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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 541 | 541 | 251317 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 635 | 635 | 251315 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 644 | 644 | 251319 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 645 | 645 | 251316 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 1827 | 1827 | 251744 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 70 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002620.0 | 2086992.0 | 37.710631205907 | -122.43273690550899 | (37.710631205907, -122.432736905509) | ||||
| 1840 | 1840 | 251759 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 248 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001757.0 | 2086582.0 | 37.709456453529796 | -122.43569030601002 | (37.7094564535298, -122.43569030601) | ||||
| 1849 | 1849 | 251761 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 236 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001827.0 | 2086593.0 | 37.709490632951706 | -122.43544916105199 | (37.7094906329517, -122.435449161052) | ||||
| 1859 | 1859 | 251772 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 90x Seville St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002045.0 | 2087474.0 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | ||||
| 1861 | 1861 | 251780 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1219 Naples St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001110.0 | 2087312.0 | 37.7114241006266 | -122.437978695611 | (37.7114241006266, -122.437978695611) | ||||
| 1874 | 1874 | 251773 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 90x Seville St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002045.0 | 2087474.0 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | ||||
| 2026 | 2026 | 252856 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 926 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001578.0 | 2088750.0 | 37.7153991335272 | -122.43646402536001 | (37.7153991335272, -122.43646402536) | ||||
| 2035 | 2035 | 252855 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 926 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001578.0 | 2088750.0 | 37.7153991335272 | -122.43646402536001 | (37.7153991335272, -122.43646402536) | ||||
| 2516 | 2516 | 251771 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 90x Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002045.0 | 2087474.0 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | ||||
| 4475 | 4475 | 253631 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 39 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 6009957.290080001 | 2113442.89538 | 37.783672949399204 | -122.409242840109 | (37.7836729493992, -122.409242840109) | ||||
| 4506 | 4506 | 253629 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 123 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6009831.1503800005 | 2113653.7445799997 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | |||||
| 4520 | 4520 | 253628 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 123 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6009831.1503800005 | 2113653.7445799997 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | |||||
| 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) | |||
| 10212 | 10212 | 173910 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6006450.1 | 2109317.2 | 37.772147675466705 | -122.421083366581 | (37.7721476754667, -122.421083366581) | ||||
| 10213 | 10213 | 173644 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6006450.1 | 2109317.2 | 37.772147675466705 | -122.421083366581 | (37.7721476754667, -122.421083366581) | ||||
| 10216 | 10216 | 173911 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6006450.1 | 2109317.2 | 37.772147675466705 | -122.421083366581 | (37.7721476754667, -122.421083366581) | ||||
| 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 | |||||||||
| 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) | |||||
| 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 | |||||||||
| 17994 | 17994 | 49868 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 368 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46634 | 6003577.84688999 | 2095267.92973361 | 37.733409356185796 | -122.430016351279 | (37.7334093561858, -122.430016351279) | ||
| 18447 | 18447 | 51025 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 51 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | Permit Number 47502 | 6005670.67188859 | 2109250.29159524 | 37.7719199923513 | -122.423774718207 | (37.7719199923513, -122.423774718207) | |||
| 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) | ||
| 19100 | 19100 | 99391 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 19278 | 19278 | 39942 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 27 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | Permit Number 41213 | 6009741.23684285 | 2089425.45829631 | 37.7177142900305 | -122.408295747981 | (37.7177142900305, -122.408295747981) | ||
| 19422 | 19422 | 58438 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 905 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1979 12:00:00 AM | 3x3 | Permit Number 51484 | 5999161.38005537 | 2107089.77623283 | 37.7656181571992 | -122.446135313725 | (37.7656181571992, -122.446135313725) | ||
| 20657 | 20657 | 64543 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1547 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25426 | 6015321.62159268 | 2095235.25021997 | 37.7339777321734 | -122.389412195042 | (37.7339777321734, -122.389412195042) | ||
| 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) | |||
| 25410 | 25410 | 46998 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
| 28915 | 28915 | 42944 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 30 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42839 | 6007671.602079799 | 2107773.96917263 | 37.7679791099284 | -122.416748729284 | (37.7679791099284, -122.416748729284) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 77597 | 77597 | 56439 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 126 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1987 12:00:00 AM | Permit Number 12650 | 6005234.88834925 | 2109313.51101723 | 37.7720689675781 | -122.425286625875 | (37.7720689675781, -122.425286625875) | ||
| 77620 | 77620 | 66244 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 545 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29343 | 5995212.13315242 | 2091201.87256763 | 37.7217676067917 | -122.458644529473 | (37.7217676067917, -122.458644529473) | ||
| 77646 | 77646 | 58026 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 680 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1987 12:00:00 AM | Permit Number 16994 | 6008648.68681502 | 2095709.61951023 | 37.734908020909295 | -122.41251618319201 | (37.7349080209093, -122.412516183192) | ||
| 77926 | 77926 | 67015 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 379 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1992 12:00:00 AM | Permit Number 30370 | 5995013.54183778 | 2088325.60684353 | 37.7138586475181 | -122.459122836548 | (37.7138586475181, -122.459122836548) | ||
| 78105 | 78105 | 88740 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 92 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51675 | 6004299.0 | 2109043.0 | 37.7712732924091 | -122.428504653556 | (37.7712732924091, -122.428504653556) | ||
| 78440 | 78440 | 46109 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 798 Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2001 12:00:00 AM | 3x3 | Permit Number 44472 | 5997167.07493712 | 2107760.6930909 | 37.767346232554004 | -122.453081574039 | (37.767346232554, -122.453081574039) | ||
| 78498 | 78498 | 46990 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
| 78538 | 78538 | 114900 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1518 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2015 12:00:00 AM | Permit Number 775911 | 5994035.5 | 2105147.2 | 37.7599902919139 | -122.46372345992201 | (37.7599902919139, -122.463723459922) | |||
| 78571 | 78571 | 63380 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 302 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1987 12:00:00 AM | Permit Number 23960 | 6006871.71117456 | 2095746.20400929 | 37.734908588108894 | -122.41866241778999 | (37.7349085881089, -122.41866241779) | ||
| 78597 | 78597 | 48554 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 378 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2015 12:00:00 AM | Permit Number 776479 | 5990306.99232217 | 2112830.037025 | 37.7808697161231 | -122.477179880009 | (37.7808697161231, -122.477179880009) | |||
| 78615 | 78615 | 64541 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1513 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25424 | 6015494.68772587 | 2095105.29398738 | 37.7336304924024 | -122.38880477766199 | (37.7336304924024, -122.388804777662) | ||
| 78728 | 78728 | 87868 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 65 Avila St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50830 | 6001059.0 | 2119911.0 | 37.800930138770106 | -122.440491523393 | (37.8009301387701, -122.440491523393) | ||
| 78772 | 78772 | 38319 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1810 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | Permit Number 774280 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.41346579017299 | (37.7684292621485, -122.413465790173) | |||
| 79042 | 79042 | 67217 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 412 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | Permit Number 30673 | 6007859.73782149 | 2096940.24415247 | 37.738242738602295 | -122.415330954317 | (37.7382427386023, -122.415330954317) | ||
| 79116 | 79116 | 39611 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 786 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2001 12:00:00 AM | 6x6 | Permit Number 44486 | 5998641.21928003 | 2107708.61027258 | 37.7672876005221 | -122.447978986539 | (37.7672876005221, -122.447978986539) | |
| 79141 | 79141 | 58102 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 251 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1987 12:00:00 AM | Permit Number 23965 | 6006689.2765112 | 2095813.61990221 | 37.735083424277796 | -122.41929794049 | (37.7350834242778, -122.41929794049) | ||
| 79266 | 79266 | 112816 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 575 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2015 12:00:00 AM | Permit Number 773547 | 5992490.3 | 2111549.9 | 37.7774812369392 | -122.46953360311001 | (37.7774812369392, -122.46953360311) | |||
| 79353 | 79353 | 39646 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 72 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41040 | 5994176.513717599 | 2090402.3957613998 | 37.719512859484794 | -122.462166418076 | (37.7195128594848, -122.462166418076) | ||
| 79370 | 79370 | 34891 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 95 Ward St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1997 12:00:00 AM | Permit Number 38498 | 6011846.48740204 | 2089823.39477464 | 37.718924606748296 | -122.401046743519 | (37.7189246067483, -122.401046743519) | |||
| 79535 | 79535 | 96590 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 79833 | 79833 | 83354 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1322-24 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50904 | 5992731.01277957 | 2106452.183429 | 37.763498178334 | -122.468329951548 | (37.763498178334, -122.468329951548) | ||
| 80088 | 80088 | 63309 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 320 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1987 12:00:00 AM | Permit Number 23875 | 6009653.46041158 | 2099624.96602916 | 37.7457150505348 | -122.409318529175 | (37.7457150505348, -122.409318529175) | ||
| 80159 | 80159 | 49866 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 368 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46634 | 6003577.84688999 | 2095267.92973361 | 37.733409356185796 | -122.430016351279 | (37.7334093561858, -122.430016351279) | ||
| 80401 | 80401 | 63315 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 391 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/1987 12:00:00 AM | Permit Number 23882 | 6009191.36429374 | 2100247.35620947 | 37.7473980957636 | -122.41096034771499 | (37.7473980957636, -122.410960347715) | ||
| 80576 | 80576 | 67198 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 49 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30650 | 5998389.107657599 | 2106230.44875795 | 37.7632145281987 | -122.448744521857 | (37.7632145281987, -122.448744521857) | ||
| 80615 | 80615 | 66647 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 972 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/2000 12:00:00 AM | Permit Number 29858 | 6010191.86940681 | 2103559.76448884 | 37.756549288119004 | -122.407734178809 | (37.756549288119, -122.407734178809) | ||
| 80624 | 80624 | 50758 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 286 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2004 12:00:00 AM | 3x3 | Permit Number 47298 | 5996260.1 | 2110808.5 | 37.7756626959421 | -122.456439068917 | (37.7756626959421, -122.456439068917) | ||
| 80639 | 80639 | 49857 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 338 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46630 | 6003649.21999567 | 2095274.80996329 | 37.733432289658396 | -122.429770085042 | (37.7334322896584, -122.429770085042) | ||
| 80822 | 80822 | 64549 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1414 Lane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25432 | 6015539.44017214 | 2095047.54254922 | 37.7334743989165 | -122.38864602407699 | (37.7334743989165, -122.388646024077) | ||
| 80859 | 80859 | 54276 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1459 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/1972 12:00:00 AM | 5x6 | Permit Number 10029 | 5993329.78711521 | 2105558.33296163 | 37.761078465039 | -122.466194038055 | (37.761078465039, -122.466194038055) | ||
| 80867 | 80867 | 46871 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1201 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.41504078297899 | (37.7958005639716, -122.415040782979) | ||
| 81001 | 81001 | 114444 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 140 LOOMIS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6010781.0 | 2097775.0 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | ||||
| 81178 | 81178 | 64551 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1315 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25434 | 6016281.43381852 | 2094844.2486814 | 37.7329572884599 | -122.386066550856 | (37.7329572884599, -122.386066550856) | ||
| 81221 | 81221 | 52435 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1808 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | Permit Number 48549 | 6004868.1713119 | 2115451.13806854 | 37.7889006530789 | -122.426992345901 | (37.7889006530789, -122.426992345901) | ||
| 81379 | 81379 | 44051 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1714 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | Permit Number 43580 | 5993441.9028453 | 2103807.69125105 | 37.7562781258297 | -122.465679089291 | (37.7562781258297, -122.465679089291) | |||
| 81679 | 81679 | 63377 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 308 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1987 12:00:00 AM | Permit Number 23957 | 6006914.1385317 | 2095742.66094638 | 37.734901248262794 | -122.41851548006399 | (37.7349012482628, -122.418515480064) | ||
| 81703 | 81703 | 96593 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 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) | ||
| 81878 | 81878 | 64533 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1423 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1988 12:00:00 AM | Permit Number 25415 | 6015974.60065069 | 2094744.26862441 | 37.732665776815 | -122.387120391311 | (37.732665776815, -122.387120391311) | ||
| 82084 | 82084 | 50062 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 259 Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46792 | 6004623.22870051 | 2103939.22214247 | 37.7572778811094 | -122.427019561527 | (37.7572778811094, -122.427019561527) | ||
| 82203 | 82203 | 99384 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 82340 | 82340 | 37491 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1653 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39960 | 5990646.15475208 | 2106518.49529305 | 37.7635596145943 | -122.47554557705799 | (37.7635596145943, -122.475545577058) | ||
| 82390 | 82390 | 102355 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 176X Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012524.1 | 2106651.0 | 37.765167421152206 | -122.399885503722 | (37.7651674211522, -122.399885503722) | |||||
| 82440 | 82440 | 103917 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fitzgerald Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.722099845446294 | -122.39319756972799 | (37.7220998454463, -122.393197569728) | |||
| 82642 | 82642 | 45299 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44138 | 6007485.11382992 | 2096559.26498899 | 37.7371755914125 | -122.416599241748 | (37.7371755914125, -122.416599241748) | ||
| 82654 | 82654 | 88828 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1321 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52530 | 6000678.0 | 2109601.0 | 37.772599843548704 | -122.44106985288201 | (37.7725998435487, -122.441069852882) | ||
| 82692 | 82692 | 46326 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3649 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/2002 12:00:00 AM | Permit Number 44579 | 6005434.40207527 | 2102522.16800234 | 37.7534328160504 | -122.424113430233 | (37.7534328160504, -122.424113430233) | ||
| 82715 | 82715 | 44020 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 67 Ruth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2000 12:00:00 AM | Permit Number 43561 | 6001434.84212338 | 2091667.66659412 | 37.7234022554793 | -122.437167620555 | (37.7234022554793, -122.437167620555) | |||
| 82776 | 82776 | 39666 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 724 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41056 | 5993542.587203501 | 2090669.62247691 | 37.7202100790578 | -122.464377044443 | (37.7202100790578, -122.464377044443) | ||
| 82946 | 82946 | 41963 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 640 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | Permit Number 46995 | 5993511.89759083 | 2094752.0237459 | 37.731417587340005 | -122.46477943358101 | (37.73141758734, -122.464779433581) | ||
| 83078 | 83078 | 103456 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 410 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6003658.0 | 2091068.0 | 37.721881827041 | -122.429439831937 | (37.721881827041, -122.429439831937) | ||||
| 83341 | 83341 | 99397 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 83456 | 83456 | 99392 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 83493 | 83493 | 39119 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 552 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40804 | 6007242.03781645 | 2104093.13141214 | 37.7578482165395 | -122.417973583722 | (37.7578482165395, -122.417973583722) | ||
| 84025 | 84025 | 122788 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1655 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007172.0 | 2109097.0 | 37.771583727056104 | -122.418570631079 | (37.7715837270561, -122.418570631079) |
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");