Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10796 | 10796 | 56697 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1835 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1530 | 3x4 | 5983784.1963 | 2102652.3274 | 37.752544024505895 | -122.498992883391 | (37.7525440245059, -122.498992883391) | |||
| 85913 | 85913 | 12591 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 540 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 135 | 3X3 | 5993752.44537 | 2114880.64385 | 37.7866994199903 | -122.465409472784 | (37.7866994199903, -122.465409472784) | |||
| 7939 | 7939 | 4660 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 125 | 5X5 | 6009761.7282 | 2119587.7167 | 37.8005341810425 | -122.410353429867 | (37.8005341810425, -122.410353429867) | |||
| 78599 | 78599 | 12607 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 653 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 125 | 9x7 | 5993406.40366 | 2114819.71467 | 37.7865121620391 | -122.46660225402901 | (37.7865121620391, -122.466602254029) | |||
| 126700 | 126700 | 12581 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 431 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 125 | 3x3 | 5994092.89819 | 2114844.89484 | 37.7866208917825 | -122.46422900028 | (37.7866208917825, -122.46422900028) | |||
| 127418 | 127418 | 12606 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 651 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 125 | 3X3 | 5993439.12695 | 2114820.30449 | 37.786515669843205 | -122.466489083379 | (37.7865156698432, -122.466489083379) | |||
| 3904 | 3904 | 4665 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 5X5 | 6009675.3838 | 2119664.5956 | 37.8007404309352 | -122.410657649881 | (37.8007404309352, -122.410657649881) | |||
| 7737 | 7737 | 8094 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 762 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 100 | 3X3 | 6004211.6397 | 2111535.7715 | 37.7781128879326 | -122.428984591665 | (37.7781128879326, -122.428984591665) | |||
| 8809 | 8809 | 3076 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2901 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 6000369.0268 | 2115111.6254 | 37.7877130071917 | -122.442534340035 | (37.7877130071917, -122.442534340035) | |||
| 9140 | 9140 | 12661 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1045 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 4X4 | 5992178.70595 | 2114775.57253 | 37.786320036254004 | -122.47084652786002 | (37.786320036254, -122.47084652786) | |||
| 9275 | 9275 | 9356 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 241 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 6000999.4900667 | 2098404.1035626 | 37.74187419547079 | -122.43915513344 | (37.7418741954708, -122.43915513344) | |||
| 18991 | 18991 | 5440 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004903.17124 | 2105121.8240799997 | 37.7605408528978 | -122.426135598976 | (37.7605408528978, -122.426135598976) | |||
| 21952 | 21952 | 5447 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004926.667780001 | 2104747.1594700003 | 37.7595134404185 | -122.42602766326401 | (37.7595134404185, -122.426027663264) | |||
| 77970 | 77970 | 12741 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1638 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 4X4 | 5990321.4540800005 | 2114762.4147099997 | 37.786176325151295 | -122.47727111168899 | (37.7861763251513, -122.477271111689) | |||
| 78188 | 78188 | 7673 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 290X LAKE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5994618.0 | 2114909.0 | 37.7868271588239 | -122.46241694027701 | (37.7868271588239, -122.462416940277) | |||
| 87397 | 87397 | 14536 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 92924 | 92924 | 14535 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 101187 | 101187 | 5485 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 700X Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 100 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
| 107403 | 107403 | 14539 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 112742 | 112742 | 13155 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1871 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3x3 | 6003453.14477 | 2119540.71202 | 37.8000494585448 | -122.43218031398199 | (37.8000494585448, -122.432180313982) | |||
| 112962 | 112962 | 14532 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 114688 | 114688 | 1471 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 223 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5995498.41446 | 2114753.58122 | 37.7864510796736 | -122.459359672388 | (37.7864510796736, -122.459359672388) | |||
| 116039 | 116039 | 14534 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 118883 | 118883 | 3331 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5330 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3x3 | 5991002.22066 | 2114113.47051 | 37.784433979884795 | -122.474868477503 | (37.7844339798848, -122.474868477503) | |||
| 119891 | 119891 | 14538 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 120313 | 120313 | 14531 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 124314 | 124314 | 14533 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 128485 | 128485 | 12541 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 233 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5994692.63999 | 2114868.9307 | 37.7867214372248 | -122.462155798195 | (37.7867214372248, -122.462155798195) | |||
| 141688 | 141688 | 1614 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 757 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5995631.63313 | 2111076.8894 | 37.7763635225537 | -122.458632510412 | (37.7763635225537, -122.458632510412) | |||
| 145511 | 145511 | 19288 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 55X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5995247.58897 | 2114888.2393799997 | 37.7868063902482 | -122.46023721951599 | (37.7868063902482, -122.460237219516) | |||
| 2016 | 2016 | 13112 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1601 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 6004666.807 | 2119779.6281 | 37.800774197193796 | -122.42799761136001 | (37.8007741971938, -122.42799761136) | |||
| 4255 | 4255 | 4659 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009780.1976 | 2119571.0943 | 37.800489575353104 | -122.410288343699 | (37.8004895753531, -122.410288343699) | |||
| 4302 | 4302 | 13161 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1895 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6003359.5664 | 2119590.4223 | 37.8001806439695 | -122.432507683341 | (37.8001806439695, -122.432507683341) | |||
| 4904 | 4904 | 23927 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1715 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6003460.7841 | 2114695.1886 | 37.7867453258178 | -122.43180771362199 | (37.7867453258178, -122.431807713622) | |||
| 5145 | 5145 | 4664 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009692.467999999 | 2119649.5892 | 37.8007001848924 | -122.410597470914 | (37.8007001848924, -122.410597470914) | |||
| 5411 | 5411 | 8150 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1000 Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6002846.3106 | 2111341.485 | 37.7775020483312 | -122.433693863913 | (37.7775020483312, -122.433693863913) | |||
| 6364 | 6364 | 13127 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6004182.8465 | 2119787.4466 | 37.8007682730329 | -122.42967287413 | (37.8007682730329, -122.42967287413) | |||
| 6968 | 6968 | 4661 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009739.5649 | 2119605.2627 | 37.8005811155969 | -122.41043136381901 | (37.8005811155969, -122.410431363819) | |||
| 8009 | 8009 | 8146 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1000 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6002926.0085 | 2111351.5233 | 37.7775341328911 | -122.433418880148 | (37.7775341328911, -122.433418880148) | |||
| 8446 | 8446 | 11434 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 6011450.63994 | 2118045.46213 | 37.7963940539012 | -122.404400461805 | (37.7963940539012, -122.404400461805) | |||
| 8946 | 8946 | 14523 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 625 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4x4 | 5999129.3058 | 2110654.1301 | 37.7754031370148 | -122.446502707181 | (37.7754031370148, -122.446502707181) | |||
| 17317 | 17317 | 5713 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1629 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6005337.04528 | 2098854.62727 | 37.743357094669705 | -122.424189297907 | (37.7433570946697, -122.424189297907) | |||
| 17549 | 17549 | 5699 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1569 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 6 | 6005313.38344 | 2099208.61144 | 37.7443277185515 | -122.424296285742 | (37.7443277185515, -122.424296285742) | |||
| 17955 | 17955 | 10276 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 215X Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6004948.0554599995 | 2109498.71961 | 37.7725612966014 | -122.42629199289699 | (37.7725612966014, -122.426291992897) | |||
| 18207 | 18207 | 5631 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1234 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6005123.01487 | 2101119.88751 | 37.749564892610394 | -122.425090505838 | (37.7495648926104, -122.425090505838) | |||
| 19158 | 19158 | 5458 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 589 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2009 12:00:00 AM | 90 | 3x3 | 6004996.57492 | 2104960.58209 | 37.7601033992601 | -122.42580108085801 | (37.7601033992601, -122.425801080858) | ||
| 19320 | 19320 | 5332 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 125 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 6x7 | 6004849.91389 | 2107615.9681599997 | 37.7673861676625 | -122.42649738994601 | (37.7673861676625, -122.426497389946) | |||
| 19662 | 19662 | 10000 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 136 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 2X2 | 6005403.547780001 | 2108183.22689 | 37.7689750062251 | -122.424622801709 | (37.7689750062251, -122.424622801709) | |||
| 19679 | 19679 | 3246 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3934 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 5995332.1300099995 | 2114476.7036099997 | 37.785681286495794 | -122.45991490670299 | (37.7856812864958, -122.459914906703) | |||
| 20393 | 20393 | 1382 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 601X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5995593.50257 | 2112100.09905 | 37.7791707937226 | -122.458838511201 | (37.7791707937226, -122.458838511201) | |||
| 20504 | 20504 | 10495 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1701 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 5997835.7259 | 2108510.475 | 37.7694432404816 | -122.450822883239 | (37.7694432404816, -122.450822883239) | |||
| 20788 | 20788 | 14571 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 5x5 | 5999361.6418 | 2109001.7234 | 37.7708793165263 | -122.445580154944 | (37.7708793165263, -122.445580154944) | |||
| 20901 | 20901 | 5441 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 6 | 6004905.78091 | 2105098.60706 | 37.76047725195271 | -122.426124920443 | (37.7604772519527, -122.426124920443) | |||
| 21599 | 21599 | 1993 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 162 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6007301.508909999 | 2098085.20202 | 37.7413551489316 | -122.417342154839 | (37.7413551489316, -122.417342154839) | |||
| 22189 | 22189 | 24547 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 704 Cortland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X4 | 6007976.32415 | 2097161.8833 | 37.7388578628999 | -122.41494353791501 | (37.7388578628999, -122.414943537915) | |||
| 22218 | 22218 | 24546 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 704 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X4 | 6007961.02706 | 2097162.19636 | 37.7388578629053 | -122.414996450438 | (37.7388578629053, -122.414996450438) | |||
| 24663 | 24663 | 8164 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1108 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 6002345.91863 | 2111334.94694 | 37.7774556905463 | -122.435424415956 | (37.7774556905463, -122.435424415956) | |||
| 77343 | 77343 | 3327 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5300 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 5991115.03763 | 2114114.39354 | 37.7844430513541 | -122.474478240984 | (37.7844430513541, -122.474478240984) | |||
| 77367 | 77367 | 12589 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 501 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5993835.87193 | 2114839.30681 | 37.786590730818894 | -122.465117835634 | (37.7865907308189, -122.465117835634) | |||
| 78527 | 78527 | 17723 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1300X Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 3X3 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | |||
| 86397 | 86397 | 239 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 3010X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 90 | 2 | 5990623.3177 | 2095139.449 | 37.73231439650579 | -122.474793962374 | (37.7323143965058, -122.474793962374) | |||
| 90915 | 90915 | 8148 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6002886.962169999 | 2111360.68278 | 37.7775570672136 | -122.43355460906601 | (37.7775570672136, -122.433554609066) | |||
| 93458 | 93458 | 8147 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6002886.962169999 | 2111360.68278 | 37.7775570672136 | -122.43355460906601 | (37.7775570672136, -122.433554609066) | |||
| 93568 | 93568 | 1421 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 50 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x12 | 5995527.212040001 | 2115624.1968 | 37.7888432106719 | -122.459323111848 | (37.7888432106719, -122.459323111848) | |||
| 94766 | 94766 | 4593 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6011460.12974 | 2118136.30046 | 37.7966440043551 | -122.40437402195299 | (37.7966440043551, -122.404374021953) | |||
| 95208 | 95208 | 3393 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6241 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5988252.22536 | 2113941.19107 | 37.7838012036794 | -122.484369756511 | (37.7838012036794, -122.484369756511) | |||
| 97802 | 97802 | 3315 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5010 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5992011.64144 | 2114143.58423 | 37.7845751079649 | -122.471378457169 | (37.7845751079649, -122.471378457169) | |||
| 98768 | 98768 | 12732 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1619 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5990481.52989 | 2114717.45643 | 37.7860621686584 | -122.476714011555 | (37.7860621686584, -122.476714011555) | |||
| 105022 | 105022 | 5464 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | |||
| 108881 | 108881 | 12603 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 645 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5993471.58312 | 2114823.4545400003 | 37.7865261918162 | -122.466377023021 | (37.7865261918162, -122.466377023021) | |||
| 110028 | 110028 | 1584 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 653 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5995606.55902 | 2111798.94869 | 37.7783446651954 | -122.458771535508 | (37.7783446651954, -122.458771535508) | |||
| 110333 | 110333 | 12601 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 637 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5993509.18858 | 2114827.45466 | 37.78653934484179 | -122.466247209305 | (37.7865393448418, -122.466247209305) | |||
| 112209 | 112209 | 1559 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 552 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 5995643.10859 | 2112475.92175 | 37.7802055542204 | -122.458694119583 | (37.7802055542204, -122.458694119583) | |||
| 113302 | 113302 | 17727 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1300X Pierce St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 3X3 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | |||
| 117968 | 117968 | 5435 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 6 | 6004896.4850004995 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | |||
| 117989 | 117989 | 175 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5400X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5990796.10602 | 2114048.44446 | 37.7842434899767 | -122.475576806045 | (37.7842434899767, -122.475576806045) | |||
| 118919 | 118919 | 1574 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 595 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5995589.6988699995 | 2112254.70561 | 37.7795950836314 | -122.45886286632 | (37.7795950836314, -122.45886286632) | |||
| 122237 | 122237 | 1582 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 633 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5995604.58017 | 2111830.53845 | 37.778431288562004 | -122.45878066865801 | (37.778431288562, -122.458780668658) | |||
| 124902 | 124902 | 12672 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1132 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X4 | 5991897.52815 | 2114823.03375 | 37.786434086563 | -122.47182278185 | (37.786434086563, -122.47182278185) | |||
| 126525 | 126525 | 3410 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6528 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5987293.52978 | 2113992.8320400002 | 37.7838871248275 | -122.48769023634199 | (37.7838871248275, -122.487690236342) | |||
| 140018 | 140018 | 12815 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2139 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5988780.51636 | 2114651.15635 | 37.7857813149586 | -122.48259413097601 | (37.7857813149586, -122.482594130976) | |||
| 140497 | 140497 | 1636 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 827 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 5995647.41415 | 2110653.56158 | 37.7752020829683 | -122.458547268394 | (37.7752020829683, -122.458547268394) | |||
| 143328 | 143328 | 3408 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6517 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 2X3 | 5987328.28355 | 2113919.47268 | 37.7836877279639 | -122.48756461184999 | (37.7836877279639, -122.48756461185) | |||
| 143481 | 143481 | 11367 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1351X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6017270.42563 | 2093912.097264 | 37.730452470679005 | -122.38258247713001 | (37.730452470679, -122.38258247713) | |||
| 144868 | 144868 | 3336 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5414 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5990748.9880099995 | 2114101.91513 | 37.7843875739705 | -122.475743722006 | (37.7843875739705, -122.475743722006) | |||
| 145960 | 145960 | 12526 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 45 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5995287.93021 | 2114888.84585 | 37.7868103758205 | -122.460097693179 | (37.7868103758205, -122.460097693179) | |||
| 145996 | 145996 | 12586 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 446 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 5994034.10882 | 2114901.58036 | 37.78677314610329 | -122.46443651291 | (37.7867731461033, -122.46443651291) | |||
| 32979 | 32979 | 61822 | Permitted Site 1 | Ficus macrophylla :: Morton Bay Fig 148 | 2749 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/1985 12:00:00 AM | 88 | Permit Number 21854 | 5999853.53427 | 2118084.4694 | 37.7958462579399 | -122.44453158308201 | (37.7958462579399, -122.444531583082) | ||
| 2899 | 2899 | 91782 | Permitted Site 1 | Platanus x hispanica 'Bloodgood' :: Bloodgood London Plane 152 | 1098 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 80 | 3x3 | Permit Number 780455 | 6010905.08721 | 2110652.14803 | 37.776063263843795 | -122.40576716423901 | (37.7760632638438, -122.405767164239) | |
| 5926 | 5926 | 13119 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1641 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3x3 | 6004501.8382 | 2119760.0821 | 37.8007111944994 | -122.42856707818899 | (37.8007111944994, -122.428567078189) | |||
| 8289 | 8289 | 4662 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 80 | 5X5 | 6009727.0981 | 2119617.2678 | 37.8006133797513 | -122.41047535239099 | (37.8006133797513, -122.410475352391) | |||
| 9376 | 9376 | 14452 | Permitted Site 1 | Tristania conferta :: 79 | 100 Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3x3 | 5998927.5567 | 2112628.8329 | 37.7808136360807 | -122.44734276226002 | (37.7808136360807, -122.44734276226) | |||
| 17686 | 17686 | 14577 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1135 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 5999374.0888 | 2108906.7208 | 37.7706191740488 | -122.445530268097 | (37.7706191740488, -122.445530268097) | |||
| 17956 | 17956 | 5584 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1070 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 6005072.3503 | 2102110.66979 | 37.7522824891524 | -122.425336202406 | (37.7522824891524, -122.425336202406) | |||
| 18511 | 18511 | 10336 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 875 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3x3 | 6002010.71574 | 2109090.04543 | 37.7712727083875 | -122.43642328112101 | (37.7712727083875, -122.436423281121) | |||
| 18729 | 18729 | 4825 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 72 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 6006134.02134 | 2097745.6697400003 | 37.7403571145946 | -122.421354819194 | (37.7403571145946, -122.421354819194) | |||
| 19125 | 19125 | 28638 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 740 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.777378207850795 | -122.42957257421499 | (37.7773782078508, -122.429572574215) | |||
| 20186 | 20186 | 5718 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1651 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 6005348.2159400005 | 2098686.18257 | 37.742895214531295 | -122.424138695771 | (37.7428952145313, -122.424138695771) | |||
| 20994 | 20994 | 5443 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 500X Dolores St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/19/1992 12:00:00 AM | 80 | 6 | 6004908.86181 | 2105038.27798 | 37.7603117767003 | -122.426109970095 | (37.7603117767003, -122.426109970095) | ||
| 21846 | 21846 | 5476 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 635 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 4X4 | 6005015.06111 | 2104677.01858 | 37.7593258454205 | -122.425716962778 | (37.7593258454205, -122.425716962778) |
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");