ng shell creek data powerpoint 2009
DESCRIPTION
Data collected from Shell Creek in Nebraska by the 2009 Newman Grove Shell Creek Watershed team.TRANSCRIPT
1
2
2009 Shell Creek Watershed Study
Advisors – Mark Seier & Suzy Goedeken
Researchers –Katie O’Brien, Olivia Wiese, Jonathon Dohmen, Jake Kaufman, Mark O’Brien, April Ramaekers, Aubrey Strong, Audrey Wondercheck, Greg Roberg, Lila Wondercheck, Kendra Nelson, Ciera Afrank, Alisha Dunlap, Joan O’Brien
3
(with Township-Range Labels)
Shell Creek and Loseke-Taylor Creek Watersheds
Lower Platte North Natural Resources District
6
4
Site 1
5
Site 2
6
Site 3
7
Site 4
8
Site 6
9
Site 5
10
W.Q.I.
• The Water Quality Index was developed by the National Sanitation Foundation as a standard system to compare different bodies of water.
• To determine the WQI, a series of nine tests were performed. These tests were: dissolved oxygen, fecal coliform, pH, Biological Oxygen Demand (BOD), temperature, total phosphate, nitrates, turbidity, and total solids. We also did a water discharge test which we use to measure the flow of the creek in cubic feet per second.
11
• After the tests are completed, the WQI for each section of the creek can be computed.
• To formulate the WQI, we first computed Q-values.
• We multiply this number by a weighting factor, which provides a measure of the relative importance of each test to overall water quality.
• The water quality index ranges from zero to 100.
- 0 - 25 is very bad - 25 - 50 is bad - 50 - 70 is medium - 70 - 90 is good- 90 - 100 is excellent
• The bio-indicator tests weren’t part of W.Q.I., but did give us a water quality rating.
12
Sample W.Q.I. Curve Chart
13
Sample W.Q.I. Form
Test Results Q-valueWeighting
FactorT o t a l
DO % sat. 0.17 Fecal Coliform col/100 mL 0.16
pH units 0.11 BOD mg/L 0.11
Temperature change in C 0.1 Total Phosphate mg/L 0.1
Nitrates mg/L 0.1 Turbidity JTU 0.08
Total Solids mg/L 0.07
Overall Water Quality Index ___
14
May June July August0
1
2
3
4
5
6
2009 Precipitation
Rainfall
Inch
es
15
May 22 June 23 July 23 August 6
6.3
6.6
6.9
7.2
7.5
7.8
8.1
8.4
pH
Site 1
Site 2
Site 3
Site 4
Site 5
Site 6
Date
pH
Level
16
May22 June 23 July 23 August 6
-3
-2.5
-2
-1.5
-1
-0.5
0
0.5
1
1.5
Change in Water Temperature
Site 1
Site 2
Site 3
Site 4
Site 5
Site 6
Date
Deg
rees C
elc
ius
The higher the change, the worse the water quality.
17
May 22 June 23 July 23 August 60
500
1000
1500
2000
2500
3000
3500
4000 Total Solids
Site 1
Site 2
Site 3
Site 4
Site 5
Site 6
Date
mg
/L
The higher the concentration, the worse the water quality.
18
Fecal Coliform
19
May 22 June 23 July 23 August 60
200
400
600
800
1000
1200Fecal Coliform
Site 1
Site 2
Site 3
Site 4
Site 5
Site 6
Date
colo
nie
s/1
00
mL
20
2003 2004 2005 2006 2007 2008 20090
200
400
600
800
1000
1200
1400
1600Fecal Coliform
Site 1
Site 2
Site 3
Site 4
Site 5
Site 6
Date
colo
nie
s/1
00
mL
In 2006 Site 1- 21,418Site 5- 17,800
21
May 22 June 23 July 23 August 60
10
20
30
40
50
60
70
80Flow
Site 1
Site 2
Site 3
Site 4
Site 5
Site 6
Date
Cu
bic
feet
per
secon
d
22
May 22 June 23 July 23 August 60
500
1000
1500
2000
2500Turbidity
Site 1
Site 2
Site 3
Site 4
Site 5
Site 6
Date
JTU
's
23
Turbidity On July 23, 2009
24
May 22 June 23 July 23 August 60
10
20
30
40
50
60
70
80
90
100
Dissolved Oxygen
Site 1
Site 2
Site 3
Site 4
Site 5
Site 6
Date
% S
atu
rati
on
25
May 22 June 23 July 23 August 60
1
2
3
4
5
6
7
85 Day Biological Oxygen Demand
Site 1
Site 2
Site 3
Site 4
Site 5
Site 6
Date
pp
m
The higher the change, the worse the water quality.
26
May 22 June 23 July 23 August 60
5
10
15
20
25
30
35
40
45
50Nitrates
Site 1
Site 2
Site 3
Site 4
Site 5
Site 6
Date
pp
m
27
2002 2003 2004 2005 2006 2007 2008 20090
10
20
30
40
50
60
Nitrates
Site 1
Site 2
Site 3
Site 4
Site 5
Site 6
Date
pp
m
28
May 22 June 23 July 23 August 60
0.5
1
1.5
2
2.5
3Phosphates
Site 1
Site 2
Site 3
Site 4
Site 5
Site 6
Date
pp
m
29
Site 1 Site 2 Site 3 Site 4 Site 6 Site 545
50
55
60
65
70
WQI Averages by Site
2003 Averages 2004 Averages 2005 Averages 2006 Averages
2007 Averages 2008 Averages 2009 Averages
WQ
I Medium
Bad
Good
30
2003 2004 2005 2006 2007 2008 200945
50
55
60
65
70
Total WQI Averages by Year
WQI
WQ
I
Good
Bad
Medium
31
May June July August45
50
55
60
65
70
WQI Averages by Date
2003 Averages 2004 Averages 2005 Averages
2006 Averages 2007 Averages 2008 Averages
2009 Averages
Month
WQ
I
Bad
Medium
Good
32
Total Rainfall Inches
Discharge CFS
Nitrates ppm pH 0
5
10
15
20
25
302003 - 2009 Chemical Test Average Compar-
isons
2003 Averages
2004 Averages
2005 Averages
2006 Averages
2007 Averages
2008 Averages
2009 Averages
33
Phosphates ppm B.O.D. ppm Change in Temp. Celcius
0
0.5
1
1.5
2
2.5
32003 - 2009 Chemical Test Average Comparisons
2003 Averages
2004 Averages
2005 Averages
2006 Averages
2007 Averages
2008 Averages
2009 Averages
34
D.O. % Sat. Turbidity JTU Fecal Coliform Colonies/100
mL
Total Solids mg/L
0
200
400
600
800
1000
1200
2003 - 2009 Chemical Test Average Comparisons
2003 Averages
2004 Averages
2005 Averages
2006 Averages
2007 Averages
2008 Averages
2009 Averages
*2006 Fecal Coliform Average 8,058 col/100 mL
Chemical Test Conclusions
• Fecal Coliform is down, but still erratic
• Less Rainfall seems to effect our data• Site 1 has significantly higher
nitrates• WQI is increasing downstream• D.O. is still low• Very high correlation between
nitrates and flow35
36
Macro Invertebrates
TolerantSomewhat Sensitive
Sensitive
37
Sample Bio-Indicator Data Form
38
Beaver-Shell Creek WQI Comparison
May-09 Jun-09 Jul-09 Aug-09 Sum-mer
Aver-age 09
Sum-mer
Aver-age 08
0
10
20
30
40
50
60
70
80
Beaver Creek Average WQI
Shell Creek Average WQIWQI
39
Beaver-Shell Creek Comparison
pH Nitrates Phos-phates
B.O.D0
2
4
6
8
10
12
14
Beaver CreekShell Creek
40
Beaver-Shell Creek Comparison
Turbidity Fecal Col-iform
Total Solids
D.O. % Sat.
0
100
200
300
400
500
600
700
800
Beaver CreekShell Creek
41
Flood Study
42
Flood StudyDate and Time
Width (ft)
Avg. Depth (ft)
Flow (cfs)
Total Solids(mg/L)
SolidDischarge (lbs/min)
SolidDischarge (tons/hr)
5/30/07 110 8.42 2243 9300 78145 2344
6/8/08 130 8.98 4328 8950 145138 4354
X cu ft
60 sec 28.32 L X mg 1 g 1 lb 1 ton 60 min
1 sec 1 min 1 cu ft 1 L 100 mg 453.6 g 2000 lb 1 hr
43Water Testi
ng
44
Chemical
Tests
45
46
Website
• http://www.newman.esu8.org/ • Click “Activities”
• Click “Watershed Project”• Click “Watershed Homepage”
• You can see our data and further information concerning this project,
including pictures.
47
48
Thank You To:• David Rus from USGS
• Lower Platte North Natural Resource District
• PrairieLand RC&D
• Natural Resource Conservation Service
• Nebraska Department of Environmental Quality
• Shell Creek Watershed
Improvement Group
• Chris Poole
• Phil Chvala
• Area Land Owners
• United States Geographical Survey
• University of Nebraska Extension Service
• Newman Grove Public Schools
The End