Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6217 | 6217 | 83680 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/23/2015 03:26:00 PM | 3 | 6008994.04445 | 2113694.03545 | 37.784308507385504 | -122.412593075226 | (37.7843085073855, -122.412593075226) | |||
| 8113 | 8113 | 75258 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 288 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/23/2015 04:17:00 PM | 3 | 6009102.38385 | 2113598.35596 | 37.7840518741506 | -122.41221149286699 | (37.7840518741506, -122.412211492867) | |||
| 18684 | 18684 | 109456 | Permitted Site 1 | Tree(s) :: 17 | 951 GILMAN AVE | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/24/2015 12:00:00 AM | 3 | Permit Number 774986 | 6015934.0 | 2089205.0 | 37.717453787650705 | -122.38687458595501 | (37.7174537876507, -122.386874585955) | ||
| 20862 | 20862 | 116132 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 25448 | 25448 | 102374 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 870 39th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 2 | 5983888.78905 | 2110020.99125 | 37.7727824290992 | -122.499175615397 | (37.7727824290992, -122.499175615397) | ||||
| 26127 | 26127 | 110046 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 288 Eddy St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 2 | 6009043.83179 | 2113590.50747 | 37.7840270384566 | -122.412413507572 | (37.7840270384566, -122.412413507572) | ||||
| 31420 | 31420 | 102369 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | Permit Number 769895 | 5984151.59861 | 2110096.53732 | 37.773005270668 | -122.49827212221099 | (37.773005270668, -122.498272122211) | |||
| 33246 | 33246 | 102378 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 870 39th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 2 | 5983886.84831 | 2110037.48525 | 37.7728276030319 | -122.499183547509 | (37.7728276030319, -122.499183547509) | ||||
| 33621 | 33621 | 102375 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 870 39th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 5983887.37527 | 2110050.4929400003 | 37.7728633493226 | -122.499182686047 | (37.7728633493226, -122.499182686047) | ||||
| 38057 | 38057 | 102379 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 5984156.57881 | 2110013.67242 | 37.772778039448106 | -122.49824877411999 | (37.7727780394481, -122.49824877412) | ||||
| 38305 | 38305 | 116138 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1601X Armstrong Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 6014404.0852 | 2092434.1919 | 37.7262356791342 | -122.39238857399599 | (37.7262356791342, -122.392388573996) | ||||
| 39888 | 39888 | 102373 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 870 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 5983890.730690001 | 2109977.48147 | 37.7726630776505 | -122.499165683617 | (37.7726630776505, -122.499165683617) | ||||
| 40373 | 40373 | 37238 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 11 | Permit Number 770085 | 5987346.2909 | 2103736.5081 | 37.755729192821704 | -122.48675431687 | (37.7557291928217, -122.48675431687) | ||
| 54999 | 54999 | 75092 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 288 Eddy St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/16/1989 12:00:00 AM | 16 | 6009056.34359 | 2113588.95965 | 37.7840234906369 | -122.41237011169201 | (37.7840234906369, -122.412370111692) | |||
| 69190 | 69190 | 102377 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 870 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 5983889.8768 | 2109995.31333 | 37.7727119887219 | -122.49916995510901 | (37.7727119887219, -122.499169955109) | ||||
| 72532 | 72532 | 116318 | Undocumented 2 | :: 54 | 1451 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010547.7 | 2101110.8 | 37.749844886729996 | -122.406331036849 | (37.74984488673, -122.406331036849) | |||||
| 77747 | 77747 | 116129 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 78776 | 78776 | 85052 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 355x Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/27/2007 12:00:00 AM | Permit Number 49332 | 6004826.8 | 2109751.4 | 37.7732482408903 | -122.426729425627 | (37.7732482408903, -122.426729425627) | |||
| 78978 | 78978 | 87642 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1002X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004813.344433 | 2112300.6630169996 | 37.7802471321724 | -122.42695756751101 | (37.7802471321724, -122.426957567511) | |||||
| 79036 | 79036 | 116326 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 79426 | 79426 | 116125 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
| 79670 | 79670 | 100784 | Permitted Site 1 | Tree(s) :: 17 | 2101 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | |||||
| 80868 | 80868 | 116284 | Undocumented 2 | :: 54 | 700X Greenwich St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 80880 | 80880 | 116148 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 81016 | 81016 | 27773 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | |||
| 81024 | 81024 | 116130 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 81330 | 81330 | 116229 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1699 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | |||||
| 81886 | 81886 | 116302 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1550 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002138.3 | 2113859.7 | 37.784376231358706 | -122.436323371803 | (37.7843762313587, -122.436323371803) | |||||
| 82559 | 82559 | 116276 | Undocumented 2 | :: 54 | 700X Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 82737 | 82737 | 106281 | Undocumented 2 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 474 | 399X Elliot St | 2 | Unaccepted Street : Yard 14 | Tree 1 | Rec/Park 3 | Permit Number 772905 | 6008798.75873 | 2088103.6204900001 | 37.7140319762934 | -122.41146014936301 | (37.7140319762934, -122.411460149363) | ||||
| 83060 | 83060 | 116290 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 84099 | 84099 | 116291 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 84542 | 84542 | 27772 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | |||
| 84777 | 84777 | 116279 | Undocumented 2 | :: 54 | 700X Greenwich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 84841 | 84841 | 116134 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 85033 | 85033 | 109457 | Undocumented 2 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 951 GILMAN AVE | 43 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 23 | 6015934.0 | 2089205.0 | 37.717453787650705 | -122.38687458595501 | (37.7174537876507, -122.386874585955) | ||||
| 87523 | 87523 | 116144 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 88004 | 88004 | 27771 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | |||
| 88078 | 88078 | 116321 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 88387 | 88387 | 116329 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 88440 | 88440 | 116286 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 88615 | 88615 | 100034 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199@Washington Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411.0 | 2117399.5 | 37.794506209154704 | -122.411412418869 | (37.7945062091547, -122.411412418869) | |||
| 89080 | 89080 | 106004 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 695X CAMPBELL AVE | unknown : Yard 19 | Tree 1 | Rec/Park 3 | 6009136.9 | 2088912.4 | 37.716271678506 | -122.41034847162202 | (37.716271678506, -122.410348471622) | ||||||
| 89720 | 89720 | 116304 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1550 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002138.3 | 2113859.7 | 37.784376231358706 | -122.436323371803 | (37.7843762313587, -122.436323371803) | |||||
| 89735 | 89735 | 27770 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/01/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | |||
| 90870 | 90870 | 116303 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1550 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002138.3 | 2113859.7 | 37.784376231358706 | -122.436323371803 | (37.7843762313587, -122.436323371803) | |||||
| 91125 | 91125 | 116146 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 91482 | 91482 | 116332 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 91746 | 91746 | 87641 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1002X Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004813.344433 | 2112300.6630169996 | 37.7802471321724 | -122.42695756751101 | (37.7802471321724, -122.426957567511) | |||||
| 92470 | 92470 | 116283 | Undocumented 2 | :: 54 | 700X Greenwich St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 92543 | 92543 | 116287 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 92983 | 92983 | 116128 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
| 93124 | 93124 | 116328 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 93581 | 93581 | 116133 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 93863 | 93863 | 94301 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1150X Fillmore St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 93919 | 93919 | 96976 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 390X Filbert St | 1 | Median : Yard 3 | Tree 1 | Rec/Park 3 | 28 | 6010951.1 | 2119992.4 | 37.8017119430502 | -122.406266229116 | (37.8017119430502, -122.406266229116) | ||||
| 94078 | 94078 | 116333 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 94106 | 94106 | 116320 | Undocumented 2 | :: 54 | 1451 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010547.7 | 2101110.8 | 37.749844886729996 | -122.406331036849 | (37.74984488673, -122.406331036849) | |||||
| 94547 | 94547 | 116285 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 95183 | 95183 | 116324 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 95392 | 95392 | 37236 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | Permit Number 770085 | 5987459.55498562 | 2104367.82715752 | 37.757469225946295 | -122.48640896705601 | (37.7574692259463, -122.486408967056) | |||
| 95834 | 95834 | 106280 | Undocumented 2 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 474 | 399X Elliot St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Rec/Park 3 | Permit Number 772905 | 6008798.75873 | 2088103.6204900001 | 37.7140319762934 | -122.41146014936301 | (37.7140319762934, -122.411460149363) | ||||
| 96429 | 96429 | 116143 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 96944 | 96944 | 116147 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 97092 | 97092 | 5467 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 600X Dolores St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||||
| 98178 | 98178 | 116335 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 98431 | 98431 | 116227 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1699 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | |||||
| 98464 | 98464 | 116142 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 98757 | 98757 | 116282 | Undocumented 2 | :: 54 | 700X Greenwich St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 98945 | 98945 | 116341 | Undocumented 2 | :: 54 | 201X Bright St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5993755.0695 | 2088847.02637 | 37.715217913096104 | -122.463510368547 | (37.7152179130961, -122.463510368547) | |||||
| 99142 | 99142 | 116319 | Undocumented 2 | :: 54 | 1451 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010547.7 | 2101110.8 | 37.749844886729996 | -122.406331036849 | (37.74984488673, -122.406331036849) | |||||
| 100067 | 100067 | 116145 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 100230 | 100230 | 116306 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1550 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002138.3 | 2113859.7 | 37.784376231358706 | -122.436323371803 | (37.7843762313587, -122.436323371803) | |||||
| 101071 | 101071 | 111757 | Landmark tree 9 | Sambucus mexicana :: Blue Elderberry 480 | 3440X Folsom St | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 6008633.6974599995 | 2098934.7859 | 37.743762781475 | -122.41279594632401 | (37.743762781475, -122.412795946324) | |||||
| 101234 | 101234 | 94303 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 102030 | 102030 | 116141 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 102302 | 102302 | 116136 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 102570 | 102570 | 94295 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 103966 | 103966 | 94293 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 104628 | 104628 | 116305 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1550 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002138.3 | 2113859.7 | 37.784376231358706 | -122.436323371803 | (37.7843762313587, -122.436323371803) | |||||
| 105094 | 105094 | 116131 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 105834 | 105834 | 27768 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/10/2000 12:00:00 AM | 6 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | |||
| 106091 | 106091 | 75415 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 290 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/23/2015 04:14:00 PM | 3 | 6009037.88726419 | 2113590.00375699 | 37.7840253217877 | -122.412434037929 | (37.7840253217877, -122.412434037929) | |||
| 107067 | 107067 | 116330 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 107184 | 107184 | 116334 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 107812 | 107812 | 87643 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1002X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004813.344433 | 2112300.6630169996 | 37.7802471321724 | -122.42695756751101 | (37.7802471321724, -122.426957567511) | |||||
| 107857 | 107857 | 94299 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1150X Fillmore St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 108909 | 108909 | 116293 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 108927 | 108927 | 116338 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 110949 | 110949 | 116228 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1699 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | |||||
| 111357 | 111357 | 96617 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3555@ Valencia 19th St | 251 | Sidewalk: Property side : 26 | Tree 1 | Rec/Park 3 | Permit Number 771218 | 6006277.0 | 2104934.0 | 37.7601026853586 | -122.42137080656 | (37.7601026853586, -122.42137080656) | ||||
| 111444 | 111444 | 116288 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 112414 | 112414 | 110047 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 290 Eddy St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009037.88726419 | 2113590.00375699 | 37.7840253217877 | -122.412434037929 | (37.7840253217877, -122.412434037929) | |||||
| 112616 | 112616 | 100037 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199@Washington Mason St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411.0 | 2117399.5 | 37.794506209154704 | -122.411412418869 | (37.7945062091547, -122.411412418869) | |||
| 112628 | 112628 | 116325 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 113581 | 113581 | 116149 | Undocumented 2 | Tree(s) :: 17 | 3701 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004597.25395 | 2105425.85161 | 37.7613583450105 | -122.427215284143 | (37.7613583450105, -122.427215284143) | |||||
| 113797 | 113797 | 116339 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 113933 | 113933 | 100787 | Permitted Site 1 | Tree(s) :: 17 | 2001 Washington St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | |||||
| 115300 | 115300 | 85051 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 355x Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/27/2007 12:00:00 AM | Permit Number 49332 | 6004826.8 | 2109751.4 | 37.7732482408903 | -122.426729425627 | (37.7732482408903, -122.426729425627) | |||
| 115457 | 115457 | 100785 | Permitted Site 1 | Tree(s) :: 17 | 2101 Washington St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) |
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");