Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 82066 | 82066 | 39487 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3723 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40945 | 6004943.29101021 | 2101913.34310631 | 37.7517333836283 | -122.42576846624901 | (37.7517333836283, -122.425768466249) | ||
| 92032 | 92032 | 39485 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3856 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40943 | 6004065.71023863 | 2102497.52410689 | 37.7532877768544 | -122.428844900366 | (37.7532877768544, -122.428844900366) | ||
| 106345 | 106345 | 39515 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 62 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 2 | Permit Number 40966 | 6004070.08669275 | 2102696.50176505 | 37.75383437046089 | -122.428843949963 | (37.7538343704609, -122.428843949963) | |
| 139424 | 139424 | 39516 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 62 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40966 | 6004070.08669275 | 2102696.50176505 | 37.75383437046089 | -122.428843949963 | (37.7538343704609, -122.428843949963) | ||
| 2000 | 2000 | 237999 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4302 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 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) | |
| 11815 | 11815 | 85960 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1230 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988027.116 | 2106908.7855 | 37.764479070899 | -122.48463252131201 | (37.764479070899, -122.484632521312) | ||
| 12090 | 12090 | 85962 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988020.9888 | 2107061.1992 | 37.7648972002579 | -122.484664894353 | (37.7648972002579, -122.484664894353) | ||
| 12727 | 12727 | 85961 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988024.0524 | 2107011.4158 | 37.7647606871244 | -122.484650646191 | (37.7647606871244, -122.484650646191) | ||
| 180921 | 180921 | 52459 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 584@ BALBOA 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 1 | Permit Number 48570 | 5992242.76591 | 2111511.4032400004 | 37.777361226341895 | -122.470387093473 | (37.7773612263419, -122.470387093473) | |
| 11068 | 11068 | 86516 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1303 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987691.5588 | 2106373.6447 | 37.762990173852 | -122.48575382789801 | (37.762990173852, -122.485753827898) | ||
| 127102 | 127102 | 27759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1099X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/25/2005 12:00:00 AM | 4 | 3x3 | 6015711.817910201 | 2101113.2850563 | 37.750139234821 | -122.38847329943701 | (37.750139234821, -122.388473299437) | ||
| 12065 | 12065 | 108545 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 150 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773707 | 6003013.00279 | 2094373.5586 | 37.7309216102277 | -122.431905334488 | (37.7309216102277, -122.431905334488) |
| 10454 | 10454 | 86246 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2292X 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988581.0227 | 2099729.0585 | 37.744797709288605 | -122.48219068753401 | (37.7447977092886, -122.482190687534) | ||
| 10486 | 10486 | 86247 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2290 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988579.3157 | 2099752.9558 | 37.744863225687105 | -122.482198340398 | (37.7448632256871, -122.482198340398) | ||
| 10586 | 10586 | 85951 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1390 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988061.1772 | 2105842.3097 | 37.7615528036389 | -122.484436487246 | (37.7615528036389, -122.484436487246) | ||
| 10712 | 10712 | 85954 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1370 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988057.3894 | 2105986.2433 | 37.7619477854522 | -122.484460144927 | (37.7619477854522, -122.484460144927) | ||
| 10873 | 10873 | 85952 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1390 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988060.095 | 2105875.8581 | 37.761644855373895 | -122.484442690808 | (37.7616448553739, -122.484442690808) | ||
| 11850 | 11850 | 85953 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1374 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988058.4716 | 2105953.2359 | 37.76185721916121 | -122.48445398099899 | (37.7618572191612, -122.484453980999) | ||
| 11868 | 11868 | 85927 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1722 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988145.2074 | 2103551.0636 | 37.7552665558176 | -122.483977844866 | (37.7552665558176, -122.483977844866) | ||
| 12042 | 12042 | 85957 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1330 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988048.1907 | 2106230.8219999997 | 37.762618796080105 | -122.484509899399 | (37.7626187960801, -122.484509899399) | ||
| 12242 | 12242 | 86333 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2285 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988537.0686 | 2099797.3366 | 37.7449826262514 | -122.48234767234 | (37.7449826262514, -122.48234767234) | ||
| 12366 | 12366 | 86334 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2289 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988537.4954 | 2099766.6115 | 37.7448982880571 | -122.482343945808 | (37.7448982880571, -122.482343945808) | ||
| 12387 | 12387 | 85955 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1346 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988066.5882 | 2106122.0602 | 37.7623212372231 | -122.48443829226002 | (37.7623212372231, -122.48443829226) | ||
| 13091 | 13091 | 86495 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1534 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5987787.3318 | 2104833.8728 | 37.7587679608906 | -122.485309594748 | (37.7587679608906, -122.485309594748) | ||
| 3013 | 3013 | 39333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 5518 | 5518 | 39334 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 6740 | 6740 | 39332 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 14197 | 14197 | 39331 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 44810 | 44810 | 53918 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 55722 | 55722 | 39388 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 414 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40926 | 6003200.97263054 | 2099519.74958744 | 37.745062524724204 | -122.43162276019501 | (37.7450625247242, -122.431622760195) | ||
| 10293 | 10293 | 86369 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1281 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5987992.2676 | 2106611.2343 | 37.7636600473858 | -122.484731221945 | (37.7636600473858, -122.484731221945) | ||
| 10702 | 10702 | 86368 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1235 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5987981.927999999 | 2106870.8736 | 37.764372343527704 | -122.48478603091999 | (37.7643723435277, -122.48478603092) | ||
| 10787 | 10787 | 86372 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1309 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988000.5736 | 2106373.6733 | 37.7630082536672 | -122.48468506709101 | (37.7630082536672, -122.484685067091) | ||
| 11039 | 11039 | 86373 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1309 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988001.1147 | 2106356.358 | 37.7629607421046 | -122.484681925407 | (37.7629607421046, -122.484681925407) | ||
| 11157 | 11157 | 86388 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1543 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988055.0728 | 2104801.2215 | 37.7586939032987 | -122.48438123978599 | (37.7586939032987, -122.484381239786) | ||
| 11238 | 11238 | 86381 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1449 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988033.2668 | 2105434.5266 | 37.760431517128296 | -122.48450310552299 | (37.7604315171283, -122.484503105523) | ||
| 11398 | 11398 | 86374 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1327 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988004.3613 | 2106238.9386 | 37.762638529629506 | -122.48466208303199 | (37.7626385296295, -122.484662083032) | ||
| 11438 | 11438 | 86379 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1375 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988016.2656 | 2105945.6605 | 37.7618339613784 | -122.484599397348 | (37.7618339613784, -122.484599397348) | ||
| 11639 | 11639 | 86384 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1469 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988038.2569 | 2105288.5651 | 37.7600310371708 | -122.484475141227 | (37.7600310371708, -122.484475141227) | ||
| 11751 | 11751 | 86389 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1547 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988054.2021 | 2104771.6176 | 37.7586125683242 | -122.484382079778 | (37.7586125683242, -122.484382079778) | ||
| 11760 | 11760 | 86383 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1465 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988037.0094 | 2105333.0605 | 37.7601531367846 | -122.48448271934299 | (37.7601531367846, -122.484482719343) | ||
| 12012 | 12012 | 85885 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2594 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988342.102999999 | 2097683.778 | 37.7391680067391 | -122.482866951392 | (37.7391680067391, -122.482866951392) | ||
| 12281 | 12281 | 86371 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1309 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988000.0325 | 2106399.6463 | 37.7630795369037 | -122.48468884389999 | (37.7630795369037, -122.4846888439) | ||
| 12361 | 12361 | 86380 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1435 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988029.9401 | 2105512.7054 | 37.7606459810936 | -122.48452034532801 | (37.7606459810936, -122.484520345328) | ||
| 12728 | 12728 | 86382 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1453 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988035.346 | 2105390.8629 | 37.7603117495754 | -122.484492711924 | (37.7603117495754, -122.484492711924) | ||
| 12732 | 12732 | 86390 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1571 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988060.297 | 2104609.2316 | 37.75816705532 | -122.484349091388 | (37.75816705532, -122.484349091388) | ||
| 13165 | 13165 | 86375 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1335 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988007.6079 | 2106189.1571 | 37.7625020323163 | -122.48464720252399 | (37.7625020323163, -122.484647202524) | ||
| 13040 | 13040 | 86402 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1715 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | Permit Number 775346 | 5988092.6268 | 2103602.7043 | 37.7554052860025 | -122.484163468892 | (37.7554052860025, -122.484163468892) | |
| 12916 | 12916 | 72155 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 260 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2014 12:00:00 AM | 3 | Permit Number 774096 | 6000883.4658699995 | 2093545.19578 | 37.7285261634496 | -122.43920812806499 | (37.7285261634496, -122.439208128065) | |
| 10357 | 10357 | 85931 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1686 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988131.3934 | 2103830.0344 | 37.756031730146 | -122.48404607344901 | (37.756031730146, -122.484046073449) | ||
| 10547 | 10547 | 85949 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1430 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988070.6928 | 2105557.2008 | 37.760770526422206 | -122.484382665437 | (37.7607705264222, -122.484382665437) | ||
| 10664 | 10664 | 85932 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1666 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988126.3838 | 2103953.8446 | 37.7563713878607 | -122.48407247701599 | (37.7563713878607, -122.484072477016) | ||
| 10737 | 10737 | 85944 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1530 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988094.8611 | 2104879.1908 | 37.758910302597705 | -122.48424935350799 | (37.7589103025977, -122.484249353508) | ||
| 10828 | 10828 | 85935 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1622 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988119.2271 | 2104230.0917 | 37.7571294710464 | -122.484117484634 | (37.7571294710464, -122.484117484634) | ||
| 11120 | 11120 | 86325 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2227 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988524.6932 | 2100155.797 | 37.7459661439862 | -122.48241672353201 | (37.7459661439862, -122.482416723532) | ||
| 11145 | 11145 | 86328 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2247 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988528.9606 | 2100030.7626 | 37.7456230807951 | -122.482392807934 | (37.7456230807951, -122.482392807934) | ||
| 11444 | 11444 | 86329 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2247 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988529.8141 | 2100010.2791 | 37.7455668881622 | -122.48238835613998 | (37.7455668881622, -122.48238835614) | ||
| 11547 | 11547 | 85938 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1590 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988108.9468 | 2104468.7646 | 37.7577842036766 | -122.484170540261 | (37.7577842036766, -122.484170540261) | ||
| 11792 | 11792 | 85933 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1638 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988122.0898 | 2104149.2214 | 37.7569075897464 | -122.484101654102 | (37.7569075897464, -122.484101654102) | ||
| 11832 | 11832 | 85947 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1490 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988084.4157 | 2105183.7722 | 37.7597459921782 | -122.484307816387 | (37.7597459921782, -122.484307816387) |
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");