search

drkane / geo-lookups

A collection of useful files for using UK Geography
37 stars 3 forks source link

readme

geo-lookups

A collection of data resources for handling small-area UK geography.

Boundary files

A collection of geojson files for local authorities that give the boundaries of wards, LSOAs and MSOAs within that authority.

la_all_codes.csv

A record for each Lower Tier Local Authority that has existed at any time since 2011, with a lookup to the latest Local Authority codes.

Covers England, Northern Ireland, Scotland and Wales.

Fields:

The following columns are included for compatability but are deprecated and can expected to be removed in future versions:

utla_all_codes.csv

A record for each Upper Tier Local Authority.

Covers England, Northern Ireland, Scotland and Wales.

Fields:

lsoa_la.csv

A record for every Lower Super Output Area from the 2011 and 2021 censuses, along with a lookup to the latest Local Authority data.

Covers England, Northern Ireland, Scotland and Wales. Uses "Data Zones" for Scotland (2011 census only). For Northern Ireland the file includes "Super Output Areas" for the 2011 Census and "Data Zones" for the 2021 Census.

Fields:

The following columns are included for compatability but are deprecated and can expected to be removed in future versions:

lsoa_latlong.csv

A record for every Lower Super Output Area from the 2011 and 2021 censuses, along with the latitude and longitude of the centre of the area.

Covers England, Northern Ireland, Scotland and Wales. Uses "Data Zones" for Scotland (2011 census only). For Northern Ireland the file includes "Super Output Areas" for the 2011 Census and "Data Zones" for the 2021 Census.

Fields:

The following columns are included for compatability but are deprecated and can expected to be removed in future versions:

msoa_la.csv

A record for every Middle Super Output Area from the 2011 and 2021 censuses, along with a lookup to the latest Local Authority data.

Covers England, Northern Ireland, Scotland and Wales. Uses "Intermediate Zones" for Scotland (2011 census only). For Northern Ireland the file includes "Super Output Areas" for the 2011 Census and "Super Data Zones" for the 2021 Census.

Fields:

The following columns are included for compatability but are deprecated and can expected to be removed in future versions:

msoa_latlong.csv

A record for every Middle Super Output Area from the 2011 and 2021 censuses, along with the latitude and longitude of the centre of the area.

Covers England, Northern Ireland, Scotland and Wales. Uses "Intermediate Zones" for Scotland (2011 census only). For Northern Ireland the file includes "Super Output Areas" for the 2011 Census and "Super Data Zones" for the 2021 Census.

Fields:

The following columns are included for compatability but are deprecated and can expected to be removed in future versions:

ward_all_codes.csv

A record for every Ward in the UK that has existed since 2015, along with a lookup to the latest Local Authority that it would be part of. Lookups are based on a lookup from the Local Authority that the ward belonged to at the time it existed to the latest Local Authorities. So these could be incorrect in a few cases.

Covers England, Northern Ireland, Scotland and Wales.

Fields:

The following columns are included for compatability but are deprecated and can expected to be removed in future versions:

ward_latlong.csv

A record for every Ward in the UK that has existed since 2015, along with the latitude and longitude of the centre of the area.

Covers England, Northern Ireland, Scotland and Wales.

Fields:

cauth_all_codes.csv

A record for each Combined Authority.

Covers England

Fields:

rgn_all_codes.csv

A record for each English region.

Covers England

Fields:

ctry_all_codes.csv

A record for each Country.

Covers England, Northern Ireland, Scotland and Wales.

Fields:

The following files are also created for completeness, although they only include one record each.

la_orgid_to_gss.csv

A lookup between the codes for Local Authorities from the (now defunct) registers of Local Authorities held by gov.uk with the GSS codes for the areas they represent.

Fields:

area_all_codes.csv

Based on la_all_codes.csv, this file also adds records for administrative geography at a higher level than local authority districts, so there are records for:

Each record contains links to areas that can be inferred from the given code. Where defunct local authorities are included, their record links to the most up to date code for that authority.

Fields:

Other files

lieutenancy_areas_england.csv

A list of the lieutenancy areas of England from 1997, based on data from Wikidata and Wikipedia, mapped to current and former local authority codes. These are sometimes known as ceremonial counties.

Note that according to Wikipedia the local authority areas have a 1:1 match with the boundaries of ceremonial areas, with the exception of Stockton-on-Tees (E06000004) which is shared between County Durham (north of the Tees) and North Yorkshire (south of the Tees). For the purposes of this list Stockton-on-Tees has been allocated to County Durham, but this is not completely accurate.

Data sources

Data is sourced from the ONS Geoportal and used under the Open Government Licence v3.0.

Other data sources: