From a 500-row sample across 35 columns.
hectareshiftdatehectareshiftdatelocation:@computed_region_sbqj_enih:@computed_region_f5dn_yrer+5Mappable — Socrata point column `geocoded_column`.
Open on the map →| x | y | unique_squirrel_id | hectare | shift | date | hectare_squirrel_number | combination_of_primary_and | running | chasing | climbing | eating |
|---|---|---|---|---|---|---|---|---|---|---|---|
| -73.9561344937861 | 40.7940823884086 | 37F-PM-1014-03 | 37F | PM | 10142018 | 3 | + | false | false | false | false |
| -73.9688574691102 | 40.7837825208444 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
x | float | Longitude coordinate for squirrel sighting point | 0% | -73.9573119777312-73.9742010726136-73.9765867029226 |
y | float | Latitude coordinate for squirrel sighting point | 0% | 40.789959935014540.794388908712340.7686351097159 |
unique_squirrel_id | text | Identification tag for each squirrel sightings. The tag is comprised of "Hectare ID" + "Shift" + "Date" + "Hectare Squirrel Number." | 0% | 37E-PM-1006-034C-PM-1010-051F-AM-1010-04 |
hectare | text | ID tag, which is derived from the hectare grid used to divide and count the park area. One axis that runs predominantly north-to-south is numerical (1-42), and the axis that runs predominantly east-to-west is roman characters (A-I). |
GET /api/datasets/vfnx-vebw GET /api/datasets/vfnx-vebw/quality GET /api/datasets/vfnx-vebw/related GET /api/columns?dataset=vfnx-vebw
location:@computed_region_sbqj_enih:@computed_region_f5dn_yrer:@computed_region_sbqj_enih:@computed_region_f5dn_yrer:@computed_region_efsh_h5xi+2location:@computed_region_sbqj_enih:@computed_region_f5dn_yrer+3| 21B-AM-1019-04 |
| 21B |
| AM |
| 10192018 |
| 4 |
| + |
| false |
| false |
| false |
| false |
| -73.9742811484852 | 40.775533619083 | 11B-PM-1014-08 | 11B | PM | 10142018 | 8 | Gray+ | false | true | false | false |
| -73.9596413903948 | 40.7903128889029 | 32E-PM-1017-14 | 32E | PM | 10172018 | 14 | Gray+ | false | false | false | true |
| -73.9702676472613 | 40.7762126854894 | 13E-AM-1017-05 | 13E | AM | 10172018 | 5 | Gray+Cinnamon | false | false | false | false |
| -73.9683613516225 | 40.7725908847499 | 11H-AM-1010-03 | 11H | AM | 10102018 | 3 | Cinnamon+White | false | false | false | false |
| -73.9541201789795 | 40.7931811701082 | 36H-AM-1010-02 | 36H | AM | 10102018 | 2 | Gray+ | false | false | false | false |
| -73.9582694312289 | 40.7917367820255 | 33F-AM-1008-02 | 33F | AM | 10082018 | 2 | Gray+ | false | false | false | false |
| -73.9674285955293 | 40.7829723919744 | 21C-PM-1006-01 | 21C | PM | 10062018 | 1 | Gray+ | false | false | false | false |
| -73.9722500196844 | 40.7742879599026 | 11D-AM-1010-03 | 11D | AM | 10102018 | 3 | Gray+Cinnamon | false | false | true | false |
Showing 12 of 34 columns. All of them are listed below.
| 0% |
14D32E14E |
shift | categorical | Value is either "AM" or "PM," to communicate whether or not the sighting session occurred in the morning or late afternoon. | 0% | PMAMof 2 |
date | categorical | Concatenation of the sighting session day and month. | 0% | 101320181007201810142018of 11 |
hectare_squirrel_number | integer | Number within the chronological sequence of squirrel sightings for a discrete sighting session. | 0% | 123 |
age | categorical | Value is either "Adult" or "Juvenile." | 4% | AdultJuvenile?of 3 |
primary_fur_color | categorical | Value is either "Gray," "Cinnamon" or "Black." | 2% | GrayCinnamonBlackof 3 |
highlight_fur_color | categorical | Discrete value or string values comprised of "Gray," "Cinnamon" or "Black." | 36% | CinnamonWhiteCinnamon, Whiteof 10 |
combination_of_primary_and | text | A combination of the previous two columns; this column gives the total permutations of primary and highlight colors observed. | 0% | Gray+Gray+CinnamonGray+White |
color_notes | text | Sighters occasionally added commentary on the squirrel fur conditions. These notes are provided here. | 94% | Gray & Cinnamon selected…white bellywhite back legs |
location | categorical | Value is either "Ground Plane" or "Above Ground." Sighters were instructed to indicate the location of where the squirrel was when first sighted. | 2% | Ground PlaneAbove Groundof 2 |
above_ground_sighter | text | For squirrel sightings on the ground plane, fields were populated with a value of “FALSE.” | 4% | FALSE1020 |
specific_location | text | Sighters occasionally added commentary on the squirrel location. These notes are provided here. | 84% | treein treeon fence |
running | boolean | Squirrel was seen running. | 0% | FalseTrueof 2 |
chasing | boolean | Squirrel was seen chasing another squirrel. | 0% | FalseTrueof 2 |
climbing | boolean | Squirrel was seen climbing a tree or other environmental landmark. | 0% | FalseTrueof 2 |
eating | boolean | Squirrel was seen eating. | 0% | FalseTrueof 2 |
foraging | boolean | Squirrel was seen foraging for food. | 0% | FalseTrueof 2 |
other_activities | text | — | 86% | diggingsittingwalking |
kuks | boolean | Squirrel was heard kukking, a chirpy vocal communication used for a variety of reasons. | 0% | FalseTrueof 2 |
quaas | boolean | Squirrel was heard quaaing, an elongated vocal communication which can indicate the presence of a ground predator such as a dog. | 0% | FalseTrueof 2 |
moans | boolean | Squirrel was heard moaning, a high-pitched vocal communication which can indicate the presence of an air predator such as a hawk. | 0% | FalseTrueof 2 |
tail_flags | boolean | Squirrel was seen flagging its tail. Flagging is a whipping motion used to exaggerate squirrel's size and confuse rivals or predators. Looks as if the squirrel is scribbling with tail into the air. | 0% | FalseTrueof 2 |
tail_twitches | boolean | Squirrel was seen twitching its tail. Looks like a wave running through the tail, like a breakdancer doing the arm wave. Often used to communicate interest, curiosity. | 0% | FalseTrueof 2 |
approaches | boolean | Squirrel was seen approaching human, seeking food. | 0% | FalseTrueof 2 |
indifferent | boolean | Squirrel was indifferent to human presence. | 0% | FalseTrueof 2 |
runs_from | boolean | Squirrel was seen running from humans, seeing them as a threat. | 0% | FalseTrueof 2 |
other_interactions | text | Sighter notes on other types of interactions between squirrels and humans. | 92% | runs from (dog)curiousruns from (me) |
geocoded_column | coordinate | Latitude and longitude | 0% | {'coordinates': [-73.968…{'coordinates': [-73.961…{'coordinates': [-73.976… |