Boring Log Template Design Window

<< Click to Display Table of Contents >>

Navigation:  EnviroInsite > Boring Logs >

Boring Log Template Design Window

Downhole Groups and Visibility

 

Open the Tasks Pane on the right-hand side of the EnviroInsite interface, select Create Window and then select Boring Logs. A new view window is generated. Select Plot> Logs or Logs from Template and the Select Borings dialog box opens. Highlight the desired boring locations and click the => button to move the boring locations to the Selected pane. Click OK. The Boring Log Template Design window will open.

 

55132-EI_boring_log_temp

 

The Boring Log Template Design window is used to select the data fields to be plotted and to design the layout of the page. The fields are selected from the lists at the right of the window. Each of the lists are derived from a different table or field set. The table names highlighted in blue serve as section dividers and may not be added to a template design.

 

For EQuIS users, the source tables and fields are described in the help article, Tables and Fields used in Generating Full-Page Boring Logs.

 

For non-EQuIS users, the source data for each type of interval is as follows:
 

Header / Footer Data

Fields of Wells Table

Downhole Interval Data

Fields of Borings Table

Downhole / Point Data

Contents of Constituents Field in Point Values Table

 

Fields are added to the Boring Log Template Design window by double-clicking on the field name or by selecting a field and dragging and releasing it at the desired location on the template. Once placed on the Boring Log Template Design window, fields may be dragged using the mouse to the desired location.

 

Where present (e.g. Header/Footer Data | dt_drill_activity | Select drill_event), drop-down menus enable filtering data sources by selected values in the database (all facilities). To use this feature: select the drop-down menu and choose the desired value, then add related fields to the template. The field placeholder names that are added to the layout are prepended with the filter value (e.g. "hdr: INITIAL_drill_start_date" for the start_date of INITIAL drill event). Change the filter selection, then add related fields to the template again as desired. This enables including multiple records of the same field related to different events, e.g. data from multiple drill events may be grouped and displayed together. If no option is selected from the drop-down, the template will use a default record.

 

Multiple objects may be selected in the template by holding the SHIFT key and clicking the desired objects. The grouped objects may be moved around the template by again holding the SHIFT key, then clicking and dragging the group.

 

Selected objects may also be aligned with right-click> Align> Left or Bottom. The objects are aligned based on the placement of the blue object box that is displayed when an object is selected. The placement of the blue object box may be changed in the Alignment section of the Properties window.

 

When an object is selected in the Boring Log Template Design window, that object's properties are populated in the Properties window in the bottom-left corner. Double-clicking on a placed object in the Boring Log Template Design window opens a pop-up context-sensitive Properties window. The object properties can be modified in either the Properties window or the pop-up Properties window. Data fields added to the main body of the template will generate an associated title block for the data. This block and its text may be toggled off in the properties menu of the data object.

 

Downhole Groups and Visibility

 

In the properties of a Downhole Interval Data or Downhole / Point Data object, the visibility of an object may be turned off for the plotted boring logs without the need to remove the object from the template completely. Groups and group colors may also be assigned to organize data objects. If an object within a group has its visibility unchecked, any remaining contiguous group members will resize automatically to fill the space of the disabled object. Title blocks for each data object will similarly resize to stay in line with the data fields. If a group is unassigned, its group color will reset to black.

 

Visibility settings for Downhole Interval Data and Downhole / Point Data objects may be overridden using DT_FACILITY_PARAMETER codes from the table below and assigning “N” as their param_value. These PARAM_CODEs will first need to be added to RT_FACILITY_PARAM_TYPE with STATUS_FLAG=A. Please note that apart from the field not displaying in the boring log, there is no visual indicator within EnviroInsite that this override designation has been set in DT_FACILITY_PARAMETER.

 

User-defined parameters available from the Template Design window may also have their visibility toggled off by a PARAM_CODE using the data field name from the template. The convention is: “EI_{DATA NAME}_VISIBLE”. For example, DT_GEO_RESULT may have a RESULT_CODE called “Compaction_DryD” which shows up as “GeoTest Compaction_DryD” in the template. The corresponding PARAM_CODE in DT_FACILITY_PARAMETER is therefore “EI_GEOTEST_COMPACTION_DRYD_VISIBLE”. Note that spaces should be replaced by _ and the PARAM_CODE should be in all capital letters.

 

DT_FACILITY_PARAMETER

EnviroInsite Boring Log Template Designer Data

Default

 

EI_WELL_CONSTRUCTION_VISIBLE

Well Construction

EI_AXIS_VISIBLE

Axis

EI_ELEVATION_AXIS_VISIBLE

Elevation Axis

EI_SMPL_ID_VISIBLE

Smpl ID

EI_WATER_LEVEL_VISIBLE

Water Level

DT_LITHOLOGY

 

EI_REMARK_1_VISIBLE

remark_1

EI_REMARK_2_VISIBLE

remark_2

EI_MATERIAL_NAME_VISIBLE

material_name

EI_GEO_UNIT_CODE_1_VISIBLE

geo_unit_code_1

EI_GEO_UNIT_CODE_2_VISIBLE

geo_unit_code_2

EI_GEO_UNIT_CODE_3_VISIBLE

geo_unit_code_3

EI_GEO_UNIT_CODE_4_VISIBLE

geo_unit_code_4

EI_GEO_UNIT_CODE_5_VISIBLE

geo_unit_code_5

EI_MOISTURE_VISIBLE

moisture        

EI_PERMEABLE_VISIBLE

permeable

EI_COLOR_VISIBLE

color

EI_OBSERVATION_VISIBLE

observation

EI_GRAINSIZE_VISIBLE

grainsize

EI_ODOR_VISIBLE

odor

EI_CUSTOM_FIELD_1_VISIBLE

custom_field_1

EI_CUSTOM_FIELD_2_VISIBLE

custom_field_2

EI_CUSTOM_FIELD_3_VISIBLE

custom_field_3

EI_CUSTOM_FIELD_4_VISIBLE

custom_field_4

EI_CUSTOM_FIELD_5_VISIBLE

custom_field_5

DT_GEO_STANDARD_PENETRATION

 

EI_GEO_SPT_TYPE_VISIBLE

spt_type

EI_GEO_MAIN_BLOWS_1_VISIBLE

main_blows_1

EI_GEO_MAIN_BLOWS_2_VISIBLE

main_blows_2

EI_GEO_MAIN_BLOWS_3_VISIBLE

main_blows_3

EI_GEO_MAIN_BLOWS_4_VISIBLE

main_blows_4

EI_GEO_N_VALUE_VISIBLE

n_value

DT_GEO_CORING

 

EI_GEO_RECOVERY_PERCENT_VISIBLE

recovery_percent

EI_GEO_RQD_PERCENT_VISIBLE

rqd_percent

EI_GEO_RECOVERY_LENGTH_VISIBLE

recovery_length

EI_GEO_RQD_LENGTH_VISIBLE

rqd_length

 

Downhole field box widths may be resized by selecting the box and dragging the corner sizing rectangles.

 

A control bar at the bottom of the page enables you to zoom to the window extent, zoom to a window or pan within the page. Images, lines, text, and rectangles may be added to a log report by selecting the appropriate button on the control bar at the bottom of the page. When the boring log report design is complete, save the design to a template by selecting Template> Save or click OK to draw the boring log for the selected locations. Clicking the Select button opens a window to allow selection of locations. If no locations are selected, then all locations will be plotted.