Sea bed 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.
EQUIPMENT_START_DATE DATE Date on which use of a specific piece of equipment began.
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 sea bed in metres (to the nearest centimetre).
DEPTH_BASE NUMBER Lower depth relative to the sea bed 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_6_5 NUMBER Sediment that has passed through the -7.0 phi sieve and has been retained by the -6.5 phi sieve, or equivalent (90510-128000 micron).
PHI_MI_6_0 NUMBER Sediment that has passed through the -6.5 phi sieve and has been retained by the -6.0 phi sieve, or equivalent (64000-90510 micron).
PHI_MI_6 NUMBER Sediment that has passed through the -7.0 phi sieve and has been retained by the -6.0 phi sieve, or equivalent (64000-128000 micron).
PHI_MI_5_5 NUMBER Sediment that has passed through the -6.0 phi sieve and has been retained by the -5.5 phi sieve, or equivalent (45255-64000 micron).
PHI_MI_5_0 NUMBER Sediment that has passed through the -5.5 phi sieve and has been retained by the -5.0 phi sieve, or equivalent (32000-45255 micron).
PHI_MI_5 NUMBER Sediment that has passed through the -6.0 phi sieve and has been retained by the -5.0 phi sieve, or equivalent (32000-64000 micron).
PHI_MI_4_5 NUMBER Sediment that has passed through the -5.0 phi sieve and has been retained by the -4.5 phi sieve, or equivalent (22627-32000 micron).
PHI_MI_4_0 NUMBER Sediment that has passed through the -4.5 phi sieve and has been retained by the -4.0 phi sieve, or equivalent (16000-22627 micron).
PHI_MI_4 NUMBER Sediment that has passed through the -5.0 phi sieve and has been retained by the -4.0 phi sieve, or equivalent (16000-32000 micron).
PHI_MI_3_5 NUMBER Sediment that has passed through the -4.0 phi sieve and has been retained by the -3.5 phi sieve, or equivalent (11314-16000 micron).
PHI_MI_3_0 NUMBER Sediment that has passed through the -3.5 phi sieve and has been retained by the -3.0 phi sieve, or equivalent (8000-11314 micron).
PHI_MI_3 NUMBER Sediment that has passed through the -4.0 phi sieve and has been retained by the -3.0 phi sieve, or equivalent (8000-16000 micron).
PHI_MI_2_5 NUMBER Sediment that has passed through the -3.0 phi sieve and has been retained by the -2.5 phi sieve, or equivalent (5657-8000 micron).
PHI_MI_2_0 NUMBER Sediment that has passed through the -2.5 phi sieve and has been retained by the -2.0 phi sieve, or equivalent (4000-5657 micron).
PHI_MI_2 NUMBER Sediment that has passed through the -3.0 phi sieve and has been retained by the -2.0 phi sieve, or equivalent (4000-8000 micron).
PHI_MI_1_5 NUMBER Sediment that has passed through the -2.0 phi sieve and has been retained by the -1.5 phi sieve, or equivalent (2828-4000 micron).
PHI_MI_1_0 NUMBER Sediment that has passed through the -1.5 phi sieve and has been retained by the -1.0 phi sieve, or equivalent (2000-2828 micron).
PHI_MI_1 NUMBER Sediment that has passed through the -2.0 phi sieve and has been retained by the -1.0 phi sieve, or equivalent (2000-4000 micron).
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, or equivalent (1414-2000 micron).
PHI_MI_0_25 NUMBER Sediment that has passed through the -0.5 phi sieve and has been retained by the -0.25 phi sieve, or equivalent (1189-1414 micron).
PHI_0 NUMBER Sediment that has passed through the -1.0 phi sieve and has been retained by the 0.0 phi sieve, or equivalent (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, or equivalent (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, or equivalent (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, or equivalent (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, or equivalent (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, or equivalent (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, or equivalent (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, or equivalent (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, or equivalent (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, or equivalent (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, or equivalent (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, or equivalent (88-125 micron).
PHI_3_75 NUMBER Sediment that has passed through the 3.5 phi sieve and has been retained by the 3.75 phi sieve, or equivalent (74-88 micron).
PHI_4 NUMBER Sediment that has passed through the 3.0 phi sieve and has been retained by the 4.0 phi sieve, or equivalent (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, or equivalent (62.5-88 micron).
PHI_4_5 NUMBER Sediment that has passed through the 4.0 phi sieve and has been retained by the 4.5 phi sieve, or equivalent (44.2-62.5 micron).
PHI_5 NUMBER Sediment that has passed through the 4.0 phi sieve and has been retained by the 5.0 phi sieve, or equivalent (31.25-62.5 micron). The range is the coarse silt fraction according to the Wentworth classification.
PHI_5_0 NUMBER Sediment that has passed through the 4.5 phi sieve and has been retained by the 5.0 phi sieve, or equivalent (31.25-44.2 micron).
PHI_5_5 NUMBER Sediment that has passed through the 5.0 phi sieve and has been retained by the 5.5 phi sieve, or equivalent (22-31.25 micron).
PHI_6 NUMBER Sediment that has passed through the 5.0 phi sieve and has been retained by the 6.0 phi sieve, or equivalent (15.6-31.25 micron). The range is the medium silt fraction according to the Wentworth classification.
PHI_6_0 NUMBER Sediment that has passed through the 5.5 phi sieve and has been retained by the 6.0 phi sieve, or equivalent (15.6-22 micron).
PHI_6_5 NUMBER Sediment that has passed through the 6.0 phi sieve and has been retained by the 6.5 phi sieve, or equivalent (11-15.6 micron).
PHI_7 NUMBER Sediment that has passed through the 6.0 phi sieve and has been retained by the 7.0 phi sieve, or equivalent (7.8-15.6 micron). The range is the fine silt fraction according to the Wentworth classification.
PHI_7_0 NUMBER Sediment that has passed through the 6.5 phi sieve and has been retained by the 7.0 phi sieve, or equivalent (7.8-11 micron).
PHI_7_5 NUMBER Sediment that has passed through the 7.0 phi sieve and has been retained by the 7.5 phi sieve, or equivalent (5.5-7.8 micron).
PHI_8 NUMBER Sediment that has passed through the 7.0 phi sieve and has been retained by the 8.0 phi sieve, or equivalent (3.9-7.8 micron). The range is the very fine silt fraction according to the Wentworth classification.
PHI_8_0 NUMBER Sediment that that has passed through the 7.5 phi sieve and has been retained by the 8.0 phi sieve, or equivalent (3.9-5.5 micron).
PHI_8_5 NUMBER Sediment that has passed through the 8.0 phi sieve and has been retained by the 8.5 phi sieve, or equivalent (2.76-3.9 micron).
PHI_9 NUMBER Sediment that has passed through the 8.0 phi sieve and has been retained by the 9.0 phi sieve, or equivalent (2-3.9 micron).
PHI_9_0 NUMBER Sediment that has passed through the 8.5 phi sieve and has been retained by the 9.0 phi sieve, or equivalent (2-2.76 micron).
PHI_9_5 NUMBER Sediment that has passed through the 9.0 phi sieve and has been retained by the 9.5 phi sieve, or equivalent (1.38-2 micron).
PHI_10 NUMBER Sediment that has passed through the 9.0 phi sieve and has been retained by the 10.0 phi sieve, or equivalent (0.98-2 micron).
PHI_10_0 NUMBER Sediment that has passed through the 9.5 phi sieve and has been retained by the 10.0 phi sieve, or equivalent (0.98-1.38 micron).
PHI_10_5 NUMBER Sediment that has passed through the 10.0 phi sieve and has been retained by the 10.5 phi sieve, or equivalent (0.69-0.98 micron).
PHI_11 NUMBER Sediment that has passed through the 10.0 phi sieve and has been retained by the 11.0 phi sieve, or equivalent (0.49-0.98 micron).
PHI_11_0 NUMBER Sediment that has passed through the 10.5 phi sieve and has been retained by the 11.0 phi sieve, or equivalent (0.49-0.69 micron).
PHI_11_5 NUMBER Sediment that has passed through the 11.0 phi sieve and has been retained by the 11.5 phi sieve, or equivalent (0.35-0.49 micron).
PHI_12 NUMBER Sediment that has passed through the 11.0 phi sieve and has been retained by the 12.0 phi sieve, or equivalent (0.25-0.49 micron).
PHI_12_0 NUMBER Sediment that has passed through the 11.5 phi sieve and has been retained by the 12.0 phi sieve, or equivalent (0.25-0.35 micron).
PHI_12_5 NUMBER Sediment that has passed through the 12.0 phi sieve and has been retained by the 12.5 phi sieve, or equivalent (0.175-0.25 micron).
PHI_13 NUMBER Sediment that has passed through the 12.0 phi sieve and has been retained by the 13.0 phi sieve, or equivalent (0.125-0.25 micron).
PHI_13_0 NUMBER Sediment that has passed through the 12.5 phi sieve and has been retained by the 13.0 phi sieve, or equivalent (0.125-0.175 micron).
PHI_13_5 NUMBER Sediment that has passed through the 13.0 phi sieve and has been retained by the 13.5 phi sieve, or equivalent (0.085-0.125 micron).
PHI_14 NUMBER Sediment that has passed through the 13.0 phi sieve and has been retained by the 14.0 phi sieve, or equivalent (0.06-01.25 micron).
PHI_14_0 NUMBER Sediment that has passed through the 13.5 phi sieve and has been retained by the 14.0 phi sieve, or equivalent (0.06-0.085 micron).
PHI_14_5 NUMBER Sediment that has passed through the 14.0 phi sieve and has been retained by the 14.5 phi sieve, or equivalent (0.04-0.06 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.