Internationale Admingrenzen 2017

Just an idea: Although Nominatim correctly determines address tags for Curaçao as CW, it still favours the higher ranked “Koninkrijk der Nederlanden” relation for ISO code and country display. Same for the other members of that relation.

I wonder:

Should relation # 2323309 (named ‘Nederland’) (admin level 2) not be labelled ‘Koninkrijk der Nederlanden’ indeed ? It is currently just named ‘Nederland’ but it seems to include Curacao, Aruba and St. Maarten (all admin level 3). After all, there is an IMHO correct relation for ‘Nederland’ (consisting of Europe mainland Nederland plus correctly Bonaire, Saba and St. Eustatius) being # 47796.

Whether that helps the postal code problem is another question…

sincerely yours,

Marcel.

Moin,

hier die aktuelle Missing Boundaries-Auswertung: https://wambachers-osm.website/index.php/10-osm-reports/1101-countries-compare-2017-12-06

Der Datenstand ist vom 2017-12-05 23:03:02+01

42 Missings und eine kritische Grenze.

Gruss
walter

Yes, really strange:


               key               |              value               |              value               
---------------------------------+----------------------------------+----------------------------------
 admin_level                     | 2                                | 3
 alt_name:cs                     | Nizozemí                         | 
 boundary                        | administrative                   | administrative
 currency                        |                                  | EUR
 description                     |                                  | Kingdom of the Netherlands, cons
 flag                            | http://upload.wikimedia.org/wiki | 
 int_name                        | Nederland                        | Nederland
 ISO3166-1                       | NL                               | 
 ISO3166-1:alpha2                | NL                               | 
 ISO3166-1:alpha3                | NLD                              | 
 ISO3166-1:numeric               | 528                              | 
 name                            | Nederland                        | Nederland
 name:ace                        | Blanda                           | 
 name:af                         | Nederland                        | 
 name:als                        | Niederlande                      | 
 name:am                         | ሆላንድ                             | 
 name:an                         | Países Baixos                    | 
 name:ang                        | Niðerland                        | 
 name:ar                         | هولندا                           | 
 name:arc                        | ܗܘܠܢܕܐ                           | 
 name:arz                        | نيديرلاند                        | 
 name:ast                        | Países Baxos                     | Países Baxos
 name:ay                         | Aynacha Jach'a Markanaka         | 
 name:az                         | Niderland                        | 
 name:ba                         | Нидерландтар                     | 
 name:bar                        | Holland                          | 
 name:bat-smg                    | Nīderlandā                       | 
 name:bcl                        | Nederlands                       | 
 name:be                         | Нідэрланды                       | 
 name:be-tarask                  | Нідэрлянды                       | 
 name:bg                         | Нидерландия                      | 
 name:bh                         | एम्सटर्डम                          | 
 name:bi                         | Netherlands                      | 
 name:bn                         | নেদারল্যান্ডস                      | 
 name:bo                         | ཧོ་ལན།                            | 
 name:bpy                        | নেদারল্যান্ড                       | 
 name:br                         | Izelvroioù                       | 
 name:bs                         | Holandija                        | 
 name:bug                        | Belanda                          | 
 name:bxr                        | Нидерланд                        | 
 name:ca                         | Països Baixos                    | Països Baixos
 name:cdo                        | Hò̤-làng                          | 
 name:ce                         | Нидерландаш                      | 
 name:ceb                        | Olanda                           | 
 name:chr                        | ᏁᏛᎳᏂ                             | 
 name:ckb                        | ھۆلەند                           | 
 name:co                         | Paesi Bassi                      | 
 name:crh                        | Felemenk                         | 
 name:cs                         | Nizozemsko                       | Nizozemsko
 name:csb                        | Néderlandzkô                     | 
 name:cu                         | Нидєрландꙑ                       | 
 name:cv                         | Нидерландсем                     | 
 name:cy                         | Yr Iseldiroedd                   | 
 name:da                         | Holland                          | Nederlandene
 name:de                         | Niederlande                      | Niederlande
 name:diq                        | Hollanda                         | 
 name:dsb                        | Nižozemska                       | 
 name:dv                         | ނެދަލޭންޑު                            | 
 name:dz                         | ནེ་དར་ལེནཌསི་                       | 
 name:ee                         | Netherlands                      | 
 name:el                         | Κάτω Χώρες                       | Ολλανδία
 name:en                         | The Netherlands                  | Netherlands
 name:eo                         | Nederlando                       | Nederlando
 name:es                         | Países Bajos                     | Países Bajos
 name:et                         | Holland                          | 
 name:eu                         | Herbehereak                      | 
 name:ext                        | Paisis Baxus                     | 
 name:fa                         | هلند                             | 
 name:ff                         | Holannda                         | 
 name:fi                         | Alankomaat                       | 
 name:fiu-vro                    | Holland                          | 
 name:fo                         | Niðurlond                        | 
 name:fr                         | Pays-Bas                         | Pays-Bas
 name:frp                        | Payis-Bâs                        | 
 name:frr                        | Nederlönje                       | 
 name:fur                        | Paîs Bas                         | 
 name:fy                         | Nederlân                         | Nederlân
 name:ga                         | An Ísiltír                       | 
 name:gag                        | Niderland                        | 
 name:gan                        | 荷蘭                             | 
 name:gd                         | Na Tìrean Ìsle                   | 
 name:gl                         | Países Baixos                    | 
 name:gn                         | Holanda                          | 
 name:gu                         | નેધરલેંડ                            | 
 name:gv                         | Yn Çheer Injil                   | 
 name:hak                        | Hò-làn                           | 
 name:haw                        | Hōlani                           | 
 name:he                         | הולנד                            | 
 name:hi                         | नीदरलैण्ड                          | 
 name:hif                        | The Netherlands                  | 
 name:hr                         | Nizozemska                       | Nizozemska
 name:hsb                        | Nižozemska                       | Nižozemska
 name:ht                         | Peyiba                           | 
 name:hu                         | Hollandia                        | 
 name:hy                         | Նիդերլանդներ                     | 
 name:ia                         | Pais Basse                       | 
 name:id                         | Belanda                          | 
 name:ie                         | Nederland                        | 
 name:ilo                        | Olánda                           | 
 name:io                         | Nederlando                       | Nederlando
 name:is                         | Holland                          | 
 name:it                         | Paesi Bassi                      | Paesi Bassi
 name:ja                         | オランダ                         | 
 name:jbo                        | nederland                        | 
 name:jv                         | Walanda                          | 
 name:ka                         | ნიდერლანდი                       | 
 name:kaa                        | Niderlandiya                     | 
 name:kbd                        | Нидерлэндхэр                     | 
 name:kg                         | Pays-Bas                         | 
 name:kk                         | Нидерланд                        | 
 name:kl                         | Hollandi                         | 
 name:kn                         | ನೆದರ್ಲ್ಯಾಂಡ್ಸ್                        | 
 name:ko                         | 네덜란드                         | 
 name:koi                        | Недерланд                        | 
 name:krc                        | Нидерландла                      | 
 name:ksh                        | Niederlande                      | 
 name:ku                         | Holenda                          | 
 name:kv                         | Нидерландъяс                     | 
 name:kw                         | Iseldiryow                       | 
 name:ky                         | Нидерландтар                     | 
 name:la                         | Nederlandia                      | 
 name:lad                        | Payises Bashos                   | 
 name:lb                         | Holland                          | 
 name:lez                        | Нидерландар                      | 
 name:li                         | Nederland                        | 
 name:lij                        | Paixi Basci                      | 
 name:lmo                        | Paes Bass                        | 
 name:ln                         | Holanda                          | 
 name:lt                         | Nyderlandai                      | Nyderlandai
 name:ltg                        | Nīderlandeja                     | 
 name:lv                         | Nīderlande                       | 
 name:map-bms                    | Landa                            | 
 name:mdf                        | Недерлантт                       | 
 name:mhr                        | Нидерланде                       | 
 name:mi                         | Hōrana                           | Hōrana
 name:min                        | Balando                          | 
 name:mk                         | Холандија                        | 
 name:ml                         | നെതർലന്റ്സ്                         | 
 name:mn                         | Нидерланд                        | 
 name:mr                         | नेदरलँड्स                           | 
 name:ms                         | Belanda                          | 
 name:mt                         | Pajjiżi l-Baxxi                  | 
 name:my                         | နယ်သာလန်နိုင်ငံ                     | 
 name:mzn                        | هلند                             | 
 name:na                         | Eben Eyong                       | 
 name:nah                        | Tlanitlālpan                     | 
 name:nap                        | Ulanna                           | 
 name:nds                        | Nedderlannen                     | Nedderlannen
 name:nds-nl                     | Nederlaand                       | 
 name:ne                         | नेदरल्याण्ड्स                        | 
 name:new                        | नेदरल्यान्द्स्                        | 
 name:nl                         | Nederland                        | Nederland
 name:nn                         | Nederland                        | 
 name:no                         | Nederland                        | 
 name:nov                        | Nederlande                       | 
 name:nrm                        | Pays Bas                         | 
 name:nv                         | Kéyah Wóyahgo Siʼánígíí          | 
 name:oc                         | Païses Basses                    | 
 name:os                         | Нидерландтæ                      | 
 name:pa                         | ਨੀਦਰਲੈਂਡ                           | 
 name:pam                        | Paises Bahes                     | 
 name:pap                        | Hulanda                          | 
 name:pcd                        | Bas-Païs                         | 
 name:pdc                        | Holland                          | 
 name:pih                        | Dem Nethiland                    | 
 name:pl                         | Królestwo Niderlandów            | Holandia
 name:pms                        | Pais Bass                        | 
 name:pnb                        | نیدرلینڈز                        | 
 name:pnt                        | Ολλανδία                         | 
 name:ps                         | هالنډ                            | 
 name:pt                         | Países Baixos                    | Países Baixos
 name:qu                         | Urasuyu                          | 
 name:rm                         | Pajais Bass                      | 
 name:rmy                        | Olanda                           | 
 name:ro                         | Țările de Jos                    | 
 name:roa-tara                   | Pajèsere Vasce                   | 
 name:ru                         | Нидерланды                       | Нидерланды
 name:rue                        | Нідерланды                       | 
 name:rw                         | Ubuholandi                       | 
 name:sa                         | नेदरलैंड्स                           | 
 name:sah                        | Недерланд                        | 
 name:sc                         | Logos Bascios                    | 
 name:scn                        | Paisi Vasci                      | 
 name:sco                        | Netherlands                      | 
 name:se                         | Vuolleeatnamat                   | 
 name:sh                         | Holandija                        | 
 name:si                         | නෙදර්ලන්තය                         | 
 name:simple                     | Netherlands                      | 
 name:sk                         | Holandsko                        | 
 name:sl                         | Nizozemska                       | 
 name:so                         | Holland                          | 
 name:sq                         | Holanda                          | 
 name:sr                         | Холандија                        | Холандија
 name:srn                        | Bakrakondre                      | 
 name:ss                         | IDashi                           | 
 name:st                         | Hôlanê                           | 
 name:stq                        | Niederlounde                     | 
 name:su                         | Walanda                          | 
 name:sv                         | Nederländerna                    | Nederländerna
 name:sw                         | Uholanzi                         | 
 name:szl                        | Ńiderlandy                       | 
 name:ta                         | நெதர்லாந்து                        | நெதர்லாந்து
 name:te                         | నెదర్లాండ్                           | 
 name:tet                        | Olanda                           | 
 name:tg                         | Нидерланд                        | 
 name:th                         | ประเทศเนเธอร์แลนด์                 | 
 name:tk                         | Niderlandlar                     | 
 name:tl                         | Olanda                           | 
 name:to                         | Holani                           | 
 name:tpi                        | Ol Nitelan                       | 
 name:tr                         | Hollanda                         | 
 name:tt                         | Нидерландлар                     | 
 name:tzl                        | Päts-Bäts                        | Päts-Bäts
 name:udm                        | Нидерланд                        | 
 name:ug                         | گوللاندىيە                       | 
 name:uk                         | Нідерланди                       | Нідерланди
 name:ur                         | ہالینڈ                           | 
 name:uz                         | Niderlandlar                     | 
 name:vec                        | Paéxi Basi                       | 
 name:vep                        | Alamad                           | 
 name:vi                         | Hà Lan                           | 
 name:vls                        | Holland                          | 
 name:vo                         | Nedän                            | Nedän
 name:wa                         | Bas Payis                        | 
 name:war                        | Nederlandes                      | 
 name:wo                         | Olaand                           | 
 name:wuu                        | 尼德兰                           | 
 name:xal                        | Недерлендин Нутг                 | 
 name:xh                         | ENetherlands                     | 
 name:xmf                        | ნიდერლანდი                       | 
 name:yi                         | האלאנד                           | 
 name:yo                         | Nẹ́dálándì                        | 
 name:zea                        | Nederland                        | 
 name:zh                         | 荷蘭                             | 
 name:zh-classical               | 荷蘭                             | 
 name:zh-min-nan                 | Hô-lân-kok                       | 
 name:zh-yue                     | 荷蘭                             | 
 name:zu                         | Netherlands                      | 
 note                            | This is the whole kingdom. See s | 
 official_name                   | Koninkrijk der Nederlanden       | 
 official_name:ca                | Regne dels Països Baixos         | 
 official_name:cs                | Nizozemské království            | 
 official_name:de                | Königreich der Niederlande       | 
 official_name:el                | Βασίλειο των Κάτω Χωρών          | 
 official_name:en                | Kingdom of the Netherlands       | 
 official_name:eo                | Reĝlando Nederlando              | 
 official_name:es                | Reino de Los Paises Bajos        | 
 official_name:fi                | Alankomaiden kuningaskunta       | 
 official_name:fr                | Royaume des Pays-Bas             | 
 official_name:nds               | Königriek vun de Nedderlannen    | 
 official_name:nl                | Koninkrijk der Nederlanden       | 
 old_name:cs                     | Holandsko                        | 
 population                      |                                  | 17000000
 timezone                        |                                  | Europe/Amsterdam
 TMC:cid_58:tabcd_1:Class        |                                  | Are
 TMC:cid_58:tabcd_1:LCLversion   |                                  | 8.00
 TMC:cid_58:tabcd_1:LocationCode |                                  | 4
 wikidata                        | Q29999                           | Q55
 wikipedia                       | nl:Koninkrijk der Nederlanden    | nl:Nederland
