Chicago

Author: cocadmin
Description: 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.
Category: Environment & Sustainable Development
Tags: ust, ast, tanks
Rating: Current value: 0 out of 5
Data Provided By: Department of Public Health
Source Link: http://www.cityofchicago.org/city/en/depts/cdph.html

CDPH Storage TanksThis 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.Visit the full page to view this data.

This view cannot be displayed

Embed this Dataset

      <div><p style="margin-bottom:3px"><a href="https://data.cityofchicago.org/Environment-Sustainable-Development/CDPH-Storage-Tanks/ug5u-hxnx" target="_blank" style="font-size:12px;font-weight:bold;text-decoration:none;color:#333333;font-family:arial;">CDPH Storage Tanks</a></p><iframe width="_width_px" title="CDPH Storage Tanks" height="_height_px" src="https://data.cityofchicago.org/w/ug5u-hxnx/3q3f-6823?cur=DTxz-cgP7wf" frameborder="0"scrolling="no"><a href="https://data.cityofchicago.org/Environment-Sustainable-Development/CDPH-Storage-Tanks/ug5u-hxnx" title="CDPH Storage Tanks" target="_blank">CDPH Storage Tanks</a></iframe><p><a href="http://www.socrata.com/" target="_blank">Powered by Tyler Technologies</a></p></div>

Size

500x425
760x646
950x808

Custom Size

425x425 is the minimum size

Width

Height

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

ADDRESS: address
STREET NUMBER FROM: street_number
STREET NUMBER TO: street_number_to
DIRECTION: direction
STREET NAME: street_name
STREET TYPE: street_type
TANK TYPE: tank_type
FACILITY ID: facility_id
OWNER: applicant
FACILITY NAME: facility
Tank ID: tank_id
TANK MATERIAL: tank_material
TANK CONSTRUCTION: tank_construction
TANK PRODUCT: tank_product
TANK CAPACITY: tank_capacity
INSTALLATION DATE: installation_date
REMOVAL DATE: removal_abandoned_date
LAST USED DATE: last_used_date
COMMENT: comment
DATA SOURCE: data_source
LATITUDE: latitude
LONGITUDE: longitude
LOCATION: location
Boundaries - ZIP Codes: :@computed_region_rpca_8um6
Community Areas: :@computed_region_vrxf_vc4k
Zip Codes: :@computed_region_6mkv_f3dw
Census Tracts: :@computed_region_bdys_3d7i
Wards: :@computed_region_43wa_7qmu

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

Chicago

API Endpoint:

Field Names:

OData V4 Endpoint:

OData V2 Endpoint:

Want to leave a comment?

You are leaving data.cityofchicago.org.

Notice