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 "Hectare" = :p0 and "Runs from" = :p1 order by Quaas 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	Climbing	Eating	Foraging	Other Activities	Moans	Tail flags	Runs from	Other Interactions	Lat/Long
624	-73.96130519573059	40.7909351393505	31D-AM-1014-02	31D	AM	10142018	2	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE	Undergrowth	0	0	0	1		0	0	1		POINT (-73.9613051957306 40.7909351393505)
730	-73.9607280801601	40.7901506706248	31D-PM-1006-01	31D	PM	10062018	1	Adult	Gray		Gray+	Ground Plane	FALSE		0	0	1	1		0	1	1		POINT (-73.9607280801601 40.7901506706248)
891	-73.9613351649026	40.79098668513571	31D-AM-1014-03	31D	AM	10142018	3		Gray	White	Gray+White	Ground Plane	FALSE	Undergrowth	0	0	0	1		0	0	1		POINT (-73.9613351649026 40.7909866851357)
2061	-73.9608834102446	40.790624710005005	31D-AM-1014-05	31D	AM	10142018	5	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE		0	0	0	1		0	0	1		POINT (-73.9608834102446 40.790624710005)
2261	-73.9609692861012	40.790502891247	31D-AM-1014-07	31D	AM	10142018	7		Gray		Gray+	Ground Plane	FALSE	Crossing path to tree	1	0	0	0		0	0	1		POINT (-73.9609692861012 40.790502891247)
2729	-73.9615429203441	40.7907417648701	31D-AM-1014-01	31D	AM	10142018	1		Gray	Cinnamon	Gray+Cinnamon	Above Ground	20	Ground then up tree	0	1	0	0	chased by a doggo	1	0	1	runs from (dogs!)	POINT (-73.9615429203441 40.7907417648701)