surface water quality monitoring information system swqmis
Download
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


  • 149 Views
  • 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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
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

TCEQ

(512) 239-6546

[email protected]

benefits4
Benefits
  • 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

assessments36
Assessments
  • 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
administration44
Administration
  • 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
ad