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 "Eating" = :p0 and "Foraging" = :p1 and "Primary Fur Color" = :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	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
42	-73.9579564338627	40.795933779502704	38C-PM-1014-09	38C	PM	10142018	9	Adult	Black		Black+	Ground Plane	FALSE		0	0	1	0	0	1	0	0		POINT (-73.9579564338627 40.7959337795027)
130	-73.95816559494371	40.799770819002205	41A-PM-1007-06	41A	PM	10072018	6	Adult	Black		Black+	Ground Plane	FALSE		1	1	1	0	0	0	0	1		POINT (-73.9581655949437 40.7997708190022)
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	0	0		POINT (-73.9711298491132 40.7676902603543)
381	-73.959709414696	40.7919745085986	33D-PM-1006-03	33D	PM	10062018	3		Black		Black+	Above Ground	15		1	0	1	0	1	0	0	1	ran up tree	POINT (-73.959709414696 40.7919745085986)
731	-73.97335458025151	40.7675056025357	4G-AM-1006-04	04G	AM	10062018	4	Adult	Black		Black+	Ground Plane	FALSE		0	0	1	0	0	0	1	0		POINT (-73.9733545802515 40.7675056025357)
1223	-73.95912985511109	40.7919612446005	33E-AM-1014-04	33E	AM	10142018	4	Adult	Black	Cinnamon, White	Black+Cinnamon, White	Ground Plane	FALSE		1	0	1	0	0	0	1	0		POINT (-73.9591298551111 40.7919612446005)
1261	-73.9719109949232	40.772313852132704	9F-AM-1013-01	09F	AM	10132018	1	Adult	Black		Black+	Ground Plane	FALSE		0	0	1	0	0	0	0	1		POINT (-73.9719109949232 40.7723138521327)
1296	-73.97055091705421	40.7689416540228	6I-PM-1013-04	06I	PM	10132018	4	Adult	Black	Gray	Black+Gray	Ground Plane	FALSE	Grass	0	0	1	0	1	0	0	0		POINT (-73.9705509170542 40.7689416540228)
1307	-73.9565197137317	40.7986011403785	41C-PM-1007-01	41C	PM	10072018	1	Adult	Black		Black+	Ground Plane	FALSE		1	0	1	0	0	0	0	1		POINT (-73.9565197137317 40.7986011403785)
1345	-73.95813265542058	40.7918074743129	34E-PM-1006-02	34E	PM	10062018	2	Juvenile	Black	Gray, White	Black+Gray, White	Ground Plane	FALSE		0	0	1	0	1	0	0	1		POINT (-73.9581326554206 40.7918074743129)
1528	-73.9690104245067	40.7853358193723	23A-AM-1018-02	23A	AM	10182018	2	Juvenile	Black		Black+	Ground Plane	FALSE		0	0	1	0	0	0	1	0		POINT (-73.9690104245067 40.7853358193723)
2120	-73.9733905460282	40.7656337147768	2H-PM-1006-03	02H	PM	10062018	3	Adult	Black		Black+	Ground Plane	FALSE		0	0	1	0	0	0	1	0		POINT (-73.9733905460282 40.7656337147768)
2159	-73.9696688162449	40.774142217718705	12F-AM-1020-05	12F	AM	10202018	5	Adult	Black	Cinnamon	Black+Cinnamon	Ground Plane	FALSE		0	0	1	0	1	0	0	0		POINT (-73.9696688162449 40.7741422177187)
2270	-73.9703732649257	40.77019793771029	8H-PM-1014-04	08H	PM	10142018	4	Adult	Black		Black+	Ground Plane	FALSE		0	0	1	0	0	0	1	0		POINT (-73.97037326492571 40.7701979377103)
2325	-73.9728360875598	40.7660637295671	3H-PM-1014-04	03H	PM	10142018	4	Adult	Black	Cinnamon	Black+Cinnamon	Ground Plane	FALSE		0	0	1	0	0	0	1	0		POINT (-73.9728360875598 40.7660637295671)
2433	-73.9706949930717	40.772362045852	10G-AM-1006-08	10G	AM	10062018	8	Adult	Black	Cinnamon	Black+Cinnamon	Above Ground	3		0	0	1	1	1	0	1	0		POINT (-73.9706949930717 40.772362045852)
2496	-73.96962742914171	40.7691980808067	7I-PM-1013-03	07I	PM	10132018	3	Adult	Black	Gray	Black+Gray	Ground Plane	FALSE	Trash bins	0	0	1	0	0	0	0	0		POINT (-73.9696274291417 40.7691980808067)
2879	-73.9744080700098	40.773151572182606	9C-PM-1006-07	09C	PM	10062018	7	Adult	Black	Cinnamon, White	Black+Cinnamon, White	Ground Plane	FALSE	on top of tarped sand pile	0	0	1	0	0	0	0	1	(me)	POINT (-73.9744080700098 40.7731515721826)