squirrels

Custom SQL query returning 14 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 "Above Ground Sighter Measurement" = :p0 and "Date" = :p1 and "Highlight Fur Color" = :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	Other Activities	Quaas	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
193	-73.9537691298752	40.7941272599797	38G-PM-1020-01	38G	PM	10202018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	1	0	0	0	1		POINT (-73.9537691298752 40.7941272599797)
2602	-73.97548229388691	40.771776689383294	7C-PM-1020-01	07C	PM	10202018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0		POINT (-73.9754822938869 40.7717766893833)
241	-73.97602564775579	40.7703573131398	5D-AM-1020-02	05D	AM	10202018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1	small jumps	0	0	0	0	0	0		POINT (-73.9760256477558 40.7703573131398)
1218	-73.953375642605	40.7947144477885	38G-PM-1020-02	38G	PM	10202018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	1	0	0	1	0		POINT (-73.953375642605 40.7947144477885)
605	-73.9573930079918	40.7934570294469	35E-AM-1020-03	35E	AM	10202018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0		POINT (-73.9573930079918 40.7934570294469)
962	-73.97154668503241	40.7695584933538	6H-PM-1020-03	06H	PM	10202018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	runs from (kids kicking the fence)	POINT (-73.9715466850324 40.7695584933538)
1481	-73.95388671863759	40.794140943400706	38G-PM-1020-03	38G	PM	10202018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	1	0	0	1	0		POINT (-73.9538867186376 40.7941409434007)
2110	-73.9647151303629	40.7912681060756	30A-PM-1020-03	30A	PM	10202018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Rock	0	0	0	1	0		0	0	0	0	0	1		POINT (-73.9647151303629 40.7912681060756)
2399	-73.9583762071264	40.7852226065643	27I-PM-1020-03	27I	PM	10202018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0		0	0	0	1	0	0	begging for food; on hind legs	POINT (-73.9583762071264 40.7852226065643)
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	0	0	1	0		POINT (-73.9542770888881 40.79436103668531)
1025	-73.9763506612375	40.771611393182	7C-PM-1020-05	07C	PM	10202018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0		POINT (-73.9763506612375 40.771611393182)
1367	-73.9542684235907	40.7944237164092	38G-PM-1020-05	38G	PM	10202018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		1	1	0	0	1	0		POINT (-73.9542684235907 40.7944237164092)
2159	-73.9696688162449	40.774142217718705	12F-AM-1020-05	12F	AM	10202018	5	Adult	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	1	0	0	0		POINT (-73.9696688162449 40.7741422177187)
2759	-73.9543373703455	40.7943889087123	38G-PM-1020-07	38G	PM	10202018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	1		1	1	0	0	1	0		POINT (-73.9543373703455 40.7943889087123)