trees
332 rows where qSpecies_id = 121
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 590 | 75888 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 350 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6011802.87578 | 2118766.0417 | 37.7983922692391 | -122.403232358505 | (37.7983922692391, -122.403232358505) | 3 | 1 | 10 | 308 | 23 | |||
| 1120 | 57868 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 360 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1977 12:00:00 AM | 7 | Permit Number 16812 | 6008032.73051 | 2113659.88131 | 37.7841607298832 | -122.415916474888 | (37.7841607298832, -122.415916474888) | 7 | 10 | 9 | 28858 | 36 | |
| 3372 | 218976 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 208 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6000663.81639 | 2094977.92785 | 37.7324476131567 | -122.440070159711 | (37.7324476131567, -122.440070159711) | 9 | 7 | 5 | 63 | 40 | |||
| 4089 | 260964 | Significant Tree 6 | Fraxinus spp :: Ash Spp 121 | 1100x Vermont St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
| 4630 | 261689 | Significant Tree 6 | Fraxinus spp :: Ash Spp 121 | 1100x Vermont St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
| 4759 | 218967 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 140 Alton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5993644.45362 | 2101662.07824 | 37.7503985047832 | -122.464822793961 | (37.7503985047832, -122.464822793961) | 1 | 8 | 4 | 29491 | 40 | |||
| 5203 | 192229 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009648.37032 | 2108577.40653 | 37.7702961480689 | -122.409968002743 | (37.7702961480689, -122.409968002743) | 8 | 2 | 9 | 28853 | 34 | |||
| 5428 | 192289 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1490 Harrison St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009238.64118 | 2108962.03516 | 37.7713292766491 | -122.411412437151 | (37.7713292766491, -122.411412437151) | 8 | 2 | 9 | 28853 | 34 | |||
| 5817 | 192349 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 262 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008725.32275 | 2109583.20667 | 37.7730060635085 | -122.413231967974 | (37.7730060635085, -122.413231967974) | 8 | 2 | 9 | 28853 | 34 | |||
| 5964 | 192275 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1490 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009036.05094 | 2108770.66843 | 37.7707924632209 | -122.412099681957 | (37.7707924632209, -122.412099681957) | 8 | 2 | 9 | 28853 | 34 | |||
| 6269 | 192348 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 170 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008297.90047 | 2110029.55008 | 37.774207611721 | -122.414742072711 | (37.774207611721, -122.414742072711) | 8 | 2 | 9 | 28853 | 34 | |||
| 6276 | 11636 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | 9 | 8 | 4 | 59 | 40 | |||
| 6430 | 260967 | Significant Tree 6 | Fraxinus spp :: Ash Spp 121 | 1100x Vermont St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
| 6459 | 75974 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 350 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6011885.57896 | 2118777.06264 | 37.7984271485395 | -122.402946954135 | (37.7984271485395, -122.402946954135) | 3 | 1 | 10 | 308 | 23 | |||
| 6766 | 192216 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009448.92717 | 2108828.02796 | 37.7709731163511 | -122.410675580336 | (37.7709731163511, -122.410675580336) | 8 | 2 | 9 | 28853 | 34 | |||
| 9452 | 225805 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 367 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001818.89494 | 2103707.75244 | 37.7564833474558 | -122.436701459403 | (37.7564833474558, -122.436701459403) | 2 | 4 | 5 | 28862 | 3 | |||
| 12339 | 29010 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 113 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008095.19014 | 2110335.08748 | 37.7750351534761 | -122.415464921674 | (37.7750351534761, -122.415464921674) | 8 | 2 | 9 | 28853 | 34 | ||
| 13105 | 75815 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 350 Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6011743.63854 | 2118757.50225 | 37.7983655135139 | -122.403436737532 | (37.7983655135139, -122.403436737532) | 3 | 1 | 10 | 308 | 23 | |||
| 14163 | 128820 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 99 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 4ft | 6008600.12871 | 2112713.96294 | 37.7815953480768 | -122.413886537756 | (37.7815953480768, -122.413886537756) | 7 | 10 | 9 | 28852 | 36 | |||
| 14368 | 30514 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 22 | Permit Number 42913 | 6008785.20324 | 2113547.07327 | 37.783893261596 | -122.413305198882 | (37.783893261596, -122.413305198882) | 7 | 10 | 9 | 28852 | 36 | |
| 14434 | 225800 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 839 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6003765.43327 | 2103426.88271 | 37.7558225759747 | -122.429949607592 | (37.7558225759747, -122.429949607592) | 2 | 4 | 5 | 28862 | 22 | |||
| 14901 | 75920 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 350 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6011822.33856 | 2118769.30011 | 37.7984023029841 | -122.403165240278 | (37.7984023029841, -122.403165240278) | 3 | 1 | 10 | 308 | 23 | |||
| 15908 | 192339 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 59 10th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6007610.66005 | 2110846.20818 | 37.7764113230636 | -122.417177247033 | (37.7764113230636, -122.417177247033) | 8 | 2 | 9 | 28853 | 34 | |||
| 16299 | 192212 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009404.47018 | 2108873.18774 | 37.7710946219563 | -122.410832548904 | (37.7710946219563, -122.410832548904) | 8 | 2 | 9 | 28853 | 34 | |||
| 17089 | 225807 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 144 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6x5 | 6002846.79255 | 2107449.48757 | 37.7668156107901 | -122.433414004758 | (37.7668156107901, -122.433414004758) | 15 | 5 | 5 | 28862 | 3 | |||
| 18079 | 192268 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009073.27718 | 2108601.79495 | 37.7703308646077 | -122.411958979438 | (37.7703308646077, -122.411958979438) | 8 | 2 | 9 | 28853 | 34 | |||
| 18685 | 225385 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 300 Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6004766.71932 | 2101872.10114 | 37.7516101631948 | -122.426376138857 | (37.7516101631948, -122.426376138857) | 2 | 4 | 5 | 28862 | 22 | |||
| 19083 | 192300 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2250 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6011831.68624 | 2102353.37218 | 37.7533284609567 | -122.401978268278 | (37.7533284609567, -122.401978268278) | 10 | 3 | 8 | 28856 | 29 | |||
| 19419 | 75860 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 350 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6011761.31231 | 2118758.70866 | 37.7983698131588 | -122.403375665477 | (37.7983698131588, -122.403375665477) | 3 | 1 | 10 | 308 | 23 | |||
| 20786 | 192390 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 233 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6014050.42421 | 2105956.49266 | 37.7633454309814 | -122.394557641045 | (37.7633454309814, -122.394557641045) | 14 | 3 | 8 | 28856 | 29 | |||
| 21105 | 192200 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 326 10th St | 0 | : | Tree | Private 2 | 7 | Width 3ft | 6008879.18119 | 2109418.2333 | 37.7725617219648 | -122.41268808589 | (37.7725617219648, -122.41268808589) | 8 | 2 | 9 | 28853 | 34 | |||
| 22122 | 128808 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2501 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001383.33039 | 2116587.25055 | 37.7918224564007 | -122.439130852904 | (37.7918224564007, -122.439130852904) | 13 | 6 | 1 | 29490 | 27 | |||
| 23260 | 218969 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 150 Alton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5993603.1998 | 2101661.03992 | 37.7503932752257 | -122.464965376055 | (37.7503932752257, -122.464965376055) | 1 | 8 | 4 | 29491 | 40 | |||
| 23414 | 192211 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009388.56894 | 2108888.96567 | 37.7711370528685 | -122.410888666597 | (37.7711370528685, -122.410888666597) | 8 | 2 | 9 | 28853 | 34 | |||
| 23569 | 128819 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 99 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 4ft | 6008597.39864 | 2112731.9069 | 37.7816444645714 | -122.41389725225 | (37.7816444645714, -122.41389725225) | 7 | 10 | 9 | 28852 | 36 | |||
| 24878 | 192326 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 193 Rhode Island St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6011698.18772 | 2107878.52746 | 37.7684918553317 | -122.402828490057 | (37.7684918553317, -122.402828490057) | 8 | 2 | 8 | 28853 | 20 | |||
| 25433 | 192235 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009557.26279 | 2108491.22918 | 37.7700544184084 | -122.410277059238 | (37.7700544184084, -122.410277059238) | 8 | 2 | 9 | 28853 | 34 | |||
| 25853 | 225384 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 300 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004767.45942 | 2101889.24161 | 37.7516572687753 | -122.426374799776 | (37.7516572687753, -122.426374799776) | 2 | 4 | 5 | 28862 | 22 | |||
| 26051 | 192338 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 59 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6007624.10398 | 2110832.2606 | 37.7763737826504 | -122.417129752033 | (37.7763737826504, -122.417129752033) | 8 | 2 | 9 | 28853 | 34 | |||
| 27506 | 41070 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 255 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1999 12:00:00 AM | 3 | Permit Number 41832 | 6008672.12135 | 2109729.96637 | 37.7734060441945 | -122.413426379828 | (37.7734060441945, -122.413426379828) | 8 | 2 | 9 | 28853 | 34 | |
| 27677 | 192259 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009225.68237 | 2108442.74281 | 37.7699026937941 | -122.411420569714 | (37.7699026937941, -122.411420569714) | 8 | 2 | 9 | 28853 | 34 | |||
| 28623 | 192215 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009439.26153 | 2108838.29328 | 37.7710007606102 | -122.410709739261 | (37.7710007606102, -122.410709739261) | 8 | 2 | 9 | 28853 | 34 | |||
| 29361 | 192269 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009063.69289 | 2108616.03922 | 37.7703694383326 | -122.411993138384 | (37.7703694383326, -122.411993138384) | 8 | 2 | 9 | 28853 | 34 | |||
| 29516 | 192234 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009571.19084 | 2108505.46163 | 37.7700942781462 | -122.410229887119 | (37.7700942781462, -122.410229887119) | 8 | 2 | 9 | 28853 | 34 | |||
| 30062 | 225797 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3000X 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008067.53952 | 2103885.77224 | 37.7573252810462 | -122.415103967973 | (37.7573252810462, -122.415103967973) | 2 | 4 | 7 | 28859 | 19 | |||
| 30125 | 225783 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3251 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6007765.10393 | 2105579.72042 | 37.7619594722828 | -122.416269885947 | (37.7619594722828, -122.416269885947) | 2 | 4 | 7 | 28859 | 19 | |||
| 32271 | 128824 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 600 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6011998.07084 | 2115236.96461 | 37.7887131646294 | -122.402308656723 | (37.7887131646294, -122.402308656723) | 4 | 2 | 10 | 28854 | 6 | |||
| 32745 | 192256 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009265.04555 | 2108401.4321 | 37.7697914719171 | -122.41128149407 | (37.7697914719171, -122.41128149407) | 8 | 2 | 9 | 28853 | 34 | |||
| 32793 | 128821 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 99 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6008602.80861 | 2112693.55273 | 37.7815394570312 | -122.41387582233 | (37.7815394570312, -122.41387582233) | 7 | 10 | 9 | 28852 | 36 | |||
| 32820 | 192262 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009184.59268 | 2108480.10836 | 37.7700029861676 | -122.41156533899 | (37.7700029861676, -122.41156533899) | 8 | 2 | 9 | 28853 | 34 | |||
| 33336 | 192346 | Planning Code 138.1 required 2 | Fraxinus spp :: Ash Spp 121 | 118 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2014 12:00:00 AM | 1 | Width 3ft | Permit Number 770901 | 6007994.19176 | 2110350.54528 | 37.7750719195804 | -122.415815392882 | (37.7750719195804, -122.415815392882) | 8 | 2 | 9 | 28853 | 34 | |
| 34528 | 192263 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009170.52832 | 2108493.74189 | 37.7700396317537 | -122.411614950978 | (37.7700396317537, -122.411614950978) | 8 | 2 | 9 | 28853 | 34 | |||
| 34530 | 92523 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 275 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52874 | 6008729.08615 | 2109670.87254 | 37.7732469846794 | -122.413225150241 | (37.7732469846794, -122.413225150241) | 8 | 2 | 9 | 28853 | 34 | |
| 34565 | 25983 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1901 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x2 | 6013395.85675 | 2096673.78587 | 37.7378206945684 | -122.396170987024 | (37.7378206945684, -122.396170987024) | 10 | 3 | 8 | 58 | 1 | |||
| 35717 | 192245 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009401.17079 | 2108343.15985 | 37.7696391033908 | -122.410806522516 | (37.7696391033908, -122.410806522516) | 8 | 2 | 9 | 28853 | 34 | |||
| 38697 | 29008 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 123 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 6 | 3x3 | 6008118.46736 | 2110307.2661 | 37.7749600708805 | -122.415382430453 | (37.7749600708805, -122.415382430453) | 8 | 2 | 9 | 28853 | 34 | ||
| 39859 | 225383 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 464 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6002919.07295 | 2099218.44031 | 37.7442192171504 | -122.432576000288 | (37.7442192171504, -122.432576000288) | 2 | 7 | 5 | 63 | 22 | |||
| 40347 | 120307 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 100 23rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5988691.32321 | 2114547.33744 | 37.7854910683194 | -122.482895098939 | (37.7854910683194, -122.482895098939) | 11 | 6 | 2 | 55 | 26 | |||
| 40541 | 192213 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009411.17621 | 2108867.66587 | 37.7710798361979 | -122.410808962379 | (37.7710798361979, -122.410808962379) | 8 | 2 | 9 | 28853 | 34 | |||
| 42273 | 128812 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 360 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008015.3478 | 2113733.84894 | 37.7843628498196 | -122.415981852889 | (37.7843628498196, -122.415981852889) | 7 | 10 | 9 | 28858 | 36 | |||
| 43782 | 192315 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 195 Rhode Island St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6011711.98857 | 2107614.42243 | 37.7677674532432 | -122.402762177653 | (37.7677674532432, -122.402762177653) | 8 | 2 | 8 | 28853 | 20 | |||
| 44475 | 192298 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2200 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011908.73866 | 2102359.42769 | 37.7533493881837 | -122.401712229047 | (37.7533493881837, -122.401712229047) | 10 | 3 | 8 | 28856 | 29 | |||
| 45266 | 192356 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1400 Quint St | 3 | : | Tree | Private 2 | 11 | Width 3ft | 6013361.05471 | 2096570.45075 | 37.7375350213353 | -122.396284074954 | (37.7375350213353, -122.396284074954) | 10 | 3 | 8 | 58 | 1 | |||
| 45575 | 192353 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1500 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 2ft | 6015367.94031 | 2101545.1725 | 37.7513060448498 | -122.38969261993 | (37.7513060448498, -122.38969261993) | 10 | 3 | 8 | 28856 | 1 | |||
| 46897 | 192351 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 262 10th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008765.23275 | 2109539.84577 | 37.7728892451858 | -122.413090847292 | (37.7728892451858, -122.413090847292) | 8 | 2 | 9 | 28853 | 34 | |||
| 47020 | 192203 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009293.32816 | 2108991.82453 | 37.7714141384687 | -122.411225376349 | (37.7714141384687, -122.411225376349) | 8 | 2 | 9 | 28853 | 34 | |||
| 47067 | 59141 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 588 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 15 | Permit Number 18448 | 5992243.78964 | 2111491.996 | 37.7773079985249 | -122.470382138383 | (37.7773079985249, -122.470382138383) | 11 | 6 | 2 | 54 | 11 | ||
| 47320 | 192323 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 193 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6011703.78174 | 2107812.61007 | 37.7683111734485 | -122.402804504224 | (37.7683111734485, -122.402804504224) | 8 | 2 | 8 | 28853 | 20 | |||
| 47364 | 218970 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 85 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997504.5128 | 2099195.16066 | 37.7438467530404 | -122.451296605465 | (37.7438467530404, -122.451296605465) | 9 | 7 | 4 | 59 | 40 | |||
| 47711 | 192324 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 193 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6011702.91759 | 2107830.29721 | 37.7683596900813 | -122.40280873733 | (37.7683596900813, -122.40280873733) | 8 | 2 | 8 | 28853 | 20 | |||
| 48366 | 225804 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 4433 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001581.80688 | 2104063.4307 | 37.7574464772949 | -122.437546862602 | (37.7574464772949, -122.437546862602) | 2 | 4 | 5 | 28862 | 3 | |||
| 48385 | 192214 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009421.09589 | 2108858.33176 | 37.7710547630982 | -122.41077399042 | (37.7710547630982, -122.41077399042) | 8 | 2 | 9 | 28853 | 34 | |||
| 48957 | 225816 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 220 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6000887.34044 | 2106474.16774 | 37.7640262618211 | -122.440121464252 | (37.7640262618211, -122.440121464252) | 15 | 5 | 5 | 28862 | 3 | |||
| 48965 | 192240 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009484.38016 | 2108422.4744 | 37.7698615480128 | -122.41052430446 | (37.7698615480128, -122.41052430446) | 8 | 2 | 9 | 28853 | 34 | |||
| 49083 | 192307 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 100 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6011941.53927 | 2107440.75625 | 37.7673034192378 | -122.40195597501 | (37.7673034192378, -122.40195597501) | 8 | 3 | 8 | 28853 | 20 | |||
| 50557 | 128818 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 99 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6008590.07282 | 2112753.66331 | 37.7817037910346 | -122.413924135711 | (37.7817037910346, -122.413924135711) | 7 | 10 | 9 | 28852 | 36 | |||
| 50947 | 128816 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 215 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6008534.84964 | 2112776.47121 | 37.7817633144723 | -122.414116796578 | (37.7817633144723, -122.414116796578) | 7 | 10 | 9 | 28852 | 36 | |||
| 51556 | 124030 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 101 Funston Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5991790.36528 | 2114364.58828 | 37.7851691212148 | -122.472160105538 | (37.7851691212148, -122.472160105538) | 11 | 6 | 2 | 54 | 11 | |||
| 51889 | 33479 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 190 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.7428610132017 | -122.420369801641 | (37.7428610132017, -122.420369801641) | 2 | 7 | 7 | 28859 | 2 | |||
| 52048 | 225387 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 300 Chattanooga St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6004770.30193 | 2101839.2583 | 37.7515201869079 | -122.426361411567 | (37.7515201869079, -122.426361411567) | 2 | 4 | 5 | 28862 | 22 | |||
| 52573 | 225803 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 378 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001778.51091 | 2103657.66309 | 37.7563435190568 | -122.436837535831 | (37.7563435190568, -122.436837535831) | 2 | 4 | 5 | 28862 | 3 | |||
| 53565 | 92547 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 99 Santa Marina St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52890 | 6006207.5 | 2097640.2 | 37.740071660795 | -122.421093271685 | (37.740071660795, -122.421093271685) | 2 | 7 | 7 | 28859 | 2 | |||
| 54804 | 192303 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2250 24th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011758.17653 | 2102347.83114 | 37.7533091435026 | -122.402232092032 | (37.7533091435026, -122.402232092032) | 10 | 3 | 8 | 28856 | 29 | |||
| 54925 | 56313 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 229 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1973 12:00:00 AM | 12 | Permit Number 12447 | 5993040.18993 | 2113916.11955 | 37.7840099974474 | -122.467803508187 | (37.7840099974474, -122.467803508187) | 11 | 6 | 2 | 54 | 11 | ||
| 56172 | 41689 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 117 Conrad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | Permit Number 42143 | 6001812.4652313 | 2096668.95095007 | 37.7371560974157 | -122.436219989049 | (37.7371560974157, -122.436219989049) | 2 | 7 | 5 | 63 | 7 | |||
| 57736 | 192221 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009500.9778 | 2108774.75194 | 37.7708297509354 | -122.410491772396 | (37.7708297509354, -122.410491772396) | 8 | 2 | 9 | 28853 | 34 | |||
| 57801 | 59099 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 488 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 13 | Permit Number 18401 | 5993459.27292 | 2112191.28378 | 37.7792982564624 | -122.466228254831 | (37.7792982564624, -122.466228254831) | 11 | 6 | 2 | 54 | 11 | ||
| 58261 | 192280 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1490 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009110.34419 | 2108839.39222 | 37.7709853309346 | -122.411847556143 | (37.7709853309346, -122.411847556143) | 8 | 2 | 9 | 28853 | 34 | |||
| 60626 | 225817 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 220 States St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6000861.2218 | 2106493.57318 | 37.7640780573843 | -122.440213192391 | (37.7640780573843, -122.440213192391) | 15 | 5 | 5 | 28862 | 3 | |||
| 61347 | 225812 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 197 Noe St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 3ft | 6002912.30789 | 2107203.01713 | 37.7661425797454 | -122.43316978577 | (37.7661425797454, -122.43316978577) | 15 | 5 | 5 | 28862 | 3 | |||
| 61918 | 128811 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 360 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008019.0102 | 2113722.70436 | 37.7843324554077 | -122.415968392744 | (37.7843324554077, -122.415968392744) | 7 | 10 | 9 | 28858 | 36 | |||
| 61981 | 225382 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3614 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005452.14403 | 2105496.18029 | 37.7615997596391 | -122.424263576509 | (37.7615997596391, -122.424263576509) | 8 | 4 | 5 | 28859 | 19 | |||
| 62371 | 25984 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1901 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x2 | 6013408.21183 | 2096665.53237 | 37.7377987196205 | -122.396127690947 | (37.7377987196205, -122.396127690947) | 10 | 3 | 8 | 58 | 1 | |||
| 64625 | 64914 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 65 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1989 12:00:00 AM | 4x4 | Permit Number 25941 | 6005478.3629861 | 2099307.48712071 | 37.7446085231046 | -122.42373284962 | (37.7446085231046, -122.42373284962) | 2 | 7 | 5 | 28859 | 22 | |
| 64809 | 192302 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2250 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011784.47888 | 2102348.07827 | 37.7533112902053 | -122.402141149916 | (37.7533112902053, -122.402141149916) | 10 | 3 | 8 | 28856 | 29 | |||
| 65001 | 192239 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009494.20262 | 2108431.40539 | 37.7698866211063 | -122.410490959396 | (37.7698866211063, -122.410490959396) | 8 | 2 | 9 | 28853 | 34 | |||
| 65660 | 192328 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 237 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008484.68025 | 2109928.45568 | 37.7739405229657 | -122.414088812365 | (37.7739405229657, -122.414088812365) | 8 | 2 | 9 | 28853 | 34 | |||
| 66004 | 192322 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 193 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6011704.56892 | 2107781.11389 | 37.7682247360183 | -122.402799566063 | (37.7682247360183, -122.402799566063) | 8 | 2 | 8 | 28853 | 20 | |||
| 68452 | 192276 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1490 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009052.59315 | 2108786.25199 | 37.7708361801883 | -122.412043563376 | (37.7708361801883, -122.412043563376) | 8 | 2 | 9 | 28853 | 34 | |||
| 68616 | 30522 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 215 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1995 12:00:00 AM | 25 | Permit Number 34528 | 6008488.12717 | 2112769.36057 | 37.7817411659647 | -122.414277931689 | (37.7817411659647, -122.414277931689) | 7 | 10 | 9 | 28852 | 36 |
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) );