2018_Central_Park_Squirrel_Census_-_Squirrel_Data

98 rows where Age = "Adult", Date = 10142018, Indifferent = 0 and Location = "Ground Plane"

- 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, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Running, Chasing, Climbing, Eating, Foraging, Kuks, Tail flags, Tail twitches, Approaches, Runs from, Other Interactions

Link	rowid ▼	longitude	latitude	Unique Squirrel ID	Hectare	Shift	Date	Hectare Squirrel Number	Age	Primary Fur Color	Highlight Fur Color	Combination of Primary and Highlight Color	Color notes	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Climbing	Eating	Foraging	Other Activities	Kuks	Quaas	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
37	37	-73.96431539204279	40.78208185169571	22F-PM-1014-05	22F	PM	10142018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9643153920428 40.7820818516957)
42	42	-73.9579564338627	40.795933779502704	38C-PM-1014-09	38C	PM	10142018	9	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	1	0	0		POINT (-73.9579564338627 40.7959337795027)
108	108	-73.9574809028248	40.7950013620207	37D-PM-1014-04	37D	PM	10142018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	1	chasing (a chipmunk)	0	0	0	0	0	0	0	1		POINT (-73.9574809028248 40.7950013620207)
122	122	-73.9712527809516	40.7763310392591	13D-AM-1014-08	13D	AM	10142018	8	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as Primary. Cinnamon selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9712527809516 40.7763310392591)
128	128	-73.97462290946429	40.7748467061969	10B-PM-1014-05	10B	PM	10142018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	0	0	avoided people	POINT (-73.9746229094643 40.7748467061969)
154	154	-73.9686056085297	40.7781658424866	16E-AM-1014-03	16E	AM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9686056085297 40.7781658424866)
167	167	-73.95976427784271	40.7976368003915	39A-PM-1014-02	39A	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9597642778427 40.7976368003915)
236	236	-73.9737266070919	40.7786338379896	14A-PM-1014-01	14A	PM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9737266070919 40.7786338379896)
289	289	-73.9684254196866	40.77809016436	16E-AM-1014-02	16E	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9684254196866 40.77809016436)
338	338	-73.9765595553183	40.7748455340432	10A-PM-1014-04	10A	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9765595553183 40.7748455340432)
386	386	-73.95503513809571	40.7974681522214	40E-AM-1014-01	40E	AM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9550351380957 40.7974681522214)
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)
431	431	-73.97574360194321	40.774606436322706	10B-PM-1014-01	10B	PM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE	on lawn in front of a tree	0	0	0	0	1		0	0	0	0	1	0	0	0	stay on ground but went to other side of tree to hide from a dog	POINT (-73.9757436019432 40.7746064363227)
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)
487	487	-73.9666521094255	40.7842753517648	23C-PM-1014-02	23C	PM	10142018	2	Adult	Gray		Gray+		Ground Plane	FALSE	in bushes, then ran across path	1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9666521094255 40.7842753517648)
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)
501	501	-73.9708798496132	40.7761532088521	13D-AM-1014-06	13D	AM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9708798496132 40.7761532088521)
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)
544	544	-73.9718474480919	40.7794963354254	16B-AM-1014-01	16B	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9718474480919 40.7794963354254)
558	558	-73.95793352754859	40.7953080673706	37D-PM-1014-05	37D	PM	10142018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9579335275486 40.7953080673706)
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)
581	581	-73.9556218199258	40.7980460204041	41D-PM-1014-01	41D	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0	digging,drinking	0	0	0	0	0	0	0	1		POINT (-73.9556218199258 40.7980460204041)
643	643	-73.976730206737	40.773709213913996	8A-PM-1014-01	08A	PM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	1	0		1	0	0	0	0	0	0	1	runs from (goes up a tree)	POINT (-73.976730206737 40.773709213914)
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)
793	793	-73.9730111650468	40.7782157736204	14B-PM-1014-05	14B	PM	10142018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9730111650468 40.7782157736204)
829	829	-73.9711801122578	40.778688894221396	16C-AM-1014-02	16C	AM	10142018	2	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.97118011225781 40.77868889422141)
843	843	-73.97140896474309	40.7767916587915	14D-AM-1014-12	14D	AM	10142018	12	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9714089647431 40.7767916587915)
898	898	-73.95428280532559	40.794179732035495	37G-AM-1014-03	37G	AM	10142018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9542828053256 40.7941797320355)
941	941	-73.9717920322306	40.7763095393715	13D-AM-1014-10	13D	AM	10142018	10	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9717920322306 40.7763095393715)
956	956	-73.9581173730857	40.795477217054895	37D-PM-1014-08	37D	PM	10142018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9581173730857 40.7954772170549)
974	974	-73.9753744539307	40.7671162211032	2F-PM-1014-12	02F	PM	10142018	12	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.97537445393071 40.7671162211032)
1005	1005	-73.95582687317709	40.7952074193788	38E-PM-1014-04	38E	PM	10142018	4	Adult	Gray		Gray+		Ground Plane	FALSE	THICK UNDERGROWTH	0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9558268731771 40.7952074193788)
1036	1036	-73.9709207551033	40.7767932008037	14D-AM-1014-04	14D	AM	10142018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9709207551033 40.7767932008037)
1075	1075	-73.9640534906634	40.777738389983604	17I-AM-1014-02	17I	AM	10142018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0	standing upright	0	0	0	0	0	1	0	1	runs from (only ran away when a grandpa chased it off)	POINT (-73.9640534906634 40.7777383899836)
1102	1102	-73.9688173465755	40.7782009764626	16E-AM-1014-08	16E	AM	10142018	8	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (dog)	POINT (-73.9688173465755 40.7782009764626)
1119	1119	-73.9597557819449	40.7949918204459	36C-AM-1014-01	36C	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon	Gray & Cinnamon selected as Primary. Cinnamon selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9597557819449 40.7949918204459)
1134	1134	-73.9716995507598	40.7797671327739	16B-AM-1014-02	16B	AM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9716995507598 40.7797671327739)
1183	1183	-73.9525699067954	40.7937125788106	38I-PM-1014-01	38I	PM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	on the lawn East of the fountain	0	0	0	0	0	scampering thru the grass!	0	0	0	0	1	0	0	1		POINT (-73.9525699067954 40.7937125788106)
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)
1271	1271	-73.96567502325959	40.7833002587016	22E-PM-1014-01	22E	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9656750232596 40.7833002587016)
1295	1295	-73.9709534894049	40.7765964740768	14D-AM-1014-15	14D	AM	10142018	15	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	1	0	0		POINT (-73.9709534894049 40.7765964740768)
1298	1298	-73.9612900553755	40.791291739186704	32C-AM-1014-01	32C	AM	10142018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9612900553755 40.7912917391867)
1360	1360	-73.96749306684309	40.781351011968	20D-PM-1014-01	20D	PM	10142018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.96749306684312 40.781351011968)
1389	1389	-73.9580021017892	40.7955140102242	37D-PM-1014-07	37D	PM	10142018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9580021017892 40.7955140102242)
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)
1490	1490	-73.9727405679487	40.778267755448205	14B-PM-1014-01	14B	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9727405679487 40.7782677554482)
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)
1525	1525	-73.97271159154221	40.7782929320632	14B-PM-1014-02	14B	PM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9727115915422 40.7782929320632)
1538	1538	-73.9698083598887	40.7720099392886	10H-AM-1014-01	10H	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9698083598887 40.7720099392886)
1584	1584	-73.9581310602492	40.7960214726964	38C-PM-1014-05	38C	PM	10142018	5	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	0	chasing (#4)	0	0	0	0	0	0	0	1		POINT (-73.9581310602492 40.7960214726964)
1635	1635	-73.95607317386771	40.798033601855394	41D-PM-1014-02	41D	PM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9560731738677 40.7980336018554)
1726	1726	-73.9686479277215	40.7705815354769	9I-AM-1014-08	09I	AM	10142018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9686479277215 40.7705815354769)
1753	1753	-73.9733437449715	40.778240154836205	14B-PM-1014-07	14B	PM	10142018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9733437449715 40.7782401548362)
1803	1803	-73.9588076804698	40.7912942607296	33E-AM-1014-06	33E	AM	10142018	6	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9588076804698 40.7912942607296)
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)
1884	1884	-73.9733898487296	40.7666975131518	3H-PM-1014-02	03H	PM	10142018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9733898487296 40.7666975131518)
1908	1908	-73.95883455468791	40.7991830272008	40A-PM-1014-02	40A	PM	10142018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (ran from base of tree into bushes)	POINT (-73.9588345546879 40.7991830272008)
1965	1965	-73.9719359643975	40.772699885583	9F-PM-1014-01	09F	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0	he is fed every day by a woman who calls him "chiquita"! he ran right up to her.	POINT (-73.9719359643975 40.772699885583)
2047	2047	-73.9721656413591	40.7722869065638	9F-PM-1014-08	09F	PM	10142018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0	turned to face me while eating	POINT (-73.9721656413591 40.7722869065638)
2055	2055	-73.9806928007664	40.768255422025	1A-PM-1014-03	01A	PM	10142018	3	Adult	Gray	Black	Gray+Black		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9806928007664 40.768255422025)
2070	2070	-73.9725700261894	40.7668793330427	3H-PM-1014-01	03H	PM	10142018	1	Adult	Gray		Gray+		Ground Plane	FALSE	under a parked car	1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9725700261894 40.7668793330427)
2073	2073	-73.9661108248377	40.7891945123815	28A-AM-1014-01	28A	AM	10142018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9661108248377 40.7891945123815)
2086	2086	-73.9525627119429	40.793860286746394	38I-PM-1014-02	38I	PM	10142018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	hanging out w/ Squirrel #1	0	0	0	0	0	scampering w/ squirrel #1	0	0	0	0	1	0	0	1		POINT (-73.9525627119429 40.7938602867464)
2124	2124	-73.97300395815209	40.7730688398468	9E-PM-1014-03	09E	PM	10142018	3	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE	underneath a tree	0	0	0	1	1		0	0	0	0	1	0	0	0		POINT (-73.9730039581521 40.7730688398468)
2149	2149	-73.9691845420174	40.7707749899254	9I-AM-1014-03	09I	AM	10142018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9691845420174 40.7707749899254)
2196	2196	-73.96233563694321	40.7888693815168	29D-AM-1014-05	29D	AM	10142018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	Rocky area	0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9623356369432 40.7888693815168)
2216	2216	-73.97351950184459	40.778714727971504	14A-AM-1014-02	14A	AM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	1	0	0	0		POINT (-73.9735195018446 40.7787147279715)
2234	2234	-73.9734741818047	40.766328451425	3H-PM-1014-03	03H	PM	10142018	3	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9734741818047 40.766328451425)
2276	2276	-73.9611985783336	40.791604823372005	32C-AM-1014-06	32C	AM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9611985783336 40.791604823372)
2279	2279	-73.9586085858962	40.7990326758282	40A-PM-1014-04	40A	PM	10142018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (ran from path to bushes)	POINT (-73.9586085858962 40.7990326758282)
2307	2307	-73.9736997033862	40.778497952406	14A-PM-1014-02	14A	PM	10142018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9736997033862 40.778497952406)
2312	2312	-73.97658670292259	40.7674304266107	2E-PM-1014-01	02E	PM	10142018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	1	0	0		POINT (-73.9765867029226 40.7674304266107)
2316	2316	-73.957697363244	40.7997576909042	42A-PM-1014-01	42A	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1	up on hind legs looking around	0	0	0	0	0	0	0	0	came to about 10' away then ran off	POINT (-73.957697363244 40.7997576909042)
2332	2332	-73.9709797467807	40.776909571067904	14D-AM-1014-07	14D	AM	10142018	7	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9709797467807 40.7769095710679)
2398	2398	-73.95871384837301	40.7963918051751	38C-PM-1014-02	38C	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.958713848373 40.7963918051751)
2416	2416	-73.95886898209079	40.799238413797205	40A-PM-1014-03	40A	PM	10142018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (ran from base of tree into bushes)	POINT (-73.9588689820908 40.799238413797205)
2439	2439	-73.95874591363909	40.7982497351812	40B-PM-1014-05	40B	PM	10142018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9587459136391 40.7982497351812)
2464	2464	-73.96913180449691	40.770980197469605	9I-AM-1014-05	09I	AM	10142018	5	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9691318044969 40.7709801974696)
2536	2536	-73.96850872880721	40.7779068128051	16E-AM-1014-01	16E	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	burying food	0	0	0	0	0	1	0	0		POINT (-73.9685087288072 40.7779068128051)
2551	2551	-73.970138810251	40.770579297644	8H-PM-1014-02	08H	PM	10142018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0	froze & watched me,then went back to eating	POINT (-73.970138810251 40.770579297644)
2618	2618	-73.95795157569	40.7961254697958	38C-PM-1014-04	38C	PM	10142018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	1	0		0	0	0	1	0	0	0	1		POINT (-73.95795157569 40.7961254697958)
2621	2621	-73.9596904740342	40.7897200025671	31E-AM-1014-01	31E	AM	10142018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9596904740342 40.7897200025671)
2655	2655	-73.9659156108069	40.781070981869604	20E-AM-1014-01	20E	AM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	1	1		0	0	0	0	1	0	0	0		POINT (-73.9659156108069 40.7810709818696)
2710	2710	-73.9577919365342	40.796085328505896	38C-PM-1014-08	38C	PM	10142018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		1	0	0	0	0	0	0	1		POINT (-73.9577919365342 40.7960853285059)
2738	2738	-73.9691801791373	40.770927235357206	9I-AM-1014-04	09I	AM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9691801791373 40.7709272353572)
2758	2758	-73.95420748142959	40.79543222400039	39F-AM-1014-01	39F	AM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9542074814296 40.7954322240004)
2809	2809	-73.9686756254868	40.777745910265104	16E-AM-1014-04	16E	AM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9686756254868 40.7777459102651)
2849	2849	-73.9709912560997	40.77589655951979	13D-AM-1014-01	13D	AM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	0	1		POINT (-73.9709912560997 40.7758965595198)
2881	2881	-73.9541629063295	40.7934259301577	37G-AM-1014-02	37G	AM	10142018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0	ran away & disappeared	0	0	0	0	0	0	0	0		POINT (-73.9541629063295 40.7934259301577)
2892	2892	-73.9688070760806	40.777968829417205	16E-AM-1014-06	16E	AM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	0	0	0	1		POINT (-73.9688070760806 40.777968829417205)
2899	2899	-73.9686358129525	40.7778035516486	16E-AM-1014-05	16E	AM	10142018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9686358129525 40.7778035516486)
2901	2901	-73.9735833104203	40.7786318041581	14A-PM-1014-08	14A	PM	10142018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1	new movement flailing arms while foraging	0	0	0	0	0	0	0	1		POINT (-73.9735833104203 40.7786318041581)
2922	2922	-73.97034213914421	40.7773706575356	14D-AM-1014-01	14D	AM	10142018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9703421391442 40.7773706575356)
2936	2936	-73.9809876538513	40.768322324214296	1A-PM-1014-05	01A	PM	10142018	5	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9809876538513 40.7683223242143)
2948	2948	-73.9545225586988	40.7956074663106	39F-AM-1014-03	39F	AM	10142018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9545225586988 40.7956074663106)
2959	2959	-73.9747963162162	40.7745023355775	10B-PM-1014-04	10B	PM	10142018	4	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.9747963162162 40.7745023355775)
2975	2975	-73.959412243507	40.7917871123534	33E-AM-1014-01	33E	AM	10142018	1	Adult	Black	Cinnamon	Black+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	digging	0	0	0	0	0	0	0	1		POINT (-73.959412243507 40.7917871123534)
3010	3010	-73.9580906814132	40.7948404060484	37D-PM-1014-01	37D	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1	eyes from a safe distance	POINT (-73.9580906814132 40.7948404060484)

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