Data Quality Toolkit 2024: Difference between revisions

Update page links
(Update page links)
Line 53: Line 53:


'''Solutions:'''
'''Solutions:'''
* Arctos
* [[Arctos Data Quality Toolkit#Identified Date Earlier than Collected Date|Arctos]]
* Excel
* [[Excel Data Quality Toolkit#Identified Date Earlier than Collected Date|Excel]]
* OpenRefine
* [[OpenRefine Data Quality Toolkit#Identified Date Earlier than Collected Date|OpenRefine]]
* Specify
* [[Specify Data Quality Toolkit#Identified Date Earlier than Collected Date|Specify]]
* Symbiota
* [[Symbiota Data Quality Toolkit#Identified Date Earlier than Collected Date|Symbiota]]
* TaxonWorks
* [[TaxonWorks Data Quality Toolkit#Identified Date Earlier than Collected Date|TaxonWorks]]


=== Year, Month, and Day Values Do Not Match Date ===
=== Year, Month, and Day Values Do Not Match Date ===
Line 64: Line 64:


'''Solutions:'''
'''Solutions:'''
* Arctos
* [[Arctos Data Quality Toolkit#Year, Month, and Day Values Do Not Match Date|Arctos]]
* Excel
* [[Excel Data Quality Toolkit#Year, Month, and Day Values Do Not Match Date|Excel]]
* OpenRefine
* [[OpenRefine Data Quality Toolkit#Year, Month, and Day Values Do Not Match Date|OpenRefine]]
* Specify
* [[Specify Data Quality Toolkit#Year, Month, and Day Values Do Not Match Date|Specify]]
* Symbiota
* [[Symbiota Data Quality Toolkit#Year, Month, and Day Values Do Not Match Date|Symbiota]]
* TaxonWorks
* [[TaxonWorks Data Quality Toolkit#Year, Month, and Day Values Do Not Match Date|TaxonWorks]]


== Geography ==
== Geography ==
Line 77: Line 77:


'''Solutions:'''
'''Solutions:'''
* Arctos
* [[Arctos Data Quality Toolkit#Coordinates are Zero|Arctos]]
* Excel
* [[Excel Data Quality Toolkit#Coordinates are Zero|Excel]]
* OpenRefine
* [[OpenRefine Data Quality Toolkit#Coordinates are Zero|OpenRefine]]
* Specify
* [[Specify Data Quality Toolkit#Coordinates are Zero|Specify]]
* Symbiota
* [[Symbiota Data Quality Toolkit#Coordinates are Zero|Symbiota]]
* TaxonWorks
* [[TaxonWorks Data Quality Toolkit#Coordinates are Zero|TaxonWorks]]


=== Coordinates Do Not Fall Within Named Geographic Unit ===
=== Coordinates Do Not Fall Within Named Geographic Unit ===
Line 88: Line 88:


'''Solutions:'''
'''Solutions:'''
* Arctos
* [[Arctos Data Quality Toolkit#Coordinates Do Not Fall Within Named Geographic Unit|Arctos]]
* Excel
* [[Excel Data Quality Toolkit#Coordinates Do Not Fall Within Named Geographic Unit|Excel]]
* OpenRefine
* [[OpenRefine Data Quality Toolkit#Coordinates Do Not Fall Within Named Geographic Unit|OpenRefine]]
* Specify
* [[Specify Data Quality Toolkit#Coordinates Do Not Fall Within Named Geographic Unit|Specify]]
* Symbiota
* [[Symbiota Data Quality Toolkit#Coordinates Do Not Fall Within Named Geographic Unit|Symbiota]]
* TaxonWorks
* [[TaxonWorks Data Quality Toolkit#Coordinates Do Not Fall Within Named Geographic Unit|TaxonWorks]]


=== Georeference Metadata with no Associated Georeference ===
=== Georeference Metadata with no Associated Georeference ===
Line 99: Line 99:


'''Solutions:'''
'''Solutions:'''
* Arctos
* [[Arctos Data Quality Toolkit#Georeference Metadata with no Associated Georeference|Arctos]]
* Excel
* [[Excel Data Quality Toolkit#Georeference Metadata with no Associated Georeference|Excel]]
* OpenRefine
* [[OpenRefine Data Quality Toolkit#Georeference Metadata with no Associated Georeference|OpenRefine]]
* Specify
* [[Specify Data Quality Toolkit#Georeference Metadata with no Associated Georeference|Specify]]
* Symbiota
* [[Symbiota Data Quality Toolkit#Georeference Metadata with no Associated Georeference|Symbiota]]
* TaxonWorks
* [[TaxonWorks Data Quality Toolkit#Georeference Metadata with no Associated Georeference|TaxonWorks]]


=== Elevation is Unlikely ===
=== Elevation is Unlikely ===
Line 110: Line 110:


'''Solutions:'''
'''Solutions:'''
* Arctos
* [[Arctos Data Quality Toolkit#Elevation is Unlikely|Arctos]]
* Excel
* [[Excel Data Quality Toolkit#Elevation is Unlikely|Excel]]
* OpenRefine
* [[OpenRefine Data Quality Toolkit#Elevation is Unlikely|OpenRefine]]
* Specify
* [[Specify Data Quality Toolkit#Elevation is Unlikely|Specify]]
* Symbiota
* [[Symbiota Data Quality Toolkit#Elevation is Unlikely|Symbiota]]
* TaxonWorks
* [[TaxonWorks Data Quality Toolkit#Elevation is Unlikely|TaxonWorks]]


=== Improperly Negated Latitudes/Longitudes ===
=== Improperly Negated Latitudes/Longitudes ===
Line 121: Line 121:


'''Solutions:'''
'''Solutions:'''
* Arctos
* [[Arctos Data Quality Toolkit#Improperly Negated Latitudes/Longitudes|Arctos]]
* Excel
* [[Excel Data Quality Toolkit#Improperly Negated Latitudes/Longitudes|Excel]]
* OpenRefine
* [[OpenRefine Data Quality Toolkit#Improperly Negated Latitudes/Longitudes|OpenRefine]]
* Specify
* [[Specify Data Quality Toolkit#Improperly Negated Latitudes/Longitudes|Specify]]
* Symbiota
* [[Symbiota Data Quality Toolkit#Improperly Negated Latitudes/Longitudes|Symbiota]]
* TaxonWorks
* [[TaxonWorks Data Quality Toolkit#Improperly Negated Latitudes/Longitudes|TaxonWorks]]


=== Invalid Coordinates ===
=== Invalid Coordinates ===
Line 133: Line 133:


'''Solutions:'''
'''Solutions:'''
* Arctos
* [[Arctos Data Quality Toolkit#Invalid Coordinates|Arctos]]
* Excel
* [[Excel Data Quality Toolkit#Invalid Coordinates|Excel]]
* OpenRefine
* [[OpenRefine Data Quality Toolkit#Invalid Coordinates|OpenRefine]]
* Specify
* [[Specify Data Quality Toolkit#Invalid Coordinates|Specify]]
* Symbiota
* [[Symbiota Data Quality Toolkit#Invalid Coordinates|Symbiota]]
* TaxonWorks
* [[TaxonWorks Data Quality Toolkit#Invalid Coordinates|TaxonWorks]]


=== Lower Geography Values are Provided, but No Higher Geography ===
=== Lower Geography Values are Provided, but No Higher Geography ===
Line 144: Line 144:


'''Solutions:'''
'''Solutions:'''
* Arctos
* [[Arctos Data Quality Toolkit#Lower Geography Values are Provided, but No Higher Geography|Arctos]]
* Excel
* [[Excel Data Quality Toolkit#Lower Geography Values are Provided, but No Higher Geography|Excel]]
* OpenRefine
* [[OpenRefine Data Quality Toolkit#Lower Geography Values are Provided, but No Higher Geography|OpenRefine]]
* Specify
* [[Specify Data Quality Toolkit#Lower Geography Values are Provided, but No Higher Geography|Specify]]
* Symbiota
* [[Symbiota Data Quality Toolkit#Lower Geography Values are Provided, but No Higher Geography|Symbiota]]
* TaxonWorks
* [[TaxonWorks Data Quality Toolkit#Lower Geography Values are Provided, but No Higher Geography|TaxonWorks]]


=== Minimum and Maximum Elevation Values Mismatched ===
=== Minimum and Maximum Elevation Values Mismatched ===
Line 155: Line 155:


'''Solutions:'''
'''Solutions:'''
* Arctos
* [[Arctos Data Quality Toolkit#Minimum and Maximum Elevation Values Mismatched|Arctos]]
* Excel
* [[Excel Data Quality Toolkit#Minimum and Maximum Elevation Values Mismatched|Excel]]
* OpenRefine
* [[OpenRefine Data Quality Toolkit#Minimum and Maximum Elevation Values Mismatched|OpenRefine]]
* Specify
* [[Specify Data Quality Toolkit#Minimum and Maximum Elevation Values Mismatched|Specify]]
* Symbiota
* [[Symbiota Data Quality Toolkit#Minimum and Maximum Elevation Values Mismatched|Symbiota]]
* TaxonWorks
* [[TaxonWorks Data Quality Toolkit#Minimum and Maximum Elevation Values Mismatched|TaxonWorks]]


=== Mismatched Country and CountryCode Values ===
=== Mismatched Country and CountryCode Values ===
Line 166: Line 166:


'''Solutions:'''
'''Solutions:'''
* Arctos
* [[Arctos Data Quality Toolkit#Mismatched Country and CountryCode Values|Arctos]]
* Excel
* [[Excel Data Quality Toolkit#Mismatched Country and CountryCode Values|Excel]]
* OpenRefine
* [[OpenRefine Data Quality Toolkit#Mismatched Country and CountryCode Values|OpenRefine]]
* Specify
* [[Specify Data Quality Toolkit#Mismatched Country and CountryCode Values|Specify]]
* Symbiota
* [[Symbiota Data Quality Toolkit#Mismatched Country and CountryCode Values|Symbiota]]
* TaxonWorks
* [[TaxonWorks Data Quality Toolkit#Mismatched Country and CountryCode Values|TaxonWorks]]


=== Mismatched Geographic Terms ===
=== Mismatched Geographic Terms ===
Line 177: Line 177:


'''Solutions:'''
'''Solutions:'''
* Arctos
* [[Arctos Data Quality Toolkit#Mismatched Geographic Terms|Arctos]]
* Excel
* [[Excel Data Quality Toolkit#Mismatched Geographic Terms|Excel]]
* OpenRefine
* [[OpenRefine Data Quality Toolkit#Mismatched Geographic Terms|OpenRefine]]
* Specify
* [[Specify Data Quality Toolkit#Mismatched Geographic Terms|Specify]]
* Symbiota
* [[Symbiota Data Quality Toolkit#Mismatched Geographic Terms|Symbiota]]
* TaxonWorks
* [[TaxonWorks Data Quality Toolkit#Mismatched Geographic Terms|TaxonWorks]]


=== Missing Geodetic Datum ===
=== Missing Geodetic Datum ===
Line 188: Line 188:


'''Solutions:'''
'''Solutions:'''
* Arctos
* [[Arctos Data Quality Toolkit#Missing Geodetic Datum|Arctos]]
* Excel
* [[Excel Data Quality Toolkit#Missing Geodetic Datum|Excel]]
* OpenRefine
* [[OpenRefine Data Quality Toolkit#Missing Geodetic Datum|OpenRefine]]
* Specify
* [[Specify Data Quality Toolkit#Missing Geodetic Datum|Specify]]
* Symbiota
* [[Symbiota Data Quality Toolkit#Missing Geodetic Datum|Symbiota]]
* TaxonWorks
* [[TaxonWorks Data Quality Toolkit#Missing Geodetic Datum|TaxonWorks]]


=== Missing Latitudes/Longitudes ===
=== Missing Latitudes/Longitudes ===
Line 199: Line 199:


'''Solutions:'''
'''Solutions:'''
* Arctos
* [[Arctos Data Quality Toolkit#Missing Latitudes/Longitudes|Arctos]]
* Excel
* [[Excel Data Quality Toolkit#Missing Latitudes/Longitudes|Excel]]
* OpenRefine
* [[OpenRefine Data Quality Toolkit#Missing Latitudes/Longitudes|OpenRefine]]
* Specify
* [[Specify Data Quality Toolkit#Missing Latitudes/Longitudes|Specify]]
* Symbiota
* [[Symbiota Data Quality Toolkit#Missing Latitudes/Longitudes|Symbiota]]
* TaxonWorks
* [[TaxonWorks Data Quality Toolkit#Missing Latitudes/Longitudes|TaxonWorks]]


=== Misspelled Geographic Unit Names ===
=== Misspelled Geographic Unit Names ===
Line 210: Line 210:


'''Solutions:'''
'''Solutions:'''
* Arctos
* [[Arctos Data Quality Toolkit#Misspelled Geographic Unit Names|Arctos]]
* Excel
* [[Excel Data Quality Toolkit#Misspelled Geographic Unit Names|Excel]]
* OpenRefine
* [[OpenRefine Data Quality Toolkit#Misspelled Geographic Unit Names|OpenRefine]]
* Specify
* [[Specify Data Quality Toolkit#Misspelled Geographic Unit Names|Specify]]
* Symbiota
* [[Symbiota Data Quality Toolkit#Misspelled Geographic Unit Names|Symbiota]]
* TaxonWorks
* [[TaxonWorks Data Quality Toolkit#Misspelled Geographic Unit Names|TaxonWorks]]


== Taxonomy ==
== Taxonomy ==
Line 223: Line 223:


'''Solutions:'''
'''Solutions:'''
* Arctos
* [[Arctos Data Quality Toolkit#Misspelled or Invalid Taxonomic Names|Arctos]]
* Excel
* [[Excel Data Quality Toolkit#Misspelled or Invalid Taxonomic Names|Excel]]
* OpenRefine
* [[OpenRefine Data Quality Toolkit#Misspelled or Invalid Taxonomic Names|OpenRefine]]
* Specify
* [[Specify Data Quality Toolkit#Misspelled or Invalid Taxonomic Names|Specify]]
* Symbiota
* [[Symbiota Data Quality Toolkit#Misspelled or Invalid Taxonomic Names|Symbiota]]
* TaxonWorks
* [[TaxonWorks Data Quality Toolkit#Misspelled or Invalid Taxonomic Names|TaxonWorks]]


=== Unknown Higher Taxonomy ===
=== Unknown Higher Taxonomy ===
Line 234: Line 234:


'''Solutions:'''
'''Solutions:'''
* Arctos
* [[Arctos Data Quality Toolkit#Unknown Higher Taxonomy|Arctos]]
* Excel
* [[Excel Data Quality Toolkit#Unknown Higher Taxonomy|Excel]]
* OpenRefine
* [[OpenRefine Data Quality Toolkit#Unknown Higher Taxonomy|OpenRefine]]
* Specify
* [[Specify Data Quality Toolkit#Unknown Higher Taxonomy|Specify]]
* Symbiota
* [[Symbiota Data Quality Toolkit#Unknown Higher Taxonomy|Symbiota]]
* TaxonWorks
* [[TaxonWorks Data Quality Toolkit#Unknown Higher Taxonomy|TaxonWorks]]


== Other Issues ==
== Other Issues ==
245

edits