About this Dataset

CDPH Environmental Permits

Permits issued by the Department of Environment (DOE) from January 1993 to December 31, 2011 and by the Department of Public Health (CDPH) since January 1, 2012. This dataset also includes tank permits issued by CDPH on behalf of the Office of the Illinois State Fire Marshall (OSFM). 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:02.109681
Tags: environmental-health, environmental-permits

Tables

Table 1

@usgov.city_of_chicago_cdph_environmental_permits.table_1

7.63 MB
65948 rows
19 columns


CREATE TABLE table_1 (
  "application_id" VARCHAR,
  "application_name" VARCHAR,
  "address" VARCHAR,
  "street_number_from" DOUBLE,
  "street_number_to" DOUBLE,
  "direction" VARCHAR,
  "street_name" VARCHAR,
  "street_type" VARCHAR,
  "application_type" VARCHAR,
  "application_subtype" VARCHAR,
  "status" VARCHAR,
  "applicant" VARCHAR,
  "issue_date" TIMESTAMP,
  "expiration_date" TIMESTAMP,
  "comment" VARCHAR,
  "data_source" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);