trees
7 rows where PlotSize = "3x3" and qSpecies_id = 117 sorted by YCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 184741 | 109308 | Undocumented 4 | Melaleuca spp :: Melaleuca spp 117 | 73 Keystone Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774521 | 5994086.4 | 2093277.1 | 37.7274009132864 | -122.462686331638 | (37.7274009132864, -122.462686331638) | 9 | 8 | 4 | 59 | 40 | |
| 177856 | 24099 | Permitted Site 7 | Melaleuca spp :: Melaleuca spp 117 | 105X Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2001 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.081358 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | 10 | 3 | 8 | 58 | 1 | ||
| 114276 | 15009 | Permitted Site 7 | Melaleuca spp :: Melaleuca spp 117 | 600X Mendell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2002 12:00:00 AM | 3 | 3x3 | 6016372.25512 | 2097272.64218 | 37.7396301943656 | -122.385921767044 | (37.7396301943656, -122.385921767044) | 10 | 3 | 8 | 58 | 1 | ||
| 177877 | 113822 | Undocumented 4 | Melaleuca spp :: Melaleuca spp 117 | 4101x 25TH ST | 15 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 7 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
| 92497 | 108127 | Undocumented 4 | Melaleuca spp :: Melaleuca spp 117 | 1901 FOLSOM ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008051 | 2107091 | 37.7661251677687 | -122.415388074018 | (37.7661251677687, -122.415388074018) | 8 | 4 | 7 | 28853 | 19 | ||||
| 9037 | 87895 | Permitted Site 7 | Melaleuca spp :: Melaleuca spp 117 | 333 Fell St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2008 12:00:00 AM | 3x3 | Permit Number 50914 | 6005838.683161 | 2110670.713999 | 37.7758296125272 | -122.423294544203 | (37.7758296125272, -122.423294544203) | 7 | 9 | 11 | 28852 | 10 | ||
| 165214 | 87896 | Permitted Site 7 | Melaleuca spp :: Melaleuca spp 117 | 333 Fell St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 50914 | 6005838.683161 | 2110670.713999 | 37.7758296125272 | -122.423294544203 | (37.7758296125272, -122.423294544203) | 7 | 9 | 11 | 28852 | 10 |
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) );