2018_Central_Park_Squirrel_Census_-_Squirrel_Data

16 rows where Climbing = 0 and Hectare = "07G" sorted by Lat/Long

View and edit SQL

Suggested facets: Shift, Date, Hectare Squirrel Number, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Eating, Foraging, Indifferent, Runs from

Highlight Fur Color

Tail twitches

  • 0 14
  • 1 2

Kuks

  • 0 16

Hectare

  • 07G · 16

Climbing

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 ▼
110 -73.97113187902791 40.7701941550273 7G-AM-1010-02 07G AM 10102018 2 Adult Gray   Gray+   Above Ground 3   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9711318790279 40.7701941550273)
2765 -73.971525123573 40.770368535984204 7G-PM-1018-06 07G PM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 grooming 0 0 0 0 0 0 0 0   POINT (-73.971525123573 40.7703685359842)
1438 -73.97168547522399 40.7706668465923 7G-PM-1018-07 07G PM 10182018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.971685475224 40.7706668465923)
870 -73.97187204036571 40.770233505633705 7G-PM-1018-04 07G PM 10182018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9718720403657 40.7702335056337)
202 -73.97187291016759 40.7703692621371 7G-PM-1018-05 07G PM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9718729101676 40.7703692621371)
2506 -73.9719038949487 40.770353349248204 7G-AM-1010-05 07G AM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9719038949487 40.7703533492482)
903 -73.9719941577406 40.77037129313 7G-AM-1010-04 07G AM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9719941577406 40.77037129313)
2256 -73.9720050204318 40.769941909416794 7G-AM-1010-03 07G AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9720050204318 40.7699419094168)
2401 -73.972010921173 40.7701626919216 7G-AM-1010-09 07G AM 10102018 9 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.972010921173 40.7701626919216)
1363 -73.972112497276 40.77027590374279 7G-AM-1010-08 07G AM 10102018 8 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.972112497276 40.7702759037428)
1898 -73.9721263050502 40.7698763846186 7G-PM-1018-01 07G PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9721263050502 40.7698763846186)
138 -73.9721442939797 40.770075080231706 7G-PM-1018-03 07G PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9721442939797 40.7700750802317)
1511 -73.9721642509914 40.7701179390078 7G-AM-1010-01 07G AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9721642509914 40.7701179390078)
1085 -73.9722265046794 40.7700916895929 7G-PM-1018-02 07G PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9722265046794 40.7700916895929)
1233 -73.9722281263634 40.770408328801295 7G-AM-1010-06 07G AM 10102018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9722281263634 40.7704083288013)
1814 -73.97223594012421 40.7702891474555 7G-AM-1010-07 07G AM 10102018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9722359401242 40.7702891474555)

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" (
"longitude" REAL,
  "latitude" REAL,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" INTEGER,
  "Hectare Squirrel Number" INTEGER,
  "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" INTEGER,
  "Chasing" INTEGER,
  "Climbing" INTEGER,
  "Eating" INTEGER,
  "Foraging" INTEGER,
  "Other Activities" TEXT,
  "Kuks" INTEGER,
  "Quaas" INTEGER,
  "Moans" INTEGER,
  "Tail flags" INTEGER,
  "Tail twitches" INTEGER,
  "Approaches" INTEGER,
  "Indifferent" INTEGER,
  "Runs from" INTEGER,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT
);
Powered by Datasette · Query took 190.392ms