Advanced Output Options and Site

Maps
gINT V8i Tutorial

DAA039560-1/0001
The information in this publication is subject to change without notice and does not
represent a commitment on the part of Bentley. The software described in this document
is furnished under a license agreement or nondisclosure agreement. The software must be
used or copied only in accordance with the terms of the agreement.

COPYRIGHT NOTICE

Copyright (c) 2011 Bentley Systems, Incorporated. All rights reserved.

Including software, file formats, and audiovisual displays; may only be used pursuant to
applicable software license agreement; contains confidential and proprietary information of
Bentley Systems, Incorporated and/or third parties which is protected by copyright and trade
secret law and may not be provided or otherwise made available without proper
authorization.

RESTRICTED RIGHTS LEGENDS

If this software is acquired for or on behalf of the United States of America, its agencies
and/or instrumentalities ("U.S. Government"), it is provided with restricted rights. This
software and accompanying documentation are "commercial computer software" and
"commercial computer software documentation," respectively, pursuant to 48 C.F.R. 12.212
and 227.7202, and "restricted computer software" pursuant to 48 C.F.R. 52.227-19(a), as
applicable. Use, modification, reproduction, release, performance, display or disclosure of this
software and accompanying documentation by the U.S. Government are subject to restrictions
as set forth in this Agreement and pursuant to 48 C.F.R. 12.212, 52.227-19, 227.7202, and
1852.227-86, as applicable. Contractor/Manufacturer is Bentley Systems, Incorporated, 685
Stockton Drive, Exton, PA 19341-0678.

Unpublished - rights reserved under the Copyright Laws of the United States and
International treaties.”

Bentley Systems Inc.

Corporate Headquarters
685 Stockton Drive
Exton, PA 19341, United States

Web Site: http://www.bentley.com/en-US/Products/gINT/

Sales and General Support: http://www.bentley.com/en-US/Corporate/Contact+Us/

—1—
Contents
Using this Tutorial ................................................................................................................................ 4
Setting up Sample Files ............................................................................................................................ 5
Advanced OUTPUT Features ............................................................................................................. 6
Exporting to PDF ........................................................................................................................................ 6
Separating into One PDF File per Borehole ........................................................................................ 8
Generating Bookmarks................................................................................................................................ 9
Exporting to DXF ......................................................................................................................................12
Exporting to Bitmap Graphics (JPG and BMP) ..............................................................................16
Filtering........................................................................................................................................................18
Standard Filters ........................................................................................................................................... 19
Range Filters ................................................................................................................................................. 21
Scripts ...........................................................................................................................................................23
Creating an Output Script ....................................................................................................................... 24
Script Editing ................................................................................................................................................ 26
User Input Parameters in Scripts ......................................................................................................... 28
Site Maps ................................................................................................................................................ 31
Importing a Site Map...............................................................................................................................31
Viewing Options........................................................................................................................................33
Customizing the PointID Markers......................................................................................................36
Using a Site Map to Navigate to Borehole Records .....................................................................38
Assigning Coordinates to Unplaced Boreholes using the Site Map.......................................41
Positioning New Boreholes on the Site Map ..................................................................................43
Using the Site Map to Select Boreholes at Output Time ............................................................45
Creating and Selecting Zones...............................................................................................................46
Printing a Site Map Report ...................................................................................................................49
Site Map Entities in Logs and Fences................................................................................................52
Fence Output Options ........................................................................................................................ 54
3-D Output of Fence Reports ...............................................................................................................54
Depth and Elevation Scales ..................................................................................................................55
Understanding Baselines.......................................................................................................................58
Creating a Custom Baseline ..................................................................................................................59
Using Min, Max and Scale ......................................................................................................................65
Using Alignments ................................................................................................................................ 70

—2—
 The Alignments Support Module (Tab) ...........................................................................................70
How to Store Baselines as Alignments.............................................................................................71
Drawing a Baseline/Alignment Interactively................................................................................72
Displaying a Scale along Alignments ................................................................................................74
Creating Alignments for Road Design ..............................................................................................76
Additional Points about Alignments .................................................................................................78
Appendix A -- Matching Scale and Origin in Imported Site Maps ....................................... 79
Appendix B -- DXF Import and Export ......................................................................................... 83
Configuring a Report for AutoCAD Export .....................................................................................84
Site Map Import/Export ........................................................................................................................85
Drawing Import/Export ........................................................................................................................85
Exporting ........................................................................................................................................................ 85
Importing ....................................................................................................................................................... 85
Appendix C -- Outputting a Fence Report of Evenly Spaced, Custom-Ordered Points 86

—3—
Using this Tutorial
This tutorial is designed for beginning and intermediate level gINT users, and is intended
for self-study. It covers the OUTPUT tab in detail, including an in-depth demonstration of
the various report applications, the process of exporting reports, and using scripts and
filters. It also shows how to use site maps in INPUT as a project GIS, and as something that
can be both printed in reports and used to control the set of boreholes output. The tutorial
employs some explanations, but mostly has you perform step-by-step instructions in gINT.

If you learn better with direction from an instructor, you might want to take the gINT
University course gINT 002 -- Advanced Output Options and Site Maps. The course takes two
hours, performed over the internet with a live instructor, and parallels the material in this
tutorial. Other instructional options include gINT Summit Trainings at your site or in
various cities. For training options involving instructors, see
www.gintsoftware.com/support_training.html.

You should be familiar with gINT data entry and basic output (including preview and
printing, and the zoom tools) before working through this tutorial. We recommend you
work through the Performing Data Entry tutorial or take the gINT University class gINT 001
- Introduction to gINT: Data Entry and Basic Output if you do not have that familiarity.

—4—
Setting up Sample Files

Before starting the tutorial, you need the following:

• gINT Version 8 installed on your computer

• Sample files installed in the appropriate subfolders of the \gINT\ installation folder
(usually C:\Program Files\gINT\)
To obtain and install the sample files, do the following:
1. Go to www.gintsoftware.com/support_doc.html.
2. Click on the link ‘Standard Data Files for All gINT Tutorials’.
3. Extract the following files to the indicated locations:

File Destination

training.glb \gINT\libraries\

training.gpj \gINT\projects\

site map.dxf \gINT\auxiliary files\

site map 2.dxf \gINT\auxiliary files\

 Note: If these files are already present in the indicated locations because of working
on another tutorial, you do not need to replace them.

—5—
Advanced OUTPUT Features
In this section, we will discuss some advanced features of the OUTPUT tab, including the
process of exporting reports to various file formats and the use of scripts and filters.

Exporting to PDF

A useful feature in OUTPUT is the ability to generate a PDF file from an output run. Note
that the gINT PDF export facility does not use the Adobe Acrobat drivers; it uses drivers
that are built into gINT. So you don’t need Adobe’s software to generate PDF’s.

Let’s export a multi-borehole log report to a PDF file.

1. Select the Logs tab in OUTPUT.
2. Ensure that the training.glb library is active (File  Change Library) and the
current project is training.gpj (click the Browse button in Source File and browse
to the project).
3. Select ‘ENVIRONMENTAL BH’ in the object selector drop-down list in the toolbar.

4. Click the Browse button to the right of Borehole ID and highlight, by Ctrl-
clicking, boreholes ‘B-1’, ‘B-2’, ‘B-3’. and ‘TP-1’ in the borehole selection list. Click
OK.

5. Click the Browse button to the right of Export to File.

6. In the Export to File dialog box, specify a path of \gINT\drawings, a file type of
‘Adobe Portable Document Format *.pdf’, and a filename of ‘environmental-bh.pdf’.

—6—
7. Click Save. The path and filename appear in the Export to File box. Notice that
additional options have appeared. These relate to generating PDF files.

8. Check the View Document After Export box. This causes Acrobat Reader to open
automatically at the end of the export process.
9. Click the Export button. A PDF file will be generated, and will open in Acrobat.

—7—
 10. Scroll down through the file. Notice that several borehole logs are included.
11. Close the Adobe Acrobat window.

Separating into One PDF File per Borehole

Instead of printing all boreholes to a single PDF file, you can automatically separate them
into one PDF file per borehole.

1. Select the Each Dataset to Individual File radio button.

Notice that the displayed options have changed.

—8—
 2. Check View Document After Export.
3. Leave the defaults in the other fields. A file path has already been specified (in the
Export to File box). The File Name Expression is optional; if left blank each PDF will
be named after its borehole. Click Export.

Multiple PDF files are generated and opened in Acrobat.

4. Close the PDF files.

