Street_Tree_List

Data source: data.sfgov.org

830 rows where qSpecies = 88 sorted by TreeID 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

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

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

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

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

Link	rowid	TreeID ▲	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
3902	3902	253544	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1000 Cayuga Ave	12	Back Yard : Yard 13	Tree 1	DPW 2		10/03/2017 02:38:00 PM	3	3x3		6000652.979169999	2091201.14277	37.7220768117153	-122.43983693715201	(37.7220768117153, -122.439836937152)
3900	3900	253543	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1000 Cayuga Ave	11	Back Yard : Yard 13	Tree 1	DPW 2		10/03/2017 02:35:00 PM	3	3x3		6000652.979169999	2091201.14277	37.7220768117153	-122.43983693715201	(37.7220768117153, -122.439836937152)
3896	3896	253542	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1000 Cayuga Ave	10	Back Yard : Yard 13	Tree 1	DPW 2		10/03/2017 02:42:00 PM	3	3x3		6000652.979169999	2091201.14277	37.7220768117153	-122.43983693715201	(37.7220768117153, -122.439836937152)
3899	3899	253541	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1000 Cayuga Ave	9	Back Yard : Yard 13	Tree 1	DPW 2		10/03/2017 03:59:00 PM	3	3x3		6000652.979169999	2091201.14277	37.7220768117153	-122.43983693715201	(37.7220768117153, -122.439836937152)
3906	3906	253540	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1000 Cayuga Ave	8	Back Yard : Yard 13	Tree 1	DPW 2		10/03/2017 04:11:00 PM	3	3x3		6000652.979169999	2091201.14277	37.7220768117153	-122.43983693715201	(37.7220768117153, -122.439836937152)
3318	3318	253415	Planning Code 138.1 required 4	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	55 Stoneybrook Ave		Front Yard : Cutout 8	Tree 1	Private 1		08/31/2017 12:00:00 AM	3		Permit Number 779907	6005926.97731	2093972.4268599998	37.729984953042795	-122.421802746417	(37.7299849530428, -122.421802746417)
3174	3174	253344	Planning Code 138.1 required 4	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2586 30th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/23/2017 12:00:00 AM	3	4x4	Permit Number 780063	5987098.36417	2097677.28593	37.7390777358027	-122.487166705945	(37.7390777358027, -122.487166705945)
5195	5195	253341	Planning Code 138.1 required 4	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1935 46th Ave	1	Sidewalk: Property side : Cutout 5	Tree 1	Private 1		08/23/2017 12:00:00 AM	3	3x3	Permit Number 769984	5981944.6810099995	2101921.14451	37.750428327874204	-122.505299944249	(37.7504283278742, -122.505299944249)
1480	1480	251545	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	347 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				3x3		6004948.0	2106317.0	37.7638250559684	-122.426065641314	(37.7638250559684, -122.426065641314)
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)
60128	60128	250187	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	665 Parker Ave	4	: 4	Tree 1	Private 1			1	Width 4ft		5997222.68042	2110871.6887	37.7758914096851	-122.453113845732	(37.7758914096851, -122.453113845732)
169196	169196	250186	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	665 Parker Ave	3	: 4	Tree 1	Private 1			2	Width 4ft		5997220.39466	2110886.1472400003	37.7759309780695	-122.4531227967	(37.7759309780695, -122.4531227967)
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)
44983	44983	250184	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	665 Parker Ave	1	: 4	Tree 1	Private 1			2	Width 4ft		5997216.13133	2110917.44789	37.7760166771611	-122.45313980466699	(37.7760166771611, -122.453139804667)
165775	165775	249954	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	303 Filbert St	1	Side Yard : Yard 17	Tree 1	Private 1			3	Width 0ft		6011374.5207	2120037.6372700003	37.8018598293151	-122.404804177386	(37.8018598293151, -122.404804177386)
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)
71813	71813	249952	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	303 Filbert St	3	Side Yard : Yard 17	Tree 1	Private 1			2	Width 0ft		6011371.46837	2120040.8031	37.801868351303796	-122.40481496294399	(37.8018683513038, -122.404814962944)
75481	75481	249813	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	260 Chestnut St	3	Front Yard : Yard 7	Tree 1	Private 1			3	Width 0ft		6010621.11973	2121031.8935700003	37.8045476726861	-122.407481446514	(37.8045476726861, -122.407481446514)
528	528	248942	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1500x Galvez Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2	Private 3	03/18/2017 12:56:00 PM	3	3x3		6016393.0	2097292.0	37.739684495027205	-122.385851388433	(37.7396844950272, -122.385851388433)
1063	1063	248924	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	201x Cashmere St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2	Private 3	04/29/2017 10:39:00 AM	3	3x3		6016272.0	2096170.0	37.7365970133228	-122.38619155869101	(37.7365970133228, -122.386191558691)
66618	66618	248252	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	110 Lundy's Ln	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6006810.41598	2098914.4324	37.7436043875329	-122.41909899033999	(37.7436043875329, -122.41909899034)
72299	72299	247777	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	240 30th St	1	: 4	Tree 1	Private 1			2	Width 3ft		6005014.994390001	2098457.52943	37.742248565111204	-122.42527461684799	(37.7422485651112, -122.425274616848)
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)
153633	153633	247755	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	52 Alpine Ter	1	: 4	Tree 1	Private 1			2	Width 3ft		6001613.95356	2108514.35375	37.7696694492075	-122.43775445760299	(37.7696694492075, -122.437754457603)
164978	164978	246941	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	269 Frederick St	1	: 4	Tree 1	Private 1			2	Width 3ft		5998752.122880001	2107600.5740099996	37.7669972990085	-122.447587610674	(37.7669972990085, -122.447587610674)
55956	55956	246808	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	162 Brewster St	1	: 4	Tree 1	Private 1			1	Width 2ft		6010230.46229	2099004.5054099998	37.744043711743004	-122.407279600877	(37.744043711743, -122.407279600877)
135085	135085	246460	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	200 Duncan St	1	: 4	Tree 1	Private 1			2	Width 3ft		6005150.47679	2099924.83113	37.7462850938946	-122.42491052900299	(37.7462850938946, -122.424910529003)
3389	3389	243477	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	109 Jarboe Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/05/2017 12:00:00 AM	3	3x3	Permit Number 779653	6007827.749919999	2097028.5645299999	37.7384834490575	-122.415447803985	(37.7384834490575, -122.415447803985)
3386	3386	243475	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	109X Jarboe Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/05/2017 12:00:00 AM	3	3x3	Permit Number 779653	6007857.826	2097024.89565	37.738475065558895	-122.415343555473	(37.7384750655589, -122.415343555473)
5246	5246	243453	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	73 Elsie St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			0	4x6		6007416.818030001	2098970.61704	37.74379278831079	-122.41700617529699	(37.7437927883108, -122.417006175297)
5133	5133	242839	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1151 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 7ft		6005182.8356800005	2101610.74761	37.750916060132106	-122.424918561756	(37.7509160601321, -122.424918561756)
5141	5141	237496	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3927 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6003620.49393	2101843.48933	37.751466742003295	-122.430337889878	(37.7514667420033, -122.430337889878)
67518	67518	230357	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	137 Randall St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6004642.1298400005	2097534.3319200003	37.739692602838296	-122.426498147168	(37.7396926028383, -122.426498147168)
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)
168110	168110	230355	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	397 30th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6004002.34815	2098351.08289	37.7418990256315	-122.428768448829	(37.7418990256315, -122.428768448829)
157255	157255	230354	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	531 30th St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 8ft		6003165.5903900005	2098301.47872	37.7417154299181	-122.431658143201	(37.7417154299181, -122.431658143201)
129514	129514	230353	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	210 Moffitt St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 2ft		6002369.42033	2097177.7522	37.7385847765781	-122.43433070979401	(37.7385847765781, -122.434330709794)
57558	57558	230352	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	136 Moffitt St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6002654.78135	2096839.9013099999	37.7376733091617	-122.433319933881	(37.7376733091617, -122.433319933881)
165815	165815	230351	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	132 Moffitt St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6002667.4556599995	2096824.4771	37.737631676855294	-122.43327501094299	(37.7376316768553, -122.433275010943)
33482	33482	230350	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	35 Sussex St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6002643.63835	2096299.62877	37.7361892128574	-122.433319865541	(37.7361892128574, -122.433319865541)
151066	151066	230349	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	222 Surrey St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		6001969.40377	2096197.83075	37.735871425709995	-122.43564368671801	(37.73587142571, -122.435643686718)
2537	2537	230348	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	280 Arlington St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	3x3		6004547.50076	2096560.5372400002	37.7370134334286	-122.42675600438	(37.7370134334286, -122.42675600438)
60673	60673	230347	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1801 Church St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004579.28935	2098353.48586	37.741938260334294	-122.42677374352199	(37.7419382603343, -122.426773743522)
24569	24569	230346	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1801 Church St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004582.48938	2098325.9035400003	37.74186270650671	-122.426760715042	(37.7418627065067, -122.426760715042)
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)
29464	29464	230344	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1801 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004583.81865	2098292.85658	37.7417720422523	-122.426753765994	(37.7417720422523, -122.426753765994)
153254	153254	230343	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	65 Chenery St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6004910.0558400005	2097921.66035	37.7407712613889	-122.42559933235	(37.7407712613889, -122.42559933235)
44551	44551	230342	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	65 Chenery St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6004911.05921	2097907.1085200002	37.740731362062704	-122.42559482765499	(37.7407313620627, -122.425594827655)
38961	38961	230341	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	65 Chenery St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6004909.36728	2097888.2006599996	37.7406793497697	-122.425599332346	(37.7406793497697, -122.425599332346)
147660	147660	230340	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	65 Chenery St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6004910.8116	2097869.74707	37.7406287620114	-122.425593025396	(37.7406287620114, -122.425593025396)
176498	176498	230339	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	65 Chenery St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6004912.08615	2097855.70847	37.7405902872201	-122.425587619594	(37.7405902872201, -122.425587619594)
181671	181671	230338	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	31 Walter St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6003171.4913099995	2108119.01737	37.7686723924455	-122.43233874923	(37.7686723924455, -122.43233874923)
42139	42139	230337	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	823 Castro St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6002470.86224	2103420.79735	37.7557324674964	-122.43442621241199	(37.7557324674964, -122.434426212412)
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)
147958	147958	230335	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	823 Castro St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6002473.18997	2103401.0764	37.7556784506177	-122.434416752458	(37.7556784506177, -122.434416752458)
173292	173292	230334	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3817 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6002957.98298	2102975.20169	37.7545366065863	-122.43270976546499	(37.7545366065863, -122.432709765465)
74610	74610	230333	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	629 28th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6001808.677069999	2099403.33262	37.7446638554471	-122.436428732821	(37.7446638554471, -122.436428732821)
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)
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)
170923	170923	230330	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	38 Bonview St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6007670.81289	2099114.19378	37.744201302652705	-122.416138084916	(37.7442013026527, -122.416138084916)
180726	180726	230329	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	33 Prospect Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6007181.85452	2099302.37672	37.7446905059706	-122.417842137412	(37.7446905059706, -122.417842137412)
65368	65368	230328	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	518 Banks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6008539.17549	2096369.5184099998	37.7367138134929	-122.41294144560601	(37.7367138134929, -122.412941445606)
165446	165446	230327	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	204 27th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6005133.403419999	2100215.61494	37.747082555133	-122.42499025209999	(37.747082555133, -122.4249902521)
180308	180308	230326	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	383 27th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6004064.30243	2100111.9169799997	37.7467373764274	-122.428679723506	(37.7467373764274, -122.428679723506)
175002	175002	230325	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	30 Chattanooga St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 4ft		6004684.33252	2103302.03118	37.7555317594992	-122.426762864436	(37.7555317594992, -122.426762864436)
161292	161292	230324	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	14 Chattanooga St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6004676.492190001	2103485.42894	37.7560348834086	-122.426803038952	(37.7560348834086, -122.426803038952)
50219	50219	230323	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	12 Chattanooga St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6004674.70805	2103511.60917	37.7561066672951	-122.42681107348601	(37.7561066672951, -122.426811073486)
27217	27217	230322	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	4089 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6003345.458190001	2100655.86235	37.7481902141138	-122.43120423378299	(37.7481902141138, -122.431204233783)
171575	171575	230321	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1297 Sanchez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6003909.46951	2100753.0320099997	37.748488965296204	-122.42926082853901	(37.7484889652962, -122.429260828539)
27017	27017	230320	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	469 28th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		6002876.4268	2099458.33871	37.7448755037027	-122.432740595108	(37.7448755037027, -122.432740595108)
154873	154873	230319	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	119 Day St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6005056.96104	2098704.0891400003	37.7429279327818	-122.425147048897	(37.7429279327818, -122.425147048897)
161578	161578	230318	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	107 Valley St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		6005160.92225	2099293.15868	37.744551255839795	-122.424829478514	(37.7445512558398, -122.424829478514)
150105	150105	230317	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	609 Precita Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6009667.55833	2100362.09801	37.74773984264029	-122.40932179038799	(37.7477398426403, -122.409321790388)
146648	146648	230316	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	131 Peralta Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6010129.26175	2100145.52723	37.7471710439032	-122.407709968747	(37.7471710439032, -122.407709968747)
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)
49507	49507	230314	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	31 Mullen Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009412.86003	2099877.13325	37.7463939631256	-122.41016829345301	(37.7463939631256, -122.410168293453)
57885	57885	230313	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	968 Hampshire St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010194.52879	2103588.6082900004	37.756628635618604	-122.40772701540399	(37.7566286356186, -122.407727015404)
133786	133786	230312	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2901 20th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6009544.39548	2104509.50944	37.759120806308204	-122.41004043054701	(37.7591208063082, -122.410040430547)
34741	34741	230311	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2901 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6009504.69694	2104506.09173	37.7591091969416	-122.41017748630101	(37.7591091969416, -122.410177486301)
164626	164626	230310	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	322 Fair Oaks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6005451.16912	2101791.33905	37.7514270756131	-122.424003479091	(37.7514270756131, -122.424003479091)
151933	151933	230309	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3668 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6005328.964269999	2101978.057	37.7519328597144	-122.424439358013	(37.7519328597144, -122.424439358013)
165271	165271	230308	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3795 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6005100.08631	2104263.85733	37.7581962060976	-122.42539350181801	(37.7581962060976, -122.425393501818)
75357	75357	230307	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	316 San Carlos St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006700.0483099995	2104252.32406	37.758254804122	-122.419859309575	(37.758254804122, -122.419859309575)
74490	74490	230306	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	65 Oakwood St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6005267.4467	2105080.91438	37.7604491067472	-122.42487282493299	(37.7604491067472, -122.424872824933)
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)
54472	54472	230304	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3689 19th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6005034.41688	2104845.09352	37.7597884333033	-122.42566198362101	(37.7597884333033, -122.425661983621)
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)
187466	187466	230302	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	2908 25th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6009976.47339	2101651.34742	37.751297139764795	-122.408344495308	(37.7512971397648, -122.408344495308)
147644	147644	230301	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1083 York St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6010010.1738	2102926.1510900003	37.754799354323	-122.40831786097999	(37.754799354323, -122.40831786098)
151893	151893	230300	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1225 York St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6010064.03861	2101924.1335400003	37.7520510531386	-122.408060919271	(37.7520510531386, -122.408060919271)
164901	164901	230299	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	590 York St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6009785.6882	2105558.56974	37.762014809365	-122.409279952113	(37.762014809365, -122.409279952113)
37460	37460	230298	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	613 York St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009857.38844	2105338.70025	37.761415114429795	-122.409016453452	(37.7614151144298, -122.409016453452)
23594	23594	230297	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1171 Treat Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6008685.11737	2101744.284	37.7514799242568	-122.412816735721	(37.7514799242568, -122.412816735721)
59160	59160	230296	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3500 19th St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6006123.351530001	2104947.42015	37.7601308699707	-122.421903157405	(37.7601308699707, -122.421903157405)
161500	161500	230295	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3500 19th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6006165.1210199995	2104950.71502	37.7601422724637	-122.42175893043199	(37.7601422724637, -122.421758930432)
165212	165212	230294	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3500 19th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6006176.610669999	2104951.77673	37.760145835588006	-122.421719268545	(37.760145835588, -122.421719268545)
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)
74024	74024	230292	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3500 19th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6006199.95177	2104950.54929	37.760143781519496	-122.42163845546499	(37.7601437815195, -122.421638455465)
174376	174376	230291	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	3623 18th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6005393.28111	2105446.83582	37.7614609474791	-122.424463649589	(37.7614609474791, -122.424463649589)
156468	156468	230290	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	59 Ramona Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6005216.74861	2107488.55744	37.76705705897071	-122.425219491113	(37.7670570589707, -122.425219491113)

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