Street_Tree_List

Data source: data.sfgov.org

432 rows where qSiteInfo = 11 and qSpecies = 100 sorted by qAddress

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: DBH

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
17252	17252	24963	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	100 Dolores St	4	Median : Cutout 11	Tree 1	DPW 2			90	20		6004800.736959999	2107633.50365	37.7674315357679	-122.42666873508999	(37.7674315357679, -122.42666873509)
19333	19333	24968	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	100 Dolores St	9	Median : Cutout 11	Tree 1	DPW 2			90	20		6004810.58196	2107534.1310400004	37.767159239034704	-122.426627605497	(37.7671592390347, -122.426627605497)
19334	19334	24962	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	100 Dolores St	3	Median : Cutout 11	Tree 1	DPW 2		04/21/2005 12:00:00 AM	30	20		6004805.8872	2107667.07109	37.76752399506629	-122.42665331171999	(37.7675239950663, -122.42665331172)
19826	19826	24965	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	100 Dolores St	6	Median : Cutout 11	Tree 1	DPW 2			90	20		6004804.04595	2107595.6918	37.767327900586	-122.42665459683799	(37.767327900586, -122.426654596838)
20452	20452	24966	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	100 Dolores St	7	Median : Cutout 11	Tree 1	DPW 2			90	20		6004812.73188	2107584.41194	37.76729741985871	-122.426623750096	(37.7672974198587, -122.426623750096)
22009	22009	24961	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	100 Dolores St	1	Median : Cutout 11	Tree 1	DPW 2		04/21/2005 12:00:00 AM	90	20		6004800.95891	2107734.51921	37.76770891277079	-122.42667516163999	(37.7677089127708, -122.42667516164)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
17056	17056	25058	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000X Dolores St	1	Median : Cutout 11	Tree 1	DPW 2			90	20		6005092.48697	2102458.1018	37.753237594341996	-122.425291287561	(37.753237594342, -122.425291287561)
17722	17722	25061	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000X Dolores St	4	Median : Cutout 11	Tree 1	DPW 2			90	20		6005097.79962	2102345.06954	37.7529275341834	-122.425264872687	(37.7529275341834, -122.425264872687)
21757	21757	25064	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000X Dolores St	7	Median : Cutout 11	Tree 1	DPW 2			40	20		6005102.4225699995	2102227.07793	37.7526038178156	-122.425240490271	(37.7526038178156, -122.425240490271)
22227	22227	25067	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000X Dolores St	10	Median : Cutout 11	Tree 1	DPW 2			40	20		6005110.57075	2102123.34784	37.7523194593995	-122.425204931964	(37.7523194593995, -122.425204931964)
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)
16962	16962	25071	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100X Dolores St	2	Median : Cutout 11	Tree 1	DPW 2			80	20		6005127.376540001	2101840.69033	37.751544296835206	-122.42512670443001	(37.7515442968352, -122.42512670443)
18230	18230	25073	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100X Dolores St	4	Median : Cutout 11	Tree 1	DPW 2			90	20		6005132.2187	2101761.89405	37.7513282140435	-122.42510435359199	(37.7513282140435, -122.425104353592)
18432	18432	25070	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100X Dolores St	1	Median : Cutout 11	Tree 1	DPW 2			80	20		6005125.726319999	2101888.99536	37.751676838028395	-122.425135847862	(37.7516768380284, -122.425135847862)
20762	20762	25074	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100X Dolores St	5	Median : Cutout 11	Tree 1	DPW 2			70	20		6005132.37065	2101712.1567700002	37.751191655576	-122.425100289545	(37.751191655576, -122.425100289545)
21721	21721	25072	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100X Dolores St	3	Median : Cutout 11	Tree 1	DPW 2			80	20		6005130.36391	2101800.2565200003	37.751433443721	-122.425113497011	(37.751433443721, -122.425113497011)
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)
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)
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)
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)
111083	111083	25747	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1101X The Embarcadero	2	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)
100172	100172	25080	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1156 DOLORES ST	1	Median : Cutout 11	Tree 1	DPW 2			90	20		6005077.9	2101580.2	37.7508262556468	-122.425279266089	(37.7508262556468, -122.425279266089)
85336	85336	25079	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1162 DOLORES ST	1	Median : Cutout 11	Tree 1	DPW 2			80	20		6005068.3	2101554.8	37.7507559707678	-122.42531065650499	(37.7507559707678, -122.425310656505)
121975	121975	25078	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1166 DOLORES ST	1	Median : Cutout 11	Tree 1	DPW 2			80	20		6005069.8	2101528.7	37.7506843909536	-122.42530361228901	(37.7506843909536, -122.425303612289)
93699	93699	25077	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1178 DOLORES ST	1	Median : Cutout 11	Tree 1	DPW 2			80	20		6005072.5	2101478.6	37.750546980486895	-122.42529071074	(37.7505469804869, -122.42529071074)
92759	92759	25076	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1184 DOLORES ST	1	Median : Cutout 11	Tree 1	DPW 2			80	20		6005073.9	2101453.9	37.750479239095604	-122.42528411198299	(37.7504792390956, -122.425284111983)
81675	81675	25075	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1198 DOLORES ST	1	Median : Cutout 11	Tree 1	DPW 2			80	20		6005087.7	2101404.7	37.7503449269028	-122.425232889951	(37.7503449269028, -122.425232889951)
17316	17316	25084	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200X Dolores St	4	Median : Cutout 11	Tree 1	DPW 2			90	20		6005164.22411	2101175.53736	37.7497200220711	-122.42495196167499	(37.7497200220711, -122.424951961675)
17792	17792	25085	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200X Dolores St	5	Median : Cutout 11	Tree 1	DPW 2			70	20		6005165.443630001	2101134.8464599997	37.7496083631354	-122.424944849843	(37.7496083631354, -122.424944849843)
20716	20716	25082	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200X Dolores St	2	Median : Cutout 11	Tree 1	DPW 2			90	20		6005158.72228	2101250.83835	37.7499264704292	-122.424976344106	(37.7499264704292, -122.424976344106)
21959	21959	25083	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200X Dolores St	3	Median : Cutout 11	Tree 1	DPW 2			90	20		6005162.35719	2101213.31575	37.74982364735521	-122.424961105075	(37.7498236473552, -122.424961105075)
17276	17276	25090	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1250X Dolores St	5	Median : Cutout 11	Tree 1	DPW 2			90	20		6005182.99372	2100845.43458	37.7488146961375	-122.424863573617	(37.7488146961375, -122.424863573617)
19587	19587	25088	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1250X Dolores St	3	Median : Cutout 11	Tree 1	DPW 2			90	20		6005178.85274	2100929.77786	37.7490460494561	-122.424883892899	(37.7490460494561, -122.424883892899)
20929	20929	25087	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1250X Dolores St	2	Median : Cutout 11	Tree 1	DPW 2			90	20		6005179.035519999	2100967.22192	37.7491488725392	-122.42488592444401	(37.7491488725392, -122.424885924444)
21135	21135	25089	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1250X Dolores St	4	Median : Cutout 11	Tree 1	DPW 2			90	20		6005180.26353	2100884.10883	37.748920732509	-122.424875765702	(37.748920732509, -122.424875765702)
20790	20790	25095	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1300 Dolores St	5	Median : Cutout 11	Tree 1	DPW 2			80	20		6005196.77931	2100544.39428	37.7479888873864	-122.424794489489	(37.7479888873864, -122.424794489489)
20879	20879	25092	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1300 Dolores St	2	Median : Cutout 11	Tree 1	DPW 2			80	20		6005189.02223	2100681.47449	37.7483648399821	-122.424831064022	(37.7483648399821, -122.424831064022)
21503	21503	25093	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1300 Dolores St	3	Median : Cutout 11	Tree 1	DPW 2			80	20		6005193.32199	2100633.40551	37.7482330964805	-122.424812776293	(37.7482330964805, -122.424812776293)
17425	17425	25099	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1300X Dolores St	4	Median : Cutout 11	Tree 1	DPW 2			70	20		6005195.84744	2100584.78774	37.7480997459068	-122.42480058509899	(37.7480997459068, -122.424800585099)
17620	17620	25096	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1300X Dolores St	1	Median : Cutout 11	Tree 1	DPW 2			90	20		6005188.030230001	2100718.94336	37.748467664846295	-122.42483715961001	(37.7484676648463, -122.42483715961)
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)
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)
109799	109799	25803	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1300X The Embarcadero	5	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)
112807	112807	25802	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1300X The Embarcadero	4	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)
116990	116990	25800	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1300X The Embarcadero	2	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)
140551	140551	25801	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1300X The Embarcadero	3	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)
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)
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)
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)
112942	112942	25754	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1301X The Embarcadero	7	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)
117219	117219	25750	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1301X The Embarcadero	3	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)
141888	141888	25751	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1301X The Embarcadero	4	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)
146321	146321	25753	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1301X The Embarcadero	6	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)
148059	148059	248621	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	132x McCoppin St	1	Median : Cutout 11	Tree 1	DPW 2			29	Width 0ft		6005771.7237	2109102.262	37.7715192426118	-122.42341464686501	(37.7715192426118, -122.423414646865)
106112	106112	25094	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1348 Dolores St	4	Median : Cutout 11	Tree 1	DPW 2			40	20		6005177.2486108	2100480.3758406	37.747812004334705	-122.424857472056	(37.7478120043347, -122.424857472056)
19687	19687	25091	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1350 Dolores St	1	Median : Cutout 11	Tree 1	DPW 2			80	20		6005204.68058	2100428.03656	37.7476698420965	-122.42475889070299	(37.7476698420965, -122.424758890703)
17487	17487	25100	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1350X Dolores St	5	Median : Cutout 11	Tree 1	DPW 2			60	20		6005208.528519999	2100314.21379	37.7473575282405	-122.424737488671	(37.7473575282405, -122.424737488671)
17756	17756	25098	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1350X Dolores St	3	Median : Cutout 11	Tree 1	DPW 2			90	20		6005207.855169999	2100363.5353099997	37.7474929157794	-122.424743325238	(37.7474929157794, -122.424743325238)
117928	117928	25097	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1388X Dolores St	2	Median : Cutout 11	Tree 1	DPW 2			90	20		6005167.2006822	2100254.8047856004	37.747192070496	-122.424876171578	(37.747192070496, -122.424876171578)
17004	17004	25108	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400 Dolores St	1	Median : Cutout 11	Tree 1	DPW 2			30	20		6005223.671490001	2100130.84124	37.7468548845426	-122.424672082757	(37.7468548845426, -122.424672082757)
17078	17078	25113	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400 Dolores St	6	Median : Cutout 11	Tree 1	DPW 2			30	20		6005228.94357	2100007.06865	37.7465153311328	-122.424645049125	(37.7465153311328, -122.424645049125)
17629	17629	25102	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400X Dolores St	2	Median : Cutout 11	Tree 1	DPW 2			90	20		6005226.05485	2100086.94121	37.7467344797311	-122.424660718923	(37.7467344797311, -122.424660718923)
21388	21388	25107	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400X Dolores St	7	Median : Cutout 11	Tree 1	DPW 2			70	20		6005229.6240300005	2099972.88313	37.7464215039571	-122.424640264758	(37.7464215039571, -122.424640264758)
171600	171600	248622	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	142x McCoppin St	2	Median : Cutout 11	Tree 1	DPW 2			26	Width 0ft		6005746.1935	2109104.2775	37.7715233357229	-122.423503100629	(37.7715233357229, -122.423503100629)
20817	20817	25112	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1450 Dolores St	5	Median : Cutout 11	Tree 1	DPW 2			90	20		6005235.506709999	2099747.61613	37.7458033045753	-122.42460390154699	(37.7458033045753, -122.424603901547)
20892	20892	25110	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1450 Dolores St	3	Median : Cutout 11	Tree 1	DPW 2			90	20		6005236.31225	2099800.23492	37.7459478292265	-122.42460485845301	(37.7459478292265, -122.424604858453)
21855	21855	25111	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1450 Dolores St	4	Median : Cutout 11	Tree 1	DPW 2			90	20		6005242.59316	2099769.2409599996	37.745863081619895	-122.424580935573	(37.7458630816199, -122.424580935573)
22048	22048	25106	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1450X Dolores St	6	Median : Cutout 11	Tree 1	DPW 2			90	20		6005241.17775	2099713.8788799997	37.74571099007721	-122.424581892451	(37.7457109900772, -122.424581892451)
86700	86700	25109	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1496 Dolores St	2	Median : Cutout 11	Tree 1	DPW 2			90	20		6005218.8222955	2099617.195839	37.7454442580108	-122.424652317948	(37.7454442580108, -122.424652317948)
18853	18853	24967	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	150 Dolores St	8	Median : Cutout 11	Tree 1	DPW 2			90	20		6004824.658890001	2107297.38564	37.7665099887808	-122.42656205570499	(37.7665099887808, -122.426562055705)
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)
16918	16918	25119	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500X Dolores St	6	Median : Cutout 11	Tree 1	DPW 2			30	20		6005258.69008	2099408.1764	37.7448725899054	-122.42449959638999	(37.7448725899054, -122.42449959639)
18928	18928	25116	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500X Dolores St	3	Median : Cutout 11	Tree 1	DPW 2			90	20		6005256.05434	2099495.31423	37.7451117016422	-122.42451490734301	(37.7451117016422, -122.424514907343)
21986	21986	25118	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500X Dolores St	5	Median : Cutout 11	Tree 1	DPW 2			90	20		6005257.61936	2099436.85892	37.74495128509079	-122.42450533857	(37.7449512850908, -122.42450533857)
109462	109462	25117	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1548X Dolores St	4	Median : Cutout 11	Tree 1	DPW 2			90	20		6005242.6409807	2099315.8732106998	37.7446182400704	-122.42454852673201	(37.7446182400704, -122.424548526732)
18284	18284	25123	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1550 Dolores St	4	Median : Cutout 11	Tree 1	DPW 2			90	20		6005274.82817	2099143.28527	37.744146170621704	-122.424424956245	(37.7441461706217, -122.424424956245)
19053	19053	25122	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1550 Dolores St	3	Median : Cutout 11	Tree 1	DPW 2			90	20		6005275.20405	2099188.4733700003	37.7442702680707	-122.42442687003	(37.7442702680707, -122.42442687003)
21512	21512	25120	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1550 Dolores St	1	Median : Cutout 11	Tree 1	DPW 2			90	20		6005269.99247	2099258.02767	37.744460954018	-122.424449836913	(37.744460954018, -122.424449836913)
20326	20326	25115	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1550X Dolores St	2	Median : Cutout 11	Tree 1	DPW 2			90	20		6005272.16967	2099229.32207	37.7443822579348	-122.424440267208	(37.7443822579348, -122.424440267208)

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