NGA Banner
NGA Banner



agency bullet 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.
1 = Americas/Western Europe;
2 = Eastern Europe;
3 = Africa/Middle East;
4 = Russia/ Central Asia;
5 = Asia/Pacific;
6 = Vietnam.

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, and seconds; DMS; (±ddmmss):
no sign (+) = North;
negative sign (-) = South.

Note: DMS values, in the provided format, are not left padded with zeros, and should be interpreted from right to left.

For example: A value of 430 would be interpreted as 4 minutes 30 seconds (from right to left: 30 seconds 4 minutes).
Number 7
DMS_LONG Longitude of the feature in ± degrees, minutes, and seconds; DMS; (±dddmmss):
no sign (+) = East;
negative sign (-) = West.

Note: DMS values, in the provided format, are not left padded with zeros, and should be interpreted from right to left.

For example: A value of 430 would be interpreted as 4 minutes 30 seconds (from right to left: 30 seconds 4 minutes).
Number 8
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 Classification: Nine (9) major feature categories into which similar feature designations are grouped.
A = Administrative region
P = Populated place
V = Vegetation
L = Locality or area
U = Undersea
R = Streets, highways, roads, or railroad
T = Hypsographic
H = Hydrographic
S = Spot

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 Classification.  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, and 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:
C = Conventional: A commonly used English-language name approved by the U.S. Board on Geographic Names (BGN) for use in addition to, or in lieu of, a BGN-approved local official name or names, e.g., Rome, Alps, Danube River.
N = Approved: The BGN-approved local official name for a geographic feature. Except for countries with more than one official language; there is normally only one such name for a feature wholly within a country.
D = Unverified: A name from a source whose official status cannot be verified by the BGN.
P = Provisional: A geographic name of an area for which the territorial status is not finally determined or not recognized by the United States.

VA = Anglicized variant: An English-language name that is derived by modifying the local official name to render it more accessible or meaningful to an English-language user.
V = Variant: A former name, name in local usage, or other spelling found on various sources.

NS = Non-Roman Script: The non-Roman script form of the BGN-approved local official name for a geographic feature. Except for countries with more than one official language; there is normally only one such name for a feature wholly within a country.
DS = Unverified Non-Roman Script: The non-Roman script form of a name from a source whose official status cannot be verified by the BGN.
VS = Variant Non-Roman Script: The non-Roman script form of a former name, name in local usage, or other spelling found on various sources.

For a description of these codes/values, please see the "Look-up Tables..." section on the GNS Offered Services page.

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 are stripped out, and commas replaced with a space.  This field also includes non-roman script based names which are stripped of vowel markings/pointers for languages using Arabic based letters. 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 Latin based 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 are stripped out, and commas replaced with a space. This field also includes non-roman script based names which are stripped of vowel markings/pointers for languages using Arabic based letters. 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.

The display values correspond to the following scale ranges:
1 – 1 - 25,999
2 – 26,000 - 67,999
3 – 68,000 - 150,999
4 – 151,000 - 225,999
5 – 226,000 - 325,999
6 – 326,000 - 425,999
7 – 426,000 - 625,999
8 – 626,999 - 999,999
9 - 1,000,000 or Smaller

Examples:
A feature with display value of 1 should appear in a visualization client or service between scales of 1 and 25,999. It should not appear at scales of 26,000 and smaller.

A feature with display values of 1,2,3 should appear in a visualization client or service between scales of 1 through 150,999. It should not appear at scales of 160,000 and smaller.

A feature with display values of 1,2,3,4,5,6,7,8,9 should appear in a visualization client or service at all scales.

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
 
 
Point of Contact: GEOnet Names Server
NGA Campus East
phone 571-557-5959, DSN 547-5959
geonames@nga.mil

Document last modified October 24, 2014

NGA Home
NGA Footer