Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 167372 | 167372 | 40008 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 950 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 8 | Permit Number 41261 | 6018990.20826 | 2094681.6711099998 | 37.7326604269313 | -122.376690235261 | (37.7326604269313, -122.376690235261) | |
| 105619 | 105619 | 11343 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1300X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/1999 12:00:00 AM | 16 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.730677746775605 | -122.382320962891 | (37.7306777467756, -122.382320962891) | ||
| 64837 | 64837 | 40044 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1322 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 1 | Permit Number 41281 | 6016731.9607 | 2093562.0843 | 37.729461643225704 | -122.384419676567 | (37.7294616432257, -122.384419676567) | |
| 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) | |
| 92893 | 92893 | 37976 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1199 Tennessee St | 5 | 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 73278 | 73278 | 113422 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1583 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11 | 3x3 | 6015014.3399 | 2094064.2928 | 37.7307454784064 | -122.390392783554 | (37.7307454784064, -122.390392783554) | ||
| 111749 | 111749 | 113423 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1583 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6015002.21794725 | 2094078.95124561 | 37.730785055109294 | -122.39043571521799 | (37.7307850551093, -122.390435715218) | |||
| 159694 | 159694 | 39695 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1583 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | 7 | Permit Number 41080 | 6014997.8516 | 2094075.2851 | 37.730774746396 | -122.390450554434 | (37.730774746396, -122.390450554434) | |
| 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) | |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 96051 | 96051 | 40031 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1656 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41273 | 6014957.20136248 | 2095924.63791994 | 37.7358504391775 | -122.390720277971 | (37.7358504391775, -122.390720277971) | ||
| 86331 | 86331 | 40032 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1660 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41274 | 6014934.45622927 | 2095941.56583888 | 37.7358956578297 | -122.390800100159 | (37.7358956578297, -122.390800100159) | ||
| 50125 | 50125 | 35432 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1506 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | 7 | Permit Number 38878 | 6014141.4984800005 | 2102013.02263 | 37.7525225775725 | -122.39396657421499 | (37.7525225775725, -122.393966574215) | |
| 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) | |
| 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) | |
| 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) | |
| 53789 | 53789 | 32019 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 900 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | Permit Number 35412 | 6012513.40810989 | 2108571.960758 | 37.7704413522571 | -122.40005739994601 | (37.7704413522571, -122.400057399946) | |||
| 147458 | 147458 | 48456 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 520 06th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 7 | Permit Number 45824 | 6011955.4839699995 | 2110455.52014 | 37.7755820536976 | -122.402119714552 | (37.7755820536976, -122.402119714552) | ||
| 148570 | 148570 | 48459 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 520 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 2 | Permit Number 45824 | 6011943.63031 | 2110470.08202 | 37.775621375652705 | -122.40216174348998 | (37.7756213756527, -122.40216174349) | ||
| 174499 | 174499 | 48458 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 520 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 3 | Permit Number 45824 | 6011932.18219 | 2110480.19141 | 37.7756484947135 | -122.402202056493 | (37.7756484947135, -122.402202056493) | ||
| 25889 | 25889 | 48457 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 520 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 6 | Permit Number 45824 | 6011919.3472 | 2110495.26684 | 37.7756891719521 | -122.402247516312 | (37.7756891719521, -122.402247516312) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 83910 | 83910 | 38217 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 350 Wayland St | 1 | 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 11876 | 11876 | 38200 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 514 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 12 | 3x3 | Permit Number 45184 | 6010449.69037 | 2092207.2371 | 37.7253921259422 | -122.406042793857 | (37.7253921259422, -122.406042793857) |
| 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) |
| 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) | |
| 81988 | 81988 | 69511 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 457 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | Permit Number 33638 | 6008927.18415449 | 2096207.51304953 | 37.736290754505 | -122.41158848323201 | (37.736290754505, -122.411588483232) | ||
| 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) | ||
| 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) | ||
| 84199 | 84199 | 41743 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1100 California St | 6 | 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) | ||
| 89590 | 89590 | 41744 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1100 California St | 10 | 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) | ||
| 89826 | 89826 | 41746 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1100 California St | 7 | 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 145501 | 145501 | 41745 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1100 California St | 9 | 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 44130 | 44130 | 41755 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1630 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 5 | Permit Number 42184 | 6008378.01882 | 2118113.9596 | 37.79640994672071 | -122.415037267971 | (37.7964099467207, -122.415037267971) | ||
| 187730 | 187730 | 41756 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1630 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 9 | Permit Number 42184 | 6008372.67518 | 2118139.66101 | 37.7964802161469 | -122.41505757827 | (37.7964802161469, -122.41505757827) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 144874 | 144874 | 41728 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 99X 14th St | 2 | 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) | ||
| 145443 | 145443 | 41726 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 99X 14th 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) | ||
| 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) | ||
| 147065 | 147065 | 32517 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 837 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | 5 | Permit Number 39421 | 6007583.92915 | 2095468.81341 | 37.734187007231796 | -122.41618038453998 | (37.7341870072318, -122.41618038454) | |
| 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) | |||
| 60527 | 60527 | 32523 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 861 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 8 | Permit Number 37025 | 6007568.6691 | 2095324.89508 | 37.7337909808565 | -122.416222953925 | (37.7337909808565, -122.416222953925) | |
| 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) | |
| 183550 | 183550 | 32520 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 848 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 6 | Permit Number 37022 | 6007545.9989 | 2095398.0670900003 | 37.7339906204551 | -122.416306512649 | (37.7339906204551, -122.416306512649) | |
| 68843 | 68843 | 32524 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 862 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 4 | Permit Number 37026 | 6007537.57048 | 2095302.13495 | 37.733726737790796 | -122.416328859904 | (37.7337267377908, -122.416328859904) | |
| 172002 | 172002 | 42677 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1097 Green St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42702 | 6007869.31291 | 2118866.9514599997 | 37.7984488752774 | -122.41685087859301 | (37.7984488752774, -122.416850878593) | ||
| 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) | |
| 185123 | 185123 | 42676 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1097 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42702 | 6007858.06857 | 2118865.16486 | 37.7984433372469 | -122.41688966093399 | (37.7984433372469, -122.416889660934) | ||
| 186937 | 186937 | 42675 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1097 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42702 | 6007843.31475 | 2118863.44983 | 37.7984377983088 | -122.416940592258 | (37.7984377983088, -122.416940592258) | ||
| 162768 | 162768 | 42678 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1097 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 8 | Permit Number 42702 | 6007821.24509 | 2118860.5405 | 37.7984285685682 | -122.417016754032 | (37.7984285685682, -122.417016754032) | |
| 15769 | 15769 | 30659 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 54 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 34592 | 6007591.74325 | 2109572.72569 | 37.7729135790239 | -122.41715242667 | (37.7729135790239, -122.41715242667) |
| 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) | ||
| 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) | |||
| 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) | ||
| 92257 | 92257 | 33453 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 343 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37554 | 6006165.48085512 | 2098035.43238588 | 37.7411545114342 | -122.421266615711 | (37.7411545114342, -122.421266615711) | |||
| 77489 | 77489 | 33057 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 328 San Jose Ave | 2 | 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 79480 | 79480 | 41761 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1320-1360 Lombard St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041.0 | 2120044.0 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | ||
| 84205 | 84205 | 41767 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1320-1360 Lombard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041.0 | 2120044.0 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | ||
| 88994 | 88994 | 41759 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1320-1360 Lombard St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041.0 | 2120044.0 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | ||
| 98293 | 98293 | 41763 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1320-1360 Lombard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041.0 | 2120044.0 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | ||
| 102200 | 102200 | 41764 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1320-1360 Lombard St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041.0 | 2120044.0 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | ||
| 118895 | 118895 | 41760 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1320-1360 Lombard St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041.0 | 2120044.0 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | ||
| 122474 | 122474 | 41765 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1320-1360 Lombard St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041.0 | 2120044.0 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | ||
| 128204 | 128204 | 41769 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1320-1360 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041.0 | 2120044.0 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | ||
| 139215 | 139215 | 41768 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1320-1360 Lombard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041.0 | 2120044.0 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | ||
| 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) |
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");