About this Dataset

London's Zero Carbon Energy Resource - Secondary Heat

These datasets accompany the London Secondary Heat Study (2013) and provides an understanding of the technical potential (available heat) and deployment potential (delivered heat) of eleven key secondary heat sources in London. The accompanying reports are available on the GLA website. Data available for Middle Super Output Areas (MSOA).
Publisher name: Greater London Authority
Last updated: 2024-09-14T08:19:51Z

Tables

Available Heat 2013-msoa

@ukgov.londons_zero_carbon_energy_resource_secondary_heat.available_heat_2013_msoa

53.19 kB
983 rows
20 columns

CREATE TABLE available_heat_2013_msoa (
  "middle_super_output_area" VARCHAR,
  "n__1_2013_available_low_grade_heat_typical_temperature_24266db9" VARCHAR  -- Table 1: 2013 Available Low Grade Heat;Typical Temperature;Greater London Totals (GWh);As A % Of Total Heat Demand;MSOA Name,
  "n__open_loop_ground_source_abstraction" VARCHAR  -- Open Loop Ground Source Abstraction,
  "n__closed_loop_ground_source_abstraction" VARCHAR  -- Closed Loop Ground Source Abstraction,
  "n__air_source_heat_pumps" VARCHAR  -- Air Source Heat Pumps,
  "n__rivers_10_abstraction" DOUBLE  -- Rivers (10% Abstraction),
  "n__power_stations" VARCHAR  -- Power Stations,
  "building_heat_rejection_office" BIGINT,
  "building_heat_rejection_retail" BIGINT,
  "building_heat_rejection_gyms" VARCHAR,
  "n__industrial_sources_part_a_processes" VARCHAR  -- Industrial Sources;Part A Processes,
  "n__industrial_sources_part_b_processes" VARCHAR  -- Industrial Sources;Part B Processes,
  "commercial_building_sources_non_hvac_supermarkets" VARCHAR  -- Commercial Building Sources - Non HVAC;Supermarkets,
  "commercial_building_sources_non_hvac_data_centres" VARCHAR  -- Commercial Building Sources - Non HVAC;Data Centres,
  "n__wastewater_treatment_plants" VARCHAR  -- Wastewater (Treatment Plants);,
  "n__tubre_rejected" DOUBLE  -- Tubre Rejected,
  "n__national_grid_infrastructure" VARCHAR  -- National Grid Infrastructure,
  "n__ukpn_infrastructure" VARCHAR  -- UKPN Infrastructure,
  "n__sewer_heat_mining_various" VARCHAR  -- Sewer Heat Mining;Various,
  "n__total_gwh" BIGINT  -- TOTAL;GWh
);

Available Heat 2050-msoa

@ukgov.londons_zero_carbon_energy_resource_secondary_heat.available_heat_2050_msoa

52.48 kB
983 rows
20 columns

CREATE TABLE available_heat_2050_msoa (
  "middle_super_output_area" VARCHAR,
  "msoa_name" VARCHAR,
  "n__open_loop_ground_source_abstraction" VARCHAR  -- Open Loop Ground Source Abstraction,
  "n__closed_loop_ground_source_abstraction" VARCHAR  -- Closed Loop Ground Source Abstraction,
  "n__air_source_heat_pumps" VARCHAR  -- Air Source Heat Pumps,
  "n__rivers_10_abstraction" VARCHAR  -- Rivers (10% Abstraction),
  "n__power_stations" VARCHAR  -- Power Stations,
  "building_heat_rejection_office" BIGINT,
  "building_heat_rejection_retail" BIGINT,
  "building_heat_rejection_gyms" VARCHAR,
  "n__industrial_sources_part_a_processes" VARCHAR  -- Industrial Sources;Part A Processes,
  "n__industrial_sources_part_b_processes" VARCHAR  -- Industrial Sources;Part B Processes,
  "commercial_building_sources_non_hvac_supermarkets" VARCHAR  -- Commercial Building Sources - Non HVAC;Supermarkets,
  "commercial_building_sources_non_hvac_data_centres" VARCHAR  -- Commercial Building Sources - Non HVAC;Data Centres,
  "n__wastewater_treatment_plants" VARCHAR  -- Wastewater (Treatment Plants);,
  "n__tubre_rejected" VARCHAR  -- Tubre Rejected,
  "n__national_grid_infrastructure" VARCHAR  -- National Grid Infrastructure,
  "n__ukpn_infrastructure" VARCHAR  -- UKPN Infrastructure,
  "n__sewer_heat_mining_various" VARCHAR  -- Sewer Heat Mining;Various,
  "n__total_gwh" BIGINT  -- TOTAL;GWh
);

