trees

467 rows where Police Districts = 7 and qSpecies_id = 8 sorted by Neighborhoods (old)

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);