Validate Imported Drillhole Data

1. Import drillhole data. See:
   • Import Drillhole Data from an Access Database
   • Import Drillhole Data from Tables
   • Import Drillhole Data from ODBC

   The Project Validation window displays.

2. Select the Validation Options from:
   • Collar - Duplicate Collar Locations
   • Survey - No associated Collar
   • Survey - Dip Sign Discrepancy
   • Survey - Large Dip Curvature Change
   • Survey - Large Azimuth Curvature Changes
   • Downhole - No Associated Collar
   • Downhole - Sample Interval Gaps
3. If Validation Options includes Survey - Large Dip Curvature Change, enter the maximum Dip.
4. If Validation Options includes Survey - Large Azimuth Curvature Changes, enter the maximum Azimuth.
5. If Validation Options includes Downhole - Sample Interval Gaps, enter the maximum number of Gaps.
6. Click Next.

   The Project Validation window for Collar displays.

7. Correct the errors manually or use the Quickfix tool as required.

   Error Message	Description	Quickfix
   Collar null location	Mandatory. Easting, Northing and Depth fields cannot be null or equal to zero.	Deletes the hole.
   Duplicate HoleID	Mandatory.	Keeps only the first hole.
   Dip and Azimuth fields cannot be null	Mandatory.	No quick fix available.
   Duplicate Collar Location	Optional.	No quick fix available.

8. Click Refresh.
9. Click Next.

   The Project Validation window for Survey displays.

10. Correct the errors manually or use the Quickfix tool as required.

    Error Message	Description	Quickfix
    Duplicate depth values	A downhole survey with the same HoleID and survey depth.	Keeps only the first survey point.
    Dip out of range	The dip is not between 90 and -90 degrees; for example, 120 degrees dip.	Deletes the survey point.
    Azimuth out of range	The azimuth is not between 0 and 360 degrees .	Deletes the survey point.
    Survey EOH greater than Collar EOH	A drillhole in the survey table has an EOH that is larger than a drillhole in the collar table with the same HoleID.	Changes the collar depth to match the deepest survey depth.
    No Associated Collar	The survey table has a HoleID that is not in the collar table.	No quick fix available.
    Dip Sign Discrepancy	The survey table has both positive and negative values for dip.	Corrects the dip value sign.
    Large Dip Curvature Changes	The dip changes more than a certain; for example, 5 degrees over an interval of 50m.	No quick fix available.
    Large Azimuth Curvature Changes	The azimuth changes more than a certain.	No quick fix available.

11. Click Refresh.
12. Click Next.

    The Project Validation window for Downhole displays.

13. Correct the errors manually or use the Quickfix tool as required.

    Error Message	Description	Quickfix
    Duplicate sample number	More than one samples have the same sample number in the downhole table.	No quick fix available.
    Overlap sample interval	The downhole table has an interval overlap between separate intervals; for example, quartzite is from depth 20m to 30m and granite is from depth 25m to 40m.	Keeps only the first row.
    Sample beyond Collar EOH	A sample in the downhole table is beyond the EOH.	Changes the collar depth to match the deepest downhole depth.
    No Associated Collar	The downhole table has a sample without a corresponding collar.	No quick fix available.
    Sample Interval Gaps	Missing data in the sample intervals for the downhole table.	No quick fix available.

14. Click Refresh.
15. Click Finish.

    Note: All validations are stored in a validation report located in <ESRI Project Folder>\Discover_Drilling\Drilling_Validation_Errors.csv.