trees
6 rows where Police Districts = 3 and qSpecies_id = 12 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192727 | 97026 | Property Tree 8 | Tilia cordata :: Littleleaf Linden 12 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
| 19998 | 69332 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 160 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/1994 12:00:00 AM | 11 | Permit Number 781107 | 6013130.58112 | 2106316.68773 | 37.7642832664742 | -122.397764366249 | (37.7642832664742, -122.397764366249) | 14 | 3 | 8 | 28856 | 29 | ||
| 80443 | 197975 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1808 Newhall St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6013682.66617 | 2094773.96113 | 37.7326201220065 | -122.395046310152 | (37.7326201220065, -122.395046310152) | 10 | 3 | 8 | 58 | 1 | |||
| 15 | 264849 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 15 Hale St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6010381 | 2094903 | 37.7327902820185 | -122.40647012075 | (37.7327902820185, -122.40647012075) | 10 | 3 | 7 | 309 | 28 | |||
| 28 | 264848 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 15 Hale St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6010381 | 2094903 | 37.7327902820185 | -122.40647012075 | (37.7327902820185, -122.40647012075) | 10 | 3 | 7 | 309 | 28 | |||
| 13771 | 15042 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1024 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2008 12:00:00 AM | 3 | 3X3 | 6015618.91517 | 2096257.6222 | 37.7368014371311 | -122.388455686999 | (37.7368014371311, -122.388455686999) | 10 | 3 | 8 | 58 | 1 |
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) );