World Cities Database Basic

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

GeoDataSource™ World Cities Database Basic Edition