This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Zip Codes, Community Districts, City Council Districts, Police Precincts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19 | 19 | -73.9768603630674 | 40.7702795904962 | 5C-PM-1010-09 | 05C | PM | 10102018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9768603630674 40.7702795904962) | 19 | 4 | 19 | 13 | |||||
84 | 84 | -73.9701824825872 | 40.7766530579293 | 14E-AM-1008-09 | 14E | AM | 10082018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | false | true | false | false | false | false | false | false | true | POINT (-73.9701824825872 40.7766530579293) | 19 | 4 | 19 | 13 | ||||||
320 | 320 | -73.9684376038582 | 40.7824275067237 | 20C-PM-1018-09 | 20C | PM | 10182018 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9684376038582 40.7824275067237) | 19 | 4 | 19 | 13 | ||||||
377 | 377 | -73.9757001944781 | 40.769499790547 | 5E-AM-1008-09 | 05E | AM | 10082018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | went up tree | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9757001944781 40.769499790547) | 19 | 4 | 19 | 13 | ||||
405 | 405 | -73.9786603147149 | 40.7671937837017 | 1D-AM-1006-09 | 01D | AM | 10062018 | 9 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9786603147149 40.7671937837017) | 19 | 4 | 19 | 13 | |||||
406 | 406 | -73.9766354967197 | 40.7734575166319 | 8B-AM-1007-09 | 08B | AM | 10072018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | shelling and eating a nut then a dog chased it up a tree & squirrel carried its nut up the tree,settled in a branch & resumed eating | false | false | false | false | false | false | true | false | POINT (-73.9766354967197 40.7734575166319) | 19 | 4 | 19 | 13 | |||||
411 | 411 | -73.9669366401071 | 40.7836023897982 | 22C-PM-1006-09 | 22C | PM | 10062018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | true | false | false | false | false | false | false | POINT (-73.96693664010711 40.7836023897982) | 19 | 4 | 19 | 13 | ||||||
556 | 556 | -73.9721670042434 | 40.776085913838 | 13D-PM-1018-09 | 13D | PM | 10182018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9721670042434 40.776085913838) | 19 | 4 | 19 | 13 | |||||
946 | 946 | -73.9654093844049 | 40.7806896368469 | 20F-PM-1007-09 | 20F | PM | 10072018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | false | POINT (-73.9654093844049 40.7806896368469) | 19 | 4 | 19 | 13 | |||||
979 | 979 | -73.9612349421547 | 40.7959586475744 | 36A-PM-1013-09 | 36A | PM | 10132018 | 9 | Gray | Gray+ | Ground Plane | FALSE | THICK UNDERGROWTH | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9612349421547 40.7959586475744) | 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 | |||||
1212 | 1212 | -73.9761792189352 | 40.7745745517215 | 9A-AM-1013-09 | 09A | AM | 10132018 | 9 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9761792189352 40.7745745517215) | 19 | 4 | 19 | 13 | ||||||
1293 | 1293 | -73.9775465365348 | 40.7681943707876 | 3D-PM-1010-09 | 03D | PM | 10102018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9775465365348 40.7681943707876) | 19 | 4 | 19 | 13 | ||||||
1733 | 1733 | -73.9756345867747 | 40.7675540517649 | 3E-PM-1008-09 | 03E | PM | 10082018 | 9 | Adult | Gray | Gray+ | Above Ground | 5 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9756345867747 40.7675540517649) | 19 | 4 | 19 | 13 | ||||||
1850 | 1850 | -73.975809362521 | 40.7734702737835 | 8B-PM-1012-09 | 08B | PM | 10122018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.975809362521 40.7734702737835) | 19 | 4 | 19 | 13 | |||||
1893 | 1893 | -73.9708108312271 | 40.7773975776146 | 14D-PM-1019-09 | 14D | PM | 10192018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9708108312271 40.7773975776146) | 19 | 4 | 19 | 13 | |||||
1915 | 1915 | -73.9797112925048 | 40.7688046778472 | 2B-PM-1013-09 | 02B | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Above Ground | 30 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9797112925048 40.7688046778472) | 19 | 4 | 19 | 13 | |||||
2160 | 2160 | -73.975028559002 | 40.7667307335544 | 2F-PM-1014-09 | 02F | PM | 10142018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.975028559002 40.7667307335544) | 19 | 4 | 19 | 13 | |||||
2293 | 2293 | -73.9675309175947 | 40.7788649926486 | 17E-AM-1017-09 | 17E | AM | 10172018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9675309175947 40.7788649926486) | 19 | 4 | 19 | 13 | ||||||
2319 | 2319 | -73.9756870789187 | 40.7733646782679 | 9B-AM-1010-09 | 09B | AM | 10102018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | food in mouth | false | false | false | false | false | false | false | false | POINT (-73.9756870789187 40.7733646782679) | 19 | 4 | 19 | 13 | ||||
2384 | 2384 | -73.9708564226824 | 40.7726219968014 | 10F-PM-1019-09 | 10F | PM | 10192018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Across Arbor path into hill w/ bushes | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9708564226824 40.7726219968014) | 19 | 4 | 19 | 13 | ||||
2708 | 2708 | -73.9528429238071 | 40.7922651848867 | 36I-PM-1007-09 | 36I | PM | 10072018 | 9 | Juvenile | Gray | Gray+ | Above Ground | 5 | true | true | false | false | false | burying nut | false | false | false | false | true | false | false | false | POINT (-73.9528429238071 40.7922651848867) | 19 | 4 | 19 | 13 | |||||
2799 | 2799 | -73.9682627382073 | 40.7730766743452 | 11H-AM-1010-09 | 11H | AM | 10102018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9682627382073 40.7730766743452) | 19 | 4 | 19 | 13 | |||||
3003 | 3003 | -73.9698663926657 | 40.773999710413 | 12F-PM-1007-09 | 12F | PM | 10072018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9698663926657 40.773999710413) | 19 | 4 | 19 | 13 | |||||
152 | 152 | -73.9755133710665 | 40.7697883435981 | 5E-AM-1008-08 | 05E | AM | 10082018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9755133710665 40.7697883435981) | 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 | |||||
885 | 885 | -73.9750463844984 | 40.7666871742836 | 2F-PM-1014-08 | 02F | PM | 10142018 | 8 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9750463844984 40.7666871742836) | 19 | 4 | 19 | 13 | |||||
895 | 895 | -73.9786898656279 | 40.7720833097065 | 6A-AM-1006-08 | 06A | AM | 10062018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9786898656279 40.77208330970651) | 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 | |||
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 | |||||
957 | 957 | -73.9586527721822 | 40.7908831110561 | 32F-PM-1008-08 | 32F | PM | 10082018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9586527721822 40.7908831110561) | 19 | 4 | 19 | 13 | |||||
1000 | 1000 | -73.9805137046778 | 40.769275143797 | 2A-AM-1010-08 | 02A | AM | 10102018 | 8 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9805137046778 40.769275143797) | 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 | ||||||
1065 | 1065 | -73.9769700777377 | 40.7728489574967 | 7B-AM-1008-08 | 07B | AM | 10082018 | 8 | Adult | Gray | Gray+ | Above Ground | 5 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9769700777377 40.7728489574967) | 19 | 4 | 19 | 13 | ||||||
1084 | 1084 | -73.9698839750249 | 40.7781433076692 | 16D-PM-1010-08 | 16D | PM | 10102018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | true | false | false | false | false | false | true | false | POINT (-73.9698839750249 40.7781433076692) | 19 | 4 | 19 | 13 | ||||||
1102 | 1102 | -73.9688173465755 | 40.7782009764626 | 16E-AM-1014-08 | 16E | AM | 10142018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.9688173465755 40.7782009764626) | 19 | 4 | 19 | 13 | |||||
1125 | 1125 | -73.9775735077285 | 40.7692872082165 | 4C-PM-1010-08 | 04C | PM | 10102018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | on stone arch | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9775735077285 40.7692872082165) | 19 | 4 | 19 | 13 | ||||
1199 | 1199 | -73.9756993198381 | 40.7681956641913 | 3E-PM-1008-08 | 03E | PM | 10082018 | 8 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9756993198381 40.7681956641913) | 19 | 4 | 19 | 13 | ||||||
1270 | 1270 | -73.967762162893 | 40.7823359027165 | 20C-PM-1018-08 | 20C | PM | 10182018 | 8 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | true | runs from (dog) | POINT (-73.967762162893 40.7823359027165) | 19 | 4 | 19 | 13 | |||||
1532 | 1532 | -73.9779263114572 | 40.7682681855369 | 3D-PM-1010-08 | 03D | PM | 10102018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9779263114572 40.7682681855369) | 19 | 4 | 19 | 13 | |||||
1684 | 1684 | -73.9637824756607 | 40.7904737110761 | 30B-AM-1007-08 | 30B | AM | 10072018 | 8 | Adult | Gray | Gray+ | Above Ground | 40 | true | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9637824756607 40.7904737110761) | 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 | |||||
2214 | 2214 | -73.9583688637255 | 40.791388958496 | 33E-PM-1012-08 | 33E | PM | 10122018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9583688637255 40.791388958496) | 19 | 4 | 19 | 13 | |||||
2289 | 2289 | -73.9745800592393 | 40.767356541975 | 3F-AM-1006-08 | 03F | AM | 10062018 | 8 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | close to tall tree & light post | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9745800592393 40.767356541975) | 19 | 4 | 19 | 13 | ||||
2657 | 2657 | -73.9582150734453 | 40.7962862794303 | 38C-AM-1019-08 | 38C | AM | 10192018 | 8 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | true | false | false | false | false | false | true | false | POINT (-73.9582150734453 40.7962862794303) | 19 | 4 | 19 | 13 | |||||
2662 | 2662 | -73.9708628933624 | 40.7725630886784 | 10F-PM-1019-08 | 10F | PM | 10192018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Under "Grape Arbor" structure behind Bandshell | true | false | false | false | true | digging | false | false | false | false | false | false | false | true | POINT (-73.9708628933624 40.7725630886784) | 19 | 4 | 19 | 13 | |||
2710 | 2710 | -73.9577919365342 | 40.7960853285059 | 38C-PM-1014-08 | 38C | PM | 10142018 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | true | false | false | false | false | false | false | true | POINT (-73.9577919365342 40.7960853285059) | 19 | 4 | 19 | 13 | |||||
2735 | 2735 | -73.9768096953647 | 40.7708185213129 | 5C-PM-1010-08 | 05C | PM | 10102018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9768096953647 40.7708185213129) | 19 | 4 | 19 | 13 | |||||
2939 | 2939 | -73.9680204438195 | 40.7743882322654 | 13H-PM-1010-08 | 13H | PM | 10102018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9680204438195 40.77438823226541) | 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 | |||||
28 | 28 | -73.958736593111 | 40.7908524370626 | 32F-PM-1008-07 | 32F | PM | 10082018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.958736593111 40.7908524370626) | 19 | 4 | 19 | 13 | ||||||
125 | 125 | -73.9651601541795 | 40.7761841788025 | 15I-PM-1012-07 | 15I | PM | 10122018 | 7 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9651601541795 40.7761841788025) | 19 | 4 | 19 | 13 | ||||||
237 | 237 | -73.967895656898 | 40.7767409597341 | 15F-PM-1010-07 | 15F | PM | 10102018 | 7 | Adult | Gray | Gray+ | Above Ground | 3 | on fence | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.967895656898 40.7767409597341) | 19 | 4 | 19 | 13 | |||||
284 | 284 | -73.9547336666137 | 40.7938937756332 | 37G-PM-1007-07 | 37G | PM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9547336666137 40.7938937756332) | 19 | 4 | 19 | 13 | |||||
312 | 312 | -73.958356112357 | 40.796014459571 | 38C-AM-1019-07 | 38C | AM | 10192018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.958356112357 40.796014459571) | 19 | 4 | 19 | 13 | ||||
322 | 322 | -73.9546042927016 | 40.7898133734952 | 33I-PM-1006-07 | 33I | PM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9546042927016 40.7898133734952) | 19 | 4 | 19 | 13 | ||||||
434 | 434 | -73.9676639740486 | 40.7745369616499 | 13H-PM-1010-07 | 13H | PM | 10102018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9676639740486 40.7745369616499) | 19 | 4 | 19 | 13 | ||||||
547 | 547 | -73.9559677963727 | 40.7951124076946 | 38E-AM-1010-07 | 38E | AM | 10102018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | branches | true | true | false | false | false | chasing and being chased by #6 | false | false | false | false | true | false | false | true | POINT (-73.9559677963727 40.7951124076946) | 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 | ||||
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 | |||||
772 | 772 | -73.9584188461059 | 40.7913241048498 | 33E-PM-1012-07 | 33E | PM | 10122018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9584188461059 40.7913241048498) | 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 | |||||
1090 | 1090 | -73.967767372181 | 40.784702631615 | 23B-PM-1012-07 | 23B | PM | 10122018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.967767372181 40.784702631615) | 19 | 4 | 19 | 13 | |||||
1142 | 1142 | -73.9765805609072 | 40.7692807820935 | 4D-PM-1008-07 | 04D | PM | 10082018 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | hopped over fence and chased # 6 around tree & ran it to end of lawn | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9765805609072 40.7692807820935) | 19 | 4 | 19 | 13 | ||||
1236 | 1236 | -73.9792039071114 | 40.7678749471267 | 2C-AM-1010-07 | 02C | AM | 10102018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | true | false | false | false | #7 & #8 chased each other up diff tree | false | false | false | false | false | false | false | true | POINT (-73.9792039071114 40.76787494712671) | 19 | 4 | 19 | 13 | ||||
1338 | 1338 | -73.9716624574422 | 40.7762037110101 | 13D-PM-1018-07 | 13D | PM | 10182018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | true | false | true | false | false | scratching | false | false | false | false | false | false | true | false | POINT (-73.9716624574422 40.7762037110101) | 19 | 4 | 19 | 13 | ||||
1442 | 1442 | -73.961241953418 | 40.7941677113011 | 35B-PM-1013-07 | 35B | PM | 10132018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | true | false | got fed twice by grandpa,grabbed from grass and ate in tree | false | false | false | false | false | true | true | true | approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up. | POINT (-73.961241953418 40.7941677113011) | 19 | 4 | 19 | 13 | ||||
1484 | 1484 | -73.9716736557408 | 40.7749333494336 | 12E-AM-1017-07 | 12E | AM | 10172018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9716736557408 40.7749333494336) | 19 | 4 | 19 | 13 | |||||
1517 | 1517 | -73.970041085185 | 40.7834427580313 | 21A-AM-1019-07 | 21A | AM | 10192018 | 7 | Adult | Gray | Gray+ | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.970041085185 40.783442758031306) | 19 | 4 | 19 | 13 | ||||||
1648 | 1648 | -73.9790263372004 | 40.7683513714892 | 2C-PM-1013-07 | 02C | PM | 10132018 | 7 | Adult | Gray | White | Gray+White | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9790263372004 40.7683513714892) | 19 | 4 | 19 | 13 | |||||||
1656 | 1656 | -73.9557399927792 | 40.7971563708988 | 40D-PM-1013-07 | 40D | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9557399927792 40.7971563708988) | 19 | 4 | 19 | 13 | |||||
1765 | 1765 | -73.9689041600147 | 40.7781788966185 | 16E-AM-1014-07 | 16E | AM | 10142018 | 7 | Adult | Gray | Gray+ | Above Ground | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.9689041600147 40.7781788966185) | 19 | 4 | 19 | 13 | ||||||
1889 | 1889 | -73.9679319758284 | 40.7821154802399 | 20C-PM-1018-07 | 20C | PM | 10182018 | 7 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9679319758284 40.7821154802399) | 19 | 4 | 19 | 13 | |||||
2080 | 2080 | -73.954530253849 | 40.7910247489879 | 34I-PM-1010-07 | 34I | PM | 10102018 | 7 | Adult | Gray | Gray+ | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.954530253849 40.7910247489879) | 19 | 4 | 19 | 13 | ||||||||
2193 | 2193 | -73.9569318105253 | 40.7973442139041 | 40C-PM-1006-07 | 40C | PM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9569318105253 40.7973442139041) | 19 | 4 | 19 | 13 | ||||||
2210 | 2210 | -73.9699124811406 | 40.7743016981538 | 12F-PM-1007-07 | 12F | PM | 10072018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | true | true | false | true | false | false | false | true | false | false | true | false | POINT (-73.9699124811406 40.7743016981538) | 19 | 4 | 19 | 13 | |||||
2217 | 2217 | -73.9652746477521 | 40.7809326848536 | 20F-PM-1007-07 | 20F | PM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | cinnamon tail | Ground Plane | FALSE | true | false | false | false | false | watching | false | false | false | true | false | false | false | true | POINT (-73.96527464775211 40.7809326848536) | 19 | 4 | 19 | 13 | |||
2261 | 2261 | -73.9609692861012 | 40.790502891247 | 31D-AM-1014-07 | 31D | AM | 10142018 | 7 | Gray | Gray+ | Ground Plane | FALSE | Crossing path to tree | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9609692861012 40.790502891247) | 19 | 4 | 19 | 13 | ||||||
2301 | 2301 | -73.968906907671 | 40.7816278267843 | 19C-PM-1018-07 | 19C | PM | 10182018 | 7 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.968906907671 40.7816278267843) | 19 | 4 | 19 | 13 | ||||
2454 | 2454 | -73.9565151662506 | 40.7946647987447 | 37E-PM-1006-07 | 37E | PM | 10062018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | true | me | POINT (-73.9565151662506 40.7946647987447) | 19 | 4 | 19 | 13 | ||||
2462 | 2462 | -73.9768544488742 | 40.7680069500977 | 3D-AM-1006-07 | 03D | AM | 10062018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | running (with food in mouth) | false | false | false | false | false | false | true | false | POINT (-73.9768544488742 40.7680069500977) | 19 | 4 | 19 | 13 | ||||
2513 | 2513 | -73.9767590273554 | 40.7717561807266 | 6B-PM-1017-07 | 06B | PM | 10172018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9767590273554 40.7717561807266) | 19 | 4 | 19 | 13 | |||||
2707 | 2707 | -73.9743165321099 | 40.7754674678574 | 11B-PM-1014-07 | 11B | PM | 10142018 | 7 | Gray | Gray+ | Above Ground | 10 | true | false | false | true | true | false | false | false | false | false | false | false | false | POINT (-73.9743165321099 40.7754674678574) | 19 | 4 | 19 | 13 | |||||||
2713 | 2713 | -73.9687214684206 | 40.7792841720164 | 17D-AM-1008-07 | 17D | AM | 10082018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9687214684206 40.7792841720164) | 19 | 4 | 19 | 13 | |||||
2788 | 2788 | -73.9647845655965 | 40.7816573808695 | 21F-AM-1018-07 | 21F | AM | 10182018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9647845655965 40.7816573808695) | 19 | 4 | 19 | 13 | |||||
31 | 31 | -73.9540054100539 | 40.7952445999836 | 39G-PM-1013-06 | 39G | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9540054100539 40.7952445999836) | 19 | 4 | 19 | 13 | |||||
41 | 41 | -73.9639159298446 | 40.7891774637988 | 29C-AM-1007-06 | 29C | AM | 10072018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9639159298446 40.7891774637988) | 19 | 4 | 19 | 13 | |||||
47 | 47 | -73.9640032826529 | 40.7820309825448 | 22F-PM-1014-06 | 22F | PM | 10142018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.9640032826529 40.7820309825448) | 19 | 4 | 19 | 13 | ||||||
63 | 63 | -73.9745630038492 | 40.7692602628745 | 5E-AM-1008-06 | 05E | AM | 10082018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | true | false | false | POINT (-73.9745630038492 40.7692602628745) | 19 | 4 | 19 | 13 | |||||
79 | 79 | -73.9610705592868 | 40.7914829661051 | 32D-AM-1013-06 | 32D | AM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | true | true | eating (a mushroom),circles around us,really fat,scratching himself,grooming activity | false | false | false | false | true | true | false | false | POINT (-73.9610705592868 40.7914829661051) | 19 | 4 | 19 | 13 | |||||
81 | 81 | -73.9578237168359 | 40.7980959471034 | 40B-PM-1014-06 | 40B | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9578237168359 40.7980959471034) | 19 | 4 | 19 | 13 | |||||
83 | 83 | -73.9617088749928 | 40.7944585082367 | 35A-PM-1013-06 | 35A | PM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9617088749928 40.7944585082367) | 19 | 4 | 19 | 13 | ||||||
87 | 87 | -73.9541453465817 | 40.7982162223764 | 42E-PM-1012-06 | 42E | PM | 10122018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9541453465817 40.79821622237641) | 19 | 4 | 19 | 13 | |||||
130 | 130 | -73.9581655949437 | 40.7997708190022 | 41A-PM-1007-06 | 41A | PM | 10072018 | 6 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9581655949437 40.7997708190022) | 19 | 4 | 19 | 13 | ||||||
300 | 300 | -73.9528149779809 | 40.7924984810637 | 36I-AM-1017-06 | 36I | AM | 10172018 | 6 | Adult | Gray | Black | Gray+Black | Darker than others | Above Ground | 10 | Running down tree | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9528149779809 40.7924984810637) | 19 | 4 | 19 | 13 | |||
400 | 400 | -73.9590502257662 | 40.794290363687 | 36C-PM-1013-06 | 36C | PM | 10132018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | Running across wide street | true | false | false | false | true | carrying food in mouth | false | false | false | false | false | false | false | false | POINT (-73.9590502257662 40.794290363687) | 19 | 4 | 19 | 13 | ||||
477 | 477 | -73.9701481200298 | 40.7751110354034 | 12F-AM-1020-06 | 12F | AM | 10202018 | 6 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9701481200298 40.7751110354034) | 19 | 4 | 19 | 13 | |||||
494 | 494 | -73.958837574505 | 40.7985003987784 | 40A-PM-1014-06 | 40A | PM | 10142018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.958837574505 40.7985003987784) | 19 | 4 | 19 | 13 | |||||
501 | 501 | -73.9708798496132 | 40.7761532088521 | 13D-AM-1014-06 | 13D | AM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9708798496132 40.7761532088521) | 19 | 4 | 19 | 13 | |||||
563 | 563 | -73.9700330712119 | 40.7782913925727 | 16D-PM-1010-06 | 16D | PM | 10102018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | walking | false | false | false | false | false | false | false | false | checking me out | POINT (-73.9700330712119 40.7782913925727) | 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 );