Street_Tree_List

Data source: data.sfgov.org

195 rows where qSiteInfo = 3 and qSpecies = 100 sorted by YCoord

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, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord ▼	Latitude	Longitude	Location
22823	22823	251110	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	5	Median : Yard 3	Tree 1	DPW 2
22825	22825	251109	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	3	Median : Yard 3	Tree 1	DPW 2
22828	22828	251115	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	19	Median : Yard 3	Tree 1	DPW 2
22831	22831	251116	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	20	Median : Yard 3	Tree 1	DPW 2
22832	22832	251108	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	2	Median : Yard 3	Tree 1	DPW 2
22833	22833	251113	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	15	Median : Yard 3	Tree 1	DPW 2
22838	22838	251111	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	7	Median : Yard 3	Tree 1	DPW 2
22839	22839	251114	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700X Quesada Ave	16	Median : Yard 3	Tree 1	DPW 2
35928	35928	194284	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	20	Median : Yard 3	Tree 1	DPW 2			31			6014504.15008	2095180.2076400002	37.733781239407	-122.392234619349	(37.733781239407, -122.392234619349)
166815	166815	194285	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	28	Median : Yard 3	Tree 1	DPW 2			30			6014471.94536	2095201.4069599998	37.7338376601657	-122.39234744377701	(37.7338376601657, -122.392347443777)
150397	150397	194286	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	29	Median : Yard 3	Tree 1	DPW 2			36			6014450.16973	2095221.3993900002	37.7338913460907	-122.392424127176	(37.7338913460907, -122.392424127176)
39870	39870	194287	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	32	Median : Yard 3	Tree 1	DPW 2			31			6014435.322380001	2095233.3766599998	37.733923408722795	-122.392476296866	(37.7339234087228, -122.392476296866)
35608	35608	194288	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	37	Median : Yard 3	Tree 1	DPW 2			34			6014411.93404	2095259.01392	37.733992504551296	-122.392558950849	(37.7339925045513, -122.392558950849)
58702	58702	194289	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	38	Median : Yard 3	Tree 1	DPW 2			48			6014396.14271	2095264.76436	37.734007417094	-122.39261394888901	(37.734007417094, -122.392613948889)
70141	70141	194290	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	40	Median : Yard 3	Tree 1	DPW 2			27			6014381.3022300005	2095272.57767	37.7340280466394	-122.39266580380101	(37.7340280466394, -122.392665803801)
54354	54354	194291	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	41	Median : Yard 3	Tree 1	DPW 2			38			6014364.32912	2095287.3135099998	37.7340675655682	-122.39272551607701	(37.7340675655682, -122.392725516077)
27134	27134	194292	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	43	Median : Yard 3	Tree 1	DPW 2			38			6014354.24031	2095291.86255	37.734079495961396	-122.392760714642	(37.7340794959614, -122.392760714642)
27594	27594	194293	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	46	Median : Yard 3	Tree 1	DPW 2			28			6014318.796490001	2095319.19207	37.7341525685742	-122.392885167337	(37.7341525685742, -122.392885167337)
54350	54350	194294	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	49	Median : Yard 3	Tree 1	DPW 2			27			6014297.19865	2095334.47415	37.7341933303645	-122.392960907318	(37.7341933303645, -122.392960907318)
47964	47964	234371	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1750x Dolores St	5	Median : Yard 3	Tree 1	DPW 2			35			6005338.50183	2098008.71997	37.7410345073494	-122.42412411595	(37.7410345073494, -122.42412411595)
148964	148964	234370	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1750x Dolores St	4	Median : Yard 3	Tree 1	DPW 2			35			6005335.592730001	2098044.06455	37.7411313913144	-122.42413668757	(37.7411313913144, -122.42413668757)
68375	68375	234369	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1750x Dolores St	3	Median : Yard 3	Tree 1	DPW 2			18			6005339.90624	2098058.76544	37.7411720001789	-122.42412281821899	(37.7411720001789, -122.424122818219)
123736	123736	234368	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1750x Dolores St	1	Median : Yard 3	Tree 1	DPW 2			21			6005333.75186	2098133.92444	37.7413780222889	-122.42414944174	(37.7413780222889, -122.42414944174)
94540	94540	106114	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1752X DOLORES ST	1	Median : Yard 3	Tree 1	DPW 2						6005197.0	2098194.1	37.741535528464496	-122.424626562024	(37.7415355284645, -122.424626562024)
47477	47477	234367	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1650x Dolores St	5	Median : Yard 3	Tree 1	DPW 2			44			6005309.50054	2098532.58451	37.7424712831236	-122.424261641173	(37.7424712831236, -122.424261641173)
133800	133800	234346	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1350x Dolores St	7	Median : Yard 3	Tree 1	DPW 2			33			6005214.83803	2100265.33674	37.74722367943539	-122.424712194312	(37.7472236794354, -122.424712194312)
71379	71379	234345	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1350x Dolores St	6	Median : Yard 3	Tree 1	DPW 2			34			6005211.50018	2100294.54181	37.7473036813364	-122.424725813644	(37.7473036813364, -122.424725813644)
158301	158301	234365	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	7	Median : Yard 3	Tree 1	DPW 2			33			6005150.81264	2101423.31762	37.7503996118641	-122.425015966416	(37.7503996118641, -122.425015966416)
132937	132937	234364	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	6	Median : Yard 3	Tree 1	DPW 2			23			6005148.136969999	2101464.62312	37.7505128760752	-122.425028157637	(37.7505128760752, -122.425028157637)
151204	151204	234363	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	5	Median : Yard 3	Tree 1	DPW 2			25			6005145.85028	2101496.26634	37.7505996318694	-122.425038316369	(37.7505996318694, -122.425038316369)
33156	33156	234362	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	4	Median : Yard 3	Tree 1	DPW 2			25			6005144.45634	2101528.47617	37.7506879938715	-122.425045428228	(37.7506879938715, -122.425045428228)
154721	154721	234361	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	3	Median : Yard 3	Tree 1	DPW 2			27			6005142.97819	2101556.59196	37.75076510982829	-122.42505254004699	(37.7507651098283, -122.425052540047)
63890	63890	234360	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Dolores St	2	Median : Yard 3	Tree 1	DPW 2			21			6005142.56045	2101579.1271	37.7508269625113	-122.425055587855	(37.7508269625113, -122.425055587855)
47801	47801	234359	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x Dolores St	13	Median : Yard 3	Tree 1	DPW 2			31			6005116.63925	2102018.48994	37.752031886768705	-122.42517648553302	(37.7520318867687, -122.425176485533)
150698	150698	234330	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	900x Dolores St	15	Median : Yard 3	Tree 1	DPW 2			23			6005083.062580001	2102603.58555	37.7536365264144	-122.42533423108699	(37.7536365264144, -122.425334231087)
155084	155084	234329	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	900x Dolores St	14	Median : Yard 3	Tree 1	DPW 2			27			6005081.6594	2102660.65252	37.7537931397475	-122.425343144298	(37.7537931397475, -122.425343144298)
167096	167096	234328	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	850x Dolores St	4	Median : Yard 3	Tree 1	DPW 2			23			6005051.1738	2103243.46642	37.7553916882954	-122.425490044948	(37.7553916882954, -122.425490044948)
174328	174328	234327	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	850x Dolores St	3	Median : Yard 3	Tree 1	DPW 2			29			6005045.03345	2103276.5066400003	37.755482062073604	-122.425513631455	(37.7554820620736, -122.425513631455)
164848	164848	234326	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	850x Dolores St	1	Median : Yard 3	Tree 1	DPW 2			27			6005043.60607	2103360.12702	37.755711583428294	-122.425524518639	(37.7557115834283, -122.425524518639)
151971	151971	194274	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Tennessee St	17	Median : Yard 3	Tree 1	DPW 2			28			6015578.255919999	2103421.32087	37.756469211897	-122.389096301947	(37.756469211897, -122.389096301947)
152917	152917	194273	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1150x Tennessee St	16	Median : Yard 3	Tree 1	DPW 2			20	Width 8ft		6015573.17514	2103426.7647700002	37.7564838780418	-122.38911425333	(37.7564838780418, -122.38911425333)
138553	138553	116529	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	745X SANCHEZ ST	6	Median : Yard 3	Tree 1	DPW 2			18			6003713.0	2103768.0	37.7567562336472	-122.430155272915	(37.7567562336472, -122.430155272915)
131012	131012	234358	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	650x Dolores St	5	Median : Yard 3	Tree 1	DPW 2			23			6004991.05597	2104342.31446	37.7584054702508	-122.425776160656	(37.7584054702508, -122.425776160656)
179789	179789	234357	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	650x Dolores St	4	Median : Yard 3	Tree 1	DPW 2			24			6004986.096919999	2104380.3629099997	37.758509662101204	-122.425796019476	(37.7585096621012, -122.425796019476)
38595	38595	234356	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	650x Dolores St	3	Median : Yard 3	Tree 1	DPW 2			22			6004985.9304599995	2104422.99085	37.7586266989802	-122.42579962935301	(37.7586266989802, -122.425799629353)
157237	157237	234355	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	650x Dolores St	2	Median : Yard 3	Tree 1	DPW 2			27			6004978.4588	2104465.76881	37.7587437349524	-122.425828514675	(37.7587437349524, -122.425828514675)
27355	27355	234354	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	650x Dolores St	1	Median : Yard 3	Tree 1	DPW 2			23			6004979.813630001	2104508.3497200003	37.7588607286626	-122.425826859935	(37.7588607286626, -122.425826859935)
182038	182038	234353	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	600x Dolores St	5	Median : Yard 3	Tree 1	DPW 2			22			6004972.999969999	2104631.70012	37.7591990347337	-122.425859204936	(37.7591990347337, -122.425859204936)
130698	130698	234352	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	600x Dolores St	4	Median : Yard 3	Tree 1	DPW 2			45			6004969.77736	2104678.02917	37.7593260612613	-122.425873648056	(37.7593260612613, -122.425873648056)
177827	177827	234351	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	600x Dolores St	3	Median : Yard 3	Tree 1	DPW 2			30			6004966.99113	2104720.1905900002	37.759441669116796	-122.425886285347	(37.7594416691168, -122.425886285347)
165757	165757	234350	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	600x Dolores St	2	Median : Yard 3	Tree 1	DPW 2			25			6004963.57632	2104757.16703	37.759543004714	-122.425900727537	(37.759543004714, -122.425900727537)
161954	161954	234349	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	600x Dolores St	1	Median : Yard 3	Tree 1	DPW 2			29			6004962.28051	2104795.65924	37.7596486220069	-122.42590794909599	(37.7596486220069, -122.425907949096)
119491	119491	234348	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	550x Dolores St	5	Median : Yard 3	Tree 1	DPW 2			33			6004955.107340001	2105017.7620200003	37.760258058393205	-122.425948567888	(37.7602580583932, -122.425948567888)
133649	133649	234347	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	550x Dolores St	1	Median : Yard 3	Tree 1	DPW 2			28			6004944.62757	2105117.25917	37.760530661773	-122.425991895418	(37.760530661773, -122.425991895418)
156553	156553	233943	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	450x Dolores St	7	Median : Yard 3	Tree 1	DPW 2			32			6004924.09393	2105519.3056799998	37.7616334257704	-122.426091534022	(37.7616334257704, -122.426091534022)
164800	164800	233942	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	450x Dolores St	2	Median : Yard 3	Tree 1	DPW 2			35			6004917.83694	2105642.84744	37.7619722884988	-122.426121969753	(37.7619722884988, -122.426121969753)
156879	156879	233941	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	370x Dolores St	1	Median : Yard 3	Tree 1	DPW 2			32			6004887.91201	2106172.4684599997	37.7634248105293	-122.426263176805	(37.7634248105293, -122.426263176805)
49252	49252	233940	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	270x Dolores St	2	Median : Yard 3	Tree 1	DPW 2			27			6004851.53435	2106800.76384	37.7651479034782	-122.426433734123	(37.7651479034782, -122.426433734123)
71756	71756	233939	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	270x Dolores St	1	Median : Yard 3	Tree 1	DPW 2			32			6004850.2917	2106826.33652	37.765218049699605	-122.426439853137	(37.7652180496996, -122.426439853137)
170250	170250	233938	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	230x Dolores St	4	Median : Yard 3	Tree 1	DPW 2			33			6004845.02149	2106914.0966	37.7654587199743	-122.426464330874	(37.7654587199743, -122.426464330874)
35273	35273	233937	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	230x Dolores St	3	Median : Yard 3	Tree 1	DPW 2			32			6004843.94175	2106947.59382	37.7655506342911	-122.42647045077801	(37.7655506342911, -122.426470450778)
41120	41120	233936	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	230x Dolores St	2	Median : Yard 3	Tree 1	DPW 2			34			6004841.8872	2106976.70647	37.7656304545194	-122.42647963012699	(37.7656304545194, -122.426479630127)
24494	24494	233935	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	150x Dolores St	9	Median : Yard 3	Tree 1	DPW 2			30			6004826.52958	2107279.95522	37.766462234780604	-122.426554344032	(37.7664622347806, -122.426554344032)
72308	72308	233934	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	150x Dolores St	7	Median : Yard 3	Tree 1	DPW 2			34			6004824.15396	2107326.99928	37.7665912721916	-122.42656591108101	(37.7665912721916, -122.426565911081)
73360	73360	233933	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	150x Dolores St	3	Median : Yard 3	Tree 1	DPW 2			35			6004817.19467	2107404.1110799997	37.76680260927	-122.426595473608	(37.76680260927, -122.426595473608)
182641	182641	233932	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	150x Dolores St	2	Median : Yard 3	Tree 1	DPW 2			24			6004814.58298	2107439.6885599997	37.7669001488458	-122.426607040704	(37.7669001488458, -122.426607040704)
58200	58200	246535	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1x Octavia St	1	Median : Yard 3	Tree 1	DPW 2			29	Width 8ft		6005703.308569999	2109325.61851	37.7721286642513	-122.423667182089	(37.7721286642513, -122.423667182089)
137727	137727	246536	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1x Octavia St	2	Median : Yard 3	Tree 1	DPW 2			31	Width 8ft		6005696.49055	2109344.97624	37.7721814310539	-122.42369214280501	(37.7721814310539, -122.423692142805)
162596	162596	194326	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	2	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6015764.48229	2112042.08861	37.7801502823482	-122.38905414805599	(37.7801502823482, -122.389054148056)
164090	164090	194328	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	4	Median : Yard 3	Tree 1	DPW 2			32	Width 8ft		6015816.38649	2112097.21372	37.7803045205874	-122.388878435804	(37.7803045205874, -122.388878435804)
156409	156409	194327	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	3	Median : Yard 3	Tree 1	DPW 2			25	Width 8ft		6015782.92624	2112129.67425	37.780391795274	-122.388996458319	(37.780391795274, -122.388996458319)
46468	46468	194330	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	6	Median : Yard 3	Tree 1	DPW 2			32	Width 8ft		6015863.586519999	2112149.96757	37.780451986896296	-122.38871883132	(37.7804519868963, -122.38871883132)
59677	59677	194329	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	5	Median : Yard 3	Tree 1	DPW 2			29	Width 8ft		6015829.09984	2112179.7817	37.7805319384279	-122.388840220015	(37.7805319384279, -122.388840220015)
55186	55186	194332	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	8	Median : Yard 3	Tree 1	DPW 2			33	Width 8ft		6015905.66871	2112206.70701	37.7806101129033	-122.38857720969601	(37.7806101129033, -122.388577209696)
55101	55101	194331	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	7	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6015869.7392	2112229.4323400003	37.7806705203569	-122.388703094985	(37.7806705203569, -122.388703094985)
27329	27329	194334	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	10	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6015942.04821	2112270.67914	37.7807877820727	-122.388455820993	(37.7807877820727, -122.388455820993)
51725	51725	194333	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	9	Median : Yard 3	Tree 1	DPW 2			31	Width 8ft		6015903.377169999	2112286.3418900003	37.78082864545979	-122.38859069771999	(37.7808286454598, -122.38859069772)
61273	61273	194336	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	12	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6015966.10007	2112335.54697	37.7809672274079	-122.38837714201799	(37.7809672274079, -122.388377142018)
29064	29064	194335	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	11	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6015932.5598	2112347.87113	37.7809992081901	-122.38849403588999	(37.7809992081901, -122.38849403589)
155383	155383	194338	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	14	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6015989.55415	2112403.0150099997	37.781153779156206	-122.388300712233	(37.7811537791562, -122.388300712233)
35716	35716	194337	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	13	Median : Yard 3	Tree 1	DPW 2			29	Width 8ft		6015953.29851	2112409.5704799998	37.781169770014294	-122.38842659752198	(37.7811697700143, -122.388426597522)
173586	173586	194339	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	15	Median : Yard 3	Tree 1	DPW 2			21	Width 8ft		6015964.49017	2112481.16819	37.781366981449295	-122.388392878343	(37.7813669814493, -122.388392878343)
155521	155521	194340	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	88x King St	16	Median : Yard 3	Tree 1	DPW 2			26	Width 8ft		6015972.31673	2112547.01001	37.7815482020175	-122.388370398867	(37.7815482020175, -122.388370398867)
43461	43461	194341	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			25	Width 8ft		6016036.61123	2112738.53497	37.7820776491035	-122.388161338867	(37.7820776491035, -122.388161338867)
182277	182277	194342	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			26	Width 8ft		6016043.56926	2112825.74631	37.7823174973895	-122.38814335514999	(37.7823174973895, -122.38814335515)
153572	153572	194344	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016049.59347	2112931.0937900003	37.7826070916921	-122.38812986802	(37.7826070916921, -122.38812986802)
182585	182585	194343	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			29	Width 8ft		6016001.634319999	2112937.23784	37.7826213045779	-122.38829621649799	(37.7826213045779, -122.388296216498)
130735	130735	194346	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	6	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6016057.40985	2113028.64004	37.782875364847705	-122.388109635977	(37.7828753648477, -122.388109635977)
163146	163146	194345	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016011.38638	2113034.09815	37.7828878015789	-122.388269240457	(37.7828878015789, -122.388269240457)
76413	76413	194348	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	8	Median : Yard 3	Tree 1	DPW 2			32	Width 8ft		6016063.83562	2113121.68463	37.783131200395296	-122.388093900527	(37.7831312003953, -122.388093900527)
56517	56517	194347	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	7	Median : Yard 3	Tree 1	DPW 2			32	Width 8ft		6016017.18881	2113128.44937	37.783147190320896	-122.388255753298	(37.7831471903209, -122.388255753298)
71598	71598	194349	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			25	Width 8ft		6016039.59045	2113336.99155	37.7837210414445	-122.388192810667	(37.7837210414445, -122.388192810667)
130277	130277	194351	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	11	Median : Yard 3	Tree 1	DPW 2			31	Width 8ft		6016097.15673	2113420.59165	37.7839537779004	-122.387999487006	(37.7839537779004, -122.387999487006)
168401	168401	194350	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	10	Median : Yard 3	Tree 1	DPW 2			29	Width 8ft		6016048.53605	2113426.10211	37.7839662146185	-122.388168082915	(37.7839662146185, -122.388168082915)
66121	66121	194352	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	12	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016055.63748	2113520.42583	37.7842255997618	-122.388150099168	(37.7842255997618, -122.388150099168)
182808	182808	194353	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	418x The Embarcadero	13	Median : Yard 3	Tree 1	DPW 2			26	Width 8ft		6016057.99648	2113605.1395799997	37.7844583353237	-122.388147851742	(37.7844583353237, -122.388147851742)
152768	152768	194354	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			27	Width 8ft		6016129.928040001	2113821.08982	37.7850552711313	-122.387914064893	(37.7850552711313, -122.387914064893)
147393	147393	194355	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016135.3126300005	2113894.74213	37.785257802049706	-122.38790057687001	(37.7852578020497, -122.38790057687)
158245	158245	194357	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x King St	4	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016143.59514	2113983.21728	37.7855011936686	-122.387878097405	(37.7855011936686, -122.387878097405)
138222	138222	194356	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016092.96172	2113985.53296	37.7855047469016	-122.38805343733401	(37.7855047469016, -122.388053437334)

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