squirrels

Custom SQL query returning 4 rows (hide)

select rowid, longitude, latitude, [Unique Squirrel ID], Hectare, Shift, Date, [Hectare Squirrel Number], Age, [Primary Fur Color], [Highlight Fur Color], [Combination of Primary and Highlight Color], [Color notes], Location, [Above Ground Sighter Measurement], [Specific Location], Running, Chasing, Climbing, Eating, Foraging, [Other Activities], Kuks, Quaas, Moans, [Tail flags], [Tail twitches], Approaches, Indifferent, [Runs from], [Other Interactions], [Lat/Long] from [2018_Central_Park_Squirrel_Census_-_Squirrel_Data] where "Approaches" = :p0 and "Foraging" = :p1 and ([Lat/Long] > :p3 or ([Lat/Long] = :p3 and rowid > :p2)) order by [Lat/Long], rowid limit 101

Query parameters

This data as json, CSV

rowid	longitude	latitude	Unique Squirrel ID	Hectare	Shift	Date	Hectare Squirrel Number	Age	Primary Fur Color	Highlight Fur Color	Combination of Primary and Highlight Color	Location	Above Ground Sighter Measurement	Specific Location	Eating	Foraging	Tail twitches	Approaches	Indifferent	Lat/Long
651	-73.9801661903932	40.7697950141751	3A-PM-1017-03	03A	PM	10172018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	1	0	1	0	POINT (-73.9801661903932 40.7697950141751)
1474	-73.9801971465604	40.7697081749827	3A-PM-1017-04	03A	PM	10172018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	1	0	1	0	POINT (-73.9801971465604 40.7697081749827)
669	-73.98020792598659	40.7678723471007	1B-AM-1012-10	01B	AM	10122018	10	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		1	1	0	1	0	POINT (-73.9802079259866 40.7678723471007)
2816	-73.9809342290598	40.7687265606227	2A-AM-1010-05	02A	AM	10102018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE	base of tree with ~ 30 small birds all eating	1	1	1	1	1	POINT (-73.9809342290598 40.7687265606227)