(259 Zeilen)

That can’t be true. i agree that the AL2 relation should be modified to be more specific.

Regards
walter

Even stranger:

Do I see here that Admin Level 3 has a description of ‘Kingdom of the Netherlands, cons’ - what does the ‘cons’ -part mean ?
It looks like ‘Kingdom of the Netherlands’ should be level 2, and ‘the Netherlands’ level 3.
Likewise int_name ‘Koninkrijk der Nederlanden’ on level 2, ‘Nederland’ on level 3.
And additionally I wonder whether the quoted ISO-3166 -codes should not be put on level 3 instead of level 2.
Most name:xxx descriptions currently under level 2 should also be level 3, I fear … (and on some of them, like the DAnish ‘Holland’ for level 2 vs. ‘Nederland’ for level 3 I have serious doubts).

Oh boy, my country seems really messed up.

Marcel.

Are you able - and willing to change some of them? Starting with some names? and ignoring the translations at first?
i think, its better a local mapper will do that.

walter

no, they are looking ok to me. ISO-3166-1 is for countries. But level 3 needs additional ISO-Codes ISO3166-2, i think. i’ll check that at the ISO webpage.

walter

see https://www.iso.org/obp/ui/#iso:code:3166:NL

edit: seems, there are NO AL3 in the netherlands anyhow :frowning:

