aggs (stats, value_counts) not working when other doc_types have similar mappings for 1.5.1, works for 1.4.4

[alecklandgraf]

I saw an issue with aggs not working when upgrading from 1.4.4 to 1.5.1. I was able to reproduce with generic data in both a linux server (ubuntu on CircleCI) and OS X on my laptop locally. (nice to have CI)

After some debugging, I was able to narrow it down to adding a second mapping where the second mapping's doc type has the same name as the first mapping's nested object. The following script below will return 0 or null aggs results for the stats aggregation in 1.5.1 when the second mapping is applied. Without the second mapping, this isn't an issue, and in 1.4.4 this isn't an issue.

Cheers, Aleck

#!/bin/bash
# Aleck Landgraf - Elasticsearch 1.5.1 aggs tests with various mappings
# This test will return 0 or null aggregations for elasticsearch version 1.5.1
# and return valid aggs on 1.4.4. See output at the bottom.
#
# Comment out line 35 (mapping of building_snapshot) to work on 1.5.1.
#
# I've only tested for the value_counts and stats aggs, but more are probably
# affected.

echo ""
echo "get elasticsearch version for debug"
echo ""
curl -XGET localhost:9200
echo ""

echo ""
echo "drop index"
echo ""
curl -XDELETE localhost:9200/test
echo ""

echo ""
echo ""
echo "create index"
echo ""
curl -XPUT localhost:9200/test
echo ""

