Water Framework Directive

1. Water Framework Directive WISE - 2005

2. Items on which to report progress • Finalising schemas for 2005 reporting • Develop WISE Web site for 2005 • Develop a tool to assist in 2005 reporting • Visualisation • Incorporate inter-calibration into WISE • Review of ReportNet

3. Web site 2005

4. Only Minor changes • Web site • Changed to enable upload of 2005 data • Slight changes but basically the same • Just enables different data to be loaded

5. Logon screen

6. RBD submissions

7. Supporting documents

8. Schema download

9. Access based tool to support 2005 submissions

10. 2005 Reporting Tool • Access 2000 • Discussed with GIS Activity 1 Group • Confirmed with DG ENV at reporting steering group • Table definitions to match schema requirements • Data may be uploaded directly to tables • SWB, GWB and Protected Areas from GIS or similar • Forms interface for RBD summary data

11. 2005 Reporting Tool • Forms • Enables data for the RBD to be entered • One form per Reporting sheet • No field validation • Run as batch on each form • All edits automatically saved • Can create XML files for upload • RBD, SWB, GWB and Protected Areas

12. RBD Form

13. River Basin District Form

14. SWB1 - Typology of Surface Water Bodies

15. SWPI1- Summary of Significant Pressures on Surface Water Bodies

16. Generate XML files

17. Schema development

18. Schema work carried out • Schema issues discussed with GIS Activity 1 Group 10th March 2005 • 1st draft issued to member states for comment 22nd March 2005 • Some comments received • From GIS Activity 1 Group members • Compiled into schemas issue log • Reviewed 13th April 2005 • Close for comments 26th April 2005

19. 2005 Reporting Requirements Schemas • 4 reporting schemas defined • RBD.xsd • RBD summary information • Split by reporting sheets • SWB1, SWB2, SWB3, SWPI1 – SWPI9 • GWB1, GWPI1-GWPI11 (GWPI9 not included as at water body level) • ECO1, RPA1

20. 2005 Reporting Requirements Schemas • SWB.xsd • Data for each Surface Water Body • lake, river, coastal and transitional water bodies • GWB.xsd • Data for each groundwater body • ProtArea.xsd • Data for each Protected Area

21. 2005 Reporting Requirements Schemas • WFDCommon.xsd • Reference schema only - not used for data. • All common type definitions, enumerated lists etc • Extended to include new definitions, lists etc • E.g. Risk Status Code • 1 =Not at Risk; • 2 =Possibly at Risk; • 3 =At Risk

22. Metadata and URLs • Metadata • a reference to any metadata statements may be provided at the schema level, or at the individual waterbody/protected area level. • These metadata statements should be uploaded to the WISE server or made available on the internet. • URL, reference to uploaded document, text • URLs • A URL may also be provided if wished • Requires a valid hyperlink/URL format to be provided. • Web-mapping system or further information

23. Key Comments / Issues

24. Inter-calibration metadatabase

25. Intercalibration Metadata • Integrate inter-calibration site data witinh WISE • Will continue to input/update site data using existing interface • Upload XML files to WISE • Processes to validate and convert on GIG and/or MS level • Enable site data to be accessed graphically • Selected data • Pre-generated reports and graphs • Data download as .csv or site XML file

26. Timetable

27. Next Planned Steps • Update WISE site now available for testing • Compile and assess all comments • Implement agreed changes and re-issue schemas by ?? May 2005 • Amend WISE to validate revised schemas • Amend data input and XML generation tool to match revised schemas • Make site available for use ?? June 2005 • Develop extra requirements • Inter-calibration, • xsd stylesheets to produce user-friendly RBD reports