trees
9 rows where qSpecies_id = 184
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1383 | 260901 | DPW Maintained 1 | Populus alba :: White Poplar 184 | 1599 Steiner St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Width 0ft | 6002672 | 2113572 | 37.7836165897996 | -122.434456380093 | (37.7836165897996, -122.434456380093) | 13 | 9 | 11 | 29490 | 41 | ||||
| 6348 | 260900 | DPW Maintained 1 | Populus alba :: White Poplar 184 | 1599 Steiner St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Width 0ft | 6002672 | 2113572 | 37.7836165897996 | -122.434456380093 | (37.7836165897996, -122.434456380093) | 13 | 9 | 11 | 29490 | 41 | ||||
| 16599 | 260899 | DPW Maintained 1 | Populus alba :: White Poplar 184 | 1599 Steiner St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Width 0ft | 6002672 | 2113572 | 37.7836165897996 | -122.434456380093 | (37.7836165897996, -122.434456380093) | 13 | 9 | 11 | 29490 | 41 | ||||
| 17502 | 260902 | Significant Tree 6 | Populus alba :: White Poplar 184 | 1901 Geary Blvd | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Width 0ft | 6002672 | 2113572 | 37.7836165897996 | -122.434456380093 | (37.7836165897996, -122.434456380093) | 13 | 9 | 11 | 29490 | 41 | ||||
| 53384 | 234868 | DPW Maintained 1 | Populus alba :: White Poplar 184 | 310 Liberty St | 58 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 6003726.80276 | 2103918.02855 | 37.7571689581965 | -122.430118240383 | (37.7571689581965, -122.430118240383) | 2 | 4 | 5 | 28862 | 3 | |||
| 103178 | 107527 | Undocumented 4 | Populus alba :: White Poplar 184 | 2540x LYON ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 30 | Permit Number 774117 | 5999227 | 2117510 | 37.7942331479636 | -122.446658147156 | (37.7942331479636, -122.446658147156) | 13 | 1 | 57 | 30 | ||||
| 133898 | 195953 | DPW Maintained 1 | Populus alba :: White Poplar 184 | 1599 Rankin St | 2 | Side Yard : Yard | Tree | Private 2 | 11 | 6012519.43639 | 2096471.57125 | 37.7372166514233 | -122.39918702717 | (37.7372166514233, -122.39918702717) | 10 | 3 | 8 | 58 | 1 | ||||
| 148553 | 212848 | DPW Maintained 1 | Populus alba :: White Poplar 184 | 217 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 5998651.03844 | 2093760.08524 | 37.7289889122974 | -122.446941175297 | (37.7289889122974, -122.446941175297) | 9 | 7 | 4 | 28861 | 40 | ||||
| 156168 | 113153 | Significant Tree 6 | Populus alba :: White Poplar 184 | 55 BRONTE ST | Front Yard : Cutout | Tree | Private 2 | 12 | 3x3 | 6009403 | 2097128 | 37.7388448914729 | -122.410008345842 | (37.7388448914729, -122.410008345842) | 10 | 7 | 7 | 28859 | 2 |
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) );