NJ i Map 2 0 and NJ BASINS

NJ i. Map 2. 0 and NJ BASINS Paul Morton Water Monitoring & Standards Marzooq Al-Ebus Division of Watershed Management

Overall Use of STORET in NJ v Began using STORET in 1970 s v Currently storing ambient chemical, benthic macroinvertebrate, fish and data logger results v Since 1998, over 3, 300 stations, 600, 000 results v Used for required Integrated Water Quality Report (303 (d) & 305(b)) to USEPA and for TMDL development

NJDEP/USGS-NJ NWIS Data v Entered 3 years of cooperative network results in NJ STORET (only a part of NJDEP’s monitoring program) v Eliminated practice w/Region 2’s approval ØDuplicate entry = skewed results for users retrieving data from both databases ØNo proofreading and USGS staff limitations ØShifted resources to getting data not in a public database into STORET so publicly available for Integrated Assessment Report

Window to My Environment v Advantages: Ø“One stop shop” for NWIS & STORET data ØAccess to data not in NJ-STORET (DRBC, EPA, IEC) ØMap based and available to the public v Disadvantages: ØDifferent data formats: must reformat to merge ØOnly one station of data per retrieval ØNo Legacy STORET data

Plans for NJ-STORET and CDX v Will be applying for FY 06 NEIEN Grant funding for multiple data flows to NJ-STORET • • • v NJ State Lab NJ-STORET (expanding e. DWR) NJ-STORET EPA-STORET? May create a Web site/Web service for receiving 319(h) grant & volunteer data from groups not running STORET per Region 2 guidance Learn from Pacific Northwest and USGS XMLbased data sharing efforts so don’t reinvent the wheel

i-Map. NJ Arc. Intelligence 2. 0 “Integrating GIS with NJDEP Databases” Business Objects Web Intelligence NJ NJEMS STORET Facility Data (DMRs, Permits, Violations) Ambient Water Quality & Bio Data BRIDGE i-Map. NJ GIS Spatial Data

Basic Function of i-Map. NJ (Intranet) ü ü ü ü Builds a Bridge between Tabular Data and Spatial Data Improves Environmental Decision-Making Puts GIS & Data Viewer on Every NJDEP Desktop Introduces a “User Profile” concept Integrates additional environmental data Deploys additional GIS tools; Improves performance Employs State-of-the-Art Intranet Mapping Software Answers spatial questions that were previously unanswerable (not having a discoverable answer)

i. Map NJ Interface

ü f You Can Manage the Layers in Your Profile

Pre-Defined WEBI Query for Water Monitoring and Standards

Results of the Query - Now Run the WEBI Report

WEBI Report

Set Filters on WEBI Report to find Results Exceeding the Standard

Result Set - Now Show These Stations in i. Map

Download a Comma Delimited File to your PC

Open with Excel or Access

NJ Perspective on Needed National STORET & Related Enhancements v v v Common format for data exchange (XML schema for STORET) to eliminate current wasteful practice of manually reformatting data Automate 2 -way data exchange (CDX client node] between Federal agencies (STORET and NWIS] and states/tribes to eliminate wasteful manual process NEIEN Grant funds for states to implement STORET CDX nodes or we won’t be able to implement efficiencies offered by NEIEN initiatives STORET GIS Web Service to make monitoring stations available via common format and eliminate manual creation of GIS data layers. Multiple agencies create GIS data clearinghouses that point to Web Services = broadest possible exposure for STORET data Web links for reports currently disappear after 30 days. Make Web links for Data Logger files permanent so we can link to them from our Web sites rather than having to store the data on our Web sites

NJ Perspective on Needed National STORET/WME Enhancements v STORET/Window to My Environment • Add ability to download multiple station results rather than the exhausting “one at a time” process • Normalize output formats for STORET and NWIS (ex: units of measure, how “Non-detects” are treated, etc. ) so end user can spend less time reformatting data and more time assessing results and developing TMDLS • Add link to Legacy STORET data for users needing to do long term trend analysis and indicator/surrogate studies rather than forcing them to go to 2 Web sites and reformat data.

