IEPA Leaking Underground Storage Tank Incident

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.illinois.gov
Id 2kz4-t22j
Name IEPA Leaking Underground Storage Tank Incident
Attribution Illinois Environmental Protection Agency
Category Environment
Created 2011-09-30T14:38:30Z
Publication Date 2011-09-30T15:46:12Z

Description

Data extracted from the Bureau of Land’s Leaking Underground Storage Tank Incident (LIT) Database. The (LIT) database identifies the status of all Illinois Leaking Underground Storage Tank incidents reported to the Illinois Emergency Management Agency and to the Illinois Environmental Protection Agency.

Columns

| Included | Schema Type | Field Name                         | Name                               | Data Type     | Render Type   |
| ======== | =========== | ================================== | ================================== | ============= | ============= |
| Yes      | series tag  | incident                           | INCIDENT                           | text          | text          |
| Yes      | series tag  | lpc_                               | LPC #                              | text          | text          |
| Yes      | time        | iema_date                          | IEMA Date                          | date          | date          |
| Yes      | series tag  | site_name                          | Site Name                          | text          | text          |
| Yes      | series tag  | site_city                          | Site City                          | text          | text          |
| Yes      | series tag  | site_location                      | Site Location                      | text          | text          |
| Yes      | series tag  | site_state                         | Site State                         | text          | text          |
| Yes      | series tag  | site_zip                           | Site Zip                           | text          | text          |
| Yes      | series tag  | site_county                        | Site County                        | text          | text          |
| Yes      | series tag  | primary_responsible_party_name     | Primary Responsible Party Name     | text          | text          |
| No       |             | primary_responsible_party_address  | Primary Responsible Party Address  | text          | text          |
| Yes      | series tag  | primary_responsible_party_city     | Primary Responsible Party City     | text          | text          |
| Yes      | series tag  | primary_responsible_party_state    | Primary Responsible Party State    | text          | text          |
| Yes      | series tag  | primary_responsible_party_zip_code | Primary Responsible Party Zip Code | text          | text          |
| Yes      | series tag  | primary_responsible_party_phone    | Primary Responsible Party Phone    | text          | number        |
| Yes      | series tag  | primary_responsible_party_contact  | Primary Responsible Party Contact  | text          | text          |
| Yes      | series tag  | gasoline                           | Gasoline                           | checkbox      | checkbox      |
| Yes      | series tag  | unleaded                           | UnLeaded                           | checkbox      | checkbox      |
| Yes      | series tag  | diesel                             | Diesel                             | checkbox      | checkbox      |
| Yes      | series tag  | fuel_oil                           | Fuel Oil                           | checkbox      | checkbox      |
| Yes      | series tag  | jet_fuel                           | Jet Fuel                           | checkbox      | checkbox      |
| Yes      | series tag  | used_oil                           | Used Oil                           | checkbox      | checkbox      |
| Yes      | series tag  | non_petroleum_product              | Non-Petroleum Product              | checkbox      | checkbox      |
| Yes      | series tag  | other_petroleum                    | Other Petroleum                    | checkbox      | checkbox      |
| Yes      | series tag  | regulation                         | Regulation                         | text          | text          |
| Yes      | series tag  | project_manager_first_name         | Project Manager First Name         | text          | text          |
| Yes      | series tag  | project_manager_last_name          | Project Manager Last Name          | text          | text          |
| Yes      | series tag  | project_manager_phone              | Project Manager Phone              | text          | text          |
| Yes      | series tag  | project_manager_email              | Project Manager Email              | text          | text          |
| No       |             | non_lust_date                      | Non-Lust Date                      | date          | date          |
| No       |             | day_report_date_1                  | 20 Day Report Date                 | date          | date          |
| No       |             | day_report_date_2                  | 45 Day Report Date                 | date          | date          |
| No       |             | nfr_date                           | NFR Date                           | date          | date          |
| No       |             | nfr_recorded_date                  | NFR Recorded Date                  | date          | date          |
| No       |             | pre_74_date                        | Pre-74 Date                        | date          | date          |
| No       |             | free_product_discovery_date        | Free Product Discovery Date        | date          | date          |
| No       |             | heating_oil_letter_date            | Heating Oil Letter Date            | date          | date          |
| No       |             | non_lust_letter_date               | Non LUST Letter Date               | calendar_date | calendar_date |

Time Field

Value = iema_date
Format & Zone = seconds

Series Fields

Excluded Fields = primary_responsible_party_address,non_lust_date,day_report_date_1,day_report_date_2,nfr_date,nfr_recorded_date,pre_74_date,free_product_discovery_date,heating_oil_letter_date,non_lust_letter_date

Data Commands

