squirrels

81 rows where Date = 10182018, Foraging = "true" and Police Precincts = 13 sorted by Approaches

View and edit SQL

Police Precincts

Foraging

  • true · 38

Date

  • 10182018 · 38
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
1541 -73.9711617997772 40.7761212878075 13D-PM-1018-04 13D PM 10182018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true digging false false false false false false true false   POINT (-73.9711617997772 40.7761212878075)   19 4 19 13
1655 -73.969570012716 40.7816501516863 19B-PM-1018-04 19B PM 10182018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.969570012716 40.7816501516863)   19 4 19 13
1828 -73.9682965197661 40.7805378963883 18D-AM-1018-04 18D AM 10182018 4 Adult Gray   Gray+   Above Ground 2   false false true false true   false false false false false false false false   POINT (-73.9682965197661 40.7805378963883)   19 4 19 13
1942 -73.96249054313 40.7935389038787 33A-PM-1018-01 33A PM 10182018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false stopped to see what i would do 1st POINT (-73.96249054313 40.7935389038787)   19 4 19 13
1957 -73.9684187207423 40.780592789876 18D-AM-1018-01 18D AM 10182018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true cleaning false false false false false false false false   POINT (-73.9684187207423 40.780592789876)   19 4 19 13
1958 -73.9693120090055 40.771096102012 9H-PM-1018-07 09H PM 10182018 7 Adult Gray   Gray+         false false false false true   false false false false false false false false   POINT (-73.9693120090055 40.771096102012)   19 4 19 13
1978 -73.9579689996645 40.7949338489917 37D-AM-1018-02 37D AM 10182018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9579689996645 40.7949338489917)   19 4 19 13
2048 -73.9627661465376 40.7819356810575 22G-PM-1018-02 22G PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9627661465376 40.7819356810575)   19 4 19 13
2049 -73.9692650850957 40.7713793846002 9H-PM-1018-03 09H PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9692650850957 40.7713793846002)   19 4 19 13
2082 -73.9696802053043 40.7816057406125 19B-PM-1018-03 19B PM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9696802053043 40.7816057406125)   19 4 19 13
2099 -73.9685612289881 40.7778488829217 16E-PM-1018-08 16E PM 10182018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9685612289881 40.7778488829217)   19 4 19 13
2125 -73.9687933229572 40.7788600242549 17E-PM-1018-01 17E PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9687933229572 40.7788600242549)   19 4 19 13
2156 -73.9650387848001 40.7814134438394 21F-AM-1018-04 21F AM 10182018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9650387848001 40.7814134438394)   19 4 19 13
2201 -73.9717135461165 40.7761780680083 13D-PM-1018-01 13D PM 10182018 1 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.9717135461165 40.776178068008306)   19 4 19 13
2255 -73.9642967875857 40.7815652353937 21F-AM-1018-08 21F AM 10182018 8 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9642967875857 40.7815652353937)   19 4 19 13
2339 -73.9695117797648 40.7802675743233 18C-PM-1018-07 18C PM 10182018 7   Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9695117797648 40.780267574323304)   19 4 19 13
2432 -73.9657203199746 40.775173008911 14I-PM-1018-02 14I PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9657203199746 40.775173008911)   19 4 19 13
2522 -73.9658747245917 40.7754033737532 14I-PM-1018-01 14I PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   Fallen branch true false false false true   false false false false true false false true   POINT (-73.9658747245917 40.7754033737532)   19 4 19 13
2531 -73.9599424115626 40.7957472585327 37B-AM-1018-05 37B AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9599424115626 40.7957472585327)   19 4 19 13
2582 -73.9665004148497 40.7805656411756 19E-PM-1018-05 19E PM 10182018 5   Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9665004148497 40.7805656411756)   19 4 19 13
2612 -73.9711673006524 40.7747979614577 12E-PM-1018-05 12E PM 10182018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9711673006524 40.7747979614577)   19 4 19 13
2681 -73.968807163616 40.7812018159499 19C-PM-1018-02 19C PM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.968807163616 40.7812018159499)   19 4 19 13
2712 -73.9682760864462 40.7780727569417 16E-PM-1018-04 16E PM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   true false false false false false true false   POINT (-73.9682760864462 40.7780727569417)   19 4 19 13
2765 -73.971525123573 40.7703685359842 7G-PM-1018-06 07G PM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true grooming false false false false false false false false   POINT (-73.971525123573 40.7703685359842)   19 4 19 13
2830 -73.9556083695689 40.7965223709493 39E-AM-1018-02 39E AM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9556083695689 40.7965223709493)   19 4 19 13
2838 -73.9507699667119 40.7955166039555 40I-AM-1018-02 40I AM 10182018 2 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9507699667119 40.795516603955505)   19 4 19 13
2853 -73.9678613185071 40.7822170887526 20C-PM-1018-03 20C PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9678613185071 40.7822170887526)   19 4 19 13
2876 -73.9558995737654 40.7960097734603 39E-AM-1018-05 39E AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false true false false true false   POINT (-73.9558995737654 40.7960097734603)   19 4 19 13
2884 -73.9598378495787 40.7956843021662 37B-AM-1018-04 37B AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false false false   POINT (-73.9598378495787 40.7956843021662)   19 4 19 13
2937 -73.9683460607021 40.7805408447877 18D-AM-1018-03 18D AM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9683460607021 40.7805408447877)   19 4 19 13
2966 -73.9630596103391 40.7925720620556 32A-AM-1018-04 32A AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE Base of tree false false false false true   false false false true false false true false   POINT (-73.9630596103391 40.7925720620556)   19 4 19 13
2972 -73.9631468456897 40.7926110399714 32A-AM-1018-03 32A AM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9631468456897 40.7926110399714)   19 4 19 13
3018 -73.9645437409662 40.7811599933331 21F-PM-1018-02 21F PM 10182018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9645437409662 40.7811599933331)   19 4 19 13
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
913 -73.9514111329059 40.7975085872897 42G-AM-1018-01 42G AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false true false true   POINT (-73.9514111329059 40.797508587289705)   19 4 19 13
1312 -73.9712034320741 40.7764415506669 13D-PM-1018-05 13D PM 10182018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false false true   false false false false true true true false   POINT (-73.9712034320741 40.7764415506669)   19 4 19 13
1704 -73.9624052832372 40.7809656348254 21H-PM-1018-04 21H PM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false true true false false   POINT (-73.9624052832372 40.7809656348254)   19 4 19 13
1725 -73.9657480066074 40.7753465489231 14I-PM-1018-04 14I PM 10182018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false true true false false   POINT (-73.9657480066074 40.7753465489231)   19 4 19 13

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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
);
Powered by Datasette · Query took 13.41ms