Account services

CDDA data collection 2012 - additional information

Released on 2012-01-31 by: Marek Staron

To: Eionet PCPs and NRCs for Nature Protection and Biodiversity

Cc: Eionet National Focal Points

From: Marek Staron, EEA, on behalf of Rania Spyropoulou

Dear Colleague,

As we have announced in the CDDA data collection 2012 request letter from 16 December 2011, we are sending you this second letter to inform you about the recent development concerning the data collection.

Template error fix

Please fix your MS Access template database by using the provided file.

An error slipped into the pre-loaded MS Access template database. It appears when you try to export the data into xml files. As this critical problem prevents you from using the Automatic QA service on the CDR, we have prepared a small MS Access application which will fix the problem. It is very easy to use. Please follow these instructions:

CDDA template database
  1. Download CDDA_2012_templatefix.zip
  2. Unzip the file to the folder where your CDDA template database is placed
  3. Close the CDDA template database if it is open
  4. Open the CDDA_2012_templatefix.mdb
  5. Press the 'Browse' button and select the template database
  6. Press the 'Fix the CDDA database' button

The fix runs very fast so you should be immediately informed that it was successful. If an unexpected error occurs please contact Marek Staron.

We sincerely apologize for any inconvenience this problem could cause you.

Automatic QA

Please export your data to xml files, upload them and check the results of the automatic QA.

We have finished the update of the automatic quality assurance (QA) procedures for the CDDA data. They check the following data quality indicators:

  • availability of mandatory fields
  • duplicities in primary key fields
  • correctness of data types of provided values
  • correctness of used codes where codelists are defined
  • position of sites coordinates against the country boundary boxes

The automatic QA service requires that you upload your data in xml format. You get them by using the 'Generate XML files' function in your template. It will create one file per table. Please zip the files and upload them to the CDR together with the MS Access database. The zip archive will be automatically unzipped.

Once you are done, you will notice that a 'Run QA #1' button appears with each of the xml files in addition to the 'Run Full QA' and 'Run relation QA' buttons. We recommend that you use these in order to check the quality of your data. The full QA is automatically executed when you release the envelope and results are then stored in the Feedback section of the CDR envelope. If any problems are detected, please try to fix them and redeliver your data before you close the envelope. The more problems you can fix before you release the data, the faster your deliveries can be processed.

A further level of data quality checks will be carried out by ETC data managers and EEA, as usual.

CDDA preparation for INSPIRE - update

In the CDDA request letter, we announced that CDDA preparations for INSPIRE would be discussed with you at a workshop during 2012 Q1. The discussions with countries will now take place at a later date in 2012. Invitations will be sent in due course.

Helpdesk and support

helpdesk@ eionet.europa.eu

cdda@mnhn.fr

If the people working directly on the CDDA data delivery in your country are not PCPs or NRCs, please copy this letter to them so that they are aware of the wider context of their work at the European level.

Finally, we kindly remind you that the CDDA data collection period will run until 15 March 2012. We also sincerely apologize for any inconvenience the delay in the data collection preparation could cause you.

Marek Staron
EEA Project Officer - Data and indicators group
European Environment Agency