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 to water

Note: new version is available!
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)

text

[+] Show table definition

Spatial Unit Characteristics and Pressures (emissions_v1_spatial_unit_characterisation, 150 records)

Field name Field Definition Note Data type Primary key
sucID internal record ID
long yes
sucCountryCode Abbreviation of EEA Member or Collaborating Country ISO3166 two digit code text(2) yes
sucSpatialUnitCode National identification code of spatial unit
text(50) yes
sucSpatialUnitName National name of the spatial unit
text(255)
sucSpatialUnitCategory Spatial Unit Category
text(10)
sucUnitCode National identification code of Sub-Unit
text(50)
sucSubUnitName National name of the Sub-Unit in which water body is located
text(255)
sucRBDcode River basin district code
text(50)
sucRBDname Name of the river basin district
text(255)
sucSpatialUnitArea Area of the unit in km2.
double
sucPermanentPopulationNumber Population number of the spatial unit.
long
sucMaximumPopulationNumber Maximum population number of the spatial unit.
long
sucLongTermIntFlow Total volume of river run-off and groundwater generated, in natural conditions, exclusively by precipitation into a territory.
double
sucPeriodLongTermIntFlow The year or range of years to which this data applies in format YYYY-YYYY
text(50)
sucAnnIntFlow Total annual mean volume of river run-off and groundwater generated, in natural conditions, exclusively by precipitation into a territory.
double
sucYear The year to which this data applies in format YYYY.
text(255)
adID "action" ID (1= 2009 regular reporting)
integer
LastDelivery last year in which spatial unit was reported
integer

Nutrients Emission Discharges from Point Sources (emissions_v1_nutrients_point, 6301 records)

Field name Field Definition Note Data type Primary key
nupID internal record ID
long yes
nupCountryCode Abbreviation of EEA Member or Collaborating Country ISO3166 two digit code text(2) yes
nupSpatialUnitCode National identification code of spatial unit
text(50) yes
nupSpatialUnitName National name of the spatial unit
text(255)
nupSpatialUnitCategory Spatial Unit Category
text(10)
nupPeriodYears The year or range of years to which this data applies in format YYYY or YYYY-YYYY.
text(50) yes
nupDeterminandNutrientsID Identification number of nutrients and organic matter determinand, as defined in codelist.
integer
nupDeterminandNutrientsName Name of nutrient or organic matter determinand, as defined in codelist.
text(255) yes
nupSourcePointEmission Source of point emissions, as defined in codelist.
text(10) yes
nupEmission Emission of nutrients and organic matter in tonnes/year.
double
QA_LRviolations Error code(s) (divided by commas)
text(255)
Remarks Additional remarks, if any
text(255)

Nutrients Emission Discharges from Diffuse Sources (emissions_v1_nutrients_diffuse, 877 records)

Field name Field Definition Note Data type Primary key
nudID internal record ID
long yes
nudCountryCode Abbreviation of EEA Member or Collaborating Country ISO3166 two digit code text(2) yes
nudSpatialUnitCode National identification code of spatial unit
text(50) yes
nudSpatialUnitName National name of the spatial unit
text(255)
nudSpatialUnitCategory Spatial Unit Category
text(10)
nudPeriodYears The year or range of years to which this data applies in format YYYY or YYYY-YYYY.
text(50) yes
nudDeterminandNutrientsID Identification number of nutrients and organic matter determinand, as defined in codelist.
integer
nudDeterminandNutrientsName Name of nutrient or organic matter determinand, as defined in codelist.
text(255) yes
nudSourceDiffEmission Source of point emissions, as defined in codelist.
text(10) yes
nudEmission Emission of nutrients and organic matter in tonnes/year.
double
QA_LRviolations Error code(s) (divided by commas)
text(255)
Remarks Additional remarks, if any
text(255)

Hazardous Substances Emission Discharges from Point Sources (emissions_v1_hazsubst_point, 8761 records)

Field name Field Definition Note Data type Primary key
hspID internal record ID
long yes
hspCountryCode Abbreviation of EEA Member or Collaborating Country ISO3166 two digit code text(2) yes
hspSpatialUnitCode National identification code of spatial unit
text(50) yes
hspSpatialUnitName National name of the spatial unit
text(255)
hspSpatialUnitCategory Spatial Unit Category
text(10)
hspPeriodYears The year or range of years to which this data applies in format YYYY or YYYY-YYYY.
text(50) yes
hspDeterminandHazSubsID Identification number of hazardous substance determinand, as defined in codelist.
integer
hspDeterminandHazSubsName Name of hazardous substance determinand, as defined in codelist.
text(255) yes
hspSourcePointEmission Source of point emissions, as defined in codelist.
text(10) yes
hspEPRTRFacility Flag if emission value is from E-PRTR Facilities or not
text(10)
hspEmission Emission of hazardous substance in kg/year.
double
QA_LRviolations Error code(s) (divided by commas)
text(255)
Remarks Additional remarks, if any
text(255)

Hazardous Substances Emission Discharges from Diffuse Sources (emissions_v1_hazsubst_diffuse, 441 records)

Field name Field Definition Note Data type Primary key
hsdID internal record ID
long yes
hsdCountryCode Abbreviation of EEA Member or Collaborating Country ISO3166 two digit code text(2) yes
hsdSpatialUnitCode National identification code of spatial unit
text(50) yes
hsdSpatialUnitName National name of the spatial unit
text(255)
hsdSpatialUnitCategory Spatial Unit Category
text(10)
hsdPeriodYears The year or range of years to which this data applies in format YYYY or YYYY-YYYY.
text(50) yes
hsdDeterminandHazSubsID Identification number of hazardous substance determinand, as defined in codelist.
integer
hsdDeterminandHazSubsName Name of hazardous substance determinand, as defined in codelist.
text(255) yes
hsdSourceDiffEmission Source of diffuse emissions, as defined in codelist.
text(10) yes
hsdEmission Emission of hazardous substance in kg/year.
double
QA_LRviolations Error code(s) (divided by commas)
text(255)
Remarks Additional remarks
text(255)

Additional information

Code lists

Lists and description of codes used in the emission data tables

Quality assessment documents

Metadata

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