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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21324 | 21324 | 621 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 3151 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/23/1992 12:00:00 AM | 18 | 3X3 | 6007979.07595 | 2102079.2423799997 | 37.7523599891254 | -122.41528202924101 | (37.7523599891254, -122.415282029241) | ||
| 83290 | 83290 | 11584 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 4001 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 3X3 | 5982142.686634201 | 2105549.2773534 | 37.7604018044904 | -122.504884056543 | (37.7604018044904, -122.504884056543) | |||
| 87474 | 87474 | 16273 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 692X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 3X3 | 5997509.7184819 | 2094751.8939266002 | 37.7316469123248 | -122.450958273614 | (37.7316469123248, -122.450958273614) | ||
| 97652 | 97652 | 4167 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 3781 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/04/1993 12:00:00 AM | 12 | 3X3 | 6005338.8489102 | 2100470.9859700003 | 37.7477953482432 | -122.424297997893 | (37.7477953482432, -122.424297997893) | ||
| 98438 | 98438 | 117606 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 420 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002292.2454566 | 2105806.2278627 | 37.7622721434766 | -122.43521453981701 | (37.7622721434766, -122.435214539817) | |||
| 101513 | 101513 | 83941 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 60 13th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3X3 | Permit Number 50121 | 6008302.41836553 | 2108360.42350377 | 37.7696248364946 | -122.41460830425899 | (37.7696248364946, -122.414608304259) | ||
| 110655 | 110655 | 28415 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 692X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 3X3 | 5997509.7184819 | 2094751.8939266002 | 37.7316469123248 | -122.450958273614 | (37.7316469123248, -122.450958273614) | ||
| 128524 | 128524 | 117607 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 420 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002292.2454566 | 2105806.2278627 | 37.7622721434766 | -122.43521453981701 | (37.7622721434766, -122.435214539817) | |||
| 3525 | 3525 | 253489 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 7 | 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) | |
| 3532 | 3532 | 253483 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 1 | 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) | |
| 3533 | 3533 | 253491 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1x Gordon St | 9 | 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 6292 | 6292 | 87392 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3322 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773384 | 6002333.63287 | 2119648.2941900003 | 37.800281314083705 | -122.43606195061199 | (37.8002813140837, -122.436061950612) | |
| 6671 | 6671 | 87391 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3322 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773384 | 6002335.87278 | 2119635.99284 | 37.800247665053 | -122.43605331890801 | (37.800247665053, -122.436053318908) | |
| 15504 | 15504 | 49998 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1101X 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014225.48172 | 2105233.1729900003 | 37.7613690835438 | -122.39390153433901 | (37.7613690835438, -122.393901534339) |
| 18713 | 18713 | 34080 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) |
| 19051 | 19051 | 582 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 3013 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/23/1992 12:00:00 AM | 12 | 3x3 | 6008818.92095 | 2102127.6459 | 37.7525400594852 | -122.41238111940099 | (37.7525400594852, -122.412381119401) | ||
| 29943 | 29943 | 83166 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1089 Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52361 | 6015096.6014 | 2089812.1317 | 37.719074451264 | -122.389811494874 | (37.719074451264, -122.389811494874) | |
| 34945 | 34945 | 113776 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1710 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000070.198 | 2114878.1306 | 37.7870548531015 | -122.443551447546 | (37.7870548531015, -122.443551447546) | |||
| 47070 | 47070 | 83362 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3325 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51120 | 5982822.4546 | 2100126.935 | 37.745553538391206 | -122.50213183404101 | (37.7455535383912, -122.502131834041) | |
| 48125 | 48125 | 36793 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1350 Donner Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39527 | 6015250.697000001 | 2090820.757 | 37.721852482589796 | -122.38934923747601 | (37.7218524825898, -122.389349237476) | |
| 53611 | 53611 | 109316 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1516 BROADWAY | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006331.3 | 2118082.2 | 37.796207516174796 | -122.42211710536101 | (37.7962075161748, -122.422117105361) | ||||
| 80153 | 80153 | 82685 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 35 Jennings Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52459 | 6012802.99497586 | 2089176.16957459 | 37.7172007679129 | -122.397695078281 | (37.7172007679129, -122.397695078281) | ||
| 80434 | 80434 | 30020 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 710X San Jose Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005718.76576524 | 2099005.5772577 | 37.7437931149581 | -122.42288013057501 | (37.7437931149581, -122.422880130575) | ||
| 80952 | 80952 | 109314 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1516 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006331.3 | 2118082.2 | 37.796207516174796 | -122.42211710536101 | (37.7962075161748, -122.422117105361) | ||||
| 81156 | 81156 | 109317 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1516 BROADWAY | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006331.3 | 2118082.2 | 37.796207516174796 | -122.42211710536101 | (37.7962075161748, -122.422117105361) | ||||
| 82547 | 82547 | 30021 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 710X San Jose Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005718.76576524 | 2099005.5772577 | 37.7437931149581 | -122.42288013057501 | (37.7437931149581, -122.422880130575) | ||
| 83323 | 83323 | 30003 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 610X San Jose Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6006030.83928578 | 2099887.5672939997 | 37.74623246341729 | -122.42186369026399 | (37.7462324634173, -122.421863690264) | ||
| 86383 | 86383 | 34081 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 SHOTWELL ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) |
| 86898 | 86898 | 34083 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) |
| 87668 | 87668 | 103568 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 223 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5997125.5 | 2106655.6 | 37.76430954658429 | -122.45314559026801 | (37.7643095465843, -122.453145590268) | |||
| 94982 | 94982 | 39859 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 70 13th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.41483963035499 | (37.7696326766808, -122.414839630355) | ||
| 96207 | 96207 | 108286 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1 HENRY ADAMS ST | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 98468 | 98468 | 34082 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) |
| 98537 | 98537 | 34079 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) |
| 100434 | 100434 | 108225 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 103766 | 103766 | 85491 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 4400 24th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2007 12:00:00 AM | 3x3 | Permit Number 52154 | 6000641.0 | 2101716.0 | 37.7509474670616 | -122.440632169404 | (37.7509474670616, -122.440632169404) | |||
| 105965 | 105965 | 108221 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 106308 | 106308 | 34076 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2851X 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768574 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) |
| 106980 | 106980 | 108282 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1 HENRY ADAMS ST | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | |||
| 107863 | 107863 | 39860 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 70 13th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.41483963035499 | (37.7696326766808, -122.414839630355) | ||
| 109559 | 109559 | 98644 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2391 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008222.0 | 2104509.0 | 37.7590452010005 | -122.414613883143 | (37.7590452010005, -122.414613883143) | |||
| 111471 | 111471 | 52313 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 4400HOFFMAN 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2009 12:00:00 AM | 3x3 | Permit Number 52154 | 6000634.55195661 | 2101724.81174328 | 37.7509712947951 | -122.440655099281 | (37.7509712947951, -122.440655099281) | ||
| 112993 | 112993 | 99104 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 3644 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006000.9 | 2104423.0 | 37.7586840282695 | -122.422289399469 | (37.7586840282695, -122.422289399469) | ||||
| 113895 | 113895 | 52312 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 4400HOFFMAN 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2009 12:00:00 AM | 3x3 | Permit Number 52154 | 6000634.55195661 | 2101724.81174328 | 37.7509712947951 | -122.440655099281 | (37.7509712947951, -122.440655099281) | ||
| 113940 | 113940 | 107411 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3634 20th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006068.0 | 2104353.0 | 37.7584956093101 | -122.422052363883 | (37.7584956093101, -122.422052363883) | ||||
| 114868 | 114868 | 83791 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 369 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50933 | 6008828.16902132 | 2097088.78446754 | 37.7387049796432 | -122.411993079981 | (37.7387049796432, -122.411993079981) | ||
| 115414 | 115414 | 52311 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 4400HOFFMAN 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2009 12:00:00 AM | 3x3 | Permit Number 52154 | 6000634.55195661 | 2101724.81174328 | 37.7509712947951 | -122.440655099281 | (37.7509712947951, -122.440655099281) | ||
| 116911 | 116911 | 109315 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1516 BROADWAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006331.3 | 2118082.2 | 37.796207516174796 | -122.42211710536101 | (37.7962075161748, -122.422117105361) | ||||
| 117733 | 117733 | 62050 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 70 13th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008120.0 | 2108416.0 | 37.769767186200795 | -122.41524321981701 | (37.7697671862008, -122.415243219817) | ||
| 118122 | 118122 | 108224 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 118194 | 118194 | 108227 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 118249 | 118249 | 39861 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 70 13th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.41483963035499 | (37.7696326766808, -122.414839630355) | ||
| 120475 | 120475 | 108220 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 120751 | 120751 | 34077 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2851X 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768574 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) |
| 121741 | 121741 | 99249 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 435 Paul Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2012 12:00:00 AM | 3x3 | Permit Number 769233 | 6012286.9 | 2091380.6 | 37.7232249352354 | -122.399633675727 | (37.7232249352354, -122.399633675727) | ||
| 126801 | 126801 | 34084 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) |
| 127065 | 127065 | 84127 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 88 Mill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50980 | 6010360.09243836 | 2089687.02520781 | 37.7184671339256 | -122.406175049692 | (37.7184671339256, -122.406175049692) | ||
| 127307 | 127307 | 110182 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 339 ELSIE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 776744 | 6006513.8 | 2097161.9 | 37.7387756178582 | -122.420000276005 | (37.7387756178582, -122.420000276005) | ||
| 129363 | 129363 | 108222 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 137872 | 137872 | 82840 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1379 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 13 | 3x3 | Permit Number 52465 | 6016423.5899 | 2093711.7525 | 37.729855545757 | -122.38549618052299 | (37.729855545757, -122.385496180523) | |
| 138600 | 138600 | 30004 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 610X San Jose Ave | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6006030.83928578 | 2099887.5672939997 | 37.74623246341729 | -122.42186369026399 | (37.7462324634173, -122.421863690264) | ||
| 140788 | 140788 | 34085 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2851X 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768574 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) |
| 141713 | 141713 | 82360 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 415-421 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2011 12:00:00 AM | 10 | 3x3 | Permit Number 768604 | 6007434.83105048 | 2107262.94030089 | 37.766562624561 | -122.417531473498 | (37.766562624561, -122.417531473498) |
| 142472 | 142472 | 108226 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 145082 | 145082 | 88286 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51287 | 6007754.0 | 2106536.0 | 37.7645845697556 | -122.416376026653 | (37.7645845697556, -122.416376026653) | ||
| 145218 | 145218 | 71944 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1342 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/1995 12:00:00 AM | 3x3 | Permit Number 50253 | 6008035.06455956 | 2100432.68279191 | 37.7478420534954 | -122.414971880187 | (37.7478420534954, -122.414971880187) | ||
| 145642 | 145642 | 108223 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 145835 | 145835 | 80165 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 415-421 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2011 12:00:00 AM | 10 | 3x3 | Permit Number 768604 | 6007434.83105048 | 2107262.94030089 | 37.766562624561 | -122.417531473498 | (37.766562624561, -122.417531473498) |
| 163040 | 163040 | 82715 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1379 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 11 | 3x3 | Permit Number 52465 | 6016442.9825 | 2093699.9014 | 37.7298240779238 | -122.385428311894 | (37.7298240779238, -122.385428311894) | |
| 166782 | 166782 | 36797 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1350 Donner Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39527 | 6015213.5435 | 2090847.5562 | 37.721924008003604 | -122.389479539312 | (37.7219240080036, -122.389479539312) | |
| 174472 | 174472 | 36791 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1350 Donner Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | 9 | 3x3 | Permit Number 39527 | 6015186.7443 | 2090870.701 | 37.7219860731406 | -122.389573793771 | (37.7219860731406, -122.389573793771) | |
| 179138 | 179138 | 36792 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1350 Donner Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 9 | 3x3 | Permit Number 39527 | 6015166.6448 | 2090882.8824 | 37.7220184063671 | -122.38964412365499 | (37.7220184063671, -122.389644123655) |
| 87848 | 87848 | 100205 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4085 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2012 12:00:00 AM | 12 | 3x4 | Permit Number 769140 | 6003091.0 | 2104064.0 | 37.757533730328205 | -122.43232751517901 | (37.7575337303282, -122.432327515179) | |
| 13285 | 13285 | 187639 | Planning Code 138.1 required 4 | Trachycarpus fortunei :: Windmill Palm 31 | 1671 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2017 12:00:00 AM | 3 | 3x6 | 5985585.0 | 2103854.0 | 37.7559489545124 | -122.492853989295 | (37.7559489545124, -122.492853989295) | ||
| 59569 | 59569 | 115612 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 4x4 | 6012209.3182 | 2107055.3618 | 37.7662601539356 | -122.401002678345 | (37.7662601539356, -122.401002678345) | |||
| 107827 | 107827 | 115617 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||||
| 110007 | 110007 | 115616 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||||
| 110112 | 110112 | 115632 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 55x 15TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6012114.0 | 2107494.0 | 37.7674592382642 | -122.40136319642001 | (37.7674592382642, -122.40136319642) | ||||
| 157293 | 157293 | 60204 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/1982 12:00:00 AM | 8 | 4x4 | Permit Number 19750 | 6012229.2906 | 2107053.9352 | 37.766257350909704 | -122.400933496957 | (37.7662573509097, -122.400933496957) | |
| 172140 | 172140 | 115615 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 4x4 | 6012069.0366 | 2107045.8512 | 37.766226213653 | -122.40148722008699 | (37.766226213653, -122.401487220087) | |||
| 78446 | 78446 | 16228 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 564X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998342.280841901 | 2094738.2735002 | 37.731657141982204 | -122.44807897208 | (37.7316571419822, -122.44807897208) | ||
| 78838 | 78838 | 16202 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 500X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998782.1299536 | 2094714.7967047 | 37.7316178141427 | -122.446556643647 | (37.7316178141427, -122.446556643647) | ||
| 87736 | 87736 | 16286 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 700X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096626998 | (37.7316223027997, -122.45117096627) | ||
| 96559 | 96559 | 16227 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 564X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998342.280841901 | 2094738.2735002 | 37.731657141982204 | -122.44807897208 | (37.7316571419822, -122.44807897208) | ||
| 109605 | 109605 | 16314 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 758X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.45247618016899 | (37.7316364140758, -122.452476180169) | ||
| 111546 | 111546 | 28414 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 600X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998107.3609693 | 2094732.8027768002 | 37.7316286888145 | -122.448890739326 | (37.7316286888145, -122.448890739326) | ||
| 118733 | 118733 | 16313 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 758X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.45247618016899 | (37.7316364140758, -122.452476180169) | ||
| 139874 | 139874 | 16201 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 500X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998782.1299536 | 2094714.7967047 | 37.7316178141427 | -122.446556643647 | (37.7316178141427, -122.446556643647) | ||
| 144031 | 144031 | 16312 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 758X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.45247618016899 | (37.7316364140758, -122.452476180169) |
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");