2018 Kansas City Energy and Water Consumption Benchmarking for Community-Wide Buildings v1.0
data.kcmo.org | Last Updated 26 Jul 2019The 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.
This dataset has the following 18 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Property Name | property_name | text | Building name assigned by point of contact for property | Metro Park Warehouse Kansas City International Paper Kansas City Container Smith Hale College Prep Tiffany II view top 100 |
| Year Ending | year_ending | text | The last date in the full year period in which metrics are taken | 2018-12-31T00:00:00.000 view top 100 |
| Street Address | street_address | text | Street Address | 933 McGee St 4900 Oak St 410 Nichols Rd 7312 NW Polo Dr 106 W 12th St view top 100 |
| City | city | text | City that the building is located in. Kansas City Missouri. | Kansas City KANSAS CITY kansas city Kansas CIty Kansas Citgy view top 100 |
| State/Province | state_province | text | State the building is located in. Missouri | Missouri view top 100 |
| Postal Code | postal_code | text | The zip code the building is located in. | 64105 64108 64112 64111 64120 view top 100 |
| Kansas City Building Reporting ID | kansas_city_building_reporting | text | Unique (with a few exceptions) ID that identifies the building being submitted. | NA 11-IS-03230 11-IS-03215 52-CM-00810 53-CM-07350 view top 100 |
| Primary Property Type - Self Selected | primary_property_type_self | text | A self-selected main property use type | Multifamily Housing Office K-12 School Hotel Manufacturing/Industrial Plant view top 100 |
| Primary Property Type - Portfolio Manager-Calculated | primary_property_type | text | A calculated property use type based of the use that has the most SQFT assigned to it. | Multifamily Housing Office K-12 School Manufacturing/Industrial Plant Hotel view top 100 |
| Property GFA - Calculated (Buildings and Parking) (ft²) | property_gfa_calculated_1 | number | Total SQFT between the building and parking | 210000 57000 60000 67000 100000 view top 100 |
| Property GFA - Calculated (Buildings) (ft²) | property_gfa_calculated | number | Total building SQFT (does not include parking) | 210000 57000 100000 60000 67000 view top 100 |
| Property GFA - Calculated (Parking) (ft²) | property_gfa_calculated_2 | text | Total Parking SQFT (does not include building SQFT) | NA 10000 25000 100000 20000 view top 100 |
| Weather Normalized Source EUI (kBtu/ft²) | weather_normalized_source | number | Energy use per SQFT that has been normalized to account for both weather and source of energy | 97 94.7 211.3 46.7 74.5 view top 100 |
| Weather Normalized Site EUI (kBtu/ft²) | weather_normalized_site_eui | number | Energy 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. | 37.8 33.8 74 53.9 44.6 view top 100 |
| Direct GHG Emissions (Metric Tons CO2e) | direct_ghg_emissions_metric | number | Direct GHG (low amounts tend to round to 0) | 0 0.1 92.5 149.4 94.5 view top 100 |
| Indirect GHG Emissions (Metric Tons CO2e) | indirect_ghg_emissions_metric | number | Indirect GHG (low amounts tend to round to 0) | 0 870.1 713.4 287 622.5 view top 100 |
| Water Use (All Water Sources) (kgal) | water_use_all_water_sources | number | Water metric from indoor, outdoor, and mixed meters | 7.7 5.6 1625 2323.6 638.9 view top 100 |
| ENERGY STAR Score | energy_star_score | number | A 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. | 100 1 78 71 61 view top 100 |