trees
7 rows where PlotSize = "Width 5ft" and qSpecies_id = 202 sorted by Supervisor Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39944 | 125565 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1907 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 5999924.77973 | 2115560.64966 | 37.7889205779801 | -122.444103621795 | (37.7889205779801, -122.444103621795) | 13 | 6 | 1 | 29490 | 27 | |||
| 190673 | 175222 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 300 Gaven St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6008975.92118 | 2094875.47718 | 37.7326360049484 | -122.411325907078 | (37.7326360049484, -122.411325907078) | 9 | 3 | 7 | 309 | 28 | |||
| 73206 | 187967 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1551 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015595.88641 | 2096776.81479 | 37.7382257582057 | -122.38857153857 | (37.7382257582057, -122.38857153857) | 10 | 3 | 8 | 58 | 1 | |||
| 164248 | 189235 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1634 Jerrold Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6015126.70903 | 2097207.07467 | 37.7393811514086 | -122.390223786492 | (37.7393811514086, -122.390223786492) | 10 | 3 | 8 | 58 | 1 | |||
| 10445 | 187965 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 211 Terry A Francois Blvd | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 5ft | 6015662.09524 | 2110622.54521 | 37.7762468568378 | -122.38930919937 | (37.7762468568378, -122.38930919937) | 14 | 3 | 9 | 310 | 20 | |||
| 29070 | 187964 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 211 Terry A Francois Blvd | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 5ft | 6015658.44742 | 2110621.01823 | 37.7762424618552 | -122.389321711634 | (37.7762424618552, -122.389321711634) | 14 | 3 | 9 | 310 | 20 | |||
| 57327 | 187966 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 211 Terry A Francois Blvd | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 5ft | 6015666.2407 | 2110622.1949 | 37.7762461247865 | -122.389294834495 | (37.7762461247865, -122.389294834495) | 14 | 3 | 9 | 310 | 20 |
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) );