ng shell creek data powerpoint 2004
TRANSCRIPT
1
Advisor- Mark SeierResearchers- Amanda Gasper, Courtney Bennett, Cody Nelsen, Melissa Gasper, Abbie Finkral, Brittany Pieke, Katie Dunlap, Kelly Dunlap, Sarah O’Brien, Tom O’Brien, Kali Roundy, Laura Johnson, Cody Benson, & Heather Schmidt
2004 Shell Creek Watershed Study
2
1 2
34
5
3
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.
4
• 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. Zero to 25 is very bad. 25 to 50 is bad. 50 to 70 is medium. 70 to 90 is good, and 90 to 100 is excellent.
• The bio-indicator tests weren’t part of W.Q.I., but did give us a water quality rating.
5
Sample W.Q.I. Curve Chart
6
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 ___
7
Test Natural Readings Cautionary Readings
Dissolved Oxygen % Saturation
90% or higher Below 90% unless the waters are supersaturated due to cultural eutrophication.
pH 6.5-8.5 Below 6.5Above 8.5
Nitrates 0.0-1.0 ppm Consistent readings above 3.5 ppm
Change in Temperature
The higher the change, the worse the water quality.
Turbidity 0-8 JTU’s Increasing trends in turbidity measurements.
8
Test Natural Readings Cautionary Readings
5 Day B.O.D The higher the difference between the original and the 5 day reading, the worse the water.
Phosphates Less than 1 mg/L More than 1 mg/L
Total Solids The higher the concentration, the worse the water.
Fecal Coliform Over 200 colonies/100 mL of water
9
pH Change in Water Temp.
Degrees Celsius
Total Solids mg/L
Fecal ColiformCol./100
mL
Discharge cubic
ft./sec.
May 31 Site 1 7.7 0.4 490 0 NA
Site 2 7.6 0.3 640 80 NA
Site 3 7.7 -0.2 1030 20 NA
Site 4 8 0.7 1920 0 NA
Site 5 8.5 0 9310 0 NA
June 23 & 24
Site 1 8.05 0.05 570 1050 2.71
Site 2 7.85 -0.15 390 150 1.51
Site 3 8.05 -0.2 500 300 6.02
Site 4 8.05 0.3 620 200 6.55
Site 5 8 -0.6 710 1125 30
10
Turbidity JTU’s
Dissolved Oxygen % Saturation
Dissolved Oxygen
ppm
5 Day B.O.D.
Nitratesppm
Phosphatesppm
May 31 Site 1 200 34% 3.4 2.9 22.2 2
Site 2 360 26% 2.7 0 3.3 .82
Site 3 560 18% 1.8 0 2.2 .94
Site 4 960 12% 0.7 0 2.2 .99
Site 5 800 30% 2.9 0 12.9 .81
June 23 & 24
Site 1 62.5 59% 5.6 1.8 10.17 1.29
Site 2 37.5 38.5% 3.6 1.4 5.11 .38
Site 3 45 65.5% 6 1.2 9.68 .47
Site 4 50 49.5% 4.5 0 12.57 .52
Site 5 140 44% 4 2.7 9.77 .59
11
pH Change in Water Temp.
Degrees Celsius
Total Solids mg/L
Fecal ColiformCol./100
mL
Discharge cubic
ft./sec.
July 21 & 22
Site 1 8 0.8 460 500 1.96
Site 2 7.8 1.2 415 450 1.07
Site 3 8.2 0 335 600 6.54
Site 4 7.5 0.8 310 200 6.91
Site 5 8 0.8 3215 250 20.6
August 12 & 13
Site 1 7.9 -0.6 250 50 3.688
Site 2 7.75 2 250 650 0.945
Site 3 7.95 -0.2 250 400 3.108
Site 4 8.05 0.3 250 100 3.572
Site 5 8.2 0.4 850 250 9.159
12
Turbidity JTU’s
Dissolved Oxygen % Saturation
Dissolved Oxygen
ppm
5 Day B.O.D.
Nitrates Phosphates
July 21 & 22
Site 1 42.5 56% 4.7 1.9 22.05 1.12
Site 2 47.5 36% 3 0 9.37 0.42
Site 3 32.5 46% 3.7 1.8 9.73 0.35
Site 4 27.5 65% 5.2 3.8 9.17 0.69
Site 5 80 87% 7.2 6.3 6.21 0.79
August 12 & 13
Site 1 35 68% 6.65 2.5 6.16 0.58
Site 2 25 58% 5.7 1.6 3.08 0.53
Site 3 47.5 70% 6.75 2.6 7.61 0.38
Site 4 15 86% 8.25 3 6.53 0.13
Site 5 65 69.5% 6.65 2.5 11.92 0.98
13
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 27 0.17 4.59Fecal Coliform
Col./100mL 97 0.16 15.52
pH Units 92 0.11 10.12B.O.D. Mg/L 67 0.11 7.37Temp. Change in o C 92 0.10 9.20Phosphates Mg/L 26 0.10 2.60Nitrates Mg/L 35 0.10 3.50Turbidity JTU 5 0.08 0.40Total Solids Mg/L 32 0.07 2.24
Overall Water Quality Index 55.54(medium)
May 31 Site 1
14
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 17 0.17 2.89Fecal Coliform
Col./100mL 46 0.16 7.36
pH Units 91 0.11 10.01B.O.D. Mg/L 98 0.11 10.78Temp. Change in o C 91 0.10 9.10Phosphates Mg/L 42 0.10 4.20Nitrates Mg/L 95 0.10 9.50Turbidity JTU 5 0.08 0.40Total Solids Mg/L 20 0.07 1.40
Overall Water Quality Index 55.64(medium)
May 31 Site 2
15
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 10 0.17 1.70Fecal Coliform
Col./100mL 62 0.16 9.92
pH Units 92 0.11 10.12B.O.D. Mg/L 98 0.11 10.78Temp. Change in o C 90 0.10 9.00Phosphates Mg/L 41 0.10 4.10Nitrates Mg/L 92 0.10 9.20Turbidity JTU 5 0.08 0.40Total Solids Mg/L 20 0.07 1.40
Overall Water Quality Index 56.62(medium)
May 31 Site 3
16
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 8 0.17 1.36Fecal Coliform
Col./100mL 97 0.16 15.52
pH Units 82 0.11 9.02B.O.D. Mg/L 98 0.11 10.78Temp. Change in o C 91 0.10 9.10Phosphates Mg/L 41 0.10 4.10Nitrates Mg/L 92 0.10 9.20Turbidity JTU 5 0.08 0.40Total Solids Mg/L 20 0.07 1.40
Overall Water Quality Index 60.88(medium)
May 31 Site 4
17
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 20 0.17 3.40Fecal Coliform
Col./100mL 97 0.16 15.52
pH Units 69 0.11 7.59B.O.D. Mg/L 98 0.11 10.78Temp. Change in o C 92 0.10 9.20Phosphates Mg/L 42 0.10 4.20Nitrates Mg/L 48 0.10 4.80Turbidity JTU 5 0.08 0.40Total Solids Mg/L 20 0.07 1.40
Overall Water Quality Index 57.29(medium)
May 31 Site 5
18
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 56 0.17 9.52Fecal Coliform
Col./100mL 21 0.16 3.36
pH Units 83 0.11 9.13B.O.D. Mg/L 88 0.11 9.68Temp. Change in o C 92 0.10 9.20Phosphates Mg/L 34 0.10 3.40Nitrates Mg/L 50 0.10 5.00Turbidity JTU 31 0.08 2.48Total Solids Mg/L 20 0.07 1.40
Overall Water Quality Index 53.17(medium)
June 23 & 24 Site 1
19
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 28 0.17 4.76Fecal Coliform
Col./100mL 40 0.16 6.40
pH Units 90 0.11 9.90B.O.D. Mg/L 90 0.11 9.90Temp. Change in o C 91 0.10 9.10Phosphates Mg/L 70 0.10 7.00Nitrates Mg/L 61 0.10 6.10Turbidity JTU 47 0.08 3.76Total Solids Mg/L 48 0.07 3.36
Overall Water Quality Index 60.28(medium)
June 23 & 24 Site 2
20
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 65 0.17 11.05Fecal Coliform
Col./100mL 34 0.16 5.44
pH Units 80 0.11 8.80B.O.D. Mg/L 95 0.11 10.45Temp. Change in o C 92 0.10 9.20Phosphates Mg/L 61 0.10 6.10Nitrates Mg/L 51 0.10 5.10Turbidity JTU 41 0.08 3.28Total Solids Mg/L 30 0.07 2.10
Overall Water Quality Index 61.52(medium)
June 23 & 24 Site 3
21
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 46 0.17 7.82Fecal Coliform
Col./100mL 35 0.16 5.60
pH Units 81 0.11 8.91B.O.D. Mg/L 100 0.11 11.00Temp. Change in o C 91 0.10 9.10Phosphates Mg/L 55 0.10 5.50Nitrates Mg/L 47 0.10 4.70Turbidity JTU 39 0.08 3.12Total Solids Mg/L 20 0.07 1.40
Overall Water Quality Index 57.15(medium)
June 23 & 24 Site 4
22
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 38 0.17 6.46Fecal Coliform
Col./100mL 20 0.16 3.20
pH Units 84 0.11 9.24B.O.D. Mg/L 70 0.11 7.70Temp. Change in o C 91 0.10 9.10Phosphates Mg/L 55 0.10 5.50Nitrates Mg/L 52 0.10 5.20Turbidity JTU 5 0.08 0.40Total Solids Mg/L 20 0.07 1.40
Overall Water Quality Index 48.2(bad)
June 23 & 24 Site 5
23
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 94 0.17 15.98Fecal Coliform
Col./100mL 27 0.16 4.32
pH Units 84 0.11 9.24B.O.D. Mg/L 80 0.11 8.80Temp. Change in o C 91 0.10 9.10Phosphates Mg/L 39 0.10 3.90Nitrates Mg/L 35 0.10 3.50Turbidity JTU 44 0.08 3.52Total Solids Mg/L 38 0.07 2.66
Overall Water Quality Index 61.02(medium)
July 21 & 22 Site 1
24
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 25 0.17 4.25Fecal Coliform
Col./100mL 27 0.16 4.32
pH Units 90 0.11 9.90B.O.D. Mg/L 98 0.11 10.78Temp. Change in o C 90 0.10 9.00Phosphates Mg/L 70 0.10 7.00Nitrates Mg/L 52 0.10 5.20Turbidity JTU 40 0.08 3.20Total Solids Mg/L 45 0.07 3.15
Overall Water Quality Index 56.80(medium)
July 21 & 22 Site 2
25
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 40 0.17 6.8Fecal Coliform
Col./100mL 25 0.16 4.00
pH Units 76 0.11 8.36B.O.D. Mg/L 90 0.11 9.90Temp. Change in o C 94 0.10 9.40Phosphates Mg/L 72 0.10 7.20Nitrates Mg/L 52 0.10 5.20Turbidity JTU 51 0.08 4.08Total Solids Mg/L 53 0.07 3.71
Overall Water Quality Index 58.65(medium)
July 21 & 22 Site 3
26
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 67 0.17 11.39Fecal Coliform
Col./100mL 36 0.16 5.76
pH Units 93 0.11 10.23B.O.D. Mg/L 62 0.11 6.82Temp. Change in o C 91 0.10 9.10Phosphates Mg/L 50 0.10 5.00Nitrates Mg/L 53 0.10 5.30Turbidity JTU 56 0.08 4.48Total Solids Mg/L 59 0.07 4.13
Overall Water Quality Index 62.21(medium)
July 21 & 22 Site 4
27
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 95 0.17 16.15Fecal Coliform
Col./100mL 30 0.16 4.80
pH Units 83 0.11 9.13B.O.D. Mg/L 50 0.11 5.50Temp. Change in o C 91 0.10 9.10Phosphates Mg/L 47 0.10 4.70Nitrates Mg/L 60 0.10 6.00Turbidity JTU 25 0.08 2.00Total Solids Mg/L 20 0.07 1.40
Overall Water Quality Index 58.78(medium)
July 21 & 22 Site 5
28
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 71 0.17 12.07Fecal Coliform
Col./100mL 45 0.16 7.20
pH Units 85 0.11 9.35B.O.D. Mg/L 70 0.11 7.70Temp. Change in o C 91 0.10 9.10Phosphates Mg/L 57 0.10 5.70Nitrates Mg/L 60 0.10 6.00Turbidity JTU 48 0.08 3.84Total Solids Mg/L 66 0.07 4.62
Overall Water Quality Index 65.58(medium)
August 12 & 13 Site 1
29
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 55 0.17 9.35Fecal Coliform
Col./100mL 28 0.16 4.48
pH Units 90 0.11 9.90B.O.D. Mg/L 90 0.11 9.90Temp. Change in o C 86 0.10 8.60Phosphates Mg/L 58 0.10 5.80Nitrates Mg/L 90 0.10 9.00Turbidity JTU 57 0.08 4.56Total Solids Mg/L 66 0.07 4.62
Overall Water Quality Index 66.21(medium)
August 12 & 13 Site 2
30
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 75 0.17 12.75Fecal Coliform
Col./100mL 30 0.16 4.80
pH Units 86 0.11 9.46B.O.D. Mg/L 70 0.11 7.70Temp. Change in o C 92 0.10 9.20Phosphates Mg/L 71 0.10 7.10Nitrates Mg/L 57 0.10 5.70Turbidity JTU 40 0.08 3.20Total Solids Mg/L 66 0.07 4.62
Overall Water Quality Index 64.53(medium)
August 12 & 13 Site 3
31
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 94 0.17 15.98Fecal Coliform
Col./100mL 50 0.16 8.00
pH Units 81 0.11 8.91B.O.D. Mg/L 69 0.11 7.59Temp. Change in o C 92 0.10 9.20Phosphates Mg/L 95 0.10 9.50Nitrates Mg/L 60 0.10 6.00Turbidity JTU 67 0.08 5.36Total Solids Mg/L 66 0.07 4.62
Overall Water Quality Index 75.16(good)
August 12 & 13 Site 4
32
Test Results Q-Value Weighting Factor Total
D.O. % Sat. 74 0.17 12.58Fecal Coliform
Col./100mL 53 0.16 8.48
pH Units 74 0.11 8.14B.O.D. Mg/L 70 0.11 7.70Temp. Change in o C 91 0.10 9.10Phosphates Mg/L 41 0.10 4.10Nitrates Mg/L 50 0.10 5.00Turbidity JTU 31 0.08 2.48Total Solids Mg/L 20 0.07 1.40
Overall Water Quality Index 58.98(medium)
August 12 & 13 Site 5
33
2004 Precipitation
0
1
2
3
4
5
6
7
8
9
10
May June July August
Inch
es
Rainfall
34
pH
7
7.5
8
8.5
9
May-31
June23&24
July21&22
August12&13
Date
pH
Lev
el
Site 1
Site 2
Site 3
Site 4
Site 5
35
Change in Water TemperatureDegrees Celsius
-1.0
-0.5
0.0
0.5
1.0
1.5
2.0
Site 1 Site 2 Site 3Site 4 Site 5
May 31 June 23 & 24 July 21 & 22
August 12 & 13
36
Total Solids
02000400060008000
10000
May-
31
June
25&26
July
21&22
August
12&13
Dates
mg
/L
Site 1
Site 2
Site 3
Site 4
Site 5
37
Fecal Coliform
0200400600800
10001200
May
-31
June
23&
24
July
21&22
Augus
t 12&
13
Dates
Co
lon
ies
pe
r 1
00
mL
Site 1
Site 2
Site 3
Site 4
Site 5
38
Fecal Coliform
39
Flow
05
101520253035
June23&24
July21&22
August12&13
Dates
Cu
bic
Fe
et
pe
r S
ec
on
d
Site 1
Site 2
Site 3
Site 4
Site 5
40
Turbidity
0200400600800
10001200
May-31 June23&24
July21&22
August12&13
Dates
JTU
's Site 1
Site 2
Site 3
Site 4
Site 5
41
Dissolved Oxygen
0
2
4
6
8
10
May-31 June23&24
July21&22
August12&13
Date
ppm
Site 1
Site 2
Site 3
Site 4
Site 5
42
Dissolved Oxygen
020
4060
80100
May-31 June23&24
July21&22
August12&13
Dates
Per
cen
t S
atu
rati
on
Site 1
Site 2
Site 3
Site 4
Site 5
43
5 Day Biological Oxygen Demand
01234567
May-31 June23&24
July21&22
August12&13
Date
pp
m
Site 1
Site 2
Site 3
Site 4
Site 5
44
Nitrates
05
1015
2025
May-31 June23&24
July21&22
August12&13
Date
pp
m
Site 1
Site 2
Site 3
Site 4
Site 5
45
Phosphates
00.5
11.5
22.5
Ma
y-3
1
Jun
e2
3&
24
July
21
&2
2
Au
gu
st1
2&
13
Date
pp
m Site 1
Site 2
Site 3
Site 4
Site 5
46
Chemical Test Conclusion• All W.Q.I. numbers were within the medium range, except August 12 and 13-Site 4 (Good) and June 23 and 24-Site 5 (Bad)
• Best overall date: August 12 & 13
• Best overall site: Site 4
• Consistent pH readings
• Dissolved oxygen increased over the summer
• Turbidity decreased over the summer
• High precipitation amounts in May affected testing because of increase in runoff
• Very high nitrate readings
47
Site 1 58.83
Site 2 59.73
Site 3 60.33
Site 4 63.85
Site 5 55.81
May 31 59.19
June 23 & 24 56.60
July 21 & 22 59.49
August 12 & 13 66.09
WQI Averages by Site
WQI Averages by Date
48
50
52
54
56
58
60
62
64
66
Site 1 Site 2 Site 3 Site 4 Site 5
Site
WQI Averages by Site
2003 Averages
2004 Averages
49
WQI Averages by Date
0
10
20
30
40
50
60
70
80
May June July August
Month
2003 Averages2004 Averages
50
2003 to 2004 Chemical Test Average Comparisons
0
1
2
3
4
5
6
7
8
9
10
Discharge pH Nitate Phosphate B.O.D. Change inTemp.Chemical Test
2003 Averages
2004 Averages
51
2003 to 2004 Chemical Test Average Comparisons
0
200
400
600
800
1000
1200
D.O. % Sat. Turbidity Fecal Coliform Total Solids
Chemical Test
2003 Averages
2004 Averages
52
Macro Invertebrates
TolerantSomewhat SensitiveSensitive
53
Sample Bio-Indicator Data Form
54
Comparison Chart-2002 and 2004
0
2
4
6
8
10
12
14
16
18
20
Site 1 Site 2 Site 3 Site 4
Summer 2002
Summer 2004
55
Comparison Bio-Indicators Throughout the Summer
Bio-Indicator Ratings
0123456789
101112131415
June August
Month
Rat
ing
s
site 1site 2site 3site 4site 5
56
Biological Indicators Conclusion• Water quality improved over the summer
• Best overall date: August 12 & 13
• Best overall site: Site 3
• The results slightly declined compared to 2 yrs ago
•Bio-Indicator scale ranked the Shell Creek slightly below the W.Q.I. rankings
•Bio-Indicators-poor to fair
•W.Q.I.-medium to good
57
Site 1
58
Site 2
59
Site 3
60
Site 4
61
Site 5
62
Site 5 after big rain in June
63
Filamentous algae at site 4
Unknown substance at Site 2
64
Using the Equipment
65
Bio-Indicators
66
Lab Work
67
Testing at Site 2
68
Stuck in the Mud at Site 3
69
Mr. Seier at Site 2
70The End
71
Thank You To:
• Lower Platte North Natural Resource District
• PrairieLand RC&D
• Nebraska Department of Environmental Quality
• Shell Creek Watershed Improvement Group
• Area Land Owners