Waterbase is the generic name given to the EEA's databases on the status and quality of Europe's rivers, lakes, groundwater bodies and transitional, coastal and marine waters, and on the quantity of Europe's water resources

European data

Waterbase - TCM: FluxStations

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) and Pressures data.

[+]Show table definition
(records:147)

Longitude

Longitude

(X) international geographical co-ordinates in decimal degrees format. Longitude provided using the common geodetic datum ETS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM). Negative values used for co-ordinates west of the Greenwich Meridian (0 degrees). Where TCM stations represent a broader area, the central location of the area is provided.

numeric(5)

0

Latitude

Latitude

(Y) international geographical co-ordinates in decimal degrees format. Latitude provided using the common geodetic datum ETS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM). Where TCM stations represent a broader area, the central location of the area is provided.

internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).

identifier of the river or lake monitoring stations, the water quantity station, the transitional, coastal or marine flux or montoring station, all unique at the national level. A transitional, coastal or marine station should be a geographically fixed location, an area in which actual sampling locations vary from survey to survey or an area within a defined salinity range within which samples have been taken. Each station is referred to be its single, central location. For transitional, coastal or marine flux stations, the NationalStationID should be the same as that provided for the river flux station.

nvarchar(50)

0

RiverName

River name

national name of river.

nvarchar(50)

0

CatchmentName

Catchment name

name of major catchment or basin.

nvarchar(100)

0

WaterBodyID

Water body ID

national identification code of water body (if applicable) in which station is located. Water body as required/defined by the WFD. A water body may have more than one station in it.

nvarchar(50)

0

WaterBodyName

Water body name

name of water body in which station is located. Water body as required/defined by the WFD. A water body may have more than one station in it.

nvarchar(50)

0

SeaAreaName

Sea area name

name of the local sea into which the river discharges or in which the TCM station is located. SeaAreaName may be the same as WaterBodyName.

Waterbase - TCM: Pressures

The Pressures table contains proxy pressure data on the upstream catchment or drainage basin of the Eionet-Water transitional water monitoring stations, or within the River Basin District to which the coastal water monitoring stations have been assigned, provided by national sources. Each station has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Pressures data with their respective Flux Stations data.

[+]Show table definition
(records:50)

OtherDischarge

Other discharge

direct discharges from sewage treatment works to the transitional, coastal or marine water body. The OSPAR RID guidelines (http://www.ospar.org/eng/html/formats/welcome.htm) define "direct discharge" as: "a mass of a determinand discharged to the maritime area from land-based sources (sewage effluents, industrial effluents or other) per unit of time at a point on a coast or to an estuary downstream of the point at which the riverine estimate of input is made". Y=yes, N=no.

bit(1)

0

OilExtraction

Oil extraction

exploration for or extraction of oil in the transitional, coastal or marine water body. Y = yes, N = no.

bit(1)

0

GasExtraction

Gas extraction

exploration for or extraction of gas in the transitional, coastal or marine water body. Y=yes, N=no.

fish and shellfish farming in the transitional, coastal or marine water body. Y=yes, N=no.

bit(1)

0

Fishing

Fishing

commercial fishing activity in the transitional, coastal or marine water body. Y=yes, N=no.

bit(1)

0

Marina

Marina

presence of a marina in the transitional, coastal or marine water body. Y=yes, N=no.

bit(1)

0

Port

Port

presence of port facilities in the transitional, coastal or marine water body. Y=yes, N=no.

bit(1)

0

OtherActivities

Other activities

any other activities in the transitional, coastal or marine water body. Y=yes, N=no.

bit(1)

0

PopulationDensity

Population density

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/km2.

numeric(5)

0

LanduseUrban

Urban land use

urban agricultural land use as a percentage 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). Land use based on Corine Land Cover category 1.1.

numeric(5)

0

LanduseWetland

Wetland land use

wetland agricultural land use as a percentage 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). Land use based on Corine Land Cover category 4.1 plus 4.2.

numeric(5)

0

LanduseNature

Natural land use

natural land use as a percentage 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). Land use based on Corine Land Cover category 3.2 plus 3.3.

numeric(5)

0

LanduseForest

Landuse forest

forested land use as a percentage 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). Land use based on Corine Land Cover category 3.1.

numeric(5)

0

LanduseTotalAgriculture

Total agricultural land use

