GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Lookup table for German ADM4 codes? (admin4_code)  XML
Forum Index -> Administrative Divisions
Author Message
drapkin11



Joined: 23/03/2011 19:56:06
Messages: 3
Offline

I am working with both the postal and Geonames data for Germany. I noticed that while the Postal data may be used as a lookup for ADMIN_CODES 1-3 (ADM1,ADM2,ADM3), it does not mention ADM4 at all.

Does anyone know where to find the lookup table for 'admin4_code' values?

According to http://forum.geonames.org/gforum/posts/list/538.page, this admin code references a 'Gemeinde', an admin field I would like to include in my work, if possible.

Thanks,
-K
marc



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

The admin4 code is not yet included in the postal code extract. It is a new addition for Germany and changing the file layout would break all existing import scripts.
If you are interested in the lookup you can download the gazetteer files for Germany from the normal extract and use the ADM4 toponyms with their adm4 code.

Best Regards

Marc

[WWW]
drapkin11



Joined: 23/03/2011 19:56:06
Messages: 3
Offline

Marc,

I'm not sure what you mean by the gazetteer files for Germany - perhaps this: The German dataset I'm working with: http://download.geonames.org/export/dump/DE.zip

I do not see any ADM4 toponyms. There are no records in that file with non-null codes for ADM1-3 and the ADM4 code is not null.

And in general, I've been using the Postal code file (http://download.geonames.org/export/zip/DE.zip) as the base for my lookup table. If a better strategy exists I'd like to know!

Thanks,
-K
marc



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

There must be something wrong with your query. The ADM4 are there and they do have adm4 codes:
http://www.geonames.org/search.html?q=adm4&country=DE

Marc

[WWW]
drapkin11



Joined: 23/03/2011 19:56:06
Messages: 3
Offline

marc,

I've found what I needed, thanks!

The postal code file for Germany may be used to construct a lookup table for ADM1, ADM2 and ADM3 administrative areas, but not ADM4.

However, upon closer inspection, a lookup table may be constructed for ALL FOUR ADM areas from the German Geonames dataset (http://download.geonames.org/export/dump/DE.zip).

Having imported the file 'DE.txt' into a database, the following query gives me the records of interest:

Code:
 SELECT
   NAME,
   ADMIN4_CODE
 FROM DE_imported
 WHERE FEATURE_CLASS='A' and FEATURE_CODE='ADM4'
 


Somehow, I missed the top section in "GeoNames Feature Codes", which details that FEATURE_CLASS='A' for admin areas.

I was also tracking this question on GIS.StackExchange: http://gis.stackexchange.com/questions/7688/complete-lookup-table-for-german-admin-codes-in-geonames-data-admin4-code
 
Forum Index -> Administrative Divisions
Go to:   
Powered by JForum 2.1.5 © JForum Team