| Themes | Stock |
| Name of the indicator | Catches by years |
| Definition | Discards and landings by years |
| Objectives | Main objective is to get an overview of catches for the stock |
| View | |
| Calculation description | Data are disseminate through a web service on Ices website. Each year we collect these data coming from the stock assessment database. |
| Reading guide | For each year the value of catches is represented by the value of discards and the value of landings. |
| Data sources | Data are provided by members state. ICES working group gather these data for the stock assessment process. |
| Comments | |
| Query |
with part1 as
(
select * from fishdata where fishstock like 'bss.27.4bc7ad–h' and (fishstock,evaluationyear) in
(select distinct fishstock,max(evaluationyear) from fishdata group by fishstock order by fishstock)
and COALESCE(landings, 0 )+COALESCE(discards,0)>0
)
select distinct year as ABSCISSE,'Landings' as GROUPE,round(landings/1000,2) as TOTAL from part1
union
select distinct year as ABSCISSE,'Discards' as GROUPE,round(discards/1000,2) as TOTAL from part1 order by ABSCISSE,GROUPE
|
 Retour à la fiche | |
