squirrels

Custom SQL query returning 14 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 "Hectare Squirrel Number" = :p1 and "Shift" = :p2 order by Climbing 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 flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
209	-73.97107601968679	40.7725506006789	10F-PM-1019-02	10F	PM	10192018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Cinnamon head & stripe	Ground Plane	FALSE	Behind fence, grass	1	0	0	0	0	0	1	0	0	1		POINT (-73.9710760196868 40.7725506006789)
638	-73.9562765288004	40.78806179638679	31I-PM-1019-02	31I	PM	10192018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	0	0	0	1	0		POINT (-73.9562765288004 40.7880617963868)
1009	-73.9636551433178	40.790157281877605	30B-PM-1019-02	30B	PM	10192018	2	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		0	1	0	1	1	0	1	0	0	1		POINT (-73.9636551433178 40.7901572818776)
1186	-73.96740331258341	40.7769132902037	15G-PM-1019-02	15G	PM	10192018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	0	0	0	0	1		POINT (-73.9674033125834 40.7769132902037)
1372	-73.95283537022091	40.7976456178263	41F-PM-1019-02	41F	PM	10192018	2				+					0	0	0	0	0	0	0	0	0	0		POINT (-73.9528353702209 40.7976456178263)
1833	-73.962516494651	40.788476898990204	28D-PM-1019-02	28D	PM	10192018	2	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1	0	0	0	0	1		POINT (-73.962516494651 40.7884768989902)
1956	-73.98089749771201	40.7690578709841	2A-PM-1019-02	02A	PM	10192018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0	1	0	0	0	0		POINT (-73.980897497712 40.7690578709841)
2488	-73.97269208477921	40.779411746388895	16A-PM-1019-02	16A	PM	10192018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1	0	1	0	0	1	scared by dog	POINT (-73.9726920847792 40.7794117463889)
2509	-73.97142951022491	40.776954371947	14D-PM-1019-02	14D	PM	10192018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0	0	0	0	0	0		POINT (-73.9714295102249 40.776954371947)
2688	-73.9799302952205	40.767720720979796	1B-PM-1019-02	01B	PM	10192018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0	0	0	0	1	0		POINT (-73.9799302952205 40.7677207209798)
2834	-73.9651132904127	40.7905384124102	29A-PM-1019-02	29A	PM	10192018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1	0	0	0	1	0		POINT (-73.9651132904127 40.7905384124102)
2904	-73.97203897567171	40.7763524091989	13C-PM-1019-02	13C	PM	10192018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0	0	1	0	1	0		POINT (-73.9720389756717 40.7763524091989)
1265	-73.96035971176191	40.7824399298414	23I-PM-1019-02	23I	PM	10192018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	1	0	0	0	0	0	0	0		POINT (-73.9603597117619 40.7824399298414)
2380	-73.97613757295049	40.766223189212496	1F-PM-1019-02	01F	PM	10192018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2		0	0	1	1	0	0	0	1	0	0		POINT (-73.9761375729505 40.7662231892125)