Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare_Squirrel_Number, Age, Combination_of_Primary_and_Highlight_Color, Color_notes, Location, Above_Ground_Sighter_Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Moans, Tail_flags, Tail_twitches, Approaches, Indifferent, Runs_from, 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 | Latlong | Zip_Codes | Community_Districts | Borough_Boundaries | City_Council_Districts | Police_Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2927 | 2927 | -73.96857515954851 | 40.7709413567859 | 9I-PM-1010-07 | 09I | PM | 1010 | 7 | Adult | Gray | White | Gray+White | Above Ground | 1.0 | ran up tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9685751595485 40.7709413567859) | 19 | 4 | 19 | 13 | ||||
5950 | 5950 | -73.96857515954851 | 40.7709413567859 | 9I-PM-1010-07 | 09I | PM | 1010 | 7 | Adult | Gray | White | Gray+White | Above Ground | 1.0 | ran up tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9685751595485 40.7709413567859) | 19 | 4 | 19 | 13 | ||||
2179 | 2179 | -73.9683994064731 | 40.7710765500799 | 9I-AM-1014-06 | 09I | AM | 1014 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9683994064731 40.7710765500799) | 19 | 4 | 19 | 13 | |||||
5202 | 5202 | -73.9683994064731 | 40.7710765500799 | 9I-AM-1014-06 | 09I | AM | 1014 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9683994064731 40.7710765500799) | 19 | 4 | 19 | 13 | |||||
2967 | 2967 | -73.9695569897042 | 40.771206214717104 | 9H-PM-1018-01 | 09H | PM | 1018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9695569897042 40.7712062147171) | 19 | 4 | 19 | 13 | |||||
5990 | 5990 | -73.9695569897042 | 40.771206214717104 | 9H-PM-1018-01 | 09H | PM | 1018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9695569897042 40.7712062147171) | 19 | 4 | 19 | 13 | |||||
2436 | 2436 | -73.9690638424196 | 40.7713869295685 | 9H-AM-1006-06 | 09H | AM | 1006 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9690638424196 40.7713869295685) | 19 | 4 | 19 | 13 | |||||
5459 | 5459 | -73.9690638424196 | 40.7713869295685 | 9H-AM-1006-06 | 09H | AM | 1006 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9690638424196 40.7713869295685) | 19 | 4 | 19 | 13 | |||||
569 | 569 | -73.9698959071826 | 40.7716763799299 | 9H-AM-1006-05 | 09H | AM | 1006 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698959071826 40.7716763799299) | 19 | 4 | 19 | 13 | |||||
3592 | 3592 | -73.9698959071826 | 40.7716763799299 | 9H-AM-1006-05 | 09H | AM | 1006 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9698959071826 40.7716763799299) | 19 | 4 | 19 | 13 | |||||
2025 | 2025 | -73.9695560376915 | 40.7708835103516 | 9H-AM-1006-03 | 09H | AM | 1006 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9695560376915 40.7708835103516) | 19 | 4 | 19 | 13 | |||||
5048 | 5048 | -73.9695560376915 | 40.7708835103516 | 9H-AM-1006-03 | 09H | AM | 1006 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9695560376915 40.7708835103516) | 19 | 4 | 19 | 13 | |||||
2996 | 2996 | -73.9697160572446 | 40.7711445570446 | 9H-AM-1006-02 | 09H | AM | 1006 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9697160572446 40.7711445570446) | 19 | 4 | 19 | 13 | |||||
6019 | 6019 | -73.9697160572446 | 40.7711445570446 | 9H-AM-1006-02 | 09H | AM | 1006 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9697160572446 40.7711445570446) | 19 | 4 | 19 | 13 | |||||
2286 | 2286 | -73.9693202078293 | 40.771043472925 | 9H-AM-1006-01 | 09H | AM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9693202078293 40.771043472925) | 19 | 4 | 19 | 13 | |||||
5309 | 5309 | -73.9693202078293 | 40.771043472925 | 9H-AM-1006-01 | 09H | AM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9693202078293 40.771043472925) | 19 | 4 | 19 | 13 | |||||
1042 | 1042 | -73.97063600052749 | 40.7717074044466 | 9G-PM-1007-05 | 09G | PM | 1007 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9706360005275 40.7717074044466) | 19 | 4 | 19 | 13 | |||||
4065 | 4065 | -73.97063600052749 | 40.7717074044466 | 9G-PM-1007-05 | 09G | PM | 1007 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9706360005275 40.7717074044466) | 19 | 4 | 19 | 13 | |||||
522 | 522 | -73.9707542189896 | 40.7717032986885 | 9G-PM-1007-04 | 09G | PM | 1007 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9707542189896 40.7717032986885) | 19 | 4 | 19 | 13 | |||||
3545 | 3545 | -73.9707542189896 | 40.7717032986885 | 9G-PM-1007-04 | 09G | PM | 1007 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9707542189896 40.7717032986885) | 19 | 4 | 19 | 13 | |||||
311 | 311 | -73.97123088643941 | 40.7714534847379 | 9G-AM-1007-04 | 09G | AM | 1007 | 4 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 0 | 0 | 0 | 0 | grooming | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9712308864394 40.7714534847379) | 19 | 4 | 19 | 13 | ||||
3334 | 3334 | -73.97123088643941 | 40.7714534847379 | 9G-AM-1007-04 | 09G | AM | 1007 | 4 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 0 | 0 | 0 | 0 | grooming | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9712308864394 40.7714534847379) | 19 | 4 | 19 | 13 | ||||
3014 | 3014 | -73.9714653576023 | 40.77174001395021 | 9F-AM-1013-03 | 09F | AM | 1013 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9714653576023 40.7717400139502) | 19 | 4 | 19 | 13 | |||||
6037 | 6037 | -73.9714653576023 | 40.77174001395021 | 9F-AM-1013-03 | 09F | AM | 1013 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9714653576023 40.7717400139502) | 19 | 4 | 19 | 13 | |||||
878 | 878 | -73.9728654439465 | 40.7724853142211 | 9E-AM-1008-04 | 09E | AM | 1008 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9728654439465 40.7724853142211) | 19 | 4 | 19 | 13 | |||||
3901 | 3901 | -73.9728654439465 | 40.7724853142211 | 9E-AM-1008-04 | 09E | AM | 1008 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9728654439465 40.7724853142211) | 19 | 4 | 19 | 13 | |||||
1960 | 1960 | -73.9729645190377 | 40.7723310150843 | 9E-AM-1008-02 | 09E | AM | 1008 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9729645190377 40.7723310150843) | 19 | 4 | 19 | 13 | |||||
4983 | 4983 | -73.9729645190377 | 40.7723310150843 | 9E-AM-1008-02 | 09E | AM | 1008 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9729645190377 40.7723310150843) | 19 | 4 | 19 | 13 | |||||
2561 | 2561 | -73.97469338525721 | 40.773313866931 | 9C-PM-1006-05 | 09C | PM | 1006 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | w/ dog | POINT (-73.9746933852572 40.773313866931) | 19 | 4 | 19 | 13 | ||||
5584 | 5584 | -73.97469338525721 | 40.773313866931 | 9C-PM-1006-05 | 09C | PM | 1006 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | w/ dog | POINT (-73.9746933852572 40.773313866931) | 19 | 4 | 19 | 13 | ||||
733 | 733 | -73.9754802138871 | 40.773300804411996 | 9C-PM-1006-03 | 09C | PM | 1006 | 3 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9754802138871 40.773300804412) | 19 | 4 | 19 | 13 | |||||
3756 | 3756 | -73.9754802138871 | 40.773300804411996 | 9C-PM-1006-03 | 09C | PM | 1006 | 3 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9754802138871 40.773300804412) | 19 | 4 | 19 | 13 | |||||
157 | 157 | -73.97553718499721 | 40.7733561233828 | 9C-PM-1006-02 | 09C | PM | 1006 | 2 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9755371849972 40.7733561233828) | 19 | 4 | 19 | 13 | |||||
3180 | 3180 | -73.97553718499721 | 40.7733561233828 | 9C-PM-1006-02 | 09C | PM | 1006 | 2 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9755371849972 40.7733561233828) | 19 | 4 | 19 | 13 | |||||
1736 | 1736 | -73.9760942252437 | 40.7742035674209 | 9B-PM-1013-07 | 09B | PM | 1013 | 7 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9760942252437 40.7742035674209) | 19 | 4 | 19 | 13 | |||||
4759 | 4759 | -73.9760942252437 | 40.7742035674209 | 9B-PM-1013-07 | 09B | PM | 1013 | 7 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9760942252437 40.7742035674209) | 19 | 4 | 19 | 13 | |||||
1733 | 1733 | -73.9761632586697 | 40.7741085606149 | 9B-PM-1013-05 | 09B | PM | 1013 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9761632586697 40.7741085606149) | 19 | 4 | 19 | 13 | |||||
4756 | 4756 | -73.9761632586697 | 40.7741085606149 | 9B-PM-1013-05 | 09B | PM | 1013 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9761632586697 40.7741085606149) | 19 | 4 | 19 | 13 | |||||
1412 | 1412 | -73.9761799699276 | 40.774213409933 | 9B-AM-1010-07 | 09B | AM | 1010 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9761799699276 40.774213409933) | 19 | 4 | 19 | 13 | |||||
4435 | 4435 | -73.9761799699276 | 40.774213409933 | 9B-AM-1010-07 | 09B | AM | 1010 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9761799699276 40.774213409933) | 19 | 4 | 19 | 13 | |||||
1606 | 1606 | -73.975198284551 | 40.7740343763399 | 9B-AM-1010-06 | 09B | AM | 1010 | 6 | Juvenile | Gray | White | Gray+White | Above Ground | 16.0 | tree | 0 | 0 | 1 | 0 | 0 | cleaning | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.975198284551 40.7740343763399) | 19 | 4 | 19 | 13 | |||
4629 | 4629 | -73.975198284551 | 40.7740343763399 | 9B-AM-1010-06 | 09B | AM | 1010 | 6 | Juvenile | Gray | White | Gray+White | Above Ground | 16.0 | tree | 0 | 0 | 1 | 0 | 0 | cleaning | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.975198284551 40.7740343763399) | 19 | 4 | 19 | 13 | |||
2550 | 2550 | -73.97506180080991 | 40.773752116709396 | 9B-AM-1010-05 | 09B | AM | 1010 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9750618008099 40.7737521167094) | 19 | 4 | 19 | 13 | |||||
5573 | 5573 | -73.97506180080991 | 40.773752116709396 | 9B-AM-1010-05 | 09B | AM | 1010 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9750618008099 40.7737521167094) | 19 | 4 | 19 | 13 | |||||
383 | 383 | -73.9768617690725 | 40.7741877060705 | 9A-PM-1010-03 | 09A | PM | 1010 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | froze - standing on hind legs for ~10 seconds then scampered off | POINT (-73.9768617690725 40.7741877060705) | 19 | 4 | 19 | 13 | |||||
3406 | 3406 | -73.9768617690725 | 40.7741877060705 | 9A-PM-1010-03 | 09A | PM | 1010 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | froze - standing on hind legs for ~10 seconds then scampered off | POINT (-73.9768617690725 40.7741877060705) | 19 | 4 | 19 | 13 | |||||
2080 | 2080 | -73.96904988769441 | 40.7700011818847 | 8I-AM-1006-07 | 08I | AM | 1006 | 7 | Adult | Gray | White | Gray+White | White ring on short tail | Above Ground | 20.0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690498876944 40.7700011818847) | 19 | 4 | 19 | 13 | ||||
5103 | 5103 | -73.96904988769441 | 40.7700011818847 | 8I-AM-1006-07 | 08I | AM | 1006 | 7 | Adult | Gray | White | Gray+White | White ring on short tail | Above Ground | 20.0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690498876944 40.7700011818847) | 19 | 4 | 19 | 13 | ||||
2861 | 2861 | -73.9694681803635 | 40.770585795359004 | 8I-AM-1006-06 | 08I | AM | 1006 | 6 | Adult | Gray | White | Gray+White | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694681803635 40.770585795359) | 19 | 4 | 19 | 13 | ||||||
5884 | 5884 | -73.9694681803635 | 40.770585795359004 | 8I-AM-1006-06 | 08I | AM | 1006 | 6 | Adult | Gray | White | Gray+White | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9694681803635 40.770585795359) | 19 | 4 | 19 | 13 | ||||||
436 | 436 | -73.9688438058715 | 40.7703014325728 | 8I-AM-1006-05 | 08I | AM | 1006 | 5 | Adult | Gray | White | Gray+White | Above Ground | 20.0 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9688438058715 40.7703014325728) | 19 | 4 | 19 | 13 | ||||
3459 | 3459 | -73.9688438058715 | 40.7703014325728 | 8I-AM-1006-05 | 08I | AM | 1006 | 5 | Adult | Gray | White | Gray+White | Above Ground | 20.0 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9688438058715 40.7703014325728) | 19 | 4 | 19 | 13 | ||||
1753 | 1753 | -73.9692401421068 | 40.7707128895661 | 8I-AM-1006-04 | 08I | AM | 1006 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9692401421068 40.7707128895661) | 19 | 4 | 19 | 13 | |||||
4776 | 4776 | -73.9692401421068 | 40.7707128895661 | 8I-AM-1006-04 | 08I | AM | 1006 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9692401421068 40.7707128895661) | 19 | 4 | 19 | 13 | |||||
1056 | 1056 | -73.9693772461788 | 40.770687589290105 | 8I-AM-1006-03 | 08I | AM | 1006 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9693772461788 40.7706875892901) | 19 | 4 | 19 | 13 | |||||
4079 | 4079 | -73.9693772461788 | 40.770687589290105 | 8I-AM-1006-03 | 08I | AM | 1006 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9693772461788 40.7706875892901) | 19 | 4 | 19 | 13 | |||||
1478 | 1478 | -73.9693876553956 | 40.7707232748402 | 8I-AM-1006-02 | 08I | AM | 1006 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9693876553956 40.7707232748402) | 19 | 4 | 19 | 13 | |||||
4501 | 4501 | -73.9693876553956 | 40.7707232748402 | 8I-AM-1006-02 | 08I | AM | 1006 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9693876553956 40.7707232748402) | 19 | 4 | 19 | 13 | |||||
575 | 575 | -73.9693209851947 | 40.7707450042769 | 8I-AM-1006-01 | 08I | AM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9693209851947 40.7707450042769) | 19 | 4 | 19 | 13 | |||||
3598 | 3598 | -73.9693209851947 | 40.7707450042769 | 8I-AM-1006-01 | 08I | AM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9693209851947 40.7707450042769) | 19 | 4 | 19 | 13 | |||||
2936 | 2936 | -73.970138810251 | 40.770579297644 | 8H-PM-1014-02 | 08H | PM | 1014 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | froze & watched me,then went back to eating | POINT (-73.970138810251 40.770579297644) | 19 | 4 | 19 | 13 | ||||
5959 | 5959 | -73.970138810251 | 40.770579297644 | 8H-PM-1014-02 | 08H | PM | 1014 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | froze & watched me,then went back to eating | POINT (-73.970138810251 40.770579297644) | 19 | 4 | 19 | 13 | ||||
1986 | 1986 | -73.9733966282316 | 40.7717179627127 | 8E-PM-1008-08 | 08E | PM | 1008 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9733966282316 40.7717179627127) | 19 | 4 | 19 | 13 | |||||
5009 | 5009 | -73.9733966282316 | 40.7717179627127 | 8E-PM-1008-08 | 08E | PM | 1008 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9733966282316 40.7717179627127) | 19 | 4 | 19 | 13 | |||||
2971 | 2971 | -73.9735120882106 | 40.7715915415169 | 8E-PM-1008-07 | 08E | PM | 1008 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9735120882106 40.7715915415169) | 19 | 4 | 19 | 13 | ||||
5994 | 5994 | -73.9735120882106 | 40.7715915415169 | 8E-PM-1008-07 | 08E | PM | 1008 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9735120882106 40.7715915415169) | 19 | 4 | 19 | 13 | ||||
2361 | 2361 | -73.9734654671008 | 40.7715988711659 | 8E-PM-1008-06 | 08E | PM | 1008 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9734654671008 40.7715988711659) | 19 | 4 | 19 | 13 | ||||
5384 | 5384 | -73.9734654671008 | 40.7715988711659 | 8E-PM-1008-06 | 08E | PM | 1008 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9734654671008 40.7715988711659) | 19 | 4 | 19 | 13 | ||||
2899 | 2899 | -73.9734695768004 | 40.7716297491384 | 8E-PM-1008-05 | 08E | PM | 1008 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9734695768004 40.7716297491384) | 19 | 4 | 19 | 13 | ||||
5922 | 5922 | -73.9734695768004 | 40.7716297491384 | 8E-PM-1008-05 | 08E | PM | 1008 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9734695768004 40.7716297491384) | 19 | 4 | 19 | 13 | ||||
2112 | 2112 | -73.9736418085696 | 40.7716931127716 | 8E-PM-1008-04 | 08E | PM | 1008 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | in grass by a grove of tall maples | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | there's a family playing soccer | POINT (-73.9736418085696 40.7716931127716) | 19 | 4 | 19 | 13 | |||
5135 | 5135 | -73.9736418085696 | 40.7716931127716 | 8E-PM-1008-04 | 08E | PM | 1008 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | in grass by a grove of tall maples | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | there's a family playing soccer | POINT (-73.9736418085696 40.7716931127716) | 19 | 4 | 19 | 13 | |||
1286 | 1286 | -73.973394428186 | 40.7722933513053 | 8E-PM-1008-03 | 08E | PM | 1008 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | in between 2 trees | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | also being lured by mom & baby w/ food | POINT (-73.973394428186 40.7722933513053) | 19 | 4 | 19 | 13 | |||
4309 | 4309 | -73.973394428186 | 40.7722933513053 | 8E-PM-1008-03 | 08E | PM | 1008 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | in between 2 trees | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | also being lured by mom & baby w/ food | POINT (-73.973394428186 40.7722933513053) | 19 | 4 | 19 | 13 | |||
2331 | 2331 | -73.9735946835545 | 40.7724155751282 | 8E-PM-1008-01 | 08E | PM | 1008 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by tree trunk base | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | eating food being thrown at it by a mom & baby | POINT (-73.9735946835545 40.7724155751282) | 19 | 4 | 19 | 13 | |||
5354 | 5354 | -73.9735946835545 | 40.7724155751282 | 8E-PM-1008-01 | 08E | PM | 1008 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by tree trunk base | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | eating food being thrown at it by a mom & baby | POINT (-73.9735946835545 40.7724155751282) | 19 | 4 | 19 | 13 | |||
273 | 273 | -73.975062146111 | 40.7723417173451 | 8C-PM-1013-07 | 08C | PM | 1013 | 7 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.975062146111 40.7723417173451) | 19 | 4 | 19 | 13 | ||||||
3296 | 3296 | -73.975062146111 | 40.7723417173451 | 8C-PM-1013-07 | 08C | PM | 1013 | 7 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.975062146111 40.7723417173451) | 19 | 4 | 19 | 13 | ||||||
1867 | 1867 | -73.97584649051329 | 40.77259574088411 | 8C-PM-1013-05 | 08C | PM | 1013 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9758464905133 40.7725957408841) | 19 | 4 | 19 | 13 | |||||
4890 | 4890 | -73.97584649051329 | 40.77259574088411 | 8C-PM-1013-05 | 08C | PM | 1013 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9758464905133 40.7725957408841) | 19 | 4 | 19 | 13 | |||||
1057 | 1057 | -73.9752000129992 | 40.773291812223896 | 8C-PM-1013-04 | 08C | PM | 1013 | 4 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9752000129992 40.7732918122239) | 19 | 4 | 19 | 13 | |||||
4080 | 4080 | -73.9752000129992 | 40.773291812223896 | 8C-PM-1013-04 | 08C | PM | 1013 | 4 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9752000129992 40.7732918122239) | 19 | 4 | 19 | 13 | |||||
1031 | 1031 | -73.9751056714758 | 40.7732060035215 | 8C-PM-1013-03 | 08C | PM | 1013 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9751056714758 40.7732060035215) | 19 | 4 | 19 | 13 | |||||
4054 | 4054 | -73.9751056714758 | 40.7732060035215 | 8C-PM-1013-03 | 08C | PM | 1013 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9751056714758 40.7732060035215) | 19 | 4 | 19 | 13 | |||||
347 | 347 | -73.9756557086441 | 40.773296289823996 | 8B-PM-1012-08 | 08B | PM | 1012 | 8 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9756557086441 40.773296289824) | 19 | 4 | 19 | 13 | |||||
3370 | 3370 | -73.9756557086441 | 40.773296289823996 | 8B-PM-1012-08 | 08B | PM | 1012 | 8 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9756557086441 40.773296289824) | 19 | 4 | 19 | 13 | |||||
15 | 15 | -73.97673696861709 | 40.7735074437085 | 8B-PM-1012-05 | 08B | PM | 1012 | 5 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9767369686171 40.7735074437085) | 19 | 4 | 19 | 13 | |||||
3038 | 3038 | -73.97673696861709 | 40.7735074437085 | 8B-PM-1012-05 | 08B | PM | 1012 | 5 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9767369686171 40.7735074437085) | 19 | 4 | 19 | 13 | |||||
2972 | 2972 | -73.9765064169087 | 40.7737211426714 | 8B-AM-1007-06 | 08B | AM | 1007 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9765064169087 40.7737211426714) | 19 | 4 | 19 | 13 | |||||
5995 | 5995 | -73.9765064169087 | 40.7737211426714 | 8B-AM-1007-06 | 08B | AM | 1007 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9765064169087 40.7737211426714) | 19 | 4 | 19 | 13 | |||||
689 | 689 | -73.976730206737 | 40.773709213913996 | 8A-PM-1014-01 | 08A | PM | 1014 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (goes up a tree) | POINT (-73.976730206737 40.773709213914) | 19 | 4 | 19 | 13 | ||||
3712 | 3712 | -73.976730206737 | 40.773709213913996 | 8A-PM-1014-01 | 08A | PM | 1014 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (goes up a tree) | POINT (-73.976730206737 40.773709213914) | 19 | 4 | 19 | 13 | ||||
1745 | 1745 | -73.9694979297007 | 40.769466740872105 | 7I-PM-1013-02 | 07I | PM | 1013 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Construction materials | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9694979297007 40.7694667408721) | 19 | 4 | 19 | 13 | ||||
4768 | 4768 | -73.9694979297007 | 40.769466740872105 | 7I-PM-1013-02 | 07I | PM | 1013 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Construction materials | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9694979297007 40.7694667408721) | 19 | 4 | 19 | 13 | ||||
1120 | 1120 | -73.97029709193171 | 40.7696883113413 | 7H-PM-1006-08 | 07H | PM | 1006 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | in grass | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | POINT (-73.9702970919317 40.7696883113413) | 19 | 4 | 19 | 13 | ||||
4143 | 4143 | -73.97029709193171 | 40.7696883113413 | 7H-PM-1006-08 | 07H | PM | 1006 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | in grass | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | POINT (-73.9702970919317 40.7696883113413) | 19 | 4 | 19 | 13 | ||||
1007 | 1007 | -73.9722265046794 | 40.7700916895929 | 7G-PM-1018-02 | 07G | PM | 1018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9722265046794 40.7700916895929) | 19 | 4 | 19 | 13 | |||||
4030 | 4030 | -73.9722265046794 | 40.7700916895929 | 7G-PM-1018-02 | 07G | PM | 1018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9722265046794 40.7700916895929) | 19 | 4 | 19 | 13 | |||||
1909 | 1909 | -73.97223594012421 | 40.7702891474555 | 7G-AM-1010-07 | 07G | AM | 1010 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9722359401242 40.7702891474555) | 19 | 4 | 19 | 13 | |||||
4932 | 4932 | -73.97223594012421 | 40.7702891474555 | 7G-AM-1010-07 | 07G | AM | 1010 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9722359401242 40.7702891474555) | 19 | 4 | 19 | 13 |
JSON shape: default, array, newline-delimited
CREATE TABLE "2018_Central_Park_Squirrel_Census" ( "Longitude" REAL, "Latitude" REAL, "Unique_Squirrel_ID" TEXT, "Hectare" TEXT, "Shift" TEXT, "Date" INTEGER, "Hectare_Squirrel_Number" INTEGER, "Age" REAL, "Primary_Fur_Color" REAL, "Highlight_Fur_Color" REAL, "Combination_of_Primary_and_Highlight_Color" TEXT, "Color_notes" REAL, "Location" REAL, "Above_Ground_Sighter_Measurement" REAL, "Specific_Location" REAL, "Running" INTEGER, "Chasing" INTEGER, "Climbing" INTEGER, "Eating" INTEGER, "Foraging" INTEGER, "Other_Activities" REAL, "Kuks" INTEGER, "Quaas" INTEGER, "Moans" INTEGER, "Tail_flags" INTEGER, "Tail_twitches" INTEGER, "Approaches" INTEGER, "Indifferent" INTEGER, "Runs_from" INTEGER, "Other_Interactions" REAL, "Latlong" TEXT, "Zip_Codes" REAL, "Community_Districts" INTEGER, "Borough_Boundaries" INTEGER, "City_Council_Districts" INTEGER, "Police_Precincts" INTEGER )