trees
2,694 rows where qSpecies_id = 84 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||||
| 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 | ||
| 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 | ||
| 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 | |||||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |
| 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 | |||
| 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 | ||||||||||||||
| 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 | ||
| 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 | ||
| 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 | |||
| 15899 | 184179 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1607 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5981558.7987 | 2104123.9871 | 37.7564539963073 | -122.506797700314 | (37.7564539963073, -122.506797700314) | 1 | 8 | 3 | 56 | 35 | |||
| 16087 | 71214 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2131 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988191.5983 | 2100799.6289 | 37.7477145531771 | -122.483615701045 | (37.7477145531771, -122.483615701045) | 1 | 8 | 3 | 29491 | 35 | |||
| 16092 | 63589 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 718 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1987 12:00:00 AM | Permit Number 24217 | 6007364.81298333 | 2095596.86962092 | 37.734526298545 | -122.416947010477 | (37.734526298545, -122.416947010477) | 2 | 7 | 7 | 28859 | 2 | ||
| 16201 | 38115 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1342 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 5 | Permit Number 40279 | 5987120.6367 | 2106124.4711 | 37.7622727278914 | -122.487710118761 | (37.7622727278914, -122.487710118761) | 1 | 8 | 3 | 56 | 35 | |
| 16400 | 60155 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1668 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2003 12:00:00 AM | Permit Number 19686 | 5990610.46669896 | 2104039.03153173 | 37.7567495994005 | -122.475487960344 | (37.7567495994005, -122.475487960344) | 1 | 8 | 4 | 56 | 12 | ||
| 16412 | 66973 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 154 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1992 12:00:00 AM | 2 | Permit Number 30316 | 5997837.7074 | 2109963.7906 | 37.773433785241 | -122.450920838457 | (37.773433785241, -122.450920838457) | 15 | 5 | 11 | 29492 | 16 | |
| 16541 | 73456 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 52 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6009946.95062 | 2110955.66255 | 37.776843015637 | -122.409103049163 | (37.776843015637, -122.409103049163) | 8 | 2 | 9 | 28853 | 34 | |||
| 16616 | 43283 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 872 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 6 | Permit Number 43052 | 6010937.3393 | 2090651.38579 | 37.7211473420438 | -122.404247572584 | (37.7211473420438, -122.404247572584) | 10 | 3 | 7 | 309 | 28 | |
| 16758 | 86256 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1754 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988460.2167 | 2103365.3979 | 37.7547751017133 | -122.482874855725 | (37.7547751017133, -122.482874855725) | 1 | 8 | 3 | 56 | 35 | ||
| 16965 | 31849 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
| 17013 | 70667 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 20 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009828.97228 | 2111081.01172 | 37.7771805851524 | -122.409520022524 | (37.7771805851524, -122.409520022524) | 8 | 2 | 9 | 28853 | 34 | |||
| 17072 | 259381 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 225 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5997701 | 2087724 | 37.7123609051901 | -122.449790697309 | (37.7123609051901, -122.449790697309) | 9 | 7 | 6 | 28861 | 25 | ||||
| 17102 | 64930 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2306 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1989 12:00:00 AM | Permit Number 25958 | 5991495.59202308 | 2099725.9184431 | 37.7449581828883 | -122.47211252761 | (37.7449581828883, -122.47211252761) | 1 | 8 | 4 | 29491 | 40 | ||
| 17474 | 71170 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2127 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5987570.8389 | 2100801.7844 | 37.747684319575 | -122.485762384494 | (37.747684319575, -122.485762384494) | 1 | 8 | 3 | 29491 | 35 | |||
| 17485 | 64739 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 139 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51671 | 6002793.57505281 | 2109015.34015791 | 37.7711120386945 | -122.433710000051 | (37.7711120386945, -122.433710000051) | 15 | 5 | 11 | 29492 | 9 | ||
| 17492 | 43352 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4184 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2000 12:00:00 AM | Permit Number 43104 | 6002499.60919335 | 2104164.95121467 | 37.7577773673085 | -122.43437999795 | (37.7577773673085, -122.43437999795) | 2 | 4 | 5 | 28862 | 3 | ||
| 17531 | 64923 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2326 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/24/1989 12:00:00 AM | Permit Number 25951 | 5991484.88147917 | 2099641.61135178 | 37.744726077495 | -122.472143418263 | (37.744726077495, -122.472143418263) | 1 | 8 | 4 | 29491 | 40 | ||
| 17563 | 85987 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2286 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987649.8793 | 2099748.6884 | 37.7447974037311 | -122.485411804387 | (37.7447974037311, -122.485411804387) | 1 | 8 | 3 | 29491 | 35 | ||
| 17648 | 261398 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 711 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010187.59569 | 2118491.78545 | 37.7975488860672 | -122.408802387211 | (37.7975488860672, -122.408802387211) | 3 | 1 | 10 | 308 | 4 | |||||
| 17765 | 47693 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 469 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45492 | 6003825.81919033 | 2095934.94010265 | 37.7352548563783 | -122.429206586085 | (37.7352548563783, -122.429206586085) | 2 | 7 | 5 | 63 | 7 | ||
| 18112 | 95447 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2210 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3 | 4x6 | Permit Number 767309 | 5985770.3096 | 2100149.6093 | 37.7457885421032 | -122.491940419621 | (37.7457885421032, -122.491940419621) | 1 | 8 | 3 | 29491 | 35 |
| 18252 | 60819 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1607 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1983 12:00:00 AM | 1 | Permit Number 20497 | 5989955.2951 | 2101733.4508 | 37.7503810843418 | -122.477585243781 | (37.7503810843418, -122.477585243781) | 1 | 8 | 3 | 29491 | 35 | |
| 18344 | 40022 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1535 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 9 | Permit Number 41267 | 6015717.1223 | 2095636.9971 | 37.7351027679039 | -122.388072841786 | (37.7351027679039, -122.388072841786) | 10 | 3 | 8 | 58 | 1 | |
| 18360 | 32820 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4231 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37179 | 6001652.66778496 | 2102313.08223681 | 37.7526444703409 | -122.437176476876 | (37.7526444703409, -122.437176476876) | 2 | 4 | 5 | 28862 | 22 | ||
| 18397 | 41870 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 25 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42249 | 6003816.33085796 | 2108205.89422295 | 37.76894747793 | -122.430114498812 | (37.76894747793, -122.430114498812) | 7 | 9 | 5 | 28862 | 3 | ||
| 18417 | 4023 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1900 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2015 02:44:00 PM | 3 | 3X3 | 6013444.0079121 | 2101040.051797 | 37.7498122193832 | -122.396310443681 | (37.7498122193832, -122.396310443681) | 10 | 3 | 8 | 28856 | 1 | ||
| 18564 | 73527 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2119 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988189.2832 | 2100871.8604 | 37.747912746917 | -122.483629001347 | (37.747912746917, -122.483629001347) | 1 | 8 | 3 | 29491 | 35 | |||
| 19155 | 80023 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 632-632 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6001104.7117 | 2110909.6213 | 37.7762172841329 | -122.439687650862 | (37.7762172841329, -122.439687650862) | 15 | 5 | 11 | 29492 | 10 | |||
| 19203 | 65549 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 336 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1990 12:00:00 AM | Permit Number 28448 | 5995107.08134396 | 2097533.05659271 | 37.7391454621224 | -122.45946595669 | (37.7391454621224, -122.45946595669) | 9 | 7 | 4 | 59 | 40 | ||
| 19264 | 259569 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Public Park | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994238 | 2098707 | 37.7423188086517 | -122.462555955845 | (37.7423188086517, -122.462555955845) | 1 | 8 | 4 | 59 | 40 | ||||
| 19300 | 214438 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1237 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993585.37565 | 2107057.08841 | 37.7652083981778 | -122.465418951844 | (37.7652083981778, -122.465418951844) | 11 | 8 | 11 | 56 | 12 | |||
| 19438 | 244904 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 151 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999860.3433 | 2109070.0361 | 37.7710953445719 | -122.443860048791 | (37.7710953445719, -122.443860048791) | 15 | 5 | 11 | 29492 | 9 | |||
| 19528 | 244063 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1670 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | Width 0ft | 5998595.6913 | 2109011.0161 | 37.7708610734694 | -122.448230254318 | (37.7708610734694, -122.448230254318) | 15 | 5 | 11 | 29492 | 9 | ||
| 19543 | 70633 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 514 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | 6003062.45597 | 2090620.05211 | 37.720618125211 | -122.431466512079 | (37.720618125211, -122.431466512079) | 9 | 7 | 6 | 28861 | 5 | ||
| 19566 | 178881 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 631 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002458.40291 | 2090087.03952 | 37.7191203367176 | -122.433516460014 | (37.7191203367176, -122.433516460014) | 9 | 7 | 6 | 28861 | 5 | |||
| 19600 | 70126 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 518 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 3x3 | Permit Number 767414 | 6003049.75959 | 2090601.90902 | 37.7205675887031 | -122.431509104887 | (37.7205675887031, -122.431509104887) | 9 | 7 | 6 | 28861 | 5 | |
| 19672 | 39059 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2112 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1998 12:00:00 AM | Permit Number 40773 | 6009544.26649418 | 2104935.53582208 | 37.7602905710121 | -122.410070953081 | (37.7602905710121, -122.410070953081) | 2 | 4 | 7 | 28859 | 19 | ||
| 19730 | 45264 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 679 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44110 | 6007437.04043274 | 2095812.31493778 | 37.7351219268063 | -122.416712553249 | (37.7351219268063, -122.416712553249) | 2 | 7 | 7 | 28859 | 2 | ||
| 19743 | 237974 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6005423.51837 | 2102260.48733 | 37.7527136870909 | -122.424132459851 | (37.7527136870909, -122.424132459851) | 2 | 4 | 5 | 28859 | 19 | |||
| 19918 | 182711 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1707 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5988401.4839 | 2103680.4418 | 37.7556367099705 | -122.483101057669 | (37.7556367099705, -122.483101057669) | 1 | 8 | 3 | 56 | 35 | |||
| 20120 | 85951 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1390 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988061.1772 | 2105842.3097 | 37.7615528036389 | -122.484436487246 | (37.7615528036389, -122.484436487246) | 1 | 8 | 3 | 56 | 35 | ||
| 20130 | 68264 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 381 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32070 | 6009731.82582651 | 2092664.31257859 | 37.72660698205 | -122.408556624594 | (37.72660698205, -122.408556624594) | 10 | 3 | 7 | 309 | 28 | ||
| 20137 | 86308 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1503 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988358.1168 | 2105058.904 | 37.7594190709864 | -122.483352077356 | (37.7594190709864, -122.483352077356) | 1 | 8 | 3 | 56 | 35 | ||
| 20153 | 36371 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 149 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39320 | 5995639.30235658 | 2093700.91704077 | 37.7286539269724 | -122.45734862822 | (37.7286539269724, -122.45734862822) | 9 | 7 | 4 | 28861 | 40 | ||
| 20346 | 141250 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 42 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5996544.0519 | 2114280.1621 | 37.7852112604093 | -122.455707816901 | (37.7852112604093, -122.455707816901) | 11 | 6 | 1 | 54 | 31 | |||
| 20580 | 86119 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2462 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988932.9456 | 2098582.1283 | 37.7416690029042 | -122.480889862999 | (37.7416690029042, -122.480889862999) | 1 | 8 | 3 | 29491 | 35 | ||
| 20696 | 84041 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1514 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52690 | 5986231.2266 | 2104899.676 | 37.7588578622757 | -122.490696090341 | (37.7588578622757, -122.490696090341) | 1 | 8 | 3 | 56 | 35 | |
| 21001 | 37006 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1065 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39620 | 6009210.89939839 | 2102965.35956072 | 37.7548622220933 | -122.411084752447 | (37.7548622220933, -122.411084752447) | 2 | 4 | 7 | 28859 | 19 |
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) );