The many products we offer

Other Tables Supplemental data in the HIS Registry of Geography.

Email | Print | More

The registry contains two supplementary tables.

ROG_PoliticalXref: ROG Political Cross-Reference Index

This supplementary table offers an cross-reference between the HIS codes and names for geopolitcal region and alternate codes and names.

 

The ROG Cross-Reference Index contains the following four columns:

Column Format Description
Code char(16) HIS geopolitical region code
CodeRel char(1)

A one-character code that indicates the relationship between the geopolitical area represented by the HIS code and the most nearly corresponding code(s) in another system.

< The HIS code describes a smaller area than the alternate code. There are probably additional records in this table relating other HIS entities related to the same alternate code entity.
=   The HIS code describes substantially the same area as the alternate code.
> The HIS code describes a larger area than the alternate code. There are probably additional records in this table relating other alternate code entities to the same HIS entity.
AltCode varchar(45)  A code representing a region that at least partially overlaps, and might potentially be of use in encoding, the area designated by the corresponding HIS code. If the record represents an alternate name for a region from a source which does not associate the name with a code, the code field will be left empty.
Source char(8)  Source for this record.
NameType char(2) The type of name represented by this record. In many cases, sources do not clearly distinguish name types; in such cases, the name type assigned is likely to be based on the Steward's best assessment of the predominant name type of the source, rather than an individual assessment of each record.
C Conventional. A name as conventionally used by English Speakers
CL   Conventional, Long. The long form name, where a source provides both a long-form and short-form conventional name.
CS Conventional, Short. The short- form name, where a source provides both a long-form and short-form conventional name.
N Native. The name of the location transliterated from a local or national language.
V Variant or Alternate. Variant spelling, alternate name, former name, etc.
D   Dagger (not verified). Name not verified from a recent local official source
Name varchar(128) A transliteration of the region name represented in standard ASCII with all diacritics removed. Some symbols may be included, such as the apostrophes, exclamation points, or other ASCII characters to represent speech sounds not present in English.
NameD varchar(254) A transliteration of the region name into Latin characters with diacritics. See notes for the field of the same name in the ROG_Politcal table for notes on character encoding and fonts.
NameDChar char(1) The character encoding used to represent the diacritical form of the name. See notes for the field of the same name in the ROG_Political table for permitted values.
NIMA_Reg integer For NIMA-derived names, the region code identifying the original regional character set from which the HTML-encoded Unicode name was derived.

 

The SQL statement for creating this table is as follows:

CREATE TABLE ROG_PoliticalXref(
Code char(16)NOT NULL,
CodeRel char(1)NOT NULL,
AltCode varchar(45),
Source char(8) NOT NULL,
NameType char(2)NOT NULL,
Name varchar(128)NOT NULL,
NameD varchar(254)NOT NULL,
NameDChar char(1)NOT NULL,
NIMA_Reg integer)

The following shows the entries in the name index for Tromelin Island, an entity with an assigned HIS Code, but which is considered part of Réunion in the ISO coding scheme:

Code CodeRel AltCode Source NameType Name            NameD	         NameDChar NIMA_Reg
TE < RE ISO_A2 CS Reunion Réunion I 0
TE < REU ISO_A3 CS Reunion Réunion I 0
TE = TE NIMA C Tromelin Island Tromelin Island H 1
TE = TE NIMA N Ile Tromelin Île Tromelin H 1

We see that TE also has two alternate names originating from the NIMA names table, one a conventional English name and one the local (French) name. Each of these is represented in both diacritic-stripped and diacritical form. Both Name and NameD fields will be populated even if the name contains no characters with diacritics.

Column Format Description
Source char(8) Source Designation code
Description varchar(128) Description of source
URL char(254) A URL, if available, from which one can obtain further information (and possibly updated data) pertaining to a source.
Notes char(254) Notes about the source

 

The SQL statement for creating this table is as follows:

CREATE TABLE ROG_Sources (
Source char(8) NOT NULL,
Description varchar(128) NOT NULL,
URL varchar(254),
Notes varchar(254))

The following shows the entries in the name index for the three typical sources. Notes field is word wrapped for presentation here, but continuous in data:

Source   Description                                   URL                                            Notes                          
-------- ----------- ---------------------- -----
HIS Codes/Names assigned by HIS Steward http://www.gmi.org/HIS
NIMA_C_L NIMA GeoNet Names Server Country Lookup table http://gnpswww.nima.mil/geonames/GNS/index.jsp From URL indicated, choose
Country Codes under
"Lookup Tables", enter blank
form.
NIMA_A_L NIMA GeoNet Names Server ADM1 Lookup table http://gnpswww.nima.mil/geonames/GNS/index.jsp From URL indicated, choose
"ADM1 Codes" under "Lookup
Tables", enter blank form.
Note that names are in
proprietary NIMA code sets.