Display drillholes in 3D in Qgis and Create Sections

In this video i'll show you how to display drillholes in 3D with geology or assay data in Qgis and create cross sections automatically.
if you want to learn more about Qgis and master this free GIS tool check out my course here :
geo-trainings.com/home/home/c...
✅🔥🔥🔥Get All my courses for a Flat Price here 🔥🔥🔥 :
bit.ly/geologybundle
✅Get my trainings here :
geo-trainings.com/
✅Support me on Patreon here :
/ mining_geologist
✅Buy me a Coffee here ☺️
www.buymeacoffee.com/MiningGe...
✅Follow me on Facebook
/ mininggeologists
✅ Download the Drillhole data here :
bit.ly/3vkaVKr

[@toma5982]

This is a very clear explanation, and the content of your courses looks good. Thank you!

[@yvesramil4968]

👏👏👏👏👏Really impressed! I used licensed modeling softwares before, but to find out that a free software can do some important basic tasks in such a simple way, I'm positively shocked. Thank you very much for this tutorial and especially for the very very fluid explanation.! Wow!

[@hsahil_10]

Thank you Sir for this great explanation and the training files. This helps me a lot. Your explanation has such a good continuity that makes the listener to follow you and understand better. Look forward to watching more of yours. Cheers!

[@BillHorger]

I liked your tutorial on this feature and both the Geoscience and 3-D interface. It gave me something to experiment with using real data and 3-d visualization. And it gave me a real sense of how QGIS works and can work for me and my customers. I really appreciated your posting the raw data files from which you created the tutorial. I found them exceptionally revealing. It is unfortunate that the data created from the Geoscience plug-in is flawed (and the resulting 3-d displays and created layers reflects this), and the Geoscience plug-in itself lacks actual documentation on the data formats and processing, rendering it only usable for me as a toy. It appears that the basic functionality is being ported to a "commercial" product still in development, but only available as beta. I still give you "thumbs up" and am looking forward to looking at your other instructional offerings!

[@rokn3rd]

Simple cross section production was the best part - thankyou

[@MiningGeologist]

i m happy that it was useful for you

[@UFCUEAU]

Great video, clearly explained and a good pace. Thanks

[@MiningGeologist]

Thank you for your feedback, I m happy it was useful

[@GeoRGBCommunity]

Great work Mining Geologists. I love it!!!

[@MiningGeologist]

Thanks alot Geo RGB, your channel have some great content also

[@alexvilela7941]

Awesome video thank you!

[@thokowindow2364]

Great tutorial,easy to follow

[@omaralmeida3416]

Thanks for share!! very clear information! regards from Mexico

[@simenehkebede7207]

Thank you very much , I have been looking your videos and it is appropriate and appreciated Well explained Keep it up

[@MiningGeologist]

Thank you I m sure you like my last video about the new Qgis plugin as well !

[@Karanj77]

Very helpful video. Thanks

[@ahmedrifaat3515]

Interesting topics you got keep it up we will support you

[@MiningGeologist]

Thank you Ahmed for the support

[@qgisforgeos]

Once again ... Superb ..

[@MiningGeologist]

Thank alot

[@alfredonietog7261]

Muchas gracias me sirvió mucho saludos desde México

[@RengifoOrtega]

great video ! thanks for sharing it

[@RengifoOrtega]

I just have a question. In your sample data you have a Depth values which appears to be positive? Are those values in meter or centimeters...?

[@sergiofreire7162]

Thanks again. I am happy to suceed in built my first geological section with QGIS. A small diference between your results and mine was, the my Downhole_Geology came up side down. The spheres were positioned in the bottom instead of top.

[@MiningGeologist]

To fix that , all you have to do in the geoscience plugin when you run the Desurvey hole option is to uncheck the checkbox that says down dip is negative

[@taksorntaksavasu7016]

It is the great vedeo. Thank you very much for this excellent vedeo.

[@MiningGeologist]

I m happy that you found it helpful

[@kgballou]

Great video, is there a way to change the Y-axis scale to add minor tick marks and labels?

[@GeoForge]

This is fantastic, glad I found your video and the program. Is there a way I can model the strike and the dip of the beds measured in the drill holes? where would I put that data into and make sure to model it in the software?

[@craigh3725]

Great video, to the point and easy to follow! though is anyone else having issues with this working lately? having problems getting the 3d part working in Qgis2threejs :/

[@milantomic4711]

good video. Is there any way to step through the section at set increments?

[@rawhead909]

Great video, I was looking for something like this! I'm an archaeologist, and I would like to do something similar but make a 3D heat map (# of artifacts instead of lithology), and I think I can use this as a spring board...

[@MiningGeologist]

For 3D wireframes, try using Geological modeling software, I have a full course here on the channel check it out.

