Copy of the Vision of Britain g_place table prior to 2016 rebuild.

Table ID:
G_PLACE_2015     (58160)
Contents:
Copy of the Vision of Britain g_place table prior to 2016 rebuild.
Approx. number of rows:
22,373
Table type:
Gazetteer
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 1881 to 1911.

Sources:

  1. The "places" table has been built up by the Great Britain Historical GIS Project over many years, and although the methods used are summarised below there has been much manual editing and various subjective decisions, so it needs to be treated as primary data.


Notes:

  1. The first version was created in 2004 by systematically querying the original version of the AUO roughly as follows:
    • Begin by selecting all urban local government districts which existed in 1911 as an initial master set of places, and associate with them as many as possible of the other units in the system for the same "place"; for examples, the parishes associated with the town, the earlier Registration District/Poor Law Union of the same name, the Rural District covering the surrounding rural area, and so on.
    • Next add those urban local government districts which did not exist in 1911, and similarly associate other units.
    • Repeat for Civil Parishes which were not already associated with one of the the "urban" places, so adding in most villages.
    • Analoguous procedures were followed for Scotland.
  2. However, the places table which now exists has been subject to much manual tidying, for example finding "places" which had been defined from parishes called "XXXX RURAL" and merging them with "XXXX", or by identifying parishes/places in very close proximity distinguished only by a saint's dedication, as at Sawtry.
  3. It was then very substantially extended by various strategies:
    • Working manually through units in the AUO which were not already associated with places, and creating new places to which they could be linked. For example, adding small settlements which gave their names only to an Ecclesiastical Parish.
    • Finding settlements which had never given their names to any administrative unit but which had a descriptive gazetteer entry above some length threshold.
    • Working systematically through travel narratives defining additional "places" for the locations visited. This led to a substantial number of country estates/stately homes being added.


Indices:

IndexTypeColumn(s) indexed
g_place_2015_pkey Primary key g_place


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
g_place_2015_pkey Primary Key See details above for primary key index
enforce_dims_g_point Check (public.st_ndims(g_point) = 2)
enforce_dims_g_point_uk Check (public.st_ndims(g_point_uk) = 2)
enforce_geotype_g_point Check ((public.geometrytype(g_point) = 'POINT'::text) OR (g_point IS NULL))
enforce_geotype_g_point_uk Check ((public.geometrytype(g_point_uk) = 'POINT'::text) OR (g_point_uk IS NULL))
enforce_srid_g_point Check (public.st_srid(g_point) = 3034)
enforce_srid_g_point_uk Check (public.st_srid(g_point_uk) = 27700)



Columns within table:

ColumnTypeContents
g_place Integer number. Number identifying the place: originally created from a sequence number.
g_name Text string (max.len.=404). Primary name of the place. In the original construction, this would be the preferred name of the unit the place was defined from, but these names have been substantially revised and are now, in general, the most commonly used name for the place from across the range of sources we hold.
seed_unit Integer number. The unit ID from the AUO for the unit from which the place was originally defined (see above). Null for many of the more recently defined places.
g_state Integer number. ID number of the state containing the place; mostly the ID for the United Kingdom.
state_name Text string (max.len.=44). [No description available]
is_state Text string (max.len.=6). [No description available]
g_domain Integer number. [No description available]
domain_name Text string (max.len.=44). [No description available]
is_domain Text string (max.len.=6). [No description available]
g_nation Integer number. [No description available]
nation_name Text string (max.len.=44). [No description available]
is_nation Text string (max.len.=6). [No description available]
g_county Integer number. [No description available]
county_name Text string (max.len.=44). [No description available]
is_county Text string (max.len.=6). [No description available]
g_district Integer number. [No description available]
district_name Text string (max.len.=44). [No description available]
is_district Text string (max.len.=6). [No description available]
district_type Text string (max.len.=24). [No description available]
mod_dist Integer number. [No description available]
x_uk Floating point number. [No description available]
y_uk Floating point number. [No description available]
dg_text_id Integer number. [No description available]
dg_text Long text. [No description available]
dg_text_auth Text string (max.len.=104). [No description available]
tt_count Integer number. [No description available]
pop_for_near_calcs Floating point number. [No description available]
g_container Text string (max.len.=44). [No description available]
created_by Text string (max.len.=44). [No description available]
g_point geometry [No description available]
g_point_uk geometry [No description available]
rank Integer number. [No description available]
near_place Integer number. [No description available]
dg_count Integer number. [No description available]
has_multiple_names Text string (max.len.=6). [No description available]
dg_text_set_manually Text string (max.len.=6). [No description available]
dg_text_id_candidate Integer number. [No description available]
dgaz_text Integer number. [No description available]
see_also_place Integer number. [No description available]
g_point_auth Text string (max.len.=44). [No description available]
g_point_note Text string (max.len.=44). [No description available]
html_for_nearby_places Long text. [No description available]
html_for_containing_units Long text. [No description available]
html_for_containing_constituencies Long text. [No description available]
notes Long text. [No description available]
p_place Integer number. [No description available]