421.005859Serbia44.0165219.5333333Liechtenstein47.166666720.0EU2752.08.01426887512Switzerland47.000158375310.0Norway62.0-18.0Iceland65.0E-PRTR data covering reporting for 2007 to 2010 by EU Member States, Iceland, Liechtenstein, Norway, Serbia and Switzerland. The Access file is an update to the previous version (4.0) and represents the status of the E-PRTR database as of 07 June 2012 which now includes data from Lithuania for 2010 data and an update of their 2008 data. The prevision version of the database (4.0) is provided below for use by countries in association with the informal review feedback files.european-pollutant-release-and-transfer-register-e-prtr-data-base European Pollutant Release and Transfer Register (E-PRTR) - Microsoft Access database and text format E-PRTR data covering reporting for 2007 to 2010 by EU Member States, Iceland, Liechtenstein, Norway, Serbia and Switzerland. The Access file is an update to the previous version (4.0) and represents the status of the E-PRTR database as of 07 June 2012 which now includes data from Lithuania for 2010 data and an update of their 2008 data. The prevision version of the database (4.0) is provided below for use by countries in association with the informal review feedback files. 1002009-11-12T23:17:02Z2010-06-08T07:50:00ZedseFalsesimoensairwastewaterProducts.CMFCore.interfaces._content.IFolderisheea.geotags.storage.interfaces.IGeoTaggedplone.app.folder.bbb.IPhotoAlbumAbleeea.reports.interfaces.IPossibleReportContainereea.epub.subtypes.interfaces.IEPUBAwareAccessControl.interfaces.IPermissionMappingSupportOFS.interfaces.IFolderwebdav.interfaces.IWriteLockplone.app.folder.bbb.IArchivablewebdav.interfaces.IDAVCollectionProducts.CMFCore.interfaces._content.IOpaqueItemManagerplone.portlets.interfaces.ILocalPortletAssignablepersistent.interfaces.IPersistentProducts.CMFCore.interfaces._content.IDynamicTypewebdav.interfaces.IDAVResourceplone.contentrules.engine.interfaces.IRuleAssignableeea.annotator.subtypes.interfaces.IAnnotatorAwareProducts.CMFDynamicViewFTI.interfaces.ISelectableBrowserDefaultplone.app.imaging.interfaces.IBaseObjecteea.uberlisting.browser.app.interfaces.IPossibleUberlistingVieweea.promotion.interfaces.IPromotableeea.facetednavigation.subtypes.interfaces.IPossibleFacetedNavigablecollective.quickupload.interfaces.IQuickUploadCapableeea.dataservice.interfaces.IDatatableAcquisition.interfaces.IAcquirerProducts.CMFPlone.interfaces.constrains.ISelectableConstrainTypesplone.locking.interfaces.ITTWLockableOFS.interfaces.IFindSupportOFS.interfaces.IObjectManagerOFS.interfaces.ICopySourceOFS.interfaces.IPropertyManagerOFS.interfaces.ICopyContainerProducts.EEAContentTypes.interfaces.IEEAPossibleContentarchetypes.schemaextender.interfaces.IExtensibleeea.pdf.subtypes.interfaces.ICollectionPDFAwarewebdav.EtagSupport.EtagBaseInterfaceApp.interfaces.IPersistentExtraplone.app.folder.folder.IATUnifiedFolderProducts.ATContentTypes.interfaces.interfaces.IATContentTypeeea.faceted.inheritance.subtypes.interfaces.IPossibleFacetedHeritorProducts.ATContentTypes.interfaces.folder.IATBTreeFoldereea.alchemy.interfaces.IAlchemyDiscoverableeea.themecentre.interfaces.IPossibleThemeCentreApp.interfaces.IUndoSupportplone.folder.interfaces.IOrderableFolderplone.app.iterate.interfaces.IIterateAwareplone.uuid.interfaces.IUUIDAwareeea.progressbar.interfaces.IBaseObjectProducts.Archetypes.interfaces.base.IBaseObjectProducts.CMFCore.interfaces._content.IWorkflowAwareOFS.interfaces.IOrderedContainerAccessControl.interfaces.IRoleManagerProducts.EEAContentTypes.interfaces.IEEAContentProducts.NavigationManager.sections.interfaces.INavigationSectionPositionableeea.geotags.storage.interfaces.IGeoTaggableProducts.CMFCore.interfaces._content.IContentishAccessControl.interfaces.IOwnedApp.interfaces.INavigationeea.pdf.subtypes.interfaces.IPDFAwareeea.cache.subtypes.interfaces.ICacheAwareeea.themecentre.interfaces.IThemeTaggableProducts.CMFCore.interfaces._content.ICatalogAwareProducts.Archetypes.interfaces.referenceable.IReferenceableOFS.interfaces.IItemProducts.Archetypes.interfaces.metadata.IExtensibleMetadataProducts.CMFCore.interfaces._content.IMutableMinimalDublinCorezope.annotation.interfaces.IAttributeAnnotatableeea.relations.content.interfaces.IBaseObjectProducts.Archetypes.interfaces.base.IBaseFolderOFS.interfaces.ITraversableeea.versions.interfaces.IVersionEnhancedProducts.LinguaPlone.interfaces.ITranslatableeuropean-pollutant-release-and-transfer-register-e-prtr-data-base2012-07-10T12:45:59ZEuropean Pollutant Release and Transfer Register (E-PRTR) - Microsoft Access database and text formatACTIVITY (151944 records)

