This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Running, Chasing, Climbing, Foraging, Kuks, Quaas, Moans, Tail flags, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1433 | 1433 | -73.9574077497624 | 40.8001185184892 | 42B-AM-1014-01 | 42B | AM | 10142018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9574077497624 40.8001185184892) | 19 | 4 | 19 | 13 | ||||||
846 | 846 | -73.9582643954055 | 40.8000460061272 | 42A-AM-1019-01 | 42A | AM | 10192018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.95826439540551 40.8000460061272) | 19 | 4 | 19 | 13 | |||||
130 | 130 | -73.9581655949437 | 40.7997708190022 | 41A-PM-1007-06 | 41A | PM | 10072018 | 6 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9581655949437 40.7997708190022) | 19 | 4 | 19 | 13 | ||||||
2316 | 2316 | -73.957697363244 | 40.7997576909042 | 42A-PM-1014-01 | 42A | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | up on hind legs looking around | false | false | false | false | false | false | false | false | came to about 10' away then ran off | POINT (-73.957697363244 40.7997576909042) | 19 | 4 | 19 | 13 | |||
795 | 795 | -73.9582523503306 | 40.7996897499473 | 41A-PM-1007-05 | 41A | PM | 10072018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9582523503306 40.7996897499473) | 19 | 4 | 19 | 13 | |||||
473 | 473 | -73.9570130017159 | 40.7996027428625 | 42B-AM-1014-02 | 42B | AM | 10142018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | false | true | false | POINT (-73.9570130017159 40.7996027428625) | 19 | 4 | 19 | 13 | |||||
802 | 802 | -73.958494212554 | 40.7995008636057 | 41A-AM-1013-01 | 41A | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | ran across a path | false | false | false | false | false | false | true | false | POINT (-73.958494212554 40.7995008636057) | 19 | 4 | 19 | 13 | ||||
2934 | 2934 | -73.9561669236168 | 40.7994737431277 | 42C-PM-1013-04 | 42C | PM | 10132018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | false | true | POINT (-73.9561669236168 40.7994737431277) | 19 | 4 | 19 | 13 | ||||||
2797 | 2797 | -73.9576913492669 | 40.7994216061391 | 41B-AM-1010-11 | 41B | AM | 10102018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | false | false | false | true | false | eating a mushroom! | false | false | false | false | false | false | true | false | POINT (-73.9576913492669 40.7994216061391) | 19 | 4 | 19 | 13 | ||||||
1740 | 1740 | -73.9577758125518 | 40.799384716477 | 41B-AM-1010-10 | 41B | AM | 10102018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9577758125518 40.799384716477) | 19 | 4 | 19 | 13 | |||||
2720 | 2720 | -73.9566300789162 | 40.7993692120774 | 42C-PM-1013-06 | 42C | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Between park and main drag | false | false | true | true | false | false | false | false | false | false | false | true | true | POINT (-73.9566300789162 40.7993692120774) | 19 | 4 | 19 | 13 | ||||
102 | 102 | -73.9575986161364 | 40.799368134968 | 41B-PM-1014-01 | 41B | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | Climbing tree | false | false | true | false | false | climbing (tree) | false | false | false | false | false | false | false | true | POINT (-73.9575986161364 40.799368134968) | 19 | 4 | 19 | 13 | |||
1887 | 1887 | -73.9586184232889 | 40.7993153832942 | 41A-PM-1007-02 | 41A | PM | 10072018 | 2 | Adult | Black | Black+ | Above Ground | 15 | false | false | true | false | false | jumping | false | false | false | false | false | false | false | false | stared at me | POINT (-73.9586184232889 40.7993153832942) | 19 | 4 | 19 | 13 | ||||
2077 | 2077 | -73.9562733511031 | 40.7993142101839 | 42C-PM-1013-03 | 42C | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | Crossing street | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9562733511031 40.7993142101839) | 19 | 4 | 19 | 13 | |||||
1925 | 1925 | -73.9581389870644 | 40.7993081122523 | 41A-PM-1007-04 | 41A | PM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | true | false | true | false | false | laid down on the branch | false | false | false | false | false | false | false | true | POINT (-73.9581389870644 40.799308112252305) | 19 | 4 | 19 | 13 | |||||
2350 | 2350 | -73.9564777440695 | 40.7993068355401 | 42C-AM-1007-01 | 42C | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | nut in mouth | false | false | false | false | false | false | false | true | POINT (-73.9564777440695 40.7993068355401) | 19 | 4 | 19 | 13 | ||||
822 | 822 | -73.9576559099012 | 40.7992598626483 | 41B-AM-1010-09 | 41B | AM | 10102018 | 9 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9576559099012 40.7992598626483) | 19 | 4 | 19 | 13 | ||||||
92 | 92 | -73.9565759733611 | 40.7992461674802 | 42C-AM-1007-02 | 42C | AM | 10072018 | 2 | + | false | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9565759733611 40.7992461674802) | 19 | 4 | 19 | 13 | ||||||||||
920 | 920 | -73.9571233640232 | 40.7992458980266 | 41B-PM-1014-04 | 41B | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | false | false | true | false | false | false | false | false | false | false | false | false | false | climbing | POINT (-73.9571233640232 40.7992458980266) | 19 | 4 | 19 | 13 | ||||
2416 | 2416 | -73.9588689820908 | 40.7992384137972 | 40A-PM-1014-03 | 40A | PM | 10142018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (ran from base of tree into bushes) | POINT (-73.9588689820908 40.799238413797205) | 19 | 4 | 19 | 13 | |||||
2455 | 2455 | -73.9577297187155 | 40.799225295679 | 41B-AM-1010-08 | 41B | AM | 10102018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 20 | false | false | true | true | false | false | false | false | false | false | true | false | false | POINT (-73.9577297187155 40.799225295679) | 19 | 4 | 19 | 13 | |||||
561 | 561 | -73.9581982486469 | 40.7992194575293 | 41A-PM-1007-03 | 41A | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 55 | true | false | true | false | false | false | false | false | false | true | false | false | false | POINT (-73.95819824864691 40.7992194575293) | 19 | 4 | 19 | 13 | |||||
2743 | 2743 | -73.9587179613803 | 40.7992119571657 | 41A-PM-1007-01 | 41A | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9587179613803 40.7992119571657) | 19 | 4 | 19 | 13 | |||||
1574 | 1574 | -73.9561840935803 | 40.7992037821497 | 42C-PM-1013-05 | 42C | PM | 10132018 | 5 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | true | false | true | false | false | false | false | false | true | false | POINT (-73.9561840935803 40.7992037821497) | 19 | 4 | 19 | 13 | ||||||
2977 | 2977 | -73.9580681648547 | 40.7992010012653 | 41B-AM-1010-01 | 41B | AM | 10102018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9580681648547 40.7992010012653) | 19 | 4 | 19 | 13 | |||||
1343 | 1343 | -73.9563662963703 | 40.7991952101949 | 42C-PM-1013-01 | 42C | PM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9563662963703 40.7991952101949) | 19 | 4 | 19 | 13 | ||||||
2968 | 2968 | -73.9587236619579 | 40.7991850180434 | 40A-AM-1010-02 | 40A | AM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | edge of park at 108th West | true | false | true | false | false | false | false | false | true | false | false | false | true | POINT (-73.9587236619579 40.7991850180434) | 19 | 4 | 19 | 13 | ||||
1908 | 1908 | -73.9588345546879 | 40.7991830272008 | 40A-PM-1014-02 | 40A | PM | 10142018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (ran from base of tree into bushes) | POINT (-73.9588345546879 40.7991830272008) | 19 | 4 | 19 | 13 | |||||
1244 | 1244 | -73.9565260889843 | 40.7991807924337 | 42C-AM-1007-03 | 42C | AM | 10072018 | 3 | + | false | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.9565260889843 40.79918079243371) | 19 | 4 | 19 | 13 | ||||||||||
415 | 415 | -73.9570131890379 | 40.7991786736124 | 41B-PM-1014-05 | 41B | PM | 10142018 | 5 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | false | true | false | false | false | false | false | true | true | POINT (-73.9570131890379 40.7991786736124) | 19 | 4 | 19 | 13 | ||||||
2045 | 2045 | -73.9564173149092 | 40.7991558544827 | 42C-PM-1013-02 | 42C | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.95641731490922 40.7991558544827) | 19 | 4 | 19 | 13 | |||||
755 | 755 | -73.9579941847434 | 40.7991216713328 | 41B-PM-1014-02 | 41B | PM | 10142018 | 2 | Adult | Black | Black+ | Above Ground | 28 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9579941847434 40.7991216713328) | 19 | 4 | 19 | 13 | ||||||
188 | 188 | -73.9570528770427 | 40.7990973804149 | 41B-AM-1010-07 | 41B | AM | 10102018 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10 | false | false | false | false | false | true | false | false | true | false | true | false | false | mad! | POINT (-73.9570528770427 40.7990973804149) | 19 | 4 | 19 | 13 | ||||
1414 | 1414 | -73.9580513096783 | 40.79909641532 | 41B-AM-1010-02 | 41B | AM | 10102018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 16 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9580513096783 40.79909641532) | 19 | 4 | 19 | 13 | |||||
616 | 616 | -73.9556937218252 | 40.7990928062435 | 42C-AM-1007-04 | 42C | AM | 10072018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | young adult | Ground Plane | FALSE | false | false | false | false | false | walking | false | false | false | false | false | false | true | false | POINT (-73.9556937218252 40.7990928062435) | 19 | 4 | 19 | 13 | |||
354 | 354 | -73.9566751022336 | 40.799035789744 | 41C-PM-1007-04 | 41C | PM | 10072018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 65 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9566751022336 40.799035789744) | 19 | 4 | 19 | 13 | |||||
2279 | 2279 | -73.9586085858962 | 40.7990326758282 | 40A-PM-1014-04 | 40A | PM | 10142018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (ran from path to bushes) | POINT (-73.9586085858962 40.7990326758282) | 19 | 4 | 19 | 13 | |||||
2392 | 2392 | -73.9578981223015 | 40.7989967754358 | 41B-AM-1010-03 | 41B | AM | 10102018 | 3 | Adult | + | Above Ground | 60 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9578981223015 40.7989967754358) | 19 | 4 | 19 | 13 | |||||||
1072 | 1072 | -73.9566571713254 | 40.7989855775435 | 41C-AM-1017-04 | 41C | AM | 10172018 | 4 | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9566571713254 40.7989855775435) | 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 | |||||
2021 | 2021 | -73.9582800305509 | 40.7989473712974 | 40B-PM-1014-03 | 40B | PM | 10142018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9582800305509 40.7989473712974) | 19 | 4 | 19 | 13 | |||||
1310 | 1310 | -73.9546201403481 | 40.7989423768656 | 42D-AM-1014-03 | 42D | AM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9546201403481 40.7989423768656) | 19 | 4 | 19 | 13 | |||||
1185 | 1185 | -73.958230674366 | 40.7989268396525 | 40B-AM-1019-08 | 40B | AM | 10192018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | true | true | POINT (-73.958230674366 40.7989268396525) | 19 | 4 | 19 | 13 | |||||
1987 | 1987 | -73.9573692542155 | 40.7989252908321 | 41B-PM-1014-03 | 41B | PM | 10142018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 28 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9573692542155 40.7989252908321) | 19 | 4 | 19 | 13 | |||||
1986 | 1986 | -73.958247706428 | 40.7989079136796 | 40B-AM-1019-07 | 40B | AM | 10192018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | true | POINT (-73.958247706428 40.7989079136796) | 19 | 4 | 19 | 13 | |||||
2016 | 2016 | -73.9589492240754 | 40.798901118974 | 40A-PM-1014-01 | 40A | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | false | false | true | false | false | false | false | false | false | true | false | true | false | stared & then went back up tree—then ran to different tree | POINT (-73.9589492240754 40.798901118974) | 19 | 4 | 19 | 13 | ||||
1807 | 1807 | -73.9581366214863 | 40.7988964092722 | 40B-PM-1014-02 | 40B | PM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | true | false | false | true | true | false | false | false | false | false | true | POINT (-73.9581366214863 40.7988964092722) | 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 | ||||||
1034 | 1034 | -73.9553163829551 | 40.7988610926249 | 42D-PM-1013-04 | 42D | PM | 10132018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Light Cinnamon | Ground Plane | FALSE | false | false | false | false | false | carrying nut away | false | false | false | false | false | false | true | false | POINT (-73.9553163829551 40.7988610926249) | 19 | 4 | 19 | 13 | |||
2195 | 2195 | -73.955352152771 | 40.7988549523022 | 42D-AM-1014-01 | 42D | AM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | false | false | true | true | false | true | false | false | false | false | false | true | false | POINT (-73.955352152771 40.7988549523022) | 19 | 4 | 19 | 13 | |||||
116 | 116 | -73.9572093760529 | 40.7988487300216 | 41B-AM-1010-06 | 41B | AM | 10102018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9572093760529 40.7988487300216) | 19 | 4 | 19 | 13 | |||||
2285 | 2285 | -73.9576325087936 | 40.7988448745116 | 41B-AM-1010-04 | 41B | AM | 10102018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9576325087936 40.7988448745116) | 19 | 4 | 19 | 13 | |||||
1601 | 1601 | -73.9544278270221 | 40.7987827316512 | 42D-PM-1013-02 | 42D | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Gray tail, Cinnamon feet | Ground Plane | FALSE | false | true | false | false | true | chasing (chased by #1),found a nut,buried it | false | false | false | false | false | false | true | false | POINT (-73.9544278270221 40.7987827316512) | 19 | 4 | 19 | 13 | |||
2168 | 2168 | -73.9582363437135 | 40.7987752300505 | 40B-AM-1019-06 | 40B | AM | 10192018 | 6 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9582363437135 40.7987752300505) | 19 | 4 | 19 | 13 | |||||
1886 | 1886 | -73.956806913988 | 40.7987736900857 | 41C-AM-1017-06 | 41C | AM | 10172018 | 6 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | false | true | false | false | false | false | false | true | false | POINT (-73.956806913988 40.7987736900857) | 19 | 4 | 19 | 13 | ||||||
656 | 656 | -73.9553726714504 | 40.7987578541123 | 41D-AM-1014-02 | 41D | AM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | false | false | jumping | false | false | false | false | false | false | true | false | POINT (-73.9553726714504 40.7987578541123) | 19 | 4 | 19 | 13 | |||||
1224 | 1224 | -73.9572530843479 | 40.7987460430546 | 41B-AM-1010-05 | 41B | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9572530843479 40.7987460430546) | 19 | 4 | 19 | 13 | |||||
93 | 93 | -73.9551539498306 | 40.7987384656256 | 41D-AM-1014-01 | 41D | AM | 10142018 | 1 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | false | true | false | POINT (-73.9551539498306 40.7987384656256) | 19 | 4 | 19 | 13 | ||||
478 | 478 | -73.954482814186 | 40.7987031768001 | 42D-PM-1013-01 | 42D | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Drawing included. | Ground Plane | FALSE | false | false | false | false | true | watching passers-by | false | false | false | false | false | true | true | false | POINT (-73.954482814186 40.7987031768001) | 19 | 4 | 19 | 13 | |||
1603 | 1603 | -73.9545929242174 | 40.7986940168685 | 42D-AM-1014-02 | 42D | AM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9545929242174 40.7986940168685) | 19 | 4 | 19 | 13 | ||||
2953 | 2953 | -73.9585862117341 | 40.7986549251083 | 40A-PM-1014-05 | 40A | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | eating (in a tree cage thing) | false | false | false | false | false | false | true | false | POINT (-73.9585862117341 40.7986549251083) | 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 | ||||||
1307 | 1307 | -73.9565197137317 | 40.7986011403785 | 41C-PM-1007-01 | 41C | PM | 10072018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9565197137317 40.7986011403785) | 19 | 4 | 19 | 13 | ||||||
560 | 560 | -73.9573057686241 | 40.7985734105729 | 40B-PM-1014-01 | 40B | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9573057686241 40.7985734105729) | 19 | 4 | 19 | 13 | |||||
2993 | 2993 | -73.9570722262693 | 40.7985706143519 | 40C-AM-1017-04 | 40C | AM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | true | true | chasing (#3) | false | false | false | false | false | false | true | false | POINT (-73.9570722262693 40.7985706143519) | 19 | 4 | 19 | 13 | ||||
2829 | 2829 | -73.9565230963554 | 40.798556387711 | 41C-PM-1007-02 | 41C | PM | 10072018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9565230963554 40.798556387711) | 19 | 4 | 19 | 13 | |||||
517 | 517 | -73.954959868822 | 40.7985404965582 | 41D-PM-1014-03 | 41D | PM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.954959868822 40.7985404965582) | 19 | 4 | 19 | 13 | |||||
1988 | 1988 | -73.957138794884 | 40.7985389822719 | 40C-AM-1017-03 | 40C | AM | 10172018 | 3 | Adult | Gray | White | Gray+White | true | true | true | false | false | chasing (#4),digging | false | false | false | false | true | false | true | false | POINT (-73.957138794884 40.7985389822719) | 19 | 4 | 19 | 13 | ||||||
1196 | 1196 | -73.9580111496275 | 40.7985365971474 | 40B-AM-1019-05 | 40B | AM | 10192018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | true | true | false | POINT (-73.9580111496275 40.7985365971474) | 19 | 4 | 19 | 13 | |||||
2659 | 2659 | -73.9553603438021 | 40.7985282963244 | 41D-PM-1014-05 | 41D | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 12 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9553603438021 40.7985282963244) | 19 | 4 | 19 | 13 | |||||
460 | 460 | -73.9549135206961 | 40.798525897229 | 42D-PM-1013-03 | 42D | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | in tree | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9549135206961 40.798525897229) | 19 | 4 | 19 | 13 | ||||
1801 | 1801 | -73.9587072373474 | 40.7985209579925 | 40B-AM-1019-01 | 40B | AM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9587072373474 40.7985209579925) | 19 | 4 | 19 | 13 | |||||
1054 | 1054 | -73.9570050460867 | 40.7985192250745 | 40C-AM-1017-05 | 40C | AM | 10172018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9570050460867 40.7985192250745) | 19 | 4 | 19 | 13 | |||||
494 | 494 | -73.958837574505 | 40.7985003987784 | 40A-PM-1014-06 | 40A | PM | 10142018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.958837574505 40.7985003987784) | 19 | 4 | 19 | 13 | |||||
1022 | 1022 | -73.9548853492712 | 40.7984783584388 | 41D-PM-1014-04 | 41D | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | false | false | true | false | false | jumping tree to tree | false | false | false | false | false | false | false | false | POINT (-73.9548853492712 40.7984783584388) | 19 | 4 | 19 | 13 | ||||
1246 | 1246 | -73.9543044385367 | 40.7984498571338 | 41E-AM-1007-04 | 41E | AM | 10072018 | 4 | Adult | Cinnamon | White | Cinnamon+White | white haunches/tail | Ground Plane | FALSE | rubbing belly on ground | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9543044385367 40.798449857133804) | 19 | 4 | 19 | 13 | |||
1412 | 1412 | -73.9594676326588 | 40.7984457363388 | 39A-AM-1013-01 | 39A | AM | 10132018 | 1 | Juvenile | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9594676326588 40.7984457363388) | 19 | 4 | 19 | 13 | |||||
2286 | 2286 | -73.9554415665082 | 40.7984201416018 | 41D-AM-1014-03 | 41D | AM | 10142018 | 3 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9554415665082 40.7984201416018) | 19 | 4 | 19 | 13 | |||||
1064 | 1064 | -73.9540257319561 | 40.798408619116 | 42E-PM-1012-02 | 42E | PM | 10122018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | true | false | true | false | false | false | false | false | false | false | false | true | true | POINT (-73.9540257319561 40.798408619116) | 19 | 4 | 19 | 13 | |||||||
1540 | 1540 | -73.957710975899 | 40.7984055614047 | 40B-AM-1019-06 | 40B | AM | 10192018 | 6 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.957710975899 40.7984055614047) | 19 | 4 | 19 | 13 | |||||
1039 | 1039 | -73.9584646000078 | 40.7983984665955 | 40B-PM-1014-07 | 40B | PM | 10142018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9584646000078 40.7983984665955) | 19 | 4 | 19 | 13 | |||||
1324 | 1324 | -73.954554245377 | 40.7983935730557 | 41E-AM-1007-05 | 41E | AM | 10072018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | man/pit bull mix wandered | POINT (-73.954554245377 40.7983935730557) | 19 | 4 | 19 | 13 | ||||
2342 | 2342 | -73.9533645762606 | 40.7983709215535 | 42F-AM-1019-01 | 42F | AM | 10192018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | true | false | false | true | runs from (me) | POINT (-73.9533645762606 40.7983709215535) | 19 | 4 | 19 | 13 | ||||
2832 | 2832 | -73.958607566971 | 40.7983695505584 | 40B-PM-1014-04 | 40B | PM | 10142018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.958607566971 40.7983695505584) | 19 | 4 | 19 | 13 | |||||
2346 | 2346 | -73.9562177305881 | 40.7983413276331 | 41C-PM-1007-03 | 41C | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9562177305881 40.7983413276331) | 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 | |||||
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 | |||||
2885 | 2885 | -73.9530811255728 | 40.7983069118579 | 42F-AM-1019-02 | 42F | AM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9530811255728 40.79830691185791) | 19 | 4 | 19 | 13 | |||||
2840 | 2840 | -73.9532163535175 | 40.7982970313067 | 42F-PM-1017-04 | 42F | PM | 10172018 | 4 | Gray | Gray+ | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9532163535175 40.7982970313067) | 19 | 4 | 19 | 13 | |||||||||
53 | 53 | -73.9584970643213 | 40.7982886348696 | 40B-AM-1019-03 | 40B | AM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | true | true | false | false | POINT (-73.9584970643213 40.7982886348696) | 19 | 4 | 19 | 13 | |||||
172 | 172 | -73.958535640774 | 40.7982737896998 | 40B-AM-1019-02 | 40B | AM | 10192018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.958535640774 40.7982737896998) | 19 | 4 | 19 | 13 | |||||
2746 | 2746 | -73.9561432836863 | 40.7982665347234 | 41C-AM-1017-07 | 41C | AM | 10172018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9561432836863 40.7982665347234) | 19 | 4 | 19 | 13 | |||||
242 | 242 | -73.9590236602085 | 40.7982632456866 | 40A-AM-1010-04 | 40A | AM | 10102018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | bottom great hill | false | false | false | false | true | false | false | false | true | false | false | true | true | dog chased | POINT (-73.9590236602085 40.7982632456866) | 19 | 4 | 19 | 13 | |||
124 | 124 | -73.9588660250232 | 40.7982597947515 | 40A-AM-1010-03 | 40A | AM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | bottom of great hill | false | false | false | true | true | false | false | false | true | false | false | true | true | dog chased | POINT (-73.9588660250232 40.7982597947515) | 19 | 4 | 19 | 13 | |||
2439 | 2439 | -73.9587459136391 | 40.7982497351812 | 40B-PM-1014-05 | 40B | PM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9587459136391 40.7982497351812) | 19 | 4 | 19 | 13 | |||||
1686 | 1686 | -73.9593373093799 | 40.7982428507976 | 39A-PM-1014-03 | 39A | PM | 10142018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Higlights. Made executive adjustments. | Above Ground | 6 | Jumped from ground onto branch | false | false | false | false | true | digging? | false | false | false | false | true | false | true | false | POINT (-73.95933730937992 40.7982428507976) | 19 | 4 | 19 | 13 | ||
2836 | 2836 | -73.953092053256 | 40.7982256930243 | 42F-PM-1017-03 | 42F | PM | 10172018 | 3 | Gray | Cinnamon | Gray+Cinnamon | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.953092053256 40.7982256930243) | 19 | 4 | 19 | 13 | ||||||||
87 | 87 | -73.9541453465817 | 40.7982162223764 | 42E-PM-1012-06 | 42E | PM | 10122018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9541453465817 40.79821622237641) | 19 | 4 | 19 | 13 | |||||
496 | 496 | -73.9548430741605 | 40.798207350942 | 41E-AM-1007-06 | 41E | AM | 10072018 | 6 | Adult | Gray | Gray+ | Above Ground | 30 | tree | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9548430741605 40.798207350942) | 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 |
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 );