CDPH Storage Tanks

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.

Data fields requiring description are detailed below.

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.

TANK TYPE: Specifies if the asset is an Underground Storage Tank or an Aboveground Storage Tank.

FACILITY ID: This is the unique identifier of the facility. A UST Facility ID that is seven digits long and begins with the number ‘2’ is a Facility ID assigned by the Office of the State Fire Marshall (OSFM). All other IDs were assigned by the DOE or CDPH based on the facility address.

OWNER: The owner of record for the tank. For State-regulated USTs, this is the owner registered with the OSFM.

FACILITY NAME: This is the name given to the facility. This is usually the company/owner name, building name or address.

TANK ID: This is a numeric ID that uniquely identifies a particular tank at the facility.

TANK MATERIAL: Specifies the type of material the tank is made of.

TANK PRODUCT: Specifies the type of product stored in the tank.

TANK CAPACITY: This is the storage volume of the tank in gallons.

INSTALLATION DATE: The date the tank was installed at the facility if known. For some records, this information is in the COMMENTS column.

REMOVAL DATE: The date the tank was removed from the facility if known. For some records, this information is in the COMMENTS column.

LAST USED DATE: The date the tank was last in service if known. For some records, this information is in the COMMENTS column.

COMMENT: Contains additional information on the tank that may include supplemental location information; field observations; removal, abandonment, or last used dates; permitting notes; and other miscellaneous information.

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-storage-tanks-ug5u-hxnx\".\"cdph_storage_tanks\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.