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

data series with missing das_qal_id not showing in the datacall #216

Closed cedricbriandgithub closed 2 years ago

cedricbriandgithub commented 2 years ago

From @jdpo

the "existing data" tab in the data call file (at least for Germany) seems to be wrong. For Example in recruitment, for EmsBGY it is missing years 2014 - 2017. I thought we might have deleted them last year for some reason, but I can also see them in the shiny (is that showing the latest version of the DB?). Also, in the 2021 dc there were no entries that these should be deleted and they are there as existing data in the 2021 data call.

SELECT tdd.* FROM datawg.t_dataseries_das tdd JOIN
datawg.t_series_ser tss ON tdd.das_ser_id= tss.ser_id WHERE 
ser_nameshort='EmsBGY' ORDER BY das_year
das_id das_value das_ser_id das_year das_comment das_effort das_last_update das_qal_id das_dts_datasource
6 727 170 2 011 no monitoring. Series started in 2013 2021-09-08 0 dc_2021
6 728 170 2 012 no monitoring. Series started in 2013 2021-09-08 0 dc_2021
3 032 14 802 170 2 013 not representative, since an unknown number of eel bypassed the eel ladder 169 2020-08-27 4 dc_2019
3 033 43 371 170 2 014 124 2020-08-27 dc_2019
3 034 1 488 170 2 015 123 2020-08-27 dc_2019
3 035 4 816 170 2 016 101 2020-08-27 dc_2019
3 998 3 930 170 2 017 120 2020-08-27 dc_2019
3 999 8 840 170 2 018 119 2020-09-01 1 dc_2020
5 636 2 249 170 2 019 120 2020-09-01 1 dc_2020
6 749 3 157 170 2 020 120 2021-09-08 1 dc_2021
cedricbriandgithub commented 2 years ago

=> No issue they are in updated data