Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1152 | 1152 | 240384 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 65 Hermann St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779910 | 6004983.769180001 | 2108813.08838 | 37.7706807377627 | -122.426119636009 | (37.7706807377627, -122.426119636009) | |
| 128904 | 128904 | 33058 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 328 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2016 12:00:00 AM | 3 | Permit Number 779143 | 6006171.76331287 | 2101198.94449976 | 37.7498411527935 | -122.421469507825 | (37.7498411527935, -122.421469507825) | ||
| 9846 | 9846 | 41266 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2929 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779089 | 6002905.04785 | 2118704.6759200003 | 37.7977228301084 | -122.434017142274 | (37.7977228301084, -122.434017142274) | ||
| 141720 | 141720 | 42953 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2490X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2016 12:00:00 AM | 3 | Permit Number 778307 | 6000770.46048888 | 2116827.23264279 | 37.792446492390205 | -122.441268603286 | (37.7924464923902, -122.441268603286) | ||
| 113228 | 113228 | 46365 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4529 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2016 12:00:00 AM | 3 | Permit Number 777876 | 6000886.82649096 | 2105194.29533435 | 37.7605120176306 | -122.44003146279199 | (37.7605120176306, -122.440031462792) | ||
| 48290 | 48290 | 67377 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 841 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2015 12:00:00 AM | 1 | Permit Number 776566 | 5992946.95858 | 2111357.65552 | 37.776979766827104 | -122.467939896695 | (37.7769797668271, -122.467939896695) | |
| 84367 | 84367 | 97195 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 390X Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2015 12:00:00 AM | 3 | Permit Number 775228 | 6011720.2 | 2118742.9 | 37.7983241100995 | -122.403516814582 | (37.7983241100995, -122.403516814582) | ||
| 7100 | 7100 | 106210 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 585X Bush St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774310 | 6010773.37918 | 2115862.1930299997 | 37.7903614528559 | -122.406590009715 | (37.7903614528559, -122.406590009715) | |
| 144007 | 144007 | 105432 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 341 WALLER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2014 12:00:00 AM | 20 | 3x3 | Permit Number 772598 | 6004076.5 | 2108982.1 | 37.7710934821162 | -122.42926994718799 | (37.7710934821162, -122.429269947188) | |
| 14808 | 14808 | 106045 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2201X 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2014 12:00:00 AM | 14 | 4x14 | Permit Number 772230 | 6011471.492269999 | 2104620.16703 | 37.7595324691706 | -122.403383358282 | (37.7595324691706, -122.403383358282) | |
| 115972 | 115972 | 74680 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 493 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2013 12:00:00 AM | 3x3 | Permit Number 769961 | 6011188.26118785 | 2118621.30079081 | 37.79796050165611 | -122.405348925503 | (37.7979605016561, -122.405348925503) | ||
| 106194 | 106194 | 102595 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 133 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769795 | 6000714.8 | 2094523.9 | 37.7312038601891 | -122.439861356334 | (37.7312038601891, -122.439861356334) |
| 87056 | 87056 | 102078 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 35 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769728 | 6005184.6 | 2096720.6 | 37.737488929995706 | -122.42456464703699 | (37.7374889299957, -122.424564647037) |
| 83362 | 83362 | 63013 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 51 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767771 | 6007430.33105591 | 2097971.50142259 | 37.7410501993506 | -122.416888678035 | (37.7410501993506, -122.416888678035) | |
| 90176 | 90176 | 38637 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1595 Shafter Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2010 12:00:00 AM | 3x3 | Permit Number 767658 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | |
| 119285 | 119285 | 38636 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1595 Shafter Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767658 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | |
| 124237 | 124237 | 38635 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1595 Shafter Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 33 | Permit Number 767658 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | |
| 147943 | 147943 | 95925 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 467 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767622 | 5988731.71404 | 2112146.6899 | 37.7789019165926 | -122.482579385158 | (37.7789019165926, -122.482579385158) |
| 81218 | 81218 | 95802 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1512 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767546 | 6014097.5 | 2102025.1 | 37.7525532940671 | -122.394119575027 | (37.7525532940671, -122.394119575027) | |
| 93817 | 93817 | 35102 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 778 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767512 | 6001912.66160072 | 2089308.81779253 | 37.716952534231794 | -122.435347237927 | (37.7169525342318, -122.435347237927) | |
| 33870 | 33870 | 95740 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 61 Ina Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767486 | 6004943.22126 | 2091523.89765 | 37.7232063048111 | -122.42502956775499 | (37.7232063048111, -122.425029567755) |
| 41315 | 41315 | 95661 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 231 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767423 | 6010393.1108800005 | 2093567.05478 | 37.7291227359169 | -122.406334153496 | (37.7291227359169, -122.406334153496) |
| 122311 | 122311 | 95106 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 134 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54035 | 6003118.7 | 2094425.3 | 37.731069671805294 | -122.43154361449699 | (37.7310696718053, -122.431543614497) | |
| 150597 | 150597 | 94725 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 79 Manzanita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53859 | 5997862.3449099995 | 2114019.18294 | 37.7845702460701 | -122.451128124682 | (37.7845702460701, -122.451128124682) |
| 89712 | 89712 | 47995 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2594 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53833 | 5991772.56459051 | 2097785.68925868 | 37.739646833729 | -122.471013497633 | (37.739646833729, -122.471013497633) | |
| 118955 | 118955 | 47994 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2594 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53833 | 5991772.56459051 | 2097785.68925868 | 37.739646833729 | -122.471013497633 | (37.739646833729, -122.471013497633) | |
| 105918 | 105918 | 94658 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53796 | 6000765.0 | 2094447.0 | 37.73099556799129 | -122.43968229537701 | (37.7309955679913, -122.439682295377) |
| 129190 | 129190 | 94659 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53796 | 6000765.0 | 2094447.0 | 37.73099556799129 | -122.43968229537701 | (37.7309955679913, -122.439682295377) |
| 83275 | 83275 | 94656 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 118 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53795 | 6000765.0 | 2094410.0 | 37.7308939745429 | -122.439679643784 | (37.7308939745429, -122.439679643784) |
| 97280 | 97280 | 94657 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 118 Baden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53795 | 6000765.0 | 2094410.0 | 37.7308939745429 | -122.439679643784 | (37.7308939745429, -122.439679643784) |
| 110717 | 110717 | 93721 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1434 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2010 12:00:00 AM | 3x3 | Permit Number 53312 | 5992899.8 | 2097399.6 | 37.73865186152071 | -122.467087971441 | (37.7386518615207, -122.467087971441) | ||
| 143761 | 143761 | 93722 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1434 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2010 12:00:00 AM | 3x3 | Permit Number 53312 | 5992899.8 | 2097399.6 | 37.73865186152071 | -122.467087971441 | (37.7386518615207, -122.467087971441) | ||
| 47422 | 47422 | 37962 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52636 | 6013967.394309999 | 2106347.66255 | 37.7644148813545 | -122.39487221400299 | (37.7644148813545, -122.394872214003) | |
| 84564 | 84564 | 82884 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 398 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52426 | 6008893.02169344 | 2108709.50255899 | 37.770616489827106 | -122.412590100264 | (37.7706164898271, -122.412590100264) | ||
| 95116 | 95116 | 82767 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 398 11th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52426 | 6008893.02169344 | 2108709.50255899 | 37.770616489827106 | -122.412590100264 | (37.7706164898271, -122.412590100264) | ||
| 58725 | 58725 | 82802 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 770 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52410 | 5983565.30013547 | 2110567.26400669 | 37.7742633542941 | -122.500334977362 | (37.7742633542941, -122.500334977362) | ||
| 108701 | 108701 | 72276 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 770 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52410 | 5983565.30013547 | 2110567.26400669 | 37.7742633542941 | -122.500334977362 | (37.7742633542941, -122.500334977362) | ||
| 63135 | 63135 | 82850 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1457 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52367 | 6015981.5985 | 2094038.4652 | 37.730728169212 | -122.387046987845 | (37.730728169212, -122.387046987845) | |
| 48473 | 48473 | 92109 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 654 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52365 | 5981669.51861 | 2111284.19832 | 37.7761203861627 | -122.506945906937 | (37.7761203861627, -122.506945906937) | |
| 35987 | 35987 | 51788 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 339 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52292 | 6012718.572319999 | 2094804.9461700001 | 37.7326515416146 | -122.39838161323 | (37.7326515416146, -122.39838161323) | |
| 107370 | 107370 | 67614 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1257 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52284 | 6005831.35096236 | 2120311.65664048 | 37.8023008263457 | -122.42400565450001 | (37.8023008263457, -122.4240056545) | |
| 90205 | 90205 | 67457 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 709 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52276 | 6002046.91633096 | 2110893.18552424 | 37.7762257387634 | -122.43642713667299 | (37.7762257387634, -122.436427136673) | ||
| 157979 | 157979 | 89252 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 433 34th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2008 12:00:00 AM | 4 | 4x4 | Permit Number 51885 | 5985288.27991 | 2112944.4922700003 | 37.780891524599 | -122.49455024837 | (37.780891524599, -122.49455024837) | ||
| 26602 | 26602 | 89200 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3236 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51816 | 5999879.096940001 | 2119719.87548 | 37.8003381062886 | -122.444560730091 | (37.8003381062886, -122.444560730091) | |
| 82920 | 82920 | 89199 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3236 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51816 | 5999889.0 | 2119639.0 | 37.8001166089052 | -122.444520645891 | (37.8001166089052, -122.444520645891) | ||
| 146176 | 146176 | 89014 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2147 Mason St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2008 12:00:00 AM | 3X3 | Permit Number 51763 | 6008963.0 | 2120596.0 | 37.803257869178 | -122.41318870136499 | (37.803257869178, -122.413188701365) | |||
| 102768 | 102768 | 88618 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1815 Taraval St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51591 | 5987609.0 | 2098941.0 | 37.7425773238376 | -122.485493894781 | (37.7425773238376, -122.485493894781) | ||
| 10245 | 10245 | 43062 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 490 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 51464 | 5985348.18764 | 2112571.6735099996 | 37.779871377757296 | -122.49431551232401 | (37.7798713777573, -122.494315512324) | |
| 113170 | 113170 | 88439 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 837 Moultrie St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2008 12:00:00 AM | 3x3 | Permit Number 51403 | 6007580.0 | 2095463.0 | 37.7341708239465 | -122.416193557304 | (37.7341708239465, -122.416193557304) | |||
| 119575 | 119575 | 88274 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4440 23rd St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51264 | 6000402.0 | 2102285.0 | 37.7524961905728 | -122.441499478589 | (37.7524961905728, -122.441499478589) | |||
| 92053 | 92053 | 88271 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 142 Belvedere St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51257 | 5998321.8 | 2107947.7 | 37.7679258166536 | -122.449101033169 | (37.7679258166536, -122.449101033169) | |||
| 86666 | 86666 | 88224 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1821 Hayes St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51220 | 5999142.0 | 2110084.0 | 37.7738384306008 | -122.446417770519 | (37.7738384306008, -122.446417770519) | |||
| 111517 | 111517 | 88222 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1650 Fulton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51218 | 5999862.0 | 2110923.0 | 37.7761832078575 | -122.44398747698999 | (37.7761832078575, -122.44398747699) | |||
| 91660 | 91660 | 87934 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3600 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50956 | 5982309.0 | 2100840.0 | 37.7474812377595 | -122.503960055968 | (37.7474812377595, -122.503960055968) | ||
| 98152 | 98152 | 87936 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3600 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50956 | 5982309.0 | 2100840.0 | 37.7474812377595 | -122.503960055968 | (37.7474812377595, -122.503960055968) | ||
| 141514 | 141514 | 87935 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3600 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50956 | 5982309.0 | 2100840.0 | 37.7474812377595 | -122.503960055968 | (37.7474812377595, -122.503960055968) | ||
| 114349 | 114349 | 87933 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3110 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50954 | 6001440.0 | 2119068.0 | 37.7986371703342 | -122.439112652204 | (37.7986371703342, -122.439112652204) | ||
| 160691 | 160691 | 81886 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 44 Toledo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50856 | 6001667.32434 | 2120063.59572 | 37.801383746212295 | -122.43839740632299 | (37.8013837462123, -122.438397406323) | |
| 155541 | 155541 | 87877 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 32 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50849 | 6001971.5755 | 2119984.5657599997 | 37.8011840517703 | -122.43733890158998 | (37.8011840517703, -122.43733890159) | |
| 36032 | 36032 | 84615 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 26 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50848 | 6001974.9488 | 2119960.7519900003 | 37.8011188571965 | -122.437325522376 | (37.8011188571965, -122.437325522376) | |
| 73689 | 73689 | 87871 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2335 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50842 | 6000134.07181 | 2119870.32478 | 37.8007657456038 | -122.44368923307199 | (37.8007657456038, -122.443689233072) | |
| 51677 | 51677 | 81327 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3236 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50837 | 5999881.46394 | 2119701.75031 | 37.8002884744792 | -122.444551235949 | (37.8002884744792, -122.444551235949) | |
| 87149 | 87149 | 87870 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3236 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50837 | 5999889.0 | 2119639.0 | 37.8001166089052 | -122.444520645891 | (37.8001166089052, -122.444520645891) | ||
| 120461 | 120461 | 49313 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 208 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2008 12:00:00 AM | 3x3 | Permit Number 50720 | 6000587.68924836 | 2102248.75330141 | 37.7524072430871 | -122.440854735618 | (37.7524072430871, -122.440854735618) | ||
| 65292 | 65292 | 87805 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 21 Mallorca Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50570 | 6001886.8 | 2119949.6 | 37.8010832252731 | -122.437629755692 | (37.8010832252731, -122.437629755692) | |||
| 127644 | 127644 | 87804 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1953 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50568 | 6004841.0 | 2117073.0 | 37.7933523405685 | -122.427201927622 | (37.7933523405685, -122.427201927622) | ||
| 172891 | 172891 | 51254 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 258 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50492 | 6005094.58295 | 2093781.1160400002 | 37.7294126791284 | -122.42466683341699 | (37.7294126791284, -122.424666833417) | |
| 116144 | 116144 | 87465 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 485 Scott St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2008 12:00:00 AM | 3x3 | Permit Number 50381 | 6002157.0 | 2110126.0 | 37.77412549340271 | -122.43599141878201 | (37.7741254934027, -122.435991418782) | |||
| 183050 | 183050 | 69147 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2474 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50209 | 5983357.92346724 | 2098305.86052221 | 37.7405848112735 | -122.50014569422399 | (37.7405848112735, -122.500145694224) | |
| 128890 | 128890 | 83492 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2040 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 3x3 | Permit Number 50186 | 5981220.21812771 | 2101179.004699 | 37.748347964766396 | -122.50775007916 | (37.7483479647664, -122.50775007916) | ||
| 106143 | 106143 | 87075 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 395 Byxbee St | 6 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 111937 | 111937 | 87074 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 395 Byxbee St | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 93181 | 93181 | 86997 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 248 Day St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2007 12:00:00 AM | 3x3 | Permit Number 49939 | 6004323.0 | 2098701.0 | 37.742877960826604 | -122.42768466378 | (37.7428779608266, -122.42768466378) | ||
| 120057 | 120057 | 42682 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1646 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49825 | 5999927.74605546 | 2110588.07160314 | 37.7752673299483 | -122.443735976936 | (37.7752673299483, -122.443735976936) | |
| 40556 | 40556 | 32518 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 842 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/23/2007 12:00:00 AM | 9 | Permit Number 49664 | 6007548.7449 | 2095423.3131 | 37.7340600948986 | -122.41629880637 | (37.7340600948986, -122.41629880637) | |
| 121149 | 121149 | 84942 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1315 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2007 12:00:00 AM | Permit Number 49348 | 5993891.7 | 2106504.6 | 37.7637090714706 | -122.46431934241699 | (37.7637090714706, -122.464319342417) | |||
| 125174 | 125174 | 53143 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1498@ KEITH Underwood Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49074 | 6015150.01654287 | 2093336.52012549 | 37.7287546860169 | -122.389872907792 | (37.7287546860169, -122.389872907792) | ||
| 10851 | 10851 | 52794 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1277TEHAMA Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48833 | ||||||||
| 10980 | 10980 | 52793 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1277TEHAMA Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48833 | ||||||||
| 13065 | 13065 | 52792 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1277TEHAMA Houston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48833 | ||||||||
| 46879 | 46879 | 52639 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1634 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2006 12:00:00 AM | 3 | Permit Number 48720 | 5981612.27437325 | 2103952.63979264 | 37.7559866741692 | -122.506600058306 | (37.7559866741692, -122.506600058306) | |
| 82699 | 82699 | 89314 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2005 12:00:00 AM | 3x3 | Permit Number 48328 | 6002340.0 | 2108819.0 | 37.7705471897255 | -122.43526488371799 | (37.7705471897255, -122.435264883718) | ||
| 55875 | 55875 | 61446 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 167 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2005 12:00:00 AM | 4 | Permit Number 48286 | 5989582.2838 | 2114261.13607 | 37.7847570404878 | -122.479791723267 | (37.7847570404878, -122.479791723267) | |
| 142043 | 142043 | 51741 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 700 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2005 12:00:00 AM | Permit Number 48018 | 6007951.80914494 | 2095656.00646211 | 37.73472167706821 | -122.414921747465 | (37.7347216770682, -122.414921747465) | |||
| 120381 | 120381 | 51632 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 246 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2005 12:00:00 AM | 2.5x2.5 | Permit Number 47922 | 5999017.47730743 | 2106744.44536788 | 37.7646617464886 | -122.446608191655 | (37.7646617464886, -122.446608191655) | ||
| 143527 | 143527 | 42777 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 65 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | Permit Number 47615 | 6004966.00219495 | 2108807.30598956 | 37.7706638565131 | -122.42618068058701 | (37.7706638565131, -122.426180680587) | ||
| 88341 | 88341 | 50562 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2365 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2003 12:00:00 AM | Permit Number 47184 | 5998950.78977652 | 2112707.00584702 | 37.7810296062885 | -122.44726801598401 | (37.7810296062885, -122.447268015984) | |||
| 146312 | 146312 | 50561 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2365 O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2003 12:00:00 AM | Permit Number 47184 | 5998950.78977652 | 2112707.00584702 | 37.7810296062885 | -122.44726801598401 | (37.7810296062885, -122.447268015984) | |||
| 99989 | 99989 | 50515 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 Ankeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | Permit Number 47153 | 6011089.84046191 | 2089620.59314796 | 37.718325516545704 | -122.40364792757799 | (37.7183255165457, -122.403647927578) | ||
| 122450 | 122450 | 50015 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1373@ 24th ST Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | Permit Number 46746 | 6010905.44286633 | 2101942.7131649 | 37.7521491430994 | -122.405152511945 | (37.7521491430994, -122.405152511945) | ||
| 97169 | 97169 | 49152 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2464 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2003 12:00:00 AM | Permit Number 46274 | 5991742.04430079 | 2098660.96480908 | 37.7420483520093 | -122.47118277506901 | (37.7420483520093, -122.471182775069) | ||
| 119931 | 119931 | 48966 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3812 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2002 12:00:00 AM | Permit Number 46153 | 6004374.04152602 | 2101934.0957424 | 37.751758180996 | -122.427738485742 | (37.751758180996, -122.427738485742) | ||
| 108862 | 108862 | 48965 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4287 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2002 12:00:00 AM | Permit Number 46152 | 6001312.92675412 | 2102294.38376547 | 37.7525738106184 | -122.438350019053 | (37.7525738106184, -122.438350019053) | ||
| 84570 | 84570 | 48905 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2200X Clay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.790896187279394 | -122.42927158905898 | (37.7908961872794, -122.429271589059) | |||
| 93326 | 93326 | 48906 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2200X Clay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.790896187279394 | -122.42927158905898 | (37.7908961872794, -122.429271589059) | |||
| 95600 | 95600 | 48903 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2200X Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.790896187279394 | -122.42927158905898 | (37.7908961872794, -122.429271589059) | |||
| 119135 | 119135 | 48908 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2200X Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.790896187279394 | -122.42927158905898 | (37.7908961872794, -122.429271589059) | |||
| 124832 | 124832 | 48907 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2200X Clay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.790896187279394 | -122.42927158905898 | (37.7908961872794, -122.429271589059) | |||
| 125715 | 125715 | 48904 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2200X Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | Permit Number 46105 | 6004224.6625681 | 2116191.17070072 | 37.790896187279394 | -122.42927158905898 | (37.7908961872794, -122.429271589059) | |||
| 99237 | 99237 | 48566 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 638 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | Permit Number 45985 | 5993535.88564574 | 2090091.48019383 | 37.7186222534444 | -122.464358255955 | (37.7186222534444, -122.464358255955) |
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");