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 Climbing 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	Chasing	Climbing	Eating	Foraging	Other Activities	Kuks	Tail flags	Tail twitches	Approaches	Runs from	Lat/Long
959	-73.97461330580771	40.7760646554109	11B-PM-1014-04	11B	PM	10142018	4		Gray		Gray+		Ground Plane	FALSE	0	0	0	0	1	jumping	0	0	0	0	0	POINT (-73.9746133058077 40.776064655410906)
1673	-73.9746940851342	40.7760966488186	11B-PM-1014-02	11B	PM	10142018	2	Juvenile	Gray		Gray+		Above Ground	10	0	1	0	0	0		0	0	0	0	0	POINT (-73.9746940851342 40.7760966488186)
1831	-73.9746877519291	40.7761402808083	11B-PM-1014-03	11B	PM	10142018	3		Gray		Gray+		Above Ground	10	0	1	0	0	0		0	0	0	0	0	POINT (-73.9746877519291 40.7761402808083)
1926	-73.9742811484852	40.775533619083	11B-PM-1014-08	11B	PM	10142018	8		Gray		Gray+		Above Ground	10	0	1	0	0	0		0	0	0	0	0	POINT (-73.97428114848522 40.775533619083)
1944	-73.97432920664129	40.7756090404121	11B-AM-1007-05	11B	AM	10072018	5	Adult	Gray		Gray+		Ground Plane	FALSE	0	0	0	1	1		0	1	0	1	0	POINT (-73.9743292066413 40.7756090404121)
2512	-73.974275954985	40.775472387930705	11B-AM-1007-02	11B	AM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE	0	1	0	0	0		0	0	0	0	0	POINT (-73.974275954985 40.7754723879307)
2524	-73.9743877909071	40.7754706115974	11B-AM-1007-03	11B	AM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE	0	1	0	0	0		0	0	0	0	0	POINT (-73.9743877909071 40.7754706115974)
2566	-73.9744226682925	40.77556257172729	11B-AM-1007-04	11B	AM	10072018	4	Adult	Gray		Gray+		Ground Plane	FALSE	0	0	0	1	1		0	0	0	0	0	POINT (-73.9744226682925 40.7755625717273)
2707	-73.97431653210991	40.775467467857396	11B-PM-1014-07	11B	PM	10142018	7		Gray		Gray+		Above Ground	10	1	0	0	1	1		0	0	0	0	0	POINT (-73.9743165321099 40.7754674678574)
2998	-73.97520792474191	40.775537697900205	11B-AM-1007-01	11B	AM	10072018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	1	0	0	0	0		0	0	1	1	0	POINT (-73.9752079247419 40.7755376979002)
1206	-73.97487092063541	40.77608025411	11B-PM-1014-01	11B	PM	10142018	1	Adult	Gray		Gray+	Fat!	Above Ground	10	0	0	1	0	0		1	0	0	0	1	POINT (-73.9748709206354 40.77608025411)