San Francisco Municipal Energy Benchmarking by US Government | Environmental and Climate Sciences

About this Dataset

San Francisco Municipal Energy Benchmarking

A. SUMMARY San Francisco’s Existing Buildings Energy Performance Ordinance requires owners of non-residential buildings over 10,000 square feet to annually benchmark and disclose energy performance. On behalf of City agencies, the San Francisco Public Utilities Commission (SFPUC) benchmarks and reports energy use for a portfolio of approximately 500 public facilities buildings. The performance of public facilities can be examined in an interactive report at bit.ly/SFMunicipalBenchmarking, and annual reports from 2011-present are available there as well. This dataset presents the energy performance and basic characteristics for public facilities that is visualized by the SFPUC’s interactive report. In addition, energy performance data for non-municipal buildings (i.e. commercial buildings of 10,000 square feet or larger, and multifamily & mixed-use buildings of 50,000 square feet or larger) is available at: bit.ly/ExistingBuildingsReport B. HOW THE DATASET IS CREATED In compliance with California Energy Benchmarking Regulations (CA Public Resources Code Section 25402.10 and CCR Title 20 Section 1680), and San Francisco Existing Buildings Energy Ordinance (Environment Code Chapter 20), the San Francisco Public Utilities Commission provides energy benchmarking services on behalf of municipal facilities. Details for public facilities are compiled from city records, and energy usage is compiled from utility records; related metrics such as energy use intensity are calculated from the combination of such records. Data is subjected to quality assurance validation prior to publication. For additional information regarding data sources and assumptions, please review the "Data Sources and Assumptions" page of the Municipal Facilities Energy Benchmarking dashboard: https://bit.ly/SFMunicipalBenchmarking. C. UPDATE PROCESS Updated Annually.
Organization: City of San Francisco
Last updated: 2021-08-07T18:44:42.925029
Tags: climate-change, energy, environment, sustainability

Tables

Table 1

@usgov.city_of_san_francisco_san_francisco_municipal_energy_b_1eebb619.table_1

86.97 KB
503 rows
27 columns


CREATE TABLE table_1 (
  "parcel_s" VARCHAR,
  "sfpuc_code" BIGINT,
  "building_address" VARCHAR,
  "facility" VARCHAR,
  "notes" VARCHAR,
  "department_name" VARCHAR,
  "department_code" VARCHAR,
  "building_category" VARCHAR,
  "facility_type" VARCHAR,
  "year_built" BIGINT,
  "year_renovated" VARCHAR,
  "building_floor_area_sq_ft" BIGINT,
  "n_2019_energy_star_score" DOUBLE,
  "n_2019_energy_use_intensity_kbtu_sq_ft" DOUBLE,
  "n_2019_carbon_intensity_lbs_co2e_sq_ft" DOUBLE,
  "n_2020_energy_star_score" DOUBLE,
  "n_2020_energy_use_intensity_kbtu_sq_ft" DOUBLE,
  "n_2020_carbon_intensity_lbs_co2e_sq_ft" DOUBLE,
  "n_2021_energy_star_score" DOUBLE,
  "n_2021_energy_use_intensity_kbtu_sq_ft" DOUBLE,
  "n_2021_carbon_intensity_lbs_co2e_sq_ft" DOUBLE,
  "n_2022_energy_star_score" DOUBLE,
  "n_2022_energy_use_intensity_kbtu_sq_ft" DOUBLE,
  "n_2022_carbon_intensity_lbs_co2e_sq_ft" DOUBLE,
  "n_2023_energy_star_score" DOUBLE,
  "n_2023_energy_use_intensity_kbtu_sq_ft" DOUBLE,
  "n_2023_carbon_intensity_lbs_co2e_sq_ft" DOUBLE
);