trees: trees: 3 rows where where Zip Codes = 28861 and qSpecies

3 rows where Zip Codes = 28861 and qSpecies_id = 124

Search:

descending

rowid ▼	TreeID	qLegalStatus_id	qSpecies_id	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker_id	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location	Fire Prevention Districts	Police Districts	Supervisor Districts	Zip Codes	Neighborhoods (old)
42081	51535	Permitted Site 7	Acer japonicum :: Japanese Maple 124	575 Hearst Ave	1	Sidewalk: Curb side : Cutout	Tree	Private 2	01/14/2005 12:00:00 AM			Permit Number 47836	5997620.77530153	2094372.6871886	37.7306120580701	-122.450547001775	(37.7306120580701, -122.450547001775)	9	7	4	28861	40
102612	119267	Undocumented 4	Acer japonicum :: Japanese Maple 124	1321 Plymouth Ave	1	Sidewalk: Property side : Yard	Tree	Private 2		11	10x4		5995851.8603726	2092807.77065035	37.7262137675089	-122.456549245441	(37.7262137675089, -122.456549245441)	9	7	4	28861	40
158236	116267	Planning Code 138.1 required 2	Acer japonicum :: Japanese Maple 124	717 PARIS ST	1	Front Yard : Yard	Tree	Private 2			3x3		6001138	2089523	37.7174966063475	-122.438040195581	(37.7174966063475, -122.438040195581)	9	7	6	28861	5

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