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" = :p0 and "Location" = :p1 order by Indifferent 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	Running	Chasing	Climbing	Foraging	Tail twitches	Approaches	Indifferent	Runs from	Lat/Long
53	-73.95849706432129	40.7982886348696	40B-AM-1019-03	40B	AM	10192018	3	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE	1	1	0	0	1	1	0	0	POINT (-73.9584970643213 40.7982886348696)
172	-73.958535640774	40.7982737896998	40B-AM-1019-02	40B	AM	10192018	2	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE	1	1	0	0	1	0	0	0	POINT (-73.958535640774 40.7982737896998)
1540	-73.957710975899	40.79840556140471	40B-AM-1019-06	40B	AM	10192018	6	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE	0	0	0	1	0	0	0	1	POINT (-73.957710975899 40.7984055614047)
2168	-73.95823634371351	40.7987752300505	40B-AM-1019-06	40B	AM	10192018	6	Juvenile	Gray	White	Gray+White	Ground Plane	FALSE	0	0	0	1	0	0	0	1	POINT (-73.9582363437135 40.7987752300505)
2439	-73.95874591363909	40.7982497351812	40B-PM-1014-05	40B	PM	10142018	5	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	0	0	0	1	0	0	0	1	POINT (-73.9587459136391 40.7982497351812)
81	-73.9578237168359	40.7980959471034	40B-PM-1014-06	40B	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	1	0	0	0	0	0	1	0	POINT (-73.9578237168359 40.7980959471034)
560	-73.9573057686241	40.7985734105729	40B-PM-1014-01	40B	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	0	0	0	1	0	0	1	0	POINT (-73.9573057686241 40.7985734105729)
1039	-73.9584646000078	40.7983984665955	40B-PM-1014-07	40B	PM	10142018	7	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	0	0	0	1	0	0	1	0	POINT (-73.9584646000078 40.7983984665955)
1185	-73.95823067436599	40.7989268396525	40B-AM-1019-08	40B	AM	10192018	8	Adult	Gray	White	Gray+White	Ground Plane	FALSE	0	0	1	1	0	0	1	1	POINT (-73.958230674366 40.7989268396525)
1196	-73.95801114962751	40.7985365971474	40B-AM-1019-05	40B	AM	10192018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE	0	0	0	1	1	1	1	0	POINT (-73.9580111496275 40.7985365971474)
1591	-73.95762233900821	40.79797466396471	40B-AM-1019-04	40B	AM	10192018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Ground Plane	FALSE	0	0	1	1	0	1	1	0	POINT (-73.9576223390082 40.79797466396471)
1761	-73.9575307970434	40.798317641948294	40B-PM-1014-08	40B	PM	10142018	8	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	0	0	0	1	0	0	1	0	POINT (-73.9575307970434 40.7983176419483)
1801	-73.9587072373474	40.7985209579925	40B-AM-1019-01	40B	AM	10192018	1	Adult	Gray	White	Gray+White	Ground Plane	FALSE	0	0	0	1	1	0	1	0	POINT (-73.9587072373474 40.7985209579925)
1986	-73.958247706428	40.7989079136796	40B-AM-1019-07	40B	AM	10192018	7	Adult	Gray	White	Gray+White	Ground Plane	FALSE	0	0	0	1	0	0	1	1	POINT (-73.958247706428 40.7989079136796)
2021	-73.95828003055091	40.798947371297395	40B-PM-1014-03	40B	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	0	0	0	1	0	0	1	0	POINT (-73.9582800305509 40.7989473712974)
2832	-73.958607566971	40.7983695505584	40B-PM-1014-04	40B	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon	Ground Plane	FALSE	0	0	0	1	0	0	1	0	POINT (-73.958607566971 40.7983695505584)