squirrels

Custom SQL query returning 8 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 "Date" = :p0 and "Foraging" = :p1 and "Hectare Squirrel Number" = :p2 order by Moans 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	Climbing	Eating	Foraging	Tail twitches	Indifferent	Runs from	Lat/Long
134	-73.9575943815564	40.7933755266787	35E-PM-1006-07	35E	PM	10062018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	1	0	1	1	POINT (-73.9575943815564 40.7933755266787)
816	-73.9785300509908	40.772112774842704	6A-AM-1006-07	06A	AM	10062018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	1	1	1	0	POINT (-73.9785300509908 40.7721127748427)
1209	-73.97631591531379	40.7705785330431	5C-AM-1006-07	05C	AM	10062018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1	0	POINT (-73.9763159153138 40.7705785330431)
1243	-73.97455562298549	40.767292104099795	3F-AM-1006-07	03F	AM	10062018	7	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	close to tall tree & light post	0	0	1	0	1	0	POINT (-73.9745556229855 40.7672921040998)
1334	-73.957134662576	40.7872395604122	30I-PM-1006-07	30I	PM	10062018	7	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	1	0	0	1	POINT (-73.957134662576 40.7872395604122)
1659	-73.96904988769441	40.7700011818847	8I-AM-1006-07	08I	AM	10062018	7	Adult	Gray	White	Gray+White	White ring on short tail	Above Ground	20		1	0	1	0	1	0	POINT (-73.9690498876944 40.7700011818847)
2066	-73.9784610031588	40.7668839966177	1D-AM-1006-07	01D	AM	10062018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	1	1	1	0	0	POINT (-73.9784610031588 40.7668839966177)
2623	-73.9604482901468	40.7898646293603	31E-PM-1006-07	31E	PM	10062018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1	0	POINT (-73.9604482901468 40.7898646293603)