Standardised Names for Administrative Counties

Table ID:

ADM_CNTY_GAZ     (28134)

Contents:

Standardised Names for Administrative Counties

Approx. number of rows:

214

Table type:

Gazetteer

Documentation Author:

Humphrey Southall

Sources:

1. This is a new table constructed at Portsmouth, and is based on querying all fields in the database that have an 'adm_cnty' field.

---

Notes:

1. This gazetteer standardises county names but does not have any other functions, such as aggregation.

---

Indices:

Index	Type	Column(s) indexed
adm_cnty_gaz_pkey	Primary key	name

---

Constraints:

The table has the following associated constraints:

Constraint	Type	Details
adm_cnty_gaz_pkey	Primary Key	See details above for primary key index

---

Columns within table:

Column	Type	Contents
name	Text string (max.len.=64).	The "raw" spelling of the county name.
nation	Text string (max.len.=6).	Flag field indicating whether county is in England ('E'), Wales ('W') or Scotland ('S').
standard	Text string (max.len.=28).	The standardised spelling. This is null for names that were Registration or Ancient counties, but not Administrative Counties.
gis_name	Text string (max.len.=34).	An alternative standardised version of the name, as used within the GIS. This differs from 'standard' for the three parts of Lincolnshire, the three Ridings of Yorkshire and Glamorgan.
notes	Long text.	Notes.