IOwater Chemical/Physical Assessment Summation Table for HUC 8 Watershed: One Hundred and Two River (10240013)

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
Cemetery Site	19551	987010	5/19/2006	800	110607		1	0	False	True	False	False	False	False	71	0	8	10	0	2	2	42																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	3.5	0.18	High	0.475	0.65	0.115																																																										10	5	4																																																										0.20625	0.4133333	0.1663307	No	Yes	68	24			1	7/31/2007 6:16:00 PM
Cemetery Site	19552	987010	6/26/2006	1830	110607		1	0	False	True	False	False	False	False	84	1	9	6	0.15	2	8	69																						False	False	True	False	False	False	False	False	False	True	False	False	False	False	4.6	1.6	High	0.9	0.5	1.2	1.6																																																									14	14	12	5																																																									0.52	1.05	0.1238095	No	Yes	86	5			1	7/31/2007 6:22:00 PM
Cemetery Site	19546	987010	8/29/2006	800	110607		0	0	False	True	False	False	False	False	76	0	9	8	0.15	1	5	46																						False	False	False	False	False	False	False	False	True	False	False	False	False	False	2.4	0.2	Low	0.2																																																												2																																																												0.1	0.2	0.5	No	Yes	74	7			1	7/31/2007 6:03:00 PM
Cemetery Site	19547	987010	9/30/2006	800	110607		1	0	False	True	False	False	False	False	77	0	9	10	0	2	10	166																						False	False	False	False	False	False	False	False	True	False	False	False	False	True	1	0.085	Low	0.85																																																												4																																																												0.2125	0.85	0.25	No	Yes	65	20			1	7/31/2007 6:07:00 PM
Cemetery Site	19548	987010	10/8/2006	930	110607		1	0	False	True	False	False	False	False	70	0	9	8	0.15	1	10	194																						False	False	True	False	False	False	False	False	False	False	True	False	False	False			Not Sampled																																																																																																																									0	0		No	Yes		Not Sampled			1	7/31/2007 6:09:00 PM
Cemetery Site	19549	987010	11/11/2006	1400	110607		1	0	True	False	False	False	False	False	52	1	8	6	0	2	3	97																						False	False	False	False	False	False	False	False	True	True	False	False	False	False	1.5	0.13	High	0.13																																																												3																																																												4.333333E-02	0.13	0.3333333	No	Yes	40	5			1	7/31/2007 6:12:00 PM
Cemetery Site	19550	987010	4/21/2007	800	110607		2	0	True	False	False	False	False	False	72	0	9	12	0	2	2	39																						True	False	False	False	False	False	False	False	False	True	False	False	False	False	5.5	0.25	High	0.1	0.11	0.25	0.21	0.11																																																								4	7	4	3	5																																																								0.1952143	0.156	0.2502747	No	Yes	70	35			1	7/31/2007 6:14:00 PM
East River	3914	987001	7/25/2000	1330	150030	Kent Parkhurst			True	False	False	False	False	False	80	0.12	7	10	0	5	Not Sampled	Not Sampled																						False	True	False	False	False	False	False			True	False	False	False		1.7			0.03																																																												3																																																												0.01	0.03	0.3333333			84	8	picked up car battery out of stream someone had disposed of		1	8/23/2000 8:27:00 PM
East River	3241	987001	6/9/2001	1100	150030	Kent Parkhurst			True	False	False	False	False	False	71	0	7	12	1.5	0	0.2	<25	1	2	0	200	52	88	36	11733	11933	200	400	0	10400	17600	7200	10600	18000	7200	24	95	0.5	False	True	False	False	False	False	False			True	False	False	False		5			0.3	0.4	0.4	0.3																																																									0	5	4	4																																																									0.255	0.35	0.1821429			62	17			2	6/13/2001 2:10:00 PM
East River	1878	987001	8/7/2003	900	120317	Casey Barber			True	False	False	False	False	False	70	0	9	10	0	0	0	Not Sampled																						False	True	False	False	False	False	False			True	False	False	False		0.5			0.1																																																												0																																																												0	0.1	0			72	3	The stream was about dried up because of no rain		1	8/20/2003 12:24:00 PM
East River bridge on Hwy 49	2857	987003	6/9/2001	1400	150030	Kent Parkhurst			True	False	False	False	False	False	76	0	7	8	1.0	0	0.2	<25	2	2	2	400	37	55	41	8867	9267	400	400	400	7400	11000	8200	7800	11400	8600	24	91	0.5	False	True	False	False	False	False	False			True	False	False	False		6			0.05	0.43	0.6	0.46	0.41																																																								5	1	2	-7	-5																																																								0.74	0.39	0.3794872			68	13			2	11/17/2001 7:23:00 AM
East River bridge on Hwy 49	6389	987003	6/28/2001	1130	150030	Darrin Fisher			True	False	False	False	False	False	75	0	8	6	0.3	0	0.2	<25																						False	True	False	False	False	False	False			True	False	False	False		15			0.42	0.57	0.63	0.64	1	1	0.62	0.3	0.12	1	0.55	0.52	0.41	0.3																																															3	2	4	4	0	0	3	3	4	4	4	4	4	0																																															1.699167	0.5771428	0.2102929			76	18			2	11/21/2001 6:14:00 PM
East River bridge on Hwy 49	1879	987003	8/7/2003	1000	120317	Casey Barber			True	False	False	False	False	False	72	0	9	5	0.15	0	0.1	Not Sampled																						False	True	False	False	False	False	False			True	False	False	False		6.3			0.13	0.16	0.14	0.18	0.2																																																																																																																				0	0.162				64	11.3	water not running because of drought		1	8/20/2003 12:41:00 PM
Manure Shed SBF	7041	987005	7/19/2004	800	100412	Ruthann Campbell	2	Not Recorded	True	False	False	False	True	False	79	0	7	8	0	5	0.2	34																						False	True	False	False	False	False	False			True	False	False	False		3.4			0.19																																																												3.6																																																												5.277778E-02	0.19	0.2777778			63	15			1	7/21/2004 7:50:00 AM
Manure Shed SBF	8155	987005	9/23/2004	1100	100412	Ruthann Campbell	2	Not Recorded	False	False	False	True	True	False	65	0	8	3	0.3	5	0.3	99																						False	True	False	False	False	False	False			True	False	False	False		43																																																																																																																											0	0				60	14			1	10/6/2004 3:23:00 PM
Manure Shed SBF	9900	987005	3/31/2005	1430	100412	Ruthann Campbell	2	Not Recorded	False	True	False	False	True	False	72	0	9	12	0.15	5	0	40																						True	False	False	False	False	False	False			True	False	False	False		3.4			0.19																																																												3.6																																																												5.277778E-02	0.19	0.2777778			60	15			1	4/12/2005 9:18:00 AM
Manure Shed SBF	14903	987005	5/23/2006	830	100412	Nancy Norris	2	0	False	False	True	False	True	False	69	0	6	8	1.5	10	0.2	28																						False	True	False	False	False	False	False	False	False	True	False	False	False	False	3	0.18	Low																																																																																																																									0	0		No	Yes	60	15			1	5/23/2006 10:26:00 AM
Sharpsburg SBF	7042	987006	7/19/2004	1230	100412	Ruthann Campbell	2	Not Recorded	True	False	False	False	True	False	80	0	7	6	0	10	0.3	34																						False	True	False	False	False	False	False			True	False	False	False		4			0.26	0.33	0.34																																																										4	3.9	2.8																																																										0.271044	0.31	0.2914451			68	16	Measure from post to road hazard flasher		1	7/21/2004 8:15:00 AM
Sharpsburg SBF	8156	987006	9/23/2004	1130	100412	Ruthann Campbell	2	Not Recorded	False	False	False	True	True	False	65	0	7	6	0.15	5	0.2	117																						False	True	False	False	False	False	False			True	False	False	False		4																																																																																																																											0	0				60	16	Water level high		1	10/6/2004 3:34:00 PM
Sharpsburg SBF	9901	987006	3/31/2005	1500	100412	Ruthann Campbell	2	Not Recorded	False	True	False	False	True	False	75	0	7	8	0.15	2	0.1	47																						True	False	False	False	False	False	False			True	False	False	False		4			0.26	0.33	0.34																																																										4	3.9	2.8																																																										0.271044	0.31	0.2914451			58	16			1	4/12/2005 9:23:00 AM
Sharpsburg SBF	14905	987006	5/23/2006	930	100412	Nancy Norris	2	0	False	True	False	False	True	False	72	0	7	6	0.3	10	0	28																						False	True	False	False	False	False	False	False	False	True	False	False	False	False	5	0.25	Low																																																																																																																									0	0		No	Yes	61	20			1	5/23/2006 10:41:00 AM