squirrels

Custom SQL query returning 24 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 "Foraging" = :p1 and "Hectare Squirrel Number" = :p2 order by [Lat/Long] 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	Other Activities	Kuks	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Lat/Long
1533	-73.95200246546021	40.794732982815496	39I-PM-1013-04	39I	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as both Primary and Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	1	playing	0	0	0	1	0	0	POINT (-73.95200246546021 40.7947329828155)
2204	-73.9532427699097	40.7962643767092	40G-PM-1013-04	40G	PM	10132018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0		0	0	0	0	1	0	POINT (-73.9532427699097 40.7962643767092)
315	-73.95397347709341	40.7956055442	39G-PM-1013-04	39G	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	1		0	0	0	0	0	0	POINT (-73.9539734770934 40.7956055442)
1034	-73.95531638295509	40.7988610926249	42D-PM-1013-04	42D	PM	10132018	4	Adult	Cinnamon	Gray	Cinnamon+Gray	Light Cinnamon	Ground Plane	FALSE		0	0	0	0	carrying nut away	0	0	0	0	1	0	POINT (-73.9553163829551 40.7988610926249)
1176	-73.9553263156025	40.79755920605721	40D-PM-1013-04	40D	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0		0	0	0	0	0	1	POINT (-73.9553263156025 40.7975592060572)
1449	-73.95611248920629	40.7949440648632	37E-AM-1013-04	37E	AM	10132018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	8		0	0	1	1		1	0	0	0	0	1	POINT (-73.9561124892063 40.7949440648632)
173	-73.95877018015099	40.793412394152796	35D-PM-1013-04	35D	PM	10132018	4	Juvenile	Gray	White	Gray+White					0	0	0	0		0	0	0	0	0	0	POINT (-73.958770180151 40.7934123941528)
2664	-73.95983503855409	40.7973274000224	38A-PM-1013-04	38A	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0		0	0	0	0	1	0	POINT (-73.9598350385541 40.7973274000224)
1029	-73.9601259189134	40.795535060905706	36B-PM-1013-04	36B	PM	10132018	4		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1		0	0	0	0	0	1	POINT (-73.9601259189134 40.7955350609057)
497	-73.96021668769791	40.7953811003986	36B-AM-1013-04	36B	AM	10132018	4		Black		Black+		Above Ground	20	Moved 20+ feet high above top of tree limb	0	1	0	0		0	0	0	0	0	1	POINT (-73.9602166876979 40.7953811003986)
1294	-73.9604089940153	40.7910028063138	32D-AM-1013-04	32D	AM	10132018	4	Adult	Cinnamon		Cinnamon+	Brown legs	Ground Plane	FALSE		1	0	0	0		0	0	1	1	0	1	POINT (-73.9604089940153 40.7910028063138)
824	-73.9606344681252	40.7958337780644	37B-PM-1013-04	37B	PM	10132018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0		0	0	0	0	0	1	POINT (-73.9606344681252 40.795833778064406)
1585	-73.96113123553481	40.79501308639129	36A-PM-1013-04	36A	PM	10132018	4		Gray	White	Gray+White		Ground Plane	FALSE	ON ROCK NEAR POND	0	0	0	0	sitting	0	0	1	0	1	0	POINT (-73.9611312355348 40.7950130863913)
1823	-73.9612854506075	40.792083067357105	32C-PM-1013-04	32C	PM	10132018	4	Juvenile	Gray		Gray+		Above Ground			1	0	1	0		0	0	0	0	0	0	POINT (-73.9612854506075 40.7920830673571)
1076	-73.96279043284021	40.7939375305761	34A-PM-1013-04	34A	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	digging & burying	0	0	0	0	0	0	POINT (-73.9627904328402 40.7939375305761)
2383	-73.9686551213305	40.772861783717396	11H-PM-1013-04	11H	PM	10132018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1		0	0	0	1	1	0	POINT (-73.9686551213305 40.7728617837174)
1742	-73.97010234787459	40.7803527061859	17C-PM-1013-04	17C	PM	10132018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1		0	0	0	0	1	0	POINT (-73.9701023478746 40.7803527061859)
1636	-73.97014086231209	40.7695511718541	7I-PM-1013-04	07I	PM	10132018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	Grass	1	0	0	1		0	1	0	0	0	0	POINT (-73.9701408623121 40.7695511718541)
1296	-73.97055091705421	40.7689416540228	6I-PM-1013-04	06I	PM	10132018	4	Adult	Black	Gray	Black+Gray		Ground Plane	FALSE	Grass	0	0	0	1		0	0	1	0	0	0	POINT (-73.9705509170542 40.7689416540228)
318	-73.97439905767459	40.7768690723163	12A-PM-1013-04	12A	PM	10132018	4		Gray	Cinnamon	Gray+Cinnamon		Above Ground	1		0	1	0	0	chasing #3	0	0	0	0	1	0	POINT (-73.9743990576746 40.7768690723163)
375	-73.9752000129992	40.773291812223896	8C-PM-1013-04	08C	PM	10132018	4	Juvenile	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0		0	0	0	0	1	0	POINT (-73.9752000129992 40.7732918122239)
567	-73.9756972647636	40.773624164826	9B-PM-1013-04	09B	PM	10132018	4	Juvenile	Gray	Black	Gray+Black		Above Ground	30		0	0	1	0		0	0	1	0	1	0	POINT (-73.9756972647636 40.773624164826)
654	-73.976769659152	40.7741908010484	9A-AM-1013-04	09A	AM	10132018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1		0	0	0	0	0	0	POINT (-73.976769659152 40.7741908010484)
2349	-73.98003374000399	40.768360829233295	2B-PM-1013-04	02B	PM	10132018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0		0	0	0	0	0	0	POINT (-73.980033740004 40.7683608292333)