trees
6 rows where qSpecies_id = 360
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15109 | 49807 | DPW Maintained 1 | Punica granatum 'Wonderfu :: Pomegranate Tree 'Wonderful' 360 | 1164SSIPPI 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 8 | Permit Number 46601 | 6014115.89861 | 2105750.21634 | 37.7627826810847 | -122.394316741417 | (37.7627826810847, -122.394316741417) | 14 | 3 | 8 | 28856 | 29 | |
29853 | 196561 | DPW Maintained 1 | Punica granatum 'Wonderfu :: Pomegranate Tree 'Wonderful' 360 | 2330 Lane St | 3 | Front Yard : Yard | Tree | Private 2 | 9 | 6013955.56883 | 2092923.89958 | 37.7275554010408 | -122.39397334879 | (37.7275554010408, -122.39397334879) | 10 | 3 | 8 | 58 | 1 | ||||
92758 | 239034 | DPW Maintained 1 | Punica granatum 'Wonderfu :: Pomegranate Tree 'Wonderful' 360 | 246 Bemis St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6003036.33312 | 2096321.01175 | 37.7362701959111 | -122.431963686097 | (37.7362701959111, -122.431963686097) | 2 | 7 | 5 | 63 | 7 | ||||
119240 | 196559 | DPW Maintained 1 | Punica granatum 'Wonderfu :: Pomegranate Tree 'Wonderful' 360 | 582 Rhode Island St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6011757.06528 | 2105670.30233 | 37.762431852865 | -122.40246954186 | (37.762431852865, -122.40246954186) | 8 | 3 | 8 | 28856 | 29 | ||||
166150 | 196558 | DPW Maintained 1 | Punica granatum 'Wonderfu :: Pomegranate Tree 'Wonderful' 360 | 800 19th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6015115.48075 | 2105343.92611 | 37.7617226088276 | -122.390831114884 | (37.7617226088276, -122.390831114884) | 10 | 3 | 8 | 28856 | 29 | |||
193043 | 196560 | DPW Maintained 1 | Punica granatum 'Wonderfu :: Pomegranate Tree 'Wonderful' 360 | 582 Rhode Island St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6011757.86648 | 2105666.49456 | 37.7624214423066 | -122.402466503028 | (37.7624214423066, -122.402466503028) | 8 | 3 | 8 | 28856 | 29 |
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) );