Iowater Datatable ( Huc 8 Watershed: 07080209 - Iowa River

IOwater Chemical/Physical Assessment Summation Table for HUC 8 Watershed: Iowa River - Lower (07080209)

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	SVspot1	SVspot2	SVspot3	SVspot4	SVspot5	SVspot6	SVspot7	SVspot8	SVspot9	SVspot10	SVspot11	SVspot12	SVspot13	SVspot14	SVspot15	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
280th Stream Site	9806	948064	3/10/2005	1030	120402	high school conservation ecology class	1	7	False	True	False	False	True	False	42	1	6	10	0.3	10	0	28																						True	False	False	False	False	False	False			True	False	False	False		0.86			0.055															3.04															1.809211E-02	0.055	0.3289474			38	60+	very windy day, it snowed earlier in the morning		1	4/6/2005 3:19:00 PM
Buck Creek	6233	952054	5/24/2003	930	040030	Max T. , Stephen J. , Dan S.			False	True	False	False	False	True	64	0	8	6	0.15	2	0.6	<25																						True	False	False	False	False	False	False			True	False	False	False		13.7																																	0	0				56	60+	Iowa River is backed up into Buck Creek at this time. Too deep to measure depth and velocity.	We used an electronic Dissolved Oxygen and temperature data logger for verification of IOWATER tests.	2	6/23/2003 11:05:00 AM
Buffalo x 1/2 Moon	18498	952152	5/25/2007	1000	180606		1	5	True	False	False	False	False	False	62	0.2	8	10	0.15	2	0.3	41																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	2.6	0.23	Normal	0.12	0.15														5	14														3.471429E-02	0.135	0.1285714	No	Yes	58	32			1	6/1/2007 1:41:00 PM
Buffalo x 1/2 Moon	19946	952152	9/10/2007	800	180606		1	7	False	False	False	True	False	False		0.4	7	6	0.15	2	1	Not Sampled																						False	True	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																															0	0		No	Yes		Not Sampled			1	9/21/2007 3:05:00 PM
Buffalo x 1/2 Moon	20515	952152	10/29/2007	800	180606		1	7	True	False	False	False	False	False	50	0	6	6	0	2	0	27																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	3.5	0.17	Normal	0.17	0.08	0.05													5	5	8													0.05625	0.1	0.1875	No	Yes	51	46			3	10/29/2007 1:39:00 PM
Buffalo x 1/2 Moon	21765	952152	3/24/2008	1300	180606		1	7	True	False	False	False	False	False	51	0	6	8	0.15	2	0	33	0	0	0	0	26	21	17	2133	2133	0	0	0	2600	2100	1700	2600	2100	1700	48	84	1	True	True	False	False	False	False	False	False	False	False	True	False	False	False	3.8	0.4	Normal	0.4	0.38	0.3													7	4	7													0.195	0.36	0.1805556	No	Yes	42	53	Compare bacteria count with same date at Buffalo x Hwy 6	no	3	3/28/2008 7:12:00 AM
Buffalo x Hwy. 6	18499	952153	5/25/2007	1100	180606		1	5	True	False	False	False	False	False	62	0.2	7	10	0.15	1	0.1	48																						True	False	False	False	False	False	False	False	False	False	False	True	False	False	2.9	0.2	Normal	0.2	0.19														8	4														0.0725	0.195	0.1858974	No	Yes	57	34		n0	1	6/1/2007 1:49:00 PM
Buffalo x Hwy. 6	19945	952153	9/10/2007	800	180606		1	7	False	False	False	True	False	False		0.4	7	6	0.3	1	1	27																						False	True	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																															0	0		No	Yes		Not Sampled			1	9/21/2007 3:02:00 PM
Buffalo x Hwy. 6	20516	952153	10/29/2007	1330	180606		1	7	True	False	False	False	False	False	51	0	6	6	0	2	0.1	27																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	3.9	0.4	Normal	0.4	0.14	0.14													4	6	6													0.1466667	0.2266667	0.2156863	No	Yes	51	38			3	10/29/2007 1:42:00 PM
Buffalo x Hwy. 6	21766	952153	3/24/2008	1330	180606		1	7	True	False	False	False	False	False	53	0	6	6	0	0	Not Sampled	44	6	8	13	900	90	100	92	9400	10300	600	800	1300	9000	10000	9200	9600	10800	10500	48	84	1	True	False	False	False	False	False	False	False	False	True	False	False	False	False	8	0.52	Normal	0.52	0.2	0.1	0.15	0.15	0.22	0.04									0	7	5	3	3	3	4									0.2319048	0.1971429	0.1680469	No	Yes	44	24	Compare bacteria with same date at Buffalo x 1/2 moon. The change occurs after the stream passes a large animal confinement.	no	3	3/28/2008 7:17:00 AM
Clear Creek	6020	952024	1/12/2001	800	010110	Nate Stezer, Ray Reynolds, Jeff Johnson, Dana Ruckebeil, Jen Crook, Brian Kriener			False	True	False	False	False	False	62	0.74	8	8	0	1	0.5	<25																						False	True	False	False	False	False	False			True	False	False	False		13																																	0	0				55	15	students calculated that the average depth was 0.27 meters, velocity was 1m/1.5 seconds		2	3/1/2002 12:45:00 PM
Clear Creek	6382	952024	7/11/2001	1200	010110				False	True	False	False	False	True	94	74	9	5	0	5	0.4	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		14			0.42	0.35	0.31	0.31	0.31	0.29	0.26	0.24	0.27	0.29	0.18	0.22	0.13			8	7	4	3	3	3	3	3	5	4	3	4	6			0.9131666	0.2753846	0.2550745			74	24.5			2	11/11/2001 4:42:00 PM
Clear Creek	4533	952024	8/10/2001	1130	010110				True	False	False	False	False	False	78	0	9	5	0.15	5	0.4	<25	2	3	6	183	100	100	100	5000	5183	100	150	300	5000	5000	5000	5100	5150	5300	24	96	2	True	True	False	False	False	False	False			True	False	False	False		13			0.28	0.1	0.08	0.12	0.13	0.16	0.13	0.15	0.13	0.1	0.08	0.08				5	4	4	3	3	3	3	3	3	3	4	874				0.4277582	0.1283333	0.2777651			74	60			2	3/1/2002 12:04:00 PM
Clear Creek	4534	952024	9/13/2001	1000	010110	Jen Crook, Brian Kriener, Dana Ruckebeil, Jeff Johnson, Chris Buck, Ray Ryenolds, Nate Setzer, Tim Chila			False	True	False	False	False	False	70	0	9	4	0	1	Not Sampled	36																						True	False	False	False	False	False	False			True	False	False	False		9.2																																	0	0				64	41	students have the data at school but the calcualted average depth is 1.62 m and the velocity was 1m/2.51 seconds		2	3/1/2002 12:17:00 PM
Clear Creek	6083	952024	9/20/2001	1000	010110				True	False	False	False	False	False	65	1.2	8	6	Not Sampled	Not Sampled	Not Sampled	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False																																			0	0				65	36			2	3/1/2002 12:39:00 PM
Clear Creek	6084	952024	10/12/2001	1000	010110	Nate Setzer, Brian Kriener, Jeff Johnson, Ray Reynolds, Dana Ruckebeil, Jennifer Crook			False	True	False	False	False	False	62	0.74	7	6	0	1	0.6	<25																						False	True	False	False	False	False	False			True	False	False	False		13			0.27	0.12	0.14	0.2	0.14	0.15	0.27	0.24	0.28	0.15	0.18	0.7				0	7.3	12.9	3.8	3.9	3.3	4.5	2.8	4.6	3.2	2.5	3.8				0.670944	0.2366667	0.2362479			54	44			2	3/1/2002 12:52:00 PM
Clear Creek	6085	952024	10/23/2001	1000	010110	Brian Kriener, Dana Ruckebeil, Nate Setzer, Ray Reynolds, Jennifer Crook, Jeff Johnson			False	False	True	False	True	False	62	4	7	5	0.15	1	Not Sampled	<25																						False	False	False	False	False	False	False			False	False	False	False		12.8																																	0	0				55	15	There had been a heavy rain the night before our sampling. We could not enter the creek for depth or velocity. Using an orange thrown over a bridge we calculated a 1.5m/second flow. There was too much sediment in the water to be able to read the phosphate test accurately. We did not have filters at that time.		2	3/1/2002 1:01:00 PM
Clear Creek	6086	952024	1/10/2002	930	010110	Dana Ruckebeil, Jennifer Crook, Nate Setzer, Jeff Johnson, Ray Reynolds, Brian Kriener			False	False	True	False	True	False	39	0	7	10	0	2	0.3	36																						True	False	False	False	False	False	False			True	False	False	False																																			0	0				32	60			2	3/1/2002 1:05:00 PM
Clear Creek	2636	952024	5/23/2002	800	010110	Dan Meier, Ray Reynolds, Jenn Crook, Brian Kreiner, Nat Setzer, Jeff Johnson, Dana Ruckebeil			False	False	True	False	False	False	60	0	7	8	0.15	5	0.6	<25																						False	True	False	False	False	False	False			True	False	False	False		14.49			0.21	0.28	0.32	0.33	0.4	0.41	0.41	0.43	0.44	0.49	0.44	0.43	0.46	0.33		7	6	4	4	3	3	2	3	2	2	3	2	3	5		1.9035	0.3842857	0.3538104			58	16			2	8/9/2002 11:29:00 AM
Clear Creek	5269	952024	9/19/2002	930	010110	see 9/26/02 biological assessment			False	False	True	False	True	False	64	0	6	Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled																						False	True	False	False	False	False	False			True	False	False	False		9.4			0.3	0.3	0.34	0.34	0.34	0.2	0.16	0.14	0.01							7	6	5	6	6	5	11	13	0							0.3395052	0.2366667	0.1593921			66	5.5		No	2	4/3/2003 3:41:00 PM
Clear Creek	5277	952024	9/26/2002	930	010110	ECHO alternative high school students			True	False	False	False	False	False	64	0	8	6	0	2	0.2	49																						False	True	False	False	False	False	False			True	False	False	False																																			0	0				54	47		No	2	4/3/2003 3:45:00 PM
Clear Creek	5278	952024	10/3/2002	900	010110	ECHO alternative high school students			False	False	True	True	False	False	57	3.5	8	8	0	2	1	<25																						False	True	False	False	False	False	False			True	False	False	False																																			0	0					8.5	There had been a huge rain the night before. We could only sample velocity and width from a bridge over the creek and measured it to be approximately 18 meters. Velocity was 10.4 meters in 9 seconds.	No	2	4/3/2003 3:51:00 PM
Clear Creek	5286	952024	4/3/2003	930	010110	Environmental Science Class			False	True	True	False	False	True	65		9	10	0.15	2	0.2	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		11			0.13	0.09	0.15	0.14	0.12	0.11	0.16	0.175	0.18	0.17	0.105					3	4	4	5	4	5	3	4	3	4	5					0.4039167	0.1390909	0.2639978			56	60+	There was a 4 to 5 month drought that may be the cause for some of this data.		2	4/8/2003 10:51:00 AM
Clear Creek	5287	952024	4/3/2003	930	010110	Environmental Science Class			False	True	True	False	False	True	65		9	10	0.15	2	0.2	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		11			0.13	0.09	0.15	0.14	0.12	0.11	0.16	0.175	0.18	0.17	0.105					3	4	4	5	4	5	3	4	3	4	5					0.4039167	0.1390909	0.2639978			56	60+	There was a 4 to 5 month drought that may be the cause for some of this data.		2	4/8/2003 10:56:00 AM
Clear Creek	5383	952024	4/24/2003	1100	010110	Environmental Science Class			False	False	True	True	True	False	54	0	9	10	0.15	2	0.2	Not Sampled	1	2	2	83	100	100	100	5000	5083	50	100	100	5000	5000	5000	5050	5100	5100	26	90	2	False	True	False	False	False	False	False			True	False	False	False																																			0	0				52	24	It had rained an inch and a half 2 days prior to testing. we were not able to do the stream width, depth and velocity. Our chloride test strips were expired.		2	4/25/2003 1:40:00 PM
Clear Creek	13504	952024	10/6/2005	1300	010110	Nate Kray, Ashley Schulte, Wesley Weston, Steve Myers, Jesse Powers, Vince Geary	5	4	False	True	False	False	False	False	46	0	7	6	0	0	0.1	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False																																			0	0				54	25			2	12/16/2005 9:10:00 AM
Clear Creek (down)	3961	952009	9/17/2000	1630	180014	Sue Ross-Barta			True	False	False	False	False	True	76	0	9	8	0	1	Not Sampled	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		9.2			0.12	0.14	0.13	0.15	0.13	0.12	0.13	0.16	0.25							5	5	6	5	6	6	5	6	6							0.2396667	0.1477778	0.1802005			72	60+		No.	1	9/21/2000 4:22:00 PM
Clear Creek (down)	4379	952009	9/2/2001	1200	180014	Sue Ross-Barta			True	False	False	False	False	True	77	0	9	10	0	1	0.4	Not Sampled																						False	False	False	True	False	False	False			False	True	False	False		13.54			0.202	0.202	0.205	0.125	0.143	0.065	0.025	0.15	0	0	0	0.075	0.1			5	5	4	5	6	6	6	6	0	0	0	7	0			0.2315976	9.938461E-02	0.1792551			74	60+	A drainage pipe, approx. 18-24" in diameter, (on the stream's north bank) from the Coralville Water Treatment Plant was flowing moderately the entire time we completed our sampling at the upstream and downstream sites. The downstream site is approx. 50-75 m downstream of this pipe. An oily sheen was present on the side of the stream with the pipe, and a slight, but noticeable, sewage odor was present. Algae growth on the stream bed was noticeably greater than that of the upstream site, but still within the 5-25% range. This is the first time in several visits to this site at various times of the year that we have seen an outflow from this pipe.	No.	1	10/12/2001 2:00:00 PM
Clear Creek (down)	5113	952009	9/2/2002	1530	180014	Sue Ross-Barta			False	True	False	False	False	True	84	0.4	9	8	0	1	0.4	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		13.8			0.21	0.35	0.33	0.23	0.14	0.12	0.09	0.1	0.12	0.29	0.19	0.18	0.22			5	4	3	4	4	5	6	6	8	8	0	35	30			0.4513929	0.1976923	0.1756392			76	34	Outflow pipe from City Of Coralville water treatment plant not flowing during our sampling time.	No.	1	9/8/2002 10:22:00 AM
Clear Creek (down)	1613	952009	8/24/2003	1230	180014	Sue Ross-Barta			True	False	False	False	False	True	84	0	9	8	0	1	0.4	Not Sampled																						True	False	False	True	False	False	False			True	False	False	False		9.25			0	0.09	0.015	0.01	0.085	0.115	0.165	0.18	0.13							0	34	0	0	0	11	7	7	11							0.0742055	8.777778E-02	9.393101E-02			78	46	Oily sheen only along left bank.	No.	1	10/7/2003 1:56:00 PM
Clear Creek (down)	8676	952009	9/25/2004	1200	180014	Sue Ross-Barta	2	0	True	False	False	False	False	True	71	0	9	8	0	1	0.2	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		14.1			0.11	0.22	0.23	0.18	0.17	0.14	0.12	0.11	0.11	0.11	0.12	0.13	0.23	0.18		0	0	0	0	9	8	6	7	8	7	14	9	50	0		0.1291833	0.1542857	0.0598071			63	60+		No.	1	11/21/2004 11:33:00 AM
Clear Creek (up)	6150	952008	9/17/2000	1430	180014	Sue Ross-Barta			True	False	False	False	False	False	82	0	9	6	0	1	Not Sampled	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		11.75			0.25	0.25	0.09	0.41	0.33	0.28	0.25	0.15	0.2	0.18	0.13					0	26	13	8	7	7	9	19	17	13	17					0.2238618	0.2290909	8.883402E-02			72	60+	We double-checked pH with a second test strip; it read 9 each time.	No.	1	9/20/2000 4:20:00 PM
Clear Creek (up)	4356	952008	9/2/2001	1030	180014	Sue Ross-Barta			False	True	False	False	False	True	76	0	9	8	0	1	0.3	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		12.54			0.256	0.278	0.275	0.212	0.134	0.087	0.063	0.035	0.015	0.15	0.545	0.192				13	13	8	7	12	12	16	0	0	0	25	15				0.1626918	0.1868333	7.256548E-02			69	60+	Flow seemed similar to sampling time last year.	No.	1	10/12/2001 1:34:00 PM
Clear Creek (up)	5112	952008	9/2/2002	1330	180014	Sue Ross-Barta			False	True	False	False	False	True	88	0.4	9	8	0	1	0.4	Not Sampled																						False	True	False	False	False	False	False			True	False	False	False		14.1			0.53	0.54	0.61	0.72	0.62	0.49	0.33	0.34	0.51	0.75	0.71	0.6	0.59	0.03		32	22	15	12	10	10	14	15	20	20	15	20	28	0		0.4604175	0.5264286	6.247184E-02			75	60+	Stream bed has been deepened at this site from what I recall in previous years. Assume this is a natural change over time.SIte is becoming more like a pool, but we still classified it as a run due to the current.	No.	1	9/8/2002 9:59:00 AM
Clear Creek (up)	1612	952008	8/24/2003	1130	180014	Sue Ross-Barta			True	False	False	False	False	True	90	0	9	8	0	0	0.4	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		8.75			0.21	0.25	0.32	0.29	0.21	0.13	0.13	0.08								24	22	21	14	10	23	40	18								9.041264E-02	0.2025	5.581027E-02			75	56	None.	No.	1	10/7/2003 1:35:00 PM
Clear Creek (up)	8675	952008	9/25/2004	1030	180014	Sue Ross-Barta	2	0	True	False	False	False	False	True	73	0	9	8	0	1	0.2	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		15.15			0.06	0	0	0	0.14	0.22	0.33	0.42	0.41	0.44	0.32	0.2	0.1	0.24	0.07	0	0	0	0	9	8	6	7	8	7	14	9	50	0	0	0.3192421	0.1966667	0.1082176			66	60+	Many frogs and minnows present at site	No.	1	11/21/2004 11:22:00 AM
Clear Creek at Tiffin	3404	952019	9/13/2001	900	190005	Coblentz, Compton, Slaymaker, Walter, Kinney, Kleinmeyer			False	False	True	False	False	True	70	0	8	10	0	1	5	Not Sampled																						False	False	False	False	False	False	False			False	False	False	False																																			0	0								1	9/13/2001 9:48:00 AM
Clear Creek at Tiffin	5603	952019	4/17/2003	930	190005	Joe Coblenz, Tracie John, Nathan Schetz, Joe Burns, Kevin Steckley			False	False	True	False	True	False	54	0.5	7	8	1.0	2	2	Not Sampled																						False	True	False	False	False	False	False			True	False	False	False		12.2			0.7	0.11	0.15	0.15	0.17	0.2	0.14	0.9	0.18	0.26	0.31	0.4				0	0	2.9	3.47	4	3.75	2.37	2.56	2.5	2.1	2.18	2.69				1.08813	0.3058333	0.2964931			45	32			1	5/23/2003 9:26:00 AM
Clear Creek at Tiffin	20213	952019	10/10/2007	1030	190005	HIgh School Environmental Science Class	1	9	False	False	True	False	False	False	47	0	8	8	0.15	2	0.4	Not Sampled																						False	True	True	False	False	False	False	False	False	True	False	False	False	False	13	0.39	High	0.26	0.31	0.25	0.32	0.32	0.39	0.33	0.33	0.34	0.335	0.36	0.3	0.37			3.27	2.32	2.86	3	2.56	2.93	2.77	3.44	2.81	2.84	4.39	4.3	3.9			1.365978	0.3242308	0.3240755	No	Yes	64	44				10/12/2007 11:18:00 AM
Clear Creek/Jasper Street (Tiffin)	1423	952060	10/18/2003	1030	130204	Tim Surine, Kinnick			True	False	False	False	False	True	63	0	8	10	0.15	2	0.6	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False																																			0	0				48	52.25	Stream velocity was not measured, but flow was very slow. pH was between 8 and 9.		1	10/24/2003 1:29:00 PM
Cone Marsh Inlet	5754	958003	5/18/2003	1200	040315				False	False	True	False	False	False	65	0	8	8	0.15	2	0.3	Not Sampled																						False	True	False	False	False	False	False			True	False	False	False		8			0.02	0.32	0.36	0.58	0.52	0.53	0.57	0.1								60	50	25	20	20	10	30	52								0.1500564	0.375	0.0500188			60	56			1	5/31/2003 7:20:00 PM
Cone Marsh Inlet	6432	958003	6/22/2003	1130	040315				True	False	False	False	False	False	71	0	8	8	0	2	0.2	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		7.8			0.4	0.53	0.47	0.44	0.47	0.9	0.6									60	25	40	50	90	90	60									7.363889E-02	0.5442857	1.932779E-02			66	60+			1	6/28/2003 9:03:00 AM
Cone Marsh Inlet	1868	958003	8/17/2003	1230	040315				True	False	False	False	False	False	79	0	8	8	0.15	2	0.2	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		7.9			0.21	0.31	0.41	0.5	0.4	0.41	0.4									36	13	14	30	20	28	17									0.1338041	0.3771428	5.068339E-02			69	60+			1	8/22/2003 8:03:00 AM
Cone Marsh outlet	5753	958005	5/18/2003	1000	040315				False	True	False	False	False	False	74	0	7	8	0.15	0	1	Not Sampled																						False	True	False	False	False	False	False			True	False	False	False		9			0.25	0.26	0.29	0.33	0.38	0.45	0.42	0.32								0	14	8	25	11	20	10	14								0.189924	0.3375	7.034224E-02			67	11	It seems that bow fishing is popular in this spot. The banks were littered with carcasses.		1	5/31/2003 6:59:00 PM
Cone Marsh outlet	6487	958005	6/22/2003	1030	040315				True	False	False	False	False	False	82	0	9	8	0	1	1	Not Sampled																						False	True	False	False	False	False	False			True	False	False	False		8.4			0.18	0.3	0.27	0.21	0.18	0.12	0.1	0.05								180	130	80	120	60	50	80	60								1.591603E-02	0.17625	1.128796E-02			75	5			1	6/28/2003 9:08:00 AM
Cone Marsh outlet	1869	958005	8/17/2003	1130	040315				True	False	False	False	False	False	93	0	9	8	0.15	0	0.8	Not Sampled																						False	True	False	False	False	False	False			True	False	False	False		3.7			0.008	0.013	0.001													0	0	0													0	7.333333E-03	0			81	6			1	8/22/2003 8:15:00 AM
Cone Marsh outlet	1548	958005	10/18/2003	1130	040315				True	False	False	False	True	False	58	0	Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled																						False	False	False	False	False	False	False			False	False	False	False																																			0	0						Stream was dry. main channel was a mudflat. Grasses are growing.		1	10/18/2003 12:31:00 PM
Convey Creek (V Ave)	683	948019	4/17/2004	1730	140317	brandyn	1	1	True	False	False	False	False	False	77	0.05	8	6	0.15	10	0	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		2.7			0.11	0.11														4	4														0.055	0.11	0.25			61	60+			1	4/21/2004 8:17:00 AM
Convey Creek (V Ave)	8001	948019	5/16/2004	1230	140317	tracy	2	0	False	True	False	False	False	False	71	0	8	8	0.15	10	0.2	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		2.7			0.17	0.11														7	22														2.928571E-02	0.14	0.1045918			58	60+			1	9/27/2004 10:57:00 PM
Convey Creek (V Ave)	11272	948019	6/12/2005	1730	140317	Brandyn Chapman	1	1	True	False	False	False	False	False	75	0	7	6	0.15	5	0.5	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		2.45			0.19	0.17																													0	0.18				64	60			1	6/30/2005 7:06:00 PM
Convey Creek (V Ave)	12995	948019	10/2/2005	1700	140317	Shane Chapman	Not Recorded	Not Recorded	False	True	False	False	False	False			Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled																						False	False	False	False	False	False	False			False	False	False	False																																			0	0					Not Sampled	Stream was dried up and we were unable to do any monitoring		1	10/2/2005 8:49:00 PM
Convey Creek (V Ave)	18048	948019	4/29/2007	1630	140317	Brandyn & Shane	1	2	True	False	False	False	False	False	76	0	8	10	0.15	5	0.1	Not Sampled																						False	True	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																															0	0		No	Yes	55	33			1	4/29/2007 11:05:00 PM
Deer Creek (Angle Road)	4262	952020	5/16/2001	1300	010109	high school biology class			True	False	False	False	False	True	85	0	7	8	0.15	5	Not Sampled	Not Sampled																						False	True	False	False	False	False	False			True	False	False	False		6			0.25	0.5	0.75	1	0.35											4.5	3.5	3.5	2	2											1.087698	0.57	0.3816486			64.5	9	Banks were covered with fine layer of silt over grass, showing recent flooding. Banks downstream were breaking off and ready to fall into stream.Downstream cattle were grazing and breaking down banks. Distance of flood plain to channel bed about 3 meters (ie, depth of gully)	No	1	5/19/2001 5:16:00 PM
Deer Creek (Angle Road)	4490	952020	9/12/2001	1100	010109	biology class			True	False	False	False	False	True	75	0	8	8	0.3	1	1	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		1.5			0.05															12															4.166667E-03	0.05	8.333334E-02			65	26		no	1	12/31/2001 2:11:00 PM
Deer Creek (Angle Road)	5996	952020	5/8/2003	1300	010109	high school biology class			False	True	False	False	True	False	56	0	8	10	Not Sampled	2	0.2	Not Sampled																						True	True	False	False	False	False	False			True	False	False	False		7			0.26	0.23	0.25	0.22	0.25											3	4	4	3	4											0.3425	0.242	0.2830578			49	25		no	1	6/10/2003 6:40:00 PM
Deer Creek (Angle Road)	513	952020	5/17/2004	1500	010109		1	3	False	True	False	False	False	False	83	0	8	10	0.15	5	0.4	Not Sampled																						True	True	True	False	False	False	False			True	False	False	False		3			0.21	0.23	0.24													3	3	2													0.2666667	0.2266667	0.3921569			68	36			1	5/18/2004 1:29:00 PM
Deer Creek (Angle Road)	10408	952020	5/13/2005	1100	010109	Biology Class	1	10+	False	False	True	True	False	False	63	1	7	5	0.15	5	1	Not Sampled																						False	True	False	False	False	False	False			True	False	False	False		9			0.68	0.75	0.67	0.82	0.81	0.8	0.78									2.7	2.1	2.2	2.7	2.1	2.1	2.7									2.272799	0.7585714	0.4280225			56	8			1	5/18/2005 2:25:00 PM
Deer Creek (Angle Road)	18312	952020	5/10/2007	1100	010109		1	10+	True	False	False	False	False	True	65	0	8	12	0.15	Not Sampled	3	Not Sampled																						False	False	True	False	False	False	False	False	False	True	False	False	False	False	9.8	0.57	Not Sure	0.28	0.43	0.44	0.41	0.46	0.57	0.49	0.39								3.5	3	3	2	2	2	2	2								1.53	0.43375	0.4409222	No	Yes	53	23			1	5/10/2007 2:02:00 PM
Dirty Face Creek	5048	952042	8/2/2002	1000	150114	David Curry, Wayne Peterson, Liz Bisbey-Kuehn, Carol Spaziani, Bob Sayre, Laura Sayre			True	False	False	False	False	True	67	0	9	6	0.3	2	2	<25	0	0	0	0	27	27	21	2500	2500	0	0	0	2700	2700	2100	2700	2700	2100	24	83	1	True	True	False	False	False	False	False			True	False	False	False		3.45			0.22	0.22	0.1													0	8	15													3.416667E-02	0.18	0.0632716			72	29	Site is just downstream from a beaverdam and is deeply incised.	No	2	8/29/2002 2:18:00 PM
Dirty Face Creek	5664	952042	5/24/2003	1230	150114	Wayne Peterson, Bob Sayre			False	True	False	False	False	True	73	0	9	10	0.15	5	0.4	Not Sampled																						True	True	False	False	False	False	False			True	False	False	False		2.7			0.06	0.1														2	2														0.08	0.08	0.5			56	60+	Beaver dam upstream from site had been breached within last month. A new silt delta had been deposited in pool below site since last year, and bank erosion had occurred above the site (and just below the breach in the dam).		2	5/25/2003 7:46:00 PM
East Creek	28775	992013	5/18/2010	1400	080110	biology class	1	10+	True	False	False	False	False	False	71	0	7	8	0.15	10	0.8	40																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	3.5	0.38	Not Sure	0.38	0.38																													0	0.38		No	Yes	67	47	Our velocity average was .02 meters per second. We use a velocity sensor with a computer hand-held device so we can`t report as shown above.		2	6/10/2010 7:39:00 AM
English River	3639	992001	10/13/2000	1200	090018	Max Lewis, Laura Conaway			False	True	False	False	False	False	74	0	7	12	0	1	Not Sampled	Not Sampled																						True	False	False	False	False	False	False			True	False	False	False		15.2			0.1	0.3	0.54	0.52	0.72	0.56	0.53	0.47	0.36	0.32	0.32	0.4	0.4	0.26	0.2	15	2	3	3	4	2	3	3	4	5	3	6	12	8	10	1.7165	0.4	0.2860833			55	48			1	11/9/2000 1:04:00 PM
Forest Hill Culvert	26588	952200	8/1/2009	1700	020906	Dave Kincade, James Kincade	2	1	False	True	False	False	False	True	71	0	8	6	0	2	0.4	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	1.07	0.05	Not Sampled																															0	0		No	Yes	68	60+	Clear flow, cool and clear day	N/A	1	8/5/2009 7:24:00 PM
Forest Hill Culvert	26808	952200	9/13/2009	1400	020906	Dave and James Kincade	2	1	True	False	False	False	False	False	78	0	8	8	0	2	0.3	73																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	1.3	0.05	Normal																3.5															0	0		No	Yes	68	60+	Deepest part of the stream has shifted from the east to the west shoreline.		1	9/13/2009 3:06:00 PM
Fredonia Boat Ramp	14480	958008	6/11/2005	1300	030509	summer chandler, madison chandler, brian jaworski, jessica jaworski	1	4	False	True	False	False	False	False	71	0	7	10	3	2	0.1	Not Sampled																						True	True	False	False	False	False	False	False	False	True	False	False	False	True			Not Sampled																															0	0		No	Yes	58	Not Sampled	fishing pretty good according to boaters	no	1	3/27/2006 8:19:00 PM
Hawkeye Trail Stream	16472	952139	10/8/2006	930	170601	Jennifer Bair	2	0	True	False	False	False	False	False	60	0	8	8	0.15	2	0.2	33																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	2.4	0.15	Low	0.15	0.1														30	20														0.01	0.125	0.04	No	Yes	51	60+			2	10/21/2006 9:56:00 AM
Hawkeye Trail Stream	16938	952139	12/2/2006	1400	170601	Jennifer Bair	2	Not Recorded	True	False	False	False	False	False	30	0	7	10	0	2	0	78	0	0	1	33	63	66	39	5600	5633	0	0	100	6300	6600	3900	6300	6600	4000	48	95	1	True	False	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																															0	0		No	Yes	32	60+			2	12/9/2006 5:29:00 PM
Hawkeye Trail Stream	19796	952139	8/26/2007	930	170601	Jen Bair	2	0	True	False	False	False	False	False	72	0	8	12	0	2	0.4	39	2	10	1	433	100	100	100	10000	10433	200	1000	100	10000	10000	10000	10200	11000	10100	48	95	1	True	True	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																															0	0		No	Yes	64	55	Fairly high flow and level compared to normal. Evidence of higher flooding.		2	8/28/2007 8:53:00 PM
Indian Creek	8565	958006	11/2/2004	1600	222225	Lindsey McCutcheon, Julia Grimm, Autumn Hansford, and Casse Jensen	4	0	False	False	True	False	False	True	52	0.5	7	6	0	5	0	<25																						False	False	True	False	False	False	False			True	False	False	False		5.2			0.16	0.37	0.67	0.94	0.47											0	16	22	24	18											0.1188573	0.522	0.0455392			48	41			1	11/4/2004 11:47:00 AM
Indian Creek	8832	958006	11/24/2004	1530	222225	Lindsey McCutcheon and Autumn Hansford	2	0	False	True	True	False	True	False	33	0	7	8	0	5	0	<25																						False	True	False	False	False	False	False			True	False	False	False		4.7			0.22	0.43	0.46	0.28												0	11	13	0												7.447553E-02	0.3475	5.357951E-02			38	42	Stream velocity was O on edges of Stream due to weed beds not allowing for movement of the tennis ball. There were snow flurries the day before testing but no accumualtion.		1	12/2/2004 1:54:00 AM
Indiangrass Hills - East	4529	948007	7/11/2000	1100	010110				True	False	False	False	False	False	90	0	9	5	0.15	1	0.3	<25																						False	True	False	False	False	False	False			True	False	False	False		1.3			0.3															0.1															3	0.3	10			68	22.5			2	3/1/2002 11:20:00 AM
Indiangrass Hills - East	4531	948007	7/11/2001	1100	010110	Barby Buss			True	False	False	False	False	False	90	0	9	5	0.3	5	0.3	<25	1	0	0	17	30	25	33	1467	1483	50	0	0	1500	1250	1650	1550	1250	1650	23	92	2	False	True	False	False	False	False	False			True	False	False	False		1.3			0.3															0.1															3	0.3	10			68	22.5			2	3/1/2002 11:33:00 AM
Indiangrass Hills - East	2635	948007	7/23/2002	1100	010110				False	True	False	False	False	False	83	0.41	7	3	0.15	1	0.6	<25	4	7	4	25	100	100	100	500	525	20	35	20	500	500	500	520	535	520	24.5	95	21	False	True	False	False	False	False	False			True	False	False	False		1.7			0.25															0															0	0.25	0			72	11.8	substrate is 25 cm deep black seidment		2	8/9/2002 11:09:00 AM
Indiangrass Hills - West Confluence	4532	948008	7/11/2001	1430	010110				True	False	False	False	False	False	85	0	9	5	0.15	1	0.4	<25	3	2	2	117	10	9	10	483	600	150	100	100	500	450	500	650	550	600	23	92	2	True	False	False	False	False	False	False			True	False	False	False		1.22			0.05															6.3															7.936508E-03	0.05	0.1587302			75	33			2	3/1/2002 11:41:00 AM
Iowa River Power Spillway	26274	952199	6/18/2009	800	100901		2	3	True	False	False	False	False	False	80		8	8	0	5	0.3	Not Sampled																						False	True	False	False	False	False	False	False	True	True	False	False	False	False			Not Sampled																															0	0		No	Yes		14			1	6/22/2009 11:07:00 AM
Iowa River Power Spillway	26282	952199	6/18/2009	800	100901	IOWAS FIRST NATIONS	2	5	False	True	False	False	False	False	73		8	3	0	2	0.8	Not Sampled																						False	True	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																															0	0		No	Yes		17			1	6/22/2009 11:21:00 AM
Iowa River Power Spillway	26281	952199	6/18/2009	1330	100901	Mary	3	4	True	False	False	False	False	False	73		9	10	0	5	0.4	27																						False	False	False	False	False	False	False	False	True	True	False	False	False	False			Not Sure																															0	0		No	Yes	80	14	THe river was very dirty but it didn`t smell at all. We saw a tree laying part way in the river. There was a rolling dam that caused the current to move faster on the other side. The water current was so strong that the bucket got stuck and it took five people to pull it back up.		1	6/22/2009 11:19:00 AM
Johnson/Iowa Snapshot (BC1 - Buck Creek at W66)	7847	952061	9/20/2003	1030	222210	Stephanie	Not Recorded	Not Recorded	True	False	False	False	False	True			8	8	0	1	Not Sampled	25																						True	False	False	False	False	False	False			True	False	False	False																																			0	0				58	60	One horse in water upstream. No visible tile lines or pipes upstream. Left bank is eroding, cut bank with rip rap. Right bank is eroding, vegetated, cut bank. Sample taken directly from stream.	Lab analyses as part of the snapshot: Fecal coliform bacteria - 1100; E. coli bacteria - 1100 CFU/100 ml; nitrate+nitrite-N – 0.4 mg/L; ammonia-N – <0.05 mg/L; total Kjeldahl nitrogen – 0.38 mg/L; total phosphate as P – 0.27 mg/L.	2	9/20/2004 10:04:00 AM
Johnson/Iowa Snapshot (BC1 - Buck Creek at W66)	328	952061	5/15/2004	930	222210	James Martin, Gary Arner	2	Not Recorded	True	False	False	False	False	True	60	0	8	8	0	2	0.4	<25																						True	False	False	False	False	False	False			True	False	False	False																																			0	0				58	60+			2	5/29/2004 3:46:00 PM
Johnson/Iowa Snapshot (BC1 - Buck Creek at W66)	7796	952061	5/31/2004	930	222210	James and Jennifer Martin	Not Recorded	Not Recorded	False	False	True	False	False	False			7	8	0	10	Not Sampled	29																						False	True	False	False	False	False	False			True	False	False	False																																			0	0				61	4	No animals in water upstream. No visible tile lines or pipes upstream. Left and right banks are sloping banks. Sample taken from a bridge.	Lab analyses as part of the snapshot: E. coli bacteria - 23000 CFU/100 ml; nitrate+nitrite-N – 9.9 mg/L; ammonia-N – 0.22 mg/L; total Kjeldahl nitrogen – 2.0 mg/L; total phosphate as P – 0.75 mg/L.	2	9/22/2004 9:00:00 AM
Johnson/Iowa Snapshot (BC1 - Buck Creek at W66)	8405	952061	9/18/2004	1030	222210	Liz Maas	Not Recorded	Not Recorded	False	True	False	False	True	False			8	8	0	1	Not Sampled	27																						True	False	False	False	False	False	False			True	False	False	False																																			0	0				62	60	No animals in water upstream, but horses adjacent to stream on right bank. No visible tile lines or pipes upstream. Left and right banks are vegetated and cut. Sample taken from the stream.	Lab analyses as part of the snapshot: E. coli bacteria - 900 CFU/100 ml; nitrate+nitrite-N – 0.51 mg/L; ammonia-N – <0.05 mg/L; total Kjeldahl nitrogen – 0.31 mg/L; total phosphate as P – 0.20 mg/L.	2	10/25/2004 9:12:00 AM
Johnson/Iowa Snapshot (BC1 - Buck Creek at W66)	11534	952061	5/14/2005	1100	222210	James Martin & Brad Freidhof	2	0	True	False	False	False	False	False			7	8	0.15	5	Not Sampled	28																						False	True	False	False	False	False	False			True	False	False	False																																			0	0				55	41	Samples taken from bridge. Horses present upstream. No tile lines visible upstream. Left and right banks are sloping and vegetated. The river is backed up into the creek.	Lab analyses as part of the snapshot: E. coli bacteria - 2100 CFU/100 ml; nitrate+nitrite-N – 9.5 mg/L; ammonia-N – 0.13 mg/L; total Kjeldahl nitrogen – 0.71 mg/L; total phosphate as P – 0.15 mg/L; total dissolved solids - 320 mg/L.	2	7/19/2005 2:47:00 PM
Johnson/Iowa Snapshot (BC1 - Buck Creek at W66)	13119	952061	7/16/2005	1130	222210	Lynette Seigley	1	0	True	False	False	False	False	True			9	6	0	1	0.8	<25																						True	False	False	False	False	False	False			True	False	False	False																																			0	0				80	48	Samples taken from bridge. No animals present upstream. No tile lines visible upstream. Left bank is cut and vegetated. Right bank is sloping. Aquatic plants and algae present on stream bottom. Red coloration in water along south bank.	Lab analyses as part of the snapshot: E. coli bacteria - 3900 CFU/100 ml; nitrate+nitrite-N – 0.5 mg/L; ammonia-N – <0.05 mg/L; total Kjeldahl nitrogen – 1 mg/L; total phosphate as P – 0.29 mg/L; total dissolved solids - 280 mg/L.	2	10/14/2005 10:25:00 AM
Johnson/Iowa Snapshot (BC1 - Buck Creek at W66)	13645	952061	10/15/2005	1000	222210	James Martin	1	0	True	False	False	False	False	False			7	8	0	0	0.2	<25																						True	False	False	False	False	False	False			True	False	False	False																																			0	0				55	60+	Samples taken from a bridge. No animals present upstream. No tile lines visible upstream. Left and right banks are sloping. Algae prevalent on mud where water has receded.	Lab analyses as part of the snapshot: E. coli bacteria - 2300 CFU/100 ml; nitrate+nitrite-N – 0.32 mg/L; ammonia-N – <0.05 mg/L; total Kjeldahl nitrogen – 0.4 mg/L; total phosphate as P – 0.17 mg/L; total dissolved solids - 260 mg/L.	2	1/6/2006 10:01:00 AM
Johnson/Iowa Snapshot (BC1 - Buck Creek at W66)	16120	952061	5/13/2006	1300	222210	James Martin	1	0	False	False	True	True	True	False			7	8	0	2	0	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																															0	0		No	Yes	48	60+	Samples taken from bridge. No animals present upstream. No tile lines visible upstream. Left and right banks are cut and eroding. Adjacent land is used for row crop, pasture, timber, and animal feeding operations/lots.	Lab analyses as part of the snapshot: E. coli bacteria - 330 CFU/100 ml; nitrate+nitrite-N – 5.3 mg/L; ammonia-N - <0.05 mg/L; total phosphate as P – 0.34 mg/L	2	8/31/2006 12:58:00 PM
Johnson/Iowa Snapshot (BC1 - Buck Creek at W66)	18197	952061	10/14/2006	1030	222210	James Martin and Mike Mittelstadt	2	Not Recorded	True	False	False	False	True	False			7	12	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	41	60+	There were no animals in the water upstream. There were no tile lines or pipes visible along the river upstream. There were deer tracks upstream. The left and right banks are both cut banks that are vegetated. Adjacent land uses are row crop and rural residential areas. No human use activities were observed. There was no evidence of human use activities. The sample was collected from a bridge. There is 60 mph traffic at this site.	Lab analyses as part of the snapshot: E. coli bacteria – 520 CFU/100 ml; nitrate+nitrite-N - 0.24 mg/L; ammonia-N -<0.05 mg/L; total phosphate as P - 0.16 mg/L	2	5/4/2007 10:14:00 AM
Johnson/Iowa Snapshot (BC1 - Buck Creek at W66)	19388	952061	5/12/2007	1200	222210	Jason McCurdy and Ruth Izer	2	0	True	False	False	False	False	False			8	8	0	5	0.2	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																															0	0		No	Yes	64	60+	Samples taken from bridge. No animals present upstream. No tile lines visible upstream. Left and right banks are cut and vegetated. Iowa River is partially backed up into the creek but still flowing out. Adjacent land use is row crop, pasture, and rural residential areas. No human use activities or evidence of human use noted.	Lab analyses as part of the snapshot: E. coli bacteria - 480 CFU/100 ml; nitrate+nitrite-N - 10 mg/L; total phosphate as P – 0.1 mg/L	2	7/25/2007 10:42:00 AM
Johnson/Iowa Snapshot (BC1 - Buck Creek at W66)	21348	952061	10/13/2007	1030	222210	Katie Eckrich, Kari Shaffer, Nick Wade	Not Recorded	Not Recorded	False	False	True	False	True	False			8	6	0	2	0.4	<25																						False	False	True	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																															0	0		No	Yes	54	60	There were three cows in the water upstream. There were no tile lines or pipes visible along the river upstream. The left stream bank is vegetated. The right stream bank includes a sand/gravel bar. Adjacent land use includes row crops. No human use activities were observed. No evidence of human use was observed. The water sample was taken from a bridge. The site is unsafe: the bridge is narrow and there is high-speed traffic.	Lab analyses as part of the snapshot: E. coli bacteria – 460 MPN/100 ml; nitrate+nitrite-N – 2.8 mg/L.	2	1/15/2008 2:14:00 PM
Johnson/Iowa Snapshot (CC00 - Headwaters Clear Ck Hwy 149)	321	948049	1/25/2004	1700	222210	Dave Ratliff	1	Not Recorded	False	False	False	False	True	False	18		Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled	<25																						False	False	False	False	False	False	False			False	False	False	False																																			0	0					60+	This is the first site where Clear Creek can be tested. It a tile coming from the west. Very little water, took about 10 seconds to fill 250 ms beaker.		2	5/30/2004 9:39:00 AM
Johnson/Iowa Snapshot (CC00 - Headwaters Clear Ck Hwy 149)	7657	948049	3/27/2004	1600	222210	Don Lund, Dave Ratliff, Lynette Seigley	3	Not Recorded	False	False	False	False	False	False			Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled	<25																						False	False	False	False	False	False	False			False	False	False	False																																			0	0					Not Sampled	Hwy 149 Clear Creek site- sampled west side of road where tile discharges		2	9/13/2004 4:06:00 PM	9/13/2004 4:20:00 PM
Johnson/Iowa Snapshot (CC00 - Headwaters Clear Ck Hwy 149)	388	948049	5/15/2004	1200	222210	Mary Skopec and Lynette Seigley	2	Not Recorded	True	False	False	False	False	True		0	7	8	0	10	0.3	25																						True	False	False	False	False	False	False			True	False	False	False																																			0	0				50	60+	Sampled tile line on west side of road. On east side, water was stagnant. Couple stopped and asked us what we were doing. They own property on west side of road at this site.		2	5/28/2004 2:54:00 PM
Johnson/Iowa Snapshot (CC00 - Headwaters Clear Ck Hwy 149)	7938	948049	5/31/2004	1430	222210		Not Recorded	Not Recorded	True	False	False	False	True	False			7	8	0	10	Not Sampled	29																						True	False	False	False	False	False	False			True	False	False	False																																			0	0				58	60+	No animals in water upstream. No visible tile lines or pipes upstream. Sample taken directly from stream.	Lab analyses as part of the snapshot: E. coli bacteria - 10 CFU/100 ml; nitrate+nitrite-N – 23 mg/L; ammonia-N – <0.05 mg/L; total Kjeldahl nitrogen – 0.12 mg/L; total phosphate as P – 0.07 mg/L.	2	9/22/2004 9:53:00 AM
Johnson/Iowa Snapshot (CC00 - Headwaters Clear Ck Hwy 149)	7117	948049	7/18/2004	1700	222210		Not Recorded	Not Recorded	False	True	False	False	False	False	82	0	7	6	0	20	0.1	<25																						True	False	False	False	False	False	False			True	False	False	False																																			0	0				61	60+			2	7/24/2004 9:53:00 AM
Johnson/Iowa Snapshot (CC00 - Headwaters Clear Ck Hwy 149)	8239	948049	9/18/2004	1130	222210	Bryce Jackman	Not Recorded	Not Recorded	False	False	False	False	False	False			Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled																						False	False	False	False	False	False	False			False	False	False	False																																			0	0					Not Sampled	Site was dry		2	10/18/2004 4:11:00 PM
Johnson/Iowa Snapshot (CC00 - Headwaters Clear Ck Hwy 149)	8579	948049	10/16/2004	1330	222210	Larry Wilson; Dave Ratliff	Not Recorded	Not Recorded	False	False	False	False	False	False			Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled																						False	False	False	False	False	False	False			False	False	False	False																																			0	0					Not Sampled	Site was dry		2	11/3/2004 8:41:00 AM
Johnson/Iowa Snapshot (CC00 - Headwaters Clear Ck Hwy 149)	9139	948049	12/25/2004	1130	222210	Dave Ratliff	1	Not Recorded	False	False	False	False	False	False			Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled																						False	False	False	False	False	False	False			False	False	False	False																																			0	0					Not Sampled	Site sampled as part of a snapshot sampling of the upper end of Clear Creek. Site was dry, so no samples collected.		2	2/7/2005 10:38:00 AM	2/7/2005 10:42:00 AM
Johnson/Iowa Snapshot (CC00 - Headwaters Clear Ck Hwy 149)	9140	948049	1/2/2005	1130	222210	Dave Ratliff and Don Lund	2	Not Recorded	False	False	False	False	False	False			Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled																						False	False	False	False	False	False	False			False	False	False	False																																			0	0					Not Sampled	Site sampled as part of a snapshot sampling of the upper end of Clear Creek. Site was dry, so no samples collected.		2	2/7/2005 10:41:00 AM
Johnson/Iowa Snapshot (CC00 - Headwaters Clear Ck Hwy 149)	11547	948049	5/14/2005	800	222210	Dave Ratliff & Bryce Jackman	2	0	False	False	True	False	True	False			7	6	0	5	0.1	<25																						False	False	False	False	False	False	False			False	False	False	False																																			0	0				53	60+		Lab analyses as part of the snapshot: E. coli bacteria - 50 CFU/100 ml; nitrate+nitrite-N – 19 mg/L; ammonia-N – <0.05 mg/L; total Kjeldahl nitrogen – 0.24 mg/L; total phosphate as P – 0.05 mg/L; total dissolved solids - 380 mg/L.	2	7/19/2005 3:59:00 PM
Johnson/Iowa Snapshot (CC00 - Headwaters Clear Ck Hwy 149)	13126	948049	7/16/2005	1230	222210	Dave Ratliff & Steve Veysey	2	0	False	False	False	False	False	False			Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled																						False	False	False	False	False	False	False			False	False	False	False																																			0	0					Not Sampled	Stream is dry.		2	10/14/2005 10:49:00 AM
Johnson/Iowa Snapshot (CC00 - Headwaters Clear Ck Hwy 149)	12741	948049	8/10/2005	1330	222210		1	0	False	False	False	False	False	False	82	0	Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled																						False	False	False	False	False	False	False			False	False	False	False																																			0	0					Not Sampled	DRY! No rain for weeks and everything is slowly drying up		2	9/7/2005 7:07:00 AM
Johnson/Iowa Snapshot (CC00 - Headwaters Clear Ck Hwy 149)	12749	948049	9/5/2005	1000	222210		1	0	True	False	False	False	True	False	81	1.3	Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled																						False	False	False	False	False	False	False			False	False	False	False																																			0	0					Not Sampled	Dry - not even any standing water after the rain.		2	9/7/2005 7:50:00 AM
Johnson/Iowa Snapshot (CC00 - Headwaters Clear Ck Hwy 149)	12854	948049	9/11/2005	1400	222210		1	0	True	False	False	False	True	False	90	0	Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled																						False	False	False	False	False	False	False			False	False	False	False																																			0	0					Not Sampled	DRY!		2	9/21/2005 7:35:00 AM
Johnson/Iowa Snapshot (CC00 - Headwaters Clear Ck Hwy 149)	13651	948049	10/15/2005	800	222210	Gary Arner & Lynette Seigley	2	0	False	False	False	False	False	False			Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled																						False	False	False	False	False	False	False			False	False	False	False																																			0	0					Not Sampled	Stream is dry.		2	1/6/2006 10:34:00 AM
Johnson/Iowa Snapshot (CC00 - Headwaters Clear Ck Hwy 149)	16121	948049	5/13/2006	1430	222210	Dave Ratliff & Gary Arner	2	0	False	False	True	False	True	False			6	8	0	5	0	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																															0	0		No	Yes	50	60+	Samples taken directly from stream. Adjacent land is used for row crop. Broken tiles present.	Lab analyses as part of the snapshot: E. coli bacteria - <10 CFU/100 ml; nitrate+nitrite-N - 19 mg/L; ammonia-N - <0.05 mg/L; total phosphate as P – 0.03 mg/L	2	8/31/2006 1:01:00 PM
Johnson/Iowa Snapshot (CC00 - Headwaters Clear Ck Hwy 149)	19389	948049	5/12/2007	1330	222210	Dave Ratliff & Lynette Seigley	2	0	True	False	False	False	True	False			7	6	0	20	0.1	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																															0	0		No	Yes	50	60+	Samples taken directly from stream. One tile line visible upstream. It is flowing and is the beginning flow of the stream. Left and right banks are sloping. Adjacent land use is row crop and conservation lands. Stream is a grassed waterway. No human use activities or evidence of human use noted.	Lab analyses as part of the snapshot: E. coli bacteria - <10 CFU/100 ml; nitrate+nitrite-N - 21 mg/L; total phosphate as P – 0.04 mg/L	2	7/25/2007 10:46:00 AM
Johnson/Iowa Snapshot (CC00A - S Trib Clear Ck on Q Ave)	304	948050	1/25/2004	1200	222210	Dave Ratliff	1	Not Recorded	True	False	False	False	True	False	18		Not Sampled	Not Sampled	Not Sampled	Not Sampled	Not Sampled	327																						False	False	False	False	False	False	False			False	False	False	False																																			0	0					60+	Clear Creek seams to flow underground for one mile where it comes out on the West side of `Q` just North of 210th with a Chloride level of 327 mg/L.		2	5/30/2004 9:42:00 AM
Johnson/Iowa Snapshot (CC00A - S Trib Clear Ck on Q Ave)	7658	948050	3/27/2004	1630	222210	Don Lund, Dave Ratliff, Lynette Seigley	3	Not Recorded	False	False	False	False	False	False			8	Not Sampled	0	10	0.2	161																						False	False	False	False	False	False	False			False	False	False	False																																			0	0					60	Lab analyses as part of the snapshot: E. coli bacteria – 30 CFU/100 ml.		2	9/13/2004 4:07:00 PM
Johnson/Iowa Snapshot (CC00A - S Trib Clear Ck on Q Ave)	21774	948050	5/15/2004	1130	222210	Mary Skopec, Lynette Seigley	2	Not Recorded	True	False	False	False	True	False	60		7	10	0	50	0.3	206																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	1.8		Not Sampled	0.04															8															0.005	0.04	0.125	No	Yes	56	60+			2	4/2/2008 8:00:00 AM
Johnson/Iowa Snapshot (CC00A - S Trib Clear Ck on Q Ave)	7939	948050	5/31/2004	1330	222210		Not Recorded	Not Recorded	True	False	False	False	True	False			7	6	0	20	Not Sampled	72																						False	False	False	False	False	False	False			False	False	False	False																																			0	0				58	60+		Lab analyses as part of the snapshot: E. coli bacteria - 64 CFU/100 ml; nitrate+nitrite-N – 30 mg/L; ammonia-N – <0.05 mg/L; total Kjeldahl nitrogen – 0.17 mg/L; total phosphate as P – 0.14 mg/L.	2	9/22/2004 9:56:00 AM
Johnson/Iowa Snapshot (CC00A - S Trib Clear Ck on Q Ave)	7118	948050	7/18/2004	1530	222210		Not Recorded	Not Recorded	False	True	False	False	False	False	78	0	6	6	0	20	0.1	225																						True	False	False	False	False	False	False			True	False	False	False																																			0	0				60	60+			2	7/24/2004 9:57:00 AM
Johnson/Iowa Snapshot (CC00A - S Trib Clear Ck on Q Ave)	8240	948050	9/18/2004	1030	222210	Bryce Jackman, Dave Ratliff	Not Recorded	Not Recorded	False	True	False	False	False	False			7	5	0	10	Not Sampled	209																						True	False	False	False	False	False	False			True	False	False	False																																			0	0				62	60+	Site is a culvert.	Lab analyses as part of the snapshot: E. coli bacteria - 64 CFU/100 ml; nitrate+nitrite-N - 24 mg/L; ammonia-N - <0.05 mg/L; total Kjeldahl nitrogen – 0.22 mg/L; total phosphate as P – 0.09 mg/L.	2	10/18/2004 4:13:00 PM
Johnson/Iowa Snapshot (CC00A - S Trib Clear Ck on Q Ave)	8562	948050	10/16/2004	1300	222210	Larry Wilson; Dave Ratliff	Not Recorded	Not Recorded	False	False	True	False	True	False			7	6	0	10	0.1	89																						True	False	False	False	False	False	False			True	False	False	False																																			0	0				55	60+	No animals in water upstream. Two pipes in junction box. Left and right banks are junction box. Sample taken di