Chicago Energy Benchmarking
City of Chicago
@usgov.city_of_chicago_chicago_energy_benchmarking
City of Chicago
@usgov.city_of_chicago_chicago_energy_benchmarking
CREATE TABLE table_1 (
"data_year" BIGINT,
"id" BIGINT,
"property_name" VARCHAR,
"reporting_status" VARCHAR,
"address" VARCHAR,
"zip_code" VARCHAR,
"chicago_energy_rating" DOUBLE,
"exempt_from_chicago_energy_rating" VARCHAR,
"community_area" VARCHAR,
"primary_property_type" VARCHAR,
"gross_floor_area_buildings_sq_ft" DOUBLE,
"year_built" DOUBLE,
"n__of_buildings" DOUBLE,
"water_use_kgal" DOUBLE,
"energy_star_score" DOUBLE,
"electricity_use_kbtu" DOUBLE,
"natural_gas_use_kbtu" DOUBLE,
"district_steam_use_kbtu" DOUBLE,
"district_chilled_water_use_kbtu" DOUBLE,
"all_other_fuel_use_kbtu" DOUBLE,
"site_eui_kbtu_sq_ft" DOUBLE,
"source_eui_kbtu_sq_ft" DOUBLE,
"weather_normalized_site_eui_kbtu_sq_ft" DOUBLE,
"weather_normalized_source_eui_kbtu_sq_ft" DOUBLE,
"total_ghg_emissions_metric_tons_co2e" DOUBLE,
"ghg_intensity_kg_co2e_sq_ft" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"location" VARCHAR,
"row_id" VARCHAR
);
Anyone who has the link will be able to view this.