data (#23) - Shortest Route Search Not Working (#373) - Message List

Hello,

I am trying to have routing working for city of Toronto data. But,nothing shows up and a problem is seen in the FindNearestEdge?() method.

One example request sent to the routing php is as follows: routing.php?startpoint=-8837720.7293944 5412947.799546&finalpoint=-8836963.525083 5412307.6394342&method=SPD&srid=900913

My understanding is that projection for the pgRouting database is 4326 and for the tiles displayed in OpenLayers? it is 900913. (In the code both the html and php projection values are set to 900913. However I am clear as to how to make the projection changes -- whether modify the pgRouting database or change OpenLayers? HTML page).

Further details are below

- The tiles were rendered through generate_tiles.py script of postgis database for Toronto routes. I found Ontario.osm and then extracted city of Toronto osm data and created the pgRouting database. Now my map displayed the tiles correctly in 900913 projection.

- I am not sure but maybe the pgRouting database is 4326 projection, because for A* the x1,y1... are shown in latlng. ...?

The HTML page is very similar to: http://pgrouting.postlbs.org/wiki/Workshop-RoutingRequest Except that instead of 54004 projection, I use 9000913 projection.

The php page is same as http://pgrouting.postlbs.org/wiki/Workshop-ClosestEdge Again I have set projection to 900913 here.

Code snippet:

...

$sql = "SELECT gid, source, target, the_geom,astext(the_geom),

distance(the_geom, GeometryFromText?(

'POINT(".$lonlat[0]." ".$lonlat[1].")', 900913)) AS dist

FROM ".TABLE." WHERE the_geom && setsrid(

'BOX3D(".($lonlat[0]-200)."

".($lonlat[1]-200).", ".($lonlat[0]+200)." ".($lonlat[1]+200).")'::box3d, 900913)

ORDER BY dist LIMIT 1";

...

The problem is when I php script runs, findNearestEdge() method doesn't work and one warning as followed shown:

PHP Warning: pg_fetch_result(): Unable to jump to row 0 on PostgreSQL result index 3 ...

I am not sure of the problem. Please if you have ideas let me know.