squirrels

Custom SQL query returning 13 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 "Indifferent" = :p1 order by [Color notes] 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	Foraging	Other Activities	Kuks	Tail flags	Approaches	Runs from	Other Interactions	Lat/Long
102	-73.95759861613641	40.799368134968	41B-PM-1014-01	41B	PM	10142018	1	Adult	Gray	White	Gray+White	Above Ground	25	Climbing tree	0	0	1	0	0	climbing (tree)	0	0	0	1		POINT (-73.9575986161364 40.799368134968)
116	-73.9572093760529	40.798848730021604	41B-AM-1010-06	41B	AM	10102018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Above Ground	6		0	0	1	0	0		0	0	0	0		POINT (-73.9572093760529 40.7988487300216)
188	-73.9570528770427	40.7990973804149	41B-AM-1010-07	41B	AM	10102018	7	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Above Ground	10		0	0	0	0	0		1	1	1	0	mad!	POINT (-73.9570528770427 40.7990973804149)
755	-73.9579941847434	40.7991216713328	41B-PM-1014-02	41B	PM	10142018	2	Adult	Black		Black+	Above Ground	28		0	0	1	0	0		0	0	0	0		POINT (-73.9579941847434 40.7991216713328)
920	-73.9571233640232	40.7992458980266	41B-PM-1014-04	41B	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	40		0	0	1	0	0		0	0	0	0	climbing	POINT (-73.9571233640232 40.7992458980266)
1224	-73.95725308434791	40.7987460430546	41B-AM-1010-05	41B	AM	10102018	5	Adult	Gray	White	Gray+White	Ground Plane	FALSE		0	1	0	0	0		0	0	0	0		POINT (-73.9572530843479 40.7987460430546)
1414	-73.9580513096783	40.79909641532	41B-AM-1010-02	41B	AM	10102018	2	Adult	Gray	White	Gray+White	Above Ground	16		0	1	0	0	0		0	0	0	0		POINT (-73.9580513096783 40.79909641532)
1740	-73.95777581255179	40.799384716477	41B-AM-1010-10	41B	AM	10102018	10	Adult	Cinnamon	White	Cinnamon+White	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0		POINT (-73.9577758125518 40.799384716477)
1987	-73.9573692542155	40.7989252908321	41B-PM-1014-03	41B	PM	10142018	3	Adult	Gray	White	Gray+White	Above Ground	28		0	0	1	0	0		0	0	0	0		POINT (-73.9573692542155 40.7989252908321)
2285	-73.9576325087936	40.7988448745116	41B-AM-1010-04	41B	AM	10102018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0		POINT (-73.9576325087936 40.7988448745116)
2392	-73.9578981223015	40.798996775435796	41B-AM-1010-03	41B	AM	10102018	3	Adult			+	Above Ground	60		0	0	0	0	0		0	0	0	0		POINT (-73.9578981223015 40.7989967754358)
2455	-73.9577297187155	40.799225295679	41B-AM-1010-08	41B	AM	10102018	8	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	Above Ground	20		0	0	1	1	0		0	0	1	0		POINT (-73.9577297187155 40.799225295679)
2977	-73.95806816485471	40.799201001265295	41B-AM-1010-01	41B	AM	10102018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0		POINT (-73.9580681648547 40.7992010012653)