160 likes | 304 Views
Eric Schneider & Deric Long. Rhode Island’s new ambient water quality data management system: RI-SWIMS and WQX. Presentation Overview. Why SWIMS was needed Overview of SWIMS Show you SWIMS…. Why was SWIMS needed ?. Inadequacies of our old data management system
E N D
Eric Schneider & Deric Long Rhode Island’s new ambient water quality data management system: RI-SWIMS and WQX
Presentation Overview • Why SWIMS was needed • Overview of SWIMS • Show you SWIMS… STORET/WQX User’s Conference – 11/28/07 Austin, Texas
Why was SWIMS needed ? • Inadequacies of our olddata 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 STORET/WQX User’s Conference – 11/28/07 Austin, Texas
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 STORET/WQX User’s Conference – 11/28/07 Austin, Texas
Overview of SWIMS STORET/WQX User’s Conference – 11/28/07 Austin, Texas
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” STORET/WQX User’s Conference – 11/28/07 Austin, Texas
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 STORET/WQX User’s Conference – 11/28/07 Austin, Texas
SWIMS Home Page for System Administrator STORET/WQX User’s Conference – 11/28/07 Austin, Texas
SWIMS Data Submission Options STORET/WQX User’s Conference – 11/28/07 Austin, Texas
SWIMS Configurable Automated Validation STORET/WQX User’s Conference – 11/28/07 Austin, Texas
SWIMS Administrator Review STORET/WQX User’s Conference – 11/28/07 Austin, Texas
SWIMS State Admin Functions STORET/WQX User’s Conference – 11/28/07 Austin, Texas
RI–DEM 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
Questions? Contact: Eric Schneider at eric.schneider@dem.ri.gov Deric Long at deric_long@enfotech.com