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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
598 | 598 | -73.9698196671161 | 40.7802972001469 | 18C-PM-1018-03 | 18C | PM | 10182018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 1 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9698196671161 40.7802972001469) | 19 | 4 | 19 | 13 | ||||||
2937 | 2937 | -73.9683460607021 | 40.7805408447877 | 18D-AM-1018-03 | 18D | AM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9683460607021 40.7805408447877) | 19 | 4 | 19 | 13 | ||||||
2041 | 2041 | -73.9651796685091 | 40.7785578267586 | 18G-AM-1014-03 | 18G | AM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9651796685091 40.7785578267586) | 19 | 4 | 19 | 13 | |||||
1200 | 1200 | -73.9657721715305 | 40.778534830257 | 18G-PM-1013-03 | 18G | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9657721715305 40.778534830257) | 19 | 4 | 19 | 13 | ||||||
614 | 614 | -73.9642411990432 | 40.7779692777193 | 18H-PM-1014-03 | 18H | PM | 10142018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9642411990432 40.7779692777193) | 19 | 4 | 19 | 13 | |||||
358 | 358 | -73.9635658786416 | 40.7777291777901 | 18I-AM-1017-03 | 18I | AM | 10172018 | 3 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9635658786416 40.77772917779011) | 19 | 4 | 19 | 13 | |||||
1680 | 1680 | -73.9638167248251 | 40.7776485679354 | 18I-PM-1007-03 | 18I | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 25 | false | false | true | false | false | false | false | false | false | false | false | false | false | stared at me | POINT (-73.9638167248251 40.77764856793541) | 19 | 4 | 19 | 13 | ||||
992 | 992 | -73.9708083587471 | 40.7825429441583 | 19A-PM-1013-03 | 19A | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9708083587471 40.7825429441583) | 19 | 4 | 19 | 13 | ||||||
2082 | 2082 | -73.9696802053043 | 40.7816057406125 | 19B-PM-1018-03 | 19B | PM | 10182018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9696802053043 40.7816057406125) | 19 | 4 | 19 | 13 | ||||
1393 | 1393 | -73.9687134137786 | 40.7812207913391 | 19C-PM-1018-03 | 19C | PM | 10182018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9687134137786 40.7812207913391) | 19 | 4 | 19 | 13 | |||||
1863 | 1863 | -73.9682830510954 | 40.7810151087286 | 19D-PM-1008-03 | 19D | PM | 10082018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | may be same squirrel as #1 - male | Above Ground | 5 | on branch of dead tree | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9682830510954 40.7810151087286) | 19 | 4 | 19 | 13 | |||
2188 | 2188 | -73.9676113345824 | 40.7803482448467 | 19E-PM-1018-03 | 19E | PM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | Baseball field #3 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9676113345824 40.7803482448467) | 19 | 4 | 19 | 13 | |||||
954 | 954 | -73.9658443548822 | 40.7796704898979 | 19F-AM-1007-03 | 19F | AM | 10072018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | false | scared | POINT (-73.9658443548822 40.7796704898979) | 19 | 4 | 19 | 13 | |||||
723 | 723 | -73.9654397484763 | 40.7798863522904 | 19F-PM-1017-03 | 19F | PM | 10172018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9654397484763 40.7798863522904) | 19 | 4 | 19 | 13 | |||||
461 | 461 | -73.9648195433192 | 40.7796399955868 | 19G-PM-1017-03 | 19G | PM | 10172018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | true | true | false | staring | false | false | false | false | true | false | false | false | POINT (-73.9648195433192 40.7796399955868) | 19 | 4 | 19 | 13 | |||||
2471 | 2471 | -73.964274290774 | 40.7795319556023 | 19H-AM-1010-03 | 19H | AM | 10102018 | 3 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | true | false | ran from human w/ dog | POINT (-73.964274290774 40.7795319556023) | 19 | 4 | 19 | 13 | ||||
2491 | 2491 | -73.9806905259671 | 40.7681152210858 | 1A-AM-1007-03 | 01A | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | looking in bush | false | false | false | false | false | false | true | false | POINT (-73.9806905259671 40.7681152210858) | 19 | 4 | 19 | 13 | ||||
2055 | 2055 | -73.9806928007664 | 40.768255422025 | 1A-PM-1014-03 | 01A | PM | 10142018 | 3 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9806928007664 40.768255422025) | 19 | 4 | 19 | 13 | |||||
2211 | 2211 | -73.9799250782277 | 40.7676106598889 | 1B-AM-1012-03 | 01B | AM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.97992507822771 40.7676106598889) | 19 | 4 | 19 | 13 | |||||
2865 | 2865 | -73.9802842404016 | 40.7678257384977 | 1B-PM-1019-03 | 01B | PM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | in tree | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.98028424040162 40.7678257384977) | 19 | 4 | 19 | 13 | ||||
2138 | 2138 | -73.9791536183194 | 40.7672705931866 | 1C-PM-1013-03 | 01C | PM | 10132018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9791536183194 40.7672705931866) | 19 | 4 | 19 | 13 | |||||
2539 | 2539 | -73.9781033448468 | 40.7666724066213 | 1D-AM-1006-03 | 01D | AM | 10062018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9781033448468 40.7666724066213) | 19 | 4 | 19 | 13 | |||||
575 | 575 | -73.9783366903829 | 40.7668300056094 | 1D-PM-1007-03 | 01D | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9783366903829 40.7668300056094) | 19 | 4 | 19 | 13 | |||||
1160 | 1160 | -73.9777256989362 | 40.766623699564 | 1E-AM-1006-03 | 01E | AM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9777256989362 40.766623699564) | 19 | 4 | 19 | 13 | ||||||
2686 | 2686 | -73.9775571403892 | 40.7665316585198 | 1E-PM-1007-03 | 01E | PM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9775571403892 40.7665316585198) | 19 | 4 | 19 | 13 | ||||||
1254 | 1254 | -73.9764013589865 | 40.7663063499207 | 1F-PM-1019-03 | 01F | PM | 10192018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 1 | false | false | false | false | false | hiding | false | false | false | false | false | false | false | false | POINT (-73.9764013589865 40.7663063499207) | 19 | 4 | 19 | 13 | |||||
1892 | 1892 | -73.9745908987975 | 40.7655191512308 | 1G-AM-1006-03 | 01G | AM | 10062018 | 3 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9745908987975 40.7655191512308) | 19 | 4 | 19 | 13 | |||||
2957 | 2957 | -73.9747313152152 | 40.7653888351839 | 1G-PM-1010-03 | 01G | PM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9747313152152 40.7653888351839) | 19 | 4 | 19 | 13 | |||||
2852 | 2852 | -73.9728146482385 | 40.7652951714745 | 1I-PM-1012-03 | 01I | PM | 10122018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Black, & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.97281464823851 40.765295171474506) | 19 | 4 | 19 | 13 | ||||
1126 | 1126 | -73.9700186001049 | 40.7826052184658 | 20B-AM-1007-03 | 20B | AM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9700186001049 40.7826052184658) | 19 | 4 | 19 | 13 | ||||||
2571 | 2571 | -73.9695468150218 | 40.7821142051746 | 20B-PM-1013-03 | 20B | PM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9695468150218 40.7821142051746) | 19 | 4 | 19 | 13 | |||||
2853 | 2853 | -73.9678613185071 | 40.7822170887526 | 20C-PM-1018-03 | 20C | PM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9678613185071 40.7822170887526) | 19 | 4 | 19 | 13 | ||||||
1355 | 1355 | -73.9655277320465 | 40.7806120529369 | 20F-AM-1014-03 | 20F | AM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9655277320465 40.7806120529369) | 19 | 4 | 19 | 13 | ||||||
2518 | 2518 | -73.9647219419257 | 40.7812084402932 | 20F-PM-1007-03 | 20F | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | gray on haunches white on tail | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9647219419257 40.7812084402932) | 19 | 4 | 19 | 13 | ||||
1420 | 1420 | -73.9647605121306 | 40.7803961531517 | 20G-AM-1018-03 | 20G | AM | 10182018 | 3 | Adult | Gray | Gray+ | Above Ground | 12 | in tree | true | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9647605121306 40.7803961531517) | 19 | 4 | 19 | 13 | |||||
1967 | 1967 | -73.9647247254127 | 40.7806136565784 | 20G-PM-1013-03 | 20G | PM | 10132018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | true | false | false | false | true | POINT (-73.9647247254127 40.7806136565784) | 19 | 4 | 19 | 13 | |||||
1912 | 1912 | -73.9698064901149 | 40.7842538115839 | 21A-AM-1019-03 | 21A | AM | 10192018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | Tree & ground | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9698064901149 40.78425381158391) | 19 | 4 | 19 | 13 | |||||
1907 | 1907 | -73.9689227467959 | 40.7837541607494 | 21B-AM-1019-03 | 21B | AM | 10192018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9689227467959 40.7837541607494) | 19 | 4 | 19 | 13 | |||||
1832 | 1832 | -73.9693159934697 | 40.7831212338295 | 21B-PM-1017-03 | 21B | PM | 10172018 | 3 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 1 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9693159934697 40.7831212338295) | 19 | 4 | 19 | 13 | |||||
2933 | 2933 | -73.9677903197449 | 40.7826561917755 | 21C-AM-1014-03 | 21C | AM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | false | true | true | false | false | false | true | false | false | false | false | false | false | looked at us from tree | POINT (-73.9677903197449 40.7826561917755) | 19 | 4 | 19 | 13 | |||||
2563 | 2563 | -73.9664536611195 | 40.7827694131949 | 21D-AM-1008-03 | 21D | AM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9664536611195 40.7827694131949) | 19 | 4 | 19 | 13 | ||||||
2528 | 2528 | -73.9676529780724 | 40.7823206990549 | 21D-PM-1008-03 | 21D | PM | 10082018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9676529780724 40.7823206990549) | 19 | 4 | 19 | 13 | |||||
1611 | 1611 | -73.9655238539833 | 40.7815633947684 | 21E-AM-1017-03 | 21E | AM | 10172018 | 3 | Adult | Gray | Gray+ | Above Ground | 7 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9655238539833 40.7815633947684) | 19 | 4 | 19 | 13 | ||||||
2043 | 2043 | -73.9643223016635 | 40.781431908715 | 21F-AM-1018-03 | 21F | AM | 10182018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | false | dead | false | false | false | false | false | false | false | true | POINT (-73.9643223016635 40.781431908715) | 19 | 4 | 19 | 13 | ||||
551 | 551 | -73.9643825381614 | 40.7815445841195 | 21F-PM-1018-03 | 21F | PM | 10182018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9643825381614 40.7815445841195) | 19 | 4 | 19 | 13 | |||||
702 | 702 | -73.963858549251 | 40.7808999610914 | 21G-AM-1014-03 | 21G | AM | 10142018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 7 | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.963858549251 40.7808999610914) | 19 | 4 | 19 | 13 | |||||
1616 | 1616 | -73.9642666013207 | 40.7810384867375 | 21G-PM-1007-03 | 21G | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.96426660132072 40.7810384867375) | 19 | 4 | 19 | 13 | |||||
2960 | 2960 | -73.962524814515 | 40.7810022923615 | 21H-PM-1018-03 | 21H | PM | 10182018 | 3 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | false | true | false | false | false | false | false | true | false | POINT (-73.962524814515 40.7810022923615) | 19 | 4 | 19 | 13 | ||||||
491 | 491 | -73.9688470831269 | 40.7844651946415 | 22A-AM-1008-03 | 22A | AM | 10082018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9688470831269 40.7844651946415) | 19 | 4 | 19 | 13 | ||||||
2867 | 2867 | -73.969370141813 | 40.7840721191988 | 22A-PM-1017-03 | 22A | PM | 10172018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.969370141813 40.7840721191988) | 19 | 4 | 19 | 13 | |||||
2411 | 2411 | -73.9686907918759 | 40.7839462261858 | 22B-AM-1013-03 | 22B | AM | 10132018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9686907918759 40.7839462261858) | 19 | 4 | 19 | 13 | ||||||
2465 | 2465 | -73.9686999860219 | 40.7844014735136 | 22B-PM-1014-03 | 22B | PM | 10142018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9686999860219 40.7844014735136) | 19 | 4 | 19 | 13 | |||||
204 | 204 | -73.9679538163341 | 40.7837103696906 | 22C-AM-1013-03 | 22C | AM | 10132018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | eating (mushroom) | false | false | false | false | false | false | false | true | POINT (-73.9679538163341 40.7837103696906) | 19 | 4 | 19 | 13 | ||||
2197 | 2197 | -73.9672413354558 | 40.7838116138235 | 22C-PM-1006-03 | 22C | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9672413354558 40.7838116138235) | 19 | 4 | 19 | 13 | ||||||
2477 | 2477 | -73.9663297144622 | 40.7837932023685 | 22D-PM-1012-03 | 22D | PM | 10122018 | 3 | Adult | Gray | Black, White | Gray+Black, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9663297144622 40.7837932023685) | 19 | 4 | 19 | 13 | |||||
660 | 660 | -73.9638298997554 | 40.7825966332367 | 22F-AM-1007-03 | 22F | AM | 10072018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | large white highlight | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9638298997554 40.7825966332367) | 19 | 4 | 19 | 13 | ||||
784 | 784 | -73.9649658099293 | 40.7823262369074 | 22F-PM-1014-03 | 22F | PM | 10142018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9649658099293 40.7823262369074) | 19 | 4 | 19 | 13 | |||||
1620 | 1620 | -73.9635606199784 | 40.782206970617 | 22G-AM-1018-03 | 22G | AM | 10182018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9635606199784 40.782206970617) | 19 | 4 | 19 | 13 | |||||
408 | 408 | -73.9633760173635 | 40.7818422357619 | 22G-PM-1018-03 | 22G | PM | 10182018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | chilling | false | false | false | false | false | false | true | false | observed | POINT (-73.96337601736352 40.7818422357619) | 19 | 4 | 19 | 13 | |||
1851 | 1851 | -73.9623621412501 | 40.7814673556041 | 22H-PM-1007-03 | 22H | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 4 | chased squirrel #2 away | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9623621412501 40.7814673556041) | 19 | 4 | 19 | 13 | ||||
347 | 347 | -73.9611696144784 | 40.7816692895155 | 22I-AM-1007-03 | 22I | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9611696144784 40.7816692895155) | 19 | 4 | 19 | 13 | ||||||
2599 | 2599 | -73.9689893412693 | 40.785308737683 | 23A-AM-1018-03 | 23A | AM | 10182018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | Tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9689893412693 40.785308737683) | 19 | 4 | 19 | 13 | ||||
2328 | 2328 | -73.9678620840741 | 40.784719027304 | 23B-PM-1012-03 | 23B | PM | 10122018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | true | 2/3 were chasing each other | false | false | false | false | true | false | false | true | POINT (-73.96786208407411 40.784719027304) | 19 | 4 | 19 | 13 | ||||
72 | 72 | -73.9666007935638 | 40.7845098131567 | 23C-PM-1014-03 | 23C | PM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 8 | false | true | false | false | false | chasing (#4 across trees) | false | false | false | false | false | false | false | false | POINT (-73.9666007935638 40.7845098131567) | 19 | 4 | 19 | 13 | |||||
1681 | 1681 | -73.9638141923763 | 40.7829225326288 | 23F-PM-1013-03 | 23F | PM | 10132018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | indifferent (noticed me,busy eating,foraging) | POINT (-73.9638141923763 40.7829225326288) | 19 | 4 | 19 | 13 | ||||
2036 | 2036 | -73.9610266708075 | 40.7817512107392 | 23I-PM-1019-03 | 23I | PM | 10192018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9610266708075 40.7817512107392) | 19 | 4 | 19 | 13 | ||||||
1750 | 1750 | -73.9684806250183 | 40.7858776210151 | 24A-PM-1007-03 | 24A | PM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9684806250183 40.7858776210151) | 19 | 4 | 19 | 13 | ||||||
783 | 783 | -73.9677654289757 | 40.786785529449 | 25A-AM-1013-03 | 25A | AM | 10132018 | 3 | Gray | Gray+ | Above Ground | 15 | BIG TREE | false | false | false | false | false | being chased by #2 | false | false | false | false | false | false | true | false | POINT (-73.9677654289757 40.786785529449) | 19 | 4 | 19 | 13 | |||||
2205 | 2205 | -73.9594986107981 | 40.7840083040604 | 25I-AM-1012-03 | 25I | AM | 10122018 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 8 | on turn, see map | true | true | false | true | false | false | false | false | false | true | true | false | false | POINT (-73.9594986107981 40.7840083040604) | 19 | 4 | 19 | 13 | |||||
1272 | 1272 | -73.9595717225279 | 40.7829872498299 | 25I-PM-1007-03 | 25I | PM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9595717225279 40.7829872498299) | 19 | 4 | 19 | 13 | ||||||
774 | 774 | -73.9673603655908 | 40.7876974177782 | 26A-PM-1006-03 | 26A | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9673603655908 40.7876974177782) | 19 | 4 | 19 | 13 | ||||||
1627 | 1627 | -73.9594391759139 | 40.784115697669 | 26I-PM-1010-03 | 26I | PM | 10102018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | black in tail | Above Ground | 15 | tree | false | false | true | true | true | false | false | false | false | true | false | true | false | POINT (-73.9594391759139 40.784115697669) | 19 | 4 | 19 | 13 | |||
1425 | 1425 | -73.9586252875856 | 40.7852027586217 | 27I-AM-1007-03 | 27I | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | had .5 of a tail | Above Ground | 20 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9586252875856 40.7852027586217) | 19 | 4 | 19 | 13 | ||||
2399 | 2399 | -73.9583762071264 | 40.7852226065643 | 27I-PM-1020-03 | 27I | PM | 10202018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | true | false | false | begging for food; on hind legs | POINT (-73.9583762071264 40.7852226065643) | 19 | 4 | 19 | 13 | ||||
1513 | 1513 | -73.9662409997642 | 40.7891042935432 | 28A-PM-1007-03 | 28A | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | true | false | true | true | chasing #2 took #2 food wrapper and is foraging through it | false | false | false | false | false | false | true | false | POINT (-73.9662409997642 40.7891042935432) | 19 | 4 | 19 | 13 | ||||
1516 | 1516 | -73.9625383795297 | 40.7883862331728 | 28D-AM-1012-03 | 28D | AM | 10122018 | 3 | Adult | Black | Black+ | Above Ground | 30 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9625383795297 40.7883862331728) | 19 | 4 | 19 | 13 | ||||||
1392 | 1392 | -73.9648090698176 | 40.7903882097837 | 29A-PM-1019-03 | 29A | PM | 10192018 | 3 | Juvenile | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | true | false | true | ran from,but now approaching. kind of weirding me out. | POINT (-73.9648090698176 40.7903882097837) | 19 | 4 | 19 | 13 | ||||
1672 | 1672 | -73.9640989602986 | 40.7899295439265 | 29B-PM-1010-03 | 29B | PM | 10102018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | false | false | POINT (-73.9640989602986 40.7899295439265) | 19 | 4 | 19 | 13 | |||||
612 | 612 | -73.9629420113622 | 40.789133072717 | 29C-AM-1007-03 | 29C | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9629420113622 40.789133072717) | 19 | 4 | 19 | 13 | |||||
2763 | 2763 | -73.9626065672894 | 40.788722645116 | 29D-AM-1014-03 | 29D | AM | 10142018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 35 | End of tree limb foraging | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9626065672894 40.788722645116) | 19 | 4 | 19 | 13 | |||||
2573 | 2573 | -73.9810149147578 | 40.7683925377714 | 2A-AM-1010-03 | 02A | AM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | on trunk | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9810149147578 40.7683925377714) | 19 | 4 | 19 | 13 | ||||
2412 | 2412 | -73.9809446489564 | 40.7685032165879 | 2A-PM-1019-03 | 02A | PM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | in tree! | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9809446489564 40.7685032165879) | 19 | 4 | 19 | 13 | ||||
893 | 893 | -73.9799311173259 | 40.7685576997559 | 2B-AM-1010-03 | 02B | AM | 10102018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9799311173259 40.7685576997559) | 19 | 4 | 19 | 13 | ||||||
2042 | 2042 | -73.9800896621713 | 40.7684379810317 | 2B-PM-1013-03 | 02B | PM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9800896621713 40.7684379810317) | 19 | 4 | 19 | 13 | |||||
391 | 391 | -73.9790875480358 | 40.7676104780657 | 2C-AM-1010-03 | 02C | AM | 10102018 | 3 | Adult | Black | Gray | Black+Gray | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9790875480358 40.7676104780657) | 19 | 4 | 19 | 13 | |||||
986 | 986 | -73.978400938697 | 40.7677411911854 | 2C-PM-1013-03 | 02C | PM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.978400938697 40.7677411911854) | 19 | 4 | 19 | 13 | |||||
226 | 226 | -73.9775681731459 | 40.7676421190309 | 2D-AM-1007-03 | 02D | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 100 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9775681731459 40.7676421190309) | 19 | 4 | 19 | 13 | ||||||
3 | 3 | -73.9768311751004 | 40.7667178072558 | 2E-AM-1010-03 | 02E | AM | 10102018 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9768311751004 40.76671780725581) | 19 | 4 | 19 | 13 | ||||||
1860 | 1860 | -73.9767100101318 | 40.7675779951996 | 2E-PM-1014-03 | 02E | PM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9767100101318 40.7675779951996) | 19 | 4 | 19 | 13 | |||||
1012 | 1012 | -73.9755569170561 | 40.7668006977526 | 2F-AM-1006-03 | 02F | AM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9755569170561 40.7668006977526) | 19 | 4 | 19 | 13 | ||||
878 | 878 | -73.9757215415855 | 40.7668205976986 | 2F-PM-1014-03 | 02F | PM | 10142018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9757215415855 40.7668205976986) | 19 | 4 | 19 | 13 | |||||
1829 | 1829 | -73.9746965894947 | 40.7664351724309 | 2G-AM-1010-03 | 02G | AM | 10102018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9746965894947 40.7664351724309) | 19 | 4 | 19 | 13 | ||||||
1326 | 1326 | -73.9747288122551 | 40.7659918747507 | 2G-PM-1007-03 | 02G | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9747288122551 40.7659918747507) | 19 | 4 | 19 | 13 | |||||
961 | 961 | -73.9731457102903 | 40.7660255393205 | 2H-AM-1006-03 | 02H | AM | 10062018 | 3 | 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.9731457102903 40.7660255393205) | 19 | 4 | 19 | 13 | |||||
2120 | 2120 | -73.9733905460282 | 40.7656337147768 | 2H-PM-1006-03 | 02H | PM | 10062018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9733905460282 40.7656337147768) | 19 | 4 | 19 | 13 | ||||||
2110 | 2110 | -73.9647151303629 | 40.7912681060756 | 30A-PM-1020-03 | 30A | PM | 10202018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Rock | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9647151303629 40.7912681060756) | 19 | 4 | 19 | 13 | ||||
480 | 480 | -73.9641293283734 | 40.7907654006019 | 30B-AM-1007-03 | 30B | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9641293283734 40.7907654006019) | 19 | 4 | 19 | 13 | ||||||
991 | 991 | -73.9635689059841 | 40.790163434915 | 30B-PM-1019-03 | 30B | PM | 10192018 | 3 | Adult | Gray | Black | Gray+Black | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9635689059841 40.790163434915) | 19 | 4 | 19 | 13 | |||||
1610 | 1610 | -73.9607056611532 | 40.7889786103871 | 30E-AM-1008-03 | 30E | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9607056611532 40.7889786103871) | 19 | 4 | 19 | 13 | ||||||
2241 | 2241 | -73.9575258627966 | 40.787715550749 | 30H-AM-1007-03 | 30H | AM | 10072018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9575258627966 40.787715550749) | 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 );