Correcting Data Errors
Leapfrog Geo automatically identifies and flags common data errors when data tables are imported. There are three ways Leapfrog Geo marks tables that contain conflicts or errors:
- Tables marked with a red X () contain errors that mean data cannot be used for processing. These errors can be corrected by opening the Database Errors window, which is described in Correcting Errors in Leapfrog Geo.
- Numeric data columns marked with a red X () contain non-numeric values, which means that the rules that are used to handle non-numeric and negative values need to be reviewed. If a table has data that contain non-numeric and negative values, the affected rows cannot be used for further processing until the rules are verified, which is described in Special Values.
- Tables marked with a yellow exclamation mark () contain warnings. Affected rows can be used for further processing, but the information in the warning can indicate that the data requires further attention. For example, if a warning indicates there is data missing for a drillhole defined in the collar table, it may be that a drillhole has been duplicated or that not all required data files have been loaded. Warnings are listed along with table errors in the Database Errors window.
Until errors are corrected, the rows that contain those errors are excluded for all processing that uses the table, including viewing in the scene. For example, if the ID for a collar position contains an invalid coordinate, that collar will not be displayed in the scene as its location is not known. Likewise, any processing will ignore data associated with this drillhole.
It is worth correcting errors as soon as possible, as correcting them later can result in significant recomputation time.
When a table contains errors and warnings, only the errors will be apparent in the project tree view. However, all errors and warnings relevant to a particular table will be displayed in the Database Errors window.
There are two approaches to correcting errors in data:
- Correct the data in the primary source. Export the errors as described in Exporting Data Errors. Then, when the errors have been corrected, reload the drillhole data as described in Reloading Drillhole Data.
- Correct the data in Leapfrog Geo. If you need a record of corrected errors, first export the errors as described in Exporting Data Errors. This must be done first, as once errors have been corrected in Leapfrog Geo, they cannot be exported, as they no longer exist. Then correct errors as described in Correcting Errors in Leapfrog Geo.