while working with POSTGIS pgrouting, for calculateing the distance between two roads(lines) i got the shortest_path function.
But the logic is based on Start_point(Start_id) and end_point(end_id) but in my data the linestring contains so many internal points like ('linestring(1 1,2 2,3 3,4 4,5 5)' just for example..)
it is taking start point (1 1) endpoint(5 5)
if other line starting with (5 5) it is showing as route...like ('linestring(5 5,6 6)')
But line which crossing the point inside the linestring like(2 2,3 3,4 4) which is not telling as connected.. example
table roads: id name way 1 A linestring(1 1,2 2,3 3,4 4,5 5) 2 B linestring(5 5,6 6) 3 c linestring(2 1,2 2,2 3)
if i am applying shortest_path function from point(1 1) to (6 6) its showing the way but for (1 1) to (2 3) it is not showing anything...but there is a route for this (1 1,2 2,2 3)
can anyone please help me out for finding the solution..
Regards Deepak M