I would like to use a hierarchy like "country -> admin1 region -> city" for all cities within the cities1000 text file. I would also like to show fo each language the translated names of country, admin region and city if available or otherwise use the original default value.
I don't understand how to link the admin1 region either in cities1000.txt or admin1Codes.txt to the alternateNames.txt file. In the first two files you have an admin1 region identifier like DE.02 for Bavaria but no GeonameID. In alternateNames file you have the GeonameID like 2951840 for Bavaria.
How is it possible to connect these two information?
I would really appreciate your help. Thanks a lot!
The admin1Codes files are a subset of the alternateNames file. There is not need to connect them, you use either one or the other, whatever you prefer.
If you want to connect them: They are connected over country code and admin1 codes.