trees
467 rows where Police Districts = 7 and qSpecies_id = 8 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
814 | 261435 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 371 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007244 | 2095778 | 37.7350168462428 | -122.417377534221 | (37.7350168462428, -122.417377534221) | 2 | 7 | 7 | 28859 | 2 | ||||
1037 | 63388 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 139 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23969 | 6005989.66886949 | 2095872.0431692 | 37.7352044148911 | -122.421720887046 | (37.7352044148911, -122.421720887046) | 2 | 7 | 7 | 28859 | 2 | ||
1085 | 223588 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x Jarboe Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6009063.07444 | 2096876.26549 | 37.7381346254237 | -122.411165877211 | (37.7381346254237, -122.411165877211) | 10 | 7 | 7 | 28859 | 2 | |||
1140 | 223581 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 85 Bessie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008353.87265 | 2100058.32291 | 37.7468320543491 | -122.413842976384 | (37.7468320543491, -122.413842976384) | 2 | 7 | 7 | 28859 | 2 | |||
1327 | 261443 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 354 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007142 | 2095710 | 37.7348243937619 | -122.417725367022 | (37.7348243937619, -122.417725367022) | 2 | 7 | 7 | 28859 | 2 | ||||
1423 | 223556 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 701x Andover St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007456 | 2095683 | 37.7347679226533 | -122.416637845271 | (37.7347679226533, -122.416637845271) | 2 | 7 | 7 | 28859 | 2 | |||
6250 | 261442 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 364 Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2095707 | 37.7348180134015 | -122.417611061749 | (37.7348180134015, -122.417611061749) | 2 | 7 | 7 | 28859 | 2 | ||||
6331 | 261440 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 374x Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007239 | 2095686 | 37.7347639531109 | -122.417388303298 | (37.7347639531109, -122.417388303298) | 2 | 7 | 7 | 28859 | 2 | ||||
6487 | 261445 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 339 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007092 | 2095790 | 37.7350412423636 | -122.417903903871 | (37.7350412423636, -122.417903903871) | 2 | 7 | 7 | 28859 | 2 | ||||
7067 | 223489 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 201x Tompkins Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6007880.65482 | 2096572.00473 | 37.73723280954 | -122.415232573728 | (37.73723280954, -122.415232573728) | 2 | 7 | 7 | 28859 | 2 | |||
7760 | 261189 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 599x Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007159 | 2095436 | 37.7340730065148 | -122.41764717788 | (37.7340730065148, -122.41764717788) | 2 | 7 | 7 | 28859 | 2 | ||||
8093 | 223555 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 701x Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007456 | 2095683 | 37.7347679226533 | -122.416637845271 | (37.7347679226533, -122.416637845271) | 2 | 7 | 7 | 28859 | 2 | |||
8415 | 96169 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 45 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767802 | 6007419 | 2097998 | 37.7411223211925 | -122.416929733801 | (37.7411223211925, -122.416929733801) | 2 | 7 | 7 | 28859 | 2 | |
8681 | 223586 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007519 | 2096543 | 37.7371328370553 | -122.416480929712 | (37.7371328370553, -122.416480929712) | 2 | 7 | 7 | 28859 | 2 | |||
8760 | 28315 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 739 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780585 | 6008002.89443 | 2097198.99062 | 37.7389612444527 | -122.414854295516 | (37.7389612444527, -122.414854295516) | 2 | 7 | 7 | 28859 | 2 | |
9157 | 261444 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 350 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007112 | 2095712 | 37.7348281970622 | -122.417829229388 | (37.7348281970622, -122.417829229388) | 2 | 7 | 7 | 28859 | 2 | ||||
9295 | 223587 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x Jarboe Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6009072.26343 | 2096875.24392 | 37.7381323357409 | -122.411134034011 | (37.7381323357409, -122.411134034011) | 10 | 7 | 7 | 28859 | 2 | |||
9542 | 261434 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 383 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007317 | 2095771 | 37.7350017327518 | -122.417124650781 | (37.7350017327518, -122.417124650781) | 2 | 7 | 7 | 28859 | 2 | ||||
9689 | 63382 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 261 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23962 | 6006733.60001952 | 2095809.91850213 | 37.7350757572483 | -122.41914443544 | (37.7350757572483, -122.41914443544) | 2 | 7 | 7 | 28859 | 2 | ||
10016 | 261433 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 393 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007343 | 2095769 | 37.7349977038172 | -122.417034617662 | (37.7349977038172, -122.417034617662) | 2 | 7 | 7 | 28859 | 2 | ||||
10065 | 223575 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007323 | 2098000 | 37.7411224122402 | -122.417261809722 | (37.7411224122402, -122.417261809722) | 2 | 7 | 7 | 28859 | 2 | |||
10072 | 223589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 590X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008529.06402 | 2096927.29731 | 37.7382447851783 | -122.413015832133 | (37.7382447851783, -122.413015832133) | 10 | 7 | 7 | 28859 | 2 | |||
10369 | 223584 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6007576 | 2096576 | 37.7372266531625 | -122.41628619091 | (37.7372266531625, -122.41628619091) | 2 | 7 | 7 | 28859 | 2 | |||
11545 | 261446 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 329 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007068 | 2095792 | 37.7350453831972 | -122.417987022359 | (37.7350453831972, -122.417987022359) | 2 | 7 | 7 | 28859 | 2 | ||||
12550 | 63379 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 311 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23959 | 6006965.60744401 | 2095790.54383517 | 37.7350356215507 | -122.418340927554 | (37.7350356215507, -122.418340927554) | 2 | 7 | 7 | 28859 | 2 | ||
14267 | 261441 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 364 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2095707 | 37.7348180134015 | -122.417611061749 | (37.7348180134015, -122.417611061749) | 2 | 7 | 7 | 28859 | 2 | ||||
15567 | 223585 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6007519 | 2096543 | 37.7371328370553 | -122.416480929712 | (37.7371328370553, -122.416480929712) | 2 | 7 | 7 | 28859 | 2 | |||
18281 | 261190 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 599x Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007159 | 2095436 | 37.7340730065148 | -122.41764717788 | (37.7340730065148, -122.41764717788) | 2 | 7 | 7 | 28859 | 2 | ||||
18382 | 223425 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1514 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010157.18753 | 2100400.68055 | 37.7478732021894 | -122.407631390476 | (37.7478732021894, -122.407631390476) | 2 | 7 | 7 | 28859 | 2 | |||
20012 | 63372 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 371 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23952 | 6007253.22314461 | 2095766.52547538 | 37.7349858586394 | -122.417344833557 | (37.7349858586394, -122.417344833557) | 2 | 7 | 7 | 28859 | 2 | ||
20459 | 223560 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 675 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008145.89505 | 2095713.05268 | 37.7348892176551 | -122.414254758854 | (37.7348892176551, -122.414254758854) | 2 | 7 | 7 | 28859 | 2 | |||
23051 | 223487 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6006838.49776 | 2096321.93409 | 37.7364875458659 | -122.418818066419 | (37.7364875458659, -122.418818066419) | 2 | 7 | 7 | 28859 | 2 | |||
23708 | 223428 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 357 Precita Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6008915.2046 | 2100223.65051 | 37.7473175155876 | -122.411913617629 | (37.7473175155876, -122.411913617629) | 2 | 7 | 7 | 28859 | 2 | |||
23922 | 58026 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 680 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/1987 12:00:00 AM | Permit Number 16994 | 6008648.68681502 | 2095709.61951023 | 37.7349080209093 | -122.412516183192 | (37.7349080209093, -122.412516183192) | 10 | 7 | 7 | 28859 | 2 | ||
24051 | 223567 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 500 Crescent Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007671.39008 | 2095684.74944 | 37.7347848378312 | -122.415893289437 | (37.7347848378312, -122.415893289437) | 2 | 7 | 7 | 28859 | 2 | |||
26446 | 223420 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3247 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009036.51349 | 2099774.38399 | 37.7460907342145 | -122.411462403466 | (37.7460907342145, -122.411462403466) | 2 | 7 | 7 | 28859 | 2 | |||
27726 | 254276 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 102 Bache St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778482 | 6007158.62699 | 2095375.94585 | 37.7339080899914 | -122.417644212443 | (37.7339080899914, -122.417644212443) | 2 | 7 | 7 | 28859 | 2 | |
27764 | 223429 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 357 Precita Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008933.85702 | 2100227.23414 | 37.7473284018833 | -122.411849371861 | (37.7473284018833, -122.411849371861) | 2 | 7 | 7 | 28859 | 2 | |||
28283 | 223478 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 147 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006034.33786 | 2095867.87013 | 37.7351954754822 | -122.42156615355 | (37.7351954754822, -122.42156615355) | 2 | 7 | 7 | 28859 | 2 | |||
29004 | 254341 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 38 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/01/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776525 | 6007503.72696 | 2099881.72077 | 37.7462993638251 | -122.416770197945 | (37.7462993638251, -122.416770197945) | 2 | 7 | 7 | 28859 | 2 |
29773 | 63456 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 801 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1987 12:00:00 AM | Permit Number 24046 | 6007615.99374583 | 2095696.52300413 | 37.7348140509231 | -122.416085647719 | (37.7348140509231, -122.416085647719) | 2 | 7 | 7 | 28859 | 2 | ||
30001 | 115382 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 625 Moultrie St | 1 | Side Yard : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776180 | 6007689.5 | 2096426.5 | 37.7368225406079 | -122.415883184956 | (37.7368225406079, -122.415883184956) | 2 | 7 | 7 | 28859 | 2 | ||
31809 | 223570 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 404 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007482.05364 | 2095699.08707 | 37.7348135594986 | -122.416548907823 | (37.7348135594986, -122.416548907823) | 2 | 7 | 7 | 28859 | 2 | |||
31891 | 63321 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 308 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1987 12:00:00 AM | Permit Number 23894 | 6009704.28478725 | 2099627.84542916 | 37.7457258041449 | -122.409142988334 | (37.7457258041449, -122.409142988334) | 2 | 7 | 7 | 28859 | 2 | ||
32619 | 223416 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 418 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009155.95431 | 2100059.10664 | 37.7468792184109 | -122.411069498672 | (37.7468792184109, -122.411069498672) | 2 | 7 | 7 | 28859 | 2 | |||
33240 | 63451 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 329 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1987 12:00:00 AM | 3x7 | Permit Number 24039 | 6007051.75115976 | 2095783.35007581 | 37.7350207178849 | -122.418042587516 | (37.7350207178849, -122.418042587516) | 2 | 7 | 7 | 28859 | 2 | |
34014 | 223422 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 356 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008795.6118 | 2100034.66543 | 37.7467918942422 | -122.412313806947 | (37.7467918942422, -122.412313806947) | 2 | 7 | 7 | 28859 | 2 | |||
35633 | 246625 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3300 Harrison St | 3 | Side Yard : Yard | Tree | Private 2 | 1 | 6009033.3388 | 2099395.8346 | 37.7450511430894 | -122.411446641942 | (37.7450511430894, -122.411446641942) | 2 | 7 | 7 | 28859 | 2 | ||||
37052 | 223427 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 357 Precita Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008897.95249 | 2100223.67255 | 37.747316608191 | -122.411973275956 | (37.747316608191, -122.411973275956) | 2 | 7 | 7 | 28859 | 2 | |||
38375 | 115384 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 324 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777467 | 6006881.6 | 2096254.2 | 37.7363039898307 | -122.418664241464 | (37.7363039898307, -122.418664241464) | 2 | 7 | 7 | 28859 | 2 | ||
38540 | 223557 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 443 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007525.59802 | 2096829.0318 | 37.737918588483 | -122.416478372193 | (37.737918588483, -122.416478372193) | 2 | 7 | 7 | 28859 | 2 | |||
38592 | 45299 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44138 | 6007485.11382992 | 2096559.26498899 | 37.7371755914125 | -122.416599241748 | (37.7371755914125, -122.416599241748) | 2 | 7 | 7 | 28859 | 2 | ||
42001 | 223564 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 130 Nevada St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6009029.83515 | 2097858.62477 | 37.7408301058168 | -122.411350181559 | (37.7408301058168, -122.411350181559) | 10 | 7 | 7 | 28859 | 2 | |||
43045 | 63309 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1987 12:00:00 AM | Permit Number 23875 | 6009653.46041158 | 2099624.96602916 | 37.7457150505348 | -122.409318529175 | (37.7457150505348, -122.409318529175) | 2 | 7 | 7 | 28859 | 2 | ||
43621 | 223578 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 165 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006732.92847 | 2098549.7578 | 37.7425987089604 | -122.419341059038 | (37.7425987089604, -122.419341059038) | 2 | 7 | 7 | 28859 | 2 | |||
43995 | 67217 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 412 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1992 12:00:00 AM | Permit Number 30673 | 6007859.73782149 | 2096940.24415247 | 37.7382427386023 | -122.415330954317 | (37.7382427386023, -122.415330954317) | 2 | 7 | 7 | 28859 | 2 | ||
45479 | 108934 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 361 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Fire Dept | 01/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774685 | 6006490.6 | 2097118.7 | 37.7386556931549 | -122.42007742591 | (37.7386556931549, -122.42007742591) | 2 | 7 | 7 | 28859 | 2 |
45695 | 64260 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 170 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25062 | 6009914.7515977 | 2100087.93471467 | 37.7470008969248 | -122.408447669408 | (37.7470008969248, -122.408447669408) | 2 | 7 | 7 | 28859 | 2 | ||
46350 | 223481 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 412 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007869.12634 | 2096919.97239 | 37.7381876044595 | -122.415297058717 | (37.7381876044595, -122.415297058717) | 2 | 7 | 7 | 28859 | 2 | |||
48911 | 32226 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1524 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 10 | Permit Number 35545 | 6008720.30382 | 2099880.58736 | 37.7463646038601 | -122.412563325657 | (37.7463646038601, -122.412563325657) | 2 | 7 | 7 | 28859 | 2 | |
49203 | 63377 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 308 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23957 | 6006914.1385317 | 2095742.66094638 | 37.7349012482628 | -122.418515480064 | (37.7349012482628, -122.418515480064) | 2 | 7 | 7 | 28859 | 2 | ||
49362 | 63315 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 391 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/1987 12:00:00 AM | Permit Number 23882 | 6009191.36429374 | 2100247.35620947 | 37.7473980957636 | -122.410960347715 | (37.7473980957636, -122.410960347715) | 2 | 7 | 7 | 28859 | 2 | ||
50209 | 97899 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 375X Precita Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 6 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | 2 | 7 | 7 | 28859 | 2 | ||
51053 | 58102 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 251 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23965 | 6006689.2765112 | 2095813.61990221 | 37.7350834242778 | -122.41929794049 | (37.7350834242778, -122.41929794049) | 2 | 7 | 7 | 28859 | 2 | ||
51931 | 223568 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 500 Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007653.2155 | 2095688.14958 | 37.7347931520797 | -122.415956366103 | (37.7347931520797, -122.415956366103) | 2 | 7 | 7 | 28859 | 2 | |||
53500 | 223412 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1726 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009299.39544 | 2099281.89074 | 37.7447531977014 | -122.410518617161 | (37.7447531977014, -122.410518617161) | 2 | 7 | 7 | 28859 | 2 | |||
53859 | 63380 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 302 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23960 | 6006871.71117456 | 2095746.20400929 | 37.7349085881089 | -122.41866241779 | (37.7349085881089, -122.41866241779) | 2 | 7 | 7 | 28859 | 2 | ||
57067 | 223583 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 324 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006884.54394 | 2096272.57358 | 37.7363546053711 | -122.418655365578 | (37.7363546053711, -122.418655365578) | 2 | 7 | 7 | 28859 | 2 | |||
57637 | 63381 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 289 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23961 | 6006861.89612331 | 2095799.20465588 | 37.7350535636056 | -122.418700109332 | (37.7350535636056, -122.418700109332) | 2 | 7 | 7 | 28859 | 2 | ||
59464 | 223477 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 181 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006251.94836 | 2095849.23921 | 37.7351565869995 | -122.420812471312 | (37.7351565869995, -122.420812471312) | 2 | 7 | 7 | 28859 | 2 | |||
61714 | 223582 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 57 Bessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008286.43047 | 2100056.77298 | 37.7468240108166 | -122.414076076165 | (37.7468240108166, -122.414076076165) | 2 | 7 | 7 | 28859 | 2 | |||
62074 | 223520 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 78 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004976.40139 | 2096163.67746 | 37.7359479859053 | -122.425244869978 | (37.7359479859053, -122.425244869978) | 2 | 7 | 5 | 28859 | 2 | |||
62521 | 223577 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 180 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6007069.07199 | 2097998.10728 | 37.7411029259504 | -122.418139669131 | (37.7411029259504, -122.418139669131) | 2 | 7 | 7 | 28859 | 2 | |||
64743 | 223374 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 14 Lundys Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007165.43911 | 2099578.09983 | 37.7454466559323 | -122.417918440397 | (37.7454466559323, -122.417918440397) | 2 | 7 | 7 | 28859 | 2 | |||
68862 | 223569 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 500 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007635.55401 | 2095689.61237 | 37.7347961756026 | -122.416017531695 | (37.7347961756026, -122.416017531695) | 2 | 7 | 7 | 28859 | 2 | |||
69103 | 63370 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 393 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1987 12:00:00 AM | 8 | 3x3 | Permit Number 23949 | 6007368.29978773 | 2095756.91555198 | 37.7349659457424 | -122.416946291173 | (37.7349659457424, -122.416946291173) | 2 | 7 | 7 | 28859 | 2 | |
69549 | 63385 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 219 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23966 | 6006529.47672641 | 2095826.96456486 | 37.7351110645595 | -122.419851373342 | (37.7351110645595, -122.419851373342) | 2 | 7 | 7 | 28859 | 2 | ||
70626 | 223482 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4044 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008350.87212 | 2096284.49377 | 37.7364697824441 | -122.413586482552 | (37.7364697824441, -122.413586482552) | 10 | 7 | 7 | 28859 | 2 | |||
71396 | 66453 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 125 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29603 | 6009081.83261092 | 2097914.76259057 | 37.7409871642392 | -122.411174357607 | (37.7409871642392, -122.411174357607) | 10 | 7 | 7 | 28859 | 2 | ||
74874 | 223579 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 175 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006727.49198 | 2098540.80298 | 37.7425738148408 | -122.419359221751 | (37.7425738148408, -122.419359221751) | 2 | 7 | 7 | 28859 | 2 | |||
75368 | 223488 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6006849.71634 | 2096321.20685 | 37.7364861806911 | -122.418779227388 | (37.7364861806911, -122.418779227388) | 2 | 7 | 7 | 28859 | 2 | |||
76652 | 63384 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 259 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23964 | 6006724.73531603 | 2095810.6587823 | 37.7350772906705 | -122.419175136454 | (37.7350772906705, -122.419175136454) | 2 | 7 | 7 | 28859 | 2 | ||
76708 | 223558 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 373 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007726.95623 | 2097342.75217 | 37.7393404732765 | -122.415818542293 | (37.7393404732765, -122.415818542293) | 2 | 7 | 7 | 28859 | 2 | |||
77062 | 63367 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 511 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/1987 12:00:00 AM | Permit Number 23943 | 6007615.98725252 | 2095736.23144951 | 37.7349230812673 | -122.4160884814 | (37.7349230812673, -122.4160884814) | 2 | 7 | 7 | 28859 | 2 | ||
78072 | 223580 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 85 Bessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008370.33425 | 2100060.18297 | 37.746838086126 | -122.413786185095 | (37.746838086126, -122.413786185095) | 2 | 7 | 7 | 28859 | 2 | |||
78602 | 223559 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 625 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007671.64487 | 2096429.50449 | 37.7368297864509 | -122.415945130859 | (37.7368297864509, -122.415945130859) | 2 | 7 | 7 | 28859 | 2 | |||
81015 | 97898 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 375X Precita Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 6 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | 2 | 7 | 7 | 28859 | 2 | ||
82316 | 64027 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 700 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24784 | 6007920.33784852 | 2095628.68558962 | 37.7346448914343 | -122.41502862166 | (37.7346448914343, -122.41502862166) | 2 | 7 | 7 | 28859 | 2 | ||
82391 | 248256 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 116 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006785.81091 | 2098870.27842 | 37.743481764973 | -122.419180937446 | (37.743481764973, -122.419180937446) | 2 | 7 | 7 | 28859 | 2 | |||
83189 | 223414 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 308 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6009647.06904 | 2099615.22374 | 37.7456879422558 | -122.409339942298 | (37.7456879422558, -122.409339942298) | 2 | 7 | 7 | 28859 | 2 | |||
84067 | 223485 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 125 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6009074.65326 | 2097933.54072 | 37.7410383222477 | -122.411200507415 | (37.7410383222477, -122.411200507415) | 10 | 7 | 7 | 28859 | 2 | |||
84738 | 223475 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 259 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006730.85862 | 2095808.36248 | 37.7350713303711 | -122.419153803122 | (37.7350713303711, -122.419153803122) | 2 | 7 | 7 | 28859 | 2 | |||
86200 | 223421 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 390 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008952.93312 | 2100044.20603 | 37.7468269174367 | -122.411770477042 | (37.7468269174367, -122.411770477042) | 2 | 7 | 7 | 28859 | 2 | |||
87603 | 223571 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007463.60834 | 2095702.768 | 37.7348226291584 | -122.416612940446 | (37.7348226291584, -122.416612940446) | 2 | 7 | 7 | 28859 | 2 | |||
87729 | 248098 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 11 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010471.50543 | 2099820.33523 | 37.7462972904853 | -122.40650360018 | (37.7462972904853, -122.40650360018) | 2 | 7 | 7 | 28859 | 2 | |||
88817 | 223483 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 562 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008521.06241 | 2096162.71972 | 37.7361449725004 | -122.412989453223 | (37.7361449725004, -122.412989453223) | 10 | 7 | 7 | 28859 | 2 | |||
90088 | 63317 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 408 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/1987 12:00:00 AM | Permit Number 23884 | 6009379.46071943 | 2100205.52672578 | 37.7472937869951 | -122.410306967571 | (37.7472937869951, -122.410306967571) | 2 | 7 | 7 | 28859 | 2 | ||
91486 | 223431 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 357 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009008.57649 | 2100230.6631 | 37.747342008624 | -122.411591238552 | (37.747342008624, -122.411591238552) | 2 | 7 | 7 | 28859 | 2 | |||
91912 | 107688 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X ALEMANY BLVD | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 16 | 6008820.4 | 2095497.5 | 37.7343352217744 | -122.411907523711 | (37.7343352217744, -122.411907523711) | 10 | 7 | 7 | 28859 | 2 | ||||
91937 | 108615 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 136 Precita Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774598 | 6007320.4947 | 2100127.53408 | 37.7469640041817 | -122.417421212351 | (37.7469640041817, -122.417421212351) | 2 | 7 | 7 | 28859 | 2 |
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) );