2018_Central_Park_Squirrel_Census_-_Squirrel_Data

145 rows where Foraging = 0, Indifferent = 0, Running = 1 and Runs from = 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, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches

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
19	19	-73.9768603630674	40.7702795904962	5C-PM-1010-09	05C	PM	10102018	9	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9768603630674 40.7702795904962)
31	31	-73.9540054100539	40.795244599983604	39G-PM-1013-06	39G	PM	10132018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9540054100539 40.7952445999836)
51	51	-73.9801666435401	40.7686905339212	2B-PM-1013-01	02B	PM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0	running (with nut)	0	0	0	0	0	0	0	0		POINT (-73.9801666435401 40.7686905339212)
53	53	-73.95849706432129	40.7982886348696	40B-AM-1019-03	40B	AM	10192018	3	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	1	1	0	0		POINT (-73.9584970643213 40.7982886348696)
63	63	-73.9745630038492	40.7692602628745	5E-AM-1008-06	05E	AM	10082018	6	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	1	0	0		POINT (-73.9745630038492 40.7692602628745)
113	113	-73.9700100617602	40.7815739959357	19B-PM-1018-01	19B	PM	10182018	1	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Above Ground	20		1	0	0	0	0	flying	0	0	0	0	0	0	0	0		POINT (-73.9700100617602 40.7815739959357)
118	118	-73.9566346046453	40.7973923396512	40D-PM-1013-01	40D	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9566346046453 40.7973923396512)
172	172	-73.958535640774	40.7982737896998	40B-AM-1019-02	40B	AM	10192018	2	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.958535640774 40.7982737896998)
222	222	-73.97702735535249	40.7732399463626	8A-AM-1013-03	08A	AM	10132018	3	Juvenile			+		Above Ground	3	fence	1	1	1	1	0	playing tag together	0	0	0	0	0	1	0	0		POINT (-73.9770273553525 40.7732399463626)
257	257	-73.9773317054464	40.7684035996758	3D-AM-1006-03	03D	AM	10062018	3	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	on top [of] a big rock/boulder in the area	1	0	1	0	0	climbing (rock)	0	0	0	0	0	1	0	0	approaches (slightly),wary of humans	POINT (-73.9773317054464 40.76840359967581)
264	264	-73.9698714743386	40.7743814661685	12F-AM-1020-02	12F	AM	10202018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9698714743386 40.7743814661685)
369	369	-73.9596398997228	40.793338695384705	34D-PM-1007-02	34D	PM	10072018	2	Adult	Black		Black+		Above Ground	25		1	0	1	0	0		0	0	0	0	0	0	0	0	cautiously aware	POINT (-73.9596398997228 40.7933386953847)
371	371	-73.964080104186	40.79078986272871	30B-AM-1007-02	30B	AM	10072018	2	Adult	Gray		Gray+		Above Ground	15		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.964080104186 40.7907898627287)
373	373	-73.96721272832829	40.7810666805133	20D-AM-1007-01	20D	AM	10072018	1	Adult	Gray		Gray+	too far to note 30'	Ground Plane	FALSE		1	0	1	1	0	a lot of activity	0	0	0	1	0	0	0	0		POINT (-73.9672127283283 40.7810666805133)
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)
411	411	-73.9669366401071	40.783602389798205	22C-PM-1006-09	22C	PM	10062018	9	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	1	0	0	0	0	0	0		POINT (-73.96693664010711 40.7836023897982)
419	419	-73.9777328709928	40.7669087724668	1D-AM-1006-02	01D	AM	10062018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9777328709928 40.7669087724668)
420	420	-73.96718516112429	40.7750878657618	14H-PM-1012-01	14H	PM	10122018	1	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	1	0	0	approaches (came very close to me)	POINT (-73.9671851611243 40.7750878657618)
447	447	-73.97259060164741	40.7713889729739	8F-PM-1012-05	08F	PM	10122018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9725906016474 40.7713889729739)
465	465	-73.9683041099256	40.786265230008205	24A-AM-1014-01	24A	AM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0	freezes	POINT (-73.9683041099256 40.7862652300082)
477	477	-73.97014812002979	40.7751110354034	12F-AM-1020-06	12F	AM	10202018	6	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9701481200298 40.7751110354034)
479	479	-73.95694033658471	40.795659960879796	38D-PM-1006-01	38D	PM	10062018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0	didn't see me or others	POINT (-73.9569403365847 40.7956599608798)
480	480	-73.9641293283734	40.7907654006019	30B-AM-1007-03	30B	AM	10072018	3	Adult	Gray		Gray+		Above Ground	30		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9641293283734 40.7907654006019)
494	494	-73.958837574505	40.7985003987784	40A-PM-1014-06	40A	PM	10142018	6	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.958837574505 40.7985003987784)
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)
520	520	-73.97494466297059	40.77206596960671	7D-PM-1010-01	07D	PM	10102018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE	outside fenced hectare	1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9749446629706 40.7720659696067)
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)
674	674	-73.9779811967788	40.7675178797546	2D-AM-1007-01	02D	AM	10072018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9779811967788 40.7675178797546)
678	678	-73.977447585355	40.769716782800295	4C-PM-1010-11	04C	PM	10102018	11	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.977447585355 40.7697167828003)
682	682	-73.9651828383592	40.780282094386294	19F-PM-1017-06	19F	PM	10172018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	1	1	0	0		0	0	0	0	1	1	0	0		POINT (-73.9651828383592 40.7802820943863)
709	709	-73.9519387881692	40.7936273636929	38I-PM-1014-04	38I	PM	10142018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9519387881692 40.7936273636929)
712	712	-73.9736169886655	40.7714942196257	7E-AM-1006-06	07E	AM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	1	0	0		POINT (-73.9736169886655 40.7714942196257)
751	751	-73.9683479943823	40.7815827298303	20C-PM-1018-01	20C	PM	10182018	1	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9683479943823 40.7815827298303)
771	771	-73.9648626810032	40.7804506112843	20G-AM-1018-02	20G	AM	10182018	2	Adult	Gray		Gray+		Above Ground	5	Ran up tree	1	0	1	0	0		1	0	0	0	0	0	0	0		POINT (-73.9648626810032 40.7804506112843)
772	772	-73.95841884610591	40.7913241048498	33E-PM-1012-07	33E	PM	10122018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9584188461059 40.7913241048498)
797	797	-73.969345754447	40.7770429650288	15E-AM-1013-02	15E	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		1	0	1	0	0		0	0	0	0	0	1	0	0		POINT (-73.969345754447 40.7770429650288)
819	819	-73.9603620122205	40.7955965755851	36B-AM-1013-02	36B	AM	10132018	2		Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0	didn't see me	POINT (-73.9603620122205 40.7955965755851)
883	883	-73.95655337834991	40.7974368491287	40D-PM-1013-02	40D	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9565533783499 40.7974368491287)
907	907	-73.95806099213101	40.7907158878729	32F-AM-1012-06	32F	AM	10122018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.958060992131 40.7907158878729)
946	946	-73.96540938440491	40.7806896368469	20F-PM-1007-09	20F	PM	10072018	9	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	1	0	0		POINT (-73.9654093844049 40.7806896368469)
947	947	-73.9736543790582	40.7651444188432	1H-AM-1012-02	01H	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9736543790582 40.7651444188432)
950	950	-73.9637415893182	40.7898140363534	29B-AM-1007-01	29B	AM	10072018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9637415893182 40.7898140363534)
960	960	-73.9623922773932	40.7814944428327	22H-PM-1007-04	22H	PM	10072018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9623922773932 40.7814944428327)
983	983	-73.9641552070803	40.7908479527923	30B-AM-1007-05	30B	AM	10072018	5	Adult	Gray		Gray+		Above Ground	10		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9641552070803 40.7908479527923)
1002	1002	-73.9672070423666	40.783337354891	22C-PM-1006-02	22C	PM	10062018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	1	0	0	0	0	0	0		POINT (-73.9672070423666 40.783337354891)
1004	1004	-73.9670850805619	40.7833747810387	22C-PM-1006-01	22C	PM	10062018	1	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	1	0	0	0	for food	0	1	0	0	0	0	0	0		POINT (-73.9670850805619 40.7833747810387)
1006	1006	-73.96862962178929	40.771812308875	10H-AM-1014-02	10H	AM	10142018	2	Juvenile	Cinnamon		Cinnamon+		Above Ground	6		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9686296217893 40.771812308875)
1046	1046	-73.9647891228606	40.789853066039	29B-AM-1007-02	29B	AM	10072018	2	Adult	Gray		Gray+		Above Ground	30		1	0	0	0	0		0	0	0	1	0	0	0	0		POINT (-73.9647891228606 40.789853066039)
1047	1047	-73.9580111056675	40.785433940148295	27I-PM-1020-02	27I	PM	10202018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9580111056675 40.7854339401483)
1082	1082	-73.96174906802979	40.792153784924395	32C-PM-1013-06	32C	PM	10132018	6	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9617490680298 40.7921537849244)
1165	1165	-73.9689504114652	40.77667701537639	14F-PM-1012-05	14F	PM	10122018	5	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Above Ground	2	on a fallen branch	1	0	0	1	0	sitting	0	0	0	0	0	0	0	0	looking at me	POINT (-73.9689504114652 40.7766770153764)
1202	1202	-73.9694979297007	40.769466740872105	7I-PM-1013-02	07I	PM	10132018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE	Construction materials	1	0	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9694979297007 40.7694667408721)
1204	1204	-73.97629653413091	40.775112516678	10A-AM-1006-02	10A	AM	10062018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE	Bridle Path lawn	1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9762965341309 40.775112516678)
1259	1259	-73.976864402584	40.7705663751959	5C-PM-1010-05	05C	PM	10102018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.976864402584 40.7705663751959)
1260	1260	-73.9811585807616	40.768706748732	2A-AM-1010-06	02A	AM	10102018	6	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	1	0	0	0	chasing #5	0	0	0	0	0	0	0	0		POINT (-73.9811585807616 40.768706748732)
1264	1264	-73.97853537753821	40.7674923683184	2C-PM-1013-01	02C	PM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9785353775382 40.7674923683184)
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)
1329	1329	-73.9772164524209	40.768839953875606	3D-AM-1006-06	03D	AM	10062018	6		Gray		Gray+		Above Ground	10	tree	1	0	1	0	0		0	0	0	0	0	0	0	0	did not run from humans,but ran straight to tree & climbed up	POINT (-73.9772164524209 40.7688399538756)
1373	1373	-73.956737220098	40.797580989254996	40C-PM-1006-01	40C	PM	10062018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.95673722009802 40.797580989255)
1408	1408	-73.973230162241	40.768982453144396	5F-AM-1007-01	05F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	5	fence	1	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.973230162241 40.7689824531444)
1420	1420	-73.9647605121306	40.780396153151706	20G-AM-1018-03	20G	AM	10182018	3	Adult	Gray		Gray+		Above Ground	12	in tree	1	0	0	0	0		1	0	0	0	0	0	0	0		POINT (-73.9647605121306 40.7803961531517)
1441	1441	-73.961335649743	40.7818876867842	23H-PM-1019-01	23H	PM	10192018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.961335649743 40.7818876867842)
1446	1446	-73.9775238847836	40.7675792683587	2D-AM-1007-05	02D	AM	10072018	5	Adult	Gray		Gray+		Above Ground	100		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9775238847836 40.7675792683587)
1451	1451	-73.9645365195454	40.778153102126296	18H-AM-1018-02	18H	AM	10182018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground		Tree	1	1	0	0	0	playing?	0	0	0	0	0	0	0	0		POINT (-73.9645365195454 40.7781531021263)
1464	1464	-73.95320745731391	40.793466946490796	37H-PM-1006-06	37H	PM	10062018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	40	tree	1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9532074573139 40.7934669464908)
1496	1496	-73.9615500510038	40.7920799263699	32C-PM-1013-05	32C	PM	10132018	5	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9615500510038 40.7920799263699)
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)
1515	1515	-73.9530326577312	40.7956922386395	39G-PM-1013-02	39G	PM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9530326577312 40.795692238639504)
1539	1539	-73.9681874036914	40.7817948690964	20C-PM-1018-02	20C	PM	10182018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9681874036914 40.7817948690964)
1551	1551	-73.9785114291288	40.771977958944895	6A-PM-1012-03	06A	PM	10122018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	1	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9785114291288 40.7719779589449)
1555	1555	-73.9784942525972	40.767260000368296	1D-AM-1006-06	01D	AM	10062018	6	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		1	0	0	0	0	tumbling	0	0	0	0	0	0	0	0		POINT (-73.9784942525972 40.7672600003683)
1562	1562	-73.97408468107099	40.7728197139621	8D-AM-1007-06	08D	AM	10072018	6	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.974084681071 40.7728197139621)
1587	1587	-73.9805517765469	40.7683044693163	2B-PM-1013-05	02B	PM	10132018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	1	0	0	climbing fence!	0	0	0	0	0	0	0	0	snuck into bike cart!	POINT (-73.9805517765469 40.7683044693163)
1599	1599	-73.9782603348665	40.7705790257951	5B-PM-1013-06	05B	PM	10132018	6	Adult	Gray		Gray+		Above Ground	5		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9782603348665 40.7705790257951)
1636	1636	-73.97014086231209	40.7695511718541	7I-PM-1013-04	07I	PM	10132018	4	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE	Grass	1	0	0	1	0		0	0	0	1	0	0	0	0		POINT (-73.9701408623121 40.7695511718541)
1646	1646	-73.9669782832746	40.7841166727168	22C-PM-1006-13	22C	PM	10062018	13	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9669782832746 40.7841166727168)
1684	1684	-73.96378247566071	40.7904737110761	30B-AM-1007-08	30B	AM	10072018	8	Adult	Gray		Gray+		Above Ground	40		1	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9637824756607 40.7904737110761)
1731	1731	-73.9692846326638	40.7841049008492	22A-PM-1017-02	22A	PM	10172018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9692846326638 40.7841049008492)
1740	1740	-73.95777581255179	40.799384716477	41B-AM-1010-10	41B	AM	10102018	10	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9577758125518 40.799384716477)
1741	1741	-73.9736995552241	40.77227125186371	8E-PM-1008-02	08E	PM	10082018	2	Adult	Black	Cinnamon	Black+Cinnamon		Above Ground	10	in tree	1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9736995552241 40.7722712518637)
1792	1792	-73.97057045274809	40.7762853012151	13E-AM-1017-06	13E	AM	10172018	6	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9705704527481 40.7762853012151)
1822	1822	-73.9775099290913	40.76976090631371	4C-PM-1010-14	04C	PM	10102018	14	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	1	0	0	0	chasing #15	0	0	0	0	0	0	0	0		POINT (-73.9775099290913 40.7697609063137)
1823	1823	-73.9612854506075	40.792083067357105	32C-PM-1013-04	32C	PM	10132018	4	Juvenile	Gray		Gray+		Above Ground			1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9612854506075 40.7920830673571)
1844	1844	-73.9682062012675	40.786498436192005	24A-AM-1014-02	24A	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Blonde? in Highlights	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9682062012675 40.786498436192)
1867	1867	-73.9745204169071	40.7736282868469	9C-AM-1006-01	09C	AM	10062018	1	Adult	Gray		Gray+		Above Ground	40	Tree	1	0	0	0	0		0	0	0	0	1	0	0	0		POINT (-73.9745204169071 40.7736282868469)
1882	1882	-73.9541601469123	40.7907832744689	34I-PM-1010-04	34I	PM	10102018	4	Adult	Gray		Gray+		Ground Plane	FALSE	across the lawn and climb up a small tree	1	0	1	0	0	grooming	0	0	0	0	0	0	0	0		POINT (-73.9541601469123 40.79078327446891)
1888	1888	-73.9673919075839	40.7786845769177	17F-PM-1020-05	17F	PM	10202018	5	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9673919075839 40.7786845769177)
1889	1889	-73.9679319758284	40.782115480239895	20C-PM-1018-07	20C	PM	10182018	7	Juvenile	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9679319758284 40.7821154802399)
1915	1915	-73.9797112925048	40.76880467784721	2B-PM-1013-09	02B	PM	10132018	9	Adult	Gray	White	Gray+White		Above Ground	30		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9797112925048 40.7688046778472)
1945	1945	-73.9530257401736	40.795139740737	39G-PM-1013-01	39G	PM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9530257401736 40.79513974073701)
1956	1956	-73.98089749771201	40.7690578709841	2A-PM-1019-02	02A	PM	10192018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	0		POINT (-73.980897497712 40.7690578709841)
1960	1960	-73.97301589136609	40.7701310707272	6F-PM-1008-02	06F	PM	10082018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		1	1	0	0	0	chasing #2	0	0	0	0	0	0	0	0		POINT (-73.9730158913661 40.7701310707272)
2002	2002	-73.9581706950566	40.790632139726895	32F-AM-1012-05	32F	AM	10122018	5	Adult	Gray	White	Gray+White		Above Ground	10		1	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9581706950566 40.7906321397269)
2029	2029	-73.9687213827744	40.7843586374648	22B-PM-1014-02	22B	PM	10142018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	8		1	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9687213827744 40.7843586374648)
2033	2033	-73.9500167570283	40.7966185836685	41I-AM-1018-01	41I	AM	10182018	1	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	0	0	cautious,observant,runs off	POINT (-73.9500167570283 40.7966185836685)
2044	2044	-73.97715523261991	40.7706917595308	5C-AM-1006-01	05C	AM	10062018	1	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	1	0	0		0	0	0	1	0	1	0	0		POINT (-73.9771552326199 40.7706917595308)
2053	2053	-73.97118102224209	40.7773445611969	14D-PM-1019-05	14D	PM	10192018	5	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9711810222421 40.7773445611969)
2087	2087	-73.956502663005	40.788160908881004	30I-PM-1006-05	30I	PM	10062018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	1	0	0		POINT (-73.956502663005 40.788160908881)
2107	2107	-73.9772624834791	40.769282191854295	4C-PM-1010-05	04C	PM	10102018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9772624834791 40.7692821918543)
2113	2113	-73.95829048146521	40.790591574956395	32F-AM-1012-04	32F	AM	10122018	4	Adult	Black		Black+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9582904814652 40.7905915749564)

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