One of the basic issues here is the question: ‘What is a country ?’. The UN (or at least it’s statistical department) defines it differently as others. The UN wants a country in principle to have a permanent representation at the UN. ISO is more relaxed and pragmatical. However, in the Kingdom of the Netherlands (the level 2 thus) there are 4 separate countries (on level 3 thus) where 1 of these takes care of all foreign business on behalf of all 4. That makes Aruba, Curacao and St. Maarten not really totally a country according to UN norms, with the result that those 3 have both a separate 3166 code (like ‘AW’ for Aruba) AND a (another) 3166-2 code, like ‘NL-AW’. Confused ? You would be right.
Sag mal: would this be causing the postal code problems ?

That Bonaire, Saba and St. Eustatius as sub-entity of Nederland have a common separate country code ‘BQ’ is not logical at all - certainly not from UN point-of-view. But they may have been needed for another reason: those islands have the USD as official currency, and otherwise (being level 2 -labelled as ‘NL’) a lot of computer systems might have assumed they would use EUR which could cause issues in banking and payment systems (this is a true story, actually).

I’m fully willing to clean-up my country (administratively); but only after consulting the NL user forum.

off to cooking now !

Marcel.

Time for the oldie but goldie: https://www.youtube.com/watch?v=4AivEQmfPpk

