Pre-Positioned Country files format (Unicode UTF-8)
Note:
- The pre-positioned files, including the single large file, are delimited using Tabs.
Field Name | Field Description | Field Type |
Maximum
Field Length /Precision |
RC |
Region Font Code. A code that determines the equivalent characters
used when generating the SORT and NO DIACRITICS (ND) feature names information rendered
in Roman script. |
Number | 1 |
UFI | Unique Feature Identifier. A number which uniquely identifies a feature. | Number | 38 |
UNI | Unique Name Identifier. A number which uniquely identifies a feature name. | Number | 38 |
LAT |
Latitude of the feature in ± decimal degrees; DD; (± dd.dddddd): no sign (+) = North; negative sign (-) = South |
Number | 10 |
LONG |
Longitude of the feature in ± decimal degrees; DD; (± ddd.dddddd): no sign (+) = East; negative sign (-) = West. |
Number | 11 |
DMS_LAT |
Latitude of the feature in degrees, minutes, seconds and hemisphere (DMSH) - dd:mm:ssH,
where H is either N (North) or S (South)
Note: In this format, DMSH values should be interpreted from left to right. |
Character (VARCHAR2) |
9 |
DMS_LONG |
Longitude of the feature in degrees, minutes, seconds and hemisphere (DMSH) - ddd:mm:ssH,
where H is either E (East) or W (West)
Note: In this format, DMSH values should be interpreted from left to right. |
Character (VARCHAR2) |
10 |
MGRS | Military Grid Reference System coordinates. MGRS is an alpha-numeric system for expressing UTM/UPS coordinates. A single alpha-numeric value references an area that is unique for the entire earth. |
Character (VARCHAR2) |
15 |
JOG | Joint Operations Graphic reference. |
Character (VARCHAR2) |
7 |
FC |
Feature Class: Nine (9) major feature categories into which similar
feature designations are grouped. |
Character (VARCHAR2) |
1 |
DSG | Feature Designation Code. A two to five-character code used to identify the type of feature a name is applied to. For a description of these codes/values, please see the "Look-up Tables..." section on the GNS Offered Services page. |
Character (VARCHAR2) |
6 |
PC | Populated Place Class. A numerical scale identifying the relative importance of a populated place. The scale ranges from 1 (high) to 5 (low). The scale can also include NULL (no value) as a value for populated places with unknown or undetermined relative importance. | Number | 1 |
CC1 |
Primary Geopolitical Code. A two alphabetic character code from the
Geopolitical Entities and Codes (formerly FIPS 10-4 standard) that uniquely
identifies a feature's primary geopolitical entity (countries, dependencies, andr
areas of special sovereignty). This field can contain one, or multiple comma separated non-spaced country codes to identify international (shared) features that run through multiple countries for up to 255 characters (example: Danube River - AU,BU,EZ…). For a description of these codes/values, please see the "Look-up Tables..." section on the GNS Offered Services page. |
Character (VARCHAR2) |
255 |
ADM1 | Primary administrative division code. A two character alpha-numeric code from the Geopolitical Entities and Codes (formerly FIPS 10-4 standard) that describes the primary administrative division of a feature, similar to a state level in the United States. For a description of these codes/values, please see the "Look-up Tables..." section on the GNS Offered Services page. |
Character (VARCHAR2) |
2 |
POP | Population figures (no longer maintained; contains no values). | Number | 38 |
ELEV | Elevation in meters (no longer maintained; contains no values). |
Number (FLOAT) |
126 |
CC2 |
Secondary Geopolitical Code. A two alphabetic character code from the
Geopolitical Entities and Codes (formerly FIPS 10-4 standard) that uniquely
identifies the particular feature name that is applicable in a particular geopolitical
entity, or entities, for international features.
This field can contain one, or multiple comma separated non-spaced country codes to identify international (shared) features that run through multiple countries for up to 255 characters (example: Donau – AU,GM… to identify the Austrian and German name for the Danube River). For a description of these codes/values, please see the "Look-up Tables..." section on the GNS Offered Services page. |
Character (VARCHAR2) |
255 |
NT |
Name Type:
|
Character (VARCHAR2) |
2 |
LC |
Language Code. A three alphabetic character code (ISO 639-3) uniquely identifying the language assigned to a feature name. For a description of these codes/values, please see the "Look-up Tables..." section on the GNS Offered Services page. |
Character (VARCHAR2) |
3 |
SHORT_FORM | A part of the full name that could substitute for the full name. |
Character (VARCHAR2) (Unicode UTF-8) |
128 |
GENERIC | The descriptive part of the full name such as Cerro (mountain), Arroyo (river), or Golfo (gulf) (generally does not apply to populated place names or English based generics). |
Character (VARCHAR2) (Unicode UTF-8) |
128 |
SORT_NAME_RO | Sort name - reading order. A form of the full name that allows for alphabetical sorting of the file into gazetteer sequence. For Roman script names, all character/diacritic combinations and special characters are substituted with QWERTY (visible U.S. English keyboard) characters, all characters are upper-cased, numerals are converted to lower-case characters (0-9 = a-j), spaces and hyphens are stripped out, and commas replaced with a space. Additionally, for non-roman script names in languages using Arabic based letters. , vowel markings/pointers are removed. This field is included for the benefit of the end user of the data to aid in the sorting of names if required. |
Character (VARCHAR2) |
255 |
FULL_NAME_RO | Full name - reading order. The full name is the complete name that identifies a named feature. The full name is output in reading order, "Mount Everest", vs. reversed generic, "Everest, Mount". |
Character (VARCHAR2) (Unicode UTF-8) |
255 |
FULL_NAME_ND_RO | Full name - reading order with no diacritics. Same as the full name but the character/diacritic combinations and special characters are substituted with QWERTY (visible U.S. English keyboard) characters while still maintaining casing and spaces. This field also includes non-roman script based names which are stripped of vowel markings. |
Character (VARCHAR2) |
255 |
SORT_NAME_RG | Sort name - reversed generic. A form of the full name that allows for alphabetical sorting of the file into gazetteer sequence. For Roman script names, all character/diacritic combinations and special characters are substituted with QWERTY (visible U.S. English keyboard) characters, all characters are upper-cased, numerals are converted to lower-case characters (0-9 = a-j), spaces and hyphens are stripped out, and commas replaced with a space. Additionally, for non-roman script names in languages using Arabic based letters, vowel markings/pointers are removed. This field is included for the benefit of the end user of the data to aid in the sorting of names if required. |
Character (VARCHAR2) |
255 |
FULL_NAME_RG | Full name - reversed generic. The full name is the complete name that identifies a named feature. The full name is output in reversed generic, "Everest, Mount" vs. reading order, "Mount Everest." |
Character (VARCHAR2) (Unicode UTF-8) |
255 |
FULL_NAME_ND_RG | Full name - reversed generic with no diacritics. Same as the full name but the character/diacritic combinations and special characters are substituted with QWERTY (visible U.S. English keyboard) characters while still maintaining casing and spaces. This field also includes non-roman script based names which are stripped of vowel markings. |
Character (VARCHAR2) |
255 |
NOTE | This field holds a geopolitical policy note concerning the feature, populated when CC1 and ADM1 are NULL, and it could contain multiple notes. If multiple notes are present, they will be delimited by semicolon followed by four spaces (1:note1; 2:note2; 3:note3; etc...). |
Character (VARCHAR2) (Unicode UTF-8) |
4000 |
MODIFY_DATE | The date a new feature was added or any part of an existing feature was modified (YYYY-MM-DD). |
Character (VARCHAR2) |
10 |
DISPLAY |
Comma-separated non-spaced scale range values to aid in the visualization and selection
of features. The display values range from 1 to 9, and are listed as 1,2,3,4,5,6,7,8,9. |
Character (VARCHAR2) |
255 |
NAME_RANK | A numeric value (1 - n) used to facilitate the display/visualization of the names associated with a feature. | Number | 38 |
NAME_LINK | Unique Name Identifier (UNI) that links romanized names to their non-Roman script equivalent and vice-versa. | Number | 38 |
TRANSL_CD | Transliteration Code. This value indicates which transliteration system was used to arrive at the romanized equivalent of a non-Roman Script name. |
Character (VARCHAR2) |
32 |
NM_MODIFY_DATE | The date a new name was added or any part of an existing name was modified (YYYY-MM-DD). |
Character (VARCHAR2) |
10 |
F_EFCTV_DT | Feature effectivity date. The documented date a feature came into existence (YYYY-MM-DD). |
Character (VARCHAR2) |
10 |
F_TERM_DT | Feature termination date. The date a feature could no longer be verified on cartographic source or imagery (YYYY-MM-DD). |
Character (VARCHAR2) |
10 |