Street_Tree_List

Data source: data.sfgov.org

5,577 rows where qSpecies = 12 sorted by Longitude

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: 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
166592	166592	118482	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	8349 Geary Blvd	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1			5981039.36975	2112282.68151	37.7788247951526	-122.509199886896	(37.7788247951526, -122.509199886896)
68925	68925	118481	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	8349 Geary Blvd	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6			5981086.353519999	2112282.5400099996	37.7788271765554	-122.509037343924	(37.7788271765554, -122.509037343924)
135329	135329	118954	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	758 48th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 4ft		5981087.552180001	2110537.58401	37.7740361134392	-122.50890360004999	(37.7740361134392, -122.50890360005)
133469	133469	250983	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	145 Seal Rock Dr	1	: 4	Tree 1	Private 1			1	Width 3ft		5981179.0028800005	2112933.49353	37.780619963167204	-122.508765181767	(37.7806199631672, -122.508765181767)
98018	98018	115240	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	507 47th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/20/2016 12:00:00 AM			Permit Number 775523	5981264.2	2112246.8	37.7787395279518	-122.50841946002899	(37.7787395279518, -122.508419460029)
181428	181428	34717	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	527 47th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/28/1997 12:00:00 AM	16		Permit Number 38372	5981286.01571	2112124.00365	37.778403651193706	-122.50833487486601	(37.7784036511937, -122.508334874866)
145575	145575	47836	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	506 47th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/14/2002 12:00:00 AM			Permit Number 45598	5981328.87768988	2112285.52839896	37.778849676193296	-122.508198593969	(37.7788496761933, -122.508198593969)
87814	87814	117380	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	823 47th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/08/2016 12:00:00 AM	3		Permit Number 778551	5981342.0	2110110.3	37.772877912923896	-122.507991719286	(37.7728779129239, -122.507991719286)
52158	52158	84909	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	5546 Anza St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/03/2007 12:00:00 AM	3		Permit No. 49266	5981382.80004	2111678.6109599997	37.7771864376432	-122.507967003985	(37.7771864376432, -122.507967003985)
48437	48437	119156	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	823 47th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		5981357.44011	2110098.58227	37.7728466492176	-122.507937441297	(37.7728466492176, -122.507937441297)
68887	68887	84908	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	5546 Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/03/2007 12:00:00 AM	4		Permit No. 49266	5981399.61362	2111678.25016	37.7771864376524	-122.507908814714	(37.7771864376524, -122.507908814714)
179231	179231	84907	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	5546 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/03/2007 12:00:00 AM	7		Permit No. 49266	5981432.92251	2111680.65563	37.7771950048451	-122.507793769263	(37.7771950048451, -122.507793769263)
181935	181935	34723	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	33 Sutro Heights Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/24/2000 12:00:00 AM	7		Permit Number 38378	5981457.29395	2111286.79163	37.7761150061979	-122.50768022848601	(37.7761150061979, -122.507680228486)
153495	153495	34724	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	33 Sutro Heights Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/24/2000 12:00:00 AM	0		Permit Number 38378	5981478.07972	2111286.72218	37.776116040031496	-122.50760832105	(37.7761160400315, -122.50760832105)
58374	58374	184495	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1863 48th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5981306.2719	2102404.095	37.7517167869353	-122.507543400741	(37.7517167869353, -122.507543400741)
119741	119741	109189	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	482 46th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/02/2015 12:00:00 AM	3	3x3	Permit Number 774830	5981625.7586	2112517.84773	37.7795050464814	-122.507188823101	(37.7795050464814, -122.507188823101)
84823	84823	109188	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	482 46th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/02/2015 12:00:00 AM	3	3x3	Permit Number 774830	5981628.45653	2112492.50566	37.7794356235543	-122.507177609428	(37.7794356235543, -122.507177609428)
124002	124002	88116	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	4316 Kirkham St		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/01/2008 12:00:00 AM		3x3	Permit Number 51117	5981501.0	2104897.0	37.758573065623104	-122.50705492642099	(37.7585730656231, -122.507054926421)

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