London Data

Spatial data for London, curated for analysis using ONS geographies. Python code used to manipulate data from original sources is provided (along with a file specifying package requirements).

Geographies

Boundary data for various geographies the UK ONS uses to produce statistics (e.g. census, electoral). Provided in .shp and .csv format, usually with BNG CRS.

Census

Data files here as follows:

• london-2021-lsoa-gen20.shp - LSOA boundaries (generalised to 20m resolution from ONS) for 2021 with codes and names for LSOA, MSOA and LAD.
• london-2021-lsoa-gen20.csv - as for london-2021-lsoa-gen20.shp but csv format ready to work in geopandas (this is what most King's students will want to currently work with).
• london-2021-lsoa.shp - LSOA boundaries (original full resolution from ONS) for 2021 with codes and names for LSOA, MSOA and LAD.
• london-2021-lsoa-simple.csv - as for london-2021-lsoa.shp but with simplified polygons for smaller file size and csv format ready to work in geopandas.
• london-2021-lsoa-trunc.csv - as for london-2021-lsoa-simple.csv but with integer co-ordinates for even smaller file size and csv format ready to work in geopandas.
• london-2011-lsoa-gen20.shp - LSOA boundaries (generalised to 20m resolution from ONS) for 2011 with codes and names for LSOA, MSOA and LAD.
• london-2011-lsoa-gen20.csv - as for london-2011-lsoa-gen20.shp but csv format ready to work in geopandas.
• london-2011-lsoa.shp - LSOA boundaries (original from ONS) for 2011 with codes and names for LSOA, MSOA and LAD.
• london-2011-lsoa-simple.csv - as for london-2011-lsoa.shp but with simplified polygons for smaller file size and csv format ready to work in geopandas.
• london-2011-lsoa-trunc.csv - as for london-2011-lsoa-simple.csv but with integer co-ordinates for even smaller file size and csv format ready to work in geopandas.

Source code for 2021 files and for 2011 files .

Source: Office for National Statistics licensed under the Open Government Licence v.3.0
Contains OS data © Crown copyright and database right (2022)

Roads

Data files here from source code as follows:

• london-2018-MRN.shp - Major Road Network clipped to extent of London Boroughs
• london-2023-oproad-MandA.shp - Motorways and A Roads from the OS Open Roads data clipped to extent of London Boroughs

Sources: Department for Transport (2022) licensed under the Open Government Licence v.3.0; Ordnance Survey (OS) licensed under the Open Government Licence v.3.0, Contains OS data © Crown Copyright [and database right] (2023)

Population

Data files here from source code as follows:

• london-mid2020-pop.csv - LSOA mid-year population estimates for 2020.
• london-mid2019-pop.csv - LSOA mid-year population estimates for 2019.

Source: Office for National Statistics licensed under the Open Government Licence.

Note: joining these data to 2011 census geographies is not entirely appropriate (e.g. see issue in the source code notebook)

Energy

Data files here as follows:

• london-2010-2020-gas.csv - LSOA domestic gas consumption for 2010-2020. [Source Code]
• london-2010-2020-elec.csv - LSOA domestic electricity consumption for 2010-2020. [Source Code]

Source: Department for Business, Energy & Industrial Strategy

Crime

Data files here from source code contain annual counts per LOSA as follows:

• london-2011-2021-major-arson - Arson and Criminal Damage crimes (major category)
• london-2011-2021-major-burglary - Burglary crimes (major category)
• london-2011-2021-major-drugs - Drug Offences crimes (major category)
• london-2011-2021-major-misc - Miscellaneous Crimes Against Society crimes (major category)
• london-2011-2021-major-weapons - Possession of Weapons crimes (major category)
• london-2011-2021-major-public-order - Public Order Offences crimes (major category)
• london-2011-2021-major-robbery - Robbery crimes (major category)
• london-2011-2021-major-sexual - Sexual Offences crimes (major category)
• london-2011-2021-major-theft-all - Theft (non-vehicle) crimes (major category)
• london-2011-2021-major-vehicle-offences - Vehicle Offences crimes (major category)
• london-2011-2021-major-violence - Violence Against the Person crimes (major category)
• london-2011-2021-minor-theft-bicycle - Bicycle Theft crimes (minor category)
• london-2011-2021-minor-theft-vehicle - Theft or Taking of a Motor Vehicle crimes (minor category)

Source: Metropolitan Police Service licensed under the Open Government Licence v.2.0

Air Quality

Data files here from source code are modelled ground level concentrations of pollution summarised for census zones from 20m grid resolution data. In filenames, XXXX is zoning level (LSOA, MSOA, LAD), ££ is data geography year (11 or 21), and #### is AQ data collection year (2019, 2016 or 2013):

• XXXX££-####-PM25 - annual mean PM2.5 (microgramme per cubic metre)
• XXXX££-####-PM10 - annual mean PM10 (microgramme per cubic metre)
• XXXX££-####-PM10d - number times daily mean PM10 exceeded 50 microgramme per cubic metre
• XXXX££-####-NOx - annual mean NOx (microgramme per cubic metre)
• XXXX££-####-NO2 - annual mean NO2 (microgramme per cubic metre)

Source: London Atmospheric Emissions Inventory (LAEI) licensed under the Open Government Licence v.2.0

Household Income

Data files here from source code are modelled household income estimates for small areas, London, 2001-2012:

• london-2001-2012-HHI-mean.csv - mean total gross household income for LSOAs (2011 geography)
• london-2001-2012-HHI-median.csv - median total gross household income for LSOAs (2011 geography)

Source: Greater London Authority licensed under the Open Government Licence v.2.0