Street_Tree_List

Data source: data.sfgov.org

5,577 rows where qSpecies = 12 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

- 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, qSiteInfo, PlantType, qCaretaker, qCareAssistant

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location ▼
294	294	251266	Private 5	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	10x Paloma Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1
675	675	47038	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	716 Walter St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/02/2002 12:00:00 AM			Permit Number 45030
1828	1828	35192	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
1869	1869	35202	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
2080	2080	34119	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37980
3062	3062	34116	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37979
3077	3077	35211	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
3212	3212	34102	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37975
3420	3420	35199	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
3622	3622	34463	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1521 Ralston Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/15/1997 12:00:00 AM			Permit Number 38201
3663	3663	36860	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/26/1998 12:00:00 AM			Permit Number 39538
3723	3723	253167	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1X Brotherhood Way	1	Front Yard : Yard 7	Tree 1	DPW 2
5605	5605	34138	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37987
5673	5673	46713	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/24/2002 12:00:00 AM			Permit Number 44843
5690	5690	34100	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37975
5885	5885	46715	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/24/2002 12:00:00 AM			Permit Number 44843
6242	6242	35188	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		16	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
6282	6282	46717	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/24/2002 12:00:00 AM			Permit Number 44843
7169	7169	34120	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37980
7188	7188	34462	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1521 Ralston Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/15/1997 12:00:00 AM			Permit Number 38201
7206	7206	46718	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/24/2002 12:00:00 AM			Permit Number 44843
7464	7464	35185	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		19	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
7694	7694	36863	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/26/1998 12:00:00 AM			Permit Number 39538
7712	7712	35193	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
8041	8041	46716	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/24/2002 12:00:00 AM			Permit Number 44843
8802	8802	50777	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 47304
8884	8884	34133	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37986
9418	9418	34114	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37978
9430	9430	47039	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	771 Walter St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/02/2002 12:00:00 AM			Permit Number 45031
9498	9498	36866	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/26/1998 12:00:00 AM			Permit Number 39538
9542	9542	34136	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37986
9591	9591	36856	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/26/1998 12:00:00 AM			Permit Number 39538
9614	9614	36864	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/26/1998 12:00:00 AM			Permit Number 39538
10854	10854	34134	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37986
10862	10862	34464	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1521 Ralston Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/15/1997 12:00:00 AM			Permit Number 38201
10907	10907	34118	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37979
10955	10955	109923	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	214 state st	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3
11057	11057	46152	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/27/2001 12:00:00 AM			Permit Number 44491
11070	11070	34466	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1521 Ralston Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/15/1997 12:00:00 AM			Permit Number 38201
11107	11107	34137	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37987
11262	11262	34121	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37980
11449	11449	35191	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
11627	11627	88529	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12			Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/21/2008 12:00:00 AM		3x3	Permit Number 51479
11728	11728	35200	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
11762	11762	47040	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	771 Walter St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/02/2002 12:00:00 AM			Permit Number 45031
12079	12079	46714	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/24/2002 12:00:00 AM			Permit Number 44843
12275	12275	35186	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
12401	12401	36861	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/26/1998 12:00:00 AM			Permit Number 39538
12589	12589	34135	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37986
13016	13016	35189	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		15	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
13086	13086	34123	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37981
13445	13445	36857	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/26/1998 12:00:00 AM			Permit Number 39538
13457	13457	36874	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/26/1998 12:00:00 AM			Permit Number 39538
14227	14227	35184	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
14448	14448	34465	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1521 Ralston Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/15/1997 12:00:00 AM			Permit Number 38201
14687	14687	35195	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
14730	14730	34101	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37975
14763	14763	50776	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 47304
14818	14818	35190	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
14890	14890	36859	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/26/1998 12:00:00 AM			Permit Number 39538
14897	14897	36862	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/26/1998 12:00:00 AM			Permit Number 39538
15003	15003	34117	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37979
15057	15057	34122	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37981
15117	15117	36858	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/26/1998 12:00:00 AM			Permit Number 39538
15124	15124	35187	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
15243	15243	109931	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2822 Moraga Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/12/2015 12:00:00 AM	3	3x3	Permit Number 775171
15510	15510	34461	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1521 Ralston Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/15/1997 12:00:00 AM			Permit Number 38201
15551	15551	34115	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37978
15779	15779	50775	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 47304
15869	15869	46153	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/27/2001 12:00:00 AM			Permit Number 44491
15972	15972	34132	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37986
16027	16027	35201	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
16469	16469	35182	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
16677	16677	36865	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/26/1998 12:00:00 AM			Permit Number 39538
16819	16819	34124	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37982
16829	16829	35194	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
16890	16890	34103	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37975
17122	17122	35196	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
17926	17926	85267	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1000 Edinburgh St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/24/2007 12:00:00 AM			Permit Number 49560
19118	19118	85268	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1000 Edinburgh St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/24/2007 12:00:00 AM			Permit Number 49560
21962	21962	85270	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1000 Edinburgh St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/24/2007 12:00:00 AM			Permit Number 49560
25439	25439	85269	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1000 Edinburgh St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/24/2007 12:00:00 AM			Permit Number 49560
52762	52762	71598	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	126 Wilson St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/30/1995 12:00:00 AM	9			5994743.91592	2086305.62835	37.70829675666771	-122.45990852057301	(37.7082967566677, -122.459908520573)
157034	157034	53003	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	88@ GENEVA Pasadena St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/21/2006 12:00:00 AM	4		Permit Number 48983	6006543.04417	2086136.9597599998	37.708505157469	-122.41911735719201	(37.708505157469, -122.419117357192)
1556	1556	251583	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	75 Rice St		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5995352.0	2086409.0	37.7086155444167	-122.45781440192499	(37.7086155444167, -122.457814401925)
90824	90824	73959	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	75 Rice St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/30/1995 12:00:00 AM	4	2x4	Permit Number 773591	5995358.56494273	2086411.36688337	37.7086224204841	-122.457791883945	(37.7086224204841, -122.457791883945)
146195	146195	71596	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	75 Rice St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/30/1995 12:00:00 AM	12	2x3		5995358.56494273	2086411.36688337	37.7086224204841	-122.457791883945	(37.7086224204841, -122.457791883945)
75296	75296	115723	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	147 Baltimore Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/23/2016 12:00:00 AM	3		Permit Number 775898	6002684.2	2086288.6	37.7087034632659	-122.432464808573	(37.7087034632659, -122.432464808573)
12459	12459	25774	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2027 Geneva Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/07/1997 12:00:00 AM	16	2x3		6005967.118919999	2086230.6545099998	37.7087299735811	-122.42111447716299	(37.7087299735811, -122.421114477163)
174882	174882	71606	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	182 Wilson St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/30/1995 12:00:00 AM	13			5994495.515430001	2086527.6412	37.708892062899	-122.460783093263	(37.708892062899, -122.460783093263)
12166	12166	25775	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1965 Geneva Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/07/1997 12:00:00 AM	16	2X3		6005734.23372	2086319.0681	37.708959607374	-122.42192563687999	(37.708959607374, -122.42192563688)
180245	180245	44388	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	375 Chicago Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/22/2001 12:00:00 AM	11		Permit Number 43748	6002261.2315	2086392.26553	37.708964112084104	-122.433934046742	(37.7089641120841, -122.433934046742)
41117	41117	71607	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	190 Wilson St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/30/1995 12:00:00 AM	11			5994457.91424	2086560.2946	37.708979557936104	-122.46091541234199	(37.7089795579361, -122.460915412342)
11640	11640	25776	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1927 Geneva Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/07/1997 12:00:00 AM	18	2X3		6005592.75122	2086370.79672	37.709093663004495	-122.42241829446199	(37.7090936630045, -122.422418294462)
9959	9959	57959	Planning Code 138.1 required 4	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	336 Hanover St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/13/2017 12:00:00 AM	3	3x3	Permit Number 774423	5999490.29697456	2086502.70799744	37.7091097236101	-122.443518692288	(37.7091097236101, -122.443518692288)
159671	159671	175338	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	248 Wilson St	1	: 4	Tree 1	Private 1			10	Width 3ft		5994374.45478	2086640.5688599998	37.709195169503005	-122.461209673184	(37.709195169503, -122.461209673184)
186888	186888	175547	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	348 Chicago Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		6002373.36986	2086487.8856799998	37.709233027364995	-122.433553309758	(37.709233027365, -122.433553309758)
152452	152452	175339	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	248 Wilson St	3	: 4	Tree 1	Private 1			8	Width 3ft		5994341.375580001	2086670.8513099998	37.709276414241295	-122.46132619294399	(37.7092764142413, -122.461326192944)
131156	131156	44387	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	330 Chicago Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/22/2001 12:00:00 AM	13		Permit Number 43747	6002496.67334	2086552.28846	37.7094168586614	-122.433131752528	(37.7094168586614, -122.433131752528)
154404	154404	175342	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	18 Rhine St	3	: 4	Tree 1	Private 1			11	Width 3ft		5994489.11096	2086733.7148099998	37.7094575242209	-122.46082015254801	(37.7094575242209, -122.460820152548)

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