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 - Transitional, coastal and marine waters / Waterbase - TCM: QualityWater

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 and Pressures data.
Category
European data
Records
311812
Table definition
Year Year year of aggregation period, or year in which sample taken, in format YYYY. int(4) 0
PeriodLength Period length number of months in aggregation period. int(4) 0
NoOfObservations Number of observations number of observation dates within aggregation period (for TwoStageMean aggregation), or number of samples. int(4) 0
Unit Unit unit of measurement. nvarchar(30) 0
WaterbaseID WaterbaseID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345). nvarchar(200) -1
AggregationPeriod Period of aggregation period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months, YYYY-YYYY = aggregated data over a time period. nvarchar(20) 0
Determinand Determinand determinand name. nvarchar(200) 0
SalinityMean Mean salinity mean salinity measured at transitional, coastal or marine water monitoring station expressed in practical salinity units (psu). float(8) 0
MinimumDepth Minimum depth minimum depth limit for samples included in aggregate expressed in m. float(8) 0
MaximumDepth Maximum depth maximum depth limit for samples included in aggregate expressed in m. float(8) 0
Mean Mean mean concentration in aggregation period. float(8) 0
Minimum Minimum minimum concentration during aggregation period. float(8) 0
Maximum Maximum maximum concentration during aggregation period. float(8) 0
CountryCode Country code ISO 3166-alpha-2 code elements varchar(2) 0
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. varchar(20) 0
Files

Geographical coverage

[+] Show Map

Document Actions

Comments

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