Street_Tree_List

Data source: data.sfgov.org

133 rows where SiteOrder = 2 and qSpecies = 88

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
2327	2327	53079	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	600 Kansas St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/11/2017 12:00:00 AM	3	3x3	Permit Number 780021	6011490.70702	2105522.9440900004	37.7620123668039	-122.4033804148	(37.7620123668039, -122.4033804148)
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)
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)
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)
9341	9341	116840	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	636 POTRERO AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	3x3		6010345.0	2105335.0	37.761432257364994	-122.40732973919701	(37.761432257365, -122.407329739197)
10963	10963	108843	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	420 Woolsey St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/2015 12:00:00 AM	3		Permit Number 772583	6010519.109209999	2091869.71455	37.7244692416558	-122.40577905416201	(37.7244692416558, -122.405779054162)
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)
13472	13472	110653	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1189 Tennessee St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/28/2015 12:00:00 AM	3	3x4		6015597.65588	2103555.7138400003	37.7568393018153	-122.38903859247101	(37.7568393018153, -122.389038592471)
15260	15260	116923	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	900x 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/22/2016 12:00:00 AM	3	5x5		6015559.42731	2102560.4848599997	37.7541044949445	-122.389101314797	(37.7541044949445, -122.389101314797)
15315	15315	116934	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1275 Minnesota St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/22/2016 12:00:00 AM	3	5x5		6015367.98495	2102613.01131	37.7542381072096	-122.38976704331999	(37.7542381072096, -122.38976704332)
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)
16533	16533	33792	Permitted Site 1	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	77 Beale St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2015 12:00:00 AM	3	3x3	Permit Number 774395	6013856.54517	2116173.60161	37.7913885182281	-122.395944220262	(37.7913885182281, -122.395944220262)
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)
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)
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)
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)
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)
30570	30570	193337	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	1270 Minnesota St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6015308.479069999	2102559.27559	37.7540872603324	-122.389969077812	(37.7540872603324, -122.389969077812)
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)
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)
35824	35824	131007	DPW Maintained 3	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	150x Drumm St	2	Median : Yard 3	Tree 1	DPW 2			4	Width 7ft		6013687.07221	2117423.5151299997	37.7948110573238	-122.396618254944	(37.7948110573238, -122.396618254944)
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)
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)
41960	41960	177441	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	71 Karen Ct	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6010258.66598	2091491.8701799999	37.7234171913236	-122.406652760812	(37.7234171913236, -122.406652760812)
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)
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)
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)
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)
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)
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)
54081	54081	193373	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	61 Beale St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6013783.27133	2116255.65231	37.7916097334637	-122.39620350109699	(37.7916097334637, -122.396203501097)
54394	54394	193368	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	262 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6013947.275280001	2116186.44855	37.79142884020779	-122.395631194149	(37.7914288402078, -122.395631194149)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)

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