Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 89853 | 89853 | 116978 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 111 BAY ST | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010550.0 | 2121704.0 | 37.806389129422705 | -122.40777498514299 | (37.8063891294227, -122.407774985143) | |||||
| 92535 | 92535 | 111709 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 111 BAY ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010550.0 | 2121704.0 | 37.806389129422705 | -122.40777498514299 | (37.8063891294227, -122.407774985143) | |||||
| 133018 | 133018 | 116821 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 8 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 14 | 6010478.7636 | 2121651.8235 | 37.806241877556 | -122.408017830638 | (37.806241877556, -122.408017830638) | ||||
| 59669 | 59669 | 116819 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 6 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 11 | 6010427.9948 | 2121647.4361 | 37.8062269882557 | -122.40819321595501 | (37.8062269882557, -122.408193215955) | ||||
| 17977 | 17977 | 116827 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 14 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 83489 | 83489 | 116828 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 15 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 83621 | 83621 | 116826 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 13 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 85395 | 85395 | 116822 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 9 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 92074 | 92074 | 116820 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 7 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 93526 | 93526 | 116831 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 18 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 94354 | 94354 | 116825 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 12 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 99346 | 99346 | 116823 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 10 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 107057 | 107057 | 116830 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 17 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 110974 | 110974 | 116818 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 5 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 111971 | 111971 | 116809 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 1 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 126108 | 126108 | 116824 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 11 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 127145 | 127145 | 116817 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 4 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 139776 | 139776 | 116829 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 16 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 144844 | 144844 | 116816 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 3 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 146001 | 146001 | 116815 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 2 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 92493 | 92493 | 112481 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 1275 Columbus Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
| 93451 | 93451 | 112482 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1275 Columbus Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
| 107396 | 107396 | 112485 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
| 108788 | 108788 | 112483 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1275 Columbus Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
| 109824 | 109824 | 112486 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | Permit Number 774532 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | |||
| 122611 | 122611 | 112487 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | |||||
| 122658 | 122658 | 112488 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | |||||
| 124450 | 124450 | 112484 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
| 113085 | 113085 | 65849 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 66 Rico Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/19/2007 12:00:00 AM | 3x3 | Permit Number 50013 | 6001352.95008446 | 2121456.09779386 | 37.8051893002679 | -122.439585161616 | (37.8051893002679, -122.439585161616) | ||
| 100647 | 100647 | 121134 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1050 North Point St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x10 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 119513 | 119513 | 121133 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1050 North Point St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 3x10 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | |||
| 58020 | 58020 | 126356 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 101 Marina Blvd | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6002934.90654 | 2121377.37848 | 37.805063066958105 | -122.434104982679 | (37.8050630669581, -122.434104982679) | ||||
| 166990 | 166990 | 136321 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Francisco St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6010437.78302 | 2121369.6786 | 37.8054648831642 | -122.408139740375 | (37.8054648831642, -122.408139740375) | ||||
| 61068 | 61068 | 133177 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 Francisco St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6010481.51509 | 2121362.5408 | 37.8054477330788 | -122.40798789525 | (37.8054477330788, -122.40798789525) | ||||
| 33297 | 33297 | 133178 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 Francisco St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6010460.26266 | 2121350.57674 | 37.8054136928441 | -122.40806059821199 | (37.8054136928441, -122.408060598212) | ||||
| 150663 | 150663 | 133180 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 Francisco St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6010437.48919 | 2121349.87905 | 37.80541050205729 | -122.40813935996 | (37.8054105020573, -122.40813935996) | ||||
| 160710 | 160710 | 133179 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 Francisco St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010446.38311 | 2121337.68774 | 37.8053775257257 | -122.408107720898 | (37.8053775257257, -122.408107720898) | ||||
| 158580 | 158580 | 133176 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 Francisco St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | 6010490.33512 | 2121337.17898 | 37.8053785896135 | -122.407955582591 | (37.8053785896135, -122.407955582591) | ||||
| 28126 | 28126 | 125863 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 150 Francisco St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010483.33133 | 2121337.12789 | 37.8053780572129 | -122.407979816633 | (37.8053780572129, -122.407979816633) | ||||
| 183483 | 183483 | 99289 | Significant Tree 6 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 845 Marina Blvd | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/05/2012 12:00:00 AM | 1 | Permit Number 768788 | 5998887.79124 | 2121333.18312 | 37.8047111982366 | -122.448107254257 | (37.8047111982366, -122.448107254257) | ||
| 47419 | 47419 | 99288 | Significant Tree 6 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 845 Marina Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/05/2012 12:00:00 AM | 1 | Permit Number 768788 | 5998881.62913 | 2121328.006 | 37.8046966310161 | -122.448128205765 | (37.8046966310161, -122.448128205765) | ||
| 147172 | 147172 | 133181 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6010456.661040001 | 2121322.6258799997 | 37.805336745057396 | -122.408071089728 | (37.8053367450574, -122.408071089728) | ||||
| 173428 | 173428 | 133190 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6010565.46337 | 2121315.97137 | 37.8053245646485 | -122.407694093918 | (37.8053245646485, -122.407694093918) | ||||
| 52076 | 52076 | 133187 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6010536.300969999 | 2121315.75922 | 37.8053223496175 | -122.407794999663 | (37.8053223496175, -122.407794999663) | ||||
| 188185 | 188185 | 133189 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010562.1879199995 | 2121314.22329 | 37.8053195814974 | -122.40770530575399 | (37.8053195814974, -122.407705305754) | ||||
| 176631 | 176631 | 133188 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010540.31188 | 2121313.86259 | 37.80531736647829 | -122.407780985508 | (37.8053173664783, -122.407780985508) | ||||
| 42553 | 42553 | 133185 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 31 | 6010525.52833 | 2121313.76081 | 37.805316259401295 | -122.407832138939 | (37.8053162594013, -122.407832138939) | ||||
| 46130 | 46130 | 132162 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 165 Francisco St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6010559.73859 | 2121313.26508 | 37.8053168133783 | -122.40771371440901 | (37.8053168133783, -122.407713714409) | ||||
| 185848 | 185848 | 132161 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 165 Francisco St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6010552.8238 | 2121311.7929599998 | 37.8053123842132 | -122.407737540175 | (37.8053123842132, -122.407737540175) | ||||
| 50265 | 50265 | 133184 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6010514.4999 | 2121309.14638 | 37.8053029719104 | -122.407869978821 | (37.8053029719104, -122.407869978821) | ||||
| 162241 | 162241 | 133183 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6010500.28668 | 2121307.21814 | 37.8052968817183 | -122.40791902965401 | (37.8052968817183, -122.407919029654) | ||||
| 188585 | 188585 | 133186 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010537.33866 | 2121307.06763 | 37.80529854275579 | -122.40779079533199 | (37.8052985427558, -122.407790795332) | ||||
| 55269 | 55269 | 133182 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010494.592999999 | 2121305.47712 | 37.8052917825441 | -122.4079386106 | (37.8052917825441, -122.4079386106) | ||||
| 144887 | 144887 | 116832 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Midway St | 7 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010125.275107 | 2121295.55695439 | 37.8052438606833 | -122.409215987298 | (37.8052438606833, -122.409215987298) | |||||
| 41671 | 41671 | 132747 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2100 Jefferson St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 5999125.84165 | 2121169.76474 | 37.804276100834606 | -122.44727169143101 | (37.8042761008346, -122.447271691431) | ||||
| 153832 | 153832 | 126045 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2100 Jefferson St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 5999106.15864 | 2121169.1947 | 37.8042734109522 | -122.44733976473302 | (37.8042734109522, -122.447339764733) | ||||
| 184653 | 184653 | 126036 | Undocumented 2 | Citrus aurantifolia 'Bearss' :: Seedless Lime 268 | 2100 Jefferson St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 5999082.9482 | 2121164.53578 | 37.8042592925024 | -122.44741975044501 | (37.8042592925024, -122.447419750445) | ||||
| 73110 | 73110 | 126046 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2100 Jefferson St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 5999077.01355 | 2121162.9453 | 37.804254586342 | -122.447440173138 | (37.804254586342, -122.447440173138) | ||||
| 34147 | 34147 | 132748 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2100 Jefferson St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | 5999067.6485 | 2121161.9158799998 | 37.80425122466389 | -122.44747250735901 | (37.8042512246639, -122.447472507359) | ||||
| 181320 | 181320 | 129489 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2120 Jefferson St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5999042.28702 | 2121160.24008 | 37.80424517403429 | -122.44756015169901 | (37.8042451740343, -122.447560151699) | ||||
| 57628 | 57628 | 131858 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2120 Jefferson St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 5999033.9151099995 | 2121159.67967 | 37.804243156854895 | -122.447589082867 | (37.8042431568549, -122.447589082867) | ||||
| 168837 | 168837 | 131859 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2120 Jefferson St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 5999029.48061 | 2121159.2823099997 | 37.8042418123825 | -122.44760440011801 | (37.8042418123825, -122.447604400118) | ||||
| 185030 | 185030 | 108987 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3560 Baker St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 5999200.334980001 | 2121108.96976 | 37.804113430551894 | -122.447009524696 | (37.8041134305519, -122.447009524696) | ||||
| 59539 | 59539 | 98244 | Significant Tree 6 | Taxus baccata :: Irish Yew 241 | 901 Bay St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6006420.63185 | 2121080.7781 | 37.8044458892203 | -122.422021121489 | (37.8044458892203, -122.422021121489) | ||||
| 154711 | 154711 | 249797 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 199 Chestnut St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6010839.41961 | 2121064.72571 | 37.804650038031795 | -122.40672831108499 | (37.8046500380318, -122.406728311085) | |||
| 65833 | 65833 | 249798 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 199 Chestnut St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010832.73906 | 2121063.1197 | 37.8046452545423 | -122.406751316639 | (37.8046452545423, -122.406751316639) | |||
| 33120 | 33120 | 249800 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 199 Chestnut St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 0ft | 6010811.58408 | 2121055.18857 | 37.8046222939481 | -122.406823966551 | (37.8046222939481, -122.406823966551) | |||
| 53267 | 53267 | 249799 | Undocumented 2 | Salix spp :: Willow 218 | 199 Chestnut St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6010830.01398 | 2121049.58658 | 37.8046079434619 | -122.406759792755 | (37.8046079434619, -122.406759792755) | |||
| 179670 | 179670 | 249796 | Undocumented 2 | Salix spp :: Willow 218 | 199 Chestnut St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 6010844.62516 | 2121045.45639 | 37.80459742048421 | -122.40670893787701 | (37.8045974204842, -122.406708937877) | |||
| 130214 | 130214 | 249786 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 161 Chestnut St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 0ft | 6010943.97363 | 2121044.47732 | 37.8046002902368 | -122.406365062323 | (37.8046002902368, -122.406365062323) | |||
| 46681 | 46681 | 249785 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 161 Chestnut St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 0ft | 6010956.1226 | 2121039.70037 | 37.804587853513105 | -122.406322682661 | (37.8045878535131, -122.406322682661) | |||
| 34887 | 34887 | 249788 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 173 Chestnut St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6010917.19441 | 2121035.2670400003 | 37.8045735030171 | -122.406457085429 | (37.8045735030171, -122.406457085429) | |||
| 184049 | 184049 | 249789 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 173 Chestnut St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 0ft | 6010910.8847900005 | 2121034.69861 | 37.804571589270296 | -122.40647888049 | (37.8045715892703, -122.40647888049) | |||
| 135517 | 135517 | 249787 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 173 Chestnut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | Width 0ft | 6010924.52484 | 2121034.4207099997 | 37.8045715892836 | -122.40643165799 | (37.8045715892836, -122.40643165799) | |||
| 33559 | 33559 | 249811 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Chestnut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 0ft | 6010658.60603 | 2121034.26523 | 37.80455628281221 | -122.40735188838 | (37.8045562828122, -122.40735188838) | |||
| 25037 | 25037 | 249812 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Chestnut St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010650.1980099995 | 2121033.7396299997 | 37.8045543690542 | -122.40738094817699 | (37.8045543690542, -122.407380948177) | |||
| 172377 | 172377 | 249791 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 173 Chestnut St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010901.74911 | 2121032.7944400003 | 37.8045658498059 | -122.406510361262 | (37.8045658498059, -122.406510361262) | |||
| 63805 | 63805 | 249790 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 173 Chestnut St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 0ft | 6010907.694630001 | 2121032.6733 | 37.804565849800206 | -122.406489777591 | (37.8045658498002, -122.406489777591) | |||
| 41725 | 41725 | 249801 | Undocumented 2 | Salix spp :: Willow 218 | 199 Chestnut St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 0ft | 6010817.41818 | 2121032.42215 | 37.8045601094112 | -122.40680217150101 | (37.8045601094112, -122.406802171501) | |||
| 75481 | 75481 | 249813 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 260 Chestnut St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6010621.11973 | 2121031.8935700003 | 37.8045476726861 | -122.407481446514 | (37.8045476726861, -122.407481446514) | |||
| 133837 | 133837 | 249792 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 173 Chestnut St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6010895.76074 | 2121030.82581 | 37.8045601094175 | -122.406530945871 | (37.8045601094175, -122.406530945871) | |||
| 154988 | 154988 | 249793 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 199 Chestnut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 6010888.03809 | 2121029.58951 | 37.8045562827982 | -122.406557583781 | (37.8045562827982, -122.406557583781) | |||
| 42673 | 42673 | 249794 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 199 Chestnut St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 6010881.7284699995 | 2121029.02109 | 37.8045543690603 | -122.40657937883499 | (37.8045543690603, -122.406579378835) | |||
| 115163 | 115163 | 249795 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 199 Chestnut St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 0ft | 6010876.47514 | 2121028.77996 | 37.804553413072 | -122.406597541559 | (37.804553413072, -122.406597541559) | |||
| 59452 | 59452 | 249784 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 161 Chestnut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010971.1563800005 | 2121021.973 | 37.8045400194799 | -122.406269406801 | (37.8045400194799, -122.406269406801) | |||
| 75555 | 75555 | 132300 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2747 Larkin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6006512.88528 | 2120797.48529 | 37.8036732420995 | -122.421681736235 | (37.8036732420995, -122.421681736235) | ||||
| 67132 | 67132 | 132301 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2747 Larkin St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6006508.97625 | 2120792.8563 | 37.8036603116463 | -122.42169493467699 | (37.8036603116463, -122.421694934677) | ||||
| 49444 | 49444 | 249767 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 266 Lombard St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | Width 0ft | 6010996.518680001 | 2120736.58117 | 37.8037578224149 | -122.406161518736 | (37.8037578224149, -122.406161518736) | |||
| 29771 | 29771 | 249766 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 266 Lombard St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 31 | Width 0ft | 6011007.58004 | 2120722.18976 | 37.80371892584 | -122.40612222558201 | (37.80371892584, -122.406122225582) | |||
| 184802 | 184802 | 249765 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 266 Lombard St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 53 | Width 0ft | 6010998.40684 | 2120702.14433 | 37.8036633729317 | -122.406152556991 | (37.8036633729317, -122.406152556991) | |||
| 72487 | 72487 | 249768 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 266 Lombard St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6010977.12206 | 2120702.10235 | 37.8036620671076 | -122.406226211476 | (37.8036620671076, -122.406226211476) | |||
| 137536 | 137536 | 249818 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Kearny St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | Width 0ft | 6010887.46579 | 2120660.30432 | 37.803542284601996 | -122.40653352599399 | (37.803542284602, -122.406533525994) | |||
| 152567 | 152567 | 249824 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 285 Kearny St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6010866.76079 | 2120642.6759099998 | 37.8034927229673 | -122.40660393393999 | (37.8034927229673, -122.40660393394) | |||
| 154615 | 154615 | 249823 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Kearny St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010881.14413 | 2120640.5408 | 37.8034876651725 | -122.406554008974 | (37.8034876651725, -122.406554008974) | |||
| 183937 | 183937 | 249822 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Kearny St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6010893.58143 | 2120633.6568400003 | 37.8034694593133 | -122.406510483572 | (37.8034694593133, -122.406510483572) | |||
| 39363 | 39363 | 249821 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 281 Kearny St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010901.8759699995 | 2120623.17353 | 37.8034411387496 | -122.406481040676 | (37.8034411387496, -122.406481040676) | |||
| 95033 | 95033 | 106942 | Significant Tree 6 | Tree(s) :: 17 | 1300@ Embarcadero Battery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/02/2014 12:00:00 AM | Permit Number 772680 | 6012231.9986 | 2120618.97397 | 37.8035039293343 | -122.40187777389099 | (37.8035039293343, -122.401877773891) | |||
| 46865 | 46865 | 249820 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 281 Kearny St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6010902.80513 | 2120614.31353 | 37.8034168633488 | -122.40647720057301 | (37.8034168633488, -122.406477200573) | |||
| 74113 | 74113 | 249819 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 275 Kearny St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 0ft | 6010904.45886 | 2120604.70215 | 37.803390565377605 | -122.40647080008002 | (37.8033905653776, -122.40647080008) | |||
| 5478 | 5478 | 121205 | Significant Tree 6 | Cotoneaster SPP :: Cotoneaster 234 | 930 Chestnut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 3x3 | 6007386.5238 | 2120591.4348299997 | 37.8031567047665 | -122.418643837145 | (37.8031567047665, -122.418643837145) |
JSON shape: default, array, newline-delimited
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");