Get Sample Event Information for Creating a Field Sheet

get_field_sheet_event_plan() is called within create_season_field_sheets() and retrieves the sampling event information from the database that is needed to prepare field sheets.

Usage

get_field_sheet_event_plan(con, sample_event_id_arg)

Arguments

con

A DBI connection object

sample_event_id

The numeric unique identifier of the targeted sampling event for a location Use get_sample_event to query and retrieve the IDs from the database.

Value

A list object containing the required arguments for create_field_sheet

• field_sheet_sample_plan A dataframe containing the content of the field sheet

• sample_event_number The non-unique sample event ID

• first_sample_date A date object YYYY-MM-DD representing the first day of sampling of a 2 day sampling event

• location_name The sampling location name (e.g., "Battle Creek")

• location_code The sampling location short code (e.g., "BTC")

See also

Other field sheet helpers: create_field_sheet(), create_season_field_sheets(), process_field_sheet_samples(), update_field_sheet_samples()