![Page 1: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/1.jpg)
STORET Data Query, Extraction and Analysis Tools
Henry B. Manguerra, Tetra Tech, Inc.
Jim Harris, Utah DWQ
Vaishal Sheth and John Zatrow, Tetra Tech, Inc.
Presented During the 2004 National STORET Users Conference
November 15-17, 2004, New Orleans
![Page 2: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/2.jpg)
System Overview
Internet
STORETDatabase
ThinClient
http, html
RichClient
http, xml, Web Services
WQAUDAIT
• Two alternative technical solutions for accessing data from the STORET database
![Page 3: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/3.jpg)
Utah Data Assessment and Integration Tools (UDAIT)
Internet
ThinClient
UDAIT
STORETDatabase
Data Views
GIS
Example Implementation: UDAIT: Provide Utah
DWQ staff easy access to water quality data to support TMDL development
![Page 4: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/4.jpg)
UDAIT - Demo
![Page 5: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/5.jpg)
![Page 6: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/6.jpg)
![Page 7: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/7.jpg)
![Page 8: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/8.jpg)
![Page 9: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/9.jpg)
![Page 10: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/10.jpg)
![Page 11: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/11.jpg)
![Page 12: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/12.jpg)
![Page 13: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/13.jpg)
![Page 14: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/14.jpg)
![Page 15: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/15.jpg)
![Page 16: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/16.jpg)
![Page 17: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/17.jpg)
![Page 18: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/18.jpg)
![Page 19: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/19.jpg)
Desktop Analysis Tools
Internet
ThinClient
UDAIT
STORETDatabase
GIS
Data Views
Data Extract/Import
UWQDAT
Utah BASINS
![Page 20: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/20.jpg)
UWQDAT – Demo
![Page 21: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/21.jpg)
![Page 22: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/22.jpg)
![Page 23: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/23.jpg)
![Page 24: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/24.jpg)
![Page 25: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/25.jpg)
![Page 26: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/26.jpg)
![Page 27: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/27.jpg)
![Page 28: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/28.jpg)
![Page 29: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/29.jpg)
Water Quality Analyzer (WQA) – Rich Client
Internet
RichClient
WQA
STORETDatabase
GIS
XML Files
Example Implementation: El Paso, Colorado:
Provide El Paso County a standalone application that contains their data (gis, wq data, wq standards) and perform analysis.
XML, ArcXML
![Page 30: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/30.jpg)
WQA - Demo
![Page 31: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/31.jpg)
Step 1 – Choose a Study Area
![Page 32: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/32.jpg)
Step 2 – Build a Project
![Page 33: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/33.jpg)
Step 3 – Review Data
![Page 34: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/34.jpg)
Step 4 – Calculate Impairments
![Page 35: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/35.jpg)
Step 5 – Inspect Output
![Page 36: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/36.jpg)
Step 6 – Export Results
![Page 37: STORET Data Query, Extraction and Analysis Tools Henry B. Manguerra, Tetra Tech, Inc. Jim Harris, Utah DWQ Vaishal Sheth and John Zatrow, Tetra Tech, Inc](https://reader035.vdocuments.us/reader035/viewer/2022081603/5697c0271a28abf838cd63e1/html5/thumbnails/37.jpg)
Summary Thin Client (UDAIT) Rich Client (WQA)
Query/Extract Provided mainly to allow users to quickly identify availability of data before downloading. Data is downloaded as text files.
Data is immediately downloaded to the desktop for the selected area of interest. All queries are performed on the local database
Analysis May require additional desktop analysis tools (e.g., ArcView, MS Excel) to perform more rigorous analysis not provided by the thin client (i.e., multiple tools)
Customized and included in the rich client (i.e., single package)
Technology JSP, Java MapObjects (Java Edition), XML
Internet Connection Requires continuous access As needed