trees
6 rows where Neighborhoods (old) = 16 and qCaretaker_id = 4 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 41872 | 41128 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2049 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 08/10/2017 12:00:00 AM | 3 | 6x6 | Permit Number 41868 | 5998020.62854813 | 2110270.29167038 | 37.7742858282579 | -122.450310189268 | (37.7742858282579, -122.450310189268) | 15 | 5 | 11 | 29492 | 16 |
| 106593 | 41127 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2049 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 08/10/2017 12:00:00 AM | 3 | 6x6 | Permit Number 41868 | 5998020.62854813 | 2110270.29167038 | 37.7742858282579 | -122.450310189268 | (37.7742858282579, -122.450310189268) | 15 | 5 | 11 | 29492 | 16 |
| 111390 | 92750 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 2049 Grove St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/02/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52971 | 5998090.3691 | 2110284.0117 | 37.7743274908907 | -122.450069934151 | (37.7743274908907, -122.450069934151) | 15 | 5 | 11 | 29492 | 16 |
| 115682 | 111766 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1860 HAYES ST | 4 | Front Yard : Yard | Tree | SFUSD 4 | 5998973 | 2110255 | 37.7742982989317 | -122.447014674672 | (37.7742982989317, -122.447014674672) | 15 | 5 | 11 | 29492 | 16 | |||||
| 132145 | 41129 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2049 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 08/10/2017 12:00:00 AM | 3 | 6x6 | Permit Number 41868 | 5998020.62854813 | 2110270.29167038 | 37.7742858282579 | -122.450310189268 | (37.7742858282579, -122.450310189268) | 15 | 5 | 11 | 29492 | 16 |
| 130847 | 98743 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 155 Masonic Ave | 5 | Sidewalk: Property side : | Tree | SFUSD 4 | DPW for City Agency | 5998843.8 | 2112455 | 37.7803315496091 | -122.447619999218 | (37.7803315496091, -122.447619999218) | 15 | 6 | 2 | 54 | 16 |
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) );