trees
399 rows where qSpecies_id = 2 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 105437 | 193408 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 480 Potrero Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010314.12402 | 2106048.65269 | 37.7633900580388 | -122.407486842464 | (37.7633900580388, -122.407486842464) | 8 | 4 | 8 | 28859 | 19 | |||
| 180775 | 197655 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1300 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6016998.37545 | 2097206.43045 | 37.7394830203258 | -122.383752282143 | (37.7394830203258, -122.383752282143) | 10 | 3 | 8 | 58 | 1 | |||
| 79656 | 2 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 850X Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2009 12:00:00 AM | 3 | 3X3 | 5992872.52482 | 2114854.21479 | 37.7865760666822 | -122.468451837381 | (37.7865760666822, -122.468451837381) | 11 | 6 | 1 | 54 | 11 | ||
| 3079 | 203064 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1300 Evans Ave | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2017 01:07:00 PM | 3 | Width 3ft | 6017493.20317 | 2097219.31473 | 37.7395457381522 | -122.382042262644 | (37.7395457381522, -122.382042262644) | 10 | 3 | 8 | 58 | 1 | ||
| 5015 | 224353 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3030 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 11:50:00 AM | 3 | Width 4ft | 6006632.75905 | 2106740.09726 | 37.7650818572521 | -122.420268591949 | (37.7650818572521, -122.420268591949) | 8 | 4 | 7 | 28853 | 19 | ||
| 87079 | 225503 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 17 | 6x6 | 6004180.73654 | 2106512.8354 | 37.7643193787498 | -122.428733333891 | (37.7643193787498, -122.428733333891) | 8 | 4 | 5 | 28862 | 3 | |||
| 110617 | 225504 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 18 | 6x6 | 6004179.96928 | 2106475.61191 | 37.7642171285539 | -122.428733333881 | (37.7642171285539, -122.428733333881) | 8 | 4 | 5 | 28862 | 3 | |||
| 114542 | 225505 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 19 | 6x6 | 6004182.33297 | 2106439.09947 | 37.7641170079293 | -122.428722555516 | (37.7641170079293, -122.428722555516) | 8 | 4 | 5 | 28862 | 3 | |||
| 126216 | 225507 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 17 | 6x6 | 6004191.74013 | 2106290.72293 | 37.7637101339293 | -122.428679441106 | (37.7637101339293, -122.428679441106) | 8 | 4 | 5 | 28862 | 3 | |||
| 74920 | 225508 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 6x6 | 6004195.74141 | 2106258.0557 | 37.763620663995 | -122.428663273099 | (37.763620663995, -122.428663273099) | 8 | 4 | 5 | 28862 | 3 | |||
| 151033 | 225509 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 22 | 6x6 | 6004197.80145 | 2106206.80833 | 37.7634800675805 | -122.428652494712 | (37.7634800675805, -122.428652494712) | 8 | 4 | 5 | 28862 | 3 | |||
| 62341 | 225510 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 21 | 6x6 | 6004199.54992 | 2106135.78909 | 37.7632851647079 | -122.42864138449 | (37.7632851647079, -122.42864138449) | 8 | 4 | 5 | 28862 | 3 | |||
| 153477 | 225511 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 17 | 6x6 | 6004201.15911 | 2106105.10523 | 37.7632010052443 | -122.428633631453 | (37.7632010052443, -122.428633631453) | 8 | 4 | 5 | 28862 | 3 | |||
| 81910 | 225512 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 01/08/2019 12:00:00 AM | 3 | 6x6 | 6004203.25115 | 2106055.40872 | 37.7630646689183 | -122.428622853063 | (37.7630646689183, -122.428622853063) | 8 | 4 | 5 | 28862 | 3 | ||
| 73597 | 226527 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 635 Potrero Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780912 | 6010443.26884 | 2105321.1926 | 37.7613998448343 | -122.406988893247 | (37.7613998448343, -122.406988893247) | 10 | 4 | 8 | 28859 | 19 | |
| 19079 | 229898 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 590 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2020 12:00:00 AM | 3 | Width 2ft | Permit Number 787828 | 6001392.90328 | 2100882.89168 | 37.7487027395486 | -122.437972352563 | (37.7487027395486, -122.437972352563) | 2 | 4 | 5 | 28862 | 22 | |
| 84741 | 230375 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 70 Pearl St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6005616.00843 | 2108643.76201 | 37.770251521926 | -122.423920665902 | (37.770251521926, -122.423920665902) | 8 | 2 | 5 | 28853 | 19 | |||
| 28398 | 230376 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 126 Dolores St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004756.55794 | 2107626.00234 | 37.7674084411732 | -122.426821010098 | (37.7674084411732, -122.426821010098) | 8 | 4 | 5 | 28862 | 3 | |||
| 180205 | 230377 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 11 Haight St | 2 | : | Tree | Private 2 | 6 | Width 4ft | 6006012.13878 | 2109648.33208 | 37.7730321861234 | -122.422621847921 | (37.7730321861234, -122.422621847921) | 7 | 9 | 11 | 28852 | 10 | |||
| 175044 | 230378 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 11 Haight St | 3 | : | Tree | Private 2 | 5 | Width 4ft | 6006027.69558 | 2109650.1201 | 37.7730379732539 | -122.422568162015 | (37.7730379732539, -122.422568162015) | 7 | 9 | 11 | 28852 | 10 | |||
| 193387 | 230379 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 636 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6010352.94216 | 2105328.73163 | 37.7614154903439 | -122.407301828531 | (37.7614154903439, -122.407301828531) | 10 | 4 | 8 | 28859 | 19 | |||
| 101791 | 230380 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1450 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010406.10881 | 2100942.79845 | 37.7493756698697 | -122.406808829185 | (37.7493756698697, -122.406808829185) | 2 | 4 | 7 | 28859 | 19 | |||
| 149323 | 230381 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 655 Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6005021.94421 | 2104476.35643 | 37.7587752633866 | -122.425678875606 | (37.7587752633866, -122.425678875606) | 2 | 4 | 5 | 28859 | 19 | |||
| 186916 | 230382 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 655 Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6005021.64655 | 2104500.02665 | 37.7588402394163 | -122.42568158976 | (37.7588402394163, -122.42568158976) | 2 | 4 | 5 | 28859 | 19 | |||
| 120075 | 230383 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 655 Dolores St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6005020.28561 | 2104519.96917 | 37.7588949199761 | -122.425687715924 | (37.7588949199761, -122.425687715924) | 2 | 4 | 5 | 28859 | 19 | |||
| 164462 | 230384 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 601 Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6005003.81478 | 2104818.83763 | 37.7597146115626 | -122.425765952455 | (37.7597146115626, -122.425765952455) | 2 | 4 | 5 | 28859 | 19 | |||
| 150628 | 230385 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 581 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 9ft | 6004995.95318 | 2104998.86424 | 37.760208477866 | -122.425805956086 | (37.760208477866, -122.425805956086) | 2 | 4 | 5 | 28859 | 19 | |||
| 37543 | 230386 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 51 13th St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6008087.40778 | 2108285.62264 | 37.769407368778 | -122.415346724678 | (37.769407368778, -122.415346724678) | 8 | 4 | 7 | 28853 | 19 | |||
| 88872 | 230387 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 51 13th St | 2 | : | Tree | Private 2 | 7 | Width 4ft | 6008108.07186 | 2108284.25114 | 37.7694047643365 | -122.415275151222 | (37.7694047643365, -122.415275151222) | 8 | 4 | 7 | 28853 | 19 | |||
| 99872 | 230388 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 51 13th St | 3 | : | Tree | Private 2 | 8 | Width 4ft | 6008125.59993 | 2108283.70929 | 37.7694042616334 | -122.41521448386 | (37.7694042616334, -122.41521448386) | 8 | 4 | 7 | 28853 | 19 | |||
| 159084 | 230389 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 51 13th St | 4 | : | Tree | Private 2 | 6 | Width 3ft | 6008142.81587 | 2108281.73826 | 37.7693998171644 | -122.415154794967 | (37.7693998171644, -122.415154794967) | 8 | 4 | 7 | 28853 | 19 | |||
| 32063 | 230390 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3431 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005492.40988 | 2103117.15388 | 37.7550697840629 | -122.423955133335 | (37.7550697840629, -122.423955133335) | 2 | 4 | 5 | 28859 | 19 | |||
| 86389 | 230391 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3425 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005521.318 | 2103117.66656 | 37.7550728237692 | -122.423855197061 | (37.7550728237692, -122.423855197061) | 2 | 4 | 5 | 28859 | 19 | |||
| 42638 | 230392 | Undocumented 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3416 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005586.33797 | 2103162.25218 | 37.7551989159029 | -122.423633508794 | (37.7551989159029, -122.423633508794) | 2 | 4 | 5 | 28859 | 19 | |||
| 108744 | 230393 | Undocumented 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3420 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005567.36067 | 2103163.57677 | 37.7552014816894 | -122.423699232135 | (37.7552014816894, -122.423699232135) | 2 | 4 | 5 | 28859 | 19 | |||
| 72127 | 230394 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 280 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005433.48505 | 2102088.45121 | 37.7522418784739 | -122.42408575987 | (37.7522418784739, -122.42408575987) | 2 | 4 | 5 | 28859 | 19 | |||
| 180008 | 2389 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2642X Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2007 12:00:00 AM | 3 | 3X3 | 6009749.5258463 | 2101948.1671123 | 37.7520994293613 | -122.409150251369 | (37.7520994293613, -122.409150251369) | 2 | 4 | 7 | 28859 | 19 | ||
| 71427 | 2390 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2642X Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2007 12:00:00 AM | 3 | 3X3 | 6009749.5258463 | 2101948.1671123 | 37.7520994293613 | -122.409150251369 | (37.7520994293613, -122.409150251369) | 2 | 4 | 7 | 28859 | 19 | ||
| 19434 | 242839 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1151 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/12/2016 05:27:00 AM | 0 | 7x7 | 6005182.83568 | 2101610.74761 | 37.7509160601321 | -122.424918561756 | (37.7509160601321, -122.424918561756) | 2 | 4 | 5 | 28859 | 19 | ||
| 77180 | 248912 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1215 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6017471 | 2096747 | 37.7382476302403 | -122.382086185189 | (37.7382476302403, -122.382086185189) | 10 | 3 | 8 | 58 | 1 | ||||
| 63030 | 251164 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1215 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2017 01:46:00 PM | 3 | 3x3 | 6017471 | 2096747 | 37.7382476302403 | -122.382086185189 | (37.7382476302403, -122.382086185189) | 10 | 3 | 8 | 58 | 1 | ||
| 77056 | 251288 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1335 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/18/2017 01:58:00 PM | 3 | 3x3 | 6016828 | 2097292 | 37.7397085577181 | -122.384347329812 | (37.7397085577181, -122.384347329812) | 10 | 3 | 8 | 58 | 1 | |
| 37463 | 252931 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 71 Edgar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997064 | 2091155 | 37.7217451669512 | -122.452239761545 | (37.7217451669512, -122.452239761545) | 9 | 8 | 6 | 28861 | 24 | ||||
| 7622 | 253826 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 701 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 02/22/2018 12:20:00 PM | 3 | 3x3 | |||||||||||
| 126676 | 25487 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 645X POTRERO AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2013 12:00:00 AM | 3 | 3X3 | 6010440 | 2105310 | 37.7613689295586 | -122.406999409931 | (37.7613689295586, -122.406999409931) | 10 | 4 | 8 | 28859 | 19 | ||
| 13136 | 255218 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 101 Goettingen St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 3345 | 258176 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 255 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6010040.21914 | 2094084.80619 | 37.7305246249549 | -122.4075906244 | (37.7305246249549, -122.4075906244) | 10 | 3 | 7 | 309 | 28 | ||
| 19452 | 258177 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 255 Silliman St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6010040.21914 | 2094084.80619 | 37.7305246249549 | -122.4075906244 | (37.7305246249549, -122.4075906244) | 10 | 3 | 7 | 309 | 28 | ||
| 7155 | 258178 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 255 Silliman St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6010040.21914 | 2094084.80619 | 37.7305246249549 | -122.4075906244 | (37.7305246249549, -122.4075906244) | 10 | 3 | 7 | 309 | 28 | ||
| 4376 | 259271 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1721x Taylor St | 5 | Side Yard : Yard | Tree | DPW 1 | Private | 05/25/2019 12:00:00 AM | 3 | ||||||||||||
| 5494 | 261029 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 863 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2019 12:00:00 AM | 3 | 4x6 | 5986308 | 2110038 | 37.7729707519219 | -122.490808659035 | (37.7729707519219, -122.490808659035) | 11 | 6 | 2 | 55 | 26 | ||
| 15650 | 261311 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3368 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2019 12:00:00 AM | 3 | 3x3 | 5998140.71226 | 2116180.16914 | 37.7905196763565 | -122.450320900484 | (37.7905196763565, -122.450320900484) | 13 | 6 | 1 | 54 | 31 | ||
| 9751 | 261814 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1622 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x4 | 5985349 | 2104146 | 37.7567369022815 | -122.493691659097 | (37.7567369022815, -122.493691659097) | 1 | 8 | 3 | 56 | 35 | ||
| 8599 | 262043 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 245 11th St | : Cutout | Tree | Private 2 | FUF | 04/14/2020 12:00:00 AM | 3 | Permit Number 785251 | 6008265.74007 | 2109435.35593 | 37.7725742877847 | -122.414811260337 | (37.7725742877847, -122.414811260337) | 8 | 2 | 9 | 28853 | 34 | ||
| 9316 | 262159 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 98 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
| 5865 | 262160 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 98 Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
| 6 | 262166 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 420 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/16/2020 12:00:00 AM | 3 | ||||||||||||
| 2 | 262167 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 420 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/16/2020 12:00:00 AM | 3 | ||||||||||||
| 19 | 262168 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 420 Alpha St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/16/2020 12:00:00 AM | 3 | ||||||||||||
| 11859 | 262397 | Undocumented 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 498 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 3x3 | 6008907 | 2105964 | 37.7630787595522 | -122.412347662048 | (37.7630787595522, -122.412347662048) | 8 | 4 | 7 | 28859 | 19 | ||
| 15395 | 262455 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1788 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000684 | 2093777 | 37.7291512919898 | -122.43991430419 | (37.7291512919898, -122.43991430419) | 9 | 7 | 6 | 28861 | 25 | ||
| 21 | 264839 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1601 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6007819 | 2087884 | 37.7133739406818 | -122.41483104388 | (37.7133739406818, -122.41483104388) | 9 | 7 | 8 | 309 | 39 | |||
| 11 | 264841 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1601 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6007819 | 2087884 | 37.7133739406818 | -122.41483104388 | (37.7133739406818, -122.41483104388) | 9 | 7 | 8 | 309 | 39 | |||
| 4497 | 264869 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1655 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | 4x6 | 5986201 | 2103975 | 37.7563171904504 | -122.490732590523 | (37.7563171904504, -122.490732590523) | 1 | 8 | 3 | 56 | 35 | ||
| 16126 | 264873 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2330 34th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/24/2020 12:00:00 AM | 3 | 4x6 | 5985803.3054 | 2099347.2154 | 37.7435873132981 | -122.491767267489 | (37.7435873132981, -122.491767267489) | 1 | 8 | 3 | 29491 | 35 | ||
| 140650 | 26918 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2000X Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/2010 12:00:00 AM | 3 | 3X3 | 6012375.8565272 | 2088505.2474917 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | 10 | 7 | 8 | 309 | 39 | ||
| 94874 | 29047 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 244 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/31/2012 12:00:00 AM | 3 | 3x3 | 6008230.7231961 | 2109406.8924959 | 37.7724941663121 | -122.414930372766 | (37.7724941663121, -122.414930372766) | 8 | 2 | 9 | 28853 | 19 | ||
| 88054 | 29774 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1100X Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/03/2017 12:44:00 PM | 3 | 3x3 | 6018183.3236 | 2096672.8034 | 37.7380832156692 | -122.379618142779 | (37.7380832156692, -122.379618142779) | 10 | 3 | 8 | 58 | 1 | ||
| 43519 | 29856 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1800X Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/12/2011 12:00:00 AM | 3 | 4x4 | 6014606.392164 | 2099329.1692391 | 37.745179108267 | -122.392171198439 | (37.745179108267, -122.392171198439) | 10 | 3 | 8 | 58 | 1 | ||
| 171372 | 30135 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 220X Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2007 12:00:00 AM | 3 | 3X30 | 6011221.783784 | 2090644.291322 | 37.7211437523189 | -122.403263826082 | (37.7211437523189, -122.403263826082) | 10 | 3 | 7 | 309 | 28 | ||
| 143563 | 32720 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 644 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1996 12:00:00 AM | 3 | 3x3 | Permit Number 37113 | 6007901.48303797 | 2114768.35798987 | 37.7871969578975 | -122.416449089052 | (37.7871969578975, -122.416449089052) | 13 | 1 | 9 | 28858 | 36 | |
| 138301 | 32721 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 644 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1996 12:00:00 AM | 3 | 3x3 | Permit Number 37113 | 6007901.48303797 | 2114768.35798987 | 37.7871969578975 | -122.416449089052 | (37.7871969578975, -122.416449089052) | 13 | 1 | 9 | 28858 | 36 | |
| 43002 | 32722 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 644 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768334 | 6007901.48303797 | 2114768.35798987 | 37.7871969578975 | -122.416449089052 | (37.7871969578975, -122.416449089052) | 13 | 1 | 9 | 28858 | 36 | |
| 162176 | 34756 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 930 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | Permit Number 767406 | 6007964.37275398 | 2102502.67346206 | 37.7535218086 | -122.415362848727 | (37.7535218086, -122.415362848727) | 2 | 4 | 7 | 28859 | 19 | ||
| 168460 | 3904 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 84 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/2014 11:00:00 AM | 3 | 2X2 | 6002180.9408165 | 2107753.3024618 | 37.7676120130603 | -122.435738811724 | (37.7676120130603, -122.435738811724) | 15 | 5 | 5 | 29492 | 3 | ||
| 8200 | 3929 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 100X Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/18/2014 12:00:00 AM | 3 | 4x4 | 6002188.32938 | 2107609.30269 | 37.7672170447484 | -122.435702952048 | (37.7672170447484, -122.435702952048) | 15 | 5 | 5 | 28862 | 3 | ||
| 98913 | 434 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 890X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 3x3 | 6010425.4291782 | 2104052.7086425 | 37.7579158746071 | -122.406961184613 | (37.7579158746071, -122.406961184613) | 10 | 4 | 7 | 28859 | 19 | ||
| 143361 | 4421 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1133 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/23/2012 12:00:00 AM | 3 | 4X4 | Permit Number 769145 | 6004474.71062 | 2102295.4201 | 37.7527559874039 | -122.427416096072 | (37.7527559874039, -122.427416096072) | 2 | 4 | 5 | 28862 | 22 | |
| 93856 | 4894 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 745X Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2007 12:00:00 AM | 3 | 3X3 | 6009751.8988059 | 2090059.5024837 | 37.7194558413593 | -122.408303589874 | (37.7194558413593, -122.408303589874) | 9 | 3 | 8 | 309 | 18 | ||
| 10779 | 49299 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 640 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Permit Number 46308 | 5981979.10455 | 2111331.16831 | 37.7762675789736 | -122.505878467652 | (37.7762675789736, -122.505878467652) | 11 | 6 | 2 | 55 | 26 | ||
| 13904 | 50261 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 31 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2002 12:00:00 AM | Permit Number 46967 | 6005053.32023027 | 2096760.11488265 | 37.737590014135 | -122.425021354004 | (37.737590014135, -122.425021354004) | 2 | 7 | 5 | 28859 | 2 | ||
| 1822 | 51694 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1205 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2005 12:00:00 AM | Permit Number 47971 | 5995825.9822194 | 2092036.11859211 | 37.7240935095077 | -122.456582925823 | (37.7240935095077, -122.456582925823) | 9 | 8 | 4 | 28861 | 40 | |||
| 78957 | 51994 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3858 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1977 12:00:00 AM | Permit Number 769135 | 5995734.40748516 | 2115851.40858603 | 37.78947898308 | -122.458622703992 | (37.78947898308, -122.458622703992) | 11 | 6 | 1 | 54 | 31 | |||
| 189245 | 52671 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1234@ LINCOLN 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53911 | 5993637.83557736 | 2107090.14039952 | 37.7653021756316 | -122.465239907967 | (37.7653021756316, -122.465239907967) | 11 | 8 | 11 | 56 | 12 | |
| 29972 | 53133 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 925 Holloway Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 08/19/2015 12:00:00 AM | Permit Number 774158 | 5994000.81776041 | 2091173.40830125 | 37.7216197566197 | -122.462829635252 | (37.7216197566197, -122.462829635252) | 9 | 8 | 6 | 64 | 24 | ||
| 136782 | 5343 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 180 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2014 02:20:00 PM | 3 | 3X3 | 6004776.79611 | 2107352.0132 | 37.7666572770255 | -122.426731495165 | (37.7666572770255, -122.426731495165) | 8 | 4 | 5 | 28862 | 3 | ||
| 129758 | 5348 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 200X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53640 | 6004789.90631 | 2107160.01438 | 37.7661308355062 | -122.426672475382 | (37.7661308355062, -122.426672475382) | 8 | 4 | 5 | 28862 | 3 | |
| 121808 | 5355 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 214 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/03/2009 12:00:00 AM | 3 | 6 | 6004795.29962 | 2107076.64131 | 37.7659022179413 | -122.426647883401 | (37.7659022179413, -122.426647883401) | 8 | 4 | 5 | 28862 | 3 | ||
| 157770 | 5356 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 220 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/2015 03:17:00 PM | 3 | 6x6 | posted for removal 3/27/14 DPW | 6004796.95819 | 2107043.90776 | 37.7658124332187 | -122.426639815582 | (37.7658124332187, -122.426639815582) | 8 | 4 | 5 | 28862 | 3 | |
| 86741 | 5370 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 265 DOLORES ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/2015 03:03:00 PM | 3 | 3X3 | 6005008.2 | 2106862.7 | 37.765326820302 | -122.425896274391 | (37.765326820302, -122.425896274391) | 8 | 4 | 5 | 28853 | 19 | ||
| 144661 | 5385 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 325X Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/2013 12:00:00 AM | 4X4 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | 8 | 4 | 5 | 28859 | 19 | |||
| 49462 | 5394 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 347 Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2014 12:00:00 AM | 2 | 7x5 | 6004926.54556 | 2106285.12827 | 37.7637363311974 | -122.426137576609 | (37.7637363311974, -122.426137576609) | 8 | 4 | 5 | 28859 | 19 | ||
| 107426 | 5406 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 392 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2012 12:00:00 AM | 5 | 3x3 | 6004848.6988147 | 2106052.9215434 | 37.7630943465887 | -122.426390290354 | (37.7630943465887, -122.426390290354) | 8 | 4 | 5 | 28859 | 3 | ||
| 43765 | 5416 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 430X Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/11/2011 12:00:00 AM | 3 | 6x150 | 6004853.9708326 | 2105864.857711 | 37.7625782660478 | -122.426358665446 | (37.7625782660478, -122.426358665446) | 8 | 4 | 5 | 28859 | 3 | ||
| 161160 | 5458 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 589 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2009 12:00:00 AM | 90 | 3x3 | 6004996.57492 | 2104960.58209 | 37.7601033992601 | -122.425801080858 | (37.7601033992601, -122.425801080858) | 2 | 4 | 5 | 28859 | 19 | ||
| 75023 | 5475 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 601 Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2008 12:00:00 AM | 3 | 4X4 | 6005004.3744 | 2104794.07494 | 37.759646650683 | -122.425762254445 | (37.759646650683, -122.425762254445) | 2 | 4 | 5 | 28859 | 19 | ||
| 136291 | 5477 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 655 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005026.79294 | 2104432.16218 | 37.7586541903676 | -122.425658960999 | (37.7586541903676, -122.425658960999) | 2 | 4 | 5 | 28859 | 19 | |||
| 171027 | 55516 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 299 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2014 12:00:00 AM | Permit Number 772528 | 6001150.72264648 | 2104659.12373936 | 37.7590575866262 | -122.439080412698 | (37.7590575866262, -122.439080412698) | 2 | 4 | 5 | 28862 | 3 | |||
| 62082 | 55564 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1X CASELLI AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50796 | 6000842 | 2104917 | 37.7597480805722 | -122.440166611531 | (37.7597480805722, -122.440166611531) | 2 | 4 | 5 | 28862 | 3 | ||
| 136361 | 5577 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1041 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2010 12:00:00 AM | 3 | 3x3 | 6005148.8764838 | 2102292.2742932 | 37.7527854561506 | -122.425084482909 | (37.7527854561506, -122.425084482909) | 2 | 4 | 5 | 28859 | 19 |
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) );