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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 186644 | 186644 | 123107 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 526 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992541.355380001 | 2111846.16706 | 37.778297656419795 | -122.469378557612 | (37.7782976564198, -122.469378557612) | |||
| 186347 | 186347 | 47388 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 476Howard Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | 1 | Permit Number 45304 | 6010838.51311 | 2112011.8477 | 37.7797929592141 | -122.406093276399 | (37.7797929592141, -122.406093276399) | ||
| 186256 | 186256 | 196495 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 728 Brannan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012138.917640001 | 2110082.47387 | 37.7745679907399 | -122.401458945783 | (37.7745679907399, -122.401458945783) | |||
| 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) | |||
| 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) | |||
| 185481 | 185481 | 51890 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 475 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | 1 | Permit Number 48103 | 6010867.53759 | 2112000.42013 | 37.779763205136206 | -122.40599206220301 | (37.7797632051362, -122.405992062203) | ||
| 185212 | 185212 | 119495 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 831 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5986317.41656 | 2110242.64878 | 37.773533209765795 | -122.49079114745199 | (37.7735332097658, -122.490791147452) | |||
| 184686 | 184686 | 237254 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 210 Upper Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5999583.74479 | 2106347.4136 | 37.7636039258024 | -122.444621090805 | (37.7636039258024, -122.444621090805) | |||
| 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) | |||
| 184263 | 184263 | 214495 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1475 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991461.16113 | 2105386.7472200003 | 37.7604993473767 | -122.47264423464199 | (37.7604993473767, -122.472644234642) | |||
| 184129 | 184129 | 32690 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 480 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 1 | Permit Number 37101 | 6010817.622359999 | 2111993.44255 | 37.7797412544913 | -122.406164249981 | (37.7797412544913, -122.406164249981) | |
| 183107 | 183107 | 238385 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 69 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002032.14652 | 2105479.21317 | 37.7613594670847 | -122.436090720833 | (37.7613594670847, -122.436090720833) | |||
| 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) | |||
| 182210 | 182210 | 214639 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1243 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993279.97178 | 2107044.2021 | 37.7651553975224 | -122.46647432513399 | (37.7651553975224, -122.466474325134) | |||
| 182146 | 182146 | 237253 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 210 Upper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5999591.4299099995 | 2106376.56541 | 37.7636844079359 | -122.444596605852 | (37.7636844079359, -122.444596605852) | |||
| 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) | |||
| 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) | |||
| 180951 | 180951 | 73633 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 782 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 1 | 5983562.4874599995 | 2110479.0519 | 37.7740209842304 | -122.500338183608 | (37.7740209842304, -122.500338183608) | ||
| 180438 | 180438 | 103498 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1850X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2014 12:00:00 AM | 1 | 3x3 | Permit Number 771036 | 5989807.55073 | 2110619.1422900003 | 37.774770222887604 | -122.478745931564 | (37.7747702228876, -122.478745931564) | |
| 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) | |||
| 180053 | 180053 | 135949 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Alhambra St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001899.24184 | 2120659.238 | 37.803032411275794 | -122.43763755203199 | (37.8030324112758, -122.437637552032) | |||
| 180014 | 180014 | 100870 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 23 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769325 | 5995481.9791 | 2111446.40578 | 37.7773695144675 | -122.45917696584299 | (37.7773695144675, -122.459176965843) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 177218 | 177218 | 196429 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 506 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010627.659580001 | 2105903.22248 | 37.7630082841384 | -122.406392171455 | (37.7630082841384, -122.406392171455) | |||
| 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) | |||
| 177092 | 177092 | 94734 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53865 | 5992586.2471199995 | 2110603.0007 | 37.7748868521692 | -122.46913276056002 | (37.7748868521692, -122.46913276056) |
| 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) | |||
| 175693 | 175693 | 124157 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 970 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5995831.42602 | 2112225.3212200003 | 37.779528293484894 | -122.45802450638 | (37.7795282934849, -122.45802450638) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 173553 | 173553 | 238322 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 129 Danvers St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5999949.71175 | 2105076.00493 | 37.760133828727795 | -122.44326400665199 | (37.7601338287278, -122.443264006652) | |||
| 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) | |||
| 172144 | 172144 | 214549 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 820 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993190.74703 | 2106665.16617 | 37.7641095156677 | -122.466755374078 | (37.7641095156677, -122.466755374078) | |||
| 171618 | 171618 | 68224 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1500 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/2012 12:00:00 AM | 1 | Permit Number 769229 | 5990833.387490001 | 2113424.07906 | 37.782531317215295 | -122.47540222511999 | (37.7825313172153, -122.47540222512) | |
| 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) | |||
| 170297 | 170297 | 65278 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 415 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1989 12:00:00 AM | 1 | Permit Number 28081 | 6011215.3927 | 2112332.46737 | 37.7806943784819 | -122.40481205633999 | (37.7806943784819, -122.40481205634) | |
| 170172 | 170172 | 59138 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 531 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 1 | Permit Number 18444 | 5992185.73773 | 2111803.62567 | 37.7781602921817 | -122.47060565987302 | (37.7781602921817, -122.470605659873) | ||
| 169821 | 169821 | 213590 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1922 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993177.337040001 | 2102373.1853099996 | 37.7523240792136 | -122.466489781784 | (37.7523240792136, -122.466489781784) | |||
| 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) | |||
| 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) | ||||
| 168286 | 168286 | 214628 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1442 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5992754.41359 | 2105631.11276 | 37.7612450859223 | -122.468189283707 | (37.7612450859223, -122.468189283707) | |||
| 168022 | 168022 | 237126 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 900 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008561.82249 | 2103234.1225799997 | 37.7555637636748 | -122.41334845447099 | (37.7555637636748, -122.413348454471) | |||
| 166961 | 166961 | 238334 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 286 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002701.12407 | 2104251.52183 | 37.7580265058249 | -122.433689263855 | (37.7580265058249, -122.433689263855) | |||
| 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) | |||
| 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) | |||
| 166226 | 166226 | 237252 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 210 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5999600.48893 | 2106400.12324 | 37.7637496087851 | -122.444566966886 | (37.7637496087851, -122.444566966886) | |||
| 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) | |||
| 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) | |||
| 165715 | 165715 | 214643 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1262 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5993331.87743 | 2106912.72627 | 37.764797394518204 | -122.466285241766 | (37.7647973945182, -122.466285241766) | |||
| 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) | |||
| 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) | |||
| 164471 | 164471 | 196494 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 728 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012174.00966 | 2110114.91402 | 37.7746590219179 | -122.40133983507401 | (37.7746590219179, -122.401339835074) | |||
| 164042 | 164042 | 196428 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 506 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010626.46866 | 2105919.55738 | 37.7630530694618 | -122.406397441508 | (37.7630530694618, -122.406397441508) | |||
| 163690 | 163690 | 135948 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 31 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001895.29837 | 2120693.9243 | 37.8031274264634 | -122.437653684066 | (37.8031274264634, -122.437653684066) | |||
| 163678 | 163678 | 81982 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 563 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49998 | 5982533.65676 | 2111927.12728 | 37.7779365331701 | -122.504004303472 | (37.7779365331701, -122.504004303472) | |
| 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) | |||
| 162833 | 162833 | 238262 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4066 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002572.00023 | 2104752.04885 | 37.759393505012 | -122.434171609857 | (37.759393505012, -122.434171609857) | |||
| 160586 | 160586 | 95194 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 517 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767108 | 5985627.976369999 | 2112321.20657 | 37.7792000368481 | -122.49332915492701 | (37.7792000368481, -122.493329154927) | |
| 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) | |||
| 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) | |||
| 159935 | 159935 | 123886 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 235 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992114.67796 | 2113795.92215 | 37.7836264835221 | -122.47099665339701 | (37.7836264835221, -122.470996653397) | |||
| 159910 | 159910 | 237243 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 36 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998389.08312 | 2106273.98135 | 37.7633340563385 | -122.44874774241501 | (37.7633340563385, -122.448747742415) | |||
| 159297 | 159297 | 196436 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2400 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010604.60023 | 2105553.40637 | 37.762046478073 | -122.40644727563101 | (37.762046478073, -122.406447275631) | |||
| 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) | |||
| 158832 | 158832 | 114543 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2035 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774983 | 6011964.29912 | 2103715.1701700003 | 37.7570750599871 | -122.401615369369 | (37.7570750599871, -122.401615369369) | ||
| 158648 | 158648 | 123574 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 126 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994298.992459999 | 2114690.05308 | 37.786207615068896 | -122.463504728187 | (37.7862076150689, -122.463504728187) | |||
| 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) | |||
| 156663 | 156663 | 238335 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 286 Hartford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002701.390980001 | 2104221.40277 | 37.7579438212587 | -122.433686188181 | (37.7579438212587, -122.433686188181) | |||
| 155840 | 155840 | 123928 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 229 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993040.69288 | 2113905.84608 | 37.783981818349396 | -122.467801020728 | (37.7839818183494, -122.467801020728) | |||
| 155442 | 155442 | 88202 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 436 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51208 | 6011181.036719999 | 2112067.6395 | 37.779965302598704 | -122.404912259701 | (37.7799653025987, -122.404912259701) | |
| 155038 | 155038 | 119498 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 811 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5986314.77262 | 2110365.9929400003 | 37.773871723515 | -122.49080937068999 | (37.773871723515, -122.49080937069) | |||
| 154905 | 154905 | 214630 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1603 10th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993055.4787 | 2104534.05584 | 37.758250237384 | -122.46706827337499 | (37.758250237384, -122.467068273375) | |||
| 154891 | 154891 | 239397 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 122 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000587.76887 | 2102357.1675 | 37.752704926800206 | -122.440862236718 | (37.7527049268002, -122.440862236718) | |||
| 154824 | 154824 | 124154 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 950 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996038.476969999 | 2112254.19163 | 37.779619458078706 | -122.457310322373 | (37.7796194580787, -122.457310322373) | |||
| 154033 | 154033 | 104979 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 423 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 2x3 | 6011155.37894 | 2112276.30906 | 37.7805368262604 | -122.405015718617 | (37.7805368262604, -122.405015718617) | |||
| 153946 | 153946 | 250819 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 60 Sea View Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5986191.04243 | 2114164.9353 | 37.7842953053345 | -122.49151705368999 | (37.7842953053345, -122.49151705369) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 150341 | 150341 | 72450 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3880 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 1 | 5996319.64273 | 2114949.8711200003 | 37.7870372213321 | -122.456532645474 | (37.7870372213321, -122.456532645474) | ||
| 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) | |||
| 148771 | 148771 | 214488 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1627 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991131.791019999 | 2104317.70681 | 37.757544974643295 | -122.473705376225 | (37.7575449746433, -122.473705376225) | |||
| 148645 | 148645 | 34700 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 546 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52703 | 5981644.97521 | 2112008.50675 | 37.7781076783894 | -122.507084551143 | (37.7781076783894, -122.507084551143) | |
| 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) | |||
| 147767 | 147767 | 119067 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5981914.59302 | 2111829.39054 | 37.7776317534825 | -122.506138577528 | (37.7776317534825, -122.506138577528) | |||
| 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) | |||
| 147133 | 147133 | 68292 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 1 | Permit Number 32101 | 5991174.54811 | 2115022.5246200003 | 37.7869399743547 | -122.47433864858101 | (37.7869399743547, -122.474338648581) | |
| 146930 | 146930 | 103497 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1850X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2014 12:00:00 AM | 1 | 3x3 | Permit Number 771036 | 5989824.39083 | 2110619.3957 | 37.7747718964667 | -122.47868769738001 | (37.7747718964667, -122.47868769738) | |
| 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) | |||
| 146145 | 146145 | 110514 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600x 15TH ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6006820.0 | 2107391.0 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | |||
| 140739 | 140739 | 110512 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600x 15TH ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6006820.0 | 2107391.0 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | |||
| 139728 | 139728 | 110506 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600x 15TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6006820.0 | 2107391.0 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) |
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");