Newtown Creek Water Quality Data 2017 (public)

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1												LGCC spreadsheet
2	Date	Location	Time	DO mg/L	DO %	Salinity (ppt)	TDS (g/L)	Temp (F)	Bloom	Surface Debris Present	Nitrate (ppm)	Phosphate (ppm)	Enterococcus	pH	Rainfall (520 Kingsland)

3	4.20.17	01 (Pulaski)	11:52	8.38	82.7	17.2	18.18	50.5		1	0.453	4.393	<10	n/a	0.14 (day of)
4	4.20.17	02 (Apollo)	12:18	7.06	71.8	17	17.96	52.9		1	0.755	1.425	10	n/a	0.14 (day of)
5	4.20.17	03 (Turning Basin)	12:32	7.03	71	17.9	18.83	52	green	1	0.561	1.033	85	n/a	0.14 (day of)
6	4.20.17	04 (East Branch)	12:54	5.55	57.1	17.5	18.47	53.6			0.396	0.876	10	n/a	0.14 (day of)
7	4.20.17	05 (English Kills)	1:12	4.52	47.3	16.7	17.63	55.5			0.445	0.652	10	n/a	0.14 (day of)
8	4.20.17	06 (DK Mouth)	2:10	9.48	97.1	17.1	18.09	53.4	green		0.465	0	10	n/a	0.14 (day of)
9	4.20.17	06A (DK Montauk)	2:16	11.49	120.8	16.7	17.7	55.8	green	1					0.14 (day of)
10	4.20.17	06B (DK LIE)	2:20	12.41	132.2	17	17.91	56.7	green						0.14 (day of)
11	4.20.17	07 (DK Head)	2:25	12.92	134.4	17.7	18.62	54.4	green		0.281	1.561	20	n/a	0.14 (day of)
12
13	4.27.17	01 (Pulaski)	10:30	9.19	93	19	19.96	51		1	3.367	2.756	158	n/a	.27 (2 days) + 1.08 (3 days)
14	4.27.17	02 (Apollo)	11:11	4.58	47.7	14	14.99	55.9		1	11.27	3.012	4352	n/a	.27 (2 days) + 1.08 (3 days)
15	4.27.17	03 (Turning Basin)	11:30	3.72	39.5	13.8	14.84	57.8		1	3.424	4.142	3441	n/a	.27 (2 days) + 1.08 (3 days)
16	4.27.17	04 (East Branch)	11:50	3.38	35.3	14.1	15.11	56			3.744	4.773	1201	n/a	.27 (2 days) + 1.08 (3 days)
17	4.27.17	05 (English Kills)	12:20	4.01	41.3	14	15.05	55			7.812	2.467	3448	n/a	.27 (2 days) + 1.08 (3 days)
18	4.27.17	06 (DK Mouth)	1:08	6.02	64	16.3	17.27	56.5		1	1.428	2.185	546	n/a	.27 (2 days) + 1.08 (3 days)
19	4.27.17	06A (DK Montauk)	1:13	5.63	58.7	17.1	18.05	54.5							.27 (2 days) + 1.08 (3 days)
20	4.27.17	06B (DK LIE)	1:16	5.08	53	16	16.98	55							.27 (2 days) + 1.08 (3 days)
21	4.27.17	07 (DK Head)	1:23	5.23	56.3	14.8	15.82	58.5			3.898	2.057	417	n/a	.27 (2 days) + 1.08 (3 days)
22
23	5.4.17	01 (Pulaski)	11:31	7.9	83.6	18.4	19.32	56			0.23	2.368	<10	n/a	0"
24	5.4.17	02 (Apollo)	12:05	8.42	91.1	19.1	19.93	57.4		1	0.158	1.58	<10	n/a	0"
25	5.4.17	03 (Turning Basin)	12:33	10.06	109.1	18.8	19.68	57.9			0.3	2.186	10	n/a	0"
26	5.4.17	04 (East Branch)	1:00	6.36	70.5	18.3	19.14	60.1			0.051	4.25	294	n/a	0"
27	5.4.17	05 (English Kills)	1:30	9.25	101	18.5	19.37	58.5			0.1	2.093	10	n/a	0"
28	5.4.17	06 (DK Mouth)	2:30	9.08	98.3	18.7	19.56	57.7			0.242	1.607	<10	n/a	0"
29	5.4.17	06A (DK Montauk)	2:35	9.27	101.5	18.7	19.55	58.6		1					0"
30	5.4.17	06B (DK LIE)	2:40	12.09	132.2	18.8	19.66	58.4	brown						0"
31	5.4.17	07 (DK Head)	2:44	16.62	184.5	18.9	19.8	59.7	brown		0.08	2.029	52	n/a	0"
32
33	5.11.17	01 (Pulaski)	9:50	8.34	88.2	16.5	17.48	55.7		1	0.289	3.110	< 10	n/a	0"
34	5.11.17	02 (Apollo)	10:20	6.89	74.3	16.8	17.77	57.6		1	0.169	0.000	< 10	n/a	0"
35	5.11.17	03 (Turning Basin)	10:35	5.95	64.1	17.3	18.26	57.3			0.116	0.000	< 10	n/a	0"
36	5.11.17	04 (East Branch)	11:00	5.77	62.2	16.7	17.65	57.6			0.213	5.924 /1.065	10	n/a	0"
37	5.11.17	05 (English Kills)	11:25	2.67	29.2	16.4	17.36	58.9	white		0.047	2.983	20	n/a	0"
38	5.11.17	06 (DK Mouth)	12:55	8.43	92.5	17.1	18.04	58.8			0.236	1.777	< 10	n/a	0"
39	5.11.17	06A (DK Montauk)	1:00	8.13	89.1	17.1	18	58.7							0"
40	5.11.17	06B (DK LIE)	1:04	8.3	92	17.1	18	59.7							0"
41	5.11.17	07 (DK Head)	1:10	6.41	71.3	17.2	18.14	60			0.096	2.058	63	n/a	0"
42
43	5.18.17	01 (Pulaski)	11:38	6.75	76.8	16.5	17.44	62.3			0.36	1.953	52	n/a	1.85 (5 days)
44	5.18.17	02 (Apollo)	12:00	8.01	94.1	15.9	16.82	65.6	green		0.27	2.455	<10	n/a	1.85 (5 days)
45	5.18.17	03 (Turning Basin)	12:15	11.23	138.6	13.2	14.28	71.7	green		0.78	2.477	<10	n/a	1.85 (5 days)
46	5.18.17	04 (East Branch)	12:30	6.97	83.1	15.4	16.42	67			0.10	2.671	10	n/a	1.85 (5 days)
47	5.18.17	05 (English Kills)	1:00	9.07	104.7	14.9	15.91	64.3			0.10	2.482	10	n/a	1.85 (5 days)
48	5.18.17	06 (DK Mouth)	1:43	9.83	116.8	16.5	17.47	66			0.28	1.725	<10	n/a	1.85 (5 days)
49	5.18.17	06A (DK Montauk)	1:48	20.69	247.9	15.8	16.81	67.2	brown						1.85 (5 days)
50	5.18.17	06B (DK LIE)	1:51	21.7	268.1	15.2	16.2	70.5	brown						1.85 (5 days)
51	5.18.17	07 (DK Head)	1:57	27.62	345.8	13.4	14.49	72.6	brown	1	0.076	2.492	10	n/a	1.85 (5 days)
52
53	5.25.17	01 (Pulaski)	9:21	6.81	76.9	19.6	20.42	59.2		1	0.324		20	6.69	.48 (day of before on); .65 (3 days)
54	5.25.17	02 (Apollo)	9:47	5.87	66.2	18.3	19.21	59.7		1	0.265		379	7.55	.48 (day of before on); .65 (3 days)
55	5.25.17	03 (Turning Basin)	10:02	5.2	58.9	19	19.84	59.8			0.06		171	7.50	.48 (day of before on); .65 (3 days)
56	5.25.17	04 (East Branch)	10:22	3.18	35	14.3	15.37	59.9			0.222		24196	n/a	.48 (day of before on); .65 (3 days)
57	5.25.17	05 (English Kills)	10:40	6.84	78.2	17.6	18.48	61.4			0.272		1674	7.50	.48 (day of before on); .65 (3 days)
58	5.25.17	06 (DK Mouth)	11:23	7.19	82.3	12.2	13.27	64.3		1	0.142		<10	7.61	.48 (day of before on); .65 (3 days)
59	5.25.17	06A (DK Montauk)	11:28	6.78	77.3	13.5	14.54	63.3		1					.48 (day of before on); .65 (3 days)
60	5.25.17	06B (DK LIE)	11:35	5.71	61.8	10.4	11.37	60.6		1					.48 (day of before on); .65 (3 days)
61	5.25.17	07 (DK Head)	11:40	5.07	55.6	11.3	12.32	61		1	0.074		24196	7.52	.48 (day of before on); .65 (3 days)
62
63	6.1.17	01 (Pulaski)	11:01	6.34	73.2	17.8	18.7	63.1			0.131		31	7.52	.16 (2 days)
64	6.1.17	02 (Apollo)	11:45	4.94	58.1	19.8	20.6	63.5			0.099		<10	7.43	.16 (2 days)
65	6.1.17	03 (Turning Basin)	12:05	4.65	55.3	19.5	20.3	64.8			0.390		<10	7.37	.16 (2 days)
66	6.1.17	Plank Road	12:50	5.26	64	19.6	20.4	66.7							.16 (2 days)
67	6.1.17	04 (East Branch)	12:20	4.75	57.6	19.4	20.3	66.4			0.109		30	7.26	.16 (2 days)
68	6.1.17	05 (English Kills)	12:35	7.71	94.8	18.4	19.3	68.6			0.000		185	7.50	.16 (2 days)
69	6.1.17	06 (DK Mouth)	1:20	7.09	84.5	18.7	19.6	65.2			0.080		20	7.48	.16 (2 days)
70	6.1.17	06A (DK Montauk)	1:23	6.7	79.8	18.7	19.6	65.1							.16 (2 days)
71	6.1.17	06B (DK LIE)	1:27	6.42	77	18.9	19.8	65.8							.16 (2 days)
72	6.1.17	07 (DK Head)	1:30	5.55	68.6	18.9	19.8	68.6			0.047		20	7.47	.16 (2 days)
73
74	6.8.17	01 (Pulaski)	10:45	7.26	84	17.5	18.45	63.5			NA		<10	n/a	.09 (3 days)
75	6.8.17	02 (Apollo)	8:45	10.23	119	19.2	19.99	63.3	green		NA		<10	n/a	.09 (3 days)
76	6.8.17	03 (Turning Basin)	9:05	9.45	110.4	19.1	19.9	63.6	green		NA		10	n/a	.09 (3 days)
77	6.8.17	Plank Road	10:12	16.84	199	18.6	19.5	64.9							.09 (3 days)
78	6.8.17	04 (East Branch)	9:20	12.03	140.7	18.7	19.5	64	green		NA		10	n/a	.09 (3 days)
79	6.8.17	05 (English Kills)	9:40	8.01	94.3	18.2	19.01	64.9	green		NA		10	n/a	.09 (3 days)
80	6.8.17	06 (DK Mouth)	8:30	8.7	100.6	19.2	20	62.6			NA		20	n/a	.09 (3 days)
81	6.8.17	06A (DK Montauk)	8:12	8.28	95.6	18.8	19.64	62.8		1					.09 (3 days)
82	6.8.17	06B (DK LIE)	8:15	8.01	92.7	19.1	19.97	62.8							.09 (3 days)
83	6.8.17	07 (DK Head)	8:20	7.23	84.3	19.3	20.13	63.4			NA		<10	n/a	.09 (3 days)
84
85	6.15.17	01 (Pulaski)	9:25	8.24	101.8	18.1	19.02	69.5	brown	1	0.192		331	7.90	.71 (1 day)
86	6.15.17	02 (Apollo)	9:50	11.09	138.5	18.3	19.16	70.5	brown		0.218		246	8.17	.71 (1 day)
87	6.15.17	03 (Turning Basin)	10:05	9.82	123	17.6	18.52	71.1	brown		0.227		432	8.12	.71 (1 day)
88	6.15.17	Plank Road	10:53	9.57	120	18	18.96	74.2	brown						.71 (1 day)
89	6.15.17	04 (East Branch)	10:20	6.88	85.7	18.3	19.23	70.2	brown		0.095		15531	7.72	.71 (1 day)
90	6.15.17	05 (English Kills)	10:35	7.79	98.9	16.9	17.88	72.7			0.1		10	7.96	.71 (1 day)
91	6.15.17	06 (DK Mouth)	11:40	9.76	121.6	17.7	18.66	70.6	brown		0.076		10	8.19	.71 (1 day)
92	6.15.17	06A (DK Montauk)	11:45	9.71	121.9	18	18.93	71.1							.71 (1 day)
93	6.15.17	06B (DK LIE)	11:50	17.55	223	16.8	17.77	73.1	brown						.71 (1 day)
94	6.15.17	07 (DK Head)	11:55	17.03	217.8	15.7	16.73	73.1	brown		0.145		52	8.89	.71 (1 day)
95
96	6.22.17	01 (Pulaski)	8:25	5.26	64.8	16.8	17.79	69.8		1	0.040		228	n/a	1.41 (3 days)
97	6.22.17	02 (Apollo)	8:55	7.87	98.2	16.5	17.48	71.3		1	0.021		<10	n/a	1.41 (3 days)
98	6.22.17	03 (Turning Basin)	9:10	11.46	144.4	16.6	17.59	72.1	brown		0.158		10	n/a	1.41 (3 days)
99	6.22.17	Plank Road	9:22	7.04	88.3	16	17.02	72		1					1.41 (3 days)
100	6.22.17	04 (East Branch)	9:30	3.25	40.5	16.8	17.73	71			0.060		776	n/a	1.41 (3 days)