Street_Tree_List

Data source: data.sfgov.org

233 rows where qLegalStatus = 1 and qSiteInfo = 11 sorted by PlotSize

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: PlantType, qCaretaker, DBH, PlotSize, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize ▼	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
14379	14379	48480	Permitted Site 1	Tree(s) :: 17		1	Median : Cutout 11	Tree 1	Private 1					Permit Number 45832
19496	19496	34866	Permitted Site 1	Olea europaea :: Olive Tree 41	579 Miramar Ave	1	Median : Cutout 11	Tree 1	Private 1	FUF 1	12/29/2015 12:00:00 AM			Permit Number 775311	5995338.59696042	2093168.95782094	37.7271760192259	-122.458349689476	(37.7271760192259, -122.458349689476)
44570	44570	27941	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	699 The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24			6012787.5534626	2119857.700218	37.801444644335106	-122.399901749617	(37.8014446443351, -122.399901749617)
72222	72222	87818	Permitted Site 1	Quercus agrifolia :: Coast Live Oak 180	85 Mendosa Ave	1	Median : Cutout 11	Tree 1	Private 1		06/04/2008 12:00:00 AM			Permit Number 50680	5993356.0	2100787.0	37.747979128324	-122.46575670711701	(37.747979128324, -122.465756707117)
77513	77513	27958	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	307X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	18			6013768.7522982005	2118400.6344275	37.7974985415834	-122.396404150152	(37.7974985415834, -122.396404150152)
78674	78674	99497	Permitted Site 1	Quercus agrifolia :: Coast Live Oak 180	1400X Plymouth Ave	4	Median : Cutout 11	Tree 1	Private 1						5995903.0	2093347.3	37.7276981218086	-122.45641145576	(37.7276981218086, -122.45641145576)
79708	79708	27959	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	307X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	18			6013768.7522982005	2118400.6344275	37.7974985415834	-122.396404150152	(37.7974985415834, -122.396404150152)
82090	82090	27775	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	299X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	26			6013785.1217042	2118375.8431165	37.797431381421	-122.39634576874799	(37.797431381421, -122.396345768748)
83274	83274	99496	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X Plymouth Ave	3	Median : Cutout 11	Tree 1	Private 1						5995903.0	2093347.3	37.7276981218086	-122.45641145576	(37.7276981218086, -122.45641145576)
84036	84036	27864	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	900X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		12/20/2000 12:00:00 AM	24			6012583.0764321	2120386.2715161997	37.8028845715493	-122.400646489089	(37.8028845715493, -122.400646489089)
84835	84835	86968	Permitted Site 1	Tree(s) :: 17	3250 Van Ness Ave	1	Median : Cutout 11	Tree 1	Private 1		10/27/2007 12:00:00 AM			Permit Number 49934	6005499.7	2121504.7	37.8055578865418	-122.42523827370701	(37.8055578865418, -122.425238273707)
86095	86095	103414	Permitted Site 1	Quercus agrifolia :: Coast Live Oak 180	1490X Plymouth Ave	1	Median : Cutout 11	Tree 1	Private 1		04/18/2013 12:00:00 AM			Permit Number 770026	5995919.3	2094026.5	37.7295639775589	-122.456404198854	(37.7295639775589, -122.456404198854)
87404	87404	99494	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X Plymouth Ave	1	Median : Cutout 11	Tree 1	Private 1						5995903.0	2093347.3	37.7276981218086	-122.45641145576	(37.7276981218086, -122.45641145576)
87650	87650	27777	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	299X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	26			6013785.1217042	2118375.8431165	37.797431381421	-122.39634576874799	(37.797431381421, -122.396345768748)
89385	89385	27863	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	900X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		12/20/2000 12:00:00 AM	24			6012583.0764321	2120386.2715161997	37.8028845715493	-122.400646489089	(37.8028845715493, -122.400646489089)
89834	89834	27792	Permitted Site 1	Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127	199X The Embarcadero	9	Median : Cutout 11	Tree 1	Port 9			12			6014015.4653372	2118064.3876984	37.796589013389394	-122.39552688195299	(37.7965890133894, -122.395526881953)
90111	90111	27847	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	280 The Embarcadero	8	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	36			6013933.6105332	2118392.9536833	37.797486624670704	-122.395833154489	(37.7974866246707, -122.395833154489)
90241	90241	27861	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	900X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		12/20/2000 12:00:00 AM	24			6012583.0764321	2120386.2715161997	37.8028845715493	-122.400646489089	(37.8028845715493, -122.400646489089)
91142	91142	28372	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	199X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9			18			6014015.4653372	2118064.3876984	37.796589013389394	-122.39552688195299	(37.7965890133894, -122.395526881953)
92133	92133	27942	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	699 The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24			6012787.5534626	2119857.700218	37.801444644335106	-122.399901749617	(37.8014446443351, -122.399901749617)
92364	92364	27782	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	399X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	24			6013580.156802201	2118681.7167588	37.7982598302065	-122.397076463892	(37.7982598302065, -122.397076463892)
92652	92652	27780	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	399X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	24			6013580.156802201	2118681.7167588	37.7982598302065	-122.397076463892	(37.7982598302065, -122.397076463892)
93856	93856	27960	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	307X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	18			6013768.7522982005	2118400.6344275	37.7974985415834	-122.396404150152	(37.7974985415834, -122.396404150152)
94947	94947	27865	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	900X The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		12/20/2000 12:00:00 AM	24			6012583.0764321	2120386.2715161997	37.8028845715493	-122.400646489089	(37.8028845715493, -122.400646489089)
96124	96124	27767	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	299X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		12/10/2000 12:00:00 AM	26			6013785.1217042	2118375.8431165	37.797431381421	-122.39634576874799	(37.797431381421, -122.396345768748)
98538	98538	98820	Permitted Site 1	Cupressus macrocarpa :: Monterey Cypress 47	302X Pacheco St	28	Median : Cutout 11	Tree 1	Private 1		05/09/2010 12:00:00 AM			Permit Number 768820	5994341.5	2100725.2	37.747866238402096	-122.46234443277001	(37.7478662384021, -122.46234443277)
99547	99547	27845	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	280 The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	36			6013933.6105332	2118392.9536833	37.797486624670704	-122.395833154489	(37.7974866246707, -122.395833154489)
100132	100132	27778	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	299X The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	26			6013785.1217042	2118375.8431165	37.797431381421	-122.39634576874799	(37.797431381421, -122.396345768748)
100729	100729	27843	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	280 The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	36			6013933.6105332	2118392.9536833	37.797486624670704	-122.395833154489	(37.7974866246707, -122.395833154489)
101121	101121	27717	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	307X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		09/11/2000 12:00:00 AM	18			6013768.7522982005	2118400.6344275	37.7974985415834	-122.396404150152	(37.7974985415834, -122.396404150152)
101242	101242	27788	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	199X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9			14			6014015.4653372	2118064.3876984	37.796589013389394	-122.39552688195299	(37.7965890133894, -122.395526881953)
101933	101933	27789	Permitted Site 1	Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127	199X The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9			12			6014015.4653372	2118064.3876984	37.796589013389394	-122.39552688195299	(37.7965890133894, -122.395526881953)
104599	104599	27791	Permitted Site 1	Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127	199X The Embarcadero	8	Median : Cutout 11	Tree 1	Port 9			12			6014015.4653372	2118064.3876984	37.796589013389394	-122.39552688195299	(37.7965890133894, -122.395526881953)
104698	104698	27952	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	107X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	6			6014670.2880903	2117144.019363	37.7940982979938	-122.39319659791501	(37.7940982979938, -122.393196597915)
105556	105556	27842	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	280 The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	36			6013933.6105332	2118392.9536833	37.797486624670704	-122.395833154489	(37.7974866246707, -122.395833154489)
105677	105677	27827	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	280 The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	36			6013933.6105332	2118392.9536833	37.797486624670704	-122.395833154489	(37.7974866246707, -122.395833154489)
106951	106951	27956	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	107X The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	6			6014670.2880903	2117144.019363	37.7940982979938	-122.39319659791501	(37.7940982979938, -122.393196597915)
108807	108807	27718	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	107X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		09/11/2000 12:00:00 AM	6			6014670.2880903	2117144.019363	37.7940982979938	-122.39319659791501	(37.7940982979938, -122.393196597915)
110061	110061	27844	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	280 The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	36			6013933.6105332	2118392.9536833	37.797486624670704	-122.395833154489	(37.7974866246707, -122.395833154489)
110146	110146	27862	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	900X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		12/20/2000 12:00:00 AM	24			6012583.0764321	2120386.2715161997	37.8028845715493	-122.400646489089	(37.8028845715493, -122.400646489089)
111571	111571	27784	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	399X The Embarcadero	7	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	20			6013580.156802201	2118681.7167588	37.7982598302065	-122.397076463892	(37.7982598302065, -122.397076463892)
112303	112303	27790	Permitted Site 1	Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127	199X The Embarcadero	7	Median : Cutout 11	Tree 1	Port 9			12			6014015.4653372	2118064.3876984	37.796589013389394	-122.39552688195299	(37.7965890133894, -122.395526881953)
112720	112720	27781	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	399X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	24			6013580.156802201	2118681.7167588	37.7982598302065	-122.397076463892	(37.7982598302065, -122.397076463892)
113231	113231	27793	Permitted Site 1	Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127	199X The Embarcadero	10	Median : Cutout 11	Tree 1	Port 9			12			6014015.4653372	2118064.3876984	37.796589013389394	-122.39552688195299	(37.7965890133894, -122.395526881953)
113986	113986	115182	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	315 Lakeshore Dr	1	Median : Cutout 11	Tree 1	Private 1		01/15/2016 12:00:00 AM			Permit Number 775158	5983956.6	2095109.9	37.7318446842931	-122.497839799214	(37.7318446842931, -122.497839799214)
114418	114418	27957	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	107X The Embarcadero	7	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	6			6014670.2880903	2117144.019363	37.7940982979938	-122.39319659791501	(37.7940982979938, -122.393196597915)
115875	115875	27841	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	280 The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	36			6013933.6105332	2118392.9536833	37.797486624670704	-122.395833154489	(37.7974866246707, -122.395833154489)
118074	118074	27961	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	307X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	18			6013768.7522982005	2118400.6344275	37.7974985415834	-122.396404150152	(37.7974985415834, -122.396404150152)
118319	118319	27846	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	280 The Embarcadero	7	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	36			6013933.6105332	2118392.9536833	37.797486624670704	-122.395833154489	(37.7974866246707, -122.395833154489)
120022	120022	27940	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	699 The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24			6012787.5534626	2119857.700218	37.801444644335106	-122.399901749617	(37.8014446443351, -122.399901749617)
120310	120310	27785	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	199X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9			18			6014015.4653372	2118064.3876984	37.796589013389394	-122.39552688195299	(37.7965890133894, -122.395526881953)
121752	121752	27776	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	299X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	26			6013785.1217042	2118375.8431165	37.797431381421	-122.39634576874799	(37.797431381421, -122.396345768748)
122780	122780	99495	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X Plymouth Ave	2	Median : Cutout 11	Tree 1	Private 1						5995903.0	2093347.3	37.7276981218086	-122.45641145576	(37.7276981218086, -122.45641145576)
125860	125860	27766	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	399X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	24			6013580.156802201	2118681.7167588	37.7982598302065	-122.397076463892	(37.7982598302065, -122.397076463892)
127099	127099	27943	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	699 The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24			6012787.5534626	2119857.700218	37.801444644335106	-122.399901749617	(37.8014446443351, -122.399901749617)
128222	128222	27953	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	107X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	6			6014670.2880903	2117144.019363	37.7940982979938	-122.39319659791501	(37.7940982979938, -122.393196597915)
128446	128446	27860	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	900X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		12/20/2000 12:00:00 AM	24			6012583.0764321	2120386.2715161997	37.8028845715493	-122.400646489089	(37.8028845715493, -122.400646489089)
139415	139415	27774	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	299X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		12/10/2000 12:00:00 AM	26			6013785.1217042	2118375.8431165	37.797431381421	-122.39634576874799	(37.797431381421, -122.396345768748)
140517	140517	86969	Permitted Site 1	Tree(s) :: 17	3250 Van Ness Ave	2	Median : Cutout 11	Tree 1	Private 1		10/27/2007 12:00:00 AM			Permit Number 49934	6005499.7	2121504.7	37.8055578865418	-122.42523827370701	(37.8055578865418, -122.425238273707)
140643	140643	27786	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	199X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9			14			6014015.4653372	2118064.3876984	37.796589013389394	-122.39552688195299	(37.7965890133894, -122.395526881953)
140645	140645	27955	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	107X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	6			6014670.2880903	2117144.019363	37.7940982979938	-122.39319659791501	(37.7940982979938, -122.393196597915)
140710	140710	27962	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	307X The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	18			6013768.7522982005	2118400.6344275	37.7974985415834	-122.396404150152	(37.7974985415834, -122.396404150152)
140893	140893	27783	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	399X The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	24			6013580.156802201	2118681.7167588	37.7982598302065	-122.397076463892	(37.7982598302065, -122.397076463892)
141929	141929	27794	Permitted Site 1	Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127	199X The Embarcadero	11	Median : Cutout 11	Tree 1	Port 9			12			6014015.4653372	2118064.3876984	37.796589013389394	-122.39552688195299	(37.7965890133894, -122.395526881953)
144544	144544	27779	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	399X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	24			6013580.156802201	2118681.7167588	37.7982598302065	-122.397076463892	(37.7982598302065, -122.397076463892)
145142	145142	27954	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	107X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	6			6014670.2880903	2117144.019363	37.7940982979938	-122.39319659791501	(37.7940982979938, -122.393196597915)
145407	145407	27787	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	199X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9			14			6014015.4653372	2118064.3876984	37.796589013389394	-122.39552688195299	(37.7965890133894, -122.395526881953)
724	724	25734	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	500X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	16	10		6013899.49111	2118360.1858599996	37.7973947538281	-122.395948920127	(37.7973947538281, -122.395948920127)
1312	1312	25735	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	500X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	16	10		6013816.07307	2118422.78251	37.7975619881486	-122.396241959692	(37.7975619881486, -122.396241959692)
4067	4067	25799	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1300X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012220.09673	2120843.1378	37.8041187644177	-122.401934728525	(37.8041187644177, -122.401934728525)
5785	5785	25798	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1100X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012871.9305	2119823.23547	37.801354716114	-122.39960734420201	(37.801354716114, -122.399607344202)
6093	6093	26031	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	450X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	36	10		6014122.12078	2117941.0950599997	37.7962564126589	-122.39514918719999	(37.7962564126589, -122.3951491872)
6748	6748	26030	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	450X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	36	10		6014150.34723	2117905.1373099997	37.796159250800294	-122.395048997307	(37.7961592508003, -122.395048997307)
7108	7108	25783	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	500X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6013938.98446	2118296.9177	37.7972232315271	-122.39580782638599	(37.7972232315271, -122.395807826386)
7340	7340	25782	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	500X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	36	10		6013997.3565	2118221.08563	37.7970182616509	-122.395600527244	(37.7970182616509, -122.395600527244)
8987	8987	25784	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	500X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6013869.26975	2118339.24702	37.797335579338004	-122.396052026484	(37.797335579338, -122.396052026484)
19785	19785	25785	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	500X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6013445.7547399	2119056.6213273997	37.7992817461076	-122.39756784649201	(37.7992817461076, -122.397567846492)
69372	69372	25749	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1301X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6011423.5148387	2121491.4283584	37.805854321699	-122.40473704035801	(37.805854321699, -122.404737040358)
78155	78155	25795	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800X The Embarcadero	9	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012764.87501	2119980.6770099998	37.80178104459689	-122.39998886869199	(37.8017810445969, -122.399988868692)
78230	78230	27930	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	799 The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24	10		6012635.1983488	2120084.4698961005	37.8020588041016	-122.400444907677	(37.8020588041016, -122.400444907677)
78576	78576	25731	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	501X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	16	10		6013387.7643744005	2119020.8269614	37.799180234142106	-122.39776600258999	(37.7991802341421, -122.39776600259)
80104	80104	25796	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800X The Embarcadero	10	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012816.959009999	2119901.25001	37.80156586089179	-122.399803052325	(37.8015658608918, -122.399803052325)
81176	81176	27963	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1101X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	36	10		6012183.0853805	2120808.9629681	37.8040228629879	-122.402060405747	(37.8040228629879, -122.402060405747)
81328	81328	25745	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	10	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	24	10		6012632.1664062	2120088.9827256002	37.802071026160604	-122.400455716884	(37.8020710261606, -122.400455716884)
86291	86291	25738	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	24	10		6012632.1664062	2120088.9827256002	37.802071026160604	-122.400455716884	(37.8020710261606, -122.400455716884)
86502	86502	25797	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800X The Embarcadero	11	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012870.34401	2119824.4270099998	37.801357899362394	-122.399612917904	(37.8013578993624, -122.399612917904)
87172	87172	26029	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	499X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	36	10		6013385.9217822	2119009.0450001	37.7991477810775	-122.397771551765	(37.7991477810775, -122.397771551765)
89841	89841	25748	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1301X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6011423.5148387	2121491.4283584	37.805854321699	-122.40473704035801	(37.805854321699, -122.404737040358)
91779	91779	26017	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	899X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	36	10		6012483.6012207	2120310.1113668997	37.8026699057947	-122.40098537237499	(37.8026699057947, -122.400985372375)
92465	92465	26024	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	899X The Embarcadero	8	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	36	10		6012483.6012207	2120310.1113668997	37.8026699057947	-122.40098537237499	(37.8026699057947, -122.400985372375)
95434	95434	27933	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	799 The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24	10		6012635.1983488	2120084.4698961005	37.8020588041016	-122.400444907677	(37.8020588041016, -122.400444907677)
96132	96132	25786	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	500X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6013445.7547399	2119056.6213273997	37.7992817461076	-122.39756784649201	(37.7992817461076, -122.397567846492)
98209	98209	25737	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	24	10		6012632.1664062	2120088.9827256002	37.802071026160604	-122.400455716884	(37.8020710261606, -122.400455716884)
101160	101160	25742	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	7	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	24	10		6012632.1664062	2120088.9827256002	37.802071026160604	-122.400455716884	(37.8020710261606, -122.400455716884)
101776	101776	25752	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1301X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6011423.5148387	2121491.4283584	37.805854321699	-122.40473704035801	(37.805854321699, -122.404737040358)
103830	103830	27697	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1100X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9			36	10		6012224.999683401	2120852.6389045	37.8041451257683	-122.401918429695	(37.8041451257683, -122.401918429695)
104498	104498	25741	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	24	10		6012632.1664062	2120088.9827256002	37.802071026160604	-122.400455716884	(37.8020710261606, -122.400455716884)
105106	105106	25746	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1101X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012183.0853805	2120808.9629681	37.8040228629879	-122.402060405747	(37.8040228629879, -122.402060405747)
107210	107210	25790	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012501.85401	2120373.90601	37.8028460885889	-122.400926692934	(37.8028460885889, -122.400926692934)
107397	107397	25804	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1300X The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6011529.7175275	2121574.5346243	37.8060884463757	-122.404375360949	(37.8060884463757, -122.404375360949)

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