Street_Tree_List

Data source: data.sfgov.org

862 rows where qLegalStatus = 3 and qSpecies = 60 sorted by rowid descending

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: qSiteInfo, qCaretaker, PermitNotes

Link	rowid ▲	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
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
188939	188939	212143	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	650x Miramar Ave	1	Median : Yard 3	Tree 1	DPW 2			3			5995395.28868	2093711.39383	37.7286686754144	-122.45819295046199	(37.7286686754144, -122.458192950462)
188895	188895	212106	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1602x Monterey Blvd	4	Median : Yard 3	Tree 1	DPW 2			33	Width 10ft		5993007.603759999	2095365.5409099997	37.733073065562	-122.466567434662	(37.733073065562, -122.466567434662)
188789	188789	1301	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	4000X Alemany Blvd	9	Median : Cutout 11	Tree 1	DPW 2			32	10		5991772.09471	2087046.42932	37.7101594558675	-122.470233284447	(37.7101594558675, -122.470233284447)
188426	188426	248776	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	10x Lyell St	3	Median : Yard 3	Tree 1	DPW 2			18	Width 10ft		6002998.16884	2095083.8511700002	37.73287107152721	-122.43200731937999	(37.7328710715272, -122.43200731938)
187741	187741	248647	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2x Lyell St	1	Median : Yard 3	Tree 1	DPW 2			23			6002988.020959999	2095088.4577900001	37.73288314494071	-122.432042732011	(37.7328831449407, -122.432042732011)
187602	187602	212146	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	650x Miramar Ave	4	Median : Yard 3	Tree 1	DPW 2			4			5995392.59413	2093841.41892	37.7290255380777	-122.458211672548	(37.7290255380777, -122.458211672548)
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)
186146	186146	212139	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	602x Miramar Ave	4	Median : Yard 3	Tree 1	DPW 2			6			5995385.05875	2093507.2159099998	37.728107464286204	-122.45821354403999	(37.7281074642862, -122.45821354404)
185624	185624	212116	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2001x Monterey Blvd	1	Median : Yard 3	Tree 1	DPW 2			26	Width 10ft		5992083.71687	2095423.23256	37.7331781144806	-122.469765726035	(37.7331781144806, -122.469765726035)
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)
183025	183025	212126	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	400x Miramar Ave	2	Median : Yard 3	Tree 1	DPW 2			7			5995367.13793	2092485.42648	37.725300846538	-122.458201574057	(37.725300846538, -122.458201574057)
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)
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)
182257	182257	212115	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1902x Monterey Blvd	3	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		5992194.67664	2095416.97281	37.7331673397011	-122.46938165614401	(37.7331673397011, -122.469381656144)
182169	182169	212152	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Miramar Ave	2	Median : Yard 3	Tree 1	DPW 2			6			5995399.05929	2094305.60657	37.730300456589106	-122.458222905079	(37.7303004565891, -122.458222905079)
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)
181805	181805	217819	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1x Junipero Serra Blvd	6	Median : Yard 3	Tree 1	DPW 2			33			5991622.365809999	2095679.35409	37.733854682528204	-122.471379381376	(37.7338546825282, -122.471379381376)
180628	180628	249479	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1300x Van Ness Ave	3	Median : Yard 3	Tree 1	DPW 2			13			6006342.53317	2115134.23147	37.7881137637835	-122.42186872687799	(37.7881137637835, -122.421868726878)
180603	180603	206418	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	99x Castenada Ave	16	Median : Cutout 11	Tree 1	DPW 2			17	Width 5ft		5993828.80673	2100251.01259	37.7465347043225	-122.464082870453	(37.7465347043225, -122.464082870453)
180124	180124	248649	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2x Lyell St	3	Median : Yard 3	Tree 1	DPW 2			14			6002995.03876	2095080.26155	37.732861037793	-122.43201788462	(37.732861037793, -122.43201788462)
179786	179786	212148	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	700x Miramar Ave	3	Median : Yard 3	Tree 1	DPW 2			2			5995395.17866	2094120.1752900002	37.7297910841891	-122.45822290508801	(37.7297910841891, -122.458222905088)
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)
173839	173839	205118	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Junipero Serra Blvd	26	Median : Cutout 11	Tree 1	DPW 2			3	Width 0ft		5991423.914	2093942.9209	37.729075391100004	-122.471938967411	(37.7290753911, -122.471938967411)
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)
172148	172148	205110	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	48	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991343.90426	2092703.6667900002	37.725668078393504	-122.472125270987	(37.7256680783935, -122.472125270987)
171533	171533	206417	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	255x San Marcos Ave	7	Median : Cutout 11	Tree 1	DPW 2			4	Width 5ft		5993040.30292	2100253.1432	37.7464950784009	-122.466809562712	(37.7464950784009, -122.466809562712)
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)
169173	169173	212153	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Miramar Ave	3	Median : Yard 3	Tree 1	DPW 2			2			5995398.99771	2094330.69415	37.730369337469504	-122.458224933031	(37.7303693374695, -122.458224933031)
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)
168651	168651	212159	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300x Marietta Dr	6	Median : Cutout 11	Tree 1	DPW 2			27	Width 5ft		5999137.09239	2097616.08451	37.739604332567794	-122.445538022478	(37.7396043325678, -122.445538022478)
167379	167379	251026	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5000x Geary Blvd	5	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		5991422.3485	2112710.0201	37.780604829996	-122.47331259909599	(37.780604829996, -122.473312599096)
166630	166630	189402	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	900x Carolina St	35	Median : Yard 3	Tree 1	DPW 2			31			6012483.079	2103205.45107	37.755704417647294	-122.399785428875	(37.7557044176473, -122.399785428875)
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)
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)
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)
164373	164373	212164	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300x Marietta Dr	29	Median : Cutout 11	Tree 1	DPW 2			18	Width 5ft		5999306.41715	2097560.47752	37.7394613142828	-122.444948576214	(37.7394613142828, -122.444948576214)
163476	163476	212133	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Miramar Ave	2	Median : Yard 3	Tree 1	DPW 2			40			5995378.50307	2093028.5023400001	37.7267926554346	-122.458201574049	(37.7267926554346, -122.458201574049)
163293	163293	248777	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	10x Lyell St	4	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6002988.77776	2095086.3960799999	37.7328775268597	-122.43203996838699	(37.7328775268597, -122.432039968387)
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)
162734	162734	212166	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300x Marietta Dr	39	Median : Cutout 11	Tree 1	DPW 2			15	Width 5ft		5999464.98652	2097513.89815	37.7393424670869	-122.444396968055	(37.7393424670869, -122.444396968055)
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)
162330	162330	212163	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	300x Marietta Dr	19	Median : Cutout 11	Tree 1	DPW 2			26	Width 5ft		5999254.90783	2097575.5344599998	37.739499717151205	-122.44512775445101	(37.7394997171512, -122.445127754451)
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)
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)
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)
160424	160424	212109	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1701x Monterey Blvd	3	Median : Yard 3	Tree 1	DPW 2			33	Width 10ft		5992703.672809999	2095383.87275	37.7331058566417	-122.467619528126	(37.7331058566417, -122.467619528126)
159485	159485	205109	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Junipero Serra Blvd	47	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991344.09487	2092681.13577	37.7256062248454	-122.472122970506	(37.7256062248454, -122.472122970506)
159138	159138	212118	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2001x Monterey Blvd	3	Median : Yard 3	Tree 1	DPW 2			34	Width 10ft		5991962.73959	2095431.83723	37.733194747433295	-122.470184599654	(37.7331947474333, -122.470184599654)
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)
158348	158348	217821	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1x Junipero Serra Blvd	9	Median : Yard 3	Tree 1	DPW 2			65			5991615.013669999	2095586.81694	37.7336001735084	-122.471398059368	(37.7336001735084, -122.471398059368)
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)
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)
157513	157513	212104	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1602x Monterey Blvd	2	Median : Yard 3	Tree 1	DPW 2			30	Width 10ft		5993129.9763400005	2095367.74637	37.733086182185	-122.46614452395201	(37.733086182185, -122.466144523952)
157149	157149	212117	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2001x Monterey Blvd	2	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		5992028.07396	2095428.94715	37.7331905889564	-122.469958512768	(37.7331905889564, -122.469958512768)
156541	156541	212155	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Miramar Ave	5	Median : Yard 3	Tree 1	DPW 2			3			5995400.6273300005	2094380.5335900001	37.7305062781406	-122.458222905082	(37.7305062781406, -122.458222905082)
156476	156476	212091	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1485x Northwood Dr	7	Median : Yard 3	Tree 1	DPW 2			17			5995834.1462199995	2094028.6614299999	37.7295650233891	-122.45669873857099	(37.7295650233891, -122.456698738571)
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)
156264	156264	212113	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1902x Monterey Blvd	1	Median : Yard 3	Tree 1	DPW 2			26	Width 10ft		5992332.7127	2095408.39507	37.7331517634298	-122.46890380855899	(37.7331517634298, -122.468903808559)
156000	156000	206304	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Junipero Serra Blvd	35	Median : Cutout 11	Tree 1	DPW 2			11	Width 0ft		5991440.53654	2094194.9922900002	37.72976847791129	-122.47189986669599	(37.7297684779113, -122.471899866696)
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)
152002	152002	212105	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1602x Monterey Blvd	3	Median : Yard 3	Tree 1	DPW 2			27	Width 10ft		5993074.71475	2095363.2347400002	37.7330706059279	-122.466335248575	(37.7330706059279, -122.466335248575)
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)
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)
150184	150184	205117	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Junipero Serra Blvd	24	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991421.73264	2093902.55265	37.7289644237558	-122.471943567458	(37.7289644237558, -122.471943567458)
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)
149555	149555	206305	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Junipero Serra Blvd	36	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991441.0529	2094219.4945900002	37.729835784970795	-122.471899866683	(37.7298357849708, -122.471899866683)
148993	148993	212151	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	800x Miramar Ave	1	Median : Yard 3	Tree 1	DPW 2			3			5995396.67937	2094269.52475	37.7302012478931	-122.458228522241	(37.7302012478931, -122.458228522241)
148028	148028	206301	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	500x Junipero Serra Blvd	28	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991427.453290001	2093984.5854099998	37.7291899962233	-122.471929767356	(37.7291899962233, -122.471929767356)
147361	147361	212138	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	602x Miramar Ave	3	Median : Yard 3	Tree 1	DPW 2			8			5995385.58848	2093480.77927	37.7280349060874	-122.458209800162	(37.7280349060874, -122.458209800162)
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)
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)
146323	146323	12554	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	280X Lake St	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			25	3X3		5994647.05266	2114915.6366	37.7868470540675	-122.462316907107	(37.7868470540675, -122.462316907107)
146288	146288	2099	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000X Bosworth St	7	Sidewalk: Property side : Cutout 5	Tree 1	DPW 2			10	3X3		6001184.3961352995	2095706.3375319	37.7344772801388	-122.438322562248	(37.7344772801388, -122.438322562248)
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)
146135	146135	112185	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	301x CORBETT AVE	5	Sidewalk: Property side : Yard 9	Tree 1	DPW 2				3x3		5999677.0	2105220.0	37.760513648972996	-122.444217531177	(37.760513648973, -122.444217531177)
146039	146039	17984	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2590 Pine St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3x3		6001555.7749733	2114978.4545091	37.787414928759105	-122.43841888265	(37.7874149287591, -122.43841888265)
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)
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)
145484	145484	16767	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1900X O'Farrell St	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	4X4		6002203.178690401	2113328.4738156004	37.7829213052255	-122.43606088796001	(37.7829213052255, -122.43606088796)
145303	145303	5126	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2750 Diamond St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			90	3X3		6002442.8157587005	2095988.0085916	37.735322180490705	-122.433991922534	(37.7353221804907, -122.433991922534)
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)
144984	144984	12574	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	352 Lake St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			60	3x3		5994320.89991	2114924.89711	37.7868536951076	-122.463445983594	(37.7868536951076, -122.463445983594)
144708	144708	16818	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2130 O'Farrell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6001107.6476595	2113179.9385941	37.782451166007	-122.439840308676	(37.782451166007, -122.439840308676)
144672	144672	16569	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	95X Nido Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/29/2000 12:00:00 AM	3	3X3		5999200.479133099	2112280.3747819	37.779872451802795	-122.446373519186	(37.7798724518028, -122.446373519186)
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)
144505	144505	121348	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
144494	144494	6314	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1829 Ellis St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6002129.29202	2112924.84308	37.781808839600394	-122.43628760910102	(37.7818088396004, -122.436287609101)
144468	144468	23942	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2334X Sacramento St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6003622.99851	2115966.7201400003	37.7902458233354	-122.431337290596	(37.7902458233354, -122.431337290596)
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)
144362	144362	111667	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2201 Sacramento St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				3X3		6004212.17015	2115977.4871900002	37.7903087592304	-122.429299568375	(37.7903087592304, -122.429299568375)
144299	144299	12268	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	649 Laguna St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6004914.9427	2111132.9358599996	37.7770465844733	-122.42652291977501	(37.7770465844733, -122.426522919775)
144164	144164	12568	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	325 Lake St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			80	3X3		5994431.11917	2114832.80083	37.7866071733964	-122.46305796876999	(37.7866071733964, -122.46305796877)
143718	143718	24328	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	601X Golden Gate Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18			6006691.6523257	2112520.4868544	37.7809567435024	-122.420475231256	(37.7809567435024, -122.420475231256)
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)
143661	143661	20223	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1540 Steiner St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	4x4		6002701.4105484	2113541.9155726	37.7835356549889	-122.43435247937201	(37.7835356549889, -122.434352479372)
143655	143655	5762	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	20 FILLMORE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6003883.0	2108496.0	37.7697478135844	-122.42990459081601	(37.7697478135844, -122.429904590816)
143178	143178	14949	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	200X Mendell St	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	3X3		6016963.53103	2098247.48496	37.7423396193305	-122.38394523176201	(37.7423396193305, -122.383945231762)
143076	143076	121355	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	399X Cargo Way	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			17	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
142931	142931	16814	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2103 O'Farrell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	4x4		6001244.311673901	2113148.4047409003	37.7823723603633	-122.43936525089899	(37.7823723603633, -122.439365250899)

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