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): |
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: |
DLONG |
Decimal Longitude
of the feature in ± decimal degree: |
LAT |
Latitude - int(4)
of the feature in ± degree, minuets, and seconds: |
LONG |
Longitude - int(4)
of the feature in ± degree, minuets, and seconds: |
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): |
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): |
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. |
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. |