Illinois Emergency Management Agency Freedom of Information Act Request ========================================= Introduction ------------ This file contains information on all annual Tier2 chemicals reports from 2005 through the current reporting period. System Requirements ------------------- Windows 98 Operating System or later is required. MS Excel, WordPad or Notepad is needed to view the file. If you will be sorting, extracting or manipulating the file data or printing address labels, a program such as Microsoft Excel, Microsoft Word or compatible products is suggested. Contents Download -------------------- T2Readme.txt Tier2.csv - An ASCII, quote/comma delimited list of ALL Tier2 annual reports from 2005 through the current reporting year. Viewing & Using the Data ------------------------ To view the file data in WordPad or Notepad: Open My Computer Navigate to the CD drive that contains the IEMA Freedom of Information Act Request CD (FOIA CD) and double-click on the Hazmat-Reports.csv file NOTE: If you can not see the folder or the Hazmat-Reports.csv file listed in the folder list on the left side of the Windows Explorer window, look at the display area on the right side. You may have to click on the folder name to display the file. To use the file data in Excel 97 or later: Launch Excel Select Open from the File menu Navigate the "Look in" box to the CD drive that contains the FOIA file The file will be displayed in 30 columns. See "Layout of Tier2.csv" for a description of the columns and contents. If you want to save the file as an Excel worksheet: Select Save As from the File menu Change the Save In location to a folder on your C: drive Change the "Save as type" to Microsoft Excel (*.xls) and click Save Layout of Tier2 -------------------- The first record of this file contains the column headers. Column Header ------------- Corporate Name Facility Name Report Year Facility Street Facility City Facility State Facility Zip Code Facility County Facility Phone Facility Fax Fire Dept. LEPC Owner Owner Phone Owner Street Owner City Owner Stte Owner Zip Code Mailing Name Mailing Street Mailing City Mailing State Mailing Zip Code Facility Latitude Facility Longitude Chemical Name Chemical CAS # Chemical EHS Chemical Contents Chemical Health Hazards Chemical Max Daily Amount (in pounds) Chemical Avg Daily Amount (in pounds) NOTE: The file contains ALL annual Tier2 chemical reports since 2005. The file contains a record for each chemical possessed by the facility for each report. The file also address and contact information for each facility. Therefore all non-chemical fields will be the same for each chemical/facility, within a report. If you are only interested in a portion of this list (i.e., reports in Sangamon county), it will be your responsibility to select only those reports. The Illinois Emergency Management Agency provides the data on this file for your use, but is not able to print labels or create databases for you from this data.