Waterbase - Emissions to water
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) |
-
Waterbase_Emissions_v1_csv.zip
(ZIP archive)
177.68 KB Download file -
Waterbase_Emissions_v1_mdb.zip
(ZIP archive)
295.34 KB Download file -
Waterbase_Emissions_v1_xls.zip
(ZIP archive)
663.30 KB Download file
Additional information
Code lists
Lists and description of codes used in the emission data tables
-
Waterbase_Emissions_v1_codelists.xls
(Microsoft Excel spreadsheet)
54.50 KB Download file -
Waterbase_Emissions_v1_codelists_txt.zip
(ZIP archive)
6.75 KB Download file
Quality assessment documents
-
QAflags.txt
(Plain Text)
589 Bytes Download file