Street_Tree_List

Data source: data.sfgov.org

651 rows where qLegalStatus = 1 and qSpecies = 60 sorted by XCoord

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: qSiteInfo

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord ▼	YCoord	Latitude	Longitude	Location
5515	5515	48743	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
6135	6135	48746	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
6959	6959	48747	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
7180	7180	48749	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
8095	8095	50823	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/19/2004 12:00:00 AM			Permit Number 47344
8773	8773	48750	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
8939	8939	48748	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
9025	9025	48744	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
10338	10338	30354	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/17/1956 12:00:00 AM			Permit Number 43
13566	13566	48742	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
14417	14417	48751	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
15637	15637	48745	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 46023
16857	16857	50824	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/19/2004 12:00:00 AM			Permit Number 47344
43129	43129	54833	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	601 43rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/10/1972 12:00:00 AM	18		Permit Number 10687	5982543.3158	2111642.14145	37.777154613505395	-122.50394977664	(37.7771546135054, -122.50394977664)
34129	34129	63191	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	480 38th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/18/1986 12:00:00 AM	14	4x9	Permit Number 23731	5984103.006630001	2112603.98729	37.7798871547077	-122.49862546555599	(37.7798871547077, -122.498625465556)
160351	160351	63201	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	434 36th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/18/1986 12:00:00 AM	17		Permit Number 23742	5984713.13689	2112937.02697	37.7808373486479	-122.496539369055	(37.7808373486479, -122.496539369055)
117813	117813	32306	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	840 El Camino Del Mar	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/19/1996 12:00:00 AM			Permit Number 36881	5985844.77778671	2115067.5891122	37.7867534900239	-122.49278149751001	(37.7867534900239, -122.49278149751)
143520	143520	32305	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	840 El Camino Del Mar	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/19/1996 12:00:00 AM			Permit Number 36881	5985844.77778671	2115067.5891122	37.7867534900239	-122.49278149751001	(37.7867534900239, -122.49278149751)
144054	144054	32304	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	840 El Camino Del Mar	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/19/1996 12:00:00 AM			Permit Number 36881	5985844.77778671	2115067.5891122	37.7867534900239	-122.49278149751001	(37.7867534900239, -122.49278149751)
124247	124247	88364	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	2559 33rd Ave		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/10/2008 12:00:00 AM		3x3	Permit Number 51343	5986101.6	2097823.5	37.739421027827	-122.490623769288	(37.739421027827, -122.490623769288)
122879	122879	100167	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	710 El Camino Del Mar	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5986405.6	2114870.0	37.7862437457696	-122.49082666767099	(37.7862437457696, -122.490826667671)
124558	124558	87671	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	450 El Camino Del Mar	1	Sidewalk: Property side : Cutout 5	Tree 1	Private 1		05/22/2008 12:00:00 AM		3x3	Permit Number 50395	5987244.0	2115292.0	37.787451378555396	-122.48795707816299	(37.7874513785554, -122.487957078163)
96580	96580	43346	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	5200 Fulton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/13/2000 12:00:00 AM			Permit Number 43101	5987278.98724374	2109843.31804433	37.772492884784896	-122.487435636536	(37.7724928847849, -122.487435636536)
106000	106000	43348	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	5200 Fulton St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/13/2000 12:00:00 AM			Permit Number 43101	5987278.98724374	2109843.31804433	37.772492884784896	-122.487435636536	(37.7724928847849, -122.487435636536)
142204	142204	43347	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	5200 Fulton St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/13/2000 12:00:00 AM			Permit Number 43101	5987278.98724374	2109843.31804433	37.772492884784896	-122.487435636536	(37.7724928847849, -122.487435636536)
173634	173634	68443	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1274 28th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/26/1993 12:00:00 AM	26	7.5x7.5	Permit Number 32300	5987418.73686806	2106612.65804585	37.7636305377833	-122.486714964872	(37.7636305377833, -122.486714964872)
124518	124518	65689	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	3601 Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/17/1990 12:00:00 AM	15	4x3	Permit Number 28615	5987420.04323	2111837.39532	37.7779762857803	-122.487094195586	(37.7779762857803, -122.487094195586)
182229	182229	106951	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	156 27th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/02/2014 12:00:00 AM	22	3x3	Permit Number 773389	5987431.57269	2114958.38797	37.7865463157209	-122.487283609867	(37.7865463157209, -122.487283609867)
144019	144019	30320	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	867 25th Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/13/1955 12:00:00 AM			Permit Number 14	5988182.28713273	2110079.61323567	37.773194323540004	-122.484328404455	(37.77319432354, -122.484328404455)
78069	78069	51559	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	29 West Clay St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 47854	5988768.43262818	2115023.56671426	37.7868031451511	-122.48266323691001	(37.7868031451511, -122.48266323691)
106768	106768	51557	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	29 West Clay St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/03/2005 12:00:00 AM			Permit Number 47854	5988768.43262818	2115023.56671426	37.7868031451511	-122.48266323691001	(37.7868031451511, -122.48266323691)
138295	138295	51558	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	29 West Clay St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/03/2005 12:00:00 AM			Permit Number 47854	5988768.43262818	2115023.56671426	37.7868031451511	-122.48266323691001	(37.7868031451511, -122.48266323691)
140018	140018	12815	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	2139 Lake St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			90	3X3		5988780.51636	2114651.15635	37.7857813149586	-122.48259413097601	(37.7857813149586, -122.482594130976)
102737	102737	12813	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	2122 Lake St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/24/2008 12:00:00 AM	3	5		5988829.5620099995	2114710.83275	37.785948022625206	-122.482428823022	(37.7859480226252, -122.482428823022)
178661	178661	43780	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	318 20th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/26/2000 12:00:00 AM	15		Permit Number 43410	5989670.6824	2113208.17204	37.7818710314531	-122.479408835232	(37.7818710314531, -122.479408835232)
40493	40493	53401	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	730 18th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/02/1969 12:00:00 AM	19		Permit Number 6300	5990392.09793	2110392.4951299997	37.774181835613206	-122.476707321825	(37.7741818356132, -122.476707321825)
144197	144197	121244	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	701 16th Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			27			5990956.24309491	2110611.72775368	37.7748164950302	-122.474771867875	(37.7748164950302, -122.474771867875)
156095	156095	54995	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	692 16th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/12/1972 12:00:00 AM	13		Permit Number 10873	5991003.861930001	2110730.86063	37.7751463606227	-122.47461584260799	(37.7751463606227, -122.474615842608)
32763	32763	68295	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	25 15th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/27/1993 12:00:00 AM	17		Permit Number 32104	5991131.604780001	2114879.69838	37.7865453253482	-122.47447679418	(37.7865453253482, -122.47447679418)
103696	103696	58220	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	40 Winston Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/27/1978 12:00:00 AM	32	3x80	Permit Number 17215	5991168.576701799	2093158.16680643	37.726905874360796	-122.472764483204	(37.7269058743608, -122.472764483204)
86430	86430	11785	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1199X Junipero Serra Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			30	3x3		5991174.554565701	2089606.7568954	37.7171549272284	-122.472485017828	(37.7171549272284, -122.472485017828)
96556	96556	24460	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1199X Junipero Serra Blvd	9	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		06/22/1995 12:00:00 AM	6	3x3		5991174.554565701	2089606.7568954	37.7171549272284	-122.472485017828	(37.7171549272284, -122.472485017828)
110250	110250	24414	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1199X Junipero Serra Blvd	17	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		06/23/1995 12:00:00 AM	12	3x3		5991174.554565701	2089606.7568954	37.7171549272284	-122.472485017828	(37.7171549272284, -122.472485017828)
125704	125704	11772	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1199X Junipero Serra Blvd	16	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		06/23/1995 12:00:00 AM	12	3x3		5991174.554565701	2089606.7568954	37.7171549272284	-122.472485017828	(37.7171549272284, -122.472485017828)
127942	127942	24412	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1199X Junipero Serra Blvd	15	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		06/23/1995 12:00:00 AM	12	3x3		5991174.554565701	2089606.7568954	37.7171549272284	-122.472485017828	(37.7171549272284, -122.472485017828)
142712	142712	11790	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1199X Junipero Serra Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			24	3x4		5991174.554565701	2089606.7568954	37.7171549272284	-122.472485017828	(37.7171549272284, -122.472485017828)
145860	145860	24413	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1199X Junipero Serra Blvd	13	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		06/22/1995 12:00:00 AM	6	3x3		5991174.554565701	2089606.7568954	37.7171549272284	-122.472485017828	(37.7171549272284, -122.472485017828)
40997	40997	68216	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	371 15th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/27/1993 12:00:00 AM	13	4x4	Permit Number 32003	5991199.85508	2112923.89297	37.781179180083704	-122.474097911754	(37.7811791800837, -122.474097911754)
107083	107083	30837	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	549 15th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/06/1995 12:00:00 AM			Permit Number 34686	5991243.131678	2111669.17977704	37.7777365894405	-122.473856633134	(37.7777365894405, -122.473856633134)
81627	81627	11762	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	999X Junipero Serra Blvd	6	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			24	3X3		5991260.9047733005	2090529.2081036	37.719692749400394	-122.47225375374799	(37.7196927494004, -122.472253753748)
103241	103241	11760	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	999X Junipero Serra Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			24	3x3		5991260.9047733005	2090529.2081036	37.719692749400394	-122.47225375374799	(37.7196927494004, -122.472253753748)
117787	117787	24405	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	999X Junipero Serra Blvd	10	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		01/28/2000 12:00:00 AM	12	3X3		5991260.9047733005	2090529.2081036	37.719692749400394	-122.47225375374799	(37.7196927494004, -122.472253753748)
123921	123921	24406	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	999X Junipero Serra Blvd	11	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		01/28/2000 12:00:00 AM	6	3x3		5991260.9047733005	2090529.2081036	37.719692749400394	-122.47225375374799	(37.7196927494004, -122.472253753748)
125742	125742	24458	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	999X Junipero Serra Blvd	14	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		03/17/2001 12:00:00 AM	6	3X3		5991260.9047733005	2090529.2081036	37.719692749400394	-122.47225375374799	(37.7196927494004, -122.472253753748)
19844	19844	27797	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	899X Junipero Serra Blvd	3	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		03/17/2001 12:00:00 AM	3	3		5991288.7107407	2091242.502063	37.7216528879997	-122.47220960661998	(37.7216528879997, -122.47220960662)
32415	32415	11719	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	899X Junipero Serra Blvd	9	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			30	3		5991288.7107407	2091242.502063	37.7216528879997	-122.47220960661998	(37.7216528879997, -122.47220960662)
83233	83233	28848	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	899X Junipero Serra Blvd	15	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		03/08/2005 12:00:00 AM	3	3X3		5991288.7107407	2091242.502063	37.7216528879997	-122.47220960661998	(37.7216528879997, -122.47220960662)
89108	89108	27799	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	899X Junipero Serra Blvd	23	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		03/08/2005 12:00:00 AM	3	3		5991288.7107407	2091242.502063	37.7216528879997	-122.47220960661998	(37.7216528879997, -122.47220960662)
90084	90084	24402	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	899X Junipero Serra Blvd	17	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		03/01/2000 12:00:00 AM	6	3X3		5991288.7107407	2091242.502063	37.7216528879997	-122.47220960661998	(37.7216528879997, -122.47220960662)
92392	92392	24401	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	899X Junipero Serra Blvd	16	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		03/17/2001 12:00:00 AM	12	3X3		5991288.7107407	2091242.502063	37.7216528879997	-122.47220960661998	(37.7216528879997, -122.47220960662)
105606	105606	11715	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	899X Junipero Serra Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		06/15/1995 12:00:00 AM	12	3X3		5991288.7107407	2091242.502063	37.7216528879997	-122.47220960661998	(37.7216528879997, -122.47220960662)
124190	124190	11727	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	899X Junipero Serra Blvd	22	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		06/15/1995 12:00:00 AM	12	3X3		5991288.7107407	2091242.502063	37.7216528879997	-122.47220960661998	(37.7216528879997, -122.47220960662)
127364	127364	11720	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	899X Junipero Serra Blvd	11	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			24	3		5991288.7107407	2091242.502063	37.7216528879997	-122.47220960661998	(37.7216528879997, -122.47220960662)
143977	143977	11717	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	899X Junipero Serra Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		03/08/2005 12:00:00 AM	3	3		5991288.7107407	2091242.502063	37.7216528879997	-122.47220960661998	(37.7216528879997, -122.47220960662)
144393	144393	11724	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	899X Junipero Serra Blvd	18	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		03/17/2001 12:00:00 AM	12	3		5991288.7107407	2091242.502063	37.7216528879997	-122.47220960661998	(37.7216528879997, -122.47220960662)
81957	81957	87701	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	799X Junipero Serra Blvd	27	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			8	3x3		5991351.334229	2092039.32129	37.7238443805247	-122.472051185335	(37.7238443805247, -122.472051185335)
80752	80752	24398	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	799X Junipero Serra Blvd	30	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		03/01/2000 12:00:00 AM	12	3		5991356.324435	2092039.0089713002	37.7238438117461	-122.472033912425	(37.7238438117461, -122.472033912425)
84989	84989	24399	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	799X Junipero Serra Blvd	13	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		06/15/1995 12:00:00 AM	12	3		5991356.324435	2092039.0089713002	37.7238438117461	-122.472033912425	(37.7238438117461, -122.472033912425)
86583	86583	11688	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	799X Junipero Serra Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			36	3x3		5991356.324435	2092039.0089713002	37.7238438117461	-122.472033912425	(37.7238438117461, -122.472033912425)
88676	88676	11697	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	799X Junipero Serra Blvd	21	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		06/21/1995 12:00:00 AM	6	3x3		5991356.324435	2092039.0089713002	37.7238438117461	-122.472033912425	(37.7238438117461, -122.472033912425)
91670	91670	11699	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	799X Junipero Serra Blvd	24	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			30	3		5991356.324435	2092039.0089713002	37.7238438117461	-122.472033912425	(37.7238438117461, -122.472033912425)
105506	105506	11693	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	799X Junipero Serra Blvd	10	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			30	3		5991356.324435	2092039.0089713002	37.7238438117461	-122.472033912425	(37.7238438117461, -122.472033912425)
108860	108860	24456	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	799X Junipero Serra Blvd	31	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		06/22/1995 12:00:00 AM	12	3		5991356.324435	2092039.0089713002	37.7238438117461	-122.472033912425	(37.7238438117461, -122.472033912425)
109450	109450	24400	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	799X Junipero Serra Blvd	22	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		06/15/1995 12:00:00 AM	6	3x3		5991356.324435	2092039.0089713002	37.7238438117461	-122.472033912425	(37.7238438117461, -122.472033912425)
117628	117628	27826	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	799X Junipero Serra Blvd	26	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		03/08/2005 12:00:00 AM	3	3		5991356.324435	2092039.0089713002	37.7238438117461	-122.472033912425	(37.7238438117461, -122.472033912425)
122590	122590	11691	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	799X Junipero Serra Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		03/17/2001 12:00:00 AM	9	3x3		5991356.324435	2092039.0089713002	37.7238438117461	-122.472033912425	(37.7238438117461, -122.472033912425)
144673	144673	26172	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	799X Junipero Serra Blvd	17	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			12	3x3		5991356.324435	2092039.0089713002	37.7238438117461	-122.472033912425	(37.7238438117461, -122.472033912425)
27174	27174	24392	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	699X Junipero Serra Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		06/21/1995 12:00:00 AM	12	3		5991405.981861901	2093130.1790735	37.7268427672434	-122.47194174766199	(37.7268427672434, -122.471941747662)
78605	78605	11658	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	699X Junipero Serra Blvd	19	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			24	3		5991405.981861901	2093130.1790735	37.7268427672434	-122.47194174766199	(37.7268427672434, -122.471941747662)
86056	86056	11659	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	699X Junipero Serra Blvd	20	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			12	3		5991405.981861901	2093130.1790735	37.7268427672434	-122.47194174766199	(37.7268427672434, -122.471941747662)
93707	93707	11654	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	699X Junipero Serra Blvd	13	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			30	3		5991405.981861901	2093130.1790735	37.7268427672434	-122.47194174766199	(37.7268427672434, -122.471941747662)
95471	95471	24391	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	699X Junipero Serra Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		06/21/1995 12:00:00 AM	12	3		5991405.981861901	2093130.1790735	37.7268427672434	-122.47194174766199	(37.7268427672434, -122.471941747662)
109059	109059	11648	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	699X Junipero Serra Blvd	3	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		01/28/2000 12:00:00 AM	3	3		5991405.981861901	2093130.1790735	37.7268427672434	-122.47194174766199	(37.7268427672434, -122.471941747662)
115573	115573	24395	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	699X Junipero Serra Blvd	21	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		06/22/1995 12:00:00 AM	6	3		5991405.981861901	2093130.1790735	37.7268427672434	-122.47194174766199	(37.7268427672434, -122.471941747662)
141005	141005	11653	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	699X Junipero Serra Blvd	10	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			18	3		5991405.981861901	2093130.1790735	37.7268427672434	-122.47194174766199	(37.7268427672434, -122.471941747662)
18608	18608	24390	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	501X Junipero Serra Blvd	6	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13		06/22/1995 12:00:00 AM	6	3		5991485.44871	2094112.7680400002	37.7295453093597	-122.471738611958	(37.7295453093597, -122.471738611958)
79986	79986	49370	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	470 REVISED West Portal Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/19/2003 12:00:00 AM			Permit Number 46343	5991620.22800025	2096213.28684732	37.735320603541204	-122.471425664133	(37.7353206035412, -122.471425664133)
38847	38847	51264	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	791 14th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/18/2004 12:00:00 AM	11		Permit Number 47641	5991632.45779	2110058.1497	37.773335681454896	-122.472392358685	(37.7733356814549, -122.472392358685)
60605	60605	51265	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	791 14th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/18/2004 12:00:00 AM	14		Permit Number 47641	5991632.71365	2110039.2533299997	37.7732838119525	-122.472390095818	(37.7732838119525, -122.472390095818)
78551	78551	38221	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	140 Chester Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/21/1998 12:00:00 AM			Permit Number 40348	5991708.17687703	2088279.9583595002	37.7135427330302	-122.470543976889	(37.7135427330302, -122.470543976889)
124902	124902	12672	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1132 Lake St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			90	3X4		5991897.52815	2114823.03375	37.786434086563	-122.47182278185	(37.786434086563, -122.47182278185)
79926	79926	112059	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	770 Funston Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		36	5x6		5991981.6527	2110175.44232	37.7736779395689	-122.471193003562	(37.7736779395689, -122.471193003562)
73663	73663	58676	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1125 Balboa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/23/1980 12:00:00 AM	19	6x9	Permit Number 18377	5992080.86263	2111323.72356	37.7768365466492	-122.470933489274	(37.7768365466492, -122.470933489274)
93744	93744	12660	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1045 Lake St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			30	4X4		5992154.39933	2114773.56456	37.7863131171963	-122.470930475416	(37.7863131171963, -122.470930475416)
9805	9805	57857	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	491 12th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/07/1984 12:00:00 AM	15		Permit Number 779316	5992173.1495199995	2112167.2990599996	37.7791581122705	-122.47067570242599	(37.7791581122705, -122.470675702426)
9140	9140	12661	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1045 Lake St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			100	4X4		5992178.70595	2114775.57253	37.786320036254004	-122.47084652786002	(37.786320036254, -122.47084652786)
105533	105533	12657	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1030 Lake St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			80	3X3		5992237.14862	2114834.7776	37.786485976689704	-122.470648646947	(37.7864859766897, -122.470648646947)
17040	17040	12655	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1016 Lake St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			36	6x21		5992294.67406	2114836.34542	37.7864936077921	-122.47044973930201	(37.7864936077921, -122.470449739302)
99863	99863	48654	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	601 Moraga St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/30/2002 12:00:00 AM			Permit Number 45947	5992474.12537509	2103859.88961246	37.7563655794475	-122.469029766101	(37.7563655794475, -122.469029766101)
139549	139549	55340	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1570 12th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/26/1972 12:00:00 AM			Permit Number 769406	5992478.56101588	2104770.1953725	37.758865297372104	-122.46908067431299	(37.7588652973721, -122.469080674313)

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