Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 59450 | 59450 | 196470 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Newcomb Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 9ft | 6013295.589480001 | 2097174.20298 | 37.7391891560441 | -122.39655273032899 | (37.7391891560441, -122.396552730329) | |||
| 181872 | 181872 | 124180 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8X Almaden Ct | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 9ft | 5995876.0 | 2112606.0 | 37.7805760973259 | -122.457897862346 | (37.7805760973259, -122.457897862346) | |||
| 43020 | 43020 | 238528 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 28 Harry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6003301.9628099995 | 2097731.40275 | 37.740157861699295 | -122.431145932563 | (37.7401578616993, -122.431145932563) | |||
| 153533 | 153533 | 117710 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 477 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5983117.17834 | 2112671.33055 | 37.7800141944428 | -122.502040811752 | (37.7800141944428, -122.502040811752) | |||
| 154192 | 154192 | 214784 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 222 Fowler Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 50 | Width 8ft | 5997118.36808 | 2099147.53648 | 37.7436938709906 | -122.45262836023399 | (37.7436938709906, -122.452628360234) | |||
| 163799 | 163799 | 237426 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4301 26th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6001882.89987 | 2100571.76133 | 37.747876302159796 | -122.436255687975 | (37.7478763021598, -122.436255687975) | |||
| 170080 | 170080 | 237063 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 132 27th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 8ft | 6005626.63256 | 2100241.78482 | 37.7471822602654 | -122.423286564723 | (37.7471822602654, -122.423286564723) | |||
| 175560 | 175560 | 214826 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5999324.23026 | 2093457.23325 | 37.728195788502795 | -122.444592150628 | (37.7281957885028, -122.444592150628) | |||
| 175710 | 175710 | 124184 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Almaden Ct | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 5995890.93647 | 2112594.82496 | 37.780546271753295 | -122.457845381425 | (37.7805462717533, -122.457845381425) | |||
| 176683 | 176683 | 179153 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 412 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 8ft | 6001969.08964 | 2086773.8202799999 | 37.7099951946836 | -122.434970999229 | (37.7099951946836, -122.434970999229) | |||
| 181976 | 181976 | 136014 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Havens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6007575.68988 | 2119392.2209400004 | 37.7998746136871 | -122.417904161874 | (37.7998746136871, -122.417904161874) | |||
| 187914 | 187914 | 135943 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2056 Jefferson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5999351.778519999 | 2121203.50658 | 37.8043816542415 | -122.446492250814 | (37.8043816542415, -122.446492250814) | |||
| 43068 | 43068 | 196481 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2075 Palou Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 6012348.976530001 | 2097093.78891 | 37.738915629056 | -122.399820067148 | (37.738915629056, -122.399820067148) | |||
| 132071 | 132071 | 238045 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 38 Dolores St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 6004739.1194 | 2107851.95841 | 37.7680278762037 | -122.426897421898 | (37.7680278762037, -122.426897421898) | |||
| 160988 | 160988 | 202147 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1979 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 6012955.252309999 | 2093506.82348 | 37.72910034549879 | -122.397472339298 | (37.7291003454988, -122.397472339298) | |||
| 3739 | 3739 | 237154 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 861 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1992 12:00:00 AM | 5 | Width 6ft | Permit Number 30833 | 6010197.69553 | 2104230.40256 | 37.7583910361238 | -122.407761316458 | (37.7583910361238, -122.407761316458) | |
| 23638 | 23638 | 179012 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 Lisbon St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6001860.73543 | 2090148.2767900003 | 37.719254552441704 | -122.435586742551 | (37.7192545524417, -122.435586742551) | |||
| 24513 | 24513 | 213290 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 155 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5994132.71522 | 2090951.16156 | 37.721017116620004 | -122.46235759304399 | (37.72101711662, -122.462357593044) | |||
| 26752 | 26752 | 250523 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 95 26th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5987685.92853 | 2115397.50584 | 37.78776683682629 | -122.48643586433998 | (37.7877668368263, -122.48643586434) | |||
| 32271 | 32271 | 237025 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Octavia St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 6ft | 6005760.04076 | 2109480.81274 | 37.7725579925006 | -122.423481975714 | (37.7725579925006, -122.423481975714) | |||
| 35376 | 35376 | 179161 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 233 Naylor St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002647.79999 | 2086739.6543400001 | 37.7099398962889 | -122.432622809119 | (37.7099398962889, -122.432622809119) | |||
| 36554 | 36554 | 120353 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2240 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 5988483.640819999 | 2114700.0523900003 | 37.7858982939261 | -122.48362481032801 | (37.7858982939261, -122.483624810328) | |||
| 39369 | 39369 | 250521 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 95 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5987685.5238 | 2115445.0256 | 37.787897288863796 | -122.48644075485201 | (37.7878972888638, -122.486440754852) | |||
| 42217 | 42217 | 237026 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Octavia St | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 6ft | 6005759.75569 | 2109493.68206 | 37.7725933124646 | -122.423483876889 | (37.7725933124646, -122.423483876889) | |||
| 42756 | 42756 | 237448 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4609 25th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6000549.980269999 | 2101082.72419 | 37.7492034604754 | -122.440901499304 | (37.7492034604754, -122.440901499304) | |||
| 43648 | 43648 | 239467 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1285 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 6ft | 5997501.9107 | 2105032.0283 | 37.7598731953164 | -122.451726570432 | (37.7598731953164, -122.451726570432) | |||
| 44659 | 44659 | 237153 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 758 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 6010110.83147 | 2104756.28299 | 37.759830122280704 | -122.408098819429 | (37.7598301222807, -122.408098819429) | |||
| 46558 | 46558 | 237027 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Octavia St | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 6ft | 6005758.332230001 | 2109504.65873 | 37.772623371413495 | -122.423489581302 | (37.7726233714135, -122.423489581302) | |||
| 49350 | 49350 | 237136 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1346 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 6ft | 6010061.84572 | 2101335.33586 | 37.7504342222613 | -122.40802698336901 | (37.7504342222613, -122.408026983369) | |||
| 57338 | 57338 | 237123 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1049 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 6008643.89723 | 2102440.9012700003 | 37.7533903648753 | -122.41300853052799 | (37.7533903648753, -122.413008530528) | |||
| 61128 | 61128 | 214484 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1868 17th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5990968.36883 | 2102715.12154 | 37.753135231722396 | -122.47415361899598 | (37.7531352317224, -122.474153618996) | |||
| 71219 | 71219 | 214483 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1868 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5990967.174319999 | 2102702.6319999998 | 37.7531008695265 | -122.47415683856899 | (37.7531008695265, -122.474156838569) | |||
| 129749 | 129749 | 237029 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Octavia St | 10 | : 4 | Tree 1 | Private 1 | 3 | Width 6ft | 6005753.2097 | 2109536.23847 | 37.7727097926437 | -122.423509546241 | (37.7727097926437, -122.423509546241) | |||
| 131462 | 131462 | 179011 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 579 Lisbon St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6001850.91399 | 2090131.7943 | 37.71920873736379 | -122.435619512955 | (37.7192087373638, -122.435619512955) | |||
| 132655 | 132655 | 250524 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 95 26th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5987685.45058 | 2115374.99193 | 37.7877049922276 | -122.486435864334 | (37.7877049922276, -122.486435864334) | |||
| 135228 | 135228 | 237060 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 199 Tiffany Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 6006047.428119999 | 2099152.06421 | 37.7442138742778 | -122.421754094776 | (37.7442138742778, -122.421754094776) | |||
| 136178 | 136178 | 214696 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 550 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 5994229.95008 | 2099570.5306599997 | 37.744689383614 | -122.462646416624 | (37.744689383614, -122.462646416624) | |||
| 137780 | 137780 | 213680 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 94 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6001486.953319999 | 2094958.6279799999 | 37.732441446519104 | -122.437223005055 | (37.7324414465191, -122.437223005055) | |||
| 148231 | 148231 | 214699 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 572 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 5994083.55737 | 2099431.17375 | 37.7442983125168 | -122.46314250065001 | (37.7442983125168, -122.46314250065) | |||
| 153351 | 153351 | 237141 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1247 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 6010327.593859999 | 2101954.7488 | 37.7521498688327 | -122.40715165974702 | (37.7521498688327, -122.407151659747) | |||
| 153474 | 153474 | 196471 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Middle Point Rd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6018269.46967 | 2096338.3756 | 37.7371696942217 | -122.379297066815 | (37.7371696942217, -122.379297066815) | |||
| 155780 | 155780 | 214697 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 550 Dewey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 5994224.09398 | 2099564.9387 | 37.7446736922334 | -122.462666260157 | (37.7446736922334, -122.462666260157) | |||
| 157642 | 157642 | 237127 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 501 York St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6009827.96491 | 2105859.23915 | 37.7628427477209 | -122.409154949944 | (37.7628427477209, -122.409154949944) | |||
| 164685 | 164685 | 237058 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 61 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 6ft | 6006122.75596 | 2099931.6661799997 | 37.7463587321654 | -122.421548984621 | (37.7463587321654, -122.421548984621) | |||
| 164891 | 164891 | 237135 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1346 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 6ft | 6010061.02642 | 2101350.15065 | 37.7504748545291 | -122.408030861231 | (37.7504748545291, -122.408030861231) | |||
| 166035 | 166035 | 214700 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200x Vasquez Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 6ft | 5994642.56982 | 2099211.09063 | 37.7437262061113 | -122.461193618499 | (37.7437262061113, -122.461193618499) | |||
| 169418 | 169418 | 237059 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 199 Tiffany Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6006039.83494 | 2099139.1612299997 | 37.7441780174179 | -122.42177943406901 | (37.7441780174179, -122.421779434069) | |||
| 172057 | 172057 | 237137 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1447 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6010126.81888 | 2100822.77716 | 37.749030486662605 | -122.40776616289 | (37.7490304866626, -122.40776616289) | |||
| 173955 | 173955 | 179013 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 Lisbon St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6001863.70015 | 2090153.04553 | 37.719267814726 | -122.435576835623 | (37.719267814726, -122.435576835623) | |||
| 181028 | 181028 | 237124 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1025 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6008637.74753 | 2102555.44614 | 37.7537045340508 | -122.413037896084 | (37.7537045340508, -122.413037896084) | |||
| 183294 | 183294 | 237062 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 189 Tiffany Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6006064.26727 | 2099183.21264 | 37.7443003503954 | -122.421698080498 | (37.7443003503954, -122.421698080498) | |||
| 185578 | 185578 | 214698 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 550 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 5994208.796569999 | 2099551.1927 | 37.7446350681495 | -122.46271815822901 | (37.7446350681495, -122.462718158229) | |||
| 185970 | 185970 | 237122 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2957 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 6ft | 6009722.71045 | 2101009.1052200003 | 37.749519471442206 | -122.40917672522 | (37.7495194714422, -122.40917672522) | |||
| 23779 | 23779 | 213682 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Baden St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6000730.9848 | 2095013.8875 | 37.7325501736469 | -122.43984052053801 | (37.7325501736469, -122.439840520538) | |||
| 27296 | 27296 | 213681 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6000730.35653 | 2095033.04499 | 37.7326027399078 | -122.439844065674 | (37.7326027399078, -122.439844065674) | |||
| 31074 | 31074 | 237092 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600 15th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006640.82063 | 2107331.42339 | 37.766705953729 | -122.420282681595 | (37.766705953729, -122.420282681595) | |||
| 32898 | 32898 | 237151 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 601 Hampshire St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6010131.8746 | 2105435.17727 | 37.761695390857795 | -122.40807391988001 | (37.7616953908578, -122.40807391988) | |||
| 33059 | 33059 | 135939 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Walnut St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5998471.02227 | 2116380.3328400003 | 37.7910881707365 | -122.44919247964701 | (37.7910881707365, -122.449192479647) | |||
| 34215 | 34215 | 179115 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Yale St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6006932.90152 | 2093437.9228299998 | 37.7285739974769 | -122.41828725417 | (37.7285739974769, -122.41828725417) | |||
| 34528 | 34528 | 238223 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 151 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6004139.72853 | 2102237.92914 | 37.7525791790987 | -122.42857042708599 | (37.7525791790987, -122.428570427086) | |||
| 35914 | 35914 | 196425 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 282 Shipley St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6011155.7597199995 | 2111427.64984 | 37.778206627062296 | -122.404954631245 | (37.7782066270623, -122.404954631245) | |||
| 37093 | 37093 | 238317 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 80 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6000563.230830001 | 2104921.8259099997 | 37.7597454565059 | -122.441131080058 | (37.7597454565059, -122.441131080058) | |||
| 40503 | 40503 | 239548 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 229 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6006756.29841 | 2097775.0153900003 | 37.7404727557057 | -122.419205308176 | (37.7404727557057, -122.419205308176) | |||
| 42344 | 42344 | 238318 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 23 Clover Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6000458.56738 | 2105088.99316 | 37.760198494491796 | -122.441505054123 | (37.7601984944918, -122.441505054123) | |||
| 47849 | 47849 | 238220 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 408 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6004143.86901 | 2101473.06412 | 37.7504792729009 | -122.42850159479799 | (37.7504792729009, -122.428501594798) | |||
| 50315 | 50315 | 237149 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 601 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6010132.87275 | 2105399.32846 | 37.7615970140239 | -122.408067939392 | (37.7615970140239, -122.408067939392) | |||
| 53796 | 53796 | 237094 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600 15th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006486.26316 | 2107324.29875 | 37.7666776808499 | -122.420816764707 | (37.7666776808499, -122.420816764707) | |||
| 55416 | 55416 | 237434 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1206 Diamond St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 6001928.49113 | 2100507.97364 | 37.7477037465288 | -122.436093471852 | (37.7477037465288, -122.436093471852) | |||
| 55934 | 55934 | 213683 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Baden St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6000730.40073 | 2094998.07335 | 37.732506718412 | -122.43984140637 | (37.732506718412, -122.43984140637) | |||
| 59687 | 59687 | 135938 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Walnut St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5998466.03707 | 2116398.7314400002 | 37.791138403269294 | -122.44921105427 | (37.7911384032693, -122.44921105427) | |||
| 63304 | 63304 | 213383 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 337 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5996461.62761 | 2106582.16791 | 37.764069850154904 | -122.455436416867 | (37.7640698501549, -122.455436416867) | |||
| 68328 | 68328 | 237091 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600 15th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006652.5626300005 | 2107332.55511 | 37.7667097228027 | -122.42024214826598 | (37.7667097228027, -122.420242148266) | |||
| 68476 | 68476 | 179033 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 88 Alpha St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6011104.28456 | 2088327.78048 | 37.7147765222032 | -122.40350709418001 | (37.7147765222032, -122.40350709418) | |||
| 71248 | 71248 | 238254 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6002935.27424 | 2105635.73424 | 37.7618405036566 | -122.43297836596399 | (37.7618405036566, -122.432978365964) | |||
| 71827 | 71827 | 196444 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200x Kansas St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 6011674.76736 | 2102721.10758 | 37.7543294225845 | -122.402546786399 | (37.7543294225845, -122.402546786399) | |||
| 129524 | 129524 | 120701 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 70 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 5988982.8407 | 2114887.49266 | 37.7864419959893 | -122.48191147245501 | (37.7864419959893, -122.481911472455) | |||
| 130467 | 130467 | 214480 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1406 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5990546.58136 | 2105796.37428 | 37.7615710910435 | -122.475837228101 | (37.7615710910435, -122.475837228101) | |||
| 131579 | 131579 | 237152 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 601 Hampshire St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6010131.8427099995 | 2105445.9441400003 | 37.7617249524607 | -122.408074789522 | (37.7617249524607, -122.408074789522) | |||
| 134644 | 134644 | 237087 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006704.33245 | 2107335.9547099997 | 37.7667219742591 | -122.420063326182 | (37.7667219742591, -122.420063326182) | |||
| 134984 | 134984 | 179034 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 88 Alpha St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6011090.19294 | 2088313.2717799998 | 37.7147358971229 | -122.403554780747 | (37.7147358971229, -122.403554780747) | |||
| 135345 | 135345 | 238107 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 149 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6006184.05234 | 2102126.82183 | 37.752389584027796 | -122.42149290108601 | (37.7523895840278, -122.421492901086) | |||
| 135424 | 135424 | 237150 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 601 Hampshire St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6010131.8199 | 2105423.31362 | 37.7616628128969 | -122.40807327236799 | (37.7616628128969, -122.408073272368) | |||
| 157718 | 157718 | 238227 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 62 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6004074.9323 | 2102707.3864599997 | 37.753864531534 | -122.428827968657 | (37.753864531534, -122.428827968657) | |||
| 158700 | 158700 | 238226 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 62 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6004072.81767 | 2102724.1328 | 37.7539103933597 | -122.428836475319 | (37.7539103933597, -122.428836475319) | |||
| 160155 | 160155 | 238106 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 149 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6006183.4276 | 2102112.77314 | 37.7523509743301 | -122.421494063899 | (37.7523509743301, -122.421494063899) | |||
| 160605 | 160605 | 237095 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600 15th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006471.77901 | 2107323.9095799997 | 37.7666757958826 | -122.42086683535801 | (37.7666757958826, -122.420866835358) | |||
| 161020 | 161020 | 213320 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 238 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5991458.7746 | 2090762.7040099998 | 37.720345321258705 | -122.47158680100901 | (37.7203453212587, -122.471586801009) | |||
| 165673 | 165673 | 213384 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 337 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5996440.690219999 | 2106573.21313 | 37.7640440612137 | -122.45550818547899 | (37.7640440612137, -122.455508185479) | |||
| 166772 | 166772 | 237090 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006663.587230001 | 2107332.32887 | 37.766709722802 | -122.420203999914 | (37.766709722802, -122.420203999914) | |||
| 170292 | 170292 | 237099 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3571 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6005122.2965400005 | 2106016.8849299997 | 37.7630108606773 | -122.425441442891 | (37.7630108606773, -122.425441442891) | |||
| 171222 | 171222 | 237079 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1300 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6011116.28674 | 2102209.6189099997 | 37.7528937925351 | -122.404442163398 | (37.7528937925351, -122.404442163398) | |||
| 173492 | 173492 | 196442 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 971 Kansas St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 5ft | 6011633.4910699995 | 2103859.13783 | 37.7574518984069 | -122.402769561075 | (37.7574518984069, -122.402769561075) | |||
| 174956 | 174956 | 237089 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006678.09953 | 2107334.09058 | 37.7667153777448 | -122.420153929277 | (37.7667153777448, -122.420153929277) | |||
| 176153 | 176153 | 237433 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1206 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 6001927.83941 | 2100530.44886 | 37.747765421138794 | -122.43609733352699 | (37.7477654211388, -122.436097333527) | |||
| 178997 | 178997 | 237074 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 405 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6005515.14346 | 2101298.89105 | 37.75007853859471 | -122.423747237058 | (37.7500785385947, -122.423747237058) | |||
| 184502 | 184502 | 237093 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600 15th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006628.38963 | 2107330.3055 | 37.7667021837902 | -122.420325599041 | (37.7667021837902, -122.420325599041) | |||
| 186721 | 186721 | 213319 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 262 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5991459.9673 | 2090912.89222 | 37.7207577701313 | -122.471593616958 | (37.7207577701313, -122.471593616958) | |||
| 188235 | 188235 | 196437 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2125 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6011358.58417 | 2105543.63854 | 37.762061808827795 | -122.40383883519199 | (37.7620618088278, -122.403838835192) | |||
| 188604 | 188604 | 237088 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6006692.25312 | 2107335.17282 | 37.7667191467912 | -122.420105051126 | (37.7667191467912, -122.420105051126) | |||
| 34 | 34 | 240126 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006399.28254 | 2110261.0751 | 37.7747364652596 | -122.42132618837299 | (37.7747364652596, -122.421326188373) |
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");