echo ""
echo "create mappings"
echo ""
curl -XPUT localhost:9200/test/_mapping/test -d '{"test": {"properties": {"building_snapshot": {"properties": {"lot_number": {"type": "string"}, "owner_address": {"type": "string"}, "owner_postal_code": {"type": "string"}, "block_number": {"type": "string"}, "project_buildings": {"type": "nested"}, "source_eui_weather_normalized": {"type": "float"}, "owner_email": {"type": "string"}, "year_ending": {"type": "date"}, "building_count": {"type": "float"}, "meters": {"index_name": "meter", "type": "string"}, "owner": {"type": "string"}, "site_eui": {"type": "float"}, "address_line_1": {"type": "string"}, "occupied_floor_area": {"type": "float"}, "source_eui": {"type": "float"}, "custom_id_1": {"index": "not_analyzed", "type": "string", "doc_values": true}, "city": {"type": "string"}, "property_notes": {"type": "string"}, "district": {"type": "string"}, "location": {"type": "geo_point"}, "latitude": {"type": "float"}, "generation_date": {"type": "date"}, "extra_data": {"type": "object", "properties": {"Wall Insulation Location": {"type": "string"}, "Audit Cost": {"ignore_malformed": true, "type": "float"}, "Design Food Sales - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Exterior Shading Type": {"type": "string"}, "Design Electricity Use - Grid Purchase (kBtu)": {"ignore_malformed": true, "type": "float"}, "Design Coal - Anthracite Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Static Pressure Reset Control": {"type": "string"}, "Annual Water Savings": {"ignore_malformed": true, "type": "float"}, "Library - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Evaporatively Cooled Condenser Minimum Temperature": {"ignore_malformed": true, "type": "float"}, "Weather Normalized Site Natural Gas Use (therms)": {"ignore_malformed": true, "type": "float"}, "Mailing Center/Post Office - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Fuel Interruptibility": {"type": "string"}, "Building air leakage": {"ignore_malformed": true, "type": "float"}, "Indoor Water Cost (All Water Sources) ($)": {"ignore_malformed": true, "type": "float"}, "Footprint Shape": {"type": "string"}, "Guiding Principle 4.7 Indoor Environment - Tobacco Smoke Control": {"type": "string"}, "Hotel - Gym/fitness Center Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Refrigerant Return Line Diameter": {"ignore_malformed": true, "type": "float"}, "Transportation Terminal/Station - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Other - Recreation - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Outside Air Reset Minimum Heating Supply Temperature": {"ignore_malformed": true, "type": "float"}, "Typical Exterior Shading Depth": {"ignore_malformed": true, "type": "float"}, "Annual Net Emissions": {"ignore_malformed": true, "type": "float"}, "Combustion Efficiency": {"ignore_malformed": true, "type": "float"}, "Non-Refrigerated Warehouse - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Design Other - Entertainment/Public Assembly - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Schedule End Month": {"ignore_malformed": true, "type": "float"}, "Police Station - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Other - Mall - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Other - Education - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Ignition Type": {"type": "string"}, "PV Module Rated Power": {"ignore_malformed": true, "type": "float"}, "Space Occupant Capacity": {"ignore_malformed": true, "type": "float"}, "Supply Duct Percent Conditioned Space": {"ignore_malformed": true, "type": "float"}, "Medical Office - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Water collected for Reuse": {"type": "string"}, "Convenience Store without Gas Station - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Minimum Fan Speed as a Fraction of Maximum - Heating": {"ignore_malformed": true, "type": "float"}, "Senior Care Community - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Conveyance Standby Time": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Lighting Control Type Manual": {"type": "string"}, "Wood Cost ($)": {"ignore_malformed": true, "type": "float"}, "Hotel- Number of guest meals served per year": {"ignore_malformed": true, "type": "float"}, "Floors Above Grade": {"ignore_malformed": true, "type": "float"}, "Contact Name": {"type": "string"}, "Enclosed Mall - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Cooling Delivery Type": {"type": "string"}, "Dishwasher Year of Manufacture": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Percent of Total Electricity Generated from Onsite Renewable Systems": {"ignore_malformed": true, "type": "float"}, "Water/Wastewater Site EUI - Adjusted to Current Year (kBtu/gpd)": {"ignore_malformed": true, "type": "float"}, "Design Manufacturing/Industrial Plant - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Personal Services (Health/Beauty, Dry Cleaning, etc.) - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Worship Facility - Commercial Refrigeration Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 1.4 Integrated -Occupant Feedback": {"type": "string"}, "Property Use Detail Alerts": {"type": "string"}, "Vertical Abutments": {"type": "string"}, "Premises Street Address 2": {"type": "string"}, "Evaporatively Cooled Condenser": {"type": "string"}, "Other - Stadium - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Premises Name": {"type": "string"}, "Foundation Wall Below Grade Depth": {"ignore_malformed": true, "type": "float"}, "Glass Type": {"type": "string"}, "Certification Version": {"type": "string"}, "Foundation Wall Insulation Continuity": {"type": "string"}, "Date Property Last Modified": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Bar/Nightclub - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Casino - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Other - Technology/Science - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Specular Reflectors": {"type": "string"}, "Repair Services (Vehicle, Shoe, Locksmith, etc.) - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Design Stadium (Open) - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Third Party Certification Date Achieved": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Design Other - Technology/Science - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Mailing Center/Post Office - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Casino - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Federal Agency/Department": {"type": "string"}, "Audit Date": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Aquarium - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Medical Office - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Owner City": {"type": "string"}, "Quantity of Processed Laundry": {"ignore_malformed": true, "type": "float"}, "NYC Borough, Block and Lot (BBL)": {"type": "string"}, "Premises Occupancy Classification": {"type": "string"}, "Other - Public Services - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 2.3 Energy - Onsite Renewable": {"type": "string"}, "Residence Hall/Dormitory - Room Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Interior Shading Type": {"type": "string"}, "Lifestyle Center - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Performing Arts - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "National Median Source Energy Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Floor Framing Factor": {"ignore_malformed": true, "type": "float"}, "Cooling Efficiency Units": {"type": "string"}, "Fuel Oil #4 Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Evaporatively Cooled Condenser Maximum Temperature": {"ignore_malformed": true, "type": "float"}, "Sequencing": {"type": "string"}, "Hotel- Hours per day guests on-site": {"ignore_malformed": true, "type": "float"}, "Other - Entertainment/Public Assembly - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Minimum Part Load Ratio": {"ignore_malformed": true, "type": "float"}, "Generation Capacity": {"ignore_malformed": true, "type": "float"}, "Water Fixture Fraction Hot Water": {"ignore_malformed": true, "type": "float"}, "Energy/Power Station - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Design Water/Wastewater Source EUI (kBtu/gpd)": {"ignore_malformed": true, "type": "float"}, "Other - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Primary Service Hot Water Type": {"type": "string"}, "Source Energy Use Intensity": {"ignore_malformed": true, "type": "float"}, "Multifamily Housing - Number of Bedrooms": {"ignore_malformed": true, "type": "float"}, "Shared Resource System": {"type": "string"}, "Worship Facility - Cooking Facilities": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 4.3 Indoor Environment - Automated Lighting Controls": {"type": "string"}, "K-12 School - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Design Medical Office - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Indoor Water Use (All Water Sources) (kgal)": {"ignore_malformed": true, "type": "float"}, "Movie Theater - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Regional Average EUI": {"type": "string"}, "Other - Education - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Dishwasher Quantity": {"ignore_malformed": true, "type": "float"}, "Design Electricity Use - Grid Purchase and Onsite Renewable Energy (kBtu)": {"ignore_malformed": true, "type": "float"}, "Energy/Power Station - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Pre-school/Daycare - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Motor Application": {"type": "string"}, "Premises County": {"type": "string"}, "Fire Station - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Other - Lodging/Residential - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Hotel- Number of Rooms": {"ignore_malformed": true, "type": "float"}, "Longitude": {"ignore_malformed": true, "type": "float"}, "Office - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Federal Property": {"type": "string"}, "Manufacturing/Industrial Plant - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Medical Office - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Outside Lighting Type": {"type": "string"}, "Pre-school/Daycare - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 1.3 Integrated - Plan": {"type": "string"}, "Medical Office - Surgery Center Size (ft2)": {"ignore_malformed": true, "type": "float"}, "Diesel Cost ($)": {"ignore_malformed": true, "type": "float"}, "Senior Care Community - Living Unit Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Complete Resource": {"type": "string"}, "Contact Type": {"type": "string"}, "Fuel Oil #1 Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Roof Insulation Material": {"type": "string"}, "Other - Technology/Science - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Hot Water Reset Control": {"type": "string"}, "College/University - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Solar Thermal System Collector Loop Type": {"type": "string"}, "Window Layout": {"type": "string"}, "Other - Specialty Hospital - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Most Recent Sale Date": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Social/Meeting Hall - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Other - Restaurant/Bar - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Design Residence Hall/Dormitory - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Daylighting Control Steps": {"type": "string"}, "Ice/Curling Rink - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Weather Normalized Site Natural Gas Intensity (therms/ft2)": {"ignore_malformed": true, "type": "float"}, "Door Operation": {"type": "string"}, "Fitness Center/Health Club/Gym - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Adult Education - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Other Water Sources: Combined Indoor/Outdoor or Other Use (kgal)": {"ignore_malformed": true, "type": "float"}, "Central Refrigeration System": {"type": "string"}, "Design Convenience Store with Gas Station - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Building Operator Type": {"type": "string"}, "Bank Branch - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Water Cost": {"ignore_malformed": true, "type": "float"}, "Pipe Location": {"type": "string"}, "Pump Control Type": {"type": "string"}, "Design Barracks - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Day Start Hour": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 5.5 Materials - Ozone Depleting Compounds": {"type": "string"}, "Skylight Layout": {"type": "string"}, "Design Fuel Oil #1 Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Design Fitness Center/Health Club/Gym - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Cost Effectiveness Screening Method": {"type": "string"}, "Metered Areas (Energy)": {"type": "string"}, "Restaurant - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Cooling Refrigerant": {"type": "string"}, "Certification Value": {"type": "string"}, "Financial Office - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Design Other - Stadium - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Wholesale Club/Supercenter- Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Pool Volume": {"ignore_malformed": true, "type": "float"}, "Floor Area Type": {"type": "string"}, "Hotel - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Roller Rink - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Static Pressure": {"ignore_malformed": true, "type": "float"}, "Other Water Sources - Outdoor Cost ($)": {"ignore_malformed": true, "type": "float"}, "Food Sales - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Part Load Ratio Below Which Hot Gas Bypass Operates": {"ignore_malformed": true, "type": "float"}, "Equipment Disposal and Salvage Costs": {"ignore_malformed": true, "type": "float"}, "Minimum Power Factor Without Penalty": {"ignore_malformed": true, "type": "float"}, "Wall Exterior Solar Absorptance": {"ignore_malformed": true, "type": "float"}, "HPWH Minimum Air Temperature": {"ignore_malformed": true, "type": "float"}, "Worship Facility - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Other Water Sources - Indoor Cost ($)": {"ignore_malformed": true, "type": "float"}, "Percent Better than National Median Water/Wastewater Site EUI": {"ignore_malformed": true, "type": "float"}, "Wholesale Club/Supercenter- Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Multifamily Housing - Number of Laundry Hookups in All Units": {"ignore_malformed": true, "type": "float"}, "Scenario Qualifier": {"type": "string"}, "Skylight Glazing": {"type": "string"}, "Audit Team Member Certification Type": {"type": "string"}, "Space Number of FTE Workers": {"ignore_malformed": true, "type": "float"}, "Convenience Store with Gas Station - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Courthouse - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Lamp Length": {"ignore_malformed": true, "type": "float"}, "Other - Entertainment/Public Assembly - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Fuel Oil (No. 5 and No. 6) Cost ($)": {"ignore_malformed": true, "type": "float"}, "Azimuth": {"ignore_malformed": true, "type": "float"}, "Auditor Qualification": {"type": "string"}, "Swimming Pool - Approximate Pool Size": {"ignore_malformed": true, "type": "float"}, "Number of Buildings": {"ignore_malformed": true, "type": "float"}, "Wall Insulation Condition": {"type": "string"}, "Fan Type": {"type": "string"}, "Design Other - Specialty Hospital - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Senior Care Community - Number of Residential Electronic Lift Systems": {"ignore_malformed": true, "type": "float"}, "Design Target Energy Cost ($)": {"ignore_malformed": true, "type": "float"}, "SHW Efficiency": {"ignore_malformed": true, "type": "float"}, "Typical Wall R-Value": {"ignore_malformed": true, "type": "float"}, "Conveyance Peak Time": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Other - Stadium - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Design Senior Care Community - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Data Center - PDU Output Site Energy (kWh)": {"ignore_malformed": true, "type": "float"}, "Space Name": {"type": "string"}, "Premises Year Completed": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Weather Normalized Site Electricity Intensity (kWh/ft2)": {"ignore_malformed": true, "type": "float"}, "End Use": {"type": "string"}, "Compressor Staging": {"type": "string"}, "Senior Care Community - Commercial Refrigeration Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Other - Recreation - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Motor Pole Count": {"ignore_malformed": true, "type": "float"}, "Number of Luminaires": {"ignore_malformed": true, "type": "float"}, "Schedule Day": {"ignore_malformed": true, "type": "float"}, "Room Density": {"ignore_malformed": true, "type": "float"}, "Adult Education - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Vocational School - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Reference For Rate Structure": {"type": "string"}, "Recirculation Flow Rate": {"ignore_malformed": true, "type": "float"}, "Indoor Water Intensity (All Water Sources) (gal/ft2)": {"ignore_malformed": true, "type": "float"}, "Floor Framing Material": {"type": "string"}, "Distribution Center - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Water Use Type": {"type": "string"}, "Space Floors Above Grade": {"ignore_malformed": true, "type": "float"}, "Natural Gas Cost ($)": {"ignore_malformed": true, "type": "float"}, "Design Convenience Store without Gas Station - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Hotel - Type of Laundry Facility": {"type": "string"}, "Manufacturing/Industrial Plant - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Solar Thermal System Storage Volume": {"ignore_malformed": true, "type": "float"}, "Measure Life": {"ignore_malformed": true, "type": "float"}, "Parasitic Fuel Consumption Rate": {"ignore_malformed": true, "type": "float"}, "Propane Cost ($)": {"ignore_malformed": true, "type": "float"}, "Net Refrigeration Capacity": {"ignore_malformed": true, "type": "float"}, "Owner Name": {"type": "string"}, "Capacity Unit": {"type": "string"}, "Other - Public Services - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Percent Better than National Median Source EUI": {"ignore_malformed": true, "type": "float"}, "Humidity Control Minimum": {"ignore_malformed": true, "type": "float"}, "Maximum Outside Air Flow Rate": {"ignore_malformed": true, "type": "float"}, "Pump Power Demand": {"ignore_malformed": true, "type": "float"}, "Deck Type": {"type": "string"}, "Target Source Energy Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Cooking Capacity Unit": {"type": "string"}, "Other - Public Services - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Distribution Center - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Primary Cooling Type": {"type": "string"}, "Financial Office - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Senior Care Community - Electronic Lift Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Site Energy Use Intensity": {"ignore_malformed": true, "type": "float"}, "Site EUI - Adjusted to Current Year (kBtu/ft2)": {"ignore_malformed": true, "type": "float"}, "Repair Services (Vehicle, Shoe, Locksmith, etc.) - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "K-12 School - Months in Use": {"ignore_malformed": true, "type": "float"}, "Floor Insulation Condition": {"type": "string"}, "Electricity": {"type": "string"}, "Municipally Supplied Reclaimed Water - Outdoor Use (kgal)": {"ignore_malformed": true, "type": "float"}, "Vocational School - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Other Water Sources - Indoor Use (kgal)": {"ignore_malformed": true, "type": "float"}, "Auditor Qualification State": {"type": "string"}, "Wholesale Club/Supercenter- Number of Open or Closed Refrigeration/Freezer Units": {"ignore_malformed": true, "type": "float"}, "PV System Racking System Tilt Angle Min": {"ignore_malformed": true, "type": "float"}, "Off-Cycle Heat Loss Coefficient": {"ignore_malformed": true, "type": "float"}, "Fast Food Restaurant - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Data Center - PDU Input Site Energy (kWh)": {"ignore_malformed": true, "type": "float"}, "Dishwasher Hot Water Use": {"ignore_malformed": true, "type": "float"}, "Distribution Center - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Pump Efficiency": {"ignore_malformed": true, "type": "float"}, "Distribution Center - Number of Walk-in Refrigeration/Freezer Units": {"ignore_malformed": true, "type": "float"}, "Floors Below Grade": {"ignore_malformed": true, "type": "float"}, "Transportation Terminal/Station - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Design Fuel Oil #5 & 6 Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Other - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Distribution Center - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 3.1 Indoor Water - Option 1": {"type": "string"}, "Guiding Principle 3.1 Indoor Water - Option 2": {"type": "string"}, "Electricity Price Escalation Rate": {"type": "string"}, "Retail Store - Number of Cash Registers": {"ignore_malformed": true, "type": "float"}, "Laboratory - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Indoor Arena - Ice Events": {"ignore_malformed": true, "type": "float"}, "Dryer Secondary Energy Use Per Load": {"ignore_malformed": true, "type": "float"}, "Investment in Energy Projects, Cumulative ($)": {"ignore_malformed": true, "type": "float"}, "Conveyance Peak Power": {"ignore_malformed": true, "type": "float"}, "Design Site Energy Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Suction Vapor Temperature": {"ignore_malformed": true, "type": "float"}, "Senior Care Community - Number of Residential Living Units": {"ignore_malformed": true, "type": "float"}, "Electrical Plug Load Intensity": {"ignore_malformed": true, "type": "float"}, "Bank Branch - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Design Hotel - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Alternative Water Generated On-Site - Outdoor Cost ($)": {"ignore_malformed": true, "type": "float"}, "Air Distribution Configuration": {"type": "string"}, "Electricity Use - Generated from Onsite Renewable Systems and Used Onsite (kWh)": {"ignore_malformed": true, "type": "float"}, "Skylight Window Treatments": {"type": "string"}, "Biomass GHG Emissions (MtCO2e)": {"ignore_malformed": true, "type": "float"}, "Race Track - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Supermarket/Grocery - Number of Walk-in Refrigeration/Freezer Units": {"ignore_malformed": true, "type": "float"}, "Veterinary Office - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Clothes Washer Loader Type": {"type": "string"}, "Design Supermarket/Grocery Store - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Design District Chilled Water Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Senior Care Community - Commercial Washing Machine Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Parking - Open Parking Lot Size (ft2)": {"ignore_malformed": true, "type": "float"}, "Direct GHG Emissions (MtCO2e)": {"ignore_malformed": true, "type": "float"}, "Race Track - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Chiller Compressor Type": {"type": "string"}, "Fast Food Restaurant - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Veterinary Office - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Design Energy Cost Intensity ($/ft2)": {"ignore_malformed": true, "type": "float"}, "Courthouse - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Cooling Equipment Maintenance Frequency": {"type": "string"}, "Medical Office - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Bowling Alley - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Boiler Insulation Thickness": {"ignore_malformed": true, "type": "float"}, "Supermarket/Grocery - Open or Closed Refrigeration Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Hospital (General Medical & Surgical) - Number of MRI Machines": {"ignore_malformed": true, "type": "float"}, "Property Data Administrator - Email": {"type": "string"}, "Coefficient of Performance": {"ignore_malformed": true, "type": "float"}, "Estimated Savings from Energy Projects, Cumulative ($)": {"ignore_malformed": true, "type": "float"}, "Other - Utility - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Design Social/Meeting Hall - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "District Steam Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Design Source EUI (kBtu/ft2)": {"ignore_malformed": true, "type": "float"}, "Design Source EUI": {"ignore_malformed": true, "type": "float"}, "Design Fuel Oil #2 Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Measure End Date": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Other - Entertainment/Public Assembly - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Office - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Design Wholesale Club/Supercenter - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Resource Units": {"type": "string"}, "Typical Skylight Frame Type": {"type": "string"}, "Stadium (Open) - Ice Events": {"ignore_malformed": true, "type": "float"}, "Diesel #2 Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Measure Description": {"type": "string"}, "Roof Insulation Continuity": {"type": "string"}, "Water Intensity": {"ignore_malformed": true, "type": "float"}, "Net Emissions (MtCO2e)": {"ignore_malformed": true, "type": "float"}, "Heat Pump Water Heater Refrigerant Designation": {"type": "string"}, "AC Adjusted": {"type": "string"}, "Medical Office - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Skylight Pitch": {"ignore_malformed": true, "type": "float"}, "Natural Gas": {"type": "string"}, "Supply Air Temperature Setpoint": {"ignore_malformed": true, "type": "float"}, "Publicly Subsidized": {"type": "string"}, "Kerosene Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Wholesale Club/Supercenter- Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Burner Turndown Ratio": {"ignore_malformed": true, "type": "float"}, "Skylights Visible Transmittance": {"ignore_malformed": true, "type": "float"}, "Ice/Curling Rink - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Design Target Source Energy Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Exterior Roughness": {"type": "string"}, "Rate Structure Sector": {"type": "string"}, "Chilled Water Supply Temperature": {"ignore_malformed": true, "type": "float"}, "Exterior Wall Color": {"type": "string"}, "Emissions Factor": {"ignore_malformed": true, "type": "float"}, "Storage Tank Insulation Thickness": {"ignore_malformed": true, "type": "float"}, "Static Pressure - Installed": {"ignore_malformed": true, "type": "float"}, "Fixed Monthly Charge": {"ignore_malformed": true, "type": "float"}, "Lighting Efficacy": {"ignore_malformed": true, "type": "float"}, "Parking - Partially Enclosed Parking Garage Size (ft2)": {"ignore_malformed": true, "type": "float"}, "Senior Care Community - Average Number of Residents": {"ignore_malformed": true, "type": "float"}, "Exterior Wall Type": {"type": "string"}, "Guiding Principle 1.2 Integrated - Goals": {"type": "string"}, "Water/Wastewater Biomass GHG Emissions Intensity (kgCO2e/gpd)": {"ignore_malformed": true, "type": "float"}, "Premises Notes": {"type": "string"}, "Drinking Water Treatment & Distribution - Average Flow (MGD)": {"ignore_malformed": true, "type": "float"}, "Prison/Incarceration - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Other - Recreation - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "SHW Year installed": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Measure Notes": {"type": "string"}, "SHW is FEMP Designated Product": {"type": "string"}, "Data Center - UPS System Redundancy": {"type": "string"}, "Lamp Subtype": {"type": "string"}, "Owner State": {"type": "string"}, "Number of Lamps per Ballast": {"ignore_malformed": true, "type": "float"}, "Portfolio Manager Property ID": {"type": "string"}, "Makeup Air Source": {"type": "string"}, "PVc System Racking System Tilt Angle Max": {"ignore_malformed": true, "type": "float"}, "Zoo - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Other - Services - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Vertical Fin Depth": {"ignore_malformed": true, "type": "float"}, "Transformer Nameplate Efficiency": {"ignore_malformed": true, "type": "float"}, "US Federal Real Property Unique Identifier": {"type": "string"}, "Guiding Principle 4.4 Daylighting and Occupant Controls - Option 2": {"type": "string"}, "Guiding Principle 4.4 Daylighting and Occupant Controls - Option 1": {"type": "string"}, "Scenario Name": {"type": "string"}, "Measure Start Date": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Indoor Arena - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Lighting Control Type Daylighting": {"type": "string"}, "Electricity Use - Grid Purchase (kBtu)": {"ignore_malformed": true, "type": "float"}, "Library - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "County": {"type": "string"}, "Process Load Heat Gain Fraction": {"ignore_malformed": true, "type": "float"}, "Design Electricity Use - Generated from Onsite Renewable Systems and Used Onsite (kBtu)": {"ignore_malformed": true, "type": "float"}, "Weather Normalized Site Energy Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Motor Efficiency": {"ignore_malformed": true, "type": "float"}, "Multifamily Housing - Number of Laundry Hookups in Common Area(s)": {"ignore_malformed": true, "type": "float"}, "Hotel - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Residence Hall/Dormitory - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Site Energy Use": {"ignore_malformed": true, "type": "float"}, "Stadium (Open) - Number of Sporting Events per Year": {"ignore_malformed": true, "type": "float"}, "Repair Services (Vehicle, Shoe, Locksmith, etc.) - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "NYC Building Identification Number (BIN)": {"type": "string"}, "Installation Type": {"type": "string"}, "Courthouse - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Design Target % Better Than Median Source EUI": {"ignore_malformed": true, "type": "float"}, "Library - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Site Energy Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Cell Count": {"ignore_malformed": true, "type": "float"}, "Aquarium - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Other - Mall - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Heating Equipment Maintenance Frequency": {"type": "string"}, "Condenser Water Temperature": {"ignore_malformed": true, "type": "float"}, "Refrigerated Warehouse - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Refrigeration Unit is Third Party Certified": {"type": "string"}, "Heat Pump Backup system fuel": {"type": "string"}, "Motor Drive Efficiency": {"ignore_malformed": true, "type": "float"}, "Cooling Efficiency Value": {"ignore_malformed": true, "type": "float"}, "Electricity Use - Grid Purchase (kWh)": {"ignore_malformed": true, "type": "float"}, "Auditor Qualification Number": {"type": "string"}, "Coal (anthracite) Cost ($)": {"ignore_malformed": true, "type": "float"}, "Roller Rink - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Recover Efficiency": {"ignore_malformed": true, "type": "float"}, "Outdoor Water Use (All Water Sources) (kgal)": {"ignore_malformed": true, "type": "float"}, "Terrace R-Value": {"ignore_malformed": true, "type": "float"}, "Typical Skylight Frames R-Value": {"ignore_malformed": true, "type": "float"}, "Off-Peak Occupancy Percentage": {"ignore_malformed": true, "type": "float"}, "Operable Windows": {"type": "string"}, "Site Energy Use - Adjusted to Current Year (kBtu)": {"ignore_malformed": true, "type": "float"}, "Motor Brake HP": {"ignore_malformed": true, "type": "float"}, "Motor Location Relative to Air Stream": {"type": "string"}, "Hospital (General Medical & Surgical) - Staffed Bed Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Design Enclosed Mall - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Software program version": {"type": "string"}, "Economizer Dry Bulb Control Point": {"ignore_malformed": true, "type": "float"}, "Design Non-Refrigerated Warehouse - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Parking - Supplemental Heating": {"type": "string"}, "Skylight Type": {"type": "string"}, "Rated Heat Pump Sensible Heat Ratio": {"ignore_malformed": true, "type": "float"}, "Daily Water Use": {"ignore_malformed": true, "type": "float"}, "Financial Office - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Premises State": {"type": "string"}, "Alternative Water Generated On-Site: Combined Indoor/Outdoor or Other Use (kgal)": {"ignore_malformed": true, "type": "float"}, "Social/Meeting Hall - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Draft Type": {"type": "string"}, "Minimum Dimming Light Fraction": {"ignore_malformed": true, "type": "float"}, "Cooled Floor Area": {"ignore_malformed": true, "type": "float"}, "Stadium (Open) - Number of Concert/Show Events per Year": {"ignore_malformed": true, "type": "float"}, "Ventilation Rate": {"ignore_malformed": true, "type": "float"}, "Refrigerated Case Doors": {"type": "string"}, "Guiding Principles - % Not Applicable": {"type": "string"}, "Name of Retro-commissioning Certification Holder": {"type": "string"}, "Metal Halide Start Type": {"type": "string"}, "Measure First Cost": {"ignore_malformed": true, "type": "float"}, "Library - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Perimeter": {"ignore_malformed": true, "type": "float"}, "Condenser Type": {"type": "string"}, "Adult Education - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Luminaire Height": {"ignore_malformed": true, "type": "float"}, "Supermarket/Grocery - Cash Register Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Design K-12 School - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Percent Better than National Median Site EUI": {"ignore_malformed": true, "type": "float"}, "Financial Office - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Zoo - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Direct GHG Emissions Intensity (kgCO2e/ft2)": {"ignore_malformed": true, "type": "float"}, "Water Use": {"ignore_malformed": true, "type": "float"}, "Dehumidification Type": {"type": "string"}, "Prison/Incarceration - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 2.2 Energy - Efficient Products": {"type": "string"}, "Output Capacity": {"ignore_malformed": true, "type": "float"}, "Cooking Equipment is Third Party Certified": {"type": "string"}, "Guiding Principles - % Not Assessed": {"type": "string"}, "Urgent Care/Clinic/Other Outpatient - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Fitness Center/Health Club/Gym - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 2.1 Energy - Energy Efficiency Any Option (Any Option)": {"type": "string"}, "Alternative Water Generated On-Site - Indoor Use (kgal)": {"ignore_malformed": true, "type": "float"}, "Utility Account Number": {"type": "string"}, "Skylight to Roof Ratio": {"ignore_malformed": true, "type": "float"}, "Weather Normalized Water/Wastewater Site Electricity Intensity (kWh/gpd)": {"ignore_malformed": true, "type": "float"}, "Weather Year": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Convention Center - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Winter Peak Electricity Reduction": {"ignore_malformed": true, "type": "float"}, "Target Source EUI (kBtu/ft2)": {"ignore_malformed": true, "type": "float"}, "Number of Meals": {"ignore_malformed": true, "type": "float"}, "Indirect GHG Emissions Intensity (kgCO2e/ft2)": {"ignore_malformed": true, "type": "float"}, "Design Ambulatory Surgical Center - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Non-Refrigerated Warehouse - Number of Worker on Main Shift": {"ignore_malformed": true, "type": "float"}, "Humidification Type": {"type": "string"}, "Casino - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Weather Normalized Site Electricity (kWh)": {"ignore_malformed": true, "type": "float"}, "Design Natural Gas Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Design Restaurant - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Water/Wastewater Source EUI - Adjusted to Current Year (kBtu/gpd)": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 4.2 Indoor Environment - Moisture Control": {"type": "string"}, "Design Energy/Power Station - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Design Indirect GHG Emissions (MtCO2e)": {"ignore_malformed": true, "type": "float"}, "Stadium (Closed) - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Other - Stadium - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Dishwasher Energy Factor": {"ignore_malformed": true, "type": "float"}, "Coal - Anthracite Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Other - Education - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Supply Fraction of Duct Leakage": {"ignore_malformed": true, "type": "float"}, "Worship Facility - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Weather Station Category": {"type": "string"}, "Foundation Wall Insulation Thickness": {"ignore_malformed": true, "type": "float"}, "Space Number Main Shift Workers": {"ignore_malformed": true, "type": "float"}, "Data Center - IT Equipment Input Site Energy (kWh)": {"ignore_malformed": true, "type": "float"}, "On-site Renewable Electricity": {"ignore_malformed": true, "type": "float"}, "Date of Last PM Modification": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Municipally Supplied Potable Water: Combined Indoor/Outdoor or Other Cost ($)": {"ignore_malformed": true, "type": "float"}, "Slab Insulation Condition": {"type": "string"}, "Police Station - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Number of Discrete Fan Speeds - Heating": {"ignore_malformed": true, "type": "float"}, "Number of Ballasts per Luminaire": {"ignore_malformed": true, "type": "float"}, "Outside Air Temperature Upper Limit Cooling Reset Control": {"ignore_malformed": true, "type": "float"}, "Installed Fan Flow Rate": {"ignore_malformed": true, "type": "float"}, "Fluorescent Start Type": {"type": "string"}, "Chilled Water Reset Control": {"type": "string"}, "Anti-Sweat Heater Power": {"ignore_malformed": true, "type": "float"}, "Federal Region/Sub-Department": {"type": "string"}, "Outpatient Rehabilitation/Physical Therapy - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Other - Lodging/Residential - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Design District Hot Water Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Boiler Type": {"type": "string"}, "Bar/Nightclub - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Distribution Center - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Point Of Use": {"type": "string"}, "Summer Peak Electricity Reduction": {"ignore_malformed": true, "type": "float"}, "Slab Perimeter": {"ignore_malformed": true, "type": "float"}, "Pre-school/Daycare - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Lighting Control Type Timer": {"type": "string"}, "Other HVAC Type": {"type": "string"}, "Guiding Principle 4.1 Indoor Environment - Ventilation and Thermal Comfort": {"type": "string"}, "Demand Reduction": {"ignore_malformed": true, "type": "float"}, "Green Power - Offsite (kWh)": {"ignore_malformed": true, "type": "float"}, "Other - Recreation - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Cooling Type": {"type": "string"}, "Food Service - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Mailing Center/Post Office - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Automobile Dealership - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Water/Wastewater Site EUI (kBtu/gpd)": {"ignore_malformed": true, "type": "float"}, "Design Drinking Water Treatment & Distribution - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Steam Boiler Maximum Operating Pressure": {"ignore_malformed": true, "type": "float"}, "Investment in Energy Projects, Cumulative ($/ft2)": {"ignore_malformed": true, "type": "float"}, "Other - Stadium - Number of Special/Other Events per Year": {"ignore_malformed": true, "type": "float"}, "Municipally Supplied Potable Water - Indoor Use (kgal)": {"ignore_malformed": true, "type": "float"}, "Occupant Activity Level": {"type": "string"}, "Worship Facility - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Design Other - Education - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Municipally Supplied Reclaimed Water - Indoor Cost Intensity ($/ft2)": {"ignore_malformed": true, "type": "float"}, "Manufacturing/Industrial Plant - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Target Total GHG Emissions Intensity (kgCO2e/ft2)": {"ignore_malformed": true, "type": "float"}, "Setpoint temperature cooling": {"ignore_malformed": true, "type": "float"}, "Ice/Curling Rink - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Fan Power Minimum Ratio": {"ignore_malformed": true, "type": "float"}, "Other - Stadium - Ice Events": {"ignore_malformed": true, "type": "float"}, "Weather Type": {"type": "string"}, "PM Profile Status": {"type": "string"}, "Other - Lodging/Residential - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Annual Combined Whole Building Annual Weather Normalized Site Resource Use": {"ignore_malformed": true, "type": "float"}, "Design Diesel #2 Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Target Water/Wastewater Site EUI (kBtu/gpd)": {"ignore_malformed": true, "type": "float"}, "Stadium (Closed) - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Motor HP": {"ignore_malformed": true, "type": "float"}, "Convenience Store without Gas Station - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Police Station - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Chiller Compressor Driver": {"type": "string"}, "Multifamily Housing - Resident Population Type": {"type": "string"}, "Strip Mall - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Ventilation Type": {"type": "string"}, "Courthouse - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Refrigerated Warehouse - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Supply Air Control Strategy": {"type": "string"}, "Software program used": {"type": "string"}, "Duct Type": {"type": "string"}, "Cooling Supply Air Temperature": {"ignore_malformed": true, "type": "float"}, "Personal Services (Health/Beauty, Dry Cleaning, etc.) - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Duct Leakage Test Method": {"type": "string"}, "Ventilation Zone Control": {"type": "string"}, "Funding from Tax Credits": {"type": "string"}, "Vocational School - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Absorption Heat Source": {"type": "string"}, "Transportation Terminal/Station - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Repair Services (Vehicle, Shoe, Locksmith, etc.) - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Slab Insulation Orientation": {"ignore_malformed": true, "type": "float"}, "Alternative Water Generated On-Site - Outdoor Use (kgal)": {"ignore_malformed": true, "type": "float"}, "Adult Education - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Target ENERGY STAR Score": {"ignore_malformed": true, "type": "float"}, "Design Vocational School - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Municipally Supplied Potable Water: Combined Indoor/Outdoor or Other Use (kgal)": {"ignore_malformed": true, "type": "float"}, "Outside Air Reset Minimum Cooling Supply Temperature": {"ignore_malformed": true, "type": "float"}, "Normalization Years": {"type": "string"}, "Tank Heating Type": {"type": "string"}, "Electricity Use - Generated from Onsite Renewable Systems and Exported (kWh)": {"ignore_malformed": true, "type": "float"}, "Primary Contact": {"type": "string"}, "Average Daily Hours": {"ignore_malformed": true, "type": "float"}, "Courthouse - Number of Computers": {"ignore_malformed": true, "type": "float"}, "eGRID Output Emissions Rate (kgCO2e/MBtu)": {"ignore_malformed": true, "type": "float"}, "Other - Stadium - Enclosed Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Stadium (Closed) - Number of Concert/Show Events per Year": {"ignore_malformed": true, "type": "float"}, "Design Financial Office - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Heat Pump Backup AFUE": {"ignore_malformed": true, "type": "float"}, "Target Finder EUI": {"ignore_malformed": true, "type": "float"}, "ENERGY STAR Certification - Year(s) Certified": {"type": "string"}, "Coke Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Adult Education - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "NAICS Code": {"type": "string"}, "Self-Storage Facility - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "ENERGY Star Score": {"ignore_malformed": true, "type": "float"}, "Process Load Duty Cycle": {"type": "string"}, "Alternative Water Generated On-Site: Combined Indoor/Outdoor or Other Cost ($)": {"ignore_malformed": true, "type": "float"}, "Other - Mall - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Number of Discrete Fan Speeds - Cooling": {"ignore_malformed": true, "type": "float"}, "Vocational School - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Other - Recreation - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Museum - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Convenience Store without Gas Station - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Fuel Oil #5 & 6 Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Receive Date": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Design Automobile Dealership - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Fenestration Area": {"ignore_malformed": true, "type": "float"}, "Aquarium - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "NPV of Tax Implications": {"ignore_malformed": true, "type": "float"}, "Casino - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Window to Wall Ratio": {"ignore_malformed": true, "type": "float"}, "Internal Rate of Return": {"ignore_malformed": true, "type": "float"}, "Residence Hall/ Dormitory - Computer Lab": {"type": "string"}, "Defrost Type": {"type": "string"}, "Supermarket/Grocery - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Design Greenhouse Gas Emissions": {"ignore_malformed": true, "type": "float"}, "Energy Cost Intensity ($)": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 2.4 Energy - Measurement and Verification": {"type": "string"}, "Ambulatory Surgical Center - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Building Certification": {"type": "string"}, "Door Visible Transmittance": {"ignore_malformed": true, "type": "float"}, "Convenience Store without Gas Station - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Weather Data Station ID": {"type": "string"}, "Plug Load Peak Power": {"ignore_malformed": true, "type": "float"}, "Type of Measure": {"type": "string"}, "Active Dehumidification": {"type": "string"}, "Design ENERGY STAR Score": {"ignore_malformed": true, "type": "float"}, "Wholesale Club/Supercenter- Exterior Entrance to the Public": {"ignore_malformed": true, "type": "float"}, "College/University - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Kerosene Cost ($)": {"ignore_malformed": true, "type": "float"}, "Design Zoo - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Design Liquid Propane Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Window Orientation": {"ignore_malformed": true, "type": "float"}, "Fitness Center/Health Club/Gym - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "National Median Energy Cost ($)": {"ignore_malformed": true, "type": "float"}, "Dryer Primary Energy Use Per Load": {"ignore_malformed": true, "type": "float"}, "Library - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Alternative Water Generated On-Site - Indoor Intensity (gal/ft2)": {"ignore_malformed": true, "type": "float"}, "Fan Design Static Pressure": {"ignore_malformed": true, "type": "float"}, "Solar Thermal System Collector Type": {"type": "string"}, "Office - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Net Metering": {"type": "string"}, "Demand Window": {"type": "string"}, "Recirculation Loop Count": {"ignore_malformed": true, "type": "float"}, "Lot Size": {"ignore_malformed": true, "type": "float"}, "K-12 School - Refrigeration Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Compressor Unloader": {"type": "string"}, "Design Multifamily Housing - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Annual Fuel Use Native Units (Native Units)": {"type": "string"}, "Municipally Supplied Potable Water - Indoor Cost Intensity ($/ft2)": {"ignore_malformed": true, "type": "float"}, "Convenience Store with Gas Station - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Clothes Washer Modified Energy Factor": {"ignore_malformed": true, "type": "float"}, "Multifamily Housing - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Worship Facility - Number of Commercial Refrigeration/Freezer Units": {"ignore_malformed": true, "type": "float"}, "Number of Refrigerant Return Lines": {"ignore_malformed": true, "type": "float"}, "National Median Source EUI (kBtu/ft2)": {"ignore_malformed": true, "type": "float"}, "Property Data Administrator": {"type": "string"}, "Natural Ventilation Method": {"type": "string"}, "Outpatient Rehabilitation/Physical Therapy - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "K-12 School - Student Seating Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Performing Arts - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Percent of Roof Terraces": {"ignore_malformed": true, "type": "float"}, "Cooling Control Strategy": {"type": "string"}, "Rate Structure Effective Date": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Overhang Height above Window": {"ignore_malformed": true, "type": "float"}, "Typical Skylights SHGC": {"ignore_malformed": true, "type": "float"}, "MV Cost": {"ignore_malformed": true, "type": "float"}, "Transportation Terminal/Station - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Race Track - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Hotel - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Target % Better Than Median Source EUI": {"ignore_malformed": true, "type": "float"}, "Bowling Alley - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 3.2 Water - Outdoor Water Any Option (Any Option)": {"type": "string"}, "Other - Utility - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Alternative Water Generated On-Site - Indoor Cost ($)": {"ignore_malformed": true, "type": "float"}, "PV Module Width": {"ignore_malformed": true, "type": "float"}, "District Hot Water Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "PM Sharing Account": {"type": "string"}, "Hospital (General Medical & Surgical) - Owned By": {"type": "string"}, "Evaporative Cooling Entering Supply Air WB Temperature": {"ignore_malformed": true, "type": "float"}, "Roof Insulation Thickness": {"ignore_malformed": true, "type": "float"}, "National Median Water/Wastewater Source EUI (kBtu/gpd)": {"ignore_malformed": true, "type": "float"}, "Fitness Center/Health Club/Gym - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Percent Savings in Lighting Power Density": {"ignore_malformed": true, "type": "float"}, "Performing Arts - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Ambulatory Surgical Center - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Type of Rate Structure": {"type": "string"}, "Typical Window Frame R-Value": {"ignore_malformed": true, "type": "float"}, "Evaporative Cooling Operation": {"type": "string"}, "Liquid Propane Cost ($)": {"ignore_malformed": true, "type": "float"}, "Other - Specialty Hospital - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Design Self-Storage Facility - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Water/Wastewater Source EUI (kBtu/gpd)": {"ignore_malformed": true, "type": "float"}, "Senior Care Community - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Design Outpatient Rehabilitation/Physical Therapy - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Wholesale Club/Supercenter- Number of Cash Registers": {"ignore_malformed": true, "type": "float"}, "Heating Type": {"type": "string"}, "Annual Heating Efficiency Value": {"ignore_malformed": true, "type": "float"}, "Percentage of Common Space": {"ignore_malformed": true, "type": "float"}, "Multifamily Housing - Primary Hot Water Fuel Type for units (for units)": {"type": "string"}, "Duct Pressure Test Leakage Percentage (Percentage)": {"ignore_malformed": true, "type": "float"}, "Retail Store - Number of Walk-in Refrigeration/Freezer Units": {"ignore_malformed": true, "type": "float"}, "Financial Office - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Contact Address 1": {"type": "string"}, "Contact Address 2": {"type": "string"}, "Senior Care Community - Number of Commercial Refrigeration/ Freezer Units": {"ignore_malformed": true, "type": "float"}, "Design Swimming Pool - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Water Alerts": {"type": "string"}, "Annual Efficiency Unit": {"type": "string"}, "Barracks - Dining Hall": {"type": "string"}, "Zoo - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Hotel - Full Service Spa Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Electric Distribution Utility": {"type": "string"}, "Design Total GHG Emissions Intensity (kgCO2e/ft2)": {"ignore_malformed": true, "type": "float"}, "Prison/Incarceration - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Window Height": {"ignore_malformed": true, "type": "float"}, "Guiding Principles - Checklist Manager": {"type": "string"}, "Measure Capital Replacement Costs": {"ignore_malformed": true, "type": "float"}, "Rate Structure End Date": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Thermal Efficiency": {"ignore_malformed": true, "type": "float"}, "Replaced/modified/removed system identifier": {"type": "string"}, "Schedule Type": {"ignore_malformed": true, "type": "float"}, "District Chilled Water": {"type": "string"}, "Minimum Outside Air Percentage": {"ignore_malformed": true, "type": "float"}, "Lifestyle Center - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Typical Exterior Wall Type": {"type": "string"}, "Design Other - Lodging/Residential - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Laundry Type": {"type": "string"}, "Design Refrigerated Warehouse - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Compressor Unloader Stages": {"type": "string"}, "Design Source Energy Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Wall Insulation Continuity": {"type": "string"}, "Financial Office - Number of Computers": {"ignore_malformed": true, "type": "float"}, "GHG Emissions": {"ignore_malformed": true, "type": "float"}, "Wholesale Club/Supercenter- Open or Closed Refrigeration Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Source EUI (kBtu/ft2)": {"ignore_malformed": true, "type": "float"}, "Property Management Company": {"type": "string"}, "Municipally Supplied Reclaimed Water: Combined Indoor/Outdoor or Other Use (kgal)": {"ignore_malformed": true, "type": "float"}, "Design Prison/Incarceration - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Bowling Alley - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Wholesale Club/Supercenter- Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Fan Flow Control Type": {"type": "string"}, "K-12 School - Gymnasium Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Heat Pump Backup Heating Switchover Temperature": {"ignore_malformed": true, "type": "float"}, "Stadium (Open) - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Year Of Latest Retrofit": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Fenestration R-value": {"ignore_malformed": true, "type": "float"}, "Return Duct Percent Conditioned Space": {"ignore_malformed": true, "type": "float"}, "Minimum Fan Speed as a Fraction of Maximum - Cooling": {"ignore_malformed": true, "type": "float"}, "Barracks - Computer Lab": {"type": "string"}, "Fuel Oil (No. 2) Cost ($)": {"ignore_malformed": true, "type": "float"}, "Wastewater Treatment Plant - Average Effluent Biological Oxygen Demand (BOD5) (mg/l)": {"ignore_malformed": true, "type": "float"}, "Ground Coupling": {"type": "string"}, "Diesel": {"type": "string"}, "Other - Education - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Design Other - Mall - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Other - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Demand Ratchet Percentage": {"ignore_malformed": true, "type": "float"}, "Premises Gross Floor Area": {"ignore_malformed": true, "type": "float"}, "Scope": {"type": "string"}, "Design District Steam Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Retail Store - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Other - Education - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Automobile Dealership - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Water Current Date": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "normalized_address": {"index": "not_analyzed", "type": "string", "store": true}, "Design Temperature Difference": {"ignore_malformed": true, "type": "float"}, "Number of Months in Operation": {"ignore_malformed": true, "type": "float"}, "Barracks- Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Fast Food Restaurant - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Design Adult Education - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Weather Station ID": {"type": "string"}, "Hospital (General Medical & Surgical) - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Pump Application": {"type": "string"}, "Design Bank Branch - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Enclosed Mall - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Hotel - Room Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "IT System Type": {"type": "string"}, "Desuperheat Valve": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 1.1 Integrated - Team": {"type": "string"}, "Wall Area": {"ignore_malformed": true, "type": "float"}, "Certification Year": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Roller Rink - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Non-Refrigerated Warehouse - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Third Party Certification Date Anticipated": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Target Finder Baseline": {"ignore_malformed": true, "type": "float"}, "Total Water Cost (All Water Sources) ($)": {"ignore_malformed": true, "type": "float"}, "Other - Entertainment/Public Assembly - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Water-Side Economizer Temperature Maximum": {"ignore_malformed": true, "type": "float"}, "Home Energy Score": {"ignore_malformed": true, "type": "float"}, "ENERGY STAR Application Status": {"type": "string"}, "Estimated Savings from Energy Projects, Cumulative ($/ft2)": {"ignore_malformed": true, "type": "float"}, "Other - Specialty Hospital - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Non-Refrigerated Warehouse - Walk-in Refrigeration Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Swimming Pool - Months in Use": {"ignore_malformed": true, "type": "float"}, "Skylight Solar tube": {"type": "string"}, "Avoided Emissions - Offsite Green Power (MtCO2e)": {"ignore_malformed": true, "type": "float"}, "Police Station - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Space Peak Number of Occupants": {"ignore_malformed": true, "type": "float"}, "Outpatient Rehabilitation/Physical Therapy - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Heating Setback Temperature": {"ignore_malformed": true, "type": "float"}, "Design Repair Services (Vehicle, Shoe, Locksmith, etc) - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Courthouse - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Capacity": {"ignore_malformed": true, "type": "float"}, "Pump Maximum Flow Rate": {"ignore_malformed": true, "type": "float"}, "Design Museum - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Other - Stadium - Number of Sporting Events per Year": {"ignore_malformed": true, "type": "float"}, "Economizer Control": {"ignore_malformed": true, "type": "float"}, "Water/Wastewater Investment in Energy Projects, Cumulative ($/GPD)": {"ignore_malformed": true, "type": "float"}, "Design Other - Recreation - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Anti-Sweat Heaters": {"type": "string"}, "Coal (bituminous) Cost ($)": {"ignore_malformed": true, "type": "float"}, "Window Frame Type": {"type": "string"}, "Other - Education - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Measure Implementation Status": {"type": "string"}, "Single Family Home - Bedroom Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Certification Expiration Date": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Design Mailing Center/Post Office - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Roof Color": {"type": "string"}, "Windows Gas Filled": {"type": "string"}, "Design Kerosene Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "SHW Control Type": {"type": "string"}, "Other Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Distribution Center - Walk-in Refrigeration Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Annual Savings Cost (Cost)": {"ignore_malformed": true, "type": "float"}, "PV System Location": {"type": "string"}, "Municipally Supplied Potable Water - Indoor Cost ($)": {"ignore_malformed": true, "type": "float"}, "Municipally Supplied Reclaimed Water - Indoor Use (kgal)": {"ignore_malformed": true, "type": "float"}, "Latitude": {"type": "string"}, "Design College/University - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Indoor Arena - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Vocational School - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Average Weekly Business Hours": {"ignore_malformed": true, "type": "float"}, "Supermarket/Grocery - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Weather Normalized Water/Wastewater Source EUI (kBtu/gpd)": {"ignore_malformed": true, "type": "float"}, "Lifestyle Center - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Reheat Control Strategy": {"type": "string"}, "Urgent Care/Clinic/Other Outpatient - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Schedule Begin Month": {"ignore_malformed": true, "type": "float"}, "Other - Services - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Country": {"type": "string"}, "Primary Service Hot Water Fuel": {"type": "string"}, "Plug Load Type": {"type": "string"}, "Number of Occupants": {"ignore_malformed": true, "type": "float"}, "Vocational School - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Data Center - UPS Output Site Energy (kWh)": {"ignore_malformed": true, "type": "float"}, "Green Power - Onsite and Offsite (kWh)": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 5.3 Materials - Environmentally Preferred Products": {"type": "string"}, "Clothes Washer Capacity": {"ignore_malformed": true, "type": "float"}, "Motor Enclosure Type": {"type": "string"}, "PM Administrator": {"type": "string"}, "Data Center - Cooling Equipment Redundancy": {"type": "string"}, "Annual Combined Whole Builidng Annual Source Energy Use Intensity (EUI)": {"ignore_malformed": true, "type": "float"}, "Auditor Company": {"type": "string"}, "Restaurant - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Guiding Principles - Principles Date Anticipated": {"type": "string"}, "Urgent Care/Clinic/Other Outpatient - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Typical Window Frame": {"type": "string"}, "Roller Rink - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Percent Better than National Median Water/Wastewater Source EUI": {"ignore_malformed": true, "type": "float"}, "Fast Food Restaurant - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "ASHRAE Baseline Lighting Power Density": {"ignore_malformed": true, "type": "float"}, "First Cost": {"ignore_malformed": true, "type": "float"}, "Casino - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Other - Stadium - Number of Walk-in Refrigeration/Freezer Units": {"ignore_malformed": true, "type": "float"}, "Laundry Equipment Usage": {"type": "string"}, "Retail Store - Cash Register Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 3.4 Water - Efficient Products": {"type": "string"}, "Source EUI - Adjusted to Current Year (kBtu/ft2)": {"ignore_malformed": true, "type": "float"}, "Barracks- Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Source Site Ratio": {"ignore_malformed": true, "type": "float"}, "ENERGY STAR Certification - Next Eligible Date": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Coal - Bituminous Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Water Cooled Condenser Flow Control": {"type": "string"}, "Design Pre-school/Daycare - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Repair Services (Vehicle, Shoe, Locksmith, etc.) - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 4.4 Indoor Environment - Daylighting and Occupant Controls Any Option (Any Option)": {"type": "string"}, "Property Floor Area (Buildings and Parking) (ft2)": {"ignore_malformed": true, "type": "float"}, "Control Technology": {"type": "string"}, "Marginal Cost Rate": {"ignore_malformed": true, "type": "float"}, "Contact Postal Code": {"type": "string"}, "Fuel Oil #2 Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Percent Better Than Baseline Design Site Energy Use Intensity": {"ignore_malformed": true, "type": "float"}, "Typical Floor R-Value": {"ignore_malformed": true, "type": "float"}, "Bowling Alley - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Wall Framing Factor": {"ignore_malformed": true, "type": "float"}, "Outpatient Rehabilitation/Physical Therapy - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "District Chilled Water Cost ($)": {"ignore_malformed": true, "type": "float"}, "Veterinary Office - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Solar Thermal System Type": {"type": "string"}, "M&V Option": {"type": "string"}, "Primary Heating Fuel Type": {"type": "string"}, "Refrigerant Subcooler": {"type": "string"}, "District Hot Water": {"type": "string"}, "Pre-school/Daycare - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Fire Station - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Wall Framing Material": {"type": "string"}, "Race Track - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Boiler Entering Water Temperature": {"ignore_malformed": true, "type": "float"}, "Refrigeration Unit is ENERGY STAR Rated": {"type": "string"}, "Pool Surface Area": {"ignore_malformed": true, "type": "float"}, "Automobile Dealership - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Utility Billpayer": {"type": "string"}, "Guiding Principles - % Complete (Yes or Not Applicable)": {"type": "string"}, "District Steam Cost ($)": {"ignore_malformed": true, "type": "float"}, "Percent of Electricity that is Green Power": {"ignore_malformed": true, "type": "float"}, "US Agency Designated Covered Facility ID": {"type": "string"}, "Library - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Fuel Generated": {"type": "string"}, "Supermarket/Grocery - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Design Hospital (General Medical & Surgical) - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Energy/Power Station - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Outside Air Reset Maximum Heating Supply Temperature": {"ignore_malformed": true, "type": "float"}, "Floor Insulation Thickness": {"ignore_malformed": true, "type": "float"}, "Avoided Emissions - Onsite and Offsite Green Power (MtCO2e)": {"ignore_malformed": true, "type": "float"}, "Hospital (General Medical & Surgical) - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Federal Agency": {"type": "string"}, "Tank Height": {"ignore_malformed": true, "type": "float"}, "Heated Floor Area": {"ignore_malformed": true, "type": "float"}, "Floor Area Source": {"type": "string"}, "Stadium (Open) - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Social/Meeting Hall - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Performing Arts - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Stadium (Closed) - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Floor Construction Type": {"type": "string"}, "Energy Baseline Date": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Primary Property Type - EPA Calculated": {"type": "string"}, "Weather Normalized Source Energy Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Personal Services (Health/Beauty, Dry Cleaning, etc.) - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Self-Storage Facility - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Hospital (General Medical & Surgical) - Maximum Number of Floors": {"ignore_malformed": true, "type": "float"}, "Museum - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Stadium (Open) - Size of Electronic Scoreboards (ft2)": {"ignore_malformed": true, "type": "float"}, "Target Site EUI (kBtu/ft2)": {"ignore_malformed": true, "type": "float"}, "Annual Savings Source Energy (Source Energy)": {"ignore_malformed": true, "type": "float"}, "Design Target Total GHG Emissions (MtCO2e)": {"ignore_malformed": true, "type": "float"}, "Recirculation Control Type": {"type": "string"}, "Design Other - Restaurant/Bar - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Quantity": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 4.6 Indoor Environment - Integrated Pest Management": {"type": "string"}, "Hospital (General Medical & Surgical) - Laboratory": {"type": "string"}, "Resource Generated On Site": {"ignore_malformed": true, "type": "float"}, "Other - Utility - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Biomass GHG Emissions Intensity (kgCO2e/ft2)": {"ignore_malformed": true, "type": "float"}, "Weather Station Name": {"type": "string"}, "Guiding Principles - % In Process": {"type": "string"}, "Retail Store - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Worship Facility - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Refrigerant Charge Factor": {"ignore_malformed": true, "type": "float"}, "Solar Thermal System Collector Area": {"ignore_malformed": true, "type": "float"}, "Aspect Ratio": {"ignore_malformed": true, "type": "float"}, "Other - Services - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Year of Last Energy Audit": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Indoor Arena - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Parking - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Percent of Window Area Shaded": {"ignore_malformed": true, "type": "float"}, "Daylight Sensors": {"type": "string"}, "Interior Visible Absorptance": {"ignore_malformed": true, "type": "float"}, "Crankcase Heater": {"type": "string"}, "Floor Covering": {"type": "string"}, "Simple Payback": {"ignore_malformed": true, "type": "float"}, "Metering Configuration": {"type": "string"}, "Refrigerated Warehouse - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Refrigeration Unit Size": {"ignore_malformed": true, "type": "float"}, "IT Energy Intensity": {"ignore_malformed": true, "type": "float"}, "Economizer": {"type": "string"}, "Wholesale Club/Supercenter- Number of Walk-in Refrigeration/Freezer Units": {"ignore_malformed": true, "type": "float"}, "Auditor Team Member with Certification": {"type": "string"}, "K-12 School - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Site Address Line 2": {"type": "string"}, "Backup Generator": {"type": "string"}, "Roller Rink - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Site Address Line 1": {"type": "string"}, "Design Library - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "IT Standby Power": {"ignore_malformed": true, "type": "float"}, "Fire Station - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Premises Postal Code": {"type": "string"}, "Conveyance System Type": {"type": "string"}, "Race Track - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Design Site EUI (kBtu/ft2)": {"ignore_malformed": true, "type": "float"}, "Roof Type": {"type": "string"}, "Convenience Store with Gas Station - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Design Target Total GHG Emissions Intensity (kgCO2e/ft2)": {"ignore_malformed": true, "type": "float"}, "K-12 School - Cooking Facilities": {"type": "string"}, "K-12 School - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Retail Store - Single Store": {"type": "string"}, "Design Site EUI": {"ignore_malformed": true, "type": "float"}, "IT Peak Power": {"ignore_malformed": true, "type": "float"}, "Energy Cost ($)": {"ignore_malformed": true, "type": "float"}, "Recirculation Energy Loss Rate": {"ignore_malformed": true, "type": "float"}, "Lighting is FEMP Designated Product": {"type": "string"}, "Design Fire Station - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Distribution Type": {"type": "string"}, "Design Roller Rink - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Solar Heat Gain Coefficient SHGC (SHGC)": {"ignore_malformed": true, "type": "float"}, "Multifamily Housing - Number of Residential Living Units": {"ignore_malformed": true, "type": "float"}, "Hotel - Amount of Laundry Processed On-site Annually (short tons/year)": {"ignore_malformed": true, "type": "float"}, "Doors Weather-Stripped": {"type": "string"}, "Restaurant - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Electricity Use - Generated from Onsite Renewable Systems and Used Onsite (kBtu)": {"ignore_malformed": true, "type": "float"}, "Electric Demand Rate": {"type": "string"}, "Food Service - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Other - Specialty Hospital - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Heat Recovery Efficiency": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 2.1 Energy Efficiency - Option 3": {"type": "string"}, "Guiding Principle 2.1 Energy Efficiency - Option 2": {"type": "string"}, "Guiding Principle 2.1 Energy Efficiency - Option 1": {"type": "string"}, "Cooling Equipment Redundancy": {"type": "string"}, "Space Floors Below Grade": {"ignore_malformed": true, "type": "float"}, "Design Coal - Bituminous Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Split Condenser": {"type": "string"}, "Other Water Sources - Indoor Intensity (gal/ft2)": {"ignore_malformed": true, "type": "float"}, "Dishwasher Type": {"type": "string"}, "Movie Theater - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Light Shelf Exterior Protrusion": {"ignore_malformed": true, "type": "float"}, "Primary Air Distribution Type": {"type": "string"}, "Design Bowling Alley - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Day End Hour": {"ignore_malformed": true, "type": "float"}, "Boiler percent condensate return": {"ignore_malformed": true, "type": "float"}, "Weather Normalized Site EUI (kBtu/ft2)": {"ignore_malformed": true, "type": "float"}, "Hot Water Boiler Maximum Flow Rate": {"ignore_malformed": true, "type": "float"}, "Mailing Center/Post Office - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Automobile Dealership - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Horizontal Abutments": {"type": "string"}, "Space Use Description": {"type": "string"}, "K-12 School - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Design Indoor Arena - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Retail Store - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "On-Site Generation Type": {"type": "string"}, "Design Single Family Home - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Minimum Dimming Power Fraction": {"ignore_malformed": true, "type": "float"}, "Target Energy Cost ($)": {"ignore_malformed": true, "type": "float"}, "National Average EUI": {"ignore_malformed": true, "type": "float"}, "Owner Street Address": {"type": "string"}, "Other - Mall - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Air Duct Configuration": {"type": "string"}, "Mailing Center/Post Office - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Water/Wastewater Indirect GHG Emissions Intensity (kgCO2e/gpd)": {"ignore_malformed": true, "type": "float"}, "PV System Inverter Efficiency": {"ignore_malformed": true, "type": "float"}, "Hospital (General Medical & Surgical)- Full Time Equivalent (FTE) Workers": {"ignore_malformed": true, "type": "float"}, "Supermarket/Grocery - Walk-in Refrigeration Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Design Food Service - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Year of Last Major Remodel": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Water Fixture Volume per Cycle": {"ignore_malformed": true, "type": "float"}, "Water Fixture Cycles per day": {"ignore_malformed": true, "type": "float"}, "Stadium (Open) - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Senior Care Community - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Social/Meeting Hall - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Office - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Maximum Fan Power": {"ignore_malformed": true, "type": "float"}, "Typical Skylight Area": {"ignore_malformed": true, "type": "float"}, "Visible Transmittance": {"ignore_malformed": true, "type": "float"}, "Number of Cooling Stages": {"ignore_malformed": true, "type": "float"}, "Veterinary Office - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Wastewater Treatment Plant - Plant Design Flow Rate (MGD)": {"ignore_malformed": true, "type": "float"}, "Office - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Residual Value": {"type": "string"}, "Power Plant": {"type": "string"}, "Liquid Propane Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Window Glass Layers": {"ignore_malformed": true, "type": "float"}, "Design Other - Utility - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Minimum Fan Flow Rate": {"ignore_malformed": true, "type": "float"}, "Stadium (Open) - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Stadium (Closed) - Number of Sporting Events per Year": {"ignore_malformed": true, "type": "float"}, "Indoor Arena - Size of Electronic Scoreboards (ft2)": {"ignore_malformed": true, "type": "float"}, "Fan Efficiency": {"ignore_malformed": true, "type": "float"}, "Design Other - Public Services - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Wastewater Treatment Plant - Average Influent Biological Oxygen Demand (BOD5) (mg/l)": {"ignore_malformed": true, "type": "float"}, "Enclosed Mall - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Energy/Power Station - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Stadium (Open) - Walk-in Refrigeration Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "SHW Setpoint Temp": {"ignore_malformed": true, "type": "float"}, "Duty Cycle": {"type": "string"}, "College/University - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Floors Partially Below Grade": {"ignore_malformed": true, "type": "float"}, "Retail Store - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Natural Gas Use (therms)": {"ignore_malformed": true, "type": "float"}, "Energy Storage Type": {"type": "string"}, "Food Sales - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Solar Thermal System Collector Azimuth": {"ignore_malformed": true, "type": "float"}, "Ambulatory Surgical Center - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Manufacturing/Industrial Plant - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Occupancy Sensors": {"type": "string"}, "Case Return Line Diameter": {"ignore_malformed": true, "type": "float"}, "Wholesale Club/Supercenter- Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Design Aquarium - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Social/Meeting Hall - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Wastewater Treatment Plant - Fixed Film Trickle Filtration Process": {"type": "string"}, "Design Courthouse - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Energy/Power Station - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Design Target Water/Wastewater Source EUI (kBtu/gpd)": {"ignore_malformed": true, "type": "float"}, "Overhang Projection": {"type": "string"}, "National Median ENERGY STAR Score": {"ignore_malformed": true, "type": "float"}, "Strip Mall - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Barracks - Room Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Plug Load Equipment is ENERGY STAR Rated": {"type": "string"}, "Occupancy": {"type": "string"}, "Enclosed Mall - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Fitness Center/Health Club/Gym - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Parent Property Name": {"type": "string"}, "Hotel- Number of Commercial Refrigeration/Freezer Units": {"ignore_malformed": true, "type": "float"}, "Required Ventilation Rate": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 5.4 Materials - Waste and Materials Mgmt": {"type": "string"}, "Fast Food Restaurant - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 3.3 Water - Stormwater": {"type": "string"}, "Design Laboratory - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Bank Branch - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Premises Street Address 1": {"type": "string"}, "Other - Technology/Science - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Medical Office - Number of MRI Machines": {"ignore_malformed": true, "type": "float"}, "Heating Delivery Type": {"type": "string"}, "Other - Stadium - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Hospital (General Medical & Surgical) - Tertiary Care": {"type": "string"}, "Other - Public Services - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Wall R-Value": {"ignore_malformed": true, "type": "float"}, "Typical Window to Wall Ratio": {"ignore_malformed": true, "type": "float"}, "Refrigeration Energy": {"ignore_malformed": true, "type": "float"}, "Recommended Measure": {"type": "string"}, "K-12 School - Number of Walk-in Refrigeration/Freezer Units": {"ignore_malformed": true, "type": "float"}, "Other - Stadium - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Design Wood Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Water Fixture Rated Flow Rate": {"ignore_malformed": true, "type": "float"}, "Number of Rooms": {"ignore_malformed": true, "type": "float"}, "Other Water Sources - Indoor Cost Intensity ($/ft2)": {"ignore_malformed": true, "type": "float"}, "Door Glazed Area Fraction": {"ignore_malformed": true, "type": "float"}, "Recirculation": {"type": "string"}, "Potable Water Savings": {"ignore_malformed": true, "type": "float"}, "Design Casino - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Design Office - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Typical Window Sill Height": {"ignore_malformed": true, "type": "float"}, "Floor Type": {"type": "string"}, "Daylighting Illuminance Set Point": {"ignore_malformed": true, "type": "float"}, "Water-Side Economizer DB Temperature Maximum": {"ignore_malformed": true, "type": "float"}, "Strip Mall - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Design Fast Food Restaurant - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Other - Entertainment/Public Assembly - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Anti-Sweat Heater Controls Manufacturer": {"type": "string"}, "Design Wastewater Treatment Plant - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Outpatient Rehabilitation/Physical Therapy - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Other - Stadium - Walk-in Refrigeration Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Hospital (General Medical & Surgical) - Number of Staffed Beds": {"ignore_malformed": true, "type": "float"}, "Design Retail Store - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Design Worship Facility - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Senior Care Community - Number of Commercial Washing Machines": {"ignore_malformed": true, "type": "float"}, "Burner Type": {"type": "string"}, "Other - Services - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Pump Minimum Flow Rate": {"ignore_malformed": true, "type": "float"}, "Movie Theater - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Bowling Alley - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Convenience Store with Gas Station - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Multifamily Housing - Maximum Number of Floors": {"ignore_malformed": true, "type": "float"}, "National Median Water/Wastewater Site EUI (kBtu/gpd)": {"ignore_malformed": true, "type": "float"}, "Supermarket/Grocery - Number of Open or Closed Refrigeration/Freezer Units": {"ignore_malformed": true, "type": "float"}, "Guiding Principles - % Yes": {"type": "string"}, "Refrigeration Unit Type": {"type": "string"}, "Medical Office - MRI Machine Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Transformer Rated Power": {"ignore_malformed": true, "type": "float"}, "Rated Cooling Sensible Heat Ratio": {"ignore_malformed": true, "type": "float"}, "Domestic Hot Water Type": {"type": "string"}, "Typical Window Area": {"ignore_malformed": true, "type": "float"}, "Laboratory - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Other Water Sources: Combined Indoor/Outdoor or Other Cost ($)": {"ignore_malformed": true, "type": "float"}, "Arch2030 Baseline": {"ignore_malformed": true, "type": "float"}, "Alternate Baseline Lighting Power Density": {"ignore_malformed": true, "type": "float"}, "Office - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Design Veterinary Office - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Serves Multiple Buildings": {"type": "string"}, "Performing Arts - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Humidity Control Maximum": {"ignore_malformed": true, "type": "float"}, "Hospital (General Medical & Surgical) - Onsite Laundry Facility": {"type": "string"}, "Pool Pump Duty Cycle": {"type": "string"}, "Process Load Installed Power": {"ignore_malformed": true, "type": "float"}, "Other - Public Services - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Ownership Status": {"type": "string"}, "Convenience Store with Gas Station - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Zoo - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Typical Window SHGC": {"ignore_malformed": true, "type": "float"}, "National Median Reference Property Type": {"type": "string"}, "Prison/Incarceration - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Roof Area": {"ignore_malformed": true, "type": "float"}, "Convention Center - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Fenestration Type": {"type": "string"}, "Economizer Low Temperature Lockout": {"type": "string"}, "ENERGY STAR Certification - Eligibility": {"type": "string"}, "Design Performing Arts - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Adult Education - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Worship Facility - Open All Weekdays": {"ignore_malformed": true, "type": "float"}, "Indoor Arena - Number of Sporting Events per Year": {"ignore_malformed": true, "type": "float"}, "Average Weekly Hours": {"ignore_malformed": true, "type": "float"}, "Wood Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Performing Arts - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Generation Annual Operation Hours": {"ignore_malformed": true, "type": "float"}, "Total GHG Emissions Intensity (kgCO2e/ft2)": {"ignore_malformed": true, "type": "float"}, "Reactive Power Charge": {"ignore_malformed": true, "type": "float"}, "Technology Category": {"type": "string"}, "Roof Exterior Thermal Absorptance": {"ignore_malformed": true, "type": "float"}, "Other - Mall - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Interior Automated Shades": {"type": "string"}, "Design Ice/Curling Rink - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "College/University - Enrollment": {"ignore_malformed": true, "type": "float"}, "Roof Framing Depth": {"ignore_malformed": true, "type": "float"}, "Evaporative Cooling Entering Supply Air DB Temperature": {"ignore_malformed": true, "type": "float"}, "Annual Fuel Use Consistent Units (Consistent Units)": {"type": "string"}, "Design Target Site EUI (kBtu/ft2)": {"ignore_malformed": true, "type": "float"}, "Pool Water Temperature": {"ignore_malformed": true, "type": "float"}, "Condensing Temperature": {"ignore_malformed": true, "type": "float"}, "Bank Branch - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Other - Technology/Science - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Data Center - National Median PUE": {"ignore_malformed": true, "type": "float"}, "Cooling Stage Capacity": {"ignore_malformed": true, "type": "float"}, "District Chilled Water Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Outdoor Water Cost (All Water Sources) ($)": {"ignore_malformed": true, "type": "float"}, "Aquarium - Number of Computers": {"ignore_malformed": true, "type": "float"}, "K-12 School - High School": {"type": "string"}, "Other - Utility - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Food Service - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Laundry Unit Quantity": {"ignore_malformed": true, "type": "float"}, "Pool Type": {"type": "string"}, "Fuel Oil (No. 1) Cost ($)": {"ignore_malformed": true, "type": "float"}, "Multifamily Housing - Percent of Gross Floor Area That is Common Space Only": {"ignore_malformed": true, "type": "float"}, "Locations of exterior water intrusion damage": {"type": "string"}, "Police Station - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Electricity (Grid Purchase) Cost ($)": {"ignore_malformed": true, "type": "float"}, "Light Shelf Distance from Top": {"ignore_malformed": true, "type": "float"}, "Laundry Unit Year of Manufacture": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Weather Data Source": {"type": "string"}, "Roof Exterior Solar Absorptance": {"ignore_malformed": true, "type": "float"}, "Boiler Insulation R Value": {"ignore_malformed": true, "type": "float"}, "Supermarket/Grocery - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Design PUE": {"ignore_malformed": true, "type": "float"}, "Food Service - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Fitness Center/Health Club/Gym - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Residence Hall/ Dormitory - Dining Hall": {"type": "string"}, "Duct Pressure Test Leakage cfm (cfm)": {"ignore_malformed": true, "type": "float"}, "Data Center - IT Site Energy (kWh)": {"ignore_malformed": true, "type": "float"}, "Laboratory - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Setup temperature cooling": {"ignore_malformed": true, "type": "float"}, "Roof Framing Material": {"type": "string"}, "Lifestyle Center - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Roof Insulated Area": {"ignore_malformed": true, "type": "float"}, "CMU Fill": {"type": "string"}, "Evaporator Pressure Regulators": {"type": "string"}, "Cooling is FEMP Designated Product": {"type": "string"}, "Emissions Factor - Source": {"type": "string"}, "Other - Stadium - Size of Electronic Scoreboards (ft2)": {"ignore_malformed": true, "type": "float"}, "Indoor Arena - Number of Concert/Show Events per Year": {"ignore_malformed": true, "type": "float"}, "Courthouse - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Window Horizontal Spacing": {"ignore_malformed": true, "type": "float"}, "Winter Peak": {"ignore_malformed": true, "type": "float"}, "Roof R-Value": {"ignore_malformed": true, "type": "float"}, "Other - Lodging/Residential - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Source Energy Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Residence Hall/Dormitory - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Other - Restaurant/Bar - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Municipally Supplied Reclaimed Water - Indoor Cost ($)": {"ignore_malformed": true, "type": "float"}, "Economizer Enthalpy Control Point": {"ignore_malformed": true, "type": "float"}, "Personal Services (Health/Beauty, Dry Cleaning, etc.) - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Data Center - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "College/University - Grant Dollars ($)": {"ignore_malformed": true, "type": "float"}, "Outpatient Rehabilitation/Physical Therapy - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Wholesale Club/Supercenter- Cash Register Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Self-Storage Facility - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Condensing Operation": {"type": "string"}, "Museum - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Fan Placement": {"type": "string"}, "National Median Site EUI (kBtu/ft2)": {"ignore_malformed": true, "type": "float"}, "Data Center - IT Energy Configuration": {"type": "string"}, "Medical Office - Surgical Operating Bed Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Ambulatory Surgical Center - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Potable": {"type": "string"}, "Quality Alert-Space Alert": {"type": "string"}, "Stadium (Closed) - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Percent of RECs Retained": {"ignore_malformed": true, "type": "float"}, "Wholesale Club/Supercenter- Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "National Median Site Energy Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Lighting Type": {"type": "string"}, "REALPac Energy Benchmarking Program Building Name": {"type": "string"}, "Utility Meter Number": {"type": "string"}, "Stadium (Closed) - Number of Special/Other Events per Year": {"ignore_malformed": true, "type": "float"}, "Non-Refrigerated Warehouse - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Design Target Site Energy Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Movie Theater - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Museum - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Other - Technology/Science - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Personal Services (Health/Beauty, Dry Cleaning, etc.) - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Other - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Other - Mall - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Other - Restaurant/Bar - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Food Sales - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Installed Power": {"ignore_malformed": true, "type": "float"}, "Primary Service Hot Water Location": {"type": "string"}, "Rated Lamp Life": {"ignore_malformed": true, "type": "float"}, "Natural Gas Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Clothes Washer Water Factor": {"ignore_malformed": true, "type": "float"}, "Energy Cost": {"ignore_malformed": true, "type": "float"}, "Cooling Tower Control Type": {"type": "string"}, "Annual Water Cost Savings": {"ignore_malformed": true, "type": "float"}, "Ice/Curling Rink - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Design Water/Wastewater Site EUI (kBtu/gpd)": {"ignore_malformed": true, "type": "float"}, "Movie Theater - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Plumbing Penetration Sealing": {"type": "string"}, "Personal Services (Health/Beauty, Dry Cleaning, etc.) - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Other - Lodging/Residential - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Cooling Degree Days (CDD) (\\u00b0F)": {"ignore_malformed": true, "type": "float"}, "Enclosed Mall - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Duct Surface Area": {"ignore_malformed": true, "type": "float"}, "Self-Storage Facility - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Owner Email Address": {"type": "string"}, "Pump Installed Flow Rate": {"ignore_malformed": true, "type": "float"}, "Hospital (General Medical & Surgical) - Licensed Bed Capacity Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Climate Zone": {"type": "string"}, "Police Station - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Net Present Value": {"ignore_malformed": true, "type": "float"}, "Other - Technology/Science - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Senior Care Community - Number of Computers": {"ignore_malformed": true, "type": "float"}, "ENERGY STAR Certification - Profile Published": {"type": "string"}, "Senior Care Community - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Input Voltage": {"ignore_malformed": true, "type": "float"}, "Electricity Sourced from Onsite Renewable Systems": {"ignore_malformed": true, "type": "float"}, "Motor RPM": {"ignore_malformed": true, "type": "float"}, "Ownership": {"type": "string"}, "Convenience Store without Gas Station - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Coke Cost ($)": {"ignore_malformed": true, "type": "float"}, "Fan Size": {"ignore_malformed": true, "type": "float"}, "Pool Hours Uncovered": {"ignore_malformed": true, "type": "float"}, "District Hot Water Cost ($)": {"ignore_malformed": true, "type": "float"}, "Veterinary Office - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Heating Degree Days (HDD) (\\u00b0F)": {"ignore_malformed": true, "type": "float"}, "Portfolio Manager Parent Property ID": {"type": "string"}, "Senior Care Community - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Type of resource meter": {"type": "string"}, "Museum - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Wall Exterior Thermal Absorptance": {"ignore_malformed": true, "type": "float"}, "Aquarium - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Percent Skylight Area": {"ignore_malformed": true, "type": "float"}, "Non-Refrigerated Warehouse - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Other Financial Incentives": {"type": "string"}, "Target Site Energy Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "College/University - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 3.2 Outdoor Water - Option 3": {"type": "string"}, "Guiding Principle 3.2 Outdoor Water - Option 2": {"type": "string"}, "Guiding Principle 3.2 Outdoor Water - Option 1": {"type": "string"}, "Water-Side Economizer Temperature Setpoint": {"ignore_malformed": true, "type": "float"}, "Pump Operation": {"type": "string"}, "Other - Specialty Hospital - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Target Total GHG Emissions (MtCO2e)": {"ignore_malformed": true, "type": "float"}, "Distribution Center - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Heat Recovery Type": {"type": "string"}, "Drinking Water Treatment & Distribution - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Quality Alert-Energy Alerts": {"type": "string"}, "Urgent Care/Clinic/Other Outpatient - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Refrigeration Compressor Type": {"type": "string"}, "Floor Area Value": {"ignore_malformed": true, "type": "float"}, "Work Plane Height": {"ignore_malformed": true, "type": "float"}, "Worship Facility - Seating Capacity": {"ignore_malformed": true, "type": "float"}, "Avoided Emissions - Onsite Green Power (MtCO2e)": {"ignore_malformed": true, "type": "float"}, "Benchmark Type": {"type": "string"}, "Multifamily Housing - Number of Dishwasher Hookups": {"ignore_malformed": true, "type": "float"}, "Roof Slope": {"ignore_malformed": true, "type": "float"}, "Multifamily Housing - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Annual Combined Whole Building Annual Weather Normalized Source Resource Use": {"ignore_malformed": true, "type": "float"}, "Primary Heating Type": {"type": "string"}, "Data Center - PUE": {"ignore_malformed": true, "type": "float"}, "Ambulatory Surgical Center - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Roller Rink - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Race Track - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Primary Fan Configuration": {"type": "string"}, "ENERGY STAR Certification - Last Approval Date": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Avoided Emissions": {"ignore_malformed": true, "type": "float"}, "Generation Capacity Unit": {"type": "string"}, "Other - Restaurant/Bar - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Fast Food Restaurant - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Fuel Oil (No. 4) Cost ($)": {"ignore_malformed": true, "type": "float"}, "Marginal Sell Rate": {"ignore_malformed": true, "type": "float"}, "Pool Control Type": {"type": "string"}, "Name of Audit Certification Holder": {"type": "string"}, "Roof Framing Configuration": {"type": "string"}, "Design Race Track - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 4.5 Indoor Environment - Low-Emitting Materials": {"type": "string"}, "Service and Product Provider": {"type": "string"}, "Mailing Center/Post Office - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Laboratory - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Measure Name": {"type": "string"}, "Normalization Start Year": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Bar/Nightclub - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Outside Air Temperature Upper Limit Heating Reset Control": {"ignore_malformed": true, "type": "float"}, "Laboratory - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Design Direct GHG Emissions (MtCO2e)": {"ignore_malformed": true, "type": "float"}, "Number of Heating Stages": {"ignore_malformed": true, "type": "float"}, "Barracks- Number of Rooms": {"ignore_malformed": true, "type": "float"}, "Pool is Heated": {"type": "string"}, "Vertical Edge Fin Only": {"type": "string"}, "Owner Postal Code": {"type": "string"}, "Stadium (Open) - Number of Walk-in Refrigeration/Freezer Units": {"ignore_malformed": true, "type": "float"}, "Municipally Supplied Potable Water - Outdoor Cost ($)": {"ignore_malformed": true, "type": "float"}, "Year PM Benchmarked": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Design Biomass GHG Emissions (MtCO2e)": {"ignore_malformed": true, "type": "float"}, "Cooling is ENERGY STAR Rated": {"type": "string"}, "Wall Insulation Thickness": {"ignore_malformed": true, "type": "float"}, "Other - Specialty Hospital - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Design Convention Center - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Retail Store - Walk-in Refrigeration Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Residence Hall/Dormitory - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Zoo - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Typical Skylight U-Value": {"ignore_malformed": true, "type": "float"}, "Other - Utility - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Prison/Incarceration - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Design Data Center - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 5.2 Materials - Biobased Content": {"type": "string"}, "Electricity Use - Grid Purchase and Generated from Onsite Renewable Systems (kBtu)": {"ignore_malformed": true, "type": "float"}, "Water Use (All Water Sources) (kgal)": {"ignore_malformed": true, "type": "float"}, "Other - Lodging/Residential - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Bowling Alley - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Indoor Water Cost Intensity (All Water Sources) ($/ft2)": {"ignore_malformed": true, "type": "float"}, "Supermarket/Grocery - Number of Cash Registers": {"ignore_malformed": true, "type": "float"}, "eGRID Region Code": {"type": "string"}, "Guiding Principle 5.1 Materials - Recycled Content": {"type": "string"}, "Year Occupied": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Building air leakage unit": {"type": "string"}, "Typical Window U-Value": {"ignore_malformed": true, "type": "float"}, "Wholesale Club/Supercenter- Walk-in Refrigeration Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Heating Refrigerant Type": {"type": "string"}, "Senior Care Community - Residential Washing Machine Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Outside Air Temperature Lower Limit Heating Reset Control": {"ignore_malformed": true, "type": "float"}, "Automobile Dealership - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Funding from Rebates": {"type": "string"}, "Process Load Type": {"type": "string"}, "Design Propane Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Financial Office - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Average Cooling Operating Hours": {"ignore_malformed": true, "type": "float"}, "Building Operator Name": {"type": "string"}, "Supermarket/Grocery - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Social/Meeting Hall - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Premises Tax Map Number": {"type": "string"}, "Retro-commissioning Date": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Water/Wastewater Estimated Savings from Energy Projects, Cumulative ($/GPD)": {"ignore_malformed": true, "type": "float"}, "Case Door Orientation": {"type": "string"}, "Owner Telephone Number": {"type": "string"}, "Office - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Movie Theater - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Urgent Care/Clinic/Other Outpatient - Number of Computers": {"ignore_malformed": true, "type": "float"}, "U.S. Federal Campus": {"type": "string"}, "Tightness": {"type": "string"}, "K-12 School - Student Seating Capacity": {"ignore_malformed": true, "type": "float"}, "Zoo - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Multiple Building Heights": {"ignore_malformed": true, "type": "float"}, "Hotel - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Annual Combined Whole Builidng Annual Site Energy Use Intensity (EUI)": {"ignore_malformed": true, "type": "float"}, "Other - Services - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Prison/Incarceration - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Bank Branch - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Other - Stadium - Number of Concert/Show Events per Year": {"ignore_malformed": true, "type": "float"}, "Number of Computers": {"ignore_malformed": true, "type": "float"}, "Scenario Type": {"type": "string"}, "Restaurant - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Reference Case": {"type": "string"}, "Wastewater Treatment Plant - Nutrient Removal": {"type": "string"}, "Municipally Supplied Potable Water - Indoor Intensity (gal/ft2)": {"ignore_malformed": true, "type": "float"}, "Condenser Fan Speed Operation": {"type": "string"}, "Weather Normalized Water/Wastewater Site Natural Gas Intensity (therms/gpd)": {"ignore_malformed": true, "type": "float"}, "Window Width": {"ignore_malformed": true, "type": "float"}, "Plug Load Standby Power": {"ignore_malformed": true, "type": "float"}, "Strip Mall - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Indoor Arena - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Restaurant - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Multifamily Housing - Government Subsidized Housing": {"type": "string"}, "Peak Occupancy Percentage": {"ignore_malformed": true, "type": "float"}, "Daily Hot Water Draw": {"ignore_malformed": true, "type": "float"}, "Analysis Period": {"type": "string"}, "Fan Application": {"type": "string"}, "Hotel - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Premises Conditioned Floor Area": {"ignore_malformed": true, "type": "float"}, "Design Other - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Onsite Renewable System Electricity Exported": {"ignore_malformed": true, "type": "float"}, "Pipe Insulation Thickness": {"ignore_malformed": true, "type": "float"}, "Site Use Description": {"type": "string"}, "PV System Maximum Power Output": {"ignore_malformed": true, "type": "float"}, "Measure Scale of Application": {"type": "string"}, "Transportation Terminal/Station - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Residence Hall/Dormitory - Number of Rooms": {"ignore_malformed": true, "type": "float"}, "Storage Tank Insulation R-Value": {"ignore_malformed": true, "type": "float"}, "Single Family Home - Number of Bedrooms": {"ignore_malformed": true, "type": "float"}, "Non-Refrigerated Warehouse - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Ventilation Control Method": {"type": "string"}, "Bank Branch - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Medical Office - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Bank Branch - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Supermarket/Grocery - Cooking Facilities": {"type": "string"}, "Hospital (General Medical & Surgical) - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 3.1 Water - Indoor Water Any Option (Any Option)": {"type": "string"}, "Typical Ground Coupling Type": {"type": "string"}, "Contact City": {"type": "string"}, "Design Distribution Center - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Other - Entertainment/Public Assembly - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Pre-school/Daycare - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Tightness/Fit Condition": {"type": "string"}, "Design Other - Services - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Other - Utility - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "College/University - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Retail Store - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Stadium (Closed) - Number of Walk-in Refrigeration/Freezer Units": {"ignore_malformed": true, "type": "float"}, "Wall Insulation Material": {"type": "string"}, "Gas Price Escalation Rate": {"ignore_malformed": true, "type": "float"}, "Absorption Stages": {"type": "string"}, "Floor R-Value": {"ignore_malformed": true, "type": "float"}, "Floor Area Custom Name": {"type": "string"}, "Water/Wastewater Direct GHG Emissions Intensity (kgCO2e/gpd)": {"ignore_malformed": true, "type": "float"}, "Multifamily Housing - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Retail Store - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Retail Store - Number of Open or Closed Refrigeration/Freezer Units": {"ignore_malformed": true, "type": "float"}, "Supply Air Temp Reset Control": {"type": "string"}, "Stadium (Closed) - Walk-in Refrigeration Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Single Family Home - Density of People (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Solar Hot Water Present": {"type": "string"}, "Wall Framing Configuration": {"type": "string"}, "National Median Total GHG Emissions (MtCO2e)": {"ignore_malformed": true, "type": "float"}, "Hotel - Commercial Refrigeration Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "K-12 School - Weekend Operation": {"type": "string"}, "Fire Station - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "LEED Certification Audit Exemption": {"type": "string"}, "Hospital (General Medical & Surgical) - Full Time Equivalent (FTE) Workers Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Premises Tax Book Number": {"type": "string"}, "Supermarket/Grocery - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Certification Program": {"type": "string"}, "Boiler Leaving Water Temperature": {"ignore_malformed": true, "type": "float"}, "Wholesale Club/Supercenter- Number of Computers": {"ignore_malformed": true, "type": "float"}, "Control Type": {"type": "string"}, "Premises Block Number": {"type": "string"}, "Repair Services (Vehicle, Shoe, Locksmith, etc.) - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Design Bar/Nightclub - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Summer Peak": {"ignore_malformed": true, "type": "float"}, "Convention Center - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Lamp Distribution Type": {"type": "string"}, "Water-Side Economizer Type": {"type": "string"}, "Manufacturing/Industrial Plant - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Design Transportation Terminal/Station - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "PV System Array Azimuth": {"ignore_malformed": true, "type": "float"}, "Roof Insulation Type": {"type": "string"}, "Premises Occupied Floor Area": {"ignore_malformed": true, "type": "float"}, "Skylight Operability": {"type": "string"}, "Financial Office - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "SHW is ENERGY STAR Rated": {"type": "string"}, "Stadium (Open) - Enclosed Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Indirect GHG Emissions (MtCO2e)": {"ignore_malformed": true, "type": "float"}, "Guiding Principle 2.5 Energy - Benchmarking": {"type": "string"}, "Lighting Control Type Occupancy": {"type": "string"}, "Premises Custom ID": {"type": "string"}, "Hospital (General Medical & Surgical) - Number of Workers on Main Shift Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Design Fuel Oil #4 Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "K-12 School - School District": {"type": "string"}, "Municipally Supplied Reclaimed Water: Combined Indoor/Outdoor or Other Cost ($)": {"ignore_malformed": true, "type": "float"}, "Wastewater Treatment Plant - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Retail Store - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "End Time Stamp": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Design Lifestyle Center - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Wholesale Club/Supercenter- Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Design Other Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Source Energy Use - Adjusted to Current Year (kBtu)": {"ignore_malformed": true, "type": "float"}, "Annual Savings Site Energy (Site Energy)": {"ignore_malformed": true, "type": "float"}, "Senior Care Community - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Economizer Type": {"type": "string"}, "Tank Volume": {"ignore_malformed": true, "type": "float"}, "Senior Care Community - Resident Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Number of Units": {"ignore_malformed": true, "type": "float"}, "Automobile Dealership - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Wastewater Treatment Plant - Average Influent Flow (MGD)": {"ignore_malformed": true, "type": "float"}, "K-12 School - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Swimming Pool - Location of Pool": {"type": "string"}, "Manufacturing/Industrial Plant - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "College/University - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Heating Staging": {"type": "string"}, "Distance Between Vertical Fins": {"ignore_malformed": true, "type": "float"}, "Total Heat Rejection": {"ignore_malformed": true, "type": "float"}, "Guiding Principles - % No": {"type": "string"}, "Floor Framing Configuration": {"type": "string"}, "Medical Office - Number of Surgical Operating Beds": {"ignore_malformed": true, "type": "float"}, "Restaurant - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Non-Refrigerated Warehouse - Number of Walk-in Refrigeration/Freezer Units": {"ignore_malformed": true, "type": "float"}, "Heating Setpoint setpoint": {"ignore_malformed": true, "type": "float"}, "Weather-Stripped": {"type": "string"}, "Fuel Use Intensity": {"ignore_malformed": true, "type": "float"}, "Contact State": {"type": "string"}, "Roof Framing Factor": {"ignore_malformed": true, "type": "float"}, "Bar/Nightclub - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Locations of interior water intrusion damage": {"type": "string"}, "Exterior Door Type": {"type": "string"}, "Enclosed Mall - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Slab Exposed Perimeter": {"ignore_malformed": true, "type": "float"}, "Type of Cooking Equipment": {"type": "string"}, "Target Water/Wastewater Source EUI (kBtu/gpd)": {"ignore_malformed": true, "type": "float"}, "Stadium (Closed) - Enclosed Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Supermarket/Grocery - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Other - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Stadium (Closed) - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Water/Wastewater Total GHG Emissions Intensity (kgCO2e/gpd)": {"ignore_malformed": true, "type": "float"}, "Discount Factor": {"ignore_malformed": true, "type": "float"}, "Retail Store - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Laboratory - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Premises Count": {"ignore_malformed": true, "type": "float"}, "Urgent Care/Clinic/Other Outpatient - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "OM Cost Annual Savings": {"ignore_malformed": true, "type": "float"}, "Casino - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Water Baseline Date": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Typical Window Type": {"type": "string"}, "Steam Boiler Minimum Operating Pressure": {"ignore_malformed": true, "type": "float"}, "Energy Recovery Efficiency": {"ignore_malformed": true, "type": "float"}, "Duct Insulation R-Value": {"ignore_malformed": true, "type": "float"}, "Premises City": {"type": "string"}, "Aquarium - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Strip Mall - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Vestibule": {"type": "string"}, "Municipally Supplied Reclaimed Water - Outdoor Cost ($)": {"ignore_malformed": true, "type": "float"}, "Indirect Tank Heating Source": {"type": "string"}, "Other - Public Services - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Federal Department": {"type": "string"}, "Other - Recreation - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Single Family Home - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Solar Thermal System Collector Tilt": {"ignore_malformed": true, "type": "float"}, "Fire Station - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Typical Exterior Shading Type": {"type": "string"}, "Anti-Sweat Heater Controls": {"type": "string"}, "Ice/Curling Rink - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Other Peak Rate": {"type": "string"}, "Design Total GHG Emissions (MtCO2e)": {"ignore_malformed": true, "type": "float"}, "Hospital (General Medical & Surgical) - MRI Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "K-12 School - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Pre-school/Daycare - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Duct Insulation": {"type": "string"}, "Bar/Nightclub - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Property Floor Area (Parking) (ft2)": {"ignore_malformed": true, "type": "float"}, "Resource": {"type": "string"}, "PV Module Length": {"ignore_malformed": true, "type": "float"}, "Tank Perimeter": {"ignore_malformed": true, "type": "float"}, "Hospital (General Medical & Surgical) - Licensed Bed Capacity": {"ignore_malformed": true, "type": "float"}, "Food Sales - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Ballast Type": {"type": "string"}, "Indoor Arena - Number of Special/Other Events per Year": {"ignore_malformed": true, "type": "float"}, "Door Configuration": {"type": "string"}, "Guiding Principle 1.5 Integrated - Commissioning": {"type": "string"}, "Convention Center - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Convention Center - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Design Target Water/Wastewater Site EUI (kBtu/gpd)": {"ignore_malformed": true, "type": "float"}, "Calculation Method": {"type": "string"}, "Radiant Barrier": {"type": "string"}, "Bar/Nightclub - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Light Shelf Interior Protrusion": {"ignore_malformed": true, "type": "float"}, "Convenience Store with Gas Station - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "ENERGY STAR Certification - Application Status": {"type": "string"}, "Veterinary Office - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Conveyance Standby Power": {"ignore_malformed": true, "type": "float"}, "Outside Air Reset Maximum Cooling Supply Temperature": {"ignore_malformed": true, "type": "float"}, "Energy/Power Station - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Floor-to-Floor Height": {"ignore_malformed": true, "type": "float"}, "Stadium (Closed) - Ice Events": {"ignore_malformed": true, "type": "float"}, "Transportation Terminal/Station - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Primary Zonal Cooling Type": {"type": "string"}, "eGRID Subregion": {"type": "string"}, "Window Sill Height": {"ignore_malformed": true, "type": "float"}, "Food Sales - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Convention Center - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Foundation Wall Insulation Condition": {"type": "string"}, "Construction Status": {"type": "string"}, "Indoor Arena - Walk-in Refrigeration Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Roof Insulation Condition": {"type": "string"}, "Design Stadium (Closed) - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Indoor Arena - Enclosed Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Electricity Use - Grid Purchase and Generated from Onsite Renewable Systems (kWh)": {"ignore_malformed": true, "type": "float"}, "Heating Setback Frequency": {"type": "string"}, "Barracks- Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Self-Storage Facility - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Ice/Curling Rink - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Anti-Sweat Heater Controls Model Number": {"type": "string"}, "Primary Zonal Cooling Fuel Type": {"type": "string"}, "Floor-to-Ceiling Height": {"ignore_malformed": true, "type": "float"}, "Total GHG Emissions (MtCO2e)": {"ignore_malformed": true, "type": "float"}, "Municipally Supplied Reclaimed Water - Indoor Intensity (gal/ft2)": {"ignore_malformed": true, "type": "float"}, "Dishwasher Loads Per Week": {"ignore_malformed": true, "type": "float"}, "Other - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Food Sales - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Non-Potable Water used for Irrigation": {"type": "string"}, "Asset Score": {"ignore_malformed": true, "type": "float"}, "Collection Date": {"ignore_malformed": true, "type": "date", "format": "MM/dd/yyyy||yyyy-MM-dd||d-MMM-y||dd-MMM-y||dd-MMM-yy||date_optional_time"}, "Electricity Use - Generated from Onsite Renewable Systems (kWh)": {"ignore_malformed": true, "type": "float"}, "Other Water Sources - Outdoor Use (kgal)": {"ignore_malformed": true, "type": "float"}, "Wall Framing Depth": {"ignore_malformed": true, "type": "float"}, "Natural Ventilation Rate": {"ignore_malformed": true, "type": "float"}, "Self-Storage Facility - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Design Target Source EUI (kBtu/ft2)": {"ignore_malformed": true, "type": "float"}, "Fire Station - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Refrigerated Warehouse - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Foundation Wall Type": {"type": "string"}, "Indoor Arena - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Input Capacity": {"ignore_malformed": true, "type": "float"}, "Natural Ventilation": {"type": "string"}, "Design Greenhouse Gas Emissions Intensity": {"ignore_malformed": true, "type": "float"}, "Ambulatory Surgical Center - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "Other - Restaurant/Bar - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Hot Water Boiler Minimum Flow Rate": {"ignore_malformed": true, "type": "float"}, "PV System Number of Modules per Array": {"ignore_malformed": true, "type": "float"}, "Propane Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Stadium (Open) - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Primary Zonal Heating Type": {"type": "string"}, "Lifestyle Center - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Senior Care Community - Number of Residential Washing Machines": {"ignore_malformed": true, "type": "float"}, "Retail Store - Open or Closed Refrigeration Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Municipally Supplied Potable Water - Outdoor Use (kgal)": {"ignore_malformed": true, "type": "float"}, "Floor Framing Depth": {"ignore_malformed": true, "type": "float"}, "Retail Store - Exterior Entrance to the Public": {"type": "string"}, "Lifestyle Center - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Food Service - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Alternative Water Generated On-Site - Indoor Cost Intensity ($/ft2)": {"ignore_malformed": true, "type": "float"}, "Bank Branch - Number of Computers": {"ignore_malformed": true, "type": "float"}, "Design Police Station - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "In Portfolio Manager": {"type": "string"}, "Utility Name": {"type": "string"}, "Design Ambient Temperature": {"ignore_malformed": true, "type": "float"}, "Primary Cooking Fuel": {"type": "string"}, "PV System Number of Arrays": {"ignore_malformed": true, "type": "float"}, "Courthouse - Percent That Can Be Cooled": {"ignore_malformed": true, "type": "float"}, "Lighting Power Density": {"ignore_malformed": true, "type": "float"}, "Stadium (Closed) - Size of Electronic Scoreboards (ft2)": {"ignore_malformed": true, "type": "float"}, "Parking - Completely Enclosed Parking Garage Size (ft2)": {"ignore_malformed": true, "type": "float"}, "Fixture Spacing": {"type": "string"}, "Heating Stage Capacity": {"ignore_malformed": true, "type": "float"}, "Number of Exterior Doors": {"ignore_malformed": true, "type": "float"}, "Museum - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Design Coke Use (kBtu)": {"ignore_malformed": true, "type": "float"}, "Design Personal Services (Health/Beauty, Dry Cleaning, etc) - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Lighting is ENERGY STAR Rated": {"type": "string"}, "Green Power - Onsite (kWh)": {"ignore_malformed": true, "type": "float"}, "Outside Air Temperature Lower Limit Cooling Reset Control": {"ignore_malformed": true, "type": "float"}, "Wall Insulation Type": {"type": "string"}, "Office - Worker Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Design Target ENERGY STAR Score": {"ignore_malformed": true, "type": "float"}, "Cooking Energy per Meal": {"ignore_malformed": true, "type": "float"}, "Ceiling Visible Absorptance": {"ignore_malformed": true, "type": "float"}, "Food Service - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Cooking Capacity": {"ignore_malformed": true, "type": "float"}, "Typical Window Visual Transmittance": {"ignore_malformed": true, "type": "float"}, "Stadium (Open) - Number of Special/Other Events per Year": {"ignore_malformed": true, "type": "float"}, "Motor Full Load Amps": {"ignore_malformed": true, "type": "float"}, "Number of Lamps per Luminaire": {"ignore_malformed": true, "type": "float"}, "Indoor Arena - Number of Walk-in Refrigeration/Freezer Units": {"ignore_malformed": true, "type": "float"}, "Duct Sealing": {"type": "string"}, "Design Parking - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Other - Restaurant/Bar - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Cooling Supply Air Temperature Control Type": {"type": "string"}, "Supermarket/Grocery - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Data Center - IT Source Energy (kBtu)": {"ignore_malformed": true, "type": "float"}, "Convenience Store without Gas Station - Computer Density (Number per 1,000 ft2)": {"ignore_malformed": true, "type": "float"}, "Slab Insulation Thickness": {"ignore_malformed": true, "type": "float"}, "Design Energy Cost ($)": {"ignore_malformed": true, "type": "float"}, "Pumping Configuration": {"type": "string"}, "Federal Sustainability Checklist Completion Percentage": {"ignore_malformed": true, "type": "float"}, "Hospital (General Medical & Surgical) - Number of Workers on Main Shift": {"ignore_malformed": true, "type": "float"}, "Strip Mall - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Metered Areas (Water)": {"type": "string"}, "Senior Care Community - Maximum Resident Capacity": {"ignore_malformed": true, "type": "float"}, "Other - Services - Weekly Operating Hours": {"ignore_malformed": true, "type": "float"}, "K-12 School - Percent That Can Be Heated": {"ignore_malformed": true, "type": "float"}, "Foundation Area": {"ignore_malformed": true, "type": "float"}, "Third party certification": {"type": "string"}, "Guiding Principles - Principles Date Achieved": {"type": "string"}, "Design Movie Theater - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Hotel - Cooking Facilities": {"type": "string"}, "Design Urgent Care/Clinic/Other Outpatient - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Single Family Home - Number of People": {"ignore_malformed": true, "type": "float"}, "Design Strip Mall - Gross Floor Area (ft2)": {"ignore_malformed": true, "type": "float"}, "Source Energy Use": {"ignore_malformed": true, "type": "float"}, "District Steam": {"type": "string"}, "Other Cost ($)": {"ignore_malformed": true, "type": "float"}}}, "space_alerts": {"type": "string"}, "pm_property_id": {"index": "not_analyzed", "type": "string", "doc_values": true}, "use_description": {"type": "string"}, "conditioned_floor_area": {"type": "float"}, "site_eui_weather_normalized": {"type": "float"}, "property_name": {"type": "string"}, "building_certification": {"type": "string"}, "state_province": {"type": "string"}, "energy_alerts": {"type": "string"}, "year_built": {"type": "float"}, "release_date": {"type": "date"}, "gross_floor_area": {"type": "float"}, "longitude": {"type": "float"}, "owner_city_state": {"type": "string"}, "owner_telephone": {"type": "string"}, "recent_sale_date": {"type": "date"}, "postal_code": {"type": "string"}, "tax_lot_id": {"index": "not_analyzed", "type": "string", "doc_values": true}, "address_line_2": {"type": "string"}, "energy_score": {"type": "float"}}}}, "dynamic_templates": [{"goals_as_floats": {"path_match": "building_snapshot.extra_data.*_goal", "mapping": {"ignore_malformed": true, "type": "float"}, "match_pattern": "regex", "match_mapping_type": "double|long|integer|float"}}, {"extra_data_as_string": {"path_match": "building_snapshot.extra_data.*", "mapping": {"type": "string"}, "match_pattern": "regex", "match_mapping_type": "date|boolean|double|long|integer|float"}}]}}'
# comment out the following line (mapping building_snapshot) to get aggs on 1.5.1
curl -XPUT localhost:9200/test/_mapping/building_snapshot -d '{"building_snapshot": {"properties": {"lot_number": {"type": "string"}, "owner_address": {"type": "string"}, "owner_postal_code": {"type": "string"}, "block_number": {"type": "string"}, "project_buildings": {"type": "nested"}, "source_eui_weather_normalized": {"type": "float"}, "owner_email": {"type": "string"}, "year_ending": {"type": "date"}, "building_count": {"type": "float"}, "postal_code": {"type": "string"}, "owner": {"type": "string"}, "site_eui": {"type": "float"}, "address_line_1": {"type": "string"}, "occupied_floor_area": {"type": "float"}, "source_eui": {"type": "float"}, "custom_id_1": {"index": "not_analyzed", "type": "string", "doc_values": true}, "city": {"type": "string"}, "property_notes": {"type": "string"}, "district": {"type": "string"}, "location": {"type": "geo_point"}, "latitude": {"type": "float"}, "generation_date": {"type": "date"}, "extra_data": {"dynamic": false, "type": "object", "properties": {"normalized_address": {"index": "not_analyzed", "type": "string", "store": true}}}, "space_alerts": {"type": "string"}, "pm_property_id": {"index": "not_analyzed", "type": "string", "doc_values": true}, "use_description": {"type": "string"}, "conditioned_floor_area": {"type": "float"}, "site_eui_weather_normalized": {"type": "float"}, "property_name": {"type": "string"}, "building_certification": {"type": "string"}, "state_province": {"type": "string"}, "energy_alerts": {"type": "string"}, "year_built": {"type": "float"}, "release_date": {"type": "date"}, "gross_floor_area": {"type": "float"}, "longitude": {"type": "float"}, "owner_city_state": {"type": "string"}, "owner_telephone": {"type": "string"}, "recent_sale_date": {"type": "date"}, "tax_lot_id": {"index": "not_analyzed", "type": "string", "doc_values": true}, "address_line_2": {"type": "string"}, "energy_score": {"type": "float"}}}}'
echo ""

