2018_Central_Park_Squirrel_Census_-_Squirrel_Data

441 rows where Hectare Squirrel Number = 3 sorted by Date

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

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
2603	2603	-73.97087815045279	40.7724138070355	10F-AM-1007-03	10F	AM	10072018	3	Adult	Gray		Gray+		Above Ground	50		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9708781504528 40.7724138070355)
2679	2679	-73.9794481602391	40.770638572864	4A-AM-1007-03	04A	AM	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.9794481602391 40.770638572864)
2686	2686	-73.97755714038921	40.766531658519796	1E-PM-1007-03	01E	PM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9775571403892 40.7665316585198)
2695	2695	-73.962800448652	40.7915532640139	31B-PM-1007-03	31B	PM	10072018	3	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.962800448652 40.7915532640139)
2718	2718	-73.9530587825442	40.7919087309222	36I-PM-1007-03	36I	PM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9530587825442 40.7919087309222)
2719	2719	-73.973425927351	40.7781929919344	14B-AM-1007-03	14B	AM	10072018	3	Adult	Gray		Gray+					0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.973425927351 40.7781929919344)
2789	2789	-73.96868007849409	40.77667390291379	15F-AM-1007-03	15F	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9686800784941 40.7766739029138)
2954	2954	-73.9677474313377	40.7742119240825	12H-PM-1007-03	12H	PM	10072018	3		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0	peanuts	0	0	0	0	0	0	1	0		POINT (-73.9677474313377 40.7742119240825)
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)
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)
279	279	-73.9550082056509	40.7894521543449	33I-AM-1008-03	33I	AM	10082018	3	Adult	Gray		Gray+		Above Ground	2	98th @ edge of park	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9550082056509 40.7894521543449)
491	491	-73.9688470831269	40.7844651946415	22A-AM-1008-03	22A	AM	10082018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9688470831269 40.7844651946415)
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)
665	665	-73.95636612568751	40.796682311450795	39D-AM-1008-03	39D	AM	10082018	3	Adult	Gray		Gray+		Above Ground	5		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9563661256875 40.7966823114508)
695	695	-73.96850806398729	40.774530979415495	13G-PM-1008-03	13G	PM	10082018	3	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Above Ground	20	maple tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9685080639873 40.77453097941551)
716	716	-73.9745427984089	40.7691848214817	5E-AM-1008-03	05E	AM	10082018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9745427984089 40.7691848214817)
811	811	-73.9771695272048	40.772427727626294	7B-AM-1008-03	07B	AM	10082018	3	Adult	Gray		Gray+		Above Ground	5		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9771695272048 40.7724277276263)
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)
978	978	-73.9676692772518	40.7764726688908	15G-AM-1008-03	15G	AM	10082018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		1	0	0	0	0	0	0	0		POINT (-73.9676692772518 40.7764726688908)
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)
1028	1028	-73.97070123456609	40.7758938984066	13E-PM-1008-03	13E	PM	10082018	3	Juvenile	Gray	White	Gray+White		Above Ground	10	hanging upside down to get a nut	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9707012345661 40.7758938984066)
1116	1116	-73.9729847109778	40.774070904960205	10D-AM-1008-03	10D	AM	10082018	3	Adult	Gray	White	Gray+White		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9729847109778 40.7740709049602)
1121	1121	-73.9645060433292	40.7768322057794	16I-AM-1008-03	16I	AM	10082018	3	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9645060433292 40.7768322057794)
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)
1569	1569	-73.973047824163	40.7700873791211	7F-AM-1008-03	07F	AM	10082018	3	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.973047824163 40.7700873791211)
1610	1610	-73.9607056611532	40.788978610387105	30E-AM-1008-03	30E	AM	10082018	3	Adult	Gray		Gray+		Above Ground	6		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9607056611532 40.7889786103871)
1664	1664	-73.97291429122029	40.772409114667795	9E-AM-1008-03	09E	AM	10082018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9729142912203 40.7724091146678)
1715	1715	-73.97457091090558	40.7672225695415	3G-AM-1008-03	03G	AM	10082018	3	Adult	Gray		Gray+		Above Ground	40		1	0	1	0	0	in tree	0	0	0	0	0	0	1	0		POINT (-73.9745709109056 40.7672225695415)
1834	1834	-73.97390388321558	40.7730354890554	9D-AM-1008-03	09D	AM	10082018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9739038832156 40.7730354890554)
1863	1863	-73.96828305109541	40.7810151087286	19D-PM-1008-03	19D	PM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	may be same squirrel as #1 - male	Above Ground	5	on branch of dead tree	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9682830510954 40.7810151087286)
1981	1981	-73.972154069981	40.769012800972206	6G-AM-1008-03	06G	AM	10082018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE	grass	0	0	0	1	1		0	0	0	1	0	0	1	0		POINT (-73.972154069981 40.7690128009722)
2006	2006	-73.9695641121727	40.7769562886685	14E-AM-1008-03	14E	AM	10082018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	walking	0	0	0	0	0	0	1	0	unaware of	POINT (-73.9695641121727 40.7769562886685)
2015	2015	-73.9574365550758	40.7886924675052	31H-PM-1008-03	31H	PM	10082018	3	Adult	Gray		Gray+		Above Ground		no clue, way up a tree!	0	0	1	0	1	throwing down acorns	0	0	0	0	0	0	0	0		POINT (-73.9574365550758 40.7886924675052)
2091	2091	-73.96761128642859	40.7772792086081	16F-AM-1008-03	16F	AM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	road	1	0	0	0	0		0	0	0	0	1	0	1	0		POINT (-73.9676112864286 40.7772792086081)
2151	2151	-73.96971787697879	40.77915441024221	17D-AM-1008-03	17D	AM	10082018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.96971787697882 40.7791544102422)
2253	2253	-73.973394428186	40.7722933513053	8E-PM-1008-03	08E	PM	10082018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE	in between 2 trees	0	0	0	1	1		0	0	0	0	0	1	0	0	also being lured by mom & baby w/ food	POINT (-73.973394428186 40.7722933513053)
2268	2268	-73.9590191655172	40.7926139425111	34D-AM-1008-03	34D	AM	10082018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9590191655172 40.7926139425111)
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)
2393	2393	-73.9729190572117	40.770018150904995	6F-PM-1008-03	06F	PM	10082018	3	Adult	Gray		Gray+		Above Ground	50	top of tree	0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9729190572117 40.770018150905)
2452	2452	-73.9727323797981	40.766903546395504	3H-AM-1008-03	03H	AM	10082018	3	Adult	Gray		Gray+		Above Ground	40	building nest	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9727323797981 40.7669035463955)
2485	2485	-73.9584950620879	40.790277071064295	32F-PM-1008-03	32F	PM	10082018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	1	1	1	1		0	0	0	0	0	0	1	0		POINT (-73.9584950620879 40.7902770710643)
2528	2528	-73.96765297807241	40.7823206990549	21D-PM-1008-03	21D	PM	10082018	3	Adult	Gray	White	Gray+White		Above Ground	4		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9676529780724 40.7823206990549)
2563	2563	-73.9664536611195	40.7827694131949	21D-AM-1008-03	21D	AM	10082018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9664536611195 40.7827694131949)
2630	2630	-73.965019827314	40.775986429132296	15I-AM-1008-03	15I	AM	10082018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.965019827314 40.7759864291323)
2871	2871	-73.9777124331985	40.7704051056666	5B-AM-1008-03	05B	AM	10082018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9777124331985 40.7704051056666)
3	3	-73.9768311751004	40.766717807255795	2E-AM-1010-03	02E	AM	10102018	3	Adult	Cinnamon		Cinnamon+		Above Ground	4		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9768311751004 40.76671780725581)
12	12	-73.96836135162249	40.772590884749896	11H-AM-1010-03	11H	AM	10102018	3	Adult	Cinnamon	White	Cinnamon+White					0	0	0	0	1		0	0	0	0	1	0	1	0		POINT (-73.9683613516225 40.7725908847499)
16	16	-73.97225001968441	40.7742879599026	11D-AM-1010-03	11D	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	30		0	0	1	0	0	grooming	0	0	0	0	0	0	1	0		POINT (-73.9722500196844 40.7742879599026)
123	123	-73.9671147090087	40.7772624641112	16G-AM-1010-03	16G	AM	10102018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1	was hanging out w/ #2 until i showed up	1	0	0	0	0	0	0	1		POINT (-73.9671147090087 40.7772624641112)
124	124	-73.9588660250232	40.7982597947515	40A-AM-1010-03	40A	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	bottom of great hill	0	0	0	1	1		0	0	0	1	0	0	1	1	dog chased	POINT (-73.9588660250232 40.7982597947515)
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)
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)
307	307	-73.9683965841952	40.771867984897796	10I-AM-1010-03	10I	AM	10102018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9683965841952 40.7718679848978)
391	391	-73.97908754803579	40.767610478065706	2C-AM-1010-03	02C	AM	10102018	3	Adult	Black	Gray	Black+Gray		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9790875480358 40.7676104780657)
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)
414	414	-73.9721899838568	40.776151904565104	13C-AM-1010-03	13C	AM	10102018	3	Adult	Gray		Gray+		Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9721899838568 40.7761519045651)
483	483	-73.9789952029637	40.7697758333099	4B-AM-1010-03	04B	AM	10102018	3	Juvenile	Gray	White	Gray+White		Above Ground	25		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9789952029637 40.7697758333099)
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)
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)
752	752	-73.9768617690725	40.7741877060705	9A-PM-1010-03	09A	PM	10102018	3		Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	0	0	froze - standing on hind legs for ~10 seconds then scampered off	POINT (-73.97686176907251 40.7741877060705)
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)
893	893	-73.9799311173259	40.768557699755895	2B-AM-1010-03	02B	AM	10102018	3	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9799311173259 40.7685576997559)
1253	1253	-73.9527227282134	40.7935061484064	37I-AM-1010-03	37I	AM	10102018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	4	in tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9527227282134 40.7935061484064)
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)
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)
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)
1627	1627	-73.9594391759139	40.784115697669	26I-PM-1010-03	26I	PM	10102018	3	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	black in tail	Above Ground	15	tree	0	0	1	1	1		0	0	0	0	1	0	1	0		POINT (-73.9594391759139 40.784115697669)
1672	1672	-73.9640989602986	40.789929543926505	29B-PM-1010-03	29B	PM	10102018	3	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9640989602986 40.7899295439265)
1773	1773	-73.9611126813593	40.7943113021522	35B-AM-1010-03	35B	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9611126813593 40.7943113021522)
1824	1824	-73.9617250054003	40.7925390432044	33B-PM-1010-03	33B	PM	10102018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9617250054003 40.7925390432044)
1829	1829	-73.9746965894947	40.766435172430896	2G-AM-1010-03	02G	AM	10102018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9746965894947 40.7664351724309)
1890	1890	-73.97877230828071	40.7713655754004	5A-PM-1010-03	05A	PM	10102018	3	Adult	Gray		Gray+		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9787723082807 40.7713655754004)
1979	1979	-73.96127592913992	40.7930468323219	33B-AM-1010-03	33B	AM	10102018	3	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9612759291399 40.7930468323219)
2076	2076	-73.9712636931964	40.77998098773	17B-AM-1010-03	17B	AM	10102018	3	Adult	Gray		Gray+		Above Ground	25		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9712636931964 40.77998098773)
2127	2127	-73.9562442622553	40.7957285542564	38E-AM-1010-03	38E	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9562442622553 40.7957285542564)
2172	2172	-73.9642900903774	40.791701716884205	31A-AM-1010-03	31A	AM	10102018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9642900903774 40.7917017168842)
2256	2256	-73.9720050204318	40.769941909416794	7G-AM-1010-03	07G	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9720050204318 40.7699419094168)
2259	2259	-73.975565603566	40.7738462518304	9B-AM-1010-03	09B	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4		1	0	1	0	1		0	0	0	0	0	0	1	0		POINT (-73.975565603566 40.7738462518304)
2379	2379	-73.97118651343641	40.7785039981892	15C-AM-1010-03	15C	AM	10102018	3	Adult	Gray		Gray+		Above Ground	6		0	0	0	1	0	sitting	0	0	0	0	0	0	1	0		POINT (-73.9711865134364 40.7785039981892)
2392	2392	-73.9578981223015	40.798996775435796	41B-AM-1010-03	41B	AM	10102018	3	Adult			+		Above Ground	60		0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9578981223015 40.7989967754358)
2471	2471	-73.964274290774	40.779531955602295	19H-AM-1010-03	19H	AM	10102018	3	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	1	1		0	0	0	0	0	0	1	0	ran from human w/ dog	POINT (-73.964274290774 40.7795319556023)
2476	2476	-73.9710843362124	40.7679739601336	5I-AM-1010-03	05I	AM	10102018	3	Adult	Gray		Gray+		Above Ground	3		0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9710843362124 40.7679739601336)
2573	2573	-73.9810149147578	40.7683925377714	2A-AM-1010-03	02A	AM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	1	on trunk	0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9810149147578 40.7683925377714)
2620	2620	-73.97718000981308	40.7708863131336	5C-PM-1010-03	05C	PM	10102018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9771800098131 40.7708863131336)
2631	2631	-73.9690080105286	40.7710230515054	9I-PM-1010-03	09I	PM	10102018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White					0	0	0	0	1		0	0	0	0	0	0	1	1		POINT (-73.9690080105286 40.7710230515054)
2912	2912	-73.9632164738341	40.7921270121312	32B-PM-1010-03	32B	PM	10102018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	15		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9632164738341 40.7921270121312)
2914	2914	-73.9722053355548	40.7662094993614	3I-AM-1010-03	03I	AM	10102018	3	Adult	Gray		Gray+		Above Ground	50		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9722053355548 40.7662094993614)
2946	2946	-73.974515099169	40.770065079988605	6E-PM-1010-03	06E	PM	10102018	3	Adult	Cinnamon	White	Cinnamon+White	white back legs	Ground Plane	FALSE	small open area but w/ 7 large oak trees	0	1	0	1	0	chasing #4	0	0	0	0	0	0	1	0		POINT (-73.974515099169 40.770065079988605)
2957	2957	-73.97473131521521	40.7653888351839	1G-PM-1010-03	01G	PM	10102018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9747313152152 40.7653888351839)
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)
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)
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)
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)
698	698	-73.95855376683821	40.7903905787005	32F-AM-1012-03	32F	AM	10122018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	1	0	0	bringing green leaves to nest	0	0	0	0	0	0	0	0		POINT (-73.9585537668382 40.7903905787005)
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)
963	963	-73.9621066718851	40.7942427079733	34A-AM-1012-03	34A	AM	10122018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9621066718851 40.7942427079733)
1159	1159	-73.9682129261841	40.77542323581179	14G-AM-1012-03	14G	AM	10122018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9682129261841 40.7754232358118)
1249	1249	-73.9590132705889	40.7952248279764	37C-AM-1012-03	37C	AM	10122018	3	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon flanks	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9590132705889 40.7952248279764)
1327	1327	-73.9689939368647	40.7740824773353	12G-AM-1012-03	12G	AM	10122018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.96899393686472 40.7740824773353)
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)

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