squirrels

Custom SQL query returning 18 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 ([Highlight Fur Color] > :p2 or ([Highlight Fur Color] = :p2 and rowid > :p1)) order by [Highlight Fur Color], 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	Color notes	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Climbing	Eating	Foraging	Other Activities	Tail flags	Tail twitches	Indifferent	Runs from	Lat/Long
2250	-73.95890163858891	40.7911727679625	33E-PM-1012-03	33E	PM	10122018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	POINT (-73.9589016385889 40.7911727679625)
2277	-73.95385121459	40.7981257651433	42E-PM-1012-04	42E	PM	10122018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	1	0	POINT (-73.95385121459 40.7981257651433)
2304	-73.9715251156965	40.774621784862	11E-PM-1012-07	11E	PM	10122018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	1	0	POINT (-73.9715251156965 40.774621784862)
2306	-73.956453902485	40.7936584431012	36F-PM-1012-05	36F	PM	10122018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	1	0	POINT (-73.956453902485 40.7936584431012)
2317	-73.97673696861709	40.7735074437085	8B-PM-1012-05	08B	PM	10122018	5	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	1	1	1		0	0	1	0	POINT (-73.9767369686171 40.7735074437085)
2328	-73.9678620840741	40.784719027304	23B-PM-1012-03	23B	PM	10122018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	1	2/3 were chasing each other	0	1	0	1	POINT (-73.96786208407411 40.784719027304)
2390	-73.9680741975294	40.7847036778165	23B-PM-1012-04	23B	PM	10122018	4	Adult	Gray	White	Gray+White		Above Ground	20		0	0	0	0	0	watching me - didn't move	0	1	0	1	POINT (-73.9680741975294 40.7847036778165)
2394	-73.97858295460459	40.7719652299132	6A-PM-1012-02	06A	PM	10122018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	1	1	0	0		0	0	0	0	POINT (-73.9785829546046 40.7719652299132)
2405	-73.9588361742943	40.791115225155	33E-PM-1012-02	33E	PM	10122018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	POINT (-73.9588361742943 40.791115225155)
2430	-73.9569811285656	40.793091234605	35F-PM-1012-02	35F	PM	10122018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	1	1	0	POINT (-73.9569811285656 40.793091234605)
2494	-73.9713968424625	40.774039018852704	11E-PM-1012-03	11E	PM	10122018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	POINT (-73.9713968424625 40.7740390188527)
2591	-73.9786351029146	40.771611416400205	6A-PM-1012-06	06A	PM	10122018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE	elevated ground	0	1	0	0	1		1	0	1	0	POINT (-73.9786351029146 40.771611416400205)
2617	-73.9564228238736	40.7936908887644	36F-PM-1012-06	36F	PM	10122018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	POINT (-73.9564228238736 40.7936908887644)
2691	-73.9564599077179	40.7965185098695	39D-PM-1012-01	39D	PM	10122018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	1	0	POINT (-73.9564599077179 40.7965185098695)
2742	-73.96280415779341	40.7884180156055	28D-AM-1012-06	28D	AM	10122018	6	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	5		0	0	0	1	0		0	0	0	1	POINT (-73.9628041577934 40.78841801560551)
2745	-73.97296259363002	40.7652601851275	1I-PM-1012-04	01I	PM	10122018	4	Juvenile	Cinnamon	White	Cinnamon+White	Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Above Ground	2	on ledge	0	0	1	0	0		0	1	0	1	POINT (-73.97296259363 40.7652601851275)
2860	-73.95651796713192	40.7936663940365	36F-PM-1012-03	36F	PM	10122018	3		Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	1	0	POINT (-73.95651796713192 40.7936663940365)
2900	-73.9631005470369	40.788549405719294	28D-AM-1012-01	28D	AM	10122018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	1		0	1	0	0	POINT (-73.9631005470369 40.7885494057193)