echo ""
echo "check mappings"
echo ""
# comment in for mappings
# curl -XGET localhost:9200/test/_mapping
echo ""

echo ""
echo "create docs"
echo ""
curl -XPUT localhost:9200/test/test/1 -d '{"building_snapshot": {"extra_data": {"test": 13}, "year_built": 10, "gross_floor_area": 39636.66217959946}}'
curl -XPUT localhost:9200/test/test/2 -d '{"building_snapshot": {"extra_data": {"test": 13}, "year_built": 11, "gross_floor_area": 39636.66217959946}}'
curl -XPUT localhost:9200/test/test/3 -d '{"building_snapshot": {"extra_data": {"test": 13}, "year_built": 12, "gross_floor_area": 39636.66217959946}}'
curl -XPUT localhost:9200/test/test/4 -d '{"building_snapshot": {"extra_data": {"test": 13}, "year_built": 13, "gross_floor_area": 39636.66217959946}}'
curl -XPUT localhost:9200/test/test/5 -d '{"building_snapshot": {"extra_data": {"test": 13}, "year_built": 14, "gross_floor_area": 39636.66217959946}}'
curl -XPUT localhost:9200/test/test/6 -d '{"building_snapshot": {"extra_data": {"test": 13}, "year_built": 8, "gross_floor_area": 39636.66217959946}}'
curl -XPUT localhost:9200/test/test/7 -d '{"building_snapshot": {"extra_data": {"test": 13}, "year_built": 4, "gross_floor_area": 39636.66217959946}}'
curl -XPUT localhost:9200/test/test/8 -d '{"building_snapshot": {"extra_data": {"test": 13}, "year_built": 1, "gross_floor_area": 39636.66217959946}}'
curl -XPUT localhost:9200/test/test/9 -d '{"building_snapshot": {"extra_data": {"test": 13}, "year_built": 1995, "gross_floor_area": 39636.66217959946}}'
curl -XPUT localhost:9200/test/test/10 -d '{"building_snapshot": {"extra_data": {"test": 13}, "year_built": null, "gross_floor_area": 39636.66217959946}}'
echo ""

