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: CDDA envelope relational checks

Subject: AutomaticQA result for: CDDA envelope relational checks
Posted automatically on: 29 Jun 2016 09:42
Task: Automatic quality assessment
Feedback status: ERROR
Feedback message: 1 envelope test generated errors

The following cross table checks were made against CDDA envelope

1. Designations - Designation boundaries

All combinations PARENT_ISO, ISO3, DESIG_ABBR in the Designation boundaries should be available also in the Designations table.

OK - the test was passed successfully.

2. Sites - Designations

All combiantions of PARENT_ISO and DESIG_ABBR in the Sites table should be available also in the Designations table. Only rows which have 'To_be_deleted' = False (both tables) will be compared.

OK - the test was passed successfully.

3. Sites - Site boundaries

3.1 All combiantions of SITE_CODE, SITE_CODE_NAT, PARENT_ISO, ISO3 in the Sites table should be available also in the Site boundaries table. Only rows which have 'To_be_deleted' = False will be compared.

ERROR - the test was not passed. The following combinations found from Sites table are missing in the Site boundaries table
RowSITE_CODESITE_CODE_NATPARENT_ISOISO3
9041694896579AUTAUT

3.2 All combiantions of SITE_CODE, SITE_CODE_NAT, PARENT_ISO, ISO3 in the Site boundaries table should be available also in the Sites table.

OK - the test was passed successfully.

3.3 Each site which have CDDA_coordinates_code = '02' should have CDDA_Availability_code='01' in Site boundaries table.

OK - the test was passed successfully.