Street_Tree_List

Data source: data.sfgov.org

133 rows where SiteOrder = 2 and qSpecies = 88 sorted by rowid descending

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by TreeID Sort by qLegalStatus Sort by qSpecies Sort by qAddress Sort by SiteOrder Sort by qSiteInfo Sort by PlantType Sort by qCaretaker Sort by qCareAssistant Sort by PlantDate Sort by DBH Sort by PlotSize Sort by PermitNotes Sort by XCoord Sort by YCoord Sort by Latitude Sort by Longitude Sort by Location

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize

Link	rowid ▲	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
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)
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)
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)
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)
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)
182454	182454	193375	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	778 Tehama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6008954.62424	2110209.1337900003	37.774737583109705	-122.41248303597901	(37.7747375831097, -122.412483035979)
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)
181425	181425	193353	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	75 Latona St	2	: 4	Tree 1	Private 1			2	Width 2ft		6014356.71381	2094130.9148900001	37.730891907436295	-122.392670976684	(37.7308919074363, -122.392670976684)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
159964	159964	193358	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	62 Main St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6014021.3474	2116423.46881	37.79208376250261	-122.395391515812	(37.7920837625026, -122.395391515812)
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)
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)
153469	153469	131001	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	937 Lombard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6007906.15602	2120261.72441	37.80228064460721	-122.416822257668	(37.8022806446072, -122.416822257668)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
135826	135826	99539	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	801X Central Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/16/2012 12:00:00 AM	1	3x3	Permit Number 768631	5999563.7	2111218.2	37.776976730821794	-122.445040600733	(37.7769767308218, -122.445040600733)
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)
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)
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)
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)
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)
126468	126468	105848	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	790 Tehama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6008900.0	2110136.0	37.774533709285706	-122.41266682187201	(37.7745337092857, -122.412666821872)
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)
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)
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)
120151	120151	88327	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	559 Lisbon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/10/2008 12:00:00 AM		3x3	Permit Number 51315	6001911.0	2090236.0	37.7194982755804	-122.43541926902701	(37.7194982755804, -122.435419269027)
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)
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)
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)
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)
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)
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)
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)
113248	113248	112574	Section 143 8	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	56 ROCKWOOD CT	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/31/2015 12:00:00 AM		3x6	Permit Number 776002	5995685.0	2098946.0	37.7430582687021	-122.457569991387	(37.7430582687021, -122.457569991387)
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)
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)
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)
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)
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)
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)
103987	103987	108663	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	842 43rd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/30/2014 12:00:00 AM	3	3x3	Permit Number 772817	5982645.59315	2110033.9904099996	37.7727451127869	-122.50347686125099	(37.7727451127869, -122.503476861251)
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)
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)
100026	100026	87899	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	700 Eugenia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/18/2008 12:00:00 AM		3x3	Permit Number 50917	6007438.0	2097723.6	37.740369948387794	-122.41684460251801	(37.7403699483878, -122.416844602518)
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)
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)
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)
91295	91295	98410	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	55 19th Ave	2	Sidewalk: Curb side : 21	Tree 1	Private 1		02/09/2012 12:00:00 AM			Permit Number 768592	5990099.2	2106073.1	37.7623049568555	-122.477404745944	(37.7623049568555, -122.477404745944)
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)
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)
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)
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)
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)
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)
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)
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)
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)
75167	75167	177436	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	99 Karen Ct	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6010107.2934	2091444.47715	37.7232785896114	-122.40717269128099	(37.7232785896114, -122.407172691281)
74944	74944	230336	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	823 Castro St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6002471.62973	2103413.82046	37.7557133541918	-122.434423059382	(37.7557133541918, -122.434423059382)
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)
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)
73056	73056	123366	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	780 04th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5994765.69029	2110380.32738	37.774401141157796	-122.461577514019	(37.7744011411578, -122.461577514019)
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)
71769	71769	177406	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	618 Edinburgh St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6002461.15734	2090172.80832	37.7193559950662	-122.433513065093	(37.7193559950662, -122.433513065093)
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)
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)
68072	68072	250185	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	665 Parker Ave	2	: 4	Tree 1	Private 1			2	Width 4ft		5997218.614440001	2110901.95743	37.7759742867055	-122.453130096488	(37.7759742867055, -122.453130096488)
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)
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)
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)
65862	65862	130969	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	95 Heather Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1			5997355.4901	2113891.63765	37.7841910082488	-122.452872452398	(37.7841910082488, -122.452872452398)
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)
62272	62272	177397	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	650 France Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 4ft		6002573.73742	2089477.3552599999	37.717452821874105	-122.433074256169	(37.7174528218741, -122.433074256169)
57463	57463	193356	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	60 Main St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6014000.33626	2116445.25726	37.7921424198756	-122.395465742269	(37.7921424198756, -122.395465742269)
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)
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)

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