Street_Tree_List

Data source: data.sfgov.org

243 rows where PlotSize = "3x3" 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: 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
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)
21837	21837	5348	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	200X Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/22/2010 12:00:00 AM	12	3x3	Permit Number 53640	6004789.9063099995	2107160.01438	37.7661308355062	-122.426672475382	(37.7661308355062, -122.426672475382)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
82006	82006	32722	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	644 Hyde St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/30/2011 12:00:00 AM	3	3x3	Permit Number 768334	6007901.48303797	2114768.35798987	37.7871969578975	-122.416449089052	(37.7871969578975, -122.416449089052)
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)
86147	86147	55564	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1X CASELLI AVE	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/12/2008 12:00:00 AM		3x3	Permit Number 50796	6000842.0	2104917.0	37.7597480805722	-122.44016661153098	(37.7597480805722, -122.440166611531)
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)
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)
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)
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)
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)
100706	100706	85720	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1133 Howard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/30/2007 12:00:00 AM	3	3x3		6009666.355548	2111144.506481	37.777345813652	-122.41008705150699	(37.777345813652, -122.410087051507)
109929	109929	85721	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1049 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/30/2007 12:00:00 AM	3	3x3		6010189.0	2111652.0	37.778768551926795	-122.408314849736	(37.7787685519268, -122.408314849736)
79013	79013	85727	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1025 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/16/2007 12:00:00 AM	3	3x3		6010365.0	2111820.0	37.7792396944918	-122.40771784288	(37.7792396944918, -122.40771784288)
141707	141707	85728	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1025 Howard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/16/2007 12:00:00 AM	3	3x3		6010365.0	2111820.0	37.7792396944918	-122.40771784288	(37.7792396944918, -122.40771784288)
9121	9121	85732	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	901 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/30/2007 12:00:00 AM	3	3x3		6011193.193535	2112605.183477	37.7814419523203	-122.404908060988	(37.7814419523203, -122.404908060988)
9463	9463	85733	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	901 Howard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/30/2007 12:00:00 AM	4	3x3		6011193.193535	2112605.183477	37.7814419523203	-122.404908060988	(37.7814419523203, -122.404908060988)
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)
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)
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)
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)
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)
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)
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)
115233	115233	85817	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1581 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/18/2007 12:00:00 AM	3	3x3		6007957.739489	2109502.485486	37.7727412989479	-122.415881423672	(37.7727412989479, -122.415881423672)
118449	118449	85818	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1525 Howard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/18/2007 12:00:00 AM	3	3x3		6007957.0	2109502.0	37.7727399243445	-122.415883947269	(37.7727399243445, -122.415883947269)
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)
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)
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)
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)
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)
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)
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)
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)
105427	105427	86795	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	445 Wawona St	2	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)
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)
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)
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)
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)
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)
102897	102897	87853	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	599 Moultrie St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/11/2008 12:00:00 AM		3x3	Permit Number 50764	6007684.0	2096571.0	37.7372189966792	-122.415912430403	(37.7372189966792, -122.415912430403)
102655	102655	87857	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1X CASELLI AVE	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/12/2008 12:00:00 AM		3x3	Permit Number 50796	6000842.0	2104917.0	37.7597480805722	-122.44016661153098	(37.7597480805722, -122.440166611531)
59156	59156	87882	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1771 North Point St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/13/2008 12:00:00 AM	6	3x3	Permit Number 50853	6002283.00879	2120864.7759700003	37.8036185768076	-122.436324238766	(37.8036185768076, -122.436324238766)
84744	84744	88349	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	100 Vienna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/10/2008 12:00:00 AM		3x3	Permit Number 51332	6004690.8	2092754.8	37.7265718296959	-122.425989720183	(37.7265718296959, -122.425989720183)
90378	90378	88350	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	100 Vienna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/10/2008 12:00:00 AM		3x3	Permit Number 51332	6004690.8	2092754.8	37.7265718296959	-122.425989720183	(37.7265718296959, -122.425989720183)
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)
103131	103131	88442	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1148 Treat Ave		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/11/2008 12:00:00 AM		3x3	Permit Number 51406	6008612.9	2101850.1	37.7517664174328	-122.413073954345	(37.7517664174328, -122.413073954345)
97097	97097	88749	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	990 Polk St	6	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)

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