EEA

Services

Account Services

Note

Subscribe to receive notifications if you want to stay updated about events in this site.

Your password

The Eionet password expires two years after it was last changed.

Feedback: AutomaticQA result for file IS_Lakes_2009_Data_NutrientsLakes_Agg.xml: WISE-SOE: Lakes - Nutrients 2010

Subject: AutomaticQA result for file IS_Lakes_2009_Data_NutrientsLakes_Agg.xml: WISE-SOE: Lakes - Nutrients 2010
Posted automatically on: 25 Oct 2010 15:56
Task: Automatic quality assessment
Referred file: IS_Lakes_2009_Data_NutrientsLakes_Agg.xml
Feedback status:
Feedback message:

The following 8 quality tests were made against this table - WISE-SOE 2010: Nutrients in Lakes - Aggregated Data

1. Mandatory values

This test checked the presence of mandatory elements - CountryCode, NationalStationID, Year, AggregationPeriod, Determinand_Nutrients, NumberOfSamples, Mean.

OK - the test was passed successfully.

2. Country codes

This test checked the correctness of country code. All CountryCodes has to match the one of the reporting Country.

OK - the test was passed successfully.

3. Duplicates

This test checked the uniqueness of primary keys. The combination of the elements CountryCode, NationalStationID, Year, AggregationPeriod, Determinand_Nutrients and SampleDepth must create a unique record in the table. No duplicate records should exist with this combination.

OK - the test was passed successfully.

4. Data types

This test checked that the format of reported elements matches the Data Dictionary specifications.

OK - the test was passed successfully.

5. Valid codes

This test checked the correctness of values against code lists (fixed values) - AggregationPeriod, Unit_Nutrients, Determinand_Nutrients.

OK - the test was passed successfully.

6. Logical checks

This test checked the logical consistency of the NumberOfSamples, Minimum, Mean, Maximum, Median, StandardDeviation, NoOfSubsites and MethodOfAggregation values.

OK - the test was passed successfully.

7. Chemical checks

This test checked the chemical rule violations. Mean value is checked for different determinands on same station / year / aggregationPeriod.

OK - the test was passed successfully.

8. Outlier checks

This test checked the possible outliers if values are greater than specified values.

OK - the test was passed successfully.