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.

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 sales@ebusinessgems.com

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;
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, 2011

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 sales@eBusinessGems.com. Thank you.