squirrels

Custom SQL query returning 14 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 "Climbing" = :p0 and "Hectare" = :p1 and "Tail twitches" = :p2 order by [Lat/Long] 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	Running	Chasing	Eating	Foraging	Other Activities	Indifferent	Lat/Long
2889	-73.9771646835311	40.769304916508396	4C-PM-1010-05	04C	PM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0		0	POINT (-73.9771646835311 40.7693049165084)
1909	-73.9772070122251	40.7694343352509	4C-PM-1010-02	04C	PM	10102018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		1	0	0	1		1	POINT (-73.97720701222511 40.7694343352509)
2107	-73.9772624834791	40.769282191854295	4C-PM-1010-05	04C	PM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0		0	POINT (-73.9772624834791 40.7692821918543)
1448	-73.9772810073685	40.7693577540392	4C-PM-1010-03	04C	PM	10102018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	1	0	1		1	POINT (-73.9772810073685 40.7693577540392)
1567	-73.97744073625871	40.7698056129554	4C-PM-1010-12	04C	PM	10102018	12	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	1		0	POINT (-73.9774407362587 40.7698056129554)
678	-73.977447585355	40.769716782800295	4C-PM-1010-11	04C	PM	10102018	11	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	1	0		0	POINT (-73.977447585355 40.7697167828003)
1580	-73.9775079672882	40.7691500357424	4C-PM-1010-07	04C	PM	10102018	7	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1		1	POINT (-73.9775079672882 40.7691500357424)
1822	-73.9775099290913	40.76976090631371	4C-PM-1010-14	04C	PM	10102018	14	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		1	1	0	0	chasing #15	0	POINT (-73.9775099290913 40.7697609063137)
2644	-73.97754454411941	40.7697096533728	4C-PM-1010-13	04C	PM	10102018	13	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		1	0	0	1		0	POINT (-73.9775445441194 40.7697096533728)
729	-73.97760445784459	40.7697607308033	4C-PM-1010-15	04C	PM	10102018	15	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground		on tree	0	1	0	0	chasing #14	1	POINT (-73.9776044578446 40.7697607308033)
2633	-73.9776151109912	40.7694681558386	4C-PM-1010-09	04C	PM	10102018	9	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	1	0	1		0	POINT (-73.9776151109912 40.7694681558386)
1996	-73.977641787698	40.769583026578395	4C-PM-1010-10	04C	PM	10102018	10	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	0	0	1		0	POINT (-73.977641787698 40.7695830265784)
2403	-73.97778796352159	40.769359455673	4C-AM-1006-03	04C	AM	10062018	3	Juvenile	Gray		Gray+	Above Ground	10		0	0	0	1		0	POINT (-73.9777879635216 40.769359455673)
1827	-73.97797608743551	40.769823093658296	4C-PM-1010-16	04C	PM	10102018	16	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	1	1		1	POINT (-73.9779760874355 40.7698230936583)