squirrels

Custom SQL query returning 7 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 "Date" = :p0 and "Indifferent" = :p1 and ([Specific Location] > :p3 or ([Specific Location] = :p3 and rowid > :p2)) order by [Specific Location], rowid 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	Climbing	Foraging	Indifferent	Lat/Long
1941	-73.97047902632241	40.776227064566605	13E-AM-1017-01	13E	AM	10172018	1	Adult	Gray		Gray+	Ground Plane	FALSE	in middle of path	0	0	0	1	1	POINT (-73.9704790263224 40.7762270645666)
1857	-73.9728797531377	40.778673314868705	15B-PM-1017-01	15B	PM	10172018	1		Gray		Gray+	Above Ground	20	in tree	0	0	1	1	1	POINT (-73.9728797531377 40.7786733148687)
805	-73.97068515461841	40.7780777016038	15D-PM-1017-04	15D	PM	10172018	4	Adult	Cinnamon		Cinnamon+	Above Ground	2	on fence	1	0	0	0	1	POINT (-73.9706851546184 40.7780777016038)
1179	-73.9696762034757	40.7704883494264	8H-AM-1017-02	08H	AM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	7	root bed of tree	1	0	0	1	1	POINT (-73.9696762034757 40.7704883494264)
542	-73.9713487591577	40.7784353043714	15C-PM-1017-03	15C	PM	10172018	3	Adult	Black		Black+	Above Ground	17	running across overpass	1	0	0	0	1	POINT (-73.9713487591577 40.7784353043714)
1182	-73.9667206046912	40.777999356509795	17G-PM-1017-04	17G	PM	10172018	4	Adult	Gray	White	Gray+White	Above Ground	10	tree & ground	1	1	1	0	1	POINT (-73.9667206046912 40.7779993565098)
2071	-73.96676944398949	40.7779501809095	17G-PM-1017-03	17G	PM	10172018	3	Adult	Gray	White	Gray+White	Above Ground	10	tree & ground	1	1	1	0	1	POINT (-73.9667694439895 40.7779501809095)