[@harpyabozed4331]

Python error: An error has occurred while executing python code. This massage above show when I try Downhole data Any suggesting?

[@sandeephamsa5579]

excellent Video

[@MiningGeologist]

Thanks , Subscribe for more ;)

[@gech11]

Hi mining geologist Generally I like your presentation and I have some questions How can assay data display on drill hole section with lithology?

[@natashasiame9014]

Thanks, let me practice

[@oguzhancamci4133]

Hi mining geologist, When I upload survey and geology data, program gave error. /AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\geoscience\DrillManager.py", line 187, in createDownholeData self.logFile.write(" Creating Downhole Data Layer. ") AttributeError: 'DrillManager' object has no attribute 'logFile' That kind of thing. What can I do for that?

[@aldoyulio7898]

Hello, thanks for the tutorial, i already did from the video but when I go qgis2threejs exporter it didn't show anything to screen, when I check 3D on point and line it still blank, the only thing that can be preview is the flat plane, do you know what is the problem?

[@mdhabib6715]

Sir, May I get this data of CSV files which is you used in your tutorial??????

[@MrSeidokan]

Hi. Thanks and congrats for the videos, very helpful for my entry level. One question: How can I create a cross section using the project topography of a vector layer for more detailed work i.e. planning infilling drilling?

[@MiningGeologist]

Hello Miguel , if you want to create a cross section using the same method i used in this tutorial , you need first to get a DEM ( raster topography not vector) , so basically what you need to do is to interpolate the the vector topo you have using TIN algorthim for example or IDW which will generate a raster version of your vector topography then do as i did in the video . i hope this helps

[@sofiagarcia6598]

Hi! Thank you for the video. I would like to ask you if do you think that it is possible to have the topography from the DEM in the section. Thank you!

[@MiningGeologist]

hey Sofia yes you can import and view your DEM in 3D and in the section too

[@TerracaftCivil]

But what software program gives you data in that csv format? Is this leapfrog?

[@kjane3390]

Hi! Is there a way to display the DH lithology in 3D with labels, for example, EOH depth and also labeling with lithology name, as opposed to just colors? Love your channel!

[@MiningGeologist]

Yes of course Jane you can do that if you right click on the Collar points and choose properties in the bottom of the window you will an option to add labels please check this video i talked about it but i didn't use it since for block models it is going to crash the software . Thank you so much being here in the community i happy that you like the channel kzbin.info/www/bejne/aYCsY6CIetKGjas

[@checarlom]

Hello, I appreciate your detailed tutorial. However, I encountered an issue while using the Qgis2threejs plugin. Despite following your instructions step by step and loading the correct geology downhole data, I am only able to see points in the visualization, not the vertical lines. Could you help me troubleshoot this problem? Thank you!

[@jec96]

I have the same issue :(

[@Tom-ks9xl]

The problem is that the latest update of the qgis2threejs plugin has a problem with the vertical axis of the Geoscience plugin. You can solve this problem by downloading a older version from qgis2threejs manually as a zip file. The start the qgis2threejs again and it will run. But do not update the plug in, otherwise you will have the same problem again.

[@Tom-ks9xl]

Check the text beneath. It explains how to solve the issue

[@duehara1206]

Thank you for a good training video about the very useful tool. In my case, using "pipe" setting, tops of lithology sections show rounded. How can I make flat tops?

[@MiningGeologist]

I don't think there is an option to make them flat because the tool is not made for this purpose

[@defrina100]

Hi, I have tried with my own data. but only small part of litology from 1 point is shown when I process collar-downhole. any suggestion to solve it? thanks in advance

[@sandeepcs2191]

Mining Geologist, absolutely love your Channel! Will be taking the course on Implicit Geomodelling as well pretty soon! just had one doubt though, where can we source the data from? I do not mean the data that you used for this particular video, but if I were to create a 3D drillhole using a completely different dataset, where can I find them? especially the Geological excel data! if you could throw some light on that, it would be really grateful! Thank you!

[@MiningGeologist]

These tables are usually provided by the team who did the drilling , but if you have the logs you can create them yourself easily. Collar table : just put holeid, x , y , z coordinates of the hole Survey table : holeid, azimuth of the hole ( dip direction, 0 if vertical hole) , dip ( 90 if vertical hole) , maximum depth of the hole ( end of hole depth) Geology table : holeid, from depth, to depth , lithology in that interval ( the code of lithology for example SAND) PS : you need to use the same names in the in all tables in the holeid column for example don't use DH1 in collar and dh1 in survey. the max depth in the geology table should be the same you used in the survey table, there should be no missing intervals in the geology table. from 0 to 5 Lith1 from 5 to 10 lith2 => all the way to the end of hole depth. I hope this helps !

[@sandeepcs2191]

@@MiningGeologist I appreciate you taking the time out to type it all out! Thank you for that, will give it a shot.

[@cloysterX418]

Anyway to create 3D layers by connecting the lithologies?

[@nicmatich]

Hi Mining Geologist. Is ther a way to scale the "Z" values in the 3D view so that the holes are exaggerated in length.

[@MiningGeologist]

yes of course you can, in the Qgis2threejs window click on "Scene" in the main menu then "scene settings" and you will find an option for "vertical exaggeration". Play arround with the values until you get what you are looking for. i hope this was helpful.

[@blancarmo]

I've seen similar comments below, but I'm not being able to display the desurvey lines nor the downhole data in the 3D viewer. I followed the tutorial to the detail and used your spreadsheets but it is not working. do you know what might I be doing wrong? Thanks for a very well-explained and interesting video!

[@AbdielMunoz_]

Hi, I have the same problem.. :(

[@andreidecastro3336]

regarding the depth, is it in meters, cm, or mm? Also, why is the section not appearing?

[@cschoon10]

Hi! Thankyou for the tutorial, I'm just having a small issue. I am using some old datasets to do some practice for future programs and am doing E-W sections of a 40x40m program. The sections can be quite long (upwards of 500m). What I'd like to do, to make the data easier to read or fit into a drilling report is to change the horizontal and vertical scales independently of one another, is there a way to do this in QGis? Thanks for your help!

[@MiningGeologist]

I don't think it is possible with this plugin, I m sure there are better ways to do this.

[@kasabianmat]

Very good work, this plug in is amazing, thanks for explaining! What would you suggest is the reason my sections are not showing up after I draw them?

[@MiningGeologist]

Thank you but your problem will depend on your data and how you created the section. I cannot tell what is the issue without more details.

[@kasabianmat]

@@MiningGeologist thanks for responding! I really appreciate it. Well, eventually, it requires the sections to cross exactly on top of the boreholes, otherwise there is nothing to show, I needed to have extrapolated anything in between. This is a good challenge for QGIS to overcome the expensive software.

[@johnesch3409]

Thanks for your QGIS Geoscience plugin videos, Is there a setting to set a vertical exaggeration on the sections? Most subsurface geological requires significant vertical exaggeration. Is it possible to have a multiple vertices instead of just a straight line for the section? It would be nice if Geoscience would allow for bringing in downhole geophysical data like a gamma-ray log in the standard .las format.

[@MiningGeologist]

Probably not possible with the current version, I think the founder stopped updating the plugin. but check out this one which I m developing right now so I might include these features kzbin.info/www/bejne/m5exfnmtd86cnMU

[@dessajiemadarcos2021]

when I try the Desurvey part, output layer is also composed of points not polyline. any solution for this?

[@gabbronorite3940]

Hi, sir! Great video! I just have a concern regarding the downhole data. When I checked the attribute table, there are no features. How can I fix this? Thank you!

[@brianmghanga8048]

I have the same problem were you able to find a work around ?

[@lucysackey6337]

Hi great tutorial tried it but my holes only plot in plan and not inclined even after l tick and untick down hole is negative

[@timrogers3343]

Any thoughts as to why my boreholes show as being horizontal when they are actually vertical? I'm not putting an azimuth or dip in.

[@MiningGeologist]

First of all Tim thank you for your comment and for following this channel ! You already answered your question the azimuth and dip are missing . Because collar file is for drillhole location (X,Y,Z) and the survey file (Dip and Azimuth ) will tell the software how much are they dipping ( 60° for example) and in which direction ( 120° azimuth) . so you need these to have your drillholes visualized the right way.

[@kijutonett]

Thank, can make a clip demo convert Epanet of water network .

[@thinkerboom8465]

How with combine this data with elevation value, and make this model to 2D section H:V, can we make it?

[@altheawalker-hallam8672]

Hi Mining Geologist, Thanks for your helpful tutorial. I'm another person who might be having trouble with the format of my files. The desurveying step seems to work fine but I keep getting a blank downhole data file. Can you suggest anything for me to try?

[@MiningGeologist]

Hey Althea, i would love to help send me sample data to email and i'll take a look at it

[@defrina100]

@@MiningGeologist Hi, can I ask the data also? i had trouble with own data.

[@taharhammouda8692]

Geat and very useful video, thank you very much!. I find problem while trying to use drilling desurvey hole command. this message appear : The data source for the layer could not be found. I tried with your files and it works but it doesn't work with my data!! is there any explanation to that? For information, I use meter unit for parameters such as elevation, depth...

[@MiningGeologist]

I m sure it is an import issue, or your data in not in the right format

[@nicthofer]

What are the situations in which this doesn't work? For example I don't have the Azimuth or Dip of every sample, so this won't work? When I go to Downhole data, I only get blank spaces in the four options (Layer, Hole ID, From/Depth, To). By the way, my resulting shape Desurvey has 3 columns (fid; CollarID; Seglength)...

[@Tom-ks9xl]

It worked. But since yesterday when i want to see the downhole geologie in QGis2threejs they don't appear suddenly anymore. When i gi to zoom to layer its jumping to nowhere. Whereas the point coordinator appear correct in 3d. In the console it says: referenceerror cant find variable:app three.min.js(42):three.webGLrenderer:angle_instanced_arrays extension not supported... this problem didn't appear before. I updated yesterday all pluginns... i guess it somehow caused this. My data is all correct.. to double check i used your data... the fault remains the same

[@ericvonhiest7808]

Awesome, I used our company data as I walked through the video - works really well, but the pipe (DH trace) thickness crashes a bit with lots of drill hole data....

[@MiningGeologist]

I m happy that you found the tutorial useful , and yes with alot of data the 3d display might cause the software to crash because Qgis is made only for 2D plots but maybe in the near future we will see some tools that integrate perfectly with Qgis and works smoothly with 3D data, make sure to subscribe to be notified if such thing is available :)

[@RGRGIS]

Like!

[@nashsteve7384]

High good voice Geologist, my question is that when i click qgis2threejs and highlight my desurvey, my boreholes direction is towards to sky lol :D something wrong should be about my depth. I checked if it is your minus value, but yours are positive as well just like mine. Whats wrong ?

[@MiningGeologist]

Hey Steve thank you for the comment and for being here in this channel , well the wrong thing is not your depth it is your Dip in the video min 5:48 you will notice that there is a checkbox that says "Down dip is negative", if your Dip is positive say 90° and the checkbox is checked , then your drillholes will be pointing to the sky let me know if that solved your problem ;)

