squirrels

Custom SQL query returning 9 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 "Date" = :p0 and "Hectare" = :p1 order by [Above Ground Sighter Measurement] 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	Other Activities	Tail flags	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
889	-73.96810426129379	40.772331431865	11I-PM-1012-04	11I	PM	10122018	4	Adult	Gray		Gray+	Above Ground	2	1	1	0	1		0	0	0	0		POINT (-73.9681042612938 40.772331431865)
1317	-73.9680522379372	40.772389813511	11I-PM-1012-06	11I	PM	10122018	6	Adult	Gray		Gray+	Above Ground	2	1	1	0	1		0	0	0	0		POINT (-73.9680522379372 40.772389813511)
1568	-73.96810798698209	40.772349408134495	11I-PM-1012-05	11I	PM	10122018	5	Adult	Gray		Gray+	Above Ground	2	1	1	0	1		0	0	0	0		POINT (-73.9681079869821 40.7723494081345)
2818	-73.9681664642028	40.77246696819579	11I-PM-1012-02	11I	PM	10122018	2	Adult	Gray		Gray+	Above Ground	4	1	1	0	1		0	0	0	1	runs away from the ball	POINT (-73.9681664642028 40.7724669681958)
402	-73.9681917366128	40.7723298813768	11I-PM-1012-03	11I	PM	10122018	3	Adult	Gray		Gray+	Ground Plane	FALSE	1	1	0	1		0	0	0	1	runs from the dog	POINT (-73.9681917366128 40.7723298813768)
485	-73.9677423154682	40.7728813350245	11I-AM-1012-02	11I	AM	10122018	2	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE	0	0	0	1		0	1	1	0		POINT (-73.9677423154682 40.77288133502451)
1795	-73.968004352343	40.7726669278308	11I-PM-1012-01	11I	PM	10122018	1	Adult	Gray		Gray+	Ground Plane	FALSE	1	0	1	1		1	1	0	0	look at humans determining	POINT (-73.968004352343 40.7726669278308)
2199	-73.9677500862135	40.7726060987821	11I-AM-1012-01	11I	AM	10122018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE	0	0	1	0		0	1	0	1		POINT (-73.9677500862135 40.7726060987821)
2311	-73.96801718943509	40.772464442631296	11I-PM-1012-07	11I	PM	10122018	7	Juvenile	Gray		Gray+	Ground Plane	FALSE	0	0	0	1	burying its food into the ground	0	0	0	0		POINT (-73.96801718943512 40.7724644426313)