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 "Above Ground Sighter Measurement" = :p0 and "Eating" = :p1 and "Indifferent" = :p2 order by [Other Activities] 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	Climbing	Eating	Other Activities	Tail flags	Tail twitches	Runs from	Other Interactions	Lat/Long
210	-73.97112984911321	40.76769026035429	5I-PM-1008-01	05I	PM	10082018	1	Adult	Black	Cinnamon	Black+Cinnamon	Above Ground	15	in tree by arsenal - climbing	0	1	1		1	0	0		POINT (-73.9711298491132 40.7676902603543)
317	-73.9545799024508	40.7908084039886	34I-PM-1010-01	34I	PM	10102018	1	Adult	Gray		Gray+	Above Ground	15		0	0	1		0	0	0		POINT (-73.9545799024508 40.7908084039886)
331	-73.95448101115	40.7954469678857	39F-PM-1006-03	39F	PM	10062018	3	Adult	Gray	White	Gray+White	Above Ground	15	lower branch of tree	0	0	1		0	0	1	ran up tree when approached	POINT (-73.95448101115 40.7954469678857)
381	-73.959709414696	40.7919745085986	33D-PM-1006-03	33D	PM	10062018	3		Black		Black+	Above Ground	15		1	0	1		0	1	1	ran up tree	POINT (-73.959709414696 40.7919745085986)
1624	-73.97370600439879	40.772566022498296	8D-AM-1007-05	08D	AM	10072018	5	Adult	Gray		Gray+	Above Ground	15		0	0	1		0	0	0		POINT (-73.9737060043988 40.7725660224983)
1767	-73.958719099962	40.7947587726617	36C-AM-1014-04	36C	AM	10142018	4		Gray	White	Gray+White	Above Ground	15	Ground then tree to eat	1	1	1		0	0	1		POINT (-73.958719099962 40.7947587726617)
2912	-73.9632164738341	40.7921270121312	32B-PM-1010-03	32B	PM	10102018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	15		0	0	1		0	0	0		POINT (-73.9632164738341 40.7921270121312)
2950	-73.9790980124501	40.7685934093915	2B-PM-1013-08	02B	PM	10132018	8	Adult	Gray	White	Gray+White	Above Ground	15		0	0	1		0	0	0		POINT (-73.9790980124501 40.7685934093915)
591	-73.95433237868879	40.7943086530436	37G-PM-1007-03	37G	PM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	15		0	0	1	lying on belly on branch,eating big nut	0	0	0		POINT (-73.9543323786888 40.7943086530436)