Stephen Woodbridge wrote: > > You can buffer the line and see which segments fall inside the buffer. > > select * from roads > where ST_Contains(the_geom, ST_makeline(gps_points)); > > -Steve >
thank you for the reply..can you be more detail please..i've tried your suggestion but it returned no record. I create a simple illustration below.. the green line is the record from road table, and the red line is the route table generated from ST_Makeline(gps_points), I want to make the red line snap into the road so it become the route http://www.nabble.com/file/p18504794/untitled.jpg Thank you in advance -- View this message in context: http://www.nabble.com/match-line-with-road-segment-tp18479996p18504794.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
