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) | |
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) |
| 31639 | 31639 | 213343 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 117 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992434.92339 | 2088648.0359 | 37.7145953816368 | -122.468058861341 | (37.7145953816368, -122.468058861341) | |||
| 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) | ||
| 32602 | 32602 | 213579 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 464 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994822.2189 | 2100134.8158400003 | 37.7462728613029 | -122.460639364526 | (37.7462728613029, -122.460639364526) | |||
| 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) | |
| 34110 | 34110 | 213580 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 45 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5995131.70851 | 2099996.48556 | 37.74591084191 | -122.459559177141 | (37.74591084191, -122.459559177141) | |||
| 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) | |||
| 34374 | 34374 | 213557 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Valdez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5996396.856430001 | 2093987.6566700002 | 37.7294847274146 | -122.454750441903 | (37.7294847274146, -122.454750441903) | |||
| 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) | |||
| 34790 | 34790 | 237110 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 380 Lexington St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 1ft | 6006531.04727 | 2103908.9188900003 | 37.7573023708184 | -122.420419415431 | (37.7573023708184, -122.420419415431) | |||
| 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) | |||
| 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) | |||
| 37063 | 37063 | 213321 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 325 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5991673.594880001 | 2090710.5616 | 37.7202145769251 | -122.470840448236 | (37.7202145769251, -122.470840448236) | |||
| 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) | |||
| 38356 | 38356 | 213463 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 314 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993094.88579 | 2099699.80528 | 37.7449789032567 | -122.46658060972 | (37.7449789032567, -122.46658060972) | |||
| 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) | |||
| 39076 | 39076 | 123168 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 598 10th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5992809.72377 | 2111438.2053099996 | 37.7771930089585 | -122.468420491782 | (37.7771930089585, -122.468420491782) | ||||
| 39376 | 39376 | 239418 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2106 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 6002637.419840001 | 2099337.55033 | 37.7445302890331 | -122.433558405315 | (37.7445302890331, -122.433558405315) | ||||
| 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) | |
| 40381 | 40381 | 250676 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 735 El Camino Del Mar | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5986293.297259999 | 2114811.88275 | 37.786077611448 | -122.49121092176 | (37.786077611448, -122.49121092176) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 43621 | 43621 | 239463 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Palo Alto Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5997639.21555 | 2103894.3138099997 | 37.7567571793145 | -122.451169653584 | (37.7567571793145, -122.451169653584) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 51050 | 51050 | 196476 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2074 Revere Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6012584.77785 | 2096296.25792 | 37.7367389189762 | -122.398948809344 | (37.7367389189762, -122.398948809344) | |||
| 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) | |||
| 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) | |||
| 53955 | 53955 | 213335 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 53 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5991917.8551 | 2088918.99095 | 37.715309483835 | -122.469865758501 | (37.715309483835, -122.469865758501) | |||
| 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) | |||
| 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) | |
| 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) | |
| 58550 | 58550 | 214789 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 385 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5995719.97757 | 2095492.23955 | 37.7335770986874 | -122.45719926076401 | (37.7335770986874, -122.457199260764) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 62005 | 62005 | 237097 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 494 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005558.8545 | 2107858.94862 | 37.7680933855167 | -122.424062541178 | (37.7680933855167, -122.424062541178) | |||
| 62513 | 62513 | 69303 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 813 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2014 12:00:00 AM | 6 | Permit Number 770956 | 5999968.796 | 2111801.6454 | 37.7786018352438 | -122.443681177953 | (37.7786018352438, -122.443681177953) | |
| 63980 | 63980 | 135933 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997039.44005 | 2116145.17864 | 37.790360514882394 | -122.45412868571002 | (37.7903605148824, -122.45412868571) | |||
| 65192 | 65192 | 214685 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 63 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993146.31618 | 2098681.89926 | 37.7421869588497 | -122.46632881033399 | (37.7421869588497, -122.466328810334) | |||
| 65482 | 65482 | 238310 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 36 Romain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000975.61601 | 2103724.3497599997 | 37.7564809597321 | -122.439618999541 | (37.7564809597321, -122.439618999541) | |||
| 65575 | 65575 | 214738 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 169 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995625.765869999 | 2093824.2443799998 | 37.7289917766278 | -122.457404343046 | (37.7289917766278, -122.457404343046) | |||
| 65597 | 65597 | 237331 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 64 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007739.785180001 | 2099985.61766 | 37.7465979158569 | -122.415961290786 | (37.7465979158569, -122.415961290786) | |||
| 66562 | 66562 | 239527 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 216 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009524.89815 | 2097270.5071099997 | 37.739243016440795 | -122.40959693254999 | (37.7392430164408, -122.40959693255) | |||
| 68081 | 68081 | 64861 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 52 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 6 | Permit Number 25877 | 5995901.579469999 | 2112392.78617 | 37.779992138301296 | -122.457793938484 | (37.7799921383013, -122.457793938484) | |
| 68741 | 68741 | 237427 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4376 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6001481.45066 | 2100595.89769 | 37.747919757402 | -122.43764560635401 | (37.747919757402, -122.437645606354) | |||
| 68810 | 68810 | 237278 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 478 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007846.81653 | 2096648.9824 | 37.737442271546996 | -122.415355016422 | (37.737442271547, -122.415355016422) | |||
| 70186 | 70186 | 238081 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 199 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008596.10001 | 2098083.7185 | 37.741423827457 | -122.41286579104401 | (37.741423827457, -122.412865791044) | |||
| 71219 | 71219 | 214483 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1868 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5990967.174319999 | 2102702.6319999998 | 37.7531008695265 | -122.47415683856899 | (37.7531008695265, -122.474156838569) | |||
| 72276 | 72276 | 218242 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 325 Wawona St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 5992065.00246 | 2097235.79822 | 37.738153881691 | -122.46996235468599 | (37.738153881691, -122.469962354686) | |||
| 72361 | 72361 | 238448 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 57 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002602.71951 | 2108615.35044 | 37.7700029340169 | -122.434341573611 | (37.7700029340169, -122.434341573611) |
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");