PLog to ESdat Translation |
  
|
PLog to ESdat Translation |
|
Data is transferred from PLog to ESdat as specified in the file "PLog.gedt" stored in the Templates directory. The gedt file format is developed by EScIS for data tranfer, but is similar to formats developed by other companies. The specifications are provided here.
The translation from PLog to ESdat is generally fairly can be easily traced by looking at the PLog Data Menus Supported page and the fields mostly have equivalent and intuitive matches. For details the PLog.gedt file can be opened in Notepad or other text editors.
The transfer of Stratigraphy data from PLog is the most complex, and is described below.
Soil and Rock Stratigraphy data are collected in different sets of forms in PLog. The standard data translation is into the single "Geology" table in ESdat according to the following description.
.
pLog Soil Data Items |
pLog Rock Data Items |
ESdat Field |
Comment |
|---|---|---|---|
Borehole Number |
Borehole Number |
LocCode |
|
Depth |
Depth |
Top_Depth |
|
Bottom Depth |
Bottom Depth |
Bottom_Depth |
|
Graphic,USCS,Major_Constituents |
Graphic,Rock_Type |
Lithological_Code |
In order of preference as given. The Lithological Code is associated with graphics in WinLog and gINT. |
Major_Constituents,Classifications, Organic_Content |
Rock Type Modifier,Mineralogy, Rock_Type |
Lithological_Description |
|
Consistency, Minor_Consistuents, |
|
Minor_Components_Description |
|
Geologic Formation |
Geologic Formation |
Formation |
|
|
Local Name |
Stratigraphy1 |
|
Moisture |
Moisture |
Moisture |
|
Color |
Color |
Colour |
|
Munsell Color |
Munsell Color |
Munsell Colour |
|
Grain Size |
Grain Size |
Grain Size |
|
|
|
Recovery_% |
|
Bedding Thickness, Structure |
Thickness, Structure, Sedimentary_Structure |
Structure |
|
Discontinuity Spacing |
Fracture Spacing (primary) |
Fracture Spacing |
|
|
Fracture Spacing (secondary ) |
Fracture Spacing2 |
|
Staining |
Staining |
Staining |
|
Odor |
Odor |
Odour |
|
HCL Reaction |
HCl Reaction |
HCL_Reaction |
|
|
Rock Type Percentage |
Major_Unit_Percentage |
|
Line_Type |
Line_Type |
Upper_Boundary_Transition |
Converted to values 'Poorly Defined' or 'Well Defined' |
Primary & Secondary Consistency |
|
Soil_Consistency |
|
Gradation |
|
Soil_Gradation |
|
Angularity |
|
Soil_Angularity |
|
Deposition_Environment |
|
Soil_Deposition_Environment |
|
Cementation |
|
Soil_Cementation |
|
Plasticity |
|
Soil_Plasticity |
|
Dilatancy |
|
Soil_Dilatancy |
|
Toughness |
|
Soil_Toughness |
|
Hardness |
|
Soil_Hardness |
|
Percent Fines |
|
Soil_Percent_Fines |
|
Percent Sand |
|
Soil_Percent_Sand |
|
Percent Gravel |
|
Soil_Percent_Gravel |
|
Dry Strength |
|
Soil_Dry_Strength |
|
USCS |
|
Soil_USCS |
|
|
RQD |
Rock_RQD |
|
|
Compressive Strength |
Rock_Compressive_Strength |
|
|
Compressive Strength2 |
Rock_Compressive_Strength2 |
|
|
Weathering |
Rock_Weathering |
|
|
Bedding_Angle |
Rock_Bedding_Angle |
|
Comments |
Comments |
Comments |
|