Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: PlantType, qCaretaker, PlantDate, PlotSize, PermitNotes
qLegalStatus ✖
Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3018 | 3018 | 128709 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4x Columbus Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 19 | Width 9ft | 6011726.08303 | 2117794.9108 | 37.795721488711294 | -122.403429729102 | (37.7957214887113, -122.403429729102) | |||
19556 | 19556 | 99478 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 650X Miramar Ave | 4 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.45808530293199 | (37.728535605791, -122.458085302932) | |
81264 | 81264 | 99456 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Miramar Ave | 6 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995388.7 | 2092398.7 | 37.7250639553871 | -122.45812076272101 | (37.7250639553871, -122.458120762721) | |
85151 | 85151 | 99471 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Miramar Ave | 7 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995435.2 | 2093399.0 | 37.727813210556704 | -122.458032376835 | (37.7278132105567, -122.458032376835) | |
87236 | 87236 | 99491 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Miramar Ave | 5 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | |
98576 | 98576 | 99490 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Miramar Ave | 4 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | |
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) | |
123683 | 123683 | 99488 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Miramar Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | |
138714 | 138714 | 99482 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Miramar Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | |
9919 | 9919 | 173741 | Undocumented 2 | Tree(s) :: 17 | 2500X Lyon St | 8 | Median : Yard 3 | Tree 1 | Private 1 | 01/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779102 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |
9921 | 9921 | 173736 | Undocumented 2 | Tree(s) :: 17 | 2500X Lyon St | 3 | Median : Yard 3 | Tree 1 | Private 1 | 01/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779102 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |
9923 | 9923 | 173740 | Undocumented 2 | Tree(s) :: 17 | 2500X Lyon St | 7 | Median : Yard 3 | Tree 1 | Private 1 | 3x3 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | ||||
9924 | 9924 | 173738 | Undocumented 2 | Tree(s) :: 17 | 2500X Lyon St | 5 | Median : Yard 3 | Tree 1 | Private 1 | 3x3 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | ||||
9925 | 9925 | 173735 | Undocumented 2 | Tree(s) :: 17 | 2500X Lyon St | 2 | Median : Yard 3 | Tree 1 | Private 1 | 01/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779102 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |
9926 | 9926 | 173734 | Undocumented 2 | Tree(s) :: 17 | 2500X Lyon St | 1 | Median : Yard 3 | Tree 1 | Private 1 | 01/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779102 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |
9927 | 9927 | 173742 | Undocumented 2 | Tree(s) :: 17 | 2500X Lyon St | 9 | Median : Yard 3 | Tree 1 | Private 1 | 01/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779102 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |
9929 | 9929 | 173737 | Undocumented 2 | Tree(s) :: 17 | 2500X Lyon St | 4 | Median : Yard 3 | Tree 1 | Private 1 | 01/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779102 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |
9931 | 9931 | 173739 | Undocumented 2 | Tree(s) :: 17 | 2500X Lyon St | 6 | Median : Yard 3 | Tree 1 | Private 1 | 01/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779102 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |
13314 | 13314 | 187669 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 554 Valley St | 1 | Median : Yard 3 | Tree 1 | Private 1 | 6002324.0 | 2099197.0 | 37.7441265828549 | -122.434632098307 | (37.7441265828549, -122.434632098307) | |||||
46910 | 46910 | 116450 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299X Cashmere St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6016873.48707 | 2095860.59847 | 37.735780731778895 | -122.384090400246 | (37.7357807317789, -122.384090400246) | ||||
76136 | 76136 | 111405 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 10 | Median : Yard 3 | Tree 1 | Private 1 | 50 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | ||||
82501 | 82501 | 111413 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 8 | Median : Yard 3 | Tree 1 | Private 1 | 42 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
83073 | 83073 | 109202 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
83529 | 83529 | 111403 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 8 | Median : Yard 3 | Tree 1 | Private 1 | 28 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | ||||
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) | |||||
85810 | 85810 | 109204 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
86474 | 86474 | 109199 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
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) | ||||
89696 | 89696 | 111418 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 200x SAN MARCOS AVE | 3 | Median : Yard 3 | Tree 1 | Private 1 | 5 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
89796 | 89796 | 111400 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 5 | Median : Yard 3 | Tree 1 | Private 1 | 54 | Permit Number 779360 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | |||
91226 | 91226 | 109209 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2401x CASTRO ST | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
93919 | 93919 | 96976 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 390X Filbert St | 1 | Median : Yard 3 | Tree 1 | Rec/Park 3 | 28 | 6010951.1 | 2119992.4 | 37.8017119430502 | -122.406266229116 | (37.8017119430502, -122.406266229116) | ||||
95691 | 95691 | 111404 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 9 | Median : Yard 3 | Tree 1 | Private 1 | 48 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | ||||
95918 | 95918 | 111398 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 3 | Median : Yard 3 | Tree 1 | Private 1 | 4 | Permit Number 779360 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | |||
95953 | 95953 | 111416 | Undocumented 2 | Ulmus spp :: Elm Spp 215 | 200x SAN MARCOS AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 24 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
96206 | 96206 | 111407 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 2 | Median : Yard 3 | Tree 1 | Private 1 | 12 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
98788 | 98788 | 111423 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200x SAN MARCOS AVE | 8 | Median : Yard 3 | Tree 1 | Private 1 | 50 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
99310 | 99310 | 111417 | Undocumented 2 | Ulmus spp :: Elm Spp 215 | 200x SAN MARCOS AVE | 2 | Median : Yard 3 | Tree 1 | Private 1 | 24 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
99590 | 99590 | 111406 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 40 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
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) | |||||
103385 | 103385 | 111415 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 10 | Median : Yard 3 | Tree 1 | Private 1 | 48 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
103516 | 103516 | 111419 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200x SAN MARCOS AVE | 4 | Median : Yard 3 | Tree 1 | Private 1 | 10 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
103771 | 103771 | 111426 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 200x SAN MARCOS AVE | 11 | Median : Yard 3 | Tree 1 | Private 1 | 6 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
104683 | 104683 | 111397 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 2 | Median : Yard 3 | Tree 1 | Private 1 | 36 | Permit Number 779360 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | |||
105632 | 105632 | 110346 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 3x3 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | ||||
105675 | 105675 | 109208 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
106027 | 106027 | 111425 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 200x SAN MARCOS AVE | 10 | Median : Yard 3 | Tree 1 | Private 1 | 16 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
106876 | 106876 | 111408 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 3 | Median : Yard 3 | Tree 1 | Private 1 | 15 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
107740 | 107740 | 107644 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1400x KIRKWOOD AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 6015822.8 | 2096363.1 | 37.7371023539668 | -122.38775811873998 | (37.7371023539668, -122.38775811874) | |||||
108934 | 108934 | 113438 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 180x LOWER TER | Median : Yard 3 | Tree 1 | Private 1 | 22 | 3x3 | 6000120.0 | 2106246.0 | 37.7633560547765 | -122.44275907578 | (37.7633560547765, -122.44275907578) | ||||
109414 | 109414 | 111414 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 9 | Median : Yard 3 | Tree 1 | Private 1 | 42 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
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) | ||
109648 | 109648 | 111396 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 53 | Permit Number 779360 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | |||
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) | ||||
111907 | 111907 | 111427 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 200x SAN MARCOS AVE | 12 | Median : Yard 3 | Tree 1 | Private 1 | 20 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
112509 | 112509 | 111420 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200x SAN MARCOS AVE | 5 | Median : Yard 3 | Tree 1 | Private 1 | 15 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
113148 | 113148 | 104375 | Undocumented 2 | Tree(s) :: 17 | 30 GARDENSIDE DR | 1 | Median : Yard 3 | Landscaping 2 | Private 1 | 50x50 | 5999465.0 | 2102094.0 | 37.7519183246276 | -122.444726043725 | (37.7519183246276, -122.444726043725) | ||||
114353 | 114353 | 111399 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 4 | Median : Yard 3 | Tree 1 | Private 1 | 48 | Permit Number 779360 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | |||
118269 | 118269 | 109197 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | ||||
121319 | 121319 | 111411 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 6 | Median : Yard 3 | Tree 1 | Private 1 | 12 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
121346 | 121346 | 111410 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 5 | Median : Yard 3 | Tree 1 | Private 1 | 10 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
121585 | 121585 | 111422 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200x SAN MARCOS AVE | 7 | Median : Yard 3 | Tree 1 | Private 1 | 48 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
122322 | 122322 | 105909 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1864X 14TH AVE | 1 | Median : Yard 3 | Tree 1 | Rec/Park 3 | 14 | 5991829.0 | 2102804.0 | 37.7534290869332 | -122.47118388851999 | (37.7534290869332, -122.47118388852) | ||||
123260 | 123260 | 109205 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
123401 | 123401 | 109201 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
125797 | 125797 | 109198 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
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) | |||||
127394 | 127394 | 111402 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 7 | Median : Yard 3 | Tree 1 | Private 1 | 29 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | ||||
128009 | 128009 | 109203 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2401x CASTRO ST | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 6002698.0 | 2098487.0 | 37.7421983129634 | -122.43328816691401 | (37.7421983129634, -122.433288166914) | |||||
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) | ||||
133804 | 133804 | 111782 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299X Cashmere St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6016893.15772 | 2095859.5830599999 | 37.7357790311769 | -122.38402231977 | (37.7357790311769, -122.38402231977) | ||||
140384 | 140384 | 104978 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 66X San Lorenzo Way | 1 | Median : Yard 3 | Tree 1 | Private 1 | Permit Number 770332 | 5993690.5 | 2097533.7 | 37.7390656757525 | -122.46436386193301 | (37.7390656757525, -122.464363861933) | ||||
140697 | 140697 | 111409 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 4 | Median : Yard 3 | Tree 1 | Private 1 | 45 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
141717 | 141717 | 111239 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 399x LIBERTY ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 3x3 | 6003700.0 | 2103889.0 | 37.7570877346209 | -122.430208863755 | (37.7570877346209, -122.430208863755) | |||
142054 | 142054 | 111424 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200x SAN MARCOS AVE | 9 | Median : Yard 3 | Tree 1 | Private 1 | 12 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
142588 | 142588 | 104374 | Undocumented 2 | Tree(s) :: 17 | 22 GARDENSIDE DR | 1 | Median : Yard 3 | Landscaping 2 | Private 1 | 50x50 | 5999468.0 | 2101996.0 | 37.7516494117124 | -122.444708626009 | (37.7516494117124, -122.444708626009) | ||||
143022 | 143022 | 111421 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200x SAN MARCOS AVE | 6 | Median : Yard 3 | Tree 1 | Private 1 | 46 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
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) | ||||
144215 | 144215 | 116451 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 250X CASHMERE ST | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6016081.0 | 2096072.0 | 37.7363173516773 | -122.386845101275 | (37.7363173516773, -122.386845101275) | |||||
144513 | 144513 | 111401 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 50x SANTA RITA AVE | 6 | Median : Yard 3 | Tree 1 | Private 1 | 40 | 5993713.0 | 2100532.0 | 37.74729954942379 | -122.464503713167 | (37.7472995494238, -122.464503713167) | ||||
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) | |||||
145014 | 145014 | 111412 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 7 | Median : Yard 3 | Tree 1 | Private 1 | 36 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
3 | 3 | 119263 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 495X Lakeshore Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 10x30 | |||||||||
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) | |||||
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) | |||||
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) | |||||
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) | |||||
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) | |||||
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) | |||||
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) | |||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
1098 | 1098 | 251438 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501X Santiago St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
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) | ||||
3898 | 3898 | 212122 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995365.2918 | 2092257.6675200001 | 37.724675368963105 | -122.45819147914699 | (37.7246753689631, -122.458191479147) | ||||
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) | |||||
10203 | 10203 | 106598 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001X SAN JOSE AVE | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) |
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");