trees
2,421 rows where qSpecies_id = 8 sorted by Longitude descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21637 | 41577 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 715 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2000 12:00:00 AM | 7 | Permit Number 42091 | 5981330.80652 | 2110844.76376 | 37.7748938752615 | -122.50808495995 | (37.7748938752615, -122.50808495995) | 11 | 6 | 2 | 55 | 26 | ||
| 9151 | 110107 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4130 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2016 12:00:00 AM | 15 | 3x3 | Permit Number 774958 | 5981430 | 2103553 | 37.7548786426579 | -122.507200765499 | (37.7548786426579, -122.507200765499) | 1 | 8 | 3 | 56 | 35 |
| 188433 | 47821 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 649 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/11/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772575 | 5981934.18686 | 2111319.10123 | 37.7762318023646 | -122.506032952708 | (37.7762318023646, -122.506032952708) | 11 | 6 | 2 | 55 | 26 |
| 87734 | 52647 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 850@ FULTON 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | 1 | Permit Number 774180 | 5982028.38924 | 2109948.2493 | 37.7724733883273 | -122.505605444469 | (37.7724733883273, -122.505605444469) | 11 | 6 | 2 | 55 | 26 | ||
| 8247 | 261144 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1223 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 11:14:00 AM | 3 | 5982369 | 2106763 | 37.7637476520641 | -122.504191265784 | (37.7637476520641, -122.504191265784) | 1 | 8 | 3 | 56 | 35 | ||
| 14607 | 144226 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 786 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:53:00 PM | 0 | Width 4ft | 5982632.5127 | 2110441.98121 | 37.7738645680338 | -122.503552325389 | (37.7738645680338, -122.503552325389) | 11 | 6 | 2 | 55 | 26 | ||
| 126095 | 51650 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 570 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47934 | 5982893.41884075 | 2111911.16830587 | 37.7779138636534 | -122.502758598437 | (37.7779138636534, -122.502758598437) | 11 | 6 | 2 | 55 | 26 | |||
| 12028 | 261519 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 658 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:20:00 PM | Width 4ft | 5982910.9702 | 2111318.38005 | 37.7762872714849 | -122.502653994406 | (37.7762872714849, -122.502653994406) | 11 | 6 | 2 | 55 | 26 | |||
| 138243 | 49336 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2210& RIVERA 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2003 12:00:00 AM | Permit Number 46330 | 5982985.87424051 | 2100072.90742452 | 37.7454147931586 | -122.501562767219 | (37.7454147931586, -122.501562767219) | 1 | 8 | 3 | 29491 | 35 | |||
| 28303 | 56711 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1659 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2015 12:00:00 AM | Permit Number 774226 | 5983116.27836009 | 2103843.81660781 | 37.7557763190096 | -122.501390749613 | (37.7557763190096, -122.501390749613) | 1 | 8 | 3 | 56 | 35 | |||
| 64249 | 252820 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 2339 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2017 12:00:00 AM | 3 | 3x3 | 5983590.30233 | 2099230.68636 | 37.743137766616 | -122.499410557243 | (37.743137766616, -122.499410557243) | 1 | 8 | 3 | 29491 | 35 | ||
| 3799 | 63192 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 439 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | 7 | Permit Number 33572 | 5984052.00356 | 2112858.19024 | 37.7805821307687 | -122.498820690141 | (37.7805821307687, -122.498820690141) | 11 | 6 | 2 | 55 | 26 | |
| 67793 | 45669 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 815 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49963 | 5984453.94726 | 2110275.98244 | 37.7735156996405 | -122.497239525872 | (37.7735156996405, -122.497239525872) | 11 | 6 | 2 | 55 | 26 | |
| 3623 | 69046 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3623 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 3 | Permit Number 33053 | 5984457.0554 | 2106305.4338 | 37.762613882253 | -122.496935660667 | (37.762613882253, -122.496935660667) | 1 | 8 | 3 | 56 | 35 | |
| 37832 | 108155 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 875 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773852 | 5984778.38849 | 2109898.30957 | 37.772497726788 | -122.496089384061 | (37.772497726788, -122.496089384061) | 11 | 6 | 2 | 55 | 26 | |
| 156485 | 105434 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 8 | 4355 ANZA ST | 1 | Back Yard : Yard | Tree | Private 2 | 10 | 5985110.8 | 2111730.2 | 37.7775470387472 | -122.495074662501 | (37.7775470387472, -122.495074662501) | 11 | 6 | 2 | 55 | 26 | ||||
| 182736 | 118075 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 426 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5985334.53877 | 2112983.7129 | 37.7810019204378 | -122.494393110571 | (37.7810019204378, -122.494393110571) | 11 | 6 | 2 | 55 | 26 | |||
| 100690 | 21338 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2592X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
| 148862 | 21341 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2592X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
| 183538 | 21343 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2592X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
| 167817 | 37241 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2839 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 3 | Permit Number 39798 | 5985223.35119541 | 2102931.47415001 | 37.7533947976733 | -122.494036683936 | (37.7533947976733, -122.494036683936) | 1 | 8 | 3 | 56 | 35 | |
| 111369 | 182485 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1563 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985266.5327 | 2104584.1284 | 37.7579350567147 | -122.494009145875 | (37.7579350567147, -122.494009145875) | 1 | 8 | 3 | 56 | 35 | |||
| 97678 | 92546 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1534 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52889 | 5985305.6485 | 2104749.3445 | 37.7583909829975 | -122.493886044317 | (37.7583909829975, -122.493886044317) | 1 | 8 | 3 | 56 | 35 | |
| 25131 | 185158 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5985178.5125 | 2097636.1993 | 37.7388527871834 | -122.493801554637 | (37.7388527871834, -122.493801554637) | 1 | 8 | 3 | 29491 | 35 | |||
| 150648 | 181341 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985179.8406 | 2097655.4564 | 37.7389057397188 | -122.493798381455 | (37.7389057397188, -122.493798381455) | 1 | 8 | 3 | 29491 | 35 | |||
| 119407 | 37231 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1815 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | 5 | Permit Number 46003 | 5985330.0834 | 2102828.2693 | 37.7531176701023 | -122.493659982631 | (37.7531176701023, -122.493659982631) | 1 | 8 | 3 | 56 | 35 | |
| 11695 | 32589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1286 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 10/22/1996 12:00:00 AM | 4 | Permit Number 37058 | 5985555.6068 | 2106469.8118 | 37.7631295295897 | -122.493148331917 | (37.7631295295897, -122.493148331917) | 1 | 8 | 3 | 56 | 35 | |
| 115355 | 99644 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1795 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | Permit Number 768958 | 5985623.9251 | 2103105.496 | 37.7538960444293 | -122.492664250547 | (37.7538960444293, -122.492664250547) | 1 | 8 | 3 | 56 | 35 | ||
| 169630 | 99645 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1795 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 768958 | 5985624.4813 | 2103086.5856 | 37.7538441541808 | -122.492660934457 | (37.7538441541808, -122.492660934457) | 1 | 8 | 3 | 56 | 35 | ||
| 53297 | 99646 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1795 34th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 768958 | 5985627.2622 | 2103048.7649 | 37.7537404715173 | -122.492648532329 | (37.7537404715173, -122.492648532329) | 1 | 8 | 3 | 56 | 35 | ||
| 113891 | 99647 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1795 34th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 768958 | 5985628.3746 | 2103030.4107 | 37.7536901409617 | -122.492643333781 | (37.7536901409617, -122.492643333781) | 1 | 8 | 3 | 56 | 35 | ||
| 76174 | 104074 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 841 32nd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/06/2013 12:00:00 AM | 2 | Permit Number 770392 | 5986000.25731 | 2110187.13166 | 37.7733622428275 | -122.491884144737 | (37.7733622428275, -122.491884144737) | 11 | 6 | 2 | 55 | 26 | ||
| 83029 | 33172 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2311 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 9 | Permit Number 37388 | 5986066.5372792 | 2098877.4979138 | 37.7423129763845 | -122.490822533573 | (37.7423129763845, -122.490822533573) | 1 | 8 | 3 | 29491 | 35 | |
| 61104 | 182266 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1470 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986219.9712 | 2105233.6732 | 37.759774269018 | -122.490759591455 | (37.759774269018, -122.490759591455) | 1 | 8 | 3 | 56 | 35 | |||
| 61559 | 92240 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1470 32nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 3x3 | Permit Number 52686 | 5986244.6 | 2105237.3 | 37.7597856659048 | -122.490674680595 | (37.7597856659048, -122.490674680595) | 1 | 8 | 3 | 56 | 35 | |||
| 158740 | 94125 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1478 32nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2010 12:00:00 AM | 3x3 | Permit Number 53485 | 5986246.3 | 2105188 | 37.7596504010073 | -122.490665173884 | (37.7596504010073, -122.490665173884) | 1 | 8 | 3 | 56 | 35 | |||
| 104971 | 66338 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1447 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/1990 12:00:00 AM | Permit Number 29459 | 5986477.48679656 | 2105401.18553313 | 37.7602492515012 | -122.489881304154 | (37.7602492515012, -122.489881304154) | 1 | 8 | 3 | 56 | 35 | ||
| 59529 | 66339 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1455 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/1990 12:00:00 AM | Permit Number 29460 | 5986479.28524168 | 2105348.90942055 | 37.7601058207136 | -122.489871239473 | (37.7601058207136, -122.489871239473) | 1 | 8 | 3 | 56 | 35 | ||
| 27076 | 69940 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1295 30th Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 05/06/2016 12:00:00 AM | 3 | 5x5 | Permit Number 778203 | 5986757.5345 | 2106473.3538 | 37.7632094781069 | -122.488991584645 | (37.7632094781069, -122.488991584645) | 1 | 8 | 3 | 56 | 35 | |
| 180570 | 254755 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3044 Ulloa St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778626 | 5986607.78234 | 2098260.29291 | 37.7406498995894 | -122.488905737407 | (37.7406498995894, -122.488905737407) | 1 | 8 | 3 | 29491 | 35 | ||
| 181544 | 43598 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2320 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | 3 | Permit Number 43256 | 5986732.527 | 2099427.1676 | 37.7438611062736 | -122.488560165713 | (37.7438611062736, -122.488560165713) | 1 | 8 | 3 | 29491 | 35 | |
| 109418 | 181738 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 2803 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5986967.0668 | 2107072.067 | 37.7648656060734 | -122.488310893002 | (37.7648656060734, -122.488310893002) | 1 | 8 | 3 | 56 | 35 | |||
| 169053 | 181735 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2801X Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5986996.5941 | 2107070.8859 | 37.7648640858106 | -122.488208680173 | (37.7648640858106, -122.488208680173) | 1 | 8 | 3 | 56 | 35 | |||
| 106925 | 38109 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1243 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 4 | Permit Number 40277 | 5987050.95818325 | 2106810.63919781 | 37.7641526918478 | -122.488001527428 | (37.7641526918478, -122.488001527428) | 1 | 8 | 3 | 56 | 35 | |
| 133392 | 38112 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1296 29th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.487755232649 | (37.763186144894, -122.487755232649) | 1 | 8 | 3 | 56 | 35 | ||
| 8256 | 144400 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 622 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 5987240.24391 | 2111690.94043 | 37.7775636765575 | -122.487705414786 | (37.7775636765575, -122.487705414786) | 11 | 6 | 2 | 55 | 26 | |||
| 54973 | 95936 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 706 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767632 | 5987288.3 | 2111108.8 | 37.7759680859814 | -122.487496400821 | (37.7759680859814, -122.487496400821) | 11 | 6 | 2 | 55 | 26 | |
| 73262 | 119937 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2655 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5987300.15523 | 2111149.41702 | 37.7760803002726 | -122.487458375319 | (37.7760803002726, -122.487458375319) | 11 | 6 | 2 | 55 | 26 | |||
| 41009 | 144432 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 774 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | Width 3ft | 5987587.51741 | 2110684.06235 | 37.7748193215988 | -122.486430151825 | (37.7748193215988, -122.486430151825) | 11 | 6 | 2 | 55 | 26 | ||
| 51629 | 90998 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2545 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5987618.41516 | 2111163.66443 | 37.7761379752311 | -122.486358489761 | (37.7761379752311, -122.486358489761) | 11 | 6 | 2 | 55 | 26 | ||
| 169765 | 90221 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2550 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987624.2052 | 2111222.01926 | 37.7762985386745 | -122.486342745884 | (37.7762985386745, -122.486342745884) | 11 | 6 | 2 | 55 | 26 | ||
| 143934 | 90999 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2539 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5987645.107 | 2111164.3334 | 37.7761413677882 | -122.486266205806 | (37.7761413677882, -122.486266205806) | 11 | 6 | 2 | 55 | 26 | ||
| 188581 | 50218 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2536 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/2003 12:00:00 AM | 2 | Permit Number 46925 | 5987649.93004 | 2111223.20837 | 37.7763033030168 | -122.486253845001 | (37.7763033030168, -122.486253845001) | 11 | 6 | 2 | 55 | 26 | |
| 72450 | 91000 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2533 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5987666.18452 | 2111163.57696 | 37.7761405192841 | -122.486193238376 | (37.7761405192841, -122.486193238376) | 11 | 6 | 2 | 55 | 26 | ||
| 98313 | 90222 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2558 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987675.672489 | 2111213.710328 | 37.7762787244022 | -122.486164098471 | (37.7762787244022, -122.486164098471) | 11 | 6 | 2 | 55 | 26 | |
| 6040 | 90220 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987751.08815 | 2111228.00123 | 37.7763223582458 | -122.485904267418 | (37.7763223582458, -122.485904267418) | 11 | 6 | 2 | 55 | 26 | ||
| 132823 | 90218 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987770.68096 | 2111227.58541 | 37.7763223582481 | -122.48583646078 | (37.7763223582481, -122.48583646078) | 11 | 6 | 2 | 55 | 26 | ||
| 105897 | 38100 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1265 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 4 | Permit Number 40271 | 5987674.53427275 | 2106687.60559412 | 37.7638512322332 | -122.485835754297 | (37.7638512322332, -122.485835754297) | 1 | 8 | 3 | 56 | 35 | |
| 188285 | 91001 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2501 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5987771.13659 | 2111168.45411 | 37.7761600268515 | -122.485830543565 | (37.7761600268515, -122.485830543565) | 11 | 6 | 2 | 55 | 26 | ||
| 84497 | 90217 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987787.70721 | 2111229.39293 | 37.7763283133255 | -122.485777695693 | (37.7763283133255, -122.485777695693) | 11 | 6 | 2 | 55 | 26 | ||
| 137429 | 91002 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2501 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5987790.41931 | 2111170.82507 | 37.7761676604582 | -122.485764014329 | (37.7761676604582, -122.485764014329) | 11 | 6 | 2 | 55 | 26 | ||
| 134127 | 41592 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 829 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42101 | 5987864.02178214 | 2110316.45521242 | 37.7738260885282 | -122.485446695956 | (37.7738260885282, -122.485446695956) | 11 | 6 | 2 | 55 | 26 | |||
| 15652 | 147295 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 859 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5987874.57425 | 2110110.67904 | 37.7732616993961 | -122.485395090629 | (37.7732616993961, -122.485395090629) | 11 | 6 | 2 | 55 | 26 | |||
| 151288 | 90216 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2440 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987916.1754 | 2111227.96813 | 37.7763318862341 | -122.485333189524 | (37.7763318862341, -122.485333189524) | 11 | 6 | 2 | 55 | 26 | ||
| 75156 | 91003 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2449 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x3 | 5987916.77213 | 2111175.55765 | 37.7761880165196 | -122.48532727859 | (37.7761880165196, -122.48532727859) | 11 | 6 | 2 | 55 | 26 | ||
| 30286 | 90215 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2434 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987937.95416 | 2111227.93997 | 37.7763330776559 | -122.485257849615 | (37.7763330776559, -122.485257849615) | 11 | 6 | 2 | 55 | 26 | ||
| 162356 | 90214 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2430 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5988003.75332 | 2111229.14654 | 37.7763402234557 | -122.485030323404 | (37.7763402234557, -122.485030323404) | 11 | 6 | 2 | 55 | 26 | ||
| 148298 | 91004 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2421 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5988014.81063 | 2111176.25764 | 37.7761956494206 | -122.484988192411 | (37.7761956494206, -122.484988192411) | 11 | 6 | 2 | 55 | 26 | ||
| 93907 | 90213 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2416 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5988036.00914 | 2111230.19721 | 37.776344987089 | -122.484918820029 | (37.776344987089, -122.484918820029) | 11 | 6 | 2 | 55 | 26 | ||
| 28197 | 91005 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2415 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5988054.23451 | 2111177.58374 | 37.776201586759 | -122.4848519135 | (37.776201586759, -122.4848519135) | 11 | 6 | 2 | 55 | 26 | ||
| 1304 | 91006 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2401X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x3 | 5988072.26413 | 2111179.36369 | 37.7762075240837 | -122.484789675521 | (37.7762075240837, -122.484789675521) | 11 | 6 | 2 | 55 | 26 | ||
| 39752 | 91007 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2401X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5988091.7784 | 2111178.02295 | 37.7762049792996 | -122.484722072811 | (37.7762049792996, -122.484722072811) | 11 | 6 | 2 | 55 | 26 | ||
| 124341 | 91008 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2401X Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5988115.38221 | 2111179.37567 | 37.7762100681257 | -122.484640521069 | (37.7762100681257, -122.484640521069) | 11 | 6 | 2 | 55 | 26 | ||
| 23082 | 96956 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2302 Cabrillo St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 782304 | 5988378.9117 | 2110569.83713 | 37.7745517889402 | -122.483684211452 | (37.7745517889402, -122.483684211452) | 11 | 6 | 2 | 55 | 26 | ||
| 100181 | 96955 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2302 Cabrillo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 782304 | 5988393.30434 | 2110570.14181 | 37.7745534632722 | -122.48363444745 | (37.7745534632722, -122.48363444745) | 11 | 6 | 2 | 55 | 26 | ||
| 77925 | 96954 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2302 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 782304 | 5988405.5552 | 2110570.49163 | 37.7745551368609 | -122.4835920955 | (37.7745551368609, -122.4835920955) | 11 | 6 | 2 | 55 | 26 | ||
| 182626 | 96953 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2302 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 782304 | 5988418.13148 | 2110571.74898 | 37.7745593211999 | -122.483548684419 | (37.7745593211999, -122.483548684419) | 11 | 6 | 2 | 55 | 26 | ||
| 23880 | 96952 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2302 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782532 | 5988431.28084 | 2110571.1656 | 37.7745584847462 | -122.483503155986 | (37.7745584847462, -122.483503155986) | 11 | 6 | 2 | 55 | 26 | |
| 95379 | 68962 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2302 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/08/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782532 | 5988444.16962 | 2110572.72123 | 37.7745635062345 | -122.483458685783 | (37.7745635062345, -122.483458685783) | 11 | 6 | 2 | 55 | 26 |
| 147442 | 182142 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1418 25th Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 0ft | 5988379.3786 | 2105646.146 | 37.7610327154794 | -122.483321592218 | (37.7610327154794, -122.483321592218) | 1 | 8 | 3 | 56 | 35 | |||
| 187900 | 88589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 874 24th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51533 | 5988541.53724 | 2110053.24401 | 37.7731428326728 | -122.483083792767 | (37.7731428326728, -122.483083792767) | 11 | 6 | 2 | 55 | 26 | ||
| 91856 | 56379 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 191@ 23rd Ave 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2012 12:00:00 AM | 2 | Permit Number 769038 | 5988661.1856 | 2114079.0461 | 37.7842035193233 | -122.482965030995 | (37.7842035193233, -122.482965030995) | 11 | 6 | 2 | 55 | 26 | ||
| 68724 | 120402 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 191 23rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5988664 | 2114068 | 37.7841733536199 | -122.482954484434 | (37.7841733536199, -122.482954484434) | 11 | 6 | 2 | 55 | 26 | |||
| 60242 | 63429 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 174 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/1987 12:00:00 AM | 1 | Permit Number 24014 | 5988702.91741 | 2114182.56462 | 37.7844901800735 | -122.482828244548 | (37.7844901800735, -122.482828244548) | 11 | 6 | 2 | 55 | 26 | ||
| 6422 | 260907 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2125 Lake St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5988893.20555 | 2114661.62902 | 37.7858166251674 | -122.482205030291 | (37.7858166251674, -122.482205030291) | 11 | 6 | 2 | 55 | 26 | |||
| 48236 | 61889 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1583 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/15/1985 12:00:00 AM | 10 | Permit Number 21932 | 5988683.0577 | 2104556.6784 | 37.7580590010432 | -122.482191490983 | (37.7580590010432, -122.482191490983) | 1 | 8 | 3 | 56 | 35 | |
| 143733 | 81450 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1651 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 6 | 3x3 | Permit Number 49732 | 5988700.7716 | 2104076.8415 | 37.7567425285058 | -122.482095077474 | (37.7567425285058, -122.482095077474) | 1 | 8 | 3 | 56 | 35 | |
| 157804 | 88392 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 318 22nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51370 | 5989049.86115 | 2113182.34537 | 37.7817640398692 | -122.481554671506 | (37.7817640398692, -122.481554671506) | 11 | 6 | 2 | 55 | 26 | ||
| 20721 | 120492 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2101 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5989019.39617 | 2110533.53925 | 37.7744893859398 | -122.481466017661 | (37.7744893859398, -122.481466017661) | 11 | 6 | 2 | 55 | 26 | |||
| 71479 | 120490 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2101 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5989039.20971 | 2110535.30773 | 37.7744953937056 | -122.481397609154 | (37.7744953937056, -122.481397609154) | 11 | 6 | 2 | 55 | 26 | |||
| 98116 | 82192 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1682 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49856 | 5989061.047 | 2103886.9798 | 37.7562421670239 | -122.480835227785 | (37.7562421670239, -122.480835227785) | 1 | 8 | 3 | 56 | 35 | |
| 159603 | 38858 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1539 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 4 | Permit Number 40685 | 5989290.38339079 | 2104868.56062873 | 37.7589506522356 | -122.480113948201 | (37.7589506522356, -122.480113948201) | 1 | 8 | 3 | 56 | 35 | |
| 162000 | 38859 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1543 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 4 | Permit Number 40686 | 5989291.28049712 | 2104842.48405606 | 37.7588791051043 | -122.480108937189 | (37.7588791051043, -122.480108937189) | 1 | 8 | 3 | 56 | 35 | |
| 186285 | 90322 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1949X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989457.99472 | 2111233.88007 | 37.7764378199226 | -122.480000100994 | (37.7764378199226, -122.480000100994) | 11 | 6 | 2 | 55 | 26 | ||
| 148596 | 38856 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1530 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 3 | Permit Number 40683 | 5989340.55843436 | 2104922.50162386 | 37.7591016749524 | -122.479944368724 | (37.7591016749524, -122.479944368724) | 1 | 8 | 3 | 56 | 35 | |
| 39889 | 38861 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1550 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 4 | Permit Number 40688 | 5989338.7682 | 2104794.677 | 37.7587505988826 | -122.479941205975 | (37.7587505988826, -122.479941205975) | 1 | 8 | 3 | 56 | 35 | |
| 96490 | 51407 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1554 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | 5 | Permit Number 47732 | 5989341.6825 | 2104766.5057 | 37.7586734173793 | -122.479929065557 | (37.7586734173793, -122.479929065557) | 1 | 8 | 3 | 56 | 35 | |
| 63633 | 51408 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1554 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | 4 | Permit Number 47732 | 5989342.6539 | 2104753.8772 | 37.758638799348 | -122.479924781914 | (37.758638799348, -122.479924781914) | 1 | 8 | 3 | 56 | 35 | |
| 181705 | 90323 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1949 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989481.72771 | 2111237.09883 | 37.7764480366161 | -122.479918238394 | (37.7764480366161, -122.479918238394) | 11 | 6 | 2 | 55 | 26 | ||
| 158104 | 120821 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 20th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5989570.27097 | 2114621.23399 | 37.7857450701275 | -122.479859643088 | (37.7857450701275, -122.479859643088) | 11 | 6 | 2 | 55 | 26 |
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) );