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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 126401 | 126401 | 113639 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1X Russ St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6009949.394180001 | 2111947.85897 | 37.7795674908256 | -122.40916462626801 | (37.7795674908256, -122.409164626268) | |||||
| 126347 | 126347 | 117645 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 2901 21ST AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5989904.0 | 2095901.0 | 37.734363711699 | -122.477336418651 | (37.734363711699, -122.477336418651) | ||||
| 126305 | 126305 | 105554 | Significant Tree 6 | Maytenus boaria :: Mayten 22 | 410 Elizabeth St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 772516 | 6003623.1 | 2102191.9 | 37.7524235434098 | -122.430353733326 | (37.7524235434098, -122.430353733326) | ||||
| 126303 | 126303 | 100056 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 401X Tehama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011330.4 | 2112435.9 | 37.78098480794971 | -122.404421471201 | (37.7809848079497, -122.404421471201) | |
| 126201 | 126201 | 116075 | Significant Tree 6 | Tree(s) :: 17 | 88 MONTCALM ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010492.0 | 2099980.0 | 37.7467368416425 | -122.406443980671 | (37.7467368416425, -122.406443980671) | |||||
| 126156 | 126156 | 98308 | Significant Tree 6 | Tree(s) :: 17 | 1490 Fairfax Ave | 1 | Front Yard : 25 | Tree 1 | Private 1 | 01/25/2012 12:00:00 AM | 3x3 | Permit Number 768575 | 6016246.6 | 2097899.9 | 37.7413455620636 | -122.386399955147 | (37.7413455620636, -122.386399955147) | ||
| 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) | |||
| 126031 | 126031 | 110476 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3700 Washington St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 5997015.1 | 2115715.0 | 37.7891779638687 | -122.454181816252 | (37.7891779638687, -122.454181816252) | |
| 126026 | 126026 | 108109 | Significant Tree 6 | Tree(s) :: 17 | 952 CAPP ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774355 | 6007364.7 | 2101732.3 | 37.751372815901604 | -122.417382061559 | (37.7513728159016, -122.417382061559) | |
| 125999 | 125999 | 106361 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1645 WEBSTER ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | ||||
| 125996 | 125996 | 103653 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 2 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.2033599997 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | |||
| 125973 | 125973 | 98834 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 333 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994230.9 | 2100817.4 | 37.748113026994 | -122.46273356703699 | (37.748113026994, -122.462733567037) | |||||
| 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) | ||||
| 125828 | 125828 | 112726 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 40x BERNAL HEIGHTS BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6009324.0 | 2098099.0 | 37.7415066181332 | -122.41035003366801 | (37.7415066181332, -122.410350033668) | |||
| 125813 | 125813 | 103600 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 50X Hermann St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.42595813798201 | (37.7707643495235, -122.425958137982) | |||||
| 125709 | 125709 | 114234 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 125647 | 125647 | 85060 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 7070 California St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/03/2007 12:00:00 AM | Permit Number 49405 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
| 125539 | 125539 | 100579 | Significant Tree 6 | Tree(s) :: 17 | 35 Lloyd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002279.7 | 2108550.0 | 37.769805157627204 | -122.435454215606 | (37.7698051576272, -122.435454215606) | |||||
| 125535 | 125535 | 116090 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
| 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) | ||||
| 125385 | 125385 | 110839 | Significant Tree 6 | Tree(s) :: 17 | 2037 TURK BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6000252.0 | 2111948.0 | 37.779019836036206 | -122.442711981138 | (37.7790198360362, -122.442711981138) | ||||
| 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) | |||
| 125242 | 125242 | 111094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 150x FONT BLVD | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 30 | 3x3 | Permit Number 775594 | 5990976.0 | 2089133.0 | 37.715842612516106 | -122.473136789074 | (37.7158426125161, -122.473136789074) | ||
| 125238 | 125238 | 105422 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 5827 DIAMOND HEIGHTS BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 6000844.1 | 2096795.2 | 37.7374476811542 | -122.439577108095 | (37.7374476811542, -122.439577108095) | ||||
| 125219 | 125219 | 110193 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 7X CASTRO ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6002014.1 | 2108690.0 | 37.7701744750285 | -122.436382938918 | (37.7701744750285, -122.436382938918) | ||||
| 125203 | 125203 | 114389 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 345x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5988176.0 | 2090635.0 | 37.7198042094326 | -122.48292478788 | (37.7198042094326, -122.48292478788) | ||||
| 125171 | 125171 | 107047 | Significant Tree 6 | Tree(s) :: 17 | 1933 15TH ST | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004592.7 | 2107127.1 | 37.766029309282295 | -122.42735222853202 | (37.7660293092823, -122.427352228532) | ||||||
| 125168 | 125168 | 85089 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | |||||
| 125158 | 125158 | 116956 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 380 SAN JOSE AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 28 | 3x3 | 6006172.0 | 2100967.0 | 37.7492042995658 | -122.421452219126 | (37.7492042995658, -122.421452219126) | |||
| 125137 | 125137 | 104285 | Significant Tree 6 | Tree(s) :: 17 | 71X 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) | |||
| 125126 | 125126 | 99829 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 129 | 2398 Broadway | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | |||||
| 125113 | 125113 | 122688 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 2590 Pacific Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 3x8 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | |||
| 125077 | 125077 | 87149 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 4 Bellair Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010093.0 | 2120950.0 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | |||||
| 125036 | 125036 | 92852 | Significant Tree 6 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 3794 16th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/14/2009 12:00:00 AM | Permit Number 53072 | 6001901.0 | 2106436.0 | 37.76397911869721 | -122.436612788339 | (37.7639791186972, -122.436612788339) | |||
| 124994 | 124994 | 104434 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1601X PORTOLA DR | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 5991823.0 | 2096240.0 | 37.73540567927029 | -122.47072655808 | (37.7354056792703, -122.47072655808) | ||||
| 124990 | 124990 | 107541 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 GARFIELD ST | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.46287353180901 | (37.7201106425596, -122.462873531809) | ||||
| 124931 | 124931 | 101527 | Significant Tree 6 | Ailanthus altissima :: Tree Of Heaven 401 | 151-153 Lower Ter | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Permit Number 769490 | 6000139.7 | 2106146.6 | 37.7630842500585 | -122.4426838025 | (37.7630842500585, -122.4426838025) | |||
| 124878 | 124878 | 97955 | Significant Tree 6 | Liquidambar styraciflua 'Slender Silhoutte' :: Upright Liquidambar 530 | 2 Mendosa Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) | |||
| 124773 | 124773 | 121168 | Significant Tree 6 | Tree(s) :: 17 | 900x Duncan St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000584.0 | 2099647.0 | 37.745263242779004 | -122.44068088983101 | (37.745263242779, -122.440680889831) | ||||
| 124454 | 124454 | 113730 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
| 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) | ||||
| 124444 | 124444 | 98547 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 555@Rio Teresita Blvd | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 124370 | 124370 | 116999 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 880x MCALLISTER ST | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005306.0 | 2112177.0 | 37.779935428414 | -122.42524444144199 | (37.779935428414, -122.425244441442) | |||||
| 124358 | 124358 | 104909 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 533 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 124356 | 124356 | 105861 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 3615-3623X Cesar Chavez St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | |||||
| 124304 | 124304 | 101467 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 301 Hazelwood Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5996219.7 | 2095283.8 | 37.733033461480495 | -122.45545652663701 | (37.7330334614805, -122.455456526637) | |||||
| 124228 | 124228 | 111770 | Significant Tree 6 | Pittosporum tobira :: Japanese Mockorange 243 | 707 Douglass St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 775627 | 6001281.0 | 2102187.2 | 37.7522776937422 | -122.438452748375 | (37.7522776937422, -122.438452748375) | ||||
| 124197 | 124197 | 96567 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 124187 | 124187 | 104433 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1601X PORTOLA DR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 5991823.0 | 2096240.0 | 37.73540567927029 | -122.47072655808 | (37.7354056792703, -122.47072655808) | ||||
| 124124 | 124124 | 104679 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 33 08th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | ||||
| 124001 | 124001 | 99698 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1750 Divisadero St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6001124.0 | 2114376.0 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | |||||
| 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) | ||||
| 123752 | 123752 | 95982 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Vasquez Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5995122.4 | 2099706.3 | 37.7451135296363 | -122.459570350972 | (37.7451135296363, -122.459570350972) | |||||
| 123605 | 123605 | 92056 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 180 | 1001 Potrero Ave | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/16/2009 12:00:00 AM | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 123568 | 123568 | 96765 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 184 Edgewood Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/12/2011 12:00:00 AM | Permit Number 767998 | 5996632.0 | 2105999.0 | 37.76247839448661 | -122.45480501488301 | (37.7624783944866, -122.454805014883) | |||
| 123402 | 123402 | 98170 | Significant Tree 6 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 2324 Sacramento St | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/22/2011 12:00:00 AM | 3 | Permit Number 768454 | 6003670.2 | 2115963.1 | 37.7902385582714 | -122.43117371849199 | (37.7902385582714, -122.431173718492) | |||
| 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) | ||||
| 123251 | 123251 | 92054 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1001 Potrero Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | |||||
| 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) | |||||
| 123166 | 123166 | 105073 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 101 LUNDYS LN | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 18 | 6006875.0 | 2098969.0 | 37.7437578546964 | -122.41887954343599 | (37.7437578546964, -122.418879543436) | ||||
| 123053 | 123053 | 113153 | Significant Tree 6 | Populus alba :: White Poplar 408 | 55 BRONTE ST | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12 | 3x3 | 6009403.0 | 2097128.0 | 37.738844891472894 | -122.410008345842 | (37.7388448914729, -122.410008345842) | ||||
| 123027 | 123027 | 101440 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X Grant Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010995.6 | 2116632.0 | 37.7924875884206 | -122.40587538693701 | (37.7924875884206, -122.405875386937) | |||||
| 123005 | 123005 | 121182 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 122936 | 122936 | 107159 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000 ESMERALDA AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009839.0 | 2098688.0 | 37.7431527400861 | -122.408610872619 | (37.7431527400861, -122.408610872619) | ||||||
| 122848 | 122848 | 96328 | Significant Tree 6 | Cordyline australis :: Dracena Palm 141 | 296 Randall St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 767829 | 6003708.0 | 2097940.0 | 37.7407536226533 | -122.429756895294 | (37.7407536226533, -122.429756895294) | ||||
| 122706 | 122706 | 88146 | Significant Tree 6 | Tree(s) :: 17 | 1475 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2000 12:00:00 AM | 3x3 | Permit Number 51176 | 6003147.8 | 2113351.1 | 37.7830370509294 | -122.43279450975001 | (37.7830370509294, -122.43279450975) | ||
| 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) | |||||
| 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) | |||||
| 122520 | 122520 | 100850 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 Estero Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 122452 | 122452 | 104674 | Significant Tree 6 | Taxus baccata :: Irish Yew 241 | 3649-3651 17TH ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | Permit Number 770917 | 6004555.5 | 2105964.3 | 37.7628344347284 | -122.427398052716 | (37.7628344347284, -122.427398052716) | |||
| 122438 | 122438 | 107835 | Significant Tree 6 | Salix babylonica :: Weeping Willow 182 | 100X SUSSEX ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6002188.0 | 2096682.0 | 37.7372132564844 | -122.434922529204 | (37.7372132564844, -122.434922529204) | ||||
| 122346 | 122346 | 87242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 4131 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 50271 | 5994116.9 | 2112250.5 | 37.779498769084604 | -122.46395756623998 | (37.7794987690846, -122.46395756624) | ||||
| 122326 | 122326 | 122412 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
| 122239 | 122239 | 105434 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 49 | 4355 ANZA ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 5985110.8 | 2111730.2 | 37.7775470387472 | -122.495074662501 | (37.7775470387472, -122.495074662501) | ||||
| 122098 | 122098 | 101203 | Significant Tree 6 | Tree(s) :: 17 | 7070 California St | 2 | Front Yard : 25 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769231 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.49337605842699 | (37.7850123376907, -122.493376058427) | |||
| 121982 | 121982 | 107985 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 13 | 2401x SCOTT ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001096.0 | 2116670.0 | 37.792033311180504 | -122.440130949989 | (37.7920333111805, -122.440130949989) | ||||
| 121907 | 121907 | 105755 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1100X Divisadero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6001418.0 | 2112151.0 | 37.7796436231931 | -122.43869287533899 | (37.7796436231931, -122.438692875339) | |||||
| 121815 | 121815 | 112772 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1X HOWTH ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998027.0 | 2091524.0 | 37.722813474972206 | -122.44893750468901 | (37.7228134749722, -122.448937504689) | ||||
| 121718 | 121718 | 107408 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 10 PEMBERTON PL | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 5998956.5 | 2104566.5 | 37.7586781689727 | -122.446662380642 | (37.7586781689727, -122.446662380642) | ||||
| 121713 | 121713 | 92964 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 380 Valdez Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 5995792.2 | 2095482.9 | 37.7335556021648 | -122.456948893253 | (37.7335556021648, -122.456948893253) | ||||
| 121702 | 121702 | 95777 | Significant Tree 6 | Acer palmatum 'Sango Kaku' :: Coral Bark Maple 518 | 30 Onondaga Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/11/2011 12:00:00 AM | Permit Number 767524 | 6001190.6 | 2091111.6 | 37.721861535681704 | -122.437972107548 | (37.7218615356817, -122.437972107548) | ||||
| 121162 | 121162 | 105090 | Significant Tree 6 | :: 54 | 344 Fulton St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 121120 | 121120 | 103719 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 49 | 748 Treat Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 8 | 3x3 | 6008496.2 | 2104169.0 | 37.758127039951205 | -122.41364151852801 | (37.7581270399512, -122.413641518528) | |||
| 121106 | 121106 | 102478 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 70 | 760 Victoria St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | |||||
| 121059 | 121059 | 103652 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 1 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.2033599997 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | |||
| 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) | |||||
| 120820 | 120820 | 115941 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 3401x 17TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 3x3 | 6006069.0 | 2106010.0 | 37.7630453994978 | -122.42216662533801 | (37.7630453994978, -122.422166625338) | ||||
| 120796 | 120796 | 105087 | Significant Tree 6 | :: 54 | 344 Fulton St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 120789 | 120789 | 120921 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 3995X Alemany Blvd | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||||
| 120773 | 120773 | 115697 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1425x LAGUNA ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6004559.0 | 2113815.0 | 37.7843907406582 | -122.4279454018 | (37.7843907406582, -122.4279454018) | ||||
| 120703 | 120703 | 105435 | Significant Tree 6 | Tree(s) :: 17 | 610 PARNASSUS AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/05/2014 12:00:00 AM | 16 | Permit Number 771221 | 5995151.3 | 2106193.4 | 37.762927120328996 | -122.459940260935 | (37.762927120329, -122.459940260935) | ||
| 120702 | 120702 | 97175 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 37 | 26 Gilbert St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | |||||
| 120634 | 120634 | 116580 | Significant Tree 6 | Shrub :: Shrub 98 | 3000x 19TH AVE | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | MTA 6 | DPW 4 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | |||
| 120572 | 120572 | 113234 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 2023 43RD AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 3x3 | 5982877.0 | 2101339.0 | 37.748884737458795 | -122.50203289923901 | (37.7488847374588, -122.502032899239) | |||
| 120452 | 120452 | 100055 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 401X Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011330.4 | 2112435.9 | 37.78098480794971 | -122.404421471201 | (37.7809848079497, -122.404421471201) | |
| 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) | ||||
| 120295 | 120295 | 117249 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 299x GRAYSTONE TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5999641.0 | 2104067.0 | 37.7573457417117 | -122.44425918093 | (37.7573457417117, -122.44425918093) | |||
| 120114 | 120114 | 122639 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 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) | |||||
| 119867 | 119867 | 120929 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 3995X Alemany Blvd | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) |
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");