Street_Tree_List

Data source: data.sfgov.org

176 rows where qSiteInfo = 14 sorted by Location

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, PlantType, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location ▼
549 251321 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 100X Monument Way 1 Unaccepted Street : Yard 14 Tree 1 Private 1                    
4222 253622 Undocumented 2 Pittosporum spp :: Pittosporum spp 128 300x Naglee Ave   Unaccepted Street : Yard 14 Tree 1 Private 1                    
4552 97357 Permitted Site 1 Tree(s) :: 17   7 Unaccepted Street : Yard 14 Tree 1 Private 1                    
4913 97358 Permitted Site 1 Tree(s) :: 17   8 Unaccepted Street : Yard 14 Tree 1 Private 1                    
7011 97356 Permitted Site 1 Tree(s) :: 17   6 Unaccepted Street : Yard 14 Tree 1 Private 1                    
7040 97351 Permitted Site 1 Tree(s) :: 17   1 Unaccepted Street : Yard 14 Tree 1 Private 1                    
8657 97354 Permitted Site 1 Tree(s) :: 17   4 Unaccepted Street : Yard 14 Tree 1 Private 1                    
10631 97353 Permitted Site 1 Tree(s) :: 17   3 Unaccepted Street : Yard 14 Tree 1 Private 1                    
14893 97355 Permitted Site 1 Tree(s) :: 17   5 Unaccepted Street : Yard 14 Tree 1 Private 1                    
16895 97352 Permitted Site 1 Tree(s) :: 17   2 Unaccepted Street : Yard 14 Tree 1 Private 1                    
185502 122532 Undocumented 2 Pinus radiata :: Monterey Pine 3 1900X Castro St 1 Unaccepted Street : Yard 14 Tree 1 Private 1                    
82185 111319 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 200x PENINSULA AVE 2 Unaccepted Street : Yard 14 Tree 1 Private 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
87976 111318 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 200x PENINSULA AVE 1 Unaccepted Street : Yard 14 Tree 1 Private 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
122748 111320 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 200x PENINSULA AVE 3 Unaccepted Street : Yard 14 Tree 1 Private 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
82737 106281 Undocumented 2 Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 474 399X Elliot St 2 Unaccepted Street : Yard 14 Tree 1 Rec/Park 3         Permit Number 772905 6008798.75873 2088103.6204900001 37.7140319762934 -122.41146014936301 (37.7140319762934, -122.411460149363)
95834 106280 Undocumented 2 Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 474 399X Elliot St 1 Unaccepted Street : Yard 14 Tree 1 Rec/Park 3         Permit Number 772905 6008798.75873 2088103.6204900001 37.7140319762934 -122.41146014936301 (37.7140319762934, -122.411460149363)
119057 106282 Undocumented 2 Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 474 399X Elliot St 3 Unaccepted Street : Yard 14 Tree 1 Rec/Park 3         Permit Number 772905 6008798.75873 2088103.6204900001 37.7140319762934 -122.41146014936301 (37.7140319762934, -122.411460149363)
87421 111309 Undocumented 2 Acacia spp :: Acacia Spp 176 100x GILROY ST 1 Unaccepted Street : Yard 14 Tree 1 Private 1       30x30   6015178.0 2088529.0 37.7155557353625 -122.38944056945101 (37.7155557353625, -122.389440569451)
91188 111312 Undocumented 2 Acacia spp :: Acacia Spp 176 99x GILROY ST 3 Unaccepted Street : Yard 14 Tree 1 Private 1       30x30   6015277.0 2088666.0 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034)
96975 111311 Undocumented 2 Acacia spp :: Acacia Spp 176 99x GILROY ST 2 Unaccepted Street : Yard 14 Tree 1 Private 1       30x30   6015277.0 2088666.0 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034)
123880 111310 Undocumented 2 Acacia spp :: Acacia Spp 176 99x GILROY ST 1 Unaccepted Street : Yard 14 Tree 1 Private 1       30x30   6015277.0 2088666.0 37.7159373992527 -122.389107938034 (37.7159373992527, -122.389107938034)
112606 105901 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 11X ELLIOT ST 2 Unaccepted Street : Yard 14 Tree 1 DPW 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
122561 105900 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 11X ELLIOT ST 1 Unaccepted Street : Yard 14 Tree 1 DPW 2     30     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
138343 105902 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 11X ELLIOT ST 3 Unaccepted Street : Yard 14 Tree 1 DPW 2     40     6009059.0 2088845.0 37.716082244868005 -122.410612975888 (37.716082244868, -122.410612975888)
93493 121630 Undocumented 2 Myoporum laetum :: Myoporum 1 96x Valmar Ter 1 Unaccepted Street : Yard 14 Tree 1 Private 1     12 3x3   6005224.0 2092573.0 37.726102766942205 -122.42413354236 (37.7261027669422, -122.42413354236)
79542 115664 Undocumented 2 Myoporum laetum :: Myoporum 1 601x PERU AVE 2 Unaccepted Street : Yard 14 Tree 1 Private 1       3x3   6005068.0 2092670.0 37.726360298316294 -122.42467972288401 (37.7263602983163, -122.424679722884)
96239 115665 Undocumented 2 Myoporum laetum :: Myoporum 1 601x PERU AVE 3 Unaccepted Street : Yard 14 Tree 1 Private 1       3x3   6005068.0 2092670.0 37.726360298316294 -122.42467972288401 (37.7263602983163, -122.424679722884)
124140 115663 Undocumented 2 Myoporum laetum :: Myoporum 1 601x PERU AVE 1 Unaccepted Street : Yard 14 Tree 1 Private 1       3x3   6005068.0 2092670.0 37.726360298316294 -122.42467972288401 (37.7263602983163, -122.424679722884)
139585 115666 Undocumented 2 Myoporum laetum :: Myoporum 1 601x PERU AVE 4 Unaccepted Street : Yard 14 Tree 1 Private 1       3x3   6005068.0 2092670.0 37.726360298316294 -122.42467972288401 (37.7263602983163, -122.424679722884)
114729 96803 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 300X Melrose Ave 1 Unaccepted Street : Yard 14 Tree 1 Private 1     48     5998134.5 2095546.7 37.733865009274204 -122.448855518806 (37.7338650092742, -122.448855518806)
9968 173756 Undocumented 2 Pinus radiata :: Monterey Pine 3 1X Emil Ln 2 Unaccepted Street : Yard 14 Tree 1 Private 1       3x3   5996276.0 2095955.0 37.734879644622296 -122.455310374086 (37.7348796446223, -122.455310374086)
9970 173755 Undocumented 2 Pinus radiata :: Monterey Pine 3 1X Emil Ln 1 Unaccepted Street : Yard 14 Tree 1 Private 1       3x3   5996276.0 2095955.0 37.734879644622296 -122.455310374086 (37.7348796446223, -122.455310374086)
142115 121724 Undocumented 2 Prunus persica :: Peach 330 439X ARLINGTON ST 2 Unaccepted Street : Yard 14 Tree 1 Private 1           6003949.9 2096014.9 37.7354814316621 -122.42878329168998 (37.7354814316621, -122.42878329169)
94709 117610 Undocumented 2 Shrub :: Shrub 98 391 NEVADA ST 1 Unaccepted Street : Yard 14 Landscaping 2 Private 1       3x3   6008958.0 2096497.0 37.737087351465796 -122.41150238578501 (37.7370873514658, -122.411502385785)
145518 114586 Undocumented 2 Pinus radiata :: Monterey Pine 3 155x BRONTE ST 1 Unaccepted Street : Yard 14 Tree 1 Private 1     15 3x3 Permit Number 777226 6009330.0 2096609.0 37.737415738166206 -122.410224113722 (37.7374157381662, -122.410224113722)
105116 105651 Undocumented 2 Yucca elephantipes :: Giant Yucca 211 150 BRONTE ST 2 Unaccepted Street : Yard 14 Tree 1 Private 1     20     6009287.5 2096640.3 37.737499298818996 -122.410373266073 (37.737499298819, -122.410373266073)
115115 105652 Undocumented 2 Yucca elephantipes :: Giant Yucca 211 150 BRONTE ST 4 Unaccepted Street : Yard 14 Tree 1 Private 1     25     6009287.5 2096640.3 37.737499298818996 -122.410373266073 (37.737499298819, -122.410373266073)
145558 105653 Undocumented 2 Pinus radiata :: Monterey Pine 3 150 BRONTE ST 3 Unaccepted Street : Yard 14 Tree 1 Private 1     16   Permit Number 770978 6009287.5 2096640.3 37.737499298818996 -122.410373266073 (37.737499298819, -122.410373266073)
144060 33896 Permitted Site 1 Yucca elephantipes :: Giant Yucca 211 150 Bronte St 1 Unaccepted Street : Yard 14 Tree 1 Private 1   03/03/1997 12:00:00 AM 25   Permit Number 37869 6009276.59000035 2096641.35700735 37.737501589532705 -122.410411061845 (37.7375015895327, -122.410411061845)
94946 95436 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 2675 25th Ave 3 Unaccepted Street : Yard 14 Tree 1 Private 1     16     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
114267 95432 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2675 25th Ave 1 Unaccepted Street : Yard 14 Tree 1 Private 1     12     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
115606 95435 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2675 25th Ave 2 Unaccepted Street : Yard 14 Tree 1 Private 1     12     5988610.0 2097126.3 37.7376529013161 -122.48189987005101 (37.7376529013161, -122.481899870051)
82723 102522 Undocumented 2 Cedrus deodara :: Deodar Cedar 129 1X 31st St 2 Unaccepted Street : Yard 14 Tree 1 Private 1           5999966.2 2097547.4 37.7394630398899 -122.442666404233 (37.7394630398899, -122.442666404233)
106463 102521 Undocumented 2 Pinus radiata :: Monterey Pine 3 1X 31st St 1 Unaccepted Street : Yard 14 Tree 1 Private 1           5999966.2 2097547.4 37.7394630398899 -122.442666404233 (37.7394630398899, -122.442666404233)
93592 97535 Permitted Site 1 Pinus radiata :: Monterey Pine 3 300 Winfield St 1 Unaccepted Street : Yard 14 Tree 1 Private 1           6006649.9 2098038.3 37.7411896837785 -122.41959186825599 (37.7411896837785, -122.419591868256)
106956 97537 Permitted Site 1 Pinus radiata :: Monterey Pine 3 300 Winfield St 3 Unaccepted Street : Yard 14 Tree 1 Private 1           6006649.9 2098038.3 37.7411896837785 -122.41959186825599 (37.7411896837785, -122.419591868256)
144308 97536 Permitted Site 1 Pinus radiata :: Monterey Pine 3 300 Winfield St 2 Unaccepted Street : Yard 14 Tree 1 Private 1         Permit Number 768224 6006649.9 2098038.3 37.7411896837785 -122.41959186825599 (37.7411896837785, -122.419591868256)
76347 111157 Undocumented 2 Myoporum laetum :: Myoporum 1 201x EUGENIA AVE 4 Unaccepted Street : Yard 14 Tree 1 Private 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
82433 111159 Undocumented 2 Myoporum laetum :: Myoporum 1 201x EUGENIA AVE 6 Unaccepted Street : Yard 14 Tree 1 Private 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
87282 111156 Undocumented 2 Myoporum laetum :: Myoporum 1 201x EUGENIA AVE 3 Unaccepted Street : Yard 14 Tree 1 Private 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
97479 111154 Undocumented 2 Myoporum laetum :: Myoporum 1 201x EUGENIA AVE 1 Unaccepted Street : Yard 14 Tree 1 Private 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
100068 111158 Undocumented 2 Myoporum laetum :: Myoporum 1 201x EUGENIA AVE 5 Unaccepted Street : Yard 14 Tree 1 Private 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
114760 111155 Undocumented 2 Myoporum laetum :: Myoporum 1 201x EUGENIA AVE 2 Unaccepted Street : Yard 14 Tree 1 Private 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
106969 99110 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 94 Bernal Heights Blvd 1 Unaccepted Street : Yard 14 Tree 1 Private 1           6009548.4 2098143.7 37.741641931317396 -122.409577286243 (37.7416419313174, -122.409577286243)
99201 113439 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 401x POWHATTAN AVE 1 Unaccepted Street : Yard 14 Tree 1 Private 1     20 3x3   6008174.0 2098184.0 37.7416754763214 -122.41433236498301 (37.7416754763214, -122.414332364983)
104633 99112 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 80X Bradford St 1 Unaccepted Street : Yard 14 Tree 1 Private 1           6009564.7 2098208.3 37.741820222197596 -122.40952548431801 (37.7418202221976, -122.409525484318)
934 251409 Undocumented 2 Pinus radiata :: Monterey Pine 3 95x Andover St 1 Unaccepted Street : Yard 14 Tree 1 Private 1       3x3   6007642.0 2098274.0 37.741892697320296 -122.41617822056101 (37.7418926973203, -122.416178220561)
110332 109200 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 2401x CASTRO ST 7 Unaccepted Street : Yard 14 Tree 1 DPW 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
101119 109309 Undocumented 2 Pinus radiata :: Monterey Pine 3 349x MAYFLOWER ST 1 Unaccepted Street : Yard 14 Tree 1 Private 1           6009941.0 2098430.0 37.7424500403346 -122.40823998935801 (37.7424500403346, -122.408239989358)
102606 112729 Undocumented 2 Pinus radiata :: Monterey Pine 3 444 Franconia St 2 Unaccepted Street : Yard 14 Tree 1 Private 1     24     6009949.70212209 2098546.33795552 37.7427699663381 -122.40821810325701 (37.7427699663381, -122.408218103257)
127372 112739 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 444 Franconia St 3 Unaccepted Street : Yard 14 Tree 1 Private 1     30     6009949.70212209 2098546.33795552 37.7427699663381 -122.40821810325701 (37.7427699663381, -122.408218103257)
123850 107158 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 101x Elsie St 1 Unaccepted Street : Yard 14 Tree 1 Private 1     20     6007300.0 2098759.0 37.7432051631731 -122.417395111614 (37.7432051631731, -122.417395111614)
77461 107157 Undocumented 2 Pinus radiata :: Monterey Pine 3 301X Esmeralda Ave 1 Unaccepted Street : Yard 14 Tree 1 Private 1     28     6007313.0 2098782.0 37.7432690474632 -122.41735179051201 (37.7432690474632, -122.417351790512)
69268 116648 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 199x Esmeralda Ave 3 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
77674 116662 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 199x Esmeralda Ave 15 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
79334 116646 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 199x Esmeralda Ave 1 Unaccepted Street : Yard 14 Tree 1 DPW 2     2     6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
82496 116652 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 199x Esmeralda Ave 7 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
92156 116653 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 199x Esmeralda Ave 8 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
93306 116660 DPW Maintained 3 Sequoia sempervirens :: Coast Redwood 116 199x Esmeralda Ave 13 Unaccepted Street : Yard 14 Tree 1 DPW 2     8     6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
94398 116654 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 199x Esmeralda Ave 9 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
95215 116655 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 199x Esmeralda Ave 9 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
101447 116661 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 199x Esmeralda Ave 14 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
105354 116656 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 199x Esmeralda Ave 10 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
105412 116658 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 199x Esmeralda Ave 12 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
112048 116664 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 199x Esmeralda Ave 18 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
112164 116647 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 199x Esmeralda Ave 2 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
118788 116651 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 199x Esmeralda Ave 6 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
123372 116663 DPW Maintained 3 Araucaria araucana :: Monkey puzzle 154 199x Esmeralda Ave 16 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
129308 116650 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 199x Esmeralda Ave 5 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
139190 116659 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 199x Esmeralda Ave 12 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
145384 116657 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 199x Esmeralda Ave 11 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
145521 116649 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 199x Esmeralda Ave 4 Unaccepted Street : Yard 14 Tree 1 DPW 2           6007213.11808 2098808.04206 37.7433349329997 -122.417699002452 (37.7433349329997, -122.417699002452)
95391 113478 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 100x ESMERALDA AVE 5 Unaccepted Street : Yard 14 Tree 1 DPW 2     8     6006917.0 2098966.0 37.7437519821991 -122.418734104398 (37.7437519821991, -122.418734104398)
19241 116677 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 100 Esmeralda Ave 16 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
78555 116671 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 100 Esmeralda Ave 7 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
82247 116682 DPW Maintained 3 Pittosporum crassifolium :: Karo Tree 108 100 Esmeralda Ave 21 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
86166 116675 DPW Maintained 3 Quercus agrifolia :: Coast Live Oak 180 100 Esmeralda Ave 14 Unaccepted Street : Yard 14 Tree 1 DPW 2     14     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
89602 116672 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100 Esmeralda Ave 9 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
92622 116679 DPW Maintained 3 Yucca elephantipes :: Giant Yucca 211 100 Esmeralda Ave 18 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
95360 116668 DPW Maintained 3 Cedrus deodara :: Deodar Cedar 129 100x Esmeralda Ave 4 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
95944 116681 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 100 Esmeralda Ave 20 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
97063 116666 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100x Esmeralda Ave 2 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
110832 116665 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100x Esmeralda Ave 1 Unaccepted Street : Yard 14 Tree 1 DPW 2     25     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
113837 116669 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100 Esmeralda Ave 6 Unaccepted Street : Yard 14 Tree 1 DPW 2     20     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
123800 116680 DPW Maintained 3 Dodonaea viscosa :: Hop Bush 132 100 Esmeralda Ave 19 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
126736 116670 DPW Maintained 3 Quercus agrifolia :: Coast Live Oak 180 100 Esmeralda Ave 8 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
127057 116678 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 100 Esmeralda Ave 17 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
138825 116683 DPW Maintained 3 Pittosporum crassifolium :: Karo Tree 108 100 Esmeralda Ave 22 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
143384 116676 DPW Maintained 3 Aesculus californica :: California Buckeye 338 100 Esmeralda Ave 15 Unaccepted Street : Yard 14 Tree 1 DPW 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
144028 113477 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100x Esmeralda Ave 10 Unaccepted Street : Yard 14 Tree 1 DPW 2     24     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 71.686ms · Data source: data.sfgov.org