World Cities Database Basic Edition

Name: GeoDataSource
Brand: GeoDataSource

$449.95 per year

Database of worldwide cities in text format suitable for any applications requiring a comprehensive list of cities name and country code. It is a subset of the GeoDataSource™ Cities Database Premium, Gold, Platinum and Titanium Edition.

Latest release: January, 2022

Click here to view breakdowns by country

Download Sample (103.54 kB)

Download Access:

Advantages

Free and Updated Monthly
Multiple Subscriptions Packages Available
Most Accurate and Up-to-Date Source of Data
Comprehensive List of Cities and Related Items (2,908,106 Entries)
Support Worldwide 260+ Countries, Territories and Sovereign Lands
Instant Download Upon Subscription
Free Customer Support
Many Happy Customers

Requirements

Internet connection capable of downloading 46.18 MB compressed ZIP data file
46.18 MB free disk space for compressed file
184.73 MB free disk space for uncompressed data files
WinZIP or other similar archive extraction utility
SQL Server, Oracle, MySQL, PostgreSQL or other database software application capable of importing 2,908,106 records from a standard tab-delimited ASCII text file and sufficient disk space to import the database

Feature Designation Code

Code	Feature Name	Description
PPL	Populated place	A city, town, village, or other agglomeration of buildings where people live and work.
PPLA	Seat of a first-order administrative division	Seat of a first-order administrative division.
PPLC	Capital of a political entity	Capital of a political entity.
PPLL	Populated locality	An area similar to a locality but with a small group of dwellings or other buildings.
PPLQ	Abandoned populated place	Abandoned populated place.
PPLR	Religious populated place	A populated place whose population is largely engaged in religious occupations.
PPLS	Populated places	Cities, towns, villages, or other agglomerations of buildings where people live and work.
PPLW	Destroyed populated place	A village, town or city destroyed by a natural disaster, or by war.
PPLX	Section of populated place	Section of populated place.
PPLA2	Second-order administrative division	Seat of a second-order administrative division.
PPLA3	Third-order administrative division	Seat of a third-order administrative division.
PPLA4	Fourth-order administrative division	Seat of a fourth-order administrative division.

Specifications

Field Name	Description	Type	Length
continent_id	Continent ID. An id that determines the character mapping used in the full name field. 1 = Africa 2 = Americas 3 = Antarctica 4 = Asia 5 = Europe 6 = Oceania	number	1
sub_continent_id	Sub-Continent ID. A sub division of continent id. 1A = Central Africa 1B = Eastern Africa 1C = Indian Ocean 1D = Northern Africa 1E = Southern Africa 1F = Western Africa 2A = Central America 2B = North America 2C = South America 2D = West Indies 3A = Antarctica 3B = Atlantic Ocean 4A = Central Asia 4B = East Asia 4C = Northern Asia 4D = South Asia 4E = South East Asia 4F = South West Asia 5A = Central Europe 5B = Eastern Europe 5C = Northern Europe 5D = South East Europe 5E = South West Europe 5F = Southern Europe 5G = Western Europe 6A = North Pacific Ocean 6B = Pacific 6C = South Pacific Ocean	character	2
ufi	Unique Feature Identifier. A number which uniquely identifies the feature. A feature with multiple names with share a same feature identifier.	number	10
uni	Unique Name Identifier. A number which uniquely identifies a name.	number	10
dsg	Feature Designation Code. A two to five-character code used to identify the type of feature a name is applied to.	character	5
cc_fips	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).	character	2
cc_iso	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).	character	5
full_name	Feature's Full Name. The full name is a complete city name which identifies the named feature. It is comprised of the specific name, generic name, and any articles or prepositions.	character	200
full_name_nd	Feature's No Diacritics Full Name. Same as the full name but the diacritics and special characters are substituted with Roman characters.	character	200
sort_name	Feature's 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.	character	200

SQL Statement

MySQL
MS SQL

-- Create table "world_cities_basic"
CREATE TABLE `world_cities_basic`(
	`continent_id` INT,
	`sub_continent_id` VARCHAR(2),
	`ufi` INT,
	`uni` INT,
	`dsg` CHAR(5),
	`cc_fips` VARCHAR(2),
	`cc_iso` VARCHAR(2),
	`full_name` VARCHAR(200),
	`full_name_nd` VARCHAR(200),
	`sort_name` VARCHAR(200),
	INDEX `idx_continent_id` (`continent_id`),
	INDEX `idx_sub_continent_id` (`sub_continent_id`),
	INDEX `idx_continent` (`continent_id`,`sub_continent_id`),
	INDEX `idx_cc_iso` (`cc_iso`),
	INDEX `idx_dsg` (`dsg`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- Load data into table
LOAD DATA LOCAL
INFILE 'GEODATASOURCE-CITIES-BASIC.TXT'
INTO TABLE `world_cities_basic`
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;

-- Create table "country"
CREATE TABLE `country`(
	`cc_fips` VARCHAR(2),
	`cc_iso` VARCHAR(2),
	`tld` VARCHAR(3),
	`country_name` VARCHAR(100),
	INDEX `idx_cc_fips`(`cc_fips`),
	INDEX `idx_cc_iso`(`cc_iso`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- Load data into table "country"
LOAD DATA LOCAL
INFILE 'GEODATASOURCE-COUNTRY.TXT'
INTO TABLE `country`
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;

-- Create table "world_cities_basic"
CREATE TABLE [geodatasource].[dbo].[world_cities_basic](
	[continent_id] int,
	[sub_continent_id] nvarchar(2) NOT NULL,
	[ufi] int NOT NULL,
	[uni] int NOT NULL,
	[dsg] nchar(5) NOT NULL,
	[cc_fips] nvarchar(2) NOT NULL,
	[cc_iso] nvarchar(2) NOT NULL,
	[full_name] nvarchar(200) NOT NULL,
	[full_name_nd] nvarchar(200) NOT NULL,
	[sort_name] nvarchar(200) NOT NULL
) ON [PRIMARY]
GO

CREATE INDEX [idx_continent_id] ON [geodatasource].[dbo].[world_cities_basic]([continent_id]) ON [PRIMARY]
GO

CREATE INDEX [idx_sub_continent_id] ON [geodatasource].[dbo].[world_cities_basic]([sub_continent_id]) ON [PRIMARY]
GO

CREATE INDEX [idx_continent] ON [geodatasource].[dbo].[world_cities_basic]([continent_id], [sub_continent_id]) ON [PRIMARY]
GO

CREATE INDEX [idx_cc_iso] ON [geodatasource].[dbo].[world_cities_basic]([cc_iso]) ON [PRIMARY]
GO

CREATE INDEX [idx_dsg] ON [geodatasource].[dbo].[world_cities_basic]([dsg]) ON [PRIMARY]
GO
			
-- Create table "country"
CREATE TABLE [geodatasource].[dbo].[country](
	[cc_fips] nvarchar(2) NOT NULL,
	[cc_iso] nvarchar(2) NOT NULL,
	[tld] nvarchar(3) NOT NULL,
	[country_name] nvarchar(100) NOT NULL,
) ON [PRIMARY]
GO

CREATE INDEX [idx_cc_fips] ON [geodatasource].[dbo].[country]([cc_fips]) ON [PRIMARY]
GO

CREATE INDEX [idx_cc_iso] ON [geodatasource].[dbo].[country]([cc_iso]) ON [PRIMARY]
GO

Licensing

Single Server License

All prices mentioned in this page are for "Single Server License" unless specified otherwise. "Single Server License" can be used for 1 database server in a commercial environment with single or multiple connected clients.