Utility Scripts

There is a script in code/utility_scripts/run_utiliyt.R that houses a hodgepodge of R scripts used to perform miscellaneous functions to maintain the GAP_PRODUCTS Oracle schema outside of the standard production run of CPUE, Biomass, Size Composition, and Age Composition. Use these scripts in the following instances:

Update GAP_PRODUCTS.Taxonomic_Confidence Table

• Frequency: Once a year prior to survey
• Populates taxonomic confidence values for the current survey year for FOSS purposes.
• FOSS POCs: Emily Markowitz (@EmilyMarkowitz-NOAA), Zack Oyafuso (@zoyafuso-NOAA)
• Location: code/utility_scripts/taxonomic_confidence.R

Update GAP_PRODUCTS.TAXONONOIC_GROUPS Table

• Frequency: Once a year prior to survey or as needed when there are changes to GAP_PRODUCTS.TAXONONOIC_CLASSIFICATION and/or GAP_PRODUCTS.TAXONONOIC_CHANGES
• Updates any taxonomic changes to the taxonomic grouping table. This table is called during the data pulling step
• Location: code/utility_scripts/taxonomic_groupings.R

In case you need recreate audit tables and triggers for GAP_PRODUCTS tables

• Frequency: As Needed (mostly in case of emergency)
• Location: code/utility_scripts/create_audit_tables.R