IOwater Chemical/Physical Assessment Summation Table for HUC 8 Watershed: Mississippi River - Flint Creek (07080104)

Site_name	ID	Site_no	DateMonitored	TimeMonitored	Monitor_id	Other_volunteers	Adults	Children	Weather_Sunny	Weather_Partly_Sunny	Weather_Cloudy	Weather_Rain_Snow	Weather_Windy	Weather_Calm	Air_Temp_Fahrenheit	Precip_24_hours	pH	Dissolved_oxygen	NitriteN	NitrateN	Phosphate	Chloride	Rep1_Ecoli	Rep2_Ecoli	Rep3_Ecoli	Avg_Ecoli100	Rep1_General_Coliform	Rep2_General_Coliform	Rep3_General_Coliform	Avg_General_Coliform100	Avg_Total_Coliform100	Rep1_Ecoli100	Rep2_Ecoli100	Rep3_Ecoli100	Rep1_General_Coliform100	Rep2_General_Coliform100	Rep3_General_Coliform100	Rep1_Total_Coliform100	Rep2_Total_Coliform100	Rep3_Total_Coliform100	Incubation_period	Incubation_Temp_Fahr	Sample_Volume	Water_Color_Clear	Water_Color_Brown	Water_Color_Green	Water_Color_Oilysheen	Water_Color_Reddish	Water_Color_Blackish	Water_Color_Chalky	Water_Color_Milky	Water_Color_Gray	Water_Odor_None	Water_Odor_SewageManure	Water_Odor_Rotteneggs	Water_Odor_Petroleum	Water_Odor_Musky	Stream_Width_Meters	Max_Stream_Depth	Stream_Flow_Level	SDspot1	SDspot2	SDspot3	SDspot4	SDspot5	SDspot6	SDspot7	SDspot8	SDspot9	SDspot10	SDspot11	SDspot12	SDspot13	SDspot14	SDspot15	SDspot16	SDspot17	SDspot18	SDspot19	SDspot20	SDspot21	SDspot22	SDspot23	SDspot24	SDspot25	SDspot26	SDspot27	SDspot28	SDspot29	SDspot30	SDspot31	SDspot32	SDspot33	SDspot34	SDspot35	SDspot36	SDspot37	SDspot38	SDspot39	SDspot40	SDspot41	SDspot42	SDspot43	SDspot44	SDspot45	SDspot46	SDspot47	SDspot48	SDspot49	SDspot50	SDspot51	SDspot52	SDspot53	SDspot54	SDspot55	SDspot56	SDspot57	SDspot58	SDspot59	SDspot60	SVspot1	SVspot2	SVspot3	SVspot4	SVspot5	SVspot6	SVspot7	SVspot8	SVspot9	SVspot10	SVspot11	SVspot12	SVspot13	SVspot14	SVspot15	SVspot16	SVspot17	SVspot18	SVspot19	SVspot20	SVspot21	SVspot22	SVspot23	SVspot24	SVspot25	SVspot26	SVspot27	SVspot28	SVspot29	SVspot30	SVspot31	SVspot32	SVspot33	SVspot34	SVspot35	SVspot36	SVspot37	SVspot38	SVspot39	SVspot40	SVspot41	SVspot42	SVspot43	SVspot44	SVspot45	SVspot46	SVspot47	SVspot48	SVspot49	SVspot50	SVspot51	SVspot52	SVspot53	SVspot54	SVspot55	SVspot56	SVspot57	SVspot58	SVspot59	SVspot60	Total_Flow	Avg_Stream_Depth	Avg_Stream_Vel	Stream_Dry	Exp_Date_Checked	Water_Temp_Fahrenheit	Transparency	Other_Stream_Comments	Other_Monitoring	Access_Level	Submit_DateTime	Date_Modified	Why_Modified
Cheek Creek	25795	929008	10/28/2008	1100	090809	Mediapolis High School Environmental Science	1	10+	True	False	False	False	False	False	48	0	7	6	0	10	0	33																						False	False	False	False	False	True	False	False	False	True	False	False	False	False	5	4	Normal	57	52	77	60																																																									6	6	6	6																																																									41	61.5	0.16	No	Yes	54	60			1	4/9/2009 10:33:00 AM
Cheek Creek	25802	929008	12/16/2008	1000	090809	Mediapolis High School Environmental Science	2	10+	False	False	False	True	False	False	16		7	5	0	5	0	32																						False	True	False	False	False	False	False	False	False	True	False	False	False	False	5	60	Normal	57	52	77	60																																																									6	6	6	6																																																									41	61.5	0.16	No	Yes	40	60+			1	4/9/2009 10:45:00 AM
Cheek Creek	25803	929008	4/1/2009	1100	090809	Mediapolis High School Environmental Science	1	10+	True	False	False	False	False	False	48	0	7	6	1.5	10	0	26																						True	True	False	False	False	False	False	False	False	True	False	False	False	False	5	0.28	Low	0.255	0.28	0.255																																																										4	4	4																																																										0.19	0.26	0.25	No	Yes	41	18	trash, no blockage, dead bird, some tree coverage		1	4/9/2009 10:51:00 AM
Cheek Creek	27458	929008	11/4/2009	900	090809		1	10+	True	False	False	False	False	False	57	0	7	6	0	0	1	29																						False	False	False	False	False	False	False	False	True	True	False	False	False	False	2	0.65	Normal	0.49	0.48																																																											6	5																																																											0.17	0.48	0.18	No	Yes	54	41			1	12/4/2009 9:44:00 AM
Cheek Creek	27495	929008	12/1/2009	1200	090809		1	10+	True	False	False	False	False	False	60	0	7	12	0	0	0	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	1.1	1.7	Normal																																																													6.85	4.37	5.76	4.89	3.87																																																								0	0		No	Yes	58	60+			1	12/10/2009 11:22:00 AM
Flint Creek Parking Lot Left (PLL)	20539	929004	9/14/2007	1100	333333		4	0	True	False	False	False	True	False			9	10	0	1	0.2	30																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	21.8		Not Sampled																																																																																																																									0	0		No	Yes	60	60+			2	11/3/2007 9:41:00 PM
Flint Creek Parking Lot Left (PLL)	20529	929004	9/28/2007	900	333333	Sally Coleman	Not Recorded	Not Recorded	True	False	False	False	False	False	62		8	10	0	0	0.2	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																																																																																																																									0	0		No	Yes	58	60+			2	11/1/2007 1:51:00 PM
Flint Creek Parking Lot Middle (PLM)	20518	929003	9/14/2007	1030	333333		3	0	True	False	False	False	False	False			9	10	0	0	0	33																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	21	0.3	Normal	0.3	0.07	0	0.03	0.12	0.12	0.08	0.07	0.06	0.07	0	0.02	0.06	0.07	0.06	0.06	0.15	0.09	0.2	0.17	0.07																																								9	20	0	5	4	4	8	7	6	7	0	2	6	7	10	6	5	6	4	6	12																																								0.318	8.904762E-02	0.1700535	No	Yes	62	60+		no	2	10/30/2007 7:00:00 PM
Flint Creek Parking Lot Middle (PLM)	20540	929003	9/14/2007	1030	333333	Lisa, Jane, Terry, Anne	4	Not Recorded	True	False	False	False	False	False	58		9	10	0	0	0	33																						True	False	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																																																																																																																									0	0		No	Yes		60+			2	11/4/2007 9:35:00 PM
Flint Creek Parking Lot Middle (PLM)	20173	929003	9/14/2007	1330	333333		3	0	True	False	False	False	True	False	55	0	8	10	0	2	0.1	196																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	21.9	0.33	Normal	0.1	0.08	0.16	0.09	0.13	0.14	0.07	0.09	0.07	0.07	0	0.02	0.02	0	0.01	0.06	0.1	0.13	0.13	0.16	0.33																																								10	0	5	4	6	6	5	5	4	2	0	0	0	8	9	0	0	0	0	0	0																																								0.1951111	9.333333E-02	9.954648E-02	No	Yes	66	60+			2	10/10/2007 8:45:00 AM
Flint Creek Parking Lot Middle (PLM)	20528	929003	9/28/2007	900	333333		Not Recorded	Not Recorded	True	False	False	False	False	False	75		8	8	0	0	0.2	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																																																																																																																									0	0		No	Yes	63	60+	Data for depth and velocity are the same for Flint Creek Left	Yes, velocity was measured with probe	2	11/1/2007 1:49:00 PM
Flint Creek Parking Lot Right (PLR)	20143	929002	9/14/2007	1100	333333		3	0	True	False	False	False	False	False			8	8	0	0	0.1	33																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	21	30	Not Sampled	0.3	0.07	0	0.03	0.12	0.12	0.08	0.07	0.06	0.07	0	0.02	0.06	0.07	0.06	0.06	0.15	0.09	0.2	0.17	0.07																																								9	20	0	5	4	4	6	4	4	18	0	0	7	3	10	6	5	6	4	6	12																																								0.329627	8.904762E-02	0.1762711	No	Yes	60	Not Sampled			2	10/8/2007 7:29:00 AM
Flint Creek Parking Lot Right (PLR)	20581	929002	9/14/2007	1130	333333		2	Not Recorded	True	False	False	False	True	False	60	0	9	10	Not Sampled	Not Sampled	0.1	33																						True	False	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																																																																																																																									0	0		No	Yes	68	60			2	11/5/2007 12:42:00 PM
Flint Creek Parking Lot Right (PLR)	20595	929002	9/14/2007	1300	333333		2	Not Recorded	True	False	False	False	False	False	65	0	9	10	Not Sampled	Not Sampled	0.1	33																						True	False	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																																																																																																																									0	0		No	Yes	68	60			2	11/8/2007 7:44:00 AM
Flint Creek Parking Lot Right (PLR)	20527	929002	9/28/2007	900	333333	Sally Coleman	Not Recorded	Not Recorded	True	False	False	False	False	False	80		8	10	0	0	0.2	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	19	0.3	Not Sampled	0.14	0.18	0.21	0.3	0.22	0.12	0.15	0.12	0.13	0.1	0.08	0.08	0.06	0.05	0.05	0.06	0.07	0.03	0																																										17.6	10.9	9.7	7.4	5.1	11.2	9.4	7.5	11.1	8.9	10.3	14.2	0	0	0	13.5	11.8	0	0																																										0.2191924	0.1131579	0.10195	No	Yes	64	60+			2	11/1/2007 1:45:00 PM
Flint Creek Site #2	5346	929001	10/21/2002	1730	222209	Carrie Boyd, Kaitlyn Suveg, Kris Griffin, Wesley Hard, Jeanette Boche, Laura Wood, Max Paul			True	False	False	False	False	False	63.7	0	9	10	0	0	0	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		16.7			0.1	0.065	0.04	0	0	0	0	0	0	0	0.08	0.035	0.03	0.085	0.075	0.18																																													4.16	3.67	0	0	0	0	0	0	0	0	5.07	0	10.68	8.16	3.87	4.99																																													0.1262064	0.043125	0.1829078			53.5	60+	Fog		1	4/17/2003 9:38:00 PM
Flint Creek Site #2	5368	929001	11/18/2002	1600	222209	Kaitlyn Suveg, Max Paul, Jeanette Boche, Wesley Hard			True	False	False	False	False	False	41	0	9	12	0	0	0.1	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		17.08			0.07	0.08	0.025	0	0	0	0	0	0	0.015	0.06	0.03	0.155	0.06	0.075	0.235																																													4.75	3.25	0	0	0	0	0	0	0	0	6.68	0	3.47	7.37	4.28	3.56																																													0.1846786	0.0503125	0.2294144			39.5	60+			1	4/17/2003 9:47:00 PM
Flint Creek Site #2	5270	929001	12/16/2002	800	222209	Wesley Hard, Max Paul, Laura Wood, Jeanette Boche, Kaitlyn Boche, Carrie Boyd			False	False	True	False	False	False	40.1	0	9	12	0	0	0	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		16			0.09	0.07	0	0	0	0	0	0	0	0.06	0.04	0.08	0.04	0.08	0.22	0																																													12.25	3.88	0	0	0	0	0	0	0	5.28	0	5	8.88	3.41	3.21	0																																													0.1492525	0.0425	0.2194891			33.8	60+		Not on this date.	1	3/31/2003 3:41:00 PM
Flint Creek Site #2	5350	929001	3/25/2003	1600	222209	Jeanette Boche, Wesley Hard, Carrie Boyd, Kris Griffith, Kaitlyn Suveg			False	True	True	False	False	True	55.4	0	9	8	0	0	0.1	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		21.48			0.05	0.02	0	0.03	0.07	0.06	0.04	0.09	0.07	0.09	0.07	0.09	0.1	0.18	0.2	0.11	0.13	0.18	0.17	0.18	0.23																																								19.59	0	0	0	3.03	5.93	0	3.69	2.81	3.5	3.06	5.56	2.25	2.03	1.97	2.43	2.48	2.41	3.25	2.72	3.85																																								0.7350884	0.1028571	0.3403187			55.4	60+			1	4/17/2003 9:55:00 PM
Flint Creek Site #2	1409	929001	10/18/2003	1330	222209	David Tharp, Ashley Moler, Tyler Farber, Nathan Roberts			True	False	False	False	False	False	72.5	0	9	8	0.15	0	0.2	Not Sampled																						True	True	False	False	False	False	False			True	False	False	False		22.5			0.07	0.07	0.1	0.1	0.1	0.04	0.04	0.03	0	0.01	0.02	0.01	0.01	0	0	0	0.01	0	0	0.06	0.12																																								0	73	0	9.8	7.5	7	0	0	0	0	0	0	0	0	0	0	0	0	0	5.1	5.2																																								6.505223E-02	3.761905E-02	0.0823446			63.8	0	Lots of moss on rocks and leaves in stream bed. Found a metal pipe.	Chlorine-lamotte calorimeter, ammonia-nitrogen used CBL, BOD- lamotte calorimeter and CBL, turbidity-CBL, TDS-conductiuvity probe, TSS-evaporation method, fecal coliform- millipore, e-coli- coliscan EZGel	1	10/24/2003 3:48:00 PM
Flint Creek Site #2	8688	929001	10/23/2004	800	222209		1	4	True	False	False	False	True	False	67.4	0.75	8	6	0.3	2	0.2	Not Sampled																						False	True	False	False	False	False	False			True	False	False	False					0.52																																																																																																																								0	0.52				58	4	Because of all the rain, the stream was too deep and the current was too fast to measure the depth or the width.		1	11/19/2004 1:24:00 PM
Flint Creek Site #2	8878	929001	11/16/2004	1600	222209	Nathan Roberts, Tyler Farber, Valerie Jarvis, Carolyn Jennings	1	4	False	True	False	False	False	True	70	0.01	7	8	0.15	2	0.2	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		23.25			0.18	0.18	0.15	0.2	0.21	0.21	0.16	0.16	0.12	0.11	0.13	0.15	0.17	0.15	0.25	0.3	0.4	0.34	0.16	0.18	0.2	0.17																																							0	2.29	1.69	2.09	1.6	1.28	2.5	2.15	1.97	2.88	2.78	2.4	2.91	3.75	2.23	3.13	2.87	3.56	3.6	3.5	3.41	6.69																																							1.626343	0.1945454	0.3799866				60			1	12/6/2004 1:01:00 PM
Flint Creek Upstream Left (USL)	20537	929007	9/14/2007	1130	333333		3	0	True	False	False	False	False	False	59	0	9	10	0	2	0.2	33																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	15.25		Not Sampled																																																																																																																									0	0		No	Yes	63	Not Sampled			2	11/2/2007 2:05:00 PM
Flint Creek Upstream Left (USL)	20538	929007	9/14/2007	1130	333333		3	0	True	False	False	False	False	False	59	0	9	10	0	2	0.2	33																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	15.25		Not Sampled																																																																																																																									0	0		No	Yes	63	Not Sampled			2	11/2/2007 2:05:00 PM
Flint Creek Upstream Middle (USM)	20519	929006	9/14/2007	800	333333		3	0	True	False	False	False	False	False			9	10	0	0	Not Sampled	33																						True	False	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																																																																																																																									0	0		No	Yes		60+			2	10/30/2007 7:06:00 PM
Flint Creek Upstream Middle (USM)	20520	929006	9/14/2007	800	333333		3	0	True	False	False	False	False	False			9	10	0	0	Not Sampled	33																						True	False	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																																																																																																																									0	0		No	Yes		60+			2	10/30/2007 7:06:00 PM
Flint Creek Upstream Middle (USM)	20174	929006	9/14/2007	1430	333333		3	0	True	False	False	False	True	False	58	0	9	12	0	2	Not Sampled	Not Sampled																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	18.8	0.26	Not Sampled	0.03	0.06	0.06	0.07	0.07	0.08	0.05	0.14	0.15	0.15	0.22	0.21	0.18	0.23	0.14	0.2	0.26	0.08																																											0	7	5	7	5	6	5	7	4	5	3	7	5	3	6	0	7	7																																											0.4433095	0.1322222	0.1862645	No	Yes	68	60+			2	10/10/2007 9:04:00 AM
Flint Creek Upstream Right (USR)	20144	929005	9/14/2007	1130	333333		3	Not Recorded	True	False	False	False	False	False			7	10	0	0	Not Sampled	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	15	0.3	Not Sampled	0.02	0.18	0.3	0.29	0.24	0.23	0.22	0.2	0.17	0.08	0.11	0.08	0.02	0.01	0																																														21	10	9	8	5	6	7	6	7	5	6	9	22	0	0																																														0.308048	0.1433333	0.1432781	No	Yes	60	60			2	10/8/2007 7:34:00 AM