Moin,

hier die aktuelle Missing Boundaries-Auswertung: https://wambachers-osm.website/index.php/10-osm-reports/1102-countries-compare-2017-12-07

Der Datenstand ist vom 2017-12-06 23:03:02+01

32 Missings und zwei kritische Grenzen.

Gruss
walter

Moin,

hier die aktuelle Missing Boundaries-Auswertung: https://wambachers-osm.website/index.php/10-osm-reports/1103-countries-compare-2017-12-08

Der Datenstand ist vom 2017-12-07 23:03:02+01

32 Missings und 5 kritische Grenzen.

Gruss
walter

Moin,

hier die aktuelle Missing Boundaries-Auswertung: https://wambachers-osm.website/index.php/10-osm-reports/1104-countries-compare-2017-12-09

Der Datenstand ist vom 2017-12-08 23:02:02+01

14 Missings und eine kritische Grenze.

Gruss
walter

Moin,

hier die aktuelle Missing Boundaries-Auswertung: https://wambachers-osm.website/index.php/10-osm-reports/1105-countries-compare-2017-12-10

Der Datenstand ist vom 2017-12-09 23:03:02+01

6 Missings und keine kritische Grenze.

Gruss
walter

Moin,

hier die aktuelle Missing Boundaries-Auswertung: https://wambachers-osm.website/index.php/10-osm-reports/1106-countries-compare-2017-12-11

