This data as json, CSV (advanced)
Suggested facets: Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Moans, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Zip Codes, Community Districts, City Council Districts, Police Precincts
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 | Zip Codes | Community Districts | Borough Boundaries | City Council Districts | Police Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19 | 19 | -73.9768603630674 | 40.7702795904962 | 5C-PM-1010-09 | 05C | PM | 10102018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9768603630674 40.7702795904962) | 19 | 4 | 19 | 13 | |||||
42 | 42 | -73.9579564338627 | 40.7959337795027 | 38C-PM-1014-09 | 38C | PM | 10142018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9579564338627 40.7959337795027) | 19 | 4 | 19 | 13 | ||||||
74 | 74 | -73.9546654184146 | 40.7947639241491 | 38G-PM-1020-09 | 38G | PM | 10202018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | true | false | false | true | false | POINT (-73.9546654184146 40.7947639241491) | 19 | 4 | 19 | 13 | |||||
141 | 141 | -73.9590992841423 | 40.793758098573 | 35D-PM-1013-09 | 35D | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9590992841423 40.793758098573) | 19 | 4 | 19 | 13 | |||||
298 | 298 | -73.957342596188 | 40.7944359654227 | 37E-PM-1006-09 | 37E | PM | 10062018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | false | moseying | false | false | false | false | true | true | false | false | POINT (-73.957342596188 40.7944359654227) | 19 | 4 | 19 | 13 | ||||
314 | 314 | -73.960601067176 | 40.7917243850136 | 32D-PM-1006-09 | 32D | PM | 10062018 | 9 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | true | false | false | POINT (-73.960601067176 40.7917243850136) | 19 | 4 | 19 | 13 | |||||
320 | 320 | -73.9684376038582 | 40.7824275067237 | 20C-PM-1018-09 | 20C | PM | 10182018 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9684376038582 40.7824275067237) | 19 | 4 | 19 | 13 | ||||||
348 | 348 | -73.9542990150586 | 40.7940915300678 | 37G-PM-1007-09 | 37G | PM | 10072018 | 9 | Adult | Cinnamon | White | Cinnamon+White | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9542990150586 40.7940915300678) | 19 | 4 | 19 | 13 | |||||||
411 | 411 | -73.9669366401071 | 40.7836023897982 | 22C-PM-1006-09 | 22C | PM | 10062018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.96693664010711 40.7836023897982) | 19 | 4 | 19 | 13 | ||||||
444 | 444 | -73.9641462360541 | 40.7778316005464 | 18I-PM-1007-09 | 18I | PM | 10072018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | true | false | false | canoodling w/ 8 | false | false | false | false | false | false | true | false | POINT (-73.9641462360541 40.7778316005464) | 19 | 4 | 19 | 13 | ||||
546 | 546 | -73.9547423290276 | 40.7899702628835 | 33I-PM-1006-09 | 33I | PM | 10062018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9547423290276 40.7899702628835) | 19 | 4 | 19 | 13 | ||||||
556 | 556 | -73.9721670042434 | 40.776085913838 | 13D-PM-1018-09 | 13D | PM | 10182018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9721670042434 40.776085913838) | 19 | 4 | 19 | 13 | |||||
609 | 609 | -73.9698762023146 | 40.7782055688113 | 16D-PM-1010-09 | 16D | PM | 10102018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | true | false | false | false | false | false | true | false | POINT (-73.9698762023146 40.77820556881131) | 19 | 4 | 19 | 13 | ||||||
611 | 611 | -73.9679399097382 | 40.7742813149957 | 13H-PM-1010-09 | 13H | PM | 10102018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.96793990973822 40.7742813149957) | 19 | 4 | 19 | 13 | ||||||
658 | 658 | -73.9704575848926 | 40.7693499326095 | 7H-PM-1006-09 | 07H | PM | 10062018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | by tree | false | false | false | true | true | false | false | false | true | false | true | false | true | POINT (-73.9704575848926 40.7693499326095) | 19 | 4 | 19 | 13 | |||||
794 | 794 | -73.9790010565108 | 40.7685732369544 | 2C-PM-1013-09 | 02C | PM | 10132018 | 9 | Adult | + | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9790010565108 40.7685732369544) | 19 | 4 | 19 | 13 | |||||||
803 | 803 | -73.9697983725608 | 40.7700677022205 | 8I-PM-1013-09 | 08I | PM | 10132018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9697983725608 40.7700677022205) | 19 | 4 | 19 | 13 | |||||
809 | 809 | -73.9633250636501 | 40.7922155082679 | 32A-PM-1013-09 | 32A | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9633250636501 40.7922155082679) | 19 | 4 | 19 | 13 | |||||
946 | 946 | -73.9654093844049 | 40.7806896368469 | 20F-PM-1007-09 | 20F | PM | 10072018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | false | POINT (-73.9654093844049 40.7806896368469) | 19 | 4 | 19 | 13 | |||||
949 | 949 | -73.9701596268736 | 40.7702106607329 | 8H-PM-1014-09 | 08H | PM | 10142018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9701596268736 40.7702106607329) | 19 | 4 | 19 | 13 | |||||
970 | 970 | -73.97035767623 | 40.7714036487747 | 9H-PM-1018-09 | 09H | PM | 10182018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.97035767623 40.7714036487747) | 19 | 4 | 19 | 13 | ||||||
979 | 979 | -73.9612349421547 | 40.7959586475744 | 36A-PM-1013-09 | 36A | PM | 10132018 | 9 | Gray | Gray+ | Ground Plane | FALSE | THICK UNDERGROWTH | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9612349421547 40.7959586475744) | 19 | 4 | 19 | 13 | ||||||
1030 | 1030 | -73.9697526733133 | 40.7759529849808 | 13E-PM-1008-09 | 13E | PM | 10082018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9697526733133 40.7759529849808) | 19 | 4 | 19 | 13 | |||||
1175 | 1175 | -73.9803282698463 | 40.7680809889384 | 1B-PM-1019-09 | 01B | PM | 10192018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Tree to ground | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9803282698463 40.7680809889384) | 19 | 4 | 19 | 13 | ||||
1197 | 1197 | -73.9590868748584 | 40.7906047630418 | 32E-PM-1017-09 | 32E | PM | 10172018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9590868748584 40.7906047630418) | 19 | 4 | 19 | 13 | |||||
1221 | 1221 | -73.9796409671481 | 40.7679049871186 | 1C-PM-1013-09 | 01C | PM | 10132018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9796409671481 40.7679049871186) | 19 | 4 | 19 | 13 | |||||
1232 | 1232 | -73.9589254878322 | 40.7914467650712 | 33E-PM-1012-09 | 33E | PM | 10122018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9589254878322 40.7914467650712) | 19 | 4 | 19 | 13 | ||||||
1240 | 1240 | -73.9696119179789 | 40.7802926111865 | 18C-PM-1018-09 | 18C | PM | 10182018 | 9 | Juvenile | Gray | Gray+ | Above Ground | 5 | false | false | true | true | true | false | false | false | false | false | false | false | false | POINT (-73.9696119179789 40.7802926111865) | 19 | 4 | 19 | 13 | ||||||
1277 | 1277 | -73.9619609976132 | 40.7922824443528 | 33B-PM-1010-09 | 33B | PM | 10102018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9619609976132 40.7922824443528) | 19 | 4 | 19 | 13 | ||||||
1293 | 1293 | -73.9775465365348 | 40.7681943707876 | 3D-PM-1010-09 | 03D | PM | 10102018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9775465365348 40.7681943707876) | 19 | 4 | 19 | 13 | ||||||
1383 | 1383 | -73.9676732725672 | 40.7763194425467 | 15G-PM-1019-09 | 15G | PM | 10192018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9676732725672 40.7763194425467) | 19 | 4 | 19 | 13 | ||||||
1479 | 1479 | -73.9707498430394 | 40.7723724480959 | 10G-PM-1017-09 | 10G | PM | 10172018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9707498430394 40.7723724480959) | 19 | 4 | 19 | 13 | ||||||
1605 | 1605 | -73.9690362384597 | 40.7767162824413 | 14F-PM-1012-09 | 14F | PM | 10122018 | 9 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9690362384597 40.7767162824413) | 19 | 4 | 19 | 13 | |||||
1622 | 1622 | -73.9615090149261 | 40.7945150173918 | 35A-PM-1013-09 | 35A | PM | 10132018 | 9 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9615090149261 40.7945150173918) | 19 | 4 | 19 | 13 | ||||||
1651 | 1651 | -73.9763373510536 | 40.7741168933928 | 9B-PM-1013-09 | 09B | PM | 10132018 | 9 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | runs from (people) | POINT (-73.9763373510536 40.7741168933928) | 19 | 4 | 19 | 13 | |||||
1733 | 1733 | -73.9756345867747 | 40.7675540517649 | 3E-PM-1008-09 | 03E | PM | 10082018 | 9 | Adult | Gray | Gray+ | Above Ground | 5 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9756345867747 40.7675540517649) | 19 | 4 | 19 | 13 | ||||||
1850 | 1850 | -73.975809362521 | 40.7734702737835 | 8B-PM-1012-09 | 08B | PM | 10122018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.975809362521 40.7734702737835) | 19 | 4 | 19 | 13 | |||||
1893 | 1893 | -73.9708108312271 | 40.7773975776146 | 14D-PM-1019-09 | 14D | PM | 10192018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9708108312271 40.7773975776146) | 19 | 4 | 19 | 13 | |||||
1915 | 1915 | -73.9797112925048 | 40.7688046778472 | 2B-PM-1013-09 | 02B | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Above Ground | 30 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9797112925048 40.7688046778472) | 19 | 4 | 19 | 13 | |||||
2031 | 2031 | -73.9795454787631 | 40.7688026892741 | 3B-PM-1007-09 | 03B | PM | 10072018 | 9 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9795454787631 40.7688026892741) | 19 | 4 | 19 | 13 | |||||||||
2160 | 2160 | -73.975028559002 | 40.7667307335544 | 2F-PM-1014-09 | 02F | PM | 10142018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.975028559002 40.7667307335544) | 19 | 4 | 19 | 13 | |||||
2171 | 2171 | -73.9686370726471 | 40.7780382348833 | 16E-PM-1018-09 | 16E | PM | 10182018 | 9 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 3 | On trunk | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9686370726471 40.7780382348833) | 19 | 4 | 19 | 13 | ||||
2299 | 2299 | -73.9605554843228 | 40.7901473714024 | 31E-PM-1006-09 | 31E | PM | 10062018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9605554843228 40.7901473714024) | 19 | 4 | 19 | 13 | |||||
2384 | 2384 | -73.9708564226824 | 40.7726219968014 | 10F-PM-1019-09 | 10F | PM | 10192018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Across Arbor path into hill w/ bushes | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9708564226824 40.7726219968014) | 19 | 4 | 19 | 13 | ||||
2484 | 2484 | -73.9619786450142 | 40.7919876274548 | 32C-PM-1013-09 | 32C | PM | 10132018 | 9 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9619786450142 40.7919876274548) | 19 | 4 | 19 | 13 | ||||||
2556 | 2556 | -73.9639828431368 | 40.7910151996207 | 30B-PM-1019-09 | 30B | PM | 10192018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9639828431368 40.7910151996207) | 19 | 4 | 19 | 13 | |||||
2625 | 2625 | -73.9699188544459 | 40.7772180370053 | 15E-PM-1008-09 | 15E | PM | 10082018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9699188544459 40.7772180370053) | 19 | 4 | 19 | 13 | ||||||
2633 | 2633 | -73.9776151109912 | 40.7694681558386 | 4C-PM-1010-09 | 04C | PM | 10102018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9776151109912 40.7694681558386) | 19 | 4 | 19 | 13 | |||||
2708 | 2708 | -73.9528429238071 | 40.7922651848867 | 36I-PM-1007-09 | 36I | PM | 10072018 | 9 | Juvenile | Gray | Gray+ | Above Ground | 5 | true | true | false | false | false | burying nut | false | false | false | false | true | false | false | false | POINT (-73.9528429238071 40.7922651848867) | 19 | 4 | 19 | 13 | |||||
2787 | 2787 | -73.9765306970303 | 40.7694956875859 | 4D-PM-1008-09 | 04D | PM | 10082018 | 9 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9765306970303 40.7694956875859) | 19 | 4 | 19 | 13 | |||||||
2978 | 2978 | -73.9688817006443 | 40.7829120321438 | 20B-PM-1013-09 | 20B | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9688817006443 40.7829120321438) | 19 | 4 | 19 | 13 | |||||
3003 | 3003 | -73.9698663926657 | 40.773999710413 | 12F-PM-1007-09 | 12F | PM | 10072018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9698663926657 40.773999710413) | 19 | 4 | 19 | 13 | |||||
235 | 235 | -73.9753574279936 | 40.7683211694257 | 4E-PM-1008-08 | 04E | PM | 10082018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9753574279936 40.7683211694257) | 19 | 4 | 19 | 13 | ||||||
274 | 274 | -73.9639832886071 | 40.7909532437095 | 30B-PM-1019-08 | 30B | PM | 10192018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.9639832886071 40.7909532437095) | 19 | 4 | 19 | 13 | |||||
303 | 303 | -73.9762348224648 | 40.7694522315322 | 4D-PM-1008-08 | 04D | PM | 10082018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | true | true | true | climbed fence staring at me - went up tree | false | false | false | false | false | false | false | true | POINT (-73.97623482246482 40.7694522315322) | 19 | 4 | 19 | 13 | ||||
305 | 305 | -73.9750283794865 | 40.7724101927821 | 8C-PM-1013-08 | 08C | PM | 10132018 | 8 | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9750283794865 40.7724101927821) | 19 | 4 | 19 | 13 | ||||||
389 | 389 | -73.9733966282316 | 40.7717179627127 | 8E-PM-1008-08 | 08E | PM | 10082018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9733966282316 40.7717179627127) | 19 | 4 | 19 | 13 | |||||
424 | 424 | -73.9756557086441 | 40.773296289824 | 8B-PM-1012-08 | 08B | PM | 10122018 | 8 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9756557086441 40.773296289824) | 19 | 4 | 19 | 13 | |||||
430 | 430 | -73.9710116801402 | 40.7723689301989 | 10G-PM-1017-08 | 10G | PM | 10172018 | 8 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9710116801402 40.7723689301989) | 19 | 4 | 19 | 13 | |||||
443 | 443 | -73.9720887275538 | 40.7760799537976 | 13D-PM-1018-08 | 13D | PM | 10182018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9720887275538 40.7760799537976) | 19 | 4 | 19 | 13 | ||||
526 | 526 | -73.9680833729772 | 40.7741871025115 | 12H-PM-1007-08 | 12H | PM | 10072018 | 8 | + | Above Ground | 7 | in tree | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9680833729772 40.7741871025115) | 19 | 4 | 19 | 13 | |||||||
564 | 564 | -73.9570086212285 | 40.7946679755816 | 37E-PM-1006-08 | 37E | PM | 10062018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.95700862122851 40.7946679755816) | 19 | 4 | 19 | 13 | ||||||
586 | 586 | -73.9789126088606 | 40.7685079149692 | 2C-PM-1013-08 | 02C | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | true | false | false | POINT (-73.9789126088606 40.7685079149692) | 19 | 4 | 19 | 13 | |||||
677 | 677 | -73.9799155966086 | 40.7698034314993 | 3A-PM-1017-08 | 03A | PM | 10172018 | 8 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9799155966086 40.7698034314993) | 19 | 4 | 19 | 13 | |||||
691 | 691 | -73.9695964983454 | 40.7802302192799 | 18C-PM-1018-08 | 18C | PM | 10182018 | 8 | Juvenile | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9695964983454 40.7802302192799) | 19 | 4 | 19 | 13 | ||||||
717 | 717 | -73.9574749571848 | 40.7981898890735 | 40C-PM-1006-08 | 40C | PM | 10062018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | By the main road | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9574749571848 40.7981898890735) | 19 | 4 | 19 | 13 | |||||
839 | 839 | -73.9615602805554 | 40.7945662185621 | 35A-PM-1013-08 | 35A | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9615602805554 40.7945662185621) | 19 | 4 | 19 | 13 | |||||
885 | 885 | -73.9750463844984 | 40.7666871742836 | 2F-PM-1014-08 | 02F | PM | 10142018 | 8 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9750463844984 40.7666871742836) | 19 | 4 | 19 | 13 | |||||
902 | 902 | -73.969105907 | 40.7820474909192 | 20B-PM-1013-08 | 20B | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | (very brown) | Ground Plane | FALSE | true | false | false | false | false | being chased by dog | false | false | false | false | false | false | false | true | POINT (-73.969105907 40.7820474909192) | 19 | 4 | 19 | 13 | |||
924 | 924 | -73.9591695545875 | 40.7938116360767 | 35D-PM-1013-08 | 35D | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9591695545875 40.7938116360767) | 19 | 4 | 19 | 13 | |||||
955 | 955 | -73.960657061561 | 40.7956150744102 | 36A-PM-1013-08 | 36A | PM | 10132018 | 8 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | true | false | false | false | false | running from #7 | false | false | false | false | false | false | false | true | POINT (-73.960657061561 40.7956150744102) | 19 | 4 | 19 | 13 | |||||
956 | 956 | -73.9581173730857 | 40.7954772170549 | 37D-PM-1014-08 | 37D | PM | 10142018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9581173730857 40.7954772170549) | 19 | 4 | 19 | 13 | |||||
957 | 957 | -73.9586527721822 | 40.7908831110561 | 32F-PM-1008-08 | 32F | PM | 10082018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9586527721822 40.7908831110561) | 19 | 4 | 19 | 13 | |||||
1037 | 1037 | -73.9677409841969 | 40.7763579140639 | 15G-PM-1019-08 | 15G | PM | 10192018 | 8 | Adult | + | Above Ground | 5 | false | true | false | false | false | false | true | true | false | false | false | false | false | POINT (-73.9677409841969 40.7763579140639) | 19 | 4 | 19 | 13 | |||||||
1060 | 1060 | -73.9728871061191 | 40.7712983658944 | 8F-PM-1012-08 | 08F | PM | 10122018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9728871061191 40.7712983658944) | 19 | 4 | 19 | 13 | |||||
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 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9595485734618 40.7835326425693) | 19 | 4 | 19 | 13 | ||||||
1084 | 1084 | -73.9698839750249 | 40.7781433076692 | 16D-PM-1010-08 | 16D | PM | 10102018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | true | false | false | false | false | false | true | false | POINT (-73.9698839750249 40.7781433076692) | 19 | 4 | 19 | 13 | ||||||
1106 | 1106 | -73.9702970919317 | 40.7696883113413 | 7H-PM-1006-08 | 07H | PM | 10062018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | in grass | false | false | false | false | true | false | false | false | false | true | true | false | true | POINT (-73.9702970919317 40.7696883113413) | 19 | 4 | 19 | 13 | ||||
1125 | 1125 | -73.9775735077285 | 40.7692872082165 | 4C-PM-1010-08 | 04C | PM | 10102018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | on stone arch | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9775735077285 40.7692872082165) | 19 | 4 | 19 | 13 | ||||
1198 | 1198 | -73.9762187733662 | 40.7739282973004 | 9B-PM-1013-08 | 09B | PM | 10132018 | 8 | Juvenile | Cinnamon | Black, White | Cinnamon+Black, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9762187733662 40.7739282973004) | 19 | 4 | 19 | 13 | |||||
1199 | 1199 | -73.9756993198381 | 40.7681956641913 | 3E-PM-1008-08 | 03E | PM | 10082018 | 8 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9756993198381 40.7681956641913) | 19 | 4 | 19 | 13 | ||||||
1234 | 1234 | -73.9701412231078 | 40.7714534088899 | 9H-PM-1018-08 | 09H | PM | 10182018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9701412231078 40.7714534088899) | 19 | 4 | 19 | 13 | ||||||
1270 | 1270 | -73.967762162893 | 40.7823359027165 | 20C-PM-1018-08 | 20C | PM | 10182018 | 8 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | true | runs from (dog) | POINT (-73.967762162893 40.7823359027165) | 19 | 4 | 19 | 13 | |||||
1300 | 1300 | -73.964280573021 | 40.777830911491 | 18I-PM-1007-08 | 18I | PM | 10072018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | true | true | false | false | canoodling w/ #9 | false | false | false | false | false | false | true | false | POINT (-73.964280573021 40.777830911491) | 19 | 4 | 19 | 13 | ||||
1339 | 1339 | -73.9686413326172 | 40.7817423907284 | 19C-PM-1018-08 | 19C | PM | 10182018 | 8 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray, Cinnamon & White selected as Primary. Gray & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9686413326172 40.7817423907284) | 19 | 4 | 19 | 13 | ||||
1378 | 1378 | -73.9669762657479 | 40.7835913293646 | 22C-PM-1006-08 | 22C | PM | 10062018 | 8 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9669762657479 40.7835913293646) | 19 | 4 | 19 | 13 | ||||||
1379 | 1379 | -73.9796470494747 | 40.7678370925485 | 1C-PM-1013-08 | 01C | PM | 10132018 | 8 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9796470494747 40.7678370925485) | 19 | 4 | 19 | 13 | ||||||
1404 | 1404 | -73.9700666654946 | 40.7742857042581 | 12F-PM-1007-08 | 12F | PM | 10072018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | stared | POINT (-73.9700666654946 40.7742857042581) | 19 | 4 | 19 | 13 | ||||
1514 | 1514 | -73.9548006161673 | 40.7945503341011 | 38G-PM-1020-08 | 38G | PM | 10202018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | true | false | false | true | false | false | true | false | POINT (-73.9548006161673 40.7945503341011) | 19 | 4 | 19 | 13 | |||||
1527 | 1527 | -73.970216605149 | 40.7702960667277 | 8H-PM-1014-08 | 08H | PM | 10142018 | 8 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | chasing (#7),playing? | false | false | false | false | false | false | true | false | POINT (-73.970216605149 40.7702960667277) | 19 | 4 | 19 | 13 | |||||
1532 | 1532 | -73.9779263114572 | 40.7682681855369 | 3D-PM-1010-08 | 03D | PM | 10102018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9779263114572 40.7682681855369) | 19 | 4 | 19 | 13 | |||||
1559 | 1559 | -73.9631648674122 | 40.7926529617419 | 32A-PM-1013-08 | 32A | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9631648674122 40.7926529617419) | 19 | 4 | 19 | 13 | |||||
1577 | 1577 | -73.965390623703 | 40.7807731363782 | 20F-PM-1007-08 | 20F | PM | 10072018 | 8 | Adult | Cinnamon | White | Cinnamon+White | white tail/belly | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.965390623703 40.7807731363782) | 19 | 4 | 19 | 13 | ||||
1582 | 1582 | -73.9804065254162 | 40.7681481183296 | 1B-PM-1019-08 | 01B | PM | 10192018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9804065254162 40.7681481183296) | 19 | 4 | 19 | 13 | |||||
1645 | 1645 | -73.9619673317128 | 40.7924176673037 | 33B-PM-1010-08 | 33B | PM | 10102018 | 8 | Juvenile | Gray | Gray+ | Above Ground | running up tree | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9619673317128 40.7924176673037) | 19 | 4 | 19 | 13 | ||||||
1647 | 1647 | -73.9795585338537 | 40.768895893226 | 3B-PM-1007-08 | 03B | PM | 10072018 | 8 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9795585338537 40.768895893226) | 19 | 4 | 19 | 13 | ||||||
1757 | 1757 | -73.9601561064548 | 40.7900513933531 | 31E-PM-1006-08 | 31E | PM | 10062018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9601561064548 40.7900513933531) | 19 | 4 | 19 | 13 | |||||
1761 | 1761 | -73.9575307970434 | 40.7983176419483 | 40B-PM-1014-08 | 40B | PM | 10142018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9575307970434 40.7983176419483) | 19 | 4 | 19 | 13 | |||||
1772 | 1772 | -73.9690540696008 | 40.7766014124609 | 14F-PM-1012-08 | 14F | PM | 10122018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | true | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9690540696008 40.7766014124609) | 19 | 4 | 19 | 13 | |||||
1820 | 1820 | -73.9546337446865 | 40.7898772579576 | 33I-PM-1006-08 | 33I | PM | 10062018 | 8 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9546337446865 40.7898772579576) | 19 | 4 | 19 | 13 |
JSON shape: default, array, newline-delimited
CREATE TABLE squirrels( "Longitude" TEXT, "Latitude" TEXT, "Unique Squirrel ID" TEXT, "Hectare" TEXT, "Shift" TEXT, "Date" TEXT, "Hectare Squirrel Number" TEXT, "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" TEXT, "Chasing" TEXT, "Climbing" TEXT, "Eating" TEXT, "Foraging" TEXT, "Other Activities" TEXT, "Kuks" TEXT, "Quaas" TEXT, "Moans" TEXT, "Tail flags" TEXT, "Tail twitches" TEXT, "Approaches" TEXT, "Indifferent" TEXT, "Runs from" TEXT, "Other Interactions" TEXT, "Lat/Long" TEXT, "Zip Codes" TEXT, "Community Districts" TEXT, "Borough Boundaries" TEXT, "City Council Districts" TEXT, "Police Precincts" TEXT );