[postgis-users] match line with road segment
lr at pcorp.us
Thu Jul 17 02:55:18 PDT 2008
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.
Sounds similar to what you are trying to do.
Hope that helps,
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Sent: Thursday, July 17, 2008 5:34 AM
To: postgis-users at 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));
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:
Sent from the PostGIS - User mailing list archive at Nabble.com.
postgis-users mailing list
postgis-users at postgis.refractions.net
More information about the postgis-users