Street_Tree_List

Data source: data.sfgov.org

176 rows where qSiteInfo = 14 sorted by qCaretaker 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

- 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, PlantType, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker ▲	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
82737	82737	106281	Undocumented 2	Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 474	399X Elliot St	2	Unaccepted Street : Yard 14	Tree 1	Rec/Park 3					Permit Number 772905	6008798.75873	2088103.6204900001	37.7140319762934	-122.41146014936301	(37.7140319762934, -122.411460149363)
95834	95834	106280	Undocumented 2	Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 474	399X Elliot St	1	Unaccepted Street : Yard 14	Tree 1	Rec/Park 3					Permit Number 772905	6008798.75873	2088103.6204900001	37.7140319762934	-122.41146014936301	(37.7140319762934, -122.411460149363)
119057	119057	106282	Undocumented 2	Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 474	399X Elliot St	3	Unaccepted Street : Yard 14	Tree 1	Rec/Park 3					Permit Number 772905	6008798.75873	2088103.6204900001	37.7140319762934	-122.41146014936301	(37.7140319762934, -122.411460149363)
3497	3497	247942	Planning Code 138.1 required 4	Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58	29 Joy St	5	Unaccepted Street : Yard 14	Tree 1	DPW 2			3		Permit Number 775404	6010292.72224	2098904.67919	37.7437730949632	-122.40705728398399	(37.7437730949632, -122.407057283984)
3501	3501	247943	Planning Code 138.1 required 4	Maytenus boaria :: Mayten 22	29 Joy St	6	Unaccepted Street : Yard 14	Tree 1	DPW 2			2		Permit Number 775404	6010304.2598	2098903.51059	37.7437705318851	-122.407017307297	(37.7437705318851, -122.407017307297)
3506	3506	247939	Planning Code 138.1 required 4	Quercus agrifolia :: Coast Live Oak 180	29 Joy St	2	Unaccepted Street : Yard 14	Tree 1	DPW 2			12		Permit Number 775404	6010258.299769999	2098917.5156900003	37.7438064148349	-122.40717721395	(37.7438064148349, -122.40717721395)
3510	3510	247941	Planning Code 138.1 required 4	Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58	29 Joy St	4	Unaccepted Street : Yard 14	Tree 1	DPW 2			5		Permit Number 775404	6010287.82636	2098909.7574	37.743786764646	-122.40707457072901	(37.743786764646, -122.407074570729)
3511	3511	247940	Planning Code 138.1 required 4	Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58	29 Joy St	3	Unaccepted Street : Yard 14	Tree 1	DPW 2			5		Permit Number 775404	6010280.31746	2098909.2881400003	37.7437850559498	-122.407100501782	(37.7437850559498, -122.407100501782)
3513	3513	247938	Planning Code 138.1 required 4	Prunus cerasifera :: Cherry Plum 16	29 Joy St	1	Unaccepted Street : Yard 14	Tree 1	DPW 2			9		Permit Number 775404	6010254.90659	2098918.71089	37.7438095066969	-122.407189031056	(37.7438095066969, -122.407189031056)
4716	4716	253674	DPW Maintained 3	Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225	600 x Sanchez St	2	Unaccepted Street : Yard 14	Tree 1	DPW 2				3x3		6003598.0	2104743.0	37.75942683738779	-122.43062255590701	(37.7594268373878, -122.430622555907)
4727	4727	253673	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	600 x Sanchez St	1	Unaccepted Street : Yard 14	Tree 1	DPW 2				3x3		6003598.0	2104743.0	37.75942683738779	-122.43062255590701	(37.7594268373878, -122.430622555907)
5081	5081	253792	Undocumented 2	Myoporum laetum :: Myoporum 1	1698X 08th Ave	2	Unaccepted Street : Yard 14	Tree 1	DPW 2				3x3		5993765.0	2103990.0	37.7567973297208	-122.464574954098	(37.7567973297208, -122.464574954098)
5085	5085	253795	Undocumented 2	Myoporum laetum :: Myoporum 1	1698X 08th Ave	5	Unaccepted Street : Yard 14	Tree 1	DPW 2				3x3		5993765.0	2103990.0	37.7567973297208	-122.464574954098	(37.7567973297208, -122.464574954098)
5092	5092	253791	Undocumented 2	Myoporum laetum :: Myoporum 1	1698X 08th Ave	1	Unaccepted Street : Yard 14	Tree 1	DPW 2				3x3		5993765.0	2103990.0	37.7567973297208	-122.464574954098	(37.7567973297208, -122.464574954098)
5097	5097	253793	Undocumented 2	Myoporum laetum :: Myoporum 1	1698X 08th Ave	3	Unaccepted Street : Yard 14	Tree 1	DPW 2				3x3		5993765.0	2103990.0	37.7567973297208	-122.464574954098	(37.7567973297208, -122.464574954098)
5099	5099	253794	Undocumented 2	Myoporum laetum :: Myoporum 1	1698X 08th Ave	4	Unaccepted Street : Yard 14	Tree 1	DPW 2				3x3		5993765.0	2103990.0	37.7567973297208	-122.464574954098	(37.7567973297208, -122.464574954098)
19241	19241	116677	DPW Maintained 3	Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58	100 Esmeralda Ave	16	Unaccepted Street : Yard 14	Tree 1	DPW 2						6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
42966	42966	112248	DPW Maintained 3	Acer spp :: Maple 158	1799X TAYLOR ST	1	Unaccepted Street : Yard 14	Tree 1	DPW 2			15			6008739.0	2118839.0	37.79842100686071	-122.413839504702	(37.7984210068607, -122.413839504702)
69268	69268	116648	DPW Maintained 3	Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193	199x Esmeralda Ave	3	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
77674	77674	116662	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	199x Esmeralda Ave	15	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
78555	78555	116671	DPW Maintained 3	Callistemon citrinus :: Lemon Bottlebrush 28	100 Esmeralda Ave	7	Unaccepted Street : Yard 14	Tree 1	DPW 2						6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
79334	79334	116646	DPW Maintained 3	Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193	199x Esmeralda Ave	1	Unaccepted Street : Yard 14	Tree 1	DPW 2			2			6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
82247	82247	116682	DPW Maintained 3	Pittosporum crassifolium :: Karo Tree 108	100 Esmeralda Ave	21	Unaccepted Street : Yard 14	Tree 1	DPW 2						6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
82496	82496	116652	DPW Maintained 3	Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193	199x Esmeralda Ave	7	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
86166	86166	116675	DPW Maintained 3	Quercus agrifolia :: Coast Live Oak 180	100 Esmeralda Ave	14	Unaccepted Street : Yard 14	Tree 1	DPW 2			14			6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
89602	89602	116672	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 Esmeralda Ave	9	Unaccepted Street : Yard 14	Tree 1	DPW 2						6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
92156	92156	116653	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	199x Esmeralda Ave	8	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
92622	92622	116679	DPW Maintained 3	Yucca elephantipes :: Giant Yucca 211	100 Esmeralda Ave	18	Unaccepted Street : Yard 14	Tree 1	DPW 2						6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
93306	93306	116660	DPW Maintained 3	Sequoia sempervirens :: Coast Redwood 116	199x Esmeralda Ave	13	Unaccepted Street : Yard 14	Tree 1	DPW 2			8			6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
94398	94398	116654	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	199x Esmeralda Ave	9	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
94793	94793	106979	DPW Maintained 3	Prunus domestica 'Green Gage' :: Green Gage Plum 506	801X Clipper St	1	Unaccepted Street : Yard 14	Tree 1	DPW 2			24			5999765.50041	2100345.59515	37.7471347718267	-122.443561289165	(37.7471347718267, -122.443561289165)
95215	95215	116655	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	199x Esmeralda Ave	9	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
95360	95360	116668	DPW Maintained 3	Cedrus deodara :: Deodar Cedar 129	100x Esmeralda Ave	4	Unaccepted Street : Yard 14	Tree 1	DPW 2						6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
95391	95391	113478	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	100x ESMERALDA AVE	5	Unaccepted Street : Yard 14	Tree 1	DPW 2			8			6006917.0	2098966.0	37.7437519821991	-122.418734104398	(37.7437519821991, -122.418734104398)
95944	95944	116681	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	100 Esmeralda Ave	20	Unaccepted Street : Yard 14	Tree 1	DPW 2						6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
97063	97063	116666	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100x Esmeralda Ave	2	Unaccepted Street : Yard 14	Tree 1	DPW 2						6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
101447	101447	116661	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	199x Esmeralda Ave	14	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
105354	105354	116656	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	199x Esmeralda Ave	10	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
105412	105412	116658	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	199x Esmeralda Ave	12	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
110332	110332	109200	Undocumented 2	Eucalyptus sideroxylon :: Red Ironbark 36	2401x CASTRO ST	7	Unaccepted Street : Yard 14	Tree 1	DPW 2						6002698.0	2098487.0	37.7421983129634	-122.43328816691401	(37.7421983129634, -122.433288166914)
110832	110832	116665	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100x Esmeralda Ave	1	Unaccepted Street : Yard 14	Tree 1	DPW 2			25			6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
112048	112048	116664	DPW Maintained 3	Acacia baileyana :: Bailey's Acacia 42	199x Esmeralda Ave	18	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
112164	112164	116647	DPW Maintained 3	Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193	199x Esmeralda Ave	2	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
112606	112606	105901	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	11X ELLIOT ST	2	Unaccepted Street : Yard 14	Tree 1	DPW 2			30			6009059.0	2088845.0	37.716082244868005	-122.410612975888	(37.716082244868, -122.410612975888)
113837	113837	116669	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 Esmeralda Ave	6	Unaccepted Street : Yard 14	Tree 1	DPW 2			20			6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
118788	118788	116651	DPW Maintained 3	Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193	199x Esmeralda Ave	6	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
122561	122561	105900	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	11X ELLIOT ST	1	Unaccepted Street : Yard 14	Tree 1	DPW 2			30			6009059.0	2088845.0	37.716082244868005	-122.410612975888	(37.716082244868, -122.410612975888)
123372	123372	116663	DPW Maintained 3	Araucaria araucana :: Monkey puzzle 154	199x Esmeralda Ave	16	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
123800	123800	116680	DPW Maintained 3	Dodonaea viscosa :: Hop Bush 132	100 Esmeralda Ave	19	Unaccepted Street : Yard 14	Tree 1	DPW 2						6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
126736	126736	116670	DPW Maintained 3	Quercus agrifolia :: Coast Live Oak 180	100 Esmeralda Ave	8	Unaccepted Street : Yard 14	Tree 1	DPW 2						6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
127057	127057	116678	DPW Maintained 3	Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58	100 Esmeralda Ave	17	Unaccepted Street : Yard 14	Tree 1	DPW 2						6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
129308	129308	116650	DPW Maintained 3	Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193	199x Esmeralda Ave	5	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
138343	138343	105902	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	11X ELLIOT ST	3	Unaccepted Street : Yard 14	Tree 1	DPW 2			40			6009059.0	2088845.0	37.716082244868005	-122.410612975888	(37.716082244868, -122.410612975888)
138825	138825	116683	DPW Maintained 3	Pittosporum crassifolium :: Karo Tree 108	100 Esmeralda Ave	22	Unaccepted Street : Yard 14	Tree 1	DPW 2						6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
139190	139190	116659	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	199x Esmeralda Ave	12	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
143384	143384	116676	DPW Maintained 3	Aesculus californica :: California Buckeye 338	100 Esmeralda Ave	15	Unaccepted Street : Yard 14	Tree 1	DPW 2						6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
144028	144028	113477	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100x Esmeralda Ave	10	Unaccepted Street : Yard 14	Tree 1	DPW 2			24			6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
144190	144190	116667	DPW Maintained 3	Cedrus deodara :: Deodar Cedar 129	100x Esmeralda Ave	3	Unaccepted Street : Yard 14	Tree 1	DPW 2						6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
145384	145384	116657	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	199x Esmeralda Ave	11	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
145521	145521	116649	DPW Maintained 3	Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193	199x Esmeralda Ave	4	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
549	549	251321	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	100X Monument Way	1	Unaccepted Street : Yard 14	Tree 1	Private 1
697	697	251362	Undocumented 2	Pinus Spp :: Pine Spp 105	1300X Stanyan St	1	Unaccepted Street : Yard 14	Tree 1	Private 1				3x3		5997565.0	2104877.0	37.7594511396077	-122.451497194349	(37.7594511396077, -122.451497194349)
934	934	251409	Undocumented 2	Pinus radiata :: Monterey Pine 3	95x Andover St	1	Unaccepted Street : Yard 14	Tree 1	Private 1				3x3		6007642.0	2098274.0	37.741892697320296	-122.41617822056101	(37.7418926973203, -122.416178220561)
3355	3355	253433	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	3 Vulcan Stwy	1	Unaccepted Street : Yard 14	Tree 1	Private 1				3x3		6000640.0	2106231.0	37.7633444989385	-122.440959493883	(37.7633444989385, -122.440959493883)
3496	3496	253449	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	330 Twin Peaks Blvd	1	Unaccepted Street : Yard 14	Tree 1	Private 1				10x10		5998688.0	2103995.0	37.7570936308358	-122.44754983450599	(37.7570936308358, -122.447549834506)
4222	4222	253622	Undocumented 2	Pittosporum spp :: Pittosporum spp 128	300x Naglee Ave		Unaccepted Street : Yard 14	Tree 1	Private 1
4552	4552	97357	Permitted Site 1	Tree(s) :: 17		7	Unaccepted Street : Yard 14	Tree 1	Private 1
4884	4884	253710	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Monument Way	4	Unaccepted Street : Yard 14	Tree 1	Private 1				10x10		5999088.0	2105836.0	37.7621714109075	-122.446298918118	(37.7621714109075, -122.446298918118)
4891	4891	253709	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Monument Way	3	Unaccepted Street : Yard 14	Tree 1	Private 1				10x10		5999088.0	2105836.0	37.7621714109075	-122.446298918118	(37.7621714109075, -122.446298918118)
4893	4893	253707	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Monument Way	1	Unaccepted Street : Yard 14	Tree 1	Private 1				10x10		5999088.0	2105836.0	37.7621714109075	-122.446298918118	(37.7621714109075, -122.446298918118)
4898	4898	253711	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Monument Way	5	Unaccepted Street : Yard 14	Tree 1	Private 1				10x10		5999088.0	2105836.0	37.7621714109075	-122.446298918118	(37.7621714109075, -122.446298918118)
4906	4906	253708	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Monument Way	2	Unaccepted Street : Yard 14	Tree 1	Private 1				10x10		5999088.0	2105836.0	37.7621714109075	-122.446298918118	(37.7621714109075, -122.446298918118)
4913	4913	97358	Permitted Site 1	Tree(s) :: 17		8	Unaccepted Street : Yard 14	Tree 1	Private 1
7011	7011	97356	Permitted Site 1	Tree(s) :: 17		6	Unaccepted Street : Yard 14	Tree 1	Private 1
7040	7040	97351	Permitted Site 1	Tree(s) :: 17		1	Unaccepted Street : Yard 14	Tree 1	Private 1
7555	7555	107448	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1111x Chestnut St	1	Unaccepted Street : Yard 14	Tree 1	Private 1			50			6006408.68895	2120404.8626200003	37.80258932431129	-122.42201440535801	(37.8025893243113, -122.422014405358)
8657	8657	97354	Permitted Site 1	Tree(s) :: 17		4	Unaccepted Street : Yard 14	Tree 1	Private 1
8668	8668	107450	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1140x Chestnut St	1	Unaccepted Street : Yard 14	Tree 1	Private 1			60			6006380.05181	2120425.48408	37.802644330436394	-122.42211497023399	(37.8026443304364, -122.422114970234)
9968	9968	173756	Undocumented 2	Pinus radiata :: Monterey Pine 3	1X Emil Ln	2	Unaccepted Street : Yard 14	Tree 1	Private 1				3x3		5996276.0	2095955.0	37.734879644622296	-122.455310374086	(37.7348796446223, -122.455310374086)
9970	9970	173755	Undocumented 2	Pinus radiata :: Monterey Pine 3	1X Emil Ln	1	Unaccepted Street : Yard 14	Tree 1	Private 1				3x3		5996276.0	2095955.0	37.734879644622296	-122.455310374086	(37.7348796446223, -122.455310374086)
10631	10631	97353	Permitted Site 1	Tree(s) :: 17		3	Unaccepted Street : Yard 14	Tree 1	Private 1
14893	14893	97355	Permitted Site 1	Tree(s) :: 17		5	Unaccepted Street : Yard 14	Tree 1	Private 1
16895	16895	97352	Permitted Site 1	Tree(s) :: 17		2	Unaccepted Street : Yard 14	Tree 1	Private 1
26646	26646	107449	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1130x CHESTNUT ST	1	Unaccepted Street : Yard 14	Tree 1	Private 1			60			6006351.9	2120450.9	37.802712528214705	-122.42221419659701	(37.8027125282147, -122.422214196597)
43848	43848	99190	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	1155@Greenwich Battery St	3	Unaccepted Street : Yard 14	Tree 1	Private 1		04/24/2012 12:00:00 AM	13	Park	Permit Number 768770	6012236.89935	2120056.2938	37.801959219714	-122.401821238566	(37.801959219714, -122.401821238566)
49637	49637	114270	Undocumented 2	Pinus radiata :: Monterey Pine 3	27x ESMERALDA AVE	2	Unaccepted Street : Yard 14	Tree 1	Private 1				3x3		6006799.0	2098981.0	37.743786524331	-122.41914318493001	(37.743786524331, -122.41914318493)
62864	62864	108717	Undocumented 2	Cedrus atlantica :: Atlas Cedar 304	1141 Chestnut St	3	Unaccepted Street : Yard 14	Tree 1	Private 1			7	3x3		6006358.32966	2120394.6178099997	37.802558354332795	-122.422187945742	(37.8025583543328, -122.422187945742)
72511	72511	98376	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	199X Cragmont Ave	1	Unaccepted Street : Yard 14	Tree 1	Private 1						5992899.0	2101153.0	37.7489576989052	-122.467363590244	(37.7489576989052, -122.467363590244)
76347	76347	111157	Undocumented 2	Myoporum laetum :: Myoporum 1	201x EUGENIA AVE	4	Unaccepted Street : Yard 14	Tree 1	Private 1				3x3		6006591.0	2098138.0	37.7414601197382	-122.419802596536	(37.7414601197382, -122.419802596536)
77461	77461	107157	Undocumented 2	Pinus radiata :: Monterey Pine 3	301X Esmeralda Ave	1	Unaccepted Street : Yard 14	Tree 1	Private 1			28			6007313.0	2098782.0	37.7432690474632	-122.41735179051201	(37.7432690474632, -122.417351790512)
78442	78442	99274	Undocumented 2	Pinus radiata :: Monterey Pine 3	16 Joy St	1	Unaccepted Street : Yard 14	Tree 1	Private 1				3x3	Permit Number 768828	6010347.9	2098933.4	37.7438550437031	-122.406868515265	(37.7438550437031, -122.406868515265)
79542	79542	115664	Undocumented 2	Myoporum laetum :: Myoporum 1	601x PERU AVE	2	Unaccepted Street : Yard 14	Tree 1	Private 1				3x3		6005068.0	2092670.0	37.726360298316294	-122.42467972288401	(37.7263602983163, -122.424679722884)
80443	80443	105069	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	49X Esmeralda Ave	2	Unaccepted Street : Yard 14	Tree 1	Private 1					Permit Number 771039	6006861.0	2099026.0	37.7439135755866	-122.41893199410299	(37.7439135755866, -122.418931994103)
81729	81729	109625	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	312x FILBERT ST	1	Unaccepted Street : Yard 14	Tree 1	Private 1			14			6011362.9	2120079.8	37.801974948341	-122.40484736081001	(37.801974948341, -122.40484736081)
82185	82185	111319	Undocumented 2	Eucalyptus sideroxylon :: Red Ironbark 36	200x PENINSULA AVE	2	Unaccepted Street : Yard 14	Tree 1	Private 1						6012569.0	2087626.0	37.71293127807179	-122.398395185538	(37.7129312780718, -122.398395185538)
82433	82433	111159	Undocumented 2	Myoporum laetum :: Myoporum 1	201x EUGENIA AVE	6	Unaccepted Street : Yard 14	Tree 1	Private 1				3x3		6006591.0	2098138.0	37.7414601197382	-122.419802596536	(37.7414601197382, -122.419802596536)
82723	82723	102522	Undocumented 2	Cedrus deodara :: Deodar Cedar 129	1X 31st St	2	Unaccepted Street : Yard 14	Tree 1	Private 1						5999966.2	2097547.4	37.7394630398899	-122.442666404233	(37.7394630398899, -122.442666404233)
83991	83991	96537	Permitted Site 1	Tree(s) :: 17	950X Kansas St	1	Unaccepted Street : Yard 14	Tree 1	Private 1		05/25/2011 12:00:00 AM			Permit Number 767960	6011564.8	2103917.5	37.7576083124183	-122.403011228478	(37.7576083124183, -122.403011228478)
84377	84377	107372	Undocumented 2	Acer palmatum :: Japanese Maple 175	305x GREENWICH ST	1	Unaccepted Street : Yard 14	Tree 1	Private 1			20			6011370.0	2120243.0	37.8024234525216	-122.40483428789801	(37.8024234525216, -122.404834287898)
85549	85549	122555	Permitted Site 1	Tree(s) :: 17	1910X Castro St	1	Unaccepted Street : Yard 14	Tree 1	Private 1						6002640.0	2099906.0	37.746091265221295	-122.433590100931	(37.7460912652213, -122.433590100931)

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