Street_Tree_List

Data source: data.sfgov.org

314 rows where qSpecies = 86 sorted by Location 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: qSiteInfo, PlantType, qCaretaker, PlantDate, PlotSize, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location ▲
25404	25404	119731	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
30532	30532	119696	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	14	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
61692	61692	119780	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	15	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
79566	79566	119689	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
80683	80683	119723	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
83899	83899	119728	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
84867	84867	119767	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
85011	85011	119690	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
86483	86483	119684	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
86543	86543	119734	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	14	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
87621	87621	119685	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
87630	87630	119692	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	10	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
88222	88222	119683	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
89139	89139	119727	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
90805	90805	119770	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
92703	92703	119766	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
92884	92884	119733	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	13	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
96316	96316	119697	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	15	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
97979	97979	119772	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
99317	99317	119769	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
100173	100173	119722	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
100653	100653	119693	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
101391	101391	119774	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
103536	103536	119694	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	12	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
103992	103992	119729	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
105008	105008	119726	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	6	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
106450	106450	119771	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	6	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
115597	115597	119725	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
117272	117272	119768	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
118707	118707	119686	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
120366	120366	119775	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	10	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
120707	120707	119721	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
120772	120772	119778	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	13	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
120932	120932	119687	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
123390	123390	119724	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
123532	123532	119777	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	12	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
124714	124714	119691	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
126370	126370	119730	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	10	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
129094	129094	119732	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	12	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
138816	138816	119735	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	104x Octavia St	15	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
139912	139912	119688	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	6	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
140489	140489	119773	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
141892	141892	119779	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	14	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
142187	142187	119776	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	204x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
142339	142339	119695	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	4x Octavia St	13	Median : Cutout 11	Tree 1	DPW 2						2109391.0	6005718.0	47.269987373868105	-138.2836696503	(47.2699873738681, -138.2836696503)
86843	86843	109377	Property Tree 7	Populus nigra 'Italica' :: Lombardy Poplar 86	111 BAY ST	4	Back Yard : Yard 13	Tree 1	Private 1						6010193.2	2121519.2	37.8058617340589	-122.40899671325899	(37.8058617340589, -122.408996713259)
96460	96460	109375	Property Tree 7	Populus nigra 'Italica' :: Lombardy Poplar 86	111 BAY ST	2	Back Yard : Yard 13	Tree 1	Private 1						6010193.2	2121519.2	37.8058617340589	-122.40899671325899	(37.8058617340589, -122.408996713259)
112237	112237	109378	Property Tree 7	Populus nigra 'Italica' :: Lombardy Poplar 86	111 BAY ST	5	Back Yard : Yard 13	Tree 1	Private 1						6010193.2	2121519.2	37.8058617340589	-122.40899671325899	(37.8058617340589, -122.408996713259)
118325	118325	109374	Property Tree 7	Populus nigra 'Italica' :: Lombardy Poplar 86	111 BAY ST	1	Back Yard : Yard 13	Tree 1	Private 1						6010193.2	2121519.2	37.8058617340589	-122.40899671325899	(37.8058617340589, -122.408996713259)
127758	127758	109376	Property Tree 7	Populus nigra 'Italica' :: Lombardy Poplar 86	111 BAY ST	3	Back Yard : Yard 13	Tree 1	Private 1						6010193.2	2121519.2	37.8058617340589	-122.40899671325899	(37.8058617340589, -122.408996713259)
154711	154711	249797	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	199 Chestnut St	5	Front Yard : Yard 7	Tree 1	Private 1			13	Width 0ft		6010839.41961	2121064.72571	37.804650038031795	-122.40672831108499	(37.8046500380318, -122.406728311085)
65833	65833	249798	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	199 Chestnut St	6	Front Yard : Yard 7	Tree 1	Private 1			14	Width 0ft		6010832.73906	2121063.1197	37.8046452545423	-122.406751316639	(37.8046452545423, -122.406751316639)
33120	33120	249800	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	199 Chestnut St	8	Front Yard : Yard 7	Tree 1	Private 1			16	Width 0ft		6010811.58408	2121055.18857	37.8046222939481	-122.406823966551	(37.8046222939481, -122.406823966551)
127197	127197	249899	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1497 Montgomery St	3	Side Yard : Yard 17	Tree 1	Private 1			17	Width 0ft		6011381.09793	2120471.14228	37.8030504957345	-122.404811954701	(37.8030504957345, -122.404811954701)
171284	171284	249897	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1497 Montgomery St	5	Side Yard : Yard 17	Tree 1	Private 1			20	Width 0ft		6011384.61876	2120458.08201	37.8030148322229	-122.40479885070101	(37.8030148322229, -122.404798850701)
33977	33977	249894	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	230 Greenwich St	30	Back Yard : Yard 13	Tree 1	Private 1			24	Width 0ft		6011403.76038	2120447.63681	37.802987222140395	-122.40473187458599	(37.8029872221404, -122.404731874586)
61728	61728	249895	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	230 Greenwich St	31	Back Yard : Yard 13	Tree 1	Private 1			18	Width 0ft		6011395.76102	2120447.38073	37.8029860719045	-122.404759538639	(37.8029860719045, -122.404759538639)
185525	185525	249893	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	230 Greenwich St	29	Back Yard : Yard 13	Tree 1	Private 1			13	Width 0ft		6011394.800530001	2120441.53452	37.8029699659579	-122.404762450627	(37.8029699659579, -122.404762450627)
74522	74522	249896	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	230 Greenwich St	32	Back Yard : Yard 13	Tree 1	Private 1			24	Width 0ft		6011386.30387	2120437.51769	37.8029584618196	-122.404791570676	(37.8029584618196, -122.404791570676)
101181	101181	117473	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1201x MONTGOMERY ST	1	Unaccepted Street : Cutout 20	Tree 1	Private 1						6011733.0	2119731.0	37.8010379082809	-122.403542078239	(37.8010379082809, -122.403542078239)
101847	101847	117472	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1201x MONTGOMERY ST	2	Unaccepted Street : Cutout 20	Tree 1	Private 1						6011733.0	2119731.0	37.8010379082809	-122.403542078239	(37.8010379082809, -122.403542078239)
77831	77831	117475	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1200x MONTGOMERY ST	2	Unaccepted Street : Cutout 20	Tree 1	Private 1						6011580.0	2119440.0	37.800230345698	-122.404051036068	(37.800230345698, -122.404051036068)
81560	81560	117474	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1200x MONTGOMERY ST	1	Unaccepted Street : Cutout 20	Tree 1	Private 1						6011580.0	2119440.0	37.800230345698	-122.404051036068	(37.800230345698, -122.404051036068)
91724	91724	103067	Permitted Site 1	Populus nigra 'Italica' :: Lombardy Poplar 86	255 Broadway	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/11/2014 12:00:00 AM	3	6x6	Permit Number 769997	6012256.1	2118721.6	37.7982955442476	-122.401660929382	(37.7982955442476, -122.401660929382)
176864	176864	135666	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	3001 Divisadero St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			42	Width 9ft		6000472.49775	2118651.8946700003	37.797439556256705	-122.442430617479	(37.7974395562567, -122.442430617479)
51312	51312	96980	Permitted Site 1	Populus nigra 'Italica' :: Lombardy Poplar 86	2090@Buchanan Vallejo St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 25529	6003561.0	2117963.0	37.7957235834131	-122.43169438827101	(37.7957235834131, -122.431694388271)
87484	87484	96979	Permitted Site 1	Populus nigra 'Italica' :: Lombardy Poplar 86	2090@Buchanan Vallejo St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 25529	6003561.0	2117963.0	37.7957235834131	-122.43169438827101	(37.7957235834131, -122.431694388271)
106073	106073	96984	Permitted Site 1	Populus nigra 'Italica' :: Lombardy Poplar 86	2090@Buchanan Vallejo St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 25529	6003561.0	2117963.0	37.7957235834131	-122.43169438827101	(37.7957235834131, -122.431694388271)
139286	139286	96978	Permitted Site 1	Populus nigra 'Italica' :: Lombardy Poplar 86	2090@Buchanan Vallejo St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 25529	6003561.0	2117963.0	37.7957235834131	-122.43169438827101	(37.7957235834131, -122.431694388271)
141279	141279	96981	Permitted Site 1	Populus nigra 'Italica' :: Lombardy Poplar 86	2090@Buchanan Vallejo St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 25529	6003561.0	2117963.0	37.7957235834131	-122.43169438827101	(37.7957235834131, -122.431694388271)
85674	85674	113134	Significant Tree 6	Populus nigra 'Italica' :: Lombardy Poplar 86	50 03rd St	2	Front Yard : Yard 7	Tree 1	Private 1		09/09/2015 12:00:00 AM		10x10	Permit Number 775860	6011822.9	2114512.2	37.7867133521926	-122.402863731968	(37.7867133521926, -122.402863731968)
140337	140337	113133	Significant Tree 6	Populus nigra 'Italica' :: Lombardy Poplar 86	50 03rd St	1	Front Yard : Yard 7	Tree 1	Private 1		09/09/2015 12:00:00 AM		10x10	Permit Number 775860	6011822.9	2114512.2	37.7867133521926	-122.402863731968	(37.7867133521926, -122.402863731968)
134366	134366	135663	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	3790 California St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 3ft		5996346.46825	2114626.15487	37.78614992323771	-122.456416418905	(37.7861499232377, -122.456416418905)
161540	161540	135664	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	3790 California St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 3ft		5996336.60886	2114624.27331	37.786144190959504	-122.45645039347099	(37.7861441909595, -122.456450393471)
29497	29497	135665	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	3790 California St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 3ft		5996326.409519999	2114621.95963	37.7861372526689	-122.45648551290199	(37.7861372526689, -122.456485512902)
164715	164715	139060	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1455 Lyon St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			39	Width 0ft		5999670.4186	2113895.7324	37.7843346353185	-122.444863945857	(37.7843346353185, -122.444863945857)
95683	95683	91056	Permitted Site 1	Populus nigra 'Italica' :: Lombardy Poplar 86	750 FOLSOM ST	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				6x4		6012569.0	2113092.0	37.7828554456154	-122.400182606689	(37.7828554456154, -122.400182606689)
110210	110210	91057	Permitted Site 1	Populus nigra 'Italica' :: Lombardy Poplar 86	750 FOLSOM ST	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			25	6x4		6012569.0	2113092.0	37.7828554456154	-122.400182606689	(37.7828554456154, -122.400182606689)
177775	177775	53540	Permitted Site 1	Populus nigra 'Italica' :: Lombardy Poplar 86	308 04th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/05/1969 12:00:00 AM	24		Permit Number 6452	5994656.440219999	2113376.70713	37.782622110333904	-122.462172779062	(37.7826221103339, -122.462172779062)
23464	23464	121867	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	382 18th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5990303.78145	2112825.7530799997	37.7808577673116	-122.477190674715	(37.7808577673116, -122.477190674715)
175227	175227	140083	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	108 Saint Joseph's Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	Width 0ft		6000722.7998	2112497.1022	37.7805543580623	-122.441122705034	(37.7805543580623, -122.441122705034)
169265	169265	140081	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	104 Saint Joseph's Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6000726.183999999	2112472.3974	37.7804867177527	-122.441109224562	(37.7804867177527, -122.441109224562)
46771	46771	140080	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	102 Saint Joseph's Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6000726.8608	2112462.5832	37.7804598090154	-122.441106178881	(37.7804598090154, -122.441106178881)
26304	26304	140079	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	100 Saint Joseph's Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6000729.2298	2112451.4153	37.780429279749605	-122.44109718195499	(37.7804292797496, -122.441097181955)
18395	18395	6096	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	106X Saint Joseph's Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6000733.8426241	2112435.5369559	37.780385944611204	-122.44108008458001	(37.7803859446112, -122.44108008458)
78042	78042	6095	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	106X Saint Joseph's Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/19/2015 12:00:00 AM	12	3X3		6000733.8426241	2112435.5369559	37.780385944611204	-122.44108008458001	(37.7803859446112, -122.44108008458)
108312	108312	6094	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	106X Saint Joseph's Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			20	3X3		6000733.8426241	2112435.5369559	37.780385944611204	-122.44108008458001	(37.7803859446112, -122.44108008458)
112632	112632	6098	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	106X Saint Joseph's Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3X3		6000733.8426241	2112435.5369559	37.780385944611204	-122.44108008458001	(37.7803859446112, -122.44108008458)
52998	52998	195998	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18			6016075.490669999	2110714.30849	37.776521728336604	-122.387885542896	(37.7765217283366, -122.387885542896)
69678	69678	195997	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23			6016094.12732	2110713.51522	37.776520582607	-122.387821017432	(37.776520582607, -122.387821017432)
166489	166489	195999	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16			6016051.5903	2110711.60548	37.7765129824099	-122.387968033214	(37.7765129824099, -122.387968033214)
46532	46532	196000	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17			6016029.9014099995	2110710.35403	37.776508344609496	-122.38804297461999	(37.7765083446095, -122.38804297462)
177942	177942	196001	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4			6016008.12939	2110708.52586	37.776502118610395	-122.38811816333401	(37.7765021186104, -122.388118163334)
47853	47853	196002	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18			6015985.51722	2110706.0962799997	37.7764941946745	-122.38819621639799	(37.7764941946745, -122.388196216398)
41087	41087	196003	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16			6015962.95079	2110705.93329	37.776492496775106	-122.388274269443	(37.7764924967751, -122.388274269443)
161996	161996	196004	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16			6015940.35109	2110704.12187	37.776486270757204	-122.388352322497	(37.7764862707572, -122.388352322497)
60534	60534	196005	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15			6015919.22066	2110703.31156	37.7764828749315	-122.38842536276	(37.7764828749315, -122.38842536276)
168920	168920	196006	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14			6015895.59891	2110702.13918	37.7764783468376	-122.388506996001	(37.7764783468376, -122.388506996001)
31815	31815	196007	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15			6015874.48096	2110701.94702	37.7764766489106	-122.388580036236	(37.7764766489106, -122.388580036236)
181735	181735	196008	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	212 Terry A Francois Blvd	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15			6015854.1615699995	2110700.296	37.7764709894889	-122.388650212137	(37.7764709894889, -122.388650212137)

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