[Routing] export osm to use it in pgrouting

[Markus]

Hi all,

after trying all these three product osm2po was the only tool that was able to create the routing table with this large dataset.

thanks again for your suggestions



________________________________
Von: Markus <markusin at yahoo.de>
An: "routing at openstreetmap.org" <routing at openstreetmap.org>
Gesendet: 17:53 Mittwoch, 31.August 2011 
Betreff: Re: [Routing] export osm to use it in pgrouting






________________________________
Von: Daniel Kastl <daniel at georepublic.de>
An: routing at openstreetmap.org
Gesendet: 15:18 Dienstag, 30.August 2011 
Betreff: Re: [Routing] export osm to use it in pgrouting


osm2pgrouting has problems with large amount of data.
It depends how much memory you have available.

I am using 2 GB of memory. Not
 enough??



This could be one reason.
Can you make sure that you created a database and loaded all required functions?
You can also create a routing_template like here:
https://github.com/pgRouting/workshop/blob/master/bin/create_templates.sh

I did all what you wrote, but I obtained the same problem.


Now I tried osm4routing: launching:

Postgis output option:
osm4routing -o postgresql://postgres@localhost/routing -n italy_nodes -e italy_edges -s /opt/tmp/italy.osm

this brings an error after parsing while trying to save in the db

Csv output option:
osm4routing -o csv -n italy_nodes -e italy_edges -s /opt/tmp/italy.osm

this save the nodes in the csv file but while saving the edges I obtain:
Read 33314731 nodes and 2849260 ways

Step 2: saving the nodes
  Wrote 1750193 nodes

Step 3: saving the edges
terminate called after throwing an instance of 'std::bad_alloc'
  what():  std::bad_alloc
Aborted


it looks like that both of this tools have problems with large data.




_______________________________________________
Routing mailing list
Routing at openstreetmap.org
http://lists.openstreetmap.org/listinfo/routing
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/routing/attachments/20110901/044d2d77/attachment.html>