Street_Tree_List

Data source: data.sfgov.org

133 rows where SiteOrder = 2 and qSpecies = 88 sorted by qAddress

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
151961	151961	177422	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	0 Santa Ynez Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 4ft		6001061.39064	2091803.12496	37.7237529577069	-122.438468271097	(37.7237529577069, -122.438468271097)
83616	83616	30531	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	100 20th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/02/1986 12:00:00 AM	2	3x3	Permit Number 34534	5989617.18715	2114630.7338900003	37.7857738797228	-122.479698023599	(37.7857738797228, -122.479698023599)
52885	52885	120377	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	101 25th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		5987995.9910699995	2115194.27342	37.7872268871617	-122.485348201277	(37.7872268871617, -122.485348201277)
93883	93883	87912	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	101 Wool St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/18/2008 12:00:00 AM		3x3	Permit Number 50936	6007398.0	2097753.0	37.7404484242714	-122.41698498961	(37.7404484242714, -122.41698498961)
160936	160936	121810	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	106 19th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5989928.89895	2114601.72994	37.7857123459232	-122.478617478776	(37.7857123459232, -122.478617478776)
74720	74720	131004	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1109 Sansome St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6011962.5768099995	2119524.82057	37.8004846103385	-122.402733131341	(37.8004846103385, -122.402733131341)
13472	13472	110653	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1189 Tennessee St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/28/2015 12:00:00 AM	3	3x4		6015597.65588	2103555.7138400003	37.7568393018153	-122.38903859247101	(37.7568393018153, -122.389038592471)
127702	127702	103787	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1217 Polk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006790.1	2115111.0	37.7880752061995	-122.42031857060101	(37.7880752061995, -122.420318570601)
83122	83122	103782	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1237 Polk St	2	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006764.1	2115217.5	37.7883661638156	-122.420416088533	(37.7883661638156, -122.420416088533)
134484	134484	34949	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1246 Bush St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/18/1995 12:00:00 AM	8		Permit Number 38547	6007519.4935099995	2115461.74269	37.7890793334842	-122.417819862092	(37.7890793334842, -122.417819862092)
184199	184199	193331	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1258 Minnesota St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6015302.57075	2102682.83592	37.754426203129	-122.38999814121	(37.754426203129, -122.38999814121)
30570	30570	193337	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1270 Minnesota St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6015308.479069999	2102559.27559	37.7540872603324	-122.389969077812	(37.7540872603324, -122.389969077812)
15315	15315	116934	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1275 Minnesota St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/22/2016 12:00:00 AM	3	5x5		6015367.98495	2102613.01131	37.7542381072096	-122.38976704331999	(37.7542381072096, -122.38976704332)
105089	105089	103774	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1288 Polk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006856.2	2115250.5	37.7884619632914	-122.420099779635	(37.7884619632914, -122.420099779635)
87428	87428	49067	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1298 Ocean Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/02/2008 12:00:00 AM		3x3	Permit Number 50555	5995836.31315767	2092013.47244835	37.724031921729704	-122.45654557668001	(37.7240319217297, -122.45654557668)
145185	145185	99291	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1300 Minnesota St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/01/2012 12:00:00 AM		3x3	Permit Number 768897	6015320.4	2102511.6	37.753957014382	-122.38992452193199	(37.753957014382, -122.389924521932)
96094	96094	88841	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1300 Polk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/12/2008 12:00:00 AM		3x3	Permit Number 51719	6006820.0	2115342.0	37.788711160036996	-122.42023152280301	(37.788711160037, -122.420231522803)
82995	82995	99875	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1301X San Jose Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	3x3		6003616.3	2095455.7	37.733927108519204	-122.429896797189	(37.7339271085192, -122.429896797189)
150867	150867	230315	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	131 Peralta Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6010141.9244099995	2100150.42012	37.7471851875523	-122.407666527004	(37.7471851875523, -122.407666527004)
4899	4899	109487	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1314 POLK ST	2	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		10/31/2017 02:27:00 PM	3	3x3		6006825.7	2115468.8	37.7890596427133	-122.420220804515	(37.7890596427133, -122.420220804515)
22965	22965	103768	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1323 Polk St	2	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006757.0	2115467.0	37.7890508291132	-122.42045837028401	(37.7890508291132, -122.420458370284)
89613	89613	24369	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	134 Duboce Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		07/19/2016 04:44:00 AM	3	3x3		6005829.420761799	2108507.0022787	37.7698880583785	-122.42317275016899	(37.7698880583785, -122.423172750169)
172336	172336	110563	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	135 Theresa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	3x9		6002082.973999999	2093709.6113599997	37.729045795311706	-122.43507312442499	(37.7290457953117, -122.435073124425)
25024	25024	208840	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1350 Plymouth Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		5995903.3540199995	2092975.62657	37.7266776159651	-122.456383367909	(37.7266776159651, -122.456383367909)
160737	160737	193316	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	136 Hawthorne St	2	: 4	Tree 1	Private 1			9	Width 2ft		6013300.831040001	2113672.81478	37.784491007704396	-122.39769151127301	(37.7844910077044, -122.397691511273)
172322	172322	230356	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	137 Randall St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6004658.9023	2097536.10277	37.73969841334279	-122.42644028119	(37.7396984133428, -122.42644028119)
15461	15461	109908	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1401 Howard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		07/18/2015 02:04:00 PM	3	3x3	Permit Number 778313	6008340.42119	2109862.66125	37.773751763372395	-122.414583173274	(37.7737517633724, -122.414583173274)
122862	122862	103867	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1411 Polk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006684.9	2115784.5	37.7899185422019	-122.42073037630101	(37.7899185422019, -122.420730376301)
112678	112678	103864	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1435 Polk St	2	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		08/21/2013 12:00:00 AM	3	3x3		6006674.8	2115856.4	37.790115392534	-122.42077042798	(37.790115392534, -122.42077042798)
124910	124910	93624	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	149 Collins St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/02/2010 12:00:00 AM			Permit Number 53164	5998064.0	2113562.0	37.783326485193	-122.450397500912	(37.783326485193, -122.450397500912)
143719	143719	8223	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1500X Galvez Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/10/2015 08:24:00 AM	3	3x3		6016396.247314	2097296.3974116	37.739696749128896	-122.385840466933	(37.7396967491289, -122.385840466933)
35824	35824	131007	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	150x Drumm St	2	Median : Yard 3	Tree 1	DPW 2			4	Width 7ft		6013687.07221	2117423.5151299997	37.7948110573238	-122.396618254944	(37.7948110573238, -122.396618254944)
43019	43019	130992	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1645 Washington St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6006789.62412	2117015.0975	37.7933033592027	-122.420455425186	(37.7933033592027, -122.420455425186)
119879	119879	94144	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1670 11th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/15/2010 12:00:00 AM		3x3	Permit Number 53556	5992831.3	2104104.9	37.757058944886396	-122.467812361688	(37.7570589448864, -122.467812361688)
153237	153237	50024	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1704 Felton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/28/2003 12:00:00 AM	3		Permit Number 46757	6005953.2164199995	2092396.45471	37.725659158041104	-122.421600147046	(37.7256591580411, -122.421600147046)
174129	174129	193351	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1752 Quesada Ave	2	: 4	Tree 1	Private 1			1	Width 4ft		6014452.02014	2095263.45344	37.734006920685204	-122.392420670182	(37.7340069206852, -122.392420670182)
32960	32960	124335	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	176 Palm Ave	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 2ft		5995959.20478	2113110.98096	37.78196742074471	-122.457646568088	(37.7819674207447, -122.457646568088)
188010	188010	230345	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1801 Church St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004583.18993	2098311.13062	37.7418221830485	-122.42675724096901	(37.7418221830485, -122.426757240969)
135913	135913	208850	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	185 Vasquez Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5994846.41703	2099381.9265400004	37.7442070079607	-122.46050114503001	(37.7442070079607, -122.46050114503)
72706	72706	112523	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	195 02nd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/09/2015 12:00:00 AM	1	3x3	Permit Number 776238	5995199.36548	2114291.31706	37.7851646286632	-122.46036079357799	(37.7851646286632, -122.460360793578)
56984	56984	38711	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2000 McAllister St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/16/2012 12:00:00 AM	1		Permit Number 768631	5999529.3553	2111223.7902	37.7769901198015	-122.44515981121201	(37.7769901198015, -122.445159811212)
81271	81271	96117	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	201 Andover St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/08/2011 12:00:00 AM		3x3	Permit Number 767772	6007577.0	2097739.0	37.7404200508617	-122.41636508469699	(37.7404200508617, -122.416365084697)
188017	188017	94885	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2010 Quesada Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/23/2010 12:00:00 AM	3	3x3	Permit Number 53951	6013050.0613	2096298.0841299999	37.736769849332	-122.39734023878599	(37.736769849332, -122.397340238786)
115603	115603	121600	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	201x San Carlos St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6006718.0	2104916.0	37.7600781154964	-122.419844317752	(37.7600781154964, -122.419844317752)
66641	66641	50836	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	202 Kirkham St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/25/2004 12:00:00 AM			Permit Number 47354	5994277.69303186	2105335.48637483	37.7605212305047	-122.462899497742	(37.7605212305047, -122.462899497742)
160153	160153	193360	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	208 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6014042.14131	2116274.34783	37.7916754675957	-122.395309117238	(37.7916754675957, -122.395309117238)
168749	168749	130985	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2098 Jefferson St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5999249.259269999	2121180.66389	37.8043130782603	-122.44684538130501	(37.8043130782603, -122.446845381305)
161888	161888	217796	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	21 Sloat Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 5ft		5991264.945169999	2095927.55542	37.7345154980788	-122.472633170284	(37.7345154980788, -122.472633170284)
155809	155809	193320	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2111 18th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 4ft		6011400.26798	2105549.24377	37.762079528159795	-122.403695060604	(37.7620795281598, -122.403695060604)
48031	48031	130967	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	213 Walnut St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		5998523.7164	2115638.03819	37.7890530400256	-122.448956666639	(37.7890530400256, -122.448956666639)
142629	142629	87975	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2160 Golden Gate Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/19/2008 12:00:00 AM		3x3	Permit Number 51010	5999212.8	2111613.6	37.778042363793396	-122.446282917617	(37.7780423637934, -122.446282917617)
112214	112214	230331	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	217 Montcalm St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 6ft		6009886.65194	2099610.71375	37.745688979177	-122.40851117835699	(37.745688979177, -122.408511178357)
115316	115316	109088	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	218 28th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		3	3x3		5987170.3	2114494.3	37.7852568239907	-122.488153421892	(37.7852568239907, -122.488153421892)
161788	161788	130997	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2201 Leavenworth St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 3ft		6007578.93915	2119952.7888599997	37.8014139751467	-122.417932677574	(37.8014139751467, -122.417932677574)
110966	110966	87903	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	223 Bocana St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/18/2008 12:00:00 AM		3x3	Permit Number 50920	6007150.2	2097674.7	37.7402194874954	-122.41783623809401	(37.7402194874954, -122.417836238094)
137475	137475	84780	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	224 Mississippi St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/18/2007 12:00:00 AM	4		Permit No. 49287	6013987.25375	2106041.39506	37.7635750422708	-122.39478207494899	(37.7635750422708, -122.394782074949)
116900	116900	104140	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2301X Filbert St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/31/2013 12:00:00 AM		3x3	Permit Number 770728	6001711.91514	2118723.596	37.797706995714606	-122.438147056882	(37.7977069957146, -122.438147056882)
143305	143305	13238	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2322 Lombard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/15/1998 12:00:00 AM	3	3X3		6001219.43305	2119376.81704	37.7994725475626	-122.439898035919	(37.7994725475626, -122.439898035919)
66770	66770	193362	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	246 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6014011.61838	2116245.86436	37.7915955610366	-122.39541273082399	(37.7915955610366, -122.395412730824)
105801	105801	88240	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2501 Turk Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/08/2008 12:00:00 AM		3x3	Permit Number 51228	5998431.6	2111697.4	37.778227810594295	-122.44899139417299	(37.7782278105943, -122.448991394173)
103390	103390	49736	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	251 28th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/04/2003 12:00:00 AM	3	3x12	Permit Number 46536	5987104.42255848	2114202.9919751	37.7844531321546	-122.488359918659	(37.7844531321546, -122.488359918659)
76542	76542	87077	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2565 Larkin St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/18/2007 12:00:00 AM	3	3x3	Permit Number 50014	6006603.98041	2120038.0860099997	37.8015932612686	-122.421312536668	(37.8015932612686, -122.421312536668)
130079	130079	193365	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	260 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6013979.60171	2116214.89575	37.7915087476865	-122.39552133835899	(37.7915087476865, -122.395521338359)
54394	54394	193368	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	262 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6013947.275280001	2116186.44855	37.79142884020779	-122.395631194149	(37.7914288402078, -122.395631194149)
172672	172672	34927	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2625 Baker St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/31/2012 12:00:00 AM	3		Permit Number 768761	5999601.94789	2117876.9745400003	37.7952621734732	-122.44538718908301	(37.7952621734732, -122.445387189083)
188778	188778	230303	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2784 23rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6010083.7548	2102826.7491599997	37.7545305388726	-122.40805638669501	(37.7545305388726, -122.408056386695)
56993	56993	130971	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2801 Webster St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 2ft		6002947.99505	2118332.47012	37.7967032866916	-122.43384191568998	(37.7967032866916, -122.43384191569)
182061	182061	115977	Planning Code 138.1 required 4	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2x Olmstead St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	3x3		6011639.0005	2091249.90123	37.722829925953896	-122.40186416949	(37.7228299259539, -122.40186416949)
134678	134678	130980	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3001 Buchanan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 4ft		6003394.29695	2118690.35312	37.797711256726	-122.43232318378	(37.797711256726, -122.43232318378)
139165	139165	99577	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	301X Noe St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/19/2013 12:00:00 AM		3x3		6002944.2	2106475.3	37.7641462544056	-122.433007480488	(37.7641462544056, -122.433007480488)
64441	64441	249953	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	303 Filbert St	2	Side Yard : Yard 17	Tree 1	Private 1			4	Width 0ft		6011372.652369999	2120041.55492	37.8018704817969	-122.40481091868901	(37.8018704817969, -122.404810918689)
118980	118980	113661	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3060 JACKSON ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/10/2015 12:00:00 AM		5x5	Permit Number 776720	5999534.0	2116404.0	37.7912138957856	-122.44551632933901	(37.7912138957856, -122.445516329339)
28898	28898	250221	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	312 Filbert St	2	Side Yard : Yard 17	Tree 1	Private 1			8	Width 0ft		6011282.00764	2120080.85256	37.8019733165766	-122.405127362244	(37.8019733165766, -122.405127362244)
53809	53809	98842	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	313 Maple St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/14/2012 12:00:00 AM	1		Permit Number 768890	5996633.94495	2115242.03804	37.7878574732038	-122.455466360678	(37.7878574732038, -122.455466360678)
167906	167906	130986	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3147 Gough St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6004613.79741	2120397.19916	37.802466888808496	-122.42822508471599	(37.8024668888085, -122.428225084716)
117699	117699	117276	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3431 19TH ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x6		6006713.0	2104938.0	37.760138240698794	-122.41986317152201	(37.7601382406988, -122.419863171522)
22057	22057	5393	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	347 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/10/2014 12:00:00 AM	3	6x7		6004928.4905	2106245.9446799997	37.7636288523174	-122.426128059965	(37.7636288523174, -122.426128059965)
144702	144702	112554	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	35 DOLORES ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/28/2015 12:00:00 AM		3x3		6004913.0	2108042.0	37.7685595148495	-122.426309519551	(37.7685595148495, -122.426309519551)
184182	184182	230293	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3500 19th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6006188.70146	2104951.15176	37.7601448013679	-122.42167740779301	(37.7601448013679, -122.421677407793)
90133	90133	109758	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3590 20TH ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/01/2015 12:00:00 AM		3x3	Permit Number 772584	6006354.0	2104372.0	37.75856390529879	-122.421064595152	(37.7585639052988, -122.421064595152)
103056	103056	99584	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3599X 16th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/21/2013 12:00:00 AM				6003014.6	2106437.9	37.7640475560396	-122.432761315556	(37.7640475560396, -122.432761315556)
153672	153672	230305	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3689 19th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6005047.22841	2104845.66376	37.7597907229735	-122.42561771539499	(37.7597907229735, -122.425617715395)
110669	110669	89185	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	370 03rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6013271.0	2113050.0	37.782779240858495	-122.39775101659401	(37.7827792408585, -122.397751016594)
39226	39226	230287	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3798 25th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6005284.60936	2101393.03847	37.750324029253505	-122.42455113382299	(37.7503240292535, -122.424551133823)
24130	24130	96862	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	387 29th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/02/2011 12:00:00 AM	2	3x3	Permit Number 768142	5986827.805480001	2113344.76478	37.7820805427479	-122.48925378416	(37.7820805427479, -122.48925378416)
122771	122771	46568	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3900 22nd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/08/2008 12:00:00 AM		3x3	Permit Number 51812	6002455.82917315	2102994.91492425	37.754562242839704	-122.43444775294701	(37.7545622428397, -122.434447752947)
68652	68652	124611	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3931 Clay St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5995971.07063	2115182.72875	37.787656567418	-122.457755475318	(37.787656567418, -122.457755475318)
143622	143622	87071	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	395 Byxbee St	2	Front Yard : Cutout 8	Tree 1	Private 1		12/18/2007 12:00:00 AM			Permit Number 50011	5991947.0	2091188.0	37.7215413135876	-122.469930130394	(37.7215413135876, -122.469930130394)
165587	165587	208854	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	403 Baden St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6000738.2575199995	2095246.2380099997	37.7331885682037	-122.439832030035	(37.7331885682037, -122.439832030035)
66578	66578	70266	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	414 23rd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/17/1996 12:00:00 AM	8			5988762.33088	2112478.2196299997	37.7798139854521	-122.482497769619	(37.7798139854521, -122.482497769619)
10963	10963	108843	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	420 Woolsey St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/2015 12:00:00 AM	3		Permit Number 772583	6010519.109209999	2091869.71455	37.7244692416558	-122.40577905416201	(37.7244692416558, -122.405779054162)
91852	91852	112388	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	4200 18th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6002010.54318716	2105309.8458945	37.760893198333704	-122.436153317055	(37.7608931983337, -122.436153317055)
116356	116356	26561	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	430 Bay Shore Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/10/2007 12:00:00 AM	3	3X3		6010306.750370901	2097855.6706051	37.740893529599106	-122.406934857164	(37.7408935295991, -122.406934857164)
79183	79183	87126	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	438 33rd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/08/2008 12:00:00 AM		3x3	Permit Number 50074	5985668.2	2112929.7	37.7808731376826	-122.493234847229	(37.7808731376826, -122.493234847229)
149661	149661	95133	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	450@ Wayland Somerset St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/04/2010 12:00:00 AM	1	3x3	Permit Number 54066	6010089.84133	2092358.2905700002	37.725786753837	-122.407297408351	(37.725786753837, -122.407297408351)
143971	143971	114720	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	465 Woolsey St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/02/2015 12:00:00 AM			Permit Number 774759	6010466.6	2091788.0	37.724241933851296	-122.405954818575	(37.7242419338513, -122.405954818575)
68243	68243	87490	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	496 38th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/16/2008 12:00:00 AM	1	3x3	Permit Number 50390	5984109.08074	2112532.5405200003	37.77969133885821	-122.498599173652	(37.7796913388582, -122.498599173652)
126909	126909	95564	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	497 Elizabeth St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/02/2011 12:00:00 AM		3x3	Permit Number 767357	6003239.0	2102086.6	37.75211264995529	-122.43167449646799	(37.7521126499553, -122.431674496468)
171597	171597	105251	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	500 36th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/08/2014 12:00:00 AM	1		Permit Number 771049	5984733.08187	2112389.43293	37.779334982299794	-122.496429952441	(37.7793349822998, -122.496429952441)
73090	73090	123057	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	514 Funston Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5991919.1397400005	2111920.98536	37.778467110254795	-122.47153646453998	(37.7784671102548, -122.47153646454)

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