Data is transferred from PLog to ESdat via ESdat Server, see the ESdat Server help documentation for more details.
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 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) |