# Presentation: 125886

## Slide 1

## The Region 10 STORET Legacy System Provides for Dynamic Real-Time Analysis of Legacy STORET Data via the Web  

_***Go Dynamically From:***_
***  ******Interactive Web Maps of STORET Stations ***
*** ******To Detailed Raw or Summary STORET Legacy Data  ***
*** ******To Reports and Charts of the Data Within a Web Browser ***
***	******	******	******	***_***On the Fly Within Seconds!***_*** ***

***What Does It Do?****** ***

## How is this accomplished? 

***By Creating:***
***The STORET Legacy Data Warehouse ***
-  A database with over **90 Million** Records of Grab, Composite, and  Invent  Data
-  Over **375,000** STORET Stations with data from Regions 4, 9, and 10 (17 States)
-  Specifically designed for extremely quick querying and access
*** ******The STORET Legacy Mapping Application***
-  A web-enabled interactive mapping application
-  Displays the locations of the STORET stations in the STORET Legacy Data Warehouse
-  There is a direct link to and from the data warehouse through a web page
***The STORET Legacy Web Query Interface***
-  Sends/accepts calls to/from the STORET Legacy Mapping Application
-  Builds custom data warehouse queries for the user
-  Saves query output in tabular format
-  Allows the user to create reports and charts on the fly within the web browser

## What does the user do?

** ****Open the STORET **
**Legacy  Mapping **
**Application**

**Click on  a STORET **
**Station with the mouse**

**The Map Click **
**Launches STORET **
**Legacy Query**
**Interface and **
**Supplies It with **
**the Station**

**The Query Interface **
**Dynamically Queries**
**The STORET Data Warehouse**

***What does the user do?***

_***Dynamic Data Analysis For STORET!***_*** ***

## The Remainder of This Presentation:

**An Example of the Mapping Application (since we are unable to connect to our server for a live demo)**
**Examples of the STORET Legacy Data Warehouse  and Query Interface**
**Discussion of the Data Warehouse Structure**
**Live Queries of the Data Warehouse If Time Permits **

## Open Mapping Application 

***Open Mapping Application ***

- Table of
- Contents
- Frame

- Map
- Frame

- Legend
- Frame

- Toolbar
- Frame

## Notice the Clickable Layers and Scale-Dependent Information 

- Notice the additional map detail as you zoom in you see more detailed streams, roads, sub-basin boundaries, etc...

- Notice the additional map layers in the table of contents that can be added to the map.

***Notice the Clickable Layers and Scale-Dependent Information ***

## Add Detail to the Map 

***Add Detail to the Map ***

## Get Summary Information About a STORET Station

- The STORET Surface Stations are labeled in red, the USGS gages are blue.

***Get Summary Information About a STORET Station***

## Pass Station Information to the STORET Legacy Data Warehouse

***Pass Station Information to the STORET Legacy Data Warehouse***

## Query the STORET Legacy Data Warehouse

***Query the STORET Legacy Data Warehouse***

## View the Results Within the Web Browser

**Within Seconds, Search Through **_***8+ Million Records***_** and View the Tabular Output in the Web Page**

***View the Results Within the Web Browser***