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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34407 | 34407 | 94751 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010352.467540001 | 2097498.7285 | 37.739916001622795 | -122.40675163410101 | (37.7399160016228, -122.406751634101) | ||
| 34684 | 34684 | 52253 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 477 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2005 12:00:00 AM | 6 | Permit Number 48420 | 6010242.5453699995 | 2089633.7594299999 | 37.718314301343796 | -122.406577611683 | (37.7183143013438, -122.406577611683) | ||
| 35578 | 35578 | 33334 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3360 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 8 | 6x9 | Permit Number 37474 | 6004131.26666 | 2120719.53303 | 37.8033246198945 | -122.42991788581999 | (37.8033246198945, -122.42991788582) |
| 35657 | 35657 | 64564 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1011 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/1988 12:00:00 AM | 11 | Permit Number 25456 | 6009907.55581 | 2117242.96669 | 37.7941042450764 | -122.40968321262699 | (37.7941042450764, -122.409683212627) | |
| 36353 | 36353 | 95920 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 701 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767618 | 5991287.86259 | 2110556.38381 | 37.7746837464675 | -122.47362070061001 | (37.7746837464675, -122.47362070061) |
| 37400 | 37400 | 88728 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 68 Pontiac St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51663 | 6010467.8 | 2117974.1 | 37.7961431384766 | -122.407796278381 | (37.7961431384766, -122.407796278381) | |||
| 37425 | 37425 | 68676 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 233 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 10 | Permit Number 32585 | 5992731.02851 | 2113895.02943 | 37.783934233118 | -122.468871549364 | (37.783934233118, -122.468871549364) | |
| 37991 | 37991 | 46987 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2010 12:00:00 AM | 5 | Permit Number 53455 | 6012596.87958 | 2101472.71362 | 37.75095304025211 | -122.39927023785 | (37.7509530402521, -122.39927023785) | ||
| 38763 | 38763 | 68965 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2271 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52893 | 5999938.800530001 | 2120187.4575099996 | 37.8016253679701 | -122.444387754501 | (37.8016253679701, -122.444387754501) | |
| 40465 | 40465 | 84616 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 65 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50830 | 6001046.02752 | 2119987.7015 | 37.8011400020673 | -122.440541917971 | (37.8011400020673, -122.440541917971) | |
| 42078 | 42078 | 52803 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 25@ TEXAS Sierra St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | 4 | Permit Number 48835 | 6013662.91964 | 2104110.0408099997 | 37.758253927301396 | -122.395768516112 | (37.7582539273014, -122.395768516112) | ||
| 42596 | 42596 | 50218 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2536 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 2 | Permit Number 46925 | 5987649.93004 | 2111223.20837 | 37.776303303016796 | -122.48625384500099 | (37.7763033030168, -122.486253845001) | |
| 42996 | 42996 | 52427 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1815X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48544 | 6004786.32091155 | 2115731.58720361 | 37.7896660673411 | -122.427295522794 | (37.7896660673411, -122.427295522794) |
| 43044 | 43044 | 101126 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Clement St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5990758.62584 | 2113423.68557 | 37.7825259029155 | -122.47566083662 | (37.7825259029155, -122.47566083662) | |||
| 43159 | 43159 | 52433 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1807 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 5 | Permit Number 48548 | 6004803.7724 | 2115546.524 | 37.7891589172332 | -122.427221954641 | (37.7891589172332, -122.427221954641) | |
| 43177 | 43177 | 84023 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 309 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 773233 | 6004808.26935881 | 2101900.57071737 | 37.7516906826671 | -122.42623448013 | (37.7516906826671, -122.42623448013) | ||
| 43534 | 43534 | 100356 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 566 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2012 12:00:00 AM | 1 | Permit Number 769115 | 6004695.2 | 2110571.1 | 37.775491495930204 | -122.427243048056 | (37.7754914959302, -122.427243048056) | ||
| 43699 | 43699 | 37992 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 650 Texas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40210 | 6013843.225980001 | 2104002.4986900003 | 37.7579686686468 | -122.39513740068999 | (37.7579686686468, -122.39513740069) | ||
| 44010 | 44010 | 46258 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 22 Leo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2002 12:00:00 AM | 5 | Permit Number 44543 | 6001485.63381 | 2091410.0324 | 37.72269773728679 | -122.436973607764 | (37.7226977372868, -122.436973607764) | ||
| 44336 | 44336 | 68425 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2209 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1993 12:00:00 AM | 10 | Permit Number 32274 | 6011881.537959999 | 2102307.78883 | 37.753206081220604 | -122.401802665774 | (37.7532060812206, -122.401802665774) | ||
| 45757 | 45757 | 37990 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 650 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | 1 | Permit Number 44744 | 6013820.84604 | 2104031.24845 | 37.758046364659 | -122.395216814417 | (37.758046364659, -122.395216814417) | |
| 45838 | 45838 | 43030 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2121 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2000 12:00:00 AM | 6 | Permit Number 42892 | 6012174.28913 | 2101359.6022 | 37.7506188998561 | -122.40072366009501 | (37.7506188998561, -122.400723660095) | ||
| 46559 | 46559 | 64158 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 738 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1987 12:00:00 AM | 11 | 6x6 | Permit Number 24937 | 5991972.51764 | 2110378.72866 | 37.774235580451496 | -122.47123941680901 | (37.7742355804515, -122.471239416809) |
| 47324 | 47324 | 114551 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 815 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 2 | Permit Number 777069 | 6011882.52063 | 2104552.93824 | 37.759370822322005 | -122.401957083855 | (37.759370822322, -122.401957083855) | ||
| 47492 | 47492 | 60061 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1574 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1982 12:00:00 AM | 3 | Permit Number 19560 | 6015687.15879 | 2097129.44006 | 37.73919905308271 | -122.38828056471701 | (37.7391990530827, -122.388280564717) | ||
| 47562 | 47562 | 59079 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 630 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 4 | Permit Number 18379 | 5993622.03165 | 2110755.91143 | 37.7753664990592 | -122.465560903584 | (37.7753664990592, -122.465560903584) | ||
| 47616 | 47616 | 64550 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1407 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 9 | Permit Number 25433 | 6015557.9064 | 2094994.5115 | 37.7333298097375 | -122.388578480063 | (37.7333298097375, -122.388578480063) | |
| 47807 | 47807 | 101124 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5990795.23328 | 2113422.41957 | 37.782524549011704 | -122.47553409958599 | (37.7825245490117, -122.475534099586) | |||
| 48042 | 48042 | 88589 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 874 24th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51533 | 5988541.53724 | 2110053.24401 | 37.7731428326728 | -122.48308379276699 | (37.7731428326728, -122.483083792767) | ||
| 49277 | 49277 | 68253 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3825 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32055 | 6000581.64191 | 2121452.9297599997 | 37.805136672889205 | -122.44225413274799 | (37.8051366728892, -122.442254132748) | |
| 49593 | 49593 | 85546 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 250X 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6007915.610258999 | 2108965.748791 | 37.771265178087894 | -122.41598913709299 | (37.7712651780879, -122.415989137093) | |||
| 49598 | 49598 | 69056 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1235 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33064 | 5992348.34951393 | 2107046.09564514 | 37.7651067945026 | -122.469696689595 | (37.7651067945026, -122.469696689595) | ||
| 49805 | 49805 | 45669 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 815 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49963 | 5984453.94726 | 2110275.98244 | 37.7735156996405 | -122.497239525872 | (37.7735156996405, -122.497239525872) | |
| 51114 | 51114 | 32504 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 399 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 9 | Permit Number 37008 | 6007356.06097 | 2095755.1769700001 | 37.734960483524496 | -122.416988482053 | (37.7349604835245, -122.416988482053) | |
| 51244 | 51244 | 96169 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 45 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767802 | 6007419.0 | 2097998.0 | 37.7411223211925 | -122.416929733801 | (37.7411223211925, -122.416929733801) | |
| 51540 | 51540 | 38100 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1265 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 4 | Permit Number 40271 | 5987674.53427275 | 2106687.60559412 | 37.76385123223321 | -122.48583575429701 | (37.7638512322332, -122.485835754297) | |
| 51570 | 51570 | 47404 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 522 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/26/2013 12:00:00 AM | 1 | Permit Number 771051 | 5993469.13316 | 2111905.11444 | 37.778513081590496 | -122.46617334261101 | (37.7785130815905, -122.466173342611) | |
| 51697 | 51697 | 87865 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 65 Avila St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50830 | 6001049.0728400005 | 2119968.8143 | 37.801088316234704 | -122.440530024452 | (37.8010883162347, -122.440530024452) | |
| 51743 | 51743 | 54985 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 610 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 1 | Permit Number 10863 | 5990982.11543 | 2111201.05221 | 37.776436117959896 | -122.474725393074 | (37.7764361179599, -122.474725393074) | ||
| 51911 | 51911 | 65610 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 655 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | 10 | Permit Number 28515 | 6002150.8874699995 | 2090106.59961 | 37.71915659198321 | -122.434580819343 | (37.7191565919832, -122.434580819343) | |
| 52045 | 52045 | 44768 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 712 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2001 12:00:00 AM | 6 | Permit Number 43876 | 6012361.28636 | 2111165.48886 | 37.777554106883706 | -122.400765825683 | (37.7775541068837, -122.400765825683) | ||
| 52128 | 52128 | 32155 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 521 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | 7 | Permit Number 35505 | 6004828.77889 | 2111059.03276 | 37.7768387933121 | -122.42681572299401 | (37.7768387933121, -122.426815722994) | ||
| 52325 | 52325 | 59129 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/1992 12:00:00 AM | 11 | Permit Number 30380 | 5992485.89514 | 2112129.74225 | 37.7790730716469 | -122.46959106216002 | (37.7790730716469, -122.46959106216) | ||
| 52649 | 52649 | 66496 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2200 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 6 | Permit Number 29657 | 6001602.2551 | 2113943.9812 | 37.784577173880294 | -122.438183936989 | (37.7845771738803, -122.438183936989) | |
| 53106 | 53106 | 59756 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 410 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1981 12:00:00 AM | 15 | Permit Number 19194 | 6003645.40594 | 2091044.7006599999 | 37.7218171391456 | -122.42948170562 | (37.7218171391456, -122.42948170562) | ||
| 53170 | 53170 | 37231 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1815 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | 5 | Permit Number 46003 | 5985330.0834 | 2102828.2693 | 37.7531176701023 | -122.493659982631 | (37.7531176701023, -122.493659982631) | |
| 53241 | 53241 | 47687 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1045 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2002 12:00:00 AM | Permit Number 45486 | 6003826.76338909 | 2102198.68251842 | 37.752453700851795 | -122.429649915481 | (37.7524537008518, -122.429649915481) | |||
| 53590 | 53590 | 33037 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 494 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37315 | 6006779.65662971 | 2100908.40918731 | 37.7490776652966 | -122.41934677281 | (37.7490776652966, -122.41934677281) | |||
| 53616 | 53616 | 35078 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 53704 | 53704 | 64964 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1649 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1989 12:00:00 AM | 12 | Permit Number 25999 | 6005045.106240001 | 2119511.2308099996 | 37.8000586419391 | -122.42666941405899 | (37.8000586419391, -122.426669414059) | |
| 54012 | 54012 | 31710 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 619 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 9 | Permit Number 35210 | 5996583.34698 | 2107294.12432 | 37.7660316834511 | -122.45506687733999 | (37.7660316834511, -122.45506687734) | |
| 54290 | 54290 | 56166 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 623 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 6 | Permit Number 12274 | 5990937.74428 | 2111139.59084 | 37.7762647906594 | -122.474874396612 | (37.7762647906594, -122.474874396612) | ||
| 54668 | 54668 | 31560 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 178 Ewing Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1995 12:00:00 AM | Permit Number 35104 | 5998523.78697564 | 2112531.01963796 | 37.7805219856792 | -122.448732545056 | (37.7805219856792, -122.448732545056) | |||
| 55547 | 55547 | 52985 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 483 Harkness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2006 12:00:00 AM | 5 | Permit Number 48967 | 6010218.63808 | 2089641.8160400002 | 37.7183350855707 | -122.40666081696101 | (37.7183350855707, -122.406660816961) | ||
| 56938 | 56938 | 33335 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3360 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 7 | 9x9 | Permit Number 37474 | 6004127.03344 | 2120735.4068 | 37.8033679654079 | -122.429933668002 | (37.8033679654079, -122.429933668002) |
| 57190 | 57190 | 41945 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 653 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 8 | Permit Number 42303 | 5993457.880580001 | 2111001.78107 | 37.7760321220276 | -122.466146606961 | (37.7760321220276, -122.466146606961) | |
| 57552 | 57552 | 94757 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010407.95479 | 2097827.7335900003 | 37.7408224831747 | -122.406582959945 | (37.7408224831747, -122.406582959945) | ||
| 57646 | 57646 | 65832 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2205 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | 1 | Permit Number 28822 | 6000136.86621 | 2120563.93301 | 37.802670367617104 | -122.443729421089 | (37.8026703676171, -122.443729421089) | |
| 57693 | 57693 | 61998 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3337 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1985 12:00:00 AM | 10 | Permit Number 22065 | 6004092.37742 | 2120634.4827 | 37.8030888913932 | -122.430046392648 | (37.8030888913932, -122.430046392648) | |
| 57943 | 57943 | 95767 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 291 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767502 | 6004463.995209999 | 2090737.7812599998 | 37.721020719304704 | -122.426630208134 | (37.7210207193047, -122.426630208134) |
| 58190 | 58190 | 55068 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1408 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 11 | Permit Number 10962 | 6015508.9909 | 2094998.9084 | 37.733339171785204 | -122.38874790280899 | (37.7333391717852, -122.388747902809) | ||
| 59309 | 59309 | 55067 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1404 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 11 | Permit Number 10961 | 6015524.9297 | 2095021.4425 | 37.7334019292539 | -122.388694369981 | (37.7334019292539, -122.388694369981) | ||
| 59512 | 59512 | 104074 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 841 32nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/06/2013 12:00:00 AM | 2 | Permit Number 770392 | 5986000.25731 | 2110187.13166 | 37.7733622428275 | -122.491884144737 | (37.7733622428275, -122.491884144737) | ||
| 59658 | 59658 | 59922 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1501 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1981 12:00:00 AM | 13 | 3x3 | Permit Number 19392 | 6009252.526319999 | 2118479.54886 | 37.797462868466 | -122.412037123318 | (37.797462868466, -122.412037123318) | |
| 59806 | 59806 | 112676 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1601 Grant Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6010481.2 | 2120003.6 | 37.8017163995107 | -122.40789309729799 | (37.8017163995107, -122.407893097298) | |||
| 60285 | 60285 | 92546 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1534 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52889 | 5985305.6485 | 2104749.3445 | 37.7583909829975 | -122.493886044317 | (37.7583909829975, -122.493886044317) | |
| 60642 | 60642 | 42138 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 579 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 8 | Permit Number 42433 | 5991254.316269999 | 2111466.88915 | 37.7771818025968 | -122.473803180798 | (37.7771818025968, -122.473803180798) | |
| 60906 | 60906 | 85554 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 360X 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6008520.7969 | 2108615.740864 | 37.7703381448181 | -122.413871001048 | (37.7703381448181, -122.413871001048) | |||
| 60983 | 60983 | 84618 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2334 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50844 | 6000130.7318 | 2119914.64406 | 37.8008872440121 | -122.44370397656601 | (37.8008872440121, -122.443703976566) | |
| 61283 | 61283 | 62959 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1175 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1986 12:00:00 AM | 14 | Permit Number 23345 | 6008001.56121 | 2118185.8038 | 37.796586051068296 | -122.416344986535 | (37.7965860510683, -122.416344986535) | |
| 62140 | 62140 | 52647 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 850@ FULTON 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | 1 | Permit Number 774180 | 5982028.38924 | 2109948.2493 | 37.7724733883273 | -122.505605444469 | (37.7724733883273, -122.505605444469) | ||
| 62288 | 62288 | 84009 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 980 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50690 | 6011658.3598 | 2090351.5567 | 37.7203643356392 | -122.401734134722 | (37.7203643356392, -122.401734134722) | |
| 62630 | 62630 | 61995 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3324 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52348 | 6004148.34958 | 2120589.64511 | 37.802968948823704 | -122.429849499548 | (37.8029689488237, -122.429849499548) | |
| 62686 | 62686 | 67384 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 632 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1992 12:00:00 AM | 8 | Permit Number 30880 | 5992568.1848 | 2111126.41775 | 37.7763229702913 | -122.469233345827 | (37.7763229702913, -122.469233345827) | |
| 63900 | 63900 | 64532 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1414 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 0 | Permit Number 25414 | 6016046.60541162 | 2094755.16174124 | 37.732699674197605 | -122.38687221028 | (37.7326996741976, -122.38687221028) | |
| 64113 | 64113 | 38141 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | 4 | Permit Number 40298 | 6010551.388230001 | 2093805.1264900002 | 37.729785283541396 | -122.40580373606001 | (37.7297852835414, -122.40580373606) | |
| 66265 | 66265 | 59758 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 354 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1981 12:00:00 AM | 18 | 6x9 | Permit Number 19196 | 6003858.35671 | 2091380.59848 | 37.722751495181704 | -122.42876952352199 | (37.7227514951817, -122.428769523522) | |
| 66576 | 66576 | 68236 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1515 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 9 | Permit Number 32031 | 5990787.04658 | 2113362.94185 | 37.7823607651124 | -122.47555807743099 | (37.7823607651124, -122.475558077431) | |
| 66740 | 66740 | 91087 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 134 Ralston St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51982 | 5992207.0 | 2088764.0 | 37.7149006256244 | -122.46885508368 | (37.7149006256244, -122.46885508368) | |||
| 68437 | 68437 | 94759 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010436.494630001 | 2097901.6693599997 | 37.7410270915281 | -122.406489488003 | (37.7410270915281, -122.406489488003) | ||
| 68650 | 68650 | 94761 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010473.71758 | 2097978.74448 | 37.741240805519396 | -122.406366213439 | (37.7412408055194, -122.406366213439) | ||
| 69028 | 69028 | 31346 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 5 | Permit Number 34957 | 6004784.8126 | 2111056.6827 | 37.7768298546653 | -122.42696764831301 | (37.7768298546653, -122.426967648313) | |
| 69071 | 69071 | 67317 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 715 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 11 | Permit Number 30798 | 5992850.6413199995 | 2110569.51812 | 37.7748101916189 | -122.468215736984 | (37.7748101916189, -122.468215736984) | |
| 69376 | 69376 | 63388 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 139 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1987 12:00:00 AM | Permit Number 23969 | 6005989.66886949 | 2095872.0431692002 | 37.7352044148911 | -122.42172088704599 | (37.7352044148911, -122.421720887046) | ||
| 70028 | 70028 | 46999 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2010 12:00:00 AM | 5 | Permit Number 53455 | 6012582.01898 | 2101471.73036 | 37.7509495122074 | -122.399321558558 | (37.7509495122074, -122.399321558558) | ||
| 70246 | 70246 | 56379 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 191@ 23rd Ave 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2012 12:00:00 AM | 2 | Permit Number 769038 | 5988661.1856 | 2114079.0461 | 37.7842035193233 | -122.482965030995 | (37.7842035193233, -122.482965030995) | ||
| 70966 | 70966 | 46985 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | 5 | Permit Number 44999 | 6012611.41785 | 2101473.70376 | 37.7509565692018 | -122.39922003227501 | (37.7509565692018, -122.399220032275) | ||
| 71713 | 71713 | 68222 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1324 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 7 | Permit Number 32012 | 5991360.0302800005 | 2113443.0378799997 | 37.78261388597161 | -122.47358167061199 | (37.7826138859716, -122.473581670612) | |
| 72154 | 72154 | 37672 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3270 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40070 | 6007686.0 | 2105618.0 | 37.7620601307471 | -122.416546187971 | (37.7620601307471, -122.416546187971) |
| 72508 | 72508 | 35506 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3451 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38909 | 6005392.68349986 | 2103106.02983212 | 37.75503360932 | -122.424299225131 | (37.75503360932, -122.424299225131) | ||
| 73786 | 73786 | 94516 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1106X Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 08/27/2010 12:00:00 AM | 2 | Permit Number 53703 | 6012787.7377 | 2102360.9473599996 | 37.753402573178896 | -122.39867255379299 | (37.7534025731789, -122.398672553793) | ||
| 74059 | 74059 | 31015 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1200 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34784 | 6001104.8718 | 2087440.4366099997 | 37.7117764674692 | -122.438005613962 | (37.7117764674692, -122.438005613962) | ||
| 74122 | 74122 | 55804 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1631 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1973 12:00:00 AM | 12 | Permit Number 11848 | 6005137.19925 | 2119177.96133 | 37.79914877534139 | -122.42632699542 | (37.7991487753414, -122.42632699542) | ||
| 74306 | 74306 | 94760 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010454.10107 | 2097938.95969 | 37.7411304676923 | -122.406431238013 | (37.7411304676923, -122.406431238013) | ||
| 74664 | 74664 | 84433 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 778 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51565 | 5992910.95397 | 2110169.95653 | 37.7737165860391 | -122.467978035553 | (37.7737165860391, -122.467978035553) | |
| 75087 | 75087 | 94754 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 5 | 3x3 | 6010365.49883 | 2097628.45401 | 37.7402729290463 | -122.406715716973 | (37.7402729290463, -122.406715716973) | ||
| 75477 | 75477 | 37660 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 486 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | 4 | Permit Number 47116 | 5991908.79894 | 2112136.43002 | 37.7790580641946 | -122.47158794068501 | (37.7790580641946, -122.471587940685) | |
| 76019 | 76019 | 108612 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3628 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | Permit Number 774590 | 6002731.19846 | 2106518.35077 | 37.764252377203 | -122.433747267607 | (37.764252377203, -122.433747267607) | |
| 76323 | 76323 | 52820 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2850@ ANZA Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 1 | Permit Number 775537 | 5989777.027869999 | 2111978.2933900002 | 37.778500303461 | -122.478950948669 | (37.778500303461, -122.478950948669) | ||
| 76545 | 76545 | 38861 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1550 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 4 | Permit Number 40688 | 5989338.7682 | 2104794.6769999997 | 37.75875059888261 | -122.479941205975 | (37.7587505988826, -122.479941205975) |
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");