total agricultural land use as a percentage 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). Land use based on Corine Land Cover category 2.

numeric(5)

0

LanduseOtherAgriculture

Other agricultural land use

other agricultural land use as a percentage 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). Land use based on Corine Land Cover category 2.2 plus 2.4.

numeric(5)

0

LanduseArableLand

Arable land use

arable land use as a percentage of the upstream catchment of the river monitoring station or lake, within the area of the groundwater body, 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). Land use based on Corine Land Cover category 2.1.

numeric(5)

0

LandusePasture

Pastoral land use

pastoral land use as a percentage of the upstream catchment of the river monitoring station or lake, within the area of the groundwater body, 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). Land use based on Corine Land Cover category 2.1.

numeric(5)

0

LanduseOther

Other land use

other land use as a percentage of the upstream catchment of the river monitoring station or lake, within the area of the groundwater body, 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).

internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).

nvarchar(50)

-1

SewageDischarge

Sewage discharge

direct discharges from sewage treatment works to the transitional, coastal or marine water body. The OSPAR RID guidelines (http://www.ospar.org/eng/html/formats/welcome.htm) define "direct discharge" as: "a mass of a determinand discharged to the maritime area from land-based sources (sewage effluents, industrial effluents or other) per unit of time at a point on a coast or to an estuary downstream of the point at which the riverine estimate of input is made". U=UWWT, NU=Non-UWWT, BU=Both.

nvarchar(2)

0

IndustrialDischarge

Industrial discharge

direct discharges from sewage treatment works to the transitional, coastal or marine water body. The OSPAR RID guidelines (http://www.ospar.org/eng/html/formats/welcome.htm) define "direct discharge" as: "a mass of a determinand discharged to the maritime area from land-based sources (sewage effluents, industrial effluents or other) per unit of time at a point on a coast or to an estuary downstream of the point at which the riverine estimate of input is made". E=EPER, NE=Non-EPER, BE=Both.

Waterbase - TCM: QualityBiota

The QualityBiota table contains aggregated data on hazardous substances in biota, measured at Eionet-Water transitional, coastal or 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 Quality data with their respective Stations data.

[+]Show table definition
(records:70366)

PeriodLength

Period length

number of months in aggregation period.

tinyint(1)

0

DryFreshNoOfSamples

Dry fresh ratio number of samples

number of samples taken in ratio of dry weight to fresh weight as a percentage.

tinyint(1)

0

Year

Year

year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.

smallint(2)

0

LowNoOfSamples

Low range number of samples

number of samples in low range during aggregation period (low range calculated as treating values below the limit of detection as zero).

smallint(2)

0

HighNoOfSamples

High range number of samples

number of samples in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection).

smallint(2)

0

FatNoOfSamples

Fat content number of samples

number of samples of fat content as a percentage of total wet matter.

smallint(2)

0

LowMinimum

Low range minimum

minimum concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero).

numeric(9)

0

Low10Percentile

Low range 10th percentile

10th percentile concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero).

numeric(9)

0

LowMean

Low range mean

mean concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero).

numeric(13)

0

LowMedian

Low range median

median concentration in low range during aggregation period (low range calculated as treating values below the limit of detection as zero).

numeric(9)

0

HighMean

High range mean

mean concentration in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection).

numeric(13)

0

HighMedian

High range median

median concentration in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection).

numeric(9)

0

FatMinimum

Fat content minimum

minimum fat content as a percentage of total wet matter.

numeric(5)

0

FatMaximum

Fat content maximum

maximum fat content as a percentage of total wet matter.

numeric(5)

0

High90Percentile

High range 90th percentile

90th percentile concentration in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection).

numeric(9)

0

HighMaximum

High range maximum

maximum concentration in high range during aggregation period (high range calculated as treating values below the limit of detection as the value of the limit of detection).

internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).

nvarchar(50)

-1

Determinand

Determinand

determinand name.

nvarchar(100)

-1

Unit

Unit

unit of measurement.

nvarchar(20)

0

CASNo

Chemical Abstract Service Number

Chemical Abstract Service Number of determinand.

nvarchar(20)

0

AggregationPeriod

Aggregation period

period of aggregation: Annual=aggregated over whole year, Summer=aggregated over summer months, Winter=aggregated over winter months, MMYYYY-MMYYYY or YYYY-YYYY=aggregated between two periods (TCM only).

Waterbase - TCM: QualitySedimentD

The QualitySedimentD 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.

month in which sample taken, values in range 0-12. If the month value has not been supplied the value will be 0.

tinyint(1)

-1

Day

Day

day in which sample was taken, values in range 0-31. If the day value has not been supplied the value will be 0.

tinyint(1)

-1

Year

Year

year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.

smallint(2)

0

Fraction

Fraction

upper limit of particle size in analysed fraction in µm.

smallint(2)

0

SedimentTop

Top of sediment layer

top of analysed sediment layer measured from the sediment surface in cm. Value will be 0 if the top of the sediment layer is the surface.

smallint(2)

-1

SedimentBottom

Bottom of sediment layer

bottom of analysed sediment layer measured from the sediment surface in cm.

smallint(2)

-1

Concentration

Concentration

concentration of determinand in sample. In TCM data, concentration values recorded as below the limit of detection or determination should contain the limit of detection or determination in the concentration field, with the LimitFlag field set to &lt;.

internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).

nvarchar(50)

-1

SampleID

Sample ID

unique sample identifier required if multiple samples taken on same day. SampleID default value is 0.

Waterbase - TCM: Discharges

The Discharges table contains data on the yearly direct discharges to transitional, coastal and marine waters, provided by national sources or Marine Conventions.

[+]Show table definition
(records:141)

Year

Year

year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.

L=lower estimate based on treating determinand values that are less than the limits of detection as zero, U=upper estimate based on treating determinand values that are less than the limits of detection as equivalent to limit of detection value, X=unspecified.

Waterbase - TCM: QualityHSWaterD

The QualityHSWaterD 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.

[+]Show table definition
(records:6644)

Month

Month

month in which sample taken, values in range 0-12. If the month value has not been supplied the value will be 0.

tinyint(1)

-1

Day

Day

day in which sample was taken, values in range 0-31. If the day value has not been supplied the value will be 0.

tinyint(1)

-1

Year

Year

year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.

smallint(2)

-1

Concentration

Concentration

concentration of determinand in sample. In TCM data, concentration values recorded as below the limit of detection or determination should contain the limit of detection or determination in the concentration field, with the LimitFlag field set to .

internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).

nvarchar(50)

-1

SampleID

Sample ID

unique sample identifier required if multiple samples taken on same day. SampleID default value is 0.

Waterbase - TCM: QualityHSWater

The QualityHSWater table contains aggregated data on hazardous substances in seawater, measured at Eionet-Water transitional, coastal or 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 Quality data with their respective Stations data.

[+]Show table definition
(records:2321)

PeriodLength

Period length

number of months in aggregation period.

tinyint(1)

0

Year

Year

year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.

smallint(2)

-1

NoOfObservations

Number of observations

number of observation dates within aggregation period (for TwoStageMean aggregation), or number of samples.

smallint(2)

0

Mean

Mean

mean concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.

numeric(9)

0

Minimum

Minimum

minimum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.

numeric(9)

0

Maximum

Maximum

maximum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.

numeric(9)

0

MinimumDepth

Minimum depth

minimum depth limit for samples included in aggregate in m.

numeric(5)

0

MaximumDepth

Maximum depth

maximum depth limit for samples included in aggregate in m.

numeric(5)

0

SalinityMean

Mean salinity

mean salinity measured at transitional, coastal or marine water station.

internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).

nvarchar(50)

-1

Determinand

Determinand

determinand name.

nvarchar(100)

-1

Unit

Unit

unit of measurement.

nvarchar(20)

0

CASNo

Chemical Abstract Service Number

Chemical Abstract Service Number of determinand.

nvarchar(20)

0

AggregationPeriod

Aggregation period

period of aggregation: Annual=aggregated over whole year, Summer=aggregated over summer months, Winter=aggregated over winter months, MMYYYY-MMYYYY or YYYY-YYYY=aggregated between two periods (TCM only).

nvarchar(20)

-1

AggregationMethod

Aggregation method

description of aggregation process. MeanOfMinimum=minimum value of all samples on same date and in same depth profile calculated then average of minima calculated by year, TwoStageMean=average of all samples on same date and in same depth profile calculated then average of averages calculated by year.

Waterbase - TCM: QualityBiotaD

The QualityBiotaD 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.

[+]Show table definition
(records:27039)

Month

Month

month in which sample taken, values in range 0-12. If the month value has not been supplied the value will be 0.

tinyint(1)

-1

Day

Day

day in which sample was taken, values in range 0-31. If the day value has not been supplied the value will be 0.

tinyint(1)

-1

Year

Year

year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.

smallint(2)

-1

Concentration

Concentration

concentration of determinand in sample. In TCM data, concentration values recorded as below the limit of detection or determination should contain the limit of detection or determination in the concentration field, with the LimitFlag field set to &lt;.

internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).

nvarchar(50)

-1

SampleID

Sample ID

unique sample identifier required if multiple samples taken on same day. SampleID default value is 0.

Waterbase - TCM: Input

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.

[+]Show table definition
(records:6334)

Year

Year

year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.

internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).

nvarchar(50)

-1

Determinand

Determinand

determinand name.

nvarchar(100)

-1

Unit

Unit

unit of measurement.

nvarchar(20)

0

CASNo

Chemical Abstract Service Number

Chemical Abstract Service Number of determinand.

nvarchar(20)

0

Estimate

Estimate type

L=lower estimate based on treating determinand values that are less than the limits of detection as zero, U=upper estimate based on treating determinand values that are less than the limits of detection as equivalent to limit of detection value, X=unspecified.

Waterbase - TCM: QualityWater

The QualityWater table contains aggregated data on nutrients, oxygen and organic matter in seawater, measured at Eionet-Water transitional, coastal or 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 Quality data with their respective Stations data.

[+]Show table definition
(records:236726)

PeriodLength

Period length

number of months in aggregation period.

tinyint(1)

0

Year

Year

year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.

smallint(2)

-1

NoOfObservations

Number of observations

number of observation dates within aggregation period (for TwoStageMean aggregation), or number of samples.

smallint(2)

0

Mean

Mean

mean concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.

numeric(9)

0

Minimum

Minimum

minimum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.

numeric(9)

0

Maximum

Maximum

maximum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.

numeric(9)

0

MinimumDepth

Minimum depth

minimum depth limit for samples included in aggregate in m.

numeric(5)

0

MaximumDepth

Maximum depth

maximum depth limit for samples included in aggregate in m.

numeric(5)

0

SalinityMean

Mean salinity

mean salinity measured at transitional, coastal or marine water station.

internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).

nvarchar(50)

-1

Determinand

Determinand

determinand name.

nvarchar(100)

-1

Unit

Unit

unit of measurement.

nvarchar(20)

0

AggregationPeriod

Aggregation period

period of aggregation: Annual=aggregated over whole year, Summer=aggregated over summer months, Winter=aggregated over winter months, MMYYYY-MMYYYY or YYYY-YYYY=aggregated between two periods (TCM only).

nvarchar(20)

-1

AggregationMethod

Aggregation method

description of aggregation process. MeanOfMinimum=minimum value of all samples on same date and in same depth profile calculated then average of minima calculated by year, TwoStageMean=average of all samples on same date and in same depth profile calculated then average of averages calculated by year.

Waterbase - TCM: QualitySediment

The QualitySediment table contains aggregated data on hazardous substances in sediment, measured at Eionet-Water transitional, coastal or 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 Quality data with their respective Stations data.

[+]Show table definition
(records:847)

PeriodLength

Period length

number of months in aggregation period.

tinyint(1)

0

Year

Year

year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.

smallint(2)

-1

Fraction

Fraction

upper limit of particle size in analysed fraction in µm.

smallint(2)

0

NoOfSamples

Number of samples

number of samples in aggregation period.

smallint(2)

0

SedimentTop

Top of sediment layer

top of analysed sediment layer measured from the sediment surface in cm. Value will be 0 if the top of the sediment layer is the surface. Value -1 means that this information is not available.

smallint(2)

-1

SedimentBottom

Bottom of sediment layer

bottom of analysed sediment layer measured from the sediment surface in cm. Value -1 means that this information is not available.

smallint(2)

-1

Mean

Mean

mean concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.

numeric(9)

0

Minimum

Minimum

minimum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.

numeric(9)

0

Maximum

Maximum

maximum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination are set equal to the specified limit, making the aggregate an upper limit.

internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).

nvarchar(50)

-1

Determinand

Determinand

determinand name.

nvarchar(100)

-1

Unit

Unit

unit of measurement.

nvarchar(20)

0

CASNo

Chemical Abstract Service Number

Chemical Abstract Service Number of determinand.

nvarchar(20)

0

AggregationPeriod

Aggregation period

period of aggregation: Annual=aggregated over whole year, Summer=aggregated over summer months, Winter=aggregated over winter months, MMYYYY-MMYYYY or YYYY-YYYY=aggregated between two periods (TCM only).

Waterbase - TCM: QualityWaterD

The QualityWaterD 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.

[+]Show table definition
(records:1099536)

Month

Month

month in which sample taken, values in range 0-12. If the month value has not been supplied the value will be 0.

tinyint(1)

-1

Day

Day

day in which sample was taken, values in range 0-31. If the day value has not been supplied the value will be 0.

tinyint(1)

-1

Year

Year

year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request.

smallint(2)

-1

Concentration

Concentration

concentration of determinand in sample. In TCM data, concentration values recorded as below the limit of detection or determination should contain the limit of detection or determination in the concentration field, with the LimitFlag field set to &lt;.

internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).

nvarchar(50)

-1

SampleID

Sample ID

unique sample identifier required if multiple samples taken on same day. SampleID default value is 0.

Waterbase - TCM: Stations

The Stations 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 data.

[+]Show table definition
(records:35662)

SeaResidence

Residence time

residence time of transitional or coastal water body in days.

smallint(2)

0

ReferenceStation

Reference Station

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. Concentrations of nutrients or hazardous substances occurring naturally would give an indication of background levels. For volatile sunthetic substances, data from these stations might be used to assess the significance of atmospheric deposition. River and lake stations can be of more than one type. 1=yes, 0=no.

bit(1)

0

Longitude

Longitude

(X) international geographical co-ordinates in decimal degrees format. Longitude provided using the common geodetic datum ETS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM). Negative values used for co-ordinates west of the Greenwich Meridian (0 degrees). Where TCM stations represent a broader area, the central location of the area is provided.

numeric(5)

0

Latitude

Latitude

(Y) international geographical co-ordinates in decimal degrees format. Latitude provided using the common geodetic datum ETS89 (rivers, lakes, groundwater, water quantity) or WGS84 (TCM). Where TCM stations represent a broader area, the central location of the area is provided.

numeric(5)

0

MainlandCoast

Mainland coast

distance of marine station from nearest mainland coast expressed in km.

numeric(5)

0

ClosestCoast

Closest coast

distance of marine station from closest coast expressed in km. Only shown if different from MainlandCoast.

internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001).

proximity to land, defined by comparing supplied station co-ordinates with maps. Coast=within 20 km of closest land or island, Open Water=more than 20 km from closest land or island.

nvarchar(20)

0

SeaConventionArea

Marine Convention Area

name of Marine Convention area of which regional sea is a part.

nvarchar(20)

0

StationReporting

Station reporting purpose

reporting purpose of the transitional, coastal or marine water station. EC=European Commission, MC=Marine Conventions, N=national purposes. Station can be for more than one reporting purpose, listed alphabetically with no separator (e.g. ECN).

identifier of the river or lake monitoring stations, the water quantity station, the transitional, coastal or marine flux or montoring station, all unique at the national level. A transitional, coastal or marine station should be a geographically fixed location, an area in which actual sampling locations vary from survey to survey or an area within a defined salinity range within which samples have been taken. Each station is referred to be its single, central location. For transitional, coastal or marine flux stations, the NationalStationID should be the same as that provided for the river flux station.

Data in Waterbase are sub-samples of national data assembled for the purpose of providing comparable indicators of pressures, state and impact of waters on a Europe-wide scale and the data sets are not intended for assessing compliance with any European Directive or any other legal instrument. Information on the national and sub-national scales should be sought from other sources.

Determinands and units used in the data base are listed in the &quot;pdf&quot; document called &quot;Waterbase_TCM_v4_Determinands&quot; available within the &quot;Additional information&quot; section.

Data sources

The European Topic Centre on Water. Version 4, date of delivery (date sent to the Data Service): 20/12/2006.

Additional information

Waterbase contains timely, reliable and policy-relevant data collected from EEA member countries through the Eionet-Water (formerly known as Eurowaternet) process. Eionet-Water 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 Eionet-Water 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 EEA's indicator-based factsheets.