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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1820 | 1820 | 251716 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3929 19th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003450.0 | 2104734.0 | 37.75939373993371 | -122.431133769968 | (37.7593937399337, -122.431133769968) | |||||
| 1822 | 1822 | 251717 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000X San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6004710.0 | 2096486.0 | 37.736817957153605 | -122.426188866367 | (37.7368179571536, -122.426188866367) | |||||
| 1907 | 1907 | 251816 | Undocumented 2 | Acer spp :: Maple 158 | 1800 Ellis St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6002197.0 | 2113045.0 | 37.782142606902205 | -122.436061972283 | (37.7821426069022, -122.436061972283) | ||||
| 1939 | 1939 | 252822 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 3852 17th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 2071 | 2071 | 252870 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 716 McAllister St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | ||||
| 2184 | 2184 | 89309 | Significant Tree 6 | Tree(s) :: 17 | 32 Lyon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780094 | 6000399.0 | 2109002.0 | 37.7709392449299 | -122.441991937871 | (37.7709392449299, -122.441991937871) | |
| 2186 | 2186 | 252924 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700 Sanchez St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6003672.0 | 2104202.0 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | |||||
| 2734 | 2734 | 253182 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 5157 Diamond Heights Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000788.0 | 2100195.0 | 37.7467795353698 | -122.44001478039101 | (37.7467795353698, -122.440014780391) | |||||
| 2736 | 2736 | 253183 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 5159 Diamond Heights Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000808.0 | 2099903.0 | 37.745978911495 | -122.439924689335 | (37.745978911495, -122.439924689335) | |||||
| 2869 | 2869 | 253250 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99X Lopez Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 3031 | 3031 | 78440 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 953 Key Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/12/2002 12:00:00 AM | 31 | 6013574.75289 | 2089557.5945599999 | 37.7182910313742 | -122.395054157617 | (37.7182910313742, -122.395054157617) | |||
| 3138 | 3138 | 253254 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 270 Castenada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 3256 | 3256 | 253373 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 78 Peralta Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6010457.0 | 2100357.0 | 37.7477700431666 | -122.406591570174 | (37.7477700431666, -122.406591570174) | ||||
| 3283 | 3283 | 253384 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 203 | 55 Cerritos Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5992588.0 | 2092941.0 | 37.7263916542788 | -122.46784182223999 | (37.7263916542788, -122.46784182224) | ||||
| 3284 | 3284 | 253385 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1100 Golden Gate Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004275.0 | 2112509.0 | 37.780788718892204 | -122.428834805692 | (37.7807887188922, -122.428834805692) | |||||
| 3534 | 3534 | 253482 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2179 41st Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x5 | 5983532.0 | 2100331.0 | 37.74615550514321 | -122.49969345420799 | (37.7461555051432, -122.499693454208) | ||||
| 3662 | 3662 | 253513 | Significant Tree 6 | Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 216 | 1545 05th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/14/2012 12:00:00 AM | 3x3 | Permit Number 768941 | 5994803.920580001 | 2105050.88998 | 37.7597700982665 | -122.461058902115 | (37.7597700982665, -122.461058902115) | ||
| 3689 | 3689 | 252876 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400 Baker St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000422.0 | 2113928.0 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | ||||
| 3690 | 3690 | 253398 | Undocumented 2 | Tree(s) :: 17 | 1555 Evans Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6015916.0 | 2098279.0 | 37.7423681872216 | -122.387569506434 | (37.7423681872216, -122.387569506434) | |
| 3694 | 3694 | 252874 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Post St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000387.0 | 2114050.0 | 37.784799083264396 | -122.44239591065 | (37.7847990832644, -122.44239591065) | ||||
| 3696 | 3696 | 253396 | Undocumented 2 | Tree(s) :: 17 | 400x Newhall St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780731 | 6016185.0 | 2098125.0 | 37.741960230665995 | -122.38662864108801 | (37.741960230666, -122.386628641088) | |
| 3723 | 3723 | 253167 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1X Brotherhood Way | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
| 3759 | 3759 | 253555 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 27 Ceres St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | ||||
| 3804 | 3804 | 253558 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1240 Wisconsin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012830.0 | 2101639.0 | 37.7514226163546 | -122.39847574638901 | (37.7514226163546, -122.398475746389) | |||||
| 4105 | 4105 | 253605 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 301 Teresita Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5997753.0 | 2098469.0 | 37.741867117319 | -122.45038506263799 | (37.741867117319, -122.450385062638) | ||||
| 4693 | 4693 | 253655 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1048 Ingalls St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6018024.0 | 2094000.0 | 37.7307354351655 | -122.379983340658 | (37.7307354351655, -122.379983340658) | ||||
| 4881 | 4881 | 253712 | Undocumented 2 | Pittosporum spp :: Pittosporum spp 128 | 339 Vienna St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 3ft | 6003970.0 | 2091429.0 | 37.7228907132276 | -122.428387044746 | (37.7228907132276, -122.428387044746) | ||||
| 4923 | 4923 | 253718 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 227 Madison St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6005690.0 | 2092595.0 | 37.726189474375204 | -122.422524168298 | (37.7261894743752, -122.422524168298) | ||||
| 5105 | 5105 | 253777 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
| 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) | |||
| 7681 | 7681 | 103657 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 7740 | 7740 | 9445 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/01/1994 12:00:00 AM | 12 | 3X3 | 6005680.1419 | 2112439.5166 | 37.780677364386705 | -122.423968789396 | (37.7806773643867, -122.423968789396) | ||
| 7743 | 7743 | 121449 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1274 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 10x6 | 6006927.94593 | 2119481.89109 | 37.800084349978 | -122.420151970562 | (37.800084349978, -122.420151970562) | |||
| 7764 | 7764 | 103662 | Undocumented 2 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 7809 | 7809 | 119599 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 4357x Mission St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774415 | |||||||||
| 7834 | 7834 | 119605 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 299x Avalon Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 8003 | 8003 | 109210 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2637 Larkin St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774817 | 6006569.78732 | 2120282.61277 | 37.802262741793704 | -122.421448236261 | (37.8022627417937, -122.421448236261) | |
| 8128 | 8128 | 87100 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 700 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 50056 | ||||||||
| 9555 | 9555 | 105225 | Private 5 | Juniperus chinensis :: Juniper 19 | 175 Spruce St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5997195.09596 | 2114417.64894 | 37.785626103218895 | -122.453465347546 | (37.7856261032189, -122.453465347546) | ||||
| 9883 | 9883 | 173726 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1101 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6013424.0 | 2101939.0 | 37.752279425117294 | -122.396442635345 | (37.7522794251173, -122.396442635345) | |||||
| 9912 | 9912 | 173731 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 484 Chenery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003566.0 | 2096120.0 | 37.7357482768139 | -122.43011807363199 | (37.7357482768139, -122.430118073632) | |||||
| 9974 | 9974 | 173765 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
| 10099 | 10099 | 173842 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 288X Graystone Ter | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999483.0 | 2103863.0 | 37.7567765924541 | -122.444790942005 | (37.7567765924541, -122.444790942005) | |||||
| 10174 | 10174 | 173886 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 2931 20th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009454.0 | 2104482.0 | 37.759040204703496 | -122.41035112011801 | (37.7590402047035, -122.410351120118) | |||||
| 10256 | 10256 | 173933 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 Beacon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003193.0 | 2097540.0 | 37.739626138558705 | -122.43150902083299 | (37.7396261385587, -122.431509020833) | |||||
| 11662 | 11662 | 102569 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 0 Diaz Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/04/2013 12:00:00 AM | 2 | Permit Number 769785 | 5990053.95839 | 2089992.8197400002 | 37.7181500356804 | -122.476386530439 | (37.7181500356804, -122.476386530439) | ||
| 12540 | 12540 | 108677 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 11 Otsego Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | Permit Number 773206 | 6000966.57436 | 2092971.8241299998 | 37.7269565451936 | -122.438879746024 | (37.7269565451936, -122.438879746024) | |
| 13267 | 13267 | 187629 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 4283 23rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6001353.0 | 2102279.0 | 37.7525338497288 | -122.43821033719401 | (37.7525338497288, -122.438210337194) | ||||
| 13296 | 13296 | 187658 | Property Tree 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 600X Clarendon Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5995637.0 | 2102382.0 | 37.7524899085688 | -122.457984564932 | (37.7524899085688, -122.457984564932) | ||||
| 18684 | 18684 | 109456 | Permitted Site 1 | Tree(s) :: 17 | 951 GILMAN AVE | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/24/2015 12:00:00 AM | 3 | Permit Number 774986 | 6015934.0 | 2089205.0 | 37.717453787650705 | -122.38687458595501 | (37.7174537876507, -122.386874585955) | ||
| 18793 | 18793 | 114373 | Property Tree 7 | Liquidambar styraciflua :: American Sweet Gum 62 | 805 GONZALEZ DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 5988302.0 | 2089566.0 | 37.7168763353695 | -122.482410970247 | (37.7168763353695, -122.482410970247) | ||||
| 18877 | 18877 | 82435 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 51 Peralta Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/02/2005 12:00:00 AM | 20 | 6010636.52703341 | 2100363.58782589 | 37.7477981742678 | -122.405971235802 | (37.7477981742678, -122.405971235802) | |||
| 18891 | 18891 | 107407 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 171 TWIN PEAKS BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5998631.4 | 2104681.4 | 37.7589750798494 | -122.44779499190099 | (37.7589750798494, -122.447794991901) | ||||
| 19018 | 19018 | 102131 | Significant Tree 6 | Tree(s) :: 17 | 850 Treat Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/24/2012 12:00:00 AM | Permit Number 769452 | 6008548.2 | 2103592.2 | 37.7565461982029 | -122.41342088796499 | (37.7565461982029, -122.413420887965) | |||
| 19405 | 19405 | 103965 | Significant Tree 6 | Tree(s) :: 17 | 141 Marview Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/11/2013 12:00:00 AM | Permit Number 770303 | 5998318.6 | 2103174.0 | 37.7548182509721 | -122.448768222318 | (37.7548182509721, -122.448768222318) | |||
| 19583 | 19583 | 119914 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 400X Brotherhood Way | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 100x100 | |||||||||
| 19656 | 19656 | 101900 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1100 Ocean Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 19797 | 19797 | 97906 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 401 Upper Ter | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2011 12:00:00 AM | 60 | Permit Number 768366 | 5999222.6 | 2106240.8 | 37.7632905770055 | -122.44586250428002 | (37.7632905770055, -122.44586250428) | ||
| 20477 | 20477 | 104866 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 411 Holladay Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | |||||
| 20865 | 20865 | 103256 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 4187 26th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 3x3 | 6002700.0 | 2100625.0 | 37.7480688746475 | -122.433434000346 | (37.7480688746475, -122.433434000346) | |||
| 22288 | 22288 | 237856 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 636 30th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 6ft | 6002455.57988 | 2098272.49197 | 37.7415955682714 | -122.434111048608 | (37.7415955682714, -122.434111048608) | |||
| 22304 | 22304 | 248911 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 1633 Oakdale Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6014844.92913 | 2095599.8976 | 37.7349525388235 | -122.39108575959101 | (37.7349525388235, -122.391085759591) | |||||
| 22308 | 22308 | 248932 | Landmark tree 9 | Araucaria heterophylla :: Norfolk Island Pine 24 | 46 Cook St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 | 5997514.0 | 2113392.0 | 37.7828282170553 | -122.452288002469 | (37.7828282170553, -122.452288002469) | ||||
| 22822 | 22822 | 248039 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 21 Rutledge St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010496.95071 | 2099420.9430400003 | 37.745202070015296 | -122.406387476112 | (37.7452020700153, -122.406387476112) | ||||
| 23961 | 23961 | 247944 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 21 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010317.99645 | 2098902.9194900002 | 37.7437696775404 | -122.40696976733999 | (37.7437696775404, -122.40696976734) | ||||
| 24400 | 24400 | 220351 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 3921 21st St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6002309.75741 | 2103525.9195 | 37.7560119615059 | -122.434990881437 | (37.7560119615059, -122.434990881437) | ||||
| 24447 | 24447 | 201523 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 799 Earl St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 10ft | 6020371.96237 | 2093662.3098400002 | 37.729937451546704 | -122.371842613372 | (37.7299374515467, -122.371842613372) | |||
| 25153 | 25153 | 219212 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 1501 15th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5991536.71945 | 2105150.6616 | 37.759855492149704 | -122.47236570472 | (37.7598554921497, -122.47236570472) | ||||
| 25418 | 25418 | 191034 | Undocumented 2 | Diospyros kaki :: Persimmon 293 | 2338 Lane St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 6ft | 6013925.13865 | 2092881.2708700001 | 37.727436659956005 | -122.394075563956 | (37.727436659956, -122.394075563956) | |||
| 25672 | 25672 | 247989 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 130 Mullen Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 10ft | 6009899.29934 | 2099821.3308900003 | 37.7462679959733 | -122.40848229933901 | (37.7462679959733, -122.408482299339) | |||
| 25843 | 25843 | 121699 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 1002 Pennsylvania Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6014459.10408 | 2102474.46412 | 37.753807243829 | -122.392900512462 | (37.753807243829, -122.392900512462) | ||||
| 26417 | 26417 | 247936 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1149 Esmeralda Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010249.43041 | 2098747.94631 | 37.7433403177918 | -122.40719593154101 | (37.7433403177918, -122.407195931541) | ||||
| 26650 | 26650 | 109414 | Significant Tree 6 | Persea americana :: Avocado 113 | 4 GUY PL | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6014378.1 | 2114502.6 | 37.786829336844605 | -122.394022608955 | (37.7868293368446, -122.394022608955) | ||||
| 26728 | 26728 | 197173 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1900 23rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6012739.26156 | 2102864.49072 | 37.7547824929244 | -122.39887553350201 | (37.7547824929244, -122.398875533502) | ||||
| 27051 | 27051 | 196337 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 602 Arthur Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015979.32592 | 2099953.2392599997 | 37.7469688106565 | -122.38746731498199 | (37.7469688106565, -122.387467314982) | ||||
| 27200 | 27200 | 209021 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 34 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6000790.06178 | 2095561.6998400001 | 37.7340577017886 | -122.43967553722 | (37.7340577017886, -122.43967553722) | ||||
| 27984 | 27984 | 204834 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1676 09th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 6ft | 5993429.17197 | 2104103.8615599996 | 37.7570905984748 | -122.465744634126 | (37.7570905984748, -122.465744634126) | |||
| 29139 | 29139 | 194295 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1942 Quesada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | Width 10ft | 6013443.13195 | 2096013.71128 | 37.7360108970885 | -122.395961290278 | (37.7360108970885, -122.395961290278) | |||
| 29357 | 29357 | 125421 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 952 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6008979.12848 | 2118712.4234 | 37.7980869413024 | -122.41299962903601 | (37.7980869413024, -122.412999629036) | ||||
| 29361 | 29361 | 246743 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 140 Ripley St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6008904.95931 | 2099075.9410099997 | 37.7441655842699 | -122.411867956365 | (37.7441655842699, -122.411867956365) | ||||
| 29564 | 29564 | 237905 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 3937 21st St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6002227.46362 | 2103520.4707299997 | 37.7559923274905 | -122.435275090576 | (37.7559923274905, -122.435275090576) | ||||
| 29900 | 29900 | 213665 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 3ft | 5994824.1493 | 2098927.22664 | 37.7429572344905 | -122.460545199208 | (37.7429572344905, -122.460545199208) | |||
| 29908 | 29908 | 249959 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 273 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | Width 0ft | 6011558.5565599995 | 2120064.53903 | 37.801943979781896 | -122.40416921824301 | (37.8019439797819, -122.404169218243) | |||
| 30066 | 30066 | 178334 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 11 Pilgrim Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 79 | 6000689.70014 | 2093938.9080400001 | 37.729596178617705 | -122.439906202537 | (37.7295961786177, -122.439906202537) | ||||
| 30086 | 30086 | 121490 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 400x Vermont St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 24 | 6011163.12299 | 2106299.7163 | 37.7641269067524 | -122.40456808916201 | (37.7641269067524, -122.404568089162) | ||||
| 30171 | 30171 | 194414 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 2190 Revere Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6011991.11483 | 2096738.36261 | 37.737919746788705 | -122.401032427923 | (37.7379197467887, -122.401032427923) | ||||
| 30202 | 30202 | 196060 | Undocumented 2 | Prunus armeniaca :: Apricot 259 | 955 Kansas St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6011632.64941 | 2103950.5109599996 | 37.757702741818 | -122.40277889784299 | (37.757702741818, -122.402778897843) | ||||
| 30242 | 30242 | 247859 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Bradford St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6009590.028030001 | 2098126.55062 | 37.741597175379894 | -122.409432139892 | (37.7415971753799, -122.409432139892) | ||||
| 30434 | 30434 | 248121 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 109 Brewster St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010387.395819999 | 2099398.52057 | 37.7451343735684 | -122.40676472010901 | (37.7451343735684, -122.406764720109) | ||||
| 30956 | 30956 | 191848 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1951 Revere Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6013055.009930001 | 2095902.15156 | 37.735682976376204 | -122.397295372485 | (37.7356829763762, -122.397295372485) | ||||
| 31219 | 31219 | 194283 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Tulare St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 44 | 6016255.79944 | 2100318.37917 | 37.747986718206604 | -122.386536741486 | (37.7479867182066, -122.386536741486) | ||||
| 31705 | 31705 | 249964 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 265 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6011637.77879 | 2120097.34238 | 37.802038476045496 | -122.403897380163 | (37.8020384760455, -122.403897380163) | |||
| 31869 | 31869 | 248052 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 19 Rutledge St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6010613.31023 | 2099368.8774099997 | 37.7450656176979 | -122.405981455594 | (37.7450656176979, -122.405981455594) | ||||
| 32434 | 32434 | 189222 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 101 Pennsylvania Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6014335.23001 | 2106254.12043 | 37.764178481086205 | -122.39359341489799 | (37.7641784810862, -122.393593414898) | ||||
| 32465 | 32465 | 248037 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 55 Rutledge St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6010488.35763 | 2099431.59018 | 37.745230824035204 | -122.40641793974599 | (37.7452308240352, -122.406417939746) | ||||
| 32547 | 32547 | 135824 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1013 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6008637.906 | 2118634.49639 | 37.7978538127598 | -122.41417484600099 | (37.7978538127598, -122.414174846001) | ||||
| 33034 | 33034 | 129083 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 1000 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6008684.91148 | 2118672.65791 | 37.797961234983504 | -122.414014894389 | (37.7979612349835, -122.414014894389) | ||||
| 33366 | 33366 | 124269 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 9 03rd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 5994882.44582 | 2114964.8982 | 37.7869958645771 | -122.461506079992 | (37.7869958645771, -122.461506079992) | ||||
| 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) | |||
| 33614 | 33614 | 188708 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Bridgeview Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6014073.74253 | 2095336.92691 | 37.734187650237395 | -122.393733643518 | (37.7341876502374, -122.393733643518) |
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");