Street_Tree_List

Data source: data.sfgov.org

243 rows where PlotSize = "3x3" and qSpecies = 90 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

- 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
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)
18619	18619	96032	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1314 Larkin St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/02/2011 12:00:00 AM		3x3	Permit Number 767671	6007241.0	2115796.0	37.7899814452739	-122.418807131377	(37.7899814452739, -122.418807131377)
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)
78558	78558	96014	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	999 California St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/02/2011 12:00:00 AM		3x3	Permit Number 767660	6009569.0	2116409.0	37.791795397820394	-122.410795730189	(37.7917953978204, -122.410795730189)
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)
82865	82865	93743	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	875 Howard St		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/29/2010 12:00:00 AM		3x3	Permit Number 53322	6011367.4	2112778.7	37.7819281242694	-122.40431760427	(37.7819281242694, -122.40431760427)
83040	83040	96012	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	999 California St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/02/2011 12:00:00 AM		3x3	Permit Number 767660	6009569.0	2116409.0	37.791795397820394	-122.410795730189	(37.7917953978204, -122.410795730189)
84064	84064	96013	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	999 California St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/02/2011 12:00:00 AM		3x3	Permit Number 767660	6009569.0	2116409.0	37.791795397820394	-122.410795730189	(37.7917953978204, -122.410795730189)
84434	84434	88753	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	990 Polk St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/19/2008 12:00:00 AM		3x3	Permit Number 51679	6006960.9	2114284.0	37.785814090273796	-122.41966893082501	(37.7858140902738, -122.419668930825)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
97097	97097	88749	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	990 Polk St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/19/2008 12:00:00 AM		3x3	Permit Number 51679	6006960.9	2114284.0	37.785814090273796	-122.41966893082501	(37.7858140902738, -122.419668930825)
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)
99054	99054	88750	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	990 Polk St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/19/2008 12:00:00 AM		3x3	Permit Number 51679	6006960.9	2114284.0	37.785814090273796	-122.41966893082501	(37.7858140902738, -122.419668930825)
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)
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)
102897	102897	87853	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	599 Moultrie St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/11/2008 12:00:00 AM		3x3	Permit Number 50764	6007684.0	2096571.0	37.7372189966792	-122.415912430403	(37.7372189966792, -122.415912430403)
103131	103131	88442	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1148 Treat Ave		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/11/2008 12:00:00 AM		3x3	Permit Number 51406	6008612.9	2101850.1	37.7517664174328	-122.413073954345	(37.7517664174328, -122.413073954345)
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)
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)
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)
105721	105721	95660	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	431 Brussels St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/08/2011 12:00:00 AM		3x3	Permit Number 767422	6010656.7	2092697.9	37.726750960199794	-122.40536171554	(37.7267509601998, -122.40536171554)
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)
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)
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)
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)
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)
118760	118760	88752	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	990 Polk St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/19/2008 12:00:00 AM		3x3	Permit Number 51679	6006960.9	2114284.0	37.785814090273796	-122.41966893082501	(37.7858140902738, -122.419668930825)
119478	119478	96015	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	999 California St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/02/2011 12:00:00 AM		3x3	Permit Number 767660	6009569.0	2116409.0	37.791795397820394	-122.410795730189	(37.7917953978204, -122.410795730189)
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)
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)
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)
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)
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)
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)
128409	128409	88751	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	990 Polk St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/19/2008 12:00:00 AM		3x3	Permit Number 51679	6006960.9	2114284.0	37.785814090273796	-122.41966893082501	(37.7858140902738, -122.419668930825)
138637	138637	94896	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1375 Keith St		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/23/2010 12:00:00 AM		3x3	Permit Number 53955	6016208.4	2094705.0	37.7325708970962	-122.386309345138	(37.7325708970962, -122.386309345138)
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)
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)
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)
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)
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)
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)
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)
151629	151629	116966	Planning Code 138.1 required 4	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	480 Potrero Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	3x3		6010311.678719999	2106089.82191	37.7635029625087	-122.407498202703	(37.7635029625087, -122.407498202703)
507	507	251288	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1335 Fairfax Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2	Private 3	03/18/2017 01:58:00 PM	3	3x3		6016828.0	2097292.0	37.7397085577181	-122.38434732981199	(37.7397085577181, -122.384347329812)
511	511	251164	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1215 Fairfax Ave	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/10/2017 01:46:00 PM	3	3x3		6017471.0	2096747.0	37.738247630240295	-122.382086185189	(37.7382476302403, -122.382086185189)
1124	1124	29774	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1100X Evans Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/03/2017 12:44:00 PM	3	3x3		6018183.3236	2096672.8034	37.7380832156692	-122.37961814277901	(37.7380832156692, -122.379618142779)
4901	4901	18480	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1298 Potrero Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/31/2017 01:20:00 PM	3	3x3		6010561.39126	2101710.28558	37.751491708090896	-122.406325925618	(37.7514917080909, -122.406325925618)
9079	9079	6769	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1275 Fairfax Ave	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/27/2007 12:00:00 AM	3	3x3		6017217.4089567	2096970.3613046003	37.738846926957706	-122.382978527185	(37.7388469269577, -122.382978527185)
9121	9121	85732	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	901 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/30/2007 12:00:00 AM	3	3x3		6011193.193535	2112605.183477	37.7814419523203	-122.404908060988	(37.7814419523203, -122.404908060988)
9231	9231	6725	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1200X Fairfax Ave	22	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/05/2008 12:00:00 AM	3	3x3		6017621.9936242	2096730.3826429	37.7382103402349	-122.381562963191	(37.7382103402349, -122.381562963191)
9834	9834	6787	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1360 Fairfax Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/03/2017 06:55:00 AM	3	3x3		6016787.1910829	2097353.9213772	37.739876324716896	-122.384492742853	(37.7398763247169, -122.384492742853)
13480	13480	85599	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1115 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/07/2014 12:00:00 AM	3	3x3		6017434.0078	2093308.576	37.7288043549368	-122.38197498007798	(37.7288043549368, -122.381974980078)
14031	14031	18353	Planning Code 138.1 required 4	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	480 Potrero Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/02/2013 12:00:00 AM	3	3x3		6010310.709559999	2106111.3358	37.76356198052329	-122.407503071611	(37.7635619805233, -122.407503071611)
17657	17657	18422	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	940 Potrero Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/09/2016 06:57:00 AM	3	3x3		6010451.25485	2103753.05423	37.7570945357026	-122.406850749261	(37.7570945357026, -122.406850749261)
17773	17773	18420	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	924 Potrero Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/14/2013 12:00:00 AM	3	3x3		6010442.48956	2103839.41038	37.7573311599314	-122.406887149344	(37.7573311599314, -122.406887149344)
18023	18023	108392	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1382 San Bruno Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/19/2014 12:00:00 AM	3	3x3	Permit Number 773801	6011141.7607	2101910.8917	37.7520749768049	-122.40433304488701	(37.7520749768049, -122.404333044887)
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)
21685	21685	18423	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	952 Potrero Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/20/2013 12:00:00 AM	3	3x3		6010455.30853	2103703.2834799998	37.75695810316021	-122.406833222372	(37.7569581031602, -122.406833222372)
22956	22956	103844	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1541 Polk St	2	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006635.7	2116216.3	37.791101384779296	-122.420931274285	(37.7911013847793, -122.420931274285)
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)
22970	22970	103849	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1524 Polk St	2	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006765.8	2116184.9	37.7910225007002	-122.420478902042	(37.7910225007002, -122.420478902042)
22978	22978	103850	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1524 Polk St	3	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006765.8	2116184.9	37.7910225007002	-122.420478902042	(37.7910225007002, -122.420478902042)
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)
66030	66030	103847	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1529 Polk St	1	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006640.1	2116184.7	37.7910148670423	-122.42091380589399	(37.7910148670423, -122.420913805894)
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)
78052	78052	103838	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	900X O'Farrell St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006751.076230001	2113939.67696	37.78485684194221	-122.420370415446	(37.7848568419422, -122.420370415446)
79013	79013	85727	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1025 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/16/2007 12:00:00 AM	3	3x3		6010365.0	2111820.0	37.7792396944918	-122.40771784288	(37.7792396944918, -122.40771784288)
80881	80881	85815	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1607 Howard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/18/2007 12:00:00 AM	3	3x3		6007663.0	2109095.0	37.7716058657462	-122.41687208779301	(37.7716058657462, -122.416872087793)
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)
81332	81332	94246	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2125 BRYANT ST	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/29/2010 12:00:00 AM	3	3x3	Permit Number 53614	6009652.0	2104721.0	37.7597075419954	-122.40968320892	(37.7597075419954, -122.40968320892)
82006	82006	32722	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	644 Hyde St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/30/2011 12:00:00 AM	3	3x3	Permit Number 768334	6007901.48303797	2114768.35798987	37.7871969578975	-122.416449089052	(37.7871969578975, -122.416449089052)
82685	82685	103874	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1331 Polk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006716.3	2115545.2	37.7892632533111	-122.42060474068998	(37.7892632533111, -122.42060474069)
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)
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)
83591	83591	94262	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2850X 20th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/29/2010 12:00:00 AM	3	3x3	Permit Number 53614	6009745.2	2104556.4	37.759260809864294	-122.409349258874	(37.7592608098643, -122.409349258874)
84159	84159	85604	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1261 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2007 12:00:00 AM	3	3x3		6016687.610646	2093879.449725	37.7303306134548	-122.384595098105	(37.7303306134548, -122.384595098105)
84499	84499	103835	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	900X O'Farrell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006751.076230001	2113939.67696	37.78485684194221	-122.420370415446	(37.7848568419422, -122.420370415446)
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)
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)
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)
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)
85241	85241	85828	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	875 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/17/2007 12:00:00 AM	3	3x3		6011370.824523999	2112775.117387	37.7819184786136	-122.40430550469401	(37.7819184786136, -122.404305504694)
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)
85874	85874	94260	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2850X 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/29/2010 12:00:00 AM	3	3x3	Permit Number 53614	6009745.2	2104556.4	37.759260809864294	-122.409349258874	(37.7592608098643, -122.409349258874)
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)
86047	86047	85812	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1675 Howard St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/18/2007 12:00:00 AM	3	3x3		6007516.0	2108769.0	37.7707024771995	-122.417357464156	(37.7707024771995, -122.417357464156)
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");