Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 128143 | 128143 | 107552 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 18835 | 18835 | 114526 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 TIOGA AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6011351.0 | 2088602.0 | 37.715543251319204 | -122.402673611341 | (37.7155432513192, -122.402673611341) | |||||
| 86608 | 86608 | 85093 | Significant Tree 6 | Tree(s) :: 17 | 100 32nd Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/18/2009 12:00:00 AM | Permit Number 53112 | 5985781.7 | 2114962.8 | 37.786462080845396 | -122.49299200677 | (37.7864620808454, -122.49299200677) | |||
| 141630 | 141630 | 115750 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 340 | 100 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | |||||
| 102605 | 102605 | 121181 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 2 | 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) | |||
| 114906 | 114906 | 105678 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 101X 03RD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | 6012079.1 | 2114345.8 | 37.7862707590298 | -122.401965633825 | (37.7862707590298, -122.401965633825) | |||
| 1702 | 1702 | 251658 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1050 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 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) | ||||
| 2572 | 2572 | 24480 | Significant Tree 6 | Salix babylonica :: Weeping Willow 182 | 108X Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780363 | 6002195.08262 | 2096706.93645 | 37.737282128351005 | -122.434899824187 | (37.737282128351, -122.434899824187) | |
| 86745 | 86745 | 115730 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776540 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 111685 | 111685 | 107343 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 110 JULIAN AVE | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 6006340.8 | 2107214.1 | 37.7663669011591 | -122.421312071366 | (37.7663669011591, -122.421312071366) | ||||
| 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) | ||
| 102570 | 102570 | 94295 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 138409 | 138409 | 105227 | Significant Tree 6 | Tree(s) :: 17 | 1150X Golden Gate Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/02/2014 12:00:00 AM | Permit Number 771276 | 6004329.61165 | 2112216.22051 | 37.7799879097685 | -122.428625001082 | (37.7799879097685, -122.428625001082) | |||
| 69736 | 69736 | 99191 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1155@Sansome Battery St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Plaza | Permit Number 768022 | 6012232.15659 | 2120086.23158 | 37.8020411569217 | -122.401839756495 | (37.8020411569217, -122.401839756495) | ||
| 118401 | 118401 | 114145 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 118284 | 118284 | 115091 | Significant Tree 6 | Tree(s) :: 17 | 121 Topaz Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | Permit Number 776934 | 6001846.4 | 2098050.0 | 37.740950064786794 | -122.436201464472 | (37.7409500647868, -122.436201464472) | |||
| 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) | ||||
| 3147 | 3147 | 253098 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1290 Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 08/22/2017 12:00:00 AM | 3 | 3x3 | 5994035.0 | 2097938.0 | 37.740195634398 | -122.463202075736 | (37.740195634398, -122.463202075736) | ||
| 106535 | 106535 | 113163 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1300X STANYAN ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 3x3 | 5997565.0 | 2104877.0 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | |||
| 4659 | 4659 | 253652 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 131 Font Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x10 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
| 106567 | 106567 | 106109 | Significant Tree 6 | Magnolia champaca :: Champa 170 | 135 MENDOSA AVE | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/23/2014 12:00:00 AM | Permit Number 772704 | 5992893.2 | 2100790.2 | 37.747961208182 | -122.467357269235 | (37.747961208182, -122.467357269235) | |||
| 5055 | 5055 | 253765 | Significant Tree 6 | Acacia baileyana :: Bailey's Acacia 42 | 1366 Guerrero St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3X3 | 6005800.0848900005 | 2101007.6677599996 | 37.7492949871928 | -122.422741198761 | (37.7492949871928, -122.422741198761) | ||||
| 108061 | 108061 | 104751 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 13X JUAN BAUTISTA CIR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5989494.0 | 2090180.0 | 37.7186314952818 | -122.47833572411999 | (37.7186314952818, -122.47833572412) | |||||
| 142848 | 142848 | 108144 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 140x TOPAZ WAY | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | Permit Number 775551 | 6001767.0 | 2098265.0 | 37.741535893008106 | -122.436491384585 | (37.7415358930081, -122.436491384585) | |||
| 107622 | 107622 | 104691 | Significant Tree 6 | Tree(s) :: 17 | 1435X La Salle Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/31/2013 12:00:00 AM | Permit Number 770699 | 6016460.43075 | 2095036.9864400001 | 37.733496412822205 | -122.385461132957 | (37.7334964128222, -122.385461132957) | |||
| 118056 | 118056 | 99734 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 9 | 145 Irving St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/21/2012 12:00:00 AM | Permit Number 768746 | 5995340.8 | 2106458.8 | 37.76366673695 | -122.45930407086 | (37.76366673695, -122.45930407086) | |||
| 105444 | 105444 | 105416 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1450X McAllister St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002220.7882900005 | 2111575.67932 | 37.7781095739995 | -122.43587451144501 | (37.7781095739995, -122.435874511445) | |||||
| 128937 | 128937 | 88145 | Significant Tree 6 | Tree(s) :: 17 | 1475 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2000 12:00:00 AM | 3x3 | Permit Number 51176 | 6003147.8 | 2113351.1 | 37.7830370509294 | -122.43279450975001 | (37.7830370509294, -122.43279450975) | ||
| 159181 | 159181 | 98310 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 1499@Newhall Evans Ave | 2 | Front Yard : 25 | Tree 1 | Private 1 | 01/25/2012 12:00:00 AM | 4 | Permit Number 768575 | 6016248.7932 | 2098029.2738099997 | 37.7417009175609 | -122.38640138991501 | (37.7417009175609, -122.386401389915) | ||
| 143196 | 143196 | 98157 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 149x Chaves Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5996703.5 | 2098396.7 | 37.7416084783757 | -122.454008650942 | (37.7416084783757, -122.454008650942) | |||||
| 1646 | 1646 | 251633 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 14R Amethyst Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999202.0 | 2100044.0 | 37.746274510978395 | -122.445488137723 | (37.7462745109784, -122.445488137723) | |||||
| 103313 | 103313 | 115731 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 15 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776556 | 5993468.8 | 2097225.0 | 37.7382052810266 | -122.465107977902 | (37.7382052810266, -122.465107977902) | ||
| 129300 | 129300 | 104280 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 2 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 155517 | 155517 | 101742 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1590 Broadway | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | 8 | Permit Number 769428 | 6006220.9946099995 | 2117990.3045099997 | 37.7959489722299 | -122.422492252021 | (37.7959489722299, -122.422492252021) | ||
| 80993 | 80993 | 85086 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | ||||
| 125168 | 125168 | 85089 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | |||||
| 13821 | 13821 | 105161 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600X Oakdale Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 13 | 3x3 | 6014869.34112 | 2095641.8363700002 | 37.735069048787 | -122.39100428831499 | (37.735069048787, -122.391004288315) | |||
| 124187 | 124187 | 104433 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1601X PORTOLA DR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 5991823.0 | 2096240.0 | 37.73540567927029 | -122.47072655808 | (37.7354056792703, -122.47072655808) | ||||
| 119181 | 119181 | 33327 | Significant Tree 6 | Arbutus unedo :: Strawberry Tree 61 | 1629 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2010 12:00:00 AM | 3x3 | Originally issued under Permit Number 51411; permit expired; property changed owners; trees re-posted and permit 53716 issued | 6005242.65792202 | 2118493.60609418 | 37.7972756709044 | -122.425913331435 | (37.7972756709044, -122.425913331435) | ||
| 93355 | 93355 | 111359 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1637 OAK ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x15 | 5999143.0 | 2109364.0 | 37.771861551181395 | -122.44636250519699 | (37.7718615511814, -122.446362505197) | ||||
| 125999 | 125999 | 106361 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1645 WEBSTER ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | ||||
| 88225 | 88225 | 104494 | Significant Tree 6 | Acer circinatum :: Vine Maple 379 | 171 SAN MARCOS AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770388 | 5993514.0 | 2100282.0 | 37.7466016393389 | -122.465173679454 | (37.7466016393389, -122.465173679454) | ||||
| 138484 | 138484 | 104148 | Significant Tree 6 | Tree(s) :: 17 | 1710-1738 Diamond St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 768304 | 6001979.7 | 2099047.6 | 37.743696813668706 | -122.43581192261101 | (37.7436968136687, -122.435811922611) | ||||
| 140716 | 140716 | 99699 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1750 Divisadero St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6001124.0 | 2114376.0 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | |||||
| 81752 | 81752 | 116834 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
| 88034 | 88034 | 111070 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 1836 08TH AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 2 | 3x15 | 5993799.0 | 2102987.0 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | |||
| 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) | ||
| 117349 | 117349 | 105754 | Significant Tree 6 | Tree(s) :: 17 | 1899X Eddy St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/21/2014 12:00:00 AM | Permit Number 772599 | 6001374.8 | 2112478.6 | 37.7805406719806 | -122.438865805362 | (37.7805406719806, -122.438865805362) | |||
| 91565 | 91565 | 114074 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 18x HIGUERA AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5988029.0 | 2090212.0 | 37.718634203797706 | -122.483401916227 | (37.7186342037977, -122.483401916227) | ||||
| 93221 | 93221 | 106514 | Significant Tree 6 | Tree(s) :: 17 | 190 EUCALYPTUS DR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990695.4 | 2094728.8 | 37.7311910349726 | -122.474514801842 | (37.7311910349726, -122.474514801842) | |||||
| 179146 | 179146 | 106256 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X 18th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Permit Number 770844 | 6012014.62334 | 2105627.65597 | 37.7623291305193 | -122.401575740746 | (37.7623291305193, -122.401575740746) | |||
| 140306 | 140306 | 98695 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 191@Clarendon Forest Knolls Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.754391095173794 | -122.455633951336 | (37.7543910951738, -122.455633951336) | |||
| 20656 | 20656 | 107549 | Significant Tree 6 | Tree(s) :: 17 | 198X Jennings St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.739388557233205 | -122.377570991407 | (37.7393885572332, -122.377570991407) | ||
| 80520 | 80520 | 116010 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 198 | 199x SAN BUENAVENTURA WAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993547.0 | 2095667.0 | 37.7339319096844 | -122.464724497297 | (37.7339319096844, -122.464724497297) | ||||
| 111811 | 111811 | 112770 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1X HOWTH ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998027.0 | 2091524.0 | 37.722813474972206 | -122.44893750468901 | (37.7228134749722, -122.448937504689) | ||||
| 113067 | 113067 | 104750 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1X Junipero Serra Blvd Off Ramp | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | Permit Number 770709 | 5991326.15861 | 2088181.65405 | 37.7132507161795 | -122.47185719553998 | (37.7132507161795, -122.47185719554) | ||
| 105747 | 105747 | 113638 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1X Russ St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6009949.394180001 | 2111947.85897 | 37.7795674908256 | -122.40916462626801 | (37.7795674908256, -122.409164626268) | |||||
| 110771 | 110771 | 109970 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 1x DAVIS ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/28/2015 12:00:00 AM | 3x3 | Permit Number 774526 | 6013431.7 | 2116562.3 | 37.7924321476874 | -122.397441457592 | (37.7924321476874, -122.397441457592) | ||
| 5112 | 5112 | 253808 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 89364 | 89364 | 100695 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 2 | 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) | |||
| 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) | |||||
| 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) | |||||
| 85138 | 85138 | 103617 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 201X Haight St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6004725.0 | 2109149.0 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | |||||
| 84673 | 84673 | 110840 | Significant Tree 6 | Tree(s) :: 17 | 2037 TURK BLVD | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000252.0 | 2111948.0 | 37.779019836036206 | -122.442711981138 | (37.7790198360362, -122.442711981138) | |||||
| 19360 | 19360 | 105328 | Significant Tree 6 | Tree(s) :: 17 | 2051 03rd St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 771015 | 6015779.9 | 2106081.5 | 37.7637846705736 | -122.388584622631 | (37.7637846705736, -122.388584622631) | ||||
| 143929 | 143929 | 92898 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
| 118949 | 118949 | 114101 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 21x ACEVEDO AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988027.0 | 2090598.0 | 37.7196939458216 | -122.48343711113998 | (37.7196939458216, -122.48343711114) | ||||
| 49634 | 49634 | 112391 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 2201X LYON ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x12 | 5999307.0 | 2116423.0 | 37.7912531030346 | -122.446303107227 | (37.7912531030346, -122.446303107227) | ||||
| 87608 | 87608 | 87240 | Significant Tree 6 | Tree(s) :: 17 | 233 Arbor St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 02/14/2008 12:00:00 AM | Permit Number 50269 | 6001330.0 | 2096776.0 | 37.737422605415205 | -122.43789575270901 | (37.7374226054152, -122.437895752709) | |||
| 88091 | 88091 | 87157 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 237 Rivoli St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 50138 | 5997662.0 | 2105892.0 | 37.762243628012705 | -122.451234923187 | (37.7622436280127, -122.451234923187) | ||||
| 88432 | 88432 | 99828 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2398 Broadway | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | |||||
| 139221 | 139221 | 99831 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 198 | 2398@Steiner Broadway | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | |||||
| 81776 | 81776 | 114391 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 23x PINTO AVE | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988521.0 | 2090808.0 | 37.720299292258794 | -122.481744923362 | (37.7202992922588, -122.481744923362) | ||||
| 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) | ||||
| 144347 | 144347 | 104782 | Significant Tree 6 | Tree(s) :: 17 | 246-290X Eddy St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009232.7 | 2113643.9 | 37.7841842385635 | -122.411763863717 | (37.7841842385635, -122.411763863717) | |||||
| 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) | ||||
| 183154 | 183154 | 113770 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 2550 Broadway | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 6001403.30227 | 2117311.89486 | 37.7938132775122 | -122.43911370912501 | (37.7938132775122, -122.439113709125) | ||||
| 106634 | 106634 | 121195 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 255x Red Rock Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999917.0 | 2099808.0 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | |||
| 1357 | 1357 | 173636 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | |
| 104664 | 104664 | 122689 | Significant Tree 6 | Aesculus hippocastanum :: White Horsechestnut 364 | 2590 Pacific Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 3x8 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | |||
| 116788 | 116788 | 101979 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Tiffany Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.42052904239901 | (37.7461054290546, -122.420529042399) | |||||
| 96425 | 96425 | 116863 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 262X OAK PARK DR | 2 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 10x10 | 5995091.0 | 2103085.0 | 37.7543887826633 | -122.459923632558 | (37.7543887826633, -122.459923632558) | ||||
| 95122 | 95122 | 91107 | Significant Tree 6 | Tree(s) :: 17 | 2650 Turk Blvd | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/12/2009 12:00:00 AM | On campus | Permit Number 51996 | 5995208.0 | 2110277.0 | 37.774142880877704 | -122.46004000497801 | (37.7741428808777, -122.460040004978) | ||
| 146331 | 146331 | 91111 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2650 Turk Blvd | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | On Campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | ||||
| 90919 | 90919 | 112420 | Significant Tree 6 | Picea Spp :: Spruce Spp 357 | 268 Lily St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/29/2015 12:00:00 AM | 3 | 6005334.87738 | 2110100.0463 | 37.7742342515583 | -122.42499672664302 | (37.7742342515583, -122.424996726643) | |||
| 117755 | 117755 | 107142 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 2694 MCALLISTER ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 48 | 5996297.4 | 2110789.6 | 37.7756129427938 | -122.45630867288999 | (37.7756129427938, -122.45630867289) | ||||
| 9684 | 9684 | 173630 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2699x OCEAN AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | |||
| 2848 | 2848 | 253255 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 270 Castenada Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 10597 | 10597 | 92315 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2783 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985839.9086 | 2096474.3035 | 37.73570120363421 | -122.491429290175 | (37.7357012036342, -122.491429290175) | |
| 12690 | 12690 | 92317 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985840.9699 | 2096433.9745 | 37.7355905329114 | -122.491422653463 | (37.7355905329114, -122.491422653463) | |
| 10461 | 10461 | 92319 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2788 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985889.2586 | 2096423.8922 | 37.7355656712712 | -122.491254961509 | (37.7355656712712, -122.491254961509) | |
| 91613 | 91613 | 88453 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2801 Oakdale Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089005 | -122.40455177544202 | (37.742488010089, -122.404551775442) | |||
| 3059 | 3059 | 126695 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2829 Divisadero St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 10x10 | Permit Number 779774 | 6000551.43021 | 2118023.61416 | 37.7957189625051 | -122.44211236900601 | (37.7957189625051, -122.442112369006) | ||
| 10190 | 10190 | 173887 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 2931 20th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009454.0 | 2104482.0 | 37.759040204703496 | -122.41035112011801 | (37.7590402047035, -122.410351120118) | |||||
| 122848 | 122848 | 96328 | Significant Tree 6 | Cordyline australis :: Dracena Palm 141 | 296 Randall St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 767829 | 6003708.0 | 2097940.0 | 37.7407536226533 | -122.429756895294 | (37.7407536226533, -122.429756895294) | ||||
| 595 | 595 | 119606 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 299x Avalon Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 9750 | 9750 | 173672 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 299x Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 120295 | 120295 | 117249 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 299x GRAYSTONE TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5999641.0 | 2104067.0 | 37.7573457417117 | -122.44425918093 | (37.7573457417117, -122.44425918093) | |||
| 45605 | 45605 | 119614 | Significant Tree 6 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 2X Sutter St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6012582.0 | 2115890.0 | 37.7905388243453 | -122.400334219916 | (37.7905388243453, -122.400334219916) |
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");