[pgrouting-users] Re: [mapserver-users] OpenStreetMap + osm2pgsql = pgRouting

Stephen Woodbridge woodbri at swoodbridge.com
Mon May 17 21:05:07 EDT 2010


Subscribe to this list and post it here:
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

roshni.spain wrote:
> Hi all,
> First of all, my apologies for placing this post abour pgRouting in this
> post, but i sincerely did not find any other appropriate forum to post this
> issue. 
> 
> Well, the scenario is the following:
> 
> I have got OSM data that has been inserted into PostGIS using osm2pgsql. I
> have used MapServer to interact with my map through OpenLayers and this
> works perfectly fine. 
> 
> On the other side, I need to use pgRouting to use the algoritms of
> shortest_path or dijkstra to find a route between A and B and show it with
> OpenLayers. I have managed to do this with OpenLayers, so i know that if the
> algorithms return any result, the calculated rout shows properly in my
> browser. BUT, my problem is that in most of the cases, my algoritms do not
> return any result... lets say maybe 80-90% of the times there is no route
> calculated. What can i do ??
> 
> My geom table has got the values x1,y1,x2,y2,source,target filled for all
> the rows. 
> 
> The columns source and target are filled using this:
> SELECT assign_vertex_id('planet_osm_line', 5, 'the_geom', 'gid');   
> 
> As for the columns x1,y1,x2,y2, these are filled using this:
> SELECT astext(StartPoint(way)) as startpoint from planet_osm_line => used to
> fill up x1, y1
> SELECT astext(EndPoint(way))as endpoint from planet_osm_line => used to fill
> up x2, y2
> 
> I really dont know where the problem could be, as all the rows are filled up
> and the data seem correct...
> 
> Please help !!! 
> Thank you !



More information about the Pgrouting-users mailing list