trees
399 rows where qSpecies_id = 2 sorted by PlantDate
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 3529 | 79630 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1331 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6011736.35903 | 2102141.72528 | 37.7527420040406 | -122.402293051689 | (37.7527420040406, -122.402293051689) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | ||
| 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 | ||||||||||||||
| 14858 | 171814 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 100 Dartmouth St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6008473.26376 | 2093533.30473 | 37.7289224829841 | -122.412968858728 | (37.7289224829841, -122.412968858728) | 9 | 3 | 7 | 309 | 28 | ||
| 19302 | 18446 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1036 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010478.12987 | 2103164.08177 | 37.7554788523745 | -122.406716298816 | (37.7554788523745, -122.406716298816) | 10 | 4 | 7 | 28859 | 19 | |||
| 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 | ||
| 21135 | 102590 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1205 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47971 | 5995820 | 2092088.8 | 37.724237816628 | -122.4566074133 | (37.724237816628, -122.4566074133) | 9 | 7 | 4 | 28861 | 40 | ||||
| 24373 | 177452 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 404 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003440.2849 | 2091219.73942 | 37.7222861409715 | -122.430203237092 | (37.7222861409715, -122.430203237092) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 65551 | 104727 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1079 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | Permit Number 770313 | 6004450 | 2102615 | 37.7536320814231 | -122.427524315639 | (37.7536320814231, -122.427524315639) | 2 | 4 | 5 | 28862 | 22 | ||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 85532 | 110043 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 890 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6011841.59848 | 2104237.14125 | 37.7585014297196 | -122.402076412192 | (37.7585014297196, -122.402076412192) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 101899 | 100432 | Significant Tree 6 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 200X Stonecrest Dr | 2 | Front Yard : Yard | Tree | Private 2 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | |||||
| 102280 | 131010 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3099 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001935.38679 | 2118702.33437 | 37.7976613236686 | -122.437372261923 | (37.7976613236686, -122.437372261923) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 111986 | 131011 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1771 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002300.20603 | 2120865.81933 | 37.8036224187107 | -122.436264801676 | (37.8036224187107, -122.436264801676) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 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 | |||
| 120199 | 116966 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 480 Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6010311.67872 | 2106089.82191 | 37.7635029625087 | -122.407498202703 | (37.7635029625087, -122.407498202703) | 8 | 4 | 8 | 28859 | 19 | |||
| 123120 | 193407 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 541 Missouri St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6013570.69062 | 2104547.33874 | 37.7594495210946 | -122.396118132954 | (37.7594495210946, -122.396118132954) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 131390 | 108760 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1350 Church St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6004491.73804 | 2101024.57628 | 37.7492675091862 | -122.427266693799 | (37.7492675091862, -122.427266693799) | 2 | 4 | 5 | 28862 | 22 | ||||
| 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 | |||
| 144023 | 100465 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1140 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010498.9 | 2102571.5 | 37.7538529165301 | -122.40660271212 | (37.7538529165301, -122.40660271212) | 10 | 4 | 7 | 28859 | 19 | |||
| 147278 | 100431 | Significant Tree 6 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 200X Stonecrest Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | |||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 179157 | 193406 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 746 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011525.03424 | 2104899.87784 | 37.7603034831294 | -122.403217858726 | (37.7603034831294, -122.403217858726) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 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 | |||
| 185957 | 177451 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 836 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004096.83843 | 2090858.43848 | 37.7213312534072 | -122.427907954105 | (37.7213312534072, -122.427907954105) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 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 | |||
| 108000 | 108709 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 280 Fair Oaks St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773390 | 6005432.93594 | 2102084.07132 | 37.7522298213067 | -122.424087347331 | (37.7522298213067, -122.424087347331) | 2 | 4 | 5 | 28859 | 19 | |
| 72148 | 6787 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1360 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/03/2017 06:55:00 AM | 3 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.7398763247169 | -122.384492742853 | (37.7398763247169, -122.384492742853) | 10 | 3 | 8 | 58 | 1 | ||
| 109523 | 108761 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1350 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774645 | 6004491.73804 | 2101024.57628 | 37.7492675091862 | -122.427266693799 | (37.7492675091862, -122.427266693799) | 2 | 4 | 5 | 28862 | 22 |
| 60208 | 108834 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 163 Ney St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774662 | 6004445.49273 | 2094062.11561 | 37.7301475609408 | -122.426930805706 | (37.7301475609408, -122.426930805706) | 9 | 7 | 6 | 28861 | 5 | |
| 177568 | 108791 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 323 Edinburgh St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774649 | 6003546.88289 | 2091819.58764 | 37.7239392283561 | -122.429877518865 | (37.7239392283561, -122.429877518865) | 9 | 7 | 6 | 28861 | 5 | |
| 41844 | 108873 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 137 Cole St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773403 | 5997771.92218 | 2110131.23662 | 37.7738897825389 | -122.451160475717 | (37.7738897825389, -122.451160475717) | 15 | 5 | 11 | 29492 | 16 | |
| 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 | ||
| 18500 | 144214 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 786 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2020 12:25:00 PM | 0 | Width 4ft | 5982943.75928 | 2110448.71022 | 37.7739013377013 | -122.502476188525 | (37.7739013377013, -122.502476188525) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | ||
| 138954 | 108977 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2970 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773794 | 6008402.2 | 2103930 | 37.7574655215329 | -122.413949705223 | (37.7574655215329, -122.413949705223) | 2 | 4 | 7 | 28859 | 19 |
| 12272 | 117721 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 471 40th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/25/2020 11:12:00 AM | 3 | Width 3ft | 5983437.41308 | 2112653.95912 | 37.779985305245 | -122.500931708584 | (37.779985305245, -122.500931708584) | 11 | 6 | 2 | 55 | 26 | ||
| 155368 | 93268 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1574 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/29/2015 05:47:00 AM | 3 | 3x3 | 6004569 | 2099722 | 37.7456953047191 | -122.42690676352 | (37.7456953047191, -122.42690676352) | 2 | 7 | 5 | 63 | 22 | ||
| 163472 | 109142 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 342 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773572 | 5986886.5 | 2113633.7 | 37.7828773022088 | -122.489071978745 | (37.7828773022088, -122.489071978745) | 11 | 6 | 2 | 55 | 26 |
| 37211 | 87647 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1989X PINE ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2008 12:00:00 AM | 3 | 3x3 | 6004432 | 2115332 | 37.7885488568913 | -122.428492943957 | (37.7885488568913, -122.428492943957) | 13 | 9 | 11 | 28858 | 27 | ||
| 106272 | 115435 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 563 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777504 | 6001919.8 | 2090201.1 | 37.7194029477524 | -122.435386355519 | (37.7194029477524, -122.435386355519) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | ||
| 22249 | 109286 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1438 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771727 | 5982826.9 | 2105321.3 | 37.75981607235 | -122.502500845014 | (37.75981607235, -122.502500845014) | 1 | 8 | 3 | 56 | 35 |
| 83634 | 109258 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1290 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773444 | 5982171 | 2106334.4 | 37.7625591927486 | -122.504844313965 | (37.7625591927486, -122.504844313965) | 1 | 8 | 3 | 56 | 35 |
| 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 | ||
| 60588 | 125087 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2498X Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 779691 | 6001734 | 2116823 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | 13 | 6 | 1 | 29490 | 27 | |
| 164641 | 125088 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2498X Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 779691 | 6001734 | 2116823 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | 13 | 6 | 1 | 29490 | 27 | |
| 185594 | 135722 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2498X Pierce St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 779691 | 6001734 | 2116823 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | 13 | 6 | 1 | 29490 | 27 | |
| 21886 | 12447 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1989X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2004 12:00:00 AM | 4 | 3x3 | 6004432.6263962 | 2115327.1853144 | 37.7885356724235 | -122.428490433403 | (37.7885356724235, -122.428490433403) | 13 | 9 | 11 | 28858 | 27 | ||
| 60125 | 109530 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 76 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775000 | 6005863.7 | 2102913.1 | 37.7545304541232 | -122.422656603423 | (37.7545304541232, -122.422656603423) | 2 | 4 | 5 | 28859 | 19 |
| 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 | |||||||||||
| 63966 | 95388 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 4290 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767255 | 6001987.9 | 2101228 | 37.7496841432906 | -122.43593955208 | (37.7496841432906, -122.43593955208) | 2 | 4 | 5 | 28862 | 22 | |
| 114396 | 95387 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 949 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767255 | 6001944 | 2101334 | 37.7499727001327 | -122.436098944037 | (37.7499727001327, -122.436098944037) | 2 | 4 | 5 | 28862 | 22 | |
| 8777 | 18349 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 480 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6010308 | 2106081 | 37.7634785336334 | -122.407510304274 | (37.7634785336334, -122.407510304274) | 8 | 4 | 8 | 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 | |||
| 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 | ||
| 16185 | 182600 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1959 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 4x4 | 5985980.7032 | 2101896.5884 | 37.7505975691069 | -122.4913414752 | (37.7505975691069, -122.4913414752) | 1 | 8 | 3 | 29491 | 35 | ||
| 128665 | 95423 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2187 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767291 | 5989736.1 | 2100494 | 37.7469651560486 | -122.478252612879 | (37.7469651560486, -122.478252612879) | 1 | 8 | 3 | 29491 | 35 | |
| 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 | ||
| 3150 | 85599 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1115 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2014 12:00:00 AM | 3 | 3x3 | 6017434.0078 | 2093308.576 | 37.7288043549368 | -122.381974980078 | (37.7288043549368, -122.381974980078) | 10 | 3 | 8 | 58 | 1 | ||
| 132768 | 95660 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 431 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767422 | 6010656.7 | 2092697.9 | 37.7267509601998 | -122.40536171554 | (37.7267509601998, -122.40536171554) | 10 | 3 | 7 | 309 | 28 | |
| 88606 | 85598 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1101 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 3 | 3x3 | 6017523.881587 | 2093256.051678 | 37.7286650962772 | -122.381660625783 | (37.7286650962772, -122.381660625783) | 10 | 3 | 8 | 58 | 1 | ||
| 190320 | 72375 | Private 9 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 4299X Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/1996 12:00:00 AM | 3x3 | Permit Number 773790 | 5990099.63678033 | 2109979.56687008 | 37.773031079694 | -122.477688796337 | (37.773031079694, -122.477688796337) | 11 | 6 | 2 | 55 | 26 | |
| 105367 | 6784 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1360 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2007 12:00:00 AM | 4 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.7398763247169 | -122.384492742853 | (37.7398763247169, -122.384492742853) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 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 | ||
| 103060 | 13103 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1516 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2008 12:00:00 AM | 3 | 3x3 | 6005111 | 2119918 | 37.8011792509168 | -122.426470375667 | (37.8011792509168, -122.426470375667) | 13 | 9 | 1 | 57 | 17 | ||
| 179720 | 87673 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2610 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2006 12:00:00 AM | 3 | 3x3 | 6010582.741346 | 2086196.470906 | 37.708895230886 | -122.405159783861 | (37.708895230886, -122.405159783861) | 9 | 7 | 8 | 309 | 39 | ||
| 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 | ||
| 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 | |
| 135674 | 188687 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1300 Evans Ave | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/2017 12:53:00 PM | 3 | Width 4ft | 6017556.40659 | 2097171.27575 | 37.7394173230594 | -122.381820390005 | (37.7394173230594, -122.381820390005) | 10 | 3 | 8 | 58 | 1 | ||
| 25377 | 85589 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1566 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015069.619532 | 2095135.418187 | 37.7336896386511 | -122.390276478357 | (37.7336896386511, -122.390276478357) | 10 | 3 | 8 | 58 | 1 |
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) );