COLOBUS (COLOBUS hunts)

Each row, taken together with the related EVENTS row, represents a record of colobus monkey hunting recorded during a follow.

The related EVENTS row must be a colobus monkey hunting event; it must have an EVENTS.Behavior value of COL. This related EVENTS row supplies the start and stop times for the hunt, as well as comments and/or a description of the hunt.

There should be only one colobus monkey hunting event occurring at any given time, in any given follow. This means that the system will generate a warning when there are two EVENTS rows with the same WID value and the Start of the first is equal to or before the Start of the second, and the Stop of the first is equal to or after the Start of the second.

If the FocalMaleNumKills column is not NULL, and not 0, the focal of the follow should be male. The system will generate a warning when there are kills recorded for the focal male and the focal is not male – when the BIOGRAPHY_DATA.Sex column has a value other than M.

If the FocalFemaleNumKills column is not NULL, and not 0, the focal of the follow should be female. The system will generate a warning when there are kills recorded for the focal female and the focal is not female – when the BIOGRAPHY_DATA.Sex column has a value other than F.

The BIOGRAPHY_DATA.AnimIDs in the Hunters column’s text should be separated by commas. The system will generate a warning if the comma-separated components of this column are not BIOGRAPHY_DATA.AnimID values.

The BIOGRAPHY_DATA.AnimIDs in the Killers column’s text should be separated by commas. The system will generate a warning if the comma-separated components of this column are not BIOGRAPHY_DATA.AnimID values.

For further information, including additional data integrity rules, see the documentation of the EVENTS table.

EID (Event ID)

A unique, automatically generated, positive integer which serves to identify the row. The value of this column cannot be changed. The EVENTS.EID identifying the colobus monkey hunting event. The related event contains information on hunt start and stop times, and notes.

This column may not be NULL.

StartMap (START time rounded to MAPping interval)

The start time of the encounter rounded to the nearest 15 minute interval. Rounding is down, when the start time is after the 15 minute interval by 7 minutes or less. Otherwise rounding is up.

The gloal is to have a time which corresponds to the location times of the LOCATIONS_MAP rows. [1] In some cases, changes were made based on notes.

This column may not be NULL.

Hunt (was there a HUNT?)

A boolean, TRUE when at least one chimpanzee hunted. This column may not be NULL.

Hunters

Text listing the BIOGRAPHY_DATA.AnimIDs of the individuals that were seen to climb in pursuit of monkeys.

This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

HuntCert (HUNT CERTantity)

A boolean, TRUE when the notes were of sufficient detail to determine if at least one chimp climbed in pursuit. This column may not be NULL.

MaleHunt (did a MALE HUNT?)

A boolean, TRUE when a male (of any age) climbed in pursuit. This column may not be NULL.

FemaleHunt (did a FEMALE HUNT?)

A boolean, TRUE when a female (of any age) climbed in pursuit. This column may not be NULL.

FocalHunt (did the FOCAL HUNT?)

A boolean, TRUE when the focal chimpanzee climbed in pursuit. This column may not be NULL.

FocalHuntCert (is it CERTain the FOCAL HUNTed?)

A boolean, TRUE when the notes were of sufficient detail to determine that the focal chimp climbed in pursuit.

This column may be NULL when there is no information.

Kill

A boolean, TRUE when a monkey was killed by any chimpanzee. This column may not be NULL.

Killers

Text listing the BIOGRAPHY_DATA.AnimIDs of the individuals that were seen to kill a monkey.

This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

NumKills

The total number of colobus killed. This column may not be NULL.

MaleNumKills

The total number of colobus killed by males. This column may not be NULL.

FocalMaleNumKills

The total number of colobus killed by the focal male.

This column may be NULL when there is no information.

FocalFemaleNumKills

The total number of colobus killed by the focal female.

This column may be NULL when there is no information.

VictimsAges

Text recording the age of each colobus killed, if known. This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

InfantsKilled (by males)

The number of colobus infants killed by males. This column may not be NULL.

JuvenilesKilled (by males)

The number of colobus juveniles killed by males. This column may not be NULL.

AdultsKilled (by males)

The number of colobus adults killed by males. This column may not be NULL.

NoAgeKilled (by males)

The number of colobus for which there was no age data killed by males. This column may not be NULL.

GroupSize

A code indicating the size of the colobus group. A COLOBUS_GROUP_SIZES.Size value. This column may not be NULL.

Details (colobus troop DETAILS)

Specific information regarding the colobus troop. This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

Vegetation (details of the area’s VEGETATION)

Text consisting of specific information regarding the vegetation type in which the encounter occurred. This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

FailureDetails (hunt FAILURE DETAILS)

Text consisting of specific information regarding why the hunt failed. This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

Description

Description of hunt, if it occurred, usually copied directly from the translation. This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

Footnotes

[1]

A way to round, to the nearest 15 minute interval, is to use an expression like:

``DATE_BIN('15 minutes'
         , '1960-07-04'::DATE + events.start + '8 minutes'::INTERVAL
         , '1960-07-04 00:00')::TIME WITHOUT TIME ZONE``

This expression rounds down when the start time is after the 15 minute interval by 7 minutes or less, and otherwise rounds up. (The date 1960-07-04 is an arbitrary choice. It does not affect the result.)

Should this be useful it can be made into a function.

Page last generated: 2026-07-01 00:11:55 UTC