Der Datenstand ist vom 2017-12-10 23:03:02+01

15 Missings und 8 kritische Grenzen.

Gruss
walter

Moin,

heute mal keine Auswertung, da es kleinere technische Probleme gab.

no evaluation today because of minor technical problems.

Walter

Moin,

hier die aktuelle Missing Boundaries-Auswertung: https://wambachers-osm.website/index.php/10-osm-reports/1107-countries-compare-2017-12-13

Der Datenstand ist vom 2017-12-12 23:03:02+01

52 Missings und 7 kritische Grenzen.

Gruss
walter

Moin,

hier die aktuelle Missing Boundaries-Auswertung: https://wambachers-osm.website/index.php/10-osm-reports/1108-countries-compare-2017-12-14

Der Datenstand ist vom 2017-12-13 23:03:02+01

99 Missings und eine kritische Grenze.

Gruss
walter

Moin,

hier die aktuelle Missing Boundaries-Auswertung: https://wambachers-osm.website/index.php/10-osm-reports/1109-countries-compare-2017-12-15

Der Datenstand ist vom 2017-12-14 23:02:03+01

61 Missings und 5 kritische Grenzen.

Gruss
walter

Moin,

hier die aktuelle Missing Boundaries-Auswertung: https://wambachers-osm.website/index.php/10-osm-reports/1110-countries-compare-2017-12-16

Der Datenstand ist vom 2017-12-15 23:03:02+01

49 Missings und 4 kritische Grenzen.

Gruss
walter

Moin,

hier die aktuelle Missing Boundaries-Auswertung: https://wambachers-osm.website/index.php/10-osm-reports/1111-countries-compare-2017-12-17

Der Datenstand ist vom 2017-12-16 23:03:02+01

19 Missings und 4 kritische Grenzen.

Gruss
walter