2018_Central_Park_Squirrel_Census_-_Squirrel_Data

116 rows where Above Ground Sighter Measurement = 10 sorted by Lat/Long

View and edit SQL

Highlight Fur Color

Eating

  • 0 15
  • 1 1

Above Ground Sighter Measurement

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 ▼
100 -73.9761592532482 40.774721358538706 10A-AM-1006-04 10A AM 10062018 4 Juvenile Gray   Gray+   Above Ground 10 tree near large rock on Bridle Path 0 0 0 0 0 walking on branch 0 0 0 0 1 0 0 0   POINT (-73.9761592532482 40.7747213585387)
733 -73.9764397550289 40.7737004557104 8B-AM-1007-01 08B AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9764397550289 40.7737004557104)
1263 -73.9770873939997 40.771037966210606 6C-PM-1020-02 06C PM 10202018 2 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9770873939997 40.7710379662106)
199 -73.97716146866159 40.770967798324705 5C-AM-1006-02 05C AM 10062018 2 Adult Cinnamon White Cinnamon+White   Above Ground 10   1 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9771614686616 40.7709677983247)
1329 -73.9772164524209 40.768839953875606 3D-AM-1006-06 03D AM 10062018 6   Gray   Gray+   Above Ground 10 tree 1 0 1 0 0   0 0 0 0 0 0 0 0 did not run from humans,but ran straight to tree & climbed up POINT (-73.9772164524209 40.7688399538756)
1768 -73.97736964550309 40.7687241866704 3D-PM-1010-14 03D PM 10102018 14 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 0 0 0 crying out 1 1 0 0 0 0 0 0   POINT (-73.9773696455031 40.7687241866704)
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 1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9775735077285 40.7692872082165)
2403 -73.97778796352159 40.769359455673 4C-AM-1006-03 04C AM 10062018 3 Juvenile Gray   Gray+   Above Ground 10   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9777879635216 40.769359455673)
1168 -73.9779874405715 40.7730765377366 7A-PM-1007-02 07A PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9779874405715 40.7730765377366)
137 -73.97824171151392 40.77246650364471 7A-AM-1006-01 07A AM 10062018 1 Adult Gray White Gray+White   Above Ground 10 in tree 0 0 0 0 1   0 1 0 0 1 0 0 0 looked at us POINT (-73.9782417115139 40.7724665036447)
191 -73.9787105069657 40.7693708133873 3B-AM-1010-08 03B AM 10102018 8 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0 together w/ #7 0 0 0 0 0 0 1 0   POINT (-73.9787105069657 40.7693708133873)
2297 -73.9787771053108 40.769356212275 3B-AM-1010-07 03B AM 10102018 7 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0 together w/ #8 0 0 0 1 0 0 1 0   POINT (-73.9787771053108 40.76935621227501)
1799 -73.978844141973 40.7696046074378 4B-AM-1010-05 04B AM 10102018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   0 1 0 0 0 chasing squirrel #6 1 1 0 0 1 0 0 0   POINT (-73.978844141973 40.7696046074378)
1365 -73.9791648157033 40.767625444347 2C-AM-1010-04 02C AM 10102018 4 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9791648157033 40.767625444347)
2893 -73.97931014826541 40.7692600238491 3B-PM-1007-02 03B PM 10072018 2 Adult Gray   Gray+   Above Ground 10 in tree 0 0 0 0 0 chased by dog 0 0 0 0 0 0 0 0   POINT (-73.9793101482654 40.7692600238491)
2911 -73.9793923984874 40.770847547458295 5A-AM-1006-01 05A AM 10062018 1 Adult Gray   Gray+   Above Ground 10 Oak tree near rock outcropping 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.97939239848742 40.7708475474583)

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 34.462ms