Waterbase-Emissions (5 tables)

Data Table

This page was archived on 25 Aug 2017 with reason: A new version has been published

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-Water and the EEA. Results of quality assessment have been incorporated into the individual data tables.

Data and maps

Menu

Category

European data

Table definition

Spatial Unit Characteristics and Pressures (Waterbase_emissions_v2_Spatial_units, 437 records)

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

Field name	Definition	Note	data type
RecordID	Unique record identifier		long
RecordReported	Date when the record was reported by the data provider.		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country	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(100)
SUcode	National identification code of spatial unit		text(100)
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(20)
RBDname	Name of the River Basin District.		text(150)
SUarea	Area of the spatial unit in km2.		decimal
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.		decimal
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.		decimal
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 Emission Discharges from Point Sources (Waterbase_emissions_v2_Nutrients_Points, 12032 records)

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

Field name	Definition	Note	data type
RecordID	Unique record identifier		long
RecordReported	Date when the record was reported by the data provider.		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country	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(100)
SUcode	National identification code of spatial unit		text(100)
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. <= 10 000; U13 - Urban Waste Water Untreated Discharges 10 000 > p.e.<= 100 000; U14 - Urban Waste Water Untreated Discharges > 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. <= 10 000; U23 - Urban Waste Water Treated Discharges 10 000 > p.e.<= 100 000; U24 - Urban Waste Water Treated Discharges > 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.		decimal
QA_station_issues	Quality assessment field - stations data quality issues flag	List of codes of spatial unit 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 Emission Discharges from Diffuse Sources (Waterbase_emissions_v2_Nutrients_Diffuse, 968 records)

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

Field name	Definition	Note	data type
RecordID	Unique record identifier		long
RecordReported	Date when the record was reported by the data provider.		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country	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(100)
SUcode	National identification code of spatial unit		text(100)
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
SourceDiffEmission	Source of diffuse emissions.	NP - Total Diffuse Emissions to Inland Waters; NP1 - Agricultural Emissions; NP2 - Atmospheric Deposition; NP3 - Un-Connected Dwellings Emissions; NP4 - Urban Diffuse Emissions - Refers only to those emissions of pollutants in urban runoff that are not connected to a collecting system; NP5 - Storm Overflow Emissions - Refers to discharges/emissions to a receiving water following exceedance of the storage capacity of the collecting/treatment system during heavy 'storm' rainfall; NP6 - Abandoned Industrial Site Emissions; NP7 - Other Diffuse Emissions; NP8 - Background Emissions	text(50)
Emission	Emission of nutrients and organic matter in tonnes/year.		decimal
QA_station_issues	Quality assessment field - stations data quality issues flag	List of codes of spatial unit 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_v2_HazSubs_Points, 14311 records)

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

Field name	Definition	Note	data type
RecordID	Unique record identifier		long
RecordReported	Date when the record was reported by the data provider.		text(10)
CountryCode	Abbreviation of EEA Member or Collaborating Country	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(100)
SUcode	National identification code of spatial unit		text(100)
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. <= 10 000; U13 - Urban Waste Water Untreated Discharges 10 000 > p.e.<= 100 000; U14 - Urban Waste Water Untreated Discharges > 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. <= 10 000; U23 - Urban Waste Water Treated Discharges 10 000 > p.e.<= 100 000; U24 - Urban Waste Water Treated Discharges > 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.		decimal
QA_station_issues	Quality assessment field - stations data quality issues flag	List of codes of spatial unit 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_v2_HazSubs_Diffuse, 769 records)

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

Field name	Definition	Note	data type
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	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(100)
SUcode	National identification code of spatial unit		text(100)
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
SourceDiffEmission	Source of diffuse emissions.	NP - Total Diffuse Emissions to Inland Waters; NP1 - Agricultural Emissions; NP2 - Atmospheric Deposition; NP3 - Un-Connected Dwellings Emissions; NP4 - Urban Diffuse Emissions - Refers only to those emissions of pollutants in urban runoff that are not connected to a collecting system; NP5 - Storm Overflow Emissions - Refers to discharges/emissions to a receiving water following exceedance of the storage capacity of the collecting/treatment system during heavy 'storm' rainfall; NP6 - Abandoned Industrial Site Emissions; NP7 - Other Diffuse Emissions; NP8 - Background Emissions	text(50)
Emission	Emission of hazardous substance emissions in kg/year.		decimal
QA_station_issues	Quality assessment field - stations data quality issues flag	List of codes of spatial unit 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