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 "Eating" = :p1 and "Hectare Squirrel Number" = :p2 order by latitude 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	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Climbing	Foraging	Other Activities	Kuks	Quaas	Tail flags	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
2962	-73.9722530826293	40.7667138028361	3I-AM-1010-05	03I	AM	10102018	5	Adult	Gray		Gray+	Ground Plane	FALSE		0	0	0	1		0	0	0	0	1	0		POINT (-73.9722530826293 40.7667138028361)
1762	-73.9769106838192	40.7674414870702	2E-AM-1010-05	02E	AM	10102018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Above Ground	33		0	0	1	0		0	0	0	0	1	0		POINT (-73.9769106838192 40.7674414870702)
1722	-73.98025646852649	40.768175909819895	2B-AM-1010-05	02B	AM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1		0	0	1	0	1	0		POINT (-73.9802564685265 40.7681759098199)
1763	-73.9768286349595	40.7687012827059	3D-PM-1010-05	03D	PM	10102018	5	Adult	Cinnamon		Cinnamon+	Ground Plane	FALSE		1	0	0	1		0	0	0	0	0	0		POINT (-73.9768286349595 40.7687012827059)
1849	-73.9788436368415	40.7691104998969	3B-AM-1010-05	03B	AM	10102018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1		0	0	0	0	1	0		POINT (-73.9788436368415 40.7691104998969)
2107	-73.9772624834791	40.769282191854295	4C-PM-1010-05	04C	PM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0		0	0	0	0	0	0		POINT (-73.9772624834791 40.7692821918543)
2889	-73.9771646835311	40.769304916508396	4C-PM-1010-05	04C	PM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0		0	0	0	0	0	0		POINT (-73.9771646835311 40.7693049165084)
1799	-73.978844141973	40.7696046074378	4B-AM-1010-05	04B	AM	10102018	5	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	10		0	1	0	0	chasing squirrel #6	1	1	0	1	0	0		POINT (-73.978844141973 40.7696046074378)
2506	-73.9719038949487	40.770353349248204	7G-AM-1010-05	07G	AM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1		0	0	0	0	1	0		POINT (-73.9719038949487 40.7703533492482)
1259	-73.976864402584	40.7705663751959	5C-PM-1010-05	05C	PM	10102018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	0	1	0		0	0	0	0	0	0		POINT (-73.976864402584 40.7705663751959)
2152	-73.9686925781295	40.7705688673142	9I-PM-1010-05	09I	PM	10102018	5	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Ground Plane	FALSE		1	0	0	1		0	0	0	0	0	1		POINT (-73.9686925781295 40.7705688673142)
532	-73.96854290608391	40.7724786961619	11H-AM-1010-05	11H	AM	10102018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	1	0	0		0	0	0	0	1	0		POINT (-73.9685429060839 40.7724786961619)
2824	-73.97506180080991	40.773752116709396	9B-AM-1010-05	09B	AM	10102018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1		0	0	0	1	1	0		POINT (-73.9750618008099 40.7737521167094)
208	-73.9677646187171	40.7746492806333	13H-PM-1010-05	13H	PM	10102018	5	Adult	Gray		Gray+	Ground Plane	FALSE		0	0	0	1		0	0	0	0	1	0		POINT (-73.9677646187171 40.7746492806333)
59	-73.9684910712272	40.776881164002106	15F-PM-1010-05	15F	PM	10102018	5	Adult	Gray		Gray+	Ground Plane	FALSE		0	0	0	1		0	0	0	0	1	0		POINT (-73.9684910712272 40.7768811640021)
1141	-73.9664669369583	40.7774085361976	16G-AM-1010-05	16G	AM	10102018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE		1	0	0	0		0	0	0	0	1	0		POINT (-73.9664669369583 40.7774085361976)
2240	-73.9697787673802	40.7781746195436	16D-PM-1010-05	16D	PM	10102018	5	Adult	Gray		Gray+	Ground Plane	FALSE		1	0	0	1		0	0	0	0	0	1		POINT (-73.9697787673802 40.7781746195436)
908	-73.9594120573719	40.78419457505979	26I-PM-1010-05	26I	PM	10102018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	10	tree	0	0	1	1		0	0	0	0	1	0		POINT (-73.9594120573719 40.7841945750598)
2875	-73.95466167829221	40.790974533738996	34I-PM-1010-05	34I	PM	10102018	5	Adult	Gray		Gray+				0	0	0	1		0	0	0	1	0	0		POINT (-73.9546616782922 40.790974533739)
1606	-73.96289327978859	40.7923116396365	32B-PM-1010-05	32B	PM	10102018	5	Adult	Gray		Gray+	Ground Plane	FALSE		1	0	0	1		0	0	0	0	0	0		POINT (-73.9628932797886 40.7923116396365)
2970	-73.9619019299709	40.7924476439693	33B-PM-1010-05	33B	PM	10102018	5	Adult	Gray		Gray+	Ground Plane	FALSE		0	0	0	0		0	0	0	0	1	0		POINT (-73.9619019299709 40.7924476439693)
1347	-73.9616693665254	40.792971019627	33B-AM-1010-05	33B	AM	10102018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1		0	0	0	0	0	1		POINT (-73.9616693665254 40.792971019627)
1320	-73.9554327683595	40.7953846381499	38E-AM-1010-05	38E	AM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1		0	0	0	0	1	0	interested in my presence	POINT (-73.9554327683595 40.7953846381499)
1224	-73.95725308434791	40.7987460430546	41B-AM-1010-05	41B	AM	10102018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	1	0	0		0	0	0	0	0	0		POINT (-73.9572530843479 40.7987460430546)