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 "Highlight Fur Color" = :p0 and "Indifferent" = :p1 and "Runs from" = :p2 order by longitude 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	Specific Location	Running	Climbing	Eating	Foraging	Kuks	Quaas	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
779	-73.9745305540008	40.7742043234014	10C-PM-1013-02	10C	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	1	0	0	0	1	0	1	1		POINT (-73.9745305540008 40.7742043234014)
2424	-73.9684752839242	40.776581626151795	15F-AM-1007-01	15F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO	Ground Plane	FALSE		1	0	1	1	0	0	0	0	0	1	1		POINT (-73.9684752839242 40.7765816261518)
232	-73.9624184586031	40.7921524868211	32B-AM-1017-03	32B	AM	10172018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0	0	0	1	1	1	1	approaches (primarily),runs from (initially),follows	POINT (-73.9624184586031 40.7921524868211)
2731	-73.9595886063173	40.7918405182594	33D-AM-1017-09	33D	AM	10172018	9	Adult	Black	Cinnamon	Black+Cinnamon		Above Ground	7		0	1	0	0	1	1	0	0	0	1	1		POINT (-73.9595886063173 40.7918405182594)
242	-73.9590236602085	40.798263245686606	40A-AM-1010-04	40A	AM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	bottom great hill	0	0	0	1	0	0	1	0	0	1	1	dog chased	POINT (-73.9590236602085 40.7982632456866)
124	-73.9588660250232	40.7982597947515	40A-AM-1010-03	40A	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	bottom of great hill	0	0	1	1	0	0	1	0	0	1	1	dog chased	POINT (-73.9588660250232 40.7982597947515)
2828	-73.9587439756541	40.7849006107353	27I-AM-1007-04	27I	AM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0	0	0	0	0	1	1		POINT (-73.9587439756541 40.7849006107353)
2720	-73.9566300789162	40.7993692120774	42C-PM-1013-06	42C	PM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Between park and main drag	0	1	1	0	0	0	0	0	0	1	1		POINT (-73.9566300789162 40.7993692120774)
1064	-73.9540257319561	40.798408619116	42E-PM-1012-02	42E	PM	10122018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon					1	1	0	0	0	0	0	0	0	1	1		POINT (-73.9540257319561 40.798408619116)