Personal tools

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: QualityWaterD

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 and Pressures data.
Category
European data
Records
696340
Table definition
Year Year year of aggregation period, or year in which sample taken, in format YYYY. int(4) 0
Month Month month in which sample taken, values in range 0-12 (it is possible that the month has not been supplied, in which case the value will be 0). int(4) 0
Day Day day in which sample was taken, values in range 0-31 (it is possible that the day has not been supplied, in which case the value will be 0). 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
SampleID Sample ID unique sample identifier required if multiple samples taken on same day. SampleID default value is 0. nvarchar(50) 0
Determinand Determinand determinand name. nvarchar(200) 0
Concentration Concentration concentration of determinand in sample. For observations reported as below the analytical limit, the field will contain the upper (reporting) limit. float(8) 0
SampleDepth Sample depth depth at which sample taken expressed as m below surface, with value >=0. float(8) 0
Salinity Salinity salinity of sample or salinity to which sample concentration is normalised in practical salinity units (psu). float(8) 0
HaloPos Halocline position vertical position relative to halocline at transitional, coastal and marine water monitoring station: AH = Above halocline, IH = In halocline, BH = Below halocline. varchar(2) 0
CountryCode Country code ISO 3166-alpha-2 code elements. varchar(2) 0
LimitOfDetectionFlag Limit of detection flag flag to indicate sample below analytical limit of detection in format <. varchar(1) 0
ThermoPos Thermocline position vertical position relative to thermocline at transitional, coastal and marine water monitoring station: AT = Above thermocline, IT = In thermocline, BT = Below thermocline. varchar(2) 0
Files

Geographical coverage

[+] Show Map

Document Actions

Comments

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