Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 576 | 576 | 240412 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3420 Market St | 1 | : 4 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 7 | Width 3ft | 6000095.059769999 | 2103920.2632400002 | 37.7569687331323 | -122.442678332141 | (37.7569687331323, -122.442678332141) | ||
| 596 | 596 | 240413 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3420 Market St | 2 | : 4 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 8 | Width 3ft | 6000107.95046 | 2103900.11575 | 37.756914147893795 | -122.442632304847 | (37.7569141478938, -122.442632304847) | ||
| 2370 | 2370 | 112542 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 438 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2016 12:00:00 AM | 3 | 3x3 | 6011405.06525 | 2118709.9257400003 | 37.7982159634572 | -122.40460495956002 | (37.7982159634572, -122.40460495956) | ||
| 5190 | 5190 | 253817 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 159 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001018.0 | 2098627.0 | 37.742487269754704 | -122.43910710368601 | (37.7424872697547, -122.439107103686) | ||||
| 6247 | 6247 | 112539 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 426 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/12/2016 11:10:00 AM | 3 | 3x3 | 6011460.82325 | 2118719.23159 | 37.7982446311281 | -122.404412674615 | (37.7982446311281, -122.404412674615) | ||
| 6998 | 6998 | 112530 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 435 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2016 07:26:00 AM | 3 | 3x3 | 6011409.86951 | 2118646.99301 | 37.7980434339179 | -122.40458390283199 | (37.7980434339179, -122.404583902832) | ||
| 18331 | 18331 | 34 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 759 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003742.09963 | 2107707.8799900003 | 37.767575847275204 | -122.430335723414 | (37.7675758472752, -122.430335723414) | |||
| 18385 | 18385 | 25468 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 437 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/26/1996 12:00:00 AM | 6 | 3X3 | 5992774.4094 | 2088493.0908 | 37.7141895393891 | -122.466874212626 | (37.7141895393891, -122.466874212626) | ||
| 19634 | 19634 | 31 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 753 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2016 06:04:00 AM | 3 | 3X3 | 6003785.60824 | 2107710.67637 | 37.7675859898405 | -122.430185432325 | (37.7675859898405, -122.430185432325) | ||
| 20666 | 20666 | 33 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 755 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1998 12:00:00 AM | 3 | 3X3 | 6003762.7674 | 2107707.98129 | 37.7675772960935 | -122.43026424352199 | (37.7675772960935, -122.430264243522) | ||
| 21370 | 21370 | 22 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 725 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2017 08:22:00 AM | 3 | 3X3 | 6003898.66598 | 2107719.95316 | 37.7676178644975 | -122.429795042015 | (37.7676178644975, -122.429795042015) | ||
| 35219 | 35219 | 136329 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 447 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 3ft | 6011341.08824 | 2118636.57968 | 37.7980109971731 | -122.404821173685 | (37.7980109971731, -122.404821173685) | |||
| 46584 | 46584 | 112541 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 438 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6011421.73685 | 2118713.41459 | 37.798226474727 | -122.404547516275 | (37.798226474727, -122.404547516275) | |||
| 68016 | 68016 | 112540 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 432 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6011444.64707 | 2118714.34063 | 37.7982302977556 | -122.404468304876 | (37.7982302977556, -122.404468304876) | |||
| 81181 | 81181 | 112547 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 462 BROADWAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011324.0 | 2118723.0 | 37.798247331278 | -122.404886391926 | (37.798247331278, -122.404886391926) | ||||
| 83025 | 83025 | 7243 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 1929X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002956.0424065 | 2114080.0912444 | 37.7850277993699 | -122.43351002509701 | (37.7850277993699, -122.433510025097) | |||
| 90622 | 90622 | 112528 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 459 BROADWAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011361.0 | 2118561.0 | 37.797804586609004 | -122.40474694923401 | (37.797804586609, -122.404746949234) | ||||
| 95726 | 95726 | 23598 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 200X Vasquez Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
| 97182 | 97182 | 32 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 753 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2016 06:10:00 AM | 3 | 3X3 | 6003820.6216400005 | 2107707.01694 | 37.7675779249973 | -122.43006406443999 | (37.7675779249973, -122.43006406444) | ||
| 97680 | 97680 | 112525 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 471 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011292.0 | 2118586.0 | 37.7978693737352 | -122.40498747086399 | (37.7978693737352, -122.404987470864) | ||||
| 98390 | 98390 | 11347 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 1300X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/06/1997 12:00:00 AM | 18 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.730677746775605 | -122.382320962891 | (37.7306777467756, -122.382320962891) | ||
| 102926 | 102926 | 112527 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 459 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011361.0 | 2118561.0 | 37.797804586609004 | -122.40474694923401 | (37.797804586609, -122.404746949234) | ||||
| 103341 | 103341 | 112529 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 459 BROADWAY | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011361.0 | 2118561.0 | 37.797804586609004 | -122.40474694923401 | (37.797804586609, -122.404746949234) | ||||
| 111533 | 111533 | 25183 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3448X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 6 | 3X3 | 6000085.2661190005 | 2103906.7160847997 | 37.7569309776636 | -122.442711229464 | (37.7569309776636, -122.442711229464) | ||
| 113563 | 113563 | 18603 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 520 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/25/1996 12:00:00 AM | 6 | 3X3 | 5992619.61154 | 2088559.40218 | 37.7143626789426 | -122.467414068351 | (37.7143626789426, -122.467414068351) | ||
| 115972 | 115972 | 74680 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 493 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2013 12:00:00 AM | 3x3 | Permit Number 769961 | 6011188.26118785 | 2118621.30079081 | 37.79796050165611 | -122.405348925503 | (37.7979605016561, -122.405348925503) | ||
| 115976 | 115976 | 112531 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 435 BROADWAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011430.0 | 2118629.0 | 37.79799515449189 | -122.404512977901 | (37.7979951544919, -122.404512977901) | ||||
| 116556 | 116556 | 23599 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 200X Vasquez Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
| 120958 | 120958 | 25184 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3448X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 25 | 3X3 | 6000085.2661190005 | 2103906.7160847997 | 37.7569309776636 | -122.442711229464 | (37.7569309776636, -122.442711229464) | ||
| 124635 | 124635 | 1772 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 2000X Bay Shore Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | |||
| 126995 | 126995 | 9330 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 159 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2015 03:37:00 AM | 3 | 3x3 | 6000991.502255901 | 2098643.2192577 | 37.7425302962209 | -122.439199887043 | (37.7425302962209, -122.439199887043) | ||
| 128753 | 128753 | 29219 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 1902X 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5983534.517682901 | 2102185.1808128003 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | |||
| 131736 | 131736 | 112538 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 412 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2016 12:00:00 AM | 2 | 3x3 | 6011488.50983 | 2118723.0183900003 | 37.7982565759239 | -122.40431713692699 | (37.7982565759239, -122.404317136927) | ||
| 135504 | 135504 | 136328 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 447 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 3ft | 6011327.03299 | 2118633.79421 | 37.7980025633245 | -122.40486961294201 | (37.7980025633245, -122.404869612942) | |||
| 140610 | 140610 | 112526 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 471 BROADWAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011292.0 | 2118586.0 | 37.7978693737352 | -122.40498747086399 | (37.7978693737352, -122.404987470864) | ||||
| 140802 | 140802 | 112543 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 448 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011394.0 | 2118786.0 | 37.798424226523 | -122.404648607058 | (37.798424226523, -122.404648607058) | ||||
| 143705 | 143705 | 13408 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 364 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 5 | 5999660.108164 | 2097381.7238333 | 37.738990678772396 | -122.443712833155 | (37.7389906787724, -122.443712833155) | |||
| 169354 | 169354 | 117837 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 660x 39th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 6ft | 5983820.01458 | 2111273.2343900003 | 37.776216692790705 | -122.49950607144899 | (37.7762166927907, -122.499506071449) | |||
| 173900 | 173900 | 112532 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 435 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6011441.2715 | 2118651.0791599997 | 37.7980564084299 | -122.404475530047 | (37.7980564084299, -122.404475530047) | |||
| 176846 | 176846 | 112537 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 412 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6011527.0722 | 2118728.8461599997 | 37.7982747323527 | -122.404184109226 | (37.7982747323527, -122.404184109226) | |||
| 177684 | 177684 | 112546 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 464 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6011322.0 | 2118712.0 | 37.7982170161506 | -122.404892537684 | (37.7982170161506, -122.404892537684) | |||
| 187146 | 187146 | 136330 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 447 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 3ft | 6011365.830569999 | 2118639.8560599997 | 37.7980213762507 | -122.40473578841998 | (37.7980213762507, -122.40473578842) | |||
| 122 | 122 | 183689 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1341 42nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5983043.6112 | 2105976.497 | 37.761627789464704 | -122.501799836383 | (37.7616277894647, -122.501799836383) | |||
| 1152 | 1152 | 240384 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 65 Hermann St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779910 | 6004983.769180001 | 2108813.08838 | 37.7706807377627 | -122.426119636009 | (37.7706807377627, -122.426119636009) | |
| 1553 | 1553 | 207056 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 340 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991811.94775 | 2097766.11202 | 37.7395953573424 | -122.470875903123 | (37.7395953573424, -122.470875903123) | |||
| 1559 | 1559 | 207057 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 340 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991827.84816 | 2097768.2699700003 | 37.7396022020835 | -122.47082108403099 | (37.7396022020835, -122.470821084031) | |||
| 1984 | 1984 | 252847 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1500 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008908.0 | 2108725.0 | 37.7706598827985 | -122.412539385599 | (37.7706598827985, -122.412539385599) | ||||
| 1993 | 1993 | 252846 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1500 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008908.0 | 2108725.0 | 37.7706598827985 | -122.412539385599 | (37.7706598827985, -122.412539385599) | ||||
| 2099 | 2099 | 200057 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1898x Lane St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014825.8229 | 2094079.4071 | 37.7307765200208 | -122.39104557773999 | (37.7307765200208, -122.39104557774) | |||
| 7100 | 7100 | 106210 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 585X Bush St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774310 | 6010773.37918 | 2115862.1930299997 | 37.7903614528559 | -122.406590009715 | (37.7903614528559, -122.406590009715) | |
| 9846 | 9846 | 41266 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2929 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779089 | 6002905.04785 | 2118704.6759200003 | 37.7977228301084 | -122.434017142274 | (37.7977228301084, -122.434017142274) | ||
| 10245 | 10245 | 43062 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 490 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 51464 | 5985348.18764 | 2112571.6735099996 | 37.779871377757296 | -122.49431551232401 | (37.7798713777573, -122.494315512324) | |
| 10851 | 10851 | 52794 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1277TEHAMA Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48833 | ||||||||
| 10944 | 10944 | 35742 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1998 12:00:00 AM | Permit Number 39016 | |||||||||
| 10980 | 10980 | 52793 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1277TEHAMA Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48833 | ||||||||
| 11876 | 11876 | 38200 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 514 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 12 | 3x3 | Permit Number 45184 | 6010449.69037 | 2092207.2371 | 37.7253921259422 | -122.406042793857 | (37.7253921259422, -122.406042793857) |
| 13065 | 13065 | 52792 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1277TEHAMA Houston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48833 | ||||||||
| 13295 | 13295 | 187666 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 107 Bernard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 2ft | 6008318.73536 | 2118064.92593 | 37.796271980829 | -122.415238929252 | (37.796271980829, -122.415238929252) | ||||
| 14122 | 14122 | 35743 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1998 12:00:00 AM | Permit Number 39016 | |||||||||
| 14808 | 14808 | 106045 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2201X 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2014 12:00:00 AM | 14 | 4x14 | Permit Number 772230 | 6011471.492269999 | 2104620.16703 | 37.7595324691706 | -122.403383358282 | (37.7595324691706, -122.403383358282) | |
| 15769 | 15769 | 30659 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 54 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 34592 | 6007591.74325 | 2109572.72569 | 37.7729135790239 | -122.41715242667 | (37.7729135790239, -122.41715242667) |
| 17486 | 17486 | 18596 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 409 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/1996 12:00:00 AM | 6 | 3X3 | 5992903.2652 | 2088492.7734 | 37.7141961040887 | -122.46642881780501 | (37.7141961040887, -122.466428817805) | ||
| 17788 | 17788 | 18608 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 550 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/1997 12:00:00 AM | 6 | 3X3 | 5992502.2173 | 2088557.38 | 37.7143503484358 | -122.467819678694 | (37.7143503484358, -122.467819678694) | ||
| 17804 | 17804 | 26068 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 282 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2003 12:00:00 AM | 3 | 2X3 | 5994051.2236 | 2088339.7969 | 37.7138422407476 | -122.46244996961 | (37.7138422407476, -122.46244996961) | ||
| 18565 | 18565 | 68830 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 111 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32781 | 6000000.33338592 | 2094041.19205625 | 37.729837760714204 | -122.44229674739599 | (37.7298377607142, -122.442296747396) | ||
| 18943 | 18943 | 26157 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 260 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1997 12:00:00 AM | 3 | 3X3 | 5994051.6997 | 2088243.7899 | 37.713578655736 | -122.462441364614 | (37.713578655736, -122.462441364614) | ||
| 19205 | 19205 | 17244 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 10X Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2005 12:00:00 AM | 6 | 3X3 | 5993945.3779 | 2088542.9193 | 37.7143938707274 | -122.462830535838 | (37.7143938707274, -122.462830535838) | ||
| 21649 | 21649 | 18607 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 530 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/1996 12:00:00 AM | 6 | 3x3 | 5992558.0676 | 2088557.0731 | 37.7143527306111 | -122.467626617395 | (37.7143527306111, -122.467626617395) | ||
| 22821 | 22821 | 197331 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1501 25th St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6014124.123369999 | 2101967.77095 | 37.752397360459 | -122.39402349321199 | (37.752397360459, -122.394023493212) | ||||
| 23461 | 23461 | 240416 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 12 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003644.58951 | 2098299.35585 | 37.7417367402568 | -122.43000177276899 | (37.7417367402568, -122.430001772769) | |||
| 23811 | 23811 | 140094 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1652 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999863.0392 | 2110926.6558 | 37.7761933050322 | -122.44398414486 | (37.7761933050322, -122.44398414486) | |||
| 23960 | 23960 | 136302 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 3362 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998728.182469999 | 2115610.0271400004 | 37.788987820287 | -122.44824722563699 | (37.788987820287, -122.448247225637) | |||
| 23996 | 23996 | 240380 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 87 14th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008113.4152 | 2107953.3802 | 37.768496570485794 | -122.41523324373199 | (37.7684965704858, -122.415233243732) | |||
| 24847 | 24847 | 214027 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000768.47308 | 2094513.82924 | 37.7311792633149 | -122.439675077667 | (37.7311792633149, -122.439675077667) | |||
| 25175 | 25175 | 34531 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 635 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1997 12:00:00 AM | 5 | Permit Number 38240 | 5988437.8449 | 2111647.649 | 37.7775145896121 | -122.483559386935 | (37.7775145896121, -122.483559386935) | ||
| 25229 | 25229 | 197350 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 719 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009290.40599 | 2110497.98819 | 37.7755495477154 | -122.411341904202 | (37.7755495477154, -122.411341904202) | |||
| 25257 | 25257 | 240410 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 235 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001912.29637 | 2096185.45895 | 37.735834211766 | -122.43584024433599 | (37.735834211766, -122.435840244336) | |||
| 25288 | 25288 | 136307 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1110 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008614.233080001 | 2116420.22843 | 37.7917726483359 | -122.41410002782 | (37.7917726483359, -122.41410002782) | |||
| 25889 | 25889 | 48457 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 520 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 6 | Permit Number 45824 | 6011919.3472 | 2110495.26684 | 37.7756891719521 | -122.402247516312 | (37.7756891719521, -122.402247516312) | ||
| 26373 | 26373 | 140857 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 617 Euclid Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5996458.4312 | 2113796.5573 | 37.7838784965198 | -122.45596906246 | (37.7838784965198, -122.45596906246) | |||
| 26432 | 26432 | 141346 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 463 BRODERICK ST | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 6001145.1037 | 2110334.7664 | 37.774641176317104 | -122.439506706044 | (37.7746411763171, -122.439506706044) | |||
| 26602 | 26602 | 89200 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3236 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51816 | 5999879.096940001 | 2119719.87548 | 37.8003381062886 | -122.444560730091 | (37.8003381062886, -122.444560730091) | |
| 26737 | 26737 | 41177 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1555 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/1999 12:00:00 AM | 3 | Permit Number 41896 | 6002761.3685800005 | 2121278.33423 | 37.804781267115104 | -122.43469844348301 | (37.8047812671151, -122.434698443483) | |
| 26763 | 26763 | 240404 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4362 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000898.63467 | 2103311.26449 | 37.7553423460847 | -122.439855611169 | (37.7553423460847, -122.439855611169) | |||
| 26795 | 26795 | 179378 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2016 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6012163.289480001 | 2088075.41369 | 37.7141426692356 | -122.39982900101299 | (37.7141426692356, -122.399829001013) | |||
| 27483 | 27483 | 124544 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1001 Balboa St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5992459.19305 | 2111330.13563 | 37.7768760257506 | -122.46962520893801 | (37.7768760257506, -122.469625208938) | |||
| 27566 | 27566 | 200054 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1800 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014879.1353 | 2094151.956 | 37.73097868287971 | -122.39086633517 | (37.7309786828797, -122.39086633517) | |||
| 27615 | 27615 | 47743 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4201 Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/2002 12:00:00 AM | 6 | Permit Number 45527 | 5982418.5702 | 2113061.40286 | 37.78104415210971 | -122.50448647782 | (37.7810441521097, -122.50448647782) | |
| 27641 | 27641 | 240391 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 346 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006743.91028 | 2097051.2853599999 | 37.7384848564878 | -122.41919681678199 | (37.7384848564878, -122.419196816782) | |||
| 27695 | 27695 | 214032 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 342 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997805.133780001 | 2093821.6600400002 | 37.729109618413 | -122.449869953332 | (37.729109618413, -122.449869953332) | |||
| 27782 | 27782 | 136327 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 463 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011305.85301 | 2118630.68117 | 37.797992831771495 | -122.404942682854 | (37.7979928317715, -122.404942682854) | |||
| 28149 | 28149 | 214012 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1479 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5992097.0420699995 | 2105377.93896 | 37.7605119495939 | -122.47044439308998 | (37.7605119495939, -122.47044439309) | |||
| 28437 | 28437 | 240376 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1367 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007185.77161 | 2107529.7326700003 | 37.76728115653079 | -122.41841184713499 | (37.7672811565308, -122.418411847135) | |||
| 29132 | 29132 | 31972 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 100 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 5 | Permit Number 35372 | 5995228.46958 | 2114784.79077 | 37.786521248530995 | -122.46029586964701 | (37.786521248531, -122.460295869647) | |
| 29223 | 29223 | 183217 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 3150 Rivera St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983341.801 | 2100199.14 | 37.7457822914528 | -122.50034138058201 | (37.7457822914528, -122.500341380582) | |||
| 29438 | 29438 | 31973 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 100 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 5 | Permit Number 35372 | 5995224.68838 | 2114814.58842 | 37.7866028473263 | -122.460311111336 | (37.7866028473263, -122.460311111336) | |
| 29717 | 29717 | 32611 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2926 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 0 | Permit Number 37076 | 5985807.8579886 | 2105043.58172562 | 37.7592282476447 | -122.492170870983 | (37.7592282476447, -122.492170870983) | |
| 29920 | 29920 | 240423 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002449.92079 | 2096381.9214299999 | 37.7364041778047 | -122.433995506402 | (37.7364041778047, -122.433995506402) | |||
| 30089 | 30089 | 122281 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990111.6262 | 2111320.57885 | 37.7767138255075 | -122.477745368245 | (37.7767138255075, -122.477745368245) | |||
| 30486 | 30486 | 214028 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6000768.83365 | 2094531.22311 | 37.7312270433827 | -122.43967507764201 | (37.7312270433827, -122.439675077642) |
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");