squirrels

Custom SQL query returning 28 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 "Approaches" = :p0 and "Highlight Fur Color" = :p1 and "Shift" = :p2 order by longitude 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	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
1597	-73.9789401448556	40.76973731414979	4B-AM-1010-04	04B	AM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1	1		0	0	1	0	0		POINT (-73.9789401448556 40.7697373141498)
2928	-73.9767953468937	40.7676376977667	3E-AM-1006-03	03E	AM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1	checkin' his stashes	1	0	1	0	1		POINT (-73.9767953468937 40.7676376977667)
1257	-73.97672475936541	40.772620005419704	7B-AM-1008-15	07B	AM	10082018	15	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1	0		0	0	1	0	0		POINT (-73.9767247593654 40.7726200054197)
1862	-73.97648512317541	40.771573686286104	6C-AM-1007-07	06C	AM	10072018	7	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	1	0	0	ambling	0	0	1	0	1	trucks	POINT (-73.9764851231754 40.7715736862861)
2233	-73.9754709117681	40.7681421869407	3E-AM-1006-08	03E	AM	10062018	8	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	4		0	0	0	1	0		0	0	1	0	0		POINT (-73.9754709117681 40.7681421869407)
2586	-73.9752965316933	40.775253857578896	10B-AM-1006-03	10B	AM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground		In tree	0	0	1	0	0		0	1	1	0	0		POINT (-73.9752965316933 40.7752538575789)
1892	-73.9745908987975	40.7655191512308	1G-AM-1006-03	01G	AM	10062018	3	Adult	Black	Cinnamon	Black+Cinnamon	Ground Plane	FALSE		0	1	0	0	1		0	0	1	0	0		POINT (-73.9745908987975 40.7655191512308)
1661	-73.974519308015	40.7691228794395	5E-AM-1008-02	05E	AM	10082018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	8	trellis	1	0	0	0	1		0	0	1	0	0		POINT (-73.974519308015 40.7691228794395)
712	-73.9736169886655	40.7714942196257	7E-AM-1006-06	07E	AM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0	0		0	0	1	0	0		POINT (-73.9736169886655 40.7714942196257)
738	-73.9725712588741	40.7669101832926	4H-AM-1006-02	04H	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	1	0	0	climbing (over small wire fence then on the ground)	0	0	1	0	1	approaches (saw me & came forward),runs from (startled by another person)	POINT (-73.9725712588741 40.7669101832926)
1521	-73.97239229041192	40.7729164833027	9E-AM-1008-01	09E	AM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	1	0	0		POINT (-73.9723922904119 40.7729164833027)
941	-73.9717920322306	40.7763095393715	13D-AM-1014-10	13D	AM	10142018	10	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	1	0	0		POINT (-73.9717920322306 40.7763095393715)
2161	-73.9715375915057	40.7751212088827	12D-AM-1013-01	12D	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	1	0	0		POINT (-73.9715375915057 40.7751212088827)
2932	-73.9705837974358	40.775849484967296	13E-AM-1017-13	13E	AM	10172018	13	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	on rock	0	0	0	0	1		0	0	1	0	0		POINT (-73.97058379743581 40.7758494849673)
1557	-73.9705331808443	40.769994357129605	7H-AM-1006-09	07H	AM	10062018	9	Adult	Gray	Cinnamon	Gray+Cinnamon				0	0	0	0	1		0	0	1	0	0		POINT (-73.9705331808443 40.7699943571296)
1285	-73.97051151894291	40.769839557706796	7H-AM-1006-08	07H	AM	10062018	8	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	1	0	0		POINT (-73.9705115189429 40.7698395577068)
435	-73.9702963056917	40.7697928730791	7H-AM-1006-11	07H	AM	10062018	11	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	1	0	0		POINT (-73.9702963056917 40.7697928730791)
797	-73.969345754447	40.7770429650288	15E-AM-1013-02	15E	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	20		1	0	1	0	0		0	0	1	0	0		POINT (-73.969345754447 40.7770429650288)
154	-73.9686056085297	40.7781658424866	16E-AM-1014-03	16E	AM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1	1		0	0	1	0	0		POINT (-73.9686056085297 40.7781658424866)
2536	-73.96850872880721	40.7779068128051	16E-AM-1014-01	16E	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	0	burying food	0	0	1	0	0		POINT (-73.9685087288072 40.7779068128051)
289	-73.9684254196866	40.77809016436	16E-AM-1014-02	16E	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	1	1		0	0	1	0	0		POINT (-73.9684254196866 40.77809016436)
271	-73.9661262885099	40.7844085550945	23D-AM-1013-01	23D	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Above Ground	3		0	0	1	0	0		0	0	1	0	0	approaches (he saw me,came towards,then darted up)	POINT (-73.9661262885099 40.7844085550945)
1919	-73.9637440847107	40.789142741937205	29C-AM-1007-04	29C	AM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	1	0	0		POINT (-73.9637440847107 40.7891427419372)
232	-73.9624184586031	40.7921524868211	32B-AM-1017-03	32B	AM	10172018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	1	1	1	1	approaches (primarily),runs from (initially),follows	POINT (-73.9624184586031 40.7921524868211)
2196	-73.96233563694321	40.7888693815168	29D-AM-1014-05	29D	AM	10142018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	Rocky area	0	0	0	0	1		0	0	1	0	0		POINT (-73.9623356369432 40.7888693815168)
2275	-73.96142184133559	40.793894505879294	34B-AM-1013-01	34B	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		1	0	0	0	1	hopping	0	1	1	0	0		POINT (-73.9614218413356 40.7938945058793)
1057	-73.9594406225891	40.7918533707789	33D-AM-1017-02	33D	AM	10172018	2	Adult	Black	Cinnamon	Black+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	1	1	0	0		POINT (-73.9594406225891 40.7918533707789)
913	-73.9514111329059	40.797508587289705	42G-AM-1018-01	42G	AM	10182018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE		0	0	0	0	1		0	0	1	0	1		POINT (-73.9514111329059 40.797508587289705)