trees
10 rows where qSpecies_id = 369
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16563 | 204754 | DPW Maintained 1 | Aloe barberae :: Tree aloe 369 | 140 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994505.57293 | 2100089.53761 | 37.7461303160582 | -122.461730997591 | (37.7461303160582, -122.461730997591) | 1 | 8 | 4 | 29491 | 40 | |||
43415 | 204752 | DPW Maintained 1 | Aloe barberae :: Tree aloe 369 | 140 Pacheco St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994511.5278 | 2100117.0182 | 37.7462061136348 | -122.46171239872 | (37.7462061136348, -122.46171239872) | 1 | 8 | 4 | 29491 | 40 | |||
48681 | 204751 | DPW Maintained 1 | Aloe barberae :: Tree aloe 369 | 140 Pacheco St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994525.40112 | 2100147.21703 | 37.7462898306232 | -122.461666616016 | (37.7462898306232, -122.461666616016) | 1 | 8 | 4 | 29491 | 40 | |||
81742 | 103502 | DPW Maintained 1 | Aloe barberae :: Tree aloe 369 | 2050 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/2013 12:00:00 AM | 8 | 3x3 | Permit Number 768855 | 5999390.64276 | 2121209.61307 | 37.8044006407487 | -122.446358197886 | (37.8044006407487, -122.446358197886) | 13 | 9 | 1 | 57 | 17 | |
88207 | 204753 | DPW Maintained 1 | Aloe barberae :: Tree aloe 369 | 140 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994508.79603 | 2100105.12708 | 37.746173306358 | -122.461720982741 | (37.746173306358, -122.461720982741) | 1 | 8 | 4 | 29491 | 40 | |||
109145 | 187997 | DPW Maintained 1 | Aloe barberae :: Tree aloe 369 | 764 De Haro St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6012092.70661 | 2104856.04192 | 37.7602148063835 | -122.401251453315 | (37.7602148063835, -122.401251453315) | 10 | 3 | 8 | 28856 | 29 | ||||
117438 | 187998 | DPW Maintained 1 | Aloe barberae :: Tree aloe 369 | 2211 25th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6012098.53804 | 2101850.00675 | 37.7519612189539 | -122.401020068525 | (37.7519612189539, -122.401020068525) | 10 | 3 | 8 | 28856 | 29 | ||||
150955 | 204755 | DPW Maintained 1 | Aloe barberae :: Tree aloe 369 | 140 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994506.1495 | 2100077.57714 | 37.7460975088062 | -122.461728136838 | (37.7460975088062, -122.461728136838) | 1 | 8 | 4 | 29491 | 40 | |||
173167 | 204750 | DPW Maintained 1 | Aloe barberae :: Tree aloe 369 | 140 Pacheco St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994534.31056 | 2100157.74286 | 37.746319244754 | -122.461636571492 | (37.746319244754, -122.461636571492) | 1 | 8 | 4 | 29491 | 40 | |||
175359 | 187996 | DPW Maintained 1 | Aloe barberae :: Tree aloe 369 | 764 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6012086.09905 | 2104857.7195 | 37.760219044007 | -122.401274423773 | (37.760219044007, -122.401274423773) | 10 | 3 | 8 | 28856 | 29 |
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) );