5. If you were to open the \drawings folder in Windows Explorer, you would see one
PDF file for each borehole (in addition to the multiple-borehole file, environmental-
bh.pdf, that we generated earlier.

Generating Bookmarks
Another useful PDF export feature is the ability to generate bookmarks. Bookmarks enable
you to navigate a PDF file using a Windows-Explorer-like tree interface. gINT enables you
to directly define bookmark nodes, as well as to automatically generate bookmarks to the
start of each log.

1. Select the All Datasets to the Same File radio button.

—9—
2. Click the Browse button to the right of Bookmark Path. The ‘Specify Bookmark
Location and Type’ dialog box opens.

The ROOT is the base level in the bookmark hierarchy. We will add a child
bookmark under which each log bookmark will be inserted.

3. Right-click on the word ROOT and select Insert Child.

4. Rename the child node ‘Logs’.

— 10 —
5. Click OK.
6. Click the Type drop-down arrow and select ‘Child Bookmarks’.

 Note: We could have instead selected the ‘Child Bookmarks’ option for
Bookmark Type in the ‘Specify Bookmark Location and Type’ dialog box.
7. Click Export. At the ‘Append Or Overwrite’ prompt, click Overwrite.

A PDF file is generated and opened in Acrobat.

8. Click the Expand (+) symbol to the left of ‘Logs’. The list of boreholes appears.

— 11 —
 If you click on any borehole bookmark, the display changes to show that borehole in
the PDF file.

 Note: Exports can be appended to existing PDF files and the bookmarks of
the original file and the new export will be maintained.
 For further study, select the Help  Index  Adobe Acrobat Portable Document
Files topic.

Exporting to DXF

The process of exporting to an AutoCAD DXF file from OUTPUT is very similar to creating a
PDF. Export to DXF is very useful, especially for fences, since the exported DXF file can be
opened and edited in AutoCAD (or other software capable of working with DXF files). Note
that Microstation .DGN files are not supported in gINT, but Microstation users can use
AutoCAD DXF files for the same functionality.

Do the following:

1. Go to OUTPUT and select the Fences tab.

— 12 —
2. Ensure that the training.glb library is active (File  Change Library) and the
current project is training.gpj (click the Browse button in Source File and browse
to the project).
3. Select ‘STRATIGRAPHY & GW - A SIZE’ in the object selector drop-down list in the
toolbar.

4. Choose the boreholes to output using the Browse button to the right of the Borehole
ID text box.

5. Select B-1, B-2, and B-3 by Shift-clicking.

6. Click the Browse button to the right of the Export To File text box.

— 13 —
 A file browser window appears.

7. Specify a path of \drawings, an output type (Save As Type) of ‘ACad DXF’, and a
filename of ‘stratigraphy-gw.dxf’.

8. Click Save.
9. Click the Export button to generate the DXF file.

10. Click OK in the User Report Variables window. We’re skipping this feature.
11. If you have AutoCAD or a suitable DXF viewer on your computer, double-click on the
DXF filename in Windows Explorer to open it. Here is what the file looks like in a
DXF viewer:

— 14 —
12. In the AutoCAD or viewer software, bring up the list of layers. You should see a
Layer 0, which contains all non-borehole data (such as border, title block and axis
labels) and one numbered layer for each borehole.
13. In gINT, select File  System Properties and click the DXF Files tab.

— 15 —
 Notice that there are several options enabling you to customize the output format of
exported DXF files.

14. Close the SYSTEM PROPERTIES window.

 For further study, see Help  Index  DXF Files.

Exporting to Bitmap Graphics (JPG and BMP)

Reports can be output to standard bitmap graphic formats such as JPEG and Windows
Bitmap (BMP). One bitmap file is generated for each page of output, numbered
consecutively. Resolution can be specified, and an option is provided for automatically
cropping each bitmap to the edges of the graphic image.

Perform the following steps:

1. Go to OUTPUT  Logs.
2. Select the ‘ENVIRONMENTAL BH’ report in the object selector if not already
selected.

3. Click the Browse button to the right of Export to File.

4. In the EXPORT TO FILE dialog box, select ‘Windows Bitmap (*.bmp)’ in the Save As
Type selection list.
5. Navigate to \gINT\drawings\ using the Save In drop-down if this is not already the
destination folder.

— 16 —
6. For File Name, enter ‘env bh’, and click Save. Notice that the set of options under
Export To File changes:

7. Ensure that Resolution (DPI) is set to ‘100’ (a larger value creates unnecessarily
large files for most uses), Color Depth is set to ‘True Color (24 Bit)’, and Crop is
checked.
8. Click the Export button. A progress dialog box appears until the export is finished.
9. Using Windows Explorer, navigate to \gINT\drawings\. Notice that multiple BMP
files have been created, named env bh1.bmp, env bh2.bmp, and so on.
10. Double-click on env bh1.bmp to open it with Windows Paint or another default
BMP editor.

— 17 —
 Notice that this is a bitmap graphic of the specified report page at the specified
resolution.

11. Close the bitmap editor program.

Filtering

All reports can be filtered to include only specific boreholes using various techniques, alone
or in combination:

• By selecting the boreholes from a list

• By defining and selecting one or more “zones” in the site map.

• By setting a standard filter query, such as ‘auger holes by AAAAA Construction

completed after 11/1/2007’.
The data in certain report types—graphs, histograms, graphic tables and text tables—can
be filtered at a lower level than entire boreholes, such as by specific stratigraphic units or

— 18 —
sample types, using range filters. This is an advanced topic not covered in this course.

 For information on range filters, see Help  Index  Range Filter.

Standard Filters
A standard filter (or filter, for short) limits the output to items meeting the specified
criteria.

In log and fence reports, you can only filter on borehole-level fields, that is, fields in the
POINT table or tables with which it has a one-to-one relationship (such as WELL DETAILS).
When you filter the set of boreholes for a log report, the filter limits which boreholes will
have logs created in the output. When you filter the set of boreholes for a fence report, it
limits the set of fenceposts that appear.

We’ll experiment with creating filters in the filter specification grid. Do the following:
1. Go to INPUT  Borehole. In the ‘TP-1’ row, enter a North value of ‘324’ and an East
value of ‘213’. This is so ‘TP-1’ will appear with the other points on the fence
reports.
2. Go to OUTPUT  Fences. Notice the filter specification grid in the bottom section of
the tab.

 Note: gINT uses the same syntax for filter grid expressions as Microsoft
Access.

3. Click Preview . Click OK in the User Report Variables window to skip entry of a
report name. With all five boreholes appearing, the fence report looks like this:

— 19 —
 From left to right, the boreholes are ‘B-1’, ‘B-2’, ‘TP-1’, ‘B-3’ and ‘CPT-1’.

4. Now let’s see only boreholes that were completed after Nov. 23rd. Click in the Field
column in the first row.
5. Select ‘POINT’ for Table and ‘Date Completed’ for Field in the pair of selection lists
beneath the word ‘FILTER’. This pair of drop-down lists is called the Data Tool.
6. Click the Paste button. ‘[POINT].[Date Completed]’ appears in the row 1, column 1
cell.
7. Click in the row 2, column 1 cell. Enter ‘ >"11/23/2007" ’, as shown:

8. Preview the report. Only the ‘B-3’, ‘TP-1’ and ‘CPT-1’ boreholes appear. Close the
preview.

Multiple fields can be used to create a compound filter expression. Each additional
field’s name goes in the Field row in its own column, and values are placed in
Criteria and Or rows as follows:

• If criteria values are in the same row as one another, they are AND’ed, that is, the

— 20 —
 compound condition is true only if both conditions are true.
• If criteria values are in different rows, they are OR’ed, that is, the compound
condition is true if either or both conditions are true.
9. Click in the row 1, column 2 cell. Select a Field of ‘PointID’ in the Data Tool and click
Paste.
10. In row 2, column 2, enter “ Like 'B-*' ”, as shown:

It is important to include the asterisk after the string you wish to match. “ Like 'B-' ”
will only locate boreholes named ‘B-’; “ Like 'B-*' ” locates boreholes whose names
start with ‘B-’.

11. Preview the report. Notice that only the ‘B-3’ borehole appears. This is because the
completion date restriction and the borehole name restriction have been “and-ed”,
with the result that the only boreholes to output are those that simultaneously were
completed after November 23 (‘B-3’, ‘TP-1’ and ‘CPT-1’) and have names that start
with ‘B-’. The only borehole that meets the combined condition is ‘B-3’.
12. Close the preview. Remove the “ Like 'B-*' ” condition from row 2, column 2, and re-
enter it in row 3, column 2, as shown:

13. Preview the report. Notice that all five boreholes have reappeared. This is because
the two conditions are ‘OR-ed’ because of being on different rows. The resulting
compound condition outputs boreholes that were completed after November 23 (‘B-
3’, ‘TP-1’ and ‘CPT-1’), or have names that start with ‘B-’, or both. The only boreholes
that would be excluded would be ones that meet neither condition.
14. Close the preview, and clear the filter criteria (by clicking the empty light blue
square at upper left in the filter grid, then pressing Delete.

Range Filters
Whereas a standard filter enables you to specify a set of boreholes to output, a range filter
enables you to screen for records at a lower level in the table hierarchy. They also provide a
useful querying feature that lets you find items within particular depth ranges, hence the
name. For example, you may want to see data from SAMPLE records with depths between
10 and 20 feet, or test records for all specimens from a particular lithology layer.

— 21 —
1. Go to INPUT. Click the List icon.
2. In the PROJECT DATA TABLES dialog box, uncheck the Hide checkbox for the
TESTS table, and click OK.
3. Click the Tests tab to view the contents of the TESTS table. Note that for a particular
borehole (specified in the object selector) there is a set of records containing test
values, one record at each of several depths.
4. Go to OUTPUT  Text Tables. Select ‘TEST SUMMARY’ in the object selector if not
already selected.
5. Preview the report and zoom in on the text. Notice that 15 records appear, five each
for each of three boreholes. Close the preview.
6. We would like to only see test data from lithology layers with clay soils (USCS code
of ‘CL’). Enter the following query specifications, using the Data Tool beneath Filters.

Field Value

Range Top Field [LITHOLOGY].[Depth]

Range Bottom Field [LITHOLOGY].[Bottom]

Include Top/Bottom Top

Criterion Field [LITHOLOGY].[USCS]

Criteria ='CL'

7. Preview the report and zoom in on the data. Notice that only six records appear, all
of them at depths of 10 or 14 feet. (There are two clay layers in our sample data,
from 10 to 13 feet and from 13.5 to 15 feet.)
8. Close the preview.
9. We would like to see if any tests in the clay layers indicated unstable soil, as shown
by a liquid limit higher than 50. In the standard filter grid (to the left of the range
filter grid), enter the following:

— 22 —
 Field Value

Field [TESTS].[Liquid Limit]

Criteria >50

10. Preview the report, and zoom in. Notice that only one record appears, and it has a
liquid limit value of 51. Any conditions you specify in the standard filter grid are
“AND-ed” with those in the range filter grid.
11. Close the preview, change the Criteria setting in the standard filter to ‘>40’, and
preview and zoom again. Now there are two records, one with a liquid limit of 51 in
‘B-1’, and one with 47 in ‘B-2’. Close the preview.
12. You can save and retrieve range filters. Click the Save button above the range filter
grid, and enter a Name of ‘CLAY SOILS’, then click OK. Click the drop-down arrow
under Stored Range Filters. Notice that the range filter ‘CLAY SOILS’ appears in the
list. You can open this range filter again at a later time by selecting it from this drop-
down list.

Scripts

gINT provides the ability to perform batch output of reports using the Scripts facility. This
enables you to print multiple reports or export them to a graphic format, with predefined
output settings (such as which project, library and report form to use, which boreholes to
include, filter settings, and so on). For example, you might have a project that has borehole
and test pit logs, a number of fences, graphs, histograms, and tables. Through the course of
the project you might make draft output runs to check the data. When you are ready for the
final output, instead of manually outputting the reports one at a time, you can run them all
unattended by executing a single script.

In addition to batch output of reports, scripts can also perform batch data import and
export operations, utilities such as library merge/copy, and output of symbol library
printouts.

A script is a series of instructions in a text file with a specific syntax, but you can also
generate a script by capturing the current output settings, without the need to edit it. When
you are ready to run a script, you invoke it from the Script toolbar icon. Script files have a
.GSC filename extension, and are typically stored in your \gINT\scripts folder. The
following is a portion of a script file, displayed in Notepad.

— 23 —
Creating an Output Script
Let’s create an output script that exports to PDF and one that prints. Then we’ll merge the
two into a single script that performs both actions. Perform the following steps:
1. Go to OUTPUT  Logs.
2. Ensure that the current library is training.glb and the current project (in the
Source File field) is training.gpj.
3. Select the ‘GENERAL BH / TP / WELL’ report in the object selector.
4. Click the Browse button on the Borehole ID field, select (by Shift-clicking) points
‘B-1’, ‘B-2’, ‘B-3’ and ‘TP-1’, and click OK.
5. Click the Browse button on the Export To File box. Specify a file type (Save As
Type) of ‘Adobe Portable Document Format *.PDF’ and a file name of ‘four points
log.pdf’. Click Save.

6. Click the Script icon and select Write Script. The WRITE COMMAND SCRIPT
dialog box appears.

— 24 —
7. Click the Browse button on the Script File field. This specifies the output path and
filename. Use the default path (this is set in System Properties and is probably
\gINT\scripts) and enter a filename of ‘four points log.gsc’. Click Save.
8. In the Command drop-down list, select Export. This specifies the output action to
take when the script runs.
9. Check the Set Library checkbox. This sets a library name property in the script to
the name and path of the library in use when the script was created.
10. Click OK. This saves the script and closes the dialog box.

11. To run the script, click the Script icon and select Execute Script. The EXECUTE
COMMAND SCRIPT dialog box appears.

12. In the Script File box, select ‘four points log.gsc’, and set the Run Option to ‘Execute
Script’. Click OK. The script executes.
13. Using Windows Explorer, locate the ‘four points log.pdf’ file in \gint\drawings and
double-click on it. The exported PDF file with the specified points appears.

— 25 —
 14. Close the Acrobat window.

Script Editing
We’ve seen how to create a script to export one report. Let’s look at the contents of the
script file we created. Then we’ll add a second role to the same script—printing the same
report to a printer.

1. Click the Script icon and select Edit Script. Select ‘four points log.gsc’ and click
Open. The script file opens in Wordpad.

— 26 —
2. Notice the following points about the script’s contents:
• Two ‘Operation’ sections appear, the first to specify the library, the second to
specify that the subsequent commands are for an OUTPUT script operation (it
could instead have been an INPUT or LIB OBJECT operation).
• The ‘Command’ section specifies EXPORT (the other possibilities would be
PRINT or PREVIEW).
• The ‘Properties’ section specifies that the report type is ‘Log’ and the report form
to use is ‘GENERAL BH / TP / WELL’.
• The ‘Spec’ section includes various property settings that were active in the
OUTPUT tab when the script was created. This includes the project name, the
selected boreholes, the path and filename for the PDF file to generate, and
miscellaneous PDF settings.
3. Close the Wordpad window.
4. Select the ‘ENVIRONMENTAL BH’ report in the object selector.
5. Click the Browse button for Borehole ID and select only boreholes ‘B-1’, ‘B-2’ and
‘B-3’. Click OK.

6. Click the Script icon and select Write Script.

7. Leave the Script File setting the same—‘four points log.gsc’. We will append to this
file.
8. Change the Command setting to PRINT. Click OK. You are prompted to append or
overwrite, since you have specified an existing script file.

— 27 —
 9. Click Append.

10. Click the Script icon and select Edit Script.

11. Open the ‘four points log.gsc’ script.
12. Notice the additional sections in the file, which specify a new output action. This is
to print (rather than export) a different report, using a smaller set of boreholes.
You can continue to add operations to a single script in this fashion. For example, you could
create a script to print all of your reports, or to print, export to DXF and export to PDF each
of three reports. To start a new script rather than add to an existing one, specify a new
name in the Script File field in the WRITE COMMAND SCRIPT dialog box.

You can also use a text editor such as Wordpad to make changes manually inside the script
file. With an editor you can take advantages of features such as search-and-replace, which
you could use to replace all instances of the current project name with a different one, for
example.

 For further study, select Help  Index  Scripts.

User Input Parameters in Scripts

By adding special expressions to a script file, you can prompt the user for selection of files
and entry of other values when the script is run, and use these input values to alter the
script’s operation. To see an example of this, do the following:

1. Click the Script icon and select Write Script.

2. Click the browse button on the Script File field, specify the name ‘user prompt
PDF.gsc’, and click Save.
3. Specify a Command value of ‘Export’. Click OK to generate the script file.

4. Click the Script icon and select Edit Script.

5. Select ‘user prompt PDF.gsc’ and click Open. Wordpad opens with the script
displayed.

— 28 —
6. Enter the following at the top of the file, just beneath the command script date and
time:
**Parameters
PDF File Name=**FileGeneral

This creates a new section that defines a user prompt for entry of the PDF filename.
The ‘PDF File Name’ portion of the expression defines both the variable name that
can be used later in the script, and the text that will appear when the user is
prompted.

— 29 —
 7. Scroll down in the file to the ‘**Spec’ section, and locate the ‘ExportFile=’
expression. Replace the ‘ExportFile=’ line with the following:
ExportFile=<<Get(PDF File Name)>>

Instead of a hard-coded PDF file path and filename in the script, you are obtaining
the path and file of the export file from the user’s entry.

8. Save the script and close the Wordpad window.

9. Click the Script icon and select Execute Script.

10. Select a Script File of ‘user prompt PDF.gsc’, and click OK to run the script. A
prompt window appears:

11. Browse to \gINT\drawings, specify a filename of ‘user prompt.pdf’ (be sure to

include ‘.pdf’).
12. Click Open, and when prompted as to whether or not to create the new file, answer
‘Yes’.
13. Click OK to close the SUPPLY VALUES window and generate the PDF file.
14. Use Windows Explorer to navigate to \gINT\drawings and open the ‘user
prompt.pdf’ file. Notice that it contains your log report. Close the Acrobat window.
You can prompt the user for a wide range of parameters, such as a list of boreholes, a
project file to use, the report name, and so on. You can have as many parameters as desired,
but the Parameters section must be above the lines where the parameters are referenced in
the script. For documentation purposes, it is best to put the Parameters section at the top
of the script file.

 For further study, select the Help  Contents  How to Guide  Command Scripts 
User Input Parameters topic.

— 30 —
Site Maps
A site map can be imported into a project in INPUT and stored with that project. This is
generally a DXF or HPGL file created in AutoCAD or some other CAD application, or can be
created in the DRAWINGS application group.

A project’s site map can be used in several different ways in gINT:

• To navigate to borehole data for data entry by selecting boreholes plotted on the site
map.
• To visually group together boreholes into zones, which can be used for filtering the
set of boreholes to appear on a report
• To select boreholes to print by highlighting them on the site map.
• To lay out a drilling program by placing borehole locations on the site map, and
subsequently performing data entry into the generated POINT records.
• To print the site map, including some or all of the contained points, as a site map
report or incorporated in another report such as a log, fence, or graph.
• To display the site map at the top or bottom of a 3-D fence report, showing the
locations of the fenceposts relative to geographical features.
• To visually specify a baseline for a fence report.
We will demonstrate all but the last two of these uses in this section (the others will be
covered in the Fence Report Output section).

Importing a Site Map

A project does not have a site map until you import it into INPUT, and the site map is
subsequently saved with that project. A project with a site map displays the Site Map tab in
the first row of secondary tabs. Clicking on this tab then brings up the site map view of the
project. We will import a site map in DXF format into the training.gpj project.
1. Ensure that the current project is training.gpj.
2. Go to INPUT  Borehole. Delete the North and East values from the ‘TP-1’ row.
This is so we can demonstrate a site map feature later on.
3. If the Site Map tab is not already visible, select Additional Modules  Site Map
Support. This places a checkmark next to the menu option, indicating that site map
support is active. It makes the Site Map tab appear (and the project tables are
placed in a tab bar beneath a Main group tab).

— 31 —
  Note: Un-checking the Site Map Support option causes the site map to be
deleted from the project.
4. Click the Site Map tab. Notice that point markers appear corresponding to all
borehole records with both East and North coordinates.

5. Select File  Import/Export  DXF Import. You see the Import DXF File dialog box.
6. Select ‘ACad *.dxf’ in the Files of Type drop-down list.
7. Navigate to site map.dxf, located in \gINT\auxiliary files\, and click Open. The
imported file is displayed, with the borehole indicators overlaid:

— 32 —
 8. Notice that borehole ‘TP-1’ does not appear. This is because it lacks East and North
coordinates.
If the coordinates used to draw the site map do not match the coordinate system you are
using for your boreholes, the borehole points will not be placed in correct locations relative
to the drawing. In this circumstance you must remove the site map from the project
(deselect Additional Modules  Site Map Support), and adjust the scale and origin of the
site map drawing before re-importing. This can be accomplished in a CAD program or by
importing into DRAWINGS  General Drawings and making edits there. See “Appendix A
-- Matching Scale and Origin in Imported Site Maps.”

Viewing Options

When in site map view, you can do the following to change viewing options:

• Use zooming and panning tools, the same as in report preview.

• Display or hide drawing layers, if present.
• Turn on and off the display of the borehole ID adjacent to point markers.
• Change the size of the point marker symbols.

— 33 —
 • Show different symbols for different borehole types or other data.
To hide and display drawing layers, do the following:

1. Click the Layer Properties icon on the right side of the toolbar. The LAYER
PROPERTIES window appears.

2. Check the Hide checkbox in the row for the ‘STREETS’ layer. Click OK.
3. Notice that the streets (magenta lines) have disappeared from the site map.
4. Click the Layer Properties icon again, uncheck the Hide checkbox, and click OK. The
‘STREETS’ layer returns to view.

To turn off and on the display of borehole ID’s, do the following:

1. Select the Site Map  PointID Display menu.

2. Notice that the PointID Text option is either checked or unchecked.

— 34 —
 3. Click the option, which changes from checked to unchecked or vice versa. When
checked, the PointID text appears above each marker circle.

4. Select Site Map  PointID Display again and ensure that PointID Text is checked.

To change the size of the borehole marker symbols and text, do the following:

1. Select Site Map  PointID Display  PointID Circle Height. The POINTID CIRCLE
HEIGHT dialog box appears:

2. Change the Circle Height value to ‘0.05’ and click OK. The marker circles and text
become half their previous size.
3. Select Site Map  PointID Display  PointID Circle Height and change the value
to ‘0.2’, then click OK. The marker circles and text become twice their original size.
4. Select Site Map  PointID Display  PointID Circle Height and change the value
to ‘0.1’, then click OK. This restores the original size.

— 35 —
 5. Click the Zoom In icon three times. Notice that each time the site map features
are enlarged, but the borehole marker circle and text are unchanged in size. Click
the Zoom Out icon three times to restore the original view, and notice that the
circle and text height remain unchanged.

The Circle Height measurement is in screen units, and is unrelated to the site map’s
measurement units.

Customizing the PointID Markers

If your boreholes fall into different classifications, you can set a PointID marker expression
to define the borehole markers for each classification. For example, you can write an
expression that says if the hole is a test pit, use a triangle for the marker. To see the list of
available markers, refer to the “Graphic Symbols” appendix, or go to UTILITIES  Print
Object Lists  Data Markers and generate a PDF or printout.

To set a PointID marker expression:

1. Select the Site Map  PointID Display  Site Map PointID Marker Expression menu
option. You see the SITE MAP POINTID MARKER EXPRESSION dialog box:

2. Enter the value ‘TP_MARKER’, and click OK. Notice that the circles have changed to
filled squares.

Instead of assigning a single symbol to all types of boreholes, we want an expression

that assigns different symbols depending on borehole type, as indicated in the
PointID field. We will assign triangles (the BH_MARKER symbol) to boreholes
(points beginning in ‘B-’), squares (TP_MARKER) to test pits (‘TP-’), and diamonds
(CPT_MARKER) to cone penetrometer holes (‘CPT-’). For point ID’s starting in
anything else, we will default to filled circles (DEFAULT_MARKER).

The expression could be entered directly, but instead we have created a User System
Data item for the purpose.

— 36 —
3. Select Site Map  PointID Display  Site Map PointID Marker Expression.
4. Using the left half of the Data Tool, select ‘User System Data’ for Table and ‘Site Map
PointID Marker’ for Field, then click Paste. The following should appear:
<<User System Data.Site Map PointID Marker>>

5. Click OK. You should see the following (you may have to exit Site Map view and
return):

Notice that the ‘B-’ boreholes now have triangle symbols and ‘CPT-1’ has a filled
diamond.

6. To see the expression for determining the marker symbol, close the site map (click
the Input tab), go to DATA DESIGN  User System Data, and select ‘Site Map
PointID Marker’ in the object selector. You see the following expression.
<<Switch(<<Like(<<POINT.PointID>>,"B-*")>>,BH_MARKER,_
<<Like(<<POINT.PointID>>,"TP*")>>,TP_MARKER,_
<<Like(<<POINT.PointID>>,"CPT*")>>,CPT_MARKER,_
True,DEFAULT_MARKER _
)>>

The Switch() function is similar to IF-THEN-ELSE or CASE in some programming

languages—if like the first clause, choose the first result, if like the second, choose
the second, and so on. The final line, ‘True, DEFAULT_MARKER’ specifies the symbol
to use (a filled circle) if none of the other conditions apply.

To change the criteria for site map marker symbol selection, edit this user data item.
Note that you can use any POINT table fields in your decision logic—for example,
you could set marker symbols based on the contractor or hole size or depth.

— 37 —
 In the following illustration, values of methane concentration in the data are used to
determine which marker symbol, and what text, appear for each point.

 Source: Evaluating Cleanup at Hamilton Army Airfield Using EQuIS and ArcGIS, by
S.D. Weaver and B.A. Call. See
http://www.gintsoftware.com/assets/gint_articles_industry_evaluating_cleanup.pdf
.

Using a Site Map to Navigate to Borehole Records

You can select boreholes plotted on the site map to navigate to their borehole data for data
entry.

1. Go to INPUT  Site Map.

2. Select the Site Map  PointID Project Data menu option.
3. Click inside the red triangle marker beneath borehole ‘B-1’. The Available Tables
dialog box appears.

— 38 —
 4. Select the LITHOLOGY table and click OK to view the lithology data for borehole ‘B-
1’:

Notice that you can’t edit data from within the site map using this option, with the
exception of POINT table (borehole) data. Subordinate tables can only be viewed,
printed or exported, but not edited.

5. Click the Close button.

6. On the Available Tables dialog, click Cancel.

To edit POINT table data, do the following:

1. Select Site Map  PointID Properties. The ‘Select Entity’ prompt appears.
2. Click inside the red marker triangle underneath B-2. The Properties for B-2 dialog
box appears.

— 39 —
  Note: You can also invoke this dialog box without using the menus by
double-clicking inside the marker.
3. Click OK to close the dialog box. We could edit data in the borehole record here if
desired, but will leave the existing values.

Another option on the Site Map menu allows you to go to a specific borehole.

1. Using the Quick Zoom tool, zoom in on borehole ‘CPT-1’.

2. Select Site Map  Go to PointID. You see a list of borehole ID’s to select from:

3. Select ‘B-2’ then click OK. The scale remains the same but the program shifts the site
map drawing so the selected borehole is centered on the screen.

— 40 —
Assigning Coordinates to Unplaced Boreholes using the Site Map

You can assign East-North coordinates in Site Map view to points in your project that
currently lack them. In training.gpj there is one such point: ‘TP-1’. In practice, you may
have several points whose other data was entered before the locations were known. To
demonstrate this feature, do the following:

1. Click the Zoom Out icon once to view more of the site map.
2. Select Site Map  PointID Display  Coordinate Decimal Places with Mouse.
This enables you to set the number of decimal places returned for coordinates you
set by clicking on the site map.

3. Enter ‘1’ and click OK.

4. Select Site Map  Assign PointID Coordinates. A dialog box displays all boreholes
without coordinates:

5. Click on ‘TP-1’ to highlight it. Click OK, and click on the site map where you want to
locate it. (Position it midway horizontally between points ‘B-1’ and ‘B-2’, vertically
just south of the bend in the road.) The borehole appears.

— 41 —
6. The coordinates you specified are entered in its POINT table record. Double-click
inside TP-1’s square symbol. The data for borehole ‘TP-1’ is displayed:

Notice that new North and East values appear, with decimal precision of one
decimal place.

7. Click OK to close the dialog box.

— 42 —
Positioning New Boreholes on the Site Map

You can use a site map to position new boreholes interactively on the site map diagram.
You can then close the site map and work with the new boreholes in grid data entry in
INPUT. Do the following.
1. Select Site Map  New PointID. The ‘PointID Location’ prompt appears.
2. Click in the site map inside the left edge of the field that is south of the tank farm.
This will place your first borehole.

3. Enter a Borehole Number of ‘BH-1’ and a Total Depth of 40. Click OK. The new
point is displayed at the coordinates where you clicked.
4. Select Site Map  New PointID. The ‘PointID Location’ prompt appears.
5. Enter the values ’92,305’ in the coordinates box at lower left, and press Enter. The
New PointID dialog box appears, with the specified coordinates for East and North.
6. Enter a Borehole Number of ‘BH-2’ and a Total Depth of 35. Click OK. The second
borehole appears on the site map.

— 43 —
 7. Click the Input tab to close the Site Map view, and click the Borehole tab. The two
new boreholes are displayed in the data entry grid.

You could then proceed to enter data in the other POINT table fields and other
tables. We do not need these two points, however.

8. Highlight the ‘BH-1’ and ‘BH-2’ rows (by Shift-clicking in the blue squares to their
left) and press Delete, then click the Save icon.

 Note: You can also add boreholes in the site map view by placing the cursor over a
borehole, holding down the CTRL key and clicking and dragging the mouse to a new
location. The program automatically numbers the borehole with the next sequential
number.

— 44 —
Using the Site Map to Select Boreholes at Output Time

In most report types, you can use the project’s site map to interactively select the set of
points to output. Do the following:

1. Go to OUTPUT  Fences.
2. Click on the Site Layout button. You see a view that is similar to the INPUT Site Map
application, but with fewer menu options and no drawing tools.

3. Click twice on the site map, once to place the upper right corner of a selection
rectangle and once to place the lower left, surrounding the ‘B-1’, ‘B-2’ and ‘B-3’
boreholes. Notice that their markers and labels turn green, indicating that they are
selected.
4. Click on the marker of the ‘CPT-1’ point. Notice that it turns green also.
5. Click again on the marker of the ‘CPT-1’ point. It changes back to red, indicating that
it is no longer selected.
6. Click the OK button at lower right, then the Return to Output tab. Notice that the
‘B-1’, ‘B-2’ and ‘B-3’ boreholes are selected for output in the Borehole Number
field.

— 45 —
Especially in complex projects with many boreholes, this can be a useful way to select a
subset of them for report output.

Creating and Selecting Zones

The Zones feature provides the means to draw boundaries around regions of the site map,
then select one or more of these regions for output. Zones are useful for delimiting
geographical areas, manmade subdivisions, geologic zones, or other areas of the site that
may need to be looked at separately.

1. Go to INPUT  Site Map.

2. Click once or twice on the Zoom In icon to show boundaries of the tank farm more
clearly.
3. Select Site Map  Zones  New Zone.

4. Enter ‘TANK FARM’, then click OK.

5. By clicking on successive corner points, outline the boundary of the tank farm. To
close the polygon, double-click on the final point instead of single-clicking. The
region you outlined appears with a broken line border, and the ZONE PROPERTIES
dialog appears.
6. Enter the following in the Name tab:

Field Value

Line Type Dash

Thickness 5

Line Color Very Light Red

7. Click the Name Display tab. Enter the following:

— 46 —
 Field Value

Show Name checked

Height 20

Color Very Light Red

8. Click OK. Click Preview . The site map preview appears, with the ‘TANK FARM’
zone outlined with a red dashed line, and a red label appearing in the center.

9. Close the preview.

10. Zoom out and pan to show the area between the tank farm and the bottom of the
site map.
11. Select Site Map  Zones  New Zone. Enter a name of ‘SOUTH SUBDIVISION’ and
click OK.
12. Draw a boundary that initially follows the southern boundary of the tank farm,
drops due south along the road from the southeast corner of the tank farm,
continues to the south edge of the site map, follows the edge of the site map west to
the next major road, and follows the road north until even with the bottom of the
tank farm. Close the polygon by double-clicking.
13. In the ZONE PROPERTIES window, change Line Type to ‘Dash-Dot’, change Line
Color to ‘Very Light Blue’, and the Color in the Name Display tab to ‘Very Light
Blue’, then click OK.
14. Preview the site map and notice the colored outlining around the two zones.

— 47 —
 15. Exit the preview, then click the Input tab to close the Site Map view.

We will demonstrate selective output by zone, which is a feature of log, fence, and site map
report output.

1. Go to OUTPUT  Fences. Ensure that ‘STRATIGRAPHY & GW - A SIZE’ appears in

the object selector.

2. Click the Browse button on the Zone Filter field at lower right. The Select Zone
or Zones to Filter On dialog appears.

Notice that both zones you previously created are listed. Check the Exclude
checkbox to the right of ‘SOUTH SUBDIVISION’, then click OK. Notice that the Zone
Filter field has changed from ‘Off’ to ‘On’.

— 48 —
 3. Preview the report. Notice that only boreholes ‘B-1’, ‘B-2’, ‘B-3’ and ‘CPT-1’ appear.
‘TP-1’ has been excluded because it is in the ‘SOUTH SUBDIVISION’ zone. Close the
preview.

4. Click the Browse button on the Zone Filter field, uncheck the Exclude checkbox
for ‘SOUTH SUBDIVISION’ and check it for ‘TANK FARM’. Click OK.
5. Preview the report again. Notice that only ‘TP-1’ appears.
6. Close the preview.

7. Click the Browse button on the Zone Filter field, clear the checkbox on ‘TANK
FARM’ then click OK.

Printing a Site Map Report

A site map report typically displays the site map with borehole markers overlaid and some
header and footer information. Optional features can be added in REPORT DESIGN,
including a legend to distinguish different marker types, and display of database data
alongside borehole markers. To view a standard site map report using the site map in your
project, do the following:
1. Go to OUTPUT  Site Maps.
2. In the object selector, select the ‘BASIC SITE MAP’ report.

3. Click the Preview button. The site map report is generated:

— 49 —
4. Notice that grid lines appear and the axes are labeled at 100 foot intervals. Borehole
points have markers corresponding to the settings in Site Map view in INPUT
(because the report design and the PointID marker expression in INPUT use the
same user data item). Also, the zones are indicated in color.
5. Close the preview.
6. Select ‘SITE MAP WITH DEPTH+ELEV’ in the object selector. Preview the report, and
zoom in on the upper left.

— 50 —
 7. Notice that elevation and depth values from the database appear alongside each
borehole marker. Close the preview.

You can print a portion of the site map instead of the entire map. Do the following:

1. Under SITE MAP OPTIONS, specify a MIN of ‘-100’ for East Axis, and a MIN of ‘200’
and a MAX of ‘700’ for North Axis .

Notice that you do not specify MIN and MAX for both axes, because the graph scales
the axes proportionally.

2. Preview the report. The site map area is now zoomed in on the region you specified.

— 51 —
 3. Close the preview.

Site Map Entities in Logs and Fences

A site map entity can be placed in a log or fence report in REPORT DESIGN to provide a
display of where borehole points in the report are located at the site. The following is an
example of a fence report with a site map included (in the upper right corner).

— 52 —
A site map entity is added to a log report in REPORT DESIGN by selecting Log  Site Map
and specifying properties in the SITE MAP PROPERTIES dialog box. Similarly, a site map is
added to a fence report by selecting Fence  Site Map.
 For further study, see Help  Index  Site Map Entity Overview. You will need
familiarity with REPORT DESIGN to modify a report to add a site map entity.

— 53 —
Fence Output Options
You can specify various settings for fence report output. These include setting maximum,
minimum and scale for both the horizontal and vertical axes, drawing a baseline to
determine how points are projected, and altering horizontal and vertical viewing angles to
create a 3-D view.

Output options specific to fences appear in the middle section of the OUTPUT tab when
OUTPUT  Fences is selected.

3-D Output of Fence Reports

Any fence report can be output in a 3-D view by changing settings in the OUTPUT tab. Also,
if the project has a site map, the site map can be displayed on the top, bottom, or both of the
3-D viewing cube. To demonstrate this, do the following:
1. Go to OUTPUT  Fences.
2. In the object selector, choose ‘STRATIGRAPHY & GW - A SIZE’.

3. Click the Properties icon. Click the 3D Options tab, and specify ‘Bottom’ for the
Site Map on 3D Cube property. Click OK.
4. Enter ‘30’ for Horz Viewing Angle and ‘30’ for Vert Viewing Angle (in the middle
of the Fence Options section of the OUTPUT tab).

5. Click the Preview icon, and enter ‘3D Fence with Site Map’ for the diagram name,
then click OK. The 3D fence report appears:

— 54 —
 6. Close the preview.
7. Clear the HORZ and VERT values.
 For further study on 3D fence report options, see Help  Index  3D Options Tab
and Help  Index  Viewing Angles.

Depth and Elevation Scales

A fence report can be output with either an Elevation or Depth scale. With an Elevation
scale, fenceposts and their constituent layers are plotted against elevation, that is, their
heights relative to a fixed point, which is often mean sea level. The values on the Y axis
increase as you go up the axis from the origin point. With a Depth scale, fenceposts are
plotted relative to Depth = zero, so all of the fencepost tops are aligned to a Depth = zero
line. The values on the Y axis increase as you move downwards from the zero line to the
origin point.

Perform the following steps:

1. Click the Properties icon, and click the Scales tab. Notice that the value in
Vertical Scale is ‘Elevation’. Click OK to close the properties window.

— 55 —
2. Preview the report (you click OK in the User Report Variables window without
specifying a value). Notice the numbering of the Y axis, and how the tops of the
fenceposts vary in Y value.

3. Close the preview. Click the Properties icon, and click the Scales tab. Change
Vertical Scale to ‘Depth’.
4. Close the properties window and preview the report.

— 56 —
5. Notice the values along the Y axis, and how the tops of all fenceposts align with the Y
= zero value.
6. Close the preview.
7. Reopen FENCE PROPERTIES  Scale, change the Vertical Scale back to ‘Elevation’,
and close the properties window.

— 57 —
Understanding Baselines

A fence report is generated by projecting borehole points perpendicularly onto a baseline.

This is demonstrated in the following pair of illustrations:

— 58 —
Note the following points about the relationships between a baseline, borehole points and
fenceposts:

• Distances along the X axis to fenceposts in the fence report are generated from
distances along the baseline to the bases of perpendiculars.
• The distance of a borehole point from the baseline (the length of a perpendicular) is
not represented.
• A baseline has a start and an end. If you flip a linear baseline so that the start and
end points are reversed, the fence report flips horizontally, reversing the order of
the fenceposts.

Creating a Custom Baseline

When you do not specify the baseline, the software creates a “best fit” baseline for the set of
borehole points, and projects onto that. However, you can specify your own baseline either
by entering coordinates of baseline points or by drawing. By specifying a custom baseline
you determine the view created of your borehole points. Do the following:
1. Preview the fence report with default options (note that in this and the remaining
previews, you can omit the Diagram Name).

2. Close the preview.

— 59 —
3. Click the Browse button to the right of the Baseline field. Enter ’24, 321’ for the
pair of coordinates in the first row, and 329, 321 for the pair in the second row.

These two points are the endpoints of the baseline.

4. Click OK to save the baseline coordinates, then preview the report.

— 60 —
5. Notice that the five boreholes are much closer together, ‘CPT-1’ has moved to the
left of ‘B-3’, and ‘TP-1’ has moved to the right of ‘B-1’. Close the preview.
6. Click the Site Layout button. Zoom in on the middle-left section where the
boreholes are. The red horizontal line across the center is the baseline.

— 61 —
7. Select Fence Spec  Erase Baseline. This removes the current baseline.
8. Select Fence Spec  Draw Baseline. The First Point prompt appears in the
command box. Create (by clicking on two points, starting at the bottom) a vertical
line that lies to the right of the ‘B-2’ and ‘TP-1’ points, and to the left of ‘CPT-1’, as
shown. Click OK after placing the second point.

9. Click Return to Output, then preview the report.

— 62 —
 Notice that ‘B-1’, ‘B-2’ and ‘B-3’ are clustered at left center, with ‘TP-1’ at left, and
‘CPT-1’ at right center. This is consistent with where these points lie relative to the
baseline, as you move up the baseline from the bottom.

As you recall, we drew the baseline from bottom to top. If we had drawn it in the
other direction, the order of the fenceposts would be reversed, with ‘CPT-1’ at left
and ‘TP-1’ at the right.

10. Close the preview.

Next, we’ll see how you can restrict the set of boreholes output to those lying within a
specified distance of the baseline.

1. Click Site Layout, and zoom in on the group of boreholes.

2. Click the Distance icon. Click on the ‘B-3’ point, and click again on the baseline
at the same height. This indicates the distance between the borehole and the
baseline. Make note of the value (it should be about 75 feet). Press Esc to close the
Distance box.
3. Close the Site Layout view.

— 63 —
 4. Enter a value just slightly larger than the ‘B-3’ distance in the Maximum Baseline
Offset field, then preview the report. Notice that ‘B-1’ and ‘TP-1’ fenceposts have
disappeared, but the other three boreholes remain.
5. Close the preview. Enter a value just slightly less than the ‘B-3’ distance in the
Maximum Baseline Offset field, then preview the report. Notice that ‘B-3’ has
disappeared, and only two boreholes are shown.
6. Close the preview. Clear the Maximum Baseline Offset value.

Note that a baseline does not have to be a single straight line. It can be a series of connected
line segments, although the report will still project each point to the baseline at its closest
distance to the baseline. Do the following:

1. Click Site Layout, and zoom to the cluster of points.

2. Select Fence Spec  Erase Baseline, then Fence Spec  Draw Baseline.
3. Click on multiple points, starting at left, that trace the path of the main road below
the tank farm, as shown, then click OK.

4. Close the Site Layout view. Enter a Maximum Baseline Offset of ‘100’, then preview
the report.

— 64 —
 Notice that the five points are shown at their distances along the road.

5. Close the preview.

 Note: Your baseline settings are lost when you leave OUTPUT. To save a baseline,
either create a script (click the Script icon and select Write Script) or select the
Expand button to the right of the Baseline field and click Export.

Using Min, Max and Scale

Min, Max, Scale, and #Div fields are provided for both the vertical (Elevation or Depth)
and horizontal (Distance Along Baseline) axes. These fields control the span of each axis
relative to the data.

1. Click the Site Layout button.

2. Select Fence Spec  Erase Baseline to remove the existing baseline.
3. Select Fence Spec  Draw Baseline. Enter ‘24, 321’ in the coordinates box at lower
left (then Enter) for the First Point prompt, then ‘329, 321’ for the Next Point
prompt.
4. Click OK, then close Site Layout view. Preview the report.

— 65 —
5. Notice the horizontal scale is from 0 to 350, with grid lines every 50'. This is because
the baseline is 305' long (from X=24 to X=329, with no change in Y). The system
calculates the length of the baseline (the best fit baseline, if you do not specify one),
divides it into increments of a reasonable size, and rounds up the length to the next
increment.
6. Change the Max value for Distance Axis to ‘300’. Preview the report.

— 66 —
 7. Notice that the X axis is now from 0 to 300, with 6 increments of 50' (instead of 7
increments of 50' as before).
8. Close the preview. Set the Distance Axis Min to ‘25’ and Max to ‘275’, and leave
#Div at 10.
9. Preview the report. Notice that the resulting scale is from 20 to 380, in 13
increments of 20'.

Clearly the software does not implement your X axis specifications to the letter—
rather, it chooses something close to what you requested, without creating
arbitrarily confusing or ugly scales (such as the 10 increments of 36' that would
have resulted if our specifications were implemented exactly).

Next we will experiment with vertical scale.

1. Before closing the preview, notice the range and increments of the vertical axis. It
ranges from 75' to 135', in 11 increments of 5'.

— 67 —
 This has been calculated based on the highest and lowest elevation values in the set
of boreholes—at the top of the ‘B-2’ borehole (130') and the bottom of the ‘CPT-1’
(77').

2. Close the preview.

3. Clear the Distance Axis Min and Max values.

4. Click the Properties icon, then Data Frame. Notice that the Frame Height is
5.5", which tells us that the current scale is 10 ft/in (55' of elevation in 5.5" on the
page).
5. Click the Scales tab. Clear the value from the Vertical Axis Offset: Top field. Click
OK.
6. Preview the report. Notice that the Y axis range is now 75' to 130', and the top of the
‘B-2’ borehole straddles the upper edge of the data frame.

The offset value in the Scales tab was keeping the top of the frame away from the
top of the highest borehole.

7. Close the preview. Set a Vertical Axis Max of 130 and Scale of 2.5, then preview the
report.

— 68 —
 Notice that the Y axis range is now from 116' to 130', in seven increments of 2'. The
program has adhered to your maximum and scale requirements exactly, but
adjusted the number of divisions (from 10 to 7).

 Note: The Y minimum is placed at 116.25', which is where 5.5" of page at 2.5
ft/in and a maximum of 130' would place the Y axis bottom. The software has
plotted the Y minimum exactly at this height.

Note also that you cannot meaningfully set all three of the minimum, maximum
and scale for an axis. One of these values will be ignored (by convention, gINT
ignores the maximum in this circumstance).

8. Close the preview.

 Note: The Vertical Axis Offset: Top value that you removed from the Scales
tab will be restored the next time you leave OUTPUT or close the program,
since it is specified for this report in REPORT DESIGN. Changes to report
properties in OUTPUT are temporary.
 For more information on fence minimum, maximum and scale settings in OUTPUT,
see Help  Index  Fences (Output).

— 69 —
Using Alignments
Alignment support is provided in Version 8.2 and later. If you are doing road design, this
feature lets you define, store and output the data for multiple alignments. However,
alignments also benefit anyone who uses custom baselines in fence reports, since they
enable you to save multiple baselines.

The Alignments Support Module (Tab)

To add alignments support, do the following:

1. Go to INPUT.
2. Ensure that your current library is training.glb and your current project is
training.gpj.
3. Select Additional Modules  Alignments Support. This adds the alignments
support module, indicated with a checkmark next to the menu option.
4. Notice that there is now an Alignments tab in the Main group. Click this tab. The
split screen for alignment data entry appears:

— 70 —
 The upper grid is for the GINT_ALIGNMENTS table, captioned as Alignments. You
create one parent record here for each road alignment or stored baseline.

The lower grid is for the GINT_ALIGNMENT_COORDS table, captioned as Alignment

Coordinates. For each parent GINT_ALIGNMENTS record in the upper grid, this
lower grid holds the coordinates that define the path of the alignment.

How to Store Baselines as Alignments

We’ll use the Alignment tab grids to create and use some stored baselines.

1. In the Alignment ID field in the upper grid, enter ‘1st Baseline’.

2. In the lower grid, if the East column is to the right of the North, drag the East
column header to the left so that it is the first column.
3. Enter the following values in the lower grid:

East North

50 309

139 319

297 292

For baseline creation, you leave the other columns blank.

4. Click the Save icon. Notice that values appear in the Station column. Stationing
or chainage is the distance along the alignment, and is automatically calculated
when you save.
 Note: If you do not have a Site Map tab, you will need to add Site Map
support and import the tank farm site map. To do this, 1) select Additional
Modules  Site Map Support, 2) click the Site Map tab, 3) select File 
Import/Export  DXF Import, 4) open ‘site map.dxf’, and 5) click the Input
tab to close site map view.
5. Go to OUTPUT  Fences.

