Street_Tree_List

Data source: data.sfgov.org

176 rows where qSiteInfo = 14 sorted by SiteOrder 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
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
4913	4913	97358	Permitted Site 1	Tree(s) :: 17		8	Unaccepted Street : Yard 14	Tree 1	Private 1
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)
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)
4552	4552	97357	Permitted Site 1	Tree(s) :: 17		7	Unaccepted Street : Yard 14	Tree 1	Private 1
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)
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)
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)
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)
7011	7011	97356	Permitted Site 1	Tree(s) :: 17		6	Unaccepted Street : Yard 14	Tree 1	Private 1
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)
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)
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)
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)
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)
14893	14893	97355	Permitted Site 1	Tree(s) :: 17		5	Unaccepted Street : Yard 14	Tree 1	Private 1
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)
100068	100068	111158	Undocumented 2	Myoporum laetum :: Myoporum 1	201x EUGENIA AVE	5	Unaccepted Street : Yard 14	Tree 1	Private 1				3x3		6006591.0	2098138.0	37.7414601197382	-122.419802596536	(37.7414601197382, -122.419802596536)
105289	105289	105760	Permitted Site 1	Tree(s) :: 17	1910X CASTRO ST	5	Unaccepted Street : Yard 14	Tree 1	Private 1		04/10/2014 12:00:00 AM	15		Permit Number 771977	6002617.0	2100030.0	37.746430435118796	-122.43367849259899	(37.7464304351188, -122.433678492599)
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)
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)
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)
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)
8657	8657	97354	Permitted Site 1	Tree(s) :: 17		4	Unaccepted Street : Yard 14	Tree 1	Private 1
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)
86301	86301	105759	Permitted Site 1	Tree(s) :: 17	1910X CASTRO ST	4	Unaccepted Street : Yard 14	Tree 1	Private 1		04/10/2014 12:00:00 AM	15		Permit Number 771977	6002617.0	2100030.0	37.746430435118796	-122.43367849259899	(37.7464304351188, -122.433678492599)
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)
111257	111257	98379	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	199X Cragmont Ave	4	Unaccepted Street : Yard 14	Tree 1	Private 1						5992899.0	2101153.0	37.7489576989052	-122.467363590244	(37.7489576989052, -122.467363590244)
115115	115115	105652	Undocumented 2	Yucca elephantipes :: Giant Yucca 211	150 BRONTE ST	4	Unaccepted Street : Yard 14	Tree 1	Private 1			25			6009287.5	2096640.3	37.737499298818996	-122.410373266073	(37.737499298819, -122.410373266073)
128665	128665	117627	Undocumented 2	Pinus radiata :: Monterey Pine 3	890x VERMONT ST	4	Unaccepted Street : Yard 14	Tree 1	Private 1						6011292.0	2104239.0	37.7584758425658	-122.403977311201	(37.7584758425658, -122.403977311201)
139585	139585	115666	Undocumented 2	Myoporum laetum :: Myoporum 1	601x PERU AVE	4	Unaccepted Street : Yard 14	Tree 1	Private 1				3x3		6005068.0	2092670.0	37.726360298316294	-122.42467972288401	(37.7263602983163, -122.424679722884)
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)
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)
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)
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)
10631	10631	97353	Permitted Site 1	Tree(s) :: 17		3	Unaccepted Street : Yard 14	Tree 1	Private 1
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)
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)
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)
87282	87282	111156	Undocumented 2	Myoporum laetum :: Myoporum 1	201x EUGENIA AVE	3	Unaccepted Street : Yard 14	Tree 1	Private 1				3x3		6006591.0	2098138.0	37.7414601197382	-122.419802596536	(37.7414601197382, -122.419802596536)
88788	88788	117626	Undocumented 2	Pinus radiata :: Monterey Pine 3	890x VERMONT ST	3	Unaccepted Street : Yard 14	Tree 1	Private 1						6011292.0	2104239.0	37.7584758425658	-122.403977311201	(37.7584758425658, -122.403977311201)
91188	91188	111312	Undocumented 2	Acacia spp :: Acacia Spp 176	99x GILROY ST	3	Unaccepted Street : Yard 14	Tree 1	Private 1				30x30		6015277.0	2088666.0	37.7159373992527	-122.389107938034	(37.7159373992527, -122.389107938034)
94946	94946	95436	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	2675 25th Ave	3	Unaccepted Street : Yard 14	Tree 1	Private 1			16			5988610.0	2097126.3	37.7376529013161	-122.48189987005101	(37.7376529013161, -122.481899870051)
96239	96239	115665	Undocumented 2	Myoporum laetum :: Myoporum 1	601x PERU AVE	3	Unaccepted Street : Yard 14	Tree 1	Private 1				3x3		6005068.0	2092670.0	37.726360298316294	-122.42467972288401	(37.7263602983163, -122.424679722884)
106956	106956	97537	Permitted Site 1	Pinus radiata :: Monterey Pine 3	300 Winfield St	3	Unaccepted Street : Yard 14	Tree 1	Private 1						6006649.9	2098038.3	37.7411896837785	-122.41959186825599	(37.7411896837785, -122.419591868256)
110195	110195	105756	Permitted Site 1	Tree(s) :: 17	1910X CASTRO ST	3	Unaccepted Street : Yard 14	Tree 1	Private 1		04/10/2014 12:00:00 AM	14		Permit Number 771977	6002640.0	2099906.0	37.746091265221295	-122.433590100931	(37.7460912652213, -122.433590100931)
115043	115043	105070	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	49X Esmeralda Ave	3	Unaccepted Street : Yard 14	Tree 1	Private 1					Permit Number 771039	6006861.0	2099026.0	37.7439135755866	-122.41893199410299	(37.7439135755866, -122.418931994103)
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)
121692	121692	98378	Permitted Site 1	Cupressus macrocarpa :: Monterey Cypress 47	199X Cragmont Ave	3	Unaccepted Street : Yard 14	Tree 1	Private 1					Permit Number 768647	5992899.0	2101153.0	37.7489576989052	-122.467363590244	(37.7489576989052, -122.467363590244)
122748	122748	111320	Undocumented 2	Eucalyptus sideroxylon :: Red Ironbark 36	200x PENINSULA AVE	3	Unaccepted Street : Yard 14	Tree 1	Private 1						6012569.0	2087626.0	37.71293127807179	-122.398395185538	(37.7129312780718, -122.398395185538)
127372	127372	112739	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	444 Franconia St	3	Unaccepted Street : Yard 14	Tree 1	Private 1			30			6009949.70212209	2098546.33795552	37.7427699663381	-122.40821810325701	(37.7427699663381, -122.408218103257)
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)
139483	139483	115526	Permitted Site 1	Tree(s) :: 17	25 FRANCONIA ST	3	Unaccepted Street : Yard 14	Tree 1	Private 1		07/12/2016 12:00:00 AM	3	3x3	Permit Number 777451	6010006.0	2099954.0	37.746638251201404	-122.408122694659	(37.7466382512014, -122.408122694659)
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)
145558	145558	105653	Undocumented 2	Pinus radiata :: Monterey Pine 3	150 BRONTE ST	3	Unaccepted Street : Yard 14	Tree 1	Private 1			16		Permit Number 770978	6009287.5	2096640.3	37.737499298818996	-122.410373266073	(37.737499298819, -122.410373266073)
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)
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)
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)
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)
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)
16895	16895	97352	Permitted Site 1	Tree(s) :: 17		2	Unaccepted Street : Yard 14	Tree 1	Private 1
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)
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)
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)
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)
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)
86227	86227	112615	Undocumented 2	Pinus radiata :: Monterey Pine 3	1798x 22ND ST	2	Unaccepted Street : Yard 14	Tree 1	Private 1		05/02/2016 12:00:00 AM	3			6012787.0	2103832.0	37.7574417223043	-122.398778335858	(37.7574417223043, -122.398778335858)
96975	96975	111311	Undocumented 2	Acacia spp :: Acacia Spp 176	99x GILROY ST	2	Unaccepted Street : Yard 14	Tree 1	Private 1				30x30		6015277.0	2088666.0	37.7159373992527	-122.389107938034	(37.7159373992527, -122.389107938034)
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)
102335	102335	108605	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1140x CHESTNUT ST	2	Unaccepted Street : Yard 14	Tree 1	Private 1						6006369.1	2120452.7	37.802718440704204	-122.42215480373899	(37.8027184407042, -122.422154803739)
102606	102606	112729	Undocumented 2	Pinus radiata :: Monterey Pine 3	444 Franconia St	2	Unaccepted Street : Yard 14	Tree 1	Private 1			24			6009949.70212209	2098546.33795552	37.7427699663381	-122.40821810325701	(37.7427699663381, -122.408218103257)
105116	105116	105651	Undocumented 2	Yucca elephantipes :: Giant Yucca 211	150 BRONTE ST	2	Unaccepted Street : Yard 14	Tree 1	Private 1			20			6009287.5	2096640.3	37.737499298818996	-122.410373266073	(37.737499298819, -122.410373266073)
106187	106187	106504	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	3974 22nd St	2	Unaccepted Street : Yard 14	Tree 1	Private 1					Permit Number 773286	6002049.0	2102947.0	37.754407578182004	-122.435851245675	(37.754407578182, -122.435851245675)
111080	111080	98377	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	199X Cragmont Ave	2	Unaccepted Street : Yard 14	Tree 1	Private 1						5992899.0	2101153.0	37.7489576989052	-122.467363590244	(37.7489576989052, -122.467363590244)
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)
114760	114760	111155	Undocumented 2	Myoporum laetum :: Myoporum 1	201x EUGENIA AVE	2	Unaccepted Street : Yard 14	Tree 1	Private 1				3x3		6006591.0	2098138.0	37.7414601197382	-122.419802596536	(37.7414601197382, -122.419802596536)

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