About this Dataset

CDPH Environmental Asbestos And Demolition Notification

Notices of Intent (NOI) for demolition and asbestos abatement per Chapter 11 -4 Article XVIII of the Municipal Code 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.
Organization: City of Chicago
Last updated: 2020-11-10T16:55:16.271796
Tags: asbestos, environmental-health

Tables

Table 1

@usgov.city_of_chicago_cdph_asbestos_and_demolition_notification.table_1

4.36 MB
64068 rows
16 columns


CREATE TABLE table_1 (
  "application_id" VARCHAR,
  "notification_type" VARCHAR,
  "address" VARCHAR,
  "street_number_from" BIGINT,
  "street_number_to" DOUBLE,
  "direction" VARCHAR,
  "street_name" VARCHAR,
  "street_type" VARCHAR,
  "owner_applicant" VARCHAR,
  "start_date" VARCHAR,
  "end_date" VARCHAR,
  "comment" VARCHAR,
  "data_source" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);