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 "Above Ground Sighter Measurement" = :p0 and "Chasing" = :p1 and "Eating" = :p2 order by [Lat/Long] 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	Other Activities	Kuks	Tail flags	Tail twitches	Indifferent	Runs from	Lat/Long
822	-73.9576559099012	40.7992598626483	41B-AM-1010-09	41B	AM	10102018	9	Adult	Gray		Gray+	Above Ground	3		0	1	0		0	0	0	1	0	POINT (-73.9576559099012 40.7992598626483)
1613	-73.95992022335359	40.7972599930224	38A-AM-1019-02	38A	AM	10192018	2	Adult	Gray		Gray+	Above Ground	3		1	1	1		0	0	0	1	0	POINT (-73.9599202233536 40.7972599930224)
2466	-73.95994199262991	40.797277472881106	38A-AM-1019-01	38A	AM	10192018	1	Adult	Gray		Gray+	Above Ground	3		1	1	1		0	0	0	1	0	POINT (-73.9599419926299 40.7972774728811)
2663	-73.96134291849741	40.79121580572671	32C-AM-1014-02	32C	AM	10142018	2	Adult	Gray		Gray+	Above Ground	3		0	1	1		0	0	0	0	0	POINT (-73.9613429184974 40.7912158057267)
958	-73.9613862251332	40.791282169715	32C-AM-1014-03	32C	AM	10142018	3	Adult	Gray		Gray+	Above Ground	3		0	1	1		0	0	0	0	0	POINT (-73.9613862251332 40.791282169715)
906	-73.9664120826015	40.7888022709721	27A-AM-1008-01	27A	AM	10082018	1	Adult	Gray		Gray+	Above Ground	3		0	1	0		0	0	0	0	1	POINT (-73.96641208260151 40.7888022709721)
849	-73.9736165917399	40.772454390149704	8D-AM-1007-04	08D	AM	10072018	4	Adult	Gray		Gray+	Above Ground	3		0	1	0	chasing squirrel #3	0	0	0	0	0	POINT (-73.9736165917399 40.7724543901497)
150	-73.97634308293419	40.7686351097159	4D-PM-1008-11	04D	PM	10082018	11	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Above Ground	3	on tree facing downward	0	1	0	chased #12	1	1	0	0	1	POINT (-73.9763430829342 40.7686351097159)
2988	-73.9766342759486	40.7687518380873	4D-AM-1012-04	04D	AM	10122018	4	Adult	Gray		Gray+	Above Ground	3	on tree trunk	0	1	1		0	0	1	1	0	POINT (-73.9766342759486 40.7687518380873)