[postgis-users] match line with road segment

searchelite searchelite at gmail.com
Wed Jul 23 00:39:05 PDT 2008

Paragon Corporation-2 wrote:
> Are you just looking to get back the portions of the line segments with
> the
> line segment id of the line segments that intersect your road.
> If so, then now that you have your single line, you can splice it with the
> road segments by doing
> SELECT r.gid As road_gid, t.tripid, ST_Intersection(r.the_geom,
> triproute.the_geom) As road_segment
>  FROM roads r INNER JOIN triproute t ON ST_Intersects(r.the_geom,
> triproute.the_geom)
> The only problem with the above is that it will splice your trip into the
> various road segments making it up, but then you loose the time path that
> make line gave you.  
> It may not matter depending on what you are doing though.
> If you want to still maintain a sense of time and splice such that you
> have
> something like
> Timestart, trip_id, trip_road_segment, road_gid
> Then that's a tad bit trickier and requires you do this after you do the
> snap points.
> Hope that helps,
> Regina 

thanks for the idea regina, it's almost what i want to..it's just that now i
don't have a connected route..my purpose is to match the route line with a
road segment. From the illustration that i gave, i have to connect the two
point between the intersection with the intersection so i have a route match
with a road. I have the end_point and start_point in every road segment. any
idea how to do that? 

Thank you, sorry for the rough explanation, i hope you can understand my
View this message in context: http://www.nabble.com/match-line-with-road-segment-tp18479996p18605499.html
Sent from the PostGIS - User mailing list archive at Nabble.com.

More information about the postgis-users mailing list