6. Click the Browse button to the left of Use Alignment (under FENCE OPTIONS).
Select ‘1st Baseline’ and click OK.

— 71 —
 Notice that ‘1st Baseline’ appears in the Baseline field, indicating that this
alignment is providing the baseline for the fence report.

7. Click the Site Layout button. Notice that the alignment/baseline is drawn just above
the three lower points.

8. Click the Return to Output tab.

9. In the object selector, choose ‘STRATIGRAPHY & GW - A SIZE’.
10. Preview the report. The fence report appears, using the alignment you specified as a
baseline.
11. Close the preview.

Drawing a Baseline/Alignment Interactively

This is the same process for drawing a baseline as was described in “Creating a Custom
Baseline.” However, after we draw the baseline, we will copy the baseline points to the
Alignments tab to save the baseline as an alignment. Do the following:

1. Click the Site Layout button.

2. Zoom in on the tank farm area and its immediate surroundings using the Zoom
Window tool.

— 72 —
3. Select Fence Spec  Deselect Alignment for Baseline.
4. Select Fence Spec  Draw Baseline.
5. Draw a custom baseline from the upper left corner of the tank farm to the lower
right, following the tank farm boundary. Click OK.

6. Close the site layout view.

7. Click the Expand button to the right of the Baseline field.

