trees
467 rows where Police Districts = 7 and 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 814 | 261435 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 371 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007244 | 2095778 | 37.7350168462428 | -122.417377534221 | (37.7350168462428, -122.417377534221) | 2 | 7 | 7 | 28859 | 2 | ||||
| 1037 | 63388 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 139 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23969 | 6005989.66886949 | 2095872.0431692 | 37.7352044148911 | -122.421720887046 | (37.7352044148911, -122.421720887046) | 2 | 7 | 7 | 28859 | 2 | ||
| 1123 | 72265 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 358 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002353.80444 | 2091524.36294 | 37.7230609707806 | -122.433980702666 | (37.7230609707806, -122.433980702666) | 9 | 7 | 6 | 28861 | 5 | |||
| 2532 | 72297 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 463 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6002248.50751 | 2090769.44278 | 37.7209821527804 | -122.434290747523 | (37.7209821527804, -122.434290747523) | 9 | 7 | 6 | 28861 | 5 | |||
| 3696 | 262180 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 263 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6009676.04228 | 2087903.41357 | 37.713531417046 | -122.408413797613 | (37.713531417046, -122.408413797613) | 9 | 7 | 8 | 309 | 39 | ||
| 4187 | 78365 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 671 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6002103.17705 | 2090031.785 | 37.7189484591704 | -122.434740388752 | (37.7189484591704, -122.434740388752) | 9 | 7 | 6 | 28861 | 5 | |||
| 4370 | 38420 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1542 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42357 | 6004548.16357043 | 2099910.23270392 | 37.7462109701995 | -122.426992216906 | (37.7462109701995, -122.426992216906) | 2 | 7 | 5 | 63 | 22 | ||
| 4986 | 51031 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1085 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 6 | Permit Number 47506 | 6011820.57141 | 2089923.66488 | 37.7191984823926 | -122.401143367398 | (37.7191984823926, -122.401143367398) | 10 | 7 | 8 | 309 | 28 | ||
| 7204 | 262178 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 235 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6009840.919 | 2087844.03033 | 37.713377594646 | -122.407839737463 | (37.713377594646, -122.407839737463) | 9 | 7 | 8 | 309 | 39 | ||
| 7695 | 262179 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 255 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6009723.14992 | 2087886.44693 | 37.713487468075 | -122.408249780165 | (37.713487468075, -122.408249780165) | 9 | 7 | 8 | 309 | 39 | ||
| 9542 | 261434 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 383 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007317 | 2095771 | 37.7350017327518 | -122.417124650781 | (37.7350017327518, -122.417124650781) | 2 | 7 | 7 | 28859 | 2 | ||||
| 9689 | 63382 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 261 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23962 | 6006733.60001952 | 2095809.91850213 | 37.7350757572483 | -122.41914443544 | (37.7350757572483, -122.41914443544) | 2 | 7 | 7 | 28859 | 2 | ||
| 10016 | 261433 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 393 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007343 | 2095769 | 37.7349977038172 | -122.417034617662 | (37.7349977038172, -122.417034617662) | 2 | 7 | 7 | 28859 | 2 | ||||
| 10976 | 262163 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | 6010745.67067 | 2087724.79538 | 37.7131008096728 | -122.404704194453 | (37.7131008096728, -122.404704194453) | 9 | 7 | 8 | 309 | 39 | ||
| 11167 | 78311 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 651 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6002171.16475 | 2090137.23408 | 37.7192418585039 | -122.434512917837 | (37.7192418585039, -122.434512917837) | 9 | 7 | 6 | 28861 | 5 | |||
| 12550 | 63379 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 311 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23959 | 6006965.60744401 | 2095790.54383517 | 37.7350356215507 | -122.418340927554 | (37.7350356215507, -122.418340927554) | 2 | 7 | 7 | 28859 | 2 | ||
| 14507 | 78352 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 647 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6002178.01905 | 2090148.09572 | 37.71927207124 | -122.434490001335 | (37.71927207124, -122.434490001335) | 9 | 7 | 6 | 28861 | 5 | |||
| 17189 | 39942 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 27 Ervine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | Permit Number 41213 | 6009741.23684285 | 2089425.45829631 | 37.7177142900305 | -122.408295747981 | (37.7177142900305, -122.408295747981) | 9 | 7 | 8 | 309 | 39 | ||
| 19771 | 31015 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1200 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34784 | 6001104.8718 | 2087440.43661 | 37.7117764674692 | -122.438005613962 | (37.7117764674692, -122.438005613962) | 9 | 7 | 6 | 28861 | 5 | ||
| 19777 | 117430 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 724 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776863 | 6004182.22692 | 2091583.55482 | 37.7233270936563 | -122.427664426683 | (37.7233270936563, -122.427664426683) | 9 | 7 | 6 | 28861 | 5 | ||
| 20012 | 63372 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 371 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23952 | 6007253.22314461 | 2095766.52547538 | 37.7349858586394 | -122.417344833557 | (37.7349858586394, -122.417344833557) | 2 | 7 | 7 | 28859 | 2 | ||
| 23922 | 58026 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 680 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/1987 12:00:00 AM | Permit Number 16994 | 6008648.68681502 | 2095709.61951023 | 37.7349080209093 | -122.412516183192 | (37.7349080209093, -122.412516183192) | 10 | 7 | 7 | 28859 | 2 | ||
| 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 | |
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | |
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | |
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |
| 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 | ||
| 82316 | 64027 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 700 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24784 | 6007920.33784852 | 2095628.68558962 | 37.7346448914343 | -122.41502862166 | (37.7346448914343, -122.41502862166) | 2 | 7 | 7 | 28859 | 2 | ||
| 88741 | 40429 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 516 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | Permit Number 41524 | 6002015.10880124 | 2090488.09848269 | 37.7201963938126 | -122.435077424443 | (37.7201963938126, -122.435077424443) | 9 | 7 | 6 | 28861 | 5 | |||
| 88778 | 59756 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 410 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1981 12:00:00 AM | 15 | Permit Number 19194 | 6003645.40594 | 2091044.70066 | 37.7218171391456 | -122.42948170562 | (37.7218171391456, -122.42948170562) | 9 | 7 | 6 | 28861 | 5 | ||
| 90088 | 63317 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 408 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/1987 12:00:00 AM | Permit Number 23884 | 6009379.46071943 | 2100205.52672578 | 37.7472937869951 | -122.410306967571 | (37.7472937869951, -122.410306967571) | 2 | 7 | 7 | 28859 | 2 | ||
| 90393 | 38422 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1542 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42357 | 6004548.16357043 | 2099910.23270392 | 37.7462109701995 | -122.426992216906 | (37.7462109701995, -122.426992216906) | 2 | 7 | 5 | 63 | 22 | ||
| 91912 | 107688 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X ALEMANY BLVD | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 16 | 6008820.4 | 2095497.5 | 37.7343352217744 | -122.411907523711 | (37.7343352217744, -122.411907523711) | 10 | 7 | 7 | 28859 | 2 | ||||
| 92062 | 52985 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 483 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2006 12:00:00 AM | 5 | Permit Number 48967 | 6010218.63808 | 2089641.81604 | 37.7183350855707 | -122.406660816961 | (37.7183350855707, -122.406660816961) | 10 | 7 | 8 | 309 | 39 | ||
| 94376 | 63383 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 260 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23963 | 6006655.03075921 | 2095764.2987202 | 37.7349460704184 | -122.419412842724 | (37.7349460704184, -122.419412842724) | 2 | 7 | 7 | 28859 | 2 | ||
| 95447 | 32498 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 676 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 9 | Permit Number 37003 | 6007391.76195 | 2095838.15833 | 37.7351903403438 | -122.416870928073 | (37.7351903403438, -122.416870928073) | 2 | 7 | 7 | 28859 | 2 | |
| 103281 | 63387 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 181 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | 14 | Permit Number 23968 | 6006281.90561253 | 2095847.6388786 | 37.735153881321 | -122.420708784491 | (37.735153881321, -122.420708784491) | 2 | 7 | 7 | 28859 | 2 | |
| 105766 | 63386 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 211 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23967 | 6006484.78968372 | 2095830.6963139 | 37.7351187935179 | -122.420006137563 | (37.7351187935179, -122.420006137563) | 2 | 7 | 7 | 28859 | 2 | ||
| 106652 | 108684 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2014 12:00:00 AM | 3 | Permit Number 774614 | 6000319.87619 | 2088768.81693 | 37.7153792289568 | -122.440813996186 | (37.7153792289568, -122.440813996186) | 9 | 7 | 6 | 28861 | 5 | |
| 107540 | 42062 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1726 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42373 | 6009298.2802895 | 2099318.00641811 | 37.7448523008957 | -122.410525022946 | (37.7448523008957, -122.410525022946) | 2 | 7 | 7 | 28859 | 2 | ||
| 116907 | 67855 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 340 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31525 | 6004308.51979611 | 2099879.32748922 | 37.7461125578998 | -122.427818673872 | (37.7461125578998, -122.427818673872) | 2 | 7 | 5 | 63 | 22 | ||
| 121321 | 63486 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 241 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/07/1987 12:00:00 AM | Permit Number 24081 | 6006644.95300973 | 2095817.32130171 | 37.7350910911062 | -122.419451445549 | (37.7350910911062, -122.419451445549) | 2 | 7 | 7 | 28859 | 2 | ||
| 124395 | 63322 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 319 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1987 12:00:00 AM | Permit Number 23895 | 6009664.87242413 | 2099573.52917991 | 37.7455744556115 | -122.409275438791 | (37.7455744556115, -122.409275438791) | 2 | 7 | 7 | 28859 | 2 | ||
| 126421 | 64123 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 319 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24894 | 6003820.50853257 | 2099508.65029248 | 37.7450671453675 | -122.429479723764 | (37.7450671453675, -122.429479723764) | 2 | 7 | 5 | 63 | 22 | ||
| 127843 | 64026 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 907 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24783 | 6008326.13361224 | 2095676.92812978 | 37.7348001501968 | -122.413629054856 | (37.7348001501968, -122.413629054856) | 10 | 7 | 7 | 28859 | 2 | ||
| 136780 | 52253 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 477 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2005 12:00:00 AM | 6 | Permit Number 48420 | 6010242.54537 | 2089633.75943 | 37.7183143013438 | -122.406577611683 | (37.7183143013438, -122.406577611683) | 10 | 7 | 8 | 309 | 39 | ||
| 136898 | 63378 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 306 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23958 | 6006899.99608094 | 2095743.84196722 | 37.7349036948983 | -122.418564459297 | (37.7349036948983, -122.418564459297) | 2 | 7 | 7 | 28859 | 2 | ||
| 138025 | 31017 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1200 Naples St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | Permit Number 34784 | 6001138.87641909 | 2087503.16195668 | 37.7119506311233 | -122.437892574784 | (37.7119506311233, -122.437892574784) | 9 | 7 | 6 | 28861 | 5 | |||
| 140555 | 99879 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 76 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2012 12:00:00 AM | Permit Number 768149 | 6004987.5 | 2096139.2 | 37.7358814033012 | -122.425204756431 | (37.7358814033012, -122.425204756431) | 2 | 7 | 5 | 28859 | 2 | |||
| 141294 | 51961 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2680 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2005 12:00:00 AM | Permit Number 48182 | 6002292.28789306 | 2096370.56832846 | 37.7363640576921 | -122.434539697316 | (37.7363640576921, -122.434539697316) | 2 | 7 | 5 | 63 | 7 | |||
| 142189 | 117442 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 683 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 778575 | 6002740.92134 | 2089524.8599 | 37.7175927411032 | -122.432499770158 | (37.7175927411032, -122.432499770158) | 9 | 7 | 6 | 28861 | 5 | ||
| 142445 | 32504 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 9 | Permit Number 37008 | 6007356.06097 | 2095755.17697 | 37.7349604835245 | -122.416988482053 | (37.7349604835245, -122.416988482053) | 2 | 7 | 7 | 28859 | 2 | |
| 143019 | 64122 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 330 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24893 | 6003743.68198418 | 2099556.50648257 | 37.7451941972726 | -122.429748789002 | (37.7451941972726, -122.429748789002) | 2 | 7 | 5 | 63 | 22 | ||
| 143396 | 84789 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 499x Lisbon St | 2 | 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 | |||
| 146738 | 32499 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 707 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37004 | 6007421.96096236 | 2095649.42060619 | 37.7346738065112 | -122.416753152102 | (37.7346738065112, -122.416753152102) | 2 | 7 | 7 | 28859 | 2 | ||
| 148006 | 60514 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1551 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1982 12:00:00 AM | Permit Number 20115 | 6004602.91474331 | 2099861.26634292 | 37.7460796156332 | -122.426799407471 | (37.7460796156332, -122.426799407471) | 2 | 7 | 5 | 63 | 22 | ||
| 148740 | 42130 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 166 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2011 12:00:00 AM | Permit Number 767992 | 5998983.29782445 | 2093814.78501268 | 37.7291580818069 | -122.445796466287 | (37.7291580818069, -122.445796466287) | 9 | 7 | 4 | 28861 | 40 | |||
| 149374 | 63458 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 48 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1987 12:00:00 AM | Permit Number 24049 | 6007171.84075647 | 2095576.51841089 | 37.7344595618195 | -122.417612739346 | (37.7344595618195, -122.417612739346) | 2 | 7 | 7 | 28859 | 2 | ||
| 149441 | 64269 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1663 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1988 12:00:00 AM | Permit Number 25072 | 6009753.58464886 | 2100137.8418766 | 37.7471289041039 | -122.409008493901 | (37.7471289041039, -122.409008493901) | 2 | 7 | 7 | 28859 | 2 | ||
| 154115 | 63369 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23948 | 6007406.67814687 | 2095701.52961522 | 37.7348160268391 | -122.416809680655 | (37.7348160268391, -122.416809680655) | 2 | 7 | 7 | 28859 | 2 | ||
| 155694 | 31037 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 722 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 9 | Permit Number 34796 | 6002553.27762 | 2087290.2882 | 37.7114464558494 | -122.432988809779 | (37.7114464558494, -122.432988809779) | 9 | 7 | 6 | 28861 | 5 | |
| 159901 | 38421 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1542 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42357 | 6004548.16357043 | 2099910.23270392 | 37.7462109701995 | -122.426992216906 | (37.7462109701995, -122.426992216906) | 2 | 7 | 5 | 63 | 22 | ||
| 160868 | 66455 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29605 | 6009024.9615405 | 2097864.85103927 | 37.7408469284457 | -122.411367472491 | (37.7408469284457, -122.411367472491) | 10 | 7 | 7 | 28859 | 2 | ||
| 160973 | 45791 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 399 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 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 |
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) );