trees
261 rows where qSpecies_id = 177 sorted by Supervisor Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1346 | 260123 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3195X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2019 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 2551 | 256191 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
| 4868 | 256192 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
| 6907 | 108593 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 530 Moraga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774578 | ||||||||||
| 9500 | 256189 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
| 15675 | 256190 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
| 16520 | 121489 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2 Judah St | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | ||||||||||||||
| 17536 | 264654 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 999 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2020 04:51:00 PM | 3x3 | |||||||||||||
| 3302 | 256186 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
| 4989 | 256185 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
| 5804 | 253280 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2335 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007032 | 2120361 | 37.8025040230696 | -122.419854317954 | (37.8025040230696, -122.419854317954) | 5 | 1 | 1 | 28858 | 32 | ||||
| 6215 | 256187 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
| 11136 | 131782 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2646 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | Permit Number 779549 | 6000337.27442 | 2118211.39807 | 37.7962223607332 | -122.442866875924 | (37.7962223607332, -122.442866875924) | 13 | 9 | 1 | 57 | 17 | ||
| 12471 | 76775 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
| 13429 | 105011 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 11 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2013 12:00:00 AM | 5 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.7857897179877 | -122.455998396638 | (37.7857897179877, -122.455998396638) | 11 | 6 | 1 | 54 | 31 | ||
| 16011 | 131781 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2758 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2020 12:00:00 AM | 3 | Width 3ft | 5999580.2108 | 2118368.89391 | 37.7966116124855 | -122.445497792185 | (37.7966116124855, -122.445497792185) | 13 | 9 | 1 | 57 | 17 | ||
| 18862 | 256188 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
| 25056 | 105010 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 11 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2013 12:00:00 AM | 5 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.7857897179877 | -122.455998396638 | (37.7857897179877, -122.455998396638) | 11 | 6 | 1 | 54 | 31 | ||
| 31119 | 255523 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
| 38919 | 84742 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 147 Alhambra St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49255 | 6001618 | 2120311 | 37.8020602472718 | -122.438585827087 | (37.8020602472718, -122.438585827087) | 13 | 9 | 1 | 57 | 17 | ||
| 45539 | 683 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2340X Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2010 12:00:00 AM | 0 | 3X3 | Permit Number 53450 | 5988222.7193 | 2114685.44657 | 37.7858429996456 | -122.484526443804 | (37.7858429996456, -122.484526443804) | 11 | 6 | 1 | 55 | 33 | |
| 46430 | 76789 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
| 51070 | 76761 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
| 53958 | 76804 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
| 54873 | 98330 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 147 Alhambra St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49255 | 6001593.9 | 2120254.3 | 37.801903193112 | -122.438665159251 | (37.801903193112, -122.438665159251) | 13 | 9 | 1 | 57 | 17 | ||
| 57341 | 105009 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 11 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2013 12:00:00 AM | 7 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.7857897179877 | -122.455998396638 | (37.7857897179877, -122.455998396638) | 11 | 6 | 1 | 54 | 31 | ||
| 70345 | 255525 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
| 74355 | 115438 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2500X Larkin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777506 | 6006688.6 | 2119773.1 | 37.8008704472237 | -122.421000888697 | (37.8008704472237, -122.421000888697) | 5 | 9 | 1 | 28858 | 32 | ||
| 80914 | 255524 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
| 85994 | 76813 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
| 91107 | 102914 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2848 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2013 12:00:00 AM | 3x3 | Permit Number 770041 | 5999369.2 | 2118090.3 | 37.7958346193373 | -122.446207883579 | (37.7958346193373, -122.446207883579) | 13 | 9 | 1 | 57 | 17 | ||
| 91598 | 76793 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
| 102669 | 255526 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
| 106404 | 76809 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
| 120674 | 124797 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2898 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780062 | 5999308.846 | 2118065.45598 | 37.7957629573367 | -122.446414930702 | (37.7957629573367, -122.446414930702) | 13 | 9 | 1 | 57 | 17 | |
| 124246 | 1444 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 151X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2009 12:00:00 AM | 3 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | 11 | 6 | 1 | 54 | 11 | ||
| 125035 | 255253 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2178 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2018 12:00:00 AM | 3 | 3x3 | 6003537 | 2115267 | 37.7883196953611 | -122.43158486312 | (37.7883196953611, -122.43158486312) | 13 | 9 | 1 | 29490 | 27 | ||
| 133250 | 76766 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
| 154970 | 139362 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2869 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999793.3033 | 2114332.6333 | 37.7855412639984 | -122.444470219362 | (37.7855412639984, -122.444470219362) | 15 | 6 | 1 | 29490 | 31 | |||
| 156289 | 76753 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
| 158445 | 76746 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
| 170762 | 256228 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||||
| 177143 | 140885 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 112 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/04/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781739 | 5996566.0494 | 2113683.186 | 37.7835733852629 | -122.455588548359 | (37.7835733852629, -122.455588548359) | 11 | 6 | 1 | 54 | 31 | |
| 178606 | 76782 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
| 179281 | 76817 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | 3x3 | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | ||
| 181198 | 118312 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2410 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002301 | 2116562 | 37.7918052987456 | -122.435953913571 | (37.7918052987456, -122.435953913571) | 13 | 9 | 1 | 29490 | 27 | ||||
| 185355 | 76799 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
| 5642 | 13071 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 645X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 09/27/2006 12:00:00 AM | 3 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | ||
| 5671 | 13046 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 534 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x3 | 6009764.2975 | 2120561.184 | 37.8032072253646 | -122.410413314112 | (37.8032072253646, -122.410413314112) | 3 | 1 | 10 | 308 | 23 | |||
| 6110 | 13007 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 373 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 10:56:00 AM | 3 | 3x3 | 6010526.1986 | 2120617.8557 | 37.8034055135257 | -122.407780718516 | (37.8034055135257, -122.407780718516) | 3 | 1 | 10 | 308 | 23 | ||
| 8763 | 13089 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 722 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008909.0684 | 2120447.731 | 37.8028477316821 | -122.41336484235 | (37.8028477316821, -122.41336484235) | 3 | 1 | 10 | 308 | 23 | |||
| 9548 | 13006 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 383 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 10:51:00 AM | 3 | 3X3 | 6010482.094 | 2120612.9552 | 37.8033895888272 | -122.407932999148 | (37.8033895888272, -122.407932999148) | 3 | 1 | 10 | 308 | 23 | ||
| 10133 | 12999 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 349 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2017 09:03:00 AM | 3 | 3X3 | 6010644.3554 | 2120634.1907 | 37.8034569792808 | -122.407372982577 | (37.8034569792808, -122.407372982577) | 3 | 1 | 10 | 308 | 23 | ||
| 11154 | 13008 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 373 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/27/2015 10:06:00 AM | 3 | 3X3 | 6010552.8791 | 2120622.2117 | 37.8034189676022 | -122.407688696484 | (37.8034189676022, -122.407688696484) | 3 | 1 | 10 | 308 | 23 | ||
| 11709 | 13039 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 515-519 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009909.1781 | 2120541.7464 | 37.8031619752733 | -122.409910575369 | (37.8031619752733, -122.409910575369) | 3 | 1 | 10 | 308 | 23 | |||
| 13587 | 13088 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 722 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2019 06:03:00 AM | 3 | 3X3 | 6008925.6016 | 2120449.3844 | 37.8028531997518 | -122.413307745784 | (37.8028531997518, -122.413307745784) | 3 | 1 | 10 | 308 | 23 | ||
| 16151 | 13005 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 383 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 10:59:00 AM | 3 | 3X3 | 6010464.6699 | 2120611.8662 | 37.8033856231837 | -122.407993219356 | (37.8033856231837, -122.407993219356) | 3 | 1 | 10 | 308 | 23 | ||
| 16281 | 13043 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 526 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 11:51:00 AM | 3 | 3x3 | 6009812.0026 | 2120568.2515 | 37.8032293051326 | -122.410248727784 | (37.8032293051326, -122.410248727784) | 3 | 1 | 10 | 308 | 23 | ||
| 17402 | 12986 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 312 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2016 06:43:00 AM | 3 | 3X3 | 6010791.3462 | 2120702.976 | 37.8036540726688 | -122.406869163124 | (37.8036540726688, -122.406869163124) | 3 | 1 | 10 | 308 | 23 | ||
| 19019 | 13004 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 368 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2016 06:38:00 AM | 3 | 4X4 | 6010562.3418 | 2120670.5672 | 37.8035522695821 | -122.407659361785 | (37.8035522695821, -122.407659361785) | 3 | 1 | 10 | 308 | 23 | ||
| 22838 | 143258 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 661 LOMBARD ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6009397.1671 | 2120467.3833 | 37.8029290843214 | -122.411677153186 | (37.8029290843214, -122.411677153186) | 3 | 1 | 10 | 308 | 23 | |||
| 34675 | 13072 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 645X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 09/27/2008 12:00:00 AM | 3 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | ||
| 35337 | 143011 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 650-654 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2017 12:26:00 PM | 3 | Width 0ft | 6009188.4253 | 2120483.2963 | 37.8029610657241 | -122.412400635876 | (37.8029610657241, -122.412400635876) | 3 | 1 | 10 | 308 | 23 | ||
| 35355 | 13022 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 431 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:20:00 AM | 3 | 3X3 | 6010276.62799 | 2120585.425 | 37.8033024923724 | -122.408642082138 | (37.8033024923724, -122.408642082138) | 3 | 1 | 10 | 308 | 23 | ||
| 36912 | 46881 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2300@Green Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2012 12:00:00 AM | Permit Number 768822 | 6006358.85800747 | 2118685.04678939 | 37.7978643358127 | -122.422064597009 | (37.7978643358127, -122.422064597009) | 13 | 9 | 10 | 28858 | 32 | |||
| 37778 | 104607 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1839 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 3x3 | Permit Number 770939 | 6009882.8 | 2120354 | 37.8026449918113 | -122.409988596173 | (37.8026449918113, -122.409988596173) | 3 | 1 | 10 | 308 | 23 | ||
| 42180 | 114695 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 799x TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009121 | 2115613 | 37.7895846457112 | -122.412289529495 | (37.7895846457112, -122.412289529495) | 5 | 1 | 10 | 28858 | 21 | ||||
| 45752 | 143037 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 510 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/2015 07:44:00 AM | 19 | Width 0ft | 6009884.4437 | 2120577.0857 | 37.8032576219869 | -122.409998666067 | (37.8032576219869, -122.409998666067) | 3 | 1 | 10 | 308 | 23 | ||
| 48637 | 114696 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 799x TAYLOR ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009121 | 2115613 | 37.7895846457112 | -122.412289529495 | (37.7895846457112, -122.412289529495) | 5 | 1 | 10 | 28858 | 21 | ||||
| 53358 | 12988 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 324 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2016 06:56:00 AM | 3 | 3X3 | 6010748.7594 | 2120699.4941 | 37.8036421292086 | -122.407016292062 | (37.8036421292086, -122.407016292062) | 3 | 1 | 10 | 308 | 23 | ||
| 58253 | 13040 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 515-519 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 07:26:00 AM | 3 | 3X3 | 6009890.5899 | 2120540.3695 | 37.8031571528751 | -122.409974803368 | (37.8031571528751, -122.409974803368) | 3 | 1 | 10 | 308 | 23 | ||
| 61397 | 13017 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 412 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2016 12:00:00 AM | 3 | 3X3 | 6010331 | 2120658 | 37.8035048104324 | -122.408459047408 | (37.8035048104324, -122.408459047408) | 3 | 1 | 10 | 308 | 23 | ||
| 63720 | 13009 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 378 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2016 02:11:00 PM | 3 | 4X4 | 6010539.0395 | 2120665.4782 | 37.8035369920045 | -122.407739641802 | (37.8035369920045, -122.407739641802) | 3 | 1 | 10 | 308 | 23 | ||
| 68237 | 13015 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 407 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2016 12:00:00 AM | 12 | 3X3 | 6010332.686 | 2120602.2788 | 37.8033519082048 | -122.408449280112 | (37.8033519082048, -122.408449280112) | 3 | 1 | 10 | 308 | 23 | ||
| 69900 | 254752 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 701 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008942 | 2120384 | 37.8026745911634 | -122.413246372322 | (37.8026745911634, -122.413246372322) | 3 | 1 | 10 | 308 | 23 | ||||
| 70827 | 13016 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 407 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/16/2016 02:31:00 PM | 3 | 3X3 | 6010356.171 | 2120603.3463 | 37.8033561544514 | -122.408368084374 | (37.8033561544514, -122.408368084374) | 3 | 1 | 10 | 308 | 23 | ||
| 72042 | 13024 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 445 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/04/2014 02:58:00 PM | 3 | 3X3 | 6010214.1933 | 2120583.5975 | 37.8032939775537 | -122.40885801149 | (37.8032939775537, -122.40885801149) | 3 | 1 | 10 | 308 | 23 | ||
| 72976 | 13010 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 396 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:16:00 AM | 3 | 3X3 | 6010502.3453 | 2120665.4782 | 37.8035349377887 | -122.407866624342 | (37.8035349377887, -122.407866624342) | 3 | 1 | 10 | 308 | 23 | ||
| 74650 | 84929 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1500@Polk Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2007 12:00:00 AM | Permit Number 49344 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | 13 | 9 | 10 | 28858 | 32 | |||
| 76872 | 13011 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 396 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:12:00 AM | 3 | 3X3 | 6010476.6325 | 2120660.3892 | 37.8035195251148 | -122.40795524598 | (37.8035195251148, -122.40795524598) | 3 | 1 | 10 | 308 | 23 | ||
| 77866 | 13055 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 570 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2016 08:41:00 AM | 3 | 3x3 | 6009605.5749 | 2120542.0431 | 37.8031457701614 | -122.410961227909 | (37.8031457701614, -122.410961227909) | 3 | 1 | 10 | 308 | 23 | ||
| 78246 | 143041 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2000 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 780933 | 6009568.471 | 2120534.3867 | 37.8031226669303 | -122.411089086343 | (37.8031226669303, -122.411089086343) | 3 | 1 | 10 | 308 | 23 | |
| 83725 | 13075 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 645X Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/22/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774508 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | |
| 91501 | 12995 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 336 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6010707.244 | 2120695.2086 | 37.8036280390364 | -122.407159656622 | (37.8036280390364, -122.407159656622) | 3 | 1 | 10 | 308 | 23 | |||
| 93318 | 111178 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2109 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118096 | 37.7962471953974 | -122.422008397548 | (37.7962471953974, -122.422008397548) | 13 | 9 | 10 | 28858 | 32 | ||||
| 94001 | 143039 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 520 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6009841.4502 | 2120571.1962 | 37.8032390411539 | -122.410147031042 | (37.8032390411539, -122.410147031042) | 3 | 1 | 10 | 308 | 23 | |||
| 94466 | 255395 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1385 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2018 12:00:00 AM | 3 | 3x3 | 6008122.9402 | 2116875.02037 | 37.7929937885047 | -122.415832123045 | (37.7929937885047, -122.415832123045) | 5 | 1 | 10 | 28858 | 21 | ||
| 111732 | 12989 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 325 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780097 | 6010757.6116 | 2120655.4263 | 37.8035216252403 | -122.406982550515 | (37.8035216252403, -122.406982550515) | 3 | 1 | 10 | 308 | 23 | |
| 114150 | 104604 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Russell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007114.43488 | 2118959.67619 | 37.7986609851308 | -122.419469576763 | (37.7986609851308, -122.419469576763) | 5 | 1 | 10 | 28858 | 32 | ||
| 116521 | 143019 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 410 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6010368.5125 | 2120644.4743 | 37.8034697728784 | -122.408328278578 | (37.8034697728784, -122.408328278578) | 3 | 1 | 10 | 308 | 23 | |||
| 120504 | 254750 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 701 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008942 | 2120384 | 37.8026745911634 | -122.413246372322 | (37.8026745911634, -122.413246372322) | 3 | 1 | 10 | 308 | 23 | ||||
| 123811 | 13034 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 490 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/16/2016 02:07:00 PM | 3 | 3x3 | 6010037.8987 | 2120598.0598 | 37.8033238110836 | -122.409469108899 | (37.8033238110836, -122.409469108899) | 3 | 1 | 10 | 308 | 23 | ||
| 125406 | 104605 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Russell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007114.43488 | 2118959.67619 | 37.7986609851308 | -122.419469576763 | (37.7986609851308, -122.419469576763) | 5 | 1 | 10 | 28858 | 32 | ||
| 126183 | 13014 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 408 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2016 02:25:00 PM | 3 | 3X3 | 6010352 | 2120661 | 37.8035142236954 | -122.408386587386 | (37.8035142236954, -122.408386587386) | 3 | 1 | 10 | 308 | 23 | ||
| 128647 | 255530 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 301 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6010757.6116 | 2120655.4263 | 37.8035216252403 | -122.406982550515 | (37.8035216252403, -122.406982550515) | 3 | 1 | 10 | 308 | 23 | ||||
| 128671 | 13042 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 515-519 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 07:23:00 AM | 3 | 3x3 | 6009844.8077 | 2120534.1734 | 37.8031375739168 | -122.410132796901 | (37.8031375739168, -122.410132796901) | 3 | 1 | 10 | 308 | 23 | ||
| 128713 | 255394 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1385 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2018 12:00:00 AM | 3 | 3x3 | 6008122.9402 | 2116875.02037 | 37.7929937885047 | -122.415832123045 | (37.7929937885047, -122.415832123045) | 5 | 1 | 10 | 28858 | 21 | ||
| 137875 | 13025 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 451 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2016 07:02:00 AM | 3 | 3X3 | 6010198.7145 | 2120581.4625 | 37.8032872483458 | -122.40891142592 | (37.8032872483458, -122.40891142592) | 3 | 1 | 10 | 308 | 23 | ||
| 138508 | 13083 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 660 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 11:06:00 AM | 3 | 3X3 | 6009215.12 | 2120489.4566 | 37.8029794783612 | -122.412308693696 | (37.8029794783612, -122.412308693696) | 3 | 1 | 10 | 308 | 23 | ||
| 154814 | 13082 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 650 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2016 10:37:00 AM | 3 | 3x3 | 6009219.60633 | 2120572.31429 | 37.8032072366716 | -122.412299028441 | (37.8032072366716, -122.412299028441) | 3 | 1 | 10 | 308 | 23 |
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) );