World Cities Database Titanium

FIELD NAME	FIELD DESCRIPTION	FIELD TYPE	FIELD LENGTH (MAX)
REGION	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	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	2
FULL_NAME	Feature's Full Name. The full name is a complete 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 alphanumeric character code uniquely identifying a primary administrative division of a country, such as a state in the United States.	character	2
ADM1_FULL_NAME	First-Order Administrative Division's Full Name. The full name is a complete name which identifies the first-order administrative division. It is comprised of the specific name, generic name, and any articles or prepositions.	character	200
ADM1_FULL_NAME_ND	First-Order Administrative Division's No Diacritics Full Name. Same as the division's full name but the diacritics and special characters are substituted with Roman characters.	character	200
ADM2_CODE	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	2
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
ADM2_FULL_NAME_ND	Second-Order Administrative Division's No Diacritics Full Name. Same as the division's full name but the diacritics and special characters are substituted with Roman characters.(US only)	character	200
LATITUDE	Latitude in Decimal Degree: Latitude of the feature in ± decimal degrees (WGS84). no sign (+) = North; negative sign (-) = South.	number	10
LONGITUDE	Longitude in Decimal Degree: Longitude of the feature in ± decimal degrees (WGS84). no sign (+) = East; negative sign (-) = West.	number	10
DMS_LATITUDE	Latitude in Degree Minute Second: Latitude of the feature in ± degrees, minutes, and seconds (WGS84). no sign (+) = North; negative sign (-) = South.	number	6
DMS_LONGITUDE	Longitude in Degree Minute Second: Longitude of the feature in ± degrees, minutes, and seconds (WGS84). no sign (+) = East; negative sign (-) = West.	number	7
UTM	Universal Transverse Mercator: Universal Transverse Mercator coordinate grid reference.	character	4
JOG	Joint Operations Graphic: Joint Operations Graphic reference.	character	7
POPULATION	City Population: Total number of human population by estimation in the top 12,000 cities in the world.	number	10
TIMEZONE	UTC Time Zone: The city's UTC Time Zone	character	8

GeoDataSource™ World Cities Database Titanium Edition