What data can be exported from Datarock Core?

💡If you’d like to learn how to export data from Datarock Core, click here.

A) Project Data

The Project Data category is the first option you’ll see when opening the Downloads dropdown. It contains two available outputs:

Uploaded Metadata
Processing Overview

1. Uploaded Metadata

This new valuable output provides a comprehensive snapshot of which holes in your project have metadata uploaded, the type of metadata, and the date of the latest upload, all in a single file.

It includes:
- - Hole identifiers (hole_id).
  - Depth intervals (depth_from/depth_to, in metres or feet).
  - Number of images.
  - Timestamps for the last update.
If metadata has been uploaded, the file will also:
- - Provide headers for general metadata types (e.g. depth, core loss, collar, survey).
  - Include headers for product-specific metadata (e.g., rqd_intervals, fractures_intervals, jsa_intervals, etc.).
  - Show the most recent upload timestamp under each metadata type.

2. Processing Overview

It includes:
- - Hole identifiers (hole_id).
  - Depth intervals (depth_from/depth_to).
  - Number of images.
  - Last updated information.
If processing has been run for a given product:
- - Provides headers for each product that has been executed (e.g. depth_registration_succeeded, rqd_succeeded, fractures_succeeded)
  - Shows the date/timestamp of the most recent successful processing under each product header.

B) Analytics Ready Data & Images

The Analytics Ready Data & Images category is the second group you’ll see in the Downloads dropdown. It offers up to six possible outputs, although only two are typically enabled:

Image data
Depth registration

1. Image data

This data is closely linked to Data Manager. It provides a detailed snapshot of each hole's uploaded imagery and related metadata. One csv file is generated per hole.

Each file includes:
- - Image name (image_name).
  - Hole identifier (hole_id).
  - Box intervals (box_from/box_to).
  - Depth intervals (depth_from/depth_to).
  - Errors in Data Manager.
  - Warnings in Data Manager.
  - Timestamp of last update.
  - Who did the last edit.
  - Project unique identifier (internal identifier).
  - Image unique identifier (internal identifier).
  - Pipeline Version (internal identifier).

💡To learn more about how to export, edit and import this file, click here.

2. Depth registration

The aim of our depth registration process is to assign each pixel within rock material with an accurate depth position in the drill hole.

At a high level, the depth registration process aims to interpolate depth between known points such as image depths, core blocks, depth markers, taking into account several factors including core loss, compaction, and measurement of detected rock within the tray.

💡To learn more about Depth Registration, click here.

This output will generate three csv files per hole or selected group of holes: Rows, Intervals and Depth Shifts. These files are typically only used for reviewing depth registration in detail by the Datarock team, but we provide them with the aim of full transparancy:

Rows
- - This output shows, for each box row, the amount of coherent and incoherent rock detected, along with the portions identified as core block, empty tray, or undetected.
  - Each file includes:
    - - Hole identifier (hole_id).
      - Depth intervals (depth_from/depth_to).
      - Box intervals (box_from/box_to).
      - Row File Name (internal identifier).
      - Coherent Rock Fraction.
      - Incoherent Rock Fraction.
      - Core Block Fraction.
      - Empty Tray Fraction.
      - Undetected Region Fraction.
      - Timestamp (internal identifier).
      - Pipeline Version (internal identifier).

Intervals
- - Similar format to the rows csv, however this provides information on intervals between known depth points, that is, between image depths or detected depth (where it has locked onto a written depth).
  - Each file includes:
    - - Hole identifier (hole_id).
      - Depth intervals (depth_from/depth_to).

- - - - Id (internal identifier).
      - Length in meters.
      - Fraction to metres factor.
      - Fraction to metres factor median difference.
      - Compaction.
      - Original Compaction.
      - Box numbers.
      - Row count.
      - Coherent Rock Fraction.
      - Incoherent Rock Fraction.
      - Core Block Fraction.
      - Empty Tray Fraction.
      - Undetected Region Fraction.
      - Core Loss Length.
Depth Shifts
- - This output shows, for each identified written depth in the image, its exact location, the provided depth, and the estimated depth. Based on this information, it also indicates whether the point was shifted (and by how much), and whether it was ultimately used in the Depth Registration process or not.
  - Each file includes:
    - - Hole identifier (hole_id).
      - Depth intervals (depth_from/depth_to).
      - File Name (internal identifier).
      - Row X
      - Row Y
      - Provided depth in meters (or feet?).
      - Estimated depth (or feet?).
      - Shift in meters (or feet?).
      - Source (internal identifier).
      - Usable for Depth Registration.
      - Timestamp (internal identifier).

C) Product Data

The Product data is the last group in the Downloads dropdown. It contains a variable amount of options, depending on the number of products enabled for your subscription:

1. RQD

💡To learn more about RQD outputs, click here.

2. Fracture

💡To learn more about Fracture outputs, click here.

3. Joint Set Analysis

💡To learn more about Joint Set Analysis data, click here.

4. Geotechnical Weathering Intensity

💡To learn more about Geotechnical Weathering Intensity data, click here.

5. Geological Strength Index (Proxy)

💡To learn more about Geological Strength Index (Proxy) outputs, click here.

6. Fracture Orientation

💡To learn more about Fracture Orientation outputs, click here.

7. Joint Roughness Coefficient (Proxy)

💡To learn more about Joint Roughness Coefficient (Proxy) outputs, click here.