trees
302 rows where qSpecies_id = 167
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 67328 | 196531 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1150 19th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6014106.81933 | 2105287.87473 | 37.7615126872711 | -122.394315771076 | (37.7615126872711, -122.394315771076) | 10 | 3 | 8 | 28856 | 29 | |||
| 68303 | 57628 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 534 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/1990 12:00:00 AM | 7 | Permit Number 28866 | 5990653.09771 | 2111727.01603 | 37.7778611992683 | -122.475901966903 | (37.7778611992683, -122.475901966903) | 11 | 6 | 2 | 54 | 26 | ||
| 68867 | 238555 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1519 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003981.56028 | 2099428.33383 | 37.7448557321227 | -122.428917110339 | (37.7448557321227, -122.428917110339) | 2 | 7 | 5 | 63 | 22 | |||
| 69413 | 63672 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 370 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2015 12:00:00 AM | 3 | Permit Number 24323 | 6004106.96627638 | 2100160.80457488 | 37.7468740249128 | -122.428535680279 | (37.7468740249128, -122.428535680279) | 2 | 7 | 5 | 63 | 22 | ||
| 69449 | 213711 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 38 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6000905.90328 | 2094365.19154 | 37.7307789597781 | -122.439189308837 | (37.7307789597781, -122.439189308837) | 9 | 7 | 4 | 63 | 40 | |||
| 69673 | 185737 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2134 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986377.6988 | 2100714.0842 | 37.7473739221204 | -122.489881691592 | (37.7473739221204, -122.489881691592) | 1 | 8 | 3 | 29491 | 35 | |||
| 70523 | 67971 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2643 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 2 | Permit Number 31692 | 5987328.75308 | 2111152.20759 | 37.7760896301586 | -122.48735965405 | (37.7760896301586, -122.48735965405) | 11 | 6 | 2 | 55 | 26 | |
| 72104 | 238572 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 414 Collingwood St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6002097.32586 | 2103433.45375 | 37.7557460085737 | -122.435718923989 | (37.7557460085737, -122.435718923989) | 2 | 4 | 5 | 28862 | 22 | ||||
| 73350 | 67526 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1301 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31064 | 6013774.38377619 | 2105211.91246173 | 37.761285626876 | -122.395460215282 | (37.761285626876, -122.395460215282) | 10 | 3 | 8 | 28856 | 29 | ||
| 73507 | 238544 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1673 Peralta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009719.77093 | 2099951.13854 | 37.7466143635754 | -122.409112247438 | (37.7466143635754, -122.409112247438) | 2 | 7 | 7 | 28859 | 2 | |||
| 73664 | 110661 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 650 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003108.683 | 2110599.6041 | 37.7754799116102 | -122.432733221791 | (37.7754799116102, -122.432733221791) | 15 | 9 | 11 | 29492 | 10 | |||
| 76925 | 196524 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 500 De Haro St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012039.23838 | 2106001.02013 | 37.7633556787538 | -122.401516847728 | (37.7633556787538, -122.401516847728) | 8 | 3 | 8 | 28856 | 29 | |||
| 76964 | 196533 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1301 19th St | 1 | : | Tree | Private 2 | 5 | Width 4ft | 6013698.90567 | 2105212.75779 | 37.7612837495574 | -122.395721323302 | (37.7612837495574, -122.395721323302) | 10 | 3 | 8 | 28856 | 29 | |||
| 77109 | 65661 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 76 Melrose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1990 12:00:00 AM | Permit Number 28581 | 5999609.85654862 | 2095526.3392082 | 37.7338933644168 | -122.443753320491 | (37.7338933644168, -122.443753320491) | 9 | 7 | 4 | 63 | 40 | ||
| 77173 | 256161 | Undocumented 4 | Prunus blireiana :: Flowering Plum 167 | 198X Peralta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009711 | 2099918 | 37.7465228810693 | -122.409140238555 | (37.7465228810693, -122.409140238555) | 2 | 7 | 7 | 28859 | 2 | ||||
| 77247 | 213710 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 38 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6000922.38678 | 2094365.15978 | 37.7307798105294 | -122.439132320623 | (37.7307798105294, -122.439132320623) | 9 | 7 | 4 | 63 | 40 | |||
| 77254 | 60515 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 255 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25818 | 6004877.54107387 | 2099860.14096955 | 37.7460920491494 | -122.425849704584 | (37.7460920491494, -122.425849704584) | 2 | 7 | 5 | 63 | 22 | ||
| 77356 | 60791 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 276 Ewing Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1983 12:00:00 AM | Permit Number 20465 | 5998453.93543616 | 2112227.70718861 | 37.7796851739557 | -122.44895233828 | (37.7796851739557, -122.44895233828) | 15 | 6 | 2 | 54 | 16 | ||
| 78325 | 44326 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 3101 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2001 12:00:00 AM | Permit Number 43712 | 6007112.9770146 | 2100542.34949089 | 37.7480913155606 | -122.418168196056 | (37.7480913155606, -122.418168196056) | 2 | 4 | 7 | 28859 | 2 | |||
| 78638 | 181961 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2468 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5987695.3371 | 2098486.355 | 37.741334018552 | -122.485162019071 | (37.741334018552, -122.485162019071) | 1 | 8 | 3 | 29491 | 35 | |||
| 78768 | 50189 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 350 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2003 12:00:00 AM | Permit Number 46896 | 5992966.98430504 | 2103249.49310039 | 37.7547180534592 | -122.467280921215 | (37.7547180534592, -122.467280921215) | 1 | 8 | 4 | 56 | 12 | |||
| 79119 | 4209 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3929 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004325.38397 | 2100415.60352 | 37.747586001896 | -122.427798564152 | (37.747586001896, -122.427798564152) | 2 | 4 | 5 | 63 | 22 | |||
| 79882 | 218412 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 205 Castenada Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5994303.24232 | 2100628.09542 | 37.7475974107089 | -122.462469682732 | (37.7475974107089, -122.462469682732) | 1 | 8 | 4 | 29491 | 40 | |||
| 79931 | 60386 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1432 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1982 12:00:00 AM | Permit Number 19966 | 6015791.47503069 | 2094604.97930734 | 37.7322731738529 | -122.387743792201 | (37.7322731738529, -122.387743792201) | 10 | 3 | 8 | 58 | 1 | ||
| 80138 | 238574 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 290 States St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000331.0714 | 2106844.50131 | 37.7650114214522 | -122.442072013715 | (37.7650114214522, -122.442072013715) | 15 | 5 | 5 | 28862 | 3 | |||
| 80699 | 185053 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2719 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983670.2351 | 2096626.4658 | 37.735991973866 | -122.498941812175 | (37.735991973866, -122.498941812175) | 1 | 8 | 3 | 29491 | 35 | |||
| 81771 | 63785 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 4007 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24470 | 6003796.64349499 | 2101262.51482532 | 37.7498814982247 | -122.42968731122 | (37.7498814982247, -122.42968731122) | 2 | 4 | 5 | 28862 | 22 | ||
| 81984 | 238551 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 263 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004827.45458 | 2098981.61516 | 37.7436769880021 | -122.425960370593 | (37.7436769880021, -122.425960370593) | 2 | 7 | 5 | 63 | 22 | |||
| 82409 | 63662 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 3929 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24311 | 6004353.00566134 | 2100414.81780831 | 37.7475854070132 | -122.427702994 | (37.7475854070132, -122.427702994) | 2 | 4 | 5 | 63 | 22 | ||
| 83252 | 64834 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 552 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/1989 12:00:00 AM | Permit Number 25843 | 6002326.41169322 | 2099472.15020661 | 37.7448822177818 | -122.434643430049 | (37.7448822177818, -122.434643430049) | 2 | 7 | 5 | 63 | 22 | ||
| 83761 | 44069 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 45 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43593 | 6002668.59972375 | 2105639.21740039 | 37.761834937896 | -122.433900935359 | (37.761834937896, -122.433900935359) | 15 | 4 | 5 | 28862 | 3 | ||||
| 84475 | 64804 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1476 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25803 | 6003915.51476447 | 2099673.7745449 | 37.7455259170349 | -122.42916298071 | (37.7455259170349, -122.42916298071) | 2 | 7 | 5 | 63 | 22 | ||
| 84667 | 98122 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 900 York St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774687 | 6009897 | 2103882.5 | 37.7574189360449 | -122.40877671519 | (37.7574189360449, -122.40877671519) | 2 | 4 | 7 | 28859 | 19 | |
| 85134 | 123200 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1310 09th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 9ft | 5993097.33077 | 2112035.35395 | 37.7788492259481 | -122.467469010607 | (37.7788492259481, -122.467469010607) | 11 | 6 | 2 | 54 | 11 | |||
| 86086 | 238566 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 621 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002444.33707 | 2100031.09777 | 37.7464236506235 | -122.43427561915 | (37.7464236506235, -122.43427561915) | 2 | 7 | 5 | 63 | 22 | |||
| 86414 | 246644 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3350 Harrison St | 5 | Side Yard : Yard | Tree | Private 2 | 4 | 6009046.23893 | 2099176.02556 | 37.7444483194522 | -122.411386509679 | (37.7444483194522, -122.411386509679) | 2 | 7 | 7 | 28859 | 2 | ||||
| 87153 | 238548 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 76 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010523.51123 | 2100011.17861 | 37.7468242140742 | -122.406337213897 | (37.7468242140742, -122.406337213897) | 2 | 7 | 7 | 28859 | 2 | |||
| 88206 | 44237 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 415 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2001 12:00:00 AM | Permit Number 43676 | 6001527.40561887 | 2103403.09040324 | 37.755630249317 | -122.437687712198 | (37.755630249317, -122.437687712198) | 2 | 4 | 5 | 28862 | 22 | |||
| 89330 | 10116 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 842 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6005634.91055 | 2104075.87142 | 37.7577102430435 | -122.423530480645 | (37.7577102430435, -122.423530480645) | 2 | 4 | 5 | 28859 | 19 | |||
| 89391 | 64617 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1635 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1988 12:00:00 AM | 6 | Permit Number 25522 | 6004008.12859 | 2120059.46677 | 37.8015052752171 | -122.43029688889 | (37.8015052752171, -122.43029688889) | 13 | 9 | 1 | 57 | 17 | ||
| 89413 | 182859 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1830 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5986931.5262 | 2102786.1611 | 37.7530956091735 | -122.488118856463 | (37.7530956091735, -122.488118856463) | 1 | 8 | 3 | 56 | 35 | |||
| 89930 | 67744 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1460 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31363 | 5994310.57601305 | 2105578.84704093 | 37.7611913298083 | -122.462803426682 | (37.7611913298083, -122.462803426682) | 1 | 5 | 11 | 56 | 12 | ||
| 90030 | 40825 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 695 05th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1999 12:00:00 AM | Permit Number 41762 | 6013368.81391754 | 2110378.20910645 | 37.7754485595516 | -122.39722520599 | (37.7754485595516, -122.39722520599) | 6 | 2 | 9 | 28856 | 34 | |||
| 90863 | 213712 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 611 Joost Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 5998085.35885 | 2094959.97852 | 37.7322512012233 | -122.448983163356 | (37.7322512012233, -122.448983163356) | 9 | 7 | 4 | 59 | 40 | ||||
| 91037 | 65677 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 25 Sequoia Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28597 | 5998247.19530514 | 2097659.9759073 | 37.7396740035761 | -122.448618049723 | (37.7396740035761, -122.448618049723) | 9 | 7 | 4 | 59 | 40 | ||
| 91244 | 196523 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1801 Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011996.40725 | 2106050.20307 | 37.7634883341404 | -122.401668444652 | (37.7634883341404, -122.401668444652) | 8 | 3 | 8 | 28856 | 29 | |||
| 92552 | 63685 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1488 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1987 12:00:00 AM | Permit Number 24342 | 6003919.51862242 | 2099605.68059427 | 37.7453391734545 | -122.429144281616 | (37.7453391734545, -122.429144281616) | 2 | 7 | 5 | 63 | 22 | ||
| 93316 | 62805 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 15 Chicago Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1991 12:00:00 AM | 5 | Permit Number 29952 | 6003841.76502 | 2086802.53618 | 37.7101801951336 | -122.428500718859 | (37.7101801951336, -122.428500718859) | 9 | 7 | 6 | 309 | 5 | ||
| 96098 | 109293 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 370 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004104.9 | 2100171.3 | 37.7469027259862 | -122.428543573264 | (37.7469027259862, -122.428543573264) | 2 | 7 | 5 | 63 | 22 | |||||
| 96292 | 118174 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 855 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5985693.27669 | 2109963.71146 | 37.7727308467676 | -122.492929558244 | (37.7727308467676, -122.492929558244) | 11 | 6 | 2 | 55 | 26 | |||
| 96337 | 122124 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 109 16th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990813.29617 | 2114656.20657 | 37.7859132318364 | -122.475561727296 | (37.7859132318364, -122.475561727296) | 11 | 6 | 2 | 54 | 26 | |||
| 96789 | 179167 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 111 Brunswick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6000723.35107 | 2087387.59269 | 37.7116096657128 | -122.439320465973 | (37.7116096657128, -122.439320465973) | 9 | 7 | 6 | 28861 | 5 | |||
| 97602 | 63680 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1290 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1987 12:00:00 AM | Permit Number 24335 | 6003854.79358898 | 2100760.12330994 | 37.7485053408812 | -122.42945040251 | (37.7485053408812, -122.42945040251) | 2 | 4 | 5 | 28862 | 22 | ||
| 97673 | 123560 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 131 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 7ft | 5994254.42812 | 2114646.46204 | 37.7860853581858 | -122.463655743051 | (37.7860853581858, -122.463655743051) | 11 | 6 | 1 | 54 | 11 | |||
| 98385 | 182117 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2468 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5987697.3676 | 2098504.9682 | 37.7413852437695 | -122.48515636377 | (37.7413852437695, -122.48515636377) | 1 | 8 | 3 | 29491 | 35 | |||
| 98612 | 213708 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1330 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990694.19648 | 2105216.19153 | 37.7599866214079 | -122.475284333917 | (37.7599866214079, -122.475284333917) | 1 | 8 | 4 | 56 | 12 | |||
| 99034 | 246645 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3350 Harrison St | 6 | Side Yard : Yard | Tree | Private 2 | 5 | 6009048.82114 | 2099170.00785 | 37.7444319409756 | -122.411377155852 | (37.7444319409756, -122.411377155852) | 2 | 7 | 7 | 28859 | 2 | ||||
| 99655 | 58883 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1831 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1980 12:00:00 AM | 3 | Permit Number 18147 | 5984400.4624 | 2102704.4443 | 37.752723252787 | -122.496865608544 | (37.752723252787, -122.496865608544) | 1 | 8 | 3 | 56 | 35 | ||
| 99731 | 65675 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 35 Sequoia Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28595 | 5998245.89042686 | 2097529.81502266 | 37.7393165384712 | -122.448613189427 | (37.7393165384712, -122.448613189427) | 9 | 7 | 4 | 59 | 40 | ||
| 100481 | 196532 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1317 19th St | 1 | : | Tree | Private 2 | 5 | Width 6ft | 6013654.12142 | 2105210.03972 | 37.761273794973 | -122.395876023757 | (37.761273794973, -122.395876023757) | 10 | 3 | 8 | 28856 | 29 | |||
| 101584 | 213709 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1330 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990679.02857 | 2105217.07181 | 37.7599881592429 | -122.475336856123 | (37.7599881592429, -122.475336856123) | 1 | 8 | 4 | 56 | 12 | |||
| 101816 | 63684 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1477 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1987 12:00:00 AM | Permit Number 24341 | 6003967.42510642 | 2099676.82682244 | 37.7455372363545 | -122.428983700412 | (37.7455372363545, -122.428983700412) | 2 | 7 | 5 | 63 | 22 | ||
| 102825 | 196517 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1100 Pennsylvania Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014492.80276 | 2101818.43499 | 37.7520077993331 | -122.392738083189 | (37.7520077993331, -122.392738083189) | 10 | 3 | 8 | 28856 | 1 | ||||
| 103090 | 60911 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 9 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 20703 | 5995767.1919331 | 2107036.52457374 | 37.7652775252135 | -122.457871132491 | (37.7652775252135, -122.457871132491) | 15 | 5 | 11 | 56 | 12 | ||
| 103124 | 65676 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 29 Sequoia Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28596 | 5998246.67335369 | 2097607.91153994 | 37.7395310174996 | -122.448616105598 | (37.7395310174996, -122.448616105598) | 9 | 7 | 4 | 59 | 40 | ||
| 104075 | 119033 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 745 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5982267.74264 | 2110681.16094 | 37.7744998336605 | -122.504831829725 | (37.7744998336605, -122.504831829725) | 11 | 6 | 2 | 55 | 26 | |||
| 104270 | 63655 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1374 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1987 12:00:00 AM | Permit Number 24302 | 6003882.00730683 | 2100268.96113166 | 37.747158264512 | -122.429321278666 | (37.747158264512, -122.429321278666) | 2 | 7 | 5 | 63 | 22 | ||
| 105028 | 39133 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 786 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1999 12:00:00 AM | Permit Number 40812 | 6007317.12360596 | 2102737.01571967 | 37.7541288594826 | -122.417617789975 | (37.7541288594826, -122.417617789975) | 2 | 4 | 7 | 28859 | 19 | ||
| 106286 | 63666 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 4019 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24316 | 6003771.80904203 | 2100383.61201619 | 37.7474668298055 | -122.42971051138 | (37.7474668298055, -122.42971051138) | 2 | 4 | 5 | 63 | 22 | ||
| 106343 | 138764 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1508 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 782176 | 6000169.3138 | 2114165.2585 | 37.7851031433792 | -122.443157312033 | (37.7851031433792, -122.443157312033) | 15 | 6 | 1 | 29490 | 27 | |
| 106731 | 65345 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 182 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/1994 12:00:00 AM | Permit Number 28177 | 6001753.2001687 | 2095039.63295635 | 37.7326789990165 | -122.43630832371 | (37.7326789990165, -122.43630832371) | 9 | 7 | 5 | 63 | 40 | ||
| 106916 | 122160 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 547 15th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5991246.04787 | 2111677.18179 | 37.7777587296811 | -122.473847129053 | (37.7777587296811, -122.473847129053) | 11 | 6 | 2 | 54 | 26 | |||
| 106985 | 12418 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1691 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/1989 12:00:00 AM | 6 | 4X4 | 6004450.1666 | 2114579.9986 | 37.7864850778881 | -122.428376470838 | (37.7864850778881, -122.428376470838) | 13 | 9 | 11 | 29490 | 13 | ||
| 107498 | 196522 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1801 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011980.51858 | 2106049.29218 | 37.7634849464005 | -122.401723334779 | (37.7634849464005, -122.401723334779) | 8 | 3 | 8 | 28856 | 29 | |||
| 107573 | 30499 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 2468 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778856 | 6001812.59982079 | 2117366.46102333 | 37.7939863828561 | -122.437701414239 | (37.7939863828561, -122.437701414239) | 13 | 9 | 1 | 57 | 27 | |
| 109538 | 196529 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1150 19th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6014166.99848 | 2105290.36806 | 37.7615228783907 | -122.394107809149 | (37.7615228783907, -122.394107809149) | 10 | 3 | 8 | 28856 | 29 | |||
| 110192 | 49555 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 71REVISED Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2003 12:00:00 AM | Permit Number 46444 | 6009365.93611768 | 2097039.29774225 | 37.7385992569024 | -122.410130235329 | (37.7385992569024, -122.410130235329) | 10 | 7 | 7 | 28859 | 2 | |||
| 110536 | 46606 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1166 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.7543285475592 | -122.476085621892 | (37.7543285475592, -122.476085621892) | 1 | 8 | 4 | 56 | 12 | |||
| 111333 | 109267 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 900 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774687 | 6009897 | 2103882.5 | 37.7574189360449 | -122.40877671519 | (37.7574189360449, -122.40877671519) | 2 | 4 | 7 | 28859 | 19 | |
| 111552 | 61603 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 51 Temescal Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/1984 12:00:00 AM | 5 | Permit Number 21576 | 5997451.8044 | 2111351.7774 | 37.777222737132 | -122.452355902086 | (37.777222737132, -122.452355902086) | 15 | 6 | 2 | 54 | 16 | |
| 112416 | 238564 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 631 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6002380.96657 | 2100028.16957 | 37.7464120134059 | -122.434494537516 | (37.7464120134059, -122.434494537516) | 2 | 7 | 5 | 63 | 22 | |||
| 112731 | 64368 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 416 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | Permit Number 25207 | 6010971.78233994 | 2119344.22600524 | 37.7999333725763 | -122.406148966564 | (37.7999333725763, -122.406148966564) | 3 | 1 | 10 | 308 | 23 | ||
| 113099 | 46607 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1166 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.7543285475592 | -122.476085621892 | (37.7543285475592, -122.476085621892) | 1 | 8 | 4 | 56 | 12 | |||
| 113719 | 238560 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3329 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007360.6242 | 2105555.31734 | 37.7618697145455 | -122.417667096959 | (37.7618697145455, -122.417667096959) | 2 | 4 | 7 | 28859 | 19 | |||
| 114334 | 57241 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2630 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/1975 12:00:00 AM | 3 | Permit Number 14529 | 5987816.4921 | 2098311.7293 | 37.740861599204 | -122.484730305914 | (37.740861599204, -122.484730305914) | 1 | 8 | 3 | 29491 | 35 | ||
| 116017 | 136033 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1798 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002299.69392 | 2120568.99271 | 37.8028073820088 | -122.436245318762 | (37.8028073820088, -122.436245318762) | 13 | 9 | 1 | 57 | 17 | |||
| 116152 | 118369 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 55 Vandewater St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 2x2 | 6009060.6253 | 2121300.7581 | 37.8051984388103 | -122.412900722184 | (37.8051984388103, -122.412900722184) | 3 | 1 | 10 | 308 | 23 | |||
| 117233 | 53440 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 62 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/1969 12:00:00 AM | 5 | Permit Number 6341 | 5995913.45443 | 2114081.21839 | 37.7846288055158 | -122.457875074337 | (37.7846288055158, -122.457875074337) | 11 | 6 | 1 | 54 | 31 | ||
| 117990 | 138729 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1615 BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000051.0937 | 2114639.9425 | 37.7863997609352 | -122.443600426882 | (37.7863997609352, -122.443600426882) | 15 | 6 | 1 | 29490 | 31 | |||
| 119371 | 64408 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 80 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/1988 12:00:00 AM | Permit Number 25254 | 6010509.94669729 | 2100012.34807199 | 37.7468266663579 | -122.406384201378 | (37.7468266663579, -122.406384201378) | 2 | 7 | 7 | 28859 | 2 | ||
| 121892 | 46605 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1166 Noriega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.7543285475592 | -122.476085621892 | (37.7543285475592, -122.476085621892) | 1 | 8 | 4 | 56 | 12 | |||
| 122376 | 41957 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2638 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 4 | Permit Number 42313 | 5995143.69116 | 2110295.91032 | 37.7741911046961 | -122.460263829424 | (37.7741911046961, -122.460263829424) | 11 | 6 | 2 | 54 | 11 | |
| 122693 | 136032 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 Locust St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997540.73441 | 2116039.76442 | 37.7900998077197 | -122.452386640442 | (37.7900998077197, -122.452386640442) | 11 | 6 | 1 | 54 | 31 | |||
| 123284 | 85263 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 3000 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.7335405447433 | -122.478606721292 | (37.7335405447433, -122.478606721292) | 1 | 8 | 4 | 64 | 35 | |||
| 123402 | 63670 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1480 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24320 | 6003916.84938378 | 2099651.07656136 | 37.7454636691757 | -122.429156747668 | (37.7454636691757, -122.429156747668) | 2 | 7 | 5 | 63 | 22 | ||
| 123584 | 23662 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 311 Virginia Ave | 1 | Median : Cutout | Tree | DPW 1 | 6 | 12 | 6006938.1768512 | 2098312.3803834 | 37.7419584813283 | -122.41861453897 | (37.7419584813283, -122.41861453897) | 2 | 7 | 7 | 28859 | 2 | |||
| 123721 | 122919 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 342 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992497.47697 | 2113139.63077 | 37.7818466194185 | -122.469624534307 | (37.7818466194185, -122.469624534307) | 11 | 6 | 2 | 54 | 11 | |||
| 123751 | 8778 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3520 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5996129.70402 | 2112934.11169 | 37.7814915775121 | -122.457043925193 | (37.7814915775121, -122.457043925193) | 11 | 6 | 1 | 54 | 31 | |||
| 123939 | 123558 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 127 05th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 7ft | 5994253.98001 | 2114683.08774 | 37.7861858965782 | -122.463659952565 | (37.7861858965782, -122.463659952565) | 11 | 6 | 1 | 54 | 11 | |||
| 123954 | 122125 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 109 16th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990812.11385 | 2114674.53706 | 37.7859634937051 | -122.475567156694 | (37.7859634937051, -122.475567156694) | 11 | 6 | 2 | 54 | 26 |
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) );