Street_Tree_List

Data source: data.sfgov.org

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

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
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
49219	49219	247756	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	52 Alpine Ter	2	: 4	Tree 1	Private 1			3	Width 3ft		6001615.48849	2108494.65039	37.7696154359451	-122.437747736977	(37.7696154359451, -122.437747736977)
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)
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)
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)
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)
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)
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)
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)
31130	31130	177416	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	538 Madrid St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6002518.22292	2090772.4099400002	37.721005605292504	-122.433358634398	(37.7210056052925, -122.433358634398)
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)
36649	36649	177403	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	688 Vienna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		6002695.8436900005	2089531.77748	37.7176091789075	-122.432656076817	(37.7176091789075, -122.432656076817)
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)
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)
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)
11033	11033	83366	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	618 Athens St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/01/2009 12:00:00 AM	3	3x3	Permit Number 52311	6003144.474669999	2089738.5573200001	37.718202383405206	-122.43112011482701	(37.7182023834052, -122.431120114827)
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)
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)
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)
2517	2517	178826	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	927 Brazil Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6004356.8834	2090741.4764900003	37.7210248094256	-122.427000725205	(37.7210248094256, -122.427000725205)
55977	55977	230279	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	529 Buchanan St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 6ft		6004554.65684	2110370.74902	37.774933432055	-122.42771494250499	(37.774933432055, -122.427714942505)
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)
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)
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)
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)
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)
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)
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)
48337	48337	230332	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	73 Leese St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6005526.20735	2096295.99594	37.736342348511	-122.423353372654	(37.736342348511, -122.423353372654)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
4168	4168	13059	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	583 Lombard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/28/2015 07:23:00 AM	3	2x2		6009557.0524	2120495.5376	37.8030153566132	-122.41112585507	(37.8030153566132, -122.41112585507)
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)
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)
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)
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)
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)

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