Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78 | 78 | 251199 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 900X 14th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3X3 | 6002515.0 | 2107976.0 | 37.768242455454995 | -122.43459927073098 | (37.768242455455, -122.434599270731) | ||||
| 86 | 86 | 119601 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 4357x Mission St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774415 | |||||||||
| 93 | 93 | 251198 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 900X 14th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002515.0 | 2107976.0 | 37.768242455454995 | -122.43459927073098 | (37.768242455455, -122.434599270731) | |||||
| 363 | 363 | 119608 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 299x Avalon Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 595 | 595 | 119606 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 299x Avalon Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 1310 | 1310 | 251480 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 51 Peralta Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6010641.0 | 2100362.0 | 37.747794064611604 | -122.40595565659201 | (37.7477940646116, -122.405955656592) | ||||
| 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) | |||||
| 1930 | 1930 | 252828 | Significant Tree 6 | Palm (unknown Genus) :: Palm Spp 161 | 3852 17th St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1932 | 1932 | 252826 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1933 | 1933 | 252830 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1936 | 1936 | 252824 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1938 | 1938 | 252827 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 3852 17th St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 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) | |||||
| 1947 | 1947 | 252825 | Significant Tree 6 | Ilex spp :: Holly Species 163 | 3852 17th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1950 | 1950 | 252823 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 3852 17th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1957 | 1957 | 252829 | Significant Tree 6 | Palm (unknown Genus) :: Palm Spp 161 | 3852 17th St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 2196 | 2196 | 119600 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 4357x Mission St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774415 | |||||||||
| 2691 | 2691 | 253165 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 180 | 1451 Bay St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6003691.0 | 2120547.0 | 37.802825946660796 | -122.431429119577 | (37.8028259466608, -122.431429119577) | ||||
| 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) | |||||
| 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) | ||||
| 2854 | 2854 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Lopez Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 2859 | 2859 | 253251 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99X Lopez Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 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) | ||||
| 2874 | 2874 | 253252 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99X Lopez Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 4553 | 4553 | 253637 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 701 Noe St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 3ft | 6003144.80454 | 2104133.37104 | 37.757727257313704 | -122.43214639144101 | (37.7577272573137, -122.432146391441) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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 | |||||||||
| 7810 | 7810 | 119607 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 299x Avalon Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 7834 | 7834 | 119605 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 299x Avalon Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 9641 | 9641 | 114157 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9643 | 9643 | 114152 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9644 | 9644 | 114150 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9647 | 9647 | 114149 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9651 | 9651 | 114156 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9655 | 9655 | 114155 | Significant Tree 6 | Pittosporum spp :: Pittosporum spp 128 | 1200X JUNIPERO SERRA BLVD | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||||
| 9656 | 9656 | 114151 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9657 | 9657 | 114153 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9661 | 9661 | 114148 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9677 | 9677 | 114154 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200x JUNIPERO SERRA BLVD | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | ||||
| 16097 | 16097 | 104813 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1601X Portola Dr | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 17858 | 17858 | 121173 | Significant Tree 6 | Tree(s) :: 17 | 950 Duncan St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000333.0 | 2099683.0 | 37.7453477932295 | -122.44155138616101 | (37.7453477932295, -122.441551386161) | ||||
| 19350 | 19350 | 95161 | Significant Tree 6 | Acer palmatum :: Japanese Maple 175 | 2721 Pacific Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 54078 | 6001026.7 | 2116843.3 | 37.7925052022591 | -122.440383162252 | (37.7925052022591, -122.440383162252) | |||||
| 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) | |||
| 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) | |||||
| 23001 | 23001 | 251172 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 363 Jersey St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002784.74363 | 2101501.25508 | 37.750479672211 | -122.433203561601 | (37.750479672211, -122.433203561601) | |||||
| 23162 | 23162 | 251173 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 367 Jersey St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 3ft | 6002770.52649 | 2101500.0126900002 | 37.7504754543841 | -122.43325263672399 | (37.7504754543841, -122.433252636724) | ||||
| 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) | ||||
| 46601 | 46601 | 84938 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 145 Guerrero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 49347 | 6005480.0 | 2108218.0 | 37.769074802262395 | -122.42436083172 | (37.7690748022624, -122.42436083172) | ||||
| 58944 | 58944 | 100194 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 361 Dellbrook Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | |||||
| 59539 | 59539 | 98244 | Significant Tree 6 | Taxus baccata :: Irish Yew 241 | 901 Bay St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6006420.63185 | 2121080.7781 | 37.8044458892203 | -122.422021121489 | (37.8044458892203, -122.422021121489) | ||||
| 63120 | 63120 | 105071 | Significant Tree 6 | Acacia stenophylla :: Shoestring Acacia 109 | 1808 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Permit Number 771033 | 6004794.05676 | 2118138.55822 | 37.796275437823894 | -122.427440299436 | (37.7962754378239, -122.427440299436) | |||
| 67557 | 67557 | 100121 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 690 Miramar Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5995444.4 | 2093941.6 | 37.729303587844704 | -122.45803982404199 | (37.7293035878447, -122.458039824042) | |||||
| 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) | ||
| 72156 | 72156 | 104935 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 835 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 74055 | 74055 | 100572 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 3020 Washington St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Permit Number 769157 | 6000180.60876 | 2116141.82829 | 37.790530933705 | -122.44326025018299 | (37.790530933705, -122.443260250183) | |||
| 74816 | 74816 | 100209 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 108 | 701 Rhode Island St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Permit Number 769013 | 6011855.86556 | 2105057.10212 | 37.7607536567646 | -122.402084714731 | (37.7607536567646, -122.402084714731) | |||
| 75150 | 75150 | 97534 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 203 Surrey St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 768282 | 6002070.0 | 2096079.6 | 37.73555250464221 | -122.435287431957 | (37.7355525046422, -122.435287431957) | ||||
| 77671 | 77671 | 107413 | Significant Tree 6 | Pseudotsuga menziesii :: Douglas Fir 231 | 276 Yerba Buena Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 5995080.66446 | 2095640.15746 | 37.733946507354396 | -122.459420244296 | (37.7339465073544, -122.459420244296) | ||||
| 77818 | 77818 | 108026 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 862 Kansas St | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774734 | 6011570.0 | 2104296.0 | 37.758647879927395 | -122.403019866682 | (37.7586478799274, -122.403019866682) | |||||
| 77934 | 77934 | 105417 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1450X McAllister St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002220.7882900005 | 2111575.67932 | 37.7781095739995 | -122.43587451144501 | (37.7781095739995, -122.435874511445) | |||||
| 78391 | 78391 | 108038 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 Twin Peaks Blvd | Front Yard : Yard 7 | Tree 1 | Private 1 | 5998985.485719999 | 2105240.3128 | 37.760529947122706 | -122.446610614338 | (37.7605299471227, -122.446610614338) | ||||||
| 78513 | 78513 | 113727 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
| 78531 | 78531 | 104869 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 411 Holladay Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770735 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | ||||
| 78769 | 78769 | 116833 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
| 78929 | 78929 | 99659 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1325 Portola Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993615.2 | 2097760.6 | 37.7396843456359 | -122.464640684629 | (37.7396843456359, -122.464640684629) | |||||
| 79254 | 79254 | 104682 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 33 08th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | ||||
| 79287 | 79287 | 98950 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 108 | 401 Grove St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005778.2 | 2111279.0 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | |||||
| 79360 | 79360 | 112811 | Significant Tree 6 | Tree(s) :: 17 | 2023 43rd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5982877.4 | 2101339.2 | 37.748885310102104 | -122.502031530859 | (37.7488853101021, -122.502031530859) | |||||
| 79490 | 79490 | 113728 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
| 79494 | 79494 | 105555 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 410 Elizabeth St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 772516 | 6003623.1 | 2102191.9 | 37.7524235434098 | -122.430353733326 | (37.7524235434098, -122.430353733326) | ||||
| 79771 | 79771 | 105872 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 595X San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006124.4715599995 | 2100100.1430599997 | 37.7468214281195 | -122.421555015777 | (37.7468214281195, -122.421555015777) | |||||
| 80060 | 80060 | 113973 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 11 Hiliritas Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 776381 | 6001589.6 | 2096875.9 | 37.7377116664791 | -122.437005345865 | (37.7377116664791, -122.437005345865) | ||||
| 80137 | 80137 | 101978 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Tiffany Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6006502.0 | 2099737.0 | 37.7458455996049 | -122.420223786963 | (37.7458455996049, -122.420223786963) | ||||
| 80152 | 80152 | 104683 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 33 08th St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | ||||
| 80662 | 80662 | 110904 | Significant Tree 6 | Tree(s) :: 17 | 203 CORBETT AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 3x3 | 6000094.0 | 2105620.0 | 37.7616357315689 | -122.442804047122 | (37.7616357315689, -122.442804047122) | |||
| 80921 | 80921 | 104904 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 417 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 81071 | 81071 | 78107 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 970 GUERRERO ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005649.9 | 2103318.5 | 37.755631523761394 | -122.42342479955799 | (37.7556315237614, -122.423424799558) | ||||
| 81326 | 81326 | 99859 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 4443 19th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.43893032447399 | (37.7589248414166, -122.438930324474) | ||||
| 81710 | 81710 | 104892 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 Gonzalez Dr | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | ||||||
| 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) | |||||
| 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) | ||||
| 82109 | 82109 | 105208 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2694 47TH AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 5981878.3 | 2096771.8 | 37.736285749950206 | -122.50514791128201 | (37.7362857499502, -122.505147911282) | ||||||
| 82114 | 82114 | 98455 | Significant Tree 6 | Washingtonia filifera :: California Fan Palm 189 | 2200 22nd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6011565.2 | 2103754.7 | 37.7571613219705 | -122.402998394603 | (37.7571613219705, -122.402998394603) | |||||
| 82219 | 82219 | 97945 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2 Mendosa Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) |
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");