Overall:
Taxonomy needs to be added but this requires AFD to provide an API
Mapped parameters are missing, this could be related to the fact that the test databases is a small subset that may not have included the parameters missing
Empty values character has to be standardised, so far N\A,NULL and "" are used
There are multiple cases where a single observation id has multiple observations, this needs to be fixed. Create validation to check for single observation per observation type -foi combinations
The sensitivity analyses needs to be implemented in ETL
Metadata record has to be added
Amphibian individual
Check | Result | Notes |
|---|---|---|
Accuracy of mapping (are all mapped variables present?) | FAILED | Snout length and sampling duration seem to be missing. This potentially is due to no observation having this values OR test DB not having this observations |
Functionality in EcoPlots | PASSED | |
Completeness and functionality of download (API, cart) | PASSED | Cart download works API download works |
Functionality of data | PASSED | |
Transformation | FAILED | Multiple observations per parameter for unique foi id e.g. |
Joining,Analysing | PASSED | |
Integrity of data | NA | test data is only a subset |
Unique observation id | FAILED | see transformation row above, see example output below  |
Taxonomic information | FAILED | Missing taxon class. External dependency. Waiting for AFD to provide API endpoint |
Scientific name present and no more than 5% of names missing a taxon class | FAILED | Missing scientific name. Added to mapping |
Sensitive data | FAILED | Needs implementing. Cannot be implemented until AFD taxonomic matching is implemented |
Check citation is correct | FAILED | Needs implementing. Metadata record has not been added. Add https://portal-test.tern.org.au/biological-databases-south-australia/24602 |
...
Check | Result | Notes |
|---|---|---|
Accuracy of mapping (are all mapped variables present?) | FAILED | Missing: 1 sampling duration |
Functionality in EcoPlots | PASSED | |
Completeness and functionality of download (API, cart) | PASSED | |
Functionality of data | PASSED | |
Transformation | FAILED | Multiple observations per obs id |
Joining,Analysing | PASSED | |
Integrity of data | test data is only a subset | |
Unique observation id | PASSED | Multiple observations per obs id |
Taxonomic information | FAILED | Missing taxon class. External dependency. Waiting for AFD to provide API endpoint |
Scientific name present and no more than 5% of names missing a taxon class | FAILED | Missing scientific name row. Added to mapping |
Sensitive data | FAILED | Needs implementing. Cannot be implemented until AFD taxonomic matching is implemented |
Check citation is correct | FAILED | Needs implementing. Metadata record has not been added. Add https://portal-test.tern.org.au/biological-databases-south-australia/24602 |
Mammal individual
Check | Result | Notes |
|---|---|---|
Accuracy of mapping (are all mapped variables present?) | FAILED | MIssing: 1 lactating status |
Functionality in EcoPlots | PASSED | |
Completeness and functionality of download (API, cart) | PASSED | |
Functionality of data | PASSED | |
Transformation | PASSSED | |
Joining,Analysing | PASSED | |
Integrity of data | test data is only a subset | |
Unique observation id | PASSED | |
Taxonomic information | FAILED | Missing taxon class. External dependency. Waiting for AFD to provide API endpoint |
Scientific name present and no more than 5% of names missing a taxon class | PASSED | |
Sensitive data | FAILED | Needs implementing. Cannot be implemented until AFD taxonomic matching is implemented |
Check citation is correct | FAILED | Needs implementing. Metadata record has not been added. Add https://portal-test.tern.org.au/biological-databases-south-australia/24602 |
Mammal occurrence
Check | Result | Notes |
|---|---|---|
Accuracy of mapping (are all mapped variables present?) | FAILED | Missing variables : 1 animal relative habitat position |
Functionality in EcoPlots | PASSED | |
Functionality of download (API, cart) | PASSED | |
Functionality of data | PASSED | |
Transformation | PASSED | |
Joining,Analysing | PASSED | |
Integrity of data | test data is only a subset | |
Unique observation id | FAILED | Multiple observations per observation ID see:  |
Taxonomic information | FAILED | Missing taxon class. External dependency. Waiting for AFD to provide API endpoint |
Scientific name present and no more than 5% of names missing a taxon class | FAILED | Scientific name was missing in mapping. Missing name in mapping added. |
Sensitive data | FAILED | Needs implementing. Cannot be implemented until AFD taxonomic matching is implemented |
Check citation is correct | FAILED | Needs implementing. Metadata record has not been added. Add https://portal-test.tern.org.au/biological-databases-south-australia/24602 |
Reptile individual
Check | Result | Notes |
|---|---|---|
Accuracy of mapping (are all mapped variables present?) | FAILED | 2 number of individual animals |
Functionality in EcoPlots | PASSED | |
Completeness and functionality of download (API, cart) | PASSED | |
Functionality of data | ||
Transformation | PASSED | |
Joining,Analysing | PASSED | |
Integrity of data | test data is only a subset | |
Unique observation id | PASSED | |
Taxonomic information | FAILED | Missing taxon class. External dependency. Waiting for AFD to provide API endpoint |
Scientific name present and no more than 5% of names missing a taxon class | FAILED | Missing scientific name row. Added to mapping |
Sensitive data | FAILED | Needs implementing. Cannot be implemented until AFD taxonomic matching is implemented |
Check citation is correct | FAILED | Needs implementing. Metadata record has not been added. Add https://portal-test.tern.org.au/biological-databases-south-australia/24602 |
Reptile occurrence
Check | Result | Notes |
|---|---|---|
Accuracy of mapping (are all mapped variables present?) | FAILED | Missing variables: 1 animal relative habitat position |
Functionality in EcoPlots | PASSED | |
Completeness and functionality of download (API, cart) | PASSED | |
Functionality of data | PASSED | |
Transformation | FAILED | Multiple observations per observation id |
Joining,Analysing | PASSED | |
Integrity of data | test data is only a subset | |
Unique observation id | FAILED | Multiple observations per observation id |
Taxonomic information | FAILED | Missing taxon class. External dependency. Waiting for AFD to provide API endpoint |
Scientific name present and no more than 5% of names missing a taxon class | PASSED | |
Sensitive data | FAILED | Needs implementing. Cannot be implemented until AFD taxonomic matching is implemented |
Check citation is correct | FAILED | Needs implementing. Metadata record has not been added. Add https://portal-test.tern.org.au/biological-databases-south-australia/24602 |