Street_Tree_List

Data source: data.sfgov.org

431 rows where PlotSize = "Width 5ft" and qSiteInfo = 2 sorted by PlantDate

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate ▼	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
1009	1009	223537	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	1300 Noe St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 5ft		6003218.0959	2100594.3408	37.7480140720016	-122.431640256605	(37.7480140720016, -122.431640256605)
2702	2702	175365	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	18	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 5ft		5993296.25394	2087788.76232	37.712285726578	-122.465019407322	(37.712285726578, -122.465019407322)
2703	2703	175367	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	23	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993394.31846	2087754.15211	37.7121963492565	-122.464677958129	(37.7121963492565, -122.464677958129)
2705	2705	175366	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	22	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		5993316.47827	2087783.2739799998	37.7122718230516	-122.464949108223	(37.7122718230516, -122.464949108223)
2708	2708	175370	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	26	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993448.13741	2087722.6413599998	37.712112930839	-122.464489658971	(37.712112930839, -122.464489658971)
2709	2709	175364	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5993263.021319999	2087797.41727	37.7123075747038	-122.465134896479	(37.7123075747038, -122.465134896479)
2716	2716	175362	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		5993185.52762	2087808.44828	37.7123333942447	-122.46540353654	(37.7123333942447, -122.46540353654)
2720	2720	175369	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	25	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5993431.63462	2087732.39125	37.7121387503812	-122.46454740445101	(37.7121387503812, -122.464547404451)
2721	2721	175371	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	27	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5993471.88559	2087712.01586	37.712085124705204	-122.464406808033	(37.7120851247052, -122.464406808033)
2722	2722	175368	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	24	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993415.10175	2087740.6954	37.7121605985029	-122.464605149022	(37.7121605985029, -122.464605149022)
3382	3382	122965	Undocumented 2	Cordyline australis :: Dracena Palm 141	98 09th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993050.799269999	2114904.9128799997	37.786725565514004	-122.467838745487	(37.786725565514, -122.467838745487)
4769	4769	194422	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	199X Kissling St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			52	Width 5ft		6007901.53326	2109054.5781799997	37.771508291196	-122.41604412194401	(37.771508291196, -122.416044121944)
23444	23444	201445	Undocumented 2	Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8	50 Middle Point Rd	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		6018205.83588	2096062.22823	37.7364079387746	-122.379497902505	(37.7364079387746, -122.379497902505)
23448	23448	121887	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	50 18th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 5ft		5990232.62779	2114784.35142	37.78623140306821	-122.47758002792801	(37.7862314030682, -122.477580027928)
23539	23539	122063	Undocumented 2	Ilex spp :: Holly Species 163	5 17th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 5ft		5990505.08019	2115005.32961	37.786853953760705	-122.476653573827	(37.7868539537607, -122.476653573827)
23738	23738	215457	Undocumented 2	Ulmus americana :: American Elm 119	170 Santa Ana Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5992608.79004	2095578.76173	37.7336354943765	-122.467961730965	(37.7336354943765, -122.467961730965)
24030	24030	136773	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	3700 Clay St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 5ft		5997087.63405	2115382.9814299997	37.7882704886466	-122.453906871501	(37.7882704886466, -122.453906871501)
24903	24903	201466	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	301 Catalina St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017699.909990001	2096021.8364	37.7362691149141	-122.38124431128	(37.7362691149141, -122.38124431128)
24990	24990	130764	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	2672 Vallejo St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 5ft		6000780.4951599995	2117576.2259299997	37.794503603424	-122.441287648428	(37.794503603424, -122.441287648428)
25026	25026	124921	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	125 Maple St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 5ft		5996572.93556	2115696.21149	37.789101010747	-122.455710282907	(37.789101010747, -122.455710282907)
25593	25593	215447	Undocumented 2	Ulmus americana :: American Elm 119	110 Santa Ana Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5992597.98393	2095879.53795	37.7344607266837	-122.468020961215	(37.7344607266837, -122.468020961215)
25618	25618	241059	Undocumented 2	Taxus baccata :: Irish Yew 241	112 Crescent Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		6005916.7260300005	2095826.92897	37.7350764277358	-122.421969873622	(37.7350764277358, -122.421969873622)
25802	25802	187983	Undocumented 2	Alnus cordata :: Italian Alder 294	1740 Bancroft Ave	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 5ft		6013541.30669	2092786.45742	37.7271549806017	-122.395395842461	(37.7271549806017, -122.395395842461)
26150	26150	130766	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	2672 Vallejo St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 5ft		6000749.67266	2117573.07322	37.79449319107189	-122.441394071498	(37.7944931910719, -122.441394071498)
26155	26155	190587	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1245 03rd St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6015583.31199	2109308.81865	37.7726352865222	-122.38948996669701	(37.7726352865222, -122.389489966697)
26364	26364	126688	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2801 Divisadero St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 5ft		6000574.048880001	2117936.56798	37.79548124560729	-122.44202785340201	(37.7954812456073, -122.442027853402)
26566	26566	250534	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	70 25th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 5ft		5988031.60804	2115549.24332	37.7882036078474	-122.485251031835	(37.7882036078474, -122.485251031835)
26694	26694	124453	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	61 Edward St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 5ft		5995857.77274	2111686.71555	37.7780509386546	-122.457894375539	(37.7780509386546, -122.457894375539)
27032	27032	203761	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1701 Portola Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 5ft		5991748.48888	2096138.80576	37.73512351624029	-122.470976798948	(37.7351235162403, -122.470976798948)
27131	27131	215446	Undocumented 2	Ulmus americana :: American Elm 119	110 Santa Ana Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5992597.86385	2095891.15575	37.7344926193226	-122.468022221156	(37.7344926193226, -122.468022221156)
27154	27154	192389	Undocumented 2	Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10	450 Amador St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 5ft		6018217.012999999	2099612.2395900004	37.746156176965606	-122.37970582128901	(37.7461561769656, -122.379705821289)
27238	27238	124451	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	61 Edward St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 5ft		5995921.71899	2111694.81562	37.7780768529354	-122.457673750202	(37.7780768529354, -122.457673750202)
28365	28365	223874	Undocumented 2	Cycas revoluta :: Sago palm 359	2712 Bryant St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 5ft		6009766.52355	2101514.6779099996	37.750910116518	-122.409060886278	(37.750910116518, -122.409060886278)
28433	28433	175352	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		5993139.4707	2087896.7194400001	37.7125731094281	-122.46556913053301	(37.7125731094281, -122.465569130533)
28460	28460	211766	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	98 San Fernando Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 5ft		5992106.77002	2095921.0899200002	37.73454643836789	-122.469722258175	(37.7345464383679, -122.469722258175)
28469	28469	133683	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	3301 Laguna St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 5ft		6003639.65716	2120421.26895	37.8024778119699	-122.431597810397	(37.8024778119699, -122.431597810397)
28498	28498	218176	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1450 Portola Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 5ft		5992814.7731	2097288.8664	37.7383429066102	-122.467373901707	(37.7383429066102, -122.467373901707)
28938	28938	201582	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	601 Donahue St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 5ft		6020666.22255	2092954.7050599998	37.7280106612574	-122.370776399631	(37.7280106612574, -122.370776399631)
29385	29385	241060	Undocumented 2	Taxus baccata :: Irish Yew 241	112 Crescent Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		6005928.78547	2095826.36488	37.735075558995206	-122.421928139697	(37.7350755589952, -122.421928139697)
29496	29496	215453	Undocumented 2	Ulmus americana :: American Elm 119	130 Santa Ana Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		5992604.15491	2095739.66057	37.734077014732705	-122.46798945526501	(37.7340770147327, -122.467989455265)
29517	29517	135087	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1401 The Embarcadero	45	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 5ft		6010278.59779	2122338.55223	37.8081162545339	-122.408759020708	(37.8081162545339, -122.408759020708)
29917	29917	211768	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	120 San Fernando Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 5ft		5992110.677069999	2095846.95978	37.7343431214426	-122.469703355335	(37.7343431214426, -122.469703355335)
30168	30168	122242	Undocumented 2	Quercus agrifolia :: Coast Live Oak 180	1628 Lake St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		5990370.4799	2114772.2223799997	37.7862060986385	-122.477102214032	(37.7862060986385, -122.477102214032)
30613	30613	175346	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993589.7174	2087738.26685	37.712163995237105	-122.464001454798	(37.7121639952371, -122.464001454798)
31296	31296	221186	Undocumented 2	Azara microphylla :: Little-Leaf Azara 295	2 Bird St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 5ft		6005971.92074	2105741.10447	37.7623015995533	-122.422483282201	(37.7623015995533, -122.422483282201)
31358	31358	191605	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	2400 Mendell St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		6013387.2032	2093129.03799	37.7280870649434	-122.39595257676399	(37.7280870649434, -122.395952576764)
31470	31470	236880	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	30 Ashbury Ter	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5999599.46075	2106928.4775400003	37.7652002791041	-122.44460850030701	(37.7652002791041, -122.444608500307)
31655	31655	124443	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 Edward St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 5ft		5996014.365230001	2111743.99955	37.778217220689	-122.457356814692	(37.778217220689, -122.457356814692)
31717	31717	135070	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1401 The Embarcadero	28	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 5ft		6010442.39712	2122245.83866	37.8078708592274	-122.4081856049	(37.8078708592274, -122.4081856049)
31719	31719	218144	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	74 Ridge Ln	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5997132.65616	2090034.31598	37.7186719635242	-122.451921626186	(37.7186719635242, -122.451921626186)
31752	31752	250543	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	98 25th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 5ft		5988034.75992	2115431.27896	37.78787989509	-122.485231467955	(37.78787989509, -122.485231467955)
32044	32044	218190	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1401 Portola Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 5ft		5993083.56044	2097460.2146099997	37.738828899343204	-122.466457024875	(37.7388288993432, -122.466457024875)
32205	32205	201465	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	221 Catalina St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		6017857.702409999	2096046.34832	37.736345129211294	-122.380700455256	(37.7363451292113, -122.380700455256)
32864	32864	218189	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1421 Portola Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 5ft		5993057.32079	2097427.16876	37.7387366495817	-122.46654534729299	(37.7387366495817, -122.466545347293)
32907	32907	126694	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2801 Divisadero St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 5ft		6000564.04952	2118006.17276	37.7956717921666	-122.44206745147	(37.7956717921666, -122.44206745147)
33022	33022	187984	Undocumented 2	Alnus cordata :: Italian Alder 294	1740 Bancroft Ave	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 5ft		6013523.184119999	2092800.1784400002	37.7271916477681	-122.395459453304	(37.7271916477681, -122.395459453304)
33352	33352	203352	Undocumented 2	Acer palmatum :: Japanese Maple 175	50 San Rafael Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5991879.77556	2095665.97475	37.733832833509396	-122.470488472467	(37.7338328335094, -122.470488472467)
33512	33512	228422	Undocumented 2	Heteromeles arbutifolia :: Toyon 322	840 27th St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 5ft		6001124.36874	2099998.4940400003	37.746259119672	-122.438837573191	(37.746259119672, -122.438837573191)
33548	33548	215452	Undocumented 2	Ulmus americana :: American Elm 119	130 Santa Ana Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5992604.2406	2095761.0748	37.7341358178054	-122.467990716115	(37.7341358178054, -122.467990716115)
33678	33678	135076	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1401 The Embarcadero	34	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 5ft		6010384.52328	2122278.10501	37.807956213866	-122.408388169972	(37.807956213866, -122.408388169972)
33718	33718	205774	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	367 Kensington Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 5ft		5994104.037819999	2099097.57437	37.743383512235496	-122.46304748455401	(37.7433835122355, -122.463047484554)
33854	33854	124441	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 Edward St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 5ft		5996092.3035699995	2111750.82416	37.7782404354383	-122.45708769291402	(37.7782404354383, -122.457087692914)
34056	34056	124444	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 Edward St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 5ft		5995959.12368	2111736.70034	37.778194005969	-122.45754738597401	(37.778194005969, -122.457547385974)
34335	34335	201443	Undocumented 2	Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8	50 Middle Point Rd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6018205.670580001	2096108.31022	37.736534461697104	-122.379501674263	(37.7365344616971, -122.379501674263)
34960	34960	135084	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1401 The Embarcadero	42	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 5ft		6010314.2182599995	2122318.99449	37.8080645489009	-122.40863436569201	(37.8080645489009, -122.408634365692)
35188	35188	191596	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	450 Amador St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		6018234.420580001	2099614.56318	37.74616351723	-122.379645788832	(37.74616351723, -122.379645788832)
35570	35570	240617	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	685 Sanchez St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 5ft		6003712.72581	2104261.51662	37.7581112975082	-122.43019142809099	(37.7581112975082, -122.430191428091)
35635	35635	218057	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	30 San Rafael Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5991870.78261	2095844.7512599998	37.73432318885929	-122.47053257972401	(37.7343231888593, -122.470532579724)
35642	35642	175347	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993550.997219999	2087766.5420799998	37.712239400706395	-122.464137333384	(37.7122394007064, -122.464137333384)
35773	35773	121884	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	50 18th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5990230.5783400005	2114834.8193200002	37.78636985483121	-122.477590808601	(37.7863698548312, -122.477590808601)
35979	35979	215448	Undocumented 2	Ulmus americana :: American Elm 119	110 Santa Ana Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		5992599.75801	2095859.8997900002	37.7344069076591	-122.46801339970501	(37.7344069076591, -122.468013399705)
36013	36013	201469	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	300 Catalina St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017698.8541	2095974.10398	37.7361379928748	-122.381244644042	(37.7361379928748, -122.381244644042)
37132	37132	211777	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	180 San Fernando Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 5ft		5992120.545080001	2095553.8250099998	37.7335388172519	-122.46964790585	(37.7335388172519, -122.46964790585)
37319	37319	124448	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 Edward St	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 5ft		5995755.70235	2111706.15448	37.778098448140895	-122.458248878605	(37.7780984481409, -122.458248878605)
37410	37410	211776	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	170 San Fernando Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 5ft		5992119.752169999	2095585.4214	37.73362552719011	-122.46965294655001	(37.7336255271901, -122.46965294655)
37621	37621	250510	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	75 27th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 5ft		5987308.66603	2115522.71145	37.788088617839705	-122.487750306256	(37.7880886178397, -122.487750306256)
37918	37918	126693	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2801 Divisadero St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 5ft		6000564.95745	2118000.54097	37.7956563804956	-122.44206390543002	(37.7956563804956, -122.44206390543)
38144	38144	201442	Undocumented 2	Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8	50 Middle Point Rd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6018207.71631	2096124.7676	37.736579763236705	-122.37949574413601	(37.7365797632367, -122.379495744136)
38268	38268	222737	Undocumented 2	Ceanothus Sps :: California lilac 270	840 27th St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 5ft		6001059.80246	2099994.7201799997	37.7462450839594	-122.439060564612	(37.7462450839594, -122.439060564612)
38616	38616	215454	Undocumented 2	Ulmus americana :: American Elm 119	160 Santa Ana Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		5992606.05096	2095656.4975700001	37.733848779404795	-122.46797685305401	(37.7338487794048, -122.467976853054)
38633	38633	250514	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	40 27th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 5ft		5987350.46748	2115543.99511	37.788149494743706	-122.487607246587	(37.7881494947437, -122.487607246587)
38754	38754	219028	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1490 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 5ft		5991185.310269999	2105281.9213400004	37.76019555188989	-122.473590620024	(37.7601955518899, -122.473590620024)
38804	38804	218054	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	40 San Rafael Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 5ft		5991875.535130001	2095741.56423	37.7340401380298	-122.470508636163	(37.7340401380298, -122.470508636163)
38879	38879	133686	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	3301 Laguna St	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 5ft		6003672.54238	2120178.33709	37.801812648208	-122.43146665866301	(37.801812648208, -122.431466658663)
39010	39010	188236	Undocumented 2	Archontophoenix cunninghamiana :: King Palm 210	1108 Rhode Island St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		6011896.7371	2103246.34422	37.755783996849	-122.401816071954	(37.755783996849, -122.401816071954)
39016	39016	215462	Undocumented 2	Ulmus americana :: American Elm 119	196 Santa Ana Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5992612.6930599995	2095452.3609	37.733288654633704	-122.467939046451	(37.7332886546337, -122.467939046451)
39232	39232	132164	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	150 Lombard St	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 5ft		6011515.19186	2120799.8495099996	37.8039605395195	-122.404371067467	(37.8039605395195, -122.404371067467)
39667	39667	121886	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	50 18th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 5ft		5990230.2479	2114806.89873	37.786293173551	-122.47758991028499	(37.786293173551, -122.477589910285)
39845	39845	236879	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	30 Ashbury Ter	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5999597.94254	2106903.1548099997	37.7651306625862	-122.44461193121599	(37.7651306625862, -122.444611931216)
40492	40492	215456	Undocumented 2	Ulmus americana :: American Elm 119	170 Santa Ana Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5992607.47204	2095602.74615	37.73370127349371	-122.46796803159599	(37.7337012734937, -122.467968031596)
40630	40630	124449	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 Edward St	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 5ft		5995696.13098	2111699.5362400003	37.7780768529151	-122.45845447691299	(37.7780768529151, -122.458454476913)
40874	40874	118059	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	478 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 5ft		5984726.55462	2112637.2362	37.780014996055	-122.496470823095	(37.780014996055, -122.496470823095)
41197	41197	227088	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Alemany Blvd	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		6009533.30641	2096029.17809	37.7358350661275	-122.409480276115	(37.7358350661275, -122.409480276115)
41465	41465	228421	Undocumented 2	Heteromeles arbutifolia :: Toyon 322	840 27th St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 5ft		6001133.99652	2099998.61422	37.746259997407705	-122.438804290182	(37.7462599974077, -122.438804290182)
42323	42323	126124	Undocumented 2	Cordyline australis :: Dracena Palm 141	1055 Lombard St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		6007293.98833	2120181.06921	37.8020247344007	-122.418934936917	(37.8020247344007, -122.418934936917)
42480	42480	250519	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	66 27th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 5ft		5987405.1087	2115487.58099	37.787997784516	-122.487414054232	(37.787997784516, -122.487414054232)
42557	42557	205256	Undocumented 2	Cordyline australis :: Dracena Palm 141	1490 16th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5991184.504790001	2105292.04801	37.7602233103899	-122.473594144473	(37.7602233103899, -122.473594144473)
43023	43023	133488	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	201 Spruce St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 5ft		5997064.99147	2115637.7546099997	37.7889687294832	-122.454003617874	(37.7889687294832, -122.454003617874)
43130	43130	188825	Undocumented 2	Betula pendula :: European White Birch 146	1888 Illinois St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		6016272.37699	2100354.77616	37.7480875745024	-122.38648195390199	(37.7480875745024, -122.386481953902)
43452	43452	120711	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	80 21st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 5ft		5989302.99834	2114755.68457	37.7860987022701	-122.480794166777	(37.7860987022701, -122.480794166777)

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