squirrels

Custom SQL query returning 13 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 "Hectare" = :p0 and "Runs from" = :p1 order by [Primary Fur Color] 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	Combination of Primary and Highlight Color	Color notes	Location	Above Ground Sighter Measurement	Specific Location	Climbing	Eating	Foraging	Other Activities	Runs from	Lat/Long
1149	-73.960237785199	40.7907831607574	32E-PM-1017-16	32E	PM	10172018	16	Adult	Black	Black+		Ground Plane	FALSE	rocky outcrop	0	0	1		1	POINT (-73.960237785199 40.7907831607574)
10	-73.9596413903948	40.790312888902896	32E-PM-1017-14	32E	PM	10172018	14	Adult	Gray	Gray+	Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments.				0	1	1		1	POINT (-73.9596413903948 40.7903128889029)
244	-73.9597648775789	40.7903443029725	32E-AM-1007-01	32E	AM	10072018	1	Adult	Gray	Gray+		Ground Plane	FALSE		0	1	0		1	POINT (-73.9597648775789 40.7903443029725)
245	-73.95894143392421	40.790707388827705	32E-PM-1017-04	32E	PM	10172018	4	Adult	Gray	Gray+		Ground Plane	FALSE	treed area	0	1	1		1	POINT (-73.9589414339242 40.7907073888277)
463	-73.95921030643271	40.7904390691553	32E-PM-1017-10	32E	PM	10172018	10	Adult	Gray	Gray+		Ground Plane	FALSE		0	1	1		1	POINT (-73.9592103064327 40.7904390691553)
621	-73.9588886083793	40.7909991733435	32E-PM-1017-01	32E	PM	10172018	1	Adult	Gray	Gray+		Ground Plane	FALSE		0	0	1		1	POINT (-73.9588886083793 40.7909991733435)
1173	-73.959070754026	40.790667514341294	32E-PM-1017-07	32E	PM	10172018	7	Adult	Gray	Gray+		Ground Plane	FALSE	treed area	1	0	0		1	POINT (-73.959070754026 40.7906675143413)
1197	-73.95908687485841	40.7906047630418	32E-PM-1017-09	32E	PM	10172018	9	Adult	Gray	Gray+		Ground Plane	FALSE	treed area	0	1	1		1	POINT (-73.9590868748584 40.7906047630418)
1398	-73.9602808042376	40.7906130788763	32E-AM-1007-14	32E	AM	10072018	14	Adult	Gray	Gray+		Above Ground	50	literally fell to ground from 50 feet up	0	0	0	falling	1	POINT (-73.9602808042376 40.7906130788763)
1674	-73.9589698681439	40.7906520520417	32E-PM-1017-06	32E	PM	10172018	6	Adult	Gray	Gray+		Ground Plane	FALSE	treed area	0	1	1		1	POINT (-73.9589698681439 40.7906520520417)
1746	-73.96034711618691	40.7906003311747	32E-PM-1017-15	32E	PM	10172018	15	Adult	Gray	Gray+		Ground Plane	FALSE		0	0	1		1	POINT (-73.9603471161869 40.7906003311747)
1812	-73.9590074024938	40.7907059424675	32E-PM-1017-05	32E	PM	10172018	5	Adult	Gray	Gray+		Ground Plane	FALSE	treed area	0	1	1		1	POINT (-73.9590074024938 40.7907059424675)
2593	-73.9590191812452	40.790616698140894	32E-PM-1017-08	32E	PM	10172018	8	Adult	Gray	Gray+		Ground Plane	FALSE	treed area	0	1	1		1	POINT (-73.9590191812452 40.7906166981409)