Activity data | Attribute descriptions

COLUMN NAME DATA TYPE DESCRIPTION
ACTIVITY_ID NUMBER Unique identifier of a sampling activity record.
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.
IMAGE_URL TEXT Location of the scanned image.
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.
DGSQ TEXT One degree square of latitude and longitude defined by bottom south-west corner of the square. Format e.g. +54-001 appended with a sequential accession number forms a unique identifier for a survey station e.g. +54-001/230.
NUM NUMBER Sequential accession number which is appended to the degree square to uniquely identify each survey station e.g. +54-001/123.
CRUISE TEXT Name by which a cruise is known.
SHIP TEXT Name of the ship used on the survey.
SOURCE_TITLE TEXT Title of either the associated survey or offshore report.
OFFSHORE_REPORT TEXT Report number from which details of the sample were obtained.
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.
EQUIPMENT_ATTEMPT NUMBER Sequence number for the use of a specific piece of equipment at a particular survey station. There could be multiple attempts because of equipment failure or because of different operational requirements.
SUCCESS TEXT Success of an activity. Used to indicate if a sample has been recovered and if not reasons for failure.
RECOVERY_VOLUME NUMBER Volume recovered, generally from a grab or dredging device, in litres.
RECOVERY_VOLUME_UNITS TEXT Recovery volume units, litres.
SAMPLE_RETAINED TEXT Set to Y if the sample has been retained and N if the sample has been discarded after processing.
SEABED_PHOTO TEXT Flag is set to Y if a seabed photo was taken at the site of the sampling activity.
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).
GEOL_SUMMARY TEXT Summary description of the sediments or bottom conditions encountered at a survey station.
ADDITIONAL_INFO TEXT Any additional information relating to a sampling activity e.g. collection methods, quality observations, limits or caveats on use, purpose of collection, relevant references.
CONFIDENTIALITY TEXT Confidentiality classification.
ACCESSUSE_RESTRIC TEXT Access and use restrictions.
RELEASE_DATE DATE Data release date, where set will determine settings of confidentiality and access and use restrictions.
SHAPE_WGS84 SDO_GEOMETRY Point in WGS84 (SRID=4326) derived from the X,Y coordinates of the sampling activity.