16
edits
Excel Data Quality Toolkit: Difference between revisions
→Elevation is Unlikely
| Line 81: | Line 81: | ||
'''Solution:''' | '''Solution:''' | ||
Records with unlikely elevation 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 elevation values (e.g. dwc:[https://dwc.tdwg.org/terms/#dwc:minimumElevationInMeters minimumElevationInMeters], dwc:[https://dwc.tdwg.org/terms/#dwc:maximumElevationInMeters maximumElevationInMeters]) 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, change the filter criterion "Choose One" to "Between", set "Less Than" = "0" and "Greater Than" = "17000", and select "Apply Filter". | |||
Similar filters can be used to locate unlikely depth values (e.g. dwc:[https://dwc.tdwg.org/terms/#dwc:minimumDepthInMeters minimumDepthInMeters], dwc:[https://dwc.tdwg.org/terms/#dwc:maximumDepthInMeters maximumDepthInMeters]). | |||
=== Improperly Negated Latitudes/Longitudes === | === Improperly Negated Latitudes/Longitudes === | ||