trees
467 rows where Police Districts = 7 and qSpecies_id = 8
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
499 | 180799 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Mount Vernon Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 8x8 | Permit Number 782754 | 5998557.73755 | 2089669.84713 | 37.7177527376786 | -122.446969503064 | (37.7177527376786, -122.446969503064) | 9 | 7 | 6 | 28861 | 25 | |
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 | ||
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 | ||
2215 | 49868 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 368 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46634 | 6003577.84688999 | 2095267.92973361 | 37.7334093561858 | -122.430016351279 | (37.7334093561858, -122.430016351279) | 2 | 7 | 5 | 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 | |||
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 | ||
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 | |||
8415 | 96169 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 45 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767802 | 6007419 | 2097998 | 37.7411223211925 | -122.416929733801 | (37.7411223211925, -122.416929733801) | 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 | |||
8760 | 28315 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 739 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780585 | 6008002.89443 | 2097198.99062 | 37.7389612444527 | -122.414854295516 | (37.7389612444527, -122.414854295516) | 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 | ||||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | |||
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 | ||
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 | |||
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 | ||
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 | |||
24439 | 49859 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 338 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46630 | 6003649.21999567 | 2095274.80996329 | 37.7334322896584 | -122.429770085042 | (37.7334322896584, -122.429770085042) | 2 | 7 | 5 | 28861 | 25 | ||
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 | |||
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 | |
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 | ||||
27726 | 254276 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 102 Bache St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778482 | 6007158.62699 | 2095375.94585 | 37.7339080899914 | -122.417644212443 | (37.7339080899914, -122.417644212443) | 2 | 7 | 7 | 28859 | 2 | |
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 | |||
29004 | 254341 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 38 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/01/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776525 | 6007503.72696 | 2099881.72077 | 37.7462993638251 | -122.416770197945 | (37.7462993638251, -122.416770197945) | 2 | 7 | 7 | 28859 | 2 |
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 | |||
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 | ||
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 | ||
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 | |||
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 | ||
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 |
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) );