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:
[download prod_url='”http://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’]
- Africa
- Antarctic Region
- Arctic Region
- Asia
- Central America and the Caribbean
- Commonwealth of Independent States
- Europe
- Middle East
- North America
- Oceania
- South America
- South East Asia
- World Others
Fields in the Table COUNTRIES:
- ISO2: Two character ISO country code
- FIPS104: Two character FIPS country code
- ISO3: Three character ISO country code
- ISON: Numeric ISO country code
- TLD: Top level Internet domain name for the country
- Country: Name of the country
- Continent: Continent or reference zone
- Capital: Capital of the country
- NationalitySingular: Nationality (singular form)
- NationalityPlural: Nationality (plural form)
- Currency: Currency of the country
- CurrencyCode: Three character currency code
- Population: Population of the country
Fields in the Table REGIONS:
- ISO2: Two character ISO country code
- RC: Two character region code
- Region: Name of the region of the country
Fields in the Table CITIES:
- CityID: City identification number
- ISO2: Two character ISO country code
- RC: Two character region code
- City: Name of the city
- AccentCity: Accented name of the city
- Latitude: Latitude of the city
- Longitude: Longitude of the city
The corresponding SQL command, for example, in the dump file to create CITIES table is:
[download prod_url='”http://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:
| 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 |
| 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.