– or –
Please login or register to participate.
Dlevedag Feb 08, 2017 12:19 PM
Hey, there seems to be an error/missing Data in the E-PRTR dataset.

As I need the full information for the research project I am working on it would be nice to have the full dataset.

The problem I have lies in "eprtr_v10_csv.zip" -> eprtr_v10_csv\FullCS\dbo.FULL_POLLUTANTRELEASE.csv
It's only 16KB in Size and there is no real data (or rather lots of empty columns) inside. However, in dbo.PUBLISH_POLLUTANTRELEASE.csv the data is there, so.. is that intentional or is that an error?

Thanks in advance for the answer
Best regards
Replies (4)
Dlevedag Feb 09, 2017 10:52 AM
And also, I would be glad if you could clear up some things for me, regarding the classifications.
Example, from the Public_FacilityReport:
FacilityReport ID: 778753
MainIAActivityCode: 7.(a).(ii) [raising of poultry]
NaceActivityCode: A.01.11 [Growing of cereals (except rice), leguminous crops and oil seeds]

I mean.. huh? And this is not a singular issue, this discrepancies are common amongst intensive livestock producers - even though these facilityreportIDs are (according to pollutantrelease.csv) emitting NH3, which would support the livestock hypothesis.

Thank you for your good work on documenting emissions and I hope you are able to help me
EEA Feb 15, 2017 02:10 PM
Dear Dlevedag,

Many thanks for pointing out this error, it has now been corrected.

Regarding your second question:

NACE codes indicate a broad economic classification. The other code stated (MainIAActivityCode) refers to the reason why the reporter is actually reporting under E-PRTR. From an environmental perspective this second code is therefore more reliable. In terms of the example used (FacilityReport ID: 778753), the PRTR website shows that the facility is indeed raising poultry (http://prtr.ec.europa.eu/#/[…]8351&ReportingYear=2014). This coincides well with the MainIAActivityCode: 7.(a).(ii) [raising of poultry].

I hope this is helpful.

Kind regards,
Dlevedag Feb 16, 2017 03:54 PM
Thanks a lot for fixing the issue so quickly and for giving a quick answer!

While I'm at it, a new question has popped up:
In the datasets there are CO2 Emissions and CO2 Emissions excluding biomass,
IA Code: 3.(b) Opencast mining and quarrying
Total CO2 Emissions 2014: 2095000 t
Total CO2 (excluding Biomass) Emissions 2014: 223000 t
So, how exactly are 90% of CO2 emissions of opencast mining and quarrying biomass related? Is this counting for the destroyed forests/carbon sinks or what?

whereby the question I want to ask is: How exactly are "CO2 Emissions excluding biomass" defined? Seeing as I cannot for the life of me seem to find a satisfactory definition of this term :/ (Only thing I found was a taskman project, talking about enabling this option in the database, 7yrs ago..)

Again, I would be very glad and utmost thankful to you if you could elaborate what is exactly meant by that term.

EEA Feb 24, 2017 08:50 AM
Dear Dlevedag,

Your question has been forwarded to our experts. We will get back to you as soon as possible.

Kind regards,