Street_Tree_List

Data source: data.sfgov.org

771 rows where PlotSize = "Width 6ft" and qSiteInfo = 2 sorted by qCareAssistant

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: SiteOrder

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant ▼	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
1857	1857	251765	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	23 Seville St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1				Width 6ft		6001915.0	2087651.0	37.7124006661461	-122.435220643728	(37.7124006661461, -122.435220643728)
1870	1870	251767	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	23 Seville St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1				Width 6ft		6001915.0	2087651.0	37.7124006661461	-122.435220643728	(37.7124006661461, -122.435220643728)
1871	1871	176854	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	23 Seville St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 6ft		6001915.0	2087651.0	37.7124006661461	-122.435220643728	(37.7124006661461, -122.435220643728)
1876	1876	251766	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	23 Seville St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1				Width 6ft		6001915.0	2087651.0	37.7124006661461	-122.435220643728	(37.7124006661461, -122.435220643728)
1878	1878	251764	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	187 Seville St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1				Width 6ft		6001178.343719999	2087386.3168	37.7116320444605	-122.43774780171302	(37.7116320444605, -122.437747801713)
3405	3405	180669	Undocumented 2	Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73	171 Winding Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 6ft		6002170.184219999	2086635.71157	37.70962739445179	-122.434266111507	(37.7096273944518, -122.434266111507)
3413	3413	180646	Undocumented 2	Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73	451 Rolph St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 6ft		6002230.18825	2087673.61332	37.7124806510226	-122.434132874236	(37.7124806510226, -122.434132874236)
3423	3423	251752	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	128 South Hill Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1				Width 6ft		6003064.16129	2086909.24662	37.7104291634552	-122.431195883608	(37.7104291634552, -122.431195883608)
3430	3430	180648	Undocumented 2	Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73	120 Seville St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 6ft		6001751.26715	2087361.8508	37.7115974268507	-122.435765878508	(37.7115974268507, -122.435765878508)
3432	3432	180655	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	128 South Hill Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 6ft		6003064.16129	2086909.24662	37.7104291634552	-122.431195883608	(37.7104291634552, -122.431195883608)
3488	3488	251753	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	128 South Hill Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1				Width 6ft		6003064.16129	2086909.24662	37.7104291634552	-122.431195883608	(37.7104291634552, -122.431195883608)
4071	4071	251734	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	856 Prague St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/05/2017 08:08:00 AM	3	Width 6ft		6002039.2106099995	2086908.72872	37.7103696049432	-122.434738288839	(37.7103696049432, -122.434738288839)
4205	4205	251774	Undocumented 2	Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73	120 Seville St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/10/2017 10:14:00 AM	3	Width 6ft		6001722.65495	2087355.7886599998	37.711579156239296	-122.435864336264	(37.7115791562393, -122.435864336264)
4209	4209	180663	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	355 Chicago Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/10/2017 01:48:00 PM	3	Width 6ft		6002383.84355	2086445.14687	37.709116270155604	-122.43351405884898	(37.7091162701556, -122.433514058849)
4231	4231	180667	Undocumented 2	Pittosporum crassifolium :: Karo Tree 108	344 Chicago Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/10/2017 01:51:00 PM	3	Width 6ft		6002403.88387	2086502.6359	37.709275259527296	-122.43344890203998	(37.7092752595273, -122.43344890204)
4244	4244	180664	Undocumented 2	Magnolia champaca :: Champa 170	339 Chicago Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/10/2017 01:55:00 PM	3	Width 6ft		6002468.5653	2086489.08528	37.7092417219876	-122.43322438540399	(37.7092417219876, -122.433224385404)
4254	4254	180668	Undocumented 2	Pittosporum crassifolium :: Karo Tree 108	360 Chicago Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/10/2017 01:45:00 PM	3	Width 6ft		6002314.90905	2086461.72548	37.709157880008	-122.433753490754	(37.709157880008, -122.433753490754)
4271	4271	180665	Undocumented 2	Pittosporum crassifolium :: Karo Tree 108	316 Chicago Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/10/2017 02:13:00 PM	3	Width 6ft		6002643.65919	2086652.61793	37.7097006784091	-122.432630907484	(37.7097006784091, -122.432630907484)
4284	4284	175543	Undocumented 2	Podocarpus gracilor :: Fern Pine 13	187 Seville St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/10/2017 09:37:00 AM	3	Width 6ft		6001178.343719999	2087386.3168	37.7116320444605	-122.43774780171302	(37.7116320444605, -122.437747801713)
4296	4296	251775	Undocumented 2	Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73	120 Seville St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/10/2017 10:17:00 AM	3	Width 6ft		6001722.65495	2087355.7886599998	37.711579156239296	-122.435864336264	(37.7115791562393, -122.435864336264)
4358	4358	180653	Undocumented 2	Magnolia champaca :: Champa 170	245 Chicago Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/11/2017 07:56:00 AM	3	Width 6ft		6002847.75966	2086772.69306	37.7100419513527	-122.43193406871299	(37.7100419513527, -122.431934068713)
4484	4484	251776	Undocumented 2	Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73	120 Seville St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		10/13/2017 12:12:00 PM	3	Width 6ft		6001722.65495	2087355.7886599998	37.711579156239296	-122.435864336264	(37.7115791562393, -122.435864336264)
23452	23452	207071	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1927 08th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 6ft		5993749.481269999	2102344.6615	37.752278758765605	-122.464509159894	(37.7522787587656, -122.464509159894)
23456	23456	122922	Undocumented 2	Crateagus spp :: Hawthorn 160	2 11th Ave	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 6ft		5992430.88304	2114907.16681	37.7866959384714	-122.469983652903	(37.7866959384714, -122.469983652903)
23530	23530	222049	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	201 Treat Ave	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		6008976.23011	2107818.47181	37.768174596097104	-122.41223929451401	(37.7681745960971, -122.412239294514)
23531	23531	212068	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	65 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 6ft		5994349.34377	2097659.88165	37.7394500943456	-122.46209504585501	(37.7394500943456, -122.462095045855)
23577	23577	118033	Undocumented 2	Cordyline australis :: Dracena Palm 141	89 Shore View Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 6ft		5984120.82492	2112822.3596099997	37.780487786596204	-122.498579960483	(37.7804877865962, -122.498579960483)
23638	23638	179012	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	575 Lisbon St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		6001860.73543	2090148.2767900003	37.719254552441704	-122.435586742551	(37.7192545524417, -122.435586742551)
23769	23769	133285	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2800 Divisadero St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 6ft		6000622.64068	2117960.51369	37.7955497631676	-122.44186143746401	(37.7955497631676, -122.441861437464)
23904	23904	122926	Undocumented 2	Betula pendula :: European White Birch 146	2 11th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 6ft		5992433.415569999	2114874.23335	37.7866056586788	-122.46997249221701	(37.7866056586788, -122.469972492217)
24085	24085	212387	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	95 San Rafael Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		5991919.26492	2095494.2164099999	37.7333635115101	-122.47033944313499	(37.7333635115101, -122.470339443135)
24221	24221	124585	Undocumented 2	Pittosporum crassifolium :: Karo Tree 108	3979 Washington St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 6ft		5995656.4760300005	2115464.7980400003	37.788412975773504	-122.458864334168	(37.7884129757735, -122.458864334168)
24414	24414	205283	Undocumented 2	Cordyline australis :: Dracena Palm 141	200 Pacheco St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 6ft		5994526.48433	2100257.0572599997	37.7465914866063	-122.46167083296801	(37.7465914866063, -122.461670832968)
24416	24416	212061	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	21 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		5994643.85383	2097859.63633	37.740015523303704	-122.461091241468	(37.7400155233037, -122.461091241468)
24799	24799	120350	Undocumented 2	Eriobotrya japonica :: Edible Loquat 190	2122 Lake St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5988813.63616	2114710.28976	37.7859456052821	-122.482483881641	(37.7859456052821, -122.482483881641)
25105	25105	189974	Undocumented 2	Cercis occidentalis :: Western Redbud 246	875 Vermont St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 6ft		6011341.45696	2104259.23548	37.75853416774461	-122.40380768986999	(37.7585341677446, -122.40380768987)
25444	25444	198476	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	800 Minnesota St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		6015193.91802	2104744.93458	37.7600822588968	-122.390517973622	(37.7600822588968, -122.390517973622)
25635	25635	204675	Undocumented 2	Calocedrus decurrens :: Incense Cedar 177	2020 09th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 6ft		5993508.90003	2101694.1589200003	37.7504787737838	-122.46529387412201	(37.7504787737838, -122.465293874122)
25674	25674	218195	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1365 Portola Dr	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 6ft		5993371.5777900005	2097679.7437299998	37.7394482867046	-122.46547714694599	(37.7394482867046, -122.465477146946)
25739	25739	212063	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	39 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		5994526.15715	2097790.3563900003	37.7398185241173	-122.461493163775	(37.7398185241173, -122.461493163775)
25989	25989	118011	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	450 37th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 6ft		5984411.11276	2112748.04652	37.7803007642443	-122.49757024513599	(37.7803007642443, -122.497570245136)
26173	26173	211563	Undocumented 2	Pittosporum undulatum :: Victorian Box 26	175 San Fernando Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 6ft		5992148.97215	2095580.3817099999	37.7336133782595	-122.46955155876002	(37.7336133782595, -122.46955155876)
26387	26387	212392	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	65 San Rafael Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		5991914.22227	2095632.90127	37.733744013755796	-122.470366973162	(37.7337440137558, -122.470366973162)
26518	26518	206504	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1959 10th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		5993136.05327	2102151.01657	37.7517116786758	-122.46661639913602	(37.7517116786758, -122.466616399136)
26752	26752	250523	Undocumented 2	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18	95 26th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 6ft		5987685.92853	2115397.50584	37.78776683682629	-122.48643586433998	(37.7877668368263, -122.48643586434)
26768	26768	203786	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	2010 09th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 6ft		5993506.591630001	2101771.6935400004	37.7506915308916	-122.465307488051	(37.7506915308916, -122.465307488051)
26891	26891	203788	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	2010 09th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 6ft		5993504.43454	2101812.32675	37.7508029748893	-122.465317898622	(37.7508029748893, -122.465317898622)
27081	27081	176269	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	273 Curtis St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		6000993.66237	2087160.73145	37.711002134104795	-122.43836995721901	(37.7110021341048, -122.438369957219)
27168	27168	197313	Undocumented 2	Quercus virginiana :: Southern Live Oak 341	16 Bridgeview Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		6016056.29901	2108502.85342	37.7704484959236	-122.387797593705	(37.7704484959236, -122.387797593705)
27171	27171	211993	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	163 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 6ft		5992397.64836	2095631.03278	37.7337668223846	-122.468695504899	(37.7337668223846, -122.468695504899)
27196	27196	198667	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	124 Russ St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		6010302.39718	2111555.70743	37.778510504382794	-122.407915770511	(37.7785105043828, -122.407915770511)
27210	27210	118030	Undocumented 2	Myoporum laetum :: Myoporum 1	65 Shore View Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 6ft		5984259.34297	2112813.72518	37.7804722014619	-122.498100130783	(37.7804722014619, -122.498100130783)
27215	27215	120462	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	75 West Clay St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		5988526.89995	2115008.4578299997	37.7867476054693	-122.483497765205	(37.7867476054693, -122.483497765205)
27425	27425	197327	Undocumented 2	Quercus virginiana :: Southern Live Oak 341	14 Bridgeview Way	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		6016081.45818	2108068.9584	37.769258508494	-122.387680289716	(37.769258508494, -122.387680289716)
27464	27464	215498	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	95 Santa Paula Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5993979.5407	2097285.08347	37.7383996933922	-122.46334646239201	(37.7383996933922, -122.463346462392)
27480	27480	120474	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	88 West Clay St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		5988469.711569999	2115060.56996	37.78688736184021	-122.483699443255	(37.7868873618402, -122.483699443255)
27511	27511	215496	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	69 Santa Paula Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5993975.721530001	2097357.94979	37.7385995461283	-122.46336495334299	(37.7385995461283, -122.463364953343)
27606	27606	201518	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	501 Griffith St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 6ft		6019207.673780001	2094338.78719	37.7317309074526	-122.37591462936199	(37.7317309074526, -122.375914629362)
27663	27663	174978	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	861 Lisbon St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 6ft		6001016.58593	2088794.32712	37.7154889282344	-122.43840769096799	(37.7154889282344, -122.438407690968)
27665	27665	215220	Undocumented 2	Syzygium paniculatum :: Brush Cherry 198	2020 09th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 6ft		5993507.89159	2101745.37647	37.7506193459188	-122.465301081296	(37.7506193459188, -122.465301081296)
27744	27744	208259	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	7 San Lorenzo Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5993794.93642	2097790.46819	37.7397767164315	-122.464021405387	(37.7397767164315, -122.464021405387)
28099	28099	215484	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	21 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5994076.92667	2097749.04597	37.739679229001496	-122.46304340523001	(37.7396792290015, -122.46304340523)
28230	28230	243963	Undocumented 2	Yucca gloriosa :: Spanish Dagger 224	3450 26th St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		6006727.57204	2100887.26512	37.7490166748846	-122.419525382284	(37.7490166748846, -122.419525382284)
28239	28239	120254	Undocumented 2	Pyrus kawakamii :: Evergreen Pear 82	150 24th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5988369.36546	2114920.76145	37.7864976459369	-122.4840363573	(37.7864976459369, -122.4840363573)
28309	28309	206505	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1965 10th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 6ft		5993138.76599	2102124.2403700002	37.7516383146611	-122.46660507218701	(37.7516383146611, -122.466605072187)
28332	28332	120358	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	2350 Lake St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		5988092.81378	2114686.07827	37.785837168438604	-122.48497592142598	(37.7858371684386, -122.484975921426)
28421	28421	208250	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	55 San Lorenzo Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		5993729.31252	2097594.20118	37.739234034035704	-122.464234058156	(37.7392340340357, -122.464234058156)
28606	28606	231203	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	100 27th St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 6ft		6005825.85771	2100250.83508	37.747218351845	-122.42259830188401	(37.747218351845, -122.422598301884)
28675	28675	208635	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	469 Pacheco St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 6ft		5993695.70853	2101832.2366299997	37.7508686712517	-122.464657906832	(37.7508686712517, -122.464657906832)
28682	28682	220133	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	751 Dolores St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 6ft		6005049.364440001	2103949.71117	37.7573307687038	-122.42554656283501	(37.7573307687038, -122.425546562835)
28699	28699	219186	Undocumented 2	Ilex altaclarensis 'Wilsonii' :: Wilson Holly Tree 310	496 Pacheco St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 6ft		5993589.76159	2101911.4781299997	37.7510801396583	-122.46503003281099	(37.7510801396583, -122.465030032811)
28772	28772	175741	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	262 Chicago Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 6ft		6002753.09913	2086743.14922	37.709955463542	-122.432259125067	(37.709955463542, -122.432259125067)
29038	29038	208963	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	90 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			30	Width 6ft		5993939.166669999	2096822.57013	37.7371274206966	-122.463452499655	(37.7371274206966, -122.463452499655)
29183	29183	135142	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1405 The Embarcadero	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 6ft		6009611.73281	2122475.6117	37.8084552117099	-122.411076576336	(37.8084552117099, -122.411076576336)
29287	29287	120447	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	55 22nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		5988944.82314	2114949.71234	37.7866106225502	-122.482047561852	(37.7866106225502, -122.482047561852)
29329	29329	206551	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	308 Pacheco St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5994320.14066	2100781.15308	37.74801864146029	-122.462422349606	(37.7480186414603, -122.462422349606)
29455	29455	211935	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	200 Pacheco St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 6ft		5994517.11867	2100302.62637	37.74671606878879	-122.461706521658	(37.7467160687888, -122.461706521658)
29684	29684	197303	Undocumented 2	Quercus virginiana :: Southern Live Oak 341	13 Bridgeview Way	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		6016090.0437900005	2108435.7275799997	37.770266052269605	-122.387676185234	(37.7702660522696, -122.387676185234)
29752	29752	197306	Undocumented 2	Quercus virginiana :: Southern Live Oak 341	13 Bridgeview Way	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		6016086.21724	2108504.38173	37.7704543496162	-122.387694212136	(37.7704543496162, -122.387694212136)
29756	29756	215492	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	51 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5993992.82093	2097521.50716	37.7390496190449	-122.463317697564	(37.7390496190449, -122.463317697564)
29996	29996	131246	Undocumented 2	Metrosideros excelsa :: New Zealand Xmas Tree 2	2759 Broderick St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 6ft		6000062.75843	2118080.3525400003	37.7958468901791	-122.443807334766	(37.7958468901791, -122.443807334766)
30255	30255	212081	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	143 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 6ft		5994296.308209999	2096965.44252	37.737540283266796	-122.462228067287	(37.7375402832668, -122.462228067287)
30287	30287	214298	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	268 Pacheco St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5994394.90516	2100680.9533	37.7477478232146	-122.4621565532	(37.7477478232146, -122.4621565532)
30355	30355	180399	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	349 Chicago Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		6002410.48398	2086459.29818	37.7091566380421	-122.433422996175	(37.7091566380421, -122.433422996175)
30962	30962	229293	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	500 Dolores St	17	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 6ft		6004930.67222	2104696.88853	37.7593756346006	-122.42601023528	(37.7593756346006, -122.42601023528)
30993	30993	246520	Undocumented 2	Olea europaea :: Olive Tree 41	155 Laguna St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 6ft		6005167.3236	2109440.76034	37.772414546119705	-122.42552939567601	(37.7724145461197, -122.425529395676)
31119	31119	222045	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	201 Treat Ave	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 6ft		6008941.81103	2107754.9472	37.7679982408485	-122.412353856457	(37.7679982408485, -122.412353856457)
31171	31171	229300	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	500 Dolores St	29	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 6ft		6004946.7397	2104361.09729	37.7584545390754	-122.425930763098	(37.7584545390754, -122.425930763098)
31255	31255	120468	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	90 West Clay St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 6ft		5988384.0014	2115083.94801	37.7869465618324	-122.483997692017	(37.7869465618324, -122.483997692017)
31291	31291	210988	Undocumented 2	Picea Spp :: Spruce Spp 357	2000 16th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		5991307.5277	2101754.98227	37.7505185813763	-122.472910744261	(37.7505185813763, -122.472910744261)
31410	31410	203402	Undocumented 2	Acer rubrum :: Red Maple 6	20 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 6ft		5993459.6533	2097164.40162	37.738038365583	-122.465135202222	(37.738038365583, -122.465135202222)
31563	31563	124169	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	951 Anza St	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 6ft		5996113.01293	2112199.70913	37.779474144226	-122.457048529936	(37.779474144226, -122.457048529936)
31727	31727	197188	Undocumented 2	Quercus agrifolia :: Coast Live Oak 180	1800 Illinois St	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		6016258.08648	2100618.43223	37.748810728335705	-122.386549751994	(37.7488107283357, -122.386549751994)
31840	31840	197328	Undocumented 2	Quercus virginiana :: Southern Live Oak 341	14 Bridgeview Way	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		6016081.1788	2108055.10958	37.7692204671748	-122.38768028972	(37.7692204671748, -122.38768028972)
31994	31994	124164	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	951 Anza St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 6ft		5995840.67051	2112165.09055	37.7793634471791	-122.45798816595301	(37.7793634471791, -122.457988165953)
32201	32201	198478	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	800 Minnesota St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 6ft		6015196.41735	2104702.3820599997	37.759965557478296	-122.390506356185	(37.7599655574783, -122.390506356185)
32333	32333	212083	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	147 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 6ft		5994302.639880001	2096897.5947599998	37.7373543547061	-122.462201256705	(37.7373543547061, -122.462201256705)
32387	32387	229294	Undocumented 2	Magnolia grandiflora :: Southern Magnolia 21	500 Dolores St	19	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 6ft		6004933.04589	2104652.65087	37.7592543025755	-122.42599887684099	(37.7592543025755, -122.425998876841)
32405	32405	203412	Undocumented 2	Acer rubrum :: Red Maple 6	1945 08th Ave	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5993816.05949	2102205.88495	37.7519015516321	-122.464268849347	(37.7519015516321, -122.464268849347)
32649	32649	208251	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	45 San Lorenzo Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		5993740.8112	2097632.42389	37.7393396468031	-122.464197075333	(37.7393396468031, -122.464197075333)

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