This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1766 | 1766 | -73.972757765574 | 40.7654285510067 | 2I-AM-1006-01 | 02I | AM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.972757765574 40.7654285510067) | 19 | 4 | 19 | 13 | ||||||
2136 | 2136 | -73.9721897915211 | 40.7660434203132 | 3I-AM-1010-02 | 03I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9721897915211 40.76604342031321) | 19 | 4 | 19 | 13 | ||||||
2914 | 2914 | -73.9722053355548 | 40.7662094993614 | 3I-AM-1010-03 | 03I | AM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 50 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9722053355548 40.7662094993614) | 19 | 4 | 19 | 13 | ||||||
2570 | 2570 | -73.9721064150173 | 40.7667053821991 | 3I-AM-1010-01 | 03I | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9721064150173 40.7667053821991) | 19 | 4 | 19 | 13 | ||||||
1682 | 1682 | -73.9759258407288 | 40.7667622711142 | 2F-PM-1014-05 | 02F | PM | 10142018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9759258407288 40.7667622711142) | 19 | 4 | 19 | 13 | ||||||
1427 | 1427 | -73.9755321998542 | 40.7668311576007 | 2F-PM-1014-01 | 02F | PM | 10142018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.97553219985421 40.7668311576007) | 19 | 4 | 19 | 13 | ||||||
535 | 535 | -73.9772396728545 | 40.7668696411765 | 2E-AM-1010-02 | 02E | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | totally indifferent | POINT (-73.9772396728545 40.7668696411765) | 19 | 4 | 19 | 13 | |||||
2070 | 2070 | -73.9725700261894 | 40.7668793330427 | 3H-PM-1014-01 | 03H | PM | 10142018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | under a parked car | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9725700261894 40.7668793330427) | 19 | 4 | 19 | 13 | |||||
974 | 974 | -73.9753744539307 | 40.7671162211032 | 2F-PM-1014-12 | 02F | PM | 10142018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.97537445393071 40.7671162211032) | 19 | 4 | 19 | 13 | ||||||
1715 | 1715 | -73.9745709109056 | 40.7672225695415 | 3G-AM-1008-03 | 03G | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 40 | true | false | true | false | false | in tree | false | false | false | false | false | false | true | false | POINT (-73.9745709109056 40.7672225695415) | 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 | ||||||
1446 | 1446 | -73.9775238847836 | 40.7675792683587 | 2D-AM-1007-05 | 02D | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 100 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9775238847836 40.7675792683587) | 19 | 4 | 19 | 13 | ||||||
671 | 671 | -73.9709244006956 | 40.7676942639697 | 5I-AM-1010-02 | 05I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9709244006956 40.7676942639697) | 19 | 4 | 19 | 13 | ||||||
661 | 661 | -73.9700759073973 | 40.7680560871695 | 5I-AM-1010-01 | 05I | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9700759073973 40.7680560871695) | 10090 | 23 | 4 | 51 | 11 | |||||
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 | ||||||
2734 | 2734 | -73.9763629541474 | 40.7682321897044 | 3E-PM-1008-04 | 03E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 6 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9763629541474 40.7682321897044) | 19 | 4 | 19 | 13 | ||||||
1314 | 1314 | -73.980919134781 | 40.7683772453336 | 1A-PM-1014-06 | 01A | PM | 10142018 | 6 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | true | false | false | false | false | false | false | true | POINT (-73.980919134781 40.7683772453336) | 19 | 4 | 19 | 13 | ||||||
2038 | 2038 | -73.9803562137049 | 40.7685780990634 | 2B-AM-1010-02 | 02B | AM | 10102018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9803562137049 40.7685780990634) | 19 | 4 | 19 | 13 | ||||||
2777 | 2777 | -73.9810843611086 | 40.7687905493699 | 2A-PM-1019-05 | 02A | PM | 10192018 | 5 | ? | Gray | Gray+ | Above Ground | 50 | in tall planetree | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9810843611086 40.7687905493699) | 19 | 4 | 19 | 13 | |||||
1329 | 1329 | -73.9772164524209 | 40.7688399538756 | 3D-AM-1006-06 | 03D | AM | 10062018 | 6 | Gray | Gray+ | Above Ground | 10 | tree | true | false | true | false | false | false | false | false | false | false | false | false | false | did not run from humans,but ran straight to tree & climbed up | POINT (-73.9772164524209 40.7688399538756) | 19 | 4 | 19 | 13 | |||||
2385 | 2385 | -73.9787552947847 | 40.7690779628762 | 3B-AM-1010-06 | 03B | AM | 10102018 | 6 | Adult | Gray | Gray+ | Above Ground | 20 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9787552947847 40.7690779628762) | 19 | 4 | 19 | 13 | ||||||
2861 | 2861 | -73.9720102361126 | 40.7692143930301 | 6G-PM-1020-01 | 06G | PM | 10202018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9720102361126 40.7692143930301) | 19 | 4 | 19 | 13 | ||||||
336 | 336 | -73.9757413215621 | 40.7692582758978 | 4E-PM-1008-04 | 04E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9757413215621 40.7692582758978) | 19 | 4 | 19 | 13 | ||||||
1000 | 1000 | -73.9805137046778 | 40.769275143797 | 2A-AM-1010-08 | 02A | AM | 10102018 | 8 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9805137046778 40.769275143797) | 19 | 4 | 19 | 13 | |||||
7 | 7 | -73.9719735582476 | 40.7693045133578 | 6G-PM-1020-02 | 06G | PM | 10202018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9719735582476 40.7693045133578) | 19 | 4 | 19 | 13 | ||||||
262 | 262 | -73.9712876234172 | 40.7695885530701 | 7H-PM-1006-02 | 07H | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 25 | tree | true | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9712876234172 40.7695885530701) | 19 | 4 | 19 | 13 | |||||
2640 | 2640 | -73.9788304714091 | 40.7696373635315 | 4B-AM-1010-06 | 04B | AM | 10102018 | 6 | Adult | Gray | Gray+ | Above Ground | 12 | true | false | false | false | false | running from squirrel #5 | false | false | false | false | false | false | false | false | POINT (-73.9788304714091 40.7696373635315) | 19 | 4 | 19 | 13 | |||||
152 | 152 | -73.9755133710665 | 40.7697883435981 | 5E-AM-1008-08 | 05E | AM | 10082018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9755133710665 40.7697883435981) | 19 | 4 | 19 | 13 | ||||||
1575 | 1575 | -73.9703169373939 | 40.7700658823854 | 7H-AM-1006-13 | 07H | AM | 10062018 | 13 | Adult | Gray | Gray+ | Above Ground | 10 | true | false | false | false | false | running (up tree) | false | false | false | false | false | false | true | false | POINT (-73.9703169373939 40.7700658823854) | 19 | 4 | 19 | 13 | |||||
569 | 569 | -73.9709040623777 | 40.7701163892686 | 7H-PM-1006-03 | 07H | PM | 10062018 | 3 | Adult | Gray | Gray+ | Above Ground | 8 | tree | true | false | true | false | false | false | false | false | true | false | false | true | false | POINT (-73.9709040623777 40.7701163892686) | 19 | 4 | 19 | 13 | |||||
110 | 110 | -73.9711318790279 | 40.7701941550273 | 7G-AM-1010-02 | 07G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9711318790279 40.7701941550273) | 19 | 4 | 19 | 13 | ||||||
903 | 903 | -73.9719941577406 | 40.77037129313 | 7G-AM-1010-04 | 07G | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9719941577406 40.77037129313) | 19 | 4 | 19 | 13 | ||||||
142 | 142 | -73.9724063986771 | 40.7705711897977 | 7F-PM-1012-01 | 07F | PM | 10122018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9724063986771 40.7705711897977) | 19 | 4 | 19 | 13 | ||||||
1599 | 1599 | -73.9782603348665 | 40.7705790257951 | 5B-PM-1013-06 | 05B | PM | 10132018 | 6 | Adult | Gray | Gray+ | Above Ground | 5 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9782603348665 40.7705790257951) | 19 | 4 | 19 | 13 | ||||||
1278 | 1278 | -73.9729848996456 | 40.7707143294261 | 7F-AM-1008-11 | 07F | AM | 10082018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9729848996456 40.7707143294261) | 19 | 4 | 19 | 13 | ||||||
1602 | 1602 | -73.9728836727349 | 40.770815850599 | 7F-AM-1008-10 | 07F | AM | 10082018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9728836727349 40.770815850599) | 19 | 4 | 19 | 13 | ||||||
1594 | 1594 | -73.9778730762957 | 40.770827251547 | 5B-PM-1013-05 | 05B | PM | 10132018 | 5 | Adult | Gray | Gray+ | Above Ground | 3 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9778730762957 40.770827251547) | 19 | 4 | 19 | 13 | ||||||
2676 | 2676 | -73.9692849074642 | 40.7708755098145 | 9H-PM-1018-06 | 09H | PM | 10182018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9692849074642 40.7708755098145) | 19 | 4 | 19 | 13 | ||||||
2930 | 2930 | -73.9692563597762 | 40.770904999952 | 9H-PM-1018-05 | 09H | PM | 10182018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9692563597762 40.770904999952) | 19 | 4 | 19 | 13 | ||||||
2648 | 2648 | -73.9729410488021 | 40.7709484964577 | 7F-AM-1008-13 | 07F | AM | 10082018 | 13 | Adult | Gray | Gray+ | Above Ground | 4 | to tree | true | false | false | true | true | ran up tree 4 feet and ate leaves | false | false | false | false | false | false | true | false | POINT (-73.9729410488021 40.7709484964577) | 19 | 4 | 19 | 13 | ||||
1470 | 1470 | -73.9724806580638 | 40.7710077206132 | 7F-AM-1008-15 | 07F | AM | 10082018 | 15 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9724806580638 40.7710077206132) | 19 | 4 | 19 | 13 | ||||||
2391 | 2391 | -73.9721497679014 | 40.7716160199386 | 8F-PM-1012-02 | 08F | PM | 10122018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9721497679014 40.7716160199386) | 19 | 4 | 19 | 13 | ||||||
2442 | 2442 | -73.9699369796844 | 40.7720350191273 | 10G-PM-1017-04 | 10G | PM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9699369796844 40.7720350191273) | 19 | 4 | 19 | 13 | ||||||
402 | 402 | -73.9681917366128 | 40.7723298813768 | 11I-PM-1012-03 | 11I | PM | 10122018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | false | false | false | true | runs from the dog | POINT (-73.9681917366128 40.7723298813768) | 19 | 4 | 19 | 13 | |||||
889 | 889 | -73.9681042612938 | 40.772331431865 | 11I-PM-1012-04 | 11I | PM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9681042612938 40.772331431865) | 19 | 4 | 19 | 13 | ||||||
1568 | 1568 | -73.9681079869821 | 40.7723494081345 | 11I-PM-1012-05 | 11I | PM | 10122018 | 5 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9681079869821 40.7723494081345) | 19 | 4 | 19 | 13 | ||||||
1317 | 1317 | -73.9680522379372 | 40.772389813511 | 11I-PM-1012-06 | 11I | PM | 10122018 | 6 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9680522379372 40.772389813511) | 19 | 4 | 19 | 13 | ||||||
2818 | 2818 | -73.9681664642028 | 40.7724669681958 | 11I-PM-1012-02 | 11I | PM | 10122018 | 2 | Adult | Gray | Gray+ | Above Ground | 4 | true | false | true | false | true | false | false | false | false | false | false | false | true | runs away from the ball | POINT (-73.9681664642028 40.7724669681958) | 19 | 4 | 19 | 13 | |||||
757 | 757 | -73.9783185278595 | 40.7724861675504 | 7A-AM-1006-03 | 07A | AM | 10062018 | 3 | Adult | Gray | Gray+ | 3/4 length tail, hair loss | Above Ground | 20 | in trees, then to ground | true | false | true | false | false | jumping | false | false | false | false | false | false | true | false | POINT (-73.9783185278595 40.7724861675504) | 19 | 4 | 19 | 13 | |||
1795 | 1795 | -73.968004352343 | 40.7726669278308 | 11I-PM-1012-01 | 11I | PM | 10122018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | true | false | false | false | true | true | false | false | false | look at humans determining | POINT (-73.968004352343 40.7726669278308) | 19 | 4 | 19 | 13 | |||||
2619 | 2619 | -73.9739737592602 | 40.7727130476777 | 9D-AM-1008-04 | 09D | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9739737592602 40.7727130476777) | 19 | 4 | 19 | 13 | ||||||
1562 | 1562 | -73.974084681071 | 40.7728197139621 | 8D-AM-1007-06 | 08D | AM | 10072018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.974084681071 40.7728197139621) | 19 | 4 | 19 | 13 | ||||||
1065 | 1065 | -73.9769700777377 | 40.7728489574967 | 7B-AM-1008-08 | 07B | AM | 10082018 | 8 | Adult | Gray | Gray+ | Above Ground | 5 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9769700777377 40.7728489574967) | 19 | 4 | 19 | 13 | ||||||
969 | 969 | -73.9773529368499 | 40.7728750685699 | 7B-AM-1008-12 | 07B | AM | 10082018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9773529368499 40.7728750685699) | 19 | 4 | 19 | 13 | ||||||
1612 | 1612 | -73.9746049088475 | 40.7728776887397 | 8C-AM-1007-01 | 08C | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | behind fence, safe | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9746049088475 40.7728776887397) | 19 | 4 | 19 | 13 | |||||
451 | 451 | -73.9753140640445 | 40.7734037805101 | 9C-AM-1006-02 | 09C | AM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9753140640445 40.7734037805101) | 19 | 4 | 19 | 13 | ||||||
406 | 406 | -73.9766354967197 | 40.7734575166319 | 8B-AM-1007-09 | 08B | AM | 10072018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | shelling and eating a nut then a dog chased it up a tree & squirrel carried its nut up the tree,settled in a branch & resumed eating | false | false | false | false | false | false | true | false | POINT (-73.9766354967197 40.7734575166319) | 19 | 4 | 19 | 13 | |||||
2181 | 2181 | -73.9702530172652 | 40.7736241205021 | 11F-AM-1013-01 | 11F | AM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9702530172652 40.7736241205021) | 19 | 4 | 19 | 13 | ||||||
1867 | 1867 | -73.9745204169071 | 40.7736282868469 | 9C-AM-1006-01 | 09C | AM | 10062018 | 1 | Adult | Gray | Gray+ | Above Ground | 40 | Tree | true | false | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9745204169071 40.7736282868469) | 19 | 4 | 19 | 13 | |||||
264 | 264 | -73.9698714743386 | 40.7743814661685 | 12F-AM-1020-02 | 12F | AM | 10202018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9698714743386 40.7743814661685) | 19 | 4 | 19 | 13 | ||||||
2939 | 2939 | -73.9680204438195 | 40.7743882322654 | 13H-PM-1010-08 | 13H | PM | 10102018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9680204438195 40.77438823226541) | 19 | 4 | 19 | 13 | ||||||
434 | 434 | -73.9676639740486 | 40.7745369616499 | 13H-PM-1010-07 | 13H | PM | 10102018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9676639740486 40.7745369616499) | 19 | 4 | 19 | 13 | ||||||
1736 | 1736 | -73.9743873549635 | 40.7745426051392 | 10C-AM-1018-04 | 10C | AM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9743873549635 40.7745426051392) | 19 | 4 | 19 | 13 | ||||||
1794 | 1794 | -73.9757912350482 | 40.7747598621451 | 10B-AM-1006-04 | 10B | AM | 10062018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9757912350482 40.7747598621451) | 19 | 4 | 19 | 13 | ||||||
2246 | 2246 | -73.9711607544742 | 40.774988247642 | 12E-AM-1017-04 | 12E | AM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9711607544742 40.774988247642) | 19 | 4 | 19 | 13 | ||||||
610 | 610 | -73.9671549566066 | 40.7751342870705 | 14H-AM-1007-01 | 14H | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 180 | top of tree | true | false | false | false | false | jumping between branches | false | false | false | false | false | false | true | false | POINT (-73.9671549566066 40.7751342870705) | 19 | 4 | 19 | 13 | ||||
1255 | 1255 | -73.9717469822209 | 40.7753731930704 | 12D-PM-1014-03 | 12D | PM | 10142018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9717469822209 40.7753731930704) | 19 | 4 | 19 | 13 | ||||||
2707 | 2707 | -73.9743165321099 | 40.7754674678574 | 11B-PM-1014-07 | 11B | PM | 10142018 | 7 | Gray | Gray+ | Above Ground | 10 | true | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9743165321099 40.7754674678574) | 19 | 4 | 19 | 13 | |||||||
2630 | 2630 | -73.965019827314 | 40.7759864291323 | 15I-AM-1008-03 | 15I | AM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.965019827314 40.7759864291323) | 19 | 4 | 19 | 13 | ||||||
1962 | 1962 | -73.9647318357023 | 40.7760936175332 | 15I-PM-1012-04 | 15I | PM | 10122018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9647318357023 40.7760936175332) | 19 | 4 | 19 | 13 | ||||||
1706 | 1706 | -73.965215665278 | 40.7761309082202 | 15I-PM-1012-02 | 15I | PM | 10122018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.965215665278 40.7761309082202) | 19 | 4 | 19 | 13 | ||||||
1991 | 1991 | -73.965059909327 | 40.7762131886797 | 15I-PM-1012-06 | 15I | PM | 10122018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.965059909327 40.7762131886797) | 19 | 4 | 19 | 13 | ||||||
1792 | 1792 | -73.9705704527481 | 40.7762853012151 | 13E-AM-1017-06 | 13E | AM | 10172018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9705704527481 40.7762853012151) | 19 | 4 | 19 | 13 | ||||||
1487 | 1487 | -73.965394655961 | 40.7763136791661 | 15I-PM-1012-05 | 15I | PM | 10122018 | 5 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | true | burying the food on ground | false | false | false | false | false | false | false | false | look at us and continue hiding the food | POINT (-73.965394655961 40.7763136791661) | 19 | 4 | 19 | 13 | ||||
2904 | 2904 | -73.9720389756717 | 40.7763524091989 | 13C-PM-1019-02 | 13C | PM | 10192018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.9720389756717 40.7763524091989) | 19 | 4 | 19 | 13 | ||||||
2546 | 2546 | -73.9660267365885 | 40.776444395505 | 16H-AM-1007-01 | 16H | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9660267365885 40.776444395505) | 19 | 4 | 19 | 13 | ||||||
932 | 932 | -73.9718597156773 | 40.7765858763313 | 13C-PM-1019-04 | 13C | PM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9718597156773 40.7765858763313) | 19 | 4 | 19 | 13 | ||||||
1905 | 1905 | -73.9691968748482 | 40.7765862996192 | 14E-AM-1008-14 | 14E | AM | 10082018 | 14 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9691968748482 40.7765862996192) | 19 | 4 | 19 | 13 | ||||||
1040 | 1040 | -73.9702588981432 | 40.776610754288 | 14E-AM-1008-08 | 14E | AM | 10082018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9702588981432 40.776610754288) | 19 | 4 | 19 | 13 | ||||||
84 | 84 | -73.9701824825872 | 40.7766530579293 | 14E-AM-1008-09 | 14E | AM | 10082018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | true | false | false | false | false | false | false | true | POINT (-73.9701824825872 40.7766530579293) | 19 | 4 | 19 | 13 | ||||||
237 | 237 | -73.967895656898 | 40.7767409597341 | 15F-PM-1010-07 | 15F | PM | 10102018 | 7 | Adult | Gray | Gray+ | Above Ground | 3 | on fence | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.967895656898 40.7767409597341) | 19 | 4 | 19 | 13 | |||||
95 | 95 | -73.9692883970928 | 40.7768553703082 | 14E-AM-1008-02 | 14E | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | walking | false | false | false | false | false | false | false | true | POINT (-73.9692883970928 40.7768553703082) | 19 | 4 | 19 | 13 | |||||
888 | 888 | -73.9674177504573 | 40.7769569731993 | 15G-PM-1019-03 | 15G | PM | 10192018 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9674177504573 40.7769569731993) | 19 | 4 | 19 | 13 | ||||||
2318 | 2318 | -73.967458693983 | 40.7769922522105 | 15G-AM-1008-02 | 15G | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.967458693983 40.7769922522105) | 19 | 4 | 19 | 13 | ||||||
2053 | 2053 | -73.9711810222421 | 40.7773445611969 | 14D-PM-1019-05 | 14D | PM | 10192018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9711810222421 40.7773445611969) | 19 | 4 | 19 | 13 | ||||||
749 | 749 | -73.9686304581526 | 40.7773631337117 | 15E-PM-1008-01 | 15E | PM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 4 | on fallen tree | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9686304581526 40.7773631337117) | 19 | 4 | 19 | 13 | |||||
2866 | 2866 | -73.9744025383371 | 40.7777296605765 | 13A-AM-1017-04 | 13A | AM | 10172018 | 4 | Adult | Gray | Gray+ | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9744025383371 40.7777296605765) | 19 | 4 | 19 | 13 | ||||||||
2698 | 2698 | -73.9744917362668 | 40.77783887377 | 13A-AM-1017-02 | 13A | AM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9744917362668 40.77783887377) | 19 | 4 | 19 | 13 | ||||||
1879 | 1879 | -73.9701926736281 | 40.7778587687376 | 15D-AM-1007-02 | 15D | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9701926736281 40.7778587687376) | 19 | 4 | 19 | 13 | ||||||
2422 | 2422 | -73.9683066605832 | 40.7781213930544 | 16E-PM-1018-03 | 16E | PM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9683066605832 40.7781213930544) | 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 | ||||||
2240 | 2240 | -73.9697787673802 | 40.7781746195436 | 16D-PM-1010-05 | 16D | PM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9697787673802 40.7781746195436) | 19 | 4 | 19 | 13 | ||||||
1765 | 1765 | -73.9689041600147 | 40.7781788966185 | 16E-AM-1014-07 | 16E | AM | 10142018 | 7 | Adult | Gray | Gray+ | Above Ground | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.9689041600147 40.7781788966185) | 19 | 4 | 19 | 13 | ||||||
1102 | 1102 | -73.9688173465755 | 40.7782009764626 | 16E-AM-1014-08 | 16E | AM | 10142018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.9688173465755 40.7782009764626) | 19 | 4 | 19 | 13 | |||||
563 | 563 | -73.9700330712119 | 40.7782913925727 | 16D-PM-1010-06 | 16D | PM | 10102018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | walking | false | false | false | false | false | false | false | false | checking me out | POINT (-73.9700330712119 40.7782913925727) | 19 | 4 | 19 | 13 | ||||
1426 | 1426 | -73.9664986446294 | 40.778308334318 | 17G-PM-1017-02 | 17G | PM | 10172018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9664986446294 40.778308334318) | 19 | 4 | 19 | 13 | ||||||
329 | 329 | -73.967832992543 | 40.7783669913408 | 17E-PM-1018-03 | 17E | PM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.967832992543 40.7783669913408) | 19 | 4 | 19 | 13 | ||||||
1370 | 1370 | -73.9681627331154 | 40.7785099665602 | 17E-PM-1018-02 | 17E | PM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | On the rock | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9681627331154 40.7785099665602) | 19 | 4 | 19 | 13 | |||||
1200 | 1200 | -73.9657721715305 | 40.778534830257 | 18G-PM-1013-03 | 18G | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9657721715305 40.778534830257) | 19 | 4 | 19 | 13 | ||||||
1888 | 1888 | -73.9673919075839 | 40.7786845769177 | 17F-PM-1020-05 | 17F | PM | 10202018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9673919075839 40.7786845769177) | 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 );