Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5008 | 5008 | 253723 | DPW Maintained 3 | Calocedrus decurrens :: Incense Cedar 177 | 1X Glenview Dr | Median : Yard 3 | Tree 1 | DPW 2 | 3x3 | 5998487.0 | 2100314.0 | 37.746975021233204 | -122.447979947083 | (37.7469750212332, -122.447979947083) | |||||
| 3208 | 3208 | 253368 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 236 Moncada Way | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 10x10 | 5992398.0 | 2093455.0 | 37.7277919980392 | -122.468536018982 | (37.7277919980392, -122.468536018982) | ||||
| 1098 | 1098 | 251438 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501X Santiago St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 764 | 764 | 251379 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 747 | 747 | 251378 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 757 | 757 | 251377 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 785 | 785 | 251376 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 731 | 731 | 251375 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 749 | 749 | 251374 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 763 | 763 | 251373 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 22831 | 22831 | 251116 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 20 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 22828 | 22828 | 251115 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 19 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 22839 | 22839 | 251114 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 16 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 22833 | 22833 | 251113 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 15 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 22838 | 22838 | 251111 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 22823 | 22823 | 251110 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 22825 | 22825 | 251109 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 22832 | 22832 | 251108 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 22840 | 22840 | 251107 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1700X Quesada Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 157626 | 157626 | 251106 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6300x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5987426.0529 | 2112570.9396 | 37.779990741259 | -122.48712729528201 | (37.779990741259, -122.487127295282) | |||
| 40342 | 40342 | 251093 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6100x Geary Blvd | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5987925.4225 | 2112589.2174 | 37.780070032325 | -122.485401115216 | (37.780070032325, -122.485401115216) | |||
| 177329 | 177329 | 251092 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6100x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5988013.9609 | 2112592.2358 | 37.780083477756705 | -122.485095046206 | (37.7800834777567, -122.485095046206) | |||
| 150851 | 150851 | 251082 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5600x Geary Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5989477.5192 | 2112643.2957 | 37.7803088175248 | -122.480035730601 | (37.7803088175248, -122.480035730601) | |||
| 44761 | 44761 | 251081 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 5600x Geary Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 5989538.2764 | 2112645.9841 | 37.7803197290205 | -122.479825742455 | (37.7803197290205, -122.479825742455) | |||
| 151880 | 151880 | 251078 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5100x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5991099.7276 | 2112702.723 | 37.7805661077577 | -122.474428154783 | (37.7805661077577, -122.474428154783) | |||
| 44686 | 44686 | 251075 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5100x Geary Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990994.9145 | 2112700.954 | 37.7805551774565 | -122.47479062026899 | (37.7805551774565, -122.474790620269) | |||
| 175283 | 175283 | 251074 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5991352.6942 | 2112710.2412 | 37.7806014035471 | -122.473553580301 | (37.7806014035471, -122.473553580301) | |||
| 74409 | 74409 | 251072 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 10ft | 5990697.77 | 2112688.192 | 37.7805029132293 | -122.475817641236 | (37.7805029132293, -122.475817641236) | |||
| 172638 | 172638 | 251071 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5200x Geary Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990727.8797 | 2112689.8051 | 37.7805090880033 | -122.47571359647101 | (37.7805090880033, -122.475713596471) | |||
| 173206 | 173206 | 251070 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5200x Geary Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990754.7634 | 2112689.2674 | 37.7805091701663 | -122.47562055473499 | (37.7805091701663, -122.475620554735) | |||
| 32868 | 32868 | 251069 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5990794.5513 | 2112690.3427 | 37.7805144291466 | -122.47548298954099 | (37.7805144291466, -122.475482989541) | |||
| 60953 | 60953 | 251054 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 6000x Geary Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5988209.3153 | 2112595.4218 | 37.7801036030677 | -122.48441946896601 | (37.7801036030677, -122.484419468966) | |||
| 166322 | 166322 | 251051 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5900x Geary Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5988530.6021 | 2112606.8245 | 37.780153615018705 | -122.48330884168699 | (37.7801536150187, -122.483308841687) | |||
| 187052 | 187052 | 251050 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 5800x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 10ft | 5988878.2157 | 2112618.8979 | 37.780206989324796 | -122.48210718666901 | (37.7802069893248, -122.482107186669) | |||
| 41989 | 41989 | 251049 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700x Geary Blvd | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 10ft | 5989182.8738 | 2112626.0902 | 37.7802444522785 | -122.481053773582 | (37.7802444522785, -122.481053773582) | |||
| 34570 | 34570 | 251048 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5700x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5989255.4598 | 2112633.0799 | 37.7802678632993 | -122.480803179963 | (37.7802678632993, -122.480803179963) | |||
| 149750 | 149750 | 251044 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5600x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5989568.3861 | 2112643.8334 | 37.7803155729867 | -122.47972142279801 | (37.7803155729867, -122.479721422798) | |||
| 176711 | 176711 | 251042 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5500x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5989852.8157 | 2112655.9311 | 37.7803653089721 | -122.47873834484899 | (37.7803653089721, -122.478738344849) | |||
| 178472 | 178472 | 251037 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317x Geary Blvd | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990398.0172 | 2112670.1794 | 37.780436072061896 | -122.476853300249 | (37.7804360720619, -122.476853300249) | |||
| 158594 | 158594 | 251036 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317x Geary Blvd | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990401.2433 | 2112674.4808 | 37.780448069653296 | -122.47684245414699 | (37.7804480696533, -122.476842454147) | |||
| 74413 | 74413 | 251035 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5317x Geary Blvd | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990415.7605 | 2112675.5562 | 37.7804518645045 | -122.47679231146002 | (37.7804518645045, -122.47679231146) | |||
| 47168 | 47168 | 251029 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5991370.3842 | 2112709.3567 | 37.7805999993895 | -122.473492318223 | (37.7805999993895, -122.473492318223) | |||
| 76481 | 76481 | 251028 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5000x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 10ft | 5991390.9488 | 2112709.5778 | 37.780601797334704 | -122.47342119229799 | (37.7806017973347, -122.473421192298) | |||
| 167379 | 167379 | 251026 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5000x Geary Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 10ft | 5991422.3485 | 2112710.0201 | 37.780604829996 | -122.47331259909599 | (37.780604829996, -122.473312599096) | |||
| 67631 | 67631 | 251025 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5000x Geary Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 10ft | 5991443.5764 | 2112711.3468 | 37.7806097019127 | -122.47323925917101 | (37.7806097019127, -122.473239259171) | |||
| 47826 | 47826 | 251024 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5000x Geary Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 10ft | 5991467.9002 | 2112710.9046 | 37.7806098961229 | -122.473155080103 | (37.7806098961229, -122.473155080103) | |||
| 152127 | 152127 | 251023 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5991490.4549 | 2112712.2313 | 37.780614844759995 | -122.473077150172 | (37.78061484476, -122.473077150172) | |||
| 69767 | 69767 | 251022 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5991511.6828 | 2112712.2313 | 37.7806160737768 | -122.473003713445 | (37.7806160737768, -122.473003713445) | |||
| 32237 | 32237 | 250565 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6300x Geary Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5987286.538 | 2112566.9152 | 37.7799715553521 | -122.48760963785601 | (37.7799715553521, -122.487609637856) | |||
| 169010 | 169010 | 250145 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2550x Lyon St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 5999218.1379 | 2117651.88833 | 37.794622229397 | -122.44669902475799 | (37.794622229397, -122.446699024758) | ||||
| 153227 | 153227 | 250144 | DPW Maintained 3 | Magnolia x soulangiana :: Saucer Magnolia 92 | 2550x Lyon St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 5999230.56416 | 2117643.35138 | 37.794599499022105 | -122.446655413925 | (37.7945994990221, -122.446655413925) | ||||
| 187917 | 187917 | 250143 | DPW Maintained 3 | Magnolia x soulangiana :: Saucer Magnolia 92 | 2550x Lyon St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 5999225.81293 | 2117634.10371 | 37.7945738359766 | -122.446671188041 | (37.7945738359766, -122.446671188041) | ||||
| 24029 | 24029 | 250142 | DPW Maintained 3 | Magnolia spp :: Magnolia 89 | 2550x Lyon St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 5999229.6006 | 2117622.80882 | 37.7945430395703 | -122.44665726921801 | (37.7945430395703, -122.446657269218) | ||||
| 162948 | 162948 | 250141 | DPW Maintained 3 | Acer x freemanii :: Freeman Maple 265 | 2550x Lyon St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 5999216.75628 | 2117624.1444599996 | 37.79454597318011 | -122.446701808162 | (37.7945459731801, -122.446701808162) | ||||
| 151769 | 151769 | 250140 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 2550x Lyon St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5999207.82154 | 2117620.0573299997 | 37.7945342406205 | -122.446732429154 | (37.7945342406205, -122.446732429154) | ||||
| 164446 | 164446 | 250139 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2550x Lyon St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 5999209.46456 | 2117608.80739 | 37.794503445131 | -122.446725934276 | (37.794503445131, -122.446725934276) | ||||
| 29906 | 29906 | 250138 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 2550x Lyon St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 101 | 5999227.62567 | 2117605.22496 | 37.7944946461503 | -122.446662836939 | (37.7944946461503, -122.446662836939) | ||||
| 181589 | 181589 | 250137 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 2550x Lyon St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5999214.14671 | 2117588.9485299997 | 37.7944491854404 | -122.44670830396002 | (37.7944491854404, -122.44670830396) | ||||
| 41136 | 41136 | 250136 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 2550x Lyon St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 100 | 5999230.194080001 | 2117561.109 | 37.794373662156296 | -122.446650774326 | (37.7943736621563, -122.446650774326) | ||||
| 25604 | 25604 | 250134 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 2550x Lyon St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5999224.86929 | 2117537.18532 | 37.7943076699218 | -122.446667476532 | (37.7943076699218, -122.446667476532) | ||||
| 59302 | 59302 | 250133 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 2550x Lyon St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5999242.46646 | 2117532.2796099996 | 37.7942952053215 | -122.446606235406 | (37.7942952053215, -122.446606235406) | ||||
| 179912 | 179912 | 249490 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500x Van Ness Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6006241.6595 | 2115852.2639200003 | 37.7900796134287 | -122.42226876779101 | (37.7900796134287, -122.422268767791) | ||||
| 111911 | 111911 | 249489 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500x Van Ness Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6006246.93776 | 2115807.86331 | 37.7899579981201 | -122.422247349544 | (37.7899579981201, -122.422247349544) | ||||
| 67093 | 67093 | 249488 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1500x Van Ness Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6006252.337669999 | 2115769.3960599997 | 37.7898526811986 | -122.422225932188 | (37.7898526811986, -122.422225932188) | ||||
| 68645 | 68645 | 249487 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6006262.64335 | 2115713.0194599996 | 37.789698466352704 | -122.42218626847901 | (37.7896984663527, -122.422186268479) | ||||
| 59551 | 59551 | 249480 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1300x Van Ness Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6006341.46577 | 2115150.70304 | 37.788158930442705 | -122.421873590397 | (37.7881589304427, -122.421873590397) | ||||
| 180628 | 180628 | 249479 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1300x Van Ness Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6006342.53317 | 2115134.23147 | 37.7881137637835 | -122.42186872687799 | (37.7881137637835, -122.421868726878) | ||||
| 154476 | 154476 | 249478 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1300x Van Ness Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6006350.91475 | 2115079.54882 | 37.7879640914292 | -122.421835842261 | (37.7879640914292, -122.421835842261) | ||||
| 135502 | 135502 | 249477 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1300x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6006355.55828 | 2115049.12823 | 37.7878808258785 | -122.421817614792 | (37.7878808258785, -122.421817614792) | ||||
| 186488 | 186488 | 249476 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Van Ness Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6006383.25331 | 2114827.68427 | 37.78727435725771 | -122.421706060208 | (37.7872743572577, -122.421706060208) | ||||
| 49786 | 49786 | 249475 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Van Ness Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6006389.52859 | 2114780.4065099997 | 37.7871448980627 | -122.421680989782 | (37.7871448980627, -122.421680989782) | ||||
| 35652 | 35652 | 249474 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1200x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6006395.0323 | 2114736.35179 | 37.7870242450239 | -122.421658817911 | (37.7870242450239, -122.421658817911) | ||||
| 169889 | 169889 | 249473 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1100x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6006432.644069999 | 2114489.3949 | 37.7863482830936 | -122.42151114382901 | (37.7863482830936, -122.421511143829) | ||||
| 25183 | 25183 | 249466 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900x Van Ness Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6006522.49711 | 2113836.87509 | 37.7845616899264 | -122.421153924138 | (37.7845616899264, -122.421153924138) | ||||
| 73439 | 73439 | 249465 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Van Ness Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6006528.896380001 | 2113762.4002 | 37.78435756088879 | -122.421126494805 | (37.7843575608888, -122.421126494805) | ||||
| 35512 | 35512 | 249464 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Van Ness Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6006534.583819999 | 2113721.77463 | 37.7842463336479 | -122.421103932595 | (37.7842463336479, -122.421103932595) | ||||
| 37159 | 37159 | 249463 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6006539.42856 | 2113694.50869 | 37.7841717411666 | -122.421085234814 | (37.7841717411666, -122.421085234814) | ||||
| 163293 | 163293 | 248777 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Lyell St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 10ft | 6002988.77776 | 2095086.3960799999 | 37.7328775268597 | -122.43203996838699 | (37.7328775268597, -122.432039968387) | |||
| 188426 | 188426 | 248776 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Lyell St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 10ft | 6002998.16884 | 2095083.8511700002 | 37.73287107152721 | -122.43200731937999 | (37.7328710715272, -122.43200731938) | |||
| 53230 | 53230 | 248775 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Lyell St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6002997.286669999 | 2095073.79392 | 37.732843406592295 | -122.432009651347 | (37.7328434065923, -122.432009651347) | |||
| 135595 | 135595 | 248774 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Lyell St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6003001.138169999 | 2095064.3103599998 | 37.7328175852443 | -122.43199565878 | (37.7328175852443, -122.43199565878) | |||
| 63738 | 63738 | 248650 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2x Lyell St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6002998.47059 | 2095072.4374099998 | 37.732839749044 | -122.432005461406 | (37.732839749044, -122.432005461406) | |||
| 180124 | 180124 | 248649 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2x Lyell St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6002995.03876 | 2095080.26155 | 37.732861037793 | -122.43201788462 | (37.732861037793, -122.43201788462) | ||||
| 39338 | 39338 | 248648 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2x Lyell St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6002994.42779 | 2095088.08837 | 37.7328824938235 | -122.432020555603 | (37.7328824938235, -122.432020555603) | ||||
| 187741 | 187741 | 248647 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2x Lyell St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6002988.020959999 | 2095088.4577900001 | 37.73288314494071 | -122.432042732011 | (37.7328831449407, -122.432042732011) | ||||
| 151449 | 151449 | 247579 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 300x Alemany Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6008670.31016 | 2095309.15662 | 37.733809649895704 | -122.412413126286 | (37.7338096498957, -122.412413126286) | ||||
| 123415 | 123415 | 247578 | DPW Maintained 3 | Eucalyptus camaldulensis :: River Red Gum 340 | 300x Alemany Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 43 | 6008699.141969999 | 2095317.61632 | 37.733834496346 | -122.412314043462 | (37.733834496346, -122.412314043462) | ||||
| 182720 | 182720 | 247577 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 300x Alemany Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 44 | 6008700.9232 | 2095336.3735 | 37.7338860994661 | -122.41230921050501 | (37.7338860994661, -122.412309210505) | ||||
| 136198 | 136198 | 247576 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 350x Alemany Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6008435.75806 | 2095170.56175 | 37.733415932988 | -122.413214248635 | (37.733415932988, -122.413214248635) | ||||
| 52253 | 52253 | 247575 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 350x Alemany Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6008404.3383 | 2095155.19461 | 37.7333719741436 | -122.413321789588 | (37.7333719741436, -122.413321789588) | ||||
| 151195 | 151195 | 247574 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 350x Alemany Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6008213.28818 | 2095041.8138700002 | 37.7330499269008 | -122.413974287302 | (37.7330499269008, -122.413974287302) | ||||
| 138011 | 138011 | 247573 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 350x Alemany Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6008162.04858 | 2094997.2690700002 | 37.7329247385863 | -122.41414828632901 | (37.7329247385863, -122.414148286329) | ||||
| 163348 | 163348 | 247572 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 350x Alemany Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6008135.46244 | 2094979.0190299999 | 37.7328731345802 | -122.414238911006 | (37.7328731345802, -122.414238911006) | ||||
| 178221 | 178221 | 247571 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 350x Alemany Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6008108.27012 | 2094965.3059 | 37.732833953824205 | -122.414331952177 | (37.7328339538242, -122.414331952177) | ||||
| 159986 | 159986 | 247038 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 550x Valley St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6002247.5223900005 | 2099161.75856 | 37.7440254762006 | -122.434894020862 | (37.7440254762006, -122.434894020862) | ||||
| 45496 | 45496 | 247037 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 550x Valley St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6002254.50848 | 2099154.508 | 37.744005964510606 | -122.434869346159 | (37.7440059645106, -122.434869346159) | ||||
| 152956 | 152956 | 247036 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 550x Valley St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6002256.51494 | 2099162.48937 | 37.7440279934038 | -122.434862978946 | (37.7440279934038, -122.434862978946) | ||||
| 174903 | 174903 | 247035 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 550x Valley St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6002263.72164 | 2099154.77603 | 37.7440072235471 | -122.434837508343 | (37.7440072235471, -122.434837508343) | ||||
| 150595 | 150595 | 247034 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 550x Valley St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6002282.13399 | 2099154.62459 | 37.744007853087204 | -122.434773831861 | (37.7440078530872, -122.434773831861) | ||||
| 31162 | 31162 | 247033 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 550x Valley St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6002285.13208 | 2099166.02387 | 37.7440393230544 | -122.434764280156 | (37.7440393230544, -122.434764280156) |
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");