squirrels

Custom SQL query returning 11 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 "Date" = :p0 and "Runs from" = :p1 and (Location > :p3 or (Location = :p3 and rowid > :p2)) order by Location, rowid 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	Running	Eating	Foraging	Other Activities	Tail twitches	Indifferent	Lat/Long
2736	-73.95938952535009	40.797308584408704	38B-AM-1019-03	38B	AM	10192018	3	Juvenile	Gray		Gray+		Ground Plane	FALSE	0	1	1		1	1	POINT (-73.9593895253501 40.7973085844087)
2800	-73.9802983138318	40.7676540772339	1B-PM-1019-05	01B	PM	10192018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE	0	1	0		0	1	POINT (-73.9802983138318 40.7676540772339)
2802	-73.9533101544112	40.7938634280159	38H-AM-1019-01	38H	AM	10192018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	0	1	1		0	1	POINT (-73.9533101544112 40.7938634280159)
2834	-73.9651132904127	40.7905384124102	29A-PM-1019-02	29A	PM	10192018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	0	0	1		0	1	POINT (-73.9651132904127 40.7905384124102)
2841	-73.9693262952166	40.783260411082004	21B-AM-1019-01	21B	AM	10192018	1	Juvenile	Gray		Gray+		Ground Plane	FALSE	0	0	1		0	1	POINT (-73.9693262952166 40.783260411082)
2882	-73.956581233786	40.7902127690837	33H-AM-1019-01	33H	AM	10192018	1	Adult	Cinnamon	Gray	Cinnamon+Gray	Cinnamon patches	Ground Plane	FALSE	0	0	0	wrestling with child	0	0	POINT (-73.956581233786 40.79021276908371)
2885	-73.9530811255728	40.7983069118579	42F-AM-1019-02	42F	AM	10192018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE	0	1	1		0	1	POINT (-73.9530811255728 40.79830691185791)
2902	-73.9673220504383	40.777029634596296	15G-PM-1019-04	15G	PM	10192018	4	Adult	Gray		Gray+		Ground Plane	FALSE	0	0	1		0	0	POINT (-73.9673220504383 40.7770296345963)
2904	-73.97203897567171	40.7763524091989	13C-PM-1019-02	13C	PM	10192018	2	Adult	Gray		Gray+		Ground Plane	FALSE	1	0	0		1	1	POINT (-73.9720389756717 40.7763524091989)
2907	-73.96852016269341	40.783329261225	21B-AM-1019-05	21B	AM	10192018	5	Adult	Gray		Gray+		Ground Plane	FALSE	1	0	1		0	1	POINT (-73.9685201626934 40.783329261225)
2987	-73.9563724838337	40.7882504581015	31I-PM-1019-04	31I	PM	10192018	4	Adult	Gray		Gray+		Ground Plane	FALSE	1	0	0		0	1	POINT (-73.95637248383372 40.7882504581015)