Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, SiteOrder, qSiteInfo, qCareAssistant, DBH, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2489 | 2489 | 119760 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2492 | 2492 | 119762 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2501 | 2501 | 119761 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2508 | 2508 | 119759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 5254 | 5254 | 253839 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 94 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6006239.0 | 2097690.0 | 37.740210176126794 | -122.42098789234 | (37.7402101761268, -122.42098789234) | ||||
| 19557 | 19557 | 119842 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 350 Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 65293 | 65293 | 119806 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 251X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6005545.0 | 2110174.0 | 37.7744491774234 | -122.42427513465401 | (37.7744491774234, -122.424275134654) | ||||
| 79671 | 79671 | 115684 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
| 80690 | 80690 | 119841 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 350 Octavia St Frontage East | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 80706 | 80706 | 119853 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 401 Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 81889 | 81889 | 119810 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 250 Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | ||||
| 82267 | 82267 | 114834 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 82773 | 82773 | 119812 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 250 Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | ||||
| 82903 | 82903 | 114822 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 83464 | 83464 | 119866 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451X Octavia St Frontage West | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 84338 | 84338 | 119805 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 251X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6005545.0 | 2110174.0 | 37.7744491774234 | -122.42427513465401 | (37.7744491774234, -122.424275134654) | ||||
| 85800 | 85800 | 119596 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 431 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005470.0 | 2110737.0 | 37.7759908035691 | -122.42457463067 | (37.7759908035691, -122.42457463067) | ||||
| 88602 | 88602 | 114838 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 88617 | 88617 | 115688 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 150X Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005692.21728 | 2109889.45005 | 37.7736761836422 | -122.42374564492701 | (37.7736761836422, -122.423745644927) | ||||
| 89929 | 89929 | 119858 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 431 Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 91588 | 91588 | 119804 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 251X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6005545.0 | 2110174.0 | 37.7744491774234 | -122.42427513465401 | (37.7744491774234, -122.424275134654) | ||||
| 91881 | 91881 | 114825 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 91988 | 91988 | 114837 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 92251 | 92251 | 114828 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 93073 | 93073 | 114824 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 93294 | 93294 | 119598 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 401x Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005458.0 | 2110677.0 | 37.7758253804544 | -122.424611872791 | (37.7758253804544, -122.424611872791) | ||||
| 95582 | 95582 | 119809 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 250 Octavia St Frontage East | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | ||||
| 96058 | 96058 | 119851 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 331 Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 96072 | 96072 | 109161 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200 Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | ||||
| 96639 | 96639 | 111917 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 150X Octavia St Frontage East | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005692.21728 | 2109889.45005 | 37.7736761836422 | -122.42374564492701 | (37.7736761836422, -122.423745644927) | ||||
| 96725 | 96725 | 109157 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 200 OCTAVIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/25/2016 12:00:00 AM | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | |||
| 97014 | 97014 | 109160 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200 Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | ||||
| 97482 | 97482 | 119877 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 450X Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 99034 | 99034 | 106992 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1701X Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2012 12:00:00 AM | 6004025.8 | 2114231.4 | 37.785503891427005 | -122.42981979958701 | (37.785503891427, -122.429819799587) | ||||
| 99656 | 99656 | 119850 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 331 Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 100139 | 100139 | 119864 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451X Octavia St Frontage West | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 101341 | 101341 | 115455 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 300 Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 101488 | 101488 | 119870 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 400X Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 101970 | 101970 | 119856 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 431 Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 102125 | 102125 | 119872 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 400X Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 102395 | 102395 | 119863 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 103270 | 103270 | 114823 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 103508 | 103508 | 106991 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1701X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2014 12:00:00 AM | 6004025.8 | 2114231.4 | 37.785503891427005 | -122.42981979958701 | (37.785503891427, -122.429819799587) | ||||
| 103534 | 103534 | 115686 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
| 104070 | 104070 | 119873 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 400X Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 105377 | 105377 | 114831 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 105813 | 105813 | 114826 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 107925 | 107925 | 119597 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 431 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005470.0 | 2110737.0 | 37.7759908035691 | -122.42457463067 | (37.7759908035691, -122.42457463067) | ||||
| 108079 | 108079 | 119843 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 350 Octavia St Frontage East | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 108332 | 108332 | 114830 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 109355 | 109355 | 119876 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 450X Octavia St Frontage East | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 110359 | 110359 | 114827 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 111648 | 111648 | 119720 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 150X Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005692.21728 | 2109889.45005 | 37.7736761836422 | -122.42374564492701 | (37.7736761836422, -122.423745644927) | ||||
| 112492 | 112492 | 119852 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 331 Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 113327 | 113327 | 115456 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 300 Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 113520 | 113520 | 114821 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 115299 | 115299 | 115687 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
| 118718 | 118718 | 119875 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 450X Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 119612 | 119612 | 96804 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200X Revere Ave | 1 | Median : 22 | Tree 1 | DPW 2 | 6017205.4 | 2092876.1 | 37.7276042330013 | -122.38273521775801 | (37.7276042330013, -122.382735217758) | |||||
| 121524 | 121524 | 119874 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 450X Octavia St Frontage East | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 122170 | 122170 | 114832 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 122392 | 122392 | 114820 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 124671 | 124671 | 119865 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451X Octavia St Frontage West | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 124768 | 124768 | 109159 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200 Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | ||||
| 125682 | 125682 | 115453 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 300 Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 127506 | 127506 | 119859 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 431 Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 139109 | 139109 | 114829 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 139389 | 139389 | 114836 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 140404 | 140404 | 114835 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 141123 | 141123 | 114839 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 143597 | 143597 | 119811 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 250 Octavia St Frontage East | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005726.0 | 2110076.0 | 37.7741903117261 | -122.42364205127599 | (37.7741903117261, -122.423642051276) | ||||
| 143671 | 143671 | 114833 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
| 143683 | 143683 | 115685 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100x Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005589.0 | 2109665.0 | 37.773054070852496 | -122.424086724818 | (37.7730540708525, -122.424086724818) | ||||
| 144990 | 144990 | 119871 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 400X Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 145152 | 145152 | 119844 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 350 Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 145803 | 145803 | 119595 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 431 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005470.0 | 2110737.0 | 37.7759908035691 | -122.42457463067 | (37.7759908035691, -122.42457463067) | ||||
| 118129 | 118129 | 2453 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1801X Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 0 | 4X4 | 6003961.1396892 | 2114603.1916159 | 37.786521075947796 | -122.430070036959 | (37.7865210759478, -122.430070036959) | ||
| 26465 | 26465 | 213721 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 66x Santa Monica Way | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 5993647.57824 | 2097426.08398 | 37.7387677148629 | -122.46450445281401 | (37.7387677148629, -122.464504452814) | ||||
| 27753 | 27753 | 178904 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011792.88406 | 2090769.7339700002 | 37.7215200714836 | -122.401298496839 | (37.7215200714836, -122.401298496839) | |||
| 43899 | 43899 | 214548 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 800 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | Width 4ft | 5993241.508719999 | 2106665.1801299998 | 37.7641124834295 | -122.46657980664 | (37.7641124834295, -122.46657980664) | |||
| 154431 | 154431 | 178903 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011814.45609 | 2090752.0893599999 | 37.7214728265024 | -122.401222688486 | (37.7214728265024, -122.401222688486) | |||
| 158887 | 158887 | 121620 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1300x Kansas St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | 3x3 | 6011700.392659999 | 2102280.30315 | 37.7531205008135 | -122.402427173876 | (37.7531205008135, -122.402427173876) | |||
| 2513 | 2513 | 138183 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1865 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 2 | Width 0ft | 6003936.4381 | 2114774.6580000003 | 37.7869904804487 | -122.43016773530199 | (37.7869904804487, -122.430167735302) | ||
| 2541 | 2541 | 138182 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1865 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 2 | Width 0ft | 6003933.6106 | 2114790.6807 | 37.7870343146011 | -122.43017866131201 | (37.7870343146011, -122.430178661312) | ||
| 2544 | 2544 | 138181 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1865 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 2 | Width 0ft | 6003932.1968 | 2114801.9909 | 37.7870652894849 | -122.43018435992599 | (37.7870652894849, -122.430184359926) | ||
| 2550 | 2550 | 138186 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1865 Buchanan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 0ft | 6003941.622 | 2114719.9923 | 37.786840675810396 | -122.43014589889499 | (37.7868406758104, -122.430145898895) | |||
| 31626 | 31626 | 106986 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1737-1795 Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2012 12:00:00 AM | 2 | 6003814.6942 | 2114193.6153 | 37.7853881873399 | -122.430547466156 | (37.7853881873399, -122.430547466156) | |||
| 37982 | 37982 | 237111 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2x Coso Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6007125.29232 | 2099860.06971 | 37.7462186223039 | -122.418077248072 | (37.7462186223039, -122.418077248072) | ||||
| 50088 | 50088 | 1497 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 325 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5995534.5488977 | 2114067.6155393003 | 37.7845696798314 | -122.45918496626999 | (37.7845696798314, -122.45918496627) | |||
| 51598 | 51598 | 117842 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 620x 39th Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5983810.65643 | 2111554.107 | 37.7769873385843 | -122.499559205901 | (37.7769873385843, -122.499559205901) | |||
| 52167 | 52167 | 214406 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200x Terrace Dr | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5993802.78615 | 2096495.7432 | 37.736222176613104 | -122.463900308969 | (37.7362221766131, -122.463900308969) | ||||
| 60634 | 60634 | 117841 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 600x 39th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5983809.68656 | 2111621.06726 | 37.7771711351486 | -122.499567510814 | (37.7771711351486, -122.499567510814) | |||
| 66160 | 66160 | 214405 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 200x Terrace Dr | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5993807.85396 | 2096495.9519200001 | 37.73622304175571 | -122.46388280274701 | (37.7362230417557, -122.463882802747) | ||||
| 87590 | 87590 | 91928 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X IRVING ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 2 | 3x3 | 5992070.0 | 2106573.0 | 37.7637917074669 | -122.470624962715 | (37.7637917074669, -122.470624962715) | ||
| 98111 | 98111 | 91929 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X IRVING ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2014 12:00:00 AM | 2 | 3x3 | 5992070.0 | 2106573.0 | 37.7637917074669 | -122.470624962715 | (37.7637917074669, -122.470624962715) | ||
| 110833 | 110833 | 16607 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 107 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6002880.641859099 | 2107642.9841193003 | 37.7673488254303 | -122.433310753696 | (37.7673488254303, -122.433310753696) | |||
| 131922 | 131922 | 213728 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 66x San Lorenzo Way | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5993678.600330001 | 2097499.69771 | 37.7389716280322 | -122.464402537152 | (37.7389716280322, -122.464402537152) | ||||
| 132802 | 132802 | 106988 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1737-1795 Post St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2012 12:00:00 AM | 2 | 6003903.841 | 2114208.5386 | 37.7854342126943 | -122.43024011010401 | (37.7854342126943, -122.430240110104) | |||
| 146849 | 146849 | 106987 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1737-1795 Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2012 12:00:00 AM | 2 | 6003830.0102 | 2114195.5789 | 37.78539444652429 | -122.430494617565 | (37.7853944465243, -122.430494617565) | |||
| 148511 | 148511 | 212576 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 100x Idora Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 9ft | 5995353.74805 | 2099410.49817 | 37.74431463161879 | -122.458748984199 | (37.7443146316188, -122.458748984199) |
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");