2018_Central_Park_Squirrel_Census_-_Squirrel_Data

129 rows where Above Ground Sighter Measurement = "FALSE", Hectare Squirrel Number = 2, Shift = "AM" and Tail twitches = 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: Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Approaches, Indifferent, Runs from

Link	rowid ▼	longitude	latitude	Unique Squirrel ID	Hectare	Shift	Date	Hectare Squirrel Number	Age	Primary Fur Color	Highlight Fur Color	Combination of Primary and Highlight Color	Color notes	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Climbing	Eating	Foraging	Other Activities	Kuks	Quaas	Moans	Tail flags	Tail twitches	Approaches	Indifferent	Runs from	Other Interactions	Lat/Long
6	6	-73.9565700386162	40.7902561000937	33H-AM-1019-02	33H	AM	10192018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	wrestling with mother	0	0	0	0	0	0	0	0		POINT (-73.9565700386162 40.7902561000937)
13	13	-73.95412017897951	40.793181170108205	36H-AM-1010-02	36H	AM	10102018	2	Adult	Gray		Gray+	just outside hectare	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9541201789795 40.7931811701082)
14	14	-73.9582694312289	40.7917367820255	33F-AM-1008-02	33F	AM	10082018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9582694312289 40.7917367820255)
33	33	-73.9738033257473	40.7711846894166	7E-AM-1006-02	07E	AM	10062018	2	Adult	Gray		Gray+		Ground Plane	FALSE	under a tree	0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9738033257473 40.7711846894166)
56	56	-73.97246424363941	40.7690526441109	6G-AM-1008-02	06G	AM	10082018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE	bush	0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9724642436394 40.7690526441109)
62	62	-73.952819267977	40.792313040279296	36I-AM-1017-02	36I	AM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon stripe on back	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.952819267977 40.7923130402793)
95	95	-73.9692883970928	40.776855370308205	14E-AM-1008-02	14E	AM	10082018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	1	walking	0	0	0	0	0	0	0	1		POINT (-73.9692883970928 40.7768553703082)
187	187	-73.9700162034073	40.7815277479588	19B-AM-1019-02	19B	AM	10192018	2	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	1	0	posing	0	0	0	0	0	0	1	1	indifferent then runs from	POINT (-73.9700162034073 40.7815277479588)
200	200	-73.9510747586301	40.7973106833951	42H-AM-1019-02	42H	AM	10192018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9510747586301 40.7973106833951)
206	206	-73.96136434180251	40.789243193420894	30D-AM-1017-02	30D	AM	10172018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9613643418025 40.7892431934209)
230	230	-73.97314980648721	40.7659963196581	2H-AM-1006-02	02H	AM	10062018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	1	0	0		0	0	0	0	0	1	0	0		POINT (-73.9731498064872 40.7659963196581)
234	234	-73.9741401377844	40.7758134257881	12B-AM-1007-02	12B	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9741401377844 40.7758134257881)
241	241	-73.97602564775579	40.7703573131398	5D-AM-1020-02	05D	AM	10202018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	1	small jumps	0	0	0	0	0	0	0	0		POINT (-73.9760256477558 40.7703573131398)
250	250	-73.97267476660019	40.77030226693079	7F-AM-1008-02	07F	AM	10082018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	see stories and locations	POINT (-73.9726747666002 40.7703022669308)
251	251	-73.95708175790921	40.7964221087879	38D-AM-1017-02	38D	AM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	hiding in log	0	0	0	0	0	0	1	0		POINT (-73.9570817579092 40.7964221087879)
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)
287	287	-73.9709281471442	40.782809793977705	20A-AM-1010-02	20A	AM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9709281471442 40.7828097939777)
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)
325	325	-73.96309908232429	40.788576428401605	28D-AM-1012-02	28D	AM	10122018	2	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	1		POINT (-73.9630990823243 40.7885764284016)
334	334	-73.9687395228846	40.7807364481385	18D-AM-1018-02	18D	AM	10182018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0		POINT (-73.9687395228846 40.7807364481385)
346	346	-73.9712971568288	40.7745520717065	11E-AM-1013-02	11E	AM	10132018	2	Adult	Gray	Black	Gray+Black		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9712971568288 40.7745520717065)
442	442	-73.9502466289084	40.795922877988296	41I-AM-1018-02	41I	AM	10182018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	0	runs off	POINT (-73.9502466289084 40.7959228779883)
451	451	-73.97531406404451	40.7734037805101	9C-AM-1006-02	09C	AM	10062018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9753140640445 40.7734037805101)
464	464	-73.96644503991209	40.788784490469496	27A-AM-1008-02	27A	AM	10082018	2	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9664450399121 40.7887844904695)
473	473	-73.95701300171591	40.799602742862504	42B-AM-1014-02	42B	AM	10142018	2	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1	digging	0	0	0	0	0	0	1	0		POINT (-73.9570130017159 40.7996027428625)
484	484	-73.9666526554772	40.7756111718355	14H-AM-1007-02	14H	AM	10072018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	sitting	0	0	0	0	0	0	1	0		POINT (-73.9666526554772 40.77561117183551)
529	529	-73.96352907511829	40.7820936628202	22G-AM-1018-02	22G	AM	10182018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	1	0	0		1	0	0	0	0	0	0	1		POINT (-73.9635290751183 40.7820936628202)
535	535	-73.9772396728545	40.7668696411765	2E-AM-1010-02	02E	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	1	0	totally indifferent	POINT (-73.9772396728545 40.7668696411765)
553	553	-73.9638526062093	40.782693848993	22F-AM-1007-02	22F	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	standing	0	0	0	0	0	0	1	0		POINT (-73.9638526062093 40.782693848993)
603	603	-73.9721592378418	40.776034583573	12C-AM-1013-02	12C	AM	10132018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		1	0	0	0	0	0	1	0		POINT (-73.9721592378418 40.776034583573)
624	624	-73.96130519573059	40.7909351393505	31D-AM-1014-02	31D	AM	10142018	2	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE	Undergrowth	0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9613051957306 40.7909351393505)
629	629	-73.95737241332641	40.7980080911115	40C-AM-1017-02	40C	AM	10172018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	1	0	chasing (#1)	0	0	0	0	0	0	0	1		POINT (-73.9573724133264 40.7980080911115)
648	648	-73.95394000282359	40.79800412717	41E-AM-1007-02	41E	AM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9539400028236 40.79800412717)
663	663	-73.9766440589836	40.7682390282581	3E-AM-1006-02	03E	AM	10062018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	0	1		POINT (-73.9766440589836 40.7682390282581)
671	671	-73.9709244006956	40.7676942639697	5I-AM-1010-02	05I	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9709244006956 40.7676942639697)
680	680	-73.95640114211221	40.7958097849369	38E-AM-1010-02	38E	AM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	0	climbs	POINT (-73.95640114211221 40.7958097849369)
694	694	-73.9698032734704	40.7782343912417	16D-AM-1007-02	16D	AM	10072018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9698032734704 40.7782343912417)
732	732	-73.9695041366722	40.779787880948206	17D-AM-1008-02	17D	AM	10082018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9695041366722 40.7797878809482)
738	738	-73.9725712588741	40.7669101832926	4H-AM-1006-02	04H	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	0	climbing (over small wire fence then on the ground)	0	0	0	0	0	1	0	1	approaches (saw me & came forward),runs from (startled by another person)	POINT (-73.9725712588741 40.7669101832926)
745	745	-73.9671640520938	40.7772236833816	16G-AM-1010-02	16G	AM	10102018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9671640520938 40.7772236833816)
766	766	-73.96844631543979	40.78348133193521	21B-AM-1019-02	21B	AM	10192018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9684463154398 40.7834813319352)
806	806	-73.97047575554599	40.7763348062134	13E-AM-1017-02	13E	AM	10172018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	begging (came one yard away from me and stood there)	0	0	0	0	0	1	0	0		POINT (-73.970475755546 40.7763348062134)
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)
821	821	-73.959077668148	40.7926045823346	34D-AM-1008-02	34D	AM	10082018	2	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.959077668148 40.7926045823346)
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)
848	848	-73.9692190295442	40.776336630915395	14F-AM-1007-02	14F	AM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9692190295442 40.7763366309154)
892	892	-73.9611368390233	40.7815619053395	22I-AM-1007-02	22I	AM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9611368390233 40.7815619053395)
915	915	-73.9770235090023	40.774135208066	9A-AM-1013-02	09A	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9770235090023 40.774135208066)
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)
972	972	-73.9704591091677	40.7729175143429	10G-AM-1006-02	10G	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	notch on tail	Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9704591091677 40.7729175143429)
993	993	-73.97724226646571	40.773436329163	8A-AM-1013-02	08A	AM	10132018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	playground	1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9772422664657 40.773436329163)
1050	1050	-73.9562642076935	40.798333876307396	41C-AM-1017-02	41C	AM	10172018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	0	0		POINT (-73.9562642076935 40.7983338763074)
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)
1120	1120	-73.9564079273261	40.7939340053805	36F-AM-1017-02	36F	AM	10172018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon on shoulders	Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9564079273261 40.7939340053805)
1130	1130	-73.95190816277679	40.7973148719421	41G-AM-1013-02	41G	AM	10132018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9519081627768 40.7973148719421)
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)
1136	1136	-73.9515907796216	40.795268423547704	40H-AM-1017-02	40H	AM	10172018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.95159077962161 40.7952684235477)
1153	1153	-73.9688523924488	40.7844018035948	22A-AM-1008-02	22A	AM	10082018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9688523924488 40.7844018035948)
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)
1228	1228	-73.9729090336637	40.779434005250295	15A-AM-1007-02	15A	AM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0	in fenced in lawn (chill)	POINT (-73.9729090336637 40.7794340052503)
1258	1258	-73.9789385196073	40.7675202157155	2C-AM-1010-02	02C	AM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	0	0		POINT (-73.9789385196073 40.7675202157155)
1266	1266	-73.9709897849823	40.768627964006	6H-AM-1008-02	06H	AM	10082018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9709897849823 40.768627964006)
1274	1274	-73.9745859998733	40.7671634885616	3G-AM-1008-02	03G	AM	10082018	2	Adult	Gray		Gray+	Big one! Beautiful tail	Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9745859998733 40.7671634885616)
1286	1286	-73.9589096782789	40.793969875790296	35D-AM-1019-02	35D	AM	10192018	2	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White	Black tail & edge, Cinnamon mid, While tail edge	Ground Plane	FALSE		0	0	0	0	1	very quietly searching in long grass	0	0	0	0	0	0	0	0		POINT (-73.9589096782789 40.7939698757903)
1319	1319	-73.9562105506291	40.796699119790894	39D-AM-1008-02	39D	AM	10082018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9562105506291 40.7966991197909)
1325	1325	-73.97752788478971	40.7687881061059	3C-AM-1007-02	03C	AM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9775278847897 40.7687881061059)
1330	1330	-73.9643032554205	40.7794514526463	19H-AM-1010-02	19H	AM	10102018	2		Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE	near base of small tree	1	0	0	1	1		0	0	0	1	0	1	0	0	ran from human with dog	POINT (-73.9643032554205 40.7794514526463)
1332	1332	-73.97749282457809	40.7720464606979	6B-AM-1012-02	06B	AM	10122018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	by bike racks at Tavern on the Green	0	0	0	0	1	walking,exploring - digging in flower bed	0	0	0	0	0	0	0	1		POINT (-73.9774928245781 40.7720464606979)
1439	1439	-73.9729645190377	40.7723310150843	9E-AM-1008-02	09E	AM	10082018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9729645190377 40.7723310150843)
1444	1444	-73.9763852372393	40.768876248561	4D-AM-1012-02	04D	AM	10122018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9763852372393 40.768876248561)
1455	1455	-73.9715621134573	40.7695918717513	7H-AM-1006-02	07H	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1	running (along ground,up tree)	0	0	0	0	0	0	1	0		POINT (-73.9715621134573 40.76959187175131)
1477	1477	-73.9589635326362	40.7951748673846	37C-AM-1012-02	37C	AM	10122018	2	Adult	Gray	Cinnamon	Gray+Cinnamon	Cinnamon flanks, light band across nose	Ground Plane	FALSE		0	0	0	0	1	caching	0	0	0	0	0	0	1	0		POINT (-73.9589635326362 40.7951748673846)
1482	1482	-73.95886101956991	40.7945269936639	36C-AM-1014-02	36C	AM	10142018	2	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE	Crossing path	0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9588610195699 40.7945269936639)
1528	1528	-73.9690104245067	40.7853358193723	23A-AM-1018-02	23A	AM	10182018	2	Juvenile	Black		Black+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9690104245067 40.7853358193723)
1558	1558	-73.968200390984	40.783709576948205	22B-AM-1013-02	22B	AM	10132018	2	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE		0	0	0	0	1	climbed tree	0	0	0	0	0	0	1	0		POINT (-73.968200390984 40.7837095769482)
1603	1603	-73.95459292421741	40.7986940168685	42D-AM-1014-02	42D	AM	10142018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments.	Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9545929242174 40.7986940168685)
1632	1632	-73.9592392692535	40.796186995179795	37B-AM-1018-02	37B	AM	10182018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9592392692535 40.7961869951798)
1633	1633	-73.97470601437419	40.7728528164878	8C-AM-1007-02	08C	AM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	0	peeps out from behind tree at cooing tourists	POINT (-73.9747060143742 40.7728528164878)
1634	1634	-73.97264597739951	40.7656357433691	2I-AM-1006-02	02I	AM	10062018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9726459773995 40.7656357433691)
1643	1643	-73.95305356247809	40.7929809144271	37I-AM-1010-02	37I	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9530535624781 40.7929809144271)
1708	1708	-73.9618486459307	40.7946365810826	35A-AM-1014-02	35A	AM	10142018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9618486459307 40.7946365810826)
1716	1716	-73.97974252624591	40.76791202463521	1B-AM-1012-02	01B	AM	10122018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9797425262459 40.7679120246352)
1717	1717	-73.97149520927671	40.7748063281815	12E-AM-1017-02	12E	AM	10172018	2	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9714952092767 40.7748063281815)
1719	1719	-73.955429970986	40.797816862987496	40D-AM-1013-02	40D	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.955429970986 40.7978168629875)
1721	1721	-73.95873307074629	40.7907682009641	32F-AM-1012-02	32F	AM	10122018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray patches on back legs	Ground Plane	FALSE		0	0	0	0	0	curious about me	0	0	0	0	0	1	0	1		POINT (-73.9587330707463 40.7907682009641)
1724	1724	-73.9795492724533	40.770949747173795	4A-AM-1007-02	04A	AM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9795492724533 40.7709497471738)
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)
1853	1853	-73.9721210372896	40.7667971476099	4I-AM-1006-02	04I	AM	10062018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	0	0	1	0		POINT (-73.9721210372896 40.7667971476099)
1879	1879	-73.97019267362809	40.7778587687376	15D-AM-1007-02	15D	AM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9701926736281 40.7778587687376)
1895	1895	-73.954699659637	40.7951308856929	38F-AM-1018-02	38F	AM	10182018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.954699659637 40.7951308856929)
1917	1917	-73.9627819112681	40.7886877360376	29D-AM-1014-02	29D	AM	10142018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9627819112681 40.7886877360376)
1936	1936	-73.9667911565238	40.779321901098	18F-AM-1014-02	18F	AM	10142018	2	Adult	Gray		Gray+		Ground Plane	FALSE	In small tree by water	0	0	0	1	1		0	1	0	0	0	0	1	0		POINT (-73.9667911565238 40.77932190109801)
1978	1978	-73.9579689996645	40.794933848991704	37D-AM-1018-02	37D	AM	10182018	2	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9579689996645 40.7949338489917)
1990	1990	-73.9774584305147	40.770813398619204	5B-AM-1008-02	05B	AM	10082018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9774584305147 40.7708133986192)
2004	2004	-73.9635838951472	40.7917524619792	31B-AM-1017-02	31B	AM	10172018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	0	1		POINT (-73.9635838951472 40.7917524619792)
2038	2038	-73.98035621370491	40.7685780990634	2B-AM-1010-02	02B	AM	10102018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0	0	0	1		POINT (-73.9803562137049 40.7685780990634)
2051	2051	-73.9544808708211	40.7906575852286	34I-AM-1012-02	34I	AM	10122018	2	Adult	Gray	White	Gray+White	Short tail	Ground Plane	FALSE		0	0	0	0	0	hiding	0	0	0	0	0	0	0	1		POINT (-73.9544808708211 40.7906575852286)
2108	2108	-73.9702420100291	40.7772720889907	14D-AM-1014-02	14D	AM	10142018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9702420100291 40.7772720889907)
2126	2126	-73.96126235775479	40.7911558714527	32D-AM-1013-02	32D	AM	10132018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	0	1	0		POINT (-73.9612623577548 40.7911558714527)
2200	2200	-73.96980803283041	40.7842252948542	21A-AM-1019-02	21A	AM	10192018	2	Adult	Gray		Gray+		Ground Plane	FALSE	Tree & ground	0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9698080328304 40.7842252948542)

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