Street_Tree_List

Data source: data.sfgov.org

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

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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
118880	118880	93268	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1574 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/29/2015 05:47:00 AM	3	3x3		6004569.0	2099722.0	37.7456953047191	-122.42690676352	(37.7456953047191, -122.42690676352)
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)
124404	124404	87647	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1989X PINE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/30/2008 12:00:00 AM	3	3x3		6004432.0	2115332.0	37.788548856891296	-122.42849294395701	(37.7885488568913, -122.428492943957)
9977	9977	5406	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	392 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/02/2012 12:00:00 AM	5	3x3		6004848.6988147	2106052.9215434	37.7630943465887	-122.42639029035401	(37.7630943465887, -122.426390290354)
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)
128139	128139	12447	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1989X Pine St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/18/2004 12:00:00 AM	4	3x3		6004432.626396201	2115327.1853143997	37.7885356724235	-122.428490433403	(37.7885356724235, -122.428490433403)
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)
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)
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)
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)
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)
96738	96738	85598	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1101 Palou Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/08/2014 12:00:00 AM	3	3x3		6017523.881587001	2093256.0516779998	37.728665096277204	-122.381660625783	(37.7286650962772, -122.381660625783)
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)
100415	100415	6784	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1360 Fairfax Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/10/2007 12:00:00 AM	4	3x3		6016787.1910829	2097353.9213772	37.739876324716896	-122.384492742853	(37.7398763247169, -122.384492742853)
102892	102892	13103	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1516 Lombard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/11/2008 12:00:00 AM	3	3x3		6005111.0	2119918.0	37.801179250916796	-122.426470375667	(37.8011792509168, -122.426470375667)
139282	139282	87673	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2610 Bay Shore Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/14/2006 12:00:00 AM	3	3x3		6010582.741346	2086196.4709060001	37.708895230886	-122.40515978386101	(37.708895230886, -122.405159783861)
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)
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)
86667	86667	85584	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1512 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2007 12:00:00 AM	3	3x3		6015354.897796	2094923.102787	37.7331224832721	-122.389275358402	(37.7331224832721, -122.389275358402)
91134	91134	85567	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1274 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2007 12:00:00 AM	3	3x3		6016640.49857	2093964.460415	37.730561430483796	-122.384763892339	(37.7305614304838, -122.384763892339)
93558	93558	85578	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1388 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2007 12:00:00 AM	3	3x3		6016034.7263629995	2094416.0331849998	37.7317678372886	-122.386889636739	(37.7317678372886, -122.386889636739)
100161	100161	85559	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	980 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2007 12:00:00 AM	3	3x3		6018187.977748999	2092810.8923689998	37.727479421244	-122.37933387198099	(37.727479421244, -122.379333871981)
105434	105434	85569	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1260 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2007 12:00:00 AM	3	3x3		6016711.517151	2093911.5196330003	37.7304199931233	-122.384514682139	(37.7304199931233, -122.384514682139)
105958	105958	85583	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1500 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2007 12:00:00 AM	3	3x3		6015418.292964	2094875.9215880001	37.7329964475839	-122.389052889382	(37.7329964475839, -122.389052889382)
112715	112715	85568	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1264 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2007 12:00:00 AM	3	3x3		6016691.22613	2093926.645569	37.730460403847204	-122.384585884949	(37.7304604038472, -122.384585884949)
118293	118293	85562	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	990 Palou Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2007 12:00:00 AM	3	3x3		6018144.213614	2092843.516343	37.7275665867834	-122.379487431767	(37.7275665867834, -122.379487431767)
118353	118353	85607	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1397 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2007 12:00:00 AM	3	3x3		6015969.720597	2094414.6007130002	37.7317603044799	-122.387114277117	(37.7317603044799, -122.387114277117)
120019	120019	85580	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1458 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2007 12:00:00 AM	3	3x3		6015655.098902999	2094699.254039	37.7325244779387	-122.38822185678002	(37.7325244779387, -122.38822185678)
120459	120459	85597	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1101 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2007 12:00:00 AM	6	3x3		6017523.881587001	2093256.0516779998	37.728665096277204	-122.381660625783	(37.7286650962772, -122.381660625783)
120899	120899	85560	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	980 Palou Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2007 12:00:00 AM	3	3x3		6018187.977748999	2092810.8923689998	37.727479421244	-122.37933387198099	(37.727479421244, -122.379333871981)
127595	127595	85589	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1566 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2007 12:00:00 AM	3	3x3		6015069.619532	2095135.4181869999	37.7336896386511	-122.390276478357	(37.7336896386511, -122.390276478357)
142002	142002	85561	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	990 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2007 12:00:00 AM	3	3x3		6018144.213614	2092843.516343	37.7275665867834	-122.379487431767	(37.7275665867834, -122.379487431767)
143637	143637	85570	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1260 Palou Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2007 12:00:00 AM	3	3x3		6016711.517151	2093911.5196330003	37.7304199931233	-122.384514682139	(37.7304199931233, -122.384514682139)
143702	143702	85577	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1370 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2007 12:00:00 AM	3	3x3		6016127.199744	2094347.0989189998	37.731583677290004	-122.38656512948499	(37.73158367729, -122.386565129485)
144143	144143	85565	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1276 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/21/2007 12:00:00 AM	3	3x3		6016630.35305	2093972.0233900002	37.7305816357941	-122.384799493903	(37.7305816357941, -122.384799493903)
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)
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)
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)
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)
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)
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)
9463	9463	85733	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	901 Howard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/30/2007 12:00:00 AM	4	3x3		6011193.193535	2112605.183477	37.7814419523203	-122.404908060988	(37.7814419523203, -122.404908060988)
88428	88428	86595	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2154 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/30/2007 12:00:00 AM	6	3x3		6009566.0	2104744.0	37.7597658751742	-122.409982265203	(37.7597658751742, -122.409982265203)
89180	89180	85698	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	640 Howard St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/30/2007 12:00:00 AM	3	3x3		6012881.28755	2114275.485576	37.786122430176896	-122.39918531693199	(37.7861224301769, -122.399185316932)
99235	99235	86637	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2679 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/30/2007 12:00:00 AM	3	3x3		6009805.5318559995	2101750.09748	37.751558711569096	-122.40894259967101	(37.7515587115691, -122.408942599671)
100706	100706	85720	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1133 Howard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/30/2007 12:00:00 AM	3	3x3		6009666.355548	2111144.506481	37.777345813652	-122.41008705150699	(37.777345813652, -122.410087051507)
109929	109929	85721	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1049 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/30/2007 12:00:00 AM	3	3x3		6010189.0	2111652.0	37.778768551926795	-122.408314849736	(37.7787685519268, -122.408314849736)
110192	110192	85696	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	640 Howard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/30/2007 12:00:00 AM	3	3x3		6012881.28755	2114275.485576	37.786122430176896	-122.39918531693199	(37.7861224301769, -122.399185316932)
110941	110941	85708	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	964 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/30/2007 12:00:00 AM	3	3x3		6010738.0	2112218.0	37.780353382723604	-122.40645552748501	(37.7803533827236, -122.406455527485)
120118	120118	85737	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	843 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/30/2007 12:00:00 AM	3	3x3		6011572.165806	2112967.7341830004	37.782458608165896	-122.40362250946998	(37.7824586081659, -122.40362250947)
124409	124409	85712	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1144 Howard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/30/2007 12:00:00 AM	3	3x3		6009550.0	2111081.0	37.777164917460105	-122.410485079371	(37.7771649174601, -122.410485079371)
139951	139951	85719	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1175 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/30/2007 12:00:00 AM	3	3x3		6009405.0	2110901.0	37.7766625499179	-122.410973965657	(37.7766625499179, -122.410973965657)
144410	144410	85707	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	960 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/30/2007 12:00:00 AM	3	3x3		6010763.0	2112242.0	37.7804206796364	-122.406370731962	(37.7804206796364, -122.406370731962)
146040	146040	85697	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	640 Howard St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/30/2007 12:00:00 AM	3	3x3		6012881.28755	2114275.485576	37.786122430176896	-122.39918531693199	(37.7861224301769, -122.399185316932)
146109	146109	85695	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	640 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/30/2007 12:00:00 AM	3	3x3		6012881.28755	2114275.485576	37.786122430176896	-122.39918531693199	(37.7861224301769, -122.399185316932)
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)
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)
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)
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)
141707	141707	85728	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1025 Howard St	2	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)
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)
88557	88557	85827	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1345 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/17/2007 12:00:00 AM	3	3x3		6008580.0	2110114.0	37.774455337270396	-122.413772211324	(37.7744553372704, -122.413772211324)
96836	96836	85833	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	875 Howard St	6	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)
96859	96859	85826	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1399X Howard St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/17/2007 12:00:00 AM	3	3x3		6008422.422874	2109956.642426	37.774014420128495	-122.414306166437	(37.7740144201285, -122.414306166437)
116886	116886	85824	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1399X Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/17/2007 12:00:00 AM	3	3x3		6008422.422874	2109956.642426	37.774014420128495	-122.414306166437	(37.7740144201285, -122.414306166437)
117554	117554	85822	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1499X Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/17/2007 12:00:00 AM	3	3x3		6008077.269337	2109627.004998	37.7730899192917	-122.415476772701	(37.7730899192917, -122.415476772701)
123660	123660	85829	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	875 Howard St	2	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)
127408	127408	85825	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1399X Howard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/17/2007 12:00:00 AM	3	3x3		6008422.422874	2109956.642426	37.774014420128495	-122.414306166437	(37.7740144201285, -122.414306166437)
140765	140765	85831	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	875 Howard St	4	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)
142267	142267	85832	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	875 Howard St	5	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)
146253	146253	85830	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	875 Howard St	3	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)
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)
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)
110344	110344	85820	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1501 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/18/2007 12:00:00 AM	3	3x3		6008072.0	2109608.0	37.7730374398788	-122.415493654294	(37.7730374398788, -122.415493654294)
115233	115233	85817	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1581 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/18/2007 12:00:00 AM	3	3x3		6007957.739489	2109502.485486	37.7727412989479	-122.415881423672	(37.7727412989479, -122.415881423672)
118449	118449	85818	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1525 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/18/2007 12:00:00 AM	3	3x3		6007957.0	2109502.0	37.7727399243445	-122.415883947269	(37.7727399243445, -122.415883947269)
123533	123533	85811	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1675 Howard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/18/2007 12:00:00 AM	3	3x3		6007516.0	2108769.0	37.7707024771995	-122.417357464156	(37.7707024771995, -122.417357464156)
124508	124508	85821	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1501 Howard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/18/2007 12:00:00 AM	3	3x3		6008072.0	2109608.0	37.7730374398788	-122.415493654294	(37.7730374398788, -122.415493654294)
140189	140189	85813	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1675 Howard St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/18/2007 12:00:00 AM	3	3x3		6007516.0	2108769.0	37.7707024771995	-122.417357464156	(37.7707024771995, -122.417357464156)
144998	144998	85810	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1675 Howard St	1	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)
145952	145952	85814	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1607 Howard St	1	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)
116965	116965	18361	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	530 Potrero Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/02/2015 11:39:00 AM	3	3x3		6010330.807907499	2105828.5872592	37.762786742062204	-122.407413622665	(37.7627867420622, -122.407413622665)
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)
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)
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)

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