1 / 23

Agenda Item 2a

Reporting under DWD for 2005-2006-2007. Agenda Item 2a. Workshop on Drinking Water Directive reporting under WISE Brussels, 21 October 2008 Violeta Vinceviciene European Commission, DG Environment Unit D.2 – Water and Marine, WFD Team - WISE. Main purpose of the workshop

MikeCarlo
Download Presentation

Agenda Item 2a

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Reporting under DWD for 2005-2006-2007 Agenda Item 2a Workshop on Drinking Water Directive reporting under WISE Brussels, 21 October 2008 Violeta Vinceviciene European Commission, DG Environment Unit D.2 – Water and Marine, WFD Team - WISE

  2. Main purpose of the workshop - to beready to report data electronicallyunder DWD in WISE 1/ WISE Reporting arrangements for DWD and list of reporters – Annex 32/ Options to report under DWD for 2005-2006-2007Technical formats and supporting guidance documents under DWD in WISE:3/ What to report (Which tables are needed)4/ How to report (Templates for reporting & Data Dictionary)5/ Further explanatory details (Guidance for coding, IDs for WSZ and link to NUTS)6/ QA/QC rules for Reportnet

  3. 1/ WISE Reporting arrangements for DWD and list of reporters – Annex 3(see separate presentation)

  4. Reporting procedure • The procedure for electronic reporting in WISE via Reportnet for DWD: • WISE reporting arrangements(very informal for DWD, as it is already endorsed by Water Directors in March’07) • Final list of nominated reporters (for access rights to upload reports)

  5. 2/ Options to report under DWD for 2005-2006-2007

  6. 2. Options to Report: • To use templates from Reportnet (and Data Dictionary) • To use guidance document on reporting for DWD agreed on 09/05/2007

  7. ReportingthroughReportnet in WISE Option 1: To use data formats created for WISE data on Reportnet • Documents available: • Guidance document on tables 09/05/2007http://ec.europa.eu/environment/water/water-drink/pdf/2007_05_09_guidance_doc_reporting.pdf • Data dictionary document on technical explanation of these tables for realisation in WISE compatible electronic format / templates for data exchange (xml, excel) • Guidance document on coding of IDs for WSZ and link of WSZ to NUTS http://circa.europa.eu/Public/irc/env/wfd/library?|=/framework_directive/drinking_directive • Templates (xml and/or xls forms) from EEA Reportnet and/or CIRCA: • EEA/Reportnet:http://dd.eionet.europa.eu/datasets.jsp

  8. Options to Report: Option 2: • To use guidance document on reporting for DWD agreed on 09/05/2007: • Document available from web site: http://ec.europa.eu/environment/water/water-drink/pdf/2007_05_09_guidance_doc_reporting.pdf • No templates available, but strongly recommended to report files at least in MS Excel according to tables of the document above

  9. DWD reporting process, 2005-2007 data REPORTNET (http://eionet.europa.eu/) DD CDR 1.step: downloadnewdatadictionary (DD) for DWD reporting 4. step: collect and download all country deliveries 3.2.Accept country delivery 3.step:upload DW data QA/QC DWD working db 3.1. Reject delivery if data not meet basic criteria CountryReporter 5. step: quality assurance of DW data Production DB for EU-27 2.step: Prepare DW data accordingto DD template

  10. Option 1 No templates (Excel format) but only guidance on reporting of 09/05/08 from CIRCA Download (xml or excel) format tables from Reportnet Prepare data (in ready to fill in templates of crrect format) Prepare the data (in Excel) in MSs UploadintoReportnet (draft + final) and to release envelop Upload into Reportnet (draft + final) and to release envelop QA/QC and the errorr-log file available to MSs No QA/QC When envelop will be released, letter of confirmation/acceptance automatically arrive to the reporter When envelop will be released, letter of confirmation/acceptance automatically arrive to the reporter Print confirmation letter and send it through PermRep to the EC, DG ENV Unit D.2, attn: Helmut Bloech Print confirmation letter and send it through PermRep to the EC, DG ENV Unit D.2, attn: Helmut Bloech End of data delivery: deadline end Febr’09 End of data delivery: deadline end Febr’09 Process of data flow Option 2

  11. 3. What to Report Correspondence of 13 tables in DD with tables in guidance document

  12. Methodology for reporting the data (page 3 DD): • Provide information on the WSZ • Submit annual summary information on DW quality in the WSZ exceeding 1000m3/day or serving >5000 persons • Submit data for non-compliance of DW in WSZ • Submit data on derogations in accordance with Art.9 of DWD • Use templates (xml schemas or Excel) and these specifications will guide you in formating and collating your data delivery. All are available to download from data dictionary • Supply data on WSZ in xml, Excel or tab-separated ASCII text format. Ensure commas are not used as decimal separators. • Upload your data files to your nominated repository: the central Data Repository athttp://cdr.eionet.europa.eu/

  13. 4. How to report:http://cdr.eionet.europa.eu/

  14. 4. How to report:Choose the country and go to http://cdr.eionet.europa.eu/lv

  15. 4. How to report 17

  16. 4. How to report Guidance of 09/05/2007 Data dictionary of Oct’08 Other doc’s on CIRCA 18

  17. 4. How to report:Templates for Tables and DD Final version of templates for 13 reporting tables and DD are available • from CIRCA at http://circa.europa.eu/Public/irc/env/wfd/library?|=/framework_directive/drinking_directive • As well as from EIONET: http://cdr.eionet.europa.eu/ Data Dictionary from: http://dd.eionet.europa.eu/datasets.jsp (to be available for DWD from 31/10/08), e.g. for NiD http://dd.eionet.europa.eu/search_results_tbl.jsp

  18. 4. How to report:Templates for Tables and DD Table 07 of DD 20

  19. 4. How to report:Templates for Tables and DD 21

  20. 5. QA/QC Rules for Reportnet When data are in Reportnet at CDR • Automatic QA/QC takes place • Within the data specifications sizes (number of characters) and values (min and max) that should be complied with, are defined. • When a value from a code list is asked for it should already be listed under the code list. This applies to the fields: • Country code • Parameter • Parameter type • Remedial • Time table • Cause • Derogation type. • Check a date field for the format yyyy/mm/dd • Parameters values have to be defined (will be introduced for the next reporting exercise only)

  21. 6. Guidance for coding of IDs for WSZ and how to link with NUTS: See separate presentation – slightly modified that of 16/07/2008 workshop

More Related