2024-25 MI [Data]

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	2024-2025 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)	pH Test Kit	Conductivity (uS/cm)	WQI value	Weather (past 48 hr)	Creek Appearance	Stage (m)	Flow (m/s)	Discharge (m3/s)	Other tests

8	401	Allendale Public Schools	4/30/2025	8:45 AM	8.5	660.0	12.5	0.15	0.02	170.0	0.0	7.75	957.00	5.05	Sunny, warm, and windy	Sand channel, but the banks were fine muddy sediment. Water was clear, but had a lot of organic matter too.	0.21	0.1404	0.0295	RCE = 217 PTI = 5.361 Relative Depth = 0.21 m
9	401	Allendale Public Schools	4/22/2025	8:45 AM	6.9	605.0	11.0	0.89	0.05	195.5	7.5	8.00	883.50	17.45	A mix of rain and over cast weather	Clear and faster flowing	0.233	0.2439	0.0568	RCE = 276 PTI = 5.721 Relative Depth = 0.233 m
10	401	Allendale Public Schools	4/15/2025	9:45 AM	6.4	640.0	12.5	0.15	0.05	204.0	0.0	7.50	914.50	3.43	Cold, windy, and rainy.	Clear fast moving water	0.265	0.256	0.068	RCE = 255 PTI = 5.129 Relative Depth = 0.265 m
11	401	Allendale Public Schools	10/22/2024	11:30 AM	12.5	631.5	11.0	0.35	0.15	195.5	0.0	8.25	915.50	14.00	Partially cloudy.	Clear with a sandy/rocky bottom	0.148	0.064	0.0095	RCE = 157 PTI = 71.018 Relative Depth = 0.148 m
12	401	Allendale Public Schools	10/15/2024	12:35 AM	12.0	287.0	7.5	0.35	0.23	221.0	0.0	7.00	579.00	15.64	Cold and rainy.	It was shallow and sandy.	0.3	0.1522	0.0457	RCE = 221 PTI = 71.132 Relative Depth = 0.3 m
13	402	Allendale Public Schools	4/30/2025	7:40 AM	7.67	360.0	8.5	0.80	0.01	221.0	0.0	7.75	660.00	14.25	Mild to warm temperatures. Sunny.	Grassy banks, rocky concrete near downstream. Otherwise clear.	0.386	0.21	0.081	RCE = 143 PTI = 5.524 Relative Depth = 0.386 m
14	402	Allendale Public Schools	4/22/2025	7:45 AM	7	600.0	10.5	0.84	0.09	195.5	0.0	6.25	844.00	22.45	Mostly rain, but was mild Tuesday morning	Water levels were high and clear.	0.28	0.25	0.07	RCE = 228 PTI = 5.457 Relative Depth = 0.282 m
15	402	Allendale Public Schools	4/15/2025	8:45 AM	6.8	625.5	7.0	0.63	0.05	229.5	5.0	7.50	920.50	13.10	Windy, rainy, and cold.	Water was somewhat clear and slow moving	0.43	0.2	0.086	RCE = 182 PTI=5.837 Relstive Depth = 0.43 m
16	402	Allendale Public Schools	10/22/2024	9:50 AM	13.5	409.0	7.0	0.78	0.02	204.0	0.0	7.50	640.00	13.20	Clear and mild	Clear with a lot of detritus along the sides of the channel.	0.13	0.256	0.033	RCE = 134 PTI Score = 70.549 Relative Depth = 0.13 m
17	402	Allendale Public Schools	10/15/2024	11:30 AM	11.0	590.3	9.3	0.35	0.10	280.5	0.0	6.25	906.00	18.40	Cold and rainy.	Clear	0.38	0.19	0.0722	RCE = 86 PTI = 71.285 Relative Depth = 0.38 m
18	402	Allendale Public Schools	10/8/2024	12:40 AM	20.0	297.0	10.0	0.26	0.26	229.5	20.0	7.25	629.00	15.50	Cool mornings, but sunny during the day. No precipitation.	Clear and sandy	0.076	0.31347	0.02382	RCE = 209 PTI = 64.735 Relative Depth = 0.076 m
19	403	Allendale Public Schools, MI	4/30/2025	12:00 PM	16.5	633.0	8.5	0.26	0.14	221.0	0.0	7.75	834.00	10.75	Clear, sunny, and warm.	Muddy, dirty, but calm water.	0.19	0.085	0.01615	RCE = 133 PTI = 5.793 Relative Depth = 0.19 m
20	403	Allendale Public Schools, MI	4/15/2025	7:40 AM	11.0	669.5	9.0	0.53	0.06	153.0	7.5	7.00	963.00	15.39	Rainy and cold	Water at this site was actually pretty high, probably due to previous rain and the winter snow melt.	0.29	0.045	0.013	RCE = 178 PTI = 7.638 Relative Depth = 0.29 m
21	403	Allendale Public Schools	10/22/2024	8:45 AM	10.0	262.0	6.5	0.10	0.13	297.5	60.0	7.00	589.00	24.45	Cool mornings but warm and sunny during the days.	Very slow moving and very muddy.	0.108	0.04	0.00432	RCE = 142 PTI = 52.249 Relative Depth = 0.108 m
22	403	Allendale Public Schools	10/15/2024	9:50 AM	10.0	259.0	4.0	0.00	0.35	221.0	30.0	8.00	369.90	22.45	Cold and with alot of rain.	Hardly any flow, and very turbid.	0.06	0.0665	0.00399	RCE = 203 PTI = 49.793 Relative Depth = 0.06 m
23	403	Allendale Public Schools	10/8/2024	11:25 AM	16.0	255.0	5.0	0.15	0.00	331.5	70.0	6.75	541.00	28.00	Cold in the morning, but sunny in the afternoons. No precipitation at all.	Muddy and slow flow	0.22	0.005	0.0077	RCE = 514 PTI = 54.807 Relative Depth = 0.22 m
24	404	Allendale Public Schools	4/30/2025	11:20 AM	11.0	605.0	12.5	0.30	0.01	204.0	7.5	7.75	889.50	7.86	Windy, warm, and sunny.	Clear cold water	0.308	0.146	0.045	RCE = 142 PTI = 5.313 Relative Depth = 0.308 m
25	404	Allendale Public Schools	4/22/2025	12:30 PM	14.7	615.0	11.5	0.65	0.05	212.5	7.5	7.50	857.00	10.64	Cloudy/Rainy	Clear, rocky at upstream. Cloudy water downstream	0.343	0.2	0.0686	RCE = 247 PTI = 5.337 Relative Depth = 0.343 m
26	404	Allendale Public Schools	10/22/2024	7:45 AM	12.7	407.7	12.0	0.00	0.12	178.5	2.5	7.25	583.50	5.86	Sunny, cool mornings.	Clear	0.13	0.204	0.0265	RCE = 205 PTI = 69.308 Relative Depth = 0.13 m
27	404	Allendale Public Schools	10/15/2024	8:45 AM	11.0	256.0	10.5	0.45	0.01	119.0	0.0	7.00	494.50	11.25	Cool and a lot of precipitation.	Sandy and muddy areas. Darker water, deeper is some areas	0.178	0.071	0.012	RCE = 196 PTI = 67.742 Relative Depth = 0.178 m
28	404	Allendale Public Schools	10/8/2024	9:45 AM	12.0	268.0	13.0	0.20	0.05	238.0	2.5	7.75	383.00	6.15	Cold evenings. No rain.	Dirty water, a lot of rocks upstream.	0.61	0.2	0.122	RCE = 182 PTI = 52.757 Relative Depth = 0.61 m
29	405	Allendale Public Schools	4/30/2025	9:45 AM	12.2	650.0	12.0	0.79	0.02	255.0	5.0	7.75	925.50	12.75	Sandy, clear, rocky downstream. A lot detritus along the shallow banks.	Sunny, Windy, with mild temperatures.	0.16	0.984	0.1574	RCE = 152 PTI = 5.777 Relative Depth = 0.16m
30	405	Allendale Public Schools	4/22/2025	11:20 AM	11.5	615.0	13.0	0.36	0.07	229.5	0.0	7.25	878.00	7.51	Colder, rainy, and windy.	Clear and moving fast.	0.267	0.189	0.05	RCE = 173 PTI = 5.662 Relative Depth = 0.267m
31	405	Allendale Public Schools	4/15/2025	12:35 AM	7.8	535.0	7.0	0.80	0.01	127.5	5.0	7.25	955.00	16.18	Mild, but then rain moved in and it got cold.	Clear water with a lot of detritus in the the pooled areas.	0.37	0.1233	0.169	RCE = 242 PTI = 5.676 Relative Depth = 0.37m
32	405	Allendale Public Schools	10/15/2024	7:45 AM	10.0	244.5	8.0	0.36	0.00	136.0	0.0	7.25	494.00	10.00	Cold and with a lot of rain	Rocky at downstream, mid and up were sandy. Clear water though.	0.11	0.135	0.01485	RCE = 227 PTI = 67.669 Relative Depth = 0.11 m
33	405	Allendale Public Schools	10/8/2024	8:45 AM	12.0	284.5	8.5	0.30	0.03	212.5	50.0	6.50	569.50	25.50	No precipitation, cool nights.	Clear water, shallow muddy banks	0.076	0.001	0.000076	RCE = 227 PTI = 45.926 Relative Depth = 0.076 m
34	406	Allendale Public Schools	4/22/2025	9:50 AM	9.4	610.0	9.5	0.16	0.06	195.5	0.0	7.75	882.50	7.85	Rainy and windy.	Clear and sandy channel, muddy banks.	0.34	0.224	0.076	RCE = 168 PTI = 5.613 Relative Depth = 0.34 m
35	406	Allendale Public Schools	4/15/2025	9:50 AM	6.7	614.0	11.5	0.57	0.02	195.5	5.0	7.75	960.00	10.94	Misty, rainy, cloudy, Mild but then switched over to very cold.	Muddy, but the water was somewhat clear with some raised areas of deposition.	0.13	0.026	0.003	RCE = 188 PTI = 6.056 Relative Depth =0.13 m
36	406	Allendale Public Schools	10/22/2024	1:50 PM	19.3	618.0	8.0	0.02	0.03	221.0	10.0	7.25	895.50	8.98	Moderate temperatures.	Full of leaf litter. Clear water with detritus along the sides of the channel.	0.143	0.17361	0.0248	RCE = 310 PTI = 72.625 Relative Depth = 0.143 m
37	406	Allendale Public Schools	10/8/2024	7:45 AM	14.0	295	5.0	0.85	0.03	161.5	30.0	7.25	597.00	23.41	Cold evenings, no precipitation	Very shallow, low flow.	0.063	0.158	0.00995	RCE = 184 PTI = 68.495 Relative Depth = 0.0634 m
38														70.00
39														70.00
40														70.00
41														70.00
42														70.00
43														70.00
44														70.00
45														70.00
46														70.00
47														70.00
48														70.00
49														70.00
50														70.00
51														70.00
52														70.00
53														70.00
54														70.00
55														70.00
56														70.00
57														70.00
58														70.00
59														70.00
60														70.00
61														70.00
62														70.00
63														70.00
64														70.00
65														70.00
66														70.00
67														70.00
68														70.00
69														70.00
70														70.00
71														70.00
72														70.00
73														70.00
74														70.00
75														70.00
76														70.00
77														70.00
78														70.00
79														70.00
80														70.00
81														70.00
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100