The table lists all industrial activities that a facility is operating with.

Field name

Field definition

Data type

ActivityID

Primary key. Required.

int

FacilityReportID

Facility report unique identifier

int

FacilityReportName

Name of reporting facility

nvarchar (255)

AnnexIActivityCode

Industrial activity code

nvarchar (255)

AnnexIActivityName

Industrial activity name

nvarchar (255)

AnnexIActivityIPPCCode

Industrial activity IPPC code

nvarchar (255)

RankingNumeric

Importance ranking of respective activity

int

MainActivityIndicator

Indicator whether this activity is the facilities main activity

bit

POLLUTANTRELEASE (151944 records)

The table lists the reported releases of pollutants for a facility. It covers both releases to air, water and land.

Field name

Field definition

Data type

PollutantReleaseID

Primary key. Required.

int

FacilityReportID

Identifies the facility report that the data belongs to. Required.

int

ReleaseMediumCode

Identifies the environmental medium (air, water etc) code

nvarchar(255)

ReleaseMediumName

Identifies the environmental medium name.

nvarchar(255)

PollutantCode

Identifies the pollutant code

nvarchar(255)

PollutantName

Identifies the pollutant name

nvarchar(255)

PollutantGroupCode

Identifies the pollutant group code

nvarchar(255)

PollutantGroupName

Identifies the pollutant group name

nvarchar(255)

PollutantCAS

Pollutant CAS description

nvarchar(20)

MethodBasisCode

Identifies the method basis code of the main method used (M/C/E).

nvarchar(255)

MethodBasisName

Identifies the method basis name of the main method used

nvarchar(255)

TotalQuantity

Total quantity including accidental quantity [t/year]

float

AccidentalQuantity

Accidental quantity [t/year]

float

UnitCode

Identities the unit code of the quantity

nvarchar(255)

UnitName

Identifies the unit name of the quantity

nvarchar(255)

ConfidentialIndicator

Indicates if confidentiality is claimed. Required.

bit

ConfidentialityReasonCode

Identifies the reason code for confidentiality. Required if confidentiality is claimed for mandatory data.

nvarchar(255)

ConfidentialityReasonName

Identifies the reason name for confidentiality. Required if confidentiality is claimed for mandatory data.

nvarchar(255)

POLLUTANTRELEASEMETHODUSED (163038 records)

The table lists the methods used for measuring quantities of pollutant releases.

Field name

Field definition

Data type

PollutantReleaseMethodUsedID

Primary key. Required.

int

PollutantReleaseID

Identifies the pollutant report that the data belongs to. Required.

int

MethodTypeCode

Identifies the method type code

nvarchar(255)

MethodTypeName

Identifies the method type name

nvarchar(255)

MethodDesignation

