Geotechnical data | Attribute descriptions

COLUMN NAME DATA TYPE DESCRIPTION
GEOTECHNICAL_DATA_ID NUMBER Unique identifier of a geotechnical data record.
ACTIVITY_ID NUMBER Unique identifier of a sampling activity.
SAMPLE_NAME TEXT Unique name used to identify a sample/activity. It is a concatenation of the survey station identifier, the equipment code and the equipment attempt.
TERMS_OF_USE TEXT Terms under which the data can be used.
TERMS_OF_USE_URL TEXT Location of the terms of use.
SAMPLE_ALIAS TEXT Alternative name by which an activity may be identified. May have been used in literature or by an external organisation.
SAMPLE_SOURCE TEXT Cruise or Offshore Report with which the activity is associated.
CLIENT TEXT If activity is linked to a cruise, client for whom the project was carried out. If activity is linked to a report, client for whom the report was produced.
CONTRACTOR TEXT If activity is linked to a cruise, contractor who undertook the project on behalf of the client. If activity is linked to a report, contractor who produced the report on behalf of the client.
EQUIPMENT_TYPE TEXT Type of equipment used for sampling.
EPSG_CODE NUMBER EPSG (OGP) code for the horizontal coordinate system.
EPSG TEXT Translation of the EPSG (OGP) code for the horizontal coordinate system.
X NUMBER The X coordinate. It may be lat/long, national grid, UTM, etc.
Y NUMBER The Y coordinate. It may be lat/long, national grid, UTM, etc.
XY_SOURCE TEXT Source of the X and Y coordinates. It should normally be the original value but may have been recalculated to give better accuracy.
X_ED50 NUMBER X coordinate using the ED50 coordinate system.
Y_ED50 NUMBER Y coordinate using the ED50 coordinate system.
X_WGS84 NUMBER X coordinate using the WGS84 coordinate system.
Y_WGS84 NUMBER Y coordinate using the WGS84 coordinate system.
X_BNG NUMBER Easting (X) using the British National Grid coordinate system.
Y_BNG NUMBER Northing (Y) using the British National Grid coordinate system.
DEPTH_UNITS TEXT Depth units, metres (to the nearest centimetre).
WATER_DEPTH NUMBER Water depth in metres.
DEPTH_DATUM TEXT Depth datum (vertical coordinate system).
DEPTH_SOURCE TEXT Source of the water depth.
TERMINAL_DEPTH NUMBER Maximum depth achieved by an activity in metres (to the nearest centimetre).
MEAS_DEPTH NUMBER Depth of reading relative to the seabed in metres (to the nearest centimetre).
MEAS_SOURCE TEXT Source of the measurement.
MEAS_ORIENTATION TEXT Measurement orientation (Vertical, Horizontal or Unknown).
SHEAR_STRENGTH NUMBER Shear strength, the average of the hand vane readings multiplied by the conversion factor (in kPa).
SHEAR_STRENGTH_UNITS TEXT Units of measurement for SHEAR_STRENGTH, kPa.
COMPR_STRENGTH NUMBER Compressive strength, the average of the penetrometer head readings multiplied by the conversion factor (in kPa).
COMPR_STRENGTH_UNITS TEXT Units of measurement for COMPR_STRENGTH, kPa.
CONFIDENTIALITY TEXT Confidentiality classification.
ACCESSUSE_RESTRIC TEXT Access and use restrictions.
SHAPE_WGS84 SDO_GEOMETRY Point in WGS84 (SRID=4326) derived from the X,Y coordinates of the sampling activity.