Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

As osm2po was a more reliable way to convert an .osm I went for that solution to load my date in postgres.

In the workshop however the author points out to check the result after osm2pgrouting. The following tables must be created:

"classes"
"geometry_columns" "nodes"
"spatial_ref_sys" "types"
"vertices_tmp"
"vertices_tmp_id_seq" "ways"

After the sql (generated from osm2po) has run, only the tables "geometry_columns" and "spatial_ref_sys" are created. How do I fix this difference?
Is osm2po incomplete? Did something go wrong?

Can anyone point me in a better direction?

Thanks alot!

share|improve this question
add comment

2 Answers 2

geometry_columns and spatial_ref_sys are created and populated by PostGIS automatically in case you add a geometry column. The other tables are more or less temporary, used for finding links via assign_vertex_id. osm2po does all this segmenting-stuff for you. All you need is the resulting table which is created by osm2po. In addition osm2po does not rely on assign_vertex_id and uses the original links from osm instead.

share|improve this answer
    
Carsten is right. And there is nothing incomplete when vertices_tmp is missing either, which is a temporary table and can be deleted. While osm2po is the better import tool at the moment, it's not part of the workshop, because it's not on OSGeo Live DVD. And it's not on the LiveDVD because it's not released under Open Source license. –  dkastl Aug 9 '12 at 20:18
    
Thanks alot for this valuable info. Now I can continue without doubt, which means alot :) –  user9347 Aug 10 '12 at 8:37
    
But as I'm continuing, confusion increases too. I see in the workshop that it uses the functions of pgRouting. (e.g. shortest path) How do I continue now, knowing that there is not even a "ways" table? The osm2po tutor (osm2po.de/tutorial.php) clearly states that this is the only thing needed for pgRouting, which looks like contradiction if the ways table is not existing. –  user9347 Aug 10 '12 at 9:34
1  
The tutorial is deprecated and not part of the official web page anymore. –  Carsten Aug 10 '12 at 11:58
1  
Have a look into the pdf on page 9 chapter 4.5. –  Carsten Aug 11 '12 at 9:41
show 1 more comment

There is one more thing that no one mentioned. So the standard osm2po tables end up missing a vertex table equivalent to the vertices_temp table in osm2pgrouting. I found this table quite useful, as it has the lat/long for each osm vertex as well as its osm_id node id. You can still get this from the osm2po application, but you need to go into the actual osm2po java application and uncomment the line:

#postp.2.class = de.cm.osm2po.plugins.PgVertexWriter

If you uncomment this line, (remove the #), then rerun the osm2po application on your osm or pbf file, it will generate a new sql script with a prefix_2p_v.sql file. You can then run this like the pgr.sql file and it will add a vertex table.

share|improve this answer
add comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.