Street_Tree_List

Data source: data.sfgov.org

1,742 rows where qSpecies = 51 sorted by Longitude descending

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

- 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, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude ▲	Location
77552	77552	50767	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	800 Innes Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/24/2004 12:00:00 AM			Permit Number 47301	6019786.72970778	2094070.44918577	37.73102596117	-122.373894113437	(37.73102596117, -122.373894113437)
81095	81095	50764	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	800 Innes Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/24/2004 12:00:00 AM			Permit Number 47301	6019786.72970778	2094070.44918577	37.73102596117	-122.373894113437	(37.73102596117, -122.373894113437)
142095	142095	50766	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	800 Innes Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/24/2004 12:00:00 AM			Permit Number 47301	6019786.72970778	2094070.44918577	37.73102596117	-122.373894113437	(37.73102596117, -122.373894113437)
143984	143984	50765	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	800 Innes Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/24/2004 12:00:00 AM			Permit Number 47301	6019786.72970778	2094070.44918577	37.73102596117	-122.373894113437	(37.73102596117, -122.373894113437)
25481	25481	198281	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		6017868.75025	2099595.89007	37.7460920687928	-122.380908946009	(37.7460920687928, -122.380908946009)
160306	160306	198282	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		6017853.17114	2099595.49021	37.74609011098	-122.38096278932301	(37.74609011098, -122.380962789323)
74955	74955	198283	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		6017833.27301	2099593.92963	37.7460847276446	-122.381031486718	(37.7460847276446, -122.381031486718)
31735	31735	198284	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		6017813.21777	2099593.44192	37.74608228148	-122.381100801954	(37.74608228148, -122.381100801954)
42267	42267	198426	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1333 Hudson Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6017711.66244	2094697.5586700002	37.7326335587832	-122.381111632521	(37.7326335587832, -122.381111632521)
30849	30849	198285	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		6017793.32679	2099592.23757	37.7460778765941	-122.381169499371	(37.7460778765941, -122.381169499371)
50176	50176	198425	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1335 Hudson Ave	15	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6017678.76067	2094717.52418	37.7326865639235	-122.38122677090401	(37.7326865639235, -122.381226770904)
55610	55610	198286	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		6017773.62926	2099591.7423799997	37.7460754295565	-122.381237577149	(37.7460754295565, -122.381237577149)
38795	38795	198287	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		6017753.37339	2099590.18904	37.7460700461913	-122.38130751204399	(37.7460700461913, -122.381307512044)
65432	65432	198288	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		6017733.321719999	2099589.8795	37.7460680892801	-122.3813768273	(37.7460680892801, -122.3813768273)
170643	170643	198289	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		6017712.53976	2099588.87163	37.746064174537004	-122.381448619273	(37.746064174537, -122.381448619273)
67092	67092	198290	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		6017692.8350599995	2099588.0199599997	37.746060748120705	-122.381516697036	(37.7460607481207, -122.381516697036)
131704	131704	198291	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		6017672.75114	2099586.10688	37.746054386310796	-122.38158601229601	(37.7460543863108, -122.381586012296)
37378	37378	198292	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		6017651.2465699995	2099584.75723	37.7460494930826	-122.381660279195	(37.7460494930826, -122.381660279195)
57835	57835	198293	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		6017632.06769	2099583.36051	37.746044598982	-122.381726500798	(37.746044598982, -122.381726500798)
57758	57758	198294	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		6017591.2197	2099581.33021	37.7460367685821	-122.381867608025	(37.7460367685821, -122.381867608025)
73875	73875	198295	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	16	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		6017570.97457	2099580.31165	37.746032853833206	-122.38193754289101	(37.7460328538332, -122.381937542891)
53948	53948	198296	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	17	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		6017552.343280001	2099579.4388200003	37.7460294283132	-122.382001907384	(37.7460294283132, -122.382001907384)
183395	183395	198297	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	18	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		6017533.81233	2099583.55419	37.7460397048816	-122.382066271836	(37.7460397048816, -122.382066271836)
172019	172019	198298	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	19	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		6017519.7761	2099586.1475400003	37.7460460504973	-122.38211498813601	(37.7460460504973, -122.382114988136)
147691	147691	198299	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	20	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		6017490.49598	2099601.17912	37.746085707003004	-122.38221728150499	(37.746085707003, -122.382217281505)
159839	159839	198423	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1195 La Salle Ave	24	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6017270.50645	2094483.4459099998	37.7320212859403	-122.38262193865299	(37.7320212859403, -122.382621938653)
51018	51018	198427	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1322 Hudson Ave	51	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6017279.83873	2095283.438	37.7342184214395	-122.382645321023	(37.7342184214395, -122.382645321023)
66929	66929	198422	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1196 La Salle Ave	15	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6017170.944180001	2094491.5929599998	37.7320381554174	-122.38296671716199	(37.7320381554174, -122.382966717162)
117525	117525	12095	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1261X La Salle Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/23/1996 12:00:00 AM	6	3X3		6017141.6501925	2094501.7221284	37.732064349457005	-122.383068698568	(37.732064349457, -122.383068698568)
71767	71767	198424	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1197 La Salle Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6017092.18151	2094577.95359	37.7322709323521	-122.38324502853999	(37.7322709323521, -122.38324502854)
130533	130533	198421	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1196 La Salle Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6017061.11221	2094548.33613	37.732187891662896	-122.383350382316	(37.7321878916629, -122.383350382316)
144194	144194	12106	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1281X La Salle Ave	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/23/1996 12:00:00 AM	6	3X3		6017033.141005999	2094557.4754692002	37.732211440602605	-122.383447721977	(37.7322114406026, -122.383447721977)
22997	22997	12121	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1400X La Salle Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			2	3X3		6016540.00349	2094984.34395	37.733356269266295	-122.38518235797899	(37.7333562692663, -122.385182357979)
9186	9186	10962	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1431 Hudson Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/04/1998 12:00:00 AM	3	3X4		6016563.2925523	2096760.0557493	37.7382333059102	-122.385225528118	(37.7382333059102, -122.385225528118)
15078	15078	2525	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1570 Burke Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/10/2016 02:24:00 PM	3	3X3		6016567.66909	2098923.0431	37.7441726718323	-122.385361080243	(37.7441726718323, -122.385361080243)
16215	16215	2527	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1570 Burke Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/10/2016 02:21:00 PM	3	3X3		6016536.91868	2098947.33995	37.7442376847211	-122.38546910231001	(37.7442376847211, -122.38546910231)
15469	15469	12131	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1400X La Salle Ave	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6016434.11275	2095220.18267	37.7339979769066	-122.38556488553499	(37.7339979769066, -122.385564885535)
16106	16106	12141	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1400X La Salle Ave	21	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3X3		6016374.05041	2095443.42618	37.7346076354195	-122.38578809634899	(37.7346076354195, -122.385788096349)
79748	79748	52609	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	900 Gilman Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/03/2006 12:00:00 AM			Permit Number 48695	6016118.74890568	2089125.97967621	37.717247040692	-122.386230482369	(37.717247040692, -122.386230482369)
101940	101940	52610	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	900 Gilman Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/03/2006 12:00:00 AM			Permit Number 48695	6016118.74890568	2089125.97967621	37.717247040692	-122.386230482369	(37.717247040692, -122.386230482369)
110588	110588	52611	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	900 Gilman Ave	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/03/2006 12:00:00 AM			Permit Number 48695	6016118.74890568	2089125.97967621	37.717247040692	-122.386230482369	(37.717247040692, -122.386230482369)
119803	119803	52612	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	900 Gilman Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/03/2006 12:00:00 AM			Permit Number 48695	6016118.74890568	2089125.97967621	37.717247040692	-122.386230482369	(37.717247040692, -122.386230482369)
121183	121183	52603	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	900 Gilman Ave	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/03/2006 12:00:00 AM			Permit Number 48695	6016118.74890568	2089125.97967621	37.717247040692	-122.386230482369	(37.717247040692, -122.386230482369)
86847	86847	53136	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1400@ JENNINGS Yosemite Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2006 12:00:00 AM			Permit Number 49070	6015681.6329149	2091892.45532517	37.7248190377031	-122.38793433454201	(37.7248190377031, -122.387934334542)
89907	89907	53134	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1400@ JENNINGS Yosemite Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2006 12:00:00 AM			Permit Number 49070	6015681.6329149	2091892.45532517	37.7248190377031	-122.38793433454201	(37.7248190377031, -122.387934334542)
90678	90678	53135	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1400@ JENNINGS Yosemite Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2006 12:00:00 AM			Permit Number 49070	6015681.6329149	2091892.45532517	37.7248190377031	-122.38793433454201	(37.7248190377031, -122.387934334542)
114694	114694	53138	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1400@ JENNINGS Yosemite Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2006 12:00:00 AM			Permit Number 49070	6015681.6329149	2091892.45532517	37.7248190377031	-122.38793433454201	(37.7248190377031, -122.387934334542)
140773	140773	53137	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1400@ JENNINGS Yosemite Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2006 12:00:00 AM			Permit Number 49070	6015681.6329149	2091892.45532517	37.7248190377031	-122.38793433454201	(37.7248190377031, -122.387934334542)
23334	23334	8279	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1601 Galvez Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			1	3x3		6015771.79311	2097687.24817	37.740735369454605	-122.388026849781	(37.7407353694546, -122.388026849781)
16692	16692	12234	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1570 La Salle Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/25/2002 12:00:00 AM	6	3X3		6015728.02305	2096056.7839799998	37.7362560216982	-122.38806443872	(37.7362560216982, -122.38806443872)
14268	14268	12235	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1574 La Salle Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/27/1997 12:00:00 AM	6	3X3		6015715.635319999	2096065.54177	37.736279382483204	-122.38810787958201	(37.7362793824832, -122.388107879582)
16089	16089	71389	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1501 Kirkwood Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/14/2013 12:00:00 AM	12	3x3	Permit Number 770154	6015658.34523	2096378.9353200002	37.7371367232675	-122.388327823184	(37.7371367232675, -122.388327823184)
100645	100645	88216	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1500 Revere Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/08/2008 12:00:00 AM		3x3	Permit Number 51215	6015591.6	2094077.6	37.730814022139505	-122.38839801578001	(37.7308140221395, -122.38839801578)
106416	106416	88215	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1500 Revere Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/08/2008 12:00:00 AM		3x3	Permit Number 51215	6015591.6	2094077.6	37.730814022139505	-122.38839801578001	(37.7308140221395, -122.38839801578)
119265	119265	88214	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1500 Revere Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/08/2008 12:00:00 AM		3x3	Permit Number 51215	6015591.6	2094077.6	37.730814022139505	-122.38839801578001	(37.7308140221395, -122.38839801578)
159205	159205	198306	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	502 Beale St	20	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 6ft		6015908.341130001	2113925.9394400003	37.78533088635999	-122.38868801426202	(37.78533088636, -122.388688014262)
3661	3661	253519	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	701 22nd St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				Width 3ft		6015696.1864	2103920.99342	37.7578477430893	-122.38872333331899	(37.7578477430893, -122.388723333319)
172008	172008	198255	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	701 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6015696.1864	2103920.99342	37.7578477430893	-122.38872333331899	(37.7578477430893, -122.388723333319)
13984	13984	21894	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2068 03rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/01/2003 12:00:00 AM	3	2X3		6015677.89854	2105976.47682	37.7634906462863	-122.388930084758	(37.7634906462863, -122.388930084758)
132456	132456	198307	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Brannan St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6015819.881580001	2113595.44766	37.784418527738204	-122.388970977841	(37.7844185277382, -122.388970977841)
96000	96000	40028	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1566 Newcomb Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/01/2009 12:00:00 AM		3x3	Permit Number 52304	6015421.32187962	2095579.21927044	37.7349277287796	-122.389091506131	(37.7349277287796, -122.389091506131)
132057	132057	198269	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	401 16th St	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6015584.25134	2107180.42064	37.7667912238576	-122.38933806131	(37.7667912238576, -122.38933806131)
74713	74713	198308	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Brannan St	19	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6015701.627180001	2113485.85575	37.7841110576194	-122.389372445082	(37.7841110576194, -122.389372445082)
141210	141210	53149	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1499@ LANE Thomas Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/02/2006 12:00:00 AM			Permit Number 49076	6015286.17606683	2093519.24782482	37.7292639697355	-122.389414946979	(37.7292639697355, -122.389414946979)
162847	162847	198309	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Brannan St	20	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6015688.10696	2113472.66106	37.7840740783932	-122.389418298834	(37.7840740783932, -122.389418298834)
51539	51539	198268	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	401 16th St	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6015559.03734	2107179.0425299997	37.7667860419549	-122.389425176852	(37.7667860419549, -122.389425176852)
136548	136548	53053	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1042 Tennessee St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/26/2006 12:00:00 AM	5	3x3	Permit Number 49030	6015494.75997	2104280.44649	37.7588235587865	-122.38944505814501	(37.7588235587865, -122.389445058145)
184466	184466	198267	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	401 16th St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6015536.948369999	2107177.2535099997	37.7667799049876	-122.389501454631	(37.7667799049876, -122.389501454631)
28474	28474	198266	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	401 16th St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6015509.21403	2107176.39831	37.7667760190131	-122.389597324184	(37.7667760190131, -122.389597324184)
159176	159176	198265	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	401 16th St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6015482.60076	2107174.90803	37.766770451333706	-122.38968927173799	(37.7667704513337, -122.389689271738)
69929	69929	198264	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	401 16th St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6015458.161180001	2107173.009	37.7667638817829	-122.389773672231	(37.7667638817829, -122.389773672231)
29284	29284	198256	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	718 Tennessee St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 4ft		6015417.87325	2105664.96075	37.762620874174104	-122.38980767650499	(37.7626208741741, -122.389807676505)
28007	28007	198263	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	401 16th St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6015429.86935	2107171.76588	37.7667588995269	-122.38987144293002	(37.7667588995269, -122.38987144293)
46587	46587	198262	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	401 16th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6015403.651819999	2107169.78818	37.766752015232	-122.38996198758001	(37.766752015232, -122.38996198758)
40735	40735	198261	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	401 16th St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6015349.85102	2107166.4928900003	37.7667399832017	-122.390147846856	(37.7667399832017, -122.390147846856)
162245	162245	198260	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	401 16th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6015323.86346	2107164.8695799997	37.7667340845278	-122.390237620786	(37.7667340845278, -122.390237620786)
163390	163390	198310	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	299 Bryant St	28	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6015446.63596	2114020.379	37.7855645967725	-122.390291988402	(37.7855645967725, -122.390291988402)
170522	170522	198259	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	401 16th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6015299.78244	2107163.66731	37.7667294476245	-122.39032082966601	(37.7667294476245, -122.390320829666)
33869	33869	198258	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	401 16th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6015275.05109	2107162.53945	37.766724978901	-122.390406293135	(37.766724978901, -122.390406293135)
132413	132413	198257	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	401 16th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6015249.12496	2107161.11313	37.7667196243297	-122.390495868314	(37.7667196243297, -122.390495868314)
86423	86423	52157	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1625 Shafter Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/31/2005 12:00:00 AM			Permit Number 48349	6014824.95742785	2094210.63428485	37.731136795346295	-122.391057738459	(37.7311367953463, -122.391057738459)
77376	77376	49717	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1195 Fitzgerald Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/03/2003 12:00:00 AM			Permit Number 46529	6014698.72785663	2090465.4227663002	37.7208461876659	-122.39123244275801	(37.7208461876659, -122.391232442758)
83435	83435	49719	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1195 Fitzgerald Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/03/2003 12:00:00 AM			Permit Number 46529	6014698.72785663	2090465.4227663002	37.7208461876659	-122.39123244275801	(37.7208461876659, -122.391232442758)
87176	87176	49716	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1195 Fitzgerald Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/03/2003 12:00:00 AM			Permit Number 46529	6014698.72785663	2090465.4227663002	37.7208461876659	-122.39123244275801	(37.7208461876659, -122.391232442758)
84938	84938	102708	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	999X PHELPS ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/07/2015 12:00:00 AM	3	3x3	Permit Number 773962	6014744.0	2097272.0	37.7395381878784	-122.39155157401501	(37.7395381878784, -122.391551574015)
114153	114153	102709	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	999X PHELPS ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/07/2015 12:00:00 AM	3	3x3	Permit Number 773962	6014744.0	2097272.0	37.7395381878784	-122.39155157401501	(37.7395381878784, -122.391551574015)
39506	39506	198280	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	951 Phelps St	2	: 4	Tree 1	Private 1			1	Width 3ft		6014735.9327300005	2097232.0415	37.739428022289204	-122.39157667443001	(37.7394280222892, -122.39157667443)
128924	128924	84862	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1683 Kirkwood Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/27/2007 12:00:00 AM			Permit No. 49249	6014727.7	2097047.5	37.73892085236739	-122.39159224107901	(37.7389208523674, -122.391592241079)
129509	129509	198279	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	951 Phelps St	1	: 4	Tree 1	Private 1			1	Width 3ft		6014707.30065	2097191.0938	37.7393139990344	-122.391672810175	(37.7393139990344, -122.391672810175)
43763	43763	79959	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1719 Quesada Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/07/2002 12:00:00 AM	5			6014649.309169999	2095031.35513	37.73338057973321	-122.39172235292	(37.7333805797332, -122.39172235292)
91780	91780	50195	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1723 Quesada Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/25/2003 12:00:00 AM			Permit Number 46901	6014617.12557199	2095043.2497264	37.7334114532812	-122.39183445293001	(37.7334114532812, -122.39183445293)
138694	138694	45717	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1780 McKinnon Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/02/2001 12:00:00 AM			Permit Number 44387	6014447.60969273	2096647.07167699	37.7378058077839	-122.392532669221	(37.7378058077839, -122.392532669221)
123705	123705	45718	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1784 McKinnon Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/02/2001 12:00:00 AM			Permit Number 44388	6014427.08068492	2096662.22075279	37.7378462639335	-122.39260470792802	(37.7378462639335, -122.392604707928)
165778	165778	198314	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	578 02nd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6014710.85995	2112833.85129	37.7822658223454	-122.39275454260401	(37.7822658223454, -122.392754542604)
15099	15099	99592	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1855X Evans Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	3x3		6014373.22453	2099430.50237	37.7454443986533	-122.392984546922	(37.7454443986533, -122.392984546922)
147989	147989	36728	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	8 South Park	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/26/1998 12:00:00 AM	1		Permit Number 39511	6014628.68085	2112892.71481	37.7824228835593	-122.39304296778099	(37.7824228835593, -122.393042967781)
178150	178150	36730	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	8 South Park	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/26/1998 12:00:00 AM	2		Permit Number 39511	6014600.478619999	2112868.92208	37.7823559874826	-122.393138870561	(37.7823559874826, -122.393138870561)
13359	13359	99591	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1855X Evans Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/27/2012 12:00:00 AM	10	3x3	Permit Number 769738	6014314.47679	2099474.93569	37.745563139741996	-122.39319079741301	(37.745563139742, -122.393190797413)
15042	15042	94225	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	625 03rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/22/2010 12:00:00 AM	3	3x3	Permit Number 53569	6014481.04423	2111852.0491299997	37.7795572495918	-122.393480876451	(37.7795572495918, -122.393480876451)
27624	27624	94226	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	625 03rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/22/2010 12:00:00 AM	2	3x3	Permit Number 53569	6014463.046680001	2111873.47872	37.779615090399204	-122.393544638372	(37.7796150903992, -122.393544638372)

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");