squirrels

Custom SQL query returning 19 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 "Climbing" = :p0 and "Date" = :p1 and "Shift" = :p2 order by Shift desc 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	Color notes	Location	Above Ground Sighter Measurement	Specific Location	Running	Climbing	Eating	Foraging	Other Activities	Kuks	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
85	-73.9676410497481	40.7766043512974	15G-PM-1019-05	15G	PM	10192018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4		0	1	0	0		0	0	0	0	0	0		POINT (-73.9676410497481 40.7766043512974)
99	-73.9710541405708	40.772469160571795	10F-PM-1019-05	10F	PM	10192018	5	Adult	Black		Black+		Above Ground	10	Behind fence, tree	0	1	0	0		0	0	0	0	1	0		POINT (-73.9710541405708 40.7724691605718)
274	-73.9639832886071	40.7909532437095	30B-PM-1019-08	30B	PM	10192018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	1	1		0	0	0	0	0	1		POINT (-73.9639832886071 40.7909532437095)
286	-73.97209073846129	40.7762987836055	13C-PM-1019-01	13C	PM	10192018	1	Adult	Gray		Gray+		Above Ground	7		0	1	0	0		1	0	0	0	1	0		POINT (-73.9720907384613 40.7762987836055)
366	-73.9673548527075	40.7765669058396	15G-PM-1019-11	15G	PM	10192018	11	Adult	Gray		Gray+		Above Ground	4		0	1	0	0		0	0	0	0	0	0	stared	POINT (-73.9673548527075 40.7765669058396)
737	-73.97111769994709	40.7724278547281	10F-PM-1019-06	10F	PM	10192018	6	Adult	Gray	White	Gray+White		Above Ground	10	Different tree	0	1	0	0		0	0	0	0	1	0		POINT (-73.9711176999471 40.7724278547281)
964	-73.9631045499811	40.790618096947206	30B-PM-1019-04	30B	PM	10192018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	1	1	1		0	0	0	0	0	1		POINT (-73.9631045499811 40.7906180969472)
981	-73.9673160165357	40.776615800120204	15G-PM-1019-12	15G	PM	10192018	12	Adult	Gray		Gray+		Above Ground	4		0	1	0	0		0	0	0	0	0	0	stared	POINT (-73.9673160165357 40.7766158001202)
991	-73.96356890598409	40.790163434915	30B-PM-1019-03	30B	PM	10192018	3	Adult	Gray	Black	Gray+Black		Above Ground	10		0	1	0	0		0	0	0	0	0	0		POINT (-73.9635689059841 40.790163434915)
1265	-73.96035971176191	40.7824399298414	23I-PM-1019-02	23I	PM	10192018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0		0	0	0	0	0	0		POINT (-73.9603597117619 40.7824399298414)
1897	-73.97107389601	40.7723265810536	10F-PM-1019-07	10F	PM	10192018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	Same tree (as #6)	0	1	0	0		0	0	0	0	1	0		POINT (-73.97107389601 40.7723265810536)
2079	-73.96430251719141	40.790570391517	30B-PM-1019-06	30B	PM	10192018	6	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		0	1	0	1		0	0	0	0	0	1		POINT (-73.9643025171914 40.790570391517)
2153	-73.9797122322834	40.767834758743504	1B-PM-1019-10	01B	PM	10192018	10	Adult	Cinnamon	White	Cinnamon+White		Above Ground		Dog chased up tree	0	1	0	0		0	0	1	0	0	0		POINT (-73.97971223228342 40.7678347587435)
2198	-73.97097381665309	40.7774102689734	14D-PM-1019-08	14D	PM	10192018	8	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0		0	0	0	0	0	0		POINT (-73.9709738166531 40.7774102689734)
2335	-73.9704679459444	40.7773384236212	14D-PM-1019-10	14D	PM	10192018	10	Adult	Gray		Gray+		Above Ground	20		0	1	0	0		0	1	0	0	0	1		POINT (-73.9704679459444 40.7773384236212)
2380	-73.97613757295049	40.766223189212496	1F-PM-1019-02	01F	PM	10192018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2		0	1	1	0		0	0	0	1	0	0		POINT (-73.9761375729505 40.7662231892125)
2517	-73.9710221361528	40.7724939691584	10F-PM-1019-01	10F	PM	10192018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon head & stripe	Above Ground	2	Behind fence, tree trunk	0	1	0	0	sitting	0	0	0	0	1	0		POINT (-73.9710221361528 40.7724939691584)
2660	-73.97260564119709	40.77934679047429	16A-PM-1019-03	16A	PM	10192018	3		Gray		Gray+		Above Ground	15		0	1	0	0		0	0	0	0	0	0		POINT (-73.9726056411971 40.7793467904743)
2877	-73.9730027200009	40.7798000868804	16A-PM-1019-05	16A	PM	10192018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	1	0	0		0	0	0	0	0	0		POINT (-73.9730027200009 40.7798000868804)