Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96644 | 96644 | 40784 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 410 Monticello St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | ||
| 96815 | 96815 | 58515 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1465 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/2004 12:00:00 AM | Permit Number 30484 | 5998691.7005410995 | 2108280.83754266 | 37.76886167705071 | -122.447845581015 | (37.7688616770507, -122.447845581015) | ||
| 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) | ||
| 97529 | 97529 | 42941 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 90 14TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | 10 | Permit Number 42835 | 6008035.0 | 2107992.0 | 37.768598204141995 | -122.415507210488 | (37.768598204142, -122.415507210488) | ||
| 98066 | 98066 | 38216 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 350 Wayland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40338 | 6010576.45287423 | 2092372.10995681 | 37.7258519216371 | -122.405616192564 | (37.7258519216371, -122.405616192564) | ||
| 99110 | 99110 | 38000 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2454 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40212 | 5992064.31245936 | 2098735.51233127 | 37.742271675931896 | -122.47007391125601 | (37.7422716759319, -122.470073911256) | ||
| 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) | ||
| 99254 | 99254 | 38032 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | |||
| 99913 | 99913 | 38034 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 71 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40237 | 5993126.63617522 | 2098605.576855 | 37.7419762612493 | -122.466391311334 | (37.7419762612493, -122.466391311334) | ||
| 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) | ||
| 100543 | 100543 | 38059 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1802 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40254 | 6001102.14351194 | 2114546.50782632 | 37.786203101297396 | -122.439957367186 | (37.7862031012974, -122.439957367186) | ||
| 101438 | 101438 | 37979 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1199 Tennessee St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.756407638243296 | -122.38902089785499 | (37.7564076382433, -122.389020897855) | ||
| 101850 | 101850 | 38881 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40703 | 5996508.72142362 | 2113802.71293841 | 37.7838982845648 | -122.455795523067 | (37.7838982845648, -122.455795523067) | ||
| 102043 | 102043 | 41729 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 99X 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | ||
| 102334 | 102334 | 40175 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1779 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1999 12:00:00 AM | Permit Number 41366 | 6008032.61088554 | 2108096.47604813 | 37.7688849366199 | -122.415522872015 | (37.7688849366199, -122.415522872015) | ||
| 102562 | 102562 | 38030 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | |||
| 103072 | 103072 | 68820 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 215 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32768 | 5999394.70937931 | 2093830.63611547 | 37.729225087217294 | -122.444375326018 | (37.7292250872173, -122.444375326018) | ||
| 103731 | 103731 | 42939 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 90 14TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42835 | 6008035.0 | 2107992.0 | 37.768598204141995 | -122.415507210488 | (37.768598204142, -122.415507210488) | |||
| 103735 | 103735 | 41749 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1100 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.41252459171899 | (37.7916912386009, -122.412524591719) | ||
| 105121 | 105121 | 69026 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3826 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | Permit Number 33030 | 5981605.36463184 | 2100817.40426398 | 37.7473777946481 | -122.506391463775 | (37.7473777946481, -122.506391463775) | ||
| 106034 | 106034 | 41818 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 66 Encanto Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42204 | 6000020.46726166 | 2112594.97224476 | 37.7807830542731 | -122.44355943151699 | (37.7807830542731, -122.443559431517) | ||
| 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) | |||
| 107439 | 107439 | 37980 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1199 Tennessee St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.756407638243296 | -122.38902089785499 | (37.7564076382433, -122.389020897855) | ||
| 107754 | 107754 | 38060 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1802 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40254 | 6001102.14351194 | 2114546.50782632 | 37.786203101297396 | -122.439957367186 | (37.7862031012974, -122.439957367186) | ||
| 107845 | 107845 | 42769 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1045 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42745 | 6002868.75255453 | 2110597.66752235 | 37.7754609839703 | -122.43356305917 | (37.7754609839703, -122.43356305917) | ||
| 108435 | 108435 | 38031 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | |||
| 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) | ||
| 109001 | 109001 | 55144 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1438 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/1995 12:00:00 AM | Permit Number 11048 | 5993686.04342696 | 2105701.01392221 | 37.7614907777587 | -122.46497227391501 | (37.7614907777587, -122.464972273915) | ||
| 109498 | 109498 | 41751 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1100 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.41252459171899 | (37.7916912386009, -122.412524591719) | ||
| 111478 | 111478 | 39381 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1367 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/28/2001 12:00:00 AM | Permit Number 43822 | 6007199.57850018 | 2107537.80288531 | 37.7673040926749 | -122.418364663242 | (37.7673040926749, -122.418364663242) | ||
| 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) | |||
| 112273 | 112273 | 66617 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 537 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1994 12:00:00 AM | Permit Number 29820 | 6003370.78769204 | 2095896.23030716 | 37.7351227979483 | -122.430777034501 | (37.7351227979483, -122.430777034501) | ||
| 112909 | 112909 | 38640 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1595 Shafter Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40566 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | ||
| 113166 | 113166 | 63504 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2185 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/07/1987 12:00:00 AM | Permit Number 24108 | 5999131.28808567 | 2111466.68826776 | 37.7776343263975 | -122.44655432302099 | (37.7776343263975, -122.446554323021) | ||
| 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) | ||
| 114634 | 114634 | 38033 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1400 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40236 | 5991713.73808693 | 2098444.67646581 | 37.7414528421268 | -122.471264893104 | (37.7414528421268, -122.471264893104) | ||
| 114768 | 114768 | 42054 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 326 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42369 | 6006171.20759912 | 2101208.97418807 | 37.749868660690005 | -122.42147214171999 | (37.74986866069, -122.42147214172) | ||
| 114842 | 114842 | 41747 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1100 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.41252459171899 | (37.7916912386009, -122.412524591719) | ||
| 115738 | 115738 | 41748 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1100 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.41252459171899 | (37.7916912386009, -122.412524591719) | ||
| 115885 | 115885 | 41752 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1100 California St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.41252459171899 | (37.7916912386009, -122.412524591719) | ||
| 115944 | 115944 | 69045 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1490 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 5 | Permit Number 33052 | 5984059.2399452 | 2105030.87804217 | 37.7590909914126 | -122.498217402727 | (37.7590909914126, -122.498217402727) | |
| 116221 | 116221 | 41750 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1100 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42181 | 6009068.76416013 | 2116381.28511649 | 37.7916912386009 | -122.41252459171899 | (37.7916912386009, -122.412524591719) | ||
| 116845 | 116845 | 48626 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1648 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45923 | 5992496.87532412 | 2104233.57360814 | 37.757392932598 | -122.468978283216 | (37.757392932598, -122.468978283216) | ||
| 117400 | 117400 | 41736 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1675 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42175 | 6007516.69169836 | 2108778.794217 | 37.77072940872289 | -122.417355765748 | (37.7707294087229, -122.417355765748) | ||
| 117895 | 117895 | 40701 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 547 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | Permit Number 41680 | 6005025.18813412 | 2093548.59411277 | 37.7287703058889 | -122.424890201858 | (37.7287703058889, -122.424890201858) | ||
| 118244 | 118244 | 32863 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 369 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37210 | 6002757.72867407 | 2101496.8738153 | 37.7504661097568 | -122.433296668218 | (37.7504661097568, -122.433296668218) | ||
| 118316 | 118316 | 69032 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1306 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | Permit Number 33038 | 5984326.99960905 | 2106268.60698724 | 37.76250514437871 | -122.49738275102699 | (37.7625051443787, -122.497382751027) | ||
| 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) | |||
| 119499 | 119499 | 40199 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4845 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983584.60152 | 2111699.05511 | 37.7773720577908 | -122.500351906273 | (37.7773720577908, -122.500351906273) | |
| 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) | ||
| 120373 | 120373 | 35894 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 225 Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | Permit Number 39088 | 6010847.02207847 | 2096940.13108018 | 37.7384098714444 | -122.405002340826 | (37.7384098714444, -122.405002340826) | ||
| 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) | |||
| 121751 | 121751 | 41727 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1803 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | ||
| 122443 | 122443 | 47699 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 297 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2002 12:00:00 AM | Permit Number 45496 | 6000129.38189454 | 2094930.1458917998 | 37.732285975496104 | -122.44191439219401 | (37.7322859754961, -122.441914392194) | |||
| 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) | ||
| 122873 | 122873 | 40786 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 410 Monticello St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | ||
| 124738 | 124738 | 37419 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 557 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39897 | 6002931.14322816 | 2099749.14332352 | 37.7456770883652 | -122.432572163971 | (37.7456770883652, -122.432572163971) | ||
| 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) | |||
| 124833 | 124833 | 33056 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 328 San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37328 | 6006171.76331287 | 2101198.94449976 | 37.7498411527935 | -122.421469507825 | (37.7498411527935, -122.421469507825) | |||
| 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) | ||
| 125240 | 125240 | 37977 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1199 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.756407638243296 | -122.38902089785499 | (37.7564076382433, -122.389020897855) | ||
| 125273 | 125273 | 41593 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 538 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43228 | 6003084.80949648 | 2098934.42438565 | 37.7434487728436 | -122.431982642828 | (37.7434487728436, -122.431982642828) | ||
| 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) | |||
| 125793 | 125793 | 43585 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 237 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43246 | 6004367.379779 | 2099245.61051184 | 37.7443758465625 | -122.427570002743 | (37.7443758465625, -122.427570002743) | ||
| 126641 | 126641 | 32859 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37207 | 6000703.6978076 | 2101134.48618072 | 37.7493543400616 | -122.440373654783 | (37.7493543400616, -122.440373654783) | |||
| 126645 | 126645 | 44207 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 701 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2000 12:00:00 AM | Permit Number 43655 | 6009221.06713893 | 2115299.96241651 | 37.7887307349007 | -122.411921176175 | (37.7887307349007, -122.411921176175) | ||
| 126722 | 126722 | 34910 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 234 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1997 12:00:00 AM | Permit Number 38511 | 5994034.02525385 | 2087990.46611796 | 37.712882070912 | -122.462484089909 | (37.712882070912, -122.462484089909) | |||
| 126873 | 126873 | 41661 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1376 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 2 | Permit Number 42129 | 5999046.52257313 | 2104716.21389633 | 37.7590943881005 | -122.44636181286998 | (37.7590943881005, -122.44636181287) | |
| 128479 | 128479 | 41874 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 66 Belcher St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42253 | 6003778.26782897 | 2107952.91484982 | 37.768250702181504 | -122.430228105724 | (37.7682507021815, -122.430228105724) | ||
| 128574 | 128574 | 38029 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2490X 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40235 | 5992179.14418088 | 2098457.94829189 | 37.7415161934278 | -122.46965666006399 | (37.7415161934278, -122.469656660064) | ||
| 128723 | 128723 | 33551 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 242 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37659 | 6007042.9412775 | 2097614.40669633 | 37.740047898701604 | -122.418202822848 | (37.7400478987016, -122.418202822848) | |||
| 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) | ||
| 129131 | 129131 | 68856 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 111 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | Permit Number 32819 | 6000663.76465174 | 2094326.91833664 | 37.7306600888757 | -122.440023675014 | (37.7306600888757, -122.440023675014) | ||
| 130691 | 130691 | 30907 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2363 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 4 | Permit Number 37373 | 5987310.298054401 | 2099201.63941585 | 37.743275562979605 | -122.486545838163 | (37.7432755629796, -122.486545838163) | |
| 132831 | 132831 | 201725 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1915 Quesada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6013561.8417 | 2095888.78027 | 37.735674466103795 | -122.39554210998199 | (37.7356744661038, -122.395542109982) | ||||
| 133840 | 133840 | 44311 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 339 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2001 12:00:00 AM | 1 | Permit Number 43708 | 5998562.918 | 2115355.99866 | 37.788280875801505 | -122.44880071158899 | (37.7882808758015, -122.448800711589) | ||
| 134013 | 134013 | 43231 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1371 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 3 | Permit Number 43018 | 5989871.41437878 | 2106041.52738456 | 37.7622050471688 | -122.47819025383801 | (37.7622050471688, -122.478190253838) | |
| 135718 | 135718 | 43234 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1442 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 0 | Permit Number 43021 | 5989629.54713999 | 2105535.31198119 | 37.760801073285705 | -122.478989743073 | (37.7608010732857, -122.478989743073) | |
| 136514 | 136514 | 35869 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 Boutwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 6 | Permit Number 39080 | 6010666.93779 | 2096840.63562 | 37.7381266097475 | -122.40561798198799 | (37.7381266097475, -122.405617981988) | |
| 137254 | 137254 | 124092 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 601 Funston Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5991890.07496 | 2111196.5227799998 | 37.776476251963295 | -122.47158420369101 | (37.7764762519633, -122.471584203691) | ||||
| 137431 | 137431 | 35870 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 Boutwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 3 | Permit Number 39080 | 6010672.98165 | 2096855.55492 | 37.738167912917106 | -122.405598135739 | (37.7381679129171, -122.405598135739) | |
| 139989 | 139989 | 41876 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 66 Belcher St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42253 | 6003778.26782897 | 2107952.91484982 | 37.768250702181504 | -122.430228105724 | (37.7682507021815, -122.430228105724) | ||
| 140049 | 140049 | 38215 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 350 Wayland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40338 | 6010576.45287423 | 2092372.10995681 | 37.7258519216371 | -122.405616192564 | (37.7258519216371, -122.405616192564) | ||
| 140727 | 140727 | 38639 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1595 Shafter Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40566 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | ||
| 141016 | 141016 | 37981 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1199 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.756407638243296 | -122.38902089785499 | (37.7564076382433, -122.389020897855) | ||
| 141299 | 141299 | 63484 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2139 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | Permit Number 28328 | 5999347.56552659 | 2111497.12488065 | 37.7777302487495 | -122.44580833834 | (37.7777302487495, -122.44580833834) | ||
| 141716 | 141716 | 38638 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1595 Shafter Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40566 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | ||
| 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) | ||
| 141851 | 141851 | 32857 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37207 | 6000703.6978076 | 2101134.48618072 | 37.7493543400616 | -122.440373654783 | (37.7493543400616, -122.440373654783) | |||
| 141966 | 141966 | 69085 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1462 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33095 | 5992142.99696903 | 2105491.66018597 | 37.7608268551195 | -122.470293739312 | (37.7608268551195, -122.470293739312) | ||
| 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) | |||
| 142202 | 142202 | 70387 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 81 Lyell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 4 | 6003118.96111 | 2094567.6101799998 | 37.7314604381496 | -122.431552867694 | (37.7314604381496, -122.431552867694) | ||
| 142436 | 142436 | 32858 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37207 | 6000703.6978076 | 2101134.48618072 | 37.7493543400616 | -122.440373654783 | (37.7493543400616, -122.440373654783) | |||
| 143019 | 143019 | 52145 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 101 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2004 12:00:00 AM | 6002340.0 | 2108819.0 | 37.7705471897255 | -122.43526488371799 | (37.7705471897255, -122.435264883718) | |||
| 143280 | 143280 | 41725 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 99X 14th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42172 | 6008031.27943269 | 2107943.20653569 | 37.7684640195804 | -122.415516624702 | (37.7684640195804, -122.415516624702) | ||
| 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) | ||
| 143720 | 143720 | 42161 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2010 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42456 | 5989367.84309334 | 2111281.28093807 | 37.776562731283796 | -122.480315427669 | (37.7765627312838, -122.480315427669) | ||
| 143906 | 143906 | 37978 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1199 Tennessee St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.756407638243296 | -122.38902089785499 | (37.7564076382433, -122.389020897855) | ||
| 144305 | 144305 | 42698 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1659 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | Permit Number 45472 | 6009187.38661424 | 2118931.29098858 | 37.798699585947 | -122.412294470142 | (37.798699585947, -122.412294470142) | ||
| 144346 | 144346 | 41875 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 66 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42253 | 6003778.26782897 | 2107952.91484982 | 37.768250702181504 | -122.430228105724 | (37.7682507021815, -122.430228105724) |
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");