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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 64837 | 64837 | 40044 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1322 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 1 | Permit Number 41281 | 6016731.9607 | 2093562.0843 | 37.729461643225704 | -122.384419676567 | (37.7294616432257, -122.384419676567) | |
| 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) | |||
| 66650 | 66650 | 38870 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1551 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 2 | Permit Number 43029 | 5989746.74182688 | 2105808.42580632 | 37.7615577752966 | -122.47860439661501 | (37.7615577752966, -122.478604396615) | |
| 66939 | 66939 | 32596 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1474 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 2 | Permit Number 37064 | 5985605.53989408 | 2105188.12612078 | 37.759613297357895 | -122.492881221287 | (37.7596132973579, -122.492881221287) | |
| 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) | |||
| 68181 | 68181 | 47745 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4201 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/2002 12:00:00 AM | 5 | Permit Number 45527 | 5982377.51547 | 2113061.47559 | 37.7810419369254 | -122.50462850953998 | (37.7810419369254, -122.50462850954) | |
| 68843 | 68843 | 32524 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 862 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 4 | Permit Number 37026 | 6007537.57048 | 2095302.13495 | 37.733726737790796 | -122.416328859904 | (37.7337267377908, -122.416328859904) | |
| 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) | |||
| 70411 | 70411 | 41218 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 21 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 5 | Permit Number 41926 | 6001937.22199 | 2119965.3728 | 37.8011293999489 | -122.43745640431001 | (37.8011293999489, -122.43745640431) | |
| 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) | |||
| 70953 | 70953 | 41210 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3537 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 2 | Permit Number 41919 | 6002146.81597 | 2120360.9832900004 | 37.8022275558181 | -122.436759454895 | (37.8022275558181, -122.436759454895) | |
| 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) | |||
| 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) | |
| 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) | ||
| 75380 | 75380 | 40197 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4845 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983545.15866 | 2111697.12052 | 37.7773644306872 | -122.50048820674401 | (37.7773644306872, -122.500488206744) | |
| 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) | |||
| 77080 | 77080 | 38895 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 123 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 4 | Permit Number 40710 | 5996840.66245358 | 2113625.05698332 | 37.7834295330259 | -122.454634297306 | (37.7834295330259, -122.454634297306) | |
| 78673 | 78673 | 40783 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 410 Monticello St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | ||
| 78709 | 78709 | 67518 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 342 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/08/1994 12:00:00 AM | Permit Number 31054 | 5997814.69503285 | 2093832.35785798 | 37.729139539152705 | -122.44983767011499 | (37.7291395391527, -122.449837670115) | ||
| 78865 | 78865 | 41694 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 444 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42146 | 6003561.9148943005 | 2096429.88916823 | 37.7365989305362 | -122.430154297904 | (37.7365989305362, -122.430154297904) | ||
| 79175 | 79175 | 47698 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 297 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45496 | 6000129.38189454 | 2094930.1458917998 | 37.732285975496104 | -122.44191439219401 | (37.7322859754961, -122.441914392194) | ||
| 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) | |||
| 80145 | 80145 | 39731 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3472 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41103 | 6003734.27078033 | 2106581.04610194 | 37.7644813903829 | -122.430282399811 | (37.7644813903829, -122.430282399811) | ||
| 80885 | 80885 | 41663 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1376 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42129 | 5999046.52257313 | 2104716.21389633 | 37.7590943881005 | -122.44636181286998 | (37.7590943881005, -122.44636181287) | ||
| 81218 | 81218 | 95802 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1512 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767546 | 6014097.5 | 2102025.1 | 37.7525532940671 | -122.394119575027 | (37.7525532940671, -122.394119575027) | |
| 81988 | 81988 | 69511 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 457 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | Permit Number 33638 | 6008927.18415449 | 2096207.51304953 | 37.736290754505 | -122.41158848323201 | (37.736290754505, -122.411588483232) | ||
| 82592 | 82592 | 38845 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1333 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40675 | 5989863.06342131 | 2106288.82741716 | 37.76288358166779 | -122.47823721882601 | (37.7628835816678, -122.478237218826) | ||
| 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) | |||
| 83275 | 83275 | 94656 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 118 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53795 | 6000765.0 | 2094410.0 | 37.7308939745429 | -122.439679643784 | (37.7308939745429, -122.439679643784) |
| 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) | |
| 83910 | 83910 | 38217 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 350 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40338 | 6010576.45287423 | 2092372.10995681 | 37.7258519216371 | -122.405616192564 | (37.7258519216371, -122.405616192564) | ||
| 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) | ||
| 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) | ||
| 86331 | 86331 | 40032 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1660 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41274 | 6014934.45622927 | 2095941.56583888 | 37.7358956578297 | -122.390800100159 | (37.7358956578297, -122.390800100159) | ||
| 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) | |||
| 87056 | 87056 | 102078 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 35 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769728 | 6005184.6 | 2096720.6 | 37.737488929995706 | -122.42456464703699 | (37.7374889299957, -122.424564647037) |
| 87400 | 87400 | 38061 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1802 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40254 | 6001102.14351194 | 2114546.50782632 | 37.786203101297396 | -122.439957367186 | (37.7862031012974, -122.439957367186) | ||
| 87982 | 87982 | 68973 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3541 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | Permit Number 32963 | 5999700.01023575 | 2120669.59399303 | 37.8029355580023 | -122.445248759265 | (37.8029355580023, -122.445248759265) | ||
| 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) | |||
| 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) | ||
| 90488 | 90488 | 57281 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2469 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | Permit Number 14578 | 5992015.46997478 | 2098642.50003897 | 37.7420134642029 | -122.470236020298 | (37.7420134642029, -122.470236020298) | ||
| 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) | ||
| 91962 | 91962 | 41706 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 235 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42155 | 6001936.91803675 | 2096162.95952183 | 37.7357738321427 | -122.435753508421 | (37.7357738321427, -122.435753508421) | ||
| 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) | |||
| 93817 | 93817 | 35102 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 778 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767512 | 6001912.66160072 | 2089308.81779253 | 37.716952534231794 | -122.435347237927 | (37.7169525342318, -122.435347237927) | |
| 95064 | 95064 | 41700 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 135 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42150 | 6002619.11270974 | 2096812.53264581 | 37.7375961375204 | -122.43344130209499 | (37.7375961375204, -122.433441302095) | ||
| 95358 | 95358 | 47718 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45513 | 6003399.03676128 | 2096258.54340471 | 37.7361192276447 | -122.430705213698 | (37.7361192276447, -122.430705213698) | ||
| 95536 | 95536 | 69021 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2095 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | Permit Number 33025 | 5981665.37116425 | 2100840.03174895 | 37.747443456100704 | -122.506185646516 | (37.7474434561007, -122.506185646516) | ||
| 96051 | 96051 | 40031 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1656 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41273 | 6014957.20136248 | 2095924.63791994 | 37.7358504391775 | -122.390720277971 | (37.7358504391775, -122.390720277971) | ||
| 96815 | 96815 | 58515 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1465 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/2004 12:00:00 AM | Permit Number 30484 | 5998691.7005410995 | 2108280.83754266 | 37.76886167705071 | -122.447845581015 | (37.7688616770507, -122.447845581015) | ||
| 97169 | 97169 | 49152 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2464 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2003 12:00:00 AM | Permit Number 46274 | 5991742.04430079 | 2098660.96480908 | 37.7420483520093 | -122.47118277506901 | (37.7420483520093, -122.471182775069) | ||
| 97449 | 97449 | 102592 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 124 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | FUF 1 | 04/17/2010 12:00:00 AM | 3 | 6x6 | 6000765.0 | 2094428.0 | 37.7309433983829 | -122.439680933747 | (37.7309433983829, -122.439680933747) | |
| 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) | ||||
| 98414 | 98414 | 22550 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 23 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2008 12:00:00 AM | 4 | 2x3 | 6001475.729427099 | 2098645.6307198997 | 37.742564460006896 | -122.437525748228 | (37.7425644600069, -122.437525748228) | ||
| 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) | ||||
| 99110 | 99110 | 38000 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2454 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40212 | 5992064.31245936 | 2098735.51233127 | 37.742271675931896 | -122.47007391125601 | (37.7422716759319, -122.470073911256) | ||
| 99237 | 99237 | 48566 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 638 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | Permit Number 45985 | 5993535.88564574 | 2090091.48019383 | 37.7186222534444 | -122.464358255955 | (37.7186222534444, -122.464358255955) | ||
| 99913 | 99913 | 38034 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 71 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40237 | 5993126.63617522 | 2098605.576855 | 37.7419762612493 | -122.466391311334 | (37.7419762612493, -122.466391311334) | ||
| 99989 | 99989 | 50515 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 Ankeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | Permit Number 47153 | 6011089.84046191 | 2089620.59314796 | 37.718325516545704 | -122.40364792757799 | (37.7183255165457, -122.403647927578) | ||
| 101850 | 101850 | 38881 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40703 | 5996508.72142362 | 2113802.71293841 | 37.7838982845648 | -122.455795523067 | (37.7838982845648, -122.455795523067) | ||
| 102334 | 102334 | 40175 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1779 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1999 12:00:00 AM | Permit Number 41366 | 6008032.61088554 | 2108096.47604813 | 37.7688849366199 | -122.415522872015 | (37.7688849366199, -122.415522872015) | ||
| 102926 | 102926 | 112527 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 459 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011361.0 | 2118561.0 | 37.797804586609004 | -122.40474694923401 | (37.797804586609, -122.404746949234) | ||||
| 103072 | 103072 | 68820 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 215 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32768 | 5999394.70937931 | 2093830.63611547 | 37.729225087217294 | -122.444375326018 | (37.7292250872173, -122.444375326018) | ||
| 105121 | 105121 | 69026 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3826 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | Permit Number 33030 | 5981605.36463184 | 2100817.40426398 | 37.7473777946481 | -122.506391463775 | (37.7473777946481, -122.506391463775) | ||
| 105619 | 105619 | 11343 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1300X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/1999 12:00:00 AM | 16 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.730677746775605 | -122.382320962891 | (37.7306777467756, -122.382320962891) | ||
| 105918 | 105918 | 94658 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53796 | 6000765.0 | 2094447.0 | 37.73099556799129 | -122.43968229537701 | (37.7309955679913, -122.439682295377) |
| 106034 | 106034 | 41818 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 66 Encanto Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42204 | 6000020.46726166 | 2112594.97224476 | 37.7807830542731 | -122.44355943151699 | (37.7807830542731, -122.443559431517) | ||
| 106194 | 106194 | 102595 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 133 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769795 | 6000714.8 | 2094523.9 | 37.7312038601891 | -122.439861356334 | (37.7312038601891, -122.439861356334) |
| 107370 | 107370 | 67614 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1257 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52284 | 6005831.35096236 | 2120311.65664048 | 37.8023008263457 | -122.42400565450001 | (37.8023008263457, -122.4240056545) | |
| 107845 | 107845 | 42769 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1045 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42745 | 6002868.75255453 | 2110597.66752235 | 37.7754609839703 | -122.43356305917 | (37.7754609839703, -122.43356305917) | ||
| 108701 | 108701 | 72276 | 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) | ||
| 108862 | 108862 | 48965 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4287 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2002 12:00:00 AM | Permit Number 46152 | 6001312.92675412 | 2102294.38376547 | 37.7525738106184 | -122.438350019053 | (37.7525738106184, -122.438350019053) | ||
| 109001 | 109001 | 55144 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1438 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/1995 12:00:00 AM | Permit Number 11048 | 5993686.04342696 | 2105701.01392221 | 37.7614907777587 | -122.46497227391501 | (37.7614907777587, -122.464972273915) | ||
| 109498 | 109498 | 41751 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1100 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.41252459171899 | (37.7916912386009, -122.412524591719) | ||
| 110717 | 110717 | 93721 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1434 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2010 12:00:00 AM | 3x3 | Permit Number 53312 | 5992899.8 | 2097399.6 | 37.73865186152071 | -122.467087971441 | (37.7386518615207, -122.467087971441) | ||
| 111478 | 111478 | 39381 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1367 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/28/2001 12:00:00 AM | Permit Number 43822 | 6007199.57850018 | 2107537.80288531 | 37.7673040926749 | -122.418364663242 | (37.7673040926749, -122.418364663242) | ||
| 111533 | 111533 | 25183 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3448X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 6 | 3X3 | 6000085.2661190005 | 2103906.7160847997 | 37.7569309776636 | -122.442711229464 | (37.7569309776636, -122.442711229464) | ||
| 112273 | 112273 | 66617 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 537 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1994 12:00:00 AM | Permit Number 29820 | 6003370.78769204 | 2095896.23030716 | 37.7351227979483 | -122.430777034501 | (37.7351227979483, -122.430777034501) | ||
| 113166 | 113166 | 63504 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2185 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/07/1987 12:00:00 AM | Permit Number 24108 | 5999131.28808567 | 2111466.68826776 | 37.7776343263975 | -122.44655432302099 | (37.7776343263975, -122.446554323021) | ||
| 113228 | 113228 | 46365 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4529 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2016 12:00:00 AM | 3 | Permit Number 777876 | 6000886.82649096 | 2105194.29533435 | 37.7605120176306 | -122.44003146279199 | (37.7605120176306, -122.440031462792) | ||
| 113357 | 113357 | 18570 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 698X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 6 | 3X3 | 5992368.005846401 | 2088553.4079402 | 37.7143316913291 | -122.46828327353701 | (37.7143316913291, -122.468283273537) | ||
| 113563 | 113563 | 18603 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 520 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/25/1996 12:00:00 AM | 6 | 3X3 | 5992619.61154 | 2088559.40218 | 37.7143626789426 | -122.467414068351 | (37.7143626789426, -122.467414068351) | ||
| 114349 | 114349 | 87933 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3110 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50954 | 6001440.0 | 2119068.0 | 37.7986371703342 | -122.439112652204 | (37.7986371703342, -122.439112652204) | ||
| 114634 | 114634 | 38033 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | ||
| 114768 | 114768 | 42054 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 326 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42369 | 6006171.20759912 | 2101208.97418807 | 37.749868660690005 | -122.42147214171999 | (37.74986866069, -122.42147214172) | ||
| 115944 | 115944 | 69045 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1490 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 5 | Permit Number 33052 | 5984059.2399452 | 2105030.87804217 | 37.7590909914126 | -122.498217402727 | (37.7590909914126, -122.498217402727) | |
| 116845 | 116845 | 48626 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1648 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45923 | 5992496.87532412 | 2104233.57360814 | 37.757392932598 | -122.468978283216 | (37.757392932598, -122.468978283216) | ||
| 117895 | 117895 | 40701 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 547 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | Permit Number 41680 | 6005025.18813412 | 2093548.59411277 | 37.7287703058889 | -122.424890201858 | (37.7287703058889, -122.424890201858) | ||
| 118244 | 118244 | 32863 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 369 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37210 | 6002757.72867407 | 2101496.8738153 | 37.7504661097568 | -122.433296668218 | (37.7504661097568, -122.433296668218) |
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");