| Feature table |
| Field | Data type | Field description |
| Feature_int_id |
integer |
Unique key value for Feature table. |
| FeatureType_str_code |
varchar(5) |
Foreign key value into FeatureType table. See FeatureType fields. |
| Admin1_str_code |
varchar(5) |
Foreign key value into Admin1 table. See Admin1 fields. |
| Admin2_str_code |
varchar(8) |
Foreign key value into Admin2 table. See Admin2 fields. |
| Country_str_code |
varchar(2) |
Foreign key value into Country table. See country fields. |
| Timezone_int_id |
int |
Foreign key value into Timezone table. See Timezone fields. |
| Feature_int_font_code |
int |
Code indicating which Unicode Windows-based font to use to display local names using special diacritic characters.
1 = Western Europe / Americas
2 = Eastern Europe
3 = Africa / Middle East
4 = Central Asia
5 = Asia / Pacific
6 = Vietnam |
| Feature_int_population_tier |
int |
Code indicating the approximate population for populated places features (note: for countries other than the United States of America, the current release targets places with a population of more than 100,000 and capitals).
1 = more than 2,500,000
2 = 1,000,000 - 2,499,999
3 = 500,000 - 999,999
4 = 250,000 - 499,999
5 = 100,000 - 249,999
6 = 50,000 - 99,999
7 = 25,000 - 49,999
8 = 10,000 - 24,999
9 = less than 10,000
10 = notable populated place; population tier undetermined |
| Feature_str_name |
varchar(120) |
Conventional Romanized-language recognized name of the city in current and widespread use. Clean of any specialized language diacritics - uses only standard ASCII characters. Suitable for nearly all computer systems and for printing. |
| Feature_str_local_name |
varchar(120) |
Feature_str_name using local native language characters and spelling. May contain special foreign characters with diacritic marks. Refer to the Feature_int_font_code section for further information. |
| Feature_str_lat |
varchar(12) |
Latitude of the feature in degrees minutes seconds*. Format: hhh°mm"ss' N/S. |
| Feature_str_lon |
varchar(12) |
Longitude of the feature in degrees minutes seconds - based on the UTC (GMT)*. Format: hhh°mm"ss' E/W. |
| Feature_dec_lat |
numeric(12,7) |
Latitude of the feature in decimal degrees*. 12 digit precision with 7 digit scale. |
| Feature_dec_lon |
numeric(12,7) |
Longitude of the feature in decimal degrees*. 12 digit precision with 7 digit scale. |
| Feature_str_source_lat |
varchar(12) |
Latitude of the source of a linear feature, such as a river, in degrees minutes seconds*. Format: hhh°mm"ss' N/S. Not available for all records. |
| Feature_str_source_lon |
varchar(12) |
Longitude of the source of a linear feature, such as a river, in degrees minutes seconds - based on the UTC (GMT)*. Format: hhh°mm"ss' N/S. Not available for all records. |
| Feature_dec_source_lat |
numeric(12,7) |
Latitude of the source of a linear feature, such as a river, in decimal degrees*. 12 digit precision with 7 digit scale. Not available for all records. |
| Feature_dec_source_lon |
numeric(12,7) |
Longitude of the source of a linear feature, such as a river, in decimal degrees*. 12 digit precision with 7 digit scale. Not available for all records. |
| *Due to the nature of international variations some lat/lon coordinates may be approximate as they have been read from sources that vary in scale and in geodetic quality. These coordinates may be used to approximately locate features on medium and large-scale maps and/or for distance calculations. Coordinates have been read at the map symbol for populated places, point features, and features occupying limited extent. Coordinates for linear features such as rivers also include pairs of source coordinates taken at their mouths or lower reaches. Locations of area features are represented by the coordinates of their approximate center. |
FeatureType table |
| Field | Data type | Field description |
| FeatureType_str_code |
varchar(5) |
Unique key value for FeatureType table |
| FeatureType_str_type |
varchar(35) |
Classification for the type of city |
| FeatureType_str_name |
varchar(50) |
Recognized name of the type of city |
| FeatureType_str_description |
varchar(255) |
Description of the type of city |
Admin1 table |
| Field | Data type | Field description |
| Admin1_str_code |
varchar(5) |
Unique key value for Admin1 table |
| Country_str_code |
varchar(2) |
Foreign key value into Country table. See Country fields. |
| Admin1_str_type |
varchar(50) |
Type of first level administrative division, such as a 'state' in the United States or a 'province' in the Netherlands |
| Admin1_str_local_type |
varchar(50) |
Admin1_str_type using local native language characters and spelling. May contain special foreign characters with diacritic marks. |
| Admin1_str_name |
varchar(100) |
Recognized name of the first level administrative division |
Admin2 table (see details) |
| Field | Data type | Field description |
| Admin2_str_code |
varchar(8) |
Unique key value for Admin2 table |
| Admin1_str_code |
varchar(5) |
Foreign key value into Admin1 table. See Admin1 fields. |
| Country_str_code |
varchar(2) |
Foreign key value into Country table. See Country fields. |
| Admin2_str_type |
varchar(50) |
Type of second level administrative division, such as a 'county' within a state in the United States or a 'municipality' within a province in the Netherlands |
| Admin2_str_local_type |
varchar(50) |
Admin2_str_type using local native language characters and spelling. May contain special foreign characters with diacritic marks. |
| Admin2_str_name |
varchar(100) |
Recognized name of the second level administrative division |
Country table |
| Field | Data type | Field description |
| Country_str_code |
varchar(2) |
Unique key value for Country table |
| Region_str_code |
varchar(3) |
Foreign key value into Region table. See Region fields. |
Country_str_
ISO3166_2char_code |
varchar(2) |
The two-letter alpha code maintained by the International Organization for Standardization (ISO) using the ISO-3166 Alpha-2 standard |
Country_str_
ISO3166_3char_code |
varchar(3) |
The three-letter alpha code maintained by the International Organization for Standardization (ISO) using the ISO-3166 Alpha-3 standard |
Country_str_
ISO3166_numeric_code |
varchar(3) |
The numeric code maintained by the International Organization for Standardization (ISO) using the ISO-3166 Numeric standard |
| Country_str_type |
varchar(30) |
Specifies whether the country is an independent state or a dependency |
| Country_str_name |
varchar(100) |
Recognized short name of the country |
| Country_str_local_name |
varchar(100) |
Country_str_name using local native language characters and spelling. May contain special foreign characters with diacritic marks. |
| Country_str_long_name |
varchar(100) |
Recognized full name of the country |
Country_str_
local_long_name |
varchar(150) |
Country_str_long_name using local native language characters and spelling. May contain special foreign characters with diacritic marks. |
Country_str_
controlling_entity |
varchar(25) |
The name of the controlling country if country_str_type indicates a dependency |
| Country_str_former_name |
varchar(100) |
Previous country name, where applicable |
Country_str_
name_abbreviation |
varchar(25) |
Short abbreviation of country name |
CountryNotes table |
| Field | Data type | Field description |
| Country_str_code |
varchar(2) |
Foreign key value into Country table. See Country fields. |
| Country_txt_location |
text |
Location, neighboring countries, and adjacent bodies of water |
| Country_txt_government_type |
text |
The basic form of government (e.g., republic, constitutional monarchy, federal republic, parliamentary democracy, military dictatorship) |
Country_txt_
government_type_notes |
text |
Notes on government type |
| Country_str_capital |
varchar(200) |
The location of the seat of government |
| Country_txt_dependency_status |
text |
The status of the country if dependent upon another entity |
Country_txt_
dependency_status_notes |
text |
Notes on dependency status |
| Country_txt_dependent_areas |
text |
Alphabetical listing of any non-independent entities associated with country |
Country_txt_
dependent_areas_notes |
text |
Notes on dependent areas |
Country_str_
internet_country_code |
varchar(10) |
The two-letter alpha code maintained by the International Organization for Standardization (ISO) using the ISO-3166 Alpha-2 standard and used by the Internet Assigned Numbers Authority (IANA) to establish country-coded top-level domains (ccTLDs) |
| Country_str_population |
varchar(200) |
An estimate from the US Bureau of the Census based on statistics from population censuses, vital statistics registration systems, or sample surveys pertaining to the recent past and on assumptions about future trends. The total population presents one overall measure of the potential impact of the country on the world and within its region. |
| Country_txt_languages |
text |
List of languages sorted by greatest usage |
| Country_txt_languages_notes |
text |
Notes on country languages |
| Country_str_currency |
varchar(100) |
Identifies the national medium of exchange and its basic subunit |
| Country_str_currency_code |
varchar(25) |
The alpha code maintained by the International Organization for Standardization (ISO) using the ISO-4217 Alpha standard that represents the currency code |
| Country_txt_currency_notes |
text |
Notes on country currency |
| Country_txt_background |
text |
Highlights major historic events and current issues and may include a statement about one or two key future trends |
| Country_txt_climate |
text |
Description of typical weather patterns throughout the year |
| Country_txt_terrain |
text |
Description of the topography |
Country_str_
nationality_noun |
varchar(100) |
Identifying term for country's citizens |
Country_str_
nationality_adjective |
varchar(100) |
Descriptive term for country's citizens |
| Country_str_land_area |
varchar(100) |
The aggregate of all surfaces delimited by international boundaries and/or coastlines, excluding inland water bodies (lakes, reservoirs, rivers) |
| Country_str_water_area |
varchar(50) |
The sum of all water surfaces delimited by international boundaries and/or coastlines, including inland water bodies (lakes, reservoirs, rivers) |
| Country_str_total_area |
varchar(100) |
The sum of all land and water areas delimited by international boundaries and/or coastlines |
| Country_txt_area_notes |
text |
Additional notes concerning country areas |
Country_str_
land_boundaries_total |
varchar(25) |
The total length of all land boundaries |
Country_str_
land_boundaries_border_countries |
varchar(350) |
The individual lengths for each of the contiguous border countries |
| Country_str_coastline |
varchar(150) |
The total length of the boundary between the land area (including islands) and the sea |
| Country_txt_independence |
text |
The date of sovereignty, unification, federation, confederation, establishment, fundamental change in the form of government, or state succession. Dependent areas include the notation 'none'. |
| Country_txt_independence_notes |
text |
Notes on independence |
| Country_txt_national_holiday |
text |
Primary national day of celebration - usually independence day |
| Country_txt_constitution |
text |
The dates of adoption, revisions, and major amendments |
| Country_txt_constitution_notes |
text |
Notes on constitution |
| Country_str_general |
text |
General information about the country |
Region table |
| Field | Data type | Field description |
| Region_str_code |
varchar(3) |
Unique key value for Region table |
| Region_str_name |
varchar(50) |
Region name |
TIMEZONE table |
| Field | Data type | Field description |
| Timezone_int_id |
varchar(3) |
Unique key value for Timezone table |
| Timezone_str_standard_offset |
varchar(10) |
Standard time offset from UTC (GMT) in +/-HHMM (hour/min) format |
| Timezone_str_standard_code |
varchar(10) |
Standard time zone code |
| Timezone_str_standard_name |
varchar(100) |
Standard time zone name |
| Timezone_str_DST_observed |
varchar(3) |
Indicates if Daylight Saving Time is observed (yes/no) |
| Timezone_str_DST_offset |
varchar(10) |
If DST observed, daylight saving time offset from UTC (GMT) in +/-HHMM (hour/min) format |
| Timezone_str_DST_code |
varchar(10) |
If DST observed, daylight saving time zone code |
| Timezone_str_DST_name |
varchar(100) |
If DST observed, daylight saving time zone name |
| Timezone_str_DST_start_date |
varchar(10) |
If DST observed, daylight saving time start date |
| Timezone_str_DST_end_date |
varchar(10) |
If DST observed, daylight saving time end date |
| |
Corporate Edition
Corporate Edition
Corporate Edition
