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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||
31206 | 31206 | 246759 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 70 Waltham St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6009196.74806 | 2098886.80636 | 37.7436626276403 | -122.410845655606 | (37.7436626276403, -122.410845655606) | ||||
35367 | 35367 | 197333 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1501 25th St | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6014202.148440001 | 2101967.42619 | 37.7524007500093 | -122.39375364352301 | (37.7524007500093, -122.393753643523) | ||||
35612 | 35612 | 72078 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 167 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1984 12:00:00 AM | 5 | 5989583.57132 | 2114255.42421 | 37.784741432124 | -122.479786850818 | (37.784741432124, -122.479786850818) | ||
38193 | 38193 | 246761 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 70 Waltham St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6009235.422669999 | 2098888.8268 | 37.7436703438078 | -122.410712070303 | (37.7436703438078, -122.410712070303) | ||||
38403 | 38403 | 197339 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 696 Amador St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6016827.1128 | 2099574.92506 | 37.745976956489294 | -122.384509368331 | (37.7459769564893, -122.384509368331) | ||||
39381 | 39381 | 74867 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 3501 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 4 | 5997417.18704 | 2116038.42588 | 37.7900890536146 | -122.452814005488 | (37.7900890536146, -122.452814005488) | ||
41388 | 41388 | 75003 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 3501 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 5 | 5997399.304819999 | 2116036.40743 | 37.7900824867734 | -122.452875730442 | (37.7900824867734, -122.452875730442) | ||
41529 | 41529 | 73403 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 81 Lyell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 4 | 6003121.9233099995 | 2094558.5911 | 37.7314358416937 | -122.43154198316999 | (37.7314358416937, -122.43154198317) | ||
43322 | 43322 | 246767 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 70 Waltham St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6009322.267109999 | 2098890.11567 | 37.743678751571295 | -122.410411873024 | (37.7436787515713, -122.410411873024) | ||||
43641 | 43641 | 179373 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 670 Brunswick St | 17 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 5998557.70629 | 2086647.36142 | 37.709453678716706 | -122.446752254708 | (37.7094536787167, -122.446752254708) | ||||
45898 | 45898 | 78303 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4200 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 8 | 5985601.84615 | 2111830.0583200003 | 37.7778499560934 | -122.493383352985 | (37.7778499560934, -122.493383352985) | ||
52507 | 52507 | 72377 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2015 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 3 | 5989328.1004 | 2111226.70664 | 37.776410575889 | -122.480448911859 | (37.776410575889, -122.480448911859) | ||
59518 | 59518 | 74566 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 3501 Jackson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 4 | 5997456.57692 | 2116043.58234 | 37.7901054689466 | -122.452678092717 | (37.7901054689466, -122.452678092717) | ||
62331 | 62331 | 70121 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2220 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 4 | 5988662.200680001 | 2110577.24438 | 37.7745886129839 | -122.48270481422199 | (37.7745886129839, -122.482704814222) | ||
63782 | 63782 | 197353 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 22nd St | 13 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6012786.799 | 2103803.61301 | 37.7573637666391 | -122.398777038841 | (37.7573637666391, -122.398777038841) | ||||
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) | ||||
74893 | 74893 | 73753 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2019 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 7 | 5989295.11737 | 2111227.81825 | 37.7764117112404 | -122.480563089536 | (37.7764117112404, -122.480563089536) | ||
84043 | 84043 | 73758 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2220 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 6 | 5988694.038819999 | 2110577.4842 | 37.774591123751605 | -122.48259469871799 | (37.7745911237516, -122.482594698718) | ||
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) | ||||
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) | ||||
142202 | 142202 | 70387 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 81 Lyell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 4 | 6003118.96111 | 2094567.6101799998 | 37.7314604381496 | -122.431552867694 | (37.7314604381496, -122.431552867694) | ||
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) | ||||
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) | ||||
153374 | 153374 | 74719 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 3501 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 4 | 5997437.82689 | 2116041.06971 | 37.7900974955643 | -122.45274278455099 | (37.7900974955643, -122.452742784551) | ||
157777 | 157777 | 197340 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 696 Amador St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6016813.36643 | 2099575.53369 | 37.745977867490204 | -122.384556944272 | (37.7459778674902, -122.384556944272) | ||||
158949 | 158949 | 197336 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 651 Missouri St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6013643.57223 | 2103811.4939599996 | 37.757433106182 | -122.39581450923201 | (37.757433106182, -122.395814509232) | ||||
159069 | 159069 | 72309 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 3555 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 4 | 5997281.41005 | 2116017.68654 | 37.7900243276015 | -122.45328228245701 | (37.7900243276015, -122.453282282457) | ||
166990 | 166990 | 136321 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Francisco St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6010437.78302 | 2121369.6786 | 37.8054648831642 | -122.408139740375 | (37.8054648831642, -122.408139740375) | ||||
169753 | 169753 | 70219 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2519 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1993 12:00:00 AM | 2 | 5999766.96115 | 2119470.2848900002 | 37.7996463981067 | -122.444930811031 | (37.7996463981067, -122.444930811031) | ||
172123 | 172123 | 240382 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 200 Kingston St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6006224.51109 | 2098080.7337 | 37.7412822264814 | -122.4210657258 | (37.7412822264814, -122.4210657258) | ||||
175872 | 175872 | 78389 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4200 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 8 | 5985613.90998 | 2111830.68363 | 37.77785237866 | -122.49334166667101 | (37.77785237866, -122.493341666671) | ||
178929 | 178929 | 247983 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 497 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6009757.51939 | 2099637.18115 | 37.74575442014729 | -122.408959568646 | (37.7457544201473, -122.408959568646) | ||||
179103 | 179103 | 197332 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1501 25th St | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6014163.86905 | 2101969.79141 | 37.752405117125896 | -122.393886186499 | (37.7524051171259, -122.393886186499) | ||||
185231 | 185231 | 197341 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 696 Amador St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6016796.90554 | 2099573.89089 | 37.745972446388 | -122.384613749949 | (37.745972446388, -122.384613749949) | ||||
185623 | 185623 | 78275 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 65 Pomona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2000 12:00:00 AM | 7 | 6014137.61661 | 2094337.2388799998 | 37.7314462603177 | -122.39344287108901 | (37.7314462603177, -122.393442871089) | ||
187182 | 187182 | 247984 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 497 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009751.76686 | 2099644.8640900003 | 37.745775193576705 | -122.408980002136 | (37.7457751935767, -122.408980002136) | ||||
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) | ||||
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) | ||
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) | ||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | ||||
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) | |||||
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) | ||||
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) | ||||
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) | ||
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) | ||||
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) | |||
176461 | 176461 | 103083 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 670 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012579.2635 | 2114003.58062 | 37.785359006363 | -122.40021114274599 | (37.785359006363, -122.400211142746) | |||
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) | |||
183319 | 183319 | 106008 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1800X Lane St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6014836.2656 | 2094091.4986 | 37.7308103003106 | -122.391010320168 | (37.7308103003106, -122.391010320168) | |||
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) | |
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
31223 | 31223 | 184437 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2115 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5982295.3096 | 2100678.1438 | 37.7470360206297 | -122.50399540910401 | (37.7470360206297, -122.503995409104) | |||
32809 | 32809 | 137686 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2143 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999343.9567 | 2111495.7816 | 37.7777263543907 | -122.445820725833 | (37.7777263543907, -122.445820725833) | |||
33040 | 33040 | 185413 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2300 Sunset Blvd | 29 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5985092.6382 | 2099208.8841 | 37.7431659316065 | -122.49421435006501 | (37.7431659316065, -122.494214350065) | |||
37930 | 37930 | 186236 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1701 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984809.6691 | 2103350.7929 | 37.75452191688171 | -122.495498186629 | (37.7545219168817, -122.495498186629) | |||
40074 | 40074 | 181349 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2254 29th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5987333.026000001 | 2099936.24 | 37.745293905616705 | -122.48652117681601 | (37.7452939056167, -122.486521176816) | |||
50005 | 50005 | 181948 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1813 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5987556.2457 | 2098923.5959 | 37.742526463070796 | -122.48567502435301 | (37.7425264630708, -122.485675024353) | |||
50906 | 50906 | 200055 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1800 Lane St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014871.4407 | 2094140.9637 | 37.7309480732984 | -122.390892168964 | (37.7309480732984, -122.390892168964) | |||
53292 | 53292 | 217579 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 636 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5992273.5996 | 2088560.7555 | 37.714346412845295 | -122.46861011007299 | (37.7143464128453, -122.468610110073) | |||
54123 | 54123 | 140855 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 621 Euclid Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5996425.9427 | 2113796.2189 | 37.7838757026194 | -122.45608143549101 | (37.7838757026194, -122.456081435491) | |||
61590 | 61590 | 137691 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2175 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999187.5809 | 2111472.1809 | 37.7776526229954 | -122.44635998308 | (37.7776526229954, -122.44635998308) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
153152 | 153152 | 141053 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 196 PARKER AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5996969.9558 | 2113061.6744 | 37.781890048327206 | -122.45414629097999 | (37.7818900483272, -122.45414629098) | |||
153549 | 153549 | 184960 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1990 41st Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983549.8392 | 2101614.3877 | 37.7496803803898 | -122.499726609203 | (37.7496803803898, -122.499726609203) | |||
155475 | 155475 | 199669 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1909 Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015195.1623 | 2093397.888 | 37.7289256934462 | -122.38972111920602 | (37.7289256934462, -122.389721119206) | |||
155906 | 155906 | 183281 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1267 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5981168.1745 | 2106457.5745 | 37.762838347579006 | -122.50832180491899 | (37.762838347579, -122.508321804919) |
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");