16
edits
Excel Data Quality Toolkit: Difference between revisions
Jump to navigation
Jump to search
→Missing Latitudes/Longitudes
| Line 128: | Line 128: | ||
# At the bottom of the pop-up window, deselect "Select All", scroll down, and then only check 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 "Select All", scroll down, and then only check the "Blanks" box (you may need to scroll down in the pop-up window to locate it). | ||
# 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. | ||
To find missing longitude values: | To find missing longitude values: | ||
| Line 137: | Line 136: | ||
# At the bottom of the pop-up window, deselect "Select All", scroll down, and then only check 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 "Select All", scroll down, and then only check the "Blanks" box (you may need to scroll down in the pop-up window to locate it). | ||
# 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. | ||
=== Misspelled Geographic Unit Names === | === Misspelled Geographic Unit Names === | ||