squirrels

Custom SQL query returning 11 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 "Hectare Squirrel Number" = :p1 order by rowid 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	Specific Location	Running	Chasing	Climbing	Eating	Other Activities	Kuks	Quaas	Tail flags	Tail twitches	Indifferent	Other Interactions	Lat/Long
16	-73.97225001968441	40.7742879599026	11D-AM-1010-03	11D	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	30		0	0	1	0	grooming	0	0	0	0	1		POINT (-73.9722500196844 40.7742879599026)
335	-73.97823514358521	40.7715896672335	6A-AM-1006-03	06A	AM	10062018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	30	tree	0	1	0	1		0	0	1	1	0		POINT (-73.9782351435852 40.7715896672335)
347	-73.96116961447841	40.7816692895155	22I-AM-1007-03	22I	AM	10072018	3	Adult	Gray		Gray+	Above Ground	30		0	0	1	0		0	0	0	0	1		POINT (-73.9611696144784 40.7816692895155)
391	-73.97908754803579	40.767610478065706	2C-AM-1010-03	02C	AM	10102018	3	Adult	Black	Gray	Black+Gray	Above Ground	30		0	0	1	0		0	0	0	0	0		POINT (-73.9790875480358 40.7676104780657)
480	-73.9641293283734	40.7907654006019	30B-AM-1007-03	30B	AM	10072018	3	Adult	Gray		Gray+	Above Ground	30		1	0	0	0		0	0	0	0	0		POINT (-73.9641293283734 40.7907654006019)
1355	-73.9655277320465	40.780612052936895	20F-AM-1014-03	20F	AM	10142018	3	Adult	Gray		Gray+	Above Ground	30		0	0	1	0		1	0	0	0	0		POINT (-73.9655277320465 40.7806120529369)
1516	-73.9625383795297	40.7883862331728	28D-AM-1012-03	28D	AM	10122018	3	Adult	Black		Black+	Above Ground	30		1	0	0	0		0	0	0	0	1		POINT (-73.9625383795297 40.7883862331728)
1890	-73.97877230828071	40.7713655754004	5A-PM-1010-03	05A	PM	10102018	3	Adult	Gray		Gray+	Above Ground	30		0	0	1	0		0	0	0	0	0		POINT (-73.9787723082807 40.7713655754004)
2228	-73.9714045891597	40.771541833397606	9G-AM-1007-03	09G	AM	10072018	3	Adult	Gray	Black	Gray+Black	Above Ground	30		0	0	1	0		0	0	0	0	0		POINT (-73.97140458915972 40.7715418333976)
2377	-73.9704328573603	40.7739347247552	11F-AM-1013-03	11F	AM	10132018	3	Adult	Gray		Gray+	Above Ground	30		0	0	1	0		0	0	0	0	0		POINT (-73.9704328573603 40.7739347247552)
2933	-73.9677903197449	40.7826561917755	21C-AM-1014-03	21C	AM	10142018	3	Adult	Gray		Gray+	Above Ground	30		0	1	1	0		0	1	0	0	0	looked at us from tree	POINT (-73.9677903197449 40.7826561917755)