trees
6 rows where qSpecies_id = 387
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19818 | 197480 | DPW Maintained 1 | Schefflera species :: Umbrella tree 387 | 1 Jack Balestreri Way | 31 | Front Yard : Yard | Tree | Private 2 | 4 | 6012406.70944 | 2104799.68799 | 37.7600775842279 | -122.400161501074 | (37.7600775842279, -122.400161501074) | 10 | 3 | 8 | 28856 | 29 | ||||
| 29735 | 197479 | DPW Maintained 1 | Schefflera species :: Umbrella tree 387 | 1700x Quesada Ave | 48 | Median : Yard | Tree | DPW 1 | 4 | 6014300.68484 | 2095327.0716 | 37.7341731981237 | -122.392948336615 | (37.7341731981237, -122.392948336615) | 10 | 3 | 8 | 58 | 1 | ||||
| 57927 | 31833 | DPW Maintained 1 | Schefflera species :: Umbrella tree 387 | 234 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 14 | Permit Number 35290 | 6009600.90187 | 2109052.05463 | 37.7715967611174 | -122.410165712372 | (37.7715967611174, -122.410165712372) | 8 | 2 | 9 | 28853 | 34 | |
| 101001 | 197481 | DPW Maintained 1 | Schefflera species :: Umbrella tree 387 | 1700x Quesada Ave | 21 | Median : Yard | Tree | DPW 1 | 4 | 6014505.90634 | 2095186.14654 | 37.7337976439333 | -122.392228962601 | (37.7337976439333, -122.392228962601) | 10 | 3 | 8 | 58 | 1 | ||||
| 123961 | 136364 | DPW Maintained 1 | Schefflera species :: Umbrella tree 387 | 3698 Beach St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 5ft | 6002136.20971 | 2121153.21559 | 37.8044022136584 | -122.436852904354 | (37.8044022136584, -122.436852904354) | 13 | 9 | 1 | 57 | 17 | |||
| 140642 | 239565 | DPW Maintained 1 | Schefflera species :: Umbrella tree 387 | 198 Corbin Pl | 4 | Side Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6000083.99604 | 2105681.3583 | 37.7618036359623 | -122.442843052861 | (37.7618036359623, -122.442843052861) | 15 | 5 | 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) );