8. Highlight the set of East and North values by dragging with the mouse. Press Ctrl-C
(Copy).
9. Click OK. Go to INPUT  Alignments.
10. Enter ‘2nd Baseline’ in the Alignment ID cell in the second row.
11. Click in the East cell in the lower grid. Press Ctrl-V (Paste). This creates an
alignment from the points that you drew in OUTPUT.
12. Go to OUTPUT. Click the Browse button to the left of Use Alignment.

— 73 —
 As you can see, you now have two stored baselines that you can choose between.

13. Click Cancel.

Displaying a Scale along Alignments

You can display a scale along each alignment in the site map. This shows the distance along
the alignment (that is, chainage). The distance and number of tick marks between divisions,
the size and offsetting of scale numbers, and similar features can be customized. To
demonstrate this, do the following:

1. Go to INPUT. Click the Site Map tab.

2. Zoom in on the alignment line just above the B-1, B-2 and B-3 boreholes. Notice that
the alignment is represented with a simple series of line segments, with no scale
markings.
3. Select Site Map  Alignment Scale Display.

4. Enter the following values, then click OK:

Property Value

— 74 —
 Major Division 50

Major Tick Length 10

Number of Minor Divisions 10

Minor Tick Length 5

Number Height 5

The length and height units are in distance units, not page units. For example, a
Major Tick Length of ‘10’ means 10 feet or 10 meters long (whatever your units
are), not some number of millimeters or inches on the page.

