File Format Details

  • EVS Data Input & Output Formats

    EVS Data Input & Output Formats Input EVS conducts most of its analysis using input data contained in a number of ASCII files. These files can generally be created using the Data Transformation Tools, which are on the Tools tab of EVS. These tools will create C Tech’s formats from from Microsoft Excel files.

  • Handling Non-Detects

    Handling Non-Detects It is important to understand how to properly handle samples that are classified as non-detects. A non-detect is an analytical sample where the concentration is deemed to be lower than could be detected using the method employed by the laboratory. Non-detects are accommodated in EVS for analysis and visualization using a few very important parameters that should be well understood and carefully considered. These parameters control the clipping non-detect handling in all of the EVS modules that read chemistry (.apdv, or .aidv) files. The affected modules are 3d estimation, krig_2d, post_samples, and file_statistics.

  • Consistent Coordinate Systems

    Consistent Coordinate Systems C Tech’s software is designed to work with many types of data. However, because you are creating objects in a three-dimensional domain (x, y, and z extents) you must have all objects defined in a consistent coordinate system. Any coordinate projection may be used, but it is essential that all of your data files (including world files to georeference images) be in the same coordinate system.

  • Projecting File Coordinates

    Projecting File Coordinates Discussion of File Coordinate Projection Each file contains horizontal and vertical coordinates, which can be projected from one coordinate system to another given that the user knows which coordinates systems to project from and to. This is accomplished by adding the REPROJECT tag to the file. This tag is used in place of the coordinate unit definition and causes the file reader to look at the end of the file for a block of text describing the projection definitions. The definitions are a series of flags that listed below. NOTE: GMF files do not need the REPROJECT tag, the projection definitions can occur in a continuous block anywhere in the file.

  • Analytical Data

    All analytical data can be represented in one of two formats:

  • APDV: Analyte Point Data File Format

    APDV: Analyte Point Data File Format Discussion of analyte (e.g. chemistry) or Property Files Analyte (e.g. chemistry) or property files contain horizontal and vertical coordinates, which describe the 3-D locations and values of properties of a system. For simplicity, these files will generally be referred to in this manual as analyte (e.g. chemistry) files, although they can actually contain any scalar property value of interest. Analyte (e.g. chemistry) files must be in ASCII format and can be delimited by commas, spaces, or tabs. They must have a .apdv suffix to be selected in the file browsers of EVS modules .The content and format of analyte (e.g. chemistry) files are the same, except that fence diagram files require some special subsetting and ordering. Each line of the analyte (e.g. chemistry) file contains the coordinate data for one sampling location and any number of (columns of) analyte (e.g. chemistry) or property values. There are no computational restrictions on the number of borings and/or samples that can be included in a analyte (e.g. chemistry) file, except that run times for execution of kriging do increase with the number of samples in the file.

  • AIDV: Analyte Interval Data File Format

    AIDV: Analyte Interval Data File Format This format allows you to specify the top and bottom elevations of well screens and one or more concentrations that were measured over that interval. This new format (.aidv) will allow you to quickly visualize well screens in post_samples and automatically convert well screens to intelligently spaced samples along the screen interval for 3D (and 2D) kriging.

  • Time Domain Analyte Data

    Analyte Time Files Format Discussion of Analyte Time Files Analyte time files contain 3-D coordinates (x, y, z) describing the locations of samples and values of one or more analytes or properties taken over a series of different times. Time files must conform to the ASCII formats described below and individual entries (coordinates or measurements) can be delimited by commas, spaces, or tabs. They must have either a .sct (Soil Chemistry Time) or .gwt (Ground Water Time) suffix to be selected in the file browsers of EVS modules. Each line of the file contains the coordinate data for one sampling location, or well screen, and any number of chemistry or property values. There are no limits on the number of borings and/or samples that can be included in these files, except that run times for execution of kriging do increase with a greater number of samples in the file.

  • PGF: Pre Geology File Lithology

    Pre Geology File: Lithology The ASCII pregeology file name must have a .pgf suffix to be selected in the module’s file browser. This file type represents raw (uninterpreted) 3D boring logs representing lithology. This format is used by: create stratigraphic hierarchy post_samples gridding and horizons (to extract a top and bottom surface to build a single layer)

  • LPDV Lithology Point Data Value File Format

    LPDV Lithology Point Data Value File Format The LPDV lithology file format is the most general, free-form format to represent lithology information. To understand the rationale for its existence, you must understand that when creating lithologic models (smooth or block) with lithologic modeling, the internal kriging operations require lithologic data in point format. Therefore all other lithology file formats (.PGF and .LSDV) are converted to points based on the PGF Refine Distance. LPDV files are not refined since we use the point data directly.

  • LSDV Lithology Screen Data Value File Format

    LSDV Lithology Screen Data Value File Format The LSDV lithology file format can be used as a more feature rich replacement for the older PGF format. It has the following advantages: Fully supports non-vertical borings Supports missing intervals and lithology data which does not begin at ground surface Provides an Explicit definition of each lithologic interval An explanation of the file format follows:

  • GEO: Borehole Geology Stratigraphy

    GEO: Borehole Geology Stratigraphy Geology data files basically contain horizontal and vertical coordinates, which describe the geometry of geologic features of the region being modeled. The files must be in ASCII format and can be delimited by commas, spaces, or tabs. Borehole Geology files must have a .geo suffix to be selected in the file browsers of EVS modules. The z values in .geo files can represent either elevation or depth, although elevation is generally the easiest to work with. When chemistry or property data is to be utilized along with geologic data for a 3-D visualization, a consistent coordinate system must be used in both sets of data.

  • Geology Multi-File

    Geology Multi-File Geology Multi-Files: Unlike the .geo file format, the .gmf format is not based on boring observations with common x,y coordinates. The multi-file format allows for description of individual geologic surfaces by defining a set of x,y,z coordinates (separated by spaces, tabs, and/or commas). Geologic hierarchy still applies for definition of complex geologic structures. This file format allows for creation of geologic models when the data available for the top surface and one or more of the subsurface layers are uncorrelated (in number or x,y location). For example, a gmf file may contain 1000 x,y,z measurements for the ground surface, but only 12 x,y,z measurements for other lithologic surfaces. This format also allows for specification of the geologic material color (layer material number).

  • PT File Format

    .PT File Format The .PT (Place-Text) format is used to place 3D text (labels) with user adjustable font and alignment. The format is: Lines beginning with “#” are comments Lines beginning with “LINEFONT” are font specification lines specifically associated with single line text. LINEFONT, height, justification, azimuth, inclination, roll, red, green, blue, curve tolerance, font flags (bold is ignored) NOTE: There is no specification of the Font to be used, because EVS includes its own Unicode Line Font which supports most worldwide languages. Lines beginning with “TRUETYPE” are font specification lines specifically associated with TrueType Fonts.

  • EMT File Format

    This legacy format has been deprecated and replaced by the .PT File Format.

Subsections of File Format Details

EVS Data Input & Output Formats

Input

EVS conducts most of its analysis using input data contained in a number of ASCII files. These files can generally be created using the Data Transformation Tools, which are on the Tools tab of EVS. These tools will create C Tech’s formats from from Microsoft Excel files.

  • consistent_coordinate_systems.md
  • projecting_file_coordinates.md
  • apdv-files.md
  • aidv-files.md
  • handling_non_detects.md
  • pre_geology_file.md
  • Lithology: LSDV Screen File Format
  • Lithology: LPDV Points File Format
  • geology_file_examples_figures.md
  • geologic_file_example_sedimentary_layers_and_lenses.md
  • geologic_file_example_outcrop_of_dipping_strata.md
  • gmf_file.md
  • tcf_file.md
  • eff_file.md

.apdv, .aidv and .pgf files can be used to create a single geologic layer model. This is not preferred alternative to creating/representing your valid site geology. However, most sites have some ground surface topography variation. If 3d estimation is used without geology input, the resulting output will have flat top and bottom surfaces. The flat top surface may be below or above the actual ground surface at various locations. This can result in plume volumes that are inaccurate.

When a .apdv, .aidv, or .pgf is read by gridding and horizons the files are interpreted as geology as follows:

  1. If Top of boring elevations are provided in the file, these values are used to create the ground surface.
  2. If Top of boring elevations are not provided in the file, the elevations of the highest sample in each boring are used to create the ground surface.
  3. The bottom surface is created as a flat surface slightly below the lowest sample in the file. The elevation of the surface is computed by taking the lowest sample and subtracting 5% of the total z-extent of the samples.

Output

Because EVS runs under all versions of Microsoft Windows operating systems, there are numerous options for creating output.

Bitmap: EVS renders objects in the viewer in a user defined resolution. That resolution refers to the number of pixels in the horizontal and vertical directions.

Images: EVS also includes the output_images module, which will produce virtually all types of bitmap images supported by Windows. The most common types are .png; .bmp; .tga; .jpg; and .tif. PNG is the recommended format because it has high quality lossless compression.

Bitmap Animations: By using output_images with the Animator module, EVS can create bitmap animations. Once a sequence of images is created, the Images_to_Animation module is used to convert these to a bitmap animation format such as .AVI, .MPG, or a proprietary format called .HAV.

Printed Output: The viewer provides the ability to directly output to any Windows printer at a user defined resolution. Alternatively, images may be created (as in a) above) and printed.

Vector: EVS offers several vector output options. These include:

VRML: EVS creates VRML files which are a vector output format that allows for creation of 3D modules that model can be zoomed, panned and rotated and can represent most of the objects in the C Tech viewer. VRML files must be played in a VRML viewer or used for creating 3D PDFs or 3D printing.

4DIM: EVS creates 4DIMs, which unlike bitmap (image) based animations contain a complete 3D model at each frame of the animation. Each frame can be thought of as a VRML model (though it is not) and has similar functionality. Each frame of the model can be zoomed, panned and rotated as a static 3D model or you can interact with the 4DIM animation as it is playing.

2D and 3D Shapefiles: Shapefiles that are compatible with ESRI’s ArcGIS program can be created in full three-dimensions. Nearly any object in your applications can be output as a shapefile. The primary limitations are associated with the limitations of shapefile. The most significant limitation is the lack of any volumetric elements.

AutoCAD .DXF Files: AutoCAD compatible DXF files can be created in full three-dimensions. Nearly any object in your applications can be output as a DXF file.

Archive: EVS offers several output options for archiving kriged results and/or geologic models. The preferred format is C Tech’s fully documented EFF or EFB formats. Both of these file types can be read back into EVS eliminating the need to recreate the models by kriging or re-gridding. This saves time and provides a means to archive the data upon which analysis or visualization was based.

Handling Non-Detects

It is important to understand how to properly handle samples that are classified as non-detects. A non-detect is an analytical sample where the concentration is deemed to be lower than could be detected using the method employed by the laboratory. Non-detects are accommodated in EVS for analysis and visualization using a few very important parameters that should be well understood and carefully considered. These parameters control the clipping non-detect handling in all of the EVS modules that read chemistry (.apdv, or .aidv) files. The affected modules are 3d estimation, krig_2d, post_samples, and file_statistics.

Non-detects should “almost” never be left out of the data file. They are critically important in determining the spatial extent of the contamination. Furthermore, it is important to understand what it means to have a sample that is not-detected. It is not the same as truly ZERO, or perfectly clean. In some cases samples may be non-detects but the detection limit may be so high that the sample should not be used in your data file. If the lab (for whatever reason) reports “Not detected to less than XX.X” where that value XX.X is above your contaminant levels of interest, that sample should not be included in the data file because doing so may create an indefensible “bubble” of high concentration.

As for WHY to use a fraction of the detection limit. At each point where a measurement was made and the result was a non-detect, we should use a fraction of the detection limit (such as one-half to one-tenth). If we were to use the detection limit, we would dramatically overestimate the actual concentrations. From a statistical point of view, when we have a non-detect on a site where the range of measurements varies over several orders of magnitude, it is far more probable that the actual measurement will be dramatically lower than the detection limit rather than just below it. Statistically, if the data spans 6 orders of magnitude, then we would actually expect a non-detect to be 2-3 orders of magnitude below the detection limit! Using ONE-HALF is inanely conservative and is a throwback to linear (vs log) interpolation and thinking.

When you might drop a specific Non-Detect: If your target MCL was 1.0 mg/l, and the laboratory reporting limit for a sample were 0.5 mg/l, you would be on the edge of whether this sample should be included in your dataset. If you plan to use a multiplier of one-half, it would make the sample 0.25, which is far too close to your MCL given that the only information you really have is that the lab was unable to detect the analyte. If you use a multiplier of one-tenth, it is probably acceptable to include this sample, however if the nearby samples are already lower than this value, we would still recommend dropping it.

Recommended Method: The recommended approach for including non-detects in your data files is the use of Less Than signs “<” preceding the laboratory detection limit for that sample. In this case,the Less Than Multiplier affects each value, making it less by the corresponding fraction.

Otherwise, you can enter either 0.0 or ND for each non-detect in which case, you need to understand (and perhaps modify) the following parameters:

  • The number entered into the Pre-Clip Min input field will be used during preprocessing to replace any nodal property value that is less than the specified number. When log processing is being used, the value of Clip Min must be a positive, non-zero value. Generally, Clip Min should be set to a value that is one-half to one-tenth of the global detection limit for the data set. If individual samples have varying detection limits, use the Recommended Method with “<” above. As an example, if the lowest detection limit is 0.1 (which is present in the data set as a 0), and the user sets Clip Min to 0.001, the clipped non-detected values forces two orders of magnitude between any detected value and the non-detected values.
  • The Less Than Multiplier value affects any file value with a preceeding “<” character. It will multiply these values by the set value.
  • The Detection Limit value affects any file values set with the “ND” or other non-detect flags (for a list of these flags open the help for the APDV file format). When the module encounters this flag in the file it will insert the a value equal to (Detection Limit * LT Multiplier).

Consistent Coordinate Systems

C Tech’s software is designed to work with many types of data. However, because you are creating objects in a three-dimensional domain (x, y, and z extents) you must have all objects defined in a consistent coordinate system. Any coordinate projection may be used, but it is essential that all of your data files (including world files to georeference images) be in the same coordinate system.

Furthermore, if volumes are to be calculated the units for all three axes (x, y, and z) must be the same. We strongly recommend working in feet or meters. Other units may be used (even microns!), but you may have to perform your own unit conversions when computing volumes with volumetrics.

Though all of your analysis must be performed in a consistent coordinate system, we do allow you to have data files with different units. If you choose to do this you must use the reprojection capabilities of the Projecting File Coordinates options in your data files.

Projecting File Coordinates

Discussion of File Coordinate Projection

Each file contains horizontal and vertical coordinates, which can be projected from one coordinate system to another given that the user knows which coordinates systems to project from and to. This is accomplished by adding the REPROJECT tag to the file. This tag is used in place of the coordinate unit definition and causes the file reader to look at the end of the file for a block of text describing the projection definitions. The definitions are a series of flags that listed below. NOTE: GMF files do not need the REPROJECT tag, the projection definitions can occur in a continuous block anywhere in the file.

NOTE: When projecting from Geographic to Projected coordinates, please note that Latitude corresponds to Y and Longitude corresponds to X. Since we expect X coordinates before Y coordinates we expect Longitude (then) Latitude (Lon-Lat). If the order in your data file is Lat-Lon you must use the “SWAP_XY” tag at the bottom of the file.

Format (for REPROJECT flag):

APDV and AIDV files:

Line 2:Elevation/Depth Specifier:This line must contain the wordElevationorDepth(case insensitive)to denote whether sample elevations are true elevation or depth below ground surface. This should be followed by the ASCII string REPROJECT.

