Street_Tree_List

Data source: data.sfgov.org

863 rows where qSiteInfo = 17 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▲ PermitNotes XCoord YCoord Latitude Longitude Location
132813 132813 201611 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 98 Jerrold Ave 1 Side Yard : Yard 17 Tree 1 Private 1     2 Width 9ft   6020793.34161 2092957.5019 37.7280253184122 -122.37033713297501 (37.7280253184122, -122.370337132975)
162455 162455 195979 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 900 Phelps St 1 Side Yard : Yard 17 Tree 1 Private 1     30 Width 9ft   6014704.25324 2097268.53042 37.739526454869704 -122.39168875963999 (37.7395264548697, -122.39168875964)
29484 29484 190646 Undocumented 2 Heteromeles arbutifolia :: Toyon 322 230 Middle Point Rd 4 Side Yard : Yard 17 Tree 1 Private 1     8 Width 8ft   6018218.4425 2096359.44868 37.7372247426365 -122.379474956329 (37.7372247426365, -122.379474956329)
33505 33505 193829 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 900 Phelps St 13 Side Yard : Yard 17 Tree 1 Private 1     27 Width 8ft   6014453.31745 2096931.20635 37.738586300018504 -122.392532803946 (37.7385863000185, -122.392532803946)
39127 39127 247002 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 401 Valley St 2 Side Yard : Yard 17 Tree 1 Private 1     10 Width 8ft   6003223.72191 2099183.9093400002 37.7441416748926 -122.431520126078 (37.7441416748926, -122.431520126078)
41147 41147 247005 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 401 Valley St 5 Side Yard : Yard 17 Tree 1 Private 1     2 Width 8ft   6003245.1291 2099189.5781900003 37.7441584535423 -122.431446509373 (37.7441584535423, -122.431446509373)
48630 48630 247006 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 401 Valley St 6 Side Yard : Yard 17 Tree 1 Private 1     8 Width 8ft   6003253.92203 2099189.92697 37.7441599095582 -122.43141613026 (37.7441599095582, -122.43141613026)
50991 50991 203317 Undocumented 2 Acer palmatum :: Japanese Maple 175 1515 16th Ave 1 Side Yard : Yard 17 Tree 1 Private 1     6 Width 8ft   5991175.14948 2105039.99944 37.759530710094296 -122.47360811363899 (37.7595307100943, -122.473608113639)
57193 57193 247001 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 401 Valley St 1 Side Yard : Yard 17 Tree 1 Private 1     5 Width 8ft   6003204.32988 2099186.4435 37.744147533977795 -122.431587360294 (37.7441475339778, -122.431587360294)
62478 62478 247003 Undocumented 2 Juniperus chinensis :: Juniper 19 401 Valley St 3 Side Yard : Yard 17 Tree 1 Private 1     6 Width 8ft   6003236.004319999 2099186.05464 37.744148261529006 -122.431477809352 (37.744148261529, -122.431477809352)
137129 137129 203318 Undocumented 2 Acer palmatum :: Japanese Maple 175 1515 16th Ave 2 Side Yard : Yard 17 Tree 1 Private 1     4 Width 8ft   5991179.11324 2105030.95188 37.7595060974465 -122.473593745149 (37.7595060974465, -122.473593745149)
154255 154255 247009 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 401 Valley St 9 Side Yard : Yard 17 Tree 1 Private 1     13 Width 8ft   6003278.48209 2099193.13161 37.744170100676996 -122.431331435716 (37.744170100677, -122.431331435716)
157854 157854 203451 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 1515 16th Ave 4 Side Yard : Yard 17 Tree 1 Private 1     8 Width 8ft   5991183.11857 2105012.94014 37.7594568739424 -122.473578579008 (37.7594568739424, -122.473578579008)
170593 170593 247004 Undocumented 2 Aesculus californica :: California Buckeye 338 401 Valley St 4 Side Yard : Yard 17 Tree 1 Private 1     8 Width 8ft   6003237.98739 2099191.84637 37.7441642766696 -122.43147136571501 (37.7441642766696, -122.431471365715)
173419 173419 203452 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 1515 16th Ave 5 Side Yard : Yard 17 Tree 1 Private 1     10 Width 8ft   5991186.2272 2105007.12865 37.7594410971589 -122.473567404026 (37.7594410971589, -122.473567404026)
173508 173508 247008 Undocumented 2 Callistemon 'Jeffers' :: Purple bottlebrush 395 401 Valley St 8 Side Yard : Yard 17 Tree 1 Private 1     5 Width 8ft   6003270.60035 2099185.34055 37.74414826155 -122.43135813298599 (37.74414826155, -122.431358132986)
175990 175990 203450 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 1515 16th Ave 3 Side Yard : Yard 17 Tree 1 Private 1     9 Width 8ft   5991181.21192 2105021.0246 37.7594789613077 -122.47358576280001 (37.7594789613077, -122.4735857628)
179168 179168 247007 Undocumented 2 Callistemon salignus :: White flowering bottlebrush 557 401 Valley St 7 Side Yard : Yard 17 Tree 1 Private 1     10 Width 8ft   6003259.67301 2099184.77085 37.744146077987 -122.431395876644 (37.744146077987, -122.431395876644)
185796 185796 214455 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 449 Baden St 1 Side Yard : Yard 17 Tree 1 Private 1     10 Width 8ft   6000738.084840001 2095503.40232 37.733894671806 -122.439851058803 (37.733894671806, -122.439851058803)
46836 46836 136715 Undocumented 2 Taxus baccata :: Irish Yew 241 1599 North Point St 9 Side Yard : Yard 17 Tree 1 Private 1     9 Width 7ft   6003190.857480001 2120979.91426 37.803986257417 -122.43319081820499 (37.803986257417, -122.433190818205)
47340 47340 195222 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 900 Phelps St 6 Side Yard : Yard 17 Tree 1 Private 1     12 Width 7ft   6014590.36228 2097114.26531 37.739096551976 -122.392071762927 (37.739096551976, -122.392071762927)
62669 62669 195221 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 900 Phelps St 5 Side Yard : Yard 17 Tree 1 Private 1     9 Width 7ft   6014598.7472 2097125.5339900001 37.739127958984106 -122.392043559277 (37.7391279589841, -122.392043559277)
66458 66458 136660 Undocumented 2 Taxus baccata :: Irish Yew 241 1599 North Point St 17 Side Yard : Yard 17 Tree 1 Private 1     14 Width 7ft   6003228.45993 2120985.21121 37.8040029344509 -122.433061071222 (37.8040029344509, -122.433061071222)
72993 72993 136716 Undocumented 2 Taxus baccata :: Irish Yew 241 1599 North Point St 14 Side Yard : Yard 17 Tree 1 Private 1     15 Width 7ft   6003215.33658 2120983.87446 37.8039985196804 -122.43310638985001 (37.8039985196804, -122.43310638985)
75488 75488 136658 Undocumented 2 Taxus baccata :: Irish Yew 241 1599 North Point St 6 Side Yard : Yard 17 Tree 1 Private 1     15 Width 7ft   6003175.48548 2120978.26665 37.803980861494395 -122.433243896185 (37.8039808614944, -122.433243896185)
115469 115469 136714 Undocumented 2 Taxus baccata :: Irish Yew 241 1599 North Point St 3 Side Yard : Yard 17 Tree 1 Private 1     18 Width 7ft   6003161.03368 2120976.61805 37.803975515032604 -122.433293789677 (37.8039755150326, -122.433293789677)
147721 147721 136659 Undocumented 2 Taxus baccata :: Irish Yew 241 1599 North Point St 11 Side Yard : Yard 17 Tree 1 Private 1     13 Width 7ft   6003202.747769999 2120982.34817 37.8039936147875 -122.433149845112 (37.8039936147875, -122.433149845112)
147962 147962 195223 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 900 Phelps St 7 Side Yard : Yard 17 Tree 1 Private 1     10 Width 7ft   6014580.60262 2097100.86929 37.7390592273959 -122.392104571083 (37.7390592273959, -122.392104571083)
166163 166163 195224 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 900 Phelps St 8 Side Yard : Yard 17 Tree 1 Private 1     12 Width 7ft   6014570.35716 2097088.14635 37.7390237239721 -122.392139105952 (37.7390237239721, -122.392139105952)
167037 167037 221195 Undocumented 2 Bambusa spp :: Bamboo Species 346 200 Saint Marys Ave 2 Side Yard : Yard 17 Tree 1 Private 1     18 Width 7ft   6003941.6017 2095959.6325400001 37.7353292100649 -122.428808043276 (37.7353292100649, -122.428808043276)
2774 2774 219153 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1500 16th Ave 7 Side Yard : Yard 17 Tree 1 Private 1     8 Width 6ft   5991180.54312 2105148.28148 37.759828336219705 -122.473597358645 (37.7598283362197, -122.473597358645)
2776 2776 219152 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1500 16th Ave 6 Side Yard : Yard 17 Tree 1 Private 1     15 Width 6ft   5991180.06905 2105137.8500200002 37.759799666743 -122.473598237272 (37.759799666743, -122.473598237272)
31230 31230 187779 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 230 Middle Point Rd 2 Side Yard : Yard 17 Tree 1 Private 1     5 Width 6ft   6018271.33931 2096490.0449 37.737586251210104 -122.379301134458 (37.7375862512101, -122.379301134458)
33553 33553 211325 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 16th Ave 4 Side Yard : Yard 17 Tree 1 Private 1     6 Width 6ft   5991167.02607 2105120.24929 37.7597505844426 -122.47364206215 (37.7597505844426, -122.47364206215)
156685 156685 206432 Undocumented 2 Cotoneaster SPP :: Cotoneaster 234 1501 16th Ave 2 Side Yard : Yard 17 Tree 1 Private 1     5 Width 6ft   5991165.77974 2105142.87216 37.759812628661706 -122.473648022834 (37.7598126286617, -122.473648022834)
172072 172072 187778 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 230 Middle Point Rd 1 Side Yard : Yard 17 Tree 1 Private 1     2 Width 6ft   6018276.18855 2096495.79876 37.7376023175876 -122.37928476769899 (37.7376023175876, -122.379284767699)
182693 182693 187780 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 230 Middle Point Rd 3 Side Yard : Yard 17 Tree 1 Private 1     4 Width 6ft   6018250.04699 2096453.9006400001 37.7374858320104 -122.379372242948 (37.7374858320104, -122.379372242948)
3743 3743 175363 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 8 Side Yard : Yard 17 Tree 1 Private 1     3 Width 5ft   5993226.79298 2087801.79474 37.71231750501779 -122.465260429219 (37.7123175050178, -122.465260429219)
38547 38547 196063 Undocumented 2 Prunus spp :: Cherry 84 1751 22nd St 9 Side Yard : Yard 17 Tree 1 Private 1     3 Width 5ft   6012868.1198 2103766.18767 37.757265535503 -122.39849317144501 (37.757265535503, -122.398493171445)
39582 39582 229804 Undocumented 2 Jacaranda mimosifolia :: Jacaranda 52 10 Crescent Ave 7 Side Yard : Yard 17 Tree 1 Private 1     6 Width 5ft   6005354.49537 2095898.81655 37.7352420900484 -122.423918818711 (37.7352420900484, -122.423918818711)
53529 53529 194560 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2045 19th St 1 Side Yard : Yard 17 Tree 1 Private 1     6 Width 5ft   6011621.05801 2105090.22678 37.7608315011953 -122.402899143494 (37.7608315011953, -122.402899143494)
59121 59121 194265 Undocumented 2 Persea americana :: Avocado 113 2045 19th St 2 Side Yard : Yard 17 Tree 1 Private 1     7 Width 5ft   6011630.99539 2105089.40534 37.760829800588205 -122.40286471653299 (37.7608298005882, -122.402864716533)
75463 75463 136607 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3798 Webster St 4 Side Yard : Yard 17 Tree 1 Private 1     11 Width 5ft   6002552.02607 2121667.51893 37.8058379785924 -122.435450751546 (37.8058379785924, -122.435450751546)
148916 148916 188810 Undocumented 2 Bambusa spp :: Bamboo Species 346 1499 Rankin St 8 Side Yard : Yard 17 Tree 1 Private 1     24 Width 5ft   6012693.20045 2096700.71926 37.737855526197706 -122.39860231674801 (37.7378555261977, -122.398602316748)
157126 157126 234508 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 201 Coso Ave 2 Side Yard : Yard 17 Tree 1 Private 1     28 Width 5ft   6007691.399540001 2099521.3226799998 37.745320345265 -122.416095727735 (37.745320345265, -122.416095727735)
172278 172278 241053 Undocumented 2 Taxus baccata :: Irish Yew 241 201 Coso Ave 3 Side Yard : Yard 17 Tree 1 Private 1     11 Width 5ft   6007672.87316 2099533.1354400003 37.7453517387841 -122.416160625529 (37.7453517387841, -122.416160625529)
177483 177483 196062 Undocumented 2 Prunus spp :: Cherry 84 1751 22nd St 8 Side Yard : Yard 17 Tree 1 Private 1     5 Width 5ft   6012859.76673 2103766.08005 37.757264774654395 -122.398522052264 (37.7572647746544, -122.398522052264)
188746 188746 136606 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3798 Webster St 3 Side Yard : Yard 17 Tree 1 Private 1     8 Width 5ft   6002550.09467 2121664.33857 37.8058291364749 -122.43545720778799 (37.8058291364749, -122.435457207788)
2768 2768 219151 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1500 16th Ave 5 Side Yard : Yard 17 Tree 1 Private 1     15 Width 4ft   5991179.47447 2105124.8493 37.759763935780704 -122.47359934526101 (37.7597639357807, -122.473599345261)
25897 25897 134510 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 9 Side Yard : Yard 17 Tree 1 Private 1     18 Width 4ft   6008017.687530001 2112101.62184 37.7798812789472 -122.415858138542 (37.7798812789472, -122.415858138542)
26079 26079 134508 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 7 Side Yard : Yard 17 Tree 1 Private 1     17 Width 4ft   6008055.00417 2112104.50717 37.7798912991906 -122.41572924771499 (37.7798912991906, -122.415729247715)
26362 26362 196123 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2300 20th St 1 Side Yard : Yard 17 Tree 1 Private 1     6 Width 4ft   6011242.42693 2104654.95461 37.7596151915071 -122.404178032517 (37.7596151915071, -122.404178032517)
32078 32078 195081 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1000 Indiana St 23 Side Yard : Yard 17 Tree 1 Private 1     9 Width 4ft   6014990.50186 2103171.25593 37.7557499880963 -122.391111501888 (37.7557499880963, -122.391111501888)
40126 40126 134511 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 10 Side Yard : Yard 17 Tree 1 Private 1     21 Width 4ft   6008018.559330001 2112114.37672 37.7799163498009 -122.41585602603399 (37.7799163498009, -122.415856026034)
41420 41420 195079 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1000 Indiana St 21 Side Yard : Yard 17 Tree 1 Private 1     9 Width 4ft   6014986.69812 2103234.99475 37.755924790211395 -122.391129111534 (37.7559247902114, -122.391129111534)
43990 43990 134521 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 20 Side Yard : Yard 17 Tree 1 Private 1     14 Width 4ft   6007806.05941 2112087.1007 37.7798295076742 -122.416589227122 (37.7798295076742, -122.416589227122)
44987 44987 134512 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 11 Side Yard : Yard 17 Tree 1 Private 1     13 Width 4ft   6007952.73516 2112091.3955099997 37.7798495481525 -122.416082113806 (37.7798495481525, -122.416082113806)
47947 47947 130534 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 200 Spruce St 6 Side Yard : Yard 17 Tree 1 Private 1     11 Width 4ft   5997125.56519 2115595.68583 37.7888566928265 -122.453791002876 (37.7888566928265, -122.453791002876)
48783 48783 195082 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1000 Indiana St 24 Side Yard : Yard 17 Tree 1 Private 1     9 Width 4ft   6014993.20082 2103136.83485 37.755655624926895 -122.39109976213899 (37.7556556249269, -122.391099762139)
49284 49284 196125 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2300 20th St 3 Side Yard : Yard 17 Tree 1 Private 1     5 Width 4ft   6011177.05787 2104649.1602 37.7595956285643 -122.40440370476101 (37.7595956285643, -122.404403704761)
52420 52420 136605 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3798 Webster St 2 Side Yard : Yard 17 Tree 1 Private 1     10 Width 4ft   6002548.49635 2121661.6698 37.805821717964605 -122.43546254797701 (37.8058217179646, -122.435462547977)
52971 52971 126040 Undocumented 2 Citrus spp :: Lemon: Orange: Lime 278 2390 Bay St 1 Side Yard : Yard 17 Tree 1 Private 1     4 Width 4ft   5999373.78481 2120164.23699 37.801529357251205 -122.446341287942 (37.8015293572512, -122.446341287942)
57595 57595 134520 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 19 Side Yard : Yard 17 Tree 1 Private 1     18 Width 4ft   6007809.423690001 2112072.4347 37.779789427567 -122.41657654936199 (37.779789427567, -122.416576549362)
58449 58449 130533 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 200 Spruce St 5 Side Yard : Yard 17 Tree 1 Private 1     12 Width 4ft   5997122.58531 2115614.86787 37.7889091907409 -122.453802698553 (37.7889091907409, -122.453802698553)
60593 60593 134509 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 8 Side Yard : Yard 17 Tree 1 Private 1     28 Width 4ft   6008051.61488 2112117.95752 37.7799280400987 -122.415741925456 (37.7799280400987, -122.415741925456)
63837 63837 234919 Undocumented 2 Prunus spp :: Cherry 84 200 Saint Marys Ave 5 Side Yard : Yard 17 Tree 1 Private 1     2 Width 4ft   6003932.02563 2095971.19882 37.735360426449105 -122.428841975603 (37.7353604264491, -122.428841975603)
66598 66598 134503 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 2 Side Yard : Yard 17 Tree 1 Private 1     3 Width 4ft   6008163.02923 2112130.27379 37.7799681201757 -122.41535736455799 (37.7799681201757, -122.415357364558)
68012 68012 136610 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3798 Webster St 7 Side Yard : Yard 17 Tree 1 Private 1     15 Width 4ft   6002559.08771 2121673.9848 37.805856133210895 -122.43542677652 (37.8058561332109, -122.43542677652)
69445 69445 201615 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 98 Jerrold Ave 5 Side Yard : Yard 17 Tree 1 Private 1     2 Width 4ft   6020732.10647 2093000.2197599998 37.728139252612 -122.370551779534 (37.728139252612, -122.370551779534)
70214 70214 134516 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 15 Side Yard : Yard 17 Tree 1 Private 1     7 Width 4ft   6007879.23543 2112081.34439 37.7798178173801 -122.416335670458 (37.7798178173801, -122.416335670458)
70475 70475 134506 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 5 Side Yard : Yard 17 Tree 1 Private 1     22 Width 4ft   6008094.26451 2112112.8267900003 37.779916349808396 -122.41559401757699 (37.7799163498084, -122.415594017577)
72627 72627 136608 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3798 Webster St 5 Side Yard : Yard 17 Tree 1 Private 1     14 Width 4ft   6002554.72948 2121670.19367 37.8058454762555 -122.435441587454 (37.8058454762555, -122.435441587454)
73716 73716 134514 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 13 Side Yard : Yard 17 Tree 1 Private 1     15 Width 4ft   6007916.55212 2112084.22953 37.779827837626705 -122.41620677962 (37.7798278376267, -122.41620677962)
77273 77273 195083 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1000 Indiana St 25 Side Yard : Yard 17 Tree 1 Private 1     10 Width 4ft   6014995.62835 2103102.9826 37.755562808578404 -122.391089000875 (37.7555628085784, -122.391089000875)
137288 137288 134517 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 16 Side Yard : Yard 17 Tree 1 Private 1     7 Width 4ft   6007880.14491 2112095.92317 37.7798578983531 -122.41633355704599 (37.7798578983531, -122.416333557046)
137329 137329 134502 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 1 Side Yard : Yard 17 Tree 1 Private 1     27 Width 4ft   6008165.1975300005 2112116.84845 37.779931379274004 -122.415348912733 (37.779931379274, -122.415348912733)
138148 138148 134518 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 17 Side Yard : Yard 17 Tree 1 Private 1     6 Width 4ft   6007848.65925 2112079.5377 37.7798111372171 -122.41644131921801 (37.7798111372171, -122.416441319218)
149621 149621 196124 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2300 20th St 2 Side Yard : Yard 17 Tree 1 Private 1     5 Width 4ft   6011192.22551 2104649.1364599997 37.7595964109771 -122.40435124553998 (37.7595964109771, -122.40435124554)
153139 153139 134513 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 12 Side Yard : Yard 17 Tree 1 Private 1     29 Width 4ft   6007949.93141 2112103.61743 37.779882948971206 -122.416092679044 (37.7798829489712, -122.416092679044)
159471 159471 130532 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 200 Spruce St 3 Side Yard : Yard 17 Tree 1 Private 1     12 Width 4ft   5997120.56574 2115634.70295 37.7889635367836 -122.45381111889799 (37.7889635367836, -122.453811118898)
162918 162918 126034 Undocumented 2 Citrus aurantifolia 'Bearss' :: Seedless Lime 268 2390 Bay St 2 Side Yard : Yard 17 Tree 1 Private 1     8 Width 4ft   5999370.04259 2120163.81894 37.801527995669204 -122.446354207574 (37.8015279956692, -122.446354207574)
164267 164267 134504 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 3 Side Yard : Yard 17 Tree 1 Private 1     19 Width 4ft   6008127.86822 2112113.3553299997 37.7799196898886 -122.41547780446999 (37.7799196898886, -122.41547780447)
166855 166855 129091 Undocumented 2 Ilex altaclarensis 'Wilsonii' :: Wilson Holly Tree 310 200 Spruce St 8 Side Yard : Yard 17 Tree 1 Private 1     14 Width 4ft   5997131.25122 2115563.65608 37.78876907367739 -122.45376901623399 (37.7887690736774, -122.453769016234)
169605 169605 193341 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1751 22nd St 6 Side Yard : Yard 17 Tree 1 Private 1     2 Width 4ft   6012847.48484 2103764.38864 37.757259446178104 -122.398564409431 (37.7572594461781, -122.398564409431)
172416 172416 193454 Undocumented 2 Malus :: Crab Apple 235 1751 22nd St 4 Side Yard : Yard 17 Tree 1 Private 1     5 Width 4ft   6012836.35508 2103764.61447 37.75725944619679 -122.39860291658701 (37.7572594461968, -122.398602916587)
172984 172984 134507 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 6 Side Yard : Yard 17 Tree 1 Private 1     24 Width 4ft   6008088.37088 2112123.28694 37.779944739586 -122.415615147138 (37.779944739586, -122.415615147138)
176180 176180 195080 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1000 Indiana St 22 Side Yard : Yard 17 Tree 1 Private 1     9 Width 4ft   6014988.8599 2103201.99322 37.755834295018204 -122.39111932871201 (37.7558342950182, -122.391119328712)
177126 177126 134515 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 14 Side Yard : Yard 17 Tree 1 Private 1     18 Width 4ft   6007920.47696 2112096.9218900003 37.7798629084902 -122.416194101002 (37.7798629084902, -122.416194101002)
177530 177530 134505 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 4 Side Yard : Yard 17 Tree 1 Private 1     24 Width 4ft   6008123.85605 2112126.20986 37.7799547598338 -122.41549259472299 (37.7799547598338, -122.415492594723)
177540 177540 134519 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 18 Side Yard : Yard 17 Tree 1 Private 1     24 Width 4ft   6007845.81845 2112089.93571 37.779839527901295 -122.416451883555 (37.7798395279013, -122.416451883555)
182626 182626 195078 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1000 Indiana St 20 Side Yard : Yard 17 Tree 1 Private 1     11 Width 4ft   6014987.06432 2103267.10016 37.7560129651346 -122.391130089079 (37.7560129651346, -122.391130089079)
184178 184178 201613 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 98 Jerrold Ave 3 Side Yard : Yard 17 Tree 1 Private 1     2 Width 4ft   6020763.58395 2092982.86481 37.728093326933205 -122.370441760089 (37.7280933269332, -122.370441760089)
185405 185405 201614 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 98 Jerrold Ave 4 Side Yard : Yard 17 Tree 1 Private 1     3 Width 4ft   6020747.34365 2092993.8196 37.728122515333396 -122.370498661104 (37.7281225153334, -122.370498661104)
188021 188021 136609 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 3798 Webster St 6 Side Yard : Yard 17 Tree 1 Private 1     7 Width 4ft   6002557.10875 2121672.73918 37.805852600677795 -122.435433535844 (37.8058526006778, -122.435433535844)
24649 24649 194268 Undocumented 2 Persea americana :: Avocado 113 900 Quint St 3 Side Yard : Yard 17 Tree 1 Private 1     7 Width 3ft   6014100.1568599995 2097559.70841 37.7402924173605 -122.393797854205 (37.7402924173605, -122.393797854205)
25256 25256 238433 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 272 Corbett Ave 8 Side Yard : Yard 17 Tree 1 Private 1     8 Width 3ft   5999629.6727599995 2105348.1757099996 37.7608628875441 -122.444390425487 (37.7608628875441, -122.444390425487)
25273 25273 237871 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 200 Corbin Pl 3 Side Yard : Yard 17 Tree 1 Private 1     4 Width 3ft   6000061.7105 2105723.34521 37.761917651093704 -122.44292314469 (37.7619176510937, -122.44292314469)
26546 26546 191706 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1499 Rankin St 7 Side Yard : Yard 17 Tree 1 Private 1     1 Width 3ft   6012685.03055 2096691.5436200001 37.7378298766422 -122.39862992054701 (37.7378298766422, -122.398629920547)
30657 30657 220393 Undocumented 2 Acer palmatum :: Japanese Maple 175 20 Deming St 1 Side Yard : Yard 17 Tree 1 Private 1     5 Width 3ft   5999466.4358 2105239.81948 37.7605560532329 -122.44494719845801 (37.7605560532329, -122.444947198458)
30768 30768 223720 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 10 Crescent Ave 3 Side Yard : Yard 17 Tree 1 Private 1     15 Width 3ft   6005295.72226 2095902.89747 37.7352499770995 -122.424122309196 (37.7352499770995, -122.424122309196)

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