HUMANS

Each row records the number of, various kinds of, humans which were present. These are in addition to the observers that normally make the observations.

The related EVENTS row must must be one that records the presence of other species; the EVENTS row with an EID value that matches the HUMANS row’s EID value must have an EVENTS.Behavior value of OS.

The OBS view is useful when querying HUMANS.

Using OBS to provide a more complete picture of human encounters

SELECT obs.wid, obs.type
     , obs.eid
     , obs.date
     , obs.animid AS focal
     , obs.commid
     , obs.start
     , obs.stop
     , humans.researchers
     , humans.nonresearchers
     , obs.notes
     , obs.event_notes
  FROM obs
    JOIN humans
         ON (humans.eid = obs.eid)
  WHERE obs.behavior = 'OS'
  ORDER BY obs.animid, obs.date, obs.start, obs.stop
         , obs.eid;

EID (Event IDentifier)

The EVENTS.EID that identifies the event which records the presence of non-chimpanzee species. A unique, automatically generated, positive integer which serves to identify the row. The value of this column cannot be changed. This column may not be NULL.

Researchers

The number of additional researchers present during the event. This column may not contain a negative value. This column may not be NULL.

NonResearchers

The number of additional non-researchers present during the event. This column may not contain a negative value. This column may not be NULL.

Page last generated: 2026-08-13 23:02:22 UTC