Column | Type | Contents |
g_authority |
Text string (max.len.=44). |
Identifier for the gazetteer from which the entry is drawn,
as defined in the auo.g_authority table which
provides full publication details.
|
g_text_id |
Integer number. |
Numerical identifier uniquely identifying the entry.
|
g_adl_ft |
Text string (max.len.=44). |
Feature type for the entry taken from the
Gazetteer Feature Type Thesaurus developed
by the Alexandria Digital Library.
|
g_ft_text |
Text string (max.len.=124). |
The part of the actual entry text saying what kind of feature the
entry is about.
|
g_text_len |
Integer number. |
Total length of the entry in number of characters.
|
g_text |
Long text. |
Text of the entry, held as HTML.
NB the Edinburgh entry in Groome' gazetteer
contains over 100,000 words, and many of
the longer entries include statistical tables
and even poems.
|
g_place |
Integer number. |
Identifier for the "place" the entry is about,
as defined in g_place_2015.
|
idxfti |
tsvector |
[Column used by the Postgres free text indexing system]
|
non_place |
Text string (max.len.=6). |
Flag identifying entries which are not
about places; for example, generic place names.
|
g_header |
Text string (max.len.=260). |
The first part of the actual entry text, stating the place name or names.
This is our original version, extracted based on capitalisation or
emboldening, depending on the particular gazetteer.
|
new_header |
Text string (max.len.=260). |
Our second attempt to extract the place name or names,
based on extracting whatever text appeared before the text
held in g_ft_text.
|
created_by |
Text string (max.len.=64). |
Name of the script which inserted this particular row into the original
version of this table.
|
domain_name |
Text string (max.len.=14). |
'Britain', 'Ireland' or 'Europe',
depending on where the entry was for, and controlling
which banner, canonical address etc should be used
when presenting the entry online.
|
p_place |
Integer number. |
Wikidata Q_ID, as used in our PastPlace global gazetteer.
Added lomg after the table was created.
|