Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96557 | 96557 | 107036 | Significant Tree 6 | Tree(s) :: 17 | 350 08th St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/23/2014 12:00:00 AM | 7x7 | Permit Number 772214 | 6009826.0 | 2110084.0 | 37.774442857676505 | -122.409459923405 | (37.7744428576765, -122.409459923405) | |||
| 96590 | 96590 | 99643 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 1268 Lombard St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6006289.0 | 2120073.0 | 37.8016713630652 | -122.42240499597 | (37.8016713630652, -122.42240499597) | ||||
| 96595 | 96595 | 106311 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.4648400003 | 37.73289581695511 | -122.49149816384899 | (37.7328958169551, -122.491498163849) | |||
| 96627 | 96627 | 104900 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 317 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 96655 | 96655 | 105086 | Significant Tree 6 | :: 54 | 344 Fulton St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 96798 | 96798 | 111179 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 400 NORTH POINT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | 9x6 | 6008572.0 | 2121805.0 | 37.806555520543 | -122.41462738080799 | (37.806555520543, -122.414627380808) | ||
| 96813 | 96813 | 112924 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||||
| 96939 | 96939 | 113833 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 932 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 6007966.0 | 2102301.0 | 37.752968150444204 | -122.415342945464 | (37.7529681504442, -122.415342945464) | ||||
| 96972 | 96972 | 120593 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 499x Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 34 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | |||
| 96978 | 96978 | 104261 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1556X O'Farrell St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003781.85581 | 2113525.38813 | 37.783551542878 | -122.430613377711 | (37.783551542878, -122.430613377711) | |||||
| 97000 | 97000 | 113736 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
| 97021 | 97021 | 106360 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1820 POST ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6003351.1 | 2114201.6 | 37.785383838011 | -122.43215193232099 | (37.785383838011, -122.432151932321) | ||||
| 97038 | 97038 | 105091 | Significant Tree 6 | :: 54 | 344 Fulton St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 97229 | 97229 | 85428 | Significant Tree 6 | Tree(s) :: 17 | 43 Ora Way | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/23/2007 12:00:00 AM | Permit Number 49665 | 6001553.3 | 2098294.6 | 37.741605021987205 | -122.437232403771 | (37.7416050219872, -122.437232403771) | |||
| 97249 | 97249 | 114184 | Significant Tree 6 | Tree(s) :: 17 | 2454 HYDE ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/07/2016 12:00:00 AM | 30x30 | Permit Number 776893 | 6007060.0 | 2120781.0 | 37.8036588138585 | -122.41978724303999 | (37.8036588138585, -122.41978724304) | ||
| 97259 | 97259 | 116164 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2411 OCTAVIA ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 15x4 | 6004495.0 | 2117637.0 | 37.7948813682629 | -122.428439330772 | (37.7948813682629, -122.428439330772) | |||
| 97425 | 97425 | 116862 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 262X OAK PARK DR | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 10x10 | 5995091.0 | 2103085.0 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | ||||
| 97455 | 97455 | 98954 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 302 Ivy St | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | |||||
| 97466 | 97466 | 102302 | Significant Tree 6 | Tree(s) :: 17 | 740X 31st Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/14/2013 12:00:00 AM | Permit Number 769784 | 5986476.3 | 2110809.8 | 37.7750997269751 | -122.490283282468 | (37.7750997269751, -122.490283282468) | |||
| 97519 | 97519 | 114725 | Significant Tree 6 | :: 54 | 520 Townsend St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012508.1 | 2109575.3 | 37.7731959986981 | -122.40014623691201 | (37.7731959986981, -122.400146236912) | |||||
| 97526 | 97526 | 113735 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
| 97714 | 97714 | 102073 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 110 | 273 Magellan Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | |||||
| 97749 | 97749 | 96481 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 97751 | 97751 | 110321 | Significant Tree 6 | Ilex opaca :: American Holly 484 | 1x SAN PABLO AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774750 | 5994773.0 | 2097898.0 | 37.740128291439 | -122.460647489756 | (37.740128291439, -122.460647489756) | ||
| 97754 | 97754 | 115459 | Significant Tree 6 | Tree(s) :: 17 | 80 Crestline Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 02/02/2016 12:00:00 AM | 3 | Permit Number 776150 | 5999012.8 | 2102131.7 | 37.7519960240451 | -122.446292521132 | (37.7519960240451, -122.446292521132) | ||
| 97768 | 97768 | 104681 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 33 08th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | ||||
| 97871 | 97871 | 115124 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 499X MAIN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
| 97963 | 97963 | 104717 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 3618 22nd St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.42832583872601 | (37.7549616692716, -122.428325838726) | ||||
| 98070 | 98070 | 88456 | Significant Tree 6 | Tree(s) :: 17 | 2801 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2008 12:00:00 AM | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089005 | -122.40455177544202 | (37.742488010089, -122.404551775442) | |||
| 98079 | 98079 | 104865 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 80 Stoneman St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770375 | 6007947.7 | 2099422.0 | 37.7450620347132 | -122.415202450973 | (37.7450620347132, -122.415202450973) | ||||
| 98089 | 98089 | 110427 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1860 09TH AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | Permit Number 775447 | 5993494.0 | 2102835.0 | 37.7536103714224 | -122.465428263995 | (37.7536103714224, -122.465428263995) | ||
| 98122 | 98122 | 103656 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.2033599997 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | |||
| 98130 | 98130 | 95234 | Significant Tree 6 | Tree(s) :: 17 | 7 Almaden Ct | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/25/2011 12:00:00 AM | Permit Number 767129 | 5995849.0 | 2112535.0 | 37.780379598944705 | -122.457986127959 | (37.7803795989447, -122.457986127959) | ||||
| 98176 | 98176 | 105497 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3929 19TH ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 60 | 6003450.9 | 2104734.8 | 37.7593959875427 | -122.431130714429 | (37.7593959875427, -122.431130714429) | ||||
| 98270 | 98270 | 107984 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 13 | 2401x SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001096.0 | 2116670.0 | 37.792033311180504 | -122.440130949989 | (37.7920333111805, -122.440130949989) | ||||
| 98300 | 98300 | 94851 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1107 Bowdoin St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/17/2010 12:00:00 AM | 12 | Permit Number 774691 | 6009593.0 | 2091048.0 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | ||
| 98327 | 98327 | 99832 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 198 | 2398@Steiner Broadway | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | |||||
| 98505 | 98505 | 100433 | Significant Tree 6 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 152 | 200X Stonecrest Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | |||||
| 98560 | 98560 | 114194 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 555x SAN JOSE AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | 30 | 3x3 | Permit Number 777057 | 6006305.0 | 2100249.0 | 37.747240333103 | -122.420941331562 | (37.747240333103, -122.420941331562) | |
| 98650 | 98650 | 113044 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 500 RAYMOND AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6008527.0 | 2088690.0 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | ||||
| 98668 | 98668 | 108560 | Significant Tree 6 | Pinus halepensis :: Allepo Pine 164 | 3790 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003155.9 | 2103640.4 | 37.7563743055091 | -122.432072816055 | (37.7563743055091, -122.432072816055) | |||||
| 98681 | 98681 | 104726 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 142 | 1079 Church St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770313 | 6004474.7 | 2102638.1 | 37.7536969056436 | -122.42744054305099 | (37.7536969056436, -122.427440543051) | ||||
| 98711 | 98711 | 105649 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990274.6 | 2090665.2 | 37.7200090188364 | -122.475672946469 | (37.7200090188364, -122.475672946469) | |||||
| 98766 | 98766 | 104736 | Significant Tree 6 | Lagunaria patersonii :: Primrose Tree 48 | 1499X 44th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770763 | 5982473.05016 | 2105245.16297 | 37.7595862228156 | -122.50371897878901 | (37.7595862228156, -122.503718978789) | ||||
| 98792 | 98792 | 108275 | Significant Tree 6 | Arecastrum romanzoffianum :: Queen Palm 238 | 1800x ALAMEDA ST | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 15 | 6011533.0 | 2107928.0 | 37.7686184708296 | -122.40340334412501 | (37.7686184708296, -122.403403344125) | ||||
| 98850 | 98850 | 108305 | Significant Tree 6 | Tree(s) :: 17 | 360 GAMBIER ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/06/2015 12:00:00 AM | 3 | Permit Number 774454 | 6006059.9 | 2092154.5 | 37.725000818070995 | -122.42121417648599 | (37.725000818071, -122.421214176486) | ||
| 98898 | 98898 | 117252 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 2500x 34TH AVE | 2 | Side Yard : Yard 17 | Tree 1 | SFUSD 4 | 3x3 | 5985829.0 | 2097874.0 | 37.73954376030179 | -122.491570003273 | (37.7395437603018, -122.491570003273) | ||||
| 98982 | 98982 | 98757 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 340 Castenada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993579.1 | 2100062.8 | 37.7460035255592 | -122.464932655613 | (37.7460035255592, -122.464932655613) | |||||
| 98992 | 98992 | 114476 | Significant Tree 6 | Pittosporum spp :: Pittosporum spp 128 | 299x UNION ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 6011527.0 | 2119680.0 | 37.8008863659875 | -122.40425133897 | (37.8008863659875, -122.40425133897) | ||||
| 99011 | 99011 | 115564 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 3524 Jackson St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5x10 | 5997387.02929021 | 2116081.37513577 | 37.790205252620794 | -122.452921449726 | (37.7902052526208, -122.452921449726) | ||||
| 99064 | 99064 | 93932 | Significant Tree 6 | Pinus Spp :: Pine Spp 105 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.5528400003 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | |||||
| 99170 | 99170 | 100432 | Significant Tree 6 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 200X Stonecrest Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | |||||
| 99196 | 99196 | 108002 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 461X Ivy St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005199.36333 | 2111122.83043 | 37.777034912059605 | -122.425538300101 | (37.7770349120596, -122.425538300101) | |||||
| 99197 | 99197 | 106956 | Significant Tree 6 | Tree(s) :: 17 | 50 Fell St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 10x10 | 6007226.0 | 2110908.0 | 37.7765593411304 | -122.418512280303 | (37.7765593411304, -122.418512280303) | |||
| 99207 | 99207 | 96568 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 99263 | 99263 | 101435 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X Grant Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010995.6 | 2116632.0 | 37.7924875884206 | -122.40587538693701 | (37.7924875884206, -122.405875386937) | |||||
| 99448 | 99448 | 116072 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 388 POLARIS WAY | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000586.0 | 2086414.0 | 37.70892857908329 | -122.439725431133 | (37.7089285790833, -122.439725431133) | ||||
| 99634 | 99634 | 99847 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 850@14th Ave Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5991942.0 | 2105939.0 | 37.7620435090796 | -122.47102148161501 | (37.7620435090796, -122.471021481615) | |||||
| 99731 | 99731 | 115673 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 86 Stanton St | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000281.6 | 2103909.8 | 37.7569506357303 | -122.442032456595 | (37.7569506357303, -122.442032456595) | ||||||
| 99765 | 99765 | 115276 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 598X PORTOLA DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5997411.0 | 2099824.0 | 37.74556803712711 | -122.451665301061 | (37.7455680371271, -122.451665301061) | ||||
| 99779 | 99779 | 114394 | Significant Tree 6 | Ficus Spp. :: 253 | 134x TAPIA DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 99811 | 99811 | 104936 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 837 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 99818 | 99818 | 105907 | Significant Tree 6 | Pinus Spp :: Pine Spp 105 | 1837 30TH AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5986904.0 | 2102674.0 | 37.752786039312795 | -122.488205804709 | (37.7527860393128, -122.488205804709) | ||||
| 99827 | 99827 | 122418 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 99835 | 99835 | 104913 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 28 | 608 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 100107 | 100107 | 100701 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954.0 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | |||
| 100141 | 100141 | 121157 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 100197 | 100197 | 103618 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 201X Haight St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6004725.0 | 2109149.0 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | |||||
| 100317 | 100317 | 113359 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 702 Foerster St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998153.40008835 | 2095558.62470631 | 37.733898832504295 | -122.448791034412 | (37.7338988325043, -122.448791034412) | |||||
| 100331 | 100331 | 112930 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | |||
| 100341 | 100341 | 120932 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 3995X Alemany Blvd | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||||
| 100392 | 100392 | 96279 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 55@ Alemany Trumbull St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | |||||
| 100450 | 100450 | 107818 | Significant Tree 6 | Ficus Spp. :: 253 | 474 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | 6004715.2 | 2110227.8 | 37.7745500089947 | -122.42714940503201 | (37.7745500089947, -122.427149405032) | ||||
| 100567 | 100567 | 103612 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 200X Buchanan St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | |||||
| 100583 | 100583 | 121159 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 100592 | 100592 | 116998 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 880x MCALLISTER ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | |||||
| 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) | ||||
| 100775 | 100775 | 107342 | Significant Tree 6 | Prunus laurocerasus :: English laurel 227 | 110 JULIAN AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 100 | 6006340.8 | 2107214.1 | 37.7663669011591 | -122.421312071366 | (37.7663669011591, -122.421312071366) | ||||
| 100778 | 100778 | 102077 | Significant Tree 6 | Ulmus glabra :: Scotch Elm 511 | 273 Magellan Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | |||||
| 100812 | 100812 | 115070 | Significant Tree 6 | :: 54 | 401 DARIEN WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 5992724.0 | 2094938.0 | 37.7318827746659 | -122.467516839465 | (37.7318827746659, -122.467516839465) | ||||
| 100978 | 100978 | 121192 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 100981 | 100981 | 103655 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.2033599997 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | |||
| 101102 | 101102 | 96484 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 180 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 101234 | 101234 | 94303 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 101276 | 101276 | 62912 | Significant Tree 6 | Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 502 | 500 Cortland Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50224 | 6007523.90359428 | 2097218.90762974 | 37.7389890062486 | -122.416511839888 | (37.7389890062486, -122.416511839888) | ||
| 101280 | 101280 | 113045 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 500 RAYMOND AVE | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6008527.0 | 2088690.0 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | ||||
| 101316 | 101316 | 113733 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
| 101472 | 101472 | 106058 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 13 | 301 FILBERT ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6011273.0 | 2120044.0 | 37.8018716248897 | -122.40515593659401 | (37.8018716248897, -122.405155936594) | ||||
| 101515 | 101515 | 100772 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 108 | 450 Hayes St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||||
| 101535 | 101535 | 116502 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 71X PARKRIDGE DR | 3 | Median : Yard 3 | Tree 1 | Private 1 | 28 | 3x3 | 5999012.0 | 2102131.0 | 37.751994056327 | -122.446295237287 | (37.751994056327, -122.446295237287) | |||
| 101621 | 101621 | 104406 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 290 Stonecrest Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | Permit Number 770927 | 5990725.0 | 2092655.0 | 37.7254986161427 | -122.474261202586 | (37.7254986161427, -122.474261202586) | |||
| 101651 | 101651 | 106059 | Significant Tree 6 | Salix spp :: Willow 218 | 339 FILBERT ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6011263.6 | 2119947.8 | 37.801606957686 | -122.40518168715599 | (37.801606957686, -122.405181687156) | ||||
| 101747 | 101747 | 113695 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 907 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6009441.0 | 2103786.0 | 37.7571284172194 | -122.41034693748101 | (37.7571284172194, -122.410346937481) | |||
| 101782 | 101782 | 116536 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754.0 | 2090179.0 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | |
| 101898 | 101898 | 114193 | Significant Tree 6 | Tree(s) :: 17 | 555x SAN JOSE AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778877 | 6006305.0 | 2100249.0 | 37.747240333103 | -122.420941331562 | (37.747240333103, -122.420941331562) | |
| 101996 | 101996 | 101236 | Significant Tree 6 | Tree(s) :: 17 | 895X Church St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10/05/2012 12:00:00 AM | 13 | Permit Number 769299 | 6004383.5 | 2103691.7 | 37.7565846850157 | -122.42783100085899 | (37.7565846850157, -122.427831000859) | ||
| 102016 | 102016 | 105368 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 180 CLIFFORD TER | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999283.1 | 2106587.2 | 37.7642451591147 | -122.44567816768298 | (37.7642451591147, -122.445678167683) | ||||||
| 102075 | 102075 | 109040 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 654 Precita Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6009911.5 | 2100416.7 | 37.7479034320272 | -122.408482100152 | (37.7479034320272, -122.408482100152) | |||||
| 102078 | 102078 | 117000 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 880x MCALLISTER ST | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | |||||
| 102204 | 102204 | 107137 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 700X Stevenson St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008444.340419999 | 2111440.4280000003 | 37.778089774899705 | -122.41433535624701 | (37.7780897748997, -122.414335356247) |
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");