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 "Hectare" = :p0 and "Highlight Fur Color" = :p1 order by Location 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	Running	Climbing	Eating	Foraging	Other Activities	Indifferent	Other Interactions	Lat/Long
1915	-73.9797112925048	40.76880467784721	2B-PM-1013-09	02B	PM	10132018	9	Adult	Gray	White	Gray+White	Above Ground	30	1	0	0	0		0		POINT (-73.9797112925048 40.7688046778472)
2950	-73.9790980124501	40.7685934093915	2B-PM-1013-08	02B	PM	10132018	8	Adult	Gray	White	Gray+White	Above Ground	15	0	0	1	0		0		POINT (-73.9790980124501 40.7685934093915)
51	-73.9801666435401	40.7686905339212	2B-PM-1013-01	02B	PM	10132018	1	Adult	Gray	White	Gray+White	Ground Plane	FALSE	1	0	0	0	running (with nut)	0		POINT (-73.9801666435401 40.7686905339212)
1587	-73.9805517765469	40.7683044693163	2B-PM-1013-05	02B	PM	10132018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE	1	1	0	0	climbing fence!	0	snuck into bike cart!	POINT (-73.9805517765469 40.7683044693163)
2042	-73.9800896621713	40.7684379810317	2B-PM-1013-03	02B	PM	10132018	3	Adult	Gray	White	Gray+White	Ground Plane	FALSE	0	0	0	0		0		POINT (-73.9800896621713 40.7684379810317)
2116	-73.9801562527339	40.76872673271129	2B-AM-1010-01	02B	AM	10102018	1	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE	0	0	1	1		1		POINT (-73.9801562527339 40.7687267327113)
2212	-73.9801138983722	40.768572151563504	2B-PM-1013-02	02B	PM	10132018	2	Adult	Gray	White	Gray+White	Ground Plane	FALSE	0	0	0	1		0		POINT (-73.9801138983722 40.7685721515635)
2349	-73.98003374000399	40.768360829233295	2B-PM-1013-04	02B	PM	10132018	4	Adult	Gray	White	Gray+White	Ground Plane	FALSE	0	0	0	0		0		POINT (-73.980033740004 40.7683608292333)