[@robertmillar211]

Can you do a tutorial on how to setup the drill hole data in the spreadsheet for this? I have around 1000 drill holes I need to model for a mine remediation project.

[@MiningGeologist]

hey robert , thank you for your comment, i would love to help you send a sample of these drillholes and i'll put them in the right format and then you can follow what i've done with the rest of the dataset.

[@juanfeliperodriguez6553]

very good explanation. i had some problems with the csv and the commas and dots, but now i have something. only problem i have is that the drills are towards the sky instead the ground. Where must i change the data to correct this issue? thank you so much.

[@MiningGeologist]

When you do Desurvey Hole there is a checkbox saying "Down Dip is Negative", check that or uncheck that based on your dataset

[@redfox7006]

Hi, great explanation of using this tool but I am having some issues. I know this is an old video but I am wondering if you can help me. I have about 100 drillholes that I would like to plot. When I try to run the downhole survey with my collar and survey csv files the surveyed layers get loaded into the layer manager but nothing appears in the project and I have the error "Layer unavailable, data source could not be found" and "Warning some east, north, collar, depth values are not numbers" . I tried with the data you provided as well and got the same issue. The only difference I can see in the process is that your data was separated by a semicolon and mine is comma delimited and I have surveys at multiple depths with azimuth/dip values that have decimals. Any ideas? Thanks

[@MiningGeologist]

No worries @Redfox700, can you send a sample from your dataset I'll check what is the error and send you a detailed solution via email , you can apply a transition to the coordinates if you want. (my email can be found the about section in my channel , cannot post it here to stay away from bot emails)

[@bagus4883]

Hi! Thank you for your video, it helps me a lot! May i have a look for the survey file? I have trouble in displaying the lithology line after desurveying. Hope you read my messege quickly :)

[@bagus4883]

You can send me the survey file to [e-mail] , thank you! :)

[@brianmghanga8048]

can you send some sample data @Mining Geologist a humble request ?

[@maulanaismail7427]

Can I Ask you a Question, Is it possible to be rendering with TIF Files?? so how can it done?? Is it going to be render or is it not working?? Have you ever tried??

[@DiamondDad1]

Hi Mining Geo, If I drag a Survey or Geology CSV file into QGIS the numbers show up as text (string). If I add the CSV file as a Delimited Text File then sometimes the numbers show up as integers or decimal numbers, but sometimes as text. I go into Fields and make sure all numbers are integers or decimals, but when I use the Geoscience plugin the drill collars plot OK but not the lines representing the drill holes nor any lithology. I get an error message saying "Warning: Some 'From' or 'To' values are not numbers". I assume this is why the drill holes are not showing up in 3D. How do I get QGIS to recognize numbers as numbers when I add a CSV file?

[@MiningGeologist]

I think the problem is easy to solve, if I m not mistaken this is caused by the decimal separator you are using if you are using comma (,) and it is not working try using a point (.) as a decimal separator(or the opposite if you are using a point). I think this should solve your problem, let me know what happened ;)