AN EXAMPLEFOLLOWS:

This is a comment line….not the header line - the next line is

X Y Z@@TOTHC Bore Top

Elevation 6.0 REPROJECT

PGF files:

  • Line 2: Line 2 contains the declaration of Elevation or Depth, the definitions of Lithology IDs and Names, and coordinate units.
    • Elevation/Depth Specifier: This line must contain the word Elevation or Depth (case insensitive) to specify whether well screen top and bottom elevations are true elevation or depth below ground surface.
        • Depth forces the otherwise optional ground surface elevation column to be required. Depths given in column 3 are distances below the ground surface elevation in the last column (column 6). If the top surface is omitted, a value of 0.0 will be assumed and a warning message will be printed to the EVS Information Window.
      • IDs and Names: Line 2 should contain Lithology IDs and corresponding names for each material. Each Name is explicitly associated with its corresponding Lithology ID and the pairs are delimited by a pipe symbol “|”.
        • Though it is generally advisable, IDs need not be sequential and may be any integer values. This allow for a unified set of Lithology IDs and Names to be applied to a large site where models create for sub-sites may not have all materials.

          • The number of (material) IDs and Names MUST be equal to the number of Lithology IDs specified in the data section. Each material ID present in the data section must have corresponding Lithology IDs and Names. If there are four materials represented in your .pgf file, there should be at least four IDs and Names on line two.
          • The order of Lithology IDs and Names will determine the order that they appear in legends. The IDs do not need to be sequential.
          • You can specify additional IDs and Names, which are not in the data and those will appear on legends.
      • Coordinate Units: You should include the units of your coordinates (e.g. feet or meters). If this is included it must follow the names associated with each Lithology ID.
      • The Btagmust follow the IDs & names forthematerials.

The first two lines of a PGF EXAMPLEFOLLOWS:

Pregeology file

Elevation 1|Silt 2|Fill 3|Clay 4|Sand 5|Gravel REPROJECT

GEO files:

Line 2: Elevation/Depth Specifier:

  • The only REQUIRED item on this line in the Elevation or Depth Specifier.
    • This line should contain the word Elevation or Depth (case insensitive) to denote whether sample elevations are true elevation or depth below ground surface.
      • If set to Depth all surface descriptions for layer bottoms are entered as depths relative to the top surface. This is a common means of collecting sample coordinates for borings.
      • Note that the flags such as pinch or short are not modified.
  • Line 2 SHOULD contain names for each geologic surface (and therefore the layers created by them).
    • There are some rules that must be observed.
      • The number of surface (layer) names MUST be equal to the number of surfaces. Therefore, if naming layers, the first name should correspond to the top surface and each subsequent name will refer to the surface that defines the bottom of that layer.
      • A name containing a space MUST be enclosed in quotation marks example (“Silty Sand”). Names should be limited to upper and lower case letters, numerals, hyphen “-” and underscore “_”. The names defined on line two will appear as the cell set name in the explode_and_scale or select cell sets modules. Names should be separated with spaces, commas or tabs.
  • The REPROJECT tag must follow the names for the material numbers. It replaces the COORDINATE UNITS

AN EXAMPLE FOLLOWS:

X Y TOP BOT_1 BOT_2 BOT_3 BOT_4 BOT_5 BOT_6 BOT_7 Boring

-1 Top Fill SiltySand Clay Sand Silt Sand GravelREPROJECT

GMF files:

GMF files can have the projection block placed anywhere in the file.

Projection Block Flags:

**NOTE: Most flags defined below include arguments denoted by the ‘[’ and ‘]’ characters. These characters should not be included in the file. (Example: IN_XY meters)

PROJECTION: Indicates the start of the coordinate projection block

SWAP_XY:This will swap all coordinates in the x and y columns

UNITS[string]: This defines what your final coordinates for x, y, and z,will be.These units will be checked for in the file \data\special\unit_conversions.txt. If they are not found there they will be treated asequivalent tometers.

UNIT_SCALE[double]: The UNIT_SCALE flag sets the conversion factor between the final coordinates and meters. This is only necessary if you are defining units with the UNITS flagthat are not listed in the \data\special\unit_conversions.txt file.

IN_Z[string]: This flag sets what units your z or depth coordinates are. These units if different than the defined UNITS will be converted to the UNIT type. If UNITS arenot set then this will generate an error.

IN_X[string]: This flag sets whatunits your x coordinates are. These units if different than the defined UNITS will be converted to the UNIT type. If UNITS arenot set then this will generate an error.

IN_Y[string]: This flag sets whatunits your y coordinates are. These units if different than the defined UNITS will be converted to the UNIT type. If UNITS arenot set then this will generate an error.

IN_XY[string]: This flag sets what units your x and y coordinates are. These units if different than the defined UNITS will be converted to the UNIT type. If UNITS arenot set then this will generate an error.

PROJECT_FROM_ID[int]: This flag sets the EPSG ID value you wish to project from, you can look up what ID is appropriate for your location using the project_fieldmodule. To use this flag you must set the PROJECT_TO_ID or PROJECT_TO flag as well.

PROJECT_TO_ID[int]: This flag sets the EPSG ID value you wish to project to, you can look up what ID is appropriate for your location using theproject_field module. To use this flag you must set the PROJECT_FROM_ID or PROJECT_FROM flag as well.

PROJECT_FROM[string]: This flag sets the NAME of the location you wish to project from, you can look up what NAME is appropriate for your location using theproject_field module. To use this flag you must set the PROJECT_TO_ID or PROJECT_TO flag as well.IMPORTANT: The full name should be enclosed in quotation marks so that the full name will be read.

PROJECT_TO[string]: This flag sets the NAME of the location you wish to project to, you can look up what NAME is appropriate for your location using theproject_field module. To use thisflag you must set the PROJECT_FROM_ID or PROJECT_FROM flag as well.IMPORTANT: The full name should be enclosed in quotation marks so that the full name will be read.

TRANSLATE[doubledoubledouble]: This flag will translate each coordinate in the file by these values. It will translate x by the first value, y by the second, and all z values by the third.

END_PROJECTION: Denotes the end of the projection block and is required.

Example 1:

PROJECTION

PROJECT_FROM_ID 4267

PROJECT_TO “NAD83 / UTM zone 10N”

UNITS “meters”

SWAP_XY

END_PROJECTION

Example 2:

PROJECTION

UNITS “meters”

IN_XY “km”

IN_Z “ft”

END_PROJECTION

All analytical data can be represented in one of two formats:

These two file formats can support many different types of data including:

  • Soil, groundwater and air contaminant concentrations
  • Ore data
  • Data collected at multiple dates and times
  • MIP (semi-continuous)
  • Geophysical data
    • Porosity, transmissivity
    • Hydraulic head
    • Flow velocity
    • Electrical Resistivity
    • Ground Penetrating Radar
    • Seismic
  • Oceanographic data
    • CTD
    • Plankton density
    • Other water quality
    • Sub-bottom sediment measurements

APDV: Analyte Point Data File Format

Discussion of analyte (e.g. chemistry) or Property Files

Analyte (e.g. chemistry) or property files contain horizontal and vertical coordinates, which describe the 3-D locations and values of properties of a system. For simplicity, these files will generally be referred to in this manual as analyte (e.g. chemistry) files, although they can actually contain any scalar property value of interest. Analyte (e.g. chemistry) files must be in ASCII format and can be delimited by commas, spaces, or tabs. They must have a .apdv suffix to be selected in the file browsers of EVS modules .The content and format of analyte (e.g. chemistry) files are the same, except that fence diagram files require some special subsetting and ordering. Each line of the analyte (e.g. chemistry) file contains the coordinate data for one sampling location and any number of (columns of) analyte (e.g. chemistry) or property values. There are no computational restrictions on the number of borings and/or samples that can be included in a analyte (e.g. chemistry) file, except that run times for execution of kriging do increase with the number of samples in the file.

Analyte (e.g. chemistry) data can be visualized independently or within a domain bounded by a geologic system. When a geologic domain is utilized for a 3-D visualization, a consistent coordinate system must be used in both the analyte (e.g. chemistry) and geology files. The boring and sample locations in 3-D analyte (e.g. chemistry) files do not have to correspond to those in the geology files, except that they must be contained within the spatial domain of the geology, or they will not be displayed in the visualization. If the posting of borings and sample locations are to honor the topography of a site, the analyte (e.g. chemistry) files also must contain the top surface elevation of the boring. As will be described in later sections, EVS uses tubes to show actual boring locations and depths, and spheres to show actual sample locations in three-space. In order for these entities to be correctly positioned in relation to a variable topography, the top elevation of the boring must be supplied to the program.

Format:

  • You may insert comment lines in .apdv files.

    • Comment lines must begin with a ’#’ as the first character of a line.

