Street_Tree_List

Data source: data.sfgov.org

161 rows where qCaretaker = 1 and qSiteInfo = 11 sorted by Location

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location ▼
14379	14379	48480	Permitted Site 1	Tree(s) :: 17		1	Median : Cutout 11	Tree 1	Private 1					Permit Number 45832
142086	142086	110077	Undocumented 2	Pinus radiata :: Monterey Pine 3	4099x ALEMANY BLVD		Median : Cutout 11	Tree 1	Private 1			48			5991599.0	2086829.0	37.7095524384103	-122.470815701049	(37.7095524384103, -122.470815701049)
107501	107501	115835	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	900X LAKE MERCED BLVD	3	Median : Cutout 11	Tree 1	Private 1		08/30/2016 12:00:00 AM	3	10x100		5987646.0	2090104.0	37.7183153647657	-122.484717856844	(37.7183153647657, -122.484717856844)
111885	111885	115833	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	900X LAKE MERCED BLVD	1	Median : Cutout 11	Tree 1	Private 1		08/30/2016 12:00:00 AM	3	10x100		5987646.0	2090104.0	37.7183153647657	-122.484717856844	(37.7183153647657, -122.484717856844)
114243	114243	115834	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	900X LAKE MERCED BLVD	2	Median : Cutout 11	Tree 1	Private 1		08/30/2016 12:00:00 AM	3	10x100	Permit Number 777492	5987646.0	2090104.0	37.7183153647657	-122.484717856844	(37.7183153647657, -122.484717856844)
92233	92233	111089	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	10x HIGUERA AVE	1	Median : Cutout 11	Tree 1	Private 1		08/30/2016 12:00:00 AM	3	3x3	Permit Number 777485	5988057.0	2090190.0	37.7185754269376	-122.483303520979	(37.7185754269376, -122.483303520979)
108439	108439	110447	Undocumented 2	Pinus radiata :: Monterey Pine 3	1400 Holloway Ave	1	Median : Cutout 11	Tree 1	Private 1				5x5		5991161.796471	2091241.0154845002	37.7216414605593	-122.47264820285801	(37.7216414605593, -122.472648202858)
90152	90152	107496	Undocumented 2	Pinus radiata :: Monterey Pine 3	846x JUNIPERO SERRA BLVD	1	Median : Cutout 11	Tree 1	Private 1			60			5991242.0	2091754.0	37.7230546314384	-122.47240834171801	(37.7230546314384, -122.472408341718)
99750	99750	92208	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	300x Miramar Ave	2	Median : Cutout 11	Tree 1	Private 1		07/16/2009 12:00:00 AM		2x2	Permit Number 52642	5995384.3	2092126.4	37.724316032008204	-122.45811627477501	(37.7243160320082, -122.458116274775)
100266	100266	92210	Permitted Site 1	Pinus pinea :: Italian Stone Pine 143	300x Miramar Ave	4	Median : Cutout 11	Tree 1	Private 1		07/16/2009 12:00:00 AM		2x2	Permit Number 52642	5995384.3	2092126.4	37.724316032008204	-122.45811627477501	(37.7243160320082, -122.458116274775)
112226	112226	92209	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	300x Miramar Ave	3	Median : Cutout 11	Tree 1	Private 1		07/16/2009 12:00:00 AM		2x2	Permit Number 52642	5995384.3	2092126.4	37.724316032008204	-122.45811627477501	(37.7243160320082, -122.458116274775)
112766	112766	92207	Permitted Site 1	Pinus pinea :: Italian Stone Pine 143	300X Miramar Ave	1	Median : Cutout 11	Tree 1	Private 1		07/16/2009 12:00:00 AM		2x2	Permit Number 52642	5995384.3	2092126.4	37.724316032008204	-122.45811627477501	(37.7243160320082, -122.458116274775)
128923	128923	92212	Permitted Site 1	Tree(s) :: 17	300x Miramar Ave	6	Median : Cutout 11	Tree 1	Private 1		07/16/2009 12:00:00 AM		2x2	Permit Number 52642	5995384.3	2092126.4	37.724316032008204	-122.45811627477501	(37.7243160320082, -122.458116274775)
139081	139081	92211	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	300x Miramar Ave	5	Median : Cutout 11	Tree 1	Private 1		12/29/2010 12:00:00 AM		2x2	Permit Number 54064	5995384.3	2092126.4	37.724316032008204	-122.45811627477501	(37.7243160320082, -122.458116274775)
24427	24427	99454	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	400X Miramar Ave	4	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995388.7	2092398.7	37.7250639553871	-122.45812076272101	(37.7250639553871, -122.458120762721)
91074	91074	99452	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	400X Miramar Ave	2	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995388.7	2092398.7	37.7250639553871	-122.45812076272101	(37.7250639553871, -122.458120762721)
119791	119791	99453	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	400X Miramar Ave	3	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995388.7	2092398.7	37.7250639553871	-122.45812076272101	(37.7250639553871, -122.458120762721)
128319	128319	99451	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	400X Miramar Ave	1	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995388.7	2092398.7	37.7250639553871	-122.45812076272101	(37.7250639553871, -122.458120762721)
145354	145354	99455	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	400X Miramar Ave	5	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995388.7	2092398.7	37.7250639553871	-122.45812076272101	(37.7250639553871, -122.458120762721)
79420	79420	114061	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	700X LAKE MERCED BLVD	7	Median : Cutout 11	Tree 1	Private 1			52			5987837.0	2092819.0	37.7257811856502	-122.484256664993	(37.7257811856502, -122.484256664993)
98520	98520	114060	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	700X LAKE MERCED BLVD	6	Median : Cutout 11	Tree 1	Private 1			60			5987837.0	2092819.0	37.7257811856502	-122.484256664993	(37.7257811856502, -122.484256664993)
109936	109936	114056	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	700X LAKE MERCED BLVD	2	Median : Cutout 11	Tree 1	Private 1			61			5987837.0	2092819.0	37.7257811856502	-122.484256664993	(37.7257811856502, -122.484256664993)
118992	118992	114058	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	700X LAKE MERCED BLVD	4	Median : Cutout 11	Tree 1	Private 1			58			5987837.0	2092819.0	37.7257811856502	-122.484256664993	(37.7257811856502, -122.484256664993)
126354	126354	114055	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	700X LAKE MERCED BLVD	1	Median : Cutout 11	Tree 1	Private 1			50			5987837.0	2092819.0	37.7257811856502	-122.484256664993	(37.7257811856502, -122.484256664993)
142943	142943	114059	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	700X LAKE MERCED BLVD	5	Median : Cutout 11	Tree 1	Private 1			38			5987837.0	2092819.0	37.7257811856502	-122.484256664993	(37.7257811856502, -122.484256664993)
146162	146162	114057	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	700X LAKE MERCED BLVD	3	Median : Cutout 11	Tree 1	Private 1			46			5987837.0	2092819.0	37.7257811856502	-122.484256664993	(37.7257811856502, -122.484256664993)
77822	77822	97488	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	500X Miramar Ave	4	Median : Cutout 11	Tree 1	Private 1			10	15x280		5995423.2	2092691.6	37.7258701708071	-122.45802268806801	(37.7258701708071, -122.458022688068)
89076	89076	97486	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500X Miramar Ave	2	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995423.2	2092691.6	37.7258701708071	-122.45802268806801	(37.7258701708071, -122.458022688068)
90036	90036	97489	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	500X Miramar Ave	5	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995423.2	2092691.6	37.7258701708071	-122.45802268806801	(37.7258701708071, -122.458022688068)
111872	111872	97492	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500X Miramar Ave	8	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995423.2	2092691.6	37.7258701708071	-122.45802268806801	(37.7258701708071, -122.458022688068)
117015	117015	97487	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500X Miramar Ave	3	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995423.2	2092691.6	37.7258701708071	-122.45802268806801	(37.7258701708071, -122.458022688068)
120510	120510	97485	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	500X Miramar Ave	1	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995423.2	2092691.6	37.7258701708071	-122.45802268806801	(37.7258701708071, -122.458022688068)
126256	126256	97490	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	500X Miramar Ave	7	Median : Cutout 11	Tree 1	Private 1			12	15x280		5995423.2	2092691.6	37.7258701708071	-122.45802268806801	(37.7258701708071, -122.458022688068)
127626	127626	97493	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500X Miramar Ave	9	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995423.2	2092691.6	37.7258701708071	-122.45802268806801	(37.7258701708071, -122.458022688068)
139369	139369	97491	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	500X Miramar Ave	6	Median : Cutout 11	Tree 1	Private 1		10/14/2011 12:00:00 AM	30	15x280	Permit Number 768370	5995423.2	2092691.6	37.7258701708071	-122.45802268806801	(37.7258701708071, -122.458022688068)
82410	82410	99464	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	550X Miramar Ave	9	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995413.0	2092983.7	37.7266716211667	-122.45807907885799	(37.7266716211667, -122.458079078858)
86969	86969	99459	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	550X Miramar Ave	5	Median : Cutout 11	Tree 1	Private 1		10/28/2014 12:00:00 AM	3	15x280	Permit Number 772553	5995413.0	2092983.7	37.7266716211667	-122.45807907885799	(37.7266716211667, -122.458079078858)
90742	90742	99463	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	550X Miramar Ave	6	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995413.0	2092983.7	37.7266716211667	-122.45807907885799	(37.7266716211667, -122.458079078858)
106153	106153	99462	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	550X Miramar Ave	2	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995413.0	2092983.7	37.7266716211667	-122.45807907885799	(37.7266716211667, -122.458079078858)
120095	120095	99457	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	550X Miramar Ave	1	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995413.0	2092983.7	37.7266716211667	-122.45807907885799	(37.7266716211667, -122.458079078858)
121555	121555	99465	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	550X Miramar Ave	4	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995413.0	2092983.7	37.7266716211667	-122.45807907885799	(37.7266716211667, -122.458079078858)
126291	126291	99460	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	550X Miramar Ave	7	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995413.0	2092983.7	37.7266716211667	-122.45807907885799	(37.7266716211667, -122.458079078858)
139448	139448	99461	Undocumented 2	Pinus halepensis :: Allepo Pine 164	550X Miramar Ave	8	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995413.0	2092983.7	37.7266716211667	-122.45807907885799	(37.7266716211667, -122.458079078858)
142707	142707	99458	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	550X Miramar Ave	3	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995413.0	2092983.7	37.7266716211667	-122.45807907885799	(37.7266716211667, -122.458079078858)
96023	96023	113237	Undocumented 2	Cedrus deodara :: Deodar Cedar 129	700X JUNIPERO SERRA BLVD	1	Median : Cutout 11	Tree 1	Private 1				3x3		5991325.0	2093086.0	37.726716776202295	-122.472218478241	(37.7267167762023, -122.472218478241)
19496	19496	34866	Permitted Site 1	Olea europaea :: Olive Tree 41	579 Miramar Ave	1	Median : Cutout 11	Tree 1	Private 1	FUF 1	12/29/2015 12:00:00 AM			Permit Number 775311	5995338.59696042	2093168.95782094	37.7271760192259	-122.458349689476	(37.7271760192259, -122.458349689476)
78674	78674	99497	Permitted Site 1	Quercus agrifolia :: Coast Live Oak 180	1400X Plymouth Ave	4	Median : Cutout 11	Tree 1	Private 1						5995903.0	2093347.3	37.7276981218086	-122.45641145576	(37.7276981218086, -122.45641145576)
83274	83274	99496	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X Plymouth Ave	3	Median : Cutout 11	Tree 1	Private 1						5995903.0	2093347.3	37.7276981218086	-122.45641145576	(37.7276981218086, -122.45641145576)
87404	87404	99494	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X Plymouth Ave	1	Median : Cutout 11	Tree 1	Private 1						5995903.0	2093347.3	37.7276981218086	-122.45641145576	(37.7276981218086, -122.45641145576)
122780	122780	99495	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X Plymouth Ave	2	Median : Cutout 11	Tree 1	Private 1						5995903.0	2093347.3	37.7276981218086	-122.45641145576	(37.7276981218086, -122.45641145576)
114819	114819	115563	Undocumented 2	Pinus radiata :: Monterey Pine 3	600x JUNIPERO SERRA BLVD	1	Median : Cutout 11	Tree 1	Private 1			40	3x3		5991349.0	2093478.0	37.7277944993603	-122.47216407308998	(37.7277944993603, -122.47216407309)
80646	80646	99473	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	600X Miramar Ave	2	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995435.2	2093399.0	37.727813210556704	-122.458032376835	(37.7278132105567, -122.458032376835)
94507	94507	99469	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600X Miramar Ave	6	Median : Cutout 11	Tree 1	Private 1			4	15x280		5995435.2	2093399.0	37.727813210556704	-122.458032376835	(37.7278132105567, -122.458032376835)
97066	97066	99466	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600X Miramar Ave	1	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995435.2	2093399.0	37.727813210556704	-122.458032376835	(37.7278132105567, -122.458032376835)
101136	101136	99470	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600X Miramar Ave	8	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995435.2	2093399.0	37.727813210556704	-122.458032376835	(37.7278132105567, -122.458032376835)
112364	112364	99472	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	600X Miramar Ave	5	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995435.2	2093399.0	37.727813210556704	-122.458032376835	(37.7278132105567, -122.458032376835)
123808	123808	99468	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600X Miramar Ave	4	Median : Cutout 11	Tree 1	Private 1			6	15x280		5995435.2	2093399.0	37.727813210556704	-122.458032376835	(37.7278132105567, -122.458032376835)
141106	141106	99467	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600X Miramar Ave	3	Median : Cutout 11	Tree 1	Private 1			6	15x280		5995435.2	2093399.0	37.727813210556704	-122.458032376835	(37.7278132105567, -122.458032376835)
99860	99860	114066	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	600x LAKE MERCED BLVD	1	Median : Cutout 11	Tree 1	Private 1			36			5987697.0	2093816.0	37.7285105386339	-122.48481373540702	(37.7285105386339, -122.484813735407)
84567	84567	99479	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	650X Miramar Ave	7	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995425.4	2093662.3	37.728535605791	-122.45808530293199	(37.728535605791, -122.458085302932)
99445	99445	99474	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	650X Miramar Ave	5	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995425.4	2093662.3	37.728535605791	-122.45808530293199	(37.728535605791, -122.458085302932)
100862	100862	99476	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	650X Miramar Ave	2	Median : Cutout 11	Tree 1	Private 1		10/28/2014 12:00:00 AM	3	15x280	Permit Number 772553	5995425.4	2093662.3	37.728535605791	-122.45808530293199	(37.728535605791, -122.458085302932)
101015	101015	99477	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	650X Miramar Ave	6	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995425.4	2093662.3	37.728535605791	-122.45808530293199	(37.728535605791, -122.458085302932)
101615	101615	99480	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	650X Miramar Ave	8	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995425.4	2093662.3	37.728535605791	-122.45808530293199	(37.728535605791, -122.458085302932)
102939	102939	99481	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	650X Miramar Ave	3	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995425.4	2093662.3	37.728535605791	-122.45808530293199	(37.728535605791, -122.458085302932)
128765	128765	99475	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	650X Miramar Ave	1	Median : Cutout 11	Tree 1	Private 1		04/18/2014 12:00:00 AM	44	15x280	Permit Number 772553	5995425.4	2093662.3	37.728535605791	-122.45808530293199	(37.728535605791, -122.458085302932)
79587	79587	115562	Undocumented 2	Pinus radiata :: Monterey Pine 3	450x JUNIPERO SERRA BLVD	1	Median : Cutout 11	Tree 1	Private 1			30	3x3		5991387.0	2094058.0	37.7293892334347	-122.472074965405	(37.7293892334347, -122.472074965405)
86095	86095	103414	Permitted Site 1	Quercus agrifolia :: Coast Live Oak 180	1490X Plymouth Ave	1	Median : Cutout 11	Tree 1	Private 1		04/18/2013 12:00:00 AM			Permit Number 770026	5995919.3	2094026.5	37.7295639775589	-122.456404198854	(37.7295639775589, -122.456404198854)
20071	20071	99485	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	700X Miramar Ave	6	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995446.3	2094052.9	37.7296092999141	-122.458041307204	(37.7296092999141, -122.458041307204)
88472	88472	99487	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	700X Miramar Ave	4	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995446.3	2094052.9	37.7296092999141	-122.458041307204	(37.7296092999141, -122.458041307204)
114163	114163	99486	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	700X Miramar Ave	3	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995446.3	2094052.9	37.7296092999141	-122.458041307204	(37.7296092999141, -122.458041307204)
118496	118496	99484	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	700X Miramar Ave	5	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995446.3	2094052.9	37.7296092999141	-122.458041307204	(37.7296092999141, -122.458041307204)
126415	126415	99483	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	700X Miramar Ave	2	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995446.3	2094052.9	37.7296092999141	-122.458041307204	(37.7296092999141, -122.458041307204)
95382	95382	99489	Undocumented 2	Pinus halepensis :: Allepo Pine 164	800X Miramar Ave	6	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995450.2	2094280.5	37.7302344585425	-122.458044289565	(37.7302344585425, -122.458044289565)
128399	128399	99493	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	800X Miramar Ave	3	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995450.2	2094280.5	37.7302344585425	-122.458044289565	(37.7302344585425, -122.458044289565)
139244	139244	99492	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	800X Miramar Ave	2	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995450.2	2094280.5	37.7302344585425	-122.458044289565	(37.7302344585425, -122.458044289565)
3232	3232	253369	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	449X Trumbull St	1	Median : Cutout 11	Tree 1	Private 1				Width 10ft		6005840.0	2094317.0	37.730926169648	-122.42212790794599	(37.730926169648, -122.422127907946)
113986	113986	115182	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	315 Lakeshore Dr	1	Median : Cutout 11	Tree 1	Private 1		01/15/2016 12:00:00 AM			Permit Number 775158	5983956.6	2095109.9	37.7318446842931	-122.497839799214	(37.7318446842931, -122.497839799214)
78281	78281	111082	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	130 JUNIPERO SERRA BLVD	1	Median : Cutout 11	Tree 1	Private 1				3x3		5991393.0	2095322.0	37.7328602072681	-122.472146321186	(37.7328602072681, -122.472146321186)
112663	112663	114044	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	549X ARLINGTON ST		Median : Cutout 11	Tree 1	Private 1			70			6003400.0	2095634.0	37.734404428182295	-122.430657330781	(37.7344044281823, -122.430657330781)
122644	122644	110235	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	2346x CASTRO ST	1	Median : Cutout 11	Tree 1	Private 1				3x3		6002664.5	2098664.4	37.742683511585206	-122.43341667357402	(37.7426835115852, -122.433416673574)
117426	117426	106344	Permitted Site 1	Agonis flexuosa :: Peppermint Willow 7	2428 14th Ave	1	Median : Cutout 11	Tree 1	Private 1		04/18/2014 12:00:00 AM		3x3		5992079.0	2098890.7	37.7426986307713	-122.470034423922	(37.7426986307713, -122.470034423922)
144189	144189	106345	Permitted Site 1	Agonis flexuosa :: Peppermint Willow 7	2428 14th Ave	2	Median : Cutout 11	Tree 1	Private 1		04/18/2014 12:00:00 AM		3x3		5992079.0	2098890.7	37.7426986307713	-122.470034423922	(37.7426986307713, -122.470034423922)
88594	88594	112580	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	274X SAN MARCOS AVE	1	Median : Cutout 11	Tree 1	Private 1				3x20		5993121.0	2100271.0	37.7465487656332	-122.46653182115801	(37.7465487656332, -122.466531821158)
142725	142725	112581	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	274X SAN MARCOS AVE	2	Median : Cutout 11	Tree 1	Private 1				3x20		5993121.0	2100271.0	37.7465487656332	-122.46653182115801	(37.7465487656332, -122.466531821158)
77875	77875	106884	Undocumented 2	Ulmus pumila :: Siberian Elm 53	180X SAN MARCOS AVE	6	Median : Cutout 11	Tree 1	Private 1	DPW 4		4			5993452.8	2100406.9	37.746941053663505	-122.46539437233801	(37.7469410536635, -122.465394372338)
94262	94262	106880	Undocumented 2	Ulmus pumila :: Siberian Elm 53	180X SAN MARCOS AVE	3	Median : Cutout 11	Tree 1	Private 1	DPW 4		5			5993452.8	2100406.9	37.746941053663505	-122.46539437233801	(37.7469410536635, -122.465394372338)
108228	108228	106878	Undocumented 2	Pinus radiata :: Monterey Pine 3	180X SAN MARCOS AVE	1	Median : Cutout 11	Tree 1	Private 1	DPW 4		26			5993452.8	2100406.9	37.746941053663505	-122.46539437233801	(37.7469410536635, -122.465394372338)
114247	114247	106879	Undocumented 2	Albizia julibrissin :: Mimosa Silk Tree 126	180X SAN MARCOS AVE	2	Median : Cutout 11	Tree 1	Private 1	DPW 4		6			5993452.8	2100406.9	37.746941053663505	-122.46539437233801	(37.7469410536635, -122.465394372338)
125523	125523	106883	Undocumented 2	Ulmus pumila :: Siberian Elm 53	180X SAN MARCOS AVE	4	Median : Cutout 11	Tree 1	Private 1	DPW 4		4			5993452.8	2100406.9	37.746941053663505	-122.46539437233801	(37.7469410536635, -122.465394372338)
44175	44175	99145	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	302X Pacheco St	29	Median : Cutout 11	Tree 1	Private 1			9			5994341.5	2100725.2	37.747866238402096	-122.46234443277001	(37.7478662384021, -122.46234443277)
78288	78288	99129	Undocumented 2	Pinus radiata :: Monterey Pine 3	302X Pacheco St	12	Median : Cutout 11	Tree 1	Private 1			18			5994341.5	2100725.2	37.747866238402096	-122.46234443277001	(37.7478662384021, -122.46234443277)
81983	81983	99149	Undocumented 2	Pinus radiata :: Monterey Pine 3	302X Pacheco St	33	Median : Cutout 11	Tree 1	Private 1			24			5994341.5	2100725.2	37.747866238402096	-122.46234443277001	(37.7478662384021, -122.46234443277)
83372	83372	99155	Undocumented 2	Pinus radiata :: Monterey Pine 3	302X Pacheco St	38	Median : Cutout 11	Tree 1	Private 1			3			5994341.5	2100725.2	37.747866238402096	-122.46234443277001	(37.7478662384021, -122.46234443277)
83574	83574	99156	Undocumented 2	Pinus radiata :: Monterey Pine 3	302X Pacheco St	39	Median : Cutout 11	Tree 1	Private 1			6			5994341.5	2100725.2	37.747866238402096	-122.46234443277001	(37.7478662384021, -122.46234443277)
85707	85707	99130	Undocumented 2	Pinus radiata :: Monterey Pine 3	302X Pacheco St	13	Median : Cutout 11	Tree 1	Private 1			18			5994341.5	2100725.2	37.747866238402096	-122.46234443277001	(37.7478662384021, -122.46234443277)
88064	88064	99162	Undocumented 2	Pinus radiata :: Monterey Pine 3	302X Pacheco St	46	Median : Cutout 11	Tree 1	Private 1			24			5994341.5	2100725.2	37.747866238402096	-122.46234443277001	(37.7478662384021, -122.46234443277)
89044	89044	99160	Undocumented 2	Pinus radiata :: Monterey Pine 3	302X Pacheco St	44	Median : Cutout 11	Tree 1	Private 1			48			5994341.5	2100725.2	37.747866238402096	-122.46234443277001	(37.7478662384021, -122.46234443277)
89067	89067	99157	Undocumented 2	Pinus radiata :: Monterey Pine 3	302X Pacheco St	40	Median : Cutout 11	Tree 1	Private 1			24			5994341.5	2100725.2	37.747866238402096	-122.46234443277001	(37.7478662384021, -122.46234443277)
89136	89136	99125	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	302X Pacheco St	8	Median : Cutout 11	Tree 1	Private 1			3			5994341.5	2100725.2	37.747866238402096	-122.46234443277001	(37.7478662384021, -122.46234443277)

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