trees
2,694 rows where qSpecies_id = 84
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7788 | 39331 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
| 7795 | 34636 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1466 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 4 | Permit Number 45216 | 5988080.2573 | 2105318.5059 | 37.7601156921394 | -122.484332079774 | (37.7601156921394, -122.484332079774) | 1 | 8 | 3 | 56 | 35 | |
| 7880 | 46205 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1852 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/03/2002 12:00:00 AM | 6 | Permit Number 44521 | 5988484.6348 | 2102686.0448 | 37.7529112010076 | -122.482740630037 | (37.7529112010076, -122.482740630037) | 1 | 8 | 3 | 56 | 35 | |
| 7942 | 71165 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2119 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988190.2092 | 2100857.5067 | 37.7478733893734 | -122.483624747125 | (37.7478733893734, -122.483624747125) | 1 | 8 | 3 | 29491 | 35 | |||
| 8000 | 71225 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2262 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5987644.7584 | 2099883.1111 | 37.7451661944085 | -122.485439373685 | (37.7451661944085, -122.485439373685) | 1 | 8 | 3 | 29491 | 35 | |||
| 8197 | 65499 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1520 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1989 12:00:00 AM | 2 | Permit Number 28383 | 5988131.2403 | 2099681.6905 | 37.7446414773793 | -122.483742458373 | (37.7446414773793, -122.483742458373) | 1 | 8 | 3 | 29491 | 35 | |
| 8270 | 261411 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 8298 | 66169 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 141 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/1990 12:00:00 AM | Permit Number 29241 | 6009332.38059352 | 2096679.3641893 | 37.7376090764499 | -122.410220849347 | (37.7376090764499, -122.410220849347) | 10 | 7 | 7 | 28859 | 2 | ||
| 8330 | 60243 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1241 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 1 | Permit Number 19795 | 5987983.8428 | 2106825.6856 | 37.7642483811973 | -122.484776093092 | (37.7642483811973, -122.484776093092) | 1 | 8 | 3 | 56 | 35 | |
| 8464 | 92304 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2001 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52751 | 5989091.9697 | 2101683.9526 | 37.7501950388707 | -122.480567026206 | (37.7501950388707, -122.480567026206) | 1 | 8 | 3 | 29491 | 35 |
| 8521 | 43574 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 165 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43235 | 6004098.34924441 | 2100984.69662112 | 37.7491357535113 | -122.428624197191 | (37.7491357535113, -122.428624197191) | 2 | 4 | 5 | 28862 | 22 | ||
| 8548 | 138687 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2828 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999933.5509 | 2114410.1103 | 37.7857619969761 | -122.443990574135 | (37.7857619969761, -122.443990574135) | 15 | 6 | 1 | 29490 | 31 | |||
| 8574 | 182275 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 3150 Kirkham St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985063.5912 | 2105018.8618 | 37.7591168373077 | -122.49474304376 | (37.7591168373077, -122.49474304376) | 1 | 8 | 3 | 56 | 35 | |||
| 8717 | 119762 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
| 8785 | 178959 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1333 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007585.1415 | 2091886.23741 | 37.7243500958617 | -122.415922582174 | (37.7243500958617, -122.415922582174) | 9 | 3 | 7 | 309 | 28 | |||
| 8869 | 45450 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 191 Corona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44761 | 5993006.32104665 | 2092505.10355506 | 37.7252189362985 | -122.466364051503 | (37.7252189362985, -122.466364051503) | 9 | 8 | 4 | 59 | 40 | ||
| 8946 | 98096 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 81 Frank Norris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006843.26628 | 2115504.44745 | 37.789158511592 | -122.420162558272 | (37.789158511592, -122.420162558272) | 13 | 9 | 10 | 28858 | 21 | |||
| 8968 | 261399 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 715 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010168.78657 | 2118489.20051 | 37.7975407349103 | -122.408867289597 | (37.7975407349103, -122.408867289597) | 3 | 1 | 10 | 308 | 4 | |||||
| 8992 | 261405 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 9198 | 44212 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2009 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2001 12:00:00 AM | 2 | Permit Number 43659 | 6003842.4279 | 2115438.8041 | 37.7888087328674 | -122.430540396598 | (37.7888087328674, -122.430540396598) | 13 | 9 | 1 | 29490 | 27 | |
| 9212 | 259382 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 225 Whipple Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5997701 | 2087724 | 37.7123609051901 | -122.449790697309 | (37.7123609051901, -122.449790697309) | 9 | 7 | 6 | 28861 | 25 | ||||
| 9291 | 34653 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2000 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38332 | 5988676.14476792 | 2105141.94720244 | 37.75966558895 | -122.482258277854 | (37.75966558895, -122.482258277854) | 1 | 8 | 3 | 56 | 35 | ||
| 9392 | 70671 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 73 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6010033.5172 | 2110899.92735 | 37.7766948289379 | -122.408799654802 | (37.7766948289379, -122.408799654802) | 8 | 2 | 9 | 28853 | 34 | |||
| 9471 | 119842 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 350 Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
| 9552 | 139978 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1002 SCOTT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001945.5177 | 2111990.8232 | 37.7792338137079 | -122.436856496835 | (37.7792338137079, -122.436856496835) | 15 | 5 | 11 | 29490 | 41 | |||
| 9643 | 70441 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2443 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5982992.9824 | 2098498.3633 | 37.7410919453428 | -122.501421735716 | (37.7410919453428, -122.501421735716) | 1 | 8 | 3 | 29491 | 35 | |||
| 9852 | 31300 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 519 Birch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 10 | Permit Number 34943 | 6005263.3007 | 2111469.3023 | 37.7779898515936 | -122.425341782234 | (37.7779898515936, -122.425341782234) | 7 | 9 | 11 | 28852 | 10 | |
| 9928 | 261390 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 638 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010519.78547 | 2118576.37921 | 37.7977997607314 | -122.407658884309 | (37.7977997607314, -122.407658884309) | 3 | 1 | 10 | 308 | 4 | |||||
| 10081 | 119760 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
| 10215 | 45064 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2101 27th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | Permit Number 43947 | 5987870.53797958 | 2100985.88306806 | 37.7482072643075 | -122.484739557427 | (37.7482072643075, -122.484739557427) | 1 | 8 | 3 | 29491 | 35 | ||
| 10250 | 261397 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 720 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010143.42503 | 2118526.09105 | 37.7976406066987 | -122.408957651874 | (37.7976406066987, -122.408957651874) | 3 | 1 | 10 | 308 | 4 | |||||
| 10332 | 86369 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1281 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5987992.2676 | 2106611.2343 | 37.7636600473858 | -122.484731221945 | (37.7636600473858, -122.484731221945) | 1 | 8 | 3 | 56 | 35 | ||
| 10452 | 182205 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1651 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5988079.8655 | 2104054.0379 | 37.7566437831632 | -122.484240699303 | (37.7566437831632, -122.484240699303) | 1 | 8 | 3 | 56 | 35 | |||
| 10622 | 58722 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 73 Carmelita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1986 12:00:00 AM | Permit Number 22987 | 6002575.33914396 | 2108761.52820117 | 37.7704027479761 | -122.434446734741 | (37.7704027479761, -122.434446734741) | 15 | 5 | 5 | 29492 | 9 | ||
| 10688 | 31923 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2296 15th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35341 | 5991714.32950315 | 2099798.09333533 | 37.7451690123809 | -122.471361438247 | (37.7451690123809, -122.471361438247) | 1 | 8 | 4 | 29491 | 40 | ||
| 10794 | 71822 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1300 26th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 5988042.7796 | 2106389.3653 | 37.7630537975137 | -122.484540243852 | (37.7630537975137, -122.484540243852) | 1 | 8 | 3 | 56 | 35 | ||||
| 10978 | 261419 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 781 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009855.16282 | 2118445.96033 | 37.7974044358704 | -122.409949461749 | (37.7974044358704, -122.409949461749) | 3 | 1 | 10 | 308 | 4 | |||||
| 11005 | 49212 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1901 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2003 12:00:00 AM | 5 | Permit Number 46298 | 6001466.4689 | 2115088.0238 | 37.7877106976566 | -122.438735717029 | (37.7877106976566, -122.438735717029) | 13 | 6 | 1 | 29490 | 27 | |
| 11051 | 32827 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4107 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 6 | 3x3 | Permit Number 37185 | 6002480.53446063 | 2101776.94850735 | 37.7512193992216 | -122.434275246016 | (37.7512193992216, -122.434275246016) | 2 | 4 | 5 | 28862 | 22 |
| 11088 | 79919 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1343 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988008.149 | 2106155.0675 | 37.7624084631065 | -122.484642830378 | (37.7624084631065, -122.484642830378) | 1 | 8 | 3 | 56 | 35 | |||
| 11092 | 74333 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1118 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6015132.5367 | 2090213.511 | 37.720178552846 | -122.389715298726 | (37.720178552846, -122.389715298726) | 10 | 3 | 8 | 58 | 1 | |||
| 11107 | 78786 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1356 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6001332.0848 | 2110785.1298 | 37.7758884007732 | -122.438892183533 | (37.7758884007732, -122.438892183533) | 15 | 5 | 11 | 29492 | 10 | |||
| 11347 | 85990 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2234 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987638.7841 | 2100062.768 | 37.7456591364178 | -122.485473213008 | (37.7456591364178, -122.485473213008) | 1 | 8 | 3 | 29491 | 35 | ||
| 11366 | 53918 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
| 11410 | 25472 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 205X Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 6 | 3X3 | 5993432.494 | 2088486.2672 | 37.7142087634879 | -122.464599140586 | (37.7142087634879, -122.464599140586) | 9 | 8 | 6 | 64 | 24 | ||
| 11419 | 51055 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 640 Rivera St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2004 12:00:00 AM | Permit Number 47524 | 5991199.18695168 | 2100466.01651136 | 37.746973143605 | -122.47319139748 | (37.746973143605, -122.47319139748) | 1 | 8 | 4 | 29491 | 40 | |||
| 11452 | 110549 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
| 11462 | 38558 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1534 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40523 | 6015743.77247492 | 2095689.90327715 | 37.7352495140639 | -122.387984392406 | (37.7352495140639, -122.387984392406) | 10 | 3 | 8 | 58 | 1 | ||
| 11464 | 71211 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2267 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5988532.3745 | 2099906.1549 | 37.7452811395366 | -122.48237187504 | (37.7452811395366, -122.48237187504) | 1 | 8 | 3 | 29491 | 35 | |||
| 11497 | 26788 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 78 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/1999 12:00:00 AM | 4 | 3X3 | 6010596.3656 | 2087261.1203 | 37.711819305554 | -122.405187615188 | (37.711819305554, -122.405187615188) | 9 | 7 | 8 | 309 | 39 | ||
| 11519 | 261392 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 670 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010377.23792 | 2118557.51621 | 37.7977399869991 | -122.408150809713 | (37.7977399869991, -122.408150809713) | 3 | 1 | 10 | 308 | 4 | |||||
| 11581 | 98091 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2X Frank Norris St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6007129.63323 | 2115568.12393 | 37.7893494826426 | -122.419176280756 | (37.7893494826426, -122.419176280756) | 13 | 9 | 10 | 28858 | 21 | ||
| 11590 | 37254 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4200 20th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) | 2 | 4 | 5 | 28862 | 3 | ||
| 11618 | 92317 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2787 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985840.9699 | 2096433.9745 | 37.7355905329114 | -122.491422653463 | (37.7355905329114, -122.491422653463) | 1 | 8 | 3 | 29491 | 35 | ||
| 11667 | 72507 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2135 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5988189.7462 | 2100767.6803 | 37.7476267230083 | -122.483619763458 | (37.7476267230083, -122.483619763458) | 1 | 8 | 3 | 29491 | 35 | |||
| 11747 | 66492 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 52 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | 8 | Permit Number 29653 | 6009972.98695 | 2110931.16988 | 37.7767772230325 | -122.409011252663 | (37.7767772230325, -122.409011252663) | 8 | 2 | 9 | 28853 | 34 | |
| 11798 | 66507 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 64 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | Permit Number 29671 | 6009973.94739461 | 2110908.31483893 | 37.7767145222423 | -122.409006317188 | (37.7767145222423, -122.409006317188) | 8 | 2 | 9 | 28853 | 34 | ||
| 11895 | 36362 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 136 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39316 | 5995674.40918334 | 2093601.67196771 | 37.7283834402433 | -122.457220086151 | (37.7283834402433, -122.457220086151) | 9 | 7 | 4 | 28861 | 40 | ||
| 11993 | 261391 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 660 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010421.78403 | 2118563.41089 | 37.7977586664904 | -122.407997083107 | (37.7977586664904, -122.407997083107) | 3 | 1 | 10 | 308 | 4 | |||||
| 12075 | 63390 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 725 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2017 12:00:00 AM | 3 | Permit Number 779370 | 6007403.5343153 | 2095452.62499742 | 37.7341324124104 | -122.416802921773 | (37.7341324124104, -122.416802921773) | 2 | 7 | 7 | 28859 | 2 | |
| 12101 | 70886 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2145 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5997606.572 | 2109869.8792 | 37.7731626941817 | -122.451713589147 | (37.7731626941817, -122.451713589147) | 15 | 5 | 11 | 29492 | 16 | |||
| 12147 | 63155 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1466 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1986 12:00:00 AM | Permit Number 23691 | 5992764.22387578 | 2105486.82086268 | 37.7608494648287 | -122.468144857754 | (37.7608494648287, -122.468144857754) | 1 | 8 | 4 | 56 | 12 | ||
| 12189 | 9378 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 320 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6001091.8143019 | 2097867.0769739 | 37.7404048998329 | -122.438797433034 | (37.7404048998329, -122.438797433034) | 2 | 7 | 5 | 63 | 7 | |||
| 12262 | 261408 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 12308 | 61076 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2611 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/01/1983 12:00:00 AM | 1 | Permit Number 20913 | 5999537.3607 | 2113600.286 | 37.7835158217397 | -122.445303028393 | (37.7835158217397, -122.445303028393) | 15 | 6 | 1 | 29490 | 31 | |
| 12502 | 261420 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 780 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009867.40288 | 2118488.04976 | 37.7975206891225 | -122.409910080478 | (37.7975206891225, -122.409910080478) | 3 | 1 | 10 | 308 | 4 | |||||
| 12670 | 86450 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2362 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987982.1495 | 2099214.8079 | 37.7433508614418 | -122.4842237451 | (37.7433508614418, -122.4842237451) | 1 | 8 | 3 | 29491 | 35 | ||
| 12686 | 84527 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 32 Mars St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50968 | 5999562.49866969 | 2105598.34791337 | 37.7615459654268 | -122.444640731753 | (37.7615459654268, -122.444640731753) | 15 | 5 | 5 | 28862 | 3 | ||
| 12839 | 43336 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 423 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2000 12:00:00 AM | 6 | Permit Number 43093 | 6003416.5357 | 2091104.19433 | 37.7219675345615 | -122.430277093028 | (37.7219675345615, -122.430277093028) | 9 | 7 | 6 | 28861 | 5 | |
| 12874 | 34981 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 336 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41309 | 6003431.10233151 | 2104509.78972726 | 37.7587770412129 | -122.43118312363 | (37.7587770412129, -122.43118312363) | 2 | 4 | 5 | 28862 | 3 | ||
| 12911 | 25471 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 237 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5993297.6081 | 2088487.2193 | 37.7142036007288 | -122.465065423908 | (37.7142036007288, -122.465065423908) | 9 | 8 | 6 | 64 | 24 | ||
| 13159 | 63787 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4043 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24473 | 6003575.02317091 | 2101250.14462278 | 37.749834980882 | -122.430452801929 | (37.749834980882, -122.430452801929) | 2 | 4 | 5 | 28862 | 22 | ||
| 13210 | 244980 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 289 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005226.4402 | 2109722.7783 | 37.7731922392405 | -122.425344978098 | (37.7731922392405, -122.425344978098) | 7 | 9 | 11 | 28852 | 10 | |||
| 13229 | 21689 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1881 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6003724.339 | 2114539.1952 | 37.7863319437467 | -122.43088473956 | (37.7863319437467, -122.43088473956) | 13 | 9 | 11 | 29490 | 13 | |||
| 13252 | 92316 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2787 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985840.4393 | 2096424.4229 | 37.7355642757438 | -122.49142378511 | (37.7355642757438, -122.49142378511) | 1 | 8 | 3 | 29491 | 35 | ||
| 13514 | 65246 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1123 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28040 | 6009230.45296658 | 2102616.7905535 | 37.753906226408 | -122.410992511898 | (37.753906226408, -122.410992511898) | 2 | 4 | 7 | 28859 | 19 | ||
| 13647 | 43721 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 655 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43361 | 5995440.43888004 | 2089883.51967293 | 37.7181608417184 | -122.457759993154 | (37.7181608417184, -122.457759993154) | 9 | 8 | 6 | 28861 | 24 | ||
| 13724 | 85931 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1686 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988131.3934 | 2103830.0344 | 37.756031730146 | -122.484046073449 | (37.756031730146, -122.484046073449) | 1 | 8 | 3 | 56 | 35 | ||
| 13767 | 38951 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 300 Urbano Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/04/1998 12:00:00 AM | Permit Number 40747 | 5992264.30447735 | 2092728.68952836 | 37.7257900052514 | -122.468945369117 | (37.7257900052514, -122.468945369117) | 9 | 8 | 4 | 59 | 40 | ||
| 13781 | 40472 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 43 Lakeview Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | 9 | 8 | 6 | 28861 | 24 | |||
| 13830 | 62681 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 59 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1986 12:00:00 AM | Permit Number 23015 | 6002832.11131033 | 2108737.08241022 | 37.7703501979341 | -122.433556812869 | (37.7703501979341, -122.433556812869) | 15 | 5 | 5 | 29492 | 9 | ||
| 13963 | 63055 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 74 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | 3 | Permit Number 29651 | 6010016.44472 | 2110878.7775 | 37.7766358001278 | -122.408857221277 | (37.7766358001278, -122.408857221277) | 8 | 2 | 9 | 28853 | 34 | |
| 14089 | 261410 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 14237 | 240835 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1383 Vermont St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
| 14300 | 261393 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 661 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010427.0314 | 2118523.75657 | 37.7976500791874 | -122.407976127788 | (37.7976500791874, -122.407976127788) | 3 | 1 | 10 | 308 | 4 | |||||
| 14311 | 71226 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2267 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5987603.3648 | 2099853.8795 | 37.7450835205099 | -122.485580358953 | (37.7450835205099, -122.485580358953) | 1 | 8 | 3 | 29491 | 35 | |||
| 14432 | 178904 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 10x Mansell St | 4 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6011792.88406 | 2090769.73397 | 37.7215200714836 | -122.401298496839 | (37.7215200714836, -122.401298496839) | 10 | 3 | 8 | 309 | 28 | |||
| 14515 | 214414 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 659 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5997734.91386 | 2094962.25156 | 37.7322373939404 | -122.450194889199 | (37.7322373939404, -122.450194889199) | 9 | 7 | 4 | 59 | 40 | ||||
| 14566 | 31845 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
| 14580 | 33345 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 90 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37482 | 6001488.85408541 | 2094961.63013744 | 37.7324497978026 | -122.437216648553 | (37.7324497978026, -122.437216648553) | 9 | 7 | 5 | 63 | 40 | ||
| 14620 | 65548 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 335 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1990 12:00:00 AM | Permit Number 28447 | 5995087.51239517 | 2097484.61184976 | 37.7390113196181 | -122.459530109112 | (37.7390113196181, -122.459530109112) | 9 | 7 | 4 | 59 | 40 | ||
| 15189 | 89400 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1908 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5992787.397851 | 2112077.494993 | 37.77894703563 | -122.468544248635 | (37.77894703563, -122.468544248635) | 11 | 6 | 2 | 54 | 11 | ||
| 15267 | 119759 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
| 15294 | 178876 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 852 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2005 12:00:00 AM | 1 | Width 2ft | Permit Number 48053 | 6000760.9108 | 2088982.59449 | 37.7159913219087 | -122.439304903221 | (37.7159913219087, -122.439304903221) | 9 | 7 | 6 | 28861 | 5 | |
| 15474 | 67662 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1544 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | Permit Number 31263 | 6016003.68231462 | 2097240.31166612 | 37.739521017402 | -122.387193890351 | (37.739521017402, -122.387193890351) | 10 | 3 | 8 | 58 | 1 | ||
| 15516 | 39334 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
| 15546 | 86251 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2230 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988566.0868 | 2100132.7531 | 37.7459052793749 | -122.482271903737 | (37.7459052793749, -122.482271903737) | 1 | 8 | 3 | 29491 | 35 | ||
| 15646 | 182066 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1383 26th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5988020.5944 | 2105839.0631 | 37.761541526107 | -122.484576606624 | (37.761541526107, -122.484576606624) | 1 | 8 | 3 | 56 | 35 | |||
| 15690 | 214433 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1530 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993395.62301 | 2105048.89443 | 37.7596834779287 | -122.465929324277 | (37.7596834779287, -122.465929324277) | 1 | 8 | 4 | 56 | 12 | |||
| 15708 | 36338 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 47 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39302 | 5995626.1352497 | 2092908.66266202 | 37.7264778306363 | -122.457336855787 | (37.7264778306363, -122.457336855787) | 9 | 7 | 4 | 28861 | 40 |
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) );