"ny-gov/rsbs-single-family-onsite-inspections-measure-c8sd-bzeb:latest"."rsbs_single_family_onsite_inspections_measure"

SELECT
    ":id", -- Socrata column ID
    "no_cable_boxes_plugged_into_smart_strips_or_outlets", -- Number of cable boxes plugged into power outlets or smart strips during on-site visit [e.g., 0-9]
    "description_of_plug_loads", -- What type of plug load is being described [e.g., 2-way Radio Setup-Work Shop]
    "no_plug_loads", -- Number of appliances plugged into power outlets during on-site visit [e.g., 1 – 65]
    "no_t12_light_bulbs", -- Number of T12 light bulbs [e.g., 0-150]
    "dhw_unit_heat_recovery", -- Presence of DHW unit heat recovery system [e.g., No-Yes]
    "efficiency_rating_of_dhw_heat_recovery", -- Efficiency rating of DHW heat recovery system [e.g., .21-100]
    "presence_of_orphan_natural_draft_dhw", -- Presence of an orphan natural draft DHW [e.g., No – Yes] 
    "storage_volume_of_the_unit_gallons", -- Size of storage tank in gallons [e.g., 0-120] 
    "thickness_of_dhw_pipe_insulation_inches", -- DHW pipe insulation thickness measured in inches [e.g., 0 -9]
    "dhw_insulation_thickness_inches", -- Thickness of DHW insulation, measured in inches [e.g., 0-10.5]
    "is_hvac_heating_primary_or_secondary_source", -- Is the heating unit the primary or secondary source of heating? [e.g., Primary-Secondary( Simultaneous)]
    "hvac_heating_year_manufactured", -- Year HVAC Heating unit was manufactured [e.g., 1935-2014]
    "year_known_or_estimated", -- Is the year of manufacture of the heating unit known or estimated? [e.g., Estimated-Known]
    "condition_of_hvac_heating_furnace_air_filter", -- The condition of the HVAC heating furnace air filter [e.g., Fair - Poor]
    "hvac_heating_model_number", -- HVAC heating unit model number [e.g., 207-YF24]
    "hvac_heating_capacity", -- End range of the heating unit, measured in BTU/hr [e.g., 37.5-650000]
    "is_there_an_hvac_heating_filter_slot_cover", -- Does the HVAC Heating unit have a filter slot cover? [e.g., No-Yes]
    "number_of_hvac_heating_systems", -- Number of heating systems in the unit or building [e.g., 1-35]
    "rated_efficiency_of_heating_system", -- The heating fuel usage efficiency rating of the heating unit [e.g., .9 - 100]
    "hvac_heating_efficiency_type", -- Unit that the heating efficiency of the heating unit is measured in [e.g., AFUE %-HSPF]
    "hvac_heating_efficiency_data_source", -- What was the efficiency data for the heating unit derived from? [e.g., AHRI-Similar Equipment]
    "visual_condition_of_heating_system", -- Condition of heating system based on a visual inspection [e.g., Disrepair - Well Maintained]
    "refrigerator_with_indoor_water_dispenser", -- Presence of refrigerator with indoor water dispenser  [e.g., No-Yes]
    "pool_hot_tub_pump_speeds", -- Pool/Hot Tub pump speed setting [e.g., Multi Speed – Variable Speed]
    "solar_dhw_system_in_working_order", -- Is the installed DHW solar system in working order, condition? [e.g., Yes]
    "interior_or_cavity_insulation_quality_grade_i_iii", -- Quality of interior or cavity insulation [e.g., Grade I – Sub Grade III ]
    "dhw_solar_system_presence", -- Presence of a DHW solar system installed on site [e.g., No – Yes]
    "interior_or_cavity_insulation_type", -- Type of interior or cavity insulation [e.g., AirKrete-XPS and Spray Foam]
    "source_for_solar_dhw_capacity", -- Source of DHW solar system capacity data collected [e.g., Plate – SQFT]
    "pool_hot_tub_above_ground_or_in_ground", -- Presence of above ground or in ground pool or hot tub [e.g., Above Ground – In ground]
    "is_hvac_cooling_energy_star", -- Presence of an Energy Star rated HVAC Cooling system [e.g., No-Yes]
    "hvac_cooling_efficiency_data_source", -- Data source for HVAC cooling efficiency rating [e.g., AHRI - Similar Equipment]
    "dhw_fuel_type", -- Type of fuel used for DHW unit [e.g., Electricity- Wood Pellets]
    "attic_access_weather_stripping", -- Presence of weather stripping around attic access [e.g., Fair-Poor ]
    "hvac_fuel_type", -- Type of fuel used for DHW unit [e.g., Coal, Hard – Wood Pellets]
    "measure_id", -- Unique identifier for each measure reviewed during the on-site single family inspection
    "climate_zone", -- IECC climate Zone [e.g., Climate Zone 4-6]; see https://energycode.pnl.gov/EnergyCodeReqs/?state=New%20York for a map and details for each zone
    "region", -- Region in New York [e.g., Capital District-Western New York]
    "county", -- County in New York where the multifamily building is located [e.g., Albany – Yates]
    "appliance_category", -- Categorization of examined appliances [e.g., Clothes Dryer - Wine Cooler]
    "survey_weight", -- The survey weights are used to ensure that the sample accurately reflects the original population distribution by climate zone and construction type. [36.70-18797.72]
    "surface_type", -- Type of surface inspected [e.g., Ceiling-Wall]
    "rated_efficiency_of_hvac_cooling_system", -- Rated efficiency of HVAC cooling system based on on-site visit [e.g., 3-41]
    "what_unit_does_the_hvac_cooling_system_serve", -- Type of unit that the HVAC cooling system serves [e.g., Multiple Units in Building-SF Home]
    "no_incandescent_light_bulbs", -- Number of incandescent light bulbs [e.g., 0-150]
    "no_lighting_controls", -- Number of installed lighting controls  [e.g., 1-40]
    "location_of_unit", -- Unit located in conditioned or unconditioned space [e.g., Conditioned – Unconditioned]
    "year_building_built", -- Year that the single family building was constructed [e.g., 1790 – 2014]
    "dishwasher_usage_pattern_cycles_week", -- Frequency that dishwasher is used, measured in cycles per week [e.g., 0 – 14]
    "appliance_unit_manufacturer", -- Appliance Manufacturer Name [e.g., Admiral – Woods]
    "equipment_category", -- Data collection was performed through database software; as a result there were individual datasets for each major equipment type. This column shows the dataset that is related to the specific measure.
    "age_of_unit_known_or_estimated", -- Is the age of the unit known or estimated [e.g., Estimated-Known]
    "appliance_model_number", -- Model number of appliance [e.g., 291 - ZIS42NY]
    "appliance_wattage", -- Wattage of appliance identified [e.g., 10-20000]
    "fan_usage", -- Presence of fans used seasonally or all year round [e.g., Fall - Year Round]
    "appliance_fuel", -- Type of fuel that the specific appliance uses [e.g., Electricity – Wood]
    "dishwasher_efficiency_rating_energy_factor", -- Efficiency rating of dishwasher, measured by its Energy Factor [e.g., .29 – 1]
    "does_the_new_construction_home_contain_an_air_duct_system", -- Presence of an air duct system in newly constructed building [e.g., No – Yes]
    "hvac_heating_system_type", -- Type of heating system [e.g., Air Source Heat Pump-Wall Furnace]
    "pressurization_or_depressurization", -- Performed pressurization or depressurization air duct test during on-site visit [e.g., Depressurization to Pressurization]
    "solar_dhw_system_capacity_gallons", -- Capacity of DHW solar system [e.g., 0 – 142]
    "visual_condition_of_cooling_system", -- Observed visual condition of HVAC cooling system during on-site visit [e.g., Disrepair-Well Maintained]
    "is_hvac_heating_energy_star", -- Is the HVAC heating unit Energy Star rated? [e.g., No-Yes]
    "no_dvd_players_plugged_into_smart_strips_or_outlets", -- Number of DVD Players plugged into power outlets or smart strips during on-site visit [e.g., 0-6]
    "computer_monitor_type", -- Type of computer monitor present during on-site [e.g., CRT-Plasma]
    "number_of_units", -- Number of a specific type of appliance identified during on-site [e.g., 1-20]
    "dhw_age", -- Age of individual DHW unit [e.g., 0 – 44]
    "hvac_system_fuel_type", -- Type of fuel used by the heating unit [e.g., Coal, Hard-Wood Pellets]
    "type_style_of_appliance", -- Type and style of appliance [e.g., Bottom Freezer-Ventless]
    "other_large_appliances", -- Other large appliances listed during onsite visit [e.g., Air Purifier-Wood Working Equipment]
    "year_appliance_was_manufactured", -- Year that appliance was manufactured [e.g., 1950-2014]
    "pool_hot_tub_pump_horsepower", -- Horsepower for pool and hot tub pump [e.g., 0 – 3]
    "type_of_conditioned_air_being_distributed_by_the_duct_system", -- Type of air duct system inspected [e.g., Cooling- No Distribution System Present]
    "construction_material_of_building_envelope", -- Construction material of building envelope [e.g., 2x10 - Wood Plank] 
    "hvac_cooling_manufacturer", -- Manufacturer of HVAC cooling system [e.g., AIRE-Flo Zenith]
    "hvac_cooling_model_number", -- Model of HVAC cooling system [253.70051-ZW5010Y0]
    "hvac_cooling_capacity", -- Measured HVAC cooling capacity [e.g., 1600-114000]
    "hvac_heating_manufacturer", -- Name of manufacturer of heating unit [e.g., A O Smith-Yukon]
    "when_was_hvac_heating_system_last_serviced", -- When was the heating unit last serviced by an HVAC professional? [e.g., 1970 - 2014]
    "no_halogen_light_bulbs", -- Number of halogen light bulbs [e.g., 0-150]
    "type_of_other_light_bulbs", -- Type of other light bulbs [e.g., Blacklight- Xenon]
    "location_of_lighting_unit", -- Where the lighting unit is installed on site [e.g., 3 season Porch-Yoga Outbuilding]
    "site_id", -- Anonymous identifier applied to the single family site for the on-site single family inspection
    "energy_star_certified", -- Is the appliance Energy Star certified [e.g., No-Yes]
    "tetra_tech_id_by_region", -- Anonymous unique identifier that links the on-site inspection data to the telephone or web survey with single and multifamily occupants [ST#####]. The first two letters of the ID represent a New York State Regional Economic Development Council: CD=Capital District, CN= Central New York, FL=Finger Lakers, LI=Long Island, MH=Mid-Hudson, MV=Mohawk Valley, NC=North Country, NY=New York City, ST=Southern Tier, WN=Western New York
    "loads_per_week", -- Number of loads per run [e.g., 0-40]
    "television_screen_size_inches", -- Size of television screen measured in inches [e.g., 5-90] 
    "total_air_duct_interior_and_exterior_leakage", -- Total air duct leakage at pressurization of 25 cubic feet per minute, includes interior and exterior leakage [e.g., 0-3700]
    "dhw_type", -- Type of DHW system [e.g., ASHP w/Tank – Storage Water Heater]
    "no_of_water_heaters", -- Number of water heaters in the building [e.g., 1-2]
    "dhw_model_number", -- DHW unit model number [e.g., 153.31333 - XG50T06EC38UO]
    "unit_energy_factor", -- Energy Factor efficiency rating of DHW unit [e.g., .4 – 2.4]
    "humidifier_usage", -- Was humidifier or dehumidifier used seasonally or all year round [e.g., Spring – Year Round]
    "percent_of_total_exterior_and_interior_surfaces_that_are_insula", -- Percentage of total exterior and interior surfaces that are insulated [e.g., 10-100]
    "exterior_or_continuous_insulation_type", -- Type of exterior or continuous insulation [e.g., Belly Wrap - XPS]
    "interior_or_cavity_insulation_thickness_inches", -- Thickness of interior or cavity insulation measured in inches [e.g., 0 - 24]
    "cooling_setback_temperature", -- Temperature cooling unit is set to during setback (degrees in Fahrenheit) [e.g., 50-90]
    "what_percentage_of_conditioned_space_does_the_hvac_heating_unit", -- What Percentage of Conditioned Space Does the HVAC Heating Unit Serve? [e.g., 0-100]
    "heated_pool_hot_tub", -- Presence of heated pool or hot tub on site [e.g., No – Yes]
    "no_tier_2_plug_loads_smart_strips_and_outlets", -- Number of Tier 2 plug loads, smart strips and outlets [e.g., 0-1]
    "no_vcr_s_plugged_into_smart_strips_or_outlets", -- Number of VCR's plugged into power outlets or smart strips during on-site visit [e.g., 0-4]
    "pool_hot_tub_high_efficiency_pump", -- Presence of high efficiency pool or hot tub pump [e.g., No – Yes]
    "no_tier_1_plug_loads_smart_strips_and_outlets", -- Number of Tier 1 plug loads, smart strips and outlets [e.g., 0-2]
    "no_stereo_systems_plugged_into_smart_strips_or_outlets", -- Number of stereo systems plugged into power outlets or smart strips during on-site visit [e.g., 0-4] 
    "no_printers_and_copiers_plugged_into_smart_strips_or_outlets", -- Number of printers and copiers plugged into power outlets or smart strips during on-site visit [e.g., 0-5]
    "size_of_refrigerator_or_freezer_cu_ft", -- Refrigerator or freezer size, measured in cubic feet [e.g., 1-30]
    "no_gaming_consoles_plugged_into_smart_strips_or_outlets", -- Number of gaming consoles plugged into power outlets or smart strips during on-site visit [e.g., 0-6]
    "air_duct_leakage_to_the_outside", -- Air duct leakage to the outside at pressurization of 25 cubic feet per minute [e.g., 0-1200]
    "type_of_building_served_by_dhw", -- Type of building that is served by a DHW system [e.g., Multiple units in building-SF Home]
    "dhw_manufacture_year", -- Year that present DHW unit was manufactured [e.g., 1970-2014]
    "age_known_or_estimated", -- Is the year estimated or known? [e.g., Estimated-Known]
    "dhw_unit_manufacturer", -- Manufacturer of DHW unit [e.g., A.O Smith-Williamson]
    "efficiency_data_source", -- Source of efficiency data collected for DHW system [e.g., AHRI -Similar Equipment]
    "dhw_venting", -- Type of DHW venting found in the building  [e.g., Atmospheric-Sealed Combustion]
    "water_temperature_setting", -- Water temperature setting [e.g., 100-165]
    "no_fax_machines_plugged_into_smart_strips_or_outlets", -- Number of fax machines plugged into power outlets or smart strips during on-site visit [e.g., 0-1]
    "window_or_door", -- Is the measure observed a window or door? [e.g., Door-Window]
    "door_material", -- Material the door is made of [e.g., Double Glazed – Wood w/Glazing and Storm]
    "door_weather_stripping", -- Presence and quality of door weather stripping [e.g., Fair-Poor]
    "no_windows", -- Number of windows located onsite [e.g., 1-66]
    "window_size_inches", -- Size of the window measured in inches [e.g., 0 – 600]
    "u_factor", -- U factor rating of window insulation [e.g., .2 – 1.3]
    "no_space_heaters_plugged_into_smart_strips_or_outlets", -- Number of space heaters plugged into power outlets or smart strips during on-site visit [e.g., 0-5] 
    "construction_type", -- Flag indicating construction type [e.g., Existing-New]
    "window_glazing", -- Type of window glazing [e.g., Double-Triple Low-e]
    "window_frame_type", -- Type of window frame [e.g., Concrete – Wood/Vinyl]
    "bay_windows", -- Presence of bay windows during the onsite visit [e.g., No-Yes]
    "window_treatments", -- Window treatments identified during on-site visit [e.g., None – Window Films]
    "storm_windows", -- Presence of storm windows during onsite visit [e.g., Exterior – none]
    "hvac_systems_served", -- Which units are using HVAC controls? [e.g., All Systems-Secondary]
    "hvac_controls_thermostat_type", -- Type of Thermostat [e.g., Analog-Digital]
    "cooling_setback_hours", -- Number of hours cooling setback runs for [e.g., 0-24]
    "set_point_temperature_for_cooling_season", -- Temperature cooling unit is set to during cooling (degrees in Fahrenheit) season [e.g., 50-88]
    "heating_setback_hours", -- Number of hours heating setback runs for [e.g., 0-24]
    "no_home_theater_systems_plugged_into_smart_strips_or_outlets", -- Number of home theater systems plugged into power outlets or smart strips during on-site visit [e.g., 0-3]
    "overall_window_condition", -- Overall condition of window [e.g., Fair-Poor]
    "heating_setback_temperature", -- Temperature heating unit is set to during setback (degrees in Fahrenheit) [e.g., 50-90]
    "gas_filled_window", -- Presence of a gas filled window [e.g., No-Yes]
    "set_point_temperature_for_heating_season", -- Temperature heating unit is set to during heating (degrees in Fahrenheit) season [e.g., 50-82]
    "are_hvac_controlled_thermostats_programmable", -- Are the HVAC controlled thermostats programmable? [e.g., Non-Programmable-Programmable but not Programmed]
    "status_of_thermostat_at_time_of_inspection", -- Setting of thermostat when inspector visited site [e.g., Auto-Off]
    "what_percentage_of_conditioned_space_does_the_hvac_cooling_unit", -- Total percentage of conditioned space that HVAC cooling unit serves [e.g., 0-100]
    "is_hvac_cooling_primary_or_secondary_source", -- Is the cooling unit in question the primary source of cooling? [e.g., Primary-Secondary (Simultaneous)]
    "hvac_cooling_system_type", -- Type of HVAC cooling system examined during on-site [e.g., Air Source Heat Pump-Room Window AC]
    "single_family_or_multifamily", -- Single family or multifamily identifier
    "hvac_cooling_manufacture_year", -- Year HVAC cooling system was installed [e.g., 1974-2014]
    "age_known_estimated", -- Is the installation year of the HVAC cooling system known or estimated? [e.g., Estimated-Known]
    "washing_machine_temperature", -- Temperature options for the washing machine [e.g., All of the Above - Warm and Cold]
    "no_ac_units", -- Number of AC units identified during on-site visit [e.g., 1-4]
    "hvac_cooling_efficiency_type", -- Specific type of HVAC cooling efficiency [e.g., COP-SEER]
    "hvac_cooling_filter_slot_cover", -- Presence of an HVAC cooling filter slot cover [e.g., No-Yes] 
    "location_of_cooling_system", -- Location of HVAC cooling system is conditioned or not conditioned [e.g., Conditioned-Unconditioned]
    "condition_of_furnace_air_filter", -- Condition of HVAC cooling furnace air filter [e.g. Fair-Poor]
    "heating_ventilation_type", -- Type of venting used by the heating unit [e.g., Atmospheric - Sealed Combustion]
    "does_the_hvac_heating_system_have_thermostatic_radiator_valves", -- Does the HVAC Heating System have Thermostatic Radiator valves? [e.g., No-Yes]
    "what_unit_does_the_hvac_heating_system_serve", -- What type of space does the heating unit serve? [e.g., Multiple Units in Building-Swimming Pool]
    "when_was_hvac_cooling_system_last_serviced", -- Year HVAC cooling system was last serviced by an HVAC professional [e.g., 1980-2014]
    "does_the_hvac_heating_system_have_an_outdoor_reset", -- Does the HVAC Heating System Have an Outdoor Reset? [e.g., No-Yes]
    "electronically_commutated_motor_present", -- Presence of a electronically commutated motor on the HVAC heating unit [e.g., No-Yes]
    "location_of_hvac_heating", -- Type of location Heating unit is located in [e.g., Conditioned-Unconditioned]
    "unit_in_conditioned_or_unconditioned_part_of_house", -- United located in conditioned or unconditioned part of house [e.g., Conditioned-Unconditioned]
    "no_other_light_bulbs", -- Number of other light bulbs [e.g., 0-150]
    "no_efficient_light_bulbs", -- Number of efficient light bulbs [e.g., 0 – 150]
    "type_of_lighting_controls", -- Type of installed lighting controls  [e.g., Camera - Timer]
    "no_hvac_ventilation_operating_hours_per_day", -- Number of hours per day HVAC ventilation system is run [e.g., <1-24]
    "hvac_ventilation_system_configuration", -- Type of air flow created by HVAC ventilation system [e.g., Balanced-Supply]
    "hvac_ventilation_space_served", -- Type of site served by HVAC ventilation system [e.g., MF Unit-SF]
    "hvac_system_type", -- Type of HVAC system installed
    "hvac_ventilation_type", -- Room served by HVAC system [e.g., Active Radon System-Whole House]
    "type_of_solar_technology_used_for_dhw", -- Type of technology used for the DHW solar system [e.g., Evacuated Tubes – Flat Plate]
    "type_of_solar_dhw_system", -- Type of DHW solar system installed [e.g., Closed – Open]
    "ceiling_type", -- Quality of insulation found by the attic access [e.g., Fair-Poor]
    "depth_below_grade", -- Building depth below grade measured in feet [e.g., 0 - 13] 
    "attic_access_sq_ft", -- Square feet of attic access [e.g., 1-40]
    "attic_access_insulation_level", -- Type of Ceiling [e.g., Cathedral - Vented Attic]
    "data_source_for_the_on_site_inspector_determining_exterior_or_c", -- Data source that the on-site inspector used to determine the exterior or continuous insulation characteristics [e.g., Educated Guess-Reported]
    "exterior_or_continuous_insulation_quality_grade_i_iii", -- Quality of exterior or continuous insulation [e.g., Grade I-Sub Grade III]
    "exterior_or_continuous_insulation_thickness_inches", -- Thickness of exterior or continuous insulation measured in inches [e.g., .25 - 12]
    "data_source_for_the_on_site_inspector_determining_interior_or_c", -- Data source that the on-site inspector used to determine the  interior or cavity insulation characteristics [e.g., Educated Guess-Reported]
    "does_the_home_have_perimeter_insulation", -- Presence of perimeter insulation [e.g., No-Yes]
    "number_of_doors" -- Number of doors identified during on-site visit [e.g., 1 – 14]
FROM
    "ny-gov/rsbs-single-family-onsite-inspections-measure-c8sd-bzeb:latest"."rsbs_single_family_onsite_inspections_measure"
LIMIT 100;

sgr clone ny-gov/rsbs-single-family-onsite-inspections-measure-c8sd-bzeb

sgr checkout ny-gov/rsbs-single-family-onsite-inspections-measure-c8sd-bzeb:latest

sgr checkout --layered ny-gov/rsbs-single-family-onsite-inspections-measure-c8sd-bzeb:latest