trees
614 rows where qSpecies_id = 29 sorted by DBH descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25866 | 32518 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 842 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/2007 12:00:00 AM | 9 | Permit Number 49664 | 6007548.7449 | 2095423.3131 | 37.7340600948986 | -122.41629880637 | (37.7340600948986, -122.41629880637) | 2 | 7 | 7 | 28859 | 2 | |
| 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 | |||
| 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 | ||||
| 69805 | 179380 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 77 Santa Cruz Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5993077.06779 | 2086425.74691 | 37.7085305695939 | -122.465678009642 | (37.7085305695939, -122.465678009642) | 9 | 8 | 6 | 28861 | 25 | |||
| 103746 | 240377 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 87 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008059.81094 | 2107952.18864 | 37.768490286015 | -122.415418572409 | (37.768490286015, -122.415418572409) | 8 | 4 | 7 | 28853 | 19 | |||
| 119572 | 31971 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 100 02nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 9 | Permit Number 35372 | 5995225.90281 | 2114852.20624 | 37.786706205556 | -122.46030963631 | (37.786706205556, -122.46030963631) | 11 | 6 | 1 | 54 | 11 | |
| 148706 | 41756 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1630 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 9 | Permit Number 42184 | 6008372.67518 | 2118139.66101 | 37.7964802161469 | -122.41505757827 | (37.7964802161469, -122.41505757827) | 5 | 1 | 10 | 308 | 21 | ||
| 148880 | 240407 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 489 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6003411.63679 | 2096255.36709 | 37.7361112200507 | -122.430661423705 | (37.7361112200507, -122.430661423705) | 2 | 7 | 5 | 63 | 7 | |||
| 191449 | 240376 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1367 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007185.77161 | 2107529.73267 | 37.7672811565308 | -122.418411847135 | (37.7672811565308, -122.418411847135) | 8 | 4 | 7 | 28853 | 19 | |||
| 7825 | 197345 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008901.33871 | 2110395.02653 | 37.7752450102959 | -122.412680506426 | (37.7752450102959, -122.412680506426) | 8 | 2 | 9 | 28853 | 34 | |||
| 12537 | 54837 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 131 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1972 12:00:00 AM | 8 | Permit Number 10691 | 5998715.81827648 | 2110282.46474316 | 37.7743590132093 | -122.447906287477 | (37.7743590132093, -122.447906287477) | 15 | 5 | 11 | 29492 | 16 | |
| 16920 | 78303 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4200 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5985601.84615 | 2111830.05832 | 37.7778499560934 | -122.493383352985 | (37.7778499560934, -122.493383352985) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 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 | |||
| 68958 | 246759 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 70 Waltham St | 3 | Front Yard : Yard | Tree | Private 2 | 8 | 6009196.74806 | 2098886.80636 | 37.7436626276403 | -122.410845655606 | (37.7436626276403, -122.410845655606) | 2 | 7 | 7 | 28859 | 2 | ||||
| 77469 | 248239 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 298 Esmeralda Ave | 4 | Side Yard : Yard | Tree | Private 2 | 8 | 6006759.33465 | 2099019.31967 | 37.7438895076886 | -122.419283056374 | (37.7438895076886, -122.419283056374) | 2 | 7 | 7 | 28859 | 2 | ||||
| 100804 | 8103 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 775 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/1998 12:00:00 AM | 8 | 3X3 | 6004110.63243 | 2111457.69852 | 37.7778928009026 | -122.429328443516 | (37.7778928009026, -122.429328443516) | 7 | 9 | 11 | 28852 | 10 | ||
| 120646 | 247983 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 497 Peralta Ave | 1 | Side Yard : Yard | Tree | Private 2 | 8 | 6009757.51939 | 2099637.18115 | 37.7457544201473 | -122.408959568646 | (37.7457544201473, -122.408959568646) | 2 | 7 | 7 | 28859 | 2 | ||||
| 122370 | 240400 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 499 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000695.68287 | 2101155.78818 | 37.7494123738797 | -122.440402898093 | (37.7494123738797, -122.440402898093) | 2 | 4 | 5 | 28862 | 22 | |||
| 124526 | 214037 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 510 Ramsell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5993017.24879 | 2090566.81293 | 37.7198974930477 | -122.466185481793 | (37.7198974930477, -122.466185481793) | 9 | 8 | 6 | 64 | 24 | |||
| 132582 | 240413 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3420 Market St | 2 | : | Tree | DPW 1 | 04/19/1996 12:00:00 AM | 8 | Width 3ft | 6000107.95046 | 2103900.11575 | 37.7569141478938 | -122.442632304847 | (37.7569141478938, -122.442632304847) | 2 | 4 | 5 | 28862 | 3 | ||
| 141336 | 40008 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 950 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 8 | Permit Number 41261 | 6018990.20826 | 2094681.67111 | 37.7326604269313 | -122.376690235261 | (37.7326604269313, -122.376690235261) | 10 | 3 | 8 | 58 | 1 | |
| 143437 | 136314 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 107 Bernard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008318.73536 | 2118064.92593 | 37.796271980829 | -122.415238929252 | (37.796271980829, -122.415238929252) | 5 | 1 | 10 | 28858 | 21 | |||
| 145068 | 32523 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 861 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 8 | Permit Number 37025 | 6007568.6691 | 2095324.89508 | 37.7337909808565 | -122.416222953925 | (37.7337909808565, -122.416222953925) | 2 | 7 | 7 | 28859 | 2 | |
| 157021 | 179371 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 479 Goettingen St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010448.30169 | 2092366.95531 | 37.7258306011814 | -122.406058841354 | (37.7258306011814, -122.406058841354) | 10 | 3 | 7 | 309 | 28 | |||
| 157735 | 197346 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1245 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008998.58265 | 2110487.32292 | 37.7755038918289 | -122.412350641372 | (37.7755038918289, -122.412350641372) | 8 | 2 | 9 | 28853 | 34 | |||
| 162832 | 42678 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1097 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 8 | Permit Number 42702 | 6007821.24509 | 2118860.5405 | 37.7984285685682 | -122.417016754032 | (37.7984285685682, -122.417016754032) | 5 | 1 | 10 | 28858 | 21 | |
| 177127 | 240392 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1803 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008038.16649 | 2107910.13922 | 37.7683736115782 | -122.415490461517 | (37.7683736115782, -122.415490461517) | 8 | 4 | 7 | 28853 | 19 | |||
| 4031 | 73753 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2019 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989295.11737 | 2111227.81825 | 37.7764117112404 | -122.480563089536 | (37.7764117112404, -122.480563089536) | 11 | 6 | 2 | 55 | 26 | |||
| 6470 | 78275 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Pomona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6014137.61661 | 2094337.23888 | 37.7314462603177 | -122.393442871089 | (37.7314462603177, -122.393442871089) | 10 | 3 | 8 | 58 | 1 | |||
| 9617 | 240412 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3420 Market St | 1 | : | Tree | DPW 1 | 04/19/1996 12:00:00 AM | 7 | Width 3ft | 6000095.05977 | 2103920.26324 | 37.7569687331323 | -122.442678332141 | (37.7569687331323, -122.442678332141) | 2 | 4 | 5 | 28862 | 3 | ||
| 76954 | 214036 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 262 Ralston St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992219.26388 | 2089623.39625 | 37.7172610279406 | -122.46887519663 | (37.7172610279406, -122.46887519663) | 9 | 8 | 6 | 64 | 24 | |||
| 76971 | 87871 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2335 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50842 | 6000134.07181 | 2119870.32478 | 37.8007657456038 | -122.443689233072 | (37.8007657456038, -122.443689233072) | 13 | 9 | 1 | 57 | 17 | |
| 79841 | 214044 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 119 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5999274.87025 | 2093768.22401 | 37.7290468799003 | -122.444785134325 | (37.7290468799003, -122.444785134325) | 9 | 7 | 4 | 28861 | 40 | |||
| 94034 | 240379 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 87 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008087.13667 | 2107952.681 | 37.7684931737476 | -122.41532408966 | (37.7684931737476, -122.41532408966) | 8 | 4 | 7 | 28853 | 19 | |||
| 104389 | 214041 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 431 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997281.47486 | 2093791.4004 | 37.7289965565343 | -122.451678093372 | (37.7289965565343, -122.451678093372) | 9 | 7 | 4 | 28861 | 40 | |||
| 108080 | 39695 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1583 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | 7 | Permit Number 41080 | 6014997.8516 | 2094075.2851 | 37.730774746396 | -122.390450554434 | (37.730774746396, -122.390450554434) | 10 | 3 | 8 | 58 | 1 | |
| 147145 | 51788 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 339 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52292 | 6012718.57232 | 2094804.94617 | 37.7326515416146 | -122.39838161323 | (37.7326515416146, -122.39838161323) | 10 | 3 | 8 | 58 | 1 | |
| 160545 | 179373 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Brunswick St | 17 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 5998557.70629 | 2086647.36142 | 37.7094536787167 | -122.446752254708 | (37.7094536787167, -122.446752254708) | 9 | 7 | 6 | 28861 | 5 | ||||
| 163298 | 117837 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 660x 39th Ave | 2 | Median : Cutout | Tree | DPW 1 | 7 | Width 6ft | 5983820.01458 | 2111273.23439 | 37.7762166927907 | -122.499506071449 | (37.7762166927907, -122.499506071449) | 11 | 6 | 2 | 55 | 26 | |||
| 164027 | 35432 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1506 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | 7 | Permit Number 38878 | 6014141.49848 | 2102013.02263 | 37.7525225775725 | -122.393966574215 | (37.7525225775725, -122.393966574215) | 10 | 3 | 8 | 28856 | 29 | |
| 164354 | 240409 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1 Arbor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6002196.79726 | 2096967.09193 | 37.7379965524899 | -122.434912495609 | (37.7379965524899, -122.434912495609) | 2 | 7 | 5 | 63 | 7 | |||
| 165949 | 48456 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 7 | Permit Number 45824 | 6011955.48397 | 2110455.52014 | 37.7755820536976 | -122.402119714552 | (37.7755820536976, -122.402119714552) | 14 | 2 | 9 | 28853 | 34 | ||
| 177533 | 214039 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 57 Nordhoff St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6000414.26094 | 2095519.56512 | 37.7339206127394 | -122.440971772322 | (37.7339206127394, -122.440971772322) | 9 | 7 | 5 | 63 | 40 | |||
| 187632 | 197333 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1501 25th St | 22 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6014202.14844 | 2101967.42619 | 37.7524007500093 | -122.393753643523 | (37.7524007500093, -122.393753643523) | 10 | 3 | 8 | 28856 | 1 | ||||
| 190698 | 136321 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Francisco St | 13 | Front Yard : Yard | Tree | Private 2 | 7 | 6010437.78302 | 2121369.6786 | 37.8054648831642 | -122.408139740375 | (37.8054648831642, -122.408139740375) | 3 | 1 | 10 | 308 | 23 | ||||
| 2004 | 73758 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2220 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988694.03882 | 2110577.4842 | 37.7745911237516 | -122.482594698718 | (37.7745911237516, -122.482594698718) | 11 | 6 | 2 | 55 | 26 | |||
| 13641 | 136307 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008614.23308 | 2116420.22843 | 37.7917726483359 | -122.41410002782 | (37.7917726483359, -122.41410002782) | 5 | 1 | 10 | 28857 | 21 | |||
| 20954 | 137686 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2143 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999343.9567 | 2111495.7816 | 37.7777263543907 | -122.445820725833 | (37.7777263543907, -122.445820725833) | 15 | 5 | 11 | 54 | 16 | |||
| 23177 | 29219 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1902X 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5983534.5176829 | 2102185.1808128 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | 1 | 8 | 3 | 29491 | 35 | |||
| 30874 | 18608 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 550 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/1997 12:00:00 AM | 6 | 3X3 | 5992502.2173 | 2088557.38 | 37.7143503484358 | -122.467819678694 | (37.7143503484358, -122.467819678694) | 9 | 8 | 6 | 64 | 24 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 70554 | 240383 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004954.4402 | 2108809.15318 | 37.7706682749432 | -122.426220805247 | (37.7706682749432, -122.426220805247) | 7 | 9 | 5 | 28852 | 10 | |||
| 70662 | 35869 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1 Boutwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 6 | Permit Number 39080 | 6010666.93779 | 2096840.63562 | 37.7381266097475 | -122.405617981988 | (37.7381266097475, -122.405617981988) | 10 | 3 | 8 | 58 | 1 | |
| 72275 | 48457 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 6 | Permit Number 45824 | 6011919.3472 | 2110495.26684 | 37.7756891719521 | -122.402247516312 | (37.7756891719521, -122.402247516312) | 14 | 2 | 9 | 28853 | 34 | ||
| 72383 | 117792 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3801 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5983744.15991 | 2111021.91382 | 37.7755221883124 | -122.499749889479 | (37.7755221883124, -122.499749889479) | 11 | 6 | 2 | 55 | 26 | |||
| 75438 | 136320 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 99 North Point St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6010568.43745 | 2122006.80544 | 37.8072215900736 | -122.407732543518 | (37.8072215900736, -122.407732543518) | 3 | 1 | 10 | 308 | 23 | |||
| 81719 | 8100 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 765 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/1998 12:00:00 AM | 6 | 3X3 | 6004193.95704 | 2111472.64562 | 37.7779385589247 | -122.429041260431 | (37.7779385589247, -122.429041260431) | 7 | 9 | 11 | 28852 | 10 | ||
| 95310 | 42677 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1097 Green St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42702 | 6007869.31291 | 2118866.95146 | 37.7984488752774 | -122.416850878593 | (37.7984488752774, -122.416850878593) | 5 | 1 | 10 | 28858 | 21 | ||
| 100100 | 136315 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 895 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009067.06929 | 2119033.92208 | 37.7989746333364 | -122.41271806751 | (37.7989746333364, -122.41271806751) | 3 | 1 | 10 | 308 | 21 | |||
| 105290 | 240410 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 235 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001912.29637 | 2096185.45895 | 37.735834211766 | -122.435840244336 | (37.735834211766, -122.435840244336) | 2 | 7 | 5 | 63 | 7 | |||
| 106836 | 214033 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 342 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997821.19553 | 2093821.69316 | 37.7291106283447 | -122.449814429211 | (37.7291106283447, -122.449814429211) | 9 | 7 | 4 | 28861 | 40 | |||
| 107058 | 214018 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2464 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991736.67899 | 2098669.28572 | 37.7420708887619 | -122.47120193253 | (37.7420708887619, -122.47120193253) | 1 | 8 | 4 | 29491 | 40 | |||
| 113452 | 197332 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1501 25th St | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6014163.86905 | 2101969.79141 | 37.7524051171259 | -122.393886186499 | (37.7524051171259, -122.393886186499) | 10 | 3 | 8 | 28856 | 1 | ||||
| 129616 | 240402 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4440 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000362.39575 | 2102290.8235 | 37.7525099241126 | -122.441636854259 | (37.7525099241126, -122.441636854259) | 2 | 4 | 5 | 28862 | 22 | |||
| 130231 | 32520 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 848 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 6 | Permit Number 37022 | 6007545.9989 | 2095398.06709 | 37.7339906204551 | -122.416306512649 | (37.7339906204551, -122.416306512649) | 2 | 7 | 7 | 28859 | 2 | |
| 130716 | 18607 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 530 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/1996 12:00:00 AM | 6 | 3x3 | 5992558.0676 | 2088557.0731 | 37.7143527306111 | -122.467626617395 | (37.7143527306111, -122.467626617395) | 9 | 8 | 6 | 64 | 24 | ||
| 134252 | 47746 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4201 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2002 12:00:00 AM | 6 | Permit Number 45527 | 5982405.06542 | 2113061.42324 | 37.7810434137217 | -122.504533198292 | (37.7810434137217, -122.504533198292) | 11 | 6 | 2 | 55 | 26 | |
| 140741 | 18570 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 698X Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1997 12:00:00 AM | 6 | 3X3 | 5992368.0058464 | 2088553.4079402 | 37.7143316913291 | -122.468283273537 | (37.7143316913291, -122.468283273537) | 9 | 8 | 6 | 64 | 24 | ||
| 141338 | 240378 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 87 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008072.76469 | 2107952.79864 | 37.768492689 | -122.415373809569 | (37.768492689, -122.415373809569) | 8 | 4 | 7 | 28853 | 19 | |||
| 143532 | 18603 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/25/1996 12:00:00 AM | 6 | 3X3 | 5992619.61154 | 2088559.40218 | 37.7143626789426 | -122.467414068351 | (37.7143626789426, -122.467414068351) | 9 | 8 | 6 | 64 | 24 | ||
| 144733 | 25183 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3448X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/19/1996 12:00:00 AM | 6 | 3X3 | 6000085.266119 | 2103906.7160848 | 37.7569309776636 | -122.442711229464 | (37.7569309776636, -122.442711229464) | 2 | 5 | 5 | 28862 | 3 | ||
| 144974 | 63485 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2159 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/07/1987 12:00:00 AM | 6 | Permit Number 24080 | 5999253.53185357 | 2111483.89157027 | 37.7776885439579 | -122.446132679753 | (37.7776885439579, -122.446132679753) | 15 | 5 | 11 | 54 | 16 | |
| 155055 | 17244 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 10X Randolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2005 12:00:00 AM | 6 | 3X3 | 5993945.3779 | 2088542.9193 | 37.7143938707274 | -122.462830535838 | (37.7143938707274, -122.462830535838) | 9 | 8 | 6 | 64 | 24 | ||
| 156793 | 217578 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 308 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5993138.4427 | 2088550.8537 | 37.7143691463099 | -122.465620176978 | (37.7143691463099, -122.465620176978) | 9 | 8 | 6 | 64 | 24 | |||
| 167181 | 47743 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4201 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2002 12:00:00 AM | 6 | Permit Number 45527 | 5982418.5702 | 2113061.40286 | 37.7810441521097 | -122.50448647782 | (37.7810441521097, -122.50448647782) | 11 | 6 | 2 | 55 | 26 | |
| 168305 | 214032 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 342 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997805.13378 | 2093821.66004 | 37.729109618413 | -122.449869953332 | (37.729109618413, -122.449869953332) | 9 | 7 | 4 | 28861 | 40 | |||
| 169888 | 240403 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 557 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002931.13898 | 2099759.29881 | 37.7457049727185 | -122.432572903928 | (37.7457049727185, -122.432572903928) | 2 | 7 | 5 | 63 | 22 | |||
| 174273 | 197352 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1240 Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017442.65456 | 2093993.31463 | 37.7306849905143 | -122.381992698304 | (37.7306849905143, -122.381992698304) | 10 | 3 | 8 | 58 | 1 | |||
| 188763 | 100236 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 701X 39th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5983814.22353 | 2110811.15249 | 37.7749476096575 | -122.499491947241 | (37.7749476096575, -122.499491947241) | 11 | 6 | 2 | 55 | 26 | |||
| 192565 | 214025 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 118 Baden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6000768.8435 | 2094480.08399 | 37.7310866277439 | -122.439671378725 | (37.7310866277439, -122.439671378725) | 9 | 7 | 4 | 63 | 40 | |||
| 5160 | 240388 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008348.72479 | 2098315.88712 | 37.7420474227613 | -122.413737549756 | (37.7420474227613, -122.413737549756) | 2 | 7 | 7 | 28859 | 2 | |||
| 10754 | 41218 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 21 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 5 | Permit Number 41926 | 6001937.22199 | 2119965.3728 | 37.8011293999489 | -122.43745640431 | (37.8011293999489, -122.43745640431) | 13 | 9 | 1 | 57 | 17 | |
| 13360 | 75003 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3501 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5997399.30482 | 2116036.40743 | 37.7900824867734 | -122.452875730442 | (37.7900824867734, -122.452875730442) | 11 | 6 | 1 | 54 | 31 | |||
| 13609 | 200054 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1800 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6014879.1353 | 2094151.956 | 37.7309786828797 | -122.39086633517 | (37.7309786828797, -122.39086633517) | 10 | 3 | 8 | 58 | 1 | |||
| 13916 | 240385 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 310 Gates St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008245.55924 | 2097104.87481 | 37.7387164553078 | -122.41400861353 | (37.7387164553078, -122.41400861353) | 2 | 7 | 7 | 28859 | 2 | |||
| 14362 | 197348 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 776 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6009001.8467 | 2110254.60923 | 37.7748650979682 | -122.412322898178 | (37.7748650979682, -122.412322898178) | 8 | 2 | 9 | 28853 | 34 | |||
| 27362 | 197344 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012519.57167 | 2113947.09446 | 37.7852005799736 | -122.400413690752 | (37.7852005799736, -122.400413690752) | 12 | 2 | 9 | 28855 | 6 | |||
| 27785 | 31973 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 100 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 5 | Permit Number 35372 | 5995224.68838 | 2114814.58842 | 37.7866028473263 | -122.460311111336 | (37.7866028473263, -122.460311111336) | 11 | 6 | 1 | 54 | 11 | |
| 29332 | 40197 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4845 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983545.15866 | 2111697.12052 | 37.7773644306872 | -122.500488206744 | (37.7773644306872, -122.500488206744) | 11 | 6 | 2 | 55 | 26 | |
| 30102 | 184465 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2182 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5982354.8718 | 2100269.3302 | 37.7459170344363 | -122.503759179813 | (37.7459170344363, -122.503759179813) | 1 | 8 | 3 | 29491 | 35 | |||
| 30433 | 40199 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 4845 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983584.60152 | 2111699.05511 | 37.7773720577908 | -122.500351906273 | (37.7773720577908, -122.500351906273) | 11 | 6 | 2 | 55 | 26 | |
| 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 | |||
| 70236 | 136304 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1110 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008621.36418 | 2116364.4323 | 37.791619846337 | -122.414071405095 | (37.791619846337, -122.414071405095) | 5 | 1 | 10 | 28857 | 21 |
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) );