London's Zero Carbon Energy Resource - Secondary Heat
Greater London Authority
@ukgov.londons_zero_carbon_energy_resource_secondary_heat
Greater London Authority
@ukgov.londons_zero_carbon_energy_resource_secondary_heat
CREATE TABLE available_heat_2013_msoa (
"middle_super_output_area" VARCHAR,
"n__1_2013_available_low_grade_heat_typical_temperature_24266db9" VARCHAR,
"n__open_loop_ground_source_abstraction" VARCHAR,
"n__closed_loop_ground_source_abstraction" VARCHAR,
"n__air_source_heat_pumps" VARCHAR,
"n__rivers_10_abstraction" DOUBLE,
"n__power_stations" VARCHAR,
"building_heat_rejection_office" BIGINT,
"building_heat_rejection_retail" BIGINT,
"building_heat_rejection_gyms" VARCHAR,
"n__industrial_sources_part_a_processes" VARCHAR,
"n__industrial_sources_part_b_processes" VARCHAR,
"commercial_building_sources_non_hvac_supermarkets" VARCHAR,
"commercial_building_sources_non_hvac_data_centres" VARCHAR,
"n__wastewater_treatment_plants" VARCHAR,
"n__tubre_rejected" DOUBLE,
"n__national_grid_infrastructure" VARCHAR,
"n__ukpn_infrastructure" VARCHAR,
"n__sewer_heat_mining_various" VARCHAR,
"n__total_gwh" BIGINT
);
CREATE TABLE available_heat_2050_msoa (
"middle_super_output_area" VARCHAR,
"msoa_name" VARCHAR,
"n__open_loop_ground_source_abstraction" VARCHAR,
"n__closed_loop_ground_source_abstraction" VARCHAR,
"n__air_source_heat_pumps" VARCHAR,
"n__rivers_10_abstraction" VARCHAR,
"n__power_stations" VARCHAR,
"building_heat_rejection_office" BIGINT,
"building_heat_rejection_retail" BIGINT,
"building_heat_rejection_gyms" VARCHAR,
"n__industrial_sources_part_a_processes" VARCHAR,
"n__industrial_sources_part_b_processes" VARCHAR,
"commercial_building_sources_non_hvac_supermarkets" VARCHAR,
"commercial_building_sources_non_hvac_data_centres" VARCHAR,
"n__wastewater_treatment_plants" VARCHAR,
"n__tubre_rejected" VARCHAR,
"n__national_grid_infrastructure" VARCHAR,
"n__ukpn_infrastructure" VARCHAR,
"n__sewer_heat_mining_various" VARCHAR,
"n__total_gwh" BIGINT
);
CREATE TABLE delivered_heat_2013_msoa (
"middle_super_output_area" VARCHAR,
"msoa_name" VARCHAR,
"n__open_loop_ground_source_abstraction" VARCHAR,
"n__closed_loop_ground_source_abstraction" VARCHAR,
"n__air_source_heat_pumps" VARCHAR,
"n__rivers_10_abstraction" DOUBLE,
"n__power_stations" VARCHAR,
"building_heat_rejection_office" BIGINT,
"building_heat_rejection_retail" BIGINT,
"building_heat_rejection_gyms" VARCHAR,
"n__industrial_sources_part_a_processes" VARCHAR,
"n__industrial_sources_part_b_processes" VARCHAR,
"commercial_building_sources_non_hvac_supermarkets" VARCHAR,
"commercial_building_sources_non_hvac_data_centres" VARCHAR,
"n__wastewater_treatment_plants" VARCHAR,
"n__tubre_rejected" DOUBLE,
"n__national_grid_infrastructure" VARCHAR,
"n__ukpn_infrastructure" VARCHAR,
"n__sewer_heat_mining_various" VARCHAR,
"n__total_gwh" BIGINT
);
CREATE TABLE delivered_heat_2050_msoa (
"middle_super_output_area" VARCHAR,
"msoa_name" VARCHAR,
"n__open_loop_ground_source_abstraction" VARCHAR,
"n__closed_loop_ground_source_abstraction" VARCHAR,
"n__air_source_heat_pumps" VARCHAR,
"n__rivers_10_abstraction" VARCHAR,
"n__power_stations" VARCHAR,
"building_heat_rejection_office" BIGINT,
"building_heat_rejection_retail" BIGINT,
"building_heat_rejection_gyms" VARCHAR,
"n__industrial_sources_part_a_processes" VARCHAR,
"n__industrial_sources_part_b_processes" VARCHAR,
"commercial_building_sources_non_hvac_supermarkets" VARCHAR,
"commercial_building_sources_non_hvac_data_centres" VARCHAR,
"n__wastewater_treatment_plants" VARCHAR,
"n__tubre_rejected" VARCHAR,
"n__national_grid_infrastructure" VARCHAR,
"n__ukpn_infrastructure" VARCHAR,
"n__sewer_heat_mining_various" VARCHAR,
"n__total_gwh" BIGINT,
"unnamed_20" VARCHAR
);
Anyone who has the link will be able to view this.