trees

Custom SQL query returning 1 row (hide)

select 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)] from trees where "PermitNotes" = :p0 and "SiteOrder" = :p1 and "qSpecies_id" = :p2 and (PlotSize > :p4 or (PlotSize = :p4 and ((rowid > :p3)))) order by PlotSize, rowid limit 101

Query parameters

This data as json, CSV

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)
126686	64148	7	65	1545 Noe St	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	12/05/1987 12:00:00 AM			Permit Number 24927	6003347.08832902	2099252.09112644	37.7443358777099	-122.431098417838	(37.7443358777099, -122.431098417838)	2	7	5	63	22