trees
9 rows where qSpecies_id = 421
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28863 | 115887 | Planning Code 138.1 required 2 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 | 134 Lunado Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | 2x4 | Permit Number 772714 | 5991633.6 | 2092401.5 | 37.7248551637156 | -122.471101821397 | (37.7248551637156, -122.471101821397) | 9 | 8 | 4 | 59 | 40 | |
29841 | 115885 | Planning Code 138.1 required 2 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 | 134 Lunado Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | 10x10 | Permit Number 772714 | 5991633.6 | 2092401.5 | 37.7248551637156 | -122.471101821397 | (37.7248551637156, -122.471101821397) | 9 | 8 | 4 | 59 | 40 | |
45389 | 115886 | Planning Code 138.1 required 2 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 | 134 Lunado Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | 2x4 | Permit Number 772714 | 5991633.6 | 2092401.5 | 37.7248551637156 | -122.471101821397 | (37.7248551637156, -122.471101821397) | 9 | 8 | 4 | 59 | 40 | |
57453 | 66716 | Permitted Site 7 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 | 3506 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/1991 12:00:00 AM | 12 | 3x3 | Permit Number 29957 | 6006118 | 2102026 | 37.7521090259453 | -122.421714160738 | (37.7521090259453, -122.421714160738) | 2 | 4 | 5 | 28859 | 19 | |
82843 | 243896 | Planning Code 138.1 required 2 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 | 4225 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2018 12:00:00 AM | 3 | 3x3 | 6001659.32992 | 2102313.2065 | 37.7526451902403 | -122.437153446982 | (37.7526451902403, -122.437153446982) | 2 | 4 | 5 | 28862 | 22 | ||
115380 | 107697 | Permitted Site 7 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 | 2401 MORAGA ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5986802.4 | 2103641.7 | 37.7554371523715 | -122.488628271884 | (37.7554371523715, -122.488628271884) | 1 | 8 | 3 | 56 | 35 | ||||
157845 | 107434 | Undocumented 4 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 | 3169 WASHINGTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999560.6 | 2115983.6 | 37.7900611064648 | -122.44539405336 | (37.7900611064648, -122.44539405336) | 13 | 6 | 1 | 29490 | 27 | |||||
182845 | 107698 | Permitted Site 7 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 | 2401 MORAGA ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5986802.4 | 2103641.7 | 37.7554371523715 | -122.488628271884 | (37.7554371523715, -122.488628271884) | 1 | 8 | 3 | 56 | 35 | ||||
187521 | 100073 | Permitted Site 7 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 | 930@ Lorraine Ct Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2012 12:00:00 AM | 3x3 | Permit Number 769060 | 5996162 | 2112255 | 37.7796287713947 | -122.456883064061 | (37.7796287713947, -122.456883064061) | 11 | 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) );