squirrels

Custom SQL query returning 13 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 "Kuks" = :p1 and "Specific Location" = :p2 order by longitude 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	Chasing	Climbing	Eating	Other Activities	Indifferent	Runs from	Lat/Long
385	-73.979316275899	40.769213472755496	3B-PM-1007-01	03B	PM	10072018	1	Adult	Gray	White	Gray+White		Above Ground		in tree	0	0	0	chased by dog	0	0	POINT (-73.979316275899 40.7692134727555)
2893	-73.97931014826541	40.7692600238491	3B-PM-1007-02	03B	PM	10072018	2	Adult	Gray		Gray+		Above Ground	10	in tree	0	0	0	chased by dog	0	0	POINT (-73.9793101482654 40.7692600238491)
126	-73.97921554736891	40.7693711799946	3B-PM-1007-11	03B	PM	10072018	11	Adult	Gray		Gray+		Above Ground	5	in tree	0	1	0		0	0	POINT (-73.9792155473689 40.7693711799946)
1864	-73.9694344956258	40.7742869276902	12G-PM-1007-01	12G	PM	10072018	1		Gray		Gray+		Above Ground	40	in tree	1	0	0		0	0	POINT (-73.9694344956258 40.7742869276902)
1649	-73.969347812694	40.7744098063421	12G-PM-1007-02	12G	PM	10072018	2		Gray		Gray+		Above Ground		in tree	1	0	0		0	0	POINT (-73.969347812694 40.7744098063421)
1727	-73.96924722995651	40.7722592187215	10H-PM-1007-01	10H	PM	10072018	1	Adult	Gray	White	Gray+White	dark gray	Above Ground	15	in tree	0	1	0		1	0	POINT (-73.9692472299565 40.7722592187215)
526	-73.9680833729772	40.774187102511505	12H-PM-1007-08	12H	PM	10072018	8				+		Above Ground	7	in tree	0	0	0		0	1	POINT (-73.9680833729772 40.7741871025115)
1109	-73.96781540330991	40.774278348448604	12H-PM-1007-01	12H	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	in tree	0	0	1		0	0	POINT (-73.9678154033099 40.7742783484486)
505	-73.9677387336667	40.774269591199996	12H-PM-1007-02	12H	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	in tree	0	1	1	peanuts	1	0	POINT (-73.9677387336667 40.7742695912)
1110	-73.96764342569759	40.78623366244479	24A-PM-1007-04	24A	PM	10072018	4	Adult	Gray		Gray+		Above Ground	50	in tree	0	1	0		0	0	POINT (-73.9676434256976 40.7862336624448)
2074	-73.9676246014119	40.786355136088	24A-PM-1007-05	24A	PM	10072018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	45	in tree	0	1	0		0	0	POINT (-73.9676246014119 40.786355136088)
2868	-73.9653873284496	40.7804699882574	20F-PM-1007-11	20F	PM	10072018	11	Adult	Gray	White	Gray+White		Above Ground	10	in tree	0	1	0		0	0	POINT (-73.9653873284496 40.7804699882574)
2730	-73.96535757586871	40.78053399533721	20F-PM-1007-12	20F	PM	10072018	12	Adult	Gray	White	Gray+White		Above Ground	20	in tree	0	1	1		0	0	POINT (-73.9653575758687 40.7805339953372)