ng shell creek data powerpoint 2003

2003Shell Creek

Watershed StudyResearchers: Amanda Gasper, Melissa Gasper, Anjuli Mostek, Katie Stone,

Katie Dunlap, Courtney Bennett, Brittany Pieke, Sarah O’Brien,

Instructor: Mark Seier

•Site 1- Instead of testing on Paul Cederland’s property, we moved to a site on Tim Krueger’s farm. This enabled us to have a sight on the South branch

• Site 2- This is the site with established buffer zones. It is on the North branch. Here we have roadside access to the site.

• Site 3- Located on Brad Wallin’s land. At this point, the north and south branches have already converged.

• Site 4- Just below Newman Grove on Katie Hallgren’s property. Scoured banks are trademark to this site. It also lies below the waste water treatment facility.

Introduction

• 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, Biochemical 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.

WQI

• 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 which is a number determined from a weighting curve chart. 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.

DO: % saturation

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 ___56.93___

5033

93

8550

58

903320

8.55.28

10.236.388.5

59

2.64

1.4

Sample WQI Form

Water Test Natural 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.5 Above 8.5

Nitrates 0.0 - 1.0 ppm Consistent readings above 3 ppm

Change in Temperature

The higher the change, the worse the water quality.

Turbidity 0 – 8 JTU Increasing trends in turbidity measurements.

Cautionary Readings

Water Test Natural Readings

5 Day BOD 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

Cautionary Readings

pH Turbidity Nitrates Phosphate

units JTU mg/L mg/L

May 23, 24

Site 1 7.5 60 2.5 0.6

Site 2 7.7 20 0.25 0.3

Site 3 8.3 110 3.75 0.3

Site 4 8.5 60 3 0.7

June 25, 26

Site 1 7.8 75 2.75 0.4

Site 2 7.65 17.5 0.75 0.3

Site 3 7.8 2595 0.875 0.7

Site 4 7 5035 0.375 0.9

Fecal Coliform

Total Solids

Discharge Change in H20 Temp

Col/100ml mg/L ft.3/sec. Celsius

May 23, 24

Site 1 280 680 1.79 2.3

Site 2 120 650 1.45 -1.8

Site 3 140 670 3.24 -0.1

Site 4 120 480 3.43 -0.5

June 25, 26

Site 1 320 425 1.41 3.8

Site 2 200 1545 3.74 -1

Site 3 900 545 5.15 -0.05

Site 4 0 3340 --- -0.1

Dissolved Oxygen

5 Day BOD

% Sat. mg/L

May 23, 24

Site 1 53% 4.9

Site 2 54% 2.2

Site 3 45% 2

Site 4 26% 2.6

June 25, 26

Site 1 41% 3.1

Site 2 25.50% 1.7

Site 3 57.50% 4.5

Site 4 20.50% 1.4

pH Turbidity Nitrates Phosphate

units JTU mg/L mg/L

July 17, 18

Site 1 7.75 170 1.6 0.1

Site 2 7.45 7.5 0.25 0

Site 3 8.05 60 0.35 0.4

Site 4 8.05 35 0.65 0.4

August 7,8

Site 1 8.4 80 0.75 0.4

Site 2 7.8 5 0 0.3

Site 3 7.9 5 <.25 0.1

Site 4 8 50 <.25 0.4

Fecal Coliform

Total Solids

Discharge Change in H20 Temp

Col/100ml mg/L ft.3/sec. Celsius

July 17, 18

Site 1 260 920 1.05 0.45

Site 2 40 550 1.37 -1.6

Site 3 80 570 2.38 -0.3

Site 4 40 550 --- -0.3

August 7, 8

Site 1 120 600 1.001 6

Site 2 0 490 0.537 -3.6

Site 3 20 370 1.57 -0.3

Site 4 60 410 --- 0.7

Dissolved Oxygen

5 Day BOD

% Sat. mg/L

July 17, 18

Site 1 30% 0.65

Site 2 9% 0.6

Site 3 17% 0.8

Site 4 24% 1.2

August 7, 8

Site 1 85% 7

Site 2 8% 1

Site 3 47% 4.4

Site 4 46% 4.4

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 ___61.33___

5033

93

8550

98

903320

8.55.28

10.2310.788.5

59

2.64

1.4

May 23 Site 1

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 ___59.66___

45

92

8972

41

65

58

6120

7.65 6.56 10.12

7.15 8.9 7.2

5.8 4.88 1.4

May 23 Site 2

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 ___56.94___

37

75

9179

40

80

80520

7.31 6.4 8.038.8 9.2 7.48.0 0.4 1.4

May 23 Site 3

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 ___53.19___

18

67

9050

41

88

753334

3.06 6.56 7.379.68 9.0 5.07.5 2.64 2.38

May 23 Site 4

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 ___61.26___

3333

93958066

942744

5.615.28

10.2310.45

86.6

9.42.613.08

June 26 Site 1

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 ___61.91___

1636

93989072

976420

2.725.76

10.2310.78

97.2

9.75.121.4

June 26 Site 2

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 ___62.44___

2287

91849257

805

20

14.973.52

10.019.249.25.7

80.41.4

June 26 Site 3

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 ___67.23___

9813

89

859296

965

20

2.2115.68

9.799.359.29.6

9.60.41.4

June 26 Site 4

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 ___55.65___

3219

91

698597

975

20

3.235.12

10.017.598.59.7

9.70.41.4

July 18 Site 1

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 ___67.22___

556

93998898

988120

1.028.8

10.2310.89

8.89.8

9.86.481.4

July 18 Site 2

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 ___57.73___

4810

83889167

973320

7.681.7

9.13

9.689.16.7

9.72.641.4

July 18 Site 3

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 ___62.11___

5515

83999167

974820

2.558.8

9.13

10.899.16.79.7

3.841.4

July 18 Site 4

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 ___55.3___

93

70

7070

9725

8.5

7.7

7

29.7

7

42

20 1.4

6.72

48 5.28

August 8 Site 1

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 ___71.39___

5

89

788097

86

0.85

9.79

7.88

9.76.88

98

32

15.68

2.24

95 10.45

August 8 Site 2

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 ___71.51___

41

87

9296

9886

6.97

9.57

9.29.6

9.86.88

61

51

9.76

3.57

56 6.16

August 8 Site 3

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 ___62.22___

40

83

51

9370

9834

45

6.88.16

9.13

9.37.0

9.82.72

3.15

56 6.16

August 8 Site 4

0.0

0.2

0.4

0.6

0.8

1.0

1.2

1.4

1.6

1.8

2.0

May 04 May 05 May 08 May 10 May 13 May 19 May 22 May 24 June 01 June 02

Precipitation

0.0

0.2

0.4

0.6

0.8

1.0

1.2

1.4

1.6

1.8

June 07 June 25 June 27 July 04 July 05 July 09 July 27 July 31 August 04 August 05

Precipitation cont.

May 23&24 June 25&26 July 17& 18 August 7&80

1

2

3

4

5

6

7

Site 1Site 2

Site 4Site 3

Dissolved Oxygen ppm

May 23&24 June 25&26 July 17& 18 August 7&80.0

0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9Site 1Site 2Site 3Site 4

Dissolved Oxygen % Saturation

2595

5035

May 23&24 June 25&26 July 17& 18 August 7&80

20

40

60

80

100

120

140

160

180

Site 1Site 2Site 3

Site 4

Turbidity

May 23&24 June 25&26 July 17& 18 August 7&8

0 0<.25

0.0

0.5

1.0

1.5

2.0

2.5

3.0

3.5

4.0

Site 1Site 2Site 3Site 4

Nitrates

-4-3-2-10123456

May 23& 24

June 25& 26

July 17& 18

August7& 8

site 1site 2site 3site 4

Change in Temperature Degrees Celsius

0

500

1000

1500

2000

2500

3000

3500

May 23& 24

June 25& 26

July17&18

August7& 8

Site 1Site 2Site 3Site 4

mg/L

Total Solids

0

100

200

300

400

500

600

700

800

900

May 23& 24

June 25& 26

July 17& 18

August 7& 8

site 1site 2site 3site 4

Fecal Coliform

0

0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9

May 23& 24

June 25& 26

July 17& 18

August 7& 8

Site 1Site 2Site 3Site 4

mg/L

Phosphates

Cubic feet per second

0

1

2

3

4

5

6

May 23 &24

June 25 &26

July 17 &18

August 7 &8

Site 1Site 2Site 3Site 4

Stream Discharge

Averages by SiteSite 1

5 8 . 3 9

Site 26 5 . 0 5

Site 36 2 . 1 6

Site 46 1 . 1 9

Averages by DateMay 23

5 7 . 7 8

June 25 & 266 3 . 2 1

July 17 & 186 0 . 6 8

Aug. 7 & 86 5 . 1 1

WQI Averages by Site

Site 1 Site 2 Site 3 Site 40

10

20

30

40

50

60

70

WQI Averages by Date

May 23&24 June 25&26 July 17&18 Aug. 7&8

0

10

20

30

40

50

60

70

•All WQI numbers were within the medium range or slightly above

•Best overall date: August 7&8 had lowest overall amount of dissolved oxygen

•Best overall site: 2; may be due to buffer strips

•Beaver dams on sites 1 & 2

•Low nitrates

•BOD tests not significant due to low oxygen numbers

•Site 1 had high fecal coliform numbers

•High levels of silt and sediment causing high turbidity

•Good pH levels

Conclusions

Site 1

Site 3Site 2

Site 3

Site 3

Site 4

Brittany and Amanda performing the Fecal coliform test

Amanda measuring the depth

Brittany and Melissa after a flow rate test

Fecal Coliform sample

Melissa with duckweed sample from Site 2

Courtney entering data on the computer

Anjuli performing phosphate test

Melissa and Brittany performing turbidity test