Rhode Island’s new ambient water quality data management

system: RI-SWIMS and WQX

Eric Eric Schneider Schneider

& & Deric LongDeric Long

STORET/WQX User’s Conference – 11/28/07 Austin, Texas 2

Presentation Overview

I. Why SWIMS was needed

II. Overview of SWIMS

III. Show you SWIMS…

STORET/WQX User’s Conference – 11/28/07 Austin, Texas 3

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

Why was SWIMS needed ?

STORET/WQX User’s Conference – 11/28/07 Austin, Texas 4

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

Why was SWIMS needed ?

STORET/WQX User’s Conference – 11/28/07 Austin, Texas 5

Overview of SWIMS

DMZ

InnerNetwork

Internet

InsideFirewall

OutsideFirewall

Internet

Pass web request to Web Service Tier via WebServices and http (typically over Ports 80 [HTTP] and 443 [HTTPS])

Return Security Token

Request Node.WebService

Database: Node Database,

Source DatabasesQuery database (Stored Procedure with Parameters)

Return result set

```

Outside User NAAS Web Service

Auth,UserMgr,Policy

Web Server(Application Server)

with IIS

Web Service Tier

DatabaseServer

Database Tier

Data DataData

Call NAAS Web Service

Connect toProxy Server

Pass Security Token

Web Tier

Web Service: Node.WebServicesWindows Service: Node.Task (schedule to run Node.WebServices)Web Application (Node.Administration, Node.Client) could be installed on Inner Network which can access Database Server

Port 80 (HTTP) / 443 (HTTPS)

Port 80 (HTTP) / 443 (HTTPS)

1

105

4

2 9

6

8

7

Return Node Query/Solicit Result

Pass Node Query/Solicit Result

Database FirewallPort 1433 (MS SQL Server), or any other port necessary to communicate with database

SWIMS communication to Databases through Inner Firewall

Recommended to use Microsoft ISA Server 2006 to support both Proxy and Reverse Proxy

Proxy Server(and Reverse Proxy)

3

STORET/WQX User’s Conference – 11/28/07 Austin, Texas 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”

STORET/WQX User’s Conference – 11/28/07 Austin, Texas 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

STORET/WQX User’s Conference – 11/28/07 Austin, Texas 10

SWIMS Home Page for System Administrator

STORET/WQX User’s Conference – 11/28/07 Austin, Texas 11

SWIMS Data Submission Options

STORET/WQX User’s Conference – 11/28/07 Austin, Texas 12

SWIMS Configurable Automated Validation

STORET/WQX User’s Conference – 11/28/07 Austin, Texas 13

SWIMS Administrator Review

STORET/WQX User’s Conference – 11/28/07 Austin, Texas 14

SWIMS State Admin Functions

Acknowledgements RI–DEM

Alisa RichardsonDeb MerrillConnie CareyEric SchneiderPam Galli

Deric Long &enfoTech Systems Development Team

Funded by aNational

Environmental Information Exchange

Network (NEIEN) Grant

Questions?

Contact: Eric Schneider at eric.schneider@dem.ri.govDeric Long at deric_long@enfotech.com