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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100045 | 100045 | 120550 | DPW Maintained 3 | Acer macrophyllum :: Big Leaf Maple 159 | 298x Corbett Ave | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 10 | Permit Number 778898 | 5999572.0 | 2105342.0 | 37.7608426398345 | -122.444589445505 | (37.7608426398345, -122.444589445505) | |||
| 100141 | 100141 | 121157 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 103109 | 103109 | 117003 | Permitted Site 1 | Tree(s) :: 17 | 1701x PACHECO ST | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778399 | 5989693.0 | 2101699.0 | 37.750271267074 | -122.47848974966101 | (37.750271267074, -122.478489749661) | |
| 112260 | 112260 | 117251 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 2500x 34TH AVE | 1 | Side Yard : Yard 17 | Tree 1 | SFUSD 4 | 3x3 | 5985829.0 | 2097874.0 | 37.73954376030179 | -122.491570003273 | (37.7395437603018, -122.491570003273) | ||||
| 114561 | 114561 | 114882 | DPW Maintained 3 | Salix babylonica :: Weeping Willow 182 | 801x Alemany Blvd | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 6004188.833980001 | 2094500.26728 | 37.731336111506295 | -122.42784931643499 | (37.7313361115063, -122.427849316435) | |||||
| 120316 | 120316 | 121151 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1X Payson St | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 25 | 3x3 | 5992041.0 | 2087761.0 | 37.7121370380572 | -122.469355880776 | (37.7121370380572, -122.469355880776) | |||
| 121639 | 121639 | 117546 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 122220 | 122220 | 188563 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1 Waterville St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6011470.31075 | 2096143.8224099998 | 37.7362581989524 | -122.402791312072 | (37.7362581989524, -122.402791312072) | ||||
| 122555 | 122555 | 126122 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2833 Larkin St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6006473.28428 | 2120942.81763 | 37.804070054442 | -122.42182910722799 | (37.804070054442, -122.421829107228) | ||||
| 123361 | 123361 | 117295 | Significant Tree 6 | Tree(s) :: 17 | 130 CAMBON DR | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 5990450.0 | 2089482.0 | 37.7167704112637 | -122.47498033116501 | (37.7167704112637, -122.474980331165) | ||||
| 130946 | 130946 | 177832 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 648 Peru Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6005040.015980001 | 2092604.7564 | 37.7261795732245 | -122.424771822965 | (37.7261795732245, -122.424771822965) | ||||
| 131223 | 131223 | 118635 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 349 Point Lobos Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 29 | 5981642.90919 | 2112624.80307 | 37.779799724333294 | -122.50713742957399 | (37.7797997243333, -122.507137429574) | ||||
| 131514 | 131514 | 213997 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1500 16th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 5991180.77064 | 2105068.88436 | 37.7596103459632 | -122.47359078009501 | (37.7596103459632, -122.473590780095) | ||||
| 132813 | 132813 | 201611 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 98 Jerrold Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 9ft | 6020793.34161 | 2092957.5019 | 37.7280253184122 | -122.37033713297501 | (37.7280253184122, -122.370337132975) | |||
| 132984 | 132984 | 175066 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 Thornton Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010981.076169999 | 2094029.55145 | 37.73042552801979 | -122.40433403878599 | (37.7304255280198, -122.404334038786) | ||||
| 133560 | 133560 | 247858 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 82 Bradford St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6009570.7437 | 2098077.6511 | 37.7414618274161 | -122.40949536852501 | (37.7414618274161, -122.409495368525) | ||||
| 133793 | 133793 | 206299 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 231 Edna St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 5998763.35609 | 2095379.2875599999 | 37.733441276780205 | -122.446669340837 | (37.7334412767802, -122.446669340837) | ||||
| 133850 | 133850 | 175204 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 653 Peru Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6005107.433759999 | 2092594.0364400002 | 37.72615394614 | -122.424538001034 | (37.72615394614, -122.424538001034) | ||||
| 133976 | 133976 | 187580 | Undocumented 2 | Araucaria columnaris :: Coral reef araucaria 185 | 297 Elliot St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6008925.29742 | 2088423.47753 | 37.7149173344326 | -122.411045360877 | (37.7149173344326, -122.411045360877) | ||||
| 134892 | 134892 | 249849 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 289 Greenwich St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6011439.22895 | 2120384.4493 | 37.8028157070334 | -122.40460468348499 | (37.8028157070334, -122.404604683485) | |||
| 136091 | 136091 | 178347 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 99 Bowdoin St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 6008416.70539 | 2094741.77162 | 37.7322374982533 | -122.413249807854 | (37.7322374982533, -122.413249807854) | ||||
| 136128 | 136128 | 218153 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 22 Ashton Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 5994153.71185 | 2090014.1877400002 | 37.7184456203604 | -122.46221709555 | (37.7184456203604, -122.46221709555) | ||||
| 137329 | 137329 | 134502 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | Width 4ft | 6008165.1975300005 | 2112116.84845 | 37.779931379274004 | -122.415348912733 | (37.779931379274, -122.415348912733) | |||
| 138080 | 138080 | 247822 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3514 Folsom St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6008510.026459999 | 2098371.0987299997 | 37.7422080785429 | -122.413183721146 | (37.7422080785429, -122.413183721146) | ||||
| 138174 | 138174 | 233332 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 24 Saturn St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6000503.342180001 | 2106030.7905200003 | 37.7627869888479 | -122.44141778031201 | (37.7627869888479, -122.441417780312) | |||
| 147088 | 147088 | 247846 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 149 Chapman St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6009148.8704 | 2098211.07705 | 37.7418045383459 | -122.410963488373 | (37.7418045383459, -122.410963488373) | ||||
| 147311 | 147311 | 205445 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 300 Melrose Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 5998069.65907 | 2095547.09422 | 37.7338623834248 | -122.449079720856 | (37.7338623834248, -122.449079720856) | ||||
| 147897 | 147897 | 187545 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1399 Somerset St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6011375.77756 | 2088317.82522 | 37.714764348070204 | -122.40256799691002 | (37.7147643480702, -122.40256799691) | ||||
| 148697 | 148697 | 227017 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 31 Poppy Ln | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 2ft | 6002132.64017 | 2096807.6586799999 | 37.7375551427627 | -122.435122918088 | (37.7375551427627, -122.435122918088) | |||
| 149350 | 149350 | 247902 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 377 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6009819.79405 | 2098407.16553 | 37.74238055412221 | -122.40865747466499 | (37.7423805541222, -122.408657474665) | ||||
| 150119 | 150119 | 249838 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 305 Greenwich St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 0ft | 6011296.05526 | 2120375.39097 | 37.8027828323166 | -122.405099502142 | (37.8027828323166, -122.405099502142) | |||
| 150225 | 150225 | 248044 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 38 Rutledge St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6010553.661280001 | 2099412.7108 | 37.7451826383612 | -122.40619079978501 | (37.7451826383612, -122.406190799785) | ||||
| 152144 | 152144 | 223808 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 6 Miguel St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 6003326.01138 | 2097344.7820099997 | 37.739097652747205 | -122.431035195413 | (37.7390976527472, -122.431035195413) | ||||
| 152624 | 152624 | 246651 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009062.258230001 | 2099181.14023 | 37.7444632616835 | -122.41133147927401 | (37.7444632616835, -122.411331479274) | ||||
| 153002 | 153002 | 247975 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 503 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6009813.28917 | 2099236.8138200003 | 37.744658223 | -122.40873848381099 | (37.744658223, -122.408738483811) | ||||
| 153202 | 153202 | 132422 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Vallejo St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6008806.4990300005 | 2118647.23011 | 37.7978982446696 | -122.413592365905 | (37.7978982446696, -122.413592365905) | ||||
| 153590 | 153590 | 248107 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 138 Rutledge St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6010423.63855 | 2099478.50343 | 37.7453560168793 | -122.406645033853 | (37.7453560168793, -122.406645033853) | ||||
| 154158 | 154158 | 132459 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1109 Chestnut St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6006454.20417 | 2120400.58953 | 37.8025801584021 | -122.42185659591699 | (37.8025801584021, -122.421856595917) | ||||
| 154241 | 154241 | 222765 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 272 Corbett Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 5999637.29501 | 2105376.06979 | 37.760939912666004 | -122.444366068238 | (37.760939912666, -122.444366068238) | |||
| 157311 | 157311 | 247865 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 400 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6009511.40819 | 2098411.1338400003 | 37.742374173428004 | -122.40972406433201 | (37.742374173428, -122.409724064332) | ||||
| 158284 | 158284 | 250003 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 232 Filbert St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 0ft | 6011516.941380001 | 2120107.55399 | 37.802059763016096 | -122.404316256511 | (37.8020597630161, -122.404316256511) | |||
| 158327 | 158327 | 194694 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1750 22nd St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6012866.59255 | 2103798.94499 | 37.757355394863794 | -122.398500751831 | (37.7573553948638, -122.398500751831) | ||||
| 158925 | 158925 | 248059 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 18 Rutledge St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 41 | 6010698.28988 | 2099365.5413599997 | 37.7450612101031 | -122.40568737459299 | (37.7450612101031, -122.405687374593) | ||||
| 159551 | 159551 | 247520 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6000003.99995 | 2108482.26842 | 37.7694896756401 | -122.443320913055 | (37.7694896756401, -122.443320913055) | ||||
| 160690 | 160690 | 118626 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 499 46th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 10ft | 5981578.2503 | 2112431.17888 | 37.7792642811872 | -122.507346739716 | (37.7792642811872, -122.507346739716) | |||
| 161645 | 161645 | 194297 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2198 Revere Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6011968.87844 | 2096761.7845599998 | 37.737982818059294 | -122.40111095580299 | (37.7379828180593, -122.401110955803) | ||||
| 162418 | 162418 | 249770 | Undocumented 2 | Schinus molle :: California Pepper 138 | 102 Pfeiffer St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 0ft | 6010494.56062 | 2121168.81632 | 37.8049165440205 | -122.407929079557 | (37.8049165440205, -122.407929079557) | |||
| 162455 | 162455 | 195979 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 900 Phelps St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 30 | Width 9ft | 6014704.25324 | 2097268.53042 | 37.739526454869704 | -122.39168875963999 | (37.7395264548697, -122.39168875964) | |||
| 162601 | 162601 | 178307 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 623 Brotherhood Way | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | Width 0ft | 5990951.00825 | 2088079.7183700001 | 37.712949111472604 | -122.473146401692 | (37.7129491114726, -122.473146401692) | |||
| 164724 | 164724 | 187547 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1398 Somerset St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6011342.64618 | 2088318.4988900002 | 37.71476434807511 | -122.402682560663 | (37.7147643480751, -122.402682560663) | ||||
| 165775 | 165775 | 249954 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 303 Filbert St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 0ft | 6011374.5207 | 2120037.6372700003 | 37.8018598293151 | -122.404804177386 | (37.8018598293151, -122.404804177386) | |||
| 166245 | 166245 | 248084 | Undocumented 2 | Acacia decurrens :: Acacia: Silver Wattle 181 | 15 Montcalm St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6010670.84523 | 2100349.03377 | 37.7477601313264 | -122.40585153953998 | (37.7477601313264, -122.40585153954) | ||||
| 166544 | 166544 | 176163 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 654 Peru Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6005125.75661 | 2092550.7271200002 | 37.726036063007705 | -122.42447158070601 | (37.7260360630077, -122.424471580706) | ||||
| 166763 | 166763 | 247928 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6010393.74755 | 2098772.89885 | 37.7434169076795 | -122.406698675702 | (37.7434169076795, -122.406698675702) | ||||
| 166987 | 166987 | 247992 | Undocumented 2 | Cedrus atlantica :: Atlas Cedar 304 | 260 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6009735.72559 | 2099644.7711400003 | 37.7457740397574 | -122.40903546421998 | (37.7457740397574, -122.40903546422) | ||||
| 168432 | 168432 | 248087 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 14 Montcalm St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6010655.20977 | 2100360.58155 | 37.747790964577 | -122.40590641976699 | (37.747790964577, -122.405906419767) | ||||
| 169254 | 169254 | 236090 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 200 Corbin Pl | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 3ft | 6000058.01731 | 2105721.74002 | 37.7619130330791 | -122.442935802668 | (37.7619130330791, -122.442935802668) | |||
| 169459 | 169459 | 249955 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 285 Filbert St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6011505.97031 | 2120064.83328 | 37.801941849301 | -122.404351213161 | (37.801941849301, -122.404351213161) | |||
| 169491 | 169491 | 246623 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3300 Harrison St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6009020.22785 | 2099406.68522 | 37.7450802011034 | -122.41149274390101 | (37.7450802011034, -122.411492743901) | ||||
| 169579 | 169579 | 187557 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 3959 Somerset St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6011334.94928 | 2088323.74418 | 37.71477832084229 | -122.40270953314301 | (37.7147783208423, -122.402709533143) | ||||
| 170181 | 170181 | 248235 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 301 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 29 | 6006740.56255 | 2099063.9997900003 | 37.7440111320042 | -122.419351135062 | (37.7440111320042, -122.419351135062) | ||||
| 170456 | 170456 | 240330 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 1275 San Jose Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6003923.42572 | 2095674.7129099998 | 37.7345458564984 | -122.428850578486 | (37.7345458564984, -122.428850578486) | ||||
| 171449 | 171449 | 249865 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1497 Montgomery St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | Width 0ft | 6011350.601919999 | 2120707.91777 | 37.8036989186248 | -122.404934168095 | (37.8036989186248, -122.404934168095) | |||
| 172072 | 172072 | 187778 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Middle Point Rd | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 6ft | 6018276.18855 | 2096495.79876 | 37.7376023175876 | -122.37928476769899 | (37.7376023175876, -122.379284767699) | |||
| 172369 | 172369 | 191849 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1998 Revere Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6013048.000580001 | 2095925.65097 | 37.735747110629 | -122.397321254093 | (37.735747110629, -122.397321254093) | ||||
| 172744 | 172744 | 196477 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1499 Rankin St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 3ft | 6012648.615180001 | 2096647.7620400002 | 37.7377076327033 | -122.39875275533501 | (37.7377076327033, -122.398752755335) | |||
| 173301 | 173301 | 194438 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1051 18th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6014405.25344 | 2105708.40792 | 37.762683964324495 | -122.39331303148 | (37.7626839643245, -122.39331303148) | ||||
| 173566 | 173566 | 187579 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 299 Elliot St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | 6008885.34324 | 2088289.2599799999 | 37.7145465601547 | -122.411173984595 | (37.7145465601547, -122.411173984595) | ||||
| 173605 | 173605 | 226941 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 300 Fairmount St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6004051.37428 | 2097144.63452 | 37.738589168851206 | -122.42851295770399 | (37.7385891688512, -122.428512957704) | ||||
| 176182 | 176182 | 247880 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 387 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6009937.12086 | 2098396.47956 | 37.742357783277996 | -122.40825103864799 | (37.742357783278, -122.408251038648) | ||||
| 176645 | 176645 | 178270 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 35 Tomaso Ct | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 3ft | 6009167.93697 | 2086263.08528 | 37.7089989437285 | -122.41005426658701 | (37.7089989437285, -122.410054266587) | |||
| 176872 | 176872 | 248241 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 296 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 63 | 6006778.03314 | 2099006.59157 | 37.743855612256 | -122.419217498503 | (37.743855612256, -122.419217498503) | ||||
| 178075 | 178075 | 178250 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 287 Hester Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6012202.6988699995 | 2087794.30309 | 37.713372992543896 | -122.39967306036199 | (37.7133729925439, -122.399673060362) | ||||
| 178929 | 178929 | 247983 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 497 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6009757.51939 | 2099637.18115 | 37.74575442014729 | -122.408959568646 | (37.7457544201473, -122.408959568646) | ||||
| 179179 | 179179 | 225241 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 301 Fairmount St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6004065.1857199995 | 2097137.17926 | 37.7385694799892 | -122.428464673104 | (37.7385694799892, -122.428464673104) | ||||
| 179249 | 179249 | 206474 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 230 Edna St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 5998806.12443 | 2095305.20487 | 37.73324030618979 | -122.446516151203 | (37.7332403061898, -122.446516151203) | ||||
| 179334 | 179334 | 136052 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1114 Greenwich St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6007569.13805 | 2119905.68389 | 37.801284085155004 | -122.41796325270201 | (37.801284085155, -122.417963252702) | ||||
| 179933 | 179933 | 248234 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 299 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6006807.51712 | 2099039.75283 | 37.7439483260488 | -122.419117901273 | (37.7439483260488, -122.419117901273) | ||||
| 180928 | 180928 | 248055 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 17 Rutledge St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010658.86611 | 2099354.83953 | 37.745029620524605 | -122.405822941986 | (37.7450296205246, -122.405822941986) | ||||
| 181115 | 181115 | 203656 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 232 Edna St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 5998785.56076 | 2095387.29688 | 37.733464536852395 | -122.446593149381 | (37.7334645368524, -122.446593149381) | ||||
| 181293 | 181293 | 247981 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 499 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009794.7729400005 | 2099497.71505 | 37.7453735635492 | -122.40882091295 | (37.7453735635492, -122.40882091295) | ||||
| 181546 | 181546 | 125276 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1285 Greenwich St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6006714.64641 | 2119759.73621 | 37.800835221824 | -122.420909807645 | (37.800835221824, -122.420909807645) | ||||
| 182365 | 182365 | 201726 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1411 Phelps St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6013752.92787 | 2095946.3891599998 | 37.735843275152995 | -122.394885479886 | (37.735843275153, -122.394885479886) | ||||
| 183364 | 183364 | 247818 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1058 Jarboe Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 46 | 6009634.533480001 | 2096844.3676599998 | 37.738079072495395 | -122.409187798594 | (37.7380790724954, -122.409187798594) | ||||
| 184220 | 184220 | 247977 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 501 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 6009780.56598 | 2099401.3305099998 | 37.7451081169387 | -122.408863239563 | (37.7451081169387, -122.408863239563) | ||||
| 185796 | 185796 | 214455 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 449 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 6000738.084840001 | 2095503.40232 | 37.733894671806 | -122.439851058803 | (37.733894671806, -122.439851058803) | |||
| 185900 | 185900 | 201701 | Undocumented 2 | Acacia decurrens :: Acacia: Silver Wattle 181 | 43 Gilroy St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | Width 0ft | 6015213.19192 | 2088555.8526400002 | 37.71563141862261 | -122.389320803321 | (37.7156314186226, -122.389320803321) | |||
| 186554 | 186554 | 250195 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 0ft | 6011875.28376 | 2119779.56963 | 37.8011792152183 | -122.40305313080401 | (37.8011792152183, -122.403053130804) | |||
| 187893 | 187893 | 130609 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1500 Beach St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6002918.83172 | 2121356.11513 | 37.80500377108171 | -122.43415909039699 | (37.8050037710817, -122.434159090397) | ||||
| 3270 | 3270 | 253380 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 3280 | 3280 | 253389 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 30X Grand View Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 6000475.0 | 2103841.0 | 37.756772747069604 | -122.44135867200701 | (37.7567727470696, -122.441358672007) | ||||
| 3610 | 3610 | 115725 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 250X Octavia St | 2 | Side Yard : Yard 17 | Tree 1 | Dept of Real Estate 5 | ||||||||||
| 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) | ||||
| 9987 | 9987 | 173779 | Significant Tree 6 | Ficus macrophylla :: Morton Bay Fig 148 | 99X Cleveland St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x6 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 13271 | 13271 | 187638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
| 24579 | 24579 | 247929 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 6010384.7561099995 | 2098766.60945 | 37.743399135274295 | -122.40672932282301 | (37.7433991352743, -122.406729322823) | ||||
| 28898 | 28898 | 250221 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 312 Filbert St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 0ft | 6011282.00764 | 2120080.85256 | 37.8019733165766 | -122.405127362244 | (37.8019733165766, -122.405127362244) | |||
| 29820 | 29820 | 187571 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 73 Bishop St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6010860.52073 | 2089475.11103 | 37.7179132396708 | -122.40443035886899 | (37.7179132396708, -122.404430358869) | ||||
| 30048 | 30048 | 132396 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 40 | 6006504.32212 | 2120945.10898 | 37.804078096188704 | -122.421721861273 | (37.8040780961887, -122.421721861273) | ||||
| 30472 | 30472 | 247853 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80 Bradford St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6009574.28658 | 2098178.5899099996 | 37.7417391819242 | -122.40949024059401 | (37.7417391819242, -122.409490240594) |
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");