Från: Bo Thunholm [Bo.Thunholm@sgu.se]
Skickat: den 13 januari 2010 15:44
Till: Miroslav.Fanta@cenia.cz
Kopia: Misterewicz, Marta
Ämne: Ang. SE - 2009 WISE SoE groundwater reporting - response....

Bifogade filer: SoE_2009_Groundwater_Quality_SWE.xls

Dear Mr Fanta

Here is a revised version of "SoE_2009_Groundwater_Quality_SWE.xls". The id's for the groundwater bodies (corresponding to the monitoring stations that you mentioned) in sheet "GroundwaterMonitoringSites" have been corrected. This excel file should replace the previous one.

Best regards
Bo Thunholm
Hydrogeolog / Hydrogeologist
Sveriges geologiska undersökning / Geological Survey of Sweden
Box 670 / Box 670
751 28 Uppsala / SE-751 28 Uppsala
Sweden

018 - 179 212 / +46 18 179 212




Miroslav.Fanta@cenia.cz

2009-12-16 11:37

Till
Bo.Thunholm@sgu.se, Marta.Misterewicz@naturvardsverket.se
Kopia
Ärende
SE - 2009 WISE SoE groundwater reporting - response....






Dear Mr. Thunholm, dear Ms. Misterewicz,


thank you for your reply.


Unfortunately, first question was not fully clarified.
Mentioned 6 monitoring stations SE19_15, SE20_, SE20_10, SE20_6, SE3_53, SE3_54 are embedded to WFD gw bodies SE660896-139402, SE663197-154203, SE663197-154203 or SE620244-140640.

Please provide at least basic attributes (name, Reference year, Number of Horizon, RBD, identical EIONET gw body(if any)) to these 4 gw bodies,
because they are missing in the list of reported gw bodies in corrected dataset.


Thank you


Best regards


Miroslav Fanta



Od: Bo Thunholm <Bo.Thunholm@sgu.se>
Komu: Miroslav.Fanta@cenia.cz
Kopie: <Marta.Misterewicz@naturvardsverket.se>
Datum: 11.12.2009 13:21
Předmět: SE - 2009 WISE SoE groundwater reporting - response....







Dear Mr. Fanta:



Here is the response to your request of 4 december:


1. Confirmed; the change should be implemented.


2. Confirmed, these high values are correct.


3. Negative values have been replaced with "<", see attached file.


4. Yes, aggregated data "
NutrientsGW_Agg" are based on the "NutrientsGW_Disag", aggregated data is deleted in the attached file.

Best regards

Bo Thunholm
Hydrogeolog / Hydrogeologist
Sveriges geologiska undersökning / Geological Survey of Sweden
Box 670 / Box 670
751 28 Uppsala / SE-751 28 Uppsala
Sweden

018 - 179 212 / +46 18 179 212







4.12.2009:

to: magnus.asman@sgu.se

Dear Mr. Åsman,

thank you very much for 2009 WISE SoE groundwater data delivery.

I would like to ask you to clarify following data problems:

1) 6 monitoring stations are embedded to different WFD gw bodies than it was reported in 2008.
   See attached table SE_err_stations_DifferentLinkToWFDgwBody.xls.
   Please confirm, whether we should implement this change.

2)  we are using treshold 1000 as warning for very high and potentialy suspicious disaggregated data values to detect typing errors etc.
  3 Hazardous substances disaggregated data records are exceeding this limit (see attached file SE_warn_HazSubstDisagg_HighValues.xls)
  Please confirm, whether these high values are correct.

3) 3 Nutrients disaggregated data recors have negative value. See attached file SE_err_NitratesDisagg_Negativevalues.xls.
   Please correct these values

4) Please confirm, whether NutrientsGW_Agg sheet contains aggregated data created by aggregation of data delivered on NutrientsGW_Disagg sheet.
   In such case, aggregated data delivery is redundant and aggregated data are not taken into account.
   Disaggregated data are allways preferred, as described in Data Dictionary on the page 3
   (see General Information chapter, ->  Methodology of obtaining data. -> Summary of changes in 2009  -> IMPORTANT NOTICE)


Thank you

Best regards

Miroslav Fanta
ETC Water data manager
CENIA
v
[attachment "SoE_2009_Groundwater_Quality_SWE.xls" deleted by Miroslav Fanta/CENIA/CZ]