– or –
Please login or register to participate.
jalexson Feb 19, 2018 03:06 PM
My name is Johanna Alexson and I am currently an intern at SEI (Stockholm Environmental Institute) and am looking for data on phosphorus in surface water. I found your interactive map on phosphorus in lakes and Orthophosphates in rivers (I will attach the webpages below for the two interactive maps I am writing about), but the data does not seem to be available anymore. I am wondering if it is possible to gain access to data that was archived, for example and excel file with the data that is accessible trough the maps? Or if there is more recent data on phosphorus in lakes and rivers accessible?
I have downloaded data from Waterbase (https://www.eea.europa.eu/[…]/) but I can not find any phosphorus measurements in any of the data-files.

Thank you for your time and have a great week!
Kind regards
/Johanna Alexson


Replies (5)
EEA Feb 22, 2018 10:44 AM
Hi Johanna,

The two interactive maps are available from the following homepage http://www.eea.europa.eu/[…]/status-of-water-quality . When loading the data you may have to wait 10-20 seconds until the content is displayed. Remark that at the bottom of the maps there is a time ruler to change the years. On the map with P in rivers there are no P-concentration data for 2013 (a bug).

We would recommend that you use the earlier versions of Waterbases split by rivers and lakes https://www.eea.europa.eu/[…]/waterbase-rivers-10 and https://www.eea.europa.eu/[…]/waterbase-lakes-10 . We have discovered some inconsistencies in the merged Waterbase Water quality and we are in the process of revising the dataset.

In addition to the two products, EEA has its indicator on nutrients in freshwater https://www.eea.europa.eu/d[…]ter-assessment-published-6. This indicator shows for consistent time series (1992-2012 and 2000-2012 (not all countries have the long time series)) trend for P in rivers and lakes.

Kind regards
jalexson Feb 22, 2018 04:42 PM
Hi again,
Thank you so much for taking the time to answer me and for your fast respons. I appriciate it very much.
I had a look at the interactive maps and the information connected to each lake i perfect, but I am wondering if it is possible to get access to the raw data? My wish is not to use this data online, but to use the raw data on phosphorus in lakes with other data that I collected and try to assess how manure from pigs affects the phosphorus load to European lakes.
I tried the old version of Waterbase that you added in the email, however, I could not get this to work. When I tried to open the file after downloading, an error message appears saying that "the file or catalog does not exist".

Is there any other way to gain access to this data perhaps?

Thank you again for your time and have a great afternoon!
Kind regards,
Johanna Alexson
jalexson Mar 02, 2018 03:48 PM
Good afternoon!
I am just wondering if my respons from February 22 got through? My internship ends soon and it would be very appreciated if I would be able to gain access to the data before I leave SEI, if it is possible to get the data of course.

Thank you again for your time and have a nice weekend!
Kind regards,
Johanna Alexson
EEA Mar 06, 2018 11:20 AM
Hi Johanna,

I am sorry that we haven't yet provided an answer, but we will get back to you very soon.

Kind regards
EEA Mar 07, 2018 11:42 AM
Hi Johanna,

At the Waterbase homepages there are two options: either download of a zipped Microsoft Access database or download a set of comma separated files.
After download, the files have to be extracted from the zipped folder. The extracted files can then be opened either with Access or imported in a spreadsheet (e.g. Excel). The files cannot be opened without being extracted from the zipped folder.

Kind regards