Connections between descriptive gazetteer entries and administrative units

Table ID:
G_DGAZ_LINK_2015     (58088)
Contents:
Connections between descriptive gazetteer entries and administrative units
Approx. number of rows:
164,189
Table type:
Raw Data
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 1881 to 1911.

Notes:

  1. The contents of this table was mostly inserted by various scripts which analysed the text of descriptive gazetteer entries to find references to administrative units, and then matched these in the AUO.
  2. When this archive version was created in 2016, seven of these links were to units which no longer existed in our working version of the AUO. These were checked carefully and deleted or updated as appropriate, so this table should now link perfectly to the AUO.


Indices:

IndexTypeColumn(s) indexed
g_dgaz_link_2015_pkey Primary key g_unit, g_text_id


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
g_dgaz_link_2015_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
g_unit Integer number. ID of the administrative unit the entry is linked to, as defined in the AUO.
g_text_id Integer number. Numerical identifier uniquely identifying the gazetteer entry this link is for.
g_link_status Text string (max.len.=6). "Status" of the link: "M" = main, meaning that the entry is about the unit. "S" = subsidiary, meaning the entry is about somewhere withing the units.
created_by Text string (max.len.=44). Name of the script which inserted this particular row into the original version of this table.