Street_Tree_List

Data source: data.sfgov.org

166 rows where PlotSize = "Width 3ft" and qSpecies = 109 sorted by Location

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by TreeID Sort by qLegalStatus Sort by qSpecies Sort by qAddress Sort by SiteOrder Sort by qSiteInfo Sort by PlantType Sort by qCaretaker Sort by qCareAssistant Sort by PlantDate Sort by DBH Sort by PlotSize Sort by PermitNotes Sort by XCoord Sort by YCoord Sort by Latitude Sort by Longitude Sort by Location

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location ▼
178254	178254	221510	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1300x Guerrero St	13	Median : Cutout 11	Tree 1	DPW 2			7	Width 3ft		6005838.80296	2100921.0233299998	37.7490592658716	-122.422601154533	(37.7490592658716, -122.422601154533)
185178	185178	221511	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1300x Guerrero St	11	Median : Cutout 11	Tree 1	DPW 2			6	Width 3ft		6005835.54562	2100976.57743	37.749211620932606	-122.422616365666	(37.7492116209326, -122.422616365666)
182868	182868	221512	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1300x Guerrero St	10	Median : Cutout 11	Tree 1	DPW 2			7	Width 3ft		6005835.43443	2101000.02463	37.749275995297296	-122.422618416129	(37.7492759952973, -122.422618416129)
41002	41002	221513	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1300x Guerrero St	9	Median : Cutout 11	Tree 1	DPW 2			7	Width 3ft		6005831.83209	2101056.03846	37.7494295931996	-122.42263485302799	(37.7494295931996, -122.422634853028)
73212	73212	221514	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1300x Guerrero St	8	Median : Cutout 11	Tree 1	DPW 2			8	Width 3ft		6005830.22915	2101083.18072	37.7495040291878	-122.42264232458	(37.7495040291878, -122.42264232458)
52769	52769	221515	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1300x Guerrero St	7	Median : Cutout 11	Tree 1	DPW 2			7	Width 3ft		6005828.19442	2101110.33186	37.7495784651962	-122.42265128992399	(37.7495784651962, -122.422651289924)
137049	137049	221516	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1300x Guerrero St	6	Median : Cutout 11	Tree 1	DPW 2			9	Width 3ft		6005827.472999999	2101138.31675	37.749655264584	-122.42265577304701	(37.749655264584, -122.422655773047)
153605	153605	221517	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1300x Guerrero St	4	Median : Cutout 11	Tree 1	DPW 2			7	Width 3ft		6005823.4134	2101214.1336	37.7498632112216	-122.422675198428	(37.7498632112216, -122.422675198428)
48258	48258	221518	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1300x Guerrero St	3	Median : Cutout 11	Tree 1	DPW 2			7	Width 3ft		6005823.14172	2101242.96968	37.7499423731511	-122.42267818684799	(37.7499423731511, -122.422678186848)
74207	74207	221519	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1300x Guerrero St	2	Median : Cutout 11	Tree 1	DPW 2			7	Width 3ft		6005822.7904900005	2101267.93468	37.7500109014944	-122.422681175305	(37.7500109014944, -122.422681175305)
150263	150263	221520	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1200x Guerrero St	13	Median : Cutout 11	Tree 1	DPW 2			6	Width 3ft		6005805.491090001	2101500.8171	37.7506493670819	-122.422757545722	(37.7506493670819, -122.422757545722)
182320	182320	221521	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1200x Guerrero St	12	Median : Cutout 11	Tree 1	DPW 2			7	Width 3ft		6005805.669319999	2101529.55059	37.7507282726947	-122.422758971142	(37.7507282726947, -122.422758971142)
32093	32093	221522	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1200x Guerrero St	11	Median : Cutout 11	Tree 1	DPW 2			18	Width 3ft		6005804.6365	2101559.54048	37.750810559762705	-122.42276467376999	(37.7508105597627, -122.42276467377)
155379	155379	221559	Undocumented 2	Acacia stenophylla :: Shoestring Acacia 109	1306 York St	4	: 4	Tree 1	Private 1			7	Width 3ft		6010039.89073	2101557.1439900002	37.7510420290671	-122.408118546954	(37.7510420290671, -122.408118546954)
25270	25270	221523	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1200x Guerrero St	8	Median : Cutout 11	Tree 1	DPW 2			7	Width 3ft		6005797.77147	2101666.82906	37.751104762181	-122.42279603761101	(37.751104762181, -122.422796037611)
54972	54972	221524	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1200x Guerrero St	7	Median : Cutout 11	Tree 1	DPW 2			8	Width 3ft		6005795.8556	2101693.96335	37.7511791585977	-122.42280459107401	(37.7511791585977, -122.422804591074)
48249	48249	221525	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1200x Guerrero St	6	Median : Cutout 11	Tree 1	DPW 2			4	Width 3ft		6005795.99168	2101720.64475	37.7512524272579	-122.422806016491	(37.7512524272579, -122.422806016491)
73681	73681	221526	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1200x Guerrero St	5	Median : Cutout 11	Tree 1	DPW 2			8	Width 3ft		6005792.85635	2101748.62489	37.7513290773756	-122.42281884712601	(37.7513290773756, -122.422818847126)
65787	65787	221527	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1200x Guerrero St	4	Median : Cutout 11	Tree 1	DPW 2			7	Width 3ft		6005790.21854	2101800.81566	37.7514722323764	-122.422831677752	(37.7514722323764, -122.422831677752)
47639	47639	221528	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1200x Guerrero St	3	Median : Cutout 11	Tree 1	DPW 2			8	Width 3ft		6005788.731319999	2101828.76193	37.7515488824818	-122.422838806667	(37.7515488824818, -122.422838806667)
55516	55516	221529	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1200x Guerrero St	1	Median : Cutout 11	Tree 1	DPW 2			10	Width 3ft		6005786.9094	2101880.5255400003	37.751690910628	-122.42284878555701	(37.751690910628, -122.422848785557)
42667	42667	221530	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1100x Guerrero St	12	Median : Cutout 11	Tree 1	DPW 2			11	Width 3ft		6005772.5167	2102115.11175	37.75233421815221	-122.422915228372	(37.7523342181522, -122.422915228372)
150449	150449	221531	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1100x Guerrero St	11	Median : Cutout 11	Tree 1	DPW 2			0	Width 3ft		6005769.92765	2102140.767	37.7524045154572	-122.422926004956	(37.7524045154572, -122.422926004956)
159464	159464	221532	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1100x Guerrero St	10	Median : Cutout 11	Tree 1	DPW 2			8	Width 3ft		6005770.103999999	2102168.30473	37.7524801376575	-122.42292735211201	(37.7524801376575, -122.422927352112)
188083	188083	221533	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1100x Guerrero St	9	Median : Cutout 11	Tree 1	DPW 2			8	Width 3ft		6005767.42939	2102227.70946	37.75264309841	-122.422940823082	(37.75264309841, -122.422940823082)
158034	158034	221565	Undocumented 2	Acacia stenophylla :: Shoestring Acacia 109	4286 23rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6001328.916669999	2102339.67059	37.7526990668325	-122.438297967381	(37.7526990668325, -122.438297967381)
179284	179284	221563	Undocumented 2	Acacia stenophylla :: Shoestring Acacia 109	4286 23rd St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6001305.60339	2102341.6071	37.752703058000705	-122.438378727412	(37.7527030580007, -122.438378727412)
179875	179875	221564	Undocumented 2	Acacia stenophylla :: Shoestring Acacia 109	4286 23rd St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6001316.917769999	2102341.7359599997	37.7527040553705	-122.438339609582	(37.7527040553705, -122.438339609582)
55535	55535	221566	Undocumented 2	Acacia stenophylla :: Shoestring Acacia 109	4286 23rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6001342.8820400005	2102344.46852	37.7527130350975	-122.43825001643299	(37.7527130350975, -122.438250016433)
163113	163113	221534	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1100x Guerrero St	8	Median : Cutout 11	Tree 1	DPW 2			7	Width 3ft		6005765.63484	2102254.12398	37.7527155253202	-122.422948906168	(37.7527155253202, -122.422948906168)
129563	129563	221535	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1100x Guerrero St	6	Median : Cutout 11	Tree 1	DPW 2			4	Width 3ft		6005763.23809	2102308.0919	37.7528635735186	-122.42296102995199	(37.7528635735186, -122.422961029952)
185218	185218	221536	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1100x Guerrero St	5	Median : Cutout 11	Tree 1	DPW 2			9	Width 3ft		6005762.1987	2102333.32685	37.75293280420979	-122.422966417762	(37.7529328042098, -122.422966417762)
130218	130218	221537	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1100x Guerrero St	4	Median : Cutout 11	Tree 1	DPW 2			6	Width 3ft		6005757.84067	2102377.3752200003	37.753053504939	-122.422984619142	(37.753053504939, -122.422984619142)
32785	32785	221538	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1100x Guerrero St	3	Median : Cutout 11	Tree 1	DPW 2			7	Width 3ft		6005757.68157	2102409.38047	37.7531413749784	-122.422987443927	(37.7531413749784, -122.422987443927)
177057	177057	221539	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1100x Guerrero St	2	Median : Cutout 11	Tree 1	DPW 2			5	Width 3ft		6005756.51513	2102435.1394700003	37.753212037416	-122.422993308391	(37.753212037416, -122.422993308391)
34243	34243	221540	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1100x Guerrero St	1	Median : Cutout 11	Tree 1	DPW 2			6	Width 3ft		6005754.92272	2102467.8076299997	37.753301646771	-122.42300113699301	(37.753301646771, -122.423001136993)
44105	44105	221562	Undocumented 2	Acacia stenophylla :: Shoestring Acacia 109	100 San Jose Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6006161.28805	2102498.9287799997	37.753410020459995	-122.421598049829	(37.75341002046, -122.421598049829)
148793	148793	221561	Undocumented 2	Acacia stenophylla :: Shoestring Acacia 109	100 San Jose Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6006161.81341	2102510.42937	37.7534416280528	-122.42159704977	(37.7534416280528, -122.42159704977)
71884	71884	221560	Undocumented 2	Acacia stenophylla :: Shoestring Acacia 109	100 San Jose Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6006161.42459	2102519.64651	37.7534669142699	-122.42159904898001	(37.7534669142699, -122.42159904898)
67326	67326	221557	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1000x Guerrero St	15	Median : Cutout 11	Tree 1	DPW 2			3	Width 3ft		6005743.02813	2102638.73526	37.7537703032837	-122.42305441913099	(37.7537703032837, -122.423054419131)
180267	180267	221556	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1000x Guerrero St	14	Median : Cutout 11	Tree 1	DPW 2			3	Width 3ft		6005741.57845	2102677.06839	37.753875475376	-122.42306215689501	(37.753875475376, -122.423062156895)
182798	182798	221555	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1000x Guerrero St	13	Median : Cutout 11	Tree 1	DPW 2			2	Width 3ft		6005738.9106	2102712.57542	37.753972818908	-122.423073906548	(37.753972818908, -122.423073906548)
76663	76663	221554	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1000x Guerrero St	12	Median : Cutout 11	Tree 1	DPW 2			4	Width 3ft		6005736.5559	2102753.56312	37.754085228758505	-122.423084962814	(37.7540852287585, -122.423084962814)
68227	68227	221553	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1000x Guerrero St	11	Median : Cutout 11	Tree 1	DPW 2			3	Width 3ft		6005734.111409999	2102791.4847	37.7541892146839	-122.42309611170799	(37.7541892146839, -122.423096111708)
176544	176544	221552	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1000x Guerrero St	10	Median : Cutout 11	Tree 1	DPW 2			3	Width 3ft		6005734.10722	2102815.94179	37.754256367947704	-122.423097864468	(37.7542563679477, -122.423097864468)
143107	143107	221551	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1000x Guerrero St	9	Median : Cutout 11	Tree 1	DPW 2			2	Width 3ft		6005731.5319	2102850.00284	37.7543497463656	-122.423109191463	(37.7543497463656, -122.423109191463)
177873	177873	221550	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1000x Guerrero St	7	Median : Cutout 11	Tree 1	DPW 2			1	Width 3ft		6005729.97057	2102894.68155	37.7544723356343	-122.423117766494	(37.7544723356343, -122.423117766494)
176764	176764	221549	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1000x Guerrero St	6	Median : Cutout 11	Tree 1	DPW 2			1	Width 3ft		6005728.89674	2102911.59468	37.7545187145683	-122.423122682192	(37.7545187145683, -122.423122682192)
169550	169550	221558	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1000x Guerrero St	5	Median : Cutout 11	Tree 1	DPW 2			3	Width 3ft		6005728.5881	2102926.2105099997	37.754558828830106	-122.423124788381	(37.7545588288301, -122.423124788381)
131374	131374	221548	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1000x Guerrero St	4	Median : Cutout 11	Tree 1	DPW 2			3	Width 3ft		6005727.072790001	2102965.9789400003	37.7546679382008	-122.42313285530899	(37.7546679382008, -122.423132855309)
135861	135861	221547	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1000x Guerrero St	3	Median : Cutout 11	Tree 1	DPW 2			3	Width 3ft		6005723.41397	2102999.7023	37.7547603282456	-122.42314790545299	(37.7547603282456, -122.423147905453)
76927	76927	221546	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1000x Guerrero St	2	Median : Cutout 11	Tree 1	DPW 2			3	Width 3ft		6005723.96055	2103030.09242	37.7548438033068	-122.423148175257	(37.7548438033068, -122.423148175257)
34286	34286	221545	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1000x Guerrero St	1	Median : Cutout 11	Tree 1	DPW 2			2	Width 3ft		6005721.87722	2103062.7074700003	37.754933239094704	-122.423157698184	(37.7549332390947, -122.423157698184)
178961	178961	221541	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	900x Guerrero St	8	Median : Cutout 11	Tree 1	DPW 2			6	Width 3ft		6005710.1718	2103251.3867	37.7554506478492	-122.423211590049	(37.7554506478492, -122.423211590049)
149575	149575	221542	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	900x Guerrero St	7	Median : Cutout 11	Tree 1	DPW 2			8	Width 3ft		6005709.18006	2103278.9471400003	37.7555262664424	-122.423216978787	(37.7555262664424, -122.423216978787)
61658	61658	221543	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	900x Guerrero St	6	Median : Cutout 11	Tree 1	DPW 2			8	Width 3ft		6005707.0284	2103306.91954	37.7556029507207	-122.42322640818999	(37.7556029507207, -122.42322640819)
168829	168829	221544	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	900x Guerrero St	5	Median : Cutout 11	Tree 1	DPW 2			7	Width 3ft		6005705.623380001	2103333.32509	37.755675374928295	-122.423233144119	(37.7556753749283, -122.423233144119)
155244	155244	221567	Undocumented 2	Acacia stenophylla :: Shoestring Acacia 109	324 Hill St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6004154.58593	2103373.98314	37.7556993571514	-122.428600021096	(37.7556993571514, -122.428600021096)
148070	148070	221507	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	900x Guerrero St	2	Median : Cutout 11	Tree 1	DPW 2			5	Width 3ft		6005699.48542	2103446.5929900003	37.755986035831704	-122.42326242243999	(37.7559860358317, -122.42326242244)
35380	35380	221506	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	900x Guerrero St	1	Median : Cutout 11	Tree 1	DPW 2			5	Width 3ft		6005698.11962	2103476.06965	37.756066894799204	-122.423269241105	(37.7560668947992, -122.423269241105)
32169	32169	221427	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	900x Guerrero St	6	Median : Cutout 11	Tree 1	DPW 2			6	Width 3ft		6005696.85287	2103501.5592	37.7561368116793	-122.42327543382099	(37.7561368116793, -122.423275433821)
46284	46284	221426	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	900x Guerrero St	5	Median : Cutout 11	Tree 1	DPW 2			6	Width 3ft		6005693.61577	2103548.6076700003	37.7562658131324	-122.423289973179	(37.7562658131324, -122.423289973179)
134735	134735	221425	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	900x Guerrero St	3	Median : Cutout 11	Tree 1	DPW 2			6	Width 3ft		6005689.68683	2103597.2936	37.7563992716189	-122.42330702161301	(37.7563992716189, -122.423307021613)
189094	189094	221424	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	900x Guerrero St	2	Median : Cutout 11	Tree 1	DPW 2			6	Width 3ft		6005689.534530001	2103630.03961	37.7564891759384	-122.423309876046	(37.7564891759384, -122.423309876046)
41267	41267	221568	Undocumented 2	Acacia stenophylla :: Shoestring Acacia 109	359 Diamond St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6001813.22675	2103761.96483	37.7566318794794	-122.436724942504	(37.7566318794794, -122.436724942504)
43283	43283	221415	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	800x Guerrero St	1	Median : Cutout 11	Tree 1	DPW 2			1	Width 3ft		6005678.5014	2103825.14435	37.7570242653802	-122.42336190183201	(37.7570242653802, -122.423361901832)
30827	30827	221416	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	800x Guerrero St	2	Median : Cutout 11	Tree 1	DPW 2			2	Width 3ft		6005677.18728	2103848.76992	37.757089061516204	-122.42336812603399	(37.7570890615162, -122.423368126034)
159637	159637	221417	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	800x Guerrero St	3	Median : Cutout 11	Tree 1	DPW 2			1	Width 3ft		6005673.16306	2103886.4908	37.7571924071266	-122.42338472483101	(37.7571924071266, -122.423384724831)
44886	44886	221418	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	800x Guerrero St	5	Median : Cutout 11	Tree 1	DPW 2			8	Width 3ft		6005666.2176	2103986.40391	37.757466353200996	-122.423415847665	(37.757466353201, -122.423415847665)
55774	55774	221419	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	800x Guerrero St	6	Median : Cutout 11	Tree 1	DPW 2			6	Width 3ft		6005664.4202	2104015.7148700003	37.7575467328056	-122.423424147502	(37.7575467328056, -122.423424147502)
147617	147617	221420	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	800x Guerrero St	8	Median : Cutout 11	Tree 1	DPW 2			5	Width 3ft		6005663.71373	2104068.90036	37.7576927278639	-122.423430371709	(37.7576927278639, -122.423430371709)
155282	155282	221421	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	800x Guerrero St	9	Median : Cutout 11	Tree 1	DPW 2			7	Width 3ft		6005663.971419999	2104121.3615	37.7578367884406	-122.42343320997499	(37.7578367884406, -122.423433209975)
174460	174460	221422	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	800x Guerrero St	10	Median : Cutout 11	Tree 1	DPW 2			6	Width 3ft		6005661.88318	2104154.96713	37.7579289437835	-122.42344282103001	(37.7579289437835, -122.42344282103)
134894	134894	221423	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	800x Guerrero St	12	Median : Cutout 11	Tree 1	DPW 2			6	Width 3ft		6005658.05131	2104209.2390900003	37.7580777456208	-122.42345993152901	(37.7580777456208, -122.423459931529)
5127	5127	152423	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	700x Guerrero St	12	Median : Cutout 11	Tree 1	DPW 2			0	Width 3ft		6005645.11359	2104396.78205	37.758591964470895	-122.423518008854	(37.7585919644709, -122.423518008854)
5168	5168	152422	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	700x Guerrero St	11	Median : Cutout 11	Tree 1	DPW 2			0	Width 3ft		6005644.9376300005	2104427.7274700003	37.7586769234173	-122.423520817442	(37.7586769234173, -122.423520817442)
5113	5113	152421	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	700x Guerrero St	10	Median : Cutout 11	Tree 1	DPW 2			0	Width 3ft		6005642.99765	2104457.73967	37.7587592203909	-122.42352966049	(37.7587592203909, -122.42352966049)
51201	51201	221569	Undocumented 2	Acacia stenophylla :: Shoestring Acacia 109	616 Noe St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6003001.08037	2104529.5167	37.7588068286936	-122.432671745707	(37.7588068286936, -122.432671745707)
5118	5118	152420	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	700x Guerrero St	9	Median : Cutout 11	Tree 1	DPW 2			0	Width 3ft		6005641.8915099995	2104501.69931	37.7588798608311	-122.42353661133998	(37.7588798608311, -122.42353661134)
5122	5122	152419	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	700x Guerrero St	8	Median : Cutout 11	Tree 1	DPW 2			0	Width 3ft		6005637.900330001	2104551.94757	37.7590176055009	-122.423553987148	(37.7590176055009, -122.423553987148)
5131	5131	152418	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	700x Guerrero St	7	Median : Cutout 11	Tree 1	DPW 2			0	Width 3ft		6005636.4507	2104585.0792400003	37.759108495478394	-122.42356135618999	(37.7591084954784, -122.42356135619)
5135	5135	152417	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	700x Guerrero St	6	Median : Cutout 11	Tree 1	DPW 2			0	Width 3ft		6005634.27087	2104624.16733	37.7592156991708	-122.423571674116	(37.7592156991708, -122.423571674116)
5111	5111	152416	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	700x Guerrero St	5	Median : Cutout 11	Tree 1	DPW 2			0	Width 3ft		6005631.99539	2104658.5890900004	37.7593100848133	-122.423581991114	(37.7593100848133, -122.423581991114)
5137	5137	152415	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	700x Guerrero St	4	Median : Cutout 11	Tree 1	DPW 2			0	Width 3ft		6005628.48676	2104715.95286	37.7594673942256	-122.423598204106	(37.7594673942256, -122.423598204106)
5114	5114	152414	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	700x Guerrero St	3	Median : Cutout 11	Tree 1	DPW 2			0	Width 3ft		6005626.99355	2104746.96336	37.7595524574982	-122.423605573157	(37.7595524574982, -122.423605573157)
5110	5110	152413	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	700x Guerrero St	2	Median : Cutout 11	Tree 1	DPW 2			0	Width 3ft		6005625.074080001	2104777.98262	37.7596375207611	-122.42361441706899	(37.7596375207611, -122.423614417069)
5138	5138	152412	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	700x Guerrero St	1	Median : Cutout 11	Tree 1	DPW 2			0	Width 3ft		6005623.17605	2104812.38517	37.7597318749526	-122.4236234274	(37.7597318749526, -122.4236234274)
136012	136012	187785	Undocumented 2	Acacia stenophylla :: Shoestring Acacia 109	1740 20th St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 3ft		6012766.00153	2104746.33455	37.7599511143744	-122.39891512883499	(37.7599511143744, -122.398915128835)
48680	48680	221505	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	600x Guerrero St	12	Median : Cutout 11	Tree 1	DPW 2			2	Width 3ft		6005615.32825	2104975.43597	37.760179131174795	-122.423662162075	(37.7601791311748, -122.423662162075)
4487	4487	221504	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	600x Guerrero St	11	Median : Cutout 11	Tree 1	DPW 2		02/21/2015 11:05:00 PM	2	Width 3ft		6005611.75297	2105011.45268	37.7602778227802	-122.42367708812901	(37.7602778227802, -122.423677088129)
4517	4517	221503	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	600x Guerrero St	10	Median : Cutout 11	Tree 1	DPW 2		02/21/2015 11:06:00 PM	2	Width 3ft		6005610.53101	2105047.42068	37.7603765134773	-122.423683871708	(37.7603765134773, -122.423683871708)
4481	4481	221502	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	600x Guerrero St	9	Median : Cutout 11	Tree 1	DPW 2		02/21/2015 11:07:00 PM	2	Width 3ft		6005607.7078	2105081.85863	37.760470912626296	-122.42369608451	(37.7604709126263, -122.42369608451)
4526	4526	221501	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	600x Guerrero St	8	Median : Cutout 11	Tree 1	DPW 2		02/21/2015 11:08:00 PM	2	Width 3ft		6005604.17413	2105138.97106	37.7606275304574	-122.423712366728	(37.7606275304574, -122.423712366728)
4478	4478	221500	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	600x Guerrero St	7	Median : Cutout 11	Tree 1	DPW 2		02/28/2015 11:10:00 PM	2	Width 3ft		6005602.08318	2105171.2083400004	37.7607159284129	-122.423721890569	(37.7607159284129, -122.423721890569)
4499	4499	221499	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	600x Guerrero St	6	Median : Cutout 11	Tree 1	DPW 2		02/28/2015 11:01:00 PM	2	Width 3ft		6005601.090469999	2105206.48742	37.760812740428904	-122.42372783238899	(37.7608127404289, -122.423727832389)
184414	184414	221498	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	600x Guerrero St	5	Median : Cutout 11	Tree 1	DPW 2			3	Width 3ft		6005599.77613	2105242.7413	37.7609122108583	-122.423734955914	(37.7609122108583, -122.423734955914)
4491	4491	221497	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	600x Guerrero St	4	Median : Cutout 11	Tree 1	DPW 2		02/21/2015 10:57:00 PM	2	Width 3ft		6005595.06917	2105295.4476799998	37.761056664463204	-122.42375498292499	(37.7610566644632, -122.423754982925)
4523	4523	221496	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	600x Guerrero St	3	Median : Cutout 11	Tree 1	DPW 2		02/21/2015 12:00:00 AM	2	Width 3ft		6005594.03058	2105332.56679	37.761158526170895	-122.423761214331	(37.7611585261709, -122.423761214331)
4454	4454	221495	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	600x Guerrero St	2	Median : Cutout 11	Tree 1	DPW 2		02/21/2015 10:54:00 PM	2	Width 3ft		6005593.17627	2105367.35468	37.761253997298205	-122.42376664264299	(37.7612539972982, -122.423766642643)
4507	4507	221494	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	600x Guerrero St	1	Median : Cutout 11	Tree 1	DPW 2		02/21/2015 10:53:00 PM	2	Width 3ft		6005589.49697	2105398.2938599996	37.7613387412987	-122.423781567769	(37.7613387412987, -122.423781567769)

Next page

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");