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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17607 | 17607 | 1217 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 3501 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/2016 12:00:00 AM | 3 | 3x3 | 5993695.72185 | 2087421.0982400002 | 37.711299234146296 | -122.463612070865 | (37.7112992341463, -122.463612070865) | ||
| 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) | |
| 1432 | 1432 | 14312 | Planning Code 138.1 required 4 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 2190X Market St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/2017 12:00:00 AM | 3 | 4X4 | Permit Number 779911 | 6003624.7851 | 2107240.8343 | 37.766286807234295 | -122.430708166736 | (37.7662868072343, -122.430708166736) | |
| 1406 | 1406 | 14313 | Planning Code 138.1 required 4 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 2190X Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/2017 12:00:00 AM | 3 | 4X4 | Permit Number 779911 | 6003603.86 | 2107219.9092 | 37.7662281664546 | -122.43077904924299 | (37.7662281664546, -122.430779049243) | |
| 145330 | 145330 | 15235 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | 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) | |
| 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) | |
| 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) | |
| 16618 | 16618 | 15246 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770901 | 6007883.54199 | 2110310.54573 | 37.774955869255706 | -122.41619532227101 | (37.7749558692557, -122.416195322271) | |
| 16367 | 16367 | 15247 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770901 | 6007902.55668 | 2110326.57547 | 37.77500095226429 | -122.416130681693 | (37.7750009522643, -122.416130681693) | |
| 13838 | 13838 | 15248 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770901 | 6007914.867219999 | 2110337.26914 | 37.7750310067149 | -122.41608885424 | (37.7750310067149, -122.41608885424) | |
| 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) | |
| 16888 | 16888 | 18349 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 480 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6010310.27618 | 2106136.10948 | 37.763629979170496 | -122.40750631726101 | (37.7636299791705, -122.407506317261) | ||
| 14031 | 14031 | 18353 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 480 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2013 12:00:00 AM | 3 | 3x3 | 6010310.709559999 | 2106111.3358 | 37.76356198052329 | -122.407503071611 | (37.7635619805233, -122.407503071611) | ||
| 138370 | 138370 | 23050 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1058 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006261.27662 | 2103419.73409 | 37.7559439767922 | -122.421317651992 | (37.7559439767922, -122.421317651992) | |
| 9814 | 9814 | 29017 | Planning Code 138.1 required 4 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 120 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2014 12:00:00 AM | 6 | 3x3 | Permit Number 770901 | 6008044.5664857 | 2110308.5131992 | 37.7749593412658 | -122.415638158484 | (37.7749593412658, -122.415638158484) | |
| 4900 | 4900 | 31068 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 1450 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007659.7746 | 2107385.50696 | 37.7669118184545 | -122.41676211549999 | (37.7669118184545, -122.4167621155) | |
| 8908 | 8908 | 33111 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 2626 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | 3 | 4x4 | Permit Number 769981 | 6000363.34088 | 2118561.77591 | 37.797185891667105 | -122.442801853125 | (37.7971858916671, -122.442801853125) | |
| 8186 | 8186 | 35487 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000866.3431 | 2114483.9624 | 37.7860179417845 | -122.440768684557 | (37.7860179417845, -122.440768684557) | |
| 3858 | 3858 | 35488 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | Permit Number 770253 | 6000772.5656 | 2114469.8149 | 37.7859737553806 | -122.441092113094 | (37.7859737553806, -122.441092113094) | ||
| 9781 | 9781 | 36044 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3030 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008531.98185334 | 2106261.58493121 | 37.763874807614606 | -122.413665776536 | (37.7638748076146, -122.413665776536) | |
| 9807 | 9807 | 36045 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3030 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008531.98185334 | 2106261.58493121 | 37.763874807614606 | -122.413665776536 | (37.7638748076146, -122.413665776536) | |
| 151101 | 151101 | 39246 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3524 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | 1 | Permit Number 772836 | 5997390.1418 | 2116079.3582900004 | 37.7901998932662 | -122.452910535096 | (37.7901998932662, -122.452910535096) | ||
| 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) | ||
| 124504 | 124504 | 44001 | Planning Code 138.1 required 4 | Jacaranda mimosifolia :: Jacaranda 52 | 2701X 17th St | 5 | 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) | ||
| 78162 | 78162 | 44003 | Planning Code 138.1 required 4 | Jacaranda mimosifolia :: Jacaranda 52 | 2701X 17th St | 9 | 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) | ||
| 143265 | 143265 | 44004 | Planning Code 138.1 required 4 | Jacaranda mimosifolia :: Jacaranda 52 | 2701X 17th St | 8 | 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) | ||
| 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) | ||
| 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) | ||
| 143793 | 143793 | 44012 | Planning Code 138.1 required 4 | Jacaranda mimosifolia :: Jacaranda 52 | 405X Florida St | 1 | 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) | ||
| 145619 | 145619 | 44013 | Planning Code 138.1 required 4 | Jacaranda mimosifolia :: Jacaranda 52 | 2701X 17th St | 6 | 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) | ||
| 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) | ||
| 23422 | 23422 | 54948 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1531 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/1972 12:00:00 AM | 15 | 6x3 | Permit Number 779312 | 5982470.8167 | 2104681.2673 | 37.758037793894204 | -122.503684942327 | (37.7580377938942, -122.503684942327) | |
| 9959 | 9959 | 57959 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 336 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 774423 | 5999490.29697456 | 2086502.70799744 | 37.7091097236101 | -122.443518692288 | (37.7091097236101, -122.443518692288) | |
| 13498 | 13498 | 60261 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2495 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2015 12:00:00 AM | 12 | 3x3 | Permit Number 776014 | 6008888.61229415 | 2103948.71328851 | 37.7575442102667 | -122.41226881345301 | (37.7575442102667, -122.412268813453) | |
| 13329 | 13329 | 60277 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2690 Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51145 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||
| 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) | |
| 9823 | 9823 | 63407 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2125 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770314 | 6000344.0086 | 2116075.3402400003 | 37.790357690994504 | -122.442690122255 | (37.7903576909945, -122.442690122255) | |
| 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) | |
| 403 | 403 | 65940 | Planning Code 138.1 required 4 | Liquidambar styraciflua :: American Sweet Gum 62 | 620 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 8 | Permit Number 28961 | 6007431.46715 | 2113367.23378 | 37.78332336932171 | -122.41797588370702 | (37.7833233693217, -122.417975883707) | |
| 8122 | 8122 | 65944 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 1051 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774496 | 6007126.88528 | 2114657.80083 | 37.7868498044193 | -122.419121190999 | (37.7868498044193, -122.419121190999) | |
| 128502 | 128502 | 66394 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 504 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2016 12:00:00 AM | 3 | 3x4 | Permit Number 772815 | 6007447.25872729 | 2096493.62336554 | 37.7369932248849 | -122.41672547553001 | (37.7369932248849, -122.41672547553) | |
| 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) | |
| 139787 | 139787 | 68987 | Planning Code 138.1 required 4 | Cordyline australis :: Dracena Palm 141 | 767 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2016 12:00:00 AM | 3 | 10x10 | Permit Number 775182 | 5999291.63198947 | 2121477.34728573 | 37.8051301110493 | -122.44672010757 | (37.8051301110493, -122.44672010757) | |
| 9630 | 9630 | 72480 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 138 | 138 | 72565 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/16/1996 12:00:00 AM | 3 | 4x4 | Permit Number 770847 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |
| 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) | |
| 9623 | 9623 | 75842 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 9633 | 9633 | 75872 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 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) | |||
| 116647 | 116647 | 81972 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1822 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2015 12:00:00 AM | 3 | 3x6 | Permit Number 774361 | 5989407.90008391 | 2102936.76390687 | 37.7536532824256 | -122.47956618379699 | (37.7536532824256, -122.479566183797) | |
| 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) | |
| 361 | 361 | 85803 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 923 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778048 | 6011427.0378 | 2111936.1074 | 37.779617893816 | -122.40405196806002 | (37.779617893816, -122.40405196806) | |
| 394 | 394 | 85804 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 923 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778048 | 6011441.4589 | 2111949.4191 | 37.7796552503769 | -122.404003016031 | (37.7796552503769, -122.404003016031) | |
| 350 | 350 | 85805 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011627.0 | 2111882.0 | 37.77948049775679 | -122.40335640121799 | (37.7794804977568, -122.403356401218) | |
| 384 | 384 | 85806 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011627.0 | 2111882.0 | 37.77948049775679 | -122.40335640121799 | (37.7794804977568, -122.403356401218) | |
| 387 | 387 | 85807 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604.0 | 2111950.0 | 37.779665925350706 | -122.40344075372101 | (37.7796659253507, -122.403440753721) | |
| 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) | |
| 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) | ||
| 78883 | 78883 | 98406 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 237 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778181 | 5994692.2 | 2088928.8 | 37.7154963945459 | -122.46027718208401 | (37.7154963945459, -122.460277182084) | |
| 133773 | 133773 | 101942 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 537 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 2 | 2x4 | Permit Number 769476 | 6010108.2937199995 | 2111885.47528 | 37.7794051005107 | -122.408610520167 | (37.7794051005107, -122.408610520167) | |
| 1602 | 1602 | 102429 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 200 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010552.49087 | 2111923.99595 | 37.7795357369219 | -122.40707656363399 | (37.7795357369219, -122.407076563634) | |
| 1601 | 1601 | 102430 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 200 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010566.09371 | 2111909.33227 | 37.779496235110706 | -122.407028471514 | (37.7794962351107, -122.407028471514) | |
| 3823 | 3823 | 102525 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 310 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2013 12:00:00 AM | 0 | 3x3 | Permit Number 769739 | 5998596.991169999 | 2115413.44206 | 37.7884405486385 | -122.448686963531 | (37.7884405486385, -122.448686963531) | |
| 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) | |
| 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) | |
| 22936 | 22936 | 104688 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 3 | 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) | |
| 15438 | 15438 | 104819 | Planning Code 138.1 required 4 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 468 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770905 | 6011018.41682 | 2111922.08536 | 37.7795565535331 | -122.405464583724 | (37.7795565535331, -122.405464583724) | |
| 9790 | 9790 | 104876 | Planning Code 138.1 required 4 | Prunus laurocerasus :: English laurel 227 | 2478 43rd Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 778928 | 5983068.6 | 2098273.8 | 37.740479796641296 | -122.50114367627701 | (37.7404797966413, -122.501143676277) | |||
| 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) | |||||
| 15001 | 15001 | 105275 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 64 Townsend St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015531.53579 | 2112438.89481 | 37.7812269075454 | -122.389887748547 | (37.7812269075454, -122.389887748547) | |
| 13567 | 13567 | 105276 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 64 Townsend St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015520.229280001 | 2112423.42174 | 37.7811837949483 | -122.38992578265699 | (37.7811837949483, -122.389925782657) | |
| 15264 | 15264 | 105277 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 64 Townsend St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015510.23316 | 2112419.2864900003 | 37.781171886114706 | -122.38996007562 | (37.7811718861147, -122.38996007562) | |
| 116577 | 116577 | 106315 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 1199X OCEAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777362 | 5996259.0 | 2091739.0 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | |
| 121738 | 121738 | 107645 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1600X Franklin St | 1 | 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) | ||
| 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) | ||
| 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) | ||
| 145677 | 145677 | 108030 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 601 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2014 12:00:00 AM | 3 | 3x3 | 6002630.6 | 2098839.9 | 37.743163470374895 | -122.43354642924999 | (37.7431634703749, -122.43354642925) | ||
| 9795 | 9795 | 108228 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 390x TREAT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008492.0 | 2106262.0 | 37.763873702058 | -122.413804091523 | (37.763873702058, -122.413804091523) | |
| 12678 | 12678 | 108261 | Planning Code 138.1 required 4 | Melaleuca quinquenervia :: Cajeput 50 | 379 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774479 | 6002548.02456 | 2091247.69967 | 37.7223123355393 | -122.43328956378201 | (37.7223123355393, -122.433289563782) | |
| 166306 | 166306 | 109458 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4x4 | Permit Number 773752 | 6013450.121119999 | 2109506.07563 | 37.7730584040491 | -122.396882784219 | (37.7730584040491, -122.396882784219) | ||
| 152424 | 152424 | 109459 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 773752 | 6013430.92674 | 2109487.72122 | 37.7730069385559 | -122.39694789334101 | (37.7730069385559, -122.396947893341) | ||
| 147831 | 147831 | 109460 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 4x4 | Permit Number 773752 | 6013412.32492 | 2109471.0252 | 37.7729600595772 | -122.39701106892099 | (37.7729600595772, -122.397011068921) | ||
| 159239 | 159239 | 109461 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 773752 | 6013397.072509999 | 2109454.07559 | 37.7729126707161 | -122.397062640549 | (37.7729126707161, -122.397062640549) | ||
| 151818 | 151818 | 109462 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | Permit Number 773752 | 6013376.015 | 2109435.75899 | 37.7728612052211 | -122.39713419690001 | (37.7728612052211, -122.3971341969) | ||
| 22937 | 22937 | 109463 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2017 12:00:00 AM | 3 | 4x4 | Permit Number 773752 | 6013357.96458 | 2109418.68041 | 37.7728133064148 | -122.39719543803899 | (37.7728133064148, -122.397195438039) | |
| 175630 | 175630 | 109464 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x4 | Permit Number 773752 | 6013338.99753 | 2109402.3629400004 | 37.772767446381394 | -122.39725990323 | (37.7727674463814, -122.39725990323) | ||
| 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) | ||
| 22935 | 22935 | 109466 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2017 12:00:00 AM | 3 | 4x4 | Permit Number 773752 | 6013302.89282 | 2109368.02055 | 37.7726711397891 | -122.39738238550699 | (37.7726711397891, -122.397382385507) | |
| 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) | ||
| 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) | ||
| 171614 | 171614 | 109469 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x4 | Permit Number 773752 | 6013484.3589 | 2109540.27035 | 37.7731542007368 | -122.3967667483 | (37.7731542007368, -122.3967667483) | ||
| 187427 | 187427 | 109470 | Planning Code 138.1 required 4 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 360 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x4 | Permit Number 773752 | 6013467.61268 | 2109523.16527 | 37.77310630195289 | -122.39682347663299 | (37.7731063019529, -122.396823476633) | ||
| 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) | |
| 145461 | 145461 | 111714 | Planning Code 138.1 required 4 | Lagunaria patersonii :: Primrose Tree 48 | 3038 CLEMENT ST | 2 | 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) | |
| 20380 | 20380 | 112084 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 99X Fremont St | 1 | 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) | |||
| 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) | |||
| 180408 | 180408 | 112198 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 2570 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771994 | 6001873.5131 | 2116702.41623 | 37.7921665513862 | -122.43744307455401 | (37.7921665513862, -122.437443074554) | |
| 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) | ||
| 22979 | 22979 | 112863 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2451 19TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2015 12:00:00 AM | 3 | 3x3 | 5990427.0 | 2098705.0 | 37.7420931085193 | -122.475732948104 | (37.7420931085193, -122.475732948104) | ||
| 127737 | 127737 | 112972 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4099x ULLOA ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 1 | 3x3 | Permit Number 773327 | 5983385.0 | 2098079.0 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) |
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");