{"id":669,"date":"2021-11-23T00:00:00","date_gmt":"2021-11-23T00:00:00","guid":{"rendered":"https:\/\/wp3.geodatasource.com\/tutorials\/what-is-world-cities-database\/"},"modified":"2021-11-23T00:00:00","modified_gmt":"2021-11-23T00:00:00","password":"","slug":"what-is-world-cities-database","status":"publish","type":"docs","link":"https:\/\/www.geodatasource.com\/resources\/tutorials\/what-is-world-cities-database\/","title":{"rendered":"What is World Cities Database"},"content":{"rendered":"\n
\"What<\/figure>\n\n\n\n

A database is an organized collection of data or information that is set up and stored for easy access electronically in a computer system.<\/p>\n\n\n\n

GeoDataSource World Cities Database is a database that contains the list of all cities, including counties, boroughs, towns and so on, in a text format that can be easily loaded in a database to be used by any application which requires a comprehensive list of country code, state\/province, city name, latitude, longitude, population and time zone.<\/p>\n\n\n\n

Database Editions<\/h2>\n\n\n\n

The edition of GeoDataSource World Cities Database comprises various editions which contain different granularity of information. Below are the details of the World Cities Database edition.<\/p>\n\n\n\n

Edition<\/strong><\/td>Price<\/strong><\/td><\/tr>
World Cities Database Free Edition<\/td>FREE<\/td><\/tr>
World Cities Database Basic Edition<\/td>$149.95 USD\/month or $449.95 USD\/year<\/td><\/tr>
World Cities Database Premium Edition<\/td>$249.95 USD\/month or $749.95 USD\/year<\/td><\/tr>
World Cities Database Gold Edition<\/td>$349.95 USD\/month or $1049.95 USD\/year<\/td><\/tr>
World Cities Database Platinum Edition<\/td>$449.95 USD\/month or $1349.95 USD\/year<\/td><\/tr>
World Cities Database Titanium Edition<\/td>$549.95 USD\/month or $1649.95 USD\/year<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Database Fields<\/h2>\n\n\n\n

The benefit of using the World Cities Database is that the data is updated monthly, ensuring most accurate and up-to-date source of data. It also provides instant download upon subscription. Below are the database fields for World Cities Database Titanium Edition<\/strong>.<\/p>\n\n\n\n

Field name<\/strong><\/td>Description<\/strong><\/td><\/tr>
continent_id<\/td>Continent ID. An id that determines the character mapping used in the full name field.<\/td><\/tr>
sub_continent_id<\/td>Sub-Continent ID. A subdivision of continent id.<\/td><\/tr>
ufi<\/td>Unique Feature Identifier. A number that uniquely identifies the feature. A feature with multiple names shares the same feature identifier.<\/td><\/tr>
uni<\/td>Unique Name Identifier. A number that uniquely identifies a name.<\/td><\/tr>
dsg<\/td>Feature Designation Code. A two to five-character code used to identify the type of feature a name is applied to.<\/td><\/tr>
cc_fips<\/td>FIPS 10-4 Primary Country Code. A two alphabetic character FIPS 10-4 Primary Country Code uniquely identifying a geopolitical entity (countries, dependencies, and areas of special sovereignty).<\/td><\/tr>
cc_iso<\/td>ISO 3166 Primary Country Code. A two alphabetic character ISO 3166 Primary Country Code uniquely identifying a geopolitical entity (countries, dependencies, and areas of special sovereignty).<\/td><\/tr>
full_name<\/td>Feature\u2019s Full Name. The full name is a complete city name that identifies the named feature. It is comprised of the specific name, generic name, and any articles or prepositions.<\/td><\/tr>
full_name_nd<\/td>Feature\u2019s No Diacritics Full Name. Same as the full name but the diacritics and special characters are substituted with Roman characters.<\/td><\/tr>
sort_name<\/td>Feature\u2019s Sort Name. A form of the full name which allows for easy sorting of the name into alpha-numeric sequence. It is comprised of the specific name, generic name, and any articles or prepositions. This field is all upper case with spaces, diacritics, and hyphens removed and numbers are substituted with lower case alphabetic characters.<\/td><\/tr>
adm1_code<\/td>First-Order Administrative Division Code. A two to three alphanumeric character code uniquely identifying a primary administrative division of a country, such as a state in the United States.<\/td><\/tr>
adm1_full_name<\/td>First-Order Administrative Division\u2019s Full Name. The full name is a complete region name which identifies the first-order administrative division. It is comprised of the specific name, generic name, and any articles or prepositions.<\/td><\/tr>
adm2_code<\/td>Second-Order Administrative Division Code. The name of a subdivision of a second-order administrative division, or known as a county in the United States. (US only).<\/td><\/tr>
adm2_full_name<\/td>Second-Order Administrative Division\u2019s Full Name. The full name is a complete name which identifies the second-order administrative division. It is comprised of the specific name, generic name, and any articles or prepositions. (US only)<\/td><\/tr>
latitude<\/td>Latitude in Decimal Degree. Latitude of the feature in \u00b1 decimal degrees (WGS84).<\/td><\/tr>
longitude<\/td>Longitude in Decimal Degree. Longitude of the feature in \u00b1 decimal degrees (WGS84).<\/td><\/tr>
population<\/td>City Population. Total number of human populations by estimation in the top 12,000 cities in the world.<\/td><\/tr>
time_zone<\/td>UTC Time Zone. The city\u2019s UTC Time Zone<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Database table<\/h2>\n\n\n\n

In order to get the world cities information, the World Cities Database Titanium Edition<\/strong> table can be created and loaded by the following code.<\/p>\n\n\n\n

-- Create table \"world_cities_titanium\"\nCREATE TABLE `world_cities_titanium`(\n\t`continent_id` INT,\n\t`sub_continent_id` VARCHAR(2),\n\t`ufi` INT,\n\t`uni` INT,\n\t`dsg` CHAR(5),\n\t`cc_fips` VARCHAR(2),\n\t`cc_iso` VARCHAR(2),\n\t`full_name` VARCHAR(200),\n\t`full_name_nd` VARCHAR(200),\n\t`sort_name` VARCHAR(200),\n\t`adm1_code` VARCHAR(3),\n\t`adm1_full_name` VARCHAR(200),\n\t`adm2_code` VARCHAR(3),\n\t`adm2_full_name` VARCHAR(200),\n\t`latitude` FLOAT,\n\t`longitude` FLOAT,\n\t`population` INT,\n\t`time_zone` VARCHAR(8),\n\tINDEX `idx_continent_id` (`continent_id`),\n\tINDEX `idx_sub_continent_id` (`sub_continent_id`),\n\tINDEX `idx_continent` (`continent_id`,`sub_continent_id`),\n\tINDEX `idx_cc_iso` (`cc_iso`),\n\tINDEX `idx_dsg` (`dsg`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;\n\n-- Load data into table\nLOAD DATA LOCAL\nINFILE 'GEODATASOURCE-CITIES-TITANIUM.TXT'\nINTO TABLE `world_cities_titanium`\nFIELDS TERMINATED BY 't'\nLINES TERMINATED BY 'rn'\nIGNORE 1 LINES;\n<\/code><\/pre>\n\n\n\n
For more details about the World Cities Database, you can visit https:\/\/www.geodatasource.com\/world-cities-database<\/a> to learn more about the information provided by each edition.<\/p>\n","protected":false},"excerpt":{"rendered":"
A database is an organized collection of data or information that is set up and stored for easy access electronically […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"doc_category":[20],"doc_tag":[],"class_list":["post-669","docs","type-docs","status-publish","hentry","doc_category-general-topics"],"year_month":"2026-05","word_count":802,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"hexasoft","author_nicename":"hexasoft","author_url":"https:\/\/www.geodatasource.com\/resources\/author\/hexasoft\/"},"doc_category_info":[{"term_name":"General Topics","term_url":"https:\/\/www.geodatasource.com\/resources\/categories\/general-topics\/"}],"doc_tag_info":[],"yoast_head":"\nWhat is World Cities Database |<\/title>\n<meta name=\"description\" content=\"This article shows the definition What is GeoDataSource World Cities Database. Read about it to learn more details.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.geodatasource.com\/resources\/tutorials\/what-is-world-cities-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is World Cities Database |\" \/>\n<meta property=\"og:description\" content=\"This article shows the definition What is GeoDataSource World Cities Database. Read about it to learn more details.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.geodatasource.com\/resources\/tutorials\/what-is-world-cities-database\/\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/geodatasource\/\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.geodatasource.com\/resources\/wp-content\/uploads\/2021\/11\/gds-nov-article-img.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@_geodatasource\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/tutorials\\\/what-is-world-cities-database\\\/\",\"url\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/tutorials\\\/what-is-world-cities-database\\\/\",\"name\":\"What is World Cities Database |\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/tutorials\\\/what-is-world-cities-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/tutorials\\\/what-is-world-cities-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/gds-nov-article-img.jpg\",\"datePublished\":\"2021-11-23T00:00:00+00:00\",\"description\":\"This article shows the definition What is GeoDataSource World Cities Database. Read about it to learn more details.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/tutorials\\\/what-is-world-cities-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/tutorials\\\/what-is-world-cities-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/tutorials\\\/what-is-world-cities-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/gds-nov-article-img.jpg\",\"contentUrl\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/gds-nov-article-img.jpg\",\"width\":1200,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/tutorials\\\/what-is-world-cities-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tutorials\",\"item\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/tutorials\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"What is World Cities Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/#website\",\"url\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/\",\"name\":\"GeoDataSource Articles & Tutorials\",\"description\":\"Resources About GeoDataSource Services\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/#organization\",\"name\":\"GeoDataSource.com\",\"url\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/logo-e1564122827936.png\",\"contentUrl\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/logo-e1564122827936.png\",\"width\":220,\"height\":27,\"caption\":\"GeoDataSource.com\"},\"image\":{\"@id\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/geodatasource\\\/\",\"https:\\\/\\\/x.com\\\/_geodatasource\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is World Cities Database |","description":"This article shows the definition What is GeoDataSource World Cities Database. Read about it to learn more details.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.geodatasource.com\/resources\/tutorials\/what-is-world-cities-database\/","og_locale":"en_US","og_type":"article","og_title":"What is World Cities Database |","og_description":"This article shows the definition What is GeoDataSource World Cities Database. Read about it to learn more details.","og_url":"https:\/\/www.geodatasource.com\/resources\/tutorials\/what-is-world-cities-database\/","article_publisher":"https:\/\/www.facebook.com\/geodatasource\/","og_image":[{"url":"https:\/\/www.geodatasource.com\/resources\/wp-content\/uploads\/2021\/11\/gds-nov-article-img.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@_geodatasource","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.geodatasource.com\/resources\/tutorials\/what-is-world-cities-database\/","url":"https:\/\/www.geodatasource.com\/resources\/tutorials\/what-is-world-cities-database\/","name":"What is World Cities Database |","isPartOf":{"@id":"https:\/\/www.geodatasource.com\/resources\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.geodatasource.com\/resources\/tutorials\/what-is-world-cities-database\/#primaryimage"},"image":{"@id":"https:\/\/www.geodatasource.com\/resources\/tutorials\/what-is-world-cities-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.geodatasource.com\/resources\/wp-content\/uploads\/2021\/11\/gds-nov-article-img.jpg","datePublished":"2021-11-23T00:00:00+00:00","description":"This article shows the definition What is GeoDataSource World Cities Database. Read about it to learn more details.","breadcrumb":{"@id":"https:\/\/www.geodatasource.com\/resources\/tutorials\/what-is-world-cities-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.geodatasource.com\/resources\/tutorials\/what-is-world-cities-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.geodatasource.com\/resources\/tutorials\/what-is-world-cities-database\/#primaryimage","url":"https:\/\/www.geodatasource.com\/resources\/wp-content\/uploads\/2021\/11\/gds-nov-article-img.jpg","contentUrl":"https:\/\/www.geodatasource.com\/resources\/wp-content\/uploads\/2021\/11\/gds-nov-article-img.jpg","width":1200,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/www.geodatasource.com\/resources\/tutorials\/what-is-world-cities-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.geodatasource.com\/resources\/"},{"@type":"ListItem","position":2,"name":"Tutorials","item":"https:\/\/www.geodatasource.com\/resources\/tutorials\/"},{"@type":"ListItem","position":3,"name":"What is World Cities Database"}]},{"@type":"WebSite","@id":"https:\/\/www.geodatasource.com\/resources\/#website","url":"https:\/\/www.geodatasource.com\/resources\/","name":"GeoDataSource Articles & Tutorials","description":"Resources About GeoDataSource Services","publisher":{"@id":"https:\/\/www.geodatasource.com\/resources\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.geodatasource.com\/resources\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.geodatasource.com\/resources\/#organization","name":"GeoDataSource.com","url":"https:\/\/www.geodatasource.com\/resources\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.geodatasource.com\/resources\/#\/schema\/logo\/image\/","url":"https:\/\/www.geodatasource.com\/resources\/wp-content\/uploads\/2019\/07\/logo-e1564122827936.png","contentUrl":"https:\/\/www.geodatasource.com\/resources\/wp-content\/uploads\/2019\/07\/logo-e1564122827936.png","width":220,"height":27,"caption":"GeoDataSource.com"},"image":{"@id":"https:\/\/www.geodatasource.com\/resources\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/geodatasource\/","https:\/\/x.com\/_geodatasource"]}]}},"_links":{"self":[{"href":"https:\/\/www.geodatasource.com\/resources\/wp-json\/wp\/v2\/docs\/669","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.geodatasource.com\/resources\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.geodatasource.com\/resources\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.geodatasource.com\/resources\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.geodatasource.com\/resources\/wp-json\/wp\/v2\/comments?post=669"}],"version-history":[{"count":0,"href":"https:\/\/www.geodatasource.com\/resources\/wp-json\/wp\/v2\/docs\/669\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.geodatasource.com\/resources\/wp-json\/wp\/v2\/media?parent=669"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.geodatasource.com\/resources\/wp-json\/wp\/v2\/doc_category?post=669"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.geodatasource.com\/resources\/wp-json\/wp\/v2\/doc_tag?post=669"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}