I have GPS locations with date. These are points.
I want to convert the points to lines, sorted by date.
SELECT observations.id, ST_MakeLine(observations.geom ORDER BY observations.date) AS newgeom FROM observations GROUP BY observations.id ;
The problem is that the single line values gives the same coordinates. So, there will be no line. 0 and 1 are the same.
How is this possible?