What are the Benefits of Using SQL Filters in Gemcom GEMS™?
SQL filters provide the ability to filter all drillhole data, or any other GEMS data, to the exact subset you require. This allows you to remove superfluous data and alerts you to anomalous data. SQL filters may be created once and reused, which saves time and reduces possible consistency errors.
GEMS SQL Filtering provides the capability to filter data on more than one table.
For example:
- If you want to see only holes drilled longer than a minimum length in an area that went through a specific lithological zone or had an assay greater than or equal to a value, your SQL filter might look like:
[DDH1_HEADER].LENGTH >= 50 AND ([DDH1_LITHO].[ROCK_CODE]>=10 OR [DDH1_ASSAY].[AU(OZ/T)]>3)
- Or if you are looking only for holes drilled longer than a specific length and have an assay value greater than or equal to a value, your SQL filter might look like:
[DDH1_HEADER].LENGTH >= 50 AND [DDH1_LITHO].[ROCK_CODE]>=10 AND [DDH1_ASSAY].[AU(OZ/T)]>3
Once filters have been created they can be used in several places within GEMS:
- When opening the holes for viewing in the 3D graphical view.
- Within the data editor (Workspace > Edit data).
- When exporting drillhole data to Excel.
Additionally, “AND” as well as “OR” statements can be combined to create very versatile filters. Examples can be found in the GEMS Help by searching keywords “SQL Filters”.
To learn more about GEMS, visit www.gemcomsoftware.com.
