Connections between descriptive gazetteer entries and administrative units

Table ID:

G_DGAZ_LINK_2015     (1247913)

Contents:

Connections between descriptive gazetteer entries and administrative units

Approx. number of rows:

164,192

Table type:

Raw Data

Documentation Author:

Humphrey Southall

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:

Index	Type	Column(s) indexed
g_dgaz_link_2015_pkey	Primary key	g_unit, g_text_id
g_dgaz_link_2015_g_text_id_g_unit_idx	Unique	g_text_id, g_unit

---

Constraints:

The table has the following associated constraints:

Constraint	Type	Details
g_dgaz_link_2015_pkey	Primary Key	See details above for primary key index
g_dgaz_link_2015_fk1	Foreign Key	Column(s) {2} link to table g_dgaz_2015, column(s) {2}.

---

Columns within table:

Column	Type	Contents
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.