Jump to content
RockWare Support Forum

Top of Bedrock Surface from Lithology Data


Recommended Posts

I have lithology data for my site that includes various bedrock types.  I have phyllite, metasandstone, dolomite, and quartzite.  I want to create a top of rock elevation contour map.  I can see how to create a superface grid in lithology under borehole operations.  However, this only allows me to create the grid for each individual bedrock lithology.  If I could query the database, I would look for the shallowest lithology G-codes for bedrock in each borehole and use that depth to create the top of rock contour map.  I just cant find a simple method in the menus for doing this.

Link to post
Share on other sites

I'll add to the wishlist the ability to pull a Lithology | Superface grid for a group of lithotypes. In the meantime, one option might be:

1. Add a new rock type to the Lithology Types table called "bedrock", with a unique G value. (Let' say "10" for this example.) You can uncheck "Show in Legend" so that it is not displayed in your lithology legends.

2. Create a Boolean Model (Solid | Logic) of phyllite, metasandstone, dolomite, and quartzite G values, setting the "true" value to "10", thus substituting "bedrock" for all of the distinct bedrock types. You can set the "false" values to 0 or null. Note that this will only work if the various bedrocks have sequential G values. (e.g. 6, 7, 8, 9) since you have to set a single min and max for the acceptable "true" range.

3. Generate a Lithology | Superface grid for this new Bedrock lithotype.

 

Let me know if that works!
Molly Mayfield
RockWare Inc.

Link to post
Share on other sites

Select Lithology.BhID,Location.Name,LithType.Name RockType,Northing, Easting, depth1,(Elevation-depth1) BedrockDepth
From Lithology
Inner Join LithType
on Lithology.LithTypeId = LithType.LithTypeId
Inner Join Location
on Lithology.BhId = Location.BhId
where GValue >=6
GROUP BY location.Name 
Order by min(Depth1)

Link to post
Share on other sites

Hi Mike,

 

Another way to create a grid on the top of multiple Lithology types is to export the Lithology to Excel, then import the Lithology to the Stratigraphy table. Delete the different bedrock lithology types in the Stratigraphy Types table and merge them into a single Stratigraphy unit, then create a grid with the Stratigraphy | Single Surface menu.

 

Regards,

Tom B

RockWare Inc

Link to post
Share on other sites

Here is another query example, from our database expert. This will give you the XYZ point for each hole where the first (shallowest) occurrence of the bedrock lith types occurs. This example illustrates the Samples database, you would need to change the lithotype names for your project:

 

SELECT Location.Name, LithType.Name as Keyword, LithType.GValue, Easting+X1 as Easting, Northing+Y1 as Northing, MIN(Elevation-Z1) as Elevation FROM Lithology
JOIN Location ON Location.BhId=Lithology.BhId
JOIN LithType ON LithType.LithTypeId = Lithology.LithTypeId
WHERE LithType.Name IN ("Sand", "Silt")
GROUP BY Location.Name
ORDER BY Location.Name

 

and get, which pasted in a Datasheet could create a grid.  You would need something like SQLite Expert Personal (Free) to get the query results to cut/paste to the datasheet

Name     Keyword     GValue     Easting     Northing     Elevation
DH-01     Silt     3     481976.2     4399822     1762.1
DH-03     Sand     4     481951.7     4399925     1778.1
DH-04     Silt     3     482064.1     4399822     1766.487
DH-06     Silt     3     482022.7     4399784     1764.667
DH-07     Sand     4     482122.8     4399864     1816.4
DH-08     Silt     3     482025.2     4399946     1784.1
DH-09     Sand     4     481927.2     4399864     1783.5
DH-10     Sand     4     481927.2     4399781     1775.5
DH-11     Silt     3     482122.8     4399781     1767.3
DH-12     Sand     4     482122.8     4399946     1799.73
DH-13     Sand     4     481975.1     4399755     1777.6
DH-14     Sand     4     482055.9     4399773     1793.513
DH-15     Sand     4     482135.8     4399834     1812
DH-16     Sand     4     481897.7     4399829     1781.1
DH-17     Sand     4     481927.9     4399966     1772.5
DH-18     Sand     4     481986.6     4399957     1774
DH-20     Silt     3     482168.2     4399976     1792.7
DH-21     Sand     4     481996.7     4399899     1774.1
DH-22     Silt     3     482154.1     4399919     1790.3
DH-23     Sand     4     482170     4399838     1816.1
DH-24     Silt     3     482168.9     4399767     1769.9
DH-25     Sand     4     482137.6     4399730     1798.6
DH-26     Sand     4     482018     4399738     1814.5
DH-27     Sand     4     481890.6     4399748     1768.481
DH-28     Sand     4     482046.4     4399826     1810.5
DH-29     Sand     4     481880     4399874     1785
DH-30     Sand     4     481896.6     4399952     1780.4
DH-31     Sand     4     481979.8     4399998     1771
DH-32     Silt     3     482033.8     4400010     1790.3
DH-33     Sand     4     482135.8     4399997     1798.51
DH-34     Silt     3     482073.8     4399782     1766.7
DH-35     Silt     3     481982     4399796     1765.3
DH-36     Sand     4     481971.1     4399854     1779.4
DH-37     Sand     4     482037.8     4399919     1798.5
DH-38     Sand     4     481882.9     4399851     1784.7
DH-39     Sand     4     481906.3     4399997     1769.4
DH-40     Sand     4     482029.9     4399895     1801.6
DH-41     Sand     4     482078.9     4399879     1808.2
DH-42     Sand     4     482028.1     4399825     1811.2
DH-43     Silt     3     482059.8     4399945     1784.489

 

Molly Mayfield

RockWare Inc

Link to post
Share on other sites

Thank you Molly.  I used that query and it worked.  I did modify it to be max(Elevation+Z1)  because Z1 is a negative number

 

SELECT Location.Name, LithType.Name as Keyword, LithType.GValue, Easting+X1 as Easting, Northing+Y1 as Northing, Elevation as GroundElev, MAX(Elevation+Z1) as BedrockElev, Depth1 as Depth
FROM Lithology
JOIN Location ON Location.BhId=Lithology.BhId
JOIN LithType ON LithType.LithTypeId = Lithology.LithTypeId
WHERE LithType.Name IN ("Slate", "Metasandstone","Quartzite", "Dolomite", "Phyllite")
GROUP BY Location.Name
ORDER BY Location.Name

 

Name Keyword GValue Easting Northing GroundElev BedrockElev Depth
BH-1 DOLOMITE 8 2296130 232935 533.1 508.1 25
BH-2 METASANDSTONE 6 2296829 233236 518.3025 504.3025 14
BH-3 METASANDSTONE 6 2296493 233253 531.2397 522.2397 9
BH-4 SLATE 10 2296982 232280 500.3275 483.3275 17
BH-7 METASANDSTONE 6 2296147 232925 533.7025 496.7025 37
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...