Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 136130 | 136130 | 178972 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 856 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009124.92679 | 2086754.6391599998 | 37.7103462396574 | -122.410237598787 | (37.7103462396574, -122.410237598787) | |||
| 156949 | 156949 | 178980 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 38 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998273.4288099995 | 2087174.03892 | 37.7108835719974 | -122.44777265158702 | (37.7108835719974, -122.447772651587) | |||
| 181085 | 181085 | 178981 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 38 Whipple Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998261.9451 | 2087183.3832900003 | 37.7109085731488 | -122.447813014086 | (37.7109085731488, -122.447813014086) | |||
| 34465 | 34465 | 179159 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 113 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001727.04807 | 2087313.1468599997 | 37.711462320802205 | -122.435846103423 | (37.7114623208022, -122.435846103423) | |||
| 151564 | 151564 | 179160 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 113 Seville St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001754.98626 | 2087320.62379 | 37.711484437814896 | -122.43575007652599 | (37.7114844378149, -122.435750076526) | |||
| 26523 | 26523 | 88167 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 189 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2013 12:00:00 AM | 1 | 3x3 | Permit Number 51184 | 6010014.6058 | 2087504.2072 | 37.7124542316575 | -122.40721547231199 | (37.7124542316575, -122.407215472312) | |
| 55797 | 55797 | 178976 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 221 Naglee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5998101.98654 | 2088087.6608 | 37.7133823688881 | -122.448430945451 | (37.7133823688881, -122.448430945451) | |||
| 184405 | 184405 | 179029 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 226 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009880.60922 | 2087872.96636 | 37.7134592690157 | -122.407704592601 | (37.7134592690157, -122.407704592601) | |||
| 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) | |||
| 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) | |||
| 53260 | 53260 | 178985 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 276 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5998310.44307 | 2088707.23579 | 37.7150954964391 | -122.447755025789 | (37.7150954964391, -122.447755025789) | |||
| 36963 | 36963 | 179014 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 174 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004359.78757 | 2090147.3010099998 | 37.7193934976835 | -122.426948390073 | (37.7193934976835, -122.426948390073) | |||
| 56542 | 56542 | 213324 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 355 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5991941.51913 | 2090886.05993 | 37.7207119433918 | -122.469927103079 | (37.7207119433918, -122.469927103079) | |||
| 189007 | 189007 | 214828 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996730.05288 | 2091219.63097 | 37.7219034920315 | -122.453398786937 | (37.7219034920315, -122.453398786937) | |||
| 132513 | 132513 | 202042 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 52 Exeter St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012532.81359 | 2090984.9967200002 | 37.7221523937885 | -122.398755844523 | (37.7221523937885, -122.398755844523) | |||
| 30296 | 30296 | 202045 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 41 Exeter St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012584.35783 | 2091031.2434099999 | 37.7222822496095 | -122.39858091108201 | (37.7222822496095, -122.398580911082) | |||
| 117664 | 117664 | 178989 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 342 Oneida Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5999402.14397 | 2091356.43076 | 37.722431916576795 | -122.444171904613 | (37.7224319165768, -122.444171904613) | |||
| 136084 | 136084 | 214838 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 525 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994748.09139 | 2092048.02975 | 37.7240642697395 | -122.460309866434 | (37.7240642697395, -122.460309866434) | |||
| 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) | |||
| 70081 | 70081 | 214717 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 151 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993452.86708 | 2094012.79018 | 37.729384430533706 | -122.464929844743 | (37.7293844305337, -122.464929844743) | |||
| 48960 | 48960 | 214716 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 163 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993482.35353 | 2094088.81019 | 37.729594862901 | -122.46483342661502 | (37.729594862901, -122.464833426615) | |||
| 165082 | 165082 | 213691 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 292 Circular Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000508.81995 | 2094097.0756400002 | 37.7300201720878 | -122.440542862272 | (37.7300201720878, -122.440542862272) | |||
| 166562 | 166562 | 214763 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 81 Northwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5995479.81772 | 2094208.1402 | 37.7300374777322 | -122.457936663441 | (37.7300374777322, -122.457936663441) | |||
| 28184 | 28184 | 214762 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 81 Northwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5995454.99385 | 2094213.2008599997 | 37.730049946826796 | -122.45802284817199 | (37.7300499468268, -122.458022848172) | |||
| 66203 | 66203 | 214714 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106 Aptos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993036.39091 | 2094292.8856099998 | 37.7301294810876 | -122.466389978617 | (37.7301294810876, -122.466389978617) | |||
| 177159 | 177159 | 179100 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 135 Craut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004051.95756 | 2094086.86306 | 37.73019325200929 | -122.42829307076599 | (37.7301932520093, -122.428293070766) | |||
| 132753 | 132753 | 179101 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 135 Craut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004050.870569999 | 2094104.12464 | 37.730240586937 | -122.428298058407 | (37.730240586937, -122.428298058407) | |||
| 47200 | 47200 | 214819 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001004.15668 | 2094363.7751900002 | 37.730780661291206 | -122.438849530576 | (37.7307806612912, -122.438849530576) | |||
| 65949 | 65949 | 214701 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 289 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992648.14001 | 2094956.6542099998 | 37.7319296144386 | -122.467780457307 | (37.7319296144386, -122.467780457307) | |||
| 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) | |||
| 71520 | 71520 | 213678 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 196 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001770.450019999 | 2095060.16023 | 37.73273634229739 | -122.43625015533001 | (37.7327363422974, -122.43625015533) | |||
| 70897 | 70897 | 237408 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 113 Cuvier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004031.84478 | 2095124.54925 | 37.7330413671563 | -122.42843653693998 | (37.7330413671563, -122.42843653694) | |||
| 174759 | 174759 | 213676 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 180 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001814.64929 | 2095222.55474 | 37.7331847514805 | -122.43610896448 | (37.7331847514805, -122.43610896448) | |||
| 34005 | 34005 | 196506 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6016688.4000699995 | 2094936.9316 | 37.7332342924349 | -122.384666003252 | (37.7332342924349, -122.384666003252) | |||
| 64185 | 64185 | 196507 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 65 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6016757.4280199995 | 2094967.1096700002 | 37.7333209726796 | -122.384429453683 | (37.7333209726796, -122.384429453683) | |||
| 28369 | 28369 | 237264 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 780 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007326.8188 | 2095184.16778 | 37.7333909723093 | -122.417049136835 | (37.7333909723093, -122.417049136835) | |||
| 56297 | 56297 | 179040 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2945 24th Ave | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 5989055.545969999 | 2095618.79902 | 37.7335395942586 | -122.480249118621 | (37.7335395942586, -122.480249118621) | |||
| 48514 | 48514 | 50297 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2909 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 1 | Permit Number 47009 | 5989047.82914 | 2095849.4982599998 | 37.7341725865769 | -122.48029267728701 | (37.7341725865769, -122.480292677287) | |
| 55363 | 55363 | 213618 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 47 Stanford Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5997823.37766 | 2095859.28539 | 37.7347054969618 | -122.449953678441 | (37.7347054969618, -122.449953678441) | |||
| 59938 | 59938 | 237315 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 515 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6008887.93473 | 2095934.39273 | 37.7355386235085 | -122.41170489307501 | (37.7355386235085, -122.411704893075) | |||
| 178004 | 178004 | 237262 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 251 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006011.4232 | 2096130.28963 | 37.735914728990004 | -122.42166401060301 | (37.73591472899, -122.421664010603) | |||
| 165818 | 165818 | 239455 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 201 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001688.324030001 | 2096388.17196 | 37.736378089382704 | -122.436629108958 | (37.7363780893827, -122.436629108958) | |||
| 160445 | 160445 | 239452 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 135 Swiss Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001289.95457 | 2096424.81573 | 37.7364560578872 | -122.438009060187 | (37.7364560578872, -122.438009060187) | |||
| 174043 | 174043 | 237274 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 624 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007643.98133 | 2096429.64875 | 37.7368286272306 | -122.41604078636298 | (37.7368286272306, -122.416040786363) | |||
| 185530 | 185530 | 237333 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 379 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6007360.67513 | 2096538.56664 | 37.7371117589919 | -122.417028018027 | (37.7371117589919, -122.417028018027) | |||
| 38688 | 38688 | 237334 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 379 Highland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6007338.79094 | 2096540.2275099999 | 37.737115088292 | -122.417103799428 | (37.737115088292, -122.417103799428) | |||
| 53356 | 53356 | 238510 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 272 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004605.35635 | 2096606.41263 | 37.737142667797706 | -122.42655923724399 | (37.7371426677977, -122.426559237244) | |||
| 160348 | 160348 | 218239 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 333 Wawona St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 2ft | 5992027.82558 | 2097196.10935 | 37.738042756963296 | -122.47008800346599 | (37.7380427569633, -122.470088003466) | |||
| 30946 | 30946 | 214679 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2662 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991458.95209 | 2097290.33549 | 37.7382685749396 | -122.472061728486 | (37.7382685749396, -122.472061728486) | |||
| 69474 | 69474 | 214675 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2666 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991784.11224 | 2097296.36475 | 37.7383039407656 | -122.47093793473199 | (37.7383039407656, -122.470937934732) | |||
| 148310 | 148310 | 238495 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 160 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004494.89279 | 2097560.99136 | 37.739757479015005 | -122.42700912849199 | (37.739757479015, -122.427009128492) | |||
| 127118 | 127118 | 237289 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 220 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008259.21213 | 2097608.44348 | 37.7400999111754 | -122.413997022154 | (37.7400999111754, -122.413997022154) | |||
| 152727 | 152727 | 214806 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 39 Reposa Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5997950.91184 | 2097983.31568 | 37.7405448705597 | -122.449665760462 | (37.7405448705597, -122.449665760462) | |||
| 66928 | 66928 | 214803 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 861 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5996696.54151 | 2098246.82779 | 37.741196566960795 | -122.454021889422 | (37.7411965669608, -122.454021889422) | |||
| 55168 | 55168 | 214804 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 861 Rockdale Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5996707.74048 | 2098249.43953 | 37.7412043802882 | -122.45398335617399 | (37.7412043802882, -122.453983356174) | |||
| 67306 | 67306 | 237199 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 506 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003244.32891 | 2098942.2749900003 | 37.743479370974896 | -122.43143162557699 | (37.7434793709749, -122.431431625577) | |||
| 65415 | 65415 | 214681 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993846.98731 | 2099285.74524 | 37.743885371716 | -122.463949948827 | (37.743885371716, -122.463949948827) | |||
| 152835 | 152835 | 237409 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 85 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005854.88413 | 2099040.03879 | 37.7438954180548 | -122.422411912884 | (37.7438954180548, -122.422411912884) | |||
| 59593 | 59593 | 237207 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Valley St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6002742.12056 | 2099166.74161 | 37.7440672281147 | -122.433184169536 | (37.7440672281147, -122.433184169536) | ||||
| 168358 | 168358 | 237206 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Valley St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6002728.73401 | 2099167.30182 | 37.7440680069289 | -122.43323049721 | (37.7440680069289, -122.43323049721) | ||||
| 32991 | 32991 | 237208 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Valley St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6002753.541619999 | 2099167.64088 | 37.74407034517979 | -122.433144742342 | (37.7440703451798, -122.433144742342) | ||||
| 42773 | 42773 | 237209 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Valley St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6002775.7731 | 2099167.46556 | 37.744071124872896 | -122.43306785839899 | (37.7440711248729, -122.433067858399) | ||||
| 30654 | 30654 | 237210 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Valley St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6002788.0313800005 | 2099167.4963 | 37.744071904607395 | -122.43302547424 | (37.7440719046074, -122.43302547424) | ||||
| 31049 | 31049 | 237165 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1801 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009370.48822 | 2099100.96041 | 37.7442603881066 | -122.41026001891001 | (37.7442603881066, -122.41026001891) | |||
| 162921 | 162921 | 237202 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 300 Valley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003860.21691 | 2099267.14708 | 37.744406281519296 | -122.42932520110901 | (37.7444062815193, -122.429325201109) | |||
| 43645 | 43645 | 213424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2329 Cecilia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991443.60729 | 2099536.95345 | 37.7444363251911 | -122.47227850735001 | (37.7444363251911, -122.47227850735) | |||
| 36046 | 36046 | 237218 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1534 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003930.350380001 | 2099302.4493400003 | 37.744507183667295 | -122.42908521071699 | (37.7445071836673, -122.429085210717) | |||
| 179381 | 179381 | 213434 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2326 Cecilia Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5991474.66936 | 2099581.1439400003 | 37.7445594585564 | -122.47217432268499 | (37.7445594585564, -122.472174322685) | |||
| 136693 | 136693 | 237414 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 618 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001860.112380001 | 2099445.78199 | 37.744783333975704 | -122.436253917188 | (37.7447833339757, -122.436253917188) | |||
| 183012 | 183012 | 239409 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 38 Newburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6002441.3727400005 | 2099900.5673700003 | 37.746065076544 | -122.434276539152 | (37.746065076544, -122.434276539152) | |||
| 180388 | 180388 | 246511 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 207 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6005075.21268 | 2099872.36362 | 37.746136778598 | -122.42516705074101 | (37.746136778598, -122.425167050741) | |||
| 150275 | 150275 | 237181 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009871.831 | 2099849.755 | 37.7463445040092 | -122.408579286712 | (37.7463445040092, -122.408579286712) | |||
| 62219 | 62219 | 213573 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 401 Dewey Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5995208.70184 | 2100413.07322 | 37.7470591142869 | -122.459323109585 | (37.7470591142869, -122.459323109585) | |||
| 186079 | 186079 | 213586 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2146 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992608.85526 | 2100815.1518900003 | 37.748013300381395 | -122.468342327659 | (37.7480133003814, -122.468342327659) | |||
| 166393 | 166393 | 214768 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 48 Marcela Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5994762.16541 | 2100788.31407 | 37.7480637478616 | -122.460894375369 | (37.7480637478616, -122.460894375369) | |||
| 152202 | 152202 | 214767 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 333 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5994252.85515 | 2100808.3467 | 37.7480894333884 | -122.462656990837 | (37.7480894333884, -122.462656990837) | |||
| 121797 | 121797 | 214666 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2116 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991020.8875 | 2100990.67096 | 37.7484033831124 | -122.473846204659 | (37.7484033831124, -122.473846204659) | |||
| 177005 | 177005 | 214490 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2083 16th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5991275.47389 | 2101260.33758 | 37.7491585600375 | -122.47298552109 | (37.7491585600375, -122.47298552109) | |||
| 113411 | 113411 | 114039 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1328 TREAT WAY | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6008689.0 | 2100921.0 | 37.7492195885474 | -122.412745111821 | (37.7492195885474, -122.412745111821) | ||||
| 29862 | 29862 | 237360 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1328 Treat Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008685.53865 | 2100922.75177 | 37.749224204239 | -122.412757205096 | (37.749224204239, -122.412757205096) | |||
| 34050 | 34050 | 214489 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2083 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5991276.32219 | 2101284.43599 | 37.7492247771203 | -122.47298434476801 | (37.7492247771203, -122.472984344768) | |||
| 153811 | 153811 | 196454 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Cesar Chavez St | 10 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012891.82767 | 2101016.42082 | 37.749716592054206 | -122.398218262172 | (37.7497165920542, -122.398218262172) | |||
| 178948 | 178948 | 196451 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Cesar Chavez St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013299.05466 | 2101039.80695 | 37.7498034800424 | -122.396811684714 | (37.7498034800424, -122.396811684714) | |||
| 147208 | 147208 | 196450 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Cesar Chavez St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013387.24706 | 2101044.34817 | 37.7498208576628 | -122.39650702770001 | (37.7498208576628, -122.3965070277) | |||
| 51276 | 51276 | 214657 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2033 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5990646.87273 | 2101531.01352 | 37.7498653525019 | -122.475178967532 | (37.7498653525019, -122.475178967532) | |||
| 169229 | 169229 | 214485 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2027 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5990955.91795 | 2101581.62177 | 37.7500222167656 | -122.47411397779 | (37.7500222167656, -122.47411397779) | |||
| 170802 | 170802 | 196438 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1300 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015044.32759 | 2101169.27402 | 37.7502559568629 | -122.390785451805 | (37.7502559568629, -122.390785451805) | |||
| 67796 | 67796 | 196439 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1300 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015016.02089 | 2101171.05558 | 37.7502592780626 | -122.39088346350401 | (37.7502592780626, -122.390883463504) | |||
| 25494 | 25494 | 237385 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3100 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008720.74445 | 2101541.69648 | 37.750925664000704 | -122.412679212271 | (37.7509256640007, -122.412679212271) | |||
| 40351 | 40351 | 237387 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3100 25th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008814.668380001 | 2101545.8698 | 37.7509423940946 | -122.412354708115 | (37.7509423940946, -122.412354708115) | |||
| 33402 | 33402 | 237389 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3100 25th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008835.28321 | 2101547.20536 | 37.750947218045795 | -122.412283514173 | (37.7509472180458, -122.412283514173) | |||
| 57522 | 57522 | 237388 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3100 25th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008822.57979 | 2101547.7181599997 | 37.7509479132318 | -122.41232748022699 | (37.7509479132318, -122.412327480227) | |||
| 146631 | 146631 | 237390 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3100 25th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008886.46543 | 2101550.71699 | 37.750959732103 | -122.412106768613 | (37.750959732103, -122.412106768613) | |||
| 73413 | 73413 | 239403 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 338 Hoffman Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6000617.55151 | 2101735.06623 | 37.7509984830156 | -122.440714623806 | (37.7509984830156, -122.440714623806) | |||
| 153480 | 153480 | 239402 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 338 Hoffman Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6000616.75777 | 2101741.19606 | 37.7510152688496 | -122.440717808276 | (37.7510152688496, -122.440717808276) | |||
| 67645 | 67645 | 239401 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 338 Hoffman Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6000615.63827 | 2101746.4158900003 | 37.7510295374914 | -122.440722053988 | (37.7510295374914, -122.440722053988) | |||
| 61617 | 61617 | 239399 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 338 Hoffman Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6000615.20196 | 2101754.98366 | 37.751053037676 | -122.44072417728998 | (37.751053037676, -122.44072417729) | |||
| 165824 | 165824 | 239391 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4174 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002067.4671 | 2101800.93595 | 37.7512618089847 | -122.43570539191299 | (37.7512618089847, -122.435705391913) | |||
| 137230 | 137230 | 239388 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4162 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002133.10623 | 2101804.99651 | 37.7512766864792 | -122.43547869528 | (37.7512766864792, -122.43547869528) | |||
| 26420 | 26420 | 237140 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1285 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010074.8833099995 | 2101754.71583 | 37.7515864768406 | -122.40801147007099 | (37.7515864768406, -122.408011470071) |
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");