2019 Kansas City Energy and Water Consumption Benchmarking for City-Owned Buildings
data.kcmo.org | Last Updated 31 Aug 20202019 Energy and Water consumption of City-Owned buildings 10,000 SQFT or greater, required by the Energy Empowerment Ordinance, using the Energy Star Portfolio Manager tool. The City provided some buildings below this threshold when available. The data were collected in 2020.
This dataset has the following 48 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 | SPEC Building Pioneer College KCI-Parking And Bus Administration Rocky Branch Treatment Plant Garage-1220 Walnut view top 100 |
Year Ending | year_ending | calendar_date | The last date in the full year period in which metrics are taken | 2019-12-31T00:00:00.000 view top 100 |
Street Address | street_address | text | Street Address | 9701 Marion Park Dr. 7601 Prospect Ave. 5900 Swope Pkwy 301 West 13th Street 1703 American Royal Ct. view top 100 |
City | city | text | City that the building is located in: Kansas City, Missouri. | Kansas City Kansas CIty 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. | 64153 64105 64132 64106 64108 view top 100 |
Property GFA - Calculated (Buildings and Parking) (ft²) | property_gfa_calculated | number | Total SQFT between the building and parking | 150000 25848 48000 17592 25000 view top 100 |
Property GFA - Calculated (Buildings) (ft²) | property_gfa_calculated_1 | number | Total building SQFT (does not include parking) | 150000 25848 48000 17592 25000 view top 100 |
Property GFA - Calculated (Parking) (ft²) | property_gfa_calculated_2 | number | Total Parking SQFT (does not include building SQFT) | 7600 7604 41770 82650 93825 view top 100 |
Primary Property Type - Self Selected | primary_property_type_self | text | A self-selected main property use type | Fire Station Police Station Office Other - Recreation Parking view top 100 |
List of All Property Use Types at Property | list_of_all_property_use | text | All property uses identified for the building | Fire Station Other Police Station Office Other - Recreation 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. | 1 87 12 21 23 view top 100 |
Site Energy Use (kBtu) | site_energy_use_kbtu | number | Total Site Energy use among all meter source types | 5830.7 9187.6 18756.8 64780.8 85162.5 view top 100 |
Site EUI (kBtu/ft²) | site_eui_kbtu_ft | number | Site Energy use per square foot | 2.3 83.9 107.4 100.9 75.1 view top 100 |
National Median Site Energy Use (kBtu) | national_median_site_energy | number | The median Site Energy use across building with the same use type and size | 30607.9 46820.9 52176.7 66501.3 68707.7 view top 100 |
National Median Site EUI (kBtu/ft²) | national_median_site_eui | number | The median Site Energy use per SQFT across building with the same use type and size | 63.5 31.9 52.9 44.6 40 view top 100 |
% Difference from National Median Site EUI | difference_from_national | number | % Difference between median and actual | 43.7 3 -92.5 240.2 199.5 view top 100 |
Source Energy Use (kBtu) | source_energy_use_kbtu | number | Total Source Energy use among all meter source types | 16326.1 25725.3 52519.1 181386.2 238455 view top 100 |
Source EUI (kBtu/ft²) | source_eui_kbtu_ft | number | Source Energy Use per SQFT | 150.3 64.6 6.5 190.6 344.5 view top 100 |
National Median Source Energy Use (kBtu) | national_median_source_energy | number | The median Source Energy use across building with the same use type and size | 84603.9 85702 146094.9 151281.4 161136.5 view top 100 |
National Median Source EUI (kBtu/ft²) | national_median_source_eui | number | The median Source Energy use per SQFT across building with the same use type and size | 124.9 89.3 112 116.4 96.9 view top 100 |
% Difference from National Median Source EUI | difference_from_national_1 | number | % Difference between median and actual | 43.7 3 -92.5 240.2 199.5 view top 100 |
Weather Normalized Site Energy Use (kBtu) | weather_normalized_site_energy | number | Total Site Energy use among all meter source types (normalized for weather) | 5830.7 9219 18756.8 64699.9 85162.5 view top 100 |
Weather Normalized Site EUI (kBtu/ft²) | weather_normalized_site_eui | number | Site Energy use per square foot (normalized for weather) | 89.3 72.4 34.8 83.9 2.3 view top 100 |
Weather Normalized Source Energy Use (kBtu) | weather_normalized_source | number | Total Source Energy use among all meter source types (normalized for weather) | 16326.1 25813.2 52519.1 181159.7 238455 view top 100 |
Weather Normalized Source EUI (kBtu/ft²) | weather_normalized_source_1 | number | Site Energy use per square foot (normalized for weather) | 150.6 6.5 14 233.6 216.7 view top 100 |
Energy Cost ($) | energy_cost | number | Amount spent on Energy | 629.4 360906.46 165789 4731.48 87251.23 view top 100 |
Energy Cost Intensity ($/ft²) | energy_cost_intensity_ft | number | Amount spent on energy per square foot | 1.95 1.41 1.76 1.85 1.96 view top 100 |
Water Use (All Water Sources) (kgal) | water_use_all_water_sources | number | Water usage | 0 306.1 1262.1 847.4 175.2 view top 100 |
Water Use Intensity (All Water Sources) (gal/ft²) | water_use_intensity_all_water | number | Water usage per square foot | 0 0.01 0.03 0.49 0.69 view top 100 |
Direct GHG Emissions (Metric Tons CO2e) | direct_ghg_emissions_metric | number | Direct GHG emissions | 0 32 49.1 175.6 23 view top 100 |
Direct GHG Emissions Intensity (kgCO2e/ft²) | direct_ghg_emissions_intensity | number | Direct GHG emissions per SQFT | 0 3.2 3.3 0.2 3.1 view top 100 |
Indirect GHG Emissions (Metric Tons CO2e) | indirect_ghg_emissions_metric | number | Indirect GHG emissions | 0 62.3 75.9 45.2 9 view top 100 |
Indirect GHG Emissions Intensity (kgCO2e/ft²) | indirect_ghg_emissions | number | Indirect GHG emissions per SQFT | 0 6.2 6.7 1.4 3.8 view top 100 |
eGRID Subregion | egrid_subregion | text | Subregion of eGRID which is the source of data on the environmental characteristics of almost all electric power generated in the United States. | (SPNO) SPNO (KS-Western MO) (SRMW) SRMW (Middle Mississippi) (NYUP) NYUP (Upstate NY) view top 100 |
eGRID Output Emissions Rate (kgCO2e/MBtu) | egrid_output_emissions_rate | number | This is the emissions taken from the eGRID subregion | 189.1 215.7 39.3 view top 100 |
Kansas City Building Reporting ID | kansas_city_building_reporting | text | Unique building ID for identification | 30-IS-05910 16-IS-03900 27-IS-01915 30-IS-04910 20-IS-01620 view top 100 |
Natural Gas Use (kBtu) | natural_gas_use_kbtu | number | Natural gas usage | 10704469.1 23395981.1 925113 1703420.6 3305122.4 view top 100 |
District Steam Use (kBtu) | district_steam_use_kbtu | number | District steam usage | 2179565.6 5048752.5 9518403.4 11723299.9 16045608.5 view top 100 |
District Hot Water Use (kBtu) | district_hot_water_use_kbtu | text | District Hot Water usage | view top 100 |
District Chilled Water Use (kBtu) | district_chilled_water_use | number | District Chilled Water usage | 4932168 6674338.7 view top 100 |
Electricity Use – Generated from Onsite Renewable Systems and Used Onsite (kWh) | electricity_use_generated | text | Renewable Electricity usage | view top 100 |
Total GHG Emissions (Metric Tons CO2e) | total_ghg_emissions_metric | number | Total GHG emissions | 0 52.6 146.2 6695 264 view top 100 |
Total GHG Emissions Intensity (kgCO2e/ft²) | total_ghg_emissions_intensity | number | Total GHG emissions per SQFT | 0 3.6 7.2 15.9 19.1 view top 100 |
Electricity Use - Grid Purchase (kBtu) | electricity_use_grid_purchase | number | Electricity grid usage | 2346606.3 1405999.3 4154029.1 1280297 85162.5 view top 100 |
Cooling Degree Days (CDD) (°F) | cooling_degree_days_cdd_f | number | Number of days you would have to cool your building by 1 degree to accommodate the heating requirement. | 1874 1400 1334 1417 603 view top 100 |
Heating Degree Days (HDD) (°F) | heating_degree_days_hdd_f | number | Number of days you would have to heat your building by 1 degree to accommodate the heating requirement. | 4925 5403 5395 5747 5928 view top 100 |
Weather Station Name | weather_station_name | text | Name of weather station that weather data is being taken from | CHARLES B WHEELER D KANSAS CITY INTL JOHNSON CO EXECUTIVE ST. JOSEPH/ROSE-CRA GREATER BUFFALO INT view top 100 |