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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3535 | 3535 | 253480 | Planning Code 138.1 required 4 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1222 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009984.0 | 2109753.0 | 37.7735428603255 | -122.40889001076201 | (37.7735428603255, -122.408890010762) | |
| 3538 | 3538 | 253485 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3546 | 3546 | 253495 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3547 | 3547 | 201698 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6010000.12901 | 2109874.7171 | 37.773877970619296 | -122.408842806955 | (37.7738779706193, -122.408842806955) | |
| 3550 | 3550 | 201694 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009941.3987 | 2109939.6045 | 37.77405284648871 | -122.40905054497101 | (37.7740528464887, -122.409050544971) | |
| 3553 | 3553 | 253492 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3554 | 3554 | 253490 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3555 | 3555 | 253487 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3556 | 3556 | 201697 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009987.20299 | 2109888.7351 | 37.7739157367544 | -122.40888850959499 | (37.7739157367544, -122.408888509595) | |
| 3560 | 3560 | 201696 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009973.11931 | 2109904.86997 | 37.773959250457004 | -122.40893836622699 | (37.773959250457, -122.408938366227) | |
| 3562 | 3562 | 253488 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3563 | 3563 | 253493 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3565 | 3565 | 253475 | Planning Code 138.1 required 4 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1222 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009984.0 | 2109753.0 | 37.7735428603255 | -122.40889001076201 | (37.7735428603255, -122.408890010762) | |
| 3566 | 3566 | 201689 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 324 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009821.14 | 2110064.65257 | 37.774389461835206 | -122.40947536940399 | (37.7743894618352, -122.409475369404) | |
| 3568 | 3568 | 253479 | Planning Code 138.1 required 4 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1222 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009984.0 | 2109753.0 | 37.7735428603255 | -122.40889001076201 | (37.7735428603255, -122.408890010762) | |
| 3569 | 3569 | 201699 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6010014.86815 | 2109861.25987 | 37.7738418457656 | -122.408790872027 | (37.7738418457656, -122.408790872027) | |
| 3570 | 3570 | 253476 | Planning Code 138.1 required 4 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1222 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009984.0 | 2109753.0 | 37.7735428603255 | -122.40889001076201 | (37.7735428603255, -122.408890010762) | |
| 3573 | 3573 | 253496 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3575 | 3575 | 201690 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 324 08th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009863.47645 | 2110020.43216 | 37.7742704149776 | -122.409325797764 | (37.7742704149776, -122.409325797764) | |
| 3581 | 3581 | 253486 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3582 | 3582 | 253484 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3583 | 3583 | 201688 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 324 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009806.99553 | 2110077.79875 | 37.7744247656342 | -122.409525226004 | (37.7744247656342, -122.409525226004) | |
| 3584 | 3584 | 253477 | Planning Code 138.1 required 4 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1222 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009984.0 | 2109753.0 | 37.7735428603255 | -122.40889001076201 | (37.7735428603255, -122.408890010762) | |
| 3587 | 3587 | 253494 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763.0 | 2109812.0 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | |
| 3687 | 3687 | 152811 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 2901 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 6x6 | Permit Number 777487 | 6009988.15821 | 2101607.87857 | 37.7511784382559 | -122.40830102206999 | (37.7511784382559, -122.40830102207) | |
| 3691 | 3691 | 152812 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 2901 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 6x6 | Permit Number 777487 | 6010002.42353 | 2101608.75594 | 37.751181646126795 | -122.40825175271401 | (37.7511816461268, -122.408251752714) | |
| 3700 | 3700 | 152810 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 2901 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 6x6 | Permit Number 777487 | 6009973.24314 | 2101608.01571 | 37.751177979599206 | -122.408352609887 | (37.7511779795992, -122.408352609887) | |
| 3753 | 3753 | 253554 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 1855 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778968 | 5986885.63083 | 2102641.2721 | 37.7526951056681 | -122.48826692291901 | (37.7526951056681, -122.488266922919) | |
| 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) | ||
| 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) | |
| 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) | ||
| 3868 | 3868 | 253576 | 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) | ||
| 3890 | 3890 | 161753 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 175x Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001022.0 | 2087749.0 | 37.7126190008501 | -122.43831413288 | (37.7126190008501, -122.43831413288) | |
| 3901 | 3901 | 253246 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 1192 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001173.0 | 2087586.0 | 37.7121800264355 | -122.437780563503 | (37.7121800264355, -122.437780563503) | |
| 4329 | 4329 | 239457 | Planning Code 138.1 required 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 165 Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001959.66963 | 2096487.1672 | 37.7366653238346 | -122.435698035437 | (37.7366653238346, -122.435698035437) | |
| 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) | ||
| 4404 | 4404 | 239458 | Planning Code 138.1 required 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 165 Sussex St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001977.4736 | 2096494.97635 | 37.7366877772239 | -122.435637038029 | (37.7366877772239, -122.435637038029) | |
| 4434 | 4434 | 253623 | Planning Code 138.1 required 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1331 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778744 | 5983976.422619999 | 2106100.27997 | 37.7620224120695 | -122.498582815109 | (37.7620224120695, -122.498582815109) | |
| 4790 | 4790 | 158406 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 50 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2017 12:00:00 AM | 3 | 3X3 | Permit Number 770857 | 6001789.37716 | 2096842.5543 | 37.7376314601307 | -122.436312235543 | (37.7376314601307, -122.436312235543) | |
| 4873 | 4873 | 243284 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 1450 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007678.08789 | 2107386.86578 | 37.766916579475 | -122.416698868869 | (37.766916579475, -122.416698868869) | |
| 4880 | 4880 | 253705 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 98X Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | ||||||
| 4888 | 4888 | 151878 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 1450 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007623.77597 | 2107385.0882099997 | 37.7669086438472 | -122.41688659964599 | (37.7669086438472, -122.416886599646) | |
| 4889 | 4889 | 253706 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 98X Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | ||||||
| 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) | |
| 4932 | 4932 | 253743 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4941 | 4941 | 253741 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4947 | 4947 | 253753 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4951 | 4951 | 253752 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4954 | 4954 | 253735 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4958 | 4958 | 253746 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4961 | 4961 | 253750 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4964 | 4964 | 253756 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 41x Division St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 5x5 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4966 | 4966 | 253751 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4970 | 4970 | 253749 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 2x Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4992 | 4992 | 253754 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4997 | 4997 | 253742 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 4999 | 4999 | 253739 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5007 | 5007 | 253755 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 41x Division St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 5x5 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5009 | 5009 | 253747 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 2x Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5010 | 5010 | 253737 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5020 | 5020 | 253748 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 2x Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5024 | 5024 | 253736 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5026 | 5026 | 253744 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5027 | 5027 | 253738 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5032 | 5032 | 253740 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 5036 | 5036 | 253745 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Henry Adams St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
| 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) | ||||
| 5103 | 5103 | 253796 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Scotia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2017 12:00:00 AM | 3 | Permit Number 779938 | 6011980.63004 | 2095004.60122 | 37.733158617067296 | -122.40094689916799 | (37.7331586170673, -122.400946899168) | ||
| 5192 | 5192 | 243370 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Hill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006249.2279900005 | 2103449.78821 | 37.756025819148796 | -122.421361454386 | (37.7560258191488, -122.421361454386) | |
| 5194 | 5194 | 243372 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1050 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006308.99467 | 2103436.4955 | 37.755992689926295 | -122.42115381712 | (37.7559926899263, -122.42115381712) | |
| 5205 | 5205 | 243371 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1 Hill St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006273.4727300005 | 2103450.37091 | 37.7560287860041 | -122.42127764924 | (37.7560287860041, -122.42127764924) | |
| 5242 | 5242 | 243740 | Planning Code 138.1 required 4 | Podocarpus gracilor :: Fern Pine 13 | 550 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 776473 | 6003047.0557699995 | 2096015.8076799999 | 37.7354327831918 | -122.431904827248 | (37.7354327831918, -122.431904827248) | |
| 5296 | 5296 | 117021 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008114.19003 | 2113031.70239 | 37.7824404814865 | -122.415590162171 | (37.7824404814865, -122.415590162171) | |
| 5549 | 5549 | 117113 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1650 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773961 | 6005663.57094 | 2117913.49378 | 37.7957066076266 | -122.424415580821 | (37.7957066076266, -122.424415580821) | |
| 5738 | 5738 | 117115 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1650 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773961 | 6005638.31982 | 2117909.64088 | 37.7956946025865 | -122.42450268015 | (37.7956946025865, -122.42450268015) | |
| 5744 | 5744 | 117020 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008118.25915 | 2113018.6658799998 | 37.7824049150971 | -122.41557516146601 | (37.7824049150971, -122.415575161466) | |
| 5891 | 5891 | 117112 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1650 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773961 | 6005683.22125 | 2117915.42136 | 37.7957130098979 | -122.424347724294 | (37.7957130098979, -122.424347724294) | |
| 5966 | 5966 | 117017 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008130.7573 | 2112963.51283 | 37.7822541806174 | -122.415528017206 | (37.7822541806174, -122.415528017206) | |
| 6755 | 6755 | 117018 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008125.664580001 | 2112987.05621 | 37.78231853881321 | -122.415547303188 | (37.7823185388132, -122.415547303188) | |
| 7045 | 7045 | 117250 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 2474 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773044 | 6001780.62325 | 2117368.05955 | 37.7939889537763 | -122.437812170719 | (37.7939889537763, -122.437812170719) | |
| 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) | |||
| 7243 | 7243 | 116776 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008776.88904 | 2117992.21481 | 37.7960980717264 | -122.41364847189399 | (37.7960980717264, -122.413648471894) | ||
| 7304 | 7304 | 117114 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1650 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773961 | 6005648.88243 | 2117910.88116 | 37.7956986045686 | -122.42446621984399 | (37.7956986045686, -122.424466219844) | |
| 7556 | 7556 | 115529 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 101 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007327.31765 | 2111347.52577 | 37.777771876795 | -122.418192961161 | (37.777771876795, -122.418192961161) | |
| 7735 | 7735 | 116777 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008763.52683 | 2117990.43413 | 37.796092432072705 | -122.41369458194099 | (37.7960924320727, -122.413694581941) | ||
| 7909 | 7909 | 115530 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007332.44961 | 2111311.79762 | 37.7776740647351 | -122.418172674243 | (37.7776740647351, -122.418172674243) | |
| 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) | |
| 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) | |
| 8658 | 8658 | 115528 | Planning Code 138.1 required 4 | Platanus x hispanica :: Sycamore: London Plane 15 | 101 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007325.8351 | 2111377.63368 | 37.77785446243671 | -122.418200224953 | (37.7778544624367, -122.418200224953) | |
| 8765 | 8765 | 116774 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008811.215480001 | 2117995.14613 | 37.7961080479024 | -122.413529902601 | (37.7961080479024, -122.413529902601) | ||
| 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) | |
| 8943 | 8943 | 116775 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008794.04431 | 2117993.28546 | 37.79610197478279 | -122.413589186808 | (37.7961019747828, -122.413589186808) | ||
| 9622 | 9622 | 122597 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 5 | 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) | |
| 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) | |
| 9625 | 9625 | 122599 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 7 | 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) | |
| 9627 | 9627 | 122596 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 4 | 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) | |
| 9628 | 9628 | 122598 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 42X Colin P Kelly Jr St | 6 | 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) | |
| 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) |
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");