Street_Tree_List

Data source: data.sfgov.org

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

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)
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)
90173	90173	95961	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5200 Geary Blvd	1	Median : Cutout 11	Tree 1	DPW 2		03/12/2011 12:00:00 AM				5990756.89162	2112756.21837	37.780693122390204	-122.47561808245399	(37.7806931223902, -122.475618082454)
97454	97454	105000	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	280X SAN MARCOS AVE	1	Median : Cutout 11	Tree 1	DPW 2			65		Tree tag no. 416	5993063.2	2100277.9	37.7465643757171	-122.466732187112	(37.7465643757171, -122.466732187112)
105037	105037	95960	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5100 Geary Blvd	3	Median : Cutout 11	Tree 1	DPW 2		03/12/2011 12:00:00 AM	2			5991179.182440001	2112771.35122	37.780759144985	-122.47415829445299	(37.780759144985, -122.474158294453)
109243	109243	95967	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5500 Geary Blvd	10	Median : Cutout 11	Tree 1	DPW 2		03/12/2011 12:00:00 AM	5			5989915.47138	2112737.13311	37.780591904899104	-122.478527531838	(37.7805919048991, -122.478527531838)
119414	119414	95963	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5200 Geary Blvd	4	Median : Cutout 11	Tree 1	DPW 2		03/12/2011 12:00:00 AM	5			5990756.89162	2112756.21837	37.780693122390204	-122.47561808245399	(37.7806931223902, -122.475618082454)
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)
141679	141679	13302	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	9X Lyell St	2	Median : Cutout 11	Tree 1	DPW 2			12	10		6003085.685949201	2094681.4720202	37.7317711908882	-122.43167603243099	(37.7317711908882, -122.431676032431)
188789	188789	1301	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	4000X Alemany Blvd	9	Median : Cutout 11	Tree 1	DPW 2			32	10		5991772.09471	2087046.42932	37.7101594558675	-122.470233284447	(37.7101594558675, -122.470233284447)
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)
138487	138487	13304	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	9X Lyell St	4	Median : Cutout 11	Tree 1	DPW 2			12	15		6003085.685949201	2094681.4720202	37.7317711908882	-122.43167603243099	(37.7317711908882, -122.431676032431)
142098	142098	13303	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	9X Lyell St	3	Median : Cutout 11	Tree 1	DPW 2			18	15		6003085.685949201	2094681.4720202	37.7317711908882	-122.43167603243099	(37.7317711908882, -122.431676032431)
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)
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)
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)
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)
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)
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)
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)
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)
77692	77692	3754	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1020 Carolina St	1	Median : Cutout 11	Tree 1	DPW 2			36	18		6012443.0515847	2103208.5839527003	37.755710788358	-122.399924077269	(37.755710788358, -122.399924077269)
98155	98155	19460	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1700X Sloat Blvd	6	Median : Cutout 11	Tree 1	DPW 2		11/13/2007 12:00:00 AM	3	20		5985858.9484667	2095882.6709765	37.7340778499573	-122.49131993236901	(37.7340778499573, -122.491319932369)
99939	99939	19428	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1200X Sloat Blvd	1	Median : Cutout 11	Tree 1	DPW 2		11/13/2007 12:00:00 AM	3	20		5987947.5018995	2095985.7700737999	37.7344827526385	-122.484106799366	(37.7344827526385, -122.484106799366)
114224	114224	19423	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	880X Sloat Blvd	1	Median : Cutout 11	Tree 1	DPW 2		11/13/2007 12:00:00 AM	3	20		5988998.102828201	2096024.0271709	37.7346489082814	-122.48047736602301	(37.7346489082814, -122.480477366023)
138707	138707	11843	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	20	Median : Cutout 11	Tree 1	DPW 2			3	2X2		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
87249	87249	29605	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	910X Junipero Serra Blvd	14	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991188.7321263	2091104.0152466998	37.7212668508959	-122.472545111236	(37.7212668508959, -122.472545111236)
88720	88720	29582	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	510X Junipero Serra Blvd	4	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991359.8087356	2093789.3771641003	37.7286500887761	-122.472149394695	(37.7286500887761, -122.472149394695)
88970	88970	11763	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	810X Junipero Serra Blvd	1	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991252.992504	2092079.9575241	37.7239502662313	-122.472394094235	(37.7239502662313, -122.472394094235)
95442	95442	29636	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	9	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
98950	98950	29632	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	5	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
99891	99891	29635	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	8	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
100149	100149	29637	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	10	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
103060	103060	29629	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	2	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
103985	103985	29638	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	11	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
108232	108232	29628	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	1	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
112917	112917	29604	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	910X Junipero Serra Blvd	13	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991188.7321263	2091104.0152466998	37.7212668508959	-122.472545111236	(37.7212668508959, -122.472545111236)
116075	116075	29587	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	610X Junipero Serra Blvd	1	Median : Cutout 11	Tree 1	DPW 2		04/01/2007 12:00:00 AM	3	3X3		5991336.987432401	2093443.9543843998	37.7277003234109	-122.472203119704	(37.7277003234109, -122.472203119704)
127749	127749	29603	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	910X Junipero Serra Blvd	12	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991188.7321263	2091104.0152466998	37.7212668508959	-122.472545111236	(37.7212668508959, -122.472545111236)
140900	140900	29634	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	7	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
141522	141522	23267	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800X Van Ness Ave	1	Median : Cutout 11	Tree 1	DPW 2			18	3X3		6006632.086075599	2113221.2018047003	37.7828773790282	-122.420731060153	(37.7828773790282, -122.420731060153)
143674	143674	29630	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	3	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
145795	145795	29633	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1110X Junipero Serra Blvd	6	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
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)
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)
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)
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)
98230	98230	29976	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	610X Junipero Serra Blvd	2	Median : Cutout 11	Tree 1	DPW 2		04/01/2007 12:00:00 AM	3	3x3		5991336.00972369	2093444.32433125	37.7277012826104	-122.47220652658001	(37.7277012826104, -122.47220652658)
125882	125882	29977	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	610X Junipero Serra Blvd	2	Median : Cutout 11	Tree 1	DPW 2		04/01/2007 12:00:00 AM	3	3x3		5991336.00972369	2093444.32433125	37.7277012826104	-122.47220652658001	(37.7277012826104, -122.47220652658)
141731	141731	29971	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	510X Junipero Serra Blvd	15	Median : Cutout 11	Tree 1	DPW 2		04/01/2007 12:00:00 AM	3	3x3		5991358.83331002	2093789.78166754	37.728651142992796	-122.472152796239	(37.7286511429928, -122.472152796239)
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)
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)
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)
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)
84548	84548	13398	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	332 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			80	5		5999526.1960451	2097456.6056762002	37.739188647769296	-122.44418121753901	(37.7391886477693, -122.444181217539)
88522	88522	13394	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300 Marietta Dr	2	Median : Cutout 11	Tree 1	DPW 2			100	5		5999367.9101935	2097504.6578797	37.7393115562077	-122.444731949771	(37.7393115562077, -122.444731949771)
90178	90178	13395	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	316 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			70	5		5999447.6447037	2097480.7016993	37.7392503280525	-122.44445454302401	(37.7392503280525, -122.444454543024)
102654	102654	13397	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	326 Marietta Dr	2	Median : Cutout 11	Tree 1	DPW 2			80	5		5999496.7834134	2097465.9380067	37.7392125940965	-122.44428358328001	(37.7392125940965, -122.44428358328)
112767	112767	111778	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300 Marietta Dr	3	Median : Cutout 11	Tree 1	DPW 2				5		5999367.9101935	2097504.6578797	37.7393115562077	-122.444731949771	(37.7393115562077, -122.444731949771)
141097	141097	13393	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			12	5		5999367.9101935	2097504.6578797	37.7393115562077	-122.444731949771	(37.7393115562077, -122.444731949771)
146180	146180	13391	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	294 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			12	5		5999337.3143931	2097513.8503676	37.739335050559	-122.44483839666701	(37.739335050559, -122.444838396667)

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