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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64497 | 64497 | 214035 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 142 Staples Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5999120.59989 | 2093807.09624 | 37.72914480888021 | -122.445321250796 | (37.7291448088802, -122.445321250796) | ||||
| 65759 | 65759 | 122284 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990094.44484 | 2111319.9709799998 | 37.776711159339705 | -122.47780475856199 | (37.7767111593397, -122.477804758562) | |||
| 66165 | 66165 | 186237 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1701 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984808.8655 | 2103347.0431 | 37.7545115739121 | -122.495500689099 | (37.7545115739121, -122.495500689099) | |||
| 66397 | 66397 | 140854 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 623 Euclid Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5996411.3906 | 2113796.8958 | 37.783876725924294 | -122.456131829019 | (37.7838767259243, -122.456131829019) | |||
| 66574 | 66574 | 214018 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2464 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991736.67899 | 2098669.28572 | 37.742070888761894 | -122.47120193253001 | (37.7420708887619, -122.47120193253) | |||
| 66593 | 66593 | 207054 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1266 09th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5993334.80991 | 2106859.56975 | 37.7646516098981 | -122.466271235742 | (37.7646516098981, -122.466271235742) | |||
| 67968 | 67968 | 240378 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 87 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008072.764690001 | 2107952.79864 | 37.768492689 | -122.41537380956899 | (37.768492689, -122.415373809569) | |||
| 68004 | 68004 | 240379 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 87 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008087.13667 | 2107952.681 | 37.7684931737476 | -122.41532408966002 | (37.7684931737476, -122.41532408966) | |||
| 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) | |||
| 68882 | 68882 | 184399 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2085 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5982287.3567 | 2100926.0377 | 37.7477162005877 | -122.50404126767499 | (37.7477162005877, -122.504041267675) | |||
| 69594 | 69594 | 214034 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 218 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 1ft | 5998609.02608 | 2093807.55818 | 37.729116861544206 | -122.447089829625 | (37.7291168615442, -122.447089829625) | |||
| 70290 | 70290 | 136305 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1110 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008618.494469999 | 2116385.90895 | 37.7916786547855 | -122.414082854345 | (37.7916786547855, -122.414082854345) | |||
| 70628 | 70628 | 240402 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4440 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000362.39575 | 2102290.8235 | 37.7525099241126 | -122.441636854259 | (37.7525099241126, -122.441636854259) | |||
| 71077 | 71077 | 240373 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1373 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6010904.97586 | 2101974.91384 | 37.7522375329589 | -122.405156394162 | (37.7522375329589, -122.405156394162) | |||
| 71181 | 71181 | 240388 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 65 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008348.72479 | 2098315.88712 | 37.742047422761296 | -122.413737549756 | (37.7420474227613, -122.413737549756) | |||
| 71286 | 71286 | 240425 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002456.8751300005 | 2096374.3168900001 | 37.736383692152295 | -122.433970918943 | (37.7363836921523, -122.433970918943) | |||
| 72433 | 72433 | 122278 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990134.53204 | 2111321.8992 | 37.776718780123794 | -122.477666227559 | (37.7767187801238, -122.477666227559) | |||
| 72907 | 72907 | 214025 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 118 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000768.8435 | 2094480.0839900002 | 37.7310866277439 | -122.439671378725 | (37.7310866277439, -122.439671378725) | |||
| 73278 | 73278 | 113422 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1583 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11 | 3x3 | 6015014.3399 | 2094064.2928 | 37.7307454784064 | -122.390392783554 | (37.7307454784064, -122.390392783554) | ||
| 73730 | 73730 | 240424 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002452.23233 | 2096379.1355 | 37.7363966594644 | -122.43398731536502 | (37.7363966594644, -122.433987315365) | |||
| 73887 | 73887 | 214033 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 342 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997821.19553 | 2093821.6931599998 | 37.7291106283447 | -122.449814429211 | (37.7291106283447, -122.449814429211) | |||
| 73938 | 73938 | 240417 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001765.76464 | 2096530.8335799999 | 37.736774205667295 | -122.436371571893 | (37.7367742056673, -122.436371571893) | |||
| 74280 | 74280 | 217578 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 308 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5993138.4427 | 2088550.8537 | 37.7143691463099 | -122.46562017697799 | (37.7143691463099, -122.465620176978) | |||
| 74323 | 74323 | 240374 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 99 Ramona Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005228.2825 | 2107285.15785 | 37.7664992238917 | -122.425165122599 | (37.7664992238917, -122.425165122599) | |||
| 74383 | 74383 | 240409 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 Arbor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002196.797259999 | 2096967.0919299999 | 37.7379965524899 | -122.434912495609 | (37.7379965524899, -122.434912495609) | |||
| 75103 | 75103 | 124546 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1001 Balboa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5992441.4203 | 2111328.77742 | 37.7768712692618 | -122.469686590816 | (37.7768712692618, -122.469686590816) | |||
| 75414 | 75414 | 240419 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001783.7465 | 2096493.5262099998 | 37.7366727900018 | -122.436306731665 | (37.7366727900018, -122.436306731665) | |||
| 75456 | 75456 | 240418 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001776.14511 | 2096508.8311299998 | 37.73671438186 | -122.436334107928 | (37.73671438186, -122.436334107928) | |||
| 75966 | 75966 | 197346 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1245 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008998.58265 | 2110487.32292 | 37.7755038918289 | -122.412350641372 | (37.7755038918289, -122.412350641372) | |||
| 76501 | 76501 | 240390 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 48 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005917.96775 | 2097681.76661 | 37.740169467433894 | -122.42209730935801 | (37.7401694674339, -122.422097309358) | |||
| 79717 | 79717 | 10670 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1045 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002868.606349099 | 2110598.6567928 | 37.775463691965896 | -122.43356363564301 | (37.7754636919659, -122.433563635643) | |||
| 79913 | 79913 | 179372 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 479 Goettingen St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010444.86472 | 2092384.67512 | 37.72587906384779 | -122.40607197057 | (37.7258790638478, -122.40607197057) | |||
| 80692 | 80692 | 100236 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 701X 39th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5983814.22353 | 2110811.1524900002 | 37.7749476096575 | -122.499491947241 | (37.7749476096575, -122.499491947241) | |||
| 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) | ||||
| 82346 | 82346 | 98673 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1898@green Leavenworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | ||||
| 82906 | 82906 | 98672 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1898@green Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | ||||
| 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) | |||
| 86432 | 86432 | 117228 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 66 POTOMAC ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6003144.0 | 2108708.0 | 37.7702880357607 | -122.43247591327801 | (37.7702880357607, -122.432475913278) | |||
| 86977 | 86977 | 122462 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1351 42nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5983044.58583163 | 2105938.11904156 | 37.7615224717284 | -122.501793626008 | (37.7615224717284, -122.501793626008) | ||||
| 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) | ||||
| 91393 | 91393 | 100238 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 701X 39th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5983814.58777 | 2110777.43528 | 37.774855053302495 | -122.499488194975 | (37.7748550533025, -122.499488194975) | |||
| 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) | |||
| 96974 | 96974 | 112589 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 776 TEHAMA ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009004.0 | 2110266.0 | 37.7748964951756 | -122.41231625471 | (37.7748964951756, -122.41231625471) | |||||
| 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) | ||||
| 98519 | 98519 | 101262 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1948 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989728.00904 | 2106533.07201 | 37.76354637066729 | -122.47872218339701 | (37.7635463706673, -122.478722183397) | ||||
| 99236 | 99236 | 101956 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 510X Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6x6 | 6012441.7 | 2108540.8 | 37.7703517934984 | -122.400303251175 | (37.7703517934984, -122.400303251175) | |||
| 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) | ||||
| 104373 | 104373 | 100234 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 701X 39th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5983811.49615 | 2110876.46915 | 37.7751267903243 | -122.499506209788 | (37.7751267903243, -122.499506209788) | |||
| 105477 | 105477 | 112588 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 776 TEHAMA ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009004.0 | 2110266.0 | 37.7748964951756 | -122.41231625471 | (37.7748964951756, -122.41231625471) | |||||
| 111749 | 111749 | 113423 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1583 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6015002.21794725 | 2094078.95124561 | 37.730785055109294 | -122.39043571521799 | (37.7307850551093, -122.390435715218) | |||
| 115313 | 115313 | 98671 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1898@green Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | ||||
| 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) | |||
| 116622 | 116622 | 214030 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 133 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6000729.565880001 | 2094512.14983 | 37.7311724374522 | -122.439809466051 | (37.7311724374522, -122.439809466051) | |||
| 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) | |||
| 125050 | 125050 | 240396 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 122 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005552.307130001 | 2096648.4643 | 37.737311620735895 | -122.42328818262301 | (37.7373116207359, -122.423288182623) | |||
| 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) | |||
| 129548 | 129548 | 214017 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1438 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993685.58433 | 2105688.82171 | 37.761457274651605 | -122.464972976223 | (37.7614572746516, -122.464972976223) | |||
| 129693 | 129693 | 122288 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990072.179690001 | 2111319.40231 | 37.776708305720796 | -122.477881737882 | (37.7767083057208, -122.477881737882) | |||
| 129970 | 129970 | 214013 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1483 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5992099.86454 | 2105356.08672 | 37.760452112299795 | -122.47043304005899 | (37.7604521122998, -122.470433040059) | |||
| 130150 | 130150 | 240411 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 235 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001924.04211 | 2096180.04982 | 37.7358200267578 | -122.435799247861 | (37.7358200267578, -122.435799247861) | |||
| 130254 | 130254 | 136325 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 464 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011322.0 | 2118712.0 | 37.7982170161506 | -122.404892537684 | (37.7982170161506, -122.404892537684) | |||
| 130949 | 130949 | 181350 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2270 25th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5988575.9018 | 2099879.6972 | 37.745211025577895 | -122.48221942866999 | (37.7452110255779, -122.48221942867) | |||
| 131206 | 131206 | 179380 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 77 Santa Cruz Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5993077.06779 | 2086425.7469099998 | 37.7085305695939 | -122.46567800964199 | (37.7085305695939, -122.465678009642) | |||
| 132552 | 132552 | 136315 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 895 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009067.06929 | 2119033.92208 | 37.7989746333364 | -122.41271806751001 | (37.7989746333364, -122.41271806751) | |||
| 132729 | 132729 | 197335 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1512 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014078.36763 | 2102008.61135 | 37.7525069563416 | -122.394184584264 | (37.7525069563416, -122.394184584264) | |||
| 132831 | 132831 | 201725 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1915 Quesada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6013561.8417 | 2095888.78027 | 37.735674466103795 | -122.39554210998199 | (37.7356744661038, -122.395542109982) | ||||
| 133530 | 133530 | 136299 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 21 Mallorca Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001939.11813 | 2119948.35287 | 37.8010827755037 | -122.43744862338 | (37.8010827755037, -122.43744862338) | |||
| 134645 | 134645 | 214022 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 659 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997050.53703 | 2094389.3323099997 | 37.7306251064676 | -122.45251959171101 | (37.7306251064676, -122.452519591711) | |||
| 134723 | 134723 | 214040 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 111 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5999932.25708 | 2094051.5429 | 37.729862301496 | -122.442532837136 | (37.729862301496, -122.442532837136) | |||
| 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) | |||
| 135749 | 135749 | 122280 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990124.518680001 | 2111321.36168 | 37.776716723141206 | -122.477700827061 | (37.7767167231412, -122.477700827061) | |||
| 135840 | 135840 | 117962 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4340 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5985111.43248 | 2111810.6865 | 37.7777680685843 | -122.495078411045 | (37.7777680685843, -122.495078411045) | |||
| 135936 | 135936 | 214037 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 510 Ramsell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5993017.248790001 | 2090566.81293 | 37.719897493047704 | -122.466185481793 | (37.7198974930477, -122.466185481793) | |||
| 137058 | 137058 | 136304 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1110 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008621.3641800005 | 2116364.4323 | 37.791619846337 | -122.414071405095 | (37.791619846337, -122.414071405095) | |||
| 137156 | 137156 | 118182 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 615 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5985646.494109999 | 2111667.23632 | 37.7774055049593 | -122.493216904169 | (37.7774055049593, -122.493216904169) | |||
| 137254 | 137254 | 124092 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 601 Funston Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5991890.07496 | 2111196.5227799998 | 37.776476251963295 | -122.47158420369101 | (37.7764762519633, -122.471584203691) | ||||
| 137258 | 137258 | 122279 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990130.41151 | 2111322.13937 | 37.7767192004406 | -122.477680499098 | (37.7767192004406, -122.477680499098) | |||
| 137736 | 137736 | 136324 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 448 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011401.0 | 2118734.0 | 37.798281838344 | -122.404620722239 | (37.798281838344, -122.404620722239) | |||
| 137888 | 137888 | 214039 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 57 Nordhoff St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6000414.26094 | 2095519.5651200002 | 37.7339206127394 | -122.440971772322 | (37.7339206127394, -122.440971772322) | |||
| 138246 | 138246 | 197352 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1240 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017442.65456 | 2093993.31463 | 37.7306849905143 | -122.381992698304 | (37.7306849905143, -122.381992698304) | |||
| 139489 | 139489 | 98670 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1898@green Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | ||||
| 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) | ||||
| 142203 | 142203 | 197348 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 776 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6009001.8467 | 2110254.60923 | 37.7748650979682 | -122.412322898178 | (37.7748650979682, -122.412322898178) | |||
| 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) | |||
| 145225 | 145225 | 186232 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1701 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984802.7052 | 2103358.5602 | 37.754542835963505 | -122.49552284211201 | (37.7545428359635, -122.495522842112) | |||
| 146433 | 146433 | 142182 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001064.3503 | 2110400.0934 | 37.7748159516075 | -122.439790732155 | (37.7748159516075, -122.439790732155) | |||
| 146955 | 146955 | 197338 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 501 Amador St | 9 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6017587.31479 | 2099538.4559 | 37.745918828809295 | -122.381878129198 | (37.7459188288093, -122.381878129198) | |||
| 147113 | 147113 | 184465 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2182 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5982354.8718 | 2100269.3302 | 37.745917034436296 | -122.503759179813 | (37.7459170344363, -122.503759179813) | |||
| 148073 | 148073 | 240372 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1373 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6010906.21016 | 2101953.93145 | 37.752179988937 | -122.40515064838199 | (37.752179988937, -122.405150648382) | |||
| 148155 | 148155 | 136300 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 119 Locust St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997500.209559999 | 2116012.95103 | 37.790023863549706 | -122.45252491659402 | (37.7900238635497, -122.452524916594) | |||
| 148592 | 148592 | 179377 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 11 Cross St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000163.43149 | 2088211.60643 | 37.7138403432439 | -122.441314779179 | (37.7138403432439, -122.441314779179) | |||
| 149259 | 149259 | 181332 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1458 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988697.9248 | 2105396.3508 | 37.760365379214605 | -122.482201591019 | (37.7603653792146, -122.482201591019) | |||
| 149302 | 149302 | 136316 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 895 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009084.75499 | 2119036.14381 | 37.798981726274 | -122.41265702602502 | (37.798981726274, -122.412657026025) | |||
| 149552 | 149552 | 246638 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 3320 Harrison St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6009023.34848 | 2099240.7850900004 | 37.7446248509555 | -122.411470234758 | (37.7446248509555, -122.411470234758) | ||||
| 149725 | 149725 | 136320 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 99 North Point St | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6010568.43745 | 2122006.8054400003 | 37.8072215900736 | -122.40773254351801 | (37.8072215900736, -122.407732543518) | |||
| 151712 | 151712 | 248239 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 298 Esmeralda Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6006759.33465 | 2099019.31967 | 37.7438895076886 | -122.419283056374 | (37.7438895076886, -122.419283056374) | ||||
| 152254 | 152254 | 183295 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1262 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981829.8203 | 2106490.9182 | 37.762968869451896 | -122.50603591567899 | (37.7629688694519, -122.506035915679) |
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");