CDPH Asbestos and Demolition Notification
CDPH Asbetos and Demolition Notification
Notices of Intent (NOI) for demolition and asbestos abatement per Chapter 11 -4 Article XVIII of the Municipal Code ( see http://tinyurl.com/crvyb29) submitted to the Department of Environment (DOE) for work started January, 1993 to December 31, 2011 or submitted to the Department of Public Health (CDPH) for work beginning on or after January 1, 2012. On January 1, 2012, the DOE was disbanded and all its inspection, permitting, and enforcement authorities were transferred to the CDPH.
Data fields requiring description are detailed below.
NOTIFICATION TYPE: Specifies the type of NOI submitted: NOI DEMO/RENOVATIONion or NOI NESHAP (National Emission Standards for Hazardous Air Pollutants).
MAPPED LOCATION: Contains latitude/longitude coordinates of the site as determined through the Chicago Open Data Portal’s geocoding engine. In instances where the facility address is a range, the lower number (the value in the “Street Number From” column) is used for geocoding. For example, for the range address 1000-1005 S Wabash Ave, the Mapped Location would be the coordinates for 1000 S Wabash Ave.
OWNER/APPLICANT: The owner or entity that submitted the NOI.
START DATE: The proposed start date of work as reported in the NOI.
END DATE: The proposed finish date of work as reported in the NOI.
COMMENT: Additional information relating to the NOI that may include location information, property description, actual start and finish dates, field observations, and status of work.
DATA SOURCE: The city department that collected the data.
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 \"cityofchicago/cdph-asbestos-and-demolition-notification-qhb4-qx8k\".\"cdph_asbestos_and_demolition_notification\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.