trees
8 rows where PlotSize = "3x8" and qLegalStatus_id = 6
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24819 | 122688 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 2590 Pacific Ave | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 3x8 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | |||
59933 | 122637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630X 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x8 | 5990614 | 2091411 | 37.7220764711857 | -122.47455416919 | (37.7220764711857, -122.47455416919) | 9 | 8 | 4 | 64 | 40 | ||||
69281 | 122640 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630X 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x8 | 5990614 | 2091411 | 37.7220764711857 | -122.47455416919 | (37.7220764711857, -122.47455416919) | 9 | 8 | 4 | 64 | 40 | ||||
94162 | 122638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630X 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x8 | 5990614 | 2091411 | 37.7220764711857 | -122.47455416919 | (37.7220764711857, -122.47455416919) | 9 | 8 | 4 | 64 | 40 | ||||
115527 | 122689 | Significant Tree 6 | Aesculus hippocastanum :: White Horsechestnut 190 | 2590 Pacific Ave | 2 | Front Yard : Yard | Tree | Private 2 | 12 | 3x8 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | |||
160307 | 110393 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 451 LOS PALMOS DR | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x8 | 5997298 | 2095759 | 37.7344000615683 | -122.451762846846 | (37.7344000615683, -122.451762846846) | 9 | 7 | 4 | 59 | 40 | ||||
162024 | 122639 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630X 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x8 | 5990614 | 2091411 | 37.7220764711857 | -122.47455416919 | (37.7220764711857, -122.47455416919) | 9 | 8 | 4 | 64 | 40 | ||||
188643 | 122687 | Significant Tree 6 | Tree(s) :: 17 | 1462 Funston Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 01/04/2017 12:00:00 AM | 3 | 3x8 | Permit Number 779171 | 5992142.99696903 | 2105491.66018597 | 37.7608268551195 | -122.470293739312 | (37.7608268551195, -122.470293739312) | 1 | 8 | 4 | 56 | 12 |
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) );