1 / 41

Current Data Collation

Current Data Collation. Waste Information Excel and paper based system. Water Quality Excel files + Other sent to EPA. Diverse formats Some extracted from Agency LIMS. LAMS (LA statutory performance) Collected on disk (access system). Complaints Paper based correspondence. Air Quality

cameron-white
Download Presentation

Current Data Collation

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. Current Data Collation Waste Information Excel and paper based system Water Quality Excel files + Other sent to EPA. Diverse formats Some extracted from Agency LIMS LAMS (LA statutory performance) Collected on disk (access system) Complaints Paper based correspondence Air Quality Data down loaded and Excel file sent to EPA. Real-time invalidated data available Bathing Water Online internet system providing summary compliance information Drinking Water Abstraction Received in various forms form LA Quality Via Excel template Dangerous Substances Paper based system Urban Waste Water Excel system – Files sent to EPA, slow and cumbersome Water Quantity Data reported to EPA via email

  2. LA Lab EPA Data Bases LGCSB Health Board LA LIMS EPA Data Bases EPA EPA Labs EPA Data Bases Contract Lab Water Quality Analysis Data Electronic or Paper Based EPA extracts data from excel or other format, checks and puts into DB’s

  3. LA LIMS LA Lab EPA Data Bases Health Board EDEN EPA Data Bases EPA Labs EPA Data Bases Contract Lab LA Approval EPA extracts data from excel or other format, checks and puts into DB’s Water Quality Analysis Data Electronic or Paper Based

  4. Water - Example Bathing Water Drinking Water • What constitutes “Water” • Bathing Water • Drinking Water • Ground Water • Lake Water • River Water • Transitional and Costal Water • Urban Waste Water Ground Water Ground Water Lake Water Lake Water River Water River Water T & C Water Transitional, Coastal and Marine Water Urban Waste Water Urban Waste Water

  5. Lakes Data “Flow” Local Authorities Biological data via Excel Templates Phosphorous Report EPA Laboratories Chemical data via Excel Templates Dangerous Substance Report Central Fisheries Board Biological data via Excel Templates Water Quality in Ireland Lake Water Data set(s) Local Authorities Phosphorus data via Excel sheets and Paper State of the Environment (Water) Environmental Indicators (Water) EPA Lake Monitoring Program Phosphorus data via Excel sheets EPA Annual Report Local Authorities Dangerous Substance data via Excel sheets and Paper EIONET (Lake Quality - EWN 2) EPA Laboratories Dangerous Substance data via Excel sheets

  6. Bathing Water Directive Report Bathing Water Local Authorities Summary data via Web Local Authorities Bathing Water Report Chemical data via Excel Templates Local Authorities Chemical data via Excel Templates Drinking Water Report Hydrometric Teams Drinking Water Site Readings via Excel Paper and Citrix entry Ground Water Quality Report Local Authorities Bacterialogical data via Excel sheets Eionet (Ground Water - EWN 3) Hydrometric Teams Level data via Excel Paper and Citrix entry Ground Water Local Authorities Phosphorous Report Biological data via Excel Templates Ground EPA Laboratories Water Chemical data Dangerous Substance Report via Excel Templates Central Fisheries Board Biological data via Excel Templates Water Quality in Ireland Local Authorities Lake Water Phosphorus data via Excel sheets and Paper Lake State of the Environment (Water) EPA Lake Monitoring Program Water Phosphorus data via Excel sheets Local Authorities Environmental Indicators (Water) Dangerous Substance data via Excel sheets and Paper EPA Laboratories River Water Dangerous Substance data EPA Annual Report via Excel sheets River EPA Biologists Water Biological data via MSAccess exports to Excel sheets Eionet (Lake Quality - EWN 2) Local Authorities Chemical data via Labinfo export to Excel River Water Quality Report EPA Biologists T & C Water Phosphorus Biological data via Paper Transitional, EPA Laboratories Coastal and River Biological Survey report Phosphorus Chemical data Marine Water via Excel sheets EPA Laboratories Chemical data Eionet (River Quality - EWN 1) via LIMS export to Excel sheets Marine Institute Chemical data Urban Waste Water via Excel sheets Urban OSPAR report Dublin EPA laboratory Waste OSPAR data Water via Excel sheets Eionet (Marine Quality - ME 1) Local Authorities Treatment Plant data via web site entry Local Authorities UWWT Discharge Report Chemical data via MSAccess databases

  7. The First Step – A Central Data Repository LA 3 LA 1 EPA LA 2 LA 4 Water Quality date received can be assessed by Agency, processed and reported onwards where required. Data from Agency’s water quality monitoring programmes available to LA’s via CDX Drinking Water Bathing Water Urban Waste Water River Water Quality CDX/CDR acts only as convayer of information Lake Water Quality C&T Water Quality Groundwater Data Hydrometric Data Information on state of water quality in Ireland availabe via Agency’s GIS webservices RBD 1 RBD 3 All data can be uniquely geo referenced for use in national GIS. RBD 2

  8. Synopsis • EDEN - a Central Data Exchange for environmental data • Readily accessible to key stakeholders. • ‘One Stop Shop’ for quality data related to the environment. • Benefit for those involved in projects that come under the Water Framework Directive. • Organisations can then avail of EDEN to download and upload the datasets that they are responsible for and interested in.

  9. Solution - EDEN • Environmental Data Exchange Network • Will build on what is already in existence • Focus on standardised reporting format - XML • Data collection and sharing using web services • EDEN will be used to share data nationally and internationally

  10. Phase 1 Biological Quality Groundwater Quality Lakes Quality River Water Quality Urban Waste Water Drinking Water Quality Bathing Water Quality Groundwater Quantity Costal and Transitional Quality Water Quantity Industrial Discharges Drinking Water Abstraction

  11. Phase 1 Biological Quality Groundwater Quality EDEN Lakes Quality River Water Quality Urban Waste Water Drinking Water Quality Bathing Water Quality Groundwater Quantity Costal and Transitional Quality Water Quantity Industrial Discharges Drinking Water Abstraction

  12. Progressive Integration Groundwater Quality Biological Quality EDEN Lakes Quality River Water Quality Urban Waste Water Drinking Water Quality Bathing Water Quality Groundwater Quantity Costal and Transitional Quality Water Quantity Industrial Discharges Drinking Water Abstraction

  13. A Single Integrated System for Water Data EDEN GIS Rivers, Lakes, Aquifer, C&T Costal and Transitional Biological Quality Lakes River Water Quality Bathing Water Dangerous Substances & Phosphorous Urban Waste Water Water Quantity Drinking Water Industrial Discharges Groundwater Quality Drinking Water Abstraction Groundwater Quantity

  14. Soil Noise Air Waste Water EDEN

  15. TFS/C1 Management LA can enter details of TFS received Allows for improved tracking of Waste EPA can query TFS register and can generate reports WRT waste export etc TFS Register maintained in CDX A similar tracking system might also be established for waste transferred under C1 forms

  16. Complaints Management LA can enter complaints received wrt to their own functions. They can also enter complaints wrt to IPPC and Waste facilities LA notified of comtplaints entered by EPA regarding complaints received relating to LA functions. LA can view/import records EPA can enter complaints regarding IPPC and Waste Industry. Can also enter complaints received regarding LA functions. EPA notified of comtplaints entered by LA’s regarding IPPC and Waste facilities & can view/import records Complaints Register maintained in CDX

  17. Future Elements of EDEN Complaints LA Complaints IPPC and Waste Complaints Water Surface water monitoring data Groundwater Monitoring Data Urban Waste Water Drinking Water Bathing Water Licensee Emissions Data Licence Details Location Class of Industry Emission Limits GIS Air Air Quality Monitoring Data Licensee Emissions Data Enforcement Tracking Farm Management Waste Waste Register TFS Packaging Landfill Reports Public Information Diary/Calander Web Services Noise Statutory Requirments Document Repository

  18. Water Surface water monitoring data Groundwater Monitoring Data Urban Waste Water Drinking Water Bathing Water Licensee Emissions Data Air Air Quality Monitoring Data Licensee Emissions Data Complaints LA Complaints IPPC and Waste Complaints Licence Details Location Class of Industry Emission Limits Waste Waste Register TFS Packaging Landfill Reports Noise Noise Mapping Enforcement Tracking Farm Management Public Information Diary/Calander Internet Statutory Requirments GIS Document Repository EDEN (Portal) Enforcment Statutory Performance Environmental Quality/Data Network Information sharing Reference External Communication

  19. The Vision LA’s CSO DEHLG LGCSB EDEN MI LA LA EEA FSAI EC EPA GSI Ind DOA OSI RBDs OECD

  20. EDEN – 4 Key Functions • Data Gathering • Exchange & Validation • Data Repository • Reporting

  21. XML Extraction

  22. LabInfo Export

  23. Download/Upload

  24. EDEN Verification Report

  25. EDEN Website

  26. Settings

  27. Metadata

  28. Queries

  29. Queries

  30. RBD Labs EDEN System Web Service EPA Database Server Third Party Labs /Orgs Web Service Web Service Data Warehouse DTS – For Links to RBD for EMS – Pull Data from Data Warehouse Web Service Web Server LA Labs EDEN Work Flow

  31. RBD Labs EDEN System EPA Web Service Third Party Labs /Orgs Web Service Web Service Database Server Web Server DTS – For Links to RBD for EMS – Pull Data from Data Warehouse Web Service Data Warehouse LA Labs EDEN Work Flow

  32. User Requirements • Data Quality • Only Certified Data (or QC’d) data will be accepted to EDEN • Data must be certified within the LA’s Local LIMS System to ensure high data reliance • Agreements • System Use Agreements – by all participants

  33. User Requirements cntd. • IT • Internet Access – Environment Sections • Internet Explorer version 6 (or above) • Netscape/Mozilla • LIMS capable of exporting to XML in required Structure • Windows XP SP2 operating System

  34. Benefits • Data gathered via EDEN can benefit the success of the Water Framework Directive :- • RBD Consultants can collect and return Monitoring Data to/from LA’s & EPA • Develop Programme Of Measures • Enhances ability to detect improvements/ deterioration • Improves design of RBMP and EMS

  35. Benefits • Data Quality Standards – Validation, structure, certification, agreement of use - Integrated naming conventions – reduces misinterpretation & confusion • WFD Data Transfer – quicker, easier • Data Dissemination – quicker, easier

  36. Benefits • For LIMS Users - No additional workload to LA’s • Regulatory Returns – Quality, Timeliness • Increase in Data Exchange Openness & Transparency • Future Applications – Public Participation in WFD, Public Awareness

  37. Project Status

  38. Questions? Thank You

More Related