trees

534 rows where Fire Prevention Districts = 2 and qSpecies_id = 8

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention 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
893 226590 Private 9 Eriobotrya deflexa :: Bronze Loquat 8 837 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 Port 08/14/2019 12:00:00 AM 3 3x3 Permit Number 784594 6001099.54842 2099653.23365 37.7453097044788 -122.438898660558 (37.7453097044788, -122.438898660558) 2 4 5 63 22
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
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
2215 49868 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 368 Bosworth St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2003 12:00:00 AM   3x3 Permit Number 46634 6003577.84688999 2095267.92973361 37.7334093561858 -122.430016351279 (37.7334093561858, -122.430016351279) 2 7 5 28861 25
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
3218 84023 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 309 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM   3x3 Permit Number 773233 6004808.26935881 2101900.57071737 37.7516906826671 -122.42623448013 (37.7516906826671, -122.42623448013) 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
3984 243570 Private 9 Eriobotrya deflexa :: Bronze Loquat 8 837 Duncan St 2 Sidewalk: Curb side : Cutout Tree Private 2 Port   3 3x3 Permit Number 784594 6001117.2647 2099653.19311 37.7453106011164 -122.438837397829 (37.7453106011164, -122.438837397829) 2 4 5 63 22
4370 38420 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1542 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42357 6004548.16357043 2099910.23270392 37.7462109701995 -122.426992216906 (37.7462109701995, -122.426992216906) 2 7 5 63 22
5257 62102 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 440 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/28/1985 12:00:00 AM     Permit Number 22195 6006762.92692973 2101210.352632 37.7499057910946 -122.419426042368 (37.7499057910946, -122.419426042368) 2 4 7 28859 19
5373 224056 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 4609 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2020 12:00:00 AM 3 Width 3ft Permit Number 787677 6000381.16624 2105168.69891 37.7604129369301 -122.441778467817 (37.7604129369301, -122.441778467817) 2 4 5 28862 3
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
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
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
8997 47687 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 1045 Sanchez St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/22/2002 12:00:00 AM     Permit Number 45486 6003826.76338909 2102198.68251842 37.7524537008518 -122.429649915481 (37.7524537008518, -122.429649915481) 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
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
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
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
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
18040 33037 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 494 Bartlett St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1996 12:00:00 AM     Permit Number 37315 6006779.65662971 2100908.40918731 37.7490776652966 -122.41934677281 (37.7490776652966, -122.41934677281) 2 4 7 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
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
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
21456 34943 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3968 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/2016 12:00:00 AM 3   Permit Number 775333 6003347.35755113 2102457.99102165 37.7531385434777 -122.43132628846 (37.7531385434777, -122.43132628846) 2 4 5 28862 22
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
24439 49859 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 338 Bosworth St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2003 12:00:00 AM   3x3 Permit Number 46630 6003649.21999567 2095274.80996329 37.7334322896584 -122.429770085042 (37.7334322896584, -122.429770085042) 2 7 5 28861 25
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
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
28255 39127 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 739 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40808 6007354.16846215 2103008.55652832 37.7548765329449 -122.417508922955 (37.7548765329449, -122.417508922955) 2 4 7 28859 19
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
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
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
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
29985 59550 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 374 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24919 6003521.85163486 2098666.09972032 37.7427367824396 -122.43045232079 (37.7427367824396, -122.43045232079) 2 7 5 63 22
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
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
30499 83186 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3453 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50577 6006512.76900503 2105506.90807829 37.7616890471737 -122.420596061932 (37.7616890471737, -122.420596061932) 2 4 7 28859 19
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
31788 64128 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 627 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24899 6002528.44281747 2098851.45130448 37.7431893908467 -122.433900486749 (37.7431893908467, -122.433900486749) 2 7 5 63 7
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
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
32577 35506 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3451 22nd St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38909 6005392.68349986 2103106.02983212 37.75503360932 -122.424299225131 (37.75503360932, -122.424299225131) 2 4 5 28859 19

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