5. Notice that the two alignments in the site map now have scale markings.

6. You can make the scale numbers perpendicular (or angled) relative to the major tick
marks by changing the Number Angle Offset value. Select Site Map  Alignment
Scale Display, and set Number Angle Offset to ‘90’. Click OK. Notice that the scale
values are now perpendicular to the tick marks.
7. Close the Site Map view.
The Alignment Scale Display settings you entered only apply in Site Map view (in INPUT)
and Site Layout view (in OUTPUT). They must be configured separately in REPORT
DESIGN if you want to see the alignment scale included in printed or previewed reports, as
follows:

• For a site map entity in a log or fence:

a. Open the report in REPORT DESIGN.
b. Double-click the site map entity.

— 75 —
 c. Click the Alignment Scales tab in the SITE MAP PROPERTIES window.
d. Enter your specifications then click OK. The properties in this tab work exactly
the same way as their counterpart in INPUT  Site Map  Alignment Scale
Display.
• For a site map report:
a. Open the report in REPORT DESIGN  Site Maps.

b. Click the Properties icon.

c. Click the Alignment Scales tab (you may have to scroll the tabs to see it).
d. Enter your specifications then click OK. The properties in this tab work the same
way as their counterparts in INPUT  Site Map and log/fence reports.

Creating Alignments for Road Design

