[Tile-serving] [openstreetmap/osm2pgsql] many duplicate lines from relations (#772)
gruzk
notifications at github.com
Tue Jul 18 05:54:08 UTC 2017
It seems some relations are processed into duplicate lines. On a full planet import I have around 237 thousand duplicates (all with osm_id negative). My style file is unmodified. I am using osm2pgsql release version 0.92.1 with the typical command line as follows...
osm2pgsql -d <db> -C 34000 --cache-strategy optimized --number-processes 6 --multi-geometry --hstore -U <user> -c --flat-nodes nodes.tmp --slim --unlogged -S openstreetmap-carto.style -E 3395 -H xxx -W planet-160912.osm.pbf
Duplicates are identified by counting the number of features with the same osm_id and way, and for which the count is greater than one. Polygons and points do not contain any duplicates, only line and roads.
The worst example is a 700+km line "Asian Highway AH12" with osm_id -229600. It has 132 duplicates on one particular section. This is also by far the worst relation which, summing all duplicates, has over 120 thousand duplicated sections.
Currently I am removing the duplicates in postgresql with some SQL scripts after import, but it would be preferable not to have these duplicates created in the first place. Is there a fix for osm2pgsql?
--
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/772
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20170718/935dd275/attachment.html>
More information about the Tile-serving
mailing list