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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 84536 | 84536 | 106945 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1150 LOMBARD ST | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Permit Number 773092 | 6006825.0 | 2120436.8 | 37.8027004869705 | -122.420576026126 | (37.8027004869705, -122.420576026126) | |||
| 128628 | 128628 | 107635 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 1150 Lombard St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/01/2014 12:00:00 AM | 3 | Permit Number 773092 | 6006825.00646 | 2120436.80144 | 37.8027004912885 | -122.42057600387301 | (37.8027004912885, -122.420576003873) | ||
| 93863 | 93863 | 94301 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1150X Fillmore St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 101234 | 101234 | 94303 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 102570 | 102570 | 94295 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 103966 | 103966 | 94293 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 107857 | 107857 | 94299 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1150X Fillmore St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 123205 | 123205 | 94297 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1150X Fillmore St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 125342 | 125342 | 105226 | Significant Tree 6 | Tree(s) :: 17 | 1150X Golden Gate Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/02/2014 12:00:00 AM | Permit Number 771276 | 6004329.61165 | 2112216.22051 | 37.7799879097685 | -122.428625001082 | (37.7799879097685, -122.428625001082) | |||
| 138409 | 138409 | 105227 | Significant Tree 6 | Tree(s) :: 17 | 1150X Golden Gate Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/02/2014 12:00:00 AM | Permit Number 771276 | 6004329.61165 | 2112216.22051 | 37.7799879097685 | -122.428625001082 | (37.7799879097685, -122.428625001082) | |||
| 175351 | 175351 | 106611 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1154 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6011908.79849 | 2103025.7220099997 | 37.7551788898075 | -122.401758852609 | (37.7551788898075, -122.401758852609) | |||
| 69736 | 69736 | 99191 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1155@Sansome Battery St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Plaza | Permit Number 768022 | 6012232.15659 | 2120086.23158 | 37.8020411569217 | -122.401839756495 | (37.8020411569217, -122.401839756495) | ||
| 88420 | 88420 | 96906 | Significant Tree 6 | Ulmus 'Frontier' :: Frontier Elm 464 | 1155@Sansome Battery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/05/2011 12:00:00 AM | Plaza | Permit Number 768022 | 6012245.0 | 2120028.0 | 37.80188198386271 | -122.401791216362 | (37.8018819838627, -122.401791216362) | ||
| 91730 | 91730 | 99192 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1155@Sansome Battery St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Plaza | Permit Number 768022 | 6012245.0 | 2120028.0 | 37.80188198386271 | -122.401791216362 | (37.8018819838627, -122.401791216362) | |||
| 83772 | 83772 | 99951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1160 Battery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/19/2012 12:00:00 AM | Permit Number 768993 | 6012314.3 | 2120017.7 | 37.8018575696458 | -122.40155068012699 | (37.8018575696458, -122.401550680127) | |||
| 90772 | 90772 | 106612 | Significant Tree 6 | Schinus molle :: California Pepper 138 | 1189 TENNESSEE ST | Front Yard : Yard 7 | Tree 1 | Private 1 | 55 | 6015654.1 | 2103577.3 | 37.7569017014681 | -122.388844893024 | (37.7569017014681, -122.388844893024) | |||||
| 144388 | 144388 | 114393 | Significant Tree 6 | Ficus Spp. :: 253 | 118x TAPIA DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 5988638.0 | 2090878.0 | 37.72049829773871 | -122.48134562114099 | (37.7204982977387, -122.481345621141) | ||||
| 141507 | 141507 | 104287 | Significant Tree 6 | Tree(s) :: 17 | 119X Middle Point Rd | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 90953 | 90953 | 104290 | Significant Tree 6 | Tree(s) :: 17 | 11X Hare St | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 119438 | 119438 | 78519 | Significant Tree 6 | Tree(s) :: 17 | 12 Sumner St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 3x3 | 6009421.0 | 2110873.0 | 37.776586565695894 | -122.41091663866501 | (37.7765865656959, -122.410916638665) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 10004 | 10004 | 114140 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 5 | Side Yard : Yard 17 | 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 89097 | 89097 | 114144 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 89972 | 89972 | 114147 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 118401 | 118401 | 114145 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 140509 | 140509 | 114146 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 89464 | 89464 | 100191 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1201 Holloway Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992431.5 | 2091178.1 | 37.721542125529396 | -122.46825464021099 | (37.7215421255294, -122.468254640211) | |||||
| 108692 | 108692 | 116346 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 121 SAN BENITO WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777164 | 5992901.0 | 2095856.0 | 37.73441359171021 | -122.46697163304701 | (37.7344135917102, -122.466971633047) | |
| 118284 | 118284 | 115091 | Significant Tree 6 | Tree(s) :: 17 | 121 Topaz Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | Permit Number 776934 | 6001846.4 | 2098050.0 | 37.740950064786794 | -122.436201464472 | (37.7409500647868, -122.436201464472) | |||
| 128894 | 128894 | 115090 | Significant Tree 6 | Tree(s) :: 17 | 121 Topaz Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | Permit Number 776934 | 6001846.4 | 2098050.0 | 37.740950064786794 | -122.436201464472 | (37.7409500647868, -122.436201464472) | |||
| 105495 | 105495 | 112955 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 24 | 121X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5991652.84779157 | 2095347.0788301998 | 37.7329441015396 | -122.471249796136 | (37.7329441015396, -122.471249796136) | |||||
| 107838 | 107838 | 104193 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 177 | 122 Arch St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992720.4 | 2088013.1 | 37.712868482575104 | -122.467026013031 | (37.7128684825751, -122.467026013031) | |||||
| 85476 | 85476 | 112374 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1247 Bosworth St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20x20 | Permit Number 775819 | 6000424.1100699995 | 2096055.79143 | 37.735393525896704 | -122.44097617665199 | (37.7353935258967, -122.440976176652) | |||
| 96590 | 96590 | 99643 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 1268 Lombard St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6006289.0 | 2120073.0 | 37.8016713630652 | -122.42240499597 | (37.8016713630652, -122.42240499597) | ||||
| 79699 | 79699 | 110954 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 126X Mendell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 6017060.745069999 | 2098543.2218400002 | 37.74315702656929 | -122.38362967653299 | (37.7431570265693, -122.383629676533) | |||
| 7743 | 7743 | 121449 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1274 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 10x6 | 6006927.94593 | 2119481.89109 | 37.800084349978 | -122.420151970562 | (37.800084349978, -122.420151970562) | |||
| 92493 | 92493 | 112481 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 1275 Columbus Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
| 93451 | 93451 | 112482 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1275 Columbus Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
| 107396 | 107396 | 112485 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
| 108788 | 108788 | 112483 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1275 Columbus Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
| 122611 | 122611 | 112487 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | |||||
| 122658 | 122658 | 112488 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | |||||
| 124450 | 124450 | 112484 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
| 3147 | 3147 | 253098 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1290 Portola Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 08/22/2017 12:00:00 AM | 3 | 3x3 | 5994035.0 | 2097938.0 | 37.740195634398 | -122.463202075736 | (37.740195634398, -122.463202075736) | ||
| 3158 | 3158 | 253097 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1290 Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | DPW 4 | 08/22/2017 12:00:00 AM | 3 | 3x3 | 5994035.0 | 2097938.0 | 37.740195634398 | -122.463202075736 | (37.740195634398, -122.463202075736) | |
| 119901 | 119901 | 101138 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1290 Portola Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994035.6 | 2097938.3 | 37.7401964926879 | -122.463200022957 | (37.7401964926879, -122.463200022957) | |||||
| 90145 | 90145 | 101204 | Significant Tree 6 | Tree(s) :: 17 | 1290 Stanyan St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769288 | 5997580.9 | 2104992.4 | 37.7597689094704 | -122.451450528065 | (37.7597689094704, -122.451450528065) | |||
| 89824 | 89824 | 110738 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 333 | 1299x PERSIA AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6004594.0 | 2089787.0 | 37.71841743015371 | -122.42611316787901 | (37.7184174301537, -122.426113167879) | ||||
| 104170 | 104170 | 110739 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 333 | 1299x PERSIA AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6004594.0 | 2089787.0 | 37.71841743015371 | -122.42611316787901 | (37.7184174301537, -122.426113167879) | ||||
| 125443 | 125443 | 110737 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 333 | 1299x PERSIA AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6004594.0 | 2089787.0 | 37.71841743015371 | -122.42611316787901 | (37.7184174301537, -122.426113167879) | ||||
| 123361 | 123361 | 117295 | Significant Tree 6 | Tree(s) :: 17 | 130 CAMBON DR | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 5990450.0 | 2089482.0 | 37.7167704112637 | -122.47498033116501 | (37.7167704112637, -122.474980331165) | ||||
| 95033 | 95033 | 106942 | Significant Tree 6 | Tree(s) :: 17 | 1300@ Embarcadero Battery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/02/2014 12:00:00 AM | Permit Number 772680 | 6012231.9986 | 2120618.97397 | 37.8035039293343 | -122.40187777389099 | (37.8035039293343, -122.401877773891) | |||
| 106535 | 106535 | 113163 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1300X STANYAN ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 3x3 | 5997565.0 | 2104877.0 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | |||
| 112251 | 112251 | 113162 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1300X STANYAN ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 3x3 | 5997565.0 | 2104877.0 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | |||
| 96251 | 96251 | 107399 | Significant Tree 6 | Tree(s) :: 17 | 1300X Sansome St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/02/2014 12:00:00 AM | 3 | Permit Number 772689 | 6012222.0 | 2120529.0 | 37.8032563246841 | -122.40190604611401 | (37.8032563246841, -122.401906046114) | ||
| 125954 | 125954 | 114239 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1300x JUNIPERO SERRA BLVD | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 5991168.0 | 2088425.0 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | ||||
| 1817 | 1817 | 251719 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Clayton St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5999055.0 | 2105304.0 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | |||||
| 15902 | 15902 | 108047 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 1301 Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 3 | 3x3 | 6017036.144669999 | 2097442.01922 | 37.7401319873023 | -122.383638088928 | (37.7401319873023, -122.383638088928) | ||
| 86807 | 86807 | 109521 | Significant Tree 6 | Tree(s) :: 17 | 1308 Ulloa St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5991965.5 | 2098469.9 | 37.741536659377395 | -122.470396231887 | (37.7415366593774, -122.470396231887) | ||||
| 123839 | 123839 | 114250 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 131 FONT BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
| 4659 | 4659 | 253652 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 131 Font Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x10 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
| 4673 | 4673 | 253651 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 131 Font Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
| 50494 | 50494 | 110477 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 131X Washington St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 6013427.21844 | 2117958.83498 | 37.796266453658795 | -122.397554954018 | (37.7962664536588, -122.397554954018) | |
| 78929 | 78929 | 99659 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1325 Portola Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993615.2 | 2097760.6 | 37.7396843456359 | -122.464640684629 | (37.7396843456359, -122.464640684629) | |||||
| 91973 | 91973 | 106184 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1327 ULLOA ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 2 | 4x4 | 5991893.8 | 2098371.4 | 37.7412620575898 | -122.470636971077 | (37.7412620575898, -122.470636971077) | ||
| 115473 | 115473 | 104085 | Significant Tree 6 | Populus spp :: Poplar Spp 276 | 1329 Stanyan St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/07/2013 12:00:00 AM | Permit Number 770194 | 5997530.4 | 2104741.3 | 37.7590765601241 | -122.45160706914801 | (37.7590765601241, -122.451607069148) | |||
| 81053 | 81053 | 88569 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 60 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 93053 | 93053 | 88571 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 62 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 104222 | 104222 | 88572 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 66 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 109202 | 109202 | 88570 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 61 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 112187 | 112187 | 88567 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 39 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 115344 | 115344 | 88568 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 59 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187.0 | 2113215.0 | 37.782665577707796 | -122.43264916888701 | (37.7826655777078, -122.432649168887) | |||
| 144598 | 144598 | 99662 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1337 Portola Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993559.3 | 2097744.3 | 37.7396363671104 | -122.46483277796801 | (37.7396363671104, -122.464832777968) | |||||
| 99779 | 99779 | 114394 | Significant Tree 6 | Ficus Spp. :: 253 | 134x TAPIA DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 106567 | 106567 | 106109 | Significant Tree 6 | Magnolia champaca :: Champa 170 | 135 MENDOSA AVE | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/23/2014 12:00:00 AM | Permit Number 772704 | 5992893.2 | 2100790.2 | 37.747961208182 | -122.467357269235 | (37.747961208182, -122.467357269235) | |||
| 143283 | 143283 | 106107 | Significant Tree 6 | Magnolia champaca :: Champa 170 | 135 MENDOSA AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/23/2014 12:00:00 AM | Permit Number 772704 | 5992893.2 | 2100790.2 | 37.747961208182 | -122.467357269235 | (37.747961208182, -122.467357269235) | |||
| 138380 | 138380 | 115753 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 135x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776552 | 5994185.89401 | 2096656.23912 | 37.7366849291808 | -122.46258739592 | (37.7366849291808, -122.46258739592) | ||
| 120332 | 120332 | 103422 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1365 Portola Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769779 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.46532315146601 | (37.7394617231066, -122.465323151466) | ||||
| 5055 | 5055 | 253765 | Significant Tree 6 | Acacia baileyana :: Bailey's Acacia 42 | 1366 Guerrero St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3X3 | 6005800.0848900005 | 2101007.6677599996 | 37.7492949871928 | -122.422741198761 | (37.7492949871928, -122.422741198761) | ||||
| 126828 | 126828 | 115415 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 137 ANZAVISTA AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5999865.0 | 2112093.0 | 37.7793958997315 | -122.444061187374 | (37.7793958997315, -122.444061187374) | ||||
| 120839 | 120839 | 113132 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 1375 FAIRFAX AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016814.0 | 2097238.0 | 37.7395595104895 | -122.384391976269 | (37.7395595104895, -122.384391976269) | |||||
| 86272 | 86272 | 104288 | Significant Tree 6 | Tree(s) :: 17 | 137X Middle Point Rd | 1 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 108061 | 108061 | 104751 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 13X JUAN BAUTISTA CIR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5989494.0 | 2090180.0 | 37.7186314952818 | -122.47833572411999 | (37.7186314952818, -122.47833572412) | |||||
| 96055 | 96055 | 107245 | Significant Tree 6 | Tree(s) :: 17 | 140 CEDRO AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 5991993.7 | 2093259.3 | 37.727231291852604 | -122.469919436342 | (37.7272312918526, -122.469919436342) | ||||||
| 112374 | 112374 | 99106 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1400 Evans Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/09/2012 12:00:00 AM | Permit Number 768768 | 6016404.0 | 2098045.1 | 37.741752963260105 | -122.38586583443899 | (37.7417529632601, -122.385865834439) | |||
| 126121 | 126121 | 99105 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1400@ Mendell Evans Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/09/2012 12:00:00 AM | Permit Number 768768 | 6016404.0 | 2098045.1 | 37.741752963260105 | -122.38586583443899 | (37.7417529632601, -122.385865834439) | |||
| 85678 | 85678 | 115250 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1404x Mason St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | 6009352.6 | 2118074.7 | 37.796356867240206 | -122.41166222086001 | (37.7963568672402, -122.41166222086) | ||||
| 142848 | 142848 | 108144 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 140x TOPAZ WAY | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | Permit Number 775551 | 6001767.0 | 2098265.0 | 37.741535893008106 | -122.436491384585 | (37.7415358930081, -122.436491384585) |
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");