Country border The Netherlands not loaded

aertsko commented 3 years ago

Context

After downloading the latest pbf file from The Netherlands (http://download.geofabrik.de/europe/netherlands-latest.osm.pbf) and importing it with imposm and the settings below, the country border of The Netherlands is not loaded.

tables: admin: columns:

name: osm_id type: id
name: geometry type: geometry
key: name name: name type: string
name: type type: mapping_value
key: admin_level name: admin_level type: integer mapping: boundary:
- administrative type: polygon

Also loaded as linestring, same behaviour

Expected Behavior

Country border loaded

Actual Behavior

The country border (admin_level 2) is loaded for some smaller parts, but the big one around The Netherlands is missing

Possible Fix

Steps to Reproduce

Dataset: http://download.geofabrik.de/europe/netherlands-latest.osm.pbf
Settings tables: admin: columns:
- name: osm_id type: id
- name: geometry type: geometry
- key: name name: name type: string
- name: type type: mapping_value
- key: admin_level name: admin_level type: integer mapping: boundary:
  - administrative type: polygon
Loaded without any clipping

Context

Your Environment

Version used: Latest version of imposm
Environment name and version (e.g. PostgreSQL x.y.z with PostGIS a.b.c): PostgresSQL13 with latest PostGIS
Server type and version: different linux distros tested
Operating System and version:

aertsko commented 3 years ago

https://www.openstreetmap.org/relation/2323309#map=6/51.624/10.449 This one is missing

ImreSamu commented 3 years ago

r2323309 This one is missing

imho: it is expected ; broken border relation in the geofabrik area

probably this (~Caribbean ) part is missing

https://en.wikipedia.org/wiki/Netherlands#Caribbean_islands

And Geofabrik europe-netherland part is this:

The https://www.openstreetmap.org/relation/47796 ( admin_level=3 ) has a same problem.

https://en.wikipedia.org/wiki/Oranjestad,_Aruba

proposed solutions:

a.)

download osm planet
filter to admin_level=2 with osmium tools

b.)

download osm planet
using osmium getid to filter r2323309

c.)

ask other solutions in the osm help forum: https://help.openstreetmap.org/tags/borders/

ImreSamu commented 3 years ago

Yout can test for the missing ways with the https://docs.osmcode.org/osmium/latest/osmium-check-refs.html - tools.

$ osmium check-refs -rvi netherlands-latest.osm.pbf  | grep r2323309
[ 0:00] Started osmium check-refs
[ 0:00]   osmium version 1.12.1 (v1.12.1-6-g3182275)
[ 0:00]   libosmium version 2.15.6
[ 0:00] Command line options and default settings:
[ 0:00]   input options:
[ 0:00]     file name: netherlands-latest.osm.pbf
[ 0:00]     file format: 
[ 0:00]   other options:
[ 0:00]     show ids: yes
[ 0:00]     check relations: yes
[ 0:01] Reading nodes...
[ 0:05] Reading ways...
[ 0:08] Reading relations...
w114819318 in r2323309
w82217909 in r2323309
w684830598 in r2323309
w545142126 in r2323309
w545142121 in r2323309
w690052685 in r2323309
w684830594 in r2323309
w522217513 in r2323309
w524066268 in r2323309
w524074069 in r2323309
w42939090 in r2323309
w188099376 in r2323309
w523678741 in r2323309
w188099371 in r2323309
w690052686 in r2323309
w545142113 in r2323309
w545142123 in r2323309
w82212788 in r2323309
w892528328 in r2323309
w246287543 in r2323309
w53599893 in r2323309
w892529909 in r2323309
w81100680 in r2323309
w892529910 in r2323309
r1216719 in r2323309
r1231749 in r2323309
r1231790 in r2323309
There are 113216308 nodes, 15329314 ways, and 171069 relations in this file.
Nodes     in ways      missing: 0
Nodes     in relations missing: 12422
Ways      in relations missing: 155013
Relations in relations missing: 10781
[ 0:09] Memory used for indexes: 1137 MBytes
[ 0:09] Peak memory used: 1724 MBytes
[ 0:09] Done.

d.)

not tested .. but maybe you can merge the netherlands-latest.osm.pbf with the https://download.geofabrik.de/central-america.html for the missing Caribbean data.

omniscale / imposm3