Webinar: EPA’s Superfund, Hazardous Materials and Brownfields Data August 3, 2011

1. Webinar: EPA’s Superfund, Hazardous Materials and Brownfields DataAugust 3, 2011

2. Agenda • Introductions • Sarah Swenson, EPA (facilitator) • Lisa Jenkins, EPA (presenter) • Joe Carioti, EPA (presenter) • Format • EPA speaker (30 minutes) - • Lines are muted - submit questions as the speakers talk • Technical issues? Send a message via webinar panel • Questions and Answers (15 minutes) • See the website: epa.gov/appsfortheenvironment

3. Background about the Challenge • Apps must use EPA data and address one of EPA Administrator Lisa Jackson’s Seven Priorities • Judged based on usefulness, innovativeness, and usability • Submissions are due by September 16 • Winners and runners up for Best Overall App and Best Student App, plus People’s Choice • Recognition from EPA in Washington, D.C. in November • Get more details at epa.gov/appsfortheenvironment

4. Office of Solid Waste and Emergency Response (OSWER) Mission Areas: • Solid Waste Management • Cleanup (Superfund, Hazardous Waste Management, Underground Storage Tanks, Brownfields, Federal Facilities) • Emergency Management

5. OSWER Data for Apps for the Environment Major Datasets & Tools • Superfund – CERCLIS Public Access Database (CPAD) • http://www.epa.gov/superfund/sites/phonefax/products.htm • http://cfpub.epa.gov/supercpad/cursites/srchsites.cfm • http://www.epa.gov/superfund/sites/ded/index.htm • Brownfields – ACRES (in Envirofacts and CIMC) • RCRA* – RCRAInfo and Biennial Report (BR) (in Envirofacts), and Web Services • Cleanups in My Community (CIMC) – a Web application to access cleanup data listed above • http://www.epa.gov/cimc * RCRA = Resource Conservation and Recovery Act – includes waste management and RCRA Corrective Action (cleanup)

6. OSWER Data for Apps for the Environment Smaller Datasets & Tools (page 1) • Unit Cost Compendium (UCC) data – cost guidelines for estimating cleanups for RCRA – update due out in 2011/12 • http://www.epa.gov/wastes/hazard/wastetypes/wasteid/ucc-csv/ • RMAN portion of CPG data – recycled content reco’s/guidance • http://www.epa.gov/wastes/conserve/tools/cpg/rman-csv/index.htm • Local Emergency Planning Committee (LEPC) (listing) tool • http://yosemite.epa.gov/oswer/lepcdb.nsf/HomePage?openForm • Title III List of Lists – Regulated chemical info (Data and tool) • http://www.epa.gov/swercepp/web/tools.htm#lol • EPA On-Scene Coordinator Web Sites – Emergency responses • http://www.epaosc.org/site/regionmap.aspx

7. OSWER Data for Apps for the Environment Smaller Datasets & Tools (page 2) • Superfund Site Comprehensive Listing (NPL, non-NPL, Contaminants, Responsible Parties) • http://www.epa.gov/superfund/sites/phonefax/order.htm • Widgets to search for Brownfields, RCRA, BRS, Superfund and Cleanups in Envirofacts • http://www.epa.gov/enviro/facts/widgets.html • EPA Geospatial Download • http://www.epa.gov/enviro/geo_data.html

8. Cleanups in My Community(middle of) Welcome Page U.S. Environmental Protection Agency

9. U.S. Environmental Protection Agency

10. Cleanups in My CommunityProgress Profile Views

11. Cleanups in My CommunityList View

12. RCRAInfo

13. What is RCRAInfo? • RCRAInfo is EPA's comprehensive information system, providing access to data supporting the Resource Conservation and Recovery Act (RCRA) of 1976 and the Hazardous and Solid Waste Amendments (HSWA) of 1984. • The system enables cradle-to-grave waste tracking of many types of information regarding the regulated universe of RCRA hazardous waste handlers. It characterizes facility status, regulated activities, compliance histories, financial assurance requirements and GIS data. In addition,it captures detailed data on the generation of hazardous waste from large quantity generators and on waste management practices from treatment, storageand disposal facilities.

