Geographic Names Processing System - Phase IV

GNPS IV

Geographic Information Systems (GIS) Spacial Output Format


Note:


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.