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 "Hectare Squirrel Number" = :p0 and "Indifferent" = :p1 and (latitude > :p3 or (latitude = :p3 and rowid > :p2)) order by latitude, 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	Climbing	Eating	Foraging	Kuks	Tail flags	Indifferent	Runs from	Lat/Long
814	-73.9607608482656	40.7954687648248	36A-PM-1013-06	36A	PM	10132018	6		Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	EDGE OF WOODS	0	0	1	0	0	0	1	0	POINT (-73.9607608482656 40.7954687648248)
2588	-73.95810074370941	40.795940311272204	38C-AM-1019-06	38C	AM	10192018	6	Adult	Gray		Gray+	Above Ground	23		0	1	0	0	1	1	1	0	POINT (-73.9581007437094 40.7959403112722)
393	-73.9577212629651	40.796552529672205	38C-PM-1014-06	38C	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	1	1	0	0	1	0	POINT (-73.9577212629651 40.7965525296722)
378	-73.95848354168459	40.7978213396921	39B-PM-1014-06	39B	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	10		0	1	0	0	0	0	1	0	POINT (-73.9584835416846 40.7978213396921)
81	-73.9578237168359	40.7980959471034	40B-PM-1014-06	40B	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0	0	0	1	0	POINT (-73.9578237168359 40.7980959471034)
1886	-73.956806913988	40.7987736900857	41C-AM-1017-06	41C	AM	10172018	6	Adult	Gray		Gray+	Above Ground	4		0	1	0	0	1	0	1	0	POINT (-73.956806913988 40.7987736900857)
2720	-73.9566300789162	40.7993692120774	42C-PM-1013-06	42C	PM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	Between park and main drag	0	1	1	0	0	0	1	1	POINT (-73.9566300789162 40.7993692120774)