Street_Tree_List

Data source: data.sfgov.org

432 rows where qSiteInfo = 11 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: qLegalStatus, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH ▼	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
81526	81526	103927	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	100 The Embarcadero	13	Median : Cutout 11	Tree 1	DPW 2		02/05/2001 12:00:00 AM		4x4		6014859.0	2117030.0	37.793795709183996	-122.392535650186	(37.793795709184, -122.392535650186)
127400	127400	119700	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	6x Octavia St Frontage West	2	Median : Cutout 11	Tree 1	DPW 2						2109337.0	6005692.0	47.2698908128932	-138.283860688311	(47.2698908128932, -138.283860688311)
138316	138316	119699	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	6x Octavia St Frontage West	1	Median : Cutout 11	Tree 1	DPW 2						2109337.0	6005692.0	47.2698908128932	-138.283860688311	(47.2698908128932, -138.283860688311)
140592	140592	26537	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	794X Dolores St	4	Median : Cutout 11	Tree 1	DPW 2		06/23/1997 12:00:00 AM		20		6004985.41588	2103704.6857762	37.7566543729812	-122.425750282521	(37.7566543729812, -122.425750282521)
78381	78381	23674	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	319 Virginia Ave	3	Median : Cutout 11	Tree 1	DPW 2			3	12		6006936.2458165	2098250.5638735	37.741788638281996	-122.418616833275	(37.741788638282, -122.418616833275)
18142	18142	13388	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	218 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			6	5		5997667.5215300005	2098758.8322	37.7426580336411	-122.45070150968999	(37.7426580336411, -122.45070150969)
14049	14049	18560	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	15	Median : Cutout 11	Tree 1	DPW 2			12	19		6014546.06488	2095149.2171099999	37.7336984729967	-122.392087539714	(37.7336984729967, -122.392087539714)
16768	16768	18555	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	10	Median : Cutout 11	Tree 1	DPW 2			12	19		6014626.04256	2095092.9200799998	37.733548332979105	-122.39180709603201	(37.7335483329791, -122.391807096032)
22064	22064	25150	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	50X Dolores St	3	Median : Cutout 11	Tree 1	DPW 2			12	20		6004790.11345	2107911.6189	37.7681945727608	-122.42672528803699	(37.7681945727608, -122.426725288037)
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)
85028	85028	18558	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	13	Median : Cutout 11	Tree 1	DPW 2			12	19		6014793.6967997	2095004.1424748	37.7333138733401	-122.39122125893199	(37.7333138733401, -122.391221258932)
86395	86395	18554	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	9	Median : Cutout 11	Tree 1	DPW 2			12	19		6014793.6967997	2095004.1424748	37.7333138733401	-122.39122125893199	(37.7333138733401, -122.391221258932)
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)
30035	30035	194392	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	860x Jamestown Ave	5	Median : Cutout 11	Tree 1	DPW 2			17	Width 5ft		6014755.052209999	2089115.5775900001	37.7171429037943	-122.39094345187799	(37.7171429037943, -122.390943451878)
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)
151174	151174	194393	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	860x Jamestown Ave	9	Median : Cutout 11	Tree 1	DPW 2			18	Width 5ft		6014647.11529	2089218.63866	37.7174198994758	-122.391323741894	(37.7174198994758, -122.391323741894)
32439	32439	194391	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	828x Jamestown Ave	4	Median : Cutout 11	Tree 1	DPW 2			19	Width 5ft		6014866.8225	2088973.5540099998	37.7167591360948	-122.39054719349899	(37.7167591360948, -122.390547193499)
41784	41784	194394	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	920x Jamestown Ave	4	Median : Cutout 11	Tree 1	DPW 2			19	Width 5ft		6014490.42947	2089308.0420799998	37.717656686497506	-122.39187158462799	(37.7176566864975, -122.391871584628)
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)
121202	121202	27482	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	990X Dolores St	2	Median : Cutout 11	Tree 1	DPW 2		10/20/1999 12:00:00 AM	20	20		6005038.29077	2102581.9809991	37.7535746757806	-122.425487524624	(37.7535746757806, -122.425487524624)
172221	172221	245963	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1950x Market St	1	Median : Cutout 11	Tree 1	DPW 2			20	Width 0ft		6005062.3371	2108554.2304	37.7699744164919	-122.425829439833	(37.7699744164919, -122.425829439833)
183995	183995	194395	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	920x Jamestown Ave	9	Median : Cutout 11	Tree 1	DPW 2			20	Width 5ft		6014427.53162	2089348.9061599998	37.7177653992236	-122.392091851971	(37.7177653992236, -122.392091851971)
58367	58367	132070	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	1	Median : Cutout 11	Tree 1	DPW 2			23	Width 5ft		6013297.802519999	2119184.84583	37.7996255806051	-122.39808881644501	(37.7996255806051, -122.398088816445)
18337	18337	25498	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1745X Market St	3	Median : Cutout 11	Tree 1	DPW 2		04/01/1993 12:00:00 AM	24	20		6005901.64349	2109360.28288	37.7722350378549	-122.422983588528	(37.7722350378549, -122.422983588528)
18585	18585	25121	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500 Dolores St	2	Median : Cutout 11	Tree 1	DPW 2			24	20		6005252.19486	2099522.95164	37.745187369700105	-122.424530218294	(37.7451873697001, -122.424530218294)
20060	20060	25500	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1745X Market St	5	Median : Cutout 11	Tree 1	DPW 2		04/01/1993 12:00:00 AM	24	20		6005964.12554	2109421.56816	37.7724068380339	-122.422771813485	(37.7724068380339, -122.422771813485)
20628	20628	25499	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1745X Market St	4	Median : Cutout 11	Tree 1	DPW 2		04/01/1993 12:00:00 AM	24	20		6005915.63153	2109374.76445	37.772275590069796	-122.42293623203999	(37.7722755900698, -122.42293623204)
21421	21421	25497	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1745X Market St	2	Median : Cutout 11	Tree 1	DPW 2		04/01/1993 12:00:00 AM	24	20		6005883.25661	2109339.92737	37.7721781089695	-122.42304574337099	(37.7721781089695, -122.423045743371)
21445	21445	25496	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1745X Market St	1	Median : Cutout 11	Tree 1	DPW 2		04/01/1993 12:00:00 AM	24	20		6005866.13841	2109325.7941099997	37.772138336447	-122.42310395199499	(37.772138336447, -122.423103951995)
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)
87718	87718	96830	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	650X Dolores St	5	Median : Cutout 11	Tree 1	DPW 2			24	20x225		6004936.0	2104486.3	37.7587977092663	-122.425976818319	(37.7587977092663, -122.425976818319)
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)
95346	95346	96821	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	610X Dolores St	1	Median : Cutout 11	Tree 1	DPW 2			24	20x225		6004926.4	2104659.4	37.7592724584905	-122.426022342006	(37.7592724584905, -122.426022342006)
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)
110274	110274	96826	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	650X Dolores St	1	Median : Cutout 11	Tree 1	DPW 2			24	20x225		6004936.0	2104486.3	37.7587977092663	-122.425976818319	(37.7587977092663, -122.425976818319)
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)
113929	113929	25012	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	500X Dolores St	6	Median : Cutout 11	Tree 1	DPW 2			24	20		6004896.4850004995	2105439.5076575	37.7614127588524	-122.426181340905	(37.7614127588524, -122.426181340905)
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)
118260	118260	96823	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	610X Dolores St	3	Median : Cutout 11	Tree 1	DPW 2			24	20x225		6004926.4	2104659.4	37.7592724584905	-122.426022342006	(37.7592724584905, -122.426022342006)
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)

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