Personal tools

Notifications
Get notifications on new reports and products. Frequency: 3-4 emails / month.
Subscriptions
Sign up to receive our reports (print and/or electronic) and quarterly e-newsletter.
Follow us
Twitter icon Twitter
Facebook icon Facebook
YouTube icon YouTube channel
RSS logo RSS Feeds
More

Write to us Write to us

For the public:


For media and journalists:

Contact EEA staff
Contact the web team
FAQ

Call us Call us

Reception:

Phone: (+45) 33 36 71 00
Fax: (+45) 33 36 71 99


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 (5 tables)

Waterbase-Emissions (5 tables)

Note: new version is available!
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.
Category
European data
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
Files

Geographical coverage

[+] Show Map

Document Actions

Comments

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