Line 1: You may include any header message here (that does not start with a ’#’ character) unless you wish to include analyte names for use by other EVS modules (e.g. data component name). The format for line 1 to enable chemical names is as follows

A. Placing a pair of ’@’ symbols triggers the use and display of chemical names (example @@VOC). Any characters up to the @@ characters are ignored, and only the first analyte name needs @@, after that the chemical names must be delimited by spaces,

B. The following rules for commas are implemented to accommodate comma delimited files and also for using chemical names which have a comma within (example 1,1-DCA). Commas following a name will not become a part of the name, but a comma in the middle of a text string will be included in the name. The recommended approach is to put a space before the names.

C. If you want a space in your analyte name, you may use underscores and EVS will convert underscores to spaces (example: Vinyl_Chloride in a .aidv file will be converted to ’r;Vinyl Chloride." Or you may surround the entire name in quotation marks (example: “Vinyl Chloride”).

The advantages of using chemical names (attribute names of any type) are the following:

    • many modules use analyte names instead of data component numbers,
      • when writing EVS Field files (.eff, .efb, etc.), you will get analyte names instead of data component numbers.
      • when querying your data set with post_sample’s mouse interactivity, the analyte name is displayed.
      • time-series data can be used and the appropriate time-step can be displayed.

Line 2: Specifications

  • Elevation / Depth / 2D Specifier: The first item on line 2 must be one of the following three words.
    1. Elevation: This is case insensitive and specifies that the Z coordinate information is a TRUE ELEVATION
    2. DepthThis is case insensitive and specifies that the Z coordinate information is a positive number corresponding to the DEPTH below ground surface.
    3. 2D: This is a special case that allow for all data rows in the file to NOT INCLUDE Z Coordinate information. When read, the file will assume the Z coordinate is 0.0.
  • Coordinate Units:After Depth/Elevation/2D, include the units of your coordinates (e.g. feet, ft. or meters, m)

Line 3: Specifications

  • The first integer (n) is the number of samples (rows of data) to follow. You may specify “All” instead to use all data lines in the file.
  • The second integer is the number of analyte (chemistry) values per sample.
  • The units of each data analyte column (e.g. ppm or mg/kg).

Line 4: The first line of analyte point data must contain:

  • X
  • Y
  • Elevation (or Depth) of sample
  • (one or more) Analyte Value(s) (chemistry or property)
  • Well or Boring name. The boring name cannot contain spaces (recommend underscore “_” instead).
  • Elevation of the top of the boring.

Boring name and top are are optional parameters, but are used by many modules and it is highly recommended that you include this information in your file if possible. They are used by post_samples for posting tubes along borehole traces and for generating tubes which start from the ground surface of the borehole. Both 3d estimation and gridding and horizons will use this information to determing the Z spatial extent of your grids (gridding and horizons will create a layer that begins at ground surface if this information is provided). Numbers and names can be separated by one comma and/or any number of spaces or tabs.

BLANK ENTRIES (CELLS) ARE NOT ALLOWED.

Please see the section on Handling Non-Detects for information on how to deal with samples whose concentration is below the detection limit. For any sample that is not detected you may enter any of the following. Please note that thefirst threeflag words are not case sensitive, but must be spelled exactly as shown below.

  • Prepend a less than sign < to the actual detection limit for that sample. This allows you to set the “Less Than Multiplier” in all modules that read .apdv files to a value such as 0.1 to 0.5 (10 to 50%). This is the preferred and most rigorous method.
  • nondetect
  • non-detect
  • nd
  • 0.0 (zero)

For files with multiple analytes such as the example below, if an analyte was not measured at a sample location, use any of the flags below to denote that this sample should be skipped for this analyte.Please note that these flag words are not case sensitive, but must be spelled exactly as shown below.

  • missing
  • unmeasured
  • not-measured
  • nm
  • unknown
  • unk
  • na

Example Files are here:

  • APDV File Examples

    Three Dimensional Analyte Point Data File Example An actual .apdv file could look like the following: X Y ELEV @@1-DCA 1-DCE TCE VC SITE_ID Top Elevation feet 50 4 mg/kg ug/kg ug/kg mg/kg 12008 12431 22.9 22 missing 500 <0.01 CSB-39 30.4 12008 12431 18.9 <0.01 <0.01 2800 <0.01 CSB-39 30.4 12008 12431 13.4 <0.01 <0.01 290 <0.01 CSB-39 30.4 12008 12431 8.4 <0.01 <0.01 9.7 <0.01 CSB-39 30.4 12008 12431 7.9 <0.01 <0.01 23 <0.01 CSB-39 30.4 12008 12431 1.9 <0.01 <0.01 24 <0.01 CSB-39 30.4 11651 13184 28.5 <0.01 <0.01 <0.01 <0.01 CSB-40 30 11651 13184 26 <0.01 <0.01 <0.01 <0.01 CSB-40 30 11427 12781 28.8 0.28 0.02 0.78 <0.01 CSB-42 30.8 11427 12781 24.8 <0.01 0.02 0.76 <0.01 CSB-42 30.8 11427 12781 17.3 <0.01 <0.01 0.01 <0.01 CSB-42 30.8 11427 12781 14.6 <0.01 <0.01 0.01 <0.01 CSB-42 30.8 11427 12781 9.8 <0.01 <0.01 <0.01 <0.01 CSB-42 30.8 11427 12781 3.3 0.64 0.14 1.5 0.19 CSB-42 30.8 11410 12725 29.6 0.01 <0.01 0.01 <0.01 CSB-43 30.6 11410 12725 23.6 0.08 <0.01 0.02 <0.01 CSB-43 30.6 11410 12725 21.6 0.04 <0.01 0.01 <0.01 CSB-43 30.6 11410 12725 12.1 0.1 <0.01 <0.01 0.13 CSB-43 30.6 11410 12725 6.1 0.06 <0.01 <0.01 0.05 CSB-43 30.6 11417 12819 28.2 0.01 <0.01 0.03 <0.01 CSB-44 30.2 11417 12819 24.2 0.04 <0.01 0.04 <0.01 CSB-44 30.2 11417 12819 16.2 0.43 0.04 0.04 <0.01 CSB-44 30.2 11417 12819 11.2 1.1 <0.01 <0.01 <0.01 CSB-44 30.2 11417 12819 9.2 <0.01 <0.01 <0.01 <0.01 CSB-44 30.2 11417 12819 6.2 <0.01 <0.01 <0.01 <0.01 CSB-44 30.2 11417 12819 2.2 0.06 <0.01 <0.01 <0.01 CSB-44 30.2 11402 12898 28.5 <0.01 <0.01 <0.01 <0.01 CSB-45 30.5 11402 12898 24.5 <0.01 <0.01 <0.01 <0.01 CSB-45 30.5 11402 12898 14.5 0.79 <0.01 1.7 <0.01 CSB-45 30.5 11402 12898 9 <0.01 <0.01 11 <0.01 CSB-45 30.5 11402 12898 2 0.18 <0.01 0.01 0.11 CSB-45 30.5 11260 12819 28.4 <0.01 <0.01 <0.01 <0.01 CSB-46 30.4 11260 12819 22.4 <0.01 <0.01 <0.01 <0.01 CSB-46 30.4 11260 12819 16.9 <0.01 <0.01 <0.01 <0.01 CSB-46 30.4 11260 12819 11.9 <0.01 <0.01 <0.01 <0.01 CSB-46 30.4 11260 12819 2.9 <0.01 <0.01 <0.01 <0.01 CSB-46 30.4 11340 12893 24.6 <0.01 <0.01 <0.01 <0.01 CSB-47 30.6 11340 12893 20.1 <0.01 <0.01 <0.01 <0.01 CSB-47 30.6 11340 12893 14.6 0.15 <0.01 <0.01 <0.01 CSB-47 30.6 11340 12893 9.1 <0.01 <0.01 <0.01 1.1 CSB-47 30.6 11340 12893 5.1 <0.01 <0.01 <0.01 <0.01 CSB-47 30.6 11249 12871 27.8 90 0.07 0.32 <0.01 CSB-48 29.8 11249 12871 23.3 0.16 <0.01 <0.01 <0.01 CSB-48 29.8 11249 12871 21.3 2.1 <0.01 <0.01 <0.01 CSB-48 29.8 11249 12871 13.3 <0.01 <0.01 <0.01 <0.01 CSB-48 29.8 11249 12871 8.3 <0.01 <0.01 <0.01 <0.01 CSB-48 29.8 11087 12831 28.3 <0.01 <0.01 0.01 <0.01 CSB-49 30.8 11087 12831 24.8 <0.01 <0.01 <0.01 <0.01 CSB-49 30.8 11087 12831 14.8 <0.01 <0.01 <0.01 <0.01 CSB-49 30.8 11087 12831 4.8 <0.01 <0.01 <0.01 <0.01 CSB-49 30.8 This file uses z coordinates (versus depth) for all samples, therefore line 2 has the word Elevation. There are 50 samples a<0.01 5 analytes (chemicals) per sample.

Subsections of APDV: Analyte Point Data File Format

Three Dimensional Analyte Point Data File Example

An actual .apdv file could look like the following:

XYELEV@@1-DCA1-DCETCEVCSITE_IDTop
Elevationfeet
504mg/kgug/kgug/kgmg/kg
120081243122.922missing500<0.01CSB-3930.4
120081243118.9<0.01<0.012800<0.01CSB-3930.4
120081243113.4<0.01<0.01290<0.01CSB-3930.4
12008124318.4<0.01<0.019.7<0.01CSB-3930.4
12008124317.9<0.01<0.0123<0.01CSB-3930.4
12008124311.9<0.01<0.0124<0.01CSB-3930.4
116511318428.5<0.01<0.01<0.01<0.01CSB-4030
116511318426<0.01<0.01<0.01<0.01CSB-4030
114271278128.80.280.020.78<0.01CSB-4230.8
114271278124.8<0.010.020.76<0.01CSB-4230.8
114271278117.3<0.01<0.010.01<0.01CSB-4230.8
114271278114.6<0.01<0.010.01<0.01CSB-4230.8
11427127819.8<0.01<0.01<0.01<0.01CSB-4230.8
11427127813.30.640.141.50.19CSB-4230.8
114101272529.60.01<0.010.01<0.01CSB-4330.6
114101272523.60.08<0.010.02<0.01CSB-4330.6
114101272521.60.04<0.010.01<0.01CSB-4330.6
114101272512.10.1<0.01<0.010.13CSB-4330.6
11410127256.10.06<0.01<0.010.05CSB-4330.6
114171281928.20.01<0.010.03<0.01CSB-4430.2
114171281924.20.04<0.010.04<0.01CSB-4430.2
114171281916.20.430.040.04<0.01CSB-4430.2
114171281911.21.1<0.01<0.01<0.01CSB-4430.2
11417128199.2<0.01<0.01<0.01<0.01CSB-4430.2
11417128196.2<0.01<0.01<0.01<0.01CSB-4430.2
11417128192.20.06<0.01<0.01<0.01CSB-4430.2
114021289828.5<0.01<0.01<0.01<0.01CSB-4530.5
114021289824.5<0.01<0.01<0.01<0.01CSB-4530.5
114021289814.50.79<0.011.7<0.01CSB-4530.5
11402128989<0.01<0.0111<0.01CSB-4530.5
114021289820.18<0.010.010.11CSB-4530.5
112601281928.4<0.01<0.01<0.01<0.01CSB-4630.4
112601281922.4<0.01<0.01<0.01<0.01CSB-4630.4
112601281916.9<0.01<0.01<0.01<0.01CSB-4630.4
112601281911.9<0.01<0.01<0.01<0.01CSB-4630.4
11260128192.9<0.01<0.01<0.01<0.01CSB-4630.4
113401289324.6<0.01<0.01<0.01<0.01CSB-4730.6
113401289320.1<0.01<0.01<0.01<0.01CSB-4730.6
113401289314.60.15<0.01<0.01<0.01CSB-4730.6
11340128939.1<0.01<0.01<0.011.1CSB-4730.6
11340128935.1<0.01<0.01<0.01<0.01CSB-4730.6
112491287127.8900.070.32<0.01CSB-4829.8
112491287123.30.16<0.01<0.01<0.01CSB-4829.8
112491287121.32.1<0.01<0.01<0.01CSB-4829.8
112491287113.3<0.01<0.01<0.01<0.01CSB-4829.8
11249128718.3<0.01<0.01<0.01<0.01CSB-4829.8
110871283128.3<0.01<0.010.01<0.01CSB-4930.8
110871283124.8<0.01<0.01<0.01<0.01CSB-4930.8
110871283114.8<0.01<0.01<0.01<0.01CSB-4930.8
11087128314.8<0.01<0.01<0.01<0.01CSB-4930.8

This file uses z coordinates (versus depth) for all samples, therefore line 2 has the word Elevation. There are 50 samples a<0.01 5 analytes (chemicals) per sample.

Another example using depths from the top surface is:

X CoordY CoordDepth@@TOTHCBoringTop
Depthfeet
371ppm
11856.7212764.011.057CSB_671.7
11856.7212764.018.134CSB_671.7
11856.7212764.0116.081CSB_671.7
11856.7212764.0120.292CSB_671.7
11856.7212764.0126.066CSB_671.7
11889.6012772.2021.762CSB_231.3
11889.6012772.204.853CSB_231.3
11889.6012772.207.941CSB_231.3
11889.6012772.201510.467CSB_231.3
11889.6012772.2016488.460CSB_231.3
11889.6012772.2022410.900CSB_231.3
11889.6012772.2026.140CSB_231.3
11939.1912758.456.175CSB_703.7
11939.1912758.4515.100CSB_703.7
11939.1912758.4518.430CSB_703.7
11939.1912758.4526.100CSB_703.7
12002.8012759.802.321CSB_241.2
12002.8012759.804.296CSB_241.2
12002.8012759.808.179CSB_241.2
12002.8012759.80130.000CSB_241.2
12002.8012759.8017.711CSB_241.2
12002.8012759.8023.864CSB_241.2
12002.8012759.8028.311CSB_241.2
12085.1512749.012.104CSW_714.6
12085.1512749.016.154CSW_714.6
12085.1512749.0116.732CSW_714.6
12085.1512749.0126.065CSW_714.6
12146.7012713.211.027CSB-722.1
12146.7012713.217.251CSB-722.1
12146.7012713.21231.176CSB-722.1
12199.7012709.802.043CSB-126.0
12199.7012709.804.055CSB-126.0
12199.7012709.808.031CSB-126.0
12199.7012709.8012.014CSB-126.0
12199.7012709.8016.018CSB-126.0
12199.7012709.8023.466CSB-126.0
12199.7012709.8027.197CSB-126.0

This file has 37 samples in 7 boreholes. Since depth below the top surface is used instead of “Z” coordinates, line 2 contains the word Depth. Note that in this example there is only one analyte (e.g. chemistry) (property) value per line, but up to 300 could be included in which case line three of the file would read “37 300” a<0.01 we would have 299 more columns of numbers in this file!.

A analyte (e.g. chemistry) fence diagram file has the exact same format, except that the samples from each boring must occur in the order of connectivity along the fence, a<0.01 they should be sorted by increasing depth at each sample location.

Discussion of analyte (e.g. chemistry) Files for Fence Sections

analyte (e.g. chemistry) files to be used to create fence diagrams using the older krig_fence module, must contain only those borings that the user wishes to include on an i<0.01ividual cross section of the fence, in the order that they will be connected along the section. The result is that one .apdv file is produced for each cross section that will be included in the fence diagram, a<0.01 the data for borings at which the fences will intersect are included in each of the intersecting cross section files. When geology is included on the fence diagrams, the order of the borings in the analyte (e.g. chemistry) files must be identical to those in the geology files for each section. Generally, it is easiest to create the analyte (e.g. chemistry) file for a complete dataset, a<0.01 then subset the fence diagram files from the complete file.

AIDV: Analyte Interval Data File Format

This format allows you to specify the top and bottom elevations of well screens and one or more concentrations that were measured over that interval. This new format (.aidv) will allow you to quickly visualize well screens in post_samples and automatically convert well screens to intelligently spaced samples along the screen interval for 3D (and 2D) kriging.

Format:

  • You may insert comment lines in C Tech Groundwater analyte (e.g. chemistry) (.aidv) input files.

    • Comment lines must begin with a ’#’ as the first character of a line.

Line 1: You may include any header message here (that does not start with a ’#’ character) unless you wish to include analyte names for use by other EVS modules (e.g. data component name). The format for line 1 to enable chemical names is as follows

A. Placing a pair of ’@’ symbols triggers the use and display of chemical names (example @@VOC). Any characters up to the @@ characters are ignored, and only the first analyte name needs @@, after that the chemical names must be delimited by spaces,

B. The following rules for commas are implemented to accommodate comma delimited files and also for using chemical names which have a comma within (example 1,1-DCA). Commas following a name will not become a part of the name, but a comma in the middle of a text string will be included in the name. The recommended approach is to put a space before the names.

C. If you want a space in your analyte name, you may use underscores and EVS will convert underscores to spaces (example: Vinyl_Chloride in a .aidv file will be converted to ’r;Vinyl Chloride." Or you may surround the entire name in quotation marks (example: “Vinyl Chloride”).

The advantages of using chemical names (attribute names of any type) are the following:

    • many modules use analyte names instead of data component numbers,
      • when writing EVS Field files (.eff, .efb, etc.), you will get analyte names instead of data component numbers.
      • when querying your data set with post_sample’s mouse interactivity, the analyte name is displayed.
      • time-series data can be used and the appropriate time-step can be displayed.

Line 2: Specifications

  • Elevation/Depth Specifier: The first item on line 2 must be the word Elevation or Depth (case insensitive) to denote whether well screen top and bottom elevations are true elevation or depth below ground surface.
  • Maximum Gap: The second parameter in this line is a real number (not an integer) specifying the Max-Gap. Max-gap is the maximum distance between samples for kriging. When a screen interval’s total length is less than max-gap, a single sample is placed at the center of the interval. If the screen interval is longer than max-gap, two or more equally spaced samples are distributed within the interval. The number of samples is equal to the interval divided by max-gap rounded up to an integer.
    • [note: if you set max gap too small, you effectively create over-sampling in z (relative to x-y) for your data. On the other hand, if you have multiple screen intervals with different z extents and depths, choosing the proper value for max-gap will ensure better 3D distributions. If max-gap is set very large, only one sample is placed at the center of each screen interval. If the screens are small relative to the thickness of the aquifer, a large max gap is OK. If the screens are long (30% or more) of the local thickness and there are nearby screens with different depths/lengths, you will need a smaller max-gap value. Viewing your screen intervals with the spheres ON will help assess the optimal value.
  • Coordinate Units: After Depth/Elevation, include the units of your coordinates (e.g. feet or meters)

Line 3: Specifications

  • The first integer (n) is the number of well screens (rows of data) to follow. You may specify “All” instead to use all data lines in the file.
  • The second integer is the number of analyte (chemistry) values per well screen.
  • The units of each data analyte column (e.g. ppm or mg/l).

Line 4: The first line of analyte interval (well screen) data must contain:

  • X
  • Y
  • Well Screen Top
  • Well Screen Bottom
  • (one or more) Analyte Value(s) (chemistry or property)
  • Well or Boring name. The boring name cannot contain spaces (recommend underscore “_” instead).
  • Elevation of the top of the boring.

Boring name and top are are optional parameters, but are used by many modules and it is highly recommended that you include this information in your file if possible. They are used by post_samples for posting tubes along borehole traces and for generating tubes which start from the ground surface of the borehole. Both 3d estimation and gridding and horizons will use this information to determing the Z spatial extent of your grids (gridding and horizons will create a layer that begins at ground surface if this information is provided). Numbers and names can be separated by one comma and/or any number of spaces or tabs.

BLANK ENTRIES (CELLS) ARE NOT ALLOWED.

Please see the section on Handling Non-Detects for information on how to deal with samples whose concentration is below the detection limit. For any sample that is not detected you may enter any of the following. Please note that the first three flag words are not case sensitive, but must be spelled exactly as shown below.

  • Prepend a less than sign < to the actual detection limit for that sample. This allows you to set the “Less Than Multiplier” in all modules that read .apdv files to a value such as 0.1 to 0.5 (10 to 50%). This is the preferred and most rigorous method.
  • nondetect
  • non-detect
  • nd
  • 0.0 (zero)

For files with multiple analytes such as the example below, if an analyte was not measured at a sample location, use any of the flags below to denote that this sample should be skipped for this analyte. Please note that these flag words are not case sensitive, but must be spelled exactly as shown below.

  • missing
  • unmeasured
  • not-measured
  • nm
  • unknown
  • unk
  • na

Example Files are here:

Subsections of AIDV: Analyte Interval Data File Format

An actual .aidv file could look like the following:

This is a comment line….any line that starts with # is ignored

XYZtopZbot@@TOTHCBoreTop
Elevation6.0feet
101mg/l
11086.5212830.67-13-262.000W-494.5
11199.0412810.16-18-302.000W-514
11298.0012808.63-12-383600.W-523
11566.3412850.59-14-250.000W-307.5
11251.3012929.27-24-3033000W-752
11248.7512870.91-17-225004.8W-483
11340.4912892.61-11-16120.0W-472.5
11340.4912892.61-22-28320.0W-472.5
11338.0012830.80-13-20640.0W-384
11401.7312897.77-36-40<0.300W-454

This example file above (10_well_screens.aidv) has 10 well screens in 9 boreholes. Well W-47 has two different screen intervals. Note that line 2 contains the word Elevation and the number 6.0 which is the max-gap parameter. There are 10 rows of data and there is only one analyte value per line, but up to 300 could be included in a single file.

Analyte Time Files Format

Discussion of Analyte Time Files

Analyte time files contain 3-D coordinates (x, y, z) describing the locations of samples and values of one or more analytes or properties taken over a series of different times. Time files must conform to the ASCII formats described below and individual entries (coordinates or measurements) can be delimited by commas, spaces, or tabs. They must have either a .sct (Soil Chemistry Time) or .gwt (Ground Water Time) suffix to be selected in the file browsers of EVS modules. Each line of the file contains the coordinate data for one sampling location, or well screen, and any number of chemistry or property values. There are no limits on the number of borings and/or samples that can be included in these files, except that run times for execution of kriging do increase with a greater number of samples in the file.

Time data can be visualized independently (without geology data) or within a domain bounded by a geologic system. When a geologic domain is utilized for a 3-D visualization, a consistent coordinate system (the same projection and overlapping spatial extents) must be used for both the chemistry and geology. The boring and sample locations in the time files do not have to correspond to those in the geology files, except that only those contained within or proximal to the spatial domain of the geology will be used for the kriging.

If the posting of borings and sample locations are to honor the topography of the site, the chemistry files also must contain the top surface elevation of each boring.

Format:

You may insert comment lines anywhere in Analyte time files. Comments must begin with a ‘#’ character. The line numbers that follow refer to all non-commented lines in the file.

The format of chemistry time files is substantially different from other analyte file formats (.apdv or .aidv) used in EVS. These differences includerequiredanalyte name and unitson line one (no other information allowed), and no need to specify the number of samples or number of analytesandtimes.

Line 1: This line contains the name of each analyte. After every analyte has been listed the analyte units are then required for each analyte. Analyte Units are REQUIRED for time chemistry files.

Line 2: This line contains the mapping of the analytes to a specific date. This is done by listing the analyte name followed by a pipe character “|” and then followed by the sampling date. There should be one of these mappings for every column of data in the file. If you want a space in your analyte name you may enclose the entire name and date in quotation marks (example: “Vinyl Chloride|6/1/2004”). Optionally the analyte name may be omitted and just a date used, in this case the first analyte name listed on line one will be used.

It is required that the order of analyte-date columns be from oldest to newest for each analyte.

The date format is dependent on your REGIONAL SETTINGS on your computer (control panel).

C Tech uses the SHORT DATE and SHORT TIME formats.

If the date/time works in Excel it will likely work in EVS.

For most people in the U.S., this would not be 24 hour clock so you would need:

“m/d/yyyy hh:mm:ss AM” or “m/d/yyyy hh:mm:ss PM”

Also, you MUST put the date/time in quotes if you use more than just date (i.e. if there are spaces in the total date/time).

Line 3: This line must contain the word Elevation or Depth to denote whether sample elevations are true elevation or depth below ground surface. If actual elevations are used (a right-handed coordinate system), then this parameter should be Elevation; if depths below the top surface elevation are used, then this parameter should be Depth.

FOR GWT FILESONLY:the second parameter in this line is a real number (not an integer) specifying the Max-Gap in the same units as your coordinate data. Max-gap is the maximum distance between samples for kriging. When a screen interval’s total length is less than max-gap, a single sample is placed at the center of the interval. If the screen interval is longer than max-gap, two or more equally spaced samples are distributed within the interval. The number of samplesis equal to theinterval divided by max-gap roundedupto an integer.

The last value on this line should be the units of your coordinates (e.g. feet or meters), or the flag word reproject.

Lines 4+: The lines of sample data:The content of these lines varies whether the files is a SCT or GWT file. GWT files have an additional column of elevation (Z) data to allow for specification of the top and bottom of each screen interval, whereas SCT files specify the location of a POINT sample (requiring only a single elevation).

X, Y, Z (for Chemistry files or Well Screen Top), Well Screen Bottom for groundwater chemistry files) , (one or more) Analyte Value(s) (chemistry or property), Boring name, and Elevation of the Top Of The Boring (optional).

There are several flag words available for missing values these include:

  1. unmeasured
  2. not-measured
  3. nm
  4. missing
  5. unknown
  6. unk
  7. na

For non-detect samples the following flag words are available:

  1. Prepend a less than sign < to the actual detection limit for that sample. This allows you to set the “Less Than Multiplier” in all modules that read .apdv files to a value such as 0.1 to 0.5 (10 to 50%). This is the preferred and most rigorous method.
  2. nondetect or
  3. non-detect
  4. nd

The boring name cannot contain spaces (recommend underscore “_” instead), unless surrounded by quotation marks (example: “B 1”). The optional boring name and top are needed only by the post_samples module for posting tubes along borehole traces and for generating tubes which start from the ground surface of the borehole. Numbers and names can be separated by one comma and/or any number of spaces or tabs.BLANK ENTRIES (CELLS) ARE NOT ALLOWED.

When Top of Boring elevations are given, they must be provided for all lines of the file.

#Soil Chemistry Time File Example (SCT)

“ethane"“ethylene"“mg/kg"“ug/kg”

“ethane|6/8/1976"“ethylene|6/8/1976"“ethane|1/12/1979” “ethylene|1/12/1979” “ethylene|3/16/1981”

Elevation meters

12008 12431 22.9 22 Unk 21 500 0 CSB-39 30.4

11271 13105 18.9 0 0 0 2800 0 CSB-40 35.9

10652 13857 23.4 0 0 0 290 0 CSB-41 28.1

9904 14522 18.4 0 0 0 Unk Unk CSB-42 22.8

9029 15283 37.9 0 0 0 23 0 CSB-43 30.1

For the GWT file below, those items that are unique to GWT (vs. SCT) are in BLUE.

#Ground WaterChemistry Time File Example (GWT)

“ethane"“ethylene"“mg/kg"“ug/kg”

“ethane|6/8/1976"“ethylene|6/8/1976"“ethane|1/12/1979” “ethylene|1/12/1979” “ethylene|3/16/1981”

Elevation3.0meters

12008 12431 22.9 15.2 22 Unk 21 500 0 CSB-39 30.4

11271 13105 18.9 12.5 0 0 0 2800 0 CSB-40 35.9

10652 13857 23.4 19.0 0 0 0 290 0 CSB-41 28.1

9904 14522 18.4 11.8 0 0 0 Unk Unk CSB-42 22.8

9029 15283 37.9 30.3 0 0 0 23 0 CSB-43 30.1

  • Time Domain Analyte Data

    We recommend that analyte files which represent data collected over time use either the APDV or AIDV format and include data for only a single analyte

  • Time Domain AIDV Example File

    | x | y | ztop | zbot | @@1/1/2001 | 5/1/2001 | 8/1/2001 | 11/1/2001 | 7/1/2002 | Site ID | Ground | | — | — | — | — | — | — | — | — |

  • Analyte Time Files (.sct and .gwt) Format

    Analyte Time Files Format Discussion of Analyte Time Files Analyte time files contain 3-D coordinates (x, y, z) describing the locations of samples and values of one or more analytes or properties taken over a series of different times. Time files must conform to the ASCII formats described below and individual entries (coordinates or measurements) can be delimited by commas, spaces, or tabs. They must have either a .sct (Soil Chemistry Time) or .gwt (Ground Water Time) suffix to be selected in the file browsers of EVS modules. Each line of the file contains the coordinate data for one sampling location, or well screen, and any number of chemistry or property values. There are no limits on the number of borings and/or samples that can be included in these files, except that run times for execution of kriging do increase with a greater number of samples in the file.

Subsections of Time Domain Analyte Data

We recommend that analyte files which represent data collected over time use either the APDV or AIDV format and include data for only a single analyte

We do not recommend using the SCT or GWT formats.

When using APDV or AIDV files for time domain data, the following rules apply:

  • Include data for only a single analyte
  • Group measurements taken over a few days or even weeks into the same DATE GROUP. If your entire site is re-sampled every 3 months, do not separately list each day when a particular well is sampled.
  • The “analyte name” for each column of data representing a Date Group should be the average date for that sampling event. The date must be in the Windows standard short date format. In the United States that is typically MM/DD/YYYY (e.g. 11/08/2003 for November 8, 2003)
  • The data file cannot specify the actual analyte name (e.g. benzene). However, the modules which deal with time domain data have the ability to specify the actual name and units.
  • Date groups need not be at equal time intervals.
xyztopzbot@@1/1/20015/1/20018/1/200111/1/20017/1/2002Site IDGround
Elevation10m
985mg/lmg/lmg/lmg/lmg/l
2772536.7331635.8886.5866.565555805-I1025.1
2772554.6331635.2987.4967.40.715555805-S1025.2
2772601.5333091.7862.1852.10.7155555011038.0
2772610.4333100.5950.6930.60.7111124171038.5
2772830.1336800.0853.5833.51901301251201108091018.8
2772982.4333214.1955.3935.3555554101035.3
2773014.8331825.0954.0934.0180nmnmnmnm811-I1032.0
2773014.8331825.0881.9861.9150nmnmnmnm811-S1031.9
2773069.9332631.8888.1868.135364050605101036.7
2773076.0332138.7959.5949.54848556155602-D1035.3
2773087.1332138.3994.4974.40.7111055602-S1035.6
2773091.3332611.7784.4684.4555557111037.2
2773104.2332134.5887.6867.64404805005203007081035.3
2773129.1332136.9736.0686.00.7155558061036.0
2773146.2333741.7862.5842.53003302402401208031040.5
2773149.9333225.71020.1990.1265025002350220020504131038.0
2773156.3333244.41017.8987.8750690135002600038500RW-11038.3
2773156.6333219.81002.0982.0200200200200200210-41038.5
2773157.7333579.1946.1941.10.712555212-21039.8
2773159.4333587.11006.4986.40.7111117141038.2
2773165.1333262.31013.1993.11000010000300004900068000P-21037.7
2773182.8333309.71009.2989.24500043000535006400074500P-31038.9
2773192.1333368.0796.2779.2555554021038.5
2773192.5333361.4870.7853.7191122847307-81038.7
2773196.2333647.9936.4921.42910013017010061039.3
2773236.4333568.81016.61016.6109nmnmnmLN-1D1038.6
2773253.6333567.21017.01017.0800800770780800LN-31039.6
2773266.3335344.6908.3888.36nmnmnmnm813-I1052.3
2773290.3335351.9833.0813.0610nmnmnmnm813-S1056.0
2773307.6333207.61005.5985.52000190015001200910206-41042.3
2773308.9333198.4945.6940.6180180200220240206-21042.0
2773323.3333554.51016.3996.375051077001480021900P-41038.8
2773324.5333353.1947.0942.0750750675610545207-21039.3
2773325.8333349.21009.5989.510091857970207-41038.9
2773326.6333529.31012.4992.4110010008106104104121038.6
2773328.0333518.51021.11001.1800730700650600208-41038.1
2773439.9333202.0994.0974.09088806040202-41039.4
2773441.7333077.61009.3989.3410410400380360201-41041.4
2773446.4333203.9946.0941.055555202-21039.6
2773457.6333081.2890.2870.24003802752501257051040.5
2773462.8333364.41000.7980.7110001100010550101009650203-41039.3
2773477.3333524.2941.8936.855555204-21039.5
2773480.4333449.21010.0980.0700066005750490040504111039.1
2773480.5333522.51006.9986.9350350375410445204-41038.8
2773482.1333669.2946.5931.50.711555D1038.3
2773541.1333784.9876.4826.4230240290390nmRW-3051038.4
2773570.2333713.21013.2989.90.711551600305-S1037.3
2773571.6333770.9853.5833.5100110160200500305-D1038.7
2773572.2332825.61008.8988.825262729315091043.7
2773573.4332844.1903.4883.41251201752503757031042.7
2773575.8333740.1738.3688.30.7155558041038.3
2773620.0332116.71019.5996.555555601-S1041.5
2773630.2332116.9959.4939.411555601-D1041.3
2773663.4332966.11003.8983.8700610625650725709-S1042.0
2773672.4332971.5889.9869.97565240420600709-D1041.7
2773688.4332956.9743.3693.3555558021043.3
2773689.4333385.8997.9977.9370190420480500101-41039.2
2773692.6333066.4882.0862.0800750950120011008011042.0
2773708.8333065.21007.8987.82500002200002600003000003400004061041.7
2773713.9333494.8860.6849.11002701902303903061039.7
2773714.1333523.81006.5986.53636353534102-41039.3
2773717.9333532.7941.2936.23131302827102-21038.7
2773730.5331660.3906.0886.00.71nmnmnmnm812-S1056.0
2773732.8331687.1950.3930.30.71nmnmnmnm812-I1028.3
2773735.5333543.7784.5734.50.7155557121037.8
2773760.8333319.1936.3931.388888100-21038.8
2773763.3333330.4997.1977.15926257805563485489053433100-41038.8
2773765.6333309.41013.0963.07708208907001200401-B1039.5
2773797.1333060.91008.8988.897979590854051041.6
2773899.9333080.3967.1957.11012121213706-S1041.2
2773902.7333097.7915.8905.859121518706-D1040.8
2774022.9333742.9882.9832.9469577120160RW-99D1035.2
2774033.8333513.5986.9974.922222301-D1038.5
2774051.8333512.91027.51005.521002100210025002800301-S1038.7
2774065.2333730.6983.5963.552505677RW-99S1035.0
2774073.1333738.4858.5838.50.710.713354031036.5
2774073.7334671.8947.1937.10.711455503-S1025.1
2774076.5333728.3823.7823.70.7122224151036.4
2774083.0332103.9866.4856.498851001201507011038.3
2774085.3333736.6996.9973.51625371725303-S1036.2
2774087.2334674.8792.4782.42220191915503-D1024.4
2774094.7333745.8936.3924.51614508150303-D1034.8
2774186.2331604.2873.9853.90.7155558101023.9
2774187.3333087.0911.3891.316222527357041041.6
2774194.8333100.9973.6953.6555554081042.1
2774324.1334101.7922.3912.30.71155nm414-I1032.2
2774332.3333623.1881.4861.40.7135557021038.7
2774338.3333327.8998.8981.50.7125553001040.2
2774341.9333638.31022.6999.4555553021039.3
2774344.3333870.5862.2852.2556345021036.3
2774352.8333882.0898.1888.10.7114134161036.0
2774664.2334463.8845.0835.00.711555504-D1018.0
2774677.0334462.1961.0951.0130120135150165504-S1018.0
2774820.0333352.3883.5863.50.7155555061039.4
2774995.8336287.5694.9644.90.715555807-D994.9
2774995.9336310.6831.8811.83031343744807-I994.8
2775092.1334397.8946.4936.41091010105051031.3
2777126.6336231.0809.7789.70.7155558081028.7

Analyte Time Files Format

Discussion of Analyte Time Files

Analyte time files contain 3-D coordinates (x, y, z) describing the locations of samples and values of one or more analytes or properties taken over a series of different times. Time files must conform to the ASCII formats described below and individual entries (coordinates or measurements) can be delimited by commas, spaces, or tabs. They must have either a .sct (Soil Chemistry Time) or .gwt (Ground Water Time) suffix to be selected in the file browsers of EVS modules. Each line of the file contains the coordinate data for one sampling location, or well screen, and any number of chemistry or property values. There are no limits on the number of borings and/or samples that can be included in these files, except that run times for execution of kriging do increase with a greater number of samples in the file.

Time data can be visualized independently (without geology data) or within a domain bounded by a geologic system. When a geologic domain is utilized for a 3-D visualization, a consistent coordinate system (the same projection and overlapping spatial extents) must be used for both the chemistry and geology. The boring and sample locations in the time files do not have to correspond to those in the geology files, except that only those contained within or proximal to the spatial domain of the geology will be used for the kriging.

If the posting of borings and sample locations are to honor the topography of the site, the chemistry files also must contain the top surface elevation of each boring.

Format:

You may insert comment lines anywhere in Analyte time files. Comments must begin with a ‘#’ character. The line numbers that follow refer to all non-commented lines in the file.

The format of chemistry time files is substantially different from other analyte file formats (.apdv or .aidv) used in EVS. These differences includerequiredanalyte name and unitson line one (no other information allowed), and no need to specify the number of samples or number of analytesandtimes.

Line 1: This line contains the name of each analyte. After every analyte has been listed the analyte units are then required for each analyte. Analyte Units are REQUIRED for time chemistry files.

Line 2: This line contains the mapping of the analytes to a specific date. This is done by listing the analyte name followed by a pipe character “|” and then followed by the sampling date. There should be one of these mappings for every column of data in the file. If you want a space in your analyte name you may enclose the entire name and date in quotation marks (example: “Vinyl Chloride|6/1/2004”). Optionally the analyte name may be omitted and just a date used, in this case the first analyte name listed on line one will be used.

It is required that the order of analyte-date columns be from oldest to newest for each analyte.

The date format is dependent on your REGIONAL SETTINGS on your computer (control panel).

C Tech uses the SHORT DATE and SHORT TIME formats.

If the date/time works in Excel it will likely work in EVS.

For most people in the U.S., this would not be 24 hour clock so you would need:

“m/d/yyyy hh:mm:ss AM” or “m/d/yyyy hh:mm:ss PM”

Also, you MUST put the date/time in quotes if you use more than just date (i.e. if there are spaces in the total date/time).

Line 3: This line must contain the word Elevation or Depth to denote whether sample elevations are true elevation or depth below ground surface. If actual elevations are used (a right-handed coordinate system), then this parameter should be Elevation; if depths below the top surface elevation are used, then this parameter should be Depth.

FOR GWT FILESONLY:the second parameter in this line is a real number (not an integer) specifying the Max-Gap in the same units as your coordinate data. Max-gap is the maximum distance between samples for kriging. When a screen interval’s total length is less than max-gap, a single sample is placed at the center of the interval. If the screen interval is longer than max-gap, two or more equally spaced samples are distributed within the interval. The number of samplesis equal to theinterval divided by max-gap roundedupto an integer.

The last value on this line should be the units of your coordinates (e.g. feet or meters), or the flag word reproject.

Lines 4+: The lines of sample data:The content of these lines varies whether the files is a SCT or GWT file. GWT files have an additional column of elevation (Z) data to allow for specification of the top and bottom of each screen interval, whereas SCT files specify the location of a POINT sample (requiring only a single elevation).

X, Y, Z (for Chemistry files or Well Screen Top), Well Screen Bottom for groundwater chemistry files) , (one or more) Analyte Value(s) (chemistry or property), Boring name, and Elevation of the Top Of The Boring (optional).

There are several flag words available for missing values these include:

  1. unmeasured
  2. not-measured
  3. nm
  4. missing
  5. unknown
  6. unk
  7. na

For non-detect samples the following flag words are available:

  1. Prepend a less than sign < to the actual detection limit for that sample. This allows you to set the “Less Than Multiplier” in all modules that read .apdv files to a value such as 0.1 to 0.5 (10 to 50%). This is the preferred and most rigorous method.
  2. nondetect or
  3. non-detect
  4. nd

The boring name cannot contain spaces (recommend underscore “_” instead), unless surrounded by quotation marks (example: “B 1”). The optional boring name and top are needed only by the post_samples module for posting tubes along borehole traces and for generating tubes which start from the ground surface of the borehole. Numbers and names can be separated by one comma and/or any number of spaces or tabs.BLANK ENTRIES (CELLS) ARE NOT ALLOWED.

When Top of Boring elevations are given, they must be provided for all lines of the file.

#Soil Chemistry Time File Example (SCT)

“ethane"“ethylene"“mg/kg"“ug/kg”

“ethane|6/8/1976"“ethylene|6/8/1976"“ethane|1/12/1979” “ethylene|1/12/1979” “ethylene|3/16/1981”

Elevation meters

12008 12431 22.9 22 Unk 21 500 0 CSB-39 30.4

11271 13105 18.9 0 0 0 2800 0 CSB-40 35.9

10652 13857 23.4 0 0 0 290 0 CSB-41 28.1

9904 14522 18.4 0 0 0 Unk Unk CSB-42 22.8

9029 15283 37.9 0 0 0 23 0 CSB-43 30.1

For the GWT file below, those items that are unique to GWT (vs. SCT) are in BLUE.

#Ground WaterChemistry Time File Example (GWT)

“ethane"“ethylene"“mg/kg"“ug/kg”

“ethane|6/8/1976"“ethylene|6/8/1976"“ethane|1/12/1979” “ethylene|1/12/1979” “ethylene|3/16/1981”

Elevation3.0meters

12008 12431 22.9 15.2 22 Unk 21 500 0 CSB-39 30.4

11271 13105 18.9 12.5 0 0 0 2800 0 CSB-40 35.9

10652 13857 23.4 19.0 0 0 0 290 0 CSB-41 28.1

9904 14522 18.4 11.8 0 0 0 Unk Unk CSB-42 22.8

9029 15283 37.9 30.3 0 0 0 23 0 CSB-43 30.1

Pre Geology File: Lithology

The ASCII pregeology file name must have a .pgf suffix to be selected in the module’s file browser. This file type represents raw (uninterpreted) 3D boring logs representing lithology. This format is used by:

  • create stratigraphic hierarchy

  • post_samples

  • gridding and horizons (to extract a top and bottom surface to build a single layer)

  • lithologic modeling for Geologic Indicator Kriging (GIK).

  • adaptive_indicator_krig

  • You may insert comment lines in .pgf files.

    • Comment lines must begin with a ’#’ as the first character of a line.

The pre-geology file format is used to represent raw 3D boring logs. We also refer to this geologic data format as “uninterpreted”. This is not meant to imply that no form of geologic evaluation or interpretation has occurred. On the contrary, it is required that someone categorizes the materials on the site and in each boring.

Data Concept:

  • A PGF file can be considered a group of file sections where each section represents the lithology for individual borings (wells).

  • It is essential to use the same ID for the ground surface (first line) as for the bottom of the first observed material (second line) in each section (boring). If a different material ID is used a synthetic point will be added between the ground and first observed material. This will be reported for the first five occurrences.

    • Think about the PGF file as a shorthand way of specifying intervals. The first line is the FROM. The second is the TO.
  • Please note that the data for each boring must be sorted (by you) from beginning to end (normally top to bottom).

  • We cannot sort this data for you because some borings may turn to horizontal or even upwards.

    • It is your responsibility to make sure that the data is in the proper order.
    • It is your responsibility to make sure that each boring ID corresponds to a unique X, Y location if there would be overlapping Z (or depth) intervals. In other words, there cannot be overlapping boring definitions.
    • If the data is unsorted, and within a boring the direction between two values varies by more than 90 degrees, an error will be reported.

FILE FORMAT:

  • Line 1: May contain any header message, but cannot be left blank or commented. There is no information content in this line.
  • Line 2: Line 2 contains the declaration of Elevation or Depth, the definitions of Lithology IDs and Names, and coordinate units.
    • Elevation/Depth Specifier: This line must contain the word Elevation or Depth (case insensitive) to specify whether well screen top and bottom elevations are true elevation or depth below ground surface.
        • Depth forces the otherwise optional ground surface elevation column to be required. Depths given in column 3 are distances below the ground surface elevation in the last column (column 6). If the top surface is omitted, a value of 0.0 will be assumed and a warning message will be printed to the EVS Information Window.
      • IDs and Names: Line 2 should contain Lithology IDs and corresponding names for each material. Each Name is explicitly associated with its corresponding Lithology ID and the pairs are delimited by a pipe symbol “|”.
        • Though it is generally advisable, IDs need not be sequential and may be any integer values. This allow for a unified set of Lithology IDs and Names to be applied to a large site where models create for sub-sites may not have all materials.

          • The number of (material) IDs and Names MUST be equal to the number of Lithology IDs specified in the data section. Each material ID present in the data section must have corresponding Lithology IDs and Names. If there are four materials represented in your .pgf file, there should be at least four IDs and Names on line two.
          • The order of Lithology IDs and Names will determine the order that they appear in legends. The IDs do not need to be sequential.
          • You can specify additional IDs and Names, which are not in the data and those will appear on legends.
      • Coordinate Units: You should include the units of your coordinates (e.g. feet or meters). If this is included it must follow the names associated with each Lithology ID.
  • Line 3: Must be the number of lines of data (n) to follow. For each boring, there is one line for the ground surface and one line for the bottom of each observed lithologic unit. Therefore the total number of lines in the file should be equal to the number of borings PLUS the sum of the number of materials observed in each boring.
  • Line 4: First line of sample data. X, Y, Z, “Lithology ID”, Boring name, and Ground surface elevation. The Ground surface elevation is an optional parameter which is required if Depth is specified on line 2. If depths are used (instead of elevations) the top surface should be in the same coordinate system. Depths are relative to the Ground surface (which is assumed at 0.0 if the Ground surface is not defined). The boring name cannot contain spaces unless the entire name is surrounded in quotation marks (example “Boring 1D”). One comma and/or any number of spaces or tabs can separate numbers and name.
  • Line 3+n: is the last line of the file.

AN EXAMPLE FILE FOLLOWS:

Pregeologyfile
Elevation1Silt2Fill3Clay
17
11086.512830.74.51B-49
11086.512830.7-3.81B-49
11086.512830.7-212B-49
11086.512830.7-263B-49
11086.512830.7-424B-49
11086.512830.7-555B-49
111991260041B-51
1119912600-51B-51
1119912600-202B-51
1119912600-253B-51
1119912600-394B-51
1119912600-535B-51
11259.712819.321B-46
11259.712819.3-7.51B-46
11259.712819.3-273B-46
11259.712819.3-404B-46
11259.712819.3-535B-46
  • PGF File Examples

    In the (very short) example file below, please note that the Lithology IDs and Names are not ordered by increasing ID number. The order that you speci

  • PGF File Example with Depth

    Easting Northing Depth Lithology_ID Boring_ID Ground

Subsections of PGF: Pre Geology File Lithology

In the (very short) example file below, please note that the Lithology IDs and Names are not ordered by increasing ID number. The order that you specify the Lithology IDs and Names determines the order that is used for exploding the lithologic materials and the ordering in legends. Also notice that Lithology ID 3 is specified in line 2, but not present in the data. Silty-Sand will be shown in the legend, but will not be present in the borings displayed with post_samples nor any model created with this data.

EAST NORTH TOP-BOT MATERIAL-ID WELL_ID

Elevation 4|Sand 5|Gravel 1|Clay 2|Silt 3|Silty-sand meters

11

2085487.12 322869.95 31 4 AW-3

2085487.12 322869.95 -1 4 AW-3

2085487.12 322869.95 -3 2 AW-3

2085108.47 323363.89 32 4 MW-10A

2085108.47 323363.89 20 4 MW-10A

2085108.47 323363.89 12 5 MW-10A

2085079.22 323361.25 32 4 MW-10B

2085079.22 323361.25 20 4 MW-10B

2085266.93 323410.05 32 4 MW-11A

2085266.93 323410.05 14 4 MW-11A

2085266.93 323410.05 7 1 MW-11A

In the realistic example below, IDs are listed in ascending order and this order on Line 2 will be the order used for exploding materials and legends.

Pre-Geology File for Initial Painting Facility soil investigation
Elevation1Silt
144
11086.512830.74.5
11086.512830.7-3.8
11086.512830.7-21.0
11086.512830.7-26.0
11086.512830.7-42.0
11086.512830.7-55.0
11199.012810.24.0
11199.012810.2-5.0
11199.012810.2-20.0
11199.012810.2-25.0
11199.012810.2-39.0
11199.012810.2-53.0
11259.712819.32.0
11259.712819.3-7.5
11259.712819.3-20.5
11259.712819.3-27.0
11259.712819.3-40.0
11259.712819.3-53.0
11298.012808.63.0
11298.012808.6-6.0
11298.012808.6-19.0
11298.012808.6-25.8
11298.012808.6-41.8
11298.012808.6-55.0
11414.412781.12.0
11414.412781.1-6.0
11414.412781.1-20.5
11414.412781.1-28.0
11414.412781.1-42.0
11414.412781.1-55.0
11427.012780.96.5
11427.012780.9-7.0
11427.012780.9-23.0
11427.012780.9-28.5
11427.012780.9-38.5
11427.012780.9-51.0
11496.312753.61.5
11496.312753.6-7.5
11496.312753.6-20.0
11496.312753.6-28.8
11496.312753.6-38.8
11496.312753.6-51.0
11209.412993.92.0
11209.412993.9-3.0
11209.412993.9-23.0
11209.412993.9-27.5
11209.412993.9-37.5
11209.412993.9-51.0
11251.312929.32.0
11251.312929.3-2.5
11251.312929.3-22.0
11251.312929.3-28.0
11251.312929.3-40.0
11251.312929.3-53.0
11248.812870.93.0
11248.812870.9-3.5
11248.812870.9-22.0
11248.812870.9-28.5
11248.812870.9-36.3
11248.812870.9-50.0
11211.912710.82.0
11211.912710.8-6.5
11211.912710.8-22.5
11211.912710.8-27.5
11211.912710.8-37.5
11211.912710.8-51.0
11302.013079.74.5
11302.013079.7-3.5
11302.013079.7-21.9
11302.013079.7-26.0
11302.013079.7-38.0
11302.013079.7-51.0
11286.813026.72.0
11286.813026.7-5.0
11286.813026.7-23.0
11286.813026.7-29.0
11286.813026.7-37.0
11286.813026.7-50.0
11309.012949.04.0
11309.012949.0-2.5
11309.012949.0-22.0
11309.012949.0-28.3
11309.012949.0-38.3
11309.012949.0-52.0
11340.512892.62.5
11340.512892.6-2.5
11340.512892.6-20.0
11340.512892.6-23.0
11340.512892.6-38.0
11340.512892.6-52.0
11338.012830.84.0
11338.012830.8-8.8
11338.012830.8-23.0
11338.012830.8-26.5
11338.012830.8-36.5
11338.012830.8-50.0
11393.512948.93.5
11393.512948.9-3.8
11393.512948.9-23.0
11393.512948.9-27.0
11393.512948.9-39.0
11393.512948.9-52.0
11401.712897.84.0
11401.712897.8-2.0
11401.712897.8-22.0
11401.712897.8-27.5
11401.712897.8-37.5
11401.712897.8-51.0
11416.912819.52.5
11416.912819.5-5.0
11416.912819.5-21.0
11416.912819.5-28.5
11416.912819.5-38.5
11416.912819.5-51.0
11381.712747.51.5
11381.712747.5-4.0
11381.712747.5-21.5
11381.712747.5-25.8
11381.712747.5-42.8
11381.712747.5-56.0
11410.312724.70.5
11410.312724.7-4.5
11410.312724.7-22.9
11410.312724.7-25.0
11410.312724.7-36.0
11410.312724.7-49.0
11566.312850.62.5
11566.312850.6-5.0
11566.312850.6-21.0
11566.312850.6-28.5
11566.312850.6-38.5
11566.312850.6-51.0
11586.313050.611.5
11586.313050.61.0
11586.313050.6-11.0
11586.313050.6-18.5
11586.313050.6-26.5
11586.313050.6-47.0
11086.313090.68.5
11086.313090.6-1.0
11086.313090.6-14.0
11086.313090.6-23.5
11086.313090.6-32.5
11086.313090.6-48.0

Easting Northing Depth Lithology_ID Boring_ID Ground

Depth 0|Overburden 1|Lava 2|Sulfide 3|Rhyolite 4|Mafic_Intrusion m

29

192731.10 1389503.04 0.00 0 1 2132.53

192731.10 1389503.04 6.75 0 1 2132.53

192731.10 1389503.04 101.00 1 1 2132.53

192731.10 1389503.04 383.10 3 1 2132.53

192731.10 1389503.04 403.70 2 1 2132.53

192731.10 1389503.04 490.00 4 1 2132.53

192674.55 1389639.67 0.00 0 22 2126.28

192674.55 1389639.67 4.30 0 22 2126.28

192674.55 1389639.67 100.60 1 22 2126.28

192674.55 1389639.67 156.00 3 22 2126.28

192674.55 1389639.67 209.40 2 22 2126.28

192674.55 1389639.67 496.20 4 22 2126.28

192987.12 1389624.87 0.00 0 13 2130.64

192987.12 1389624.87 6.98 0 13 2130.64

192987.12 1389624.87 91.40 1 13 2130.64

192987.12 1389624.87 397.40 2 13 2130.64

192987.12 1389624.87 425.80 4 13 2130.64

192930.95 1389745.48 0.00 0 14 2128.68

192930.95 1389745.48 6.70 0 14 2128.68

192930.95 1389745.48 80.40 1 14 2128.68

192930.95 1389745.48 246.40 3 14 2128.68

192930.95 1389745.48 250.60 2 14 2128.68

192930.95 1389745.48 459.60 4 14 2128.68

192582.47 1389677.63 0.00 0 23 2123.62

192582.47 1389677.63 6.80 0 23 2123.62

192582.47 1389677.63 101.20 1 23 2123.62

192582.47 1389677.63 138.70 3 23 2123.62

192582.47 1389677.63 160.00 2 23 2123.62

192582.47 1389677.63 499.60 4 23 2123.62

LPDV Lithology Point Data Value File Format

The LPDV lithology file format is the most general, free-form format to represent lithology information.

To understand the rationale for its existence, you must understand that when creating lithologic models (smooth or block) with lithologic modeling, the internal kriging operations require lithologic data in point format. Therefore all other lithology file formats (.PGF and .LSDV) are converted to points based on the PGF Refine Distance. LPDV files are not refined since we use the point data directly.

LPDV files have the following advantages and disadvantages:

  • Advantages

    • Is not based on borings or screens
    • It can represent surficial lithology data (material definitions at ground without depth)
    • LSDV formats can be converted to LPDV and merged with other LPDV data. This is done with this Tool

  • Disadvantages

    • Files tend to be larger since a single screen can represent many points
    • Displaying boring based data is more limited
    • LPDV files cannot be further refined.
      • If your points are too coarse or too fine, you cannot easily change this.

An explanation of the file format follows:

  • You may insert comment lines in .lpdv files.

    • Comment lines must begin with a ’#’ as the first character of a line.
  • Entries on lines can be separated by commas, spaces and/or tabs.

  • The First (uncommented) line:

    1. Must begin with Elevation or Depth
      • For the data section shown below, when Depth is specified, replace Z with Depth and columns 5 & 6 are required
    2. Then each material specified in the file is listed as: “Material^number^|Material^name^”
    3. The end of the line has the coordinate units (typically m [meters] or ft [feet]), OR the REPROJECT tag.
  • The next line begins the data section. You do not need to specify the number of data lines. The 9 entries in each line are all requiredand therefore must be:

    • Columns 1-3: X, Y, Z
    • Column 4: Material-number (these are integers which should begin with zero on line 1)
    • Column 5: Boring ID : OPTIONAL, however, if any line has this then all lines must have it.
    • Column 6: Ground Surface Elevation: OPTIONAL, however, it can only be included if Boring_ID is included and if any line has this then all lines must have it.

Below is a snippet of the file “lithology.lpdv” in the “Exporting Data to C Tech File Formats” folder of Studio Projects. This file was converted from lithology.lsdv.

Elevation “0|SAND” “1|SANDSTONE” “2|GRAVEL” “3|MUDSTONE” “4|LIMESTONE” “5|SILTSTONE” “6|MADEGROUND” “7|CONGLOMERATE” “8|GYPSUM” “9|CLAY” “10|SILT” m

736133.267249 1637594.558440 1190.194000 0 720B0001 1190.200000

736133.267249 1637594.558440 1189.806000 0 720B0001 1190.200000

736133.267249 1637594.558440 1189.794000 1 720B0001 1190.200000

736133.267249 1637594.558440 1189.006000 1 720B0001 1190.200000

736133.267249 1637594.558440 1188.206000 1 720B0001 1190.200000

736133.267249 1637594.558440 1188.194000 0 720B0001 1190.200000

736133.267249 1637594.558440 1187.806000 0 720B0001 1190.200000

736133.267249 1637594.558440 1187.794000 1 720B0001 1190.200000

736133.267249 1637594.558440 1187.256000 1 720B0001 1190.200000

736133.267249 1637594.558440 1186.706000 1 720B0001 1190.200000

736133.267249 1637594.558440 1186.694000 0 720B0001 1190.200000

736133.267249 1637594.558440 1186.156000 0 720B0001 1190.200000

736133.267249 1637594.558440 1185.606000 0 720B0001 1190.200000

736133.267249 1637594.558440 1185.594000 2 720B0001 1190.200000

736133.267249 1637594.558440 1184.906000 2 720B0001 1190.200000

736133.267249 1637594.558440 1184.206000 2 720B0001 1190.200000

736133.267249 1637594.558440 1184.194000 1 720B0001 1190.200000

736133.267249 1637594.558440 1183.453000 1 720B0001 1190.200000

736133.267249 1637594.558440 1182.706000 1 720B0001 1190.200000

736133.267249 1637594.558440 1181.959000 1 720B0001 1190.200000

736133.267249 1637594.558440 1181.206000 1 720B0001 1190.200000

736133.267249 1637594.558440 1181.194000 1 720B0001 1190.200000

LSDV Lithology Screen Data Value File Format

The LSDV lithology file format can be used as a more feature rich replacement for the older PGF format. It has the following advantages:

  • Fully supports non-vertical borings
  • Supports missing intervals and lithology data which does not begin at ground surface
  • Provides an Explicit definition of each lithologic interval

An explanation of the file format follows:

  • You may insert comment lines in .pgf files.

    • Comment lines must begin with a ’#’ as the first character of a line.
  • Any line beginning with # is a comment (in the file below, the first and third lines are comments and could be deleted without loss of function)

  • Entries on lines can be separated by commas, spaces and/or tabs.

  • The First (uncommented) line:

    1. Must begin with Elevation or Depth
      • For the data section shown below, when Depth is specified, replace Z with Depth
    2. Then each material specified in the file is listed as: “Material^number^|Material^name^”
    3. The end of the line has the coordinate units (typically m [meters] or ft [feet]), OR the REPROJECT tag.
  • The next line begins the data section. You do not need to specify the number of data lines. The 9 entries in each line are all requiredand therefore must be:

    • Columns 1-3: X, Y, Z
    • Columns 4-6: X, Y, Z
    • Column 7: Material-number (these are integers which should begin with zero on line 1)
    • Column 8: Boring ID
    • Column 9: Ground Surface Elevation
  • We cannot sort this data for you because some borings may turn to horizontal or even upwards.

    • It is your responsibility to make sure that the data is in the proper order.
    • It is your responsibility to make sure that each boring ID corresponds to a unique X, Y location if there would be overlapping Z (or depth) intervals. In other words, there cannot be overlapping boring definitions

Below is a snippet of the file “lithology.lsdv” in the “Exporting Data to C Tech File Formats” folder of Studio Projects.

C Tech Data Exporter generated LSDV File from LITHOLOGY-DATA.XLSX (05/01/2020 15:31:03)

Elevation “0|SAND” “1|SANDSTONE” “2|GRAVEL” “3|MUDSTONE” “4|LIMESTONE” “5|SILTSTONE” “6|MADEGROUND” “7|CONGLOMERATE” “8|GYPSUM” “9|CLAY” “10|SILT” m

Columns [DEMO]: “East” “North” “Elev-Top” “East” “North” “Elev-Bot” “Lithology” “Boring” “Ground_Surface”

736133.267249, 1637594.55844, 1190.2, 736133.267249, 1637594.55844, 1189.8, 0, “720B0001”, 1190.2

736133.267249, 1637594.55844, 1189.8, 736133.267249, 1637594.55844, 1188.2, 1, “720B0001”, 1190.2

736133.267249, 1637594.55844, 1188.2, 736133.267249, 1637594.55844, 1187.8, 0, “720B0001”, 1190.2

736133.267249, 1637594.55844, 1187.8, 736133.267249, 1637594.55844, 1186.7, 1, “720B0001”, 1190.2

736133.267249, 1637594.55844, 1186.7, 736133.267249, 1637594.55844, 1185.6, 0, “720B0001”, 1190.2

736133.267249, 1637594.55844, 1185.6, 736133.267249, 1637594.55844, 1184.2, 2, “720B0001”, 1190.2

736133.267249, 1637594.55844, 1184.2, 736133.267249, 1637594.55844, 1181.2, 1, “720B0001”, 1190.2

736133.267249, 1637594.55844, 1181.2, 736133.267249, 1637594.55844, 1176.2, 1, “720B0001”, 1190.2

736133.267249, 1637594.55844, 1176.2, 736133.267249, 1637594.55844, 1174.9, 1, “720B0001”, 1190.2

736286.268053, 1637647.55834, 1191.2, 736286.268053, 1637647.55834, 1190.2, 0, “720B0002”, 1191.2

736286.268053, 1637647.55834, 1190.2, 736286.268053, 1637647.55834, 1189.8, 0, “720B0002”, 1191.2

736286.268053, 1637647.55834, 1189.8, 736286.268053, 1637647.55834, 1187.2, 1, “720B0002”, 1191.2

736286.268053, 1637647.55834, 1187.2, 736286.268053, 1637647.55834, 1186.2, 2, “720B0002”, 1191.2

736286.268053, 1637647.55834, 1186.2, 736286.268053, 1637647.55834, 1184.1, 1, “720B0002”, 1191.2

736286.268053, 1637647.55834, 1184.1, 736286.268053, 1637647.55834, 1182.2, 1, “720B0002”, 1191.2

736286.268053, 1637647.55834, 1182.2, 736286.268053, 1637647.55834, 1175.9, 1, “720B0002”, 1191.2

737193.272266, 1637709.55665, 1190.2, 737193.272266, 1637709.55665, 1189.2, 0, “720B0003”, 1190.2

737193.272266, 1637709.55665, 1189.2, 737193.272266, 1637709.55665, 1188.2, 0, “720B0003”, 1190.2

737193.272266, 1637709.55665, 1188.2, 737193.272266, 1637709.55665, 1184.2, 0, “720B0003”, 1190.2

737193.272266, 1637709.55665, 1184.2, 737193.272266, 1637709.55665, 1181.9, 0, “720B0003”, 1190.2

737193.272266, 1637709.55665, 1181.9, 737193.272266, 1637709.55665, 1179.2, 1, “720B0003”, 1190.2

737193.272266, 1637709.55665, 1179.2, 737193.272266, 1637709.55665, 1178.9, 0, “720B0003”, 1190.2

737193.272266, 1637709.55665, 1178.9, 737193.272266, 1637709.55665, 1178.2, 1, “720B0003”, 1190.2

737193.272266, 1637709.55665, 1178.2, 737193.272266, 1637709.55665, 1177.9, 0, “720B0003”, 1190.2

737193.272266, 1637709.55665, 1177.9, 737193.272266, 1637709.55665, 1177.2, 1, “720B0003”, 1190.2

737193.272266, 1637709.55665, 1177.2, 737193.272266, 1637709.55665, 1174.7, 1, “720B0003”, 1190.2

GEO: Borehole Geology Stratigraphy

Geology data files basically contain horizontal and vertical coordinates, which describe the geometry of geologic features of the region being modeled. The files must be in ASCII format and can be delimited by commas, spaces, or tabs. Borehole Geology files must have a .geo suffix to be selected in the file browsers of EVS modules. The z values in .geo files can represent either elevation or depth, although elevation is generally the easiest to work with. When chemistry or property data is to be utilized along with geologic data for a 3-D visualization, a consistent coordinate system must be used in both sets of data.

Geology files should also specify the geologic layer material (color) number and layer names. This provides a mechanism to color multiple (not necessarily adjacent) layers as the same material.

Borehole Geology files (.geo suffix) must have the same number of entries for each boring location, so that every geologic layer in the system is represented in each boring. However, EVS allows flags to be included in the .geo files to allow automated processing of data in systems where geologic layers are not present in all locations (i.e., the layers “pinch out”). Also, EVS accommodates borings that were not extended deep enough to encounter layers that the scientist knows are present in the system. The use of these flags greatly facilitates the production of .geo data files, and minimizes the amount of manual interpretation the scientist must do before using EVS to analyze, understand, and refine a geologic model. For layers that pinch out, a flag of pinch can be used for automated estimation of the “depth” to the bottom of that layer. Entering this flag is essentially equivalent to entering the bottom depth of the layer directly above the pinched out layer (which is also an acceptable way to prepare the file). When EVS encounters this flag in a file, it assigns the pinched out layer a zero thickness at this location. For borings that do not extend to the depths of geologic layers in the system, a flag of short is included in the file for all layers below the depth of the boring. Including this flag notifies EVS to ignore the presence of this boring when kriging the surface of the layers below the total depth of the boring.

Format:

The file name must have a .geo suffix to be selected in the module’s file browser. The format below is the same for all EVS modules which read geology files:

  • You may insert comment lines in .geo files.

    • Comment lines must begin with a ’#’ as the first character of a line.

The first non-commented line of the file is the header line (line 1 described below).

Line 1: Any header message: Except that:

  • $W or $G as the first two characters signifies a special geology file which contains unrelated surfaces such as historical water tables. These flags turn off checking for corrupt geology file formats (situations where lower surfaces are above higher surfaces) and automatically turn off kriging in thickness space.
  • Line one cannot be BLANK

Line 2: Elevation/Depth Specifier:

  • The only REQUIRED item on this line in the Elevation or Depth Specifier.
    • This line should contain the word Elevation or Depth (case insensitive) to denote whether sample elevations are true elevation or depth below ground surface.
      • If set to Depth all surface descriptions for layer bottoms are entered as depths relative to the top surface. This is a common means of collecting sample coordinates for borings.
      • Note that the flags such as pinch or short are not modified.
  • Line 2 SHOULD contain names for each geologic surface (and therefore the layers created by them).
    • There are some rules that must be observed.
      • The number of surface (layer) names MUST be equal to the number of surfaces. Therefore, if naming layers, the first name should correspond to the top surface and each subsequent name will refer to the surface that defines the bottom of that layer.
      • A name containing a space MUST be enclosed in quotation marks example (“Silty Sand”). Names should be limited to upper and lower case letters, numerals, hyphen “-” and underscore “_”. The names defined on line two will appear as the cell set name in the explode_and_scale or select cell sets modules. Names should be separated with spaces, commas or tabs.
  • Line 2: After the names, include the units of your coordinates (e.g. feet or meters). It must follow the names for each material number.

Line 3: The first integer (n) is the number of lines to follow. The second integer (m) is the number of geologic layer depths plus one (for the top surface). The 3rd and subsequent numbers are the colors for each surface in your model. Layers are colored by the color of the surface that defines their bottoms. The first two color numbers should be the same (top and bottom of the first layer).

When used with fence_geology, the order of the borings determines the connectivity of the fence diagram and must match the chemistry file for krig_fence.

Note that X and Y corresponding to Eastings and Northings are used. Be careful not to reverse these.

Line 4: First line of sample data. X, Y, top surface, and “m” depths or elevations to the bottom of each geologic layer. Coordinates, elevations (depths) and boring name can be separated by one comma and/or any number of spaces or tabs.

Two different flag parameters are included to accommodate special conditions. These flags are

A: Boring terminates early or surface information is missing. This flag class is used to identify that a boring did not continue deep enough to find the bottom of a geologic layer, OR that a section of a core sample is missing (lost, damaged, etc.) and that no determination of the location of this surface can be made from this boring. This is distinctly different than a surface (layer) that is not present because it has been determined that it has pinched out. The flags that are used for this class are [note: all flags are case insensitive, but spelling is critical]:

  • missing
  • unknown
  • unk
  • na
  • short
  • terminated
  • term

In the sample file below, BOR-24 was not deep enough to reach to the bottom of the Lsand (lower sand) layer or the gravel layer. Rather than use the bottom of the boring (a meaningless number), the short flag is used so that this boring will not be used to determine the bottom of these two layers. Similarly BOR-72 is not deep enough to be used in determining the bottom of the last (Gravel) layer. The flags that are used for this class are [note: all flags are case insensitive, but spelling is critical]:

B: This flag class is used to identify that a geologic layer is not present because it has pinched out for this particular boring. It can be “thought of” as numerically equivalent to using the value one column to the left. However, now that gridding and horizons includes special treatment for the pinchflag, using the value to the left is not strictly equivalent.

  • pinch
  • pinched
  • pinch-out

Note that several layers pinch out in borings WEL-67, BOR-23, BOR-70 and BOR-24, so the pinch flag was used for these layer’s entries instead of any numerical value.

IMPORTANT: There are two important things to consider when using the flags above:

  1. It is wholly inappropriate to have a pinch follow a short. Pinch denotes that the layer above is zero thickness. It is equivalent to using the numeric value to the left. However if it were to follow a short (unknown) it would be meaningless since the short is interpreted to be missing information.
  2. If your last defined surface has fewer than 3 numeric values (with all the rest being missing/short), it will be poorly defined since it takes 3 points to define a plane. If there are no numeric valuesthe surfacecannot be created.

Line 3+n is the last line of the file.

AN EXAMPLE FILE FOLLOWS:

XYTOPBOT_1BOT_2BOT_3BOT_4BOT_5BOT_6BOT_7Boring
DepthTopFillSiltySandClaySandSiltSandGravelfeet
7855314246
11856.712764.005.018.223.5pinchpinch69.0105.0WEL-67
11889.612772.201.517.022.0pinchpinch63.0105.0BOR-23
11939.112758.402.516.025.5pinchpinch63.0105.0BOR-70
12002.812759.801.017.027.0pinch47.0shortshortBOR-24
12085.112749.001.017.525.745.7pinch68.0105.0WEL-71
12146.712713.201.018.026.532.539.565.0shortBOR-72
12199.712709.801.016.522.527.535.570.0105.0WEL-12

This file has 7 boreholes with 8 entries (surfaces) per borehole, corresponding to the top surface and the bottom depths of 7 geologic layers. Note that the fourth and sixth layers are both designated to be material 4. This allows you to easily create layers with the same material the same color.

Other Examples of Geologic Input Files

Example of a .geo file for sedimentary layers and lenses (containing pinchouts)

Example of a .geo file for Dipping Strata Geologic_File_Example_Outcrop_of_Dipping_Strata

  • Geologic File Example: Sedimentary Layers and Lenses

    Geologic File Example: Sedimentary Layers & Lenses Both example files below represent valid forms for the geology file associated with the above figure. For file 1, line 2 of the file is “1”, therefore all surface elevations are entered as actual elevations relative to a fixed reference such as sea level (not depths) and the relationship between x, y, and elevation must be a right handed coordinate system. Note that X and Y corresponding to Eastings and Northings are used. Be careful not to reverse these.

  • Geologic File Example: Outcrop of Dipping Strata

    Geologic File Example: Outcrop of Dipping Strata EVS is not limited to sedimentary layers or lenses. The figure below shows a cross-section through an outcrop of dipping geologic strata. EVS easily model the layers truncating on the top ground surface. The file below represents the geology file associated with the above figure. Line 2 of the file is “Elevation”, therefore all surface elevations are entered as elevations (not depths) and the relationship between x, y, and elevation must be a right handed coordinate system. The pinch flag is used extensively to identify that a geologic layer is not present (pinched out) for a particular boring. It is equivalent to using the value one column to the left. The file was created with the assumption that there was no desire to model any layers below -70 foot elevation and that all borings extend to/beyond that depth.

  • Geology Files for Production of a Fence Diagram

    Geology Files for Production of a Fence Diagram Discussion of Geology Files for Fence Sections Files used to create fence diagrams contain only those borings that the user wishes to include on an individual cross section of the fence, in the order that they will be connected along the section. The resulting set of files includes one .geo file for each cross section that will be included in a fence diagram. The order of the boring listings determines the connectivity of the fence diagram, and must match the order of the borings in the associated chemistry file when chemistry is to be displayed on the diagram. The data for the boring(s) at which individual sections will be joined to produce the fence diagram are included in each of the cross section files that will intersect. Generally, it is easiest to create the geology file for the complete 3-D dataset, and then cut and paste the individual section files from the complete file. Examples of a 3-D geology file and a typical set of fence diagram files are presented below.

Subsections of GEO: Borehole Geology Stratigraphy

Geologic File Example: Sedimentary Layers & Lenses

image\\evslayr1_wmf.jpg image\\evslayr1_wmf.jpg

Both example files below represent valid forms for the geology file associated with the above figure. For file 1, line 2 of the file is “1”, therefore all surface elevations are entered as actual elevations relative to a fixed reference such as sea level (not depths) and the relationship between x, y, and elevation must be a right handed coordinate system. Note that X and Y corresponding to Eastings and Northings are used. Be careful not to reverse these.

Two special flags are used to accommodate special conditions. These flags are pinch and short. Pinch is used to identify that a geologic layer is not present (pinched out) for a particular boring. It is equivalent to using the value one column to the left. Short is used to identify that a boring did not extend to the bottom of a geologic layer. In the sample file below, boring C was not deep enough to reach to the bottom of the layer 3 or any subsequent layers. Rather than use the bottom of the boring (a meaningless number), the short flag is used so that this boring will not be used to determine the bottom of these layers.

File 1:

XYTOPBOT_1BOT_2BOT_3BOT_4BOT_5BOT_6NAME
ElevTopFILLSHSSSDSLSGRfeet
1171123456
533-11.5-22pinch-36pinch-59A
1353.5-12-22.5pinch-36.8-37.5shortB
2475-11-24pinch-38.5-43-58.6C
4228-3-22-23-41.5-46shortD
57117-2-13-26.5-42-43.5-63E
72147-3-8-27.6shortshortshortF
85195.7-5pinch-26.6-38.3pinch-65G
107234.2-5-8-26-38-41shortH
123352.2-3-13-16.9-37.5-41-66I
136243-1.5-15pinch-37-37.5shortJ
1451840-15.7pinch-36.3pinch-58K

For file 2 line 2 of the file is Depth", therefore all surface descriptions for layer bottoms are entered as depths relative to the top surface elevations. This is a common means of collecting sample coordinates for borings. Note that the flags (pinch and short) are not affected by using depths versus elevations.

File 2:

XYTOPBOT_1BOT_2BOT_3BOT_4BOT_5BOT_6NAME
DepthTopFILLSHSSSDSLSGRfeet
1171123456
53314.525pinch39pinch62A
1353.515.526pinch40.341shortB
24751629pinch43.54863.6C
422811303149.554shortD
5711792033.54950.570E
72147101534.6shortshortshortF
85195.710.7pinch32.344pinch70.7G
107234.29.212.230.242.245.2shortH
123352.25.215.219.139.743.268.2I
1362434.518pinch4040.5shortJ
145184419.7pinch40.3pinch62K

There is no numerical equivalent to using the short flag. It causes the kriging modules to select only those borings with valid data for computing the surfaces of each layer.

Geologic File Example: Outcrop of Dipping Strata

EVS is not limited to sedimentary layers or lenses. The figure below shows a cross-section through an outcrop of dipping geologic strata. EVS easily model the layers truncating on the top ground surface.

image\\evslayr2_wmf.jpg image\\evslayr2_wmf.jpg

The file below represents the geology file associated with the above figure. Line 2 of the file is “Elevation”, therefore all surface elevations are entered as elevations (not depths) and the relationship between x, y, and elevation must be a right handed coordinate system. The pinch flag is used extensively to identify that a geologic layer is not present (pinched out) for a particular boring. It is equivalent to using the value one column to the left. The file was created with the assumption that there was no desire to model any layers below -70 foot elevation and that all borings extend to/beyond that depth.

Also, we have assigned the following material layer colors (numbers) to the 7 layers.

Layer # Material Abbreviation Material Color

1 Shale SH 5

2 Silty-sand SS 2

3 Sand SD 1

4 Sandy-silt SLS 3

5 Silty-sand SS 2

6 Sandy-silt SLS 3

7 Silt SL 4

XYTOPBOT_1BOT_2BOT_3BOT_4BOT_5BOT_6BOT_7NAME
ElevationTopSHSHSSSDSLSSSSLSSLfeet
44855213234
5323.54-22pinch-39-70-70-70A
1352613-18pinch-36-64-70-70B
2472622-9-9.5-32-57.5-70-70C
42222pinchpinch-3-24-50-70-70D
57624pinchpinch4-15-43.5-70-70E
72730.5pinchpinch14-4-37-70-70F
85333pinchpinch21.56-30-70-70G
107429.5pinchpinchpinch19-20-60-70H
123629.5pinchpinchpinch28.5-10-49.5-70I
136338pinchpinchpinchpinch-4-44-70J
145039.5pinchpinchpinchpinch-3-39-70K
3.1128.1825.933.96-20.99pinch-39.01-70-70-70A1
16.8537.9724.8515.61-20.7pinch-35.7-61.92-70-70B1
25.9932.0223.0523.34-6.11-6.41-31.53-59.17-70-70C1
41.0525.1324.26pinchpinch-1.22-25.57-47.06-70-70D1
54.4334.9426.56pinchpinch1.36-14.66-45.49-70-70E1
67.2929.328.3pinchpinch16.45-6.49-37.22-70-70F1
88.8925.3132.92pinchpinch19.176.16-27.28-70-70G1
104.1730.5830.13pinchpinchpinch19.76-22.25-62.18-70H1
121.8730.2630.76pinchpinchpinch27.84-7.81-49.67-70I1
136.9929.6135.95pinchpinchpinchpinch-6.02-44.8-70J1
149.6729.3337.59pinchpinchpinchpinch-4.09-40.17-70K1
4.0662.0323.473.46-22.43pinch-38.05-70-70-70A2
12.0964.1525.2613.42-19.11pinch-33.89-59.06-70-70B2
30.7366.4225.8126.1-3.46-3.76-28.81-58.62-70-70C2
40.4349.7926.12pinchpinch-0.5-27.73-46.67-70-70D2
54.565.5127.88pinchpinch1.79-15.51-43.8-70-70E2
66.4152.925.48pinchpinch16.96-7.18-35.22-70-70F2
93.5850.1834.29pinchpinch21.626.46-28.76-70-70G2
106.1355.4430.39pinchpinchpinch20.9-23.47-60.65-70H2
126.1963.4328.78pinchpinchpinch27.64-8.31-48.85-70I2
138.3962.436.52pinchpinchpinchpinch-5.72-47.12-70J2
144.9152.7940.49pinchpinchpinchpinch-4.66-37.23-70K2
6.7786.1521.092.83-22.62pinch-36.05-70-70-70A3
16.9198.5322.8610.95-17.19pinch-31.33-57.46-70-70B3
35.0787.0525.3925.81-2.37-2.67-30.89-59.85-70-70C3
36.3777.3826.62pinchpinch-2.19-27.56-43.87-70-70D3
51.594.8627.26pinchpinch4.57-15.51-46.35-70-70E3
71.2373.1926.45pinchpinch16.19-9.22-38.04-70-70F3
93.0979.1533.93pinchpinch19.649.37-28.16-70-70G3
110.1876.0227.4pinchpinchpinch20.63-21.81-63.39-70H3
127.990.6231.64pinchpinchpinch29.56-8.26-45.96-70I3
139.2796.2637.57pinchpinchpinchpinch-8.29-47.67-70J3
143.5275.6238.22pinchpinchpinchpinch-6.59-37.51-70K3

Geology Files for Production of a Fence Diagram

Discussion of Geology Files for Fence Sections

Files used to create fence diagrams contain only those borings that the user wishes to include on an individual cross section of the fence, in the order that they will be connected along the section. The resulting set of files includes one .geo file for each cross section that will be included in a fence diagram. The order of the boring listings determines the connectivity of the fence diagram, and must match the order of the borings in the associated chemistry file when chemistry is to be displayed on the diagram. The data for the boring(s) at which individual sections will be joined to produce the fence diagram are included in each of the cross section files that will intersect. Generally, it is easiest to create the geology file for the complete 3-D dataset, and then cut and paste the individual section files from the complete file. Examples of a 3-D geology file and a typical set of fence diagram files are presented below.

The format of the data in the file is exactly the same as for 3-D geology files. Material colors are not supported for fence diagrams.

An example set of files for producing a fence diagram with two merged cross sections are shown below:

Geology File for Cross Section A-A'
Elevationfeet
78
11086.5212830.6725002496248424792420
11199.0412810.1625012492248224732420
11259.6712819.2925022492247924672425
1129812808.6325032492249224802424
11414.412781.125042491248224712420
1142712780.925012493247724672424
11496.3412753.5925022492248024652422
Geology File for Cross Section B B'
Elevationfeet
58
11209.3512993.94250224922481
11251.3012929.27250324932474
11248.7512870.91250124922483
11199.0412810.16250124922482
11211.8712710.75250324932480

This example fence diagram contains two cross sections, with elevations for the surface and the bottoms of seven layers of geology in each. Section A-A’ has seven borings that will be used to define it, and Section B-B’ has five borings. Neither of the sections contains layers that pinch out, and all of the borings extend to the depth of the fence. Note that the entries for location BOR-51 are identical in each file, and are placed such that the sections will cross at the second location in the A-A’ file, and the fourth location in the B-B’ file. The user will typically use a basemap to plan the orientations and intersections of the fences. EVS does not impose any restrictions on the number of borings in or placement of sections in fence diagrams, but planning should be done to assure that most sections of the fence can be viewed from a chosen viewpoint.

Geology Multi-File

Geology Multi-Files: Unlike the .geo file format, the .gmf format is not based on boring observations with common x,y coordinates. The multi-file format allows for description of individual geologic surfaces by defining a set of x,y,z coordinates (separated by spaces, tabs, and/or commas). Geologic hierarchy still applies for definition of complex geologic structures.

This file format allows for creation of geologic models when the data available for the top surface and one or more of the subsurface layers are uncorrelated (in number or x,y location). For example, a gmf file may contain 1000 x,y,z measurements for the ground surface, but only 12 x,y,z measurements for other lithologic surfaces. This format also allows for specification of the geologic material color (layer material number).

You SHOULD include the units of your coordinates (e.g. feet or meters). If this is included it must be on a line following the word units.

Note: there are no special flags (e.g. short, pinch, etc.) used in GMF files. Since each surface stands on its own (does not refer to a prior surface) pinched-out layers are accomplished by duplicating the elevations (x,y,z points) on two consecutive surfaces. The “short” flags are not needed since those points are merely excluded from a surface’s definition.

The name for a surface can be a date or date & time if the data represents surface points at different times (e.g. changing groundwater elevations. The date format is dependent on your REGIONAL SETTINGS on your computer (control panel).

C Tech uses the SHORT DATE and SHORT TIME formats.

If the date/time works in Excel it will likely work in EVS.

For most people in the U.S., this would not be 24 hour clock so you would need:

“m/d/yyyy hh:mm:ss AM” or “m/d/yyyy hh:mm:ss PM”

Also, you MUST put the date/time in quotes if you use more than just date (i.e. if there are spaces in the total date/time).

Format: The following is a geology multi-file which is included with EVS. This file begins with the line starting with a “#”.

Lines beginning with a “#” character are comments.

Each geologic surface begins with a line: surface x

The number after surface is the layer material color number.

Each surface can have different x,y coords and number of points

units ft

surface 2 Top

11086.5 12830.7 4.5

11199.0 12810.2 4

Comment lines can be placed anywhere in a multi-file

11259.7 12819.3 2

11298.0 12808.6 3

11414.4 12781.1 2

11427.0 12780.9 6.5

11496.3 12753.6 1.5

11209.4 12993.9 2

11251.3 12929.3 2

11248.8 12870.9 3

11211.9 12710.8 2

11302.0 13079.7 4.5

11286.8 13026.7 2

11309.0 12949.0 4

11340.5 12892.6 2.5

11338.0 12830.8 4

11393.5 12948.9 3.5

11401.7 12897.8 4

11416.9 12819.5 2.5

11381.7 12747.5 1.5

11410.3 12724.7 0.5

11566.3 12850.6 2.5

11586.3 13050.6 11.5

11086.3 13090.6 8.5

surface 2 Fill

11086.5 12830.7 -3.8

11199.0 12810.2 -5

11259.7 12819.3 -7.5

11298.0 12808.6 -6

11414.4 12781.1 -6

11427.0 12780.9 -7

11496.3 12753.6 -7.5

11209.4 12993.9 -3

11251.3 12929.3 -2.5

11248.8 12870.9 -3.5

11211.9 12710.8 -6.5

11302.0 13079.7 -3.5

11286.8 13026.7 -5

11309.0 12949.0 -2.5

11340.5 12892.6 -2.5

11338.0 12830.8 -8.8

11393.5 12948.9 -3.8

11401.7 12897.8 -2

11416.9 12819.5 -5

11381.7 12747.5 -4

11410.3 12724.7 -4.5

11566.3 12850.6 -5

11586.3 13050.6 1

11086.3 13090.6 -1

surface 1 Silt

11086.5 12830.7 -21

11199.0 12810.2 -20

11259.7 12819.3 -20.5

11298.0 12808.6 -19

11414.4 12781.1 -20.5

11427.0 12780.9 -23

11496.3 12753.6 -20

11209.4 12993.9 -23

11251.3 12929.3 -22

11248.8 12870.9 -22

11211.9 12710.8 -22.5

11302.0 13079.7 -21.9

11286.8 13026.7 -23

11309.0 12949.0 -22

11340.5 12892.6 -20

11338.0 12830.8 -23

11393.5 12948.9 -23

11401.7 12897.8 -22

11416.9 12819.5 -21

11381.7 12747.5 -21.5

11410.3 12724.7 -22.9

11566.3 12850.6 -21

11586.3 13050.6 -11

11086.3 13090.6 -14

surface 3 Clay

11086.5 12830.7 -26

11199.0 12810.2 -25

11259.7 12819.3 -27

11298.0 12808.6 -25.8

11414.4 12781.1 -28

11427.0 12780.9 -28.5

11496.3 12753.6 -28.8

11209.4 12993.9 -27.5

11251.3 12929.3 -28

11248.8 12870.9 -28.5

11211.9 12710.8 -27.5

11302.0 13079.7 -26

11286.8 13026.7 -29

11309.0 12949.0 -28.3

11340.5 12892.6 -23

11338.0 12830.8 -26.5

11393.5 12948.9 -27

11401.7 12897.8 -27.5

11416.9 12819.5 -28.5

11381.7 12747.5 -25.8

11410.3 12724.7 -25

11566.3 12850.6 -28.5

11586.3 13050.6 -18.5

11086.3 13090.6 -23.5

surface 5 Gravel

11086.5 12830.7 -42

11199.0 12810.2 -39

11259.7 12819.3 -40

11298.0 12808.6 -41.8

11414.4 12781.1 -42

11427.0 12780.9 -38.5

11496.3 12753.6 -38.8

11209.4 12993.9 -37.5

11251.3 12929.3 -40

11248.8 12870.9 -36.3

11211.9 12710.8 -37.5

11302.0 13079.7 -38

11286.8 13026.7 -37

11309.0 12949.0 -38.3

11340.5 12892.6 -38

11338.0 12830.8 -36.5

11393.5 12948.9 -39

11401.7 12897.8 -37.5

11416.9 12819.5 -38.5

11381.7 12747.5 -42.8

11410.3 12724.7 -36

11566.3 12850.6 -38.5

11586.3 13050.6 -26.5

11086.3 13090.6 -32.5

surface 4 Sand

11086.5 12830.7 -55

11199.0 12810.2 -53

11259.7 12819.3 -53

11298.0 12808.6 -55

11414.4 12781.1 -55

11427.0 12780.9 -51

11496.3 12753.6 -51

11209.4 12993.9 -51

11251.3 12929.3 -53

11248.8 12870.9 -50

11211.9 12710.8 -51

11302.0 13079.7 -51

11286.8 13026.7 -50

11309.0 12949.0 -52

11340.5 12892.6 -52

11338.0 12830.8 -50

11393.5 12948.9 -52

11401.7 12897.8 -51

11416.9 12819.5 -51

11381.7 12747.5 -56

11410.3 12724.7 -49

11566.3 12850.6 -51

11586.3 13050.6 -47

11086.3 13090.6 -48

end

  • ctech_example.gmf

    ctech_example.gmf Database Generated GMF File (Creation at 7/22/2003 5:36:07 PM) Surface 1: 25 Coordinates Database Columns [GMF_Surface0 (Ground Surface)]: X, Y, Top surface 1 Sand

Subsections of Geology Multi-File

ctech_example.gmf

Database Generated GMF File (Creation at 7/22/2003 5:36:07 PM)

Surface 1: 25 Coordinates

Database Columns [GMF_Surface0 (Ground Surface)]: X, Y, Top

surface 1 Sand

11566.34 12850.59 2.5

11586.34 13050.59 11.5

11086.3 13090.6 8.5

.

.

.

.

11393.47 12948.9 3.5

11251.3 12929.27 2

Surface 1 Complete

Surface 2: 24 Coordinates (Added at 7/22/2003 5:37:04 PM)

Database Columns [GMF_Surface1]: X, Y, Z

surface 1 Sand

11566.34 12850.59 -5

11586.34 13050.59 1

11086.3 13090.6 -1

.

.

.

.

11393.47 12948.9 -3.8

11251.3 12929.27 -2.5

Surface 2 Complete

Surface 3: 24 Coordinates (Added at 7/22/2003 5:38:18 PM)

Database Columns [GMF_Surface2]: X, Y, Z

surface 1 Sand

11566.34 12850.59 -21

11586.34 13050.59 -11

11086.3 13090.6 -14

.

.

.

11393.47 12948.9 -23

11251.3 12929.27 -22

Surface 3 Complete

units ft

end

Database Generated GMF File (Finalization at 7/22/2003 5:39:06 PM)

.PT File Format

The .PT (Place-Text) format is used to place 3D text (labels) with user adjustable font and alignment.

The format is:

  • Lines beginning with “#” are comments

  • Lines beginning with “LINEFONT” are font specification lines specifically associated with single line text.

    • LINEFONT, height, justification, azimuth, inclination, roll, red, green, blue, curve tolerance, font flags (bold is ignored)
    • NOTE: There is no specification of the Font to be used, because EVS includes its own Unicode Line Font which supports most worldwide languages.
  • Lines beginning with “TRUETYPE” are font specification lines specifically associated with TrueType Fonts.

    • TRUETYPE, height, justification, azimuth, inclination, roll, red, green, blue, curve tolerance, outlined (“True”/“False”), depth, bevel, font flags, font name
  • Lines beginning with “FORWARDFACING” font specification lines specifically associated with Forward Facing Fonts.

    • FORWARDFACING, red, green, blue, font flags
    • NOTE: Forward Facing font specifications other than color are module wide. Therefore, the .PT files do not contain the Justification or Font specification options (including size).
  • The lines containing each TEXT STRING to be displayed have five columns of information:

    1. X coordinate
    2. Y coordinate
    3. Z coordinate
    4. Explode_ID: This is equivalent to the (Stratigraphic) cell data “Layer” information. The uppermost ID (layer) is ZERO (0) and does not move. If you don’t want your text to move with changing Explode Distance, use a value of ZERO. Otherwise, by assigning an appropriate ID value your text string can move properly with both stratigraphic layers or lithologic materials as they are exploded.
    5. Text: Everything on the line after Explode_ID (and any trailing spaces) is the text to be placed at the above coordinate, and must be in quotes.
  • Blank lines anywhere in the file are ignored.

  • Lines beginning with “END” specify the end of the file. Using END is optional, but if you want to have any notes or comments after the last command or data line, precede it with a line using the “END” statement.

Lines beginning with “FONT” are legacy font specification lines that we suggest you avoid. However, when we read a legacy file, we attempt to migrate it to the new options.

Below is an example .PT file and the output it creates:

TRUETYPE, 20.000000, LC, 180.000000, 90.000000, 0.000000, 0.847059, 0.847059, 0.858824, 0.050000, False, 0.200000, 5.000000, None, “Noto Sans”

0.000000, 300.000000, 0.000000, 0, “TTF”

TRUETYPE, 20.000000, LC, 180.000000, 90.000000, 0.000000, 0.847059, 0.847059, 0.858824, 0.050000, False, 0.200000, 5.000000, Bold, “Noto Sans”

250.000000, 300.000000, 0.000000, 0, “TTF Bold”

TRUETYPE, 20.000000, LC, 180.000000, 90.000000, 0.000000, 0.847059, 0.847059, 0.858824, 0.050000, False, 0.200000, 5.000000, Italic, “Noto Sans”

500.000000, 300.000000, 0.000000, 0, “TTF Italic”

TRUETYPE, 20.000000, LC, 180.000000, 90.000000, 0.000000, 0.847059, 0.847059, 0.858824, 0.050000, False, 0.200000, 5.000000, Bold Italic, “Noto Sans”

750.000000, 300.000000, 0.000000, 0, “TTF Bold Italic”

TRUETYPE, 20.000000, UC, 180.000000, 90.000000, 0.000000, 0.847059, 0.847059, 0.858824, 0.050000, True, 0.200000, 5.000000, None, “Noto Sans”

0.000000, 200.000000, 0.000000, 0, “Outlined”

TRUETYPE, 20.000000, UC, 180.000000, 90.000000, 0.000000, 0.847059, 0.847059, 0.858824, 0.050000, True, 0.200000, 5.000000, Bold, “Noto Sans”

250.000000, 200.000000, 0.000000, 0, “Outlined Bold”

TRUETYPE, 20.000000, UC, 180.000000, 90.000000, 0.000000, 0.847059, 0.847059, 0.858824, 0.050000, True, 0.200000, 5.000000, Italic, “Noto Sans”

500.000000, 200.000000, 0.000000, 0, “Outlined Italic”

TRUETYPE, 20.000000, UC, 180.000000, 90.000000, 0.000000, 0.847059, 0.847059, 0.858824, 0.050000, True, 0.200000, 5.000000, Bold Italic, “Noto Sans”

750.000000, 200.000000, 0.000000, 0, “Outlined Bold Italic”

TRUETYPE, 20.000000, UC, 180.000000, 90.000000, 45.000000, 0.847059, 0.847059, 0.858824, 0.050000, False, 0.200000, 5.000000, Bold, “Noto Sans”

250.000000, 400.000000, 0.000000, 0, “TTF Bold at 45° roll”

LINEFONT, 20.000000, UC, 180.000000, 90.000000, 0.000000, 0.847059, 0.847059, 0.858824, 0.050000, None

0.000000, 100.000000, 0.000000, 0, “Singleline”

LINEFONT, 20.000000, UC, 180.000000, 90.000000, 0.000000, 0.847059, 0.847059, 0.858824, 0.050000, Italic

500.000000, 100.000000, 0.000000, 0, “Singleline Italic”

FORWARDFACING, 0.847059, 0.847059, 0.858824, None

0.000000, 0.000000, 0.000000, 0, “ForwardFacing”

This legacy format has been deprecated and replaced by the .PT File Format.

The EMT (EVS Multi-Text) format is used to place 3D text (labels) with user adjustable font and alignment.

The format is:

  • Lines beginning with “#” are comments
  • Lines beginning with “FONT” are font specification lines (more later)
  • Lines beginning with “END” specify the end of the file (this is optional, but if you want to have anything after the last command or data line, precede it with an “END” statement.
  • All other lines are DATA lines specifying the x-y-z coordinates of a string and the text for that string.
  • Blank lines are ignored.
  • The FONT specification lines contain the following information in this order:
    • Size: The font size is the height of a typical Capitol letter in true user units
      • Justification: The justification options are the same as in post_samples
      • Plane: The plane options are the same as in post_samples
      • Orientation: The orientation options are the same as in post_samples
      • Red, Green, Blue: These 3 numbers determine the font color.
      • Resolution: The resolution parameter is the same as in post_samples
      • Depth: The parameter is the same as in post_samples
      • Bevel%: The Bevel percentage isthe same as in post_samples
      • Font Face: The Font Face options are the same as in post_samples
  • The DATA lines contain four columns of information:
    1. X coordinate
    2. Y coordinate
    3. Z coordinate
    4. Text: Everything on the line after the z coordinate (and trailing spaces) is the text to be placed at the above coordinate.

Below is an example EMT File

FONT Size Just. Plane Orient R G B Resolution Depth Bevel% Font Face

FONT, 4, MC, XZ, +X, 0.8, 0.8, 0.8, 3, 0, 0, Arial

X, Y, Z, Bore

11566.34, 12850.59, 8.5, B-30

11586.34, 13050.59, 12.5, B-31

11381.7, 12747.5, 2.5, B-33

11414.4, 12781.1, 3, B-34

11410.29, 12724.69, 4.5, B-4

11427, 12780.9, 7.5, B-42

11086.52, 12830.67, 5.5, B-49

11211.87, 12710.75, 3, B-50

11199.04, 12810.16, 5, B-51

11496.34, 12753.59, 2.5, B-53

11209.35, 12993.94, 3, B-57

11301.97, 13079.66, 5.5, B-58

11286.77, 13026.7, 3, B-59

FONT Size Just. Plane Orient R G B Resolution Depth Bevel% Font Face

FONT, 6, MC, XZ, +X, 1, 0.5, 0.5, 3, 0.1, 0, Arial

11393.47, 12948.9, 4.5, B-60

11309.03, 12948.99, 5, B-56

11248.75, 12870.91, 4, B-48

11259.67, 12819.29, 3, B-46

11298, 12808.63, 4, B-52

11338, 12830.8, 5, B-38

11401.73, 12897.77, 5, B-45

11416.9, 12819.45, 3.5, B-44

FONT, Size, Justification, Plane, Orientation, Red, Green, Blue, Resolution, Depth, Bevel%, Font Face

FONT, 8, MC, XZ, +X, 1, 0, 0, 3, .3, 0, Arial Bold

11340.49, 12892.61, 3.5, B-47

11251.3, 12929.27, 3, B-75

END