Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 152523 | 152523 | 223698 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 151 | 6004903.42732 | 2096771.39372 | 37.7376125150086 | -122.42554040785801 | (37.7376125150086, -122.425540407858) | ||||
| 106826 | 106826 | 107037 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1060 Clayton St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 99 | 5998985.0 | 2106259.0 | 37.7633269800406 | -122.446685590868 | (37.7633269800406, -122.446685590868) | ||||
| 97410 | 97410 | 113742 | Landmark tree 9 | Ficus macrophylla :: Morton Bay Fig 148 | 1580 Valencia St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 80 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | ||||
| 108351 | 108351 | 106363 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 URBANO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 80 | 5993535.8 | 2092458.1 | 37.7251204132224 | -122.464530299025 | (37.7251204132224, -122.464530299025) | ||||
| 30066 | 30066 | 178334 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 11 Pilgrim Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 79 | 6000689.70014 | 2093938.9080400001 | 37.729596178617705 | -122.439906202537 | (37.7295961786177, -122.439906202537) | ||||
| 138404 | 138404 | 114251 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 129 FONT BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 75 | 5990853.0 | 2088876.0 | 37.715129831054796 | -122.473543194374 | (37.7151298310548, -122.473543194374) | ||||
| 154149 | 154149 | 201514 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1001 Innes Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 75 | 6018663.55815 | 2094844.4948099998 | 37.733089515074795 | -122.377830854436 | (37.7330895150748, -122.377830854436) | ||||
| 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) | ||||
| 46888 | 46888 | 223710 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 67 | 6004258.36813 | 2095937.1689 | 37.735285453551604 | -122.427711264267 | (37.7352854535516, -122.427711264267) | ||||
| 132735 | 132735 | 223694 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 65 | 6005104.45792 | 2096735.8383799999 | 37.7375262448502 | -122.424842819945 | (37.7375262448502, -122.424842819945) | ||||
| 19797 | 19797 | 97906 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 401 Upper Ter | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2011 12:00:00 AM | 60 | Permit Number 768366 | 5999222.6 | 2106240.8 | 37.7632905770055 | -122.44586250428002 | (37.7632905770055, -122.44586250428) | ||
| 83227 | 83227 | 102226 | Undocumented 2 | Tree(s) :: 17 | 3088 Market St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/28/2013 12:00:00 AM | 60 | Permit Number 769557 | 5999953.3 | 2105403.7 | 37.7610338030554 | -122.443275133554 | (37.7610338030554, -122.443275133554) | ||
| 98176 | 98176 | 105497 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3929 19TH ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 60 | 6003450.9 | 2104734.8 | 37.7593959875427 | -122.431130714429 | (37.7593959875427, -122.431130714429) | ||||
| 53546 | 53546 | 223712 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 75 | Front Yard : Yard 7 | Tree 1 | Private 1 | 59 | 6004557.86024 | 2096180.22234 | 37.7359697602838 | -122.426693112116 | (37.7359697602838, -122.426693112116) | ||||
| 75817 | 75817 | 247835 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 Nevada St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 58 | 6009027.31415 | 2098119.1381900003 | 37.7415452773025 | -122.411377297935 | (37.7415452773025, -122.411377297935) | ||||
| 133455 | 133455 | 126127 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 956 Vallejo St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 57 | 6008898.21639 | 2118715.7176599996 | 37.798091444229605 | -122.41327984251001 | (37.7980914442296, -122.41327984251) | ||||
| 58790 | 58790 | 205909 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 14 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 56 | 6000896.43949 | 2095509.3176099998 | 37.733919926568106 | -122.43930400388399 | (37.7339199265681, -122.439304003884) | ||||
| 97649 | 97649 | 114386 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 429x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 56 | 5988163.0 | 2090444.0 | 37.7192790152529 | -122.482955732568 | (37.7192790152529, -122.482955732568) | ||||
| 127597 | 127597 | 114509 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3X VULCAN STWY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 56 | 6000640.0 | 2106231.0 | 37.7633444989385 | -122.440959493883 | (37.7633444989385, -122.440959493883) | ||||
| 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) | |||||
| 131413 | 131413 | 247109 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2301 Castro St | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 55 | 6002712.35608 | 2098750.32101 | 37.742922145648606 | -122.433257339272 | (37.7429221456486, -122.433257339272) | ||||
| 137779 | 137779 | 223717 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1101 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 55 | 6005027.45143 | 2096662.24212 | 37.737319816266705 | -122.425103832873 | (37.7373198162667, -122.425103832873) | ||||
| 145874 | 145874 | 100769 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3701 21st St | Front Yard : Yard 7 | Tree 1 | Private 1 | 55 | Street tree w/in RoW | 6003717.0 | 2103606.0 | 37.7563116466144 | -122.43012988292 | (37.7563116466144, -122.43012988292) | ||||
| 68976 | 68976 | 132202 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 956 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 54 | 6008925.4683300005 | 2118706.00298 | 37.7980663000818 | -122.413184855205 | (37.7980663000818, -122.413184855205) | ||||
| 129598 | 129598 | 222999 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 3955 21st St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 53 | 6002171.060869999 | 2103519.51853 | 37.7559865097873 | -122.435470081578 | (37.7559865097873, -122.435470081578) | ||||
| 184802 | 184802 | 249765 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 266 Lombard St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 53 | Width 0ft | 6010998.40684 | 2120702.14433 | 37.8036633729317 | -122.406152556991 | (37.8036633729317, -122.406152556991) | |||
| 48319 | 48319 | 249971 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 216 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 52 | Width 0ft | 6011749.26924 | 2120132.42748 | 37.8021410392439 | -122.403514037858 | (37.8021410392439, -122.403514037858) | |||
| 77061 | 77061 | 132174 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1111 Chestnut St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 52 | 6006441.86345 | 2120416.15353 | 37.8026221972261 | -122.42190040728998 | (37.8026221972261, -122.42190040729) | ||||
| 77269 | 77269 | 223713 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 81 | Front Yard : Yard 7 | Tree 1 | Private 1 | 52 | 6004590.4575 | 2096203.6023099998 | 37.7360357993049 | -122.426582074619 | (37.7360357993049, -122.426582074619) | ||||
| 60073 | 60073 | 223798 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 250 States St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 51 | Width 3ft | 6000691.89745 | 2106604.60917 | 37.764373293104896 | -122.44080679981501 | (37.7643732931049, -122.440806799815) | |||
| 35196 | 35196 | 223693 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 6004632.33856 | 2096219.1037400002 | 37.736080730338394 | -122.426438378246 | (37.7360807303384, -122.426438378246) | ||||
| 99642 | 99642 | 113379 | Property Tree 7 | Fagus sylvatica :: European Beech 250 | 140 CASTENADA AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 5994437.0 | 2101097.0 | 37.7488926059174 | -122.462041158848 | (37.7488926059174, -122.462041158848) | ||||
| 114769 | 114769 | 114267 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800x BROTHERHOOD WAY | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 142961 | 142961 | 104761 | Significant Tree 6 | Ilex aquifolium :: European Holly 277 | 1665 18TH AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 9x9 | 5990543.2 | 2104073.0 | 37.756838968238 | -122.475723071248 | (37.756838968238, -122.475723071248) | ||||
| 144810 | 144810 | 104762 | Significant Tree 6 | Ilex aquifolium :: European Holly 277 | 1665 18TH AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 9x9 | 5990543.2 | 2104073.0 | 37.756838968238 | -122.475723071248 | (37.756838968238, -122.475723071248) | ||||
| 146111 | 146111 | 223697 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 50 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 6005304.12461 | 2097202.65687 | 37.738819299062904 | -122.424185667341 | (37.7388192990629, -122.424185667341) | ||||
| 170501 | 170501 | 205908 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 22 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 6000855.4988 | 2095527.0411599998 | 37.733966261424 | -122.43944681802799 | (37.733966261424, -122.439446818028) | ||||
| 181738 | 181738 | 223705 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 79 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 6004537.44257 | 2096386.8120900001 | 37.7365358547364 | -122.426778411906 | (37.7365358547364, -122.426778411906) | ||||
| 42862 | 42862 | 249675 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Baker St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 49 | 5999731.49147 | 2117154.85585 | 37.7932868206735 | -122.444887014927 | (37.7932868206735, -122.444887014927) | ||||
| 129599 | 129599 | 125343 | Undocumented 2 | Acer macrophyllum :: Big Leaf Maple 159 | 900 Green St | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 49 | 6008565.48376 | 2119003.63515 | 37.798863308048794 | -122.414451581778 | (37.7988633080488, -122.414451581778) | ||||
| 155482 | 155482 | 132175 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1100 Chestnut St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 49 | 6006452.3729 | 2120433.08861 | 37.8026692893229 | -122.421865242911 | (37.8026692893229, -122.421865242911) | ||||
| 33613 | 33613 | 181300 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Nueva Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 48 | Width 4ft | 6013063.40285 | 2087533.07945 | 37.712703665812796 | -122.39667984502199 | (37.7127036658128, -122.396679845022) | |||
| 92075 | 92075 | 111588 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 48 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | |||
| 102684 | 102684 | 111539 | DPW Maintained 3 | Acacia spp :: Acacia Spp 176 | 900x BOSWORTH ST | 17 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 48 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 114021 | 114021 | 111281 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 700X BOSWORTH ST | 19 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 48 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 117755 | 117755 | 107142 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 2694 MCALLISTER ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 48 | 5996297.4 | 2110789.6 | 37.7756129427938 | -122.45630867288999 | (37.7756129427938, -122.45630867289) | ||||
| 140312 | 140312 | 115391 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 21X BELMONT AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 48 | 5996611.0 | 2106266.0 | 37.7632103037359 | -122.45489693849501 | (37.7632103037359, -122.454896938495) | ||||
| 141340 | 141340 | 111506 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 800x BOSWORTH ST | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 48 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
| 169290 | 169290 | 247108 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2301 Castro St | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 48 | 6002704.67605 | 2098786.321 | 37.7430205575564 | -122.433286466502 | (37.7430205575564, -122.433286466502) | ||||
| 53350 | 53350 | 223795 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 22 Saturn St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 47 | Width 3ft | 6000543.87273 | 2106026.1348599996 | 37.7627765144437 | -122.44127726574101 | (37.7627765144437, -122.441277265741) | |||
| 56853 | 56853 | 224143 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 47 | Width 8ft | 6005228.63249 | 2097540.9706099997 | 37.7397439694151 | -122.424470741631 | (37.7397439694151, -122.424470741631) | |||
| 132334 | 132334 | 224176 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1000 San Jose Ave | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 47 | 6005145.896380001 | 2097244.7957200003 | 37.738926067473 | -122.424735743967 | (37.738926067473, -122.424735743967) | ||||
| 43642 | 43642 | 234528 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 San Jose Av Off Ramp | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 46 | 6002924.2654 | 2095295.03485 | 37.733446743766606 | -122.432277899312 | (37.7334467437666, -122.432277899312) | ||||
| 57024 | 57024 | 209025 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 36 Martha Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 46 | 6000769.58789 | 2095570.4874200001 | 37.7340806650885 | -122.43974695145599 | (37.7340806650885, -122.439746951456) | ||||
| 164177 | 164177 | 224220 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1201 San Jose Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 46 | 6004122.93683 | 2095831.8247900002 | 37.734988540591395 | -122.42817199506099 | (37.7349885405914, -122.428171995061) | ||||
| 49444 | 49444 | 249767 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 266 Lombard St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | Width 0ft | 6010996.518680001 | 2120736.58117 | 37.8037578224149 | -122.406161518736 | (37.8037578224149, -122.406161518736) | |||
| 57311 | 57311 | 197586 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Jack Balestreri Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | Width 10ft | 6012374.628719999 | 2104733.59825 | 37.7598943275787 | -122.400267811735 | (37.7598943275787, -122.400267811735) | |||
| 157760 | 157760 | 224275 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1300 San Jose Ave | 53 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | 6003325.50221 | 2095516.5443799999 | 37.734077700922896 | -122.43090651413999 | (37.7340777009229, -122.43090651414) | ||||
| 158580 | 158580 | 133176 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 Francisco St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | 6010490.33512 | 2121337.17898 | 37.8053785896135 | -122.407955582591 | (37.8053785896135, -122.407955582591) | ||||
| 169268 | 169268 | 246758 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 70 Waltham St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | 6009165.3759699995 | 2098887.8964 | 37.743663861508395 | -122.41095421008801 | (37.7436638615084, -122.410954210088) | ||||
| 176669 | 176669 | 223743 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 65 Zircon Pl | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | 6002363.70914 | 2098682.85125 | 37.7427171047157 | -122.434458039421 | (37.7427171047157, -122.434458039421) | ||||
| 31219 | 31219 | 194283 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Tulare St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 44 | 6016255.79944 | 2100318.37917 | 37.747986718206604 | -122.386536741486 | (37.7479867182066, -122.386536741486) | ||||
| 58821 | 58821 | 223001 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 3944 22nd St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 44 | 6002181.90808 | 2102965.21527 | 37.7544651419609 | -122.43539291887501 | (37.7544651419609, -122.435392918875) | ||||
| 112832 | 112832 | 108978 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 MIGUEL ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 44 | 6003334.2 | 2097391.9 | 37.739227491928894 | -122.431010244874 | (37.7392274919289, -122.431010244874) | ||||
| 137916 | 137916 | 125342 | Undocumented 2 | Acer macrophyllum :: Big Leaf Maple 159 | 900 Green St | 34 | Front Yard : Yard 7 | Tree 1 | Private 1 | 44 | 6008569.92711 | 2119005.57592 | 37.7988688865349 | -122.41443634368099 | (37.7988688865349, -122.414436343681) | ||||
| 73388 | 73388 | 249854 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 285 Greenwich St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 43 | Width 0ft | 6011456.47585 | 2120387.94643 | 37.8028262731804 | -122.40454524638099 | (37.8028262731804, -122.404545246381) | |||
| 134472 | 134472 | 221252 | Undocumented 2 | Betula pendula :: European White Birch 146 | 190 Storrie St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 43 | Width 3ft | 6000796.34064 | 2105302.63259 | 37.7608043335649 | -122.44035218082199 | (37.7608043335649, -122.440352180822) | |||
| 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) | ||||
| 28978 | 28978 | 233911 | Undocumented 2 | Paulownia fortunei :: Dragon tree 365 | 1100 San Jose Ave | 75 | Front Yard : Yard 7 | Tree 1 | Private 1 | 42 | 6004583.96879 | 2096449.39973 | 37.7367103367208 | -122.426622006327 | (37.7367103367208, -122.426622006327) | ||||
| 158258 | 158258 | 233307 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 680 29th St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 42 | 6002117.91965 | 2098881.4010400004 | 37.743248320761204 | -122.435322107156 | (37.7432483207612, -122.435322107156) | ||||
| 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) | ||||
| 47483 | 47483 | 223974 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2 Miguel St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | 6003823.8109 | 2097275.5293400004 | 37.7389356956285 | -122.429309094259 | (37.7389356956285, -122.429309094259) | ||||
| 134583 | 134583 | 209010 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 408 Baden St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | 6000785.06362 | 2095352.2063400003 | 37.7334821968386 | -122.439677803484 | (37.7334821968386, -122.439677803484) | ||||
| 148811 | 148811 | 247957 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 8 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | 6010434.9927199995 | 2098878.7541 | 37.743709870826 | -122.40656351750602 | (37.743709870826, -122.406563517506) | ||||
| 182295 | 182295 | 249826 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 391 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | Width 0ft | 6011015.83097 | 2120024.81975 | 37.8018045803872 | -122.406044514263 | (37.8018045803872, -122.406044514263) | |||
| 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) | ||||
| 60603 | 60603 | 247590 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 800 Tompkins Ave | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6008957.64855 | 2096444.8911599999 | 37.736944252178205 | -122.411499920492 | (37.7369442521782, -122.411499920492) | ||||
| 79785 | 79785 | 106153 | Undocumented 2 | Tree(s) :: 17 | 735 TERESITA BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/25/2014 12:00:00 AM | 40 | Permit Number 772792 | 5998960.9 | 2095994.0 | 37.7351404140963 | -122.44603057724899 | (37.7351404140963, -122.446030577249) | ||
| 83189 | 83189 | 104146 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1710-1738 Diamond St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6001979.7 | 2099047.6 | 37.743696813668706 | -122.43581192261101 | (37.7436968136687, -122.435811922611) | ||||
| 90169 | 90169 | 104567 | Private 5 | Tree(s) :: 17 | 8 JOY ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6010448.0 | 2098932.0 | 37.7438568002142 | -122.40652229250799 | (37.7438568002142, -122.406522292508) | ||||
| 91183 | 91183 | 114258 | Private 5 | Pinus radiata :: Monterey Pine 3 | 70x CHUMASERO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 5990913.0 | 2088468.0 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | ||||
| 95974 | 95974 | 111547 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900x BOSWORTH ST | 25 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 40 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 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) | |||
| 123394 | 123394 | 114040 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 95 LINARES AVE | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 40 | 3x3 | 5994258.0 | 2102054.0 | 37.751509977458795 | -122.462729551044 | (37.7515099774588, -122.462729551044) | |||
| 131190 | 131190 | 246442 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 485 Duncan St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6003379.46073 | 2099778.50621 | 37.7457831256083 | -122.431024044746 | (37.7457831256083, -122.431024044746) | ||||
| 137317 | 137317 | 223704 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 78 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6004560.21701 | 2096406.8969299998 | 37.7365922907993 | -122.426701100777 | (37.7365922907993, -122.426701100777) | ||||
| 141204 | 141204 | 111548 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x BOSWORTH ST | 26 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 40 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 141435 | 141435 | 104808 | Significant Tree 6 | Ilex aquifolium :: European Holly 277 | 1665 08th Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 5993673.5 | 2104163.7 | 37.7572689897716 | -122.46490400670099 | (37.7572689897716, -122.464904006701) | |||||
| 170407 | 170407 | 223738 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1760 Diamond St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6002028.666809999 | 2098687.0013900003 | 37.742709475762894 | -122.43561681495899 | (37.7427094757629, -122.435616814959) | ||||
| 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) | |||
| 43799 | 43799 | 224152 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1001 San Jose Ave | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 39 | 6005249.86613 | 2097022.14713 | 37.7383205962226 | -122.424360432602 | (37.7383205962226, -122.424360432602) | ||||
| 52226 | 52226 | 247946 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 15 Joy St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 39 | 6010368.2533 | 2098885.09245 | 37.7437235405125 | -122.406794734117 | (37.7437235405125, -122.406794734117) | ||||
| 69573 | 69573 | 221253 | Undocumented 2 | Betula pendula :: European White Birch 146 | 190 Storrie St | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 39 | Width 3ft | 6000832.842619999 | 2105336.18629 | 37.760898542056296 | -122.44022834328001 | (37.7608985420563, -122.44022834328) | |||
| 157797 | 157797 | 234527 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 San Jose Av Off Ramp | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 39 | 6002909.37025 | 2095287.3929700002 | 37.733424916326605 | -122.432328850416 | (37.7334249163266, -122.432328850416) | ||||
| 54301 | 54301 | 194281 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Tulare St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 6016211.24922 | 2100302.5214299997 | 37.7479407097974 | -122.38668969007601 | (37.7479407097974, -122.386689690076) | ||||
| 56202 | 56202 | 221255 | Undocumented 2 | Betula pendula :: European White Birch 146 | 190 Storrie St | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | Width 3ft | 6000864.196380001 | 2105365.8102700002 | 37.7609816672784 | -122.44012202902901 | (37.7609816672784, -122.440122029029) | |||
| 83858 | 83858 | 111541 | DPW Maintained 3 | Acacia spp :: Acacia Spp 176 | 900x BOSWORTH ST | 19 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 38 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 88589 | 88589 | 114269 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800x BROTHERHOOD WAY | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 104842 | 104842 | 111542 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900x BOSWORTH ST | 20 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 38 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) |
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");