About this Dataset

Existing Buildings Energy Performance Ordinance Report

A. SUMMARY The Existing Buildings Energy Performance Ordinance (Environment Code Chapter 20) requires that each non-residential building with at least 10,000 square feet of conditioned (heated or cooled) space and each residential building with at least 50,000 square feet of conditioned space must be benchmarked annually using Energy Star Portfolio Manager. Each non-residential building specified above is also required to undergo an energy audit, retrocommissioning, or develop a plan for decarbonization at least once every 5 years. More information: San Francisco Existing Buildings Energy Ordinance Website B. HOW THE DATASET IS CREATED The data is sourced from the benchmark and energy audit reports submitted for compliance with Environment Code Chapter 20. The dataset is presented in two tables which together provide basic characteristics, compliance status, and a public record of reported energy performance. C. UPDATE PROCESS This dataset will be updated on a monthly basis. D. HOW TO USE THIS DATASET Existing Buildings - Basic Info and Audit Compliance Status -- This filtered view contains one record per building and provides basic characteristics (such as size and vintage). For commercial buildings, the table indicates when an energy audit or decarbonization plan is due. Existing Buildings - Benchmark Reports -- Each row of this filtered view presents one year of benchmarking data for one building – so there are multiple records per building. One year of data includes compliance status, and if the building complied it also presents energy use data including gas, electricity, steam and EPA-estimated operational carbon emissions. This dataset contains the information of the two views joined on Parcel Number.
Organization: City of San Francisco
Last updated: 2023-10-13T19:53:53.558091
Tags: benchmark, benchmarking, building, buildings, carbon-emissions, energy, greenhouse-gas-emissions

Tables

Table 1

@usgov.city_of_san_francisco_existing_buildings_energy_perfor_66fcc911.table_1

1.06 MB
28,535 rows
34 columns

CREATE TABLE table_1 (
  "unique_identifier" VARCHAR,
  "parcel_number" VARCHAR,
  "building_name" VARCHAR,
  "building_address" VARCHAR,
  "postal_code" BIGINT,
  "floor_area" BIGINT,
  "category" VARCHAR,
  "property_type_self_selected" VARCHAR  -- Property Type - Self Selected,
  "pim_link" VARCHAR,
  "year_built" DOUBLE,
  "energy_audit_due_date" TIMESTAMP,
  "energy_audit_status" VARCHAR,
  "benchmark_year" BIGINT,
  "energy_star_score" DOUBLE,
  "site_eui_kbtu_ft2" DOUBLE  -- Site EUI (kBtu/ft2),
  "source_eui_kbtu_ft2" DOUBLE  -- Source EUI (kBtu/ft2),
  "percent_better_than_national_median_site_eui" DOUBLE,
  "weather_normalized_site_eui_kbtu_ft2" DOUBLE  -- Weather Normalized Site EUI (kBtu/ft2),
  "weather_normalized_source_eui_kbtu_ft2" DOUBLE  -- Weather Normalized Source EUI (kBtu/ft2),
  "total_ghg_emissions_metric_tons_co2e" DOUBLE  -- Total GHG Emissions (Metric Tons CO2e),
  "total_ghg_emissions_intensity_kgco2e_ft2" DOUBLE  -- Total GHG Emissions Intensity (kGCO2e/ft2),
  "electricity_use_grid_purchase_kwh" DOUBLE  -- Electricity Use - Grid Purchase (kWh),
  "natural_gas_use_kbtu" DOUBLE  -- Natural Gas Use (kBtu),
  "district_steam_use_kbtu" DOUBLE  -- District Steam Use (kBtu),
  "site_energy_use_kbtu" DOUBLE  -- Site Energy Use (kBtu),
  "benchmark_status" VARCHAR,
  "reason_for_exemption" VARCHAR,
  "point" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);