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 "Hectare" = :p0 and "Indifferent" = :p1 order by [Unique Squirrel ID] 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	Running	Climbing	Foraging	Other Activities	Kuks	Quaas	Runs from	Lat/Long
2647	-73.954499539822	40.7949716693686	38F-AM-1018-01	38F	AM	10182018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE	1	0	0		0	0	1	POINT (-73.954499539822 40.7949716693686)
2687	-73.9550235589287	40.7951312356844	38F-AM-1018-03	38F	AM	10182018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	1	0	0		0	0	1	POINT (-73.9550235589287 40.7951312356844)
631	-73.95488778301359	40.795015748910295	38F-AM-1018-04	38F	AM	10182018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	1	0		0	0	0	POINT (-73.95488778301362 40.7950157489103)
2164	-73.955013129397	40.7954024311542	38F-AM-1018-05	38F	AM	10182018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	1	0	0	ran up tree	0	0	1	POINT (-73.955013129397 40.7954024311542)
2374	-73.9551370586201	40.7946465469021	38F-AM-1018-06	38F	AM	10182018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	0	0	hopped away	0	0	1	POINT (-73.95513705862011 40.7946465469021)
1211	-73.9549337398033	40.794655273162796	38F-PM-1013-01	38F	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon tail & belly	Ground Plane	FALSE	0	0	1		0	0	0	POINT (-73.9549337398033 40.7946552731628)
1782	-73.9549133872427	40.7946871036949	38F-PM-1013-02	38F	PM	10132018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	0	1		0	0	0	POINT (-73.9549133872427 40.7946871036949)
2668	-73.95486485185579	40.7946730924872	38F-PM-1013-03	38F	PM	10132018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	0	1		0	0	0	POINT (-73.9548648518558 40.7946730924872)
2520	-73.95482071063391	40.7946991812402	38F-PM-1013-04	38F	PM	10132018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	0	1		0	0	0	POINT (-73.9548207106339 40.7946991812402)
101	-73.9544007658685	40.7950689723135	38F-PM-1013-05	38F	PM	10132018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	0	1	being chased,was pushed by other squirrel	1	1	0	POINT (-73.9544007658685 40.7950689723135)
2434	-73.9545912098958	40.7948301813102	38F-PM-1013-06	38F	PM	10132018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	0	1		0	0	0	POINT (-73.9545912098958 40.7948301813102)