Open HansMJ opened 3 years ago
Some assessment values are on dry weight basis (see summary table summary) and in some cases you will have both dry and wet eight for the same species and matrix/tissue combination (e.g. Norwegian blue mussels (soft body) are on wet weight basis, whereas the Icelandic are on dry weight). So do we need to include basis in the table or can we use a standard conversion when the basis is dry weight?Species.matrix.basis.combinations.for.HG.20210601.xlsx
Updated Levels table where unit and basis are separated. Param has been added, so that other determinands than HG can be included. Additional coloumns has been added ('convert_from_ww', 'convert_from_dw' and 'convert_from_lw') to enable basis conversions of assessment values, so that they can be compared with the risk levels. So if assessment value is dw and risk level in ww, the 'convert_from_dw' value should be multiplied with the assessment value when comparing. The column 'No effect (<)' is strictly not needed because it is the same value as given under 'low effect (>=)' Species.matrix.basis.combinations.20210826.xlsx
As agreed we will use the table as is for now, by using a flag saying something like 'no comparable risk level' when no category can be looked up.
From the result summary table the column meanLY (the fitted mean concentration in lastyear) can be used to make 3 (verify with Simon) classes when comparing with some predefined effect levels (per species and tissue). Simon will provide the list of effect levels to use.
[X] 1. Send list with combinations of (species tissue) to Simon , so that he can add the effect levels (Hans) Species matrix combinations for HG 20210601.xlsx
[X] 2. Use the table with effect levels to display coloured dots (depending on distance to effect levels) on a levels map (can be a toggled version of the trend map or a separate map page (check with Simon
[X] 3. Legend will also need to be added to the map page and possibly some way of downloading the effect levels (also check with Simon)
[X] 4. When clicking a station we should show the meanLY, species, tissue , effects level value (check with Simon)
https://gis.ices.dk/ahat/