series e:2kz4-t22j d:2011-09-30T07:38:33.000Z t:site_city=St.Charles t:non_petroleum_product=false t:site_county=Kane t:other_petroleum=false t:lpc_="* N.A.?*" t:gasoline=false t:jet_fuel=false t:site_name="Borden Chemical" t:diesel=false t:unleaded=false t:regulation=731 t:fuel_oil=false t:project_manager_phone="(217) 557-6937" t:project_manager_first_name=Wayne t:used_oil=false t:project_manager_email=Wayne.Zuehlke@illinois.gov t:project_manager_last_name=Zuehlke t:incident=00000A m:row_number.2kz4-t22j=1

series e:2kz4-t22j d:2000-03-15T08:00:00.000Z t:site_city=Chicago t:non_petroleum_product=false t:site_county=Cook t:other_petroleum=false t:lpc_=0316055017 t:site_state=IL t:gasoline=false t:primary_responsible_party_city=Chicago t:primary_responsible_party_name="George Oshana" t:jet_fuel=false t:site_name="Oshana, George" t:primary_responsible_party_state=IL t:primary_responsible_party_phone=7732940557 t:diesel=false t:site_location="4000 North Western Ave." t:unleaded=false t:regulation=732 t:primary_responsible_party_zip_code=60646 t:fuel_oil=false t:project_manager_phone="(217) 524-5596" t:project_manager_first_name=Matt t:used_oil=true t:project_manager_email=Matt.Urish@illinois.gov t:project_manager_last_name=Urish t:incident=20000449 m:row_number.2kz4-t22j=2

series e:2kz4-t22j d:2000-03-31T08:00:00.000Z t:site_city=Chicago t:non_petroleum_product=false t:site_zip=60644 t:site_county=Cook t:other_petroleum=true t:lpc_=0316255119 t:site_state=IL t:gasoline=false t:primary_responsible_party_city=Chicago t:primary_responsible_party_name="Ebony Affair" t:jet_fuel=false t:site_name="Ebony Affair" t:primary_responsible_party_state=IL t:primary_responsible_party_phone=7739211201 t:diesel=false t:site_location="740 North Cicero Ave." t:unleaded=false t:regulation=732 t:primary_responsible_party_zip_code=60644 t:primary_responsible_party_contact="Fedrick Ballenger" t:fuel_oil=false t:used_oil=false t:project_manager_last_name="NOT ASSIGNED" t:incident=20000569 m:row_number.2kz4-t22j=3

Meta Commands

metric m:row_number.2kz4-t22j p:long l:"Row Number"

entity e:2kz4-t22j l:"IEPA Leaking Underground Storage Tank Incident" t:attribution="Illinois Environmental Protection Agency" t:url=https://data.illinois.gov/api/views/2kz4-t22j

property e:2kz4-t22j t:meta.view v:id=2kz4-t22j v:category=Environment v:attributionLink=http://epadata.epa.state.il.us/land/ust/ v:averageRating=0 v:name="IEPA Leaking Underground Storage Tank Incident" v:attribution="Illinois Environmental Protection Agency"

property e:2kz4-t22j t:meta.view.owner v:id=9gpg-gpch v:screenName=IEPA v:displayName=IEPA

property e:2kz4-t22j t:meta.view.tableauthor v:id=9gpg-gpch v:screenName=IEPA v:roleName=publisher v:displayName=IEPA

Top Records

