You may be better off snapping the points to the line first before you do a make line. Take a look at Paul's blog entry.
http://blog.cleverelephant.ca/2008/04/snapping-points-in-postgis.html Sounds similar to what you are trying to do. Hope that helps, Regina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of searchelite Sent: Thursday, July 17, 2008 5:34 AM To: postgis-users@postgis.refractions.net Subject: Re: [postgis-users] match line with road segment 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 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