[@DiamondDad1]

@@MiningGeologist Thanks for the quick response! I will have to play with this for a bit. I'm also using a Mac which may complicate things but I'll let you know if I solve it.

[@MiningGeologist]

@@DiamondDad1 Yeah sure

[@DiamondDad1]

@@MiningGeologist Well, it's definitely a CSV issue. I enlisted some help and recreated the CSV files from scratch using R software and the good news is there were no more error messages and the drill holes plotted in 3D, but the bad news is only the first intercept plotted, not the complete downhole lithology. So we have a few more bugs to iron out!

[@DEDEWANOUmyriam]

Hi Thks a lot for your vidéo. Just one question, how is your calculation to obtain the cell "_FROM_Z" and "TO_Z"? I understand that "Mid_z" is the average of the both but I don't get the formula for "_FROM_Z" and "TO_Z". Thks a lot in advance for your answer. Best regards

[@DEDEWANOUmyriam]

Ok when I looked the first time the video my enceinte didn't work. I fixed them and now I anderstand that the colum I was looking for are in fact calculated by QGIS. Clear for me now. Thks for your video. Best regards

[@sirb1846]

Great video for very useful task: thank you! But I have an issue: the holes are upward instead of being donward! What I'm doing wrong?

[@MiningGeologist]

To fix that , all you have to do in the geoscience plugin when you run the Desurvey hole option is to uncheck the checkbox that says down dip is negative

[@TheHackenberga]

Great vid. Any idea if you can you display the cross section in the 3D view of qgis2threejs?

[@MiningGeologist]

The cross sections will be displayed in the canvas as a map (Top view) so it is not possible this way! but I m working on a Qgis plugin that will change a lot of things here is a sneak peek : www.linkedin.com/feed/update/urn:li:activity:6999112487417614337

[@TheHackenberga]

@@MiningGeologist Unreal, thanks mate.

[@MiningGeologist]

@@TheHackenberga You are welcome ! Stay tuned for that !

[@navu1961]

Thanks for the video. Could you please show the data structure of the geology and survey csv files you added to the layers? In other words what are the column titles or headers? It would be great if you could open the two files.

[@MiningGeologist]

I just added the link to the file used in the description please download the file and try it. I hope this helps

[@navu1961]

@@MiningGeologist Very helpful, thanks again.

[@MiningGeologist]

@@navu1961 You are welcome

[@nkanikaruigema3103]

Is the any possibility to make different tutorials to get there, but showing how you start from collecting data, creating the Excel files and importing the files into QGIS

[@lambofgodinflame1]

Hi, great videos! For some reason the BH data seems to be upside down (both in 3D and section view). The BH circle is at base and BH data with geology above that. Any idea what is going wrong? Thanks!

[@MiningGeologist]

When you do Desurvey Hole there is a checkbox saying "Down Dip is Negative", check that or uncheck that based on your dataset

[@lambofgodinflame1]

@@MiningGeologist Thanks for the reply! All works great now.

[@MiningGeologist]

@@lambofgodinflame1 happy to hear that

[@isabelaresende2324]

Is it possible to generate a layer model through the drillhole interpolation?

[@MiningGeologist]

Technically it is possible, but it is going to require some tidious manipulation also the accuracy is not going to be as you expect. There are better software that can do this but most of them are paid softwares. If you stick around and follow my channel your problem might be solved in the near future I m working on plug in that will do this automatically in Qgis.

[@andreidecastro3336]

Also, it's taking so much time to build downhole data layer. I just used/practiced using 3 borehole data at 15m depth haha

[@MiningGeologist]

This is weird it is not supposed to take a lot of time with a such small dataset. do you have a good machine ?

[@izzywizzyable]

Hi Mining Geologist, Do you need survey data? I have none and I'm wondering what the easiest way to deal with this is. Most of my holes are shallow (

[@MiningGeologist]

Hello izzy, thank you for your comment , actually survey data are needed to allow the software to trace the path of the drillholes in subsurface , usually if the drillings are vertical like in your case you don't get a Survey file . but you can create one really easily, make a copy of your collar file , delete all the coordinates columns , keep only the drillhole name column now add two columns DIP ( make it all equal to 90 which means vertical drillholes , some softwares needs -90) and Azimuth column ( make it all equal to 0 ) since they are all vertical . i hope this helps .

[@izzywizzyable]

@@MiningGeologist I did try this but it hasn't worked for some reason. Not sure if I am missing something!

[@MiningGeologist]

@@izzywizzyable i can check this for you send me a sample file if you want

[@dicornius9596]

