Tables and fields
Every table and field in GeotechOS Borehole Logging: the unit, what you can type, the limits and the AGS 4 heading of each field.
Applies toWindows and macOSWeb browserPhone and tablet
This page lists each table of a hole and its fields, in the order of the project tree. For how to use the tables, see Use the tables.
- Unit: the unit of the value. Depths are in metres below the ground.
- Notes: what you can type, the limits, and the AGS 4 heading that the field goes to in an AGS file.
Geology
The description of the ground, and the rock tables for cored holes.
Lithology
| Field | Unit | Notes |
|---|---|---|
| Top | m | Required. 0 or more. AGS: GEOL_TOP. |
| Base | m | Required. Deeper than Top. AGS: GEOL_BASE. |
| Graphic | A legend from the graphic catalogue. AGS: GEOL_LEG. |
|
| Group symbol | AGS: GEOL_GEOL. |
|
| Description | AGS: GEOL_DESC. |
|
| Geology unit | One of the project's geology units. | |
| Unit 2 | One of the project's geology units. | |
| Moisture condition | Borehole Logging fills it in from other fields. | |
| Consistency/Density | Borehole Logging fills it in from other fields. | |
| Remarks | AGS: GEOL_REM. |
|
| Consistency (description part) | For example: very soft, soft, firm, stiff, very stiff, hard, very loose, loose and more. | |
| To (description part) | For example: very soft, soft, firm, stiff, very stiff, hard, very loose, loose and more. | |
| Shade (description part) | For example: light, dark, pale, bright. | |
| Tint (description part) | For example: brownish, greyish, reddish, yellowish, orangish, bluish, greenish, blackish and more. | |
| Colour (description part) | For example: brown, grey, red, yellow, orange, blue, green, black and more. | |
| Link (description part) | For example: mottled, and, with, streaked, speckled, banded. | |
| Shade 2 (description part) | For example: light, dark, pale, bright. | |
| Tint 2 (description part) | For example: brownish, greyish, reddish, yellowish, orangish, bluish, greenish, blackish and more. | |
| Colour 2 (description part) | For example: brown, grey, red, yellow, orange, blue, green, black and more. | |
| Qualifier (description part) | For example: silty, sandy, gravelly, clayey, cobbly, organic. | |
| Soil (description part) | For example: CLAY, SILT, SAND, GRAVEL, COBBLES, BOULDERS, PEAT, ORGANIC SOIL and more. | |
| Plasticity (description part) | For example: low, medium, high. | |
| Grading (description part) | For example: fine grained, medium grained, coarse grained, fine to medium grained, medium to coarse grained, fine to coarse grained, well graded, poorly graded and more. | |
| Minor (description part) | ||
| Moisture (description part) | For example: dry, moist, wet, w < PL, w ≈ PL, w > PL, w < LL, w ≈ LL and more. | |
| Structure (description part) | ||
| Additional (description part) | ||
| Origin (description part) | For example: fill, topsoil, alluvium, colluvium, residual soil, extremely weathered rock, estuarine, marine and more. | |
| Material | A material from the workspace catalogue. | |
| Type | Required. One of: Fill, Soil, Rock, Concrete, Void, Other. | |
| Fill | A colour, for example #C0A060. | |
| Boundary | Required. One of: Solid, Dashed, Gradational, Termination, None. | |
| Method | ||
| Colour (text) | Borehole Logging fills it in from other fields. From a list. |
Moisture
| Field | Unit | Notes |
|---|---|---|
| Top | m | Required. 0 or more. |
| Base | m | Required. Deeper than Top. |
| Moisture condition | Required. For example: dry, moist, wet, w < PL, w ≈ PL, w > PL, w < LL, w ≈ LL and more. | |
| Remarks |
Consistency/Density
| Field | Unit | Notes |
|---|---|---|
| Top | m | Required. 0 or more. |
| Base | m | Required. Deeper than Top. |
| Consistency/Density | Required. For example: very soft, soft, firm, stiff, very stiff, hard, very loose, loose and more. | |
| To | For example: very soft, soft, firm, stiff, very stiff, hard, very loose, loose and more. | |
| Remarks |
Defects
| Field | Unit | Notes |
|---|---|---|
| Depth | m | Required. 0 or more. AGS: DISC_TOP. |
| To | m | At least Depth. AGS: DISC_BASE. |
| Type | Required. One of: Bedding, Joint, Shear, Fault, Seam, Fracture zone, Crushed zone, Extremely weathered zone, Extremely weathered seam, Core loss, Handling break, Drilling break, Other. AGS: DISC_TYPE. |
|
| Dip | ° | From -90 to 90. AGS: DISC_DIP. |
| Dip (max) | ° | From -90 to 90. |
| Dip direction | ° | From 0 to 360. AGS: DISC_DIR. |
| Set | AGS: DISC_SET. |
|
| Roughness | For example: POL, SL, SM, RO, VR. | |
| Shape | For example: PR, CU, UN, ST, IR. | |
| Aperture | mm | 0 or more. |
| Thickness | mm | 0 or more. |
| Infill | For example: Clay, Silt, Sand, Ca, Fe, Qz, Cb. | |
| Coating | For example: CN, SN, Fe SN, VNR, CO. | |
| Weathering | ||
| Persistence | mm | 0 or more. |
| Remarks | AGS: DISC_REM. |
Core runs
| Field | Unit | Notes |
|---|---|---|
| Run | Required. | |
| Top | m | Required. 0 or more. AGS: CORE_TOP. |
| Base | m | Required. Deeper than Top. AGS: CORE_BASE. |
| Recovered | m | 0 or more. |
| Solid core | m | 0 or more. |
| RQD length | m | 0 or more. |
| TCR | % | Borehole Logging fills it in from other fields. From 0 to 100. AGS: CORE_PREC. |
| SCR | % | Borehole Logging fills it in from other fields. From 0 to 100. AGS: CORE_SREC. |
| RQD | % | Borehole Logging fills it in from other fields. From 0 to 100. AGS: CORE_RQD. |
| Material | A material from the workspace catalogue. | |
| Rock type | ||
| Colour | From a list. | |
| Legend | A legend from the graphic catalogue. | |
| Fill | A colour, for example #C0A060. | |
| Description | ||
| Defects | ||
| Boundary | Required. One of: Solid, Dashed, Gradational, Termination, None. | |
| Method | ||
| Flush return | % | From 0 to 100. |
| Flush note | ||
| Remarks | AGS: CORE_REM. |
Strength
| Field | Unit | Notes |
|---|---|---|
| Top | m | Required. 0 or more. |
| Base | m | Required. Deeper than Top. |
| From | Required. One of: VL, L, M, H, VH, EH. From a list. | |
| To | Required. One of: VL, L, M, H, VH, EH. From a list. | |
| Remarks |
Weathering
| Field | Unit | Notes |
|---|---|---|
| Top | m | Required. 0 or more. |
| Base | m | Required. Deeper than Top. |
| Weathering | Required. From a list. | |
| Remarks |
Defect spacing
| Field | Unit | Notes |
|---|---|---|
| Top | m | Required. 0 or more. |
| Base | m | Required. Deeper than Top. |
| Min | mm | Required. From 1 to 100000. |
| Max | mm | Required. At least Min. From 1 to 100000. |
| Average | mm | From 1 to 100000. |
| Fracture frequency | /m | From 0 to 1000. |
| Remarks |
Samples & tests
The samples taken, and the tests done in the hole.
Samples
| Field | Unit | Notes |
|---|---|---|
| Sample | Required. AGS: SAMP_REF. |
|
| Type | Required. One of: Auger, Bulk, Hand auger, Push tube, Core, Shelby, Split spoon, Test pit, Undisturbed 100, Undisturbed 50, Validation, Water, Disturbed, Grab, Environmental, Ds, Blk, Undisturbed, U50, U75, St, Spt, Piston. From a list. AGS: SAMP_TYPE. |
|
| Top | m | Required. 0 or more. AGS: SAMP_TOP. |
| Base | m | At least Top. AGS: SAMP_BASE. |
| Recovery | % | From 0 to 100. AGS: SAMP_RECV. |
| Lab ref | ||
| Lab specification | ||
| Remarks | AGS: SAMP_REM. |
In-situ tests
| Field | Unit | Notes |
|---|---|---|
| Test | Required. One of: SPT, DCP, CPT, VST, UCS, IS50, PP, PID, PACKER, PERM, PMT, Other. | |
| Depth | m | Required. 0 or more. |
| To | m | Borehole Logging fills it in from other fields. At least Depth. |
| Blows (150 mm) | Three values: the seating drive, test drive 1 and test drive 2. | |
| Penetration | mm | Three values: the seating drive, test drive 1 and test drive 2. |
| RW | mm | From 0 to 450. |
| HW | mm | From 0 to 450. |
| Stopped by | One of: Refusal, Obstruction. | |
| HB | Tick or clear. | |
| Result | ||
| N60 | Borehole Logging fills it in from other fields. | |
| Reported | Borehole Logging fills it in from other fields. | |
| Hammer | One of: Automatic trip, Rope cathead, Other. | |
| Energy ratio | % | From 1 to 150. |
| Hole dia. | mm | From 1 to 1000. |
| Rod length | m | From 0 to 500. |
| Sampler | One of: Standard, Without liner. | |
| Recovered | mm | From 0 to 1000. |
| Orientation | One of: Diametral, Axial. | |
| Method | One of: Falling head, Rising head, Constant head. | |
| Limit pressure | kPa | 0 or more. |
| Modulus | MPa | 0 or more. |
| < > | One of: <, >. | |
| Result to | At least Result. | |
| Unit | ||
| Peak | kPa | From 0 to 5000. |
| Remoulded | kPa | From 0 to 5000. |
| Remarks |
Hole construction
How the hole was made, and what was put in it.
Boring methods
| Field | Unit | Notes |
|---|---|---|
| Top | m | Required. 0 or more. AGS: HDPH_TOP. |
| Base | m | Required. Deeper than Top. AGS: HDPH_BASE. |
| Code | Required. AGS: HDPH_TYPE. |
|
| Method | ||
| Diameter | mm | 0 or more. |
| Casing to | m | 0 or more. |
| Equipment | ||
| Remarks |
Penetration resistance
| Field | Unit | Notes |
|---|---|---|
| Top | m | Required. 0 or more. |
| Base | m | Required. Deeper than Top. |
| Resistance | Required. For example: VL, L, M, H, VH, R, L-M, M-H and more. | |
| Remarks |
Water return
| Field | Unit | Notes |
|---|---|---|
| Top | m | Required. 0 or more. |
| Base | m | Required. Deeper than Top. |
| Return | % | From 0 to 100. |
| Note | For example: partial loss, total loss. | |
| Remarks |
Installations
| Field | Unit | Notes |
|---|---|---|
| Top | m | Required. 0 or more. |
| Base | m | Required. Deeper than Top. |
| Component | Required. One of: Surface seal, Casing, Blank pipe, Screen, Sand pack, Bentonite, Grout, Backfill, Sump, Other. | |
| Diameter | mm | 0 or more. |
| Material | ||
| Legend | Required. A legend from the graphic catalogue. | |
| Remarks |
Monitoring
Groundwater, and the readings at the start and the end of each shift.
Groundwater
| Field | Unit | Notes |
|---|---|---|
| Depth | m | Required. 0 or more. AGS: WSTG_DPTH. |
| Observation | Required. One of: Encountered, Standing, Seepage, Not encountered. | |
| Observed | A date and time. Type it as DD/MM/YYYY HH:MM. AGS: WSTG_DTIM. |
|
| Condition | ||
| Rose to | m | 0 or more. AGS: WSTK_DEPO. |
| After | min | From 0 to 100000. A whole number. AGS: WSTK_TIME. |
| Casing at | m | 0 or more. AGS: WSTK_CAS. |
| Sealed | Tick or clear. | |
| Remarks | AGS: WSTG_REM. |
Progress & water levels
| Field | Unit | Notes |
|---|---|---|
| Date and time | Required. A date and time. Type it as DD/MM/YYYY HH:MM. | |
| Shift | One of: Start, End. | |
| Hole depth | m | 0 or more. |
| Casing | m | 0 or more. |
| Water | m | 0 or more. |
| Remarks |
Comments
Notes at a depth.
Comments
| Field | Unit | Notes |
|---|---|---|
| Top | m | Required. 0 or more. |
| Base | m | At least Top. |
| Category | Required. One of: General, Inclusion, Drilling, Geology, Groundwater, Casing, Safety, Other. | |
| Comment | Required. |