trees
2,421 rows where qSpecies_id = 8 sorted by PlotSize
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24334 | 48686 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2002 12:00:00 AM | Permit Number 45967 | 5995920.95422115 | 2113779.82862982 | 37.7838017006932 | -122.457827310949 | (37.7838017006932, -122.457827310949) | 11 | 6 | 1 | 54 | 31 | |||
| 24478 | 69061 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1259 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33069 | 5992353.79544263 | 2106887.79671216 | 37.764672462389 | -122.469666328544 | (37.764672462389, -122.469666328544) | 11 | 8 | 11 | 56 | 12 | ||
| 24551 | 62760 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 409 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23114 | 5993046.38592213 | 2104560.1415905 | 37.7583213372073 | -122.467101616449 | (37.7583213372073, -122.467101616449) | 1 | 8 | 4 | 56 | 12 | ||
| 25666 | 84783 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 280 Charter Oak Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2007 12:00:00 AM | 7 | Permit No. 49320 | 6010967.59518 | 2095106.34893 | 37.7333814341037 | -122.404456411357 | (37.7333814341037, -122.404456411357) | 10 | 3 | 8 | 58 | 1 | ||
| 25797 | 35077 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 25810 | 48572 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Shields St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2002 12:00:00 AM | Permit Number 45886 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | 9 | 8 | 6 | 64 | 24 | |||
| 26008 | 54985 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 610 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 1 | Permit Number 10863 | 5990982.11543 | 2111201.05221 | 37.7764361179599 | -122.474725393074 | (37.7764361179599, -122.474725393074) | 11 | 6 | 2 | 54 | 26 | ||
| 26406 | 33945 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2858 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | 8 | Permit Number 45901 | 6004794.02705 | 2119422.76429 | 37.7998015374823 | -122.427531938546 | (37.7998015374823, -122.427531938546) | 13 | 9 | 1 | 57 | 17 | |
| 26610 | 103937 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2300 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2013 12:00:00 AM | 26 | Permit Number 770288 | 6008943.2 | 2121170.5 | 37.804834190774 | -122.413297871125 | (37.804834190774, -122.413297871125) | 3 | 1 | 10 | 308 | 23 | ||
| 27050 | 44420 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 859 Prague St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2017 08:03:00 AM | 3 | Permit Number 43768 | 6002331.23577 | 2087017.31055 | 37.7106843218039 | -122.433736745364 | (37.7106843218039, -122.433736745364) | 9 | 7 | 6 | 28861 | 5 | |
| 27234 | 69058 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1243 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33066 | 5992350.1648235 | 2106993.32933415 | 37.7649620171359 | -122.469686569205 | (37.7649620171359, -122.469686569205) | 11 | 8 | 11 | 56 | 12 | ||
| 27943 | 31680 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 55 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35186 | 5998329.53554 | 2107192.57672 | 37.7658528820189 | -122.44901987369 | (37.7658528820189, -122.44901987369) | 15 | 5 | 11 | 29492 | 9 | |
| 27976 | 67374 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1020 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | 6 | Permit Number 30868 | 5992412.40492 | 2111393.18626 | 37.7770464413981 | -122.469791653286 | (37.7770464413981, -122.469791653286) | 11 | 6 | 2 | 54 | 11 | |
| 28255 | 39127 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 739 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40808 | 6007354.16846215 | 2103008.55652832 | 37.7548765329449 | -122.417508922955 | (37.7548765329449, -122.417508922955) | 2 | 4 | 7 | 28859 | 19 | ||
| 28303 | 56711 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1659 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2015 12:00:00 AM | Permit Number 774226 | 5983116.27836009 | 2103843.81660781 | 37.7557763190096 | -122.501390749613 | (37.7557763190096, -122.501390749613) | 1 | 8 | 3 | 56 | 35 | |||
| 29323 | 84791 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 499x Lisbon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2007 12:00:00 AM | Permit No. 49321 | 6002176 | 2090606 | 37.7205292596373 | -122.434529703705 | (37.7205292596373, -122.434529703705) | 9 | 7 | 6 | 28861 | 5 | |||
| 29773 | 63456 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 801 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1987 12:00:00 AM | Permit Number 24046 | 6007615.99374583 | 2095696.52300413 | 37.7348140509231 | -122.416085647719 | (37.7348140509231, -122.416085647719) | 2 | 7 | 7 | 28859 | 2 | ||
| 29985 | 59550 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 374 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24919 | 6003521.85163486 | 2098666.09972032 | 37.7427367824396 | -122.43045232079 | (37.7427367824396, -122.43045232079) | 2 | 7 | 5 | 63 | 22 | ||
| 30001 | 115382 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 625 Moultrie St | 1 | Side Yard : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776180 | 6007689.5 | 2096426.5 | 37.7368225406079 | -122.415883184956 | (37.7368225406079, -122.415883184956) | 2 | 7 | 7 | 28859 | 2 | ||
| 30184 | 68222 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1324 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 7 | Permit Number 32012 | 5991360.03028 | 2113443.03788 | 37.7826138859716 | -122.473581670612 | (37.7826138859716, -122.473581670612) | 11 | 6 | 2 | 54 | 26 | |
| 30235 | 35086 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 30387 | 60896 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1226 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1992 12:00:00 AM | Permit Number 20684 | 5995496.17178877 | 2107213.04806332 | 37.7657466388052 | -122.458821302083 | (37.7657466388052, -122.458821302083) | 15 | 5 | 11 | 56 | 12 | ||
| 30539 | 67015 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 379 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30370 | 5995013.54183778 | 2088325.60684353 | 37.7138586475181 | -122.459122836548 | (37.7138586475181, -122.459122836548) | 9 | 8 | 6 | 28861 | 24 | ||
| 30640 | 38839 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 947 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | Permit Number 40668 | 5992575.8845778 | 2114792.63949005 | 37.7863898589993 | -122.469473646902 | (37.7863898589993, -122.469473646902) | 11 | 6 | 2 | 54 | 11 | ||
| 30817 | 51030 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1085 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 5 | Permit Number 47506 | 6011828.2745 | 2089900.62278 | 37.7191356431884 | -122.401115122362 | (37.7191356431884, -122.401115122362) | 10 | 7 | 8 | 309 | 28 | ||
| 31066 | 56439 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 126 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 12650 | 6005234.88834925 | 2109313.51101723 | 37.7720689675781 | -122.425286625875 | (37.7720689675781, -122.425286625875) | 7 | 9 | 11 | 28852 | 10 | ||
| 31788 | 64128 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 627 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24899 | 6002528.44281747 | 2098851.45130448 | 37.7431893908467 | -122.433900486749 | (37.7431893908467, -122.433900486749) | 2 | 7 | 5 | 63 | 7 | ||
| 31891 | 63321 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 308 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1987 12:00:00 AM | Permit Number 23894 | 6009704.28478725 | 2099627.84542916 | 37.7457258041449 | -122.409142988334 | (37.7457258041449, -122.409142988334) | 2 | 7 | 7 | 28859 | 2 | ||
| 32015 | 61986 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3219 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1985 12:00:00 AM | 13 | Permit Number 22053 | 6004150.64271 | 2120237.53433 | 37.8020022738516 | -122.429816434187 | (37.8020022738516, -122.429816434187) | 13 | 9 | 1 | 57 | 17 | |
| 32023 | 85527 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301X 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008215.27395 | 2108839.588309 | 37.7709356143391 | -122.414943653714 | (37.7709356143391, -122.414943653714) | 8 | 2 | 9 | 28853 | 19 | |||
| 32261 | 223373 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Bosworth St | 7 | Front Yard : Yard | Tree | Private 2 | 17 | 6003068.252 | 2095170.80318 | 37.7331137949537 | -122.431771230282 | (37.7331137949537, -122.431771230282) | 2 | 7 | 5 | 28861 | 25 | ||||
| 32297 | 48573 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Shields St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2002 12:00:00 AM | Permit Number 45886 | 5993237.92929814 | 2089815.21510238 | 37.7178465167843 | -122.465368104118 | (37.7178465167843, -122.465368104118) | 9 | 8 | 6 | 64 | 24 | |||
| 32577 | 35506 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3451 22nd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38909 | 6005392.68349986 | 2103106.02983212 | 37.75503360932 | -122.424299225131 | (37.75503360932, -122.424299225131) | 2 | 4 | 5 | 28859 | 19 | ||
| 32693 | 46869 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.415040782979 | (37.7958005639716, -122.415040782979) | 5 | 1 | 10 | 28858 | 21 | ||
| 32770 | 60516 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 273 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1982 12:00:00 AM | Permit Number 20119 | 6004763.14449697 | 2099853.52664846 | 37.7460674222913 | -122.42624480255 | (37.7460674222913, -122.42624480255) | 2 | 7 | 5 | 63 | 22 | ||
| 32978 | 66244 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 545 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29343 | 5995212.13315242 | 2091201.87256763 | 37.7217676067917 | -122.458644529473 | (37.7217676067917, -122.458644529473) | 9 | 8 | 6 | 28861 | 24 | ||
| 33184 | 31346 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 5 | Permit Number 34957 | 6004784.8126 | 2111056.6827 | 37.7768298546653 | -122.426967648313 | (37.7768298546653, -122.426967648313) | 7 | 9 | 11 | 28852 | 10 | |
| 33503 | 64537 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1448 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | 4 | Permit Number 25419 | 6015877.1655 | 2094890.2503 | 37.7330612171639 | -122.387467432023 | (37.7330612171639, -122.387467432023) | 10 | 3 | 8 | 58 | 1 | |
| 33909 | 71627 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 955 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1995 12:00:00 AM | 5 | 6012042.50926 | 2118962.60831 | 37.7989453738906 | -122.402416977385 | (37.7989453738906, -122.402416977385) | 3 | 1 | 10 | 308 | 23 | ||
| 34097 | 115876 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1880 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | Permit Number 775798 | 6005184.1768 | 2117160.91115 | 37.793613123489 | -122.426020771756 | (37.793613123489, -122.426020771756) | 13 | 9 | 1 | 28858 | 27 | ||
| 34618 | 63613 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 191 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1987 12:00:00 AM | Permit Number 24252 | 6005229.19307431 | 2109538.39058576 | 37.7726861107413 | -122.425322331795 | (37.7726861107413, -122.425322331795) | 7 | 9 | 11 | 28852 | 10 | ||
| 34948 | 63791 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4079 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24477 | 6003353.40286408 | 2101237.77442121 | 37.7497884585709 | -122.43121829162 | (37.7497884585709, -122.43121829162) | 2 | 4 | 5 | 28862 | 22 | ||
| 35252 | 31682 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 61 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 10 | Permit Number 35188 | 5998292.66632 | 2107186.56904 | 37.765834277768 | -122.449146963179 | (37.765834277768, -122.449146963179) | 15 | 5 | 11 | 29492 | 9 | |
| 35395 | 64964 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1649 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1989 12:00:00 AM | 12 | Permit Number 25999 | 6005045.10624 | 2119511.23081 | 37.8000586419391 | -122.426669414059 | (37.8000586419391, -122.426669414059) | 13 | 9 | 1 | 57 | 17 | |
| 35633 | 246625 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3300 Harrison St | 3 | Side Yard : Yard | Tree | Private 2 | 1 | 6009033.3388 | 2099395.8346 | 37.7450511430894 | -122.411446641942 | (37.7450511430894, -122.411446641942) | 2 | 7 | 7 | 28859 | 2 | ||||
| 35739 | 37602 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 510 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/26/1998 12:00:00 AM | 0 | Permit Number 40029 | 5992226.61347 | 2111944.07676 | 37.7785482961825 | -122.470474488792 | (37.7785482961825, -122.470474488792) | 11 | 6 | 2 | 54 | 11 | |
| 36476 | 115877 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1880 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | Permit Number 775798 | 6005144.10497 | 2117158.82947 | 37.7936051429156 | -122.42615927544 | (37.7936051429156, -122.42615927544) | 13 | 9 | 1 | 28858 | 27 | ||
| 36552 | 37407 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1710 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39887 | 6002579.2352778 | 2100599.04049757 | 37.7479907436881 | -122.433849744568 | (37.7479907436881, -122.433849744568) | 2 | 4 | 5 | 63 | 22 | |||
| 36614 | 40677 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 195 Maynard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2015 12:00:00 AM | 1 | Permit Number 774326 | 6004652.68968 | 2093800.00562 | 37.7294395787702 | -122.426195845473 | (37.7294395787702, -122.426195845473) | 9 | 7 | 6 | 28861 | 5 | |
| 36832 | 64890 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2479 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1989 12:00:00 AM | Permit Number 25916 | 5990747.37657328 | 2098534.47311176 | 37.7416434544453 | -122.474612755594 | (37.7416434544453, -122.474612755594) | 1 | 8 | 4 | 29491 | 40 | ||
| 36881 | 46985 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | 5 | Permit Number 44999 | 6012611.41785 | 2101473.70376 | 37.7509565692018 | -122.399220032275 | (37.7509565692018, -122.399220032275) | 10 | 3 | 8 | 28856 | 1 | ||
| 37659 | 62959 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1175 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 14 | Permit Number 23345 | 6008001.56121 | 2118185.8038 | 37.7965860510683 | -122.416344986535 | (37.7965860510683, -122.416344986535) | 5 | 1 | 10 | 28858 | 21 | |
| 37755 | 39665 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 720 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41055 | 5993542.26347395 | 2090641.85281267 | 37.7201338116039 | -122.464376148313 | (37.7201338116039, -122.464376148313) | 9 | 8 | 6 | 64 | 24 | ||
| 37767 | 35299 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4128 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/1998 12:00:00 AM | Permit Number 38772 | 6002342.17007059 | 2101820.0635556 | 37.7513299284774 | -122.434756807393 | (37.7513299284774, -122.434756807393) | 2 | 4 | 5 | 28862 | 22 | |||
| 37859 | 46993 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
| 38276 | 52807 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
| 38299 | 66118 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 262 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29177 | 6004443.55987266 | 2109134.3816324 | 37.771532383715 | -122.428011127655 | (37.771532383715, -122.428011127655) | 7 | 9 | 11 | 28852 | 10 | ||
| 38375 | 115384 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 324 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777467 | 6006881.6 | 2096254.2 | 37.7363039898307 | -122.418664241464 | (37.7363039898307, -122.418664241464) | 2 | 7 | 7 | 28859 | 2 | ||
| 38592 | 45299 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44138 | 6007485.11382992 | 2096559.26498899 | 37.7371755914125 | -122.416599241748 | (37.7371755914125, -122.416599241748) | 2 | 7 | 7 | 28859 | 2 | ||
| 38599 | 48554 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 378 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2015 12:00:00 AM | Permit Number 776479 | 5990306.99232217 | 2112830.037025 | 37.7808697161231 | -122.477179880009 | (37.7808697161231, -122.477179880009) | 11 | 6 | 2 | 55 | 26 | |||
| 39141 | 66232 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 218 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | 12 | Permit Number 29329 | 5997099.27039938 | 2089468.87131755 | 37.7171174718407 | -122.451996253737 | (37.7171174718407, -122.451996253737) | 9 | 8 | 6 | 28861 | 24 | |
| 39751 | 96590 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 39889 | 38861 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1550 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 4 | Permit Number 40688 | 5989338.7682 | 2104794.677 | 37.7587505988826 | -122.479941205975 | (37.7587505988826, -122.479941205975) | 1 | 8 | 3 | 56 | 35 | |
| 40773 | 41963 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 640 Darien Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | Permit Number 46995 | 5993511.89759083 | 2094752.0237459 | 37.73141758734 | -122.464779433581 | (37.73141758734, -122.464779433581) | 9 | 8 | 4 | 59 | 40 | ||
| 40787 | 64563 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/1988 12:00:00 AM | 12 | Permit Number 25455 | 6009863.09945 | 2117549.8357 | 37.7949443413606 | -122.409858709005 | (37.7949443413606, -122.409858709005) | 3 | 1 | 10 | 28857 | 4 | |
| 42729 | 64533 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1423 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1988 12:00:00 AM | Permit Number 25415 | 6015974.60065069 | 2094744.26862441 | 37.732665776815 | -122.387120391311 | (37.732665776815, -122.387120391311) | 10 | 3 | 8 | 58 | 1 | ||
| 42964 | 52803 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 4 | Permit Number 48835 | 6013662.91964 | 2104110.04081 | 37.7582539273014 | -122.395768516112 | (37.7582539273014, -122.395768516112) | 10 | 3 | 8 | 28856 | 29 | ||
| 43045 | 63309 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1987 12:00:00 AM | Permit Number 23875 | 6009653.46041158 | 2099624.96602916 | 37.7457150505348 | -122.409318529175 | (37.7457150505348, -122.409318529175) | 2 | 7 | 7 | 28859 | 2 | ||
| 43105 | 85526 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 301X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008215.27395 | 2108839.588309 | 37.7709356143391 | -122.414943653714 | (37.7709356143391, -122.414943653714) | 8 | 2 | 9 | 28853 | 19 | |||
| 43406 | 31661 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4812 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1995 12:00:00 AM | 8 | Permit Number 35169 | 5998134.62707 | 2105673.01843 | 37.7616694094477 | -122.449584512135 | (37.7616694094477, -122.449584512135) | 15 | 5 | 11 | 29492 | 9 | |
| 43469 | 64884 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2550 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/1989 12:00:00 AM | 8 | Permit Number 25910 | 5989263.5772 | 2097984.1265 | 37.7400462586589 | -122.479702916678 | (37.7400462586589, -122.479702916678) | 1 | 8 | 3 | 29491 | 35 | |
| 43567 | 30935 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1093 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2016 12:00:00 AM | 1 | Permit Number 775227 | 5995910.73733 | 2091157.41519 | 37.7216856645565 | -122.456226438915 | (37.7216856645565, -122.456226438915) | 9 | 8 | 6 | 28861 | 24 | |
| 43995 | 67217 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 412 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1992 12:00:00 AM | Permit Number 30673 | 6007859.73782149 | 2096940.24415247 | 37.7382427386023 | -122.415330954317 | (37.7382427386023, -122.415330954317) | 2 | 7 | 7 | 28859 | 2 | ||
| 44430 | 45523 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 153 Jordan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2001 12:00:00 AM | 4 | Permit Number 44284 | 5996204.70963 | 2113340.17454 | 37.782610825272 | -122.456813820837 | (37.782610825272, -122.456813820837) | 11 | 6 | 1 | 54 | 31 | ||
| 44433 | 94516 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1106X Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 08/27/2010 12:00:00 AM | 2 | Permit Number 53703 | 6012787.7377 | 2102360.94736 | 37.7534025731789 | -122.398672553793 | (37.7534025731789, -122.398672553793) | 10 | 3 | 8 | 28856 | 29 | ||
| 44731 | 112816 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 575 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2015 12:00:00 AM | Permit Number 773547 | 5992490.3 | 2111549.9 | 37.7774812369392 | -122.46953360311 | (37.7774812369392, -122.46953360311) | 11 | 6 | 2 | 54 | 11 | |||
| 44789 | 44020 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 67 Ruth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2000 12:00:00 AM | Permit Number 43561 | 6001434.84212338 | 2091667.66659412 | 37.7234022554793 | -122.437167620555 | (37.7234022554793, -122.437167620555) | 9 | 7 | 6 | 28861 | 25 | |||
| 44908 | 96593 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 45466 | 74829 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 998 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1995 12:00:00 AM | 7 | 6012078.13426 | 2119069.37262 | 37.7992405115981 | -122.402301213024 | (37.7992405115981, -122.402301213024) | 3 | 1 | 10 | 28860 | 6 | ||
| 45695 | 64260 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 170 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25062 | 6009914.7515977 | 2100087.93471467 | 37.7470008969248 | -122.408447669408 | (37.7470008969248, -122.408447669408) | 2 | 7 | 7 | 28859 | 2 | ||
| 45768 | 47096 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 108 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45078 | 5996526.30490934 | 2112305.63939243 | 37.7797887262832 | -122.455626444814 | (37.7797887262832, -122.455626444814) | 15 | 6 | 2 | 54 | 16 | ||
| 46308 | 191085 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6014420.63086 | 2105780.43179 | 37.762882580487 | -122.393264886285 | (37.762882580487, -122.393264886285) | 14 | 3 | 8 | 28856 | 29 | ||||
| 46394 | 66647 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 972 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/2000 12:00:00 AM | Permit Number 29858 | 6010191.86940681 | 2103559.76448884 | 37.756549288119 | -122.407734178809 | (37.756549288119, -122.407734178809) | 2 | 4 | 7 | 28859 | 19 | ||
| 46775 | 44051 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1714 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43580 | 5993441.9028453 | 2103807.69125105 | 37.7562781258297 | -122.465679089291 | (37.7562781258297, -122.465679089291) | 1 | 8 | 4 | 56 | 12 | |||
| 47336 | 114900 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1518 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2015 12:00:00 AM | Permit Number 775911 | 5994035.5 | 2105147.2 | 37.7599902919139 | -122.463723459922 | (37.7599902919139, -122.463723459922) | 1 | 5 | 4 | 56 | 12 | |||
| 47493 | 38141 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Felton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1998 12:00:00 AM | 4 | Permit Number 40298 | 6010551.38823 | 2093805.12649 | 37.7297852835414 | -122.40580373606 | (37.7297852835414, -122.40580373606) | 10 | 3 | 7 | 309 | 28 | |
| 47747 | 52433 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1807 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | Permit Number 48548 | 6004803.7724 | 2115546.524 | 37.7891589172332 | -122.427221954641 | (37.7891589172332, -122.427221954641) | 13 | 9 | 11 | 28858 | 27 | |
| 47805 | 46326 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3649 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/2002 12:00:00 AM | Permit Number 44579 | 6005434.40207527 | 2102522.16800234 | 37.7534328160504 | -122.424113430233 | (37.7534328160504, -122.424113430233) | 2 | 4 | 5 | 28859 | 19 | ||
| 47946 | 46990 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
| 48084 | 39666 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 724 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41056 | 5993542.5872035 | 2090669.62247691 | 37.7202100790578 | -122.464377044443 | (37.7202100790578, -122.464377044443) | 9 | 8 | 6 | 64 | 24 | ||
| 48236 | 61889 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1583 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/15/1985 12:00:00 AM | 10 | Permit Number 21932 | 5988683.0577 | 2104556.6784 | 37.7580590010432 | -122.482191490983 | (37.7580590010432, -122.482191490983) | 1 | 8 | 3 | 56 | 35 | |
| 48287 | 50062 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 259 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46792 | 6004623.22870051 | 2103939.22214247 | 37.7572778811094 | -122.427019561527 | (37.7572778811094, -122.427019561527) | 2 | 4 | 5 | 28862 | 3 | ||
| 48488 | 66494 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2454 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2014 12:00:00 AM | 3 | Permit Number 29655 | 6001767.8317 | 2114666.7908 | 37.7865712397422 | -122.437662882365 | (37.7865712397422, -122.437662882365) | 13 | 6 | 11 | 29490 | 27 | |
| 48749 | 103917 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
| 48911 | 32226 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1524 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 10 | Permit Number 35545 | 6008720.30382 | 2099880.58736 | 37.7463646038601 | -122.412563325657 | (37.7463646038601, -122.412563325657) | 2 | 7 | 7 | 28859 | 2 | |
| 49203 | 63377 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 308 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23957 | 6006914.1385317 | 2095742.66094638 | 37.7349012482628 | -122.418515480064 | (37.7349012482628, -122.418515480064) | 2 | 7 | 7 | 28859 | 2 | ||
| 49362 | 63315 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 391 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/1987 12:00:00 AM | Permit Number 23882 | 6009191.36429374 | 2100247.35620947 | 37.7473980957636 | -122.410960347715 | (37.7473980957636, -122.410960347715) | 2 | 7 | 7 | 28859 | 2 | ||
| 49669 | 39646 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 72 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41040 | 5994176.5137176 | 2090402.3957614 | 37.7195128594848 | -122.462166418076 | (37.7195128594848, -122.462166418076) | 9 | 8 | 6 | 28861 | 24 | ||
| 50099 | 52435 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1808 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | Permit Number 48549 | 6004868.1713119 | 2115451.13806854 | 37.7889006530789 | -122.426992345901 | (37.7889006530789, -122.426992345901) | 13 | 9 | 1 | 28858 | 27 | ||
| 50744 | 65610 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 655 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | 10 | Permit Number 28515 | 6002150.88747 | 2090106.59961 | 37.7191565919832 | -122.434580819343 | (37.7191565919832, -122.434580819343) | 9 | 7 | 6 | 28861 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );