View table

Identifier NiD_SW_EutroMeas
Short name SW_Eutrophication_measurements
Dataset NiD_water
Reference URL http://dd-test.01dev.eea.europa.eu/datasets/latest/NiD/tables/NiD_SW_EutroMeas
Name 5. Eutrophication parameters in surface water
Definition Eutrophication parameters measured in each surface water monitoring station.
Methodology for obtaining data Different criteria to evaluate the eutrophication status exist in the various EU-Member States. Member States are requested to report on methodology and on those eutrophication parameters which were used to do the assessment. Reporting has to be done separately for rivers, lakes and coastal waters.
This table should be used for all surface water monitoring stations and all measured parameters. Discrimination between the surface water entities (river, lake, etc.) can be made by indicating the "Station type", discrimination between the parameters by entering the "Name of parameter". The combination of the elements CountryCode, NationalStationCode and StationType must create a unique record in the table. No duplicate records should exist with this combination.

Elements

Element name Datatype Element type
* Country Code (CountryCode) C string Fixed values
* National station code (ND_NatStatCode) C string Quantitative
* Station type (ND_StationType) C string Fixed values
* Beginning date (ND_BeginDate) C date Quantitative
* End date (ND_EndDate) C date Quantitative
* Name of parameter (ND_ParameterName) C string Fixed values
* Unit of measurement (ND_MeasUnit) C string Fixed values
* Number of samples (ND_NoOfSamples) C integer Quantitative
* Average value (ND_AvgValue) C float Quantitative
(an asterisk in front of element name indicates that the element is mandatory in this table)
(the C sign marks a common element)