trees
15 rows where Police Districts = 4 and qSpecies_id = 177
This data as json, CSV (advanced)
These facets timed out: Police Districts
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5224 | 229828 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1456 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2020 12:00:00 AM | 3 | 3x3 | 6010092.99129 | 2100772.65012 | 37.7488909550714 | -122.407879605175 | (37.7488909550714, -122.407879605175) | 2 | 4 | 7 | 28859 | 19 | ||
| 7066 | 115194 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 4150 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 777365 | 6002684.1 | 2104186.2 | 37.7578461817613 | -122.433743471638 | (37.7578461817613, -122.433743471638) | 2 | 4 | 5 | 28862 | 3 | |||
| 10237 | 243286 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 552 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 4x5 | 6005074.488 | 2107832.11687 | 37.7679923530051 | -122.425736005029 | (37.7679923530051, -122.425736005029) | 8 | 4 | 5 | 28853 | 19 | ||
| 42853 | 113802 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 806 SHOTWELL ST | 4 | Front Yard : Yard | Tree | Private 2 | 6007931 | 2103220 | 37.755489548438 | -122.415529041662 | (37.755489548438, -122.415529041662) | 2 | 4 | 7 | 28859 | 19 | |||||
| 58624 | 58070 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 4530 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/1977 12:00:00 AM | 2 | 6x9 | Permit Number 17040 | 6000943.54601309 | 2105249.62912473 | 37.7606671794335 | -122.439839263811 | (37.7606671794335, -122.439839263811) | 15 | 4 | 5 | 28862 | 3 | |
| 66864 | 117270 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 481 JERSEY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6002050 | 2101440 | 37.7502697725383 | -122.435739974128 | (37.7502697725383, -122.435739974128) | 2 | 4 | 5 | 28862 | 22 | |||
| 108474 | 63786 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 4035 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2009 12:00:00 AM | 3x3 | Permit Number 52930 | 6003624.27213054 | 2101252.89355661 | 37.7498453184987 | -122.43028269297 | (37.7498453184987, -122.43028269297) | 2 | 4 | 5 | 28862 | 22 | ||
| 114910 | 102005 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1703 CASTRO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776283 | 6002624 | 2100623.7 | 37.7480609930318 | -122.433696712327 | (37.7480609930318, -122.433696712327) | 2 | 4 | 5 | 63 | 22 | |
| 129328 | 92913 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 87 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2009 12:00:00 AM | 3 | 6x12 | Permit Number 53113 | 6005252.7 | 2107310.7 | 37.7665707358936 | -122.425082484344 | (37.7665707358936, -122.425082484344) | 8 | 4 | 5 | 28853 | 19 | |
| 141100 | 55048 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3791 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2012 12:00:00 AM | Permit Number 768924 | 6003127.14535424 | 2103564.68904381 | 37.7561647909862 | -122.432166852953 | (37.7561647909862, -122.432166852953) | 2 | 4 | 5 | 28862 | 22 | |||
| 142116 | 99931 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 801X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2012 12:00:00 AM | 3x3 | Permit Number 768924 | 6003100.6 | 2103580.4 | 37.7562064244422 | -122.432259777723 | (37.7562064244422, -122.432259777723) | 2 | 4 | 5 | 28862 | 22 | ||
| 151386 | 106547 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 4509A 25th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2014 12:00:00 AM | 3x3 | Permit Number 772697 | 6000984.2 | 2101089.3 | 37.7492462369191 | -122.439400435576 | (37.7492462369191, -122.439400435576) | 2 | 4 | 5 | 28862 | 22 | |||
| 168854 | 102006 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1703 Castro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776283 | 6002624 | 2100623.7 | 37.7480609930318 | -122.433696712327 | (37.7480609930318, -122.433696712327) | 2 | 4 | 5 | 63 | 22 | |
| 189227 | 109745 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2730 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769296 | 6008568.6 | 2106948.2 | 37.7657621501348 | -122.413587690705 | (37.7657621501348, -122.413587690705) | 8 | 4 | 7 | 28853 | 19 |
| 191399 | 25159 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2600X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2015 12:55:00 PM | 3 | 3X3 | 6001683.708124 | 2105708.1424059 | 37.7619682491468 | -122.437312213886 | (37.7619682491468, -122.437312213886) | 15 | 4 | 5 | 28862 | 3 |
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) );