squirrels

Custom SQL query returning 9 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 "Climbing" = :p0 and "Hectare Squirrel Number" = :p1 and "Highlight Fur Color" = :p2 order by [Specific Location] 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	Tail twitches	Indifferent	Runs from	Lat/Long
354	-73.95667510223359	40.799035789744	41C-PM-1007-04	41C	PM	10072018	4	Adult	Gray	White	Gray+White		Above Ground	65		0	0	1	0	0	0	0	0	POINT (-73.9566751022336 40.799035789744)
667	-73.9624538733037	40.7883829851518	28D-AM-1012-04	28D	AM	10122018	4	Adult	Cinnamon	White	Cinnamon+White		Above Ground	10		0	0	1	0	0	0	0	1	POINT (-73.9624538733037 40.7883829851518)
2103	-73.9782983634755	40.766831436426294	1D-AM-1006-04	01D	AM	10062018	4	Adult	Gray	White	Gray+White		Above Ground	30		0	0	1	0	0	0	0	0	POINT (-73.9782983634755 40.7668314364263)
2779	-73.9767835160078	40.767403033048204	2E-PM-1014-04	02E	PM	10142018	4	Adult	Cinnamon	White	Cinnamon+White		Above Ground	15		0	0	1	0	0	0	0	1	POINT (-73.9767835160078 40.7674030330482)
1767	-73.958719099962	40.7947587726617	36C-AM-1014-04	36C	AM	10142018	4		Gray	White	Gray+White		Above Ground	15	Ground then tree to eat	1	0	1	1	0	0	0	1	POINT (-73.958719099962 40.7947587726617)
2145	-73.96512504025829	40.7812884929069	20F-PM-1007-04	20F	PM	10072018	4	Juvenile	Gray	White	Gray+White	white on tail	Above Ground	20	climbed tree	0	0	1	0	1	0	0	0	POINT (-73.9651250402583 40.7812884929069)
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	1	0	1	POINT (-73.97296259363 40.7652601851275)
2232	-73.9566277721581	40.7966674587803	39D-PM-1012-04	39D	PM	10122018	4	Juvenile	Gray	White	Gray+White		Above Ground	10	on tree trunk (descending from height of ~10 ft)	0	0	1	0	0	0	1	0	POINT (-73.95662777215811 40.7966674587803)
1182	-73.9667206046912	40.777999356509795	17G-PM-1017-04	17G	PM	10172018	4	Adult	Gray	White	Gray+White		Above Ground	10	tree & ground	1	1	1	0	0	0	1	0	POINT (-73.9667206046912 40.7779993565098)