Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3100 | 3100 | 124475 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 336 Willard St North | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 1 | Width 3ft | Permit Number 51142 | 5996295.75285 | 2110564.44719 | 37.7749946376288 | -122.456298087251 | (37.7749946376288, -122.456298087251) | |
| 10315 | 10315 | 47259 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1487 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/11/2014 12:00:00 AM | 1 | 3x3 | Permit Number 770986 | 5989591.7291 | 2105266.36 | 37.7600604072843 | -122.479100863475 | (37.7600604072843, -122.479100863475) |
| 23166 | 23166 | 26519 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2851 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | 1 | 1X1 | Permit Number 777140 | 6009004.2746 | 2101873.01384 | 37.751851296609296 | -122.411722142074 | (37.7518512966093, -122.411722142074) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 26420 | 26420 | 237140 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1285 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010074.8833099995 | 2101754.71583 | 37.7515864768406 | -122.40801147007099 | (37.7515864768406, -122.408011470071) | |||
| 26523 | 26523 | 88167 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 189 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2013 12:00:00 AM | 1 | 3x3 | Permit Number 51184 | 6010014.6058 | 2087504.2072 | 37.7124542316575 | -122.40721547231199 | (37.7124542316575, -122.407215472312) | |
| 26868 | 26868 | 135947 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 31 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001885.41156 | 2120707.63326 | 37.803164505492504 | -122.43768887996201 | (37.8031645054925, -122.437688879962) | |||
| 27296 | 27296 | 213681 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6000730.35653 | 2095033.04499 | 37.7326027399078 | -122.439844065674 | (37.7326027399078, -122.439844065674) | |||
| 28064 | 28064 | 237394 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2849 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009003.01461 | 2101888.403 | 37.751893481115395 | -122.41172758658399 | (37.7518934811154, -122.411727586584) | |||
| 28184 | 28184 | 214762 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 81 Northwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5995454.99385 | 2094213.2008599997 | 37.730049946826796 | -122.45802284817199 | (37.7300499468268, -122.458022848172) | |||
| 28369 | 28369 | 237264 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 780 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007326.8188 | 2095184.16778 | 37.7333909723093 | -122.417049136835 | (37.7333909723093, -122.417049136835) | |||
| 28640 | 28640 | 124153 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 950 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996057.73725 | 2112257.8824 | 37.7796306981474 | -122.45724396024201 | (37.7796306981474, -122.457243960242) | |||
| 28695 | 28695 | 214477 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1587 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990545.71643 | 2104592.61626 | 37.758265842404 | -122.47575231233601 | (37.758265842404, -122.475752312336) | |||
| 29523 | 29523 | 237237 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 643 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998666.13007 | 2105451.86711 | 37.7610925752937 | -122.44773034478001 | (37.7610925752937, -122.44773034478) | |||
| 29741 | 29741 | 196461 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 615 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014144.28645 | 2104277.08263 | 37.7587393543665 | -122.39411542098999 | (37.7587393543665, -122.39411542099) | |||
| 29788 | 29788 | 214638 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1239 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993279.003830001 | 2107062.36881 | 37.7652052226678 | -122.466478993514 | (37.7652052226678, -122.466478993514) | |||
| 29862 | 29862 | 237360 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1328 Treat Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008685.53865 | 2100922.75177 | 37.749224204239 | -122.412757205096 | (37.749224204239, -122.412757205096) | |||
| 29919 | 29919 | 237125 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 900 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008561.37097 | 2103253.06793 | 37.7556157579627 | -122.413351355702 | (37.7556157579627, -122.413351355702) | |||
| 30296 | 30296 | 202045 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 41 Exeter St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012584.35783 | 2091031.2434099999 | 37.7222822496095 | -122.39858091108201 | (37.7222822496095, -122.398580911082) | |||
| 30654 | 30654 | 237210 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Valley St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6002788.0313800005 | 2099167.4963 | 37.744071904607395 | -122.43302547424 | (37.7440719046074, -122.43302547424) | ||||
| 30946 | 30946 | 214679 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2662 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991458.95209 | 2097290.33549 | 37.7382685749396 | -122.472061728486 | (37.7382685749396, -122.472061728486) | |||
| 31049 | 31049 | 237165 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1801 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009370.48822 | 2099100.96041 | 37.7442603881066 | -122.41026001891001 | (37.7442603881066, -122.41026001891) | |||
| 31418 | 31418 | 238116 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3011 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009261.554769999 | 2104491.09339 | 37.7590543832636 | -122.41101733168999 | (37.7590543832636, -122.41101733169) | |||
| 31810 | 31810 | 214634 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1258 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992402.51004 | 2106874.95458 | 37.764640016757795 | -122.469496904268 | (37.7646400167578, -122.469496904268) | |||
| 32898 | 32898 | 237151 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 601 Hampshire St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6010131.8746 | 2105435.17727 | 37.761695390857795 | -122.40807391988001 | (37.7616953908578, -122.40807391988) | |||
| 32991 | 32991 | 237208 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Valley St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6002753.541619999 | 2099167.64088 | 37.74407034517979 | -122.433144742342 | (37.7440703451798, -122.433144742342) | ||||
| 33402 | 33402 | 237389 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3100 25th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008835.28321 | 2101547.20536 | 37.750947218045795 | -122.412283514173 | (37.7509472180458, -122.412283514173) | |||
| 33416 | 33416 | 196500 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 468 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010880.72676 | 2112052.38014 | 37.7799066128255 | -122.405950096213 | (37.7799066128255, -122.405950096213) | |||
| 33473 | 33473 | 214546 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 714 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993519.43334 | 2106675.98145 | 37.7641581752734 | -122.465619338785 | (37.7641581752734, -122.465619338785) | |||
| 33846 | 33846 | 123222 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 738 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5993211.31332 | 2110438.04706 | 37.7744700313031 | -122.466958548333 | (37.7744700313031, -122.466958548333) | |||
| 34005 | 34005 | 196506 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6016688.4000699995 | 2094936.9316 | 37.7332342924349 | -122.384666003252 | (37.7332342924349, -122.384666003252) | |||
| 34050 | 34050 | 214489 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2083 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5991276.32219 | 2101284.43599 | 37.7492247771203 | -122.47298434476801 | (37.7492247771203, -122.472984344768) | |||
| 34465 | 34465 | 179159 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 113 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001727.04807 | 2087313.1468599997 | 37.711462320802205 | -122.435846103423 | (37.7114623208022, -122.435846103423) | |||
| 34716 | 34716 | 237236 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 641 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998663.85715 | 2105470.4547200003 | 37.761143482317294 | -122.447739543949 | (37.7611434823173, -122.447739543949) | |||
| 34728 | 34728 | 123892 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 285 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992432.92995 | 2113586.68874 | 37.7830703873676 | -122.469880394252 | (37.7830703873676, -122.469880394252) | |||
| 35914 | 35914 | 196425 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 282 Shipley St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6011155.7597199995 | 2111427.64984 | 37.778206627062296 | -122.404954631245 | (37.7782066270623, -122.404954631245) | |||
| 36046 | 36046 | 237218 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1534 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003930.350380001 | 2099302.4493400003 | 37.744507183667295 | -122.42908521071699 | (37.7445071836673, -122.429085210717) | |||
| 36262 | 36262 | 238321 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 129 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5999968.6486599995 | 2105032.89953 | 37.760016551754 | -122.443195417152 | (37.760016551754, -122.443195417152) | |||
| 36963 | 36963 | 179014 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 174 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004359.78757 | 2090147.3010099998 | 37.7193934976835 | -122.426948390073 | (37.7193934976835, -122.426948390073) | |||
| 37932 | 37932 | 120691 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 346 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5989055.073580001 | 2112994.27839 | 37.7812479638107 | -122.481522861281 | (37.7812479638107, -122.481522861281) | |||
| 37977 | 37977 | 72335 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 775 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 1 | 5988805.09626 | 2110041.06897 | 37.773124736634294 | -122.482171226619 | (37.7731247366343, -122.482171226619) | ||
| 38688 | 38688 | 237334 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 379 Highland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6007338.79094 | 2096540.2275099999 | 37.737115088292 | -122.417103799428 | (37.737115088292, -122.417103799428) | |||
| 40351 | 40351 | 237387 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3100 25th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008814.668380001 | 2101545.8698 | 37.7509423940946 | -122.412354708115 | (37.7509423940946, -122.412354708115) | |||
| 40632 | 40632 | 120241 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 288 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5988396.42783 | 2114046.0373400003 | 37.784097477489794 | -122.483878566425 | (37.7840974774898, -122.483878566425) | |||
| 41091 | 41091 | 214637 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1231 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993277.56181 | 2107122.2146799997 | 37.765369460447296 | -122.466488331178 | (37.7653694604473, -122.466488331178) | |||
| 42773 | 42773 | 237209 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Valley St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6002775.7731 | 2099167.46556 | 37.744071124872896 | -122.43306785839899 | (37.7440711248729, -122.433067858399) | ||||
| 43645 | 43645 | 213424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2329 Cecilia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991443.60729 | 2099536.95345 | 37.7444363251911 | -122.47227850735001 | (37.7444363251911, -122.47227850735) | |||
| 43899 | 43899 | 214548 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 800 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | Width 4ft | 5993241.508719999 | 2106665.1801299998 | 37.7641124834295 | -122.46657980664 | (37.7641124834295, -122.46657980664) | |||
| 44697 | 44697 | 103496 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1850X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2014 12:00:00 AM | 1 | 3x3 | Permit Number 771036 | 5989840.04595 | 2110621.50302 | 37.7747785915425 | -122.478633697845 | (37.7747785915425, -122.478633697845) | |
| 45768 | 45768 | 109206 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2322 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Permit Number 774968 | 5991447.56759 | 2112037.47435 | 37.77875966432521 | -122.47317629235901 | (37.7787596643252, -122.473176292359) | ||
| 46285 | 46285 | 65280 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 435 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1989 12:00:00 AM | 1 | Permit Number 28085 | 6011091.92612 | 2112217.73363 | 37.7803724445696 | -122.405231107147 | (37.7803724445696, -122.405231107147) | |
| 47200 | 47200 | 214819 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001004.15668 | 2094363.7751900002 | 37.730780661291206 | -122.438849530576 | (37.7307806612912, -122.438849530576) | |||
| 48514 | 48514 | 50297 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2909 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 1 | Permit Number 47009 | 5989047.82914 | 2095849.4982599998 | 37.7341725865769 | -122.48029267728701 | (37.7341725865769, -122.480292677287) | |
| 48537 | 48537 | 116894 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6001897.52549 | 2120678.68583 | 37.8030857122852 | -122.43764488509899 | (37.8030857122852, -122.437644885099) | |||
| 48960 | 48960 | 214716 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 163 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993482.35353 | 2094088.81019 | 37.729594862901 | -122.46483342661502 | (37.729594862901, -122.464833426615) | |||
| 49034 | 49034 | 214547 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 754 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993387.3182 | 2106668.96839 | 37.764131298133 | -122.46607577350099 | (37.764131298133, -122.466075773501) | |||
| 49492 | 49492 | 135940 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 310 Locust St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5997632.68283 | 2115371.58358 | 37.7882704283935 | -122.452020280013 | (37.7882704283935, -122.452020280013) | |||
| 50315 | 50315 | 237149 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 601 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6010132.87275 | 2105399.32846 | 37.7615970140239 | -122.408067939392 | (37.7615970140239, -122.408067939392) | |||
| 50428 | 50428 | 237250 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Upper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5999614.9988400005 | 2106452.87899 | 37.763895290861605 | -122.444520573572 | (37.7638952908616, -122.444520573572) | |||
| 50531 | 50531 | 96079 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 664 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767703 | 5983226.11153 | 2111277.81973 | 37.7761944189321 | -122.501560849986 | (37.7761944189321, -122.501560849986) |
| 50840 | 50840 | 237249 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5999617.47988 | 2106464.70048 | 37.7639278912924 | -122.444512842101 | (37.7639278912924, -122.444512842101) | |||
| 51276 | 51276 | 214657 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2033 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5990646.87273 | 2101531.01352 | 37.7498653525019 | -122.475178967532 | (37.7498653525019, -122.475178967532) | |||
| 53260 | 53260 | 178985 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 276 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5998310.44307 | 2088707.23579 | 37.7150954964391 | -122.447755025789 | (37.7150954964391, -122.447755025789) | |||
| 53314 | 53314 | 95695 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 523 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767449 | 5992184.07474 | 2111863.6623299997 | 37.7783250403386 | -122.47061578659999 | (37.7783250403386, -122.4706157866) |
| 53356 | 53356 | 238510 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 272 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004605.35635 | 2096606.41263 | 37.737142667797706 | -122.42655923724399 | (37.7371426677977, -122.426559237244) | |||
| 54381 | 54381 | 123144 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 572 10th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5992865.77571 | 2111587.1444200003 | 37.7776051929209 | -122.46823742950501 | (37.7776051929209, -122.468237429505) | |||
| 54653 | 54653 | 51291 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2020 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2004 12:00:00 AM | 1 | Permit Number 47663 | 5989189.38676 | 2113364.18569 | 37.7822714342333 | -122.481085302679 | (37.7822714342333, -122.481085302679) | ||
| 55168 | 55168 | 214804 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 861 Rockdale Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5996707.74048 | 2098249.43953 | 37.7412043802882 | -122.45398335617399 | (37.7412043802882, -122.453983356174) | |||
| 55363 | 55363 | 213618 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 47 Stanford Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5997823.37766 | 2095859.28539 | 37.7347054969618 | -122.449953678441 | (37.7347054969618, -122.449953678441) | |||
| 55797 | 55797 | 178976 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 221 Naglee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5998101.98654 | 2088087.6608 | 37.7133823688881 | -122.448430945451 | (37.7133823688881, -122.448430945451) | |||
| 56087 | 56087 | 58297 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1978 12:00:00 AM | 1 | Permit Number 17314 | 5995266.20192 | 2113689.20735 | 37.783515241763894 | -122.46008592615101 | (37.7835152417639, -122.460085926151) | ||
| 56297 | 56297 | 179040 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2945 24th Ave | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 5989055.545969999 | 2095618.79902 | 37.7335395942586 | -122.480249118621 | (37.7335395942586, -122.480249118621) | |||
| 56542 | 56542 | 213324 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 355 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5991941.51913 | 2090886.05993 | 37.7207119433918 | -122.469927103079 | (37.7207119433918, -122.469927103079) | |||
| 57170 | 57170 | 114542 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2035 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774983 | 6011944.84803 | 2103714.6650900003 | 37.757072587740296 | -122.401682603564 | (37.7570725877403, -122.401682603564) | ||
| 57522 | 57522 | 237388 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3100 25th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008822.57979 | 2101547.7181599997 | 37.7509479132318 | -122.41232748022699 | (37.7509479132318, -122.412327480227) | |||
| 58517 | 58517 | 237147 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3620 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006103.51013 | 2104360.70517 | 37.75851876863779 | -122.4219301011 | (37.7585187686378, -122.4219301011) | |||
| 59299 | 59299 | 238355 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 677 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003708.60882 | 2104373.3659200002 | 37.7584181758823 | -122.43021364584999 | (37.7584181758823, -122.43021364585) | |||
| 59593 | 59593 | 237207 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Valley St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6002742.12056 | 2099166.74161 | 37.7440672281147 | -122.433184169536 | (37.7440672281147, -122.433184169536) | ||||
| 59938 | 59938 | 237315 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 515 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6008887.93473 | 2095934.39273 | 37.7355386235085 | -122.41170489307501 | (37.7355386235085, -122.411704893075) | |||
| 60325 | 60325 | 214563 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1450 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991226.48085 | 2106597.45408 | 37.7638100387342 | -122.47354419252599 | (37.7638100387342, -122.473544192526) | |||
| 61270 | 61270 | 238382 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4127 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002850.37349 | 2104133.23019 | 37.757710172901504 | -122.433164644326 | (37.7577101729015, -122.433164644326) | |||
| 61617 | 61617 | 239399 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 338 Hoffman Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6000615.20196 | 2101754.98366 | 37.751053037676 | -122.44072417728998 | (37.751053037676, -122.44072417729) | |||
| 61667 | 61667 | 237251 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Upper Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5999611.7264 | 2106438.84771 | 37.763856577740505 | -122.444530883411 | (37.7638565777405, -122.444530883411) | |||
| 62219 | 62219 | 213573 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 401 Dewey Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5995208.70184 | 2100413.07322 | 37.7470591142869 | -122.459323109585 | (37.7470591142869, -122.459323109585) | |||
| 63276 | 63276 | 59606 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1077 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 1 | 3x3 | Permit Number 19007 | 6015566.4484 | 2104073.9972599996 | 37.7582606677124 | -122.38918270881099 | (37.7582606677124, -122.389182708811) | |
| 63304 | 63304 | 213383 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 337 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5996461.62761 | 2106582.16791 | 37.764069850154904 | -122.455436416867 | (37.7640698501549, -122.455436416867) | |||
| 64127 | 64127 | 105980 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 750 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2014 12:00:00 AM | 1 | 3x4 | Permit Number 772437 | 5989466.7948900005 | 2110227.47578 | 37.7736750233383 | -122.479895995237 | (37.7736750233383, -122.479895995237) | |
| 64185 | 64185 | 196507 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 65 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6016757.4280199995 | 2094967.1096700002 | 37.7333209726796 | -122.384429453683 | (37.7333209726796, -122.384429453683) | |||
| 65271 | 65271 | 238354 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 677 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003710.47164 | 2104353.75948 | 37.758364446775296 | -122.43020580465 | (37.7583644467753, -122.43020580465) | |||
| 65415 | 65415 | 214681 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993846.98731 | 2099285.74524 | 37.743885371716 | -122.463949948827 | (37.743885371716, -122.463949948827) | |||
| 65949 | 65949 | 214701 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 289 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992648.14001 | 2094956.6542099998 | 37.7319296144386 | -122.467780457307 | (37.7319296144386, -122.467780457307) | |||
| 66203 | 66203 | 214714 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106 Aptos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993036.39091 | 2094292.8856099998 | 37.7301294810876 | -122.466389978617 | (37.7301294810876, -122.466389978617) | |||
| 66450 | 66450 | 237084 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Hoff St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006548.40896 | 2106250.77586 | 37.7637335423826 | -122.420525601982 | (37.7637335423826, -122.420525601982) | |||
| 66573 | 66573 | 237191 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1026 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004373.7656 | 2102888.2274700003 | 37.7543779877776 | -122.427807417997 | (37.7543779877776, -122.427807417997) | |||
| 66928 | 66928 | 214803 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 861 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5996696.54151 | 2098246.82779 | 37.741196566960795 | -122.454021889422 | (37.7411965669608, -122.454021889422) | |||
| 67142 | 67142 | 118470 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 510 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5981008.92024 | 2112222.55161 | 37.7786579010228 | -122.50930075514499 | (37.7786579010228, -122.509300755145) |
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");