About this Dataset

CDPH Environmental Storage Tanks

Note: This dataset is no longer being updated. As of 2020, Aboveground Storage Tank data is captured in the CDPH Environmental Permits dataset and Underground Storage Tank data is available from the Office of the Illinois State Fire Marshal. This dataset contains Aboveground Storage Tank (AST) and Underground Storage Tank (UST) information from the Department of Public Health’s (CDPH) Tank Asset Database. The Tank Asset Database contains tank information from CDPH AST and UST permit applications as well as UST records imported from the historic Department of Environment (DOE) database. This dataset also includes AST records from the historic DOE and pre-1992 UST records from the Building Department.
Organization: City of Chicago
Last updated: 2020-11-10T16:55:29.475738
Tags: ast, environmental-health, historical, tanks, ust

Tables

Table 1

@usgov.city_of_chicago_cdph_storage_tanks.table_1

4.39 MB
46,441 rows
23 columns

CREATE TABLE table_1 (
  "address" VARCHAR,
  "street_number_from" BIGINT,
  "street_number_to" DOUBLE,
  "direction" VARCHAR,
  "street_name" VARCHAR,
  "street_type" VARCHAR,
  "tank_type" VARCHAR,
  "facility_id" VARCHAR,
  "owner" VARCHAR,
  "facility_name" VARCHAR,
  "tank_id" VARCHAR,
  "tank_material" VARCHAR,
  "tank_construction" VARCHAR,
  "tank_product" VARCHAR,
  "tank_capacity" VARCHAR,
  "installation_date" TIMESTAMP,
  "removal_date" TIMESTAMP,
  "last_used_date" VARCHAR,
  "comment" VARCHAR,
  "data_source" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);