squirrels

Custom SQL query returning 14 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 "Location" = :p1 order by Indifferent 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	Running	Chasing	Climbing	Eating	Foraging	Other Activities	Tail twitches	Indifferent	Lat/Long
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		1	0	POINT (-73.9777328709928 40.7669087724668)
1549	-73.97779784978941	40.7668620784309	1D-AM-1006-01	01D	AM	10062018	1	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE	1	0	1	0	1		1	0	POINT (-73.9777978497894 40.7668620784309)
1555	-73.9784942525972	40.767260000368296	1D-AM-1006-06	01D	AM	10062018	6	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE	1	0	0	0	0	tumbling	0	0	POINT (-73.9784942525972 40.7672600003683)
2066	-73.9784610031588	40.7668839966177	1D-AM-1006-07	01D	AM	10062018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE	0	0	0	1	1		1	0	POINT (-73.9784610031588 40.7668839966177)
2344	-73.9786310308892	40.766934936818295	1D-AM-1006-05	01D	AM	10062018	5	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	0	0	0	1	0		1	0	POINT (-73.9786310308892 40.7669349368183)
405	-73.97866031471492	40.7671937837017	1D-AM-1006-09	01D	AM	10062018	9	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	1	0	0	0	1		1	1	POINT (-73.9786603147149 40.7671937837017)
468	-73.9780659679557	40.7672382282781	1D-PM-1007-06	01D	PM	10072018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE	0	0	0	0	1		0	1	POINT (-73.9780659679557 40.7672382282781)
575	-73.9783366903829	40.7668300056094	1D-PM-1007-03	01D	PM	10072018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE	0	1	0	0	0		0	1	POINT (-73.9783366903829 40.7668300056094)
971	-73.978392591149	40.7668993398193	1D-PM-1007-04	01D	PM	10072018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	0	0	0	0	1		0	1	POINT (-73.978392591149 40.7668993398193)
1847	-73.9782283921819	40.766793260207706	1D-PM-1007-02	01D	PM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	0	1	0	0	0		0	1	POINT (-73.9782283921819 40.7667932602077)
2260	-73.9784685928652	40.7669924015341	1D-PM-1007-05	01D	PM	10072018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	0	0	0	1		0	1	POINT (-73.9784685928652 40.7669924015341)
2402	-73.9777206733344	40.7668595585487	1D-PM-1007-07	01D	PM	10072018	7	Adult	Gray		Gray+		Ground Plane	FALSE	0	0	0	0	0	lying down	0	1	POINT (-73.9777206733344 40.7668595585487)
2539	-73.97810334484679	40.766672406621296	1D-AM-1006-03	01D	AM	10062018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE	0	0	0	0	1		1	1	POINT (-73.9781033448468 40.7666724066213)
3001	-73.97755922284159	40.7668485329273	1D-PM-1007-01	01D	PM	10072018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	0	0	0	0	1		0	1	POINT (-73.9775592228416 40.7668485329273)