Hello, I have 3 columns in my table, with data as
Latitude Longitude Utc_time 56.6474065 12.8533945 132733 56.647401 12.8534145 132733 56.6473953333 12.8534343333 132733 56.6473893333 12.8534556667 132733 56.6473006667 12.8537761667 132737 56.647293 12.8538066667 132737 56.6472853333 12.8538373333 132737 I want to create a Geography linestring/multiline column of latitude/longitude values where time is same for eg. time of first 4 rows is same, hence a line should be created between 1st row and 4th row. any idea how can i do this, and a proper syntax is requested , since i am very new in creating a spatial table.
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
