2018 Kansas City Energy and Water Consumption Benchmarking for Community-Wide Buildings v1.0

data.kcmo.org | Last Updated 26 Jul 2019

The first version of the 2018 Energy and Water consumption sent to the City by owners of buildings 50,000 SQFT or greater using the Energy Star Portfolio Manager tool. Data is required by the Energy Empowerment Ordinance in Kansas City, Missouri. The data were collected in 2019 and might be appended as new submissions come in.

Tags: energy, energy benchmarking, sustainability, energy empowerment ordinance, compliance, energy star, environmental quality, green

This dataset has the following 18 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Property Nameproperty_nametextBuilding name assigned by point of contact for property
Year Endingyear_endingtextThe last date in the full year period in which metrics are taken
Street Addressstreet_addresstextStreet Address
CitycitytextCity that the building is located in. Kansas City Missouri.
State/Provincestate_provincetextState the building is located in. Missouri
Postal Codepostal_codetextThe zip code the building is located in.
Kansas City Building Reporting IDkansas_city_building_reportingtextUnique (with a few exceptions) ID that identifies the building being submitted.
Primary Property Type - Self Selectedprimary_property_type_selftextA self-selected main property use type
Primary Property Type - Portfolio Manager-Calculatedprimary_property_typetextA calculated property use type based of the use that has the most SQFT assigned to it.
Property GFA - Calculated (Buildings and Parking) (ft²)property_gfa_calculated_1numberTotal SQFT between the building and parking
Property GFA - Calculated (Buildings) (ft²)property_gfa_calculatednumberTotal building SQFT (does not include parking)
Property GFA - Calculated (Parking) (ft²)property_gfa_calculated_2textTotal Parking SQFT (does not include building SQFT)
Weather Normalized Source EUI (kBtu/ft²)weather_normalized_sourcenumberEnergy use per SQFT that has been normalized to account for both weather and source of energy
Weather Normalized Site EUI (kBtu/ft²)weather_normalized_site_euinumberEnergy use per SQFT that has been normalized to account for weather. compared to Site, this is more reflective of what you'd find on a utility billing statement.
Direct GHG Emissions (Metric Tons CO2e)direct_ghg_emissions_metricnumberDirect GHG (low amounts tend to round to 0)
Indirect GHG Emissions (Metric Tons CO2e)indirect_ghg_emissions_metricnumberIndirect GHG (low amounts tend to round to 0)
Water Use (All Water Sources) (kgal)water_use_all_water_sourcesnumberWater metric from indoor, outdoor, and mixed meters
ENERGY STAR Scoreenergy_star_scorenumberA score generated by the national Energy Star Program used to compare the building to other similar building types. The score is out of 1-100 where 50 is the median and 75 is at the upper quartile. Not all buildings are eligible for a score.