trees
32 rows where Police Districts = 8 and qSpecies_id = 177
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5376 | 203267 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2 Garcia Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/08/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781591 | 5995210.8831 | 2099639.94271 | 37.7449364165845 | -122.45925958957 | (37.7449364165845, -122.45925958957) | 1 | 8 | 4 | 59 | 40 | |
| 6587 | 261546 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1955 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2020 12:00:00 AM | 3 | 3X3 | Permit Number 783144 | 5985360.77923 | 2101907.46183 | 37.750591180724 | -122.493485992107 | (37.750591180724, -122.493485992107) | 1 | 8 | 3 | 29491 | 35 | |
| 10940 | 92249 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1382 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 52698 | 5985580.0638 | 2105823.8988 | 37.7613574627672 | -122.493016162233 | (37.7613574627672, -122.493016162233) | 1 | 8 | 3 | 56 | 35 | |
| 11531 | 203268 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2 Garcia Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/08/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781591 | 5995209.06254 | 2099610.1708 | 37.7448545656781 | -122.459263729153 | (37.7448545656781, -122.459263729153) | 1 | 8 | 4 | 59 | 40 | |
| 14369 | 203266 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2 Garcia Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/08/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781591 | 5995196 | 2099610 | 37.7448533456978 | -122.459308884303 | (37.7448533456978, -122.459308884303) | 1 | 8 | 4 | 59 | 40 | |
| 20330 | 115297 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 84 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775683 | 5992506.3 | 2098571.2 | 37.7418460572185 | -122.468533715231 | (37.7418460572185, -122.468533715231) | 1 | 8 | 4 | 29491 | 40 | |||
| 35798 | 210473 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 855 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2016 12:00:00 AM | 14 | Width 3ft | Permit Number 41828 | 5993066.85825 | 2107284.57434 | 37.765803096459 | -122.467228905809 | (37.765803096459, -122.467228905809) | 11 | 8 | 11 | 56 | 12 | |
| 44103 | 115287 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1526 12th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 776185 | 5992489.2 | 2105046.7 | 37.7596251212978 | -122.469064003389 | (37.7596251212978, -122.469064003389) | 1 | 8 | 4 | 56 | 12 | |||
| 45994 | 56898 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1886 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 775792 | 5985700.55899725 | 2102390.4838018 | 37.7519372972974 | -122.492346587933 | (37.7519372972974, -122.492346587933) | 1 | 8 | 3 | 56 | 35 | |||
| 51392 | 37127 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1501 46th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | 2x2 | Permit Number 39712 | 5981856.07887628 | 2104857.97095308 | 37.7584868087664 | -122.50582403114 | (37.7584868087664, -122.50582403114) | 1 | 8 | 3 | 56 | 35 | ||
| 53752 | 121107 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1391 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 5993608 | 2106030 | 37.7623895873424 | -122.465266089176 | (37.7623895873424, -122.465266089176) | 1 | 8 | 11 | 56 | 12 | ||
| 60053 | 93574 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2998 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2010 12:00:00 AM | 3x3 | Permit Number 53727 | 5995937.7 | 2087355.5 | 37.711248045329 | -122.455858535778 | (37.711248045329, -122.455858535778) | 9 | 8 | 6 | 28861 | 24 | ||
| 66436 | 98847 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2400 Noriega St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768753 | 5986497.5 | 2103053.8 | 37.753805142535 | -122.489639464015 | (37.753805142535, -122.489639464015) | 1 | 8 | 3 | 56 | 35 | |
| 77723 | 55923 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 530 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/1973 12:00:00 AM | 3 | 3x3 | Permit Number 774578 | 5992693.0422579 | 2103919.63429657 | 37.7565422691319 | -122.468277027995 | (37.7565422691319, -122.468277027995) | 1 | 8 | 4 | 56 | 12 | |
| 77781 | 115289 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1425 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775512 | 5991747.8 | 2105705.5 | 37.7613911460485 | -122.47167612106 | (37.7613911460485, -122.47167612106) | 1 | 8 | 4 | 56 | 12 | |||
| 102162 | 216685 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 111 Ashton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/06/2017 08:11:00 AM | 3 | Width 3ft | 5994133.1609 | 2090669.87199 | 37.7202447887441 | -122.462335661261 | (37.7202447887441, -122.462335661261) | 9 | 8 | 6 | 28861 | 24 | ||
| 105519 | 97293 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2154 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2011 12:00:00 AM | 3x3 | Permit Number 768386 | 5989030.8 | 2106542.7 | 37.7635322996796 | -122.481134285356 | (37.7635322996796, -122.481134285356) | 1 | 8 | 3 | 56 | 35 | ||
| 108273 | 93575 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2998 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2010 12:00:00 AM | 3x3 | Permit Number 53727 | 5995937.7 | 2087355.5 | 37.711248045329 | -122.455858535778 | (37.711248045329, -122.455858535778) | 9 | 8 | 6 | 28861 | 24 | ||
| 109612 | 55389 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1386 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1972 12:00:00 AM | 3x3 | Permit Number 11326 | 5993364.66899649 | 2106056.80614716 | 37.762449154491 | -122.466109621957 | (37.762449154491, -122.466109621957) | 1 | 8 | 11 | 56 | 12 | ||
| 114886 | 50468 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2016 12:00:00 AM | 3 | Permit Number 778534 | 5995312.36828974 | 2100223.18422456 | 37.7465436862786 | -122.458950895655 | (37.7465436862786, -122.458950895655) | 1 | 8 | 4 | 59 | 40 | |
| 116618 | 43627 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2230 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2016 12:00:00 AM | 0 | 3x3 | Permit Number 775700 | 5985470.85834553 | 2100027.42958295 | 37.7454355618475 | -122.492966865959 | (37.7454355618475, -122.492966865959) | 1 | 8 | 3 | 29491 | 35 |
| 119291 | 93577 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2998 San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53727 | 5995937.7 | 2087355.5 | 37.711248045329 | -122.455858535778 | (37.711248045329, -122.455858535778) | 9 | 8 | 6 | 28861 | 24 | |
| 123252 | 162764 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 919 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2017 10:56:00 AM | 3 | Width 0ft | 5995008.1104 | 2090049.40289 | 37.7185914714977 | -122.459266363268 | (37.7185914714977, -122.459266363268) | 9 | 8 | 6 | 28861 | 24 | ||
| 143392 | 100949 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1561 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/2012 12:00:00 AM | 1 | Permit Number 769342 | 5982149.6 | 2104456.5 | 37.7574017552939 | -122.504779173294 | (37.7574017552939, -122.504779173294) | 1 | 8 | 3 | 56 | 35 | |
| 143629 | 98845 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2400 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768753 | 5986497.5 | 2103053.8 | 37.753805142535 | -122.489639464015 | (37.753805142535, -122.489639464015) | 1 | 8 | 3 | 56 | 35 | |
| 147693 | 121108 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1391 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 5993608 | 2106030 | 37.7623895873424 | -122.465266089176 | (37.7623895873424, -122.465266089176) | 1 | 8 | 11 | 56 | 12 | ||
| 163779 | 116372 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1306 10TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 5993057 | 2106542 | 37.7637636140689 | -122.467209006309 | (37.7637636140689, -122.467209006309) | 1 | 8 | 11 | 56 | 12 | ||||
| 166626 | 115253 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 20 Edgar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 772988 | 5997135.3 | 2090888.7 | 37.7210180538388 | -122.451974094521 | (37.7210180538388, -122.451974094521) | 9 | 8 | 6 | 28861 | 24 | |||
| 167690 | 256776 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 244 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781951 | 5994190.23703 | 2091515.08881 | 37.7225688371899 | -122.462199635944 | (37.7225688371899, -122.462199635944) | 9 | 8 | 4 | 28861 | 24 | |
| 170941 | 98846 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2400 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768753 | 5986497.5 | 2103053.8 | 37.753805142535 | -122.489639464015 | (37.753805142535, -122.489639464015) | 1 | 8 | 3 | 56 | 35 | |
| 175464 | 54377 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1454 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774580 | 5984357.5042 | 2105265.8509 | 37.7597536454069 | -122.497203224003 | (37.7597536454069, -122.497203224003) | 1 | 8 | 3 | 56 | 35 |
| 176540 | 37129 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1501 46th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | 2x2 | Permit Number 39712 | 5981856.07887628 | 2104857.97095308 | 37.7584868087664 | -122.50582403114 | (37.7584868087664, -122.50582403114) | 1 | 8 | 3 | 56 | 35 |
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) );