Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189024 | 189024 | 209189 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 156 Kensington Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 3ft | 5994812.38667 | 2098544.02713 | 37.7419043873887 | -122.460558108972 | (37.7419043873887, -122.460558108972) | |||
| 188904 | 188904 | 211725 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 41 Ralston St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992180.34622 | 2088219.99909 | 37.7134053906231 | -122.468907645067 | (37.7134053906231, -122.468907645067) | ||||
| 188488 | 188488 | 240422 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002442.71855 | 2096389.33655 | 37.7364241292793 | -122.43402093743201 | (37.7364241292793, -122.434020937432) | |||
| 188401 | 188401 | 207079 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 59 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 5992173.18035 | 2088300.4585900002 | 37.7136258989769 | -122.46893826428699 | (37.7136258989769, -122.468938264287) | ||||
| 188129 | 188129 | 207114 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 53 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 5992175.21623 | 2088282.1627599997 | 37.7135757806697 | -122.468929896991 | (37.7135757806697, -122.468929896991) | ||||
| 188029 | 188029 | 249872 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Greenwich St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011683.12279 | 2120489.80597 | 37.8031186185004 | -122.403768099014 | (37.8031186185004, -122.403768099014) | |||
| 187735 | 187735 | 239190 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 Northbound | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 6005977.0875 | 2108970.19311 | 37.7711682017725 | -122.422694894458 | (37.7711682017725, -122.422694894458) | ||||
| 187617 | 187617 | 249716 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2975 Broadway | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 5999444.23089 | 2116975.8695799997 | 37.7927789735145 | -122.44586807365 | (37.7927789735145, -122.44586807365) | ||||
| 187310 | 187310 | 227505 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 11 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002170.3179 | 2096422.89629 | 37.7365008135581 | -122.434965139225 | (37.7365008135581, -122.434965139225) | |||
| 186880 | 186880 | 206444 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 75 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 5992169.96835 | 2088350.8654599998 | 37.71376411849379 | -122.46895303206301 | (37.7137641184938, -122.468953032063) | ||||
| 186211 | 186211 | 197763 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1405 Minnesota St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6015410.29997 | 2101920.42662 | 37.7523387624307 | -122.389572339186 | (37.7523387624307, -122.389572339186) | ||||
| 186175 | 186175 | 239207 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 18 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6005923.40296 | 2108870.98166 | 37.7708927619194 | -122.422873539387 | (37.7708927619194, -122.422873539387) | ||||
| 185525 | 185525 | 249893 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 29 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | Width 0ft | 6011394.800530001 | 2120441.53452 | 37.8029699659579 | -122.404762450627 | (37.8029699659579, -122.404762450627) | |||
| 184872 | 184872 | 245779 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Addison St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 8ft | 6003578.068469999 | 2096849.2280400002 | 37.73775125431 | -122.430128354157 | (37.73775125431, -122.430128354157) | |||
| 184764 | 184764 | 126562 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 8 Codman Pl | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | 6009829.32931 | 2117256.5326099996 | 37.7941371098806 | -122.40995484385901 | (37.7941371098806, -122.409954843859) | ||||
| 184761 | 184761 | 231940 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 31 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002651.97591 | 2096151.4784799998 | 37.735782899162395 | -122.433280456348 | (37.7357828991624, -122.433280456348) | |||
| 184062 | 184062 | 204381 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 47 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992175.93878 | 2088248.61457 | 37.7134837071825 | -122.46892495972901 | (37.7134837071825, -122.468924959729) | ||||
| 183987 | 183987 | 245781 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Addison St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 8ft | 6003587.5616 | 2096850.22083 | 37.7377545179491 | -122.43009560263799 | (37.7377545179491, -122.430095602638) | |||
| 183893 | 183893 | 240363 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 19 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002113.49716 | 2096265.44164 | 37.7360652530044 | -122.435150333941 | (37.7360652530044, -122.435150333941) | |||
| 183681 | 183681 | 250308 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 10 Redfield Aly | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6008483.77451 | 2119506.40025 | 37.8002391853351 | -122.41476992380801 | (37.8002391853351, -122.414769923808) | |||
| 183663 | 183663 | 239206 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 19 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6005929.117819999 | 2108865.00797 | 37.7708766820544 | -122.42285334689899 | (37.7708766820544, -122.422853346899) | ||||
| 183262 | 183262 | 191810 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 6011130.07486 | 2106859.15267 | 37.7656611456652 | -122.40472178059099 | (37.7656611456652, -122.404721780591) | ||||
| 183112 | 183112 | 233517 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 100 Hwy 101 Southbound | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 6005882.82166 | 2108930.28485 | 37.771053304398606 | -122.42301812700501 | (37.7710533043986, -122.423018127005) | ||||
| 182994 | 182994 | 191809 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 19 | 6011127.66334 | 2106895.1514 | 37.76575985524929 | -122.404732656101 | (37.7657598552493, -122.404732656101) | ||||
| 182862 | 182862 | 209187 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 156 Kensington Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 3ft | 5994832.7400400005 | 2098518.64338 | 37.7418358608449 | -122.460485895213 | (37.7418358608449, -122.460485895213) | |||
| 181159 | 181159 | 224265 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 58 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 38 | 6002671.84671 | 2096513.9082400003 | 37.7367791753169 | -122.433237644116 | (37.7367791753169, -122.433237644116) | ||||
| 180980 | 180980 | 249806 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | Width 0ft | 6010784.31321 | 2121039.01987 | 37.804576372755605 | -122.406917200191 | (37.8045763727556, -122.406917200191) | |||
| 180957 | 180957 | 191842 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 6015112.514169999 | 2099226.0983 | 37.744924185813396 | -122.390413900506 | (37.7449241858134, -122.390413900506) | ||||
| 180826 | 180826 | 239202 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 24 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6005953.73874 | 2108834.81297 | 37.7707951629947 | -122.422766036225 | (37.7707951629947, -122.422766036225) | ||||
| 180684 | 180684 | 226835 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 27 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002073.33297 | 2096755.10087 | 37.7374074632877 | -122.43532421245199 | (37.7374074632877, -122.435324212452) | |||
| 180672 | 180672 | 211726 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 41 Ralston St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 5992180.41529 | 2088216.9630599997 | 37.7133970584078 | -122.46890718553699 | (37.7133970584078, -122.468907185537) | ||||
| 179961 | 179961 | 204383 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 41 Ralston St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 5992172.93339 | 2088222.9751099998 | 37.7134131337717 | -122.46893348261699 | (37.7134131337717, -122.468933482617) | ||||
| 179841 | 179841 | 249924 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 0ft | 6011171.36702 | 2120411.09017 | 37.802873882370896 | -122.405533505089 | (37.8028738823709, -122.405533505089) | |||
| 179625 | 179625 | 233518 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 100 Hwy 101 Southbound | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 6005873.996719999 | 2108944.2877 | 37.7710912548825 | -122.42304964824301 | (37.7710912548825, -122.423049648243) | ||||
| 179584 | 179584 | 195959 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6015616.60441 | 2100338.74984 | 37.7480072461368 | -122.388748492749 | (37.7480072461368, -122.388748492749) | ||||
| 179054 | 179054 | 249777 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 119 Pfeiffer St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 0ft | 6010400.427069999 | 2121136.58311 | 37.8048227690275 | -122.40825256571001 | (37.8048227690275, -122.40825256571) | |||
| 178882 | 178882 | 245780 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Addison St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 8ft | 6003583.611880001 | 2096848.84807 | 37.7377505249636 | -122.430109160821 | (37.7377505249636, -122.430109160821) | |||
| 177983 | 177983 | 245778 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Addison St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 8ft | 6003567.005919999 | 2096851.6434799999 | 37.7377572599929 | -122.43016677498899 | (37.7377572599929, -122.430166774989) | |||
| 177754 | 177754 | 209147 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 75 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | 5992171.618 | 2088327.33496 | 37.7136996047335 | -122.46894561897 | (37.7136996047335, -122.46894561897) | ||||
| 177691 | 177691 | 209186 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 3ft | 5994849.5459 | 2098494.81966 | 37.741771413634794 | -122.46042606063 | (37.7417714136348, -122.46042606063) | |||
| 177217 | 177217 | 245789 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 13 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | Width 2ft | 6002510.68516 | 2096313.6496700002 | 37.736220167514404 | -122.433780540537 | (37.7362201675144, -122.433780540537) | |||
| 176884 | 176884 | 218149 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Ashton Ave | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 5994121.0220800005 | 2090034.4141 | 37.7184992747921 | -122.462331555861 | (37.7184992747921, -122.462331555861) | ||||
| 176501 | 176501 | 245784 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Addison St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 4ft | 6003626.79774 | 2096849.74169 | 37.7377554244689 | -122.429959910226 | (37.7377554244689, -122.429959910226) | |||
| 176394 | 176394 | 249925 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6011155.36985 | 2120409.86411 | 37.802869621408796 | -122.40558877741002 | (37.8028696214088, -122.40558877741) | |||
| 176393 | 176393 | 249926 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011142.49576 | 2120408.96257 | 37.8028664261111 | -122.405633265077 | (37.8028664261111, -122.405633265077) | |||
| 175716 | 175716 | 211722 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 47 Ralston St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5992176.846480001 | 2088244.58976 | 37.7134727084689 | -122.468921529709 | (37.7134727084689, -122.468921529709) | ||||
| 175233 | 175233 | 195961 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6015577.60391 | 2100335.50195 | 37.7479961664858 | -122.388883129368 | (37.7479961664858, -122.388883129368) | ||||
| 174819 | 174819 | 209181 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 3ft | 5994876.85162 | 2098459.48593 | 37.7416759667651 | -122.46032908762699 | (37.7416759667651, -122.460329087627) | |||
| 174735 | 174735 | 236183 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 2ft | 6002335.35488 | 2096511.4177599999 | 37.7367532424671 | -122.434400864109 | (37.7367532424671, -122.434400864109) | |||
| 174700 | 174700 | 118571 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7940 Geary Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 5982344.86422 | 2112440.78156 | 37.779335773230294 | -122.50469546097601 | (37.7793357732303, -122.504695460976) | ||||
| 174189 | 174189 | 242821 | Undocumented 2 | Tree(s) :: 17 | 18 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 37 | Width 5ft | 6002176.86514 | 2096431.6975599998 | 37.7365253515621 | -122.43494313191499 | (37.7365253515621, -122.434943131915) | |||
| 173877 | 173877 | 195973 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 19 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 4ft | 6015335.01264 | 2100318.2949099997 | 37.747935470342895 | -122.38972080559601 | (37.7479354703429, -122.389720805596) | |||
| 173534 | 173534 | 249884 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 230 Greenwich St | 20 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6011503.3679 | 2120436.4879799997 | 37.8029621769312 | -122.404386393712 | (37.8029621769312, -122.404386393712) | |||
| 172941 | 172941 | 191812 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 6011136.684719999 | 2106709.3643099996 | 37.765250230128004 | -122.404688372578 | (37.765250230128, -122.404688372578) | ||||
| 172795 | 172795 | 191843 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 6015141.47385 | 2099207.7707599998 | 37.7448754686187 | -122.390312482158 | (37.7448754686187, -122.390312482158) | ||||
| 172487 | 172487 | 219172 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 47 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 5992175.93719 | 2088256.51499 | 37.7135053997375 | -122.46892553980601 | (37.7135053997375, -122.468925539806) | ||||
| 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) | ||||
| 171805 | 171805 | 195974 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 20 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 4ft | 6015315.44713 | 2100317.81293 | 37.7479330619596 | -122.389788429193 | (37.7479330619596, -122.389788429193) | |||
| 171720 | 171720 | 207111 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | 5992171.5605 | 2088305.6585 | 37.713640083085 | -122.468944241206 | (37.713640083085, -122.468944241206) | ||||
| 171592 | 171592 | 223338 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 17 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002542.32415 | 2096276.52832 | 37.736120036118706 | -122.433668499417 | (37.7361200361187, -122.433668499417) | |||
| 171499 | 171499 | 249885 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 230 Greenwich St | 21 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011498.61175 | 2120434.8744 | 37.8029574806516 | -122.404402738904 | (37.8029574806516, -122.404402738904) | |||
| 171288 | 171288 | 195971 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 17 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 4ft | 6015377.86647 | 2100320.4119700002 | 37.7479436595871 | -122.389572765484 | (37.7479436595871, -122.389572765484) | |||
| 171246 | 171246 | 249875 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 19 | Width 0ft | 6011656.00691 | 2120465.5569700003 | 37.803050521838706 | -122.40386022737499 | (37.8030505218387, -122.403860227375) | |||
| 171235 | 171235 | 249889 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 230 Greenwich St | 25 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 0ft | 6011472.47528 | 2120454.19881 | 37.8030090801563 | -122.404494546207 | (37.8030090801563, -122.404494546207) | |||
| 170870 | 170870 | 249922 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011172.25119 | 2120397.10621 | 37.802835535282604 | -122.405529459923 | (37.8028355352826, -122.405529459923) | |||
| 170487 | 170487 | 239210 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 13 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6005891.00584 | 2108925.69957 | 37.771041176138795 | -122.422989491673 | (37.7710411761388, -122.422989491673) | ||||
| 170319 | 170319 | 211723 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 47 Ralston St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 5992174.6999 | 2088241.1909400001 | 37.7134632521081 | -122.468928701793 | (37.7134632521081, -122.468928701793) | ||||
| 169417 | 169417 | 249809 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6010708.4562800005 | 2121025.2354099997 | 37.804534279087704 | -122.407178739215 | (37.8045342790877, -122.407178739215) | |||
| 169264 | 169264 | 223845 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000588.980819999 | 2104313.3574 | 37.7580762176596 | -122.440998371578 | (37.7580762176596, -122.440998371578) | |||
| 168811 | 168811 | 239193 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 Northbound | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 6005953.87409 | 2109001.5556400004 | 37.771253006051296 | -122.42277741983801 | (37.7712530060513, -122.422777419838) | ||||
| 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) | ||||
| 168653 | 168653 | 132412 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 8 Codman Pl | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | Width 10ft | 6009828.26061 | 2117303.30498 | 37.7942654755313 | -122.40996184507601 | (37.7942654755313, -122.409961845076) | |||
| 167246 | 167246 | 206445 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 53 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 5992171.9093 | 2088272.93373 | 37.7135502489179 | -122.46894065561001 | (37.7135502489179, -122.46894065561) | ||||
| 166869 | 166869 | 239197 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 Northbound | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 6005924.85036 | 2109052.04357 | 37.7713899961886 | -122.42288140308001 | (37.7713899961886, -122.42288140308) | ||||
| 166702 | 166702 | 223846 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000593.0444 | 2104306.7365599996 | 37.7580582698975 | -122.440983843043 | (37.7580582698975, -122.440983843043) | |||
| 166281 | 166281 | 220095 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 5 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 2ft | 6002427.25103 | 2096406.93673 | 37.7364715774983 | -122.43407567285601 | (37.7364715774983, -122.434075672856) | |||
| 165645 | 165645 | 227016 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 29 Poppy Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002117.32476 | 2096797.30121 | 37.7375258338607 | -122.43517513003201 | (37.7375258338607, -122.435175130032) | |||
| 164865 | 164865 | 239558 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 26 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 2ft | 6002169.792830001 | 2096347.5297 | 37.7362938444778 | -122.434961566227 | (37.7362938444778, -122.434961566227) | |||
| 164753 | 164753 | 207116 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 47 Ralston St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5992178.8337 | 2088240.4151599999 | 37.7134613608383 | -122.46891435762801 | (37.7134613608383, -122.468914357628) | ||||
| 164588 | 164588 | 132414 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 8 Codman Pl | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 10ft | 6009830.1634599995 | 2117290.7141400003 | 37.794231010794704 | -122.409954371722 | (37.7942310107947, -122.409954371722) | |||
| 164095 | 164095 | 249920 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 358 Greenwich St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | Width 0ft | 6011181.16541 | 2120413.994 | 37.8028824034529 | -122.405499802075 | (37.8028824034529, -122.405499802075) | |||
| 163838 | 163838 | 239218 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 10ft | 6005833.18575 | 2109028.0269 | 37.771318879598105 | -122.423196768328 | (37.7713188795981, -122.423196768328) | |||
| 163778 | 163778 | 223997 | Undocumented 2 | Eucalyptus rudis :: Swamp Gum: Flooded Gum 287 | 100 Hwy 101 Southbound | 16 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 6005905.0919699995 | 2108895.1603 | 37.770958117464396 | -122.42293859636601 | (37.7709581174644, -122.422938596366) | ||||
| 163775 | 163775 | 233337 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 251 Coso Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6007732.48322 | 2099500.473 | 37.7452654065818 | -122.415952190562 | (37.7452654065818, -122.415952190562) | ||||
| 163352 | 163352 | 223998 | Undocumented 2 | Eucalyptus rudis :: Swamp Gum: Flooded Gum 287 | 100 Hwy 101 Southbound | 15 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 6005894.41752 | 2108909.3321599998 | 37.770996427668 | -122.422976527055 | (37.770996427668, -122.422976527055) | ||||
| 163239 | 163239 | 220552 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 13 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6002169.64489 | 2096371.31931 | 37.736359156858704 | -122.434963778568 | (37.7363591568587, -122.434963778568) | |||
| 162970 | 162970 | 246778 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 392 Franconia St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 6009934.469769999 | 2098852.71045 | 37.7436103455484 | -122.408292376913 | (37.7436103455484, -122.408292376913) | ||||
| 162496 | 162496 | 207110 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 5992170.63195 | 2088310.84387 | 37.7136542672107 | -122.468947827707 | (37.7136542672107, -122.468947827707) | ||||
| 162015 | 162015 | 245786 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Addison St | 13 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 3ft | 6003641.8158599995 | 2096850.294 | 37.73775779149221 | -122.429908024732 | (37.7377577914922, -122.429908024732) | |||
| 161920 | 161920 | 218151 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Ashton Ave | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 19 | 5994130.74614 | 2090030.24083 | 37.7184883759248 | -122.46229764153799 | (37.7184883759248, -122.462297641538) | ||||
| 161916 | 161916 | 132415 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 8 Codman Pl | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 10ft | 6009831.3064 | 2117286.6196 | 37.7942198322406 | -122.409950127822 | (37.7942198322406, -122.409950127822) | |||
| 161892 | 161892 | 203876 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 41 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 25 | 5992169.18145 | 2088225.46502 | 37.7134197536892 | -122.468946631609 | (37.7134197536892, -122.468946631609) | ||||
| 161192 | 161192 | 233957 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 15 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002524.54294 | 2096295.7854099998 | 37.7361719027113 | -122.43373135214199 | (37.7361719027113, -122.433731352142) | |||
| 160996 | 160996 | 223847 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000596.08551 | 2104301.4441 | 37.758043911304895 | -122.44097294593901 | (37.7580439113049, -122.440972945939) | |||
| 160995 | 160995 | 245783 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Addison St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | Width 8ft | 6003607.92987 | 2096849.5108400001 | 37.73775372205 | -122.430025129081 | (37.73775372205, -122.430025129081) | |||
| 160942 | 160942 | 249712 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | 5999372.04623 | 2116967.23886 | 37.792751153907204 | -122.44611721373998 | (37.7927511539072, -122.44611721374) | ||||
| 160902 | 160902 | 239191 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 Northbound | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 6005967.76325 | 2108980.83852 | 37.7711969054453 | -122.422727904078 | (37.7711969054453, -122.422727904078) | ||||
| 160585 | 160585 | 249998 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 39 Darrell Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011504.54206 | 2120237.90093 | 37.8024169710215 | -122.40436834431699 | (37.8024169710215, -122.404368344317) | |||
| 160452 | 160452 | 228906 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 902 Duboce Ave | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | 6002292.02781 | 2108250.42967 | 37.768983311465 | -122.435390141758 | (37.768983311465, -122.435390141758) | ||||
| 160401 | 160401 | 227015 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 29 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 1 | Width 2ft | 6002114.09151 | 2096793.82616 | 37.7375161085743 | -122.43518606040399 | (37.7375161085743, -122.435186060404) |
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");