Street_Tree_List

Data source: data.sfgov.org

195 rows where qSiteInfo = 3 and qSpecies = 100 sorted by rowid descending

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
187874	187874	194313	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			12	Width 7ft		6015116.8381	2116756.98357	37.793060384871	-122.391624402345	(37.793060384871, -122.391624402345)
186747	186747	194316	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	8	Median : Yard 3	Tree 1	DPW 2			26	Width 7ft		6014969.23068	2116866.2603700003	37.793352239169295	-122.392142782374	(37.7933522391693, -122.392142782374)
186566	186566	132093	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			25	Width 10ft		6012902.31977	2119848.32419	37.8014252975988	-122.39950394556699	(37.8014252975988, -122.399503945567)
185868	185868	132133	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	500x The Embarcadero	13	Median : Yard 3	Tree 1	DPW 2			27	Width 10ft		6013516.34459	2118862.0699	37.7987514845508	-122.39730992891	(37.7987514845508, -122.39730992891)
183458	183458	194358	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6016102.75205	2114084.3299	37.7857765633769	-122.388026462162	(37.7857765633769, -122.388026462162)
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)
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)
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)
182470	182470	132107	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			22	Width 10ft		6011604.73213	2121437.1460700002	37.805715402812204	-122.40410608402901	(37.8057154028122, -122.404106084029)
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)
182110	182110	194322	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	400x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			22	Width 7ft		6014773.3420400005	2117151.64182	37.7941249519603	-122.392840551058	(37.7941249519603, -122.392840551058)
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)
181994	181994	132108	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6011532.668269999	2121506.48507	37.8059017639302	-122.404360356561	(37.8059017639302, -122.404360356561)
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)
178718	178718	194367	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	310x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			32	Width 8ft		6016138.88729	2114959.31506	37.7881810762396	-122.38796252216999	(37.7881810762396, -122.38796252217)
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)
177459	177459	132104	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			19	Width 10ft		6012041.8343	2121038.82925	37.8046461349625	-122.402565391602	(37.8046461349625, -122.402565391602)
176923	176923	132084	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			25	Width 10ft		6012274.61558	2120706.35336	37.8037462301721	-122.401736440606	(37.8037462301721, -122.401736440606)
176286	176286	132079	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	11	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6012611.87531	2120208.19637	37.8023972264213	-122.40053431322399	(37.8023972264213, -122.400534313224)
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)
174052	174052	194319	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	11	Median : Yard 3	Tree 1	DPW 2			19	Width 7ft		6014937.91263	2116957.6212	37.793601355862705	-122.392257538577	(37.7936013558627, -122.392257538577)
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)
173116	173116	194373	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	310x The Embarcadero	10	Median : Yard 3	Tree 1	DPW 2			29	Width 8ft		6016083.2484800005	2115225.4963700003	37.7889088670017	-122.38817360834	(37.7889088670017, -122.38817360834)
171516	171516	194323	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	400x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			15	Width 7ft		6014746.37404	2117187.8708099998	37.7942229303951	-122.39293639989201	(37.7942229303951, -122.392936399892)
170290	170290	194382	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	300x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6015730.53426	2115716.1031299997	37.7902364120368	-122.389428237241	(37.7902364120368, -122.389428237241)
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)
168748	168748	132110	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6011374.63029	2121626.67271	37.8062229369941	-122.404915741893	(37.8062229369941, -122.404915741893)
168474	168474	132105	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6012001.46692	2121074.30881	37.8047412994387	-122.402707584299	(37.8047412994387, -122.402707584299)
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)
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)
166867	166867	132106	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6011673.52168	2121373.1691	37.8055435810345	-122.40386352159099	(37.8055435810345, -122.403863521591)
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)
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)
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)
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)
164799	164799	194376	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	310x The Embarcadero	13	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016101.40226	2115318.33028	37.789164773592205	-122.38811727930201	(37.7891647735922, -122.388117279302)
164266	164266	132076	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			25	Width 10ft		6012766.891340001	2119978.53875	37.8017752858665	-122.399981740966	(37.8017752858665, -122.399981740966)
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)
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)
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)
162235	162235	194317	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			22	Width 7ft		6014996.79198	2116890.75749	37.7934210328094	-122.392049131461	(37.7934210328094, -122.392049131461)
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)
160227	160227	194315	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	7	Median : Yard 3	Tree 1	DPW 2			20	Width 7ft		6015053.743430001	2116822.79374	37.793237581902105	-122.391847319118	(37.7932375819021, -122.391847319118)
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)
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)
157962	157962	194366	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	310x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016195.859569999	2114866.22772	37.78792863564279	-122.387758908461	(37.7879286356428, -122.387758908461)
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)
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)
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)
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)
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)
155474	155474	132089	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	6	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6011437.6783	2121540.455	37.805989728403894	-122.404691478852	(37.8059897284039, -122.404691478852)
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)
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)
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)
154122	154122	194384	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	300x The Embarcadero	7	Median : Yard 3	Tree 1	DPW 2			27	Width 8ft		6015676.83265	2115781.59367	37.7904132565166	-122.38961861831699	(37.7904132565166, -122.389618618317)
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)
153490	153490	132085	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1300x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6012153.585109999	2120867.04559	37.8041806971541	-122.402166580042	(37.8041806971541, -122.402166580042)
153149	153149	194381	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	300x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6015827.50848	2115690.11268	37.79017042428	-122.389090895237	(37.79017042428, -122.389090895237)
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)
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)
152011	152011	194318	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	10	Median : Yard 3	Tree 1	DPW 2			24	Width 7ft		6014918.376630001	2116934.10067	37.7935356891802	-122.392323489462	(37.7935356891802, -122.392323489462)
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)
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)
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)
150555	150555	132096	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	8	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6012742.85934	2120080.46122	37.8020538004962	-122.400072065282	(37.8020538004962, -122.400072065282)
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)
149311	149311	132111	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	11	Median : Yard 3	Tree 1	DPW 2			22	Width 10ft		6011290.22315	2121683.26622	37.806373610322105	-122.40521183646999	(37.8063736103221, -122.40521183647)
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)
148681	148681	194369	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	310x The Embarcadero	6	Median : Yard 3	Tree 1	DPW 2			26	Width 8ft		6016121.084980001	2115040.32123	37.7884025145026	-122.388029770758	(37.7884025145026, -122.388029770758)
147998	147998	132115	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	6	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6013243.85901	2119336.7003900004	37.8000395322586	-122.398286142085	(37.8000395322586, -122.398286142085)
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)
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)
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)
137882	137882	132117	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	10	Median : Yard 3	Tree 1	DPW 2			17	Width 10ft		6013132.776319999	2119506.7755299998	37.800500329583	-122.398682475136	(37.800500329583, -122.398682475136)
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)
136668	136668	194314	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	6	Median : Yard 3	Tree 1	DPW 2			20	Width 7ft		6015030.092180001	2116803.1524	37.793182338337296	-122.39192778056601	(37.7931823383373, -122.391927780566)
136050	136050	132086	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6011972.21269	2121045.33445	37.8046601095467	-122.402806783124	(37.8046601095467, -122.402806783124)
135993	135993	132130	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	500x The Embarcadero	10	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		6013704.00439	2118650.24995	37.79818032331121	-122.39664570406099	(37.7981803233112, -122.396645704061)
135215	135215	194383	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	300x The Embarcadero	6	Median : Yard 3	Tree 1	DPW 2			29	Width 8ft		6015768.92359	2115752.8180400003	37.7903393511162	-122.389297976729	(37.7903393511162, -122.389297976729)
135157	135157	132081	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	16	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6012501.69351	2120366.8481099997	37.802826700352995	-122.400926752172	(37.802826700353, -122.400926752172)
134092	134092	194378	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	300x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			27	Width 8ft		6015852.133669999	2115594.9283	37.7899104347693	-122.388999044794	(37.7899104347693, -122.388999044794)
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)
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)
133391	133391	194310	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			20	Width 7ft		6015149.43028	2116672.0498900004	37.7928289857212	-122.39150569005301	(37.7928289857212, -122.391505690053)
133036	133036	132072	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		6013209.184309999	2119314.66631	37.799977100409	-122.39840458371201	(37.799977100409, -122.398404583712)
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)
131771	131771	132074	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6013098.86351	2119482.52775	37.800431861502396	-122.39879812525601	(37.8004318615024, -122.398798125256)
131405	131405	194320	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	400x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			23	Width 7ft		6014831.89764	2117081.36813	37.7939352489635	-122.392633022622	(37.7939352489635, -122.392633022622)
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)
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)
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)
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)
130206	130206	194374	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	310x The Embarcadero	11	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		6016126.62936	2115234.83636	37.788936915964705	-122.388024167087	(37.7889369159647, -122.388024167087)
129992	129992	132099	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	14	Median : Yard 3	Tree 1	DPW 2			22	Width 10ft		6012592.45443	2120302.68635	37.8026555899447	-122.40060816104099	(37.8026555899447, -122.400608161041)
127243	127243	194363	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	380x The Embarcadero	10	Median : Yard 3	Tree 1	DPW 2			27	Width 8ft		6016134.25394	2114462.08003	37.7868155249754	-122.387943842344	(37.7868155249754, -122.387943842344)
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)
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)
119303	119303	194372	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	310x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			30	Width 8ft		6016142.80175	2115153.3259099997	37.788714002784296	-122.387962522166	(37.7887140027843, -122.387962522166)
115831	115831	132073	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	7	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		6013155.58738	2119398.1180000002	37.800203252927105	-122.39859590999501	(37.8002032529271, -122.398595909995)

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