Query the Data Delivery Network
Query the DDNThe easiest way to query any data on Splitgraph is via the "Data Delivery Network" (DDN). The DDN is a single endpoint that speaks the PostgreSQL wire protocol. Any Splitgraph user can connect to it at data.splitgraph.com:5432 and query any version of over 40,000 datasets that are hosted or proxied by Splitgraph.
For example, you can query the rsbs_mom_part_1_of_2_new_york_state_residential table in this repository, by referencing it like:
"ny-gov/rsbs-mom-part-1-of-2-new-york-state-residential-e58s-chjh:latest"."rsbs_mom_part_1_of_2_new_york_state_residential"or in a full query, like:
SELECT
":id", -- Socrata column ID
"job_title", -- Job title of the respondent corresponding to position at that location or with the company that manages the property [Owner of property; President / Vice president]
"future_renovations_building", -- Planned renovations in the next five years to include major renovations to the building if "Major Renovations Next Five Years" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"future_renovations_other", -- Planned renovations in the next five years to include some other type of renovation if "Major Renovations Next Five Years" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"future_renovations_common_area", -- Planned renovations in the next five years to include adding to the common space area if "Major Renovations Next Five Years" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"number_of_stories_of_average_building", -- Number of stories within the building or average number of stories within the buildings (not counting the basements) at this particular multifamily property [1-75; Don't know; Refused]
"percentage_t12s_outdoor_common_space", -- Percent of lights used within total general outdoor common spaces at the multifamily property lit by T12s [0-100%; Don't know; Refused]
"common_area_buildings_office", -- Rental office within common area building if "Common Area Buildings" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"timers", -- Use of timers to control lighting within indoor common areas at the multifamily property [Not mentioned; Mentioned; Don't know]
"future_renovations_lighting", -- Planned renovations in the next five years to include lighting upgrades if "Major Renovations Next Five Years" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"percentage_t8s_outdoor_common_space", -- Percent of lights used within total general outdoor common spaces at the multifamily property lit by T8s [0-100%; Don't know; Refused]
"percentage_high_intensity_discharge_lamps_indoor_common_space", -- Percent of lights used within total general indoor common spaces at the multifamily property lit high intensity discharge lamps such as high pressure sodium, metal halide or mercury vapor [0-100%; Don't know; Refused]
"percentage_halogen_bulbs_indoor_common_space", -- Percent of lights used within total general indoor common spaces at the multifamily property lit by halogen bulbs [0-100%; Don't know; Refused]
"percentage_cfls_indoor_common_space", -- Percent of lights used within total general indoor common spaces at the multifamily property lit by compact fluorescent light or CFL bulbs [0-100%; Don't know; Refused]
"percentage_t5s_indoor_common_space", -- Percent of lights used within total general indoor common spaces at the multifamily property lit by T5s [0-100%; Don't know; Refused]
"percentage_t8s_indoor_common_space", -- Percent of lights used within total general indoor common spaces at the multifamily property lit by T8s [0-100%; Don't know; Refused]
"percentage_t12s_indoor_common_space", -- Percent of lights used within total general indoor common spaces at the multifamily property lit by T12s [0-100%; Don't know; Refused]
"percentage_incandescent_light_bulbs_indoor_common_space", -- Percent of lights used within total general indoor common spaces at the multifamily property lit by incandescent light bulbs [0-100%; Don't know; Refused]
"average_age_of_stove", -- Average age of majority of stoves provided to tenants if "Supplied to Tenant - Stove" is "Mentioned" [Less than 2 years old; 2 to 4 years old; 5 to 9 years old; 10 to 14 years old; 15 to 19 years old; 20 years old or more; Don’t know; Programmed skip]
"majority_energy_star_fridge", -- ENERGY STAR® status of the majority of refrigerators provided to tenants if "Supplied to Tenant - Fridge" is "Yes" and "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Average Age of Fridge" is "Less than 2 years old," "2 to 4 years old," or "5 to 9 years old" [Yes; No; Don't know; Programmed skip]
"average_age_of_fridge", -- Average age of majority of refrigerators provided to tenants if "Supplied to Tenant - Fridge" is "Mentioned" [Less than 2 years old; 2 to 4 years old; 5 to 9 years old; 10 to 14 years old; 15 to 19 years old; 20 years old or more; Don’t know; Programmed skip]
"supplied_to_tenant_none", -- Tenant not supplied with any appliances in their living units at the multifamily property [Not mentioned; Mentioned]
"supplied_to_tenant_unit_water_heater", -- Tenant supplied with in-unit water heater in their living units at the multifamily property [Not mentioned; Mentioned]
"supplied_to_tenant_unit_clothes_dryer", -- Tenant supplied with in-unit clothes dryer in their living units at the multifamily property [Not mentioned; Mentioned]
"supplied_to_tenant_unit_clothes_washer", -- Tenant supplied with in-unit clothes washer in their living units at the multifamily property [Not mentioned; Mentioned]
"supplied_to_tenant_space_heater", -- Tenant supplied with portable space heater in their living units at the multifamily property [Not mentioned; Mentioned]
"supplied_to_tenant_microwave", -- Tenant supplied with microwave in their living units at the multifamily property [Not mentioned; Mentioned]
"supplied_to_tenant_dishwasher", -- Tenant supplied with dishwasher in their living units at the multifamily property [Not mentioned; Mentioned]
"supplied_to_tenant_stove", -- Tenant supplied with stove in their living units at the multifamily property [Not mentioned; Mentioned]
"supplied_to_tenant_fridge", -- Tenant supplied with refrigerator in their living units at the multifamily property [Not mentioned; Mentioned]
"age_of_water_heating_system", -- Age of primary water heating system if "Central Domestic Water Heater" is "Yes" [Less than 2 years old; 2 to 4 years old; 5 to 9 years old; 10 to 14 years old; 15 to 19 years old; 20 years old or more; Don’t know; Programmed skip]
"central_domestic_hot_water", -- Presence of central system that provides domestic hot water to multiple living units [Yes; No; Don't know]
"tune_up_of_cooling_system", -- Annual tune-up of air conditioning system or systems if "Central or Individual Cooling System" is not "No air conditioning provided" [Yes; No; Don't know; Programmed skip]
"energy_star_cooling_system", -- ENERGY STAR® status of primary cooling system if "Central or Individual Cooling System" is not "No air conditioning provided" and "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Age of Cooling System" is "Less than 2 years old," "2 to 4 years old," or "5 to 9 years old" [Yes; No; Don't know; Programmed skip]
"age_of_cooling_system", -- Age of central cooling system or age of majority of the cooling systems in each unit of the multifamily property if "Central or Individual Cooling System" is not "No air conditioning provided" [Less than 2 years old; 2 to 4 years old; 5 to 9 years old; 10 to 14 years old; 15 to 19 years old; 20 years old or more; Don’t know; Programmed skip]
"central_or_individual_cooling_system", -- Central system providing cooling to multiple living units, individual heating system in each unit, or air conditioning not provided at the multifamily property [Central cooling system; Individual in-unit cooling system; No air conditioning provided]
"central_boiler_type", -- Steam or hot water central boiler if "Primary Heating System" is "Central boiler with radiators or pipes in each room [e.g., Steam/H2O]]" [Hot water; Steam; Don't know; Interviewer mistake; Programmed skip]
"primary_heating_system", -- Primary type of heating system used at this multifamily property [Baseboard heat; Central boiler with radiators or pipes in each room; District steam with ducts to individual rooms; Forced air furnace with ducts to individual rooms; Other; Don't know]
"central_or_individual_heating_system", -- Central system providing heating to multiple living units or individual heating system in each unit [Central heating system; Each unit has its own heating system]
"percentage_3_bedroom", -- Percentage of livings units that are three or more bedroom units at the building or buildings that comprise this property [0-100%; Don't know; Refused]
"percentage_2_bedroom", -- Percentage of livings units that are two bedroom units at the building or buildings that comprise this property [0-100%; Don't know; Refused]
"percentage_1_bedroom", -- Percentage of livings units that are one bedroom units at the building or buildings that comprise this property [0-100%; Don't know; Refused]
"percentage_studios", -- Percentage of livings units that are studios at the building or buildings that comprise this property [0-100%; Don' know; Refused]
"no_lighting_control_method_above", -- No lighting controls present within indoor common areas at the multifamily property [Not mentioned; Mentioned; Don't know]
"occupancy_motion_sensors", -- Use of occupancy/motion sensors to control lighting within indoor common areas at the multifamily property [Not mentioned; Mentioned; Don't know]
"dimmer_switch", -- Use of dimmer switches to control lighting within indoor common areas at the multifamily property [Not mentioned; Mentioned; Don't know]
"no_natural_lighting_method_above", -- No natural lighting present within indoor common areas at the multifamily property [Not mentioned; Mentioned]
"large_uncovered_windows", -- Presence of large uncovered window areas for natural lighting within indoor common areas at the multifamily property [Not mentioned; Mentioned]
"tubular_skylights", -- Presence of tubular skylights that let daylight in through the roof for natural lighting within indoor common areas at the multifamily property [Not mentioned; Mentioned]
"skylights", -- Presence of skylights for natural lighting within indoor common areas at the multifamily property [Not mentioned; Mentioned]
"cooking_fuel_type", -- Primary fuel type used for cooking at the multifamily property [Electricity; Natural gas; Propane; Other; Don't know]
"major_renovations_next_five_years", -- Planned renovations in the next five years. Renovations could include adding multifamily buildings or units, adding additional common area space, installing new systems, or reconstruction due to flooding or hurricane [Yes; No; Don't know]
"past_renovations_lighting", -- Renovations in the past five years included lighting upgrades if "Major Renovations Past Five Years" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"past_renovations_other", -- Renovations in the past five years included some other type of renovation if "Major Renovations Past Five Years" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"major_renovations_past_five_years", -- Whether or not the property has undergone any major renovations, remodels, or additions in the past five years. Examples could include adding more multifamily buildings or units, adding additional common area space, installing new systems, or reconstruction due to flooding or hurricane [Yes; No; Don't know]
"majority_energy_star_water_heater", -- water heaters provided to tenants if "Supplied to Tenant - Unit Water Heater" is "Yes" and "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Average Age of Unit Water Heater" is "Less than 2 years old," "2 to 4 years old," or "5 to 9 years old" [Yes; No; Don't know; Programmed skip]
"common_area_buildings_garage", -- Garage as part of common area if "Common Area Buildings" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"common_area_buildings_boiler", -- Boiler room within common area building if "Common Area Buildings" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"common_area_buildings_community", -- Community center within common area building if "Common Area Buildings" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"common_area_buildings_maintenance", -- Maintenance equipment shed as part of common area if "Common Area Buildings" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"common_area_buildings_laundry", -- Laundry within common area building if "Common Area Buildings" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"common_area_buildings_club_house", -- Club house within common area building if "Common Area Buildings" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"common_area_buildings_gym", -- Gym or exercise room within common area building if "Common Area Buildings" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"common_area_buildings", -- Presence of any other enclosed buildings that are used for common area purposed such as utility shed, pool house, or community center at this multifamily property [Y/N]
"percentage_occupied_units", -- Percentage of the units at the property that are occupied [0-100%; Don't know; Refused]
"percentage_floor_space_non_residential", -- Percentage of total floor space that is non-residential business space if "Other Business Present" is "Yes" [1-100%; Don't know; Programmed skip]
"average_age_of_unit_water_heater", -- Average age of majority of in-unit water heaters provided to tenants if "Supplied to Tenant - Unit Water Heater" is "Mentioned" [Less than 2 years old; 2 to 4 years old; 5 to 9 years old; 10 to 14 years old; 15 to 19 years old; 20 years old or more; Don’t know; Programmed skip]
"other_business_other", -- Other business at location if "Other Business Present" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"other_business_education", -- Education business at location if "Other Business Present" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"other_business_retail", -- Retail business at location if "Other Business Present" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"other_business_present", -- Presence of any shops, restaurants, retail space, or other business space at within the building or buildings at this particular multifamily property [Yes; No]
"other_nys_properties_built_after_january_2012", -- Other properties built since January 2012 if "Other NYS Properties" is "Yes" [Yes; No; Don't know; Programmed skip; Refused]
"number_of_other_nys_properties", -- Number of other properties the organization owns or manages in New York State if "Other NYS Properties" is "Yes" [1 - 2000; Don't know; Programmed skip; Refused]
"majority_energy_star_unit_clothes_dryer", -- ENERGY STAR® status of the majority of in-unit clothes dryers provided to tenants if "Supplied to Tenant - Unit Clothes Dryer" is "Yes" and "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Average Age of Unit Clothes Dryer" is "Less than 2 years old," "2 to 4 years old," or "5 to 9 years old" [Yes; No; Don't know; Programmed skip]
"average_age_of_unit_clothes_dryer", -- Average age of majority of in-unit clothes dryers provided to tenants if "Supplied to Tenant - Unit Clothes Dryer" is "Mentioned" [Less than 2 years old; 2 to 4 years old; 5 to 9 years old; 10 to 14 years old; 15 to 19 years old; 20 years old or more; Don’t know; Programmed skip]
"other_nys_properties", -- Ownership or management of other properties in New York State [Yes; No; Don't know]
"range_of_units_in_building", -- Range of units within the building [[1-4 units; 5 or more units; Programming change]
"organization_s_years_of_property_management", -- Number of years the organization has been in the business of owning, managing, or maintaining multifamily properties [0-750; Don't know; Refused]
"confirm_multifamily_unit", -- Confirmation that property surveyed is a multifamily unit [Yes; Programmed skip; Programming change]
"recruitment", -- Flag indicating if respondent was recruited for onsite scheduling [Not recruited; Recruited]
"construction_type", -- Flag indicating construction type [Existing; New]
"region", -- Region in New York [Capital District - Western New York]
"majority_energy_star_unit_clothes_washer", -- ENERGY STAR® status of the majority of in-unit clothes washers provided to tenants if "Supplied to Tenant - Unit Clothes Washer" is "Yes" and "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Average Age of Unit Clothes Washer" is "Less than 2 years old," "2 to 4 years old," or "5 to 9 years old" [Yes; No; Don't know; Programmed skip]
"average_age_of_unit_clothes_washer", -- Average age of majority of in-unit clothes washers provided to tenants if "Supplied to Tenant - Unit Clothes Washer" is "Mentioned" [Less than 2 years old; 2 to 4 years old; 5 to 9 years old; 10 to 14 years old; 15 to 19 years old; 20 years old or more; Don’t know; Programmed skip]
"majority_energy_star_space_heater", -- ENERGY STAR® status of the majority of portable space heaters provided to tenants if "Supplied to Tenant - Space Heater" is "Yes" and "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Average Age of Space Heater" is "Less than 2 years old," "2 to 4 years old," or "5 to 9 years old" [Yes; No; Don't know; Programmed skip]
"gas_utility", -- Gas utility of the single family case from which multifamily data originated [e.g., Ambit New York ; Rochester Gas & Electric Corporation]
"electric_utility", -- Electric utility [Central Hudson; ConEd; LIPA; National Grid; NYSEG; RG&E]
"majority_energy_star_dishwasher", -- ENERGY STAR® status of the majority of dishwashers provided to tenants if "Supplied to Tenant - Dishwasher" is "Yes" and "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Average Age of Dishwasher" is "Less than 2 years old," "2 to 4 years old," or "5 to 9 years old" [Yes; No; Don't know; Programmed skip]
"spa_heater_fuel_type", -- Type of fuel used to heat residents' hot tub, spa, or Jacuzzi if "Spa in Common Area" is "Yes" [e.g., Electricity; Some other fuel; Programmed skip]
"spa_in_common_area", -- Presence of hot tub, spa, or Jacuzzi in the common areas of the multifamily property for the residents' use [Yes; No]
"swimming_pool_heater_fuel_type", -- Type of fuel used to heat residents' filtered swimming pool if "Filtered Swimming Pool with Heater in Common Area" is "Yes" [e.g., Electricity - Some other fuel [Electricity; Natural gas; Don't know; Programmed skip]
"filtered_swimming_pool_with_heater_in_common_area", -- Use of heater with residents' filtered swimming pool if "Filtered Swimming Pool in Common Area" is "Yes" [Yes; No; Don't know; Programmed skip]
"filtered_swimming_pool_with_automatic_timer_in_common_area", -- Use of automatic timer to control the time of day that the pool pump operates the residents' filtered swimming pool if " "Filtered Swimming Pool with Pump in Common Area" is "Yes" [Yes; No; Don't know; Programmed skip]
"filtered_swimming_pool_with_high_efficiency_pump_in_common_area", -- Use of high efficiency pool pump with residents' filtered swimming pool if "Filtered Swimming Pool with Pump in Common Area" is "Yes" [Yes; No; Don't know; Programmed skip]
"number_of_exercise_machines_using_electricity", -- Number of exercise machines using electricity in the gym or exercise room of the common area of the multifamily property if "Gym in Common Area" is "Yes" [0-75; Don't know; Programmed skip]
"gym_in_common_area", -- Presence of a gym or exercise room in the common areas of the multifamily property [Yes; No]
"kitchen_in_common_area", -- Presence of kitchen in the common areas of the multifamily property [Yes; No]
"percentage_high_intensity_discharge_lamps_outdoor_common_space", -- Percent of lights used within total general outdoor common spaces at the multifamily property lit high intensity discharge lamps such as high pressure sodium, metal halide or mercury vapor [0-100%; Don't know; Refused]
"percentage_t5s_outdoor_common_space", -- Percent of lights used within total general outdoor common spaces at the multifamily property lit by T5s [0-100%; Don't know; Refused]
"percentage_incandescent_light_bulbs_outdoor_common_space", -- Percent of lights used within total general outdoor common spaces at the multifamily property lit by incandescent light bulbs [0-100%; Don't know; Refused]
"energy_star_water_heating_system", -- ENERGY STAR® status of water heating system "Central Domestic Hot Water" is "Yes" and "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Age of Water Heating System" is "Less than 2 years old," "2 to 4 years old," or "5 to 9 years old" [Yes; No; Don't know; Programmed skip]
"water_heating_system_type", -- Type of primary water heating system used at this property if "Central Domestic Hot Water" is "Yes" [Heat pump; Part of heating system boiler; Stand-alone storage tank; Tankless or on-demand; Other; Don't know; Programmed skip]
"natural_gas_service", -- Natural gas service at the property [Yes; No; Don't know]
"future_renovations_hvac", -- Planned renovations in the next five years to include adding new systems such as central AC, heating, and water heating if "Major Renovations Next Five Years" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"future_renovations_units", -- Planned renovations in the next five years to include increasing the number of units if "Major Renovations Next Five Years" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"past_renovations_hvac", -- Renovations in the past five years included adding new systems such as central AC, heating, and water heating if "Major Renovations Past Five Years" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"past_renovations_storm_damage", -- Renovations in the past five years included reconstruction due to flooding or hurricane damage if "Major Renovations Past Five Years" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"past_renovations_units", -- Renovations in the past five years included increasing the number of units if "Major Renovations Past Five Years" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"year_built", -- Year or year category in which this particular multifamily property was built [1939 or before; 1940 to 1949; 1950 to 1959; 1960 to 1969; 1970 to 1979; 1980 to 1989; 1990 to 1999; 2000 to 2009; 2010; 2011; 2012; Don't know]
"number_of_common_area_buildings", -- Number of common area buildings if "Common Area Buildings" is "Yes" [e.g., 1-75; Programmed skip]
"other_business_health", -- Health care business at location if "Other Business Present" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"other_business_food", -- Food sales or service business at location if "Other Business Present" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"other_business_professional", -- Office/professional business at location if "Other Business Present" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"county", -- County in New York where the survey respondent's home is located [Albany - Yates]
"percentage_cfls_outdoor_common_space", -- Percent of lights used within total general outdoor common spaces at the multifamily property lit by compact fluorescent light or CFL bulbs [0-100%; Don't know; Refused]
"number_of_living_units", -- Number of living units within the building or buildings at this particular multifamily property [1-8,500]
"number_of_separate_buildings", -- Number of separate multifamily buildings located at the multifamily property [1 - 100]
"percentage_halogen_bulbs_outdoor_common_space", -- Percent of lights used within total general outdoor common spaces at the multifamily property lit by halogen bulbs [0-100%; Don't know; Refused]
"number_of_stoves_in_common_area", -- Number of stoves in common areas of the multifamily property if "Kitchen in Common Area" is "Yes" [0-75; Don't know; Programmed skip]
"age_of_heating_system", -- Age of central heating system or age of majority of the heating systems in each unit of the multifamily property [Less than 2 years old; 2 to 4 years old; 5 to 9 years old; 10 to 14 years old; 15 to 19 years old; 20 years old or more; Don’t know]
"tune_up_of_heating_system", -- Annual tune-up of heating system or systems either by a heating contractor or survey respondent [Yes, do it myself; Yes, done by a heating contractor; No; Don't know]
"number_of_microwaves_in_common_area", -- Number of refrigerators in common areas of the multifamily property if "Kitchen in Common Area" is "Yes" [0-75; Don't know; Programmed skip]
"number_of_fridges_in_common_area", -- Number of refrigerators in common areas of the multifamily property if "Kitchen in Common Area" is "Yes" [0-75; Don't know; Programmed skip]
"primary_heating_fuel", -- Primary type of heating fuel used at this multifamily property [Electricity; District steam; Natural gas; Fuel oil; Other; Don't know]
"average_age_of_dishwasher", -- Average age of majority of dishwashers provided to tenants if "Supplied to Tenant - Dishwasher" is "Mentioned" [Less than 2 years old; 2 to 4 years old; 5 to 9 years old; 10 to 14 years old; 15 to 19 years old; 20 years old or more; Don’t know; Programmed skip]
"majority_energy_star_stove", -- ENERGY STAR® status of the majority of stoves provided to tenants if "Supplied to Tenant - Stove" is "Yes" and "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Average Age of Stove" is "Less than 2 years old," "2 to 4 years old," or "5 to 9 years old" [Yes; No; Don't know; Programmed skip]
"number_of_electric_fireplaces_in_common_area", -- Number of electric fireplaces in the common areas of the multifamily property if "Fireplaces in Common Area" is "Yes" [0-75; Don't know; Programmed skip]
"number_of_gas_fireplaces_in_common_area", -- Number of gas fireplaces in the common areas of the multifamily property if "Fireplaces in Common Area" is "Yes" [0-75; Don't know; Programmed skip]
"number_of_wood_fireplaces_in_common_area", -- Number of wood fireplaces in the common areas of the multifamily property if "Fireplaces in Common Area" is "Yes" [0-75; Don't know; Programmed skip]
"unique_case_id", -- Unique case identifier for the multifamily study [1-376]
"outdoor_lighting_for_parking", -- Use of outdoor lighting at the multifamily property for parking [Not mentioned; Mentioned; Don't know; Programmed skip; Refused]
"common_area_buildings_storage", -- Storage units within common area building if "Common Area Buildings" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"percentage_led_bulbs_indoor_common_space", -- Percent of lights used within total general indoor common spaces at the multifamily property lit by LED bulbs [0-100%; Don't know; Refused]
"fireplaces_in_common_area", -- Presence of fireplaces in the common areas of the multifamily property [Yes; No; Don't know]
"number_of_smart_strips_in_common_area", -- Number of smart strips, power strips with sensors to save electricity, in the common areas of the multifamily property if "TVs in Common Area" is "Yes" [0-75; Don't know; Programmed skip]
"number_of_gaming_systems_in_common_area", -- Number of video gaming systems (e.g. PS3, PlayStation, Nintendo, XBOX, Wii) in the common areas of the multifamily property if "TVs in Common Area" is "Yes" [0-75; Don't know; Programmed skip]
"filtered_swimming_pool_with_pump_in_common_area", -- Use of a pool pump with residents' filtered swimming pool if "Filtered Swimming Pool in Common Area" is "Yes" [Yes; No; Don't know; Programmed skip]
"past_renovations_common_area", -- Renovations in the past five years included adding to the common space area if "Major Renovations Past Five Years" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"filtered_swimming_pool_in_common_area", -- Presence of a swimming pool with a filtering system in the common area of the multifamily property for the residents' use [Yes; No; Don't know; Programmed skip]
"number_of_digital_converter_boxes_in_common_area", -- Number of digital TV converter boxes in the common areas of the multifamily property if "TVs in Common Area" is "Yes" [0-75; Don't know; Programmed skip]
"percentage_other_indoor_common_space", -- Percent of lights used within total general indoor common spaces at the multifamily property lit by something else or another type of bulb [0-100%; Don't know; Refused]
"number_of_vcr_in_common_area", -- Number of VCRs in the common areas of the multifamily property if "TVs in Common Area" is "Yes" [0-75; Don't know; Programmed skip]
"number_of_dvd_blu_ray_in_common_area", -- Number of DVD or Blu-Ray players in the common areas of the multifamily property if "TVs in Common Area" is "Yes" [0-75; Don't know; Programmed skip]
"number_of_dvrs_in_common_area", -- Number of DVRs (e.g. TiVo) in the common areas of the multifamily property if "TVs in Common Area" is "Yes" [0-75; Don't know; Programmed skip]
"number_of_tv_boxes_in_common_area", -- Number of cable, satellite, or set-top boxes in the common areas of the multifamily property if "TVs in Common Area" is "Yes" [0-75; Don't know; Programmed skip]
"number_of_lcd_led_tvs_in_common_area", -- Number of flat screen LCD/LED TVs in the common areas of the multifamily property if "TVs in Common Area" is "Yes" [0-75; Don't know; Programmed skip]
"number_of_plasma_tvs_in_common_area", -- Number of flat screen plasma TVs in the common areas of the multifamily property if "TVs in Common Area" is "Yes" [0-75; Don't know; Programmed skip]
"number_of_standard_tube_tvs_in_common_area", -- Number of standard tube TVs in the common areas of the multifamily property if "TVs in Common Area" is "Yes" [0-75; Don't know; Programmed skip]
"tvs_in_common_area", -- Presence of TVs in the common areas of the multifamily property [Yes; No]
"outdoor_lighting_for_walkways", -- Use of outdoor lighting at the multi family property for sidewalks or walkways [Not mentioned; Mentioned; Don't know; Programmed skip; Refused]
"other_outdoor_lighting", -- Use of outdoor lighting at the multifamily property for other purposes [Not mentioned; Mentioned; Don't know; Programmed skip; Refused]
"average_age_of_space_heater", -- Average age of majority of portable space heaters provided to tenants if "Supplied to Tenant - Space Heater" is "Mentioned" [Less than 2 years old; 2 to 4 years old; 5 to 9 years old; 10 to 14 years old; 15 to 19 years old; 20 years old or more; Don’t know; Programmed skip]
"climate_zone", -- IECC Climate zone; see https://energycode.pnl.gov/EnergyCodeReqs/?state=New%20York for a map and details for each zone [4-6]
"outdoor_lighting_for_signage", -- Use of outdoor lighting at the multifamily property for outdoor signage [Not mentioned; Mentioned; Don't know; Programmed skip; Refused]
"outdoor_lighting_for_decoration", -- Use of outdoor lighting at the multifamily property for decoration [Not mentioned; Mentioned; Don't know; Programmed skip; Refused]
"percentage_other_outdoor_common_space", -- Percent of lights used within total general outdoor common spaces at the multifamily property lit by something else or another type of bulb [0-100%; Don't know; Refused]
"percentage_led_bulbs_outdoor_common_space", -- Percent of lights used within total general outdoor common spaces at the multifamily property lit by LED bulbs [0-100%; Don't know; Refused]
"common_area_buildings_other", -- Other indoor common area if "Common Area Buildings" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"outdoor_lighting_for_security", -- Use of outdoor lighting at the multifamily property for security lights [Not mentioned; Mentioned; Don't know; Programmed skip; Refused]
"number_of_projection_tvs_in_common_area", -- Number of projection TVs (NOT projectors) in the common areas of the multifamily property if "TVs in Common Area" is "Yes" [0-75; Don't know; Programmed skip]
"majority_energy_star_microwave", -- ENERGY STAR® status of the majority of microwaves provided to tenants if "Supplied to Tenant - Microwave" is "Yes" and "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Average Age of Microwave" is "Less than 2 years old," "2 to 4 years old," or "5 to 9 years old" [Yes; No; Don't know; Programmed skip]
"past_renovations_building", -- Renovations in the past five years included major renovations to the building if "Major Renovations Past Five Years" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"water_heating_fuel_type", -- Primary type of fuel used for water heating at the multifamily property if "Central Domestic Hot Water" is "Yes" [Electricity; District steam; Natural gas; Fuel oil; Other; Don't know; Programmed skip]
"past_renovations_cosmetic", -- Renovations in the past five years included cosmetic upgrades such as paint, carpets, and landscapes if "Major Renovations Past Five Years" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"future_renovations_cosmetic", -- Planned renovations in the next five years to include cosmetic upgrades such as paint, carpets, and landscapes if "Major Renovations Next Five Years" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"energy_star_heating_system", -- ENERGY STAR® status of primary heating system or systems if "Familiarity with Energy Star" is "Somewhat familiar" or "Very familiar" and "Age of Heating System" is "Less than 2 years old," "2 to 4 years old," or "5 to 9 years old" [Yes; No; Don't know; Programmed skip]
"future_renovations_storm_damage", -- Planned renovations in the next five years to include reconstruction due to flooding or hurricane damage if "Major Renovations Next Five Years" is "Yes" [Not mentioned; Mentioned; Programmed skip]
"natural_gas_metering", -- Type of natural gas service metering from the utility for the building or buildings at this property if "Natural Gas Service" is "Yes" [One master meter, no individual tenant unit meters; Individual metered plus separate meters for common area; All individual metered tenant units, no master meter; Other; Don't know; Programmed skip; Refused]
"average_age_of_microwave", -- Average age of majority of microwaves provided to tenants if "Supplied to Tenant - Microwave" is "Mentioned" [Less than 2 years old; 2 to 4 years old; 5 to 9 years old; 10 to 14 years old; 15 to 19 years old; 20 years old or more; Don’t know; Programmed skip]
"electric_metering" -- How the electric service is metered by the utility for this property [All individual metered tenant units, no master meter; Individual metered plus separate meters for common area; Master meter for total building plus sub-meter for individual tenant units; Don't know; Other]
FROM
"ny-gov/rsbs-mom-part-1-of-2-new-york-state-residential-e58s-chjh:latest"."rsbs_mom_part_1_of_2_new_york_state_residential"
LIMIT 100;Connecting to the DDN is easy. All you need is an existing SQL client that can connect to Postgres. As long as you have a SQL client ready, you'll be able to query ny-gov/rsbs-mom-part-1-of-2-new-york-state-residential-e58s-chjh with SQL in under 60 seconds.
Query Your Local Engine
Install Splitgraph Locally
bash -c "$(curl -sL https://github.com/splitgraph/splitgraph/releases/latest/download/install.sh)"Read the installation docs.
Splitgraph Cloud is built around Splitgraph Core (GitHub), which includes a local Splitgraph Engine packaged as a Docker image. Splitgraph Cloud is basically a scaled-up version of that local Engine. When you query the Data Delivery Network or the REST API, we mount the relevant datasets in an Engine on our servers and execute your query on it.
It's possible to run this engine locally. You'll need a Mac, Windows or Linux system to install sgr, and a Docker installation to run the engine. You don't need to know how to actually use Docker; sgrcan manage the image, container and volume for you.
There are a few ways to ingest data into the local engine.
For external repositories, the Splitgraph Engine can "mount" upstream data sources by using sgr mount. This feature is built around Postgres Foreign Data Wrappers (FDW). You can write custom "mount handlers" for any upstream data source. For an example, we blogged about making a custom mount handler for HackerNews stories.
For hosted datasets (like this repository), where the author has pushed Splitgraph Images to the repository, you can "clone" and/or "checkout" the data using sgr cloneand sgr checkout.
Cloning Data
Because ny-gov/rsbs-mom-part-1-of-2-new-york-state-residential-e58s-chjh:latest is a Splitgraph Image, you can clone the data from Spltgraph Cloud to your local engine, where you can query it like any other Postgres database, using any of your existing tools.
First, install Splitgraph if you haven't already.
Clone the metadata with sgr clone
This will be quick, and does not download the actual data.
sgr clone ny-gov/rsbs-mom-part-1-of-2-new-york-state-residential-e58s-chjhCheckout the data
Once you've cloned the data, you need to "checkout" the tag that you want. For example, to checkout the latest tag:
sgr checkout ny-gov/rsbs-mom-part-1-of-2-new-york-state-residential-e58s-chjh:latestThis will download all the objects for the latest tag of ny-gov/rsbs-mom-part-1-of-2-new-york-state-residential-e58s-chjh and load them into the Splitgraph Engine. Depending on your connection speed and the size of the data, you will need to wait for the checkout to complete. Once it's complete, you will be able to query the data like you would any other Postgres database.
Alternatively, use "layered checkout" to avoid downloading all the data
The data in ny-gov/rsbs-mom-part-1-of-2-new-york-state-residential-e58s-chjh:latest is 0 bytes. If this is too big to download all at once, or perhaps you only need to query a subset of it, you can use a layered checkout.:
sgr checkout --layered ny-gov/rsbs-mom-part-1-of-2-new-york-state-residential-e58s-chjh:latestThis will not download all the data, but it will create a schema comprised of foreign tables, that you can query as you would any other data. Splitgraph will lazily download the required objects as you query the data. In some cases, this might be faster or more efficient than a regular checkout.
Read the layered querying documentation to learn about when and why you might want to use layered queries.
Query the data with your existing tools
Once you've loaded the data into your local Splitgraph Engine, you can query it with any of your existing tools. As far as they're concerned, ny-gov/rsbs-mom-part-1-of-2-new-york-state-residential-e58s-chjh is just another Postgres schema.