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 Foraging 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	Foraging	Kuks	Tail twitches	Runs from	Other Interactions	Lat/Long
536	-73.9561141662309	40.7976258458604	40D-PM-1013-05	40D	PM	10132018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	1	0	0	0	0	0	1		POINT (-73.9561141662309 40.7976258458604)
1176	-73.9553263156025	40.79755920605721	40D-PM-1013-04	40D	PM	10132018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	1	0	0	0	0	0	1		POINT (-73.9553263156025 40.7975592060572)
1273	-73.95589438800509	40.7971535141896	40D-PM-1013-06	40D	PM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	4	0	0	1	0	0	0	1		POINT (-73.9558943880051 40.7971535141896)
1656	-73.9557399927792	40.7971563708988	40D-PM-1013-07	40D	PM	10132018	7	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	1	1	0	0	0	0	1		POINT (-73.9557399927792 40.7971563708988)
2179	-73.95596639495109	40.7974497269789	40D-AM-1013-07	40D	AM	10132018	7	Adult	Gray		Gray+	Above Ground	6	0	0	1	1	0	0	1	curious	POINT (-73.9559663949511 40.7974497269789)
2242	-73.9565824187667	40.797312050952	40D-AM-1013-06	40D	AM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	15	1	0	1	1	1	1	1		POINT (-73.9565824187667 40.797312050952)