This data as json, CSV (advanced)
Suggested facets: Shift, 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, Tail flags, Tail twitches
Hectare Squirrel Number ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
142 | 142 | -73.9724063986771 | 40.7705711897977 | 7F-PM-1012-01 | 07F | PM | 10122018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9724063986771 40.7705711897977) | 19 | 4 | 19 | 13 | ||||||
165 | 165 | -73.969058856545 | 40.7766356226979 | 14F-PM-1012-06 | 14F | PM | 10122018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.969058856545 40.7766356226979) | 19 | 4 | 19 | 13 | |||||
221 | 221 | -73.9665709146738 | 40.7839384318554 | 22D-PM-1012-04 | 22D | PM | 10122018 | 4 | 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.9665709146738 40.7839384318554) | 19 | 4 | 19 | 13 | |||||
255 | 255 | -73.9800669115792 | 40.7676825134384 | 1B-AM-1012-07 | 01B | AM | 10122018 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2 | on tree trunk | false | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9800669115792 40.7676825134384) | 19 | 4 | 19 | 13 | |||||
267 | 267 | -73.9754742295091 | 40.7696998327247 | 5E-PM-1012-02 | 05E | PM | 10122018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9754742295091 40.7696998327247) | 19 | 4 | 19 | 13 | |||||
285 | 285 | -73.9691433356733 | 40.7731708333242 | 11G-AM-1012-01 | 11G | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9691433356733 40.77317083332421) | 19 | 4 | 19 | 13 | |||||
328 | 328 | -73.9652357279671 | 40.7819296887147 | 21E-PM-1012-02 | 21E | PM | 10122018 | 2 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9652357279671 40.7819296887147) | 19 | 4 | 19 | 13 | |||||
344 | 344 | -73.9759432151552 | 40.7733240612552 | 8B-PM-1012-06 | 08B | PM | 10122018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 2 | on a bench | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9759432151552 40.7733240612552) | 19 | 4 | 19 | 13 | ||||
392 | 392 | -73.9802376131034 | 40.7680707516627 | 1B-AM-1012-12 | 01B | AM | 10122018 | 12 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9802376131034 40.7680707516627) | 19 | 4 | 19 | 13 | |||||
404 | 404 | -73.9680774548516 | 40.7762491903691 | 14F-PM-1012-01 | 14F | PM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9680774548516 40.7762491903691) | 19 | 4 | 19 | 13 | |||||
424 | 424 | -73.9756557086441 | 40.773296289824 | 8B-PM-1012-08 | 08B | PM | 10122018 | 8 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9756557086441 40.773296289824) | 19 | 4 | 19 | 13 | |||||
485 | 485 | -73.9677423154682 | 40.7728813350245 | 11I-AM-1012-02 | 11I | AM | 10122018 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9677423154682 40.77288133502451) | 19 | 4 | 19 | 13 | |||||
565 | 565 | -73.9615402629655 | 40.7924082330328 | 33C-AM-1012-02 | 33C | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon along back & tail | Above Ground | 20 | tree branches | false | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9615402629655 40.7924082330328) | 19 | 4 | 19 | 13 | |||
571 | 571 | -73.9659549963516 | 40.7833659689194 | 22D-PM-1012-05 | 22D | PM | 10122018 | 5 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9659549963516 40.7833659689194) | 19 | 4 | 19 | 13 | |||||||
640 | 640 | -73.9785536529136 | 40.7716184505002 | 6A-PM-1012-07 | 06A | PM | 10122018 | 7 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | elevated ground | false | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9785536529136 40.771618450500206) | 19 | 4 | 19 | 13 | ||||
657 | 657 | -73.9679008849677 | 40.7759013923034 | 14G-AM-1012-02 | 14G | AM | 10122018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9679008849677 40.7759013923034) | 19 | 4 | 19 | 13 | ||||||
684 | 684 | -73.9691057326088 | 40.7765973509721 | 14F-PM-1012-07 | 14F | PM | 10122018 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | true | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9691057326088 40.7765973509721) | 19 | 4 | 19 | 13 | |||||
765 | 765 | -73.96797780019 | 40.7847629473258 | 23B-PM-1012-05 | 23B | PM | 10122018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | chain link fence | false | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.96797780019 40.7847629473258) | 19 | 4 | 19 | 13 | ||||
776 | 776 | -73.9686816795392 | 40.775770422667 | 14F-PM-1012-02 | 14F | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 3 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9686816795392 40.775770422667) | 19 | 4 | 19 | 13 | |||||
788 | 788 | -73.9687476703117 | 40.7742856696093 | 12G-AM-1012-01 | 12G | AM | 10122018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9687476703117 40.7742856696093) | 19 | 4 | 19 | 13 | |||||
798 | 798 | -73.980854228628 | 40.7678702158382 | 1B-AM-1012-17 | 01B | AM | 10122018 | 17 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.98085422862802 40.7678702158382) | 19 | 4 | 19 | 13 | |||||
832 | 832 | -73.9676206022477 | 40.784594234984 | 23B-PM-1012-01 | 23B | PM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9676206022477 40.784594234984) | 19 | 4 | 19 | 13 | |||||
880 | 880 | -73.9565684577989 | 40.7936003940413 | 36F-PM-1012-02 | 36F | PM | 10122018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9565684577989 40.7936003940413) | 19 | 4 | 19 | 13 | |||||
1031 | 1031 | -73.9766593636657 | 40.7735708178842 | 8B-PM-1012-04 | 08B | PM | 10122018 | 4 | 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.9766593636657 40.7735708178842) | 19 | 4 | 19 | 13 | |||||
1100 | 1100 | -73.980542388615 | 40.7682048804794 | 1B-AM-1012-14 | 01B | AM | 10122018 | 14 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.980542388615 40.7682048804794) | 19 | 4 | 19 | 13 | ||||||
1123 | 1123 | -73.9670858934045 | 40.7753505024976 | 14H-PM-1012-02 | 14H | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9670858934045 40.7753505024976) | 19 | 4 | 19 | 13 | |||||
1166 | 1166 | -73.980048119915 | 40.7676638655026 | 1B-AM-1012-06 | 01B | AM | 10122018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.980048119915 40.7676638655026) | 19 | 4 | 19 | 13 | |||||
1249 | 1249 | -73.9590132705889 | 40.7952248279764 | 37C-AM-1012-03 | 37C | AM | 10122018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon flanks | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9590132705889 40.7952248279764) | 19 | 4 | 19 | 13 | ||||
1284 | 1284 | -73.9570891696776 | 40.7935448802241 | 36E-PM-1012-01 | 36E | PM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9570891696776 40.7935448802241) | 19 | 4 | 19 | 13 | |||||
1299 | 1299 | -73.9766653663947 | 40.7688767713012 | 4D-AM-1012-01 | 04D | AM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9766653663947 40.7688767713012) | 19 | 4 | 19 | 13 | |||||
1318 | 1318 | -73.9714907235676 | 40.774058386152 | 11E-PM-1012-01 | 11E | PM | 10122018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9714907235676 40.774058386152) | 19 | 4 | 19 | 13 | |||||
1349 | 1349 | -73.9806805581636 | 40.7681537966505 | 1B-AM-1012-16 | 01B | AM | 10122018 | 16 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9806805581636 40.7681537966505) | 19 | 4 | 19 | 13 | |||||
1350 | 1350 | -73.9727698663722 | 40.7714335285174 | 8F-PM-1012-06 | 08F | PM | 10122018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9727698663722 40.7714335285174) | 19 | 4 | 19 | 13 | ||||||
1435 | 1435 | -73.9582534432858 | 40.7917772296796 | 34F-PM-1012-01 | 34F | PM | 10122018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9582534432858 40.7917772296796) | 19 | 4 | 19 | 13 | |||||
1444 | 1444 | -73.9763852372393 | 40.768876248561 | 4D-AM-1012-02 | 04D | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9763852372393 40.768876248561) | 19 | 4 | 19 | 13 | |||||
1447 | 1447 | -73.9601968065017 | 40.7935831836482 | 34C-PM-1012-03 | 34C | PM | 10122018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9601968065017 40.79358318364821) | 19 | 4 | 19 | 13 | |||||
1460 | 1460 | -73.9714329979305 | 40.7741873388945 | 11E-PM-1012-04 | 11E | PM | 10122018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9714329979305 40.7741873388945) | 19 | 4 | 19 | 13 | |||||
1473 | 1473 | -73.9584064190878 | 40.7912992852442 | 33F-PM-1012-03 | 33F | PM | 10122018 | 3 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9584064190878 40.7912992852442) | 19 | 4 | 19 | 13 | |||||
1488 | 1488 | -73.9690072647093 | 40.7737712267463 | 12G-AM-1012-02 | 12G | AM | 10122018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9690072647093 40.7737712267463) | 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 | ||||||
1565 | 1565 | -73.9803895322385 | 40.7680730789944 | 1B-AM-1012-13 | 01B | AM | 10122018 | 13 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9803895322385 40.7680730789944) | 19 | 4 | 19 | 13 | |||||
1576 | 1576 | -73.9619985187616 | 40.7943277743532 | 34A-AM-1012-02 | 34A | AM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | chasing from tree to ground | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9619985187616 40.7943277743532) | 19 | 4 | 19 | 13 | ||||
1579 | 1579 | -73.9768309556127 | 40.7717803706095 | 6B-AM-1012-01 | 06B | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Started in field, crossed busy street, ran up tree | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.97683095561271 40.7717803706095) | 19 | 4 | 19 | 13 | ||||
1605 | 1605 | -73.9690362384597 | 40.7767162824413 | 14F-PM-1012-09 | 14F | PM | 10122018 | 9 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9690362384597 40.7767162824413) | 19 | 4 | 19 | 13 | |||||
1690 | 1690 | -73.96052295327 | 40.7934359372871 | 34C-PM-1012-04 | 34C | PM | 10122018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.96052295327 40.7934359372871) | 19 | 4 | 19 | 13 | ||||||
1710 | 1710 | -73.9545438656122 | 40.7902168635009 | 34I-AM-1012-04 | 34I | AM | 10122018 | 4 | 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.9545438656122 40.7902168635009) | 19 | 4 | 19 | 13 | |||||
1716 | 1716 | -73.9797425262459 | 40.7679120246352 | 1B-AM-1012-02 | 01B | AM | 10122018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9797425262459 40.7679120246352) | 19 | 4 | 19 | 13 | |||||
1744 | 1744 | -73.9584661589182 | 40.7912068380845 | 33F-PM-1012-01 | 33F | PM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9584661589182 40.7912068380845) | 19 | 4 | 19 | 13 | |||||
1772 | 1772 | -73.9690540696008 | 40.7766014124609 | 14F-PM-1012-08 | 14F | PM | 10122018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | true | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9690540696008 40.7766014124609) | 19 | 4 | 19 | 13 | |||||
1781 | 1781 | -73.96005650463 | 40.7934048502983 | 34C-PM-1012-02 | 34C | PM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.96005650463 40.7934048502983) | 19 | 4 | 19 | 13 | |||||
1806 | 1806 | -73.9657504643585 | 40.7831210813592 | 22D-PM-1012-02 | 22D | PM | 10122018 | 2 | Adult | Gray | Black, White | Gray+Black, White | No Primary Fur Color selected. Made executive adjustment based on other squirrels. | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9657504643585 40.7831210813592) | 19 | 4 | 19 | 13 | ||||
1841 | 1841 | -73.9806377967573 | 40.7681097168268 | 1B-AM-1012-15 | 01B | AM | 10122018 | 15 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9806377967573 40.7681097168268) | 19 | 4 | 19 | 13 | ||||||
2023 | 2023 | -73.9663977261879 | 40.775645134229 | 14H-PM-1012-08 | 14H | PM | 10122018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9663977261879 40.775645134229) | 19 | 4 | 19 | 13 | |||||
2069 | 2069 | -73.9538377039825 | 40.7980605334961 | 42E-PM-1012-03 | 42E | PM | 10122018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 20 | in tree | false | false | true | false | true | true | false | false | false | false | false | true | false | POINT (-73.9538377039825 40.7980605334961) | 19 | 4 | 19 | 13 | ||||
2106 | 2106 | -73.9801651470389 | 40.7677698656935 | 1B-AM-1012-05 | 01B | AM | 10122018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9801651470389 40.7677698656935) | 19 | 4 | 19 | 13 | |||||
2155 | 2155 | -73.9538938706987 | 40.7981150065974 | 42E-PM-1012-05 | 42E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9538938706987 40.7981150065974) | 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 | |||||
2232 | 2232 | -73.9566277721581 | 40.7966674587803 | 39D-PM-1012-04 | 39D | PM | 10122018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 10 | on tree trunk (descending from height of ~10 ft) | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.95662777215811 40.7966674587803) | 19 | 4 | 19 | 13 | ||||
2277 | 2277 | -73.95385121459 | 40.7981257651433 | 42E-PM-1012-04 | 42E | PM | 10122018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.95385121459 40.7981257651433) | 19 | 4 | 19 | 13 | |||||
2304 | 2304 | -73.9715251156965 | 40.774621784862 | 11E-PM-1012-07 | 11E | PM | 10122018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9715251156965 40.774621784862) | 19 | 4 | 19 | 13 | |||||
2306 | 2306 | -73.956453902485 | 40.7936584431012 | 36F-PM-1012-05 | 36F | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.956453902485 40.7936584431012) | 19 | 4 | 19 | 13 | |||||
2309 | 2309 | -73.966824257293 | 40.7753405377869 | 14H-PM-1012-04 | 14H | PM | 10122018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.966824257293 40.7753405377869) | 19 | 4 | 19 | 13 | |||||
2314 | 2314 | -73.9663961415789 | 40.7750691120996 | 14H-PM-1012-06 | 14H | PM | 10122018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary with a note that it was "hard to tell". | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9663961415789 40.7750691120996) | 19 | 4 | 19 | 13 | ||||
2317 | 2317 | -73.9767369686171 | 40.7735074437085 | 8B-PM-1012-05 | 08B | PM | 10122018 | 5 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9767369686171 40.7735074437085) | 19 | 4 | 19 | 13 | |||||
2323 | 2323 | -73.9715921982161 | 40.7746153066601 | 11E-PM-1012-06 | 11E | PM | 10122018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Above Ground | 5 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9715921982161 40.7746153066601) | 19 | 4 | 19 | 13 | ||||
2367 | 2367 | -73.9681671864047 | 40.7753770538635 | 14G-AM-1012-04 | 14G | AM | 10122018 | 4 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9681671864047 40.7753770538635) | 19 | 4 | 19 | 13 | |||||
2369 | 2369 | -73.9801956082236 | 40.767836440957 | 1B-AM-1012-08 | 01B | AM | 10122018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9801956082236 40.767836440957) | 19 | 4 | 19 | 13 | |||||
2430 | 2430 | -73.9569811285656 | 40.793091234605 | 35F-PM-1012-02 | 35F | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9569811285656 40.793091234605) | 19 | 4 | 19 | 13 | |||||
2447 | 2447 | -73.9589670987899 | 40.7952127039287 | 37C-AM-1012-04 | 37C | AM | 10122018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon flanks | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9589670987899 40.7952127039287) | 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 | |||||
2487 | 2487 | -73.9595222999173 | 40.7833202577782 | 25I-AM-1012-02 | 25I | AM | 10122018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 31 | on tree | true | true | false | false | false | false | false | false | true | true | false | true | false | POINT (-73.9595222999173 40.7833202577782) | 19 | 4 | 19 | 13 | ||||
2492 | 2492 | -73.9801619956135 | 40.7678576697542 | 1B-AM-1012-09 | 01B | AM | 10122018 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9801619956135 40.7678576697542) | 19 | 4 | 19 | 13 | ||||||
2538 | 2538 | -73.9796985410897 | 40.7678612835067 | 1B-AM-1012-01 | 01B | AM | 10122018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9796985410897 40.7678612835067) | 19 | 4 | 19 | 13 | ||||||
2568 | 2568 | -73.9779039082557 | 40.7675313108314 | 2D-PM-1012-01 | 02D | PM | 10122018 | 1 | 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.9779039082557 40.7675313108314) | 19 | 4 | 19 | 13 | |||||
2591 | 2591 | -73.9786351029146 | 40.7716114164002 | 6A-PM-1012-06 | 06A | PM | 10122018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | elevated ground | false | true | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9786351029146 40.771611416400205) | 19 | 4 | 19 | 13 | ||||
2598 | 2598 | -73.976658503418 | 40.7686868456917 | 4D-AM-1012-03 | 04D | AM | 10122018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.976658503418 40.7686868456917) | 19 | 4 | 19 | 13 | ||||||
2652 | 2652 | -73.9620542514749 | 40.7943731722138 | 34A-AM-1012-01 | 34A | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | chasing from tree to ground | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9620542514749 40.7943731722138) | 19 | 4 | 19 | 13 | ||||
2691 | 2691 | -73.9564599077179 | 40.7965185098695 | 39D-PM-1012-01 | 39D | PM | 10122018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9564599077179 40.7965185098695) | 19 | 4 | 19 | 13 | |||||
2806 | 2806 | -73.9714298880357 | 40.77410578689 | 11E-PM-1012-02 | 11E | PM | 10122018 | 2 | 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.9714298880357 40.77410578689) | 19 | 4 | 19 | 13 | |||||
2823 | 2823 | -73.9664054327771 | 40.7756180893318 | 14H-PM-1012-07 | 14H | PM | 10122018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9664054327771 40.7756180893318) | 19 | 4 | 19 | 13 | |||||
2860 | 2860 | -73.9565179671319 | 40.7936663940365 | 36F-PM-1012-03 | 36F | PM | 10122018 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.95651796713192 40.7936663940365) | 19 | 4 | 19 | 13 | ||||||
2872 | 2872 | -73.9615396457996 | 40.7923594366783 | 33C-AM-1012-01 | 33C | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon along tail & back | Above Ground | 20 | tree branches | false | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9615396457996 40.7923594366783) | 19 | 4 | 19 | 13 | |||
2903 | 2903 | -73.9670432105975 | 40.7753462013506 | 14H-PM-1012-03 | 14H | PM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9670432105975 40.7753462013506) | 19 | 4 | 19 | 13 | |||||
2981 | 2981 | -73.9800094828465 | 40.7677782585639 | 1B-AM-1012-04 | 01B | AM | 10122018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9800094828465 40.7677782585639) | 19 | 4 | 19 | 13 | ||||||
2986 | 2986 | -73.9756533763813 | 40.7733537881363 | 8B-PM-1012-07 | 08B | PM | 10122018 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9756533763813 40.7733537881363) | 19 | 4 | 19 | 13 | |||||
2988 | 2988 | -73.9766342759486 | 40.7687518380873 | 4D-AM-1012-04 | 04D | AM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | on tree trunk | false | true | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9766342759486 40.7687518380873) | 19 | 4 | 19 | 13 | |||||
3000 | 3000 | -73.9688293382172 | 40.7738958027568 | 12G-AM-1012-04 | 12G | AM | 10122018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9688293382172 40.773895802756805) | 19 | 4 | 19 | 13 | |||||
3021 | 3021 | -73.9665871993517 | 40.7836775064883 | 22D-PM-1012-07 | 22D | PM | 10122018 | 7 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9665871993517 40.7836775064883) | 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 | |||||
2213 | 2213 | -73.9707487237344 | 40.7800822831001 | 17B-PM-1012-03 | 17B | PM | 10122018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | true | true | false | false | false | 2/3 chasing each other | false | false | false | false | true | false | true | false | POINT (-73.9707487237344 40.7800822831001) | 19 | 4 | 19 | 13 | ||||
345 | 345 | -73.9724452296309 | 40.7715792113505 | 8F-PM-1012-03 | 08F | PM | 10122018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | buried an acorn | false | false | false | false | false | false | true | false | POINT (-73.9724452296309 40.7715792113505) | 19 | 4 | 19 | 13 | ||||
1477 | 1477 | -73.9589635326362 | 40.7951748673846 | 37C-AM-1012-02 | 37C | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon flanks, light band across nose | Ground Plane | FALSE | false | false | false | false | true | caching | false | false | false | false | false | false | true | false | POINT (-73.9589635326362 40.7951748673846) | 19 | 4 | 19 | 13 | |||
2638 | 2638 | -73.9598973337711 | 40.7933346360478 | 34C-PM-1012-01 | 34C | PM | 10122018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | false | true | false | POINT (-73.9598973337711 40.7933346360478) | 19 | 4 | 19 | 13 | |||||
1001 | 1001 | -73.9801985977846 | 40.7680159511705 | 1B-AM-1012-11 | 01B | AM | 10122018 | 11 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | true | false | fighting w/ pigeons | false | false | false | false | false | false | true | false | POINT (-73.9801985977846 40.7680159511705) | 19 | 4 | 19 | 13 | ||||
1456 | 1456 | -73.9714242426496 | 40.7744535798123 | 11E-PM-1012-05 | 11E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | true | foraging (foraged,ran to tree root,munched) | false | false | false | false | false | false | true | false | POINT (-73.9714242426496 40.7744535798123) | 19 | 4 | 19 | 13 | ||||
2666 | 2666 | -73.9763593390732 | 40.7717297058549 | 7C-AM-1012-03 | 07C | AM | 10122018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | foraging (loving the acorns!) | false | false | false | false | false | false | true | false | POINT (-73.97635933907321 40.7717297058549) | 19 | 4 | 19 | 13 | ||||
2808 | 2808 | -73.9765027953575 | 40.7717327360835 | 7C-AM-1012-02 | 07C | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | hopping around | false | false | false | false | false | false | true | false | POINT (-73.9765027953575 40.7717327360835) | 19 | 4 | 19 | 13 | ||||
2627 | 2627 | -73.9766348078633 | 40.7717715634438 | 7C-AM-1012-01 | 07C | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | hopping around grass | false | false | false | false | false | false | true | false | POINT (-73.9766348078633 40.7717715634438) | 19 | 4 | 19 | 13 | ||||
2480 | 2480 | -73.9546780963388 | 40.7903216522111 | 34I-AM-1012-03 | 34I | AM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | false | nut in mouth | false | false | false | false | false | false | true | false | POINT (-73.9546780963388 40.7903216522111) | 19 | 4 | 19 | 13 | ||||
1697 | 1697 | -73.9568610943394 | 40.7935959584643 | 36E-PM-1012-02 | 36E | PM | 10122018 | 2 | Adult | Gray | Gray+ | Above Ground | 28 | on tree branch | false | false | true | false | true | picking acorns off oak tree | false | false | false | false | false | false | true | false | POINT (-73.95686109433942 40.7935959584643) | 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 );