Themes | Stock |
Name of the indicator | Stock assessment models output |
Definition | Main columns obtained are the fishing mortality (meanf by years), the FMSY and the ratio beetween meanf and FMSY |
Objectives | The main objective is to analyse how far we are from the FMSY for the stock and the trends of the ration meanF/FMSY |
View | |
Calculation description | We get the data directly from ICES webservices. |
Reading guide |
You can get the Fishing mortality by year (meanf) and what should be a sustainable fishing mortality (FMSY). Then the ration between both values is a proxy of how far we are from a sustainable fishery.
Year wg - Year of last working group fishstock - the Ices code fro the stock year - the time serie year value f_etoile2 - ratio of meanf / FMSY overfished - 1 if f_etoile2>1 then 1 else 0 maxyear - last year of the time serie fmsy - Fishing mortality for a maximum sustainable yield meanf - Annual Fishing mortality. |
Data sources | Ices stock assessment output |
Comments | |
Query |
select f_etoile2_year.*,fmsy,meanf from f_etoile2_year LEFT join (limits inner join fishdata using(fishstock,evaluationyear)) using(fishstock,year) where
(year_wg=evaluationyear or year_wg is null) and fishstock like 'sol.27.8ab' order by year
|
Retour à la fiche |