The Alignments Support module contains a robust set of features for road design. To
demonstrate this, we’ll examine a project with the alignments data already entered. Do the
following:

1. Go to INPUT and open the alignments.gpj project.

2. Click the Point tab. Notice that there are 13 boreholes.
3. Click the Site Map tab. Notice that a site map of a hilly area has been included in the
project, and the borehole locations are plotted.

The blue line between the boreholes is the alignment called ‘main road alignment’.
Any alignments you define in the project will be plotted in Site Map view.

— 76 —
4. Click the Input tab to close the Site Map view. Click the Alignment tab.

5. Notice the following:

ο There is one parent alignment (GINT_ALIGNMENTS) record, with an Alignment
ID of ‘main road alignment’.
ο The parent record has 20 child Alignment Coordinates
(GINT_ALIGNMENT_COORDS) records in the lower grid, each defining a
measuring point along the alignment.
ο The child Alignment Coordinates records have Z1 and Z2 values, which were
not used in the previous “saved baseline” examples.
ο Station (chainage) values have been calculated for all of the child records.
ο The set of Z1 values in the child records has a corresponding Z1 Description
(‘original ground surface’), Z1 Line Thickness, and Z1 Color in the parent
record. The Z2 values also have a Z2 Description (‘final graded surface’) and
line and color fields.
6. Go to OUTPUT  Fences. Make sure that ‘STRATIGRAPHY & GW - A SIZE’ is
selected in the object selector.

