Global Cities Database Standard Edition - Pricing - Product Overview - Product Summary - Product Detail - Product Features - Product Requirements - Country Breakout - Database Fields Available editions: STANDARD, Professional, Corporate Available licensing: COMMERCIAL, Non-Profit, Redistribution Available regions: GLOBAL, Africa, Arctic Region, Asia, Central America and the Caribbean, Europe, Middle East, North America, Oceania, South America, Southeast Asia, Pricing Standard Edition Commercial Server For 1 database server in a commercial environment with multiple connected clients located at a single company location Download... Commercial Server, August 2010: Commercial Server Standard Edition  $ 779.95 Buy Now with Quarterly updates*  $ 1,165.95 Buy Now Upgrades for previous versions: Commercial Server Standard Edition  $ 467.95 Buy Now with Quarterly updates*  $ 701.95 Buy Now   Standard Edition Commercial Site For unlimited database servers in a commercial environment with multiple connected clients located at a single company location Download... Commercial Site, August 2010: Commercial Site Standard Edition  $ 1,165.95 Buy Now with Quarterly updates*  $ 1,750.95 Buy Now Upgrades for previous versions: Commercial Site Standard Edition  $ 701.95 Buy Now with Quarterly updates*  $ 1,048.95 Buy Now   Standard Edition Commercial Enterprise For unlimited database servers in a commercial environment with multiple connected clients located across multiple company locations Download... Commercial Enterprise, August 2010: Commercial Enterprise Standard Edition  $ 2,335.95 Buy Now with Quarterly updates*  $ 3,505.95 Buy Now Upgrades for previous versions: Commercial Enterprise Standard Edition  $ 1,399.95 Buy Now with Quarterly updates*  $ 2,101.95 Buy Now   Need Non-Profit licensing? Need Redistribution licensing? *One time cost for a 1 year subscription     Product Overview Substantial core database of cities suitable for any application requiring a comprehensive list of cities. Subset of the Professional and Corporate editions.   Product Summary Global Cities database - Standard edition - August 2010 release. Database contains 2,965,974 entries with names, type classifications, state-level information (1st level administrative division) and country data.   Product Detail Updated quarterly Subscriptions plans available Discounted update pricing available Most accurate and timely source of data Comprehensive list of Cities and related items: 2,965,974 entries Streamline user input - create standardized lists of cities Complete list of 260+ countries, territories and sovereign lands   Product Features The cities database is comprised of the types of features listed below: Feature type # of entries Description Populated Place 2,854,736 a city, town, village, or other agglomeration of buildings where people live and work Section of Populated Place 45,382 section of populated place Populated Locality 31,133 an area similar to a locality but with a small group of dwellings or other buildings Abandoned Populated Place 17,449 abandoned populated place Captial of a First-Order Administrative Division 6,592 seat of a first-order administrative division (PPLC takes precedence over PPLA) Destroyed Populated Place 2,598 a village, town or city destroyed by a natural disaster, or by war Captial of a Country (PCLD, PCLF, PCLI, PCLS) 718 capital of a political entity Populated Places 422 cities, towns, villages, or other agglomerations of buildings where people live and work Religious Populated Place 21 a populated place whose population is largely engaged in religious occupations Total 2,959,051     Product requirements Internet connection capable of downloading 44 MB compressed ZIP data file 44 MB free disk space for compressed file 93 MB free disk space for uncompressed data files WinZIP or other similar PKZip archive extraction utility SQL Server, Oracle, MySQL, PostgrSQL or other database software application capable of importing 2,965,974 records from a standard tab-delimited ASCII text file. Sufficient free disk space for database software application to import the data files and create necessary supporting index files (varies depending upon software).   Global country summary breakout [ display full breakout ] # of entries Region # of countries 430,940 Africa 57 3 Antarctic Region 2 1,097 Arctic Region 3 725,481 Asia 22 75,673 Central America and the Caribbean 29 671,679 Europe 47 264,568 Middle East 17 219,951 North America 5 37,531 Oceania 21 158,867 South America 14 373,261 Southeast Asia 18 2,959,051 Totals 235   Database fields available in the Standard Edition Feature table Additional Feature fields are available in the Professional and Corporate editions Field Data type Field description Feature_int_id integer Unique key value for Feature table. FeatureType_str_code varchar(5) Foreign key value into FeatureType table. See FeatureType fields. Admin1_str_code varchar(5) Foreign key value into Admin1 table. See Admin1 fields. Country_str_code varchar(2) Foreign key value into Country table. See country fields. Feature_str_name varchar(120) Conventional Romanized-language recognized name of the city in current and widespread use. Clean of any specialized language diacritics - uses only standard ASCII characters. Suitable for nearly all computer systems and for printing. FeatureType table Field Data type Field description FeatureType_str_code varchar(5) Unique key value for FeatureType table FeatureType_str_type varchar(35) Classification for the type of city FeatureType_str_name varchar(50) Recognized name of the type of city FeatureType_str_description varchar(255) Description of the type of city Admin1 table Additional 1st-Level Administrative Division fields are available in the Professional and Corporate editions Field Data type Field description Admin1_str_code varchar(5) Unique key value for Admin1 table Country_str_code varchar(2) Foreign key value into Country table. See Country fields. Admin1_str_type varchar(50) Type of first level administrative division, such as a 'state' in the United States or a 'province' in the Netherlands Admin1_str_name varchar(100) Recognized name of the first level administrative division Admin2 table (see details) 2nd-Level Administrative Division fields are available only in the Corporate edition Field Data type Field description Country table Additional country fields are available in the Professional and Corporate editions Field Data type Field description Country_str_code varchar(2) Unique key value for Country table Country_str_ ISO3166_2char_code varchar(2) The two-letter alpha code maintained by the International Organization for Standardization (ISO) using the ISO-3166 Alpha-2 standard Country_str_ ISO3166_3char_code varchar(3) The three-letter alpha code maintained by the International Organization for Standardization (ISO) using the ISO-3166 Alpha-3 standard Country_str_ ISO3166_numeric_code varchar(3) The numeric code maintained by the International Organization for Standardization (ISO) using the ISO-3166 Numeric standard Country_str_type varchar(30) Specifies whether the country is an independent state or a dependency Country_str_name varchar(100) Recognized short name of the country Country_str_long_name varchar(100) Recognized full name of the country Country_str_ controlling_entity varchar(25) The name of the controlling country if country_str_type indicates a dependency Country_str_former_name varchar(100) Previous country name, where applicable Country_str_ name_abbreviation varchar(25) Short abbreviation of country name CountryNotes table CountryNote fields are available only in the Professional and Corporate edition Field Data type Field description Region table Region fields are available only in the Professional and Corporate edition Field Data type Field description TIMEZONE table Timezone fields are available only in the Corporate edition Field Data type Field description

Data products that improve your business!

Meridian World Data offers geographical databases, lists and gazetteers of world-wide features and global locations containing officially recognized place names, latitude/longitude coordinates, administrative regions, countries and distance calculations. 

7.1+ million geographic features and ZIP codes. 270+ countries and territories. Comprehensive global listings. 

Put Meridian World Data to work for your business - custom datasets and applications to meet your company's needs.

--The world is now within your grasp!

Global Cities

Postal Codes

Man-made features

Water features

Land features