This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Color notes, Location, Above Ground Sighter Measurement, Running, Climbing, Eating, Other Activities, Kuks, Quaas, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts, Police Precincts
Combination of Primary and Highlight Color ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15 | 15 | -73.9674285955293 | 40.7829723919744 | 21C-PM-1006-01 | 21C | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | false | false | false | true | true | false | false | false | POINT (-73.9674285955293 40.7829723919744) | 19 | 4 | 19 | 13 | ||||||
25 | 25 | -73.9671130680114 | 40.7784859700171 | 17F-AM-1007-07 | 17F | AM | 10072018 | 7 | Adult | Gray | White | Gray+White | Above Ground | 24 | true | false | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9671130680114 40.7784859700171) | 19 | 4 | 19 | 13 | |||||
38 | 38 | -73.9742073452913 | 40.7757957380463 | 12B-AM-1007-01 | 12B | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9742073452913 40.7757957380463) | 19 | 4 | 19 | 13 | |||||
74 | 74 | -73.9546654184146 | 40.7947639241491 | 38G-PM-1020-09 | 38G | PM | 10202018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | true | false | false | true | false | POINT (-73.9546654184146 40.7947639241491) | 19 | 4 | 19 | 13 | |||||
78 | 78 | -73.964474836001 | 40.7883840104749 | 28C-PM-1006-01 | 28C | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | gathering acorns | false | false | false | true | false | false | false | true | gnd to tree | POINT (-73.964474836001 40.7883840104749) | 19 | 4 | 19 | 13 | |||
80 | 80 | -73.9688454483585 | 40.7845301288163 | 22A-AM-1008-05 | 22A | AM | 10082018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 3 | trash can | false | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.9688454483585 40.7845301288163) | 19 | 4 | 19 | 13 | ||||
90 | 90 | -73.9787180870736 | 40.7715877863274 | 5A-AM-1006-05 | 05A | AM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | near 65th St arch | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9787180870736 40.7715877863274) | 19 | 4 | 19 | 13 | ||||
94 | 94 | -73.9641971813967 | 40.7813537959435 | 21G-PM-1007-01 | 21G | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | true | false | POINT (-73.9641971813967 40.7813537959435) | 19 | 4 | 19 | 13 | |||||
124 | 124 | -73.9588660250232 | 40.7982597947515 | 40A-AM-1010-03 | 40A | AM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | bottom of great hill | false | false | false | true | true | false | false | false | true | false | false | true | true | dog chased | POINT (-73.9588660250232 40.7982597947515) | 19 | 4 | 19 | 13 | |||
133 | 133 | -73.9664711607022 | 40.787896428768 | 26A-PM-1006-06 | 26A | PM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Tree 90th left 90th & 89 | false | false | true | false | false | false | false | false | true | false | false | false | false | studying us looking for food | POINT (-73.9664711607022 40.787896428768) | 19 | 4 | 19 | 13 | |||
150 | 150 | -73.9763430829342 | 40.7686351097159 | 4D-PM-1008-11 | 04D | PM | 10082018 | 11 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | on tree facing downward | false | true | false | false | false | chased #12 | true | false | false | true | false | false | false | true | POINT (-73.9763430829342 40.7686351097159) | 19 | 4 | 19 | 13 | |||
159 | 159 | -73.9638270331336 | 40.7810450065235 | 21G-PM-1007-02 | 21G | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | false | true | POINT (-73.9638270331336 40.7810450065235) | 19 | 4 | 19 | 13 | ||||||
188 | 188 | -73.9570528770427 | 40.7990973804149 | 41B-AM-1010-07 | 41B | AM | 10102018 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10 | false | false | false | false | false | true | false | false | true | false | true | false | false | mad! | POINT (-73.9570528770427 40.7990973804149) | 19 | 4 | 19 | 13 | ||||
192 | 192 | -73.9651654887991 | 40.7777806006951 | 17H-PM-1007-02 | 17H | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9651654887991 40.7777806006951) | 19 | 4 | 19 | 13 | ||||||
193 | 193 | -73.9537691298752 | 40.7941272599797 | 38G-PM-1020-01 | 38G | PM | 10202018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9537691298752 40.7941272599797) | 19 | 4 | 19 | 13 | |||||
194 | 194 | -73.9764839973068 | 40.7691725326976 | 4D-PM-1008-06 | 04D | PM | 10082018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9764839973068 40.7691725326976) | 19 | 4 | 19 | 13 | |||||
203 | 203 | -73.9638774579549 | 40.7913532129148 | 31A-AM-1010-05 | 31A | AM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | jumping | false | false | false | true | true | false | true | false | eventually ran from lawnmower (tail flag) | POINT (-73.9638774579549 40.7913532129148) | 19 | 4 | 19 | 13 | ||||
210 | 210 | -73.9711298491132 | 40.7676902603543 | 5I-PM-1008-01 | 05I | PM | 10082018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 15 | in tree by arsenal - climbing | false | false | true | true | false | false | false | false | true | false | false | false | false | POINT (-73.9711298491132 40.7676902603543) | 19 | 4 | 19 | 13 | ||||
234 | 234 | -73.9741401377844 | 40.7758134257881 | 12B-AM-1007-02 | 12B | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9741401377844 40.7758134257881) | 19 | 4 | 19 | 13 | |||||
239 | 239 | -73.9758464905133 | 40.7725957408841 | 8C-PM-1013-05 | 08C | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9758464905133 40.7725957408841) | 19 | 4 | 19 | 13 | |||||
242 | 242 | -73.9590236602085 | 40.7982632456866 | 40A-AM-1010-04 | 40A | AM | 10102018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | bottom great hill | false | false | false | false | true | false | false | false | true | false | false | true | true | dog chased | POINT (-73.9590236602085 40.7982632456866) | 19 | 4 | 19 | 13 | |||
261 | 261 | -73.9552861155228 | 40.788973931872 | 32I-AM-1013-05 | 32I | AM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | In and below shrub | false | false | true | false | true | false | false | false | true | false | false | true | false | POINT (-73.9552861155228 40.788973931872) | 19 | 4 | 19 | 13 | ||||
294 | 294 | -73.9756573579063 | 40.7656644063024 | 1G-PM-1010-01 | 01G | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | true | false | false | false | false | true | false | false | true | false | too busy eating in his tree | POINT (-73.9756573579063 40.7656644063024) | 19 | 4 | 19 | 13 | ||||
308 | 308 | -73.9554095823557 | 40.7887305802044 | 32I-AM-1013-01 | 32I | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9554095823557 40.7887305802044) | 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 | |||||
335 | 335 | -73.9782351435852 | 40.7715896672335 | 6A-AM-1006-03 | 06A | AM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 30 | tree | false | true | false | true | false | false | false | false | true | true | false | false | false | POINT (-73.9782351435852 40.7715896672335) | 19 | 4 | 19 | 13 | ||||
373 | 373 | -73.9672127283283 | 40.7810666805133 | 20D-AM-1007-01 | 20D | AM | 10072018 | 1 | Adult | Gray | Gray+ | too far to note 30' | Ground Plane | FALSE | true | false | true | true | false | a lot of activity | false | false | false | true | false | false | false | false | POINT (-73.9672127283283 40.7810666805133) | 19 | 4 | 19 | 13 | ||||
379 | 379 | -73.9606817053484 | 40.7917320450401 | 32D-PM-1006-07 | 32D | PM | 10062018 | 7 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | true | false | POINT (-73.9606817053484 40.7917320450401) | 19 | 4 | 19 | 13 | |||||
384 | 384 | -73.968045072743 | 40.7836626717225 | 22C-AM-1013-02 | 22C | AM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | false | false | true | false | true | true | false | false | true | false | false | false | true | POINT (-73.968045072743 40.7836626717225) | 19 | 4 | 19 | 13 | |||||
416 | 416 | -73.9702788578386 | 40.7694484997295 | 7I-PM-1013-05 | 07I | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Rock | false | false | false | true | false | false | false | false | true | false | false | false | false | POINT (-73.9702788578386 40.7694484997295) | 19 | 4 | 19 | 13 | ||||
427 | 427 | -73.9589367709165 | 40.7896465303483 | 31F-PM-1007-04 | 31F | PM | 10072018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9589367709165 40.7896465303483) | 19 | 4 | 19 | 13 | ||||||
507 | 507 | -73.9744835563086 | 40.7729521433235 | 9D-AM-1008-01 | 09D | AM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9744835563086 40.7729521433235) | 19 | 4 | 19 | 13 | ||||||
566 | 566 | -73.9708364583591 | 40.7723691587433 | 10F-AM-1007-01 | 10F | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 60 | false | false | true | false | false | false | false | false | true | false | false | false | false | POINT (-73.9708364583591 40.7723691587433) | 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 | |||
569 | 569 | -73.9709040623777 | 40.7701163892686 | 7H-PM-1006-03 | 07H | PM | 10062018 | 3 | Adult | Gray | Gray+ | Above Ground | 8 | tree | true | false | true | false | false | false | false | false | true | false | false | true | false | POINT (-73.9709040623777 40.7701163892686) | 19 | 4 | 19 | 13 | |||||
582 | 582 | -73.9677779408464 | 40.7867482211349 | 25A-AM-1013-02 | 25A | AM | 10132018 | 2 | Gray | Gray+ | Above Ground | 15 | BIG TREE | false | true | false | false | false | chasing #3 | false | false | false | true | false | false | true | false | POINT (-73.9677779408464 40.7867482211349) | 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 | |||||
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 | |||||
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 | ||||||
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 | ||||||
681 | 681 | -73.9552880892701 | 40.7889040503316 | 32I-AM-1013-04 | 32I | AM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9552880892701 40.7889040503316) | 19 | 4 | 19 | 13 | |||||
706 | 706 | -73.9570132570934 | 40.7932014159087 | 35F-PM-1012-01 | 35F | PM | 10122018 | 1 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | true | false | false | true | true | POINT (-73.9570132570934 40.7932014159087) | 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 | ||||||
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 | ||||
770 | 770 | -73.9597782762029 | 40.7920773376757 | 33D-AM-1017-07 | 33D | AM | 10172018 | 7 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | true | false | true | false | false | true | false | POINT (-73.9597782762029 40.7920773376757) | 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 | |||||
815 | 815 | -73.9753283783695 | 40.7733043910649 | 8C-PM-1013-02 | 08C | PM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9753283783695 40.7733043910649) | 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 | ||||
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 | |||||
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 | ||||
928 | 928 | -73.967042958599 | 40.7784370719371 | 17F-AM-1007-05 | 17F | AM | 10072018 | 5 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | true | false | false | false | false | true | false | false | true | false | POINT (-73.967042958599 40.7784370719371) | 19 | 4 | 19 | 13 | |||||
1007 | 1007 | -73.9635317822977 | 40.7821352080233 | 22G-AM-1018-01 | 22G | AM | 10182018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | true | false | false | true | false | false | true | false | POINT (-73.9635317822977 40.7821352080233) | 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 | ||||
1017 | 1017 | -73.9552035011902 | 40.7889851896334 | 32I-AM-1013-06 | 32I | AM | 10132018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | In and below shrub | false | false | true | false | true | false | false | false | true | false | false | true | false | POINT (-73.9552035011902 40.7889851896334) | 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 | |||||
1038 | 1038 | -73.9563311167069 | 40.7950901563337 | 38E-AM-1010-12 | 38E | AM | 10102018 | 12 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | running on rocks | false | true | false | false | false | false | false | false | true | false | false | false | false | runs toward something | POINT (-73.9563311167069 40.7950901563337) | 19 | 4 | 19 | 13 | ||||
1046 | 1046 | -73.9647891228606 | 40.789853066039 | 29B-AM-1007-02 | 29B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 30 | true | false | false | false | false | false | false | false | true | false | false | false | false | POINT (-73.9647891228606 40.789853066039) | 19 | 4 | 19 | 13 | ||||||
1048 | 1048 | -73.9782120139407 | 40.7717154468791 | 6A-AM-1006-05 | 06A | AM | 10062018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | tree | false | false | true | false | false | false | false | false | true | true | false | false | false | curious | POINT (-73.9782120139407 40.7717154468791) | 19 | 4 | 19 | 13 | |||
1058 | 1058 | -73.9737100743183 | 40.7708360121735 | 7E-PM-1013-03 | 07E | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | Ground & Tree Base | false | false | false | false | true | false | false | false | true | true | false | true | false | POINT (-73.9737100743183 40.7708360121735) | 19 | 4 | 19 | 13 | |||||
1059 | 1059 | -73.9749457516921 | 40.7676712372245 | 3F-PM-1013-07 | 03F | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9749457516921 40.7676712372245) | 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 | ||||||
1135 | 1135 | -73.9667474482967 | 40.7760643720793 | 15H-PM-1008-01 | 15H | PM | 10082018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | Oak tree | false | true | false | false | false | watching me | false | true | false | true | false | false | false | false | observant | POINT (-73.9667474482967 40.7760643720793) | 19 | 4 | 19 | 13 | ||
1138 | 1138 | -73.9594357049738 | 40.7840678890949 | 25I-AM-1012-01 | 25I | AM | 10122018 | 1 | Adult | Cinnamon | Cinnamon+ | Above Ground | 4 | on bar | false | false | false | true | false | false | false | false | true | true | true | false | false | POINT (-73.9594357049738 40.7840678890949) | 19 | 4 | 19 | 13 | |||||
1174 | 1174 | -73.9682067129876 | 40.7779911208015 | 16E-PM-1018-05 | 16E | PM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | staring | false | false | false | true | false | true | false | false | approaches (very close) | POINT (-73.9682067129876 40.7779911208015) | 19 | 4 | 19 | 13 | |||
1175 | 1175 | -73.9803282698463 | 40.7680809889384 | 1B-PM-1019-09 | 01B | PM | 10192018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Tree to ground | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9803282698463 40.7680809889384) | 19 | 4 | 19 | 13 | ||||
1188 | 1188 | -73.9669529835992 | 40.7871864151365 | 25A-AM-1013-05 | 25A | AM | 10132018 | 5 | Gray | Gray+ | Ground Plane | FALSE | CROSS BRIDLE - INTO TREE TO AVOID DOGGO | true | false | true | false | false | d.p.t. | false | false | false | true | true | false | true | false | calm | POINT (-73.96695298359921 40.7871864151365) | 19 | 4 | 19 | 13 | ||||
1198 | 1198 | -73.9762187733662 | 40.7739282973004 | 9B-PM-1013-08 | 09B | PM | 10132018 | 8 | Juvenile | Cinnamon | Black, White | Cinnamon+Black, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9762187733662 40.7739282973004) | 19 | 4 | 19 | 13 | |||||
1201 | 1201 | -73.9782813538421 | 40.7715730368712 | 6A-AM-1006-02 | 06A | AM | 10062018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 30 | tree | false | true | true | false | false | false | false | false | true | false | false | false | false | POINT (-73.9782813538421 40.7715730368712) | 19 | 4 | 19 | 13 | ||||
1218 | 1218 | -73.953375642605 | 40.7947144477885 | 38G-PM-1020-02 | 38G | PM | 10202018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.953375642605 40.7947144477885) | 19 | 4 | 19 | 13 | |||||
1230 | 1230 | -73.9790822606486 | 40.7714466633386 | 5A-AM-1006-03 | 05A | AM | 10062018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 8 | false | false | true | true | false | false | false | false | true | false | false | false | true | POINT (-73.9790822606486 40.7714466633386) | 19 | 4 | 19 | 13 | ||||||
1235 | 1235 | -73.9679686793869 | 40.7825993867876 | 21C-AM-1014-01 | 21C | AM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | true | false | false | false | false | jumping back & forth on tree | false | false | false | true | true | false | true | false | POINT (-73.9679686793869 40.7825993867876) | 19 | 4 | 19 | 13 | ||||
1330 | 1330 | -73.9643032554205 | 40.7794514526463 | 19H-AM-1010-02 | 19H | AM | 10102018 | 2 | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | near base of small tree | true | false | false | true | true | false | false | false | true | false | true | false | false | ran from human with dog | POINT (-73.9643032554205 40.7794514526463) | 19 | 4 | 19 | 13 | ||||
1333 | 1333 | -73.9754527701832 | 40.7656088463928 | 1G-PM-1010-02 | 01G | PM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | false | false | false | laying on tree branch | false | false | false | true | true | false | false | false | POINT (-73.9754527701832 40.7656088463928) | 19 | 4 | 19 | 13 | ||||
1367 | 1367 | -73.9542684235907 | 40.7944237164092 | 38G-PM-1020-05 | 38G | PM | 10202018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | true | false | true | false | false | true | false | POINT (-73.9542684235907 40.7944237164092) | 19 | 4 | 19 | 13 | |||||
1368 | 1368 | -73.9542770888881 | 40.7943610366853 | 38G-PM-1020-04 | 38G | PM | 10202018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | true | false | true | false | false | true | false | POINT (-73.9542770888881 40.79436103668531) | 19 | 4 | 19 | 13 | |||||
1403 | 1403 | -73.9761632586697 | 40.7741085606149 | 9B-PM-1013-05 | 09B | PM | 10132018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9761632586697 40.7741085606149) | 19 | 4 | 19 | 13 | |||||
1415 | 1415 | -73.9678561384348 | 40.7782877397822 | 16E-PM-1018-02 | 16E | PM | 10182018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | true | false | false | false | false | false | false | true | false | false | false | false | gets distance from people but then continues to chase #1 | POINT (-73.9678561384348 40.7782877397822) | 19 | 4 | 19 | 13 | ||||
1421 | 1421 | -73.9595022290348 | 40.7831151330074 | 25I-PM-1007-02 | 25I | PM | 10072018 | 2 | Adult | Gray | White | Gray+White | white belly | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | true | false | false | true | POINT (-73.9595022290348 40.783115133007406) | 19 | 4 | 19 | 13 | ||||
1481 | 1481 | -73.9538867186376 | 40.7941409434007 | 38G-PM-1020-03 | 38G | PM | 10202018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9538867186376 40.7941409434007) | 19 | 4 | 19 | 13 | |||||
1509 | 1509 | -73.9556450015702 | 40.7967188058002 | 39E-AM-1018-04 | 39E | AM | 10182018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9556450015702 40.7967188058002) | 19 | 4 | 19 | 13 | ||||||
1514 | 1514 | -73.9548006161673 | 40.7945503341011 | 38G-PM-1020-08 | 38G | PM | 10202018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | true | false | false | true | false | false | true | false | POINT (-73.9548006161673 40.7945503341011) | 19 | 4 | 19 | 13 | |||||
1523 | 1523 | -73.9673103881521 | 40.7874267409618 | 26A-PM-1006-01 | 26A | PM | 10062018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9673103881521 40.7874267409618) | 19 | 4 | 19 | 13 | |||||
1529 | 1529 | -73.9692401421068 | 40.7707128895661 | 8I-AM-1006-04 | 08I | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9692401421068 40.7707128895661) | 19 | 4 | 19 | 13 | |||||
1531 | 1531 | -73.9630381400083 | 40.7807571827321 | 21H-PM-1018-02 | 21H | PM | 10182018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9630381400083 40.7807571827321) | 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 | |||||
1636 | 1636 | -73.9701408623121 | 40.7695511718541 | 7I-PM-1013-04 | 07I | PM | 10132018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | Grass | true | false | false | true | false | false | false | false | true | false | false | false | false | POINT (-73.9701408623121 40.7695511718541) | 19 | 4 | 19 | 13 | ||||
1660 | 1660 | -73.9800499498034 | 40.7702181099573 | 4A-PM-1007-05 | 04A | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | At rock | false | false | false | false | true | false | false | false | true | true | false | true | false | POINT (-73.9800499498034 40.770218109957305) | 19 | 4 | 19 | 13 | ||||
1722 | 1722 | -73.9802564685265 | 40.7681759098199 | 2B-AM-1010-05 | 02B | AM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9802564685265 40.7681759098199) | 19 | 4 | 19 | 13 | |||||
1795 | 1795 | -73.968004352343 | 40.7726669278308 | 11I-PM-1012-01 | 11I | PM | 10122018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | true | false | false | false | true | true | false | false | false | look at humans determining | POINT (-73.968004352343 40.7726669278308) | 19 | 4 | 19 | 13 | |||||
1808 | 1808 | -73.9698870647042 | 40.7826510985538 | 20B-AM-1007-02 | 20B | AM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | true | true | false | false | POINT (-73.9698870647042 40.7826510985538) | 19 | 4 | 19 | 13 | |||||
1815 | 1815 | -73.9603268255317 | 40.7900154505092 | 31E-PM-1006-06 | 31E | PM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9603268255317 40.7900154505092) | 19 | 4 | 19 | 13 | |||||
1818 | 1818 | -73.956863563379 | 40.7986418851147 | 41C-AM-1017-01 | 41C | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.95686356337902 40.7986418851147) | 19 | 4 | 19 | 13 | ||||||
1836 | 1836 | -73.9751056714758 | 40.7732060035215 | 8C-PM-1013-03 | 08C | PM | 10132018 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | true | false | POINT (-73.9751056714758 40.7732060035215) | 19 | 4 | 19 | 13 | |||||
1910 | 1910 | -73.9699876501742 | 40.7742482676758 | 12F-PM-1007-06 | 12F | PM | 10072018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | true | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9699876501742 40.77424826767581) | 19 | 4 | 19 | 13 | |||||
1944 | 1944 | -73.9743292066413 | 40.7756090404121 | 11B-AM-1007-05 | 11B | AM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | true | false | true | false | false | POINT (-73.9743292066413 40.7756090404121) | 19 | 4 | 19 | 13 | ||||||
1956 | 1956 | -73.980897497712 | 40.7690578709841 | 2A-PM-1019-02 | 02A | PM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | false | POINT (-73.980897497712 40.7690578709841) | 19 | 4 | 19 | 13 | |||||
1959 | 1959 | -73.9707737073771 | 40.7800373465838 | 17B-PM-1012-02 | 17B | PM | 10122018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | true | true | false | false | true | 2/3 chasing each other | true | true | false | true | true | false | true | false | POINT (-73.9707737073771 40.7800373465838) | 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 |
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 );