# Presentation: 799918

## STORET 1001 and theState of Utah Monitoring Strategy

- Today you will see:
- What kind of attributes are available in STORET
- How results, stations, and projects are related in STORET
- How metadata is related to results
- How QA/QC results are related to other results
- How STORET can accommodate monitoring programs sampling analysis plans
- How biological monitoring programs can be accommodated in STORET

## State of Utah Monitoring Strategy

## 	TABLE OF CONTENTS

** **
** **
- Overview of the Division of Water Quality’s 2004-2005  Water Quality Monitoring Program	1
- Stream Monitoring	1
- Lake/Reservoir Sampling	2
- Point Source Monitoring	2
- Municipal and Industrial Discharge Monitoring	2
- Waste Load Allocation 	2
- Nonpoint Source Monitoring	2
- Ground Water Monitoring	3
- Cooperative Monitoring Programs	3
- Total Maximum Daily Load Analysis Monitoring	3
- Benthic Macroinvertebrate Sampling	3
- Previous Water Quality Monitoring	4
- Synopsis of Water Quality Monitoring	5
- Stream Monitoring Program	5
- Lake/Reservoir Water Quality Assessment Program	7
- Municipal and Industrial (Point Source) Oversight Monitoring	8
- Total Maximum Daily Load Analysis Monitoring Program	9
- Total Maximum Daily Load Program	10
- 319 Nonpoint Source Monitoring Program	11
- Ground Water Monitoring Program	12
- Cooperative Water Quality Monitoring Program	13

**Notes:**
We have several programs which we administer.  We store all the data and all the data types in STORET

## State of Utah Monitoring Strategy

- State is divided into watersheds or areas where we perform monitoring runs.
- We combine several projects on these runs such that we combine sampling for all projects that have monitoring requests in that area.
- Long term
- Non point source
- Waste load allocation
- UPDES
- etc

## State of Utah Monitoring Strategy

**Notes:**
On the right you can see the list of sites associated with part of this run and on the left you can see the list of projects these sites are associated with in STORET.
The page on the right is not generated with any software in STORET it was generated by in house efforts
This is one area were we built custom applications that rely on the STORET Tables

## State of Utah Monitoring Strategy

**Notes:**
This is how that data looks in STORET interface.   The picture on the right shows the trip id, the trip name, and lists the station visits that were made during that run.  The picture on the left is a different view of the same trip.  Please note it shows activities associated with station visits and trip blanks associated with trip.  You can also associate trip blanks with specific samples on a trip if you so desire.  I will show you how you can group these results either by type, spatially or temporally.

## Slide 7

**Notes:**
On the right I am drilling down into a station visit and as you can see there were two activities that took place during this station visit.  You can have numerous activities associated with a station visit.  In this case we performed some field measurements and a water sampling event.
On the left you can see what sort of meta data you can store with a Field msr/obs activity.  Of course if it was a different Activity type different sets of buttons would be accessible. Please note the Document Graphic button on the bottom left hand of the field activity screen.  If you wanted you could associate a picture or document of just about anything with this activity.  You can also store associate blobs with a plethora of other “points” in the data base

## State of Utah Monitoring Strategy

**Notes:**
Looking at the sample activity for this station visit we can select the results tab to produce what results have been associated with this activity.  The usual suspects are there on the left.  On the right you see the actual result screen associated with BOD and obviously there is plenty of places here where you could add any data necessary for this chemical result.  The screens are different for physical or other different data types.  Again note the Graphic capabilities.  I handle my duplicate data by changing the value status from final to preliminary.  Preliminary data is not available on the web.

## State of Utah Monitoring Strategy

**Notes:**
These two screens that were at the bottom of the activity result screen provide a means of associating methodology and laboratory information with a result.

## State of Utah Monitoring Strategy

**Notes:**
Like your power yoga teacher tells you, breath deep.  It will help keep you focused.  I just showed you the very basics of one way to store a result in STORET.  I am sure you have a lot of questions, but I just don’t have time to do that.  I do want to show you how I organize other types of monitoring activities.  I am going to stick to the standard field msr/obs and samples in the next example of my lake data. 

## State of Utah Monitoring Strategy

- On any given waterbody, at least one site will be established as the primary deep site.  This site will represent the deepest point for the water body and may not always be the site next to the dam.  At this site all physical parameters, nutrient parameters and field tests including dissolved oxygen and temperature profiles will be gathered.  This site will also be defined as the site where metal and chemistry parameters will be obtained if those parameters are required.  In addition, phytoplankton sampling will occur at this site.  Depending on the depth of this site, a protocol for sampling will be selected.  If the site is deeper than five meters then at least four sampling intervals (surface, two intermediate depths, and a bottom sample) will be defined.  If a thermocline exists then the intermediate samples will be from above and below the thermocline.  If there is no established thermocline then the intervals will be defined equally throughout the waterbody.  Water from the surface sample will be collected and analyzed for nutrient parameters, chlorophyll-a, bacteriological parameters and for the following chemistry parameters:  total alkalinity, volatile suspended solids, residual suspended solids, sodium, potassium, calcium, magnesium, sulfate, chloride, silica, total dissolved solids, and turbidity (NTU).  During the second sampling period (August/September), phytoplankton samples will be sampled and processed at this sample site.  The two intermediate water column samples will be collected and analyzed for nutrient parameters.  Water from the bottom will be collected and analyzed for nutrients, metals and total hardness.  Sediment samples will be collected for metal analysis.  In addition, field (physical) data (temperature, conductivity, pH, and dissolved oxygen) will be obtained at one meter intervals throughout the entire water column and a secchi depth (meters) obtained and reported for this site.

