Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 185958 | 185958 | 107058 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 600X Front St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/23/2014 12:00:00 AM | 14 | Permit Number 771755 | 6012887.2102 | 2118277.8013400002 | 37.797112176041004 | -122.39944591049601 | (37.797112176041, -122.399445910496) | ||
| 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) | ||
| 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) | ||||
| 181559 | 181559 | 106870 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | 2 | Permit Number 769156 | 6008504.136630001 | 2111439.18954 | 37.778089733190605 | -122.414128411309 | (37.7780897331906, -122.414128411309) | ||
| 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) | |||
| 175900 | 175900 | 105351 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 9 | 2040 Jackson St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/16/2014 12:00:00 AM | 3 | Permit Number 769933 | 6004399.13095 | 2117053.27366 | 37.7932731788779 | -122.428729419132 | (37.7932731788779, -122.428729419132) | ||
| 175351 | 175351 | 106611 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1154 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6011908.79849 | 2103025.7220099997 | 37.7551788898075 | -122.401758852609 | (37.7551788898075, -122.401758852609) | |||
| 171955 | 171955 | 96275 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 55@ Alemany Trumbull St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6003967.5577300005 | 2094330.4049099998 | 37.73085718729 | -122.428602205549 | (37.73085718729, -122.428602205549) | ||||
| 171221 | 171221 | 112905 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2401 Keith St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6014331.87009 | 2092225.76664 | 37.725659374776605 | -122.39262364628901 | (37.7256593747766, -122.392623646289) | ||||
| 168767 | 168767 | 96276 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 55@ Alemany Trumbull St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6003946.78636 | 2094329.77315 | 37.730854277083104 | -122.428673970523 | (37.7308542770831, -122.428673970523) | ||||
| 166020 | 166020 | 99921 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1740 Jones St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6008331.64636 | 2118443.68708 | 37.7973126906849 | -122.415221079511 | (37.7973126906849, -122.415221079511) | ||||
| 164545 | 164545 | 82366 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 31 | 51 Princeton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/28/2005 12:00:00 AM | 9 | 6007564.92616 | 2093725.05049 | 37.7293979446509 | -122.416122630059 | (37.7293979446509, -122.416122630059) | ||
| 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) | ||
| 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) | ||
| 154324 | 154324 | 112045 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2418 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 18 | 3x3 | 6002446.95594 | 2117111.03197 | 37.7933210893366 | -122.435488200226 | (37.7933210893366, -122.435488200226) | |||
| 154027 | 154027 | 96278 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 55@ Alemany Trumbull St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6003898.31997 | 2094328.2986700002 | 37.7308474854131 | -122.42884142159599 | (37.7308474854131, -122.428841421596) | ||||
| 151501 | 151501 | 98241 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 3760 Washington St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/10/2012 12:00:00 AM | 9 | Permit Number 768462 | 5996814.4677800005 | 2115674.0493799997 | 37.7890540175629 | -122.45487301496999 | (37.7890540175629, -122.45487301497) | ||
| 150859 | 150859 | 106257 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X 18th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Permit Number 770844 | 6011994.4738300005 | 2105627.58235 | 37.762327804017296 | -122.401645425613 | (37.7623278040173, -122.401645425613) | |||
| 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) | ||||
| 146274 | 146274 | 100043 | Significant Tree 6 | Tree(s) :: 17 | 50 Bronte St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/12/2012 12:00:00 AM | Permit Number 769001 | 6009337.0 | 2097155.0 | 37.7389153282678 | -122.41023844976401 | (37.7389153282678, -122.410238449764) | |||
| 146206 | 146206 | 115735 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776554 | 5993777.6 | 2097002.8 | 37.737612976998896 | -122.464024183823 | (37.7376129769989, -122.464024183823) | ||
| 146133 | 146133 | 106250 | Significant Tree 6 | Tree(s) :: 17 | 580 De Haro St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770844 | 6012025.9 | 2105717.4 | 37.7625761768628 | -122.401543046462 | (37.7625761768628, -122.401543046462) | ||||
| 146084 | 146084 | 85088 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | |||||
| 146074 | 146074 | 94447 | Significant Tree 6 | Tree(s) :: 17 | 1103 Gough St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/06/2010 12:00:00 AM | 3x3 | Permit Number 53668 | 6005549.7 | 2113553.5 | 37.7837287235103 | -122.424499312595 | (37.7837287235103, -122.424499312595) | ||
| 146046 | 146046 | 117273 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 17 PEREGO TER | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999542.0 | 2101494.0 | 37.7502752643571 | -122.444416651791 | (37.7502752643571, -122.444416651791) | |||||
| 145554 | 145554 | 121180 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000x Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | ||||
| 145551 | 145551 | 121158 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 145474 | 145474 | 114257 | Significant Tree 6 | Leptospermum quinquenervia :: Tea Tree 151 | 50x CHUMASERO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990913.0 | 2088468.0 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | |||||
| 145389 | 145389 | 94463 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 744 Carolina St | 1 | : 4 | Tree 1 | Private 1 | 06/10/2010 12:00:00 AM | Permit Number 53681 | 6012327.5 | 2104524.9 | 37.759318660176504 | -122.40041614875601 | (37.7593186601765, -122.400416148756) | |||
| 145280 | 145280 | 99376 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 177 | 1088 Ashbury St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 768767 | 5998994.0 | 2106195.0 | 37.7631517661679 | -122.44664985791401 | (37.7631517661679, -122.446649857914) | ||||
| 145258 | 145258 | 96222 | Significant Tree 6 | Tree(s) :: 17 | 176 Holladay Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/18/2011 12:00:00 AM | 18 | 3x3 | Permit Number 767739 | 6010842.9 | 2100101.6 | 37.7470903528282 | -122.405239158587 | (37.7470903528282, -122.405239158587) | |
| 145255 | 145255 | 101233 | Significant Tree 6 | Tree(s) :: 17 | 3740 25th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/04/2012 12:00:00 AM | Permit Number 769197 | 6005584.0 | 2101403.0 | 37.7503682845448 | -122.423516527668 | (37.7503682845448, -122.423516527668) | |||
| 145177 | 145177 | 107016 | Significant Tree 6 | Tree(s) :: 17 | 945 SACRAMENTO ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | Permit Number 773422 | 6010352.6 | 2116759.1 | 37.7928005931964 | -122.408109164657 | (37.7928005931964, -122.408109164657) | |||
| 145164 | 145164 | 116308 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 699X DETROIT ST | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x20 | 5999400.0 | 2095202.0 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | ||||
| 145011 | 145011 | 113731 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
| 144956 | 144956 | 104445 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 507 Capp St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 2x6 | Permit Number 770679 | 6007300.0 | 2104257.5 | 37.7583027968034 | -122.41778477647301 | (37.7583027968034, -122.417784776473) | |||
| 144883 | 144883 | 94942 | Significant Tree 6 | Pyrus pyrifolia '20th Century' :: Asian Pear '20th Century' 417 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 144880 | 144880 | 103613 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 200X Buchanan St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | |||||
| 144810 | 144810 | 104762 | Significant Tree 6 | Ilex aquifolium :: European Holly 277 | 1665 18TH AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 9x9 | 5990543.2 | 2104073.0 | 37.756838968238 | -122.475723071248 | (37.756838968238, -122.475723071248) | ||||
| 144783 | 144783 | 92909 | Significant Tree 6 | Tree(s) :: 17 | 100 32nd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/18/2009 12:00:00 AM | 11 | Permit Number 53112 | 5985781.7 | 2114962.8 | 37.786462080845396 | -122.49299200677 | (37.7864620808454, -122.49299200677) | ||
| 144713 | 144713 | 103084 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 30X Zircon Pl | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6002309.6 | 2098789.5 | 37.7430068656447 | -122.43465275743601 | (37.7430068656447, -122.434652757436) | |||||
| 144632 | 144632 | 114429 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 455 EDDY ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | 3x3 | 6008254.0 | 2113439.0 | 37.783566680449795 | -122.41513531885201 | (37.7835666804498, -122.415135318852) | |||
| 144598 | 144598 | 99662 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1337 Portola Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993559.3 | 2097744.3 | 37.7396363671104 | -122.46483277796801 | (37.7396363671104, -122.464832777968) | |||||
| 144561 | 144561 | 118359 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 8 Keystone Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 3x3 | 5994105.0 | 2092664.0 | 37.72571856099329 | -122.46257757783 | (37.7257185609933, -122.46257757783) | |||
| 144536 | 144536 | 116092 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
| 144388 | 144388 | 114393 | Significant Tree 6 | Ficus Spp. :: 253 | 118x TAPIA DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 5988638.0 | 2090878.0 | 37.72049829773871 | -122.48134562114099 | (37.7204982977387, -122.481345621141) | ||||
| 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) | |||||
| 144323 | 144323 | 115460 | Significant Tree 6 | Tree(s) :: 17 | 80 Crestline Dr | 2 | 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) | ||
| 144229 | 144229 | 98696 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 191@Clarendon Forest Knolls Dr | 3 | 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) | |||
| 144227 | 144227 | 108021 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 455X Ivy St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005179.30837 | 2111099.83336 | 37.776970634543 | -122.42560603936 | (37.776970634543, -122.42560603936) | |||||
| 144144 | 144144 | 94944 | Significant Tree 6 | Pyrus pyrifolia 'Sainseiki' :: Asian Pear 'Sainseiki' 540 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 144120 | 144120 | 114104 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 400x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 3x3 | 5988116.0 | 2090625.0 | 37.7197732605649 | -122.48313145165001 | (37.7197732605649, -122.48313145165) | |||
| 144044 | 144044 | 115738 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 95x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776553 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 144015 | 144015 | 108197 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 930 FLORIDA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009368.6 | 2103733.3 | 37.7569796561067 | -122.410593604092 | (37.7569796561067, -122.410593604092) | |||||
| 143961 | 143961 | 116345 | Significant Tree 6 | Tree(s) :: 17 | 85x SANTA CLARA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777165 | 5993361.0 | 2096925.0 | 37.7373753392635 | -122.465458906558 | (37.7373753392635, -122.465458906558) | |
| 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) | ||||
| 143921 | 143921 | 113737 | Significant Tree 6 | Tree(s) :: 17 | 1580 Valencia St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/08/2015 12:00:00 AM | Permit Number 775128 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||
| 143885 | 143885 | 108210 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 524 45th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 773704 | 5981973.192319999 | 2112153.30127 | 37.778524566445206 | -122.505959887315 | (37.7785245664452, -122.505959887315) | ||||
| 143868 | 143868 | 99827 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 198 | 2398 Broadway | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | |||||
| 143856 | 143856 | 106172 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 46 | 150 CONRAD ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | 6001768.8 | 2096480.0 | 37.7366348009068 | -122.43635744032801 | (37.7366348009068, -122.436357440328) | ||||
| 143824 | 143824 | 115749 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 340 | 100 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | |||||
| 143813 | 143813 | 115751 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | ||
| 143721 | 143721 | 100473 | Significant Tree 6 | Pinus halepensis :: Allepo Pine 164 | 930 Monterey Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5995794.4 | 2094643.4 | 37.7312506649165 | -122.45688058924699 | (37.7312506649165, -122.456880589247) | |||||
| 143647 | 143647 | 120560 | Significant Tree 6 | Grevillea robusta :: Silk Oak Tree 145 | 17X Castro St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6002113.0 | 2108564.0 | 37.7698341292575 | -122.436031827668 | (37.7698341292575, -122.436031827668) | ||||
| 143633 | 143633 | 121087 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1443 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778784 | 5981521.320719999 | 2105258.5458 | 37.7595669638281 | -122.507011468719 | (37.7595669638281, -122.507011468719) | |||
| 143629 | 143629 | 96998 | Significant Tree 6 | Prunus spp :: Cherry 84 | 2451X Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.38719408923599 | (37.7197277910807, -122.387194089236) | |||||
| 143568 | 143568 | 96273 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 55@ Alemany Trumbull St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | |||||
| 143507 | 143507 | 113729 | Significant Tree 6 | Tree(s) :: 17 | 1580 Valencia St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/08/2015 12:00:00 AM | Permit Number 775128 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||
| 143283 | 143283 | 106107 | Significant Tree 6 | Magnolia champaca :: Champa 170 | 135 MENDOSA AVE | 1 | 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) | |||
| 143237 | 143237 | 104888 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 146 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 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) | |||||
| 143100 | 143100 | 101741 | Significant Tree 6 | Tree(s) :: 17 | 1590 Broadway | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | Permit Number 769428 | 6006147.8 | 2117991.4 | 37.795947850763895 | -122.422745597666 | (37.7959478507639, -122.422745597666) | |||
| 143056 | 143056 | 121179 | Significant Tree 6 | Acacia spp :: Acacia Spp 176 | 990x Duncan St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000056.0 | 2099639.0 | 37.7452111944111 | -122.442506045398 | (37.7452111944111, -122.442506045398) | ||||
| 143000 | 143000 | 105860 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 3615-3623X Cesar Chavez St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | |||||
| 142961 | 142961 | 104761 | Significant Tree 6 | Ilex aquifolium :: European Holly 277 | 1665 18TH AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 9x9 | 5990543.2 | 2104073.0 | 37.756838968238 | -122.475723071248 | (37.756838968238, -122.475723071248) | ||||
| 142904 | 142904 | 112920 | 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 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
| 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) | |||
| 142822 | 142822 | 107138 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 700X Stevenson St | 3 | 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) | |||
| 142812 | 142812 | 107493 | Significant Tree 6 | Tree(s) :: 17 | 180 BARTLETT ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11/10/2014 12:00:00 AM | 3 | Permit Number 774017 | 6006657.2 | 2102756.7 | 37.7541457516772 | -122.419901368465 | (37.7541457516772, -122.419901368465) | ||
| 142779 | 142779 | 112056 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 762 FUNSTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 8 | 5991999.0 | 2110277.0 | 37.773957792878704 | -122.47114039751001 | (37.7739577928787, -122.47114039751) | |||
| 142739 | 142739 | 84936 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 145 Guerrero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005480.0 | 2108218.0 | 37.769074802262395 | -122.42436083172 | (37.7690748022624, -122.42436083172) | |||||
| 142723 | 142723 | 98301 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 6 Locksley Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994194.0 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | |||||
| 142656 | 142656 | 121196 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 255x Red Rock Way | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999917.0 | 2099808.0 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | |||
| 142616 | 142616 | 104933 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 755 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990427.0 | 2090598.0 | 37.7198333383806 | -122.47514125414499 | (37.7198333383806, -122.475141254145) | |||||
| 142453 | 142453 | 113641 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 545X Minna St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6010081.18772 | 2112137.85468 | 37.7800965567953 | -122.40872210131901 | (37.7800965567953, -122.408722101319) | |||||
| 142403 | 142403 | 100551 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 4443 19th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.43893032447399 | (37.7589248414166, -122.438930324474) | |||||
| 142384 | 142384 | 106198 | Significant Tree 6 | Juniperus scopulorum 'Pat :: Juniper Tree 'Pathfinder' 539 | 2101 42ND AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 5983206.1 | 2100796.8 | 37.74741533456479 | -122.500854798087 | (37.7474153345648, -122.500854798087) | ||||
| 142324 | 142324 | 117253 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 2500x 34TH AVE | 3 | Side Yard : Yard 17 | Tree 1 | SFUSD 4 | 3x3 | 5985829.0 | 2097874.0 | 37.73954376030179 | -122.491570003273 | (37.7395437603018, -122.491570003273) | ||||
| 142304 | 142304 | 100054 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 401X Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011330.4 | 2112435.9 | 37.78098480794971 | -122.404421471201 | (37.7809848079497, -122.404421471201) | |
| 142282 | 142282 | 96784 | Significant Tree 6 | Acer palmatum :: Japanese Maple 175 | 615 Rhode Island St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | Permit Number 767987 | 6011854.6 | 2105476.9 | 37.7619062576766 | -122.40211860576099 | (37.7619062576766, -122.402118605761) | ||||
| 142197 | 142197 | 112354 | Significant Tree 6 | Tree(s) :: 17 | 300 Moncada Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/04/2016 12:00:00 AM | 10x10 | Permit Number 775546 | 5992209.2 | 2093928.1 | 37.729080105492 | -122.469223117768 | (37.729080105492, -122.469223117768) | ||
| 142191 | 142191 | 114191 | Significant Tree 6 | Tree(s) :: 17 | 201 Delano Ave | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | Permit Number 776814 | 6000172.52130735 | 2092388.14283689 | 37.7253086814057 | -122.44158289611 | (37.7253086814057, -122.44158289611) | |||
| 142149 | 142149 | 109294 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 370 27TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6004104.9 | 2100171.3 | 37.7469027259862 | -122.42854357326401 | (37.7469027259862, -122.428543573264) | ||||
| 142126 | 142126 | 104912 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 606 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 142099 | 142099 | 102583 | Significant Tree 6 | Tree(s) :: 17 | 22 Gennessee St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/27/2013 12:00:00 AM | Permit Number 769949 | 5997479.4 | 2093692.8 | 37.7287371564084 | -122.450986747444 | (37.7287371564084, -122.450986747444) | |||
| 142025 | 142025 | 98491 | Significant Tree 6 | Robinia pseudoacacia :: Black Locust 169 | 55X Perine Pl | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | Permit Number 768655 | 6002130.5 | 2115544.8 | 37.7890026421633 | -122.436471006098 | (37.7890026421633, -122.436471006098) | ||||
| 142007 | 142007 | 106310 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 4 | 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) | |||
| 141862 | 141862 | 105088 | Significant Tree 6 | :: 54 | 344 Fulton St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 141804 | 141804 | 96996 | Significant Tree 6 | Malus :: Crab Apple 235 | 2451X Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.38719408923599 | (37.7197277910807, -122.387194089236) | |||||
| 141746 | 141746 | 104027 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 520X Oak Park Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/25/2013 12:00:00 AM | Permit Number 770238 | 5995008.5 | 2103700.7 | 37.756074592877496 | -122.46025354267599 | (37.7560745928775, -122.460253542676) |
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");