San Francisco Data

Close
Author
SFEBO Help Desk
Description
<strong>UPDATE 10/10/2023: The Existing Buildings Energy Ordinance dataset, published monthly, will be updated to a new structure. The main update merges compliance status information with a public record of reported energy performance for each building, joining on Parcel Number. <u><a href="https://data.sfgov.org/Energy-and-Environment/Existing-Buildings-Energy-Performance-Ordinance-Re/96ck-qcfe">The new dataset can be found at this link.</a></u> For convenience, the new dataset also includes two filtered views, for each subset of data: <u><a href="https://data.sfgov.org/Energy-and-Environment/Existing-Buildings-Basic-Info-and-Audit-Compliance/vgqy-2ca4">Existing Buildings - Basic Info and Audit Compliance Status</a></u> -- 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. <u><a href="https://data.sfgov.org/Energy-and-Environment/Existing-Buildings-Benchmark-Reports/4ua7-5sfx">Existing Buildings - Benchmark Reports</a></u> -- 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. The current dataset will be available for one month until Monday, October 30, 2023, and will no longer be available after. Please use the above tables moving forward. The Existing Buildings Energy Ordinance dataset will continue to be published monthly. </strong> Data updated 09/11/2023. 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 using Energy Star Portfolio Manager annually. Each non-residential building specified above is also required to undergo an energy audit or retrocommissioning at least once every 5 years. This dataset presents basic information about energy use and implications (estimated greenhouse gas emissions, gas use, electricity use, and district steam use); and compliance status for private-sector (non-municipal) properties. More information: www.sfenvironment.org/ebo.
Category
Energy and Environment
Tags
energy, building, buildings, benchmarking, benchmark, carbon emissions, greenhouse gas emissions
Rating
Current value: 0 out of 5
Data Provided By
SF Environment
Source Link
http://www.sfenvironment.org/ecb
License
Public Domain Dedication and License
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Parcel(s)
parcel_s
Building Name
building_name
Building Address
building_address
Postal Code
postal_code
Floor Area
floor_area
Category
property_type
Property Type - Self Selected
property_type_self_selected
PIM Link
pim_link
Year Built
year_built
Energy Audit Due Date
energy_audit_due_date
Energy Audit Status
energy_audit_status
2022 ENERGY STAR Score
_2022_energy_star_score
2022 Site EUI (kBtu/ft2)
_2022_site_eui_kbtu_ft2_
2022 Source EUI (kBtu/ft2)
_2022_source_eui_kbtu_ft2_
2022 Percent Better than National Median Site EUI
_2022_percent_better_than_national_median_site_eui
2022 Weather Normalized Site EUI (kBtu/ft2)
_2022_weather_normalized_site_eui_kbtu_ft2_
2022 Weather Normalized Source EUI (kBtu/ft2)
_2022_weather_normalized_source_eui_kbtu_ft2_
2022 Total GHG Emissions (Metric Tons CO2e)
_2022_total_ghg_emissions_metric_tons_co2e_
2022 Total GHG Emissions Intensity (kGCO2e/ft2)
_2022_total_ghg_emissions_intensity_kgco2e_ft2_
2022 Electricity Use - Grid Purchase (kWh)
_2022_electricity_use_grid_purchase_kwh_
2022 Natural Gas Use (kBtu)
_2022_natural_gas_use_kbtu_
2022 District Steam Use (kBtu)
_2022_district_steam_use_kbtu_
2022 Site Energy Use (kBtu)
_2022_site_energy_use_kbtu_
2021 ENERGY STAR Score
_2021_energy_star_score
2021 Site EUI (kBtu/ft2)
_2021_site_eui_kbtu_ft2_
2021 Source EUI (kBtu/ft2)
_2021_source_eui_kbtu_ft2_
2021 Percent Better than National Median Site EUI
_2021_percent_better_than_national_median_site_eui
2021 Weather Normalized Site EUI (kBtu/ft2)
_2021_weather_normalized_site_eui_kbtu_ft2_
2021 Weather Normalized Source EUI (kBtu/ft2)
_2021_weather_normalized_source_eui_kbtu_ft2_
2021 Total GHG Emissions (Metric Tons CO2e)
_2021_total_ghg_emissions_metric_tons_co2e_
2021 Total GHG Emissions Intensity (kGCO2e/ft2)
_2021_total_ghg_emissions_intensity_kgco2e_ft2_
2021 Electricity Use - Grid Purchase (kWh)
_2021_electricity_use_grid_purchase_kwh_
2021 Natural Gas Use (kBtu)
_2021_natural_gas_use_kbtu_
2021 District Steam Use (kBtu)
_2021_district_steam_use_kbtu_
2021 Site Energy Use (kBtu)
_2021_site_energy_use_kbtu_
2020 ENERGY STAR Score
_2020_energy_star_score
2020 Site EUI (kBtu/ft2)
_2020_site_eui_kbtu_ft2_
2020 Source EUI (kBtu/ft2)
_2020_source_eui_kbtu_ft2_
2020 Percent Better than National Median Site EUI
_2020_percent_better_than_national_median_site_eui
2020 Weather Normalized Site EUI (kBtu/ft2)
_2020_weather_normalized_site_eui_kbtu_ft2_
2020 Weather Normalized Source EUI (kBtu/ft2)
_2020_weather_normalized_source_eui_kbtu_ft2_
2020 Total GHG Emissions (Metric Tons CO2e)
_2020_total_ghg_emissions_metric_tons_co2e_
2020 Total GHG Emissions Intensity (kGCO2e/ft2)
_2020_total_ghg_emissions_intensity_kgco2e_ft2_
2020 Electricity Use - Grid Purchase (kWh)
_2020_electricity_use_grid_purchase_kwh_
2020 Natural Gas Use (kBtu)
_2020_natural_gas_use_kbtu_
2020 District Steam Use (kBtu)
_2020_district_steam_use_kbtu_
2020 Site Energy Use (kBtu)
_2020_site_energy_use_kbtu_
2019 ENERGY STAR Score
a_2019_energy_star_score
2019 Site EUI (kBtu/ft2)
a_2019_site_eui_kbtu_ft2_
2019 Source EUI (kBtu/ft2)
a_2019_source_eui_kbtu_ft2_
2019 Percent Better than National Median Site EUI
a_2019_percent_better_than_national_median_site_eui
2019 Weather Normalized Site EUI (kBtu/ft2)
a_2019_weather_normalized_site_eui_kbtu_ft2_
2019 Weather Normalized Source EUI (kBtu/ft2)
a_2019_weather_normalized_source_eui_kbtu_ft2_
2019 Total GHG Emissions (Metric Tons CO2e)
_2019_total_ghg_emissions_metric_tons_co2e_
2019 Total GHG Emissions Intensity (kGCO2e/ft2)
_2019_total_ghg_emissions_intensity_kgco2e_ft2_
2019 Electricity Use - Grid Purchase (kWh)
_2019_electricity_use_grid_purchase_kwh_
2019 Natural Gas Use (kBtu)
_2019_natural_gas_use_kbtu_
2019 District Steam Use (kBtu)
_2019_district_steam_use_kbtu_
2019 Site Energy Use (kBtu)
_2019_site_energy_use_kbtu_
2018 ENERGY STAR Score
_2018_energy_star_score
2018 Site EUI (kBtu/ft2)
_2018_site_eui_kbtu_ft2_
2018 Source EUI (kBtu/ft2)
_2018_source_eui_kbtu_ft2_
2018 Percent Better than National Median Site EUI
_2018_percent_better_than_national_median_site_eui
2018 Weather Normalized Site EUI (kBtu/ft2)
_2018_weather_normalized_site_eui_kbtu_ft2_
2018 Weather Normalized Source EUI (kBtu/ft2)
_2018_weather_normalized_source_eui_kbtu_ft2_
2018 Total GHG Emissions (Metric Tons CO2e)
_2018_total_ghg_emissions_metric_tons_co2e_
2018 Total GHG Emissions Intensity (kGCO2e/ft2)
_2018_total_ghg_emissions_intensity_kgco2e_ft2_
2018 Electricity Use - Grid Purchase (kWh)
_2018_electricity_use_grid_purchase_kwh_
2018 Natural Gas Use (kBtu)
_2018_natural_gas_use_kbtu_
2018 District Steam Use (kBtu)
_2018_district_steam_use_kbtu_
2018 Site Energy Use (kBtu)
_2018_site_energy_use_kbtu_
2017 ENERGY STAR Score
_2017_energy_star_score
2017 Site EUI (kBtu/ft2)
_2017_site_eui_kbtu_ft2
2017 Source EUI (kBtu/ft2)
_2017_source_eui_kbtu_ft2
2017 Percent Better than National Median Site EUI
_2017_percent_better_than_national_median_site_eui
2017 Weather Normalized Site EUI (kBtu/ft2)
_2017_weather_normalized_site_eui_kbtu_ft2
2017 Weather Normalized Source EUI (kBtu/ft2)
_2017_weather_normalized_source_eui_kbtu_ft2
2016 ENERGY STAR Score
_2016_energy_star_score
2016 Site EUI (kBtu/ft2)
_2016_site_eui_kbtu_ft2
2016 Source EUI (kBtu/ft2)
_2016_source_eui_kbtu_ft2
2016 Percent Better than National Median Site EUI
_2016_percent_better_than_national_median_site_eui
2016 Percent Better than National Median Source EUI
_2016_percentage_better_than_national_median_source_eui
2016 Weather Normalized Site EUI (kBtu/ft2)
_2016_weather_normalized_site_eui_kbtu_ft2
2016 Weather Normalized Source EUI (kBtu/ft2)
_2016_weather_normalized_source_eui_kbtu_ft2
2015 ENERGY STAR Score
_2015_energy_star_score
2015 Site EUI (kBtu/ft2)
_2015_site_eui_kbtu_ft2
2015 Source EUI (kBtu/ft2)
_2015_source_eui_kbtu_ft2
2015 Percent Better than National Median Site EUI
_2015_percent_better_than_national_median_site_eui
2015 Weather Normalized Site EUI (kBtu/ft2)
_2015_weather_normalized_site_eui_kbtu_ft2
2015 Weather Normalized Source EUI (kBtu/ft2)
_2015_weather_normalized_source_eui_kbtu_ft2
2014 ENERGY STAR Score
_2014_energy_star_score
2014 Site EUI (kBtu/ft2)
_2014_site_eui_kbtu_ft2
2014 Source EUI (kBtu/ft2)
_2014_source_eui_kbtu_ft2
2014 Percent Better than National Median Site EUI
_2014_percent_better_than_national_median_site_eui
2014 Weather Normalized Site EUI (kBtu/ft2)
_2014_weather_normalized_site_eui_kbtu_ft2
2014 Weather Normalized Source EUI (kBtu/ft2)
_2014_weather_normalized_source_eui_kbtu_ft2
2013 ENERGY STAR Score
_2013_energy_star_score
2013 Site EUI (kBtu/ft2)
_2013_site_eui_kbtu_ft2
2013 Source EUI (kBtu/ft2)
_2013_source_eui_kbtu_ft2
2013 Percent Better than National Median Site EUI
_2013_percent_better_than_national_median_site_eui
2013 Weather Normalized Site EUI (kBtu/ft2)
_2013_weather_normalized_site_eui_kbtu_ft2
2013 Weather Normalized Source EUI (kBtu/ft2)
_2013_weather_normalized_source_eui_kbtu_ft2
2012 ENERGY STAR Score
_2012_energy_star_score
2012 Site EUI (kBtu/ft2)
_2012_site_eui_kbtu_ft2
2012 Source EUI (kBtu/ft2)
_2012_source_eui_kbtu_ft2
2012 Percent Better than National Median Site EUI
_2012_percent_better_than_national_median_site_eui
2012 Weather Normalized Site EUI (kBtu/ft2)
_2012_weather_normalized_site_eui_kbtu_ft2
2012 Weather Normalized Source EUI (kBtu/ft2)
_2012_weather_normalized_source_eui_kbtu_sq_ft
2011 ENERGY STAR Score
_2011_energy_star_score
2011 Site EUI (kBtu/ft2)
_2011_site_eui_kbtu_ft2
2011 Source EUI (kBtu/ft2)
_2011_source_eui_kbtu_ft2
2011 Percent Better than National Median Site EUI
_2011_percent_better_than_national_median_site_eui
2011 Weather Normalized Site EUI (kBtu/ft2)
_2011_weather_normalized_site_eui_kbtu_ft2
2011 Weather Normalized Source EUI (kBtu/ft2)
_2011_weather_normalized_source_eui_kbtu_ft2
2022 Benchmark Status
_2022_benchmark_status
2022 Reason for Exemption
_2022_reason_for_exemption
2021 Benchmark Status
_2021_benchmark_status
2021 Reason for Exemption
_2021_reason_for_exemption
2020 Benchmark Status
benchmark_2020_status
2020 Reason for Exemption
_2020_reason_for_exemption
2019 Benchmark Status
benchmark_2019_status
2019 Reason for Exemption
a_2019_reason_for_exemption
2018 Benchmark Status
benchmark_2018_status
2018 Reason for Exemption
_2018_reason_for_exemption
2017 Benchmark Status
benchmark_2017_status
2017 Reason for Exemption
_2017_reason_for_exemption
2016 Benchmark Status
benchmark_2016_status
2016 Reason for Exemption
_2016_reason_for_exemption
2015 Benchmark Status
benchmark_2015_status
2015 Reason for Exemption
_2015_reason_for_exemption
2014 Benchmark Status
benchmark_2014_status
2014 Reason for Exemption
_2014_reason_for_exemption
2013 Benchmark Status
benchmark_2013_status
2013 Reason for Exemption
_2013_reason_for_exemption
2012 Benchmark Status
benchmark_2012_status
2012 Reason for Exemption
_2012_reason_for_exemption
2011 Benchmark Status
benchmark_2011_status
2011 Reason for Exemption
_2011_reason_for_exemption

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.