Street_Tree_List

Data source: data.sfgov.org

1,287 rows where qLegalStatus = 6

View and edit SQL

Suggested facets: SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
78 251199 Significant Tree 6 Pinus radiata :: Monterey Pine 3 900X 14th St 4 Front Yard : Yard 7 Tree 1 Private 1       3X3   6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
86 119601 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 34 4357x Mission St 3 Front Yard : Yard 7 Tree 1 Private 1         Permit Number 774415          
93 251198 Significant Tree 6 Pinus radiata :: Monterey Pine 3 900X 14th St 3 Front Yard : Yard 7 Tree 1 Private 1           6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
95 251197 Significant Tree 6 Pinus radiata :: Monterey Pine 3 900X 14th St 3 Front Yard : Yard 7 Tree 1 Private 1   03/22/2017 12:00:00 AM 3   Permit Number 779570 6002798.55883 2107703.57748 37.7675105430125 -122.43359899801901 (37.7675105430125, -122.433598998019)
96 251196 Significant Tree 6 Pinus radiata :: Monterey Pine 3 900X 14th St 2 Front Yard : Cutout 8 Tree 1 Private 1   03/22/2017 12:00:00 AM 3     6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
114 251216 Significant Tree 6 Myoporum laetum :: Myoporum 1 399X Townsend St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
118 251217 Significant Tree 6 Myoporum laetum :: Myoporum 1 399X Townsend St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
272 251264 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
277 251265 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
293 251262 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
300 251263 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3630x 19th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 779147          
363 119608 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 34 299x Avalon Ave 4 Front Yard : Yard 7 Tree 1 Private 1                    
484 205880 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 44 Mendosa Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     43 Width 3ft   5993348.04769 2101170.42115 37.7490314462559 -122.46581205990499 (37.7490314462559, -122.465812059905)
563 173951 Significant Tree 6 Tree(s) :: 17 2646 Union St 1 Front Yard : Cutout 8 Tree 1 Private 1   04/11/2017 12:00:00 AM 3 10x10 Permit Number 779549 6000338.0 2118225.0 37.796259749404605 -122.442865342513 (37.7962597494046, -122.442865342513)
595 119606 Significant Tree 6 Myoporum laetum :: Myoporum 1 299x Avalon Ave 2 Front Yard : Yard 7 Tree 1 Private 1                    
1025 251425 Significant Tree 6 Pittosporum spp :: Pittosporum spp 128 5016 Diamond Heights Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1           5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
1027 251426 Significant Tree 6 Pinus radiata :: Monterey Pine 3 5020 Diamond Heights Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1030 251424 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 5016 Diamond Heights Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
1159 112361 Significant Tree 6 Pittosporum undulatum :: Victorian Box 26 561X Folsom St 1 Front Yard : Yard 7 Tree 1 Private 1   11/16/2015 12:00:00 AM 3 10x30 Permit Number 775828 6013749.7362 2114198.9064599997 37.785960521430205 -122.396175324952 (37.7859605214302, -122.396175324952)
1310 251480 Significant Tree 6 Pinus radiata :: Monterey Pine 3 51 Peralta Ave 1 Front Yard : Yard 7 Tree 1 Private 1       3x3   6010641.0 2100362.0 37.747794064611604 -122.40595565659201 (37.7477940646116, -122.405955656592)
1337 251410 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 21 2777 Pine St 1 Front Yard : Cutout 8 Tree 1 Private 1       3x3 Permit Number 779015 6000658.0 2114782.0 37.7868244087741 -122.441510888069 (37.7868244087741, -122.441510888069)
1357 173636 Significant Tree 6 Tree(s) :: 17 2590 Pacific Ave 2 Front Yard : Yard 7 Tree 1 Private 1   05/11/2017 12:00:00 AM 3 3x3 Permit Number 779167 6001760.0 2117029.0 37.7930568116395 -122.43785923271999 (37.7930568116395, -122.43785923272)
1358 173635 Significant Tree 6 Tree(s) :: 17 2590 Pacific Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   05/11/2017 12:00:00 AM 3 3x3 Permit Number 779167 6001760.0 2117029.0 37.7930568116395 -122.43785923271999 (37.7930568116395, -122.43785923272)
1384 251515 Significant Tree 6 Pinus radiata :: Monterey Pine 3 99x Mountview Ct 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1409 251514 Significant Tree 6 Pinus radiata :: Monterey Pine 3 99x Mountview Ct 2 Back Yard : Yard 13 Tree 1 Private 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1598 251612 Significant Tree 6 Pinus radiata :: Monterey Pine 3 60R Amber Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1603 251636 Significant Tree 6 Pinus radiata :: Monterey Pine 3 22R Amethyst Way 1 Back Yard : Yard 13 Tree 1 Private 1           5999148.0 2100052.0 37.74629339412971 -122.44567543770901 (37.7462933941297, -122.445675437709)
1604 251632 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 14R Amethyst Way 1 Back Yard : Yard 13 Tree 1 Private 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1607 251602 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 108 44R Amber Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5999509.0 2100035.0 37.746267320465705 -122.444425925791 (37.7462673204657, -122.444425925791)
1608 251603 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 44R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999509.0 2100035.0 37.746267320465705 -122.444425925791 (37.7462673204657, -122.444425925791)
1609 251630 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 8R Amethyst Way 2 Back Yard : Yard 13 Tree 1 Private 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1611 251605 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 108 48R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999482.0 2100041.0 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345)
1615 251604 Significant Tree 6 Pinus radiata :: Monterey Pine 3 48R Amber Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5999482.0 2100041.0 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345)
1616 251607 Significant Tree 6 Pinus radiata :: Monterey Pine 3 52R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1623 251613 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 60R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1628 251629 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 8R Amethyst Way 1 Back Yard : Yard 13 Tree 1 Private 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1629 251631 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 8R Amethyst Way 3 Back Yard : Yard 13 Tree 1 Private 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1631 251621 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 72R Amber Dr 4 Back Yard : Yard 13 Tree 1 Private 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1632 251628 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 2R Amethyst Way 3 Back Yard : Yard 13 Tree 1 Private 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1637 251619 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 72R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1645 251626 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 2R Amethyst Way 1 Back Yard : Yard 13 Tree 1 Private 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1646 251633 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 14R Amethyst Way 2 Back Yard : Yard 13 Tree 1 Private 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1648 251606 Significant Tree 6 Pinus radiata :: Monterey Pine 3 52R Amber Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1650 251608 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 56R Amber Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1651 251609 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 56R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1654 251610 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 56R Amber Dr 3 Back Yard : Yard 13 Tree 1 Private 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1674 251651 Significant Tree 6 Jacaranda mimosifolia :: Jacaranda 52 3237 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6009049.0 2099828.0 37.746238652288106 -122.411423013741 (37.7462386522881, -122.411423013741)
1693 251659 Significant Tree 6 Olea europaea :: Olive Tree 41 1050 North Point St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1702 251658 Significant Tree 6 Olea europaea :: Olive Tree 41 1050 North Point St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1708 251660 Significant Tree 6 Pinus radiata :: Monterey Pine 3 1050 North Point St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1710 251657 Significant Tree 6 Pinus radiata :: Monterey Pine 3 1050 North Point St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1717 251661 Significant Tree 6 Olea europaea :: Olive Tree 41 3200X Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1719 251394 Significant Tree 6 Araucaria araucana :: Monkey puzzle 154 203 Corbett Ave 1 Front Yard : Yard 7 Tree 1 Private 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779803 6000094.0 2105620.0 37.7616357315689 -122.442804047122 (37.7616357315689, -122.442804047122)
1817 251719 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 116 1301 Clayton St 1 Side Yard : Yard 17 Tree 1 Private 1           5999055.0 2105304.0 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866)
1820 251716 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3929 19th St 1 Front Yard : Yard 7 Tree 1 Private 1           6003450.0 2104734.0 37.75939373993371 -122.431133769968 (37.7593937399337, -122.431133769968)
1930 252828 Significant Tree 6 Palm (unknown Genus) :: Palm Spp 161 3852 17th St 7 Front Yard : Yard 7 Tree 1 Private 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1932 252826 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 75 3852 17th St 5 Front Yard : Yard 7 Tree 1 Private 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1933 252830 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 75 3852 17th St 9 Front Yard : Yard 7 Tree 1 Private 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1935 252836 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 98 Prosper St 4 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1936 252824 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 75 3852 17th St 3 Front Yard : Yard 7 Tree 1 Private 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1938 252827 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 75 3852 17th St 6 Front Yard : Yard 7 Tree 1 Private 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1939 252822 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 3852 17th St 1 Front Yard : Yard 7 Tree 1 Private 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1947 252825 Significant Tree 6 Ilex spp :: Holly Species 163 3852 17th St 4 Front Yard : Yard 7 Tree 1 Private 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1950 252823 Significant Tree 6 Maytenus boaria :: Mayten 22 3852 17th St 2 Front Yard : Yard 7 Tree 1 Private 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1956 252838 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 99 Pond St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1957 252829 Significant Tree 6 Palm (unknown Genus) :: Palm Spp 161 3852 17th St 8 Front Yard : Yard 7 Tree 1 Private 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
2003 127110 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3201 Laguna St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23 Width 6ft   6003718.35126 2119752.0994 37.8006449063974 -122.431277695812 (37.8006449063974, -122.431277695812)
2059 173596 Significant Tree 6 Tree(s) :: 17 200 Howard St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3 Permit Number 779179 6014439.0 2115766.0 37.790301726009204 -122.393900378517 (37.7903017260092, -122.393900378517)
2105 251411 Significant Tree 6 Tree(s) :: 17 2751 Buchanan St 1 Front Yard : Cutout 8 Tree 1 Private 1   06/21/2017 12:00:00 AM 3 6x6 Permit Number 779887 6003497.0 2117826.0 37.7953437887296 -122.431906052505 (37.7953437887296, -122.431906052505)
2114 107983 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 15 2405x Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   6001231.007069999 2116743.47753 37.7922427464694 -122.43966909537599 (37.7922427464694, -122.439669095376)
2151 252916 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 101 Gold Mine Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001472.0 2098865.0 37.7431665844065 -122.437554349716 (37.7431665844065, -122.437554349716)
2169 89310 Significant Tree 6 Tree(s) :: 17 32 Lyon St 2 Front Yard : Yard 7 Tree 1 Private 1   06/28/2017 12:00:00 AM 3 3x3 Permit Number 780094 6000399.0 2109002.0 37.7709392449299 -122.441991937871 (37.7709392449299, -122.441991937871)
2180 251495 Significant Tree 6 Tree(s) :: 17 2448 Clay St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   06/28/2017 12:00:00 AM 3 10x10 Permit Number 780000 6003026.0 2116224.0 37.7909183964794 -122.433421252488 (37.7909183964794, -122.433421252488)
2184 89309 Significant Tree 6 Tree(s) :: 17 32 Lyon St 1 Front Yard : Yard 7 Tree 1 Private 1   06/28/2017 12:00:00 AM 3 3x3 Permit Number 780094 6000399.0 2109002.0 37.7709392449299 -122.441991937871 (37.7709392449299, -122.441991937871)
2196 119600 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 34 4357x Mission St 2 Front Yard : Yard 7 Tree 1 Private 1         Permit Number 774415          
2572 24480 Significant Tree 6 Salix babylonica :: Weeping Willow 182 108X Sussex St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2017 12:00:00 AM 3 3x3 Permit Number 780363 6002195.08262 2096706.93645 37.737282128351005 -122.434899824187 (37.737282128351, -122.434899824187)
2610 253145 Significant Tree 6 Pittosporum undulatum :: Victorian Box 26 801X Santiago St 1 Side Yard : Yard 17 Tree 1 Private 1           5990274.0 2099728.0 37.7448931297685 -122.47633667765699 (37.7448931297685, -122.476336677657)
2691 253165 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 180 1451 Bay St 3 Front Yard : Yard 7 Tree 1 Private 1       3x3   6003691.0 2120547.0 37.802825946660796 -122.431429119577 (37.8028259466608, -122.431429119577)
2712 253178 Significant Tree 6 Washingtonia filifera :: California Fan Palm 189 4450 24th St 2 Front Yard : Cutout 8 Tree 1 Private 1       Width 0ft   6000289.52403 2101701.02913 37.7508863393389 -122.441846529398 (37.7508863393389, -122.441846529398)
2734 253182 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 5157 Diamond Heights Blvd 1 Front Yard : Yard 7 Tree 1 Private 1           6000788.0 2100195.0 37.7467795353698 -122.44001478039101 (37.7467795353698, -122.440014780391)
2736 253183 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 5159 Diamond Heights Blvd 1 Front Yard : Yard 7 Tree 1 Private 1           6000808.0 2099903.0 37.745978911495 -122.439924689335 (37.745978911495, -122.439924689335)
2760 251575 Significant Tree 6 Pinus radiata :: Monterey Pine 3 300 Sussex St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   08/02/2017 12:00:00 AM 3 3x3 Permit Number 780395 6001194.0 2096647.0 37.737060666835205 -122.438356728037 (37.7370606668352, -122.438356728037)
2848 253255 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 270 Castenada Ave 2 Front Yard : Yard 7 Tree 1 Private 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2854 253253 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 5 99X Lopez Ave 4 Front Yard : Yard 7 Tree 1 Private 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2859 253251 Significant Tree 6 Pinus radiata :: Monterey Pine 3 99X Lopez Ave 2 Front Yard : Yard 7 Tree 1 Private 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2869 253250 Significant Tree 6 Pinus radiata :: Monterey Pine 3 99X Lopez Ave 1 Front Yard : Yard 7 Tree 1 Private 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2874 253252 Significant Tree 6 Pinus radiata :: Monterey Pine 3 99X Lopez Ave 3 Front Yard : Yard 7 Tree 1 Private 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
3037 253283 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 44 673 San Jose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6005929.0 2099335.0 37.7447094953859 -122.422176588207 (37.7447094953859, -122.422176588207)
3059 126695 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2829 Divisadero St 2 Front Yard : Yard 7 Tree 1 Private 1     11 10x10 Permit Number 779774 6000551.43021 2118023.61416 37.7957189625051 -122.44211236900601 (37.7957189625051, -122.442112369006)
3138 253254 Significant Tree 6 Pinus radiata :: Monterey Pine 3 270 Castenada Ave 1 Front Yard : Yard 7 Tree 1 Private 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
3147 253098 Significant Tree 6 Pinus radiata :: Monterey Pine 3 1290 Portola Dr 2 Sidewalk: Property side : Yard 9 Tree 1 DPW 2   08/22/2017 12:00:00 AM 3 3x3   5994035.0 2097938.0 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736)
3158 253097 Significant Tree 6 Pinus radiata :: Monterey Pine 3 1290 Portola Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1 DPW 4 08/22/2017 12:00:00 AM 3 3x3   5994035.0 2097938.0 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736)
3204 253366 Significant Tree 6 Ficus carica :: Edible Fig 201 20 Laussat St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6004582.0 2109434.0 37.772362894278395 -122.427553605007 (37.7723628942784, -122.427553605007)
3256 253373 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 44 78 Peralta Ave 1 Front Yard : Yard 7 Tree 1 Private 1       3x3   6010457.0 2100357.0 37.7477700431666 -122.406591570174 (37.7477700431666, -122.406591570174)
3283 253384 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 203 55 Cerritos Ave 1 Front Yard : Yard 7 Tree 1 Private 1       10x10   5992588.0 2092941.0 37.7263916542788 -122.46784182223999 (37.7263916542788, -122.46784182224)
3361 253428 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 3 Valletta Ct 1 Side Yard : Cutout 18 Tree 1 Private 1       6x10   5999319.0 2096479.0 37.736492551957895 -122.44482735214198 (37.7364925519579, -122.444827352142)
3534 253482 Significant Tree 6 Juniperus chinensis :: Juniper 19 2179 41st Ave 1 Front Yard : Yard 7 Tree 1 Private 1       3x5   5983532.0 2100331.0 37.74615550514321 -122.49969345420799 (37.7461555051432, -122.499693454208)
3549 253470 Significant Tree 6 Juniperus chinensis :: Juniper 19 3 Valletta Ct 2 Side Yard : Cutout 18 Tree 1 Private 1       6x10   5999319.0 2096479.0 37.736492551957895 -122.44482735214198 (37.7364925519579, -122.444827352142)
3557 253471 Significant Tree 6 Sequoiadendron giganteum :: Sierra Redwood 212 17 Valletta Ct 1 Side Yard : Cutout 18 Tree 1 Private 1       6x10   5999337.0 2096545.0 37.7366747995559 -122.444769861358 (37.7366747995559, -122.444769861358)
3662 253513 Significant Tree 6 Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 216 1545 05th Ave 1 Front Yard : Yard 7 Tree 1 Private 1   08/14/2012 12:00:00 AM   3x3 Permit Number 768941 5994803.920580001 2105050.88998 37.7597700982665 -122.461058902115 (37.7597700982665, -122.461058902115)

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