Missouri Department of Natural Resources' Implementation of WQX - - PowerPoint PPT Presentation

Missouri Department of Natural Resources

Robert Voss (573) 522-4505 Robert.Voss@dnr.mo.gov

Missouri Department of Natural Resources' Implementation

• f WQX within their Data Management

and Assessment System

70+ Different Acce cess ss database ses

– Must search multiple databases to find all data. – Must enter data manually into each database. – Minimal GIS component – Each database had it’s own shapefile.

The Way It Used To Be

EPA’s Assessment Database (ADB) worked but had to be manually changed to be copaseti tic with Missouri ri’s Water Quality ty Standard rds.

– Every Triennial Review required update to ADB – No GIS integration. – 303(d)/305(b) GIS shapefiles were a time intensive process manually created from the final report produced for EPA.

The Way It Used To Be

Development of WQA

WQA is Phase III of the MoDNR - Water Protection Program Enterprise Application: “Missouri Clean Water Information System” (MOCWIS )

• Phase 1 – Water Quality Standards
• Phase 2 – Permitting and Compliance
• Phase 3 – Water Quality Assessment

– Application and Development Staff - Creating and programming the system, Business Rules & GIS web application – Contractor – RKV Technologies – Business Analysis, Project Charter, programming, ect. – GIS Staff - GIS database design, database and application service management, help with the web application development and configuration, subject matter expert/liaison, system documentation/requirments – Enterprise Data Warehouse Staff – Database tasks for OWIR/ATTAINS and WQX submittals, Report needs for the end users (Business Objects/Web Intelligence) – MoDNR Staff – Design guides, testing, and conversion

Groups Involved in Development

Project Charter

• Project Purpose which includes findings from Business Analysis and

recommendations for implementation

• Identified the Scope of the project- Goals & Objectives, Subject

Areas, Functions & Activities, What was not included in the project.

• Identified all users of the system
• Detailed the Project approach
• Identified Project Team roles/ responsibilities
• Identified all team members and their responsibilities
• Deliverables
• Project Schedule

Development of the System

 Project Time Frame: 1/2009 to 9/2010 – 6 months of which was Business Analysis  Contractor created:

 Project Charter that outlined the requirements and scope of the project.  User Interface Specifications - Documents that detail what screens are needed and what they should look like.  Use Case Specifications – Documents that detail what the system is supposed to do for each action performed in the system.

Business Analysis

– Purpose – Capture the current water quality data management process used by the Water Quality Monitoring and Assessment Unit and provide a recommended solution. – Took approximately 6 months (1-2 several hour meetings per week for ~ 6 months) – Documentation of the business needs found during analysis, as well as documenting EPA OWIR/ATTAINS and WQX data submission/schema requirements. – Outcome is a recommended course of action and set of goals for MoDNR.

*

Goals from Business Analysis

 Finding a replacement solution for all WQIS functionality  Reducing the number of water quality data repositories  Adhering to EPA reporting requirements  Reducing the amount of manual data entry required for water quality raw data  Improving the accessibility of all water quality data  Providing a better overall solution for maintaining water quality data.

Documentation

Data Mapping

Bugs - Issue Tracking

Bugs - Issue Tracking

Deliverables

 One enterprise system for information.  Searchable and available to MoDNR staff and public.  Under greater scrutiny  Greater consistency  GIS feature classes available for MoDNR staff in real time.  GIS shapefiles will become available on the Missouri Spatial Data Information System (MSDIS) for public use.  Automated process for submission of 303(d)/305(b) information (OWIR/ATTAINS)  Automated process for submission of sample data to EPA’s STORET database. (WQX)

*

End Product – The Water Quality Assessment System

 Web based enterprise application which supports the work of the Missouri Department of Natural Resources (MoDNR) Water Quality Monitoring Program.  Used for storage, organization, analysis and distribution of water quality and assessment data collected by the MoDNR and many

• ther sources.

 The application integrates data management with GIS editing capabilities to save time, provide better data accuracy, and gain timely access to the data by both in-house and public users.  Automated Process for flowing data to WQX and OWIR/ATTAINS

End Product

All components integrated into one system.

WQA – OWIR Batch Error Report E-mailed to users before submission to OWIR/ATTAINS Node

OWIR/ATTAINS Submittal

WQX MoDNR Node Submittal

WQX Node Error Report

GIS Data Integration

 Stream Surveys – Monitoring locations (points) and Use Attainability Ratings (lines)  Toxic Events – Streams (lines) & Lakes (polygons)  Nonpoint Source Areas (polygons)  Raw Sampling Sites (points)  Water Quality Assessments – Streams (lines), Lakes (polygons), Lake downstream (point)

Contact Info: Robert Voss (573) 522-4505 Robert.Voss@dnr.mo.gov