Street_Tree_List

Data source: data.sfgov.org

197 rows where qCaretaker = 1 and qSpecies = 90 sorted by Longitude

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, SiteOrder, qSiteInfo, qCareAssistant, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude ▼	Location
55712	55712	109258	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1290 45th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/05/2015 12:00:00 AM	3	3x3	Permit Number 773444	5982171.0	2106334.4	37.762559192748604	-122.504844313965	(37.7625591927486, -122.504844313965)
22960	22960	109286	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1438 43rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/05/2015 12:00:00 AM	3	3x3	Permit Number 771727	5982826.9	2105321.3	37.75981607235	-122.502500845014	(37.75981607235, -122.502500845014)
117889	117889	109142	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	342 29th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/29/2015 12:00:00 AM	3	3x3	Permit Number 773572	5986886.5	2113633.7	37.782877302208796	-122.489071978745	(37.7828773022088, -122.489071978745)
143631	143631	88363	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2294 31st Ave		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/10/2009 12:00:00 AM		3x3	Permit Number 52532	5986746.4	2099664.8	37.7445143908471	-122.48852965844999	(37.7445143908471, -122.48852965845)
104974	104974	95423	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2187 21st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/01/2011 12:00:00 AM		3x3	Permit Number 767291	5989736.1	2100494.0	37.7469651560486	-122.478252612879	(37.7469651560486, -122.478252612879)
86924	86924	108507	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	796 19th Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/23/2014 12:00:00 AM	3	3x3	Permit Number 773790	5990094.5666	2109953.25495	37.772958540137	-122.477704410848	(37.772958540137, -122.477704410848)
145512	145512	72375	Private 5	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	4299X Fulton St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/09/1996 12:00:00 AM		3x3	Permit Number 773790	5990099.63678033	2109979.56687008	37.773031079694	-122.47768879633699	(37.773031079694, -122.477688796337)
99170	99170	100432	Significant Tree 6	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	200X Stonecrest Dr	2	Front Yard : Yard 7	Tree 1	Private 1						5990724.7	2093134.9	37.7268162840874	-122.47429724264	(37.7268162840874, -122.47429724264)
114083	114083	100431	Significant Tree 6	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	200X Stonecrest Dr	1	Front Yard : Yard 7	Tree 1	Private 1						5990724.7	2093134.9	37.7268162840874	-122.47429724264	(37.7268162840874, -122.47429724264)
97987	97987	117395	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	544 Wawona St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/08/2016 12:00:00 AM	3		Permit Number 778554	5991215.4	2097083.4	37.737686285904296	-122.47288871789	(37.7376862859043, -122.47288871789)
143424	143424	114091	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1717 15th Ave		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/01/2015 12:00:00 AM			Permit Number 775992	5991423.2	2103752.9	37.7560110367904	-122.472656396727	(37.7560110367904, -122.472656396727)
85638	85638	92584	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	445 Wawona St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/24/2009 12:00:00 AM		3x3	Permit Number 52914	5991625.0	2097033.0	37.737571604455205	-122.471468876287	(37.7375716044552, -122.471468876287)
88751	88751	92582	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	445 Wawona St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/24/2009 12:00:00 AM		3x3	Permit Number 52914	5991625.0	2097033.0	37.737571604455205	-122.471468876287	(37.7375716044552, -122.471468876287)
90783	90783	92589	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	445 Wawona St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/24/2009 12:00:00 AM		3x3	Permit Number 52914	5991625.0	2097033.0	37.737571604455205	-122.471468876287	(37.7375716044552, -122.471468876287)
105427	105427	86795	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	445 Wawona St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/24/2009 12:00:00 AM		3x3	Permit Number 52914	5991625.0	2097033.0	37.737571604455205	-122.471468876287	(37.7375716044552, -122.471468876287)
106942	106942	92587	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	445 Wawona St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/24/2009 12:00:00 AM		3x3	Permit Number 52914	5991625.0	2097033.0	37.737571604455205	-122.471468876287	(37.7375716044552, -122.471468876287)
110607	110607	92586	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	445 Wawona St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/24/2009 12:00:00 AM		3x3	Permit Number 52914	5991625.0	2097033.0	37.737571604455205	-122.471468876287	(37.7375716044552, -122.471468876287)
111694	111694	92580	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	445 Wawona St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/24/2009 12:00:00 AM		3x3	Permit Number 52914	5991625.0	2097033.0	37.737571604455205	-122.471468876287	(37.7375716044552, -122.471468876287)
117359	117359	92585	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	445 Wawona St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/24/2009 12:00:00 AM		3x3	Permit Number 52914	5991625.0	2097033.0	37.737571604455205	-122.471468876287	(37.7375716044552, -122.471468876287)
120705	120705	92583	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	445 Wawona St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/24/2009 12:00:00 AM		3x3	Permit Number 52914	5991625.0	2097033.0	37.737571604455205	-122.471468876287	(37.7375716044552, -122.471468876287)
123606	123606	92588	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	445 Wawona St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/24/2009 12:00:00 AM		3x3	Permit Number 52914	5991625.0	2097033.0	37.737571604455205	-122.471468876287	(37.7375716044552, -122.471468876287)
142121	142121	86796	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	445 Wawona St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/24/2009 12:00:00 AM		3x3	Permit Number 52914	5991625.0	2097033.0	37.737571604455205	-122.471468876287	(37.7375716044552, -122.471468876287)
146017	146017	92581	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	445 Wawona St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/24/2009 12:00:00 AM		3x3	Permit Number 52914	5991625.0	2097033.0	37.737571604455205	-122.471468876287	(37.7375716044552, -122.471468876287)
127564	127564	16583	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	810X Lake St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/26/2008 12:00:00 AM	2	3X3		5992991.92524	2114858.80829	37.7865955752076	-122.46803907898199	(37.7865955752076, -122.468039078982)
144520	144520	52671	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1234@ LINCOLN 08th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/10/2010 12:00:00 AM		3x3	Permit Number 53911	5993637.83557736	2107090.14039952	37.7653021756316	-122.46523990796699	(37.7653021756316, -122.465239907967)
117526	117526	117298	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1590 08th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/06/2016 12:00:00 AM	3		Permit Number 778522	5993741.6	2104678.7	37.7586869726954	-122.46470588880699	(37.7586869726954, -122.464705888807)
94068	94068	112744	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	235 Bright St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/18/2015 12:00:00 AM			Permit Number 774127	5993719.1	2088769.4	37.7150026970857	-122.463629063261	(37.7150026970857, -122.463629063261)
125075	125075	53133	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	925 Holloway Ave	1	Sidewalk: Property side : Cutout 5	Tree 1	Private 1	FUF 1	08/19/2015 12:00:00 AM			Permit Number 774158	5994000.81776041	2091173.40830125	37.7216197566197	-122.46282963525199	(37.7216197566197, -122.462829635252)
97369	97369	51994	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3858 Jackson St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/21/1977 12:00:00 AM			Permit Number 769135	5995734.40748516	2115851.40858603	37.78947898308	-122.458622703992	(37.78947898308, -122.458622703992)
78106	78106	102590	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1205 Plymouth Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 47971	5995820.0	2092088.8	37.724237816628	-122.4566074133	(37.724237816628, -122.4566074133)
18622	18622	51694	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1205 Plymouth Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2005 12:00:00 AM			Permit Number 47971	5995825.9822194	2092036.11859211	37.7240935095077	-122.456582925823	(37.7240935095077, -122.456582925823)
2200	2200	252931	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	71 Edgar Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5997064.0	2091155.0	37.7217451669512	-122.45223976154499	(37.7217451669512, -122.452239761545)
89625	89625	108873	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	137 Cole St		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/08/2015 12:00:00 AM	3	3x3	Permit Number 773403	5997771.922180001	2110131.23662	37.7738897825389	-122.45116047571699	(37.7738897825389, -122.451160475717)
2563	2563	124911	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3234 Pacific Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/19/2017 12:00:00 AM	3	Width 4ft	Permit Number 780160	5998736.95045	2116593.12953	37.7916876606053	-122.448287711302	(37.7916876606053, -122.448287711302)
2562	2562	124910	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3234 Pacific Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/19/2017 12:00:00 AM	3	Width 4ft	Permit Number 780160	5998760.117380001	2116596.00833	37.79169688945171	-122.4482077616	(37.7916968894517, -122.4482077616)
89374	89374	88771	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	461 Baker St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/03/2015 12:00:00 AM	3	3x3	Permit Number 775199	6000624.0	2110522.0	37.7751256013752	-122.441322740074	(37.7751256013752, -122.441322740074)
86147	86147	55564	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1X CASELLI AVE	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/12/2008 12:00:00 AM		3x3	Permit Number 50796	6000842.0	2104917.0	37.7597480805722	-122.44016661153098	(37.7597480805722, -122.440166611531)
102655	102655	87857	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1X CASELLI AVE	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/12/2008 12:00:00 AM		3x3	Permit Number 50796	6000842.0	2104917.0	37.7597480805722	-122.44016661153098	(37.7597480805722, -122.440166611531)
143565	143565	55516	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	299 Douglass St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/28/2014 12:00:00 AM			Permit Number 772528	6001150.72264648	2104659.12373936	37.759057586626206	-122.439080412698	(37.7590575866262, -122.439080412698)
142452	142452	72994	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	590 Clipper St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/06/2011 12:00:00 AM		3x3	Permit Number 768023	6001377.74978743	2100887.76679336	37.748715263692006	-122.438025102274	(37.748715263692, -122.438025102274)
49354	49354	131010	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3099 Steiner St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6001935.38679	2118702.3343700003	37.797661323668606	-122.437372261923	(37.7976613236686, -122.437372261923)
59156	59156	87882	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1771 North Point St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/13/2008 12:00:00 AM	6	3x3	Permit Number 50853	6002283.00879	2120864.7759700003	37.8036185768076	-122.436324238766	(37.8036185768076, -122.436324238766)
60367	60367	131011	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1771 North Point St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6002300.20603	2120865.81933	37.8036224187107	-122.436264801676	(37.8036224187107, -122.436264801676)
106814	106814	95387	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	949 Diamond St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/24/2011 12:00:00 AM		3x3	Permit Number 767255	6001944.0	2101334.0	37.7499727001327	-122.436098944037	(37.7499727001327, -122.436098944037)
88356	88356	95388	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	4290 25th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/24/2011 12:00:00 AM		3x3	Permit Number 767255	6001987.9	2101228.0	37.7496841432906	-122.43593955208	(37.7496841432906, -122.43593955208)
98839	98839	115435	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	563 Lisbon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/01/2016 12:00:00 AM	3		Permit Number 777504	6001919.8	2090201.1	37.7194029477524	-122.43538635551901	(37.7194029477524, -122.435386355519)
99829	99829	95738	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	445 Edinburg St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/07/2011 12:00:00 AM		3x3	Permit Number 767484	6003120.3	2091142.7	37.7220564786865	-122.431303852024	(37.7220564786865, -122.431303852024)
116290	116290	88687	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	135 Hancock St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/06/2008 12:00:00 AM			Permit Number 51638	6003417.0	2105051.0	37.7602622759886	-122.43127052793899	(37.7602622759886, -122.431270527939)
44178	44178	91424	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2112 15th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/26/2008 12:00:00 AM		3x3	Permit Number 52102	6003571.0	2107157.0	37.7660535712373	-122.430888215554	(37.7660535712373, -122.430888215554)
91361	91361	91421	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2112 15th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/26/2008 12:00:00 AM		3x3	Permit Number 52102; tree 1 on Sanchez (DPW-maintained); maintenance agreement through 4/8/2012	6003571.0	2107157.0	37.7660535712373	-122.430888215554	(37.7660535712373, -122.430888215554)
120630	120630	91426	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2112 15th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/26/2008 12:00:00 AM		3x3	Permit Number 52102	6003571.0	2107157.0	37.7660535712373	-122.430888215554	(37.7660535712373, -122.430888215554)
121595	121595	91423	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2112 15th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/26/2008 12:00:00 AM		3x3	Permit Number 52102	6003571.0	2107157.0	37.7660535712373	-122.430888215554	(37.7660535712373, -122.430888215554)
127472	127472	91422	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2112 15th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/26/2008 12:00:00 AM		3x3	Permit Number 52102; Tree 2 on Sanchez (DPW-maintained); maintenance agreement through 4/8/2012	6003571.0	2107157.0	37.7660535712373	-122.430888215554	(37.7660535712373, -122.430888215554)
142736	142736	91425	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2112 15th St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/26/2008 12:00:00 AM		3x3	Permit Number 52102	6003571.0	2107157.0	37.7660535712373	-122.430888215554	(37.7660535712373, -122.430888215554)
172742	172742	177452	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	404 Naples St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6003440.2849	2091219.73942	37.7222861409715	-122.430203237092	(37.7222861409715, -122.430203237092)
91750	91750	94689	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	218 Roanoke St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/22/2010 12:00:00 AM		3x3	Permit Number 53815	6003547.0	2096007.0	37.73543692838779	-122.43017570506201	(37.7354369283878, -122.430175705062)
142073	142073	108791	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	323 Edinburgh St		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/2015 12:00:00 AM	3	3x3	Permit Number 774649	6003546.88289	2091819.58764	37.7239392283561	-122.429877518865	(37.7239392283561, -122.429877518865)
79853	79853	96159	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2 Milton St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/08/2011 12:00:00 AM		3x3	Permit Number 767792	6003680.0	2095311.9	37.7335358734479	-122.429666314328	(37.7335358734479, -122.429666314328)
105916	105916	96160	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2 Milton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/08/2011 12:00:00 AM		3x3	Permit Number 767792	6003680.0	2095311.9	37.7335358734479	-122.429666314328	(37.7335358734479, -122.429666314328)
98990	98990	96158	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1 Milton St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/08/2011 12:00:00 AM		3x3	Permit Number 767791	6003728.0	2095595.0	37.7343159198258	-122.429520547314	(37.7343159198258, -122.429520547314)
95910	95910	95566	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	168 Jersey St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/08/2014 12:00:00 AM		3x3	Permit Number 772810	6004034.0	2101610.0	37.75084904875379	-122.4288912915	(37.7508490487538, -122.4288912915)
24021	24021	177451	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	836 Brazil Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 2ft		6004096.8384300005	2090858.43848	37.7213312534072	-122.427907954105	(37.7213312534072, -122.427907954105)
127668	127668	87026	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	863 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/07/2007 12:00:00 AM		3x3	Permit Number 49970	6004379.0	2103877.0	37.757093220538394	-122.427859766577	(37.7570932205384, -122.427859766577)
89333	89333	104727	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1079 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	DPW 4			3x3	Permit Number 770313	6004450.0	2102615.0	37.7536320814231	-122.427524315639	(37.7536320814231, -122.427524315639)
102059	102059	108761	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1350 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/05/2015 12:00:00 AM	3	3x3	Permit Number 774645	6004491.73804	2101024.57628	37.749267509186204	-122.427266693799	(37.7492675091862, -122.427266693799)
104089	104089	108760	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1350 Church St		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1			3x3		6004491.73804	2101024.57628	37.749267509186204	-122.427266693799	(37.7492675091862, -122.427266693799)
90759	90759	108834	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	163 Ney St		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/2015 12:00:00 AM	3	3x3	Permit Number 774662	6004445.49273	2094062.1156099997	37.73014756094079	-122.42693080570601	(37.7301475609408, -122.426930805706)
156278	156278	230376	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	126 Dolores St	1	: 4	Tree 1	Private 1			4	Width 3ft		6004756.55794	2107626.00234	37.7674084411732	-122.426821010098	(37.7674084411732, -122.426821010098)
120504	120504	17177	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1601 Octavia St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/14/2007 12:00:00 AM	3	4X4		6004921.1693652	2114736.5058391998	37.7869414485048	-122.426758067349	(37.7869414485048, -122.426758067349)
1590	1590	5343	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	180 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/24/2014 02:20:00 PM	3	3X3		6004776.7961099995	2107352.0132	37.7666572770255	-122.426731495165	(37.7666572770255, -122.426731495165)
21837	21837	5348	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	200X Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/22/2010 12:00:00 AM	12	3x3	Permit Number 53640	6004789.9063099995	2107160.01438	37.7661308355062	-122.426672475382	(37.7661308355062, -122.426672475382)
102892	102892	13103	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1516 Lombard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/11/2008 12:00:00 AM	3	3x3		6005111.0	2119918.0	37.801179250916796	-122.426470375667	(37.8011792509168, -122.426470375667)
84744	84744	88349	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	100 Vienna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/10/2008 12:00:00 AM		3x3	Permit Number 51332	6004690.8	2092754.8	37.7265718296959	-122.425989720183	(37.7265718296959, -122.425989720183)
90378	90378	88350	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	100 Vienna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/10/2008 12:00:00 AM		3x3	Permit Number 51332	6004690.8	2092754.8	37.7265718296959	-122.425989720183	(37.7265718296959, -122.425989720183)
9244	9244	87452	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	601 Dolores St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/28/2008 12:00:00 AM	4	3x3		6004976.0	2104871.0	37.7598562652774	-122.425865863079	(37.7598562652774, -122.425865863079)
178549	178549	230385	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	581 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 9ft		6004995.95318	2104998.86424	37.760208477866	-122.42580595608601	(37.760208477866, -122.425805956086)
19158	19158	5458	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	589 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/20/2009 12:00:00 AM	90	3x3		6004996.57492	2104960.58209	37.7601033992601	-122.42580108085801	(37.7601033992601, -122.425801080858)
134507	134507	230384	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	601 Dolores St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 4ft		6005003.814780001	2104818.83763	37.7597146115626	-122.42576595245501	(37.7597146115626, -122.425765952455)
17893	17893	5475	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	601 Dolores St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/30/2008 12:00:00 AM	3	4X4		6005004.3744	2104794.07494	37.759646650682996	-122.425762254445	(37.759646650683, -122.425762254445)
75813	75813	230383	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	655 Dolores St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 6ft		6005020.28561	2104519.96917	37.7588949199761	-122.425687715924	(37.7588949199761, -122.425687715924)
152400	152400	230382	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	655 Dolores St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 6ft		6005021.64655	2104500.02665	37.7588402394163	-122.42568158976002	(37.7588402394163, -122.42568158976)
59682	59682	230381	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	655 Dolores St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 6ft		6005021.944209999	2104476.3564299997	37.7587752633866	-122.425678875606	(37.7587752633866, -122.425678875606)
115779	115779	5577	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1041 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/11/2010 12:00:00 AM	3	3x3		6005148.8764838	2102292.2742932	37.752785456150605	-122.42508448290899	(37.7527854561506, -122.425084482909)
141895	141895	84852	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1266 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/18/2007 12:00:00 AM			Permit No. 49294	6005132.0	2100972.0	37.7491593351889	-122.42504891393499	(37.7491593351889, -122.425048913935)
124075	124075	50261	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	31 Highland Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/14/2002 12:00:00 AM			Permit Number 46967	6005053.32023027	2096760.11488265	37.737590014135	-122.425021354004	(37.737590014135, -122.425021354004)
113204	113204	114762	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	27X Highland Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/07/2015 12:00:00 AM			Permit Number 46967	6005096.96871	2096699.6024099998	37.7374263260205	-122.424866136467	(37.7374263260205, -122.424866136467)
98395	98395	108709	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	280 Fair Oaks St		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/02/2015 12:00:00 AM	3	3x3	Permit Number 773390	6005432.93594	2102084.07132	37.752229821306706	-122.42408734733101	(37.7522298213067, -122.424087347331)
44789	44789	230394	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	280 Fair Oaks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6005433.48505	2102088.4512099996	37.752241878473896	-122.42408575987	(37.7522418784739, -122.42408575987)
173263	173263	230390	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3431 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6005492.40988	2103117.15388	37.7550697840629	-122.423955133335	(37.7550697840629, -122.423955133335)
178042	178042	230375	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	70 Pearl St	1	: 4	Tree 1	Private 1			9	Width 4ft		6005616.00843	2108643.7620099997	37.770251521926	-122.423920665902	(37.770251521926, -122.423920665902)
117348	117348	95786	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3431 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/19/2011 12:00:00 AM		3x3	Permit Number 767530	6005503.0	2103116.0	37.7550672136514	-122.42391842755801	(37.7550672136514, -122.423918427558)
53871	53871	230391	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3425 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6005521.318	2103117.66656	37.755072823769204	-122.423855197061	(37.7550728237692, -122.423855197061)
136828	136828	230393	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3420 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6005567.360669999	2103163.57677	37.7552014816894	-122.423699232135	(37.7552014816894, -122.423699232135)
45445	45445	230392	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3416 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6005586.33797	2103162.25218	37.7551989159029	-122.423633508794	(37.7551989159029, -122.423633508794)
85097	85097	109530	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	76 Alvarado St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/20/2015 12:00:00 AM	3	3x3	Permit Number 775000	6005863.7	2102913.1	37.7545304541232	-122.42265660342301	(37.7545304541232, -122.422656603423)
51642	51642	230377	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	11 Haight St	2	: 4	Tree 1	Private 1			6	Width 4ft		6006012.138780001	2109648.33208	37.7730321861234	-122.42262184792101	(37.7730321861234, -122.422621847921)
132375	132375	230378	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	11 Haight St	3	: 4	Tree 1	Private 1			5	Width 4ft		6006027.69558	2109650.1201	37.7730379732539	-122.422568162015	(37.7730379732539, -122.422568162015)
117808	117808	98719	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1500 Broadway	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/30/2012 12:00:00 AM			Permit Number 768751	6006413.8	2117997.6	37.795979878671	-122.421825625767	(37.795979878671, -122.421825625767)
120237	120237	98720	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1500 Broadway	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/30/2012 12:00:00 AM		4x4	Permit Number 768751	6006413.8	2117997.6	37.795979878671	-122.421825625767	(37.795979878671, -122.421825625767)
86562	86562	103851	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1524 Polk St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/21/2013 12:00:00 AM	3	3x3		6006765.8	2116184.9	37.7910225007002	-122.420478902042	(37.7910225007002, -122.420478902042)

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