GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Where to get Database of Country -> State -> City ?  XML
Forum Index -> General
Author Message
AGeoNamesUser



Joined: 17/06/2017 16:51:26
Messages: 3
Offline

The allCountries.zip in /dump only contains countries and cities, but no states/provinces. (For example, the row for Sydney, Australia does not contain "New South Wales" anywhere.)

The allCountries.zip in /zip do contain countries, states/provinces, and cities (e.g. Sydney, New South Wales, Australia), but is limited to just countries that use Postal Codes (only about 80 or so).

So where can I find a COMPLETE database of ALL countries, states/provinces (full names), and cities in the world?

This database should show, for example, both "Sydney, New South Wales, AU" and "Kabul, Kabul, AF".

Thank you.
marc



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

The first file is the correct one, you may also want alternatenames.zip to get all languages. The state/province info is in the admincode1 field as a self reference to the same table to features with featurecode ADM1.

Best Regards

Marc

[WWW]
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team