Why not ask your question on the new OpenStreetMap Community Forum?


I imported the latest planet pbf file from AWS (s3://osm-pds) using osm2pgsql. It finished successfully, but the line and polygon tables are empty. I'm using a custom style and lua transform script, but I've done the same thing in the past and it's worked fine.

From what I've found it sounds like this can happen if the nodes/ways/rels aren't ordered correctly in the planet file. However I don't think Amazon is rearranging the data in their pbf...?

So two questions:

  1. What could've caused this?
  2. Is there a way I can salvage the data I've imported without reimporting?



asked 07 Aug '19, 23:52

skmoore's gravatar image

accept rate: 0%

Can you share the last few lines of output when osm2pgsql ran? Are you sure it completed successfully?

(08 Aug '19, 09:05) Frederik Ramm ♦

NOTICE: Self-intersection at or near point -8947023.3594009988 2985562.7520912946 NOTICE: Self-intersection at or near point 7148486.4317922518 7047035.3777957428 Copying planet_osm_point to cluster by geometry finished Creating geometry index on planet_osm_point NOTICE: Self-intersection at or near point 14317693.027572632 8695223.7255895436 Copying planet_osm_roads to cluster by geometry finished Creating geometry index on planet_osm_roads NOTICE: Self-intersection at or near point 6506904.3278176021 5395859.9191456046 NOTICE: Self-intersection at or near point 4729261.1576032471 7937547.0538152577 Creating osm_id index on planet_osm_roads Creating osm_id index on planet_osm_point

Osm2pgsql took 472546s overall

(08 Aug '19, 17:15) skmoore

I imported again using a planet file from planet.openstreetmap.org, having the same problem. I checked the osm2pgsql syntax I'm using and I don't see any issues. Any ideas...?

(17 Aug '19, 01:19) skmoore

I ran a test importing a Central America pbf from Geofabrik, used the same style and transform and the same osm2pgsql syntax, this worked fine.

Has something changed with the planet files available at planet.openstreetmap.org?

(20 Aug '19, 20:00) skmoore
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 07 Aug '19, 23:52

question was seen: 991 times

last updated: 20 Aug '19, 20:00

powered by OSQA