squirrels

Custom SQL query returning 6 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 "Above Ground Sighter Measurement" = :p0 and "Date" = :p1 order by Running 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	Location	Above Ground Sighter Measurement	Specific Location	Climbing	Other Activities	Runs from	Lat/Long
48	-73.95959331954091	40.7905847332369	32E-AM-1007-13	32E	AM	10072018	13	Adult	Gray	Gray+	Above Ground	50		1		0	POINT (-73.9595933195409 40.7905847332369)
919	-73.96372797118529	40.7905198502307	30B-AM-1007-09	30B	AM	10072018	9	Adult	Gray	Gray+	Above Ground	50		1	jumping b/w trees	0	POINT (-73.9637279711853 40.7905198502307)
1071	-73.9703774000082	40.771760755155505	9G-AM-1007-01	09G	AM	10072018	1	Adult	Gray	Gray+	Above Ground	50		1		0	POINT (-73.9703774000082 40.7717607551555)
1110	-73.96764342569759	40.78623366244479	24A-PM-1007-04	24A	PM	10072018	4	Adult	Gray	Gray+	Above Ground	50	in tree	1		0	POINT (-73.9676434256976 40.7862336624448)
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	falling	1	POINT (-73.9602808042376 40.7906130788763)
2603	-73.97087815045279	40.7724138070355	10F-AM-1007-03	10F	AM	10072018	3	Adult	Gray	Gray+	Above Ground	50		1		0	POINT (-73.9708781504528 40.7724138070355)