2018_Central_Park_Squirrel_Census_-_Squirrel_Data

199 rows where Age = "Adult", Hectare Squirrel Number = 3 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

- 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, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, 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
2	2	-73.9570437717691	40.7948509408039	37E-PM-1006-03	37E	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	me	POINT (-73.9570437717691 40.794850940803904)
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)
65	65	-73.9741824992294	40.7689486657963	5F-PM-1007-03	05F	PM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	hiding nut	0	0	0	0	1	0	1	0		POINT (-73.9741824992294 40.7689486657963)
72	72	-73.9666007935638	40.7845098131567	23C-PM-1014-03	23C	PM	10142018	3	Adult	Gray		Gray+		Above Ground	8		0	1	0	0	0	chasing (#4 across trees)	0	0	0	0	0	0	0	0		POINT (-73.9666007935638 40.7845098131567)
73	73	-73.96148483609001	40.7922645521905	33C-PM-1007-03	33C	PM	10072018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.96148483609 40.7922645521905)
105	105	-73.9589249555235	40.7908193284981	32E-PM-1017-03	32E	PM	10172018	3	Adult	Gray		Gray+		Above Ground	2	bottom of tree	0	0	0	1	0	still	0	0	0	0	0	0	1	0		POINT (-73.9589249555235 40.7908193284981)
138	138	-73.9721442939797	40.770075080231706	7G-PM-1018-03	07G	PM	10182018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9721442939797 40.7700750802317)
140	140	-73.97686527856641	40.768483816820705	3D-PM-1010-03	03D	PM	10102018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.97686527856641 40.7684838168207)
164	164	-73.9758676144255	40.7701671581939	5D-PM-1018-03	05D	PM	10182018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9758676144255 40.7701671581939)
168	168	-73.9745691353018	40.777103558929795	13A-PM-1014-03	13A	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	6		0	0	1	0	0		0	0	0	0	0	0	0	1	child chasing	POINT (-73.9745691353018 40.7771035589298)
179	179	-73.9646901432328	40.775995869679	15I-PM-1012-03	15I	PM	10122018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9646901432328 40.775995869679)
196	196	-73.965796978969	40.7760402842845	15H-PM-1008-03	15H	PM	10082018	3	Adult	Gray		Gray+		Ground Plane	FALSE	lawn moving east over Park path	0	0	0	0	0	not sure walk-pause-walk	0	0	0	0	0	0	1	0		POINT (-73.96579697896901 40.7760402842845)
201	201	-73.9598015842806	40.7973522744237	38A-PM-1013-03	38A	PM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9598015842806 40.7973522744237)
219	219	-73.9761209945419	40.768240452890296	3E-PM-1008-03	03E	PM	10082018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9761209945419 40.7682404528903)
220	220	-73.96718161220299	40.7787752287055	17F-PM-1020-03	17F	PM	10202018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	35		0	0	1	1	0		0	0	0	0	0	0	0	0		POINT (-73.967181612203 40.7787752287055)
224	224	-73.9520592496349	40.797507629981105	42G-PM-1014-03	42G	PM	10142018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	4	on fence	1	0	0	0	0	prancing	0	0	0	0	0	0	0	1		POINT (-73.9520592496349 40.7975076299811)
266	266	-73.97864810094991	40.7697372811949	4B-PM-1018-03	04B	PM	10182018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	1	0	0		POINT (-73.9786481009499 40.7697372811949)
270	270	-73.9767191629692	40.7730786298701	8B-PM-1012-03	08B	PM	10122018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9767191629692 40.7730786298701)
280	280	-73.9587401274261	40.7960322222949	37C-PM-1013-03	37C	PM	10132018	3	Adult	Gray	White	Gray+White					0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9587401274261 40.7960322222949)
297	297	-73.9685604013735	40.7773439909065	15F-PM-1010-03	15F	PM	10102018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9685604013735 40.7773439909065)
310	310	-73.9795081274695	40.7691431548544	3B-PM-1007-03	03B	PM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	0		POINT (-73.9795081274695 40.7691431548544)
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)
331	331	-73.95448101115	40.7954469678857	39F-PM-1006-03	39F	PM	10062018	3	Adult	Gray	White	Gray+White		Above Ground	15	lower branch of tree	0	0	0	1	0		0	0	0	0	0	0	0	1	ran up tree when approached	POINT (-73.95448101115 40.7954469678857)
345	345	-73.9724452296309	40.7715792113505	8F-PM-1012-03	08F	PM	10122018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1	buried an acorn	0	0	0	0	0	0	1	0		POINT (-73.9724452296309 40.7715792113505)
361	361	-73.96148244372509	40.7912929799884	32C-PM-1013-03	32C	PM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9614824437251 40.7912929799884)
394	394	-73.9719888241794	40.7667681685356	4I-PM-1007-03	04I	PM	10072018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	3	ran to tree	0	0	0	0	0	being chased	0	0	0	0	0	0	0	0		POINT (-73.9719888241794 40.7667681685356)
395	395	-73.9565686300382	40.797592846003	40C-PM-1006-03	40C	PM	10062018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9565686300382 40.797592846003)
396	396	-73.9669206605745	40.7748155701122	13H-PM-1010-03	13H	PM	10102018	3	Adult	Gray		Gray+		Ground Plane	FALSE	in glen	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9669206605745 40.7748155701122)
402	402	-73.9681917366128	40.7723298813768	11I-PM-1012-03	11I	PM	10122018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	1	0	1		0	0	0	0	0	0	0	1	runs from the dog	POINT (-73.9681917366128 40.7723298813768)
413	413	-73.96989341826121	40.7708211633861	8H-PM-1014-03	08H	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9698934182612 40.7708211633861)
418	418	-73.9573604880421	40.7930844158021	35E-PM-1006-03	35E	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9573604880421 40.7930844158021)
437	437	-73.9793952066038	40.7707837657859	4A-PM-1007-03	04A	PM	10072018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE	by rock	0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9793952066038 40.77078376578591)
460	460	-73.9549135206961	40.798525897229	42D-PM-1013-03	42D	PM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	25	in tree	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9549135206961 40.798525897229)
461	461	-73.96481954331921	40.7796399955868	19G-PM-1017-03	19G	PM	10172018	3	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	1	1	0	staring	0	0	0	0	1	0	0	0		POINT (-73.9648195433192 40.7796399955868)
517	517	-73.954959868822	40.7985404965582	41D-PM-1014-03	41D	PM	10142018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.954959868822 40.7985404965582)
530	530	-73.9696360756453	40.7786545659072	16D-PM-1010-03	16D	PM	10102018	3	Adult	Gray		Gray+		Above Ground	18		0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9696360756453 40.7786545659072)
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)
548	548	-73.95846960832841	40.7980121226635	39B-PM-1014-03	39B	PM	10142018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9584696083284 40.7980121226635)
551	551	-73.9643825381614	40.7815445841195	21F-PM-1018-03	21F	PM	10182018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9643825381614 40.7815445841195)
554	554	-73.97335194581801	40.768814796037	5G-PM-1010-03	05G	PM	10102018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.973351945818 40.768814796037)
561	561	-73.95819824864691	40.7992194575293	41A-PM-1007-03	41A	PM	10072018	3	Adult	Gray	White	Gray+White		Above Ground	55		1	0	1	0	0		0	0	0	0	1	0	0	0		POINT (-73.95819824864691 40.7992194575293)
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)
575	575	-73.9783366903829	40.7668300056094	1D-PM-1007-03	01D	PM	10072018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9783366903829 40.7668300056094)
580	580	-73.97509925643621	40.7743391883762	10B-PM-1014-03	10B	PM	10142018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0	avoided people	POINT (-73.9750992564362 40.7743391883762)
591	591	-73.95433237868879	40.7943086530436	37G-PM-1007-03	37G	PM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	0	0	1	0	lying on belly on branch,eating big nut	0	0	0	0	0	0	0	0		POINT (-73.9543323786888 40.7943086530436)
614	614	-73.9642411990432	40.7779692777193	18H-PM-1014-03	18H	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	1	0		POINT (-73.9642411990432 40.7779692777193)
628	628	-73.96001657854859	40.795246676183204	36B-PM-1013-03	36B	PM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9600165785486 40.7952466761832)
636	636	-73.97575361873191	40.775511981067794	11A-PM-1013-03	11A	PM	10132018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9757536187319 40.7755119810678)
645	645	-73.9758152322587	40.76923774014671	4E-PM-1008-03	04E	PM	10082018	3	Adult	Gray		Gray+					0	1	0	0	0	chasing #4	0	0	0	0	0	0	0	0		POINT (-73.9758152322587 40.7692377401467)
651	651	-73.9801661903932	40.7697950141751	3A-PM-1017-03	03A	PM	10172018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9801661903932 40.7697950141751)
723	723	-73.9654397484763	40.7798863522904	19F-PM-1017-03	19F	PM	10172018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9654397484763 40.7798863522904)
728	728	-73.96029131055779	40.7910635810038	32D-PM-1006-03	32D	PM	10062018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Above Ground	40		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9602913105578 40.7910635810038)
748	748	-73.9756603846107	40.7672531319384	3F-PM-1013-03	03F	PM	10132018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9756603846107 40.7672531319384)
774	774	-73.9673603655908	40.787697417778205	26A-PM-1006-03	26A	PM	10062018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9673603655908 40.7876974177782)
791	791	-73.9772635911119	40.7709428872533	6B-PM-1017-03	06B	PM	10172018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9772635911119 40.7709428872533)
825	825	-73.9580105174865	40.7974468322692	39C-PM-1006-03	39C	PM	10062018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9580105174865 40.7974468322692)
828	828	-73.9545101041865	40.790382361678205	34I-PM-1010-03	34I	PM	10102018	3	Adult	Gray		Gray+		Ground Plane	FALSE	in the playground.	1	0	0	0	1	with some nuts in the mouth	0	0	0	0	0	0	0	0		POINT (-73.9545101041865 40.7903823616782)
830	830	-73.95956459625391	40.7899599350145	31E-PM-1006-03	31E	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	under bushes	0	0	0	1	1	burying	0	0	0	0	0	0	1	0		POINT (-73.9595645962539 40.7899599350145)
869	869	-73.96294833745279	40.7936809905265	33A-PM-1018-03	33A	PM	10182018	3	Adult	Gray		Gray+		Above Ground	6		1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9629483374528 40.7936809905265)
877	877	-73.9710547484029	40.7723589827074	9F-PM-1014-03	09F	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9710547484029 40.7723589827074)
878	878	-73.9757215415855	40.766820597698604	2F-PM-1014-03	02F	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9757215415855 40.7668205976986)
925	925	-73.9763116425885	40.768883957648704	4D-PM-1008-03	04D	PM	10082018	3	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1	ran two feet up tree trunk	POINT (-73.9763116425885 40.7688839576487)
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)
962	962	-73.97154668503241	40.7695584933538	6H-PM-1020-03	06H	PM	10202018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	1	runs from (kids kicking the fence)	POINT (-73.9715466850324 40.7695584933538)
986	986	-73.978400938697	40.7677411911854	2C-PM-1013-03	02C	PM	10132018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.978400938697 40.7677411911854)
991	991	-73.96356890598409	40.790163434915	30B-PM-1019-03	30B	PM	10192018	3	Adult	Gray	Black	Gray+Black		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9635689059841 40.790163434915)
992	992	-73.97080835874709	40.782542944158294	19A-PM-1013-03	19A	PM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9708083587471 40.7825429441583)
1018	1018	-73.96953055553921	40.7757541971012	13F-PM-1008-03	13F	PM	10082018	3	Adult	Gray		Gray+		Above Ground	15	tree	0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9695305555392 40.7757541971012)
1058	1058	-73.97371007431829	40.7708360121735	7E-PM-1013-03	07E	PM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE	Ground & Tree Base	0	0	0	0	1		0	0	0	1	1	0	1	0		POINT (-73.9737100743183 40.7708360121735)
1137	1137	-73.9520280004414	40.7946345014466	39I-PM-1013-03	39I	PM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0	playing	0	0	0	0	0	1	0	0		POINT (-73.9520280004414 40.7946345014466)
1143	1143	-73.9628349778362	40.793887005205995	34A-PM-1013-03	34A	PM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9628349778362 40.793887005206)
1148	1148	-73.9707339200738	40.7796333355689	17C-PM-1013-03	17C	PM	10132018	3	Adult	Gray		Gray+		Above Ground	20	in a tree	0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9707339200738 40.7796333355689)
1167	1167	-73.9593244415072	40.794964729747	36C-PM-1013-03	36C	PM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE	Clearing near bike path (bikes active)	0	1	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9593244415072 40.794964729747)
1191	1191	-73.9634835346077	40.7918244310746	31A-PM-1017-03	31A	PM	10172018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9634835346077 40.7918244310746)
1200	1200	-73.9657721715305	40.778534830257	18G-PM-1013-03	18G	PM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9657721715305 40.778534830257)
1222	1222	-73.9691420412059	40.777349258213796	15E-PM-1008-03	15E	PM	10082018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	walking	0	0	0	0	0	0	1	0		POINT (-73.9691420412059 40.7773492582138)
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)
1250	1250	-73.9585133340331	40.796372167947396	38C-PM-1014-03	38C	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		1	0	0	0	0	0	0	1		POINT (-73.9585133340331 40.7963721679474)
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)
1268	1268	-73.96239842629359	40.7913900453449	31C-PM-1010-03	31C	PM	10102018	3	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9623984262936 40.7913900453449)
1272	1272	-73.9595717225279	40.7829872498299	25I-PM-1007-03	25I	PM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9595717225279 40.7829872498299)
1289	1289	-73.97246812695259	40.7743474675821	11D-PM-1006-03	11D	PM	10062018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9724681269526 40.7743474675821)
1291	1291	-73.96859351775	40.7735537139641	11H-PM-1013-03	11H	PM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0	planting nut	0	0	0	0	0	0	1	0		POINT (-73.96859351775 40.7735537139641)
1301	1301	-73.95521466657141	40.7892909102377	32I-PM-1007-03	32I	PM	10072018	3	Adult	Gray		Gray+	small adult	Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9552146665714 40.7892909102377)
1326	1326	-73.9747288122551	40.7659918747507	2G-PM-1007-03	02G	PM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9747288122551 40.7659918747507)
1369	1369	-73.97027172608291	40.768951107763	6I-PM-1013-03	06I	PM	10132018	3	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE	Flowers, grass	0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9702717260829 40.768951107763)
1393	1393	-73.96871341377859	40.7812207913391	19C-PM-1018-03	19C	PM	10182018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9687134137786 40.7812207913391)
1443	1443	-73.9728511531484	40.7782654840595	14B-PM-1014-03	14B	PM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9728511531484 40.7782654840595)
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)
1448	1448	-73.9772810073685	40.7693577540392	4C-PM-1010-03	04C	PM	10102018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	1	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9772810073685 40.7693577540392)
1461	1461	-73.95692690934399	40.7965323262487	39D-PM-1012-03	39D	PM	10122018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.956926909344 40.7965323262487)
1465	1465	-73.9720289863666	40.7763749561607	13C-PM-1019-03	13C	PM	10192018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.97202898636661 40.7763749561607)
1473	1473	-73.9584064190878	40.7912992852442	33F-PM-1012-03	33F	PM	10122018	3	Adult	Black	Gray	Black+Gray		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	1	0		POINT (-73.9584064190878 40.7912992852442)
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)
1497	1497	-73.9722261495647	40.7690542072646	6G-PM-1020-03	06G	PM	10202018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9722261495647 40.7690542072646)
1510	1510	-73.9655670884957	40.7763728890554	16H-PM-1014-03	16H	PM	10142018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	1	0	0	followed man across bridge	POINT (-73.9655670884957 40.7763728890554)
1513	1513	-73.96624099976421	40.789104293543204	28A-PM-1007-03	28A	PM	10072018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	1	0	1	1	chasing #2 took #2 food wrapper and is foraging through it	0	0	0	0	0	0	1	0		POINT (-73.9662409997642 40.7891042935432)
1522	1522	-73.95389705545321	40.7955196793479	39G-PM-1013-03	39G	PM	10132018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9538970554532 40.7955196793479)
1537	1537	-73.97672201797249	40.77532621031229	10A-PM-1014-03	10A	PM	10142018	3	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Above Ground		above my head in tree	0	0	0	1	0	eating (in a tree)	0	0	0	0	0	0	1	0	indifferent (lots of people taking its picture,didn't bother it)	POINT (-73.9767220179725 40.7753262103123)
1542	1542	-73.960876728048	40.790357245370004	31D-PM-1006-03	31D	PM	10062018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.960876728048 40.79035724537)

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