Drill Models
Geodb.io provides a comprehensive suite of models for managing drillhole data, structured to reflect standard exploration workflows. These models—Drill Collar, Drill Survey, Drill Samples, Drill Lithology, Drill Alteration, Drill Structure, and Drill Photos—are designed as unique tables, each linked to a Drill Collar entry, ensuring all data ties back to a specific drillhole. This setup supports both online and offline logging, with seamless integration into the web application and QGIS.
Geodb.io provides a comprehensive suite of models for managing drillhole data, structured to reflect standard exploration workflows. These models—Drill Collar, Drill Survey, Drill Samples, Drill Lithology, Drill Alteration, Drill Structure, and Drill Photos—are designed as unique tables, each linked to a Drill Collar entry, ensuring all data ties back to a specific drillhole. This setup supports both online and offline logging, with seamless integration into the web application and QGIS.
Drill Model Overview
- Drill Collar: The foundational table for every drillhole, storing key details like location, depth, and status. Every entry in other drill models must reference a Drill Collar.
- Drill Survey: Captures survey data (e.g., azimuth, dip) for each drillhole, linked to its Drill Collar.
- Drill Samples: Records sample data collected from the drillhole, tied to the Drill Collar.
- Drill Lithology: Logs lithological observations, associated with a Drill Collar.
- Drill Alteration: Tracks alteration zones, linked to the Drill Collar.
- Drill Structure: Documents structural features, tied to the Drill Collar.
- Drill Photos: Stores photos related to the drillhole, each referencing its Drill Collar.
Every entry across these tables is explicitly linked to a Drill Collar, maintaining a clear and organized relationship between all drillhole data.
Bulk Import Notes
When bulk importing data into either Drill Alteration or Drill Lithology the importer first checks if an alteration or lithology instance has been selected from the dropdown. If so, it will save it and ignore a column that has been selected as 'alteration' or 'lithology' respectively. If no dropdown has been selected and there is column that has been selected as either 'alteration' or 'lithology', if the data in column exactly matches the name of a respective Alteration or Lithology instance of the project
they will be linked automatically. This operation is performed on a row-by-row basis. If the first row has the dropdown selected, but the second does not, the importer will save the alteration or lithology from the dropdown from the row, and will try to save the alteration or lithology from the column with that header in the second row.
Bulk Import Notes
When bulk importing data into either Drill Alteration or Drill Lithology the importer first checks if an alteration or lithology instance has been selected from the dropdown. If so, it will save it and ignore a column that has been selected as 'alteration' or 'lithology' respectively. If no dropdown has been selected and there is column that has been selected as either 'alteration' or 'lithology', if the data in column exactly matches the name of a respective Alteration or Lithology instance of the project
they will be linked automatically. This operation is performed on a row-by-row basis. If the first row has the dropdown selected, but the second does not, the importer will save the alteration or lithology from the dropdown from the row, and will try to save the alteration or lithology from the column with that header in the second row.
Logging Functionality
Geodb.io supports efficient logging in both online and offline environments:
Geodb.io supports efficient logging in both online and offline environments:
- Online Logging: Use the web application when connected to the internet to input data directly into the drill models.
- Offline Logging: Leverage the Geodb.io QGIS plugin as a logging tool when internet access is unavailable, syncing data once reconnected.
- Streamlined Input: During logging, the active drillhole (Drill Collar) and current depth are pre-filled for convenience. For example, the “depth to” from the previous entry automatically populates the “depth from” of a new entry, minimizing manual input and reducing errors.
Drill Collar: The Unified View
The Drill Collar table offers a unique, comprehensive view for each drillhole:
- When viewing an individual Drill Collar entry in the web application, all related data—Drill Photos, Samples, Surveys, Lithologies, Alterations, and Structures—is displayed on the same page.
- This consolidated view simplifies analysis by presenting the entire dataset for a drillhole in one place, eliminating the need to navigate between tables manually.
Why It Matters
The Drill Models are built to accommodate real-world exploration needs, offering a logical structure, flexible logging options, and an intuitive interface. Whether you’re logging data in the field with QGIS or reviewing a complete drillhole profile online, Geodb.io ensures your drill data is cohesive, accessible, and easy to manage.