GCC Community Science Water Quality Data_Public

	A	B	C	D	E	F	G	H	I	J	K	L
1			The Community Science data below reflects the results from each school's visit from 2017 - 2022. Community Scientists range from grades 5 - 12. Tests are conducted by students with the help of GCC facilitators and data is recorded by GCC staff.
2	School	Date	Time	Rainfall in last 48 hours?	Temperature (°C)	Salinity (ppt)	Turbidity (cm)	Nitrate (ppm)	Phosphate (ppm)	Dissolved Oxygen (ppm)	Biological Oxygen Demand (ppm)	Enterococcus (MPN/100mL)

3	IS24	11/2/2017	11:30 AM	>0.1	18.326	13.66	58.72	0.15	2	8.56	4.56	119
4	SMMS	11/08/2017	11:00 AM	0.78	13.8575	20.43375	27.44	0.17	0	7.08	2	383
5	JHS223	11/13/2017	11:00 AM	0.05	11.99	23.6	41.975	0.13	0	7.5	3.5	121
6	JHS234	11/14/2017	11:00 AM	0.07	12.36	26.1	19.09	0.17	0	6.8	3	161
7	IS226	11/21/17	10:50 AM	0	12.3	23.4	37.49	0.19	3	9.53	6	75
8	IS226	11/28/17	11:00 AM	0	10.4	24.5	50.825	0.00925	1.1	10.22	5	10
9	SMMS	11/29/17	11:10 AM	0	12.646	22.8	42.2	0.3198	2	7.564	3	10
10	IS.24	12/06/17	11:15 AM	0.75	10.34	28.5	42.0325	0.104	0	8.47	6.5	368
11	JHS234	12/07/2017	11:15 AM	0.75	24.08	38.316	0.16381	1.22	8.3228	4.1	5	52
12	JHS223	12/12/17	11:30 AM	0.09 *Did snow over the weekend	8.25	24.75	42.66	0.013	0	9.175	3	62
13
14	MS2	10/30/2018	2:00 PM	0.4	13.28	20	53.5	3.75	0.64	7.5	3	41
15	PS225	11/01/2018	10:30 AM	0.43	15	23.25	36.15	2.88	0.93	9	3	20
16	DitmasJHS	11/8/2018	10:30 AM	0.29	11.98	16.75	26.03	4.5	1.25	8	3	332
17	MS2	11/13/2018	2:00 PM	0.49	10.15	13.75	36	4.38	0.73	7.25	4	12,033
18	PS206	11/20/2018	10:30 AM	0	8.75	19	43.7	4.5	1.03	7.25	2	31
19	PS206	11/27/2018	10:30 AM	1.21	7.7	21.2	41.08	4	1.09	6.6	3	609
20	DitmasJHS	11/28/2018	10:30 AM	1.22	5.66	14.6	31.32	5	0.92	8.67	2	119
21	PS225	11/29/2018	10:30 AM	0.78	8.23	12.25	26.93	3.63	1.63	7.75	3	148
22
23	MS447	3/28/2019	10:30 AM	0	9.5	12.67	30.7	n/a	n/a	2.87	n/a	n/a
24	MS447	4/16/2019	10:30 AM	1.02	11.3	13.2	26.4	n/a	n/a	1.8	n/a	n/a
25	PS58	4/30/2019	9:45 AM	0.03	12.78	12.05	36.25	n/a	n/a	4.38	n/a	n/a
26	PS58	5/7/2019	9:45 AM	1.53	16.4	18	34.88	n/a	n/a	2.6	n/a	n/a
27	PS58	5/9/2019	9:45 AM	0.21	14.6	16.65	39.35	n/a	n/a	1.87	n/a	n/a
28	PS58	5/14/2019	9:45 AM	2.61	12.4	15.12	36.95	n/a	n/a	2.37	n/a	n/a
29	JHS223	5/21/2019	10:00 AM	0.06	19.95	15.3	50	n/a	n/a	2.13	n/a	n/a
30	PS58	5/30/2019	9:45 AM	1.87	16.4	18	34.88	n/a	n/a	2.6	n/a	n/a
31	Brooklyn Frontiers	6/11/2019	12:30 PM	0.97	14.6	16.65	39.35	n/a	n/a	1.87	n/a	n/a
32
33	ISB	9/24/19	10:00 AM	0.01	25.17	25.37	44.25	n/a	n/a	3.5	n/a	n/a
34	FGPA	10/24/19	10:00 AM	0.36	17.16	19	42.9	0.18	1.5	2.6	2	12,997
35	Mott Hall 2	10/29/2019	10:00 AM	1.3	15.6	22	81.8	1.5	3	2.5	0.5	882
36	Marine Park	11/12/19	10:30 AM	0.04	13.74	21.2	50	1	1.6	1.4	4	355
37	Mott Hall 2	11/14/19	10:00 AM	0.04	19.64	16.1	89.4	0.3	1.5	0.5	0	20
38	PS/IS 206	11/19/19	10:00 AM	0.43	18.96	18.33	53	0.73	1.16	1.66	4	15,531
39	Marine Park	11/21/19	10:30 AM	0.19	8.62	18.2	87.6	1	1.4	0.4	0	309
40	FGPA	11/26/19	10:00 AM	0.76	11.3	18.8	76.24	2.4	1.5	0.1	2	272
41	PS/IS 206	12/12/19	10:30 AM	0.72	6.35	15.57	42.75	4.25	1	0.75	2	5,172
42
43	Note: We are collecting water quality data for the 2020 season with new testing equipment and processing enterococcus samples at a new lab. Instead of using the most probable number (MPN) metric, we are using colony forming units (CFU). This metric is more accurate and preferred by New York State and the Environmental Protection Agency. "TNTC" indicates "too numerous to count", meaning the enterococcus sample is greater than 6,000 CFU. The EPA recommends less than 110 CFU in a single sample to be considered "safe".
44	GCC Staff	10/15/2020	12:30 PM	0.13	17.1	25.51	n/a	n/a	n/a	6.06	n/a	270 CFU
45	GCC Staff	10/22/2020	1:10 PM	0.01	17.1	24.9	167.64	n/a	n/a	6.29	n/a	58 CFU
46	GCC Staff	10/29/20	12:20 PM	0.09	15.9	22.17	30.48	n/a	n/a	6.84	n/a	TNTC
47	GCC Staff	11/5/20	1:20 PM	0	13.7	23.78	111.76	n/a	n/a	7.62	n/a	20 CFU
48	GCC Staff	11/12/20	1:00 PM	0.72	14.7	25.27	76.2	n/a	n/a	7	n/a	240 CFU
49	GCC Staff	11/19/20	1:15 PM	0	12.1	24.73	40.64	n/a	n/a	7.97	n/a	600 CFU
50	GCC Staff	11/23/20	1:40 PM	0.38	15.8	32.75	55.88	n/a	n/a	8.53	n/a	1400 CFU
51	GCC Staff	12/3/20	1:45 PM	0	10.3	17.3	15.24	n/a	n/a	9.43	n/a	210 CFU
52	GCC Staff	12/10/20	12:30 PM	0.06	9.2	21.54	30.48	n/a	n/a	8.73	n/a	60 CFU
53	GCC Staff	12/15/20	12:30 PM	0.28	8.8	21.97	30.48	n/a	n/a	8.39	n/a	500 CFU
54
55	GCC Staff	6/3/21	2:10 PM	0.75	16.3	24.04	121.92	n/a	n/a	7.3	n/a	161 MPN
56	GCC Staff	6/10/21	1:30 PM	0	n/a	n/a	91.44	n/a	n/a	7.6	n/a	670 MPN
57	GCC Staff	6/17/21	2:20 PM	0.01	20	23.26	131.06	n/a	n/a	5.94	n/a	20 MPN
58	GCC Staff	6/24/21	12:15 PM	0	19.8	24.81	60.96	n/a	n/a	5.73	n/a	98 MPN
59	GCC Staff	7/1/21	12:25 PM	0.76	22.2	24.53	106.68	n/a	n/a	4.07	n/a	12,997 MPN
60	GCC Staff	7/15/21	11:30 AM	0.71	23.6	19.51	152.4	n/a	n/a	4.71	n/a	168 MPN
61	GCC Staff	7/20/21	2:15 PM	0.42	24.7	17.42	121.92	n/a	n/a	5.14	n/a	109 MPN
62	GCC Staff	7/22/21	12:00 PM	2.27	23.7	19.48	60.96	n/a	n/a	5.02	n/a	771 MPN
63	GCC Staff	8/4/21	10:00 AM	0	22.9	18.66	70.104	n/a	n/a	2.75	n/a	110 MPN
64	GCC Staff	8/5/21	10:30 AM	0	20.9	22.04	83.82	n/a	n/a	4.96	n/a	74 MPN
65	GCC Staff	8/17/21	1:15 PM	1.28	23.9	23.88	100.58	n/a	n/a	5.22	n/a	85 MPN
66	GCC Staff	8/24/21	12:10 PM	0.25	24.5	19.94	106.68	n/a	n/a	4.25	n/a	327 MPN
67	GCC Staff	8/26/21	11:00 AM	0	25.6	17.2	100.58	n/a	n/a	4.1	n/a	63 MPN
68	GCC Staff	9/1/21	1:00 PM	0	23.8	17.99	131.06	n/a	n/a	4.52	n/a	160 MPN
69	GCC Staff	9/2/21	2:00 PM	0	23.3	16.05	100.58	n/a	n/a	5.05	n/a	4,360 MPN
70	GCC Staff	9/9/21	11:00 AM	0.43	22.7	21.35	167.64	n/a	n/a	5.81	n/a	425 MPN
71	GCC Staff	9/15/21	10:30 AM		22.7	21.11	100.58	n/a	n/a	6.43	n/a	159 MPN
72	Brooklyn Collaboratove Studies	4/13/22	3:30 PM	n/a	9.3	17	45.72	5	1	8	n/a	n/a
73	Brooklyn Collaboratove Studies	4/28/22	3:30 PM	n/a	10.7	14	35.56	5	1	8	n/a	n/a
74	Brooklyn Collaboratove Studies	5/11/22	3:30 PM	n/a	17.5	18	33	5	1	4	n/a	n/a
75	Brooklyn Collaboratove Studies	5/18/02	3:30 PM	n/a	14.5	22	23	5	1	4	n/a	n/a
76	Brooklyn Collaboratove Studies	5/25/22	3:30 PM	n/a	18.6	22	61	0	1	5	n/a	n/a
77	Brooklyn Collaboratove Studies	6/1/22	3:30 PM	n/a	18	22	65	0	1	8	n/a	n/a
78	GCC Staff	9/16/21	11:30 AM		22.5	21.69	91.44	n/a	n/a	6.02	n/a	52 MPN
79	Brooklyn Urban Garden School	9/23/22	10:30 AM	0.5	19.8	26.75	44.6	0	3.5	2.43	n/a	n/a
80	International School of Brooklyn	9/27/22	10:45 AM	1.11	23.74	22.6	56	3	1.6	4	n/a	n/a
81	GCC Staff	9/29/2022	12:15 PM	0	19.7	26.07	n/a	n/a	n/a	5.97	n/a	52 MPN
82	GCC Staff	10/6/22	11:00 AM	1.92	16.7	24.98	n/a	n/a	n/a	6.15	n/a	52 MPN
83	Lyon's Community School	10/6/22	1:45 PM	1.92	18.6	24.75	37.75	2.5	2.5	4	n/a	n/a
84	GCC Staff	10/13/22	9:25 AM	0	16.6	26.24	n/a	n/a	n/a	6.01	n/a	52 MPN
85	PS 124	10/18/22	10:30 AM	0.04	13.1	21.3	31	5	1	4	n/a	n/a
86	GCC Staff	10/20/22	9:50 AM	0.001	15.6	23.39	n/a	n/a	n/a	7.25	n/a	63 MPN
87	PS 124	10/20/22	10:30 AM	0.001	17.2	18.33	48.5	0	2	3.66	n/a	n/a
88	GCC Staff	10/27/22	11:38 AM	0.002	16.2	26.18	n/a	n/a	n/a	6.5	n/a	20 MPN
89	PS 32	11/1/22	10:45 AM	0.183	16.1	23.75	35.25	2.25	0	4	n/a	n/a
90	GCC Staff	11/3/22	11:32 AM	0.092	15.8	25.53	n/a	n/a	n/a	7.24	n/a	52 MPN
91	GCC Staff	11/10/22	10:30 AM	0	15	26.44	n/a	n/a	n/a	6.68	n/a	20 MPN
92	BASE High School	11/10/22	12:40 PM	0	15	30	75.6	0	1.6	4	n/a	n/a
93	Transit Tech HS	11/15/22	10:40 AM	0	10.62	24.5	66.47	0.25	1.36	3	n/a	n/a
94	GCC Staff	11/17/22	11:50 AM	0.53	12.5	20.49	n/a	n/a	n/a	7.27	n/a	36.6 MPN
95	Transit Tech HS	11/17/22	10:40 AM	0.53	8.4	23.5	31.55	0	1	2	n/a	n/a
96	GCC Staff	11/22/22	9:48 AM	0	10.8	23.34	n/a	n/a	n/a	8.97	n/a	20 MPN
97	Brooklyn Collaboratove Studies	4/25/23	3:30 PM	n/a	12.5	n/a	34.5	5	n/a	n/a	n/a	n/a
98	Brooklyn Collaboratove Studies	5/4/23	3:30 PM	n/a	11.5	10	65	5	4	0	n/a	n/a
99	Brooklyn Collaboratove Studies	5/23/23	3:30 PM	n/a	11.12	35	54	5	<1	0	n/a	n/a
100	Brooklyn Collaboratove Studies	5/30/23	3:30 PM	n/a	18.4	24	64	5	<1	3	n/a	n/a