squirrels

Custom SQL query returning 7 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 "Approaches" = :p0 and "Climbing" = :p1 and "Hectare Squirrel Number" = :p2 order by Climbing 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	Climbing	Eating	Foraging	Kuks	Tail flags	Approaches	Other Interactions	Lat/Long
271	-73.9661262885099	40.7844085550945	23D-AM-1013-01	23D	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	3	0	1	0	0	0	0	1	approaches (he saw me,came towards,then darted up)	POINT (-73.9661262885099 40.7844085550945)
917	-73.9676514056678	40.7730853732876	11H-AM-1010-01	11H	AM	10102018	1	Adult	Gray	White	Gray+White	Above Ground	20	0	1	0	0	0	0	1	started climbing down to me	POINT (-73.9676514056678 40.7730853732876)
1215	-73.9728895595977	40.769937833229896	6F-AM-1006-01	06F	AM	10062018	1	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE	0	1	1	0	0	0	1		POINT (-73.9728895595977 40.7699378332299)
1683	-73.9790889008147	40.7676402781925	1C-PM-1013-01	01C	PM	10132018	1	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Ground Plane	FALSE	0	1	0	1	0	0	1		POINT (-73.9790889008147 40.7676402781925)
2005	-73.9755259087781	40.770725612418104	6D-AM-1008-01	06D	AM	10082018	1	Adult	Cinnamon	White	Cinnamon+White	Above Ground	10	0	1	1	0	1	0	1		POINT (-73.9755259087781 40.7707256124181)
2044	-73.97715523261991	40.7706917595308	5C-AM-1006-01	05C	AM	10062018	1	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE	1	1	0	0	0	1	1		POINT (-73.9771552326199 40.7706917595308)
2942	-73.9672063784809	40.7826070395665	21D-PM-1008-01	21D	PM	10082018	1		Gray		Gray+	Above Ground	8	0	1	0	0	0	0	1		POINT (-73.9672063784809 40.7826070395665)