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:

"geometry_columns" "nodes"
"spatial_ref_sys" "types"
"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

1 Answer

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
The tutorial is deprecated and not part of the official web page anymore. –  Carsten Aug 10 '12 at 11:58
Have a look into the pdf on page 9 chapter 4.5. –  Carsten Aug 11 '12 at 9:41
show 1 more comment

Your Answer


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.