trees
2,694 rows where qSpecies_id = 84 sorted by PlantDate descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6906 | 48666 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1715REVISED Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2002 12:00:00 AM | 1 | Permit Number 45950 | 6004823.677 | 2115363.4456 | 37.7886573555281 | -122.427140041517 | (37.7886573555281, -122.427140041517) | 13 | 9 | 11 | 28858 | 27 | |
| 72044 | 50652 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 41 Josiah Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | Permit Number 47234 | 5996870.80130055 | 2089899.24303395 | 37.7182860829536 | -122.452817003739 | (37.7182860829536, -122.452817003739) | 9 | 8 | 6 | 28861 | 24 | |||
| 12670 | 86450 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2362 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987982.1495 | 2099214.8079 | 37.7433508614418 | -122.4842237451 | (37.7433508614418, -122.4842237451) | 1 | 8 | 3 | 29491 | 35 | ||
| 35011 | 86446 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2426 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987996.8709 | 2098757.0924 | 37.7420949525843 | -122.484139283552 | (37.7420949525843, -122.484139283552) | 1 | 8 | 3 | 29491 | 35 | ||
| 39227 | 86445 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2434 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987997.5477 | 2098724.6039 | 37.7420057871296 | -122.484134561433 | (37.7420057871296, -122.484134561433) | 1 | 8 | 3 | 29491 | 35 | ||
| 42523 | 86453 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2330 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987973.3506 | 2099428.6905 | 37.7439376142067 | -122.484269851802 | (37.7439376142067, -122.484269851802) | 1 | 8 | 3 | 29491 | 35 | ||
| 45304 | 86448 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2410 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987993.1483 | 2098903.2906 | 37.7424961575573 | -122.484162874059 | (37.7424961575573, -122.484162874059) | 1 | 8 | 3 | 29491 | 35 | ||
| 57398 | 86435 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2578 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988030.7572 | 2097759.3623 | 37.7393574208367 | -122.483948972283 | (37.7393574208367, -122.483948972283) | 1 | 8 | 3 | 29491 | 35 | ||
| 93844 | 86451 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2358 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987978.4269 | 2099245.2659 | 37.7434342743144 | -122.484238850005 | (37.7434342743144, -122.484238850005) | 1 | 8 | 3 | 29491 | 35 | ||
| 98879 | 86567 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2307 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987921.2336 | 2099575.5655 | 37.7443378593723 | -122.484460828778 | (37.7443378593723, -122.484460828778) | 1 | 8 | 3 | 29491 | 35 | ||
| 100435 | 86565 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2243 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987907.2026 | 2100032.4695 | 37.7455915795676 | -122.484542851528 | (37.7455915795676, -122.484542851528) | 1 | 8 | 3 | 29491 | 35 | ||
| 111221 | 86568 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2337 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987926.9868 | 2099392.4793 | 37.7438354881374 | -122.484427509802 | (37.7438354881374, -122.484427509802) | 1 | 8 | 3 | 29491 | 35 | ||
| 115502 | 86454 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2326 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987972.3353 | 2099456.4411 | 37.7440137508973 | -122.484275397242 | (37.7440137508973, -122.484275397242) | 1 | 8 | 3 | 29491 | 35 | ||
| 129692 | 86452 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2350 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987979.4422 | 2099298.3981 | 37.743580220411 | -122.484239235211 | (37.743580220411, -122.484239235211) | 1 | 8 | 3 | 29491 | 35 | ||
| 139761 | 86449 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2370 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987981.4727 | 2099180.2889 | 37.7432560419796 | -122.484223554257 | (37.7432560419796, -122.484223554257) | 1 | 8 | 3 | 29491 | 35 | ||
| 146666 | 86438 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2558 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988026.0275 | 2097893.3718 | 37.7397251004281 | -122.483975149426 | (37.7397251004281, -122.483975149426) | 1 | 8 | 3 | 29491 | 35 | ||
| 149689 | 86442 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2470 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988005.6699 | 2098496.5076 | 37.7413799676446 | -122.484089754678 | (37.7413799676446, -122.484089754678) | 1 | 8 | 3 | 29491 | 35 | ||
| 155873 | 86437 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2566 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988027.6041 | 2097846.7049 | 37.7395970571481 | -122.483966277165 | (37.7395970571481, -122.483966277165) | 1 | 8 | 3 | 29491 | 35 | ||
| 160836 | 86434 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2590 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988032.3338 | 2097694.7224 | 37.7391800283996 | -122.48393878255 | (37.7391800283996, -122.48393878255) | 1 | 8 | 3 | 29491 | 35 | ||
| 165460 | 86440 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2506 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988014.3608 | 2098206.7963 | 37.7405850025908 | -122.484038465173 | (37.7405850025908, -122.484038465173) | 1 | 8 | 3 | 29491 | 35 | ||
| 167442 | 86444 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2438 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988000.2551 | 2098696.1765 | 37.7419278906096 | -122.484123116004 | (37.7419278906096, -122.484123116004) | 1 | 8 | 3 | 29491 | 35 | ||
| 183145 | 86439 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2550 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988024.4509 | 2097942.8764 | 37.7398609352841 | -122.48398422975 | (37.7398609352841, -122.48398422975) | 1 | 8 | 3 | 29491 | 35 | ||
| 193554 | 86441 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2498 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988007.7004 | 2098406.8258 | 37.7411338432365 | -122.484076158984 | (37.7411338432365, -122.484076158984) | 1 | 8 | 3 | 29491 | 35 | ||
| 191637 | 68951 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 738 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32940 | 5988848.01258948 | 2110286.79093664 | 37.7738019171776 | -122.482040779575 | (37.7738019171776, -122.482040779575) | 11 | 6 | 2 | 55 | 26 | ||
| 28066 | 60426 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 419 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31497 | 6003853.1521524 | 2098925.15717718 | 37.7434668562001 | -122.42932524739 | (37.7434668562001, -122.42932524739) | 2 | 7 | 5 | 63 | 22 | ||
| 132377 | 67826 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 153 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31486 | 6004143.42814251 | 2102312.76348145 | 37.752784866029 | -122.428562966982 | (37.752784866029, -122.428562966982) | 2 | 4 | 5 | 28862 | 22 | ||
| 102298 | 95117 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 83 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54044 | 6002203.8888 | 2093301.19707 | 37.7279312475122 | -122.434625921244 | (37.7279312475122, -122.434625921244) | 9 | 7 | 6 | 28861 | 25 |
| 136710 | 46783 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 89 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 54062 | 6002335.14709 | 2093516.37756 | 37.7285295350115 | -122.43418753503 | (37.7285295350115, -122.43418753503) | 9 | 7 | 6 | 28861 | 25 |
| 142187 | 95122 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 75 Lyell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54049 | 6003110.14823 | 2094598.24907 | 37.731544066089 | -122.431585522054 | (37.731544066089, -122.431585522054) | 9 | 7 | 5 | 28861 | 25 |
| 1668 | 86560 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1887 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987821.2541 | 2102469.8936 | 37.7522790893532 | -122.485018839299 | (37.7522790893532, -122.485018839299) | 1 | 8 | 3 | 56 | 35 | ||
| 113870 | 86463 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1866 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987865.2759 | 2102589.5992 | 37.7526103328382 | -122.484875387875 | (37.7526103328382, -122.484875387875) | 1 | 8 | 3 | 56 | 35 | ||
| 143251 | 86475 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1770 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987843.9387 | 2103258.2798 | 37.7544451068579 | -122.484998229192 | (37.7544451068579, -122.484998229192) | 1 | 8 | 3 | 56 | 35 | ||
| 46931 | 52496 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 325 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48605 | 6006702.14310168 | 2096075.5406716 | 37.7358033255144 | -122.41927203001 | (37.7358033255144, -122.41927203001) | 2 | 7 | 7 | 28859 | 2 | ||
| 103859 | 35085 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1541 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48630 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 138458 | 52486 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 673 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48596 | 6009795.59485787 | 2098213.25445234 | 37.7418467611143 | -122.408727471584 | (37.7418467611143, -122.408727471584) | 10 | 7 | 7 | 28859 | 2 | ||
| 184728 | 52530 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 142 San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48628 | 6001389.8357889 | 2092264.63848184 | 37.7250388464928 | -122.437365925247 | (37.7250388464928, -122.437365925247) | 9 | 7 | 6 | 28861 | 25 | ||
| 190450 | 52532 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1636@ UNION Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 5x5 | Permit Number 48631 | 6009676.39438666 | 2119273.10665206 | 37.7996655555567 | -122.410626491106 | (37.7996655555567, -122.410626491106) | 3 | 1 | 10 | 308 | 4 | |
| 69270 | 46169 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 16 Hillway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44498 | 5996114.82184578 | 2106837.19956265 | 37.7647501957168 | -122.456654354016 | (37.7647501957168, -122.456654354016) | 15 | 5 | 11 | 29492 | 12 | ||
| 94206 | 46173 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 40 Hillway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44502 | 5996118.87311026 | 2106741.44800782 | 37.7644875191721 | -122.456633416718 | (37.7644875191721, -122.456633416718) | 15 | 5 | 11 | 29492 | 12 | ||
| 98224 | 46171 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 28 Hillway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44500 | 5996116.84747825 | 2106789.32377975 | 37.7646188574314 | -122.456643885347 | (37.7646188574314, -122.456643885347) | 15 | 5 | 11 | 29492 | 12 | ||
| 106164 | 46168 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 10 Hillway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44497 | 5996113.80902962 | 2106861.13745227 | 37.7648158648531 | -122.456659588364 | (37.7648158648531, -122.456659588364) | 15 | 5 | 11 | 29492 | 12 | ||
| 56420 | 39487 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3723 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40945 | 6004943.29101021 | 2101913.34310631 | 37.7517333836283 | -122.425768466249 | (37.7517333836283, -122.425768466249) | 2 | 4 | 5 | 28862 | 22 | ||
| 92786 | 39485 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3856 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40943 | 6004065.71023863 | 2102497.52410689 | 37.7532877768544 | -122.428844900366 | (37.7532877768544, -122.428844900366) | 2 | 4 | 5 | 28862 | 22 | ||
| 127014 | 39515 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 62 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 2 | Permit Number 40966 | 6004070.08669275 | 2102696.50176505 | 37.7538343704609 | -122.428843949963 | (37.7538343704609, -122.428843949963) | 2 | 4 | 5 | 28862 | 22 | |
| 185532 | 39516 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 62 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40966 | 6004070.08669275 | 2102696.50176505 | 37.7538343704609 | -122.428843949963 | (37.7538343704609, -122.428843949963) | 2 | 4 | 5 | 28862 | 22 | ||
| 89128 | 237999 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 4302 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2012 12:00:00 AM | 2 | Width 4ft | Permit Number 769743 | 6001218.46057 | 2101752.36044 | 37.7510801711245 | -122.438637864349 | (37.7510801711245, -122.438637864349) | 2 | 4 | 5 | 28862 | 22 | |
| 101051 | 85960 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1230 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988027.116 | 2106908.7855 | 37.764479070899 | -122.484632521312 | (37.764479070899, -122.484632521312) | 1 | 8 | 3 | 56 | 35 | ||
| 117557 | 85962 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1200 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988020.9888 | 2107061.1992 | 37.7648972002579 | -122.484664894353 | (37.7648972002579, -122.484664894353) | 1 | 8 | 3 | 56 | 35 | ||
| 166133 | 85961 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1200 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988024.0524 | 2107011.4158 | 37.7647606871244 | -122.484650646191 | (37.7647606871244, -122.484650646191) | 1 | 8 | 3 | 56 | 35 | ||
| 143531 | 52459 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 584@ BALBOA 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | 1 | Permit Number 48570 | 5992242.76591 | 2111511.40324 | 37.7773612263419 | -122.470387093473 | (37.7773612263419, -122.470387093473) | 11 | 6 | 2 | 54 | 11 | |
| 70146 | 86516 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1303 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987691.5588 | 2106373.6447 | 37.762990173852 | -122.485753827898 | (37.762990173852, -122.485753827898) | 1 | 8 | 3 | 56 | 35 | ||
| 25815 | 27759 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1099X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/25/2005 12:00:00 AM | 4 | 3x3 | 6015711.8179102 | 2101113.2850563 | 37.750139234821 | -122.388473299437 | (37.750139234821, -122.388473299437) | 10 | 3 | 8 | 58 | 1 | ||
| 114875 | 108545 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 150 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773707 | 6003013.00279 | 2094373.5586 | 37.7309216102277 | -122.431905334488 | (37.7309216102277, -122.431905334488) | 9 | 7 | 5 | 28861 | 25 |
| 20120 | 85951 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1390 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988061.1772 | 2105842.3097 | 37.7615528036389 | -122.484436487246 | (37.7615528036389, -122.484436487246) | 1 | 8 | 3 | 56 | 35 | ||
| 22876 | 86247 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2290 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988579.3157 | 2099752.9558 | 37.7448632256871 | -122.482198340398 | (37.7448632256871, -122.482198340398) | 1 | 8 | 3 | 29491 | 35 | ||
| 29911 | 85954 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1370 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988057.3894 | 2105986.2433 | 37.7619477854522 | -122.484460144927 | (37.7619477854522, -122.484460144927) | 1 | 8 | 3 | 56 | 35 | ||
| 34956 | 86246 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2292X 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988581.0227 | 2099729.0585 | 37.7447977092886 | -122.482190687534 | (37.7447977092886, -122.482190687534) | 1 | 8 | 3 | 29491 | 35 | ||
| 55891 | 85952 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1390 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988060.095 | 2105875.8581 | 37.7616448553739 | -122.484442690808 | (37.7616448553739, -122.484442690808) | 1 | 8 | 3 | 56 | 35 | ||
| 97912 | 85953 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1374 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988058.4716 | 2105953.2359 | 37.7618572191612 | -122.484453980999 | (37.7618572191612, -122.484453980999) | 1 | 8 | 3 | 56 | 35 | ||
| 99424 | 85927 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1722 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988145.2074 | 2103551.0636 | 37.7552665558176 | -122.483977844866 | (37.7552665558176, -122.483977844866) | 1 | 8 | 3 | 56 | 35 | ||
| 116858 | 86333 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2285 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988537.0686 | 2099797.3366 | 37.7449826262514 | -122.48234767234 | (37.7449826262514, -122.48234767234) | 1 | 8 | 3 | 29491 | 35 | ||
| 132080 | 85957 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1330 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988048.1907 | 2106230.822 | 37.7626187960801 | -122.484509899399 | (37.7626187960801, -122.484509899399) | 1 | 8 | 3 | 56 | 35 | ||
| 143188 | 85955 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1346 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988066.5882 | 2106122.0602 | 37.7623212372231 | -122.48443829226 | (37.7623212372231, -122.48443829226) | 1 | 8 | 3 | 56 | 35 | ||
| 143937 | 86334 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2289 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988537.4954 | 2099766.6115 | 37.7448982880571 | -122.482343945808 | (37.7448982880571, -122.482343945808) | 1 | 8 | 3 | 29491 | 35 | ||
| 185360 | 86495 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1534 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5987787.3318 | 2104833.8728 | 37.7587679608906 | -122.485309594748 | (37.7587679608906, -122.485309594748) | 1 | 8 | 3 | 56 | 35 | ||
| 4940 | 39332 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
| 5165 | 39388 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 414 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40926 | 6003200.97263054 | 2099519.74958744 | 37.7450625247242 | -122.431622760195 | (37.7450625247242, -122.431622760195) | 2 | 7 | 5 | 63 | 22 | ||
| 6169 | 39333 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
| 7788 | 39331 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
| 11366 | 53918 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
| 15516 | 39334 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
| 10332 | 86369 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1281 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5987992.2676 | 2106611.2343 | 37.7636600473858 | -122.484731221945 | (37.7636600473858, -122.484731221945) | 1 | 8 | 3 | 56 | 35 | ||
| 26901 | 86368 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1235 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5987981.928 | 2106870.8736 | 37.7643723435277 | -122.48478603092 | (37.7643723435277, -122.48478603092) | 1 | 8 | 3 | 56 | 35 | ||
| 53890 | 86372 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1309 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988000.5736 | 2106373.6733 | 37.7630082536672 | -122.484685067091 | (37.7630082536672, -122.484685067091) | 1 | 8 | 3 | 56 | 35 | ||
| 65224 | 86388 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1543 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988055.0728 | 2104801.2215 | 37.7586939032987 | -122.484381239786 | (37.7586939032987, -122.484381239786) | 1 | 8 | 3 | 56 | 35 | ||
| 67805 | 86381 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1449 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988033.2668 | 2105434.5266 | 37.7604315171283 | -122.484503105523 | (37.7604315171283, -122.484503105523) | 1 | 8 | 3 | 56 | 35 | ||
| 74078 | 86373 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1309 26th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988001.1147 | 2106356.358 | 37.7629607421046 | -122.484681925407 | (37.7629607421046, -122.484681925407) | 1 | 8 | 3 | 56 | 35 | ||
| 78881 | 86379 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1375 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988016.2656 | 2105945.6605 | 37.7618339613784 | -122.484599397348 | (37.7618339613784, -122.484599397348) | 1 | 8 | 3 | 56 | 35 | ||
| 91684 | 86374 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1327 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988004.3613 | 2106238.9386 | 37.7626385296295 | -122.484662083032 | (37.7626385296295, -122.484662083032) | 1 | 8 | 3 | 56 | 35 | ||
| 92167 | 86384 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1469 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988038.2569 | 2105288.5651 | 37.7600310371708 | -122.484475141227 | (37.7600310371708, -122.484475141227) | 1 | 8 | 3 | 56 | 35 | ||
| 99614 | 86389 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1547 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988054.2021 | 2104771.6176 | 37.7586125683242 | -122.484382079778 | (37.7586125683242, -122.484382079778) | 1 | 8 | 3 | 56 | 35 | ||
| 102507 | 86383 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1465 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988037.0094 | 2105333.0605 | 37.7601531367846 | -122.484482719343 | (37.7601531367846, -122.484482719343) | 1 | 8 | 3 | 56 | 35 | ||
| 116347 | 85885 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2594 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988342.103 | 2097683.778 | 37.7391680067391 | -122.482866951392 | (37.7391680067391, -122.482866951392) | 1 | 8 | 3 | 29491 | 35 | ||
| 126773 | 86371 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1309 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988000.0325 | 2106399.6463 | 37.7630795369037 | -122.4846888439 | (37.7630795369037, -122.4846888439) | 1 | 8 | 3 | 56 | 35 | ||
| 148574 | 86380 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1435 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988029.9401 | 2105512.7054 | 37.7606459810936 | -122.484520345328 | (37.7606459810936, -122.484520345328) | 1 | 8 | 3 | 56 | 35 | ||
| 156392 | 86382 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1453 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988035.346 | 2105390.8629 | 37.7603117495754 | -122.484492711924 | (37.7603117495754, -122.484492711924) | 1 | 8 | 3 | 56 | 35 | ||
| 169901 | 86390 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1571 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988060.297 | 2104609.2316 | 37.75816705532 | -122.484349091388 | (37.75816705532, -122.484349091388) | 1 | 8 | 3 | 56 | 35 | ||
| 187525 | 86375 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1335 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988007.6079 | 2106189.1571 | 37.7625020323163 | -122.484647202524 | (37.7625020323163, -122.484647202524) | 1 | 8 | 3 | 56 | 35 | ||
| 179537 | 86402 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1715 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2006 12:00:00 AM | 3 | 3x3 | Permit Number 775346 | 5988092.6268 | 2103602.7043 | 37.7554052860025 | -122.484163468892 | (37.7554052860025, -122.484163468892) | 1 | 8 | 3 | 56 | 35 | |
| 8197 | 65499 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1520 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/1989 12:00:00 AM | 2 | Permit Number 28383 | 5988131.2403 | 2099681.6905 | 37.7446414773793 | -122.483742458373 | (37.7446414773793, -122.483742458373) | 1 | 8 | 3 | 29491 | 35 | |
| 11410 | 25472 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 205X Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 6 | 3X3 | 5993432.494 | 2088486.2672 | 37.7142087634879 | -122.464599140586 | (37.7142087634879, -122.464599140586) | 9 | 8 | 6 | 64 | 24 | ||
| 19528 | 244063 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1670 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | Width 0ft | 5998595.6913 | 2109011.0161 | 37.7708610734694 | -122.448230254318 | (37.7708610734694, -122.448230254318) | 15 | 5 | 11 | 29492 | 9 | ||
| 116480 | 72155 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 260 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2014 12:00:00 AM | 3 | Permit Number 774096 | 6000883.46587 | 2093545.19578 | 37.7285261634496 | -122.439208128065 | (37.7285261634496, -122.439208128065) | 9 | 7 | 6 | 28861 | 25 | |
| 13724 | 85931 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1686 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988131.3934 | 2103830.0344 | 37.756031730146 | -122.484046073449 | (37.756031730146, -122.484046073449) | 1 | 8 | 3 | 56 | 35 | ||
| 25667 | 85944 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1530 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988094.8611 | 2104879.1908 | 37.7589103025977 | -122.484249353508 | (37.7589103025977, -122.484249353508) | 1 | 8 | 3 | 56 | 35 | ||
| 31548 | 85949 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1430 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988070.6928 | 2105557.2008 | 37.7607705264222 | -122.484382665437 | (37.7607705264222, -122.484382665437) | 1 | 8 | 3 | 56 | 35 | ||
| 38011 | 85932 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1666 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988126.3838 | 2103953.8446 | 37.7563713878607 | -122.484072477016 | (37.7563713878607, -122.484072477016) | 1 | 8 | 3 | 56 | 35 | ||
| 57228 | 85935 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1622 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988119.2271 | 2104230.0917 | 37.7571294710464 | -122.484117484634 | (37.7571294710464, -122.484117484634) | 1 | 8 | 3 | 56 | 35 | ||
| 60917 | 86325 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2227 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988524.6932 | 2100155.797 | 37.7459661439862 | -122.482416723532 | (37.7459661439862, -122.482416723532) | 1 | 8 | 3 | 29491 | 35 | ||
| 65600 | 86328 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2247 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988528.9606 | 2100030.7626 | 37.7456230807951 | -122.482392807934 | (37.7456230807951, -122.482392807934) | 1 | 8 | 3 | 29491 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );