Waterbase-Emissions (5 tables)

Data Table

This is an old version, kept for reference only.

Go to latest version

This page was archived on 11 Oct 2016 with reason: Other (New version data-and-maps/data/waterbase-emissions-5/waterbase-emissions-5-tables was 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/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.

Data and maps

Menu

Category

European data

Table definition

Spatial Unit Characteristics and Pressures (Waterbase_emissions_v5_Spatial_units, 247 records)

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

FieldName	Definition	Note	DataType
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(70)
SUname	National name of the spatial unit		text(255)
SUcategory	Spatial unit category code.	CC - Country, RBD - National part of a River Basin District, SU - Sub-Unit of an RBD	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_v5_Nutrients_Points, 13845 records)

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

FieldName	Definition	Note	DataType
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(70)
SUname	National name of the spatial unit		text(255)
SUcategory	Spatial unit category code.	CC - Country, RBD - National part of a River Basin District, SU - Sub-Unit of an RBD	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_v5_Nutrients_Diffuse, 1727 records)

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

FieldName	Definition	Note	DataType
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(70)
SUname	National name of the spatial unit		text(255)
SUcategory	Spatial unit category code.	CC - Country, RBD - National part of a River Basin District, SU - Sub-Unit of an RBD	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_v5_HazSubs_Points, 22845 records)

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

FieldName	Definition	Note	DataType
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(70)
SUname	National name of the spatial unit		text(255)
SUcategory	Spatial unit category code.	CC - Country, RBD - National part of a River Basin District, SU - Sub-Unit of an RBD	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_v5_HazSubs_Diffuse, 3088 records)

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

FieldName	Definition	Note	DataType
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(70)
SUname	National name of the spatial unit		text(255)
SUcategory	Spatial unit category code.	CC - Country, RBD - National part of a River Basin District, SU - Sub-Unit of an RBD	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