Open4st Family, Clone and Database Naming Conventions
Patrick N McGovern 2018
Family Naming Scheme (pre-2011)
Family names are delimited by alpha-numeric characters that denote the Family ID, an "x" which denotes "cross", the Taxa abbreviations and the year the cross was made (now deprecated). A sample family name is: 1xGAA91 with the following syntax: [Family number]x[parent taxa][year of cross]. The parent letters are general taxa description of the cross. The family, “gaa” might indicate ga x a with the specific details in the online r4st database. See "Using and Accessing the r4st Database". Several pre-2004 crosses denoted ploidy by including the ploidy number of the non-diploid parent between the taxa letters (eg. 1xT4E04) This convention is deprecated in favor of not including the expected ploidy in the name.
Family Naming Scheme - Post 2011
Newer family names do not include the year the cross was made for conciseness. Most new hybrid parent names use a single character to describe them (e.g. R instead of AG and B instead of CAG). A sample family name is: 2xb with the following syntax: [Family ID number]x[parent taxa] which has the taxa parents P. canescens x (P. alba x P. grandidentata).
Open4st Clone Naming Scheme
Internal (Open4st) syntax: [Family ID number][Family Taxa][Clone ID] (e.g. 41aa102, 2b25, )
External cooperator Clone syntax: [Family ID number][Family Taxa][Clone ID][CooperatorSite] (e.g. 15AG4MF)
T = tremulodies
E = tremula
A = alba
C = canescens (P. alba x P. tremula)
G = grandidentata
R = alba x P. grandidentata (P. x rouleauiana Boivin)
S = P. grandidentata x P. tremuloides P. x smithii Boivin (smithii)
B = CAG - ((A x E) x (A x G))
W = The male is wind or open pollinated
Plant table, "alba_class" column:
In 2018 eight high level "hybrid name" classifications were developed to categorize alba/aspen materials from a higher level P. alba family
percentage context. Below is a listing of these classes which are are associated to each clone in the Plant table in the "alba_class" column. It was not added to the Taxa table to ease manual data updates and improve accuracy, since there are many taxa and male/female reciprocal combinations. Note that the Family and Plant tables have foreign key relationships to the Taxa table. Below are the "alba_class" data descriptions:
'A' = Alba, 100% P. alba'
'H' = Hybrid, with 50% P. alba'
'AH' = 'Alba Hybrid, with > 50% P. alba
'ASH' = 'Aspen Hybrid, with < 50% P. alba'
'ASA' = 'Aspen American, native American aspen
'ASO' = 'Aspen Other, with 0% P. alba, (eg, P. tremula)
'C' = 'Control, with 0% P. alba
'U' = Unknown
Test_Detail table, "planted_order"column:
Records in the test_detail table are typically ordered by the test_detail_key (variety) for easier selection processing. The "planted_order" column simply contains the original planted order of the materials to verify records over time.
Test_Detail table, "selection_type"column:
Nursery testing involves the selection, promotion, demotion and removal of materials over time. The Test Detail table contains the "selection_type" column to track selections in a given year. These values are typically associated with ranked data to assist with selection decisions. Below are the definitions for each selection type:
'P' = Primary, an elite high priority selection
'S' = Secondary, a medium priority selection
'T' = Tertiary, a tertiary or parent selection
'F' = Family, a family population worthy of retesting
'R' = Retest, a clone worthy of retesting.
'D' = Discard
'U' = Unknown
Test_Detail table, "stock_type" column:
Nursery stock types typically describe the size, age and stage of nursery grown trees. The Test Detail table contains the "stock_type" column to track the stock types in a given year. These values are typically associated with ranked data to assist with selection decisions. Below are the definitions for each stock type:
'ASP' = Active Shoot Propagation, non-lignified greenwood shoots with actively growing meristematic tips.
'SASP' = Seedling Active Shoots, seedling shoot tips grown via ASP process.
'WASP' = Winter Active Shoots, 3"-4" dormant cuttings propagated under humid greenhouse ASP conditions.
'DC' = Dormant hardwood Cuttings
'ODC' = Ortet Dormant Cuttings, first year ortet whips representing a clone and made into dormant hardwood cuttings.
'FDC' = Family Dormant Cuttings, one lower 8" dormant cutting planted per ortet and retaining only the family name.
'MS' = Ministool, typically a 1-0 stock plant with roots cut to 1", stem to 3" and total length 10" to 12" long.
'RTL' = RootLings, typically 3 mm thick by 55 mm long juvenile roots propagated distal end up via ASP process.
'SEL' = SEedLings, typically aspen seedlings.
'RS' = Root Shoots, typically succulent aspen shoots sprouting from horizontally grown dormant aspen root sections.
'1-0' = 1-0 stock grown one year in a nursery and lifted in the Spring or Fall.
'1-1' = 1-1 stock grown one year in a nursery, lifted and replanted another year, then lifted in the Spring or Fall.
'U' = Unknown, typically reserved for the first 3 database "dummy" records.
Test_Detail table, "leaf_score" column:
Updated in 2017. Based on an intuitive grading score where a low score is bad and highest is best. The 5 point system uses 3 as a true middle metric and allows room for 5 to represent a "perfect" plus score. The -1 is the default r4st value for "Not Scored". This system can be adapted for scoring other attributes.
-1 = Not scored.
1= Over 50% of crown affected by leaf issues, major defoliation,
2= About 25% of crown affected by leaf issues and defoliation.
3= Leaves moderately affected with minor defoliation,
4= A few leaf issues, no defoliation,
5= No leaf issues.
Signicant va1_master_test_detail view columns:
This view contains all McGovern nursery data based on the test_detail table with additional averaged detail columns listed below. These column terms are repeated in many test_detail nursery views. Results can vary annually per variety as different mix of stock types may be used.
collar_median_dia_mm: Each replicated nursery variety was measured for its median collar diameter in millimeters from dormant rooted cuttings stock types.
stool_collar_median_dia_mm: Each replicated nursery variety was measured for its median collar diameter in millimeters from rooted mini-stool stock types.
field_cuttings_ft: The number of field grade 12" cuttings with the smallest end diameter > 10mm in a given replicated nursery variety.
survival_rate: The replicated nursery variety survival rate with the formula: (end_quantity / start_quantity).
vigor_survival: Typically intended for dormant cutting stock types (DC). The survival rate multiplied by the related median cutting collar diameter with the formula: (end_quantity / start_quantity) * collar_median_dia_mm.
stool_vigor_survival: Typically intended for rooted mini-stool stock types (MS). The survival rate multiplied by the related median mini-stool collar diameter with the formula: (end_quantity / start_quantity) * collar_median_dia_mm.
is_plus_ynu: A subjective, contextual appraisal of a variety on a given site and time. Data values are the characters Y, N, U (Yes, No, Unknown).
is_plus_tree: A mathematical representation of the Yes values from the "is_plus_ynu" column. Often used to sum the count of Yes values for summaries.
Signicant vw_2017_2_nursery_key_stock_summary and vw_2017_5_nursery_field_summary view columns:
These views contain the 2017 McGovern nursery data aggregated by variety (test_detail_key) and stock type. Below are 2 multi-data columns related to the Mini-stool (MS) and Dormant Cutting (DC) stock types, not commonly used in other views. They add their respective average vigor survival metric to the average number of field cuttings in feet, multiplied by the number of replications in the 2017 nursery. Below are the respective, formulas in SQL:
stools_cut_fcut_reps:
trunc(avg(stool_vigor_survival) + avg(field_cuttings_ft) * (count(replication_nbr) *.1),2)
cut_fcut_reps:
trunc(avg(vigor_survival) + avg(field_cuttings_ft) * (count(replication_nbr) *.1),2)