Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97285 | 97285 | 102172 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 9X Hattie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621.0 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) |
| 143029 | 143029 | 102171 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 9X Hattie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621.0 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) |
| 85018 | 85018 | 92970 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3506 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2009 12:00:00 AM | 3x3 | Permit Number 53127 | 6003465.3 | 2106607.7 | 37.764539336845004 | -122.43121459836901 | (37.764539336845, -122.431214598369) | ||
| 90654 | 90654 | 49014 | Permitted Site 1 | Syzygium paniculatum :: Brush Cherry 198 | 4378 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2002 12:00:00 AM | Permit Number 46200 | 6000173.974491901 | 2105793.6078214003 | 37.762116974703495 | -122.442539913685 | (37.7621169747035, -122.442539913685) | |||
| 81443 | 81443 | 100355 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 Waller St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 12/30/2014 12:00:00 AM | 3 | 27x6 | Permit Number 769031 | 6002899.6 | 2108847.2 | 37.770656382716396 | -122.43333123962 | (37.7706563827164, -122.43333123962) | ||
| 87786 | 87786 | 105728 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 82-98X Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772582 | 6002862.0 | 2108710.0 | 37.7702775320686 | -122.43345149235701 | (37.7702775320686, -122.433451492357) |
| 111761 | 111761 | 105729 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 82-98X Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772582 | 6002862.0 | 2108710.0 | 37.7702775320686 | -122.43345149235701 | (37.7702775320686, -122.433451492357) |
| 139650 | 139650 | 108635 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2610 Lake St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774602 | 5987336.48113 | 2114673.56953 | 37.7857587403195 | -122.487591667787 | (37.7857587403195, -122.487591667787) |
| 145525 | 145525 | 108648 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 196 Lippard Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774607 | 6001751.75522 | 2094959.06379 | 37.7324576925005 | -122.436307555189 | (37.7324576925005, -122.436307555189) | |
| 18067 | 18067 | 5516 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 839 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/2009 12:00:00 AM | 3 | 6X6 | 6005075.66356 | 2103479.99989 | 37.756042537557605 | -122.425422183901 | (37.7560425375576, -122.425422183901) | ||
| 87285 | 87285 | 50652 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Josiah Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2003 12:00:00 AM | Permit Number 47234 | 5996870.80130055 | 2089899.24303395 | 37.718286082953604 | -122.452817003739 | (37.7182860829536, -122.452817003739) | |||
| 111732 | 111732 | 50308 | Permitted Site 1 | Prunus spp :: Cherry 84 | 701 (REVISED) Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2003 12:00:00 AM | Permit Number 47019 | 5994734.51143453 | 2090549.74162157 | 37.719949548569396 | -122.46024830726499 | (37.7199495485694, -122.460248307265) | |||
| 17623 | 17623 | 4137 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3550 Cesar Chavez St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2000 12:00:00 AM | 3 | 3x3 | 6006233.57538 | 2100604.08317 | 37.7482112843407 | -122.421213523093 | (37.7482112843407, -122.421213523093) | ||
| 20694 | 20694 | 4134 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3550 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2000 12:00:00 AM | 3 | 3x3 | 6006304.68418 | 2100605.7275799997 | 37.7482198080922 | -122.42096774735901 | (37.7482198080922, -122.420967747359) | ||
| 121180 | 121180 | 41272 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 516 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/1999 12:00:00 AM | Permit Number 41955 | 5998145.81312844 | 2095035.80887782 | 37.7324628706429 | -122.448779620072 | (37.7324628706429, -122.448779620072) | |||
| 69506 | 69506 | 51979 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 201 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 7 | 3x3 | Permit Number 775837 | 6000531.055869999 | 2092082.3650200001 | 37.7244895060779 | -122.440321560704 | (37.7244895060779, -122.440321560704) | |
| 8180 | 8180 | 21666 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1765 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 4X4 | Permit Number 774582 | 6004178.5577 | 2114595.027 | 37.7865109691436 | -122.42931724201799 | (37.7865109691436, -122.429317242018) |
| 144896 | 144896 | 79557 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 153 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772536 | 6004741.65189255 | 2108986.02751221 | 37.7711418993687 | -122.426969442731 | (37.7711418993687, -122.426969442731) |
| 10801 | 10801 | 83237 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769756 | 6004043.10746 | 2093201.4009 | 37.727761469894794 | -122.42826058457099 | (37.7277614698948, -122.428260584571) |
| 10410 | 10410 | 86450 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2362 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987982.1495 | 2099214.8079 | 37.7433508614418 | -122.4842237451 | (37.7433508614418, -122.4842237451) | ||
| 10519 | 10519 | 86446 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2426 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987996.8709 | 2098757.0924 | 37.742094952584296 | -122.484139283552 | (37.7420949525843, -122.484139283552) | ||
| 10928 | 10928 | 86448 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2410 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987993.1483 | 2098903.2906 | 37.7424961575573 | -122.484162874059 | (37.7424961575573, -122.484162874059) | ||
| 10961 | 10961 | 86453 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2330 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987973.3506 | 2099428.6905 | 37.74393761420671 | -122.48426985180201 | (37.7439376142067, -122.484269851802) | ||
| 10972 | 10972 | 86435 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2578 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988030.7572 | 2097759.3623 | 37.739357420836704 | -122.483948972283 | (37.7393574208367, -122.483948972283) | ||
| 11018 | 11018 | 86445 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2434 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987997.5477 | 2098724.6039 | 37.7420057871296 | -122.484134561433 | (37.7420057871296, -122.484134561433) | ||
| 11518 | 11518 | 86451 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2358 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987978.4269 | 2099245.2659 | 37.743434274314396 | -122.484238850005 | (37.7434342743144, -122.484238850005) | ||
| 11689 | 11689 | 86565 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2243 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987907.2026 | 2100032.4695 | 37.7455915795676 | -122.48454285152799 | (37.7455915795676, -122.484542851528) | ||
| 11712 | 11712 | 86567 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2307 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987921.2336 | 2099575.5655 | 37.744337859372294 | -122.484460828778 | (37.7443378593723, -122.484460828778) | ||
| 11820 | 11820 | 86568 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2337 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987926.9868 | 2099392.4793 | 37.7438354881374 | -122.484427509802 | (37.7438354881374, -122.484427509802) | ||
| 12029 | 12029 | 86454 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2326 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987972.3353 | 2099456.4411 | 37.744013750897295 | -122.48427539724199 | (37.7440137508973, -122.484275397242) | ||
| 12219 | 12219 | 86452 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2350 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987979.4422 | 2099298.3981 | 37.743580220411 | -122.48423923521099 | (37.743580220411, -122.484239235211) | ||
| 12481 | 12481 | 86449 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2370 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987981.4727 | 2099180.2889 | 37.743256041979606 | -122.48422355425699 | (37.7432560419796, -122.484223554257) | ||
| 12490 | 12490 | 86438 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2558 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988026.0275 | 2097893.3718 | 37.7397251004281 | -122.483975149426 | (37.7397251004281, -122.483975149426) | ||
| 12534 | 12534 | 86442 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2470 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988005.6699 | 2098496.5076 | 37.7413799676446 | -122.484089754678 | (37.7413799676446, -122.484089754678) | ||
| 12667 | 12667 | 86440 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2506 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988014.3608 | 2098206.7963 | 37.7405850025908 | -122.484038465173 | (37.7405850025908, -122.484038465173) | ||
| 12670 | 12670 | 86437 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2566 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988027.6041 | 2097846.7049 | 37.7395970571481 | -122.483966277165 | (37.7395970571481, -122.483966277165) | ||
| 12746 | 12746 | 86444 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2438 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988000.2551 | 2098696.1765 | 37.7419278906096 | -122.48412311600401 | (37.7419278906096, -122.484123116004) | ||
| 12867 | 12867 | 86434 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2590 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988032.3338 | 2097694.7224 | 37.7391800283996 | -122.48393878255 | (37.7391800283996, -122.48393878255) | ||
| 13118 | 13118 | 86439 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2550 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988024.4509 | 2097942.8764 | 37.7398609352841 | -122.48398422975 | (37.7398609352841, -122.48398422975) | ||
| 13167 | 13167 | 86441 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2498 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988007.7004 | 2098406.8258 | 37.7411338432365 | -122.484076158984 | (37.7411338432365, -122.484076158984) | ||
| 97679 | 97679 | 86443 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2450 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987997.37774 | 2098622.10748 | 37.741724349066 | -122.484127634313 | (37.741724349066, -122.484127634313) | |
| 143250 | 143250 | 86436 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2574 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988026.00444 | 2097787.2202669997 | 37.7394336348182 | -122.48396744726001 | (37.7394336348182, -122.48396744726) | ||
| 114123 | 114123 | 39607 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 425 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41010 | 5998485.83180749 | 2106734.79631937 | 37.7646048701954 | -122.44844630961 | (37.7646048701954, -122.44844630961) | ||
| 117804 | 117804 | 39606 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 425 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41010 | 5998485.83180749 | 2106734.79631937 | 37.7646048701954 | -122.44844630961 | (37.7646048701954, -122.44844630961) | ||
| 139783 | 139783 | 39603 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 636 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 10 | Permit Number 41005 | 6012670.17637 | 2104503.85017 | 37.759279965615704 | -122.39922952194401 | (37.7592799656157, -122.399229521944) | |
| 160813 | 160813 | 35020 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1013 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1997 12:00:00 AM | 7 | Permit Number 38595 | 6012215.58628 | 2103654.42136 | 37.7569222759593 | -122.400742049433 | (37.7569222759593, -122.400742049433) | ||
| 38648 | 38648 | 68912 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 10 Florence St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 8 | Permit Number 32890 | 6008496.870730001 | 2118345.67653 | 37.797052862167604 | -122.41464241973 | (37.7970528621676, -122.41464241973) | |
| 40751 | 40751 | 68941 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 730 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 6 | Permit Number 32928 | 5989462.36102 | 2110347.5276900004 | 37.774004395159295 | -122.479920119491 | (37.7740043951593, -122.479920119491) | |
| 42627 | 42627 | 68954 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 754 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 3 | Permit Number 32943 | 5988851.01728 | 2110187.80327 | 37.7735302992339 | -122.482023133058 | (37.7735302992339, -122.482023133058) | |
| 43576 | 43576 | 68892 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 40 Exeter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 7 | Permit Number 32864 | 6012556.44634 | 2091062.56254 | 37.7223666905441 | -122.398679591909 | (37.7223666905441, -122.398679591909) | |
| 59592 | 59592 | 68878 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 535 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 9 | Permit Number 32849 | 5994664.33554 | 2111876.7239 | 37.778504013274 | -122.462036654628 | (37.778504013274, -122.462036654628) | |
| 63648 | 63648 | 68925 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2124 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 8 | Permit Number 32909 | 5992060.17158 | 2112059.99244 | 37.77885694376779 | -122.471058716214 | (37.7788569437678, -122.471058716214) | |
| 74474 | 74474 | 68933 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 681 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 7 | Permit Number 32917 | 5992842.88545 | 2110833.13785 | 37.7755335724471 | -122.468261747786 | (37.7755335724471, -122.468261747786) | |
| 89941 | 89941 | 68891 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 36 Exeter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32863 | 6012558.723351 | 2091084.70468571 | 37.722427615253295 | -122.398673273848 | (37.7224276152533, -122.398673273848) | ||
| 101603 | 101603 | 68962 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2302 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 5 | 3x3 | Permit Number 32951 | 5988444.16962 | 2110572.72123 | 37.7745635062345 | -122.483458685783 | (37.7745635062345, -122.483458685783) |
| 106651 | 106651 | 68879 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1741 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32850 | 5993705.24231741 | 2103645.69057472 | 37.7558484998294 | -122.46475661409599 | (37.7558484998294, -122.464756614096) | ||
| 129852 | 129852 | 68895 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2 Wheat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 6 | Permit Number 32867 | 6012134.32764 | 2091434.42813 | 37.723364230264394 | -122.400164870833 | (37.7233642302644, -122.400164870833) | |
| 133820 | 133820 | 68940 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 454 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 6 | Permit Number 32926 | 5989392.15436 | 2112242.86267 | 37.7792043799748 | -122.480301726508 | (37.7792043799748, -122.480301726508) | |
| 135870 | 135870 | 68953 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 750 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 3 | 3x3 | Permit Number 32942 | 5988850.38114 | 2110206.21118 | 37.7735808052559 | -122.48202668229901 | (37.7735808052559, -122.482026682299) |
| 145666 | 145666 | 68951 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 738 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32940 | 5988848.01258948 | 2110286.79093664 | 37.7738019171776 | -122.482040779575 | (37.7738019171776, -122.482040779575) | ||
| 161168 | 161168 | 68950 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 734 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 6 | Permit Number 32939 | 5988846.075 | 2110312.98983 | 37.7738737393837 | -122.482049401575 | (37.7738737393837, -122.482049401575) | |
| 165599 | 165599 | 68952 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 747 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 3 | Permit Number 32941 | 5988797.45218 | 2110217.11495 | 37.7736076654938 | -122.482210568345 | (37.7736076654938, -122.482210568345) | |
| 170838 | 170838 | 68956 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 874 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 7 | Permit Number 32945 | 5988542.5052 | 2110035.3324599997 | 37.7730937088544 | -122.483079131422 | (37.7730937088544, -122.483079131422) | |
| 108662 | 108662 | 67826 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 153 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1992 12:00:00 AM | Permit Number 31486 | 6004143.42814251 | 2102312.76348145 | 37.752784866029 | -122.428562966982 | (37.752784866029, -122.428562966982) | ||
| 124226 | 124226 | 60426 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 419 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1992 12:00:00 AM | Permit Number 31497 | 6003853.1521524 | 2098925.15717718 | 37.7434668562001 | -122.42932524738998 | (37.7434668562001, -122.42932524739) | ||
| 164091 | 164091 | 67822 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 519 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1992 12:00:00 AM | 9 | Permit Number 31478 | 6011808.7605800005 | 2105938.99653 | 37.763172512922004 | -122.402309638787 | (37.763172512922, -122.402309638787) | ||
| 9780 | 9780 | 65693 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3779 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2016 12:00:00 AM | 3 | 4x4 | Permit Number 779357 | 6005288.42845233 | 2101344.00549356 | 37.7501896116955 | -122.424534439725 | (37.7501896116955, -122.424534439725) |
| 9798 | 9798 | 32469 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 124 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779287 | 6000593.0 | 2105649.0 | 37.7617437934708 | -122.441080293978 | (37.7617437934708, -122.441080293978) | |
| 13234 | 13234 | 82735 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 174 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769757 | 6003803.82611 | 2092820.0296 | 37.726700767200896 | -122.429060604385 | (37.7267007672009, -122.429060604385) |
| 25688 | 25688 | 95116 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 67 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 54043 | 6002297.43224 | 2093241.3314 | 37.727772179934 | -122.43429826136999 | (37.727772179934, -122.43429826137) |
| 42021 | 42021 | 95125 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 91 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 54053 | 6003379.33035 | 2094579.25553 | 37.731507167824 | -122.430653552813 | (37.731507167824, -122.430653552813) |
| 58060 | 58060 | 46783 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 89 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 54062 | 6002335.14709 | 2093516.37756 | 37.7285295350115 | -122.43418753503 | (37.7285295350115, -122.43418753503) |
| 59501 | 59501 | 95117 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 83 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54044 | 6002203.8888 | 2093301.19707 | 37.7279312475122 | -122.43462592124399 | (37.7279312475122, -122.434625921244) |
| 103979 | 103979 | 95132 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 201 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54056 | 6001204.4 | 2093241.7 | 37.7277110907766 | -122.438076912641 | (37.7277110907766, -122.438076912641) | |
| 129425 | 129425 | 68081 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 201 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54056 | 6001211.28738215 | 2093268.78253612 | 37.727785844916895 | -122.438055042052 | (37.7277858449169, -122.438055042052) | |
| 170211 | 170211 | 72979 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1451 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2010 12:00:00 AM | 2 | Permit Number 54060 | 5988344.3187 | 2105426.2097 | 37.7604267896985 | -122.483426724107 | (37.7604267896985, -122.483426724107) | ||
| 174170 | 174170 | 95122 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 75 Lyell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54049 | 6003110.14823 | 2094598.2490700001 | 37.731544066089 | -122.43158552205401 | (37.731544066089, -122.431585522054) |
| 10379 | 10379 | 86560 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1887 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987821.2541 | 2102469.8936 | 37.7522790893532 | -122.48501883929899 | (37.7522790893532, -122.485018839299) | ||
| 11953 | 11953 | 86463 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1866 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987865.2759 | 2102589.5992 | 37.7526103328382 | -122.48487538787501 | (37.7526103328382, -122.484875387875) | ||
| 12591 | 12591 | 86475 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1770 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987843.9387 | 2103258.2798 | 37.7544451068579 | -122.48499822919202 | (37.7544451068579, -122.484998229192) | ||
| 25402 | 25402 | 52514 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 38699 | 38699 | 52528 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2005 12:00:00 AM | 7 | Permit Number 48628 | 6001332.37944 | 2092272.13723 | 37.725056169781205 | -122.437565081984 | (37.7250561697812, -122.437565081984) | ||
| 45219 | 45219 | 52525 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 115 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 5 | Permit Number 48625 | 6000708.298330001 | 2092511.5798799999 | 37.725678122036705 | -122.439739616589 | (37.7256781220367, -122.439739616589) | |
| 81604 | 81604 | 52515 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 83381 | 83381 | 52518 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 83932 | 83932 | 52496 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 325 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48605 | 6006702.14310168 | 2096075.5406716 | 37.7358033255144 | -122.41927203001002 | (37.7358033255144, -122.41927203001) | ||
| 85420 | 85420 | 52517 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 87318 | 87318 | 52495 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 599 Moultrie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2005 12:00:00 AM | Permit Number 48604 | 6007698.78842616 | 2096579.30794213 | 37.7372426398673 | -122.41586188802299 | (37.7372426398673, -122.415861888023) | |||
| 99540 | 99540 | 35085 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1541 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48630 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 99955 | 99955 | 62924 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 599 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48604 | 6007698.78842616 | 2096579.30794213 | 37.7372426398673 | -122.41586188802299 | (37.7372426398673, -122.415861888023) | ||
| 111902 | 111902 | 52516 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 114154 | 114154 | 52486 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 673 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48596 | 6009795.59485787 | 2098213.25445234 | 37.741846761114296 | -122.408727471584 | (37.7418467611143, -122.408727471584) | ||
| 129207 | 129207 | 52499 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 206 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48608 | 6007090.91316375 | 2097005.21766224 | 37.7383779008303 | -122.41799378080201 | (37.7383779008303, -122.417993780802) | ||
| 141213 | 141213 | 52530 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 142 San Juan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48628 | 6001389.835788901 | 2092264.63848184 | 37.725038846492794 | -122.43736592524701 | (37.7250388464928, -122.437365925247) | ||
| 145500 | 145500 | 52532 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1636@ UNION Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 5x5 | Permit Number 48631 | 6009676.39438666 | 2119273.10665206 | 37.7996655555567 | -122.410626491106 | (37.7996655555567, -122.410626491106) | |
| 78907 | 78907 | 46184 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 841 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44511 | 5997623.38792866 | 2107669.89260679 | 37.767123058720706 | -122.451496709211 | (37.7671230587207, -122.451496709211) | ||
| 87920 | 87920 | 46169 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 16 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44498 | 5996114.82184578 | 2106837.19956265 | 37.76475019571679 | -122.456654354016 | (37.7647501957168, -122.456654354016) | ||
| 96946 | 96946 | 46173 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 40 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44502 | 5996118.87311026 | 2106741.44800782 | 37.7644875191721 | -122.456633416718 | (37.7644875191721, -122.456633416718) | ||
| 102306 | 102306 | 46171 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 28 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44500 | 5996116.84747825 | 2106789.32377975 | 37.764618857431394 | -122.456643885347 | (37.7646188574314, -122.456643885347) | ||
| 105011 | 105011 | 46168 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 10 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44497 | 5996113.80902962 | 2106861.13745227 | 37.7648158648531 | -122.45665958836399 | (37.7648158648531, -122.456659588364) |
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");