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.