Hi Martin. ST_Line_Substring(road, ST_Line_Locate_Point(road, gps_start), ST_Line_Locate_Point(road, gps_end)) AS highlight
Gr Ralf Am Dienstag 11 Januar 2011, 17:46:06 schrieb Martin Fafard: > Ralf > > Yes, ok for the buffer. But how to "dynamically segment" my new road > from my original segment? > > Martin > > Ralf Suhr a écrit : > > Hi Martin, > > > > you will not get a correct solution for this problem. Your road network > > and the gps points differs always. > > > > A possible "solution" is building a buffer around the streets und look > > für intersection with gps points and filter by direction road/points. > > Grouping gps points can give you the start and end point for the road. > > If a road is only one times driven. > > > > Gr > > Ralf > > > > Am Dienstag 11 Januar 2011, 17:16:18 schrieb Martin Fafard: > >> Hi > >> > >> I have a network of roads (topological) and I receive GPS points. I > >> would like to create new lines who follow exactly the same path as my > >> road from the GPS points (to "highlight" where the GPS unit was on the > >> network). The problem is I need to segment the new line because the GPS > >> points can stop anywhere on my roads... Any advice to do this? > >> Thank you > >> > >> Martin F > >> _______________________________________________ > >> postgis-users mailing list > >> [email protected] > >> http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
