7 rows where qSpecies_id = 158 sorted by rowid descending

View and edit SQL

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)
178796 256488 Undocumented 4 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158 901 Ingerson Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014644 2089423 37.7179808627223 -122.391348788107 (37.7179808627223, -122.391348788107) 10 3 8 58 1
35280 255716 Undocumented 4 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158 937x Meade Ave 2 Front Yard : Yard Tree Private 2       3x3   6012763 2089349 37.7176730984513 -122.397845439416 (37.7176730984513, -122.397845439416) 10 3 8 58 1
32485 256486 Undocumented 4 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158 901 Ingerson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014644 2089423 37.7179808627223 -122.391348788107 (37.7179808627223, -122.391348788107) 10 3 8 58 1
28904 255717 Undocumented 4 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158 937x Meade Ave 3 Front Yard : Yard Tree Private 2       3x3   6012763 2089349 37.7176730984513 -122.397845439416 (37.7176730984513, -122.397845439416) 10 3 8 58 1
11572 96179 Permitted Site 7 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158     Unaccepted Street : Cutout Tree Private 2       3x3 Permit Number 767811                    
6343 96176 Permitted Site 7 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158     Unaccepted Street : Cutout Tree Private 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767809                    
980 96180 Permitted Site 7 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158     Unaccepted Street : Cutout Tree Private 2   04/04/2011 12:00:00 AM   3x3 Permit Number 767812                    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);