Transcript Facility Profiler System - The Exchange Network

Kansas Department of Health and
Environment
Facility Profiler System
INTRODUCTION TO THE SYSTEM
Exchange Network Grant History
 One Stop Grant $500,000 (’02)
 Readiness Grant $297,000 (’03)
 Implementation Grant $300,000 (’04)
 Challenge Grant (HERE) $750,000 (’05)
 Infrastructure Grant (CME) $223,000 (’06)
 Implementation II $245,000
Exchange Network Flow Goals
 State to EPA & EPA to State
 FRS, NEI, SDWIS, AQS, RCRA, FEA, RMP
 RCRAInfo, WQX, UIC, ICIS-NPDES (Proposed)
 State to State
 KS to {MO,NE,IA} (HERE Project Presentation Tomorrow)
 Intrastate
 KDA to KDHE (Ag Chemicals)
 Regulated Community
 TRI
Facility Profiler Data Content
45 32’ N
Affiliated Parties
Facility name,
Industry
Classification
122 40’W
Geographic Location
Environmental
Interests
Facility Profiler Goals
 Establish an agency-wide data sharing environment
 Support FOIA requests (e.g., ‘Who’s doing what nearby?’)
thus reducing agency burden
 Support drivers for integrated environmental data from
EPA, the legislature, and the regulated community
 Assist with internal bureau coordination (e.g., during
permit reviews or enforcement actions)
 Participate in the National Exchange Network
Facility Profiler Overview
Facility
Reconciliation
Data Inquiry
KDHE
Information
Systems
Facility
Profiler
EPA
KDA
KDHE
Node
Additional Benefits
 Browser based GIS mapping capabilities on agency






desktops
Facility location address cleaning
Derivation of facility location coordinates
Identification of facility duplication in existing systems
Facility name data standardization
Allows users to query and download data
Can provide a ‘portal’ to bureaus’ inquiry systems
Multiple Source Systems
KDHE Program Systems
Federal EPA
TRIS
USTs
LUST
FRS
Air Quality
RCRAInfo
TRI
Reporter
CAFO
ECHO
Remediation
Tier II
Facility
Profiler
Solid Waste
UIC
Wastewater
Tracking
Dry Cleaners
Radiation
STORET
Spills
SDWIS
KDHE
Node
Kansas Dept of
Agriculture
KDA Node
RECS
Multiple External Connections
Facility Profiler
ECHO
Environmental Interests
with External Links
RTKNET
FEA
TRI
KDHE
Intranet
TRI/CDX
Repository
Envirofacts
Identified Site List
KS ISL
RCRA
Envirofacts
SDWIS
KS SDWIS
STORET
KS STORET
Solid Waste
KS Solid Waste
Spills
KS Spills
Internet
Applications
Monarch Cement
Wichita Area of Interest
Wastewater Treatment
7
Leaking Underground Tanks
49
Spill Incident Report
59
RCRA
206
Radioactive Material
8
KDA Sites
20
Identified Sites
23
Toxic Release Inventory
12
Right-to-Know
21
Resource Management Plans
2
Formal Enforcement Action
4
Dry Cleaners
5
Air Quality
36
0
50
1 00
1 50
200
250
Sharing
 Facility Profiler Reuse
 Michigan (.Net, SQL Server)
 Kansas (.Net, Oracle)
 North Dakota (.Net, SQL Server)
 Nevada (.Net, Oracle)
 Connecticut - variant (.Net, SQL Server)
 Missouri (Java, DB2)
Conclusions
 Integration doesn’t have to be all or nothing
 Integrated data access doesn’t require integrated data
management – a warehouse can be a highly effective, lower
cost alternative
 Integration is not just an agency thing anymore
 Data about your state is probably disparate;
 The EN allows for comprehensive data integration
 States can collaborate effectively
 Share data – e.g., HERE
 Share investments – e.g., Node, Plugins, Applications (FP)