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 "SiteOrder" = :p0 and "qSiteInfo" = :p1 and "qSpecies_id" = :p2 and ([Fire Prevention Districts] > :p4 or ([Fire Prevention Districts] = :p4 and ((rowid > :p3)))) order by [Fire Prevention 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)
17451	162712	1	48	850 Grafton Ave	2	Sidewalk: Curb side : Cutout	Tree	1			0	Width 0ft		5994210.35674	2090607.81746	37.7200788467504	-122.462064325032	(37.7200788467504, -122.462064325032)	9	8	6	28861	24
17487	162702	1	48	650 Grafton Ave	2	Sidewalk: Curb side : Cutout	Tree	1			0	Width 0ft		5994851.70364	2090594.06409	37.7200779878774	-122.459846425972	(37.7200779878774, -122.459846425972)	9	8	6	28861	24