Street_Tree_List

Data source: data.sfgov.org

343 rows where qSpecies = 90 sorted by TreeID 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

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

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)
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)
44789	44789	230394	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	280 Fair Oaks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6005433.48505	2102088.4512099996	37.752241878473896	-122.42408575987	(37.7522418784739, -122.42408575987)
136828	136828	230393	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3420 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6005567.360669999	2103163.57677	37.7552014816894	-122.423699232135	(37.7552014816894, -122.423699232135)
45445	45445	230392	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3416 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6005586.33797	2103162.25218	37.7551989159029	-122.423633508794	(37.7551989159029, -122.423633508794)
53871	53871	230391	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3425 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6005521.318	2103117.66656	37.755072823769204	-122.423855197061	(37.7550728237692, -122.423855197061)
173263	173263	230390	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3431 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6005492.40988	2103117.15388	37.7550697840629	-122.423955133335	(37.7550697840629, -122.423955133335)
22880	22880	230389	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	51 13th St	4	: 4	Tree 1	Private 1			6	Width 3ft		6008142.81587	2108281.73826	37.7693998171644	-122.41515479496701	(37.7693998171644, -122.415154794967)
180875	180875	230388	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	51 13th St	3	: 4	Tree 1	Private 1			8	Width 4ft		6008125.5999300005	2108283.70929	37.7694042616334	-122.41521448386001	(37.7694042616334, -122.41521448386)
164713	164713	230387	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	51 13th St	2	: 4	Tree 1	Private 1			7	Width 4ft		6008108.07186	2108284.2511400003	37.7694047643365	-122.415275151222	(37.7694047643365, -122.415275151222)
41914	41914	230386	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	51 13th St	1	: 4	Tree 1	Private 1			9	Width 4ft		6008087.40778	2108285.62264	37.769407368778	-122.415346724678	(37.769407368778, -122.415346724678)
178549	178549	230385	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	581 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 9ft		6004995.95318	2104998.86424	37.760208477866	-122.42580595608601	(37.760208477866, -122.425805956086)
134507	134507	230384	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	601 Dolores St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 4ft		6005003.814780001	2104818.83763	37.7597146115626	-122.42576595245501	(37.7597146115626, -122.425765952455)
75813	75813	230383	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	655 Dolores St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 6ft		6005020.28561	2104519.96917	37.7588949199761	-122.425687715924	(37.7588949199761, -122.425687715924)
152400	152400	230382	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	655 Dolores St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 6ft		6005021.64655	2104500.02665	37.7588402394163	-122.42568158976002	(37.7588402394163, -122.42568158976)
59682	59682	230381	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	655 Dolores St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 6ft		6005021.944209999	2104476.3564299997	37.7587752633866	-122.425678875606	(37.7587752633866, -122.425678875606)
32851	32851	230380	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1450 Hampshire St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6010406.10881	2100942.79845	37.74937566986971	-122.40680882918501	(37.7493756698697, -122.406808829185)
182507	182507	230379	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	636 Potrero Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 2ft		6010352.94216	2105328.73163	37.7614154903439	-122.407301828531	(37.7614154903439, -122.407301828531)
132375	132375	230378	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	11 Haight St	3	: 4	Tree 1	Private 1			5	Width 4ft		6006027.69558	2109650.1201	37.7730379732539	-122.422568162015	(37.7730379732539, -122.422568162015)
51642	51642	230377	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	11 Haight St	2	: 4	Tree 1	Private 1			6	Width 4ft		6006012.138780001	2109648.33208	37.7730321861234	-122.42262184792101	(37.7730321861234, -122.422621847921)
156278	156278	230376	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	126 Dolores St	1	: 4	Tree 1	Private 1			4	Width 3ft		6004756.55794	2107626.00234	37.7674084411732	-122.426821010098	(37.7674084411732, -122.426821010098)
178042	178042	230375	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	70 Pearl St	1	: 4	Tree 1	Private 1			9	Width 4ft		6005616.00843	2108643.7620099997	37.770251521926	-122.423920665902	(37.770251521926, -122.423920665902)
49153	49153	193408	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	480 Potrero Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6010314.12402	2106048.6526900004	37.763390058038794	-122.40748684246401	(37.7633900580388, -122.407486842464)
129588	129588	193407	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	541 Missouri St	1	: 4	Tree 1	Private 1			3	Width 2ft		6013570.69062	2104547.33874	37.7594495210946	-122.396118132954	(37.7594495210946, -122.396118132954)
179739	179739	193406	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	746 Kansas St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6011525.03424	2104899.87784	37.7603034831294	-122.40321785872601	(37.7603034831294, -122.403217858726)
516	516	188685	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1300 Evans Ave	14	: 4	Tree 1	DPW 2		04/10/2017 01:01:00 PM	3	Width 3ft		6017863.857919999	2096944.2017700002	37.738810795988606	-122.38074156686301	(37.7388107959886, -122.380741566863)
172742	172742	177452	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	404 Naples St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6003440.2849	2091219.73942	37.7222861409715	-122.430203237092	(37.7222861409715, -122.430203237092)
24021	24021	177451	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	836 Brazil Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 2ft		6004096.8384300005	2090858.43848	37.7213312534072	-122.427907954105	(37.7213312534072, -122.427907954105)
60367	60367	131011	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1771 North Point St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6002300.20603	2120865.81933	37.8036224187107	-122.436264801676	(37.8036224187107, -122.436264801676)
49354	49354	131010	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3099 Steiner St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6001935.38679	2118702.3343700003	37.797661323668606	-122.437372261923	(37.7976613236686, -122.437372261923)
2563	2563	124911	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3234 Pacific Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/19/2017 12:00:00 AM	3	Width 4ft	Permit Number 780160	5998736.95045	2116593.12953	37.7916876606053	-122.448287711302	(37.7916876606053, -122.448287711302)
2562	2562	124910	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3234 Pacific Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/19/2017 12:00:00 AM	3	Width 4ft	Permit Number 780160	5998760.117380001	2116596.00833	37.79169688945171	-122.4482077616	(37.7916968894517, -122.4482077616)
97987	97987	117395	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	544 Wawona St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/08/2016 12:00:00 AM	3		Permit Number 778554	5991215.4	2097083.4	37.737686285904296	-122.47288871789	(37.7376862859043, -122.47288871789)
117526	117526	117298	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1590 08th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/06/2016 12:00:00 AM	3		Permit Number 778522	5993741.6	2104678.7	37.7586869726954	-122.46470588880699	(37.7586869726954, -122.464705888807)
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)
98839	98839	115435	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	563 Lisbon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/01/2016 12:00:00 AM	3		Permit Number 777504	6001919.8	2090201.1	37.7194029477524	-122.43538635551901	(37.7194029477524, -122.435386355519)
9788	9788	115347	Planning Code 138.1 required 4	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	398X HARRISON ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/28/2016 12:00:00 AM	3	4x4	Permit Number 773314	6014854.0	2114630.0	37.7872055860551	-122.392385006805	(37.7872055860551, -122.392385006805)
9806	9806	115346	Planning Code 138.1 required 4	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	398X HARRISON ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/28/2016 12:00:00 AM	3	4x4	Permit Number 773314	6014854.0	2114630.0	37.7872055860551	-122.392385006805	(37.7872055860551, -122.392385006805)
113204	113204	114762	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	27X Highland Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/07/2015 12:00:00 AM			Permit Number 46967	6005096.96871	2096699.6024099998	37.7374263260205	-122.424866136467	(37.7374263260205, -122.424866136467)
143424	143424	114091	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1717 15th Ave		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/01/2015 12:00:00 AM			Permit Number 775992	5991423.2	2103752.9	37.7560110367904	-122.472656396727	(37.7560110367904, -122.472656396727)
94068	94068	112744	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	235 Bright St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/18/2015 12:00:00 AM			Permit Number 774127	5993719.1	2088769.4	37.7150026970857	-122.463629063261	(37.7150026970857, -122.463629063261)
33883	33883	110043	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	890 Rhode Island St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		9			6011841.59848	2104237.14125	37.7585014297196	-122.402076412192	(37.7585014297196, -122.402076412192)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
120644	120644	103862	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1436 Polk St	2	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006766.2	2115894.4	37.7902248822442	-122.42045688909701	(37.7902248822442, -122.420456889097)
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)
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)
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)
95708	95708	103848	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1524 Polk St	1	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)
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)
99600	99600	103846	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1540 Polk St	2	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006747.0	2116248.1	37.7911949727431	-122.42054843762399	(37.7911949727431, -122.420548437624)
99675	99675	103845	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1540 Polk St	1	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006747.0	2116248.1	37.7911949727431	-122.42054843762399	(37.7911949727431, -122.420548437624)
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)
87496	87496	103843	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1541 Polk St	1	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)
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)
107651	107651	103837	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	900X O'Farrell St	4	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)
141455	141455	103836	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	900X O'Farrell St	3	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)
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)
104380	104380	103834	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	900X O'Farrell St	1	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)
125341	125341	103817	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1100 Polk St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2009 12:00:00 AM	3	3x3		6006925.9	2114751.5	37.787095758933894	-122.41982320605	(37.7870957589339, -122.41982320605)
114055	114055	103794	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1214 Polk St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2009 12:00:00 AM	3	3x3		6006878.4	2115091.6	37.7880269138329	-122.420011690177	(37.7880269138329, -122.420011690177)
103470	103470	103793	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1214 Polk St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2009 12:00:00 AM	3	3x3		6006878.4	2115091.6	37.7880269138329	-122.420011690177	(37.7880269138329, -122.420011690177)
99080	99080	103792	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1214 Polk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2009 12:00:00 AM	3	3x3		6006878.4	2115091.6	37.7880269138329	-122.420011690177	(37.7880269138329, -122.420011690177)
142798	142798	103791	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1214 Polk St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2009 12:00:00 AM	3	3x3		6006878.4	2115091.6	37.7880269138329	-122.420011690177	(37.7880269138329, -122.420011690177)
78106	78106	102590	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1205 Plymouth Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 47971	5995820.0	2092088.8	37.724237816628	-122.4566074133	(37.724237816628, -122.4566074133)
114199	114199	100465	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1140 Potrero Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	3x3		6010498.9	2102571.5	37.75385291653011	-122.40660271212	(37.7538529165301, -122.40660271212)
99170	99170	100432	Significant Tree 6	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	200X Stonecrest Dr	2	Front Yard : Yard 7	Tree 1	Private 1						5990724.7	2093134.9	37.7268162840874	-122.47429724264	(37.7268162840874, -122.47429724264)
114083	114083	100431	Significant Tree 6	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	200X Stonecrest Dr	1	Front Yard : Yard 7	Tree 1	Private 1						5990724.7	2093134.9	37.7268162840874	-122.47429724264	(37.7268162840874, -122.47429724264)
120237	120237	98720	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1500 Broadway	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/30/2012 12:00:00 AM		4x4	Permit Number 768751	6006413.8	2117997.6	37.795979878671	-122.421825625767	(37.795979878671, -122.421825625767)
117808	117808	98719	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1500 Broadway	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/30/2012 12:00:00 AM			Permit Number 768751	6006413.8	2117997.6	37.795979878671	-122.421825625767	(37.795979878671, -122.421825625767)
15344	15344	96670	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1425 Mendell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/26/2012 12:00:00 AM	4	4x4		6015007.7446	2095379.2401	37.7343556918302	-122.390507431087	(37.7343556918302, -122.390507431087)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)

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