Function reference • gapindex

Get Data

get_connected(): Define RODBC connection to Oracle

get_data(): Pull data from RACEBASE

get_station_info(): Pull station/grid data

Design-Based Index and Composition Estimation

calc_cpue(): Calculate CPUEs at haul level

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

Utility Functions

upload_oracle(): Upload a table to Oracle with associated metadata

stitch_entries(): Helper function to format sql queries