| Field Name |
Field Description |
| RC |
Region
Code - tinyint. A code that determines the character mapping
used in the full nam field
1 = Western
Europe/Americas;
2 = Eastern
Europe;
3 = Africa/Middle
East;
4 = Central
Asia;
5 = Asia/Pacific;
6 = Vietnam. |
| UFI |
Unique
Feature Identifier - int(4). A number which uniquely identifies
the feature. |
| UNI |
Unique
Name Identifier - int(4). A number which uniquely identifies
a name. |
| DLAT |
Decimal
Latitude of the feature in ± decimal degree:
no sign (+)
= North;
negative sign
(-) = South. |
| DLONG |
Decimal
Longitude of the feature in ± decimal degree:
no sign (+)
= East;
negative sign
(-) = West. |
| LAT |
Latitude
- int(4) of the feature in ± degree, minuets, and seconds:
no sign (+)
= North;
negative sign
(-) = South. |
| LONG |
Longitude
- int(4) of the feature in ± degree, minuets, and seconds:
no sign (+)
= East;
negative sign
(-) = West. |
| MGRS |
Military
Grid Reference System. |
| UTM |
Universal
Transverse Mercator - char(4) coordinate grid reference. |
| JOG |
Joint
Operations Graphic - char(7) reference. |
| FC |
Feature
Classification - char(1):
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 feature. |
| DSG |
Feature
Designation Code - char(5). A two to five-character code
used to identify the type of feature a name is applied to. |
| PC |
Populated
Place Classification - tinyint(1).
A graduated numerical scale denoting the relative importance of a populated
place. The scale ranges from 1, relatively high, to 5, relatively
low. The scale could also include NULL (Blank) as a value for populated
places with unknown or undetermined classification. |
| CC1 |
Primary
Country Code - char(2). A two alphabetic character code uniquely
identifying a geopolitical entity (countries, dependencies, and areas of
special sovereignty). |
| ADM1 |
First-order
administrative division - char(2). A two alphanumeric character
code uniquely identifying a primary administrative division of a country,
such as a state in the United States. |
| ADM2 |
Second-order
administrative division - varchar(255). A subdivision of
a first-order administrative division, such as a county in the United States. |
| DIM |
Dimension
- int(4). Usually used to display elevation or population
data. |
| CC2 |
Secondary
Country Code -char(2). A two alphabetic character code uniquely
identifying the country code of a particular name if different than that
of the feature. |
| NT |
Name
Type - char(1):
C = Conventional;
D = Dagger
or not verified;
N = Native;
V = Variant
or alternate. |
| LC |
Language
Code - char(2). A two alphabetic character code uniquely
identifying a language of a country if multiple official languages
are used. |
| SHORT_FORM |
varchar(128)
- A specific part of the name that could substitute for the full name. |
| GENERIC |
varchar(128)
- The descriptive part of the full name (does not apply to populated place
names). |
| SORT_NAME |
varchar(200)
- 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. It is in reading order. |
| FULL_NAME |
varchar(200)
- 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. It is in reading order |
| FULL_NAME_ND |
varchar(200)
- Same as the full name but the diacritics and special characters are substituted
with Roman characters ND = No Diacritics / Stripped Diacritics. |
