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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||||
| 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) | |
| 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) | ||||
| 79568 | 79568 | 116501 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 71X PARKRIDGE DR | 2 | Median : Yard 3 | Tree 1 | Private 1 | 40 | 3x3 | 5999012.0 | 2102131.0 | 37.751994056327 | -122.446295237287 | (37.751994056327, -122.446295237287) | |||
| 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) | |
| 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) | ||||
| 82835 | 82835 | 113195 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 699X Noe St | 2 | Median : Yard 3 | Tree 1 | Private 1 | 6003039.779709999 | 2104315.51778 | 37.7582214335608 | -122.432522620301 | (37.7582214335608, -122.432522620301) | |||||
| 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) | ||||
| 84421 | 84421 | 96975 | DPW Maintained 3 | Tree(s) :: 17 | 399X Filbert St | 4 | Median : Yard 3 | Tree 1 | Private 1 | 24 | 6010951.1 | 2119992.4 | 37.8017119430502 | -122.406266229116 | (37.8017119430502, -122.406266229116) | ||||
| 84668 | 84668 | 116500 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 71X PARKRIDGE DR | 1 | Median : Yard 3 | Tree 1 | Private 1 | 45 | 3x3 | 5999012.0 | 2102131.0 | 37.751994056327 | -122.446295237287 | (37.751994056327, -122.446295237287) | |||
| 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) | |
| 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) | |||||
| 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) | |
| 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) | |||
| 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) | ||||
| 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) | |
| 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) | |||||
| 101535 | 101535 | 116502 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 71X PARKRIDGE DR | 3 | Median : Yard 3 | Tree 1 | Private 1 | 28 | 3x3 | 5999012.0 | 2102131.0 | 37.751994056327 | -122.446295237287 | (37.751994056327, -122.446295237287) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 116375 | 116375 | 99101 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 55x Santa Monica Way | 1 | Median : Yard 3 | Tree 1 | Private 1 | 04/07/2012 12:00:00 AM | Permit Number 768464 | 5993693.6 | 2097654.3 | 37.739396991894104 | -122.464361897304 | (37.7393969918941, -122.464361897304) | |||
| 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) | ||||
| 121860 | 121860 | 102111 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 18 Saturn St | 1 | Median : Yard 3 | Tree 1 | Private 1 | 24 | 6000559.0 | 2106017.0 | 37.7627522940794 | -122.441224290546 | (37.7627522940794, -122.441224290546) | ||||
| 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) | |
| 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) | ||||
| 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) | ||||
| 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) | |
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 10408 | 10408 | 106060 | DPW Maintained 3 | Calocedrus decurrens :: Incense Cedar 177 | 12X Canyon Dr | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6003183.55845 | 2086355.5239400002 | 37.7089155261884 | -122.430743733243 | (37.7089155261884, -122.430743733243) | ||||
| 11046 | 11046 | 116538 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 3x3 | 6001578.1015800005 | 2088233.43486 | 37.7139807660769 | -122.436426724612 | (37.7139807660769, -122.436426724612) | |||
| 11659 | 11659 | 106061 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 12X Canyon Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 6003256.93175 | 2086330.4794599998 | 37.7088509162175 | -122.430488359046 | (37.7088509162175, -122.430488359046) | ||||
| 18076 | 18076 | 107933 | DPW Maintained 3 | Tree(s) :: 17 | 3098X Market St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5999920.0 | 2105144.0 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | |||||
| 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) | |||
| 22808 | 22808 | 195725 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 250x King St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 10ft | 6014714.95739 | 2111115.10019 | 37.7775467477219 | -122.39262009845 | (37.7775467477219, -122.39262009845) | |||
| 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 |
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");