echo ""
echo "wait for index to refresh"
curl -XPOST localhost:9200/_refresh
echo ""

echo ""
echo "search with aggs"
echo ""
curl -XGET localhost:9200/test/test/_search?pretty -d '{"query": {"filtered": {"filter": {"range": {"building_snapshot.gross_floor_area": {"gte": 200}}}}}, "aggs": {"gfa": {"stats": {"field": "building_snapshot.year_built"}}}}'

# Output 1.5.1 building_snapshot mapping included
# "aggregations" : {
#   "gfa" : {
#     "count" : 0,
#     "min" : null,
#     "max" : null,
#     "avg" : null,
#     "sum" : null
#   }
# }
#
# Output 1.5.1 building_snapshot mapping excluded
# "aggregations" : {
#   "gfa" : {
#     "count" : 9,
#     "min" : 1.0,
#     "max" : 1995.0,
#     "avg" : 229.77777777777777,
#     "sum" : 2068.0,
#     "min_as_string" : "1.0",
#     "max_as_string" : "1995.0",
#     "avg_as_string" : "229.77777777777777",
#     "sum_as_string" : "2068.0"
#   }
# }
#
# Output 1.4.4 mapping included or excluded
# "aggregations" : {
#   "gfa" : {
#     "count" : 9,
#     "min" : 1.0,
#     "max" : 1995.0,
#     "avg" : 229.77777777777777,
#     "sum" : 2068.0
#   }
# }

[clintongormley]

Hi @alecklandgraf

Thanks for reporting. Actually, this problem is not new in 1.5, it is just a matter of luck that you didn't hit it before. Field lookup in the 1.x series is ambiguous. This issue is a duplicate of https://github.com/elastic/elasticsearch/issues/6108. For related problems, see the issues linked to on this issue: https://github.com/elastic/elasticsearch/issues/4081

All of this is being fixed in 2.0 by #8870.