Baselight
Sign In

London Building Stock Model (LBSM)

Greater London Authority

@ukgov.london_building_stock_model_lbsm

Loading...
Loading...

About this Dataset

London Building Stock Model (LBSM)

The Mayor is committed to cutting fuel poverty and increasing the energy efficiency of buildings across London. To help target where action is most needed, the Mayor has developed a London Building Stock Model with the UCL Energy Institute. The London Building Stock Model is a database of all the energy and carbon data collected through the Mayor’s energy programmes and policies. It provides a snapshot of all London’s buildings (both domestic and non-domestic) with information on their energy performance certificates as of 2017. More information is available here, and an interactive map is available here. Most of the data from the London Building Stock Model interactive map has been made available through the data extracts below. Please note that the data extracts are based on Ordnance Survey's list of London properties as of 2023. However, as the London Building Stock Model data is from 2017, some of the properties might not have any London Building Stock Model data attached to them. The data contains Ordnance Survey mapping and the data is published under Ordnance Survey's 'presumption to publish'. © Crown copyright and database rights 2023
Publisher name: Greater London Authority
Last updated: 2024-06-14T04:02:21Z

Tables

London Building Stock Model - Redbridge Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_redbridge_data
  • 5.88 MB
  • 125524 rows
  • 43 columns
Loading... 

CREATE TABLE london_building_stock_model_redbridge_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Richmond Upon Thames Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_richmond_upon_thames_data
  • 4.78 MB
  • 101433 rows
  • 43 columns
Loading... 

CREATE TABLE london_building_stock_model_richmond_upon_thames_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Southwark Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_southwark_data
  • 5.28 MB
  • 179437 rows
  • 43 columns
Loading... 

CREATE TABLE london_building_stock_model_southwark_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Sutton Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_sutton_data
  • 4.5 MB
  • 98019 rows
  • 43 columns
Loading... 

CREATE TABLE london_building_stock_model_sutton_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Tower Hamlets Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_tower_hamlets_data
  • 4.36 MB
  • 194906 rows
  • 43 columns
Loading... 

CREATE TABLE london_building_stock_model_tower_hamlets_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Waltham Forest Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_waltham_forest_data
  • 5.74 MB
  • 134420 rows
  • 43 columns
Loading... 

CREATE TABLE london_building_stock_model_waltham_forest_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Wandsworth Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_wandsworth_data
  • 6.54 MB
  • 190281 rows
  • 43 columns
Loading... 

CREATE TABLE london_building_stock_model_wandsworth_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

London Building Stock Model - Westminster Data

@ukgov.london_building_stock_model_lbsm.london_building_stock_model_westminster_data
  • 4.9 MB
  • 199713 rows
  • 43 columns
Loading... 

CREATE TABLE london_building_stock_model_westminster_data (
  "uprn" BIGINT,
  "scu_id" VARCHAR,
  "os_topo_toid" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "oa" VARCHAR,
  "lsoa" VARCHAR,
  "msoa" VARCHAR,
  "oac" VARCHAR,
  "ward_code" VARCHAR,
  "ward" VARCHAR,
  "administrative_area" VARCHAR,
  "estimated_floor_count" VARCHAR,
  "estimate_total_floor_area_all" VARCHAR,
  "scu_footprint" VARCHAR,
  "mean_object_height_m" VARCHAR,
  "basement_floor" VARCHAR,
  "count_d_uprns" VARCHAR,
  "count_nd_uprns" VARCHAR,
  "mix_class" VARCHAR,
  "dominant_nd_activity_by_c2_fs" VARCHAR,
  "dominant_nd_activity_by_c2_count" VARCHAR,
  "dec_count" BIGINT,
  "agg_dec_current_operational_rating_by_count" VARCHAR,
  "agg_dec_current_operational_rating_band_by_count" VARCHAR,
  "agg_dec_current_operational_rating_by_floorarea" VARCHAR,
  "agg_dec_current_operational_rating_band_by_floorarea" VARCHAR,
  "epc_rating_count_dom" BIGINT,
  "epc_rating_count_nondom" BIGINT,
  "agg_epc_current_energy_efficiency_by_count" VARCHAR,
  "agg_epc_current_energy_rating_by_count" VARCHAR,
  "agg_epc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_current_energy_rating_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_count" VARCHAR,
  "agg_epc_potential_energy_rating_by_count" VARCHAR,
  "agg_epc_potential_energy_efficiency_by_floorarea" VARCHAR,
  "agg_epc_potential_energy_rating_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_count" VARCHAR,
  "agg_rvepc_current_energy_rating_by_count" VARCHAR,
  "agg_rvepc_current_energy_efficiency_by_floorarea" VARCHAR,
  "agg_rvepc_current_energy_rating_by_floorarea" VARCHAR
);

Share link

Anyone who has the link will be able to view this.