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

agentsees agentsees at gmx.net
Mon Apr 19 03:07:29 EDT 2010


Hi,

Thanks for your posting, but that doesnt help me any further.
Maybe its worth a try to downgrade to PostGIS 1.4.
I have no other ideas. Or could someone confirm that the smart Wrapper, 
or the give_we_wkt function works with newest postgresql, postgis and 
pgouting?
Thanks!


Daniel Kastl schrieb:
> Hi,
>
> I made a comment to your forum post:
> http://pgrouting.postlbs.org/discussion/topic/353#message1467
>
> Hope it helps.
> Daniel
>
>
>
> -- 
> Georepublic UG & Georepublic Japan
> eMail: daniel.kastl at georepublic.de <mailto:daniel.kastl at georepublic.de>
> Web: http://georepublic.de
>
>
>
> 2010/4/17 agentsees <agentsees at gmx.net <mailto:agentsees at gmx.net>>
>
>     Hi!
>
>     I posted this topic also on the forum and hope to get answers.
>     http://pgrouting.postlbs.org/discussion/topic/353
>
>
>     > 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:
>     >
>     > SELECT
>     >
>     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
>     <mailto:Pgrouting-users at lists.postlbs.org>
>     > http://lists.postlbs.org/mailman/listinfo/pgrouting-users
>     >
>     >
>
>     _______________________________________________
>     Pgrouting-users mailing list
>     Pgrouting-users at lists.postlbs.org
>     <mailto:Pgrouting-users at lists.postlbs.org>
>     http://lists.postlbs.org/mailman/listinfo/pgrouting-users
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.postlbs.org
> http://lists.postlbs.org/mailman/listinfo/pgrouting-users
>   

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20100419/63ee27ab/attachment.html


More information about the Pgrouting-users mailing list