Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11880 | 11880 | 47474 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45375 | |||||||||
| 13904 | 13904 | 47479 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | Permit Number 45375 | |||||||||
| 137271 | 137271 | 191088 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1 01st St | 19 | : Yard 23 | Tree 1 | Private 1 | 18 | 6014455.34951 | 2105889.6924799997 | 37.7631845152826 | -122.393152451232 | (37.7631845152826, -122.393152451232) | ||||
| 131203 | 131203 | 223464 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998616.14306 | 2107232.00709 | 37.76597753526261 | -122.448031401823 | (37.7659775352626, -122.448031401823) | |||
| 61122 | 61122 | 207588 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1 Chilton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001743.96601 | 2095815.79538 | 37.734809637542604 | -122.43639577894699 | (37.7348096375426, -122.436395778947) | |||
| 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) | |||
| 188754 | 188754 | 223383 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1 Cumberland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6005540.24064 | 2104579.79946 | 37.759088567411794 | -122.423893721341 | (37.7590885674118, -122.423893721341) | |||
| 39877 | 39877 | 207693 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992963.53977 | 2099050.31915 | 37.7431879987389 | -122.46698756732599 | (37.7431879987389, -122.466987567326) | |||
| 40110 | 40110 | 207692 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992959.6562 | 2099040.51355 | 37.743160850889396 | -122.467000282841 | (37.7431608508894, -122.467000282841) | |||
| 85116 | 85116 | 52350 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2005 12:00:00 AM | Permit Number 48491 | 5992970.80290968 | 2099088.07445215 | 37.74329208444921 | -122.46696519775 | (37.7432920844492, -122.46696519775) | |||
| 117163 | 117163 | 52351 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Madrone Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2005 12:00:00 AM | Permit Number 48491 | 5992970.80290968 | 2099088.07445215 | 37.74329208444921 | -122.46696519775 | (37.7432920844492, -122.46696519775) | |||
| 121809 | 121809 | 52349 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2005 12:00:00 AM | Permit Number 48491 | 5992970.80290968 | 2099088.07445215 | 37.74329208444921 | -122.46696519775 | (37.7432920844492, -122.46696519775) | |||
| 152957 | 152957 | 207691 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Madrone Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992956.08252 | 2099027.95475 | 37.7431261613357 | -122.46701172671999 | (37.7431261613357, -122.46701172672) | |||
| 52431 | 52431 | 176245 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Ordway St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6011861.55971 | 2090354.4495299999 | 37.72038361619379 | -122.401031937775 | (37.7203836161938, -122.401031937775) | |||
| 70812 | 70812 | 176244 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Ordway St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011881.091109999 | 2090360.91966 | 37.720402471380204 | -122.400964878027 | (37.7204024713802, -122.400964878027) | |||
| 74948 | 74948 | 176246 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Ordway St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011847.19322 | 2090350.44098 | 37.72037180809671 | -122.401081316846 | (37.7203718080967, -122.401081316846) | |||
| 150014 | 150014 | 176243 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Ordway St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011901.96297 | 2090368.71329 | 37.72042503536171 | -122.40089327761801 | (37.7204250353617, -122.400893277618) | |||
| 186789 | 186789 | 176247 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Ordway St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011833.809309999 | 2090345.7505400002 | 37.720358182462704 | -122.401127251532 | (37.7203581824627, -122.401127251532) | |||
| 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) | |
| 29324 | 29324 | 246575 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005230.8128 | 2109313.1532400004 | 37.7720677549581 | -122.425300698072 | (37.7720677549581, -122.425300698072) | |||
| 44765 | 44765 | 246572 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6005238.2187 | 2109262.1859999998 | 37.7719282296287 | -122.42527145302601 | (37.7719282296287, -122.425271453026) | |||
| 97961 | 97961 | 64786 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1989 12:00:00 AM | Permit Number 25781 | 6005246.79588468 | 2109227.98306531 | 37.7718348011935 | -122.425239349655 | (37.7718348011935, -122.425239349655) | ||
| 157957 | 157957 | 246573 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6005236.998 | 2109273.038 | 37.771957957636 | -122.42527644787701 | (37.771957957636, -122.425276447877) | |||
| 160036 | 160036 | 246576 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 5 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005228.37861 | 2109333.02061 | 37.7721221684335 | -122.42531053216001 | (37.7721221684335, -122.42531053216) | |||
| 167170 | 167170 | 246574 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6005235.59585 | 2109292.2935900004 | 37.7720107496197 | -122.425282668482 | (37.7720107496197, -122.425282668482) | |||
| 77345 | 77345 | 48686 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Palm Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2002 12:00:00 AM | Permit Number 45967 | 5995920.95422115 | 2113779.82862982 | 37.7838017006932 | -122.457827310949 | (37.7838017006932, -122.457827310949) | |||
| 92923 | 92923 | 48688 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Palm Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2002 12:00:00 AM | Permit Number 45967 | 5995920.95422115 | 2113779.82862982 | 37.7838017006932 | -122.457827310949 | (37.7838017006932, -122.457827310949) | |||
| 138947 | 138947 | 48687 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Palm Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2002 12:00:00 AM | Permit Number 45967 | 5995920.95422115 | 2113779.82862982 | 37.7838017006932 | -122.457827310949 | (37.7838017006932, -122.457827310949) | |||
| 129832 | 129832 | 223452 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Rivoli St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998137.72031 | 2105984.6438 | 37.762525231268704 | -122.44959626987301 | (37.7625252312687, -122.449596269873) | |||
| 131823 | 131823 | 31713 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 43549 | 5998153.78946 | 2105987.36259 | 37.762533615662704 | -122.44954088871 | (37.7625336156627, -122.44954088871) | |
| 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) | ||
| 80512 | 80512 | 90161 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1000X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992485.27988 | 2111393.76315 | 37.7770522373591 | -122.46953960037901 | (37.7770522373591, -122.469539600379) | ||
| 117452 | 117452 | 90162 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1000X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992470.47116 | 2111395.13018 | 37.7770551349921 | -122.469590927435 | (37.7770551349921, -122.469590927435) | ||
| 94129 | 94129 | 90352 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1001 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5992411.3282699995 | 2111337.20647 | 37.7768926738444 | -122.469791301151 | (37.7768926738444, -122.469791301151) | ||
| 95462 | 95462 | 90900 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1003 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992498.4502 | 2110659.84076 | 37.7750378461806 | -122.469440604249 | (37.7750378461806, -122.469440604249) | ||
| 51112 | 51112 | 126557 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011999.63961 | 2119254.38216 | 37.7997441211609 | -122.402585850275 | (37.7997441211609, -122.402585850275) | |||
| 52331 | 52331 | 126558 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012003.3055 | 2119230.3844 | 37.7996784337747 | -122.402571476413 | (37.7996784337747, -122.402571476413) | |||
| 55656 | 55656 | 126560 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012009.79179 | 2119188.89054 | 37.7995648637804 | -122.402546111926 | (37.7995648637804, -122.402546111926) | |||
| 133212 | 133212 | 126556 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011993.70082 | 2119305.26438 | 37.799883499875996 | -122.402609980888 | (37.799883499876, -122.402609980888) | |||
| 151638 | 151638 | 126555 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6011987.15474 | 2119346.92061 | 37.7999975123406 | -122.402635563904 | (37.7999975123406, -122.402635563904) | |||
| 155894 | 155894 | 126559 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012005.05894 | 2119209.80303 | 37.799622020198605 | -122.402563960758 | (37.7996220201986, -122.402563960758) | |||
| 180698 | 180698 | 126554 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011981.00581 | 2119393.57508 | 37.8001252709281 | -122.402660124387 | (37.8001252709281, -122.402660124387) | |||
| 115797 | 115797 | 19295 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 100X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 6 | 3X3 | 5995238.34395 | 2110816.5488299998 | 37.7756260846481 | -122.45997413441401 | (37.7756260846481, -122.459974134414) | ||
| 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) | |||||
| 490 | 490 | 85529 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 3x3 | 6007351.89443 | 2109342.45047 | 37.7722678019432 | -122.417965767207 | (37.7722678019432, -122.417965767207) | ||
| 162446 | 162446 | 120821 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 20th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5989570.27097 | 2114621.23399 | 37.785745070127504 | -122.47985964308799 | (37.7857450701275, -122.479859643088) | |||
| 175182 | 175182 | 120820 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 20th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5989571.70093 | 2114608.1795799998 | 37.785709309470796 | -122.47985374027 | (37.7857093094708, -122.47985374027) | |||
| 63506 | 63506 | 138230 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998494.0384 | 2112624.2642 | 37.78077630983061 | -122.44884217738701 | (37.7807763098306, -122.448842177387) | |||
| 157006 | 157006 | 138228 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998518.0663 | 2112627.9868 | 37.7807879051601 | -122.448759321794 | (37.7807879051601, -122.448759321794) | |||
| 151480 | 151480 | 124028 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Funston Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5991796.1991 | 2114253.0901 | 37.7848633156564 | -122.47213179245199 | (37.7848633156564, -122.472131792452) | |||
| 181783 | 181783 | 124029 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Funston Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5991795.62331 | 2114277.55052 | 37.7849304438848 | -122.47213556804701 | (37.7849304438848, -122.472135568047) | |||
| 3065 | 3065 | 175836 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 101 Rhine St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994366.585519999 | 2086543.72285 | 37.70892880020671 | -122.46122985488998 | (37.7089288002067, -122.46122985489) | |||
| 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) | |||
| 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) | |
| 152061 | 152061 | 141989 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1019 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004298.7778 | 2111838.3869 | 37.77894872708271 | -122.42870472731 | (37.7789487270827, -122.42870472731) | |||
| 469 | 469 | 85530 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 101X 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6007333.48731 | 2109350.5044400003 | 37.772288880253704 | -122.418030010287 | (37.7722888802537, -122.418030010287) | |||
| 479 | 479 | 85531 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 101X 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007317.968280001 | 2109362.68703 | 37.7723214572932 | -122.418084555959 | (37.7723214572932, -122.418084555959) | |||
| 92928 | 92928 | 90163 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1020 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992466.887805 | 2111387.622086 | 37.7770343127004 | -122.469602776563 | (37.7770343127004, -122.469602776563) | ||
| 148384 | 148384 | 67374 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1020 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | 6 | Permit Number 30868 | 5992412.40492 | 2111393.18626 | 37.7770464413981 | -122.469791653286 | (37.7770464413981, -122.469791653286) | |
| 111869 | 111869 | 35565 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1021 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2003 12:00:00 AM | Permit Number 38935 | 6005771.77167049 | 2102851.56857317 | 37.7543563162185 | -122.422970143174 | (37.7543563162185, -122.422970143174) | ||
| 4062 | 4062 | 216659 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1022 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 07:44:00 AM | 3 | Width 4ft | 5995946.33237 | 2090713.9624 | 37.7204700913979 | -122.456071352615 | (37.7204700913979, -122.456071352615) | ||
| 118251 | 118251 | 50409 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1023 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2003 12:00:00 AM | Permit Number 47064 | 6005772.16397035 | 2102844.45984762 | 37.75433681944221 | -122.422968281285 | (37.7543368194422, -122.422968281285) | |||
| 93204 | 93204 | 90899 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1039 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992439.368739 | 2110665.9684619997 | 37.7750512566564 | -122.469645424238 | (37.7750512566564, -122.469645424238) | ||
| 167899 | 167899 | 69965 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1039 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/1992 12:00:00 AM | 1 | 5992352.5387699995 | 2110655.12549 | 37.7750164659141 | -122.469944995693 | (37.7750164659141, -122.469944995693) | ||
| 83774 | 83774 | 90350 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1045 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992328.99634 | 2111334.95536 | 37.7768817336944 | -122.470075945794 | (37.7768817336944, -122.470075945794) | ||
| 122842 | 122842 | 90351 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1045 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992345.34525 | 2111334.78441 | 37.7768822094186 | -122.47001937801399 | (37.7768822094186, -122.470019378014) | ||
| 145202 | 145202 | 90349 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1045 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992315.426080001 | 2111334.89456 | 37.776880782256704 | -122.470122884589 | (37.7768807822567, -122.470122884589) | ||
| 185264 | 185264 | 84126 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1045 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50691 | 6011772.837180001 | 2090087.8836 | 37.7196467305931 | -122.401319901612 | (37.7196467305931, -122.401319901612) | |
| 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) | |||
| 87907 | 87907 | 47688 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1045 Sanchez St | 1 | 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) | |||
| 91542 | 91542 | 47689 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1045 Sanchez St | 2 | 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) | |||
| 52087 | 52087 | 141987 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1047 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004139.84 | 2111815.1387 | 37.7788758968254 | -122.429252898528 | (37.7788758968254, -122.429252898528) | |||
| 53773 | 53773 | 223550 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1047 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5997652.48315 | 2106877.54396 | 37.7649491371199 | -122.451338921264 | (37.7649491371199, -122.451338921264) | |||
| 36646 | 36646 | 191087 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1050 18th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6014377.05875 | 2105781.79588 | 37.762883905197 | -122.393415683687 | (37.762883905197, -122.393415683687) | ||||
| 40591 | 40591 | 191084 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1050 18th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6014440.039609999 | 2105781.9689 | 37.7628878793072 | -122.393197865211 | (37.7628878793072, -122.393197865211) | ||||
| 51462 | 51462 | 191085 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1050 18th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6014420.63086 | 2105780.4317900003 | 37.762882580487 | -122.393264886285 | (37.762882580487, -122.393264886285) | ||||
| 73147 | 73147 | 191083 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1050 18th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6014452.20409 | 2105784.61715 | 37.7628958266015 | -122.39315597748998 | (37.7628958266015, -122.39315597749) | ||||
| 153372 | 153372 | 191086 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1050 18th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6014399.78897 | 2105779.8886 | 37.762879931094 | -122.393336933676 | (37.762879931094, -122.393336933676) | |||
| 129944 | 129944 | 66093 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1052 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/08/1990 12:00:00 AM | 16 | Permit Number 29138 | 6007872.07049 | 2119612.96826 | 37.8004974059005 | -122.41689421958799 | (37.8004974059005, -122.416894219588) | |
| 70646 | 70646 | 191068 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 106 Langton St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6010213.082230001 | 2110716.2431099997 | 37.776200530977896 | -122.40816552573901 | (37.7762005309779, -122.408165525739) | |||
| 87110 | 87110 | 46247 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 107 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/11/2006 12:00:00 AM | Permit Number 44535 | 5998156.93644181 | 2106198.33011415 | 37.7631130593676 | -122.449545206751 | (37.7631130593676, -122.449545206751) | ||
| 88946 | 88946 | 46246 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 107 Alma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2002 12:00:00 AM | Permit Number 44535 | 5998156.93644181 | 2106198.33011415 | 37.7631130593676 | -122.449545206751 | (37.7631130593676, -122.449545206751) | |||
| 140728 | 140728 | 117303 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1075 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778518 | 6009488.7 | 2102920.1 | 37.754753524299005 | -122.410120841459 | (37.754753524299, -122.410120841459) | ||
| 81763 | 81763 | 47096 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 108 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45078 | 5996526.30490934 | 2112305.63939243 | 37.7797887262832 | -122.455626444814 | (37.7797887262832, -122.455626444814) | ||
| 140681 | 140681 | 47097 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 108 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45078 | 5996526.30490934 | 2112305.63939243 | 37.7797887262832 | -122.455626444814 | (37.7797887262832, -122.455626444814) | ||
| 153913 | 153913 | 51031 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1085 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 6 | Permit Number 47506 | 6011820.571409999 | 2089923.6648799998 | 37.7191984823926 | -122.40114336739799 | (37.7191984823926, -122.401143367398) | ||
| 169080 | 169080 | 51030 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1085 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 5 | Permit Number 47506 | 6011828.2745 | 2089900.6227799999 | 37.7191356431884 | -122.401115122362 | (37.7191356431884, -122.401115122362) | ||
| 70733 | 70733 | 71444 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1088 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | 6012034.251 | 2119394.2595 | 37.8001301227773 | -122.402475922527 | (37.8001301227773, -122.402475922527) | ||
| 187496 | 187496 | 73575 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1088 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 6 | 6012040.57569 | 2119341.71147 | 37.7999861916725 | -122.40245033952 | (37.7999861916725, -122.40245033952) | ||
| 57664 | 57664 | 223451 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 109 Alma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998103.07896 | 2106202.6156900004 | 37.7631217452986 | -122.44973178961 | (37.7631217452986, -122.44973178961) | |||
| 132432 | 132432 | 223450 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 109 Alma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998091.45259 | 2106201.0539 | 37.7631167918352 | -122.449771888566 | (37.7631167918352, -122.449771888566) | |||
| 82916 | 82916 | 90553 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1090 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992323.628330001 | 2110709.32554 | 37.7751636133682 | -122.470048949636 | (37.7751636133682, -122.470048949636) | ||
| 106867 | 106867 | 90552 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1090 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992344.80015 | 2110709.94859 | 37.77516654798529 | -122.46997575761499 | (37.7751665479853, -122.469975757615) | ||
| 130201 | 130201 | 30935 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1093 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2016 12:00:00 AM | 1 | Permit Number 775227 | 5995910.73733 | 2091157.41519 | 37.721685664556496 | -122.45622643891501 | (37.7216856645565, -122.456226438915) | |
| 157490 | 157490 | 30936 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1093 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2016 12:00:00 AM | 1 | Permit Number 775227 | 5995909.9946800005 | 2091121.8923 | 37.7215880844914 | -122.45622643891501 | (37.7215880844914, -122.456226438915) | |
| 121285 | 121285 | 95807 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 10993 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767551 | 6014326.8 | 2102083.7 | 37.752726939242 | -122.393330710599 | (37.752726939242, -122.393330710599) | |
| 76579 | 76579 | 248098 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 11 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010471.50543 | 2099820.33523 | 37.746297290485295 | -122.40650360018 | (37.7462972904853, -122.40650360018) | |||
| 3943 | 3943 | 216737 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 11 Lee Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/04/2017 02:31:00 PM | 3 | Width 2ft | 5996481.70655 | 2089974.5093900003 | 37.7184704425356 | -122.45416736555799 | (37.7184704425356, -122.454167365558) | ||
| 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) |
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");