Rhode Islands new ambient water quality data management system:

1
Rhode Islands new ambient water quality data
management system RI-SWIMS and WQX
2
Presentation Overview

• Why SWIMS was needed
• Overview of SWIMS
• Show you SWIMS

3
Why was SWIMS needed ?

• Inadequacies of our old data management system
• Currently, water quality data is
• housed in many different databases
• not always readily available to staff
• Old database
• Lacks capacity to hold all water quality data
• Lacks modern security protocols
• Little detailed feedback regarding data uploads
• Data was not uploaded to STORET or WQX

4
Why was SWIMS needed ?

• Goals for our new data system (RI-SWIMS)
• Secure and robust architecture
• House all state water quality data
• Store pictures, QAPPs, other metadata
• Retain table structure for links to other DEM
  databases
• User-friendly web interface allows
• data is readily accessible to all staff
• Automated upload of data from staff outside
  users
• Flow data via a NODE from Dept. of Health and
  to WQX

5
Overview of SWIMS
6
(No Transcript)
7
SWIMS Features and Benefits

• Design Highlights
• Designed based on WQX Model
• Stations tied to a Waterbody ID
• Built-in Administrator Review
• Framework for Other Data Sets
• Configuration Benefits
• XML Driven Data Validation
• Intelligent Data Duplicate Checking
• Template Driven Datasets
• Configurable Project-Specific Security Rights
• Automated Emails
• Business Process Features
• Allows Electronic Upload from Water Quality Data
  Collectors.
• Resulted in an automated process with RI
  Department of Health.
• Dynamic Query and Reporting Module
• Evaluate Data Against Criteria Wizard

8
(No Transcript)
9
SWIMS System Demonstration

• Upload/Validate data
• Review and Approve Data Uploads
• Search and Review Data across the State
• Run Dynamic Queries and Reports
• Compare Data to Criteria and Print Evaluation
  Report

10
SWIMS Home Page for System Administrator
11
SWIMS Data Submission Options
12
SWIMS Configurable Automated Validation
13
SWIMS Administrator Review
14
SWIMS State Admin Functions
15
Acknowledgements
Alisa Richardson Deb Merrill Connie Carey Eric
Schneider Pam Galli
Funded by a National Environmental Information
Exchange Network (NEIEN) Grant
Deric Long enfoTech Systems Development Team
16
Questions?
Contact Eric Schneider at eric.schneider_at_dem.ri.
gov Deric Long at deric_long_at_enfotech.com