EDM - The Online Exploration Data Management System
The Exploration Data Management online service is focused on streamlining, organizing and presenting data for a variety of geological environments. The Exploration Data Management, EDM, online service is designed for mineral exploration, development, and mining projects. As such the EDM also supports data management for other industries utilizing similar surface, drilling, and analytical data collection processes.
There is no software installation required to use the service, only your browser. The EDM provides maximum flexibility and utility, enabling surface and drill data to be entered on the fly from anywhere in the world, processed, and then presented in attractive, customizable user reports for all stakeholders.
The EDM has been used to manage active drill programs around the world for nearly a decade and the results are impressive. In one installation alone, the EDM resulted in a 75% reduction in manpower requirements. It is an extremely cost effective solution managing mining industry exploration data. The EDM allows real-time access to geologic and analytical data from anywhere in the world, which ensures rapid, informed decision making.
Would you like to know more? Please look through our website, and contact us at info@edmsolutions.biz .
What is the EDM?
The development of the EDM began in the early 2000’s as a SQL database to answer the need to manage active drill programs with multiple projects and 30 plus drill rigs. The initial application resulted in a 75% reduction in manpower requirements, while providing real time access to geologic and analytical data. By the late 2000’s, based on end users feedback the EDM was migrated to a web based user interface and the core functionality was expanded.
In 2010, the application was further expanded to support multiple customers utilizing a cloud based secure hosting service. While initially developed to meet the needs of gold centric projects, the application has also been utilized in porphyry copper, and rare element systems. As a result the application is now easily adaptable to any metallogenic system and has been used on projects worldwide by our clients.
The EDM SQL database includes tools that minimize the time between data acquisition and availability to end users. Our product reduces data management cost by greatly simplifying workflows.
Using the EDM increases data accuracy by maintaining control over data integrity and security through extensive validation at time of capture and process auditing, reducing "data busts".
Companies using the EDM benefit from the extensive cost savings of having an always available, verified, repository of their data and a streamlined data flow to key experts during 43-101 resource evaluations and feasibility studies.
“The EDM” is a multi-user web based exploration Data Management System designed to meet the real-time dynamic needs of exploration and development projects, significantly reducing data management costs and increasing data accuracy.
The EDM has much more flexibility and utility than other frontends to typical mine planning software packages.
Our online service allows management as well as technical employees immediate access to data utilizing a SQL Server® based security model ensuring data integrity and improving report turnaround time.
No software installation is required. All data is uploaded via laboratory certificates or Excel® Spreadsheets using your browser, and an internet connection.
Audit trails are maintained on all primary tables allowing change tracking when required.
Microsoft SQL Server® database allows third-party software to connect remotely via ODBC.
Users have the ability to generate canned as well as user customizable reports and export files.
Customized export formats can be generated to a users specifications, minimizing reporting delays.
The EDM has been designed from the ground up to be fast and efficient, reducing connection latency over poor internet field connections, for example satellite
The home screen from our Training Site is shown below. The basic concept is to provide access to all information concerning a particular drill hole from one screen. Note there is a separate tab for surface or point samples as well.
Data Entry
Data can be uploaded from customizable Excel® spreadsheets, and direct entry and editing is supported if internet access is available.
Extensive data validation is in place for each of the import processes to ensure only data that is accurate gets stored. This validation can be customized as necessary to meet your businesses unique requirements.
Assay and geochemical certificates received from assay labs are imported and stored in a master repository.
Data from this repository can then be posted to the assay, geochemistry, and QaQc tables based on lab method priority rules for each analyte. These rules can only be managed by authorized users.
Surface samples or other point sample data can be entered directly or from Excel® spreadsheets. Assay lab files can be posted to the surface sample table using analyte rules as described above.
Geologic logs can be entered using import templates. Management of different log versions, including relogs, is quick and easy. Logs can be activated and deactivated with the click of a button.
Bulk Data Importing
Data Importing
Category
Spreadsheet
Online Form
Drill Hole Header/Collar
Yes
Yes
Dbsheet/Drill Samples
Yes
No
QaQc Samples
Yes
Yes
Assay Certificates
Yes
No
Drill Hole Surveys
Yes
Yes
Geology Drill Log
Yes
Yes
Surface or Point Samples
Yes
Yes
Geology Codes
No
Yes
Lab Methods
No
Yes
Standards
No
Yes
Projects
No
Yes
Areas
No
Yes
Geologist
No
Yes
Users/Permissions
No
Yes
Legacy data can be imported from spreadsheets utilizing the geologic log import module or from an existing database.
Data Integrity
Extensive data validation routines are integral to the system. For example, when lab files are imported, lab methods and elements are checked against look up lists. Look up lists are also utilized for all geologic parameters. Each project can have a unique set of look up lists. Referential integrity is enforced on Project, Holename and Depth in primary tables.
Database Security
A robust security model is in place using SQL Server® to limit permissions based on assigned roles. For instance, all valid users are able to view most data but are not allowed to make changes. A user assigned to the Geology role can modify geologic records but cannot create assay records. The security model is managed from an administrative form by an authorized user.
Changes to data in the primary tables are audited in the background so there is a complete list of changes available indicating what, when and who made them.
Productivity Tools and Data Reporting
Productivity Tools
Compositing (GxT calculator)
Significant Intercept Calculation
RC Sample Generator
Sample Data Digger (Quick Find)
Standards Management
Geology Log Template Mapping
Lab Method Management
Surface Sample Management
Drill Hole Data Delete
Remove Header Records
QA QC Charting
Feature Request Submission
Geolog Import
Reporting-Exporting
Geodata Digger Report *
Drill Hole Table Data Exporting
Drill Hole GeoData Exporting
Drill Hole Assays Complete Report
Drill Hole Recent Changes Report
Drill Hole Assay Report
Results By Method Report
Drill Hole Header Report
Surface Sample Data Report
Certificate Surface Samples Processed Report
Automated Email Reports
ODBC Support For 3rd Party Software
KML For 3rd Party GIS Software
User customized reporting is available along with various standard reports. Export files can be created to support virtually any third party application. Significant intercepts can be calculated and stored using a user configured color-coded interactive form.
*Geodata Digger Report allows the user to simply select via menu check boxes any custom combination of drill hole analytical and/or geologic variables, (click here to see a report example). Geodata Digger Report format can also be used to export custom data sets.
Pricing
Our pricing is flexible and dependent on the needs of your business.
Our experience has shown that every customer has varying requirements depending on existing systems and legacy data, among other factors. Which is why we begin with a consulting session and review of the clients needs so they can obtain the most value from the service and realize the most return on their investment.
In addition to help with implementing the EDM online service itself, our consultants offer an ongoing full line of support services to help you get a handle on your data.
Once the service has been configured for your business there is a monthly subscription fee for up to five unique user logins to access the service. Additional unique logins can be purchased for an additional fee.
Please Contact Us to discuss your organization's specific requirements in more detail and for more pricing and services information.
What help do we offer you?
Our consultants are available to provide direct data organization and management support, to help you address the ‘Where do we start?' question. EDM consultants can:
Review and consolidate digital and hard copy data
Integrate historic legacy data, including automated assay unit conversion
Load all data and verify it
Configure custom reports to meet user specifications
Configure custom output formats to meet user specifications
Train client staff
Our consultants can provide ongoing support for new data upload, verification and reporting in the event in-house resources are unavailable. Please contact us for pricing and additional information.
Customized functionality and integration services can be provided to meet your business requirements.
Help with your EDM installation
Our consultants are committed to providing full support for our loyal customers. Our comprehensive training on the usage and best practices of the EDM will ensure you and your employees get the most out of your EDM installation.
Contact Us
We look forward to hearing from you to discuss your existing workflows, data sources and data customers. Please send us an email at info@edmsolutions.biz and let us know your interests and a good time to call
We would be happy to give you a demonstration of the EDM and consult with you on your specific requirements.