I have a table of points at a Postgres database that have two main columns (geom geometry, time timestamp).
I need a query to retrieve as linestrings or as array of the geometries the points that are close to each other by 1 m aprox and follow the sequence of time.
The points table:
Within this set of points, how can i get in a query those two sequences of points as two different linestrings? Also excluding points that are isolated.
Assuming that this is a particular case within millions like those two cases, which would be the more efficient way to find all the linestrings?