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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51053 | 58102 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 251 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23965 | 6006689.2765112 | 2095813.61990221 | 37.7350834242778 | -122.41929794049 | (37.7350834242778, -122.41929794049) | 2 | 7 | 7 | 28859 | 2 | ||
| 51453 | 64531 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1410 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1988 12:00:00 AM | 0 | Permit Number 25413 | 6016066.97411905 | 2094739.83359707 | 37.7326587139482 | -122.386800721401 | (37.7326587139482, -122.386800721401) | 10 | 3 | 8 | 58 | 1 | |
| 52671 | 43032 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2111 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2000 12:00:00 AM | 8 | Permit Number 42893 | 6012270.45394 | 2101364.96859 | 37.7506389979096 | -122.400391489185 | (37.7506389979096, -122.400391489185) | 10 | 3 | 8 | 28856 | 1 | ||
| 52892 | 64551 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1315 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25434 | 6016281.43381852 | 2094844.2486814 | 37.7329572884599 | -122.386066550856 | (37.7329572884599, -122.386066550856) | 10 | 3 | 8 | 58 | 1 | ||
| 52958 | 64541 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1513 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25424 | 6015494.68772587 | 2095105.29398738 | 37.7336304924024 | -122.388804777662 | (37.7336304924024, -122.388804777662) | 10 | 3 | 8 | 58 | 1 | ||
| 53101 | 34891 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Ward St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1997 12:00:00 AM | Permit Number 38498 | 6011846.48740204 | 2089823.39477464 | 37.7189246067483 | -122.401046743519 | (37.7189246067483, -122.401046743519) | 10 | 7 | 8 | 309 | 39 | |||
| 53539 | 35777 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3528 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1998 12:00:00 AM | Permit Number 39032 | 6006085.57014843 | 2104950.10312581 | 37.7601361059974 | -122.422034016017 | (37.7601361059974, -122.422034016017) | 2 | 4 | 5 | 28859 | 19 | ||
| 53575 | 46871 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Pacific Ave | 3 | 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 | ||
| 53859 | 63380 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 302 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23960 | 6006871.71117456 | 2095746.20400929 | 37.7349085881089 | -122.41866241779 | (37.7349085881089, -122.41866241779) | 2 | 7 | 7 | 28859 | 2 | ||
| 53959 | 64549 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1414 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25432 | 6015539.44017214 | 2095047.54254922 | 37.7334743989165 | -122.388646024077 | (37.7334743989165, -122.388646024077) | 10 | 3 | 8 | 58 | 1 | ||
| 53966 | 37491 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1653 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39960 | 5990646.15475208 | 2106518.49529305 | 37.7635596145943 | -122.475545577058 | (37.7635596145943, -122.475545577058) | 1 | 8 | 3 | 56 | 12 | ||
| 54558 | 102355 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 176X Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012524.1 | 2106651 | 37.7651674211522 | -122.399885503722 | (37.7651674211522, -122.399885503722) | 14 | 3 | 8 | 28856 | 20 | |||||
| 54968 | 117333 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2655 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 778488 | 5991395.3 | 2097349.2 | 37.7384265182794 | -122.472286093711 | (37.7384265182794, -122.472286093711) | 1 | 8 | 4 | 29491 | 40 | |||
| 55451 | 256092 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 240 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6007860.62906 | 2108997.35701 | 37.7713488754693 | -122.416181558888 | (37.7713488754693, -122.416181558888) | 8 | 2 | 9 | 28853 | 19 | |||||
| 55466 | 52669 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 346@ SANCHEZ Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2006 12:00:00 AM | Permit Number 48750 | 6004271.44295602 | 2099877.18374076 | 37.7461045741604 | -122.427946728117 | (37.7461045741604, -122.427946728117) | 2 | 7 | 5 | 63 | 22 | |||
| 55473 | 39119 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 552 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40804 | 6007242.03781645 | 2104093.13141214 | 37.7578482165395 | -122.417973583722 | (37.7578482165395, -122.417973583722) | 2 | 4 | 7 | 28859 | 19 | ||
| 56214 | 38319 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1810 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | Permit Number 774280 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.413465790173 | (37.7684292621485, -122.413465790173) | 8 | 4 | 7 | 28853 | 19 | |||
| 56364 | 67198 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 49 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30650 | 5998389.1076576 | 2106230.44875795 | 37.7632145281987 | -122.448744521857 | (37.7632145281987, -122.448744521857) | 15 | 5 | 11 | 29492 | 9 | ||
| 56619 | 67275 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 282 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1992 12:00:00 AM | 8 | Permit Number 30749 | 6004343.26025 | 2091654.32947 | 37.7235305328868 | -122.427112803239 | (37.7235305328868, -122.427112803239) | 9 | 7 | 6 | 28861 | 5 | |
| 57493 | 64965 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1695 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1989 12:00:00 AM | 9 | Permit Number 26000 | 6004890.47461 | 2119142.08334 | 37.7990363142334 | -122.42717819022 | (37.7990363142334, -122.42717819022) | 13 | 9 | 1 | 57 | 17 | |
| 57637 | 63381 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 289 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23961 | 6006861.89612331 | 2095799.20465588 | 37.7350535636056 | -122.418700109332 | (37.7350535636056, -122.418700109332) | 2 | 7 | 7 | 28859 | 2 | ||
| 57658 | 56170 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 657 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/1973 12:00:00 AM | 3 | Permit Number 12278 | 5990945.58459 | 2110914.19297 | 37.7756463641696 | -122.474830819328 | (37.7756463641696, -122.474830819328) | 11 | 6 | 2 | 54 | 26 | ||
| 57827 | 34683 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1901X Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2013 12:00:00 AM | 2 | Permit Number 770151 | 6003781.4605 | 2118989.07405 | 37.7985534124753 | -122.43100482351 | (37.7985534124753, -122.43100482351) | 13 | 9 | 1 | 57 | 17 | ||
| 58419 | 32155 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 521 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | 7 | Permit Number 35505 | 6004828.77889 | 2111059.03276 | 37.7768387933121 | -122.426815722994 | (37.7768387933121, -122.426815722994) | 7 | 9 | 11 | 28852 | 10 | ||
| 58711 | 68462 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 295 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/1993 12:00:00 AM | Permit Number 32324 | 5991504.44002823 | 2113463.17784531 | 37.7826775467792 | -122.473083548968 | (37.7826775467792, -122.473083548968) | 11 | 6 | 2 | 54 | 26 | ||
| 58874 | 43033 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2111 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2000 12:00:00 AM | 6 | Permit Number 42893 | 6012236.17829 | 2101361.16711 | 37.7506266484242 | -122.400509750935 | (37.7506266484242, -122.400509750935) | 10 | 3 | 8 | 28856 | 1 | ||
| 59509 | 35073 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 12 | 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 | ||
| 59529 | 66339 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1455 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/1990 12:00:00 AM | Permit Number 29460 | 5986479.28524168 | 2105348.90942055 | 37.7601058207136 | -122.489871239473 | (37.7601058207136, -122.489871239473) | 1 | 8 | 3 | 56 | 35 | ||
| 59586 | 52350 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2005 12:00:00 AM | Permit Number 48491 | 5992970.80290968 | 2099088.07445215 | 37.7432920844492 | -122.46696519775 | (37.7432920844492, -122.46696519775) | 1 | 8 | 4 | 59 | 40 | |||
| 60161 | 33723 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 52 Germania St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | Permit Number 37790 | 6003978.61539507 | 2108896.55422138 | 37.7708530523079 | -122.429602431291 | (37.7708530523079, -122.429602431291) | 7 | 9 | 11 | 29492 | 10 | |||
| 60242 | 63429 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 174 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/1987 12:00:00 AM | 1 | Permit Number 24014 | 5988702.91741 | 2114182.56462 | 37.7844901800735 | -122.482828244548 | (37.7844901800735, -122.482828244548) | 11 | 6 | 2 | 55 | 26 | ||
| 60323 | 64125 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 623 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24896 | 6002552.88374737 | 2098852.79748639 | 37.7431944740998 | -122.433816072766 | (37.7431944740998, -122.433816072766) | 2 | 7 | 5 | 63 | 7 | ||
| 60769 | 52801 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 1 | Permit Number 48835 | 6013622.04592 | 2104108.35581 | 37.7582470267928 | -122.395909758227 | (37.7582470267928, -122.395909758227) | 10 | 3 | 8 | 28856 | 29 | ||
| 63071 | 58747 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 129 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1992 12:00:00 AM | Permit Number 30343 | 5995606.37444292 | 2090757.94596432 | 37.7205713407191 | -122.457249650747 | (37.7205713407191, -122.457249650747) | 9 | 8 | 6 | 28861 | 24 | ||
| 63210 | 96591 | 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 | |||||
| 63409 | 46246 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 107 Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2002 12:00:00 AM | Permit Number 44535 | 5998156.93644181 | 2106198.33011415 | 37.7631130593676 | -122.449545206751 | (37.7631130593676, -122.449545206751) | 15 | 5 | 11 | 29492 | 9 | |||
| 63633 | 51408 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1554 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | 4 | Permit Number 47732 | 5989342.6539 | 2104753.8772 | 37.758638799348 | -122.479924781914 | (37.758638799348, -122.479924781914) | 1 | 8 | 3 | 56 | 35 | |
| 63990 | 46247 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 107 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/11/2006 12:00:00 AM | Permit Number 44535 | 5998156.93644181 | 2106198.33011415 | 37.7631130593676 | -122.449545206751 | (37.7631130593676, -122.449545206751) | 15 | 5 | 11 | 29492 | 9 | ||
| 64054 | 52809 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 9 | 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 | |||
| 64406 | 30963 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1900 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2018 12:00:00 AM | 3 | Permit Number 781472 | 6001995.095 | 2115110.3689 | 37.7878021107927 | -122.436908375591 | (37.7878021107927, -122.436908375591) | 13 | 6 | 1 | 29490 | 27 | |
| 64496 | 85535 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 5 | 6007364.04136 | 2109271.58584 | 37.7720739081089 | -122.41791872548 | (37.7720739081089, -122.41791872548) | 8 | 2 | 9 | 28853 | 19 | |||
| 64853 | 52436 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1808 Octavia St | 2 | 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 | ||
| 65154 | 47258 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1290 20TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45199 | 5989944 | 2106611 | 37.763772878654 | -122.477980844758 | (37.763772878654, -122.477980844758) | 1 | 8 | 3 | 56 | 35 | ||
| 65939 | 85545 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 240 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007812 | 2109019 | 37.7714055675706 | -122.416351302737 | (37.7714055675706, -122.416351302737) | 8 | 2 | 9 | 28853 | 19 | |||
| 66207 | 41815 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 30 Barcelona Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42202 | 5999705.97173025 | 2112292.94161938 | 37.7799358147995 | -122.444625705837 | (37.7799358147995, -122.444625705837) | 15 | 5 | 1 | 29490 | 16 | ||
| 66835 | 31708 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 498 Frederick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | 7 | Permit Number 35209 | 5997262.9247 | 2107438.6115 | 37.7664673716678 | -122.452726796412 | (37.7664673716678, -122.452726796412) | 15 | 5 | 11 | 29492 | 9 | ||
| 67463 | 55804 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1631 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1973 12:00:00 AM | 12 | Permit Number 11848 | 6005137.19925 | 2119177.96133 | 37.7991487753414 | -122.42632699542 | (37.7991487753414, -122.42632699542) | 13 | 9 | 1 | 57 | 17 | ||
| 67857 | 60061 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1574 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/1982 12:00:00 AM | 3 | Permit Number 19560 | 6015687.15879 | 2097129.44006 | 37.7391990530827 | -122.388280564717 | (37.7391990530827, -122.388280564717) | 10 | 3 | 8 | 58 | 1 | ||
| 67865 | 36987 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 800 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39609 | 5993070.986847 | 2113501.00043119 | 37.7828719719487 | -122.467666762888 | (37.7828719719487, -122.467666762888) | 11 | 6 | 2 | 54 | 11 | ||
| 68249 | 56109 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3330 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1985 12:00:00 AM | Permit Number 22207 | 6006832.6652986 | 2102651.38828329 | 37.7538664735729 | -122.419287095 | (37.7538664735729, -122.419287095) | 2 | 4 | 7 | 28859 | 19 | ||
| 68593 | 50890 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2242 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47400 | 5991328.18651744 | 2100148.47255099 | 37.7461087183508 | -122.472722183475 | (37.7461087183508, -122.472722183475) | 1 | 8 | 4 | 29491 | 40 | ||
| 68640 | 52808 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 8 | 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 | |||
| 68951 | 33009 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3616 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37303 | 6005672.83784214 | 2102003.77697796 | 37.752022893602 | -122.423252020871 | (37.752022893602, -122.423252020871) | 2 | 4 | 5 | 28859 | 19 | ||
| 69338 | 51093 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 70 Waterville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2004 12:00:00 AM | 4 | Permit Number 47550 | 6011455.69814 | 2095723.6306 | 37.7351036250145 | -122.402812291464 | (37.7351036250145, -122.402812291464) | 10 | 3 | 8 | 58 | 1 | ||
| 69440 | 31713 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 8 | Permit Number 43549 | 5998153.78946 | 2105987.36259 | 37.7625336156627 | -122.44954088871 | (37.7625336156627, -122.44954088871) | 15 | 5 | 11 | 29492 | 9 | |
| 69549 | 63385 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 219 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23966 | 6006529.47672641 | 2095826.96456486 | 37.7351110645595 | -122.419851373342 | (37.7351110645595, -122.419851373342) | 2 | 7 | 7 | 28859 | 2 | ||
| 69628 | 114796 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 719 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2015 12:00:00 AM | Permit Number 775428 | 5990315.8 | 2110460.7 | 37.7743646815998 | -122.476976231877 | (37.7743646815998, -122.476976231877) | 11 | 6 | 2 | 55 | 26 | |||
| 70118 | 85528 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 225X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007748.883838 | 2109107.739625 | 37.771645676205 | -122.416575912394 | (37.771645676205, -122.416575912394) | 8 | 2 | 9 | 28853 | 19 | |||
| 70526 | 66093 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1052 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | 16 | Permit Number 29138 | 6007872.07049 | 2119612.96826 | 37.8004974059005 | -122.416894219588 | (37.8004974059005, -122.416894219588) | 5 | 1 | 1 | 308 | 32 | |
| 70702 | 64142 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 387 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24915 | 6003450.8356786 | 2098610.10956553 | 37.7425790233006 | -122.430693879032 | (37.7425790233006, -122.430693879032) | 2 | 7 | 5 | 63 | 22 | ||
| 70902 | 85555 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 360X 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008520.7969 | 2108615.740864 | 37.7703381448181 | -122.413871001048 | (37.7703381448181, -122.413871001048) | 8 | 2 | 9 | 28853 | 19 | |||
| 70969 | 47557 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 206 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45420 | 6004100.72419306 | 2102141.4355601 | 37.7523120229359 | -122.428698432782 | (37.7523120229359, -122.428698432782) | 2 | 4 | 5 | 28862 | 22 | |||
| 71264 | 47688 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2002 12:00:00 AM | Permit Number 45486 | 6003826.76338909 | 2102198.68251842 | 37.7524537008518 | -122.429649915481 | (37.7524537008518, -122.429649915481) | 2 | 4 | 5 | 28862 | 22 | |||
| 71396 | 66453 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 125 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29603 | 6009081.83261092 | 2097914.76259057 | 37.7409871642392 | -122.411174357607 | (37.7409871642392, -122.411174357607) | 10 | 7 | 7 | 28859 | 2 | ||
| 71780 | 72330 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2761 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1996 12:00:00 AM | 9 | 5995926.57923 | 2110675.1717 | 37.7752774586568 | -122.457583143432 | (37.7752774586568, -122.457583143432) | 11 | 6 | 2 | 54 | 16 | ||
| 72272 | 45790 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 399 Duncan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2001 12:00:00 AM | Permit Number 44428 | 6003953.11185898 | 2099806.69128577 | 37.7458930039208 | -122.429042450873 | (37.7458930039208, -122.429042450873) | 2 | 7 | 5 | 63 | 22 | |||
| 72718 | 64414 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/1988 12:00:00 AM | Permit Number 25261 | 6003697.20020727 | 2098175.28884646 | 37.741399060208 | -122.429811015213 | (37.741399060208, -122.429811015213) | 2 | 7 | 5 | 63 | 7 | ||
| 72996 | 47143 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2179 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/01/2016 12:00:00 AM | 3 | Permit Number 777489 | 5991297.44493317 | 2100594.37185861 | 37.7473312629118 | -122.472860991281 | (37.7473312629118, -122.472860991281) | 1 | 8 | 4 | 29491 | 40 | |
| 73029 | 46994 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 11 | 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 | |||
| 73700 | 46325 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3649 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2002 12:00:00 AM | Permit Number 56854 | 6005434.40207527 | 2102522.16800234 | 37.7534328160504 | -122.424113430233 | (37.7534328160504, -122.424113430233) | 2 | 4 | 5 | 28859 | 19 | |||
| 74034 | 35084 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 14 | 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 | ||
| 74042 | 61992 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3315 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1985 12:00:00 AM | Permit Number 22059 | 6004110.15533963 | 2120501.76517011 | 37.8027254903671 | -122.429975398963 | (37.8027254903671, -122.429975398963) | 13 | 9 | 1 | 57 | 17 | ||
| 74307 | 64143 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 461 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24917 | 6002822.78297859 | 2098575.51836339 | 37.7424484420328 | -122.432863028806 | (37.7424484420328, -122.432863028806) | 2 | 7 | 5 | 63 | 22 | ||
| 74477 | 42137 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 491 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 4 | Permit Number 42432 | 5991232.26761 | 2112071.30225 | 37.7788400781617 | -122.47392356042 | (37.7788400781617, -122.47392356042) | 11 | 6 | 2 | 54 | 26 | |
| 75277 | 32838 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1414 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37193 | 6002529.48991502 | 2101462.27171946 | 37.7503581498404 | -122.434083460627 | (37.7503581498404, -122.434083460627) | 2 | 4 | 5 | 28862 | 22 | ||
| 75288 | 35080 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/2001 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 75361 | 46996 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 13 | 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 | |||
| 76174 | 104074 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 841 32nd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/06/2013 12:00:00 AM | 2 | Permit Number 770392 | 5986000.25731 | 2110187.13166 | 37.7733622428275 | -122.491884144737 | (37.7733622428275, -122.491884144737) | 11 | 6 | 2 | 55 | 26 | ||
| 76198 | 103919 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 6 | 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 | |||
| 76303 | 85538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 180 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6007511.05272 | 2109187.82256 | 37.7718521865557 | -122.417404262918 | (37.7718521865557, -122.417404262918) | 8 | 2 | 9 | 28853 | 19 | |||
| 76450 | 64808 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 53 Newburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25810 | 6002470.46019505 | 2099868.65232966 | 37.745979096274 | -122.434173677497 | (37.745979096274, -122.434173677497) | 2 | 7 | 5 | 63 | 22 | ||
| 76476 | 46258 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 22 Leo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2002 12:00:00 AM | 5 | Permit Number 44543 | 6001485.63381 | 2091410.0324 | 37.7226977372868 | -122.436973607764 | (37.7226977372868, -122.436973607764) | 9 | 7 | 6 | 28861 | 25 | ||
| 76652 | 63384 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 259 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23964 | 6006724.73531603 | 2095810.6587823 | 37.7350772906705 | -122.419175136454 | (37.7350772906705, -122.419175136454) | 2 | 7 | 7 | 28859 | 2 | ||
| 77062 | 63367 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 511 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/1987 12:00:00 AM | Permit Number 23943 | 6007615.98725252 | 2095736.23144951 | 37.7349230812673 | -122.4160884814 | (37.7349230812673, -122.4160884814) | 2 | 7 | 7 | 28859 | 2 | ||
| 77189 | 52437 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1808 Octavia St | 3 | 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 | ||
| 77306 | 31710 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 619 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35210 | 5996583.34698 | 2107294.12432 | 37.7660316834511 | -122.45506687734 | (37.7660316834511, -122.45506687734) | 15 | 5 | 11 | 29492 | 12 | |
| 77337 | 64966 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1690 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1989 12:00:00 AM | 9 | Permit Number 26001 | 6004915.29698 | 2119193.66495 | 37.79917934781 | -122.427095972412 | (37.79917934781, -122.427095972412) | 13 | 9 | 1 | 57 | 17 | |
| 77440 | 115160 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | 15 | 5 | 5 | 28862 | 3 | |||
| 77634 | 67192 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1209 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30642 | 5997398.59481409 | 2105779.27985473 | 37.7619190417907 | -122.452137804207 | (37.7619190417907, -122.452137804207) | 15 | 5 | 11 | 29492 | 12 | ||
| 77685 | 68223 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1330 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 9 | Permit Number 781803 | 5991325.89713 | 2113444.25067 | 37.7826152391743 | -122.473699843984 | (37.7826152391743, -122.473699843984) | 11 | 6 | 2 | 54 | 26 | |
| 77707 | 64130 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 650 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | 24 | Permit Number 24901 | 6002310.61439363 | 2098891.53580323 | 37.7432870897096 | -122.434656544552 | (37.7432870897096, -122.434656544552) | 2 | 7 | 5 | 63 | 22 | |
| 78114 | 33048 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1192 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37324 | 6005740.26598795 | 2102030.16267757 | 37.7520991477767 | -122.423020719371 | (37.7520991477767, -122.423020719371) | 2 | 4 | 5 | 28859 | 19 | ||
| 78139 | 106892 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 629 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2014 12:00:00 AM | 1 | Permit Number 773229 | 6014439.75654 | 2104200.5982 | 37.7585457626959 | -122.393088190163 | (37.7585457626959, -122.393088190163) | 10 | 3 | 8 | 28856 | 29 | ||
| 78668 | 50867 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2626 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2004 12:00:00 AM | Permit Number 47381 | 6001007.94143804 | 2117610.91289932 | 37.7946117985032 | -122.440503146962 | (37.7946117985032, -122.440503146962) | 13 | 9 | 1 | 57 | 27 | |||
| 78689 | 59079 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 630 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 4 | Permit Number 18379 | 5993622.03165 | 2110755.91143 | 37.7753664990592 | -122.465560903584 | (37.7753664990592, -122.465560903584) | 11 | 6 | 2 | 54 | 11 | ||
| 78696 | 42947 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 370 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42842 | 6007791.87448942 | 2105665.73605783 | 37.7621971566206 | -122.416183388947 | (37.7621971566206, -122.416183388947) | 8 | 4 | 7 | 28859 | 19 | ||
| 79356 | 66089 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2240 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | 11 | Permit Number 29133 | 6007618.97147 | 2120081.10266 | 37.8017685454413 | -122.417803248017 | (37.8017685454413, -122.417803248017) | 5 | 1 | 10 | 308 | 32 | |
| 79618 | 61781 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2121 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/04/1985 12:00:00 AM | 12 | Permit Number 21856 | 6012125.65384 | 2102323.13714 | 37.7532618445577 | -122.400959536972 | (37.7532618445577, -122.400959536972) | 10 | 3 | 8 | 28856 | 29 | |
| 79628 | 68421 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2207 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1993 12:00:00 AM | 9 | Permit Number 32265 | 6011906.60073 | 2102309.43328 | 37.7532119951541 | -122.401716108723 | (37.7532119951541, -122.401716108723) | 10 | 3 | 8 | 28856 | 29 | ||
| 79670 | 64117 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 606 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24888 | 6002640.14988451 | 2098909.68283406 | 37.7433556196147 | -122.433518394217 | (37.7433556196147, -122.433518394217) | 2 | 7 | 5 | 63 | 22 |
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) );