Skip to contents

Get Data

get_connected()
Define RODBC connection to Oracle
get_data()
Pull AFSC GAP BTS survey data
get_station_info()
Pull station/grid 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

Utility Functions

upload_oracle()
Upload a table to Oracle with associated metadata
stitch_entries()
Helper function to format sql queries