Skip to content
English
  • There are no suggestions because the search field is empty.

Uploading CSV Data

This page provides a guide on uploading tabulated data (CSVs) to the Datarock Platform, including warnings and errors that may occur during the uploading process.

CSV metadata files can be added at any point throughout your subscription. Once any data (imagery or metadata) is uploaded, that Hole ID will be created and will be displayed on the Drill Holes list.

1 - How to Upload

Step 1: Navigate to Upload page

Open your Project (yellow) and click on Upload to reveal a dropdown; select Upload CSV (red).

csv-data-1

Step 2: Create your CSV files

The yellow box indicates CSV files issued by the client with the correct naming convention for Datarock platform (if not already being automatically brought into the platform).

Step 3: Upload your CSV files

Drag 'n' drop your CSV files into the red box zone or click text box to navigate to your CSV files on your server

csv-data-2

Step 4: Upload your CSV files

Click on Upload. A 

 

2 - Data QA - Errors

Errors are highlighted in red and stop you from uploading CSV files with errors. This example shows that you can’t press the Upload button, which is greyed out.

This error is due to there being an incorrect column header for the file_id column.

To address this error, you should remove the CSV by clicking the bin icon to the right (in yellow), update the column header in the original file, and re-upload the CSV. If there are no further errors, you will be able to Upload.

csv-data-3

Common Errors

Common errors are due to the file naming convention required for Datarock Platform recognition, make sure the file is named correctly. Do not change the header rows of each file.

Datarock naming convention

Content

Common errors

HOLEID_core_loss

Core loss file

CL past EOH depth, CL doesn’t match from file to box, CL spread over multiple trays, more CL than the interval.

HOLEID_depth

Start and end depth file

Incorrect start and end depth, daughter holes may not be accurate.

HOLEID_sample

RQD sample file

Incorrect start and end depths, RQD may be incomplete for entire hole.


 

3 - Inputs per Product


Hole Depth File

File name: HoleID_depth.csv

Click here to download an example of this file, or create your own by using the following fields:

File Header 

Description 

file_id

always include * in this column

from

Start of hole (m)

to

End of hole (m)

Core Loss File

File name: HoleID_core_loss.csv

Click here to download an example of this file, or create your own by using the following fields:

File Header 

Description 

depth_from

Start depth of core loss interval (m)

depth_to

End depth of core loss interval (m)

loss

Total core loss (m)

Geotechnical and Geology Products

RQD Inputs

Sampling Intervals

User data may be uploaded to the platform via csv in the following format:

  • HOLEID_sample.csv

Click here to download an example of this file, or create your own by using the following fields:

File Header

Description 

depth_from

Start of interval

depth_to

End of interval

rqd_m

Site measured length of coherent rock pieces longer than 100mm

rqd

Sum of site measured length of coherent rock pieces longer than 100mm divided by interval length, multiplied by 100

 
Core Diameter

To calculate RQD based on core diameter, the data should be uploaded via csv in the following format:

  • HOLEID_core_diameter.csv

CSV file to contain the following headers:

File Header 

Description 

depth_from

Start of interval

depth_to

End of interval

core_diameter

The core diameter / drill bit size such as NQ, HQ, PQ etc

 

Fractures Inputs

User data may be uploaded to the platform via csv in the following format:

  • HoleID_sampling_intervals_fractures.csv

Click here to download an example of this file, or create your own by using the following fields: 

File Header

Description

depth_from

Start of interval

depth_to

End of interval

fractures

Number of natural fractures counted on site

 

Joint Set Analysis Inputs

User data may be uploaded to the platform via csv in the following format:

  • HoleID_sampling_intervals_joint_sets.csv

Click here to download an example of this file, or create your own by using the following fields: 

 

File Header

Description

depth_from

Start of interval

depth_to

End of interval

groundtruth

Joint Set Number logged on site. This is an optional field.

 

Geotechnical Weathering Intensity Inputs

User data may be uploaded to the platform via csv in the following format:

  • HoleID_sampling_intervals_weathering_intensity.csv

CSV file to contain the following headers:

File Header 

Description 

depth_from

Start of interval

depth_to

End of interval

groundtruth

Degree of weathering logged on site. This is an optional field.

 

Joint Roughness Coefficient Proxy Inputs

Not currently able to upload User Data to the platform.

Dominant Colour Inputs

Not currently able to upload User Data to the platform.

Weighted Joint Density Inputs

User data may be provided to the Datarock team via csv in the following format:

  • HoleID_sampling_intervals_WJD.csv

CSV file to contain the following headers:

 

File Header

Description

depth_from

Start of interval

depth_to

End of interval

 

Fracture Orientation Inputs

Downhole survey data must be provided in the following format format:

  • HoleID_survey.csv

CSV file to contain the following headers:

 

File Header

Description

hole_id

Hole Name

depth

The vertical distance from the surface down to the bottom of the drilled hole

azimuth

Azimuth is the horizontal orientation of the drill path, measured in degrees from true north (or grid north).

dip

Dip refers to the angle at which the drill hole deviates vertically from the horizontal plane, measured in degrees.

 

 Geological Strength Index (Proxy) Inputs

User data may be provided to the Datarock team via csv in the following format:

  • HoleID_sampling_intervals_GSI.csv

CSV file to contain the following headers:

 

File Header

Description

depth_from

Start of interval

depth_to

End of interval

Discing Analysis Inputs

User data is not required for this product.

 

Unique Classification

Sampling Intervals

User data may be uploaded to the platform via CSV in the following format for customisable intervals (assay or geology logs):

  • HOLEID_sampling_intervals_lithology.csv
  • HOLEID_sampling_intervals_alteration.csv
  • HOLEID_sampling_intervals_mineral.csv

Click here to download an example of this file for Lithology or click here to download an example of this file for Alteration, or create your own csv file by using the following fields: 

File Header

Description 

depth_from

Start of interval

depth_to

End of interval

groundtruth

Class name (i.e. lithology class, alteration class, mineral class - depending on the model)

 

Unique Segmentation

User data can not be uploaded to the Platform via CSV at the current time.

The following data is required for customisable intervals (assay or geology logs) to be sent to the Datarock Customer Success Team:

  • Hole_ID

  • Depth_From

  • Depth_To