Street_Tree_List

Data source: data.sfgov.org

314 rows where qSpecies = 86 sorted by DBH

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, 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)
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)
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)
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)
78277	78277	98312	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	160 Stanford Heights Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5998064.7	2096544.4	37.7366004632858	-122.449168689734	(37.7366004632858, -122.449168689734)
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)
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)
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)
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)
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)
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)
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)
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)
89334	89334	116094	Significant Tree 6	Populus nigra 'Italica' :: Lombardy Poplar 86	300x EXECUTIVE PARK BLVD	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6014482.0	2086919.0	37.7110963749119	-122.39173377323799	(37.7110963749119, -122.391733773238)
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)
92450	92450	116095	Significant Tree 6	Populus nigra 'Italica' :: Lombardy Poplar 86	300x EXECUTIVE PARK BLVD	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6014482.0	2086919.0	37.7110963749119	-122.39173377323799	(37.7110963749119, -122.391733773238)
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)
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)
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)
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)
97405	97405	85294	Permitted Site 1	Populus nigra 'Italica' :: Lombardy Poplar 86	2255 Mariposa St		Sidewalk: Property side : Cutout 5	Landscaping 2	Private 1		07/27/2007 12:00:00 AM		2x50	Permit Number 49675	6010752.0	2105977.0	37.7632178155038	-122.40596731591499	(37.7632178155038, -122.405967315915)
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)
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)
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)
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)
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)
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)
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)
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)
114742	114742	116093	Significant Tree 6	Populus nigra 'Italica' :: Lombardy Poplar 86	300x EXECUTIVE PARK BLVD	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6014482.0	2086919.0	37.7110963749119	-122.39173377323799	(37.7110963749119, -122.391733773238)
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)
118020	118020	116097	Significant Tree 6	Populus nigra 'Italica' :: Lombardy Poplar 86	300x EXECUTIVE PARK BLVD	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6014482.0	2086919.0	37.7110963749119	-122.39173377323799	(37.7110963749119, -122.391733773238)
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)
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)
119705	119705	116096	Significant Tree 6	Populus nigra 'Italica' :: Lombardy Poplar 86	300x EXECUTIVE PARK BLVD	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6014482.0	2086919.0	37.7110963749119	-122.39173377323799	(37.7110963749119, -122.391733773238)
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)
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)
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)
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)
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)
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)
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)
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)
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)
144536	144536	116092	Significant Tree 6	Populus nigra 'Italica' :: Lombardy Poplar 86	300x EXECUTIVE PARK BLVD	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6014482.0	2086919.0	37.7110963749119	-122.39173377323799	(37.7110963749119, -122.391733773238)
51068	51068	201994	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1799 Carroll Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2			6013316.6056	2092506.69666	37.7263743142142	-122.396153039251	(37.7263743142142, -122.396153039251)
132662	132662	201996	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1799 Carroll Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2			6013312.67339	2092499.74696	37.7263550129554	-122.396166145968	(37.7263550129554, -122.396166145968)
137250	137250	201997	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1799 Carroll Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2			6013313.68951	2092516.98736	37.7264024081338	-122.39616384100201	(37.7264024081338, -122.396163841002)
157844	157844	201995	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1799 Carroll Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2			6013319.20907	2092521.7003099998	37.726415656052104	-122.396145090149	(37.7264156560521, -122.396145090149)
164241	164241	201993	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	1799 Carroll Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2			6013314.351009999	2092488.44605	37.726324076294205	-122.396159554816	(37.7263240762942, -122.396159554816)
46984	46984	195986	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3			6018468.61509	2099561.7634900003	37.7460314544851	-122.378832298987	(37.7460314544851, -122.378832298987)
61850	61850	195989	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3			6018358.23149	2099573.02507	37.7460562901585	-122.37921477706699	(37.7460562901585, -122.379214777067)
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)
120047	120047	195988	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3			6018362.603680001	2099564.59582	37.7460333862374	-122.379199073078	(37.7460333862374, -122.379199073078)
123249	123249	24282	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	300X Winding Way	20	Median : Cutout 11	Tree 1	DPW 2			3	8		6001646.2933309	2086550.8578367	37.7093646550959	-122.436070699117	(37.7093646550959, -122.436070699117)
29206	29206	195983	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4			6018491.3513	2099573.26629	37.7460642923356	-122.378754477939	(37.7460642923356, -122.378754477939)
65982	65982	244266	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		6005600.5046	2110125.0362	37.7743178686238	-122.42407965066499	(37.7743178686238, -122.424079650665)
69871	69871	195990	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4			6018348.89198	2099575.3229	37.746062084515295	-122.379247231793	(37.7460620845153, -122.379247231793)
175927	175927	234897	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	50 Alemany Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4			6009692.09622	2096449.4371099998	37.7369979030329	-122.408960917621	(37.7369979030329, -122.408960917621)
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)
26910	26910	195984	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6018485.16554	2099556.70792	37.7460184853642	-122.378774718093	(37.7460184853642, -122.378774718093)
33201	33201	195967	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	13	Back Yard : Yard 13	Tree 1	Private 1			5			6015456.783980001	2100328.64296	37.747970635647	-122.389300444473	(37.747970635647, -122.389300444473)
42525	42525	195977	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	23	Back Yard : Yard 13	Tree 1	Private 1			5	Width 4ft		6015256.877230001	2100313.90806	37.7479190918917	-122.389990690329	(37.7479190918917, -122.389990690329)
46340	46340	244263	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005610.4338	2110073.0988	37.7741758216851	-122.424041609468	(37.7741758216851, -122.424041609468)
58148	58148	246560	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	2x Octavia St	4	Median : Yard 3	Tree 1	DPW 2			5	Width 7ft		6005720.56075	2109380.70244	37.772280885298	-122.423611422347	(37.772280885298, -122.423611422347)
90928	90928	244261	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005613.489	2110034.9096	37.7740711358709	-122.424028324662	(37.7740711358709, -122.424028324662)
130066	130066	195985	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6018474.359130001	2099556.32192	37.74601682971289	-122.378812058831	(37.7460168297129, -122.378812058831)
147625	147625	195976	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	22	Back Yard : Yard 13	Tree 1	Private 1			5	Width 4ft		6015275.57642	2100315.1093900003	37.7479234275315	-122.38992611271401	(37.7479234275315, -122.389926112714)
147941	147941	244402	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005599.7408	2110138.7844	37.774355574729796	-122.424083270702	(37.7743555747298, -122.424083270702)
149276	149276	195992	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6018320.61791	2099573.80473	37.7460563567193	-122.379344895446	(37.7460563567193, -122.379344895446)
157234	157234	244262	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	202x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005612.7252	2110055.5318	37.7741277163216	-122.424032433594	(37.7741277163216, -122.424032433594)
177923	177923	195991	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	401 Amador St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6018339.20952	2099575.6179	37.7460623605839	-122.379280733321	(37.7460623605839, -122.379280733321)
28694	28694	246559	DPW Maintained 3	Populus nigra 'Italica' :: Lombardy Poplar 86	2x Octavia St	3	Median : Yard 3	Tree 1	DPW 2			6	Width 7ft		6005723.21879	2109372.62983	37.7722588698898	-122.42360165389299	(37.7722588698898, -122.423601653893)
35883	35883	248126	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	109 Brewster St	6	Front Yard : Yard 7	Tree 1	Private 1			6			6010387.789530001	2099433.6295	37.7452307970734	-122.40676583257401	(37.7452307970734, -122.406765832574)
38334	38334	195966	Undocumented 2	Populus nigra 'Italica' :: Lombardy Poplar 86	200 Tulare St	12	Back Yard : Yard 13	Tree 1	Private 1			6			6015475.98989	2100328.78152	37.7479720808553	-122.389234040342	(37.7479720808553, -122.389234040342)

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