Geological data | Attribute descriptions

COLUMN NAME DATA TYPE DESCRIPTION
GEOLOGICAL_DATA_ID NUMBER Unique identifier of a geological 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).
UNIT_DEPTH_TOP NUMBER Upper depth of the lithological unit relative to the seabed in metres (to the nearest centimetre).
UNIT_DEPTH_BASE NUMBER Basal depth of the lithological unit relative to the seabed in metres (to the nearest centimetre).
UNIT_LENGTH NUMBER Length of the lithological unit in metres (to the nearest centimetre).
INTERP_SOURCE TEXT Source of the interpretation.
BASE_BED TEXT Base of bed, nature of the basal contact of a unit.
BED_TYPE TEXT Bedding type.
CGI_BED_TYPE TEXT Commission for the Management and Application of Geoscience Information (CGI) bedding type.
H2S_ODOUR TEXT H2S (hydrogen sulphide) odour presence.
JOINTING TEXT Jointing based on Bieniawski Geomechanics Classification.
HEAVY_MINERALS TEXT Heavy minerals presence.
MICA TEXT Mica presence.
GLAUCONITE TEXT Glauconite presence.
CALCAREOUS TEXT Calcareous mineral presence.
HCL_REACTION TEXT HCL reaction.
ROCK_CLASS_MAIN TEXT Main rock classification.
ROCK_CLASS_MINOR TEXT Minor rock classification.
CGI_SIMPLE_LITHOLOGY TEXT Commission for the Management and Application of Geoscience Information (CGI) simple lithology.
GRAIN_SIZE_MIN TEXT Visual estimate of the minimum grain size according to the Udden-Wentworth scale.
GRAIN_SIZE_MAX TEXT Visual estimate of the maximum grain size according to the Udden-Wentworth scale.
GRAIN_SIZE_MEAN TEXT Visual estimate of the mean grain size according to the Udden-Wentworth scale.
SAND_GRAIN_SIZE_MIN TEXT Minimum sand grain size.
SAND_GRAIN_SIZE_MAX TEXT Maximum sand grain size.
SORTING TEXT Sorting quality.
SAND_SPHERICITY TEXT Sand sphericity (High or Low).
SAND_ROUNDNESS_MIN TEXT Minimum sand roundness.
SAND_ROUNDNESS_MAX TEXT Maximum sand roundness.
GRAVEL_PERC_SHELL NUMBER Percentage of the gravel fraction which is made up of shell material.
GRAVEL_PERC_SHELL_UNITS TEXT Units of measurement for percentage of the gravel fraction which is made up of shell material.
SAND_PERC_SHELL NUMBER Percentage of the sand fraction which is made up of shell material.
SAND_PERC_SHELL_UNITS TEXT Units of measurement for percentage of the sand fraction which is made up of shell material.
GRAVEL_MAX_CLAST_SIZE NUMBER Size of the biggest clast in the gravel fraction (in millimetres).
GRAVEL_MAX_CLAST_SIZE_UNITS TEXT Units of measurement for size of the biggest clast in the gravel fraction.
GRAVEL_SPHERICITY TEXT Gravel sphericity (High or Low).
GRAVEL_ROUNDNESS_MIN TEXT Minimum gravel roundness.
GRAVEL_ROUNDNESS_MAX TEXT Maximum gravel roundness.
MUD_HARDNESS_MIN TEXT Minimum mud hardness.
MUD_HARDNESS_MAX TEXT Maximum mud hardness.
MUD_PLASTICITY_MIN TEXT Minimum mud plasticity.
MUD_PLASTICITY_MAX TEXT Maximum mud plasticity.
CHRONOSTRAT_MIN TEXT Minimum age chronostratigraphy.
CHRONOSTRAT_MAX TEXT Maximum age chronostratigraphy.
LITHOSTRAT TEXT Lithostratigraphy.
FAUNA_FOSSILS TEXT Fauna fossils presence.
WHOLE_SHELLS TEXT Whole shells presence.
FORAMS TEXT Foraminifera presence.
PLANT_REMAINS TEXT Plant remains presence.
BIOTURBATION TEXT Bioturbation index.
MUNSELL_CODE_MAIN TEXT Main munsell soil colour code.
MUNSELL_COLOUR_MAIN TEXT Main munsell soil colour.
MUNSELL_CODE_MINOR TEXT Minor munsell soil colour code.
MUNSELL_COLOUR_MINOR TEXT Minor munsell soil colour.
GEOLOGIST TEXT Geologist who described the geological data.
GEOL_DESC TEXT Geological description.
ADDITIONAL_INFO TEXT Any additional information.
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.