The Gombe-MI Pocket Reference Guide
The Gombe-MI Pocket Reference GuideThe Gombe-MI Pocket Reference GuideA Technical Specification Summaryi
The Gombe-MI Pocket Reference GuideiiCOLLABORATORSTITLE :The Gombe-MI Pocket Reference GuideACTIONNAMEDATEWRITTEN BYKarl O. Pinc,Elizabeth V. Lonsdorf,PHD., and Carson M.Murray, PhD.August 25, 2018SIGNATURE
The Gombe-MI Pocket Reference GuideiiiContents123Gombe-MI Summarized11.1Main Table Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .11.2The Warning Sub-System Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .21.3Support Table Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .21.4The Warning Sub-System Support Tables . . . . . . . . . . . . . . . . . . . . . . . . . . .51.5An Overview Of The Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5The Gombe-MI ER Diagrams142.1Gombe-MI Entity Relationship Diagrams . . . . . . . . . . . . . . . . . . . . . . . . . . .142.2Warning Sub-System ER Diagrams . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .24The Gombe-MI Views253.1Demography Related Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .253.2Follow Mechanics Related Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .333.3Follow Event Related Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .393.4Follow Distance Related Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .863.5Group Related Views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .91
The Gombe-MI Pocket Reference GuideivList of Figures1Key to the Gombe-MI Entity Relationship Diagrams . . . . . . . . . . . . . . . . . . . . .142Gombe-MI Demography Entity Relationship Diagram . . . . . . . . . . . . . . . . . . . .153Gombe-MI Essentials of a Follow Entity Relationship Diagram . . . . . . . . . . . . . . . .164Gombe-MI Follow Distance Entity Relationship Diagram . . . . . . . . . . . . . . . . . . .175Gombe-MI Follow Events Entity Relationship Diagram . . . . . . . . . . . . . . . . . . . .186Gombe-MI Behavior Event Detail Entity Relationship Diagram . . . . . . . . . . . . . . . .197Gombe-MI Group Membership Entity Relationship Diagram . . . . . . . . . . . . . . . . .208Gombe-MI Follow Detailed Entity Relationship Diagram . . . . . . . . . . . . . . . . . . .219Gombe-MI Data Collection Templates Entity Relationship Diagram . . . . . . . . . . . . .2210Warning Sub-System Entity Relationship Diagram . . . . . . . . . . . . . . . . . . . . . .2411Query Defining the BIOGRAPHY View . . . . . . . . . . . . . . . . . . . . . . . . . . . .2512Entity Relationship Diagram of the BIOGRAPHY View . . . . . . . . . . . . . . . . . . .2613Query Defining the BIOGRAPHY UPLOAD View . . . . . . . . . . . . . . . . . . . . . .2714Entity Relationship Diagram of the BIOGRAPHY UPLOAD View . . . . . . . . . . . . .2815Query Defining the CHIMPS View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2916Entity Relationship Diagram of the CHIMPS View . . . . . . . . . . . . . . . . . . . . . .3017Query Defining the COMMUNITY MEMBERSHIP UPLOAD View . . . . . . . . . . . .3118Entity Relationship Diagram of the COMMUNITY MEMBERSHIP UPLOAD View . . . .3119Query Defining the DATASHEETS View: Part I . . . . . . . . . . . . . . . . . . . . . . . .3320Query Defining the DATASHEETS View: Part II . . . . . . . . . . . . . . . . . . . . . . .3421Query Defining the DATASHEETS View: Part III . . . . . . . . . . . . . . . . . . . . . . .3522Query Defining the DATASHEETS View: Part IV . . . . . . . . . . . . . . . . . . . . . . .3623Entity Relationship Diagram of the DATASHEETS View . . . . . . . . . . . . . . . . . . .3624Query Defining the UPLOAD BEHAVIORS View: Part I . . . . . . . . . . . . . . . . . . .3725Query Defining the UPLOAD BEHAVIORS View: Part II . . . . . . . . . . . . . . . . . .3826Entity Relationship Diagram of the UPLOAD BEHAVIORS View . . . . . . . . . . . . . .39
The Gombe-MI Pocket Reference Guidev27Query Defining the ACTOR ACTEES View . . . . . . . . . . . . . . . . . . . . . . . . . .3928Entity Relationship Diagram of the ACTOR ACTEES View . . . . . . . . . . . . . . . . .4029Query Defining the ACTOR ACTEES W BABOONS View: Part I . . . . . . . . . . . . .4230Query Defining the ACTOR ACTEES W BABOONS View: Part II . . . . . . . . . . . . .4331Entity Relationship Diagram of the ACTOR ACTEES W BABOONS View . . . . . . . .4432Query Defining the ASOCIAL EVENTS View . . . . . . . . . . . . . . . . . . . . . . . .4533Entity Relationship Diagram of the ASOCIAL EVENTS View . . . . . . . . . . . . . . . .4634Query Defining the EVENT BOUTS View: Part I . . . . . . . . . . . . . . . . . . . . . . .4835Query Defining the EVENT BOUTS View: Part II . . . . . . . . . . . . . . . . . . . . . .4936Query Defining the EVENT BOUTS View: Part III . . . . . . . . . . . . . . . . . . . . . .5037Query Defining the EVENT BOUTS View: Part IV . . . . . . . . . . . . . . . . . . . . . .5138Query Defining the EVENT BOUTS View: Part V . . . . . . . . . . . . . . . . . . . . . .5239Query Defining the EVENT BOUTS View: Part VI . . . . . . . . . . . . . . . . . . . . . .5340Entity Relationship Diagram of the EVENT BOUTS View . . . . . . . . . . . . . . . . . .5441Query Defining the EVENT BOUT AGGS View . . . . . . . . . . . . . . . . . . . . . . .5542Entity Relationship Diagram of the EVENT BOUT AGGS View . . . . . . . . . . . . . .5643Query Defining the FAMILY EVENTS View: Part I . . . . . . . . . . . . . . . . . . . . .5844Query Defining the FAMILY EVENTS View: Part II . . . . . . . . . . . . . . . . . . . . .5945Entity Relationship Diagram of the FAMILY EVENTS View . . . . . . . . . . . . . . . . .6046Query Defining the FOCAL EVENTS View . . . . . . . . . . . . . . . . . . . . . . . . . .6247Entity Relationship Diagram of the FOCAL EVENTS View . . . . . . . . . . . . . . . . .6348Query Defining the FOCAL SOCIAL EVENTS View . . . . . . . . . . . . . . . . . . . .6449Entity Relationship Diagram of the FOCAL SOCIAL EVENTS View . . . . . . . . . . . .6550Query Defining the NOOBS View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .6651Entity Relationship Diagram of the NOOBS View . . . . . . . . . . . . . . . . . . . . . . .6752Query Defining the SOCIAL BOUTS View: Part I . . . . . . . . . . . . . . . . . . . . . .6953Query Defining the SOCIAL BOUTS View: Part II . . . . . . . . . . . . . . . . . . . . . .7054Query Defining the SOCIAL BOUTS View: Part III . . . . . . . . . . . . . . . . . . . . .71
The Gombe-MI Pocket Reference Guidevi55Query Defining the SOCIAL BOUTS View: Part IV . . . . . . . . . . . . . . . . . . . . .7256Query Defining the SOCIAL BOUTS View: Part V . . . . . . . . . . . . . . . . . . . . . .7357Query Defining the SOCIAL BOUTS View: Part VI . . . . . . . . . . . . . . . . . . . . .7458Query Defining the SOCIAL BOUTS View: Part VII . . . . . . . . . . . . . . . . . . . . .7559Query Defining the SOCIAL BOUTS View: Part VIII . . . . . . . . . . . . . . . . . . . .7660Entity Relationship Diagram of the SOCIAL BOUTS View . . . . . . . . . . . . . . . . .7761Query Defining the SOCIAL BOUT AGGS View . . . . . . . . . . . . . . . . . . . . . .7962Entity Relationship Diagram of the SOCIAL BOUT AGGS View . . . . . . . . . . . . . .8063Query Defining the SOCIAL EVENTS View . . . . . . . . . . . . . . . . . . . . . . . . .8064Entity Relationship Diagram of the SOCIAL EVENTS View . . . . . . . . . . . . . . . . .8165Query Defining the SOCIAL EVENTS W BABOONS View: Part I . . . . . . . . . . . .8266Query Defining the SOCIAL EVENTS W BABOONS View: Part II . . . . . . . . . . . .8367Query Defining the SOCIAL EVENTS W BABOONS View: Part III . . . . . . . . . . . .8468Entity Relationship Diagram of the SOCIAL EVENTS W BABOONS View . . . . . . . .8569Query Defining the DISTS View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8670Entity Relationship Diagram of the DISTS View . . . . . . . . . . . . . . . . . . . . . . . .8771Query Defining the FAMILY DISTS View: Part I . . . . . . . . . . . . . . . . . . . . . . .8872Query Defining the FAMILY DISTS View: Part II . . . . . . . . . . . . . . . . . . . . . .8973Entity Relationship Diagram of the FAMILY DISTS View . . . . . . . . . . . . . . . . . .90
The Gombe-MI Pocket Reference Guide1 / 911 Gombe-MI Summarized1.1 Main Table OverviewDemography RelatedTableOne row for eachADOPTIONStime a chimpanzee is adoptedBIOGRAPHY DATAchimpanzeeCHIMPIDSchimpanzee id; usually 1 row per chimpanzee but 2 rows pertwinCOMMUNITY MEMBERSHIPtenure of an individual in a communityTWINSindividual who is a twinFollow Mechanics RelatedTableOne row for eachFIELDFOLLOWSmother infant data packet collected by any one researcher in thefieldFOLLOWPARTSmother infant follow for every focal participantFOLLOWSmother infant followINTERVALSobservation time interval of every followSheetstemplate sheet used in the field or, when the details of what wason which sheet are not available, one row per followFollow Event RelatedTableOne row for eachEATSpart of every kind of food eaten during a eating behavioral eventEVENTSnon-social behavior and one row for each social behavior/socialpartner combination of each focal recorded for each intervalFISHEDevery kind of food fished for during a fishing behavioral eventPARTSindividual, focal or not, involved in every recorded behavior,excluding baboons but including unrecognized or otherwiseanonymous individuals
The Gombe-MI Pocket Reference Guide2 / 91Follow Event RelatedTableOne row for eachPLAYSplay activity occurring during a play eventRESTSresting posture assumed during a resting eventRIDESriding posture assumed during a riding eventVOCSkind of vocalization made during a vocalization behavioraleventFollow Distance RelatedTableOne row for eachDISTANCEPARTSindividual who’s distance to another individual was recordedDISTANCESindividual who’s distance to another individual was recordedGroup RelatedTableOne row for eachGROUPMEMBERSgroup member identified per automated group survey analysisGROUPSautomated group survey analysisRAW GROUPMEMBERSgroup member identified per group surveyRAW GROUPSgroup survey1.2 The Warning Sub-System TablesTableOne row for eachINTEGRITY QUERIESquery used to discover data integrity problemsINTEGRITY WARNINGSdata integrity problem discovered by the warning sub-system1.3 Support Table Overview
The Gombe-MI Pocket Reference Guide3 / 91Demography RelatedTableId ColumnRelated Column(s)One entry for every possible choice of.BDDISTSBDDistBIOGRAPHY DATA.BDDistbirth date probability distributionDEPARTTYPESDeparttypeBIOGRAPHY DATA.Departtypemeans by which individual’s depart fromthe study populationENTRYTYPESEntrytypeBIOGRAPHY DATA.Entrytypemeans by which individual’s enter into thestudy populationRelated Column(s)One entry for every possible choice of.Nonebehavior code written in the field plus onerow for every column on the field dataentry sheet which represents specificbehaviorsFollow Mechanics RelatedTableId ColumnBEHAVIOR TRANS Old BehaviorDISTANCE TRANSOld DistanceNonedistance code written in the field plus onerow for every column on the field dataentry sheet which represents a specificinter-focal RTS.Rolerole among follow focals (mother, infant,sibling, twin1, etc.)FOLLOWTYPESTypeSheets.Followtypetype of data entry sheetNonefood part code written in the fieldFOODPART TRANS Old FoodpartGC TRANSMarkNonemark written in the field onto the groupcomposition portion of the data collectionsheets, in the cells of the columns whichrecord chimpanzee or baboon LLOWS.Entererperson who collects data in the field orwho enters data in the labsPLAY TRANSOld PlayNoneplay code written in the fieldVOC TRANSOld VocNonevocalization code written in the field
The Gombe-MI Pocket Reference Guide4 / 91Follow Event RelatedTableId ColumnRelated Column(s)BEHAVIORSBehaviorEVENTS.Behavior,kind of behaviorBEHAVIOR TRANS.New BehaviorFISHING RESULTSResultFISHED.Resultoutcome of a fishing attemptFOODKINDSFoodkindEATS.Foodkind,BEHAVIOR TRANS.Fishkind Valkind of food eaten by chimpanzeesFOODPARTSFoodpartEATS.Foodpart,part (plant part, animal organ, etc) of theFOODPART TRANS.New Foodpart, different kinds of foods eaten byBEHAVIOR TRANS.Fishpart Val OR TRANS.Position Valdesignated region within the forest canopyPLAY TYPESPlayPLAYS.Play,PLAY TRANS.New Play,BEHAVIOR TRANS.Play Valplay activityRESTING POSTURESRestRESTS.Rest,BEHAVIOR TRANS.Rest Valposture when restingRIDING POSTURES RidesRIDES.Ride,BEHAVIOR TRANS.Ride Valposture when ridingVOCALIZATIONSVOCS.Vocalization,class of chimpanzee vocalization definedVOC TRANS.New Voc,in the data collection protocolsBEHAVIOR TRANS.Vocalization ValVocalizationOne entry for every possible choice of.Follow Distance RelatedTableId ColumnRelated Column(s)One entry for every possible choice e categoryDISTANCE TRANS.New DistanceTableId ColumnRelated Column(s)One entry for every possible choice of.GCSTATUSESGCStatusFIELDFOLLOWS.GCStatusgroup composition statusGM ORIGINSOriginRAW GROUPMEMBERS.Origin,GC TRANS.Originsource of data for an individual’s groupmembershipGroup Related
The Gombe-MI Pocket Reference Guide5 / 911.4 The Warning Sub-System Support TablesTableId ColumnRelated Column(s)One entry for every possible choice of.IQTYPESIQTypeINTEGRITY QUERIES.Typekind of problem with data integrityWARNING REMARKSWRIDremark which might apply to more thanINTEGRITY WARNINGS.Category one instance of questionable databaseintegrity1.5 An Overview Of The ViewsDemography RelatedViewBIOGRAPHYBIOGRAPHY UPLOADOne row for eachPurposeTables/Views usedBIOGRAPHY DATA rowProvides aninterface intothe masterbiographytableimportedfrom Accesswhich isinvariant, andslightly easierto use.BIOGRAPHY DATA, TWINSBIOGRAPHY DATA rowProvides anuploadinterface intothe masterbiographytable enablingeasy importfrom Access.BIOGRAPHY DATA
The Gombe-MI Pocket Reference Guide6 / 91Demography RelatedViewCHIMPSOne row for eachPurposeTables/Views usedBIOGRAPHY DATA row plusone row for each twinProvides aninterface intothe masterbiographytable with oneextra row foreach twin,BIOGRAPHY DATA, TWINSwhich is aCHIMPIDSduplicate ofthe twin’sBIOGRAPHY DATArow but usedwhen thetwins are notdistinguishable.Provides anuploadinterface intothe masterCOMMUNITY MEMBERSHIPCOMMUNITY MEMBERSHIP UPLOADCOMMUNITY MEMBERSHcommurownity membershiptable enablingeasy importfrom Access.
The Gombe-MI Pocket Reference Guide7 / 91Follow Mechanics RelatedViewOne row for eachPurposeTables/Views usedDATASHEET EVENTSEVENTS row per any relatedEATS, FISHED, PLAYS,RESTS, RIDES, or VOCSrows.To resemblethe eventportion of thedata entrysheets andprovide amechanismfor updatingevent relateddata in thedatabase.FOLLOWS, INTERVALS,EVENTS, PARTS, EATS,FISHED, PLAYS, RESTS,RIDES, VOCSDATASHEETSEVENTS row per any relatedEATS, FISHED, PLAYS,RESTS, RIDES, or VOCS rowsplus one row per DISTANCESrowTo produce areportresemblingthe data entrysheets.FOLLOWS, INTERVALS,EVENTS, PARTS,DISTANCES,DISTANCEPARTS, EATS,FISHED, PLAYS, RESTS,RIDES, VOCSFOCAL FOLLOWSFOLLOWS row, per eachpossible paring of infant andsibling (i.e. one row per followwhen there are no twins, tworows per follow when either theinfants or siblings are twins,and 4 rows per follow whenboth the infants and siblings aretwins)To provide asimplemechanismfor deletingand creatingfollows.FOLLOWS, FOLLOWPARTS(3 times)FOLLOW DURATIONSFOLLOWS rowComputesvarious totalsof time spentobservingduring thefollow.FOLLOWSFOLLOW INTERVALSINTERVALS row perINTERVALS rowFOLLOWS,FOLLOWPARTS(3 times),INTERVALS
The Gombe-MI Pocket Reference Guide8 / 91Follow Mechanics RelatedViewUPLOAD BEHAVIORSOne row for eachPurposeTables/Views usedFOLLOWS rowThis viewreturns norows. It isused only toupload followdata intoGombe-MI.FOLLOWS, FOLLOWPARTS,INTERVALS, EVENTS,PARTS, DISTANCES,DISTANCEPARTSOne row for eachPurposeTables/Views usedEVENTS row where there are 2chimpanzees involved in anactor/actee behavioral event,events involving baboons arenot included.Provides astraightforward way toanalyzedirectedsocialbehaviorsfrom theperspective ofwho isinitiating andwho receivingthe behavior.EVENTS, PARTS (twice, oncefor each chimpanzee involvedin the behavior),FOLLOWROLES (twice, oncefor each chimpanzee involvedin the behavior)EVENTS row where there are 2animals involved in anactor/actee behavioral event,including events involvingbaboons.Provides astraightforward way toanalyzedirectedsocialbehaviorsfrom theperspective ofwho isinitiating andwho receivingthe behavior.EVENTS, PARTS (twice, oncefor each animal involved in thebehavior), FOLLOWROLES(up to twice, once for eachchimpanzee involved in thebehavior)Follow Event RelatedViewACTOR ACTEESACTOR ACTEES W BABOONS
The Gombe-MI Pocket Reference Guide9 / 91Follow Event RelatedViewOne row for eachPurposeTables/Views usedASOCIAL EVENTSEVENTS row having a relatedPARTS row with a Part value ofSProvides adirect way toanalyzeasocialbehavioralevents.EVENTS, PARTS,FOLLOWROLESEVENT BOUTSFOLLOWPARTS row perINTERVALS row, perEVENTS.Behavior valuehaving a related PARTS rowthat shows the given focalinvolved in the given behavior -one row per follow, per focal,per interval in which the focalis involved in a behavior(excluding behavioral eventswhich involve a baboon), percode for the behavior involvedin.Providesper-focal,per-minuteanalysis forcontiguousminutes of NTERVALS, EVENTS,PARTS, CHIMPIDSEVENT BOUT AGGSFOLLOWPARTS row, perEVENTS.Behavior valuehaving a related PARTS rowthat shows the given focalinvolved in the given behavior -one row per follow, per focal inwhich the focal is involved in abehavior (excluding behavioralevents which involve a baboon),per code for the behaviorinvolved in.Providesper-focalanalysis forcontiguousminutes of NTERVALS, EVENTS,PARTS, CHIMPIDS
The Gombe-MI Pocket Reference Guide10 / 91Follow Event RelatedViewFAMILY EVENTSFOCAL EVENTSFOCAL SOCIAL EVENTSOne row for eachPurposeTables/Views usedEVENTS rowProvides away to reviewrecordedbehaviors in away similar tothe way datais recorded inthe field.EVENTS, PARTS (four times,once for each of the mother,infant, sibling, and othernon-focal individual who maybe involved in the behavior)EVENTS row per focalindividual involved in thebehavioral eventProvides adirect way toanalyzebehaviorswheninterested inthe function(mom, infant,sib,non-focal) ofthechimpanzeesinvolved inthe behavior.EVENTS, PARTS (once ortwice, once for the focal andagain if there is anotherindividual), FOLLOWROLES(once or twice, once for thefocal and again if there isanother individual)EVENTS row per individualinvolved in the behavioral eventwhen the individual is a focal inthe follow where there are 2chimpanzees involved in theexhibited behaviorProvides adirect way toanalyze socialbehaviorswheninterested inthe function(mom, infant,sib,non-focal) ofthechimpanzeesinvolved inthe behavior.EVENTS, PARTS (twice, oncefor the focal and once for theother individual),FOLLOWROLES (twice, oncefor the focal and once for theother individual)
The Gombe-MI Pocket Reference Guide11 / 91Follow Event RelatedViewOne row for eachPurposeTables/Views usedNOOBSFOLLOWS row, perFOLLOWPARTS row, perminute from 06:00 through20:00, inclusive, but only whenthere is no behavioral data onthe focal.Computesminutes ineach follow’sday duringwhich eachfocal has nodata onbehavior.FOLLOWPARTS, CHIMPIDSINTERVALS, EVENTS,PARTSSOCIAL BOUTSFOLLOWPARTS row perINTERVALS row, perEVENTS.Behavior valuehaving a related PARTS rowthat shows the given focalinvolved in the given behaviorwith a social partner, perAnimID of the social partner -one row per follow, per focal,per social partner, per intervalin which the focal is involved ina social behavior (excludingbehavioral events which involvea baboon), per code for thebehavior involved in.Providesper-focal, persocial-partner,per-minuteanalysis forcontiguousminutes of NTERVALS, EVENTS,PARTS, CHIMPIDSSOCIAL BOUT AGGSFOLLOWPARTS row perEVENTS.Behavior valuehaving a related PARTS rowthat shows the given focalinvolved in the given behaviorwith a social partner, perAnimID of the social partner -one row per follow, per focal,per social partner (excludingbehavioral events which involvea baboon), per code for thebehavior involved in.Providesper-focal, persocial partneranalysis forcontiguousminutes of NTERVALS, EVENTS,PARTS, CHIMPIDS
The Gombe-MI Pocket Reference Guide12 / 91Follow Event RelatedViewOne row for eachPurposeTables/Views usedSOCIAL EVENTSEVENTS row, per chimpanzee,where there are 2 chimpanzees(no baboons) involved in theexhibited behavior. So, 2 rowsper EVENTS row for thoseevents, involving chimpanzees,that are social in nature.Provides adirect way toanalyzechimp socialbehaviorsregardless ofwhether achimpanzee isa focal in thefollow.EVENTS, PARTS (twice, oncefor each chimpanzee involvedin the behavior),FOLLOWROLES (twice, oncefor each chimpanzee involvedin the behavior)SOCIAL EVENTS W BABOONSEVENTS row, per chimpanzee,where there are 2 animalsinvolved in the exhibitedbehavior, baboons included. So,2 rows per EVENTS row forthose events, involving animals,that are social in nature.Provides adirect way toanalyze socialbehaviorsregardless ofwhether achimpanzee isa focal in thefollow.EVENTS, PARTS (twice, oncefor each chimpanzee involvedin the behavior),FOLLOWROLES (twice, oncefor each chimpanzee involvedin the behavior)One row for eachPurposeTables/Views usedDISTANCES row per relatedDISTANCEPARTS row. So, 2rows per DISTANCES row.Provides adirect way toanalyzechimpinter-familialdistancesusing eitherChimpID orrole thechimp playsin the follow.DISTANCES,DISTANCEPARTS (twice,once for each chimpanzeeinvolved).Follow Distance RelatedViewDISTS
The Gombe-MI Pocket Reference Guide13 / 91Follow Distance RelatedViewFAMILY DISTSOne row for eachPurposeTables/Views usedDISTANCES rowProvides adirect way toanalyzechimpinter-familialdistancesbased on therole (mom,infant,sibling) thechimp playsin the follow,and a way tomaintain theunderlyingdata.DISTANCES,DISTANCEPARTS (threetimes, once for each possiblerole played in the follow).
The Gombe-MI Pocket Reference Guide2 The Gombe-MI ER Diagrams2.1 Gombe-MI Entity Relationship DiagramsFigure 1: Key to the Gombe-MI Entity Relationship Diagrams14 / 91
The Gombe-MI Pocket Reference GuideFigure 2: Gombe-MI Demography Entity Relationship Diagram15 / 91
The Gombe-MI Pocket Reference GuideFigure 3: Gombe-MI Essentials of a Follow Entity Relationship Diagram16 / 91
The Gombe-MI Pocket Reference GuideFigure 4: Gombe-MI Follow Distance Entity Relationship Diagram17 / 91
The Gombe-MI Pocket Reference Guide18 / 91
The Gombe-MI Pocket Reference Guide19 / 91
The Gombe-MI Pocket Reference GuideFigure 7: Gombe-MI Group Membership Entity Relationship Diagram20 / 91
The Gombe-MI Pocket Reference GuideFigure 8: Gombe-MI Follow Detailed Entity Relationship Diagram21 / 91
The Gombe-MI Pocket Reference GuideFigure 9: Gombe-MI Data Collection Templates Entity Relationship Diagram22 / 91
The Gombe-MI Pocket Reference Guide23 / 91
The Gombe-MI Pocket Reference Guide2.2 Warning Sub-System ER DiagramsFigure 10: Warning Sub-System Entity Relationship Diagram24 / 91
The Gombe-MI Pocket Reference Guide25 / 913 The Gombe-MI ViewsFor information on the operations (INSERT, UPDATE, DELETE) allowed by each view and their actions onthe underlying tables see The Gombe-MI Views of The Gombe-MI Reference Manual.3.1 Demography Related Views3.1.1 The BIOGRAPHY ViewSELECT,,,,,,,,,,,,,,,,,,,,,FROMbiography data.animid AS animidbiography data.animid num AS animid numbiography data.animname AS animnamebiography data.birthgroup AS birthgroupbiography data.bgcertainty AS bgcertaintybiography data.sex AS sexbiography data.momid AS momidbiography data.dadid AS dadidbiography data.dad prelim AS dad prelimbiography data.dad published AS dad publishedbiography data.firstborn AS firstbornbiography data.birthdate AS birthdatebiography data.bdmin AS bdminbiography data.bdmax AS bdmaxbiography data.bddist AS bddistbiography data.entrydate AS entrydatebiography data.entrytype AS entrytypebiography data.departdate AS departdatebiography data.departdateerror AS departdateerrorbiography data.departtype AS departtypebiography data.import datetime AS import datetimetwins.twin AS twinbiography dataLEFT OUTER JOIN twins ON (twins.animid biography data. ֓animid);Figure 11: Query Defining the BIOGRAPHY View
The Gombe-MI Pocket Reference GuideFigure 12: Entity Relationship Diagram of the BIOGRAPHY View26 / 91
The Gombe-MI Pocket Reference Guide3.1.2 The BIOGRAPHY UPLOAD ViewSELECT,,,,,,,,,,,,,,,,,,FROMbiography data.animid::TEXT AS "B AnimID"biography data.animid num::TEXT AS "B AnimID num"biography data.animname::TEXT AS "B AnimName"biography data.birthgroup::TEXT AS "B BirthGroup"biography data.bgcertainty::TEXT AS "B BGCertainty"biography data.sex::TEXT AS "B Sex"biography data.momid::TEXT AS "B MomID"CASEWHEN biography data.dad prelim THEN(biography data.dadid ’gmi dadid prelim’)::TEXTELSEbiography data.dadid::TEXTEND AS "B DadID"biography data.dad published AS "B DadID publication info"biography data.firstborn::TEXT AS "B FirstBorn"biography data.birthdate AS "B Birthdate"biography data.bdmin AS "B BDMin"biography data.bdmax AS "B BDMax"biography data.bddist::TEXT AS "B BDDist"biography data.entrydate AS "B Entrydate"biography data.entrytype::TEXT AS "B Entrytype"biography data.departdate AS "B Departdate"biography data.departdateerror AS "B DepartdateError"biography data.departtype::TEXT AS "B Departtype"biography data;Figure 13: Query Defining the BIOGRAPHY UPLOAD View27 / 91
The Gombe-MI Pocket Reference GuideFigure 14: Entity Relationship Diagram of the BIOGRAPHY UPLOAD View28 / 91
The Gombe-MI Pocket Reference Guide3.1.3 The CHIMPS id AS chimpidbiography data.animid AS animidbiography data.animid num AS animid numbiography data.animname AS animnamebiography data.birthgroup AS birthgroupbiography data.bgcertainty AS bgcertaintybiography data.sex AS sexbiography data.momid AS momidbiography data.dadid AS dadidbiography data.dad prelim AS dad prelimbiography data.dad published AS dad publishedbiography data.firstborn AS firstbornbiography data.birthdate AS birthdatebiography data.bdmin AS bdminbiography data.bdmax AS bdmaxbiography data.bddist AS bddistbiography data.entrydate AS entrydatebiography data.entrytype AS entrytypebiography data.departdate AS departdatebiography data.departdateerror AS departdateerrorbiography data.departtype AS departtypebiography data.import datetime AS import datetimetwins.twin AS twinbiography dataJOIN chimpids ON (chimpids.animid biography data.animid)LEFT OUTER JOIN twins ON (twins.animid biography data. ֓animid);Figure 15: Query Defining the CHIMPS View29 / 91
The Gombe-MI Pocket Reference GuideFigure 16: Entity Relationship Diagram of the CHIMPS View30 / 91
The Gombe-MI Pocket Reference Guide31 / 913.1.4 The COMMUNITY MEMBERSHIP UPLOAD ViewSELECT,,,,,FROMcommunity membership.animid::TEXT AS cm b animidcommunity membership.start date AS cm start datecommunity membership.end date AS cm end datecommunity membership.community id::TEXT AS cm cl community idcommunity membership.start source AS cm start sourcecommunity membership.end source AS cm end sourcecommunity membership;Figure 17: Query Defining the COMMUNITY MEMBERSHIP UPLOAD ViewFigure 18: Entity Relationship Diagram of the COMMUNITY MEMBERSHIP UPLOAD View
The Gombe-MI Pocket Reference Guide32 / 91
The Gombe-MI Pocket Reference Guide3.2 Follow Mechanics Related Views3.2.1 The DATASHEETS ViewSELECT ,,,,,,,,datasheet events.followid AS followiddatasheet events.intid AS intiddatasheet events.date AS datedatasheet events.time AS timedatasheet events.mom AS momdatasheet events.infant AS infantdatasheet events.infant2 AS infant2datasheet events.sib AS sibdatasheet events.sib2 AS sib2datasheet events.eid AS eiddatasheet events.behavior AS e behaviordatasheet events.position AS e positiondatasheet events.uncertain AS e uncertaindatasheet events.e mom AS e momdatasheet events.e mompart AS e mompartdatasheet events.e mom foodpart AS e mom foodpartdatasheet events.e mom foodkind AS e mom foodkinddatasheet events.e mom fishpart AS e mom fishpartdatasheet events.e mom fishkind AS e mom fishkinddatasheet events.e mom fishresult AS e mom fishresultdatasheet events.e mom voc AS e mom vocdatasheet events.e mom play AS e mom playdatasheet events.e mom rest AS e mom restdatasheet events.e infant AS e infantdatasheet events.e infantpart AS e infantpartdatasheet events.e infant foodpart AS e infant foodpartdatasheet events.e infant foodkind AS e infant foodkinddatasheet events.e infant fishpart AS e infant fishpartdatasheet events.e infant fishkind AS e infant fishkinddatasheet events.e infant fishresult AS ֓e infant fishresultdatasheet events.e infant voc AS e infant vocdatasheet events.e infant play AS e infant playdatasheet events.e infant ride AS e infant ridedatasheet events.e infant rest AS e infant restdatasheet events.e sib as e sibdatasheet events.e sibpart AS e sibpartdatasheet events.e sib foodpart AS e sib foodpartdatasheet events.e sib foodkind AS e sib foodkinddatasheet events.e sib fishpart AS e sib fishpartdatasheet events.e sib fishkind AS e sib fishkinddatasheet events.e sib fishresult AS e sib fishresultdatasheet events.e sib voc AS e sib voc
The Gombe-MI Pocket Reference Guide ii COLLABORATORS TITLE : The Gombe-MI Pocket Reference Guide ACTION NAME DATE SIGNATURE WRITTEN BY Karl O. Pinc, Elizabeth V. L
Sustainable Healthcare International (SHI) Foundation started out in 2009 as an indigenous non-governmental organization . Sales, Marketing, Business Development and Strategic Management. ---ensuring sustainable logistics services . 5 . 61, Biu Road Gombe Gombe State The Gombe office serves Gombe, Yobe, Borno, Adamawa and the Northern parts .
May 02, 2018 · D. Program Evaluation ͟The organization has provided a description of the framework for how each program will be evaluated. The framework should include all the elements below: ͟The evaluation methods are cost-effective for the organization ͟Quantitative and qualitative data is being collected (at Basics tier, data collection must have begun)
Silat is a combative art of self-defense and survival rooted from Matay archipelago. It was traced at thé early of Langkasuka Kingdom (2nd century CE) till thé reign of Melaka (Malaysia) Sultanate era (13th century). Silat has now evolved to become part of social culture and tradition with thé appearance of a fine physical and spiritual .
On an exceptional basis, Member States may request UNESCO to provide thé candidates with access to thé platform so they can complète thé form by themselves. Thèse requests must be addressed to esd rize unesco. or by 15 A ril 2021 UNESCO will provide thé nomineewith accessto thé platform via their émail address.
̶The leading indicator of employee engagement is based on the quality of the relationship between employee and supervisor Empower your managers! ̶Help them understand the impact on the organization ̶Share important changes, plan options, tasks, and deadlines ̶Provide key messages and talking points ̶Prepare them to answer employee questions
Dr. Sunita Bharatwal** Dr. Pawan Garga*** Abstract Customer satisfaction is derived from thè functionalities and values, a product or Service can provide. The current study aims to segregate thè dimensions of ordine Service quality and gather insights on its impact on web shopping. The trends of purchases have
Chính Văn.- Còn đức Thế tôn thì tuệ giác cực kỳ trong sạch 8: hiện hành bất nhị 9, đạt đến vô tướng 10, đứng vào chỗ đứng của các đức Thế tôn 11, thể hiện tính bình đẳng của các Ngài, đến chỗ không còn chướng ngại 12, giáo pháp không thể khuynh đảo, tâm thức không bị cản trở, cái được
opinions about the courts in a survey conducted by the National . criminal justice system, and that black women are imprisoned at a rate seven times greater than white women. The report indicates there has been an increase in their incarceration rate in excess of 400% in recent years. Further, three-fourths of the women, according to the report, were mothers, and two-thirds had children .
