Codebook classifying standardised version of descriptive gazetteer feature descriptions

Table ID:

G_DGAZ_FT_TEXT_2015     (1247896)

Contents:

Codebook classifying standardised version of descriptive gazetteer feature descriptions

Approx. number of rows:

7,209

Table type:

Codebook

Documentation Author:

Humphrey Southall

Sources:

1. We defined feature type strings as being the text immediately following the place name or names at the start of a descriptive gazetteer entry, which almost always says what kind of feature or place the entry is about. The g_dgaz_ft_text_string_2015 table holds raw feature type strings systematically harvested from our very large collection of such entries, while this table holds standardised versions of those strings, matching each to (a) the most appropriate term in the ADL Gazetteer Feature Type Thesaurus, and (b) a series of flag columns saying whether the entry is for one of a series of types of administrative units.

---

Notes:

1. This table is an exact copy of the table held in the HGIS system at the end of 2015, and is intended as a permanent archive.
2. Assigning strings to the ADL thesaurus was complicated by many entries saying the entity being written about was more than one kind of thing. In these cases, we prioritised physical landscape features over administrative units, and prioritised terms mentioned early within the string. In particular, entries for "a village and parish" would be classified as "populated places".
3. The various is_?? flags enabled us to identify entries which could be linked to our AUO, and hence to the relationships help in g_dgaz_link_2015.

---

Indices:

Index	Type	Column(s) indexed
g_dgaz_ft_text_2015_pkey	Primary key	g_ft_text

---

Constraints:

The table has the following associated constraints:

Constraint	Type	Details
g_dgaz_ft_text_2015_pkey	Primary Key	See details above for primary key index
g_dgaz_ft_text_2015_fk_adl	Foreign Key	Column(s) {2} link to table g_adl_ft_2015, column(s) {1}.
g_dgaz_ft_text_2015_chk_barony	Check	(((is_barony IS NULL) OR (is_barony = 1)))
g_dgaz_ft_text_2015_chk_borough	Check	(((is_borough IS NULL) OR (is_borough = 1) OR (is_borough = 2)))
g_dgaz_ft_text_2015_chk_chapelry	Check	(((is_chapelry IS NULL) OR (is_chapelry = 1)))
g_dgaz_ft_text_2015_chk_county	Check	(((is_county IS NULL) OR (is_county = 1)))
g_dgaz_ft_text_2015_chk_district	Check	(((is_district IS NULL) OR (is_district = 1)))
g_dgaz_ft_text_2015_chk_hundred	Check	(((is_hundred IS NULL) OR (is_hundred = 1)))
g_dgaz_ft_text_2015_chk_liberty	Check	(((is_liberty IS NULL) OR (is_liberty = 1)))
g_dgaz_ft_text_2015_chk_parish	Check	(((is_parish IS NULL) OR (is_parish = 1) OR (is_parish = 2)))
g_dgaz_ft_text_2015_chk_sub_par	Check	(((is_sub_par IS NULL) OR (is_sub_par = 1)))
g_dgaz_ft_text_2015_chk_township	Check	(((is_township IS NULL) OR (is_township = 1)))
g_dgaz_ft_text_2015_chk_tything	Check	(((is_tything IS NULL) OR (is_tything = 1)))

---

Columns within table:

Column	Type	Contents
g_ft_text	Text string (max.len.=204).	Standardised version of gazetteer feature type string.
g_adl_ft	Text string (max.len.=44).	ADL feature type classification.
is_parish	Integer number.	2 if the entry clearly states it was for a parish, without qualification; 1 if it is described as an 'ancient parish', a 'quoad sacra' parish or similar language; and null otherwise.
is_county	Integer number.	1 if the entry is for a county, null otherwise.
is_barony	Integer number.	1 if the entry is for a barony, null otherwise.
is_borough	Integer number.	1 if the entry is for a borough, null otherwise.
is_district	Integer number.	1 if the entry is for a 'district', null otherwise. In 19th century England or Wales this most probably means a Registration District.
is_subdist	Integer number.	1 if the entry is for a Registration sub-District, null otherwise.
is_hundred	Integer number.	1 if the entry is for a hundred, null otherwise.
is_liberty	Integer number.	1 if the entry is for a liberty, null otherwise.
is_township	Integer number.	1 if the entry is for a township, null otherwise.
is_tything	Integer number.	1 if the entry is for a tything, null otherwise.
is_chapelry	Integer number.	1 if the entry is for a chapelry, null otherwise.
is_sub_par	Integer number.	1 if the entry is for a sub-parish unit, null otherwise.