All Questions
Tagged with postgresql line
29
questions
2
votes
1
answer
107
views
Determine area enclosed by multiple segments
I am trying to determine the area enclosed by multiple linestrings. For example, in the following picture, I have 4 linestrings, forming 2 closed polygons. I'd like to be able to get the coordinates ...
- 43
2
votes
1
answer
220
views
Count points on linestring
I have a table table_point with points that are located on linestrings (table_line). How would I count for each segement of the a linestring of table_lines the number of points that are located on it?
- 3,398
2
votes
1
answer
386
views
How to snap points to line
I am having a table lines being MULTILINESTRING (2 Dimensions) and a table points being MULTIPOINT (3 Dimensions). The two are in the same CRS.
Now, I am trying to snap all the points to the closest ...
- 3,398
1
vote
1
answer
872
views
Storing Google Maps API returned polyline in PostgreSQL (or PostGIS)
By making Google Maps API call, I received a response JSON which contained this polyline:
ezdvBcps}Lt@W@F@BVKl@UK]Wc@}@kAOKBEzA{BdA}Ab@s@LBf@RjARZBv@?rAAfBIX?f@FLBf@^b@hATbAF~@BvB?hALjBHpCLjAVdAd@...
- 163
5
votes
1
answer
141
views
Segment lines with incremental attributes - PostGIS
I have been trying to segment lines at specific interval (2000 m) using St_LineSubstring function. So far, I managed to accomplish that with the following code:
SELECT ST_LineSubstring(the_geom, 2000....
- 143
3
votes
1
answer
77
views
New line layer from point layer
PostgreSQL/QGIS/LizMap environment
I have a Postrgre DB POINT layer:
-[ RECORD 1 ]+-----------------------------------------------------------------------------------
buildingid | 1
nodeid | 2
...
- 39
4
votes
1
answer
106
views
How to count the number of 100m length chunks in a table with line geometry?
And by chunks I do not mean segments so I can't use st_segmentize for this
In other words I have a linetable which has many lines of varying length. Example:
id | st_length(geom) | intended count for ...
- 2,328
2
votes
1
answer
143
views
Calculate 500m south of coordinate in PostGIS
I have a point layer punkte_test. From that I want to make a line: first point of the line is the point A from the point layer itself. Second point of the line shall be y(B) = y(A) - 500 m . How can I ...
- 85
7
votes
2
answers
2k
views
PostGIS functions for generating centerline from polygon
I want to create a centerline from a polygon and I have tried using both ST_StraightSkeleton and ST_ApproximateMedialAxis functions in PostGIS.
It gives an error with a message
straight skeleton of ...
- 71
4
votes
2
answers
305
views
Merging two isolines into one in PostGIS
How can I sum two isolines A and B (closed linestrings with values) into one isoline C with summed values on common parts?
For each line string there is a value and I would like to sum on common part.
...
- 141
3
votes
1
answer
691
views
How to estimate time spent within a location using GPS/timestamp data in PostGIS?
I am new to PostGIS, and I am trying to estimate time spent in a location based off of interpolating time between GPS points (I am using PostgreSQL 12.2 and PostGIS 3.0).
I have GPS points stored ...
- 41
0
votes
1
answer
639
views
Lat/Long WKT field to line geometry
I'm working with data containing multiple lat/long entries within a single row. I am using PostGreSQL to process the data. Is there a way to take the WKT lat/long field and convert it into a line geom ...
- 193
1
vote
1
answer
66
views
Nearest Neighbor Two Point Tables Return Line Geometry
I am looking to find the nearest neighbor between two point tables in PostGIS and return the ids of both along with the line geometry. I have been able to determine the distance for the nearest ...
- 910
2
votes
1
answer
241
views
Splitting multilinestrings in segments using PosgreSQL
I need to split several multilinestring into a defined number of segments using PosgreSQL.
I tried using ST_subdvideand ST_segmentize but they didn't work.
Can someone help me to solve this problem?
...
- 21
0
votes
0
answers
327
views
Display arrows on each segment of a multines feature, using GeoServer and SLD
I'm using the SLD code below to display arrows along lines with GeoServer 2.10:
<Rule>
<Name>Lines</Name>
<Title>Lines</Title>
<LineSymbolizer>
<...
- 2,710