To obtain map-able data from the EPA databases go to
the Facility and Geographic Locational Reference Information EZ Query pages
They are located at
http://www.epa.gov/enviro/html/fii/ez.html
From the Geographic Locational Reference Information table select the EPA Facility Latitude and Longitude Information view.
Then select the appropriate columns for your output (if you want to narrow your search criteria by program office be sure to select the ‘Program System Acronym’ table) by clicking on the square box next to the column name. When you are finished selecting columns. The columns you click here will be the ones in the data that is provided to you and the columns that you can use to search upon.
Click on the "STEP 3: Enter Search Criteria" button at the bottom of the page.
(In search criteria enter TRIS for the program system acronym for TRI data or CERCLIS for Superfund data.)
You will probably need to enter a state code in order to prevent your query form timing out due to the large quantity of data. You may then click the Search Database button for on-line results (good to check) and then click on "Output to CSV File" to obtain results in a downloadable format - or you can choose CVF from the initial query page.
Once you have the CVF data on your browser screen you should then click on the File > Save as option on the browser and save it to a local file.
To quickly view the data you can start Excel and then open the CVF file - be sure to select the CVF file form the file type. You may modify the column names etc. If you desire and save it as an Excel file.
At this point you can move to GeoMedia
Connect to an Access warehouse that is read/write.
Select Warehouse > Feature Class Definition and in that dialogue select one of the current read/write Access warehouses
At this point the Attach button will become accessible.
Click it and choose the proper file format - in this case Excell97
Browse to or enter the file name for the EPA data that you saved in Excel format.
The worksheet name is entered automatically in the left column, Type in a valid feature class name in the left column. Click OK.
You will now need to geocode the data. Select Analysis > Geocode Coordinates
In this dialogue select the attached feature class and associate the proper column with the latitude and longitude entries. You may also need to adjust the coordinate system information of the data. Use the Define button to select NAD83 (or whatever the correct selection is for your data)
When done click on OK
If you want to permanently have the data accessible you may want to
output to a feature class.