trees
467 rows where Police Districts = 7 and qSpecies_id = 8 sorted by PermitNotes
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 | ||||
| 1085 | 223588 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x Jarboe Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6009063.07444 | 2096876.26549 | 37.7381346254237 | -122.411165877211 | (37.7381346254237, -122.411165877211) | 10 | 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 | |||
| 1140 | 223581 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 85 Bessie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008353.87265 | 2100058.32291 | 37.7468320543491 | -122.413842976384 | (37.7468320543491, -122.413842976384) | 2 | 7 | 7 | 28859 | 2 | |||
| 1327 | 261443 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 354 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007142 | 2095710 | 37.7348243937619 | -122.417725367022 | (37.7348243937619, -122.417725367022) | 2 | 7 | 7 | 28859 | 2 | ||||
| 1419 | 148015 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 703 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002502.98722 | 2088786.72578 | 37.7155524923237 | -122.433269485517 | (37.7155524923237, -122.433269485517) | 9 | 7 | 6 | 28861 | 5 | |||
| 1423 | 223556 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 701x Andover St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007456 | 2095683 | 37.7347679226533 | -122.416637845271 | (37.7347679226533, -122.416637845271) | 2 | 7 | 7 | 28859 | 2 | |||
| 1653 | 159947 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 157 Bertita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 0ft | 6000525.42449 | 2090002.91659 | 37.7187794927682 | -122.440191978283 | (37.7187794927682, -122.440191978283) | 9 | 7 | 6 | 28861 | 25 | ||
| 2450 | 251744 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 70 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002620 | 2086992 | 37.710631205907 | -122.432736905509 | (37.710631205907, -122.432736905509) | 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 | |||
| 2581 | 170684 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400X San Juan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2020 12:00:00 AM | 3 | Width 3ft | 6000643.43225 | 2092709.34496 | 37.7262174472681 | -122.439978026889 | (37.7262174472681, -122.439978026889) | 9 | 7 | 6 | 28861 | 25 | ||
| 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 | ||
| 3936 | 172254 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1007 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6004516.89039 | 2090643.22078 | 37.7207640671979 | -122.426440635537 | (37.7207640671979, -122.426440635537) | 9 | 7 | 6 | 28861 | 5 | |||
| 3971 | 172343 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 164 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6001347.87441 | 2087361.61872 | 37.7115738673031 | -122.437160092082 | (37.7115738673031, -122.437160092082) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 5953 | 181063 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 280 Guttenberg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 04:21:00 PM | 3 | Width 3ft | 5999687.90058 | 2086653.14824 | 37.7095340664096 | -122.44284654224 | (37.7095340664096, -122.44284654224) | 9 | 7 | 6 | 28861 | 5 | ||
| 6250 | 261442 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 364 Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2095707 | 37.7348180134015 | -122.417611061749 | (37.7348180134015, -122.417611061749) | 2 | 7 | 7 | 28859 | 2 | ||||
| 6331 | 261440 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 374x Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007239 | 2095686 | 37.7347639531109 | -122.417388303298 | (37.7347639531109, -122.417388303298) | 2 | 7 | 7 | 28859 | 2 | ||||
| 6423 | 161312 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 486 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 0ft | 6002939.11369 | 2090932.78769 | 37.7214698362342 | -122.431915186563 | (37.7214698362342, -122.431915186563) | 9 | 7 | 6 | 28861 | 5 | ||
| 6424 | 170682 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400X San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000690.30065 | 2092674.87518 | 37.7261254691045 | -122.439813535471 | (37.7261254691045, -122.439813535471) | 9 | 7 | 6 | 28861 | 25 | ||
| 6487 | 261445 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 339 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007092 | 2095790 | 37.7350412423636 | -122.417903903871 | (37.7350412423636, -122.417903903871) | 2 | 7 | 7 | 28859 | 2 | ||||
| 7067 | 223489 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 201x Tompkins Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6007880.65482 | 2096572.00473 | 37.73723280954 | -122.415232573728 | (37.73723280954, -122.415232573728) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||
| 7733 | 170655 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 398X San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | 4x6 | 6000850.12796 | 2092564.23012 | 37.7258307594577 | -122.439253095949 | (37.7258307594577, -122.439253095949) | 9 | 7 | 6 | 28861 | 25 | ||
| 7760 | 261189 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 599x Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007159 | 2095436 | 37.7340730065148 | -122.41764717788 | (37.7340730065148, -122.41764717788) | 2 | 7 | 7 | 28859 | 2 | ||||
| 8093 | 223555 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 701x Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007456 | 2095683 | 37.7347679226533 | -122.416637845271 | (37.7347679226533, -122.416637845271) | 2 | 7 | 7 | 28859 | 2 | |||
| 8681 | 223586 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007519 | 2096543 | 37.7371328370553 | -122.416480929712 | (37.7371328370553, -122.416480929712) | 2 | 7 | 7 | 28859 | 2 | |||
| 8973 | 170735 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1895 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 2ft | 6000284.32157 | 2093024.69966 | 37.7270628891409 | -122.441242066294 | (37.7270628891409, -122.441242066294) | 9 | 7 | 6 | 28861 | 25 | ||
| 9157 | 261444 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 350 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007112 | 2095712 | 37.7348281970622 | -122.417829229388 | (37.7348281970622, -122.417829229388) | 2 | 7 | 7 | 28859 | 2 | ||||
| 9295 | 223587 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x Jarboe Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6009072.26343 | 2096875.24392 | 37.7381323357409 | -122.411134034011 | (37.7381323357409, -122.411134034011) | 10 | 7 | 7 | 28859 | 2 | |||
| 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 | ||||
| 9952 | 148016 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 703 Italy Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002451.59987 | 2088819.6954 | 37.7156401042879 | -122.433449457832 | (37.7156401042879, -122.433449457832) | 9 | 7 | 6 | 28861 | 5 | |||
| 9989 | 176265 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Excelsior Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 5ft | 6004683.74002 | 2091261.8142 | 37.7224720200432 | -122.425907897826 | (37.7224720200432, -122.425907897826) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | ||||
| 10065 | 223575 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007323 | 2098000 | 37.7411224122402 | -122.417261809722 | (37.7411224122402, -122.417261809722) | 2 | 7 | 7 | 28859 | 2 | |||
| 10072 | 223589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 590X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008529.06402 | 2096927.29731 | 37.7382447851783 | -122.413015832133 | (37.7382447851783, -122.413015832133) | 10 | 7 | 7 | 28859 | 2 | |||
| 10369 | 223584 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6007576 | 2096576 | 37.7372266531625 | -122.41628619091 | (37.7372266531625, -122.41628619091) | 2 | 7 | 7 | 28859 | 2 | |||
| 10646 | 172228 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 203 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6002933 | 2092317 | 37.7252702278754 | -122.432035115452 | (37.7252702278754, -122.432035115452) | 9 | 7 | 6 | 28861 | 5 | |||
| 10751 | 170656 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 398X San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | 6x4 | 6000839.66357 | 2092572.31066 | 37.7258523512861 | -122.439289849442 | (37.7258523512861, -122.439289849442) | 9 | 7 | 6 | 28861 | 25 | ||
| 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 | |||
| 11545 | 261446 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 329 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007068 | 2095792 | 37.7350453831972 | -122.417987022359 | (37.7350453831972, -122.417987022359) | 2 | 7 | 7 | 28859 | 2 | ||||
| 12160 | 170683 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400X San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2020 12:00:00 AM | 3 | Width 3ft | 6000666.46145 | 2092693.59381 | 37.7261755091709 | -122.439897287525 | (37.7261755091709, -122.439897287525) | 9 | 7 | 6 | 28861 | 25 | ||
| 12812 | 170654 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | 4x6 | 6000891.32853 | 2092534.3103 | 37.7257509509219 | -122.439108525449 | (37.7257509509219, -122.439108525449) | 9 | 7 | 6 | 28861 | 25 | ||
| 13251 | 262414 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 3x3 | 6003118 | 2094425 | 37.7310688083977 | -122.431546013106 | (37.7310688083977, -122.431546013106) | 9 | 7 | 5 | 28861 | 25 | |
| 14267 | 261441 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 364 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2095707 | 37.7348180134015 | -122.417611061749 | (37.7348180134015, -122.417611061749) | 2 | 7 | 7 | 28859 | 2 | ||||
| 14283 | 176234 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 46 Rolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6000330.77387 | 2088762.22962 | 37.7153617623173 | -122.44077585684 | (37.7153617623173, -122.44077585684) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 14625 | 161993 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 138 Guttenberg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 5999425.42548 | 2087282.88829 | 37.7112482236968 | -122.443798910798 | (37.7112482236968, -122.443798910798) | 9 | 7 | 6 | 28861 | 5 | |||
| 15086 | 207588 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001743.96601 | 2095815.79538 | 37.7348096375426 | -122.436395778947 | (37.7348096375426, -122.436395778947) | 2 | 7 | 5 | 63 | 7 | |||
| 15246 | 242850 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 483 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003468.14105 | 2098906.5693 | 37.7433940136201 | -122.430655192302 | (37.7433940136201, -122.430655192302) | 2 | 7 | 5 | 63 | 22 | |||
| 15567 | 223585 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6007519 | 2096543 | 37.7371328370553 | -122.416480929712 | (37.7371328370553, -122.416480929712) | 2 | 7 | 7 | 28859 | 2 | |||
| 16056 | 243760 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2432 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 1x3 | 6001985.30347 | 2097161.30264 | 37.7385177995686 | -122.435657623519 | (37.7385177995686, -122.435657623519) | 2 | 7 | 5 | 63 | 7 | |||
| 17045 | 176247 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011833.80931 | 2090345.75054 | 37.7203581824627 | -122.401127251532 | (37.7203581824627, -122.401127251532) | 10 | 7 | 8 | 309 | 28 | |||
| 18281 | 261190 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 599x Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007159 | 2095436 | 37.7340730065148 | -122.41764717788 | (37.7340730065148, -122.41764717788) | 2 | 7 | 7 | 28859 | 2 | ||||
| 18382 | 223425 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1514 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010157.18753 | 2100400.68055 | 37.7478732021894 | -122.407631390476 | (37.7478732021894, -122.407631390476) | 2 | 7 | 7 | 28859 | 2 | |||
| 20325 | 223546 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 384 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000939.02096 | 2096709.07098 | 37.7372165929608 | -122.439242751069 | (37.7372165929608, -122.439242751069) | 2 | 7 | 5 | 63 | 7 | |||
| 20459 | 223560 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 675 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008145.89505 | 2095713.05268 | 37.7348892176551 | -122.414254758854 | (37.7348892176551, -122.414254758854) | 2 | 7 | 7 | 28859 | 2 | |||
| 20672 | 176230 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 883 Madrid St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001498.44538 | 2089067.7688 | 37.7162671349894 | -122.436761734667 | (37.7162671349894, -122.436761734667) | 9 | 7 | 6 | 28861 | 5 | |||
| 20834 | 251731 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 749 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 10:28:00 AM | 3 | 3x3 | 6002542 | 2087174 | 37.7111265141547 | -122.433019485161 | (37.7111265141547, -122.433019485161) | 9 | 7 | 6 | 28861 | 5 | ||
| 20990 | 4475 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1521 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1992 12:00:00 AM | 6 | 3X3 | 6004596.9832 | 2100011.91057 | 37.7464929146108 | -122.426830644527 | (37.7464929146108, -122.426830644527) | 2 | 7 | 5 | 63 | 22 | ||
| 23051 | 223487 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6006838.49776 | 2096321.93409 | 37.7364875458659 | -122.418818066419 | (37.7364875458659, -122.418818066419) | 2 | 7 | 7 | 28859 | 2 | |||
| 23320 | 181055 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Brunswick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:09:00 AM | 3 | Width 2ft | 6000651.24572 | 2087413.96665 | 37.7116779791296 | -122.439571570199 | (37.7116779791296, -122.439571570199) | 9 | 7 | 6 | 28861 | 5 | ||
| 23708 | 223428 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 357 Precita Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6008915.2046 | 2100223.65051 | 37.7473175155876 | -122.411913617629 | (37.7473175155876, -122.411913617629) | 2 | 7 | 7 | 28859 | 2 | |||
| 24051 | 223567 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 500 Crescent Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007671.39008 | 2095684.74944 | 37.7347848378312 | -122.415893289437 | (37.7347848378312, -122.415893289437) | 2 | 7 | 7 | 28859 | 2 | |||
| 25043 | 253081 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2849X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/2017 10:35:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.450099227424 | (37.7132258706419, -122.450099227424) | 9 | 7 | 6 | 28861 | 25 | ||
| 25492 | 251734 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 898X Prague St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 08:08:00 AM | 3 | Width 6ft | 6002039.21061 | 2086908.72872 | 37.7103696049432 | -122.434738288839 | (37.7103696049432, -122.434738288839) | 9 | 7 | 6 | 28861 | 5 | ||
| 26446 | 223420 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3247 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009036.51349 | 2099774.38399 | 37.7460907342145 | -122.411462403466 | (37.7460907342145, -122.411462403466) | 2 | 7 | 7 | 28859 | 2 | |||
| 26465 | 176246 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011847.19322 | 2090350.44098 | 37.7203718080967 | -122.401081316846 | (37.7203718080967, -122.401081316846) | 10 | 7 | 8 | 309 | 28 | |||
| 27608 | 251772 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 90x Seville St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002045 | 2087474 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | 9 | 7 | 6 | 28861 | 5 | ||||
| 27764 | 223429 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 357 Precita Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008933.85702 | 2100227.23414 | 37.7473284018833 | -122.411849371861 | (37.7473284018833, -122.411849371861) | 2 | 7 | 7 | 28859 | 2 | |||
| 28283 | 223478 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 147 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006034.33786 | 2095867.87013 | 37.7351954754822 | -122.42156615355 | (37.7351954754822, -122.42156615355) | 2 | 7 | 7 | 28859 | 2 | |||
| 28306 | 223532 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 529 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002464.30667 | 2099434.4104 | 37.7447864204556 | -122.434163917953 | (37.7447864204556, -122.434163917953) | 2 | 7 | 5 | 63 | 22 | |||
| 29548 | 251781 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1237 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:14:00 AM | 3 | 3x3 | 6001070 | 2087245 | 37.7112378586553 | -122.438112149268 | (37.7112378586553, -122.438112149268) | 9 | 7 | 6 | 28861 | 5 | ||
| 29910 | 172261 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 230 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6001860 | 2086600 | 37.7095117275676 | -122.435335608043 | (37.7095117275676, -122.435335608043) | 9 | 7 | 6 | 28861 | 5 | |||
| 30263 | 253080 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2849X Alemany Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/2017 11:00:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.450099227424 | (37.7132258706419, -122.450099227424) | 9 | 7 | 6 | 28861 | 25 | ||
| 30368 | 223652 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 360 Bosworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003548.82407 | 2095261.83271 | 37.7333909714052 | -122.430116256482 | (37.7333909714052, -122.430116256482) | 2 | 7 | 5 | 28861 | 25 | |||
| 30925 | 176229 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 883 Madrid St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001482.8368 | 2089045.33875 | 37.7162046599834 | -122.43681408062 | (37.7162046599834, -122.43681408062) | 9 | 7 | 6 | 28861 | 5 | |||
| 31379 | 251733 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 824 Prague St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:24:00 AM | 3 | Width 6ft | 6002320.95082 | 2087061.42241 | 37.7108048597154 | -122.433775443194 | (37.7108048597154, -122.433775443194) | 9 | 7 | 6 | 28861 | 5 | ||
| 31475 | 176232 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 490 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002153.50763 | 2090617.3285 | 37.7205590883176 | -122.434608262185 | (37.7205590883176, -122.434608262185) | 9 | 7 | 6 | 28861 | 5 | |||
| 31809 | 223570 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 404 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007482.05364 | 2095699.08707 | 37.7348135594986 | -122.416548907823 | (37.7348135594986, -122.416548907823) | 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 | ||||
| 32619 | 223416 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 418 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009155.95431 | 2100059.10664 | 37.7468792184109 | -122.411069498672 | (37.7468792184109, -122.411069498672) | 2 | 7 | 7 | 28859 | 2 | |||
| 34014 | 223422 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 356 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008795.6118 | 2100034.66543 | 37.7467918942422 | -122.412313806947 | (37.7467918942422, -122.412313806947) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||||
| 37052 | 223427 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 357 Precita Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008897.95249 | 2100223.67255 | 37.747316608191 | -122.411973275956 | (37.747316608191, -122.411973275956) | 2 | 7 | 7 | 28859 | 2 | |||
| 38540 | 223557 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 443 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007525.59802 | 2096829.0318 | 37.737918588483 | -122.416478372193 | (37.737918588483, -122.416478372193) | 2 | 7 | 7 | 28859 | 2 | |||
| 39029 | 103456 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 410 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6003658 | 2091068 | 37.721881827041 | -122.429439831937 | (37.721881827041, -122.429439831937) | 9 | 7 | 6 | 28861 | 5 | ||||
| 40532 | 223443 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Day St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003241.07095 | 2098648.16117 | 37.742671617906 | -122.431421899403 | (37.742671617906, -122.431421899403) | 2 | 7 | 5 | 63 | 22 | |||
| 40764 | 207590 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 434 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 1ft | 5998520.92157 | 2094401.97974 | 37.7307439689499 | -122.447437181086 | (37.7307439689499, -122.447437181086) | 9 | 7 | 4 | 59 | 40 | |||
| 42001 | 223564 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 130 Nevada St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6009029.83515 | 2097858.62477 | 37.7408301058168 | -122.411350181559 | (37.7408301058168, -122.411350181559) | 10 | 7 | 7 | 28859 | 2 | |||
| 42579 | 176250 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3562 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012131.39961 | 2089120.6063 | 37.7170107808051 | -122.400012580531 | (37.7170107808051, -122.400012580531) | 10 | 7 | 8 | 309 | 39 | |||
| 43410 | 176244 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011881.09111 | 2090360.91966 | 37.7204024713802 | -122.400964878027 | (37.7204024713802, -122.400964878027) | 10 | 7 | 8 | 309 | 28 | |||
| 43621 | 223578 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 165 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006732.92847 | 2098549.7578 | 37.7425987089604 | -122.419341059038 | (37.7425987089604, -122.419341059038) | 2 | 7 | 7 | 28859 | 2 | |||
| 44380 | 180623 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 755 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 10:23:00 AM | 3 | Width 6ft | 6002495.21129 | 2087156.55582 | 37.7110759621502 | -122.433179952615 | (37.7110759621502, -122.433179952615) | 9 | 7 | 6 | 28861 | 5 | ||
| 45628 | 251771 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 90x Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002045 | 2087474 | 37.7119220445534 | -122.434758675533 | (37.7119220445534, -122.434758675533) | 9 | 7 | 6 | 28861 | 5 | ||||
| 46051 | 207593 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 166 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5998975.03938 | 2093802.03245 | 37.7291225947148 | -122.445824099527 | (37.7291225947148, -122.445824099527) | 9 | 7 | 4 | 28861 | 40 | |||
| 46342 | 223655 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 360 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003599.33439 | 2095266.26783 | 37.733406009884 | -122.429941944474 | (37.733406009884, -122.429941944474) | 2 | 7 | 5 | 28861 | 25 | |||
| 46350 | 223481 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 412 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007869.12634 | 2096919.97239 | 37.7381876044595 | -122.415297058717 | (37.7381876044595, -122.415297058717) | 2 | 7 | 7 | 28859 | 2 |
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) );