trees
7 rows where Neighborhoods (old) = 11 and qSpecies_id = 129 sorted by Police 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3875 | 3295 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 4721 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2005 12:00:00 AM | 6 | 3X3 | 5992917.64909 | 2114121.45234 | 37.784566708473 | -122.468242393585 | (37.784566708473, -122.468242393585) | 11 | 6 | 2 | 54 | 11 | ||
51444 | 103560 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 300X Cornwall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2013 12:00:00 AM | 4 | 3x3 | Permit Number 769959 | 5994548.41195 | 2114239.31822 | 37.7849843868147 | -122.462609100644 | (37.7849843868147, -122.462609100644) | 11 | 6 | 2 | 54 | 11 | |
62857 | 123067 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 604 12th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5992249.44693 | 2111276.49592 | 37.7767166209192 | -122.470346870506 | (37.7767166209192, -122.470346870506) | 11 | 6 | 2 | 54 | 11 | |||
64632 | 62317 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 690 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | Permit Number 22459 | 5994436.89437 | 2110841.52784 | 37.7756485440016 | -122.462748336841 | (37.7756485440016, -122.462748336841) | 11 | 6 | 2 | 54 | 11 | |
79873 | 124285 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 4201 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5994493.43638 | 2114295.92728 | 37.7851366537527 | -122.462803405372 | (37.7851366537527, -122.462803405372) | 11 | 6 | 2 | 54 | 11 | |||
133689 | 103558 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 4201 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2013 12:00:00 AM | 11 | 3x3 | Permit Number 769959 | 5994475.89844 | 2114293.94067 | 37.7851301889308 | -122.462863936545 | (37.7851301889308, -122.462863936545) | 11 | 6 | 2 | 54 | 11 | |
186841 | 123653 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 340 Cornwall St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5994489.04448 | 2114234.67413 | 37.7849682162377 | -122.46281415459 | (37.7849682162377, -122.46281415459) | 11 | 6 | 2 | 54 | 11 |
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) );