Street_Tree_List

Data source: data.sfgov.org

248 rows where qSiteInfo = 11 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: PlantDate

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord ▼	YCoord	Latitude	Longitude	Location
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
61723	61723	205092	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	22	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991305.54801	2092051.8490000002	37.723876128855	-122.472210372006	(37.723876128855, -122.472210372006)
83096	83096	205094	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	24	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		5991307.287769999	2092102.83038	37.7240162117682	-122.47220807246599	(37.7240162117682, -122.472208072466)
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)
37920	37920	205095	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	25	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991309.74373	2092124.64335	37.724076246906705	-122.472201171954	(37.7240762469067, -122.472201171954)
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)
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)
36236	36236	205097	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	27	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991311.65126	2092183.57203	37.7242381608387	-122.47219887147499	(37.7242381608387, -122.472198871475)
146871	146871	205096	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	26	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		5991311.7020000005	2092154.41765	37.7241581130794	-122.47219657191002	(37.7241581130794, -122.47219657191)
43527	43527	205098	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	29	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991316.70247	2092233.8206900002	37.724376423516105	-122.472185071407	(37.7243764235161, -122.472185071407)
133644	133644	205099	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	33	Median : Cutout 11	Tree 1	DPW 2			11	Width 0ft		5991320.805269999	2092333.78187	37.724651129544	-122.47217817178002	(37.724651129544, -122.47217817178)
161984	161984	205100	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	34	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		5991322.5960099995	2092355.6088599998	37.724711164672705	-122.472173571767	(37.7247111646727, -122.472173571767)
181938	181938	205102	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	36	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991324.44766	2092411.88768	37.7248657994962	-122.472171271311	(37.7248657994962, -122.472171271311)
157717	157717	205101	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	35	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991325.17756	2092383.3819099998	37.724787571970296	-122.47216667126101	(37.7247875719703, -122.472166671261)
182952	182952	205103	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	37	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991326.973119999	2092437.01185	37.724934930379206	-122.47216437168899	(37.7249349303792, -122.472164371689)
161718	161718	205104	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	38	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991328.11288	2092459.51484	37.7249967839599	-122.47216207124399	(37.7249967839599, -122.472162071244)
47528	47528	205105	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	39	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991330.58276	2092481.99012	37.7250586384304	-122.472155170739	(37.7250586384304, -122.472155170739)
66048	66048	205106	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	40	Median : Cutout 11	Tree 1	DPW 2			10	Width 0ft		5991333.82922	2092509.74916	37.7251350457334	-122.47214597065901	(37.7251350457334, -122.472145970659)

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