**Notes:**
This is our protocol for sampling what we call a primary lake site.  You will not be tested on this.  The important point here is that we take samples form four different depths at one lake site.  We also take a lake “profile” at the site.  To Utah a lake profile is measurement of field parameters at one meter intervals from the surface to the bottom.

## State of Utah Monitoring Strategy

**Notes:**
On the right is a visit screen associated with “lake run” .  Please note that the station visit above the one highlighted it is actually a blind duplicate.  I will show you how I handle duplicates later.  By selecting the highlighted station visit, the screen on the right appears.  This screen allows you to navigate to basic station visit info, activities associated with this station visit, or it allows you to group activities associated with a station visit.  There are number of ways to group activities in STORET, the example I am going to show is one way to group activities spatially.

## State of Utah Monitoring Strategy

**Notes:**
I have organized these according to a numbering system that for lakes goes from 21 to 29, 21 being the surface, 29 the bottom, 23 and 27 generally above and below the thermo cline.  As you can see I have grouped the field activities with their appropriate water samples.  I am assuming you all realize why I would try tie activities together.

## State of Utah Monitoring Strategy

**Notes:**
The screen on the left shows you what kind of data I could enter about where in the water column the sample was collected, in this case it was from the bottom which was also at 37.1 meters.  The screen on the right shows you which personnel I have associated with that activity.

## State of Utah Monitoring Strategy

**Notes:**
On the left is the activity screen for this station visit, and we see the eight activities that were on the were grouped together on the previous screens and we also see one more, the portable data logger activity is also listed.  The right shows the results from one of the lines on this logger, it just so happens to be at the bottom and is therefore the last line.

## State of Utah Monitoring Strategy

**Notes:**
I’ve shown you one way to organize spatially separated samples in STORET, and and example of a portable data logger activity.  I would like to entertain some questions at this time about chemical results.  Any Questions.  Lets move on to biological data specifically taxon abundance and single taxon group summary data.

## State of Utah Monitoring Strategy

**Notes:**
On the right is the activity list for a sample visit, this is the third time you’ve seen this list so it should be familiar.  Please note this is the same lake station we saw before, but a sampling event three years earlier.  The eight activities that are associated with water sampling at four different depths are there, as well as the lake profile.  What is new is the sample with a biological medium that has an activity category of Integrated vertical profile.  That is my phytoplankton sample.  Selecting it takes me to the field activity menu we have already seen for field msr/obs, but this time there are some other buttons available for us to use.  I would like to look two of those buttons first. The Sample collection procedures and The sample Preservation screens.

## State of Utah Monitoring Strategy

**Notes:**
On the right is the procedure used and gear associated with our collection of a phytoplankton sample.  On the left are details on the bottles and preservation used for the sample.

## State of Utah Monitoring Strategy

- There are four types of biological groups in STORET the two groups not shown are
- Single taxon frequency classes
- Single taxon individuals

**Notes:**
Getting into the results of the phytoplankton sample you can see we have two group types out of the four available in STORET.  These group types allow you to do everything you would probably want to do with the intent of taxon abundance. I would like to use the example of fish here so you get the idea.  First you could go electroshock a bunch of fish. Store each one in STORET.  Then you could store the summary data on each taxon, store the frequency data on each taxon, and then store the multi-taxa population census all under the same visit in the same data base.  Now for my phytoplankton sampling event.

## State of Utah Monitoring Strategy

**Notes:**
On the right is the data associated with the population census.  Please note all the “metadata” you can include for each count.  On the left is group summary statistics that I chose to include.  What is missing from this data set?  Habitat Assessment is missing.

## State of Utah Monitoring Strategy

- Habitat Assessment
- All EMAP protocols are available in STORET
- All EPA Rapid bioassesment  protocols are available in STORET
- You can make your own habitat assessments characteristics in STORET

**Notes:**
I wish I had some habitat assessment data to show you.  I do have data electronically stored that I will be loading into STORET in the near future.  We would be happy to show you some in Room ???? where we have set up 5 work stations for your use.  It will help you become more familiar with STORET if you actually punch the buttons.  For now I want to understand that habitat assessment is one of the more flexible areas of STORET because it allows you to customize assessments to your methodologies.

## State of Utah Monitoring Strategy&STORET

- It is a big leap of faith to use STORET as your primary data storage tool.
- The task of designing a database to handle all the different types of data involved in water quality assessments was daunting.
- STORET has remained dynamic, and will change with changing technology and assessment techniques.

## State of Utah Monitoring Strategy

## State of Utah Monitoring Strategy