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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||||
| 140734 | 140734 | 94945 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 1820X Palou Ave | : Cutout 24 | Tree 1 | Rec/Park 3 | FUF 1 | 04/04/2009 12:00:00 AM | 6013714.4 | 2096294.3 | 37.7367964240349 | -122.395043047708 | (37.7367964240349, -122.395043047708) | ||||
| 1080 | 1080 | 9610 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1388X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/01/2017 01:42:00 PM | 3 | 3X3 | 6002958.1886 | 2112049.4711 | 37.7794523489738 | -122.433357444963 | (37.7794523489738, -122.433357444963) | ||
| 7109 | 7109 | 18519 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1700X Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X3 | 6009627.5943 | 2119520.0726 | 37.800340927010296 | -122.410812809398 | (37.8003409270103, -122.410812809398) | |||
| 7403 | 7403 | 107472 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1464 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x3 | 6007706.0171300005 | 2117181.73808 | 37.793812512193604 | -122.417296448573 | (37.7938125121936, -122.417296448573) | |||
| 7614 | 7614 | 20156 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1100X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 4X4 | 6002897.8994 | 2112109.7603 | 37.7796144675148 | -122.43357032043899 | (37.7796144675148, -122.433570320439) | |||
| 7740 | 7740 | 9445 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/01/1994 12:00:00 AM | 12 | 3X3 | 6005680.1419 | 2112439.5166 | 37.780677364386705 | -122.423968789396 | (37.7806773643867, -122.423968789396) | ||
| 7851 | 7851 | 4658 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 34 | 5X5 | 6009795.4348 | 2119557.2423 | 37.8004523952872 | -122.410234638074 | (37.8004523952872, -122.410234638074) | |||
| 8128 | 8128 | 87100 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 700 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 50056 | ||||||||
| 8608 | 8608 | 9533 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6004176.1272 | 2112221.7819 | 37.7799944925987 | -122.429156369266 | (37.7799944925987, -122.429156369266) | |||
| 8790 | 8790 | 105143 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 432 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | DPW for City Agency 2 | 3 | 4x4 | 6005556.0703 | 2110851.1612 | 37.776309122873705 | -122.42428501193301 | (37.7763091228737, -122.424285011933) | ||
| 10993 | 10993 | 764 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3 | 5984614.2914 | 2106873.7688 | 37.76418358274471 | -122.496433785178 | (37.7641835827447, -122.496433785178) | |||
| 14374 | 14374 | 26131 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1500 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x3 | 6015558.456 | 2095125.3192 | 37.7336890117673 | -122.388585707606 | (37.7336890117673, -122.388585707606) | |||
| 15454 | 15454 | 7377 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1000X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 45 | 3X3 | 6010910.3764 | 2111530.9317 | 37.7784764953194 | -122.405810783213 | (37.7784764953194, -122.405810783213) | |||
| 17563 | 17563 | 687 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 1299X Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 3X3 | 6010636.022580001 | 2101844.6913400004 | 37.75186493122229 | -122.40607730804199 | (37.7518649312223, -122.406077308042) | |||
| 18045 | 18045 | 24537 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6007586.10322 | 2097213.8581 | 37.738978639151505 | -122.416296424042 | (37.7389786391515, -122.416296424042) | |||
| 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) | ||
| 19927 | 19927 | 10223 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1377X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005871.04446 | 2100967.56548 | 37.7491888788632 | -122.42249296966999 | (37.7491888788632, -122.42249296967) | |||
| 21461 | 21461 | 5433 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 500X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/27/2008 12:00:00 AM | 3 | 6 | 6004888.034519999 | 2105376.13123 | 37.76123826456529 | -122.42620605546301 | (37.7612382645653, -122.426206055463) | ||
| 21638 | 21638 | 18577 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/12/1998 12:00:00 AM | 6 | 3X3 | 5993712.2633 | 2088544.8235 | 37.7143856696584 | -122.46363640417201 | (37.7143856696584, -122.463636404172) | ||
| 28004 | 28004 | 103180 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 11 | 3x4 | 5987448.1702 | 2104354.2995 | 37.757431419068496 | -122.486447346513 | (37.7574314190685, -122.486447346513) | |||
| 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) | ||||
| 44141 | 44141 | 88407 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009407.88363 | 2117347.72867 | 37.7943638829406 | -122.411419542685 | (37.7943638829406, -122.411419542685) | |
| 46034 | 46034 | 103206 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1600X 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10 | 3x4 | 5987202.3567 | 2103753.0931 | 37.7557663384655 | -122.487253298879 | (37.7557663384655, -122.487253298879) | |||
| 48375 | 48375 | 17720 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300X Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 35 | 3X3 | Permit Number 768629 | 6002290.5602400005 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | |
| 50090 | 50090 | 13071 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 645X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 09/27/2006 12:00:00 AM | 3 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | ||
| 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) | |||||
| 78767 | 78767 | 12056 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1330X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6016860.8582794005 | 2094712.6673543 | 37.732628043472 | -122.38405415096399 | (37.732628043472, -122.384054150964) | |||
| 78915 | 78915 | 114478 | Undocumented 2 | Washingtonia filifera :: California Fan Palm 189 | 45 HOFF ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6006591.0 | 2106401.0 | 37.7641484227608 | -122.420388955837 | (37.7641484227608, -122.420388955837) | ||||
| 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) | |||||
| 79113 | 79113 | 24925 | Permitted Site 1 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 2099X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/09/1996 12:00:00 AM | 6 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
| 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) | |||||
| 81054 | 81054 | 2804 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 50 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | |||
| 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) | |||||
| 84242 | 84242 | 99240 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 560X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10 | 4x4 | 6008281.0 | 2113828.0 | 37.784636297853105 | -122.415069452341 | (37.7846362978531, -122.415069452341) | |||
| 85540 | 85540 | 115541 | Undocumented 2 | Grevillea robusta :: Silk Oak Tree 145 | 780 DOUGLASS ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Rec/Park 3 | 24 | 3x3 | 6001139.0 | 2101871.0 | 37.7514014062737 | -122.43892114779301 | (37.7514014062737, -122.438921147793) | |||
| 85891 | 85891 | 26298 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/24/1997 12:00:00 AM | 3 | 3X3 | 5999917.070942 | 2092574.844182 | 37.7258067629719 | -122.442479358973 | (37.7258067629719, -122.442479358973) | ||
| 87911 | 87911 | 29065 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1001X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004375.703483 | 2111849.9138356997 | 37.7789847305516 | -122.42843943238 | (37.7789847305516, -122.42843943238) | ||
| 88029 | 88029 | 5481 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 700X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 80 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | |||
| 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) | |||||
| 88826 | 88826 | 22610 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X5 | 6005224.1346872 | 2112659.8569034003 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | |||
| 90660 | 90660 | 8490 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1950X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002386.446026901 | 2113776.6748133 | 37.7841623615489 | -122.435458932616 | (37.7841623615489, -122.435458932616) | |||
| 90787 | 90787 | 112647 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3100X 26TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5 | 3x3 | 6008747.0 | 2100981.0 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | |||
| 91603 | 91603 | 24685 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6599X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/02/1998 12:00:00 AM | 3 | 3X3 | 5986563.555448 | 2112507.5928897997 | 37.7797664796237 | -122.490106359303 | (37.7797664796237, -122.490106359303) | ||
| 92516 | 92516 | 101511 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 240X DRUMM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6013870.0 | 2117910.0 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | ||||
| 92526 | 92526 | 98417 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.43442509431299 | (37.7831064505465, -122.434425094313) | |||
| 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) | ||||
| 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) | |||||
| 94964 | 94964 | 8519 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.43780596128799 | (37.7836169980675, -122.437805961288) | |||
| 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) | ||||
| 97157 | 97157 | 9917 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1905X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3x3 | Permit Number 768908 | 6005198.982724099 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | ||
| 98214 | 98214 | 113797 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 695x SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 4x4 | 6008062.0 | 2103972.0 | 37.757561731467 | -122.415129229314 | (37.757561731467, -122.415129229314) | ||||
| 98696 | 98696 | 11137 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2455X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6006975.507678599 | 2120876.6023828997 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | |||
| 100130 | 100130 | 112151 | Undocumented 2 | Casurina stricta :: Beefwood: Drooping She-Oak 309 | 299x SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10 | 3x3 | 6007772.0 | 2106483.0 | 37.7644400562771 | -122.41631001514901 | (37.7644400562771, -122.416310015149) | |||
| 100807 | 100807 | 29067 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1091X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004816.84954 | 2112603.0518286 | 37.781077615403596 | -122.426966984587 | (37.7810776154036, -122.426966984587) | ||
| 100922 | 100922 | 104446 | Private 5 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2490X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
| 100994 | 100994 | 5461 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 600X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/11/2006 12:00:00 AM | 3 | 6 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||
| 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) | |||||
| 101740 | 101740 | 103168 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 9 | 3x4 | 5987451.7241 | 2103743.616 | 37.7557548552633 | -122.486390221731 | (37.7557548552633, -122.486390221731) | |||
| 101761 | 101761 | 101311 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4244X 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5 | 3x3 | 6001912.0 | 2104709.0 | 37.7592378221466 | -122.43645112889901 | (37.7592378221466, -122.436451128899) | |||
| 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) | |||||
| 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) | |||
| 106691 | 106691 | 25411 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 895X Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | |||
| 107282 | 107282 | 100095 | Permitted Site 1 | Tree(s) :: 17 | 4372 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | Private 3 | 07/03/2012 12:00:00 AM | 3x3 | Permit Number 769070 | 6001507.0 | 2100613.7 | 37.747970090970504 | -122.43755853273001 | (37.7479700909705, -122.43755853273) | |
| 109652 | 109652 | 113804 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 990X OSHAUGHNESSY BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 3x30 | 6000025.0 | 2096199.0 | 37.735764003208 | -122.442366322687 | (37.735764003208, -122.442366322687) | ||||
| 112463 | 112463 | 20462 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1202X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 10 | 5984687.1705981 | 2107256.1433531996 | 37.7652377447603 | -122.49620993463101 | (37.7652377447603, -122.496209934631) | |||
| 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) | |||||
| 114087 | 114087 | 20505 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1211X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
| 114266 | 114266 | 9773 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/25/1997 12:00:00 AM | 18 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.781492900843894 | -122.42399680548999 | (37.7814929008439, -122.42399680549) | ||
| 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) | |||
| 115377 | 115377 | 29070 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1050X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004796.752563099 | 2112456.6816498 | 37.7806745826486 | -122.427026081915 | (37.7806745826486, -122.427026081915) | ||
| 115558 | 115558 | 107125 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 350X 30TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 6x6 | 6004409.0 | 2098396.0 | 37.7420453649399 | -122.427365577216 | (37.7420453649399, -122.427365577216) | |||
| 115560 | 115560 | 109453 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 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) | ||
| 115936 | 115936 | 20480 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 115969 | 115969 | 20467 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1203X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 116607 | 116607 | 108953 | Undocumented 2 | Tree(s) :: 17 | 1401X GREAT HWY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823.0 | 2105507.0 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | |
| 119252 | 119252 | 116340 | Undocumented 2 | :: 54 | 201X Bright St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5993755.0695 | 2088847.02637 | 37.715217913096104 | -122.463510368547 | (37.7152179130961, -122.463510368547) | |||||
| 120223 | 120223 | 116140 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 120849 | 120849 | 113976 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 1180 STANYAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 120980 | 120980 | 100033 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 1 | 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) | |||
| 122160 | 122160 | 114736 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 435 LILY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 2x2 | 6004484.0 | 2109981.0 | 37.77385927942 | -122.427931581119 | (37.77385927942, -122.427931581119) | ||||
| 122322 | 122322 | 105909 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1864X 14TH AVE | 1 | Median : Yard 3 | Tree 1 | Rec/Park 3 | 14 | 5991829.0 | 2102804.0 | 37.7534290869332 | -122.47118388851999 | (37.7534290869332, -122.47118388852) | ||||
| 122770 | 122770 | 99243 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 570 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 9 | 4x4 | 6008204.0 | 2113818.0 | 37.784604512923 | -122.41533513918002 | (37.784604512923, -122.41533513918) | |||
| 123293 | 123293 | 102368 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 4 | Permit Number 769895 | 5984151.13176 | 2110133.93549 | 37.7731079279349 | -122.49827649972 | (37.7731079279349, -122.49827649972) | |||
| 123341 | 123341 | 117622 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 890x VERMONT ST | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 6011292.0 | 2104239.0 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | |||||
| 124786 | 124786 | 22398 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5 | 3X3 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | |||
| 125042 | 125042 | 98427 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.782170112299795 | -122.434235614198 | (37.7821701122998, -122.434235614198) | |||
| 126787 | 126787 | 23612 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 890X Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 30X30PL | 6011290.8652502 | 2104244.5269478 | 37.7584909549369 | -122.403981624636 | (37.7584909549369, -122.403981624636) | |||
| 128075 | 128075 | 120885 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6009830.0 | 2087548.0 | 37.7125641444482 | -122.407856615551 | (37.7125641444482, -122.407856615551) | ||||
| 128189 | 128189 | 8478 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | |||
| 138269 | 138269 | 116274 | Undocumented 2 | :: 54 | 700X Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 139264 | 139264 | 12049 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/17/2007 12:00:00 AM | 3 | 3x3 | 6016940.808513099 | 2094664.4394134998 | 37.7325000389111 | -122.38377438405399 | (37.7325000389111, -122.383774384054) | ||
| 139799 | 139799 | 111804 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 50X COLUMBIA SQUARE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 140221 | 140221 | 9790 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 40 | 3x3 | 6005630.9126204 | 2113075.2727516997 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | |||
| 140654 | 140654 | 27152 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1700X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 06/02/1999 12:00:00 AM | 6 | 3X3 | 6011020.5092245005 | 2095004.7366116 | 37.733105385033795 | -122.40426632243 | (37.7331053850338, -122.40426632243) | ||
| 142733 | 142733 | 103174 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2201 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||||
| 144403 | 144403 | 112127 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 145449 | 145449 | 20228 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1699 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002579.480222 | 2114044.5496622 | 37.784908839203204 | -122.43481026677 | (37.7849088392032, -122.43481026677) |
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");