About this Dataset

Existing Buildings Energy & Water Efficiency (EBEWE) Program

The City's Existing Buildings Energy & Water Efficiency (EBEWE) Program was established in 2016 (LA Municipal Code Section 91.9701, Ordinance No. 184674) and is administered by the Department of Building and Safety(LADBS). It requires that owners of buildings subject to the Ordinance, to annually register their building (includes pay fees) and file a benchmark report of energy and water usage for their buildings for the Compliance Year. The EBEWE dataset includes the Compliance Year, Building Address, Compliance Status, various energy and water use benchmark data, and the last 3 digits of the Assessor Identification Number (AIN). For a complete explanation of the Program, including reporting requirements, please visit LADBS' EBEWE site at http://www.ladbs.org/services/green-building-sustainability/existing-buildings-energy-water-efficiency-program.
Organization: City of Los Angeles
Last updated: 2020-11-10T17:52:12.179106
Tags: 184675, 185198, benchmark, carbon-emission, ebewe, energy-efficiency, energy-star-rating, energy-star-score, energy-usage, eui, water-efficiency, water-usage, weather-normalized

Tables

Table 1

@usgov.city_of_los_angeles_existing_buildings_energy_water_ef_74a79f9a.table_1

2.87 MB
85,267 rows
28 columns

CREATE TABLE table_1 (
  "building_address" VARCHAR,
  "building_id" BIGINT,
  "carbon_dioxide_emissions_metric_ton_co2e" VARCHAR  -- CARBON DIOXIDE EMISSIONS (Metric Ton CO2e),
  "compliance_status" VARCHAR,
  "n__difference_from_national_median_source_eui" VARCHAR  -- % DIFFERENCE FROM NATIONAL MEDIAN SOURCE EUI,
  "n__difference_from_national_median_site_eui" VARCHAR  -- % DIFFERENCE FROM NATIONAL MEDIAN SITE EUI,
  "energy_star_score" VARCHAR,
  "energy_star_certification_eligibility" VARCHAR  -- ENERGY STAR CERTIFICATION - ELIGIBILITY,
  "energy_star_certification_last_approval_date" VARCHAR  -- ENERGY STAR CERTIFICATION - LAST APPROVAL DATE,
  "energy_star_certification_year_s_certified" VARCHAR  -- ENERGY STAR CERTIFICATION - YEAR(S) CERTIFIED,
  "entity_responsible_for_benchmark" VARCHAR,
  "gross_building_floor_area_ft" DOUBLE  -- GROSS BUILDING FLOOR AREA (ft²),
  "indoor_water_use_kgal" VARCHAR  -- INDOOR WATER USE (kgal),
  "indoor_water_use_intensity_gal_ft" VARCHAR  -- INDOOR WATER USE INTENSITY (gal/ft²),
  "number_of_buildings" DOUBLE,
  "occupancy" DOUBLE,
  "outdoor_water_use_kgal" VARCHAR  -- OUTDOOR WATER USE (kgal),
  "postal_code" BIGINT,
  "program_year" BIGINT,
  "property_type" VARCHAR,
  "site_energy_use_intensity_eui_kbtu_ft" VARCHAR  -- SITE ENERGY USE INTENSITY (EUI) (kBtu/ft²),
  "source_eui_kbtu_ft" VARCHAR  -- Source EUI (kBtu/ft²),
  "total_water_use_kgal" VARCHAR  -- TOTAL WATER USE (kgal),
  "weather_normalized_site_energy_use_intensity_eui_kbtu_ft" VARCHAR  -- WEATHER NORMALIZED SITE ENERGY USE INTENSITY (EUI) (kBtu/ft²),
  "weather_normalized_source_energy_use_intensity_eui_kbtu_ft" VARCHAR  -- WEATHER NORMALIZED SOURCE ENERGY USE INTENSITY (EUI) (kBtu/ft²),
  "year_built" DOUBLE,
  "ain" VARCHAR,
  "ladbs_building_category" VARCHAR
);