squirrels

Custom SQL query returning 17 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 "Highlight Fur Color" = :p2 order by 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	Kuks	Quaas	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
169	-73.97487064155841	40.7744174965072	10B-AM-1006-02	10B	AM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground		High in a tree	0	0	1	0	0		0	0	0	0	1	0		POINT (-73.9748706415584 40.7744174965072)
372	-73.9781303869038	40.7725000348875	7A-AM-1006-02	07A	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	8	in tree	0	0	1	0	0		0	0	0	0	0	1		POINT (-73.9781303869038 40.7725000348875)
419	-73.9777328709928	40.7669087724668	1D-AM-1006-02	01D	AM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	1	0	0	0		POINT (-73.9777328709928 40.7669087724668)
453	-73.959514034869	40.789911786416	31E-PM-1006-02	31E	PM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	under bushes	0	0	0	1	1		0	1	0	0	1	0		POINT (-73.959514034869 40.789911786416)
503	-73.9598340783572	40.7915857030295	33D-PM-1006-02	33D	PM	10062018	2		Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	1	0	0	0		0	0	0	0	0	1		POINT (-73.95983407835722 40.7915857030295)
504	-73.95334760207359	40.7933003544685	37H-PM-1006-02	37H	PM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	tree	1	0	1	0	1		1	0	0	0	0	1	dogs	POINT (-73.9533476020736 40.7933003544685)
738	-73.9725712588741	40.7669101832926	4H-AM-1006-02	04H	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	0	climbing (over small wire fence then on the ground)	0	0	0	1	0	1	approaches (saw me & came forward),runs from (startled by another person)	POINT (-73.9725712588741 40.7669101832926)
972	-73.9704591091677	40.7729175143429	10G-AM-1006-02	10G	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	notch on tail	Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	1		POINT (-73.9704591091677 40.7729175143429)
1035	-73.97725699096729	40.7664804797448	1E-AM-1006-02	01E	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1		0	0	1	0	1	0		POINT (-73.9772569909673 40.7664804797448)
1455	-73.9715621134573	40.7695918717513	7H-AM-1006-02	07H	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1	running (along ground,up tree)	0	0	0	0	1	0		POINT (-73.9715621134573 40.76959187175131)
1853	-73.9721210372896	40.7667971476099	4I-AM-1006-02	04I	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0		POINT (-73.9721210372896 40.7667971476099)
1921	-73.97562782402329	40.766952370137204	2F-AM-1006-02	02F	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5	in tree	0	0	1	0	0		0	0	0	0	1	0		POINT (-73.9756278240233 40.7669523701372)
1973	-73.957138759793	40.795592603505504	38D-PM-1006-02	38D	PM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	1	0	1	0		POINT (-73.957138759793 40.7955926035055)
2368	-73.9731925179247	40.7748962746181	11D-PM-1006-02	11D	PM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	1	0	0		0	0	0	0	1	0		POINT (-73.9731925179247 40.7748962746181)
2783	-73.97917671562679	40.7714445258765	5A-AM-1006-02	05A	AM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	12	in tall shrubs near wall next to CPW	0	0	1	1	0		0	0	0	0	1	0		POINT (-73.9791767156268 40.7714445258765)
2796	-73.96310890114121	40.789191946875	29C-PM-1006-02	29C	PM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0		POINT (-73.9631089011412 40.789191946875)
2870	-73.9538475741188	40.796479421955	40F-PM-1006-02	40F	PM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	6		0	0	0	0	1		0	0	0	0	1	0		POINT (-73.9538475741188 40.796479421955)