squirrels

Custom SQL query returning 10 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 "Highlight Fur Color" = :p1 order by Location 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	Eating	Foraging	Tail twitches	Indifferent	Runs from	Lat/Long
77	-73.9615696577673	40.7951278622399	35A-AM-1014-03	35A	AM	10142018	3	Adult	Gray	White	Gray+White	Ground Plane	FALSE	0	0	0	0	1	0	1	0	POINT (-73.9615696577673 40.7951278622399)
277	-73.96190702296741	40.795255669250004	35A-AM-1014-05	35A	AM	10142018	5	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE	1	0	0	0	0	0	0	1	POINT (-73.9619070229674 40.79525566925)
839	-73.9615602805554	40.7945662185621	35A-PM-1013-08	35A	PM	10132018	8	Adult	Gray	White	Gray+White	Ground Plane	FALSE	0	0	0	0	1	1	0	1	POINT (-73.9615602805554 40.7945662185621)
1140	-73.9615817859213	40.7945839663845	35A-AM-1014-08	35A	AM	10142018	8	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE	0	0	1	0	0	0	1	0	POINT (-73.9615817859213 40.79458396638451)
2072	-73.9618709589382	40.7944969066792	35A-PM-1013-02	35A	PM	10132018	2	Adult	Gray	White	Gray+White	Ground Plane	FALSE	0	0	0	0	1	0	0	1	POINT (-73.9618709589382 40.7944969066792)
2104	-73.9622419917579	40.794579797904	35A-AM-1014-07	35A	AM	10142018	7	Adult	Gray	White	Gray+White	Ground Plane	FALSE	0	1	0	0	0	0	1	0	POINT (-73.9622419917579 40.794579797904)
2545	-73.9617594316752	40.7946803725236	35A-AM-1014-01	35A	AM	10142018	1	Adult	Gray	White	Gray+White	Ground Plane	FALSE	1	0	0	1	0	0	1	0	POINT (-73.9617594316752 40.7946803725236)
2669	-73.9615900833886	40.7945431292846	35A-PM-1013-07	35A	PM	10132018	7	Adult	Gray	White	Gray+White	Ground Plane	FALSE	0	0	0	0	1	0	0	0	POINT (-73.9615900833886 40.7945431292846)
2716	-73.9618094076328	40.7944097368153	35A-PM-1013-03	35A	PM	10132018	3	Adult	Gray	White	Gray+White	Ground Plane	FALSE	1	0	0	1	1	0	0	1	POINT (-73.9618094076328 40.7944097368153)
2997	-73.96197353854829	40.7944667974974	35A-PM-1013-01	35A	PM	10132018	1	Adult	Gray	White	Gray+White	Ground Plane	FALSE	0	0	0	0	1	0	0	1	POINT (-73.9619735385483 40.7944667974974)