Low Carbon Generators
Greater London Authority
@ukgov.low_carbon_generators
Greater London Authority
@ukgov.low_carbon_generators
CREATE TABLE lfb_low_carbon_generators_at_fire_stations_june_2017 (
"fire_station" VARCHAR,
"address" VARCHAR,
"postcode" VARCHAR,
"number_of_photovoltaic_arrays" DOUBLE,
"photovoltaic_output_at_peak_kwp" VARCHAR,
"photovoltaic_installation_date" DOUBLE,
"number_of_combined_heat_and_power" DOUBLE,
"combined_heat_and_power_kwe_electric_power_output_and__8df2a262" VARCHAR,
"combined_heat_and_power_installation_date" VARCHAR,
"number_of_wind_turbine" DOUBLE,
"wind_turbine_mean_power_kwh" VARCHAR,
"wind_turbine_installation_date" DOUBLE,
"number_of_solar_thermal_unit" VARCHAR,
"solar_thermal_power_output" VARCHAR,
"solar_thermal_installation_date" DOUBLE,
"biomass" DOUBLE,
"biomass_power_output" VARCHAR,
"biomass_installation_date" DOUBLE,
"number_of_ground_source_heat_pumps" DOUBLE,
"heat_pump_output" VARCHAR,
"ground_source_heat_pump_installation_date" DOUBLE
);
CREATE TABLE lfepa_low_carbon_generators_june_2016 (
"fire_station" VARCHAR,
"address" VARCHAR,
"postcode" VARCHAR,
"number_of_photovoltaic_arrays" DOUBLE,
"photovoltaic_output_at_peak_kwp" VARCHAR,
"photovoltaic_installation_date" DOUBLE,
"number_of_combined_heat_and_power" DOUBLE,
"combined_heat_and_power_kwe_electric_power_output_and__8df2a262" VARCHAR,
"combined_heat_and_power_installation_date" DOUBLE,
"number_of_wind_turbine" DOUBLE,
"wind_turbine_mean_power_kwh" VARCHAR,
"wind_turbine_installation_date" DOUBLE,
"number_of_solar_thermal_unit" VARCHAR,
"solar_thermal_power_output" VARCHAR,
"solar_thermal_installation_date" DOUBLE,
"biomass" DOUBLE,
"biomass_power_output" VARCHAR,
"biomass_installation_date" DOUBLE,
"number_of_ground_source_heat_pumps" DOUBLE,
"heat_pump_output" VARCHAR,
"ground_source_heat_pump_installation_date" DOUBLE
);
CREATE TABLE mps_may_2011 (
"name" VARCHAR,
"address" VARCHAR,
"postcode" VARCHAR,
"pv" DOUBLE,
"pv_power" VARCHAR,
"chp" DOUBLE,
"chp_power" VARCHAR,
"wt_power" VARCHAR,
"gshp" DOUBLE,
"gshp_power" VARCHAR,
"stu" DOUBLE,
"stu_power" VARCHAR,
"northing" VARCHAR,
"longitude_wgs84" DOUBLE,
"latitude_wgs84" DOUBLE
);
CREATE TABLE table_2 (
"name" VARCHAR,
"address" VARCHAR,
"postcode" VARCHAR,
"pv" BIGINT,
"pv_power" VARCHAR,
"chp" BIGINT,
"chp_power" BIGINT,
"wt" BIGINT,
"wt_power" BIGINT,
"stu" BIGINT,
"stu_power" BIGINT,
"easting" BIGINT,
"northing" BIGINT,
"longitude_wgs84" DOUBLE,
"latitude_wgs84" DOUBLE
);
CREATE TABLE tfl_may_2011 (
"renewable_energy_type" VARCHAR,
"location" VARCHAR,
"postcode" VARCHAR,
"quantity" BIGINT,
"installed_electrical_capacity_kw" DOUBLE,
"installed_heat_capacity_kw_for_chp_m2_for_solar_thermal" VARCHAR
);
Anyone who has the link will be able to view this.