Data Quality Toolkit 2024: Difference between revisions

Remove references to OpenRefine
(clarified the intent of what is meant by expected values for individualCount (e.g. 1, 2, 3, but not 2.3 or -2))
(Remove references to OpenRefine)
Line 19: Line 19:
* [https://handbook.arctosdb.org/documentation/catalog.html#catalog-number Arctos]
* [https://handbook.arctosdb.org/documentation/catalog.html#catalog-number Arctos]
* [[Excel Data Quality Toolkit#Duplicate Catalog Numbers|Excel]]
* [[Excel Data Quality Toolkit#Duplicate Catalog Numbers|Excel]]
* [[OpenRefine Data Quality Toolkit#Duplicate Catalog Numbers|OpenRefine]]
* [[Specify Data Quality Toolkit#Duplicate Catalog Numbers|Specify]]
* [[Specify Data Quality Toolkit#Duplicate Catalog Numbers|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#duplicate-catalog-numbers Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#duplicate-catalog-numbers Symbiota]
Line 32: Line 31:
* [[Arctos Data Quality Toolkit#Date Hasn't Happened Yet|Arctos]]
* [[Arctos Data Quality Toolkit#Date Hasn't Happened Yet|Arctos]]
* [[Excel Data Quality Toolkit#Date Hasn't Happened Yet|Excel]]
* [[Excel Data Quality Toolkit#Date Hasn't Happened Yet|Excel]]
* [[OpenRefine Data Quality Toolkit#Date Hasn't Happened Yet|OpenRefine]]
* [[Specify Data Quality Toolkit#Date Hasn't Happened Yet|Specify]]
* [[Specify Data Quality Toolkit#Date Hasn't Happened Yet|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#date-hasnt-happened-yet Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#date-hasnt-happened-yet Symbiota]
Line 44: Line 42:
* [[Arctos Data Quality Toolkit#Date is Suspiciously Old|Arctos]]
* [[Arctos Data Quality Toolkit#Date is Suspiciously Old|Arctos]]
* [[Excel Data Quality Toolkit#Date is Suspiciously Old|Excel]]
* [[Excel Data Quality Toolkit#Date is Suspiciously Old|Excel]]
* [[OpenRefine Data Quality Toolkit#Date is Suspiciously Old|OpenRefine]]
* [[Specify Data Quality Toolkit#Date is Suspiciously Old|Specify]]
* [[Specify Data Quality Toolkit#Date is Suspiciously Old|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#date-is-suspiciously-old Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#date-is-suspiciously-old Symbiota]
Line 55: Line 52:
* [[Arctos Data Quality Toolkit#Identified Date Earlier than Collected Date|Arctos]]
* [[Arctos Data Quality Toolkit#Identified Date Earlier than Collected Date|Arctos]]
* [[Excel Data Quality Toolkit#Identified Date Earlier than Collected Date|Excel]]
* [[Excel Data Quality Toolkit#Identified Date Earlier than Collected Date|Excel]]
* [[OpenRefine Data Quality Toolkit#Identified Date Earlier than Collected Date|OpenRefine]]
* [[Specify Data Quality Toolkit#Identified Date Earlier than Collected Date|Specify]]
* [[Specify Data Quality Toolkit#Identified Date Earlier than Collected Date|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#identified-date-earlier-than-collected-date Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#identified-date-earlier-than-collected-date Symbiota]
Line 66: Line 62:
* [[Arctos Data Quality Toolkit#Year, Month, and Day Values Do Not Match Date|Arctos]]
* [[Arctos Data Quality Toolkit#Year, Month, and Day Values Do Not Match Date|Arctos]]
* [[Excel Data Quality Toolkit#Year, Month, and Day Values Do Not Match Date|Excel]]
* [[Excel Data Quality Toolkit#Year, Month, and Day Values Do Not Match Date|Excel]]
* [[OpenRefine Data Quality Toolkit#Year, Month, and Day Values Do Not Match Date|OpenRefine]]
* [[Specify Data Quality Toolkit#Year, Month, and Day Values Do Not Match Date|Specify]]
* [[Specify Data Quality Toolkit#Year, Month, and Day Values Do Not Match Date|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#year-month-and-day-values-do-not-match-date Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#year-month-and-day-values-do-not-match-date Symbiota]
Line 79: Line 74:
* [[Arctos Data Quality Toolkit#Coordinates are Zero|Arctos]]
* [[Arctos Data Quality Toolkit#Coordinates are Zero|Arctos]]
* [[Excel Data Quality Toolkit#Coordinates are Zero|Excel]]
* [[Excel Data Quality Toolkit#Coordinates are Zero|Excel]]
* [[OpenRefine Data Quality Toolkit#Coordinates are Zero|OpenRefine]]
* [[Specify Data Quality Toolkit#Coordinates are Zero|Specify]]
* [[Specify Data Quality Toolkit#Coordinates are Zero|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#coordinates-are-zero Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#coordinates-are-zero Symbiota]
Line 90: Line 84:
* [[Arctos Data Quality Toolkit#Coordinates Do Not Fall Within Named Geographic Unit|Arctos]]
* [[Arctos Data Quality Toolkit#Coordinates Do Not Fall Within Named Geographic Unit|Arctos]]
* [[Excel Data Quality Toolkit#Coordinates Do Not Fall Within Named Geographic Unit|Excel]]
* [[Excel Data Quality Toolkit#Coordinates Do Not Fall Within Named Geographic Unit|Excel]]
* [[OpenRefine Data Quality Toolkit#Coordinates Do Not Fall Within Named Geographic Unit|OpenRefine]]
* [[Specify Data Quality Toolkit#Coordinates Do Not Fall Within Named Geographic Unit|Specify]]
* [[Specify Data Quality Toolkit#Coordinates Do Not Fall Within Named Geographic Unit|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#coordinates-do-not-fall-within-named-geographic-unit Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#coordinates-do-not-fall-within-named-geographic-unit Symbiota]
Line 101: Line 94:
* [[Arctos Data Quality Toolkit#Georeference Metadata with no Associated Georeference|Arctos]]
* [[Arctos Data Quality Toolkit#Georeference Metadata with no Associated Georeference|Arctos]]
* [[Excel Data Quality Toolkit#Georeference Metadata with no Associated Georeference|Excel]]
* [[Excel Data Quality Toolkit#Georeference Metadata with no Associated Georeference|Excel]]
* [[OpenRefine Data Quality Toolkit#Georeference Metadata with no Associated Georeference|OpenRefine]]
* [[Specify Data Quality Toolkit#Georeference Metadata with no Associated Georeference|Specify]]
* [[Specify Data Quality Toolkit#Georeference Metadata with no Associated Georeference|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#georeference-metadata-with-no-associated-georeference Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#georeference-metadata-with-no-associated-georeference Symbiota]
Line 112: Line 104:
* [[Arctos Data Quality Toolkit#Elevation is Unlikely|Arctos]]
* [[Arctos Data Quality Toolkit#Elevation is Unlikely|Arctos]]
* [[Excel Data Quality Toolkit#Elevation is Unlikely|Excel]]
* [[Excel Data Quality Toolkit#Elevation is Unlikely|Excel]]
* [[OpenRefine Data Quality Toolkit#Elevation is Unlikely|OpenRefine]]
* [[Specify Data Quality Toolkit#Elevation is Unlikely|Specify]]
* [[Specify Data Quality Toolkit#Elevation is Unlikely|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#elevation-is-unlikely Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#elevation-is-unlikely Symbiota]
Line 123: Line 114:
* [[Arctos Data Quality Toolkit#Improperly Negated Latitudes/Longitudes|Arctos]]
* [[Arctos Data Quality Toolkit#Improperly Negated Latitudes/Longitudes|Arctos]]
* [[Excel Data Quality Toolkit#Improperly Negated Latitudes/Longitudes|Excel]]
* [[Excel Data Quality Toolkit#Improperly Negated Latitudes/Longitudes|Excel]]
* [[OpenRefine Data Quality Toolkit#Improperly Negated Latitudes/Longitudes|OpenRefine]]
* [[Specify Data Quality Toolkit#Improperly Negated Latitudes/Longitudes|Specify]]
* [[Specify Data Quality Toolkit#Improperly Negated Latitudes/Longitudes|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#improperly-negated-latitudeslongitudes Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#improperly-negated-latitudeslongitudes Symbiota]
Line 134: Line 124:
* [[Arctos Data Quality Toolkit#Invalid Coordinates|Arctos]]
* [[Arctos Data Quality Toolkit#Invalid Coordinates|Arctos]]
* [[Excel Data Quality Toolkit#Invalid Coordinates|Excel]]
* [[Excel Data Quality Toolkit#Invalid Coordinates|Excel]]
* [[OpenRefine Data Quality Toolkit#Invalid Coordinates|OpenRefine]]
* [[Specify Data Quality Toolkit#Invalid Coordinates|Specify]]
* [[Specify Data Quality Toolkit#Invalid Coordinates|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#invalid-coordinates Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#invalid-coordinates Symbiota]
Line 145: Line 134:
* [[Arctos Data Quality Toolkit#Lower Geography Values are Provided, but No Higher Geography|Arctos]]
* [[Arctos Data Quality Toolkit#Lower Geography Values are Provided, but No Higher Geography|Arctos]]
* [[Excel Data Quality Toolkit#Lower Geography Values are Provided, but No Higher Geography|Excel]]
* [[Excel Data Quality Toolkit#Lower Geography Values are Provided, but No Higher Geography|Excel]]
* [[OpenRefine Data Quality Toolkit#Lower Geography Values are Provided, but No Higher Geography|OpenRefine]]
* [[Specify Data Quality Toolkit#Lower Geography Values are Provided, but No Higher Geography|Specify]]
* [[Specify Data Quality Toolkit#Lower Geography Values are Provided, but No Higher Geography|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#lower-geography-values-are-provided-but-no-higher-geography Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#lower-geography-values-are-provided-but-no-higher-geography Symbiota]
Line 156: Line 144:
* [[Arctos Data Quality Toolkit#Minimum and Maximum Elevation Values Mismatched|Arctos]]
* [[Arctos Data Quality Toolkit#Minimum and Maximum Elevation Values Mismatched|Arctos]]
* [[Excel Data Quality Toolkit#Minimum and Maximum Elevation Values Mismatched|Excel]]
* [[Excel Data Quality Toolkit#Minimum and Maximum Elevation Values Mismatched|Excel]]
* [[OpenRefine Data Quality Toolkit#Minimum and Maximum Elevation Values Mismatched|OpenRefine]]
* [[Specify Data Quality Toolkit#Minimum and Maximum Elevation Values Mismatched|Specify]]
* [[Specify Data Quality Toolkit#Minimum and Maximum Elevation Values Mismatched|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#minimum-and-maximum-elevation-values-mismatched Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#minimum-and-maximum-elevation-values-mismatched Symbiota]
Line 167: Line 154:
* [[Arctos Data Quality Toolkit#Mismatched Country and CountryCode Values|Arctos]]
* [[Arctos Data Quality Toolkit#Mismatched Country and CountryCode Values|Arctos]]
* [[Excel Data Quality Toolkit#Mismatched Country and CountryCode Values|Excel]]
* [[Excel Data Quality Toolkit#Mismatched Country and CountryCode Values|Excel]]
* [[OpenRefine Data Quality Toolkit#Mismatched Country and CountryCode Values|OpenRefine]]
* [[Specify Data Quality Toolkit#Mismatched Country and CountryCode Values|Specify]]
* [[Specify Data Quality Toolkit#Mismatched Country and CountryCode Values|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#mismatched-country-and-countrycode-values Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#mismatched-country-and-countrycode-values Symbiota]
Line 178: Line 164:
* [[Arctos Data Quality Toolkit#Mismatched Geographic Terms|Arctos]]
* [[Arctos Data Quality Toolkit#Mismatched Geographic Terms|Arctos]]
* [[Excel Data Quality Toolkit#Mismatched Geographic Terms|Excel]]
* [[Excel Data Quality Toolkit#Mismatched Geographic Terms|Excel]]
* [[OpenRefine Data Quality Toolkit#Mismatched Geographic Terms|OpenRefine]]
* [[Specify Data Quality Toolkit#Mismatched Geographic Terms|Specify]]
* [[Specify Data Quality Toolkit#Mismatched Geographic Terms|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#mismatched-geographic-terms Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#mismatched-geographic-terms Symbiota]
Line 189: Line 174:
* [[Arctos Data Quality Toolkit#Missing Geodetic Datum|Arctos]]
* [[Arctos Data Quality Toolkit#Missing Geodetic Datum|Arctos]]
* [[Excel Data Quality Toolkit#Missing Geodetic Datum|Excel]]
* [[Excel Data Quality Toolkit#Missing Geodetic Datum|Excel]]
* [[OpenRefine Data Quality Toolkit#Missing Geodetic Datum|OpenRefine]]
* [[Specify Data Quality Toolkit#Missing Geodetic Datum|Specify]]
* [[Specify Data Quality Toolkit#Missing Geodetic Datum|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#missing-geodetic-datum Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#missing-geodetic-datum Symbiota]
Line 200: Line 184:
* [[Arctos Data Quality Toolkit#Missing Latitudes/Longitudes|Arctos]]
* [[Arctos Data Quality Toolkit#Missing Latitudes/Longitudes|Arctos]]
* [[Excel Data Quality Toolkit#Missing Latitudes/Longitudes|Excel]]
* [[Excel Data Quality Toolkit#Missing Latitudes/Longitudes|Excel]]
* [[OpenRefine Data Quality Toolkit#Missing Latitudes/Longitudes|OpenRefine]]
* [[Specify Data Quality Toolkit#Missing Latitudes/Longitudes|Specify]]
* [[Specify Data Quality Toolkit#Missing Latitudes/Longitudes|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#missing-latitudeslongitudes Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#missing-latitudeslongitudes Symbiota]
Line 211: Line 194:
* [[Arctos Data Quality Toolkit#Misspelled Geographic Unit Names|Arctos]]
* [[Arctos Data Quality Toolkit#Misspelled Geographic Unit Names|Arctos]]
* [[Excel Data Quality Toolkit#Misspelled Geographic Unit Names|Excel]]
* [[Excel Data Quality Toolkit#Misspelled Geographic Unit Names|Excel]]
* [[OpenRefine Data Quality Toolkit#Misspelled Geographic Unit Names|OpenRefine]]
* [[Specify Data Quality Toolkit#Misspelled Geographic Unit Names|Specify]]
* [[Specify Data Quality Toolkit#Misspelled Geographic Unit Names|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#misspelled-geographic-unit-names Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#misspelled-geographic-unit-names Symbiota]
Line 224: Line 206:
* [[Arctos Data Quality Toolkit#Misspelled or Invalid Taxonomic Names|Arctos]]
* [[Arctos Data Quality Toolkit#Misspelled or Invalid Taxonomic Names|Arctos]]
* [[Excel Data Quality Toolkit#Misspelled or Invalid Taxonomic Names|Excel]]
* [[Excel Data Quality Toolkit#Misspelled or Invalid Taxonomic Names|Excel]]
* [[OpenRefine Data Quality Toolkit#Misspelled or Invalid Taxonomic Names|OpenRefine]]
* [[Specify Data Quality Toolkit#Misspelled or Invalid Taxonomic Names|Specify]]
* [[Specify Data Quality Toolkit#Misspelled or Invalid Taxonomic Names|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#misspelled-or-invalid-taxonomic-names Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#misspelled-or-invalid-taxonomic-names Symbiota]
Line 235: Line 216:
* [[Arctos Data Quality Toolkit#Unknown Higher Taxonomy|Arctos]]
* [[Arctos Data Quality Toolkit#Unknown Higher Taxonomy|Arctos]]
* [[Excel Data Quality Toolkit#Unknown Higher Taxonomy|Excel]]
* [[Excel Data Quality Toolkit#Unknown Higher Taxonomy|Excel]]
* [[OpenRefine Data Quality Toolkit#Unknown Higher Taxonomy|OpenRefine]]
* [[Specify Data Quality Toolkit#Unknown Higher Taxonomy|Specify]]
* [[Specify Data Quality Toolkit#Unknown Higher Taxonomy|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#unknown-higher-taxonomy Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#unknown-higher-taxonomy Symbiota]
Line 248: Line 228:
* [[Arctos Data Quality Toolkit#Incorrect Character Encodings|Arctos]]
* [[Arctos Data Quality Toolkit#Incorrect Character Encodings|Arctos]]
* [[Excel Data Quality Toolkit#Incorrect Character Encodings|Excel]]
* [[Excel Data Quality Toolkit#Incorrect Character Encodings|Excel]]
* [[OpenRefine Data Quality Toolkit#Incorrect Character Encodings|OpenRefine]]
* [[Specify Data Quality Toolkit#Incorrect Character Encodings|Specify]]
* [[Specify Data Quality Toolkit#Incorrect Character Encodings|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#incorrect-character-encodings Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#incorrect-character-encodings Symbiota]
Line 259: Line 238:
* [[Arctos Data Quality Toolkit#Incorrect Line Endings|Arctos]]
* [[Arctos Data Quality Toolkit#Incorrect Line Endings|Arctos]]
* [[Excel Data Quality Toolkit#Incorrect Line Endings|Excel]]
* [[Excel Data Quality Toolkit#Incorrect Line Endings|Excel]]
* [[OpenRefine Data Quality Toolkit#Incorrect Line Endings|OpenRefine]]
* [[Specify Data Quality Toolkit#Incorrect Line Endings|Specify]]
* [[Specify Data Quality Toolkit#Incorrect Line Endings|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#incorrect-line-endings Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#incorrect-line-endings Symbiota]
Line 270: Line 248:
* [[Arctos Data Quality Toolkit#Invalid Individual Count|Arctos]]
* [[Arctos Data Quality Toolkit#Invalid Individual Count|Arctos]]
* [[Excel Data Quality Toolkit#Invalid Individual Count|Excel]]
* [[Excel Data Quality Toolkit#Invalid Individual Count|Excel]]
* [[OpenRefine Data Quality Toolkit#Invalid Individual Count|OpenRefine]]
* [[Specify Data Quality Toolkit#Invalid Individual Count|Specify]]
* [[Specify Data Quality Toolkit#Invalid Individual Count|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#invalid-individual-count Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#invalid-individual-count Symbiota]
Line 285: Line 262:
* [[Arctos Data Quality Toolkit#Non-standardized BasisOfRecord Values|Arctos]]
* [[Arctos Data Quality Toolkit#Non-standardized BasisOfRecord Values|Arctos]]
* [[Excel Data Quality Toolkit#Non-standardized BasisOfRecord Values|Excel]]
* [[Excel Data Quality Toolkit#Non-standardized BasisOfRecord Values|Excel]]
* [[OpenRefine Data Quality Toolkit#Non-standardized BasisOfRecord Values|OpenRefine]]
* [[Specify Data Quality Toolkit#Non-standardized BasisOfRecord Values|Specify]]
* [[Specify Data Quality Toolkit#Non-standardized BasisOfRecord Values|Specify]]
* [https://biokic.github.io/symbiota-docs/editor/quality/#non-standardized-basisofrecord-values Symbiota]
* [https://biokic.github.io/symbiota-docs/editor/quality/#non-standardized-basisofrecord-values Symbiota]
* [[TaxonWorks Data Quality Toolkit#Non-standardized BasisOfRecord Values|TaxonWorks]]
* [[TaxonWorks Data Quality Toolkit#Non-standardized BasisOfRecord Values|TaxonWorks]]
255

edits