Street_Tree_List

Data source: data.sfgov.org

853 rows where qCaretaker = 2 and qSpecies = 60 sorted by XCoord

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by TreeID Sort by qLegalStatus Sort by qSpecies Sort by qAddress Sort by SiteOrder Sort by qSiteInfo Sort by PlantType Sort by qCaretaker Sort by qCareAssistant Sort by PlantDate Sort by DBH Sort by PlotSize Sort by PermitNotes Sort by XCoord Sort by YCoord Sort by Latitude Sort by Longitude Sort by Location

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord ▼	YCoord	Latitude	Longitude	Location
6948	6948	20002	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	100 STAIRWAY46	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	2
7696	7696	19998	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	100 STAIRWAY46	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40
10647	10647	19755	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	100 STAIRWAY15	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3
16139	16139	19754	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	100 STAIRWAY15	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3
189144	189144	121399	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	349X Cargo Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2
103615	103615	21143	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2292X Sunset Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60		5984947.8628076	2099601.6268993	37.7442358239277	-122.49474388696001	(37.7442358239277, -122.49474388696)
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)
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)
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)
60953	60953	251054	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	6000x Geary Blvd	5	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5988209.3153	2112595.4218	37.7801036030677	-122.48441946896601	(37.7801036030677, -122.484419468966)
166322	166322	251051	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5900x Geary Blvd	5	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5988530.6021	2112606.8245	37.780153615018705	-122.48330884168699	(37.7801536150187, -122.483308841687)
92602	92602	95971	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5900 Geary Blvd	5	Median : 22	Tree 1	DPW 2		03/12/2011 12:00:00 AM	2			5988665.62185	2112680.2165599996	37.7803629858967	-122.482847132605	(37.7803629858967, -122.482847132605)
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)
150851	150851	251082	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5600x Geary Blvd	4	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		5989477.5192	2112643.2957	37.7803088175248	-122.480035730601	(37.7803088175248, -122.480035730601)
149750	149750	251044	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5600x Geary Blvd	2	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		5989568.3861	2112643.8334	37.7803155729867	-122.47972142279801	(37.7803155729867, -122.479721422798)
85995	85995	95969	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5600 Geary Blvd	4	Median : 22	Tree 1	DPW 2		03/12/2011 12:00:00 AM	2			5989606.68558	2112715.06065	37.7805133679778	-122.479594141591	(37.7805133679778, -122.479594141591)
122416	122416	95968	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5600 Geary Blvd	2	Median : 22	Tree 1	DPW 2		03/12/2011 12:00:00 AM	2			5989606.68558	2112715.06065	37.7805133679778	-122.479594141591	(37.7805133679778, -122.479594141591)
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)
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)
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)
98676	98676	95965	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5400 Geary Blvd	1	Median : 22	Tree 1	DPW 2		03/12/2011 12:00:00 AM	2			5990210.87302	2112736.64328	37.7806077057511	-122.47750557201701	(37.7806077057511, -122.477505572017)
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)
119299	119299	353	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	3590X 19th Ave	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	2		5990537.68384	2091850.07218	37.7232776319094	-122.474850005219	(37.7232776319094, -122.474850005219)
58965	58965	331	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	3402X 19th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/24/2008 12:00:00 AM	50	2X3		5990579.05408	2092494.4249099998	37.725049260991604	-122.474754004974	(37.7250492609916, -122.474754004974)
78918	78918	332	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	3402X 19th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/24/2008 12:00:00 AM	80	2X3		5990579.05408	2092494.4249099998	37.725049260991604	-122.474754004974	(37.7250492609916, -122.474754004974)
74409	74409	251072	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5200x Geary Blvd	6	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		5990697.77	2112688.192	37.7805029132293	-122.475817641236	(37.7805029132293, -122.475817641236)
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)
104582	104582	95964	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5200 Geary Blvd	6	Median : 22	Tree 1	DPW 2		03/12/2011 12:00:00 AM				5990756.89162	2112756.21837	37.780693122390204	-122.47561808245399	(37.7806931223902, -122.475618082454)
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)
32868	32868	251069	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5200x Geary Blvd	1	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		5990794.5513	2112690.3427	37.7805144291466	-122.47548298954099	(37.7805144291466, -122.475482989541)
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)
44686	44686	251075	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5100x Geary Blvd	3	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5990994.9145	2112700.954	37.7805551774565	-122.47479062026899	(37.7805551774565, -122.474790620269)
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)
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)
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)
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)
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)
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)
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)
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)
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)
186690	186690	212295	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	6	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		5991170.53267	2089939.6813400001	37.7180688232854	-122.472523177809	(37.7180688232854, -122.472523177809)
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)
162733	162733	212296	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	10	Median : Cutout 11	Tree 1	DPW 2			10	Width 0ft		5991176.06439	2090044.25898	37.7183562879852	-122.472511677268	(37.7183562879852, -122.472511677268)
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)
67053	67053	212297	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	11	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991177.8274300005	2090064.7629799999	37.7184126889791	-122.47250707726002	(37.7184126889791, -122.47250707726)
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)
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)
146358	146358	212299	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	14	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991184.2984	2090150.76712	37.7186492097602	-122.47249097667401	(37.7186492097602, -122.472490976674)
173416	173416	212300	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	16	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991186.31185	2090192.49351	37.7187638967107	-122.472487057435	(37.7187638967107, -122.472487057435)
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)
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)
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)
184198	184198	212301	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	17	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991188.84719	2090215.0879099998	37.7188260821255	-122.47247994019199	(37.7188260821255, -122.472479940192)
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)
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)
157693	157693	212304	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	20	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991192.55124	2090289.74279	37.7190312804608	-122.472472576553	(37.7190312804608, -122.472472576553)
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)
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)
68407	68407	212307	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	23	Median : Cutout 11	Tree 1	DPW 2			12	Width 0ft		5991200.212719999	2090369.09522	37.7192496061609	-122.47245187595	(37.7192496061609, -122.47245187595)
66442	66442	212308	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	24	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991201.47803	2090397.56088	37.7193278390954	-122.47244957640801	(37.7193278390954, -122.472449576408)
166561	166561	212309	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	25	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991201.91083	2090418.0925900002	37.719384239169294	-122.472449576413	(37.7193842391693, -122.472449576413)
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)
55711	55711	205076	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	27	Median : Cutout 11	Tree 1	DPW 2			12	Width 0ft		5991204.8696099995	2090463.7504	37.7195097755318	-122.472442675902	(37.7195097755318, -122.472442675902)
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)
158549	158549	205078	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	29	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		5991207.21899	2090512.07145	37.7196425892212	-122.47243807587601	(37.7196425892212, -122.472438075876)
73785	73785	205079	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	30	Median : Cutout 11	Tree 1	DPW 2			13	Width 0ft		5991209.0936900005	2090537.87387	37.7197135448202	-122.47243347583	(37.7197135448202, -122.47243347583)
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)
174777	174777	205080	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	31	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		5991211.60542	2090562.33735	37.7197808608892	-122.47242657625	(37.7197808608892, -122.47242657625)
72304	72304	205082	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	34	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991216.27623	2090657.6545099998	37.720042848675604	-122.47241737616501	(37.7200428486756, -122.472417376165)
111045	111045	11732	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	900X Junipero Serra Blvd	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	4X6		5991216.9689233005	2091217.0890623	37.7215789580388	-122.472455744827	(37.7215789580388, -122.472455744827)
69407	69407	205083	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	35	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		5991217.1837	2090700.70485	37.720161106826	-122.472417376171	(37.720161106826, -122.472417376171)
67638	67638	205084	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	36	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991220.51447	2090732.43963	37.720248435491904	-122.472408175222	(37.7202484354919, -122.472408175222)
156267	156267	205085	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	38	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991225.77549	2090792.62573	37.720413996187	-122.47239437511601	(37.720413996187, -122.472394375116)
182927	182927	205086	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	39	Median : Cutout 11	Tree 1	DPW 2			12	Width 0ft		5991226.90116	2090814.4677099998	37.7204740340313	-122.472392075543	(37.7204740340313, -122.472392075543)
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)
65755	65755	205087	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	40	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991229.32936	2090834.95737	37.7205304341251	-122.47238517504499	(37.7205304341251, -122.472385175045)
169141	169141	205089	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	42	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		5991231.16702	2090890.57712	37.7206832586037	-122.47238287549601	(37.7206832586037, -122.472382875496)
70422	70422	205090	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	44	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991232.93514	2090942.88536	37.7208269864641	-122.472380575028	(37.7208269864641, -122.472380575028)
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)
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)
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)
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)
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)
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)
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)
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)
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)
93174	93174	24409	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	901X Junipero Serra Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/18/1998 12:00:00 AM	6	3x3		5991288.1161497	2091224.4470027	37.7216032788517	-122.472210346501	(37.7216032788517, -122.472210346501)
106771	106771	11758	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	901X Junipero Serra Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/18/1998 12:00:00 AM	6	3X5		5991288.1161497	2091224.4470027	37.7216032788517	-122.472210346501	(37.7216032788517, -122.472210346501)
113706	113706	24407	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	901X Junipero Serra Blvd	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/29/1995 12:00:00 AM	6	3X3		5991288.1161497	2091224.4470027	37.7216032788517	-122.472210346501	(37.7216032788517, -122.472210346501)
139614	139614	24408	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	901X Junipero Serra Blvd	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/29/1995 12:00:00 AM	12	3x3		5991288.1161497	2091224.4470027	37.7216032788517	-122.472210346501	(37.7216032788517, -122.472210346501)
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)

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