FinalSensorObservationswithMap.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	sensor	mission	avg_mass conc	avg_lpo	avg_av0	tally	duration	dep_loctn	latitude	longitude	dep_start	dep_end	logfile	Conversion PM2.5 Value	Overall PM 2.5 value
2
3	DUSTY	224	11729	14.36	0.57	118	0:59:00	Azalea Community Park	32.732403	-117.10733	4/28/15 14:25	4/28/15 15:25	12147	656.824	461.552
4	DUSTY	155	5533	7.62	0.64	239	1:59:30	Azalea Community Park	32.732643	-117.107353	4/19/15 13:50	4/19/15 15:50	12144	309.848
5	DUSTY	280	493	0.94	0.62	120	1:00:00	Azalea Community Park	32.732403	-117.107323	5/3/15 14:16	5/3/15 15:17	12149	27.608
6	DUSTY	156	9799	10.18	0.59	234	1:57:00	Azalea Community Park	32.732693	-117.107407	4/26/15 13:50	4/26/15 15:50	12145	548.744
7	DUSTY	145	13656	14.35	0.66	240	2:00:00	Azalea Community Park	32.732609	-117.107391	4/12/15 13:55	4/12/15 15:55	123	764.736
8							7:55:30
9
10	Bot	209	396	0.63	2.17	126	1:03:00	Mercado Del Barrio 1985 National Ave #1115 San Diego, CA	32.70023	-117.145126	4/21/15 19:00	4/21/15 20:00	10029	22.176	30.506
11	Bot	207	156	0.3	3.7	118	0:59:00	Ryan Bros. Coffee 1894 Main St, San Diego, CA 92113	32.699387	-117.146553	4/16/15 15:00	4/16/15 16:00	10027	8.736
12	Bot	205	9	0.02	2.34	182	1:31:00	Ryan Bros. Coffee 1894 Main St, San Diego, CA 92113	32.699387	-117.146553	4/10/15 13:20	4/10/15 14:46	10022	0.504
13	Bot	212	628	1.21	2.74	131	1:05:30	Ryan Bros. Coffee 1894 Main St, San Diego, CA 92113	32.699387	-117.146553	4/27/15 17:39	4/27/15 18:39	10035	35.168
14	Bot	210	251	0.48	2.18	114	0:57:00	Ryan Bros. Coffee 1894 Main St, San Diego, CA 92113	32.699387	-117.146553	4/22/15 17:10	4/22/15 18:10	10030	14.056
15	Bot	208	2015	2.68	2.17	123	1:01:30	Mercado Del Barrio 1985 National Ave #1115 San Diego, CA	32.70023	-117.145126	4/20/15 17:54	4/20/15 18:56	10028	112.84
16	Bot	206	717	1.38	2.22	117	0:58:30	Mercado Del Barrio 1985 National Ave #1115, San Diego, CA 92113	32.70023	-117.145126	4/13/15 17:43	4/13/15 18:45	10026	40.152
17	Bot	211	186	0.35	2.48	117	0:58:30	Ryan Bros Coffee 1894 Main St, San Diego, CA 92113	32.699387	-117.146553	4/23/15 12:45	4/23/15 13:45	10032	10.416
18							8:34:00
19
20	Baby	228	58	0.11	2.76	119	0:59:30	Bankers Hill	32.739044	-117.158806	4/21/15 12:37	4/21/15 13:37	10038	3.248	70.819
21	Baby	238	410	0.78	3.33	120	1:00:00	Bankers Hill	32.731144	-117.160385	4/29/15 9:22	4/29/15 10:22	10044	22.96
22	Baby	234	403	0.77	2.75	120	1:00:00	Bankers Hill	32.735313	-117.159042	4/27/15 17:43	4/27/15 18:43	10042	22.568
23	Baby	229	2596	3.5	2.29	121	1:00:30	Bankers Hill	32.726669	-117.15905	4/22/15 18:53	4/22/15 19:53	10039	145.376
24	Baby	225	267	0.51	2.42	119	0:59:30	Bankers Hill	32.731121	-117.160301	4/20/15 21:08	4/20/15 22:08	10037	14.952
25	Baby	240	3470	6.1	2.51	120	1:00:00	Bankers Hill	32.738464	-117.1604	4/27/15 16:35	4/27/15 17:35	10041	194.32
26	Baby	236	2304	4.22	2.6	118	0:59:00	Bankers Hill	32.731125	-117.160385	4/28/15 9:21	4/28/15 10:21	10043	129.024
27	Baby	231	609	1.09	2.35	118	0:59:00	Bankers Hill	32.731102	-117.160332	4/23/15 9:32	4/23/15 10:32	10040	34.104
28							7:57:30
29
30	Edu	243	6452	8.36	2.66	119	0:59:30	Maple Canyon Trail by Quince street	32.731152	-117.160355	4/28/15 9:21	4/28/15 10:21	10030	361.312	248
31	Edu	241	1056	1.88	2.59	120	1:00:00	5th Avenue/Palm Street (Bankers Hill)	32.735386	-117.160347	4/27/15 17:25	4/27/15 18:25	10028	59.136
32	Edu	237	2385	3.81	2.11	122	1:01:00	Laurel Street/6th Avenue (Bankers Hill)	32.731586	-117.159409	4/20/15 18:53	4/20/15 19:53	10025	133.56
33	Edu	226	1500	2.43	2.87	119	0:59:30	Maple Canyon Trail by Quince street	32.737118	-117.162155	4/21/15 12:35	4/21/15 13:35	10024	84
34	Edu	244	16081	17.64	2.84	120	1:00:00	Laurel Street/5th Avenue (Bankers Hill)	32.731117	-117.160332	4/29/15 9:24	4/29/15 10:24	10031	900.536
35	Edu	242	1833	3.25	2.32	86	0:43:00	Laurel Street/6th Avenue (Bankers Hill)	32.731586	-117.159409	4/27/15 18:35	4/27/15 19:35	10029	102.648
36	Edu	239	1693	2.51	2.27	120	1:00:00	Laurel Street/5th Avenue (Bankers Hill)	32.731079	-117.160378	4/23/15 9:32	4/23/15 10:32	10026	94.808
37							6:43:00
38
39	GLAM	223	6032	8.54	1.85	212	1:46:00	CHICANOPARK	32.700344	-117.143021	4/29/15 10:00	4/29/15 10:00	10072	337.792	162.47
40	GLAM	221	5041	8.32	1.89	137	1:08:30	CHICANOPARK	32.700344	-117.143021	4/23/15 9:00	4/23/15 10:00	10070	282.296
41	GLAM	219	874	1.36	1.77	253	2:06:30	CHICANOPARK	32.700344	-117.143021	4/16/15 9:00	4/16/15 10:00	10068	48.944
42	GLAM	216	3084	4.81	0.82	180	1:30:00	CHICANOPARK	32.700344	-117.143021	4/7/15 9:00	4/7/15 10:00	10065	172.704
43	GLAM	301	836	1.57	1.39	136	1:08:00	CHICANO PARK	32.700344	-117.143021	4/9/15 9:00	4/9/15 10:00	10074	46.816
44	GLAM	222	3145	5.6	1.89	168	1:24:00	CHICANOPARK	32.700344	-117.143021	4/28/15 9:00	4/28/15 10:00	10071	176.12
45	GLAM	220	4045	6	2	124	1:02:00	CHICANOPARK	32.700344	-117.143021	4/21/15 9:00	4/21/15 10:00	10069	226.52
46	GLAM	218	153	0.29	0.65	247	2:03:30	CHICANOPARK	32.700344	-117.143021	4/14/15 9:00	4/14/15 10:00	10067	8.568
47							12:08:30
48
49	H1000	161	24	0.04	0.57	123	1:01:30	starbucks/pizza on 5th	32.731144	-117.160416	4/20/15 10:45	4/20/15 11:45	10033	1.344	51.051
50	H1000	164	1231	2.16	2.25	125	1:02:30	starbucks/pizza on 5th	32.731071	-117.1605	4/26/15 16:32	4/26/15 17:32	10035	68.936
51	HAL1K	168	2	0	1.74	117	0:58:30	starbucks/pizza on 5th	32.731033	-117.160545	4/27/15 11:24	4/27/15 12:24	10036	0.112
52	HAL1K	160	535	1.01	0.77	120	1:00:00	starbucks/pizza on 5th	32.731136	-117.160431	4/19/15 18:30	4/19/15 19:30	10032	29.96
53	HAL1K	146	1939	3.24	0.85	119	0:59:30	Starbucks, 5th Ave, BH	32.731144	-117.160416	4/10/15 15:20	4/10/15 16:20	10030	108.584
54	HAL1K	249	711	1.35	1.61	119	0:59:30	pizza shop table on 5th	32.731106	-117.1605	4/27/15 12:32	4/27/15 13:32	10038	39.816
55	HAL1K	162	1275	2.17	2.23	162	1:21:00	starbucks/pizza on 5th	32.731071	-117.1605	4/24/15 14:42	4/24/15 15:42	10034	71.4
56	HAL1K	147	1576	2.89	0.78	123	1:01:30	same place	32.73114	-117.160423	4/13/15 11:20	4/13/15 12:20	10031	88.256
57							8:24:00
58
59
60	Ntlia	195	171	0.33	0.13	174	1:27:00	Logan Heights7	32.698612	-117.129417	4/25/15 19:00	4/25/15 20:00	10036	9.576	12.456
61	Ntlia	320	229	0.44	0.14	162	1:21:00	Logan Heights 3	32.698612	-117.129417	4/17/15 19:00	4/17/15 20:00	10026	12.824
62	Ntlia	318	503	0.97	0.13	115	0:57:30	Logan Heights8	32.698612	-117.129417	4/28/15 10:00	4/28/15 11:00	10037	28.168
63	Ntlia	196	260	0.5	0.14	141	1:10:30	Logan Heights6	32.698612	-117.129417	4/24/15 10:00	4/24/15 11:00	10035	14.56
64	Ntlia	322	246	0.47	0.13	122	1:01:00	Logan Heights 1	32.698612	-117.129417	4/14/15 19:00	4/14/15 20:00	10023	13.776
65	Ntlia	319	99	0.19	0.13	136	1:08:00	Logan Heights 4	32.698612	-117.129417	4/21/15 10:23	4/21/15 11:23	10027	5.544
66	Ntlia	315	49	0.09	0.13	57	0:28:30	Logan Heights5	32.698612	-117.129417	4/23/15 19:00	4/23/15 20:00	10034	2.744
67							7:33:30
68
69	R2D2	171	9	0.02	0.16	121	1:00:30	Logan Elementary	32.693192	-117.078476	4/16/15 17:07	4/16/15 18:06	19	0.504	21.812
70	R2D2	166	318	0.61	0.16	113	0:56:30	Logan Elementary	32.700771	-117.132423	4/23/15 10:35	4/23/15 11:35	23	17.808
71	R2D2	169	699	1.3	0.17	110	0:55:00	Logan Heights Library	32.709213	-117.154182	4/17/15 13:50	4/17/15 14:49	21	39.144
72	R2D2	167	199	0.38	0.16	114	0:57:00	Logan Elementary	32.700771	-117.132423	4/21/15 19:47	4/21/15 20:48	22	11.144
73	R2D2	165	528	0.96	0.18	116	0:58:00	Logan Elementary	32.700771	-117.132423	4/25/15 15:47	4/27/15 16:44	24	29.568
74	R2D2	163	584	1.11	0.18	71	0:35:30	Logan Elementary	32.700771	-117.132423	4/25/15 14:16	4/25/15 15:15	25	32.704
75							5:22:30
76
77	Sensi	134	1614	2.91	2.11	19	0:09:30	Pt 6 Barrio Logan	32.697655	-117.142937	3/21/15 14:58	3/21/15 15:48	10036	90.384	11.32061538
78	Sensi	132	178	0.34	2.1	19	0:09:30	Pt 4 Barrio Logan	32.697517	-117.14109	3/21/15 15:13	3/21/15 15:23	10039	9.968
79	Sensi	270	9	0.02	2.23	19	0:09:30	Pt 14	32.69997	-117.146049	4/30/15 14:04	4/30/15 14:14	10007	0.504
80	Sensi	130	141	0.27	2.23	18	0:09:00	Pt 2 Barrio Logan	32.69828	-117.139297	3/21/15 13:48	3/21/15 13:58	10032	7.896
81	Sensi	268	21	0.04	2.37	19	0:09:30	Pt 11 Barrio Logan	32.699284	-117.146858	4/30/15 13:33	4/30/15 13:43	10005	1.176
82	Sensi	266	51	0.1	2.31	20	0:10:00	Pt 9 Barrio Logan	32.696899	-117.143135	4/30/15 13:06	4/30/15 13:16	10003	2.856
83	Sensi	264	23	0.04	2.31	20	0:10:00	Pt 7 Barrio Logan	32.696533	-117.140907	4/30/15 12:42	4/30/15 12:52	10001	1.288
84	Sensi	135	193	0.37	2.13	20	0:10:00	Pt 7 Barrio Logan	32.696445	-117.138412	3/21/15 15:29	3/21/15 15:39	10040	10.808
85	Sensi	133	204	0.39	2.09	19	0:09:30	Pt 5 Barrio Logan	32.699036	-117.142708	3/21/15 14:42	3/21/15 14:52	10035	11.424
86	Sensi	131	143	0.27	2.19	20	0:10:00	Pt 3 Barrio Logan	32.69899	-117.140289	3/21/15 14:16	3/21/15 14:26	10033	8.008
87	Sensi	269	41	0.08	2.28	19	0:09:30	Pt 12 Barrio Logan	32.70013	-117.148376	4/30/15 13:52	4/30/15 14:02	10006	2.296
88	Sensi	267	1	0	2.17	19	0:09:30	Pt 10 Barrio Logan	32.695148	-117.142136	4/30/15 13:19	4/30/15 13:29	10004	0.056
89	Sensi	265	9	0.02	2.57	19	0:09:30	Pt 8 Barrio Logan	32.69548	-117.141533	4/30/15 12:54	4/30/15 13:04	10002	0.504
90							2:05:00
91
92	Steve	304	282	0.54	0.44	133	1:06:30	Memorial Park	32.699734	-117.130547	4/3/15 13:00	4/3/15 14:00	10022	15.792	19.2864
93	Steve	308	138	0.26	0.43	116	0:58:00	Memorial Park	32.699787	-117.130524	4/17/15 14:00	4/17/15 15:00	10028	7.728
94	Steve	305	561	1.08	0.43	119	0:59:30	Memorial Park	32.699753	-117.130463	4/4/15 15:00	4/4/15 16:00	10023	31.416
95	Steve	309	592	1.14	0.41	127	1:03:30	Memorial Park	32.699753	-117.130486	4/24/15 14:00	4/24/15 15:00	10029	33.152
96	Steve	307	149	0.29	0.42	135	1:07:30	Memorial Park	32.699699	-117.130463	4/10/15 13:00	4/10/15 14:00	10025	8.344
97							5:15:00
98
99
100