StocksAndFisheriesKB

@aureliano.gentile@fao.org I do not understand the issue here.

In fact, I see that the GRSF record has 97 values for catches and the same number of values does the RAM record has.
Can you please elaborate on this?

Thanks Yannis.
As you can see in the excel file attached in this ticket (i.e. cell D21): GRSF has 97 and RAM has 170 and GRSF has 4 out of 5 of the assessid's.

Specifically, regarding the error mentioned in D23 "GRSF has 2 records (2012 and 2013) and RAM has 32" of the following stock:

Merluccius merluccius Portuguese Waters - East (Division 27.9.a) Bay of Biscay - South (Division 27.8.c)
Short Name: Hake - Bay of Biscay and Iberian Basin
GRSF Semantic identifier: asfis:HKE+fao:27.8.C;fao:27.9.A
Record URL: http://data.d4science.org/ctlg/GRSF_Admin/1bbbe48c-3410-3e19-bcae-fe8b144e852c

for the assessment_id WGBIE-HAKESOTH-1982-2014-ICESIMP2016 the GRSF contains only two values (2013, 2012) while the source DB RAM (not the legacy record but the source database) contains 32 values (from 1982 to 2013). I just double checked and I confirm, you can check on your own also by checking the source RAM CSV file at https://goo.gl/DMXkzE , go to the worksheet "timeseries", filter by WGBIE-HAKESOTH-1982-2014-ICESIMP2016 (assessid column) and by TCBEST-MT (tsid column) and you get 32 rows.

In conclusion it seems a data harvest problem where the legacy record is already missing some data.

great, thanks a lot, this is one of the more 'disturbing" bugs...

Thanks Yannis,
I am not sure if the fix has been already propagated to GRSF (RAM) records or only to the legacy records.
I just checked my original example (quoted below) and still there are only 2 entries for "WGBIE-HAKESOTH-1982-2014-ICESIMP2016" (assess_id) while there should be 32.
(it is a catch time series for the record Short Name: Hake - Bay of Biscay and Iberian Basin Record URL: http://data.d4science.org/ctlg/GRSF_Admin/1bbbe48c-3410-3e19-bcae-fe8b144e852c)

Aureliano Gentile wrote:

Thanks Yannis.
As you can see in the excel file attached in this ticket (i.e. cell D21): GRSF has 97 and RAM has 170 and GRSF has 4 out of 5 of the assessid's.

Specifically, regarding the error mentioned in D23 "GRSF has 2 records (2012 and 2013) and RAM has 32" of the following stock:

Merluccius merluccius Portuguese Waters - East (Division 27.9.a) Bay of Biscay - South (Division 27.8.c)
Short Name: Hake - Bay of Biscay and Iberian Basin
GRSF Semantic identifier: asfis:HKE+fao:27.8.C;fao:27.9.A
Record URL: http://data.d4science.org/ctlg/GRSF_Admin/1bbbe48c-3410-3e19-bcae-fe8b144e852c

for the assessment_id WGBIE-HAKESOTH-1982-2014-ICESIMP2016 the GRSF contains only two values (2013, 2012) while the source DB RAM (not the legacy record but the source database) contains 32 values (from 1982 to 2013). I just double checked and I confirm, you can check on your own also by checking the source RAM CSV file at https://goo.gl/DMXkzE , go to the worksheet "timeseries", filter by WGBIE-HAKESOTH-1982-2014-ICESIMP2016 (assessid column) and by TCBEST-MT (tsid column) and you get 32 rows.

That's true. Only the legacy records have been updated.
The GRSF ones will be updated after proceeding with the bulk approval of RAM records (#16375)