7. Click the Use Alignment Browse button. Select Main Road Alignment and click
OK.

— 77 —
 8. Preview the report.

9. Notice that the Z1 (‘original ground surface’) and Z2 (‘final graded surface’) curves
are plotted for the ‘main road alignment’. The Z1 (original) curve is a blue dashed
line, as specified in the GINT_ALIGNMENTS record. The Z2 (final) curve is a magenta
solid line.
10. Close the preview.

Additional Points about Alignments

• The Units property for the fields in an alignment is specified when you add
Alignments Support. The Units properties of the Initial Station field in the parent
table and all the fields in the child table are set to be the same as the Units property
of the Depth (HoleDepth) field in POINT.
• On save, the alignment coordinates are validated for the following:
ο There must be at least 2 points.
ο The lines connecting the alignment coordinates cannot cross.
ο No two rows can have the same pair of North and East values.
 For additional information about alignments, see Help  Index  Alignments.

— 78 —
Appendix A -- Matching Scale and Origin in Imported Site
Maps
When you import an AutoCAD DXF file to use as a site map in your gINT project, you need
to make sure both the scale and the origin point of the site map match with borehole
locations stored in the gINT project database. Scaling and origin placement problems are
easily corrected using the General Drawings application in DRAWINGS.

Note that this method requires that at least two borehole locations used in the gINT project
database be marked on the AutoCAD drawing. (If more are marked, choose the two located
the greatest distance apart from each other as your “reference” boreholes.)

We will import, move and re-scale the site map 2.dxf file. This is a site map showing of a
portion of site map.dxf, with the same boreholes indicated, but to a smaller scale and
different origin. Do the following:
1. Extract the following file to the indicated location:

File Destination

site map 2.dxf \gINT\auxiliary files\

2. Go to INPUT. If the Site Map tab appears, select Additional Modules  Site Map
support. Click OK when the Remove Site Map Support prompt appears. This
deletes the existing site map from the project.
3. Select Additional Modules  Site Map Support. Click the Site Map tab. \
4. Select File  Import/Export  DXF Import and select site map 2.dxf in
\gINT\auxiliary files\. Click Open.

5. Click Zoom Extent to show the entire site map and database borehole points.
Notice that the locations of the boreholes in the site map and database do not
coincide.

— 79 —
6. Select Modify  Move (or press Ctrl-M, or click the Move icon). The Select
Entities prompt appears.
7. Click the Mark All button at lower right. This highlights all entities in the site map.
Click OK. The Handle Point prompt appears.

8. Select the Snap to Center tool in the Snaps toolbar.

9. Click in or near the center of the ‘B-1’ point ID marker square in the site map. (This
is green because of having been selected previously.) The Final Location of Handle
Point prompt appears.

10. Select the Snap to Point tool.

11. Click in the center of the ‘B-1’ point ID marker symbol from the database. (This is
red, and is either a solid triangle or a hollow circle, depending on whether or not
you have performed the exercises in the Site Map chapter). The site map drawing
moves so that the ‘B-1’ points in the database and site map drawing coincide.

