{"id":658,"date":"2019-04-30T00:00:00","date_gmt":"2019-04-30T00:00:00","guid":{"rendered":"https:\/\/wp3.geodatasource.com\/tutorials\/changes-on-geodatasource-world-cities-database-may-2019-update\/"},"modified":"2019-04-30T00:00:00","modified_gmt":"2019-04-30T00:00:00","password":"","slug":"changes-on-geodatasource-world-cities-database-may-2019-update","status":"publish","type":"docs","link":"https:\/\/www.geodatasource.com\/resources\/tutorials\/changes-on-geodatasource-world-cities-database-may-2019-update\/","title":{"rendered":"Changes on GeoDataSource World Cities Database May 2019 update"},"content":{"rendered":"<p>GeoDataSource.com is pleased to announce the release of updates for the GeoDataSource World Cities Database. There are some changes for both the Free Edition and the Commercial Edition starting from May 2019 update. In this article, we will discuss about the changes in both Free Edition and Commercial Edition World Cities Database.<\/p>\n<p><strong>World Cities Database Free Edition Changes<\/strong><\/p>\n<p>A new column named <strong>cc_iso<\/strong>, ISO 3166 Primary Country Code has been added to the World Cities Database Free Edition. It is a two alphabetic character ISO 3166 Primary Country Code uniquely identifying a geopolitical entity (countries, dependencies, and areas of special sovereignty).<\/p>\n<p>By adding the new column, the existing world_cities_free table can no longer be used. Please follow the steps below to create the world_cities_free table with the new table structure.<\/p>\n<ol>\n<li>Drop the current world_cities_free table by running the SQL below\n<pre>DROP TABLE `world_cities_free`;<\/pre>\n<\/li>\n<li>Create the new world_cities_free table by running the SQL below\n<pre>CREATE TABLE `world_cities_free`(\n\t`cc_fips` VARCHAR(2),\n\t`cc_iso` VARCHAR(2),\n\t`full_name_nd` VARCHAR(200),\n\tINDEX `idx_cc_iso` (`cc_iso`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;<\/pre>\n<\/li>\n<li>Load the data into the new world_cities_free table by running the SQL below\n<pre>LOAD DATA LOCAL\nINFILE 'GEODATASOURCE-CITIES-FREE.TXT'\nINTO TABLE `world_cities_free`\nFIELDS TERMINATED BY 't'\nLINES TERMINATED BY 'rn'\nIGNORE 1 LINES;<\/pre>\n<\/li>\n<li>Done.<\/li>\n<\/ol>\n<p><strong>World Cities Database Commercial Edition Changes<\/strong><\/p>\n<p>World Cities Database Commercial Edition consists of Basic Edition, Premium Edition, Gold Edition, Platinum Edition and Titanium Edition. Some column names have been changed in the World Cities Database Commercial Edition for May 2019 update. The affected columns are the region_code and the sub_region_code fields. The field names have been amended to continent_id and sub_continent_id respectively. The <strong>continent_id <\/strong>is an id that determines the character mapping used in the continent name. It contains,<\/p>\n<ul>\n<li>1 = Africa<\/li>\n<li>2 = Americas<\/li>\n<li>3 = Antarctica<\/li>\n<li>4 = Asia<\/li>\n<li>5 = Europe<\/li>\n<li>6 = Oceania<\/li>\n<\/ul>\n<p>The <strong>sub_continent_id<\/strong> is a sub-division of the continent id. It is used to represent the sub-continent name. For example,<\/p>\n<ul>\n<li>1A = Central Africa<\/li>\n<li>1B = Eastern Africa<\/li>\n<li>1C = Indian Ocean<\/li>\n<li>1D = Northern Africa<\/li>\n<li>1E = Southern Africa<\/li>\n<li>1F = Western Africa<\/li>\n<li>2A = Central America<\/li>\n<li>2B = North America<\/li>\n<li>2C = South America<\/li>\n<li>2D = West Indies<\/li>\n<li>3A = Antarctica<\/li>\n<li>3B = Atlantic Ocean<\/li>\n<li>4A = Central Asia<\/li>\n<li>4B = East Asia<\/li>\n<li>4C = Northern Asia<\/li>\n<li>4D = South Asia<\/li>\n<li>4E = South East Asia<\/li>\n<li>4F = South West Asia<\/li>\n<li>5A = Central Europe<\/li>\n<li>5B = Eastern Europe<\/li>\n<li>5C = Northern Europe<\/li>\n<li>5D = South East Europe<\/li>\n<li>5E = South West Europe<\/li>\n<li>5F = Southern Europe<\/li>\n<li>5G = Western Europe<\/li>\n<li>6A = North Pacific Ocean<\/li>\n<li>6B = Pacific<\/li>\n<li>6C = South Pacific Ocean<\/li>\n<\/ul>\n<p>With the changes in the column names, the current database table can still be used as normal. However, the table columns should be modified to follow the latest coding standard. The table can be changed by running the following SQL commands.<\/p>\n<pre>ALTER TABLE `world_cities_titanium` CHANGE `region_code` `continent_id` INT;<\/pre>\n<pre>ALTER TABLE `world_cities_titanium` CHANGE `sub_region_code` `sub_continent_id` VARCHAR(2);<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>GeoDataSource.com is pleased to announce the release of updates for the GeoDataSource World Cities Database. There are some changes for [&hellip;]<\/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-658","docs","type-docs","status-publish","hentry","doc_category-general-topics"],"year_month":"2026-06","word_count":494,"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":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Changes on GeoDataSource World Cities Database May 2019 update |<\/title>\n<meta name=\"description\" content=\"This article shows the changes on GeoDataSource World Cities Database May 2019 update. 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\/changes-on-geodatasource-world-cities-database-may-2019-update\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Changes on GeoDataSource World Cities Database May 2019 update |\" \/>\n<meta property=\"og:description\" content=\"This article shows the changes on GeoDataSource World Cities Database May 2019 update. Read about it to learn more details.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.geodatasource.com\/resources\/tutorials\/changes-on-geodatasource-world-cities-database-may-2019-update\/\" \/>\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\/05\/banner-articles-and-tutorials.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"2 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\\\/changes-on-geodatasource-world-cities-database-may-2019-update\\\/\",\"url\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/tutorials\\\/changes-on-geodatasource-world-cities-database-may-2019-update\\\/\",\"name\":\"Changes on GeoDataSource World Cities Database May 2019 update |\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/#website\"},\"datePublished\":\"2019-04-30T00:00:00+00:00\",\"description\":\"This article shows the changes on GeoDataSource World Cities Database May 2019 update. Read about it to learn more details.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/tutorials\\\/changes-on-geodatasource-world-cities-database-may-2019-update\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/tutorials\\\/changes-on-geodatasource-world-cities-database-may-2019-update\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.geodatasource.com\\\/resources\\\/tutorials\\\/changes-on-geodatasource-world-cities-database-may-2019-update\\\/#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\":\"Changes on GeoDataSource World Cities Database May 2019 update\"}]},{\"@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":"Changes on GeoDataSource World Cities Database May 2019 update |","description":"This article shows the changes on GeoDataSource World Cities Database May 2019 update. 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\/changes-on-geodatasource-world-cities-database-may-2019-update\/","og_locale":"en_US","og_type":"article","og_title":"Changes on GeoDataSource World Cities Database May 2019 update |","og_description":"This article shows the changes on GeoDataSource World Cities Database May 2019 update. Read about it to learn more details.","og_url":"https:\/\/www.geodatasource.com\/resources\/tutorials\/changes-on-geodatasource-world-cities-database-may-2019-update\/","article_publisher":"https:\/\/www.facebook.com\/geodatasource\/","og_image":[{"width":1200,"height":600,"url":"https:\/\/www.geodatasource.com\/resources\/wp-content\/uploads\/2021\/05\/banner-articles-and-tutorials.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@_geodatasource","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.geodatasource.com\/resources\/tutorials\/changes-on-geodatasource-world-cities-database-may-2019-update\/","url":"https:\/\/www.geodatasource.com\/resources\/tutorials\/changes-on-geodatasource-world-cities-database-may-2019-update\/","name":"Changes on GeoDataSource World Cities Database May 2019 update |","isPartOf":{"@id":"https:\/\/www.geodatasource.com\/resources\/#website"},"datePublished":"2019-04-30T00:00:00+00:00","description":"This article shows the changes on GeoDataSource World Cities Database May 2019 update. Read about it to learn more details.","breadcrumb":{"@id":"https:\/\/www.geodatasource.com\/resources\/tutorials\/changes-on-geodatasource-world-cities-database-may-2019-update\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.geodatasource.com\/resources\/tutorials\/changes-on-geodatasource-world-cities-database-may-2019-update\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.geodatasource.com\/resources\/tutorials\/changes-on-geodatasource-world-cities-database-may-2019-update\/#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":"Changes on GeoDataSource World Cities Database May 2019 update"}]},{"@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\/658","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=658"}],"version-history":[{"count":0,"href":"https:\/\/www.geodatasource.com\/resources\/wp-json\/wp\/v2\/docs\/658\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.geodatasource.com\/resources\/wp-json\/wp\/v2\/media?parent=658"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.geodatasource.com\/resources\/wp-json\/wp\/v2\/doc_category?post=658"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.geodatasource.com\/resources\/wp-json\/wp\/v2\/doc_tag?post=658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}