Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've imported a osm layer into my postgres/postgis database.

osm2pqsql -E 3857 -c -S /usr/share/osm2pgsql/ -H localhost -W -d landslide -U postgres oberpfalz-latest.osm.bz2

During the import there were several warnings like this:

Processing: Node(3261k 69.4k/s) Way(399k 7.27k/s) Relation(80 26.67/s) Standard exception processing way_id 33907: TopologyException: side location conflict at 1396469.99 6361915.7599999998

Accept of this, I think the import runs without any problems.

After that I added planet_osm_roads to my qgis-project (EPSG:3857).

The result is shown in the picture below. I tried to change the SRIDs, but no change.

enter image description here

Any ideas what this strange exposure comes from?

share|improve this question
up vote 1 down vote accepted

A few possible reasons:

  • Your version of osm2pgsql is not ready for 64-bit-long node numbers. Try the latest version
  • Updating of the planet at Geofabrik failed before cutting into pieces. The OSM Inspector has such lines too at the moment. There is not much to do but complaining at Geofabrik.
  • You get that kind of error if boundary polygons are missing some elements. The cutting polygons of Geofabrik are sometimes a bit too close.
share|improve this answer
When I add the planet_osm_point layer everything is correct. At first I will update my osm2pgsql version. – Stefan Aug 12 '13 at 11:28
Points can not have missing elements, so you won't see the mistake. – AndreJ Aug 12 '13 at 12:19
The answer is updating osm2pgsql. Thanks a lot! – Stefan Aug 12 '13 at 14:01

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.