Personal tools

next
previous
items

Skip to content. | Skip to navigation

Sound and independent information
on the environment

You are here: Home / Data and maps / Datasets / Waterbase - Emissions to water

Waterbase - Emissions to water

Note: new version is available!
Topics: ,
Emissions to water are an important element (describing the pressure) in assessment of the state of Europe’s environment (SoE). This database contains data on emissions of nutrients and hazardous substances to water, aggregated within River Basin Districts (RBDs), in the EEA member countries. The reporting process, endorsed by the Water Directors, and this publication of the data, enables all stakeholders to use the data and contributes to streamlining with other reporting processes.

European data

Waterbase-Emissions (5 tables)

Dataset contains data selected from reporting of member and collaborating countries on emissions of nutrients and hazardous substances to water, aggregated within River Basin Districts. Reported data have been assessed and processed by the ETC/ICM and the EEA. Results of quality assessment have been incorporated into the individual data tables. ***WARNING:*** Records, where errors and other quality issues and inconsistencies have been detected, have been removed from the dataset only in the most severe cases (missing primary key values, duplicates...). The other "problematic" records are left in. Each data table contains a set of special QA fields which are used to flag the particular quality issues detected in the individual records. The QA fields and flag codes are described in the QA documentation.

[+] Show table definition

Spatial Unit Characteristics and Pressures (Waterbase_emissions_v4_Spatial_units, 569 records)

Physical characteristics and proxy pressures on spatial units used (River basin Districts, sub-units or water bodies).

FieldNameDefinitionNoteDataType
RecordID Unique record identifier long
RecordReported Date when the records was reported by the data provider text(10)
CountryCode Abbreviation of EEA Member or Collaborating Country from which territory the data come from. ISO 3166-1-alpha-2 code elements text(2)
Waterbase_SUcode Internally produced, unique, Waterbase compatible identifier of the spatial unit. [CountryCode] + "_EW_" + [SUcode] text(70)
SUcode National identification code of spatial unit text(64)
SUname National name of the spatial unit text(255)
SUcategory Spatial unit category code. CW - Coastal Water Body, GW - Groundwater Body, RBD - National part of a River Basin District, SU - Sub-Unit of an RBD, SWL - Surface Water Body - category Lake, SWR - Surface Water Body - category River, TW - Transitional Water Body text(3)
SubUnitCode National identification code of Sub-Unit. text(50)
SubUnitName National name of the Sub-Unit in which water body is located. text(255)
RBDcode River Basin District Code text(50)
RBDname Name of the River Basin District. text(150)
SUarea Area of the spatial unit in km2. single
PermanentPopulationNumber Population number of the spatial unit. long
MaximumPopulationNumber Maximum Population number of the spatial unit. long
LongTermIntFlow Total volume of river run-off and groundwater generated, in natural conditions, exclusively by precipitation into a territory, in millions of cubic meters. single
PeriodLongTermIntFlow The year or range of years to which the long term mean internal flow data applies. text(9)
AnnualIntFlow Total annual mean volume of river run-off and groundwater generated, in natural conditions, exclusively by precipitation into a territory, in millions of cubic meters. single
PeriodYears The year or range of years to which this data applies. text(9)
QA_DDviolations Quality assessment field - data definition errors List of field names and their values where values that do not follow the official specifications. Details are explained in the QA documentation. memo

Nutrients and Organic Matter Emission Discharges from Point Sources (Waterbase_emissions_v4_Nutrients_Points, 16099 records)

Annual emission of nutrients and organic matter from point sources (discharges) to rivers and lakes.

