Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1495 | 1495 | 213442 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2455 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2002 12:00:00 AM | 6 | Width 3ft | Permit Number 45711 | 5992014.67382 | 2098752.22599 | 37.742314697659204 | -122.470246761681 | (37.7423146976592, -122.470246761681) | |
| 4328 | 4328 | 28085 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2255 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6002770.4091 | 2114749.1272 | 37.786854268374796 | -122.43420010239201 | (37.7868542683748, -122.434200102392) | |||
| 8875 | 8875 | 2624 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1822 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004615.6699 | 2115060.0567 | 37.7878125608959 | -122.427838089219 | (37.7878125608959, -122.427838089219) | |||
| 10340 | 10340 | 28256 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3476 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/2003 12:00:00 AM | 6 | 3x3 | 6012060.981000001 | 2089540.1901200002 | 37.7181589470551 | -122.400285438425 | (37.7181589470551, -122.400285438425) | ||
| 11313 | 11313 | 26979 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 538 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004789.78173 | 2093487.7597 | 37.728589968546 | -122.42569968949199 | (37.728589968546, -122.425699689492) | |||
| 11481 | 11481 | 28255 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3476 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2003 12:00:00 AM | 6 | 3x3 | 6012058.005419999 | 2089554.66958 | 37.7181985388057 | -122.400296740219 | (37.7181985388057, -122.400296740219) | ||
| 12793 | 12793 | 13368 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 900 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X50 | 6009218.46856 | 2090025.7710400003 | 37.719333336630896 | -122.410145089137 | (37.7193333366309, -122.410145089137) | |||
| 17409 | 17409 | 4836 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 123 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2000 12:00:00 AM | 6 | 3X3 | 6006379.67825 | 2097659.7420099997 | 37.7401350234134 | -122.420499335499 | (37.7401350234134, -122.420499335499) | ||
| 18266 | 18266 | 4090 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3215 Cesar Chavez St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/1995 12:00:00 AM | 6 | 3X3 | 6008246.07333 | 2100530.81306 | 37.748123352213504 | -122.41424916149201 | (37.7481233522135, -122.414249161492) | ||
| 18339 | 18339 | 3945 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 129 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2000 12:00:00 AM | 6 | 3X3 | 6002246.22679 | 2107489.51068 | 37.7668914137434 | -122.435494123149 | (37.7668914137434, -122.435494123149) | ||
| 18631 | 18631 | 10219 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1361 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2002 12:00:00 AM | 6 | 3X3 | 6005865.11973 | 2101072.64646 | 37.7494770729178 | -122.422520923317 | (37.7494770729178, -122.422520923317) | ||
| 18995 | 18995 | 19331 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/05/2000 12:00:00 AM | 6 | 3x3 | 5993203.76699 | 2089824.45321 | 37.7178699121392 | -122.465486857851 | (37.7178699121392, -122.465486857851) | ||
| 19214 | 19214 | 10228 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1411 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2002 12:00:00 AM | 6 | 3X3 | 6005886.64477 | 2100667.53648 | 37.7483659479448 | -122.422417708118 | (37.7483659479448, -122.422417708118) | ||
| 19308 | 19308 | 4173 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3807X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/1995 12:00:00 AM | 6 | 3X3 | 6005111.29038 | 2100461.84082 | 37.7477573856943 | -122.42508423394301 | (37.7477573856943, -122.425084233943) | ||
| 20721 | 20721 | 10215 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1335 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/24/2000 12:00:00 AM | 6 | 3X3 | 6005858.33864 | 2101181.45988 | 37.749775467064 | -122.42255210370199 | (37.749775467064, -122.422552103702) | ||
| 21265 | 21265 | 27509 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1335 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/24/2000 12:00:00 AM | 6 | 3X3 | 6005856.94451 | 2101204.3999 | 37.749838376446206 | -122.42255855456001 | (37.7498383764462, -122.42255855456) | ||
| 21301 | 21301 | 3944 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 129 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/1999 12:00:00 AM | 6 | 3X3 | 6002248.02502 | 2107476.74068 | 37.7668564525859 | -122.435486989749 | (37.7668564525859, -122.435486989749) | ||
| 21380 | 21380 | 4200 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3890 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1995 12:00:00 AM | 6 | 3X3 | 6004657.19405 | 2100480.3462900002 | 37.7477825352565 | -122.42665579384399 | (37.7477825352565, -122.426655793844) | ||
| 22029 | 22029 | 25409 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3763-3767 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 6 | 3x3 | 6005453.81691 | 2100480.39517 | 37.7478276749239 | -122.42390111285 | (37.7478276749239, -122.42390111285) | ||
| 23606 | 23606 | 31666 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4066 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 6 | Permit Number 35467 | 6002585.751619999 | 2104753.963 | 37.7593995412727 | -122.434124187708 | (37.7593995412727, -122.434124187708) | |
| 24659 | 24659 | 239434 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 641 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002846.37462 | 2095677.3876200002 | 37.734492180455 | -122.43257449123699 | (37.734492180455, -122.432574491237) | |||
| 26912 | 26912 | 237377 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 979 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009171.618530001 | 2103483.06464 | 37.7562815207028 | -122.411257166497 | (37.7562815207028, -122.411257166497) | |||
| 27195 | 27195 | 135991 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1040 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008482.86494 | 2115597.67171 | 37.789506729108204 | -122.414496332055 | (37.7895067291082, -122.414496332055) | |||
| 27694 | 27694 | 238465 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 71 Potomac St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003081.83351 | 2108772.32809 | 37.7704611394919 | -122.43269554267599 | (37.7704611394919, -122.432695542676) | |||
| 27986 | 27986 | 237283 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 614 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007963.94281 | 2096020.98872 | 37.7357245205556 | -122.414905620711 | (37.7357245205556, -122.414905620711) | |||
| 29842 | 29842 | 238504 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 68 Wilder St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002684.617740001 | 2095553.88907 | 37.7341439071982 | -122.433124916788 | (37.7341439071982, -122.433124916788) | |||
| 30210 | 30210 | 237187 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 904 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004333.66814 | 2103620.22544 | 37.7563856136086 | -122.427998244239 | (37.7563856136086, -122.427998244239) | |||
| 30633 | 30633 | 95739 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 612 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767485 | 6003904.92985 | 2091757.6805900002 | 37.7237895151604 | -122.428635396826 | (37.7237895151604, -122.428635396826) |
| 31003 | 31003 | 124618 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 700 Euclid Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996155.438130001 | 2113845.79893 | 37.78399630583271 | -122.45702086273 | (37.7839963058327, -122.45702086273) | |||
| 31403 | 31403 | 238374 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 587 Liberty St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002502.863419999 | 2103825.71172 | 37.7568460818083 | -122.434344490133 | (37.7568460818083, -122.434344490133) | |||
| 31646 | 31646 | 237358 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1400 Treat Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008695.940169999 | 2100749.23036 | 37.7487483369695 | -122.41270897086399 | (37.7487483369695, -122.412708970864) | |||
| 31936 | 31936 | 48575 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2275 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2002 12:00:00 AM | 6 | Permit Number 45888 | 5999350.9725 | 2120803.18902 | 37.80328244439271 | -122.446466222664 | (37.8032824443927, -122.446466222664) | ||
| 32170 | 32170 | 111793 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 55X Sherman St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3x3 | 6010868.84129 | 2110834.34163 | 37.7765614981606 | -122.405905386452 | (37.7765614981606, -122.405905386452) | |||
| 32843 | 32843 | 31989 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 147 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 6 | Permit Number 35389 | 5994568.75053 | 2114560.8648099997 | 37.78586843793 | -122.462562068449 | (37.78586843793, -122.462562068449) | |
| 33510 | 33510 | 40676 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 191 Maynard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2005 12:00:00 AM | 6 | Permit Number 47920 | 6004632.23626 | 2093798.9275599997 | 37.7294354625595 | -122.426266478225 | (37.7294354625595, -122.426266478225) | |
| 34178 | 34178 | 213551 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 159 Valdez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996188.75737 | 2094532.8518700001 | 37.73096976354329 | -122.455509245751 | (37.7309697635433, -122.455509245751) | |||
| 34490 | 34490 | 68541 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 501 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 6 | Permit Number 32425 | 5982517.9924800005 | 2112299.68917 | 37.778958557712606 | -122.504086094205 | (37.7789585577126, -122.504086094205) | |
| 34515 | 34515 | 237052 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1359 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010359.96313 | 2101381.9177099997 | 37.7505788125805 | -122.40699934965099 | (37.7505788125805, -122.406999349651) | |||
| 35079 | 35079 | 213616 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 282 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995109.982340001 | 2095633.16995 | 37.733929007011206 | -122.459318378264 | (37.7339290070112, -122.459318378264) | |||
| 35288 | 35288 | 238420 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 242 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999803.1371 | 2105544.26543 | 37.7614111970029 | -122.443804579221 | (37.7614111970029, -122.443804579221) | |||
| 35668 | 35668 | 213507 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 170 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995650.65208 | 2093847.52813 | 37.729057137577 | -122.457319993841 | (37.729057137577, -122.457319993841) | |||
| 36221 | 36221 | 239472 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 192 Upper Ter | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5999641.79555 | 2106531.14704 | 37.764111724386204 | -122.44443351741998 | (37.7641117243862, -122.44443351742) | |||
| 37224 | 37224 | 238146 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 816 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001874.44025 | 2101652.14409 | 37.750842295952104 | -122.436362251334 | (37.7508422959521, -122.436362251334) | |||
| 38505 | 38505 | 237174 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1530 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008721.73548 | 2099825.28397 | 37.746212833362605 | -122.412554466435 | (37.7462128333626, -122.412554466435) | |||
| 38891 | 38891 | 238204 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3753 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003355.958330001 | 2103579.02376 | 37.7562171211382 | -122.43137656370399 | (37.7562171211382, -122.431376563704) | |||
| 39061 | 39061 | 238237 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3851 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003263.10271 | 2105914.5471 | 37.7626246459451 | -122.43186444678899 | (37.7626246459451, -122.431864446789) | |||
| 39066 | 39066 | 124480 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 276 Willard St North | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5996245.79674 | 2110923.35846 | 37.7759772459796 | -122.456496854767 | (37.7759772459796, -122.456496854767) | |||
| 40172 | 40172 | 213418 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1500 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991335.33208 | 2098431.48094 | 37.741394714585496 | -122.47257231588301 | (37.7413947145855, -122.472572315883) | |||
| 40185 | 40185 | 62775 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | 6 | Permit Number 23130 | 6000616.95925 | 2093064.6604900002 | 37.727191555121706 | -122.440095009781 | (37.7271915551217, -122.440095009781) | |
| 40751 | 40751 | 68941 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 730 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 6 | Permit Number 32928 | 5989462.36102 | 2110347.5276900004 | 37.774004395159295 | -122.479920119491 | (37.7740043951593, -122.479920119491) | |
| 41185 | 41185 | 238302 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 224 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001725.92578 | 2104522.1250400003 | 37.758714133770496 | -122.437081282675 | (37.7587141337705, -122.437081282675) | |||
| 41337 | 41337 | 238326 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 358 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001462.98209 | 2103653.8418 | 37.7563150887866 | -122.437928468325 | (37.7563150887866, -122.437928468325) | |||
| 42511 | 42511 | 214723 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 Miramar Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995322.28894 | 2093286.2773099998 | 37.7274972131074 | -122.45841455420299 | (37.7274972131074, -122.458414554203) | |||
| 42810 | 42810 | 237421 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4347 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001594.69603 | 2100278.73808 | 37.74705535061779 | -122.43723130398199 | (37.7470553506178, -122.437231303982) | |||
| 42915 | 42915 | 214589 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Lurline St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991796.94128 | 2105115.28006 | 37.7597734011291 | -122.47146315499701 | (37.7597734011291, -122.471463154997) | |||
| 43022 | 43022 | 238228 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3831 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004247.41053 | 2101874.23621 | 37.751586656701 | -122.428172127243 | (37.751586656701, -122.428172127243) | |||
| 43622 | 43622 | 239460 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 134 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002209.73333 | 2096210.1693 | 37.7359189522033 | -122.43481365563801 | (37.7359189522033, -122.434813655638) | |||
| 44371 | 44371 | 213690 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 531 Gennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5997444.64303 | 2095159.4948599997 | 37.732762361473604 | -122.451212635762 | (37.7327623614736, -122.451212635762) | |||
| 44592 | 44592 | 237271 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 530 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007683.52656 | 2096864.1843700001 | 37.7380239899033 | -122.41593482283399 | (37.7380239899033, -122.415934822834) | |||
| 48217 | 48217 | 32078 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3847 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 6 | Permit Number 35451 | 6003283.17124 | 2105912.34445 | 37.7626197356314 | -122.431794879733 | (37.7626197356314, -122.431794879733) | |
| 48235 | 48235 | 179065 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 252 Otsego Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000349.56267 | 2091773.3269599997 | 37.7236306229466 | -122.440926797246 | (37.7236306229466, -122.440926797246) | |||
| 48259 | 48259 | 237401 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3511 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006078.7375300005 | 2102562.31872 | 37.7535794194659 | -122.421888029913 | (37.7535794194659, -122.421888029913) | |||
| 48583 | 48583 | 239537 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007207.949109999 | 2097619.73987 | 37.7400718289571 | -122.41763267000799 | (37.7400718289571, -122.417632670008) | |||
| 49079 | 49079 | 238346 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 213 Collingwood St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002078.3851 | 2104627.3949 | 37.759023207373296 | -122.43586985090599 | (37.7590232073733, -122.435869850906) | |||
| 49933 | 49933 | 78363 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 6 | 6001858.247830001 | 2090145.2543799998 | 37.719246112288104 | -122.43559512512199 | (37.7192461122881, -122.435595125122) | ||
| 49995 | 49995 | 135934 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Spruce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997041.86737 | 2116129.80097 | 37.790318431109704 | -122.454119176269 | (37.7903184311097, -122.454119176269) | |||
| 50362 | 50362 | 237418 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 786 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001460.61655 | 2100008.82783 | 37.746306618271205 | -122.437675611364 | (37.7463066182712, -122.437675611364) | |||
| 50364 | 50364 | 74315 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 6 | 6000588.288430001 | 2093013.22945 | 37.727048705022895 | -122.440190437741 | (37.7270487050229, -122.440190437741) | ||
| 50623 | 50623 | 239509 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 444 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008753.78485 | 2096712.524 | 37.737667676711794 | -122.412223680483 | (37.7376676767118, -122.412223680483) | |||
| 50959 | 50959 | 196483 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 65 Colin P Kelly Jr St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6015356.8087 | 2112701.6743900003 | 37.7819387497011 | -122.39051059018699 | (37.7819387497011, -122.390510590187) | |||
| 51473 | 51473 | 237339 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 328 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006792.98874 | 2097141.4032700001 | 37.738735064080295 | -122.41903351700199 | (37.7387350640803, -122.419033517002) | |||
| 51659 | 51659 | 178979 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 190 Rae Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5997616.63139 | 2087136.8467599999 | 37.7107438892848 | -122.450040007061 | (37.7107438892848, -122.450040007061) | |||
| 51756 | 51756 | 179117 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 212 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004824.04554 | 2093769.3744299999 | 37.7293651562744 | -122.4256012722 | (37.7293651562744, -122.4256012722) | |||
| 52380 | 52380 | 119254 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008843.9612300005 | 2117672.51917 | 37.7952240323069 | -122.41339376771799 | (37.7952240323069, -122.413393767718) | |||
| 52624 | 52624 | 86960 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 208 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2007 12:00:00 AM | 6 | 3x3 | Permit Number 49928 | 5993493.7535 | 2087361.9529 | 37.71112519553311 | -122.464305827668 | (37.7111251955331, -122.464305827668) | |
| 53349 | 53349 | 238145 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 820 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001874.13959 | 2101637.6151400004 | 37.7508023858328 | -122.436362251332 | (37.7508023858328, -122.436362251332) | |||
| 53430 | 53430 | 238419 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 242 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999814.22869 | 2105549.6420400003 | 37.761426592486 | -122.443766604438 | (37.761426592486, -122.443766604438) | |||
| 53559 | 53559 | 237338 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 123 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007275.446930001 | 2097014.4227200001 | 37.7384135600251 | -122.41735640368 | (37.7384135600251, -122.41735640368) | |||
| 53858 | 53858 | 214650 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 28 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5996115.71323 | 2106752.8498400003 | 37.7645186442469 | -122.45664517043899 | (37.7645186442469, -122.456645170439) | |||
| 55895 | 55895 | 40019 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 12 Latona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 6 | Permit Number 41264 | 6014412.91208 | 2094585.9323200001 | 37.732144413937796 | -122.392508504263 | (37.7321444139378, -122.392508504263) | |
| 56277 | 56277 | 213696 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 123 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999234.8811 | 2093770.79632 | 37.729051660688796 | -122.444923564269 | (37.7290516606888, -122.444923564269) | |||
| 56405 | 56405 | 213539 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1560 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995783.29259 | 2094350.88739 | 37.7304468581388 | -122.45689784037701 | (37.7304468581388, -122.456897840377) | |||
| 56599 | 56599 | 43215 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 365 Sweeny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 6 | Permit Number 43005 | 6008686.27116 | 2094503.726 | 37.731599006589704 | -122.41230103567499 | (37.7315990065897, -122.412301035675) | |
| 56604 | 56604 | 33140 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3143 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 6 | Permit Number 37367 | 6001896.074 | 2118984.29093 | 37.798433267540105 | -122.437528496644 | (37.7984332675401, -122.437528496644) | |
| 56945 | 56945 | 84414 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 738 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51575 | 5994138.61763 | 2110515.8988900003 | 37.7747372701378 | -122.46375650168999 | (37.7747372701378, -122.46375650169) | |
| 57166 | 57166 | 135968 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2831 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002535.74001 | 2117875.30124 | 37.795424617112296 | -122.435235693088 | (37.7954246171123, -122.435235693088) | |||
| 57325 | 57325 | 237412 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 609 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001916.519180001 | 2099409.00866 | 37.7446855677848 | -122.436056242601 | (37.7446855677848, -122.436056242601) | |||
| 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) | |||
| 57602 | 57602 | 213592 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2038 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993203.16917 | 2101587.87617 | 37.750169312562704 | -122.466343382053 | (37.7501693125627, -122.466343382053) | |||
| 57991 | 57991 | 37799 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 425 Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2002 12:00:00 AM | 6 | Permit Number 40126 | 6010088.32636 | 2092511.7068599998 | 37.7262079180568 | -122.407313455853 | (37.7262079180568, -122.407313455853) | |
| 58413 | 58413 | 40675 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 191 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2005 12:00:00 AM | 6 | Permit Number 47920 | 6004642.33575 | 2093798.50545 | 37.7294348744024 | -122.42623153326099 | (37.7294348744024, -122.426231533261) | |
| 58743 | 58743 | 109720 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 91x Jennings Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013003.046630001 | 2089225.87008 | 37.7173483736975 | -122.39700707233999 | (37.7173483736975, -122.39700707234) | |||
| 59095 | 59095 | 214834 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1223 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995042.942000001 | 2092029.67306 | 37.7240308230599 | -122.459289291479 | (37.7240308230599, -122.459289291479) | |||
| 59329 | 59329 | 238311 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 38 Romain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000933.03179 | 2103722.09476 | 37.7564723442357 | -122.43976610883301 | (37.7564723442357, -122.439766108833) | |||
| 59674 | 59674 | 33813 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 261 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | 6 | Permit Number 37827 | 6006152.11101 | 2110895.2275099996 | 37.776463756237504 | -122.42222627034401 | (37.7764637562375, -122.422226270344) | ||
| 59864 | 59864 | 239539 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007197.88288 | 2097498.21378 | 37.739737578835204 | -122.417658863675 | (37.7397375788352, -122.417658863675) | |||
| 61183 | 61183 | 213585 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 30 Montecito Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996654.35387 | 2094558.3489299999 | 37.731066478420296 | -122.453901450408 | (37.7310664784203, -122.453901450408) | |||
| 61198 | 61198 | 237276 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 798 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007581.948890001 | 2095782.1901200002 | 37.7350473598298 | -122.416209418232 | (37.7350473598298, -122.416209418232) | |||
| 61541 | 61541 | 239478 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 251 Alma St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997548.994659999 | 2106126.07284 | 37.7628798618316 | -122.451642649306 | (37.7628798618316, -122.451642649306) | |||
| 61632 | 61632 | 39922 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2335 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 6 | Permit Number 41196 | 6003527.33622 | 2116558.3105 | 37.791864757797896 | -122.431710530526 | (37.7918647577979, -122.431710530526) |
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");