Hello. I have a question. I managed to get almost everything I needed learning from your video. I wanted to make a drillhole planning 3d drawing, so I don't even need the lithological info. I just changed the elevation on Qgis2threejs to the value I wanted and changed the symbols to cylinders. Worked perfectly so far. I just need to know: is there a way for me to tilt these objects on Qgis2threejs somehow? Do you have any idea? Because some of the drillholes shall be done diagonally and I need to represent that. Thank you

[@MiningGeologist]

just play around with the dip values in the survey file that should do the trick!

[@dicornius9596]

@@MiningGeologist Oh, that's the thing... i'm not even using Geoscience plugin cause it isn't necessary, since it's just a drillhole planning project. I'm straight up importing Google Earth Markers, adding coordinates to them, etc. Is there a way for me to add Dip values to them in a way that would display correctly on Qgis2threejs? Or add Dip values on Qgis2threejs window itself?

[@MiningGeologist]

@@dicornius9596 check the video description, you will find the dataset I used in the video (3 CSV tables) try creating similar tables but with your data then in the survey file try to adapt the DIP and Azimuth to your needs

[@downstream5227]

can you share the data? for personal training

[@MiningGeologist]

i'll try to add a link

[@jonathangarcia2757]

Hi ! Is the plugin still working? I get an error when doing the Desurvey. It shows like it creates the layers but then shows a warning message saying that it can't find where the shape files are and basically I can't find them either. Any idea? Thanks

[@joaooo92]

did you manage to solve it? Had the same problem as you.

[@jeromest-michel4911]

Same problem@@joaooo92

[@dr.ravishankar6434]

Very informative..Thanks dear.... can I get the CSV file ?

[@MiningGeologist]

Please send an email for that

[@omass007]

good tutorial, but i have problem with azimuth, my wells are vertical and i tried not make it and give me nonlogical view?????????

[@luguem4598]

Bonjour ! A quoi correspond le ''Z''dans le dossier collars ? Faut-il faire une différence entre l'attitude et la profondeur des autres dossiers qui commence à ''0'' et va jusqu'à ''4500'' ? J'essaie d'appliquer votre modèle a mes données de forage ! :) La vidéo est super mais j'ai des difficultés a l'appliquer a mes données... Merciii d'avance !!! 😁

[@MiningGeologist]

Z is the elevation in the collar table , 0 is the starting depth (starting from that Z elevation ) 4500 is the end of hole depth

[@andreidecastro3336]

What data is needed for the surveys? What is the input?

[@MiningGeologist]

Andrei , you will find a link to download the dataset used in the description you can check how it is structured. mainly the Same hole names, Dip, and azimuth you can set them to 90, and 0 respectively in case you have vertical holes

[@nirmalvijayan3729]

Could you please suggest some free software for 3d geological modelling

[@MiningGeologist]

Hello Nirmal , i m not aware of any free geological modelling software , but stay tuned and subscribe to this channel because i'll be making a course about how to make your geological modelling software how about that ?

[@nirmalvijayan3729]

@@MiningGeologist sure thanks sir

[@wiliamevereti2755]

Can you Please show the format of each of your CSV files that you use here Thanks

[@MiningGeologist]

yeah sure i'll try to show the format in the next tutorial

[@brianmghanga8048]

@@MiningGeologist 8 months no tutorial 😔

[@MiningGeologist]

@@brianmghanga8048 Hey Brian do you want just need the format ? if so send me an email and I can send you the data used in the tutorial

[@fernandocorreatodeschini4499]

It would be nice if you showed the input tables: geology ans surbeys data

[@MiningGeologist]

you can download them for free and check them yourself (link in the description)

[@afzalhamdulay]

where to get that csv excel file?

[@MiningGeologist]

send me an email

[@qolindzalamangoveni7650]

My vertical drillholes dont want to display. Sometimes the show up but the drillhole length is way too exaggerated. Like km long

[@hsahil_10]

When I load the 3D view, the lithology of the boreholes are shown up side down. The layers supposed to come first (on top) are shown in depth and vice versa.

[@MiningGeologist]

check the box of the negative dip

[@hsahil_10]

@@MiningGeologist Thank you, it worked.

[@fuqradinahmed1419]

Please can you guide how to get those files i.e the colour file

[@MiningGeologist]

Thank you for your comment , please check this video below start from min 11 , you will see how the collar file is structured kzbin.info/www/bejne/qnWtkoN_obJrj5Y

[@fuqradinahmed1419]

Still i avent seen how extracted the data I can see the files are already therr

[@MiningGeologist]

@@fuqradinahmed1419 can you explain what do you mean by extracted the data ? since these files are what a field geologist give you

[@chillandlyric8474]

hello sir, i follow all the step. but i dont know, when i want to show the drill hole. oll the drilll holes are about the point. and i dont know why

[@MiningGeologist]

are you using the same dataset I used in the tutorial ?

[@chillandlyric8474]

@@MiningGeologist yes sir

[@MiningGeologist]

