Government Databases (was EPA databases)

[kato13]

For those out of the US EPA is the environmental protection agency.

I was reformatting my chemical plants for insertion into my mapping database and I remembered that the EPA was a wonderful source of information.

For example water sources
selector
http://www.epa.gov/enviro/html/sdwis/sdwis_query.html

details
http://oaspub.epa.gov/enviro/sdw_query_v2.get_list?wsys_name=&fac_search=fac_beginning&fac_county=BOONE&pop_serv=500&pop_serv=3300&pop_serv=10000&pop_serv=100000&pop_serv=100001&sys_status=active&pop_serv=&wsys_id=&fac_state=IL&last_fac_name=&page=1&query_results=&total_rows_found=


The full chemical information I pulled is in DBF format which is hard to open unless you have the right programs. I have attached a zipped csv version if anyone is interested.



Here is another potential data source
state selector
http://www.epa.gov/air/data/geosel.html

California Facility Emissions Report
http://www.epa.gov/air/data/netemis.html?st~CA~California

If you chose all the pollutants you get over 9500 returns of polluters in California. Many would not be useful (like dry cleaners) but others might (sawmills, petroleum terminals, telephone equipment and semiconductors manufacturers, etc). I am still trying to decide what to do with this data so I will attach an example in csv format.

[kato13]

More government data. I am posting these links here so I don't lose or forget them. I have lost the source for a ton of files over the years.

6745 Active Mines or processing plants

http://tin.er.usgs.gov/mineplant/output/mineplant-2009-03-08-08-23-26.txt (text file) (going to integrate this into my mapping system soon)

http://tin.er.usgs.gov/mineplant/package.php (google earth file.)


One very interesting commodity which would be in high demand in a T2k canon world would be Zeolites (found near the bottom of the list). It's use as a filter is one of the easiest methods of producing pure alcohol. This would be necessary if alcohol is to be used in vehicles and standard distillation would only get you to 95%.