Seabed sediment data | Attribute descriptions

COLUMN NAME DATA TYPE DESCRIPTION
PSA_DATA_ID NUMBER Unique identifier of a particle size analysis 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).
DEPTH_TOP NUMBER Upper depth relative to the seabed in metres (to the nearest centimetre).
DEPTH_BASE NUMBER Lower depth relative to the seabed in metres (to the nearest centimetre).
ANALYSIS_SOURCE TEXT Source of the analysis.
FOLK_CLASS TEXT Abbreviation by which the folk classification is known.
FOLK TEXT Description of the folk classification.
WEIGHT NUMBER Total weight of sample, grams.
WEIGHT_UNITS TEXT Weight units, grams.
GRAV NUMBER Percentage gravel.
SAND NUMBER Percentage sand.
MUD NUMBER Percentage mud.
GSM_UNITS TEXT Gravel, sand and mud units, percent.
TGRAV NUMBER Weight of gravel used in carbonate test, grams.
CGRAV NUMBER Percentage carbonate in gravel.
TSAND NUMBER Weight of sand used in carbonate test, grams.
CSAND NUMBER Percentage carbonate in sand.
TMUD NUMBER Weight of mud used in carbonate test, grams.
CMUD NUMBER Percentage carbonate in mud.
CTOT NUMBER Percentage carbonate in total sample.
CARBONATE_UNITS TEXT Carbonate units, percent.
PHI_MI_0_5

NUMBER

Sediment that has passed through the -1.0 phi sieve and has been retained by the -0.5 phi sieve (1414-2000 micron).
PHI_0 NUMBER Sediment that has passed through the -1.0 phi sieve and has been retained by the 0.0 phi sieve (1000-2000 micron). The range is the very coarse sand fraction according to the Wentworth classification.
PHI_0_0 NUMBER Sediment that has passed through the -0.5 phi sieve and has been retained by the 0.0 phi sieve (1000-1414 micron).
PHI_0_5 NUMBER Sediment that has passed through the 0.0 phi sieve and has been retained by the 0.5 phi sieve (707-1000 micron).
PHI_1 NUMBER Sediment that has passed through the 0.0 phi sieve and has been retained by the 1.0 phi sieve (500-1000 micron). The range is the coarse sand fraction according to the Wentworth classification.
PHI_1_0 NUMBER Sediment that has passed through the 0.5 phi sieve and has been retained by the 1.0 phi sieve (500-707 micron).
PHI_1_5 NUMBER Sediment that has passed through the 1.0 phi sieve and has been retained by the 1.5 phi sieve (354-500 micron).
PHI_2 NUMBER Sediment that has passed through the 1.0 phi sieve and has been retained by the 2.0 phi sieve (250-500 micron). The range is the medium sand fraction according to the Wentworth classification.
PHI_2_0 NUMBER Sediment that has passed through the 1.5 phi sieve and has been retained by the 2.0 phi sieve (250-354 micron).
PHI_2_5 NUMBER Sediment that has passed through the 2.0 phi sieve and has been retained by the 2.5 phi sieve (177-250 micron).
PHI_3 NUMBER Sediment that has passed through the 2.0 phi sieve and has been retained by the 3.0 phi sieve (125-250 micron). The range is the fine sand fraction according to the Wentworth classification.
PHI_3_0 NUMBER Sediment that has passed through the 2.5 phi sieve and has been retained by the 3.0 phi sieve (125-177 micron).
PHI_3_5 NUMBER Sediment that has passed through the 3.0 phi sieve and has been retained by the 3.5 phi sieve (88-125 micron).
PHI_4 NUMBER Sediment that has passed through the 3.0 phi sieve and has been retained by the 4.0 phi sieve (62.5-125 micron). The range is the very fine sand fraction according to the Wentworth classification.
PHI_4_0 NUMBER Sediment that has passed through the 3.5 phi sieve and has been retained by the 4.0 phi sieve (62.5-88 micron).
PHI_UNITS TEXT PHI units, either grams or percent.
ADDITIONAL_INFO TEXT Any additional information relating to the particle size analysis e.g. quality control, standards.
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.