Street_Tree_List

Data source: data.sfgov.org

243 rows where PlotSize = "3x3" and qSpecies = 90 sorted by rowid 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
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)
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)
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)
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)
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)
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)
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)
145750	145750	93279	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1557 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004591.0	2099830.0	37.745993091787795	-122.426838380811	(37.7459930917878, -122.426838380811)
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)
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)
145306	145306	93295	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1019 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004430.0	2102966.0	37.7545947138847	-122.427618485613	(37.7545947138847, -122.427618485613)
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)
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)
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)
144320	144320	93289	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1159 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004476.0	2102138.0	37.752323821507396	-122.427400423827	(37.7523238215074, -122.427400423827)
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)
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)
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)
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)
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)
143516	143516	93278	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1559 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004592.0	2099818.0	37.74596019909129	-122.426834068489	(37.7459601990913, -122.426834068489)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
139844	139844	93265	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1400X Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004448.1	2100692.1	37.748352138422796	-122.42739391326401	(37.7483521384228, -122.427393913264)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
127346	127346	94638	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2000X Bay Shore Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/19/2010 12:00:00 AM	3	3x3		6012318.2	2088514.6	37.715357222040005	-122.399324379639	(37.71535722204, -122.399324379639)
126091	126091	93264	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1326 Church St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004490.0	2101167.0	37.749658473374204	-122.42728284799401	(37.7496584733742, -122.427282847994)
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)
125597	125597	93271	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1699X Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004711.0	2099043.6	37.7438406020251	-122.426367454995	(37.7438406020251, -122.426367454995)
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)
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)
124501	124501	93263	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1326 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004490.0	2101167.0	37.749658473374204	-122.42728284799401	(37.7496584733742, -122.427282847994)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
115779	115779	5577	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1041 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/11/2010 12:00:00 AM	3	3x3		6005148.8764838	2102292.2742932	37.752785456150605	-122.42508448290899	(37.7527854561506, -122.425084482909)
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)
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)
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)
114784	114784	93255	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1070 Church St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3		6004394.0	2102659.0	37.753749727529396	-122.427721110855	(37.7537497275294, -122.427721110855)
114770	114770	93280	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1485 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004568.0	2100246.0	37.7471340314151	-122.42694753458099	(37.7471340314151, -122.426947534581)
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)
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)
114160	114160	93292	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1059 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004443.0	2102732.0	37.7539529400822	-122.42755685810499	(37.7539529400822, -122.427556858105)
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)
113846	113846	93294	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1037 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004436.0	2102861.0	37.7543067479004	-122.427590255736	(37.7543067479004, -122.427590255736)
113842	113842	6746	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1300X Fairfax Ave	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/14/2007 12:00:00 AM	3	3x3		6017621.9936242	2096730.3826429	37.7382103402349	-122.381562963191	(37.7382103402349, -122.381562963191)
113657	113657	93285	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1289 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004504.0	2101389.0	37.7502688255514	-122.427250247058	(37.7502688255514, -122.427250247058)
113436	113436	93287	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1279 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004501.0	2101449.0	37.750433401942104	-122.427264894728	(37.7504334019421, -122.427264894728)
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)
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)
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)
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)
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)
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)
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)
110579	110579	93290	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1071 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004519.0	2102665.5	37.7537746450798	-122.427289295317	(37.7537746450798, -122.427289295317)

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