trees
5 rows where qSpecies_id = 320 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
71527 | 97029 | Property Tree 8 | Rhamnus californica :: Coffeeberry Tree 320 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
26129 | 197356 | DPW Maintained 1 | Rhamnus californica :: Coffeeberry Tree 320 | 39 Latona St | 2 | : | Tree | Private 2 | 1 | Width 6ft | 6014424.19857 | 2094456.12331 | 37.7317886115532 | -122.392460407627 | (37.7317886115532, -122.392460407627) | 10 | 3 | 8 | 58 | 1 | |||
144100 | 197355 | DPW Maintained 1 | Rhamnus californica :: Coffeeberry Tree 320 | 10 Cargo Way | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6018943.2735 | 2097519.21753 | 37.7404491880699 | -122.377049293191 | (37.7404491880699, -122.377049293191) | 10 | 3 | 8 | 58 | 1 | |||
8437 | 83050 | DPW Maintained 1 | Rhamnus californica :: Coffeeberry Tree 320 | 100X Cargo Way | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 1 | 6018877.26977 | 2097567.07885 | 37.7405769700435 | -122.377280830842 | (37.7405769700435, -122.377280830842) | 10 | 3 | 8 | 58 | 1 | ||||
106980 | 197354 | DPW Maintained 1 | Rhamnus californica :: Coffeeberry Tree 320 | 900x Carolina St | 52 | Median : Yard | Tree | DPW 1 | 3 | 6012496.37101 | 2102977.25667 | 37.755078586632 | -122.399723438607 | (37.755078586632, -122.399723438607) | 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) );