surface water quality monitoring information system swqmis
Skip this Video
Download Presentation
Surface Water Quality Monitoring Information System (SWQMIS)

Loading in 2 Seconds...

play fullscreen
1 / 45

Surface Water Quality Monitoring Information System (SWQMIS) - PowerPoint PPT Presentation

  • Uploaded on

Surface Water Quality Monitoring Information System (SWQMIS) . Cindi Atwood Tetra Tech, Inc. (703) 385-6000 [email protected] Nancy Ragland TCEQ (512) 239-6546 [email protected] TCEQ’s New Enterprise Data System for Managing Ambient Water Quality Data . Benefits.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Surface Water Quality Monitoring Information System (SWQMIS)' - von

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
surface water quality monitoring information system swqmis

Surface Water Quality Monitoring Information System (SWQMIS)

Cindi Atwood

Tetra Tech, Inc.

(703) 385-6000

[email protected]

Nancy Ragland


(512) 239-6546

[email protected]

  • Consolidate and centralize data
  • Increase data consistency and integrity
  • Assist your agency with internal and external data requests
  • Help management to turn around urgent, high priority requests quickly
  • Save time and money
one week vs one day
One Week vs One Day
  • 44 Hours down to 8 Hours
  • 2 person task down to a 1 person task
system deployment7
System Deployment
  • Deployed the system successfully in early 2007
  • Developed the system as:
    • Web-based
    • J2EE and Oracle
  • Integrated the system with web-based GIS functionalities using ESRI ArcIMS and ArcSDE
core system modules
Core System Modules
  • Monitoring Stations
  • Equipment
  • Geographical Areas
  • Constituents
  • Sampling
  • Comparison Information
  • Projects
  • Reports and Extracts
  • Maps (GIS)
  • Assessment
  • Administration
manage ambient water quality data10
Manage Ambient Water Quality Data
  • Organize data in a way that enhances business processes
  • Protect data integrity through clean system design
  • Involve stakeholders at all levels of organization in design and test
  • Keep system flexible to meet future needs
consolidate centralize databases12
Consolidate & Centralize Databases
  • Allow core data submittal from various data owners
  • Consolidate and centralize databases containing :
    • Field measurements
      • Toxics and organics in a variety of media
      • Biological
      • Habitat parameters, etc.
    • Spatial data
various data sources14
Various Data Sources
  • Supply custom interfaces for manual entry
    • Administrators
    • Data Managers
    • Field Personnel
    • Assessors
  • Provide mass data loaders for various data sources including
    • Continuous data from data loggers
    • LIMS
    • USGS
    • River and municipal authorities in Texas
data integrity16
Data Integrity
  • Provide custom interfaces for manual entry
  • Enforce consistent data entry of all types of data
    • Typographical errors
    • Outlier checks
  • Validate data from manual and mass loaded data
  • Review of submitted data by data managers to approve or deny
mass loaded data validation
Mass Loaded Data Validation
  • The automated validation checks are all run, without stopping after the first “failure.”  In this way, a complete list of errors can be shown.
  • Over 50 validation checks run on mass loaded data
    • Check for outliers.  Check measurements against predefined ranges (min/max).  Compares verify flag in the Results file to see if the outlier value has already been verified by the collector.
    • If sample collected when raining or has rained within the last 24 hours, report a value of <1.  In other words, is days since precipitation (72053) < 1?
    • Check for duplicates in data set based on station ID, sample date, sample time, and parameter code.
gis integration19
GIS Integration
  • Allow map-based creation of sites
  • Automatically assign geographic attributes such as basin, county and ecoregion to a site
  • Provide map-based search and reporting features
  • Synchronize geographic data with tabular data
public access23
Public Access
  • Allow the public and other organizations to retrieve water quality data
public access drill down
Public Access – Drill Down

100 x 100

Mile Square

public access drill down27
Public Access – Drill Down

6.25 x 6.25

Mile Square

reports data extractions32
Reports & Data Extractions
  • Avaliable in:
    • HTML
    • CSV (Comma Separated Values)
    • Pipe delimited “|” (text) format
reports data extractions33
Reports & Data Extractions

Station Inventory Report

reports data extractions34
Reports & Data Extractions

Sampling History Report

  • Integrates SWQMIS with the statistical SAS tools in order to:
    • Summarize data
    • Calculate various statistics
    • Provide reports for assessors
assessments business logic
Assessments – Business Logic
  • Identify and convert preferred parameters to correct units
  • Handle profile samples appropriately
    • Identification of the mixed surface layer
  • Summarize data and calculate statistics
    • Mean, geometric mean, median, standard deviation, percentiles, confidence intervals
assessments business logic cont
Assessments – Business Logic (cont.)
  • Determine appropriate criteria and identify exceedances
    • Basin-specific
    • Segment-specific
    • Site-specific
    • Formulas (acute & chronic metals)
  • Ascertain waterbody’s support status
  • Provide full documentation for all steps of the process
data flow41
Data Flow
  • Transfer of core data to EPA automatically on a periodic basis through web services and the Central Data Exchange (CDX via the Water Quality Exchange (WQX)
data flow42
Data Flow
  • Actively flowing data to the EPA since September, 2007
  • Fully automated process
  • Currently transfer physical and chemical data
  • Will transfer biological data at a later date
  • Track the “history” of data changes
  • Provide interfaces that allow a database administrator to manage:
    • Users
    • Security
    • Reference data
lessons learned
Lessons Learned
  • Allow design time that is adequate for the scope
  • Employ tried technology
  • Use agile development techniques
  • Start third party integration communication and testing early