trees

Custom SQL query returning 4 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 "Zip Codes" = :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	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location	Fire Prevention Districts	Police Districts	Supervisor Districts	Zip Codes	Neighborhoods (old)
145545	249373	1	65	649 Jones St	1	:	Tree	2	06/22/1998 12:00:00 AM	21	Width 4ft	Permit Number 39973	6008805.56783	2114728.16614	37.7871374013058	-122.4133182966	(37.7871374013058, -122.4133182966)	5	1	10	28852	36
33220	139917	1	65	1000 LAGUNA ST	3	Sidewalk: Curb side : Cutout	Tree	2		17	Width 0ft		6004809.1682	2112368.8803	37.7804342038606	-122.426976875009	(37.7804342038606, -122.426976875009)	7	9	11	28852	41
146765	139915	1	65	1000 LAGUNA ST	1	Sidewalk: Curb side : Cutout	Tree	2		7	Width 0ft		6004816.1035	2112332.8828	37.7803357557587	-122.426950318013	(37.7803357557587, -122.426950318013)	7	9	11	28852	41
185738	139916	1	65	1000 LAGUNA ST	2	Sidewalk: Curb side : Cutout	Tree	2		10	Width 0ft		6004814.4523	2112350.3862	37.7803837224117	-122.426957277261	(37.7803837224117, -122.426957277261)	7	9	11	28852	41