mark gibbs | nrc meeting | 13th june streamlining of...
TRANSCRIPT
![Page 1: Mark Gibbs | NRC Meeting | 13th June Streamlining of ...eionet.kormany.hu/download/2/31/42000/streamilining.pdf · Thematic reporting ... • Currently under review in testing phase](https://reader033.vdocuments.us/reader033/viewer/2022050110/5f483ba6e4f38e4aad3804d8/html5/thumbnails/1.jpg)
Streamlining of Industrial Reporting
Integrated E-PRTR + LCP Reporting
Mark Gibbs | NRC Meeting | 13th June
![Page 2: Mark Gibbs | NRC Meeting | 13th June Streamlining of ...eionet.kormany.hu/download/2/31/42000/streamilining.pdf · Thematic reporting ... • Currently under review in testing phase](https://reader033.vdocuments.us/reader033/viewer/2022050110/5f483ba6e4f38e4aad3804d8/html5/thumbnails/2.jpg)
Thematic reporting – Data model
Contextual
LCP E-PRTR
![Page 3: Mark Gibbs | NRC Meeting | 13th June Streamlining of ...eionet.kormany.hu/download/2/31/42000/streamilining.pdf · Thematic reporting ... • Currently under review in testing phase](https://reader033.vdocuments.us/reader033/viewer/2022050110/5f483ba6e4f38e4aad3804d8/html5/thumbnails/3.jpg)
Thematic reporting – Links to the EU Registry
LCP thematic data reported at this level
E-PRTR thematic data reported at this level
Facility INSPIRE ID
Installation Part INSPIRE ID
Administrative Data
Thematic(Emissions) Data
Site 1
Site INSPIRE ID
Facility 1
Facility INSPIRE ID
Facility 2
Facility INSPIRE ID
Installation 1
Installation INSPIRE ID
Installation
Part 1
Installation part INSPIRE ID
![Page 4: Mark Gibbs | NRC Meeting | 13th June Streamlining of ...eionet.kormany.hu/download/2/31/42000/streamilining.pdf · Thematic reporting ... • Currently under review in testing phase](https://reader033.vdocuments.us/reader033/viewer/2022050110/5f483ba6e4f38e4aad3804d8/html5/thumbnails/4.jpg)
Documentation
Data model documentation QA Logic Manual for Reporters
Purpose: Development
and detail of data model
contents
Purpose: Details of
complex automated
checks in place in the CDR
Purpose: Information on how
attributes should be populated,
the data model, and reporting
process
![Page 5: Mark Gibbs | NRC Meeting | 13th June Streamlining of ...eionet.kormany.hu/download/2/31/42000/streamilining.pdf · Thematic reporting ... • Currently under review in testing phase](https://reader033.vdocuments.us/reader033/viewer/2022050110/5f483ba6e4f38e4aad3804d8/html5/thumbnails/5.jpg)
IT tools – Access template
Access template
• Access template provides an accessible route for reporting
• When combined with the conversion service, this provides a route where the reporter needn’t generate XML
• Populated example is provided to guide reporting
• Available on the project website: http://cdrtest.eionet.europa.eu/help/eprtr_lcp
![Page 6: Mark Gibbs | NRC Meeting | 13th June Streamlining of ...eionet.kormany.hu/download/2/31/42000/streamilining.pdf · Thematic reporting ... • Currently under review in testing phase](https://reader033.vdocuments.us/reader033/viewer/2022050110/5f483ba6e4f38e4aad3804d8/html5/thumbnails/6.jpg)
IT tools – Conversion service
• Online service to be used in conjunction with Access template
• Enables the transformation of Access database into XML schema structure to be uploaded to CDR
• Ensures schema is adhered to
• Available on the project website: http://cdrtest.eionet.europa.eu/help/eprtr_lcp
Conversion
service
XML
![Page 7: Mark Gibbs | NRC Meeting | 13th June Streamlining of ...eionet.kormany.hu/download/2/31/42000/streamilining.pdf · Thematic reporting ... • Currently under review in testing phase](https://reader033.vdocuments.us/reader033/viewer/2022050110/5f483ba6e4f38e4aad3804d8/html5/thumbnails/7.jpg)
IT tools – QA modules
• Two quality assurance modules perform a series of checks on submissions in CDR, details of which can be found in the QA Logic Manual
• QA#1 – Ensures compliance with schema
• QA#2 – More detailed checks on reporting requirements and consistency
• Currently under review in testing phase
QA modules
![Page 8: Mark Gibbs | NRC Meeting | 13th June Streamlining of ...eionet.kormany.hu/download/2/31/42000/streamilining.pdf · Thematic reporting ... • Currently under review in testing phase](https://reader033.vdocuments.us/reader033/viewer/2022050110/5f483ba6e4f38e4aad3804d8/html5/thumbnails/8.jpg)
IT tools – Harvesting
Harvesting
XML #1
XML #2
XML #3XML #4
• Harvesting refers to the process of combining multiple XML submissions to create public data products
• This tool is still in development, but is managed by the EEA
• More details will become available later in the year, as the tool is developed
![Page 9: Mark Gibbs | NRC Meeting | 13th June Streamlining of ...eionet.kormany.hu/download/2/31/42000/streamilining.pdf · Thematic reporting ... • Currently under review in testing phase](https://reader033.vdocuments.us/reader033/viewer/2022050110/5f483ba6e4f38e4aad3804d8/html5/thumbnails/9.jpg)
Testing phase
CDR test site
• Member states may now test the submission process.
• Testing will run from June – August.
• The EEA & ETC will provide bilateral support.
• Member states are encouraged to use large, complete datasets in order to get the most benefit out of testing.
• Webinar recording: http://cdrtest.eionet.europa.eu/help/eprtr_lcp/Guidance/Webinar%203%20Recording.mp4
![Page 10: Mark Gibbs | NRC Meeting | 13th June Streamlining of ...eionet.kormany.hu/download/2/31/42000/streamilining.pdf · Thematic reporting ... • Currently under review in testing phase](https://reader033.vdocuments.us/reader033/viewer/2022050110/5f483ba6e4f38e4aad3804d8/html5/thumbnails/10.jpg)
CLRTAP/NECD LPS Reporting
• Large point source reporting is required every four years from 2017 onwards
• Scope overlaps with E-PRTR as it references Annex II
• Stack height and PM2.5 + BC has been added to the data model/code lists, to help Member states fulfil this obligation through this reporting
![Page 11: Mark Gibbs | NRC Meeting | 13th June Streamlining of ...eionet.kormany.hu/download/2/31/42000/streamilining.pdf · Thematic reporting ... • Currently under review in testing phase](https://reader033.vdocuments.us/reader033/viewer/2022050110/5f483ba6e4f38e4aad3804d8/html5/thumbnails/11.jpg)
Mapping historical data -
0
10
20
30
40
50
60
70
2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018
Facility A Facility B Facility 1 Facility 2
Historical mapping • The existing data reported previously under the E-PRTR and LCP reporting will be mapped once data becomes available
• This process will require the input of member states to ensure data is mapped correctly
![Page 12: Mark Gibbs | NRC Meeting | 13th June Streamlining of ...eionet.kormany.hu/download/2/31/42000/streamilining.pdf · Thematic reporting ... • Currently under review in testing phase](https://reader033.vdocuments.us/reader033/viewer/2022050110/5f483ba6e4f38e4aad3804d8/html5/thumbnails/12.jpg)
Post Submission-
All member state submissions will be ‘harvested’ and integrated into a European wide dataset. A
public-facing version will also be created, which will remove the requested as confidential.
Submission
harvesting
MS 1
MS 2
MS 3
MS 4
MS N
Integration
into
database
EEA internal data
set
Co
nfid
en
tia
lity filt
er
Public
facing
dataset
Thematic
Data
Other
public data
products
EU Registry
Combined
dataset
![Page 13: Mark Gibbs | NRC Meeting | 13th June Streamlining of ...eionet.kormany.hu/download/2/31/42000/streamilining.pdf · Thematic reporting ... • Currently under review in testing phase](https://reader033.vdocuments.us/reader033/viewer/2022050110/5f483ba6e4f38e4aad3804d8/html5/thumbnails/13.jpg)
Expected Public data products
Thematic Access database Thematic Excel summaryIntegrated EU Registry/Thematic
Access database
• Contains only thematic data on E-
PRTR and LCPs
• Streamlined dataset for timeseries
and pollutant totals
• Contains only thematic data on
E-PRTR and LCPs
• Excel format for easy access/analysis
• Full combined dataset with all
thematic and administrative data
• Contains queries to replicate E-PRTR
or LCP reporting format.
![Page 14: Mark Gibbs | NRC Meeting | 13th June Streamlining of ...eionet.kormany.hu/download/2/31/42000/streamilining.pdf · Thematic reporting ... • Currently under review in testing phase](https://reader033.vdocuments.us/reader033/viewer/2022050110/5f483ba6e4f38e4aad3804d8/html5/thumbnails/14.jpg)
Thematic Access database
Thematic Access database
Based on Access template
![Page 15: Mark Gibbs | NRC Meeting | 13th June Streamlining of ...eionet.kormany.hu/download/2/31/42000/streamilining.pdf · Thematic reporting ... • Currently under review in testing phase](https://reader033.vdocuments.us/reader033/viewer/2022050110/5f483ba6e4f38e4aad3804d8/html5/thumbnails/15.jpg)
Combined integrated Access database
EU Registry/Thematic integrated Access database
Combined dataset joining together administrative and
thematic data.
ProductionFacility
ProductionInstallationPart (LCPs)
ProductionInstallation
productionFacility_LocalId
productionInstallation_LocalI
d
productionFacility_LocalId
pointGeometryLAT
pointGeometryLONG
pollutantRelease
offsitePollutantTransfer
pollutantTransfer
numberOfEmployees
EPRTRAnnexIType
Etc…..
productionInstallationPart_LocalId
productionInstallation_LocalI
d
totalRatedThermalInput
pointGeometryLAT
pointGeometryLONG
emissionsToAir
energyInput
numberOfOperatingHours
combustionPlantCategory
Etc…..Key:
Thematic attributes
EU Registry attributes