squirrels

Custom SQL query returning 11 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 "Date" = :p1 and "Hectare Squirrel Number" = :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	Chasing	Climbing	Eating	Foraging	Other Activities	Indifferent	Lat/Long
279	-73.9550082056509	40.7894521543449	33I-AM-1008-03	33I	AM	10082018	3	Adult	Gray		Gray+	Above Ground	2	98th @ edge of park	0	0	1	0	0		1	POINT (-73.9550082056509 40.7894521543449)
665	-73.95636612568751	40.796682311450795	39D-AM-1008-03	39D	AM	10082018	3	Adult	Gray		Gray+	Above Ground	5		0	0	1	0	0		0	POINT (-73.9563661256875 40.7966823114508)
695	-73.96850806398729	40.774530979415495	13G-PM-1008-03	13G	PM	10082018	3	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Above Ground	20	maple tree	0	0	1	0	0		1	POINT (-73.9685080639873 40.77453097941551)
1116	-73.9729847109778	40.774070904960205	10D-AM-1008-03	10D	AM	10082018	3	Adult	Gray	White	Gray+White	Above Ground	10		0	0	1	0	0		0	POINT (-73.9729847109778 40.7740709049602)
1569	-73.973047824163	40.7700873791211	7F-AM-1008-03	07F	AM	10082018	3	Adult	Gray		Gray+	Above Ground	10		0	0	1	0	0		1	POINT (-73.973047824163 40.7700873791211)
1610	-73.9607056611532	40.788978610387105	30E-AM-1008-03	30E	AM	10082018	3	Adult	Gray		Gray+	Above Ground	6		0	0	1	0	0		1	POINT (-73.9607056611532 40.7889786103871)
2452	-73.9727323797981	40.766903546395504	3H-AM-1008-03	03H	AM	10082018	3	Adult	Gray		Gray+	Above Ground	40	building nest	0	0	1	0	0		1	POINT (-73.9727323797981 40.7669035463955)
2485	-73.9584950620879	40.790277071064295	32F-PM-1008-03	32F	PM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		1	1	1	1	1		1	POINT (-73.9584950620879 40.7902770710643)
2528	-73.96765297807241	40.7823206990549	21D-PM-1008-03	21D	PM	10082018	3	Adult	Gray	White	Gray+White	Above Ground	4		0	0	1	0	0		0	POINT (-73.9676529780724 40.7823206990549)
1715	-73.97457091090558	40.7672225695415	3G-AM-1008-03	03G	AM	10082018	3	Adult	Gray		Gray+	Above Ground	40		1	0	1	0	0	in tree	1	POINT (-73.9745709109056 40.7672225695415)
2015	-73.9574365550758	40.7886924675052	31H-PM-1008-03	31H	PM	10082018	3	Adult	Gray		Gray+	Above Ground		no clue, way up a tree!	0	0	1	0	1	throwing down acorns	0	POINT (-73.9574365550758 40.7886924675052)