trees
534 rows where Fire Prevention Districts = 2 and qSpecies_id = 8 sorted by PermitNotes
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 | ||||
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 | |||
1153 | 223389 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
1161 | 223387 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
2303 | 223507 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351 23rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006548.17508 | 2102589.95451 | 37.7536817641104 | -122.420266570244 | (37.7536817641104, -122.420266570244) | 2 | 4 | 7 | 28859 | 19 | |||
2337 | 223401 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3647 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6005476.77928 | 2102530.01598 | 37.7534567573481 | -122.423967438743 | (37.7534567573481, -122.423967438743) | 2 | 4 | 5 | 28859 | 19 | |||
2915 | 223666 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1511 Castro St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/16/2016 05:50:00 AM | 2 | Width 3ft | 6002610.0457 | 2101075.27233 | 37.7493001124297 | -122.433777236447 | (37.7493001124297, -122.433777236447) | 2 | 4 | 5 | 28862 | 22 | ||
3440 | 223611 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 255 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006745.90219 | 2102323.75764 | 37.752961988114 | -122.419563899379 | (37.752961988114, -122.419563899379) | 2 | 4 | 7 | 28859 | 19 | |||
3889 | 223641 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006696.02527 | 2102542.97279 | 37.753561093073 | -122.419751936808 | (37.753561093073, -122.419751936808) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
7729 | 223606 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 552 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007244.98796 | 2104086.07115 | 37.7578289967226 | -122.417962880381 | (37.7578289967226, -122.417962880381) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||||
7811 | 10192 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1169 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/16/2016 04:46:00 AM | 3 | 3X3 | 6005805.59526 | 2102140.15786 | 37.7524048554241 | -122.422802617046 | (37.7524048554241, -122.422802617046) | 2 | 4 | 5 | 28859 | 19 | ||
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 | |||
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 | |||
8807 | 224036 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1511 Castro St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/2016 07:10:00 AM | 2 | Width 3ft | 6002606.66337 | 2101060.9954 | 37.7492607194187 | -122.433787912303 | (37.7492607194187, -122.433787912303) | 2 | 4 | 5 | 28862 | 22 | ||
8809 | 223493 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007980.72085 | 2102939.00638 | 37.7547207985381 | -122.415337199951 | (37.7547207985381, -122.415337199951) | 2 | 4 | 7 | 28859 | 19 | |||
8863 | 224037 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4136 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002973.28417 | 2101264.18156 | 37.7498394178669 | -122.432534643177 | (37.7498394178669, -122.432534643177) | 2 | 4 | 5 | 28862 | 22 | |||
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 | ||||
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 | ||||
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 | |||
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 | |||
10631 | 106353 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 3520X 26TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6006283 | 2100840 | 37.7488618444312 | -122.421059362487 | (37.7488618444312, -122.421059362487) | 2 | 4 | 5 | 28859 | 19 | |||
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 | ||||
11823 | 223370 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99 Lapidge St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 6006029.2284 | 2104988.85011 | 37.7602393183104 | -122.422231628499 | (37.7602393183104, -122.422231628499) | 2 | 4 | 5 | 28859 | 19 | |||
12094 | 223388 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
13899 | 223627 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 324 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006726 | 2101710 | 37.7512756289395 | -122.419589182986 | (37.7512756289395, -122.419589182986) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||||
14883 | 242086 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4185 25th St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 02/16/2016 05:57:00 AM | 2 | Width 3ft | 6002948.22198 | 2101215.85126 | 37.7497052929799 | -122.432617857444 | (37.7497052929799, -122.432617857444) | 2 | 4 | 5 | 28862 | 22 | ||
15080 | 223395 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3641 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005336.13601 | 2104859.99107 | 37.7598463829262 | -122.424619544351 | (37.7598463829262, -122.424619544351) | 2 | 4 | 5 | 28859 | 19 | |||
15086 | 207588 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001743.96601 | 2095815.79538 | 37.7348096375426 | -122.436395778947 | (37.7348096375426, -122.436395778947) | 2 | 7 | 5 | 63 | 7 | |||
15246 | 242850 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 483 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003468.14105 | 2098906.5693 | 37.7433940136201 | -122.430655192302 | (37.7433940136201, -122.430655192302) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
15659 | 26852 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/19/2016 05:13:00 AM | 3 | 2X2 | 6005817.98305 | 2101925.96787 | 37.7518174380456 | -122.422744557734 | (37.7518174380456, -122.422744557734) | 2 | 4 | 5 | 28859 | 19 | ||
16056 | 243760 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2432 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 1x3 | 6001985.30347 | 2097161.30264 | 37.7385177995686 | -122.435657623519 | (37.7385177995686, -122.435657623519) | 2 | 7 | 5 | 63 | 7 | |||
16530 | 223386 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3665 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005227.03743 | 2104855.48781 | 37.7598278559952 | -122.424996542879 | (37.7598278559952, -122.424996542879) | 2 | 4 | 5 | 28859 | 19 | |||
18129 | 223629 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006717.33389 | 2102164.58545 | 37.7525233285091 | -122.419651401605 | (37.7525233285091, -122.419651401605) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
18943 | 166174 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3356 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6006632.30883 | 2102638.63296 | 37.7538201643798 | -122.419979070489 | (37.7538201643798, -122.419979070489) | 2 | 4 | 7 | 28859 | 19 | |||
19933 | 223498 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 255 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006745.96401 | 2102320.90162 | 37.7529541496195 | -122.41956348298 | (37.7529541496195, -122.41956348298) | 2 | 4 | 7 | 28859 | 19 | |||
20325 | 223546 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 384 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000939.02096 | 2096709.07098 | 37.7372165929608 | -122.439242751069 | (37.7372165929608, -122.439242751069) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||
20990 | 4475 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1521 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1992 12:00:00 AM | 6 | 3X3 | 6004596.9832 | 2100011.91057 | 37.7464929146108 | -122.426830644527 | (37.7464929146108, -122.426830644527) | 2 | 7 | 5 | 63 | 22 | ||
21102 | 223642 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006690.61182 | 2102567.74424 | 37.753628804832 | -122.419772415291 | (37.753628804832, -122.419772415291) | 2 | 4 | 7 | 28859 | 19 | |||
21897 | 223405 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 201 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005449.32896 | 2102471.93612 | 37.7532957337303 | -122.424058237901 | (37.7532957337303, -122.424058237901) | 2 | 4 | 5 | 28859 | 19 | |||
22090 | 224049 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 260 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002051.64145 | 2104349.66378 | 37.7582591055966 | -122.435942470278 | (37.7582591055966, -122.435942470278) | 2 | 4 | 5 | 28862 | 3 | |||
22315 | 113814 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 4101x 25TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 02/16/2016 06:05:00 AM | 3 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | |
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 | |||
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 | |||
24237 | 223512 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007094.15413 | 2105540.45939 | 37.7618139197035 | -122.418587660093 | (37.7618139197035, -122.418587660093) | 2 | 4 | 7 | 28859 | 19 | |||
25072 | 223529 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4175 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002046.64832 | 2102339.03335 | 37.7527381135931 | -122.435815881724 | (37.7527381135931, -122.435815881724) | 2 | 4 | 5 | 28862 | 22 | |||
25347 | 98970 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6008234.2 | 2102998.9 | 37.7548994960031 | -122.414464835105 | (37.7548994960031, -122.414464835105) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||
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 | |||
28306 | 223532 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 529 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002464.30667 | 2099434.4104 | 37.7447864204556 | -122.434163917953 | (37.7447864204556, -122.434163917953) | 2 | 7 | 5 | 63 | 22 | |||
28415 | 223396 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 90 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6006003.81464 | 2104993.73555 | 37.7602512990686 | -122.42231986997 | (37.7602512990686, -122.42231986997) | 2 | 4 | 5 | 28859 | 19 | |||
29054 | 223592 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1142 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009191.70637 | 2102498.92995 | 37.7535804348003 | -122.411118182576 | (37.7535804348003, -122.411118182576) | 2 | 4 | 7 | 28859 | 19 | |||
29160 | 223644 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3266 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008388.34903 | 2104490.30808 | 37.759003221729 | -122.414037245221 | (37.759003221729, -122.414037245221) | 2 | 4 | 7 | 28859 | 19 | |||
29275 | 257895 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3644 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | ||||
30368 | 223652 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 360 Bosworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003548.82407 | 2095261.83271 | 37.7333909714052 | -122.430116256482 | (37.7333909714052, -122.430116256482) | 2 | 7 | 5 | 28861 | 25 | |||
30646 | 223609 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3330 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006825.79297 | 2102649.13813 | 37.7538599081198 | -122.419310701547 | (37.7538599081198, -122.419310701547) | 2 | 4 | 7 | 28859 | 19 | |||
31318 | 223620 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 439 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006808.42719 | 2101225.05572 | 37.7499487250622 | -122.419269742819 | (37.7499487250622, -122.419269742819) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
32261 | 223373 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Bosworth St | 7 | Front Yard : Yard | Tree | Private 2 | 17 | 6003068.252 | 2095170.80318 | 37.7331137949537 | -122.431771230282 | (37.7331137949537, -122.431771230282) | 2 | 7 | 5 | 28861 | 25 | ||||
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 | |||
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 | |||
35182 | 224055 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3810 20th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6004350.69854 | 2104285.65184 | 37.7582136808258 | -122.427986763479 | (37.7582136808258, -122.427986763479) | 2 | 4 | 5 | 28862 | 3 | |||
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 | ||||
35960 | 99029 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 | ||
36383 | 223525 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4126 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6002321.16912 | 2101815.04035 | 37.7513149436309 | -122.434829071802 | (37.7513149436309, -122.434829071802) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
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 | |||
38908 | 223615 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 408 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006795.31694 | 2101399.56356 | 37.7504271455035 | -122.419327456816 | (37.7504271455035, -122.419327456816) | 2 | 4 | 7 | 28859 | 19 | |||
39001 | 99032 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 | ||
39722 | 223593 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 930 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009378.63549 | 2103724.24958 | 37.756955368323 | -122.41055825836 | (37.756955368323, -122.41055825836) | 2 | 4 | 7 | 28859 | 19 | |||
40081 | 223634 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200x Bartlett St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006707.09054 | 2102321.33719 | 37.7529531558696 | -122.419697945997 | (37.7529531558696, -122.419697945997) | 2 | 4 | 7 | 28859 | 19 | |||
40532 | 223443 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Day St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003241.07095 | 2098648.16117 | 37.742671617906 | -122.431421899403 | (37.742671617906, -122.431421899403) | 2 | 7 | 5 | 63 | 22 | |||
40964 | 99037 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 | ||
42503 | 229348 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2970 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6009679.24982 | 2101052.76499 | 37.7496369166219 | -122.409330094713 | (37.7496369166219, -122.409330094713) | 2 | 4 | 7 | 28859 | 19 | |||
42971 | 103367 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 290X Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6006718.6 | 2102097 | 37.7523378256517 | -122.419642228322 | (37.7523378256517, -122.419642228322) | 2 | 4 | 7 | 28859 | 19 | |||
43583 | 223616 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 408 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006796.55753 | 2101381.3101 | 37.75037709553 | -122.419321872018 | (37.75037709553, -122.419321872018) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
45663 | 223608 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3336 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006799.35896 | 2102646.46368 | 37.7538510758905 | -122.419401926961 | (37.7538510758905, -122.419401926961) | 2 | 4 | 7 | 28859 | 19 | |||
46230 | 99035 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 | ||
46342 | 223655 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 360 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003599.33439 | 2095266.26783 | 37.733406009884 | -122.429941944474 | (37.733406009884, -122.429941944474) | 2 | 7 | 5 | 28861 | 25 | |||
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 | |||
46659 | 223403 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3624 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005621.17135 | 2101994.19422 | 37.7519936655859 | -122.423430010205 | (37.7519936655859, -122.423430010205) | 2 | 4 | 5 | 28859 | 19 | |||
47083 | 224046 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 208 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5999979.04483 | 2104876.63266 | 37.7595880742544 | -122.443148238699 | (37.7595880742544, -122.443148238699) | 2 | 4 | 5 | 28862 | 3 | |||
48313 | 223502 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3433 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006860.5286 | 2101435.19922 | 37.7505286654636 | -122.419104477086 | (37.7505286654636, -122.419104477086) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||
51446 | 223363 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2676 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009986.00474 | 2103992.15144 | 37.757724999121 | -122.40847663451 | (37.757724999121, -122.40847663451) | 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) );