Codebook classifying standardised version of descriptive gazetteer feature descriptions

Table ID:
G_DGAZ_FT_TEXT_2015     (58071)
Contents:
Codebook classifying standardised version of descriptive gazetteer feature descriptions
Approx. number of rows:
7,209
Table type:
Codebook
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 1881 to 1911.

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:

IndexTypeColumn(s) indexed
g_dgaz_ft_text_2015_pkey Primary key g_ft_text


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
g_dgaz_ft_text_2015_pkey Primary Key See details above for primary key index
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:

ColumnTypeContents
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.