[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