trees
6 rows where qSpecies_id = 433 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80168 | 205612 | DPW Maintained 1 | Archontophoenix myolensis :: Myola palm 433 | 126 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 5999249.88937 | 2095534.41649 | 37.7338950045329 | -122.444998412161 | (37.7338950045329, -122.444998412161) | 9 | 7 | 4 | 59 | 40 | |||
| 43591 | 205611 | DPW Maintained 1 | Archontophoenix myolensis :: Myola palm 433 | 1642 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 4ft | 5993734.79121 | 2104295.98672 | 37.7576357486133 | -122.464701645392 | (37.7576357486133, -122.464701645392) | 1 | 8 | 4 | 56 | 12 | |||
| 33560 | 221185 | DPW Maintained 1 | Archontophoenix myolensis :: Myola palm 433 | 3724 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6004878.81963 | 2102538.51746 | 37.7534463234083 | -122.426035917236 | (37.7534463234083, -122.426035917236) | 2 | 4 | 5 | 28862 | 22 | |||
| 149243 | 221184 | DPW Maintained 1 | Archontophoenix myolensis :: Myola palm 433 | 3724 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6004883.94208 | 2102538.41202 | 37.7534463234012 | -122.426018195197 | (37.7534463234012, -122.426018195197) | 2 | 4 | 5 | 28862 | 22 | |||
| 88816 | 69596 | DPW Maintained 1 | Archontophoenix myolensis :: Myola palm 433 | 506 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/25/2002 12:00:00 AM | 15 | Permit Number 44922 | 6003085.58974 | 2090659.49514 | 37.7207277381626 | -122.431389360151 | (37.7207277381626, -122.431389360151) | 9 | 7 | 6 | 28861 | 5 | |
| 125628 | 46843 | DPW Maintained 1 | Archontophoenix myolensis :: Myola palm 433 | 94 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 10 | Permit Number 44913 | 6004540.55288 | 2092993.45536 | 37.7272186319258 | -122.426526105303 | (37.7272186319258, -122.426526105303) | 9 | 7 | 6 | 28861 | 5 |
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) );