This is a comprehensive world cities database. This database has World city names with latitude and longitude of all the cities and places of every country. 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. However, 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. Hence 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.

Data Format:
The package contains data as SQL dump files. SQL Dump files are script files that can be readily executed from a SQL query tool such as MySQL query browser. The script will create required tables and populate with the data. Additional format such as CSV file, TAB delimited text file, Microsoft Excel or Microsoft Access database is available on request. A small fee for data conversion may be applicable. Please send your request to [email protected]

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:
Click here to Download World Cities Database with Latitude and Longitude.

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:
[download prod_url='”https://www.ebusinessgems.com/catalog/world-city-names-database-with-latitude-longitude-p-117.html” target=”_blank”‘ prod_title=’World City Names Database with Latitude and Longitude’]
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;
Data Example:

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

Keywords:

city, database, latitude, longitude, world, cities, names, list, lat, long

Keyphrases:

city database, latitude of the world, world latitude longitude, database city, city latitude longitude, cities latitude longitude, names of world cities, world city names, world city list, lat and long, long and lat, latitude and longitude

**********************************************************

World City Names Database with Latitude and Longitude

**********************************************************

World City Names Database with Latitude and Longitude is an eBuisnessGems Product

Copyright © eBuisnessGems.com, al rights reserved

Unauthorized copying, distribution and use of this database product is strictly prohibited. You can purchase and download this product only from www.eBusinessGems.com. This product is for your personal use only and you can not resell or distribute it in its original form and content. However you may use this database in your own web site or application and sell the resulting product or service. If you find this product being sold and distributed by any other store, please immediately inform [email protected] Thank you.