Questions tagged [st-makeline]

A function that forms a line from a set of points (or other geometries).

Filter by
Sorted by
Tagged with
2
votes
1answer
45 views

PostgreSQL create line from points

How do i create a linestring from points sort by date in PostgreSQL? I tried: SELECT observations.id, ST_MakeLine(observations.geom ORDER BY observations.date) AS newgeom FROM observations ...
1
vote
0answers
22 views

PostgreSQL points to line error [duplicate]

I have GPS locations with date. These are points. I want to convert the points to lines, sorted by date. Using PostgreSQL Tried: SELECT observations.id, ST_MakeLine(observations.geom ORDER ...
2
votes
2answers
96 views

PostGIS MakeLine issue

I am using GPS coordinates and I am trying to create lines (routes) from lon,lat. I create a geography column from my point and then I create the line as following: ST_MakeLine(point_geom order by ...
3
votes
1answer
75 views

Displaying lines in QGIS from ST_MakeLine() not working with UPDATE, but works with CREATE TABLE

When using UPDATE to create geometries based on the SCHNUM (school number) of students to their attend school, not all the lines show up in QGIS. However, when the basic query result is written to a ...