[pgrouting-users] osm2pgrouting import problem

[Kai Behncke]

Dear users,

I tried it as well with the Germany-osm-data (600 MB) on a pc with
4 processors, 4 GB RAM and 7GB Swap), but it failed after 14 hours.


I trief then to load in single counties (Bundesländer). Always the first one works
but after that (e.g. first one is "Hamburg", second one "Bremen") only nodes are inserted (and no ways). Is this a known error/issue.


What would you recommend to get All the data of one country in a database?

Thank you very much, Kai
-------- Original-Nachricht --------
> Datum: Mon, 29 Jun 2009 09:35:45 +0900
> Von: Daniel Kastl <kastl at orkney.co.jp>
> An: pgrouting-users at lists.postlbs.org
> Betreff: Re: [pgrouting-users] osm2pgrouting import problem

> Hi Eike,
> 
> You probably run into this issue: http://pgrouting.postlbs.org/ticket/140
> If you can try it with a smaller dataset for testing and it worked, then 
> this is the case. If it still doesn't work then please let us know.
> 
> The original author of osm2pgrouting said he's currently working on this 
> issue as time allows.
> 
> Daniel
> 
> PS: Once I tried a little larger dataset I just increased my SWAP 
> partition and it worked then, but I don't know how large the German data 
> is. It's not a nice solution anyway.
> 
> 
> 
> Eike Lüders schrieb:
> > Hello everybody!
> >
> > I've got a problem with osm2pgrouting.
> > I downloaded the osm file for germany from here: 
> > http://download.geofabrik.de/osm/europe/germany.osm.bz2
> > If I try to run osm2pgrouting on it now by typing
> >
> > ./osm2pgrouting -file germany.osm -conf mapconfig.xml -dbname routing 
> > -user postgres -passwd postgres -clean
> >
> > into the shell it gives me the following information, but nothing 
> > happes (the db information above are correct!).
> >
> > There is no error message or something like that.
> >
> > I hope anybody know how to solve this problem.
> >
> > host=127.0.0.1 user=postgres dbname=routing port=5432 password=postgres
> > connection success
> > Trying to load config file mapconfig.xml
> > Trying to parse config
> > SE for <configuration>
> > SE for <type>
> > SE for <class>
> > class name = motorway
> > class id = 101
> > class id = 101 name = motorway added to type name=highway
> > SE for <class>
> > class name = motorway_link
> > class id = 102
> > class id = 102 name = motorway_link added to type name=highway
> > SE for <class>
> > class name = motorway_junction
> > class id = 103
> > class id = 103 name = motorway_junction added to type name=highway
> > SE for <class>
> > class name = trunk
> > class id = 104
> > class id = 104 name = trunk added to type name=highway
> > SE for <class>
> > class name = trunk_link
> > class id = 105
> > class id = 105 name = trunk_link added to type name=highway
> > SE for <class>
> > class name = primary
> > class id = 106
> > class id = 106 name = primary added to type name=highway
> > SE for <class>
> > class name = primary_link
> > class id = 107
> > class id = 107 name = primary_link added to type name=highway
> > SE for <class>
> > class name = secondary
> > class id = 106
> > class id = 106 name = secondary added to type name=highway
> > SE for <class>
> > class name = tertiary
> > class id = 107
> > class id = 107 name = tertiary added to type name=highway
> > SE for <class>
> > class name = residential
> > class id = 107
> > class id = 107 name = residential added to type name=highway
> > SE for <class>
> > class name = living_street
> > class id = 108
> > class id = 108 name = living_street added to type name=highway
> > SE for <class>
> > class name = service
> > class id = 109
> > class id = 109 name = service added to type name=highway
> > SE for <class>
> > class name = track
> > class id = 110
> > class id = 110 name = track added to type name=highway
> > SE for <class>
> > class name = pedestrian
> > class id = 111
> > class id = 111 name = pedestrian added to type name=highway
> > SE for <class>
> > class name = services
> > class id = 112
> > class id = 112 name = services added to type name=highway
> > SE for <class>
> > class name = bus_guideway
> > class id = 113
> > class id = 113 name = bus_guideway added to type name=highway
> > SE for <class>
> > class name = path
> > class id = 114
> > class id = 114 name = path added to type name=highway
> > SE for <class>
> > class name = cicleway
> > class id = 115
> > class id = 115 name = cicleway added to type name=highway
> > SE for <class>
> > class name = footway
> > class id = 116
> > class id = 116 name = footway added to type name=highway
> > SE for <class>
> > class name = bridleway
> > class id = 117
> > class id = 117 name = bridleway added to type name=highway
> > SE for <class>
> > class name = byway
> > class id = 118
> > class id = 118 name = byway added to type name=highway
> > SE for <class>
> > class name = steps
> > class id = 119
> > class id = 119 name = steps added to type name=highway
> > SE for <class>
> > class name = unclassified
> > class id = 100
> > class id = 100 name = unclassified added to type name=highway
> > SE for <class>
> > class name = road
> > class id = 100
> > class id = 100 name = road added to type name=highway
> > SE for <type>
> > SE for <class>
> > class name = lane
> > class id = 201
> > class id = 201 name = lane added to type name=cycleway
> > SE for <class>
> > class name = track
> > class id = 202
> > class id = 202 name = track added to type name=cycleway
> > SE for <class>
> > class name = opposite_lane
> > class id = 203
> > class id = 203 name = opposite_lane added to type name=cycleway
> > SE for <class>
> > class name = opposite
> > class id = 204
> > class id = 204 name = opposite added to type name=cycleway
> > SE for <type>
> > SE for <class>
> > class name = grade1
> > class id = 301
> > class id = 301 name = grade1 added to type name=tracktype
> > SE for <class>
> > class name = grade2
> > class id = 302
> > class id = 302 name = grade2 added to type name=tracktype
> > SE for <class>
> > class name = grade3
> > class id = 303
> > class id = 303 name = grade3 added to type name=tracktype
> > SE for <class>
> > class name = grade4
> > class id = 304
> > class id = 304 name = grade4 added to type name=tracktype
> > SE for <class>
> > class name = grade5
> > class id = 305
> > class id = 305 name = grade5 added to type name=tracktype
> > SE for <type>
> > SE for <class>
> > class name = roundabout
> > class id = 401
> > class id = 401 name = roundabout added to type name=junction
> > Trying to load data
> > Trying to parse data
> >
> >
> > Kind regards
> > Eike Lüders
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > Pgrouting-users mailing list
> > 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

-- 
Neu: GMX Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate
für nur 19,99 Euro/mtl.!* http://portal.gmx.net/de/go/dsl02