ices-eg / wg_WGEEL

Joint EIFAAC/ICES/GFCM Working Group on Eels
http://ices.dk/community/groups/Pages/WGEEL.aspx
5 stars 12 forks source link

Remove BeeGY with das_qal_id 3 #296

Closed cedricbriandgithub closed 5 months ago

cedricbriandgithub commented 9 months ago

BeeG and BeeGy two values, one duplicated, correct this for 2024 analysis

SELECT x.* FROM datawg.t_series_ser x
WHERE ser_nameshort ='BeeGY';
UPDATE datawg.t_series_ser
  SET (ser_qal_id, ser_qal_comment)=(3,'Duplicated series from BeeG, this series will not be used in the analysis')
  WHERE ser_id=317;