Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3199 | 3199 | 253365 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1745 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3209 | 3209 | 253364 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1741 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3238 | 3238 | 253363 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1741 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3194 | 3194 | 253362 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1737 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3221 | 3221 | 253361 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1737 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3215 | 3215 | 253360 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1723 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3234 | 3234 | 253359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1723 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3224 | 3224 | 253358 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1715 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3195 | 3195 | 253357 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3205 | 3205 | 253356 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3207 | 3207 | 253355 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3242 | 3242 | 253354 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3229 | 3229 | 253353 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3200 | 3200 | 253352 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1756 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3225 | 3225 | 253351 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1756 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3244 | 3244 | 253350 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1756 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3236 | 3236 | 253349 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1756 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3197 | 3197 | 253348 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1728 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3217 | 3217 | 253347 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3246 | 3246 | 253346 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3233 | 3233 | 253345 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 53803 | 53803 | 250309 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 12 Redfield Aly | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6008474.46022 | 2119519.71704 | 37.800275226579 | -122.414803097987 | (37.800275226579, -122.414803097987) | |||
| 183681 | 183681 | 250308 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 10 Redfield Aly | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6008483.77451 | 2119506.40025 | 37.8002391853351 | -122.41476992380801 | (37.8002391853351, -122.414769923808) | |||
| 52553 | 52553 | 249684 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2400 Baker St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999742.6330699995 | 2117264.679 | 37.793589001891796 | -122.44485636243 | (37.7935890018918, -122.44485636243) | ||||
| 54903 | 54903 | 249683 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2400 Baker St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999743.16478 | 2117253.42108 | 37.7935581209611 | -122.44485371304701 | (37.7935581209611, -122.444853713047) | ||||
| 188711 | 188711 | 249682 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2400 Baker St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999744.1267099995 | 2117244.44172 | 37.7935335209065 | -122.444849738942 | (37.7935335209065, -122.444849738942) | ||||
| 68892 | 68892 | 248602 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 462 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997486.7154 | 2107468.2888 | 37.7665616787282 | -122.451954890142 | (37.7665616787282, -122.451954890142) | |||
| 170059 | 170059 | 248511 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 77 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998828.2482 | 2107822.9016 | 37.7676121046283 | -122.447340309872 | (37.7676121046283, -122.447340309872) | |||
| 38829 | 38829 | 248392 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 707 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997906.1336 | 2108119.2199 | 37.7683729841331 | -122.450551136272 | (37.7683729841331, -122.450551136272) | |||
| 41728 | 41728 | 247994 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 270 Peralta Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6009740.549319999 | 2099529.50478 | 37.7454578138309 | -122.409010652834 | (37.7454578138309, -122.409010652834) | |||
| 47048 | 47048 | 247783 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 274 30th St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6004785.28168 | 2098443.27058 | 37.7421964332069 | -122.42606787825198 | (37.7421964332069, -122.426067878252) | |||
| 43246 | 43246 | 247776 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 228 30th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6005091.07435 | 2098463.74529 | 37.7422699303121 | -122.425011997728 | (37.7422699303121, -122.425011997728) | |||
| 25957 | 25957 | 247414 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 971 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001933.8006 | 2109433.5045 | 37.772211390909 | -122.436713922993 | (37.772211390909, -122.436713922993) | |||
| 172750 | 172750 | 247372 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 475 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002162.1125 | 2110097.0889 | 37.7740464011597 | -122.43597166463002 | (37.7740464011597, -122.43597166463) | |||
| 69173 | 69173 | 247371 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 485 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002156.5991 | 2110137.258 | 37.774156382291295 | -122.435993611299 | (37.7741563822913, -122.435993611299) | |||
| 136440 | 136440 | 247321 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 216 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002799.395 | 2109324.8498 | 37.771962206126794 | -122.433711993285 | (37.7719622061268, -122.433711993285) | |||
| 176835 | 176835 | 247315 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 303 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003239.3513 | 2109346.5826 | 37.7720468334568 | -122.432191704953 | (37.7720468334568, -122.432191704953) | |||
| 155917 | 155917 | 247314 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 303 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003237.761 | 2109364.6049 | 37.7720962280958 | -122.432198493214 | (37.7720962280958, -122.432198493214) | |||
| 50827 | 50827 | 247304 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 247 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002738.4372 | 2109472.2087 | 37.772363358196394 | -122.433933385595 | (37.7723633581964, -122.433933385595) | |||
| 118173 | 118173 | 247294 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 836 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002133.2487 | 2109156.7194 | 37.771462740402995 | -122.436004206745 | (37.771462740403, -122.436004206745) | |||
| 1012 | 1012 | 246499 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 311 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779776 | 6004393.833380001 | 2099835.13521 | 37.7459960419019 | -122.427520522551 | (37.7459960419019, -122.427520522551) | |
| 173334 | 173334 | 246299 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002916.9058 | 2106020.4516 | 37.762895802660296 | -122.433069383163 | (37.7628958026603, -122.433069383163) | |||
| 167652 | 167652 | 246225 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1387 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999540.3508 | 2107874.8368 | 37.7677953711537 | -122.44488098038401 | (37.7677953711537, -122.444880980384) | |||
| 52490 | 52490 | 246224 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1382 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999585.4723 | 2107870.9 | 37.767787136682294 | -122.444724628037 | (37.7677871366823, -122.444724628037) | |||
| 153885 | 153885 | 246222 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1381 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999537.3225 | 2107899.6688 | 37.7678633807549 | -122.444893240119 | (37.7678633807549, -122.444893240119) | |||
| 187927 | 187927 | 246220 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1375 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999535.8083 | 2107910.8735 | 37.767894059626606 | -122.444899283084 | (37.7678940596266, -122.444899283084) | |||
| 181756 | 181756 | 245991 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1250 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999788.9734 | 2108484.4317 | 37.769483351344 | -122.44406483418899 | (37.769483351344, -122.444064834189) | |||
| 172060 | 172060 | 245955 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 450 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997557.5774 | 2107478.8878 | 37.7665948394439 | -122.45171055688999 | (37.7665948394439, -122.45171055689) | |||
| 174739 | 174739 | 245934 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 83 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998834.6076 | 2107782.3225 | 37.7675010480684 | -122.447315392636 | (37.7675010480684, -122.447315392636) | |||
| 184820 | 184820 | 245887 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 204 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001309.3147 | 2109461.0534 | 37.772251523616 | -122.438876043486 | (37.772251523616, -122.438876043486) | |||
| 155982 | 155982 | 245875 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 230 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001285.051 | 2109638.8769 | 37.772738401980604 | -122.438972719673 | (37.7727384019806, -122.438972719673) | |||
| 68326 | 68326 | 245221 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 341 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6005088.7556 | 2110037.9678 | 37.7740498933785 | -122.425843687227 | (37.7740498933785, -122.425843687227) | |||
| 26914 | 26914 | 245213 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1155 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001001.539 | 2109303.6237 | 37.7718017456892 | -122.439929374343 | (37.7718017456892, -122.439929374343) | |||
| 183435 | 183435 | 245195 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 48 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000874.4772 | 2109202.1258 | 37.7715158240845 | -122.440361608185 | (37.7715158240845, -122.440361608185) | |||
| 32011 | 32011 | 245193 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 48 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6000872.1204 | 2109220.0374 | 37.77156487066021 | -122.44037104524901 | (37.7715648706602, -122.440371045249) | |||
| 32986 | 32986 | 245166 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1356 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000067.3756 | 2109215.4243 | 37.771506350919296 | -122.443154362685 | (37.7715063509193, -122.443154362685) | |||
| 25034 | 25034 | 245135 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 108 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000350.1465 | 2109371.4561 | 37.7719508943795 | -122.442187448391 | (37.7719508943795, -122.442187448391) | |||
| 147043 | 147043 | 245121 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1226 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000650.5369 | 2109296.0266 | 37.7717608989394 | -122.441142965804 | (37.7717608989394, -122.441142965804) | |||
| 50138 | 50138 | 245099 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1116 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001200.4602 | 2109374.4683 | 37.7720075888162 | -122.43924637279899 | (37.7720075888162, -122.439246372799) | |||
| 45910 | 45910 | 245066 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 26 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000396.341 | 2109035.0297 | 37.771029784663206 | -122.44200350656999 | (37.7710297846632, -122.44200350657) | |||
| 51623 | 51623 | 245057 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 38 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000389.8085 | 2109086.3569 | 37.7711703439937 | -122.44202978741501 | (37.7711703439937, -122.442029787415) | |||
| 154712 | 154712 | 245028 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1267 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000516.7427 | 2109233.4639 | 37.7715814955912 | -122.441601276959 | (37.7715814955912, -122.441601276959) | |||
| 146378 | 146378 | 245027 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1255 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000554.2196 | 2109238.2078 | 37.771596656285894 | -122.44147198305201 | (37.7715966562859, -122.441471983052) | |||
| 70065 | 70065 | 245026 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1255 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000539.9879 | 2109236.7846 | 37.771591937743295 | -122.441521109042 | (37.7715919377433, -122.441521109042) | |||
| 158425 | 158425 | 245019 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1231 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6000585.055 | 2109242.4773 | 37.7716101359109 | -122.441365628321 | (37.7716101359109, -122.441365628321) | |||
| 154517 | 154517 | 245006 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1201 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000755.8359 | 2109268.0945 | 37.771690201724205 | -122.440776726653 | (37.7716902017242, -122.440776726653) | |||
| 3398 | 3398 | 245004 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1201 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000727.3724 | 2109263.3505 | 37.7716755548589 | -122.44087484303499 | (37.7716755548589, -122.440874843035) | |||
| 3043 | 3043 | 244994 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 231 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | 4 | Width 0ft | Permit Number 45013 | 6005396.3109 | 2110099.8972 | 37.774237312156295 | -122.4247842062 | (37.7742373121563, -122.4247842062) | |
| 147675 | 147675 | 244992 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 249 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005441.5895 | 2109754.3822 | 37.773291168852204 | -122.42460299610501 | (37.7732911688522, -122.424602996105) | |||
| 46789 | 46789 | 244991 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 213 Lily St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6005531.8427 | 2110116.9147 | 37.7742916920696 | -122.424316587333 | (37.7742916920696, -122.424316587333) | |||
| 53665 | 53665 | 244990 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 215 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005497.2001 | 2110113.2681 | 37.7742797231705 | -122.42443616312299 | (37.7742797231705, -122.424436163123) | |||
| 59484 | 59484 | 244989 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 217 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6005482.6137 | 2110109.6215 | 37.7742688867804 | -122.42448636075899 | (37.7742688867804, -122.424486360759) | |||
| 166121 | 166121 | 244988 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 260 Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005214.8927 | 2109749.52 | 37.7732650130646 | -122.42538682585301 | (37.7732650130646, -122.425386825853) | |||
| 39710 | 39710 | 244987 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 260 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6005231.3024 | 2109750.7356 | 37.7732692779132 | -122.425330148953 | (37.7732692779132, -122.425330148953) | |||
| 60303 | 60303 | 244983 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299 Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005200.9141 | 2109719.1317 | 37.7731807843789 | -122.425433016756 | (37.7731807843789, -122.425433016756) | |||
| 37946 | 37946 | 244981 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 200 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6005180.5539 | 2109687.8318 | 37.7730936920725 | -122.425501217452 | (37.7730936920725, -122.425501217452) | |||
| 189068 | 189068 | 244980 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 289 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005226.4402 | 2109722.7783 | 37.7731922392405 | -122.425344978098 | (37.7731922392405, -122.425344978098) | |||
| 30963 | 30963 | 244972 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 209 Rose St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6005534.5777 | 2109768.9686 | 37.7733364706745 | -122.424282374507 | (37.7733364706745, -122.424282374507) | |||
| 72594 | 72594 | 244969 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 215 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005489.602999999 | 2109760.4598 | 37.7733105679298 | -122.424437343055 | (37.7733105679298, -122.424437343055) | |||
| 29296 | 29296 | 244956 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 298 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6005155.9394 | 2109820.0209 | 37.77345526051 | -122.42559577205 | (37.77345526051, -122.42559577205) | |||
| 49526 | 49526 | 244925 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 223 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005441.8933 | 2110105.3671 | 37.77425490559 | -122.424626917474 | (37.77425490559, -122.424626917474) | |||
| 60283 | 60283 | 244907 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 150 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999911.6566 | 2109010.7372 | 37.7709354515424 | -122.443678294205 | (37.7709354515424, -122.443678294205) | |||
| 42071 | 42071 | 244906 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 31 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000351.3383 | 2109052.958 | 37.7710764466514 | -122.442160459028 | (37.7710764466514, -122.442160459028) | |||
| 169463 | 169463 | 244904 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 151 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999860.3433 | 2109070.0361 | 37.7710953445719 | -122.44386004879101 | (37.7710953445719, -122.443860048791) | |||
| 37217 | 37217 | 244897 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 39 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000347.0687 | 2109078.5751 | 37.7711465414406 | -122.442177066871 | (37.7711465414406, -122.442177066871) | |||
| 1472 | 1472 | 244877 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1349 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000105.0 | 2109153.0 | 37.7713370947812 | -122.443019734512 | (37.7713370947812, -122.443019734512) | |||
| 146715 | 146715 | 244518 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 531 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003993.7068 | 2109716.5376 | 37.77310538093779 | -122.42960871992202 | (37.7731053809378, -122.429608719922) | |||
| 24195 | 24195 | 244515 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 426 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003699.3803 | 2109847.5959 | 37.7734485650794 | -122.430636186348 | (37.7734485650794, -122.430636186348) | |||
| 51288 | 51288 | 244389 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005653.9696 | 2110171.6272 | 37.774448814721104 | -122.42389801886002 | (37.7744488147211, -122.42389801886) | |||
| 170836 | 170836 | 244366 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 301 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005514.1663 | 2110403.406 | 37.7750773296011 | -122.424398114747 | (37.7750773296011, -122.424398114747) | |||
| 67122 | 67122 | 244365 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 301 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005511.8056 | 2110439.7613 | 37.775177019128606 | -122.424408867351 | (37.7751770191286, -122.424408867351) | |||
| 57526 | 57526 | 244352 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 300 Octavia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005613.5532 | 2110456.5225 | 37.7752287864343 | -122.42405809140699 | (37.7752287864343, -122.424058091407) | |||
| 853 | 853 | 244350 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 300 Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/20/2017 07:22:00 AM | 3 | Width 0ft | 6005619.219 | 2110418.7508 | 37.77512539438639 | -122.424035805431 | (37.7751253943864, -122.424035805431) | ||
| 56529 | 56529 | 244325 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 463 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003635.8441 | 2109959.3175 | 37.773751725465296 | -122.430863941782 | (37.7737517254653, -122.430863941782) | |||
| 77132 | 77132 | 244320 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 331 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005500.9462 | 2110499.2518 | 37.775339752374 | -122.424450664906 | (37.775339752374, -122.424450664906) | |||
| 343 | 343 | 244298 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 350 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005605.7628 | 2110511.5277 | 37.7753793775331 | -122.42408895277501 | (37.7753793775331, -122.424088952775) | |||
| 71170 | 71170 | 244253 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 200 Octavia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005660.0799 | 2110124.2725 | 37.7743191351223 | -122.423873514167 | (37.7743191351223, -122.423873514167) | |||
| 70934 | 70934 | 244250 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 200 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005666.9539 | 2110073.8626 | 37.7741811097881 | -122.423846150492 | (37.7741811097881, -122.423846150492) | |||
| 45819 | 45819 | 244240 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 251 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005550.0678 | 2110158.7025 | 37.774407460347796 | -122.424256515939 | (37.7744074603478, -122.424256515939) | |||
| 187570 | 187570 | 244239 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 253 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005546.7389 | 2110177.0116 | 37.774457544735604 | -122.424269333697 | (37.7744575447356, -122.424269333697) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");