2018_Central_Park_Squirrel_Census_-_Squirrel_Data

149 rows where Foraging = 0 and Hectare Squirrel Number = 5 sorted by Highlight Fur Color descending

descending

Link	rowid	longitude	latitude	Unique Squirrel ID	Hectare	Shift	Date	Hectare Squirrel Number	Age	Primary Fur Color	Combination of Primary and Highlight Color	Color notes	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Climbing	Eating	Other Activities	Kuks	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
360	360	-73.9672054610151	40.7876519923501	26A-PM-1006-05	26A	PM	10062018	5	Adult	Gray	Gray+		Above Ground	40		0	1	0	0		0	0	1	0	0	0		POINT (-73.9672054610151 40.7876519923501)
415	415	-73.95701318903791	40.799178673612396	41B-PM-1014-05	41B	PM	10142018	5	Adult	Gray	Gray+		Above Ground	25		0	0	1	0		1	0	0	0	1	1		POINT (-73.9570131890379 40.7991786736124)
471	471	-73.97072153948871	40.7727508149058	10G-AM-1006-05	10G	AM	10062018	5	Adult	Gray	Gray+		Ground Plane	FALSE		0	1	0	0	chasing (#6)	1	0	0	0	0	0		POINT (-73.9707215394887 40.7727508149058)
500	500	-73.95683055130169	40.7974086631267	40C-PM-1006-05	40C	PM	10062018	5	Adult	Gray	Gray+		Ground Plane	FALSE		0	0	0	0		0	0	0	0	0	0		POINT (-73.9568305513017 40.7974086631267)
578	578	-73.9671306431211	40.783887015905705	22C-PM-1006-05	22C	PM	10062018	5	Juvenile	Gray	Gray+		Ground Plane	FALSE		0	0	0	1		0	0	0	0	0	0		POINT (-73.9671306431211 40.783887015905705)
634	634	-73.95963759070379	40.79073477083529	32E-AM-1007-05	32E	AM	10072018	5	Adult	Black	Black+		Above Ground	30		0	0	1	0		0	0	0	0	1	0		POINT (-73.9596375907038 40.79073477083531)
676	676	-73.9710207438538	40.7682187144432	5I-AM-1010-05	05I	AM	10102018	5	Adult	Gray	Gray+		Ground Plane	FALSE		0	0	0	1		0	0	1	0	1	0		POINT (-73.9710207438538 40.7682187144432)
696	696	-73.96560981941491	40.7757643078973	15I-AM-1008-05	15I	AM	10082018	5	Adult	Gray	Gray+		Above Ground	5		0	0	1	0		0	0	0	0	0	1		POINT (-73.9656098194149 40.7757643078973)
977	977	-73.9764601882854	40.766070446642	1F-AM-1010-05	01F	AM	10102018	5	Adult	Gray	Gray+		Ground Plane	FALSE		0	0	0	1		0	0	0	0	1	0		POINT (-73.9764601882854 40.766070446642)
983	983	-73.9641552070803	40.7908479527923	30B-AM-1007-05	30B	AM	10072018	5	Adult	Gray	Gray+		Above Ground	10		1	0	0	0		0	0	0	0	0	0		POINT (-73.9641552070803 40.7908479527923)
1188	1188	-73.9669529835992	40.787186415136496	25A-AM-1013-05	25A	AM	10132018	5		Gray	Gray+		Ground Plane	FALSE	CROSS BRIDLE - INTO TREE TO AVOID DOGGO	1	0	1	0	d.p.t.	0	1	1	0	1	0	calm	POINT (-73.96695298359921 40.7871864151365)
1288	1288	-73.97304542959971	40.77029094543921	7F-AM-1008-05	07F	AM	10082018	5	Adult	Gray	Gray+		Ground Plane	FALSE	bush	0	1	0	0		0	0	0	0	1	0		POINT (-73.9730454295997 40.7702909454392)
1348	1348	-73.95991976123891	40.7954836456006	36B-PM-1013-05	36B	PM	10132018	5	Adult	Gray	Gray+		Above Ground	4		1	0	0	0		0	0	0	0	0	1		POINT (-73.9599197612389 40.7954836456006)
1407	1407	-73.9704778551644	40.77831191136271	15D-AM-1007-05	15D	AM	10072018	5	Adult		+					0	0	0	0		0	0	0	0	0	0		POINT (-73.9704778551644 40.7783119113627)
1428	1428	-73.9666113598566	40.775266255031205	14H-PM-1012-05	14H	PM	10122018	5	Adult	Gray	Gray+		Ground Plane	FALSE		0	0	0	1		0	0	0	1	0	0	approaches (someone was feeding it)	POINT (-73.9666113598566 40.7752662550312)
1446	1446	-73.9775238847836	40.7675792683587	2D-AM-1007-05	02D	AM	10072018	5	Adult	Gray	Gray+		Above Ground	100		1	0	0	0		0	0	0	0	0	0		POINT (-73.9775238847836 40.7675792683587)
1496	1496	-73.9615500510038	40.7920799263699	32C-PM-1013-05	32C	PM	10132018	5	Adult	Gray	Gray+		Ground Plane	FALSE		1	0	0	0		0	0	0	0	0	0		POINT (-73.9615500510038 40.7920799263699)
1574	1574	-73.95618409358029	40.799203782149704	42C-PM-1013-05	42C	PM	10132018	5	Adult	Gray	Gray+		Above Ground	20		0	0	0	1		1	0	0	0	1	0		POINT (-73.9561840935803 40.7992037821497)
1594	1594	-73.9778730762957	40.770827251547	5B-PM-1013-05	05B	PM	10132018	5	Adult	Gray	Gray+		Above Ground	3		1	0	1	0		0	0	0	0	0	1		POINT (-73.9778730762957 40.770827251547)
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		POINT (-73.9737060043988 40.7725660224983)
1682	1682	-73.97592584072879	40.7667622711142	2F-PM-1014-05	02F	PM	10142018	5	Adult	Gray	Gray+		Ground Plane	FALSE		1	0	0	0		0	0	0	0	1	0		POINT (-73.9759258407288 40.7667622711142)
1692	1692	-73.973268329435	40.770829651707295	7E-AM-1006-05	07E	AM	10062018	5	Adult	Gray	Gray+		Above Ground	25	in tree	0	0	1	0		0	0	0	0	0	0		POINT (-73.973268329435 40.7708296517073)
1842	1842	-73.9532804650089	40.7934579333341	37H-PM-1006-05	37H	PM	10062018	5			+		Above Ground		tree	0	0	0	0		0	0	0	0	0	0		POINT (-73.9532804650089 40.7934579333341)
1845	1845	-73.9626560807032	40.7884633049896	28D-AM-1012-05	28D	AM	10122018	5	Juvenile	Black	Black+		Above Ground	30		0	0	1	0		0	0	0	0	0	0		POINT (-73.9626560807032 40.7884633049896)
1854	1854	-73.9618076359384	40.7947808718203	35A-PM-1013-05	35A	PM	10132018	5	Adult	Gray	Gray+		Above Ground	3	in tree	0	0	1	0		0	0	0	0	0	0		POINT (-73.9618076359384 40.7947808718203)
1856	1856	-73.97829402311491	40.7694236097224	4B-PM-1018-05	04B	PM	10182018	5	Adult	Gray	Gray+		Ground Plane	FALSE		0	0	0	1		0	0	0	0	1	0		POINT (-73.9782940231149 40.7694236097224)
1883	1883	-73.9568108465086	40.7971727026108	39D-AM-1008-05	39D	AM	10082018	5	Adult	Gray	Gray+		Ground Plane	FALSE		0	0	0	0		0	0	0	0	0	0		POINT (-73.95681084650862 40.7971727026108)
1888	1888	-73.9673919075839	40.7786845769177	17F-PM-1020-05	17F	PM	10202018	5	Adult	Gray	Gray+		Ground Plane	FALSE		1	0	0	0		0	0	0	0	0	0		POINT (-73.9673919075839 40.7786845769177)
1900	1900	-73.9529224802393	40.796189576364895	40G-PM-1013-05	40G	PM	10132018	5	Adult	Gray	Gray+		Ground Plane	FALSE		1	0	0	0		0	0	0	0	0	1	runs from (to the tree)	POINT (-73.9529224802393 40.7961895763649)
1940	1940	-73.9696445614055	40.779148620362704	17D-AM-1008-05	17D	AM	10082018	5	Juvenile	Gray	Gray+		Above Ground	2		0	0	1	0		0	0	0	0	1	0		POINT (-73.9696445614055 40.7791486203627)
1994	1994	-73.9598463837775	40.783452472425395	25I-PM-1007-05	25I	PM	10072018	5	Adult	Gray	Gray+		Above Ground	30		0	0	1	0		0	0	0	0	0	0		POINT (-73.9598463837775 40.7834524724254)
2032	2032	-73.9590157104896	40.7956884493421	37C-PM-1013-05	37C	PM	10132018	5	Adult	Gray	Gray+		Ground Plane	FALSE		1	0	0	0		0	0	0	0	1	0		POINT (-73.9590157104896 40.7956884493421)
2053	2053	-73.97118102224209	40.7773445611969	14D-PM-1019-05	14D	PM	10192018	5	Adult	Gray	Gray+		Ground Plane	FALSE		1	0	0	0		0	0	0	0	0	0		POINT (-73.9711810222421 40.7773445611969)
2064	2064	-73.970260899173	40.783651724864995	21A-AM-1019-05	21A	AM	10192018	5	Adult	Gray	Gray+		Above Ground	2		0	0	1	0		0	0	0	0	1	0		POINT (-73.970260899173 40.783651724865)
2167	2167	-73.9799594281222	40.7701978146968	4A-AM-1007-05	04A	AM	10072018	5	Adult	Gray	Gray+		Ground Plane	FALSE		0	0	0	1		0	0	0	0	1	0		POINT (-73.9799594281222 40.7701978146968)
2170	2170	-73.9678923667678	40.7819675626236	20C-PM-1018-05	20C	PM	10182018	5	Juvenile	Gray	Gray+		Ground Plane	FALSE		1	0	0	0		0	0	0	1	0	0		POINT (-73.9678923667678 40.781967562623606)
2209	2209	-73.9697583235533	40.7787320391004	16D-AM-1007-05	16D	AM	10072018	5	Adult	Gray	Gray+	didn't get a good look	Ground Plane	FALSE		1	0	0	0		0	0	0	0	0	1		POINT (-73.96975832355331 40.7787320391004)
2552	2552	-73.97249477106979	40.7696619340886	6G-AM-1008-05	06G	AM	10082018	5	Adult	Gray	Gray+		Above Ground	30	branch	0	0	1	0	sitting	0	0	0	0	1	0		POINT (-73.9724947710698 40.7696619340886)
2581	2581	-73.9635981227569	40.7928169540326	32A-AM-1018-05	32A	AM	10182018	5	Adult	Gray	Gray+		Ground Plane	FALSE		1	0	0	0		0	0	0	0	1	0		POINT (-73.9635981227569 40.7928169540326)
2658	2658	-73.9690212174	40.783409940410706	21B-PM-1017-05	21B	PM	10172018	5	Juvenile	Gray	Gray+		Ground Plane	FALSE		1	0	0	0		0	0	0	0	0	0		POINT (-73.9690212174 40.7834099404107)
2693	2693	-73.95614986460359	40.7949288561893	37E-AM-1013-05	37E	AM	10132018	5	?		+		Above Ground	10	unsure, just heard kuks	0	0	0	0		1	0	0	0	0	0		POINT (-73.9561498646036 40.79492885618931)
2777	2777	-73.98108436110859	40.768790549369896	2A-PM-1019-05	02A	PM	10192018	5	?	Gray	Gray+		Above Ground	50	in tall planetree	1	0	0	0		0	0	0	0	0	0		POINT (-73.9810843611086 40.7687905493699)
2820	2820	-73.9615926031253	40.7944223235385	35B-PM-1013-05	35B	PM	10132018	5	Adult	Gray	Gray+		Ground Plane	FALSE		1	0	1	0	chased by dog #2	1	0	0	0	0	1	runs from (dog)	POINT (-73.96159260312531 40.7944223235385)
2859	2859	-73.9786940945874	40.769082027688796	3B-PM-1007-05	03B	PM	10072018	5	Juvenile	Gray	Gray+		Above Ground	6	on rock	0	0	1	1		0	0	0	0	1	0		POINT (-73.9786940945874 40.7690820276888)
2917	2917	-73.9770313887741	40.7724869252099	7B-AM-1008-05	07B	AM	10082018	5	Adult	Gray	Gray+		Above Ground			0	1	0	0		0	0	0	0	1	0		POINT (-73.9770313887741 40.772486925209904)
2930	2930	-73.9692563597762	40.770904999952	9H-PM-1018-05	09H	PM	10182018	5	Adult	Gray	Gray+		Ground Plane	FALSE		1	1	0	0		0	0	0	0	0	0		POINT (-73.9692563597762 40.770904999952)
2970	2970	-73.9619019299709	40.7924476439693	33B-PM-1010-05	33B	PM	10102018	5	Adult	Gray	Gray+		Ground Plane	FALSE		0	0	0	0		0	0	0	0	1	0		POINT (-73.9619019299709 40.7924476439693)
2990	2990	-73.97660121083071	40.7712310725379	6C-AM-1007-05	06C	AM	10072018	5	Adult	Gray	Gray+		Above Ground	20		0	1	1	0	chasing #4	0	0	0	0	1	0		POINT (-73.9766012108307 40.7712310725379)
2991	2991	-73.96846326736029	40.784890952519795	23A-AM-1018-05	23A	AM	10182018	5	Adult	Gray	Gray+		Ground Plane	FALSE		1	0	0	0		0	0	0	0	0	1		POINT (-73.9684632673603 40.7848909525198)

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