IOwater Chemical/Physical Assessment Summation Table for HUC 8 Watershed: Thompson River (10280102)

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
4 Mile Creek @ 210th St.	18040	988013	12/6/2006	1400	020605		1	Not Recorded	False	True	False	False	False	False	44	0	6	8	0.15	2	0.2	25																						False	False	False	False	False	False	False	False	True	True	False	False	False	False		0.19	Normal																																																																																																																									0	0		No	Yes	35	10			1	4/28/2007 8:53:00 AM
4 Mile Creek @ 210th St.	18041	988013	1/7/2007	1430	020605		1	Not Recorded	False	False	True	False	True	False	38	0	6	8	0	2	0	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False			High																																																																																																																									0	0		No	Yes	35	35			1	4/28/2007 8:56:00 AM
4 Mile Creek @ 210th St.	18042	988013	3/12/2007	1430	020605		1	0	True	False	False	False	False	False	72	0	8	8	0	2	0.2	<25																						False	True	False	False	False	False	False	False	False	False	False	False	False	True			Normal																																																																																																																									0	0		No	Yes	54	13	No testing in Feb due to frozen conditions		1	4/28/2007 8:59:00 AM
4 Mile Creek @ 210th St.	18043	988013	4/18/2007	1330	020605		1	0	True	False	False	False	True	False	61	0	9	10	0	2	0	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False			Normal																																																																																																																									0	0		No	Yes	62	49	Samples taken form a collection vessel from bridge. Note: this stream seems to have consistenly high nitrate readings compared with samples taken from other area streams.		1	4/28/2007 9:03:00 AM
4 Mile Creek @ 210th St.	18468	988013	5/25/2007	1200	020605		1	0	True	False	False	False	False	False	68	1	7	8	0.15	1	0.2	33																						False	True	False	False	False	False	False	False	False	False	False	False	False	True			High																																																																																																																									0	0		No	Yes	64	21			1	5/27/2007 1:15:00 PM
4 Mile Creek @ 210th St.	18469	988013	5/25/2007	1200	020605		1	0	True	False	False	False	False	False	68	1	7	8	0.15	1	0.2	33																						False	True	False	False	False	False	False	False	False	False	False	False	False	True			High																																																																																																																									0	0		No	Yes	64	21			1	5/27/2007 1:15:00 PM
4 Mile Creek @ 210th St.	22926	988013	7/12/2008	1530	020605		1	0	False	True	False	False	False	False	72	0.1	8	6	0	2	0.2	<25																						False	True	False	False	False	False	False	False	False	False	False	False	False	True			High																																																																																																																									0	0		No	Yes	75	Not Sampled	This stream too high to safely cross to do width, depth, and velocity.		1	7/14/2008 8:11:00 AM
Bridge over 130th St. Site #2	7157	927002	6/2/2004	1130	030415	Michael Mains	2	Not Recorded	False	True	False	False	False	False	60	0	7	8	0.3	2	0.2	28																						True	False	False	False	False	False	False			True	False	False	False					0.8	0.14	0.12	0.35																																																																																																																					0	0.3525					60	Stream banks about 15 feet to water. Stream sandy with some gravel. Trees on one bank and row crops on opposite bank.		1	7/22/2004 2:51:00 PM
Sevenmile Creek	5982	920001	5/5/2001	1630	120008	Linda Appelgate, Mimi Wagner, Alex Ashew, Penny Thomsen, Craig Cox			False	False	True	True	False	True	65	0.17	7	10	0	1	Not Sampled	Not Sampled																						False	True	False	False	False	False	False			True	False	False	False		6.6			0.06	0.16	0.24	0.2	0.16	0.21																																																							4.5	2.5	3	1.5	3	2																																																							0.449	0.1716667	0.4359223			60.5	6	This data represents a runoff event. Intermittent rainfall all day prior to sampling. Water level came up 4 cm during sampling.		1	5/16/2001 5:11:00 PM
Sevenmile Creek	1424	920001	10/17/2003	1230	120008	Linda Appelgate			True	False	False	False	False	True	70		7	6	0	0	2	<25																						False	True	False	False	False	False	False			True	False	False	False		1.1			0.11																																																												0																																																												0	0.11	0			45	16			2	10/24/2003 2:13:00 PM
Sevenmile Creek	120	920001	6/13/2004	1600	120008	Linda Appelgate	2	Not Recorded	True	False	False	False	False	False	76	1.9	7	8	0	2	0.8	<25																						False	True	False	False	False	False	False			True	False	False	False		4.6			0.11	0.08	0.05	0.04																																																									2.3	4.1	3.2	2.1																																																									0.1020109	0.07	0.3643247			70	7	Very shaded area of stream. Heavy rainfall the night before.		2	6/14/2004 2:50:00 PM
Sevenmile Creek	8704	920001	10/16/2004	1300	120008	Linda Appelgate	2	0	True	False	False	False	True	False	49	0	6	8	0	0	0.2	<25																						True	False	False	False	False	False	False			True	False	False	False		3.7			0.4	0.1	0.13																																																										15	40	0																																																										2.916667E-02	0.21	4.629629E-02			42	60+			2	11/17/2004 3:18:00 PM
Sevenmile Creek	10459	920001	5/22/2005	1730	110001	Mollie Appelgate, Sydney Dengle	3	0	True	False	False	False	True	False	76	0	8	8	0	2	0.3	<25																						True	True	False	False	False	False	False			True	False	False	False		3.4			0.06	0.12	0.05																																																										3.4	4.1	3.85																																																										5.990237E-02	7.666667E-02	0.2604451			72	39			2	5/24/2005 9:01:00 AM
Sevenmile Creek (downstream)	3141	920002	6/11/2001	1830	120008	Linda Appelgate			True	False	False	False	False	True	85	0	8	6	0	1	0.2	<25																						True	False	False	False	False	False	False			True	False	False	False		5.96			0.065	0.08	0.075	0.065	0.06																																																								4.87	6.46	4.3	8.37	8.55																																																								5.795616E-02	0.069	0.1679889			81	60			2	6/26/2001 1:55:00 PM
Sevenmile Creek (downstream)	1427	920002	10/17/2003	1400	120008	Linda Appelgate			True	False	False	False	False	True	72	0	7	3	0	0	2	<25	88	80	68	7867	216	268	192	22533	30400	8800	8000	6800	21600	26800	19200	30400	34800	26000	48	90	1	False	True	False	False	False	False	False			True	False	False	False		3.4			0.14	0.09	0.03																																																										0	0	0																																																										0	8.666667E-02	0			51	29	Water was not flowing at time of sampling, pooled conditions. Bottom was very silty and mucky and after walking around you start to sink down into the muck.		2	10/23/2003 12:45:00 PM
Sevenmile Creek (downstream)	121	920002	6/13/2004	1100	120008	Ann Robinson, Charlie Ducharme, and Mark Leoschke	4	Not Recorded	False	True	False	False	False	False	68	1.9	7	8	0	2	1	<25																						False	True	False	False	False	False	False			True	False	False	False		2.55			0.28	0.25																																																											1	1.1																																																											0.5072727	0.265	0.9571183			62	5	heavy rainfall the night before sampling		2	6/14/2004 3:03:00 PM
Sevenmile Creek (downstream)	8699	920002	10/16/2004	1130	120008	Linda Appelgate	2	0	True	False	False	False	True	False	41	0	6	Not Sampled	0	0	0.1	<25																						True	False	False	False	False	False	False			True	False	False	False		1.4			0.06																																																												3																																																												0.02	0.06	0.3333333			42	60+			2	11/17/2004 3:01:00 PM
Sevenmile Creek (downstream)	10460	920002	5/22/2005	1800	110001	Mollie Appelgate, Sydney Dengle	3	0	True	False	False	False	True	False	76	0	8	8	0	2	0.3	<25																						True	True	False	False	False	False	False			True	False	False	False		2.4			0.13	0.17																																																											4.5	3.8																																																											7.362573E-02	0.15	0.2454191			72	34		no	2	5/24/2005 9:15:00 AM	5/24/2005	Changed time from 8am to 6 pm.
Sevenmile Creek (downstream)	13172	920002	10/15/2005	1230	120008	Linda Appelgate	2	0	True	False	False	False	False	True	68	0	8	4	0	0	2	<25																						True	False	False	False	False	False	False			True	False	False	False																																																																																																																													0	0				56	45	The stream was the lowest observed in 20 years based on observations from the owners of the property. The water was pooled and not flowing. Over 268 feet of stream, there were 5 pools with a total stream length of 191 feet so 70% of the reach was pooled water. Pools had abundant minnows and small frogs and aquatic insects.		2	10/17/2005 5:37:00 PM
Three Mile Creek/Kingfisher Rd	7781	988001	8/7/2004	1300	100406		1	0	True	False	False	False	False	False	78		9	6	0	5	0.4	<25																						False	True	False	False	False	False	False			True	False	False	False		4.6			0.3	0.7	0.7	0.2																																																									30	20	25	35																																																									7.871429E-02	0.475	4.142857E-02			71	10			1	9/14/2004 6:22:00 PM
Three Mile Creek/Kingfisher Rd	8434	988001	10/16/2004	1330	100406	Don Mosman, Helen Mosman	2	0	True	False	False	False	True	False	52	0	6	10	0	0	0.1	<25																						True	False	False	False	False	False	False			True	False	False	False		5.2			0.27	0.34	0.4	0.3	0.14																																																								30.19	20.1	20.1	45	60																																																								5.475928E-02	0.29	3.776502E-02			46	31	Set aside acres 200 yds each side of creek and half mile upstream		1	10/23/2004 11:22:00 AM
Three Mile Creek/Kingfisher Rd	10796	988001	6/9/2005	1300	100406		1	0	False	False	True	False	False	True	82	2	8	8	0.15	5	0.1	<25																						False	True	False	False	False	False	True			True	False	False	False		10.2			0.08	0.15	0.17	0.2	0.25	0.23	0.23	0.18	0.13	0.09																																																			0.01	0.01	0.01	0.01	0.01	0.01	0.01	0.02	0.03	0.03																																																			147.3333	0.171	86.15984			70	5	Ditch feeding into stream has eroded, breaking at the road bed straight down 6 feet. Actually has a waterfall and `rapids` and 2 24``+ carp in the road ditch.		2	6/9/2005 7:05:00 PM
Willow Ave crossing of Thompson River	14951	988011	5/18/2006	1400	020605		2	3	True	False	False	False	False	False	71	0	9	8	0	2	0.2	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	16.5	0.4	Normal	0.11	0.13	0.14	0.13	0.1	0.12	0.12	0.17	0.31	0.4	0.31	0.23	0.18	0.06	0.03																																														5	5	3	9	8	3	3	3	2	2	3	4	5	6	6																																														0.8251111	0.1693333	0.3248469	No	Yes	61	39			1	5/25/2006 9:26:00 AM
Willow Ave crossing of Thompson River	15173	988011	6/15/2006	1400	020605		1	3	False	False	True	False	False	False	80	0	9	6	0	5	0.2	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	12	0.25	Normal	0.1	0.05	0.075	0.1	0.08	0.25	0.255	0.28	0.25	0.23	0.15																																																		5	25	25	31	11	4	4	3	2	3	11																																																		0.4703849	0.1654546	0.2584532	No	Yes	75	40	There were lots of fresh ATV tracks along the banks		1	6/15/2006 4:17:00 PM
Willow Ave crossing of Thompson River	15515	988011	7/18/2006	1400	020605		1	2	True	False	False	False	False	False	84	0	9	6	0	1	0.2	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	10.1	0.16	Low	0.02	0.06	0.14	0.12	0.14	0.15	0.16	0.14	0.09																																																				0	0	9	4	5	6	7	7	21																																																				0.1456984	0.1133333	0.1428416	No	Yes	87	41	Large rain event 5 days ago with over an inch of rain in an hour. Temps the past two days have been near 100.		1	7/18/2006 6:09:00 PM
Willow Ave crossing of Thompson River	15964	988011	8/19/2006	930	020605		1	2	False	False	True	True	False	True	74	1.5	7	6	0	0	0.2	<25																						False	True	False	False	False	False	False	False	False	True	False	False	False	False	12.4		Not Sampled																																																																																																																									0	0		No	Yes	73	10	We have had 2 rain events in the past week that had 1.5in. plus. Due to time constraints I was unable to do stream depth and flow. (all that rain REALLY messed up my schedual!)		1	8/21/2006 8:17:00 AM
Willow Ave crossing of Thompson River	16368	988011	9/24/2006	1400	020605	Pleasant Valley River Rafters 4-H	3	3	True	False	False	False	False	False	69	0	9	8	0	0	0.2	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	9	0.24	Low	0.12	0.24	0.1	0.15	0.17	0.19	0.18	0.19																																																					0	7	5	6	6	6	10	17																																																					0.1684622	0.1675	0.125718	No	Yes	65	60+			1	9/28/2006 3:50:00 PM
Willow Ave crossing of Thompson River	16474	988011	10/22/2006	1500	020605		2	1	False	False	True	False	True	False	42	0.05	7	8	0	0	0.2	61																						True	False	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																																																																																																																									0	0		No	Yes	44	40	This is the first time that I have had any variation of Chloride.		1	10/22/2006 8:26:00 PM
Willow Ave crossing of Thompson River	16931	988011	12/6/2006	1500	020605		1	Not Recorded	False	False	True	False	False	False	40	0	6	8	0	2	0.1	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																																																																																																																									0	0		No	Yes	34	Not Sampled	The river was mainly frozen over this month. I tested in a small hole in the ice not far from my usual transect.		1	12/7/2006 7:51:00 AM
Willow Ave crossing of Thompson River	17091	988011	1/7/2007	1500	020605		1	Not Recorded	False	False	True	False	True	False	36	0	6	8	0	2	0.1	<25																						False	True	False	False	False	False	False	False	False	True	False	False	False	False			High																																																																																																																									0	0		No	Yes	36	15	Had to test under the bridge due to high water from large rain events in the last week. Testing done from collection tube except dissolved oxygen.		1	1/8/2007 9:14:00 AM
Willow Ave crossing of Thompson River	17297	988011	3/13/2007	1400	020605		1	0	True	False	False	False	True	False	74	0	7	8	0	2	0.2	<25																						False	True	False	False	False	False	False	False	False	False	False	False	False	True			High																																																																																																																									0	0		No	Yes	45	2	Water too high to do depth or velocity. Water was tested at bridge instead of usual site upstream. Water was VERY muddy!		1	3/14/2007 7:31:00 AM
Willow Ave crossing of Thompson River	17911	988011	4/18/2007	1400	020605		1	0	True	False	False	False	True	False	61	0	8	6	0	2	0.2	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False			High																																																																																																																									0	0		No	Yes	61	22	River level was still somewhat above normal. Still a little too high for me to do width, depth, and velocity. I am short! Large rain event a week ago but mild temps since then. Was able to get back to my original transect today. The first time since last fall.		1	4/24/2007 7:57:00 AM
Willow Ave crossing of Thompson River	18605	988011	6/11/2007	1500	020605		1	Not Recorded	False	True	False	False	False	False	84	0	9	8	0	5	0.6	25																						False	True	False	False	False	False	False	False	False	False	False	False	False	True			High																																																																																																																									0	0		No	Yes	75	28	Water still too high to safely cross. Still not able to do depth, width, and velocity. My original transect still inaccessilbe due to the water level higher than normal.		1	6/12/2007 8:18:00 AM
Willow Ave crossing of Thompson River	19997	988011	9/21/2007	1500	020605		1	Not Recorded	True	False	False	False	True	False	86	0	8	8	0	2	0.6	<25																						False	True	False	False	False	False	False	False	False	False	False	False	False	True			High																																																																																																																									0	0		No	Yes	75	9	Recent flooding in August has left my original site unassessable. I have permanently moved it downstream of the bridge. Water still too high to cross safely to do depth and velocity.		1	9/26/2007 8:39:00 AM
Willow Ave crossing of Thompson River	20517	988011	10/30/2007	1500	020605		1	0	False	True	False	False	True	False	70	0	8	8	0	2	0.2	<25																						False	True	False	False	False	False	False	False	False	True	False	False	False	False			High																																																																																																																									0	0		No	Yes	54	22	Another month of above average rainfall. Water was higher even than last month and I was forced to test closer to the bridge.		1	10/30/2007 3:48:00 PM
Willow Ave crossing of Thompson River	20681	988011	11/19/2007	1500	020605		1	0	True	False	False	False	True	False	68	0	7	5	0	2	0.1	<25																						True	False	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																																																																																																																									0	0		No	Yes	49	52	Finally at original transect. First time since Oct 06. Lots of ATV tracks today.		1	11/23/2007 2:27:00 PM
Willow Ave crossing of Thompson River	22229	988011	5/10/2008	1500	020605		1	Not Recorded	False	False	True	False	True	False	64		7	8	0	0	0.2	<25																						False	True	False	False	False	False	False	False	False	True	False	False	False	False			Not Sampled																																																																																																																									0	0		No	Yes	62	24	River too high to cross. Couldn`t do width, depth, or velocity.		1	5/10/2008 3:50:00 PM
Willow Ave crossing of Thompson River	22925	988011	7/12/2008	1430	020605		1	0	False	True	False	False	False	False	83	0.1	8	6	0	2	0.2	<25																						False	True	False	False	False	False	False	False	False	False	False	False	False	True			High																																																																																																																									0	0		No	Yes	75	8	River too high to safely cross to do width, depth, or velocity.		1	7/14/2008 8:02:00 AM
Willow Ave crossing of Thompson River	23109	988011	9/17/2008	1600	020605		1	Not Recorded	True	False	False	False	False	True	77	0	8	6	0	0	0.3	<25																						False	False	False	False	False	False	False	True	True	False	False	False	False	True			Normal																																																																																																																									0	0		No	Yes	68	9	Could be back at original trasect. We received 5in of rain 5 days ago so flow was normal but water was too high to cross. Never in all the years I have lived along this river (15) have I seen it to where you could not cross it at some point in the year. Water very gray, milky looking. Drove around upstream and discovered that the rock quarry pumped out the quarry and sent it down stream. Water clear upstream of quarry and milky downstream. Didn`t seem to affect my reading which surprised me.		1	9/18/2008 7:34:00 AM
Willow Ave crossing of Thompson River	25458	988011	3/16/2009	1500	020605		1	0	True	False	False	False	True	False	72	0	7	10	0	0	0.2	<25																						False	True	False	False	False	False	False	False	False	False	False	False	False	True			Normal																																																																																																																									0	0		No	Yes	46	5	I had to run the water through the filter so the oxygen reading may be a little higher than it actually is.		1	3/17/2009 3:51:00 PM