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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 1527 | 1527 | 103937 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2300 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2013 12:00:00 AM | 26 | Permit Number 770288 | 6008943.2 | 2121170.5 | 37.804834190774 | -122.413297871125 | (37.804834190774, -122.413297871125) | ||
| 2608 | 2608 | 115877 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1880 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | Permit Number 775798 | 6005144.10497 | 2117158.82947 | 37.7936051429156 | -122.42615927543999 | (37.7936051429156, -122.42615927544) | ||
| 3953 | 3953 | 44431 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 859 Prague St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/2017 11:19:00 AM | 3 | Permit Number 43768 | 6002228.37284 | 2086951.06128 | 37.71049657842789 | -122.434087529513 | (37.7104965784279, -122.434087529513) | |
| 3991 | 3991 | 44420 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 859 Prague St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2017 08:03:00 AM | 3 | Permit Number 43768 | 6002331.23577 | 2087017.31055 | 37.710684321803896 | -122.433736745364 | (37.7106843218039, -122.433736745364) | |
| 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) | |||||
| 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) | ||
| 7076 | 7076 | 66494 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2454 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2014 12:00:00 AM | 3 | Permit Number 29655 | 6001767.8317 | 2114666.7908 | 37.7865712397422 | -122.437662882365 | (37.7865712397422, -122.437662882365) | |
| 7482 | 7482 | 115876 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1880 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | Permit Number 775798 | 6005184.1768 | 2117160.91115 | 37.793613123488996 | -122.426020771756 | (37.793613123489, -122.426020771756) | ||
| 9003 | 9003 | 33126 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2527 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774205 | 6000811.7731800005 | 2118925.97012 | 37.7982114272598 | -122.44127631424601 | (37.7982114272598, -122.441276314246) | |
| 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) | |||
| 10698 | 10698 | 117442 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 683 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778575 | 6002740.92134 | 2089524.8599 | 37.7175927411032 | -122.432499770158 | (37.7175927411032, -122.432499770158) | ||
| 10856 | 10856 | 108684 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 46 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | Permit Number 774614 | 6000319.87619 | 2088768.81693 | 37.71537922895679 | -122.44081399618601 | (37.7153792289568, -122.440813996186) | |
| 11339 | 11339 | 117430 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 724 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776863 | 6004182.226919999 | 2091583.55482 | 37.723327093656295 | -122.42766442668301 | (37.7233270936563, -122.427664426683) | ||
| 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) | |||||
| 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) | |||
| 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 | |||||||||
| 14340 | 14340 | 85536 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 110 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6007398.398469999 | 2109252.27561 | 37.7720228203246 | -122.41779851218901 | (37.7720228203246, -122.417798512189) | |||
| 14642 | 14642 | 85538 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 180 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007511.05272 | 2109187.82256 | 37.771852186555705 | -122.417404262918 | (37.7718521865557, -122.417404262918) | |||
| 15330 | 15330 | 85542 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 240 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007856.4505900005 | 2108988.3497099997 | 37.7713239085987 | -122.416195374412 | (37.7713239085987, -122.416195374412) | |||
| 15522 | 15522 | 85557 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 396 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6008653.68072 | 2108532.35146 | 37.7701166389055 | -122.41340545620199 | (37.7701166389055, -122.413405456202) | |||
| 15574 | 15574 | 85539 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 180 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 6 | 6007548.32218 | 2109164.7314400002 | 37.771790880665606 | -122.417273708325 | (37.7717908806656, -122.417273708325) | |||
| 15800 | 15800 | 85533 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 110 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6007332.25294 | 2109288.61069 | 37.7721188652314 | -122.418029891562 | (37.7721188652314, -122.418029891562) | |||
| 16619 | 16619 | 85558 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 396 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6008677.32979 | 2108520.19339 | 37.770084583473704 | -122.413322794134 | (37.7700845834737, -122.413322794134) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 20979 | 20979 | 85521 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2013 12:00:00 AM | 3 | 6008760.539183999 | 2108527.457431 | 37.7701092002187 | -122.413035486584 | (37.7701092002187, -122.413035486584) | |||
| 23564 | 23564 | 43029 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2131 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2000 12:00:00 AM | 6 | Permit Number 42891 | 6012151.06584 | 2101359.39792 | 37.7506170436447 | -122.400803954262 | (37.7506170436447, -122.400803954262) | ||
| 24422 | 24422 | 50532 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 315 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47171 | 5996679.82856356 | 2106618.62344586 | 37.764182465684705 | -122.454684361894 | (37.7641824656847, -122.454684361894) | |||
| 24451 | 24451 | 42139 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 583 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 5 | Permit Number 42434 | 5991253.848730001 | 2111457.82315 | 37.7771568827635 | -122.4738041366 | (37.7771568827635, -122.4738041366) | |
| 24645 | 24645 | 31679 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 4909 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35185 | 5997751.25621 | 2105611.0193 | 37.7614772360152 | -122.450905959737 | (37.7614772360152, -122.450905959737) | |
| 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) | |||
| 26893 | 26893 | 31681 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 59 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35187 | 5998307.66476 | 2107187.9506099997 | 37.7658389290403 | -122.44909518650101 | (37.7658389290403, -122.449095186501) | |
| 28172 | 28172 | 64537 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1448 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 4 | Permit Number 25419 | 6015877.1655 | 2094890.2503 | 37.73306121716389 | -122.38746743202299 | (37.7330612171639, -122.387467432023) | |
| 28518 | 28518 | 47405 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 545 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 6 | Permit Number 45316 | 5993431.14199 | 2111760.1937700002 | 37.778112976546396 | -122.466294232497 | (37.7781129765464, -122.466294232497) | |
| 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) | ||
| 29141 | 29141 | 45523 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 153 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2001 12:00:00 AM | 4 | Permit Number 44284 | 5996204.70963 | 2113340.17454 | 37.782610825272 | -122.456813820837 | (37.782610825272, -122.456813820837) | ||
| 29538 | 29538 | 33172 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2311 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37388 | 5986066.5372792 | 2098877.4979138 | 37.742312976384504 | -122.490822533573 | (37.7423129763845, -122.490822533573) | |
| 30000 | 30000 | 72470 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 955 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1996 12:00:00 AM | 7 | 6012030.25538 | 2119045.5342200003 | 37.7991723843595 | -122.402465214308 | (37.7991723843595, -122.402465214308) | ||
| 30399 | 30399 | 31893 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1997 12:00:00 AM | 8 | Permit Number 35323 | 6008432.94494 | 2108718.71395 | 37.770615950606704 | -122.41418216828501 | (37.7706159506067, -122.414182168285) | |
| 30583 | 30583 | 68237 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1775 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32032 | 6001656.99546 | 2121058.17098 | 37.8041139989306 | -122.438504449024 | (37.8041139989306, -122.438504449024) | |
| 30932 | 30932 | 74829 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 998 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | 6012078.13426 | 2119069.37262 | 37.7992405115981 | -122.402301213024 | (37.7992405115981, -122.402301213024) | ||
| 31314 | 31314 | 52821 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2850@ ANZA Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 1 | Permit Number 775537 | 5989762.54787 | 2111977.16007 | 37.7784963508186 | -122.479000957003 | (37.7784963508186, -122.479000957003) | ||
| 31343 | 31343 | 55507 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1660 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/25/1989 12:00:00 AM | 20 | Permit Number 23375 | 6004977.3709 | 2119202.3279 | 37.7992066440205 | -122.426881792584 | (37.7992066440205, -122.426881792584) | |
| 32189 | 32189 | 31714 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 122 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35214 | 5998115.883119999 | 2105983.06318 | 37.7625196419841 | -122.44967168249799 | (37.7625196419841, -122.449671682498) | |
| 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) | ||
| 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) | |
| 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) | ||||
| 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) | |
| 37880 | 37880 | 70231 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1993 12:00:00 AM | 5 | 6005265.5585 | 2110935.6138 | 37.7765246008409 | -122.425295984643 | (37.7765246008409, -122.425295984643) | ||
| 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) | ||
| 39678 | 39678 | 78352 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 647 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 5 | 6002178.01905 | 2090148.09572 | 37.71927207124 | -122.43449000133499 | (37.71927207124, -122.434490001335) | ||
| 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) | ||||
| 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) | |
| 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) | |
| 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) | ||
| 45452 | 45452 | 71627 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 955 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 5 | 6012042.50926 | 2118962.60831 | 37.798945373890604 | -122.402416977385 | (37.7989453738906, -122.402416977385) | ||
| 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) | ||
| 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) | |
| 47806 | 47806 | 70989 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1995 12:00:00 AM | 6 | 6008399.527430001 | 2108738.25581 | 37.770667730873 | -122.41429914310301 | (37.770667730873, -122.414299143103) | ||
| 48194 | 48194 | 72330 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2761 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 9 | 5995926.57923 | 2110675.1717 | 37.775277458656795 | -122.457583143432 | (37.7752774586568, -122.457583143432) | ||
| 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) | ||
| 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) | |
| 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) | ||||
| 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) | |
| 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) | ||
| 55728 | 55728 | 74929 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 39 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 7 | 6014021.820230001 | 2112985.48182 | 37.78264387125021 | -122.395148955186 | (37.7826438712502, -122.395148955186) |
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");