Street_Tree_List

Data source: data.sfgov.org

248 rows where qSiteInfo = 11 and qSpecies = 60 sorted by qLegalStatus

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, qCaretaker, PlantDate, PlotSize, PermitNotes

Link	rowid	TreeID	qLegalStatus ▼	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
83274	83274	99496	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X Plymouth Ave	3	Median : Cutout 11	Tree 1	Private 1						5995903.0	2093347.3	37.7276981218086	-122.45641145576	(37.7276981218086, -122.45641145576)
86969	86969	99459	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	550X Miramar Ave	5	Median : Cutout 11	Tree 1	Private 1		10/28/2014 12:00:00 AM	3	15x280	Permit Number 772553	5995413.0	2092983.7	37.7266716211667	-122.45807907885799	(37.7266716211667, -122.458079078858)
87404	87404	99494	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X Plymouth Ave	1	Median : Cutout 11	Tree 1	Private 1						5995903.0	2093347.3	37.7276981218086	-122.45641145576	(37.7276981218086, -122.45641145576)
99750	99750	92208	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	300x Miramar Ave	2	Median : Cutout 11	Tree 1	Private 1		07/16/2009 12:00:00 AM		2x2	Permit Number 52642	5995384.3	2092126.4	37.724316032008204	-122.45811627477501	(37.7243160320082, -122.458116274775)
100862	100862	99476	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	650X Miramar Ave	2	Median : Cutout 11	Tree 1	Private 1		10/28/2014 12:00:00 AM	3	15x280	Permit Number 772553	5995425.4	2093662.3	37.728535605791	-122.45808530293199	(37.728535605791, -122.458085302932)
112226	112226	92209	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	300x Miramar Ave	3	Median : Cutout 11	Tree 1	Private 1		07/16/2009 12:00:00 AM		2x2	Permit Number 52642	5995384.3	2092126.4	37.724316032008204	-122.45811627477501	(37.7243160320082, -122.458116274775)
122780	122780	99495	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1400X Plymouth Ave	2	Median : Cutout 11	Tree 1	Private 1						5995903.0	2093347.3	37.7276981218086	-122.45641145576	(37.7276981218086, -122.45641145576)
128765	128765	99475	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	650X Miramar Ave	1	Median : Cutout 11	Tree 1	Private 1		04/18/2014 12:00:00 AM	44	15x280	Permit Number 772553	5995425.4	2093662.3	37.728535605791	-122.45808530293199	(37.728535605791, -122.458085302932)
139081	139081	92211	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	300x Miramar Ave	5	Median : Cutout 11	Tree 1	Private 1		12/29/2010 12:00:00 AM		2x2	Permit Number 54064	5995384.3	2092126.4	37.724316032008204	-122.45811627477501	(37.7243160320082, -122.458116274775)
20071	20071	99485	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	700X Miramar Ave	6	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995446.3	2094052.9	37.7296092999141	-122.458041307204	(37.7296092999141, -122.458041307204)
78281	78281	111082	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	130 JUNIPERO SERRA BLVD	1	Median : Cutout 11	Tree 1	Private 1				3x3		5991393.0	2095322.0	37.7328602072681	-122.472146321186	(37.7328602072681, -122.472146321186)
82410	82410	99464	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	550X Miramar Ave	9	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995413.0	2092983.7	37.7266716211667	-122.45807907885799	(37.7266716211667, -122.458079078858)
89076	89076	97486	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500X Miramar Ave	2	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995423.2	2092691.6	37.7258701708071	-122.45802268806801	(37.7258701708071, -122.458022688068)
90742	90742	99463	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	550X Miramar Ave	6	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995413.0	2092983.7	37.7266716211667	-122.45807907885799	(37.7266716211667, -122.458079078858)
91074	91074	99452	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	400X Miramar Ave	2	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995388.7	2092398.7	37.7250639553871	-122.45812076272101	(37.7250639553871, -122.458120762721)
94507	94507	99469	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600X Miramar Ave	6	Median : Cutout 11	Tree 1	Private 1			4	15x280		5995435.2	2093399.0	37.727813210556704	-122.458032376835	(37.7278132105567, -122.458032376835)
97066	97066	99466	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600X Miramar Ave	1	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995435.2	2093399.0	37.727813210556704	-122.458032376835	(37.7278132105567, -122.458032376835)
101136	101136	99470	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600X Miramar Ave	8	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995435.2	2093399.0	37.727813210556704	-122.458032376835	(37.7278132105567, -122.458032376835)
102939	102939	99481	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	650X Miramar Ave	3	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995425.4	2093662.3	37.728535605791	-122.45808530293199	(37.728535605791, -122.458085302932)
106153	106153	99462	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	550X Miramar Ave	2	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995413.0	2092983.7	37.7266716211667	-122.45807907885799	(37.7266716211667, -122.458079078858)
111872	111872	97492	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500X Miramar Ave	8	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995423.2	2092691.6	37.7258701708071	-122.45802268806801	(37.7258701708071, -122.458022688068)
117015	117015	97487	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500X Miramar Ave	3	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995423.2	2092691.6	37.7258701708071	-122.45802268806801	(37.7258701708071, -122.458022688068)
118496	118496	99484	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	700X Miramar Ave	5	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995446.3	2094052.9	37.7296092999141	-122.458041307204	(37.7296092999141, -122.458041307204)
119791	119791	99453	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	400X Miramar Ave	3	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995388.7	2092398.7	37.7250639553871	-122.45812076272101	(37.7250639553871, -122.458120762721)
123808	123808	99468	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600X Miramar Ave	4	Median : Cutout 11	Tree 1	Private 1			6	15x280		5995435.2	2093399.0	37.727813210556704	-122.458032376835	(37.7278132105567, -122.458032376835)
126415	126415	99483	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	700X Miramar Ave	2	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995446.3	2094052.9	37.7296092999141	-122.458041307204	(37.7296092999141, -122.458041307204)
127626	127626	97493	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500X Miramar Ave	9	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995423.2	2092691.6	37.7258701708071	-122.45802268806801	(37.7258701708071, -122.458022688068)
128399	128399	99493	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	800X Miramar Ave	3	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995450.2	2094280.5	37.7302344585425	-122.458044289565	(37.7302344585425, -122.458044289565)
139244	139244	99492	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	800X Miramar Ave	2	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995450.2	2094280.5	37.7302344585425	-122.458044289565	(37.7302344585425, -122.458044289565)
141106	141106	99467	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600X Miramar Ave	3	Median : Cutout 11	Tree 1	Private 1			6	15x280		5995435.2	2093399.0	37.727813210556704	-122.458032376835	(37.7278132105567, -122.458032376835)
2620	2620	23170	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	202X Van Ness Ave	2	Median : Cutout 11	Tree 1	DPW 2			30	9		6006871.78386	2111296.65749	37.7776065535391	-122.41976520271601	(37.7776065535391, -122.419765202716)
5451	5451	23407	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1748X Van Ness Ave	3	Median : Cutout 11	Tree 1	DPW 2			30	9		6006159.63822	2116414.10982	37.791617675355795	-122.422592496742	(37.7916176753558, -122.422592496742)
7149	7149	23486	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2500X Van Ness Ave	1	Median : Cutout 11	Tree 1	DPW 2			30	9		6005800.3407	2119014.80575	37.7987382537111	-122.424020688524	(37.7987382537111, -122.424020688524)
7447	7447	23391	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1500X Van Ness Ave	4	Median : Cutout 11	Tree 1	DPW 2		06/09/2005 12:00:00 AM	6	9		6006253.0985199995	2115767.98121	37.789848839288	-122.422223199151	(37.789848839288, -122.422223199151)
7904	7904	23169	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	202X Van Ness Ave	1	Median : Cutout 11	Tree 1	DPW 2			30	9		6006882.10264	2111252.84384	37.777486833097896	-122.419726396954	(37.7774868330979, -122.419726396954)
8048	8048	23233	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	700X Van Ness Ave	3	Median : Cutout 11	Tree 1	DPW 2			30	9		6006624.19189	2113053.59601	37.782416729491	-122.42074646829799	(37.782416729491, -122.420746468298)
8553	8553	23232	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	700X Van Ness Ave	2	Median : Cutout 11	Tree 1	DPW 2			30	9		6006628.60579	2113016.72655	37.7823157437221	-122.42072857987301	(37.7823157437221, -122.420728579873)
8649	8649	23408	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1748X Van Ness Ave	4	Median : Cutout 11	Tree 1	DPW 2			30	9		6006154.759930001	2116452.2699700003	37.7917221783851	-122.42261208848801	(37.7917221783851, -122.422612088488)
9682	9682	13402	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300 Marietta Dr	4	Median : Cutout 11	Tree 1	DPW 2			0	5x10		5999116.0	2097588.0	37.7395260150228	-122.445608931545	(37.7395260150228, -122.445608931545)
9685	9685	111779	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	356 Marietta Dr	4	Median : Cutout 11	Tree 1	DPW 2				5		5999368.0	2097504.0	37.7393097549515	-122.44473159198601	(37.7393097549515, -122.444731591986)
10926	10926	15989	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	236 Moncada Way	2	Median : Cutout 11	Tree 1	DPW 2			24	35M		5992398.75579	2093455.53191	37.7277935021904	-122.468533444909	(37.7277935021904, -122.468533444909)
13311	13311	29591	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	18	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991298.8544	2091955.25413	37.7236105159064	-122.47222647259899	(37.7236105159064, -122.472226472599)
16230	16230	11782	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	14	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	6X6		5991290.0959	2091855.3897900002	37.7233358062868	-122.472249472731	(37.7233358062868, -122.472249472731)
17111	17111	29966	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Junipero Serra Blvd	10	Median : Cutout 11	Tree 1	DPW 2		04/01/2007 12:00:00 AM	3	3x3		5991400.88182	2093544.5626	37.7279802659702	-122.471989567778	(37.7279802659702, -122.471989567778)
17196	17196	11780	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	12	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991289.71415	2091805.7046599998	37.7231993611319	-122.47224717228599	(37.7231993611319, -122.472247172286)
17538	17538	30052	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	20	Median : Cutout 11	Tree 1	DPW 2			3	3X3		5991303.9336	2092006.82804	37.723752419029005	-122.4722126725	(37.723752419029, -122.4722126725)
17711	17711	29585	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500X Junipero Serra Blvd	7	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991398.016530001	2093471.7437599998	37.7277801578055	-122.47199416782101	(37.7277801578055, -122.471994167821)
17715	17715	16378	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000X Moraga St	1	Median : Cutout 11	Tree 1	DPW 2			18	12		5991088.16435	2103840.65792	37.756232597572605	-122.473821451692	(37.7562325975726, -122.473821451692)
17761	17761	11776	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	8	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	6X6		5991282.42505	2091712.4343599998	37.7229428421321	-122.47226557329701	(37.7229428421321, -122.472265573297)
17868	17868	11672	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	710X Junipero Serra Blvd	9	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	6X6		5991310.6193982	2092985.7524279999	37.7264406890913	-122.472260886614	(37.7264406890913, -122.472260886614)
17935	17935	29599	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	900X Junipero Serra Blvd	8	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991176.65606	2091094.6598	37.7212404641514	-122.472586172621	(37.7212404641514, -122.472586172621)
17949	17949	11779	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	11	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991286.49524	2091779.26927	37.723126589806704	-122.47225637323	(37.7231265898067, -122.47225637323)
18437	18437	11778	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	10	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	6X6		5991284.6486	2091754.7927400002	37.723059276443294	-122.472260973265	(37.7230592764433, -122.472260973265)
18870	18870	16690	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	950X Noriega St	1	Median : Cutout 11	Tree 1	DPW 2		11/07/2014 11:22:00 AM	3	8		5991053.49575	2103158.03284	37.7543562808184	-122.473891546652	(37.7543562808184, -122.473891546652)
18901	18901	29590	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	17	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991297.67299	2091930.7639	37.723543203431504	-122.47222877213301	(37.7235432034315, -122.472228772133)
18990	18990	16587	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	7X Noe St	1	Median : Cutout 11	Tree 1	DPW 2			12	3X3		6002822.0682	2108265.0608599996	37.7690535728051	-122.433557813564	(37.7690535728051, -122.433557813564)
19341	19341	11783	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	15	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991294.00766	2091883.13578	37.7234122162896	-122.472237972213	(37.7234122162896, -122.472237972213)
19957	19957	13396	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			30	5		5999058.18381	2097687.6567700002	37.7397963477092	-122.44581599931999	(37.7397963477092, -122.44581599932)
19985	19985	29967	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500X Junipero Serra Blvd	11	Median : Cutout 11	Tree 1	DPW 2		04/01/2007 12:00:00 AM	3	3x3		5991402.13289	2093572.36272	37.7280566705545	-122.471987268219	(37.7280566705545, -122.471987268219)
20180	20180	11683	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	700X Junipero Serra Blvd	15	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	6X6		5991304.64081	2092852.6411099997	37.7260748525524	-122.47227185508301	(37.7260748525524, -122.472271855083)
20236	20236	29626	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	900X Junipero Serra Blvd	35	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991174.60245	2090776.1353200001	37.720365755664794	-122.47257006037901	(37.7203657556648, -122.472570060379)
20304	20304	29965	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500X Junipero Serra Blvd	9	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	20	3x3		5991402.31851	2093518.0307	37.727907499130204	-122.471982668166	(37.7279074991302, -122.471982668166)
20444	20444	29975	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500X Junipero Serra Blvd	20	Median : Cutout 11	Tree 1	DPW 2		04/01/2007 12:00:00 AM	3	3x3		5991414.71879	2093790.73319	37.72865698961311	-122.471959668	(37.7286569896131, -122.471959668)
20515	20515	29969	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500X Junipero Serra Blvd	13	Median : Cutout 11	Tree 1	DPW 2		04/01/2007 12:00:00 AM	3	3x3		5991404.41199	2093617.36709	37.728180373200495	-122.471982668172	(37.7281803732005, -122.471982668172)
20900	20900	11781	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	13	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991290.20273	2091828.8846200001	37.7232630358375	-122.472247172271	(37.7232630358375, -122.472247172271)
21009	21009	11768	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	6	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	6X6		5991277.20617	2091654.2371	37.7227827448208	-122.472279373401	(37.7227827448208, -122.472279373401)
21040	21040	16351	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1500X Monterey Blvd	1	Median : Cutout 11	Tree 1	DPW 2			3	4-HOA		5993490.85605	2095190.6948799998	37.7326208567505	-122.464884023402	(37.7326208567505, -122.464884023402)
21262	21262	11775	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	7	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991281.15985	2091683.9699900001	37.722864612795	-122.47226787285801	(37.722864612795, -122.472267872858)
21308	21308	16353	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1500X Monterey Blvd	3	Median : Cutout 11	Tree 1	DPW 2			18	4-HOA		5993459.40286	2095225.9506299999	37.7327158467563	-122.464995323497	(37.7327158467563, -122.464995323497)
21730	21730	16356	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1500X Monterey Blvd	6	Median : Cutout 11	Tree 1	DPW 2			30	4-HOA		5993377.89298	2095299.30224	37.7329125518562	-122.46528244733	(37.7329125518562, -122.46528244733)
21780	21780	16352	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1500X Monterey Blvd	2	Median : Cutout 11	Tree 1	DPW 2			18	4-HOA		5993475.48003	2095210.28877	37.7326737701714	-122.46493860413099	(37.7326737701714, -122.464938604131)
21807	21807	16355	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1500X Monterey Blvd	5	Median : Cutout 11	Tree 1	DPW 2			18	4-HOA		5993419.93647	2095261.019	37.732809860079996	-122.46513431370501	(37.73280986008, -122.465134313705)
21945	21945	16357	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1500X Monterey Blvd	7	Median : Cutout 11	Tree 1	DPW 2			30	4-HOA		5993334.84717	2095340.24029	37.7330224750874	-122.465434239406	(37.7330224750874, -122.465434239406)
22027	22027	29592	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	19	Median : Cutout 11	Tree 1	DPW 2			12	3X3		5991300.07797	2091981.73158	37.723683287234	-122.472224172111	(37.723683287234, -122.472224172111)
22120	22120	11777	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Junipero Serra Blvd	9	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991284.187940001	2091732.93739	37.7229992404026	-122.472260973267	(37.7229992404026, -122.472260973267)
22280	22280	16692	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	950X Noriega St	3	Median : Cutout 11	Tree 1	DPW 2		02/25/2016 08:08:00 AM	3	8		5990985.786309999	2103156.72144	37.7543487579916	-122.474125605135	(37.7543487579916, -122.474125605135)
22414	22414	9013	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5317 Geary Blvd	2	Median : Cutout 11	Tree 1	DPW 2		03/12/2011 12:00:00 AM	2	8M		5990485.6581	2112681.4706	37.7804721580667	-122.47655093756501	(37.7804721580667, -122.476550937565)
22482	22482	9050	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5500 Geary Blvd	4	Median : Cutout 11	Tree 1	DPW 2			3	8M		5989756.3032	2112653.5115	37.7803530611008	-122.47907204579799	(37.7803530611008, -122.479072045798)
30424	30424	205111	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	49	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991346.44389	2092729.4529400002	37.725739027717204	-122.472118370494	(37.7257390277172, -122.472118370494)
31200	31200	205107	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	41	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		5991336.964	2092532.2101	37.7251968993055	-122.472136770613	(37.7251968993055, -122.472136770613)
31292	31292	205114	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Junipero Serra Blvd	16	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		5991407.36099	2093694.15878	37.7283913946494	-122.471978068129	(37.7283913946494, -122.471978068129)
31562	31562	212298	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	12	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991179.120709999	2090094.55389	37.7184945623549	-122.47250477768699	(37.7184945623549, -122.472504777687)
31596	31596	205081	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	32	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		5991210.7499	2090584.88401	37.7198427189488	-122.47243117628099	(37.7198427189488, -122.472431176281)
31895	31895	206303	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Junipero Serra Blvd	34	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991439.20179	2094163.2193200001	37.7296811600564	-122.47190216624901	(37.7296811600564, -122.471902166249)
32028	32028	212310	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	26	Median : Cutout 11	Tree 1	DPW 2			11	Width 0ft		5991202.259869999	2090434.6504900001	37.7194297232904	-122.472449576395	(37.7194297232904, -122.472449576395)
36236	36236	205097	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	27	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991311.65126	2092183.57203	37.7242381608387	-122.47219887147499	(37.7242381608387, -122.472198871475)
37920	37920	205095	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	25	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991309.74373	2092124.64335	37.724076246906705	-122.472201171954	(37.7240762469067, -122.472201171954)
38677	38677	212161	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300x Marietta Dr	11	Median : Cutout 11	Tree 1	DPW 2			24	Width 5ft		5999206.26812	2097588.84406	37.7395334857736	-122.445296885446	(37.7395334857736, -122.445296885446)
39182	39182	205077	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	28	Median : Cutout 11	Tree 1	DPW 2			12	Width 0ft		5991206.77223	2090490.8774299999	37.719584369801396	-122.47243807587601	(37.7195843698014, -122.472438075876)
41461	41461	212306	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	22	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991196.13313	2090333.39999	37.719151359714395	-122.472463376508	(37.7191513597144, -122.472463376508)
42384	42384	212160	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300x Marietta Dr	8	Median : Cutout 11	Tree 1	DPW 2			21	Width 5ft		5999181.20972	2097594.9111099998	37.7395487140123	-122.44538396231	(37.7395487140123, -122.44538396231)
42645	42645	176013	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300x Mansell St	2	Median : Cutout 11	Tree 1	DPW 2			32	Width 0ft		6010939.71676	2090487.4301	37.7206972862266	-122.40422782077101	(37.7206972862266, -122.404227820771)
43527	43527	205098	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	29	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991316.70247	2092233.8206900002	37.724376423516105	-122.472185071407	(37.7243764235161, -122.472185071407)
44624	44624	205088	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	41	Median : Cutout 11	Tree 1	DPW 2			11	Width 0ft		5991229.30633	2090865.43732	37.7206141232198	-122.47238747550301	(37.7206141232198, -122.472387475503)
45530	45530	206423	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	400x Marietta Dr	32	Median : Cutout 11	Tree 1	DPW 2			14	Width 3ft		5999166.42001	2097010.61151	37.737943522178504	-122.445393096728	(37.7379435221785, -122.445393096728)
47528	47528	205105	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	39	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991330.58276	2092481.99012	37.7250586384304	-122.472155170739	(37.7250586384304, -122.472155170739)
48363	48363	205112	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	50	Median : Cutout 11	Tree 1	DPW 2			10	Width 0ft		5991349.718230001	2092758.5362599997	37.7258190727658	-122.47210917039699	(37.7258190727658, -122.472109170397)
51690	51690	251039	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5400x Geary Blvd	1	Median : Cutout 11	Tree 1	DPW 2			2	Width 6ft		5990159.2899	2112663.7273	37.780404505362	-122.47767868930201	(37.780404505362, -122.477678689302)
52489	52489	212303	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	19	Median : Cutout 11	Tree 1	DPW 2			10	Width 0ft		5991192.118419999	2090269.21075	37.7189748794765	-122.47247257657601	(37.7189748794765, -122.472472576576)
52662	52662	205115	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Junipero Serra Blvd	17	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		5991409.19346	2093717.97139	37.728456884165	-122.471973468125	(37.728456884165, -122.471973468125)

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