210 likes | 223 Views
From STORET to WQX New Jersey’s Solution for Integrating Ambient Water Quality, Facility and GIS Information from Federal, State, County & Volunteer Organizations. Harry Chen New Jersey Department of Environmental Protection November 28, 2007 Austin, TX. Project Purpose.
E N D
From STORET to WQXNew Jersey’s Solution for Integrating Ambient Water Quality, Facility and GIS Information from Federal, State, County & Volunteer Organizations Harry Chen New Jersey Department of Environmental Protection November 28, 2007 Austin, TX
Project Purpose • Integrate water quality data • Streamline and simplify data transfer • Provide better, more timely access to water quality data • Aid decision-making • Improve resource efficiency
Goals • Develop an up to date, searchable inventory of ambient water quality monitoring in New Jersey • Integrate ambient water quality monitoring data into NJDEP’s enterprise environmental data management system to enable more integrated environmental decisions • Make NJ ambient water quality monitoring data available to the public • Report ambient water quality monitoring data to USEPA
Project Partners • NJDEP • Bureau of Freshwater and Biological Monitoring • Bureau of Marine Water Monitoring • Bureau of Water Quality Standards and Assessment • Division of Watershed Management • Division of Science, Research, and Technology • USGS • Department of Health and Senior Services (DHSS) • County Governments • Volunteer Monitoring Organizations • NJ Water Monitoring Coordinating Council (Inventory)
AMNET Field/Hab dB Reformat Field/Habitat dB Field Form Existing NJDEP Data Entry Mechanisms Text file Keypunch Field Msr Habitat Sample Info MS Access Link Note: Proofreading and correction steps occur for all data, but are not shown due to space limitations. AMNET Taxa dB Bench Sheet Reformat Taxa dB Keypunch Taxa counts Text file Text file Make Final dB Extensive Manual Reformat Of Text File FIBI dB Field Form Keypunch Field Msr Habitat Taxa counts Sample Info Text file Change Result Status To Final ODBC Connect DHSS Chem Results Import e-file Chem Results Migrate NJ STORET FTP Oracle Export Delete Migration Lakes dB Reformat Lakes dB QC Labs Chem Results Text file Import e-file Chem Results EPA Text file Field Staff Data Staff Field Form Keypunch Field Msr Habitat Sample Info ODBC Connect Corrections Text file DHSS Chem Results Keypunch Chem Results Proofreading dB Others Text file Others QC Labs Chem Results Keypunch Chem Results Other Projects dBs Corrections Proofreading Reports Manual Proofreading Field Form Sample Tracking dB Keypunch Field Msr Sample Info
Core project components • WQX data flow, consisting of the following • Data-in: E2 WQX module with data validation • Data transmission to and from COMPASS • Data-out: NJ Water Monitoring Inventory / Data Portal • Outbound data transmission to EPA CDX
High-Level Data Flow EPA CDX E2 COMPASS ENDS
Data System Integration • E2 • COMPASS • ENDS Data will be transmitted through each component using NJ’s Exchange Network NODE.
FutureAmbient Water Quality Data Producers 4 EPA & USGS Web Services
GIS Integration Monitoring Inventory Data Reports Link Web-based Maps Link Link
GIS Proposals: • EN Browser hosted by ECOS, a national solution • NJ-GeoWeb, a NJ solution
EN Browser Web services data discovery tool • Allows users to discover and execute Data Requests on Exchange Network Nodes • Offers users the ability to remove (filter) unwanted sections of the XML data set returned from a Data Service • Users have the option of choosing the format that they would like to retrieve the data in • Can integrate with enterprise data reporting tools
NJ-GeoWeb A New Vision for Seeking Spatial Intelligence. Integrating customized GIS and analysis tools with enterprise databases for improved decision-making on the Internet.
“NJ-GeoWeb” Permitting Compliance Enforcement Clean & Plentiful Water Water/Sewer Infrastructure Water Allocation Storm Water Runoff Monitoring What’s in My Backyard Surveillance Inspections ePermits Regulated Sites Incident Mgmt Flood Mapping Endangered Species Data Server Sustainable Growth SDE Data Taking care of Business Align Economic and Env. Goals Env. Sensitive Areas Green Technologies Economic Incentives Employment Info Revitalize and Redevelop Live Feeds from State Government L.awrence Thornton, NJDEP
WQDE Project Challenges • Pulling data from USGS (web services in development) • Pulling data from EPA (web services in development) • Coordinating with a large number of project partners • Requires compromise • Re-engineering current reporting procedures, while designing new WQX reporting procedures • How to teach an old dog new tricks?
Project Phases and Tasks: • Business Process Analysis • Functional Requirements Specification and System Design • System Development, Data Preparation and Implementation • Acceptance Testing • User Training, Documentation and Outreach
Next Steps • Complete System Design • Programming and Development • User Acceptance Testing • Documentation and Training • Production Deployment • Send data to EPA • Target Date: October 2008
Thanks! Contact Info: NJDEP- Office of Info Resources Management Name: Harry Chen Phone: (609)-633-1261 E-mail: Harry.Chen@dep.state.nj.us