-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
You shoule merge the 3 files in advance and import once. IMHO the merge option
simply retains existing data but does not actually merge it.
On 31. Dezember 2014 15:45:58 MEZ, Stefan Mohr g...@nordie.de wrote:
Hi everyone,
I am relatively new to using OSM data and osm2pgsql and have been doing
some
testing during the last few weeks. I am using the following command
lines
and I am pretty not sure, if I am doing it in the right way:
osm2pgsql --verbose --create --slim --cache 4096 --prefix planet_osm
--database osmtest --username gis --host localhost --hstore
--extra-attributes --style /gis/maps/planet/style/default.style
--number-processes 4 --bbox 7.85,51.50,11.32,55.06
schleswig-holstein-latest.osm.pbf
osm2pgsql --verbose --append --slim --cache 4096 --prefix planet_osm
--database osmtest --username gis --host localhost --hstore
--extra-attributes --style /gis/maps/planet/style/default.style
--number-processes 4 --bbox 7.85,51.50,11.32,55.06
hamburg-latest.osm.pbf
osm2pgsql --verbose --append --slim --cache 4096 --prefix planet_osm
--database osmtest --username gis --host localhost --hstore
--extra-attributes --style /gis/maps/planet/style/default.style
--number-processes 4 --bbox 7.85,51.50,11.32,55.06
niedersachsen-latest.osm.pbf
The result should be a merging of 3 osm data files, the first line is
doing a good job , but during the second line there is an error:
Reading in file: hamburg-latest.osm.pbf
Processing: Node(2156k 113.5k/s) Way(405k 27.00k/s) Relation(0
0.00/s)COPY_END for COPY planet_osm_ways FROM STDIN;
failed: ERROR: duplicate key value violates unique constraint
planet_osm_ways_pkey
DETAIL: Key (id)=(3075476) already exists.
CONTEXT: COPY planet_osm_ways, line 193
I would be glad if anyone could tell me, what I have missed and what I
am
doing wring here? Thanks a lot,
Stefan
___
dev mailing list
dev@openstreetmap.org
https://lists.openstreetmap.org/listinfo/dev
- --
Written with a pen on a Galaxy Note 10. I
-BEGIN PGP SIGNATURE-
Version: APG v1.1.1
iQE6BAEBCgAkBQJUpCQ+HRxTaW1vbiBQb29sZSA8c2ltb25AcG9vbGUuY2g+AAoJ
EEchcRCS4oLq3D8IAKJ8NHic/BlEE95vcShHb5lhveqLt72VZVA3UmIvhWsPNp0U
nCtq6044Fo0yfwnPZ9P9BTmraB3PGQ3uKVoQeAMVbU96R9fczUVi+1G559/tB8nz
LgfaI3+yDMt4MVSpbpeRcyc4cx4oHuPwU/TGGv88X3SC6558PFHnNKP5RtutkdtU
ua7a3qlEYGYZuh+UhXS/ED4K8hGsbzs369aksxBuraAQzQbCvsCS54/+QZjcVxaf
uWqbLrdG4jmgm8zixlQuBj+S/Fnlk9W378cLhMRikr/0ilsTPC5/TS7nDch+iZa6
iFoA0Y+kZg7x/L8xjP7vpOXWPST7Bbi/LZjVYEw=
=RY05
-END PGP SIGNATURE-
___
dev mailing list
dev@openstreetmap.org
https://lists.openstreetmap.org/listinfo/dev