2018_Central_Park_Squirrel_Census_-_Squirrel_Data

23 rows where Above Ground Sighter Measurement = 10, Climbing = 0 and Shift = "PM" sorted by Highlight Fur Color

descending

Link	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	Eating	Foraging	Other Activities	Kuks	Quaas	Tail flags	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
281	281	-73.9619411917909	40.7923536640283	33B-PM-1010-11	33B	PM	10102018	11	Adult	Gray		Gray+		Above Ground	10		0	0	0	0		0	0	0	0	0	0		POINT (-73.9619411917909 40.7923536640283)
1673	1673	-73.9746940851342	40.7760966488186	11B-PM-1014-02	11B	PM	10142018	2	Juvenile	Gray		Gray+		Above Ground	10		0	1	0	0		0	0	0	0	0	0		POINT (-73.9746940851342 40.7760966488186)
1831	1831	-73.9746877519291	40.7761402808083	11B-PM-1014-03	11B	PM	10142018	3		Gray		Gray+		Above Ground	10		0	1	0	0		0	0	0	0	0	0		POINT (-73.9746877519291 40.7761402808083)
1926	1926	-73.9742811484852	40.775533619083	11B-PM-1014-08	11B	PM	10142018	8		Gray		Gray+		Above Ground	10		0	1	0	0		0	0	0	0	0	0		POINT (-73.97428114848522 40.775533619083)
2707	2707	-73.97431653210991	40.775467467857396	11B-PM-1014-07	11B	PM	10142018	7		Gray		Gray+		Above Ground	10		1	0	1	1		0	0	0	0	0	0		POINT (-73.9743165321099 40.7754674678574)
2893	2893	-73.97931014826541	40.7692600238491	3B-PM-1007-02	03B	PM	10072018	2	Adult	Gray		Gray+		Above Ground	10	in tree	0	0	0	0	chased by dog	0	0	0	0	0	0		POINT (-73.9793101482654 40.7692600238491)
2421	2421	-73.96822789059891	40.773302750805705	11H-PM-1013-02	11H	PM	10132018	2	Adult	Gray	Black	Gray+Black		Above Ground	10		0	0	0	0	digging	0	0	0	0	1	0		POINT (-73.9682278905989 40.7733027508057)
144	144	-73.9730750601212	40.7701304211944	6F-PM-1008-01	06F	PM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	1	0	0		0	0	0	0	0	0		POINT (-73.9730750601212 40.7701304211944)
337	337	-73.95831019276521	40.7852649316039	27I-PM-1020-05	27I	PM	10202018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	In tree	1	0	0	0		0	0	0	0	0	1	runs from (us)	POINT (-73.9583101927652 40.7852649316039)
1060	1060	-73.97288710611909	40.771298365894395	8F-PM-1012-08	08F	PM	10122018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0		0	0	0	0	0	1		POINT (-73.9728871061191 40.7712983658944)
1109	1109	-73.96781540330991	40.774278348448604	12H-PM-1007-01	12H	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	in tree	0	0	1	0		0	0	0	0	0	0		POINT (-73.9678154033099 40.7742783484486)
1194	1194	-73.96874625660729	40.783898987005	22B-PM-1014-06	22B	PM	10142018	6		Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	0	0	digging	0	0	0	0	0	0		POINT (-73.9687462566073 40.783898987005)
1768	1768	-73.97736964550309	40.7687241866704	3D-PM-1010-14	03D	PM	10102018	14	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	0	0	crying out	1	1	0	0	0	0		POINT (-73.9773696455031 40.7687241866704)
1960	1960	-73.97301589136609	40.7701310707272	6F-PM-1008-02	06F	PM	10082018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		1	1	0	0	chasing #2	0	0	0	0	0	0		POINT (-73.9730158913661 40.7701310707272)
1970	1970	-73.96314646937691	40.793415656751	33A-PM-1018-02	33A	PM	10182018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	Tree cavity [of] London Plane tree	0	0	0	0	hanging out,watching world	0	0	0	0	0	0	watching	POINT (-73.9631464693769 40.793415656751)
646	646	-73.954092292214	40.7979800395433	41E-PM-1013-05	41E	PM	10132018	5	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	White tail	Above Ground	10		0	0	1	0		0	0	0	0	0	0		POINT (-73.954092292214 40.7979800395433)
780	780	-73.9675472064204	40.7835947167436	22C-PM-1006-06	22C	PM	10062018	6	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10	on tree	0	0	1	0		0	0	0	0	0	0		POINT (-73.9675472064204 40.7835947167436)
1135	1135	-73.9667474482967	40.7760643720793	15H-PM-1008-01	15H	PM	10082018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10	Oak tree	0	1	0	0	watching me	0	1	1	0	0	0	observant	POINT (-73.9667474482967 40.7760643720793)
1871	1871	-73.9748367344424	40.7693513000034	5E-PM-1012-06	05E	PM	10122018	6	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	10	oak tree at end of ramp from Chess House	1	0	0	0		0	0	0	0	0	1		POINT (-73.9748367344424 40.7693513000034)
1028	1028	-73.97070123456609	40.7758938984066	13E-PM-1008-03	13E	PM	10082018	3	Juvenile	Gray	White	Gray+White		Above Ground	10	hanging upside down to get a nut	0	0	0	1		0	0	0	0	1	0		POINT (-73.9707012345661 40.7758938984066)
2185	2185	-73.9707571364399	40.7758859812524	13E-PM-1008-02	13E	PM	10082018	2	Adult	Gray	White	Gray+White		Above Ground	10		0	0	0	1		0	0	1	0	1	0		POINT (-73.9707571364399 40.7758859812524)
2213	2213	-73.9707487237344	40.7800822831001	17B-PM-1012-03	17B	PM	10122018	3	Adult	Gray	White	Gray+White		Above Ground	10		1	1	0	0	2/3 chasing each other	0	0	0	1	1	0		POINT (-73.9707487237344 40.7800822831001)
2231	2231	-73.95454276114769	40.793035381744104	36G-PM-1012-02	36G	PM	10122018	2	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0		0	0	0	0	0	0		POINT (-73.9545427611477 40.7930353817441)

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" (
"longitude" REAL,
  "latitude" REAL,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" INTEGER,
  "Hectare Squirrel Number" INTEGER,
  "Age" TEXT,
  "Primary Fur Color" TEXT,
  "Highlight Fur Color" TEXT,
  "Combination of Primary and Highlight Color" TEXT,
  "Color notes" TEXT,
  "Location" TEXT,
  "Above Ground Sighter Measurement" TEXT,
  "Specific Location" TEXT,
  "Running" INTEGER,
  "Chasing" INTEGER,
  "Climbing" INTEGER,
  "Eating" INTEGER,
  "Foraging" INTEGER,
  "Other Activities" TEXT,
  "Kuks" INTEGER,
  "Quaas" INTEGER,
  "Moans" INTEGER,
  "Tail flags" INTEGER,
  "Tail twitches" INTEGER,
  "Approaches" INTEGER,
  "Indifferent" INTEGER,
  "Runs from" INTEGER,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT
);