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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||
| 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) | |||||
| 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) | ||||
| 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) | ||
| 23461 | 23461 | 240416 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 12 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003644.58951 | 2098299.35585 | 37.7417367402568 | -122.43000177276899 | (37.7417367402568, -122.430001772769) | |||
| 23811 | 23811 | 140094 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1652 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999863.0392 | 2110926.6558 | 37.7761933050322 | -122.44398414486 | (37.7761933050322, -122.44398414486) | |||
| 24847 | 24847 | 214027 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000768.47308 | 2094513.82924 | 37.7311792633149 | -122.439675077667 | (37.7311792633149, -122.439675077667) | |||
| 25257 | 25257 | 240410 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 235 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001912.29637 | 2096185.45895 | 37.735834211766 | -122.43584024433599 | (37.735834211766, -122.435840244336) | |||
| 26763 | 26763 | 240404 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4362 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000898.63467 | 2103311.26449 | 37.7553423460847 | -122.439855611169 | (37.7553423460847, -122.439855611169) | |||
| 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) | |||
| 27641 | 27641 | 240391 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 346 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006743.91028 | 2097051.2853599999 | 37.7384848564878 | -122.41919681678199 | (37.7384848564878, -122.419196816782) | |||
| 28437 | 28437 | 240376 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1367 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007185.77161 | 2107529.7326700003 | 37.76728115653079 | -122.41841184713499 | (37.7672811565308, -122.418411847135) | |||
| 30553 | 30553 | 240407 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 489 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6003411.63679 | 2096255.36709 | 37.7361112200507 | -122.430661423705 | (37.7361112200507, -122.430661423705) | |||
| 31386 | 31386 | 214044 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 119 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999274.87025 | 2093768.2240099998 | 37.729046879900295 | -122.444785134325 | (37.7290468799003, -122.444785134325) | |||
| 31525 | 31525 | 214031 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 119 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997420.89454 | 2093944.4368 | 37.7294247417474 | -122.45120714359501 | (37.7294247417474, -122.451207143595) | |||
| 31765 | 31765 | 214029 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 133 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6000729.59206 | 2094530.6160900001 | 37.7312231430208 | -122.43981069901301 | (37.7312231430208, -122.439810699013) | |||
| 32460 | 32460 | 214016 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1310 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992104.55451 | 2106488.0935299997 | 37.7635605748926 | -122.47049926614099 | (37.7635605748926, -122.470499266141) | |||
| 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) | |||
| 33363 | 33363 | 240383 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 65 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004954.4402 | 2108809.15318 | 37.770668274943205 | -122.426220805247 | (37.7706682749432, -122.426220805247) | |||
| 33748 | 33748 | 214024 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 118 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000768.15588 | 2094464.1173900003 | 37.7310427480136 | -122.43967261170201 | (37.7310427480136, -122.439672611702) | |||
| 38309 | 38309 | 120769 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4500 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5989405.82896 | 2109925.10593 | 37.7728412569544 | -122.48008475013701 | (37.7728412569544, -122.480084750137) | |||
| 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) | ||||
| 39197 | 39197 | 136301 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 119 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997498.90653 | 2116025.43206 | 37.790058058469 | -122.452530326034 | (37.790058058469, -122.452530326034) | |||
| 39998 | 39998 | 122277 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990139.99053 | 2111321.69927 | 37.7767185479371 | -122.477647330613 | (37.7767185479371, -122.477647330613) | |||
| 40291 | 40291 | 240392 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1803 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008038.16649 | 2107910.1392200002 | 37.768373611578205 | -122.415490461517 | (37.7683736115782, -122.415490461517) | |||
| 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) | ||
| 41992 | 41992 | 118563 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 8000 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5982185.81739 | 2112405.54556 | 37.7792296683273 | -122.50524304882099 | (37.7792296683273, -122.505243048821) | |||
| 42442 | 42442 | 136326 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 463 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011288.49181 | 2118628.67213 | 37.797986344959995 | -122.405002616378 | (37.79798634496, -122.405002616378) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 157900 | 157900 | 240389 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 457 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008913.61949 | 2096192.37009 | 37.7362484143157 | -122.41163431247601 | (37.7362484143157, -122.411634312476) | |||
| 158872 | 158872 | 197351 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1240 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017537.11653 | 2093985.5056900003 | 37.7306687649511 | -122.381665582497 | (37.7306687649511, -122.381665582497) | |||
| 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) | ||
| 159513 | 159513 | 214043 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 212 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998768.52981 | 2093586.90837 | 37.7285201208974 | -122.446522546303 | (37.7285201208974, -122.446522546303) | |||
| 162778 | 162778 | 179375 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 778 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001912.74857 | 2089301.2462099998 | 37.7169317492882 | -122.435346396016 | (37.7169317492882, -122.435346396016) | |||
| 164927 | 164927 | 240387 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 310 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008249.57192 | 2097137.15027 | 37.7388053020181 | -122.41399702216002 | (37.7388053020181, -122.41399702216) | |||
| 166318 | 166318 | 136303 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1110 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008623.1195 | 2116351.39928 | 37.7915841594399 | -122.414064409258 | (37.7915841594399, -122.414064409258) | |||
| 168439 | 168439 | 141052 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 196 PARKER AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5996973.34 | 2113043.0612 | 37.7818391354491 | -122.454133238512 | (37.7818391354491, -122.454133238512) | |||
| 168473 | 168473 | 183216 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 3150 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983362.6255 | 2100199.941 | 37.7457857131054 | -122.500269432817 | (37.7457857131054, -122.500269432817) | |||
| 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) | ||
| 169846 | 169846 | 181318 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1283 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5989233.022000001 | 2106632.6794 | 37.7637911125829 | -122.480441458463 | (37.7637911125829, -122.480441458463) | |||
| 171047 | 171047 | 214038 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 638 Head St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993525.3619099995 | 2090091.0611400001 | 37.718620496206796 | -122.46439460152901 | (37.7186204962068, -122.464394601529) | |||
| 171501 | 171501 | 214019 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 112 Dorado Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5994645.417119999 | 2093146.00663 | 37.7270731423102 | -122.460744326189 | (37.7270731423102, -122.460744326189) | |||
| 172426 | 172426 | 240394 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 27 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001499.24152 | 2098615.40839 | 37.742482813337 | -122.43744228675301 | (37.742482813337, -122.437442286753) | |||
| 172827 | 172827 | 214015 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1326 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5992108.78084 | 2106403.01661 | 37.763327220596 | -122.470478452218 | (37.763327220596, -122.470478452218) | |||
| 174298 | 174298 | 214014 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1462 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992138.117459999 | 2105483.85764 | 37.7608051492715 | -122.47031004699 | (37.7608051492715, -122.47031004699) | |||
| 175504 | 175504 | 179381 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 211 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004791.2259599995 | 2093805.4606400002 | 37.7294623864734 | -122.42571730003901 | (37.7294623864734, -122.425717300039) | |||
| 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) |
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");