World City Names Database with Latitude and Longitude

This is a comprehensive database of world city names with latitude and longitude for all the cities and places of each of the continent's every country and region. This enormous collection has some 2.79 million cities and places of the planet earth. The size of the package is 43 megabyte zip file having 270 megabytes of SQL dumps when unzipped. The package contains readily executable SQL dump files to create and populate the world city database. Any other data format is available on request.

The database has cities and places of 246 countries and 4500+ regions comprising a total of 2.79+ millions of entries. The list is the largest and unique collection of its kind on the web.  The data is ready to be published on your content web site or application.

The dump files are splitted to manageable units. The file "world-city-database-regions.sql" should be run first in order to create the tables and all entries but the cities. All other scripts will create the entries in CITIES table and can be run in any sequence.

Tables and Columns:
The script will create 4 tables namely CONTINENTS, COUNTRIES, REGIONS and CITIES. Fields in each of the table are listed below:

Fields in the Table CONTINENTS:

There is a single field named [Continent] in this table. Actually the table contains name of the continents as well some mapping reference zones. The full list of the continents or zones is:

1. Africa
2. Antarctic Region
3. Arctic Region
4. Asia
5. Central America and the Caribbean
6. Commonwealth of Independent States
7. Europe
8. Middle East
9. North America
10. Oceania
11. South America
12. South East Asia
13. World Others

Fields in the Table COUNTRIES:

1. ISO2: Two character ISO country code 
2. FIPS104: Two character FIPS country code 
3. ISO3: Three character ISO country code 
4. ISON: Numeric ISO country code 
5. TLD: Top level Internet domain name for the country
6. Country: Name of the country
7. Continent: Continent or reference zone
8. Capital: Capital of the country
9. NationalitySingular: Nationality (singular form)
10. NationalityPlural: Nationality (plural form)
11. Currency: Currency of the country
12. CurrencyCode: Three character currency code
13. Population: Population of the country

Fields in the Table REGIONS:

1. ISO2: Two character ISO country code 
2. RC: Two character region code
3. Region: Name of the region of the country

Fields in the Table CITIES:

1. CityID: City identification number
2. ISO2: Two character ISO country code 
3. RC: Two character region code
4. City: Name of the city
5. AccentCity: Accented name of the city
6. Latitude: Latitude of the city
7. Longitude: Longitude of the city

The corresponding SQL command, for example, in the dump file to create CITIES table is:

CREATE TABLE `Cities` (
  `CityID` INTEGER NOT NULL,
  `ISO2` VARCHAR(2),
  `RC` VARCHAR(2),
  `City` VARCHAR(100),
  `AccentCity` VARCHAR(100),
  `Latitude` DOUBLE NULL,
  `Longitude` DOUBLE NULL,
  PRIMARY KEY (`CityID`)
) ENGINE=innodb DEFAULT CHARSET=utf8;

This enormous collection has some 2.79 million cities and places of the planet earth.

Given below are sample table entries for [Regions] and [Cities] table. For further detail you can also download a sample data file. Please right click on the following link: world city database sample file and select save as ... to save the sample data file.

Table: Regions

ISO2	RC	Region
US	NV	Nevada
US	NY	New York
US	OH	Ohio
US	OK	Oklahoma
US	OR	Oregon
US	PA	Pennsylvania
US	PR	Puerto Rico
US	PW	Palau
US	RI	Rhode Island
US	SC	South Carolina

Table: Cities

CityID	ISO2	RC	City	AccentCity	Latitude	Longitude
2639795	US	PR	columbia	Columbia	18.0063889	-65.9069444
2639796	US	PR	combate	Combate	18.4316667	-66.4313889
2639797	US	PR	comerio	Comerio	18.22	-66.2263889
2639798	US	PR	cometa	Cometa	18.1447222	-65.8291667
2639799	US	PR	comunas	Comunas	18.0891667	-65.8441667
2639800	US	PR	concordia	Concordia	17.9816667	-66.0372222
2639801	US	PR	condado	Condado	18.4563889	-66.0711111