Internationale Admingrenzen 2017

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

Moin,

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

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

32 Missings und zwei kritische Grenzen.

Gruss
walter

As every year since the import of the municipality borders in Switzerland there will be a number of changes on the upcoming January 1st, see https://wiki.openstreetmap.org/wiki/Switzerland/2018_Municipality_Mergers

We tend to be finished within the day (the exception being last year when we didn’t realize that there had been a last minute change), but there are no guarantees.

Auf die Idee, mit start_date und end_date zu arbeiten, seid ihr natürlich nicht gekommen. Nun denn, selbst gemachter Stress am Neujahrstag hat ja auch was.

https://forum.openstreetmap.org/viewtopic.php?pid=676028#p676028

Gruss
walter