Add définitions to glass yellow silver yellow+silver

[cedricbriandgithub]

I still need a definition of YS

[cedricbriandgithub]

/ Insert definition for stages Please insert correct definitions /

update ref.tr_lifestage_lfs set lfs_definition ='' from ts.tr_lifestage_lfs where lfs_code='G'; update ref.tr_lifestage_lfs set lfs_definition ='' from ts.tr_lifestage_lfs where lfs_code='Y'; update ref.tr_lifestage_lfs set lfs_definition ='' from ts.tr_lifestage_lfs where lfs_code='S'; update ref.tr_lifestage_lfs set lfs_definition ='' from ts.tr_lifestage_lfs where lfs_code='YS'; update ref.tr_lifestage_lfs set lfs_definition ='A mixture of glass and yellow eel, some traps have historical set of data where glass eel and yellow eel were not separated, they were dominated by glass eel' from ts.tr_lifestage_lfs where lfs_code='GY';

[cedricbriandgithub]

definitions for G, Y, S

Check GY and find def for YS

update ref.tr_lifestage_lfs set  lfs_definition ='Young, unpigmented eel, recruiting from the sea into continental waters. WGEEL consider the glass eel term to include all recruits of the 0+ cohort age. In some cases, however, also includes the early pigmented stages.' from ts.tr_lifestage_lfs where lfs_code='G';
update ref.tr_lifestage_lfs set  lfs_definition ='Life-stage resident in continental waters. Often defined as a sedentary phase, but migration within and between rivers, and to and from coastal waters occurs and therefore includes young pigmented eels (‘elvers’ and bootlace).' from ts.tr_lifestage_lfs where lfs_code='Y';
update ref.tr_lifestage_lfs set  lfs_definition ='Migratory phase following the yellow eel phase. Eel in this phase are characterized by darkened back, silvery belly with a clearly contrasting black lateral line, enlarged eyes. Silver eel undertake downstream migration towards the sea, and subsequently westwards. This phase mainly occurs in the second half of calendar years, although some are observed throughout winter and following spring.' from ts.tr_lifestage_lfs where lfs_code='S';
update ref.tr_lifestage_lfs set  lfs_definition ='' from ts.tr_lifestage_lfs where lfs_code='YS';
update ref.tr_lifestage_lfs set  lfs_definition ='A mixture of glass and yellow eel, some traps have historical set of data where glass eel and yellow eel were not separated,
they were dominated by glass eel' from ts.tr_lifestage_lfs where lfs_code='GY';

[cedricbriandgithub]

Russell's answers Thinking about the definitions, I think we should say something like, “for the recruitment analysis, we have combined the glass eel and elver stages (as defined in the Stock Annex????) into a single 0+ age cohort”

And I see we haven’t defined the young yellow eel recruitment at all in the Stock Annex, so we need to do that. Any ideas? What about: “Eels recruit upstream from coastal waters to through to freshwaters not only as 0+ age young of the year, but also as multiple age classes of young yellow eel, typically from 1= to 10+ years of age – these are referred to as Yellow Eel Recruits”.

[cedricbriandgithub]

In answer to Russell's comment, the problem is that the lifestage table will apply as a reference for both 3B&A and recruitment series data. So I suggest

update ref.tr_lifestage_lfs set  lfs_definition ='Life-stage resident in continental waters. Often defined as a sedentary phase, but migration within and between rivers, and to and from coastal waters occurs and therefore includes young pigmented eels (‘elvers’ and bootlace). In particular, some recruitment series either far up in the river (Meuse) or in the Baltic are made of multiple age class of young yellow eel, typically from 1 to 10+ years of age- the are referred to as Yellow eel Recruits.' from ts.tr_lifestage_lfs where lfs_code='Y';