Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 115704 | 115704 | 114985 | Planning Code 138.1 required 4 | Acer buergeranum :: Trident Maple 120 | 1188 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | Permit Number 773128 | 6003158.9 | 2101346.9 | 37.7500770674438 | -122.43189868142001 | (37.7500770674438, -122.43189868142) | |||
| 115673 | 115673 | 121464 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 2353 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001140.0 | 2119261.0 | 37.7991500226194 | -122.440164592168 | (37.7991500226194, -122.440164592168) | ||||
| 115120 | 115120 | 121546 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 114824 | 114824 | 122426 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000851.7 | 2114462.1 | 37.7859570793449 | -122.440817776746 | (37.7859570793449, -122.440817776746) | |
| 114500 | 114500 | 103695 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1X Hill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006027.79546 | 2103458.18152 | 37.756036378309105 | -122.42212783919399 | (37.7560363783091, -122.422127839194) | |
| 114291 | 114291 | 113655 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 901X JESSIE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2016 12:00:00 AM | 3 | 3x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |
| 113880 | 113880 | 115805 | Planning Code 138.1 required 4 | Pyrus kawakamii :: Evergreen Pear 82 | 872 Kansas St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | 3x3 | 6011546.4 | 2104246.9 | 37.758511744317296 | -122.40309803301201 | (37.7585117443173, -122.403098033012) | |||
| 113628 | 113628 | 116851 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 83 Panorama Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | |||
| 112854 | 112854 | 113649 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 98X 10TH ST | 1 | 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) | |||
| 112639 | 112639 | 64697 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1X Hill St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006319.44787647 | 2103419.18592492 | 37.7559457511246 | -122.421116437378 | (37.7559457511246, -122.421116437378) | |
| 112546 | 112546 | 121517 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 300 Folsom St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 110900 | 110900 | 118361 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1600X Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | Permit Number 773331 | 6005773.765380001 | 2115716.99395 | 37.789681792424105 | -122.42387802240101 | (37.7896817924241, -122.423878022401) | ||
| 110506 | 110506 | 44005 | Planning Code 138.1 required 4 | Jacaranda mimosifolia :: Jacaranda 52 | 2701X 17th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.41044985886299 | (37.7642662704227, -122.410449858863) | ||
| 110233 | 110233 | 43569 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 601 29TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2000 12:00:00 AM | 3x3 | Permit Number 43230 | 6002630.6 | 2098839.9 | 37.743163470374895 | -122.43354642924999 | (37.7431634703749, -122.43354642925) | ||
| 109947 | 109947 | 120109 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 555 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2016 12:00:00 AM | 3 | 3x3 | 5997970.0 | 2087042.0 | 37.7105036758619 | -122.44881186315901 | (37.7105036758619, -122.448811863159) | ||
| 109588 | 109588 | 113335 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2X STANFORD ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727.0 | 2112481.0 | 37.781297869167396 | -122.392674013487 | (37.7812978691674, -122.392674013487) | ||
| 109208 | 109208 | 118376 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 109130 | 109130 | 119808 | Planning Code 138.1 required 4 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773331 | 6006048.0 | 2115627.0 | 37.789450169199796 | -122.422922798032 | (37.7894501691998, -122.422922798032) | |
| 108427 | 108427 | 113652 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 98X 10TH ST | 4 | 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) | |||
| 107526 | 107526 | 120527 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1672 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/2016 12:00:00 AM | 3 | 3x3 | 5981030.0 | 2103685.0 | 37.7552175094175 | -122.508593851446 | (37.7552175094175, -122.508593851446) | ||
| 107442 | 107442 | 113644 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |
| 107374 | 107374 | 103379 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 2712 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770136 | 6000520.0 | 2117210.0 | 37.793483200790895 | -122.44216269001001 | (37.7934832007909, -122.44216269001) | |
| 106915 | 106915 | 113654 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 98X 10TH ST | 6 | 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) | |||
| 106734 | 106734 | 5313 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 1785 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770253 | 6001045.0 | 2114480.0 | 37.786017234839 | -122.440150297316 | (37.786017234839, -122.440150297316) | |
| 106586 | 106586 | 121542 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 105015 | 105015 | 112975 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4099x ULLOA ST | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773327 | 5983385.0 | 2098079.0 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | ||
| 104211 | 104211 | 112085 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 99X Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.790527840543795 | -122.396700174955 | (37.7905278405438, -122.396700174955) | |||
| 104169 | 104169 | 115503 | Planning Code 138.1 required 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2901 25th St | 72 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777487 | 6010040.72394239 | 2101604.72592715 | 37.751172725188106 | -122.408119020981 | (37.7511727251881, -122.408119020981) | |
| 104148 | 104148 | 113647 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |
| 103900 | 103900 | 117456 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 236 SHIPLEY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 776408 | 6011519.0 | 2111785.0 | 37.779208125695604 | -122.403723194086 | (37.7792081256956, -122.403723194086) | ||
| 103314 | 103314 | 120914 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1356 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2016 12:00:00 AM | 3 | 3x3 | 5989939.0 | 2106143.0 | 37.7624875866057 | -122.477963922005 | (37.7624875866057, -122.477963922005) | ||
| 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) | |||
| 101885 | 101885 | 122625 | Planning Code 138.1 required 4 | Cordyline australis :: Dracena Palm 141 | 189 Country Club Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/15/2016 12:00:00 AM | 3 | 4x5 | Permit Number 774974 | 5984222.0 | 2094938.0 | 37.731388248087605 | -122.496909587532 | (37.7313882480876, -122.496909587532) | |
| 101883 | 101883 | 122422 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000851.7 | 2114462.1 | 37.7859570793449 | -122.440817776746 | (37.7859570793449, -122.440817776746) | |
| 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) | ||||
| 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) | |||
| 101502 | 101502 | 111713 | Planning Code 138.1 required 4 | Lagunaria patersonii :: Primrose Tree 48 | 3038 CLEMENT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051.0 | 2113265.0 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | |
| 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) | ||||
| 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) | ||||
| 101113 | 101113 | 113643 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1400 MISSION ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2016 12:00:00 AM | 3 | 4x6 | Permit Number 773574 | 6007947.0 | 2110424.0 | 37.7752709556829 | -122.415983842901 | (37.7752709556829, -122.415983842901) | |
| 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) | ||||
| 101006 | 101006 | 122699 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 98 Woolsey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2016 12:00:00 AM | 3 | 3x3 | 6011441.9927199995 | 2092150.08828 | 37.725290657742 | -122.402608459524 | (37.725290657742, -122.402608459524) | ||
| 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) | ||||
| 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) | ||||
| 99298 | 99298 | 79418 | Planning Code 138.1 required 4 | Brahea edulis :: Guadalupe Palm 115 | 1746 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2001 12:00:00 AM | 3x3 | 5981053.87958296 | 2103176.2415425 | 37.7538220108937 | -122.508473505042 | (37.7538220108937, -122.508473505042) | |||
| 98871 | 98871 | 73589 | Planning Code 138.1 required 4 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 468 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/1995 12:00:00 AM | 12 | 3x3 | Permit Number 770905 | 6010928.13640467 | 2111848.51157587 | 37.7793494887795 | -122.405771720076 | (37.7793494887795, -122.405771720076) | |
| 98533 | 98533 | 119286 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 400 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2016 12:00:00 AM | 3 | 4x4 | 6005873.0 | 2111410.0 | 37.777861449140204 | -122.423228396467 | (37.7778614491402, -122.423228396467) | ||
| 98279 | 98279 | 120680 | Planning Code 138.1 required 4 | Lagunaria patersonii :: Primrose Tree 48 | 522 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2016 12:00:00 AM | 3 | 3x3 | 6003717.0 | 2090174.0 | 37.719430440149104 | -122.42917217063999 | (37.7194304401491, -122.42917217064) | ||
| 97542 | 97542 | 122425 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000851.7 | 2114462.1 | 37.7859570793449 | -122.440817776746 | (37.7859570793449, -122.440817776746) | |
| 97256 | 97256 | 94315 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 399X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008122.0 | 2112982.0 | 37.7823044496932 | -122.415559622955 | (37.7823044496932, -122.415559622955) | |
| 97171 | 97171 | 60705 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 963 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/1983 12:00:00 AM | 1 | 3x3 | Permit Number 20354 | 6009178.18020232 | 2103559.73737881 | 37.7564924147418 | -122.4112398899 | (37.7564924147418, -122.4112398899) | |
| 97156 | 97156 | 115962 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 209 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2016 12:00:00 AM | 3 | 3x3 | 5997642.1 | 2106419.3 | 37.7636903209387 | -122.451341781368 | (37.7636903209387, -122.451341781368) | ||
| 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) | ||||
| 96576 | 96576 | 115405 | Planning Code 138.1 required 4 | Podocarpus macrophyllus :: Yew Pine 168 | 2050 43RD AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/29/2016 12:00:00 AM | 3 | 3x3 | 5982969.0 | 2101168.0 | 37.7484206232379 | -122.50170211889 | (37.7484206232379, -122.50170211889) | ||
| 96115 | 96115 | 121093 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 150 Ridgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778915 | 5996816.77701 | 2094570.7008900002 | 37.7311097051787 | -122.453340820219 | (37.7311097051787, -122.453340820219) | |
| 95999 | 95999 | 122427 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000851.7 | 2114462.1 | 37.7859570793449 | -122.440817776746 | (37.7859570793449, -122.440817776746) | |
| 95941 | 95941 | 119257 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 191 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2016 12:00:00 AM | 3 | 3x3 | 6010220.0 | 2098811.0 | 37.743511802413 | -122.407302138847 | (37.743511802413, -122.407302138847) | ||
| 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) | |||
| 95123 | 95123 | 17757 | Planning Code 138.1 required 4 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773331 | 6005917.49192 | 2115584.99362 | 37.7893274652545 | -122.42337135467699 | (37.7893274652545, -122.423371354677) | |
| 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) | ||||
| 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) | ||||
| 91500 | 91500 | 122697 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 98 Woolsey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2016 12:00:00 AM | 3 | 3x3 | 6011441.9927199995 | 2092150.08828 | 37.725290657742 | -122.402608459524 | (37.725290657742, -122.402608459524) | ||
| 91141 | 91141 | 67994 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 241 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776577 | 5994615.10957021 | 2088996.30431809 | 37.7156773106674 | -122.460548527933 | (37.7156773106674, -122.460548527933) | |
| 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) | ||||
| 90957 | 90957 | 112973 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4099x ULLOA ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773327 | 5983385.0 | 2098079.0 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | ||
| 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) | ||||
| 90620 | 90620 | 116853 | Planning Code 138.1 required 4 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | 3X3 | Permit Number 773331 | 6005973.81147 | 2115593.81965 | 37.7893548777914 | -122.423177122971 | (37.7893548777914, -122.423177122971) | |
| 90462 | 90462 | 121463 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 415 Oxford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778984 | 6006773.54328 | 2092061.7240000002 | 37.7247862819155 | -122.418740608563 | (37.7247862819155, -122.418740608563) | |
| 89451 | 89451 | 115539 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x10 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) | |
| 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) | ||||
| 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) | ||||
| 89046 | 89046 | 120132 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006324.60427 | 2103454.53368 | 37.7560430985606 | -122.42110111460899 | (37.7560430985606, -122.421101114609) | |
| 88750 | 88750 | 115493 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 280 BRIGHTON AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259.0 | 2091739.0 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | |
| 88619 | 88619 | 107647 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1600X Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | Permit Number 773331 | 6005773.765380001 | 2115716.99395 | 37.789681792424105 | -122.42387802240101 | (37.7896817924241, -122.423878022401) | ||
| 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) | ||||
| 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) | ||||
| 86819 | 86819 | 15237 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | 3X3 | Permit Number 770747 | 6008256.52807 | 2110680.03106 | 37.7759913537931 | -122.414931236282 | (37.7759913537931, -122.414931236282) | |
| 86420 | 86420 | 113721 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1526 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2015 12:00:00 AM | 3x3 | 5989360.0 | 2104938.6 | 37.7591470062831 | -122.479878309336 | (37.7591470062831, -122.479878309336) | |||
| 86220 | 86220 | 124718 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 610 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2016 12:00:00 AM | 3 | 3x3 | Permit Number 775784 | 6007724.21349 | 2097196.46477 | 37.738938646129704 | -122.41581766964899 | (37.7389386461297, -122.415817669649) | |
| 85844 | 85844 | 44010 | Planning Code 138.1 required 4 | Jacaranda mimosifolia :: Jacaranda 52 | 405x Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.41044985886299 | (37.7642662704227, -122.410449858863) | ||
| 84996 | 84996 | 15236 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 3 | 3X3 | Permit Number 770747 | 6008261.49106 | 2110663.4843099997 | 37.7759461992201 | -122.41491289655599 | (37.7759461992201, -122.414912896556) | |
| 84834 | 84834 | 115491 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 280 BRIGHTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259.0 | 2091739.0 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | |
| 84622 | 84622 | 121145 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 962 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 5995080.0 | 2090346.0 | 37.7194099895512 | -122.45903933602399 | (37.7194099895512, -122.459039336024) | ||
| 84353 | 84353 | 115886 | Planning Code 138.1 required 4 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 134 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | 2x4 | Permit Number 772714 | 5991633.6 | 2092401.5 | 37.7248551637156 | -122.471101821397 | (37.7248551637156, -122.471101821397) | |
| 84286 | 84286 | 82615 | Planning Code 138.1 required 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2901 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777487 | 6010040.72394239 | 2101604.72592715 | 37.751172725188106 | -122.408119020981 | (37.7511727251881, -122.408119020981) | |
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 83281 | 83281 | 107646 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1600X Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | Permit Number 773331 | 6005773.765380001 | 2115716.99395 | 37.789681792424105 | -122.42387802240101 | (37.7896817924241, -122.423878022401) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 81719 | 81719 | 112974 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4099x ULLOA ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773327 | 5983385.0 | 2098079.0 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | ||
| 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) | ||||
| 81046 | 81046 | 113699 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 239 Minerva St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778180 | 5994635.15348587 | 2088996.04011087 | 37.715677738331706 | -122.460479228374 | (37.7156777383317, -122.460479228374) | |
| 80444 | 80444 | 112854 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2622 JUDAH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 774112 | 5986417.0 | 2105735.0 | 37.7611622818619 | -122.49011505097 | (37.7611622818619, -122.49011505097) | ||
| 80040 | 80040 | 53968 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1354 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773113 | 5988678.33594659 | 2106104.92629407 | 37.762309795805294 | -122.48232125545799 | (37.7623097958053, -122.482321255458) | ||
| 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) | ||||
| 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) | ||||
| 78927 | 78927 | 115540 | Planning Code 138.1 required 4 | Crataegus laevigata :: English Hawthorn 66 | 99X Lech Walesa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 3x5 | Permit Number 770842 | 6007116.502280001 | 2111387.72892 | 37.7778703965252 | -122.41892509804701 | (37.7778703965252, -122.418925098047) |
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");