View table

There are 1 QA scripts and 4 conversion scripts registered for this table.
Link to the schema page on XMLCONV
Identifier NiD_SW_EutroState
Short name SW_Eutrophication_state
Dataset NiD_water
Reference URL
Name Trophic state of surface water
Short Description Trophic state in each surface water monitoring station.
Definition Trophic state in each surface water monitoring station.
Methodology for obtaining data Different criteria to evaluate the eutrophication status exist in different EU-Member States. Member States are requested to report on methodology and to qualify eutrophication separately for rivers, lakes and coastal waters according to the fixed values list.
This table should be used for all surface water monitoring stations. Discrimination between the surface water entities (river, lake, etc.) can be made by indicating the "Station type". 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.


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
* Number of samples (ND_NoOfSamples) C integer Quantitative
* Trophic state (ND_TrophicState) C string Fixed values
(an asterisk in front of element name indicates that the element is mandatory in this table)
(the C sign marks a common element)