Package index

Get Data

get_connected()

Define RODBC connection to Oracle

get_data()

Pull AFSC GAP BTS survey data

Design-Based Index and Composition Estimation

calc_cpue()

Calculate haul-level catch per unit effort

calc_biomass_stratum()

Calculate index of total biomass per stratum

calc_biomass_subarea()

Calculate index of total biomass across aggregated subareas

calc_sizecomp_stratum()

Calculate numerical CPUE at length by haul

calc_sizecomp_subarea()

Calculate size composition across aggregated subareas

calc_alk()

Calculate age-length key (alk)

calc_agecomp_stratum()

Calculate stratum-level age composition and mean/std.dev length at age

calc_agecomp_region()

Calculate region-level age composition and mean/std.dev length at age

do_one_bootstrap()

Bootstrap a CPUE table from gapindex

run_bootstraps()

Bootstrap haul data and return index information

Utility Functions

sql_query()

Streamlined querying function using the DBI package

upload_oracle()

Upload a table to Oracle with associated metadata

stitch_entries()

Helper function to format sql queries