Solution: Successfully load and test dataset on databox
Actions Taken:
Inconsistencies with the data identified and informed back to the data provider
Updated data received from the data provider.
Successfully loaded the data on databox
Data reviewed
Columns deleted - 'institutionCode', 'collectionCode', 'license'
Columns renamed - 'DepthAverage metres', 'Location'
Empty columns deleted
DwcA created locally
Loaded the data on collectory-test
Ran preingestion on databox
Initial inconsistencies with the data:
catalogNumber: This identifier is identical across every record in both CSVs.
geodeticDatum (ALA_Carpentaria_FIsh_by_Location_Site.csv): The values in this column appear as EPSG:4326, EPSG:4327, EPSG:4328, which seem incorrect and may have been auto-filled.
Date Format: The dates should conform to ISO 8601-1:2019, which specifies that dates should be formatted as YYYY-MM-DD.
Metadata File: There are two CSVs covered by a single metadata file.
scientificName Columns:
The ALA_Carpentaria_benthos_by_Location_Tow.csv file has values in the scientificName column that represent kingdom and phylum levels.
Ticket Update: June 18, 2024 (6:45 PM)
Issue: New Dataset
Solution: Successfully load and test dataset on databox
Actions Taken: Inconsistencies with the data identified and informed back to the data provider Updated data received from the data provider.
Successfully loaded the data on databox Data reviewed Columns deleted - 'institutionCode', 'collectionCode', 'license' Columns renamed - 'DepthAverage metres', 'Location' Empty columns deleted DwcA created locally Loaded the data on collectory-test Ran preingestion on databox
Loaded data for review: Metadata: data
Initial inconsistencies with the data: catalogNumber: This identifier is identical across every record in both CSVs. geodeticDatum (ALA_Carpentaria_FIsh_by_Location_Site.csv): The values in this column appear as EPSG:4326, EPSG:4327, EPSG:4328, which seem incorrect and may have been auto-filled. Date Format: The dates should conform to ISO 8601-1:2019, which specifies that dates should be formatted as YYYY-MM-DD. Metadata File: There are two CSVs covered by a single metadata file. scientificName Columns: The ALA_Carpentaria_benthos_by_Location_Tow.csv file has values in the scientificName column that represent kingdom and phylum levels.
Status: Test links sent to the data provider