About this Dataset

Municipal Building Energy Use

Monthly energy use metrics for City-owned properties generated by Energy STAR Portfolio Manager (ESPM). Metrics include energy use (electric and gas) and those generated by ESPM: Site EUI (Energy Use Intensity) measured in energy use per square foot, Greenhouse Gas Emissions (Metric Tons CO2e), and Energy STAR Score where available.

Available at https://nola.gov/next/resilience-sustainability/energy/municipal-building-energy-use-dashboard.

Data updates monthly.
Organization: City of New Orleans
Last updated: 2025-06-14T17:30:43.816225
Tags: resilience, sustainability

Tables

Table 1

@usgov.city_of_new_orleans_municipal_building_energy_use.table_1

2.13 MB
16,343 rows
59 columns

CREATE TABLE table_1 (
  "month" VARCHAR,
  "property_name" VARCHAR,
  "parent_property_name" VARCHAR,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "city" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "country" VARCHAR,
  "property_gfa_self_reported_sq_ft" BIGINT  -- Property GFA - Self-Reported (sq.ft.),
  "year_built" BIGINT,
  "portfolio_manager_property_id" BIGINT,
  "electricity_use_grid_purchase_kwh" DOUBLE  -- Electricity Use - Grid Purchase (kWh),
  "electricity_use_grid_purchase_kbtu" DOUBLE  -- Electricity Use - Grid Purchase (kBtu),
  "electricity_use_generated_from_onsite_renewable_system_436fa1a2" VARCHAR  -- Electricity Use – Generated From Onsite Renewable Systems And Used Onsite (kWh),
  "electricity_use_generated_from_onsite_renewable_system_a82eeb5b" VARCHAR  -- Electricity Use – Generated From Onsite Renewable Systems And Used Onsite (kBtu),
  "electricity_use_grid_purchase_and_generated_from_onsit_e4713417" DOUBLE  -- Electricity Use - Grid Purchase And Generated From Onsite Renewable Systems (kWh),
  "electricity_use_grid_purchase_and_generated_from_onsit_564ca541" DOUBLE  -- Electricity Use - Grid Purchase And Generated From Onsite Renewable Systems (kBtu),
  "electricity_weather_normalized_site_electricity_use_gr_7f7dcbfe" DOUBLE  -- Electricity - Weather Normalized Site Electricity Use (Grid And Onsite Renewables) (kBtu),
  "electricity_weather_normalized_site_electricity_use_gr_4146dc2c" DOUBLE  -- Electricity - Weather Normalized Site Electricity Use (Grid And Onsite Renewables) (kWh),
  "electricity_weather_normalized_site_electricity_intens_8e9b1e26" DOUBLE  -- Electricity - Weather Normalized Site Electricity Intensity (Grid And Onsite Renewables) (kWh/sq.ft.),
  "electricity_use_grid_monthly_kbtu" DOUBLE  -- Electricity Use (Grid) - Monthly (kBtu),
  "electricity_use_onsite_renewables_monthly_kbtu" VARCHAR  -- Electricity Use - Onsite Renewables - Monthly (kBtu),
  "percent_electricity" DOUBLE,
  "natural_gas_use_therms" DOUBLE  -- Natural Gas Use (therms),
  "natural_gas_use_kbtu" DOUBLE  -- Natural Gas Use (kBtu),
  "natural_gas_weather_normalized_site_natural_gas_use_kbtu" DOUBLE  -- Natural Gas - Weather Normalized Site Natural Gas Use (kBtu),
  "natural_gas_weather_normalized_site_natural_gas_use_therms" DOUBLE  -- Natural Gas - Weather Normalized Site Natural Gas Use (therms),
  "natural_gas_weather_normalized_site_natural_gas_intens_348e62f9" DOUBLE  -- Natural Gas - Weather Normalized Site Natural Gas Intensity (therms/sq.ft.),
  "natural_gas_use_monthly_kbtu" DOUBLE  -- Natural Gas Use - Monthly (kBtu),
  "energy_star_score" DOUBLE,
  "site_energy_use_kbtu" DOUBLE  -- Site Energy Use (kBtu),
  "source_energy_use_kbtu" DOUBLE  -- Source Energy Use (kBtu),
  "site_eui_kbtu_sq_ft" DOUBLE  -- Site EUI (kBtu/sq.ft.),
  "source_eui_kbtu_sq_ft" DOUBLE  -- Source EUI (kBtu/sq.ft.),
  "weather_normalized_site_energy_use_kbtu" DOUBLE  -- Weather Normalized Site Energy Use (kBtu),
  "weather_normalized_source_energy_use_kbtu" DOUBLE  -- Weather Normalized Source Energy Use (kBtu),
  "weather_normalized_site_eui_kbtu_sq_ft" DOUBLE  -- Weather Normalized Site EUI (kBtu/sq.ft.),
  "weather_normalized_source_eui_kbtu_sq_ft" DOUBLE  -- Weather Normalized Source EUI (kBtu/sq.ft.),
  "national_median_site_energy_use_kbtu" DOUBLE  -- National Median Site Energy Use (kBtu),
  "national_median_source_energy_use_kbtu" DOUBLE  -- National Median Source Energy Use (kBtu),
  "national_median_site_eui_kbtu_sq_ft" DOUBLE  -- National Median Site EUI (kBtu/sq.ft.),
  "national_median_source_eui_kbtu_sq_ft" DOUBLE  -- National Median Source EUI (kBtu/sq.ft.),
  "n__difference_from_national_median_site_eui" DOUBLE  -- % Difference From National Median Site EUI,
  "n__difference_from_national_median_source_eui" DOUBLE  -- % Difference From National Median Source EUI,
  "site_energy_use_adjusted_to_current_year_kbtu" DOUBLE  -- Site Energy Use - Adjusted To Current Year (kBtu),
  "site_eui_adjusted_to_current_year_kbtu_sq_ft" DOUBLE  -- Site EUI - Adjusted To Current Year (kBtu/sq.ft.),
  "source_energy_use_adjusted_to_current_year_kbtu" DOUBLE  -- Source Energy Use - Adjusted To Current Year (kBtu),
  "source_eui_adjusted_to_current_year_kbtu_sq_ft" DOUBLE  -- Source EUI - Adjusted To Current Year (kBtu/sq.ft.),
  "total_location_based_ghg_emissions_metric_tons_co2e" DOUBLE  -- Total (Location-Based) GHG Emissions (Metric Tons CO2e),
  "total_location_based_ghg_emissions_intensity_kgco2e_sq_ft" DOUBLE  -- Total (Location-Based) GHG Emissions Intensity (kgCO2e/sq.ft.),
  "direct_ghg_emissions_metric_tons_co2e" DOUBLE  -- Direct GHG Emissions (Metric Tons CO2e),
  "direct_ghg_emissions_intensity_kgco2e_sq_ft" DOUBLE  -- Direct GHG Emissions Intensity (kgCO2e/sq.ft.),
  "indirect_location_based_ghg_emissions_metric_tons_co2e" DOUBLE  -- Indirect (Location-Based) GHG Emissions (Metric Tons CO2e),
  "indirect_location_based_ghg_emissions_intensity_kgco2e_sq_ft" DOUBLE  -- Indirect (Location-Based) GHG Emissions Intensity (kgCO2e/sq.ft.),
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "row_identifier" VARCHAR
);