Validation errors for MICA Agouti dataset about mica-occurrences

[EmmaCartuyvels1]

Deployments 1, 2 and 4 do have timestamps in Agouti:

Deployments 3, 5, 6 are not to be found on Agouti

[peterdesmet]

Thanks for investigating

[peterdesmet]

Validation of latest export:

• 71d10e66-8189-452b-b911-b45560fa5221,380077a1-389f-4ddb-bd6d-9c5e40ce1c56,,208d0088-57fe-4314-9949-4de1b3cc0fcd,+02:00,+02:00,event,unknown
• aaf1e84f-90c0-4087-a546-8243c0f458b5,8520f7c9-15db-4274-ac11-7f9b42df6551,,74de0d1d-e88c-4155-8377-76dff068a4b3,+01:00,+01:00,event,blank
• 25e5417e-cd3b-4c57-ae19-319f3bf67a41,d247656d-cb58-4fb1-b860-7e7f863646ee,,fe0dfaae-d65c-4320-bbce-4df960bdec94,+01:00,+01:00,event,blank
• 501aac62-c647-44d4-8904-daf352e3fc46,f34058ce-aba3-4599-b1e3-b41e5a4739e6,,501aac62-c647-44d4-8904-daf352e3fc46,+01:00,+01:00,event,unclassified
• d27a6b66-f3c6-47e5-8da9-cdb427fa8d58,f34058ce-aba3-4599-b1e3-b41e5a4739e6,,d27a6b66-f3c6-47e5-8da9-cdb427fa8d58,+01:00,+01:00,event,unclassified
• aaf1e84f-90c0-4087-a546-8243c0f458b5,8520f7c9-15db-4274-ac11-7f9b42df6551,,74de0d1d-e88c-4155-8377-76dff068a4b3,+01:00,+01:00,event,blank

──────────────────────────────────────────────────────────────────────────────────────── Dataset ────────────────────────────────────────────────────────────────────────────────────────
                       dataset                       
┏━━━━━━━━━━━━━━┳━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━┓
┃ name         ┃ type  ┃ path             ┃ status  ┃
┡━━━━━━━━━━━━━━╇━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━┩
│ deployments  │ table │ deployments.csv  │ VALID   │
│ media        │ table │ media.csv        │ VALID   │
│ observations │ table │ observations.csv │ INVALID │
└──────────────┴───────┴──────────────────┴─────────┘
──────────────────────────────────────────────────────────────────────────────────────── Tables ─────────────────────────────────────────────────────────────────────────────────────────
                                                                          observations                                                                          
┏━━━━━━━━┳━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓
┃ Row    ┃ Field ┃ Type       ┃ Message                                                                                                                        ┃
┡━━━━━━━━╇━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┩
│ 47884  │ 5     │ type-error │ Type error in the cell "+02:00" in row "47884" and field "eventStart" at position "5": type is "datetime/%Y-%m-%dT%H:%M:%S%z"  │
│ 47884  │ 6     │ type-error │ Type error in the cell "+02:00" in row "47884" and field "eventEnd" at position "6": type is "datetime/%Y-%m-%dT%H:%M:%S%z"    │
│ 100011 │ 5     │ type-error │ Type error in the cell "+01:00" in row "100011" and field "eventStart" at position "5": type is "datetime/%Y-%m-%dT%H:%M:%S%z" │
│ 100011 │ 6     │ type-error │ Type error in the cell "+01:00" in row "100011" and field "eventEnd" at position "6": type is "datetime/%Y-%m-%dT%H:%M:%S%z"   │
│ 114907 │ 5     │ type-error │ Type error in the cell "+01:00" in row "114907" and field "eventStart" at position "5": type is "datetime/%Y-%m-%dT%H:%M:%S%z" │
│ 114907 │ 6     │ type-error │ Type error in the cell "+01:00" in row "114907" and field "eventEnd" at position "6": type is "datetime/%Y-%m-%dT%H:%M:%S%z"   │
│ 151170 │ 5     │ type-error │ Type error in the cell "+01:00" in row "151170" and field "eventStart" at position "5": type is "datetime/%Y-%m-%dT%H:%M:%S%z" │
│ 151170 │ 6     │ type-error │ Type error in the cell "+01:00" in row "151170" and field "eventEnd" at position "6": type is "datetime/%Y-%m-%dT%H:%M:%S%z"   │
│ 176577 │ 5     │ type-error │ Type error in the cell "+01:00" in row "176577" and field "eventStart" at position "5": type is "datetime/%Y-%m-%dT%H:%M:%S%z" │
│ 176577 │ 6     │ type-error │ Type error in the cell "+01:00" in row "176577" and field "eventEnd" at position "6": type is "datetime/%Y-%m-%dT%H:%M:%S%z"   │
│ 176578 │ 5     │ type-error │ Type error in the cell "+01:00" in row "176578" and field "eventStart" at position "5": type is "datetime/%Y-%m-%dT%H:%M:%S%z" │
│ 176578 │ 6     │ type-error │ Type error in the cell "+01:00" in row "176578" and field "eventEnd" at position "6": type is "datetime/%Y-%m-%dT%H:%M:%S%z"   │
└────────┴───────┴────────────┴────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘

[peterdesmet]

I manually removed the 6 invalid observations from the export and republished the dataset: https://ipt.inbo.be/resource?r=mica-agouti-occurrences They are not fixed in Agouti.