CDPH Environmental Hold On City-Issued Permits And LUST NFR by US Government | Healthcare

About this Dataset

CDPH Environmental Hold On City-Issued Permits And LUST NFR

This dataset contains environmental holds placed by the Department of Environment (DOE) up to December 31, 2011 and by the Department of Public Health (CDPH) post December 31, 2011 on construction-related permits issued by the City of Chicago. On January 1, 2012, the DOE was disbanded and all its inspection, permitting, and enforcement authorities were transferred to the CDPH. This dataset also contains No Further Remediation Letters (NFRs) received by the DOE or the CDPH for properties that have been cleaned up under the Illinois Environmental Protections Agency’s (IEPA) Leaking Underground Storage Tank (LUST) program. Throrium holds in this dataset ends November 15, 2016.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:27.939581
Tags: environmental-health, highway-authority-agreement, lust, nfr, radiation, thorium

Tables

Table 1

@usgov.city_of_chicago_cdph_environmental_hold_on_city_issued_649a2e22.table_1

215.9 KB
1850 rows
14 columns


CREATE TABLE table_1 (
  "application_id" VARCHAR,
  "address" VARCHAR,
  "street_number_from" BIGINT,
  "street_number_to" DOUBLE,
  "street_direction" VARCHAR,
  "street_name" VARCHAR,
  "street_type" VARCHAR,
  "moratorium_type" VARCHAR,
  "date" TIMESTAMP,
  "comment" VARCHAR,
  "data_source" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);