Of Countries and their Cities

Question

I need a database of Countries and their Cities   Any idea where I can get such a list

User · Answer

http   cldr unicode org  - common standard multi-language database  includes country list and other localizable data

User · Answer

From all my searching around  I strongly say that the most practical  accurate and free data source is provided by GeoNames   You can access their data in 2 ways    The easy way through their free web services  Import their free text files into Database tables and use the data in any way you wish  This method offers much greater flexibility and have found that this method is better

User · Answer

There are quite a few available   The following has database for 2 401 039 cities  http   www geodatasource com world-cities-database free

User · Answer

United Nations list of locations in mdb  csv or txt   Welcome  http   www unece org cefact locode welcome html  Choose the downloads link from the above link or just click here

User · Answer

You can use database from here -  http   myip ms info cities sql database   CREATE TABLE  cities       cityID  mediumint 8  unsigned NOT NULL AUTO INCREMENT     cityName  varchar 50  NOT NULL     stateID  smallint 5  unsigned NOT NULL DEFAULT  0      countryID  varchar 3  NOT NULL DEFAULT        language  varchar 10  NOT NULL DEFAULT        latitude  double NOT NULL DEFAULT  0      longitude  double NOT NULL DEFAULT  0     PRIMARY KEY   cityID      UNIQUE KEY  unq    countryID   stateID   cityID      KEY  cityName    cityName      KEY  stateID    stateID      KEY  countryID    countryID      KEY  latitude    latitude      KEY  longitude    longitude     ENGINE InnoDB  DEFAULT CHARSET utf8

User · Answer

Go through this link http   www maxmind com en worldcities   It Includes the following fields    Country Code ASCII City Name City Name Region Population Latitude  The latitude and longitude are near the center of the most granular location value returned  postal code  city  region  or country  Longitude

User · Answer

I was comparing worldcitiesdatabae info with www worldcitiesdatabase com and it appears the latter one to be more resourceful  However  maxmind has a free database so then why buy a cities database  Just get the free one and there is lot of help available on internet about maxmind db  If you put in extra efforts then you can save those few bucks

User · Answer

Check this out   Cities of the world database donated by MaxMind com  The company MaxMind com1 has agreed to release their cities of the world database under the GPL  The database contains locations by country  city  latitude and longitude  There are over 3 047 000 records in the database  For those of you who have tried the location module with the zipcodes database from CivicSpace  you will recognize how cool it is and how well this fits with that project and therefore Drupal    Here s another free one that might help you get started   Creating and maintaining such a database is quite a bit of work - so anyone who s done it is likely keeping it to themselves  or offering it for a fee

User · Answer

https   code google com p worlddb downloads list  Open World Database alpha  This database has multi languages country names  region names  city names and they s latitude and longitude number and country s alpha2 code

User · Answer

This service returns Countries  name code  and cities for any country as REST  SErvice  You can also download database and sample REST service  http   tecorange com content world-countries-and-cities-restjson-service-12-months-subscription

[database] Of Countries and their Cities

Examples related to database

Examples related to countries