Skip to content

Fix erroneous or obsolete dateloc values in yields table and normalize date values. #4

Open
@gsrohde

Description

@gsrohde

The permissible dateloc values are now limited to 5, 6, 7, 8, 9, 95, 96, and 97 (and possibly 5.5).

For each dateloc value other than 5, there are now prescribed values for year, month, and day for use in representing indeterminate information.

The script https://github.com/PecanProject/bety-qaqc/blob/master/date_time_cleanup/Yield_dates_fix_script.sql comprises my proposed procedure for dealing with anomalous representations of yield dates.

@dlebauer, @robkooper I'd like another set of eyes on this before I go ahead with the cleanup.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions