State Buildings Sustainability Metrics by US Government | Finance and Economics

About this Dataset

State Buildings Sustainability Metrics

This data set lists sustainability metric data for state-owned buildings. These data are used to track state departments’ progress toward the goals mandated in Executive Order B-18-12. The metrics tracked in this set are total water use, total energy use, renewable energy generation and LEED certifications. The data set also includes building information for the 1722 buildings listed including, building name, address, total square footage and use type. These data are entered by property owners from each state department into the database Energy Star Portfolio Manager. Most data are obtained by property owner using the utility bill; however, some of the information is automatically fed into the database by the utility company.
Organization: State of California
Last updated: 2021-09-08T16:15:46.036137
Tags: benchmarking, buildings, climate-change, dgs, efficiency, electricity, energy, energy-efficiency, energy-star, energy-use-intensity, eui, executive-order, gas, ghg, greenbuilding, leed, portfolio-management, reduction, renewable, score, spi, state-buildings, state-property-inventory, sustainability, utility, water, water-conservation

Tables

State Buildings Sustainability Metrics, 2013

@usgov.ca_gov_state_buildings_sustainability_metrics.state_buildings_sustainability_metrics_2013

220.11 KB
1722 rows
23 columns


CREATE TABLE state_buildings_sustainability_metrics_2013 (
  "department" VARCHAR,
  "department_name" VARCHAR,
  "property_id" BIGINT,
  "property_name" VARCHAR,
  "year_ending" TIMESTAMP,
  "address_1" VARCHAR,
  "city" VARCHAR,
  "state_province" VARCHAR,
  "postal_code" VARCHAR,
  "property_gfa_epa_calculated_buildings_ft" DOUBLE,
  "primary_property_type_self_selected" VARCHAR,
  "year_built" BIGINT,
  "electricity_use_generated_from_onsite_renewable_system_436fa1a2" DOUBLE,
  "electricity_use_grid_purchase_kwh" DOUBLE,
  "natural_gas_use_therms" DOUBLE,
  "propane_use_kbtu" DOUBLE,
  "water_use_all_water_sources_kgal" DOUBLE,
  "percent_of_electricity_that_is_green_power" VARCHAR,
  "green_power_onsite_and_offsite_kwh" DOUBLE,
  "site_energy_use_kbtu" DOUBLE,
  "energy_star_score" DOUBLE,
  "leed_certified" VARCHAR,
  "location" VARCHAR
);

State Buildings Sustainability Metrics, 2014

@usgov.ca_gov_state_buildings_sustainability_metrics.state_buildings_sustainability_metrics_2014

222 KB
1722 rows
23 columns


CREATE TABLE state_buildings_sustainability_metrics_2014 (
  "department" VARCHAR,
  "department_name" VARCHAR,
  "property_id" BIGINT,
  "property_name" VARCHAR,
  "year_ending" TIMESTAMP,
  "address_1" VARCHAR,
  "city" VARCHAR,
  "state_province" VARCHAR,
  "postal_code" VARCHAR,
  "property_gfa_epa_calculated_buildings_ft" DOUBLE,
  "primary_property_type_self_selected" VARCHAR,
  "year_built" BIGINT,
  "electricity_use_generated_from_onsite_renewable_system_436fa1a2" DOUBLE,
  "electricity_use_grid_purchase_kwh" DOUBLE,
  "natural_gas_use_therms" DOUBLE,
  "propane_use_kbtu" DOUBLE,
  "water_use_all_water_sources_kgal" DOUBLE,
  "percent_of_electricity_that_is_green_power" VARCHAR,
  "green_power_onsite_and_offsite_kwh" DOUBLE,
  "site_energy_use_kbtu" DOUBLE,
  "energy_star_score" DOUBLE,
  "leed_certified" VARCHAR,
  "location" VARCHAR
);