BlightStatus Demolitions

Blighted structures that have been demolished since the inception of BlightStat on October 1, 2010. BlightStat is a public meeting that tracks the City's progress in meeting Mayor Landrieu's stated goal of eliminating 10,000 blighted New Orleans properties in three years. Scheduled update: QuarterlyIn February 2014, the City made several changes to the dataset involving data cleaning and de-duplication. This process entailed adding demolition start and completion dates to demolitions, cleaning and verifying the addresses of demolitions, and removing duplicate cases based on their GeoPIN. The data set still includes several cases with duplicated GeoPINs, where multiple units were demolished on the same parcel.Acronyms used in the dataset:Federal Emergency Management Agency (FEMA)Imminent Danger of Collapse (IDC)New Orleans Redevelopment Authority (NORA)Strategic Demolition for Economic Recovery (SDER) also known asNew Orleans Strategic Demo (NOSD)Louisiana Land Trust (LLT) UPDATED: 9/13/17

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 \"nola-gov/blightstatus-demolitions-e3wd-h7q2\".\"blightstatus_demolitions\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.