Please note that this forum is no longer in use and has been replaced by an online contact us form.

Be assured that the information service rendered by the EEA remains similar. Note that the content of this forum will remain publicly available until the end of 2020. After that we will archive it for internal use for a max retention period of 3 years. Any personal data will be deleted after this retention period.

With kind regards,
EEA Enquiry Service

Please login to participate.
Discussion
.
karahn Mar 02, 2018 07:35 PM
This is Ken Rahn from Rhode Island, USA, again. With your help, I managed to retrieve atmospheric hourly concentrations of PM10 from Belgium. They have been very helpful. Now I am trying to do the same for Germany, but the files are so large, even for single years, that my computer cannot open them. I just need data for two or three sites. Is there a way to get them without opening the huge file for the entire country? Otherwise, the process would discriminate against individual users like me. Thanks for any help that you can give me.
Replies (10)
EEA Mar 06, 2018 02:45 PM
Dear Ken,

Thank you for your email and for sharing the problem you have in opening the files containing the raw hourly data.
We are aware of this issue. We have therefore developed a new download data service that you can access at:

http://discomap.eea.europa.eu/map/fme/AirQualityExport.htm

Through this service, you can download specific station(s) or sampling point(s). The web page also explains how to use it.

Please note that this service is still a prototype (you will be the first external user!) which will replace the old data service in the coming weeks.
Do not hesitate to get back to us should you need further clarifications or explanations. Your comments on this new service will be also very valuable for us.

Kind regards
karahn Mar 13, 2018 06:06 PM
Thanks very much in advance! I have been briefly distracted by Chinese data recently, but will try out your prototype soon. It could be very valuable for me. Thanks for the link. :)
karahn Mar 20, 2018 05:10 PM
I just tried that link, but couldn't get it to work. I tried clicking on it directly, and using "Open the link," but both failed. :(
EEA Mar 22, 2018 10:14 AM
Hello,
We have tried the link and it works. Have you tried to recopy the URL into the browser? We hope that this will work.
Kind regards,
karahn Mar 28, 2018 02:11 AM
Hi, again! I took your advice about copying the URL into the browser, and it worked. Whew! The only thing left us to find a way to get rid of the "+1 hour" end in the time columns. It messes up the normal conversions to the data and time. I can't find a way to do that in Excel, but I have an idea about how to get around it. Thanks for all your help so far. (Since all the durations, at least for PM2.5, are one hour long, this part of the time cells seems to be redundant.) Best wishes, Ken Rahn
karahn Mar 29, 2018 02:09 AM
Update--I have developed a way to plot the data nicely, using a site from Antwerp, Belgium, as a test case. But I had to work around those +1:00 values in each of the time cells. I was able to do it semi-manually. It took about 30 minutes. That is not a terrible thing, but if I wanted to do 50 sites, it would not be nice. If there is any way to get the reporting agencies to remove this part of the data, it would be a great help for anyone else who needed to plot the results. In fact, there is no need for this +1.00 to appear in any time cells, because there is already a whole column that says that every value is a one-hour average. This seems to be a case of administrative overkill. There are other ways to simplify the tables of data without losing any information, but that discussion can be left for another day. :) Ken Rahn
karahn Mar 29, 2018 02:24 AM
I should add that you can't just plot the data line by line, because lines can be missing. For that case from Antwerp that I mentioned above, 11 lines were missing, and at random intervals. You might say that 11 out of 8784 is not very much, and that is true, but I need to attach the proper time to each point that I plot.
karahn Apr 03, 2018 07:48 PM
I have just downloaded data from several sites. The program seems to be working flawlessly and efficiently. It is a pleasure to work with now. :) My only remark concerns the +01.00 in the two datetime columns. It seems to be redundant to the earlier "duration" column. The duration of one hour for PM2.5 is now listed three times in the Excel files, and never deviates from that value. But I can live with it--it just slows down the work without an obvious benefit.
EEA Apr 05, 2018 02:50 PM
Dear Ken,

Thank you for your email and for sharing the problem you have in opening the files containing the raw hourly data.
We are aware of this issue. We have therefore developed a new download data service that you can access at: http://discomap.eea.europa.eu/map/fme/AirQualityExport.htm

Through this service, you can download specific station(s) or sampling point(s). The web page also explains how to use it.

Please note that this service is still a prototype (you will be the first external user!) which will replace the old data service in the coming weeks.
Do not hesitate to get back to us should you need further clarifications or explanations. Your comments on this new service will be also very valuable for us.

Kind regards,
 
Loading