Street_Tree_List

Data source: data.sfgov.org

113 rows where PlotSize = "Width 6ft" and qSiteInfo = 4

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, SiteOrder, qCaretaker, DBH

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
652	652	237023	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	8 Octavia St	4	: 4	Tree 1	DPW 2		04/15/2017 01:44:00 PM	3	Width 6ft		6005765.01716	2109438.39176	37.7724417955802	-122.423461745458	(37.7724417955802, -122.423461745458)
661	661	237024	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	8 Octavia St	5	: 4	Tree 1	DPW 2		04/15/2017 01:48:00 PM	3	Width 6ft		6005763.84021	2109451.72322	37.772478334130994	-122.423466764586	(37.772478334131, -122.423466764586)
663	663	237022	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	8 Octavia St	3	: 4	Tree 1	DPW 2		04/15/2017 01:40:00 PM	3	Width 6ft		6005770.133230001	2109412.50366	37.772371001847	-122.423442207693	(37.772371001847, -122.423442207693)
666	666	237028	DPW Maintained 3	Pyrus kawakamii :: Evergreen Pear 82	8 Octavia St	9	: 4	Tree 1	DPW 2		04/15/2017 01:55:00 PM	3	Width 6ft		6005756.39315	2109517.28856	37.7726579404383	-122.423497186858	(37.7726579404383, -122.423497186858)
23416	23416	247236	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1251 Haight St	1	: 4	Tree 1	Private 1			26	Width 6ft		6000176.36555	2108836.62464	37.770472476353	-122.442750157415	(37.770472476353, -122.442750157415)
23879	23879	193824	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	1550 Fairfax Ave	3	: 4	Tree 1	Private 1			14	Width 6ft		6015655.00087	2098203.32161	37.742145929985796	-122.388466689285	(37.7421459299858, -122.388466689285)
23930	23930	246508	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	241 Duncan St	1	: 4	Tree 1	Private 1			8	Width 6ft		6004932.15845	2099866.5422	37.7461127118493	-122.425661300149	(37.7461127118493, -122.425661300149)
24332	24332	246923	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	411 Frederick St	1	: 4	Tree 1	Private 1			15	Width 6ft		5997906.77047	2107481.56832	37.7666221917918	-122.450502958247	(37.7666221917918, -122.450502958247)
24372	24372	246497	Undocumented 2	Maytenus boaria :: Mayten 22	319 Duncan St	1	: 4	Tree 1	Private 1			15	Width 6ft		6004279.93355	2099832.71811	37.7459829621447	-122.427914200798	(37.7459829621447, -122.427914200798)
25659	25659	194764	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	1101 Newhall St	1	: 4	Tree 1	Private 1			1	Width 6ft		6014997.18752	2096468.24359	37.737345287747395	-122.390620003515	(37.7373452877474, -122.390620003515)
27153	27153	197239	Undocumented 2	Quercus suber :: Cork Oak 76	830 Rhode Island St	1	: 4	Tree 1	Private 1			1	Width 6ft		6011827.26305	2104492.53285	37.7592018783746	-122.40214394588999	(37.7592018783746, -122.40214394589)
27862	27862	194050	Undocumented 2	Myoporum laetum :: Myoporum 1	2246 Jerrold Ave	1	: 4	Tree 1	Private 1			23	Width 6ft		6012135.46921	2099441.05415	37.7453488151107	-122.400723136672	(37.7453488151107, -122.400723136672)
30639	30639	188038	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	811 Rhode Island St	1	: 4	Tree 1	Private 1			6	Width 6ft		6011881.03364	2104580.1042400002	37.7594453311486	-122.401964136345	(37.7594453311486, -122.401964136345)
30667	30667	193640	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1980 Oakdale Ave	7	: 4	Tree 1	Private 1			28	Width 6ft		6012998.43724	2097039.27853	37.7388021399962	-122.397570695448	(37.7388021399962, -122.397570695448)
32108	32108	247728	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	49 Broderick St	5	: 4	Tree 1	Private 1			25	Width 6ft		6001337.82386	2108917.42217	37.7707604698615	-122.43873846612101	(37.7707604698615, -122.438738466121)
32271	32271	237025	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	8 Octavia St	6	: 4	Tree 1	Private 1			3	Width 6ft		6005760.04076	2109480.81274	37.7725579925006	-122.423481975714	(37.7725579925006, -122.423481975714)
33767	33767	190391	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	571 Texas St	2	: 4	Tree 1	Private 1			1	Width 6ft		6013851.28196	2104449.17868	37.75919560292179	-122.395140827087	(37.7591956029218, -122.395140827087)
35898	35898	194688	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	638 Rhode Island St	1	: 4	Tree 1	Private 1			13	Width 6ft		6011777.7256	2105391.88862	37.7616685442839	-122.402378507957	(37.7616685442839, -122.402378507957)
36186	36186	224283	Undocumented 2	Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114	2501 17th St	7	: 4	Tree 1	Private 1			25	Width 6ft		6009798.458330001	2106396.21275	37.7643155017769	-122.409294898865	(37.7643155017769, -122.409294898865)
39654	39654	189416	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1106 Wisconsin St	5	: 4	Tree 1	Private 1			23	Width 6ft		6012793.60681	2102247.59908	37.753091670356206	-122.3986443034	(37.7530916703562, -122.3986443034)
41399	41399	188809	Undocumented 2	Bambusa spp :: Bamboo Species 346	1842 Illinois St	1	: 4	Tree 1	Private 1			25	Width 6ft		6016259.82532	2100544.95868	37.7486090814646	-122.386538616586	(37.7486090814646, -122.386538616586)
42217	42217	237026	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	8 Octavia St	7	: 4	Tree 1	Private 1			3	Width 6ft		6005759.75569	2109493.68206	37.7725933124646	-122.423483876889	(37.7725933124646, -122.423483876889)
44466	44466	245799	Undocumented 2	Corymbia calophylla :: 383	50 Church St	1	: 4	Tree 1	Private 1			21	Width 6ft		6004070.9370099995	2108481.83175	37.7697195522468	-122.429253511635	(37.7697195522468, -122.429253511635)
44841	44841	187973	Undocumented 2	Albizia julibrissin :: Mimosa Silk Tree 126	1814 Illinois St	1	: 4	Tree 1	Private 1			2	Width 6ft		6016258.63636	2100595.19225	37.7487469466117	-122.386546230235	(37.7487469466117, -122.386546230235)
45074	45074	249440	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	900 Ellis St	5	: 4	Tree 1	Private 1			15	Width 6ft		6006344.64005	2113562.97552	37.7837996008221	-122.421749788816	(37.7837996008221, -122.421749788816)
45899	45899	191819	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	929 Rhode Island St	3	: 4	Tree 1	Private 1			13	Width 6ft		6011909.67827	2104067.75313	37.7580401269696	-122.401829053673	(37.7580401269696, -122.401829053673)
46335	46335	228902	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	121 Scott St	1	: 4	Tree 1	Private 1			14	Width 6ft		6002319.8368	2108939.8536900003	37.7708778790509	-122.435343274489	(37.7708778790509, -122.435343274489)
46558	46558	237027	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	8 Octavia St	8	: 4	Tree 1	Private 1			5	Width 6ft		6005758.332230001	2109504.65873	37.772623371413495	-122.423489581302	(37.7726233714135, -122.423489581302)
46583	46583	246509	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	241 Duncan St	2	: 4	Tree 1	Private 1			7	Width 6ft		6004948.2324	2099866.59265	37.7461137586439	-122.425605722044	(37.7461137586439, -122.425605722044)
48058	48058	246924	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	401 Frederick St	1	: 4	Tree 1	Private 1			11	Width 6ft		5997929.70146	2107483.7518599997	37.7666294996706	-122.45042380174101	(37.7666294996706, -122.450423801741)
49009	49009	188889	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	812 Rhode Island St	2	: 4	Tree 1	Private 1			3	Width 6ft		6011824.00346	2104560.8876	37.7593893834298	-122.402160024888	(37.7593893834298, -122.402160024888)
50519	50519	201808	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	247 Friedell St	1	: 4	Tree 1	Private 1			1	Width 6ft		6020927.8472	2093035.08257	37.7282457215548	-122.369877496672	(37.7282457215548, -122.369877496672)
51164	51164	196547	Undocumented 2	Prunus x yedoensis :: Yoshino Cherry 237	970 Wisconsin St	1	: 4	Tree 1	Private 1			10	Width 6ft		6012751.3239400005	2103003.6751599996	37.7551653352247	-122.398843585967	(37.7551653352247, -122.398843585967)
53044	53044	189423	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	401 Texas St	2	: 4	Tree 1	Private 1			16	Width 6ft		6013814.74653	2105139.2952099997	37.7610884806725	-122.395315529383	(37.7610884806725, -122.395315529383)
53841	53841	221665	Undocumented 2	Acer palmatum :: Japanese Maple 175	415 Buchanan St	2	: 4	Tree 1	Private 1			1	Width 6ft		6004608.713169999	2109961.56798	37.7738129784269	-122.427498793141	(37.7738129784269, -122.427498793141)
54298	54298	239149	Undocumented 2	Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147	8 Octavia St	13	: 4	Tree 1	Private 1			3	Width 6ft		6005748.02057	2109577.9462099997	37.7728240191579	-122.423530461786	(37.7728240191579, -122.423530461786)
55114	55114	228430	Undocumented 2	Howea forsteriana :: Kentia Palm 240	89 Elgin Park	4	: 4	Tree 1	Private 1			5	Width 6ft		6005839.096	2108586.92632	37.770108056668704	-122.42314496557199	(37.7701080566687, -122.423144965572)
55202	55202	193389	Undocumented 2	Magnolia grandiflora 'Russet' :: Russet Magnolia 229	357 Missouri St	1	: 4	Tree 1	Private 1			12	Width 6ft		6013519.95695	2105414.95396	37.7618289797317	-122.39635440822701	(37.7618289797317, -122.396354408227)
57801	57801	246533	Undocumented 2	Olea europaea 'Swan Hill' :: Olive 217	55 Laguna St	1	: 4	Tree 1	Private 1			1	Width 6ft		6005235.090009999	2108976.11964	37.771142583693205	-122.42526191570101	(37.7711425836932, -122.425261915701)
58530	58530	125936	Undocumented 2	Cedrus atlantica :: Atlas Cedar 304	3640 Fillmore St	2	: 4	Tree 1	Private 1			12	Width 6ft		6002183.33436	2120790.5318400003	37.803409058151104	-122.43666384886801	(37.8034090581511, -122.436663848868)
59063	59063	187896	Undocumented 2	Acer rubrum :: Red Maple 6	1701 Indiana St	7	: 4	Tree 1	Private 1			8	Width 6ft		6015200.4277800005	2100533.54912	37.748519049422704	-122.390201234205	(37.7485190494227, -122.390201234205)
59153	59153	220122	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	200 Dolores St	4	: 4	Tree 1	Private 1			6	Width 6ft		6004793.59671	2107104.43038	37.7659784237974	-122.42665575247	(37.7659784237974, -122.42665575247)
60719	60719	187894	Undocumented 2	Acer rubrum :: Red Maple 6	1701 Indiana St	5	: 4	Tree 1	Private 1			5	Width 6ft		6015203.0238	2100485.5663	37.748387442638396	-122.390188905397	(37.7483874426384, -122.390188905397)
61117	61117	224281	Undocumented 2	Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114	2501 17th St	4	: 4	Tree 1	Private 1			25	Width 6ft		6009683.49225	2106388.44143	37.7642877217255	-122.40969198731301	(37.7642877217255, -122.409691987313)
61734	61734	249439	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	900 Ellis St	4	: 4	Tree 1	Private 1			15	Width 6ft		6006372.16148	2113566.88832	37.7838118963457	-122.421654852808	(37.7838118963457, -122.421654852808)
62032	62032	125937	Undocumented 2	Cedrus atlantica :: Atlas Cedar 304	3640 Fillmore St	3	: 4	Tree 1	Private 1			17	Width 6ft		6002179.26509	2120811.82356	37.8034672883377	-122.43667945570401	(37.8034672883377, -122.436679455704)
62751	62751	136028	Undocumented 2	Prunus subhirtella 'Pendula' :: Weeping Cherry 370	701 Buchanan St	2	: 4	Tree 1	Private 1			4	Width 6ft		6004477.21749	2110912.17552	37.7764156757853	-122.428021412563	(37.7764156757853, -122.428021412563)
63217	63217	193823	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	1550 Fairfax Ave	2	: 4	Tree 1	Private 1			13	Width 6ft		6015666.23055	2098193.52595	37.7421196554058	-122.388427176666	(37.7421196554058, -122.388427176666)
63912	63912	196532	Undocumented 2	Prunus blireiana :: Flowering Plum 102	1317 19th St	1	: 4	Tree 1	Private 1			5	Width 6ft		6013654.12142	2105210.0397200002	37.761273794973	-122.395876023757	(37.761273794973, -122.395876023757)
64913	64913	201811	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	101 Friedell St	2	: 4	Tree 1	Private 1			1	Width 6ft		6021050.71889	2093203.62599	37.7287152512926	-122.369464359799	(37.7287152512926, -122.369464359799)
65028	65028	194756	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	451 Phelps St	3	: 4	Tree 1	Private 1			2	Width 6ft		6015565.50725	2098337.28346	37.742508801940495	-122.388785482789	(37.7425088019405, -122.388785482789)
65062	65062	201810	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	101 Friedell St	1	: 4	Tree 1	Private 1			1	Width 6ft		6021035.70856	2093179.8039900002	37.7286490171175	-122.369514606714	(37.7286490171175, -122.369514606714)
66857	66857	221191	Undocumented 2	Bambusa spp :: Bamboo Species 346	84 Elgin Park	1	: 4	Tree 1	Private 1			2	Width 6ft		6005819.266340001	2108627.0732299997	37.7702171714132	-122.423216410424	(37.7702171714132, -122.423216410424)
66860	66860	246934	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	327 Frederick St	1	: 4	Tree 1	Private 1			22	Width 6ft		5998433.91472	2107557.60959	37.7668611389688	-122.448685143299	(37.7668611389688, -122.448685143299)
67284	67284	187895	Undocumented 2	Acer rubrum :: Red Maple 6	1701 Indiana St	6	: 4	Tree 1	Private 1			8	Width 6ft		6015201.97274	2100509.17213	37.7484522010065	-122.39019418890601	(37.7484522010065, -122.390194188906)
67317	67317	191836	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	151 Quint St	1	: 4	Tree 1	Private 1			21	Width 6ft		6015558.53873	2099422.72383	37.7454888107556	-122.388885340797	(37.7454888107556, -122.388885340797)
67529	67529	193827	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	451 Phelps St	2	: 4	Tree 1	Private 1			13	Width 6ft		6015556.710659999	2098326.08175	37.7424775567988	-122.38881511721901	(37.7424775567988, -122.388815117219)
67778	67778	249437	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	900 Ellis St	2	: 4	Tree 1	Private 1			16	Width 6ft		6006423.6127	2113573.86871	37.783833963915704	-122.421477346411	(37.7838339639157, -122.421477346411)
68215	68215	239147	Undocumented 2	Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147	8 Octavia St	11	: 4	Tree 1	Private 1			5	Width 6ft		6005750.76035	2109550.79453	37.7727496218289	-122.423519053867	(37.7727496218289, -122.423519053867)
69388	69388	195163	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	787 Wisconsin St	1	: 4	Tree 1	Private 1			14	Width 6ft		6012760.9648400005	2103859.57999	37.757516000268396	-122.398870312036	(37.7575160002684, -122.398870312036)
70003	70003	193113	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	1918 Palou Ave	1	: 4	Tree 1	Private 1			18	Width 6ft		6013201.374480001	2096537.6402	37.73743604374629	-122.396833869195	(37.7374360437463, -122.396833869195)
72334	72334	228428	Undocumented 2	Howea forsteriana :: Kentia Palm 240	89 Elgin Park	2	: 4	Tree 1	Private 1			5	Width 6ft		6005838.66969	2108584.9319	37.770102556411096	-122.42314629839	(37.7701025564111, -122.42314629839)
74208	74208	199359	Undocumented 2	Eucalyptus sideroxylon :: Red Ironbark 36	1450 Rhode Island St	2	: 4	Tree 1	Private 1			22	Width 6ft		6011987.04436	2101599.75481	37.751267861428104	-122.401388046827	(37.7512678614281, -122.401388046827)
119502	119502	191797	Undocumented 2	Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114	2501 17th St	10	: 4	Tree 1	Private 1			21	Width 6ft		6009965.75706	2106404.4344599997	37.7643474484095	-122.408716837108	(37.7643474484095, -122.408716837108)
124105	124105	187892	Undocumented 2	Acer rubrum :: Red Maple 6	1701 Indiana St	3	: 4	Tree 1	Private 1			7	Width 6ft		6015206.13934	2100438.08	37.74825722800529	-122.39017481481501	(37.7482572280053, -122.390174814815)
129637	129637	221666	Undocumented 2	Acer palmatum :: Japanese Maple 175	599 Buchanan St	5	: 4	Tree 1	Private 1			1	Width 6ft		6004540.01666	2110455.77622	37.775166067795794	-122.427771645646	(37.7751660677958, -122.427771645646)
129642	129642	187897	Undocumented 2	Acer rubrum :: Red Maple 6	1701 Indiana St	8	: 4	Tree 1	Private 1			9	Width 6ft		6015199.38185	2100557.40869	37.7485845047902	-122.39020651771999	(37.7485845047902, -122.39020651772)
129749	129749	237029	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	8 Octavia St	10	: 4	Tree 1	Private 1			3	Width 6ft		6005753.2097	2109536.23847	37.7727097926437	-122.423509546241	(37.7727097926437, -122.423509546241)
130239	130239	246503	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	259 Duncan St	1	: 4	Tree 1	Private 1			12	Width 6ft		6004822.9307	2099858.69154	37.7460849830515	-122.42603843714599	(37.7460849830515, -122.426038437146)
133115	133115	187891	Undocumented 2	Acer rubrum :: Red Maple 6	1701 Indiana St	2	: 4	Tree 1	Private 1			5	Width 6ft		6015208.193580001	2100413.69272	37.7481903795776	-122.390166007757	(37.7481903795776, -122.390166007757)
134900	134900	246532	Undocumented 2	Olea europaea 'Swan Hill' :: Olive 217	65 Laguna St	2	: 4	Tree 1	Private 1			1	Width 6ft		6005230.90915	2109011.0238799998	37.7712381861207	-122.425278861635	(37.7712381861207, -122.425278861635)
147076	147076	191796	Undocumented 2	Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114	2501 17th St	9	: 4	Tree 1	Private 1			22	Width 6ft		6009868.91026	2106400.84541	37.7643321689061	-122.409051551294	(37.7643321689061, -122.409051551294)
147345	147345	191837	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	151 Quint St	2	: 4	Tree 1	Private 1			40	Width 6ft		6015645.89147	2099542.5410599997	37.745822645408104	-122.388591648288	(37.7458226454081, -122.388591648288)
147747	147747	193825	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	1550 Fairfax Ave	6	: 4	Tree 1	Private 1			15	Width 6ft		6015596.67696	2098247.43003	37.742263810427296	-122.388671435242	(37.7422638104273, -122.388671435242)
149627	149627	187893	Undocumented 2	Acer rubrum :: Red Maple 6	1701 Indiana St	4	: 4	Tree 1	Private 1			7	Width 6ft		6015205.088280001	2100461.68616	37.7483219872815	-122.390180098326	(37.7483219872815, -122.390180098326)
149677	149677	187890	Undocumented 2	Acer rubrum :: Red Maple 6	1701 Indiana St	1	: 4	Tree 1	Private 1			7	Width 6ft		6015208.72001	2100389.3363099997	37.7481235311712	-122.39016248603001	(37.7481235311712, -122.39016248603)
150057	150057	190640	Undocumented 2	Heteromeles arbutifolia :: Toyon 322	1450 Rhode Island St	1	: 4	Tree 1	Private 1			11	Width 6ft		6011986.5577	2101606.22651	37.75128560415661	-122.401390184524	(37.7512856041566, -122.401390184524)
152264	152264	246502	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	263 Duncan St	1	: 4	Tree 1	Private 1			13	Width 6ft		6004797.9998	2099855.96577	37.7460760896468	-122.426124451001	(37.7460760896468, -122.426124451001)
152901	152901	239239	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	101 Scott St	1	: 4	Tree 1	Private 1			20	Width 6ft		6002329.06188	2108869.34471	37.7706848027038	-122.435306320439	(37.7706848027038, -122.435306320439)
152926	152926	190743	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	39 Latona St	1	: 4	Tree 1	Private 1			2	Width 6ft		6014419.07803	2094437.81167	37.731738047151296	-122.392476830144	(37.7317380471513, -122.392476830144)
153275	153275	238673	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	85 Saint Germain Ave	1	: 4	Tree 1	Private 1			6	Width 6ft		5998049.304830001	2104134.89853	37.757441236042	-122.44976875802799	(37.757441236042, -122.449768758028)
155290	155290	194701	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	610 Texas St	1	: 4	Tree 1	Private 1			18	Width 6ft		6013805.4381099995	2104247.89308	37.758640366887896	-122.395285278001	(37.7586403668879, -122.395285278001)
157074	157074	201809	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	237 Friedell St	1	: 4	Tree 1	Private 1			1	Width 6ft		6020945.51773	2093059.3003900002	37.72831318869729	-122.369818081152	(37.7283131886973, -122.369818081152)
158281	158281	228429	Undocumented 2	Howea forsteriana :: Kentia Palm 240	89 Elgin Park	3	: 4	Tree 1	Private 1			5	Width 6ft		6005840.03928	2108585.95316	37.7701054378359	-122.42314163358999	(37.7701054378359, -122.42314163359)
158555	158555	192631	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	2 Garlington Ct	1	: 4	Tree 1	Private 1			15	Width 6ft		6016783.64783	2094408.52472	37.7317886592161	-122.38429991441002	(37.7317886592161, -122.38429991441)
159899	159899	187898	Undocumented 2	Acer rubrum :: Red Maple 6	1635 Indiana St	7	: 4	Tree 1	Private 1			7	Width 6ft		6015180.25331	2100882.371	37.749475722127	-122.390295365361	(37.749475722127, -122.390295365361)
160847	160847	129100	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	701 Buchanan St	3	: 4	Tree 1	Private 1			8	Width 6ft		6004473.20652	2110925.86056	37.7764530246232	-122.42803626308701	(37.7764530246232, -122.428036263087)
161423	161423	196154	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1317 19th St	2	: 4	Tree 1	Private 1			3	Width 6ft		6013683.78692	2105210.99248	37.7612780613652	-122.395773489354	(37.7612780613652, -122.395773489354)
163454	163454	129101	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	701 Buchanan St	4	: 4	Tree 1	Private 1			6	Width 6ft		6004471.22614	2110943.39026	37.7765010448349	-122.428044363274	(37.7765010448349, -122.428044363274)
164138	164138	194195	Undocumented 2	Olea europaea :: Olive Tree 41	9 Pomona St	1	: 4	Tree 1	Private 1			2	Width 6ft		6014203.67115	2094680.19203	37.732391609687205	-122.393238495663	(37.7323916096872, -122.393238495663)
168883	168883	238579	Undocumented 2	Prunus x yedoensis :: Yoshino Cherry 237	415 Buchanan St	1	: 4	Tree 1	Private 1			7	Width 6ft		6004609.7624	2109940.50049	37.7737551915801	-122.427493662508	(37.7737551915801, -122.427493662508)
169819	169819	224284	Undocumented 2	Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114	2501 17th St	8	: 4	Tree 1	Private 1			16	Width 6ft		6009837.11194	2106398.45896	37.7643238348958	-122.409161364832	(37.7643238348958, -122.409161364832)
171743	171743	224280	Undocumented 2	Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114	2501 17th St	3	: 4	Tree 1	Private 1			23	Width 6ft		6009642.33079	2106387.7637400003	37.764283554258206	-122.409834305929	(37.7642835542582, -122.409834305929)
174054	174054	193826	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	451 Phelps St	1	: 4	Tree 1	Private 1			8	Width 6ft		6015550.82711	2098317.6658099997	37.742454122259296	-122.38883487355301	(37.7424541222593, -122.388834873553)
174363	174363	228901	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	135 Scott St	1	: 4	Tree 1	Private 1			12	Width 6ft		6002314.127230001	2108991.34813	37.77101894580421	-122.435366708107	(37.7710189458042, -122.435366708107)
175187	175187	193822	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	1550 Fairfax Ave	1	: 4	Tree 1	Private 1			15	Width 6ft		6015679.2772699995	2098183.69362	37.742093380811504	-122.388381378708	(37.7420933808115, -122.388381378708)
175455	175455	239148	Undocumented 2	Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147	8 Octavia St	12	: 4	Tree 1	Private 1			3	Width 6ft		6005748.59719	2109565.89201	37.7727909537754	-122.423527610038	(37.7727909537754, -122.423527610038)
176128	176128	246976	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	221 Noe St	1	: 4	Tree 1	Private 1			4	Width 6ft		6002925.65155	2106953.9304400003	37.765459405239504	-122.43310583406799	(37.7654594052395, -122.433105834068)
177574	177574	191717	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	554 Rhode Island St	1	: 4	Tree 1	Private 1			13	Width 6ft		6011757.49983	2105782.3491	37.762739532526005	-122.40247591803801	(37.762739532526, -122.402475918038)
178218	178218	224278	Undocumented 2	Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114	2501 17th St	1	: 4	Tree 1	Private 1			29	Width 6ft		6009557.01375	2106382.4069999997	37.7642640641669	-122.410129016455	(37.7642640641669, -122.410129016455)

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