Street_Tree_List

Data source: data.sfgov.org

176 rows where qSiteInfo = 14

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                    
697 251362 Undocumented 2 Pinus Spp :: Pine Spp 105 1300X Stanyan St 1 Unaccepted Street : Yard 14 Tree 1 Private 1       3x3   5997565.0 2104877.0 37.7594511396077 -122.451497194349 (37.7594511396077, -122.451497194349)
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)
3355 253433 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 3 Vulcan Stwy 1 Unaccepted Street : Yard 14 Tree 1 Private 1       3x3   6000640.0 2106231.0 37.7633444989385 -122.440959493883 (37.7633444989385, -122.440959493883)
3496 253449 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 330 Twin Peaks Blvd 1 Unaccepted Street : Yard 14 Tree 1 Private 1       10x10   5998688.0 2103995.0 37.7570936308358 -122.44754983450599 (37.7570936308358, -122.447549834506)
3497 247942 Planning Code 138.1 required 4 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 29 Joy St 5 Unaccepted Street : Yard 14 Tree 1 DPW 2     3   Permit Number 775404 6010292.72224 2098904.67919 37.7437730949632 -122.40705728398399 (37.7437730949632, -122.407057283984)
3501 247943 Planning Code 138.1 required 4 Maytenus boaria :: Mayten 22 29 Joy St 6 Unaccepted Street : Yard 14 Tree 1 DPW 2     2   Permit Number 775404 6010304.2598 2098903.51059 37.7437705318851 -122.407017307297 (37.7437705318851, -122.407017307297)
3506 247939 Planning Code 138.1 required 4 Quercus agrifolia :: Coast Live Oak 180 29 Joy St 2 Unaccepted Street : Yard 14 Tree 1 DPW 2     12   Permit Number 775404 6010258.299769999 2098917.5156900003 37.7438064148349 -122.40717721395 (37.7438064148349, -122.40717721395)
3510 247941 Planning Code 138.1 required 4 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 29 Joy St 4 Unaccepted Street : Yard 14 Tree 1 DPW 2     5   Permit Number 775404 6010287.82636 2098909.7574 37.743786764646 -122.40707457072901 (37.743786764646, -122.407074570729)
3511 247940 Planning Code 138.1 required 4 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 29 Joy St 3 Unaccepted Street : Yard 14 Tree 1 DPW 2     5   Permit Number 775404 6010280.31746 2098909.2881400003 37.7437850559498 -122.407100501782 (37.7437850559498, -122.407100501782)
3513 247938 Planning Code 138.1 required 4 Prunus cerasifera :: Cherry Plum 16 29 Joy St 1 Unaccepted Street : Yard 14 Tree 1 DPW 2     9   Permit Number 775404 6010254.90659 2098918.71089 37.7438095066969 -122.407189031056 (37.7438095066969, -122.407189031056)
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                    
4716 253674 DPW Maintained 3 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 600 x Sanchez St 2 Unaccepted Street : Yard 14 Tree 1 DPW 2       3x3   6003598.0 2104743.0 37.75942683738779 -122.43062255590701 (37.7594268373878, -122.430622555907)
4727 253673 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 600 x Sanchez St 1 Unaccepted Street : Yard 14 Tree 1 DPW 2       3x3   6003598.0 2104743.0 37.75942683738779 -122.43062255590701 (37.7594268373878, -122.430622555907)
4884 253710 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1 Monument Way 4 Unaccepted Street : Yard 14 Tree 1 Private 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4891 253709 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1 Monument Way 3 Unaccepted Street : Yard 14 Tree 1 Private 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4893 253707 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1 Monument Way 1 Unaccepted Street : Yard 14 Tree 1 Private 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4898 253711 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1 Monument Way 5 Unaccepted Street : Yard 14 Tree 1 Private 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4906 253708 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1 Monument Way 2 Unaccepted Street : Yard 14 Tree 1 Private 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4913 97358 Permitted Site 1 Tree(s) :: 17   8 Unaccepted Street : Yard 14 Tree 1 Private 1                    
5081 253792 Undocumented 2 Myoporum laetum :: Myoporum 1 1698X 08th Ave 2 Unaccepted Street : Yard 14 Tree 1 DPW 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5085 253795 Undocumented 2 Myoporum laetum :: Myoporum 1 1698X 08th Ave 5 Unaccepted Street : Yard 14 Tree 1 DPW 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5092 253791 Undocumented 2 Myoporum laetum :: Myoporum 1 1698X 08th Ave 1 Unaccepted Street : Yard 14 Tree 1 DPW 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5097 253793 Undocumented 2 Myoporum laetum :: Myoporum 1 1698X 08th Ave 3 Unaccepted Street : Yard 14 Tree 1 DPW 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5099 253794 Undocumented 2 Myoporum laetum :: Myoporum 1 1698X 08th Ave 4 Unaccepted Street : Yard 14 Tree 1 DPW 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
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                    
7555 107448 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1111x Chestnut St 1 Unaccepted Street : Yard 14 Tree 1 Private 1     50     6006408.68895 2120404.8626200003 37.80258932431129 -122.42201440535801 (37.8025893243113, -122.422014405358)
8657 97354 Permitted Site 1 Tree(s) :: 17   4 Unaccepted Street : Yard 14 Tree 1 Private 1                    
8668 107450 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1140x Chestnut St 1 Unaccepted Street : Yard 14 Tree 1 Private 1     60     6006380.05181 2120425.48408 37.802644330436394 -122.42211497023399 (37.8026443304364, -122.422114970234)
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)
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                    
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)
26646 107449 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1130x CHESTNUT ST 1 Unaccepted Street : Yard 14 Tree 1 Private 1     60     6006351.9 2120450.9 37.802712528214705 -122.42221419659701 (37.8027125282147, -122.422214196597)
42966 112248 DPW Maintained 3 Acer spp :: Maple 158 1799X TAYLOR ST 1 Unaccepted Street : Yard 14 Tree 1 DPW 2     15     6008739.0 2118839.0 37.79842100686071 -122.413839504702 (37.7984210068607, -122.413839504702)
43848 99190 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1155@Greenwich Battery St 3 Unaccepted Street : Yard 14 Tree 1 Private 1   04/24/2012 12:00:00 AM 13 Park Permit Number 768770 6012236.89935 2120056.2938 37.801959219714 -122.401821238566 (37.801959219714, -122.401821238566)
49637 114270 Undocumented 2 Pinus radiata :: Monterey Pine 3 27x ESMERALDA AVE 2 Unaccepted Street : Yard 14 Tree 1 Private 1       3x3   6006799.0 2098981.0 37.743786524331 -122.41914318493001 (37.743786524331, -122.41914318493)
62864 108717 Undocumented 2 Cedrus atlantica :: Atlas Cedar 304 1141 Chestnut St 3 Unaccepted Street : Yard 14 Tree 1 Private 1     7 3x3   6006358.32966 2120394.6178099997 37.802558354332795 -122.422187945742 (37.8025583543328, -122.422187945742)
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)
72511 98376 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 199X Cragmont Ave 1 Unaccepted Street : Yard 14 Tree 1 Private 1           5992899.0 2101153.0 37.7489576989052 -122.467363590244 (37.7489576989052, -122.467363590244)
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)
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)
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)
78442 99274 Undocumented 2 Pinus radiata :: Monterey Pine 3 16 Joy St 1 Unaccepted Street : Yard 14 Tree 1 Private 1       3x3 Permit Number 768828 6010347.9 2098933.4 37.7438550437031 -122.406868515265 (37.7438550437031, -122.406868515265)
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)
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)
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)
80443 105069 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 49X Esmeralda Ave 2 Unaccepted Street : Yard 14 Tree 1 Private 1         Permit Number 771039 6006861.0 2099026.0 37.7439135755866 -122.41893199410299 (37.7439135755866, -122.418931994103)
81729 109625 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 312x FILBERT ST 1 Unaccepted Street : Yard 14 Tree 1 Private 1     14     6011362.9 2120079.8 37.801974948341 -122.40484736081001 (37.801974948341, -122.40484736081)
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)
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)
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)
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)
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)
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)
83991 96537 Permitted Site 1 Tree(s) :: 17 950X Kansas St 1 Unaccepted Street : Yard 14 Tree 1 Private 1   05/25/2011 12:00:00 AM     Permit Number 767960 6011564.8 2103917.5 37.7576083124183 -122.403011228478 (37.7576083124183, -122.403011228478)
84377 107372 Undocumented 2 Acer palmatum :: Japanese Maple 175 305x GREENWICH ST 1 Unaccepted Street : Yard 14 Tree 1 Private 1     20     6011370.0 2120243.0 37.8024234525216 -122.40483428789801 (37.8024234525216, -122.404834287898)
85549 122555 Permitted Site 1 Tree(s) :: 17 1910X Castro St 1 Unaccepted Street : Yard 14 Tree 1 Private 1           6002640.0 2099906.0 37.746091265221295 -122.433590100931 (37.7460912652213, -122.433590100931)
85877 103517 Permitted Site 1 Prunus spp :: Cherry 84 55X MacOndray Ln 1 Unaccepted Street : Yard 14 Tree 1 Private 1         Permit Number 770452 6008432.0 2119159.0 37.7992824016355 -122.41492448290899 (37.7992824016355, -122.414924482909)
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)
86227 112615 Undocumented 2 Pinus radiata :: Monterey Pine 3 1798x 22ND ST 2 Unaccepted Street : Yard 14 Tree 1 Private 1   05/02/2016 12:00:00 AM 3     6012787.0 2103832.0 37.7574417223043 -122.398778335858 (37.7574417223043, -122.398778335858)
86301 105759 Permitted Site 1 Tree(s) :: 17 1910X CASTRO ST 4 Unaccepted Street : Yard 14 Tree 1 Private 1   04/10/2014 12:00:00 AM 15   Permit Number 771977 6002617.0 2100030.0 37.746430435118796 -122.43367849259899 (37.7464304351188, -122.433678492599)
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)
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)
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)
88788 117626 Undocumented 2 Pinus radiata :: Monterey Pine 3 890x VERMONT ST 3 Unaccepted Street : Yard 14 Tree 1 Private 1           6011292.0 2104239.0 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201)
89419 115524 Permitted Site 1 Tree(s) :: 17 25 FRANCONIA ST 1 Unaccepted Street : Yard 14 Tree 1 Private 1   07/12/2016 12:00:00 AM 3 3x3 Permit Number 777451 6010006.0 2099954.0 37.746638251201404 -122.408122694659 (37.7466382512014, -122.408122694659)
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)
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)
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)
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)
92684 115379 Undocumented 2 Tree(s) :: 17 4004 20TH ST   Unaccepted Street : Yard 14 Tree 1 Private 1       3x3   6003604.0 2104237.0 37.758037821948 -122.43056569919399 (37.758037821948, -122.430565699194)
92918 110864 Undocumented 2 Aesculus spp :: Horsechestnut 504 1798x 22ND ST 1 Unaccepted Street : Yard 14 Tree 1 Private 1           6012787.0 2103832.0 37.7574417223043 -122.398778335858 (37.7574417223043, -122.398778335858)
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)
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)
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)
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)
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)
94710 101366 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 1348 Noe St   Unaccepted Street : Yard 14 Tree 1 Private 1     24   Owner: Brent Sommer 519-1119 nocmout@gmail.com 6003163.2 2100416.0 37.7475212781449 -122.43181735246 (37.7475212781449, -122.43181735246)
94793 106979 DPW Maintained 3 Prunus domestica 'Green Gage' :: Green Gage Plum 506 801X Clipper St 1 Unaccepted Street : Yard 14 Tree 1 DPW 2     24     5999765.50041 2100345.59515 37.7471347718267 -122.443561289165 (37.7471347718267, -122.443561289165)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
98413 107527 Undocumented 2 Populus alba :: White Poplar 408 2540x LYON ST 1 Unaccepted Street : Yard 14 Tree 1 Private 1     30   Permit Number 774117 5999227.0 2117510.0 37.7942331479636 -122.44665814715599 (37.7942331479636, -122.446658147156)
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)
99604 106503 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3974 22nd St 1 Unaccepted Street : Yard 14 Tree 1 Private 1         Permit Number 773286 6002049.0 2102947.0 37.754407578182004 -122.435851245675 (37.754407578182, -122.435851245675)
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)
100274 99610 Undocumented 2 Tree(s) :: 17 111 Corwin St   Unaccepted Street : Yard 14 Landscaping 2 Private 1           6000616.0 2104331.0 37.7581261988062 -122.44090619353999 (37.7581261988062, -122.44090619354)
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)

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 61.298ms · Data source: data.sfgov.org