trees
168 rows where Fire Prevention Districts = 8 and qSpecies_id = 8 sorted by Supervisor Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34878 | 224062 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 67 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004498.44679 | 2107387.20492 | 37.7667381638479 | -122.427696765417 | (37.7667381638479, -122.427696765417) | 8 | 4 | 5 | 28862 | 3 | |||
| 39751 | 96590 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 44908 | 96593 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 63210 | 96591 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 81530 | 96594 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 118346 | 105752 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 67 LANDERS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6004519.3 | 2107402.1 | 37.7667802417179 | -122.427625698984 | (37.7667802417179, -122.427625698984) | 8 | 4 | 5 | 28862 | 3 | |||
| 145479 | 96592 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 156111 | 96589 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 13425 | 223490 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008605.30011 | 2107940.39716 | 37.768488553924 | -122.41353093232 | (37.768488553924, -122.41353093232) | 8 | 4 | 7 | 28853 | 19 | |||
| 13567 | 243284 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1450 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007678.08789 | 2107386.86578 | 37.766916579475 | -122.416698868869 | (37.766916579475, -122.416698868869) | 8 | 4 | 7 | 28853 | 19 | |
| 14895 | 42944 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 30 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42839 | 6007671.6020798 | 2107773.96917263 | 37.7679791099284 | -122.416748729284 | (37.7679791099284, -122.416748729284) | 8 | 4 | 7 | 28853 | 19 | ||
| 17404 | 37672 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3270 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40070 | 6007686 | 2105618 | 37.7620601307471 | -122.416546187971 | (37.7620601307471, -122.416546187971) | 8 | 4 | 7 | 28859 | 19 |
| 23459 | 223514 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3349 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006548.63349 | 2106093.81796 | 37.763302585471 | -122.420513683285 | (37.763302585471, -122.420513683285) | 8 | 4 | 7 | 28859 | 19 | |||
| 30436 | 223435 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 335 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006142.1002 | 2107638.15055 | 37.7675200389439 | -122.422029465401 | (37.7675200389439, -122.422029465401) | 8 | 4 | 7 | 28853 | 19 | |||
| 32151 | 22922 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6006142.65939 | 2107729.77965 | 37.7677716622264 | -122.422034041273 | (37.7677716622264, -122.422034041273) | 8 | 4 | 7 | 28853 | 19 | |||
| 39142 | 223599 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6007767.1377 | 2106084.40018 | 37.7633453203425 | -122.416298598605 | (37.7633453203425, -122.416298598605) | 8 | 4 | 7 | 28859 | 19 | |||
| 39376 | 223432 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 321 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6006137.48741 | 2107733.43659 | 37.7677814116141 | -122.422052190377 | (37.7677814116141, -122.422052190377) | 8 | 4 | 7 | 28853 | 19 | |||
| 42828 | 223602 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 280x Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2017 12:00:00 AM | 3 | Width 3ft | 6007724 | 2106220 | 37.7637152201621 | -122.416457403809 | (37.7637152201621, -122.416457403809) | 8 | 4 | 7 | 28859 | 19 | ||
| 43767 | 223603 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 66 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007689.4598 | 2107580.51877 | 37.7674489448444 | -122.416673255272 | (37.7674489448444, -122.416673255272) | 8 | 4 | 7 | 28853 | 19 | |||
| 56214 | 38319 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | Permit Number 774280 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.413465790173 | (37.7684292621485, -122.413465790173) | 8 | 4 | 7 | 28853 | 19 | |||
| 60680 | 223433 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 321 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006139.56315 | 2107708.41808 | 37.7677128338021 | -122.422043233108 | (37.7677128338021, -122.422043233108) | 8 | 4 | 7 | 28853 | 19 | |||
| 78696 | 42947 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 370 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42842 | 6007791.87448942 | 2105665.73605783 | 37.7621971566206 | -122.416183388947 | (37.7621971566206, -122.416183388947) | 8 | 4 | 7 | 28859 | 19 | ||
| 82057 | 42946 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 64 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42841 | 6007766.22670563 | 2106145.49280526 | 37.7635130152875 | -122.416306076762 | (37.7635130152875, -122.416306076762) | 8 | 4 | 7 | 28859 | 19 | ||
| 82251 | 37664 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3250 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/2004 12:00:00 AM | Permit Number 40070 | 6007810.11967641 | 2105631.1413248 | 37.7621031933661 | -122.416117835461 | (37.7621031933661, -122.416117835461) | 8 | 4 | 7 | 28859 | 19 | ||
| 82980 | 37665 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 376X Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40070 | 6007793 | 2105738 | 37.762395639966 | -122.416184614422 | (37.762395639966, -122.416184614422) | 8 | 4 | 7 | 28859 | 19 |
| 85610 | 64683 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 306 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/1988 12:00:00 AM | Permit Number 25622 | 6007786.51024737 | 2105766.07733259 | 37.7624723689104 | -122.416209048783 | (37.7624723689104, -122.416209048783) | 8 | 4 | 7 | 28859 | 19 | ||
| 97614 | 64685 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 304 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/1988 12:00:00 AM | Permit Number 25625 | 6007786.34261543 | 2105769.21298565 | 37.7624809692619 | -122.416209850653 | (37.7624809692619, -122.416209850653) | 8 | 4 | 7 | 28859 | 19 | ||
| 99318 | 47684 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3250 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2002 12:00:00 AM | Permit Number 45476 | 6007810.11967641 | 2105631.1413248 | 37.7621031933661 | -122.416117835461 | (37.7621031933661, -122.416117835461) | 8 | 4 | 7 | 28859 | 19 | |||
| 101332 | 37666 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 376X Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40070 | 6007793 | 2105738 | 37.762395639966 | -122.416184614422 | (37.762395639966, -122.416184614422) | 8 | 4 | 7 | 28859 | 19 |
| 102187 | 39314 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3248 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40892 | 6007145.08024569 | 2106178.91659474 | 37.7635698413851 | -122.418456799551 | (37.7635698413851, -122.418456799551) | 8 | 4 | 7 | 28859 | 19 | ||
| 105198 | 223491 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008605.65376 | 2107931.14375 | 37.768463166072 | -122.413529054538 | (37.768463166072, -122.413529054538) | 8 | 4 | 7 | 28853 | 19 | |||
| 105783 | 243307 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 590 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/1976 12:00:00 AM | 0 | Width 3ft | 6007430.34748 | 2106243.87464 | 37.7637642560428 | -122.417474751767 | (37.7637642560428, -122.417474751767) | 8 | 4 | 7 | 28859 | 19 | ||
| 107596 | 151878 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1450 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007623.77597 | 2107385.08821 | 37.7669086438472 | -122.416886599646 | (37.7669086438472, -122.416886599646) | 8 | 4 | 7 | 28853 | 19 | |
| 108207 | 223605 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 28 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007673.38803 | 2107757.3509 | 37.767933580499 | -122.416741374417 | (37.767933580499, -122.416741374417) | 8 | 4 | 7 | 28853 | 19 | |||
| 113656 | 223497 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 305 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007806.86285 | 2106132.88029 | 37.763480669211 | -122.416164635585 | (37.763480669211, -122.416164635585) | 8 | 4 | 7 | 28859 | 19 | |||
| 114581 | 22921 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/1999 12:00:00 AM | 16 | 3X3 | 6006144.43338 | 2107707.65753 | 37.7677110201932 | -122.42202633352 | (37.7677110201932, -122.42202633352) | 8 | 4 | 7 | 28853 | 19 | ||
| 128623 | 223651 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008609.3878 | 2107944.17122 | 37.7684991461388 | -122.413517060262 | (37.7684991461388, -122.413517060262) | 8 | 4 | 7 | 28853 | 19 | |||
| 128807 | 223600 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6007768.16924 | 2106112.90661 | 37.76342365039 | -122.416297049994 | (37.76342365039, -122.416297049994) | 8 | 4 | 7 | 28859 | 19 | |||
| 129574 | 22918 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6006138.94284 | 2107682.09275 | 37.7676405157139 | -122.422043508318 | (37.7676405157139, -122.422043508318) | 8 | 4 | 7 | 28853 | 19 | |||
| 131944 | 38317 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 774280 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.413465790173 | (37.7684292621485, -122.413465790173) | 8 | 4 | 7 | 28853 | 19 | |
| 138809 | 38321 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | Permit Number 774280 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.413465790173 | (37.7684292621485, -122.413465790173) | 8 | 4 | 7 | 28853 | 19 | |||
| 147588 | 22920 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6006146.18632 | 2107684.74759 | 37.767648213805 | -122.422018642617 | (37.767648213805, -122.422018642617) | 8 | 4 | 7 | 28853 | 19 | |||
| 150294 | 39316 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3248 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40892 | 6007145.08024569 | 2106178.91659474 | 37.7635698413851 | -122.418456799551 | (37.7635698413851, -122.418456799551) | 8 | 4 | 7 | 28859 | 19 | ||
| 151247 | 37668 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3270 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40070 | 6007686 | 2105618 | 37.7620601307471 | -122.416546187971 | (37.7620601307471, -122.416546187971) | 8 | 4 | 7 | 28859 | 19 |
| 152460 | 223604 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 54 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007683.47887 | 2107616.29854 | 37.7675468513265 | -122.416696477566 | (37.7675468513265, -122.416696477566) | 8 | 4 | 7 | 28853 | 19 | |||
| 153178 | 39315 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3248 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40892 | 6007145.08024569 | 2106178.91659474 | 37.7635698413851 | -122.418456799551 | (37.7635698413851, -122.418456799551) | 8 | 4 | 7 | 28859 | 19 | ||
| 154941 | 223598 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 304 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6007773.13763 | 2106049.50965 | 37.7632498564254 | -122.41627537542 | (37.7632498564254, -122.41627537542) | 8 | 4 | 7 | 28859 | 19 | |||
| 154975 | 22919 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6006146.38467 | 2107662.66758 | 37.7675875985285 | -122.422016387826 | (37.7675875985285, -122.422016387826) | 8 | 4 | 7 | 28853 | 19 | |||
| 155159 | 223492 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008606.40077 | 2107919.47331 | 37.7684311637055 | -122.413525645189 | (37.7684311637055, -122.413525645189) | 8 | 4 | 7 | 28853 | 19 | |||
| 159400 | 223596 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 376 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007789.56875 | 2105780.83552 | 37.7625130634521 | -122.416199515798 | (37.7625130634521, -122.416199515798) | 8 | 4 | 7 | 28859 | 19 | |||
| 163011 | 223649 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1812 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008605.94683 | 2107884.16729 | 37.7683341961038 | -122.413524717993 | (37.7683341961038, -122.413524717993) | 8 | 4 | 7 | 28853 | 19 | |||
| 170272 | 31068 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1450 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007659.7746 | 2107385.50696 | 37.7669118184545 | -122.4167621155 | (37.7669118184545, -122.4167621155) | 8 | 4 | 7 | 28853 | 19 | |
| 176477 | 223434 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 335 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006140.81563 | 2107660.72515 | 37.7675819509849 | -122.422035512441 | (37.7675819509849, -122.422035512441) | 8 | 4 | 7 | 28853 | 19 | |||
| 176996 | 223650 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008607.48155 | 2107905.07917 | 37.7683917014338 | -122.413520888701 | (37.7683917014338, -122.413520888701) | 8 | 4 | 7 | 28853 | 19 | |||
| 177048 | 223597 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 306 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6007773.49389 | 2106023.20364 | 37.7631776462561 | -122.416272279958 | (37.7631776462561, -122.416272279958) | 8 | 4 | 7 | 28859 | 19 | |||
| 177393 | 223646 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3434 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006604.84709 | 2105555.01905 | 37.7618263375482 | -122.420281015175 | (37.7618263375482, -122.420281015175) | 8 | 4 | 7 | 28859 | 19 | |||
| 178045 | 223513 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3345 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006561.96009 | 2106094.72257 | 37.7633058203343 | -122.420467655081 | (37.7633058203343, -122.420467655081) | 8 | 4 | 7 | 28859 | 19 | |||
| 178775 | 42945 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 54 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42840 | 6007765.38854271 | 2106161.17113141 | 37.7635560172004 | -122.416310086241 | (37.7635560172004, -122.416310086241) | 8 | 4 | 7 | 28859 | 19 | ||
| 186859 | 236267 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 98X Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 775137 | 6007694.337 | 2107447.14933 | 37.7670830178903 | -122.41664693662 | (37.7670830178903, -122.41664693662) | 8 | 4 | 7 | 28853 | 19 | |
| 190274 | 223601 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 280x Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007724 | 2106220 | 37.7637152201621 | -122.416457403809 | (37.7637152201621, -122.416457403809) | 8 | 4 | 7 | 28859 | 19 | |||
| 191421 | 223375 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 12 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006422.52922 | 2105783.74221 | 37.7624440827408 | -122.42092782106 | (37.7624440827408, -122.42092782106) | 8 | 4 | 7 | 28859 | 19 | |||
| 1507 | 74233 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2400 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6010292.05063 | 2106000.69739 | 37.7632571481177 | -122.407559806245 | (37.7632571481177, -122.407559806245) | 8 | 4 | 8 | 28859 | 19 | |||
| 14213 | 74019 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2400 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 6010272.25282 | 2105997.87843 | 37.7632482996846 | -122.407628081878 | (37.7632482996846, -122.407628081878) | 8 | 4 | 8 | 28859 | 19 | ||
| 18151 | 72422 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2400 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 6010224.23312 | 2105998.24791 | 37.7632466260627 | -122.407794192953 | (37.7632466260627, -122.407794192953) | 8 | 4 | 8 | 28859 | 19 | ||
| 95986 | 189246 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2445 Mariposa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010268.3628 | 2105949.94091 | 37.7631164563708 | -122.407638156081 | (37.7631164563708, -122.407638156081) | 8 | 4 | 8 | 28859 | 19 | |||
| 124259 | 189245 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2445 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010120.66455 | 2105943.60701 | 37.7630907960193 | -122.408148550138 | (37.7630907960193, -122.408148550138) | 8 | 4 | 8 | 28859 | 19 | |||
| 1156 | 31893 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 8 | Permit Number 35323 | 6008432.94494 | 2108718.71395 | 37.7706159506067 | -122.414182168285 | (37.7706159506067, -122.414182168285) | 8 | 2 | 9 | 28853 | 19 | |
| 2430 | 224109 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006481.46308 | 2109309.64111 | 37.7721286885111 | -122.420974342101 | (37.7721286885111, -122.420974342101) | 8 | 2 | 9 | 28853 | 19 | |||
| 9156 | 73920 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6008409.30532 | 2108731.32076 | 37.7706492380987 | -122.414264830382 | (37.7706492380987, -122.414264830382) | 8 | 2 | 9 | 28853 | 19 | |||
| 9670 | 85554 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 360X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008520.7969 | 2108615.740864 | 37.7703381448181 | -122.413871001048 | (37.7703381448181, -122.413871001048) | 8 | 2 | 9 | 28853 | 19 | |||
| 14957 | 85546 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 250X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007915.610259 | 2108965.748791 | 37.7712651780879 | -122.415989137093 | (37.7712651780879, -122.415989137093) | 8 | 2 | 9 | 28853 | 19 | |||
| 15417 | 224105 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 35 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006280.26739 | 2109523.46395 | 37.7727044515829 | -122.421685485523 | (37.7727044515829, -122.421685485523) | 8 | 2 | 9 | 28853 | 19 | |||
| 15449 | 85521 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/2013 12:00:00 AM | 3 | 6008760.539184 | 2108527.457431 | 37.7701092002187 | -122.413035486584 | (37.7701092002187, -122.413035486584) | 8 | 2 | 9 | 28853 | 19 | |||
| 17998 | 85553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 332 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6008375 | 2108695 | 37.7705475827471 | -122.414380922989 | (37.7705475827471, -122.414380922989) | 8 | 2 | 9 | 28853 | 19 | |||
| 18144 | 70989 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | Permit Number 779764 | 6008399.52743 | 2108738.25581 | 37.770667730873 | -122.414299143103 | (37.770667730873, -122.414299143103) | 8 | 2 | 9 | 28853 | 19 | ||
| 21310 | 254733 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 398 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 3x3 | 6008656 | 2108503 | 37.7700361768699 | -122.413395357755 | (37.7700361768699, -122.413395357755) | 8 | 2 | 9 | 28853 | 19 | |||
| 32023 | 85527 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301X 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008215.27395 | 2108839.588309 | 37.7709356143391 | -122.414943653714 | (37.7709356143391, -122.414943653714) | 8 | 2 | 9 | 28853 | 19 | |||
| 42967 | 173911 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6006450.1 | 2109317.2 | 37.7721476754667 | -122.421083366581 | (37.7721476754667, -122.421083366581) | 8 | 2 | 9 | 28853 | 19 | ||||
| 43105 | 85526 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008215.27395 | 2108839.588309 | 37.7709356143391 | -122.414943653714 | (37.7709356143391, -122.414943653714) | 8 | 2 | 9 | 28853 | 19 | |||
| 46431 | 173910 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6006450.1 | 2109317.2 | 37.7721476754667 | -122.421083366581 | (37.7721476754667, -122.421083366581) | 8 | 2 | 9 | 28853 | 19 | ||||
| 51660 | 122788 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007172 | 2109097 | 37.7715837270561 | -122.418570631079 | (37.7715837270561, -122.418570631079) | 8 | 2 | 9 | 28853 | 19 | ||||
| 54350 | 90432 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 49X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006339.227867 | 2109481.166325 | 37.7725916370239 | -122.42147852996 | (37.7725916370239, -122.42147852996) | 8 | 2 | 9 | 28853 | 19 | ||
| 55451 | 256092 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 240 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6007860.62906 | 2108997.35701 | 37.7713488754693 | -122.416181558888 | (37.7713488754693, -122.416181558888) | 8 | 2 | 9 | 28853 | 19 | |||||
| 56042 | 100781 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 211 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6007785.14748 | 2109092.4486 | 37.7716057300517 | -122.416449390639 | (37.7716057300517, -122.416449390639) | 8 | 2 | 9 | 28853 | 19 | |||
| 56742 | 191077 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 334 12th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6008423.37153 | 2108669.51917 | 37.7704803355249 | -122.414211801833 | (37.7704803355249, -122.414211801833) | 8 | 2 | 9 | 28853 | 19 | |||
| 59073 | 90431 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 49X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770519 | 6006339.227867 | 2109481.166325 | 37.7725916370239 | -122.42147852996 | (37.7725916370239, -122.42147852996) | 8 | 2 | 9 | 28853 | 19 | |
| 61671 | 191072 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 396 12th St | 4 | : | Tree | Private 2 | 5 | Width 3ft | Permit Number 779704 | 6008614.31812 | 2108613.9778 | 37.7703385556015 | -122.413547385421 | (37.7703385556015, -122.413547385421) | 8 | 2 | 9 | 28853 | 19 | ||
| 62515 | 90438 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 48X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006368.067431 | 2109508.884182 | 37.7726693696552 | -122.421380739497 | (37.7726693696552, -122.421380739497) | 8 | 2 | 9 | 28853 | 19 | ||
| 63023 | 191073 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 352 12th St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6008306.80877 | 2108790.44152 | 37.7708058118746 | -122.41462355284 | (37.7708058118746, -122.41462355284) | 8 | 2 | 9 | 28853 | 19 | |||
| 64496 | 85535 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 5 | 6007364.04136 | 2109271.58584 | 37.7720739081089 | -122.41791872548 | (37.7720739081089, -122.41791872548) | 8 | 2 | 9 | 28853 | 19 | |||
| 65939 | 85545 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 240 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007812 | 2109019 | 37.7714055675706 | -122.416351302737 | (37.7714055675706, -122.416351302737) | 8 | 2 | 9 | 28853 | 19 | |||
| 66319 | 251315 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008830 | 2108632 | 37.7704001487298 | -122.41280261367 | (37.7704001487298, -122.41280261367) | 8 | 2 | 9 | 28853 | 19 | ||||
| 69970 | 191076 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 12th St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6008335.79472 | 2108708.57829 | 37.7705826631 | -122.414517495805 | (37.7705826631, -122.414517495805) | 8 | 2 | 9 | 28853 | 19 | |||
| 70118 | 85528 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 225X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007748.883838 | 2109107.739625 | 37.771645676205 | -122.416575912394 | (37.771645676205, -122.416575912394) | 8 | 2 | 9 | 28853 | 19 | |||
| 70902 | 85555 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 360X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008520.7969 | 2108615.740864 | 37.7703381448181 | -122.413871001048 | (37.7703381448181, -122.413871001048) | 8 | 2 | 9 | 28853 | 19 | |||
| 71150 | 191672 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 252 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007932.20387 | 2108945.73927 | 37.7712111695782 | -122.415930321737 | (37.7712111695782, -122.415930321737) | 8 | 2 | 9 | 28853 | 19 | |||
| 72439 | 246381 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6006946.7351 | 2109071.9998 | 37.7715023978524 | -122.419348063063 | (37.7715023978524, -122.419348063063) | 8 | 2 | 9 | 28853 | 19 | |||
| 73566 | 90435 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006637.011883 | 2109229.055885 | 37.7719161875872 | -122.420430563972 | (37.7719161875872, -122.420430563972) | 8 | 2 | 9 | 28853 | 19 | ||
| 76303 | 85538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 180 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6007511.05272 | 2109187.82256 | 37.7718521865557 | -122.417404262918 | (37.7718521865557, -122.417404262918) | 8 | 2 | 9 | 28853 | 19 | |||
| 80770 | 85540 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 180 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6007564 | 2109156 | 37.7717677882225 | -122.417218858728 | (37.7717677882225, -122.417218858728) | 8 | 2 | 9 | 28853 | 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) );