Differences

This shows you the differences between two versions of the page.

--- sediment_data_explorer [2024/08/07 16:01] – nefcadmin
+++ sediment_data_explorer [2026/08/21 12:24] (current) – nefcadmin
@@ Line 1: / Line 1: @@
 A lot of sediment contamination is available in MMO marine license applications.
-A standard suite of chemicals is set out 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.
@@ Line 13: / Line 13: @@
 The Sediment Template Data Explorer below shows the data for a number of sediment sampling exercises which have been carrier out as part of [[MLA-2015-00088|MLA/2015/00088]], the license for maintenance dredging of the River Tees.
-[[https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://northeastfc.uk/Teesworks/Planning/MLA_2015_00088/Additional%20Documents/20150603%20MLP201500094%20PD%20Teesport%20Results%20MMO%20Template.xlsx,https://northeastfc.uk/Teesworks/Planning/MLA_2015_00088/Returns/MMO_Results_Template%20-%20MAR01178.xlsm,https://northeastfc.uk/Teesworks/Planning/MLA_2015_00088/Returns/20125933%20-%20MMO%20Results.xlsm,https://northeastfc.uk/Teesworks/Planning/MLA_2015_00088/Returns/MMO%20Results_Template%20MAR00356_2.xlsm|River Tees and Hartlepool Maintenance Dredge Samples]]
+[[https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://northeastfc.uk/RiverTees/Planning/MLA_2015_00088/Additional%20Documents/20150603%20MLP201500094%20PD%20Teesport%20Results%20MMO%20Template.xlsx,https://northeastfc.uk/RiverTees/Planning/MLA_2015_00088/Returns/MMO_Results_Template%20-%20MAR01178.xlsm,https://northeastfc.uk/RiverTees/Planning/MLA_2015_00088/Returns/20125933%20-%20MMO%20Results.xlsm,https://northeastfc.uk/RiverTees/Planning/MLA_2015_00088/Returns/MMO%20Results_Template%20MAR00356_2.xlsm|River Tees and Hartlepool Maintenance Dredge Samples]]
-[[this>Tools/iiipahdataplot.html?status=../Teesworks/Planning/MLA_2020_00506/240204South Bank Quay Dredging - MLA-2020-00506.sed&selcharts=pahdata|South Bank Quay Dredging]]???
+[[this>Tools/iiipahdataplot.html?status=../RiverTees/Planning/MLA_2020_00506/240204South Bank Quay Dredging - MLA-2020-00506.sed&selcharts=pahdata|South Bank Quay Dredging]]???
-[[https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO%20Results_Template%20MAR00356_2%20V2-7.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00856_with%20coords-37.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00874_with%20coords-38.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00825_with%20coords-35.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00829_with%20coords-36.xlsm|South Bank Quay Dredging - Most recent versions of 5 key spreadsheets from MLA/2020/00506/2]]
+[[https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO%20Results_Template%20MAR00356_2%20V2-7.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00856_with%20coords-37.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00874_with%20coords-38.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00825_with%20coords-35.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00829_with%20coords-36.xlsm|South Bank Quay Dredging - Most recent versions of 5 key spreadsheets from MLA/2020/00506/2]]
-[[https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO%20Results_Template%20MAR00356_1%20V2-1.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO%20Results_Template%20MAR00356_2%20V2-2.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO%20Results_Template%20MAR00356_1%20V2-6.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO%20Results_Template%20MAR00356_2%20V2-7.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00829%20Interim-17.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00856%20Interim%202-18.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00874%20Interim-19.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00825%20Interim%202-20.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00825%20Interim%202-21.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00874%20Interim-22.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00856%20Interim%202-23.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00829%20Interim%20(1)-24.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00825_with%20coords-27.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00829_with%20coords-28.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00856_with%20coords-29.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00874_with%20coords-30.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00856_with%20coords-37.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00874_with%20coords-38.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00825_with%20coords-35.xlsm,https://www.northeastfc.uk/Teesworks/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00829_with%20coords-36.xlsm|South Bank Quay Dredging - All spreadsheets from MLA/2020/00506/2]]
+[[https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO%20Results_Template%20MAR00356_1%20V2-1.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO%20Results_Template%20MAR00356_2%20V2-2.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO%20Results_Template%20MAR00356_1%20V2-6.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO%20Results_Template%20MAR00356_2%20V2-7.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00829%20Interim-17.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00856%20Interim%202-18.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00874%20Interim-19.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00825%20Interim%202-20.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00825%20Interim%202-21.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00874%20Interim-22.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00856%20Interim%202-23.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00829%20Interim%20(1)-24.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00825_with%20coords-27.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00829_with%20coords-28.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00856_with%20coords-29.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00874_with%20coords-30.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00856_with%20coords-37.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00874_with%20coords-38.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00825_with%20coords-35.xlsm,https://www.northeastfc.uk/RiverTees/Planning/MLA_2020_00506/MLA_2020_00506-MMO_Results_Template%20-%20MAR00829_with%20coords-36.xlsm|South Bank Quay Dredging - All spreadsheets from MLA/2020/00506/2]]
-[[https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://northeastfc.uk/Teesworks/Planning/MLA_2015_00334/Additional%20Documents/Sample%20Results%2020.04.2016.xlsm|Able Seaton Port Berth 8 & 9 - MLA/2015/00334 - 2016]]
+[[https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://northeastfc.uk/RiverTees/Planning/MLA_2015_00334/Additional%20Documents/Sample%20Results%2020.04.2016.xlsm|Able Seaton Port Berth 8 & 9 - MLA/2015/00334 - 2016]]
-[[https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://northeastfc.uk/Teesworks/Planning/MLA_2015_00334/3/Additional%20Documents/20171110%20SAM201700066A%20Able%20Seaton%20Port%20Berth%208%20%209%20MMO%20Results%20Template(4).xlsm|Able Seaton Port Berth 8 & 9 - MLA/2015/00334 - 2017]]
+[[https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://northeastfc.uk/RiverTees/Planning/MLA_2015_00334/3/Additional%20Documents/20171110%20SAM201700066A%20Able%20Seaton%20Port%20Berth%208%20%209%20MMO%20Results%20Template(4).xlsm|Able Seaton Port Berth 8 & 9 - MLA/2015/00334 - 2017]]
-[[https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://northeastfc.uk/Teesworks/Planning/MLA_2015_00334/8/Additional%20Documents/MMO_Results_Template%20%20-%20MAR00562.xlsm|Able Seaton Port Berth 8 & 9 - MLA/2015/00334 - 2020]]
+[[https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://northeastfc.uk/RiverTees/Planning/MLA_2015_00334/8/Additional%20Documents/MMO_Results_Template%20%20-%20MAR00562.xlsm|Able Seaton Port Berth 8 & 9 - MLA/2015/00334 - 2020]]
@@ Line 36: / Line 36: @@
-[[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]]
@@ Line 45: / Line 45: @@
 Centre for Environment, Fisheries and Aquaculture Science, 1 CEFAS Lowestoft Laboratory, Pake®eld Road, Lowestoft, Sufolk, NR33 0HT, UK / 2 CEFAS Burnham Laboratory, Remembrance Avenue, Burnham-on-Crouch, Essex CM0 8HA, UK
-{{url>https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://northeastfc.uk/Teesworks/Planning/MLA_2015_00088/Additional%20Documents/20150603%20MLP201500094%20PD%20Teesport%20Results%20MMO%20Template.xlsx,https://northeastfc.uk/Teesworks/Planning/MLA_2015_00088/Returns/20125933%20-%20MMO%20Results.xlsm,https://northeastfc.uk/Teesworks/Planning/MLA_2015_00088/Returns/MMO_Results_Template%20MAR00179%20V3.xlsm,https://northeastfc.uk/Teesworks/Planning/MLA_2015_00088/5/Additional%20Documents/MMO_Results_Template%20-%20MAR00853%20Interim_4.xlsm,https://northeastfc.uk/Teesworks/Planning/MLA_2015_00088/Returns/MMO%20Results_Template%20MAR00356_2.xlsm,https://northeastfc.uk/Teesworks/Planning/MLA_2015_00088/Returns/MMO_Results_Template%20-%20MAR01178.xlsm&locations=https://northeastfc.uk/Tools/LocationLatLon-LookUp.xlsx 100%,10000}}
+[[tees_estuary_samples_taken_april_2023]]
+{{url>https://steps39.github.io/SedDataExp/SedimentDataExplorer.html?urls=https://northeastfc.uk/RiverTees/Planning/MLA_2015_00088/Additional%20Documents/20150603%20MLP201500094%20PD%20Teesport%20Results%20MMO%20Template.xlsx,https://northeastfc.uk/RiverTees/Planning/MLA_2015_00088/Returns/20125933%20-%20MMO%20Results.xlsm,https://northeastfc.uk/RiverTees/Planning/MLA_2015_00088/Returns/MMO_Results_Template%20MAR00179%20V3.xlsm,https://northeastfc.uk/RiverTees/Planning/MLA_2015_00088/5/Additional%20Documents/MMO_Results_Template%20-%20MAR00853%20Interim_4.xlsm,https://northeastfc.uk/RiverTees/Planning/MLA_2015_00088/Returns/MMO%20Results_Template%20MAR00356_2.xlsm,https://northeastfc.uk/RiverTees/Planning/MLA_2015_00088/Returns/MMO_Results_Template%20-%20MAR01178.xlsm&locations=https://northeastfc.uk/Tools/LocationLatLon-LookUp.xlsx 100%,10000}}