Buildings Selected for the Alternative Enforcement Program (AEP)

Each year, the Department of Housing Preservation and Development (HPD) designates severely distressed multiple dwellings for participation in the Alternative Enforcement Program (AEP). HPD is required by law to submit and post an annual summary report of all AEP buildings. This dataset includes all buildings selected for participation in the AEP and the current status of the building in the program.

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-alternative-enforcement-hcir-3275\".\"buildings_selected_for_the_alternative_enforcement\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.