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 "Above Ground Sighter Measurement" = :p0 and "Date" = :p1 order by [Other Activities] 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	Climbing	Eating	Foraging	Kuks	Tail twitches	Indifferent	Runs from	Lat/Long
98	-73.9730277911422	40.771214548882796	7F-AM-1008-16	07F	AM	10082018	16	Juvenile	Gray		Gray+	Above Ground	2	tree	0	0	0	0	0	0	0	1	POINT (-73.9730277911422 40.7712145488828)
279	-73.9550082056509	40.7894521543449	33I-AM-1008-03	33I	AM	10082018	3	Adult	Gray		Gray+	Above Ground	2	98th @ edge of park	0	1	0	0	0	0	1	0	POINT (-73.9550082056509 40.7894521543449)
377	-73.9757001944781	40.769499790547	5E-AM-1008-09	05E	AM	10082018	9	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	2	went up tree	1	0	0	0	0	0	1	0	POINT (-73.9757001944781 40.769499790547)
426	-73.9741944367138	40.7769889953596	13B-PM-1008-01	13B	PM	10082018	1	Adult	Gray	White	Gray+White	Above Ground	2	on railing	1	0	0	0	0	0	1	0	POINT (-73.9741944367138 40.7769889953596)
1696	-73.96945916677049	40.776651822199796	14E-AM-1008-12	14E	AM	10082018	12	Adult	Gray		Gray+	Above Ground	2		0	1	1	1	0	0	1	0	POINT (-73.9694591667705 40.7766518221998)
1940	-73.9696445614055	40.779148620362704	17D-AM-1008-05	17D	AM	10082018	5	Juvenile	Gray		Gray+	Above Ground	2		0	1	0	0	0	0	1	0	POINT (-73.9696445614055 40.7791486203627)
2515	-73.9693338657183	40.775705588453796	13F-PM-1008-05	13F	PM	10082018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	2	tree trunk	1	0	1	1	1	1	0	0	POINT (-73.9693338657183 40.77570558845381)
2706	-73.9745141185576	40.76914797812071	5E-AM-1008-01	05E	AM	10082018	1	Adult	Gray	White	Gray+White	Above Ground	2	on a checker table	0	0	1	0	0	0	1	0	POINT (-73.9745141185576 40.7691479781207)