Top of Bedrock Surface from Lithology Data

[mnapolitan 0]

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.

[Molly 0]

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.

[mnapolitan 0]

Thank you.  I do have my bedrock sequential and greater than my soils.  I will give it a try.  

[mnapolitan 0]

It worked.  However, it was not really what I was looking for.  I wrote up something that explains what I wanted and what I did to get it.  I would like the ability to query the database and then generate a grid from that query to make a surface using the various algorithms for developing the gridded data.  

Lith to Top of Rock.docx

[mnapolitan 0]

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)

[mnapolitan 0]

[mnapolitan 0]

I used DB Browser to query the database to generate what I wanted and then imported the text file and created a grid.

[TomB 0]

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

[Molly 0]

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

[mnapolitan 0]

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