A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2023-2024 Creek Connections Water Quality Data | |||||||||||||||||||
2 | Michigan Schools (Site Numbers 400-499) | |||||||||||||||||||
3 | Data in squares that are shaded BLUE represent an unrealistic data number that needs to be confirmed or checked, | |||||||||||||||||||
4 | YELLOW if only one trial was done or if Sample A and B yielded very different results and a third trial was not completed for more accuracy, | |||||||||||||||||||
5 | or ORANGE if we spot an error for any other reason. | |||||||||||||||||||
6 | Please let us know the correction and we will remove the shading. | |||||||||||||||||||
7 | Site # | School | Date | Time | Temp. (deg C) | TDS (mg/L) | DO (mg/L) | NO3-N (mg/L) | P (mg/L) | Alk (mg/L) | Turb (JTU) | Conductivity (uS/cm) | pH Test Kit | WQI value | Weather (past 48 hr) | Creek Appearance | Stage (m) | Flow (m/s) | Discharge (m3/s) | Other tests |
8 | 401 | Allendale Public Schools, MI | 9/8/2023 | 1:50:00 PM | 20.0 | 248 | 10.5 | 0.62 | 0.10 | 187.0 | 0.0 | 496.50 | 7.0 | 14.30 | Rainy yesterday | Clean | 0.07 | 0.1 | 0.007 | |
9 | 401 | Allendale Public Schools, MI | 10/27/2023 | 7:43:00 AM | 16.0 | 216 | 8.5 | 0.54 | 0.06 | 119.0 | 5.0 | 430.00 | 7.0 | 15.35 | Heavy rain at times | Clear but moving quickly | 0.11 | 0.3003 | 0.033 | relative depth = 0.11 |
10 | 401 | Allendale Public Schools, MI | 11/17/2023 | 8:45:00 AM | 12.0 | 290 | 9.0 | 0.70 | 0 | 170.0 | 0.0 | 576.00 | 7.8 | 12.70 | Spotty Rain | Clear | 0.098 | 0.234 | 0.0229 | relative depth = 0.098 m |
11 | 401 | Allendale Public Schools, MI | 12/8/2023 | 1:30:00 PM | 10.9 | 270 | 10.2 | 0.75 | 0.02 | 136.0 | 5.0 | 549.50 | 7.7 | 13.26 | Cloudy, a little bit of percipation on Wednesday | Clear, faster moving | 0.11 | 0.16 | 0.0176 | relative depth = 0.11 |
12 | 401 | Allendale Public Schools, MI | 2/15/2024 | 8:45:00 AM | 8.0 | 595 | 10.5 | 0.05 | 0.17 | 144.5 | 5.0 | 798.50 | 6.75 | 12.65 | Warm, but a cold front moved in and a mix of precipitation has begun with lake effect snow | Fast moving but clear. | 0.097 | 0.2577 | 0.025 | relative depth = 0.097 |
13 | 402 | Allendale Public Schools, MI | 9/8/2023 | 1:50:00 PM | 20.0 | 576 | 11.0 | 0.65 | 0.09 | 229.5 | 0.0 | 287.50 | 7.3 | 12.15 | Rain | Clean | 0.07 | 0.1 | 0.07 | relative depth = 0.07 |
14 | 402 | Allendale Public Schools, MI | 10/27/2023 | 1:30:00 PM | 18.0 | 218 | 8.0 | 0.55 | 0.05 | 102.0 | 5.0 | 430.50 | 7.5 | 11.70 | Spotty down pours | Clear water | 0.08 | 0.339 | 0.0271 | relative depth = 0.08 |
15 | 402 | Allendale Public Schools, MI | 11/17/2023 | 9:00:00 AM | 12.0 | 270 | 9.0 | 0.72 | 0.00 | 136.0 | 0.0 | 540.50 | 7.0 | 14.90 | Spotty Rain | Clear | 0.11 | 0.253 | 0.0278 | relative depth = 0.11 |
16 | 402 | Allendale Public Schools, MI | 12/8/2023 | 12:30:00 PM | 13.6 | 277 | 11.0 | 0.81 | 0.00 | 110.5 | 0.0 | 565.33 | 8.0 | 14.40 | Cool, overcast, with a little precip on Wednesday morning. | Clear and faster moving | 0.175 | 0.2 | 0.035 | relative depth = 0.175 |
17 | 402 | Allendale Public Schools, MI | 2/15/2024 | 9:50:00 AM | 8.0 | 274 | 11.0 | 0.95 | 0.04 | 119.0 | 10.0 | 559.00 | 7.5 | 14.40 | Warm, but then a cold front moved in. Mixed precipitation was falling while pulling the samples. | Water was clear and running nice. | 0.11 | 0.279 | 0.03 | relative depth = 0.11 |
18 | 403 | Allendale Public Schools, MI | 9/8/2023 | 12:30:00 AM | 21.0 | 340 | 10.0 | 0.30 | 0.21 | 163.0 | 22.5 | 647.00 | 7.3 | 15.65 | Rained yesterday | slow and muddy | 0.12 | 0.1 | 0.012 | relative depth = 0.012 |
19 | 403 | Allendale Public Schools, MI | 10/27/2023 | 12:30:00 PM | 19.0 | 201 | 9.5 | 0.72 | 0.11 | 136.0 | 0.0 | 402.00 | 7.5 | 12.25 | Spotty down pours | Still slow moving but clearer than usual. | 0.1 | 0.0414 | 0.0041 | relative depth = 0.1 |
20 | 403 | Allendale Public Schools, MI | 11/17/2023 | 9:50:00 AM | 13.0 | 268 | 8.0 | 0.96 | 0.07 | 119.0 | 5.0 | 536.00 | 7.5 | 16.10 | Spotty rain | Slow and cloudier than upstream of diversion | 0.124 | 0.179 | 0.0222 | relative depth = 0.124 |
21 | 403 | Allendale Public Schools, MI | 12/8/2023 | 11:30:00 AM | 10.5 | 253 | 8.5 | 0.99 | 0.00 | 170.0 | 7.5 | 542.50 | 7.8 | 17.45 | cloudy, little precipitation | cloudy, little movement | 0.12 | 0 | 0 | relative depth = 0.12 |
22 | 403 | Allendale Public Schools, MI | 2/15/2024 | 11:15:00 AM | 8.0 | 288 | 10.5 | 0.59 | 0.21 | 68.0 | 0.0 | 576.00 | 7.0 | Warm, but then a cold front moved in. Mixed precipitation was falling while pulling the samples. | Water was moving faster than what this study site usually is. | 0.09 | 0.1 | 0.009 | relative depth = 0.09 | |
23 | 404 | Allendale Public Schools, MI | 9/8/2023 | 11:30:00 AM | 21.0 | 254 | 8.0 | 0.50 | 0.23 | 221.0 | 0.0 | 509.00 | 7.5 | 12.80 | Rain yesterday | Slow with clear water | 0.12 | 0.2 | 0.024 | relative depth = 0.406 |
24 | 404 | Allendale Public Schools, MI | 10/27/2023 | 11:25:00 AM | 18.0 | 405 | 8.0 | 0.66 | 0.33 | 136.0 | 5.0 | 632.50 | 7.5 | 16.91 | Times of heavy down pours | Fast moving water upstream, but then gets slow and cloudy | 0.105 | 0.241 | 0.0253 | relative depth = 0.105 |
25 | 404 | Allendale Public Schoold, MI | 11/17/2023 | 1:30:00 AM | 12.0 | 268 | 8.0 | 0.00 | 0.00 | 119.0 | 5.0 | 543.00 | 8.3 | 11.40 | Spotty rain | Water was running fast but was clear | 0.084 | 0.19 | 0.016 | relative depth = 0.084 |
26 | 404 | Allendale Public Schoold, MI | 12/8/2023 | 9:50:00 AM | 6.9 | 283 | 10.3 | 0.12 | 0.02 | 153.0 | 5.0 | 581.30 | 8.0 | 9.30 | light rain Wednesday | deeper mid channel- and cloudy | 0.105 | 0.4 | 0.042 | relative depth = 0.105 |
27 | 404 | Allendale Public Schools, MI | 2/15/2024 | 12:15:00 PM | 8.0 | 615 | 11.5 | 0.97 | 0.02 | 102.0 | 0.0 | 878.50 | 7.3 | 13.94 | Warm, but then a cold front moved in. Mixed precipitation was falling while pulling the samples. | Water was clear and running fast. | 0.13 | 0.1968 | 0.025584 | relative depth = 0.13 |
28 | 405 | Allendale Public Schools, MI | 9/8/2023 | 9:50:00 AM | 20.0 | 550 | 9.0 | 0.72 | 0.07 | 187.0 | 5.0 | 789.00 | 7.0 | 17.00 | rain yesterday | Slow moving but clear | 0.176 | 0.1 | 0.0176 | relative depth = 0.176 |
29 | 405 | Allendale Public Schools, MI | 10/27/2023 | 9:45:00 AM | 18.0 | 216 | 10.0 | 0.98 | 0.03 | 153.0 | 10.0 | 421.50 | 8.0 | 19.30 | Spotty down pours of rain. | Clear"ish", but slightly more turbid water. | 0.22 | 0.0879 | 0.0193 | relative depth = 0.22 |
30 | 405 | Allendale Public Schools, MI | 11/19/2023 | 12:30:00 PM | 16.0 | 288 | 8.0 | 0.28 | 0.03 | 119.0 | 5.0 | 576.00 | 8.0 | 12.70 | Cool and a little rain | Clear | 0.145 | 0.187 | 0.0271 | relative depth = 0.145 |
31 | 405 | Allendale Public Schools, MI | 12/8/2023 | 8:50:00 AM | 9.0 | 283 | 11.0 | 0.42 | 0.03 | 127.5 | 2.5 | 570.00 | 7.8 | 9.50 | mild | Flowing muddy banks. | 0.13 | 0.1 | 0.013 | relative depth = 0.13 |
32 | 405 | Allendale Public Schools, MI | 2/15/2024 | 1:45:00 PM | 8.0 | 605 | 9.0 | 0.60 | 0.05 | 102.0 | 0.0 | 859.50 | 7.5 | 10.45 | Warm, but then a cold front moved in. Mixed precipitation was falling while pulling the samples. | Clear | 0.147 | 0.2058 | 0.0303 | relative depth = 0.147 |
33 | 406 | Allendale Public Schools, MI | 9/8/2023 | 8:50:00 AM | 242 | 9.5 | 0.32 | 0.03 | 187.0 | 10.0 | 470.00 | 7.8 | 10.95 | rain yesterday | low flowing | 0.13 | 0.2 | 0.026 | relative depth = 0.24 | |
34 | 406 | Allendale Public Schools, MI | 10/27/2023 | 8:45:00 AM | 18.5 | 206 | 9.0 | 0.15 | 0.12 | 170.0 | 20.0 | 406.00 | 8.3 | 16.95 | Off and on periods of heavy rain | Fast and a little cloudy | 0.165 | 0.3115 | 0.0514 | relative depth = 0.165 |
35 | 406 | Allendale Public Schools, MI | 11/17/2023 | 1:40:00 PM | 13.0 | 289 | 10.0 | 1.00 | 0.04 | 170.0 | 0.0 | 585.00 | 8.0 | 17.60 | A little bit of rain the night before | clear | 0.1 | 0.347 | 0.0347 | relative depth = 0.1 |
36 | 406 | Allendale Public Schools, MI | 2/15/2024 | 7:45:00 AM | 8.0 | 289 | 10.0 | 0.92 | 0.16 | 187.0 | 0.0 | 576.00 | 7.0 | 18.60 | Warm, but a cold front moved in and a mix of precipitation has begun with lake effect snow | Clear water | 0.12 | 0.25 | 0.03 | relative depth = 0.12 |
37 | ||||||||||||||||||||
38 | ||||||||||||||||||||
39 | ||||||||||||||||||||
40 | ||||||||||||||||||||
41 | ||||||||||||||||||||
42 | ||||||||||||||||||||
43 | ||||||||||||||||||||
44 | ||||||||||||||||||||
45 | ||||||||||||||||||||
46 | ||||||||||||||||||||
47 | ||||||||||||||||||||
48 | ||||||||||||||||||||
49 | ||||||||||||||||||||
50 | ||||||||||||||||||||
51 | ||||||||||||||||||||
52 | ||||||||||||||||||||
53 | ||||||||||||||||||||
54 | ||||||||||||||||||||
55 | ||||||||||||||||||||
56 | ||||||||||||||||||||
57 | ||||||||||||||||||||
58 | ||||||||||||||||||||
59 | ||||||||||||||||||||
60 | ||||||||||||||||||||
61 | ||||||||||||||||||||
62 | ||||||||||||||||||||
63 | ||||||||||||||||||||
64 | ||||||||||||||||||||
65 | ||||||||||||||||||||
66 | ||||||||||||||||||||
67 | ||||||||||||||||||||
68 | ||||||||||||||||||||
69 | ||||||||||||||||||||
70 | ||||||||||||||||||||
71 | ||||||||||||||||||||
72 | ||||||||||||||||||||
73 | ||||||||||||||||||||
74 | ||||||||||||||||||||
75 | ||||||||||||||||||||
76 | ||||||||||||||||||||
77 | ||||||||||||||||||||
78 | ||||||||||||||||||||
79 | ||||||||||||||||||||
80 | ||||||||||||||||||||
81 | ||||||||||||||||||||
82 | ||||||||||||||||||||
83 | ||||||||||||||||||||
84 | ||||||||||||||||||||
85 | ||||||||||||||||||||
86 | ||||||||||||||||||||
87 | ||||||||||||||||||||
88 | ||||||||||||||||||||
89 | ||||||||||||||||||||
90 | ||||||||||||||||||||
91 | ||||||||||||||||||||
92 | ||||||||||||||||||||
93 | ||||||||||||||||||||
94 | ||||||||||||||||||||
95 | ||||||||||||||||||||
96 | ||||||||||||||||||||
97 | ||||||||||||||||||||
98 | ||||||||||||||||||||
99 | ||||||||||||||||||||
100 |