Dangerous Buildings List

Updated daily. Dangerous Buildings cases are evaluated in accordance with building code standards to determine if they are a candidate for demolition. Private owners are generally given at least 30 days to conduct work to repair or demolish their property before the City will take action. The more severe the damage, the shorter the timeline the property owner has to avoid City action, which can include municipal court summons, fines, and demolition by City contractors (the cost of which is then assessed against the property owner).

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 \"kcmo/dangerous-buildings-list-ax3m-jhxx\".\"dangerous_buildings_list\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.