View the Interval Data Layout

Tutorial: View the Interval Data Layout

Estimated time: 5 minutes.

In this lesson, you will look at how downhole "Interval" data is entered, how the columns are defined, how to edit the data as a datasheet, how to generate a frequency histogram of the values, and how to do a simple query.

Be sure the Samples folder is still the current project folder (see Open a Project for information).
In the borehole file listing along the left side of the Borehole Manager, click on the borehole named DH-02 to make it active.
Click on the I-Data tab, so that the I-Data table is displayed.

! Note how each row contains a top and bottom depth, and multiple columns of measurements. These values can represent mineral assays, pollutant concentrations, percent gravel, or any quantitative measurement taken over a depth interval. If a component has no measurement for that interval, it can be left blank.
Click on the borehole DH-04 in the list to the left, and you’ll see the information listed in its I-Data table.
There's no limit to the number of components for which you can enter measurements. Let's take a look.
Look at the project's I-Data Types:
1. Click on the I-Data Types button at the top of the I-Data listing. The program will display the current I-Data setup.
  
  This defines for each component type its name (required) and its min and max values. You can also enter comments regarding units and descriptive notes. The Order column determines the left-to-right order of the columns in the display. The Visible check-box allows you to turn on/off the column display.
  
  In your own work you can add components to the I-Data table (and columns to the Borehole Manager display) by clicking in the last shown row, pressing the down-arrow key, and defining these fields for the new measurement type.
2. Click on the Close button to close the window.
  
  ! You can also access the Interval (I-Data) Columns window via the Project Manager program tab: Expand the Project Tables | Types Tables heading, and double-click on the I-Data Types item.
Edit as Datasheet: Note that even though the data displayed in the I-Data tab looks like a spreadsheet, it is not. It's actually a rather complicated merging of many records stored in the borehole database's I-Data and I-Data Type tables. Because of this, you cannot select a block of cells like you can within a spreadsheet-type display, or copy/paste blocks of cells.
There is, however, a nifty tool in the Edit menu that makes editing this data quite easy.
1. Click on the Datasheet button at the top of the I-Data listing for the current borehole. (Or select the Edit | Edit Data as Datasheet menu option.)
2. The program will load the contents of the I-Data table, for the current borehole, into a row-and-column datasheet editor window. Here you can select blocks of cells, copy and paste from other applications, etc.
3. Close this window by clicking the X button, and respond Yes to the Cancel-all-changes prompt (if it is displayed).
Generate a Frequency Histogram of Benzene measurements, which will give us a quick look at the distribution of the data.
(Note that this requires the Standard license level.)
1. Back at the main program window, click on the I-Data menu at the top of the program window, and choose the Histogram option.
2. Enter the following:
  - I-Data Track: Click this tab and choose Benzene Soil.
  - Bin Colors: Click this tab and choose Continuous.
  - Peripherals: Check this box, and click on the tab.
    - Title: Check this option.
      - Primary Title: Type in: Benzene Soil Stats
      - Secondary Title: Click here and delete all text.
      - Use your mouse to adjust the placement of the Title in the diagram to the left.
      - Hold down the Shift key as you click and drag the lower-right corner of the green title to enlarge/reduce the size of the title space.
    - Title Block: Uncheck this.
    - Image: Unchecked.
  - Output Options
    - Display: Check this so that the diagram is displayed on completion.
    - Save: Unchecked.
    - Export: Unchecked.
3. Click the Continue button at the bottom of the window to proceed.
  RockWorks will read through all of the Benzene Soil measurements for all boreholes, compute the mean and standard deviation, and generate a frequency histogram plot. This diagram will be displayed in a RockPlot2D tab in the options window.
  
  Let's say we're interested in finding those boreholes with the anomalous high readings. We can use the Query tools, next.
4. Click the Windows Close button to close the I-Data Histogram window. Click No at the save-file prompt.
Query the Data: Let's use the basic query tool in RockWorks to enable only those boreholes that have Benzene Soil values > 75 ppm.
1. Back at the main Borehole Manager window, choose the View | Filter option. You'll see a window where there are number of data filtering options.
2. Surface Region: Uncheck this. We won't be filtering by borehole location.
3. Interval Data Values: Check this box in the column along the left.
  1. I-Data name: Click the down-arrow button and choose Benzene Soil.
  2. From: In this prompt, enter 75
  3. To: In this prompt, enter 999
4. All other Select By... options should be left un-checked.
5. Click Apply at the bottom of the window. You'll see a preview to the right, displaying in red those boreholes that contain Benzene Soil measurements ranging from 75 to 999, and all others in gray.
6. Click OK.

Back at the Borehole Manager, you'll most of the boreholes are now inactive - they are no longer shown with check-marks. Disabled boreholes will not be displayed in maps or log displays, and their data will not be included in any modeling.

! The View | Filter program uses an "AND" type of query, in which each of the boreholes for which every criterion is true will be enabled and the remaining boreholes will be disabled. The View | Select Boreholes option is more complex, allowing successive filters to be applied, and the enabling/disabling will apply only to the boreholes meeting the filter parameters, and no others. So, while the Filter tool works as an AND filter, the Select Boreholes tool can function as an AND or OR filter.

Entering I-Data

Back to I-Data menu | Next (3D logs)

RockWare home page