255
edits
Data Quality Toolkit 2024: Difference between revisions
Jump to navigation
Jump to search
→Dates
(→Dates) |
|||
| Line 25: | Line 25: | ||
== Dates == | == Dates == | ||
=== Date Hasn't Happened Yet === | |||
'''Problem:''' The date the specimen was [https://dwc.tdwg.org/terms/#dwc:dateIdentified identified], collected (often designated using the [https://dwc.tdwg.org/terms/#dwc:eventDate eventDate] field), or [https://dwc.tdwg.org/terms/#dwc:georeferencedDate georeferenced] is in the future. | |||
'''Solutions:''' | |||
* Arctos | |||
* Excel | |||
* OpenRefine | |||
* Specify | |||
* Symbiota | |||
* TaxonWorks | |||
=== Date is Suspiciously Old === | |||
'''Problem:''' The date the specimen was [https://dwc.tdwg.org/terms/#dwc:dateIdentified identified], collected (often designated using the [https://dwc.tdwg.org/terms/#dwc:eventDate eventDate] field), or [https://dwc.tdwg.org/terms/#dwc:georeferencedDate georeferenced] is outside the expected historical date range. The expected date range depends on the institution, but it is unlikely that most collections have specimens with dates prior to 1600. | |||
'''Solutions:''' | |||
* Arctos | |||
* Excel | |||
* OpenRefine | |||
* Specify | |||
* Symbiota | |||
* TaxonWorks | |||
=== Identified Date Earlier than Collected Date === | === Identified Date Earlier than Collected Date === | ||
'''Problem:''' The date the specimen was identified (dateIdentified field) is earlier than the date the specimen was collected (eventDate). | '''Problem:''' The date the specimen was identified (dateIdentified field) is earlier than the date the specimen was collected (eventDate). | ||
'''Solutions:''' | |||
* Arctos | |||
* Excel | |||
* OpenRefine | |||
* Specify | |||
* Symbiota | |||
* TaxonWorks | |||
=== Year, Month, and Day Values Do Not Match Date === | |||
'''Problem:''' The event [https://dwc.tdwg.org/terms/#dwc:year year], [https://dwc.tdwg.org/terms/#dwc:month month], and [https://dwc.tdwg.org/terms/#dwc:day day] values do not match the provided [https://dwc.tdwg.org/terms/#dwc:eventDate event date]. The event date is often the date of collection for preserved specimens. | |||
'''Solutions:''' | '''Solutions:''' | ||