SPECIES_PRESENT

Each row records a kind of, non-chimpanzee, species which were present.

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 SPECIES_PRESENT row’s EID value must have an EVENTS.Behavior value of OS.

The OBS view is useful when querying SPECIES_PRESENT.

Using OBS to provide a more complete picture of other species present

SELECT obs.wid, obs.type
     , obs.eid
     , obs.date
     , obs.animid AS focal
     , obs.commid
     , obs.start
     , obs.stop
     , species_present.species
     , obs.notes
     , obs.event_notes
  FROM obs
    JOIN species_present
         ON (species_present.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.

Species

A species present during the event; a SPECIES.Species value. This column may not be NULL.

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