squirrels

Custom SQL query returning 14 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 "Running" = :p1 and (Indifferent > :p3 or (Indifferent = :p3 and rowid > :p2)) order by Indifferent, 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	Specific Location	Running	Chasing	Climbing	Eating	Foraging	Kuks	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
804	-73.9697196619878	40.7814068507607	19B-AM-1019-01	19B	AM	10192018	1	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Side stripes	Ground Plane	FALSE		1	0	0	1	0	0	0	1	1	indifferent then runs from	POINT (-73.9697196619878 40.7814068507607)
922	-73.9708002461415	40.7726685284831	10F-PM-1019-10	10F	PM	10192018	10	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Arbor path & hill w/ bushes	1	0	0	1	1	0	1	1	0		POINT (-73.9708002461415 40.7726685284831)
999	-73.980948293606	40.76856888506279	2A-PM-1019-04	02A	PM	10192018	4	Juvenile	Gray	White	Gray+White		Above Ground	15	in tree!	1	0	0	0	0	0	0	1	0		POINT (-73.980948293606 40.7685688850628)
1517	-73.970041085185	40.7834427580313	21A-AM-1019-07	21A	AM	10192018	7	Adult	Gray		Gray+		Above Ground	25		1	0	1	0	0	0	0	1	0		POINT (-73.970041085185 40.783442758031306)
1613	-73.95992022335359	40.7972599930224	38A-AM-1019-02	38A	AM	10192018	2	Adult	Gray		Gray+		Above Ground	3		1	1	1	0	0	0	0	1	0		POINT (-73.9599202233536 40.7972599930224)
1877	-73.9524490779105	40.7936003219524	38I-AM-1019-01	38I	AM	10192018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	0	0	1	0		POINT (-73.9524490779105 40.7936003219524)
2320	-73.9576897478787	40.796469532845705	38C-AM-1019-02	38C	AM	10192018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	0	1	1	0		POINT (-73.9576897478787 40.7964695328457)
2412	-73.98094464895641	40.768503216587895	2A-PM-1019-03	02A	PM	10192018	3	Juvenile	Gray	White	Gray+White		Above Ground	15	in tree!	1	0	0	0	0	0	0	1	0		POINT (-73.9809446489564 40.7685032165879)
2466	-73.95994199262991	40.797277472881106	38A-AM-1019-01	38A	AM	10192018	1	Adult	Gray		Gray+		Above Ground	3		1	1	1	0	0	0	0	1	0		POINT (-73.9599419926299 40.7972774728811)
2657	-73.9582150734453	40.7962862794303	38C-AM-1019-08	38C	AM	10192018	8	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1	1	0	1	0		POINT (-73.9582150734453 40.7962862794303)
2688	-73.9799302952205	40.767720720979796	1B-PM-1019-02	01B	PM	10192018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0	0	0	1	0		POINT (-73.9799302952205 40.7677207209798)
2904	-73.97203897567171	40.7763524091989	13C-PM-1019-02	13C	PM	10192018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0	0	1	1	0		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	0	0	1	0	0	1	0		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	0	0	0	1	0		POINT (-73.95637248383372 40.7882504581015)