14. RCRAInfo Modules • Handler (HD): The handler module is the starting point for all information about hazardous waste handlers entered into RCRAInfo. It contains all the identifying information about the facility (e.g. name, address, NAICs codes, activities). • Compliance Monitoring and Enforcement (CME): The compliance, monitoring and enforcement module contains compliance monitoring data (e.g., evaluation and violation data) and enforcement data (e.g., information on agencies beyond RCRA participating in the enforcement action, enforcement milestones, penalties, and payments). • Corrective Action (CA): The corrective action module contains corrective action authority, area, and event data gathered from hazardous waste handlers having or suspected of having a hazardous waste release. The corrective action module is also used to produce standard reports that assist in the management of the corrective action program.

15. RCRAInfo Modules • Permitting (PM): The permitting module contains permit event and unit data gathered from the hazardous waste handlers that have or are applying for a RCRA permit. • Financial Assurance (FA): The financial assurance module contains financial assurance data (e.g. cost estimates and mechanisms). • Geographic Information System (GIS): The geographical information system module contains spatial data used for mapping the entire facility, as well as mapping at the unit and area level. The module also stores acreage data that is used to track cross-program land revitalization efforts. • Waste Activity Reporting (WAR): The waste activity reporting module contains generation, management, receiving and shipping data collected biennially from large quantity generators and treatment, storage and disposal facilities. BR data is contained in this module.

16. Resources – flat files • Translator Guide: https://rcrainfo.epa.gov/rcrainfo/newsalerts/translatorguide/translator_guide.pdf • Flat files: ftp://ftp.epa.gov/rcrainfodata/rcra_flatfiles/ ftp://ftp.epa.gov/rcrainfodata/br_2009/

17. Resources – Web services • Exchange Network: • Partnership among States, Territories, Tribes, and the U.S. • Provides real-time access • http://www.exchangenetwork.net/node/dev_toolbox/funcspec.htm • http://www.exchangenetwork.net/node/dev_toolbox/protocol.htm • Representational State Transfer (REST): • Only public data is returned in an xml format • Clean url format • Additional details in Flow Configuration Document (FCD), section 4.2

18. Resources – Web services • Translator Guide https://rcrainfo.epa.gov/rcrainfo/newsalerts/translatorguide/translator_guide.pdf • Exchange Network RCRAInfo Page http://exchangenetwork.net/exchanges/waste/rcra.htm • Exchange Network FCD http://exchangenetwork.net/schema/RCRA/5/RCRA_FCD_v5.2a.doc • Wiki page http://www.exchangenetworkwiki.com/wiki/index.php/RCRAInfo • National Biennial RCRA Hazardous Waste Report http://www.epa.gov/epawaste/inforesources/data/biennialreport/index.htm

19. Resources - Envirofacts • Envirofacts http://www.epa.gov/envirofw/facts/rcrainfo/search.html http://www.epa.gov/enviro/facts/br/search.html http://www.epa.gov/enviro/facts/topicsearch.html#waste

20. EN Query and REST Services

21. Available Services

22. Available Services con’t

23. Questions and Answers Potential topics: • Questions about accessing or using data systems • How to submit ideas for apps • Ideas for future webinars – what datasets do you want to learn about?

24. Next Steps • Check out our new webinar site to catch up on any you’ve missed! • Weekly webinars – Wednesdays @ 2 PM EST • The next webinar is on Wednesday, August 10 at 2 PM eastern • Topic: EPA’s environmental enforcement data • Check out our blog at http://blog.epa.gov/data/ • Visit the website for the latest news and sign up for the listserv (EPA App Developer Community) • Email us at greenapps@epa.gov • Submit your apps by September 16

25. Contact Information RCRAInfo: Joe Wilson Branch Chief Office of Solid Waste and Emergency Response(OSWER) (703) 347-8578 wilson.joe@epa.gov • OSWER data and tools: • Lisa Tracy Jenkins • EPA/OSWER/OPM/IMDQS • (202) 566-1941 • jenkins.lisa@epa.gov • http://www.epa.gov/oswer • http://www.epa.gov/cimc