This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2166 | 2166 | -73.9711178122133 | 40.7672642958437 | 4I-PM-1007-01 | 04I | PM | 10072018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9711178122133 40.76726429584371) | 19 | 4 | 19 | 13 | ||||||
2181 | 2181 | -73.9702530172652 | 40.7736241205021 | 11F-AM-1013-01 | 11F | AM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9702530172652 40.7736241205021) | 19 | 4 | 19 | 13 | ||||||
2224 | 2224 | -73.9662310606968 | 40.7747758221226 | 14I-AM-1013-01 | 14I | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9662310606968 40.7747758221226) | 19 | 4 | 19 | 13 | |||||
2235 | 2235 | -73.9748522796455 | 40.7719586621003 | 7D-PM-1010-01 | 07D | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | outside fenced hectare | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9748522796455 40.7719586621003) | 19 | 4 | 19 | 13 | ||||
2275 | 2275 | -73.9614218413356 | 40.7938945058793 | 34B-AM-1013-01 | 34B | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | hopping | false | false | false | false | true | true | false | false | POINT (-73.9614218413356 40.7938945058793) | 19 | 4 | 19 | 13 | ||||
2278 | 2278 | -73.964539031099 | 40.7809916310012 | 20G-PM-1013-01 | 20G | PM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.964539031099 40.7809916310012) | 19 | 4 | 19 | 13 | |||||
2294 | 2294 | -73.9630820577441 | 40.7821632293136 | 22G-PM-1018-01 | 22G | PM | 10182018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | true | false | false | false | false | true | false | false | true | false | POINT (-73.9630820577441 40.7821632293136) | 19 | 4 | 19 | 13 | ||||
2313 | 2313 | -73.9646174034945 | 40.7781287528262 | 18H-AM-1018-01 | 18H | AM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Running from one tree to the other | true | true | false | false | false | playing? | false | false | false | false | false | false | false | false | POINT (-73.9646174034945 40.7781287528262) | 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 | |||
2324 | 2324 | -73.9737247632185 | 40.7759469280872 | 12C-PM-1017-01 | 12C | PM | 10172018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | digging/burying,drinking from lake | false | false | false | false | true | false | true | false | POINT (-73.9737247632185 40.7759469280872) | 19 | 4 | 19 | 13 | ||||
2371 | 2371 | -73.9769520212123 | 40.774006725863 | 9A-AM-1013-01 | 09A | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9769520212123 40.774006725863) | 19 | 4 | 19 | 13 | |||||
2423 | 2423 | -73.973552877209 | 40.7715638228207 | 7E-PM-1013-01 | 07E | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Ground & Tree Base | true | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.973552877209 40.7715638228207) | 19 | 4 | 19 | 13 | ||||
2424 | 2424 | -73.9684752839242 | 40.7765816261518 | 15F-AM-1007-01 | 15F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | true | POINT (-73.9684752839242 40.7765816261518) | 19 | 4 | 19 | 13 | ||||
2436 | 2436 | -73.95827701417 | 40.7856610238891 | 28I-PM-1007-01 | 28I | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.95827701417 40.7856610238891) | 19 | 4 | 19 | 13 | ||||||
2460 | 2460 | -73.9526681107152 | 40.7977012009146 | 42F-PM-1017-01 | 42F | PM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | playing | false | false | false | false | false | false | true | false | POINT (-73.9526681107152 40.7977012009146) | 19 | 4 | 19 | 13 | ||||
2466 | 2466 | -73.9599419926299 | 40.7972774728811 | 38A-AM-1019-01 | 38A | AM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9599419926299 40.7972774728811) | 19 | 4 | 19 | 13 | ||||||
2469 | 2469 | -73.9600963639087 | 40.7934962325313 | 34C-AM-1007-01 | 34C | AM | 10072018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | dog | POINT (-73.9600963639087 40.7934962325313) | 19 | 4 | 19 | 13 | |||||
2495 | 2495 | -73.9621253644004 | 40.7912082086879 | 31C-AM-1017-01 | 31C | AM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 8 | true | false | true | true | false | false | false | false | false | true | false | false | true | POINT (-73.9621253644004 40.7912082086879) | 19 | 4 | 19 | 13 | |||||
2508 | 2508 | -73.979381450452 | 40.7709033697887 | 4A-PM-1007-01 | 04A | PM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | true | true | false | false | false | false | true | false | true | false | POINT (-73.979381450452 40.770903369788705) | 19 | 4 | 19 | 13 | |||||
2522 | 2522 | -73.9658747245917 | 40.7754033737532 | 14I-PM-1018-01 | 14I | PM | 10182018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Fallen branch | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9658747245917 40.7754033737532) | 19 | 4 | 19 | 13 | |||||
2530 | 2530 | -73.9561076824455 | 40.7981145780509 | 40D-AM-1013-01 | 40D | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9561076824455 40.7981145780509) | 19 | 4 | 19 | 13 | |||||
2545 | 2545 | -73.9617594316752 | 40.7946803725236 | 35A-AM-1014-01 | 35A | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9617594316752 40.7946803725236) | 19 | 4 | 19 | 13 | |||||
2546 | 2546 | -73.9660267365885 | 40.776444395505 | 16H-AM-1007-01 | 16H | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9660267365885 40.776444395505) | 19 | 4 | 19 | 13 | ||||||
2570 | 2570 | -73.9721064150173 | 40.7667053821991 | 3I-AM-1010-01 | 03I | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9721064150173 40.7667053821991) | 19 | 4 | 19 | 13 | ||||||
2583 | 2583 | -73.9769693140651 | 40.7684390015166 | 3D-AM-1006-01 | 03D | AM | 10062018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 9 | up a tree | true | false | true | true | true | digging (?) | false | false | false | true | false | false | false | true | runs from (man led his dog into the area to chase squirrel) | POINT (-73.9769693140651 40.7684390015166) | 19 | 4 | 19 | 13 | ||
2585 | 2585 | -73.9771726831497 | 40.7732320781799 | 8A-AM-1013-01 | 08A | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | trail | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9771726831497 40.7732320781799) | 19 | 4 | 19 | 13 | ||||
2609 | 2609 | -73.9596865318094 | 40.7893787188526 | 31F-AM-1013-01 | 31F | AM | 10132018 | 1 | Adult | Gray | Black | Gray+Black | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9596865318094 40.7893787188526) | 19 | 4 | 19 | 13 | |||||
2621 | 2621 | -73.9596904740342 | 40.7897200025671 | 31E-AM-1014-01 | 31E | AM | 10142018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9596904740342 40.7897200025671) | 19 | 4 | 19 | 13 | ||||||
2627 | 2627 | -73.9766348078633 | 40.7717715634438 | 7C-AM-1012-01 | 07C | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | hopping around grass | false | false | false | false | false | false | true | false | POINT (-73.9766348078633 40.7717715634438) | 19 | 4 | 19 | 13 | ||||
2629 | 2629 | -73.9604576237503 | 40.7818120101394 | 23I-PM-1019-01 | 23I | PM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 35 | true | false | false | false | false | running (across branches) | false | false | false | false | false | false | false | false | POINT (-73.9604576237503 40.7818120101394) | 19 | 4 | 19 | 13 | |||||
2647 | 2647 | -73.954499539822 | 40.7949716693686 | 38F-AM-1018-01 | 38F | AM | 10182018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.954499539822 40.7949716693686) | 19 | 4 | 19 | 13 | |||||
2652 | 2652 | -73.9620542514749 | 40.7943731722138 | 34A-AM-1012-01 | 34A | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | chasing from tree to ground | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9620542514749 40.7943731722138) | 19 | 4 | 19 | 13 | ||||
2655 | 2655 | -73.9659156108069 | 40.7810709818696 | 20E-AM-1014-01 | 20E | AM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | false | false | POINT (-73.9659156108069 40.7810709818696) | 19 | 4 | 19 | 13 | |||||
2673 | 2673 | -73.9768867959365 | 40.7734803954589 | 8B-PM-1012-01 | 08B | PM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9768867959365 40.7734803954589) | 19 | 4 | 19 | 13 | |||||
2678 | 2678 | -73.9562946873694 | 40.7938593012595 | 36F-AM-1017-01 | 36F | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.9562946873694 40.7938593012595) | 19 | 4 | 19 | 13 | |||||
2682 | 2682 | -73.9711001278389 | 40.7787466095841 | 15C-PM-1017-01 | 15C | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9711001278389 40.7787466095841) | 19 | 4 | 19 | 13 | |||||
2691 | 2691 | -73.9564599077179 | 40.7965185098695 | 39D-PM-1012-01 | 39D | PM | 10122018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9564599077179 40.7965185098695) | 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 | |||||
2755 | 2755 | -73.9712022111028 | 40.7672504368263 | 4I-AM-1006-01 | 04I | AM | 10062018 | 1 | Adult | Black | Black+ | Above Ground | 3 | On top of park lamp | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9712022111028 40.7672504368263) | 19 | 4 | 19 | 13 | |||||
2758 | 2758 | -73.9542074814296 | 40.7954322240004 | 39F-AM-1014-01 | 39F | AM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9542074814296 40.7954322240004) | 19 | 4 | 19 | 13 | |||||
2768 | 2768 | -73.9641088172632 | 40.7886555184212 | 28C-AM-1014-01 | 28C | AM | 10142018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9641088172632 40.7886555184212) | 19 | 4 | 19 | 13 | ||||||
2794 | 2794 | -73.9712187890707 | 40.7750640173134 | 12E-PM-1018-01 | 12E | PM | 10182018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | true | false | false | true | false | false | true | false | false | false | true | POINT (-73.9712187890707 40.7750640173134) | 19 | 4 | 19 | 13 | |||||
2835 | 2835 | -73.9531953594918 | 40.7960413520131 | 40G-PM-1013-01 | 40G | PM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9531953594918 40.7960413520131) | 19 | 4 | 19 | 13 | ||||||
2849 | 2849 | -73.9709912560997 | 40.7758965595198 | 13D-AM-1014-01 | 13D | AM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9709912560997 40.7758965595198) | 19 | 4 | 19 | 13 | |||||
2861 | 2861 | -73.9720102361126 | 40.7692143930301 | 6G-PM-1020-01 | 06G | PM | 10202018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9720102361126 40.7692143930301) | 19 | 4 | 19 | 13 | ||||||
2900 | 2900 | -73.9631005470369 | 40.7885494057193 | 28D-AM-1012-01 | 28D | AM | 10122018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9631005470369 40.7885494057193) | 19 | 4 | 19 | 13 | |||||
2905 | 2905 | -73.9784872728213 | 40.7688122603932 | 3C-AM-1007-01 | 03C | AM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9784872728213 40.7688122603932) | 19 | 4 | 19 | 13 | |||||
2920 | 2920 | -73.9657391918196 | 40.776502470347 | 16H-PM-1014-01 | 16H | PM | 10142018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9657391918196 40.776502470347) | 19 | 4 | 19 | 13 | |||||
2998 | 2998 | -73.9752079247419 | 40.7755376979002 | 11B-AM-1007-01 | 11B | AM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | true | false | false | POINT (-73.9752079247419 40.7755376979002) | 19 | 4 | 19 | 13 | |||||
316 | 316 | -73.9540616660191 | 40.7951556603245 | 38G-PM-1020-10 | 38G | PM | 10202018 | 10 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9540616660191 40.7951556603245) | 19 | 4 | 19 | 13 | |||||
922 | 922 | -73.9708002461415 | 40.7726685284831 | 10F-PM-1019-10 | 10F | PM | 10192018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Arbor path & hill w/ bushes | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9708002461415 40.7726685284831) | 19 | 4 | 19 | 13 | ||||
1070 | 1070 | -73.9674631254594 | 40.7790076357696 | 17E-AM-1017-10 | 17E | AM | 10172018 | 10 | Juvenile | Gray | Gray+ | Above Ground | 2 | Fence | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9674631254594 40.7790076357696) | 19 | 4 | 19 | 13 | |||||
1081 | 1081 | -73.9680855277775 | 40.7769251965381 | 15F-AM-1007-10 | 15F | AM | 10072018 | 10 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9680855277775 40.7769251965381) | 19 | 4 | 19 | 13 | |||||
1192 | 1192 | -73.9634811495245 | 40.790705585077 | 30B-AM-1007-10 | 30B | AM | 10072018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | false | false | false | true | POINT (-73.9634811495245 40.790705585077) | 19 | 4 | 19 | 13 | ||||||
1381 | 1381 | -73.9586077039567 | 40.7961896477077 | 38C-AM-1019-10 | 38C | AM | 10192018 | 10 | Adult | Gray | White | Gray+White | Above Ground | 20 | true | false | true | true | false | true | false | false | false | true | false | false | true | POINT (-73.9586077039567 40.7961896477077) | 19 | 4 | 19 | 13 | |||||
1469 | 1469 | -73.9704831177035 | 40.7699878995692 | 7H-AM-1006-10 | 07H | AM | 10062018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9704831177035 40.7699878995692) | 19 | 4 | 19 | 13 | |||||
1602 | 1602 | -73.9728836727349 | 40.770815850599 | 7F-AM-1008-10 | 07F | AM | 10082018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9728836727349 40.770815850599) | 19 | 4 | 19 | 13 | ||||||
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 | |||||
1996 | 1996 | -73.977641787698 | 40.7695830265784 | 4C-PM-1010-10 | 04C | PM | 10102018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.977641787698 40.7695830265784) | 19 | 4 | 19 | 13 | |||||
2177 | 2177 | -73.9758211560957 | 40.7693422860766 | 5E-AM-1008-10 | 05E | AM | 10082018 | 10 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | up a tree | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9758211560957 40.7693422860766) | 19 | 4 | 19 | 13 | ||||
2558 | 2558 | -73.9749469566854 | 40.7667805367199 | 2F-PM-1014-10 | 02F | PM | 10142018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9749469566854 40.7667805367199) | 19 | 4 | 19 | 13 | |||||
2810 | 2810 | -73.9614659899028 | 40.7945562907624 | 35A-PM-1013-10 | 35A | PM | 10132018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9614659899028 40.7945562907624) | 19 | 4 | 19 | 13 | |||||
2897 | 2897 | -73.9689554458632 | 40.7778593393957 | 16E-PM-1018-10 | 16E | PM | 10182018 | 10 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9689554458632 40.7778593393957) | 19 | 4 | 19 | 13 | |||||
596 | 596 | -73.9769319450348 | 40.7743883576247 | 9A-AM-1013-11 | 09A | AM | 10132018 | 11 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | foot of tree | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9769319450348 40.7743883576247) | 19 | 4 | 19 | 13 | ||||
678 | 678 | -73.977447585355 | 40.7697167828003 | 4C-PM-1010-11 | 04C | PM | 10102018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.977447585355 40.7697167828003) | 19 | 4 | 19 | 13 | |||||
683 | 683 | -73.9707683621584 | 40.7759815566123 | 13E-AM-1017-11 | 13E | AM | 10172018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on/in log | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9707683621584 40.77598155661231) | 19 | 4 | 19 | 13 | |||||
1229 | 1229 | -73.9677751507448 | 40.7790990066658 | 17E-AM-1017-11 | 17E | AM | 10172018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | Shore | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9677751507448 40.7790990066658) | 19 | 4 | 19 | 13 | |||||
1278 | 1278 | -73.9729848996456 | 40.7707143294261 | 7F-AM-1008-11 | 07F | AM | 10082018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9729848996456 40.7707143294261) | 19 | 4 | 19 | 13 | ||||||
1410 | 1410 | -73.9587913289229 | 40.7961707624534 | 38C-AM-1019-11 | 38C | AM | 10192018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 20 | true | false | true | true | false | true | false | false | false | true | false | false | true | POINT (-73.9587913289229 40.7961707624534) | 19 | 4 | 19 | 13 | |||||
1913 | 1913 | -73.9774630821854 | 40.7680626674086 | 3D-PM-1010-11 | 03D | PM | 10102018 | 11 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9774630821854 40.76806266740861) | 19 | 4 | 19 | 13 | |||||
2672 | 2672 | -73.9614599022015 | 40.7945181285991 | 35A-PM-1013-11 | 35A | PM | 10132018 | 11 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9614599022015 40.7945181285991) | 19 | 4 | 19 | 13 | ||||||
176 | 176 | -73.9618064639153 | 40.792158440043 | 32C-PM-1013-12 | 32C | PM | 10132018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | true | false | false | POINT (-73.9618064639153 40.792158440043) | 19 | 4 | 19 | 13 | ||||||
181 | 181 | -73.9708775864433 | 40.772473633538 | 10F-PM-1019-12 | 10F | PM | 10192018 | 12 | Adult | Black | White | Black+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9708775864433 40.772473633538) | 19 | 4 | 19 | 13 | |||||
392 | 392 | -73.9802376131034 | 40.7680707516627 | 1B-AM-1012-12 | 01B | AM | 10122018 | 12 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9802376131034 40.7680707516627) | 19 | 4 | 19 | 13 | |||||
514 | 514 | -73.9768357173861 | 40.7683813358343 | 3D-PM-1010-12 | 03D | PM | 10102018 | 12 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | true | false | false | true | false | true | false | false | false | false | false | false | POINT (-73.9768357173861 40.7683813358343) | 19 | 4 | 19 | 13 | |||||
583 | 583 | -73.9612398509782 | 40.7950033150385 | 35A-PM-1013-12 | 35A | PM | 10132018 | 12 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9612398509782 40.7950033150385) | 19 | 4 | 19 | 13 | |||||
969 | 969 | -73.9773529368499 | 40.7728750685699 | 7B-AM-1008-12 | 07B | AM | 10082018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9773529368499 40.7728750685699) | 19 | 4 | 19 | 13 | ||||||
974 | 974 | -73.9753744539307 | 40.7671162211032 | 2F-PM-1014-12 | 02F | PM | 10142018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.97537445393071 40.7671162211032) | 19 | 4 | 19 | 13 | ||||||
1287 | 1287 | -73.9763236949008 | 40.7686815615335 | 4D-PM-1008-12 | 04D | PM | 10082018 | 12 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | true | false | false | false | false | was chased by # 11 | true | false | false | false | false | false | false | true | POINT (-73.9763236949008 40.7686815615335) | 19 | 4 | 19 | 13 | ||||
1567 | 1567 | -73.9774407362587 | 40.7698056129554 | 4C-PM-1010-12 | 04C | PM | 10102018 | 12 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9774407362587 40.7698056129554) | 19 | 4 | 19 | 13 | |||||
2919 | 2919 | -73.9768563402344 | 40.7744487310786 | 9A-AM-1013-12 | 09A | AM | 10132018 | 12 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | foot of tree | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9768563402344 40.7744487310786) | 19 | 4 | 19 | 13 | ||||
1376 | 1376 | -73.9773361580792 | 40.7729478226715 | 7B-AM-1008-13 | 07B | AM | 10082018 | 13 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9773361580792 40.7729478226715) | 19 | 4 | 19 | 13 | |||||
1565 | 1565 | -73.9803895322385 | 40.7680730789944 | 1B-AM-1012-13 | 01B | AM | 10122018 | 13 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9803895322385 40.7680730789944) | 19 | 4 | 19 | 13 | |||||
1575 | 1575 | -73.9703169373939 | 40.7700658823854 | 7H-AM-1006-13 | 07H | AM | 10062018 | 13 | Adult | Gray | Gray+ | Above Ground | 10 | true | false | false | false | false | running (up tree) | false | false | false | false | false | false | true | false | POINT (-73.9703169373939 40.7700658823854) | 19 | 4 | 19 | 13 | |||||
1646 | 1646 | -73.9669782832746 | 40.7841166727168 | 22C-PM-1006-13 | 22C | PM | 10062018 | 13 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9669782832746 40.7841166727168) | 19 | 4 | 19 | 13 | ||||||
1756 | 1756 | -73.9755041276839 | 40.7678213857557 | 3F-AM-1006-13 | 03F | AM | 10062018 | 13 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9755041276839 40.7678213857557) | 19 | 4 | 19 | 13 | |||||
2628 | 2628 | -73.9770439076963 | 40.7685720141731 | 3D-PM-1010-13 | 03D | PM | 10102018 | 13 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9770439076963 40.7685720141731) | 19 | 4 | 19 | 13 | |||||
2644 | 2644 | -73.9775445441194 | 40.7697096533728 | 4C-PM-1010-13 | 04C | PM | 10102018 | 13 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9775445441194 40.7697096533728) | 19 | 4 | 19 | 13 | |||||
2648 | 2648 | -73.9729410488021 | 40.7709484964577 | 7F-AM-1008-13 | 07F | AM | 10082018 | 13 | Adult | Gray | Gray+ | Above Ground | 4 | to tree | true | false | false | true | true | ran up tree 4 feet and ate leaves | false | false | false | false | false | false | true | false | POINT (-73.9729410488021 40.7709484964577) | 19 | 4 | 19 | 13 | ||||
1822 | 1822 | -73.9775099290913 | 40.7697609063137 | 4C-PM-1010-14 | 04C | PM | 10102018 | 14 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | true | false | false | false | chasing #15 | false | false | false | false | false | false | false | false | POINT (-73.9775099290913 40.7697609063137) | 19 | 4 | 19 | 13 | ||||
1905 | 1905 | -73.9691968748482 | 40.7765862996192 | 14E-AM-1008-14 | 14E | AM | 10082018 | 14 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9691968748482 40.7765862996192) | 19 | 4 | 19 | 13 | ||||||
2811 | 2811 | -73.9756889766089 | 40.7676078308589 | 3F-AM-1006-14 | 03F | AM | 10062018 | 14 | Adult | Gray | White | Gray+White | Above Ground | 12 | true | false | true | false | false | running from dog | false | false | false | false | false | false | false | true | POINT (-73.9756889766089 40.7676078308589) | 19 | 4 | 19 | 13 | ||||
2822 | 2822 | -73.9711120079542 | 40.7760801911766 | 13D-PM-1018-14 | 13D | PM | 10182018 | 14 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | true | false | false | climbing (down) | false | false | false | false | false | false | true | false | POINT (-73.9711120079542 40.7760801911766) | 19 | 4 | 19 | 13 | ||||
1470 | 1470 | -73.9724806580638 | 40.7710077206132 | 7F-AM-1008-15 | 07F | AM | 10082018 | 15 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9724806580638 40.7710077206132) | 19 | 4 | 19 | 13 | ||||||
2715 | 2715 | -73.9710273070712 | 40.7766521246153 | 14D-PM-1019-16 | 14D | PM | 10192018 | 16 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9710273070712 40.7766521246153) | 19 | 4 | 19 | 13 | |||||
2574 | 2574 | -73.978199543688 | 40.7695660563362 | 4C-PM-1010-17 | 04C | PM | 10102018 | 17 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | climbed up tree | true | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.978199543688 40.7695660563362) | 19 | 4 | 19 | 13 | ||||
7 | 7 | -73.9719735582476 | 40.7693045133578 | 6G-PM-1020-02 | 06G | PM | 10202018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9719735582476 40.7693045133578) | 19 | 4 | 19 | 13 | ||||||
43 | 43 | -73.9574648097543 | 40.7892508428622 | 31H-PM-1008-02 | 31H | PM | 10082018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | true | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9574648097543 40.78925084286221) | 19 | 4 | 19 | 13 | |||||
95 | 95 | -73.9692883970928 | 40.7768553703082 | 14E-AM-1008-02 | 14E | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | walking | false | false | false | false | false | false | false | true | POINT (-73.9692883970928 40.7768553703082) | 19 | 4 | 19 | 13 | |||||
110 | 110 | -73.9711318790279 | 40.7701941550273 | 7G-AM-1010-02 | 07G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9711318790279 40.7701941550273) | 19 | 4 | 19 | 13 |
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 );