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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |
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) | |
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) |
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) |
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) | |||||
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) | |||
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 | |||||||||
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) | ||
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) | |||
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) | ||
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) | ||
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) | ||
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) | ||
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) | |
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) | ||
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) | |||
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) | |
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) | |
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) | ||
16301 | 16301 | 27635 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 141 Industrial St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2009 12:00:00 AM | 3 | 2X3 | 6011682.97129 | 2097216.25233 | 37.7392147363678 | -122.40213142555099 | (37.7392147363678, -122.402131425551) | ||
16567 | 16567 | 26102 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1563 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015232.536 | 2095297.3479 | 37.73414330023979 | -122.389724529704 | (37.7341433002398, -122.389724529704) | |||
16619 | 16619 | 85558 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 396 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6008677.32979 | 2108520.19339 | 37.770084583473704 | -122.413322794134 | (37.7700845834737, -122.413322794134) | |||
16724 | 16724 | 74019 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2400 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1996 12:00:00 AM | 10 | 3x3 | 6010272.25282 | 2105997.87843 | 37.7632482996846 | -122.40762808187799 | (37.7632482996846, -122.407628081878) | |
16874 | 16874 | 25949 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2100 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6012331.41548 | 2097539.0273700003 | 37.7401371808736 | -122.399912042617 | (37.7401371808736, -122.399912042617) | ||
17112 | 17112 | 5086 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2575 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2011 12:00:00 AM | 3 | 3x3 | 6002278.04095 | 2096864.42797 | 37.737719273515 | -122.4346242575 | (37.737719273515, -122.4346242575) | ||
17994 | 17994 | 49868 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 368 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46634 | 6003577.84688999 | 2095267.92973361 | 37.733409356185796 | -122.430016351279 | (37.7334093561858, -122.430016351279) | ||
18447 | 18447 | 51025 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 51 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | Permit Number 47502 | 6005670.67188859 | 2109250.29159524 | 37.7719199923513 | -122.423774718207 | (37.7719199923513, -122.423774718207) | |||
18623 | 18623 | 117138 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
18735 | 18735 | 63382 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 261 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1987 12:00:00 AM | Permit Number 23962 | 6006733.60001952 | 2095809.91850213 | 37.735075757248296 | -122.41914443543999 | (37.7350757572483, -122.41914443544) | ||
18802 | 18802 | 509 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2753 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008975.21686 | 2102392.50435 | 37.7532760709475 | -122.411859333666 | (37.7532760709475, -122.411859333666) | |||
19100 | 19100 | 99391 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
19278 | 19278 | 39942 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 27 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | Permit Number 41213 | 6009741.23684285 | 2089425.45829631 | 37.7177142900305 | -122.408295747981 | (37.7177142900305, -122.408295747981) | ||
19422 | 19422 | 58438 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 905 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1979 12:00:00 AM | 3x3 | Permit Number 51484 | 5999161.38005537 | 2107089.77623283 | 37.7656181571992 | -122.446135313725 | (37.7656181571992, -122.446135313725) | ||
20657 | 20657 | 64543 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1547 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25426 | 6015321.62159268 | 2095235.25021997 | 37.7339777321734 | -122.389412195042 | (37.7339777321734, -122.389412195042) | ||
21151 | 21151 | 10207 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1273 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6005836.971940001 | 2101563.9580099997 | 37.7508245136462 | -122.422653168634 | (37.7508245136462, -122.422653168634) | |||
21318 | 21318 | 27510 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1259 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6005834.02618 | 2101632.44152 | 37.751012387419706 | -122.422668221463 | (37.7510123874197, -122.422668221463) | |||
21586 | 21586 | 10198 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1209 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1991 12:00:00 AM | 3 | 2X2 | 6005820.58037 | 2101870.80495 | 37.7516661199201 | -122.422731656039 | (37.7516661199201, -122.422731656039) | ||
22381 | 22381 | 17744 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1600X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006169.663819999 | 2115620.29477 | 37.789438622529204 | -122.42250137744101 | (37.7894386225292, -122.422501377441) | |||
23564 | 23564 | 43029 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2131 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2000 12:00:00 AM | 6 | Permit Number 42891 | 6012151.06584 | 2101359.39792 | 37.7506170436447 | -122.400803954262 | (37.7506170436447, -122.400803954262) | ||
23709 | 23709 | 223384 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1 Cumberland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6005565.506580001 | 2104580.7732 | 37.759092667419 | -122.42380640884701 | (37.759092667419, -122.423806408847) | |||
23816 | 23816 | 224059 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3628 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002696.79261 | 2106527.84926 | 37.76427650537521 | -122.43386694650499 | (37.7642765053752, -122.433866946505) | |||
23983 | 23983 | 224070 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4411 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000003.97958 | 2105733.8947099997 | 37.7619433258348 | -122.443123570319 | (37.7619433258348, -122.443123570319) | |||
24000 | 24000 | 246500 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 273 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6004745.35521 | 2099854.76299 | 37.746069811469 | -122.426306403626 | (37.746069811469, -122.426306403626) | |||
24032 | 24032 | 207660 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1207 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996711.4694300005 | 2107231.1786 | 37.7658662000893 | -122.454619182239 | (37.7658662000893, -122.454619182239) | |||
24108 | 24108 | 223503 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3421 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006951.65327 | 2101439.66063 | 37.750546046666706 | -122.41878967662 | (37.7505460466667, -122.41878967662) | |||
24291 | 24291 | 207706 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 215 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5998739.57891 | 2093599.69117 | 37.7285535657887 | -122.446623550035 | (37.7285535657887, -122.446623550035) | |||
24319 | 24319 | 176264 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 165 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010291.19923 | 2093895.2108900002 | 37.7300180820504 | -122.40670958899099 | (37.7300180820504, -122.406709588991) | |||
24422 | 24422 | 50532 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 315 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47171 | 5996679.82856356 | 2106618.62344586 | 37.764182465684705 | -122.454684361894 | (37.7641824656847, -122.454684361894) | |||
24451 | 24451 | 42139 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 583 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 5 | Permit Number 42434 | 5991253.848730001 | 2111457.82315 | 37.7771568827635 | -122.4738041366 | (37.7771568827635, -122.4738041366) | |
24524 | 24524 | 223397 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3560 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005876.75311 | 2104933.14392 | 37.7600777604998 | -122.422755010534 | (37.7600777604998, -122.422755010534) | |||
24645 | 24645 | 31679 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 4909 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35185 | 5997751.25621 | 2105611.0193 | 37.7614772360152 | -122.450905959737 | (37.7614772360152, -122.450905959737) | |
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) | |||
24712 | 24712 | 189244 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 690 Texas St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013923.095430001 | 2103892.83973 | 37.757672010179206 | -122.394853496397 | (37.7576720101792, -122.394853496397) | |||
24989 | 24989 | 223551 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1143 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5997699.39696 | 2106553.80105 | 37.764062907387704 | -122.45115331019 | (37.7640629073877, -122.45115331019) | |||
25085 | 25085 | 223541 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 814 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6001016.96065 | 2102616.12439 | 37.7534403941744 | -122.43939657921301 | (37.7534403941744, -122.439396579213) | |||
25196 | 25196 | 137812 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1802 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004857.7279 | 2115477.5519 | 37.7889725883007 | -122.42703036076 | (37.7889725883007, -122.42703036076) | |||
25319 | 25319 | 124355 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1108 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5992124.25378 | 2111386.32559 | 37.7770109442204 | -122.470787948699 | (37.7770109442204, -122.470787948699) | |||
25410 | 25410 | 46998 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
25711 | 25711 | 223380 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 800 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009884.795080001 | 2104504.34853 | 37.7591257084916 | -122.40886279708499 | (37.7591257084916, -122.408862797085) | |||
25760 | 25760 | 223377 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2801 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010298.3381900005 | 2101037.92652 | 37.7496308398979 | -122.407188209083 | (37.7496308398979, -122.407188209083) |
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");