Street_Tree_List

Data source: data.sfgov.org

245 rows where PlotSize = "Width 2ft" 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: SiteOrder

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant ▼	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
3943	3943	216737	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	11 Lee Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/04/2017 02:31:00 PM	3	Width 2ft		5996481.70655	2089974.5093900003	37.7184704425356	-122.45416736555799	(37.7184704425356, -122.454167365558)
3959	3959	216642	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	50 Lee Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/04/2017 01:57:00 PM	3	Width 2ft		5996528.83108	2090217.4765599999	37.7191402755735	-122.45402201441999	(37.7191402755735, -122.45402201442)
23401	23401	202171	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	20 Kalmanovitz St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 2ft		6013157.586080001	2093193.49557	37.7282512748665	-122.39675089323799	(37.7282512748665, -122.396750893238)
23445	23445	222731	Undocumented 2	Ceanothus Sps :: California lilac 270	1435 Douglass St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 2ft		6001402.34337	2099545.22287	37.7450303552734	-122.437843913168	(37.7450303552734, -122.437843913168)
23492	23492	202174	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	100 Kalmanovitz St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 2ft		6013138.83373	2093054.0318599998	37.7278672922301	-122.39680594795401	(37.7278672922301, -122.396805947954)
24131	24131	230898	Undocumented 2	Maytenus boaria :: Mayten 22	11 Clarendon Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		5998114.42055	2104641.61422	37.758836276097796	-122.44958007486	(37.7588362760978, -122.44958007486)
24251	24251	201271	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	200 Kalmanovitz St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 2ft		6013058.71274	2092794.8909900002	37.7271512843849	-122.39706476744301	(37.7271512843849, -122.397064767443)
24808	24808	210655	Undocumented 2	Olea europaea :: Olive Tree 41	302 Westgate Dr	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 2ft		5993736.1298400005	2094686.96853	37.731251887161605	-122.463999505972	(37.7312518871616, -122.463999505972)
25750	25750	187815	Undocumented 2	Acer buergeranum :: Trident Maple 120	1020 Le Conte Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 2ft		6013104.719330001	2089623.63357	37.7184462121049	-122.39668350344601	(37.7184462121049, -122.396683503446)
25788	25788	240428	Undocumented 2	Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106	530 Hickory St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 2ft		6004264.4579300005	2110312.0386200002	37.7747558078645	-122.42871461628201	(37.7747558078645, -122.428714616282)
26085	26085	121888	Undocumented 2	Podocarpus macrophyllus :: Yew Pine 168	10 17th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 2ft		5990543.39906	2115002.75523	37.786849107740395	-122.476520812684	(37.7868491077404, -122.476520812684)
26486	26486	204793	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1998 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 2ft		5991300.85589	2101853.1475400003	37.7507877313777	-122.47294097314399	(37.7507877313777, -122.472940973144)
26930	26930	136782	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	181 Marina Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 2ft		6002679.8644199995	2121606.5592	37.8056778588023	-122.435003985458	(37.8056778588023, -122.435003985458)
26986	26986	201270	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	200 Kalmanovitz St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		6013065.62044	2092803.8132900002	37.7271761677359	-122.39704151275801	(37.7271761677359, -122.397041512758)
28770	28770	120033	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	854 28th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 2ft		5987298.51459	2110108.4388099997	37.7732219709389	-122.48738756829799	(37.7732219709389, -122.487387568298)
29095	29095	218241	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	329 Wawona St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 2ft		5992046.53731	2097216.7007400002	37.7381003774208	-122.470024807225	(37.7381003774208, -122.470024807225)
29169	29169	202128	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	2799 Newhall St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 2ft		6012573.71911	2093089.235	37.7279324822924	-122.398762044451	(37.7279324822924, -122.398762044451)
29243	29243	201365	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	205 Kalmanovitz St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 2ft		6013111.57283	2092803.6730099998	37.7271783404816	-122.39688264483401	(37.7271783404816, -122.396882644834)
29289	29289	202261	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	8 Orsi Cir	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 2ft		6013121.62646	2093143.4791299999	37.728111938408496	-122.396871702789	(37.7281119384085, -122.396871702789)
29951	29951	201313	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	300 Kalmanovitz St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 2ft		6012967.92533	2092673.3343599997	37.7268124603184	-122.397370099843	(37.7268124603184, -122.397370099843)
30300	30300	219757	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1335 Douglass St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 2ft		6001386.79678	2099806.89214	37.7457479531147	-122.43791640932601	(37.7457479531147, -122.437916409326)
31184	31184	201362	Undocumented 2	Cornus florida :: Eastern Dogwood 374	225 Kalmanovitz St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 2ft		6013043.2726	2092711.57463	37.72692165510811	-122.397112304693	(37.7269216551081, -122.397112304693)
32069	32069	204794	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1998 16th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 2ft		5991301.04243	2101880.01512	37.750861513549104	-122.47294228706998	(37.7508615135491, -122.47294228707)
32529	32529	120326	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	738 23rd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 2ft		5988846.16685	2110288.25768	37.773805837099	-122.48204727167901	(37.773805837099, -122.482047271679)
32969	32969	180153	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	579 Madrid St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 2ft		6002415.21739	2090527.1834900002	37.7203264238119	-122.433697176094	(37.7203264238119, -122.433697176094)
33833	33833	201361	Undocumented 2	Lagerstroemia indica :: Crape Myrtle 199	225 Kalmanovitz St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 2ft		6013041.33854	2092709.54059	37.726915962381	-122.397118848181	(37.726915962381, -122.397118848181)
33835	33835	188022	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1001 17th St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 2ft		6014182.1741	2106635.38485	37.7652168437069	-122.394149489126	(37.7652168437069, -122.394149489126)
34605	34605	212336	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	129 Kirkham St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		5994383.10995	2105287.3927	37.7603952490607	-122.462531423009	(37.7603952490607, -122.462531423009)
34612	34612	210654	Undocumented 2	Olea europaea :: Olive Tree 41	302 Westgate Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 2ft		5993718.29601	2094664.2964	37.7311886072667	-122.46405951503901	(37.7311886072667, -122.464059515039)
35582	35582	202279	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2 Issleib Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 2ft		6012770.2482199995	2093278.97212	37.728464409705204	-122.39809593910101	(37.7284644097052, -122.398095939101)
36441	36441	230896	Undocumented 2	Maytenus boaria :: Mayten 22	11 Clarendon Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		5998100.3683400005	2104640.02402	37.7588311058945	-122.449628559107	(37.7588311058945, -122.449628559107)
36515	36515	120042	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	855 27th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 2ft		5987562.19522	2110171.37929	37.7734101615057	-122.48648009559601	(37.7734101615057, -122.486480095596)
37106	37106	127078	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	235 Marina Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		6002357.66417	2121865.24389	37.8063698385551	-122.43613752782801	(37.8063698385551, -122.436137527828)
37243	37243	202167	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	10 Kalmanovitz St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 2ft		6013164.547619999	2093230.83795	37.7283541968866	-122.396729443526	(37.7283541968866, -122.396729443526)
37940	37940	220243	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1435 Douglass St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 2ft		6001404.3339599995	2099524.15777	37.7449726286816	-122.437835521604	(37.7449726286816, -122.437835521604)
38273	38273	202293	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1 Issleib Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		6012754.8343	2093244.37958	37.7283685671459	-122.39814680025499	(37.7283685671459, -122.398146800255)
39911	39911	180156	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	579 Madrid St	20	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 2ft		6002493.30901	2090649.8353400002	37.7206676292907	-122.433435999497	(37.7206676292907, -122.433435999497)
40412	40412	202290	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	21 Issleib Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 2ft		6012710.5854	2093261.6204900001	37.7284134424104	-122.398300980932	(37.7284134424104, -122.398300980932)
41096	41096	201274	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	210 Kalmanovitz St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 2ft		6013027.04362	2092751.29466	37.7270298147504	-122.39717119231899	(37.7270298147504, -122.397171192319)
41481	41481	212334	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	129 Kirkham St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		5994348.17175	2105286.0122599998	37.7603894466406	-122.462652156996	(37.7603894466406, -122.462652156996)
41860	41860	231452	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	1445 Douglass St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 2ft		6001412.730930001	2099437.4715400003	37.74473508626	-122.437800278973	(37.74473508626, -122.437800278973)
42156	42156	124996	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	233 Cervantes Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 2ft		6000861.45694	2121438.45328	37.8051128678164	-122.441284762493	(37.8051128678164, -122.441284762493)
42531	42531	180157	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	579 Madrid St	21	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 2ft		6002506.03817	2090671.0585599998	37.720726625705105	-122.433393514622	(37.7207266257051, -122.433393514622)
43219	43219	188023	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1001 17th St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 2ft		6014199.363390001	2106636.17997	37.765219982328794	-122.39409009070101	(37.7652199823288, -122.394090090701)
43695	43695	228118	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	214 Twin Peaks Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 2ft		5998413.80138	2104642.15355	37.758854879455704	-122.448544720466	(37.7588548794557, -122.448544720466)
44515	44515	212457	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	302 Westgate Dr	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 2ft		5993751.13544	2094703.55422	37.7312982921684	-122.46394883279498	(37.7312982921684, -122.463948832795)
44586	44586	125019	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	135 Marina Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 2ft		6002839.24225	2121472.8453599997	37.8053197640715	-122.43444286966499	(37.8053197640715, -122.434442869665)
44855	44855	201335	Undocumented 2	Prunus persica :: Peach 330	55 Bitting Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 2ft		6012667.25651	2092686.59474	37.7268321257865	-122.398410441015	(37.7268321257865, -122.398410441015)
45654	45654	202165	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	10 Kalmanovitz St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 2ft		6013169.468859999	2093279.75554	37.7284887885067	-122.39671585835698	(37.7284887885067, -122.396715858357)
46261	46261	220871	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	1543 Cole St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 2ft		5998317.5553	2105142.97668	37.7602245109746	-122.448913658336	(37.7602245109746, -122.448913658336)
46324	46324	135861	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	5 Dicha Aly	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 2ft		5998316.32407	2113776.61007	37.783930185978704	-122.44954003254999	(37.7839301859787, -122.44954003255)
46406	46406	201251	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	75 Orsi Cir	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 2ft		6012888.0536400005	2093268.37063	37.72844186100129	-122.397687933748	(37.7284418610013, -122.397687933748)
47404	47404	202314	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	185 Orsi Cir	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 2ft		6013069.98157	2092932.0318900002	37.7275284726433	-122.39703542256201	(37.7275284726433, -122.397035422562)
47471	47471	201334	Undocumented 2	Prunus persica :: Peach 330	55 Bitting Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 2ft		6012664.46076	2092688.7247099997	37.7268378185048	-122.398420255305	(37.7268378185048, -122.398420255305)
47791	47791	180154	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	579 Madrid St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 2ft		6002428.5851300005	2090547.8782799998	37.7203840056065	-122.433652446514	(37.7203840056065, -122.433652446514)
48040	48040	205281	Undocumented 2	Cordyline australis :: Dracena Palm 141	123 Ortega St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 2ft		5993520.55231	2102533.14677	37.7527830913663	-122.465314516263	(37.7527830913663, -122.465314516263)
48425	48425	120039	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	855 27th Ave	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 2ft		5987565.05941	2110100.68571	37.7732162236667	-122.486464996708	(37.7732162236667, -122.486464996708)
48487	48487	228116	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	214 Twin Peaks Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 2ft		5998413.83475	2104664.17253	37.7589153399906	-122.448546190847	(37.7589153399906, -122.448546190847)
48609	48609	201267	Undocumented 2	Cercis occidentalis :: Western Redbud 246	200 Kalmanovitz St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 2ft		6013091.83169	2092838.18677	37.727272009375795	-122.396953309066	(37.7272720093758, -122.396953309066)
48950	48950	175604	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	243 Curtis St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 2ft		6000875.03048	2087235.17223	37.711199783509	-122.43878530732201	(37.711199783509, -122.438785307322)
49483	49483	202282	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2 Issleib Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 2ft		6012752.33067	2093286.7606099998	37.7284847973147	-122.398158427588	(37.7284847973147, -122.398158427588)
49945	49945	209129	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	1301 Monterey Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 2ft		5993935.3367099995	2094440.81242	37.7305874815164	-122.463292961705	(37.7305874815164, -122.463292961705)
49972	49972	220283	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1 Clarendon Ave	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 2ft		5998403.60495	2104683.4410599996	37.7589676616433	-122.448582957854	(37.7589676616433, -122.448582957854)
50235	50235	131850	Undocumented 2	Olea europaea :: Olive Tree 41	3601 Baker St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 2ft		5999143.57978	2121190.63067	37.8043344065648	-122.447211810097	(37.8043344065648, -122.447211810097)
51619	51619	202125	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	2801 Newhall St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 2ft		6012532.0475	2092956.0428099998	37.7275644419367	-122.398896761103	(37.7275644419367, -122.398896761103)
52332	52332	201344	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Bitting Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 2ft		6012750.594330001	2092624.2153200002	37.7266654868035	-122.39811796796499	(37.7266654868035, -122.398117967965)
53209	53209	201245	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	105 Orsi Cir	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 2ft		6012837.41647	2093205.33465	37.7282659571993	-122.397858570225	(37.7282659571993, -122.397858570225)
53487	53487	120032	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	854 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 2ft		5987298.75417	2110090.52019	37.773172785402004	-122.487385423111	(37.773172785402, -122.487385423111)
53652	53652	202280	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2 Issleib Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		6012765.10374	2093281.55159	37.728471205862604	-122.39811390483801	(37.7284712058626, -122.398113904838)
53702	53702	218238	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	333 Wawona St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 2ft		5992020.14039	2097188.56235	37.738021590525996	-122.47011402534599	(37.738021590526, -122.470114025346)
54183	54183	202286	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	20 Issleib Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 2ft		6012723.82063	2093295.88873	37.7285082732156	-122.398257629099	(37.7285082732156, -122.398257629099)
54574	54574	238670	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	206 Palo Alto Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 2ft		5997584.930790001	2103890.70413	37.7567441598203	-122.45135712893601	(37.7567441598203, -122.451357128936)
56366	56366	127083	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	129 Marina Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 2ft		6002845.61482	2121466.23172	37.8053019664882	-122.43442034344	(37.8053019664882, -122.43442034344)
56519	56519	228119	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	214 Twin Peaks Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 2ft		5998413.1119800005	2104629.46424	37.7588199983569	-122.448546190847	(37.7588199983569, -122.448546190847)
56812	56812	180158	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	579 Madrid St	22	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 2ft		6002520.13209	2090692.25327	37.7207856212475	-122.433346310091	(37.7207856212475, -122.433346310091)
57303	57303	202263	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	8 Orsi Cir	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		6013104.38405	2093156.20787	37.728145929167205	-122.39693220287201	(37.7281459291672, -122.396932202872)
57567	57567	188053	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1133 19th St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 2ft		6014102.5404900005	2105239.77863	37.7613803880171	-122.39432720234	(37.7613803880171, -122.39432720234)
57926	57926	175606	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	243 Curtis St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 2ft		6000866.493969999	2087267.4309	37.7112878729966	-122.43881712171499	(37.7112878729966, -122.438817121715)
58338	58338	120043	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	855 27th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 2ft		5987561.7468	2110191.3833	37.7734650607809	-122.48648311573	(37.7734650607809, -122.48648311573)
58564	58564	202170	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	20 Kalmanovitz St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 2ft		6013162.88579	2093210.0704	37.7282970809393	-122.396733733287	(37.7282970809393, -122.396733733287)
58849	58849	180151	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	579 Madrid St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 2ft		6002388.988969999	2090485.78378	37.7202112611287	-122.433784881588	(37.7202112611287, -122.433784881588)
59004	59004	221201	Undocumented 2	Betula spp :: Birch 95	84 Richland Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 2ft		6005032.52935	2096155.14672	37.7359277331662	-122.425050206297	(37.7359277331662, -122.425050206297)
59122	59122	212338	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	129 Kirkham St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		5994412.01746	2105288.77127	37.7604006989457	-122.462431546075	(37.7604006989457, -122.462431546075)
59330	59330	232625	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	7 Clarendon Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		5998202.742319999	2104655.8655	37.7588804588858	-122.44927564535101	(37.7588804588858, -122.449275645351)
59799	59799	180152	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	579 Madrid St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 2ft		6002402.08753	2090505.7258900001	37.7202667609917	-122.433741028842	(37.7202667609917, -122.433741028842)
60718	60718	201254	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	75 Orsi Cir	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 2ft		6012906.67074	2093256.5794099998	37.7284105214187	-122.397622746406	(37.7284105214187, -122.397622746406)
61738	61738	222734	Undocumented 2	Ceanothus Sps :: California lilac 270	1335 Douglass St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		6001387.85036	2099809.36545	37.745754804151204	-122.437912943329	(37.7457548041512, -122.437912943329)
61906	61906	201275	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	210 Kalmanovitz St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 2ft		6013023.37655	2092747.7881599998	37.7270199824665	-122.39718362363399	(37.7270199824665, -122.397183623634)
62037	62037	187814	Undocumented 2	Acer buergeranum :: Trident Maple 120	1020 Le Conte Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 2ft		6013124.66356	2089609.91274	37.718409647453	-122.39661360273199	(37.718409647453, -122.396613602732)
62581	62581	177303	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	10 Ruth St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 2ft		6001666.9736	2091588.58341	37.7231983035377	-122.436359529079	(37.7231983035377, -122.436359529079)
64122	64122	242453	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	140 Belgrave Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 2ft		5997900.49529	2104918.67096	37.7595847638524	-122.45033989586399	(37.7595847638524, -122.450339895864)
64207	64207	202166	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	10 Kalmanovitz St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 2ft		6013167.38298	2093268.67632	37.7284582511357	-122.39672229302201	(37.7284582511357, -122.396722293022)
64294	64294	177562	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	10 Ruth St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 2ft		6001656.83533	2091594.1990900002	37.7232131468593	-122.43639497677201	(37.7232131468593, -122.436394976772)
64584	64584	201341	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Bitting Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 2ft		6012735.10181	2092634.8954900003	37.726693949445	-122.398172274424	(37.726693949445, -122.398172274424)
64898	64898	238671	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	206 Palo Alto Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 2ft		5997573.93956	2103890.5688099996	37.7567431588975	-122.451395130686	(37.7567431588975, -122.451395130686)
65363	65363	212335	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	129 Kirkham St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		5994366.98878	2105286.2028799998	37.7603910537209	-122.462587091934	(37.7603910537209, -122.462587091934)
65618	65618	201316	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	338 Kalmanovitz St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 2ft		6012923.5709	2092614.11032	37.7266473735717	-122.397519281196	(37.7266473735717, -122.397519281196)
65881	65881	195152	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1900 18th St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 2ft		6011945.62091	2105624.6088400004	37.7623169132205	-122.401814181581	(37.7623169132205, -122.401814181581)
66362	66362	202177	Undocumented 2	Washingtonia robusta :: Mexican Fan Palm 75	100 Kalmanovitz St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 2ft		6013132.229119999	2093003.70662	37.7277287417687	-122.396825253678	(37.7277287417687, -122.396825253678)
66885	66885	125017	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	159 Marina Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 2ft		6002727.1155900005	2121565.16212	37.8055668761666	-122.434837503846	(37.8055668761666, -122.434837503846)

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