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.036144
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, 2014

@usgov.ca_gov_state_buildings_sustainability_metrics.state_buildings_sustainability_metrics_2014

227.33 kB
1,722 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  -- Property GFA - EPA Calculated (Buildings) (ft²),
  "primary_property_type_self_selected" VARCHAR  -- Primary Property Type - Self Selected,
  "year_built" BIGINT,
  "electricity_use_generated_from_onsite_renewable_system_436fa1a2" DOUBLE  -- Electricity Use  Generated From Onsite Renewable Systems And Used Onsite (kWh),
  "electricity_use_grid_purchase_kwh" DOUBLE  -- Electricity Use - Grid Purchase (kWh),
  "natural_gas_use_therms" DOUBLE  -- Natural Gas Use (therms),
  "propane_use_kbtu" DOUBLE  -- Propane Use (kBtu),
  "water_use_all_water_sources_kgal" DOUBLE  -- Water Use (All Water Sources) (kgal),
  "percent_of_electricity_that_is_green_power" VARCHAR,
  "green_power_onsite_and_offsite_kwh" DOUBLE  -- Green Power - Onsite And Offsite (kWh),
  "site_energy_use_kbtu" DOUBLE  -- Site Energy Use (kBtu),
  "energy_star_score" DOUBLE,
  "leed_certified" VARCHAR,
  "location" VARCHAR
);