Identifies the method designation

nvarchar(255)

POLLUTANTTRANSFER (21661 records)

The table lists all reported pollutant transfers for a facility. This covers all releases into waste-water.

Field name

Field definition

Data type

PollutantTransferID

Primary key. Required.

int

FacilityReportID

Identifies the facility report that the data belongs to. Required.

int

PollutantCode

Identifies the pollutant code

nvarchar(255)

PollutantName

Identifies the pollutant name

nvarchar(255)

PollutantGroupCode

Identifies the pollutant group code

nvarchar(255)

PollutantGroupName

Identifies the pollutant group name

nvarchar(255)

PollutantCAS

Pollutant CAS description

nvarchar(255)

MethodBasisCode

Identifies the method basis code of the main method used (M/C/E).

nvarchar(255)

MethodBasisName

Identifies the method basis name of the main method used.

nvarchar(255)

Quantity

Total quantity of reported pollutant [t/year]

float

QuantityUnitCode

Identities the unit code of the quantity

nvarchar(255)

QuantityUnitName

Identifies the unit name of the quantity

nvarchar(255)

ConfidentialIndicator

Indicates if confidentiality is claimed. Required.

bit

ConfidentialityReasonCode

Identifies the reason code for confidentiality. Required if confidentiality is claimed for mandatory data.

nvarchar(255)

ConfidentialityReasonName

Identifies the reason name for confidentiality. Required if confidentiality is claimed for mandatory data.

nvarchar(255)

POLLUTANTTRANSFERMETHODUSED (15409 records)

The table lists the methods used for measuring quantities of pollutant transfers.

Field name

Field definition

Data type

PollutantTransferMethodUsedID

Primary key. Required.

int

PollutantTransferID

Identifies the pollutant report that the data belongs to. Required.

int

MethodTypeCode

Identifies the method type code

nvarchar(255)

MethodTypeName

Identifies the method type name

nvarchar(255)

MethodDesignation

Identifies the method designation

nvarchar(255)

WASTETRANSFER (189714 records)

The table lists the reported data on off-site transfers of waste for a facility, except transfers of pollutants in waste-water, which is stored in the PollutantTransfer table. As for pollutants more than one method could be used for determination of the quantity.

The table lists the reported data for a given facility as part of a PollutantAndTransferReport for a given reporting year. A unique E-PRTR identification of a facility is introduced by FacilityID, which is used to hold track of identical facilities across different reporting years, even though national identifier might have changed.

Field name

Field definition

Data type

FacilityReportID

Primary key. Required.

int

PollutantReleaseAndTransferReportID

Identifies the report that the facility report is a part of. Required.

int

FacilityID

Unique identification of the facility. Required.

int

NationalID

National Identification of the facility. Required.

nvarchar(255)

ParentCompanyName

Name of the parent company, i.e. the company that owns or controls the company operating the facility. Required unless confidentiality is claimed.

nvarchar(255)

FacilityName

Name of the facility (operator or owner)

nvarchar(255)

StreetName

The street name of the facility

nvarchar(255)

BuildingNumber

The building number of the facility

nvarchar(255)

City

Name of city, where facility is located

nvarchar(255)

PostalCode

The postal code of the facility

nvarchar(50)

CountryCode

Country code

nvarchar(255)

CountryName

Country name

nvarchar(255)

Lat

Latitude

float

Long

Longitude

float

RBDGeoCode

Identifies the river basin district code computed by geo-coding

nvarchar(255)

RBDGeoName

Identifies the river basin district name computed by geo-coding

nvarchar(255)

NUTSRegionGeoCode

Identifies the NUTS region code at level 2 computed by geo-coding

nvarchar(255)

NUTSRegionGeoName

Identifies the NUTS region name at level 2 computed by geo-coding

nvarchar(255)

RBDSourceCode

Identifies the river basin district code as reported by the RS

nvarchar(255)

RBDSourceName

Identifies the river basin district name as reported by the RS

nvarchar(255)

NUTSRegionSourceCode

Identifies the NUTS region code as reported by the RS

nvarchar(255)

NUTSRegionSourceName