@@chillandlyric8474 what Qgis version are you using ?

[@chillandlyric8474]

@@MiningGeologist qgis 3.2.8 sir

[@charlyona3364]

Please Can I have the data??

[@patrickmesa1947]

Do you have a video on how to set the tables up in excel?

[@MiningGeologist]

Hi Patrick, you are supposed to have these ready from the exploration team! what kind of data do you have exactly so I can assist you ?

[@patrickmesa1947]

@@MiningGeologist so I have bore logs. They were done before me so they are not up to my geology standards but that's all I have to go off of right now. So I built Autocad logs, but basically I have a GPS positions (which I easily can change Into northing and easting) depth of well, depth to water (I don't believe I have an initial elevation, but probably could get that from a DEM). The lithology is all messed up (there was only a field tech on hand doing it and I the geologist wasn't hired yet) so the lithlog was basically taken every 5 feet and goes [tan silty sand, tan silty sand, brown silty sand clay, tan silty sand]. I dont really have a proper thickness of each unit just because it was so vague. So the clay could have been an inch but the sample was taken at 5 minut Intervals so no too much to go on there. These were done at 2" holes by method of split spooning. So to summarize lol I have crappy litlog that I KINDA can break into sections but can't properly class, DOW, EOH, DTW, HoleID, and well location lol

[@MiningGeologist]

@@patrickmesa1947 I don't know if you are already familiar with the drill hole tables to perform desurveying in most of the mining packages or not. if not here is what you need : Collar table: put the hole name, x,y,z here (you can get an elevation from a DEM as you mentioned but that's not very accurate), and end of hole (I think if you sum up all the 5 feet intervals you can get one) - Survey Table: same hole ids, dip (if you have inclined holes, other than that use 90 or -90 depending on what the software accepts), azimuth (if they are dipping to a specific direction use the right one, if not use 0 ). - Lithology table: same drill hole ids, From , To intervals, and the lithology. - Assay Table: I don't think you need one in your case whenever there are similar successive intervals just make a single one, for example, sand(5ft), sand(5ft), clay(5ft) just make them sand(10ft), clay(5ft). if they did it every 5ft and you are not sure if the clay is 5ft or just 1ft that's a problem that no one can solve and I m wondering why would someone log it that way. Also in the tutorial description, you will find a link to download the same dataset I used in the tutorial this will help you understand how to format your data properly

[@patrickmesa1947]

@@MiningGeologist ya they we not geologist lol in fact I'm teaching the how to log lithology and switching them to hollow stem cores so they can be kept in boxes. The well is completely vertical and I do have access to the site to get initial elevation. The sampling was just done at 5' intervals. But I do have two done by an actual boring company that's a little more complete so I might be able to use them. But ya this was a project done 6 years ago with no since of data preservation. And they are all monitoring wells and now they want a n-s and e-w cross section with a water table contours and flow gradient lol

[@MiningGeologist]

@@patrickmesa1947 I bet your boss was like why invest in new drill holes Patrick use the existing ones and try to predict the lithologies . Just kidding ! Good Luck

[@visionvirtuel5923]

Thank you very much sir , but the plugin sends me python error messages, then it works very slowly, but otherwise thank you

[@MiningGeologist]

Can you tell me what are the errors you are getting ?

[@visionvirtuel5923]

