[postgis-users] match line with road segment

searchelite searchelite at gmail.com
Thu Jul 17 02:33:54 PDT 2008

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


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.

More information about the postgis-users mailing list