Both sides previous revisionPrevious revisionNext revision | Previous revision |
sediment_data_explorer [2025/08/01 16:34] – nefcadmin | sediment_data_explorer [2025/09/19 20:00] (current) – nefcadmin |
---|
A lot of sediment contamination is available in MMO marine license applications. | A lot of sediment contamination is available in MMO marine license applications. |
| |
A standard suite of chemicals is set out ([[https://www.gov.uk/guidance/marine-licensing-sediment-analysis-and-sample-plans|sample plans and analysis]) which has to be sampled for before many types of marine license are granted. The concentration of chemical contaminants is submitted as part of the application in a standard template format Excel macro spreadsheet (xslm). The concentrations are in visible sheets named after the chemical type measured, along with information about the sampling locations and a particle size analysis of each sample. There are also an equal number of hidden sheets with the types of analysis used to assess the data are shown. | A standard suite of chemicals is set out ([[https://www.gov.uk/guidance/marine-licensing-sediment-analysis-and-sample-plans|sample plans and analysis]]) which has to be sampled for before many types of marine license are granted. The concentration of chemical contaminants is submitted as part of the application in a standard template format Excel macro spreadsheet (xslm). The concentrations are in visible sheets named after the chemical type measured, along with information about the sampling locations and a particle size analysis of each sample. There are also an equal number of hidden sheets with the types of analysis used to assess the data are shown. |
| |
Spreadsheets of thousands of concentrations are a useful resource, but comparison and analysis in a spreadsheet format is not possible. The Sediment Template Data Explorer has been developed to allow both comparison and analysis of multiple sheets across multiple locations and over time periods. | Spreadsheets of thousands of concentrations are a useful resource, but comparison and analysis in a spreadsheet format is not possible. The Sediment Template Data Explorer has been developed to allow both comparison and analysis of multiple sheets across multiple locations and over time periods. |
| |
| |
[[https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://northeastfc.uk/AroundUK/Planning/MLA_2014_00573/3/Additional Documents/SAM201800033_MAR00157_LivDocks.xlsm&selcharts=pahdata|Liverpool Docks]] | [[https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://northeastfc.uk/AroundUK/Planning/MLA_2014_00573/3/Additional Documents/SAM201800033_MAR00157_LivDocks.xlsm|Liverpool Docks]] |
| |
[[https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://northeastfc.uk/AroundUK/Planning/MLA_2021_00202/Additional Documents/MMO_Results_Template - MAR00922 V2.xlsm,https://northeastfc.uk/AroundUK/Planning/MLA_2021_00202/Additional Documents/MMO_Results_Template - MAR00925.xlsm,https://northeastfc.uk/AroundUK/Planning/MLA_2021_00202/Additional Documents/MMO_Results_Template - MAR00930.xlsm,https://northeastfc.uk/AroundUK/Planning/MLA_2021_00202/Additional Documents/MMO Results_Template PBDE results_FULL.xlsm,https://northeastfc.uk/AroundUK/Planning/MLA_2021_00202/Additional Documents/MMO_Results_Template,https://northeastfc.uk/AroundUK/Planning/MLA_2021_00202/Additional Documents/MAR00922 V3.xlsm,https://northeastfc.uk/AroundUK/Planning/MLA_2021_00202/Additional Documents/MMO_Results_Template - MAR00925 v2.xlsm&selcharts=pahdata|Mersey into the Irish Sea Dredging]] | [[https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://northeastfc.uk/AroundUK/Planning/MLA_2021_00202/Additional%20Documents/MMO_Results_Template%20-%20MAR00922%20V2.xlsm,https://northeastfc.uk/AroundUK/Planning/MLA_2021_00202/Additional%20Documents/MMO_Results_Template%20-%20MAR00925.xlsm,https://northeastfc.uk/AroundUK/Planning/MLA_2021_00202/Additional%20Documents/MMO_Results_Template%20-%20MAR00930.xlsm,https://northeastfc.uk/AroundUK/Planning/MLA_2021_00202/Additional%20Documents/MMO_Results_Template%20-%20MAR00922%20V3.xlsm,https://northeastfc.uk/AroundUK/Planning/MLA_2021_00202/Additional%20Documents/MMO_Results_Template%20-%20MAR00925%20v2.xlsm|Mersey into the Irish Sea Dredging]] missing this bit problem reading [[https://northeastfc.uk/AroundUK/Planning/MLA_2021_00202/Additional%20Documents/MMO%20Results_Template%20PBDE%20results_FULL.xlsm]] |
| |
[[https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://northeastfc.uk/AroundUK/Literature/Table%202-1%20from%2099Polycyclic%20aromatic%20hydrocarbons%20in%20surface%20sediments%20around%20england%20and%20wales%20and%20their%20possible%20biological%20significance.xlsx,https://northeastfc.uk/AroundUK/Literature/Table%202-2%20from%2099Polycyclic%20aromatic%20hydrocarbons%20in%20surface%20sediments%20around%20england%20and%20wales%20and%20their%20possible%20biological%20significance.xlsx,https://northeastfc.uk/AroundUK/Literature/Table%202-3%20from%2099Polycyclic%20aromatic%20hydrocarbons%20in%20surface%20sediments%20around%20england%20and%20wales%20and%20their%20possible%20biological%20significance.xlsx,https://northeastfc.uk/AroundUK/Literature/Table%202-4%20from%2099Polycyclic%20aromatic%20hydrocarbons%20in%20surface%20sediments%20around%20england%20and%20wales%20and%20their%20possible%20biological%20significance.xlsx|Pre-1999 England and Wales PAHs Sediment Contamination]] | [[https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://northeastfc.uk/AroundUK/Literature/Table%202-1%20from%2099Polycyclic%20aromatic%20hydrocarbons%20in%20surface%20sediments%20around%20england%20and%20wales%20and%20their%20possible%20biological%20significance.xlsx,https://northeastfc.uk/AroundUK/Literature/Table%202-2%20from%2099Polycyclic%20aromatic%20hydrocarbons%20in%20surface%20sediments%20around%20england%20and%20wales%20and%20their%20possible%20biological%20significance.xlsx,https://northeastfc.uk/AroundUK/Literature/Table%202-3%20from%2099Polycyclic%20aromatic%20hydrocarbons%20in%20surface%20sediments%20around%20england%20and%20wales%20and%20their%20possible%20biological%20significance.xlsx,https://northeastfc.uk/AroundUK/Literature/Table%202-4%20from%2099Polycyclic%20aromatic%20hydrocarbons%20in%20surface%20sediments%20around%20england%20and%20wales%20and%20their%20possible%20biological%20significance.xlsx|Pre-1999 England and Wales PAHs Sediment Contamination]] |