Identifies the NUTS region name as reported by the RS

nvarchar(255)

NACEMainEconomicActivityCode

Main economic activity Code for NACE reported as NACE Code

nvarchar(255)

NACEMainEconomicActivityName

Main economic activity Name for NACE reported as NACE Code

nvarchar(255)

CompetentAuthorityName

Name of competent authority party

nvarchar(255)

CompetentAuthorityAddressStreetName

Street of competent authority party

nvarchar(255)

CompetentAuthorityAddressBuildingNumber

Building number of competent authority party

nvarchar(255)

CompetentAuthorityAddressCity

City of competent authority party

nvarchar(255)

CompetentAuthorityAddressPostalCode

Postal code of competent authority party

nvarchar(50)

CompetentAuthorityAddressCountryCode

Country code of competent authority party

nvarchar(255)

CompetentAuthorityAddressCountryName

Country name of competent authority party

nvarchar(255)

CompetentAuthorityTelephoneCommunication

Telephone number of competent authority party

nvarchar(50)

CompetentAuthorityFaxCommunication

Fax number of competent authority party

nvarchar(50)

CompetentAuthorityEmailCommunication

Email of competent authority party

nvarchar(255)

CompetentAuthorityContactPersonName

Contact person at competent authority party

nvarchar(255)

ProductionVolumeProductName

Name of primary product

nvarchar(255)

ProductionVolumeQuantity

Production quantity of primary product

float

ProductionVolumeUnitCode

Unit code of quantity

nvarchar(255)

ProductionVolumeUnitName

Unit name of quantity

nvarchar(255)

TotalIPPCInstallationQuantity

The total number of IPPC installations covered by the facility

int

OperatingHours

The number of operating hours in reporting year

int

TotalEmployeeQuantity

Number of employees

int

WebsiteCommunication

The website address of Facility

nvarchar(255)

PublicInformation

Textual information

nvarchar(255)

ConfidentialIndicator

Indicates if confidentiality for mandatory data is claimed or not. Required.

bit

ConfidentialityReasonCode

Identifies the reason Code for confidentiality. Required if confidentiality is claimed for mandatory data.

nvarchar(255)

ConfidentialityReasonName

Identifies the reason Name for confidentiality. Required if confidentiality is claimed for mandatory data.

nvarchar(255)

ProtectVoluntaryData

Indicates if voluntary data should be protected or not

bit

MainIASectorCode

Sector Code of main industrial activity

nvarchar(255)

MainIASectorName

Sector Name of main industrial activity

nvarchar(255)

MainIAActivityCode

Activity Code of main industrial activity

nvarchar(255)

MainIAActivityName

Activity Name of main industrial activity

nvarchar(255)

MainIASubActivityCode

Subactivity Code of main industrial activity

nvarchar(255)

MainIASubActivityName

Subactivity Name of main industrial activity

nvarchar(255)

POLLUTANTRELEASEANDTRANSFERREPORT (169 records)

The table lists common information about a report for a given reporting year. If a country has reported more than once then only the most recent report is shown. A unique E-PRTR identification of a facility is introduced by FacilityID, which is used to hold track of identical facilities across different reporting years, even though national identifier might have changed.

Field name

Field definition

Data type

PollutantReleaseAndTransferReportID

Primary key. Required.

int

CountryCode

The RS Code reporting. Required.

nvarchar(255)

CountryName

The RS Name reporting. Required.

nvarchar(255)

ReportingYear

The calendar year of which data on releases and transfers must be gathered. Required.

int

CoordinateSystemCode

The coordinate system code used in reporting of coordinates.

nvarchar(255)

CoordinateSystemName

The coordinate system name used in reporting of coordinates.

nvarchar(255)

CdrReleased

The time when the report was released in Reportnet.

datetime

Published

The time when the report was released to public view

datetime

FACILITYID_CHANGES (134919 records)

The table lists the correspondance between newest FacilityID's and previous ones, by CountryCode and by ReportingYear

Field name

Field definition

Data type

CountryCode

The RS Code reporting

nvarchar(255)

ReportingYear

The calendar year of which data on releases and transfers must be gathered.