trees

Custom SQL query returning 2 rows (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 "Police Districts" = :p0 and "qSpecies_id" = :p1 and ([Neighborhoods (old)] > :p3 or ([Neighborhoods (old)] = :p3 and ((rowid > :p2)))) order by [Neighborhoods (old)], 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)
96239	187623	1	48	325 Vicente St	1	Sidewalk: Curb side : Cutout	Tree	2				3x3		5991928	2097693	37.7394013212876	-122.470469324928	(37.7394013212876, -122.470469324928)	1	8	4	59	40
133720	187653	1	48	307 Vicente St	1	Sidewalk: Curb side : Cutout	Tree	2				3x3		5992004	2097696	37.7394139526506	-122.470206771239	(37.7394139526506, -122.470206771239)	1	8	4	59	40