Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 154192 | 154192 | 214784 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 222 Fowler Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 50 | Width 8ft | 5997118.36808 | 2099147.53648 | 37.7436938709906 | -122.45262836023399 | (37.7436938709906, -122.452628360234) | |||
| 167790 | 167790 | 179107 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 345 Congdon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 3ft | 6004727.316269999 | 2093590.79678 | 37.7288693555286 | -122.425922967771 | (37.7288693555286, -122.425922967771) | |||
| 20569 | 20569 | 26702 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 140 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/1998 12:00:00 AM | 30 | 3X3 | 6006456.60108 | 2097572.163 | 37.739898885722 | -122.42022715296899 | (37.739898885722, -122.420227152969) | ||
| 108715 | 108715 | 26900 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 Amber Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/16/1999 12:00:00 AM | 30 | 3X3 | 5999908.8159045 | 2099289.8400101 | 37.7442440939699 | -122.44298991141001 | (37.7442440939699, -122.44298991141) | ||
| 163033 | 163033 | 238206 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 427 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6003541.496590001 | 2103297.00416 | 37.7554532756756 | -122.43071478496599 | (37.7554532756756, -122.430714784966) | |||
| 19447 | 19447 | 2552 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 59 Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/1999 12:00:00 AM | 25 | 3X3 | 6001211.45267 | 2095788.41504 | 37.7347041848314 | -122.43823489701799 | (37.7347041848314, -122.438234897018) | ||
| 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) | |||
| 45051 | 45051 | 238283 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 119 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6002051.74393 | 2105136.9168599998 | 37.760420717867206 | -122.435998447696 | (37.7604207178672, -122.435998447696) | |||
| 120872 | 120872 | 62780 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 83 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | 22 | Permit Number 23135 | 5999908.40819 | 2091902.69493 | 37.7239607020173 | -122.44246107033301 | (37.7239607020173, -122.442461070333) | |
| 31550 | 31550 | 237051 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1385 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6010363.50755 | 2101264.14929 | 37.7502556447887 | -122.406978792951 | (37.7502556447887, -122.406978792951) | |||
| 47915 | 47915 | 213379 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1229 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5993586.097030001 | 2107103.8483700003 | 37.7653368303421 | -122.46541985384701 | (37.7653368303421, -122.465419853847) | |||
| 56687 | 56687 | 238466 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 48 Potomac St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6003144.15321 | 2108572.53902 | 37.7699161017881 | -122.43246570654301 | (37.7699161017881, -122.432465706543) | |||
| 58171 | 58171 | 62166 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 92 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | 21 | Permit Number 23136 | 5999904.31715 | 2091941.2410400002 | 37.7240663075915 | -122.44247797848301 | (37.7240663075915, -122.442477978483) | |
| 72283 | 72283 | 238188 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 249 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6003535.9156 | 2101543.50295 | 37.750638258661105 | -122.430608968043 | (37.7506382586611, -122.430608968043) | |||
| 42008 | 42008 | 238157 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4231 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6001637.0207400005 | 2102310.76152 | 37.7526372087501 | -122.437230420853 | (37.7526372087501, -122.437230420853) | |||
| 95889 | 95889 | 9346 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 217 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1999 12:00:00 AM | 20 | 2X2 | 6000803.9441694 | 2098478.3891844 | 37.742067037249 | -122.43983659070601 | (37.742067037249, -122.439836590706) | ||
| 96212 | 96212 | 63809 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 407 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | 20 | 3x9 | Permit Number 24496 | 6008808.73313128 | 2096879.87499426 | 37.7381302692545 | -122.412045520647 | (37.7381302692545, -122.412045520647) |
| 125874 | 125874 | 95196 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 140 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2011 12:00:00 AM | 20 | 3x3 | Permit Number 767111 | 5992360.0 | 2098167.1 | 37.740728049154896 | -122.46901016645201 | (37.7407280491549, -122.469010166452) | |
| 63508 | 63508 | 237302 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 407 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 2ft | 6008792.81398 | 2096861.65 | 37.7380793341971 | -122.412099273675 | (37.7380793341971, -122.412099273675) | |||
| 132833 | 132833 | 179056 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Santa Ysabel Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6000936.563080001 | 2093078.77727 | 37.7272485065017 | -122.438991155826 | (37.7272485065017, -122.438991155826) | |||
| 137373 | 137373 | 136004 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1027 Broadway | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 3ft | 6008655.5558400005 | 2118272.73317 | 37.796861491822604 | -122.41408816572999 | (37.7968614918226, -122.41408816573) | |||
| 170292 | 170292 | 237099 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3571 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6005122.2965400005 | 2106016.8849299997 | 37.7630108606773 | -122.425441442891 | (37.7630108606773, -122.425441442891) | |||
| 179675 | 179675 | 238211 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3711 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6003641.48585 | 2103009.86923 | 37.7546705354436 | -122.430348506399 | (37.7546705354436, -122.430348506399) | |||
| 16838 | 16838 | 63769 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 55 Hawthorne St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2013 12:00:00 AM | 18 | 3x3 | Permit Number 768706 | 6013040.47104 | 2113998.55413 | 37.7853709106802 | -122.398615140189 | (37.7853709106802, -122.398615140189) | |
| 17633 | 17633 | 23053 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1074 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/16/1992 12:00:00 AM | 18 | 3X3 | 6006318.63458 | 2103360.59062 | 37.7557848161263 | -122.421115089604 | (37.7557848161263, -122.421115089604) | ||
| 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) | |||
| 21292 | 21292 | 27301 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 738 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/06/1999 12:00:00 AM | 18 | 2X3 | 6010383.48436 | 2104847.2768900003 | 37.7600952334384 | -122.407162256428 | (37.7600952334384, -122.407162256428) | ||
| 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) | |||
| 25042 | 25042 | 70403 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 215 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 18 | 6006511.50188 | 2092924.3025099998 | 37.7271399781258 | -122.419707630826 | (37.7271399781258, -122.419707630826) | ||
| 30820 | 30820 | 237325 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 69 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 1ft | 6007282.4623300005 | 2099098.5460200002 | 37.744136493903 | -122.41747981135 | (37.744136493903, -122.41747981135) | |||
| 44542 | 44542 | 34480 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 771 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 18 | Permit Number 38207 | 6009276.26447 | 2119410.9605 | 37.8000216267413 | -122.412020839304 | (37.8000216267413, -122.412020839304) | |
| 73640 | 73640 | 46789 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 87 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 18 | Permit Number 44880 | 6002509.21412 | 2093699.7539 | 37.7290429228788 | -122.43359887658 | (37.7290429228788, -122.43359887658) | |
| 89994 | 89994 | 2451 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1805X Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6003959.5200660005 | 2114567.2690482 | 37.7864223498862 | -122.430073076908 | (37.7864223498862, -122.430073076908) | |||
| 146347 | 146347 | 62167 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 88 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/06/1985 12:00:00 AM | 18 | Permit Number 22283 | 5999914.56058 | 2091930.95128 | 37.724038638146205 | -122.44244183023599 | (37.7240386381462, -122.442441830236) | |
| 160882 | 160882 | 135963 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2517 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6001390.29582 | 2117256.32875 | 37.793659967376 | -122.43915472812799 | (37.793659967376, -122.439154728128) | |||
| 162952 | 162952 | 237081 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 88 Hoff St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6006542.9784 | 2106353.80333 | 37.7640161255773 | -122.420551698499 | (37.7640161255773, -122.420551698499) | |||
| 173069 | 173069 | 62262 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 78 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1985 12:00:00 AM | 18 | Permit Number 22388 | 5999957.62074 | 2091909.06342 | 37.7239809934048 | -122.442291407838 | (37.7239809934048, -122.442291407838) | |
| 177146 | 177146 | 70504 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 437 Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 18 | 6004727.68791 | 2092850.7822900002 | 37.7268374605684 | -122.42586902913901 | (37.7268374605684, -122.425869029139) | ||
| 179501 | 179501 | 238076 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 439 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6006568.02437 | 2096207.3458599998 | 37.7361576790174 | -122.41974508128 | (37.7361576790174, -122.41974508128) | |||
| 184250 | 184250 | 238259 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Hartford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6002686.20727 | 2105243.22796 | 37.7607486457507 | -122.433811733548 | (37.7607486457507, -122.433811733548) | |||
| 27319 | 27319 | 246424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 418 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6003710.7768 | 2099847.4001700003 | 37.7459910605319 | -122.429883314964 | (37.7459910605319, -122.429883314964) | |||
| 54739 | 54739 | 238467 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 84 Potomac St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6003105.62038 | 2108812.21819 | 37.77057201691021 | -122.43261611365801 | (37.7705720169102, -122.432616113658) | |||
| 56597 | 56597 | 62492 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 61 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | 17 | Permit Number 22663 | 6000854.65183 | 2092771.54235 | 37.726400248862205 | -122.43925230995 | (37.7264002488622, -122.43925230995) | |
| 58748 | 58748 | 121640 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 195 Otsego Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 17 | 6000583.2387 | 2092221.3848599999 | 37.724874193767796 | -122.440151136477 | (37.7248741937678, -122.440151136477) | |||
| 63678 | 63678 | 213381 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1336 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5994897.17134 | 2106458.29966 | 37.7636398474165 | -122.46083839709401 | (37.7636398474165, -122.460838397094) | |||
| 64555 | 64555 | 239531 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 122 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007359.24637 | 2097609.09568 | 37.7400511148656 | -122.417108790654 | (37.7400511148656, -122.417108790654) | |||
| 136564 | 136564 | 238497 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 71 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6003696.82285 | 2098018.95409 | 37.7409697795215 | -122.429801171794 | (37.7409697795215, -122.429801171794) | |||
| 146982 | 146982 | 238159 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 536 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6001813.48692 | 2102703.50128 | 37.7537256078766 | -122.43664828070101 | (37.7537256078766, -122.436648280701) | |||
| 164246 | 164246 | 62478 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 19 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | 17 | Permit Number 22649 | 6000701.05589 | 2093131.58953 | 37.7273801141826 | -122.43980908564501 | (37.7273801141826, -122.439809085645) | |
| 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) | |||
| 18466 | 18466 | 26512 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2862 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2003 12:00:00 AM | 16 | 3X3 | 6008947.332669999 | 2101811.77998 | 37.7516799676748 | -122.41191472918301 | (37.7516799676748, -122.411914729183) | ||
| 18694 | 18694 | 10178 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1086 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/29/2001 12:00:00 AM | 16 | 2X2 | 6005705.19862 | 2102704.3683 | 37.7539483816144 | -122.423189907382 | (37.7539483816144, -122.423189907382) | ||
| 27437 | 27437 | 238449 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 49 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6002608.8284599995 | 2108556.35422 | 37.76984129166121 | -122.434316224409 | (37.7698412916612, -122.434316224409) | |||
| 35005 | 35005 | 238447 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 61 Carmelita St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6002599.15446 | 2108631.96581 | 37.770048353377106 | -122.434355093136 | (37.7700483533771, -122.434355093136) | |||
| 39307 | 39307 | 66567 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 41 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | 16 | Permit Number 29756 | 6005047.11996 | 2093219.91873 | 37.7278690746777 | -122.424791009107 | (37.7278690746777, -122.424791009107) | |
| 39708 | 39708 | 70395 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 190 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 16 | 6005551.028469999 | 2092833.80452 | 37.72683733826221 | -122.423021551618 | (37.7268373382622, -122.423021551618) | ||
| 40667 | 40667 | 238073 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 206 Bennington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007088.66208 | 2096951.7164900003 | 37.7382308717587 | -122.417997772301 | (37.7382308717587, -122.417997772301) | |||
| 43135 | 43135 | 135960 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2980 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5999353.02383 | 2117377.12096 | 37.7938754952995 | -122.446212529304 | (37.7938754952995, -122.446212529304) | |||
| 46218 | 46218 | 34478 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 755 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 16 | Permit Number 38205 | 6009336.13836 | 2119417.92641 | 37.8000441124981 | -122.411814144501 | (37.8000441124981, -122.411814144501) | |
| 51992 | 51992 | 62174 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 48 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1985 12:00:00 AM | 16 | Permit Number 22290 | 6000090.28991 | 2091840.80817 | 37.7238011406834 | -122.44182789633699 | (37.7238011406834, -122.441827896337) | |
| 52549 | 52549 | 237082 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 88 Hoff St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006545.3502 | 2106330.40171 | 37.7639520038912 | -122.42054183386499 | (37.7639520038912, -122.420541833865) | |||
| 55265 | 55265 | 214693 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5994489.45521 | 2099957.28838 | 37.7457662651052 | -122.46177714269699 | (37.7457662651052, -122.461777142697) | |||
| 57265 | 57265 | 239443 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 112 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003408.83198 | 2096173.52451 | 37.735886340079105 | -122.430665282699 | (37.7358863400791, -122.430665282699) | |||
| 63147 | 63147 | 68401 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 16 | Permit Number 32233 | 6002304.62048 | 2093927.0229599997 | 37.7296553414093 | -122.434322413556 | (37.7296553414093, -122.434322413556) | |
| 63355 | 63355 | 238404 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 91 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003826.96845 | 2107845.69213 | 37.7679590529034 | -122.430052005311 | (37.7679590529034, -122.430052005311) | |||
| 69458 | 69458 | 32354 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 116 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | 16 | Permit Number 36908 | 6002648.503 | 2105198.2324099997 | 37.7606229592107 | -122.43393891927299 | (37.7606229592107, -122.433938919273) | |
| 73161 | 73161 | 179069 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 315 Delano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5999894.17292 | 2091984.49333 | 37.7241844902126 | -122.44251614932301 | (37.7241844902126, -122.442516149323) | |||
| 90273 | 90273 | 12830 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2224 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 5 | 5988512.18064 | 2114699.8246299997 | 37.785899329731606 | -122.483526054934 | (37.7858993297316, -122.483526054934) | |||
| 106913 | 106913 | 12834 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2240 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2005 12:00:00 AM | 16 | 5 | 5988481.054959999 | 2114714.7558 | 37.785938514796705 | -122.483634834967 | (37.7859385147967, -122.483634834967) | ||
| 113453 | 113453 | 26851 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 987 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6006383.06935 | 2103878.3785200003 | 37.7572101739855 | -122.420929013752 | (37.7572101739855, -122.420929013752) | |||
| 123822 | 123822 | 62202 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 29 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1985 12:00:00 AM | 16 | Permit Number 22322 | 6000871.44377 | 2091886.89896 | 37.72397217555589 | -122.43913088528099 | (37.7239721755559, -122.439130885281) | |
| 130421 | 130421 | 237371 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1123 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6009231.77106 | 2102473.8810799997 | 37.753513902957 | -122.41097786045799 | (37.753513902957, -122.410977860458) | |||
| 131113 | 131113 | 238332 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 276 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6002700.68685 | 2104294.92974 | 37.7581456687184 | -122.43369387828999 | (37.7581456687184, -122.43369387829) | |||
| 131388 | 131388 | 37775 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 718 Dwight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 16 | Permit Number 40113 | 6009462.43641 | 2091064.86672 | 37.722200148706605 | -122.40937507161699 | (37.7222001487066, -122.409375071617) | |
| 131595 | 131595 | 69243 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2021 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/1994 12:00:00 AM | 16 | Permit Number 33307 | 6003282.73155 | 2118223.78108 | 37.796423843946705 | -122.432675884388 | (37.7964238439467, -122.432675884388) | ||
| 132177 | 132177 | 62180 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 22 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1985 12:00:00 AM | 16 | Permit Number 22297 | 6000204.07987 | 2091781.1748099998 | 37.723643884350096 | -122.44143026741101 | (37.7236438843501, -122.441430267411) | |
| 135068 | 135068 | 237316 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 63 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6009177.0058 | 2097121.2594 | 37.738813714278706 | -122.410789255525 | (37.7388137142787, -122.410789255525) | |||
| 158105 | 158105 | 237301 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 415 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6008790.80397 | 2096836.4006299998 | 37.7380098921444 | -122.41210443936899 | (37.7380098921444, -122.412104439369) | |||
| 158187 | 158187 | 196460 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 364 Missouri St | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6013463.46293 | 2105385.87525 | 37.76174599211679 | -122.396547761567 | (37.7617459921168, -122.396547761567) | |||
| 160636 | 160636 | 35253 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2250 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 16 | Permit Number 38739 | 6008088.43141 | 2120207.50426 | 37.8021420203875 | -122.416187651964 | (37.8021420203875, -122.416187651964) | |
| 164685 | 164685 | 237058 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 61 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 6ft | 6006122.75596 | 2099931.6661799997 | 37.7463587321654 | -122.421548984621 | (37.7463587321654, -122.421548984621) | |||
| 167191 | 167191 | 237176 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1515 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6010174.13049 | 2100416.15675 | 37.747916644848104 | -122.407573893224 | (37.7479166448481, -122.407573893224) | |||
| 170395 | 170395 | 237313 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 307 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6008971.47765 | 2096850.4815900002 | 37.7380586911421 | -122.41148075324699 | (37.7380586911421, -122.411480753247) | |||
| 172956 | 172956 | 237184 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2989 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6009623.978680001 | 2100537.57655 | 37.7482192262453 | -122.40948486982799 | (37.7482192262453, -122.409484869828) | |||
| 175130 | 175130 | 32497 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 665 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 16 | Permit Number 37002 | 6007442.3069400005 | 2095863.1015400002 | 37.7352616718948 | -122.416697941676 | (37.7352616718948, -122.416697941676) | |
| 178828 | 178828 | 78251 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 559 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 16 | 6002953.557080001 | 2090366.3939 | 37.7199154633005 | -122.431824838869 | (37.7199154633005, -122.431824838869) | ||
| 180854 | 180854 | 238080 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008716.17738 | 2096910.1385299999 | 37.7382081728556 | -122.41236767183099 | (37.7382081728556, -122.412367671831) | |||
| 181649 | 181649 | 237258 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 260 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6006124.96949 | 2096076.13929 | 37.7357724463386 | -122.42126759123998 | (37.7357724463386, -122.42126759124) | |||
| 182961 | 182961 | 239454 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 261 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6001469.80572 | 2096427.53157 | 37.736473741255004 | -122.437387434391 | (37.736473741255, -122.437387434391) | |||
| 187035 | 187035 | 213389 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1758 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5993139.29631 | 2103519.85044 | 37.755470330397394 | -122.46670467568701 | (37.7554703303974, -122.466704675687) | |||
| 187208 | 187208 | 214694 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5994500.96734 | 2099944.5523099997 | 37.7457319577612 | -122.461736412418 | (37.7457319577612, -122.461736412418) | |||
| 30285 | 30285 | 237226 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5997960.11385 | 2106796.79092 | 37.764745019783795 | -122.450269087756 | (37.7647450197838, -122.450269087756) | |||
| 33962 | 33962 | 41935 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 639 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 15 | Permit Number 42294 | 5994689.00791 | 2111165.50547 | 37.7765526175284 | -122.461899718162 | (37.7765526175284, -122.461899718162) | |
| 38249 | 38249 | 64864 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Parsons St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 15 | Permit Number 25882 | 5996577.342130001 | 2110690.66447 | 37.775357357934205 | -122.45533313851999 | (37.7753573579342, -122.45533313852) | |
| 39983 | 39983 | 237104 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3445 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6005914.842069999 | 2106060.03243 | 37.763174080447 | -122.42270336159201 | (37.763174080447, -122.422703361592) | |||
| 47504 | 47504 | 213455 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5993130.50239 | 2099670.13691 | 37.744899496712996 | -122.466455299074 | (37.744899496713, -122.466455299074) | |||
| 50046 | 50046 | 238442 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 77 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002582.7882900005 | 2108738.36652 | 37.77033957454611 | -122.434419311908 | (37.7703395745461, -122.434419311908) | |||
| 53799 | 53799 | 178967 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 505 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5999517.95201 | 2086983.4986400001 | 37.7104314441356 | -122.44345762526899 | (37.7104314441356, -122.443457625269) | |||
| 58275 | 58275 | 237306 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6008859.53771 | 2097948.3487400003 | 37.741066915300294 | -122.411945347518 | (37.7410669153003, -122.411945347518) | |||
| 69055 | 69055 | 239532 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007362.80754 | 2097682.06201 | 37.7402516645702 | -122.41710164643801 | (37.7402516645702, -122.417101646438) |
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");