fecalTableDoc: Poop-link table

In mwhalen18/krspfecals: KRSP Auxilary Fecal Database

Description

Rather than house table descriptions in the SQL database or house them in an excel file somewhere, this is a handy function to get table documentation.

Usage

fecalTableDoc(con = NULL, table = NULL)

Arguments

table

character; which table to document

Format

a dataframe with 28597 rows and 8 variables

squirrel_id

integer id of squirrel owner of trapping id

trapping_id

integer id of trap id. NOTE: This is housed as "id" in the primary trapping database

year

integer year of trapping record

vial_number

integer id indicates whether a given trapping record contained more than one poop vial. Poop vial "1" correpsonds to primary poop vial

poop_id

character value of poop vial. Used to link to fecal data tables

poop_time

numeric value of time of fecal collection in the field. When this was not documented, an estimate is given as "time_guess"

problem_duplicate

0/1 Identifies whether poop_id appears for more than one trapping record

time_guess

numeric value of time estimate if fecal collection time was not present in trapping record

Access table descriptions

Details

This table acts a linker between the fecal database and the trapping database

mwhalen18/krspfecals documentation built on Dec. 21, 2021, 11:05 p.m.