Street_Tree_List

Data source: data.sfgov.org

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

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH ▼	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
55512	55512	206300	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Junipero Serra Blvd	27	Median : Cutout 11	Tree 1	DPW 2			3	Width 0ft		5991425.03969	2093964.76062	37.7291354226469	-122.471936666969	(37.7291354226469, -122.471936666969)
56441	56441	205091	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	21	Median : Cutout 11	Tree 1	DPW 2			3	Width 0ft		5991304.49196	2092033.3191900002	37.7238251894741	-122.472212672491	(37.7238251894741, -122.472212672491)
58519	58519	212305	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	21	Median : Cutout 11	Tree 1	DPW 2			3	Width 0ft		5991194.3003	2090309.58448	37.7190858620976	-122.47246797653901	(37.7190858620976, -122.472467976539)
69825	69825	205093	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	23	Median : Cutout 11	Tree 1	DPW 2			3	Width 0ft		5991307.52024	2092082.28561	37.7239598143777	-122.472205771982	(37.7239598143777, -122.472205771982)
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)
79082	79082	11840	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	12	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
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)
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)
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)
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)
87684	87684	11839	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	14	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
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)
89892	89892	30039	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	10	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
93762	93762	11846	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	18	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
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)
95638	95638	11841	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	13	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
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)
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)
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)
99517	99517	11834	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	6	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
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)
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)
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)
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)
102800	102800	30041	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	22	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
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)
105964	105964	30045	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	26	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
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)
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)
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)
117831	117831	30043	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	24	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
119448	119448	30040	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	21	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
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)
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)
127507	127507	30044	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	25	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
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)
128129	128129	30046	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	27	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
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)
139771	139771	11844	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	16	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
139855	139855	11845	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	17	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
140080	140080	11835	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	7	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
140720	140720	11681	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	710X Junipero Serra Blvd	13	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)
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)
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)
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)
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)
144641	144641	11847	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	19	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
145215	145215	11837	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	9	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
145667	145667	11836	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1400X Junipero Serra Blvd	8	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991384.4577741	2088377.8376777	37.7137927618926	-122.47166998341001	(37.7137927618926, -122.47166998341)
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)
151025	151025	205116	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Junipero Serra Blvd	23	Median : Cutout 11	Tree 1	DPW 2			3	Width 0ft		5991420.62116	2093881.37523	37.7289062115396	-122.47194586701599	(37.7289062115396, -122.471945867016)
163038	163038	212302	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	18	Median : Cutout 11	Tree 1	DPW 2			3	Width 0ft		5991190.15994	2090239.4345099998	37.7188930078858	-122.47247717658001	(37.7188930078858, -122.47247717658)
165991	165991	206302	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Junipero Serra Blvd	29	Median : Cutout 11	Tree 1	DPW 2			3	Width 0ft		5991428.71854	2094013.04751	37.729268219243394	-122.471927466905	(37.7292682192434, -122.471927466905)

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