Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14 | 14 | 196590 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 43 Lafayette St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | Permit Number 772992 | 6007565.6944699995 | 2109618.27361 | 37.773037177355796 | -122.41724576098301 | (37.7730371773558, -122.417245760983) | ||
| 15 | 15 | 196591 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 43 Lafayette St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | Permit Number 772992 | 6007555.65106 | 2109624.06249 | 37.7730525072055 | -122.417280912782 | (37.7730525072055, -122.417280912782) | ||
| 20 | 20 | 251179 | Planning Code 138.1 required 4 | Podocarpus gracilor :: Fern Pine 13 | 1043 Minna St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6007668.0 | 2109797.0 | 37.7735336727503 | -122.41690453761002 | (37.7735336727503, -122.41690453761) | ||||
| 21 | 21 | 251178 | Planning Code 138.1 required 4 | Podocarpus gracilor :: Fern Pine 13 | 1043 Minna St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6007668.0 | 2109797.0 | 37.7735336727503 | -122.41690453761002 | (37.7735336727503, -122.41690453761) | ||||
| 30 | 30 | 196592 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 43 Lafayette St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | Permit Number 772992 | 6007533.59843 | 2109642.31042 | 37.7731013709756 | -122.41735848920901 | (37.7731013709756, -122.417358489209) | ||
| 139 | 139 | 116640 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |||
| 425 | 425 | 251299 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 431 | 431 | 251298 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 432 | 432 | 251297 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 446 | 446 | 251296 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 2190X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | ||||
| 518 | 518 | 251314 | Planning Code 138.1 required 4 | :: 54 | 1108 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001901.0 | 2100825.0 | 37.7485726639367 | -122.43621121860001 | (37.7485726639367, -122.4362112186) | ||||
| 533 | 533 | 251313 | Planning Code 138.1 required 4 | :: 54 | 390 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2099547.0 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | ||||
| 721 | 721 | 183636 | Planning Code 138.1 required 4 | Pittosporum crassifolium :: Karo Tree 108 | 1478 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 3x9 | 5981570.9282 | 2105017.3718 | 37.7589076903569 | -122.506822015648 | (37.7589076903569, -122.506822015648) | |||
| 977 | 977 | 242613 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 48 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | Permit Number 777782 | 6007306.44134 | 2099195.30791 | 37.744403529591395 | -122.417403753004 | (37.7444035295914, -122.417403753004) | ||
| 1388 | 1388 | 251519 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1395 | 1395 | 251525 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 173 Sanchez St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1401 | 1401 | 251523 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1413 | 1413 | 246406 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | |||
| 1414 | 1414 | 251524 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1416 | 1416 | 251521 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1425 | 1425 | 251522 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1433 | 1433 | 251520 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
| 1451 | 1451 | 251539 | Planning Code 138.1 required 4 | Brahea edulis :: Guadalupe Palm 115 | 1746 Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5981086.0 | 2103156.0 | 37.753768326371 | -122.50836092480499 | (37.753768326371, -122.508360924805) | ||||
| 1934 | 1934 | 252840 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 80 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997842.0 | 2113206.0 | 37.782336294689 | -122.45113984781099 | (37.782336294689, -122.451139847811) | ||||
| 2257 | 2257 | 229627 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 3662 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008456.11159 | 2097816.22885 | 37.7406815009641 | -122.41333091228701 | (37.7406815009641, -122.413330912287) | |||
| 2759 | 2759 | 253203 | Planning Code 138.1 required 4 | Acer buergeranum :: Trident Maple 120 | 349 Mangels Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999103.0 | 2095207.0 | 37.732987611392005 | -122.44548271607799 | (37.732987611392, -122.445482716078) | ||||
| 3179 | 3179 | 253343 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 200 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | Permit Number 778434 | 5995550.1802199995 | 2114806.2223 | 37.786598594028504 | -122.459184390305 | (37.7865985940285, -122.459184390305) | |||
| 3189 | 3189 | 253342 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 200 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | Permit Number 778434 | 5995550.1802199995 | 2114806.2223 | 37.786598594028504 | -122.459184390305 | (37.7865985940285, -122.459184390305) | |||
| 3255 | 3255 | 253377 | Planning Code 138.1 required 4 | :: 54 | 2 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001556.0 | 2108661.0 | 37.7700688079313 | -122.43796542225 | (37.7700688079313, -122.43796542225) | ||||
| 3275 | 3275 | 253378 | Planning Code 138.1 required 4 | :: 54 | 2 Alpine Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001556.0 | 2108661.0 | 37.7700688079313 | -122.43796542225 | (37.7700688079313, -122.43796542225) | ||||
| 3345 | 3345 | 253419 | Planning Code 138.1 required 4 | :: 54 | 3499 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997570.0 | 2115996.0 | 37.78998131889129 | -122.452282225129 | (37.7899813188913, -122.452282225129) | ||||
| 3497 | 3497 | 247942 | Planning Code 138.1 required 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 29 Joy St | 5 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3 | Permit Number 775404 | 6010292.72224 | 2098904.67919 | 37.7437730949632 | -122.40705728398399 | (37.7437730949632, -122.407057283984) | |||
| 3501 | 3501 | 247943 | Planning Code 138.1 required 4 | Maytenus boaria :: Mayten 22 | 29 Joy St | 6 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 2 | Permit Number 775404 | 6010304.2598 | 2098903.51059 | 37.7437705318851 | -122.407017307297 | (37.7437705318851, -122.407017307297) | |||
| 3506 | 3506 | 247939 | Planning Code 138.1 required 4 | Quercus agrifolia :: Coast Live Oak 180 | 29 Joy St | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 12 | Permit Number 775404 | 6010258.299769999 | 2098917.5156900003 | 37.7438064148349 | -122.40717721395 | (37.7438064148349, -122.40717721395) | |||
| 3510 | 3510 | 247941 | Planning Code 138.1 required 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 29 Joy St | 4 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 5 | Permit Number 775404 | 6010287.82636 | 2098909.7574 | 37.743786764646 | -122.40707457072901 | (37.743786764646, -122.407074570729) | |||
| 3511 | 3511 | 247940 | Planning Code 138.1 required 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 29 Joy St | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 5 | Permit Number 775404 | 6010280.31746 | 2098909.2881400003 | 37.7437850559498 | -122.407100501782 | (37.7437850559498, -122.407100501782) | |||
| 3513 | 3513 | 247938 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 29 Joy St | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 9 | Permit Number 775404 | 6010254.90659 | 2098918.71089 | 37.7438095066969 | -122.407189031056 | (37.7438095066969, -122.407189031056) | |||
| 3523 | 3523 | 253474 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
| 3809 | 3809 | 95203 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 314 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3x3 | Permit Number 769992 | 5998598.6333800005 | 2115400.1597599997 | 37.7884041728517 | -122.44868032474 | (37.7884041728517, -122.44868032474) | ||
| 4369 | 4369 | 222216 | Planning Code 138.1 required 4 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2 Van Buren St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 3ft | Permit Number 780743 | 6002014.89564 | 2096488.79408 | 37.7366729276156 | -122.435507211887 | (37.7366729276156, -122.435507211887) | ||
| 4385 | 4385 | 224618 | Planning Code 138.1 required 4 | Ficus microcarpa :: Chinese Banyan 94 | 165 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 3ft | Permit Number 780743 | 6001936.24436 | 2096476.10277 | 37.7366336128599 | -122.435778235198 | (37.7366336128599, -122.435778235198) | ||
| 4401 | 4401 | 239088 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 3855 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3x3 | Permit Number 780732 | 6004794.15723 | 2100737.4007099997 | 37.748496089721996 | -122.426200479689 | (37.748496089722, -122.426200479689) | ||
| 5050 | 5050 | 253762 | Planning Code 138.1 required 4 | :: 54 | 520 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993490.0 | 2111935.0 | 37.778596343165496 | -122.46610332918101 | (37.7785963431655, -122.466103329181) | ||||
| 7118 | 7118 | 120115 | Planning Code 138.1 required 4 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2225 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6000127.238390001 | 2120216.52423 | 37.801715927006796 | -122.443737765003 | (37.8017159270068, -122.443737765003) | |||
| 9718 | 9718 | 105047 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 278 Capitol Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995102.4 | 2087946.7 | 37.7128233663074 | -122.458788296392 | (37.7128233663074, -122.458788296392) | |||||
| 10157 | 10157 | 173899 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 1762 12th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | |||
| 10163 | 10163 | 173898 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 1762 12th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | |||
| 12646 | 12646 | 115976 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011653.53869 | 2091254.58415 | 37.7228435956385 | -122.401814242757 | (37.7228435956385, -122.401814242757) | |||
| 13325 | 13325 | 187677 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13326 | 13326 | 187676 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13332 | 13332 | 187674 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13335 | 13335 | 187678 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13336 | 13336 | 187675 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13337 | 13337 | 187679 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13578 | 13578 | 187698 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2880 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008980.17665 | 2103937.78959 | 37.757519353838795 | -122.41195137385 | (37.7575193538388, -122.41195137385) | ||||
| 14383 | 14383 | 118374 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x6 | 6014693.17098 | 2114681.8097099997 | 37.787338911495 | -122.392945071183 | (37.787338911495, -122.392945071183) | |||
| 14706 | 14706 | 117455 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 236 Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 776408 | 6011503.45491 | 2111758.7875900003 | 37.7791352841027 | -122.403775126323 | (37.7791352841027, -122.403775126323) | ||
| 16171 | 16171 | 117453 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 236 Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 776408 | 6011539.59396 | 2111788.0027 | 37.779217520823 | -122.403652162024 | (37.779217520823, -122.403652162024) | ||
| 22895 | 22895 | 251140 | Planning Code 138.1 required 4 | Olea Majestic Beauty :: 192 | 138 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996904.98449 | 2113495.29925 | 37.783076941712 | -122.45440239324499 | (37.783076941712, -122.454402393245) | ||||
| 26030 | 26030 | 118375 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 4x6 | 6014712.487269999 | 2114662.02755 | 37.7872856671566 | -122.392876855803 | (37.7872856671566, -122.392876855803) | |||
| 26519 | 26519 | 115980 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2x Olmstead St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6011593.71434 | 2091235.60939 | 37.722788156028706 | -122.402019710862 | (37.7227881560287, -122.402019710862) | |||
| 27515 | 27515 | 109465 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x4 | Permit Number 773752 | 6013321.87847 | 2109385.26551 | 37.772719547604495 | -122.397317921189 | (37.7727195476045, -122.397317921189) | ||
| 35251 | 35251 | 121502 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014428.99687 | 2115060.94265 | 37.7883652457059 | -122.393885614549 | (37.7883652457059, -122.393885614549) | |||
| 38160 | 38160 | 121504 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014396.4001 | 2115093.29031 | 37.7884522533286 | -122.39400066032499 | (37.7884522533286, -122.394000660325) | |||
| 46526 | 46526 | 109467 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | Permit Number 773752 | 6013285.76594 | 2109350.55221 | 37.7726222220803 | -122.39744040434601 | (37.7726222220803, -122.397440404346) | ||
| 46572 | 46572 | 121505 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014377.50413 | 2115113.61118 | 37.7885069995398 | -122.394067461056 | (37.7885069995398, -122.394067461056) | |||
| 60824 | 60824 | 121501 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014441.60375 | 2115047.86993 | 37.7883300516388 | -122.39384108102101 | (37.7883300516388, -122.393841081021) | |||
| 65429 | 65429 | 109468 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 4x4 | Permit Number 773752 | 6013267.70036 | 2109332.73182 | 37.7725722854256 | -122.397501645497 | (37.7725722854256, -122.397501645497) | ||
| 66090 | 66090 | 121506 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 300 Folsom St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 3x3 | 6012227.3168 | 2112699.1751 | 37.7817577819585 | -122.40133708037901 | (37.7817577819585, -122.401337080379) | |||
| 77524 | 77524 | 113650 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 98X 10TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |||
| 78293 | 78293 | 118379 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 78406 | 78406 | 120519 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 520 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010156.0 | 2108818.0 | 37.7709851997146 | -122.40822907662901 | (37.7709851997146, -122.408229076629) | ||||
| 78470 | 78470 | 121547 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 79001 | 79001 | 115079 | Planning Code 138.1 required 4 | Brahea edulis :: Guadalupe Palm 115 | 1746 Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5981053.87958296 | 2103176.2415425 | 37.7538220108937 | -122.508473505042 | (37.7538220108937, -122.508473505042) | ||||
| 79273 | 79273 | 121543 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 81075 | 81075 | 121531 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 82070 | 82070 | 121539 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 201 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 82603 | 82603 | 116967 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 480 Potrero Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010335.4704597 | 2106068.8961361 | 37.7634468367565 | -122.407414438937 | (37.7634468367565, -122.407414438937) | ||||
| 82889 | 82889 | 114908 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 281 LOBOS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994225.0 | 2088676.0 | 37.714775380268996 | -122.461873702271 | (37.714775380269, -122.461873702271) | ||||
| 83448 | 83448 | 121513 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 83570 | 83570 | 118377 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 83676 | 83676 | 121526 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 86944 | 86944 | 118378 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 87909 | 87909 | 121515 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 89423 | 89423 | 121518 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 89450 | 89450 | 118380 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 90872 | 90872 | 121545 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 91130 | 91130 | 120518 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 520 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010156.0 | 2108818.0 | 37.7709851997146 | -122.40822907662901 | (37.7709851997146, -122.408229076629) | ||||
| 91523 | 91523 | 121514 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 91964 | 91964 | 121522 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 280 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 95753 | 95753 | 113653 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 98X 10TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |||
| 97096 | 97096 | 121521 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 99977 | 99977 | 121510 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 100921 | 100921 | 121512 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 101034 | 101034 | 121516 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 101133 | 101133 | 121511 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 101224 | 101224 | 121527 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 101696 | 101696 | 121525 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | |||
| 101714 | 101714 | 121533 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 103215 | 103215 | 116528 | Planning Code 138.1 required 4 | :: 54 | 125 CROWN TER | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 3x3 | 5998841.0 | 2104182.0 | 37.7576158290564 | -122.447034160915 | (37.7576158290564, -122.447034160915) |
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");