This data as json, CSV (advanced)
Suggested facets: Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions
Combination of Primary and Highlight Color ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10 | 10 | -73.9596413903948 | 40.7903128889029 | 32E-PM-1017-14 | 32E | PM | 10172018 | 14 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9596413903948 40.7903128889029) | 19 | 4 | 19 | 13 | |||||||
11 | 11 | -73.9702676472613 | 40.7762126854894 | 13E-AM-1017-05 | 13E | AM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on tree stump | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9702676472613 40.7762126854894) | 19 | 4 | 19 | 13 | |||||
50 | 50 | -73.9680635070949 | 40.779249873647 | 17E-AM-1017-05 | 17E | AM | 10172018 | 5 | Adult | Black | Black+ | Above Ground | 10 | Branch | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9680635070949 40.779249873647) | 19 | 4 | 19 | 13 | |||||
61 | 61 | -73.9797084866613 | 40.7698885241349 | 3A-PM-1017-06 | 03A | PM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9797084866613 40.7698885241349) | 19 | 4 | 19 | 13 | |||||
62 | 62 | -73.952819267977 | 40.7923130402793 | 36I-AM-1017-02 | 36I | AM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon stripe on back | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.952819267977 40.7923130402793) | 19 | 4 | 19 | 13 | ||||
64 | 64 | -73.9595002339508 | 40.7903365788694 | 32E-PM-1017-13 | 32E | PM | 10172018 | 13 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9595002339508 40.7903365788694) | 19 | 4 | 19 | 13 | |||||||
70 | 70 | -73.9804528867547 | 40.7696753655986 | 3A-PM-1017-05 | 03A | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9804528867547 40.76967536559861) | 19 | 4 | 19 | 13 | |||||
75 | 75 | -73.9667114027214 | 40.7768804702473 | 16G-PM-1017-01 | 16G | PM | 10172018 | 1 | 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.9667114027214 40.7768804702473) | 19 | 4 | 19 | 13 | |||||
106 | 106 | -73.9634623418761 | 40.7917685404482 | 31A-PM-1017-04 | 31A | PM | 10172018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9634623418761 40.7917685404482) | 19 | 4 | 19 | 13 | |||||
153 | 153 | -73.9702348982803 | 40.7773295419104 | 15D-PM-1017-01 | 15D | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9702348982803 40.7773295419104) | 19 | 4 | 19 | 13 | |||||
206 | 206 | -73.9613643418025 | 40.7892431934209 | 30D-AM-1017-02 | 30D | AM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9613643418025 40.7892431934209) | 19 | 4 | 19 | 13 | ||||||
231 | 231 | -73.9527808174534 | 40.7924167234441 | 36I-AM-1017-05 | 36I | AM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | runs from (me) | POINT (-73.9527808174534 40.7924167234441) | 19 | 4 | 19 | 13 | ||||
232 | 232 | -73.9624184586031 | 40.7921524868211 | 32B-AM-1017-03 | 32B | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | true | true | true | approaches (primarily),runs from (initially),follows | POINT (-73.9624184586031 40.7921524868211) | 19 | 4 | 19 | 13 | ||||
240 | 240 | -73.9767080512177 | 40.7717708794221 | 6B-PM-1017-04 | 06B | PM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9767080512177 40.7717708794221) | 19 | 4 | 19 | 13 | |||||
245 | 245 | -73.9589414339242 | 40.7907073888277 | 32E-PM-1017-04 | 32E | PM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9589414339242 40.7907073888277) | 19 | 4 | 19 | 13 | |||||
282 | 282 | -73.9701575891098 | 40.7730973282423 | 10G-PM-1017-06 | 10G | PM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9701575891098 40.7730973282423) | 19 | 4 | 19 | 13 | |||||
295 | 295 | -73.9700691629574 | 40.7828893645197 | 20A-PM-1017-01 | 20A | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.97006916295742 40.7828893645197) | 19 | 4 | 19 | 13 | |||||
350 | 350 | -73.9707471099503 | 40.7759255131734 | 13E-AM-1017-08 | 13E | AM | 10172018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9707471099503 40.7759255131734) | 19 | 4 | 19 | 13 | |||||
357 | 357 | -73.9724801784201 | 40.7790131966689 | 15B-PM-1017-05 | 15B | PM | 10172018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9724801784201 40.7790131966689) | 19 | 4 | 19 | 13 | |||||
358 | 358 | -73.9635658786416 | 40.7777291777901 | 18I-AM-1017-03 | 18I | AM | 10172018 | 3 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9635658786416 40.77772917779011) | 19 | 4 | 19 | 13 | |||||
463 | 463 | -73.9592103064327 | 40.7904390691553 | 32E-PM-1017-10 | 32E | PM | 10172018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9592103064327 40.7904390691553) | 19 | 4 | 19 | 13 | ||||||
502 | 502 | -73.9683312453011 | 40.7801661685712 | 18D-PM-1017-01 | 18D | PM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9683312453011 40.7801661685712) | 19 | 4 | 19 | 13 | ||||||
513 | 513 | -73.963100689807 | 40.7920255189467 | 32B-AM-1017-02 | 32B | AM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon on its head | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.963100689807 40.79202551894671) | 19 | 4 | 19 | 13 | ||||
521 | 521 | -73.971322876671 | 40.7714145086361 | 8G-PM-1017-01 | 08G | PM | 10172018 | 1 | 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.971322876671 40.7714145086361) | 19 | 4 | 19 | 13 | |||||
621 | 621 | -73.9588886083793 | 40.7909991733435 | 32E-PM-1017-01 | 32E | PM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9588886083793 40.7909991733435) | 19 | 4 | 19 | 13 | ||||||
637 | 637 | -73.9675047480308 | 40.7789234397249 | 17E-AM-1017-01 | 17E | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | Pond area | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9675047480308 40.7789234397249) | 19 | 4 | 19 | 13 | |||||
641 | 641 | -73.9719036217446 | 40.7803588122409 | 17A-AM-1017-01 | 17A | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | ground & tree | true | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.9719036217446 40.7803588122409) | 19 | 4 | 19 | 13 | ||||
642 | 642 | -73.9568382279233 | 40.7975685470963 | 40C-AM-1017-07 | 40C | AM | 10172018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | false | true | false | POINT (-73.9568382279233 40.7975685470963) | 19 | 4 | 19 | 13 | ||||
651 | 651 | -73.9801661903932 | 40.7697950141751 | 3A-PM-1017-03 | 03A | PM | 10172018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9801661903932 40.7697950141751) | 19 | 4 | 19 | 13 | |||||
659 | 659 | -73.9572686979412 | 40.796268457326 | 38D-AM-1017-03 | 38D | AM | 10172018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | false | false | false | POINT (-73.9572686979412 40.796268457326) | 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 | |||||
723 | 723 | -73.9654397484763 | 40.7798863522904 | 19F-PM-1017-03 | 19F | PM | 10172018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9654397484763 40.7798863522904) | 19 | 4 | 19 | 13 | |||||
743 | 743 | -73.9565035705619 | 40.7937382705056 | 36F-AM-1017-04 | 36F | AM | 10172018 | 4 | Juvenile | Gray | White | Gray+White | White legs, front & back | Ground Plane | FALSE | true | false | false | true | true | true | false | false | false | false | true | false | true | approaches (me),runs from (me) | POINT (-73.9565035705619 40.7937382705056) | 19 | 4 | 19 | 13 | |||
763 | 763 | -73.9767455430709 | 40.7717866237826 | 6B-PM-1017-06 | 06B | PM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9767455430709 40.7717866237826) | 19 | 4 | 19 | 13 | |||||
770 | 770 | -73.9597782762029 | 40.7920773376757 | 33D-AM-1017-07 | 33D | AM | 10172018 | 7 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | true | false | true | false | false | true | false | POINT (-73.9597782762029 40.7920773376757) | 19 | 4 | 19 | 13 | ||||||
786 | 786 | -73.953296595236 | 40.7927644594513 | 36I-AM-1017-03 | 36I | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon stripe on back | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.953296595236 40.7927644594513) | 19 | 4 | 19 | 13 | ||||
791 | 791 | -73.9772635911119 | 40.7709428872533 | 6B-PM-1017-03 | 06B | PM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9772635911119 40.7709428872533) | 19 | 4 | 19 | 13 | |||||
806 | 806 | -73.970475755546 | 40.7763348062134 | 13E-AM-1017-02 | 13E | AM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | begging (came one yard away from me and stood there) | false | false | false | false | false | true | false | false | POINT (-73.970475755546 40.7763348062134) | 19 | 4 | 19 | 13 | |||||
851 | 851 | -73.9528462779437 | 40.7923843043685 | 36I-AM-1017-04 | 36I | AM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9528462779437 40.7923843043685) | 19 | 4 | 19 | 13 | |||||
853 | 853 | -73.9534509627885 | 40.7921084224711 | 36I-AM-1017-07 | 36I | AM | 10172018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | chasing (#8),scratching | true | false | false | false | true | false | true | false | POINT (-73.9534509627885 40.7921084224711) | 19 | 4 | 19 | 13 | ||||
857 | 857 | -73.9714243547433 | 40.7713973982359 | 8G-PM-1017-02 | 08G | PM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9714243547433 40.7713973982359) | 19 | 4 | 19 | 13 | ||||||
875 | 875 | -73.9700861859051 | 40.7770639340582 | 14E-PM-1017-04 | 14E | PM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9700861859051 40.7770639340582) | 19 | 4 | 19 | 13 | |||||
911 | 911 | -73.9697277998257 | 40.7705198722028 | 8H-AM-1017-01 | 08H | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9697277998257 40.7705198722028) | 19 | 4 | 19 | 13 | |||||
930 | 930 | -73.9622030085794 | 40.7917723228749 | 32B-AM-1017-01 | 32B | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | ran up a tree | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9622030085794 40.7917723228749) | 19 | 4 | 19 | 13 | ||||
973 | 973 | -73.9705977059862 | 40.7760413182276 | 13E-AM-1017-09 | 13E | AM | 10172018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9705977059862 40.776041318227605) | 19 | 4 | 19 | 13 | ||||||
975 | 975 | -73.956869086031 | 40.7988858771114 | 41C-AM-1017-05 | 41C | AM | 10172018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.956869086031 40.7988858771114) | 19 | 4 | 19 | 13 | ||||||
998 | 998 | -73.9600546294497 | 40.7914969165757 | 33D-AM-1017-03 | 33D | AM | 10172018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | true | false | POINT (-73.9600546294497 40.7914969165757) | 19 | 4 | 19 | 13 | ||||||
1020 | 1020 | -73.97016933635 | 40.7705452529783 | 8H-AM-1017-05 | 08H | AM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.97016933635001 40.7705452529783) | 19 | 4 | 19 | 13 | |||||
1050 | 1050 | -73.9562642076935 | 40.7983338763074 | 41C-AM-1017-02 | 41C | AM | 10172018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9562642076935 40.7983338763074) | 19 | 4 | 19 | 13 | |||||
1057 | 1057 | -73.9594406225891 | 40.7918533707789 | 33D-AM-1017-02 | 33D | AM | 10172018 | 2 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | true | false | false | POINT (-73.9594406225891 40.7918533707789) | 19 | 4 | 19 | 13 | |||||
1113 | 1113 | -73.9679309130266 | 40.7792437838039 | 17E-AM-1017-04 | 17E | AM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | Shore | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9679309130266 40.779243783803906) | 19 | 4 | 19 | 13 | |||||
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 | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9564079273261 40.7939340053805) | 19 | 4 | 19 | 13 | ||||
1132 | 1132 | -73.9798390387307 | 40.7700761090896 | 3A-PM-1017-07 | 03A | PM | 10172018 | 7 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9798390387307 40.7700761090896) | 19 | 4 | 19 | 13 | |||||
1136 | 1136 | -73.9515907796216 | 40.7952684235477 | 40H-AM-1017-02 | 40H | AM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.95159077962161 40.7952684235477) | 19 | 4 | 19 | 13 | ||||||
1149 | 1149 | -73.960237785199 | 40.7907831607574 | 32E-PM-1017-16 | 32E | PM | 10172018 | 16 | Adult | Black | Black+ | Ground Plane | FALSE | rocky outcrop | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.960237785199 40.7907831607574) | 19 | 4 | 19 | 13 | |||||
1179 | 1179 | -73.9696762034757 | 40.7704883494264 | 8H-AM-1017-02 | 08H | AM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | root bed of tree | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9696762034757 40.7704883494264) | 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 | |||||
1241 | 1241 | -73.9651817987035 | 40.7819082838334 | 21E-AM-1017-01 | 21E | AM | 10172018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | Climbs small tree | false | false | false | true | true | false | false | false | false | true | false | false | false | walks from | POINT (-73.9651817987035 40.7819082838334) | 19 | 4 | 19 | 13 | |||
1276 | 1276 | -73.9798005188704 | 40.7691868791734 | 3A-PM-1017-01 | 03A | PM | 10172018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.97980051887042 40.7691868791734) | 19 | 4 | 19 | 13 | |||||
1340 | 1340 | -73.9773083616259 | 40.7710535931636 | 6B-PM-1017-01 | 06B | PM | 10172018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | true | false | false | POINT (-73.9773083616259 40.7710535931636) | 19 | 4 | 19 | 13 | ||||
1366 | 1366 | -73.9711582199102 | 40.7783674409485 | 15C-PM-1017-05 | 15C | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | true | false | false | false | true | true | false | false | POINT (-73.9711582199102 40.7783674409485) | 19 | 4 | 19 | 13 | |||||
1375 | 1375 | -73.9564741038174 | 40.7938845572816 | 36F-AM-1017-03 | 36F | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon on shoulders | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | runs from (me) | POINT (-73.9564741038174 40.7938845572816) | 19 | 4 | 19 | 13 | |||
1471 | 1471 | -73.9614902429282 | 40.7891282017625 | 30D-AM-1017-01 | 30D | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9614902429282 40.7891282017625) | 19 | 4 | 19 | 13 | ||||||
1474 | 1474 | -73.9801971465604 | 40.7697081749827 | 3A-PM-1017-04 | 03A | PM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9801971465604 40.7697081749827) | 19 | 4 | 19 | 13 | |||||
1502 | 1502 | -73.9705254801 | 40.7763606494306 | 13E-AM-1017-03 | 13E | AM | 10172018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | true | false | false | false | false | false | false | true | acknowledges | POINT (-73.9705254801 40.7763606494306) | 19 | 4 | 19 | 13 | ||||
1564 | 1564 | -73.9703816112358 | 40.7773846065919 | 15D-PM-1017-02 | 15D | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9703816112358 40.7773846065919) | 19 | 4 | 19 | 13 | |||||
1637 | 1637 | -73.9699513151755 | 40.7722062991044 | 10G-PM-1017-05 | 10G | PM | 10172018 | 5 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9699513151755 40.7722062991044) | 19 | 4 | 19 | 13 | ||||||
1674 | 1674 | -73.9589698681439 | 40.7906520520417 | 32E-PM-1017-06 | 32E | PM | 10172018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9589698681439 40.7906520520417) | 19 | 4 | 19 | 13 | |||||
1712 | 1712 | -73.9801899519657 | 40.7695777009264 | 3A-PM-1017-02 | 03A | PM | 10172018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9801899519657 40.7695777009264) | 19 | 4 | 19 | 13 | |||||
1717 | 1717 | -73.9714952092767 | 40.7748063281815 | 12E-AM-1017-02 | 12E | AM | 10172018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9714952092767 40.7748063281815) | 19 | 4 | 19 | 13 | |||||
1746 | 1746 | -73.9603471161869 | 40.7906003311747 | 32E-PM-1017-15 | 32E | PM | 10172018 | 15 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9603471161869 40.7906003311747) | 19 | 4 | 19 | 13 | ||||||
1777 | 1777 | -73.9711751356843 | 40.7752422758202 | 12E-AM-1017-06 | 12E | AM | 10172018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9711751356843 40.7752422758202) | 19 | 4 | 19 | 13 | |||||
1784 | 1784 | -73.9748318777506 | 40.7771821378056 | 13A-AM-1017-05 | 13A | AM | 10172018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9748318777506 40.7771821378056) | 19 | 4 | 19 | 13 | |||||
1789 | 1789 | -73.9596271142953 | 40.7906612313673 | 32E-PM-1017-12 | 32E | PM | 10172018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | true | false | false | false | false | false | false | POINT (-73.9596271142953 40.7906612313673) | 19 | 4 | 19 | 13 | ||||||
1812 | 1812 | -73.9590074024938 | 40.7907059424675 | 32E-PM-1017-05 | 32E | PM | 10172018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9590074024938 40.7907059424675) | 19 | 4 | 19 | 13 | |||||
1818 | 1818 | -73.956863563379 | 40.7986418851147 | 41C-AM-1017-01 | 41C | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.95686356337902 40.7986418851147) | 19 | 4 | 19 | 13 | ||||||
1830 | 1830 | -73.9518008149564 | 40.7953738093588 | 40H-AM-1017-01 | 40H | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | base of tree | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9518008149564 40.7953738093588) | 19 | 4 | 19 | 13 | ||||
1857 | 1857 | -73.9728797531377 | 40.7786733148687 | 15B-PM-1017-01 | 15B | PM | 10172018 | 1 | Gray | Gray+ | Above Ground | 20 | in tree | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9728797531377 40.7786733148687) | 19 | 4 | 19 | 13 | ||||||
1868 | 1868 | -73.9712265022781 | 40.7783790991192 | 15C-PM-1017-04 | 15C | PM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9712265022781 40.7783790991192) | 19 | 4 | 19 | 13 | |||||
1911 | 1911 | -73.9528937660465 | 40.7922919074537 | 36I-AM-1017-01 | 36I | AM | 10172018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | false | true | runs from (me!)—from a pretty big distance | POINT (-73.9528937660465 40.7922919074537) | 19 | 4 | 19 | 13 | ||||
1937 | 1937 | -73.9565549485301 | 40.7989823714955 | 41C-AM-1017-03 | 41C | AM | 10172018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9565549485301 40.7989823714955) | 19 | 4 | 19 | 13 | |||||
1941 | 1941 | -73.9704790263224 | 40.7762270645666 | 13E-AM-1017-01 | 13E | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | in middle of path | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9704790263224 40.7762270645666) | 19 | 4 | 19 | 13 | |||||
2004 | 2004 | -73.9635838951472 | 40.7917524619792 | 31B-AM-1017-02 | 31B | AM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9635838951472 40.7917524619792) | 19 | 4 | 19 | 13 | ||||||
2078 | 2078 | -73.9706041173545 | 40.7780152784804 | 15D-PM-1017-05 | 15D | PM | 10172018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9706041173545 40.7780152784804) | 19 | 4 | 19 | 13 | |||||
2115 | 2115 | -73.9658203999388 | 40.7775874026824 | 17G-PM-1017-01 | 17G | PM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | base of tree | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9658203999388 40.7775874026824) | 19 | 4 | 19 | 13 | |||||
2121 | 2121 | -73.9693462354257 | 40.7764444385452 | 14E-PM-1017-01 | 14E | PM | 10172018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9693462354257 40.7764444385452) | 19 | 4 | 19 | 13 | |||||
2129 | 2129 | -73.9701182454818 | 40.7772805500871 | 15D-PM-1017-03 | 15D | PM | 10172018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9701182454818 40.7772805500871) | 19 | 4 | 19 | 13 | |||||
2135 | 2135 | -73.9596251284566 | 40.7916254797561 | 33D-AM-1017-05 | 33D | AM | 10172018 | 5 | Adult | Black | Black+ | Above Ground | 5 | false | false | true | false | true | false | false | false | false | true | false | true | false | POINT (-73.9596251284566 40.7916254797561) | 19 | 4 | 19 | 13 | ||||||
2148 | 2148 | -73.9767317539505 | 40.7717600450632 | 6B-PM-1017-05 | 06B | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9767317539505 40.7717600450632) | 19 | 4 | 19 | 13 | |||||
2192 | 2192 | -73.9593410965431 | 40.7923134010383 | 33D-AM-1017-08 | 33D | AM | 10172018 | 8 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9593410965431 40.7923134010383) | 19 | 4 | 19 | 13 | ||||||
2296 | 2296 | -73.965596981561 | 40.7797738845824 | 19F-PM-1017-02 | 19F | PM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.965596981561 40.7797738845824) | 19 | 4 | 19 | 13 | ||||||
2310 | 2310 | -73.9712863172608 | 40.774698758184 | 12E-AM-1017-01 | 12E | AM | 10172018 | 1 | 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.9712863172608 40.774698758184) | 19 | 4 | 19 | 13 | |||||
2352 | 2352 | -73.9727310397798 | 40.7787016773517 | 15B-PM-1017-02 | 15B | PM | 10172018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | tree | false | false | true | true | true | digging,chewing on tree—has nut in mouth! | false | false | false | false | false | false | false | true | POINT (-73.97273103977982 40.7787016773517) | 19 | 4 | 19 | 13 | |||
2364 | 2364 | -73.9587183039085 | 40.7909209137969 | 32E-PM-1017-02 | 32E | PM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9587183039085 40.7909209137969) | 19 | 4 | 19 | 13 | ||||||
2376 | 2376 | -73.9594204646985 | 40.7905923765213 | 32E-PM-1017-11 | 32E | PM | 10172018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9594204646985 40.7905923765213) | 19 | 4 | 19 | 13 | ||||||
2400 | 2400 | -73.9768268467857 | 40.7714608041933 | 6B-PM-1017-02 | 06B | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9768268467857 40.7714608041933) | 19 | 4 | 19 | 13 | |||||
2414 | 2414 | -73.9708175461804 | 40.7759228565501 | 13E-AM-1017-10 | 13E | AM | 10172018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9708175461804 40.7759228565501) | 19 | 4 | 19 | 13 | ||||||
2493 | 2493 | -73.954767265558 | 40.7973243644491 | 40E-PM-1017-03 | 40E | PM | 10172018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.954767265558 40.7973243644491) | 19 | 4 | 19 | 13 | |||||
2513 | 2513 | -73.9767590273554 | 40.7717561807266 | 6B-PM-1017-07 | 06B | PM | 10172018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9767590273554 40.7717561807266) | 19 | 4 | 19 | 13 | |||||
2541 | 2541 | -73.9579097104326 | 40.7972273394716 | 39C-AM-1017-03 | 39C | AM | 10172018 | 3 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9579097104326 40.7972273394716) | 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 );