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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189115 | 189115 | 53052 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2517@ SCOTT Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | 5 | Permit Number 49029 | 6001372.258169999 | 2117256.0832 | 37.7936582667653 | -122.439217122188 | (37.7936582667653, -122.439217122188) | |
| 188794 | 188794 | 239516 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 248 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008976.50075 | 2097193.92135 | 37.739001983760296 | -122.411487642954 | (37.7390019837603, -122.411487642954) | |||
| 187534 | 187534 | 213472 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 390 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993869.43858 | 2099604.78571 | 37.744762670277204 | -122.463895471497 | (37.7447626702772, -122.463895471497) | |||
| 187309 | 187309 | 214781 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1723 Monterey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5992834.3473 | 2095346.2214400002 | 37.733010019498 | -122.467165018866 | (37.733010019498, -122.467165018866) | |||
| 186758 | 186758 | 238479 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 82 Germania St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003859.40004 | 2108866.56108 | 37.770763947529296 | -122.43001265998001 | (37.7707639475293, -122.43001265998) | |||
| 186561 | 186561 | 179064 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 252 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000355.465580001 | 2091781.1110900003 | 37.7236523325845 | -122.440906950114 | (37.7236523325845, -122.440906950114) | |||
| 186491 | 186491 | 237290 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008290.53524 | 2097979.90466 | 37.7411216210694 | -122.41391498957898 | (37.7411216210694, -122.413914989579) | |||
| 186426 | 186426 | 214765 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5993613.7342 | 2101408.96874 | 37.7497017595309 | -122.464910643325 | (37.7497017595309, -122.464910643325) | |||
| 186077 | 186077 | 238329 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 236 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002043.38339 | 2104453.45148 | 37.7585436124229 | -122.43597845665701 | (37.7585436124229, -122.435978456657) | |||
| 185776 | 185776 | 50300 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2917 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 5 | Permit Number 47010 | 5989048.80024 | 2095796.1569299998 | 37.7340261814504 | -122.480285417057 | (37.7340261814504, -122.480285417057) | |
| 185740 | 185740 | 237188 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 904 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004338.3422300005 | 2103543.5695 | 37.756175398901206 | -122.42797661735001 | (37.7561753989012, -122.42797661735) | |||
| 184534 | 184534 | 238151 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 709 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001753.79971 | 2102029.27743 | 37.751870958478605 | -122.436806430966 | (37.7518709584786, -122.436806430966) | |||
| 184031 | 184031 | 238455 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 82 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002623.005 | 2108745.80631 | 37.770362285127796 | -122.434280734471 | (37.7703622851278, -122.434280734471) | |||
| 183819 | 183819 | 213307 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 247 Louisburg St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997575.966440001 | 2090467.37945 | 37.7198864367809 | -122.45042049131901 | (37.7198864367809, -122.450420491319) | |||
| 183451 | 183451 | 179086 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 146 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003896.054690001 | 2092965.8387900002 | 37.7271063470709 | -122.42875216298201 | (37.7271063470709, -122.428752162982) | |||
| 182777 | 182777 | 49699 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 87@ TUCKER Alpha St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50825 | 6011128.67682 | 2088300.86402 | 37.7147039774881 | -122.403420891467 | (37.7147039774881, -122.403420891467) | |
| 182553 | 182553 | 88408 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769129 | 6009412.43491 | 2117319.72378 | 37.794287243625604 | -122.411401815264 | (37.7942872436256, -122.411401815264) | |
| 182366 | 182366 | 238347 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 213 Collingwood St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002077.006 | 2104645.27422 | 37.7590722213217 | -122.435875899764 | (37.7590722213217, -122.435875899764) | |||
| 182241 | 182241 | 237133 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1298 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010041.99943 | 2101706.7565099997 | 37.751452949993 | -122.40812180518299 | (37.751452949993, -122.408121805183) | |||
| 181265 | 181265 | 214649 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 16 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996114.56342 | 2106803.43322 | 37.7646574671859 | -122.45665280570299 | (37.7646574671859, -122.456652805703) | |||
| 180996 | 180996 | 196474 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 74 Neptune St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013054.126569999 | 2093955.76147 | 37.7303385419805 | -122.39716198774599 | (37.7303385419805, -122.397161987746) | |||
| 180916 | 180916 | 213313 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 109 Caine Ave | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997305.300980001 | 2089185.13122 | 37.7163501865023 | -122.45126365610099 | (37.7163501865023, -122.451263656101) | |||
| 180157 | 180157 | 214624 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1437 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992704.14512 | 2105656.98806 | 37.7613132293559 | -122.468365022027 | (37.7613132293559, -122.468365022027) | |||
| 179967 | 179967 | 237291 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 90 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008308.41294 | 2098185.7462400002 | 37.7416878207358 | -122.413867732013 | (37.7416878207358, -122.413867732013) | |||
| 179930 | 179930 | 238383 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 220 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004823.69058 | 2103996.37139 | 37.7574461328395 | -122.42633035437599 | (37.7574461328395, -122.426330354376) | |||
| 179560 | 179560 | 237397 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1349 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005861.9823900005 | 2101116.6759099998 | 37.74959779070179 | -122.42253490058901 | (37.7495977907018, -122.422534900589) | |||
| 179414 | 179414 | 237134 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1298 York St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010042.928119999 | 2101694.54007 | 37.7514194583536 | -122.408117732167 | (37.7514194583536, -122.408117732167) | |||
| 179297 | 179297 | 238296 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4321 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001563.81631 | 2105231.07387 | 37.7606515189756 | -122.43769270386801 | (37.7606515189756, -122.437692703868) | |||
| 179283 | 179283 | 238324 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 118 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999937.73353 | 2105034.20415 | 37.7600183710625 | -122.44330243107201 | (37.7600183710625, -122.443302431072) | |||
| 179271 | 179271 | 238279 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 173 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002064.94714 | 2104866.1537900004 | 37.7596780181477 | -122.435933409625 | (37.7596780181477, -122.435933409625) | |||
| 179149 | 179149 | 213629 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Arroyo Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998678.2778900005 | 2097325.31412 | 37.738779742379606 | -122.447103478636 | (37.7387797423796, -122.447103478636) | |||
| 179105 | 179105 | 135935 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Spruce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997049.33252 | 2116083.6644599997 | 37.7901921806791 | -122.45409001393999 | (37.7901921806791, -122.45409001394) | |||
| 178931 | 178931 | 214538 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 623 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993805.0623699995 | 2106624.13828 | 37.7640322980823 | -122.464627673449 | (37.7640322980823, -122.464627673449) | |||
| 177820 | 177820 | 238088 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 568 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009823.35245 | 2098839.38675 | 37.74356753871471 | -122.40867565536199 | (37.7435675387147, -122.408675655362) | |||
| 176395 | 176395 | 238253 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3878 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003842.31465 | 2104818.9548 | 37.759649229048705 | -122.42978301358102 | (37.7596492290487, -122.429783013581) | |||
| 176349 | 176349 | 213605 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 153 Vasquez Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994959.23188 | 2099490.14718 | 37.7445106442654 | -122.460118897178 | (37.7445106442654, -122.460118897178) | |||
| 175579 | 175579 | 64857 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 21 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 5 | Permit Number 25873 | 5995838.9792599995 | 2112526.25675 | 37.780355016559504 | -122.458020161226 | (37.7803550165595, -122.458020161226) | |
| 175566 | 175566 | 214587 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Lurline St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991795.61852 | 2105144.1496 | 37.7598525927434 | -122.47146983337299 | (37.7598525927434, -122.471469833373) | |||
| 175530 | 175530 | 238391 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 74 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001679.28236 | 2105439.1103 | 37.761229300998394 | -122.43730825629 | (37.7612293009984, -122.43730825629) | |||
| 174660 | 174660 | 178999 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450 France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002140.71576 | 2089748.47374 | 37.7181726806159 | -122.434590385445 | (37.7181726806159, -122.434590385445) | |||
| 173717 | 173717 | 246594 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 22 Waller St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6005538.63737 | 2109282.04946 | 37.771999737437206 | -122.424233694733 | (37.7719997374372, -122.424233694733) | |||
| 173230 | 173230 | 237356 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1460 Treat Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008696.4782300005 | 2100696.55595 | 37.74860373498271 | -122.41270338695801 | (37.7486037349827, -122.412703386958) | |||
| 172419 | 172419 | 179017 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 27 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000125.72789 | 2088561.8694099998 | 37.714799938735 | -122.441470215282 | (37.714799938735, -122.441470215282) | |||
| 171710 | 171710 | 237031 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6005723.44032 | 2109745.94906 | 37.773283927046 | -122.423627434762 | (37.773283927046, -122.423627434762) | |||
| 171626 | 171626 | 239390 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4174 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002081.20473 | 2101801.16763 | 37.7512632254272 | -122.435657902305 | (37.7512632254272, -122.435657902305) | |||
| 171204 | 171204 | 109721 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 91x Jennings Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6012983.30026 | 2089217.1759900001 | 37.717323402237 | -122.39707471754299 | (37.717323402237, -122.397074717543) | |||
| 171156 | 171156 | 214576 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1433 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991271.06324 | 2106533.25971 | 37.7636363598559 | -122.473385314688 | (37.7636363598559, -122.473385314688) | |||
| 169697 | 169697 | 213577 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994569.9735900005 | 2099964.1686400003 | 37.745789791378 | -122.46149922251001 | (37.745789791378, -122.46149922251) | |||
| 169580 | 169580 | 84326 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 728 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53994 | 5987888.08845 | 2110995.2066599997 | 37.7756911522049 | -122.48541326443899 | (37.7756911522049, -122.485413264439) |
| 169557 | 169557 | 179140 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 Woolsey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6011506.1503099995 | 2092130.7968400002 | 37.725241269158104 | -122.402385315842 | (37.7252412691581, -122.402385315842) | |||
| 169433 | 169433 | 238452 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 74 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002631.46535 | 2108682.38304 | 37.7701886206411 | -122.434246935272 | (37.7701886206411, -122.434246935272) | |||
| 169330 | 169330 | 237384 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 145 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006711.76494 | 2102924.2782900003 | 37.7546089570481 | -122.419724558745 | (37.7546089570481, -122.419724558745) | |||
| 168464 | 168464 | 213487 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 270 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5994647.931480001 | 2100314.84296 | 37.746757141726704 | -122.461255072761 | (37.7467571417267, -122.461255072761) | |||
| 168285 | 168285 | 237337 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 124 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007298.22515 | 2096977.17548 | 37.7383125688774 | -122.417275008733 | (37.7383125688774, -122.417275008733) | |||
| 168224 | 168224 | 237032 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6005721.49565 | 2109758.3052 | 37.7733177442556 | -122.423635040324 | (37.7733177442556, -122.423635040324) | |||
| 167930 | 167930 | 178995 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Wanda St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000596.67394 | 2091620.93611 | 37.7232262634584 | -122.440061656639 | (37.7232262634584, -122.440061656639) | |||
| 167730 | 167730 | 238496 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1716 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003948.65821 | 2098247.39872 | 37.7416112938229 | -122.428946700751 | (37.7416112938229, -122.428946700751) | |||
| 167616 | 167616 | 237292 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 76 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008313.98113 | 2098256.25118 | 37.7418817244694 | -122.41385346517401 | (37.7418817244694, -122.413853465174) | |||
| 167531 | 167531 | 238451 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 66 Carmelita St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002635.187000001 | 2108649.70915 | 37.770099117414 | -122.434231725909 | (37.770099117414, -122.434231725909) | |||
| 167032 | 167032 | 179163 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 171 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002120.7512 | 2086617.7341900002 | 37.7095752265844 | -122.43443567596 | (37.7095752265844, -122.43443567596) | |||
| 166970 | 166970 | 214482 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1501 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5990834.97468 | 2105131.29032 | 37.7597616641021 | -122.47479125810499 | (37.7597616641021, -122.474791258105) | |||
| 166433 | 166433 | 250875 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 30th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986467.14332 | 2114671.0752 | 37.7857011507179 | -122.490599105783 | (37.7857011507179, -122.490599105783) | |||
| 165821 | 165821 | 214707 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992641.20106 | 2094871.0597299999 | 37.731694192613 | -122.46779822343099 | (37.731694192613, -122.467798223431) | |||
| 165066 | 165066 | 239536 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 7 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007212.48694 | 2097673.14055 | 37.7402187107189 | -122.41762076389999 | (37.7402187107189, -122.4176207639) | |||
| 165023 | 165023 | 213509 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 160 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995676.0127 | 2093766.8995400001 | 37.7288372074655 | -122.45722649041402 | (37.7288372074655, -122.457226490414) | |||
| 164925 | 164925 | 179022 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 947 Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008892.678069999 | 2090361.86972 | 37.7202379269127 | -122.411294959597 | (37.7202379269127, -122.411294959597) | |||
| 164302 | 164302 | 238187 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 362 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002777.947790001 | 2101545.63473 | 37.75060114273239 | -122.43323023281201 | (37.7506011427324, -122.433230232812) | |||
| 163704 | 163704 | 214753 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 107 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995611.1547 | 2093431.54917 | 37.7279126909161 | -122.457426455583 | (37.7279126909161, -122.457426455583) | |||
| 163282 | 163282 | 31057 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 5 | Permit Number 34809 | 6002747.277969999 | 2087115.5773200002 | 37.7109777400017 | -122.43230582505 | (37.7109777400017, -122.43230582505) | |
| 163211 | 163211 | 213634 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 524 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996908.09884 | 2093848.57813 | 37.7291321626185 | -122.452973001098 | (37.7291321626185, -122.452973001098) | |||
| 163181 | 163181 | 213465 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 160 Madrone Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992622.33383 | 2098106.49157 | 37.7405767874889 | -122.468098715706 | (37.7405767874889, -122.468098715706) | |||
| 162920 | 162920 | 238290 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4053 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002616.6046400005 | 2105290.1674900004 | 37.76087358047779 | -122.434055813139 | (37.7608735804778, -122.434055813139) | |||
| 162779 | 162779 | 239491 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 327 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007745.79507 | 2097582.41042 | 37.739999581016605 | -122.415770371009 | (37.7399995810166, -122.415770371009) | |||
| 162769 | 162769 | 37773 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 611 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 5 | Permit Number 40111 | 6009477.59682 | 2092948.39833 | 37.7273727802074 | -122.409455529449 | (37.7273727802074, -122.409455529449) | |
| 162338 | 162338 | 237318 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 161 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6009544.13683 | 2097633.21679 | 37.7402400165656 | -122.409556006214 | (37.7402400165656, -122.409556006214) | |||
| 162049 | 162049 | 179042 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2913 20th Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 5990217.2226599995 | 2095888.7019900002 | 37.7343481135815 | -122.476252619576 | (37.7343481135815, -122.476252619576) | |||
| 161228 | 161228 | 239446 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 441 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003599.81786 | 2096406.6496 | 37.7365372666692 | -122.430021593837 | (37.7365372666692, -122.430021593837) | |||
| 160740 | 160740 | 179143 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 27 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011356.63077 | 2092564.1639599998 | 37.7264228578115 | -122.402932659438 | (37.7264228578115, -122.402932659438) | |||
| 160493 | 160493 | 238186 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 342 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002879.26131 | 2101551.5295599997 | 37.7506230753963 | -122.43288030389999 | (37.7506230753963, -122.4328803039) | |||
| 160447 | 160447 | 179121 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 63 Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009618.07024 | 2094045.5323700001 | 37.730393147926996 | -122.409047291208 | (37.730393147927, -122.409047291208) | |||
| 159788 | 159788 | 238171 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4063 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002787.57611 | 2101794.13843 | 37.7512840213515 | -122.433214691609 | (37.7512840213515, -122.433214691609) | |||
| 159746 | 159746 | 214711 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 San Aleso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993359.6935 | 2094710.89058 | 37.7312958694138 | -122.46530264071998 | (37.7312958694138, -122.46530264072) | |||
| 158748 | 158748 | 135990 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 90 Myrtle St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6007019.38816 | 2114166.0331200003 | 37.7854934765818 | -122.41945820564301 | (37.7854934765818, -122.419458205643) | |||
| 158468 | 158468 | 238230 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3825 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004293.04098 | 2101877.85782 | 37.7515991824694 | -122.42801458940501 | (37.7515991824694, -122.428014589405) | |||
| 158254 | 158254 | 135936 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Spruce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997050.12682 | 2116069.05064 | 37.7901521005919 | -122.45408620982501 | (37.7901521005919, -122.454086209825) | |||
| 158044 | 158044 | 237220 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4016 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003841.31749 | 2100435.2340599997 | 37.7476125076296 | -122.429473836574 | (37.7476125076296, -122.429473836574) | |||
| 157770 | 157770 | 239494 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 555 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007704.349769999 | 2096760.84192 | 37.7377414049425 | -122.415855510735 | (37.7377414049425, -122.415855510735) | |||
| 157718 | 157718 | 238227 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 62 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6004074.9323 | 2102707.3864599997 | 37.753864531534 | -122.428827968657 | (37.753864531534, -122.428827968657) | |||
| 157220 | 157220 | 196473 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2500 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012815.80377 | 2093626.35145 | 37.729420779337204 | -122.397962808852 | (37.7294207793372, -122.397962808852) | |||
| 156953 | 156953 | 43260 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 445 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 5 | Permit Number 43042 | 6010210.47935 | 2092211.96475 | 37.7253917248338 | -122.40687006131 | (37.7253917248338, -122.40687006131) | |
| 156325 | 156325 | 33812 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 261 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/26/1996 12:00:00 AM | 5 | Permit Number 37827 | 6006136.86682 | 2110893.01835 | 37.776456830551 | -122.42227884741501 | (37.776456830551, -122.422278847415) | |
| 156227 | 156227 | 52875 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 118@ BEACH Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48887 | 6001367.786590001 | 2121129.52184 | 37.8042934541427 | -122.439510392889 | (37.8042934541427, -122.439510392889) | |
| 155902 | 155902 | 123062 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 472 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5991906.84489 | 2112217.36307 | 37.7792801711752 | -122.471600599763 | (37.7792801711752, -122.471600599763) | |||
| 155352 | 155352 | 178968 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1029 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008554.00356 | 2086922.9270900001 | 37.710776304465 | -122.412222721805 | (37.710776304465, -122.412222721805) | |||
| 154585 | 154585 | 179063 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Colonial Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000420.96554 | 2093594.54688 | 37.7286353411305 | -122.440810550888 | (37.7286353411305, -122.440810550888) | |||
| 154459 | 154459 | 30576 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 268 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52597 | 6003988.43817 | 2108723.63607 | 37.770378817350604 | -122.429556120021 | (37.7703788173506, -122.429556120021) | |
| 154154 | 154154 | 237260 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 451 Murray St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006429.81874 | 2096175.27527 | 37.7360618337705 | -122.420220640067 | (37.7360618337705, -122.420220640067) | |||
| 153533 | 153533 | 117710 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 477 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5983117.17834 | 2112671.33055 | 37.7800141944428 | -122.502040811752 | (37.7800141944428, -122.502040811752) | |||
| 153416 | 153416 | 179147 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 424 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009472.5674 | 2092325.01003 | 37.72566080560021 | -122.40942894009301 | (37.7256608056002, -122.409428940093) | |||
| 153219 | 153219 | 179023 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 947 Olmstead St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008910.54006 | 2090367.6054099998 | 37.7202546776964 | -122.411233621349 | (37.7202546776964, -122.411233621349) |
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");