trees
4 rows where qSpecies_id = 374
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17576 | 126577 | DPW Maintained 1 | Escallonia bifida :: White escallonia 374 | 3154 Baker St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 5999406.99783 | 2119698.03039 | 37.8002511760006 | -122.44619280176 | (37.8002511760006, -122.44619280176) | 13 | 9 | 1 | 57 | 17 | |||
| 85158 | 126578 | DPW Maintained 1 | Escallonia bifida :: White escallonia 374 | 3154 Baker St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 5999405.94131 | 2119714.62136 | 37.8002966700164 | -122.446197651813 | (37.8002966700164, -122.446197651813) | 13 | 9 | 1 | 57 | 17 | |||
| 107210 | 191714 | DPW Maintained 1 | Escallonia bifida :: White escallonia 374 | 1721 Revere Ave | 2 | : | Tree | Private 2 | 17 | Width 7ft | 6014452.81079 | 2094848.17037 | 37.7328666819345 | -122.392388899836 | (37.7328666819345, -122.392388899836) | 10 | 3 | 8 | 58 | 1 | |||
| 162659 | 1165 | DPW Maintained 1 | Escallonia bifida :: White escallonia 374 | 2849X Alemany Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.450099227424 | (37.7132258706419, -122.450099227424) | 9 | 7 | 6 | 28861 | 25 |
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) );