Street_Tree_List

Data source: data.sfgov.org

122 rows where SiteOrder = 2 and qSpecies = 45 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, qSiteInfo, qCaretaker, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location ▼
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
174549	174549	179376	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	11 Cross St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6000146.4091300005	2088205.43619	37.7138224314379	-122.441373172128	(37.7138224314379, -122.441373172128)
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)
188758	188758	217581	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	500 Randolph St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5992611.7697	2088555.8456	37.714352460703104	-122.467440914144	(37.7143524607031, -122.467440914144)
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)
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)
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)
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)
173397	173397	179371	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	479 Goettingen St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6010448.30169	2092366.9553099999	37.7258306011814	-122.40605884135401	(37.7258306011814, -122.406058841354)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
169762	169762	240386	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	310 Gates St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6008247.18934	2097121.53396	37.738762289236895	-122.41400415558998	(37.7387622892369, -122.41400415559)
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)
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)
182568	182568	33177	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	3245 Ulloa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/05/1996 12:00:00 AM	4	3.5x5	Permit Number 37389	5985988.52360796	2098193.06286983	37.740429143118206	-122.491041921171	(37.7404291431182, -122.491041921171)
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)
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)
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)
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)
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)
187182	187182	247984	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	497 Peralta Ave	2	Side Yard : Yard 17	Tree 1	Private 1			5			6009751.76686	2099644.8640900003	37.745775193576705	-122.408980002136	(37.7457751935767, -122.408980002136)
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)
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)
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)
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)
173420	173420	184400	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	2087 45th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5982288.7103	2100911.824	37.747677253327	-122.504035534429	(37.747677253327, -122.504035534429)
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)
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)
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)
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)
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)
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)
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)
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)
158949	158949	197336	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	651 Missouri St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18			6013643.57223	2103811.4939599996	37.757433106182	-122.39581450923201	(37.757433106182, -122.395814509232)
169430	169430	42275	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	1522 29th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/23/2000 12:00:00 AM	4		Permit Number 42512	5987167.45157267	2104900.21174724	37.7589139779601	-122.48745827105	(37.7589139779601, -122.48745827105)
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)
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)
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)
159224	159224	38871	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	1551 Judah St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/02/1998 12:00:00 AM	2		Permit Number 40696	5989746.74182688	2105808.42580632	37.7615577752966	-122.47860439661501	(37.7615577752966, -122.478604396615)
166292	166292	43230	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	1371 20th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/12/2000 12:00:00 AM	3		Permit Number 43018	5989871.41437878	2106041.52738456	37.7622050471688	-122.47819025383801	(37.7622050471688, -122.478190253838)
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)
185994	185994	181319	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	1283 22nd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5989233.7879	2106609.7025	37.7637280687606	-122.48043712751101	(37.7637280687606, -122.480437127511)
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)
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)
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)
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)
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)
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)
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)
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)
174144	174144	240381	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	98 14th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6008070.808569999	2107998.41684	37.7686178359612	-122.415383805538	(37.7686178359612, -122.415383805538)
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)
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)
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)
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)
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)
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)
157856	157856	197349	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	776 Tehama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 2ft		6008993.795609999	2110246.5783	37.7748425951336	-122.412350180929	(37.7748425951336, -122.412350180929)
173280	173280	117792	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	3801 Balboa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5983744.15991	2111021.91382	37.775522188312394	-122.499749889479	(37.7755221883124, -122.499749889479)
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)
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)
174499	174499	48458	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	520 06th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/05/2002 12:00:00 AM	3		Permit Number 45824	6011932.18219	2110480.19141	37.7756484947135	-122.402202056493	(37.7756484947135, -122.402202056493)
169354	169354	117837	DPW Maintained 3	Rhamnus alaternus :: Italian Buckthorn 45	660x 39th Ave	2	Median : Cutout 11	Tree 1	DPW 2			7	Width 6ft		5983820.01458	2111273.2343900003	37.776216692790705	-122.49950607144899	(37.7762166927907, -122.499506071449)
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)
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)
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)
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)
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)
175872	175872	78389	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	4200 Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/22/2000 12:00:00 AM	8			5985613.90998	2111830.68363	37.77785237866	-122.49334166667101	(37.77785237866, -122.493341666671)
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)
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)
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)
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)
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)
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)
176461	176461	103083	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	670 Howard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	3x3		6012579.2635	2114003.58062	37.785359006363	-122.40021114274599	(37.785359006363, -122.400211142746)
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)
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)
171286	171286	48668	Permitted Site 1	Rhamnus alaternus :: Italian Buckthorn 45	3362 Clay St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/04/2002 12:00:00 AM	2		Permit Number 45951	5998735.75428	2115612.17598	37.788994153303	-122.44822118308201	(37.788994153303, -122.448221183082)
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)
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)
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)

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