Delivered Heat 2013-msoa

@ukgov.londons_zero_carbon_energy_resource_secondary_heat.delivered_heat_2013_msoa

53.81 kB
983 rows
20 columns

CREATE TABLE delivered_heat_2013_msoa (
  "middle_super_output_area" VARCHAR,
  "msoa_name" VARCHAR,
  "n__open_loop_ground_source_abstraction" VARCHAR  -- Open Loop Ground Source Abstraction,
  "n__closed_loop_ground_source_abstraction" VARCHAR  -- Closed Loop Ground Source Abstraction,
  "n__air_source_heat_pumps" VARCHAR  -- Air Source Heat Pumps,
  "n__rivers_10_abstraction" DOUBLE  -- Rivers (10% Abstraction),
  "n__power_stations" VARCHAR  -- Power Stations,
  "building_heat_rejection_office" BIGINT,
  "building_heat_rejection_retail" BIGINT,
  "building_heat_rejection_gyms" VARCHAR,
  "n__industrial_sources_part_a_processes" VARCHAR  -- Industrial Sources;Part A Processes,
  "n__industrial_sources_part_b_processes" VARCHAR  -- Industrial Sources;Part B Processes,
  "commercial_building_sources_non_hvac_supermarkets" VARCHAR  -- Commercial Building Sources - Non HVAC;Supermarkets,
  "commercial_building_sources_non_hvac_data_centres" VARCHAR  -- Commercial Building Sources - Non HVAC;Data Centres,
  "n__wastewater_treatment_plants" VARCHAR  -- Wastewater (Treatment Plants);,
  "n__tubre_rejected" DOUBLE  -- Tubre Rejected,
  "n__national_grid_infrastructure" VARCHAR  -- National Grid Infrastructure,
  "n__ukpn_infrastructure" VARCHAR  -- UKPN Infrastructure,
  "n__sewer_heat_mining_various" VARCHAR  -- Sewer Heat Mining;Various,
  "n__total_gwh" BIGINT  -- TOTAL;GWh
);

Delivered Heat 2050-msoa

@ukgov.londons_zero_carbon_energy_resource_secondary_heat.delivered_heat_2050_msoa

54.27 kB
983 rows
21 columns

CREATE TABLE delivered_heat_2050_msoa (
  "middle_super_output_area" VARCHAR,
  "msoa_name" VARCHAR,
  "n__open_loop_ground_source_abstraction" VARCHAR  -- Open Loop Ground Source Abstraction,
  "n__closed_loop_ground_source_abstraction" VARCHAR  -- Closed Loop Ground Source Abstraction,
  "n__air_source_heat_pumps" VARCHAR  -- Air Source Heat Pumps,
  "n__rivers_10_abstraction" VARCHAR  -- Rivers (10% Abstraction),
  "n__power_stations" VARCHAR  -- Power Stations,
  "building_heat_rejection_office" BIGINT,
  "building_heat_rejection_retail" BIGINT,
  "building_heat_rejection_gyms" VARCHAR,
  "n__industrial_sources_part_a_processes" VARCHAR  -- Industrial Sources;Part A Processes,
  "n__industrial_sources_part_b_processes" VARCHAR  -- Industrial Sources;Part B Processes,
  "commercial_building_sources_non_hvac_supermarkets" VARCHAR  -- Commercial Building Sources - Non HVAC;Supermarkets,
  "commercial_building_sources_non_hvac_data_centres" VARCHAR  -- Commercial Building Sources - Non HVAC;Data Centres,
  "n__wastewater_treatment_plants" VARCHAR  -- Wastewater (Treatment Plants);,
  "n__tubre_rejected" VARCHAR  -- Tubre Rejected,
  "n__national_grid_infrastructure" VARCHAR  -- National Grid Infrastructure,
  "n__ukpn_infrastructure" VARCHAR  -- UKPN Infrastructure,
  "n__sewer_heat_mining_various" VARCHAR  -- Sewer Heat Mining;Various,
  "n__total_gwh" BIGINT  -- TOTAL;GWh,
  "unnamed_20" VARCHAR  -- Unnamed: 20
);