| Title: | FRAM Database Interface |
|---|---|
| Description: | A convenient tool for interfacing with FRAM access databases in R environments. |
| Authors: | Ty Garber [cre, aut], Collin Edwards [aut] (ORCID: <https://orcid.org/0000-0002-4937-5159>) |
| Maintainer: | Ty Garber <[email protected]> |
| License: | MIT + file LICENSE |
| Version: | 0.8.1.9000 |
| Built: | 2026-07-09 16:48:08 UTC |
| Source: | https://github.com/FRAMverse/framrsquared |
Convenience function for combining the separate mortality columns of the Mortality table. Note: this does not account for AEQ for Chinook.
add_total_mortality(.data)add_total_mortality(.data)
.data |
Dataframe with separate mortality columns |
.data with additional $total_mortality column just before $landed_catch.
Either provides the step by step process of adding new stock to a FRAM database, or walks through fram database run and checks the tables for potential errors associated with adding new stock.
addstock_check( file_name = NULL, run_id = NULL, old_stockcount = 78, override_db_checks = FALSE )addstock_check( file_name = NULL, run_id = NULL, old_stockcount = 78, override_db_checks = FALSE )
file_name |
filepath to database. If |
run_id |
RunID associated with the new stock in the FRAM database. If left as |
old_stockcount |
The number of stocks previously present to treat as the "baseline" – several checking steps will focus solely on newly added stocks. Defaults to 78. |
override_db_checks |
Ignore species, database type. When |
## Not run: ## review process addstock_check() ## check database for additional stock addstock_check("2024 Pre-Season Chinook DB - first test.mdb", run_id = 138) ## End(Not run)## Not run: ## review process addstock_check() ## check database for additional stock addstock_check("2024 Pre-Season Chinook DB - first test.mdb", run_id = 138) ## End(Not run)
Extract AEQ mortality from Chinook FRAM database. Refactored and stripped down from the framr package written by Dan Auerbach. https://github.com/FRAMverse/framr/
aeq_mortality(fram_db, run_id = NULL, msp = TRUE, label = TRUE)aeq_mortality(fram_db, run_id = NULL, msp = TRUE, label = TRUE)
fram_db |
Fram database object |
run_id |
numeric, RunID(s) as ID or ID:ID |
msp |
Do we use MSP expansion? Logical, default true. |
label |
Logical, defaults to TRUE. Add human-readable columns for flags, fisheries, stocks? |
## Not run: fram_db |> aeq_mortality(run_id = 132) ## End(Not run)## Not run: fram_db |> aeq_mortality(run_id = 132) ## End(Not run)
Performs error checks of a backwards FRAM run Returns nested tibble with diagnostics
bkfram_checks_coho(fram_db, backward_run_id = NULL, forward_run_id = NULL)bkfram_checks_coho(fram_db, backward_run_id = NULL, forward_run_id = NULL)
fram_db |
fram database object, supplied through connect_fram_db |
backward_run_id |
numeric, RunID |
forward_run_id |
numeric, RunID |
## Not run: fram_db |> bkfram_checks_coho(backward_run_id = 132, forward_run_id = 133) ## End(Not run)## Not run: fram_db |> bkfram_checks_coho(backward_run_id = 132, forward_run_id = 133) ## End(Not run)
Uses a match/replace-style table like in modify_table(), but allows user to specify
scaling factors for individual columns rather than absolute values, and returns
the corresponding match/replace df to be used in modify_table(). This is intended to support
sensitivity analyses structured as "carry out 100 runs, with stock recruit scalers for stock X
running from 5% to 500% of the current value" (calc_fram_scaling() is only one part
of the pipeline for this). See modify_table() for details of setting up a match/replace dataframe;
the only difference here is that the columns to be scaled should start with "scale_" instead
of "replace_", and should contain the scalers.
calc_fram_scaling(fram_db, table_name, df)calc_fram_scaling(fram_db, table_name, df)
fram_db |
FRAM database |
table_name |
name of FRAM table |
df |
As the match/replace dataframe of |
Note: In the StockRecruit table, RecruitScaleFactor and RecruitCohortSize should have a fixed relationship (scale factor = cohort size / base period size). For this reason, if applying scaling to only one of those columns, calc_fram_scaling will automatically apply the same scaling to the other. If the scaling for both is provided and they do not match, calc_fram_scaling will error out.
A match/replace df for use in modify_table(), with "replace_" values
generated by scaling the corresponding values in the FRAM database. Includes additional "match_"
columns for all columns except "PrimaryKey"
## Not run: ## in run 31, decrease stock 1's recruit numbers by 50% and double 2's recruit numbers library(here) fram_db <- connect_fram_db(here("example_fram_db.mdb")) df <- data.frame(match_RunID = c(31, 31), match_StockID = 1:2, scale_RecruitScaleFactor = c(.5, 2)) df_scaled <- calc_fram_scaling(fram_db, "StockRecruit", df) ## here's what the values become: df_scaled ## we can then modify the database modified <- modify_table(fram_db, "StockRecruit", df_scaled) disconnect_fram_db(fram_db) ## End(Not run)## Not run: ## in run 31, decrease stock 1's recruit numbers by 50% and double 2's recruit numbers library(here) fram_db <- connect_fram_db(here("example_fram_db.mdb")) df <- data.frame(match_RunID = c(31, 31), match_StockID = 1:2, scale_RecruitScaleFactor = c(.5, 2)) df_scaled <- calc_fram_scaling(fram_db, "StockRecruit", df) ## here's what the values become: df_scaled ## we can then modify the database modified <- modify_table(fram_db, "StockRecruit", df_scaled) disconnect_fram_db(fram_db) ## End(Not run)
Changes a run's ID number in a FRAM database
change_run_id(fram_db, old_run_id, new_run_id)change_run_id(fram_db, old_run_id, new_run_id)
fram_db |
FRAM database object |
old_run_id |
FRAM run ID to be changed |
new_run_id |
New FRAM run ID |
## Not run: fram_db |> change_run_id(old_run_id = 132, new_run_id = 300)## Not run: fram_db |> change_run_id(old_run_id = 132, new_run_id = 300)
Reads a package NAMESPACE file to extract exported functions and checks whether each function appears in a specified documentation file (e.g., a Quarto document or vignette). Reports coverage statistics to the console using the cli package.
check_demo_coverage(namespace_path, doc_path)check_demo_coverage(namespace_path, doc_path)
namespace_path |
Character string. Path to the NAMESPACE file, typically located at the root of an R package directory. |
doc_path |
Character string. Path to the documentation file to check (e.g., a .qmd, .Rmd, or .md file). |
The function searches for function calls in the form function_name( to
determine if a function is present in the documentation. It prints a
formatted report to the console showing which functions are documented
and which are missing.
Invisibly returns a list with three elements:
foundCharacter vector of function names found in the document
missingCharacter vector of function names not found in the document
coverageNumeric percentage of functions documented
## Not run: # Check if all exported functions appear in a vignette check_demo_coverage("NAMESPACE", "vignettes/function_demo.qmd") # Store results for further analysis results <- check_demo_coverage("NAMESPACE", "README.md") results$missing ## End(Not run)## Not run: # Check if all exported functions appear in a vignette check_demo_coverage("NAMESPACE", "vignettes/function_demo.qmd") # Store results for further analysis results <- check_demo_coverage("NAMESPACE", "README.md") results$missing ## End(Not run)
Returns a tibble displaying predicted FRAMencounter mark rates by fishery,
fishery type, and time-step.
coho_mark_rates(fram_db, run_id = NULL)coho_mark_rates(fram_db, run_id = NULL)
fram_db |
FRAM database object |
run_id |
Run ID (optional) |
## Not run: fram_db |> coho_mark_rates(run_id) ## End(Not run)## Not run: fram_db |> coho_mark_rates(run_id) ## End(Not run)
The starting cohort abundance listed in the database can be wrong. This function calculates the value by multipying the Stock Recruit Scalar by the base period abundance.
cohort_abundance(fram_db, run_id = NULL)cohort_abundance(fram_db, run_id = NULL)
fram_db |
FRAM database object |
run_id |
Run ID (optional) |
## Not run: fram_db |> cohort_abundance(run_id = 145) ## End(Not run)## Not run: fram_db |> cohort_abundance(run_id = 145) ## End(Not run)
Function supports QAQC practices by comparing the tables of two FRAM databases and identifying (and quantifying) differences.
compare_databases( fram_db_1, fram_db_2, runid_use = NULL, tables_use = NULL, slim = TRUE, quiet = TRUE )compare_databases( fram_db_1, fram_db_2, runid_use = NULL, tables_use = NULL, slim = TRUE, quiet = TRUE )
fram_db_1 |
connection to FRAM database that contains the results from running baseline FRAM runs (e.g., our "original" version). |
fram_db_2 |
connection to FRAM database that contains the results from running modified FRAM runs (e.g., running a new version of FRAM or using modified input values) |
runid_use |
Numeric vector of the run_ids to compare. Optional. If not provided, compare all run ids in the databases. |
tables_use |
Vector of character strings. Optional. If provided, only compare the listed tables. |
slim |
Logical. Optional, defaults to TRUE. If TRUE, do not include |
quiet |
Logical, defaults to TRUE. When TRUE, suppress messages showing individual steps. |
The key output is the $ratios tibble, which contains every comparison of relevant
table entries in long-form. These comparisons are implemented by first aligning
corresponding table rows using appropriate key columns (e.g. run_id, fishery_id,
stock_id, age, time_step, etc).
In $ratios, the table and variable columns
specify the table column being compared, respectively. prop_err, abs_err,
and scale_err provide measures of the changes between the "original" value
(from fram_db_1) and the "comparison" value (from fram_db_2). More on those below.
The original and new columns give the actual values being compared.
run_id through time_step specify the rows being compared. bkfram_off_by_fish
and bkfram_off_by_prop provide the context for the comparison (more on that below).
Quantifying error
Because FRAM involves numerical solvers, we expect some small differences in table entries
even when comparing two effectively equivalent databases. compare_databases() provides three metrics for these changes.
In each case, it is assumed that fram_db_1 is the reference file; the "error" measures all show how much the value
in fram_db_2 changed relative to the corresponding value in fram_db_1.
The simplest measure of error is the abs_err. This is the absolute value of the difference between
the two values. If we're looking at an entry with table = "Mortality" and variable = "landed_catch",
then an abs.err of 5 means that the fram_db_2 entry was five fish more or less than the fram_db_1 entry. You can confirm this
by looking at the original and new columns. While abs_err is the most easily interpreted,
it is often not very meaningful when looking across tables and variables. After all, an abs_err value of 5 could mean a
a relatively meaningless change of five fish for a landed catch entry that was originally thousands of fish,
but the same value of 5 would be a huge change in fishing effort if it were for a fishery scaler entry.
One way to make error comparable across tables and variables is to calculate the proportional error.
If an entry changed by 0.01%, that's not meaningful, while if it changed by 10%, that is. $prop_err provides
this proportional error, where -0.5 means the entry in fram_db_2 was 50% less than the corresponding value in fram_db_1,
and a value of 2 means the entry in fram_db_2 was 200% more than the corresponding value in fram_db_1. '
This gives error in context of the original value, and is often a good a way to look for problems. However,
we sometimes find very large $prop_err values for changes that aren't concerning. For example,
we may have an entry for landed catch in the mortality table that was 0.00001 fish in fram_db_1,
and 0 fish in fram_db_2. In all practicality these two values are identical, and the
0.00001 fish difference is likely one of random jitter in the numerical solver or rounding differences.
However, our $prop_err value for this cell is -1, the most extreme negative change we can get.
We can jointly look at $abs_err and $prop_err to address the potential for
misleadingly large errors $prop_err, but it would be nice to have a single error metric that
provides error in context without being sensitive to very small entries in fram_db_1.
scale_err is an elaboration on $prop_err that provides broader context. $prop_err
takes the absolute error and scales by the original value in fram_db_1. $scale_err generalizes this idea,
first calculating the average error for each table-variable combination, and then scaling the
absolute error by the corresponding table-variable average. That is, if an entry for landed_catch in the
Mortality table was 0.001 in fram_db_1, and was then 0.002 in fram_db_2, and the average of all landed_catch
entries in fram_db_1 was 1000, then the prop_err would be 1 (since fram_db_2 had double the value of fram_db_1, or (0.002-0.001)/0.001),
and the scale.err would be 0.000001 ((0.002-0.001)/1000). This better captures our intuition
that a difference of 0.001 fish in the landed catch isn't a big deal, since those values are typically huge.
scale_err is thus a measure of error that is comparable across variables and tables, essentially answer the question
"Has this entry changed a lot for this kind of variable and table?".
While scale_err is frequently the most useful error metric, compare_databases() provides all three.
There may be contexts in which it's important to focus on the proportional error. For example,
large proportional errors landed catch for the catch rare stocks can be important, but
the much larger catch from other stock could water down the scale_err metric.
Addressing the backwardsFRAM wiggle
For post-season runs, the backwards FRAM algorithm is employed; its solver stops when
the estimated fish numbers are within 1 fish of the target size. This means that there is
the potential for substantial "wiggle" in bkFRAm values when comparing two databases.
This wiggle can propagate to other tables, especially for stock-age-timesteps in which
the target values were quite small (so a wiggle of +/- 1 fish would be a proportionally large
amount). For this reason, it can be useful to see how our measures of error correspond to the errors in the
corresponding bk fram table. For every table entry for which this makes sense (e.g., has a stock id, age, and timestep),
$bkfram_off_by_fish gives the absolute error in the corresponding row of the BackwardsFram table, and
bkfram_off_by_prop give the relative error (as a proportion)
in the corresponding row of the BackwardsFram table. If
this bkfram wiggle were the cause of observed errors, we would expect the
largest errors to correspond to the largest
$bkfram_off_by_fish or $bkfram_off_by_prop values.
Suggestions
For simple plotting to see if the original and new values fall on the 1:1
line, ggplot2::geom_point() can be used, with $ratios$original and $ratios$new
for x and y, and a facet_wrap by table (and perhaps variable) to
make plots readable. For identifying meaningful change, scale.err is likely the best measure of error.
It can be helpful to plot scale.err against bkfram.off.by.fish or bkfram.off.by.prop to
see if the table entries with the largest error correspond to the stock-fishery-age-timestep in which
there's the largest wiggle in the backwards fram solutions.
When digging into individual tables, it can sometimes be helpful to look at the comparisons in $ratios_detailed,
which contains additional columns which did not fit into the standardized formatting of $ratios.
List of lists and tibbles containing comparison information:
$ratios tibble comparing every entry of every relevant column of every table. See "Details" for column descriptions.
$ratios_detailed list of tibbles showing the contents of $ratios broken into tables, with additional non-compared columns present (e.g., stock_name in $ratios_detailed$Stock). Not shown if slim is TRUE.
$nrow_tracker dataframe providing the number of rows in each table of file1 ($nrow_original), file2 ($nrow_new), and the joined comparison ($nrow_comparison). Useful to track down cause of many-to-many join warnings that can result from duplicated table entries; unless there are duplicate entries, $nrow_comparison should be less than or equal to the minimum of $nrow_original and $nrow_new.
$tabs_file1 List containing the original fetched tables from file1. Not returned if argument slim is TRUE
$tabs_file2 List containing the original fetched tables from file2. Not returned if argument slim is TRUE.
## Not run: fram_db_1 = connect_fram_db("Valid2022_Round_7_1_1_11142023_REFERENCE_fixed - fork rebuild.mdb") fram_db_2 = connect_fram_db("Valid2022_Round_7.1.1_11142023 - green river split.mdb") out = tables_compare(fram_db_1, fram_db_2) ## End(Not run)## Not run: fram_db_1 = connect_fram_db("Valid2022_Round_7_1_1_11142023_REFERENCE_fixed - fork rebuild.mdb") fram_db_2 = connect_fram_db("Valid2022_Round_7.1.1_11142023 - green river split.mdb") out = tables_compare(fram_db_1, fram_db_2) ## End(Not run)
Compares the fishery flags of two runs
compare_fishery_input_flags(fram_db, run_ids, verbose = TRUE)compare_fishery_input_flags(fram_db, run_ids, verbose = TRUE)
fram_db |
FRAM database object |
run_ids |
Two run ids |
verbose |
If |
## Not run: fram_db |> compare_fishery_input_flags(c(55, 56))## Not run: fram_db |> compare_fishery_input_flags(c(55, 56))
Compares the fishery inputs of two runs
compare_fishery_inputs(fram_db, run_ids, tolerance = 0.01, verbose = TRUE)compare_fishery_inputs(fram_db, run_ids, tolerance = 0.01, verbose = TRUE)
fram_db |
FRAM database object |
run_ids |
Two run ids |
tolerance |
Tolerance for detecting changes |
verbose |
If |
## Not run: fram_db |> compare_fishery_inputs(c(55, 56))## Not run: fram_db |> compare_fishery_inputs(c(55, 56))
Generates a dataframe that compares fishery scalers table for two runs identified by run_id's
compare_inputs(fram_db, run_ids)compare_inputs(fram_db, run_ids)
fram_db |
FRAM database object |
run_ids |
Vector of two run_ids |
Comparisons assume the first run provided is the baseline, and provide relative changes from that. This includes percent changes ($percent.diff)include percent changes (infinite when)
Data frame of differences. $percentdiff = change in quota (comparing the appropriate quotas based on fishery flags),
$regulation_comparison = change in regulation (NS, MSF, NS + MSF). Columns present in the
FisheriesScalers database are included, with _original and _comparison
suffixes identifying entries associated with the first and second entries of
run_ids, respectively.
## Not run: fram_db |> compare_inputs(c(100,101))## Not run: fram_db |> compare_inputs(c(100,101))
Can be a very busy chart if not filtered down. Consider using a filter on the dataframe before piping into compare_input_chart.
compare_inputs_chart(.data)compare_inputs_chart(.data)
.data |
Dataframe origination from the compare_inputs() function |
## Not run: fram_db |> compare_inputs(c(100, 101)) |> compare_inputs_chart()## Not run: fram_db |> compare_inputs(c(100, 101)) |> compare_inputs_chart()
Compares the non retention flags of two runs
compare_non_retention_input_flags(fram_db, run_ids, verbose = TRUE)compare_non_retention_input_flags(fram_db, run_ids, verbose = TRUE)
fram_db |
FRAM database object |
run_ids |
Two run ids |
verbose |
If |
## Not run: fram_db |> compare_non_retention_inputs(c(55, 56))## Not run: fram_db |> compare_non_retention_inputs(c(55, 56))
Compares the non retention inputs of two runs
compare_non_retention_inputs(fram_db, run_ids, verbose = TRUE)compare_non_retention_inputs(fram_db, run_ids, verbose = TRUE)
fram_db |
FRAM database object |
run_ids |
Two run ids |
verbose |
If |
## Not run: fram_db |> compare_non_retention_inputs(c(55, 56))## Not run: fram_db |> compare_non_retention_inputs(c(55, 56))
Compares the recruit scalers of two runs
compare_recruits(fram_db, run_ids, tolerance = 0.01, verbose = TRUE)compare_recruits(fram_db, run_ids, tolerance = 0.01, verbose = TRUE)
fram_db |
FRAM database object |
run_ids |
Two run ids |
tolerance |
Tolerance for detecting changes |
verbose |
If |
## Not run: fram_db |> compare_recruits()## Not run: fram_db |> compare_recruits()
Generates a report to the console of changes to inputs between two runs
compare_runs(fram_db, run_ids, tolerance = 0.01)compare_runs(fram_db, run_ids, tolerance = 0.01)
fram_db |
FRAM database object |
run_ids |
Two run ids. Run names must differ; change in FRAM if necessary. |
tolerance |
Tolerance of detection, 1 percent default |
## Not run: fram_db |> compare_runs(c(55, 56))## Not run: fram_db |> compare_runs(c(55, 56))
Compares the stock fishery rate scalers of two runs
compare_stock_fishery_rate_scalers(fram_db, run_ids)compare_stock_fishery_rate_scalers(fram_db, run_ids)
fram_db |
FRAM database object |
run_ids |
Two run ids |
## Not run: fram_db |> compare_stock_fishery_rate_scalers(c(55, 56))## Not run: fram_db |> compare_stock_fishery_rate_scalers(c(55, 56))
This produces a connection object to a FRAM database, which is a necessary precursor for almost all framrsquared functions. For most users, can just treat the connection object as a black box that's used as an argument in other functions. See details for an explanation of the returned object.
connect_fram_db(db_path, read_only = FALSE, quiet = FALSE)connect_fram_db(db_path, read_only = FALSE, quiet = FALSE)
db_path |
Path to a FRAM database. |
read_only |
Logical, defaults to FALSE. Optional argument to flag this connection as read-only (if set to |
quiet |
Logical, defaults to FALSE. Optional argument; when TRUE, silences success message and database summary. |
The returned object of connect_fram_db() is a list of useful objects for other framrsquared functions.
$fram_db_connectionconnection object, used for SQL calls.
$fram_db_connection_idconnection name in .fram_connections, used for orphan cleanup via disconnect_all_fram_connections().
$fram_db_type"full" or "transfer", useful for validation for specific functions.
$fram_db_species"COHO" or "CHINOOK"
$fram_db_speciesfiletype, typeically "mdb"
$fram_read_onlyOptional user-specified safety measure, TRUE or FALSE. Functions that modify the fram database should error out if TRUE.
framrsquared creates a special environment in the global environment, .fram_connections. Whenever a new connection is made with connect_fram_db, it is added to that environment as well; whenever the connection is closed with disconnect_fram_db(), the connection is removed from that environment. This tracking allows disconnect_all_fram_connections() to clear out any orphan connections made by assigning a connection to an existing connection object.
disconnect_fram_db(), disconnect_all_fram_connections()
## Not run: fram_db <- connect_fram_db('<path>') fram_db |> fetch_table("Mortality") ## End(Not run)## Not run: fram_db <- connect_fram_db('<path>') fram_db |> fetch_table("Mortality") ## End(Not run)
Experimental copying scaler inputs from one run to another DANGEROUS
copy_fishery_scalers(fram_db, from_run, to_run, fishery_id = NULL)copy_fishery_scalers(fram_db, from_run, to_run, fishery_id = NULL)
fram_db |
FRAM database object |
from_run |
Run ID to be copied from |
to_run |
Run ID to be copied to |
fishery_id |
ID or IDs for specific fishery(s) to copy inputs to/from. If not provided, interactive option to copy inputs for all fisheries. |
## Not run: framdb |> copy_fishery_scalers(132, 133, 87)## Not run: framdb |> copy_fishery_scalers(132, 133, 87)
FRAM is stored in an access database; these have hard size limits of 2GB. Chinook and Coho are expected to reach this limit with ~540 runs. This function includes a failsafe to prevent databases from exceeding 500 runs. This can be overridden with optional force_many_runs argument.
copy_run( fram_db, target_run, times = 1, label = "copy", force_many_runs = FALSE, verbose = TRUE )copy_run( fram_db, target_run, times = 1, label = "copy", force_many_runs = FALSE, verbose = TRUE )
fram_db |
FRAM database object |
target_run |
Run ID to be copied from |
times |
Number of copies |
label |
Label of each copy e.g. copy 1, copy 2 |
force_many_runs |
|
verbose |
Show warning message about run count? Official FRAM is hard-coded to only handle databases with <= 150 runs in them. If |
Invisibly returns the run ids of the copied runs, for use in other functions.
## Not run: framdb |> copy_run(target_run = 141, times = 1)## Not run: framdb |> copy_run(target_run = 141, times = 1)
Preps a folder for batch running in the 'Run Multiple Runs' screen of the FRAM automation fork (https://github.com/FRAMverse/FRAM_automation), for use with the advanced approach to identify multiple runs. One TAMM file will be copied multiple times in the target_folder with suffixes that identify each of the run_ids. The "Use folder" button on the "Run Multiple Runs" screen can then use the target folder to set up large batch runs. Typically users should use make_batch_runs() instead (this first copies runs and then uses copy_tamms to create tamms that match the new runs).
copy_tamms(tamm_name, target_folder, run_id_vec, overwrite = FALSE)copy_tamms(tamm_name, target_folder, run_id_vec, overwrite = FALSE)
tamm_name |
TAMM file to copy, including file path. Character string |
target_folder |
directory to put new batch TAMM files into. Character string |
run_id_vec |
vector of run_ids (numeric or character), corresponding to run ids in a FRAM database. |
overwrite |
If one or more files already exist in |
invisibly returns logical vector of file.copy() success.
## Not run: copy_tamms(tamm_name = "C:/TAMMs/Chin2020.xlsx", target_folder = "C:/Batch_run_5", run_id_vec = 10:20) ## End(Not run)## Not run: copy_tamms(tamm_name = "C:/TAMMs/Chin2020.xlsx", target_folder = "C:/Batch_run_5", run_id_vec = 10:20) ## End(Not run)
It is relatively easy to create an orphan connection using framrsquared by assigning a connection to fram_db, and then assigning another connection to fram_db without disconnecting the first connection using disconnect_fram_db(). Orphaned connections can make it frustrating to work with database files (moving, deleting, etc) without restarting rstudio or rebooting your computer. disconnect_all_fram_connections() disconnects any existing connections made by framrsquared in this R session.
disconnect_all_fram_connections()disconnect_all_fram_connections()
nothing
## Not run: fram_db = connect_fram_db("Chin2025.mdb") fram_db = connect_fram_db("Chin2025.mdb") disconnect_fram_db(fram_db) list_extant_fram_connections() ## oops, still a connection left. disconnect_all_fram_connections() list_extant_fram_connections ## End(Not run)## Not run: fram_db = connect_fram_db("Chin2025.mdb") fram_db = connect_fram_db("Chin2025.mdb") disconnect_fram_db(fram_db) list_extant_fram_connections() ## oops, still a connection left. disconnect_all_fram_connections() list_extant_fram_connections ## End(Not run)
Safely disconnect from FRAM database
disconnect_fram_db(fram_db, quiet = TRUE)disconnect_fram_db(fram_db, quiet = TRUE)
fram_db |
FRAM database R object |
quiet |
Logical. Optional; when true, silences success message. |
## Not run: disconnect_fram_db(fram_db)## Not run: disconnect_fram_db(fram_db)
Creates template files from specified organization in the specified path. Generally
initialize_project() will be more useful for new R projects, while fetch_quarto_templates()
can be helpful when working with existing projects. See initialize_project()
for details on adding template files for new organizations.
fetch_quarto_templates( to.path, organization = c("WDFW"), color = "coffee", overwrite = FALSE )fetch_quarto_templates( to.path, organization = c("WDFW"), color = "coffee", overwrite = FALSE )
to.path |
Character string. Destination file path for template files. Typically, root of Rproject directory. |
organization |
Character, defaults to "WDFW". Specifies the set of quarto templates to use. Currently only supports "WDFW". |
color |
Character string, defaults to "coffee". Specifies quarto template to use; organizations may have several. |
overwrite |
Boolean. Overwrite _quarto.yml and style.css files if they already exist? Defaults to FALSE. |
Nothing.
Returns a cleaned tibble, with column labels that were camel case (e.g., TimeStep) converted to snake case (e.g., time_step).
WARNING: the Chinook "BackwardsFRAM" table uses a different stock_id numbering system from every other table. To avoid errors when joining that with other tables, instead fetch with fetch_table_bkchin()
fetch_table_() is an alias for fetch_table() with the optional argument label set to FALSE.
fetch_table(fram_db, table_name = NULL, label = TRUE, warn = TRUE) fetch_table_(fram_db, table_name = NULL, warn = TRUE)fetch_table(fram_db, table_name = NULL, label = TRUE, warn = TRUE) fetch_table_(fram_db, table_name = NULL, warn = TRUE)
fram_db |
FRAM database object |
table_name |
Atomic character of name of table to be fetched. If not given, a list of options will be printed. |
label |
Logical, defaults to TRUE. Add human-readable columns for flags, fisheries, stocks? |
warn |
Print a warning when fetching BackwardsFRAM table from a Chinook database? Logical, defaults to |
## Not run: fram_db <- connect_fram_db("validat2024.mdb") fram_db |> fetch_table('Mortality') ## End(Not run)## Not run: fram_db <- connect_fram_db("validat2024.mdb") fram_db |> fetch_table('Mortality') ## End(Not run)
The BackwardsFRAM table uses a stock_id different numbering system from all other tables, and includes sums of joint stocks (e.g. for a marked and unmarked pair of stocks, BackwardsFRAM will typically have an additional stock which represents the sum of those two). Because the numbering is different but the column name is the same, joining the Chinook BackwardsFRAM table with other tables can cause problems.
fetch_table_bkchin(fram_db)fetch_table_bkchin(fram_db)
fram_db |
FRAM database object |
This function augments fetch_table by renaming the stock_id column to bk_stock_id, and
then adding on the associated stock_id (with NAs when the bkfram stock is one of these new "sum" stocks
and the associated bkfram stock names). This function only works for Chinook databases.
The resulting dataframe will necessarily NOT be an exact match to the BackwardsFRAM table in the FRAM database. The stock_id column will differ (containing normal stock ID values instead of bk stock ID values), and there will be two additional columns.
#' @examples ## Not run: ##Potentially problematic stock_id won't align with other tables fram_db |> fetch_table('BackwardsFRAM') ## "safe" version of the table; stock_id WILL align with other tables fram_db |> fetch_table_bkchin() ## End(Not run)#' @examples ## Not run: ##Potentially problematic stock_id won't align with other tables fram_db |> fetch_table('BackwardsFRAM') ## "safe" version of the table; stock_id WILL align with other tables fram_db |> fetch_table_bkchin() ## End(Not run)
.data must have
a fishery_id column name.Filters a dataframe to Alaska fisheries. Will
automatically detect whether it's working with a Chinook or Coho
dataset if the tables were generated within this package. .data must have
a fishery_id column name.
filter_ak(.data, species = NULL)filter_ak(.data, species = NULL)
.data |
Dataframe containing |
species |
Optional argument to identify species if |
Other fishery_filters:
filter_bc(),
filter_ca(),
filter_coast(),
filter_commercial_wa_nt(),
filter_marine(),
filter_net(),
filter_or(),
filter_puget_sound(),
filter_sport(),
filter_wa()
## Not run: fram_dataframe |> filter_ak() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_ak(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_ak(species = "COHO")## Not run: fram_dataframe |> filter_ak() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_ak(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_ak(species = "COHO")
.data must have
a fishery_id column name.Filters a dataframe to Canadian (BC) fisheries. Will
automatically detect whether it's working with a Chinook or Coho
dataset if the tables were generated within this package. .data must have
a fishery_id column name.
filter_bc(.data, species = NULL)filter_bc(.data, species = NULL)
.data |
Dataframe containing |
species |
Optional argument to identify species if |
Other fishery_filters:
filter_ak(),
filter_ca(),
filter_coast(),
filter_commercial_wa_nt(),
filter_marine(),
filter_net(),
filter_or(),
filter_puget_sound(),
filter_sport(),
filter_wa()
## Not run: fram_dataframe |> filter_bc() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_bc(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_bc(species = "COHO")## Not run: fram_dataframe |> filter_bc() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_bc(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_bc(species = "COHO")
.data must have
a fishery_id column name.Filters a dataframe to California fisheries. Will
automatically detect whether it's working with a Chinook or Coho
dataset if the tables were generated within this package. .data must have
a fishery_id column name.
filter_ca(.data, species = NULL)filter_ca(.data, species = NULL)
.data |
Dataframe containing |
species |
Optional argument to identify species if |
Other fishery_filters:
filter_ak(),
filter_bc(),
filter_coast(),
filter_commercial_wa_nt(),
filter_marine(),
filter_net(),
filter_or(),
filter_puget_sound(),
filter_sport(),
filter_wa()
## Not run: fram_dataframe |> filter_ca() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_ca(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_ca(species = "COHO")## Not run: fram_dataframe |> filter_ca() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_ca(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_ca(species = "COHO")
.data must have
a fishery_id column name.Filters a dataframe to Coastal fisheries. Will
automatically detect whether it's working with a Chinook or Coho
dataset if the tables were generated within this package. .data must have
a fishery_id column name.
filter_coast(.data, species = NULL)filter_coast(.data, species = NULL)
.data |
Dataframe containing |
species |
Optional argument to identify species if |
Other fishery_filters:
filter_ak(),
filter_bc(),
filter_ca(),
filter_commercial_wa_nt(),
filter_marine(),
filter_net(),
filter_or(),
filter_puget_sound(),
filter_sport(),
filter_wa()
## Not run: fram_dataframe |> filter_coast() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_coast(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_coast(species = "COHO")## Not run: fram_dataframe |> filter_coast() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_coast(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_coast(species = "COHO")
Will automatically detect whether it's working with a Chinook or Coho
dataset if the tables were generated within this package. .data must have
a fishery_id column name.
filter_commercial_wa_nt(.data, species = NULL)filter_commercial_wa_nt(.data, species = NULL)
.data |
Dataframe containing |
species |
Optional argument to identify species if |
Other fishery_filters:
filter_ak(),
filter_bc(),
filter_ca(),
filter_coast(),
filter_marine(),
filter_net(),
filter_or(),
filter_puget_sound(),
filter_sport(),
filter_wa()
## Not run: fram_dataframe |> filter_commercial_wa_NT() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_commercial_wa_nt(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_commercial_wa_nt(species = "COHO")## Not run: fram_dataframe |> filter_commercial_wa_NT() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_commercial_wa_nt(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_commercial_wa_nt(species = "COHO")
NA's all the information in the FisheryScalers that's not being used e.g Flag 1 only NS Scalers will be returned
filter_flag(.data)filter_flag(.data)
.data |
Fishery Scalers table |
## Not run: fishery_scalers_table |> filter_flag()## Not run: fishery_scalers_table |> filter_flag()
.data must have
a fishery_id column name.Filters a dataframe to marine fisheries. Will
automatically detect whether it's working with a Chinook or Coho
dataset if the tables were generated within this package. .data must have
a fishery_id column name.
filter_marine(.data, species = NULL)filter_marine(.data, species = NULL)
.data |
Dataframe containing |
species |
Optional argument to identify species if |
Other fishery_filters:
filter_ak(),
filter_bc(),
filter_ca(),
filter_coast(),
filter_commercial_wa_nt(),
filter_net(),
filter_or(),
filter_puget_sound(),
filter_sport(),
filter_wa()
## Not run: fram_dataframe |> filter_marine() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_marine(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_marine(species = "COHO")## Not run: fram_dataframe |> filter_marine() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_marine(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_marine(species = "COHO")
.data must have
a fishery_id column name.Filters a dataframe to net fisheries. Will
automatically detect whether it's working with a Chinook or Coho
dataset if the tables were generated within this package. .data must have
a fishery_id column name.
filter_net(.data, species = NULL)filter_net(.data, species = NULL)
.data |
Dataframe containing |
species |
Optional argument to identify species if |
Other fishery_filters:
filter_ak(),
filter_bc(),
filter_ca(),
filter_coast(),
filter_commercial_wa_nt(),
filter_marine(),
filter_or(),
filter_puget_sound(),
filter_sport(),
filter_wa()
## Not run: fram_dataframe |> filter_net() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_net(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_net(species = "COHO")## Not run: fram_dataframe |> filter_net() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_net(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_net(species = "COHO")
.data must have
a fishery_id column name.Filters a dataframe to Oregon fisheries. Will
automatically detect whether it's working with a Chinook or Coho
dataset if the tables were generated within this package. .data must have
a fishery_id column name.
filter_or(.data, species = NULL)filter_or(.data, species = NULL)
.data |
Dataframe containing |
species |
Optional argument to identify species if |
Other fishery_filters:
filter_ak(),
filter_bc(),
filter_ca(),
filter_coast(),
filter_commercial_wa_nt(),
filter_marine(),
filter_net(),
filter_puget_sound(),
filter_sport(),
filter_wa()
## Not run: fram_dataframe |> filter_or() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_or(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_or(species = "COHO")## Not run: fram_dataframe |> filter_or() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_or(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_or(species = "COHO")
.data must have
a fishery_id column name.Filters a dataframe to Puget Sound fisheries. Will
automatically detect whether it's working with a Chinook or Coho
dataset if the tables were generated within this package. .data must have
a fishery_id column name.
filter_puget_sound(.data, species = NULL)filter_puget_sound(.data, species = NULL)
.data |
Dataframe containing |
species |
Optional argument to identify species if |
Other fishery_filters:
filter_ak(),
filter_bc(),
filter_ca(),
filter_coast(),
filter_commercial_wa_nt(),
filter_marine(),
filter_net(),
filter_or(),
filter_sport(),
filter_wa()
## Not run: fram_dataframe |> filter_puget_sound() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_puget_sound(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_puget_sound(species = "COHO")## Not run: fram_dataframe |> filter_puget_sound() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_puget_sound(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_puget_sound(species = "COHO")
.data must have
a fishery_id column name.Filters a dataframe to sport fisheries. Will
automatically detect whether it's working with a Chinook or Coho
dataset if the tables were generated within this package. .data must have
a fishery_id column name.
filter_sport(.data, species = NULL)filter_sport(.data, species = NULL)
.data |
Dataframe containing |
species |
Optional argument to identify species if |
Other fishery_filters:
filter_ak(),
filter_bc(),
filter_ca(),
filter_coast(),
filter_commercial_wa_nt(),
filter_marine(),
filter_net(),
filter_or(),
filter_puget_sound(),
filter_wa()
## Not run: fram_dataframe |> filter_sport() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_sport(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_sport(species = "COHO")## Not run: fram_dataframe |> filter_sport() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_sport(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_sport(species = "COHO")
.data must have
a fishery_id column name.Filters a dataframe to Washington State fisheries. Will
automatically detect whether it's working with a Chinook or Coho
dataset if the tables were generated within this package. .data must have
a fishery_id column name.
filter_wa(.data, species = NULL)filter_wa(.data, species = NULL)
.data |
Dataframe containing |
species |
Optional argument to identify species if |
Other fishery_filters:
filter_ak(),
filter_bc(),
filter_ca(),
filter_coast(),
filter_commercial_wa_nt(),
filter_marine(),
filter_net(),
filter_or(),
filter_puget_sound(),
filter_sport()
## Not run: fram_dataframe |> filter_wa() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_wa(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_wa(species = "COHO")## Not run: fram_dataframe |> filter_wa() ## End(Not run) framrosetta::fishery_chinook_fram |> filter_wa(species = "CHINOOK") framrosetta::fishery_coho_fram |> filter_wa(species = "COHO")
Finds tables that contain a specific column name
find_tables_by_column_(fram_db, column_name)find_tables_by_column_(fram_db, column_name)
fram_db |
FRAM database object |
column_name |
Name of a column |
## Not run: fram_db |> find_tables_by_column_('RunID')## Not run: fram_db |> find_tables_by_column_('RunID')
Returns a tibble matching the Fishery Mortality screen.
fishery_mortality(fram_db, run_id = NULL, msp = TRUE)fishery_mortality(fram_db, run_id = NULL, msp = TRUE)
fram_db |
FRAM database object |
run_id |
Run ID |
msp |
Use Model Stock Proportion? Logical, defaults to TRUE. |
## Not run: fram_db |> fishery_mortality(run_id = 101) ## End(Not run)## Not run: fram_db |> fishery_mortality(run_id = 101) ## End(Not run)
Cleans the names of FRAM tables and coverts to a tibble
fram_clean_tables(.data)fram_clean_tables(.data)
.data |
Dataframe |
## Not run: fram_dataframe |> fram_clean_tables()## Not run: fram_dataframe |> fram_clean_tables()
Identifies the FRAM database species focus - Chinook or Coho
fram_database_species(con)fram_database_species(con)
con |
Connection to FRAM database |
## Not run: fram_database_species(con)## Not run: fram_database_species(con)
Identifies the FRAM database type - Full or Transfer
fram_database_type(con)fram_database_type(con)
con |
Connection to FRAM database |
## Not run: fram_database_type(con)## Not run: fram_database_type(con)
Gets all fishery_ids of FRAM database
get_fishery_ids(fram_db)get_fishery_ids(fram_db)
fram_db |
Fram database object |
## Not run: fram_dataframe |> get_run_ids()## Not run: fram_dataframe |> get_run_ids()
Gets all run_ids of FRAM database
get_run_ids(fram_db)get_run_ids(fram_db)
fram_db |
Fram database object |
## Not run: fram_dataframe |> get_run_ids()## Not run: fram_dataframe |> get_run_ids()
Gets all stock_id of FRAM database
get_stock_ids(fram_db)get_stock_ids(fram_db)
fram_db |
Fram database object |
## Not run: fram_dataframe |> get_run_ids()## Not run: fram_dataframe |> get_run_ids()
By default, creates suggested folder structure from best coding practices, and
adds WDFW-style yaml and style.css files to give quarto files consistent appearance. If you
belong to another organization and want this function to support your own organization-specific quarto styling,
reach out to the developers with a _quarto.yml and (optionally) style.css file.
initialize_project( folders = c("scripts", "original_data", "cleaned_data", "figures", "results", "results/quarto_output"), quarto = TRUE, organization = c("WDFW"), renv = FALSE, template_overwrite = TRUE, color = "coffee", quiet = TRUE )initialize_project( folders = c("scripts", "original_data", "cleaned_data", "figures", "results", "results/quarto_output"), quarto = TRUE, organization = c("WDFW"), renv = FALSE, template_overwrite = TRUE, color = "coffee", quiet = TRUE )
folders |
Vector of folders to create |
quarto |
Boolean. If TRUE, add quarto yaml file and style.css |
organization |
Character, defaults to "WDFW". Specifies the set of quarto templates to use. Currently only supports "WDFW". |
renv |
Boolean to initialize renv. Defaults to FALSE. |
template_overwrite |
Boolean. Overwrite _quarto.yml and style.css files if they already exist? Defaults to TRUE |
color |
Character string, defaults to "coffee". Specifies quarto template to use; organizations may have several. |
quiet |
Boolean, defaults to FALSE. If TRUE, suppresses informational messages. |
Dev note: new template files for additional organizations should be added to inst/
in a subfolder matching an R-friendly organization name,
and the same name should be added to the organization parameter description here and the supported_organizations
in fetch_quarto_templates().
## Not run: framrsquared::initialize_project() ## End(Not run)## Not run: framrsquared::initialize_project() ## End(Not run)
Generates an input summary based on a FisheryScalers dataframe. Probably end up streamlining / revising this.
input_summary_(.data, run_id)input_summary_(.data, run_id)
.data |
FisheryFishery scalers dataframe |
run_id |
Run ID number |
## Not run: fishery_scalers_dataframe |> input_summary()## Not run: fishery_scalers_dataframe |> input_summary()
Like label_fisheries(), but uses an active FRAM database to label fisheries, rather than
the look-up table present in the framrosetta package. Primarily used in fetch_table(),
useful if working with databases with unusual stock or fishery tables.
label_fisheries_db(.data, fram_db)label_fisheries_db(.data, fram_db)
.data |
Dataframe containing 'fishery_id' column (or analogous column with different name specied by 'fisheries_col' argument) |
fram_db |
FRAM database connection |
.data with additional column, $fishery_label
label_fisheries(), label_stocks_db()
Adds a column with a text version of flags for either non-retention or fishery scalers
label_flags(.data, species = NULL, warn = TRUE)label_flags(.data, species = NULL, warn = TRUE)
.data |
fetched FisheryScalers or NonRetentions |
species |
Optional, identifying species if |
warn |
Logical, defaults to TRUE. Warn if neither flag column is present in dataframe? |
## Not run: mortality_table |> add_flag_text()## Not run: mortality_table |> add_flag_text()
Like label_stocks(), but uses an active FRAM database to label stocks, rather than
the look-up table present in the framrosetta package. Primarily used in fetch_table(),
useful if working with databases with unusual stock or fishery tables.
label_stocks_db(.data, fram_db)label_stocks_db(.data, fram_db)
.data |
Dataframe containing 'stock_id' column (or analogous column with different name specied by 'stocks_col' argument) |
fram_db |
FRAM database connection |
.data with additional column, $stock_label
label_stocks(), label_fisheries_db()
Provides information in the terminal, including the number of existing FRAM database connections created in this R session using framrsquared, as well as the files those connections connect to. Note that there may be multiple connections to the same file.
list_extant_fram_connections()list_extant_fram_connections()
Make multiple copies of a FRAM run, make copies of specified TAMM in
target_folder with run_id suffixes matching newly created runs.
Intended to streamline using the multi-run fork of FRAM.
Primarily for use internally, in the sensitivity analysis functions
make_batch_runs( fram_db, target_run, tamm_name, target_folder, times = 1, label = "copy", force_many_runs = FALSE, verbose = TRUE )make_batch_runs( fram_db, target_run, tamm_name, target_folder, times = 1, label = "copy", force_many_runs = FALSE, verbose = TRUE )
fram_db |
Fram database connection |
target_run |
Run id of target run |
tamm_name |
Filepath/name of tamm to copy |
target_folder |
Location TAMMs should be saved |
times |
number of run copies to make. Numeric, defaults to 1. |
label |
Title suffix for newly created runs. Character, defaults to 'copy'. An index number is added after this suffix to distinguish copied runs. |
force_many_runs |
Ignore limits on number of runs in fram database? Logical, defaults to FALSE. |
verbose |
Print details to console? Logical, defaults to TRUE. |
sensitivity_exact(), sensitivity_scaled(), sensitivity_custom()
Vectorized approach to calculating the management week, returns an integer
management_week(date)management_week(date)
date |
A column with dates |
## Not run: data_fram |> mutate(mngmt_week = management_week(date_field)) ## End(Not run)## Not run: data_fram |> mutate(mngmt_week = management_week(date_field)) ## End(Not run)
Uses a special match/replace dataframe to modify values in a FRAM table.
modify_table(fram_db, table_name, df)modify_table(fram_db, table_name, df)
fram_db |
FRAM database |
table_name |
Name of FRAM table |
df |
The match/replace dataframe or tibble with specially named columns. Columns must start with either "match_" or "replace_", and should otherwise match the names of columns in |
At a high level, modifying a FRAM table requires identify which rows to change, and then replacing the values of one or more of the columns of those row with new values. We often want to make multiple changes at once, and modify_table is written around using a dataframe to define the matching and replacing, so that it is relatively easy to check all of the changes being made. This dataframe (hereafter the "match/replace dataframe") should have column names starting with "match_" and "replace_", and ending with the exact match of column names in the FRAM table identified with argument table_name. For each row of argument df, modify_table() will use columns starting with "match_" as conditions to identify rows in the FRAM database to modify, and then for those rows will replace the values of columns identified with "replace_" with the corresponding values in the df columns.
As a simple example, imagine we want to see how modifying the size limits for Area 7 Sport (chinook fishery id 36) affect our ERs. We would probably start by using copy_run to create multiple duplicate runs, and then we can use modify_table to change just the MinimumSize values of the "SizeLimits" table for just those rows for which fishery id was 36. If our run ids were 100, 101, and 102, and we wanted to look at minimum sizes of 450, 550, and 650, our df argument might look like data.frame(match_RunID = c(100, 101, 102), match_FisheryID = c(36, 36, 36), replace_MinimumSize = c(450, 550, 650)). Notably, we might create df programmatically to combine different run ids with multiple changes at once or to apply some kind of randomized parameter sampling scheme. Or we could even use an excel sheet to write out the experiment in a df format and then read in the sheet and feed it into modify_table.
## Not run: df_total <- tibble(match_Age = c(3, 4, 5)) df_total$match_StockID <- 100 df_total$match_RunID <- 396 df_total$replace_RecruitScaleFactor <- 1:3 df_total$replace_RecruitCohortSize <- 100:102 fram_db |> modify_db(table_name = "StockRecruit", df = df_total) ## End(Not run)## Not run: df_total <- tibble(match_Age = c(3, 4, 5)) df_total$match_StockID <- 100 df_total$match_RunID <- 396 df_total$replace_RecruitScaleFactor <- 1:3 df_total$replace_RecruitCohortSize <- 100:102 fram_db |> modify_db(table_name = "StockRecruit", df = df_total) ## End(Not run)
Supports guestimating the impact of making changes to a fishery on a particular stock (or group of stocks)
by multiplying its mortalities by the stock_mortality_ratio produced by mortality_scalers().
mortality_scalers(fram_db, run_id, stock_id, msp = FALSE)mortality_scalers(fram_db, run_id, stock_id, msp = FALSE)
fram_db |
FRAM database object |
run_id |
Run ID |
stock_id |
A focal stock or stocks |
msp |
Do we use MSP expansion? Logical, defaults to FALSE. Only relevant for Chinook |
plot_impacts_per_catch_heatmap()
## Not run: fram_db |> mortality_scalers(run_id = 101, stock_id = c(17:18))## Not run: fram_db |> mortality_scalers(run_id = 101, stock_id = c(17:18))
Produces the MSF screen report numbers for encounters. Returns different format depending database.
msf_encounters(fram_db, run_id = NULL)msf_encounters(fram_db, run_id = NULL)
fram_db |
FRAM database object |
run_id |
Run ID |
msf_mortalities(), msf_landed_catch()
## Not run: fram_db |> msf_encounters(run_id = 101)## Not run: fram_db |> msf_encounters(run_id = 101)
Returns a tibble matching the MSF screen report encounters for Chinook.
This is specific for Chinook and in most cases msf_encounters() is preferable.
msf_encounters_chinook_(fram_db)msf_encounters_chinook_(fram_db)
fram_db |
FRAM database object |
msf_encounters(), msf_mortalities_chinook_(), msf_landed_catch_chinook_()
## Not run: fram_db |> msf_encounters_chinook_(run_id = 101)## Not run: fram_db |> msf_encounters_chinook_(run_id = 101)
Returns a tibble matching the MSF screen report encounters for Coho This is specific for Coho and in most cases msf_encounters() is preferable.
msf_encounters_coho_(fram_db)msf_encounters_coho_(fram_db)
fram_db |
FRAM database object |
msf_encounters(), msf_landed_catch_coho_(), msf_mortalities_coho_()
## Not run: fram_db |> msf_encounters_coho_()## Not run: fram_db |> msf_encounters_coho_()
Produces the MSF screen report numbers for landed catch. Returns different format depending database.
msf_landed_catch(fram_db, run_id = NULL)msf_landed_catch(fram_db, run_id = NULL)
fram_db |
FRAM database object |
run_id |
Run ID |
msf_encounters(), msf_mortalities()
## Not run: fram_db |> msf_landed_catch(run_id = 101)## Not run: fram_db |> msf_landed_catch(run_id = 101)
Returns a tibble matching the MSF screen report landed catch for Chinook.
This is specific for Chinook and in most cases msf_landed_catch() is preferable.
msf_landed_catch_chinook_(fram_db)msf_landed_catch_chinook_(fram_db)
fram_db |
FRAM database object |
msf_landed_catch(), msf_mortalities_chinook_(), msf_encounters_chinook_()
## Not run: fram_db |> msf_landed_catch_chinook_(run_id = 101)## Not run: fram_db |> msf_landed_catch_chinook_(run_id = 101)
Returns a tibble matching the MSF screen report landed catch for Coho This is specific for Coho and in most cases msf_landed_catch() is preferable.
msf_landed_catch_coho_(fram_db)msf_landed_catch_coho_(fram_db)
fram_db |
FRAM database object |
msf_landed_catch(), msf_encounters_coho_(), msf_mortalities_coho_()
## Not run: fram_db |> msf_landed_catch_coho_()## Not run: fram_db |> msf_landed_catch_coho_()
Produces the MSF screen report numbers for mortalities. Returns different format depending database.
msf_mortalities(fram_db, run_id = NULL)msf_mortalities(fram_db, run_id = NULL)
fram_db |
FRAM database object |
run_id |
Run ID |
msf_encounters(), msf_landed_catch()
## Not run: fram_db |> msf_mortalities_coho_(run_id = 101)## Not run: fram_db |> msf_mortalities_coho_(run_id = 101)
Returns a tibble matching the MSF screen report mortalities for Chinook. This is
specific for Chinook and in most cases msf_mortalities() is preferable.
msf_mortalities_chinook_(fram_db)msf_mortalities_chinook_(fram_db)
fram_db |
FRAM database object |
msf_mortalities(), msf_encounters_chinook_(), msf_landed_catch_chinook_()
## Not run: fram_db |> msf_mortalities_chinook_(run_id = 101)## Not run: fram_db |> msf_mortalities_chinook_(run_id = 101)
Returns a tibble matching the MSF screen report mortalities for Coho. This is
specific for Coho and in most cases msf_mortalities() is preferable.
msf_mortalities_coho_(fram_db)msf_mortalities_coho_(fram_db)
fram_db |
FRAM database object |
msf_mortalities(), msf_encounters_coho_(), msf_landed_catch_coho_()
## Not run: fram_db |> msf_mortalities_coho_()## Not run: fram_db |> msf_mortalities_coho_()
See https://framverse.github.io/fram_doc/calcs_data_chin.html#46_Model-Stock_Proportion.
msp_mortality(fram_db, run_id = NULL)msp_mortality(fram_db, run_id = NULL)
fram_db |
FRAM database object |
run_id |
One or more run ids (optional) |
Mortality table with mortality values expanded by msp
## Not run: fram_db |> msp_mortality(run_id = 132) ## End(Not run)## Not run: fram_db |> msp_mortality(run_id = 132) ## End(Not run)
Provides English translation of numeric non-retention flags
NR_flag_translate(vec)NR_flag_translate(vec)
vec |
vector of flags |
## Not run: NR_flag_translate(sample(1:4, 10, replace = T))## Not run: NR_flag_translate(sample(1:4, 10, replace = T))
Identify how much reduction in landed catch at each fishery that would be needed to reduce the impacts on a focal stock by 1 fish.
plot_impacts_per_catch_heatmap( fram_db, run_id, stock_id, filters_list = list(filter_wa, filter_sport), msp = TRUE )plot_impacts_per_catch_heatmap( fram_db, run_id, stock_id, filters_list = list(filter_wa, filter_sport), msp = TRUE )
fram_db |
fram database connection |
run_id |
run_id of interest |
stock_id |
stock_id of interest |
filters_list |
list of framrsquared filter functions to apply before plotting. Defaults to |
msp |
Use Model Stock Proportion? Logical, defaults to TRUE. |
ggplot object
## Not run: path = "FRAM compilations - readonly/2024-Pre-Season-Chinook-DB/2024 Pre-Season Chinook DB.mdb" run_id = 132 stock_id = 3 plot_impacts_per_catch_heatmap(path, run_id = 132, stock_id = 5) ## End(Not run)## Not run: path = "FRAM compilations - readonly/2024-Pre-Season-Chinook-DB/2024 Pre-Season Chinook DB.mdb" run_id = 132 stock_id = 3 plot_impacts_per_catch_heatmap(path, run_id = 132, stock_id = 5) ## End(Not run)
Produces a stock composition chart, low frequency stocks are grouped into geographic area.
plot_stock_comp(fram_db, run_id, fishery_id, time_step, group_threshold = 0.01)plot_stock_comp(fram_db, run_id, fishery_id, time_step, group_threshold = 0.01)
fram_db |
Fram database object |
run_id |
numeric, RunID |
fishery_id |
numeric, Fishery ID |
time_step |
numeric, Time Step |
group_threshold |
numeric, Stock percentages below this number will be grouped. Default is 1%, setting to zero will turn grouping off |
## Not run: fram_db |> stock_comp(run_id = 132) ## End(Not run)## Not run: fram_db |> stock_comp(run_id = 132) ## End(Not run)
Creates an ordered bar chart with the top number of mortalities per fishery.
plot_stock_mortality( fram_db, run_id, stock_id, top_n = 10, filters_list = NULL, msp = TRUE )plot_stock_mortality( fram_db, run_id, stock_id, top_n = 10, filters_list = NULL, msp = TRUE )
fram_db |
fram database object, supplied through connect_fram_db |
run_id |
numeric, RunID |
stock_id |
numeric, ID of focal stock |
top_n |
numeric, Number of fisheries to display |
filters_list |
list of framrsquared filter functions to apply before plotting. |
msp |
Use Model Stock Proportion? Logical, defaults to TRUE. |
plot_impacts_per_catch_heatmap(), plot_stock_mortality_time_step()
## Not run: fram_db |> plot_stock_mortality(run_id = 132, stock_id = 17) fram_db |> plot_stock_mortality(run_id = 132, stock_id = 17, filters_list = list(filter_wa, filter_sport)) ## End(Not run)## Not run: fram_db |> plot_stock_mortality(run_id = 132, stock_id = 17) fram_db |> plot_stock_mortality(run_id = 132, stock_id = 17, filters_list = list(filter_wa, filter_sport)) ## End(Not run)
Creates an ordered bar chart with the top number of mortalities per fishery and time step.
plot_stock_mortality_time_step( fram_db, run_id, stock_id, top_n = 10, filters_list = NULL, msp = TRUE )plot_stock_mortality_time_step( fram_db, run_id, stock_id, top_n = 10, filters_list = NULL, msp = TRUE )
fram_db |
fram database object, supplied through connect_fram_db |
run_id |
numeric, RunID |
stock_id |
numeric, ID of focal stock |
top_n |
numeric, Number of fisheries to display |
filters_list |
list of framrsquared filter functions to apply before plotting. |
msp |
Use Model Stock Proportion? Logical, defaults to TRUE. |
plot_stock_mortality(), plot_impacts_per_catch_heatmap()
## Not run: fram_db |> stock_mortality_time_step(run_id = 132, stock_id = 17) ## End(Not run)## Not run: fram_db |> stock_mortality_time_step(run_id = 132, stock_id = 17) ## End(Not run)
Returns a tibble matching the Population Statistics screen.
population_statistics(fram_db, run_id = NULL)population_statistics(fram_db, run_id = NULL)
fram_db |
FRAM database object |
run_id |
Run ID |
## Not run: fram_db |> population_statistics(run_id = 101)## Not run: fram_db |> population_statistics(run_id = 101)
Generates post-season January age 3 abundances by stock from post-season databases. Used for forecasting.
post_season_abundance(fram_db, units = c("ja3", "oa3"), run_ids = NULL)post_season_abundance(fram_db, units = c("ja3", "oa3"), run_ids = NULL)
fram_db |
FRAM database object |
units |
Default January Age 3 'ja3', optional ocean age 3 'oa3' |
run_ids |
Numeric vector of run_ids to use, necessary when there are multiple runs with the same run_year in the database. Optional, defaults to NULL. |
## Not run: framdb |> post_season_abundance()## Not run: framdb |> post_season_abundance()
Provides list of FRAm database names, typically useful for internal functions.
provide_table_names(is_full = TRUE)provide_table_names(is_full = TRUE)
is_full |
Logical. Provide names for a full FRAM database (TRUE) or a model transfer (FALSE)? |
Character string of the names of FRAM tables
provide_table_names(is_full = FALSE)provide_table_names(is_full = FALSE)
Removes a run in a FRAM database
remove_run(fram_db, run_id)remove_run(fram_db, run_id)
fram_db |
FRAM database object |
run_id |
FRAM run ID or IDs to be deleted |
## Not run: fram_db |> delete_run(run_id = 132)## Not run: fram_db |> delete_run(run_id = 132)
Provides a print out of Run ID information
run_info(fram_db, run_id)run_info(fram_db, run_id)
fram_db |
FRAM database object |
run_id |
FRAM run ID |
## Not run: fram_db |> run_info(run_id = 132)## Not run: fram_db |> run_info(run_id = 132)
Provides English translation of numeric scalers flags
scalers_flag_translate(vec)scalers_flag_translate(vec)
vec |
vector of flags |
## Not run: scalers_flag_translate(sample(c(1, 2, 7, 8, 17, 18, 27, 28), 10, replace = T))## Not run: scalers_flag_translate(sample(c(1, 2, 7, 8, 17, 18, 27, 28), 10, replace = T))
For complex sensitivity analyses, it may be easiest to programmatically create a series of
match/replace dataframes (?modify_table), one for each sensitivity run. sensitivity_custom() uses a list of
these dataframes to create a series of sensitivity analyses runs. Otherwise behaves as sensitivity_exact() or sensitivity_scaled(). Saved log is a .rds file that contains scenario_list but with each list item named with the matching RunID.
sensitivity_custom( fram_db, template_run, table_name, scenario_list, tamm_template = NULL, tamm_target_folder = NULL, label = "sensitivity", save_log = TRUE )sensitivity_custom( fram_db, template_run, table_name, scenario_list, tamm_template = NULL, tamm_target_folder = NULL, label = "sensitivity", save_log = TRUE )
fram_db |
Fram database |
template_run |
Run ID of the run that should be used as a template for the sensitivity analyses. |
table_name |
Name of FRAM table that will be modified for the sensitivity analyses. For list items that are named, be ignored in favor of item name. |
scenario_list |
List of match/replace dataframes as described in documentation of |
tamm_template |
Optional; character string of filepath of a TAMM to be used as a template. If provided (and tamm_target_folder provided), |
tamm_target_folder |
Folder to copy TAMMs into. Will create if it does not exist. |
label |
Label added to each of the generated run names to identify this sequence of sensitivity analyses. String, defaults to "sensitivity" |
save_log |
Should a log .csv of the specifics used (row ids, match criterion, scaling or replacement values) be saved in the same folder as the FRAM database? Logical, defaults to TRUE. |
Current framework does not support automating creation of sensitivity analyses in which changes are being made to multiple tables for a single run.
Invisibly returns object scenario_list, but with list items named with the corresponding RunID.
sensitivity_scaled(), sensitivity_exact()
## Not run: ## silly quick-and-dirty example: try these ## two scenarios: mark release rates of 0.05 and 0.01 for fisheries 1 and 2 ## for timestep 1, or flipping those. Modifications to FisheryScalers table fram_db <- connect_fram_db(here("Valid2024_sens_test.mdb")) custom_scenarios = list(data.frame(match_FisheryID = c(1, 2), match_TimeStep = c(1, 1), replace_MarkReleaseRate = c(.05, .01)), data.frame(match_FisheryID = c(1, 2), match_TimeStep = c(1, 1), replace_MarkReleaseRate = c(.01, .05)) ) tamm_template = here("Coho2513NOF-165.xlsx") tamm_target_folder = here("sens_test_custom/") fram_db |> sensitivity_custom(template_run = 28, table_name = 'FisheryScalers', scenario_list = custom_scenarios, tamm_template = tamm_template, tamm_target_folder = tamm_target_folder, label = "markrelease custom") disconnect_fram_db(fram_db) ## End(Not run)## Not run: ## silly quick-and-dirty example: try these ## two scenarios: mark release rates of 0.05 and 0.01 for fisheries 1 and 2 ## for timestep 1, or flipping those. Modifications to FisheryScalers table fram_db <- connect_fram_db(here("Valid2024_sens_test.mdb")) custom_scenarios = list(data.frame(match_FisheryID = c(1, 2), match_TimeStep = c(1, 1), replace_MarkReleaseRate = c(.05, .01)), data.frame(match_FisheryID = c(1, 2), match_TimeStep = c(1, 1), replace_MarkReleaseRate = c(.01, .05)) ) tamm_template = here("Coho2513NOF-165.xlsx") tamm_target_folder = here("sens_test_custom/") fram_db |> sensitivity_custom(template_run = 28, table_name = 'FisheryScalers', scenario_list = custom_scenarios, tamm_template = tamm_template, tamm_target_folder = tamm_target_folder, label = "markrelease custom") disconnect_fram_db(fram_db) ## End(Not run)
As sensitivity_scaled, but provide exact values for the sensitivity analyses (in argument exact_values) instead of
scaling factors.
sensitivity_exact( fram_db, template_run, table_name, match_df, exact_values, cols_to_vary, tamm_template = NULL, tamm_target_folder = NULL, label = "sensitivity", save_log = TRUE )sensitivity_exact( fram_db, template_run, table_name, match_df, exact_values, cols_to_vary, tamm_template = NULL, tamm_target_folder = NULL, label = "sensitivity", save_log = TRUE )
fram_db |
Fram database |
template_run |
Run ID of the run that should be used as a template for the sensitivity analyses. |
table_name |
Name of FRAM table that will be modified for the sensitivity analyses |
match_df |
dataframe that defines which rows should be modified during sensitivity analyses. To modify some values for marked and unmarked Stillaguamish stocks, we would use data.frame(StockID = c(17, 18)). To modify values only for Stillaguamish age 2s, we would use expand_grid(StockID = c(17, 19), Age = 2). Unlike match/replace dataframes for |
exact_values |
numeric vector of values to exact values to use for sensitivity analyses. |
cols_to_vary |
Character or character vector of column names of FRAM table |
tamm_template |
Optional; character string of filepath of a TAMM to be used as a template. If provided (and tamm_target_folder provided), |
tamm_target_folder |
Folder to copy TAMMs into. Will create if it does not exist. |
label |
Label added to each of the generated run names to identify this sequence of sensitivity analyses. String, defaults to "sensitivity" |
save_log |
Should a log .csv of the specifics used (row ids, match criterion, scaling or replacement values) be saved in the same folder as the FRAM database? Logical, defaults to TRUE. |
Invisibly returns a list of dataframes.
$values_by_run contains a row for each sensitivity run and maps the values used to run ids.
$full_df is the full match/scale factor used by calc_fram_scaling, and shows the match conditions and scaling used for each run.
If cols_to_vary has length 1, the two dataframes will contain the same information.
## Not run: fram_db <- connect_fram_db(here("Valid2024_sens_test.mdb")) tamm_template <- here("Coho2513NOF-165.xlsx") tamm_target_folder <- here("sens_test_exact/") fram_db |> sensitivity_exact( template_run = 28, table_name = "StockRecruit", match_df = data.frame(match_StockID = 1:2), exact_values = seq(0.5, 5, by = 0.5), cols_to_vary = c("RecruitScaleFactor"), tamm_template = tamm_template, tamm_target_folder = tamm_target_folder, label = "Stilly sensitivity exact" ) disconnect_fram_db(fram_db) ## End(Not run)## Not run: fram_db <- connect_fram_db(here("Valid2024_sens_test.mdb")) tamm_template <- here("Coho2513NOF-165.xlsx") tamm_target_folder <- here("sens_test_exact/") fram_db |> sensitivity_exact( template_run = 28, table_name = "StockRecruit", match_df = data.frame(match_StockID = 1:2), exact_values = seq(0.5, 5, by = 0.5), cols_to_vary = c("RecruitScaleFactor"), tamm_template = tamm_template, tamm_target_folder = tamm_target_folder, label = "Stilly sensitivity exact" ) disconnect_fram_db(fram_db) ## End(Not run)
From a template FRAM run, for a single vector of scaling factors (e.g., c(0.5, 2) would test halving and doubling), generate sensitivity analyses which rescale the columns specied in (cols_to_vary) for rows which match the conditions specified in match_df. Optionally creates corresponding tamms from a template TAMM, labeled to work with folder loading option in the FRAM multi-run fork.
sensitivity_scaled( fram_db, template_run, table_name, match_df, scale_values, cols_to_vary, tamm_template = NULL, tamm_target_folder = NULL, label = "sensitivity", save_log = TRUE )sensitivity_scaled( fram_db, template_run, table_name, match_df, scale_values, cols_to_vary, tamm_template = NULL, tamm_target_folder = NULL, label = "sensitivity", save_log = TRUE )
fram_db |
Fram database |
template_run |
Run ID of the run that should be used as a template for the sensitivity analyses. |
table_name |
Name of FRAM table that will be modified for the sensitivity analyses |
match_df |
dataframe that defines which rows should be modified during sensitivity analyses. To modify some values for marked and unmarked Stillaguamish stocks, we would use data.frame(StockID = c(17, 18)). To modify values only for Stillaguamish age 2s, we would use expand_grid(StockID = c(17, 19), Age = 2). Unlike match/replace dataframes for |
scale_values |
Numeric vector of the scaling factors to be be used, one per sensitivity analysis run. Defines the number of runs generated. For example, |
cols_to_vary |
Character or character vector of column names of FRAM table |
tamm_template |
Optional; character string of filepath of a TAMM to be used as a template. If provided (and tamm_target_folder provided), |
tamm_target_folder |
Folder to copy TAMMs into. Will create if it does not exist. |
label |
Label added to each of the generated run names to identify this sequence of sensitivity analyses. String, defaults to "sensitivity" |
save_log |
Should a log .csv of the specifics used (row ids, match criterion, scaling or replacement values) be saved in the same folder as the FRAM database? Logical, defaults to TRUE. |
Dev note: update to allow match_df to NOT start with "match_" – it's implied.
Invisibly returns a list of dataframes. $scales_by_runs contains a row for each sensitivity run and maps the scaling factors to run ids. $full_df is the full match/scale factor used by calc_fram_scaling, and shows the match conditions and scaling used for each run.
sensitivity_exact(), sensitivity_custom()
## Not run: # Testing sensitivity_scaled library(here) fram_db <- connect_fram_db(here("Valid2024_sens_test.mdb")) tamm_template <- "ChinValidrunTest.xlsx" tamm_target_folder <- here("sens_test/") fram_db |> sensitivity_scaled( template_run = 28, table_name = "StockRecruit", match_df = data.frame(match_StockID = c(17, 19)), scale_values = seq(0.1, 2, length = 10), cols_to_vary = c("RecruitScaleFactor", "RecruitCohortSize"), tamm_template = tamm_template, tamm_target_folder = tamm_target_folder ) disconnect_fram_db(fram_db) ## End(Not run)## Not run: # Testing sensitivity_scaled library(here) fram_db <- connect_fram_db(here("Valid2024_sens_test.mdb")) tamm_template <- "ChinValidrunTest.xlsx" tamm_target_folder <- here("sens_test/") fram_db |> sensitivity_scaled( template_run = 28, table_name = "StockRecruit", match_df = data.frame(match_StockID = c(17, 19)), scale_values = seq(0.1, 2, length = 10), cols_to_vary = c("RecruitScaleFactor", "RecruitCohortSize"), tamm_template = tamm_template, tamm_target_folder = tamm_target_folder ) disconnect_fram_db(fram_db) ## End(Not run)
Statistical weeks start on mondays, so the first statistical week of the year starts on the first monday of the year. (Contrast with management weeks which start on Sundays).
statistical_week(date)statistical_week(date)
date |
A vector of dates |
## Not run: data_fram |> mutate(mngmt_week = statistical_week(date_field)) ## End(Not run)## Not run: data_fram |> mutate(mngmt_week = statistical_week(date_field)) ## End(Not run)
#' Intended for internal use, makes some assumptions about inputs.
stock_age_checker(table_name, NumStk, old_stockcount, df, min_age, max_age)stock_age_checker(table_name, NumStk, old_stockcount, df, min_age, max_age)
table_name |
Character of table name, for informative messages. |
NumStk |
Maximum number of stock, pulled from BaseID table |
old_stockcount |
Number of stock in previous FRAM baseperiod. Only looks for problems for StockID > this number. |
df |
Dataframe to check. Must have columns "stock_id" and "age" (which are the names for relevant columns of framrsquared::fetch_table). |
min_age |
Minimum age modeled. Should be the min_age from the baseid_df. |
max_age |
Maximum age modeled. Should be the max_age from the baseid_df. |
numeri; 0 if no warning, 1 if warning.
More thorough checking than stock_id_comp. Checks that the number of stock IDs makes sense given NumStk,
that Stock IDs are sequential (in the sense that if NumStk = n, every integer up to n is represented).
Optionally, can check that each stock ID is unique.
stock_check_helper(table_name, NumStk, stock_vec, uniques_only = FALSE)stock_check_helper(table_name, NumStk, stock_vec, uniques_only = FALSE)
table_name |
Character of table name, for informative messages. |
NumStk |
Maximum number of stock, pulled from BaseID table |
stock_vec |
vector of stock ids to check. Presumably column of fetched table. |
uniques_only |
Do we want warnings if there are duplicats of StockIDs? Useful for tables like Stock and Growth that should have only one entry per stock. Logical, default = |
Numeric, returning number of warnings detected.
Summarizes the three true outcomes of a stocks abundance, where it
dies to fishery related mortality, natural mortality, or reaches
some sort of escapement. When run against the coho database
spawning escapement will be displayed, when run against the
Chinook database escapement to the river will be dislpayed
along with recruits to the next year 'age_up'
stock_fate(fram_db, run_id = NULL, units = c("fish", "percentage"))stock_fate(fram_db, run_id = NULL, units = c("fish", "percentage"))
fram_db |
FRAM database object |
run_id |
Run ID (optional) |
units |
'fish' or 'percentage'. Percentage is proportion of starting adundance |
## Not run: fram_db |> stock_fate(run_id = 145) ## End(Not run)## Not run: fram_db |> stock_fate(run_id = 145) ## End(Not run)
Chinook flavor of the stock fate function
stock_fate_chinook(fram_db, run_id = NULL, units = c("fish", "percentage"))stock_fate_chinook(fram_db, run_id = NULL, units = c("fish", "percentage"))
fram_db |
FRAM database object |
run_id |
Run ID (optional) |
units |
'fish' or 'percentage'. Percentage is proportion of starting abundance |
## Not run: fram_db |> stock_fate_chinook(run_id = 145) ## End(Not run)## Not run: fram_db |> stock_fate_chinook(run_id = 145) ## End(Not run)
Coho flavor of the stock fate function
stock_fate_coho(fram_db, run_id = NULL, units = c("fish", "percentage"))stock_fate_coho(fram_db, run_id = NULL, units = c("fish", "percentage"))
fram_db |
FRAM database object |
run_id |
Run ID (optional) |
units |
'fish' or 'percentage'. Percentage is proportion of starting adbundace |
## Not run: fram_db |> stock_fate_coho(run_id = 145) ## End(Not run)## Not run: fram_db |> stock_fate_coho(run_id = 145) ## End(Not run)
Intended for internal use, makes some assumptions about inputs.
stock_id_comp(table_name, df, stock_ref)stock_id_comp(table_name, df, stock_ref)
table_name |
Character of table name, for informative messages |
df |
Dataframe |
stock_ref |
numeric vector of all stock IDs. Should be stock_df$stock_id. |
numeric; 0 if no warning, 1 if warning.
Returns a tibble matching the Stock Mortality screen.
stock_mortality(fram_db, run_id = NULL)stock_mortality(fram_db, run_id = NULL)
fram_db |
FRAM database object |
run_id |
Run ID |
## Not run: fram_db |> stock_mortality(run_id=132) |> filter(stock_id == 17, fishery_id == 36) ## End(Not run)## Not run: fram_db |> stock_mortality(run_id=132) |> filter(stock_id == 17, fishery_id == 36) ## End(Not run)
For easy readability, we want to use consistent coding style when developing code for framrsquared.
Presently this includes (a) using <- for assignment, and (b) using snakecase for
variable and function names. The functions here streamlining checking R code for
consistency with this style.
frs_stylecheck_assignment(filepath, n = Inf) frs_stylecheck_snakecase(filepath, n = Inf)frs_stylecheck_assignment(filepath, n = Inf) frs_stylecheck_snakecase(filepath, n = Inf)
filepath |
Path to R file to be checked |
n |
Number of rows to print. Default is to print all rows, but set to smaller values if output is overwhelming. |
frs_stylecheck_assignment() takes the path to an R file, and prints (and returns)
any rows that may be mis-using the = for assignment. Note that it will give false positives
for arguments defined in function calls if the call spans multiple lines, as well as
= signs included in character strings.
frs_stylecheck_snakecase takes the path to an R file
and prints (and returns) the names of any variables assigned using <- that do not include underscores.
This will identify variables that do not use snakecase, but will also give false positive
matches for variables that are single words and thus do not need snakecase.
## Not run: frs_stylecheck_assignment("R/copy.R") frs_stylecheck_snakecase("R/copy.R") ## End(Not run)## Not run: frs_stylecheck_assignment("R/copy.R") frs_stylecheck_snakecase("R/copy.R") ## End(Not run)
For each TAA, lists the associated fisheries
terminal_fisheries(fram_db, species = NULL)terminal_fisheries(fram_db, species = NULL)
fram_db |
Fram database object |
species |
"COHO" or "CHINOOK". Optional, defaults to the database species. Provide this only if fram_db connects to a database with both Chinook and Coho information. And try to avoid that – those databases are sketchy to work with. |
tibble of taa fisheries
## Not run: fram_db |> terminal_fisheries()## Not run: fram_db |> terminal_fisheries()
Terminal run information used by FRAM is stored in the TAAETRSList and (soon) the TAAETRSListChinook tables, but stored in a way that is not very human readable. parse_terminal_info() translates this to human-readable form, primarily to then be used by terminal_stocks() and terminal_fisheries().
terminal_info(fram_db, old_table_name = TRUE, species = NULL)terminal_info(fram_db, old_table_name = TRUE, species = NULL)
fram_db |
Fram database object |
old_table_name |
Logical, defaults to TRUE. We intend to change the FRAM table from TAAETRSList to TAAETRSListChinook to avoid confusion. When working with a database where that hasn't been done, leave this argument to TRUE. |
species |
"COHO" or "CHINOOK". Optional, defaults to the database species. Provide this only if fram_db connects to a database with both Chinook and Coho information. And try to avoid that – those databases are sketchy to work with. |
tibble of TAAETRSList or TAAETRSListChinook tables translated to long form.
terminal_stocks(), terminal_fisheries()
## Not run: fram_db |> parse_terminal_info()## Not run: fram_db |> parse_terminal_info()
For each TAA, lists the associated FRAM stocks and timesteps.
terminal_stocks(fram_db, species = NULL)terminal_stocks(fram_db, species = NULL)
fram_db |
Fram database object |
species |
"COHO" or "CHINOOK". Optional, defaults to the database species. Provide this only if fram_db connects to a database with both Chinook and Coho information. And try to avoid that – those databases are sketchy to work with. |
taa of taa stocks and timesteps
## Not run: fram_db |> terminal_stocks()## Not run: fram_db |> terminal_stocks()
Returns a dataframe with fisheries defined by the TRuns report driver
truns_fisheries(fram_db)truns_fisheries(fram_db)
fram_db |
FRAM database object |
## Not run: truns <- truns_fisheries(fram_db)## Not run: truns <- truns_fisheries(fram_db)
Returns a dataframe with stocks defined by the TRuns report driver
truns_stocks(fram_db)truns_stocks(fram_db)
fram_db |
FRAM database object |
## Not run: truns <- truns_stocks(fram_db)## Not run: truns <- truns_stocks(fram_db)
No error checking for transfer databases
validate_fishery_ids(fram_db, fishery_id, call = rlang::caller_env())validate_fishery_ids(fram_db, fishery_id, call = rlang::caller_env())
fram_db |
FRAM database object |
fishery_id |
one or more fishery_ids |
call |
internal use: identify name of function that called this function (for informative error message) |
Convenience function to check fram_db input
validate_fram_db( fram_db, db_type = NULL, db_species = NULL, call = rlang::caller_env() )validate_fram_db( fram_db, db_type = NULL, db_species = NULL, call = rlang::caller_env() )
fram_db |
FRAM database object |
db_type |
Enforcement of a database type 'full' or 'transfer' |
db_species |
Enforcement of a species 'COHO' or 'CHINOOK' |
call |
internal use: identify name of function that called this function (for informative error message) |
Convenience function to check run_id input
validate_run_id(fram_db, run_id, call = rlang::caller_env())validate_run_id(fram_db, run_id, call = rlang::caller_env())
fram_db |
FRAM database object |
run_id |
one or more run_ids |
call |
internal use: identify name of function that called this function (for informative error message) |
No error checking for transfer databases
validate_stock_ids(fram_db, stock_id, call = rlang::caller_env())validate_stock_ids(fram_db, stock_id, call = rlang::caller_env())
fram_db |
FRAM database object |
stock_id |
one or more stock_ids |
call |
internal use: identify name of function that called this function (for informative error message) |
Welcome message, summarizing database information
welcome(con)welcome(con)
con |
FRAM database connection |
## Not run: welcome(con)## Not run: welcome(con)