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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 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) | |
| 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) | ||
| 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) |
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 16121 | 16121 | 26100 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1577 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015169.8802 | 2095341.3169 | 37.7342605555935 | -122.38994422273198 | (37.7342605555935, -122.389944222732) | |||
| 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) | |||
| 16889 | 16889 | 15051 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1137 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/20/2000 12:00:00 AM | 3 | 8X18 | 6015459.2819 | 2095972.4779 | 37.736009641441 | -122.388987711638 | (37.736009641441, -122.388987711638) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 19912 | 19912 | 27292 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 56 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001688.66279 | 2095714.9103400002 | 37.7345294879464 | -122.436579762262 | (37.7345294879464, -122.436579762262) | |||
| 19983 | 19983 | 4397 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1011 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004431.54351 | 2102978.61798 | 37.7546294472032 | -122.427614046667 | (37.7546294472032, -122.427614046667) | |||
| 20586 | 20586 | 22918 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6006138.942840001 | 2107682.09275 | 37.7676405157139 | -122.422043508318 | (37.7676405157139, -122.422043508318) | |||
| 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) | ||
| 20683 | 20683 | 12972 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 84 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001913.39953 | 2095585.0292900002 | 37.734185633051894 | -122.435793484091 | (37.7341856330519, -122.435793484091) | |||
| 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) | |||
| 23033 | 23033 | 27530 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1898X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3X3 | 6013528.91672 | 2096649.2761900001 | 37.73776079882371 | -122.39570921391199 | (37.7377607988237, -122.395709213912) | |||
| 23103 | 23103 | 26097 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1583X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2003 12:00:00 AM | 6 | 3x3 | 6015137.4531 | 2095367.1486 | 37.7343296857828 | -122.390058138496 | (37.7343296857828, -122.390058138496) | ||
| 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) | |
| 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) | |||
| 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) | |||
| 25939 | 25939 | 223572 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 801 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008169.79 | 2095684.73442 | 37.7348128040698 | -122.414170142558 | (37.7348128040698, -122.414170142558) | |||
| 26480 | 26480 | 207665 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 315 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 6ft | 5996615.28225 | 2106600.5600799997 | 37.7641291658503 | -122.454906302505 | (37.7641291658503, -122.454906302505) | |||
| 26513 | 26513 | 207686 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2451 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990741.806609999 | 2098714.09627 | 37.742136330634 | -122.474645120982 | (37.742136330634, -122.474645120982) | |||
| 26575 | 26575 | 207688 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1732 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5990596.01765 | 2098405.20532 | 37.7412797470716 | -122.47512666388799 | (37.7412797470716, -122.475126663888) | |||
| 26626 | 26626 | 123725 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 549 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993866.33866 | 2110708.86626 | 37.7752514134392 | -122.46471237833799 | (37.7752514134392, -122.464712378338) | |||
| 26791 | 26791 | 223457 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 31 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5998436.79798 | 2105994.15168 | 37.7625684428081 | -122.448562558536 | (37.7625684428081, -122.448562558536) |
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");