| incident | lpc_       | iema_date | site_name               | site_city     | site_location            | site_state | site_zip | site_county | primary_responsible_party_name | primary_responsible_party_address | primary_responsible_party_city | primary_responsible_party_state | primary_responsible_party_zip_code | primary_responsible_party_phone | primary_responsible_party_contact | gasoline | unleaded | diesel | fuel_oil | jet_fuel | used_oil | non_petroleum_product | other_petroleum | regulation | project_manager_first_name | project_manager_last_name | project_manager_phone | project_manager_email      | non_lust_date | day_report_date_1 | day_report_date_2 | nfr_date   | nfr_recorded_date | pre_74_date | free_product_discovery_date | heating_oil_letter_date | non_lust_letter_date | 
| ======== | ========== | ========= | ======================= | ============= | ======================== | ========== | ======== | =========== | ============================== | ================================= | ============================== | =============================== | ================================== | =============================== | ================================= | ======== | ======== | ====== | ======== | ======== | ======== | ===================== | =============== | ========== | ========================== | ========================= | ===================== | ========================== | ============= | ================= | ================= | ========== | ================= | =========== | =========================== | ======================= | ==================== | 
| 00000A   | * N.A.?*   |           | Borden Chemical         | St.Charles    |                          |            |          | Kane        |                                |                                   |                                |                                 |                                    |                                 |                                   | false    | false    | false  | false    | false    | false    | false                 | false           | 731        | Wayne                      | Zuehlke                   | (217) 557-6937        | Wayne.Zuehlke@illinois.gov |               |                   |                   |            |                   |             |                             |                         |                      | 
| 20000449 | 0316055017 | 953107200 | Oshana, George          | Chicago       | 4000 North Western Ave.  | IL         |          | Cook        | George Oshana                  | 6050 North Keystone               | Chicago                        | IL                              | 60646                              | 7732940557                      |                                   | false    | false    | false  | false    | false    | true     | false                 | false           | 732        | Matt                       | Urish                     | (217) 524-5596        | Matt.Urish@illinois.gov    |               |                   |                   |            |                   |             |                             |                         |                      | 
| 20000569 | 0316255119 | 954489600 | Ebony Affair            | Chicago       | 740 North Cicero Ave.    | IL         | 60644    | Cook        | Ebony Affair                   | 740 North Cicero Ave.             | Chicago                        | IL                              | 60644                              | 7739211201                      | Fedrick Ballenger                 | false    | false    | false  | false    | false    | false    | false                 | true            | 732        |                            | NOT ASSIGNED              |                       |                            |               |                   |                   |            |                   |             |                             |                         |                      | 
| 20000889 | 0316195243 | 958114800 | A & A Auto Repair, Inc. | Chicago       | 5035 West Grand Ave.     | IL         | 60639    | Cook        | A & A Auto Repair, Inc.        | 2418 North Major St.              | Chicago                        | IL                              | 60639                              | 7732379988                      | Jose Abarca                       | false    | false    | false  | false    | false    | true     | false                 | false           | 732        |                            | NOT ASSIGNED              |                       |                            |               | 959065200         |                   |            |                   |             |                             |                         |                      | 
| 20000906 | 1930105007 | 958374000 | Webb Oil Co., Inc.      | Carmi         | 906 East Main St.        | IL         | 62821    | White       | Webb Oil Co., Inc.             | P.O. Box 247                      | Benton                         | IL                              | 62812                              | 6184382211                      | Bill Gwaltney                     | true     | false    | true   | false    | false    | false    | false                 | false           | 732        | Dawn                       | Ingold                    | (217) 782-6762        |                            |               | 961484400         | 961484400         | 1033023600 | 1035878400        |             |                             |                         |                      | 
| 20000994 | 0316675116 | 959324400 | Piet Pontiac, Inc.      | Chicago       | 6301 South Bell          | IL         | 60636    | Cook        | Piet Pontiac, Inc.             | 12601 Southwest Hwy.              | Palos Park                     | IL                              | 60464                              | 7083611958                      | Tony Piet                         | true     | false    | true   | false    | false    | false    | false                 | false           | 732        |                            | NOT ASSIGNED              |                       |                            |               |                   |                   |            |                   |             |                             |                         |                      | 
| 20001110 | 0316195243 | 960793200 | A & A Auto Repair       | Chicago       | 5035 West Grant Ave.     | IL         | 60639    | Cook        | A & A Auto Repair              | 5035 West Grant Ave.              | Chicago                        | IL                              | 60639                              | 7732379988                      | Jose Abarca                       | true     | false    | false  | false    | false    | false    | false                 | false           | 732        |                            | NOT ASSIGNED              |                       |                            |               |                   |                   |            |                   |             |                             |                         |                      | 
| 20001200 | 0690105010 | 961743600 | Ralph, Charles          | Elizabethtown | 120 Main St.             | IL         | 62931    | Hardin      | Charles Ralph                  | P.O. Box 302                      | Elizabethtown                  | IL                              | 62931                              |                                 |                                   | false    | false    | false  | false    | false    | false    | false                 | false           | 732        |                            | NOT ASSIGNED              |                       |                            |               |                   | 965631600         |            |                   |             |                             |                         |                      | 
| 20001338 | 0316335147 | 963644400 | CNO Development         | Chicago       | 2624-2628 South Dearborn | IL         | 60616    | Cook        | CNO Development                | P.O. Box 511                      | Wheaton                        | IL                              | 60189                              | 6306900189                      | Bonnie Coyne                      | false    | false    | false  | false    | false    | false    | false                 | true            | 732        |                            | NOT ASSIGNED              |                       |                            |               |                   |                   |            |                   |             |                             |                         |                      | 
| 20001465 | 1190155031 | 965286000 | Greene, Dick            | Bethalto      | 316 Bethalto Blvd.       | IL         | 62010    | Madison     | Dick Greene                    | 2304 Briar Cliff                  | Alton                          | IL                              | 62002-6909                         | 6184656531                      |                                   | true     | false    | false  | false    | false    | false    | false                 | false           | 732        | Jenny                      | Rossi                     | (217) 782-9285        | Jenny.Rossi@illinois.gov   |               | 968914800         | 968914800         |            |                   |             |                             |                         |                      |