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 "Fire Prevention Districts" = :p0 and "qLegalStatus_id" = :p1 and ([Police Districts] > :p3 or ([Police Districts] = :p3 and ((rowid > :p2)))) order by [Police Districts], 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)
141124	100244	8	34	71 Sanchez St		Back Yard : Yard	Tree	2					Interior courtyard	6003507	2107903	37.7680982797144	-122.431162830878	(37.7680982797144, -122.431162830878)	7	9	5	28862	3