Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34 | 34 | 240126 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006399.28254 | 2110261.0751 | 37.7747364652596 | -122.42132618837299 | (37.7747364652596, -122.421326188373) | |||
| 71 | 71 | 251206 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 270 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005145.0 | 2094297.0 | 37.7308320294825 | -122.424529217878 | (37.7308320294825, -122.424529217878) | ||||
| 131 | 131 | 237033 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 7 | : 4 | Tree 1 | DPW 2 | 6 | Width 4ft | 6005718.98472 | 2109769.85153 | 37.7733493059578 | -122.423644547079 | (37.7733493059578, -122.423644547079) | |||
| 135 | 135 | 237030 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 4 | : 4 | Tree 1 | DPW 2 | 5 | Width 4ft | 6005725.94025 | 2109733.85532 | 37.773250861665204 | -122.423617927146 | (37.7732508616652, -122.423617927146) | |||
| 299 | 299 | 196427 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 McLea Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010117.0 | 2109248.0 | 37.772163696411795 | -122.408394314545 | (37.7721636964118, -122.408394314545) | |||
| 383 | 383 | 181340 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1360 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5988678.0351 | 2106085.8063 | 37.7622572799997 | -122.48232089502501 | (37.7622572799997, -122.482320895025) | |||
| 1311 | 1311 | 237352 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3186 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 4x4 | 6008549.69387 | 2100618.49329 | 37.7483811527756 | -122.413205447889 | (37.7483811527756, -122.413205447889) | |||
| 1749 | 1749 | 251678 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1841 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989656.0 | 2102823.0 | 37.7533553254519 | -122.478699889248 | (37.7533553254519, -122.478699889248) | ||||
| 2028 | 2028 | 137540 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1510 Steiner St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002670.5536 | 2113409.7602 | 37.7831710382055 | -122.434449780345 | (37.7831710382055, -122.434449780345) | |||
| 2102 | 2102 | 196505 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3536 Jennings St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 6013064.418880001 | 2089502.0027700001 | 37.7181099951501 | -122.39681428375299 | (37.7181099951501, -122.396814283753) | |||
| 2141 | 2141 | 18982 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2920 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000616.67404 | 2115546.70514 | 37.7889217363036 | -122.44170876675699 | (37.7889217363036, -122.441708766757) | |||
| 2996 | 2996 | 178926 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 406 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 780238 | 6000939.854169999 | 2092384.3608900001 | 37.7253419851205 | -122.43893003518801 | (37.7253419851205, -122.438930035188) | ||
| 3396 | 3396 | 253424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | ||||
| 3800 | 3800 | 213446 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 530 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993033.55222 | 2099443.36305 | 37.744271238444206 | -122.46677405027799 | (37.7442712384442, -122.466774050278) | |||
| 3822 | 3822 | 253559 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4 Cortes Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5993184.39566 | 2099612.1282900004 | 37.7447433294416 | -122.46626473273199 | (37.7447433294416, -122.466264732732) | ||||
| 3874 | 3874 | 239439 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4x9 | 6004683.2193 | 2097236.31541 | 37.7388766398495 | -122.426334864463 | (37.7388766398495, -122.426334864463) | |||
| 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) | |||
| 4704 | 4704 | 253666 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 578 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5993791.71774 | 2111566.05198 | 37.7776007134003 | -122.465032776868 | (37.7776007134003, -122.465032776868) | ||||
| 6267 | 6267 | 17356 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2200 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005536.16539 | 2117610.65272 | 37.794867887291396 | -122.424834871756 | (37.7948678872914, -122.424834871756) | |||
| 7952 | 7952 | 17354 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2200 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005542.87933 | 2117567.08542 | 37.7947486417029 | -122.424808539584 | (37.7947486417029, -122.424808539584) | |||
| 8751 | 8751 | 17355 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2200 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005540.30706 | 2117584.3351 | 37.7947958596827 | -122.424818667772 | (37.7947958596827, -122.424818667772) | |||
| 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) | |||
| 11602 | 11602 | 27093 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 711 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6006091.0826900005 | 2093593.66537 | 37.7289542101608 | -122.421208528251 | (37.7289542101608, -122.421208528251) | |||
| 11634 | 11634 | 101011 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 83 Santa Ynez Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 6x10 | 6000610.71791 | 2092062.1351 | 37.724438494726 | -122.44004473049101 | (37.724438494726, -122.440044730491) | |||
| 11924 | 11924 | 27095 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 711 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6006067.91108 | 2093593.9714799998 | 37.7289537443201 | -122.421288656069 | (37.7289537443201, -122.421288656069) | |||
| 12282 | 12282 | 17504 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 132 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002139.261969999 | 2091310.46109 | 37.7224614665061 | -122.43470704369 | (37.7224614665061, -122.43470704369) | |||
| 12555 | 12555 | 27112 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004609.34849 | 2093526.9165 | 37.728687286881204 | -122.426326244487 | (37.7286872868812, -122.426326244487) | |||
| 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) | |||
| 12903 | 12903 | 28302 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3410 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6012014.9954 | 2089805.7813099998 | 37.7188856424495 | -122.40046303743799 | (37.7188856424495, -122.400463037438) | |||
| 13759 | 13759 | 109718 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 91x Jennings Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013027.725819999 | 2089252.6527099998 | 37.7174232872231 | -122.396923644015 | (37.7174232872231, -122.396923644015) | |||
| 13821 | 13821 | 105161 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600X Oakdale Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 13 | 3x3 | 6014869.34112 | 2095641.8363700002 | 37.735069048787 | -122.39100428831499 | (37.735069048787, -122.391004288315) | |||
| 13866 | 13866 | 10995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1544 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016004.21156 | 2097242.6965900003 | 37.7395275952262 | -122.387192226744 | (37.7395275952262, -122.387192226744) | |||
| 16684 | 16684 | 121586 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 855 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6012479.74347 | 2103984.1173799997 | 37.7578422788274 | -122.399851639655 | (37.7578422788274, -122.399851639655) | |||
| 17026 | 17026 | 16614 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 107 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | privately planted on dpw street without permit | 6002879.45304 | 2107636.12058 | 37.7673299123847 | -122.433314375152 | (37.7673299123847, -122.433314375152) | ||
| 17635 | 17635 | 4185 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3836 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004920.4543 | 2100493.66271 | 37.747833979169705 | -122.42574640029899 | (37.7478339791697, -122.425746400299) | |||
| 18004 | 18004 | 5790 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 573 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002988.46433 | 2108287.7672099997 | 37.769125358463995 | -122.43298388241301 | (37.769125358464, -122.432983882413) | |||
| 18032 | 18032 | 99798 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 723-725 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001735.0 | 2102034.0 | 37.7518828570558 | -122.43687178091899 | (37.7518828570558, -122.436871780919) | ||||
| 19906 | 19906 | 1353 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5999905.46078 | 2099295.02318 | 37.7442581344216 | -122.44300188482401 | (37.7442581344216, -122.443001884824) | |||
| 20033 | 20033 | 239534 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5 Bennington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6007215.03698 | 2097696.74866 | 37.7402836768401 | -122.417613619697 | (37.7402836768401, -122.417613619697) | ||||
| 20763 | 20763 | 36 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 773 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003693.31613 | 2107706.2481400003 | 37.7675686032223 | -122.430504342717 | (37.7675686032223, -122.430504342717) | |||
| 20923 | 20923 | 1370 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 41 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | 5999037.99816 | 2100015.3023099997 | 37.7461863501203 | -122.446053170314 | (37.7461863501203, -122.446053170314) | |||
| 21078 | 21078 | 1362 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 17 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 1X1 | 5999159.03773 | 2100010.23642 | 37.7461793516141 | -122.445634267927 | (37.7461793516141, -122.445634267927) | |||
| 21098 | 21098 | 10199 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2X2 | 6005752.31611 | 2101874.30524 | 37.7516718791661 | -122.42296797178801 | (37.7516718791661, -122.422967971788) | |||
| 21550 | 21550 | 27620 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1149 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010601.0802 | 2102491.1542599997 | 37.7536380210979 | -122.40624368710199 | (37.7536380210979, -122.406243687102) | |||
| 21590 | 21590 | 22829 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 88 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5999388.64339 | 2099036.75019 | 37.743519498737896 | -122.44477036118299 | (37.7435194987379, -122.444770361183) | |||
| 22246 | 22246 | 239535 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6007214.411780001 | 2097683.0452099997 | 37.7402460150284 | -122.417614810389 | (37.7402460150284, -122.417614810389) | ||||
| 22297 | 22297 | 237232 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 156 Rivoli St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997863.35341 | 2105946.59714 | 37.7624050647642 | -122.450542457376 | (37.7624050647642, -122.450542457376) | |||
| 23069 | 23069 | 4182 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3830 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6004950.59619 | 2100495.54046 | 37.747840838281796 | -122.42564230465 | (37.7478408382818, -122.42564230465) | |||
| 23387 | 23387 | 213501 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 787 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994873.7468 | 2093233.8423799998 | 37.7273274525845 | -122.459961359351 | (37.7273274525845, -122.459961359351) | |||
| 23502 | 23502 | 214703 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 520 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5992960.1777800005 | 2094882.5024400002 | 37.7317440249629 | -122.46669629760001 | (37.7317440249629, -122.4666962976) | |||
| 23557 | 23557 | 213451 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4 Cortes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5993177.52134 | 2099659.6696900004 | 37.7448734694269 | -122.466291957027 | (37.7448734694269, -122.466291957027) | |||
| 23561 | 23561 | 238503 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 68 Wilder St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002672.92744 | 2095557.23 | 37.7341524174814 | -122.433165572429 | (37.7341524174814, -122.433165572429) | |||
| 23585 | 23585 | 237396 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2797 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008140.86181 | 2106769.2911 | 37.7652468801621 | -122.415054485502 | (37.7652468801621, -122.415054485502) | |||
| 23601 | 23601 | 238482 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003589.43942 | 2108803.81702 | 37.7705763750292 | -122.430941979801 | (37.7705763750292, -122.430941979801) | |||
| 23638 | 23638 | 179012 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 Lisbon St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6001860.73543 | 2090148.2767900003 | 37.719254552441704 | -122.435586742551 | (37.7192545524417, -122.435586742551) | |||
| 23681 | 23681 | 237227 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 165 Grattan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5997877.39625 | 2106473.17188 | 37.763851709710394 | -122.450531852572 | (37.7638517097104, -122.450531852572) | |||
| 23779 | 23779 | 213682 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Baden St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6000730.9848 | 2095013.8875 | 37.7325501736469 | -122.43984052053801 | (37.7325501736469, -122.439840520538) | |||
| 23875 | 23875 | 123972 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 75 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993617.67519 | 2115041.45387 | 37.78713318686079 | -122.46588743043002 | (37.7871331868608, -122.46588743043) | |||
| 23887 | 23887 | 83255 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 790 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5983253.61867 | 2110435.38712 | 37.773882958787205 | -122.501403365431 | (37.7738829587872, -122.501403365431) | |||
| 23939 | 23939 | 179130 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Somerset St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009941.55337 | 2092988.7834299998 | 37.727509654348104 | -122.40785447092199 | (37.7275096543481, -122.407854470922) | |||
| 24054 | 24054 | 179073 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 201 Otsego Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6000546.4255099995 | 2092093.61368 | 37.724521267414296 | -122.440269236362 | (37.7245212674143, -122.440269236362) | |||
| 24090 | 24090 | 238060 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2x Montezuma St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6007260.48935 | 2099759.47356 | 37.7459500163869 | -122.417602623671 | (37.7459500163869, -122.417602623671) | |||
| 24140 | 24140 | 213364 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1256 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995501.45899 | 2106973.1472099996 | 37.765088237057206 | -122.45878564505101 | (37.7650882370572, -122.458785645051) | |||
| 24205 | 24205 | 135941 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 411 Laurel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998124.31484 | 2115011.10892 | 37.787308808511604 | -122.45029332808998 | (37.7873088085116, -122.45029332809) | |||
| 24236 | 24236 | 213361 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Elmhurst Dr | 6 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5991216.12738 | 2094471.85178 | 37.730515676960394 | -122.47269584493701 | (37.7305156769604, -122.472695844937) | |||
| 24357 | 24357 | 237261 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 451 Murray St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006427.64128 | 2096155.11961 | 37.7360063681022 | -122.42022673837799 | (37.7360063681022, -122.420226738378) | |||
| 24367 | 24367 | 238301 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 222 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001725.065719999 | 2104535.0570799997 | 37.7587495931307 | -122.43708518302799 | (37.7587495931307, -122.437085183028) | |||
| 24389 | 24389 | 237186 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 967 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6004411.68951 | 2103282.70615 | 37.75546327883529 | -122.42770437188 | (37.7554632788353, -122.42770437188) | |||
| 24441 | 24441 | 213456 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5993116.56669 | 2099668.45247 | 37.7448940675206 | -122.46650336333799 | (37.7448940675206, -122.466503363338) | |||
| 24443 | 24443 | 237069 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3390 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007234.90053 | 2100610.51952 | 37.7482853569883 | -122.417751419212 | (37.7482853569883, -122.417751419212) | |||
| 24459 | 24459 | 239377 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 439 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6000680.1305599995 | 2101434.3966200002 | 37.7501764801778 | -122.44047665777 | (37.7501764801778, -122.44047665777) | |||
| 24513 | 24513 | 213290 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 155 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5994132.71522 | 2090951.16156 | 37.721017116620004 | -122.46235759304399 | (37.72101711662, -122.462357593044) | |||
| 24527 | 24527 | 214750 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995612.00037 | 2093456.6914400002 | 37.7279817741139 | -122.457425350319 | (37.7279817741139, -122.457425350319) | |||
| 24539 | 24539 | 238429 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 56 Mars St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999556.96177 | 2105441.5581799997 | 37.7611151437823 | -122.444648611854 | (37.7611151437823, -122.444648611854) | |||
| 24549 | 24549 | 239423 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 113 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000623.604780001 | 2102403.64868 | 37.7528345937605 | -122.44074164393 | (37.7528345937605, -122.44074164393) | |||
| 24566 | 24566 | 239506 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 405 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008613.321269999 | 2096852.4753900003 | 37.738044069977605 | -122.412719223109 | (37.7380440699776, -122.412719223109) | |||
| 24568 | 24568 | 214543 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 642 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993736.09449 | 2106681.4613900003 | 37.7641857161125 | -122.46487037437001 | (37.7641857161125, -122.46487037437) | |||
| 24573 | 24573 | 238500 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 541 30th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6003116.9804 | 2098309.75539 | 37.741735400282 | -122.431826811079 | (37.741735400282, -122.431826811079) | |||
| 24591 | 24591 | 214612 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1333 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993302.748930001 | 2106373.33223 | 37.7633146795475 | -122.466346784179 | (37.7633146795475, -122.466346784179) | |||
| 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) | |||
| 24678 | 24678 | 21658 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1745 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004251.7833336 | 2114607.9002324 | 37.7865504610901 | -122.42906481766 | (37.7865504610901, -122.42906481766) | |||
| 24761 | 24761 | 239379 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1045 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001966.9971 | 2100951.6663900004 | 37.7489242092946 | -122.43599206429899 | (37.7489242092946, -122.435992064299) | |||
| 24786 | 24786 | 123887 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 235 12th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992115.40766 | 2113777.13838 | 37.783574950661794 | -122.47099276010701 | (37.7835749506618, -122.470992760107) | |||
| 24800 | 24800 | 135988 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 90 Myrtle St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6007056.03202 | 2114170.93433 | 37.7855089979725 | -122.419331776245 | (37.7855089979725, -122.419331776245) | |||
| 24809 | 24809 | 237307 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6008865.15222 | 2098033.0279200003 | 37.741299740778 | -122.41193191702601 | (37.741299740778, -122.411931917026) | |||
| 24891 | 24891 | 213671 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 3ft | 5994885.5088599995 | 2098943.91671 | 37.7430065910919 | -122.460334245238 | (37.7430065910919, -122.460334245238) | |||
| 24941 | 24941 | 214585 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1275 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991735.0327699995 | 2106752.18709 | 37.7642643321484 | -122.471796560669 | (37.7642643321484, -122.471796560669) | |||
| 24965 | 24965 | 213284 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 152 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994475.62527 | 2090947.51619 | 37.7210268472907 | -122.461171998816 | (37.7210268472907, -122.461171998816) | |||
| 24980 | 24980 | 213333 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 147 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991918.76578 | 2089524.2789200002 | 37.7169715101175 | -122.469906655166 | (37.7169715101175, -122.469906655166) | |||
| 25078 | 25078 | 238351 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 737 Sanchez St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6003693.255030001 | 2104105.37257 | 37.7576814602529 | -122.43024762673001 | (37.7576814602529, -122.43024762673) | |||
| 25218 | 25218 | 238350 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 369 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003912.3019199995 | 2103897.26854 | 37.7571224605398 | -122.429475232291 | (37.7571224605398, -122.429475232291) | |||
| 25219 | 25219 | 238508 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 442 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003891.58392 | 2096046.22548 | 37.7355641435676 | -122.428987145049 | (37.7355641435676, -122.428987145049) | |||
| 25256 | 25256 | 238433 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 272 Corbett Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 3ft | 5999629.6727599995 | 2105348.1757099996 | 37.7608628875441 | -122.444390425487 | (37.7608628875441, -122.444390425487) | |||
| 25262 | 25262 | 237451 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4407 24th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6000528.815780001 | 2101672.95433 | 37.7508228849759 | -122.441017024421 | (37.7508228849759, -122.441017024421) | |||
| 25325 | 25325 | 213664 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 Edgehill Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994722.94591 | 2098926.36641 | 37.7429490497558 | -122.460895067856 | (37.7429490497558, -122.460895067856) | |||
| 25464 | 25464 | 213655 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 16 Edgehill Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994743.32278 | 2099041.60515 | 37.7432666390437 | -122.460832960696 | (37.7432666390437, -122.460832960696) | |||
| 25478 | 25478 | 213643 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 27 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5999510.3328 | 2096092.78198 | 37.73544300577971 | -122.44413809190901 | (37.7354430057797, -122.444138091909) | |||
| 25479 | 25479 | 246475 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 318 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6004316.48172 | 2099879.2195200003 | 37.7461127118429 | -122.427791134863 | (37.7461127118429, -122.427791134863) | |||
| 25494 | 25494 | 237385 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3100 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008720.74445 | 2101541.69648 | 37.750925664000704 | -122.412679212271 | (37.7509256640007, -122.412679212271) |
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");