squirrels

Custom SQL query returning 9 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 "Eating" = :p0 and "Hectare" = :p1 order by Hectare 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	Color notes	Location	Above Ground Sighter Measurement	Running	Climbing	Foraging	Tail twitches	Approaches	Runs from	Lat/Long
61	-73.9797084866613	40.7698885241349	3A-PM-1017-06	03A	PM	10172018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	0	1	0	0	1	POINT (-73.9797084866613 40.7698885241349)
70	-73.9804528867547	40.7696753655986	3A-PM-1017-05	03A	PM	10172018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	0	1	0	0	0	POINT (-73.9804528867547 40.76967536559861)
651	-73.9801661903932	40.7697950141751	3A-PM-1017-03	03A	PM	10172018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	0	0	1	0	1	0	POINT (-73.9801661903932 40.7697950141751)
820	-73.9801902133148	40.769557595068	3A-AM-1012-03	03A	AM	10122018	3	Juvenile	Gray	Black, Cinnamon	Gray+Black, Cinnamon	Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments.	Above Ground	1	0	1	0	1	0	1	POINT (-73.9801902133148 40.769557595068)
1132	-73.9798390387307	40.7700761090896	3A-PM-1017-07	03A	PM	10172018	7	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	0	0	1	0	1	0	POINT (-73.9798390387307 40.7700761090896)
1276	-73.9798005188704	40.7691868791734	3A-PM-1017-01	03A	PM	10172018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	0	0	1	0	1	0	POINT (-73.97980051887042 40.7691868791734)
1297	-73.9802831706033	40.7692763295564	3A-AM-1012-02	03A	AM	10122018	2	Adult	Gray	Black, Cinnamon	Gray+Black, Cinnamon	Gray & Cinnamon selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments.	Above Ground	1	1	0	0	1	0	1	POINT (-73.9802831706033 40.7692763295564)
1474	-73.9801971465604	40.7697081749827	3A-PM-1017-04	03A	PM	10172018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	0	1	0	1	0	POINT (-73.9801971465604 40.7697081749827)
1712	-73.9801899519657	40.7695777009264	3A-PM-1017-02	03A	PM	10172018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	0	0	1	0	0	0	POINT (-73.9801899519657 40.7695777009264)