squirrels

Custom SQL query returning 19 rows (hide)

Query parameters

rowidlongitudelatitudeUnique Squirrel IDHectareShiftDateHectare Squirrel NumberAgePrimary Fur ColorHighlight Fur ColorCombination of Primary and Highlight ColorColor notesLocationAbove Ground Sighter MeasurementSpecific LocationRunningChasingClimbingEatingForagingOther ActivitiesKuksQuaasMoansTail flagsTail twitchesApproachesIndifferentRuns fromOther InteractionsLat/Long
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)
326 -73.9699843570636 40.7729480440312 10G-AM-1006-01 10G AM 10062018 1 Adult Gray   Gray+   Above Ground 80   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.96998435706361 40.7729480440312)
1867 -73.9745204169071 40.7736282868469 9C-AM-1006-01 09C AM 10062018 1 Adult Gray   Gray+   Above Ground 40 Tree 1 0 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9745204169071 40.7736282868469)
2559 -73.95723834787741 40.787685738072206 30H-PM-1006-01 30H PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9572383478774 40.7876857380722)
508 -73.97469187620759 40.765523188367794 1G-AM-1006-02 01G AM 10062018 2 Juvenile Gray White Gray+White   Above Ground 30   0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9746918762076 40.7655231883678)
2803 -73.9576652087316 40.787545797780105 29H-PM-1006-02 29H PM 10062018 2 Adult Gray   Gray+   Above Ground 2   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9576652087316 40.7875457977801)
335 -73.97823514358521 40.7715896672335 6A-AM-1006-03 06A AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree 0 1 0 1 0   0 0 0 1 1 0 0 0   POINT (-73.9782351435852 40.7715896672335)
381 -73.959709414696 40.7919745085986 33D-PM-1006-03 33D PM 10062018 3   Black   Black+   Above Ground 15   1 0 0 1 0   0 0 0 0 1 0 0 1 ran up tree POINT (-73.959709414696 40.7919745085986)
728 -73.96029131055779 40.7910635810038 32D-PM-1006-03 32D PM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 40   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9602913105578 40.7910635810038)
2396 -73.9704339422613 40.77401495296439 11F-PM-1006-03 11F PM 10062018 3 Adult Gray   Gray+   Above Ground 4   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9704339422613 40.7740149529644)
2586 -73.9752965316933 40.775253857578896 10B-AM-1006-03 10B AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   In tree 0 0 1 0 0   0 0 0 0 1 1 0 0   POINT (-73.9752965316933 40.7752538575789)
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)
670 -73.9602398690946 40.7910157676119 32D-PM-1006-04 32D PM 10062018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 40   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9602398690946 40.7910157676119)
2839 -73.9672252136807 40.787650474321204 26A-PM-1006-04 26A PM 10062018 4 Adult Gray   Gray+   Above Ground 40   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9672252136807 40.7876504743212)
360 -73.9672054610151 40.7876519923501 26A-PM-1006-05 26A PM 10062018 5 Adult Gray   Gray+   Above Ground 40   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9672054610151 40.7876519923501)
1048 -73.9782120139407 40.7717154468791 6A-AM-1006-05 06A AM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 tree 0 0 1 0 0   0 0 0 1 1 0 0 0 curious POINT (-73.9782120139407 40.7717154468791)
1820 -73.9546337446865 40.7898772579576 33I-PM-1006-08 33I PM 10062018 8 Adult Gray   Gray+   Above Ground 6   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9546337446865 40.7898772579576)
2433 -73.9706949930717 40.772362045852 10G-AM-1006-08 10G AM 10062018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 3   0 0 0 1 0   0 0 0 1 1 0 1 0   POINT (-73.9706949930717 40.772362045852)
2098 -73.9700779726297 40.7722086251085 10G-AM-1006-11 10G AM 10062018 11 Juvenile Gray   Gray+   Above Ground 2   0 0 1 0 0   0 0 0 0 1 0 0 0   POINT (-73.9700779726297 40.7722086251085)
Powered by Datasette · Query took 1.454ms