— 80 —
12. Measure the distance between the ‘B-1’ and ‘B-3’ database points. To do this, click
Snap to Point , click inside the red ‘B-1’ point marker, click the Distance icon,
click Snap to Point again, and then click inside the red ‘B-3’ marker. The DISTANCE
message box appears.

13. Make note of the Distance value at the bottom of the message box, then click OK.
Press Esc to clear the Distance command mode.
14. Click Modify  Scale to Ref Distance.

— 81 —
15. In the Reference Distance field enter the distance value you recorded from
measuring between points, then click OK.
16. In response to the Select Entities prompt, click Do All.
17. In response to the First Point of Reference Line prompt, click Snap to Point and
click the center of the red ‘B-1’ marker again (this coincides with the ‘B-1’ point on
the imported site map drawing).
18. In response to the Second Point of Reference Line prompt, click the center of the
black square ‘B-3’ marker in the site map drawing.
19. In response to the Base Point prompt, click Snap to Point and click the center of the
red ‘B-1’ marker. After processing for a few seconds, the drawing will scale so that
the borehole points in the database coincide with the borehole points indicated in
the site map.

— 82 —
 Note the following points about matching scale and origin:

• Scaling accuracy increases with the distance between the two “reference” markers,
in this case the two database points ‘B-1’ and ‘B-3’.
• Repeated iterations of the relocation and scaling process can be used if the initial
results aren’t accurate enough. A rotation menu option is also provided in the
Modify menu if needed.
• Point selection by mouse is generally less accurate than entering coordinates in the
coordinates box. When using the mouse, use snap tools with it wherever possible.

Appendix B -- DXF Import and Export

You can import from and/or export to a DXF file in the following gINT applications:
• In OUTPUT, using the Export To File text box and Export button, when you specify
a Save As Type of ‘AutoCad *.DXF’. This generates one or more DXF files from the
specified log, fence or other report, with the output controlled by specifications in
the OUTPUT tab, the report properties and system properties.
• In INPUT  Site Map, using the File  Import/Export  DXF Import or DXF
Export menu items. In particular, this enables you to import an AutoCAD-created
site map into gINT and use it as a project’s site map.
• In DRAWINGS  General Drawings, using the File  Import/Export  DXF
Import or DXF Export menu items. This enables you to import an AutoCAD
drawing and work on it in General Drawings with gIDraw tools, then re-export it to
AutoCAD, for example.
 Note: You can also import and export DXF in REPORT DESIGN and
DRAWINGS  Drawing Library, but these capabilities are generally less
useful.
 Note: Microstation .DGN files are not supported in gINT, but Microstation
users can use AutoCAD DXF files for the same functionality.
gINT supports the AutoCAD version 12 DXF specification for both import and export, with
extensive support for AutoCAD features such as layers, hatches, fonts, colors, line types,
and so on. Since gINT’s implementation of these features is often very different from
AutoCAD’s—for example, AutoCAD does not support TrueType fonts—the import and
export translations are controlled using various properties in gINT, as described in the
sections which follow.

Note that not all AutoCAD capabilities are supported, only those that are relevant to gINT.
For example, DXF files support interchange of true 3D drawings, whereas gINT does not
have 3D support and therefore would ignore the parts of a DXF file that deal with 3D.

— 83 —
 For additional details related to controlling import and export of DXF files, see Help
 Index  DXF Files Tab.

Configuring a Report for AutoCAD Export

A report has certain report and entity properties that determine how its entities and
background features are allocated to layers on output to DXF. Otherwise, the translation of
report output to AutoCAD is controlled identically to the export of drawings.

You can choose to either export a report to a single DXF file with each report page on a
separate layer, or to one DXF file per report page, with the ability to specify which entities
go on which layers. This is controlled by the setting of the Multiple Page Output to
Separate Files checkbox in the DXF Files tab of File  System Properties. If the checkbox
is unchecked, report output is to a single file with one page per layer. If it is checked, a file
is exported for each report page and settings in the report properties and entity properties
of the report control which layers receive which entities, as follows:
• For logs and graphic text docs, background elements such as the frame, grid, axes,
axis labels and division numbers always go to Layer 0. Specific non-background
entities can be assigned to specific layers, using the Layer Name property in the
Configuration tab for each entity. Note that you must create a layer in the LAYER
PROPERTIES dialog box before you can assign an entity to it. You must also check
the Retain Layering property (in the Report Structure tab in logs, in the Layers
tab in graphic text docs), or your entity assignments will be ignored and everything
will go to Layer 0.
• In fences, graphs, histograms, and site maps, the default destination for background
elements is Layer 0 but you can choose particular layers for each background
element using report properties such as Layer For Grid, Layer For Frame and so
on in the corresponding tabs. You do not need to explicitly create these layers; they
will be created on output if not already defined in LAYER PROPERTIES.
• For fences, each fencepost and its set of associated entities (such as text, text-vs-
depth and graphic-vs-depth entities) is output to its own layer. The layer is given the
name of the corresponding PointID. You cannot reconfigure this behavior.
• For graphs and histograms, non-background elements go to a separate layer for
each page.
• For site map reports. the Retain Original Site Map Drawing Layers checkbox (in
the Data Representation tab) determines whether all non-background features go
to a single layer (if unchecked), or to the layers that exist in the site map drawing (if
checked), including the ‘POINTIDS’ layer.
 Note: Although blocks are supported in both gINT reports and AutoCAD, gINT
explodes blocks on export to DXF.

— 84 —
Site Map Import/Export

In the Site Map tab in INPUT, layers can be created (in the LAYER PROPERTIES dialog)
and drawing entities can be assigned to layers as they can in any gIDraw application. Also,
any layers present in the imported site map file are retained. When a site map is exported
from INPUT, an additional layer called ‘POINTIDS’ is created to hold point marker symbols
and text. Alternately, you can just export the point ID markers without the site map
drawing by selecting the Site Map  DXF Export PointIDs Only menu option.

Drawing Import/Export

Exporting
The File  Import/Export  DXF Export command is used to export the current drawing
page from gIDraw-based applications such as DRAWINGS  General Drawings, INPUT
 Site Maps and SYMBOL DESIGN  Discrete Graphics to a DXF file. Conversion of fonts,
lines, fills and so on are controlled by settings in the DXF Files tab in the SYSTEM
PROPERTIES dialog.

 Note: In conjunction with the Print Order property, Solid White fills can be used in
polylines to blot out background entities. However, DXF export does not support
print order and the color white is translated to black. For these reasons, white
polyline fills are automatically suppressed when exported to DXF. This applies to
both the Main and Background fills.

Importing
The File  Import/Export  DXF IMPORT merges in a DXF file into an existing gINT
drawing. The supported DXF commands are: ARC, ATTDEF, BLOCK, CIRCLE, INSERT,
LAYER, LINE, POINT, POLYLINE, SOLID, TRACE, and TEXT. As with DXF export, conversion
is controlled by property settings in SYSTEM PROPERTIES.

With line entities (ARC, CIRCLE, LINE, POLYLINE, SOLID, and TRACE), gIDraw imports
them as equivalent polylines. In the case of curved entities, the No. Points in a Circle
property in SYSTEM PROPERTIES is used to determine the number of points to use.

On importing from the DXF file, if the entities take their colors from the layer color, gINT
assigns the layer color to the entities. If a layer in the DXF file does not exist in the current
gINT page, it is created with the same hidden, locked and color properties of the DXF layer.
The DXF frozen property is translated to hidden. If the DXF layer exists in the current gINT
page, the DXF layer properties are ignored and the gINT properties are maintained.

If import is to a page type that does not support layering (Data Markers, Tiles, Discrete
Graphics, and Fixed Curves), layering is ignored and all the entities are imported to the
page.

— 85 —
Appendix C -- Outputting a Fence Report of Evenly Spaced,
Custom-Ordered Points
For certain applications, you may need to create a fence report that displays a set of
borehole points in a left-to-right order of interest to you, with equal spacing between posts
(rather than spacing based on how each point’s coordinates map perpendicularly to a
baseline). Fortunately, there is a simple way to accomplish this without performing
complex manipulations of the data. This technique relies on connecting the points with a
jagged custom baseline, and setting a property on the OUTPUT  Fences tab.

To demonstrate this (using training.gpj and training.glb from the Standard Data Files for
All Tutorials), do the following:
1. Go to OUTPUT  Fences.
2. Click the Site Layout button.

Let’s assume you want fenceposts for ‘B-3’, then ‘CPT-1’, then ‘B-1’, then ‘B-2’.

3. Select Fence Spec  Draw Baseline.

4. Click the Snap to Point and Snap Lock icons at lower left. This forces the
baseline vertices to attach to each point you click on or near.
5. Click on the four points one at a time in the order indicated above. A polyline is
drawn with boreholes at the vertices.

6. Click the Return to Output tab.

— 86 —
 7. Check the Equally Space Points Along Distance Axis checkbox (just beneath the
HORZ and VERT boxes).
8. Set a maximum baseline offset of 1. This keeps points from projecting onto other
segments of the baseline.
9. Preview the report. Notice that the borehole points are equally spaced and in the
requested order.

Notice that this technique will not always work with large sets of points in highly complex
orders. Unless you can draw a baseline polyline that does not cross itself, you cannot use
this technique. That the polyline is non-self-crossing is a requirement for baselines. For
these situations you need to implement a Point Sort field (see Help  Index  Point Sort
Field). However, you would still use the Equally Space Points Along Distance Axis
checkbox.

— 87 —