NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

So as adviced, I merged several files with osmium, to update the whole database together, instead of doing --append, and after I tried to import the resulting file into the database, I got this error:

Processing: Node(1255048k 1457.7k/s) Way(156069k 11.50k/s) Relation(0 0.00/s)result COPY END for planet_osm_ways failed: ERROR: duplicate key value violates unique constraint "planet_osm_ways_pkey" DETAIL: Key (id)=(23535867) already exists. CONTEXT: COPY planet_osm_ways, line 119375 DB copy thread failed: Ending COPY mode

It appears that osmium can't handle overlapping nodes. The worst part of this is that I had to wait 4 hours to discover this.

The question is, how to merge several pbf files so that overlapping tiles are correctly handled? So that I can finally load the map?

AND WHY RUSSIA IN THE COMPLETE ASIA MAPS IS MISSING HALF ITS TERRITORY (THOUGH IF YOU OPOEN ASIA LISTING ALL ITS TERRITORY IS SHOWED AS BEING INCLUDED)?

P.S. @(6 mins ago)SK53

I have no doubt that there must be some magical incantation to make osmosis work. Like in all things.

It's just that a straightforward "osmium merge ./asia-latest.osm.pbf ./northwestern-fed-district-latest.osm.pbf ./central-fed-district-latest.osm.pbf -o merged.pbf" yielded and invalid result.

The whole point of question is to find somebody knowledgable enough to identify the issue. It sucks though that people got so sensitive, like it is not the internet anymore.

asked 05 Mar '20, 07:57

kartman1's gravatar image

kartman1
386711
accept rate: 0%

edited 05 Mar '20, 11:56

Yeah, nice minuses. Good thing you can just crap on somebody and walk away feeling smart.+ Guess you are too chicken to at least show your name.

(05 Mar '20, 09:03) kartman1
3

People here are helpful but they're not going to help someone who keeps shouting and yelling. If you can ask your questions calmly and without pejorative language like "the worst part is", then you're more likely to get answers and not downvotes.

(05 Mar '20, 10:17) Richard ♦
3

I can only advise re-evaluating the attitude which you are expressing in your text. I think you have been hinted this before in one of your previous questions. If you like people taking their time for you and getting serious responses it does not help to shout (text in capitals), demand, use words like wtf and OMG, or make totally unrelated and accusing comments to other peoples' questions. There are a lot of folks here who are eager to help and promote the use of OSM but they are doing that for their own good and in their spare time. Stick to the rules/etiquette and you get helped.

And btw: nobody is hiding anything. You can see the votes in your profile.

(05 Mar '20, 10:25) TZorn
2

@kartman1 : your general tone is not suitable for this forum. Consider that osmosis has been in use for well over a decade for this very purpose: it just might be you that are in error not the programme.

(05 Mar '20, 11:41) SK53 ♦

(to second what SK53 said earlier about osmosis) https://github.com/SomeoneElseOSM/SomeoneElse-style/blob/master/update_render.sh is the script that I use to load data for https://map.atownsend.org.uk/ and similar sites. I've just tested that it doesn't have a problem by using it to load both ends of the ferry route that ends at https://www.openstreetmap.org/node/4342493001 together. That node is in both files, and no error occurs/

(05 Mar '20, 23:05) SomeoneElse ♦

The question has been closed for the following reason "Too subjective and argumentative" by SK53 05 Mar '20, 11:42

Follow this question

By Email:

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

By RSS:

Answers

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:

×293
×263
×41
×38

question asked: 05 Mar '20, 07:57

question was seen: 1,831 times

last updated: 05 Mar '20, 23:05

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum