Street_Tree_List

Data source: data.sfgov.org

264 rows where PlotSize = "Width 10ft" and qSiteInfo = 3

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: qSpecies, SiteOrder

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
22808	22808	195725	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	9	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6014714.95739	2111115.10019	37.7775467477219	-122.39262009845	(37.7775467477219, -122.39262009845)
23395	23395	208305	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	600x Bosworth St	6	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		6002233.89157	2095386.08451	37.7336575763338	-122.43467122191299	(37.7336575763338, -122.434671221913)
23773	23773	222832	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3250x Cesar Chavez St	4	Median : Yard 3	Tree 1	DPW 2			6	Width 10ft		6007936.88236	2100571.1337200003	37.7482166910686	-122.415321190215	(37.7482166910686, -122.415321190215)
23802	23802	132129	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	500x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		6013671.61354	2118630.60451	37.79812457884061	-122.39675640879999	(37.7981245788406, -122.3967564088)
24175	24175	221317	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3500x Cesar Chavez St	17	Median : Yard 3	Tree 1	DPW 2			11	Width 10ft		6005983.198059999	2100540.62132	37.74802291412821	-122.422074813715	(37.7480229141282, -122.422074813715)
24528	24528	220701	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3200x Cesar Chavez St	8	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6008127.92361	2100571.71997	37.7482290360503	-122.41466061482001	(37.7482290360503, -122.41466061482)
25048	25048	132103	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			18	Width 10ft		6012095.78368	2120981.89347	37.8044928149639	-122.402374687645	(37.8044928149639, -122.402374687645)
25390	25390	132077	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	7	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6012714.4120000005	2120058.1365799997	37.8019909162964	-122.400168938451	(37.8019909162964, -122.400168938451)
26272	26272	221314	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3500x Cesar Chavez St	7	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6006208.09255	2100562.38879	37.7480953644201	-122.421298681694	(37.7480953644201, -122.421298681694)
26428	26428	195683	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	12	Median : Yard 3	Tree 1	DPW 2			10	Width 10ft		6015319.49651	2111685.54707	37.7791466227626	-122.390568648644	(37.7791466227626, -122.390568648644)
26820	26820	212114	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1902x Monterey Blvd	2	Median : Yard 3	Tree 1	DPW 2			36	Width 10ft		5992265.63325	2095412.1953200002	37.7331583221951	-122.46913599464399	(37.7331583221951, -122.469135994644)
27286	27286	132113	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6013330.52243	2119204.92075	37.7996825238869	-122.39797700193701	(37.7996825238869, -122.397977001937)
27382	27382	220720	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3050x Cesar Chavez St	9	Median : Yard 3	Tree 1	DPW 2			11	Width 10ft		6009105.68993	2100578.18161	37.7483016643881	-122.411279971504	(37.7483016643881, -122.411279971504)
27977	27977	195679	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	8	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6015392.54447	2111760.15634	37.779355535273105	-122.390321157906	(37.7793555352731, -122.390321157906)
29486	29486	212111	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1802x Monterey Blvd	2	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		5992507.56631	2095396.9538900002	37.7331304494932	-122.46829846591801	(37.7331304494932, -122.468298465918)
30314	30314	222818	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	11	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6006120.27144	2100551.46467	37.7480604176603	-122.42160158864701	(37.7480604176603, -122.421601588647)
30823	30823	132092	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	12	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6011191.46105	2121714.3637599996	37.806453474602	-122.405555813649	(37.806453474602, -122.405555813649)
31210	31210	222842	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3100x Cesar Chavez St	9	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		6008782.20284	2100575.62151	37.748276486974	-122.412398404384	(37.748276486974, -122.412398404384)
31521	31521	175079	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1104x Alemany Blvd	1	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		6003837.73065	2094453.4628599999	37.7311877286109	-122.42905980937599	(37.7311877286109, -122.429059809376)
31857	31857	231585	DPW Maintained 3	Maytenus boaria :: Mayten 22	431x Precita Ave	6	Median : Yard 3	Tree 1	DPW 2			11	Width 10ft		6009398.516009999	2100214.89152	37.747320568797896	-122.41024173659201	(37.7473205687979, -122.410241736592)
32237	32237	250565	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	6300x Geary Blvd	8	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5987286.538	2112566.9152	37.7799715553521	-122.48760963785601	(37.7799715553521, -122.487609637856)
32361	32361	195685	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	14	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6015271.08065	2111640.36137	37.7790198669015	-122.390732981757	(37.7790198669015, -122.390732981757)
32767	32767	221303	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3400x Cesar Chavez St	2	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		6007015.521380001	2100564.44765	37.7481465061704	-122.4185067616	(37.7481465061704, -122.4185067616)
32862	32862	132075	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6012816.85763	2119903.53523	37.8015721299035	-122.399803563704	(37.8015721299035, -122.399803563704)
32868	32868	251069	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5200x Geary Blvd	1	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		5990794.5513	2112690.3427	37.7805144291466	-122.47548298954099	(37.7805144291466, -122.475482989541)
33183	33183	209132	DPW Maintained 3	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	900x Bosworth St	18	Median : Yard 3	Tree 1	DPW 2			22	Width 10ft		6001073.50305	2095703.1639599998	37.7344622582302	-122.438705728106	(37.7344622582302, -122.438705728106)
33946	33946	211008	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	700x Bosworth St	2	Median : Yard 3	Tree 1	DPW 2			33	Width 10ft		6002060.330030001	2095430.49234	37.7337696552405	-122.435274449372	(37.7337696552405, -122.435274449372)
34570	34570	251048	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	5700x Geary Blvd	2	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5989255.4598	2112633.0799	37.7802678632993	-122.480803179963	(37.7802678632993, -122.480803179963)
34980	34980	195728	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	12	Median : Yard 3	Tree 1	DPW 2			6	Width 10ft		6014648.54809	2111053.65479	37.7773743440827	-122.39284553241501	(37.7773743440827, -122.392845532415)
37174	37174	132080	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	13	Median : Yard 3	Tree 1	DPW 2			26	Width 10ft		6012562.54875	2120282.53748	37.802598598112	-122.40071023410101	(37.802598598112, -122.400710234101)
37381	37381	220716	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3050x Cesar Chavez St	2	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6009255.72081	2100578.93816	37.74831215498521	-122.410761220066	(37.7483121549852, -122.410761220066)
37406	37406	222810	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3400x Cesar Chavez St	9	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6006867.8232	2100561.0017	37.7481287283566	-122.41901725364599	(37.7481287283566, -122.419017253646)
37743	37743	222835	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3050x Cesar Chavez St	4	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6009216.18805	2100578.21721	37.74830795876021	-122.410897872946	(37.7483079587602, -122.410897872946)
38581	38581	195678	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	7	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6015414.68674	2111779.65655	37.779410306669796	-122.39024592062	(37.7794103066698, -122.39024592062)
38678	38678	194023	DPW Maintained 3	Morus alba :: White Mulberry 112	1100x Bay Shore Blvd	4	Median : Yard 3	Tree 1	DPW 2			7	Width 10ft		6011366.79301	2093982.63877	37.730318262277606	-122.402997255042	(37.7303182622776, -122.402997255042)
38839	38839	194025	DPW Maintained 3	Morus alba :: White Mulberry 112	1100x Bay Shore Blvd	6	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		6011395.816869999	2093961.4424599998	37.730261682333605	-122.402895424807	(37.7302616823336, -122.402895424807)
39879	39879	222824	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3200x Cesar Chavez St	4	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		6008202.20567	2100572.2127900003	37.7482345623906	-122.41440378373001	(37.7482345623906, -122.41440378373)
40342	40342	251093	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	6100x Geary Blvd	13	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5987925.4225	2112589.2174	37.780070032325	-122.485401115216	(37.780070032325, -122.485401115216)
41127	41127	132091	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	10	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6011272.98764	2121658.8993	37.806305741188204	-122.405269766312	(37.8063057411882, -122.405269766312)
41755	41755	126624	DPW Maintained 3	Ficus microcarpa :: Chinese Banyan 94	801x Greenwich St	1	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6009066.28691	2120109.01558	37.801926529358504	-122.41279682292401	(37.8019265293585, -122.412796822924)
41989	41989	251049	DPW Maintained 3	Callistemon citrinus :: Lemon Bottlebrush 28	5700x Geary Blvd	11	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		5989182.8738	2112626.0902	37.7802444522785	-122.481053773582	(37.7802444522785, -122.481053773582)
42114	42114	212121	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2101x Monterey Blvd	3	Median : Yard 3	Tree 1	DPW 2			44	Width 10ft		5991706.53339	2095446.31972	37.7332196973367	-122.47107142020398	(37.7332196973367, -122.471071420204)
44686	44686	251075	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5100x Geary Blvd	3	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5990994.9145	2112700.954	37.7805551774565	-122.47479062026899	(37.7805551774565, -122.474790620269)
44761	44761	251081	DPW Maintained 3	Pittosporum crassifolium :: Karo Tree 108	5600x Geary Blvd	3	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		5989538.2764	2112645.9841	37.7803197290205	-122.479825742455	(37.7803197290205, -122.479825742455)
44978	44978	211007	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	600x Bosworth St	8	Median : Yard 3	Tree 1	DPW 2			26	Width 10ft		6002197.80666	2095393.39137	37.7336755906519	-122.43479650017001	(37.7336755906519, -122.43479650017)
45105	45105	195677	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	6	Median : Yard 3	Tree 1	DPW 2			10	Width 10ft		6015444.73624	2111808.1158	37.779490116104	-122.39014395459	(37.779490116104, -122.39014395459)
45519	45519	222813	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3400x Cesar Chavez St	15	Median : Yard 3	Tree 1	DPW 2			6	Width 10ft		6006748.5872	2100559.98827	37.748119230616105	-122.419429496578	(37.7481192306161, -122.419429496578)
45535	45535	211042	DPW Maintained 3	Pinus halepensis :: Allepo Pine 164	1050x Moraga St	2	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		5990982.70719	2103833.6403200002	37.756207220509204	-122.47418564296001	(37.7562072205092, -122.47418564296)
46588	46588	220698	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3200x Cesar Chavez St	2	Median : Yard 3	Tree 1	DPW 2			13	Width 10ft		6008249.71012	2100572.75018	37.7482387064504	-122.41423955223999	(37.7482387064504, -122.41423955224)
47168	47168	251029	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	5000x Geary Blvd	7	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		5991370.3842	2112709.3567	37.7805999993895	-122.473492318223	(37.7805999993895, -122.473492318223)
47288	47288	222807	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3400x Cesar Chavez St	6	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		6006935.06482	2100562.99304	37.7481379823795	-122.41878487513901	(37.7481379823795, -122.418784875139)
47529	47529	132102	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			17	Width 10ft		6012409.883230001	2120572.1173400003	37.8033851982182	-122.401258897879	(37.8033851982182, -122.401258897879)
47826	47826	251024	DPW Maintained 3	Metrosideros excelsa :: New Zealand Xmas Tree 2	5000x Geary Blvd	3	Median : Yard 3	Tree 1	DPW 2			11	Width 10ft		5991467.9002	2112710.9046	37.7806098961229	-122.473155080103	(37.7806098961229, -122.473155080103)
48115	48115	132100	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	15	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		6012551.63717	2120363.68822	37.802820809805496	-122.400753698321	(37.8028208098055, -122.400753698321)
48340	48340	222814	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	4	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		6006266.09505	2100563.37105	37.748101331408	-122.42109818053801	(37.748101331408, -122.421098180538)
48674	48674	222834	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3250x Cesar Chavez St	6	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6007896.6136300005	2100571.958	37.7482166910443	-122.415460497013	(37.7482166910443, -122.415460497013)
49237	49237	195730	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	14	Median : Yard 3	Tree 1	DPW 2			8	Width 10ft		6014584.98378	2110993.5551299998	37.777205793145704	-122.393061217713	(37.7772057931457, -122.393061217713)
49479	49479	132094	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		6012848.0944	2119927.2949200002	37.8016391096046	-122.39969713882601	(37.8016391096046, -122.399697138826)
49560	49560	220715	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3050x Cesar Chavez St	1	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		6009276.8217	2100578.88918	37.748313203588	-122.410688249989	(37.748313203588, -122.410688249989)
50014	50014	132109	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	7	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6011459.50109	2121569.1071	37.8060696196846	-122.40461797546301	(37.8060696196846, -122.404617975463)
50345	50345	222833	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3250x Cesar Chavez St	5	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6007916.1727	2100571.5576299997	37.74821669106021	-122.41539283380502	(37.7482166910602, -122.415392833805)
51383	51383	220726	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3100x Cesar Chavez St	12	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6008719.674819999	2100576.13539	37.7482743888655	-122.41261466163601	(37.7482743888655, -122.412614661636)
52352	52352	221312	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3500x Cesar Chavez St	2	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6006319.7284699995	2100564.13231	37.748106444967206	-122.420912771811	(37.7481064449672, -122.420912771811)
53230	53230	248775	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	10x Lyell St	2	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6002997.286669999	2095073.79392	37.732843406592295	-122.432009651347	(37.7328434065923, -122.432009651347)
53646	53646	221315	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3500x Cesar Chavez St	8	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6006188.08632	2100559.69525	37.7480868406308	-122.42136767137501	(37.7480868406308, -122.421367671375)
54529	54529	220722	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3100x Cesar Chavez St	2	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6008961.02829	2100577.3162	37.7482911738142	-122.411780148348	(37.7482911738142, -122.411780148348)
55805	55805	221306	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3400x Cesar Chavez St	11	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		6006829.97888	2100561.42314	37.7481277543884	-122.419148148164	(37.7481277543884, -122.419148148164)
55886	55886	220703	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3250x Cesar Chavez St	1	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6007996.96806	2100573.00592	37.7482252085331	-122.415113547572	(37.7482252085331, -122.415113547572)
56033	56033	222845	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3100x Cesar Chavez St	15	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		6008656.93174	2100575.27687	37.7482685099843	-122.41283156553699	(37.7482685099843, -122.412831565537)
56102	56102	220729	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3100x Cesar Chavez St	18	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6008603.15351	2100574.46613	37.748263265148104	-122.413017472476	(37.7482632651481, -122.413017472476)
56412	56412	195676	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	5	Median : Yard 3	Tree 1	DPW 2			7	Width 10ft		6015463.68033	2111825.11578	37.7795378449375	-122.39007960629401	(37.7795378449375, -122.390079606294)
56654	56654	132101	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	17	Median : Yard 3	Tree 1	DPW 2			18	Width 10ft		6012520.61539	2120407.16114	37.802938445615	-122.40086410632	(37.802938445615, -122.40086410632)
57455	57455	240287	DPW Maintained 3	Quercus agrifolia :: Coast Live Oak 180	4300x 21st St	1	Median : Yard 3	Tree 1	DPW 2			10	Width 10ft		6000783.43844	2103265.5060900003	37.755210146643	-122.440250712118	(37.755210146643, -122.440250712118)
59293	59293	209131	DPW Maintained 3	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	900x Bosworth St	17	Median : Yard 3	Tree 1	DPW 2			28	Width 10ft		6001087.056530001	2095697.8346	37.734448396084396	-122.43865848761699	(37.7344483960844, -122.438658487617)
59618	59618	132097	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	10	Median : Yard 3	Tree 1	DPW 2			22	Width 10ft		6012695.81427	2120154.0888900002	37.8022533411719	-122.400240038841	(37.8022533411719, -122.400240038841)
59692	59692	234516	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	90x Peralta Ave	2	Median : Yard 3	Tree 1	DPW 2			15	Width 10ft		6010366.95066	2100295.32111	37.7475956480377	-122.406898611185	(37.7475956480377, -122.406898611185)
60953	60953	251054	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	6000x Geary Blvd	5	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5988209.3153	2112595.4218	37.7801036030677	-122.48441946896601	(37.7801036030677, -122.484419468966)
60997	60997	221307	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3400x Cesar Chavez St	12	Median : Yard 3	Tree 1	DPW 2			13	Width 10ft		6006805.947430001	2100560.05338	37.748122639966795	-122.41923115111099	(37.7481226399668, -122.419231151111)
61445	61445	222840	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3100x Cesar Chavez St	7	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6008831.315769999	2100575.76415	37.7482796345996	-122.412228582693	(37.7482796345996, -122.412228582693)
61518	61518	220721	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3100x Cesar Chavez St	1	Median : Yard 3	Tree 1	DPW 2			13	Width 10ft		6008980.2117099995	2100577.3064900003	37.748292223309704	-122.41171381166401	(37.7482922233097, -122.411713811664)
61544	61544	132098	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	12	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6012646.4501	2120224.08688	37.802442786052396	-122.40041578348699	(37.8024427860524, -122.400415783487)
61802	61802	222823	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	16	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6006010.36461	2100542.85713	37.7480305853438	-122.42198103152	(37.7480305853438, -122.42198103152)
62222	62222	132090	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	8	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6011358.77785	2121601.92287	37.8061540939119	-122.40496885853999	(37.8061540939119, -122.40496885854)
62517	62517	221313	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3500x Cesar Chavez St	3	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6006298.52695	2100563.9468900003	37.7481047407526	-122.42098607287599	(37.7481047407526, -122.420986072876)
62624	62624	132132	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	500x The Embarcadero	12	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		6013567.49669	2118786.0724	37.798545661218	-122.39712759317699	(37.798545661218, -122.397127593177)
62655	62655	221308	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3400x Cesar Chavez St	16	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		6006729.87847	2100559.75105	37.7481175255011	-122.41949417401699	(37.7481175255011, -122.419494174017)
62709	62709	132071	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6013261.919290001	2119233.02284	37.7997558644996	-122.39821636821199	(37.7997558644996, -122.398216368212)
63738	63738	248650	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2x Lyell St	4	Median : Yard 3	Tree 1	DPW 2			25	Width 10ft		6002998.47059	2095072.4374099998	37.732839749044	-122.432005461406	(37.732839749044, -122.432005461406)
65215	65215	222839	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3100x Cesar Chavez St	5	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6008877.383769999	2100577.11513	37.7482859289696	-122.412069375694	(37.7482859289696, -122.412069375694)
65398	65398	132082	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6012375.04896	2120549.1986599998	37.803320325622295	-122.40137783233999	(37.8033203256223, -122.40137783234)
66065	66065	132114	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6013298.81612	2119255.09608	37.799818527453105	-122.39809024008001	(37.7998185274531, -122.39809024008)
66276	66276	195735	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	19	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		6014466.4540800005	2110880.54838	37.7768889170254	-122.393463342353	(37.7768889170254, -122.393463342353)
66298	66298	212112	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1802x Monterey Blvd	3	Median : Yard 3	Tree 1	DPW 2			29	Width 10ft		5992444.9445	2095398.86833	37.7331320889801	-122.468515103605	(37.7331320889801, -122.468515103605)
66951	66951	195729	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	13	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6014619.82632	2111026.87564	37.7772992192097	-122.392943017131	(37.7772992192097, -122.392943017131)
67631	67631	251025	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5000x Geary Blvd	4	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		5991443.5764	2112711.3468	37.7806097019127	-122.47323925917101	(37.7806097019127, -122.473239259171)
67786	67786	220709	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3300x Cesar Chavez St	9	Median : Yard 3	Tree 1	DPW 2			13	Width 10ft		6007353.87086	2100568.68035	37.7481771703365	-122.41733705747	(37.7481771703365, -122.41733705747)
68157	68157	231583	DPW Maintained 3	Maytenus boaria :: Mayten 22	431x Precita Ave	4	Median : Yard 3	Tree 1	DPW 2			6	Width 10ft		6009377.24569	2100204.6551900003	37.7472912697843	-122.410314565485	(37.7472912697843, -122.410314565485)
68185	68185	221319	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3500x Cesar Chavez St	19	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		6005944.18408	2100538.31841	37.7480143903463	-122.42220955912599	(37.7480143903463, -122.422209559126)
68230	68230	212110	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1802x Monterey Blvd	1	Median : Yard 3	Tree 1	DPW 2			26	Width 10ft		5992575.24541	2095393.14196	37.733123891637504	-122.468064206012	(37.7331238916375, -122.468064206012)
68393	68393	132116	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1000x The Embarcadero	8	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6013189.6161	2119421.22304	37.800268589579204	-122.39847977871901	(37.8002685895792, -122.398479778719)

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