2018_Central_Park_Squirrel_Census_-_Squirrel_Data

126 rows where Approaches = 0, Indifferent = 1, Running = 1 and Shift = "PM"

- 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: 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, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Runs from

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
7	7	-73.9719735582476	40.769304513357795	6G-PM-1020-02	06G	PM	10202018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9719735582476 40.7693045133578)
21	21	-73.9703781726172	40.778752613032104	16C-PM-1018-03	16C	PM	10182018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	6		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9703781726172 40.7787526130321)
28	28	-73.958736593111	40.790852437062604	32F-PM-1008-07	32F	PM	10082018	7	Adult	Gray		Gray+		Ground Plane	FALSE		1	1	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.958736593111 40.7908524370626)
43	43	-73.9574648097543	40.7892508428622	31H-PM-1008-02	31H	PM	10082018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	8		1	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9574648097543 40.78925084286221)
47	47	-73.9640032826529	40.782030982544796	22F-PM-1014-06	22F	PM	10142018	6	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9640032826529 40.7820309825448)
55	55	-73.9568802149818	40.7972399133816	39C-PM-1006-01	39C	PM	10062018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9568802149818 40.7972399133816)
81	81	-73.9578237168359	40.7980959471034	40B-PM-1014-06	40B	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9578237168359 40.7980959471034)
82	82	-73.96882712024009	40.7809719445309	19C-PM-1018-01	19C	PM	10182018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9688271202401 40.7809719445309)
142	142	-73.9724063986771	40.7705711897977	7F-PM-1012-01	07F	PM	10122018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9724063986771 40.7705711897977)
256	256	-73.976798124308	40.774131657411296	9A-PM-1010-04	09A	PM	10102018	4		Cinnamon		Cinnamon+		Above Ground	20		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.97679812430802 40.7741316574113)
262	262	-73.97128762341721	40.7695885530701	7H-PM-1006-02	07H	PM	10062018	2	Adult	Gray		Gray+		Above Ground	25	tree	1	0	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.9712876234172 40.7695885530701)
329	329	-73.967832992543	40.778366991340796	17E-PM-1018-03	17E	PM	10182018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.967832992543 40.7783669913408)
336	336	-73.97574132156208	40.7692582758978	4E-PM-1008-04	04E	PM	10082018	4	Adult	Gray		Gray+		Above Ground	10		1	1	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9757413215621 40.7692582758978)
375	375	-73.9752000129992	40.773291812223896	8C-PM-1013-04	08C	PM	10132018	4	Juvenile	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9752000129992 40.7732918122239)
404	404	-73.9680774548516	40.7762491903691	14F-PM-1012-01	14F	PM	10122018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9680774548516 40.7762491903691)
408	408	-73.9633760173635	40.7818422357619	22G-PM-1018-03	22G	PM	10182018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	chilling	0	0	0	0	0	0	1	0	observed	POINT (-73.96337601736352 40.7818422357619)
426	426	-73.9741944367138	40.7769889953596	13B-PM-1008-01	13B	PM	10082018	1	Adult	Gray	White	Gray+White		Above Ground	2	on railing	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9741944367138 40.7769889953596)
429	429	-73.96947840566179	40.7787735291442	16D-PM-1010-01	16D	PM	10102018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9694784056618 40.7787735291442)
438	438	-73.95257475169142	40.7977257435263	42F-PM-1017-02	42F	PM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0	playing	0	0	0	0	0	0	1	0		POINT (-73.95257475169142 40.7977257435263)
462	462	-73.96617859405309	40.7742569936186	13I-PM-1008-01	13I	PM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5	climbed tree	1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9661785940531 40.7742569936186)
469	469	-73.9717201378775	40.776120280884	13D-PM-1018-02	13D	PM	10182018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9717201378775 40.776120280884)
499	499	-73.96572880550109	40.776458003628704	16H-PM-1014-04	16H	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9657288055011 40.7764580036287)
542	542	-73.9713487591577	40.7784353043714	15C-PM-1017-03	15C	PM	10172018	3	Adult	Black		Black+		Above Ground	17	running across overpass	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9713487591577 40.7784353043714)
556	556	-73.9721670042434	40.776085913838	13D-PM-1018-09	13D	PM	10182018	9	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9721670042434 40.776085913838)
562	562	-73.972467515471	40.7659131865172	3I-PM-1013-05	03I	PM	10132018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.972467515471 40.7659131865172)
569	569	-73.9709040623777	40.7701163892686	7H-PM-1006-03	07H	PM	10062018	3	Adult	Gray		Gray+		Above Ground	8	tree	1	0	1	0	0		0	0	0	1	0	0	1	0		POINT (-73.9709040623777 40.7701163892686)
619	619	-73.9769887473852	40.7707561532949	5C-PM-1010-04	05C	PM	10102018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.97698874738522 40.7707561532949)
620	620	-73.9655905300923	40.775261463802295	14I-PM-1018-06	14I	PM	10182018	6	Adult	Cinnamon	Black	Cinnamon+Black		Above Ground	2		1	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9655905300923 40.7752614638023)
684	684	-73.9691057326088	40.7765973509721	14F-PM-1012-07	14F	PM	10122018	7	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		1	1	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9691057326088 40.7765973509721)
706	706	-73.95701325709341	40.793201415908705	35F-PM-1012-01	35F	PM	10122018	1	Juvenile	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	1	0	0	1	1		POINT (-73.9570132570934 40.7932014159087)
711	711	-73.97679809251241	40.774362775678	9A-PM-1010-02	09A	PM	10102018	2	Adult			+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9767980925124 40.774362775678)
749	749	-73.96863045815259	40.7773631337117	15E-PM-1008-01	15E	PM	10082018	1	Adult	Gray		Gray+		Above Ground	4	on fallen tree	1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9686304581526 40.7773631337117)
787	787	-73.97251575343559	40.765837672923396	2I-PM-1006-02	02I	PM	10062018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9725157534356 40.7658376729234)
805	805	-73.97068515461841	40.7780777016038	15D-PM-1017-04	15D	PM	10172018	4	Adult	Cinnamon		Cinnamon+		Above Ground	2	on fence	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9706851546184 40.7780777016038)
884	884	-73.96789372898371	40.7782808361645	16E-PM-1018-01	16E	PM	10182018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9678937289837 40.7782808361645)
885	885	-73.97504638449841	40.7666871742836	2F-PM-1014-08	02F	PM	10142018	8	Adult	Gray	Black	Gray+Black		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9750463844984 40.7666871742836)
922	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	0	0	0	1	0	1	0		POINT (-73.9708002461415 40.7726685284831)
936	936	-73.9684758245091	40.7858531619022	24A-PM-1007-02	24A	PM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9684758245091 40.7858531619022)
937	937	-73.97063234587691	40.7713196034265	9G-PM-1007-03	09G	PM	10072018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9706323458769 40.771319603426505)
953	953	-73.9547959269955	40.7925162926273	36H-PM-1008-01	36H	PM	10082018	1	Adult	Gray	White	Gray+White	white belly	Above Ground	20		1	0	1	0	1		1	1	0	0	0	0	1	0		POINT (-73.9547959269955 40.7925162926273)
957	957	-73.9586527721822	40.790883111056104	32F-PM-1008-08	32F	PM	10082018	8	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9586527721822 40.7908831110561)
999	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	0	0	0	0	1	0		POINT (-73.980948293606 40.7685688850628)
1049	1049	-73.9564606426367	40.788054657260794	30I-PM-1006-06	30I	PM	10062018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	1	ran up tree	POINT (-73.9564606426367 40.7880546572608)
1064	1064	-73.9540257319561	40.798408619116	42E-PM-1012-02	42E	PM	10122018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon					1	0	1	0	0		0	0	0	0	0	0	1	1		POINT (-73.9540257319561 40.798408619116)
1074	1074	-73.9724657562746	40.7658015504376	3I-PM-1013-06	03I	PM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9724657562746 40.7658015504376)
1084	1084	-73.96988397502491	40.778143307669204	16D-PM-1010-08	16D	PM	10102018	8	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		1	0	0	0	0	0	1	0		POINT (-73.9698839750249 40.7781433076692)
1108	1108	-73.96383977903841	40.782895027290394	23F-PM-1013-02	23F	PM	10132018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	1	1		0	1	0	0	1	0	1	0	indifferent (mostly,did notice me,busy eating,foraging)	POINT (-73.9638397790384 40.7828950272904)
1123	1123	-73.9670858934045	40.7753505024976	14H-PM-1012-02	14H	PM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	20		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9670858934045 40.7753505024976)
1139	1139	-73.9716271494641	40.7796462634184	16B-PM-1017-02	16B	PM	10172018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9716271494641 40.7796462634184)
1142	1142	-73.9765805609072	40.7692807820935	4D-PM-1008-07	04D	PM	10082018	7	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE	hopped over fence and chased # 6 around tree & ran it to end of lawn	1	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9765805609072 40.7692807820935)
1150	1150	-73.97447264347429	40.776729630785	12A-PM-1013-03	12A	PM	10132018	3		Gray	Cinnamon	Gray+Cinnamon		Above Ground	3		1	0	0	0	0	chased up a tree by #4	0	0	0	0	0	0	1	0		POINT (-73.9744726434743 40.776729630785)
1182	1182	-73.9667206046912	40.777999356509795	17G-PM-1017-04	17G	PM	10172018	4	Adult	Gray	White	Gray+White		Above Ground	10	tree & ground	1	1	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9667206046912 40.7779993565098)
1199	1199	-73.9756993198381	40.768195664191296	3E-PM-1008-08	03E	PM	10082018	8	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9756993198381 40.7681956641913)
1242	1242	-73.9714512125212	40.77602752501139	13D-PM-1018-03	13D	PM	10182018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9714512125212 40.7760275250114)
1255	1255	-73.9717469822209	40.7753731930704	12D-PM-1014-03	12D	PM	10142018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9717469822209 40.7753731930704)
1284	1284	-73.95708916967759	40.793544880224104	36E-PM-1012-01	36E	PM	10122018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9570891696776 40.7935448802241)
1338	1338	-73.9716624574422	40.776203711010105	13D-PM-1018-07	13D	PM	10182018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		1	0	1	0	0	scratching	0	0	0	0	0	0	1	0		POINT (-73.9716624574422 40.7762037110101)
1370	1370	-73.9681627331154	40.7785099665602	17E-PM-1018-02	17E	PM	10182018	2	Adult	Gray		Gray+		Ground Plane	FALSE	On the rock	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9681627331154 40.7785099665602)
1403	1403	-73.9761632586697	40.7741085606149	9B-PM-1013-05	09B	PM	10132018	5	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9761632586697 40.7741085606149)
1427	1427	-73.9755321998542	40.766831157600706	2F-PM-1014-01	02F	PM	10142018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.97553219985421 40.7668311576007)
1447	1447	-73.9601968065017	40.7935831836482	34C-PM-1012-03	34C	PM	10122018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9601968065017 40.79358318364821)
1456	1456	-73.97142424264959	40.774453579812295	11E-PM-1012-05	11E	PM	10122018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	1	1	foraging (foraged,ran to tree root,munched)	0	0	0	0	0	0	1	0		POINT (-73.9714242426496 40.7744535798123)
1458	1458	-73.9545037193355	40.7900225055417	33I-PM-1006-04	33I	PM	10062018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9545037193355 40.7900225055417)
1481	1481	-73.95388671863759	40.794140943400706	38G-PM-1020-03	38G	PM	10202018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9538867186376 40.7941409434007)
1530	1530	-73.96893059787509	40.781815249626604	19C-PM-1018-06	19C	PM	10182018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	2	Climbed fence	1	0	1	0	0	climbing (fence)	0	0	0	0	0	0	1	0		POINT (-73.9689305978751 40.7818152496266)
1570	1570	-73.96628648847891	40.7891062338302	28A-PM-1007-02	28A	PM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0	running from #3	0	0	0	0	0	0	1	0		POINT (-73.9662864884789 40.7891062338302)
1590	1590	-73.9610388059192	40.793952935840004	34B-PM-1007-01	34B	PM	10072018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9610388059192 40.79395293584)
1604	1604	-73.9734644470766	40.7782766486921	14A-PM-1014-05	14A	PM	10142018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.97346444707661 40.7782766486921)
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	0	0	0	1	0		POINT (-73.9759258407288 40.7667622711142)
1689	1689	-73.9547031549299	40.797886753932204	41E-PM-1013-01	41E	PM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9547031549299 40.7978867539322)
1690	1690	-73.96052295327	40.7934359372871	34C-PM-1012-04	34C	PM	10122018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.96052295327 40.7934359372871)
1749	1749	-73.97568253382991	40.7755542506699	11A-PM-1013-02	11A	PM	10132018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9756825338299 40.7755542506699)
1750	1750	-73.9684806250183	40.7858776210151	24A-PM-1007-03	24A	PM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9684806250183 40.7858776210151)
1772	1772	-73.9690540696008	40.7766014124609	14F-PM-1012-08	14F	PM	10122018	8	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		1	1	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9690540696008 40.7766014124609)
1781	1781	-73.96005650463	40.793404850298295	34C-PM-1012-02	34C	PM	10122018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.96005650463 40.7934048502983)
1894	1894	-73.96997808572979	40.7688706046944	6I-PM-1013-01	06I	PM	10132018	1	Adult	Gray	Black	Gray+Black		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9699780857298 40.7688706046944)
1909	1909	-73.9772070122251	40.7694343352509	4C-PM-1010-02	04C	PM	10102018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.97720701222511 40.7694343352509)
1910	1910	-73.9699876501742	40.774248267675794	12F-PM-1007-06	12F	PM	10072018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	1	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9699876501742 40.77424826767581)
1954	1954	-73.9794840520702	40.7709595369804	4A-PM-1007-02	04A	PM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9794840520702 40.770959536980406)
1959	1959	-73.97077370737709	40.780037346583796	17B-PM-1012-02	17B	PM	10122018	2	Adult	Black		Black+		Ground Plane	FALSE		1	1	0	0	1	2/3 chasing each other	1	1	0	1	1	0	1	0		POINT (-73.9707737073771 40.7800373465838)
1961	1961	-73.953664715831	40.7981256393159	41E-PM-1013-04	41E	PM	10132018	4	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.953664715831 40.7981256393159)
1975	1975	-73.9753291616796	40.7687376032936	4E-PM-1008-01	04E	PM	10082018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9753291616796 40.7687376032936)
1984	1984	-73.9739249209875	40.7768528386853	13B-PM-1008-02	13B	PM	10082018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9739249209875 40.7768528386853)
1985	1985	-73.9530791622513	40.79598856039671	40G-PM-1013-03	40G	PM	10132018	3	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9530791622513 40.7959885603967)
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	0	0	0	1	0		POINT (-73.9590157104896 40.7956884493421)
2071	2071	-73.96676944398949	40.7779501809095	17G-PM-1017-03	17G	PM	10172018	3	Adult	Gray	White	Gray+White		Above Ground	10	tree & ground	1	1	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9667694439895 40.7779501809095)
2111	2111	-73.968446056806	40.785824818871	24A-PM-1007-01	24A	PM	10072018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.96844605680602 40.785824818871)
2112	2112	-73.9655206571055	40.7764851568746	16H-PM-1014-02	16H	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9655206571055 40.7764851568746)
2118	2118	-73.958369699409	40.79024566683321	32F-PM-1008-01	32F	PM	10082018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	1	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.958369699409 40.7902456668332)
2155	2155	-73.9538938706987	40.7981150065974	42E-PM-1012-05	42E	PM	10122018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9538938706987 40.7981150065974)
2157	2157	-73.9657171357842	40.7773277532224	16H-PM-1014-05	16H	PM	10142018	5	Adult	Gray	White	Gray+White		Above Ground	5	tree	1	0	1	0	1		0	0	0	0	1	0	1	0		POINT (-73.9657171357842 40.7773277532224)
2160	2160	-73.975028559002	40.7667307335544	2F-PM-1014-09	02F	PM	10142018	9	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.975028559002 40.7667307335544)
2204	2204	-73.9532427699097	40.7962643767092	40G-PM-1013-04	40G	PM	10132018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9532427699097 40.7962643767092)
2210	2210	-73.9699124811406	40.7743016981538	12F-PM-1007-07	12F	PM	10072018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	1	1	0	1		0	0	0	1	0	0	1	0		POINT (-73.9699124811406 40.7743016981538)
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	0	2/3 chasing each other	0	0	0	0	1	0	1	0		POINT (-73.9707487237344 40.7800822831001)
2294	2294	-73.96308205774409	40.7821632293136	22G-PM-1018-01	22G	PM	10182018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		1	0	0	1	0		0	0	0	1	0	0	1	0		POINT (-73.9630820577441 40.7821632293136)
2324	2324	-73.9737247632185	40.7759469280872	12C-PM-1017-01	12C	PM	10172018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0	digging/burying,drinking from lake	0	0	0	0	1	0	1	0		POINT (-73.9737247632185 40.7759469280872)
2410	2410	-73.97551920769341	40.7664413570796	2F-PM-1014-06	02F	PM	10142018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9755192076934 40.7664413570796)
2412	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	0	0	0	0	1	0		POINT (-73.9809446489564 40.7685032165879)
2436	2436	-73.95827701417	40.785661023889105	28I-PM-1007-01	28I	PM	10072018	1	Adult	Gray		Gray+		Above Ground	20		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.95827701417 40.7856610238891)

Next page

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