squirrels

Custom SQL query returning 16 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 Squirrel Number" = :p0 and "Highlight Fur Color" = :p1 and "Indifferent" = :p2 order by [Above Ground Sighter Measurement] 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	Climbing	Eating	Foraging	Other Activities	Tail flags	Approaches	Runs from	Other Interactions	Lat/Long
1619	-73.9744555348544	40.772849810635705	8D-PM-1007-03	08D	PM	10072018	3	Adult	Cinnamon	Gray	Cinnamon+Gray				0	0	0	1		0	0	1		POINT (-73.9744555348544 40.7728498106357)
852	-73.9609704650925	40.7938786854735	34B-AM-1013-03	34B	AM	10132018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	15		1	1	0	0	hopping	0	1	1		POINT (-73.9609704650925 40.7938786854735)
2912	-73.9632164738341	40.7921270121312	32B-PM-1010-03	32B	PM	10102018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	15		0	0	1	0		0	0	0		POINT (-73.9632164738341 40.7921270121312)
1680	-73.9638167248251	40.7776485679354	18I-PM-1007-03	18I	PM	10072018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	25		0	1	0	0		0	0	0	stared at me	POINT (-73.9638167248251 40.77764856793541)
391	-73.97908754803579	40.767610478065706	2C-AM-1010-03	02C	AM	10102018	3	Adult	Black	Gray	Black+Gray	Above Ground	30		0	1	0	0		0	0	0		POINT (-73.9790875480358 40.7676104780657)
224	-73.9520592496349	40.797507629981105	42G-PM-1014-03	42G	PM	10142018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	4	on fence	1	0	0	0	prancing	0	0	1		POINT (-73.9520592496349 40.7975076299811)
204	-73.96795381633409	40.7837103696906	22C-AM-1013-03	22C	AM	10132018	3	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	1	1	eating (mushroom)	0	0	1		POINT (-73.9679538163341 40.7837103696906)
257	-73.9773317054464	40.7684035996758	3D-AM-1006-03	03D	AM	10062018	3	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE	on top [of] a big rock/boulder in the area	1	1	0	0	climbing (rock)	0	1	0	approaches (slightly),wary of humans	POINT (-73.9773317054464 40.76840359967581)
651	-73.9801661903932	40.7697950141751	3A-PM-1017-03	03A	PM	10172018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1		0	1	0		POINT (-73.9801661903932 40.7697950141751)
723	-73.9654397484763	40.7798863522904	19F-PM-1017-03	19F	PM	10172018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	1	1		0	1	0		POINT (-73.9654397484763 40.7798863522904)
1289	-73.97246812695259	40.7743474675821	11D-PM-1006-03	11D	PM	10062018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	1	1		0	1	0		POINT (-73.9724681269526 40.7743474675821)
1311	-73.9694169352433	40.774440829385796	12G-PM-1007-03	12G	PM	10072018	3		Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE	bushes	0	0	0	1		0	0	0	friendly	POINT (-73.9694169352433 40.7744408293858)
2043	-73.9643223016635	40.781431908715	21F-AM-1018-03	21F	AM	10182018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	0	dead	0	0	1		POINT (-73.9643223016635 40.781431908715)
2234	-73.9734741818047	40.766328451425	3H-PM-1014-03	03H	PM	10142018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1		0	0	1		POINT (-73.9734741818047 40.766328451425)
2496	-73.96962742914171	40.7691980808067	7I-PM-1013-03	07I	PM	10132018	3	Adult	Black	Gray	Black+Gray	Ground Plane	FALSE	Trash bins	0	0	1	0		0	0	0		POINT (-73.9696274291417 40.7691980808067)
2992	-73.9746063250438	40.7687654196811	4F-PM-1013-03	04F	PM	10132018	3	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1		1	0	1		POINT (-73.9746063250438 40.7687654196811)