next
previous
items

Waterbase-Emissions (5 tables)

Data Table
This page was archived on 25 Aug 2017 with reason: A new version has been published
text
Category
European data
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)
Files

Permalinks

Document Actions