Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am trying to import an osm file using osm2pgrouting. while following the pgrouting workshop. (file is 700mb~)

im running ubuntu 12.04 on m1.large on amazon.

the same file was successfully upload to postgres with osm2pgsql.

i am using the following command:

osm2pgrouting -file "/home/ubuntu/israelmap/israel_and_palestine.osm"  -conf "/usr/share/osm2pgrouting/mapconfig.xml" -dbname routing -user postgres -clean

the proccess starts ok, but it the way table will never have any data in it:

We need a way of type highway and class service
We need a way of type highway and class service
We DON'T need a way of type  and class
We DON'T need a way of type  and class
We DON'T need a way of type  and class
Split ways
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "nodes_pkey" for table 

"nodes"
    Nodes table created
    NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "ways_pkey" for table "ways"
    Ways table created
    Types table created
    Classes table created
create topology
NOTICE:  CREATE TABLE will create implicit sequence "vertices_tmp_id_seq" for serial column "vertices_tmp.id"
CONTEXT:  SQL statement "CREATE TABLE vertices_tmp (id serial)"
PL/pgSQL function "assign_vertex_id" line 15 at EXECUTE statement
#########################
size of streets: 159747
size of splitted ways : 365597
finished

after a very long while (2 hrs) it sais finished but way table is empty! how do i fix this?

  • i was able to load a way table using osm2po. still no success with o2m2pg

Thanks for your help!

share|improve this question
i still have problems with that, anyone anything? – yaron Mar 5 at 5:54

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.