2018_Central_Park_Squirrel_Census_-_Squirrel_Data

86 rows where Age = "Juvenile", Foraging = 0, Indifferent = 0 and Running = 0

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by longitude Sort by latitude Sort by Unique Squirrel ID Sort by Hectare Sort by Shift Sort by Date Sort by Hectare Squirrel Number Sort by Age Sort by Primary Fur Color Sort by Highlight Fur Color Sort by Combination of Primary and Highlight Color Sort by Color notes Sort by Location Sort by Above Ground Sighter Measurement Sort by Specific Location Sort by Running Sort by Chasing Sort by Climbing Sort by Eating Sort by Foraging Sort by Other Activities Sort by Kuks Sort by Quaas Sort by Moans Sort by Tail flags Sort by Tail twitches Sort by Approaches Sort by Indifferent Sort by Runs from Sort by Other Interactions Sort by Lat/Long

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Runs from, Other Interactions

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	Quaas	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
4	4	-73.9757249834141	40.7697032606755	5D-PM-1018-05	05D	PM	10182018	5	Juvenile	Gray		Gray+		Above Ground	3		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9757249834141 40.7697032606755)
6	6	-73.9565700386162	40.7902561000937	33H-AM-1019-02	33H	AM	10192018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	wrestling with mother	0	0	0	0	0	0	0	0		POINT (-73.9565700386162 40.7902561000937)
52	52	-73.9675634326877	40.781347735250705	19D-AM-1007-01	19D	AM	10072018	1	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	0	1	1	0		0	0	0	0	0	0	0	0	fenced off area can't approach	POINT (-73.9675634326877 40.7813477352507)
98	98	-73.9730277911422	40.771214548882796	7F-AM-1008-16	07F	AM	10082018	16	Juvenile	Gray		Gray+		Above Ground	2	tree	0	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9730277911422 40.7712145488828)
100	100	-73.9761592532482	40.774721358538706	10A-AM-1006-04	10A	AM	10062018	4	Juvenile	Gray		Gray+		Above Ground	10	tree near large rock on Bridle Path	0	0	0	0	0	walking on branch	0	0	0	0	1	0	0	0		POINT (-73.9761592532482 40.7747213585387)
173	173	-73.95877018015099	40.793412394152796	35D-PM-1013-04	35D	PM	10132018	4	Juvenile	Gray	White	Gray+White					0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.958770180151 40.7934123941528)
254	254	-73.9762246600197	40.775164077652	10A-AM-1006-03	10A	AM	10062018	3	Juvenile	Cinnamon		Cinnamon+		Ground Plane	FALSE	Bridle Path lawn	0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9762246600197 40.775164077652)
314	314	-73.960601067176	40.7917243850136	32D-PM-1006-09	32D	PM	10062018	9	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	1	0	0		POINT (-73.960601067176 40.7917243850136)
341	341	-73.9703161745884	40.7702610461336	8H-PM-1014-05	08H	PM	10142018	5	Juvenile	Gray		Gray+		Above Ground	2		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9703161745884 40.7702610461336)
356	356	-73.97610364001441	40.77054826845939	6D-PM-1020-03	06D	PM	10202018	3	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9761036400144 40.7705482684594)
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	0	0	watching me from tree - curious	POINT (-73.9556817958407 40.788852000621)
421	421	-73.9664630067791	40.775636151582496	14H-AM-1007-04	14H	AM	10072018	4	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9664630067791 40.7756361515825)
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	0	0	0		POINT (-73.9671306431211 40.783887015905705)
588	588	-73.9646597452128	40.7827698220703	22F-AM-1007-07	22F	AM	10072018	7	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	3		0	0	1	0	0		0	0	0	0	1	0	0	0	alert & aware	POINT (-73.9646597452128 40.7827698220703)
593	593	-73.95933528061751	40.7918150568046	33E-AM-1014-02	33E	AM	10142018	2	Juvenile	Black		Black+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9593352806175 40.7918150568046)
594	594	-73.9727488640736	40.7781916780621	14B-PM-1014-06	14B	PM	10142018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	watching me	0	0	0	0	0	1	0	0	skittish	POINT (-73.9727488640736 40.7781916780621)
635	635	-73.96732355553209	40.7786749596774	17F-PM-1020-04	17F	PM	10202018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground			0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9673235555321 40.7786749596774)
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	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.954092292214 40.7979800395433)
654	654	-73.976769659152	40.7741908010484	9A-AM-1013-04	09A	AM	10132018	4	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.976769659152 40.7741908010484)
701	701	-73.95292302079079	40.7960663442573	40G-PM-1013-06	40G	PM	10132018	6	Juvenile	Gray		Gray+		Ground Plane	FALSE	along the road	0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9529230207908 40.7960663442573)
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	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9675472064204 40.7835947167436)
792	792	-73.97301156879641	40.7741018274312	10D-AM-1008-05	10D	AM	10082018	5	Juvenile	Gray	White	Gray+White		Above Ground	25		0	0	1	1	0		0	0	0	0	0	0	0	0		POINT (-73.9730115687964 40.7741018274312)
820	820	-73.9801902133148	40.769557595068	3A-AM-1012-03	03A	AM	10122018	3	Juvenile	Gray	Black, Cinnamon	Gray+Black, Cinnamon	Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments.	Above Ground	1		0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9801902133148 40.769557595068)
844	844	-73.9642379942652	40.777479252073796	17I-PM-1017-01	17I	PM	10172018	1	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	15		0	0	1	0	0		0	0	0	0	0	0	0	0	was in a tree,so i couldn't really tell	POINT (-73.9642379942652 40.7774792520738)
876	876	-73.96727895735371	40.7874778720268	26A-PM-1006-02	26A	PM	10062018	2	Juvenile	Gray		Gray+	injured	Ground Plane	FALSE		0	0	0	0	0	not moving	0	0	0	0	0	0	0	0		POINT (-73.96727895735371 40.7874778720268)
896	896	-73.9755055978764	40.77074386817421	6D-AM-1008-02	06D	AM	10082018	2	Juvenile	Gray		Gray+		Above Ground	10		0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9755055978764 40.7707438681742)
1003	1003	-73.9645547556826	40.776877007081	16I-AM-1008-04	16I	AM	10082018	4	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	9	tree hollow	0	0	0	0	0	in hollow	0	0	0	0	0	0	0	0	curious	POINT (-73.9645547556826 40.776877007081)
1025	1025	-73.9763506612375	40.771611393182	7C-PM-1020-05	07C	PM	10202018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9763506612375 40.771611393182)
1111	1111	-73.96327993398721	40.7808316436308	21H-PM-1018-01	21H	PM	10182018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	staring	0	0	0	0	1	1	0	0		POINT (-73.9632799339872 40.7808316436308)
1172	1172	-73.9706929270645	40.77278411194239	10G-AM-1006-06	10G	AM	10062018	6	Juvenile	Gray		Gray+	skinny tail	Ground Plane	FALSE		0	1	0	0	0	chasing (#5)	1	0	0	0	0	0	0	0		POINT (-73.9706929270645 40.7727841119424)
1215	1215	-73.9728895595977	40.769937833229896	6F-AM-1006-01	06F	AM	10062018	1	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	1	1	0		0	0	0	0	0	1	0	0		POINT (-73.9728895595977 40.7699378332299)
1230	1230	-73.9790822606486	40.7714466633386	5A-AM-1006-03	05A	AM	10062018	3	Juvenile	Cinnamon		Cinnamon+		Above Ground	8		0	0	1	1	0		0	0	0	1	0	0	0	1		POINT (-73.9790822606486 40.7714466633386)
1254	1254	-73.97640135898651	40.766306349920704	1F-PM-1019-03	01F	PM	10192018	3	Juvenile	Gray		Gray+		Above Ground	1		0	0	0	0	0	hiding	0	0	0	0	0	0	0	0		POINT (-73.9764013589865 40.7663063499207)
1302	1302	-73.9704024529864	40.772925606388895	10G-AM-1006-04	10G	AM	10062018	4	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0	chasing (#3)	1	0	0	0	0	0	0	0		POINT (-73.9704024529864 40.7729256063889)
1313	1313	-73.9671813866177	40.783864003203796	22C-PM-1006-04	22C	PM	10062018	4	Juvenile	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9671813866177 40.7838640032038)
1339	1339	-73.96864133261721	40.7817423907284	19C-PM-1018-08	19C	PM	10182018	8	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray, Cinnamon & White selected as Primary. Gray & White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9686413326172 40.7817423907284)
1345	1345	-73.95813265542058	40.7918074743129	34E-PM-1006-02	34E	PM	10062018	2	Juvenile	Black	Gray, White	Black+Gray, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9581326554206 40.7918074743129)
1354	1354	-73.97652692820591	40.774687663524794	9A-AM-1013-10	09A	AM	10132018	10	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	1	1	0		0	0	0	0	0	0	0	1		POINT (-73.9765269282059 40.7746876635248)
1357	1357	-73.96313500206341	40.791907210332	32B-PM-1010-01	32B	PM	10102018	1	Juvenile	Gray		Gray+		Above Ground	25	in tree	0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9631350020634 40.791907210332)
1388	1388	-73.9685709455958	40.774487702650596	12G-PM-1007-07	12G	PM	10072018	7	Juvenile			+		Above Ground	45		0	0	0	1	0	acorns	0	0	0	0	0	0	0	0		POINT (-73.9685709455958 40.7744877026506)
1392	1392	-73.96480906981759	40.7903882097837	29A-PM-1019-03	29A	PM	10192018	3	Juvenile	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	1	0	1	ran from,but now approaching. kind of weirding me out.	POINT (-73.9648090698176 40.7903882097837)
1395	1395	-73.9710801547498	40.7760872452093	13D-AM-1014-03	13D	AM	10142018	3	Juvenile	Gray	White	Gray+White		Above Ground	2		0	1	1	1	0		0	0	0	0	0	0	0	1		POINT (-73.9710801547498 40.7760872452093)
1411	1411	-73.98028400317591	40.7678599069819	1B-PM-1019-04	01B	PM	10192018	4	Juvenile	Gray	White	Gray+White		Above Ground	25	in tree	0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9802840031759 40.7678599069819)
1415	1415	-73.9678561384348	40.77828773978221	16E-PM-1018-02	16E	PM	10182018	2	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	0	0	gets distance from people but then continues to chase #1	POINT (-73.9678561384348 40.7782877397822)
1431	1431	-73.9601918930677	40.7944134683406	35C-AM-1007-01	35C	AM	10072018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20	(white oak)	0	0	0	0	0	sitting still	0	0	0	0	0	0	0	0		POINT (-73.9601918930677 40.7944134683406)
1466	1466	-73.96511776576759	40.7812408103825	20F-PM-1007-05	20F	PM	10072018	5	Juvenile	Gray	White	Gray+White	white tail	Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9651177657676 40.781240810382506)
1548	1548	-73.9790044506465	40.7689469479245	3B-AM-1010-03	03B	AM	10102018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0	chasing #2	0	0	0	0	0	0	0	1		POINT (-73.9790044506465 40.7689469479245)
1596	1596	-73.96669451239221	40.7839956493194	22C-PM-1006-11	22C	PM	10062018	11	Juvenile	Gray		Gray+		Above Ground	13		0	0	1	0	0		1	0	0	0	0	0	0	0		POINT (-73.9666945123922 40.7839956493194)
1620	1620	-73.96356061997841	40.782206970617	22G-AM-1018-03	22G	AM	10182018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9635606199784 40.782206970617)
1625	1625	-73.9736873018042	40.76491066771379	1I-PM-1012-02	01I	PM	10122018	2	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments.	Above Ground	1	tree	0	0	1	0	0		1	0	0	0	0	0	0	1		POINT (-73.9736873018042 40.7649106677138)
1631	1631	-73.9527196716568	40.792363826828	36I-PM-1007-11	36I	PM	10072018	11	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	3		0	0	1	0	0		0	0	0	0	0	0	0	1	me!	POINT (-73.9527196716568 40.792363826828)
1645	1645	-73.9619673317128	40.7924176673037	33B-PM-1010-08	33B	PM	10102018	8	Juvenile	Gray		Gray+		Above Ground		running up tree	0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9619673317128 40.7924176673037)
1653	1653	-73.9695881075086	40.7842441291991	21A-AM-1019-01	21A	AM	10192018	1	Juvenile	Gray	Black	Gray+Black		Above Ground	3		0	0	1	0	0		0	0	0	0	0	0	0	0	keeps to tree,drops down on side away from people	POINT (-73.9695881075086 40.7842441291991)
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	0	0	0		POINT (-73.9746940851342 40.7760966488186)
1732	1732	-73.97671414072741	40.7737313251559	8A-PM-1014-02	08A	PM	10142018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	0	1	1	0		0	0	0	0	0	0	0	1	runs from (goes up a tree)	POINT (-73.9767141407274 40.7737313251559)
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	0	crying out	1	1	0	0	0	0	0	0		POINT (-73.9773696455031 40.7687241866704)
1790	1790	-73.97305925481159	40.7740879251541	10D-AM-1008-04	10D	AM	10082018	4	Juvenile	Gray		Gray+		Above Ground	25		0	1	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9730592548116 40.7740879251541)
1832	1832	-73.9693159934697	40.7831212338295	21B-PM-1017-03	21B	PM	10172018	3	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	1		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9693159934697 40.7831212338295)
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	0	0	0		POINT (-73.9626560807032 40.7884633049896)
1916	1916	-73.9693504617353	40.7830678709405	21B-PM-1017-02	21B	PM	10172018	2	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	1		0	1	0	0	0		0	1	0	0	0	0	0	0	stood on hind legs with front legs on the chest	POINT (-73.9693504617353 40.7830678709405)
1999	1999	-73.95498609472341	40.79115503283089	34H-PM-1006-07	34H	PM	10062018	7	Juvenile	Gray	White	Gray+White	white belly	Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9549860947234 40.7911550328309)
2028	2028	-73.96873477318609	40.7718955594385	10H-AM-1014-03	10H	AM	10142018	3	Juvenile			+		Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9687347731861 40.7718955594385)
2074	2074	-73.9676246014119	40.786355136088	24A-PM-1007-05	24A	PM	10072018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	45	in tree	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9676246014119 40.786355136088)
2098	2098	-73.9700779726297	40.7722086251085	10G-AM-1006-11	10G	AM	10062018	11	Juvenile	Gray		Gray+		Above Ground	2		0	0	1	0	0		0	0	0	0	1	0	0	0		POINT (-73.9700779726297 40.7722086251085)
2154	2154	-73.976716425804	40.7736889979965	8A-PM-1014-03	08A	PM	10142018	3	Juvenile	Gray		Gray+		Above Ground	23		0	0	1	1	0		0	0	0	0	0	0	0	0		POINT (-73.976716425804 40.7736889979965)
2223	2223	-73.9784863123685	40.7669225020831	1D-AM-1006-08	01D	AM	10062018	8	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	45		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9784863123685 40.7669225020831)
2254	2254	-73.9709991016317	40.7725756707748	10F-PM-1019-03	10F	PM	10192018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon	Cinnamon head	Ground Plane	FALSE	Behind fence, grass	0	0	0	1	0	eating (nuts)	0	0	0	0	0	1	0	0	approaches (bad tourists w/ nuts)	POINT (-73.9709991016317 40.772575670774806)
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	0	0	watching me from tree - curious	POINT (-73.9556177490335 40.7888569161537)
2334	2334	-73.97549229705109	40.7707686392991	6D-AM-1008-03	06D	AM	10082018	3	Juvenile	Gray		Gray+		Above Ground	10		0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9754922970511 40.7707686392991)
2389	2389	-73.9801343393329	40.769151245340204	3A-AM-1012-01	03A	AM	10122018	1	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Above Ground	1		0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9801343393329 40.7691512453402)
2397	2397	-73.9704592500888	40.772962887933005	10G-AM-1006-03	10G	AM	10062018	3	Juvenile	Gray	White	Gray+White	tuft on butt	Above Ground	10		0	0	1	0	0		0	0	0	1	0	0	0	1		POINT (-73.9704592500888 40.772962887933)
2420	2420	-73.95877875927509	40.7981699014259	40A-AM-1010-01	40A	AM	10102018	1	Juvenile	Gray		Gray+		Above Ground	30	bottom of great hill	0	0	1	0	0		0	0	0	0	0	0	0	0	climbing up a tree	POINT (-73.9587787592751 40.7981699014259)
2636	2636	-73.9700264128414	40.7692014637698	7I-PM-1013-01	07I	PM	10132018	1	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	Bench	0	0	0	1	0		0	0	0	0	0	1	0	0		POINT (-73.9700264128414 40.7692014637698)
2671	2671	-73.97433690682541	40.7675726965985	3F-AM-1006-11	03F	AM	10062018	11	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9743369068254 40.7675726965985)
2723	2723	-73.96064260275601	40.791726541984204	32D-PM-1006-08	32D	PM	10062018	8	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	0	0	stand on two feet and watching me	POINT (-73.960642602756 40.7917265419842)
2742	2742	-73.96280415779341	40.7884180156055	28D-AM-1012-06	28D	AM	10122018	6	Juvenile	Cinnamon	White	Cinnamon+White		Above Ground	5		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9628041577934 40.78841801560551)
2745	2745	-73.97296259363002	40.7652601851275	1I-PM-1012-04	01I	PM	10122018	4	Juvenile	Cinnamon	White	Cinnamon+White	Cinnamon & White selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments.	Above Ground	2	on ledge	0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.97296259363 40.7652601851275)
2754	2754	-73.9687025912431	40.7719319822619	10H-AM-1014-04	10H	AM	10142018	4	Juvenile			+		Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9687025912431 40.7719319822619)
2764	2764	-73.9692660977515	40.7830532310766	21B-PM-1017-01	21B	PM	10172018	1	Juvenile	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0	paused to look at me	POINT (-73.9692660977515 40.7830532310766)
2862	2862	-73.967466716152	40.782434654827796	21D-PM-1008-04	21D	PM	10082018	4	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	4		0	0	0	1	0		0	0	0	0	0	0	0	1	i scared it	POINT (-73.967466716152 40.7824346548278)
2865	2865	-73.98028424040159	40.767825738497706	1B-PM-1019-03	01B	PM	10192018	3	Juvenile	Gray	White	Gray+White		Above Ground	25	in tree	0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.98028424040162 40.7678257384977)
2867	2867	-73.969370141813	40.7840721191988	22A-PM-1017-03	22A	PM	10172018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.969370141813 40.7840721191988)
2869	2869	-73.9630822385425	40.7914844989865	31B-PM-1007-04	31B	PM	10072018	4	Juvenile	Gray		Gray+					0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9630822385425 40.7914844989865)
2927	2927	-73.96501200660741	40.7805932882407	20F-PM-1007-13	20F	PM	10072018	13	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9650120066074 40.78059328824071)
2982	2982	-73.9513477815203	40.7945259614138	39I-PM-1013-02	39I	PM	10132018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE	along the road	0	1	1	0	0	playing	0	0	0	0	0	0	0	0		POINT (-73.9513477815203 40.7945259614138)
3016	3016	-73.9756457597888	40.7703559775625	6D-PM-1020-02	06D	PM	10202018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9756457597888 40.7703559775625)

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