Street_Tree_List

Data source: data.sfgov.org

149 rows where qLegalStatus = 3 and qSpecies = 90 sorted by TreeID

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

Link	rowid	TreeID ▼	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
93529	93529	2	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	850X Lake St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/25/2009 12:00:00 AM	3	3X3		5992872.52482	2114854.21479	37.78657606668221	-122.468451837381	(37.7865760666822, -122.468451837381)
98187	98187	434	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	890X Potrero Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/14/2013 12:00:00 AM	3	3x3		6010425.429178201	2104052.7086425	37.7579158746071	-122.406961184613	(37.7579158746071, -122.406961184613)
139100	139100	2389	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2642X Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/11/2007 12:00:00 AM	3	3X3		6009749.5258463	2101948.1671123	37.752099429361294	-122.409150251369	(37.7520994293613, -122.409150251369)
85160	85160	2390	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2642X Bryant St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/11/2007 12:00:00 AM	3	3X3		6009749.5258463	2101948.1671123	37.752099429361294	-122.409150251369	(37.7520994293613, -122.409150251369)
122456	122456	3904	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	84 Castro St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/13/2014 11:00:00 AM	3	2X2		6002180.9408165	2107753.3024618	37.7676120130603	-122.435738811724	(37.7676120130603, -122.435738811724)
21383	21383	3929	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	100X Castro St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		07/18/2014 12:00:00 AM	3	2x2		6002188.32938	2107609.3026900003	37.7672170447484	-122.43570295204799	(37.7672170447484, -122.435702952048)
110651	110651	4421	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1133 Church St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		08/23/2012 12:00:00 AM	3	4X4	Permit Number 769145	6004474.71062	2102295.4201	37.7527559874039	-122.42741609607201	(37.7527559874039, -122.427416096072)
91376	91376	4894	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	745X Mansell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/29/2007 12:00:00 AM	3	3X3		6009751.8988059005	2090059.5024836997	37.7194558413593	-122.408303589874	(37.7194558413593, -122.408303589874)
1590	1590	5343	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	180 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/24/2014 02:20:00 PM	3	3X3		6004776.7961099995	2107352.0132	37.7666572770255	-122.426731495165	(37.7666572770255, -122.426731495165)
20240	20240	5355	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	214 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		09/03/2009 12:00:00 AM	3	6		6004795.29962	2107076.64131	37.765902217941296	-122.42664788340099	(37.7659022179413, -122.426647883401)
21175	21175	5356	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	220 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		07/11/2015 03:17:00 PM	3	6x6	posted for removal 3/27/14 DPW	6004796.958190001	2107043.90776	37.765812433218706	-122.426639815582	(37.7658124332187, -122.426639815582)
91447	91447	5370	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	265 DOLORES ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		07/11/2015 03:03:00 PM	3	3X3		6005008.2	2106862.7	37.765326820302	-122.42589627439101	(37.765326820302, -122.425896274391)
114295	114295	5385	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	325X Dolores St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/16/2013 12:00:00 AM		4X4		6004919.4864142	2106495.5645768	37.7643137401636	-122.426176974515	(37.7643137401636, -122.426176974515)
18110	18110	5394	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	347 Dolores St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/27/2014 12:00:00 AM	2	7x5		6004926.5455599995	2106285.12827	37.7637363311974	-122.426137576609	(37.7637363311974, -122.426137576609)
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)
82178	82178	5416	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	430X Dolores St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/11/2011 12:00:00 AM	3	6x150		6004853.970832599	2105864.857711	37.7625782660478	-122.42635866544599	(37.7625782660478, -122.426358665446)
20723	20723	5477	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	655 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	3X3		6005026.79294	2104432.16218	37.7586541903676	-122.42565896099899	(37.7586541903676, -122.425658960999)
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)
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)
138373	138373	9306	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	240X Mansell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/29/2007 12:00:00 AM	3	3X100		6011154.1519898	2090628.8663314	37.7210976210121	-122.403496526224	(37.7210976210121, -122.403496526224)
106121	106121	9308	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	240X Mansell St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/29/2007 12:00:00 AM	3	3X100		6011154.1519898	2090628.8663314	37.7210976210121	-122.403496526224	(37.7210976210121, -122.403496526224)
17294	17294	10232	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	11 Haight St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/30/2002 12:00:00 AM	8			6005984.55063	2109644.68395	37.7730206127534	-122.422717019597	(37.7730206127534, -122.422717019597)
20720	20720	10236	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	33 Haight St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/30/2002 12:00:00 AM	8	4X4		6005944.57875	2109639.18298	37.7730032531225	-122.42285489644699	(37.7730032531225, -122.422854896447)
79321	79321	10342	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	935 Haight St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/04/2011 12:00:00 AM	3	4x4		6001663.937059999	2109024.15924	37.7710720905099	-122.437618081823	(37.7710720905099, -122.437618081823)
118815	118815	11953	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1436 Kirkwood Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/27/2007 12:00:00 AM	6	3X4		6015854.7568499	2096315.1604746997	37.7369724919298	-122.38764428476802	(37.7369724919298, -122.387644284768)
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)
127402	127402	13061	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	583 Lombard St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/01/2013 12:00:00 AM	12	2X2		6009566.8887098	2120490.1657189	37.8030011583731	-122.411091436508	(37.8030011583731, -122.411091436508)
90907	90907	13340	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	230 Mansell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/29/2007 12:00:00 AM	3	3X24		6011187.2509688	2090638.9738565	37.721127222942	-122.40338282278499	(37.721127222942, -122.403382822785)
138443	138443	15056	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1441 Mendell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/26/2012 12:00:00 AM	3	4x4		6015002.0	2095363.0	37.7343107811298	-122.390526157796	(37.7343107811298, -122.390526157796)
14910	14910	17426	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1869 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/05/2015 01:06:00 PM	3	3X3		6013447.639169999	2096284.8118900002	37.736755533926	-122.39596469871401	(37.736755533926, -122.395964698714)
14973	14973	18344	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	440 Potrero Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		07/16/2015 07:27:00 AM	3	3X3		6010309.570730001	2106285.64769	37.7640405376657	-122.40751930078001	(37.7640405376657, -122.40751930078)
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)
85651	85651	18391	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	874 Potrero Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/14/2013 12:00:00 AM	3	4x4		6010420.6643105	2104143.6455038004	37.7581653002339	-122.406984073056	(37.7581653002339, -122.406984073056)
85642	85642	18418	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	645X POTRERO AVE	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/02/2016 12:00:00 AM	3	3X3		6010440.0	2105310.0	37.7613689295586	-122.40699940993099	(37.7613689295586, -122.406999409931)
17773	17773	18420	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	924 Potrero Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/14/2013 12:00:00 AM	3	3x3		6010442.48956	2103839.41038	37.7573311599314	-122.406887149344	(37.7573311599314, -122.406887149344)
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)
21685	21685	18423	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	952 Potrero Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/20/2013 12:00:00 AM	3	3x3		6010455.30853	2103703.2834799998	37.75695810316021	-122.406833222372	(37.7569581031602, -122.406833222372)
4901	4901	18480	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1298 Potrero Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/31/2017 01:20:00 PM	3	3x3		6010561.39126	2101710.28558	37.751491708090896	-122.406325925618	(37.7514917080909, -122.406325925618)
4892	4892	21646	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1660 Sutter St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/31/2017 01:25:00 PM	3	3X4		6004679.2621	2114722.8807	37.7868903572795	-122.427594040592	(37.7868903572795, -122.427594040592)
114281	114281	26918	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2000X Bay Shore Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/19/2010 12:00:00 AM	3	3X3		6012375.8565272	2088505.2474916999	37.7153347551878	-122.399124435859	(37.7153347551878, -122.399124435859)
92111	92111	29047	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	244 11th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		07/31/2012 12:00:00 AM	3	3x3		6008230.7231960995	2109406.8924959	37.7724941663121	-122.414930372766	(37.7724941663121, -122.414930372766)
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)
79518	79518	29856	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1800X Evans Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/12/2011 12:00:00 AM	3	4x4		6014606.392164	2099329.1692391	37.745179108267	-122.392171198439	(37.745179108267, -122.392171198439)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
91361	91361	91421	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2112 15th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/26/2008 12:00:00 AM		3x3	Permit Number 52102; tree 1 on Sanchez (DPW-maintained); maintenance agreement through 4/8/2012	6003571.0	2107157.0	37.7660535712373	-122.430888215554	(37.7660535712373, -122.430888215554)
127472	127472	91422	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2112 15th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/26/2008 12:00:00 AM		3x3	Permit Number 52102; Tree 2 on Sanchez (DPW-maintained); maintenance agreement through 4/8/2012	6003571.0	2107157.0	37.7660535712373	-122.430888215554	(37.7660535712373, -122.430888215554)
18377	18377	93250	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1050 Church St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3		6004388.0	2102776.0	37.754070642695496	-122.42775019598	(37.7540706426955, -122.42775019598)
106888	106888	93251	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1060 CHURCH ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3		6004371.0	2102721.0	37.753918663927706	-122.42780506745899	(37.7539186639277, -122.427805067459)
83075	83075	93252	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1070 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3		6004394.0	2102659.0	37.753749727529396	-122.427721110855	(37.7537497275294, -122.427721110855)
94013	94013	93253	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1070 Church St	2	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)
102183	102183	93254	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1070 Church St	3	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)
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)
106002	106002	93256	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1120 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3	Owner Michael Freethy signed agreement on 12/26/09 to maintain curb cut added within 4' of tree after tree was planted	6004410.0	2102371.0	37.7529598520175	-122.427645261537	(37.7529598520175, -122.427645261537)
102730	102730	93257	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1180X Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004390.8	2101994.4	37.7519247103798	-122.42768482883699	(37.7519247103798, -122.427684828837)
92614	92614	93258	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1180X Church St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004390.8	2101994.4	37.7519247103798	-122.42768482883699	(37.7519247103798, -122.427684828837)
100755	100755	93259	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1234 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004459.0	2101704.0	37.7511311972424	-122.42742829765899	(37.7511311972424, -122.427428297659)
91448	91448	93260	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1250X Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004401.7	2101569.1	37.750757552311704	-122.427616837084	(37.7507575523117, -122.427616837084)
103768	103768	93261	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1252 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004465.0	2101602.0	37.750851468343896	-122.427400283526	(37.7508514683439, -122.427400283526)
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)
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)
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)

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