TG2-AMENDMENT_DAY_STANDARDIZED

[pzermoglio]

TestField	Value
GUID	b129fa4d-b25b-43f7-9645-5ed4d44b357b
Label	AMENDMENT_DAY_STANDARDIZED
Description	Propose amendment to the value of dwc:day as an integer between 1 and 31 inclusive.
TestType	Amendment
Darwin Core Class	Event
Information Elements ActedUpon	dwc:day
Information Elements Consulted
Expected Response	INTERNAL_PREREQUISITES_NOT_MET if dwc:day is EMPTY; AMENDED the value of dwc:day if the value was unambiguously interpreted as an integer between 1 and 31 inclusive; otherwise NOT_AMENDED
Data Quality Dimension	Conformance
Term-Actions	DAY_STANDARDIZED
Parameter(s)
Source Authority
Specification Last Updated	2023-09-18
Examples	[dwc:day="23rd": Response.status=AMENDED, Response.result=dwc:day="23", Response.comment="dwc:day is interpretable as "23""]
	[dwc:day="X": Response.status=NOT_AMENDED, Response.result="", Response.comment="dwc:day is ambiguous, either a "X", "No data" or "10""]
Source	TG2-Gainesville
References
Example Implementations (Mechanisms)	Kurator:event_date_qc
Link to Specification Source Code	A potential minimal implementation is at: https://github.com/FilteredPush/event_date_qc/blob/238f234a4947b3c2820fb2fe3987326f9ead5e54/src/main/java/org/filteredpush/qc/date/DwCEventDQ.java#L1114 unit test at https://github.com/FilteredPush/event_date_qc/blob/238f234a4947b3c2820fb2fe3987326f9ead5e54/src/test/java/org/filteredpush/qc/date/DwcEventDQTest.java#L824
Notes	If dwc:day contains text that may be interpreted as Roman numerals, the result will be NOT_AMENDED as this is not standard. Values such as "3rd" or "12th" can be interpreted as the integers "3" and "12". Text such as "5th Friday" is ambiguous.

[chicoreus]

This issue and #128 and #129 feel like they may not belong in core, but as upstream tests for use cases involving preparing data for publication in Darwin Core like UPSTREAM_EVENTDATE_FILLED_IN_FROM_START_END urn:uuid:e4ddf9bc-cd10-46cc-b307-d6c7233a240a in Kurator

[chicoreus]

Need a clear definition of what things this amendment should attempt to do. Based on the example, I would suggest removing all non-numeric characters and attempting to parse an integer in the range of 1-31 out of the remaining characters. I would propose explicitly excluding roman numerals from translation here (as their presence in day suggests a transposition of day and month in the biodiversity domain) (MUST_NOT translate roman numerals to integers). Unclear if text "first", "second", etc, and in languages other than English should or should not be supported. If an upstream data preparation test, may need to translate numbers from more parts of the unicode character set into integers, this might be a MAY condition.

[ArthurChapman]

These are tests not in our original suite of tests, and like Paul, I question their value as CORE. I know some good arguments were put forward in Gainesville where some easy one may be corrected (as in example), but we excluded a number of other tests on Day and Month as we didn't regard those fields as CORE (other than helping to populate eventDate. I can see arguments for keeping YEAR as I know a lot of people use this on its own, but DAY and MONTH less so. I agree with @chicoreus - move to SUPPLEMENTAL

[Tasilee]

I would agree with SUPPLEMENTAL for dwc:day

[ArthurChapman]

I am not sure our description for this is good. Perhaps we should add "unambiguously" interpreted. For example do we want to convert "32" to "23" - other examples?

[Tasilee]

I agree about "unambiguosly"...will edit in. That makes "32" ambiguous as it could be "23" or "13" with typo etc.

[chicoreus]

Let's pose some examples, with some alternatives included:

Value	Interpretation	Note
1	1	It's an integer, no change needed
1st	1	Strip off trailing 'st' (ordinal indicator)
first	1	Interpret string
2nd	2	Strip off trailing 'nd' (ordinal indicator)
2ú	2	Strip off trailing 'ú' (irish ordinal indicator)
2º	2	Strip off trailing 'º' (spanish masculine ordinal indicator)
第二	2	Strip off ordinal prefix 第 , translate 二 to 2
二	2	Translate 二 to 2
3rd	3	Strip off trailing 'rd' (ordinal indicator)
3:e	3	Strip off trailing ':e' (Swedish ordinal indicator )
ke-3	3	Strip off leading 'ke-' (Malay ordinal indicator )
4th	4	Strip off trailing 'th' (ordinal indicator)
4ᵗʰ	4	Strip off trailing superscript 'th' (ordinal indicator)
1-2		A range, can't interpret.
1-2	1	A range, interpret as start value.
1 to 2		A range, can't interpret.
1 to 2	1	A range, interpret as start value.
32nd		Stripping off 'nd' leaves an out of range value.
1u		Can't interpret. Could be 1 with trailing string, or 17 with right hand in wrong place on keyboard, or irish ordinal indicator without accent...
1u	1	Strip off non numeric characters, found only a single integer in range.

We could define this test as removing strings that appear to be ordinal indicators and proposing a bare integer, so long as it is in the range 1 to 31 inclusive. Or we could define this test as checking to see if the day contains a single integer in the range 1 to 31, and if so, removing all other characters from the day value. Or...

[Tasilee]

So, where are we with this? Various TAGS have been added, removed, re-added etc.

TIME resolution to day makes this less important than month and year but does this alone make it NOT_CORE? @chicoreus provides examples where we could unambiguously AMEND (e.g., "one", "two", "thirty one", "first", "second", "thirty first","1st", "2nd", "31st".

Comments please.

[Tasilee]

Updated Note based on recent discussions:

If dwc:day contains text that may be interpreted as Roman numerals, the result will be "NOT_AMENDED" as this is not standard. Values such as "3rd" or "12th" can be interpreted as the integers "3" and "12". Text such as "5th Friday" is ambiguous.

[Tasilee]

Splitting bdqffdq:Information Elements into "Information Elements ActedUpon" and "Information Elements Consulted".

Also changed "Field" to "TestField", "Output Type" to "TestType" and updated "Specification Last Updated"