Chip Tray Photography made easy with Geobank Mobile
In the interests of sharing...
I built an automated solution for capturing high res images of chip trays.All made possible by Geobank Mobile.
Utilising a DSLR camera with a macro lens you can capture detailed images per bay (20 per tray ).
The machine drives the camera down the rail pausing at each bay and triggers the camera. Geobank Mobile receives the image - renames it ( utilizing a calculated field to build the required file name ) - then "Auto advances" to the next line and waits for the next image to arrive.
When you have thousands of trays your solution needs to be fast and efficient....
My latest version has
- Increased adjust-ability to accommodate a greater range of camera and lens combinations.
- New micro controller for improved performance and functionality.
- Smaller footprint.
- Rugged design
- Improved cycle time ( 70 seconds per tray )
You can easily process 500 photos ( 500m of drilling ) an hour. If you are organised upwards of 800 photos per hour is possible.
I hope you find this interesting....
If you would like more info feel free to drop me a line.
Addo Industries Pty
Customer support service by UserEcho
Great setup. I've been investigating Geobank Mobile functionality for core photos a couple of years ago, but we've moved into other direction (IMAGO).
Couple of questions:
1. Do you save images as BLOB type in the SQL database, or there is some other way? I think that is what stopped us from using this method, cause i was not sure if the quality will be decent, and how heavy the database will become with this new type of data.
2. Could you please share some snapshots of your 'photo' table in GM, including settings? (i assume the process is organized through a specialized table)
Thanks in advance,
Thanks for sharing this; having seen this in action, I can say that it works really well.
Andrey, the images can simply be stored at full DSLR camera quality as file images, with the Geobank Mobile table storing a link to the file location. Anatoli can show you the settings for the 'Image' data type to use.
Saving images in SQL as a BLOB is doable…. BUT I wouldn’t recommend it.
I use a separate tool to load all the “Metadata” for the images into our SQL database. ( including the file path to where the image is located ) Note! The tool also moves the images to a pre set location on a file share as the metadata is loaded.
The tool was originally designed to make the task of manually renaming core tray photos ( Back in the day when you manually copied the files from the camera SD card to your computer ). Now I just extract the metadata I need from the pre named files …. AND then push Load.
You can process thousands of files in minutes…
The metadata is loaded to the database … And the images are moved to the required location…
My drillhole related image table in the database looks like this. Nothing special. Just a typical related table in SQL.
Now that you have all the metadata for your imagery in your database ( including the file path to where the image is stored ) its child’s play to use this in Micromine.
CREATE VIEW [dbo].[DHPhoto_CTB]
SELECT P.DataSet, P.Hole_ID, P.Depth_From, P.Depth_To, CASE WHEN (Row_Number() OVER (ORDER BY P.DataSet, P.Hole_ID, P.Depth_From) % 2 = 0) THEN 0 ELSE 1 END AS Row, P.PhotoID,
P.Path + P.PhotoID AS Hyperlink
FROM tblDHPhoto AS P
WHERE (P.Photo_Type = 'CTB')
Now set up your database in Micromine like this…. No you can click on your drill trace in Vizex and BOOM … your image opens.