Geology
You can import geology logs to map it to other data along boreholes.
Supported Data Types
- In other data sources: stratigraphy, lithology, geotechnical domain, alteration columns…
- Files imported must be in .csv format (auto-import with customized features OR manual csv import)
- Where there is no data available for the remaining columns - leave blank.
- Columns in the .csv file must be in the order specified in the sections below.
- Columns in the specified format, according to this colour code:
- Number column (green)
- Text column (blue)
- Specific Text column (category) - See Table below (orange)
- Date column: yyyy-MM-dd (red)
- Point columns : X Y Z (3 number columns) (pink)
Key Features
Automatic updates from on-site databases or manual csv import
-
Automatic import: Please refer to the template to know which columns are needed. Email us at support for site-specific setup.
-
Here is a video on how to manually import it:
Grouping lithologies options for 'geotechnical lithologies'
Add multiple 'empty rows' and copy-paste the imported lithologies you want to group by just copy-paste from Excel
You only need to add rows for lithologies you want to group.
Group your lithologies from a geotechnical perspective.
Custom-colour assignment for lithologies and geotechnical domains
Link geology logs to all other data sources (lab tests, index tests, rock mass quality) along boreholes
Here is an example to assign geology logs data to Rock Mass Quality data:
FAQ
What happens if I import the same borehole twice?
For automatic inputs, the duplicates will remain - you need to ensure that your database is clean. For manual csv import, if you try to import a borehole that already exists, the new data will overwrite the old one for the whole borehole.
Can I import mapped lithology in excavation as well?
Please reach out to us at support to discuss what data type you have and how we can import it to map it to data in excavation.