An Overview Of The Views
Prev  Chapter 2. An Overview Of The Gombe-MI Data  Next

An Overview Of The Views

Demography Related
View One row for each Purpose Tables/Views used
BIOGRAPHY BIOGRAPHY_DATA row Provides an interface into the master biography table imported from Access which is invariant, and slightly easier to use. BIOGRAPHY_DATA, TWINS
BIOGRAPHY_UPLOAD BIOGRAPHY_DATA row Provides an upload interface into the master biography table enabling easy import from Access. BIOGRAPHY_DATA
CHIMPS BIOGRAPHY_DATA row plus one row for each twin Provides an interface into the master biography table with one extra row for each twin, which is a duplicate of the twin's BIOGRAPHY_DATA row but used when the twins are not distinguishable. BIOGRAPHY_DATA, TWINS, CHIMPIDS
COMMUNITY_MEMBERSHIP_UPLOAD COMMUNITY_MEMBERSHIP row Provides an upload interface into the master community_membership table enabling easy import from Access. COMMUNITY_MEMBERSHIP
Follow Mechanics Related
View One row for each Purpose Tables/Views used
DATASHEET_EVENTS EVENTS row per any related EATS, FISHED, PLAYS, RESTS, RIDES, or VOCS rows. To resemble the event portion of the data entry sheets and provide a mechanism for updating event related data in the database. FOLLOWS, INTERVALS, EVENTS, PARTS, EATS, FISHED, PLAYS, RESTS, RIDES, VOCS
DATASHEETS EVENTS row per any related EATS, FISHED, PLAYS, RESTS, RIDES, or VOCS rows plus one row per DISTANCES row To produce a report resembling the data entry sheets. FOLLOWS, INTERVALS, EVENTS, PARTS, DISTANCES, DISTANCEPARTS, EATS, FISHED, PLAYS, RESTS, RIDES, VOCS
FOCAL_FOLLOWS FOLLOWS row, per each possible paring of infant and sibling (i.e. one row per follow when there are no twins, two rows per follow when either the infants or siblings are twins, and 4 rows per follow when both the infants and siblings are twins) To provide a simple mechanism for deleting and creating follows. FOLLOWS, FOLLOWPARTS (3 times)
FOLLOW_DURATIONS FOLLOWS row Computes various totals of time spent observing during the follow. FOLLOWS
FOLLOW_INTERVALS INTERVALS row per INTERVALS row FOLLOWS, FOLLOWPARTS (3 times), INTERVALS  
UPLOAD_BEHAVIORS FOLLOWS row This view returns no rows. It is used only to upload follow data into Gombe-MI. FOLLOWS, FOLLOWPARTS, INTERVALS, EVENTS, PARTS, DISTANCES, DISTANCEPARTS
Follow Event Related
View One row for each Purpose Tables/Views used
ACTOR_ACTEES EVENTS row where there are 2 chimpanzees involved in an actor/actee behavioral event, events involving baboons are not included. Provides a straightforward way to analyze directed social behaviors from the perspective of who is initiating and who receiving the behavior. EVENTS, PARTS (twice, once for each chimpanzee involved in the behavior), FOLLOWROLES (twice, once for each chimpanzee involved in the behavior)
ACTOR_ACTEES_W_BABOONS EVENTS row where there are 2 animals involved in an actor/actee behavioral event, including events involving baboons. Provides a straightforward way to analyze directed social behaviors from the perspective of who is initiating and who receiving the behavior. EVENTS, PARTS (twice, once for each animal involved in the behavior), FOLLOWROLES (up to twice, once for each chimpanzee involved in the behavior)
ASOCIAL_EVENTS EVENTS row having a related PARTS row with a Part value of S Provides a direct way to analyze asocial behavioral events. EVENTS, PARTS, FOLLOWROLES
EVENT_BOUTS FOLLOWPARTS row per INTERVALS row, per EVENTS.Behavior value having a related PARTS row that shows the given focal involved in the given behavior -- one row per follow, per focal, per interval in which the focal is involved in a behavior (excluding behavioral events which involve a baboon), per code for the behavior involved in. Provides per-focal, per-minute analysis for contiguous minutes of per behavior-code activity. FOLLOWPARTS, FOLLOWROLES, INTERVALS, EVENTS, PARTS, CHIMPIDS
EVENT_BOUT_AGGS FOLLOWPARTS row, per EVENTS.Behavior value having a related PARTS row that shows the given focal involved in the given behavior -- one row per follow, per focal in which the focal is involved in a behavior (excluding behavioral events which involve a baboon), per code for the behavior involved in. Provides per-focal analysis for contiguous minutes of per behavior-code activity. FOLLOWPARTS, FOLLOWROLES, INTERVALS, EVENTS, PARTS, CHIMPIDS
FAMILY_EVENTS EVENTS row Provides a way to review recorded behaviors in a way similar to the way data is recorded in the field. EVENTS, PARTS (four times, once for each of the mother, infant, sibling, and other non-focal individual who may be involved in the behavior)
FOCAL_EVENTS EVENTS row per focal individual involved in the behavioral event Provides a direct way to analyze behaviors when interested in the function (mom, infant, sib, non-focal) of the chimpanzees involved in the behavior. EVENTS, PARTS (once or twice, once for the focal and again if there is another individual), FOLLOWROLES (once or twice, once for the focal and again if there is another individual)
FOCAL_SOCIAL_EVENTS EVENTS row per individual involved in the behavioral event when the individual is a focal in the follow where there are 2 chimpanzees involved in the exhibited behavior Provides a direct way to analyze social behaviors when interested in the function (mom, infant, sib, non-focal) of the chimpanzees involved in the behavior. EVENTS, PARTS (twice, once for the focal and once for the other individual), FOLLOWROLES (twice, once for the focal and once for the other individual)
NOOBS FOLLOWS row, per FOLLOWPARTS row, per minute from 06:00 through 20:00, inclusive, but only when there is no behavioral data on the focal. Computes minutes in each follow's day during which each focal has no data on behavior. FOLLOWPARTS, CHIMPIDS, INTERVALS, EVENTS, PARTS
SOCIAL_BOUTS FOLLOWPARTS row per INTERVALS row, per EVENTS.Behavior value having a related PARTS row that shows the given focal involved in the given behavior with a social partner, per AnimID of the social partner -- one row per follow, per focal, per social partner, per interval in which the focal is involved in a social behavior (excluding behavioral events which involve a baboon), per code for the behavior involved in. Provides per-focal, per-social-partner, per-minute analysis for contiguous minutes of per behavior-code activity. FOLLOWPARTS, FOLLOWROLES, INTERVALS, EVENTS, PARTS, CHIMPIDS
SOCIAL_BOUT_AGGS FOLLOWPARTS row per EVENTS.Behavior value having a related PARTS row that shows the given focal involved in the given behavior with a social partner, per AnimID of the social partner -- one row per follow, per focal, per social partner (excluding behavioral events which involve a baboon), per code for the behavior involved in. Provides per-focal, per social partner analysis for contiguous minutes of per behavior-code activity. FOLLOWPARTS, FOLLOWROLES, INTERVALS, EVENTS, PARTS, CHIMPIDS
SOCIAL_EVENTS EVENTS row, per chimpanzee, where there are 2 chimpanzees (no baboons) involved in the exhibited behavior. So, 2 rows per EVENTS row for those events, involving chimpanzees, that are social in nature. Provides a direct way to analyze chimp social behaviors regardless of whether a chimpanzee is a focal in the follow. EVENTS, PARTS (twice, once for each chimpanzee involved in the behavior), FOLLOWROLES (twice, once for each chimpanzee involved in the behavior)
SOCIAL_EVENTS_W_BABOONS EVENTS row, per chimpanzee, where there are 2 animals involved in the exhibited behavior, baboons included. So, 2 rows per EVENTS row for those events, involving animals, that are social in nature. Provides a direct way to analyze social behaviors regardless of whether a chimpanzee is a focal in the follow. EVENTS, PARTS (twice, once for each chimpanzee involved in the behavior), FOLLOWROLES (twice, once for each chimpanzee involved in the behavior)
Follow Distance Related
View One row for each Purpose Tables/Views used
DISTS DISTANCES row per related DISTANCEPARTS row. So, 2 rows per DISTANCES row. Provides a direct way to analyze chimp inter-familial distances using either ChimpID or role the chimp plays in the follow. DISTANCES, DISTANCEPARTS (twice, once for each chimpanzee involved).
FAMILY_DISTS DISTANCES row Provides a direct way to analyze chimp inter-familial distances based on the role (mom, infant, sibling) the chimp plays in the follow, and a way to maintain the underlying data. DISTANCES, DISTANCEPARTS (three times, once for each possible role played in the follow).
Prev  Up  Next
ER Diagrams  Home  Indexes

Page generated: 2018-08-25T22:19:24-04:00.