Street_Tree_List

Data source: data.sfgov.org

1,688 rows where PlotSize = "Width 4ft" and qSiteInfo = 2 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, PlantDate

Link	rowid ▲	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
189097	189097	205746	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	33 Sotelo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5993900.499	2101145.1165299998	37.748993818619795	-122.46389985751999	(37.7489938186198, -122.46389985752)
189062	189062	250894	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	250 29th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5986839.6011	2114252.83409	37.784574529539796	-122.489279763454	(37.7845745295398, -122.489279763454)
189055	189055	250836	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	283 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 4ft		5986490.348619999	2114051.42085	37.7840011137113	-122.49047321958	(37.7840011137113, -122.49047321958)
189030	189030	128980	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	199 McAllister St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		6008492.62721	2112417.9062099997	37.7807764092316	-122.414237490093	(37.7807764092316, -122.414237490093)
189012	189012	126364	Undocumented 2	Cotoneaster SPP :: Cotoneaster 234	1100 Filbert St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 4ft		6007584.0296	2119571.97409	37.8003686400458	-122.41788805230699	(37.8003686400458, -122.417888052307)
188974	188974	250864	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	170 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5986515.92946	2114612.51535	37.7855432117965	-122.49042601236	(37.7855432117965, -122.49042601236)
188930	188930	250562	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	445 El Camino Del Mar	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5987191.81534	2115294.08526	37.7874540598079	-122.488137777348	(37.7874540598079, -122.488137777348)
188929	188929	203816	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1625 Monterey Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 4ft		5993083.51125	2095334.29452	37.7329916508262	-122.466302734486	(37.7329916508262, -122.466302734486)
188900	188900	250817	Undocumented 2	Maytenus boaria :: Mayten 22	45 Sea View Ter	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5986236.9897	2114116.07021	37.7841638208535	-122.491354496716	(37.7841638208535, -122.491354496716)
188770	188770	215509	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	265 Santa Paula Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5994040.687530001	2096338.7929099998	37.7358049370452	-122.46306640808201	(37.7358049370452, -122.463066408082)
188742	188742	246420	Undocumented 2	Ceratonia siliqua :: Carob 97	400 Duncan St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		6003851.19686	2099854.61267	37.7460188154337	-122.42939827552401	(37.7460188154337, -122.429398275524)
188721	188721	119033	Undocumented 2	Prunus blireiana :: Flowering Plum 102	745 44th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5982267.74264	2110681.1609400003	37.7744998336605	-122.50483182972499	(37.7744998336605, -122.504831829725)
188649	188649	123336	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	723 04th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5994711.02171	2110605.04952	37.7750150216931	-122.461782919201	(37.7750150216931, -122.461782919201)
188619	188619	211936	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	55 Marcela Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 4ft		5994719.6585800005	2100681.91633	37.7477691605281	-122.461033650677	(37.7477691605281, -122.461033650677)
188544	188544	212503	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	65 Sotelo Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5993861.6339300005	2101357.5005200002	37.7495747312094	-122.464049667463	(37.7495747312094, -122.464049667463)
188474	188474	218968	Undocumented 2	Fraxinus spp :: Ash Spp 83	150 Alton Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 4ft		5993617.45125	2101661.58733	37.7503955999976	-122.464916133678	(37.7503955999976, -122.464916133678)
188436	188436	207812	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	635 Hearst Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 4ft		5997216.39115	2094387.61086	37.7306298809467	-122.451946087746	(37.7306298809467, -122.451946087746)
188169	188169	202581	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	625 King St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 4ft		6012003.845430001	2108517.57719	37.7702636034108	-122.40181616639099	(37.7702636034108, -122.401816166391)
188120	188120	205124	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1253 Portola Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 4ft		5994307.62301	2097874.46117	37.740036874108704	-122.462254855373	(37.7400368741087, -122.462254855373)
188118	188118	212997	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1627 08th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5993679.49927	2104412.68352	37.757952979968294	-122.464901340744	(37.7579529799683, -122.464901340744)
187900	187900	250616	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	107 28th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5987080.55182	2115289.10715	37.7874338997015	-122.488522355317	(37.7874338997015, -122.488522355317)
187775	187775	250901	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	262 29th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5986843.4258	2114179.11857	37.784372351133	-122.489261109739	(37.784372351133, -122.489261109739)
187736	187736	206608	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	2 Sola Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5994960.813709999	2100721.5804	37.7478919422595	-122.460202627649	(37.7478919422595, -122.460202627649)
187682	187682	218906	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	160 Dorantes Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5993761.1168599995	2099844.95033	37.7454158586537	-122.46428745721	(37.7454158586537, -122.46428745721)
187678	187678	130799	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	2624 Steiner St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		6002200.357969999	2117124.26521	37.7933434159171	-122.43634239249599	(37.7933434159171, -122.436342392496)
187571	187571	250436	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	98 Seacliff Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 4ft		5987616.8568	2115817.96032	37.7889172576592	-122.486705722111	(37.7889172576592, -122.486705722111)
187402	187402	179964	Undocumented 2	Trachycarpus fortunei :: Windmill Palm 31	85 South Hill Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		6002952.82685	2087126.8782400002	37.7110204227269	-122.431596206017	(37.7110204227269, -122.431596206017)
187316	187316	133599	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	3203 Pacific Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 4ft		5998812.20611	2116559.67627	37.7916001088964	-122.448024918608	(37.7916001088964, -122.448024918608)
187309	187309	214781	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	1723 Monterey Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5992834.3473	2095346.2214400002	37.733010019498	-122.467165018866	(37.733010019498, -122.467165018866)
187226	187226	250936	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	242 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 4ft		5987145.66978	2114320.34633	37.7847777601171	-122.488225846157	(37.7847777601171, -122.488225846157)
187116	187116	209527	Undocumented 2	Maytenus boaria :: Mayten 22	120 Alton Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5993729.20174	2101663.31311	37.7504067812521	-122.464529820919	(37.7504067812521, -122.464529820919)
187026	187026	250853	Undocumented 2	Maytenus boaria :: Mayten 22	218 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5986526.42947	2114357.74439	37.7848442973805	-122.490370936979	(37.7848442973805, -122.490370936979)
186962	186962	218218	Undocumented 2	Archontophoenix cunninghamiana :: King Palm 210	399 Wawona St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5991827.81177	2097037.5043900001	37.73759570307	-122.47076799437201	(37.73759570307, -122.470767994372)
186859	186859	123006	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	14 06th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5993959.7605	2115469.14519	37.7883272380259	-122.464734969158	(37.7883272380259, -122.464734969158)
186717	186717	250963	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	6538 California St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 4ft		5986577.80338	2113949.50565	37.7837263914907	-122.490163163006	(37.7837263914907, -122.490163163006)
186426	186426	214765	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	98 Sotelo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5993613.7342	2101408.96874	37.7497017595309	-122.464910643325	(37.7497017595309, -122.464910643325)
186393	186393	233550	Undocumented 2	Pittosporum crassifolium :: Karo Tree 108	4181 23rd St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 4ft		6001978.75219	2102336.68489	37.7527278082485	-122.436050510349	(37.7527278082485, -122.436050510349)
186356	186356	214959	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	96 San Andreas Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5993574.3517	2095241.11953	37.7327641241706	-122.46459902103099	(37.7327641241706, -122.464599021031)
186261	186261	214951	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	60 San Andreas Way	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5993735.153080001	2095430.2439299999	37.7332926818073	-122.464056818891	(37.7332926818073, -122.464056818891)
186207	186207	117729	Undocumented 2	Magnolia doltsopa :: Himalayan Magnolia 187	444 40th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5983475.649730001	2112834.36493	37.7804828918797	-122.500812777933	(37.7804828918797, -122.500812777933)
186140	186140	212998	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1627 08th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5993678.65574	2104395.17492	37.7579048572517	-122.464902986481	(37.7579048572517, -122.464902986481)
186082	186082	250468	Undocumented 2	Olea europaea :: Olive Tree 41	330 Seacliff Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5986773.71453	2115563.2588299997	37.7881687321606	-122.489604103052	(37.7881687321606, -122.489604103052)
186040	186040	250888	Undocumented 2	Olea europaea :: Olive Tree 41	188 29th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5986832.35186	2114485.1833200003	37.7852120706333	-122.489321932679	(37.7852120706333, -122.489321932679)
186013	186013	232596	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	62 Worth St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		6000863.33158	2102998.0614099996	37.75448035670671	-122.43995524344601	(37.7544803567067, -122.439955243446)
185943	185943	250832	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	291 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5986494.4269	2113986.56401	37.783823273672795	-122.490454337414	(37.7838232736728, -122.490454337414)
185920	185920	204625	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	1901 Monterey Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		5992281.41366	2095382.3817200002	37.733077373320896	-122.469079268988	(37.7330773733209, -122.469079268988)
185916	185916	132306	Undocumented 2	Pittosporum crassifolium :: Karo Tree 108	1100 Filbert St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		6007602.49027	2119574.77475	37.800377368866	-122.41782436951799	(37.800377368866, -122.417824369518)
185841	185841	120256	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	140 24th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5988368.86327	2114963.36268	37.7866145875471	-122.48404121988199	(37.7866145875471, -122.484041219882)
185831	185831	211933	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	225 Pacheco St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 4ft		5994452.61696	2100333.21821	37.746796353079205	-122.461931778432	(37.7467963530792, -122.461931778432)
185782	185782	215556	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	230 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5994083.61734	2096486.4471099998	37.736212831753896	-122.46292869311701	(37.7362128317539, -122.462928693117)
185777	185777	202589	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	625 King St	16	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 4ft		6012146.02673	2108653.71558	37.7706453422429	-122.401333927439	(37.7706453422429, -122.401333927439)
185738	185738	209528	Undocumented 2	Maytenus boaria :: Mayten 22	120 Alton Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5993704.81449	2101665.02128	37.7504100655711	-122.464614277122	(37.7504100655711, -122.464614277122)
185614	185614	203928	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	700 Quintara St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 4ft		5991222.21621	2101152.9176	37.7488605291971	-122.473161852043	(37.7488605291971, -122.473161852043)
185538	185538	220222	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	62 Carmel St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 4ft		5998653.96279	2105407.43218	37.7609698726686	-122.44776922698999	(37.7609698726686, -122.44776922699)
185484	185484	250678	Undocumented 2	Olea europaea :: Olive Tree 41	738 El Camino Del Mar	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5986293.8358	2114857.16147	37.7862019651938	-122.49121239213301	(37.7862019651938, -122.491212392133)
185424	185424	206738	Undocumented 2	Crataegus phaenopyrum :: Washington Hawthorn 135	2110 09th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5993654.98108	2101316.80215	37.7494510717083	-122.46476131898999	(37.7494510717083, -122.46476131899)
185399	185399	124305	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	169 Jordan Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 4ft		5996209.822430001	2113206.80783	37.782244929320605	-122.456786484191	(37.7822449293206, -122.456786484191)
185330	185330	117887	Undocumented 2	Ilex spp :: Holly Species 163	592 43rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 4ft		5982584.758169999	2111760.42718	37.7774818283717	-122.50381517937001	(37.7774818283717, -122.50381517937)
185329	185329	250877	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	111 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 4ft		5986466.719269999	2114758.04628	37.785939923445795	-122.49060697393999	(37.7859399234458, -122.49060697394)
185118	185118	133868	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	3030 Pacific Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 4ft		5999604.86675	2116716.1929099998	37.792075140714395	-122.44529358943501	(37.7920751407144, -122.445293589435)
184899	184899	203425	Undocumented 2	Acer rubrum :: Red Maple 6	135 Yerba Buena Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5994247.20035	2096642.9024	37.7366518402943	-122.46237446791099	(37.7366518402943, -122.462374467911)
184637	184637	250950	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	218 28th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5987144.16793	2114485.2871	37.78523055258079	-122.488243167098	(37.7852305525808, -122.488243167098)
184438	184438	119038	Undocumented 2	Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88	675 44th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5982249.27103	2111200.72651	37.7759253222044	-122.50493423498501	(37.7759253222044, -122.504934234985)
184436	184436	123360	Undocumented 2	Ulmus spp :: Elm Spp 215	752 04th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 4ft		5994762.63942	2110475.46435	37.774662186462706	-122.46159496648599	(37.7746621864627, -122.461594966486)
184225	184225	222889	Undocumented 2	Ceratonia siliqua :: Carob 97	81 Webster St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 4ft		6004268.7476699995	2108942.84192	37.7709965706599	-122.428602156987	(37.7709965706599, -122.428602156987)
184212	184212	214925	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	2145 Monterey Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5991708.45022	2095419.2985200002	37.7331456147813	-122.471062825413	(37.7331456147813, -122.471062825413)
184211	184211	190717	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1150 19th St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		6014133.64605	2105280.55607	37.7614940829991	-122.39422247538401	(37.7614940829991, -122.394222475384)
184185	184185	208780	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	220 Magellan Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 4ft		5994880.183759999	2100533.15531	37.74736993618271	-122.460467789158	(37.7473699361827, -122.460467789158)
183947	183947	208992	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	45 Yerba Buena Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 4ft		5993607.99739	2097104.1803400002	37.7378815660919	-122.46461793558001	(37.7378815660919, -122.46461793558)
183920	183920	233359	Undocumented 2	Pistacia chinensis :: Chinese Pistache 150	93 Webster St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		6004257.74689	2109007.55308	37.7711736292001	-122.428644822623	(37.7711736292001, -122.428644822623)
183798	183798	212504	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	65 Sotelo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5993846.98511	2101368.61986	37.749604417822205	-122.464101130262	(37.7496044178222, -122.464101130262)
183741	183741	212089	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	223 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 4ft		5994065.04722	2096675.37629	37.7367305147902	-122.463006600482	(37.7367305147902, -122.463006600482)
183694	183694	211467	Undocumented 2	Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193	5 Vasquez Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 4ft		5995826.043819999	2100197.09565	37.7465015679068	-122.4571727856	(37.7465015679068, -122.4571727856)
183693	183693	236874	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	65 Ashbury Ter	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5999508.1467	2106735.11432	37.764664141051	-122.44491043149701	(37.764664141051, -122.444910431497)
183677	183677	124311	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	141 Jordan Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 4ft		5996204.238580001	2113428.06992	37.7828521355548	-122.456821809527	(37.7828521355548, -122.456821809527)
183594	183594	133597	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	3203 Pacific Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 4ft		5998776.68009	2116556.20872	37.7915885571123	-122.44814758795	(37.7915885571123, -122.44814758795)
183560	183560	227186	Undocumented 2	Ligustrum lucidum :: Glossy Privet 55	260 Upper Ter	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 4ft		5999465.27543	2106151.00222	37.7630578682481	-122.445016716945	(37.7630578682481, -122.445016716945)
183347	183347	135750	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2552 Baker St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		5999680.47825	2117673.08537	37.794706830417	-122.445100797276	(37.794706830417, -122.445100797276)
183220	183220	250666	Undocumented 2	Cordyline australis :: Dracena Palm 141	632 El Camino Del Mar	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5986516.4549	2114931.9997799997	37.7864204545769	-122.490447706689	(37.7864204545769, -122.490447706689)
183070	183070	239602	Undocumented 2	Schinus molle :: California Pepper 138	890 Castro St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		6002438.31508	2103064.33818	37.754751868324796	-122.434513284763	(37.7547518683248, -122.434513284763)
183065	183065	250367	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	45 Scenic Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 4ft		5987752.35458	2115573.78871	37.788254730725605	-122.486218991924	(37.7882547307256, -122.486218991924)
182959	182959	206392	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	128 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 4ft		5994243.34729	2097107.2475700001	37.7379265951457	-122.46242145931002	(37.7379265951457, -122.46242145931)
182885	182885	213760	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	433 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 4ft		5995458.89239	2098325.6935900003	37.7413420700694	-122.45830691704398	(37.7413420700694, -122.458306917044)
182845	182845	133540	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 Locust St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 4ft		5997505.810409999	2116303.5724	37.790822153068106	-122.452526520096	(37.7908221530681, -122.452526520096)
182751	182751	223539	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1661 Noe St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		6003387.19904	2098534.7214900004	37.742368419572294	-122.43090853672301	(37.7423684195723, -122.430908536723)
182665	182665	250629	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	157 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 4ft		5987108.76332	2114761.35899	37.785986501116	-122.488385950679	(37.785986501116, -122.488385950679)
182662	182662	119005	Undocumented 2	Yucca gloriosa :: Spanish Dagger 224	599 43rd Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5982538.33316	2111759.97199	37.777477848688605	-122.50397574245501	(37.7774778486886, -122.503975742455)
182301	182301	123980	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	37 07th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 4ft		5993612.60829	2115222.17553	37.7876291067421	-122.46591809710199	(37.7876291067421, -122.465918097102)
182252	182252	218085	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	220 Magellan Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5994888.761	2100546.3582599997	37.747406681590704	-122.46043908639	(37.7474066815907, -122.46043908639)
182225	182225	250391	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	34 25th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 4ft		5988198.77165	2115724.55517	37.7886947006424	-122.48468554620001	(37.7886947006424, -122.4846855462)
182128	182128	214933	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	10 San Andreas Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5993794.553230001	2095807.5426900003	37.7343320741677	-122.463878834949	(37.7343320741677, -122.463878834949)
182103	182103	120755	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	25 20th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 4ft		5989558.707669999	2114980.4396	37.7867306756372	-122.479925944143	(37.7867306756372, -122.479925944143)
181983	181983	196358	Undocumented 2	Prunus persica :: Peach 330	1001 25th St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 4ft		6015624.21755	2102039.10579	37.752676489353796	-122.388840855824	(37.7526764893538, -122.388840855824)
181912	181912	220225	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	62 Carmel St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 4ft		5998611.48778	2105405.4167299997	37.7609619109939	-122.44791598376301	(37.7609619109939, -122.447915983763)
181877	181877	209554	Undocumented 2	Maytenus boaria :: Mayten 22	95 Sotelo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5993671.8015	2101379.3212200003	37.74962370288	-122.46470769332701	(37.74962370288, -122.464707693327)
181867	181867	193189	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	401 Harrison St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		6014845.7191	2114331.63578	37.786385886443206	-122.392392780401	(37.7863858864432, -122.392392780401)
181781	181781	198545	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1763 Newcomb Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		6014347.46676	2096307.9182900002	37.736869000500995	-122.392855193808	(37.736869000501, -122.392855193808)
181703	181703	203825	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1485 Portola Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 4ft		5992686.00639	2097037.5899200002	37.737645530001295	-122.46780083956301	(37.7376455300013, -122.467800839563)
181643	181643	124952	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	232 Maple St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 4ft		5996648.67677	2115450.86718	37.7884317073951	-122.455430490336	(37.7884317073951, -122.455430490336)
181604	181604	125231	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	2330 Octavia St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 4ft		6004617.74457	2117190.62158	37.793662671658794	-122.427982792965	(37.7936626716588, -122.427982792965)

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