trees
614 rows where qSpecies_id = 29
This data as json, CSV (advanced)
rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32542 | 214022 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 659 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997050.53703 | 2094389.33231 | 37.7306251064676 | -122.452519591711 | (37.7306251064676, -122.452519591711) | 9 | 7 | 4 | 28861 | 40 | |||
33110 | 197353 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 22nd St | 13 | Side Yard : Yard | Tree | Private 2 | 4 | 6012786.799 | 2103803.61301 | 37.7573637666391 | -122.398777038841 | (37.7573637666391, -122.398777038841) | 10 | 3 | 8 | 28856 | 29 | ||||
33342 | 41874 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 66 Belcher St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42253 | 6003778.26782897 | 2107952.91484982 | 37.7682507021815 | -122.430228105724 | (37.7682507021815, -122.430228105724) | 7 | 9 | 5 | 28862 | 3 | ||
33474 | 10670 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1045 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002868.6063491 | 2110598.6567928 | 37.7754636919659 | -122.433563635643 | (37.7754636919659, -122.433563635643) | 15 | 5 | 11 | 29492 | 10 | |||
34413 | 38029 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2490X 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40235 | 5992179.14418088 | 2098457.94829189 | 37.7415161934278 | -122.469656660064 | (37.7415161934278, -122.469656660064) | 1 | 8 | 4 | 29491 | 40 | ||
35359 | 94659 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 130 Baden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53796 | 6000765 | 2094447 | 37.7309955679913 | -122.439682295377 | (37.7309955679913, -122.439682295377) | 9 | 7 | 4 | 63 | 40 |
35401 | 26068 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 282 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2003 12:00:00 AM | 3 | 2X3 | 5994051.2236 | 2088339.7969 | 37.7138422407476 | -122.46244996961 | (37.7138422407476, -122.46244996961) | 9 | 8 | 6 | 28861 | 24 | ||
35846 | 113422 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1583 Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 3x3 | 6015014.3399 | 2094064.2928 | 37.7307454784064 | -122.390392783554 | (37.7307454784064, -122.390392783554) | 10 | 3 | 8 | 58 | 1 | ||
36318 | 112537 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 412 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011527.0722 | 2118728.84616 | 37.7982747323527 | -122.404184109226 | (37.7982747323527, -122.404184109226) | 3 | 1 | 10 | 308 | 23 | |||
36465 | 214012 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1479 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992097.04207 | 2105377.93896 | 37.7605119495939 | -122.47044439309 | (37.7605119495939, -122.47044439309) | 1 | 8 | 4 | 56 | 12 | |||
36649 | 43585 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 237 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43246 | 6004367.379779 | 2099245.61051184 | 37.7443758465625 | -122.427570002743 | (37.7443758465625, -122.427570002743) | 2 | 7 | 5 | 63 | 22 | ||
38756 | 41743 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.412524591719 | (37.7916912386009, -122.412524591719) | 5 | 1 | 10 | 28857 | 21 | ||
39109 | 186232 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1701 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984802.7052 | 2103358.5602 | 37.7545428359635 | -122.495522842112 | (37.7545428359635, -122.495522842112) | 1 | 8 | 3 | 56 | 35 | |||
39191 | 63013 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 51 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767771 | 6007430.33105591 | 2097971.50142259 | 37.7410501993506 | -122.416888678035 | (37.7410501993506, -122.416888678035) | 2 | 7 | 7 | 28859 | 2 | |
39553 | 214034 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 218 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 1ft | 5998609.02608 | 2093807.55818 | 37.7291168615442 | -122.447089829625 | (37.7291168615442, -122.447089829625) | 9 | 7 | 4 | 28861 | 40 | |||
40073 | 38845 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1333 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40675 | 5989863.06342131 | 2106288.82741716 | 37.7628835816678 | -122.478237218826 | (37.7628835816678, -122.478237218826) | 1 | 8 | 3 | 56 | 35 | ||
40164 | 136317 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 954 Vallejo St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6008931.36114 | 2118725.70113 | 37.7981207171523 | -122.413165857925 | (37.7981207171523, -122.413165857925) | 3 | 1 | 10 | 308 | 21 | |||
40275 | 95802 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1512 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767546 | 6014097.5 | 2102025.1 | 37.7525532940671 | -122.394119575027 | (37.7525532940671, -122.394119575027) | 10 | 3 | 8 | 28856 | 29 | |
40883 | 240415 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 751 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003800.46059 | 2107711.4253 | 37.7675888874331 | -122.430134113409 | (37.7675888874331, -122.430134113409) | 7 | 9 | 5 | 28862 | 3 | |||
40902 | 38028 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2490X 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1998 12:00:00 AM | Permit Number 40235 | 5992179.14418088 | 2098457.94829189 | 37.7415161934278 | -122.469656660064 | (37.7415161934278, -122.469656660064) | 1 | 8 | 4 | 29491 | 40 | |||
40932 | 179375 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 778 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001912.74857 | 2089301.24621 | 37.7169317492882 | -122.435346396016 | (37.7169317492882, -122.435346396016) | 9 | 7 | 6 | 28861 | 5 | |||
41119 | 184434 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3816 Quintara St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981590.8846 | 2100821.8038 | 37.7473890220179 | -122.506441860059 | (37.7473890220179, -122.506441860059) | 1 | 8 | 3 | 29491 | 35 | |||
41839 | 122286 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990082.62166 | 2111319.5038 | 37.7767091904138 | -122.477845623834 | (37.7767091904138, -122.477845623834) | 11 | 6 | 2 | 55 | 26 | |||
41944 | 140855 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 621 Euclid Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5996425.9427 | 2113796.2189 | 37.7838757026194 | -122.456081435491 | (37.7838757026194, -122.456081435491) | 11 | 6 | 1 | 54 | 31 | |||
42377 | 140854 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 623 Euclid Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5996411.3906 | 2113796.8958 | 37.7838767259243 | -122.456131829019 | (37.7838767259243, -122.456131829019) | 11 | 6 | 1 | 54 | 31 | |||
42393 | 69511 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 457 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | Permit Number 33638 | 6008927.18415449 | 2096207.51304953 | 37.736290754505 | -122.411588483232 | (37.736290754505, -122.411588483232) | 10 | 7 | 7 | 28859 | 2 | ||
42698 | 41761 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1320-1360 Lombard St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041 | 2120044 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | 5 | 9 | 1 | 28858 | 32 | ||
42922 | 69007 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2115 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 0 | Permit Number 33008 | 5982291.49205895 | 2100703.22551621 | 37.7471046635524 | -122.504010467091 | (37.7471046635524, -122.504010467091) | 1 | 8 | 3 | 29491 | 35 | |
43394 | 92109 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 654 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52365 | 5981669.51861 | 2111284.19832 | 37.7761203861627 | -122.506945906937 | (37.7761203861627, -122.506945906937) | 11 | 6 | 2 | 55 | 26 | |
43766 | 38883 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 101 Commonwealth Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40703 | 5996508.72142362 | 2113802.71293841 | 37.7838982845648 | -122.455795523067 | (37.7838982845648, -122.455795523067) | 11 | 6 | 1 | 54 | 31 | ||
44625 | 186236 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1701 Sunset Blvd | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984809.6691 | 2103350.7929 | 37.7545219168817 | -122.495498186629 | (37.7545219168817, -122.495498186629) | 1 | 8 | 3 | 56 | 35 | |||
44922 | 38217 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 350 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40338 | 6010576.45287423 | 2092372.10995681 | 37.7258519216371 | -122.405616192564 | (37.7258519216371, -122.405616192564) | 10 | 3 | 7 | 309 | 28 | ||
45022 | 240381 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 98 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008070.80857 | 2107998.41684 | 37.7686178359612 | -122.415383805538 | (37.7686178359612, -122.415383805538) | 8 | 4 | 7 | 28853 | 19 | |||
45902 | 67518 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 342 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/1994 12:00:00 AM | Permit Number 31054 | 5997814.69503285 | 2093832.35785798 | 37.7291395391527 | -122.449837670115 | (37.7291395391527, -122.449837670115) | 9 | 7 | 4 | 28861 | 40 | ||
45935 | 7243 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1929X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002956.0424065 | 2114080.0912444 | 37.7850277993699 | -122.433510025097 | (37.7850277993699, -122.433510025097) | 13 | 9 | 11 | 29490 | 13 | |||
45998 | 112547 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 462 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011324 | 2118723 | 37.798247331278 | -122.404886391926 | (37.798247331278, -122.404886391926) | 3 | 1 | 10 | 308 | 23 | ||||
46083 | 89314 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 101 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2005 12:00:00 AM | 3x3 | Permit Number 48328 | 6002340 | 2108819 | 37.7705471897255 | -122.435264883718 | (37.7705471897255, -122.435264883718) | 15 | 5 | 11 | 29492 | 9 | ||
46117 | 41663 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1376 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42129 | 5999046.52257313 | 2104716.21389633 | 37.7590943881005 | -122.44636181287 | (37.7590943881005, -122.44636181287) | 15 | 5 | 5 | 28862 | 3 | ||
46450 | 69309 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1554 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1994 12:00:00 AM | 3 | Permit Number 33388 | 5986865.46516485 | 2104681.03924788 | 37.7582945739882 | -122.488486559119 | (37.7582945739882, -122.488486559119) | 1 | 8 | 3 | 56 | 35 | |
46975 | 82884 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 398 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52426 | 6008893.02169344 | 2108709.50255899 | 37.7706164898271 | -122.412590100264 | (37.7706164898271, -122.412590100264) | 8 | 2 | 9 | 28853 | 19 | ||
48198 | 18596 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 409 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/1996 12:00:00 AM | 6 | 3X3 | 5992903.2652 | 2088492.7734 | 37.7141961040887 | -122.466428817805 | (37.7141961040887, -122.466428817805) | 9 | 8 | 6 | 64 | 24 | ||
48554 | 69006 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2111 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 3 | Permit Number 33007 | 5982290.62244002 | 2100729.28975496 | 37.7471761775601 | -122.504015404359 | (37.7471761775601, -122.504015404359) | 1 | 8 | 3 | 29491 | 35 | |
48948 | 48905 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2200X Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.7908961872794 | -122.429271589059 | (37.7908961872794, -122.429271589059) | 13 | 9 | 1 | 29490 | 27 | |||
49381 | 97195 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 390X Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2015 12:00:00 AM | 3 | Permit Number 775228 | 6011720.2 | 2118742.9 | 37.7983241100995 | -122.403516814582 | (37.7983241100995, -122.403516814582) | 3 | 1 | 10 | 308 | 23 | ||
49609 | 48458 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 3 | Permit Number 45824 | 6011932.18219 | 2110480.19141 | 37.7756484947135 | -122.402202056493 | (37.7756484947135, -122.402202056493) | 14 | 2 | 9 | 28853 | 34 | ||
49617 | 39731 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 3472 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41103 | 6003734.27078033 | 2106581.04610194 | 37.7644813903829 | -122.430282399811 | (37.7644813903829, -122.430282399811) | 8 | 4 | 5 | 28862 | 3 | ||
49755 | 112541 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 438 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011421.73685 | 2118713.41459 | 37.798226474727 | -122.404547516275 | (37.798226474727, -122.404547516275) | 3 | 1 | 10 | 308 | 23 | |||
49906 | 41694 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 444 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42146 | 6003561.9148943 | 2096429.88916823 | 37.7365989305362 | -122.430154297904 | (37.7365989305362, -122.430154297904) | 2 | 7 | 5 | 63 | 7 | ||
50181 | 89199 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 3236 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51816 | 5999889 | 2119639 | 37.8001166089052 | -122.444520645891 | (37.8001166089052, -122.444520645891) | 13 | 9 | 1 | 57 | 17 | ||
50270 | 40783 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 410 Monticello St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | 9 | 8 | 4 | 59 | 40 | ||
51701 | 98673 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1898@green Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | 5 | 1 | 10 | 28858 | 21 | ||||
51794 | 214043 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 212 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998768.52981 | 2093586.90837 | 37.7285201208974 | -122.446522546303 | (37.7285201208974, -122.446522546303) | 9 | 7 | 4 | 28861 | 40 | |||
51945 | 214035 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 142 Staples Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5999120.59989 | 2093807.09624 | 37.7291448088802 | -122.445321250796 | (37.7291448088802, -122.445321250796) | 9 | 7 | 4 | 28861 | 40 | ||||
52077 | 122289 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990067.41245 | 2111319.50308 | 37.7767083057233 | -122.477898236364 | (37.7767083057233, -122.477898236364) | 11 | 6 | 2 | 55 | 26 | |||
52120 | 136324 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 448 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011401 | 2118734 | 37.798281838344 | -122.404620722239 | (37.798281838344, -122.404620722239) | 3 | 1 | 10 | 308 | 23 | |||
52155 | 94656 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 118 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53795 | 6000765 | 2094410 | 37.7308939745429 | -122.439679643784 | (37.7308939745429, -122.439679643784) | 9 | 7 | 4 | 63 | 40 |
52593 | 98672 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1898@green Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | 5 | 1 | 10 | 28858 | 21 | ||||
53151 | 122280 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990124.51868 | 2111321.36168 | 37.7767167231412 | -122.477700827061 | (37.7767167231412, -122.477700827061) | 11 | 6 | 2 | 55 | 26 | |||
53841 | 136322 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 360 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2015 12:00:00 AM | 1 | Width 5ft | 6011695.90155 | 2118747.3363 | 37.7983349338553 | -122.403601207338 | (37.7983349338553, -122.403601207338) | 3 | 1 | 10 | 308 | 23 | ||
55018 | 41767 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1320-1360 Lombard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041 | 2120044 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | 5 | 9 | 1 | 28858 | 32 | ||
55616 | 140094 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1652 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999863.0392 | 2110926.6558 | 37.7761933050322 | -122.44398414486 | (37.7761933050322, -122.44398414486) | 15 | 5 | 11 | 29492 | 16 | |||
55692 | 67377 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 841 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2015 12:00:00 AM | 1 | Permit Number 776566 | 5992946.95858 | 2111357.65552 | 37.7769797668271 | -122.467939896695 | (37.7769797668271, -122.467939896695) | 11 | 6 | 2 | 54 | 11 | |
55782 | 47698 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 297 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45496 | 6000129.38189454 | 2094930.1458918 | 37.7322859754961 | -122.441914392194 | (37.7322859754961, -122.441914392194) | 9 | 7 | 4 | 63 | 40 | ||
57321 | 179374 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 906 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001350.07755 | 2088911.8778 | 37.71583065984 | -122.437263408906 | (37.71583065984, -122.437263408906) | 9 | 7 | 6 | 28861 | 5 | |||
58083 | 201725 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1915 Quesada Ave | 1 | Front Yard : Yard | Tree | Private 2 | 2 | 6013561.8417 | 2095888.78027 | 37.7356744661038 | -122.395542109982 | (37.7356744661038, -122.395542109982) | 10 | 3 | 8 | 58 | 1 | ||||
58114 | 197341 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 696 Amador St | 3 | Front Yard : Yard | Tree | Private 2 | 21 | 6016796.90554 | 2099573.89089 | 37.745972446388 | -122.384613749949 | (37.745972446388, -122.384613749949) | 10 | 3 | 8 | 58 | 1 | ||||
58215 | 240423 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 5 | Back Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6002449.92079 | 2096381.92143 | 37.7364041778047 | -122.433995506402 | (37.7364041778047, -122.433995506402) | 2 | 7 | 5 | 63 | 7 | |||
58873 | 41744 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1100 California St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.412524591719 | (37.7916912386009, -122.412524591719) | 5 | 1 | 10 | 28857 | 21 | ||
58885 | 197342 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012547.87891 | 2113973.86639 | 37.785275667977 | -122.400317636871 | (37.785275667977, -122.400317636871) | 12 | 2 | 9 | 28855 | 6 | |||
59349 | 136311 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1201 Sacramento St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008756.30767 | 2116638.98455 | 37.7923812780273 | -122.413623927626 | (37.7923812780273, -122.413623927626) | 5 | 1 | 10 | 28857 | 21 | |||
59685 | 41706 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 235 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42155 | 6001936.91803675 | 2096162.95952183 | 37.7357738321427 | -122.435753508421 | (37.7357738321427, -122.435753508421) | 2 | 7 | 5 | 63 | 7 | ||
59688 | 87870 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 3236 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50837 | 5999889 | 2119639 | 37.8001166089052 | -122.444520645891 | (37.8001166089052, -122.444520645891) | 13 | 9 | 1 | 57 | 17 | ||
59848 | 112528 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 459 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011361 | 2118561 | 37.797804586609 | -122.404746949234 | (37.797804586609, -122.404746949234) | 3 | 1 | 10 | 308 | 23 | ||||
60116 | 102078 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 35 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769728 | 6005184.6 | 2096720.6 | 37.7374889299957 | -122.424564647037 | (37.7374889299957, -122.424564647037) | 2 | 7 | 5 | 28859 | 2 |
60862 | 240422 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 5 Penny Ln | 4 | Back Yard : Yard | Tree | Private 2 | 3 | Width 2ft | 6002442.71855 | 2096389.33655 | 37.7364241292793 | -122.434020937432 | (37.7364241292793, -122.434020937432) | 2 | 7 | 5 | 63 | 7 | |||
61307 | 34 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 759 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003742.09963 | 2107707.87999 | 37.7675758472752 | -122.430335723414 | (37.7675758472752, -122.430335723414) | 7 | 9 | 5 | 28862 | 3 | |||
61566 | 214027 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 130 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6000768.47308 | 2094513.82924 | 37.7311792633149 | -122.439675077667 | (37.7311792633149, -122.439675077667) | 9 | 7 | 4 | 63 | 40 | |||
61612 | 40785 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 410 Monticello St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | 9 | 8 | 4 | 59 | 40 | ||
61871 | 117228 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 66 POTOMAC ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003144 | 2108708 | 37.7702880357607 | -122.432475913278 | (37.7702880357607, -122.432475913278) | 15 | 5 | 5 | 29492 | 9 | |||
62258 | 214017 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1438 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993685.58433 | 2105688.82171 | 37.7614572746516 | -122.464972976223 | (37.7614572746516, -122.464972976223) | 1 | 8 | 11 | 56 | 12 | |||
62487 | 94725 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 79 Manzanita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53859 | 5997862.34491 | 2114019.18294 | 37.7845702460701 | -122.451128124682 | (37.7845702460701, -122.451128124682) | 15 | 6 | 1 | 54 | 31 |
62872 | 240373 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1373 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6010904.97586 | 2101974.91384 | 37.7522375329589 | -122.405156394162 | (37.7522375329589, -122.405156394162) | 10 | 4 | 8 | 28859 | 19 | |||
63191 | 68973 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 3541 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | Permit Number 32963 | 5999700.01023575 | 2120669.59399303 | 37.8029355580023 | -122.445248759265 | (37.8029355580023, -122.445248759265) | 13 | 9 | 1 | 57 | 17 | ||
64020 | 47995 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2594 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53833 | 5991772.56459051 | 2097785.68925868 | 37.739646833729 | -122.471013497633 | (37.739646833729, -122.471013497633) | 1 | 8 | 4 | 59 | 40 | |
64517 | 179382 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 143 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007980.64963 | 2093237.82874 | 37.7280835045466 | -122.414650965095 | (37.7280835045466, -122.414650965095) | 9 | 3 | 7 | 309 | 28 | |||
64703 | 183216 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3150 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983362.6255 | 2100199.941 | 37.7457857131054 | -122.500269432817 | (37.7457857131054, -122.500269432817) | 1 | 8 | 3 | 29491 | 35 | |||
64803 | 214023 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 111 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000598.84895 | 2094335.44716 | 37.7306798113107 | -122.440248709336 | (37.7306798113107, -122.440248709336) | 9 | 7 | 4 | 63 | 40 | |||
64914 | 122279 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 Balboa St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5990130.41151 | 2111322.13937 | 37.7767192004406 | -122.477680499098 | (37.7767192004406, -122.477680499098) | 11 | 6 | 2 | 55 | 26 | |||
65177 | 136326 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 463 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011288.49181 | 2118628.67213 | 37.79798634496 | -122.405002616378 | (37.79798634496, -122.405002616378) | 3 | 1 | 10 | 308 | 23 | |||
65254 | 40032 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1660 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | Permit Number 41274 | 6014934.45622927 | 2095941.56583888 | 37.7358956578297 | -122.390800100159 | (37.7358956578297, -122.390800100159) | 10 | 3 | 8 | 58 | 1 | ||
65640 | 38061 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1802 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40254 | 6001102.14351194 | 2114546.50782632 | 37.7862031012974 | -122.439957367186 | (37.7862031012974, -122.439957367186) | 13 | 6 | 1 | 29490 | 27 | ||
66246 | 100238 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 701X 39th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5983814.58777 | 2110777.43528 | 37.7748550533025 | -122.499488194975 | (37.7748550533025, -122.499488194975) | 11 | 6 | 2 | 55 | 26 | |||
66488 | 41690 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Conrad St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42144 | 6001748.90360557 | 2096547.6107594 | 37.7368193138397 | -122.436431068172 | (37.7368193138397, -122.436431068172) | 2 | 7 | 5 | 63 | 7 | ||
67115 | 25468 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 437 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/26/1996 12:00:00 AM | 6 | 3X3 | 5992774.4094 | 2088493.0908 | 37.7141895393891 | -122.466874212626 | (37.7141895393891, -122.466874212626) | 9 | 8 | 6 | 64 | 24 | ||
67236 | 33177 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3245 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 4 | 3.5x5 | Permit Number 37389 | 5985988.52360796 | 2098193.06286983 | 37.7404291431182 | -122.491041921171 | (37.7404291431182, -122.491041921171) | 1 | 8 | 3 | 29491 | 35 |
67315 | 240401 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 499 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000694.66286 | 2101176.32982 | 37.749468718214 | -122.440407898332 | (37.749468718214, -122.440407898332) | 2 | 4 | 5 | 28862 | 22 | |||
67379 | 186234 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1701 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984803.2409 | 2103355.3462 | 37.7545340425765 | -122.495520752512 | (37.7545340425765, -122.495520752512) | 1 | 8 | 3 | 56 | 35 | |||
67662 | 240398 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1636 Diamond St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6002001.74432 | 2099212.54095 | 37.7441509550044 | -122.435747497273 | (37.7441509550044, -122.435747497273) | 2 | 7 | 5 | 63 | 22 | |||
67971 | 41662 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1376 Clayton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42129 | 5999046.52257313 | 2104716.21389633 | 37.7590943881005 | -122.44636181287 | (37.7590943881005, -122.44636181287) | 15 | 5 | 5 | 28862 | 3 | ||
68406 | 38637 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1595 Shafter Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2010 12:00:00 AM | 3x3 | Permit Number 767658 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );