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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8920 | 8920 | 9449 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 5 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005556.1262 | 2112420.5622 | 37.780618317973 | -122.424396471178 | (37.780618317973, -122.424396471178) | |||
| 9555 | 9555 | 105225 | Private 5 | Juniperus chinensis :: Juniper 19 | 175 Spruce St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5997195.09596 | 2114417.64894 | 37.785626103218895 | -122.453465347546 | (37.7856261032189, -122.453465347546) | ||||
| 9641 | 9641 | 114157 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9643 | 9643 | 114152 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9644 | 9644 | 114150 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9647 | 9647 | 114149 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9651 | 9651 | 114156 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9655 | 9655 | 114155 | Significant Tree 6 | Pittosporum spp :: Pittosporum spp 128 | 1200X JUNIPERO SERRA BLVD | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||||
| 9656 | 9656 | 114151 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9657 | 9657 | 114153 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9661 | 9661 | 114148 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9677 | 9677 | 114154 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200x JUNIPERO SERRA BLVD | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9883 | 9883 | 173726 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1101 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6013424.0 | 2101939.0 | 37.752279425117294 | -122.396442635345 | (37.7522794251173, -122.396442635345) | |||||
| 9912 | 9912 | 173731 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 484 Chenery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003566.0 | 2096120.0 | 37.7357482768139 | -122.43011807363199 | (37.7357482768139, -122.430118073632) | |||||
| 9972 | 9972 | 173766 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
| 9974 | 9974 | 173765 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
| 9975 | 9975 | 173768 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
| 9976 | 9976 | 173769 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
| 9978 | 9978 | 173767 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100x Bacon St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6008195.0 | 2092351.0 | 37.725660503016 | -122.413847240833 | (37.725660503016, -122.413847240833) | ||||
| 9996 | 9996 | 173615 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X JUNIPERO SERRA BLVD | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10002 | 10002 | 114158 | Significant Tree 6 | Prunus armeniaca :: Apricot 259 | 1200X JUNIPERO SERRA BLVD | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10011 | 10011 | 173616 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1200X JUNIPERO SERRA BLVD | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10020 | 10020 | 115676 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X Junipero Serra Blvd | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.2 | 2089585.5 | 37.717093588438 | -122.472660975441 | (37.717093588438, -122.472660975441) | |||
| 10099 | 10099 | 173842 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 288X Graystone Ter | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999483.0 | 2103863.0 | 37.7567765924541 | -122.444790942005 | (37.7567765924541, -122.444790942005) | |||||
| 10174 | 10174 | 173886 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 2931 20th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009454.0 | 2104482.0 | 37.759040204703496 | -122.41035112011801 | (37.7590402047035, -122.410351120118) | |||||
| 10190 | 10190 | 173887 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 2931 20th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009454.0 | 2104482.0 | 37.759040204703496 | -122.41035112011801 | (37.7590402047035, -122.410351120118) | |||||
| 10256 | 10256 | 173933 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 Beacon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003193.0 | 2097540.0 | 37.739626138558705 | -122.43150902083299 | (37.7396261385587, -122.431509020833) | |||||
| 13267 | 13267 | 187629 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 4283 23rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6001353.0 | 2102279.0 | 37.7525338497288 | -122.43821033719401 | (37.7525338497288, -122.438210337194) | ||||
| 13296 | 13296 | 187658 | Property Tree 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 600X Clarendon Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5995637.0 | 2102382.0 | 37.7524899085688 | -122.457984564932 | (37.7524899085688, -122.457984564932) | ||||
| 16097 | 16097 | 104813 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1601X Portola Dr | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 17030 | 17030 | 110785 | Permitted Site 1 | Tree(s) :: 17 | 2 Edna St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/06/2015 12:00:00 AM | 3 | 5998788.4 | 2092979.9 | 37.7268545527586 | -122.446410203741 | (37.7268545527586, -122.446410203741) | |||
| 17858 | 17858 | 121173 | Significant Tree 6 | Tree(s) :: 17 | 950 Duncan St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000333.0 | 2099683.0 | 37.7453477932295 | -122.44155138616101 | (37.7453477932295, -122.441551386161) | ||||
| 17977 | 17977 | 116827 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 14 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 18019 | 18019 | 111271 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700X BOSWORTH ST | 9 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 42 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 18620 | 18620 | 121737 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1301 Vermont St | 12 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011430.0 | 2102074.0 | 37.75253893927721 | -122.403347738299 | (37.7525389392772, -122.403347738299) | ||||
| 18708 | 18708 | 121749 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1201x Vermont St | 12 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011405.0 | 2102539.0 | 37.753814330877205 | -122.403466904543 | (37.7538143308772, -122.403466904543) | ||||
| 18793 | 18793 | 114373 | Property Tree 7 | Liquidambar styraciflua :: American Sweet Gum 62 | 805 GONZALEZ DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 5988302.0 | 2089566.0 | 37.7168763353695 | -122.482410970247 | (37.7168763353695, -122.482410970247) | ||||
| 18877 | 18877 | 82435 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 51 Peralta Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/02/2005 12:00:00 AM | 20 | 6010636.52703341 | 2100363.58782589 | 37.7477981742678 | -122.405971235802 | (37.7477981742678, -122.405971235802) | |||
| 18891 | 18891 | 107407 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 171 TWIN PEAKS BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5998631.4 | 2104681.4 | 37.7589750798494 | -122.44779499190099 | (37.7589750798494, -122.447794991901) | ||||
| 19583 | 19583 | 119914 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 400X Brotherhood Way | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 100x100 | |||||||||
| 20477 | 20477 | 104866 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 411 Holladay Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | |||||
| 20865 | 20865 | 103256 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 4187 26th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 3x3 | 6002700.0 | 2100625.0 | 37.7480688746475 | -122.433434000346 | (37.7480688746475, -122.433434000346) | |||
| 22288 | 22288 | 237856 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 636 30th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 6ft | 6002455.57988 | 2098272.49197 | 37.7415955682714 | -122.434111048608 | (37.7415955682714, -122.434111048608) | |||
| 22304 | 22304 | 248911 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 1633 Oakdale Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6014844.92913 | 2095599.8976 | 37.7349525388235 | -122.39108575959101 | (37.7349525388235, -122.391085759591) | |||||
| 22822 | 22822 | 248039 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 21 Rutledge St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010496.95071 | 2099420.9430400003 | 37.745202070015296 | -122.406387476112 | (37.7452020700153, -122.406387476112) | ||||
| 22891 | 22891 | 247616 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 300 Bradford St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6009490.26965 | 2096786.7692099998 | 37.737912836413706 | -122.409682528235 | (37.7379128364137, -122.409682528235) | ||||
| 23001 | 23001 | 251172 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 363 Jersey St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002784.74363 | 2101501.25508 | 37.750479672211 | -122.433203561601 | (37.750479672211, -122.433203561601) | |||||
| 23162 | 23162 | 251173 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 367 Jersey St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 3ft | 6002770.52649 | 2101500.0126900002 | 37.7504754543841 | -122.43325263672399 | (37.7504754543841, -122.433252636724) | ||||
| 23388 | 23388 | 191040 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1301 Minnesota St | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6015380.38588 | 2102504.53618 | 37.75394094514021 | -122.389716581452 | (37.7539409451402, -122.389716581452) | ||||
| 23442 | 23442 | 187500 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Walbridge St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6005130.65162 | 2086494.3835099998 | 37.709406927448796 | -122.424024164397 | (37.7094069274488, -122.424024164397) | ||||
| 23496 | 23496 | 222676 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 701 Church St | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6004317.3839 | 2104765.72552 | 37.7595299645462 | -122.428136192139 | (37.7595299645462, -122.428136192139) | |||
| 23547 | 23547 | 125572 | Undocumented 2 | Araucaria columnaris :: Coral reef araucaria 185 | 1120 Greenwich St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6007488.07621 | 2119895.66738 | 37.8012520198356 | -122.418243052479 | (37.8012520198356, -122.418243052479) | ||||
| 23804 | 23804 | 223982 | Undocumented 2 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 107 | 1000 San Jose Ave | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6005159.471609999 | 2097237.42875 | 37.738906606148205 | -122.424688283133 | (37.7389066061482, -122.424688283133) | ||||
| 23865 | 23865 | 188421 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 602 Arthur Ave | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015740.2817 | 2099823.35637 | 37.7465989366059 | -122.388284852668 | (37.7465989366059, -122.388284852668) | ||||
| 23907 | 23907 | 247195 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 900 Waller St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6001251.021869999 | 2108666.7471 | 37.7700672400275 | -122.43902074711201 | (37.7700672400275, -122.439020747112) | ||||
| 23909 | 23909 | 249678 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2400 Baker St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5999727.06015 | 2117202.6736 | 37.7934178626924 | -122.444905786498 | (37.7934178626924, -122.444905786498) | ||||
| 23961 | 23961 | 247944 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 21 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010317.99645 | 2098902.9194900002 | 37.7437696775404 | -122.40696976733999 | (37.7437696775404, -122.40696976734) | ||||
| 24072 | 24072 | 246633 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3320 Harrison St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6009029.84734 | 2099262.75496 | 37.7446855398981 | -122.411449314735 | (37.7446855398981, -122.411449314735) | ||||
| 24107 | 24107 | 120282 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 129 24th Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 5988304.19862 | 2115114.50046 | 37.787025803891204 | -122.484276029631 | (37.7870258038912, -122.484276029631) | ||||
| 24196 | 24196 | 198273 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Pennsylvania Ave | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014246.68754 | 2106694.7124400004 | 37.7653833298046 | -122.393930504207 | (37.7653833298046, -122.393930504207) | ||||
| 24228 | 24228 | 197487 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1301 Minnesota St | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6015378.84744 | 2102468.94598 | 37.75384313667529 | -122.389719416144 | (37.7538431366753, -122.389719416144) | ||||
| 24281 | 24281 | 223831 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 100 Santa Marina St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6006175.86532 | 2097493.16654 | 37.7396661564679 | -122.421192213677 | (37.7396661564679, -122.421192213677) | ||||
| 24288 | 24288 | 224150 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1001 San Jose Ave | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6005234.007999999 | 2096984.22045 | 37.738215562603294 | -122.424412565406 | (37.7382155626033, -122.424412565406) | ||||
| 24400 | 24400 | 220351 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 3921 21st St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6002309.75741 | 2103525.9195 | 37.7560119615059 | -122.434990881437 | (37.7560119615059, -122.434990881437) | ||||
| 24447 | 24447 | 201523 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 799 Earl St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 10ft | 6020371.96237 | 2093662.3098400002 | 37.729937451546704 | -122.371842613372 | (37.7299374515467, -122.371842613372) | |||
| 24493 | 24493 | 190983 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6016115.94828 | 2100251.3725900003 | 37.7477949890666 | -122.387015672733 | (37.7477949890666, -122.387015672733) | ||||
| 24497 | 24497 | 227291 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 65 Zircon Pl | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 4ft | 6002354.98671 | 2098718.92039 | 37.7428156470274 | -122.43449077742399 | (37.7428156470274, -122.434490777424) | |||
| 24654 | 24654 | 190986 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6016149.69105 | 2100259.24355 | 37.747818469462 | -122.38689953970601 | (37.747818469462, -122.386899539706) | ||||
| 24719 | 24719 | 247088 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2301 Castro St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6002764.361830001 | 2098589.4854900003 | 37.74248347881979 | -122.43306602918001 | (37.7424834788198, -122.43306602918) | ||||
| 24891 | 24891 | 213671 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 3ft | 5994885.5088599995 | 2098943.91671 | 37.7430065910919 | -122.460334245238 | (37.7430065910919, -122.460334245238) | |||
| 24892 | 24892 | 197177 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1900 23rd St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6012740.291540001 | 2102830.02856 | 37.7546879247201 | -122.39886955298599 | (37.7546879247201, -122.398869552986) | ||||
| 24900 | 24900 | 249938 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 339 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 6011244.68883 | 2120032.5219400004 | 37.8018385261831 | -122.405253098256 | (37.8018385261831, -122.405253098256) | |||
| 24963 | 24963 | 189144 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 602 Arthur Ave | 45 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 5ft | 6015967.83076 | 2099823.77263 | 37.7466126854204 | -122.38749803403 | (37.7466126854204, -122.38749803403) | |||
| 25037 | 25037 | 249812 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 260 Chestnut St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010650.1980099995 | 2121033.7396299997 | 37.8045543690542 | -122.40738094817699 | (37.8045543690542, -122.407380948177) | |||
| 25070 | 25070 | 245815 | Undocumented 2 | Corymbia citriodora :: Lemon Scented Gum 301 | 1000 San Jose Ave | 92 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004991.22077 | 2096914.7584400002 | 37.7380111224129 | -122.42524706251699 | (37.7380111224129, -122.425247062517) | ||||
| 25090 | 25090 | 223699 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 72 | 6004901.063490001 | 2096745.81285 | 37.737542142145706 | -122.425546760699 | (37.7375421421457, -122.425546760699) | ||||
| 25099 | 25099 | 224199 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005272.32245 | 2097108.7115200001 | 37.738559550591795 | -122.42428894459299 | (37.7385595505918, -122.424288944593) | ||||
| 25107 | 25107 | 191446 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Tulare St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6016252.95003 | 2100312.60959 | 37.747970718394704 | -122.386546192477 | (37.7479707183947, -122.386546192477) | ||||
| 25153 | 25153 | 219212 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 1501 15th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5991536.71945 | 2105150.6616 | 37.759855492149704 | -122.47236570472 | (37.7598554921497, -122.47236570472) | ||||
| 25418 | 25418 | 191034 | Undocumented 2 | Diospyros kaki :: Persimmon 293 | 2338 Lane St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 6ft | 6013925.13865 | 2092881.2708700001 | 37.727436659956005 | -122.394075563956 | (37.727436659956, -122.394075563956) | |||
| 25490 | 25490 | 225139 | Undocumented 2 | Chamaecyparis species :: 347 | 701 Church St | 41 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004346.6017 | 2104631.68872 | 37.759163584356706 | -122.428025590809 | (37.7591635843567, -122.428025590809) | ||||
| 25522 | 25522 | 175043 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 199 Shakespeare St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 8ft | 5993498.29454 | 2086678.39145 | 37.709248559547504 | -122.464240538697 | (37.7092485595475, -122.464240538697) | |||
| 25572 | 25572 | 191703 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1501 Quint St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 4ft | 6013259.66608 | 2096346.4213299998 | 37.7369142408999 | -122.396618925818 | (37.7369142408999, -122.396618925818) | |||
| 25613 | 25613 | 240953 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 1101 San Jose Ave | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004805.95854 | 2096424.9931 | 37.7366558692687 | -122.42585275411601 | (37.7366558692687, -122.425852754116) | ||||
| 25672 | 25672 | 247989 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 130 Mullen Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 10ft | 6009899.29934 | 2099821.3308900003 | 37.7462679959733 | -122.40848229933901 | (37.7462679959733, -122.408482299339) | |||
| 25680 | 25680 | 247142 | Undocumented 2 | Pinus halepensis :: Allepo Pine 164 | 500 27th St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6003177.22177 | 2100100.19766 | 37.7466549535644 | -122.43174632176 | (37.7466549535644, -122.43174632176) | ||||
| 25780 | 25780 | 178245 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 62 Tomaso Ct | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 39 | Width 8ft | 6009206.68729 | 2086340.63676 | 37.7092140561483 | -122.409925810128 | (37.7092140561483, -122.409925810128) | |||
| 25786 | 25786 | 196352 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6011956.0756 | 2105144.27438 | 37.76099860510921 | -122.401744258403 | (37.7609986051092, -122.401744258403) | ||||
| 25843 | 25843 | 121699 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 1002 Pennsylvania Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6014459.10408 | 2102474.46412 | 37.753807243829 | -122.392900512462 | (37.753807243829, -122.392900512462) | ||||
| 25962 | 25962 | 209036 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 427 Baden St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | 6000750.14831 | 2095370.65935 | 37.7335308771479 | -122.439799837889 | (37.7335308771479, -122.439799837889) | ||||
| 26215 | 26215 | 224159 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1001 San Jose Ave | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6005282.42958 | 2097112.8696299999 | 37.738571538533 | -122.424254294602 | (37.738571538533, -122.424254294602) | ||||
| 26417 | 26417 | 247936 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1149 Esmeralda Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010249.43041 | 2098747.94631 | 37.7433403177918 | -122.40719593154101 | (37.7433403177918, -122.407195931541) | ||||
| 26474 | 26474 | 250207 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 212 Union St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 0ft | 6011784.78005 | 2119790.75424 | 37.801204871053706 | -122.40336710211399 | (37.8012048710537, -122.403367102114) | |||
| 26504 | 26504 | 227603 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 55 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004504.07862 | 2096101.1879099999 | 37.735749708773795 | -122.42687342978998 | (37.7357497087738, -122.42687342979) | ||||
| 26585 | 26585 | 187549 | Undocumented 2 | Ficus Spp. :: 253 | 130 Alpha St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010899.87279 | 2088102.00857 | 37.714145178327996 | -122.404197749245 | (37.714145178328, -122.404197749245) | ||||
| 26650 | 26650 | 109414 | Significant Tree 6 | Persea americana :: Avocado 113 | 4 GUY PL | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6014378.1 | 2114502.6 | 37.786829336844605 | -122.394022608955 | (37.7868293368446, -122.394022608955) | ||||
| 26728 | 26728 | 197173 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1900 23rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6012739.26156 | 2102864.49072 | 37.7547824929244 | -122.39887553350201 | (37.7547824929244, -122.398875533502) | ||||
| 26754 | 26754 | 197191 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 602 Arthur Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6015839.12005 | 2099880.54912 | 37.7467614521736 | -122.38794706729799 | (37.7467614521736, -122.387947067298) | ||||
| 26819 | 26819 | 202073 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1 Gould St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6012686.9776800005 | 2090655.72307 | 37.721256863288396 | -122.398199843161 | (37.7212568632884, -122.398199843161) | ||||
| 26929 | 26929 | 219589 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1201 San Jose Ave | 32 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004392.47127 | 2096007.06435 | 37.7354849555631 | -122.42725259745 | (37.7354849555631, -122.42725259745) |
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");