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 "Date" = :p0 and "Hectare Squirrel Number" = :p1 and "Shift" = :p2 order by [Hectare Squirrel Number] 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	Color notes	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Climbing	Eating	Foraging	Quaas	Tail flags	Indifferent	Runs from	Lat/Long
539	-73.97614406279659	40.770603530154204	6D-PM-1020-04	06D	PM	10202018	4		Gray		Gray+		Above Ground	15		0	0	1	0	0	0	0	1	0	POINT (-73.9761440627966 40.7706035301542)
635	-73.96732355553209	40.7786749596774	17F-PM-1020-04	17F	PM	10202018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground			0	0	0	1	0	0	0	0	0	POINT (-73.9673235555321 40.7786749596774)
1023	-73.97608800701859	40.7711057827923	6C-PM-1020-04	06C	PM	10202018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0	0	0	1	0	POINT (-73.9760880070186 40.7711057827923)
1368	-73.95427708888809	40.794361036685295	38G-PM-1020-04	38G	PM	10202018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0	1	1	1	0	POINT (-73.9542770888881 40.79436103668531)
1476	-73.976609486498	40.7717832922535	7C-PM-1020-04	07C	PM	10202018	4	Adult	Gray		Gray+		Above Ground	1		0	0	1	0	0	0	0	0	1	POINT (-73.976609486498 40.7717832922535)
1780	-73.9640945609381	40.7910513041359	30A-PM-1020-04	30A	PM	10202018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Cinnamon back. Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE	Rock	1	0	0	1	0	0	0	0	1	POINT (-73.9640945609381 40.7910513041359)
2024	-73.97224722861509	40.7699550476176	6G-PM-1020-04	06G	PM	10202018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	0	0	0	0	POINT (-73.9722472286151 40.7699550476176)
2162	-73.9583300280173	40.7853495002675	27I-PM-1020-04	27I	PM	10202018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0	0	0	0	1	POINT (-73.9583300280173 40.7853495002675)