Street_Tree_List

Data source: data.sfgov.org

122 rows where SiteOrder = 2 and qSpecies = 45

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, qSiteInfo, qCaretaker, DBH, PlotSize

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
596	596	240413	DPW Maintained 3	Rhamnus alaternus :: Italian Buckthorn 45	3420 Market St	2	: 4	Tree 1	DPW 2		04/19/1996 12:00:00 AM	8	Width 3ft		6000107.95046	2103900.11575	37.756914147893795	-122.442632304847	(37.7569141478938, -122.442632304847)
1152	1152	240384	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	65 Hermann St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/04/2017 12:00:00 AM	3	Width 2ft	Permit Number 779910	6004983.769180001	2108813.08838	37.7706807377627	-122.426119636009	(37.7706807377627, -122.426119636009)
1559	1559	207057	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	340 Vicente St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991827.84816	2097768.2699700003	37.7396022020835	-122.47082108403099	(37.7396022020835, -122.470821084031)
1984	1984	252847	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	1500 Harrison St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6008908.0	2108725.0	37.7706598827985	-122.412539385599	(37.7706598827985, -122.412539385599)
2370	2370	112542	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	438 Broadway	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/24/2016 12:00:00 AM	3	3x3		6011405.06525	2118709.9257400003	37.7982159634572	-122.40460495956002	(37.7982159634572, -122.40460495956)
9846	9846	41266	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	2929 Webster St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/23/2016 12:00:00 AM	3		Permit Number 779089	6002905.04785	2118704.6759200003	37.7977228301084	-122.434017142274	(37.7977228301084, -122.434017142274)
10851	10851	52794	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	1277TEHAMA Houston St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/25/2006 12:00:00 AM			Permit Number 48833
10944	10944	35742	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/15/1998 12:00:00 AM			Permit Number 39016
19205	19205	17244	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	10X Randolph St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/08/2005 12:00:00 AM	6	3X3		5993945.3779	2088542.9193	37.7143938707274	-122.462830535838	(37.7143938707274, -122.462830535838)
25229	25229	197350	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	719 Tehama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		6009290.40599	2110497.98819	37.7755495477154	-122.411341904202	(37.7755495477154, -122.411341904202)
26432	26432	141346	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	463 BRODERICK ST	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		6001145.1037	2110334.7664	37.774641176317104	-122.439506706044	(37.7746411763171, -122.439506706044)
26602	26602	89200	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	3236 Broderick St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/08/2008 12:00:00 AM	4	3x3	Permit Number 51816	5999879.096940001	2119719.87548	37.8003381062886	-122.444560730091	(37.8003381062886, -122.444560730091)
26795	26795	179378	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	2016 Bay Shore Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 2ft		6012163.289480001	2088075.41369	37.7141426692356	-122.39982900101299	(37.7141426692356, -122.399829001013)
27695	27695	214032	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	342 Staples Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5997805.133780001	2093821.6600400002	37.729109618413	-122.449869953332	(37.729109618413, -122.449869953332)
27782	27782	136327	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	463 Broadway	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6011305.85301	2118630.68117	37.797992831771495	-122.404942682854	(37.7979928317715, -122.404942682854)
28149	28149	214012	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	1479 Funston Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5992097.0420699995	2105377.93896	37.7605119495939	-122.47044439308998	(37.7605119495939, -122.47044439309)
29223	29223	183217	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	3150 Rivera St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5983341.801	2100199.14	37.7457822914528	-122.50034138058201	(37.7457822914528, -122.500341380582)
29438	29438	31973	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	100 02nd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/30/1995 12:00:00 AM	5		Permit Number 35372	5995224.68838	2114814.58842	37.7866028473263	-122.460311111336	(37.7866028473263, -122.460311111336)
30486	30486	214028	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	130 Baden St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6000768.83365	2094531.22311	37.7312270433827	-122.43967507764201	(37.7312270433827, -122.439675077642)
31223	31223	184437	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	2115 45th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5982295.3096	2100678.1438	37.7470360206297	-122.50399540910401	(37.7470360206297, -122.503995409104)
32010	32010	136323	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	360 Broadway	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6011675.19116	2118742.8856099998	37.79832155645679	-122.403672558643	(37.7983215564568, -122.403672558643)
34981	34981	207052	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	1266 09th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5993336.085580001	2106823.92199	37.7645538041289	-122.46626423270901	(37.7645538041289, -122.466264232709)
35219	35219	136329	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	447 Broadway	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			2	Width 3ft		6011341.08824	2118636.57968	37.7980109971731	-122.404821173685	(37.7980109971731, -122.404821173685)
35612	35612	72078	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	167 20th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/14/1984 12:00:00 AM	5			5989583.57132	2114255.42421	37.784741432124	-122.479786850818	(37.784741432124, -122.479786850818)
36052	36052	240426	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	60 Brady St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6006672.38997	2109529.27096	37.772742500096705	-122.42032950031499	(37.7727425000967, -122.420329500315)
36061	36061	214023	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	111 Hearst Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 2ft		6000598.84895	2094335.4471599997	37.7306798113107	-122.44024870933599	(37.7306798113107, -122.440248709336)
39381	39381	74867	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	3501 Jackson St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/10/1996 12:00:00 AM	4			5997417.18704	2116038.42588	37.7900890536146	-122.452814005488	(37.7900890536146, -122.452814005488)
40074	40074	181349	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	2254 29th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5987333.026000001	2099936.24	37.745293905616705	-122.48652117681601	(37.7452939056167, -122.486521176816)
41367	41367	197347	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	1245 Howard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6009016.84079	2110503.78617	37.775550120588605	-122.41228864573	(37.7755501205886, -122.41228864573)
46279	46279	240375	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	99 Ramona Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6005227.26292	2107315.18034	37.7665816008793	-122.425170785627	(37.7665816008793, -122.425170785627)
47422	47422	37962	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	150 Mississippi St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/16/2009 12:00:00 AM	3	3x3	Permit Number 52636	6013967.394309999	2106347.66255	37.7644148813545	-122.39487221400299	(37.7644148813545, -122.394872214003)
48717	48717	214026	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	124 Baden St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 5ft		6000776.43659	2094502.29985	37.7311480595383	-122.43964672023199	(37.7311480595383, -122.439646720232)
50906	50906	200055	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	1800 Lane St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6014871.4407	2094140.9637	37.7309480732984	-122.390892168964	(37.7309480732984, -122.390892168964)
52507	52507	72377	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	2015 Balboa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/17/1996 12:00:00 AM	3			5989328.1004	2111226.70664	37.776410575889	-122.480448911859	(37.776410575889, -122.480448911859)
53789	53789	32019	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	900 07th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/24/1995 12:00:00 AM			Permit Number 35412	6012513.40810989	2108571.960758	37.7704413522571	-122.40005739994601	(37.7704413522571, -122.400057399946)
54123	54123	140855	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	621 Euclid Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5996425.9427	2113796.2189	37.7838757026194	-122.45608143549101	(37.7838757026194, -122.456081435491)
54599	54599	240401	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	499 Hoffman Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6000694.66286	2101176.32982	37.749468718214004	-122.440407898332	(37.749468718214, -122.440407898332)
63294	63294	47746	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	4201 Clement St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/30/2002 12:00:00 AM	6		Permit Number 45527	5982405.06542	2113061.4232400004	37.781043413721704	-122.50453319829201	(37.7810434137217, -122.504533198292)
67968	67968	240378	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	87 14th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6008072.764690001	2107952.79864	37.768492689	-122.41537380956899	(37.768492689, -122.415373809569)
71077	71077	240373	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	1373 Utah St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 5ft		6010904.97586	2101974.91384	37.7522375329589	-122.405156394162	(37.7522375329589, -122.405156394162)
72433	72433	122278	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	1750 Balboa St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 3ft		5990134.53204	2111321.8992	37.776718780123794	-122.477666227559	(37.7767187801238, -122.477666227559)
72907	72907	214025	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	118 Baden St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		6000768.8435	2094480.0839900002	37.7310866277439	-122.439671378725	(37.7310866277439, -122.439671378725)
73278	73278	113422	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	1583 Shafter Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		11	3x3		6015014.3399	2094064.2928	37.7307454784064	-122.390392783554	(37.7307454784064, -122.390392783554)
75456	75456	240418	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	150 Conrad St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6001776.14511	2096508.8311299998	37.73671438186	-122.436334107928	(37.73671438186, -122.436334107928)
77489	77489	33057	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	328 San Jose Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/05/1996 12:00:00 AM			Permit Number 37328	6006171.76331287	2101198.94449976	37.7498411527935	-122.421469507825	(37.7498411527935, -122.421469507825)
80857	80857	38028	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	2490X 14th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/10/1998 12:00:00 AM			Permit Number 40235	5992179.14418088	2098457.94829189	37.7415161934278	-122.46965666006399	(37.7415161934278, -122.469656660064)
81181	81181	112547	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	462 BROADWAY	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				3x3		6011324.0	2118723.0	37.798247331278	-122.404886391926	(37.798247331278, -122.404886391926)
82699	82699	89314	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	101 Scott St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/27/2005 12:00:00 AM		3x3	Permit Number 48328	6002340.0	2108819.0	37.7705471897255	-122.43526488371799	(37.7705471897255, -122.435264883718)
84367	84367	97195	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	390X Broadway	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/29/2015 12:00:00 AM	3		Permit Number 775228	6011720.2	2118742.9	37.7983241100995	-122.403516814582	(37.7983241100995, -122.403516814582)
87149	87149	87870	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	3236 Broderick St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/13/2008 12:00:00 AM		3x3	Permit Number 50837	5999889.0	2119639.0	37.8001166089052	-122.444520645891	(37.8001166089052, -122.444520645891)
89712	89712	47995	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	2594 15th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/28/2010 12:00:00 AM		3x3	Permit Number 53833	5991772.56459051	2097785.68925868	37.739646833729	-122.471013497633	(37.739646833729, -122.471013497633)
90622	90622	112528	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	459 BROADWAY	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				3x3		6011361.0	2118561.0	37.797804586609004	-122.40474694923401	(37.797804586609, -122.404746949234)
93181	93181	86997	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	248 Day St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/03/2007 12:00:00 AM		3x3	Permit Number 49939	6004323.0	2098701.0	37.742877960826604	-122.42768466378	(37.7428779608266, -122.42768466378)
96644	96644	40784	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	410 Monticello St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/16/1999 12:00:00 AM			Permit Number 41739	5991762.23808711	2091284.45671221	37.7217954779898	-122.470575817994	(37.7217954779898, -122.470575817994)
97182	97182	32	DPW Maintained 3	Rhamnus alaternus :: Italian Buckthorn 45	753 14th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/08/2016 06:10:00 AM	3	3X3		6003820.6216400005	2107707.01694	37.7675779249973	-122.43006406443999	(37.7675779249973, -122.43006406444)
97280	97280	94657	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	118 Baden St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/22/2010 12:00:00 AM	3	3x3	Permit Number 53795	6000765.0	2094410.0	37.7308939745429	-122.439679643784	(37.7308939745429, -122.439679643784)
97529	97529	42941	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	90 14TH ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/2000 12:00:00 AM	10		Permit Number 42835	6008035.0	2107992.0	37.768598204141995	-122.415507210488	(37.768598204142, -122.415507210488)
98066	98066	38216	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	350 Wayland St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/17/1998 12:00:00 AM			Permit Number 40338	6010576.45287423	2092372.10995681	37.7258519216371	-122.405616192564	(37.7258519216371, -122.405616192564)
99254	99254	38032	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	1400 Ulloa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/10/1998 12:00:00 AM			Permit Number 40236	5991713.73808693	2098444.67646581	37.7414528421268	-122.471264893104	(37.7414528421268, -122.471264893104)
100543	100543	38059	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	1802 Divisadero St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/10/1998 12:00:00 AM			Permit Number 40254	6001102.14351194	2114546.50782632	37.786203101297396	-122.439957367186	(37.7862031012974, -122.439957367186)
101774	101774	8103	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	775 Fulton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/14/1998 12:00:00 AM	8	3X3		6004110.63243	2111457.69852	37.7778928009026	-122.42932844351601	(37.7778928009026, -122.429328443516)
105407	105407	25463	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	308 Randolph St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM	3	3X3		5993157.11936	2088546.32287	37.714357782974204	-122.46555529463001	(37.7143577829742, -122.46555529463)
115313	115313	98671	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	1898@green Leavenworth St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6007784.7	2118870.1	37.7984527607502	-122.417143889347	(37.7984527607502, -122.417143889347)
115976	115976	112531	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	435 BROADWAY	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				3x3		6011430.0	2118629.0	37.79799515449189	-122.404512977901	(37.7979951544919, -122.404512977901)
116221	116221	41750	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	1100 California St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/19/2000 12:00:00 AM			Permit Number 42181	6009068.76416013	2116381.28511649	37.7916912386009	-122.41252459171899	(37.7916912386009, -122.412524591719)
116622	116622	214030	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	133 Baden St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 1ft		6000729.565880001	2094512.14983	37.7311724374522	-122.439809466051	(37.7311724374522, -122.439809466051)
119135	119135	48908	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	2200X Clay St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/22/2002 12:00:00 AM			Permit Number 46105	6004224.6625681	2116191.17070072	37.790896187279394	-122.42927158905898	(37.7908961872794, -122.429271589059)
120958	120958	25184	DPW Maintained 3	Rhamnus alaternus :: Italian Buckthorn 45	3448X Market St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/19/1996 12:00:00 AM	25	3X3		6000085.2661190005	2103906.7160847997	37.7569309776636	-122.442711229464	(37.7569309776636, -122.442711229464)
121149	121149	84942	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	1315 07th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/06/2007 12:00:00 AM			Permit Number 49348	5993891.7	2106504.6	37.7637090714706	-122.46431934241699	(37.7637090714706, -122.464319342417)
122443	122443	47699	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	297 Joost Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/22/2002 12:00:00 AM			Permit Number 45496	6000129.38189454	2094930.1458917998	37.732285975496104	-122.44191439219401	(37.7322859754961, -122.441914392194)
125240	125240	37977	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	1199 Tennessee St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/06/1998 12:00:00 AM			Permit Number 40204	6015599.59779117	2103398.4652457	37.756407638243296	-122.38902089785499	(37.7564076382433, -122.389020897855)
126873	126873	41661	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	1376 Clayton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/19/2000 12:00:00 AM	2		Permit Number 42129	5999046.52257313	2104716.21389633	37.7590943881005	-122.44636181286998	(37.7590943881005, -122.44636181287)
128753	128753	29219	DPW Maintained 3	Rhamnus alaternus :: Italian Buckthorn 45	1902X 41st Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		5983534.517682901	2102185.1808128003	37.7512467209802	-122.499821775189	(37.7512467209802, -122.499821775189)
129190	129190	94659	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	130 Baden St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/22/2010 12:00:00 AM	3	3x3	Permit Number 53796	6000765.0	2094447.0	37.73099556799129	-122.43968229537701	(37.7309955679913, -122.439682295377)
130150	130150	240411	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	235 Surrey St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 2ft		6001924.04211	2096180.04982	37.7358200267578	-122.435799247861	(37.7358200267578, -122.435799247861)
130254	130254	136325	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	464 Broadway	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6011322.0	2118712.0	37.7982170161506	-122.404892537684	(37.7982170161506, -122.404892537684)
130949	130949	181350	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	2270 25th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5988575.9018	2099879.6972	37.745211025577895	-122.48221942866999	(37.7452110255779, -122.48221942867)
131736	131736	112538	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	412 Broadway	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/10/2016 12:00:00 AM	2	3x3		6011488.50983	2118723.0183900003	37.7982565759239	-122.40431713692699	(37.7982565759239, -122.404317136927)
133530	133530	136299	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	21 Mallorca Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		6001939.11813	2119948.35287	37.8010827755037	-122.43744862338	(37.8010827755037, -122.43744862338)
135840	135840	117962	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	4340 Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 4ft		5985111.43248	2111810.6865	37.7777680685843	-122.495078411045	(37.7777680685843, -122.495078411045)
137058	137058	136304	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	1110 Jones St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6008621.3641800005	2116364.4323	37.791619846337	-122.414071405095	(37.791619846337, -122.414071405095)
137431	137431	35870	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	1 Boutwell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	04/24/1998 12:00:00 AM	3		Permit Number 39080	6010672.98165	2096855.55492	37.738167912917106	-122.405598135739	(37.7381679129171, -122.405598135739)
139989	139989	41876	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	66 Belcher St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/20/2000 12:00:00 AM			Permit Number 42253	6003778.26782897	2107952.91484982	37.768250702181504	-122.430228105724	(37.7682507021815, -122.430228105724)
140610	140610	112526	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	471 BROADWAY	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				3x3		6011292.0	2118586.0	37.7978693737352	-122.40498747086399	(37.7978693737352, -122.404987470864)
141514	141514	87935	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	3600 Quintara St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/18/2008 12:00:00 AM		3x3	Permit Number 50956	5982309.0	2100840.0	37.7474812377595	-122.503960055968	(37.7474812377595, -122.503960055968)
142202	142202	70387	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	81 Lyell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/27/1994 12:00:00 AM	4			6003118.96111	2094567.6101799998	37.7314604381496	-122.431552867694	(37.7314604381496, -122.431552867694)
142436	142436	32858	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	499 Hoffman Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/30/1996 12:00:00 AM			Permit Number 37207	6000703.6978076	2101134.48618072	37.7493543400616	-122.440373654783	(37.7493543400616, -122.440373654783)
143761	143761	93722	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	1434 Portola Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/24/2010 12:00:00 AM		3x3	Permit Number 53312	5992899.8	2097399.6	37.73865186152071	-122.467087971441	(37.7386518615207, -122.467087971441)
144874	144874	41728	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	99X 14th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/19/2000 12:00:00 AM			Permit Number 42172	6008031.27943269	2107943.20653569	37.7684640195804	-122.415516624702	(37.7684640195804, -122.415516624702)
145210	145210	41691	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	150 Conrad St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/19/2000 12:00:00 AM			Permit Number 42144	6001748.90360557	2096547.6107593998	37.7368193138397	-122.436431068172	(37.7368193138397, -122.436431068172)
146312	146312	50561	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	2365 O'Farrell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/13/2003 12:00:00 AM			Permit Number 47184	5998950.78977652	2112707.00584702	37.7810296062885	-122.44726801598401	(37.7810296062885, -122.447268015984)
148155	148155	136300	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	119 Locust St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5997500.209559999	2116012.95103	37.790023863549706	-122.45252491659402	(37.7900238635497, -122.452524916594)
149259	149259	181332	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	1458 24th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5988697.9248	2105396.3508	37.760365379214605	-122.482201591019	(37.7603653792146, -122.482201591019)
149302	149302	136316	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	895 Green St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		6009084.75499	2119036.14381	37.798981726274	-122.41265702602502	(37.798981726274, -122.412657026025)
153152	153152	141053	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	196 PARKER AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5996969.9558	2113061.6744	37.781890048327206	-122.45414629097999	(37.7818900483272, -122.45414629098)
155347	155347	179374	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	906 Madrid St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		6001350.07755	2088911.8778	37.71583065984	-122.437263408906	(37.71583065984, -122.437263408906)
156274	156274	40198	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	4845 Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	04/30/1999 12:00:00 AM	4		Permit Number 41381	5983564.00887	2111698.1064299997	37.7773682442298	-122.500423071675	(37.7773682442298, -122.500423071675)
156395	156395	136314	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	107 Bernard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 2ft		6008318.73536	2118064.92593	37.796271980829	-122.415238929252	(37.796271980829, -122.415238929252)
157585	157585	37646	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	1001 Balboa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/26/1998 12:00:00 AM	2		Permit Number 40060	5992418.62314	2111328.39102	37.7768688906569	-122.46976542425399	(37.7768688906569, -122.469765424254)
157777	157777	197340	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	696 Amador St	2	Front Yard : Yard 7	Tree 1	Private 1			18			6016813.36643	2099575.53369	37.745977867490204	-122.384556944272	(37.7459778674902, -122.384556944272)

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