1 / 15

BWD and EoE reporting Overview of main steps

BWD and EoE reporting Overview of main steps. 1st Regional Workshop of ETC/ICM with West Balkan countries 30-31 May 2011, Zagreb, Croatia. Annual BWD reporting introduction. Data dictionary: http://dd.eionet.europa.eu Provides description of all tables and fields

phyre
Download Presentation

BWD and EoE reporting Overview of main steps

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. BWD and EoE reporting Overview of main steps 1st Regional Workshop of ETC/ICM with West Balkan countries 30-31 May 2011, Zagreb, Croatia Event / date: Regional workshop of ETC/ICM, Zagreb, 31.5.2011 Author: Marko Kovačič (IWRS)

  2. Annual BWD reportingintroduction Data dictionary: http://dd.eionet.europa.eu • Provides description of all tables and fields • Latest xls template available for download CDR – Central data repository: http://cdr.eionet.europa.eu • Used for uploading filled xls templates • Upload path: <country> → European Union (EU), obligations →Bathing Water Directive 2006/7/EC Report Important deadlines: • Stations data: before the start of bathing season • Monitoring data: until 31.12. of each year Event / date: Regional workshop of ETC/ICM, Zagreb, 31.5.2011 Author: Marko Kovačič (IWRS)

  3. Example: filling the xls template [1 / 3] • Download the latest template: http://dd.eionet.europa.eu/dataset.jsp?ds_id=2904 • Filled template example: BWQ_SI_2010.xls • BWQD_2006_IdentifiedBW • BWID: Unique identification code of bathing water, must be unique, must start with two letter code of country • BWName: Name of Bathing Water • Longitude_BW, Latitude_BW: Coordinates in ETRS89 format • BWType: 1 existing bathing water, 2 new bathing water, 3 de-listed bathing water • Closed: N bathing water is not closed, YP bathing water is permanently closed, YT bathing water is temporarily closed • BWaterCat:C coastal water, L lake, R river, T transitional water Event / date: Regional workshop of ETC/ICM, Zagreb, 31.5.2011 Author: Marko Kovačič (IWRS)

  4. Example: filling the xls template [2 / 3] • BWQD_2006_SeasonalInfo • BWID: Unique identification code of bathing water, must be unique, must start with two letter code of country • StartDate, EndDate : Start / End date of the bathing season.Format: YYYY-MM-DD • BWQD_2006_MonitoringResults • BWID: Unique identification code of bathing water, must be unique, must start with two letter code of country • SampleDate: Date of sampling. Format: YYYY-MM-DD • ConcIE: Measured concentration of Intestinal Enterococci per sample in "colony forming unit" per 100 ml (cfu/100ml). Zero value is replaced by minimal detection limit. More samples per sampling date are possible. • ConcEC: Measured concentration of Escherichia coli per sample in "colony forming unit" per 100 ml (cfu/100ml). Zero value is replaced by minimal detection limit. More samples per sampling date are possible. Event / date: Regional workshop of ETC/ICM, Zagreb, 31.5.2011 Author: Marko Kovačič (IWRS)

  5. Example: filling the xls template [3 / 3] • BWQD_2006_AbnormalSituations Abnormal situations table contains an event or combination of events impacting on bathing water quality at the location concerned and not expected to occur on average more than once every four years. • BWID: Unique identification code of bathing water, must be unique, must start with two letter code of country • StartDateA, EndDateA: Start / End date of the impact of an abnormal situation. Format: YYYY-MM-DD • BWQD_2006_ShortTermPolut Short term pollution table contains one or more events of short term pollution that occur during the bathing season. Short term pollution means microbiological contamination that has clearly identifiable causes, is not normally expected to affect bathing water quality for more than approximately 72 hours after the bathing water quality is first affected and for which the competent authority has established procedures to predict and deal with. • BWID: Unique identification code of bathing water, must be unique, must start with two letter code of country • StartDateS, EndDateS:Start / End date of short term pollution.Format: YYYY-MM-DD Event / date: Regional workshop of ETC/ICM, Zagreb, 31.5.2011 Author: Marko Kovačič (IWRS)

  6. Example: uploading the template • CDR test site: http://cdrtest.eionet.europa.eu/ reporter / reporter • Browse to: <country> → European Union (EU), obligations • New collection: • Name: Bathing Water Directive 2006/7/EC Report • Obligations: New Bathing Water Directive →Bathing Water Directive 2006/7/EC Report (2x: monitoring, identification) • New envelope: • Name: 2011 Bathing Water Directive 2006/7/EC Report • Activate task • Add file • Release Envelope Event / date: Regional workshop of ETC/ICM, Zagreb, 31.5.2011 Author: Marko Kovačič (IWRS)

  7. BWD status calculation methodology Transition period - 2006/7/EC • number of samples – number of records (samples) for each BW station in new_monitoringresults table • Season length [in days] = EndDate – StartDate • no measurements - no records for a station in new_monitoringresults table • if BWType = 3 THAN status = NULL(Delisted station) • if Closed = Y, YP, YT and BWType!= 3 THAN status = B • if there are no measurements THAN status = NS • ifone parameter is missingTHAN status = NF • If 1st sample > 10 days after season start or 2nd sample > 41 days after season start THAN status = NF • if interval between 2 samples > 41 days THAN status = NF • If season start- 1st sample during the season > 41 days THAN status = NF • If last sample during the season – season end >41 days THAN status = NF • If number of samples < 4 andseason length > 8 weeks (56 days) THAN status = NF • in all other cases, actual status calculation: • ConcIE: • CG: no.of measurements <= 100 / all measurements >= 0.9 • CI: otherwise • ConcEC: • CG: no of measurements <= 100 / all measurements >= 0.8 • CI: no of measurements <= 2000 / all measurements >= 0.95 • NC: otherwise • final status is equal to the WORST status of both parameter statuses Event / date: Regional workshop of ETC/ICM, Zagreb, 31.5.2011 Author: Marko Kovačič (IWRS)

  8. BWD status calculation examples [1/2] ConcIE: • 7 (measurements <= 100) / 7 (all) = 1 • ConcIE status = CG ConcEC: • 6 (measurements <= 100) / 7 (all) = 0,86 • 7 (measurements <= 2000) / 7 (all) = 1 • ConcEC status = CG Status for bathing water: WORST(CG, CG) • Status = CG ConcIE: • 6 (measurements <= 100) / 7 (all) = 0,86 • ConcIE status = CI ConcEC: • 7 (measurements <= 100) / 7 (all) = 1 • 7 (measurements <= 2000) / 7 (all) = 1 • ConcEC status = CG Status for bathing water: WORST(CI, CG) • Status = CI Event / date: Regional workshop of ETC/ICM, Zagreb, 31.5.2011 Author: Marko Kovačič (IWRS)

  9. BWD status calculation examples [2/2] ConcIE: • 7 (measurements <= 100) / 7 (all) = 1 • ConcIE status = CG ConcEC: • 4 (measurements <= 100) / 7 (all) = 0,57 • 7 (measurements <= 2000) / 7 = 1 • ConcEC status = CI Status for bathing water: WORST(CG, CI) • Status = CI ConcIE: • 3 (measurements <= 100) / 4 (all) = 0,75 • ConcIE status = CI ConcEC: • 3 (measurements <= 100) / 4 (all) = 0,75 • 3 (measurements <= 2000) / 4 (all) = 0,75 • ConcEC status = NC Status for bathing water: WORST(CI, NC) • Status = NC Event / date: Regional workshop of ETC/ICM, Zagreb, 31.5.2011 Author: Marko Kovačič (IWRS)

  10. EoE reportingintroduction • Reporting of bathing water quality during bathing season on weekly or bi-weekly intervals • Data is sent by email to ETC/W: bwd@izvrs.si • Template is similar to annual BWD reporting, but simplified, only monitoring table is requested • Country data is processed and then available on Eye On Earth portal: http://www.eyeonearth.eu/ Event / date: Regional workshop of ETC/ICM, Zagreb, 31.5.2011 Author: Marko Kovačič (IWRS)

  11. Example: filling the template • Download the latest template: http://www.izvrs.si/bwd/EoE_SEIS_template_2011.xls • cc: International Country Code (e.g. HU). • BWID: Unique Bathing Water Identification. • BWName: Name of bathing water place. • Longitude_BW, Latitude_BW: Coordinates in decimal degrees in ETRS89 coordinate system with four decimal places (e.g. 32.5547). • SampleDate: Date when the parameter samples were taken (e.g. 10.05.2010). • ConcIE: Concentration of Intestinal enterococci (cfu/100ml). The reference methods of analysis are ISO 7899-1 or 7899-2. • ConcEC: Concentration of Escherichia coli (cfu/100ml). The reference methods of analysis are ISO 9308-3 or ISO 9308-1. Event / date: Regional workshop of ETC/ICM, Zagreb, 31.5.2011 Author: Marko Kovačič (IWRS)

  12. EoE status calculation methodology Methodology for calculating status (directive 2006/7/EC): • if both parameters (ConcIE, ConcEC) are missing then status = 6 (NS) * • if one of parameters is missing then status = 3 (NF) * • if both parameter values are less than GV (ConcIE <= GV && ConcEC <= GV) then status = 1 (CG) • elseif ConcEC value is less than MV (ConcEC <= MV) then status = 5 (CI) • elseif both ConcEC and ConcIE are exceeding MV (ConcEC > MV AND ConcIE > MV) then status = 2 (B) • else status = 4 (NC) • * statuses 3 (NF) and 6 (NS) are not reported for EoE Event / date: Regional workshop of ETC/ICM, Zagreb, 31.5.2011 Author: Marko Kovačič (IWRS)

  13. EoE status calculation examples Event / date: Regional workshop of ETC/ICM, Zagreb, 31.5.2011 Author: Marko Kovačič (IWRS)

  14. Contact information • bwd@izvrs.si – main team email address, best option, all members are informed • lidija.globevnik@izvrs.si – head of ETC/W team • marko.kovacic@izvrs.si – data manager, technical questions • tina.kirn@izvrs.si – content expert on Annual BWD reporting • katarina.zore@izvrs.si – content expert on EoE reporting Event / date: Regional workshop of ETC/ICM, Zagreb, 31.5.2011 Author: Marko Kovačič (IWRS)

  15. Data used in presentation • All examples in this presentation: • IWRS_BWD_and_EoR_reporting_v01.ppt • Current presentation • http://www.izvrs.si/bwd/IWRS_BWD_and_EoR_reporting.ppt • BWQ_SI_2010.xls • Actual annual BWD reporting data for 2010 season from Slovenia • http://cdr.eionet.europa.eu/si/eu/nbwd/envtqnjqa/BWQ_SI_2010.xls • EoE_SEIS_template_2011.xls • Template for EoE reporting • http://www.izvrs.si/bwd/EoE_SEIS_template_2011.xls Event / date: Regional workshop of ETC/ICM, Zagreb, 31.5.2011 Author: Marko Kovačič (IWRS)

More Related