squirrels

Custom SQL query returning 16 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 "Foraging" = :p0 and "Hectare Squirrel Number" = :p1 and "Highlight Fur Color" = :p2 and "Tail twitches" = :p3 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	Location	Above Ground Sighter Measurement	Running	Climbing	Eating	Other Activities	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
733	-73.9764397550289	40.7737004557104	8B-AM-1007-01	08B	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	10	0	1	0		0	1	0	1	0		POINT (-73.9764397550289 40.7737004557104)
2896	-73.970595860252	40.7832060751268	20A-AM-1010-01	20A	AM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	10	0	1	0		0	1	0	1	0		POINT (-73.970595860252 40.7832060751268)
1235	-73.9679686793869	40.7825993867876	21C-AM-1014-01	21C	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	3	1	0	0	jumping back & forth on tree	1	1	0	1	0		POINT (-73.9679686793869 40.7825993867876)
2016	-73.9589492240754	40.798901118974	40A-PM-1014-01	40A	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	30	0	1	0		0	1	0	1	0	stared & then went back up tree—then ran to different tree	POINT (-73.9589492240754 40.798901118974)
2559	-73.95723834787741	40.787685738072206	30H-PM-1006-01	30H	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	5	0	1	0		0	1	0	1	0		POINT (-73.9572383478774 40.7876857380722)
622	-73.97548367967059	40.7738879545412	9B-PM-1013-01	09B	PM	10132018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	0	0	0	playing	0	1	0	1	0		POINT (-73.9754836796706 40.7738879545412)
720	-73.9669814346326	40.780390919948	19E-PM-1018-01	19E	PM	10182018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	1	0	0		0	1	0	0	1		POINT (-73.9669814346326 40.780390919948)
837	-73.9557172336815	40.79211256577221	35G-PM-1006-01	35G	PM	10062018	1	Adult	Black	Cinnamon	Black+Cinnamon	Ground Plane	FALSE	1	1	0		0	1	0	0	1		POINT (-73.9557172336815 40.7921125657722)
860	-73.97135191580271	40.7798470142991	17B-AM-1010-01	17B	AM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	0	0	1		0	1	0	1	0		POINT (-73.9713519158027 40.7798470142991)
884	-73.96789372898371	40.7782808361645	16E-PM-1018-01	16E	PM	10182018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	1	0	0		0	1	0	1	0		POINT (-73.9678937289837 40.7782808361645)
1111	-73.96327993398721	40.7808316436308	21H-PM-1018-01	21H	PM	10182018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	0	0	0	staring	0	1	1	0	0		POINT (-73.9632799339872 40.7808316436308)
1316	-73.9674724790652	40.7768771349868	15G-PM-1019-01	15G	PM	10192018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	0	0	1		0	1	0	1	0		POINT (-73.9674724790652 40.7768771349868)
1511	-73.9721642509914	40.7701179390078	7G-AM-1010-01	07G	AM	10102018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	1	0	0		0	1	0	1	0		POINT (-73.9721642509914 40.7701179390078)
2324	-73.9737247632185	40.7759469280872	12C-PM-1017-01	12C	PM	10172018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	1	0	1	digging/burying,drinking from lake	0	1	0	1	0		POINT (-73.9737247632185 40.7759469280872)
2342	-73.9533645762606	40.7983709215535	42F-AM-1019-01	42F	AM	10192018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	0	0	0		0	1	0	0	1	runs from (me)	POINT (-73.9533645762606 40.7983709215535)
2382	-73.97439704555329	40.7687880243986	5F-PM-1007-01	05F	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	0	0	1		0	1	0	1	0		POINT (-73.9743970455533 40.7687880243986)