squirrels

Custom SQL query returning 18 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 "Hectare Squirrel Number" = :p0 and "Indifferent" = :p1 and "Running" = :p2 order by [Above Ground Sighter Measurement] 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	Other Activities	Tail flags	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
1695	-73.9604083891356	40.7910284106931	32D-AM-1013-05	32D	AM	10132018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		1	0	1	0		0	0	1	0		POINT (-73.9604083891356 40.7910284106931)
1394	-73.95488263914001	40.7959474571251	39F-AM-1014-05	39F	AM	10142018	5	Juvenile	Cinnamon		Cinnamon+		Above Ground	2	up/down tree	1	1	0	1		0	1	1	0		POINT (-73.95488263914 40.7959474571251)
2157	-73.9657171357842	40.7773277532224	16H-PM-1014-05	16H	PM	10142018	5	Adult	Gray	White	Gray+White		Above Ground	5	tree	1	1	0	1		0	1	1	0		POINT (-73.9657171357842 40.7773277532224)
1020	-73.97016933635	40.770545252978295	8H-AM-1017-05	08H	AM	10172018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	6		1	0	1	1		0	0	1	0		POINT (-73.97016933635001 40.7705452529783)
562	-73.972467515471	40.7659131865172	3I-PM-1013-05	03I	PM	10132018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0		0	0	1	0		POINT (-73.972467515471 40.7659131865172)
928	-73.96704295859901	40.778437071937105	17F-AM-1007-05	17F	AM	10072018	5	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	1	0		1	0	1	0		POINT (-73.967042958599 40.7784370719371)
1141	-73.9664669369583	40.7774085361976	16G-AM-1010-05	16G	AM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0		0	0	1	0		POINT (-73.9664669369583 40.7774085361976)
1188	-73.9669529835992	40.787186415136496	25A-AM-1013-05	25A	AM	10132018	5		Gray		Gray+		Ground Plane	FALSE	CROSS BRIDLE - INTO TREE TO AVOID DOGGO	1	1	0	0	d.p.t.	1	1	1	0	calm	POINT (-73.96695298359921 40.7871864151365)
1403	-73.9761632586697	40.7741085606149	9B-PM-1013-05	09B	PM	10132018	5	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0		1	0	1	0		POINT (-73.9761632586697 40.7741085606149)
1456	-73.97142424264959	40.774453579812295	11E-PM-1012-05	11E	PM	10122018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	1	1	foraging (foraged,ran to tree root,munched)	0	0	1	0		POINT (-73.9714242426496 40.7744535798123)
1604	-73.9734644470766	40.7782766486921	14A-PM-1014-05	14A	PM	10142018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0		0	0	1	0		POINT (-73.97346444707661 40.7782766486921)
1682	-73.97592584072879	40.7667622711142	2F-PM-1014-05	02F	PM	10142018	5	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0		0	0	1	0		POINT (-73.9759258407288 40.7667622711142)
2032	-73.9590157104896	40.7956884493421	37C-PM-1013-05	37C	PM	10132018	5	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0		0	0	1	0		POINT (-73.9590157104896 40.7956884493421)
2155	-73.9538938706987	40.7981150065974	42E-PM-1012-05	42E	PM	10122018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	1		0	0	1	0		POINT (-73.9538938706987 40.7981150065974)
2483	-73.9596083366477	40.7949526729608	36C-PM-1013-05	36C	PM	10132018	5	Adult	Cinnamon		Cinnamon+	"Warm brown" written in for Primary.	Ground Plane	FALSE	Ran across path in front of people	1	0	1	1		0	1	1	1		POINT (-73.9596083366477 40.7949526729608)
2581	-73.9635981227569	40.7928169540326	32A-AM-1018-05	32A	AM	10182018	5	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0		0	0	1	0		POINT (-73.9635981227569 40.7928169540326)
2907	-73.96852016269341	40.783329261225	21B-AM-1019-05	21B	AM	10192018	5	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1		0	0	1	0		POINT (-73.9685201626934 40.783329261225)
2923	-73.9672160533827	40.7830263908749	21C-AM-1014-05	21C	AM	10142018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0		1	0	1	0		POINT (-73.9672160533827 40.7830263908749)