trees
106 rows where Fire Prevention Districts = 1 and qLegalStatus_id = 2 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 183437 | 116849 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 83 Panorama Dr | 1 | Front Yard : Yard | Tree | Private 2 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | 1 | 5 | 4 | 59 | 38 | |||
| 184166 | 115674 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1433 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774098 | 5981190.2 | 2105303.4 | 37.7596706142775 | -122.508159957785 | (37.7596706142775, -122.508159957785) | 1 | 8 | 3 | 56 | 35 | ||
| 184867 | 112863 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2451 19TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2015 12:00:00 AM | 3 | 3x3 | 5990427 | 2098705 | 37.7420931085193 | -122.475732948104 | (37.7420931085193, -122.475732948104) | 1 | 8 | 3 | 29491 | 35 | ||
| 186709 | 253104 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3000x Irving St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427 | 2106455 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | 1 | 8 | 3 | 56 | 35 | |
| 194213 | 253623 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1331 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778744 | 5983976.42262 | 2106100.27997 | 37.7620224120695 | -122.498582815109 | (37.7620224120695, -122.498582815109) | 1 | 8 | 3 | 56 | 35 | |
| 138593 | 56707 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1688 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Permit Number 782197 | 5983170.4061 | 2103643.307 | 37.7552289545408 | -122.501188731534 | (37.7552289545408, -122.501188731534) | 1 | 8 | 3 | 56 | 35 |
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) );