trees
92 rows where qSpecies_id = 281
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4840 | 197065 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 1750 22nd St | 5 | Side Yard : Yard | Tree | Private 2 | 1 | 6012833.72634 | 2103797.94864 | 37.7573508280876 | -122.398614346997 | (37.7573508280876, -122.398614346997) | 10 | 3 | 8 | 28856 | 29 | ||||
| 14445 | 261937 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 1 Verna St | 2 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
| 16582 | 19309 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 375 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6010658.6989499 | 2110585.1273498 | 37.7758654588782 | -122.406614766861 | (37.7758654588782, -122.406614766861) | 14 | 2 | 9 | 28853 | 34 | |||
| 19167 | 179282 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 170 Brookdale Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6005657.15316 | 2087249.1537 | 37.7115090783656 | -122.422258074876 | (37.7115090783656, -122.422258074876) | 9 | 7 | 8 | 309 | 18 | |||
| 23936 | 22386 | Private 9 | Pyrus spp :: Pear Tree 281 | 1769X Armstrong Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6014045.0718623 | 2092725.5085003 | 37.7270156330804 | -122.393650054041 | (37.7270156330804, -122.393650054041) | 10 | 3 | 8 | 58 | 1 | |||
| 24275 | 49550 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 549 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2003 12:00:00 AM | Permit Number 46440 | 6001603.97118249 | 2101432.39429039 | 37.750223543553 | -122.437281823397 | (37.750223543553, -122.437281823397) | 2 | 4 | 5 | 28862 | 22 | |||
| 29418 | 93757 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
| 32697 | 197060 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 2000 18th St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6011671.34373 | 2105621.05197 | 37.7622918365206 | -122.402762558964 | (37.7622918365206, -122.402762558964) | 8 | 3 | 8 | 28856 | 29 | ||||
| 33559 | 100316 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 1683 Galvez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769149 | 6015429.5 | 2097921.2 | 37.7413587833137 | -122.38922671217 | (37.7413587833137, -122.38922671217) | 10 | 3 | 8 | 58 | 1 | |
| 35402 | 93756 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
| 39203 | 97052 | Property Tree 8 | Pyrus spp :: Pear Tree 281 | 795 Wisconsin St | Sidewalk: Property side : Yard | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | Permit Number 767554 | 6012787.8 | 2103832.3 | 37.7574425906128 | -122.398775590174 | (37.7574425906128, -122.398775590174) | 10 | 3 | 8 | 28856 | 29 | |||
| 39459 | 101450 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 331X 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5993377.6 | 2113262.5 | 37.7822348132756 | -122.466588676923 | (37.7822348132756, -122.466588676923) | 11 | 6 | 2 | 54 | 11 | ||||
| 43445 | 74860 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 465 Missouri St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53589 | 6013552.24086 | 2104827.26319 | 37.7602171059641 | -122.396201560366 | (37.7602171059641, -122.396201560366) | 10 | 3 | 8 | 28856 | 29 | |
| 45820 | 61806 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 579 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2010 12:00:00 AM | Permit Number 53702 | 6002929.53125078 | 2108870.97596244 | 37.7707233636609 | -122.433229406241 | (37.7707233636609, -122.433229406241) | 15 | 5 | 5 | 29492 | 9 | ||
| 52863 | 113177 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 1721X Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013664.61678 | 2093012.65223 | 37.7277829232836 | -122.394985393491 | (37.7277829232836, -122.394985393491) | 10 | 3 | 8 | 58 | 1 | |||||
| 53916 | 93764 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
| 55820 | 93765 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
| 56624 | 93755 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
| 58031 | 103494 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 108 Merrill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009514 | 2094792 | 37.7324369584937 | -122.409459739756 | (37.7324369584937, -122.409459739756) | 10 | 3 | 7 | 309 | 28 | ||||
| 58710 | 239236 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 400 Prospect Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6006240.78075 | 2097639.08375 | 37.7400704718884 | -122.420978121045 | (37.7400704718884, -122.420978121045) | 2 | 7 | 7 | 28859 | 2 | ||||
| 60173 | 80520 | Private 9 | Pyrus spp :: Pear Tree 281 | 2499X Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2002 12:00:00 AM | 2 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | 10 | 3 | 8 | 58 | 1 | |||
| 60682 | 197059 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 2000 18th St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6011675.59314 | 2105621.49354 | 37.7622932862362 | -122.402747892822 | (37.7622932862362, -122.402747892822) | 8 | 3 | 8 | 28856 | 29 | ||||
| 61524 | 93759 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
| 62263 | 50225 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 470@ NOE 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | Permit Number 776169 | 6003463.98803486 | 2100125.52863455 | 37.7467407577194 | -122.430756521382 | (37.7467407577194, -122.430756521382) | 2 | 7 | 5 | 63 | 22 | |||
| 64497 | 19308 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 375 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6010658.6989499 | 2110585.1273498 | 37.7758654588782 | -122.406614766861 | (37.7758654588782, -122.406614766861) | 14 | 2 | 9 | 28853 | 34 | |||
| 67785 | 89012 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 4601 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2008 12:00:00 AM | 4x4 | Permit Number 51762 | 6015147 | 2096120 | 37.7363973921404 | -122.390077707197 | (37.7363973921404, -122.390077707197) | 10 | 3 | 8 | 58 | 1 | ||
| 68581 | 239238 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 215 Grand View Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6000739.59043 | 2103198.58127 | 37.7550238907662 | -122.4403975516 | (37.7550238907662, -122.4403975516) | 2 | 4 | 5 | 28862 | 22 | |||
| 69670 | 103515 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 1205 04th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x9 | 5994806.3 | 2107305.7 | 37.7659613594124 | -122.461214120153 | (37.7659613594124, -122.461214120153) | 15 | 5 | 11 | 56 | 12 | ||||
| 70011 | 113178 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 1721X Armstrong Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013664.61678 | 2093012.65223 | 37.7277829232836 | -122.394985393491 | (37.7277829232836, -122.394985393491) | 10 | 3 | 8 | 58 | 1 | |||||
| 70344 | 239235 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 1101 San Jose Ave | 13 | Front Yard : Yard | Tree | Private 2 | 20 | 6004808.52644 | 2096397.91285 | 37.7365816581211 | -122.42584194877 | (37.7365816581211, -122.42584194877) | 2 | 7 | 5 | 28859 | 2 | ||||
| 71014 | 112273 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 3250 17TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007126 | 2106171 | 37.763547030123 | -122.418522230845 | (37.763547030123, -122.418522230845) | 8 | 4 | 7 | 28859 | 19 | ||||
| 72219 | 113170 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 1721X Armstrong Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013664.61678 | 2093012.65223 | 37.7277829232836 | -122.394985393491 | (37.7277829232836, -122.394985393491) | 10 | 3 | 8 | 58 | 1 | |||||
| 76313 | 120260 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 130 24th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5988368.12376 | 2114994.77136 | 37.7867007837837 | -122.484046082469 | (37.7867007837837, -122.484046082469) | 11 | 6 | 1 | 55 | 33 | |||
| 77973 | 8254 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 1525 GALVEZ AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3x3 | 6016246 | 2097351 | 37.7398383611722 | -122.386363768789 | (37.7398383611722, -122.386363768789) | 10 | 3 | 8 | 58 | 1 | |||
| 81971 | 80519 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 1769X Armstrong Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2002 12:00:00 AM | 3 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | 10 | 3 | 8 | 58 | 1 | |||
| 84302 | 89011 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 4601 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2008 12:00:00 AM | 4x4 | Permit Number 51762 | 6015147 | 2096120 | 37.7363973921404 | -122.390077707197 | (37.7363973921404, -122.390077707197) | 10 | 3 | 8 | 58 | 1 | ||
| 87340 | 113172 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 1721X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013664.61678 | 2093012.65223 | 37.7277829232836 | -122.394985393491 | (37.7277829232836, -122.394985393491) | 10 | 3 | 8 | 58 | 1 | |||||
| 91025 | 93754 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
| 92072 | 40213 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 477 45th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1999 12:00:00 AM | 5 | Permit Number 41393 | 5981888.3284 | 2112543.95641 | 37.7795921945987 | -122.506282434653 | (37.7795921945987, -122.506282434653) | 11 | 6 | 2 | 55 | 26 | |
| 92192 | 40212 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 477 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1999 12:00:00 AM | 9 | Permit Number 41393 | 5981888.09405 | 2112558.21735 | 37.7796313371332 | -122.506284303142 | (37.7796313371332, -122.506284303142) | 11 | 6 | 2 | 55 | 26 | |
| 92274 | 80514 | Private 9 | Pyrus spp :: Pear Tree 281 | 1769X Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2002 12:00:00 AM | 4 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | 10 | 3 | 8 | 58 | 1 | |||
| 94173 | 22382 | Private 9 | Pyrus spp :: Pear Tree 281 | 2499X Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | 3 | 3X3 | 6014045.0718623 | 2092725.5085003 | 37.7270156330804 | -122.393650054041 | (37.7270156330804, -122.393650054041) | 10 | 3 | 8 | 58 | 1 | ||
| 97417 | 240208 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 614 28th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6001885.70044 | 2099454.61302 | 37.7448090357188 | -122.436166070531 | (37.7448090357188, -122.436166070531) | 2 | 7 | 5 | 63 | 22 | ||||
| 99819 | 142910 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 478 GREEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6010663.8646 | 2119301.427 | 37.7997986292339 | -122.407211464682 | (37.7997986292339, -122.407211464682) | 3 | 1 | 10 | 308 | 23 | |||
| 103302 | 197064 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 617 Rhode Island St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6011832.82769 | 2105447.84725 | 37.7618252700399 | -122.402191865385 | (37.7618252700399, -122.402191865385) | 10 | 3 | 8 | 28856 | 29 | |||
| 105616 | 239237 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 215 Grand View Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6000736.45497 | 2103194.69167 | 37.7550130323385 | -122.440408115949 | (37.7550130323385, -122.440408115949) | 2 | 4 | 5 | 28862 | 22 | |||
| 108336 | 80517 | Private 9 | Pyrus spp :: Pear Tree 281 | 1769X Armstrong Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2002 12:00:00 AM | 3 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | 10 | 3 | 8 | 58 | 1 | |||
| 110021 | 143003 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 99 Julius St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6010486.8105 | 2120810.1381 | 37.8039312684383 | -122.407930590774 | (37.8039312684383, -122.407930590774) | 3 | 1 | 10 | 308 | 23 | |||
| 111595 | 101451 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 331X 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5993377.6 | 2113262.5 | 37.7822348132756 | -122.466588676923 | (37.7822348132756, -122.466588676923) | 11 | 6 | 2 | 54 | 11 | |||
| 116175 | 113175 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 1721X Armstrong Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013664.61678 | 2093012.65223 | 37.7277829232836 | -122.394985393491 | (37.7277829232836, -122.394985393491) | 10 | 3 | 8 | 58 | 1 | |||||
| 116535 | 120261 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 130 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5988366.78111 | 2114978.8034 | 37.7866568621454 | -122.484049556271 | (37.7866568621454, -122.484049556271) | 11 | 6 | 1 | 55 | 33 | |||
| 117492 | 197066 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 1800 Illinois St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6016257.10018 | 2100639.51638 | 37.7488685664372 | -122.386554632611 | (37.7488685664372, -122.386554632611) | 10 | 3 | 8 | 58 | 1 | |||
| 123007 | 93760 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
| 123840 | 44265 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 212 Amherst St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | Permit Number 43694 | 6007447.45814488 | 2092780.96885075 | 37.7267990946728 | -122.416461883011 | (37.7267990946728, -122.416461883011) | 9 | 3 | 7 | 309 | 28 | |||
| 126089 | 105350 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 2040 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2014 12:00:00 AM | Permit Number 769933 | 6004382.6 | 2117068.4 | 37.793313776361 | -122.428787696177 | (37.793313776361, -122.428787696177) | 13 | 9 | 1 | 28858 | 27 | |||
| 129556 | 197057 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 2000 18th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6011726.09311 | 2105623.31685 | 37.7623011121306 | -122.402573359597 | (37.7623011121306, -122.402573359597) | 8 | 3 | 8 | 28856 | 29 | ||||
| 130176 | 197058 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 2000 18th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6011723.1195 | 2105623.06059 | 37.7623002424837 | -122.402583626237 | (37.7623002424837, -122.402583626237) | 8 | 3 | 8 | 28856 | 29 | ||||
| 133648 | 80515 | Private 9 | Pyrus spp :: Pear Tree 281 | 1769X Armstrong Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2002 12:00:00 AM | 4 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | 10 | 3 | 8 | 58 | 1 | |||
| 135333 | 113174 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 1721X Armstrong Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013664.61678 | 2093012.65223 | 37.7277829232836 | -122.394985393491 | (37.7277829232836, -122.394985393491) | 10 | 3 | 8 | 58 | 1 | |||||
| 138185 | 93762 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
| 138375 | 93763 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
| 139946 | 80513 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 1769X Armstrong Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2002 12:00:00 AM | 4 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | 10 | 3 | 8 | 58 | 1 | |||
| 142047 | 113173 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 1721X Armstrong Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013664.61678 | 2093012.65223 | 37.7277829232836 | -122.394985393491 | (37.7277829232836, -122.394985393491) | 10 | 3 | 8 | 58 | 1 | |||||
| 143868 | 80518 | Private 9 | Pyrus spp :: Pear Tree 281 | 1769X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2002 12:00:00 AM | 5 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | 10 | 3 | 8 | 58 | 1 | |||
| 144150 | 197061 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 2000 18th St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6011668.68799 | 2105620.78925 | 37.7622909668678 | -122.402771725747 | (37.7622909668678, -122.402771725747) | 8 | 3 | 8 | 28856 | 29 | ||||
| 145992 | 31842 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 1265 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2015 12:00:00 AM | 9 | Permit Number 775724 | 6009358.6897 | 2109957.4623 | 37.7740692198633 | -122.411067505232 | (37.7740692198633, -122.411067505232) | 8 | 2 | 9 | 28853 | 34 | |
| 146576 | 98596 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 400X Steiner St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/01/2012 12:00:00 AM | Permit Number 768529 | 6004639 | 2109849 | 37.7735056071657 | -122.427386005439 | (37.7735056071657, -122.427386005439) | 7 | 9 | 11 | 28852 | 10 | |||
| 154182 | 94621 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 1769X Armstrong Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/13/2010 12:00:00 AM | 2 | Permit Number 53777 | 6014054 | 2092727 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | 10 | 3 | 8 | 58 | 1 | ||
| 154560 | 197063 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 2000 18th St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6011661.58362 | 2105620.72246 | 37.7622903868036 | -122.402796292538 | (37.7622903868036, -122.402796292538) | 8 | 3 | 8 | 28856 | 29 | ||||
| 162743 | 93751 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
| 164704 | 80516 | Private 9 | Pyrus spp :: Pear Tree 281 | 1769X Armstrong Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2002 12:00:00 AM | 4 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | 10 | 3 | 8 | 58 | 1 | |||
| 165478 | 106788 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 2900 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003450.81306 | 2118445.01923 | 37.7970408376177 | -122.432110093777 | (37.7970408376177, -122.432110093777) | 13 | 9 | 1 | 57 | 17 | |||||
| 166402 | 113171 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 1721X Armstrong Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013664.61678 | 2093012.65223 | 37.7277829232836 | -122.394985393491 | (37.7277829232836, -122.394985393491) | 10 | 3 | 8 | 58 | 1 | |||||
| 166815 | 113169 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 1721X Armstrong Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013664.61678 | 2093012.65223 | 37.7277829232836 | -122.394985393491 | (37.7277829232836, -122.394985393491) | 10 | 3 | 8 | 58 | 1 | |||||
| 166922 | 103307 | Significant Tree 6 | Pyrus spp :: Pear Tree 281 | 1467 Willard St | 1 | Front Yard : Yard | Tree | Private 2 | 04/02/2013 12:00:00 AM | 5 | 6x6 | Permit Number 768689 | 5996817.5 | 2106175 | 37.7629722844649 | -122.454176154627 | (37.7629722844649, -122.454176154627) | 15 | 5 | 11 | 29492 | 12 | |
| 167895 | 85044 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 3130 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2007 12:00:00 AM | Permit Number 49389 | 5999161.2 | 2116695.3 | 37.7919924388881 | -122.446827171413 | (37.7919924388881, -122.446827171413) | 11 | 6 | 1 | 29490 | 30 | |||
| 168380 | 89013 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 4601 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2008 12:00:00 AM | 4x4 | Permit Number 51762 | 6015147 | 2096120 | 37.7363973921404 | -122.390077707197 | (37.7363973921404, -122.390077707197) | 10 | 3 | 8 | 58 | 1 | ||
| 168542 | 103493 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 108 Merrill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009514 | 2094792 | 37.7324369584937 | -122.409459739756 | (37.7324369584937, -122.409459739756) | 10 | 3 | 7 | 309 | 28 | ||||
| 175321 | 94620 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 1799X Armstrong Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/13/2010 12:00:00 AM | 4 | Permit Number 53777 | 6014054 | 2092727 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | 10 | 3 | 8 | 58 | 1 | ||
| 176300 | 117741 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 475 39th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5983747.44738 | 2112666.97892 | 37.7800392524883 | -122.49986014062 | (37.7800392524883, -122.49986014062) | 11 | 6 | 2 | 55 | 26 | |||
| 177189 | 89010 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 4601 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2008 12:00:00 AM | 4x4 | Permit Number 51762 | 6015147 | 2096120 | 37.7363973921404 | -122.390077707197 | (37.7363973921404, -122.390077707197) | 10 | 3 | 8 | 58 | 1 | ||
| 180474 | 197062 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 2000 18th St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6011664.44905 | 2105620.87545 | 37.7622909668723 | -122.402786392795 | (37.7622909668723, -122.402786392795) | 8 | 3 | 8 | 28856 | 29 | ||||
| 182625 | 124515 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 2636 McAllister St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5996550.39828 | 2110818.71081 | 37.7757073936912 | -122.455435599477 | (37.7757073936912, -122.455435599477) | 11 | 6 | 2 | 54 | 16 | |||
| 183325 | 201541 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 601 Innes Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6020571.22527 | 2093411.75829 | 37.7292604275206 | -122.371136408139 | (37.7292604275206, -122.371136408139) | 10 | 3 | 8 | 58 | 1 | ||||
| 183462 | 93750 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
| 183867 | 93758 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 61X Napoleon St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013237.1 | 2100058.8 | 37.7471063957658 | -122.396957155424 | (37.7471063957658, -122.396957155424) | 10 | 3 | 8 | 58 | 1 | |||||
| 184247 | 98595 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 400X Steiner St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/01/2012 12:00:00 AM | Permit Number 768529 | 6004639 | 2109849 | 37.7735056071657 | -122.427386005439 | (37.7735056071657, -122.427386005439) | 7 | 9 | 11 | 28852 | 10 | |||
| 186351 | 113176 | Undocumented 4 | Pyrus spp :: Pear Tree 281 | 1721X Armstrong Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013664.61678 | 2093012.65223 | 37.7277829232836 | -122.394985393491 | (37.7277829232836, -122.394985393491) | 10 | 3 | 8 | 58 | 1 | |||||
| 188411 | 197067 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 1700 Armstrong Ave | 1 | Side Yard : Yard | Tree | Private 2 | 1 | 6013902.76145 | 2092874.56476 | 37.7274170025835 | -122.394152453295 | (37.7274170025835, -122.394152453295) | 10 | 3 | 8 | 58 | 1 | ||||
| 189802 | 56376 | DPW Maintained 1 | Pyrus spp :: Pear Tree 281 | 1150 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/1973 12:00:00 AM | 3 | Permit Number 12523 | 5991915.34825 | 2113464.50763 | 37.7827049800091 | -122.471662092112 | (37.7827049800091, -122.471662092112) | 11 | 6 | 2 | 54 | 11 | ||
| 192572 | 94622 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 1769 Armstrong Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/13/2010 12:00:00 AM | 3 | Permit Number 53777 | 6014054 | 2092727 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | 10 | 3 | 8 | 58 | 1 | ||
| 193224 | 50068 | Permitted Site 7 | Pyrus spp :: Pear Tree 281 | 849 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2008 12:00:00 AM | 3x3 | Permit Number 50340 | 6003762.74209872 | 2103351.67000746 | 37.755615907284 | -122.429953549668 | (37.755615907284, -122.429953549668) | 2 | 4 | 5 | 28862 | 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) );