squirrels

Custom SQL query returning 6 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 "Highlight Fur Color" = :p1 and "Running" = :p2 order by [Above Ground Sighter Measurement] 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	Foraging	Tail flags	Indifferent	Runs from	Lat/Long
1648	-73.97902633720041	40.7683513714892	2C-PM-1013-07	02C	PM	10132018	7	Adult	Gray	White	Gray+White				1	0	1	0	0	0	POINT (-73.9790263372004 40.7683513714892)
602	-73.96857515954851	40.7709413567859	9I-PM-1010-07	09I	PM	10102018	7	Adult	Gray	White	Gray+White	Above Ground	1	ran up tree	1	0	0	0	0	1	POINT (-73.9685751595485 40.7709413567859)
25	-73.96711306801141	40.7784859700171	17F-AM-1007-07	17F	AM	10072018	7	Adult	Gray	White	Gray+White	Above Ground	24		1	0	0	1	1	0	POINT (-73.9671130680114 40.7784859700171)
772	-73.95841884610591	40.7913241048498	33E-PM-1012-07	33E	PM	10122018	7	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	1	0	0	0	0	POINT (-73.9584188461059 40.7913241048498)
1889	-73.9679319758284	40.782115480239895	20C-PM-1018-07	20C	PM	10182018	7	Juvenile	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		1	0	0	0	0	0	POINT (-73.9679319758284 40.7821154802399)
2713	-73.9687214684206	40.779284172016396	17D-AM-1008-07	17D	AM	10082018	7	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	0	0	0	1	0	POINT (-73.9687214684206 40.7792841720164)