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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
544 | 544 | -73.9718474480919 | 40.7794963354254 | 16B-AM-1014-01 | 16B | AM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9718474480919 40.7794963354254) | 19 | 4 | 19 | 13 | |||||
552 | 552 | -73.9625416200877 | 40.7811302397912 | 21H-AM-1017-02 | 21H | AM | 10172018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9625416200877 40.78113023979121) | 19 | 4 | 19 | 13 | |||||
554 | 554 | -73.973351945818 | 40.768814796037 | 5G-PM-1010-03 | 05G | PM | 10102018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.973351945818 40.768814796037) | 19 | 4 | 19 | 13 | ||||||
555 | 555 | -73.9685227310735 | 40.776599466588 | 15F-AM-1007-02 | 15F | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9685227310735 40.776599466588) | 19 | 4 | 19 | 13 | ||||
558 | 558 | -73.9579335275486 | 40.7953080673706 | 37D-PM-1014-05 | 37D | PM | 10142018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9579335275486 40.7953080673706) | 19 | 4 | 19 | 13 | ||||||
568 | 568 | -73.9799441493404 | 40.7671499997527 | 1C-AM-1012-01 | 01C | AM | 10122018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9799441493404 40.7671499997527) | 12081 | 11 | 4 | 51 | 10 | |||
574 | 574 | -73.9706360005275 | 40.7717074044466 | 9G-PM-1007-05 | 09G | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9706360005275 40.7717074044466) | 19 | 4 | 19 | 13 | |||||
581 | 581 | -73.9556218199258 | 40.7980460204041 | 41D-PM-1014-01 | 41D | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | digging,drinking | false | false | false | false | false | false | false | true | POINT (-73.9556218199258 40.7980460204041) | 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 | |||||
593 | 593 | -73.9593352806175 | 40.7918150568046 | 33E-AM-1014-02 | 33E | AM | 10142018 | 2 | Juvenile | Black | Black+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9593352806175 40.7918150568046) | 19 | 4 | 19 | 13 | ||||||
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 | ||||||
601 | 601 | -73.9522291603405 | 40.7976985385835 | 42G-PM-1014-01 | 42G | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 8 | false | false | true | false | true | false | false | true | false | false | false | false | true | POINT (-73.9522291603405 40.7976985385835) | 19 | 4 | 19 | 13 | |||||
602 | 602 | -73.9685751595485 | 40.7709413567859 | 9I-PM-1010-07 | 09I | PM | 10102018 | 7 | Adult | Gray | White | Gray+White | Above Ground | 1 | ran up tree | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9685751595485 40.7709413567859) | 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 | |||||
615 | 615 | -73.9653279069888 | 40.7758743113817 | 15I-AM-1008-02 | 15I | AM | 10082018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Could be same squirrel as #1? | Above Ground | 4 | on fence | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9653279069888 40.7758743113817) | 19 | 4 | 19 | 13 | |||
618 | 618 | -73.957976896139 | 40.797027128241 | 39C-AM-1017-04 | 39C | AM | 10172018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.957976896139 40.797027128241005) | 19 | 4 | 19 | 13 | ||||||
621 | 621 | -73.9588886083793 | 40.7909991733435 | 32E-PM-1017-01 | 32E | PM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9588886083793 40.7909991733435) | 19 | 4 | 19 | 13 | ||||||
623 | 623 | -73.9662939630722 | 40.7878502338031 | 26B-AM-1010-01 | 26B | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | running across bridle path | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9662939630722 40.7878502338031) | 19 | 4 | 19 | 13 | |||||
624 | 624 | -73.9613051957306 | 40.7909351393505 | 31D-AM-1014-02 | 31D | AM | 10142018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | Undergrowth | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9613051957306 40.7909351393505) | 19 | 4 | 19 | 13 | ||||
627 | 627 | -73.9763791121438 | 40.770281512254 | 5D-PM-1018-04 | 05D | PM | 10182018 | 4 | Adult | Gray | White | Gray+White | Partial missing tail | Ground Plane | FALSE | false | true | false | false | false | chasing (dog chasing) | false | false | false | false | false | false | false | true | POINT (-73.9763791121438 40.770281512254) | 19 | 4 | 19 | 13 | |||
629 | 629 | -73.9573724133264 | 40.7980080911115 | 40C-AM-1017-02 | 40C | AM | 10172018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | true | false | true | false | chasing (#1) | false | false | false | false | false | false | false | true | POINT (-73.9573724133264 40.7980080911115) | 19 | 4 | 19 | 13 | ||||
630 | 630 | -73.9580109357087 | 40.7855654405447 | 28I-AM-1013-01 | 28I | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Jumped onto path & then back into brush | false | false | false | false | false | stood on fence | false | false | false | false | false | false | false | true | POINT (-73.9580109357087 40.7855654405447) | 19 | 4 | 19 | 13 | |||
643 | 643 | -73.976730206737 | 40.773709213914 | 8A-PM-1014-01 | 08A | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | true | false | true | false | false | false | false | false | false | true | runs from (goes up a tree) | POINT (-73.976730206737 40.773709213914) | 19 | 4 | 19 | 13 | ||||
648 | 648 | -73.9539400028236 | 40.79800412717 | 41E-AM-1007-02 | 41E | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9539400028236 40.79800412717) | 19 | 4 | 19 | 13 | ||||||
652 | 652 | -73.9570056123953 | 40.7878756067582 | 30I-PM-1006-02 | 30I | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9570056123953 40.7878756067582) | 19 | 4 | 19 | 13 | ||||||
653 | 653 | -73.9703401385684 | 40.7795238784266 | 17C-PM-1013-01 | 17C | PM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | then perched on 2-ft high border fencing | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9703401385684 40.7795238784266) | 19 | 4 | 19 | 13 | |||||
658 | 658 | -73.9704575848926 | 40.7693499326095 | 7H-PM-1006-09 | 07H | PM | 10062018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | by tree | false | false | false | true | true | false | false | false | true | false | true | false | true | POINT (-73.9704575848926 40.7693499326095) | 19 | 4 | 19 | 13 | |||||
663 | 663 | -73.9766440589836 | 40.7682390282581 | 3E-AM-1006-02 | 03E | AM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9766440589836 40.7682390282581) | 19 | 4 | 19 | 13 | ||||||
667 | 667 | -73.9624538733037 | 40.7883829851518 | 28D-AM-1012-04 | 28D | AM | 10122018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9624538733037 40.7883829851518) | 19 | 4 | 19 | 13 | |||||
671 | 671 | -73.9709244006956 | 40.7676942639697 | 5I-AM-1010-02 | 05I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9709244006956 40.7676942639697) | 19 | 4 | 19 | 13 | ||||||
675 | 675 | -73.9759830650957 | 40.7683034739069 | 3E-AM-1006-01 | 03E | AM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9759830650957 40.7683034739069) | 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 | |||||
696 | 696 | -73.9656098194149 | 40.7757643078973 | 15I-AM-1008-05 | 15I | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9656098194149 40.7757643078973) | 19 | 4 | 19 | 13 | ||||||
703 | 703 | -73.9576304473722 | 40.7959810622342 | 38D-AM-1017-05 | 38D | AM | 10172018 | 5 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Black stripe along sides | Ground Plane | FALSE | true | false | false | true | false | eating (nut) | false | false | false | false | false | false | false | true | POINT (-73.9576304473722 40.7959810622342) | 19 | 4 | 19 | 13 | |||
713 | 713 | -73.956200809768 | 40.798181446265 | 40C-AM-1017-06 | 40C | AM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.956200809768 40.798181446265) | 19 | 4 | 19 | 13 | |||||
717 | 717 | -73.9574749571848 | 40.7981898890735 | 40C-PM-1006-08 | 40C | PM | 10062018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | By the main road | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9574749571848 40.7981898890735) | 19 | 4 | 19 | 13 | |||||
726 | 726 | -73.973305698325 | 40.7783823311296 | 14A-PM-1014-06 | 14A | PM | 10142018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 9 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.973305698325 40.7783823311296) | 19 | 4 | 19 | 13 | |||||
727 | 727 | -73.9634563222926 | 40.780992836417 | 21G-PM-1007-04 | 21G | PM | 10072018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.9634563222926 40.780992836417) | 19 | 4 | 19 | 13 | ||||||
730 | 730 | -73.9607280801601 | 40.7901506706248 | 31D-PM-1006-01 | 31D | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | true | false | false | false | true | POINT (-73.9607280801601 40.7901506706248) | 19 | 4 | 19 | 13 | ||||||
732 | 732 | -73.9695041366722 | 40.7797878809482 | 17D-AM-1008-02 | 17D | AM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9695041366722 40.7797878809482) | 19 | 4 | 19 | 13 | |||||
738 | 738 | -73.9725712588741 | 40.7669101832926 | 4H-AM-1006-02 | 04H | AM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | false | climbing (over small wire fence then on the ground) | false | false | false | false | false | true | false | true | approaches (saw me & came forward),runs from (startled by another person) | POINT (-73.9725712588741 40.7669101832926) | 19 | 4 | 19 | 13 | |||
743 | 743 | -73.9565035705619 | 40.7937382705056 | 36F-AM-1017-04 | 36F | AM | 10172018 | 4 | Juvenile | Gray | White | Gray+White | White legs, front & back | Ground Plane | FALSE | true | false | false | true | true | true | false | false | false | false | true | false | true | approaches (me),runs from (me) | POINT (-73.9565035705619 40.7937382705056) | 19 | 4 | 19 | 13 | |||
760 | 760 | -73.9718234159557 | 40.7810842503715 | 18A-AM-1012-02 | 18A | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | false | true | true | true | burying | false | false | false | true | false | false | false | true | POINT (-73.9718234159557 40.7810842503715) | 19 | 4 | 19 | 13 | ||||
768 | 768 | -73.9729394928432 | 40.7743256716496 | 11D-AM-1010-01 | 11D | AM | 10102018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.9729394928432 40.7743256716496) | 19 | 4 | 19 | 13 | |||||
769 | 769 | -73.976521916284 | 40.773784724458 | 9B-AM-1010-01 | 09B | AM | 10102018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | true | false | false | false | false | false | false | true | POINT (-73.976521916284 40.773784724458) | 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 | ||||||
777 | 777 | -73.9654210263521 | 40.7782529692575 | 17G-AM-1018-01 | 17G | AM | 10182018 | 1 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9654210263521 40.77825296925751) | 19 | 4 | 19 | 13 | ||||||
785 | 785 | -73.9619417432685 | 40.7930365939865 | 33B-PM-1010-12 | 33B | PM | 10102018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9619417432685 40.7930365939865) | 19 | 4 | 19 | 13 | ||||||
791 | 791 | -73.9772635911119 | 40.7709428872533 | 6B-PM-1017-03 | 06B | PM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9772635911119 40.7709428872533) | 19 | 4 | 19 | 13 | |||||
793 | 793 | -73.9730111650468 | 40.7782157736204 | 14B-PM-1014-05 | 14B | PM | 10142018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9730111650468 40.7782157736204) | 19 | 4 | 19 | 13 | ||||||
795 | 795 | -73.9582523503306 | 40.7996897499473 | 41A-PM-1007-05 | 41A | PM | 10072018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9582523503306 40.7996897499473) | 19 | 4 | 19 | 13 | |||||
807 | 807 | -73.9777259022441 | 40.7682059907903 | 3D-PM-1010-10 | 03D | PM | 10102018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9777259022441 40.7682059907903) | 19 | 4 | 19 | 13 | |||||
808 | 808 | -73.9716881838671 | 40.778553537087 | 15C-PM-1017-02 | 15C | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 0 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9716881838671 40.778553537087) | 19 | 4 | 19 | 13 | |||||
813 | 813 | -73.9758959798289 | 40.7694125671679 | 4D-PM-1008-01 | 04D | PM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9758959798289 40.7694125671679) | 19 | 4 | 19 | 13 | |||||
824 | 824 | -73.9606344681252 | 40.7958337780644 | 37B-PM-1013-04 | 37B | PM | 10132018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9606344681252 40.795833778064406) | 19 | 4 | 19 | 13 | ||||||
825 | 825 | -73.9580105174865 | 40.7974468322692 | 39C-PM-1006-03 | 39C | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9580105174865 40.7974468322692) | 19 | 4 | 19 | 13 | ||||||
833 | 833 | -73.9741846413977 | 40.7762518164182 | 12B-PM-1018-01 | 12B | PM | 10182018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | Climbing up rocks | false | false | true | false | true | climbing (up rocks) | false | false | false | false | false | false | false | true | POINT (-73.9741846413977 40.7762518164182) | 19 | 4 | 19 | 13 | ||||
841 | 841 | -73.9746933852572 | 40.773313866931 | 9C-PM-1006-05 | 09C | PM | 10062018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | w/ dog | POINT (-73.9746933852572 40.773313866931) | 19 | 4 | 19 | 13 | ||||
852 | 852 | -73.9609704650925 | 40.7938786854735 | 34B-AM-1013-03 | 34B | AM | 10132018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | true | false | true | false | false | hopping | false | false | false | false | false | true | false | true | POINT (-73.9609704650925 40.7938786854735) | 19 | 4 | 19 | 13 | ||||
855 | 855 | -73.9808247660048 | 40.7689408831287 | 2A-PM-1019-01 | 02A | PM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | runs from | false | false | false | true | false | false | false | true | POINT (-73.9808247660048 40.7689408831287) | 19 | 4 | 19 | 13 | ||||
858 | 858 | -73.9629383420274 | 40.7889383725489 | 29C-AM-1007-02 | 29C | AM | 10072018 | 2 | Adult | Black | Gray | Black+Gray | Above Ground | 10 | true | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.9629383420274 40.7889383725489) | 19 | 4 | 19 | 13 | |||||
865 | 865 | -73.9741621946917 | 40.7752481472025 | 11C-PM-1018-01 | 11C | PM | 10182018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9741621946917 40.7752481472025) | 19 | 4 | 19 | 13 | |||||
867 | 867 | -73.9762257701293 | 40.7744032758323 | 9A-AM-1013-08 | 09A | AM | 10132018 | 8 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9762257701293 40.7744032758323) | 19 | 4 | 19 | 13 | |||||||||
869 | 869 | -73.9629483374528 | 40.7936809905265 | 33A-PM-1018-03 | 33A | PM | 10182018 | 3 | Adult | Gray | Gray+ | Above Ground | 6 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9629483374528 40.7936809905265) | 19 | 4 | 19 | 13 | ||||||
887 | 887 | -73.9635028497015 | 40.7928207574906 | 32A-PM-1013-05 | 32A | PM | 10132018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9635028497015 40.7928207574906) | 19 | 4 | 19 | 13 | |||||
888 | 888 | -73.9674177504573 | 40.7769569731993 | 15G-PM-1019-03 | 15G | PM | 10192018 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9674177504573 40.7769569731993) | 19 | 4 | 19 | 13 | ||||||
890 | 890 | -73.9667755678511 | 40.7760256836088 | 15H-PM-1008-02 | 15H | PM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 10 | oak tree | false | true | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9667755678511 40.7760256836088) | 19 | 4 | 19 | 13 | |||||
891 | 891 | -73.9613351649026 | 40.7909866851357 | 31D-AM-1014-03 | 31D | AM | 10142018 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | Undergrowth | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9613351649026 40.7909866851357) | 19 | 4 | 19 | 13 | |||||
898 | 898 | -73.9542828053256 | 40.7941797320355 | 37G-AM-1014-03 | 37G | AM | 10142018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9542828053256 40.7941797320355) | 19 | 4 | 19 | 13 | ||||||
902 | 902 | -73.969105907 | 40.7820474909192 | 20B-PM-1013-08 | 20B | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | (very brown) | Ground Plane | FALSE | true | false | false | false | false | being chased by dog | false | false | false | false | false | false | false | true | POINT (-73.969105907 40.7820474909192) | 19 | 4 | 19 | 13 | |||
906 | 906 | -73.9664120826015 | 40.7888022709721 | 27A-AM-1008-01 | 27A | AM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.96641208260151 40.7888022709721) | 19 | 4 | 19 | 13 | ||||||
913 | 913 | -73.9514111329059 | 40.7975085872897 | 42G-AM-1018-01 | 42G | AM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | true | POINT (-73.9514111329059 40.797508587289705) | 19 | 4 | 19 | 13 | |||||
914 | 914 | -73.9760801742337 | 40.7674218954729 | 3E-AM-1006-04 | 03E | AM | 10062018 | 4 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9760801742337 40.7674218954729) | 19 | 4 | 19 | 13 | ||||||
916 | 916 | -73.9561887624471 | 40.7958187455815 | 38E-AM-1010-04 | 38E | AM | 10102018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | true | false | false | false | false | false | true | false | false | false | true | me | POINT (-73.95618876244711 40.7958187455815) | 19 | 4 | 19 | 13 | ||||
925 | 925 | -73.9763116425885 | 40.7688839576487 | 4D-PM-1008-03 | 04D | PM | 10082018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | ran two feet up tree trunk | POINT (-73.9763116425885 40.7688839576487) | 19 | 4 | 19 | 13 | ||||
930 | 930 | -73.9622030085794 | 40.7917723228749 | 32B-AM-1017-01 | 32B | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | ran up a tree | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9622030085794 40.7917723228749) | 19 | 4 | 19 | 13 | ||||
932 | 932 | -73.9718597156773 | 40.7765858763313 | 13C-PM-1019-04 | 13C | PM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9718597156773 40.7765858763313) | 19 | 4 | 19 | 13 | ||||||
940 | 940 | -73.9700879096644 | 40.7765899724756 | 14E-PM-1017-05 | 14E | PM | 10172018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9700879096644 40.7765899724756) | 19 | 4 | 19 | 13 | |||||
943 | 943 | -73.9773096718574 | 40.7738053862489 | 8A-AM-1013-06 | 08A | AM | 10132018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9773096718574 40.7738053862489) | 19 | 4 | 19 | 13 | |||||
951 | 951 | -73.971791854883 | 40.7802971729784 | 17B-PM-1012-01 | 17B | PM | 10122018 | 1 | Adult | Gray | Gray+ | Above Ground | 2 | climbed a fence | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.971791854883 40.7802971729784) | 19 | 4 | 19 | 13 | |||||
955 | 955 | -73.960657061561 | 40.7956150744102 | 36A-PM-1013-08 | 36A | PM | 10132018 | 8 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | true | false | false | false | false | running from #7 | false | false | false | false | false | false | false | true | POINT (-73.960657061561 40.7956150744102) | 19 | 4 | 19 | 13 | |||||
956 | 956 | -73.9581173730857 | 40.7954772170549 | 37D-PM-1014-08 | 37D | PM | 10142018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9581173730857 40.7954772170549) | 19 | 4 | 19 | 13 | |||||
962 | 962 | -73.9715466850324 | 40.7695584933538 | 6H-PM-1020-03 | 06H | PM | 10202018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | runs from (kids kicking the fence) | POINT (-73.9715466850324 40.7695584933538) | 19 | 4 | 19 | 13 | |||
963 | 963 | -73.9621066718851 | 40.7942427079733 | 34A-AM-1012-03 | 34A | AM | 10122018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9621066718851 40.7942427079733) | 19 | 4 | 19 | 13 | ||||||
964 | 964 | -73.9631045499811 | 40.7906180969472 | 30B-PM-1019-04 | 30B | PM | 10192018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.9631045499811 40.7906180969472) | 19 | 4 | 19 | 13 | |||||
968 | 968 | -73.9689781843873 | 40.7709333833783 | 9I-PM-1010-04 | 09I | PM | 10102018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9689781843873 40.7709333833783) | 19 | 4 | 19 | 13 | |||||
972 | 972 | -73.9704591091677 | 40.7729175143429 | 10G-AM-1006-02 | 10G | AM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | notch on tail | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9704591091677 40.7729175143429) | 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 | ||||||
980 | 980 | -73.9709817796369 | 40.7773554311586 | 14D-PM-1019-07 | 14D | PM | 10192018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9709817796369 40.7773554311586) | 19 | 4 | 19 | 13 | ||||||
984 | 984 | -73.9672950266018 | 40.7782477517567 | 17F-PM-1020-01 | 17F | PM | 10202018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9672950266018 40.7782477517567) | 19 | 4 | 19 | 13 | |||||
993 | 993 | -73.9772422664657 | 40.773436329163 | 8A-AM-1013-02 | 08A | AM | 10132018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | playground | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9772422664657 40.773436329163) | 19 | 4 | 19 | 13 | ||||
996 | 996 | -73.9703149829421 | 40.7785583630323 | 16D-AM-1007-01 | 16D | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9703149829421 40.7785583630323) | 19 | 4 | 19 | 13 | |||||
1005 | 1005 | -73.9558268731771 | 40.7952074193788 | 38E-PM-1014-04 | 38E | PM | 10142018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | THICK UNDERGROWTH | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9558268731771 40.7952074193788) | 19 | 4 | 19 | 13 | |||||
1011 | 1011 | -73.9719111470164 | 40.7758789855474 | 12D-AM-1013-02 | 12D | AM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 7 | Was on top of the edge of Bow Bridge | false | false | false | false | false | jumped off | false | false | false | true | false | false | false | true | POINT (-73.9719111470164 40.7758789855474) | 19 | 4 | 19 | 13 | ||||
1019 | 1019 | -73.9704269630964 | 40.7722964640257 | 10G-AM-1006-09 | 10G | AM | 10062018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9704269630964 40.7722964640257) | 19 | 4 | 19 | 13 | |||||
1029 | 1029 | -73.9601259189134 | 40.7955350609057 | 36B-PM-1013-04 | 36B | PM | 10132018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9601259189134 40.7955350609057) | 19 | 4 | 19 | 13 | ||||||
1030 | 1030 | -73.9697526733133 | 40.7759529849808 | 13E-PM-1008-09 | 13E | PM | 10082018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9697526733133 40.7759529849808) | 19 | 4 | 19 | 13 | |||||
1033 | 1033 | -73.975673607467 | 40.7699044294204 | 5D-PM-1018-01 | 05D | PM | 10182018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.975673607467 40.7699044294204) | 19 | 4 | 19 | 13 | ||||||
1040 | 1040 | -73.9702588981432 | 40.776610754288 | 14E-AM-1008-08 | 14E | AM | 10082018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9702588981432 40.776610754288) | 19 | 4 | 19 | 13 | ||||||
1051 | 1051 | -73.9613747032702 | 40.7920483852431 | 33C-PM-1007-01 | 33C | PM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9613747032702 40.792048385243106) | 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 );