[pgrouting-users] Help with Routing from Point to Point

agentsees agentsees at gmx.net
Sat Apr 17 06:15:07 EDT 2010


I posted this topic also on the forum and hope to get answers.

> Hello!
> I am searching for a solution to route from a Point on a line to another 
> point on a line. I wonder why this hasnt been implemented yet in 
> pgrouting, because i think its (one of the) most used feature! What i 
> got till now is routing with different algorithms on Openstreetmap data 
> from and to vertices and edges. I have sucessfully calculated the 
> nearest points on the nearest edge to my start and endpoints. I tried to 
> fill the missing last part with the tutorial from here : 
> http://pgrouting.postlbs.org/wiki/LoadingtheCode5
> But i could not get it working. The function throws errors on the 
> following SQL statement:
> astext(give_we_wkt(".$startEdge['gid'].",".$ergebnis_nebengeometrie_anfang_gid.",'".
> $point_on_line_anfang."'))
> It says, that st_intersects is neither false nor true on:
> SELECT INTO p ST_intersects(line,buffer($3,1));
> I think the problem is the creation of the linestring ('line') in the 
> functioncode, because i can see errors which tell me that "||" is not an 
> allowed operator.
> The linestring itself remains empty and maybe thats why the function fails.
> Has somebody an idea how to fix this?
> Is there no other / easier solution to route from one point to another?
> Thanks for answers in adavance!
> J. Weskamm
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.postlbs.org
> http://lists.postlbs.org/mailman/listinfo/pgrouting-users

More information about the Pgrouting-users mailing list