Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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, this admin code references a 'Gemeinde', an admin field I would like to include in my work, if possible.

The German dataset I'm working with:

The German dataset I'm using as a lookup table for ADMIN CODES:

Both zipped folders contain a 'readme.txt' file that outlines the fieldnames in the data.

I am also tracking this question on the Geonames forum:

share|improve this question
up vote 1 down vote accepted

I've found what I needed. 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 (

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

    FROM DE_imported

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

Thanks to marc, from the Geonames forum, who helped me resolve this issue!

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.