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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
176991 | 176991 | 194762 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 900 Quint St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 3ft | 6014169.91323 | 2097651.03706 | 37.7405470630994 | -122.393563052915 | (37.7405470630994, -122.393563052915) | |||
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) | ||||
176813 | 176813 | 208888 | Undocumented 2 | Malus :: Crab Apple 235 | 747 Detroit St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 5999417.485309999 | 2095405.5962 | 37.73355085827271 | -122.44440972944099 | (37.7335508582727, -122.444409729441) | ||||
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) | |||
176347 | 176347 | 125277 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1285 Greenwich St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6006721.71386 | 2119753.35883 | 37.800818109519206 | -122.420884898228 | (37.8008181095192, -122.420884898228) | ||||
176217 | 176217 | 247847 | Undocumented 2 | Acacia decurrens :: Acacia: Silver Wattle 181 | 149 Chapman St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | 6009164.829969999 | 2098210.04366 | 37.7418025958088 | -122.410908232241 | (37.7418025958088, -122.410908232241) | ||||
176194 | 176194 | 187582 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 747 University St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6008739.08909 | 2090759.6184900003 | 37.7213214463175 | -122.41185395930799 | (37.7213214463175, -122.411853959308) | ||||
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) | ||||
176180 | 176180 | 195080 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Indiana St | 22 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 4ft | 6014988.8599 | 2103201.99322 | 37.755834295018204 | -122.39111932871201 | (37.7558342950182, -122.391119328712) | |||
176020 | 176020 | 178272 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 35 Tomaso Ct | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | Width 3ft | 6009218.69223 | 2086367.8804 | 37.709289534449894 | -122.409886240875 | (37.7092895344499, -122.409886240875) | |||
175990 | 175990 | 203450 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 8ft | 5991181.21192 | 2105021.0246 | 37.7594789613077 | -122.47358576280001 | (37.7594789613077, -122.4735857628) | |||
175972 | 175972 | 132431 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6008617.41774 | 2118989.2974400003 | 37.7988268576225 | -122.41427085762501 | (37.7988268576225, -122.414270857625) | ||||
175962 | 175962 | 199423 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 1750 22nd St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6012840.75546 | 2103801.40949 | 37.7573607224353 | -122.398590280219 | (37.7573607224353, -122.398590280219) | ||||
175371 | 175371 | 187836 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1350 Rankin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 2ft | 6012791.1903 | 2096920.73953 | 37.7384651145639 | -122.398278948414 | (37.7384651145639, -122.398278948414) | |||
175058 | 175058 | 177833 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 648 Peru Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6005045.58694 | 2092601.1582099998 | 37.726170008036 | -122.42475230858601 | (37.726170008036, -122.424752308586) | ||||
174997 | 174997 | 176989 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 184 Mount Vernon Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 5998947.7718 | 2089388.6360799999 | 37.717002872174504 | -122.445601123393 | (37.7170028721745, -122.445601123393) | ||||
174728 | 174728 | 250155 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2500 Lyon St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5999259.65981 | 2117410.03204 | 37.7939605280209 | -122.44653794537099 | (37.7939605280209, -122.446537945371) | ||||
174607 | 174607 | 237938 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 272 Corbett Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 5999643.14509 | 2105335.6231299997 | 37.7608291899369 | -122.44434292871 | (37.7608291899369, -122.44434292871) | |||
174300 | 174300 | 248219 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Fair Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 38 | 6007128.325540001 | 2099340.74379 | 37.744792840734206 | -122.418029950029 | (37.7447928407342, -122.418029950029) | ||||
174270 | 174270 | 247907 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 582 Esmeralda Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009851.66024 | 2098739.23116 | 37.7432941187313 | -122.40857070986401 | (37.7432941187313, -122.408570709864) | ||||
174262 | 174262 | 205433 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 231 Edna St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 5998775.87477 | 2095301.89625 | 37.733229493638 | -122.44662049415001 | (37.733229493638, -122.44662049415) | ||||
173872 | 173872 | 211287 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 1549 15th Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5991543.24459 | 2104910.37541 | 37.759196107445796 | -122.472325621056 | (37.7591961074458, -122.472325621056) | ||||
173692 | 173692 | 237872 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Corbin Pl | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6000053.4214699995 | 2105717.34957 | 37.7619007159651 | -122.44295138252 | (37.7619007159651, -122.44295138252) | |||
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) | ||||
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) | ||||
173508 | 173508 | 247008 | Undocumented 2 | Callistemon 'Jeffers' :: Purple bottlebrush 395 | 401 Valley St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 8ft | 6003270.60035 | 2099185.34055 | 37.74414826155 | -122.43135813298599 | (37.74414826155, -122.431358132986) | |||
173443 | 173443 | 132298 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2836 Larkin St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | 6006506.15813 | 2120992.00348 | 37.8042069600397 | -122.42171884046199 | (37.8042069600397, -122.421718840462) | ||||
173419 | 173419 | 203452 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 5991186.2272 | 2105007.12865 | 37.7594410971589 | -122.473567404026 | (37.7594410971589, -122.473567404026) | |||
173385 | 173385 | 175810 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 La Grande Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6005231.38021 | 2091782.6619 | 37.7239330883183 | -122.424051850035 | (37.7239330883183, -122.424051850035) | ||||
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) | ||||
173273 | 173273 | 249898 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1497 Montgomery St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011364.51666 | 2120462.68134 | 37.8030263372523 | -122.404868738822 | (37.8030263372523, -122.404868738822) | |||
173238 | 173238 | 197182 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1750 22nd St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6012809.5472800005 | 2103799.82503 | 37.757354633129204 | -122.39869809995501 | (37.7573546331292, -122.398698099955) | ||||
173063 | 173063 | 227018 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 31 Poppy Ln | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 3ft | 6002156.08146 | 2096805.0262900002 | 37.7375492458966 | -122.435041682346 | (37.7375492458966, -122.435041682346) | |||
172984 | 172984 | 134507 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | Width 4ft | 6008088.37088 | 2112123.28694 | 37.779944739586 | -122.415615147138 | (37.779944739586, -122.415615147138) | |||
172858 | 172858 | 187572 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 73 Bishop St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010864.17104 | 2089487.4487 | 37.7179473203875 | -122.404418609237 | (37.7179473203875, -122.404418609237) | ||||
172826 | 172826 | 246658 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009066.3858 | 2099225.83435 | 37.7445862133943 | -122.411320363668 | (37.7445862133943, -122.411320363668) | ||||
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) | |||
172692 | 172692 | 248065 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 18 Rutledge St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010648.08166 | 2099392.5913299997 | 37.7451326756473 | -122.405862891685 | (37.7451326756473, -122.405862891685) | ||||
172565 | 172565 | 227019 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 31 Poppy Ln | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 3ft | 6002163.83641 | 2096804.20988 | 37.737547444561 | -122.435014811479 | (37.737547444561, -122.435014811479) | |||
172416 | 172416 | 193454 | Undocumented 2 | Malus :: Crab Apple 235 | 1751 22nd St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 4ft | 6012836.35508 | 2103764.61447 | 37.75725944619679 | -122.39860291658701 | (37.7572594461968, -122.398602916587) | |||
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) | ||||
172278 | 172278 | 241053 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 201 Coso Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 5ft | 6007672.87316 | 2099533.1354400003 | 37.7453517387841 | -122.416160625529 | (37.7453517387841, -122.416160625529) | |||
172111 | 172111 | 250226 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 0ft | 6011217.042090001 | 2120062.49723 | 37.8019192853099 | -122.405350881537 | (37.8019192853099, -122.405350881537) | |||
172088 | 172088 | 125288 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 943 Green St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6008674.79926 | 2118995.08989 | 37.7988459853112 | -122.41407270821101 | (37.7988459853112, -122.414072708211) | ||||
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) | |||
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) | |||
171284 | 171284 | 249897 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1497 Montgomery St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011384.61876 | 2120458.08201 | 37.8030148322229 | -122.40479885070101 | (37.8030148322229, -122.404798850701) | |||
171180 | 171180 | 211324 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1500 16th Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5991176.95636 | 2105105.05253 | 37.7597094332699 | -122.473606609976 | (37.7597094332699, -122.473606609976) | ||||
170667 | 170667 | 247953 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 7 Joy St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6010438.9217 | 2098856.89307 | 37.7436500649912 | -122.40654839179899 | (37.7436500649912, -122.406548391799) | ||||
170593 | 170593 | 247004 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 401 Valley St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 8ft | 6003237.98739 | 2099191.84637 | 37.7441642766696 | -122.43147136571501 | (37.7441642766696, -122.431471365715) | |||
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) | ||||
170400 | 170400 | 247845 | Undocumented 2 | Acacia decurrens :: Acacia: Silver Wattle 181 | 151 Chapman St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6009128.636519999 | 2098211.49028 | 37.7418045383421 | -122.41103347993 | (37.7418045383421, -122.41103347993) | ||||
170275 | 170275 | 196369 | Undocumented 2 | Prunus persica :: Peach 330 | 1499 Rankin St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | Width 3ft | 6012673.95486 | 2096676.86192 | 37.7377889466986 | -122.39866718483499 | (37.7377889466986, -122.398667184835) | |||
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) | ||||
169728 | 169728 | 249848 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 289 Greenwich St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6011433.333 | 2120390.12785 | 37.8028309694274 | -122.404625486584 | (37.8028309694274, -122.404625486584) | |||
169682 | 169682 | 179659 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 287 Hester Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6012208.68796 | 2087783.6774 | 37.7133441503725 | -122.39965161424801 | (37.7133441503725, -122.399651614248) | ||||
169612 | 169612 | 247876 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 388 Mayflower St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6009908.43883 | 2098395.0561 | 37.742352268652 | -122.40835011248001 | (37.742352268652, -122.40835011248) | ||||
169605 | 169605 | 193341 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1751 22nd St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 4ft | 6012847.48484 | 2103764.38864 | 37.757259446178104 | -122.398564409431 | (37.7572594461781, -122.398564409431) | |||
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) | ||||
169544 | 169544 | 247921 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 38 | 6010260.8237 | 2098716.17835 | 37.7432537274883 | -122.407154297447 | (37.7432537274883, -122.407154297447) | ||||
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) | ||||
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) | |||
169293 | 169293 | 246769 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 99 Waltham St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6009290.58304 | 2098917.85967 | 37.7437531542765 | -122.410523388038 | (37.7437531542765, -122.410523388038) | ||||
169281 | 169281 | 197459 | Undocumented 2 | Salix discolor :: Pussy Willow 437 | 1999 Revere Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6012989.149119999 | 2095915.1657 | 37.73571504351771 | -122.397523992755 | (37.7357150435177, -122.397523992755) | ||||
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) | |||
168933 | 168933 | 249774 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 102 Pfeiffer St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6010412.38512 | 2121159.3166 | 37.804885859146104 | -122.408212787783 | (37.8048858591461, -122.408212787783) | |||
168635 | 168635 | 177817 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6009184.18934 | 2086265.3806200002 | 37.7090061571804 | -122.409998257729 | (37.7090061571804, -122.409998257729) | |||
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) | ||||
168341 | 168341 | 203438 | Undocumented 2 | Acer spp :: Maple 158 | 714 Detroit St | 13 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5999448.55059 | 2095428.3134400002 | 37.73361500690729 | -122.44430396017401 | (37.7336150069073, -122.444303960174) | ||||
168329 | 168329 | 249839 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 305 Greenwich St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 0ft | 6011296.15098 | 2120380.09271 | 37.802795747494706 | -122.405099502163 | (37.8027957474947, -122.405099502163) | |||
168100 | 168100 | 177841 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 653 Peru Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6005100.14116 | 2092616.6598200002 | 37.726215653124704 | -122.424564819721 | (37.7262156531247, -122.424564819721) | ||||
167940 | 167940 | 240620 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 272 Corbett Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | Width 3ft | 5999634.90147 | 2105345.61253 | 37.7608561480145 | -122.44437215754401 | (37.7608561480145, -122.444372157544) | |||
167911 | 167911 | 247894 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 360 Mayflower St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010044.08418 | 2098374.82588 | 37.742304315888205 | -122.40787966360901 | (37.7423043158882, -122.407879663609) | ||||
167728 | 167728 | 201724 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 28 | 6017165.24184 | 2095383.9343 | 37.7344880327856 | -122.383048514986 | (37.7344880327856, -122.383048514986) | ||||
167249 | 167249 | 190082 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1700 Armstrong Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6013888.29247 | 2092890.0974700002 | 37.7274588480349 | -122.39420355996401 | (37.7274588480349, -122.394203559964) | ||||
167168 | 167168 | 199618 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2399 Lane St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6013981.31336 | 2092866.65416 | 37.7273996474538 | -122.393880343621 | (37.7273996474538, -122.393880343621) | ||||
167037 | 167037 | 221195 | Undocumented 2 | Bambusa spp :: Bamboo Species 346 | 200 Saint Marys Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 7ft | 6003941.6017 | 2095959.6325400001 | 37.7353292100649 | -122.428808043276 | (37.7353292100649, -122.428808043276) | |||
167034 | 167034 | 176166 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 654 Peru Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 30 | 6005147.67241 | 2092530.2100099998 | 37.7259809651314 | -122.424394360408 | (37.7259809651314, -122.424394360408) | ||||
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) | ||||
166855 | 166855 | 129091 | Undocumented 2 | Ilex altaclarensis 'Wilsonii' :: Wilson Holly Tree 310 | 200 Spruce St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 4ft | 5997131.25122 | 2115563.65608 | 37.78876907367739 | -122.45376901623399 | (37.7887690736774, -122.453769016234) | |||
166825 | 166825 | 248057 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 17 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6010678.5248 | 2099352.93022 | 37.7450254773569 | -122.405754830944 | (37.7450254773569, -122.405754830944) | ||||
166798 | 166798 | 248247 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 296 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006821.11352 | 2098989.33644 | 37.743810659629204 | -122.419067312628 | (37.7438106596292, -122.419067312628) | ||||
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) | ||||
166588 | 166588 | 248068 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 20 Rutledge St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010623.83336 | 2099392.33092 | 37.7451306044855 | -122.40594672016701 | (37.7451306044855, -122.405946720167) | ||||
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) | ||||
166465 | 166465 | 187554 | Undocumented 2 | Schinus molle :: California Pepper 138 | 3960 Somerset St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6011368.52295 | 2088357.8500700002 | 37.71487384321561 | -122.40259588490801 | (37.7148738432156, -122.402595884908) | ||||
166457 | 166457 | 247914 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 399 Franconia St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6010000.52553 | 2098831.51714 | 37.7435558520369 | -122.40806247691499 | (37.7435558520369, -122.408062476915) | ||||
166394 | 166394 | 250229 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011206.629819999 | 2120043.6184099996 | 37.8018668665295 | -122.405385582777 | (37.8018668665295, -122.405385582777) | |||
166321 | 166321 | 250223 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6011234.32087 | 2120070.9566599997 | 37.80194347887979 | -122.405291684587 | (37.8019434788798, -122.405291684587) | |||
166247 | 166247 | 120262 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 100 24th Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 26 | 5988353.58713 | 2115180.43805 | 37.7872097252822 | -122.484109995805 | (37.7872097252822, -122.484109995805) | ||||
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) | ||||
166163 | 166163 | 195224 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 Phelps St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 7ft | 6014570.35716 | 2097088.14635 | 37.7390237239721 | -122.392139105952 | (37.7390237239721, -122.392139105952) | |||
166087 | 166087 | 237935 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 272 Corbett Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 3ft | 5999636.03267 | 2105332.26436 | 37.7608195617885 | -122.444367285948 | (37.7608195617885, -122.444367285948) | |||
165964 | 165964 | 175067 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 Thornton Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 26 | 6010979.40226 | 2094033.66945 | 37.730436741644894 | -122.404340115499 | (37.7304367416449, -122.404340115499) | ||||
165962 | 165962 | 210573 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 300 Melrose Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5998016.4865 | 2095547.09873 | 37.7338593545253 | -122.449263553965 | (37.7338593545253, -122.449263553965) | ||||
165904 | 165904 | 205419 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 714 Detroit St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5999453.91846 | 2095387.09878 | 37.733502147395896 | -122.444282441206 | (37.7335021473959, -122.444282441206) | ||||
165892 | 165892 | 247905 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 582 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009839.52244 | 2098719.28889 | 37.7432386818184 | -122.40861127291099 | (37.7432386818184, -122.408611272911) | ||||
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) | |||
165572 | 165572 | 250224 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6011221.34302 | 2120070.92711 | 37.8019426721638 | -122.405336592216 | (37.8019426721638, -122.405336592216) | |||
165286 | 165286 | 247908 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 582 Esmeralda Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6009856.31482 | 2098721.18962 | 37.7432448412741 | -122.408553343056 | (37.7432448412741, -122.408553343056) |
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");