Geographic Names Processing System - Phase IV
GNPS IV
Geographic Information Systems (GIS) Spacial Output Format
Note:
The data format is tab-delimited ASCII.
Field Name and Description
Field Name
Field Description
RC
Region Code - tinyint.
A code that determines the character mapping used in the Full_Name
field (refer to REGIONS.PDF for character
mapping):
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 (refer to REGIONS.PDF
for character mapping).
FULL_NAME_ND
varchar(200) - Same as the full name but the diacritics and special characters are
substituted with Roman characters (refer to REGIONS.PDF
for character mapping). ND = No Diacritics / Stripped Diacritics.