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).
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
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.
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
- Depth
- Core Loss
- RQD
- Fractures
- Joint Set Analysis
- Geotechnical Weathering Intensity
- Joint Roughness Coefficient
- Dominant Colour
- Weighted Joint Density
- Fracture Orientation
- Geological Strength Index Proxy
- Discing Analysis
- Unique Classification
- Unique Segmentation
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