Street_Tree_List

Data source: data.sfgov.org

180 rows where qCaretaker = 9 and qSpecies = 100 sorted by DBH

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: qAddress, SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH ▼	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
2027	2027	25628	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	650 The Embarcadero	1	Sidewalk: Curb side : Cutout 1	Tree 1	Port 9		12/18/2000 12:00:00 AM	12	4X4		6014034.02503	2117986.25531	37.796375512586	-122.39545718430401	(37.796375512586, -122.395457184304)
6610	6610	25631	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	650 The Embarcadero	4	Sidewalk: Curb side : Cutout 1	Tree 1	Port 9		12/18/2000 12:00:00 AM	12	4X4		6014105.621619999	2117876.68788	37.7960786481665	-122.395201764263	(37.7960786481665, -122.395201764263)
8064	8064	25629	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	650 The Embarcadero	2	Sidewalk: Curb side : Cutout 1	Tree 1	Port 9		12/18/2000 12:00:00 AM	12	4X4		6014059.75449	2117949.14567	37.79627504929729	-122.39536555327801	(37.7962750492973, -122.395365553278)
8404	8404	25630	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	650 The Embarcadero	3	Sidewalk: Curb side : Cutout 1	Tree 1	Port 9		12/18/2000 12:00:00 AM	12	4X4		6014084.49775	2117912.38554	37.7961754907607	-122.395277359473	(37.7961754907607, -122.395277359473)
78875	78875	27848	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	12	3X3		6015938.91901	2112416.43301	37.7811878161514	-122.388476823036	(37.7811878161514, -122.388476823036)
78913	78913	25684	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		12/18/2000 12:00:00 AM	12	3X3		6015953.02501	2112484.79201	37.781376296324	-122.388432795571	(37.781376296324, -122.388432795571)
109189	109189	27850	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	12	3X3		6015895.51701	2112292.73501	37.7808457639334	-122.38861833648701	(37.7808457639334, -122.388618336487)
117445	117445	27852	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	7	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	12	3X3		6015817.39201	2112182.05801	37.780537539741395	-122.388880882265	(37.7805375397414, -122.388880882265)
120266	120266	27849	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	12	3X3		6015921.55801	2112354.58401	37.7810170305764	-122.388532565578	(37.7810170305764, -122.388532565578)
126124	126124	25683	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		12/18/2000 12:00:00 AM	12	3X3		6015960.62101	2112553.15201	37.781564418481004	-122.388411289639	(37.781564418481, -122.388411289639)
139779	139779	27853	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	8	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	12	3X3		6015772.90401	2112134.31501	37.780403982219205	-122.389031454309	(37.7804039822192, -122.389031454309)
139983	139983	27851	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	12	3X3		6015857.5390099995	2112236.31101	37.7806887314792	-122.388745782008	(37.7806887314792, -122.388745782008)
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)
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)
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)
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)
112637	112637	25732	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	501X The Embarcadero	2	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)
124202	124202	25733	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	501X The Embarcadero	3	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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
76348	76348	27944	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	999 The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9			24	4X4		6012331.2461069	2120536.8810451	37.8032840604314	-122.401528548359	(37.8032840604314, -122.401528548359)
77877	77877	28025	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4X4		6014170.25601	2117873.24701	37.796072794607895	-122.39497787369301	(37.7960727946079, -122.394977873693)
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)
78636	78636	28030	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	10	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4X4		6014322.16601	2117689.8700099997	37.795577730351205	-122.39443938464899	(37.7955777303512, -122.394439384649)
81297	81297	28024	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4X4		6014145.300009999	2117911.2250099997	37.7961756855245	-122.39506688844999	(37.7961756855245, -122.39506688845)
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)
82580	82580	28021	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4x4		6014080.19501	2118017.56101	37.796464038519396	-122.39529961933201	(37.7964640385194, -122.395299619332)
83420	83420	27948	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	999 The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24	4X4		6012331.2461069	2120536.8810451	37.8032840604314	-122.401528548359	(37.8032840604314, -122.401528548359)
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)
89908	89908	27997	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	300 The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4X4		6013890.7555668	2118454.3638402	37.7976528582722	-122.395985750709	(37.7976528582722, -122.395985750709)
91110	91110	27949	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	999 The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24	4X4		6012331.2461069	2120536.8810451	37.8032840604314	-122.401528548359	(37.8032840604314, -122.401528548359)
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)
92971	92971	28023	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4x4		6014119.25801	2117944.86201	37.7962665966149	-122.395159357042	(37.7962665966149, -122.395159357042)
94674	94674	27870	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800 The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		01/31/2001 12:00:00 AM	24	4X4		6015155.50001	2116672.0830099997	37.79282941355329	-122.391484690649	(37.7928294135533, -122.391484690649)
94898	94898	28032	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	12	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4X4		6014349.29301	2117643.21201	37.7954511263865	-122.394342251353	(37.7954511263865, -122.394342251353)
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)
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)
98325	98325	27947	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	999 The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24	4X4		6012331.2461069	2120536.8810451	37.8032840604314	-122.401528548359	(37.8032840604314, -122.401528548359)
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)
102648	102648	28027	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	7	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4X4		6014263.57201	2117754.9750099997	37.795753235969	-122.394646693031	(37.795753235969, -122.394646693031)
104366	104366	28002	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	300 The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4X4		6013890.7555668	2118454.3638402	37.7976528582722	-122.395985750709	(37.7976528582722, -122.395985750709)
104388	104388	28031	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	11	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4X4		6014334.10201	2117669.25401	37.7955217871698	-122.394396639485	(37.7955217871698, -122.394396639485)
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)
106008	106008	28003	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	300 The Embarcadero	7	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4X4		6013890.7555668	2118454.3638402	37.7976528582722	-122.395985750709	(37.7976528582722, -122.395985750709)
106831	106831	27951	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	999 The Embarcadero	8	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24	4X4		6012331.2461069	2120536.8810451	37.8032840604314	-122.401528548359	(37.8032840604314, -122.401528548359)
107611	107611	28000	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	300 The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4X4		6013890.7555668	2118454.3638402	37.7976528582722	-122.395985750709	(37.7976528582722, -122.395985750709)
109422	109422	27866	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800 The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		01/31/2001 12:00:00 AM	24	4X4		6014921.77607	2116935.19701	37.793538888238395	-122.39231180375	(37.7935388882384, -122.39231180375)
111881	111881	27998	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	300 The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4X4		6013890.7555668	2118454.3638402	37.7976528582722	-122.395985750709	(37.7976528582722, -122.395985750709)
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)
113256	113256	25744	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	9	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)
113720	113720	25743	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	8	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)
114665	114665	27950	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	999 The Embarcadero	7	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24	4X4		6012331.2461069	2120536.8810451	37.8032840604314	-122.401528548359	(37.8032840604314, -122.401528548359)
114962	114962	27698	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	11	Median : Cutout 11	Tree 1	Port 9			24	10		6012632.1664062	2120088.9827256002	37.802071026160604	-122.400455716884	(37.8020710261606, -122.400455716884)
115229	115229	27932	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	799 The Embarcadero	4	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)
115397	115397	28022	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4X4		6014106.23701	2117977.41401	37.796355252616294	-122.39520669408002	(37.7963552526163, -122.39520669408)
115406	115406	27868	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800 The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		01/31/2001 12:00:00 AM	24	4X4		6015038.31301	2116806.19801	37.793191157262704	-122.39189954881	(37.7931911572627, -122.39189954881)
116513	116513	27946	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	999 The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24	4X4		6012331.2461069	2120536.8810451	37.8032840604314	-122.401528548359	(37.8032840604314, -122.401528548359)
117908	117908	28001	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	300 The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4X4		6013890.7555668	2118454.3638402	37.7976528582722	-122.395985750709	(37.7976528582722, -122.395985750709)
118790	118790	27869	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800 The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		01/31/2001 12:00:00 AM	24	4X4		6015100.81301	2116738.49001	37.7930087163181	-122.39167855690701	(37.7930087163181, -122.391678556907)
118856	118856	25739	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	4	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)
119199	119199	27935	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	799 The Embarcadero	7	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)
119973	119973	27999	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	300 The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4X4		6013890.7555668	2118454.3638402	37.7976528582722	-122.395985750709	(37.7976528582722, -122.395985750709)
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)
123608	123608	28026	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4X4		6014253.80701	2117776.67601	37.795812278914	-122.39468200241699	(37.795812278914, -122.394682002417)
123638	123638	27929	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	799 The Embarcadero	1	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)
125282	125282	27867	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800 The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		01/31/2001 12:00:00 AM	24	4X4		6014979.71901	2116870.00001	37.7933630896865	-122.392106753362	(37.7933630896865, -122.392106753362)
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)
128206	128206	27931	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	799 The Embarcadero	3	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)
128307	128307	25736	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	1	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)
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)
142211	142211	28029	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	9	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4X4		6014304.80501	2117713.7420099997	37.7956423121436	-122.394501129585	(37.7956423121436, -122.394501129585)
142246	142246	25740	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	5	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)
143792	143792	27934	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	799 The Embarcadero	6	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)
144240	144240	27945	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	999 The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24	4X4		6012331.2461069	2120536.8810451	37.8032840604314	-122.401528548359	(37.8032840604314, -122.401528548359)
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)
144979	144979	28028	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	8	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	24	4X4		6014289.61401	2117737.61301	37.7957070117951	-122.394555365911	(37.7957070117951, -122.394555365911)
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)
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)
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)
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)
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)
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)
1379	1379	25668	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	450X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		12/18/2000 12:00:00 AM	36	15		6014174.0749699995	2117868.41683	37.796059744425996	-122.394964320767	(37.796059744426, -122.394964320767)
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)
5331	5331	25671	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	450X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		12/18/2000 12:00:00 AM	36	15		6014100.8579	2117974.29057	37.7963463772386	-122.395225088169	(37.7963463772386, -122.395225088169)
5467	5467	27939	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	500X The Embarcadero	8	Median : Cutout 11	Tree 1	Port 9			36	4X4		6013788.66429	2118525.16075	37.7978415693921	-122.396343981507	(37.7978415693921, -122.396343981507)
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)

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