Street_Tree_List

Data source: data.sfgov.org

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

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
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)
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)
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)
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)
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)
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)
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)
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)
60017	60017	176014	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Mansell St	1	Median : Cutout 11	Tree 1	DPW 2			45	Width 0ft		6010647.65151	2090407.8799299998	37.7204625334973	-122.405231805915	(37.7204625334973, -122.405231805915)
74365	74365	217779	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	498x West Portal Ave	1	Median : Cutout 11	Tree 1	DPW 2			25	Width 4ft		5991539.5981	2096085.91428	37.734966205933794	-122.471695149536	(37.7349662059338, -122.471695149536)
75985	75985	176015	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	600x Mansell St	1	Median : Cutout 11	Tree 1	DPW 2			16	Width 0ft		6010073.5317400005	2090236.70222	37.7199604006417	-122.40720430245399	(37.7199604006417, -122.407204302454)
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)
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)
78324	78324	30038	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	1	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
83854	83854	13403	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	360 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			14	5x1000		5999647.998558	2097391.335153	37.7390163784819	-122.44375539278	(37.7390163784819, -122.44375539278)
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)
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)
88606	88606	113723	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	282X MARIETTA DR	1	Median : Cutout 11	Tree 1	DPW 2				5x30		5999031.0	2097664.0	37.739729839693496	-122.445908288102	(37.7397298396935, -122.445908288102)
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)
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)
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)
96198	96198	13301	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	9X Lyell St	1	Median : Cutout 11	Tree 1	DPW 2			18	6		6003085.685949201	2094681.4720202	37.7317711908882	-122.43167603243099	(37.7317711908882, -122.431676032431)
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)
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)
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)
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)
110230	110230	13411	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	368 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			20	5x1000		5999673.9454175	2097366.8297673	37.73895057241529	-122.443663920765	(37.7389505724153, -122.443663920765)
111621	111621	13400	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	338 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			18	5x1000		5999551.819033401	2097447.7157589	37.7391656999261	-122.444091986476	(37.7391656999261, -122.444091986476)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
62175	62175	212292	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	2	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		5991164.37326	2089829.54432	37.7177660575462	-122.472536442798	(37.7177660575462, -122.472536442798)
79615	79615	11764	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	810X Junipero Serra Blvd	2	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	6X6		5991252.992504	2092079.9575241	37.7239502662313	-122.472394094235	(37.7239502662313, -122.472394094235)
86752	86752	23177	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300X Van Ness Ave	2	Median : Cutout 11	Tree 1	DPW 2			30	9		6006874.5373229	2111536.5864673	37.778265495762	-122.41977270620701	(37.778265495762, -122.419772706207)
86755	86755	30140	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	410X Mansell St	2	Median : Cutout 11	Tree 1	DPW 2			18	M		6010678.994322	2090457.6265959998	37.720600879856704	-122.405126964413	(37.7206008798567, -122.405126964413)
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)
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)
89161	89161	9257	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	6600X Geary Blvd	2	Median : Cutout 11	Tree 1	DPW 2		03/12/2011 12:00:00 AM	2	8M		5986360.871619999	2112530.52863	37.7798176164012	-122.490809209885	(37.7798176164012, -122.490809209885)
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)
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)
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)
101567	101567	11830	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	2	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
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)
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)
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)
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)
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)
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)
127728	127728	13399	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	332 Marietta Dr	2	Median : Cutout 11	Tree 1	DPW 2			20	5x1000		5999526.1960451	2097456.6056762002	37.739188647769296	-122.44418121753901	(37.7391886477693, -122.444181217539)
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)
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)
160775	160775	217780	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	498x Andenwood Way	2	Median : Cutout 11	Tree 1	DPW 2			25	Width 4ft		5991282.56605	2096217.08745	37.7353114997185	-122.47259335189501	(37.7353114997185, -122.472593351895)
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)
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)
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)
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)
81843	81843	23367	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1356X Van Ness Ave	3	Median : Cutout 11	Tree 1	DPW 2			18	9		6006391.382589401	2115174.2493055	37.7882263975959	-122.42170255954201	(37.7882263975959, -122.421702559542)
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)
98624	98624	23178	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300X Van Ness Ave	3	Median : Cutout 11	Tree 1	DPW 2			30	9		6006874.5373229	2111536.5864673	37.778265495762	-122.41977270620701	(37.778265495762, -122.419772706207)
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)
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)
106431	106431	11831	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	3	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
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)
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)
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)
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)
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)
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)
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)
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)
170614	170614	212293	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	3	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		5991165.05081	2089858.71083	37.717846180842294	-122.472536226064	(37.7178461808423, -122.472536226064)
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)
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)
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)
79741	79741	16693	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	900X NORIEGA ST	4	Median : Cutout 11	Tree 1	DPW 2		11/07/2014 11:22:00 AM	3	8		5991142.4	2103205.1	37.7544906639436	-122.473587529216	(37.7544906639436, -122.473587529216)
82243	82243	206416	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	255x San Marcos Ave	4	Median : Cutout 11	Tree 1	DPW 2			13	Width 5ft		5993123.33521	2100243.25688	37.7464727248457	-122.466521730189	(37.7464727248457, -122.466521730189)
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)
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)
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)
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)
144436	144436	11832	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	4	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
154256	154256	212294	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	4	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		5991166.95703	2089883.0190299999	37.7179130355286	-122.472531408396	(37.7179130355286, -122.472531408396)
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)
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)
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)
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)
123135	123135	23179	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300X Van Ness Ave	5	Median : Cutout 11	Tree 1	DPW 2			30	9		6006874.5373229	2111536.5864673	37.778265495762	-122.41977270620701	(37.778265495762, -122.419772706207)
126132	126132	30042	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	5	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)

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