Simple cross section production was the best part - thankyou
@MiningGeologist
3 жыл бұрын
i m happy that it was useful for you
@blancarmo
7 ай бұрын
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_
7 ай бұрын
Hi, I have the same problem.. :(
@harpyabozed4331
2 жыл бұрын
Python error: An error has occurred while executing python code. This massage above show when I try Downhole data Any suggesting?
@checarlom
10 ай бұрын
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
10 ай бұрын
I have the same issue :(
@Tom-ks9xl
5 ай бұрын
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
5 ай бұрын
Check the text beneath. It explains how to solve the issue
@hsahil_10
2 ай бұрын
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!
@craigh3725
4 ай бұрын
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 :/
@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!
@oguzhancamci4133
2 жыл бұрын
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?
@toma5982
2 жыл бұрын
This is a very clear explanation, and the content of your courses looks good. Thank you!
@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!
@gech11
2 жыл бұрын
Hi mining geologist Generally I like your presentation and I have some questions How can assay data display on drill hole section with lithology?
@lucysackey6337
4 ай бұрын
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
@omaralmeida3416
3 ай бұрын
Thanks for share!! very clear information! regards from Mexico
@UFCUEAU
Жыл бұрын
Great video, clearly explained and a good pace. Thanks
@MiningGeologist
Жыл бұрын
Thank you for your feedback, I m happy it was useful
@nicthofer
4 ай бұрын
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)...
@nkanikaruigema3103
3 ай бұрын
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
@kgballou
Жыл бұрын
Great video, is there a way to change the Y-axis scale to add minor tick marks and labels?
@thokowindow2364
4 ай бұрын
Great tutorial,easy to follow
@robertmillar211
2 жыл бұрын
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
2 жыл бұрын
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.
@wordsfromhills
9 күн бұрын
All the three files : colar survey n geology should be in csv format??
@sergiofreire7162
2 жыл бұрын
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
2 жыл бұрын
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
@wordsfromhills
9 күн бұрын
I made all the three files in csv format but when i try to categorize the symbology for the down hole data categorization does not happen, only one simple line comes "all other" . And there is nothing in the attribute table. Kindly help
@brianmghanga8048
2 жыл бұрын
can you send some sample data @Mining Geologist a humble request ?
@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
@omass007
3 ай бұрын
good tutorial, but i have problem with azimuth, my wells are vertical and i tried not make it and give me nonlogical view?????????
@cloysterX418
7 ай бұрын
Anyway to create 3D layers by connecting the lithologies?
@alexvilela7941
2 жыл бұрын
Awesome video thank you!
@GeoForge
4 ай бұрын
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?
@hsahil_10
2 ай бұрын
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
2 ай бұрын
check the box of the negative dip
@hsahil_10
2 ай бұрын
@@MiningGeologist Thank you, it worked.
@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 !
@MrSeidokan
2 жыл бұрын
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
2 жыл бұрын
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
@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 ?
@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
@alfredonietog7261
Жыл бұрын
Muchas gracias me sirvió mucho saludos desde México
@nicmatich
2 жыл бұрын
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
2 жыл бұрын
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.
@gabbronorite3940
2 жыл бұрын
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
2 жыл бұрын
I have the same problem were you able to find a work around ?
@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
@ericvonhiest7808
2 жыл бұрын
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
2 жыл бұрын
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 :)
@dessajiemadarcos2021
3 ай бұрын
when I try the Desurvey part, output layer is also composed of points not polyline. any solution for this?
@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.
@qgisforgeos
3 жыл бұрын
Once again ... Superb ..
@MiningGeologist
3 жыл бұрын
Thank alot
@mdhabib6715
2 жыл бұрын
Sir, May I get this data of CSV files which is you used in your tutorial??????
@downstream5227
3 жыл бұрын
can you share the data? for personal training
@MiningGeologist
3 жыл бұрын
i'll try to add a link
@qolindzalamangoveni7650
4 ай бұрын
My vertical drillholes dont want to display. Sometimes the show up but the drillhole length is way too exaggerated. Like km long
@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
@GeoRGBCommunity
3 жыл бұрын
Great work Mining Geologists. I love it!!!
@MiningGeologist
3 жыл бұрын
Thanks alot Geo RGB, your channel have some great content also
@natashasiame9014
4 ай бұрын
Thanks, let me practice
@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.
@Karanj77
Жыл бұрын
Very helpful video. Thanks
@taksorntaksavasu7016
Жыл бұрын
It is the great vedeo. Thank you very much for this excellent vedeo.
@MiningGeologist
Жыл бұрын
I m happy that you found it helpful
@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
@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
@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
@andreidecastro3336
Жыл бұрын
regarding the depth, is it in meters, cm, or mm? Also, why is the section not appearing?
@milantomic4711
2 жыл бұрын
good video. Is there any way to step through the section at set increments?
@TerracaftCivil
4 ай бұрын
But what software program gives you data in that csv format? Is this leapfrog?
@Tom-ks9xl
7 ай бұрын
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
@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.
@kijutonett
9 ай бұрын
Thank, can make a clip demo convert Epanet of water network .
@maulanaismail7427
11 ай бұрын
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??
@ahmedrifaat3515
3 жыл бұрын
Interesting topics you got keep it up we will support you
@MiningGeologist
3 жыл бұрын
Thank you Ahmed for the support
@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)
@wiliamevereti2755
3 жыл бұрын
Can you Please show the format of each of your CSV files that you use here Thanks
@MiningGeologist
3 жыл бұрын
yeah sure i'll try to show the format in the next tutorial
@brianmghanga8048
2 жыл бұрын
@@MiningGeologist 8 months no tutorial 😔
@MiningGeologist
2 жыл бұрын
@@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
@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 !
@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 kzitem.info/news/bejne/xpyEs3qte5uamZg
@altheawalker-hallam8672
2 жыл бұрын
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
2 жыл бұрын
Hey Althea, i would love to help send me sample data to email and i'll take a look at it
@defrina100
2 жыл бұрын
@@MiningGeologist Hi, can I ask the data also? i had trouble with own data.
@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.
@timrogers3343
2 жыл бұрын
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
2 жыл бұрын
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.
@nirmalvijayan3729
3 жыл бұрын
Could you please suggest some free software for 3d geological modelling
@MiningGeologist
3 жыл бұрын
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
3 жыл бұрын
@@MiningGeologist sure thanks sir
@sofiagarcia6598
2 жыл бұрын
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
2 жыл бұрын
hey Sofia yes you can import and view your DEM in 3D and in the section too
@aldoyulio7898
2 жыл бұрын
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?
@defrina100
2 жыл бұрын
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
@bagus4883
2 жыл бұрын
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
2 жыл бұрын
You can send me the survey file to mbsdsp9@gmail.com , thank you! :)
@RengifoOrtega
2 жыл бұрын
great video ! thanks for sharing it
@RengifoOrtega
2 жыл бұрын
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...?
@navu1961
2 жыл бұрын
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
2 жыл бұрын
I just added the link to the file used in the description please download the file and try it. I hope this helps
@navu1961
2 жыл бұрын
@@MiningGeologist Very helpful, thanks again.
@MiningGeologist
2 жыл бұрын
@@navu1961 You are welcome
@kjane3390
2 жыл бұрын
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
2 жыл бұрын
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 kzitem.info/news/bejne/lIV_mKGIfp-Ein4
@thinkerboom8465
2 жыл бұрын
How with combine this data with elevation value, and make this model to 2D section H:V, can we make it?
@fuqradinahmed1419
3 жыл бұрын
Please can you guide how to get those files i.e the colour file
@MiningGeologist
3 жыл бұрын
Thank you for your comment , please check this video below start from min 11 , you will see how the collar file is structured kzitem.info/news/bejne/1XqAx4R_pX9pjGk
@fuqradinahmed1419
3 жыл бұрын
Still i avent seen how extracted the data I can see the files are already therr
@MiningGeologist
3 жыл бұрын
@@fuqradinahmed1419 can you explain what do you mean by extracted the data ? since these files are what a field geologist give you
@nashsteve7384
2 жыл бұрын
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
2 жыл бұрын
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 ;)
@sandeephamsa5579
2 жыл бұрын
excellent Video
@MiningGeologist
2 жыл бұрын
Thanks , Subscribe for more ;)
@isabelaresende2324
2 жыл бұрын
Is it possible to generate a layer model through the drillhole interpolation?
@MiningGeologist
2 жыл бұрын
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.
@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
@dr.ravishankar6434
2 жыл бұрын
Very informative..Thanks dear.... can I get the CSV file ?
@MiningGeologist
2 жыл бұрын
Please send an email for that
@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
@izzywizzyable
3 жыл бұрын
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
3 жыл бұрын
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
3 жыл бұрын
@@MiningGeologist I did try this but it hasn't worked for some reason. Not sure if I am missing something!
@MiningGeologist
3 жыл бұрын
@@izzywizzyable i can check this for you send me a sample file if you want
@afzalhamdulay
2 жыл бұрын
where to get that csv excel file?
@MiningGeologist
2 жыл бұрын
send me an email
@NadiaSimanullang
Жыл бұрын
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 ?
@NadiaSimanullang
Жыл бұрын
@@MiningGeologist yes sir
@MiningGeologist
Жыл бұрын
@@NadiaSimanullang what Qgis version are you using ?
@NadiaSimanullang
Жыл бұрын
@@MiningGeologist qgis 3.2.8 sir
@jonathangarcia2757
10 ай бұрын
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
8 ай бұрын
did you manage to solve it? Had the same problem as you.
@jeromest-michel4911
5 ай бұрын
Same problem@@joaooo92
@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)
@MrGuyarnon
2 жыл бұрын
Hi, thannks for the video! is there a way to save the 3D postition of the drills in DWG format?
@MiningGeologist
2 жыл бұрын
Can you please explain further what do you mean by Drillhole position ?
@MrGuyarnon
2 жыл бұрын
@@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
2 жыл бұрын
@@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
2 жыл бұрын
@@MiningGeologist maybe you know of a diffrent way to export something like this from QGIS to DWG format?
@MiningGeologist
2 жыл бұрын
@@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
@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
@RGRGIS
2 жыл бұрын
Like!
@charlyona3364
2 жыл бұрын
Please Can I have the data??
@DiamondDad1
2 жыл бұрын
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
2 жыл бұрын
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
2 жыл бұрын
@@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
2 жыл бұрын
@@DiamondDad1 Yeah sure
@DiamondDad1
2 жыл бұрын
@@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!
@visionvirtuel5923
2 жыл бұрын
Thank you very much sir , but the plugin sends me python error messages, then it works very slowly, but otherwise thank you
@MiningGeologist
2 жыл бұрын
Can you tell me what are the errors you are getting ?
@visionvirtuel5923
2 жыл бұрын
@@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
2 жыл бұрын
@@visionvirtuel5923 Do you have the geoscience plugin installed properly, did you manage to import the drillhole data without the 3D visualization part?
@visionvirtuel5923
2 жыл бұрын
@@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
@JohnThompson1-x1s
9 күн бұрын
Thompson Elizabeth Hernandez Barbara Wilson Christopher
@mathieuagbo6464
2 жыл бұрын
Jai des difficultés pour affiché la 3D Jai besoin d'aide
@MiningGeologist
2 жыл бұрын
what is the problem exactly ?
@mathieuagbo6464
2 жыл бұрын
@@MiningGeologist je n'arrive pas a faire affiché le fichier survey et geologie. C'est seulement le fichier collar qui s'affiche
Пікірлер: 203