Street_Tree_List

Data source: data.sfgov.org

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

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- 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
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)
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)
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)
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)
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)
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)
112259	112259	108977	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2970 21st St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/20/2015 12:00:00 AM	3	3x3	Permit Number 773794	6008402.2	2103930.0	37.7574655215329	-122.413949705223	(37.7574655215329, -122.413949705223)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
91334	91334	94243	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2125 BRYANT ST	1	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)
96403	96403	94244	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2125 BRYANT ST	3	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)
101173	101173	94263	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2850X 20th St	4	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)
109624	109624	94259	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2777X 19th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/29/2010 12:00:00 AM	3	3x3	Permit Number 53614	6009684.4	2104752.7	37.7597963985886	-122.40957339028499	(37.7597963985886, -122.409573390285)
111220	111220	94245	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2125 BRYANT ST	7	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)
114755	114755	94258	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2850X 20th St	5	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)
138820	138820	94247	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2125 BRYANT ST	11	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)
141665	141665	94261	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2850X 20th St	2	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)
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)
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)
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)
176715	176715	81753	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	565 Missouri St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/02/2009 12:00:00 AM	4	3x3	Permit Number 52385	6013577.35874	2104447.02049	37.7591744400611	-122.396088040728	(37.7591744400611, -122.396088040728)
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)
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)
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)
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)
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)
87986	87986	91094	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3417X 18th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/22/2008 12:00:00 AM	3	3x3	Permit Number 51985	6006736.0	2105525.0	37.761751301646704	-122.41982527826299	(37.7617513016467, -122.419825278263)
114805	114805	91093	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3417X 18th St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/22/2008 12:00:00 AM	3	3x3	Permit Number 51985	6006736.0	2105525.0	37.761751301646704	-122.41982527826299	(37.7617513016467, -122.419825278263)
123957	123957	91091	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3417X 18th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/22/2008 12:00:00 AM	3	3x3	Permit Number 51985	6006736.0	2105525.0	37.761751301646704	-122.41982527826299	(37.7617513016467, -122.419825278263)
126063	126063	91095	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3417X 18th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/22/2008 12:00:00 AM	3	3x3	Permit Number 51985	6006736.0	2105525.0	37.761751301646704	-122.41982527826299	(37.7617513016467, -122.419825278263)
139405	139405	91090	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3417X 18th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/22/2008 12:00:00 AM	3	3x3	Permit Number 51985	6006736.0	2105525.0	37.761751301646704	-122.41982527826299	(37.7617513016467, -122.419825278263)
143561	143561	91089	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3417X 18th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/22/2008 12:00:00 AM	3	3x3	Permit Number 51985	6006736.0	2105525.0	37.761751301646704	-122.41982527826299	(37.7617513016467, -122.419825278263)
145490	145490	91092	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3417X 18th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/22/2008 12:00:00 AM	3	3x3	Permit Number 51985	6006736.0	2105525.0	37.761751301646704	-122.41982527826299	(37.7617513016467, -122.419825278263)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
112161	112161	32720	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	644 Hyde St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/29/1996 12:00:00 AM	3	3x3	Permit Number 37113	6007901.48303797	2114768.35798987	37.7871969578975	-122.416449089052	(37.7871969578975, -122.416449089052)
115718	115718	32721	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	644 Hyde St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/29/1996 12:00:00 AM	3	3x3	Permit Number 37113	6007901.48303797	2114768.35798987	37.7871969578975	-122.416449089052	(37.7871969578975, -122.416449089052)
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)
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)
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)
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)
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)

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