Needed STORET Enhancements v Make STORET a fully functional database by eliminating wasteful practices and enhancing processing of batches of information freeing resources to enter additional data: • Add the ability to change a group of results (batch processing) from “Preliminary” results that are not visible on the Web to “Final” results that are, without having to manually change each result or delete/reenter results. • Ability to add, change or delete results for a group of existing samples (batch processing) rather than doing it “one at a time” • Ability to share custom set-ups that increase the efficiency of data entry (share Preference & Defaults) between agencies

Needed STORET Tools v v v Web based application (SIM Web? ) for accepting/reformatting data for groups (contractors, grantees, academia, volunteers] not using STORET so they can make their data publicly available and therefore valid for inclusion in Water Quality Assessments. Application to include all necessary information for STORET including Organization information, and preference/default codes that must be entered manually into a local copy of STORET (problem for those who don’t have STORET Update SIM (the STORET Interface Module) so it can accept this additional information saving time and effort from manual steps and freeing resource to enter other data that doesn’t exist in a public database.

BASINS-NJ v Customized version of EPA BASINS 2. 0 for WQ data analysis, TMDL modeling and implementation v. Additional GIS data (Land Use, Impervious Cover, etc. ) v. Additional models (Mercury and Sediment) v. Additional assessment tools Ø Low flow analysis tool Ø Watershed characterization report Ø Improved target and assess tool v. Download and/or compile water quality data from multiple sources (USGS-NWIS, NJ-STORET, third-party data source v Basins-NJ version 1 was delivered on June, 2004 and is currently undergoing testing

BASINS-NJ Issues v Arc. GIS Ø NJDEP switching from Arc. View 3. x environment to Arc. GIS 8. x, 9. x and establishing Arc. GIS as the only GIS approved platform for the agency. Ø An option is to create a version of BASINS-NJ that runs on Arc. GIS - this will involve a significant rewrite of the BASINS-NJ Arc. View 3 x Avenue scripts to VBA and Arc. Objects or migrating to BASINS 4. 0 when released by EPA.

BASINS-NJ Issues During Testing Phase v System errors Ø v Error Codes- No user-interpretable information BASINS Extensions may lock the system when multiple extensions are loaded Ø Some extensions use common dialogs and same name v Low Flow Analysis Ø Single day low flow is greater than an average 7 day low flow- 1 Q 10> 7 Q 10

BASINS Avenue Error

BASINS-NJ Issues v Data Duplication Ø NWIS and Legacy STORET data ü Data entered into both data systems ü BASINS-NJ was not designed to handle this automatically. Ø User has to review combined data manually to remove data duplicates.

Potential BASINS-NJ Enhancements v Update data and provide tools to automatically update data Ø Population Water quality and flow stations Ø Meteorological data (new WDM files) Ø Automatically refresh stations list from USGSNWIS and EPA-STORET Ø

Potential BASINS-NJ Enhancements v Include new models v Enhance current download tools to include: Ø Tools to archive and restore BASINS projects (available in BASINS 3. 1) Ø STEPL Ø GWLF Ø AQUATOX v Refresh/update NWIS stations v Connect and download EPA-STORET data and stations v Provide tools to identify potential data duplicates from multiple data sources

NJ’s Perspective on STORET & BASINS Now, and its promise for future. v v NJ has used STORET for multiple water quality networks and types of monitoring (chemical & biological) for over 4 decades, NJ enthusiastically supports STORET as a National Water Quality Data Base useful for meeting EPA requirements, especially Integrated Assessments, trends and TMDLs. Urgent need to develop automated data exchange between EPA/STORET, USGS/NWIS and states, tribes, academia and volunteers to eliminate extremely wasteful current practice of reformatting data and manual data sharing. Key enhancements are needed in the areas of importing data, editing and deleting results so that STORET is a fully functional national DB and BASINS is a comprehensive assessment tool for states, tribes, academia, volunteers and public.

Thank you!