Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3271 | 3271 | 253381 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 5161 | 5161 | 253809 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 10000 | 10000 | 173780 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 99X Cleveland St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x6 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 24649 | 24649 | 194268 | Undocumented 2 | Persea americana :: Avocado 113 | 900 Quint St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 3ft | 6014100.1568599995 | 2097559.70841 | 37.7402924173605 | -122.393797854205 | (37.7402924173605, -122.393797854205) | |||
| 24680 | 24680 | 187543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1400 Somerset St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6011384.82868 | 2088240.1087599997 | 37.714551459646394 | -122.402531250636 | (37.7145514596464, -122.402531250636) | ||||
| 25273 | 25273 | 237871 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Corbin Pl | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6000061.7105 | 2105723.34521 | 37.761917651093704 | -122.44292314469 | (37.7619176510937, -122.44292314469) | |||
| 25968 | 25968 | 249846 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 289 Greenwich St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 0ft | 6011427.16735 | 2120382.55668 | 37.8028098362532 | -122.40464628970601 | (37.8028098362532, -122.404646289706) | |||
| 27269 | 27269 | 250005 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 232 Filbert St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 0ft | 6011493.8796 | 2120090.77159 | 37.802012393927 | -122.404394879735 | (37.802012393927, -122.404394879735) | |||
| 28161 | 28161 | 249840 | Undocumented 2 | Magnolia x soulangiana :: Saucer Magnolia 92 | 305 Greenwich St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6011283.33525 | 2120383.34662 | 37.8028039654926 | -122.405144080631 | (37.8028039654926, -122.405144080631) | |||
| 28950 | 28950 | 132461 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1109 Chestnut St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006461.025 | 2120401.5247299997 | 37.8025831108771 | -122.42183305885901 | (37.8025831108771, -122.421833058859) | ||||
| 29301 | 29301 | 250202 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 203 Union St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 0ft | 6011755.5651 | 2119757.15751 | 37.8011109908426 | -122.403465834184 | (37.8011109908426, -122.403465834184) | |||
| 30768 | 30768 | 223720 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Crescent Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6005295.72226 | 2095902.89747 | 37.7352499770995 | -122.424122309196 | (37.7352499770995, -122.424122309196) | |||
| 31541 | 31541 | 247930 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6010384.98383 | 2098777.78466 | 37.7434298327179 | -122.406729322818 | (37.7434298327179, -122.406729322818) | ||||
| 32280 | 32280 | 129119 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1114 Greenwich St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007553.05086 | 2119913.7987599997 | 37.8013054611424 | -122.418019497203 | (37.8013054611424, -122.418019497203) | ||||
| 34176 | 34176 | 120265 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 100 24th Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 5988361.4812900005 | 2115164.4742099997 | 37.7871663527314 | -122.484081512932 | (37.7871663527314, -122.484081512932) | ||||
| 35692 | 35692 | 209045 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 300 Melrose Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 88 | 5998032.3562900005 | 2095523.6559099997 | 37.733795893852296 | -122.44920699922599 | (37.7337958938523, -122.449206999226) | ||||
| 37058 | 37058 | 204587 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 231 Edna St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 5998761.6398599995 | 2095307.9959099998 | 37.733245428730996 | -122.446670146634 | (37.733245428731, -122.446670146634) | ||||
| 37237 | 37237 | 247874 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 388 Mayflower St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009897.47446 | 2098392.17671 | 37.7423437484768 | -122.408387821062 | (37.7423437484768, -122.408387821062) | ||||
| 37458 | 37458 | 246770 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 99 Waltham St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009309.01668 | 2098932.20278 | 37.7437935707282 | -122.410460661231 | (37.7437935707282, -122.410460661231) | ||||
| 38549 | 38549 | 247912 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 399 Franconia St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6009971.111830001 | 2098794.45901 | 37.7434524515605 | -122.408161569622 | (37.7434524515605, -122.408161569622) | ||||
| 39303 | 39303 | 118611 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 349 Point Lobos Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5981718.6857199995 | 2112644.15815 | 37.7798573303546 | -122.506876725888 | (37.7798573303546, -122.506876725888) | ||||
| 41232 | 41232 | 194561 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 999 Kansas St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6011649.57806 | 2103809.7609599996 | 37.7573172186375 | -122.40271045314199 | (37.7573172186375, -122.402710453142) | ||||
| 41287 | 41287 | 205601 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 404 Baden St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6000770.98031 | 2095275.60302 | 37.7332710603101 | -122.43972100331699 | (37.7332710603101, -122.439721003317) | ||||
| 44680 | 44680 | 247950 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 7 Joy St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6010415.94161 | 2098863.8955 | 37.7436680064781 | -122.406628345115 | (37.7436680064781, -122.406628345115) | ||||
| 44694 | 44694 | 132423 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Vallejo St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6008817.55248 | 2118666.35728 | 37.7979513838133 | -122.41355547121401 | (37.7979513838133, -122.413555471214) | ||||
| 45007 | 45007 | 248046 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 38 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6010555.404680001 | 2099417.48898 | 37.745195855721995 | -122.406185107956 | (37.745195855722, -122.406185107956) | ||||
| 46734 | 46734 | 214372 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1500 16th Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5991179.13729 | 2105098.7165599996 | 37.759692162681 | -122.473598605112 | (37.759692162681, -122.473598605112) | ||||
| 47085 | 47085 | 218783 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998795.47023 | 2095343.3571900001 | 37.7333444548841 | -122.44655572948099 | (37.7333444548841, -122.446555729481) | ||||
| 48633 | 48633 | 247854 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 80 Bradford St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6009576.04366 | 2098148.42798 | 37.74165646228621 | -122.409482036964 | (37.7416564622862, -122.409482036964) | ||||
| 49102 | 49102 | 248109 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 138 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010416.26244 | 2099462.28287 | 37.7453110660681 | -122.406669396477 | (37.7453110660681, -122.406669396477) | ||||
| 49284 | 49284 | 196125 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2300 20th St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 4ft | 6011177.05787 | 2104649.1602 | 37.7595956285643 | -122.40440370476101 | (37.7595956285643, -122.404403704761) | |||
| 49965 | 49965 | 114038 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2x Moffitt St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6002767.774130001 | 2096661.3136900002 | 37.737189358209704 | -122.43291650912201 | (37.7371893582097, -122.432916509122) | ||||
| 51094 | 51094 | 201728 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1411 Phelps St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6013736.51011 | 2095944.0047900002 | 37.7358358152635 | -122.394942076023 | (37.7358358152635, -122.394942076023) | ||||
| 52032 | 52032 | 248226 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 71 Fair Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6007119.30754 | 2099366.9898200002 | 37.7448643988822 | -122.418062992935 | (37.7448643988822, -122.418062992935) | ||||
| 53056 | 53056 | 248184 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 216 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 28 | 6007432.5204300005 | 2098714.89498 | 37.7430915158666 | -122.416933765486 | (37.7430915158666, -122.416933765486) | ||||
| 53365 | 53365 | 248061 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 18 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6010675.96291 | 2099385.23379 | 37.74511403267871 | -122.40576596453 | (37.7451140326787, -122.40576596453) | ||||
| 54571 | 54571 | 211276 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 232 Edna St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 49 | 5998791.497719999 | 2095472.56851 | 37.7336990117025 | -122.446578756609 | (37.7336990117025, -122.446578756609) | ||||
| 56892 | 56892 | 248221 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 70 Fair Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6007127.43713 | 2099336.46972 | 37.744781055094705 | -122.418032719051 | (37.7447810550947, -122.418032719051) | ||||
| 57817 | 57817 | 132397 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6006502.73263 | 2120950.76111 | 37.804093525861795 | -122.42172776352899 | (37.8040935258618, -122.421727763529) | ||||
| 58146 | 58146 | 201718 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6017093.28201 | 2095356.3247099998 | 37.7344082458391 | -122.38329538517401 | (37.7344082458391, -122.383295385174) | ||||
| 58384 | 58384 | 236089 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 198 Corbin Pl | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 3ft | 6000079.09557 | 2105681.45742 | 37.761803628741795 | -122.442860008701 | (37.7618036287418, -122.442860008701) | |||
| 59219 | 59219 | 247999 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 346 Peralta Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6009771.618319999 | 2099231.70155 | 37.744641851750295 | -122.40888221345101 | (37.7446418517503, -122.408882213451) | ||||
| 59668 | 59668 | 246653 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009062.80504 | 2099192.42716 | 37.7444942837766 | -122.411330385709 | (37.7444942837766, -122.411330385709) | ||||
| 60552 | 60552 | 250197 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 0ft | 6011839.72623 | 2119769.92251 | 37.8011507408769 | -122.403175497057 | (37.8011507408769, -122.403175497057) | |||
| 62478 | 62478 | 247003 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 401 Valley St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 8ft | 6003236.004319999 | 2099186.05464 | 37.744148261529006 | -122.431477809352 | (37.744148261529, -122.431477809352) | |||
| 63830 | 63830 | 197460 | Undocumented 2 | Salix discolor :: Pussy Willow 437 | 1999 Revere Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6012999.02284 | 2095922.1714 | 37.7357348294881 | -122.39749034641501 | (37.7357348294881, -122.397490346415) | ||||
| 64361 | 64361 | 248069 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 20 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010620.265980001 | 2099403.1540599996 | 37.7451601229588 | -122.405959817907 | (37.7451601229588, -122.405959817907) | ||||
| 64756 | 64756 | 177286 | Undocumented 2 | Magnolia champaca :: Champa 170 | 104 Burrows St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6011163.93479 | 2093493.4831700001 | 37.7289638131138 | -122.403664163474 | (37.7289638131138, -122.403664163474) | ||||
| 64938 | 64938 | 249772 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 102 Pfeiffer St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6010438.89548 | 2121163.96639 | 37.8049001107042 | -122.40812137351801 | (37.8049001107042, -122.408121373518) | |||
| 66998 | 66998 | 226943 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 301 Fairmount St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 63 | 6004022.8098 | 2097135.0105400002 | 37.7385611270814 | -122.42861103418001 | (37.7385611270814, -122.42861103418) | ||||
| 67005 | 67005 | 191705 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1700 Armstrong Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6013900.77828 | 2092879.68746 | 37.727430958252604 | -122.394159667654 | (37.7274309582526, -122.394159667654) | ||||
| 68864 | 68864 | 187556 | Undocumented 2 | Schinus molle :: California Pepper 138 | 3960 Somerset St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6011365.57696 | 2088364.56073 | 37.7148921048592 | -122.40260653916599 | (37.7148921048592, -122.402606539166) | ||||
| 70101 | 70101 | 247851 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 152 Chapman St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 79 | 6009070.86749 | 2098234.59559 | 37.7418647407582 | -122.411234858803 | (37.7418647407582, -122.411234858803) | ||||
| 71813 | 71813 | 249952 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 303 Filbert St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 0ft | 6011371.46837 | 2120040.8031 | 37.801868351303796 | -122.40481496294399 | (37.8018683513038, -122.404814962944) | |||
| 75164 | 75164 | 237968 | Undocumented 2 | Prunus persica :: Peach 330 | 200 Saint Marys Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 2ft | 6003940.67465 | 2095963.2417 | 37.7353390675306 | -122.428811505646 | (37.7353390675306, -122.428811505646) | |||
| 76444 | 76444 | 196479 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1499 Rankin St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 3ft | 6012661.099719999 | 2096663.01157 | 37.737750200312206 | -122.39871065986601 | (37.7377502003122, -122.398710659866) | |||
| 77137 | 77137 | 201707 | Undocumented 2 | Acacia decurrens :: Acacia: Silver Wattle 181 | 42 Gilroy St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 0ft | 6015219.60254 | 2088607.0599200001 | 37.7157723792799 | -122.389302218834 | (37.7157723792799, -122.389302218834) | |||
| 88629 | 88629 | 117549 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 3 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 100583 | 100583 | 121159 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 112258 | 112258 | 114673 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 85X Peralta Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775155 | 6010502.29579 | 2100335.12269 | 37.7477125069204 | -122.40643339757601 | (37.7477125069204, -122.406433397576) | |||
| 113035 | 113035 | 118550 | Undocumented 2 | :: 54 | 8140 Geary Blvd | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5981686.0706 | 2112397.3766900003 | 37.7791778206923 | -122.506971243035 | (37.7791778206923, -122.506971243035) | |||||
| 115469 | 115469 | 136714 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1599 North Point St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 7ft | 6003161.03368 | 2120976.61805 | 37.803975515032604 | -122.433293789677 | (37.8039755150326, -122.433293789677) | |||
| 120437 | 120437 | 191051 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1998 Revere Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6013034.574440001 | 2095940.33474 | 37.735786681697796 | -122.397368703228 | (37.7357866816978, -122.397368703228) | ||||
| 123417 | 123417 | 247871 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 394 Mayflower St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6009746.3542 | 2098404.30325 | 37.742368581453704 | -122.40891120669201 | (37.7423685814537, -122.408911206692) | ||||
| 127197 | 127197 | 249899 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1497 Montgomery St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6011381.09793 | 2120471.14228 | 37.8030504957345 | -122.404811954701 | (37.8030504957345, -122.404811954701) | |||
| 130601 | 130601 | 179660 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 287 Hester Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6012212.84494 | 2087789.77212 | 37.7133611169841 | -122.399637673848 | (37.7133611169841, -122.399637673848) | ||||
| 130896 | 130896 | 248113 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6010385.30327 | 2099441.28079 | 37.745251666737296 | -122.40677496881099 | (37.7452516667373, -122.406774968811) | ||||
| 131235 | 131235 | 190150 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2399 Lane St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6013973.08997 | 2092870.4197900002 | 37.7274095301006 | -122.393909035588 | (37.7274095301006, -122.393909035588) | ||||
| 131384 | 131384 | 248174 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 218 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007322.63795 | 2098720.65313 | 37.7431011449024 | -122.41731411847401 | (37.7431011449024, -122.417314118474) | ||||
| 131480 | 131480 | 118634 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 349 Point Lobos Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 5981640.48035 | 2112637.4972099997 | 37.779834435634896 | -122.507146773829 | (37.7798344356349, -122.507146773829) | ||||
| 132167 | 132167 | 250156 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2500 Lyon St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999256.55789 | 2117425.58205 | 37.7940030470443 | -122.44654979756201 | (37.7940030470443, -122.446549797562) | ||||
| 132363 | 132363 | 247979 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 501 Peralta Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6009785.29961 | 2099426.45333 | 37.7451773638476 | -122.40884864356899 | (37.7451773638476, -122.408848643569) | ||||
| 132694 | 132694 | 191008 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1350 Rankin St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 2ft | 6012780.96774 | 2096905.12701 | 37.7384216764219 | -122.398313198195 | (37.7384216764219, -122.398313198195) | |||
| 132985 | 132985 | 179617 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 105 Burrows St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6011176.00009 | 2093481.4804599998 | 37.7289315301509 | -122.403621608451 | (37.7289315301509, -122.403621608451) | ||||
| 133827 | 133827 | 201703 | Undocumented 2 | Acacia decurrens :: Acacia: Silver Wattle 181 | 43 Gilroy St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 39 | Width 0ft | 6015230.77883 | 2088581.00853 | 37.7157014668276 | -122.389261770026 | (37.7157014668276, -122.389261770026) | |||
| 136706 | 136706 | 247898 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 351 Mayflower St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6010067.0176099995 | 2098387.06443 | 37.742339204188596 | -122.407801229241 | (37.7423392041886, -122.407801229241) | ||||
| 138040 | 138040 | 248089 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 14 Montcalm St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010641.03165 | 2100300.14916 | 37.7476242374868 | -122.405951190707 | (37.7476242374868, -122.405951190707) | ||||
| 142324 | 142324 | 117253 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 2500x 34TH AVE | 3 | Side Yard : Yard 17 | Tree 1 | SFUSD 4 | 3x3 | 5985829.0 | 2097874.0 | 37.73954376030179 | -122.491570003273 | (37.7395437603018, -122.491570003273) | ||||
| 146973 | 146973 | 187576 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 Bishop St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010826.85106 | 2089479.8583099998 | 37.7179243930824 | -122.40454707471301 | (37.7179243930824, -122.404547074713) | ||||
| 147949 | 147949 | 247848 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 149 Chapman St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 6009193.51112 | 2098205.9216299998 | 37.7417928858333 | -122.410808770816 | (37.7417928858333, -122.410808770816) | ||||
| 150194 | 150194 | 246625 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3300 Harrison St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6009033.3388 | 2099395.8346 | 37.7450511430894 | -122.411446641942 | (37.7450511430894, -122.411446641942) | ||||
| 150791 | 150791 | 205420 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 714 Detroit St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5999461.8044300005 | 2095388.23948 | 37.7335057294051 | -122.444255259197 | (37.7335057294051, -122.444255259197) | ||||
| 155274 | 155274 | 189419 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1751 22nd St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 10ft | 6012800.7136 | 2103762.3067099997 | 37.7572511238498 | -122.39872601759899 | (37.7572511238498, -122.398726017599) | |||
| 155365 | 155365 | 196193 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2198 Revere Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6011935.59565 | 2096781.31623 | 37.73803459111979 | -122.401227403639 | (37.7380345911198, -122.401227403639) | ||||
| 155855 | 155855 | 132392 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2833 Larkin St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6006479.362930001 | 2120932.81603 | 37.8040429353981 | -122.421807360741 | (37.8040429353981, -122.421807360741) | ||||
| 156377 | 156377 | 247522 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6000010.6242 | 2108472.60358 | 37.7694635161602 | -122.443297305835 | (37.7694635161602, -122.443297305835) | ||||
| 156569 | 156569 | 247882 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 387 Mayflower St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009927.8842 | 2098400.72535 | 37.7423689240761 | -122.40828327575701 | (37.7423689240761, -122.408283275757) | ||||
| 157171 | 157171 | 228516 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 592 Duncan St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6002757.83463 | 2099794.05926 | 37.7457905872828 | -122.43317464749501 | (37.7457905872828, -122.433174647495) | ||||
| 159471 | 159471 | 130532 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Spruce St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 4ft | 5997120.56574 | 2115634.70295 | 37.7889635367836 | -122.45381111889799 | (37.7889635367836, -122.453811118898) | |||
| 159931 | 159931 | 247918 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1098 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6010239.20977 | 2098728.38698 | 37.7432860401182 | -122.407229893555 | (37.7432860401182, -122.407229893555) | ||||
| 161180 | 161180 | 246642 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3350 Harrison St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6009030.51293 | 2099210.21196 | 37.744541305728504 | -122.41144330189199 | (37.7445413057285, -122.411443301892) | ||||
| 162181 | 162181 | 248238 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 298 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6006759.3942 | 2099022.22298 | 37.7438974828793 | -122.419283056376 | (37.7438974828793, -122.419283056376) | ||||
| 162501 | 162501 | 237907 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 3911 21st St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6002340.71018 | 2103530.84091 | 37.75602723197329 | -122.43488418855301 | (37.7560272319733, -122.434884188553) | ||||
| 164267 | 164267 | 134504 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | Width 4ft | 6008127.86822 | 2112113.3553299997 | 37.7799196898886 | -122.41547780446999 | (37.7799196898886, -122.41547780447) | |||
| 165040 | 165040 | 131051 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1285 Greenwich St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 26 | 6006739.62065 | 2119756.87873 | 37.8008287835889 | -122.42082318315701 | (37.8008287835889, -122.420823183157) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) |
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");