trees
7 rows where qSpecies_id = 311
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7237 | 93420 | DPW Maintained 1 | Prunus x 'Amanogawa' :: Flowering Cherry 311 | 2002 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986956.2239 | 2098967.2524 | 37.742611352251 | -122.487752901904 | (37.742611352251, -122.487752901904) | 1 | 8 | 3 | 29491 | 35 | ||
| 26183 | 93465 | DPW Maintained 1 | Prunus x 'Amanogawa' :: Flowering Cherry 311 | 1699X Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5988019.8 | 2098880.1 | 37.7424340339905 | -122.484069021286 | (37.7424340339905, -122.484069021286) | 1 | 8 | 3 | 29491 | 35 | ||
| 33048 | 4829 | DPW Maintained 1 | Prunus x 'Amanogawa' :: Flowering Cherry 311 | 94 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2011 12:00:00 AM | 3 | 3x3 | 6006236.958897 | 2097686.3159311 | 37.7401999454427 | -122.420994688157 | (37.7401999454427, -122.420994688157) | 2 | 7 | 7 | 28859 | 2 | ||
| 47948 | 93462 | DPW Maintained 1 | Prunus x 'Amanogawa' :: Flowering Cherry 311 | 1749 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987813 | 2098948 | 37.7426084273374 | -122.484789044745 | (37.7426084273374, -122.484789044745) | 1 | 8 | 3 | 29491 | 35 | ||
| 109123 | 93422 | DPW Maintained 1 | Prunus x 'Amanogawa' :: Flowering Cherry 311 | 2022 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986970 | 2098986.9 | 37.7426661028614 | -122.487706711913 | (37.7426661028614, -122.487706711913) | 1 | 8 | 3 | 29491 | 35 | ||
| 113050 | 114224 | DPW Maintained 1 | Prunus x 'Amanogawa' :: Flowering Cherry 311 | 1848x TARAVAL ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/19/2016 01:32:00 PM | 3 | 3x3 | 5987462 | 2098996 | 37.7427197736461 | -122.486006207543 | (37.7427197736461, -122.486006207543) | 1 | 8 | 3 | 29491 | 35 | ||
| 152386 | 89288 | Permitted Site 7 | Prunus x 'Amanogawa' :: Flowering Cherry 311 | 8 Costa St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/2008 12:00:00 AM | 3x3 | Permit Number 51896 | 6010584.9 | 2099259.3 | 37.7447631529327 | -122.40607197538 | (37.7447631529327, -122.40607197538) | 2 | 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) );