Data source: data.sfgov.org
This data as json, CSV (advanced)
qLegalStatus ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▼ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44130 | 44130 | 41755 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1630 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 5 | Permit Number 42184 | 6008378.01882 | 2118113.9596 | 37.79640994672071 | -122.415037267971 | (37.7964099467207, -122.415037267971) | ||
| 44795 | 44795 | 122290 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990062.61204 | 2111318.0216900003 | 37.7767039596239 | -122.47791473389799 | (37.7767039596239, -122.477914733898) | |||
| 45894 | 45894 | 136306 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1110 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6008615.340009999 | 2116402.44898 | 37.7917238924876 | -122.414094939449 | (37.7917238924876, -122.414094939449) | |||
| 46279 | 46279 | 240375 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 99 Ramona Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005227.26292 | 2107315.18034 | 37.7665816008793 | -122.425170785627 | (37.7665816008793, -122.425170785627) | |||
| 46494 | 46494 | 122286 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990082.62166 | 2111319.5038 | 37.7767091904138 | -122.477845623834 | (37.7767091904138, -122.477845623834) | |||
| 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) | |||
| 46883 | 46883 | 214041 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 431 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997281.4748599995 | 2093791.4004 | 37.7289965565343 | -122.451678093372 | (37.7289965565343, -122.451678093372) | |||
| 47021 | 47021 | 179382 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 143 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007980.64963 | 2093237.8287400003 | 37.728083504546596 | -122.414650965095 | (37.7280835045466, -122.414650965095) | |||
| 47391 | 47391 | 197344 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 670 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6012519.5716699995 | 2113947.09446 | 37.785200579973605 | -122.40041369075199 | (37.7852005799736, -122.400413690752) | |||
| 47422 | 47422 | 37962 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52636 | 6013967.394309999 | 2106347.66255 | 37.7644148813545 | -122.39487221400299 | (37.7644148813545, -122.394872214003) | |
| 47685 | 47685 | 214042 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 22 Gennessee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 5997465.40478 | 2093699.4723200002 | 37.728754675784394 | -122.451035610522 | (37.7287546757844, -122.451035610522) | |||
| 48149 | 48149 | 240393 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 35 Hill St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6006109.51353 | 2103440.5803799997 | 37.7559926584484 | -122.421843980221 | (37.7559926584484, -122.421843980221) | |||
| 48473 | 48473 | 92109 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 654 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52365 | 5981669.51861 | 2111284.19832 | 37.7761203861627 | -122.506945906937 | (37.7761203861627, -122.506945906937) | |
| 48717 | 48717 | 214026 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 124 Baden St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6000776.43659 | 2094502.29985 | 37.7311480595383 | -122.43964672023199 | (37.7311480595383, -122.439646720232) | |||
| 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) | |||
| 50462 | 50462 | 122282 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990106.33926 | 2111321.3026900003 | 37.7767155061466 | -122.477763710061 | (37.7767155061466, -122.477763710061) | |||
| 50859 | 50859 | 240415 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 751 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003800.46059 | 2107711.4253 | 37.7675888874331 | -122.43013411340901 | (37.7675888874331, -122.430134113409) | |||
| 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) | |||
| 51677 | 51677 | 81327 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3236 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50837 | 5999881.46394 | 2119701.75031 | 37.8002884744792 | -122.444551235949 | (37.8002884744792, -122.444551235949) | |
| 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) | |||
| 53789 | 53789 | 32019 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 900 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | Permit Number 35412 | 6012513.40810989 | 2108571.960758 | 37.7704413522571 | -122.40005739994601 | (37.7704413522571, -122.400057399946) | |||
| 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) | |||
| 54318 | 54318 | 37648 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1001 Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992433.05565 | 2111328.08721 | 37.776868890669206 | -122.46971547615499 | (37.7768688906692, -122.469715476155) | ||
| 54599 | 54599 | 240401 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000694.66286 | 2101176.32982 | 37.749468718214004 | -122.440407898332 | (37.749468718214, -122.440407898332) | |||
| 54931 | 54931 | 136322 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 360 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6011695.90155 | 2118747.3363 | 37.798334933855294 | -122.40360120733801 | (37.7983349338553, -122.403601207338) | |||
| 56127 | 56127 | 136318 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2431 Jones St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6007955.59027 | 2120758.45752 | 37.803647329033105 | -122.416686400679 | (37.8036473290331, -122.416686400679) | |||
| 56315 | 56315 | 240406 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003419.55137 | 2096211.39701 | 37.7359909366181 | -122.430630923178 | (37.7359909366181, -122.430630923178) | |||
| 56835 | 56835 | 240403 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 557 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002931.13898 | 2099759.29881 | 37.7457049727185 | -122.43257290392799 | (37.7457049727185, -122.432572903928) | |||
| 58619 | 58619 | 122287 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990077.48759 | 2111319.8179099998 | 37.776709754904104 | -122.477863406875 | (37.7767097549041, -122.477863406875) | |||
| 58725 | 58725 | 82802 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 770 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52410 | 5983565.30013547 | 2110567.26400669 | 37.7742633542941 | -122.500334977362 | (37.7742633542941, -122.500334977362) | ||
| 58739 | 58739 | 240420 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001790.0985900005 | 2096478.24715 | 37.7366311981596 | -122.436283676644 | (37.7366311981596, -122.436283676644) | |||
| 59339 | 59339 | 197337 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 501 Amador St | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6017571.01278 | 2099537.71438 | 37.7459158925037 | -122.381934448315 | (37.7459158925037, -122.381934448315) | |||
| 59699 | 59699 | 197345 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1277 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008901.33871 | 2110395.02653 | 37.7752450102959 | -122.41268050642599 | (37.7752450102959, -122.412680506426) | |||
| 61274 | 61274 | 197334 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1098 Mississippi St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6014199.99182 | 2102083.0983599997 | 37.7527182412529 | -122.39376919728501 | (37.7527182412529, -122.393769197285) | |||
| 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) | |||
| 62196 | 62196 | 240395 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 37 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6005177.74113 | 2096695.2803099998 | 37.7374190204687 | -122.42458656083201 | (37.7374190204687, -122.424586560832) | |||
| 63135 | 63135 | 82850 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1457 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52367 | 6015981.5985 | 2094038.4652 | 37.730728169212 | -122.387046987845 | (37.730728169212, -122.387046987845) | |
| 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) | ||||
| 65292 | 65292 | 87805 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 21 Mallorca Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50570 | 6001886.8 | 2119949.6 | 37.8010832252731 | -122.437629755692 | (37.8010832252731, -122.437629755692) | |||
| 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) | |||
| 73555 | 73555 | 37647 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1001 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992426.792 | 2111328.0458 | 37.7768684149352 | -122.469737140808 | (37.7768684149352, -122.469737140808) | ||
| 73689 | 73689 | 87871 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2335 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50842 | 6000134.07181 | 2119870.32478 | 37.8007657456038 | -122.44368923307199 | (37.8007657456038, -122.443689233072) | |
| 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) | |||
| 77489 | 77489 | 33057 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 328 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37328 | 6006171.76331287 | 2101198.94449976 | 37.7498411527935 | -122.421469507825 | (37.7498411527935, -122.421469507825) | |||
| 79480 | 79480 | 41761 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1320-1360 Lombard St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041.0 | 2120044.0 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | ||
| 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) | |||
| 80857 | 80857 | 38028 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2490X 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40235 | 5992179.14418088 | 2098457.94829189 | 37.7415161934278 | -122.46965666006399 | (37.7415161934278, -122.469656660064) | |||
| 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) | ||||
| 82699 | 82699 | 89314 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2005 12:00:00 AM | 3x3 | Permit Number 48328 | 6002340.0 | 2108819.0 | 37.7705471897255 | -122.43526488371799 | (37.7705471897255, -122.435264883718) | ||
| 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) | ||||
| 82920 | 82920 | 89199 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3236 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51816 | 5999889.0 | 2119639.0 | 37.8001166089052 | -122.444520645891 | (37.8001166089052, -122.444520645891) | ||
| 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) | |||
| 83362 | 83362 | 63013 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 51 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767771 | 6007430.33105591 | 2097971.50142259 | 37.7410501993506 | -122.416888678035 | (37.7410501993506, -122.416888678035) | |
| 84205 | 84205 | 41767 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1320-1360 Lombard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041.0 | 2120044.0 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | ||
| 84367 | 84367 | 97195 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 390X Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2015 12:00:00 AM | 3 | Permit Number 775228 | 6011720.2 | 2118742.9 | 37.7983241100995 | -122.403516814582 | (37.7983241100995, -122.403516814582) | ||
| 84564 | 84564 | 82884 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 398 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52426 | 6008893.02169344 | 2108709.50255899 | 37.770616489827106 | -122.412590100264 | (37.7706164898271, -122.412590100264) | ||
| 84570 | 84570 | 48905 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2200X Clay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.790896187279394 | -122.42927158905898 | (37.7908961872794, -122.429271589059) | |||
| 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) | |||
| 86666 | 86666 | 88224 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1821 Hayes St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51220 | 5999142.0 | 2110084.0 | 37.7738384306008 | -122.446417770519 | (37.7738384306008, -122.446417770519) | |||
| 87149 | 87149 | 87870 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3236 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50837 | 5999889.0 | 2119639.0 | 37.8001166089052 | -122.444520645891 | (37.8001166089052, -122.444520645891) | ||
| 88341 | 88341 | 50562 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2365 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2003 12:00:00 AM | Permit Number 47184 | 5998950.78977652 | 2112707.00584702 | 37.7810296062885 | -122.44726801598401 | (37.7810296062885, -122.447268015984) | |||
| 88994 | 88994 | 41759 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1320-1360 Lombard St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041.0 | 2120044.0 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | ||
| 90205 | 90205 | 67457 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 709 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52276 | 6002046.91633096 | 2110893.18552424 | 37.7762257387634 | -122.43642713667299 | (37.7762257387634, -122.436427136673) | ||
| 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) | |||
| 91660 | 91660 | 87934 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3600 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50956 | 5982309.0 | 2100840.0 | 37.7474812377595 | -122.503960055968 | (37.7474812377595, -122.503960055968) | ||
| 92053 | 92053 | 88271 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 142 Belvedere St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51257 | 5998321.8 | 2107947.7 | 37.7679258166536 | -122.449101033169 | (37.7679258166536, -122.449101033169) | |||
| 92257 | 92257 | 33453 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 343 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37554 | 6006165.48085512 | 2098035.43238588 | 37.7411545114342 | -122.421266615711 | (37.7411545114342, -122.421266615711) | |||
| 93181 | 93181 | 86997 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 248 Day St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2007 12:00:00 AM | 3x3 | Permit Number 49939 | 6004323.0 | 2098701.0 | 37.742877960826604 | -122.42768466378 | (37.7428779608266, -122.42768466378) | ||
| 93271 | 93271 | 8100 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 765 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1998 12:00:00 AM | 6 | 3X3 | 6004193.95704 | 2111472.64562 | 37.7779385589247 | -122.429041260431 | (37.7779385589247, -122.429041260431) |
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");