squirrels

Custom SQL query returning 8 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 "Highlight Fur Color" = :p1 order by rowid 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	Running	Chasing	Climbing	Eating	Foraging	Other Activities	Indifferent	Lat/Long
31	-73.9540054100539	40.795244599983604	39G-PM-1013-06	39G	PM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	1	0	0	0	0		0	POINT (-73.9540054100539 40.7952445999836)
148	-73.9532620128307	40.795247554804796	39G-AM-1018-01	39G	AM	10182018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	0	0	0	0	0	dead (something ran over it)	0	POINT (-73.9532620128307 40.7952475548048)
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	POINT (-73.9539734770934 40.7956055442)
327	-73.95343062916791	40.7959052073753	39G-PM-1013-07	39G	PM	10132018	7	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	0	0	0	0	1		1	POINT (-73.9534306291679 40.7959052073753)
474	-73.9540652304705	40.7955226178199	39G-PM-1013-05	39G	PM	10132018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	0	1	0	0	1		0	POINT (-73.9540652304705 40.7955226178199)
1515	-73.9530326577312	40.7956922386395	39G-PM-1013-02	39G	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	1	0	0	0	0		0	POINT (-73.9530326577312 40.795692238639504)
1522	-73.95389705545321	40.7955196793479	39G-PM-1013-03	39G	PM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	15	0	0	1	0	0		0	POINT (-73.9538970554532 40.7955196793479)
1945	-73.9530257401736	40.795139740737	39G-PM-1013-01	39G	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	1	0	0	0	0		0	POINT (-73.9530257401736 40.79513974073701)