1 / 40

The WISE prototype

Developed in 2004-2005, a comprehensive data management system for Water Framework Directive reporting. Includes schema definition, data entry forms, submission validation, analysis tools, and viewer reports. Supports all WFD submission requirements.

robbinsr
Download Presentation

The WISE prototype

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. The WISE prototype

  2. Remit at the start of the project • 2004 Reporting initial base data • 2005 Water body / infrastructure and status • Water body level and RBD • Subsequent detail on monitoring stations • Developed a method to suit all • Develop a data model and a process to suit future requirements

  3. The basic process

  4. Schema definition Agreed format for data

  5. Forms entry Forms entry Agreed format for data

  6. Forms entry Upload and validation Agreed format for data Initial Electronic submission Validation

  7. Forms entry Analysis and dissemination Agreed format for data Initial Electronic submission Validation Accepted Analysis / compliance General viewer Reports / maps Reports / maps

  8. The forms interface was slow!

  9. Article 5 tool Client side tool Agreed format for data Initial Electronic submission Validation Accepted Analysis / compliance General viewer Reports / maps Reports / maps

  10. Common set of tools • Data preparation • Data submission • Validation • Migration to a database • Analysis • View and disseminate

  11. The base data

  12. Article 3 Reporting data required • Provides organisational building blocks • River Basin Districts • Competent authorities • Management structures • Roles / Responsibilities • Legal documents • International River Basins

  13. Article 3 data International RBD Member States International Role RBDs Lead CA Legal document Role Support CAs Competent Authorities Support Group General responsibilities Role Group CAs

  14. Article 5 Reporting data required • Infrastructure building blocks • Rivers, Lakes and heavily modified water bodies • Coastal and transitional waters • Ground waters • Protected areas • Pressures and impacts and protected areas • Performance detail • Classifications • At risk

  15. Article 5 data

  16. WFD data structure established • Data standards and validation rules all defined within the schema definitions • Single database structural design determined for all WFD data • Physical database defined in Oracle 9i locator on the JRC server at ISPRA • Physical database also defined in Access for Article 5 data

  17. Generic submissions process • Options for submitting data • Maintains the idea of components • An overall process • Holding area • Validation • Re-submissions • Tools to assist management

  18. Methods for submission • Attribute data • Access tool • XML • Graphics detail – • GML or Shape file • Optional for water bodies

  19. Submissions and components Article 3 Submission Attribute component RBD map component Main river map component Groundwater map component Metadata component Main lake map component Coastal waters component Transitional map component • Forms • Xml • XML • GML • Shape • GML • Shape • GML • Shape

  20. Submissions and components Article 5 Submission RBD RBD RBD RBD RBD • RBD • Protected areas • Groundwater • Water bodies • RBD • Protected areas • Groundwater • Water bodies • RBD • Protected areas • Groundwater • Water bodies • RBD • Protected areas • Groundwater • Water bodies • RBD • Protected areas • Groundwater • Water bodies

  21. Process – holding area Holding area Component User

  22. Process – submission levelAll components in and valid submission validation Holding area • Cross component • validation • Database • validation Submission User

  23. Process – database load Holding area Submission Confirmation Valid data User Reporting database

  24. Submissions status

  25. Upload screen

  26. Submissions stats

  27. Re-submissions • Data re-submitted at component level • Goes through component validation • Upload to database at component level • Options for 2005 • Correct using Access tool • Correct native XML at site • Repeat upload of XML or GML or Shape • Option to download XML from site

  28. Manage submission process • Tools within interface • Select reporting process • View Submission status • Overall and cross validation • View component statuses • Overall, auto and manual checks • View history of statuses • Receipt of reminders • Failure reports

  29. Generic submissions process • Will support all of WFD submission requirements • Could be applied to other Directives • Will support the proposed WISE environment

  30. Common Web site for Public access

  31. Mapping interface

  32. Map point and click

  33. Detail report

  34. Statistics option is new

  35. Single RBD

  36. Single Member State

  37. Multiple Member states

  38. International River Basins

  39. Bar charts and pie charts

  40. View data submission Open source solution that supports WFD Could support the proposed WISE environment • Web site access to general public • Access via maps or gazetteer • Access to view detail • RBD or Water Body level • Competent organisations • Access to standard reports and maps

More Related