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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 166774 | 166774 | 242781 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 95x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 9ft | 6006152.38517 | 2109124.27435 | 37.771601160584 | -122.42209948031099 | (37.771601160584, -122.422099480311) | |||
| 26925 | 26925 | 208266 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 5996189.57852 | 2098600.11131 | 37.7421375150253 | -122.455800307749 | (37.7421375150253, -122.455800307749) | |||
| 37068 | 37068 | 208271 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 5996099.48169 | 2098476.66946 | 37.7417934029459 | -122.456102909823 | (37.7417934029459, -122.456102909823) | |||
| 51701 | 51701 | 208264 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 5996224.40551 | 2098673.0355 | 37.742339745598706 | -122.45568515764299 | (37.7423397455987, -122.455685157643) | |||
| 55150 | 55150 | 208267 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 5996171.153059999 | 2098570.8040400003 | 37.742055987003496 | -122.455861898701 | (37.7420559870035, -122.455861898701) | |||
| 62625 | 62625 | 208269 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 5996138.33351 | 2098519.81732 | 37.741914106361705 | -122.455971692433 | (37.7419141063617, -122.455971692433) | |||
| 70576 | 70576 | 208265 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 8ft | 5996197.71475 | 2098618.83624 | 37.7421893960176 | -122.455773528635 | (37.7421893960176, -122.455773528635) | |||
| 158855 | 158855 | 208270 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 8ft | 5996116.90771 | 2098495.20016 | 37.7418452839221 | -122.456043996142 | (37.7418452839221, -122.456043996142) | |||
| 175996 | 175996 | 208272 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 8ft | 5996077.78984 | 2098457.8421099996 | 37.741740462546 | -122.456176551714 | (37.741740462546, -122.456176551714) | |||
| 177610 | 177610 | 208268 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 5996154.347999999 | 2098544.9334299997 | 37.741983988173 | -122.455918135114 | (37.741983988173, -122.455918135114) | |||
| 25336 | 25336 | 197493 | DPW Maintained 3 | Schinus molle :: California Pepper 138 | 950x Kansas St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6011595.701219999 | 2103803.27065 | 37.7572963894245 | -122.402896325021 | (37.7572963894245, -122.402896325021) | ||||
| 36942 | 36942 | 197374 | DPW Maintained 3 | Robinia pseudoacacia :: Black Locust 169 | 950x Kansas St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6011591.5235 | 2103896.27295 | 37.7575515198905 | -122.402917314288 | (37.7575515198905, -122.402917314288) | ||||
| 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) | ||||
| 64747 | 64747 | 191695 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 950x Kansas St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6011603.94241 | 2103847.92507 | 37.7574194607598 | -122.40287096412901 | (37.7574194607598, -122.402870964129) | ||||
| 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) | ||||
| 59692 | 59692 | 234516 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 90x Peralta Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 10ft | 6010366.95066 | 2100295.32111 | 37.7475956480377 | -122.406898611185 | (37.7475956480377, -122.406898611185) | |||
| 135572 | 135572 | 221334 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90x Peralta Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6010340.53234 | 2100283.1811900004 | 37.747560836176 | -122.406989109071 | (37.747560836176, -122.406989109071) | |||
| 135988 | 135988 | 242371 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 90x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 10ft | 6006102.65154 | 2109126.4322 | 37.771604280331005 | -122.42227166541001 | (37.771604280331, -122.42227166541) | |||
| 138030 | 138030 | 242370 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 90x McCoppin St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 10ft | 6006121.14049 | 2109126.61017 | 37.7716058118802 | -122.422207723609 | (37.7716058118802, -122.422207723609) | |||
| 25183 | 25183 | 249466 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900x Van Ness Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6006522.49711 | 2113836.87509 | 37.7845616899264 | -122.421153924138 | (37.7845616899264, -122.421153924138) | ||||
| 35512 | 35512 | 249464 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Van Ness Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6006534.583819999 | 2113721.77463 | 37.7842463336479 | -122.421103932595 | (37.7842463336479, -122.421103932595) | ||||
| 37159 | 37159 | 249463 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6006539.42856 | 2113694.50869 | 37.7841717411666 | -122.421085234814 | (37.7841717411666, -122.421085234814) | ||||
| 73439 | 73439 | 249465 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Van Ness Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6006528.896380001 | 2113762.4002 | 37.78435756088879 | -122.421126494805 | (37.7843575608888, -122.421126494805) | ||||
| 150698 | 150698 | 234330 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900x Dolores St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6005083.062580001 | 2102603.58555 | 37.7536365264144 | -122.42533423108699 | (37.7536365264144, -122.425334231087) | ||||
| 155084 | 155084 | 234329 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 900x Dolores St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6005081.6594 | 2102660.65252 | 37.7537931397475 | -122.425343144298 | (37.7537931397475, -122.425343144298) | ||||
| 24818 | 24818 | 191371 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 66 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6012518.79145 | 2102845.53786 | 37.7547181653131 | -122.39963665401699 | (37.7547181653131, -122.399636654017) | ||||
| 26840 | 26840 | 194523 | DPW Maintained 3 | Pinus thunbergii :: Japanese Black Pine 306 | 900x Carolina St | 72 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6012512.869530001 | 2102814.17539 | 37.7546317206991 | -122.399654931846 | (37.7546317206991, -122.399654931846) | ||||
| 27156 | 27156 | 194439 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 900x Carolina St | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6012481.17054 | 2103301.60211 | 37.755968320994704 | -122.3997987802 | (37.7559683209947, -122.3997987802) | ||||
| 27255 | 27255 | 193544 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 900x Carolina St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6012476.687390001 | 2103624.0786200003 | 37.75685352098429 | -122.39983692765499 | (37.7568535209843, -122.399836927655) | ||||
| 27702 | 27702 | 191370 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 63 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012517.15762 | 2102887.31193 | 37.75483277672829 | -122.399645237162 | (37.7548327767283, -122.399645237162) | ||||
| 30111 | 30111 | 198501 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 900x Carolina St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012463.03254 | 2103576.30053 | 37.7567215715659 | -122.399880796574 | (37.7567215715659, -122.399880796574) | ||||
| 31535 | 31535 | 194476 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900x Carolina St | 43 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6012491.75598 | 2103075.9348299997 | 37.755349278054 | -122.39974632722799 | (37.755349278054, -122.399746327228) | ||||
| 32869 | 32869 | 189966 | DPW Maintained 3 | Cercis canadensis :: Eastern Redbud 299 | 900x Carolina St | 73 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012515.82864 | 2102790.5172099997 | 37.754566925442795 | -122.39964303739201 | (37.7545669254428, -122.399643037392) | ||||
| 34339 | 34339 | 194442 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 900x Carolina St | 51 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6012500.2858 | 2102979.92319 | 37.7550861265451 | -122.39971008726499 | (37.7550861265451, -122.399710087265) | ||||
| 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) | ||||
| 37718 | 37718 | 197172 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 900x Carolina St | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6012477.22941 | 2103487.19338 | 37.756477694309204 | -122.39982544148998 | (37.7564776943092, -122.39982544149) | ||||
| 38054 | 38054 | 188001 | DPW Maintained 3 | Araucaria columnaris :: Coral reef araucaria 185 | 900x Carolina St | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6012468.44405 | 2103516.87619 | 37.7565587070327 | -122.399857908825 | (37.7565587070327, -122.399857908825) | ||||
| 38640 | 38640 | 191369 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 62 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012514.91638 | 2102899.16549 | 37.7548651990855 | -122.399653820263 | (37.7548651990855, -122.399653820263) | ||||
| 40612 | 40612 | 193546 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 900x Carolina St | 56 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6012511.31155 | 2102952.5131599996 | 37.7550114792069 | -122.39967003234699 | (37.7550114792069, -122.399670032347) | ||||
| 45589 | 45589 | 191045 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 900x Carolina St | 40 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6012497.15794 | 2103097.51934 | 37.755408845542895 | -122.399729160991 | (37.7554088455429, -122.399729160991) | ||||
| 46296 | 46296 | 194557 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 900x Carolina St | 69 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6012516.26815 | 2102828.89594 | 37.7546723295715 | -122.39964421193301 | (37.7546723295715, -122.399644211933) | ||||
| 49522 | 49522 | 193547 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 900x Carolina St | 65 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6012516.839980001 | 2102871.66546 | 37.7547897972265 | -122.39964523714501 | (37.7547897972265, -122.399645237145) | ||||
| 50659 | 50659 | 201074 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900x Carolina St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6012474.94099 | 2103578.80474 | 37.756729111467706 | -122.399839788381 | (37.7567291114677, -122.399839788381) | ||||
| 56546 | 56546 | 190677 | DPW Maintained 3 | Ilex spp :: Holly Species 163 | 900x Carolina St | 71 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6012520.45276 | 2102813.85342 | 37.7546312593522 | -122.39962868423201 | (37.7546312593522, -122.399628684232) | ||||
| 59430 | 59430 | 201075 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900x Carolina St | 50 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6012500.47255 | 2103002.7121099997 | 37.755148710357396 | -122.39971104145599 | (37.7551487103574, -122.399711041456) | ||||
| 60507 | 60507 | 188584 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6012486.48206 | 2103413.8081 | 37.756276710205995 | -122.39978828959299 | (37.756276710206, -122.399788289593) | ||||
| 60646 | 60646 | 191259 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 900x Carolina St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6012470.08805 | 2103421.28043 | 37.7562963136528 | -122.39984551077299 | (37.7562963136528, -122.399845510773) | ||||
| 61087 | 61087 | 190918 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900x Carolina St | 70 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6012519.44645 | 2102822.4393700003 | 37.754654778405296 | -122.399632767143 | (37.7546547784053, -122.399632767143) | ||||
| 63150 | 63150 | 188587 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 55 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6012500.08207 | 2102956.31087 | 37.7550212809088 | -122.399709133985 | (37.7550212809088, -122.399709133985) | ||||
| 63254 | 63254 | 190917 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900x Carolina St | 68 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6012519.74637 | 2102837.21301 | 37.7546953603194 | -122.399632767155 | (37.7546953603194, -122.399632767155) | ||||
| 63255 | 63255 | 191046 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 900x Carolina St | 44 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6012503.19406 | 2103068.83729 | 37.7553304273806 | -122.399706272322 | (37.7553304273806, -122.399706272322) | ||||
| 63329 | 63329 | 193545 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 900x Carolina St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6012471.27665 | 2103561.30428 | 37.7566808547541 | -122.399851232248 | (37.7566808547541, -122.399851232248) | ||||
| 64729 | 64729 | 194038 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900x Carolina St | 53 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6012502.8583 | 2102970.8089 | 37.7550612440971 | -122.39970055084 | (37.7550612440971, -122.39970055084) | ||||
| 67780 | 67780 | 191690 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 900x Carolina St | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6012468.62754 | 2103498.74867 | 37.756508943061206 | -122.39985600137399 | (37.7565089430612, -122.399856001374) | ||||
| 68908 | 68908 | 194663 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 900x Carolina St | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6012487.04658 | 2103373.70419 | 37.7561666251126 | -122.39978352139099 | (37.7561666251126, -122.399783521391) | ||||
| 68987 | 68987 | 194433 | DPW Maintained 3 | Pinus halepensis :: Allepo Pine 164 | 900x Carolina St | 25 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6012468.7970199995 | 2103466.34183 | 37.756419970421206 | -122.39985313972001 | (37.7564199704212, -122.39985313972) | ||||
| 73552 | 73552 | 194662 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 900x Carolina St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6012476.06279 | 2103566.1501700003 | 37.756694427329 | -122.39983502019501 | (37.756694427329, -122.399835020195) | ||||
| 74110 | 74110 | 188585 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 36 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6012499.61765 | 2103177.92943 | 37.755629771207 | -122.39972630024799 | (37.755629771207, -122.399726300248) | ||||
| 76485 | 76485 | 197585 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 900x Carolina St | 75 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6012517.30691 | 2102783.51804 | 37.7545477896502 | -122.399637433715 | (37.7545477896502, -122.399637433715) | ||||
| 126903 | 126903 | 194440 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 900x Carolina St | 33 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6012485.2688 | 2103286.1411099997 | 37.7559260969364 | -122.399783521388 | (37.7559260969364, -122.399783521388) | ||||
| 130923 | 130923 | 188582 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6012479.86277 | 2103522.41115 | 37.7565745414011 | -122.39981880719999 | (37.7565745414011, -122.3998188072) | ||||
| 131762 | 131762 | 191368 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 900x Carolina St | 60 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6012502.16132 | 2102909.3105599997 | 37.7548923442165 | -122.399698643387 | (37.7548923442165, -122.399698643387) | ||||
| 132192 | 132192 | 190914 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900x Carolina St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6012455.864080001 | 2103644.27268 | 37.756907808551794 | -122.399910360878 | (37.7569078085518, -122.399910360878) | ||||
| 132920 | 132920 | 194475 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900x Carolina St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6012465.76971 | 2103588.87642 | 37.756756254802106 | -122.39987221343901 | (37.7567562548021, -122.399872213439) | ||||
| 133957 | 133957 | 197354 | DPW Maintained 3 | Rhamnus californica :: Coffeeberry Tree 232 | 900x Carolina St | 52 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6012496.37101 | 2102977.25667 | 37.755078586631996 | -122.39972343860701 | (37.755078586632, -122.399723438607) | ||||
| 135280 | 135280 | 190915 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900x Carolina St | 48 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6012505.66859 | 2103014.14021 | 37.7551803790787 | -122.399693874288 | (37.7551803790787, -122.399693874288) | ||||
| 137116 | 137116 | 188583 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6012480.57258 | 2103516.6299400004 | 37.7565587070348 | -122.399815946472 | (37.7565587070348, -122.399815946472) | ||||
| 146596 | 146596 | 188586 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 45 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6012501.01622 | 2103043.06832 | 37.755259550009896 | -122.399711994725 | (37.7552595500099, -122.399711994725) | ||||
| 146893 | 146893 | 188542 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 900x Carolina St | 54 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6012509.86374 | 2102962.70315 | 37.75503937799 | -122.39967575475401 | (37.75503937799, -122.399675754754) | ||||
| 147407 | 147407 | 188588 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 57 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6012513.0739 | 2102944.23906 | 37.754988858573 | -122.399663356681 | (37.754988858573, -122.399663356681) | ||||
| 149319 | 149319 | 197491 | DPW Maintained 3 | Schinus molle :: California Pepper 138 | 900x Carolina St | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012477.42612 | 2103497.4714900004 | 37.756505926715604 | -122.39982548288499 | (37.7565059267156, -122.399825482885) | ||||
| 150115 | 150115 | 188865 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 900x Carolina St | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6012505.22674 | 2103087.46941 | 37.7553817004262 | -122.39970055083401 | (37.7553817004262, -122.399700550834) | ||||
| 151416 | 151416 | 201073 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900x Carolina St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6012459.01568 | 2103636.5199599997 | 37.7568866969857 | -122.399898917004 | (37.7568866969857, -122.399898917004) | ||||
| 152542 | 152542 | 201072 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900x Carolina St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012454.04894 | 2103663.53187 | 37.7569605888705 | -122.39991799073601 | (37.7569605888705, -122.399917990736) | ||||
| 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) | ||||
| 155305 | 155305 | 188580 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6012471.14702 | 2103650.00365 | 37.7569243965657 | -122.399857908838 | (37.7569243965657, -122.399857908838) | ||||
| 155525 | 155525 | 188536 | DPW Maintained 3 | Acacia cyclops :: Cyclops wattle 366 | 900x Carolina St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6012479.96595 | 2103541.08212 | 37.7566258135487 | -122.399819761371 | (37.7566258135487, -122.399819761371) | ||||
| 157286 | 157286 | 198696 | DPW Maintained 3 | Ulmus spp :: Elm Spp 215 | 900x Carolina St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6012471.20589 | 2103666.47878 | 37.7569696369443 | -122.39985886209499 | (37.7569696369443, -122.399858862095) | ||||
| 157954 | 157954 | 194432 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 900x Carolina St | 64 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6012507.9331 | 2102881.1831400003 | 37.754815434199 | -122.39967670801599 | (37.754815434199, -122.399676708016) | ||||
| 162994 | 162994 | 188866 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 900x Carolina St | 42 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6012505.62203 | 2103079.77232 | 37.7553605879327 | -122.39969864337499 | (37.7553605879327, -122.399698643375) | ||||
| 166461 | 166461 | 188581 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x Carolina St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6012475.30485 | 2103528.81943 | 37.75659188303771 | -122.39983502019 | (37.7565918830377, -122.39983502019) | ||||
| 166630 | 166630 | 189402 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900x Carolina St | 35 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6012483.079 | 2103205.45107 | 37.755704417647294 | -122.399785428875 | (37.7557044176473, -122.399785428875) | ||||
| 175195 | 175195 | 194441 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 900x Carolina St | 39 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6012501.46554 | 2103105.9446900003 | 37.7554322198433 | -122.399714855461 | (37.7554322198433, -122.399714855461) | ||||
| 175406 | 175406 | 191510 | DPW Maintained 3 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 900x Carolina St | 34 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6012478.66144 | 2103273.09419 | 37.7558899046023 | -122.399805455861 | (37.7558899046023, -122.399805455861) | ||||
| 178639 | 178639 | 194661 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 900x Carolina St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6012476.239519999 | 2103642.76078 | 37.756904793134204 | -122.399839788377 | (37.7569047931342, -122.399839788377) | ||||
| 183804 | 183804 | 198502 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 900x Carolina St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6012462.6007 | 2103568.62023 | 37.75670045906929 | -122.399881750743 | (37.7567004590693, -122.399881750743) | ||||
| 184948 | 184948 | 190916 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900x Carolina St | 61 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6012503.648130001 | 2102901.04205 | 37.754869723572895 | -122.39969292101601 | (37.7548697235729, -122.399692921016) | ||||
| 33183 | 33183 | 209132 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6001073.50305 | 2095703.1639599998 | 37.7344622582302 | -122.438705728106 | (37.7344622582302, -122.438705728106) | |||
| 41196 | 41196 | 209133 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6001054.84945 | 2095714.1457200001 | 37.734491350384005 | -122.43877100628 | (37.734491350384, -122.43877100628) | ||||
| 50215 | 50215 | 209138 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6000918.34106 | 2095790.55513 | 37.7346933857729 | -122.439248434772 | (37.7346933857729, -122.439248434772) | ||||
| 50311 | 50311 | 209137 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6000977.0463 | 2095762.1119400002 | 37.734618627848796 | -122.43904343343 | (37.7346186278488, -122.43904343343) | ||||
| 58168 | 58168 | 209136 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6000997.1554 | 2095746.93377 | 37.7345780962937 | -122.438972822257 | (37.7345780962937, -122.438972822257) | ||||
| 59293 | 59293 | 209131 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 10ft | 6001087.056530001 | 2095697.8346 | 37.734448396084396 | -122.43865848761699 | (37.7344483960844, -122.438658487617) | |||
| 176176 | 176176 | 209134 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6001014.7051099995 | 2095735.41705 | 37.7345474725699 | -122.438911322111 | (37.7345474725699, -122.438911322111) | ||||
| 187536 | 187536 | 209135 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6001010.142969999 | 2095737.8079 | 37.7345537777227 | -122.438927266197 | (37.7345537777227, -122.438927266197) | ||||
| 27329 | 27329 | 194334 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015942.04821 | 2112270.67914 | 37.7807877820727 | -122.388455820993 | (37.7807877820727, -122.388455820993) | |||
| 29064 | 29064 | 194335 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015932.5598 | 2112347.87113 | 37.7809992081901 | -122.38849403588999 | (37.7809992081901, -122.38849403589) | |||
| 35716 | 35716 | 194337 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6015953.29851 | 2112409.5704799998 | 37.781169770014294 | -122.38842659752198 | (37.7811697700143, -122.388426597522) | |||
| 46468 | 46468 | 194330 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | Width 8ft | 6015863.586519999 | 2112149.96757 | 37.780451986896296 | -122.38871883132 | (37.7804519868963, -122.38871883132) | |||
| 51725 | 51725 | 194333 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | Width 8ft | 6015903.377169999 | 2112286.3418900003 | 37.78082864545979 | -122.38859069771999 | (37.7808286454598, -122.38859069772) |
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");