FieldNameDefinitionNoteDataType
RecordID Unique record identifier long
RecordReported Date when the records was reported by the data provider text(10)
CountryCode Abbreviation of EEA Member or Collaborating Country from which territory the data come from. ISO 3166-1-alpha-2 code elements text(2)
Waterbase_SUcode Internally produced, unique, Waterbase compatible identifier of the spatial unit. [CountryCode] + "_EW_" + [SUcode] text(70)
SUcode National identification code of spatial unit text(64)
SUname National name of the spatial unit text(255)
SUcategory Spatial unit category code. CW - Coastal Water Body, GW - Groundwater Body, RBD - National part of a River Basin District, SU - Sub-Unit of an RBD, SWL - Surface Water Body - category Lake, SWR - Surface Water Body - category River, TW - Transitional Water Body text(3)
PeriodYears The year or range of years to which this data applies. text(9)
Determinand_Nutrients Name of nutrient, organic matter or general physico-chemical determinand. text(50)
CASNumber Chemical Abstract Service Number of the hazardous substance or other chemical determinand. text(64)
DeterminandCode Internal identification number of the determinand monitored long
SourcePointEmission Source of point emissions. D0 - Direct Discharges to Coastal and Transitional Water total; G7 - Point Sources to Groundwater total; I - Industrial Waste Water Discharges total; I3 - Industrial Waste Water Treated Discharges - Refers only to the discharge of treated industrial waste water from independently operated industrial WWTPs and not that discharged from municipal treatment plants; I4 - Industrial Waste Water Untreated Discharges - Refers to discharges of industrial wastewater that remain untreated; O - Other Waste Water Discharges total; O5 - Other Waste Water Treated Discharges; O6 - Other Waste Water Untreated Discharges; PT - Point Sources to Inland Surface Water total; R - Riverine Input to Coastal Water; U - Urban Waste Water Discharges total; U1 - Urban Waste Water Untreated Discharges total - Refers to municipal wastewater that is collected but discharged without treatment; U11 - Urban Waste Water Untreated Discharges < 2 000 p.e.; U12 - Urban Waste Water Untreated Discharges 2 000 >= p.e.p.e.100 000 p.e.; U2 - Urban Waste Water Treated Discharges total - Refers to the discharge of municipal waste water following treatment in an UWWTP. Such wastewater may have come originally from domestic and industrial sources. In addition, it includes any urban runoff, generated during rainfall, which is collected and directed to a treatment plant. Ideally, such treated discharges should not include stormflows that exceed the storage capacity of the system.; U21 - Urban Waste Water Treated Discharges < 2 000 p.e.; U22 - Urban Waste Water Treated Discharges 2 000 >= p.e.p.e.100 000 p.e. text(3)
EPRTRfacilities Information whether the Emission value is from E-PRTR Facilities or from non-E-PRTR Facilities or from both together. text(4)
Emission Emission of nutrients and organic matter in tonnes/year. single
MethodEmissionsPointSources Method of point sources emission load quantification. text(20)
emissions_DataSource Citation or reference to the source of the emission data text(255)
Remarks Remarks, comments or explanatory notes text(255)
QA_MVissues Quality assessment field - main meassurement value issue flag. A code identifying an issue or an error in the main meassurement value of the record. Details are explained in the QA documentation. long
QA_LRviolations Quality assessment field - list of logical rules violations. List of codes of logical rules violated by record. Details are explained in the QA documentation. text(150)
QA_station_issues Quality assessment field - stations data quality issues flag List of codes of station data issues detected in the record. Details are explained in the QA documentation. text(100)
QA_DDviolations Quality assessment field - data definition errors List of field names and their values where values that do not follow the official specifications. Details are explained in the QA documentation. memo

Nutrients and Organic Matter Emissions from Diffuse Sources (Waterbase_emissions_v4_Nutrients_Diffuse, 1436 records)

Annual emission of nutrients and organic matter from diffuse sources to rivers and lakes.

