Street_Tree_List

Data source: data.sfgov.org

396 rows where PlotSize = "Width 8ft" and qSiteInfo = 2 sorted by qCareAssistant

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, qCaretaker

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant ▼	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
455	455	234501	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	2423 Market St	2	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2			12	Width 8ft		6002117.5892	2105782.84009	37.7621980066439	-122.435816935712	(37.7621980066439, -122.435816935712)
608	608	233928	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	8 Octavia St Frontage East	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			29	Width 8ft		6005775.18179	2109348.30824	37.77219502161479	-122.423420179704	(37.7721950216148, -122.423420179704)
2611	2611	248770	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Cuesta Ct	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 8ft		5999726.1375	2101744.56242	37.7509737525388	-122.44379789365499	(37.7509737525388, -122.443797893655)
2614	2614	248773	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Cuesta Ct	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 8ft		5999776.82694	2101824.96428	37.751197407653706	-122.44362838043999	(37.7511974076537, -122.44362838044)
2625	2625	248771	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Cuesta Ct	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 8ft		5999742.36883	2101773.9828	37.751055459558394	-122.4437438777	(37.7510554595584, -122.4437438777)
2626	2626	248769	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Cuesta Ct	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 8ft		5999705.100819999	2101709.8291	37.7508771833507	-122.443868145114	(37.7508771833507, -122.443868145114)
2629	2629	248772	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Cuesta Ct	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27	Width 8ft		5999759.8487	2101799.49731	37.7511265131926	-122.443685263491	(37.7511265131926, -122.443685263491)
4183	4183	180766	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1206 Naples St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/10/2017 09:29:00 AM	3	Width 8ft		6001093.57723	2087421.33847	37.7117233858917	-122.438043283865	(37.7117233858917, -122.438043283865)
23600	23600	135193	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	35 Bay St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 8ft		6010885.4927900005	2121705.9799599997	37.806413341469	-122.40661408636801	(37.806413341469, -122.406614086368)
23761	23761	123510	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	2714 Fulton St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 8ft		5994935.84099	2110268.0504400004	37.774102650784	-122.460980795496	(37.774102650784, -122.460980795496)
24044	24044	219480	Undocumented 2	Ulmus americana :: American Elm 119	40 Santa Ana Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 8ft		5992573.35664	2096580.23843	37.736383252376704	-122.468157060102	(37.7363832523767, -122.468157060102)
24218	24218	208954	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	600 Saint Francis Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			30	Width 8ft		5993495.97502	2095994.9515900002	37.7348294415148	-122.464924714122	(37.7348294415148, -122.464924714122)
25022	25022	231947	Undocumented 2	Melaleuca ericifolia :: Heath Melaleuca 184	1101 San Jose Ave	64	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 8ft		6005025.65555	2096592.3987	37.73712794050989	-122.42510507394199	(37.7371279405099, -122.425105073942)
25266	25266	215207	Undocumented 2	Syzygium paniculatum :: Brush Cherry 198	160 San Buenaventura Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			30	Width 8ft		5993414.72395	2095618.6966	37.7337916535606	-122.465178304956	(37.7337916535606, -122.465178304956)
25285	25285	123524	Undocumented 2	Ulmus spp :: Elm Spp 215	2828 Fulton St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 8ft		5994582.70338	2110216.80029	37.7739416046925	-122.46219863345199	(37.7739416046925, -122.462198633452)
25481	25481	198281	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		6017868.75025	2099595.89007	37.7460920687928	-122.380908946009	(37.7460920687928, -122.380908946009)
25589	25589	178865	Undocumented 2	Prunus persica :: Peach 330	1260 Naples St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 8ft		6000973.92591	2087218.6697900002	37.711160097322995	-122.438442319358	(37.711160097323, -122.438442319358)
25591	25591	211573	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	38 San Fernando Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 8ft		5992093.28359	2096279.5496599998	37.735529899171794	-122.469794973768	(37.7355298991718, -122.469794973768)
25629	25629	123514	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	2744 Fulton St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 8ft		5994834.09227	2110246.18844	37.7740367681104	-122.461331174398	(37.7740367681104, -122.461331174398)
25890	25890	211894	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	42 San Anselmo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 8ft		5992633.05576	2096891.53005	37.73724142864779	-122.467973292645	(37.7372414286478, -122.467973292645)
26209	26209	212049	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	11 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 8ft		5992308.89069	2096641.7463200002	37.736536860193404	-122.469075896562	(37.7365368601934, -122.469075896562)
26712	26712	219482	Undocumented 2	Ulmus americana :: American Elm 119	50 Santa Ana Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 8ft		5992576.61335	2096511.16113	37.736193771533706	-122.46814077699601	(37.7361937715337, -122.468140776996)
27536	27536	219486	Undocumented 2	Ulmus americana :: American Elm 119	60 Santa Ana Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 8ft		5992579.41042	2096404.2389200001	37.7359003515064	-122.468123331026	(37.7359003515064, -122.468123331026)
27722	27722	207753	Undocumented 2	Eucalyptus camaldulensis :: River Red Gum 340	601 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 8ft		5993435.94824	2096116.49805	37.7351597166396	-122.465141071201	(37.7351597166396, -122.465141071201)
27812	27812	219489	Undocumented 2	Ulmus americana :: American Elm 119	72 Santa Ana Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 8ft		5992583.968309999	2096317.0443099998	37.735661200197605	-122.468101231991	(37.7356612001976, -122.468101231991)
28355	28355	209122	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	90 Terrace Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 8ft		5993231.35441	2096936.94625	37.7374006626082	-122.465908015739	(37.7374006626082, -122.465908015739)
28401	28401	212048	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	11 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 8ft		5992319.55717	2096621.0874299998	37.7364807523878	-122.469037515296	(37.7364807523878, -122.469037515296)
28487	28487	212010	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	302 San Fernando Way	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 8ft		5992076.0582	2094714.7951200001	37.7312324797943	-122.46974064571998	(37.7312324797943, -122.46974064572)
28552	28552	208205	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	50 San Benito Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		5992824.24376	2096416.8452299999	37.7359491019705	-122.467277768674	(37.7359491019705, -122.467277768674)
28602	28602	208207	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	75 San Benito Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 8ft		5992862.536169999	2096286.0615700001	37.7355922132098	-122.46713587181999	(37.7355922132098, -122.46713587182)
28708	28708	212033	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	77 San Leandro Way	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			42	Width 8ft		5992382.09631	2096171.88188	37.7352509600559	-122.468788615307	(37.7352509600559, -122.468788615307)
29003	29003	211592	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	1 San Fernando Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 8ft		5992116.4659	2096423.88969	37.7359275605095	-122.46972532938801	(37.7359275605095, -122.469725329388)
29776	29776	209070	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	10 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 8ft		5992811.17187	2096755.1283099998	37.7368771879369	-122.467347553363	(37.7368771879369, -122.467347553363)
30550	30550	219479	Undocumented 2	Ulmus americana :: American Elm 119	40 Santa Ana Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 8ft		5992572.274130001	2096608.73557	37.7364614358501	-122.468162875133	(37.7364614358501, -122.468162875133)
30557	30557	215212	Undocumented 2	Syzygium paniculatum :: Brush Cherry 198	165 San Buenaventura Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 8ft		5993408.7609	2095708.9649099999	37.7340391640776	-122.465205475246	(37.7340391640776, -122.465205475246)
30590	30590	118002	Undocumented 2	Phoenix canariensis :: Canary Island Date Palm 100	7 Shore View Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 8ft		5984637.38492	2112844.95185	37.780580098776795	-122.49679463074699	(37.7805800987768, -122.496794630747)
30849	30849	198285	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		6017793.32679	2099592.23757	37.7460778765941	-122.381169499371	(37.7460778765941, -122.381169499371)
30873	30873	211922	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	155 San Anselmo Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		5993428.13683	2096525.45183	37.736282151484296	-122.465197772566	(37.7362821514843, -122.465197772566)
30878	30878	211892	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	15 San Anselmo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 8ft		5992677.8722	2096919.75593	37.7373215177838	-122.46782039530399	(37.7373215177838, -122.467820395304)
30913	30913	211344	Undocumented 2	Pittosporum crassifolium :: Karo Tree 108	302 San Fernando Way	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 8ft		5992079.24363	2094788.2155099998	37.731434257968104	-122.46973497639999	(37.7314342579681, -122.4697349764)
31258	31258	118000	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	7 Shore View Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 8ft		5984651.74201	2112846.53753	37.7805852938125	-122.49674508055	(37.7805852938125, -122.49674508055)
31603	31603	211912	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	160 San Anselmo Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		5993474.36419	2096435.15771	37.73603689198271	-122.465031390792	(37.7360368919827, -122.465031390792)
31735	31735	198284	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		6017813.21777	2099593.44192	37.74608228148	-122.381100801954	(37.74608228148, -122.381100801954)
31790	31790	215217	Undocumented 2	Syzygium paniculatum :: Brush Cherry 198	133 San Buenaventura Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 8ft		5993392.21356	2095932.78503	37.7346527642991	-122.465278936386	(37.7346527642991, -122.465278936386)
31846	31846	211571	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	2 San Fernando Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 8ft		5992089.09767	2096348.6420200001	37.73571936744779	-122.46981447465099	(37.7357193674478, -122.469814474651)
32324	32324	199585	Undocumented 2	Yucca gloriosa :: Spanish Dagger 224	875 Vermont St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 8ft		6011335.71651	2104267.18906	37.7585556858141	-122.4038281027	(37.7585556858141, -122.4038281027)
32948	32948	212023	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	60 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 8ft		5992352.18308	2096253.2392099998	37.7354726186689	-122.46889795397699	(37.7354726186689, -122.468897953977)
33840	33840	208206	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	50 San Benito Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		5992824.47991	2096396.07045	37.735892073256394	-122.46727544212	(37.7358920732564, -122.46727544212)
33873	33873	208955	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	630 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35	Width 8ft		5993530.979180001	2095998.56422	37.7348413791301	-122.464803955838	(37.7348413791301, -122.464803955838)
33893	33893	209510	Undocumented 2	Maytenus boaria :: Mayten 22	60 Santa Ana Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 8ft		5992578.93525	2096413.6287900002	37.735926106292204	-122.46812565669701	(37.7359261062922, -122.468125656697)
34858	34858	209121	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	90 Terrace Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 8ft		5993204.42935	2096950.74721	37.7374370033165	-122.466002110005	(37.7374370033165, -122.466002110005)
34872	34872	211905	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 San Anselmo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 8ft		5993202.216519999	2096632.8865099999	37.7365641096345	-122.465986670445	(37.7365641096345, -122.465986670445)
35317	35317	123509	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2636 Fulton St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 8ft		5995163.8038800005	2110297.4884900004	37.77419659482779	-122.46019437077899	(37.7741965948278, -122.460194370779)
35345	35345	212007	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	302 San Fernando Way	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 8ft		5992022.6744800005	2094535.4646599998	37.7307369974034	-122.469912149146	(37.7307369974034, -122.469912149146)
35447	35447	215218	Undocumented 2	Syzygium paniculatum :: Brush Cherry 198	133 San Buenaventura Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 8ft		5993390.45214	2095959.7776	37.734726777609296	-122.465286986206	(37.7347267776093, -122.465286986206)
35875	35875	211898	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	50 San Anselmo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 8ft		5992872.84504	2096808.4352799999	37.7370271156957	-122.46713819838001	(37.7370271156957, -122.46713819838)
36107	36107	215203	Undocumented 2	Syzygium paniculatum :: Brush Cherry 198	120 San Buenaventura Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 8ft		5993362.10241	2095871.1002099998	37.7344816565847	-122.465378560574	(37.7344816565847, -122.465378560574)
36313	36313	219185	Undocumented 2	Ilex altaclarensis 'Wilsonii' :: Wilson Holly Tree 310	2195 12th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 8ft		5992566.72507	2100523.27724	37.747209453947	-122.468466778538	(37.747209453947, -122.468466778538)
36702	36702	212005	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	302 San Fernando Way	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			49	Width 8ft		5991983.8699	2094464.4262700002	37.73053970054001	-122.470041130814	(37.73053970054, -122.470041130814)
36856	36856	219485	Undocumented 2	Ulmus americana :: American Elm 119	60 Santa Ana Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 8ft		5992578.713380001	2096435.07341	37.7359849750264	-122.468127983245	(37.7359849750264, -122.468127983245)
37002	37002	245722	Undocumented 2	Cordyline australis :: Dracena Palm 141	2423 Market St	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 8ft		6002219.32806	2105848.6190400003	37.7623843983365	-122.435469765918	(37.7623843983365, -122.435469765918)
37072	37072	219517	Undocumented 2	Ulmus americana :: American Elm 119	25 Santa Ana Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 8ft		5992610.84668	2096683.2976799998	37.7366683923157	-122.468034936661	(37.7366683923157, -122.468034936661)
37147	37147	219498	Undocumented 2	Ulmus americana :: American Elm 119	89 Santa Ana Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 8ft		5992626.79103	2096177.7893599998	37.7352813139843	-122.467943052944	(37.7352813139843, -122.467943052944)
37196	37196	211576	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	66 San Fernando Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 8ft		5992095.52933	2096194.85192	37.7352974702943	-122.46978104506901	(37.7352974702943, -122.469781045069)
37267	37267	212009	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	302 San Fernando Way	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 8ft		5992050.07919	2094590.8204299998	37.730890574625896	-122.469821436321	(37.7308905746259, -122.469821436321)
37378	37378	198292	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		6017651.2465699995	2099584.75723	37.7460494930826	-122.381660279195	(37.7460494930826, -122.381660279195)
38047	38047	211920	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	155 San Anselmo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		5993463.1611	2096494.07268	37.7361980118237	-122.465074401756	(37.7361980118237, -122.465074401756)
38156	38156	225119	Undocumented 2	Cercis canadensis :: Eastern Redbud 299	2423 Market St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 8ft		6002125.89977	2105776.44015	37.7621809060385	-122.435787734729	(37.7621809060385, -122.435787734729)
38197	38197	218300	Undocumented 2	Brugmansia spp :: Angel trumpet 137	1 Ardenwood Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 8ft		5991308.149669999	2096394.11086	37.7357990419939	-122.472517802556	(37.7357990419939, -122.472517802556)
38211	38211	118052	Undocumented 2	Pinus radiata :: Monterey Pine 3	451 36th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			37	Width 8ft		5984675.38114	2112718.18403	37.7802342573005	-122.496653827903	(37.7802342573005, -122.496653827903)
38795	38795	198287	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		6017753.37339	2099590.18904	37.7460700461913	-122.38130751204399	(37.7460700461913, -122.381307512044)
38995	38995	177874	Undocumented 2	Olea europaea :: Olive Tree 41	1222 Naples St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 8ft		6001049.49395	2087346.60283	37.711515671269495	-122.43819029695801	(37.7115156712695, -122.438190296958)
39021	39021	211904	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	80 San Anselmo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 8ft		5993117.507999999	2096685.0409	37.7367024253714	-122.466283330728	(37.7367024253714, -122.466283330728)
39555	39555	212032	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	77 San Leandro Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 8ft		5992384.20886	2096144.3676099998	37.7351755348194	-122.46877931001998	(37.7351755348194, -122.46877931002)
40205	40205	219512	Undocumented 2	Ulmus americana :: American Elm 119	41 Santa Ana Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 8ft		5992615.5560800005	2096571.3112400002	37.736361177626705	-122.46801051107599	(37.7363611776267, -122.468010511076)
40224	40224	215216	Undocumented 2	Syzygium paniculatum :: Brush Cherry 198	133 San Buenaventura Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 8ft		5993391.28977	2095902.6603400002	37.7345699961108	-122.465279942742	(37.7345699961108, -122.465279942742)
40227	40227	203406	Undocumented 2	Acer rubrum :: Red Maple 6	155 Yerba Buena Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		5994466.0383	2096440.3744299999	37.736108347605295	-122.461603176966	(37.7361083476053, -122.461603176966)
40563	40563	211587	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	55 San Fernando Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 8ft		5992126.7727	2096262.7972400002	37.7354858369058	-122.46967797107	(37.7354858369058, -122.46967797107)
41734	41734	211902	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	60 San Anselmo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 8ft		5993032.3976	2096733.05843	37.7368293583846	-122.466581080979	(37.7368293583846, -122.466581080979)
41894	41894	177321	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	1222 Naples St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 8ft		6001045.82775	2087348.99146	37.71152202140421	-122.438203139287	(37.7115220214042, -122.438203139287)
41907	41907	211927	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	145 San Anselmo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		5993219.3101	2096667.4089099998	37.736659885632704	-122.46593007882299	(37.7366598856327, -122.465930078823)
42112	42112	211890	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	33 San Anselmo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 8ft		5992746.48615	2096899.9823599998	37.737271186301705	-122.467581729613	(37.7372711863017, -122.467581729613)
42507	42507	118050	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	451 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		5984672.88957	2112829.17852	37.7805388700497	-122.496670640749	(37.7805388700497, -122.496670640749)
42580	42580	211899	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	50 San Anselmo Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 8ft		5992903.15569	2096794.06334	37.7369894035426	-122.46703235718	(37.7369894035426, -122.46703235718)
42634	42634	219504	Undocumented 2	Ulmus americana :: American Elm 119	65 Santa Ana Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 8ft		5992624.10653	2096354.05467	37.735765139345105	-122.467965151081	(37.7357651393451, -122.467965151081)
42666	42666	251004	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	322 Point Lobos Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		5981865.04882	2112690.30879	37.7799926644722	-122.50637382330099	(37.7799926644722, -122.506373823301)
43012	43012	212034	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	75 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			29	Width 8ft		5992381.096530001	2096188.3178599998	37.7352960313735	-122.468793267506	(37.7352960313735, -122.468793267506)
43043	43043	220526	Undocumented 2	Acer x freemanii :: Freeman Maple 265	2901 Bryant St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		6009878.66886	2100514.9159	37.7481712725817	-122.40860255668899	(37.7481712725817, -122.408602556689)
43190	43190	122146	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	31 15th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 8ft		5991133.9927199995	2114818.51521	37.7863774717716	-122.47446406594999	(37.7863774717716, -122.47446406595)
43213	43213	211575	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	66 San Fernando Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 8ft		5992095.0135699995	2096227.76015	37.735387798203895	-122.46978522331999	(37.7353877982039, -122.46978522332)
43276	43276	211584	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	75 San Fernando Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 8ft		5992129.81291	2096158.4246	37.735199431602794	-122.46965986413	(37.7351994316028, -122.46965986413)
43749	43749	211923	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	135 San Anselmo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		5993369.75745	2096567.1017	37.736393144928	-122.465402637242	(37.736393144928, -122.465402637242)
43894	43894	219521	Undocumented 2	Ulmus americana :: American Elm 119	15 Santa Ana Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 8ft		5992605.36477	2096774.53089	37.7369185792154	-122.468060524183	(37.7369185792154, -122.468060524183)
44074	44074	212044	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	29 San Leandro Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 8ft		5992357.053169999	2096532.5298400002	37.7362397619376	-122.468901434378	(37.7362397619376, -122.468901434378)
44348	44348	211346	Undocumented 2	Pittosporum crassifolium :: Karo Tree 108	302 San Fernando Way	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 8ft		5992080.364130001	2094802.48118	37.7314734926994	-122.46973214084299	(37.7314734926994, -122.469732140843)
44494	44494	219471	Undocumented 2	Ulmus americana :: American Elm 119	2 Santa Ana Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 8ft		5992545.99069	2096862.54215	37.7371568069404	-122.46827220569901	(37.7371568069404, -122.468272205699)
44790	44790	244846	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	90 Bartlett St	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 8ft		6006641.954969999	2103569.5656	37.75637683445171	-122.42001177073901	(37.7563768344517, -122.420011770739)
44937	44937	222679	Undocumented 2	Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58	749 Dolores St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 8ft		6005046.9751	2104064.76222	37.7576465368663	-122.425563014118	(37.7576465368663, -122.425563014118)
45120	45120	233411	Undocumented 2	Pistacia chinensis :: Chinese Pistache 150	2709 Harrison St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		6008945.30625	2102700.68655	37.754120591896	-122.411984548072	(37.754120591896, -122.411984548072)
45207	45207	178692	Undocumented 2	Prunus armeniaca :: Apricot 259	549 Cordova St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 8ft		6002131.76754	2086425.47642	37.7090479540599	-122.43438386511801	(37.7090479540599, -122.434383865118)

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