16
edits
Excel Data Quality Toolkit: Difference between revisions
Jump to navigation
Jump to search
→Missing Latitudes/Longitudes
| Line 129: | Line 129: | ||
# Navigate to the column containing your longitude values (e.g. dwc:[https://dwc.tdwg.org/terms/#dwc:decimallongitude decimalLongitude]) and select the arrow icon next to the column header indicating that this column can now be filtered on. | # Navigate to the column containing your longitude values (e.g. dwc:[https://dwc.tdwg.org/terms/#dwc:decimallongitude decimalLongitude]) and select the arrow icon next to the column header indicating that this column can now be filtered on. | ||
# At the bottom of the pop-up window, deselect the "Blanks" box (you may need to scroll down in the pop-up window to locate it). | # At the bottom of the pop-up window, deselect the "Blanks" box (you may need to scroll down in the pop-up window to locate it). | ||
# The remaining visible rows contain records with missing latitude values | # The remaining visible rows contain records with missing latitude values. | ||
To find missing longitude values: | To find missing longitude values: | ||
| Line 138: | Line 138: | ||
# Navigate to the column containing your latitude values (e.g. dwc:[https://dwc.tdwg.org/terms/#dwc:decimallatitude decimalLatitude]) and select the arrow icon next to the column header indicating that this column can now be filtered on. | # Navigate to the column containing your latitude values (e.g. dwc:[https://dwc.tdwg.org/terms/#dwc:decimallatitude decimalLatitude]) and select the arrow icon next to the column header indicating that this column can now be filtered on. | ||
# At the bottom of the pop-up window, deselect the "Blanks" box (you may need to scroll down in the pop-up window to locate it). | # At the bottom of the pop-up window, deselect the "Blanks" box (you may need to scroll down in the pop-up window to locate it). | ||
# The remaining visible rows contain records with missing longitude values | # The remaining visible rows contain records with missing longitude values. | ||
=== Misspelled Geographic Unit Names === | === Misspelled Geographic Unit Names === | ||