Street_Tree_List

Data source: data.sfgov.org

189,144 rows sorted by PlotSize

View and edit SQL

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▼ PermitNotes XCoord YCoord Latitude Longitude Location
51 60867 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/1983 12:00:00 AM     Permit Number 20649          
57 44642 Permitted Site 1 Tree(s) :: 17   60 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
59 44994 Permitted Site 1 Tree(s) :: 17   106 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
74 188665 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 2175X Palou Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     37     6011669.71313 2097723.45025 37.740606653987705 -122.402212916691 (37.7406066539877, -122.402212916691)
77 49739 Permitted Site 1 Tree(s) :: 17 145 Missouri St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/22/2017 12:00:00 AM 3   Permit Number 779552 6013462.1222 2106403.54987 37.764540227980206 -122.396623740816 (37.7645402279802, -122.396623740816)
84 36641 Permitted Site 1 Robinia x ambigua :: Locust 33   13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/1998 12:00:00 AM     Permit Number 39461          
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)
102 98037 Private 5 Pittosporum undulatum :: Victorian Box 26 1384X Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/23/2017 12:00:00 AM 3   Permit Number 767782 6001197.2582 2110764.9293 37.775825263482105 -122.439357134105 (37.7758252634821, -122.439357134105)
103 117428 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/14/2016 12:00:00 AM 3   Permit Number 776915          
104 251210 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1170 Ingalls St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/02/1992 12:00:00 AM                
121 59839 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 1201 Palou Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/10/1981 12:00:00 AM 3   Permit Number 19293 6016946.5018 2093669.1216 37.729767407645895 -122.383685429115 (37.7297674076459, -122.383685429115)
125 119758 Undocumented 2 Maytenus boaria :: Mayten 22 151X Octavia St Frontage West 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
130 66855 Permitted Site 1 Maytenus boaria :: Mayten 22 2041 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/15/1991 12:00:00 AM 8   Permit Number 30161 5998071.2779 2109932.9259 37.7733624072524 -122.450110663343 (37.7733624072524, -122.450110663343)
142 251241 Undocumented 2 Cupressocyparis leylandii :: Leyland Cypress 34 2305 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5998495.0 2111363.0 37.777313260379 -122.44874797929701 (37.777313260379, -122.448747979297)
147 58021 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4026 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 12:07:00 PM 3   Permit Number 16988 5983218.6194 2106316.5419 37.7625717348083 -122.50121971656999 (37.7625717348083, -122.50121971657)
151 36617 Permitted Site 1 Robinia x ambigua :: Locust 33   8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/1998 12:00:00 AM     Permit Number 39461          
168 179480 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 100 Serrano Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     5989599.0 2090767.0 37.7202493457345 -122.478015677124 (37.7202493457345, -122.478015677124)
171 251242 Undocumented 2 Cupressocyparis leylandii :: Leyland Cypress 34 2449 Golden Gate Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           5997716.0 2111278.0 37.7770352956542 -122.451436646998 (37.7770352956542, -122.451436646998)
172 48332 Permitted Site 1 Tree(s) :: 17   142 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
190 57209 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 2898 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/15/2014 12:00:00 AM 3   Permit Number 773671 6000999.92024 2115926.87738 37.7899874194288 -122.440410066565 (37.7899874194288, -122.440410066565)
197 251245 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 701 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/04/1992 12:00:00 AM       6002463.96916 2095671.24377 37.73445361741221 -122.433896153002 (37.7344536174122, -122.433896153002)
204 61453 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/22/1984 12:00:00 AM     Permit Number 21392          
214 251244 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 99 Grove St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5   05/29/2013 12:00:00 AM       6007340.02606 2111591.01475 37.778441154342296 -122.41816626519301 (37.7784411543423, -122.418166265193)
235 45975 Permitted Site 1 Tree(s) :: 17   132 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
268 46773 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 35 San Juan Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/03/2017 12:00:00 AM 3   Permit Number 779460 6001741.72526 2092006.08473 37.7243489150655 -122.43613098976101 (37.7243489150655, -122.436130989761)
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          
279 48153 Permitted Site 1 Tree(s) :: 17   263 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
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          
294 251266 Private 5 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 10x Paloma Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
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          
308 46059 Permitted Site 1 Tree(s) :: 17   101 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
316 67789 Permitted Site 1 Tree(s) :: 17 7 4384 St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/17/1992 12:00:00 AM     Permit Number 31429          
320 48259 Permitted Site 1 Tree(s) :: 17   123 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
321 65143 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/1989 12:00:00 AM     Permit Number 27118          
363 119608 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 34 299x Avalon Ave 4 Front Yard : Yard 7 Tree 1 Private 1                    
403 65940 Planning Code 138.1 required 4 Liquidambar styraciflua :: American Sweet Gum 62 620 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/1990 12:00:00 AM 8   Permit Number 28961 6007431.46715 2113367.23378 37.78332336932171 -122.41797588370702 (37.7833233693217, -122.417975883707)
444 44838 Permitted Site 1 Tree(s) :: 17   12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
467 85277 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 801 Holladay Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2007 12:00:00 AM     Permit Number 49566          
469 85530 Permitted Site 1 Eriobotrya deflexa :: Bronze Loquat 49 101X 12th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/29/2007 12:00:00 AM 6     6007333.48731 2109350.5044400003 37.772288880253704 -122.418030010287 (37.7722888802537, -122.418030010287)
479 85531 DPW Maintained 3 Eriobotrya deflexa :: Bronze Loquat 49 101X 12th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/29/2007 12:00:00 AM 6     6007317.968280001 2109362.68703 37.7723214572932 -122.418084555959 (37.7723214572932, -122.418084555959)
487 85532 DPW Maintained 3 Pyrus calleryana :: Ornamental Pear 9 101X 12th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/29/2007 12:00:00 AM 6     6007270.64018 2109417.23244 37.7724685621036 -122.418252136526 (37.7724685621036, -122.418252136526)
497 14419 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 2X Masonic Ave 7 Median : Cutout 11 Tree 1 DPW 2     35     5998835.1676 2113089.5942 37.7820734871416 -122.447695558807 (37.7820734871416, -122.447695558807)
501 251171 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 201X Cargo Way 37 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2017 11:21:00 AM 3              
504 81687 Permitted Site 1 Magnolia spp :: Magnolia 89 210 Frederick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/10/2017 12:00:00 AM 3   Permit Number 777040 5999000.68344445 2107685.40393875 37.7672444226119 -122.446733986311 (37.7672444226119, -122.446733986311)
509 38234 Permitted Site 1 Geijera parviflora :: Australian Willow 68 0 16th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/1998 12:00:00 AM     Permit Number 40352          
515 48129 Permitted Site 1 Tree(s) :: 17   297 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
536 45913 Permitted Site 1 Tree(s) :: 17   59 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
549 251321 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 100X Monument Way 1 Unaccepted Street : Yard 14 Tree 1 Private 1                    
554 31894 Permitted Site 1 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 333 12th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/1995 12:00:00 AM 6   Permit Number 35323 6008421.36423 2108725.6861900003 37.7706344442547 -122.41422271959999 (37.7706344442547, -122.4142227196)
580 48268 Permitted Site 1 Tree(s) :: 17   132 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
595 119606 Significant Tree 6 Myoporum laetum :: Myoporum 1 299x Avalon Ave 2 Front Yard : Yard 7 Tree 1 Private 1                    
617 57850 Permitted Site 1 Tree(s) :: 17 1700 S. Amaylett Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/14/1977 12:00:00 AM     Permit Number 16791          
624 70356 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 1912 Polk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/07/1994 12:00:00 AM 5     6006535.5562 2117410.9094 37.7943758388735 -122.42136264060801 (37.7943758388735, -122.421362640608)
632 44905 Permitted Site 1 Tree(s) :: 17   139 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
633 48204 Permitted Site 1 Tree(s) :: 17   47 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
675 47038 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 716 Walter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/02/2002 12:00:00 AM     Permit Number 45030          
682 251365 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 138x Gladeview Way 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1                    
689 48269 Permitted Site 1 Tree(s) :: 17   120 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
692 176334 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 287 Hester Ave 7 Side Yard : Yard 17 Tree 1 Private 1     34     6012223.87562 2087782.5469900002 37.713341893097 -122.399599040764 (37.713341893097, -122.399599040764)
701 176335 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 287 Hester Ave 5 Side Yard : Yard 17 Tree 1 Private 1     17     6012233.93602 2087774.2056900002 37.7133195503322 -122.399563683027 (37.7133195503322, -122.399563683027)
705 105051 Permitted Site 1 Tree(s) :: 17 1244 Masonic Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/17/2017 12:00:00 AM 3   Permit Number 779926 5999515.4 2108544.9 37.769633771891606 -122.445015457708 (37.7696337718916, -122.445015457708)
712 251366 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 138x Gladeview Way 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1                    
713 251364 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 138x Gladeview Way 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1                    
726 44958 Permitted Site 1 Tree(s) :: 17   82 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
729 48266 Permitted Site 1 Tree(s) :: 17   130 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
731 251375 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 3 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
747 251378 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 6 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
749 251374 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 2 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
757 251377 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 5 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
763 251373 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 1 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
764 251379 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 7 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
785 251376 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 401 Portola Dr 4 Median : Yard 3 Tree 1 DPW 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
793 65876 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/1990 12:00:00 AM     Permit Number 28874          
794 212187 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 720 Bosworth St 1 Sidewalk: Property side : Yard 9 Tree 1 DPW 2     16     6002096.28779 2095466.30888 37.733870041163 -122.435152693763 (37.733870041163, -122.435152693763)
796 212189 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 720 Bosworth St 3 Sidewalk: Property side : Yard 9 Tree 1 DPW 2     16     6002068.0773599995 2095471.6867 37.7338832054473 -122.435250610137 (37.7338832054473, -122.435250610137)
797 212191 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 720 Bosworth St 5 Sidewalk: Property side : Yard 9 Tree 1 DPW 2     16     6002043.865019999 2095478.6742 37.7339010165159 -122.435334819059 (37.7339010165159, -122.435334819059)
801 212193 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 720 Bosworth St 7 Sidewalk: Property side : Yard 9 Tree 1 DPW 2     14     6002021.19403 2095482.3719 37.7339098820273 -122.43541346386002 (37.7339098820273, -122.43541346386)
802 64866 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 2185 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/02/1989 12:00:00 AM 13   Permit Number 25884 5997401.9097 2109840.7512 37.773070992957 -122.45241943675501 (37.773070992957, -122.452419436755)
809 46145 Permitted Site 1 Tree(s) :: 17   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2001 12:00:00 AM     Permit Number 44490          
810 212202 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 800 Bosworth St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     6001677.26505 2095571.4535400001 37.734134940976 -122.43660890297501 (37.734134940976, -122.436608902975)
814 44650 Permitted Site 1 Tree(s) :: 17   70 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
833 251388 Permitted Site 1 Brahea edulis :: Guadalupe Palm 115 1658 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/19/2017 12:00:00 AM 3     6014992.0461800005 2094842.7959900002 37.732881854221894 -122.39052423440701 (37.7328818542219, -122.390524234407)
864 37366 Permitted Site 1 Melaleuca quinquenervia :: Cajeput 50 125 Street 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/15/1998 12:00:00 AM     Permit Number 39871          
870 117001 DPW Maintained 3 :: 54 1X Bernal Heights Blvd 1 Front Yard : Yard 7 Tree 1 DPW 2                    
921 30278 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 128          
937 45898 Permitted Site 1 Tree(s) :: 17   26 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
940 51496 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1350 REVISED Fell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/16/2005 12:00:00 AM     Permit Number 47808 6000958.86990754 2110035.78536621 37.773809648853 -122.44012948036101 (37.773809648853, -122.440129480361)
952 48321 Permitted Site 1 Tree(s) :: 17   187 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
953 46022 Permitted Site 1 Tree(s) :: 17   215 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
959 83601 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1 Jones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/22/2008 12:00:00 AM 5     6009088.96788 2112689.1650900003 37.7815547005346 -122.41219362785499 (37.7815547005346, -122.412193627855)
1010 45949 Permitted Site 1 Tree(s) :: 17   146 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/06/2001 12:00:00 AM     Permit Number 44451          
1015 48313 Permitted Site 1 Tree(s) :: 17   179 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2002 12:00:00 AM     Permit Number 45761          
1023 24311 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2639 Hyde St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20     6006902.669840001 2121389.92308 37.8053218972443 -122.420374939461 (37.8053218972443, -122.420374939461)
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)
1038 57888 Permitted Site 1 Tree(s) :: 17 2382 Fost St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/04/1977 12:00:00 AM     Permit Number 16841          

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