2018_Central_Park_Squirrel_Census_-_Squirrel_Data

1,588 rows where Foraging = 0 sorted by Highlight Fur Color

- 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
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)
955	955	-73.96065706156101	40.79561507441021	36A-PM-1013-08	36A	PM	10132018	8		Gray		Gray+		Ground Plane	FALSE	"FIELD"	1	0	0	0	0	running from #7	0	0	0	0	0	0	0	1		POINT (-73.960657061561 40.7956150744102)
958	958	-73.9613862251332	40.791282169715	32C-AM-1014-03	32C	AM	10142018	3	Adult	Gray		Gray+		Above Ground	3		0	1	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9613862251332 40.791282169715)
969	969	-73.97735293684991	40.772875068569896	7B-AM-1008-12	07B	AM	10082018	12	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9773529368499 40.7728750685699)
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)
977	977	-73.9764601882854	40.766070446642	1F-AM-1010-05	01F	AM	10102018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9764601882854 40.766070446642)
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)
979	979	-73.9612349421547	40.795958647574395	36A-PM-1013-09	36A	PM	10132018	9		Gray		Gray+		Ground Plane	FALSE	THICK UNDERGROWTH	1	0	0	0	0		0	0	0	0	1	0	0	1		POINT (-73.9612349421547 40.7959586475744)
980	980	-73.9709817796369	40.7773554311586	14D-PM-1019-07	14D	PM	10192018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9709817796369 40.7773554311586)
981	981	-73.9673160165357	40.776615800120204	15G-PM-1019-12	15G	PM	10192018	12	Adult	Gray		Gray+		Above Ground	4		0	0	1	0	0		0	0	0	0	0	0	0	0	stared	POINT (-73.9673160165357 40.7766158001202)
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)
988	988	-73.97870401924729	40.767901024728104	2C-AM-1010-06	02C	AM	10102018	6	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0	stood still & watched me then jumped on a fence and ran away	0	0	0	0	0	0	1	1		POINT (-73.9787040192473 40.7679010247281)
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)
1011	1011	-73.97191114701641	40.7758789855474	12D-AM-1013-02	12D	AM	10132018	2	Adult	Gray		Gray+		Above Ground	7	Was on top of the edge of Bow Bridge	0	0	0	0	0	jumped off	0	0	0	1	0	0	0	1		POINT (-73.9719111470164 40.7758789855474)
1016	1016	-73.9691293546408	40.7703219076549	8I-AM-1006-11	08I	AM	10062018	11	Adult	Gray		Gray+		Above Ground	50	tree	0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9691293546408 40.77032190765491)
1023	1023	-73.97608800701859	40.7711057827923	6C-PM-1020-04	06C	PM	10202018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9760880070186 40.7711057827923)
1032	1032	-73.96328685617941	40.7907806312915	30B-AM-1007-06	30B	AM	10072018	6	Adult	Gray		Gray+		Above Ground	5		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9632868561794 40.7907806312915)
1037	1037	-73.96774098419691	40.776357914063894	15G-PM-1019-08	15G	PM	10192018	8	Adult			+		Above Ground	5		0	1	0	0	0		0	1	1	0	0	0	0	0		POINT (-73.9677409841969 40.7763579140639)
1038	1038	-73.9563311167069	40.79509015633371	38E-AM-1010-12	38E	AM	10102018	12	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE	running on rocks	0	1	0	0	0		0	0	0	1	0	0	0	0	runs toward something	POINT (-73.9563311167069 40.7950901563337)
1041	1041	-73.9643236505425	40.7887854771596	28C-AM-1014-02	28C	AM	10142018	2	Adult	Gray		Gray+		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9643236505425 40.7887854771596)
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)
1051	1051	-73.96137470327021	40.7920483852431	33C-PM-1007-01	33C	PM	10072018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9613747032702 40.792048385243106)
1053	1053	-73.96858597054859	40.784880506532204	23A-AM-1018-04	23A	AM	10182018	4	Adult	Gray		Gray+		Above Ground	3	Tree	0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9685859705486 40.7848805065322)
1061	1061	-73.9532657715601	40.7949046809422	39G-AM-1018-02	39G	AM	10182018	2	Juvenile	Gray		Gray+		Above Ground	25	Tree	0	0	0	0	0	sitting & watching	0	0	0	0	0	0	1	0		POINT (-73.9532657715601 40.7949046809422)
1065	1065	-73.9769700777377	40.772848957496706	7B-AM-1008-08	07B	AM	10082018	8	Adult	Gray		Gray+		Above Ground	5		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9769700777377 40.7728489574967)
1069	1069	-73.9595485734618	40.7835326425693	25I-PM-1007-08	25I	PM	10072018	8	Adult	Gray		Gray+		Above Ground		playing very high in tree w/ #7	0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9595485734618 40.7835326425693)
1070	1070	-73.9674631254594	40.7790076357696	17E-AM-1017-10	17E	AM	10172018	10	Juvenile	Gray		Gray+		Above Ground	2	Fence	1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9674631254594 40.7790076357696)
1071	1071	-73.9703774000082	40.771760755155505	9G-AM-1007-01	09G	AM	10072018	1	Adult	Gray		Gray+		Above Ground	50		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9703774000082 40.7717607551555)
1072	1072	-73.9566571713254	40.798985577543505	41C-AM-1017-04	41C	AM	10172018	4		Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9566571713254 40.7989855775435)
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)
1084	1084	-73.96988397502491	40.778143307669204	16D-PM-1010-08	16D	PM	10102018	8	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		1	0	0	0	0	0	1	0		POINT (-73.9698839750249 40.7781433076692)
1087	1087	-73.9679955831115	40.7818431607916	20C-PM-1018-04	20C	PM	10182018	4	Adult	Gray		Gray+		Above Ground	8		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9679955831115 40.7818431607916)
1095	1095	-73.9735547926323	40.772342007610796	8D-AM-1007-02	08D	AM	10072018	2	Adult	Gray		Gray+		Above Ground	12		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9735547926323 40.7723420076108)
1096	1096	-73.95683008997729	40.793585574335395	36E-AM-1013-01	36E	AM	10132018	1	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	0	1	runs from (ran into treebrush)	POINT (-73.9568300899773 40.7935855743354)
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)
1110	1110	-73.96764342569759	40.78623366244479	24A-PM-1007-04	24A	PM	10072018	4	Adult	Gray		Gray+		Above Ground	50	in tree	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9676434256976 40.7862336624448)
1112	1112	-73.9583934264026	40.7854742185504	27I-AM-1007-02	27I	AM	10072018	2				+					0	0	0	0	0		1	0	0	0	0	0	0	0		POINT (-73.9583934264026 40.785474218550405)
1137	1137	-73.9520280004414	40.7946345014466	39I-PM-1013-03	39I	PM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0	playing	0	0	0	0	0	1	0	0		POINT (-73.9520280004414 40.7946345014466)
1138	1138	-73.9594357049738	40.7840678890949	25I-AM-1012-01	25I	AM	10122018	1	Adult	Cinnamon		Cinnamon+		Above Ground	4	on bar	0	0	0	1	0		0	0	0	1	1	1	0	0		POINT (-73.9594357049738 40.7840678890949)
1144	1144	-73.9743184653765	40.7667932997	3G-AM-1008-01	03G	AM	10082018	1	Adult	Gray		Gray+		Above Ground	30		0	0	1	0	0		1	0	0	0	0	0	0	0		POINT (-73.9743184653765 40.7667932997)
1147	1147	-73.96318185288159	40.7925332194132	32A-AM-1018-01	32A	AM	10182018	1	Adult	Gray		Gray+		Above Ground	15		1	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9631818528816 40.7925332194132)
1148	1148	-73.9707339200738	40.7796333355689	17C-PM-1013-03	17C	PM	10132018	3	Adult	Gray		Gray+		Above Ground	20	in a tree	0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9707339200738 40.7796333355689)
1162	1162	-73.95685442708809	40.7972517274475	39D-AM-1008-06	39D	AM	10082018	6	Adult	Gray		Gray+		Above Ground	3	on rock	0	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9568544270881 40.7972517274475)
1171	1171	-73.9573477643797	40.797173406050895	39C-AM-1017-01	39C	AM	10172018	1	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9573477643797 40.7971734060509)
1172	1172	-73.9706929270645	40.77278411194239	10G-AM-1006-06	10G	AM	10062018	6	Juvenile	Gray		Gray+	skinny tail	Ground Plane	FALSE		0	1	0	0	0	chasing (#5)	1	0	0	0	0	0	0	0		POINT (-73.9706929270645 40.7727841119424)
1173	1173	-73.959070754026	40.790667514341294	32E-PM-1017-07	32E	PM	10172018	7	Adult	Gray		Gray+		Ground Plane	FALSE	treed area	0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.959070754026 40.7906675143413)
1188	1188	-73.9669529835992	40.787186415136496	25A-AM-1013-05	25A	AM	10132018	5		Gray		Gray+		Ground Plane	FALSE	CROSS BRIDLE - INTO TREE TO AVOID DOGGO	1	0	1	0	0	d.p.t.	0	0	0	1	1	0	1	0	calm	POINT (-73.96695298359921 40.7871864151365)
1193	1193	-73.9731880656287	40.766002618615495	2H-AM-1006-01	02H	AM	10062018	1	Adult	Black		Black+		Ground Plane	FALSE		1	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9731880656287 40.7660026186155)
1206	1206	-73.97487092063541	40.77608025411	11B-PM-1014-01	11B	PM	10142018	1	Adult	Gray		Gray+	Fat!	Above Ground	10		0	0	1	0	0		1	0	0	0	0	0	0	1		POINT (-73.9748709206354 40.77608025411)
1207	1207	-73.95947083287321	40.791192982895005	32E-AM-1007-07	32E	AM	10072018	7	Adult	Gray		Gray+		Above Ground		on tennis club house roof	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9594708328732 40.791192982895)
1212	1212	-73.9761792189352	40.7745745517215	9A-AM-1013-09	09A	AM	10132018	9	Juvenile	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9761792189352 40.7745745517215)
1227	1227	-73.9527924755398	40.79343662605329	37I-AM-1010-04	37I	AM	10102018	4	Adult	Gray		Gray+		Above Ground	50	in tree	0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9527924755398 40.7934366260533)
1229	1229	-73.9677751507448	40.779099006665795	17E-AM-1017-11	17E	AM	10172018	11	Adult	Gray		Gray+		Ground Plane	FALSE	Shore	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9677751507448 40.7790990066658)
1230	1230	-73.9790822606486	40.7714466633386	5A-AM-1006-03	05A	AM	10062018	3	Juvenile	Cinnamon		Cinnamon+		Above Ground	8		0	0	1	1	0		0	0	0	1	0	0	0	1		POINT (-73.9790822606486 40.7714466633386)
1238	1238	-73.97736921314409	40.767977115014894	3D-PM-1010-02	03D	PM	10102018	2	Adult	Gray		Gray+		Above Ground	8		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9773692131441 40.7679771150149)
1244	1244	-73.9565260889843	40.7991807924337	42C-AM-1007-03	42C	AM	10072018	3				+					0	0	0	0	0		0	1	0	0	0	0	0	0		POINT (-73.9565260889843 40.79918079243371)
1248	1248	-73.9719729323923	40.7668318394546	4I-AM-1006-03	04I	AM	10062018	3	Adult			+	Can't tell :(	Above Ground	28	Tree	0	0	1	0	0	building nest!	0	0	0	0	0	0	0	0		POINT (-73.9719729323923 40.7668318394546)
1254	1254	-73.97640135898651	40.766306349920704	1F-PM-1019-03	01F	PM	10192018	3	Juvenile	Gray		Gray+		Above Ground	1		0	0	0	0	0	hiding	0	0	0	0	0	0	0	0		POINT (-73.9764013589865 40.7663063499207)
1255	1255	-73.9717469822209	40.7753731930704	12D-PM-1014-03	12D	PM	10142018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9717469822209 40.7753731930704)
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)
1261	1261	-73.9719109949232	40.772313852132704	9F-AM-1013-01	09F	AM	10132018	1	Adult	Black		Black+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9719109949232 40.7723138521327)
1263	1263	-73.9770873939997	40.771037966210606	6C-PM-1020-02	06C	PM	10202018	2	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9770873939997 40.7710379662106)
1265	1265	-73.96035971176191	40.7824399298414	23I-PM-1019-02	23I	PM	10192018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9603597117619 40.7824399298414)
1267	1267	-73.9701010964667	40.768891931450796	6I-PM-1013-02	06I	PM	10132018	2	Adult	Black		Black+		Ground Plane	FALSE	Bushes	0	1	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9701010964667 40.76889193145081)
1270	1270	-73.967762162893	40.7823359027165	20C-PM-1018-08	20C	PM	10182018	8	Juvenile	Cinnamon		Cinnamon+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	1	0	1	runs from (dog)	POINT (-73.967762162893 40.7823359027165)
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)
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)
1278	1278	-73.9729848996456	40.770714329426106	7F-AM-1008-11	07F	AM	10082018	11	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9729848996456 40.7707143294261)
1279	1279	-73.95121209494779	40.7947945266515	39I-PM-1013-01	39I	PM	10132018	1	Adult	Gray		Gray+		Ground Plane	FALSE	along the road	0	0	0	1	0	digging	0	0	0	0	0	0	0	0		POINT (-73.9512120949478 40.7947945266515)
1280	1280	-73.9562469727195	40.79685907654	39D-AM-1008-04	39D	AM	10082018	4	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9562469727195 40.79685907654)
1288	1288	-73.97304542959971	40.77029094543921	7F-AM-1008-05	07F	AM	10082018	5	Adult	Gray		Gray+		Ground Plane	FALSE	bush	0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9730454295997 40.7702909454392)
1291	1291	-73.96859351775	40.7735537139641	11H-PM-1013-03	11H	PM	10132018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0	planting nut	0	0	0	0	0	0	1	0		POINT (-73.96859351775 40.7735537139641)
1294	1294	-73.9604089940153	40.7910028063138	32D-AM-1013-04	32D	AM	10132018	4	Adult	Cinnamon		Cinnamon+	Brown legs	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1	1	0	1		POINT (-73.9604089940153 40.7910028063138)
1301	1301	-73.95521466657141	40.7892909102377	32I-PM-1007-03	32I	PM	10072018	3	Adult	Gray		Gray+	small adult	Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9552146665714 40.7892909102377)
1304	1304	-73.9533319519277	40.7933647909449	37H-AM-1018-02	37H	AM	10182018	2	Adult	Gray		Gray+		Above Ground		Large tree by (fence of the conservatory) about to climb up	0	0	1	0	0		0	0	0	0	0	0	0	0	busy,ready to climb	POINT (-73.9533319519277 40.7933647909449)
1307	1307	-73.9565197137317	40.7986011403785	41C-PM-1007-01	41C	PM	10072018	1	Adult	Black		Black+		Ground Plane	FALSE		1	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.9565197137317 40.7986011403785)
1313	1313	-73.9671813866177	40.783864003203796	22C-PM-1006-04	22C	PM	10062018	4	Juvenile	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9671813866177 40.7838640032038)
1314	1314	-73.980919134781	40.7683772453336	1A-PM-1014-06	01A	PM	10142018	6	Juvenile	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		1	0	0	0	0	0	0	1		POINT (-73.980919134781 40.7683772453336)
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)
1323	1323	-73.97443873476259	40.7776953143835	13A-AM-1017-03	13A	AM	10172018	3	Adult	Cinnamon		Cinnamon+					0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9744387347626 40.7776953143835)
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)
1348	1348	-73.95991976123891	40.7954836456006	36B-PM-1013-05	36B	PM	10132018	5	Adult	Gray		Gray+		Above Ground	4		1	0	0	0	0		0	0	0	0	0	0	0	1		POINT (-73.9599197612389 40.7954836456006)
1355	1355	-73.9655277320465	40.780612052936895	20F-AM-1014-03	20F	AM	10142018	3	Adult	Gray		Gray+		Above Ground	30		0	0	1	0	0		1	0	0	0	0	0	0	0		POINT (-73.9655277320465 40.7806120529369)
1357	1357	-73.96313500206341	40.791907210332	32B-PM-1010-01	32B	PM	10102018	1	Juvenile	Gray		Gray+		Above Ground	25	in tree	0	0	1	0	0		0	0	0	0	1	0	0	1		POINT (-73.9631350020634 40.791907210332)
1361	1361	-73.961934398055	40.79247895485221	33B-PM-1010-07	33B	PM	10102018	7	Adult			+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	1		POINT (-73.961934398055 40.7924789548522)
1365	1365	-73.9791648157033	40.767625444347	2C-AM-1010-04	02C	AM	10102018	4	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9791648157033 40.767625444347)
1369	1369	-73.97027172608291	40.768951107763	6I-PM-1013-03	06I	PM	10132018	3	Adult	Cinnamon		Cinnamon+		Ground Plane	FALSE	Flowers, grass	0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9702717260829 40.768951107763)
1370	1370	-73.9681627331154	40.7785099665602	17E-PM-1018-02	17E	PM	10182018	2	Adult	Gray		Gray+		Ground Plane	FALSE	On the rock	1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9681627331154 40.7785099665602)
1371	1371	-73.9542733797804	40.795578653743	39F-PM-1006-02	39F	PM	10062018	2	Adult	Gray		Gray+		Above Ground	20	tree	0	0	0	0	0		0	0	0	0	0	0	0	1	ran up tree when approached	POINT (-73.9542733797804 40.795578653743)
1372	1372	-73.95283537022091	40.7976456178263	41F-PM-1019-02	41F	PM	10192018	2				+					0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9528353702209 40.7976456178263)
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)
1378	1378	-73.9669762657479	40.7835913293646	22C-PM-1006-08	22C	PM	10062018	8	Adult	Gray		Gray+		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9669762657479 40.7835913293646)
1383	1383	-73.96767327256721	40.7763194425467	15G-PM-1019-09	15G	PM	10192018	9	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9676732725672 40.7763194425467)
1388	1388	-73.9685709455958	40.774487702650596	12G-PM-1007-07	12G	PM	10072018	7	Juvenile			+		Above Ground	45		0	0	0	1	0	acorns	0	0	0	0	0	0	0	0		POINT (-73.9685709455958 40.7744877026506)
1390	1390	-73.9677146741772	40.77882313323371	17E-AM-1017-07	17E	AM	10172018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9677146741772 40.7788231332337)
1398	1398	-73.9602808042376	40.7906130788763	32E-AM-1007-14	32E	AM	10072018	14	Adult	Gray		Gray+		Above Ground	50	literally fell to ground from 50 feet up	0	0	0	0	0	falling	0	0	0	0	0	0	0	1		POINT (-73.9602808042376 40.7906130788763)
1402	1402	-73.9745009906157	40.7741574075364	10C-AM-1018-01	10C	AM	10182018	1	Adult	Gray		Gray+		Above Ground	5		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9745009906157 40.7741574075364)
1406	1406	-73.97462048022209	40.769929484073295	6E-PM-1010-01	06E	PM	10102018	1	Juvenile			+		Ground Plane	FALSE	along dirt path by cross-town car road. saw movement in a shrub/then caught sight a little fluffy tail	0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9746204802221 40.7699294840733)

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