{"id":151,"date":"2024-01-07T16:16:42","date_gmt":"2024-01-07T16:16:42","guid":{"rendered":"https:\/\/safeavon.org.uk\/?page_id=151"},"modified":"2026-03-27T07:20:36","modified_gmt":"2026-03-27T07:20:36","slug":"data","status":"publish","type":"page","link":"https:\/\/safeavon.org.uk\/?page_id=151","title":{"rendered":"Data"},"content":{"rendered":"<ul>\n<li>SafeAvon publicly accessible raw data held on Epicollect, can be accessed by following this <strong>link<\/strong>:\u00a0<a href=\"https:\/\/five.epicollect.net\/project\/safeavon\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/five.epicollect.net\/project\/safeavon<\/a>.<\/li>\n<li>To help with understanding the data, a live spreadsheet has been set up to present it in a more intuitive way. You can access and interact with the summary spreadsheet by following this <strong>link<\/strong>:\u00a0<a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/10zcY2XL-ZTx03IdwKSJYTejASz6zjV0PdNzsSzveC80\/edit?usp=sharing\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/docs.google.com\/spreadsheets\/d\/10zcY2XL-ZTx03IdwKSJYTejASz6zjV0PdNzsSzveC80\/edit?usp=sharing<\/a><\/li>\n<\/ul>\n<p>This spreadsheet updates\u00a0automatically as new data is uploaded to Epicollect. It is the definitive source of overview statistics like\u00a0number of test\u00a0sites, samples taken etc. It means that a specific test site can quickly access the full relevant dataset and see charts of how the variables are trending,\u00a0and compare it with other\u00a0test sites.<\/p>\n<p>While the high level of nutrients (both phosphate and nitrates) show the water is polluted, it will not identify individual pollution events . You might instead use\u00a0the graphs it generates to identify when there are spikes which could indicate a pollution event, and then look at nearby sites (found using the test sites map, to which there is a link in the spreadsheet) and see if the same spike can be seen elsewhere in the same week. Alternatively, you can simply extract the relevant data and pass it on to your MP, or other stakeholder as evidence to inform their discussions and decisions.<\/p>\n<p style=\"text-align: center;\">***<\/p>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-439  aligncenter\" src=\"https:\/\/safeavon.org.uk\/wp-content\/uploads\/2026\/03\/Geoff-data-picture-300x117.png\" alt=\"\" width=\"713\" height=\"278\" srcset=\"https:\/\/safeavon.org.uk\/wp-content\/uploads\/2026\/03\/Geoff-data-picture-300x117.png 300w, https:\/\/safeavon.org.uk\/wp-content\/uploads\/2026\/03\/Geoff-data-picture.png 673w\" sizes=\"auto, (max-width: 713px) 100vw, 713px\" \/><\/h3>\n<ul>\n<li><span style=\"font-family: Times New Roman, serif;\"><span style=\"font-size: medium;\"><span style=\"color: #111111;\"><span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\"><b>Electrical Conductivity<\/b><\/span><\/span><\/span><span style=\"color: #111111;\"><span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\"> (EC): Conductivity is the ability of water to conduct electricity, which depends on the impurities in the water and is affected by <\/span><\/span><\/span><span style=\"color: #111111;\"><span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\"><u>temperature<\/u><\/span><\/span><\/span><span style=\"color: #111111;\"><span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\">. E<\/span><\/span><\/span><span style=\"color: #333333;\"><span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\">lectricity is conducted by the available ions, or electrolytes, dissolved in the water, a<\/span><\/span><\/span><span style=\"color: #3d4459;\"><span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\">n increase or decrease, can indicate pollutants, affecting the quality of the water. A sewage leak increases the EC because of additional ions such as chloride, phosphate, and nitrate. <\/span><\/span><\/span><\/span><\/span><\/li>\n<li>\n<p lang=\"en-US\"><span style=\"color: #202124;\"><span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\"><b>Nitrates<\/b><\/span><\/span><\/span><span style=\"color: #202124;\"><span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\">: High levels of nitrate in water can be a result of\u00a0<\/span><\/span><\/span><span style=\"color: #202124;\"><span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\"><b>runoff or leakage from fertilized soil, wastewater \/ sewage, landfills, septic systems, or urban drainage<\/b><\/span><\/span><\/span><span style=\"color: #202124;\"><span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\">. In river water it often ranges from\u00a0<\/span><\/span><\/span><span style=\"color: #202124;\"><span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\"><b>0.01-3.0 mg\/L (ppm)<\/b><\/span><\/span><\/span><span style=\"color: #202124;\"><span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\">. <\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<ul>\n<li>\n<p lang=\"en-US\"><span style=\"color: #202124;\"><span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\"><span lang=\"en-US\"><b>Phosphate<\/b><\/span><\/span><\/span><\/span><span style=\"color: #202124;\"><span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\"><span lang=\"en-US\">: Excessive phosphorus in surface water can cause explosive growth of aquatic plants and algae. This leads to a variety of water-quality problems, including low dissolved oxygen concentrations, which can cause fish to die &amp; harm other aquatic life. It is a good measure of sewage pollution.<\/span><\/span><\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p class=\"western\" lang=\"en-US\"><span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\"><b>Taking immediate action if necessary<\/b><\/span><\/span><span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\">, if you see any of the following: <\/span><\/span><\/p>\n<p lang=\"en-US\">\u2022 <span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\">Pollution to water or land<\/span><\/span><\/p>\n<p lang=\"en-US\">\u2022 <span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\">Damage or danger to the natural environment,<\/span><\/span><\/p>\n<p lang=\"en-US\">\u2022 <span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\">Dead fish or fish gasping for air<\/span><\/span><\/p>\n<p lang=\"en-US\">\u2022 <span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\">Collapsed or badly damaged riverbank<\/span><\/span><\/p>\n<p lang=\"en-US\"><span style=\"font-family: Abadi, serif;\"><span style=\"font-size: large;\"><b>Environment Agency 24-hour Incident Hotline 0800 80 70 60<\/b><\/span><\/span><\/p>\n<h1>Total Data<\/h1>\n<p><a href=\"https:\/\/safeavon.org.uk\/data\/2025_04_26MasterDataLog.xlsx\" target=\"_blank\" rel=\"noopener\">Total up to 2025 April 26th<\/a><\/p>\n<h1>Seasonal Data<\/h1>\n<p><a href=\"https:\/\/safeavon.org.uk\/data\/AutumnBaseline.xlsm\" target=\"_blank\" rel=\"noopener\">Autumn 2023 (1st Sept &#8211; 30th Nov)<\/a><\/p>\n<p><a href=\"https:\/\/safeavon.org.uk\/data\/WinterBaseline2024.xlsm\" target=\"_blank\" rel=\"noopener\">Winter 2023\/24 (1st Dec &#8211; 29th Feb)<\/a><\/p>\n<p><a href=\"https:\/\/safeavon.org.uk\/data\/SpringBaseline2024.xlsx\" target=\"_blank\" rel=\"noopener\">Spring 2024 (1 Mar &#8211; 31 May)<\/a><\/p>\n<p><a href=\"https:\/\/safeavon.org.uk\/data\/MasterDataLog_2024_09_06.xlsx\" target=\"_blank\" rel=\"noopener\">Summer 2024 (1 Apr &#8211; 2 Sept)<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h3><\/h3>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SafeAvon publicly accessible raw data held on Epicollect, can be accessed by following this link:\u00a0https:\/\/five.epicollect.net\/project\/safeavon. To help with understanding the data, a live spreadsheet has been set up to present it in a more intuitive way. You can access and interact with the summary spreadsheet by following this link:\u00a0https:\/\/docs.google.com\/spreadsheets\/d\/10zcY2XL-ZTx03IdwKSJYTejASz6zjV0PdNzsSzveC80\/edit?usp=sharing This spreadsheet updates\u00a0automatically as new data<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-151","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/safeavon.org.uk\/index.php?rest_route=\/wp\/v2\/pages\/151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/safeavon.org.uk\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/safeavon.org.uk\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/safeavon.org.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/safeavon.org.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=151"}],"version-history":[{"count":34,"href":"https:\/\/safeavon.org.uk\/index.php?rest_route=\/wp\/v2\/pages\/151\/revisions"}],"predecessor-version":[{"id":440,"href":"https:\/\/safeavon.org.uk\/index.php?rest_route=\/wp\/v2\/pages\/151\/revisions\/440"}],"wp:attachment":[{"href":"https:\/\/safeavon.org.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}