trees
614 rows where qSpecies_id = 29 sorted by Longitude
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 | |||||||||||||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | |
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |
| 27524 | 37977 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1199 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
| 79828 | 37976 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1199 Tennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
| 103820 | 37979 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1199 Tennessee St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
| 129710 | 37980 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1199 Tennessee St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
| 178307 | 37981 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1199 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
| 182459 | 37978 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1199 Tennessee St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.7564076382433 | -122.389020897855 | (37.7564076382433, -122.389020897855) | 10 | 3 | 8 | 28856 | 29 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |
| 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 | |
| 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 | |
| 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 | ||
| 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 | |
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 176192 | 197334 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1098 Mississippi St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 5ft | 6014199.99182 | 2102083.09836 | 37.7527182412529 | -122.393769197285 | (37.7527182412529, -122.393769197285) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | ||||
| 164027 | 35432 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1506 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | 7 | Permit Number 38878 | 6014141.49848 | 2102013.02263 | 37.7525225775725 | -122.393966574215 | (37.7525225775725, -122.393966574215) | 10 | 3 | 8 | 28856 | 29 | |
| 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 | ||||
| 40275 | 95802 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1512 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767546 | 6014097.5 | 2102025.1 | 37.7525532940671 | -122.394119575027 | (37.7525532940671, -122.394119575027) | 10 | 3 | 8 | 28856 | 29 | |
| 95948 | 197335 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1512 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6014078.36763 | 2102008.61135 | 37.7525069563416 | -122.394184584264 | (37.7525069563416, -122.394184584264) | 10 | 3 | 8 | 28856 | 29 | |||
| 5097 | 37962 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 150 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52636 | 6013967.39431 | 2106347.66255 | 37.7644148813545 | -122.394872214003 | (37.7644148813545, -122.394872214003) | 14 | 3 | 8 | 28856 | 29 | |
| 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 | ||||
| 131937 | 197336 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 651 Missouri St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6013643.57223 | 2103811.49396 | 37.757433106182 | -122.395814509232 | (37.757433106182, -122.395814509232) | 10 | 3 | 8 | 28856 | 29 | ||||
| 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 | |
| 33110 | 197353 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1750 22nd St | 13 | Side Yard : Yard | Tree | Private 2 | 4 | 6012786.799 | 2103803.61301 | 37.7573637666391 | -122.398777038841 | (37.7573637666391, -122.398777038841) | 10 | 3 | 8 | 28856 | 29 | ||||
| 23269 | 1772 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2000X Bay Shore Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012375.8565272 | 2088505.2474917 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | 10 | 7 | 8 | 309 | 39 | |||
| 125590 | 179378 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2016 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6012163.28948 | 2088075.41369 | 37.7141426692356 | -122.399829001013 | (37.7141426692356, -122.399829001013) | 10 | 7 | 8 | 309 | 39 | |||
| 12760 | 32019 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 900 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1995 12:00:00 AM | Permit Number 35412 | 6012513.40810989 | 2108571.960758 | 37.7704413522571 | -122.400057399946 | (37.7704413522571, -122.400057399946) | 14 | 2 | 8 | 28856 | 20 | |||
| 13087 | 103083 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6012579.2635 | 2114003.58062 | 37.785359006363 | -122.400211142746 | (37.785359006363, -122.400211142746) | 12 | 2 | 9 | 28855 | 6 | |||
| 98374 | 101956 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 510X Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6x6 | 6012441.7 | 2108540.8 | 37.7703517934984 | -122.400303251175 | (37.7703517934984, -122.400303251175) | 14 | 2 | 8 | 28856 | 20 | |||
| 58885 | 197342 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012547.87891 | 2113973.86639 | 37.785275667977 | -122.400317636871 | (37.785275667977, -122.400317636871) | 12 | 2 | 9 | 28855 | 6 | |||
| 132076 | 197343 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012532.19574 | 2113959.45979 | 37.7852352362655 | -122.400370883928 | (37.7852352362655, -122.400370883928) | 12 | 2 | 9 | 28855 | 6 | |||
| 27362 | 197344 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012519.57167 | 2113947.09446 | 37.7852005799736 | -122.400413690752 | (37.7852005799736, -122.400413690752) | 12 | 2 | 9 | 28855 | 6 | |||
| 165949 | 48456 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 7 | Permit Number 45824 | 6011955.48397 | 2110455.52014 | 37.7755820536976 | -122.402119714552 | (37.7755820536976, -122.402119714552) | 14 | 2 | 9 | 28853 | 34 | ||
| 21604 | 48459 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 2 | Permit Number 45824 | 6011943.63031 | 2110470.08202 | 37.7756213756527 | -122.40216174349 | (37.7756213756527, -122.40216174349) | 14 | 2 | 9 | 28853 | 34 | ||
| 49609 | 48458 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 3 | Permit Number 45824 | 6011932.18219 | 2110480.19141 | 37.7756484947135 | -122.402202056493 | (37.7756484947135, -122.402202056493) | 14 | 2 | 9 | 28853 | 34 | ||
| 72275 | 48457 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 520 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 6 | Permit Number 45824 | 6011919.3472 | 2110495.26684 | 37.7756891719521 | -122.402247516312 | (37.7756891719521, -122.402247516312) | 14 | 2 | 9 | 28853 | 34 | ||
| 131587 | 106045 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2201X 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2014 12:00:00 AM | 14 | 4x14 | Permit Number 772230 | 6011471.49227 | 2104620.16703 | 37.7595324691706 | -122.403383358282 | (37.7595324691706, -122.403383358282) | 10 | 3 | 8 | 28856 | 29 | |
| 49381 | 97195 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 390X Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2015 12:00:00 AM | 3 | Permit Number 775228 | 6011720.2 | 2118742.9 | 37.7983241100995 | -122.403516814582 | (37.7983241100995, -122.403516814582) | 3 | 1 | 10 | 308 | 23 | ||
| 53841 | 136322 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 360 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2015 12:00:00 AM | 1 | Width 5ft | 6011695.90155 | 2118747.3363 | 37.7983349338553 | -122.403601207338 | (37.7983349338553, -122.403601207338) | 3 | 1 | 10 | 308 | 23 | ||
| 106100 | 50515 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1 Ankeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | Permit Number 47153 | 6011089.84046191 | 2089620.59314796 | 37.7183255165457 | -122.403647927578 | (37.7183255165457, -122.403647927578) | 10 | 7 | 8 | 309 | 39 | ||
| 167630 | 136323 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 360 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2015 12:00:00 AM | 1 | Width 5ft | Permit Number 775228 | 6011675.19116 | 2118742.88561 | 37.7983215564568 | -122.403672558643 | (37.7983215564568, -122.403672558643) | 3 | 1 | 10 | 308 | 23 | |
| 36318 | 112537 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 412 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011527.0722 | 2118728.84616 | 37.7982747323527 | -122.404184109226 | (37.7982747323527, -122.404184109226) | 3 | 1 | 10 | 308 | 23 | |||
| 115957 | 112538 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 412 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2016 12:00:00 AM | 2 | 3x3 | 6011488.50983 | 2118723.01839 | 37.7982565759239 | -122.404317136927 | (37.7982565759239, -122.404317136927) | 3 | 1 | 10 | 308 | 23 | ||
| 193050 | 112539 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 426 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2016 11:10:00 AM | 3 | 3x3 | 6011460.82325 | 2118719.23159 | 37.7982446311281 | -122.404412674615 | (37.7982446311281, -122.404412674615) | 3 | 1 | 10 | 308 | 23 | ||
| 131847 | 112540 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 432 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011444.64707 | 2118714.34063 | 37.7982302977556 | -122.404468304876 | (37.7982302977556, -122.404468304876) | 3 | 1 | 10 | 308 | 23 | |||
| 179944 | 112532 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 435 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6011441.2715 | 2118651.07916 | 37.7980564084299 | -122.404475530047 | (37.7980564084299, -122.404475530047) | 3 | 1 | 10 | 308 | 23 | |||
| 145993 | 112531 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 435 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011430 | 2118629 | 37.7979951544919 | -122.404512977901 | (37.7979951544919, -122.404512977901) | 3 | 1 | 10 | 308 | 23 | ||||
| 49755 | 112541 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 438 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011421.73685 | 2118713.41459 | 37.798226474727 | -122.404547516275 | (37.798226474727, -122.404547516275) | 3 | 1 | 10 | 308 | 23 | |||
| 123940 | 112530 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 435 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2016 07:26:00 AM | 3 | 3x3 | 6011409.86951 | 2118646.99301 | 37.7980434339179 | -122.404583902832 | (37.7980434339179, -122.404583902832) | 3 | 1 | 10 | 308 | 23 | ||
| 5774 | 112542 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 438 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2016 12:00:00 AM | 3 | 3x3 | 6011405.06525 | 2118709.92574 | 37.7982159634572 | -122.40460495956 | (37.7982159634572, -122.40460495956) | 3 | 1 | 10 | 308 | 23 | ||
| 52120 | 136324 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 448 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011401 | 2118734 | 37.798281838344 | -122.404620722239 | (37.798281838344, -122.404620722239) | 3 | 1 | 10 | 308 | 23 | |||
| 178687 | 112543 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 448 BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011394 | 2118786 | 37.798424226523 | -122.404648607058 | (37.798424226523, -122.404648607058) | 3 | 1 | 10 | 308 | 23 | ||||
| 135679 | 136330 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 447 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6011365.83057 | 2118639.85606 | 37.7980213762507 | -122.40473578842 | (37.7980213762507, -122.40473578842) | 3 | 1 | 10 | 308 | 23 | |||
| 59848 | 112528 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 459 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011361 | 2118561 | 37.797804586609 | -122.404746949234 | (37.797804586609, -122.404746949234) | 3 | 1 | 10 | 308 | 23 | ||||
| 95401 | 112529 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 459 BROADWAY | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011361 | 2118561 | 37.797804586609 | -122.404746949234 | (37.797804586609, -122.404746949234) | 3 | 1 | 10 | 308 | 23 | ||||
| 108733 | 112527 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 459 BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011361 | 2118561 | 37.797804586609 | -122.404746949234 | (37.797804586609, -122.404746949234) | 3 | 1 | 10 | 308 | 23 | ||||
| 154166 | 136329 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 447 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6011341.08824 | 2118636.57968 | 37.7980109971731 | -122.404821173685 | (37.7980109971731, -122.404821173685) | 3 | 1 | 10 | 308 | 23 | |||
| 126649 | 136328 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 447 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6011327.03299 | 2118633.79421 | 37.7980025633245 | -122.404869612942 | (37.7980025633245, -122.404869612942) | 3 | 1 | 10 | 308 | 23 | |||
| 45998 | 112547 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 462 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011324 | 2118723 | 37.798247331278 | -122.404886391926 | (37.798247331278, -122.404886391926) | 3 | 1 | 10 | 308 | 23 | ||||
| 95613 | 112546 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 464 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3x3 | 6011322 | 2118712 | 37.7982170161506 | -122.404892537684 | (37.7982170161506, -122.404892537684) | 3 | 1 | 10 | 308 | 23 | |||
| 133154 | 136325 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 464 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011322 | 2118712 | 37.7982170161506 | -122.404892537684 | (37.7982170161506, -122.404892537684) | 3 | 1 | 10 | 308 | 23 | |||
| 115176 | 136327 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 463 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011305.85301 | 2118630.68117 | 37.7979928317715 | -122.404942682854 | (37.7979928317715, -122.404942682854) | 3 | 1 | 10 | 308 | 23 | |||
| 104544 | 112525 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 471 BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011292 | 2118586 | 37.7978693737352 | -122.404987470864 | (37.7978693737352, -122.404987470864) | 3 | 1 | 10 | 308 | 23 | ||||
| 178870 | 112526 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 471 BROADWAY | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6011292 | 2118586 | 37.7978693737352 | -122.404987470864 | (37.7978693737352, -122.404987470864) | 3 | 1 | 10 | 308 | 23 | ||||
| 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 | ||
| 65177 | 136326 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 463 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011288.49181 | 2118628.67213 | 37.79798634496 | -122.405002616378 | (37.79798634496, -122.405002616378) | 3 | 1 | 10 | 308 | 23 | |||
| 107538 | 240372 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1373 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6010906.21016 | 2101953.93145 | 37.752179988937 | -122.405150648382 | (37.752179988937, -122.405150648382) | 10 | 4 | 8 | 28859 | 19 | |||
| 169312 | 50015 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1373@ 24th ST Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/12/2005 12:00:00 AM | Permit Number 46746 | 6010905.44286633 | 2101942.7131649 | 37.7521491430994 | -122.405152511945 | (37.7521491430994, -122.405152511945) | 10 | 4 | 8 | 28859 | 19 | ||
| 62872 | 240373 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1373 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6010904.97586 | 2101974.91384 | 37.7522375329589 | -122.405156394162 | (37.7522375329589, -122.405156394162) | 10 | 4 | 8 | 28859 | 19 |
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) );