Transcript Site Profiler Popping Up Everywhere

Network Innovations
Let’s Share Code:
Site Profiler Popping Up
Everywhere
Thursday, May 31, 2012
Meeting Agenda
Time: 30 Mins
1.
Site Profiler Overview
2.
Michigan Experiences
3.
Various State Implementations
4.
Demonstration
5.
New Hampshire Experiences
6.
Colorado Experiences
7.
Open Q & A
Site Profiler
System Overview
What is the Site Profiler System?
• Integrated view of enterprise core site/facility information across
all programs.
• Spatial representation of sites (improves locational data)
• Warehouse, so it does not impact/disrupt program systems
• Shareable between States, and many times the benefits from
state-to-states are shared
Site Profiler
System Overview
What is the Site Profiler System?
• Combined with FacID Plugin - solves the challenge of sending
cleaned/non-duplicative Facility data to the EPA.
• Transparent, a quick method to present regulated data to the
Public
• Supports drivers for integrated environmental data from EPA
(FacID data flow), the legislature, and the regulated community
Site Profiler
Michigan Implementation
•
Provide basic cross-agency information for DEQ
•
What facilities have what permits in my congressional district?
•
Internal Data Reconciliation
•
Numerous Programs and Databases
•
Compliance & Enforcement – Transparency
•
Geo-spatial component – Bing Maps
•
FRS Data Flow => EPA
Programs and Databases
•
•
•
•
•
•
MI Toxic Release Inventory (TRI)
Oil & Gas Database (OGS GSDMIR)
Waste Data System (WDS)
MI Air Emissions Inventory System (MAERS)
NPDES Management System (NMS)
Safe Drinking Water (SDWIS)
Site Registry
Team/Business Protocols
Anatomy of Site Merge
#54234
#23471
#1126
Ajax Corporation
Borland Site
Ajax Corporation
1252 Rue Street
Lansing, MI
Title V
Operating Water
Permit Discharge
#845
Permit
#F964D3
+
1252 Rue Road
Lansing, MI
Cleanup
site
#34
UST
#B541
=
1252 Rue Road
Lansing, MI
Title V
Operating
Permit
#845
Cleanup
site
#34
Water
Discharge
Permit
#F964D3
UST
#B541
State of Michigan
Open Source Software License
The intent of this license is to make unique
software developed by the State of Michigan,
as described in Exhibit B, available to others
(“Software”)….
Site Profiler
State Implementations
State
Framework
Database
Spatial Toolset
CME
New Hampshire
(One Stop Environmental
Data)
NET 2.0
Oracle 9i
Google Maps/ArcGIS
No
Michigan
(Site Registry)
NET 1.1
SQL 2000
ArcIMS
Yes
Colorado
(Site Profiler)
NET 2.0
SQL 2005
Google Maps/ArcGIS
Yes
NET 1.1
Oracle 10g
ArcGIS
Yes
NET 2.0
SQL 2005
Google Maps/ArcGIS
No
J2EE 1.4.2
DB2 UDB 8.1
ArcIMS
No
NET 1.1
Oracle 11g
ArcIMS
No
NET 1.1
SQL 2000
ArcIMS
No
Kansas
(Facility Profiler)
Hawaii
(Environmental Health
Warehouse)
Missouri
(Facility Profiler)
Nevada
(Facility Profiler)
North Dakota
(Facility Profiler)
Site Profiler
Demonstration
Site Profiler
New Hampshire Implementation
•
Three primary drivers – need for map interface, FRS flow,
better reconciliation
•
It’s all about timing – already doing Node/Flow upgrade, saw
Site Profiler demo, had to have it
•
NH had assistance with installation and training, but now
NHDES/NHDoIT staff are adding additional data sets
•
Windsor did SDWIS, we have mapped to above/underground
storage tanks, air facilities, beaches and remediation sites,
working through the other source systems
Site Profiler
Colorado Implementation
•
Primary drivers – Single site view of “permitting” and
compliance information, mapping, better reconciliation, facility
flow, Helping the Source Water Assessment Program
•
Third time is the charm – Colorado had tried this before with
only limited success, so went with a product that had been
proven in other states.
•
Windsor did SDWIS, Air Stationary Sources Emissions, TRI.
Colorado mapped Solid Waste and an ICIS-NPDES data
dump.
•
Working on RCRA, evaluating others such as CAFOs,
Cleanup sites, and Health Facilities
Site Profiler
Questions/Answers
Site Profiler
System Overview
Facility Profiler
Source Systems
Geocoding
Service
Source
System 1
Mapping Server
Web
Inquiry & Mapping
Source
System 2
Data Warehouse
Source
System 3
Data Extract
Transform
and Load
(ETL)
Reconciliation Application
(FPRA)
XML
Source
System 4
Network Node
Server
Web
EPA CDX