GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Germany  XML
Forum Index -> Administrative Divisions
Author Message
marc



Joined: 08/12/2005 07:39:47
Messages: 3993
Offline

For Germany we have the following administrative divisions :

ADM1 : 16 (Bundesland)
ADM2 : 22 (Regierungsbezirk)
ADM3 : 439 (Landkreis or Stadtkreis)
ADM4 : ca 12000 (Gemeinde)

[WWW]
geotree


[Avatar]
Joined: 23/07/2007 18:28:40
Messages: 138
Location: France
Offline

I have started french translation :

Bundesland => Etat
Regierungsbezirk => District
Landkreis => Arrondissement
Stadtkreis => Ville-arrondissement
Gemeinde => Municipalité

Any comments ?

Christophe
geotree.geonames.org
geotree.geonames.org/geotree.html
[WWW]
kurush



Joined: 11/10/2008 14:13:42
Messages: 3
Offline

Sorry if I have chosen a wrong topic for my question. I have exported GeoNames database for Germany. All administrative divisions are OK but there is no information about cities in ADM4. All PPL objects have blanks in their ADM2, ADM3, ADM4 fields so there is no way to determine in which ADM PPL object is located. I want to know if this information will be added in the future and what is the proirity of this task? Thank you in advance for answers.
marc



Joined: 08/12/2005 07:39:47
Messages: 3993
Offline

We will add the information when we get it. You are free to help finding the data.

Marc

[WWW]
charlie



Joined: 29/01/2010 20:36:48
Messages: 1
Offline

ADM1 Codes for Germany:

According to http://de.wikipedia.org/wiki/ISO_3166-2: DE
(remove the last space in the URL between the ":" and the DE)

This maps the German State Names to the correct ISO_3166-2 Codes and the old ADM1-Codes for Germany in admin1Codes.txt from your database.

Baden-Württemberg DE.BW DE.01
Bayern DE.BY DE.02
Berlin DE.BE DE.16
Brandenburg DE.BB DE.11
Bremen DE.HB DE.03
Hamburg DE.HH DE.04
Hessen DE.HE DE.05
Mecklenburg-Vorpommern DE.MV DE.12
Niedersachsen DE.NI DE.06
Nordrhein-Westfalen DE.NW DE.07
Rheinland-Pfalz DE.RP DE.08
Saarland DE.SL DE.09
Sachsen DE.SN DE.13
Sachsen-Anhalt DE.ST DE.14
Schleswig-Holstein DE.SH DE.10
Thüringen DE.TH DE.15

All you need to do is to replace the third column with the second.



Thanks Guys![/url][url]
Claude Warren



Joined: 14/06/2009 16:46:35
Messages: 8
Offline

I just spent a day or so researching this issue -- then came here and found this discussion. One of these days I'll get things in the right order.

By my calculations there are 8328 German records for which the admin level codes are incorrect. I also believe that the records to the ADM1 level are correct. At first I thought the problem was that "Landkreis" records are at the ADM3 level when they should be at ADM2 and the ADM4 under the Landkreis records should be at ADM3. But then I find that some German states use a "Regierungsbezirk" layer which really is the ADM2 that is above the "Landkreis" level. Note that not all states use this structure so for those states there is no ADM2 level. All in all the data appear to be correct. However this begs the question: Is the data modelled correctly?

Perhaps we should start a discussion about how to best model the data bases on usage. For the most part I think that, in most cases admin levels are used to start/restrict searches. So, for example, one might want to find all the lakes in Weld County, Colorado, USA and so start with that restriction. In a sense the admin records are used to traverse up and down a hierarchy.

Perhaps a structure that uses up and down pointers (a b-tree approach for the technically minded) might be in order here.


Claude Warren

Identity Info identify.nu

[WWW]
mowe



Joined: 01/09/2010 18:09:25
Messages: 1
Offline

I'm going to bring this post back up again.
I've done some research on the Administrative Division stuff in Germany.

Currently only 5 (of 16) states have "Regierungsbezirke" - said "Regierungsbezirke" are ADM2 level entities in those states:
Baden-Württemberg
Bavaria (Bayern)
Hessen
North Rhine-Westphalia (Nordrhein-Westfalen)
Saxony (Sachsen) (the "Regierungsbezirke" are now called "Direktionsbezirke"; in the database, they are still called "Regierungsbezirke")

In these states ("Bundesländer") the "Landkreise" should consequently be ADM3 level.

In the remaining states there are no "Regierungsbezirke" or comparable entities; here the Landkreise (or districts) should be ADM2 level.
This, however, leads to the confusing situation that entities that are basically comparable (the "Landkreise") will be ADM2 level in some states and ADM3 level in others.
This problem could be solved by leaving blank the ADM2 level or omitting it in states without "Regierungsbezirke" and making the Landkreise ADM3 level subdivisions.

By now the situation is not very satisfying, because there is no way to add the Landkreis information to a dataset that is in an ADM1 level (Bundesland) that does not have any ADM2 children (Regierungsbezirke).
marc



Joined: 08/12/2005 07:39:47
Messages: 3993
Offline

The admin division for Germany have been completely updated with the newest data from 'destatis' (codes). The states with missing adm2 layer have the lower levels assigned with a dummy adm2 code '00'.

Best

Marc

[WWW]
Oldperl



Joined: 09/12/2010 21:30:02
Messages: 3
Location: Eltmann / germany
Offline

just written what i wrote. Can't delete this, sorry

regards Ortwin
[WWW]
 
Forum Index -> Administrative Divisions
Go to:   
Powered by JForum 2.1.5 © JForum Team