based on a document prepared by Neil G (VME_Data_Checklist_V2)
actions:
[x] @NauticalNeil to upload the VME checklist document to WGDEC community.ices.dk site
[ ] @pcrjoana to work with @NauticalNeil to add the specifics into the overall data schema
[ ] @NauticalNeil to provide new checks, corrections to existing checks to Anna
[ ] @laurar97 and @NauticalNeil to think about resubmission package envelope and key
[x] @neil-ices-dk to setup project board for QA subgroup; see board here
1. Dataflow schematic
There is an overall schematic being developed as part of the ICES Accreditation process.
Neil G has also developed a more specific version in the QC document which incorporates the use of the VME QA sub-group
The group agreed that this specific version should be incorporated into the overall schematic - so there is one master reference;
2. Automated QC elements
current QC checks are under review by NeilG; to be provided to Anna for review. Especially what is defined as a 'warning' and 'critical error'
VME_HabitatType like 'DS’ = TaxonLatinName not like 'Acanella arbuscula'
Warning
Cold-water coral reef
VME_HabitatType like 'CC' = TaxonLatinName not like 'Acanthogorgia'
Warning
Cold-water coral reef
VME_HabitatType like 'CC' = TaxonLatinName not like 'Alcyonacea'
Warning
Cold-water coral reef
VME_HabitatType like 'CC' = TaxonLatinName not like 'Alcyoniina'
Warning
Cold-water coral reef
VME_HabitatType like 'CC' = TaxonLatinName not like 'Geodia '
Error
Cold-water coral reef
VME_HabitatType like 'CC' = VME_HabitatSubtype not in ('HB%’, ‘SB%’, ‘VA’, ‘VI’)
Error
Coral Gardens
VME_HabitatType like 'CG' = VME_HabitatSubtype not in ('LMR’, ‘SVR’, ‘VA’, ‘VI’)
Error
Mud & sand emergent fauna
VME_HabitatType like ('BP', 'SCA', 'TAA', 'XA') = VME_HabitatSubtype not in ('HB%', 'SB%', 'LMR', 'SVR', 'VA', 'VI')
Error
Sea-pen fields
VME_HabitatType like ‘SP’ = VME_HabitatSubtype not in ('HB%', 'SB%', 'LMR', 'SVR', 'VA', 'VI')
Error
Hydrothermal vents/fields
VME_HabitatType like ‘HTF’ = VME_HabitatSubtype not in ('HB%', 'SB%' 'LMR', 'SVR')
Error
Gorgonian
If TaxonLatinName is 'Acanthogorgia' and VME_Indicator is not null, the VME_Indicator should be 'GG'?
Error
Soft Coral
If TaxonLatinName is ' Alcyoniina' and VME_Indicator is not null, the VME_Indicator should be 'SC'?
Error
Soft Coral
If TaxonLatinName is ' Alcyonacea' and VME_Indicator is not null, the VME_Indicator should be 'SC'?
Error
3. Manual QC Checks
manual checks will be part of the QA sub-group work, that comes after the auto QC checks stage
spot checks on new data submissions; any new QC issues to be raised as a new issue to be prioritized by QA group on implementation as an automated check;
4. resubmissions
the business rules need to be defined i.e. case key that (fields that identify the unique version of this dataset
see example of case envelope and how this is defined as a resubmission in diagram below
5. QA sub-group operating procedures
NeilG has drafted the aim, tasks and mode of operation of the sub-group
suggest to avoid formality of language to avoid looking like a resolution for a new group
using Github will enable the membership/interaction
based on a document prepared by Neil G (VME_Data_Checklist_V2)
actions:
1. Dataflow schematic
There is an overall schematic being developed as part of the ICES Accreditation process. Neil G has also developed a more specific version in the QC document which incorporates the use of the VME QA sub-group
The group agreed that this specific version should be incorporated into the overall schematic - so there is one master reference;
2. Automated QC elements
3. Manual QC Checks
4. resubmissions
5. QA sub-group operating procedures