View table

• Create an XML Schema for this table
• Create an MS Excel template for this table
• Create an OpenDocument spreadsheet template for this table
• Get the comma-separated codelists of this table
• Get the codelists of this table in XML format

Identifier	NiD_SW_Conc
Short name	SW_NO3_concentrations
Dataset	NiD_water
Reference URL	http://dd-test.01dev.eea.europa.eu/datasets/latest/NiD/tables/NiD_SW_Conc
Name	4. NO3 concentrations in surface water
Short Description	NO3 values for each surface water monitoring station
Definition	NO3 concentrations measured in each surface water monitoring station.
Methodology for obtaining data	Data on surface water monitoring stations are collected for each reporting period (4 year period). For each station the average (mean) annual and winter concentrations for NO3 over one or more years and the maximum value for NO3 in this period have to be reported. If the same station has been used for monitoring in the previous period, a trend value (average current reporting period - average previous (3rd) reporting period) has to be indicated. 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.

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
* Unit of measurement (ND_MeasUnit) C	string	Fixed values
* Number of samples (ND_NoOfSamples) C	integer	Quantitative
* Average annual value (ND_AvgAnnValue) C	float	Quantitative
* Average winter value (ND_AvgWintValue) C	float	Quantitative
* Maximum value (ND_MaxValue) C	float	Quantitative
* Trend annual value (ND_TrendAnnValue) C	float	Quantitative
* Trend winter value (ND_TrendWintValue) C	float	Quantitative