2018_Central_Park_Squirrel_Census_-_Squirrel_Data

34 rows where Above Ground Sighter Measurement = 15 and Shift = "AM" sorted by Lat/Long

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	Climbing	Eating	Foraging	Other Activities	Kuks	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long ▼
1939	1939	-73.9540151828782	40.7920066170587	35H-AM-1013-01	35H	AM	10132018	1	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	15	Climbing up tree	0	0	1	0	0		0	0	1	0	0	1		POINT (-73.9540151828782 40.7920066170587)
781	781	-73.955516031113	40.7923188156277	35G-AM-1007-01	35G	AM	10072018	1	Adult	Gray	White	Gray+White		Above Ground	15		0	0	1	0	0		0	0	0	0	1	0		POINT (-73.955516031113 40.7923188156277)
2262	2262	-73.9556177490335	40.788856916153705	32I-AM-1013-03	32I	AM	10132018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	0	1	0	0		0	0	0	0	0	0	watching me from tree - curious	POINT (-73.9556177490335 40.7888569161537)
374	374	-73.9556817958407	40.788852000621	32I-AM-1013-02	32I	AM	10132018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	0	1	0	0		0	0	0	0	0	0	watching me from tree - curious	POINT (-73.9556817958407 40.788852000621)
2242	2242	-73.9565824187667	40.797312050952	40D-AM-1013-06	40D	AM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		1	0	1	0	1		1	0	1	0	0	1		POINT (-73.9565824187667 40.797312050952)
966	966	-73.95831758180199	40.791656668315795	33E-AM-1014-12	33E	AM	10142018	12	Adult	Gray	White	Gray+White		Above Ground	15		0	0	0	0	0	sleeping	0	0	0	0	0	0	asleep	POINT (-73.958317581802 40.7916566683158)
1767	1767	-73.958719099962	40.7947587726617	36C-AM-1014-04	36C	AM	10142018	4		Gray	White	Gray+White		Above Ground	15	Ground then tree to eat	1	0	1	1	0		0	0	0	0	0	1		POINT (-73.958719099962 40.7947587726617)
2653	2653	-73.958932543729	40.7913445531266	33E-AM-1014-11	33E	AM	10142018	11	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	15		0	1	0	0	0		0	0	0	0	1	0		POINT (-73.958932543729 40.7913445531266)
2303	2303	-73.9589470461357	40.7912817646361	33E-AM-1014-10	33E	AM	10142018	10	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	15		0	1	0	0	0		0	0	0	0	1	0		POINT (-73.9589470461357 40.7912817646361)
608	608	-73.95896759955171	40.791311922358396	33E-AM-1014-09	33E	AM	10142018	9	Juvenile	Black		Black+		Above Ground	15		0	1	0	0	0		0	0	0	0	1	0		POINT (-73.9589675995517 40.7913119223584)
1104	1104	-73.95898529894859	40.7912720015917	33E-AM-1014-07	33E	AM	10142018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	15		0	0	1	0	0		0	0	0	0	1	0		POINT (-73.9589852989486 40.7912720015917)
852	852	-73.9609704650925	40.7938786854735	34B-AM-1013-03	34B	AM	10132018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	15		1	0	1	0	0	hopping	0	0	0	1	0	1		POINT (-73.9609704650925 40.7938786854735)
1145	1145	-73.9611446263364	40.7911003407299	32D-AM-1013-03	32D	AM	10132018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	15		0	0	1	0	0		0	0	0	0	1	0		POINT (-73.9611446263364 40.7911003407299)
488	488	-73.9615751148595	40.795455123814605	36A-AM-1018-01	36A	AM	10182018	1	Juvenile	Gray	White	Gray+White		Above Ground	15		0	0	0	1	0	eating (red berries)	0	0	0	0	1	0		POINT (-73.9615751148595 40.7954551238146)
1203	1203	-73.9616999731028	40.7954126939561	36A-AM-1018-02	36A	AM	10182018	2	Juvenile	Gray	White	Gray+White		Above Ground	15		0	0	0	1	0	eating (red berries)	0	0	0	0	1	0		POINT (-73.9616999731028 40.7954126939561)
1989	1989	-73.96316467546471	40.7925716810884	32A-AM-1018-02	32A	AM	10182018	2	Adult	Gray		Gray+		Above Ground	15		1	1	0	0	0		0	0	0	0	1	0		POINT (-73.9631646754647 40.7925716810884)
1147	1147	-73.96318185288159	40.7925332194132	32A-AM-1018-01	32A	AM	10182018	1	Adult	Gray		Gray+		Above Ground	15		1	1	0	0	0		0	0	0	0	1	0		POINT (-73.9631818528816 40.7925332194132)
510	510	-73.9638590768396	40.777678211498106	18I-AM-1017-02	18I	AM	10172018	2	Adult	Gray	Black	Gray+Black		Above Ground	15		0	0	1	0	0		0	0	1	0	0	1		POINT (-73.9638590768396 40.7776782114981)
371	371	-73.964080104186	40.79078986272871	30B-AM-1007-02	30B	AM	10072018	2	Adult	Gray		Gray+		Above Ground	15		1	0	0	0	0		0	0	0	0	0	0		POINT (-73.964080104186 40.7907898627287)
380	380	-73.9649590119935	40.782210792076896	21F-AM-1018-01	21F	AM	10182018	1	Adult	Gray		Gray+		Above Ground	15		0	0	1	0	0		0	0	1	0	1	0		POINT (-73.9649590119935 40.7822107920769)
2813	2813	-73.96591181893591	40.7765739928504	15H-AM-1013-02	15H	AM	10132018	2	Adult	Gray		Gray+		Above Ground	15		0	0	1	0	0		0	0	0	0	1	0		POINT (-73.9659118189359 40.7765739928504)
783	783	-73.96776542897571	40.786785529449	25A-AM-1013-03	25A	AM	10132018	3		Gray		Gray+		Above Ground	15	BIG TREE	0	0	0	0	0	being chased by #2	0	0	0	0	1	0		POINT (-73.9677654289757 40.786785529449)
582	582	-73.9677779408464	40.78674822113489	25A-AM-1013-02	25A	AM	10132018	2		Gray		Gray+		Above Ground	15	BIG TREE	0	1	0	0	0	chasing #3	0	1	0	0	1	0		POINT (-73.9677779408464 40.7867482211349)
657	657	-73.9679008849677	40.7759013923034	14G-AM-1012-02	14G	AM	10122018	2		Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	0	1	0	0		0	0	0	0	1	0		POINT (-73.9679008849677 40.7759013923034)
2361	2361	-73.9708032298419	40.7784265674544	15C-AM-1010-02	15C	AM	10102018	2	Adult	Gray		Gray+		Above Ground	15		0	0	1	0	0	nest building	0	0	0	0	1	0		POINT (-73.9708032298419 40.77842656745441)
163	163	-73.97123088643941	40.7714534847379	9G-AM-1007-04	09G	AM	10072018	4	Adult	Gray	White	Gray+White		Above Ground	15		0	0	0	0	0	grooming	0	0	0	0	1	0		POINT (-73.9712308864394 40.7714534847379)
1624	1624	-73.97370600439879	40.772566022498296	8D-AM-1007-05	08D	AM	10072018	5	Adult	Gray		Gray+		Above Ground	15		0	0	0	1	0		0	0	0	0	0	0		POINT (-73.9737060043988 40.7725660224983)
801	801	-73.9743342303548	40.772774294833205	8D-AM-1007-08	08D	AM	10072018	8	Adult	Gray		Gray+		Above Ground	15		0	0	0	0	0	communicating from tree	0	0	0	0	0	0		POINT (-73.97433423035481 40.7727742948332)
1595	1595	-73.9754696312232	40.768191647091996	4E-AM-1020-02	04E	AM	10202018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments.	Above Ground	15		0	0	1	0	1	foraging (on the tree itself)	0	0	0	0	1	0		POINT (-73.9754696312232 40.768191647092)
1796	1796	-73.9765355395622	40.7735653237366	8B-AM-1007-03	08B	AM	10072018	3	Adult	Gray		Gray+		Above Ground	15		0	0	1	0	0		0	0	0	0	1	0		POINT (-73.97653553956222 40.7735653237366)
1500	1500	-73.9769969548024	40.7710711265211	6C-AM-1007-01	06C	AM	10072018	1	Adult	Gray	White	Gray+White	vid!	Above Ground	15		0	0	1	0	0		0	0	1	0	0	0	curious,but wary	POINT (-73.97699695480242 40.7710711265211)
1607	1607	-73.9770508584979	40.7710769301257	6C-AM-1007-02	06C	AM	10072018	2	Adult			+		Above Ground	15		0	0	1	0	0	pulling things off branches	0	0	0	0	0	0		POINT (-73.9770508584979 40.7710769301257)
207	207	-73.9770824412252	40.770996130945704	5C-AM-1006-03	05C	AM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	0	1	0	0		0	0	0	0	1	0		POINT (-73.97708244122522 40.7709961309457)
260	260	-73.97843611793199	40.7724769242403	6A-AM-1006-06	06A	AM	10062018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	15	tree	0	0	1	0	0		1	0	0	0	0	0		POINT (-73.978436117932 40.7724769242403)

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
);