Street_Tree_List

Data source: data.sfgov.org

243 rows where PlotSize = "3x3" and qSpecies = 90 sorted by XCoord

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

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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
106888	106888	93251	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1060 CHURCH ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3		6004371.0	2102721.0	37.753918663927706	-122.42780506745899	(37.7539186639277, -122.427805067459)
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)
18377	18377	93250	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1050 Church St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3		6004388.0	2102776.0	37.754070642695496	-122.42775019598	(37.7540706426955, -122.42775019598)
92614	92614	93258	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1180X Church St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004390.8	2101994.4	37.7519247103798	-122.42768482883699	(37.7519247103798, -122.427684828837)
102730	102730	93257	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1180X Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004390.8	2101994.4	37.7519247103798	-122.42768482883699	(37.7519247103798, -122.427684828837)
83075	83075	93252	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1070 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3		6004394.0	2102659.0	37.753749727529396	-122.427721110855	(37.7537497275294, -122.427721110855)
94013	94013	93253	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1070 Church St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3		6004394.0	2102659.0	37.753749727529396	-122.427721110855	(37.7537497275294, -122.427721110855)
102183	102183	93254	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1070 Church St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3		6004394.0	2102659.0	37.753749727529396	-122.427721110855	(37.7537497275294, -122.427721110855)
114784	114784	93255	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1070 Church St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3		6004394.0	2102659.0	37.753749727529396	-122.427721110855	(37.7537497275294, -122.427721110855)
91448	91448	93260	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1250X Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004401.7	2101569.1	37.750757552311704	-122.427616837084	(37.7507575523117, -122.427616837084)
106002	106002	93256	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1120 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3	Owner Michael Freethy signed agreement on 12/26/09 to maintain curb cut added within 4' of tree after tree was planted	6004410.0	2102371.0	37.7529598520175	-122.427645261537	(37.7529598520175, -122.427645261537)
145306	145306	93295	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1019 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004430.0	2102966.0	37.7545947138847	-122.427618485613	(37.7545947138847, -122.427618485613)
124404	124404	87647	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1989X PINE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/30/2008 12:00:00 AM	3	3x3		6004432.0	2115332.0	37.788548856891296	-122.42849294395701	(37.7885488568913, -122.428492943957)
128139	128139	12447	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1989X Pine St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/18/2004 12:00:00 AM	4	3x3		6004432.626396201	2115327.1853143997	37.7885356724235	-122.428490433403	(37.7885356724235, -122.428490433403)
113846	113846	93294	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1037 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004436.0	2102861.0	37.7543067479004	-122.427590255736	(37.7543067479004, -122.427590255736)
87716	87716	93293	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1049 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004440.0	2102791.0	37.7541147705659	-122.42757143594	(37.7541147705659, -122.42757143594)
114160	114160	93292	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1059 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004443.0	2102732.0	37.7539529400822	-122.42755685810499	(37.7539529400822, -122.427556858105)
84828	84828	93291	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1065 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004445.0	2102697.0	37.753856951407705	-122.42754744828301	(37.7538569514077, -122.427547448283)
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)
139844	139844	93265	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1400X Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004448.1	2100692.1	37.748352138422796	-122.42739391326401	(37.7483521384228, -122.427393913264)
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)
100755	100755	93259	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1234 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004459.0	2101704.0	37.7511311972424	-122.42742829765899	(37.7511311972424, -122.427428297659)
103768	103768	93261	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1252 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004465.0	2101602.0	37.750851468343896	-122.427400283526	(37.7508514683439, -122.427400283526)
144320	144320	93289	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1159 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004476.0	2102138.0	37.752323821507396	-122.427400423827	(37.7523238215074, -122.427400423827)
85944	85944	93266	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1440 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004482.7	2100527.8	37.747902965476	-122.42726256538602	(37.747902965476, -122.427262565386)
124501	124501	93263	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1326 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004490.0	2101167.0	37.749658473374204	-122.42728284799401	(37.7496584733742, -122.427282847994)
126091	126091	93264	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1326 Church St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004490.0	2101167.0	37.749658473374204	-122.42728284799401	(37.7496584733742, -122.427282847994)
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)
90042	90042	93288	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1259 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004494.0	2101568.0	37.7507597523824	-122.42729757712601	(37.7507597523824, -122.427297577126)
113436	113436	93287	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1279 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004501.0	2101449.0	37.750433401942104	-122.427264894728	(37.7504334019421, -122.427264894728)
81232	81232	93286	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1283 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004502.0	2101425.0	37.7503675600759	-122.427259727267	(37.7503675600759, -122.427259727267)
113657	113657	93285	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1289 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004504.0	2101389.0	37.7502688255514	-122.427250247058	(37.7502688255514, -122.427250247058)
110579	110579	93290	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1071 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004519.0	2102665.5	37.7537746450798	-122.427289295317	(37.7537746450798, -122.427289295317)
97539	97539	93284	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1347 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004523.0	2101050.0	37.7493390847523	-122.427160399995	(37.7493390847523, -122.427160399995)
110080	110080	93283	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1377 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004533.0	2100877.0	37.7488646323576	-122.427113499044	(37.7488646323576, -122.427113499044)
100513	100513	93282	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1383 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004535.0	2100841.0	37.748765897796204	-122.42710401922199	(37.7487658977962, -122.427104019222)
88852	88852	93281	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1465 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004562.0	2100365.0	37.747460438671105	-122.426976756198	(37.7474604386711, -122.426976756198)
85581	85581	93267	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1550 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004563.0	2099865.0	37.746087610537295	-122.426937693393	(37.7460876105373, -122.426937693393)
114770	114770	93280	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1485 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004568.0	2100246.0	37.7471340314151	-122.42694753458099	(37.7471340314151, -122.426947534581)
118880	118880	93268	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1574 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/29/2015 05:47:00 AM	3	3x3		6004569.0	2099722.0	37.7456953047191	-122.42690676352	(37.7456953047191, -122.42690676352)
83349	83349	93300	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	589X Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/12/2008 12:00:00 AM	3	3x3		6004575.9	2105667.0	37.7620192734995	-122.427306317148	(37.7620192734995, -122.427306317148)
145750	145750	93279	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1557 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004591.0	2099830.0	37.745993091787795	-122.426838380811	(37.7459930917878, -122.426838380811)
143516	143516	93278	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1559 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004592.0	2099818.0	37.74596019909129	-122.426834068489	(37.7459601990913, -122.426834068489)
108745	108745	93276	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1603 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004604.0	2099562.0	37.7452579604553	-122.426774346316	(37.7452579604553, -122.426774346316)
98869	98869	93275	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1607 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004606.0	2099539.0	37.7451949208192	-122.42676579302	(37.7451949208192, -122.42676579302)
109604	109604	93274	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1613 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004607.0	2099503.0	37.7450961296299	-122.426759771954	(37.7450961296299, -122.426759771954)
77688	77688	93269	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1730 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004618.0	2098811.0	37.743196678206296	-122.42667246707799	(37.7431966782063, -122.426672467078)
101720	101720	93272	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1689 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004632.0	2099057.0	37.7438729293821	-122.42664157265	(37.7438729293821, -122.42664157265)
84975	84975	93277	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1565 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004670.9	2099777.3	37.7458529070189	-122.426558345234	(37.7458529070189, -122.426558345234)
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)
85134	85134	93273	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1679 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004706.9	2099119.3	37.7440482251279	-122.42638702061701	(37.7440482251279, -122.426387020617)
125597	125597	93271	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1699X Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004711.0	2099043.6	37.7438406020251	-122.426367454995	(37.7438406020251, -122.426367454995)
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)
9977	9977	5406	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	392 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/02/2012 12:00:00 AM	5	3x3		6004848.6988147	2106052.9215434	37.7630943465887	-122.42639029035401	(37.7630943465887, -122.426390290354)
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)
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)

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