@@MiningGeologist An error occurred while executing Python code: FileNotFoundError: [Errno 2] No such file or folder: '/home/ives/T%C3%A9l%C3%A9chargements/3D Drillholes in Qgis/Geoscience_DrillManager_log.txt' Traceback (most recent call last): File "/home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/geoscience/DrillManager.py", line 114, in onDesurveyHole self.openLogFile() File "/home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/geoscience/DrillManager.py", line 77, in openLogFile self.logFile = open(fileName,'w') FileNotFoundError: [Errno 2] Aucun fichier ou dossier de ce type: '/home/ives/T%C3%A9l%C3%A9chargements/3D Drillholes in Qgis/Geoscience_DrillManager_log.txt' Version de Python : 3.8.10 (default, Jun 22 2022, 20:18:18) [GCC 9.4.0] Version de QGIS : 3.26.1-Buenos Aires Buenos Aires, b609df9ed4 Chemin Python : /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/dms_2_deg /usr/share/python-wheels/certifi-2019.11.28-py2.py3-none-any.whl /usr/share/python-wheels/chardet-3.0.4-py2.py3-none-any.whl /usr/share/python-wheels/requests-2.22.0-py2.py3-none-any.whl /usr/share/python-wheels/wheel-0.34.2-py2.py3-none-any.whl /usr/share/python-wheels/lockfile-0.12.2-py2.py3-none-any.whl /usr/share/python-wheels/pkg_resources-0.0.0-py2.py3-none-any.whl /usr/share/python-wheels/pep517-0.8.2-py2.py3-none-any.whl /usr/share/python-wheels/ipaddr-2.2.0-py2.py3-none-any.whl /usr/share/python-wheels/packaging-20.3-py2.py3-none-any.whl /usr/share/python-wheels/webencodings-0.5.1-py2.py3-none-any.whl /usr/share/python-wheels/retrying-1.3.3-py2.py3-none-any.whl /usr/share/python-wheels/CacheControl-0.12.6-py2.py3-none-any.whl /usr/share/python-wheels/six-1.14.0-py2.py3-none-any.whl /usr/share/python-wheels/pip-20.0.2-py2.py3-none-any.whl /usr/share/python-wheels/appdirs-1.4.3-py2.py3-none-any.whl /usr/share/python-wheels/setuptools-44.0.0-py2.py3-none-any.whl /usr/share/python-wheels/html5lib-1.0.1-py2.py3-none-any.whl /usr/share/python-wheels/distlib-0.3.0-py2.py3-none-any.whl /usr/share/python-wheels/contextlib2-0.6.0-py2.py3-none-any.whl /usr/share/python-wheels/idna-2.8-py2.py3-none-any.whl /usr/share/python-wheels/colorama-0.4.3-py2.py3-none-any.whl /usr/share/python-wheels/urllib3-1.25.8-py2.py3-none-any.whl /usr/share/python-wheels/msgpack-0.6.2-py2.py3-none-any.whl /usr/share/python-wheels/pyparsing-2.4.6-py2.py3-none-any.whl /usr/share/python-wheels/toml-0.10.0-py2.py3-none-any.whl /usr/share/python-wheels/progress-1.5-py2.py3-none-any.whl /usr/share/python-wheels/distro-1.4.0-py2.py3-none-any.whl /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/MiMiGIS /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/OpenTopography-DEM-Downloader /usr/share/qgis/python /home/ives/.local/share/QGIS/QGIS3/profiles/default/python /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins /usr/share/qgis/python/plugins /usr/lib/python38.zip /usr/lib/python3.8 /usr/lib/python3.8/lib-dynload /home/ives/.local/lib/python3.8/site-packages /usr/local/lib/python3.8/dist-packages /usr/lib/python3/dist-packages /home/ives/.local/share/QGIS/QGIS3/profiles/default/python /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/mmqgis/forms /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/ee_plugin/extlibs_linux /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/go2streetview /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/go2streetview/res /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/HCMGIS/forms /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/isochrones /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/isochrones/iso/utilities . /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/shapetools/ext-libs /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/enmapboxplugin/site-packages /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/enmapboxplugin /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/enmapboxplugin/enmapbox/qgispluginsupport/qps/pyqtgraph /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/enmapboxplugin/enmapbox/site-packages /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/enmapboxplugin/enmapbox/apps /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/enmapboxplugin/enmapbox/coreapps /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/SentinelHub/external/requests_oauthlib-1.3.0-py2.py3-none-any.whl /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/gdrive_provider /home/ives/.local/share/QGIS/QGIS3/profiles/default/python/plugins/gdrive_provider/extlibs

[@MiningGeologist]

@@visionvirtuel5923 Do you have the geoscience plugin installed properly, did you manage to import the drillhole data without the 3D visualization part?

[@visionvirtuel5923]

@@MiningGeologist I received to import all the data including the drilling data which is displayed well, I also have the geoscience plugin installed but the problem when I start the first step in the plugin I have this message mistake

[@mathieuagbo6464]

Jai des difficultés pour affiché la 3D Jai besoin d'aide

[@MiningGeologist]

what is the problem exactly ?

[@mathieuagbo6464]

@@MiningGeologist je n'arrive pas a faire affiché le fichier survey et geologie. C'est seulement le fichier collar qui s'affiche

[@MrGuyarnon]

Hi, thannks for the video! is there a way to save the 3D postition of the drills in DWG format?

[@MiningGeologist]

Can you please explain further what do you mean by Drillhole position ?

[@MrGuyarnon]

@@MiningGeologist I would like to export the resolt on 10:20 min on the video to diffrent softeware (Rabbit) and i need DWG file.

[@MiningGeologist]

@@MrGuyarnon I m afraid this is not possible you can only export the results to a web page that you can view in your browser maybe you want to share it with someone or something. if this would help you just click File from the main menu ( of the plugin) then choose export for web

[@MrGuyarnon]

@@MiningGeologist maybe you know of a diffrent way to export something like this from QGIS to DWG format?

[@MiningGeologist]

@@MrGuyarnon I m sorry i m not aware of any option in qgis to export to DWG but you can export regular shapes to DXF if you want i don't think there software who can handle only dwg and not dxf check if yours can support dxf files