All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesDo something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
Data
The dataset contains data on physical characteristics of the transitional, coastal and marine water monitoring and flux stations, proxy pressures on the upstream catchment, basin and River Basin District associated with transitional and coastal waters, chemical quality data on nutrients in seawater and hazardous substances in biota, sediment and seawater, as well as data on direct discharges and riverine input loads.
[+] Show table definition
Discharges (1182 records)
The Discharges table contains data on the yearly direct discharges to transitional, coastal and marine waters, provided by national sources or Marine Conventions.
Field name | Field Definition | Note | Data type | Primary key |
---|---|---|---|---|
CountryCode | Abbreviation of EEA Member or Collaborating Country | text(2) | yes | |
WaterBodyID | National identification code of water body (if available) in which station is located. | text(50) | yes | |
WaterBodyName | Identifier of the TCM flux station or monitoring station, all unique at the national level. | text(50) | yes | |
SeaAreaName | Name of the local sea into which the river discharges or in which the TCM station is located. | text(30) | ||
SeaRegionName | Name of regional sea of which local sea area is a part. | text(30) | ||
SeaConventionArea | Name of Marine Convention area of which regional sea is a part, as defined in the codelist. | text(20) | ||
Year | Year in which sample taken, in format YYYY. | integer | yes | |
DischargeType | Discharge type, as defined in the codelist. | text(1) | ||
Determinand | Name of riverine inputs or direct discharge determinand, as defined in the codelist. | text(30) | yes | |
CASNumber | Chemical Abstract Service Number of the hazardous substance, as defined in the codelist. | text(20) | ||
Unit | Unit of measurement of riverine input or direct discharge, as defined in the codelist | text(20) | ||
Estimate | Estimate type, as defined in the codelist. | text(1) | yes | |
Method | Method of estimation, as defined in the codelist. | text(10) | ||
Load | Estimated load of determinand. | single | ||
QA_duplicates | Quality assurance field - record is duplicated | Combination of primary key values should be unique. Details are explained in the QA documentation | boolean | |
QA_MVmissing | Quality assurance field - missing mandatory values | List of mandatory values missing in the record. Details are explained in the QA documentation | text(150) | |
QA_load_error | Quality assurance field - load value issues | Code defining type of load value error. Details are explained in the QA documentation | integer | |
QA_datatype_errors | Quality assurance field - data type and 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 | text(150) |
Flux stations (72 records)
The FluxStations table contains the physical characteristics of the Eionet-Water transitional, coastal and marine water stations used to monitor riverine input loads, provided by national sources or Marine Conventions. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the FluxStations with their respective Input (load) data.
Field name | Field Definition | Note | Data type | Primary key |
---|---|---|---|---|
CountryCode | Abbreviation of EEA Member or Collaborating Country | text(2) | yes | |
WaterbaseID | Internally produced, unique Waterbase identifier | combination of CountryCode + '_TCM_' + (type of hazardous substances data - 'B_' - biota, 'S_' - Sediment, 'W_' - water) + NationalStationID | text(60) | yes |
NationalStationID | Identifier of the TCM flux station or monitoring station, all unique at the national level. | text(60) | ||
NationalStationName | National name of the monitoring station. | text(150) | ||
WFDstation | Specification yes / no, whether the monitoring station was reported to European Commission as Water Framework Directive, Article 8 monitoring station. | text(1) | ||
WFD_EU_CD | Internally produced, unique international identifier of the monitoring station under which the station was reported as WFD Art.8 monitoring station. | text(20) | ||
RiverName | National name of river. | text(50) | ||
CatchmentName | Name of major catchment or basin. | text(50) | ||
WaterBodyID | National identification code of water body (if available) in which station is located. | text(20) | ||
WaterBodyName | Name of water body in which station is located. | text(100) | ||
SeaAreaName | Name of the local sea into which the river discharges or in which the TCM station is located. | text(30) | ||
SeaRegionName | Name of regional sea of which local sea area is a part. | text(30) | ||
SeaConventionArea | Name of Marine Convention area of which regional sea is a part, as defined in the codelist. | text(20) | ||
RBDcode | River Basin District Code, as defined in the codelist. | text(50) | ||
RBDname | Name of the River Basin District. | text(150) | ||
Longitude | (X) International geographical co-ordinates in decimal degrees format | single | ||
Latitude | (Y) International geographical co-ordinates in decimal degrees format | single | ||
QA_MVmissing | Quality assurance field - missing mandatory values | List of mandatory values missing in the record. Details are explained in the QA documentation | text(150) | |
QA_station_problem | Quality assurance field - stations data quality issues flag | List of codes of station related violated by record. Details are explained in the QA documentation | text(50) | |
QA_datatype_errors | Quality assurance field - data type and 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 | text(100) |
HazSubs Biota (844636 records)
The HazSubs Biota table contains disaggregated data on hazardous substances in biota, measured at Eionet-Water transitional, coastal or marine water monitoring stations, provided by national sources only. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations data.
Field name | Field Definition | Note | Data type | Primary key |
---|---|---|---|---|
CountryCode | Abbreviation of EEA Member or Collaborating Country | text(2) | yes | |
WaterbaseID | Internally produced, unique Waterbase identifier | combination of CountryCode + '_TCM_' + (type of hazardous substances data - 'B_' - biota, 'S_' - Sediment, 'W_' - water) + NationalStationID | text(60) | yes |
NationalStationID | Identifier of the TCM flux station or monitoring station, all unique at the national level. | text(60) | ||
Year | Year in which sample taken | integer | yes | |
Month | Month in which sample taken | integer | yes | |
Day | Day on which sample taken | integer | yes | |
SampleID | Unique sample identifier required if multiple samples taken on same day. SampleID default value should be 0. | text(20) | yes | |
Determinand | Name of hazardous substance or other chemical determinand, as defined in codelist. | text(100) | yes | |
CASNumber | Chemical Abstract Service Number of the hazardous substance, as defined in the codelist. | text(30) | ||
Unit | Unit of measurement of hazardous substance, as defined in the codelist. | text(20) | ||
Species | Species monitored, as defined in the codelist. | text(50) | yes | |
Tissue | Tissue element of species monitored, as defined in the codelist | text(2) | yes | |
LimitFlag | Flag to indicate sample below analytical limit of detection (LOD) or limit of quantification (LOQ) | sample below limit of detection: [, sample below limit of quantification: < | text(1) | |
Concentration | Concentration of determinand in sample (negative values should not be supplied). | double | ||
Basis | Basis of measurement, as defined in the codelist. | text(1) | ||
DryWetRatio% | Ratio of dry weight to wet or fresh weight as a percentage | double | ||
Fat | Fat content as percentage of total wet matter. | double | ||
LipidWeight% | double | |||
ExtractLipidWeight% | double | |||
DataSource | Data source | EIONET, Medpol or ICES | text(10) | |
QA_MVmissing | Quality assurance field - missing mandatory values | List of mandatory values missing in the record. Details are explained in the QA documentation | text(150) | |
QA_concentration_error | Quality assurance field - concentration value issues | Code defining type of concentration value error. Details are explained in the QA documentation | integer | |
QA_outlier | Quality assurance field - outlier flag. | Code flaging record as a possible outlier and defining type of the outlier. Details are explained in the QA documentation. | integer | |
QA_station_problem | Quality assurance field - stations data quality issues flag | List of codes of station related violated by record. Details are explained in the QA documentation | text(50) | |
QA_other_errors | Quality assurance field - other, unsorted quality issues | List of codes of other, unsorted rules violated by record. Details are explained in the QA documentation | text(50) | |
QA_datatype_errors | Quality assurance field - data type and 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 | text(150) | |
HazSubs Sediment (370812 records)
The HazSubs Sediment table contains disaggregated data on hazardous substances in sediment, measured at Eionet-Water transitional, coastal or marine water monitoring stations, provided by national sources only. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations data.
Field name | Field Definition | Note | Data type | Primary key |
---|---|---|---|---|
CountryCode | Abbreviation of EEA Member or Collaborating Country | text(2) | yes | |
WaterbaseID | Internally produced, unique Waterbase identifier | combination of CountryCode + '_TCM_' + (type of hazardous substances data - 'B_' - biota, 'S_' - Sediment, 'W_' - water) + NationalStationID | text(60) | yes |
NationalStationID | Identifier of the TCM flux station or monitoring station, all unique at the national level. | text(60) | ||
Year | Year in which sample taken | integer | yes | |
Month | Month in which sample taken | integer | yes | |
Day | Day on which sample taken | integer | yes | |
SampleID | Unique sample identifier required if multiple samples taken on same day. SampleID default value should be 0. | text(20) | yes | |
Determinand | Name of hazardous substance or other chemical determinand, as defined in codelist. | text(100) | yes | |
CASNumber | Chemical Abstract Service Number of the hazardous substance, as defined in the codelist. | text(30) | ||
Unit | Unit of measurement of hazardous substance, as defined in the codelist. | text(20) | ||
GrainType | Sediment type description, as defined in the codelist | text(5) | ||
Fraction | Upper limit of particle size in analysed fraction, in µm. | long | yes | |
LimitFlag | Flag to indicate sample below analytical limit of detection (LOD) or limit of quantification (LOQ) | sample below limit of detection: [, sample below limit of quantification: < | text(1) | |
Concentration | Concentration of determinand in sample (negative values should not be supplied). | double | ||
Sampler | Name of sampling equipment used. | text(100) | ||
BottomDepth | Depth of sea bottom at sampling point in metres. | double | ||
SedimentTop | Top of analysed sediment layer measured from the sediment surface in centimetres. Value will be zero if top of sediment layer is the sediment surface. | double | yes | |
SedimentBottom | Bottom of analysed sediment layer measured from the sediment surface in centimetres. | double | yes | |
OrganicCarbon | Organic Carbon content as a percentage of total dry weight. | double | ||
DryWetRatio% | Ratio of dry weight to wet or fresh weight as a percentage | double | ||
Basis | Basis of measurement, as defined in the codelist. | text(1) | ||
DataSource | Data source | EIONET, Medpol or ICES | text(10) | |
QA_MVmissing | Quality assurance field - missing mandatory values | List of mandatory values missing in the record. Details are explained in the QA documentation | text(150) | |
QA_concentration_error | Quality assurance field - concentration value issues | Code defining type of concentration value error. Details are explained in the QA documentation | integer | |
QA_outlier | Quality assurance field - outlier flag. | Code flaging record as a possible outlier and defining type of the outlier. Details are explained in the QA documentation. | integer | |
QA_station_problem | Quality assurance field - stations data quality issues flag | List of codes of station related violated by record. Details are explained in the QA documentation | text(50) | |
QA_other_errors | Quality assurance field - other, unsorted quality issues | List of codes of other, unsorted rules violated by record. Details are explained in the QA documentation | text(50) | |
QA_datatype_errors | Quality assurance field - data type and 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 | text(150) |
HazSubs Water (59693 records)
The HazSubs Water table contains disaggregated data on hazardous substances in seawater, measured at Eionet-Water transitional, coastal or marine water monitoring stations, provided by national sources only. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations data.
Field name | Field Definition | Note | Data type | Primary key |
---|---|---|---|---|
CountryCode | Abbreviation of EEA Member or Collaborating Country | text(2) | yes | |
WaterbaseID | Internally produced, unique Waterbase identifier | combination of CountryCode + '_TCM_' + (type of hazardous substances data - 'B_' - biota, 'S_' - Sediment, 'W_' - water) + NationalStationID | text(60) | yes |
NationalStationID | Identifier of the TCM flux station or monitoring station, all unique at the national level. | text(60) | ||
Year | Year in which sample taken | integer | yes | |
Month | Month in which sample taken | integer | yes | |
Day | Day on which sample taken | integer | yes | |
SampleID | Unique sample identifier required if multiple samples taken on same day. SampleID default value should be 0. | text(20) | yes | |
Determinand | Name of hazardous substance or other chemical determinand, as defined in codelist. | text(100) | yes | |
CASNumber | Chemical Abstract Service Number of the hazardous substance, as defined in the codelist. | text(20) | ||
Unit | Unit of measurement of hazardous substance, as defined in the codelist. | text(10) | ||
LimitFlag | Flag to indicate sample below analytical limit of detection (LOD) or limit of quantification (LOQ) | sample below limit of detection: [, sample below limit of quantification: < | text(1) | |
Concentration | Concentration of determinand in sample (negative values should not be supplied). | double | ||
SampleDepth | Depth at which sample taken in metres below water surface. | double | yes | |
ThermoPos | Vertical position of sample relative to thermocline, as defined in the codelist. | text(2) | ||
HaloPos | Vertical position of sample relative to halocline, as defined in the codelist | text(2) | ||
Salinity | Salinity of sample. | double | ||
DataSource | Data source | EIONET, Medpol or ICES | text(10) | |
Remarks | Remarks, comments or explanatory notes | text(255) | ||
QA_MVmissing | Quality assurance field - missing mandatory values | List of mandatory values missing in the record. Details are explained in the QA documentation | text(150) | |
QA_concentration_error | Quality assurance field - concentration value issues | Code defining type of concentration value error. Details are explained in the QA documentation | integer | |
QA_outlier | Quality assurance field - outlier flag. | Code flaging record as a possible outlier and defining type of the outlier. Details are explained in the QA documentation. | integer | |
QA_station_problem | Quality assurance field - stations data quality issues flag | List of codes of station related violated by record. Details are explained in the QA documentation | text(50) | |
QA_datatype_errors | Quality assurance field - data type and 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 | text(150) |
Inputs (23230 records)
The Input table contains data on the yearly riverine input loads to transitional, coastal and marine waters which are monitored at Eionet-Water flux stations, provided by national sources or Marine Conventions. Each flux station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Input data with their respective Flux Stations data.
Field name | Field Definition | Note | Data type | Primary key |
---|---|---|---|---|
CountryCode | Abbreviation of EEA Member or Collaborating Country | text(2) | yes | |
WaterbaseID | Internally produced, unique Waterbase identifier | combination of CountryCode + '_TCM_' + (type of hazardous substances data - 'B_' - biota, 'S_' - Sediment, 'W_' - water) + NationalStationID | text(60) | yes |
NationalStationID | Identifier of the TCM flux station or monitoring station, all unique at the national level. | text(60) | ||
Year | Year in which sample taken | integer | yes | |
Determinand | Name of riverine inputs or direct discharge determinand, as defined in the codelist. | text(100) | yes | |
CASNumber | Chemical Abstract Service Number of the hazardous substance, as defined in the codelist. | text(30) | ||
Unit | Unit of measurement of riverine input or direct discharge, as defined in the codelist. | text(20) | ||
Estimate | Estimate type, as defined in the codelist. | text(1) | yes | |
Method | Method of estimation, as defined in the codelist. | text(10) | ||
Load | Estimated load of determinand. | double | ||
QA_duplicates | Quality assurance field - record is duplicated | Combination of primary key values should be unique. Details are explained in the QA documentation | boolean | |
QA_MVmissing | Quality assurance field - missing mandatory values | List of mandatory values missing in the record. Details are explained in the QA documentation | text(150) | |
QA_load_error | Quality assurance field - load value issues | Code defining type of load value error. Details are explained in the QA documentation | integer | |
QA_station_problem | Quality assurance field - stations data quality issues flag | List of codes of station related violated by record. Details are explained in the QA documentation | text(50) | |
QA_datatype_errors | Quality assurance field - data type and 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 | text(150) |
ProxyPressures (241 records)
The ProxyPressures table contains information about proxy pressures on the upstream catchment or drainage basin of the transitional water or the area within the River Basin District to which the coastal water has been assigned, relating to flux stations.
Field name | Field Definition | Note | Data type | Primary key |
---|---|---|---|---|
CountryCode | Abbreviation of EEA Member or Collaborating Country | text(2) | yes | |
WaterbaseID | Internally produced, unique Waterbase identifier | combination of CountryCode + '_TCM_' + (type of hazardous substances data - 'B_' - biota, 'S_' - Sediment, 'W_' - water) + NationalStationID | text(60) | yes |
NationalStationID | Identifier of the TCM flux station or monitoring station, all unique at the national level. | text(60) | ||
PopulationDensity | Population density of the upstream catchment of the river monitoring station or lake, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set), in capita per kilometre squared. | double | ||
SewageDischarge | Direct discharges from sewage treatment works to the transitional, coastal or marine water body. | text(1) | ||
IndustrialDischarge | Direct discharges from industry to the transitional, coastal or marine water body. | text(2) | ||
OtherDischarge | Direct discharges from other sources to the transitional, coastal or marine water body. | text(1) | ||
OilExtraction | Exploration for, or extraction of, oil in the transitional, coastal or marine water body. | text(1) | ||
GasExtraction | Exploration for, or extraction of, gas in the transitional, coastal or marine water body. | text(1) | ||
Spoil | Dredged spoil disposal ground in the transitional, coastal or marine water body. | text(1) | ||
Waste | Waste disposal ground in the transitional, coastal or marine water body. | text(1) | ||
Landfill | Transitional, coastal or marine water body directly impacted by leachate from landfill disposal sites. | text(1) | ||
Mariculture | Fish and shellfish farming in the transitional, coastal or marine water body. | text(1) | ||
Fishing | Commercial fishing activity in the transitional, coastal or marine water body. | text(1) | ||
Marina | Presence of a marina in the transitional, coastal or marine water body. | text(1) | ||
Port | Presence of port facilities in the transitional, coastal or marine water body. | text(1) | ||
OtherActivities | Any other activities in the transitional, coastal or marine water body. | text(1) | ||
Remarks | Remarks, comments or explanatory notes. | text(255) | ||
QA_station_problem | Quality assurance field - stations data quality issues flag | List of codes of station related violated by record. Details are explained in the QA documentation | text(50) |
Quality (6796693 records)
The Quality table contains disaggregated data on nutrients, oxygen and organic matter in seawater, measured at Eionet-water transitional, coastal or marine water monitoring stations, provided by national sources only. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Quality data with their respective Stations data.
Field name | Field Definition | Note | Data type | Primary key |
---|---|---|---|---|
CountryCode | Abbreviation of EEA Member or Collaborating Country | text(2) | yes | |
WaterbaseID | Internally produced, unique Waterbase identifier | combination of CountryCode + '_TCM_' + (type of hazardous substances data - 'B_' - biota, 'S_' - Sediment, 'W_' - water) + NationalStationID | text(60) | yes |
NationalStationID | Identifier of the TCM flux station or monitoring station, all unique at the national level. | text(60) | ||
Year | Year in which sample taken | integer | yes | |
Month | Month in which sample taken | integer | yes | |
Day | Day on which sample taken | integer | yes | |
SampleID | Unique sample identifier required if multiple samples taken on same day. SampleID default value should be 0. | text(30) | yes | |
Determinand | Name of nutrients, organic matter or general physico-chemical determinands, as defined in the codelist. | text(50) | yes | |
Unit | Unit of measurement of nutrients in seawater, as defined in the codelist | text(20) | ||
LimitOfDetection | Concentration for which there is a desirably small probability (around 5%) that the determinand will not be detected i.e. there is a 95% probability that the determinand will be detected. | double | ||
LimitOfQuantification | The smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%). | double | ||
LimitFlag | Flag to indicate sample below analytical limit of detection (LOD) or limit of quantification (LOQ) | sample below limit of detection: [, sample below limit of quantification: < | text(1) | |
Concentration | Concentration of determinand in sample (negative values should not be supplied). | double | ||
SampleDepth | Depth at which sample taken in metres below water surface. | double | yes | |
ThermoPos | Vertical position of sample relative to thermocline, as defined in the codelist. | text(2) | ||
HaloPos | Vertical position of sample relative to halocline, as defined in the codelist | text(2) | ||
Salinity | Salinity of sample. | double | ||
DataSource | Data source | EIONET, Medpol or ICES | text(10) | |
Remarks | Remarks, comments or explanatory notes | text(255) | ||
QA_MVmissing | Quality assurance field - missing mandatory values | List of mandatory values missing in the record. Details are explained in the QA documentation | text(150) | |
QA_concentration_error | Quality assurance field - concentration value issues | Code defining type of concentration value error. Details are explained in the QA documentation | integer | |
QA_outlier | Quality assurance field - outlier flag. | Code flaging record as a possible outlier and defining type of the outlier. Details are explained in the QA documentation. | integer | |
QA_station_problem | Quality assurance field - stations data quality issues flag | List of codes of station related violated by record. Details are explained in the QA documentation | text(50) | |
QA_datatype_errors | Quality assurance field - data type and 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 | text(150) |
Stations EIONET (5247 records)
The Stations_EIONET table contains the Eionet-Water transitional, coastal and marine water monitoring stations, provided by national sources or Marine Conventions. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Stations with their respective Quality or HazSubs data.
Field name | Field Definition | Note | Data type | Primary key |
---|---|---|---|---|
CountryCode | Abbreviation of EEA Member or Collaborating Country | text(2) | yes | |
WaterbaseID | Internally produced, unique Waterbase identifier | combination of CountryCode + '_TCM_' + (type of hazardous substances data - 'B_' - biota, 'S_' - Sediment, 'W_' - water) + NationalStationID | text(60) | yes |
NationalStationID | Identifier of the TCM flux station or monitoring station, all unique at the national level. | text(60) | ||
StationSite | Specify whether station represents a single point location, a linear feature or a wider area, as defined in the codelist. | text(5) | ||
NationalStationName | National name of the monitoring station. | text(100) | ||
WFDStation | Specification yes / no, whether the monitoring station was reported to European Commission as Water Framework Directive, Article 8 monitoring station. | text(3) | ||
WFD_EU_CD | Internally produced, unique international identifier of the monitoring station under which the station was reported as WFD Art.8 monitoring station. | text(20) | ||
WaterCategory | Water Category, as defined in the codelist. | text(2) | ||
WaterBodyTypeDescription | Additional water body type description, e.g. Bay, Coastal Lagoon, Embayment, Estuary, Fjord. | text(100) | ||
CatchmentName | Name of major catchment or basin. | text(150) | ||
Region | National region in which water body is located. | text(50) | ||
RBDcode | River Basin District Code, as defined in the codelist. | text(50) | ||
RBDname | Name of the River Basin District. | text(150) | ||
Longitude | International geographical co-ordinates in decimal degrees forma | double | ||
Latitude | International geographical co-ordinates in decimal degrees forma | double | ||
ReferenceStation | Reference station type, found in catchments or associated River Basin Districts with little or no human activity, natural landscape higher than 90%, and minimally impacted by inflow from adjacent coastal or marine waters. | text(1) | ||
PhysChemStation | Physico-chemical category station. | text(1) | ||
HazSubsStation | Hazardous substances category station. | text(1) | ||
WaterBodyID | National identification code of water body (if available) in which station is located. | text(50) | ||
WaterBodyName | Name of water body in which station is located. | text(150) | ||
SeaAreaName | Name of the local sea into which the river discharges or in which the TCM station is located. | text(150) | ||
SeaRegionName | Name of regional sea of which local sea area is a part. | text(150) | ||
SeaConventionArea | Name of Marine Convention area of which regional sea is a part, as defined in the codelist. | text(10) | ||
StationReporting | Reporting purpose of the transitional, coastal or marine water monitoring station, as defined in the codelist. | text(10) | ||
MainlandCoast | Distance of marine monitoring station from nearest mainland coast in kilometres. | double | ||
ClosestCoast | Distance of marine monitoring station from closest coast in kilometres. | double | ||
TCMMatrix | Environmental compartments measured at transitional, coastal or marine water monitoring station, as defined in the codelist. | text(3) | ||
SalinityMean | Mean annual salinity measured at transitional, coastal or marine water monitoring station. | double | ||
SalinityMinimum | Minimum annual salinity measured at transitional, coastal or marine water monitoring station. | double | ||
SalinityMaximum | Maximum annual salinity measured at transitional, coastal or marine water monitoring station. | double | ||
Temperature | Mean annual temperature measured at transitional, coastal or marine water monitoring station in degrees Celsius. | double | ||
SeaDepth | Mean annual sea depth at transitional, coastal or marine water monitoring station in metres. | double | ||
SeaResidence | Residence time of transitional or coastal water body in days. | double | ||
Mixing | Mixing characteristics at transitional, coastal or marine water monitoring station, as defined in the codelist. | text(2) | ||
DataSource | Data source | EIONET, Medpol or ICES | text(10) | |
QA_station_problem | Quality assurance field - stations data quality issues flag | List of codes of station related violated by record. Details are explained in the QA documentation | text(50) | |
QA_datatype_errors | Quality assurance field - data type and 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 | text(150) |
Stations ICES Medpol (177648 records)
The Stations_ICES_MEDPOL table contains the ICES and MEDPOL monitoring stations, provided by Marine Conventions. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the stations with their respective Quality and HazSubs data.
Field name | Field Definition | Note | Data type | Primary key |
---|---|---|---|---|
CountryCode | Abbreviation of EEA Member or Collaborating Country | text(2) | yes | |
WaterbaseID | Internally produced, unique Waterbase identifier | combination of CountryCode + '_TCM_' + (type of hazardous substances data - 'B_' - biota, 'S_' - Sediment, 'W_' - water) + NationalStationID | text(60) | yes |
NationalStationID | Identifier of the TCM flux station or monitoring station, all unique at the national level. | text(60) | ||
Latitude_min | Latitude minimum for the particular station. | single | ||
Longitude_min | Longitude minimum for the particular station. | single | ||
Latitude_max | Latitude maximum for the particular station. | single | ||
Longitude_max | Longitude maximum for the particular station. | single | ||
DataSource | Data source | EIONET, Medpol or ICES | text(10) |
Definition and field description of all data tables.
Table contains list of ISO 3166 alpha 2 code elements used in Waterbase-TCM version 7
Quality control documentation briefly presents ETC/Water and EEA activities focused on quality of Waterbase-TCM dataset and results of these activities.
Waterbase contains timely, reliable and policy-relevant data collected from EEA member countries through the WISE-SoE data collection (formerly known as Eionet-Water and Eurowaternet) process. WISE-SoE data collection selects validated monitoring data from national databases and adds information on the physical characteristics of the water bodies being monitored and on the pressures potentially affecting water quality. The added value of Waterbase is that data collected through the WISE-SoE data collection process are from statistically stratified monitoring stations and groundwater bodies and are comparable at the European level. Waterbase data are primarily used in the production of the EEAs indicator-based factsheets.
For references, please go to https://www.eea.europa.eu/data-and-maps/data/waterbase-transitional-coastal-and-marine-waters-6 or scan the QR code.
PDF generated on 31 May 2023, 07:42 PM
Engineered by: EEA Web Team
Software updated on 12 March 2023 21:56 from version 23.1.28
Software version: EEA Plone KGS 23.3.11
Document Actions
Share with others