pLog to ESdat Field Mapping

<< Click to Display Table of Contents >>

Navigation:  Application Configuration > pLog > pLog Data Menus Supported >

pLog to ESdat Field Mapping

Previous pageReturn to chapter overviewNext page

 

Data is transferred from pLog to ESdat via pLog Cloud and ESdat Server.

 

Borehole Info

 

Hole Info -> Locations, Boreholes

 

 

Borehole Number

-> Location.Location_Code,Boreholes.Location_Code

 

Latitude

-> Location.Latitude

 

Longitude

-> Location.Longitude

 

Elevation

-> Location.Elevation

 

Description + Offset Distance + Station

-> Location.Description

 

Logger First Name + Logger Last Name

-> Location.Mapped_By

 

Boring Type

-> Location.Location_Type

 

Borehole Number

-> Boreholes.Location_Code

 

Date Commenced

-> Boreholes.StartDateTime

 

Diameter

-> Boreholes.Borehole_Diameter

 

HoleDepth

-> Boreholes.Total_Depth

 

Bearing

-> Boreholes.Bearing

 

Plunge

-> Boreholes.Plunge

 

Drilling Method + Coring Method

-> Boreholes.Drilling_Method

 

DrillingCompany

-> Boreholes.Drill_Company

 

Driller First Name + Driller Last Name

-> Boreholes.Driller

 

Drill Rig

-> Boreholes.Drill_Rig

 

General Remarks

-> Boreholes.Comments

 

Abandonment Method

-> Boreholes.Completion_Description

 

SPT Method

(Not Imported)

 

Refusal Info -> Borehole

 

 

Refusal Depth

-> Refusal Encountered, Hole Depth

 

Rock Depth

(Not Imported)

 

Refusal Remarks

-> Boreholes.Completion_Description

 

Termination Info -> Borehole

 

 

Hole Depth

-> Total_Depth

 

Termination Date/Time

-> Date Finalised

 

Backfill Method

(Not Imported, See Borehole_Backfill)

 

Backfill Date/Time

(Not Imported)

 

Termination Remarks

-> Termination_Comments

       

Test Pit Info -> Borehole

 

 

Length

-> Test Pit Length

 

Width

-> Test Pit Width

 

Shoring Support

-> Test Pit Construction

 

Stability

-> Test Pit Construction

 

Hole Info at Depth -> Borehole_Advancement

 

 

Depth

-> Depth From

 

Bottom Depth

-> Depth To

 

Drilling Method + Coring Method + Drilling Fluid + SPT Method

-> Drilling Method

 

Diameter + Diameter Units

-> Diameter

 

Start Date Time

-> Start Date

 

Termination Date Time

-> End Date

 

Logger First Name + Logger Last Name

-> Logged By

 

Comments

-> Comments

 

Driller First Name + Driller Last Name

-> Driller Name

 

Drilling Company

-> Drilling Company

 

Drill Rig

-> Drilling Rig

 

Water Strike -> Borehole_Waterstrikes

 

 

depth

-> Depth

 

Date/Time

-> Date_Time

 

Minutes after Strike

-> Minutes_Elapsed

 

Casing Depth

-> Comments

 

Water Depth After

-> Recovered_Water_Depth

 

Depth Sealed

-> Comments

 

Flow Rate Remarks

-> Comments

 

 

       

 

Soil and Rock Stratigraphy -> Geology

 

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 Items

pLog Rock 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.

 

 

Organic Content

 

 

Not Imported

 

Primary Major Constituent

Rock Type

Primary_Major_Constituent

 

 

Secondary Major Constituent

Secondary Rock Type

Secondary_Major_Constituent

 

 

Tertiary Major Constituent

Rock Type Modifier

Tertiary Major Constituent

 

 

 

Mineralogy

Mineralogy

 

 

Minor_Consistuent 1

 

Minor_Component_1

 

 

Minor_Consistuent 2

 

Minor_Component_2

 

 

Minor_Consistuent 3

 

Minor_Component_3

 

 

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

 

 

Max Grain Size

 

Max 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'

 

Comments

Comments

Comments

 

 

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

 

 

Fines

 

Soil_Fines_Description

 

 

Percent Sand

 

Soil_Percent_Sand

 

 

Percent Gravel

 

Soil_Percent_Gravel

 

 

Dry Strength

 

Soil_Dry_Strength

 

 

USCS

 

Soil_USCS

 

 

Sand Hardness/Angularity/Grain

 

Soil_Sand_Description

 

 

Gravel Hardness/Angularity/Grain

 

Gravel_Sand_Description

 

 

Cobbles Hardness/Angularity/Grain

 

Cobbles_Sand_Description

 

 

Boulders Hardness/Angularity/Grain

 

Boulders_Sand_Description

 

 

 

RQD

Rock_RQD

 

 

 

Compressive Strength

Rock_Compressive_Strength

 

 

 

Compressive Strength2

Rock_Compressive_Strength2

 

 

 

Weathering

Rock_Weathering

 

 

 

Bedding_Angle

Rock_Bedding_Angle

 

 

 

Notes -> Borehole_Depth_Comments

 

 

Top Depth

->  Depth_From

 

Bottom Depth

->  Depth_To

 

Description

-> Comment

 

Well Details -> Wells

 

 

Well ID

-> Well

 

Stickup

-> Stickup

 

Casing Elevation

-> TOC

 

Top of Screen

-> Top_Screen_Depth

 

Bottom of Screen

-> Bottom_Screen_Depth

 

Monitoring Unit

-> Monitoring_Unit

 

Bottom of Well

-> Base_Depth

 

Casing Type

-> Casing_Description

 

Inside Diameter

-> Inner_Diameter

 

Screen Type

-> Screen_Description

 

Installer

(Not Imported)

 

Date/Time

(Not Imported)

 

Notes

(Not Imported)

 

 

Well Construction/Backfill -> Borehole_Backfill

 

 

Depth

-> Depth_From

 

BottomDepth

-> Depth_To

 

Graphic, Description

-> Backfill_Code (in order of precedence)

 

Description

-> Backfill_Description

 

Volume

(Not Imported)