Street_Tree_List

Data source: data.sfgov.org

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

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
507	507	251288	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1335 Fairfax Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2	Private 3	03/18/2017 01:58:00 PM	3	3x3		6016828.0	2097292.0	37.7397085577181	-122.38434732981199	(37.7397085577181, -122.384347329812)
511	511	251164	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1215 Fairfax Ave	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/10/2017 01:46:00 PM	3	3x3		6017471.0	2096747.0	37.738247630240295	-122.382086185189	(37.7382476302403, -122.382086185189)
1124	1124	29774	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1100X Evans Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/03/2017 12:44:00 PM	3	3x3		6018183.3236	2096672.8034	37.7380832156692	-122.37961814277901	(37.7380832156692, -122.379618142779)
2200	2200	252931	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	71 Edgar Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5997064.0	2091155.0	37.7217451669512	-122.45223976154499	(37.7217451669512, -122.452239761545)
4901	4901	18480	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1298 Potrero Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/31/2017 01:20:00 PM	3	3x3		6010561.39126	2101710.28558	37.751491708090896	-122.406325925618	(37.7514917080909, -122.406325925618)
9079	9079	6769	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1275 Fairfax Ave	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/27/2007 12:00:00 AM	3	3x3		6017217.4089567	2096970.3613046003	37.738846926957706	-122.382978527185	(37.7388469269577, -122.382978527185)
9121	9121	85732	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	901 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/30/2007 12:00:00 AM	3	3x3		6011193.193535	2112605.183477	37.7814419523203	-122.404908060988	(37.7814419523203, -122.404908060988)
9231	9231	6725	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1200X Fairfax Ave	22	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/05/2008 12:00:00 AM	3	3x3		6017621.9936242	2096730.3826429	37.7382103402349	-122.381562963191	(37.7382103402349, -122.381562963191)
9244	9244	87452	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	601 Dolores St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/28/2008 12:00:00 AM	4	3x3		6004976.0	2104871.0	37.7598562652774	-122.425865863079	(37.7598562652774, -122.425865863079)
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)
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)
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)
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)
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)
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)
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)
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)
19158	19158	5458	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	589 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/20/2009 12:00:00 AM	90	3x3		6004996.57492	2104960.58209	37.7601033992601	-122.42580108085801	(37.7601033992601, -122.425801080858)
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)
22956	22956	103844	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1541 Polk St	2	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006635.7	2116216.3	37.791101384779296	-122.420931274285	(37.7911013847793, -122.420931274285)
22970	22970	103849	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1524 Polk St	2	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006765.8	2116184.9	37.7910225007002	-122.420478902042	(37.7910225007002, -122.420478902042)
22978	22978	103850	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1524 Polk St	3	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006765.8	2116184.9	37.7910225007002	-122.420478902042	(37.7910225007002, -122.420478902042)
66030	66030	103847	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1529 Polk St	1	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006640.1	2116184.7	37.7910148670423	-122.42091380589399	(37.7910148670423, -122.420913805894)
77688	77688	93269	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1730 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004618.0	2098811.0	37.743196678206296	-122.42667246707799	(37.7431966782063, -122.426672467078)
78052	78052	103838	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	900X O'Farrell St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006751.076230001	2113939.67696	37.78485684194221	-122.420370415446	(37.7848568419422, -122.420370415446)
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)
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)
81232	81232	93286	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1283 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004502.0	2101425.0	37.7503675600759	-122.427259727267	(37.7503675600759, -122.427259727267)
82685	82685	103874	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1331 Polk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006716.3	2115545.2	37.7892632533111	-122.42060474068998	(37.7892632533111, -122.42060474069)
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)
83349	83349	93300	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	589X Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/12/2008 12:00:00 AM	3	3x3		6004575.9	2105667.0	37.7620192734995	-122.427306317148	(37.7620192734995, -122.427306317148)
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)
84499	84499	103835	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	900X O'Farrell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006751.076230001	2113939.67696	37.78485684194221	-122.420370415446	(37.7848568419422, -122.420370415446)
84828	84828	93291	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1065 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004445.0	2102697.0	37.753856951407705	-122.42754744828301	(37.7538569514077, -122.427547448283)
84975	84975	93277	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1565 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004670.9	2099777.3	37.7458529070189	-122.426558345234	(37.7458529070189, -122.426558345234)
85134	85134	93273	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1679 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004706.9	2099119.3	37.7440482251279	-122.42638702061701	(37.7440482251279, -122.426387020617)
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)
85581	85581	93267	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1550 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004563.0	2099865.0	37.746087610537295	-122.426937693393	(37.7460876105373, -122.426937693393)
85944	85944	93266	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1440 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004482.7	2100527.8	37.747902965476	-122.42726256538602	(37.747902965476, -122.427262565386)
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)
86562	86562	103851	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1524 Polk St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/21/2013 12:00:00 AM	3	3x3		6006765.8	2116184.9	37.7910225007002	-122.420478902042	(37.7910225007002, -122.420478902042)
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)
87496	87496	103843	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1541 Polk St	1	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006635.7	2116216.3	37.791101384779296	-122.420931274285	(37.7911013847793, -122.420931274285)
87716	87716	93293	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1049 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004440.0	2102791.0	37.7541147705659	-122.42757143594	(37.7541147705659, -122.42757143594)
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)
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)
88852	88852	93281	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1465 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004562.0	2100365.0	37.747460438671105	-122.426976756198	(37.7474604386711, -122.426976756198)
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)
90042	90042	93288	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1259 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004494.0	2101568.0	37.7507597523824	-122.42729757712601	(37.7507597523824, -122.427297577126)
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)
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)
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)
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)
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)
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)
95708	95708	103848	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1524 Polk St	1	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006765.8	2116184.9	37.7910225007002	-122.420478902042	(37.7910225007002, -122.420478902042)
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)
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)
97539	97539	93284	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1347 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004523.0	2101050.0	37.7493390847523	-122.427160399995	(37.7493390847523, -122.427160399995)
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)
98869	98869	93275	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1607 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004606.0	2099539.0	37.7451949208192	-122.42676579302	(37.7451949208192, -122.42676579302)
99080	99080	103792	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1214 Polk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2009 12:00:00 AM	3	3x3		6006878.4	2115091.6	37.7880269138329	-122.420011690177	(37.7880269138329, -122.420011690177)
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)
99600	99600	103846	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1540 Polk St	2	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006747.0	2116248.1	37.7911949727431	-122.42054843762399	(37.7911949727431, -122.420548437624)
99675	99675	103845	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1540 Polk St	1	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006747.0	2116248.1	37.7911949727431	-122.42054843762399	(37.7911949727431, -122.420548437624)
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)
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)
100513	100513	93282	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1383 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004535.0	2100841.0	37.748765897796204	-122.42710401922199	(37.7487658977962, -122.427104019222)
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)
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)
101720	101720	93272	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1689 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004632.0	2099057.0	37.7438729293821	-122.42664157265	(37.7438729293821, -122.42664157265)
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)
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)
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)
103470	103470	103793	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1214 Polk St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2009 12:00:00 AM	3	3x3		6006878.4	2115091.6	37.7880269138329	-122.420011690177	(37.7880269138329, -122.420011690177)
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)
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)
104380	104380	103834	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	900X O'Farrell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006751.076230001	2113939.67696	37.78485684194221	-122.420370415446	(37.7848568419422, -122.420370415446)
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)
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)
107651	107651	103837	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	900X O'Farrell St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006751.076230001	2113939.67696	37.78485684194221	-122.420370415446	(37.7848568419422, -122.420370415446)
108745	108745	93276	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1603 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004604.0	2099562.0	37.7452579604553	-122.426774346316	(37.7452579604553, -122.426774346316)
109604	109604	93274	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1613 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004607.0	2099503.0	37.7450961296299	-122.426759771954	(37.7450961296299, -122.426759771954)
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)
110080	110080	93283	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1377 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004533.0	2100877.0	37.7488646323576	-122.427113499044	(37.7488646323576, -122.427113499044)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)

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