Hi, I need a bit of advice with the st_makeline function.
We have some vehicle tracking data showing gritting activity. What we want to do is join up the points to create lines showing a travel path of what has been gritted. We can do a basic version of this but what we'd like is a seperate line for each group of events For eaxmple we have EVENT_ID Time 1 12.00 1 12:01 1 12:02 etc 1 1 2 2 2 2 1 1 What we'd like to be able to do is have it draw one line for the first event id group of 1s, then stop, draw a line for 2's, stop that line then start a new line for the next group of ones. What we have a present either jopins them all as one line, or if we just pull out aal the ones it will draw a line from the last 1 before the the two then join it to the next instance of one giving a untrue picture -- View this message in context: http://old.nabble.com/Makeline-help-tp29941457p29941457.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
