trees
614 rows where qSpecies_id = 29 sorted by Neighborhoods (old)
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2794 | 254529 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 421 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/2018 12:00:00 AM | 3 | 3x3 | Permit Number 769845 | ||||||||||
4016 | 52794 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
5667 | 52792 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
11431 | 35742 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1998 12:00:00 AM | Permit Number 39016 | ||||||||||||||
13707 | 35743 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1998 12:00:00 AM | Permit Number 39016 | ||||||||||||||
13860 | 52793 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1277TEHAMA Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48833 | |||||||||||||
6470 | 78275 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Pomona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6014137.61661 | 2094337.23888 | 37.7314462603177 | -122.393442871089 | (37.7314462603177, -122.393442871089) | 10 | 3 | 8 | 58 | 1 | |||
13609 | 200054 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1800 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6014879.1353 | 2094151.956 | 37.7309786828797 | -122.39086633517 | (37.7309786828797, -122.39086633517) | 10 | 3 | 8 | 58 | 1 | |||
16909 | 38635 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1595 Shafter Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 33 | Permit Number 767658 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | 10 | 3 | 8 | 58 | 1 | |
31760 | 53143 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1498@ KEITH Underwood Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | Permit Number 49074 | 6015150.01654287 | 2093336.52012549 | 37.7287546860169 | -122.389872907792 | (37.7287546860169, -122.389872907792) | 10 | 3 | 8 | 58 | 1 | ||
35846 | 113422 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1583 Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 3x3 | 6015014.3399 | 2094064.2928 | 37.7307454784064 | -122.390392783554 | (37.7307454784064, -122.390392783554) | 10 | 3 | 8 | 58 | 1 | ||
58083 | 201725 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1915 Quesada Ave | 1 | Front Yard : Yard | Tree | Private 2 | 2 | 6013561.8417 | 2095888.78027 | 37.7356744661038 | -122.395542109982 | (37.7356744661038, -122.395542109982) | 10 | 3 | 8 | 58 | 1 | ||||
58114 | 197341 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 696 Amador St | 3 | Front Yard : Yard | Tree | Private 2 | 21 | 6016796.90554 | 2099573.89089 | 37.745972446388 | -122.384613749949 | (37.745972446388, -122.384613749949) | 10 | 3 | 8 | 58 | 1 | ||||
65254 | 40032 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1660 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | Permit Number 41274 | 6014934.45622927 | 2095941.56583888 | 37.7358956578297 | -122.390800100159 | (37.7358956578297, -122.390800100159) | 10 | 3 | 8 | 58 | 1 | ||
68406 | 38637 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1595 Shafter Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2010 12:00:00 AM | 3x3 | Permit Number 767658 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | 10 | 3 | 8 | 58 | 1 | |
70662 | 35869 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1 Boutwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 6 | Permit Number 39080 | 6010666.93779 | 2096840.63562 | 37.7381266097475 | -122.405617981988 | (37.7381266097475, -122.405617981988) | 10 | 3 | 8 | 58 | 1 | |
80778 | 200055 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1800 Lane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014871.4407 | 2094140.9637 | 37.7309480732984 | -122.390892168964 | (37.7309480732984, -122.390892168964) | 10 | 3 | 8 | 58 | 1 | |||
89232 | 40031 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1656 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | Permit Number 41273 | 6014957.20136248 | 2095924.63791994 | 37.7358504391775 | -122.390720277971 | (37.7358504391775, -122.390720277971) | 10 | 3 | 8 | 58 | 1 | ||
105507 | 197339 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 696 Amador St | 1 | Front Yard : Yard | Tree | Private 2 | 24 | 6016827.1128 | 2099574.92506 | 37.7459769564893 | -122.384509368331 | (37.7459769564893, -122.384509368331) | 10 | 3 | 8 | 58 | 1 | ||||
108080 | 39695 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1583 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | 7 | Permit Number 41080 | 6014997.8516 | 2094075.2851 | 37.730774746396 | -122.390450554434 | (37.730774746396, -122.390450554434) | 10 | 3 | 8 | 58 | 1 | |
109155 | 11347 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1300X Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/06/1997 12:00:00 AM | 18 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.7306777467756 | -122.382320962891 | (37.7306777467756, -122.382320962891) | 10 | 3 | 8 | 58 | 1 | ||
110849 | 200056 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1800 Lane St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014859.3493 | 2094125.5746 | 37.7309051470181 | -122.390932896146 | (37.7309051470181, -122.390932896146) | 10 | 3 | 8 | 58 | 1 | |||
113452 | 197332 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1501 25th St | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6014163.86905 | 2101969.79141 | 37.7524051171259 | -122.393886186499 | (37.7524051171259, -122.393886186499) | 10 | 3 | 8 | 28856 | 1 | ||||
113635 | 200057 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1898x Lane St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014825.8229 | 2094079.4071 | 37.7307765200208 | -122.39104557774 | (37.7307765200208, -122.39104557774) | 10 | 3 | 8 | 58 | 1 | |||
115420 | 197351 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1240 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017537.11653 | 2093985.50569 | 37.7306687649511 | -122.381665582497 | (37.7306687649511, -122.381665582497) | 10 | 3 | 8 | 58 | 1 | |||
117908 | 106008 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1800X Lane St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6014836.2656 | 2094091.4986 | 37.7308103003106 | -122.391010320168 | (37.7308103003106, -122.391010320168) | 10 | 3 | 8 | 58 | 1 | |||
126929 | 199669 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1903 Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015195.1623 | 2093397.888 | 37.7289256934462 | -122.389721119206 | (37.7289256934462, -122.389721119206) | 10 | 3 | 8 | 58 | 1 | |||
131333 | 40044 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1322 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 1 | Permit Number 41281 | 6016731.9607 | 2093562.0843 | 37.7294616432257 | -122.384419676567 | (37.7294616432257, -122.384419676567) | 10 | 3 | 8 | 58 | 1 | |
132444 | 11343 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1300X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/1999 12:00:00 AM | 16 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.7306777467756 | -122.382320962891 | (37.7306777467756, -122.382320962891) | 10 | 3 | 8 | 58 | 1 | ||
138428 | 38640 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1595 Shafter Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1998 12:00:00 AM | Permit Number 40566 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | 10 | 3 | 8 | 58 | 1 | ||
140053 | 113423 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1583 Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6015002.21794725 | 2094078.95124561 | 37.7307850551093 | -122.390435715218 | (37.7307850551093, -122.390435715218) | 10 | 3 | 8 | 58 | 1 | |||
141336 | 40008 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 950 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 8 | Permit Number 41261 | 6018990.20826 | 2094681.67111 | 37.7326604269313 | -122.376690235261 | (37.7326604269313, -122.376690235261) | 10 | 3 | 8 | 58 | 1 | |
147145 | 51788 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 339 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52292 | 6012718.57232 | 2094804.94617 | 37.7326515416146 | -122.39838161323 | (37.7326515416146, -122.39838161323) | 10 | 3 | 8 | 58 | 1 | |
147638 | 197338 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 501 Amador St | 9 | : | Tree | Private 2 | 4 | Width 4ft | 6017587.31479 | 2099538.4559 | 37.7459188288093 | -122.381878129198 | (37.7459188288093, -122.381878129198) | 10 | 3 | 8 | 58 | 1 | |||
147911 | 197331 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1501 25th St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6014124.12337 | 2101967.77095 | 37.752397360459 | -122.394023493212 | (37.752397360459, -122.394023493212) | 10 | 3 | 8 | 28856 | 1 | ||||
156224 | 197340 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 696 Amador St | 2 | Front Yard : Yard | Tree | Private 2 | 18 | 6016813.36643 | 2099575.53369 | 37.7459778674902 | -122.384556944272 | (37.7459778674902, -122.384556944272) | 10 | 3 | 8 | 58 | 1 | ||||
157185 | 197337 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 501 Amador St | 8 | : | Tree | Private 2 | 5 | Width 4ft | 6017571.01278 | 2099537.71438 | 37.7459158925037 | -122.381934448315 | (37.7459158925037, -122.381934448315) | 10 | 3 | 8 | 58 | 1 | |||
157437 | 38636 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1595 Shafter Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767658 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | 10 | 3 | 8 | 58 | 1 | |
162786 | 35894 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 225 Industrial St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | Permit Number 39088 | 6010847.02207847 | 2096940.13108018 | 37.7384098714444 | -122.405002340826 | (37.7384098714444, -122.405002340826) | 10 | 3 | 8 | 58 | 1 | ||
171084 | 38639 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1595 Shafter Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1998 12:00:00 AM | Permit Number 40566 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | 10 | 3 | 8 | 58 | 1 | ||
174268 | 35870 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1 Boutwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 3 | Permit Number 39080 | 6010672.98165 | 2096855.55492 | 37.7381679129171 | -122.405598135739 | (37.7381679129171, -122.405598135739) | 10 | 3 | 8 | 58 | 1 | |
174273 | 197352 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1240 Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017442.65456 | 2093993.31463 | 37.7306849905143 | -122.381992698304 | (37.7306849905143, -122.381992698304) | 10 | 3 | 8 | 58 | 1 | |||
176087 | 82850 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1457 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52367 | 6015981.5985 | 2094038.4652 | 37.730728169212 | -122.387046987845 | (37.730728169212, -122.387046987845) | 10 | 3 | 8 | 58 | 1 | |
187632 | 197333 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1501 25th St | 22 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6014202.14844 | 2101967.42619 | 37.7524007500093 | -122.393753643523 | (37.7524007500093, -122.393753643523) | 10 | 3 | 8 | 28856 | 1 | ||||
188192 | 38638 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1595 Shafter Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1998 12:00:00 AM | Permit Number 40566 | 6014940.81298911 | 2094124.48881728 | 37.7309066855794 | -122.390651184611 | (37.7309066855794, -122.390651184611) | 10 | 3 | 8 | 58 | 1 | ||
33474 | 10670 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1045 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002868.6063491 | 2110598.6567928 | 37.7754636919659 | -122.433563635643 | (37.7754636919659, -122.433563635643) | 15 | 5 | 11 | 29492 | 10 | |||
70554 | 240383 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004954.4402 | 2108809.15318 | 37.7706682749432 | -122.426220805247 | (37.7706682749432, -122.426220805247) | 7 | 9 | 5 | 28852 | 10 | |||
75848 | 67457 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 709 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52276 | 6002046.91633096 | 2110893.18552424 | 37.7762257387634 | -122.436427136673 | (37.7762257387634, -122.436427136673) | 15 | 5 | 11 | 29492 | 10 | ||
81719 | 8100 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 765 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/1998 12:00:00 AM | 6 | 3X3 | 6004193.95704 | 2111472.64562 | 37.7779385589247 | -122.429041260431 | (37.7779385589247, -122.429041260431) | 7 | 9 | 11 | 28852 | 10 | ||
100804 | 8103 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 775 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/1998 12:00:00 AM | 8 | 3X3 | 6004110.63243 | 2111457.69852 | 37.7778928009026 | -122.429328443516 | (37.7778928009026, -122.429328443516) | 7 | 9 | 11 | 28852 | 10 | ||
126144 | 141346 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 463 BRODERICK ST | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 6001145.1037 | 2110334.7664 | 37.7746411763171 | -122.439506706044 | (37.7746411763171, -122.439506706044) | 15 | 5 | 11 | 29492 | 10 | |||
126377 | 142182 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1400 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6001064.3503 | 2110400.0934 | 37.7748159516075 | -122.439790732155 | (37.7748159516075, -122.439790732155) | 15 | 5 | 11 | 29492 | 10 | |||
132250 | 42769 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1045 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42745 | 6002868.75255453 | 2110597.66752235 | 37.7754609839703 | -122.43356305917 | (37.7754609839703, -122.43356305917) | 15 | 5 | 11 | 29492 | 10 | ||
138272 | 87465 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 485 Scott St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2008 12:00:00 AM | 3x3 | Permit Number 50381 | 6002157 | 2110126 | 37.7741254934027 | -122.435991418782 | (37.7741254934027, -122.435991418782) | 15 | 5 | 11 | 29492 | 10 | |||
157935 | 240384 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779910 | 6004983.76918 | 2108813.08838 | 37.7706807377627 | -122.426119636009 | (37.7706807377627, -122.426119636009) | 7 | 9 | 5 | 28852 | 10 | |
178523 | 105432 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 341 WALLER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2014 12:00:00 AM | 20 | 3x3 | Permit Number 772598 | 6004076.5 | 2108982.1 | 37.7710934821162 | -122.429269947188 | (37.7710934821162, -122.429269947188) | 7 | 9 | 11 | 29492 | 10 | |
187305 | 42777 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47615 | 6004966.00219495 | 2108807.30598956 | 37.7706638565131 | -122.426180680587 | (37.7706638565131, -122.426180680587) | 7 | 9 | 5 | 28852 | 10 | ||
1858 | 124541 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992474.53157 | 2111331.5451 | 37.7768807822685 | -122.46957225145 | (37.7768807822685, -122.46957225145) | 11 | 6 | 2 | 54 | 11 | |||
3428 | 37647 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992426.792 | 2111328.0458 | 37.7768684149352 | -122.469737140808 | (37.7768684149352, -122.469737140808) | 11 | 6 | 2 | 54 | 11 | ||
23748 | 124092 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 601 Funston Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5991890.07496 | 2111196.52278 | 37.7764762519633 | -122.471584203691 | (37.7764762519633, -122.471584203691) | 11 | 6 | 2 | 54 | 11 | ||||
27785 | 31973 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 100 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 5 | Permit Number 35372 | 5995224.68838 | 2114814.58842 | 37.7866028473263 | -122.460311111336 | (37.7866028473263, -122.460311111336) | 11 | 6 | 1 | 54 | 11 | |
55692 | 67377 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 841 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2015 12:00:00 AM | 1 | Permit Number 776566 | 5992946.95858 | 2111357.65552 | 37.7769797668271 | -122.467939896695 | (37.7769797668271, -122.467939896695) | 11 | 6 | 2 | 54 | 11 | |
80392 | 124542 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992469.9646 | 2111331.12947 | 37.776879377114 | -122.46958801958 | (37.776879377114, -122.46958801958) | 11 | 6 | 2 | 54 | 11 | |||
81683 | 124546 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992441.4203 | 2111328.77742 | 37.7768712692618 | -122.469686590816 | (37.7768712692618, -122.469686590816) | 11 | 6 | 2 | 54 | 11 | |||
96775 | 124545 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992450.31032 | 2111329.62958 | 37.776874122883 | -122.46965589987 | (37.776874122883, -122.46965589987) | 11 | 6 | 2 | 54 | 11 | |||
108009 | 31972 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 100 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 5 | Permit Number 35372 | 5995228.46958 | 2114784.79077 | 37.786521248531 | -122.460295869647 | (37.786521248531, -122.460295869647) | 11 | 6 | 1 | 54 | 11 | |
109657 | 124543 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992464.59444 | 2111330.54171 | 37.7768774529142 | -122.469606553628 | (37.7768774529142, -122.469606553628) | 11 | 6 | 2 | 54 | 11 | |||
119572 | 31971 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 100 02nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 9 | Permit Number 35372 | 5995225.90281 | 2114852.20624 | 37.786706205556 | -122.46030963631 | (37.786706205556, -122.46030963631) | 11 | 6 | 1 | 54 | 11 | |
122245 | 124544 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992459.19305 | 2111330.13563 | 37.7768760257506 | -122.469625208938 | (37.7768760257506, -122.469625208938) | 11 | 6 | 2 | 54 | 11 | |||
161194 | 37646 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992418.62314 | 2111328.39102 | 37.7768688906569 | -122.469765424254 | (37.7768688906569, -122.469765424254) | 11 | 6 | 2 | 54 | 11 | ||
184026 | 37648 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1001 Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40060 | 5992433.05565 | 2111328.08721 | 37.7768688906692 | -122.469715476155 | (37.7768688906692, -122.469715476155) | 11 | 6 | 2 | 54 | 11 | ||
31150 | 214014 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1462 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992138.11746 | 2105483.85764 | 37.7608051492715 | -122.47031004699 | (37.7608051492715, -122.47031004699) | 1 | 8 | 4 | 56 | 12 | |||
36465 | 214012 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1479 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992097.04207 | 2105377.93896 | 37.7605119495939 | -122.47044439309 | (37.7605119495939, -122.47044439309) | 1 | 8 | 4 | 56 | 12 | |||
62258 | 214017 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1438 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993685.58433 | 2105688.82171 | 37.7614572746516 | -122.464972976223 | (37.7614572746516, -122.464972976223) | 1 | 8 | 11 | 56 | 12 | |||
80073 | 214015 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1326 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5992108.78084 | 2106403.01661 | 37.763327220596 | -122.470478452218 | (37.763327220596, -122.470478452218) | 1 | 8 | 11 | 56 | 12 | |||
89860 | 207052 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1266 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5993336.08558 | 2106823.92199 | 37.7645538041289 | -122.466264232709 | (37.7645538041289, -122.466264232709) | 11 | 8 | 11 | 56 | 12 | |||
90134 | 214016 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1310 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992104.55451 | 2106488.09353 | 37.7635605748926 | -122.470499266141 | (37.7635605748926, -122.470499266141) | 1 | 8 | 11 | 56 | 12 | |||
97661 | 214013 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1483 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5992099.86454 | 2105356.08672 | 37.7604521122998 | -122.470433040059 | (37.7604521122998, -122.470433040059) | 1 | 8 | 4 | 56 | 12 | |||
126211 | 55144 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1438 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1995 12:00:00 AM | Permit Number 11048 | 5993686.04342696 | 2105701.01392221 | 37.7614907777587 | -122.464972273915 | (37.7614907777587, -122.464972273915) | 1 | 8 | 11 | 56 | 12 | ||
157303 | 48626 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1648 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45923 | 5992496.87532412 | 2104233.57360814 | 37.757392932598 | -122.468978283216 | (37.757392932598, -122.468978283216) | 1 | 8 | 4 | 56 | 12 | ||
165801 | 207053 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1266 09th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5993333.09346 | 2106842.13123 | 37.7646036292737 | -122.466275905005 | (37.7646036292737, -122.466275905005) | 11 | 8 | 11 | 56 | 12 | |||
166076 | 84942 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1315 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2007 12:00:00 AM | Permit Number 49348 | 5993891.7 | 2106504.6 | 37.7637090714706 | -122.464319342417 | (37.7637090714706, -122.464319342417) | 1 | 8 | 11 | 56 | 12 | |||
177757 | 69085 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1462 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33095 | 5992142.99696903 | 2105491.66018597 | 37.7608268551195 | -122.470293739312 | (37.7608268551195, -122.470293739312) | 1 | 8 | 4 | 56 | 12 | ||
185992 | 207054 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1266 09th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5993334.80991 | 2106859.56975 | 37.7646516098981 | -122.466271235742 | (37.7646516098981, -122.466271235742) | 11 | 8 | 11 | 56 | 12 | |||
45935 | 7243 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1929X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002956.0424065 | 2114080.0912444 | 37.7850277993699 | -122.433510025097 | (37.7850277993699, -122.433510025097) | 13 | 9 | 11 | 29490 | 13 | |||
51 | 137691 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2175 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2020 12:00:00 AM | 3 | Width 0ft | 5999187.5809 | 2111472.1809 | 37.7776526229954 | -122.44635998308 | (37.7776526229954, -122.44635998308) | 15 | 5 | 11 | 54 | 16 | ||
12537 | 54837 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 131 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1972 12:00:00 AM | 8 | Permit Number 10691 | 5998715.81827648 | 2110282.46474316 | 37.7743590132093 | -122.447906287477 | (37.7743590132093, -122.447906287477) | 15 | 5 | 11 | 29492 | 16 | |
20954 | 137686 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2143 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999343.9567 | 2111495.7816 | 37.7777263543907 | -122.445820725833 | (37.7777263543907, -122.445820725833) | 15 | 5 | 11 | 54 | 16 | |||
55616 | 140094 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1652 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999863.0392 | 2110926.6558 | 37.7761933050322 | -122.44398414486 | (37.7761933050322, -122.44398414486) | 15 | 5 | 11 | 29492 | 16 | |||
68740 | 50562 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2365 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2003 12:00:00 AM | Permit Number 47184 | 5998950.78977652 | 2112707.00584702 | 37.7810296062885 | -122.447268015984 | (37.7810296062885, -122.447268015984) | 15 | 5 | 1 | 54 | 16 | |||
69919 | 88224 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1821 Hayes St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51220 | 5999142 | 2110084 | 37.7738384306008 | -122.446417770519 | (37.7738384306008, -122.446417770519) | 15 | 5 | 11 | 29492 | 16 | |||
132061 | 41818 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 66 Encanto Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42204 | 6000020.46726166 | 2112594.97224476 | 37.7807830542731 | -122.443559431517 | (37.7807830542731, -122.443559431517) | 15 | 5 | 1 | 29490 | 16 | ||
137095 | 63504 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2185 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/07/1987 12:00:00 AM | Permit Number 24108 | 5999131.28808567 | 2111466.68826776 | 37.7776343263975 | -122.446554323021 | (37.7776343263975, -122.446554323021) | 15 | 5 | 11 | 54 | 16 | ||
144974 | 63485 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2159 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/07/1987 12:00:00 AM | 6 | Permit Number 24080 | 5999253.53185357 | 2111483.89157027 | 37.7776885439579 | -122.446132679753 | (37.7776885439579, -122.446132679753) | 15 | 5 | 11 | 54 | 16 | |
148702 | 88222 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1650 Fulton St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51218 | 5999862 | 2110923 | 37.7761832078575 | -122.44398747699 | (37.7761832078575, -122.44398747699) | 15 | 5 | 11 | 29492 | 16 | |||
175401 | 42682 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1646 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49825 | 5999927.74605546 | 2110588.07160314 | 37.7752673299483 | -122.443735976936 | (37.7752673299483, -122.443735976936) | 15 | 5 | 11 | 29492 | 16 | |
179927 | 63484 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2139 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1989 12:00:00 AM | Permit Number 28328 | 5999347.56552659 | 2111497.12488065 | 37.7777302487495 | -122.44580833834 | (37.7777302487495, -122.44580833834) | 15 | 5 | 11 | 54 | 16 | ||
191792 | 50561 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 2365 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2003 12:00:00 AM | Permit Number 47184 | 5998950.78977652 | 2112707.00584702 | 37.7810296062885 | -122.447268015984 | (37.7810296062885, -122.447268015984) | 15 | 5 | 1 | 54 | 16 | |||
8281 | 87805 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 21 Mallorca Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50570 | 6001886.8 | 2119949.6 | 37.8010832252731 | -122.437629755692 | (37.8010832252731, -122.437629755692) | 13 | 9 | 1 | 57 | 17 | |||
10754 | 41218 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 21 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 5 | Permit Number 41926 | 6001937.22199 | 2119965.3728 | 37.8011293999489 | -122.43745640431 | (37.8011293999489, -122.43745640431) | 13 | 9 | 1 | 57 | 17 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );