Data Quality Toolkit 2024: Difference between revisions

no edit summary
No edit summary
Line 42: Line 42:
'''Problem:''' The sign of the latitude (decimalLatitude) or longitude (decimalLongitude) does not match the sign/hemisphere of the given country. For example, all longitudes in the U.S. should be negative.
'''Problem:''' The sign of the latitude (decimalLatitude) or longitude (decimalLongitude) does not match the sign/hemisphere of the given country. For example, all longitudes in the U.S. should be negative.


'''How to FIND this Problem in Your Dataset:'''
'''Solutions:'''
* Arctos
* Excel
* OpenRefine
* Specify
* Symbiota
* TaxonWorks
 
'''How to FIX this Problem in your Dataset:'''
* Arctos
* Arctos
* Excel
* Excel
Line 61: Line 53:
'''Problem:''' A record has a latitude value, but not a longitude value.
'''Problem:''' A record has a latitude value, but not a longitude value.


'''How to FIND this Problem in Your Dataset:'''
'''Solutions:'''
* Arctos
* Excel
* OpenRefine
* Specify
* Symbiota
* TaxonWorks
 
'''How to FIX this Problem in your Dataset:'''
* Arctos
* Arctos
* Excel
* Excel
Line 80: Line 64:
'''Problem:''' The geographic units (e.g., country, state, county) are misspelled, resulting in poor matching of geographic unit names to existing geographic lists.
'''Problem:''' The geographic units (e.g., country, state, county) are misspelled, resulting in poor matching of geographic unit names to existing geographic lists.


'''How to FIND this Problem in Your Dataset:'''
'''Solutions:'''
* Arctos
* Excel
* OpenRefine
* Specify
* Symbiota
* TaxonWorks
 
'''How to FIX this Problem in your Dataset:'''
* Arctos
* Arctos
* Excel
* Excel
Line 101: Line 77:
'''Problem:''' Scientific names are misspelled, resulting in poor matching of taxonomic names to taxonomic databases.
'''Problem:''' Scientific names are misspelled, resulting in poor matching of taxonomic names to taxonomic databases.


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

edits