FieldNameDefinitionNoteDataType
RecordID Unique record identifier long
RecordReported Date when the records was reported by the data provider text(10)
CountryCode Abbreviation of EEA Member or Collaborating Country from which territory the data come from. ISO 3166-1-alpha-2 code elements text(2)
Waterbase_SUcode Internally produced, unique, Waterbase compatible identifier of the spatial unit. [CountryCode] + "_EW_" + [SUcode] text(70)
SUcode National identification code of spatial unit text(64)
SUname National name of the spatial unit text(255)
SUcategory Spatial unit category code. CW - Coastal Water Body, GW - Groundwater Body, RBD - National part of a River Basin District, SU - Sub-Unit of an RBD, SWL - Surface Water Body - category Lake, SWR - Surface Water Body - category River, TW - Transitional Water Body text(3)
PeriodYears The year or range of years to which this data applies. text(9)
Determinand_Nutrients Name of nutrient, organic matter or general physico-chemical determinand. text(50)
CASNumber Chemical Abstract Service Number of the hazardous substance or other chemical determinand. text(64)
DeterminandCode Internal identification number of the determinand monitored long
Emission Emission of nutrients and organic matter in tonnes/year. single
MethodEmissionsDiffuseSources Method of diffuse sources emission load quantification. text(9)
emissions_DataSource Citation or reference to the source of the emission data text(255)
Remarks Remarks, comments or explanatory notes text(255)
QA_MVissues Quality assessment field - main meassurement value issue flag. A code identifying an issue or an error in the main meassurement value of the record. Details are explained in the QA documentation. long
QA_LRviolations Quality assessment field - list of logical rules violations. List of codes of logical rules violated by record. Details are explained in the QA documentation. text(150)
QA_station_issues Quality assessment field - stations data quality issues flag List of codes of station data issues detected in the record. Details are explained in the QA documentation. text(100)
QA_DDviolations Quality assessment field - data definition errors List of field names and their values where values that do not follow the official specifications. Details are explained in the QA documentation. memo

Hazardous Substances Emission Discharges from Point Sources (Waterbase_emissions_v4_HazSubs_Points, 21208 records)

Annual emission of hazardous substances from point sources (discharges) to rivers and lakes.

FieldNameDefinitionNoteDataType
RecordID Unique record identifier long
RecordReported Date when the records was reported by the data provider text(10)
CountryCode Abbreviation of EEA Member or Collaborating Country from which territory the data come from. ISO 3166-1-alpha-2 code elements text(2)
Waterbase_SUcode Internally produced, unique, Waterbase compatible identifier of the spatial unit. [CountryCode] + "_EW_" + [SUcode] text(70)
SUcode National identification code of spatial unit text(64)
SUname National name of the spatial unit text(255)
SUcategory Spatial unit category code. CW - Coastal Water Body, GW - Groundwater Body, RBD - National part of a River Basin District, SU - Sub-Unit of an RBD, SWL - Surface Water Body - category Lake, SWR - Surface Water Body - category River, TW - Transitional Water Body text(3)
PeriodYears The year or range of years to which this data applies. text(9)
Determinand_HazSubs Name of hazardous substance or other chemical determinand. text(150)
CASNumber Chemical Abstract Service Number of the hazardous substance or other chemical determinand. text(64)
DeterminandCode Internal identification number of the determinand monitored long
SourcePointEmission Source of point emissions. D0 - Direct Discharges to Coastal and Transitional Water total; G7 - Point Sources to Groundwater total; I - Industrial Waste Water Discharges total; I3 - Industrial Waste Water Treated Discharges - Refers only to the discharge of treated industrial waste water from independently operated industrial WWTPs and not that discharged from municipal treatment plants; I4 - Industrial Waste Water Untreated Discharges - Refers to discharges of industrial wastewater that remain untreated; O - Other Waste Water Discharges total; O5 - Other Waste Water Treated Discharges; O6 - Other Waste Water Untreated Discharges; PT - Point Sources to Inland Surface Water total; R - Riverine Input to Coastal Water; U - Urban Waste Water Discharges total; U1 - Urban Waste Water Untreated Discharges total - Refers to municipal wastewater that is collected but discharged without treatment; U11 - Urban Waste Water Untreated Discharges < 2 000 p.e.; U12 - Urban Waste Water Untreated Discharges 2 000 >= p.e.p.e.100 000 p.e.; U2 - Urban Waste Water Treated Discharges total - Refers to the discharge of municipal waste water following treatment in an UWWTP. Such wastewater may have come originally from domestic and industrial sources. In addition, it includes any urban runoff, generated during rainfall, which is collected and directed to a treatment plant. Ideally, such treated discharges should not include stormflows that exceed the storage capacity of the system.; U21 - Urban Waste Water Treated Discharges < 2 000 p.e.; U22 - Urban Waste Water Treated Discharges 2 000 >= p.e.p.e.100 000 p.e. text(3)
EPRTRfacilities Information whether the Emission value is from E-PRTR Facilities or from non-E-PRTR Facilities or from both together. text(4)
Emission Emission of hazardous substance emissions in kg/year. single
MethodEmissionsPointSources Method of point sources emission load quantification. text(20)
emissions_DataSource Citation or reference to the source of the emission data text(255)
Remarks Remarks, comments or explanatory notes text(255)
QA_MVissues Quality assessment field - main meassurement value issue flag. A code identifying an issue or an error in the main meassurement value of the record. Details are explained in the QA documentation. long
QA_LRviolations Quality assessment field - list of logical rules violations. List of codes of logical rules violated by record. Details are explained in the QA documentation. text(150)
QA_station_issues Quality assessment field - stations data quality issues flag List of codes of station data issues detected in the record. Details are explained in the QA documentation. text(100)
QA_DDviolations Quality assessment field - data definition errors List of field names and their values where values that do not follow the official specifications. Details are explained in the QA documentation. memo

Hazardous Substances Emissions from Diffuse Source (Waterbase_emissions_v4_HazSubs_Diffuse, 2373 records)

Annual emission of hazardous substances from diffuse sources to rivers and lakes.

FieldNameDefinitionNoteDataType
RecordID Unique record identifier long
RecordReported Date when the records was reported by the data provider text(10)
CountryCode Abbreviation of EEA Member or Collaborating Country from which territory the data come from. ISO 3166-1-alpha-2 code elements text(2)
Waterbase_SUcode Internally produced, unique, Waterbase compatible identifier of the spatial unit. [CountryCode] + "_EW_" + [SUcode] text(70)
SUcode National identification code of spatial unit text(64)
SUname National name of the spatial unit text(255)
SUcategory Spatial unit category code. CW - Coastal Water Body, GW - Groundwater Body, RBD - National part of a River Basin District, SU - Sub-Unit of an RBD, SWL - Surface Water Body - category Lake, SWR - Surface Water Body - category River, TW - Transitional Water Body text(3)
PeriodYears The year or range of years to which this data applies. text(9)
Determinand_HazSubs Name of hazardous substance or other chemical determinand. text(150)
CASNumber Chemical Abstract Service Number of the hazardous substance or other chemical determinand. text(64)
DeterminandCode Internal identification number of the determinand monitored long
Emission Emission of hazardous substance emissions in kg/year. single
MethodEmissionsDiffuseSources Method of diffuse sources emission load quantification. text(9)
emissions_DataSource Citation or reference to the source of the emission data text(255)
Remarks Remarks, comments or explanatory notes text(255)
QA_MVissues Quality assessment field - main meassurement value issue flag. A code identifying an issue or an error in the main meassurement value of the record. Details are explained in the QA documentation. long
QA_LRviolations Quality assessment field - list of logical rules violations. List of codes of logical rules violated by record. Details are explained in the QA documentation. text(150)
QA_station_issues Quality assessment field - stations data quality issues flag List of codes of station data issues detected in the record. Details are explained in the QA documentation. text(100)
QA_DDviolations Quality assessment field - data definition errors List of field names and their values where values that do not follow the official specifications. Details are explained in the QA documentation. memo

Additional information

Tables metadata

Field description of all data tables.

Code lists

Lists and description of codes of fields present in the emission data tables

QA documentation

Quality control documentation briefly presents ETC-ICM and EEA activities focused on quality of Waterbase-Emissions to water dataset and results of these activities.

Metadata

 
Document Actions
European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100