Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4880 | 4880 | 253705 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 98X Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | ||||||
| 4889 | 4889 | 253706 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 98X Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | ||||||
| 11880 | 11880 | 47474 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45375 | |||||||||
| 13904 | 13904 | 47479 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45375 | |||||||||
| 147834 | 147834 | 41577 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 715 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/2000 12:00:00 AM | 7 | Permit Number 42091 | 5981330.80652 | 2110844.76376 | 37.774893875261505 | -122.50808495995001 | (37.7748938752615, -122.50808495995) | ||
| 127724 | 127724 | 47821 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 649 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/11/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772575 | 5981934.18686 | 2111319.10123 | 37.7762318023646 | -122.506032952708 | (37.7762318023646, -122.506032952708) |
| 62140 | 62140 | 52647 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 850@ FULTON 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | 1 | Permit Number 774180 | 5982028.38924 | 2109948.2493 | 37.7724733883273 | -122.505605444469 | (37.7724733883273, -122.505605444469) | ||
| 106373 | 106373 | 51650 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 570 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47934 | 5982893.41884075 | 2111911.16830587 | 37.777913863653396 | -122.502758598437 | (37.7779138636534, -122.502758598437) | |||
| 112778 | 112778 | 49336 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2210& RIVERA 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2003 12:00:00 AM | Permit Number 46330 | 5982985.87424051 | 2100072.90742452 | 37.7454147931586 | -122.50156276721901 | (37.7454147931586, -122.501562767219) | |||
| 124259 | 124259 | 56711 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1659 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2015 12:00:00 AM | Permit Number 774226 | 5983116.27836009 | 2103843.81660781 | 37.7557763190096 | -122.501390749613 | (37.7557763190096, -122.501390749613) | |||
| 3083 | 3083 | 252820 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 2339 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/21/2017 12:00:00 AM | 3 | 3x3 | 5983590.30233 | 2099230.6863599997 | 37.743137766616 | -122.49941055724301 | (37.743137766616, -122.499410557243) | ||
| 165802 | 165802 | 63192 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 439 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/2001 12:00:00 AM | 7 | Permit Number 33572 | 5984052.00356 | 2112858.1902400004 | 37.78058213076871 | -122.49882069014099 | (37.7805821307687, -122.498820690141) | |
| 49805 | 49805 | 45669 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 815 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49963 | 5984453.94726 | 2110275.98244 | 37.7735156996405 | -122.497239525872 | (37.7735156996405, -122.497239525872) | |
| 116423 | 116423 | 69046 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3623 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 3 | Permit Number 33053 | 5984457.0554 | 2106305.4338 | 37.762613882253 | -122.496935660667 | (37.762613882253, -122.496935660667) | |
| 140692 | 140692 | 108155 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 875 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773852 | 5984778.38849 | 2109898.30957 | 37.772497726788 | -122.496089384061 | (37.772497726788, -122.496089384061) | |
| 101589 | 101589 | 21338 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2592X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
| 114416 | 114416 | 21341 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2592X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
| 139395 | 139395 | 21343 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2592X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
| 122239 | 122239 | 105434 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 49 | 4355 ANZA ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 5985110.8 | 2111730.2 | 37.7775470387472 | -122.495074662501 | (37.7775470387472, -122.495074662501) | ||||
| 34670 | 34670 | 185158 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2500 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5985178.5125 | 2097636.1993 | 37.7388527871834 | -122.49380155463699 | (37.7388527871834, -122.493801554637) | |||
| 75029 | 75029 | 181341 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2500 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985179.8406 | 2097655.4564 | 37.738905739718795 | -122.49379838145501 | (37.7389057397188, -122.493798381455) | |||
| 125058 | 125058 | 37241 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2839 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 3 | Permit Number 39798 | 5985223.35119541 | 2102931.47415001 | 37.753394797673295 | -122.494036683936 | (37.7533947976733, -122.494036683936) | |
| 33242 | 33242 | 182485 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1563 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5985266.5327 | 2104584.1284 | 37.7579350567147 | -122.494009145875 | (37.7579350567147, -122.494009145875) | |||
| 60285 | 60285 | 92546 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1534 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52889 | 5985305.6485 | 2104749.3445 | 37.7583909829975 | -122.493886044317 | (37.7583909829975, -122.493886044317) | |
| 53170 | 53170 | 37231 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1815 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | 5 | Permit Number 46003 | 5985330.0834 | 2102828.2693 | 37.7531176701023 | -122.493659982631 | (37.7531176701023, -122.493659982631) | |
| 161450 | 161450 | 118075 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 426 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5985334.5387699995 | 2112983.7129 | 37.781001920437795 | -122.494393110571 | (37.7810019204378, -122.494393110571) | |||
| 27090 | 27090 | 99644 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1795 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | Permit Number 768958 | 5985623.9251 | 2103105.496 | 37.7538960444293 | -122.49266425054701 | (37.7538960444293, -122.492664250547) | ||
| 181772 | 181772 | 99645 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1795 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 768958 | 5985624.4813 | 2103086.5856 | 37.7538441541808 | -122.49266093445699 | (37.7538441541808, -122.492660934457) | ||
| 177570 | 177570 | 99646 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1795 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | Permit Number 768958 | 5985627.2622 | 2103048.7649 | 37.7537404715173 | -122.492648532329 | (37.7537404715173, -122.492648532329) | ||
| 171837 | 171837 | 99647 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1795 34th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 768958 | 5985628.3746 | 2103030.4107 | 37.7536901409617 | -122.49264333378099 | (37.7536901409617, -122.492643333781) | ||
| 53569 | 53569 | 119433 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 715 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5985978.78842 | 2110984.8920299998 | 37.7755514115766 | -122.492017154699 | (37.7755514115766, -122.492017154699) | |||
| 59512 | 59512 | 104074 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 841 32nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/06/2013 12:00:00 AM | 2 | Permit Number 770392 | 5986000.25731 | 2110187.13166 | 37.7733622428275 | -122.491884144737 | (37.7733622428275, -122.491884144737) | ||
| 29538 | 29538 | 33172 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2311 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37388 | 5986066.5372792 | 2098877.4979138 | 37.742312976384504 | -122.490822533573 | (37.7423129763845, -122.490822533573) | |
| 177999 | 177999 | 182266 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1470 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986219.9712 | 2105233.6732 | 37.759774269018 | -122.490759591455 | (37.759774269018, -122.490759591455) | |||
| 89940 | 89940 | 92240 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1470 32nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 3x3 | Permit Number 52686 | 5986244.6 | 2105237.3 | 37.7597856659048 | -122.49067468059499 | (37.7597856659048, -122.490674680595) | |||
| 121354 | 121354 | 94125 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1478 32nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2010 12:00:00 AM | 3x3 | Permit Number 53485 | 5986246.3 | 2105188.0 | 37.75965040100729 | -122.490665173884 | (37.7596504010073, -122.490665173884) | |||
| 100934 | 100934 | 66338 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1447 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/1990 12:00:00 AM | Permit Number 29459 | 5986477.48679656 | 2105401.18553313 | 37.7602492515012 | -122.489881304154 | (37.7602492515012, -122.489881304154) | ||
| 90064 | 90064 | 66339 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1455 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/1990 12:00:00 AM | Permit Number 29460 | 5986479.28524168 | 2105348.90942055 | 37.7601058207136 | -122.489871239473 | (37.7601058207136, -122.489871239473) | ||
| 183046 | 183046 | 43598 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2320 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 3 | Permit Number 43256 | 5986732.527000001 | 2099427.1676 | 37.743861106273606 | -122.48856016571301 | (37.7438611062736, -122.488560165713) | |
| 11497 | 11497 | 69940 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1295 30th Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/06/2016 12:00:00 AM | 3 | 5x5 | Permit Number 778203 | 5986757.5345 | 2106473.3538 | 37.7632094781069 | -122.488991584645 | (37.7632094781069, -122.488991584645) | |
| 133612 | 133612 | 181738 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2803 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5986967.0668 | 2107072.067 | 37.7648656060734 | -122.488310893002 | (37.7648656060734, -122.488310893002) | |||
| 60578 | 60578 | 181735 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2801 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5986996.5941 | 2107070.8859 | 37.7648640858106 | -122.488208680173 | (37.7648640858106, -122.488208680173) | |||
| 183373 | 183373 | 38109 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1243 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 4 | Permit Number 40277 | 5987050.95818325 | 2106810.63919781 | 37.7641526918478 | -122.488001527428 | (37.7641526918478, -122.488001527428) | |
| 112199 | 112199 | 38112 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1296 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.48775523264901 | (37.763186144894, -122.487755232649) | ||
| 84514 | 84514 | 95936 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 706 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767632 | 5987288.3 | 2111108.8 | 37.7759680859814 | -122.487496400821 | (37.7759680859814, -122.487496400821) | |
| 53498 | 53498 | 119937 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2655 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5987300.155230001 | 2111149.41702 | 37.7760803002726 | -122.48745837531901 | (37.7760803002726, -122.487458375319) | |||
| 79493 | 79493 | 90998 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2545 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5987618.415159999 | 2111163.66443 | 37.7761379752311 | -122.486358489761 | (37.7761379752311, -122.486358489761) | ||
| 119396 | 119396 | 90221 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2550 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987624.2052 | 2111222.01926 | 37.7762985386745 | -122.486342745884 | (37.7762985386745, -122.486342745884) | ||
| 114816 | 114816 | 90999 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2539 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5987645.107000001 | 2111164.3334 | 37.776141367788206 | -122.486266205806 | (37.7761413677882, -122.486266205806) | ||
| 42596 | 42596 | 50218 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2536 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 2 | Permit Number 46925 | 5987649.93004 | 2111223.20837 | 37.776303303016796 | -122.48625384500099 | (37.7763033030168, -122.486253845001) | |
| 88308 | 88308 | 91000 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2533 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5987666.18452 | 2111163.5769599997 | 37.7761405192841 | -122.486193238376 | (37.7761405192841, -122.486193238376) | ||
| 51540 | 51540 | 38100 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1265 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 4 | Permit Number 40271 | 5987674.53427275 | 2106687.60559412 | 37.76385123223321 | -122.48583575429701 | (37.7638512322332, -122.485835754297) | |
| 99844 | 99844 | 90222 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2558 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987675.672489 | 2111213.7103279997 | 37.776278724402204 | -122.486164098471 | (37.7762787244022, -122.486164098471) | |
| 19026 | 19026 | 90220 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2500 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987751.08815 | 2111228.00123 | 37.7763223582458 | -122.48590426741801 | (37.7763223582458, -122.485904267418) | ||
| 108998 | 108998 | 90218 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2500X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987770.68096 | 2111227.58541 | 37.7763223582481 | -122.48583646078 | (37.7763223582481, -122.48583646078) | ||
| 141368 | 141368 | 91001 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2501 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5987771.13659 | 2111168.45411 | 37.7761600268515 | -122.485830543565 | (37.7761600268515, -122.485830543565) | ||
| 93975 | 93975 | 90217 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2500X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987787.70721 | 2111229.39293 | 37.7763283133255 | -122.485777695693 | (37.7763283133255, -122.485777695693) | ||
| 113629 | 113629 | 91002 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2501 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5987790.41931 | 2111170.8250700003 | 37.7761676604582 | -122.48576401432899 | (37.7761676604582, -122.485764014329) | ||
| 115670 | 115670 | 41592 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 829 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | Permit Number 42101 | 5987864.02178214 | 2110316.45521242 | 37.7738260885282 | -122.485446695956 | (37.7738260885282, -122.485446695956) | |||
| 113533 | 113533 | 90216 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2440 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987916.1754 | 2111227.96813 | 37.776331886234104 | -122.485333189524 | (37.7763318862341, -122.485333189524) | ||
| 4902 | 4902 | 91003 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2449 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/2016 12:00:00 AM | 3 | 3x3 | 5987916.77213 | 2111175.55765 | 37.776188016519605 | -122.48532727858999 | (37.7761880165196, -122.48532727859) | ||
| 77859 | 77859 | 90215 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2434 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987937.95416 | 2111227.93997 | 37.7763330776559 | -122.485257849615 | (37.7763330776559, -122.485257849615) | ||
| 122786 | 122786 | 90214 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2430 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5988003.75332 | 2111229.14654 | 37.7763402234557 | -122.485030323404 | (37.7763402234557, -122.485030323404) | ||
| 110810 | 110810 | 91004 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2421 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5988014.81063 | 2111176.25764 | 37.7761956494206 | -122.48498819241101 | (37.7761956494206, -122.484988192411) | ||
| 92611 | 92611 | 90213 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2416 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5988036.00914 | 2111230.19721 | 37.776344987089 | -122.484918820029 | (37.776344987089, -122.484918820029) | ||
| 125079 | 125079 | 91005 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2415 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5988054.23451 | 2111177.58374 | 37.776201586759 | -122.48485191350001 | (37.776201586759, -122.4848519135) | ||
| 4907 | 4907 | 91006 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2401X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/2016 12:00:00 AM | 3 | 3x3 | 5988072.26413 | 2111179.36369 | 37.7762075240837 | -122.48478967552099 | (37.7762075240837, -122.484789675521) | ||
| 84034 | 84034 | 91007 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2401X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5988091.7784 | 2111178.02295 | 37.7762049792996 | -122.484722072811 | (37.7762049792996, -122.484722072811) | ||
| 107378 | 107378 | 91008 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2401X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5988115.3822099995 | 2111179.37567 | 37.7762100681257 | -122.484640521069 | (37.7762100681257, -122.484640521069) | ||
| 24709 | 24709 | 182142 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1418 25th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 5988379.3786 | 2105646.1459999997 | 37.761032715479395 | -122.483321592218 | (37.7610327154794, -122.483321592218) | |||
| 48042 | 48042 | 88589 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 874 24th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51533 | 5988541.53724 | 2110053.24401 | 37.7731428326728 | -122.48308379276699 | (37.7731428326728, -122.483083792767) | ||
| 70246 | 70246 | 56379 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 191@ 23rd Ave 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2012 12:00:00 AM | 2 | Permit Number 769038 | 5988661.1856 | 2114079.0461 | 37.7842035193233 | -122.482965030995 | (37.7842035193233, -122.482965030995) | ||
| 124898 | 124898 | 120402 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 191 23rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5988664.0 | 2114068.0 | 37.7841733536199 | -122.48295448443399 | (37.7841733536199, -122.482954484434) | |||
| 188615 | 188615 | 61889 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1583 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/15/1985 12:00:00 AM | 10 | Permit Number 21932 | 5988683.0577 | 2104556.6784 | 37.75805900104321 | -122.48219149098301 | (37.7580590010432, -122.482191490983) | |
| 12037 | 12037 | 81450 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1651 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 6 | 3x3 | Permit Number 49732 | 5988700.7716 | 2104076.8415 | 37.7567425285058 | -122.482095077474 | (37.7567425285058, -122.482095077474) | |
| 128626 | 128626 | 63429 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 174 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/1987 12:00:00 AM | 1 | Permit Number 24014 | 5988702.91741 | 2114182.56462 | 37.7844901800735 | -122.482828244548 | (37.7844901800735, -122.482828244548) | ||
| 147207 | 147207 | 120492 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2101 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5989019.39617 | 2110533.53925 | 37.7744893859398 | -122.481466017661 | (37.7744893859398, -122.481466017661) | |||
| 186763 | 186763 | 120490 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2101 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5989039.20971 | 2110535.30773 | 37.7744953937056 | -122.481397609154 | (37.7744953937056, -122.481397609154) | |||
| 160823 | 160823 | 88392 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 318 22nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51370 | 5989049.86115 | 2113182.34537 | 37.7817640398692 | -122.481554671506 | (37.7817640398692, -122.481554671506) | ||
| 131635 | 131635 | 82192 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1682 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49856 | 5989061.047 | 2103886.9798 | 37.7562421670239 | -122.480835227785 | (37.7562421670239, -122.480835227785) | |
| 154882 | 154882 | 64884 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2550 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/1989 12:00:00 AM | 8 | Permit Number 25910 | 5989263.5772 | 2097984.1265 | 37.7400462586589 | -122.47970291667801 | (37.7400462586589, -122.479702916678) | |
| 155483 | 155483 | 38858 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1539 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 4 | Permit Number 40685 | 5989290.38339079 | 2104868.56062873 | 37.758950652235605 | -122.48011394820101 | (37.7589506522356, -122.480113948201) | |
| 158156 | 158156 | 38859 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1543 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 4 | Permit Number 40686 | 5989291.28049712 | 2104842.48405606 | 37.7588791051043 | -122.480108937189 | (37.7588791051043, -122.480108937189) | |
| 76545 | 76545 | 38861 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1550 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 4 | Permit Number 40688 | 5989338.7682 | 2104794.6769999997 | 37.75875059888261 | -122.479941205975 | (37.7587505988826, -122.479941205975) | |
| 186782 | 186782 | 38856 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1530 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 3 | Permit Number 40683 | 5989340.55843436 | 2104922.50162386 | 37.7591016749524 | -122.479944368724 | (37.7591016749524, -122.479944368724) | |
| 187222 | 187222 | 51407 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1554 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | 5 | Permit Number 47732 | 5989341.6825 | 2104766.5057 | 37.7586734173793 | -122.479929065557 | (37.7586734173793, -122.479929065557) | |
| 162249 | 162249 | 51408 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1554 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | 4 | Permit Number 47732 | 5989342.6539 | 2104753.8772 | 37.758638799348 | -122.47992478191401 | (37.758638799348, -122.479924781914) | |
| 142352 | 142352 | 90322 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1949X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989457.99472 | 2111233.88007 | 37.7764378199226 | -122.48000010099399 | (37.7764378199226, -122.480000100994) | ||
| 140630 | 140630 | 90323 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1949 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989481.72771 | 2111237.09883 | 37.7764480366161 | -122.47991823839399 | (37.7764480366161, -122.479918238394) | ||
| 89828 | 89828 | 90324 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1949 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989502.24352 | 2111235.4245 | 37.7764446312789 | -122.479847146645 | (37.7764446312789, -122.479847146645) | ||
| 162446 | 162446 | 120821 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 20th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5989570.27097 | 2114621.23399 | 37.785745070127504 | -122.47985964308799 | (37.7857450701275, -122.479859643088) | |||
| 175182 | 175182 | 120820 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 20th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5989571.70093 | 2114608.1795799998 | 37.785709309470796 | -122.47985374027 | (37.7857093094708, -122.47985374027) | |||
| 84862 | 84862 | 90325 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1921 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989582.35832 | 2111234.7631 | 37.7764474692851 | -122.47956996156601 | (37.7764474692851, -122.479569961566) | ||
| 116245 | 116245 | 41374 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2918 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2000 12:00:00 AM | Permit Number 42011 | 5989628.92991844 | 2111970.3143396 | 37.7784697940849 | -122.47946268595699 | (37.7784697940849, -122.479462685957) | |||
| 162795 | 162795 | 51750 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 355 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2005 12:00:00 AM | 6 | Permit Number 48020 | 5989629.76736 | 2112987.41168 | 37.7812625086441 | -122.47953422389999 | (37.7812625086441, -122.4795342239) | ||
| 34308 | 34308 | 90326 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1901X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989640.77384 | 2111238.69513 | 37.77646165861329 | -122.479368175716 | (37.7764616586133, -122.479368175716) | ||
| 100091 | 100091 | 90327 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1901X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989656.13714 | 2111238.78364 | 37.7764627939564 | -122.479315036767 | (37.7764627939564, -122.479315036767) | ||
| 169465 | 169465 | 94326 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 354 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53626 | 5989679.6833 | 2112963.89728 | 37.7812008439985 | -122.479359820471 | (37.7812008439985, -122.479359820471) | |
| 173885 | 173885 | 81459 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1119 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49734 | 5989696.8991 | 2098996.9987 | 37.7428525058761 | -122.47827872443001 | (37.7428525058761, -122.47827872443) | |
| 91661 | 91661 | 82191 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1995 21st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 3x3 | Permit Number 49854 | 5989705.78063845 | 2101796.33096673 | 37.7505392542177 | -122.478452670316 | (37.7505392542177, -122.478452670316) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");