cityofnewyork-us/buildings-selected-for-the-underlying-conditions-xpbf-ithr
Icon for Socrata external plugin
 
Readme
Updated 17 days ago
Indexed 2 hours ago

Buildings Selected for the Underlying Conditions Program

Each year, the Department of Housing Preservation and Development (HPD) designates buildings for participation in the Underlying Conditions Program (Local Law 6 of 2013). These buildings are selected based on the number and severity of class "B" and "C" violations related to the presence of mold or water leaks issued by HPD within the past year and an inspection is attempted to verify conditions before the order is issued.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/buildings-selected-for-the-underlying-conditions-xpbf-ithr\".\"buildings_selected_for_the_underlying_conditions\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • buildings_selected_for_the_underlying_conditions
     
Upstream Metadata