TRI State Data Exchange

1

• TRI State Data Exchange
• April, 2008

2
Agenda

• TRI State Data Exchange National Overview
• TRI State Data Exchange - UTAH

3
Program Overview

• Toxics Release Inventory (TRI)
• Section 313 of Emergency Planning and Community
  Right-to-Know Act (EPCRA - 1986)
• Requires facilities in specific sectors to report
  their Release and other Waste Management
  activities/quantities for approximately 650 Toxic
  Chemicals
• About 23,251 facilities submitted 88,000 reports
  in RY 2006
• Electronic reporting continues to increase w/
  approximately 74 reporting using EPAs central
  data exchange for RY2006 only about 3 use paper
  reporting.
• The statute requires facilities to provide
  reports to EPA and also to their State DEP

4
Historically, Prior to TRI State Data Exchange

• Facilities have had to file same information
  twice once with EPA and once with the State.
• States may not have used electronic systems to
  manage their data or, if they did use electronic
  systems, they used precious resources to enter
  data into their own databases, duplicating EPAs
  data entry.
• Resulting in States and EPA having duplicative
  versions of data that may not be the same.
• Created need for time consuming data
  reconciliation between States and EPA.

5
Now, with the TRI State Data Exchange

• In participating states, facilities can file once
  electronically with EPA and the submission
  automatically goes to the state, saving
  facilities from having to file twice.
• States can save resources and avoid duplicative
  data entry and reconciliation by using electronic
  data
• Reduces data entry time, errors, QA process and
  FTE
• Provides better data
• Allows for redirection of effort from
  administrative tasks of managing paper to
  substantive work of pollution prevention, etc.

6
How the TRI State Data Exchange Works

• Based on a successful Pilot Program developed for
  RY2004 by EPA (OIAA/TRIPD and OIC), ECOS, and
  interested states (Michigan, Indiana, Virginia,
  and South Carolina)
• EPA sets up the electronic system to push data to
  states States set up their own nodes and backend
  systems to receive and manage data
• States work collaboratively with each other and
  EPA, sharing ideas, code, etc. states already in
  production help bring new states on board
• Individual States and EPA sign an MOA MOA and
  testing steps can be conducted simultaneously to
  speed up process
• For RY2005, States, EPA, and ECOS partnered to
  expand the program to address TRI all data flows,
  including paper and magnetic media

7
How the TRI State Data Exchange Works
Technical Aspects
State DEP
State Exchange Network
CDX
F A C I L I T Y
TRI-ME WEB
MY CDX
.xml
Web Service
.gov
TRI-ME Desk Top
Internet
TRI Database
Mail Room Keying Loading Data
Disk
Paper
8
Initially Developed TRI State Data Exchange in
Two Stages

• Stage 1 TRI-ME Electronic Submissions via CDX
  are concurrently pushed to participating States
• Reduces burden on facilities by eliminating
  duplicative reporting in participating states.
• Stage 2 Diskette, Paper and First-Time Filer
  submissions converted to XML or entered in TRIS,
  converted to XML and then pushed to participating
  states
• Very popular with states because
• They get a full data set and subsequent
  corrections the first year they join.
• Eliminates state data entry and reconciliation.
• Now that EPA technical development is complete
  for both Stages, we have combined them to provide
  seamless data exchange for States new to the
  exchange

9
Current Status TRI State Data Exchange
States in Development
2004 Pilot States
States in production RY05
A total of 23 states have either joined or are in
the process of joining the TRI State Data
Exchange
10
TRI State Data Exchange Current status

• In Production
• All flows (Stage 1 and Stage 2)
• Kentucky
• Michigan
• Washington
• Kansas
• Colorado
• Utah
• Indiana
• Virginia
• Illinois
• Ohio
• New Jersey
• Delaware

In development (Stage 1 and Stage
2) Wisconsin Mississippi North
Carolina Texas California Pennsylvania Note
denotes all flows MOA signed
For Reporting Year 2006, about 38 of the
national data (35,000 reports) went through the
TRI State Data Exchange to participating states.
For Reporting Year 2005, more than 20 of the
national data (20,062 reports) went through the
TRI State Data Exchange to participating states.
During the Pilot (RY2004), 6664 reports went to
participating states.

• Stage 1
• South Carolina
• Minnesota
• Oklahoma
• Oregon
• Note denotes Stage 2 also in development

11
Next Steps

• Bring new states on board
• Continuous process improvement
• Work toward making it faster and easier to bring
  new states onboard
• Work toward more coordination around platforms to
  ease sharing code and tools
• Continue State/EPA technical teleconference, as
  well as regular TRI SDX teleconference

12

• Contact Information
• State Data Exchange Project Lead
• Ingrid Rosencrantz
• TRI, Infomation Outreach Branch
• Ph 202-566-0961
• Email rosencrantz.ingrid_at_epa.gov
• Dipti Singh
• Chief, TRI, Information Outreach Branch
• Ph 202-566-0739
• Email singh.dipti_at_epa.gov