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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3 | 3 | 119263 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 495X Lakeshore Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 10x30 | |||||||||
| 1098 | 1098 | 251438 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501X Santiago St | 1 | 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 | ||||||||||
| 22828 | 22828 | 251115 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 19 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 22831 | 22831 | 251116 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 20 | 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 | ||||||||||
| 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 | ||||||||||
| 22839 | 22839 | 251114 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 16 | 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 | ||||||||||
| 77799 | 77799 | 105836 | DPW Maintained 3 | Araucaria heterophylla :: Norfolk Island Pine 24 | 2100X SLOAT BLVD | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5984309.0 | 2095832.0 | 37.733848030924 | -122.49667476772 | (37.733848030924, -122.49667476772) | ||||
| 144906 | 144906 | 105837 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100X SLOAT BLVD | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5984309.0 | 2095832.0 | 37.733848030924 | -122.49667476772 | (37.733848030924, -122.49667476772) | ||||
| 181676 | 181676 | 186658 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1401 Sunset Blvd | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 0ft | 5984710.2715 | 2105562.1346 | 37.7605878254343 | -122.49600505239401 | (37.7605878254343, -122.496005052394) | |||
| 46600 | 46600 | 116804 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 131 LAKESHORE DR | 1 | Median : Yard 3 | Landscaping 2 | DPW 2 | 10x100 | 5984782.0 | 2094243.0 | 37.7295127607338 | -122.494922366174 | (37.7295127607338, -122.494922366174) | ||||
| 141156 | 141156 | 104399 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2440X 37th Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5984875.46821 | 2098521.80546 | 37.7412666886784 | -122.49491460561501 | (37.7412666886784, -122.494914605615) | |||||
| 92261 | 92261 | 117511 | DPW Maintained 3 | Shrub :: Shrub 98 | 2634 37TH AVE | 1 | Median : Yard 3 | Landscaping 2 | DPW 2 | 20 | 3x3 | 5984921.0 | 2097163.0 | 37.737538439530795 | -122.49465702329901 | (37.7375384395308, -122.494657023299) | |||
| 1052 | 1052 | 187279 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 2401 Sunset Blvd | 62 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 0ft | 5984952.4466 | 2098301.7622 | 37.7406670151021 | -122.494632227246 | (37.7406670151021, -122.494632227246) | |||
| 1041 | 1041 | 187245 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 2401 Sunset Blvd | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 0ft | 5984968.6731 | 2098517.9713 | 37.741261616740005 | -122.494592058244 | (37.74126161674, -122.494592058244) | |||
| 141372 | 141372 | 104398 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 3525X Ulloa St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | 5985120.1668300005 | 2098189.34613 | 37.7403681660846 | -122.494044040088 | (37.7403681660846, -122.494044040088) | ||||
| 109166 | 109166 | 103947 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2363X 36th Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5985162.60331 | 2099213.25819 | 37.74318203563929 | -122.49397275511299 | (37.7431820356393, -122.493972755113) | ||||
| 1022 | 1022 | 186874 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 0ft | 5985204.8462 | 2096382.2812 | 37.7354114037883 | -122.493618136413 | (37.7354114037883, -122.493618136413) | |||
| 1059 | 1059 | 186952 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 0ft | 5985204.8226 | 2096075.4539 | 37.734568936321295 | -122.493595616872 | (37.7345689363213, -122.493595616872) | |||
| 1039 | 1039 | 186954 | DPW Maintained 3 | Tree(s) :: 17 | 2800 Sunset Blvd | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 0ft | 5985211.8854 | 2096092.27 | 37.734615522028896 | -122.493572437422 | (37.7346155220289, -122.493572437422) | |||
| 144456 | 144456 | 108046 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2901X SUNSET BLVD ON RAMP | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 99 | 5985273.0 | 2095807.0 | 37.733835821368295 | -122.493340136435 | (37.7338358213683, -122.493340136435) | ||||
| 118289 | 118289 | 114805 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 210X GELLERT DR | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 3x3 | 5985389.0 | 2094462.0 | 37.73014959142171 | -122.492840061243 | (37.7301495914217, -122.492840061243) | |||
| 106620 | 106620 | 108045 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2901X SUNSET BLVD OFF RAMP | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 5985539.0 | 2095817.0 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | ||||
| 113179 | 113179 | 108043 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2901X SUNSET BLVD OFF RAMP | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 5985539.0 | 2095817.0 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | ||||
| 128096 | 128096 | 108044 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2901X SUNSET BLVD OFF RAMP | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 99 | 5985539.0 | 2095817.0 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | ||||
| 37625 | 37625 | 119298 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 6700x Geary Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 5986043.64284 | 2112521.4673099997 | 37.77977419975021 | -122.491905961239 | (37.7797741997502, -122.491905961239) | ||||
| 39703 | 39703 | 119297 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6700x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5986078.135009999 | 2112521.2781700003 | 37.7797756964263 | -122.491786625446 | (37.7797756964263, -122.491786625446) | ||||
| 132349 | 132349 | 119288 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6600x Geary Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 5986322.21079 | 2112527.80703 | 37.7798078851153 | -122.490942752545 | (37.7798078851153, -122.490942752545) | ||||
| 39141 | 39141 | 119936 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6500x Geary Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 5986709.57611 | 2112539.19718 | 37.7798617820891 | -122.489603541423 | (37.7798617820891, -122.489603541423) | |||
| 178177 | 178177 | 119934 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6400x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 5986945.272609999 | 2112550.81697 | 37.7799074444019 | -122.488789028183 | (37.7799074444019, -122.488789028183) | ||||
| 175125 | 175125 | 119933 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6400x Geary Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5986970.48357 | 2112551.91695 | 37.7799119358722 | -122.48870189430001 | (37.7799119358722, -122.4887018943) | ||||
| 156604 | 156604 | 119932 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6400x Geary Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 5987027.58334 | 2112559.15504 | 37.7799351415473 | -122.488504895539 | (37.7799351415473, -122.488504895539) | ||||
| 68246 | 68246 | 119931 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 6400x Geary Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 5987060.468230001 | 2112560.63712 | 37.779941129697 | -122.4883912425 | (37.779941129697, -122.4883912425) | ||||
| 75559 | 75559 | 119930 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6400x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5987085.6039 | 2112558.1946400004 | 37.779935889891895 | -122.48830410860799 | (37.7799358898919, -122.488304108608) | ||||
| 49072 | 49072 | 119929 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6400x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 5987119.54861 | 2112558.01872 | 37.779937387281706 | -122.48818666733801 | (37.7799373872817, -122.488186667338) | ||||
| 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) | |||
| 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) | |||
| 82353 | 82353 | 109678 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | |||||
| 83234 | 83234 | 109676 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | |||||
| 109683 | 109683 | 109675 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | |||||
| 110858 | 110858 | 104466 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | ||||
| 141517 | 141517 | 109677 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | |||||
| 146161 | 146161 | 109674 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 200X VIDAL DR | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 5987624.0 | 2090693.0 | 37.719931328083206 | -122.48483708629801 | (37.7199313280832, -122.484837086298) | |||||
| 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) | |||
| 89670 | 89670 | 114428 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 34x HIGUERA AVE | 2 | Median : Yard 3 | Tree 1 | Private 1 | 56 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 109545 | 109545 | 111090 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 28x HIGUERA AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 3 | Permit Number 777485 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||
| 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) | |||
| 116741 | 116741 | 97397 | DPW Maintained 3 | Butia capitata :: Pindo Palm 149 | 1203X Sunset Blvd | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 5989104.6 | 2108557.5 | 37.7690686805765 | -122.48102656954599 | (37.7690686805765, -122.481026569546) | |||||
| 128569 | 128569 | 97396 | DPW Maintained 3 | Araucaria heterophylla :: Norfolk Island Pine 24 | 1203X Sunset Blvd | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 5989104.6 | 2108557.5 | 37.7690686805765 | -122.48102656954599 | (37.7690686805765, -122.481026569546) | |||||
| 142749 | 142749 | 97395 | DPW Maintained 3 | Araucaria heterophylla :: Norfolk Island Pine 24 | 1203X Sunset Blvd | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 5989104.6 | 2108557.5 | 37.7690686805765 | -122.48102656954599 | (37.7690686805765, -122.481026569546) | |||||
| 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) | |||
| 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) | |||
| 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) | |||
| 110134 | 110134 | 117310 | Permitted Site 1 | Tree(s) :: 17 | 126X Juan Bautista Cir | 1 | Median : Yard 3 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | 10x10 | Permit Number 777998 | 5989282.4 | 2089642.3 | 37.7171428191075 | -122.479027821944 | (37.7171428191075, -122.479027821944) | |
| 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) | |||
| 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) | |||
| 85176 | 85176 | 104920 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 750 Gonzalez Dr | 1 | Median : Yard 3 | Tree 1 | Private 1 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | |||||
| 101258 | 101258 | 104921 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 750 Gonzalez Dr | 2 | Median : Yard 3 | Tree 1 | Private 1 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | |||||
| 111624 | 111624 | 104922 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 750 Gonzalez Dr | 3 | Median : Yard 3 | Tree 1 | Private 1 | missing? | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | ||||
| 128606 | 128606 | 104928 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Gonzalez Dr | 3 | Median : Yard 3 | Tree 1 | Private 1 | 12 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | ||||
| 143894 | 143894 | 104927 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Gonzalez Dr | 2 | Median : Yard 3 | Tree 1 | Private 1 | 10 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | ||||
| 144760 | 144760 | 104926 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Gonzalez Dr | 1 | Median : Yard 3 | Tree 1 | Private 1 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | |||||
| 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) | |||
| 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) | |||
| 131175 | 131175 | 218283 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2x Sloat Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 5990775.7158 | 2095986.69925 | 37.7346495609245 | -122.474328895956 | (37.7346495609245, -122.474328895956) | ||||
| 45535 | 45535 | 211042 | DPW Maintained 3 | Pinus halepensis :: Allepo Pine 164 | 1050x Moraga St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 5990982.70719 | 2103833.6403200002 | 37.756207220509204 | -122.47418564296001 | (37.7562072205092, -122.47418564296) | |||
| 28868 | 28868 | 208175 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000x Lawton St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 9ft | 5991060.8036 | 2104516.28775 | 37.758086113802904 | -122.473965364836 | (37.7580861138029, -122.473965364836) | |||
| 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) | |||
| 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) | |||
| 147460 | 147460 | 217803 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2x Sloat Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 5991018.47185 | 2095992.29774 | 37.734678993934494 | -122.473490022742 | (37.7346789939345, -122.473490022742) | ||||
| 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) | |||
| 185691 | 185691 | 217802 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2x Sloat Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5991046.80022 | 2095992.48375 | 37.734681145124505 | -122.47339209648001 | (37.7346811451245, -122.47339209648) | ||||
| 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) | |||
| 19618 | 19618 | 102860 | DPW Maintained 3 | Calocedrus decurrens :: Incense Cedar 177 | 10X CRANLEIGH DR | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 03/06/2013 12:00:00 AM | 6 | 5991339.0 | 2095700.0 | 37.7338949747581 | -122.472360557436 | (37.7338949747581, -122.472360557436) | |||
| 127178 | 127178 | 108238 | Undocumented 2 | Tree(s) :: 17 | 764x JUNIPERO SERRA BLVD | 1 | Median : Yard 3 | Tree 1 | Private 1 | 5991289.6 | 2092496.8 | 37.7250969308873 | -122.47229792145599 | (37.7250969308873, -122.472297921456) | |||||
| 53598 | 53598 | 95407 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2X Cranleigh Dr | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 80 | 5991370.3 | 2095943.7 | 37.734565924896394 | -122.472270103664 | (37.7345659248964, -122.472270103664) | ||||
| 79067 | 79067 | 116722 | DPW Maintained 3 | Calocedrus decurrens :: Incense Cedar 177 | 10X CRANLEIGH DR | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 3x3 | 5991371.0 | 2095902.0 | 37.7344514677467 | -122.472264644795 | (37.7344514677467, -122.472264644795) | |||
| 180863 | 180863 | 218285 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Junipero Serra Frontage West | 0 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 5991436.68421 | 2095414.89925 | 37.7331178131424 | -122.47200206387 | (37.7331178131424, -122.47200206387) | ||||
| 182431 | 182431 | 218284 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50x Junipero Serra Frontage West | 0 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5991438.8932 | 2095398.7783700002 | 37.7330736770928 | -122.4719932523 | (37.7330736770928, -122.4719932523) | ||||
| 158348 | 158348 | 217821 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1x Junipero Serra Blvd | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 65 | 5991615.013669999 | 2095586.81694 | 37.7336001735084 | -122.471398059368 | (37.7336001735084, -122.471398059368) | ||||
| 181805 | 181805 | 217819 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1x Junipero Serra Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | 5991622.365809999 | 2095679.35409 | 37.733854682528204 | -122.471379381376 | (37.7338546825282, -122.471379381376) |
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");