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 "Foraging" = :p0 and "Highlight Fur Color" = :p1 and ([Hectare Squirrel Number] > :p3 or ([Hectare Squirrel Number] = :p3 and rowid > :p2)) order by [Hectare Squirrel Number], 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	Eating	Tail flags	Approaches	Indifferent	Runs from	Lat/Long
2299	-73.9605554843228	40.7901473714024	31E-PM-1006-09	31E	PM	10062018	9	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	0	0	1	0	0	1	0	POINT (-73.9605554843228 40.7901473714024)
316	-73.9540616660191	40.795155660324504	38G-PM-1020-10	38G	PM	10202018	10	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		1	0	0	0	1	0	0	1	POINT (-73.9540616660191 40.7951556603245)
1788	-73.9685567075413	40.7703797723105	8I-AM-1006-10	08I	AM	10062018	10	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	3	bush	0	0	1	0	0	0	0	1	POINT (-73.96855670754131 40.7703797723105)
2303	-73.9589470461357	40.7912817646361	33E-AM-1014-10	33E	AM	10142018	10	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	15		0	1	0	0	0	0	1	0	POINT (-73.9589470461357 40.7912817646361)
2348	-73.9531965469704	40.794743798397704	38G-PM-1020-11	38G	PM	10202018	11	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	0	0	1	1	1	1	0	POINT (-73.9531965469704 40.7947437983977)
2653	-73.958932543729	40.7913445531266	33E-AM-1014-11	33E	AM	10142018	11	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	15		0	1	0	0	0	0	1	0	POINT (-73.958932543729 40.7913445531266)
531	-73.97091043803229	40.7769096957616	14D-AM-1014-16	14D	AM	10142018	16	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	0	1	0	0	0	1	0	POINT (-73.9709104380323 40.7769096957616)