Services
Account Services
Subscribe to receive notifications if you want to stay updated about events in this site.
The Eionet password expires two years after it was last changed.
Feedback: AutomaticQA result for file Lakes_2010_NutrientsLakes_Agg.xml: WISE-SOE: Lakes - Nutrients 2010
| Subject: | AutomaticQA result for file Lakes_2010_NutrientsLakes_Agg.xml: WISE-SOE: Lakes - Nutrients 2010 |
|---|---|
| Posted automatically on: | 29 Oct 2010 11:52 |
| Task: | Automatic quality assessment |
| Referred file: | Lakes_2010_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.
2. Country codes
This test checked the correctness of country code. All CountryCodes has to match the one of the reporting Country.
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.
4. Data types
This test checked that the format of reported elements matches the Data Dictionary specifications.
5. Valid codes
This test checked the correctness of values against code lists (fixed values) - AggregationPeriod, Unit_Nutrients, Determinand_Nutrients.
6. Logical checks
This test checked the logical consistency of the NumberOfSamples, Minimum, Mean, Maximum, Median, StandardDeviation, NoOfSubsites and MethodOfAggregation values.
7. Chemical checks
This test checked the chemical rule violations. Mean value is checked for different determinands on same station / year / aggregationPeriod.
8. Outlier checks
This test checked the possible outliers if values are greater than specified values.
| Row | CountryCode | NationalStationID | Year | AggregationPeriod | Determinand_Nutrients | Unit_Nutrients | Minimum | Mean | Maximum | Median | StandardDeviation | SampleDepth | Remarks |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 160 | RO | 15206 | 2009 | annual | Chlorophyll a | µg/l | 13.86 | 207.15 | 481.62 | 114.649 | 0.5 |
| Determinand_Nutrients | Potentially High Mean Value |
|---|---|
| BOD5 | 100 |
| BOD7 | 100 |
| Chlorophyll a | 100 |
| COD | 100 |
| CODCr | 100 |
| CODMn | 100 |
| Dissolved Oxygen | 20 |
| Kjeldahl Nitrogen | 100 |
| Nitrate | 100 |
| Nitrite | 1 |
| Non-ionised Ammonia | 2 |
| Orthophosphate | 10 |
| Oxygen Saturation | 200 |
| pH | In range 1 to 14 |
| Temperature | In range -30 to 40 |
| Total Ammonium | 10 |
| Total Inorganic Nitrogen | 100 |
| Total Nitrogen | 100 |
| Total Organic Carbon | 40 |
| Total Organic Nitrogen | 100 |
| Total Oxidised Nitrogen | 100 |
| Total Phosphorus | 10 |