16
edits
Excel Data Quality Toolkit: Difference between revisions
→Missing Geodetic Datum
| Line 100: | Line 100: | ||
=== Missing Geodetic Datum === | === Missing Geodetic Datum === | ||
'''Problem:''' Geodetic datum is a key piece of a properly georeferenced specimen, but is usually left blank. Although it is commonly assumed to be in ‘WGS84’, this should be added and noted as such. | '''Problem:''' Geodetic datum (dwc:[https://dwc.tdwg.org/terms/#dwc:geodeticDatum geodeticDatum]) is a key piece of a properly georeferenced specimen, but is usually left blank. Although it is commonly assumed to be in ‘WGS84’, this should be added and noted as such. | ||
'''Solution:''' | '''Solution:''' | ||
Records with missing Geodetic Datum values can be identified using a filter. | |||
# Open your dataset in Excel and highlight Row 1. | |||
# From the Data toolbar, click "Filter". | |||
# Navigate to the column containing your geodetic datum values 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 "Select All" and then only check the "Blanks" box. | |||
# Proceed to add geodetic datum values as appropriate where missing. | |||
=== Missing Latitudes/Longitudes === | === Missing Latitudes/Longitudes === | ||