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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 56600 | 56600 | 211076 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 700x Miramar Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 74 | 5995394.80602 | 2094076.5012 | 37.7296711442905 | -122.458221033586 | (37.7296711442905, -122.458221033586) | ||||
| 67961 | 67961 | 206836 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100x Idora Ave | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 66 | Width 9ft | 5995604.17085 | 2099350.4744700002 | 37.7441642119029 | -122.45787873812799 | (37.7441642119029, -122.457878738128) | |||
| 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) | ||||
| 187642 | 187642 | 206837 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100x Idora Ave | 25 | Median : Yard 3 | Tree 1 | DPW 2 | 63 | Width 9ft | 5995840.17489 | 2099294.03492 | 37.7440227989188 | -122.45705861128401 | (37.7440227989188, -122.457058611284) | |||
| 166635 | 166635 | 232588 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5200x Diamond Heights Blvd | 43 | Median : Yard 3 | Tree 1 | DPW 2 | 59 | 6001719.64568 | 2098775.96763 | 37.742936199339795 | -122.436691686488 | (37.7429361993398, -122.436691686488) | ||||
| 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) | ||||
| 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) | |||
| 64916 | 64916 | 193539 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 2x Dukes Ct | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 53 | 6016139.60304 | 2096356.71022 | 37.7371023529977 | -122.3866623318 | (37.7371023529977, -122.3866623318) | ||||
| 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) | |||
| 26953 | 26953 | 223749 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5200x Diamond Heights Blvd | 33 | Median : Yard 3 | Tree 1 | DPW 2 | 52 | 6001564.8370199995 | 2098920.55277 | 37.743324397105 | -122.43723732135099 | (37.743324397105, -122.437237321351) | ||||
| 55031 | 55031 | 233309 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200x Diamond Heights Blvd | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 52 | 6001152.90645 | 2099246.96263 | 37.744197216131 | -122.438685051778 | (37.744197216131, -122.438685051778) | ||||
| 102681 | 102681 | 206832 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 52 | Width 8ft | 5994051.70376 | 2101574.41752 | 37.750181282555 | -122.463408144182 | (37.750181282555, -122.463408144182) | |||
| 36932 | 36932 | 211104 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 5993600.40313 | 2100945.49901 | 37.7484284211296 | -122.464923087237 | (37.7484284211296, -122.464923087237) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 153783 | 153783 | 191723 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 900x Carolina St | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 6012476.48508 | 2103328.88343 | 37.7560429683291 | -122.39981689974701 | (37.7560429683291, -122.399816899747) | ||||
| 173688 | 173688 | 191721 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 1150x Tennessee St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 6015559.12531 | 2103608.85918 | 37.75698309171089 | -122.389175557402 | (37.7569830917109, -122.389175557402) | ||||
| 62551 | 62551 | 223750 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 5200x Diamond Heights Blvd | 48 | Median : Yard 3 | Tree 1 | DPW 2 | 49 | 6001781.7092699995 | 2098716.14984 | 37.7427754806136 | -122.436472807673 | (37.7427754806136, -122.436472807673) | ||||
| 43629 | 43629 | 211101 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | 5993549.05492 | 2100852.54328 | 37.7481702275711 | -122.465093896362 | (37.7481702275711, -122.465093896362) | ||||
| 56493 | 56493 | 211115 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | Width 8ft | 5994174.89833 | 2101193.52417 | 37.749142543105 | -122.46295450185801 | (37.749142543105, -122.462954501858) | |||
| 58702 | 58702 | 194289 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 38 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | 6014396.14271 | 2095264.76436 | 37.734007417094 | -122.39261394888901 | (37.734007417094, -122.392613948889) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 173233 | 173233 | 211130 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 36 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | Width 8ft | 5994106.02259 | 2101525.20056 | 37.7500492746747 | -122.46321673696 | (37.7500492746747, -122.46321673696) | |||
| 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) | ||||
| 180599 | 180599 | 191725 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 950x Kansas St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 46 | 6011608.2265 | 2103816.01851 | 37.75733209161471 | -122.40285390399201 | (37.7573320916147, -122.402853903992) | ||||
| 79476 | 79476 | 116530 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 745X SANCHEZ ST | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 45 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | ||||
| 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) | |||
| 95383 | 95383 | 104500 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 22 SATURN ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 45 | 6000539.0 | 2106092.0 | 37.762957086281396 | -122.441298844913 | (37.7629570862814, -122.441298844913) | ||||
| 130698 | 130698 | 234352 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 45 | 6004969.77736 | 2104678.02917 | 37.7593260612613 | -122.425873648056 | (37.7593260612613, -122.425873648056) | ||||
| 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) | ||||
| 34409 | 34409 | 211112 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 44 | Width 8ft | 5994184.95875 | 2101126.7807299998 | 37.748959862029096 | -122.46291487144501 | (37.7489598620291, -122.462914871445) | |||
| 42114 | 42114 | 212121 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2101x Monterey Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 44 | Width 10ft | 5991706.53339 | 2095446.31972 | 37.7332196973367 | -122.47107142020398 | (37.7332196973367, -122.471071420204) | |||
| 47477 | 47477 | 234367 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1650x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 44 | 6005309.50054 | 2098532.58451 | 37.7424712831236 | -122.424261641173 | (37.7424712831236, -122.424261641173) | ||||
| 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) | ||||
| 53815 | 53815 | 211102 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 43 | 5993572.08024 | 2100898.12462 | 37.7482967100214 | -122.465017586199 | (37.7482967100214, -122.465017586199) | ||||
| 55507 | 55507 | 191724 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 950x Kansas St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 43 | 6011608.5229400005 | 2103823.60133 | 37.7573529289142 | -122.402853412073 | (37.7573529289142, -122.402853412073) | ||||
| 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) | ||||
| 32328 | 32328 | 211103 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 42 | 5993592.96046 | 2100932.97127 | 37.7483935940092 | -122.464947913926 | (37.7483935940092, -122.464947913926) | ||||
| 37447 | 37447 | 220241 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 10x Benton Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 42 | 6004791.23434 | 2095030.3631099998 | 37.7328256962469 | -122.425804423654 | (37.7328256962469, -122.425804423654) | ||||
| 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) | ||||
| 101111 | 101111 | 106599 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 42 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 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) | ||||
| 36297 | 36297 | 211100 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 198x San Anselmo Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 41 | 5993653.9743 | 2096326.24073 | 37.735748188020395 | -122.464402505688 | (37.7357481880204, -122.464402505688) | ||||
| 37375 | 37375 | 211161 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Idora Ave | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 41 | Width 9ft | 5995684.4738300005 | 2099331.0800900003 | 37.7441155729727 | -122.45759966680599 | (37.7441155729727, -122.457599666806) | |||
| 177528 | 177528 | 211105 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 41 | 5993636.389719999 | 2101004.93506 | 37.748593692259895 | -122.464802962985 | (37.7485936922599, -122.464802962985) | ||||
| 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) | ||||
| 60973 | 60973 | 211136 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 45 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | Width 8ft | 5993981.68965 | 2101619.35066 | 37.750300623474295 | -122.463653516122 | (37.7503006234743, -122.463653516122) | |||
| 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) | |||
| 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) | ||||
| 104032 | 104032 | 98994 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 745X SANCHEZ ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | ||||
| 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) | ||||
| 129469 | 129469 | 101030 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1010X Portola Dr | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | ||||
| 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) | |||
| 163476 | 163476 | 212133 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Miramar Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 5995378.50307 | 2093028.5023400001 | 37.7267926554346 | -122.458201574049 | (37.7267926554346, -122.458201574049) | ||||
| 56699 | 56699 | 233312 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200x Diamond Heights Blvd | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 39 | 6001396.29408 | 2099056.86784 | 37.743689103685206 | -122.437829859455 | (37.7436891036852, -122.437829859455) | ||||
| 59175 | 59175 | 217814 | DPW Maintained 3 | Eucalyptus camaldulensis :: River Red Gum 340 | 1x Junipero Serra Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 39 | 5991642.1645 | 2095884.13354 | 37.734418100595995 | -122.47132584741001 | (37.734418100596, -122.47132584741) | ||||
| 123989 | 123989 | 215225 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 500x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 39 | 5995372.41973 | 2092668.0374099999 | 37.7258025558202 | -122.458196526156 | (37.7258025558202, -122.458196526156) | ||||
| 131258 | 131258 | 211067 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 500x Miramar Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 39 | 5995372.66361 | 2092795.985 | 37.7261538831809 | -122.458204939322 | (37.7261538831809, -122.458204939322) | ||||
| 27134 | 27134 | 194292 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 43 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6014354.24031 | 2095291.86255 | 37.734079495961396 | -122.392760714642 | (37.7340794959614, -122.392760714642) | ||||
| 35348 | 35348 | 194039 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900x Carolina St | 74 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6012510.33858 | 2102789.20195 | 37.754563007990896 | -122.399661931254 | (37.7545630079909, -122.399661931254) | ||||
| 54354 | 54354 | 194291 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6014364.32912 | 2095287.3135099998 | 37.7340675655682 | -122.39272551607701 | (37.7340675655682, -122.392725516077) | ||||
| 164069 | 164069 | 206833 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 43 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | Width 8ft | 5994013.170390001 | 2101597.32245 | 37.7502419535254 | -122.463543055991 | (37.7502419535254, -122.463543055991) | |||
| 135366 | 135366 | 217818 | DPW Maintained 3 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1x Junipero Serra Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 37 | 5991630.64581 | 2095733.14753 | 37.7340028647425 | -122.471354673377 | (37.7340028647425, -122.471354673377) | ||||
| 136941 | 136941 | 211477 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 100x Idora Ave | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 37 | Width 9ft | 5995466.33774 | 2099382.46662 | 37.7442441346666 | -122.45835764690001 | (37.7442441346666, -122.4583576469) | |||
| 159868 | 159868 | 190994 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 50x Dedman Ct | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 37 | 6016552.89235 | 2096279.67285 | 37.736913695911 | -122.385228023775 | (37.736913695911, -122.385228023775) | ||||
| 165633 | 165633 | 223977 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2x Gough St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 37 | 6006660.75895 | 2109243.9943 | 37.7719585430967 | -122.42034948146002 | (37.7719585430967, -122.42034948146) | ||||
| 26820 | 26820 | 212114 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1902x Monterey Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | Width 10ft | 5992265.63325 | 2095412.1953200002 | 37.7331583221951 | -122.46913599464399 | (37.7331583221951, -122.469135994644) | |||
| 56308 | 56308 | 199365 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300x Division St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | Width 8ft | 6009969.14716 | 2108168.58479 | 37.7691915908542 | -122.408829584245 | (37.7691915908542, -122.408829584245) | |||
| 63844 | 63844 | 211066 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 500x Miramar Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 5995372.70371 | 2092704.8662900003 | 37.7259036953978 | -122.45819820880199 | (37.7259036953978, -122.458198208802) | ||||
| 64791 | 64791 | 247022 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 550x Valley St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 6002376.503830001 | 2099165.28078 | 37.744042469788 | -122.434448284462 | (37.744042469788, -122.434448284462) | ||||
| 69754 | 69754 | 212137 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 602x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 5995383.74966 | 2093392.9126 | 37.7277935397334 | -122.458209800147 | (37.7277935397334, -122.458209800147) | ||||
| 90878 | 90878 | 115157 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 245x ARLINGTON ST | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 3x3 | 6004671.0 | 2096632.0 | 37.737216635749604 | -122.426334098447 | (37.7372166357496, -122.426334098447) | |||
| 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) | |||
| 111024 | 111024 | 115151 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 15X Highland Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 6004989.3 | 2096795.8 | 37.73768438084971 | -122.42524524109 | (37.7376843808497, -122.42524524109) | ||||
| 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) | ||||
| 150397 | 150397 | 194286 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 6014450.16973 | 2095221.3993900002 | 37.7338913460907 | -122.392424127176 | (37.7338913460907, -122.392424127176) | ||||
| 157500 | 157500 | 247032 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 550x Valley St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 6002315.33428 | 2099157.14727 | 37.744016664631296 | -122.43465921327 | (37.7440166646313, -122.43465921327) | ||||
| 157873 | 157873 | 191803 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 180x Bay Shore Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | 6011162.1503800005 | 2099563.42906 | 37.7456304953456 | -122.404097342621 | (37.7456304953456, -122.404097342621) | ||||
| 32049 | 32049 | 211072 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 602x Miramar Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 5995382.34021 | 2093429.0746900002 | 37.7278927511259 | -122.45821728880699 | (37.7278927511259, -122.458217288807) | ||||
| 47939 | 47939 | 211068 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 500x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 5995376.89131 | 2092998.0023 | 37.7267088170477 | -122.4582049393 | (37.7267088170477, -122.4582049393) | ||||
| 47964 | 47964 | 234371 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750x Dolores St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 6005338.50183 | 2098008.71997 | 37.7410345073494 | -122.42412411595 | (37.7410345073494, -122.42412411595) | ||||
| 54386 | 54386 | 211064 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 300x Miramar Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 5995363.79151 | 2092232.49572 | 37.724606167023396 | -122.458194844436 | (37.7246061670234, -122.458194844436) | ||||
| 73360 | 73360 | 233933 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 150x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 6004817.19467 | 2107404.1110799997 | 37.76680260927 | -122.426595473608 | (37.76680260927, -122.426595473608) | ||||
| 75936 | 75936 | 212120 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2101x Monterey Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | Width 10ft | 5991781.48453 | 2095442.7217400002 | 37.7332141530016 | -122.47081203417 | (37.7332141530016, -122.47081203417) | |||
| 132074 | 132074 | 206817 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2187x 09th Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 5993586.72405 | 2100922.72435 | 37.7483650989873 | -122.464968735031 | (37.7483650989873, -122.464968735031) | ||||
| 148964 | 148964 | 234370 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 6005335.592730001 | 2098044.06455 | 37.7411313913144 | -122.42413668757 | (37.7411313913144, -122.42413668757) | ||||
| 157535 | 157535 | 199574 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1300x De Haro St | 33 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 6012273.26957 | 2101981.44078 | 37.7523318538423 | -122.400425049202 | (37.7523318538423, -122.400425049202) | ||||
| 164800 | 164800 | 233942 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 450x Dolores St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 6004917.83694 | 2105642.84744 | 37.7619722884988 | -122.426121969753 | (37.7619722884988, -122.426121969753) | ||||
| 29553 | 29553 | 211075 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 650x Miramar Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 5995390.83549 | 2093912.64173 | 37.7292209976493 | -122.458222905073 | (37.7292209976493, -122.458222905073) | ||||
| 35608 | 35608 | 194288 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700x Quesada Ave | 37 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 6014411.93404 | 2095259.01392 | 37.733992504551296 | -122.392558950849 | (37.7339925045513, -122.392558950849) |
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");