iDigBio

Data Quality Toolkit 2024: Difference between revisions

Page Discussion

Data Quality Toolkit 2024 (view source)

Revision as of 13:51, 16 February 2024

1,362 bytes removed ,  16 February 2024
no edit summary
No edit summary
Line 15: Line 15:


'''How to FIND this Problem in Your Dataset:'''
'''How to FIND this Problem in Your Dataset:'''
* '''Arctos:'''
* Arctos
* '''Excel:'''
* Excel
* '''OpenRefine'''
* OpenRefine
* '''Specify:'''
* Specify
* '''[[Data Quality Toolkit 2024 Symbiota#Duplicate Catalog Numbers|Symbiota]]'''
* [[Data Quality Toolkit 2024 Symbiota#Duplicate Catalog Numbers|Symbiota]]
* '''TaxonWorks:'''
* TaxonWorks


'''How to FIX this Problem in your Dataset:'''
How to FIX this Problem in your Dataset:
* '''Arctos:'''
* Arctos
* '''Excel:'''
* Excel
* '''OpenRefine'''
* OpenRefine
* '''Specify:'''
* Specify
* '''Symbiota:'''
* Symbiota
* '''TaxonWorks:'''
* TaxonWorks


== Dates ==
== Dates ==
Line 36: Line 36:


'''How to FIND this Problem in Your Dataset:'''
'''How to FIND this Problem in Your Dataset:'''
* '''Arctos:'''
* Arctos
* '''Excel:'''
* Excel
* '''OpenRefine'''
* OpenRefine
* '''Specify:'''
* Specify
* '''Symbiota:'''
* Symbiota
* '''TaxonWorks:'''
* TaxonWorks


'''How to FIX this Problem in your Dataset:'''
'''How to FIX this Problem in your Dataset:'''
* '''Arctos:'''
* Arctos
* '''Excel:'''
* Excel
* '''OpenRefine'''
* OpenRefine
* '''Specify:'''
* Specify
* '''Symbiota:'''
* Symbiota
* '''TaxonWorks:'''
* TaxonWorks


== Geography ==
== Geography ==
Line 57: Line 57:


'''How to FIND this Problem in Your Dataset:'''
'''How to FIND this Problem in Your Dataset:'''
* '''Arctos:'''
* Arctos
* '''Excel:'''
* Excel
* '''OpenRefine'''
* OpenRefine
* '''Specify:'''
* Specify
* '''Symbiota:'''
* Symbiota
* '''TaxonWorks:'''
* TaxonWorks


'''How to FIX this Problem in your Dataset:'''
'''How to FIX this Problem in your Dataset:'''
* '''Arctos:'''
* Arctos
* '''Excel:'''
* Excel
* '''OpenRefine'''
* OpenRefine
* '''Specify:'''
* Specify
* '''Symbiota:'''
* Symbiota
* '''TaxonWorks:'''
* TaxonWorks


=== Missing Latitudes/Longitudes ===
=== Missing Latitudes/Longitudes ===
Line 76: Line 76:


'''How to FIND this Problem in Your Dataset:'''
'''How to FIND this Problem in Your Dataset:'''
* '''Arctos:'''
* Arctos
* '''Excel:'''
* Excel
* '''OpenRefine'''
* OpenRefine
* '''Specify:'''
* Specify
* '''Symbiota:''' Use the [https://biokic.github.io/symbiota-docs/editor/edit/ Record Search form]. For Custom Field 1, select Decimal Latitude IS NULL. For Custom Field 2, select Decimal Longitude IS NOT NULL. Then conduct a similar search with Decimal Latitude IS NOT NULL and Decimal Longitude IS NULL.
* Symbiota
* '''TaxonWorks:'''
* TaxonWorks


'''How to FIX this Problem in your Dataset:'''
'''How to FIX this Problem in your Dataset:'''
* '''Arctos:'''
* Arctos
* '''Excel:'''
* Excel
* '''OpenRefine'''
* OpenRefine
* '''Specify:'''
* Specify
* '''Symbiota:''' No batch fixing possible. You will need to review the records and either add lat/long values or remove the orphaned lat/long values.
* Symbiota
* '''TaxonWorks:'''
* TaxonWorks


=== Misspelled Geographic Unit Names ===
=== Misspelled Geographic Unit Names ===
Line 95: Line 95:


'''How to FIND this Problem in Your Dataset:'''
'''How to FIND this Problem in Your Dataset:'''
* '''Arctos:'''
* Arctos
* '''Excel:'''
* Excel
* '''OpenRefine'''
* OpenRefine
* '''Specify:'''
* Specify
* '''Symbiota:''' Use the [https://biokic.github.io/symbiota-docs/coll_manager/data_cleaning/geography/ Geography Cleaning Tools]
* Symbiota
* '''TaxonWorks:'''
* TaxonWorks


'''How to FIX this Problem in your Dataset:'''
'''How to FIX this Problem in your Dataset:'''
* '''Arctos:'''
* Arctos
* '''Excel:'''
* Excel
* '''OpenRefine'''
* OpenRefine
* '''Specify:'''
* Specify
* '''Symbiota:''' Use the [https://biokic.github.io/symbiota-docs/coll_manager/data_cleaning/geography/ Geography Cleaning Tools]
* Symbiota
* '''TaxonWorks:'''
* TaxonWorks


== Taxonomy ==
== Taxonomy ==
Line 116: Line 116:


'''How to FIND this Problem in Your Dataset:'''
'''How to FIND this Problem in Your Dataset:'''
* '''Arctos:'''
* Arctos
* '''Excel:'''
* Excel
* '''OpenRefine'''
* OpenRefine
* '''Specify:'''
* Specify
* '''Symbiota:''' Use the [https://biokic.github.io/symbiota-docs/coll_manager/data_cleaning/taxonomy/ Taxonomic Cleaning Tool]
* Symbiota
* '''TaxonWorks:'''
* TaxonWorks


'''How to FIX this Problem in your Dataset:'''
'''How to FIX this Problem in your Dataset:'''
* '''Arctos:'''
* Arctos
* '''Excel:'''
* Excel
* '''OpenRefine'''
* OpenRefine
* '''Specify:'''
* Specify
* '''Symbiota:''' Use the [https://biokic.github.io/symbiota-docs/coll_manager/data_cleaning/taxonomy/ Taxonomic Cleaning Tool]
* Symbiota
* '''TaxonWorks:'''
* TaxonWorks
Kds15e
255

edits

Retrieved from "http://www.idigbio.org/wiki/index.php/Special:MobileDiff/34668"