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


FactorT o t a l







5033

93

8550

98

903320

8.55.28

10.2310.788.5

59

2.64

1.4

May 23 Site 1


FactorT o t a l







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


FactorT o t a l







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


FactorT o t a l







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


FactorT o t a l







3333

93958066

942744

5.615.28

10.2310.45

86.6

9.42.613.08

June 26 Site 1


FactorT o t a l







1636

93989072

976420

2.725.76

10.2310.78

97.2

9.75.121.4

June 26 Site 2


FactorT o t a l







2287

91849257

805

20

14.973.52

10.019.249.25.7

80.41.4

June 26 Site 3


FactorT o t a l







9813

89

859296

965

20

2.2115.68

9.799.359.29.6

9.60.41.4

June 26 Site 4


FactorT o t a l







3219

91

698597

975

20

3.235.12

10.017.598.59.7

9.70.41.4

July 18 Site 1


FactorT o t a l







556

93998898

988120

1.028.8

10.2310.89

8.89.8

9.86.481.4

July 18 Site 2


FactorT o t a l







4810

83889167

973320

7.681.7

9.13

9.689.16.7

9.72.641.4

July 18 Site 3


FactorT o t a l







5515

83999167

974820

2.558.8

9.13

10.899.16.79.7

3.841.4

July 18 Site 4


FactorT o t a l







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


FactorT o t a l







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


FactorT o t a l







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


FactorT o t a l







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


20

40

60

80

100

120

140

160

180

Site 1Site 2Site 3

Site 4

Turbidity


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


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


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


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

ng shell creek data powerpoint 2003

Education