Geotech_refvals Format

Format Name: Geotech_refvals

File Name: Geotech_refvals.zip

Dependencies: Licensed EQuIS Geotech and Geotech Schema

Source: Available on the EarthSoft Community Center Downloads Dashboard > Products > EQuIS Geotech

Description: This format contains an EDD section for each of the reference value tables applicable to the EQuIS Geotech Schema. Use this format to import, update, and/or export reference values.

Installation Instructions: Download the Geotech_refvals format from the EarthSoft Community Center and unblock the *.zip file.

Overview:

This format allows users to load EQuIS Geotech reference values. More information about reference values is available in the EDP\Reference Values articles.

The Geotech_refvals format populates the following EQuIS tables:

•AT_MATERIAL

•RT_ANALYTE

•RT_COMPANY

•RT_COMPANY_TYPE

•RT_COORD_ELEV_METHOD

•RT_COORD_ELEV_DATUM

•RT_COORD_TYPE

•RT_COST_TYPE

•RT_DOWNHOLE_POINT_PARAM_TYPE

•RT_FACILITY_PARAM_TYPE

•RT_GEO_RESULT_CODE

•RT_GEO_TEST_METHOD

•RT_GEO_TEST_PARAM_TYPE

•RT_GEO_UNIT_TYPE

•RT_GEOLOGIC_UNIT

•RT_GROUP

•RT_GROUP_MEMBER

•RT_LITHOLOGY_COMPONENT

•RT_LOCATION_PARAM_TYPE

•RT_LOCATION_TYPE

•RT_LOOKUP

•RT_MATERIAL

•RT_MATRIX

•RT_MATRIX_CLASS

•RT_NOTE_TYPE

•RT_REMAP

•RT_REMAP_DETAIL

•RT_SAMPLE_METHOD

•RT_SAMPLE_PARAM_TYPE

•RT_SAMPLE_TYPE

•RT_STATE

•RT_TASK_PARAM_TYPE

•RT_UNIT

•RT_VALID_CODE

•RT_WELL_SEGMENT_TYPE

•ST_GROUP_TYPE

EQuIS Geotech relies on some standard default reference values. A corresponding EDD, Geotech_Refvals_EDD.xlsx, is also available on the EarthSoft Community Center. This EDD contains all necessary reference values for EQuIS Geotech. As the Geotechnical_v2 format relies on these standard values, these reference values must be loaded prior to using the Geotechnical_v2 format.

Prior to using EQuIS Geotech, the reference values must first be loaded to the database. To do this:

1.Open Professional EDP.

2.Open the Geotech_refvals format in EDP.

3.Open the Geotech_Refvals_EDD.xlsx EDD.

4.Review loaded sections for errors or any desired modifications.

5.Create and Commit the EDD.

More information about importing reference values can be found here: Database\Modifications\Reference Values - Importing

More information about using formats and loading EDDs can be found here: EDP QuickStart

More information about formats can be found here: EQuIS Format Files