trees
467 rows where Police Districts = 7 and qSpecies_id = 8 sorted by Supervisor Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 50524 | 207695 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1222 Plymouth Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995891.52818 | 2092172.3625 | 37.7244713658451 | -122.456366191771 | (37.7244713658451, -122.456366191771) | 9 | 7 | 4 | 28861 | 40 | |||
| 69865 | 207591 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 207 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5999361.39835 | 2094045.00117 | 37.7298117829776 | -122.444505884965 | (37.7298117829776, -122.444505884965) | 9 | 7 | 4 | 28861 | 40 | |||
| 72474 | 108891 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 434 Hearst Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773352 | 5998535.11764 | 2094404.224 | 37.7307509423916 | -122.447388264722 | (37.7307509423916, -122.447388264722) | 9 | 7 | 4 | 59 | 40 | |
| 73815 | 117002 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 161 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778235 | 6001002.4 | 2094897.4 | 37.7322457718664 | -122.438893830128 | (37.7322457718664, -122.438893830128) | 9 | 7 | 4 | 63 | 40 | |
| 105828 | 207702 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 182 Stillings Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999557.67926 | 2095791.1114 | 37.7346173903777 | -122.44395272994 | (37.7346173903777, -122.44395272994) | 9 | 7 | 4 | 63 | 40 | |||
| 116488 | 108888 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 658 Monterey Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772760 | 5997727.10617 | 2094743.09717 | 37.7316352013333 | -122.450206090909 | (37.7316352013333, -122.450206090909) | 9 | 7 | 4 | 59 | 40 | |
| 130036 | 207706 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 215 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5998739.57891 | 2093599.69117 | 37.7285535657887 | -122.446623550035 | (37.7285535657887, -122.446623550035) | 9 | 7 | 4 | 28861 | 40 | |||
| 145397 | 255506 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 622 Edna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | Permit Number 781977 | 5998590.12208 | 2094762.17227 | 37.7317369269488 | -122.447223858431 | (37.7317369269488, -122.447223858431) | 9 | 7 | 4 | 59 | 40 | ||
| 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 | |||
| 149870 | 207592 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 350 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998420.65896 | 2094107.63792 | 37.7299300456356 | -122.447762621454 | (37.7299300456356, -122.447762621454) | 9 | 7 | 4 | 28861 | 40 | |||
| 154681 | 170290 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 112 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2017 12:00:00 AM | 3 | Width 3ft | 5999300.3013 | 2093511.31058 | 37.7283429067858 | -122.44467875894 | (37.7283429067858, -122.44467875894) | 9 | 7 | 4 | 28861 | 40 | ||
| 161503 | 207705 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 247 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998743.30271 | 2093743.30134 | 37.7289480983677 | -122.446621004966 | (37.7289480983677, -122.446621004966) | 9 | 7 | 4 | 28861 | 40 | |||
| 172061 | 207703 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 161 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6000991.68804 | 2094917.78379 | 37.7323011315777 | -122.438932323977 | (37.7323011315777, -122.438932323977) | 9 | 7 | 4 | 63 | 40 | |||
| 174537 | 207704 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 658 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5997711.57572 | 2094740.62548 | 37.7316275258898 | -122.450259604396 | (37.7316275258898, -122.450259604396) | 9 | 7 | 4 | 59 | 40 | |||
| 179470 | 207589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 451 Hearst Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998517.2369 | 2094367.8013 | 37.7306499124478 | -122.447447460328 | (37.7306499124478, -122.447447460328) | 9 | 7 | 4 | 28861 | 40 | |||
| 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 | ||
| 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 | ||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 33669 | 96929 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X Bosworth St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | Permit Number 18811 | 6003740.2 | 2095277.6 | 37.7334451019942 | -122.429455740482 | (37.7334451019942, -122.429455740482) | 2 | 7 | 5 | 28861 | 25 | ||
| 38466 | 49860 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 338 Bosworth St | 1 | 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 | ||
| 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 | |||
| 44074 | 254618 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 86 Rotteck St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781521 | 6003337.103 | 2094600.11874 | 37.73156206108 | -122.430801029135 | (37.73156206108, -122.430801029135) | 9 | 7 | 5 | 28861 | 25 |
| 46240 | 49866 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 368 Bosworth St | 1 | 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 | ||
| 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 | |||
| 49346 | 223656 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 336 Bosworth St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | Permit Number 18811 | 6003648.75382 | 2095269.66073 | 37.7334181246305 | -122.429771329596 | (37.7334181246305, -122.429771329596) | 2 | 7 | 5 | 28861 | 25 | ||
| 51168 | 96928 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X Bosworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | Permit Number 18811 | 6003740.2 | 2095277.6 | 37.7334451019942 | -122.429455740482 | (37.7334451019942, -122.429455740482) | 2 | 7 | 5 | 28861 | 25 | ||
| 51264 | 49857 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 338 Bosworth St | 2 | 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 | ||
| 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 | |||
| 59875 | 223439 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 391 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6003417.4163 | 2098613.92622 | 37.7425876095457 | -122.430809705719 | (37.7425876095457, -122.430809705719) | 2 | 7 | 5 | 63 | 22 | |||
| 59905 | 49865 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 368 Bosworth St | 3 | 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 | ||
| 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 | ||
| 62074 | 223520 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 78 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004976.40139 | 2096163.67746 | 37.7359479859053 | -122.425244869978 | (37.7359479859053, -122.425244869978) | 2 | 7 | 5 | 28859 | 2 | |||
| 63011 | 102695 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 384 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6000881 | 2096712 | 37.7372213335044 | -122.439443565515 | (37.7372213335044, -122.439443565515) | 2 | 7 | 5 | 63 | 7 | |||
| 63475 | 246471 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300 Duncan St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6004508.79253 | 2099888.97742 | 37.7461503817506 | -122.427126843434 | (37.7461503817506, -122.427126843434) | 2 | 7 | 5 | 63 | 22 | |||
| 64284 | 223521 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 793 27th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001408.82629 | 2099966.50087 | 37.7461874535894 | -122.437851664431 | (37.7461874535894, -122.437851664431) | 2 | 7 | 5 | 63 | 22 | |||
| 65784 | 224099 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6003688.86609 | 2098162.22587 | 37.7413627203269 | -122.429838900151 | (37.7413627203269, -122.429838900151) | 2 | 7 | 5 | 63 | 7 | |||
| 66970 | 223659 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 336 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | Permit Number 18811 | 6003694.10013 | 2095275.57225 | 37.7334369240608 | -122.429614976149 | (37.7334369240608, -122.429614976149) | 2 | 7 | 5 | 28861 | 25 | ||
| 68615 | 246490 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399 Duncan St | 4 | : | Tree | Private 2 | 11 | Width 3ft | 6004063.56102 | 2099816.02709 | 37.7459248893202 | -122.428661198349 | (37.7459248893202, -122.428661198349) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | ||
| 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 | |||
| 72623 | 223539 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1661 Noe St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6003387.19904 | 2098534.72149 | 37.7423684195723 | -122.430908536723 | (37.7423684195723, -122.430908536723) | 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 | ||
| 75883 | 223658 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 336 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | Permit Number 18811 | 6003665.26948 | 2095270.38526 | 37.7334210492488 | -122.429714281988 | (37.7334210492488, -122.429714281988) | 2 | 7 | 5 | 28861 | 25 | ||
| 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 | ||
| 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 | |
| 79547 | 223531 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 650 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6002360.62699 | 2098888.4177 | 37.7432813672398 | -122.434483391309 | (37.7432813672398, -122.434483391309) | 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 | ||
| 84859 | 246470 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300 Duncan St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6004524.4919 | 2099889.41625 | 37.7461524744566 | -122.42707258823 | (37.7461524744566, -122.42707258823) | 2 | 7 | 5 | 63 | 22 | |||
| 87007 | 246500 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 273 Duncan St | 1 | : | Tree | Private 2 | 10 | Width 5ft | 6004745.35521 | 2099854.76299 | 37.746069811469 | -122.426306403626 | (37.746069811469, -122.426306403626) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | ||
| 90531 | 59448 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1980 12:00:00 AM | 4 | 3x3 | Permit Number 18811 | 6003739.62591886 | 2095283.52491985 | 37.7334613379814 | -122.429458147626 | (37.7334613379814, -122.429458147626) | 2 | 7 | 5 | 28861 | 25 | |
| 93819 | 223662 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 29 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005138.67888 | 2096702.23576 | 37.7374359124473 | -122.42472211206 | (37.7374359124473, -122.42472211206) | 2 | 7 | 5 | 28859 | 2 | |||
| 95635 | 223440 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 374 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6003528.78647 | 2098662.81871 | 37.7427281663791 | -122.43042810807 | (37.7427281663791, -122.43042810807) | 2 | 7 | 5 | 63 | 22 | |||
| 96633 | 223519 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 118 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003743.87449 | 2095119.74297 | 37.7330118702979 | -122.429431783351 | (37.7330118702979, -122.429431783351) | 9 | 7 | 5 | 28861 | 25 | |||
| 99926 | 27292 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 56 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001688.66279 | 2095714.91034 | 37.7345294879464 | -122.436579762262 | (37.7345294879464, -122.436579762262) | 2 | 7 | 5 | 63 | 7 | |||
| 100118 | 219821 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 544 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781970 | 6003112.54338 | 2096066.43499 | 37.7355755064901 | -122.43168202563 | (37.7355755064901, -122.43168202563) | 2 | 7 | 5 | 63 | 7 | |
| 100320 | 48882 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 585 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2002 12:00:00 AM | 3x3 | Permit Number 46088 | 6002980.45045304 | 2095906.61168613 | 37.7351291798742 | -122.432127311126 | (37.7351291798742, -122.432127311126) | 2 | 7 | 5 | 63 | 7 | ||
| 103871 | 223538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1661 Noe St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6003388.52326 | 2098515.37807 | 37.74231538204 | -122.430902577793 | (37.74231538204, -122.430902577793) | 2 | 7 | 5 | 63 | 22 | |||
| 106081 | 223544 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 585 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002953.97122 | 2095898.0136 | 37.7351040701821 | -122.432218245472 | (37.7351040701821, -122.432218245472) | 2 | 7 | 5 | 63 | 7 | |||
| 106488 | 223660 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 336 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1980 12:00:00 AM | 7 | Width 3ft | Permit Number 18811 | 6003709.54346 | 2095276.16661 | 37.7334394304696 | -122.429561626586 | (37.7334394304696, -122.429561626586) | 2 | 7 | 5 | 28861 | 25 | |
| 106655 | 223545 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 219 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004195.70944 | 2096761.73033 | 37.7375459678815 | -122.427986637589 | (37.7375459678815, -122.427986637589) | 2 | 7 | 5 | 63 | 7 | |||
| 108805 | 5086 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2575 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/2011 12:00:00 AM | 3 | 3x3 | 6002278.04095 | 2096864.42797 | 37.737719273515 | -122.4346242575 | (37.737719273515, -122.4346242575) | 2 | 7 | 5 | 63 | 7 | ||
| 111167 | 246473 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300 Duncan St | 4 | : | Tree | Private 2 | 9 | Width 3ft | 6004475.07524 | 2099887.00412 | 37.7461430567683 | -122.427243293056 | (37.7461430567683, -122.427243293056) | 2 | 7 | 5 | 63 | 22 | |||
| 111409 | 223442 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003266.99586 | 2098649.35837 | 37.742676374416 | -122.431332344034 | (37.742676374416, -122.431332344034) | 2 | 7 | 5 | 63 | 22 | |||
| 112459 | 223530 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 606 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6002608.27814 | 2098903.45091 | 37.7433366998417 | -122.433628153123 | (37.7433366998417, -122.433628153123) | 2 | 7 | 5 | 63 | 22 | |||
| 116040 | 207587 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 60 Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001679.03512 | 2095671.87202 | 37.7344107675387 | -122.43660996867 | (37.7344107675387, -122.43660996867) | 2 | 7 | 5 | 63 | 7 | |||
| 116503 | 223441 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003293.90646 | 2098651.49754 | 37.742683773149 | -122.431239447646 | (37.742683773149, -122.431239447646) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | ||
| 117533 | 95391 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 529 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767260 | 6002482 | 2099437 | 37.7447945350785 | -122.434102922936 | (37.7447945350785, -122.434102922936) | 2 | 7 | 5 | 63 | 22 | |
| 125272 | 223661 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 206 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003929.14849 | 2095301.00266 | 37.733520056493 | -122.428804160008 | (37.733520056493, -122.428804160008) | 2 | 7 | 5 | 28861 | 25 | |||
| 125704 | 223438 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 270 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004159.88516 | 2099284.24689 | 37.7444701945428 | -122.428290228918 | (37.7444701945428, -122.428290228918) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | ||
| 131925 | 169674 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 67 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781222 | 6002394.02072 | 2096615.67364 | 37.7370428349616 | -122.43420548191 | (37.7370428349616, -122.43420548191) | 2 | 7 | 5 | 63 | 7 |
| 135101 | 83726 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 219 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50486 | 6004171.06042013 | 2096811.82293441 | 37.7376821162511 | -122.428075429636 | (37.7376821162511, -122.428075429636) | 2 | 7 | 5 | 63 | 7 | ||
| 135641 | 223436 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 222 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005015.06842 | 2099039.9459 | 37.7438477521768 | -122.425315796791 | (37.7438477521768, -122.425315796791) | 2 | 7 | 5 | 63 | 22 | |||
| 136200 | 223540 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1661 Noe St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6003385.20059 | 2098555.09449 | 37.7424242458904 | -122.430916900407 | (37.7424242458904, -122.430916900407) | 2 | 7 | 5 | 63 | 22 | |||
| 137831 | 246486 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 346 Duncan St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 3ft | 6004013.8028 | 2099862.02066 | 37.7460483608489 | -122.4288365338 | (37.7460483608489, -122.4288365338) | 2 | 7 | 5 | 63 | 22 | |||
| 138468 | 12972 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 84 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001913.39953 | 2095585.02929 | 37.7341856330519 | -122.435793484091 | (37.7341856330519, -122.435793484091) | 2 | 7 | 5 | 63 | 7 | |||
| 138873 | 223444 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 319 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6003651.97677 | 2099506.05827 | 37.7450504848013 | -122.430062291736 | (37.7450504848013, -122.430062291736) | 2 | 7 | 5 | 63 | 22 | |||
| 140379 | 223654 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 360 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003584.62935 | 2095264.4412 | 37.7334001615807 | -122.429992653653 | (37.7334001615807, -122.429992653653) | 2 | 7 | 5 | 28861 | 25 | |||
| 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 | |||
| 141032 | 96927 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | Permit Number 18811 | 6003740.2 | 2095277.6 | 37.7334451019942 | -122.429455740482 | (37.7334451019942, -122.429455740482) | 2 | 7 | 5 | 28861 | 25 | ||
| 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 | |||
| 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 | ||
| 146042 | 246472 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300 Duncan St | 3 | : | Tree | Private 2 | 9 | Width 3ft | 6004489.61116 | 2099886.70473 | 37.7461430567511 | -122.42719300835 | (37.7461430567511, -122.42719300835) | 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) );