EDT FISH POPULATION DATABASES - README David Graves - August 2006 This folder contains databases of registered and unregistered fish populations from the Mobrand Ecosystem Diagnosis and Treatment analyses. Registered populations are the official data describing fish populations that were used in the EDT model during the subbasin planning process (2002/2003). Unregistered populations are considered draft and were not made available to the public during subbasin planning. Registered populations are much more reliable because they are considered accurate reflections of reality. Unregistered populations may include errors or hypothetical scenarios and should be evaluated with caution. They are included here because not all subbasin planners registered the populations that they modeled and therefore some of the unregistered populations may have been used in subbasin planning. These files were created by obtaining source text files from the Mobrand EDT_Archive application for registered populations, and from the Mobrand SQL Server database for unregistered populations, and creating standardized relational databases for this information. The database for registered populations is prefixed with "Reg", and the one for unregistered is prefixed with "UnReg". A set of queries was written at CRITFC and is included with each database to report the data categories of the populations, which include a population description, summary, spawning reaches, adult data, juvenile data, migration data, and smolt migration patterns. Please see the database description below, copied from the documentation from the original Mobrand application for more information about the contents of these files. A module (CreateExcelSheets) is also included in the databases - it was written to loop through each of the populations and output information out it a series of spreadsheets, both for Current and Template scenarios. For the registered populations, Excel spreadsheets were also created and place in the subbasin EDT data folders at StreamNet under Subbasin Planning, if that is easier. ---------------------------------------------------------------------------------------- ** Fish Populations Documentation, from Mobrand EDTArchive Version2 Application ** This fish data is the background assumptions that were used by EDT when a particular population was run. The author (subbasin planners) of the populations supplies the population name, description, and selects weeks of spawning while defining the population. Spawning reaches identify the start location for the trajectories used for the population. The EDT model includes a Trajectory Generator module that generates multiple pathways, referred to as trajectories, through space and time. Each trajectory may vary in the duration, rate of travel, and timing of life stages. The variation in life stage duration and rate of travel among trajectories is determined by parameters in the Migration Pattern table. All trajectories start with spawning and end with prespawn holding in the same reach. The term migration pattern in EDT is used to mean a collection of trajectories with a similar life history behavior. These trajectories share life history behaviors, such as ocean entry timing (e.g., age at ocean entry or seasonal timing) or migration pattern during freshwater residence (e.g., freshwater residence in the natal stream or redistribution to a non-natal stream for "over-wintering"). The author of the population selects the frequency of migration patterns of a population and the adult and juvenile age assumptions that applies to each pattern. All of these choices can be reviewed for a population by going to the EDT Online web page (http://www.mobrand.com/edt/) to the Fish Population Main menu and selecting View an Existing Population. The online view does not provide a view of the underlying assumptions for life history patterns and ages. These spreadsheets are intended to provide users a view of these underlying assumptions as well as the information contained in the online view of a population. Population Summary: The Population Summary succinctly identifies what proportion of the trajectories use previously defined age specific patterns that are used in the model. For example a population may consist of two components. One is a transient type that makes up 10% of the population. 90% is made up of a spring migrant type. Both components also follow the same kind of adult and juvenile specific patterns. Each of these patterns are presented in more detail below the Summary. Juvenile Detail: A juvenile age pattern determines the trajectory age composition of smolts for a population. This is only relevant to steelhead populations that include smolt that migrate at multiple ages. The user is required to select a juvenile age pattern for Chinook and Coho but the pattern does not include migration at multiple ages. A composition of stream type (migrate a yearling smolts) and ocean type (migrate as subyearling smolts) juvenile ages for a population is determined by the frequency of life history patterns entered for a population. Steelhead juvenile patterns includes information on the % of trajectories migrating at a particular age - Proportion Smolt. Juvenile age is the number of winters in freshwater. Early Marine Survival Adj is an adjustment to the early marine survival benchmark specific to a juvenile age. This is only applicable to steelhead juvenile age patterns. Chinook and Coho values are always 1.0. The model allows differences between the current and template scenarios in early marine survival. Adult Details: An adult age pattern determines the trajectory age composition of adults for a population. Adult age is the number of winters at sea. Fall Chinook are typically modeled as spending between 0 to 5 years in the ocean. The Ocean Age Prop identifies what percent of the trajectories will return after the number of winters at sea. This does not include the last winter for steelhead that may be entering freshwater in December - February to spawn in spring. The adult age pattern also includes information on the fecundity by age (Fecundity), the percent of females spawning at that age (SpawnFemales), and the average eggs per spawner by age (Eggs). Average eggs per spawner are calculated by taking the percent females multiplied by the fecundity. The overall eggs per spawner across all ages is calculated in the EDT model based on the percent age composition and the average eggs at each age. Finally, the adult age pattern table includes adjustments to the marine survival benchmarks in the marine reaches (Survival Adj). The EDT model has a single benchmark survival of 0.9 for all life stages that spend the entire year in the ocean. This benchmark is adjusted to standard age specific marine survival assumptions for Chinook, Coho, and steelhead. For example, ocean age 2 Chinook survival would be 0.778 x 0.9 x 0.70. An unfortunate twist in the survival benchmark adjustment is that the benchmarks for ocean and stream type Chinook are shared in EDT. Age 1 transient rearing is the early marine (ocean entry to December 31) life stage for stream type Chinook whereas for ocean type Chinook this life stage is the first full year in saltwater. The life stage benchmark is 0.285 in EDT. Therefore, the survival adjustment for ocean type Chinook for ocean age 1 is 2.1224 x 0.285 which equals 0.6. The survival adjustment for ocean age 0 allows adjustments to the overall marine survival to account for differences in marine survival regimes resulting form such events as PDO cycles. Migration Pattern Detail: A migration pattern determines the life stages, duration and migration rates for a trajectory. Specifically: Life stage sequence along a trajectory (Life Stage), The pattern record type (Type) - which will be explained in more detail below, The migration direction of the life stage (Dir) indicates if the life stage is moving away for the spawning reach (1) or towards the spawning reach (-1), The window reach (Reach - meters for river mouth) if applicable indicates that the life stage must be at a particular location at a particular time, The end window for a life stage (LS End) indicates a window for the end of the life stage in statistical weeks, The life stage duration range (LS Dur) indicates a range for the life stage duration in weeks, The migration rate for a life stage (LS Rate) indicates the migration rate for the life stage in km per week. The trajectory generator randomly (uniform distribution) selects a value for LS End, LS Dur, and LS Rate. Thus, no two trajectories are exactly alike. Pattern record type is used by the trajectory generator module to determine what rules to use for the life stage. Pattern types are described below: Pattern Type 1: Life stage duration is defined by a minimum and a maximum of possible duration (weeks). The trajectory generator randomly selects the life stage duration within the window. Pattern Type 2: Life stage duration is defined by the end week of previous life stage and the ending window for the current life stage (statistical week). The trajectory generator randomly selects the life stage end week within the window. Pattern Type 3: Life stage duration is defined by a minimum and a maximum of duration (weeks). Life stage movement is defined by a reach location (meters). Trajectory speed is calculated based on life stage duration and distance to the reach location. The trajectory generator randomly selects the life stage duration within the window. Pattern Type 4: Life stage duration is defined by the end week of previous life stage and the ending window for the current life stage (statistical weeks). Life stage movement is defined by a reach location (meters). Trajectory speed is calculated based on life stage duration (calculated time from life stage start to end week) and distance to the reach location. The trajectory generator randomly selects the life stage end week within the window. Pattern Type 5: Life stage duration and migration rates for smolt life stages, including 0 age ocean type Chinook, are based on a smolt migration model defined by Zabel, Anderson, and Shaw (CJFAS 55: 658-667; 1998) for Columbia River Chinook. This model is used from the beginning of the smolt life stage to the top of the estuary reach. Zabel and Shaw thought the model was generic enough to be applied to species other than Snake River Chinook (and presumably in basins other than the Columbia River). Parameters used by this model are described in the Smolt Migration Parameter table. **********************************************************************************