trees
6 rows where PlotSize = "Width 7ft" and qSpecies_id = 86
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40704 | 136716 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 14 | Side Yard : Yard | Tree | Private 2 | 15 | Width 7ft | 6003215.33658 | 2120983.87446 | 37.8039985196804 | -122.43310638985 | (37.8039985196804, -122.43310638985) | 13 | 9 | 1 | 57 | 17 | |||
54469 | 136659 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 11 | Side Yard : Yard | Tree | Private 2 | 13 | Width 7ft | 6003202.74777 | 2120982.34817 | 37.8039936147875 | -122.433149845112 | (37.8039936147875, -122.433149845112) | 13 | 9 | 1 | 57 | 17 | |||
85899 | 136715 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 9 | Side Yard : Yard | Tree | Private 2 | 9 | Width 7ft | 6003190.85748 | 2120979.91426 | 37.803986257417 | -122.433190818205 | (37.803986257417, -122.433190818205) | 13 | 9 | 1 | 57 | 17 | |||
93918 | 136660 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 17 | Side Yard : Yard | Tree | Private 2 | 14 | Width 7ft | 6003228.45993 | 2120985.21121 | 37.8040029344509 | -122.433061071222 | (37.8040029344509, -122.433061071222) | 13 | 9 | 1 | 57 | 17 | |||
111535 | 136714 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 3 | Side Yard : Yard | Tree | Private 2 | 18 | Width 7ft | 6003161.03368 | 2120976.61805 | 37.8039755150326 | -122.433293789677 | (37.8039755150326, -122.433293789677) | 13 | 9 | 1 | 57 | 17 | |||
134209 | 136658 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1599 North Point St | 6 | Side Yard : Yard | Tree | Private 2 | 15 | Width 7ft | 6003175.48548 | 2120978.26665 | 37.8039808614944 | -122.433243896185 | (37.8039808614944, -122.433243896185) | 13 | 9 | 1 | 57 | 17 |
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) );