trees: trees: 3 rows where where qCaretaker_id = 19 and qLegalStatus

3 rows where qCaretaker_id = 19 and qLegalStatus_id = 6 sorted by qCareAssistant

Search:

descending

rowid	TreeID	qLegalStatus_id	qSpecies_id	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker_id	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location	Fire Prevention Districts	Police Districts	Supervisor Districts	Zip Codes	Neighborhoods (old)
15723	105168	Significant Tree 6	Corymbia ficifolia :: Red Flowering Gum 28	4755X 03RD ST	2	Front Yard : Cutout	Tree	Arts Commission 19	23	3x3	Permit Number 770204	6015032	2095658	37.7351224553975	-122.390443042679	(37.7351224553975, -122.390443042679)	10	3	8	58	1
29803	105161	Significant Tree 6	Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40	1600X Oakdale Ave	2	Front Yard : Cutout	Tree	Arts Commission 19	13	3x3		6014869.34112	2095641.83637	37.735069048787	-122.391004288315	(37.735069048787, -122.391004288315)	10	3	8	58	1
179978	105160	Significant Tree 6	Corymbia ficifolia :: Red Flowering Gum 28	1600X OAKDALE AVE	1	Front Yard : Yard	Tree	Arts Commission 19	13		Permit Number 770204	6015006	2095503	37.7346954145828	-122.390522107646	(37.7346954145828, -122.390522107646)	10	3	8	58	1

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