squirrels

Custom SQL query returning 13 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 "Highlight Fur Color" = :p1 order by [Hectare Squirrel Number] 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	Chasing	Eating	Foraging	Other Activities	Tail twitches	Approaches	Indifferent	Runs from	Lat/Long
1628	-73.97136652496141	40.76971786480021	7H-AM-1006-01	07H	AM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0	nut in mouth	0	0	1	0	POINT (-73.9713665249614 40.7697178648002)
1455	-73.9715621134573	40.7695918717513	7H-AM-1006-02	07H	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	1	running (along ground,up tree)	0	0	1	0	POINT (-73.9715621134573 40.76959187175131)
486	-73.971213385696	40.769872094337	7H-AM-1006-04	07H	AM	10062018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1		0	0	1	0	POINT (-73.97121338569602 40.769872094337)
20	-73.9706105896967	40.769812482150705	7H-AM-1006-05	07H	AM	10062018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	10		0	1	0	0		0	0	1	0	POINT (-73.9706105896967 40.7698124821507)
697	-73.97046560040201	40.770112577324795	7H-PM-1006-05	07H	PM	10062018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	Ran across path to eat behind fence, next to the fence.	1	0	1	1		1	0	0	1	POINT (-73.970465600402 40.7701125773248)
352	-73.970540988328	40.769810306706205	7H-AM-1006-06	07H	AM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	12		0	1	0	0		0	0	1	0	POINT (-73.970540988328 40.7698103067062)
1091	-73.97055600790999	40.7698499183436	7H-AM-1006-07	07H	AM	10062018	7	Adult	Gray	Cinnamon	Gray+Cinnamon				0	0	1	0		1	0	1	0	POINT (-73.97055600791 40.7698499183436)
1285	-73.97051151894291	40.769839557706796	7H-AM-1006-08	07H	AM	10062018	8	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1		0	1	0	0	POINT (-73.9705115189429 40.7698395577068)
1557	-73.9705331808443	40.769994357129605	7H-AM-1006-09	07H	AM	10062018	9	Adult	Gray	Cinnamon	Gray+Cinnamon				0	0	0	1		0	1	0	0	POINT (-73.9705331808443 40.7699943571296)
1469	-73.97048311770351	40.7699878995692	7H-AM-1006-10	07H	AM	10062018	10	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0		0	0	1	0	POINT (-73.9704831177035 40.7699878995692)
435	-73.9702963056917	40.7697928730791	7H-AM-1006-11	07H	AM	10062018	11	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1		0	1	0	0	POINT (-73.9702963056917 40.7697928730791)
472	-73.9702721244652	40.7701011774207	7H-AM-1006-15	07H	AM	10062018	15	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1		0	0	1	0	POINT (-73.9702721244652 40.7701011774207)
1813	-73.9706988226435	40.7696684566926	7H-AM-1006-16	07H	AM	10062018	16	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1		0	0	1	0	POINT (-73.9706988226435 40.7696684566926)