Icon for Socrata external plugin
Open repository in Console
Updated 4 days ago
Indexed 1 hour 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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/buildings-selected-for-the-underlying-conditions-xpbf-ithr\".\"buildings_selected_for_the_underlying_conditions\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • buildings_selected_for_the_underlying_conditions
Upstream Metadata