Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4728 | 4728 | 160846 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 669 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2017 12:20:00 PM | 3 | Width 0ft | 6002781.71244 | 2089588.8302099998 | 37.717770702526295 | -122.432363340291 | (37.7177707025263, -122.432363340291) | |
| 4750 | 4750 | 160919 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 656 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 11:14:00 AM | 3 | Width 0ft | 6002115.87134 | 2090131.5374900002 | 37.719223077968294 | -122.43470363886001 | (37.7192230779683, -122.43470363886) | |
| 4754 | 4754 | 160918 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 650 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 11:50:00 AM | 3 | Width 0ft | 6002126.85051 | 2090151.3483900002 | 37.7192780975889 | -122.43466710393 | (37.7192780975889, -122.43466710393) | |
| 4761 | 4761 | 160908 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 615 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:06:00 PM | 3 | Width 0ft | 6002284.55838 | 2090317.50092 | 37.7197432674186 | -122.434133839205 | (37.7197432674186, -122.434133839205) | |
| 4770 | 4770 | 160917 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 646 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 11:31:00 AM | 3 | Width 0ft | 6002146.555269999 | 2090180.2898900001 | 37.719358683138 | -122.434601060409 | (37.719358683138, -122.434601060409) | |
| 4873 | 4873 | 243284 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 1450 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007678.08789 | 2107386.86578 | 37.766916579475 | -122.416698868869 | (37.766916579475, -122.416698868869) | |
| 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 | ||||||
| 4887 | 4887 | 236267 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 98X Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 775137 | 6007694.337 | 2107447.14933 | 37.76708301789029 | -122.41664693661998 | (37.7670830178903, -122.41664693662) | |
| 4888 | 4888 | 151878 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 1450 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007623.77597 | 2107385.0882099997 | 37.7669086438472 | -122.41688659964599 | (37.7669086438472, -122.416886599646) | |
| 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 | ||||||
| 4900 | 4900 | 31068 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 1450 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | 6007659.7746 | 2107385.50696 | 37.7669118184545 | -122.41676211549999 | (37.7669118184545, -122.4167621155) | |
| 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) | ||
| 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) | ||
| 5103 | 5103 | 253796 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Scotia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2017 12:00:00 AM | 3 | Permit Number 779938 | 6011980.63004 | 2095004.60122 | 37.733158617067296 | -122.40094689916799 | (37.7331586170673, -122.400946899168) | ||
| 5159 | 5159 | 242086 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4185 25th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002948.22198 | 2101215.85126 | 37.7497052929799 | -122.432617857444 | (37.7497052929799, -122.432617857444) | |||
| 6712 | 6712 | 55965 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2740 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 18 | 5x5 | Permit Number 773535 | 6006142.142580001 | 2120235.85685 | 37.8021102410536 | -122.422924771976 | (37.8021102410536, -122.422924771976) | |
| 6880 | 6880 | 18913 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2612 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002139.88643 | 2115759.87525 | 37.789593716919704 | -122.43645393002599 | (37.7895937169197, -122.436453930026) | |||
| 7076 | 7076 | 66494 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2454 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2014 12:00:00 AM | 3 | Permit Number 29655 | 6001767.8317 | 2114666.7908 | 37.7865712397422 | -122.437662882365 | (37.7865712397422, -122.437662882365) | |
| 7482 | 7482 | 115876 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1880 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | Permit Number 775798 | 6005184.1768 | 2117160.91115 | 37.793613123488996 | -122.426020771756 | (37.793613123489, -122.426020771756) | ||
| 7638 | 7638 | 52428 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1809X Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48544 | 6004799.3483 | 2115577.2997 | 37.7892431693813 | -122.427239454587 | (37.7892431693813, -122.427239454587) |
| 8142 | 8142 | 14641 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 600X McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1998 12:00:00 AM | 8 | 4x4 | 6006147.64251 | 2112148.2738 | 37.77990406506721 | -122.422330778736 | (37.7799040650672, -122.422330778736) | ||
| 9003 | 9003 | 33126 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2527 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774205 | 6000811.7731800005 | 2118925.97012 | 37.7982114272598 | -122.44127631424601 | (37.7982114272598, -122.441276314246) | |
| 9052 | 9052 | 90537 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 508 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5994022.026869999 | 2110770.5827599997 | 37.7754298449829 | -122.464178302965 | (37.7754298449829, -122.464178302965) | ||
| 9137 | 9137 | 7679 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 299X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 18 | 3x3 | 5994818.31491 | 2110743.00765 | 37.7753999939995 | -122.461421774878 | (37.7753999939995, -122.461421774878) | ||
| 9174 | 9174 | 6373 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2101 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000795.1374 | 2112740.1737 | 37.7812258903975 | -122.440889897719 | (37.7812258903975, -122.440889897719) | |||
| 9205 | 9205 | 90538 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 508 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2008 12:00:00 AM | 4 | 3x3 | 5993999.75681 | 2110771.22635 | 37.7754303285192 | -122.464255386494 | (37.7754303285192, -122.464255386494) | ||
| 9216 | 9216 | 90536 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 508 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5994042.40763 | 2110772.62043 | 37.775436614532204 | -122.46410794960899 | (37.7754366145322, -122.464107949609) | ||
| 9453 | 9453 | 90543 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 642 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2008 12:00:00 AM | 5 | 3x3 | 5993540.28402 | 2110753.93051 | 37.775356344693996 | -122.465843541425 | (37.775356344694, -122.465843541425) | ||
| 9635 | 9635 | 64406 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2427 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1988 12:00:00 AM | Permit Number 25251 | 6011317.18902428 | 2102741.84827953 | 37.7543664024991 | -122.403784849219 | (37.7543664024991, -122.403784849219) | |||
| 9799 | 9799 | 121570 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1530 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779159 | 6010119.0 | 2100471.0 | 37.748064146234604 | -122.40776839943999 | (37.7480641462346, -122.40776839944) | |
| 10212 | 10212 | 173910 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6006450.1 | 2109317.2 | 37.772147675466705 | -122.421083366581 | (37.7721476754667, -122.421083366581) | ||||
| 10213 | 10213 | 173644 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6006450.1 | 2109317.2 | 37.772147675466705 | -122.421083366581 | (37.7721476754667, -122.421083366581) | ||||
| 10216 | 10216 | 173911 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6006450.1 | 2109317.2 | 37.772147675466705 | -122.421083366581 | (37.7721476754667, -122.421083366581) | ||||
| 10324 | 10324 | 108369 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 611 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773814 | 6001475.26516 | 2090061.55368 | 37.7189945287407 | -122.436912960177 | (37.7189945287407, -122.436912960177) |
| 10434 | 10434 | 15775 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 4808 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/05/1997 12:00:00 AM | 10 | 3X3 | Permit Number 773279 | 6001261.3736 | 2090797.0594 | 37.7210019026793 | -122.437704946106 | (37.7210019026793, -122.437704946106) | |
| 10539 | 10539 | 97421 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 84 Liebig St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2011 12:00:00 AM | 3 | 6x15 | Permit Number 768371 | 5995500.38132 | 2086681.7504200002 | 37.709372977163504 | -122.457321298761 | (37.7093729771635, -122.457321298761) | |
| 10622 | 10622 | 15860 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 5366 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999545.5765 | 2088270.5652 | 37.7139670145471 | -122.44345454060199 | (37.7139670145471, -122.443454540602) | |||
| 10698 | 10698 | 117442 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 683 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778575 | 6002740.92134 | 2089524.8599 | 37.7175927411032 | -122.432499770158 | (37.7175927411032, -122.432499770158) | ||
| 10856 | 10856 | 108684 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 46 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | Permit Number 774614 | 6000319.87619 | 2088768.81693 | 37.71537922895679 | -122.44081399618601 | (37.7153792289568, -122.440813996186) | |
| 11147 | 11147 | 83378 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 586 Athens St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52310 | 6003277.11077 | 2089949.83191 | 37.718790012118795 | -122.430676716663 | (37.7187900121188, -122.430676716663) | |
| 11339 | 11339 | 117430 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 724 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776863 | 6004182.226919999 | 2091583.55482 | 37.723327093656295 | -122.42766442668301 | (37.7233270936563, -122.427664426683) | ||
| 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) | |
| 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 | |||||||||
| 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) | |
| 13238 | 13238 | 4475 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1521 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1992 12:00:00 AM | 6 | 3X3 | 6004596.9832 | 2100011.9105700003 | 37.7464929146108 | -122.426830644527 | (37.7464929146108, -122.426830644527) | ||
| 13315 | 13315 | 187668 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 49 | 100x OGDEN AVE | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6007659.0 | 2096105.0 | 37.7359380573488 | -122.41596587682 | (37.7359380573488, -122.41596587682) | |||||
| 13423 | 13423 | 26000 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1715 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/25/2012 12:00:00 AM | 3 | 3x3 | 6014353.43695 | 2095957.87317 | 37.7359081801195 | -122.39281007033999 | (37.7359081801195, -122.39281007034) | ||
| 13451 | 13451 | 85537 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 110 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6007421.290519999 | 2109238.78217 | 37.77198705877429 | -122.417718370032 | (37.7719870587743, -122.417718370032) | |||
| 13465 | 13465 | 85534 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 110 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6007347.01879 | 2109279.74931 | 37.7720953650306 | -122.417978186861 | (37.7720953650306, -122.417978186861) | |||
| 13618 | 13618 | 25915 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1800 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/2015 12:17:00 PM | 3 | 3X3 | 6013847.663980001 | 2096411.7192 | 37.737126242566 | -122.394590512161 | (37.737126242566, -122.394590512161) | ||
| 13664 | 13664 | 6735 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 2 | 3x3 | 6017028.4506 | 2097182.15302 | 37.7394180218109 | -122.383646604615 | (37.7394180218109, -122.383646604615) | ||
| 13743 | 13743 | 26579 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 241 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1998 12:00:00 AM | 6 | 3X3 | 6011098.44545 | 2099048.11598 | 37.7442119973787 | -122.40428136282 | (37.7442119973787, -122.40428136282) | ||
| 13781 | 13781 | 26117 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1487 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2003 12:00:00 AM | 3 | 3X3 | 6015648.6011 | 2094991.9741 | 37.733327868310205 | -122.38826474357 | (37.7333278683102, -122.38826474357) | ||
| 13845 | 13845 | 117146 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Toland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011982.52405 | 2098055.99364 | 37.741537203178 | -122.401154691646 | (37.741537203178, -122.401154691646) | |
| 13874 | 13874 | 26433 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1679 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2000 12:00:00 AM | 3 | 3X3 | 6014598.595480001 | 2095777.3145 | 37.7354260166954 | -122.39194983104099 | (37.7354260166954, -122.391949831041) | ||
| 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 | |||||||||
| 13937 | 13937 | 25993 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1789 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/25/2012 12:00:00 AM | 3 | 3x3 | 6014037.236380001 | 2096196.21513 | 37.736545050306795 | -122.39391998842699 | (37.7365450503068, -122.393919988427) | ||
| 14022 | 14022 | 25548 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 141 Industrial St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2013 12:00:00 AM | 3 | 2x3 | 6011568.628409999 | 2097178.44526 | 37.7391045433316 | -122.402524116297 | (37.7391045433316, -122.402524116297) | ||
| 14072 | 14072 | 15048 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1119 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/20/2000 12:00:00 AM | 6 | 3X3 | 6015497.5853 | 2096021.456 | 37.7361462484719 | -122.38885869852601 | (37.7361462484719, -122.388858698526) | ||
| 14081 | 14081 | 26128 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1415 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/2010 12:00:00 AM | 3 | 3X3 | 6016013.7391 | 2094719.7689 | 37.7326006727272 | -122.386983370719 | (37.7326006727272, -122.386983370719) | ||
| 14085 | 14085 | 25999 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1717 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 3 | 3x3 | 6014332.85691 | 2095971.76656 | 37.7359451854222 | -122.392882195975 | (37.7359451854222, -122.392882195975) | ||
| 14095 | 14095 | 64530 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1400 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3 | 20x30 | Permit Number 53955 | 6016100.7066 | 2094719.4549 | 37.732604625715794 | -122.38668267828899 | (37.7326046257158, -122.386682678289) |
| 14340 | 14340 | 85536 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 110 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6007398.398469999 | 2109252.27561 | 37.7720228203246 | -122.41779851218901 | (37.7720228203246, -122.417798512189) | |||
| 14391 | 14391 | 26581 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 235 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6011124.08251 | 2099133.7568 | 37.7444485811329 | -122.404198741189 | (37.7444485811329, -122.404198741189) | ||
| 14462 | 14462 | 26105 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1547 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/16/2009 12:00:00 AM | 3 | 3x3 | 6015325.4204 | 2095230.2952 | 37.733964337308 | -122.38939871537501 | (37.733964337308, -122.389398715375) | ||
| 14536 | 14536 | 26016 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1690 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2000 12:00:00 AM | 3 | 3X3 | 6014602.53952 | 2095841.2099400002 | 37.735601679469 | -122.39194066153699 | (37.735601679469, -122.391940661537) | ||
| 14582 | 14582 | 26572 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 353 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1998 12:00:00 AM | 6 | 3X3 | 6010658.7205300005 | 2098280.84549 | 37.742080657198294 | -122.405747809912 | (37.7420806571983, -122.405747809912) | ||
| 14642 | 14642 | 85538 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 180 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007511.05272 | 2109187.82256 | 37.771852186555705 | -122.417404262918 | (37.7718521865557, -122.417404262918) | |||
| 14680 | 14680 | 26127 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1419 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6015993.0176 | 2094731.6994 | 37.7326322840804 | -122.38705584245199 | (37.7326322840804, -122.387055842452) | |||
| 14690 | 14690 | 26619 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1291 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/1998 12:00:00 AM | 6 | 3X3 | 6011585.48367 | 2093253.8886 | 37.728329475411 | -122.402189991188 | (37.728329475411, -122.402189991188) | ||
| 14726 | 14726 | 6733 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6017061.2899 | 2097158.62505 | 37.7393552338433 | -122.383531422133 | (37.7393552338433, -122.383531422133) | |||
| 14736 | 14736 | 6734 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017044.07799 | 2097171.2102099997 | 37.739388838832504 | -122.383591809817 | (37.7393888388325, -122.383591809817) | |||
| 14826 | 14826 | 28997 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 321X 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008985.047180001 | 2109404.3491700003 | 37.7725295406243 | -122.412320901705 | (37.7725295406243, -122.412320901705) | ||
| 14864 | 14864 | 26580 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 235 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1998 12:00:00 AM | 3 | 3X3 | 6011115.925530001 | 2099106.52375 | 37.7443733492673 | -122.404225030173 | (37.7443733492673, -122.404225030173) | ||
| 14884 | 14884 | 26578 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 241 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1998 12:00:00 AM | 6 | 3X3 | 6011090.3987 | 2099026.28851 | 37.7441516142074 | -122.404307650877 | (37.7441516142074, -122.404307650877) | ||
| 14918 | 14918 | 26006 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1669 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2000 12:00:00 AM | 3 | 3X3 | 6014649.3702300005 | 2095737.8438 | 37.735320456978705 | -122.391771523335 | (37.7353204569787, -122.391771523335) | ||
| 14921 | 14921 | 26108 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1509 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2003 12:00:00 AM | 3 | 3x3 | 6015422.1522 | 2095159.3952 | 37.733775022834394 | -122.38905933236099 | (37.7337750228344, -122.389059332361) | ||
| 14946 | 14946 | 26611 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1485 Bay Shore Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1998 12:00:00 AM | 12 | 3X3 | 6011726.3053 | 2092603.41849 | 37.7265512783073 | -122.401657461237 | (37.7265512783073, -122.401657461237) | ||
| 15058 | 15058 | 15055 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1224 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6015288.0468 | 2095812.3346 | 37.735560427325204 | -122.389568564294 | (37.7355604273252, -122.389568564294) | ||
| 15089 | 15089 | 117148 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Toland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011961.8463 | 2098027.63913 | 37.7414581941431 | -122.401224196662 | (37.7414581941431, -122.401224196662) | |
| 15177 | 15177 | 26109 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1509 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/09/2010 12:00:00 AM | 3 | 3x3 | 6015436.4421 | 2095148.4030000002 | 37.7337456325918 | -122.389009160289 | (37.7337456325918, -122.389009160289) | ||
| 15179 | 15179 | 94749 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3 | 3x3 | 6010338.73158 | 2097355.9728900003 | 37.739523256888106 | -122.406789069267 | (37.7395232568881, -122.406789069267) | ||
| 15330 | 15330 | 85542 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 240 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007856.4505900005 | 2108988.3497099997 | 37.7713239085987 | -122.416195374412 | (37.7713239085987, -122.416195374412) | |||
| 15346 | 15346 | 27245 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1840X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6013813.103680001 | 2096437.28943 | 37.7371945316856 | -122.39471179383499 | (37.7371945316856, -122.394711793835) | ||
| 15442 | 15442 | 25547 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 141 Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2014 12:00:00 AM | 3 | 2x3 | 6011520.04511 | 2097161.49572 | 37.7390552910796 | -122.402690904578 | (37.7390552910796, -122.402690904578) | ||
| 15522 | 15522 | 85557 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 396 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6008653.68072 | 2108532.35146 | 37.7701166389055 | -122.41340545620199 | (37.7701166389055, -122.413405456202) | |||
| 15574 | 15574 | 85539 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 180 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007548.32218 | 2109164.7314400002 | 37.771790880665606 | -122.417273708325 | (37.7717908806656, -122.417273708325) | |||
| 15668 | 15668 | 26613 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1355 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2015 10:59:00 PM | 3 | 3X3 | 6011681.24548 | 2092829.4663099998 | 37.727169444392096 | -122.401829114846 | (37.7271694443921, -122.401829114846) | ||
| 15680 | 15680 | 26834 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1129 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2008 12:00:00 AM | 3 | 3X3 | 6015470.5845 | 2095986.9202 | 37.7360499235694 | -122.388949641676 | (37.7360499235694, -122.388949641676) | ||
| 15700 | 15700 | 72422 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2400 Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1996 12:00:00 AM | 10 | 3x3 | 6010224.23312 | 2105998.24791 | 37.7632466260627 | -122.40779419295299 | (37.7632466260627, -122.407794192953) | |
| 15752 | 15752 | 117149 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Toland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011929.155180001 | 2097982.19203 | 37.7413315821976 | -122.40133403893499 | (37.7413315821976, -122.401334038935) | |
| 15766 | 15766 | 15015 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 650 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/14/2014 12:00:00 AM | 6 | 3x3 | 6016271.14274 | 2097128.2420599998 | 37.7392281047953 | -122.38626130881501 | (37.7392281047953, -122.386261308815) | ||
| 15800 | 15800 | 85533 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 110 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6007332.25294 | 2109288.61069 | 37.7721188652314 | -122.418029891562 | (37.7721188652314, -122.418029891562) | |||
| 15833 | 15833 | 117147 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Toland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011972.25416 | 2098042.58697 | 37.7414998183769 | -122.40118925978001 | (37.7414998183769, -122.40118925978) | |
| 15846 | 15846 | 29367 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 367X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2006 12:00:00 AM | 3 | 3X3 | 6010545.10979 | 2098098.4290400003 | 37.7415734269678 | -122.40612779327 | (37.7415734269678, -122.40612779327) | ||
| 15984 | 15984 | 26590 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1645 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/1998 12:00:00 AM | 6 | 3X3 | 6012121.9317 | 2091099.0732200001 | 37.7224427228244 | -122.400184180161 | (37.7224427228244, -122.400184180161) | ||
| 15994 | 15994 | 26106 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1539X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2000 12:00:00 AM | 12 | 3x3 | 6015355.6491 | 2095208.8603 | 37.733907157322605 | -122.389292708309 | (37.7339071573226, -122.389292708309) | ||
| 16054 | 16054 | 27246 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1840X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6013798.74354 | 2096448.75806 | 37.737225223756106 | -122.394762246699 | (37.7372252237561, -122.394762246699) | ||
| 16065 | 16065 | 26114 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1505 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 6 | 3x3 | 6015470.5181 | 2095128.0673 | 37.7336916836833 | -122.38888992918699 | (37.7336916836833, -122.388889929187) | ||
| 16117 | 16117 | 26556 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 228 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/09/1998 12:00:00 AM | 12 | 3x3 | 6011088.04001 | 2099355.12223 | 37.7450543887552 | -122.404338947303 | (37.7450543887552, -122.404338947303) |
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");