I have a
LINESTRING from a
pgRouting query. The start point and/or end poit of this line does not connect exactly the points I've clicked on the road and give me all the road segment of that edge (passing the point to next vertice) or stops in the nearest vertice (before the point).
I need to change the points to connect the line result (red lines on the images) near the points I've clicked on the map (blue circles).
My Kung-pgRouting-fu is like this tutorial http://workshop.pgrouting.org/chapters/wrapper.html#return-route-with-network-geometry (function
pgr_fromAtoB()) and is working fine.
pgr_fromAtoB() in tutorial gets the nearest roads (edges) from the points (clicked on web interface an can be arbitrary locations) and connect its vertices using
EDIT: I'm testing this info now: How to find the nearest point projected on the road network?. I think this could help me.