Add-On

Web Service

World Cities Database Platinum Edition

$1349.95 per year

Database of worldwide cities in text format suitable for any applications requiring a comprehensive list of cities name, state/province (ADM1), latitude, longitude, country code, population. It is a subset of the GeoDataSource™ Cities Database Titanium Edition.

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

region_code

Region Code. A code 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_region_code

Sub-Region Code. A sub division of region code.

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

adm1_code

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.

character

3

adm1_full_name

First-Order Administrative Division's 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.

It is compliant with ISO 3166-2 for all countries except for the countries listed below,

49 countries don't have the official ISO3166-2 subdivisions defined.

1 exception for Bahamas - New Providence region, which do not have ISO3166-2 associated.

1 exception for Singapore - we categorize Singapore as a single subdivision.

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).

character

3

adm2_full_name

Second-Order Administrative Division's 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)

character

200

latitude

Latitude in Decimal Degree. Latitude of the feature in ± decimal degrees (WGS84).

no sign (+) = North;
negative sign (-) = South.

float

10

longitude

Longitude in Decimal Degree. Longitude of the feature in ± decimal degrees (WGS84).

no sign (+) = East;
negative sign (-) = West.

float

10

population

City Population. Total number of human population by estimation in the top 12,000 cities in the world.

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.