Geochemical data | Attribute Descriptions

COLUMN NAME DATA TYPE DESCRIPTION
GEOCHEMICAL_DATA_ID NUMBER Unique identifier of a geochemical 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).
ANALYSIS_SOURCE TEXT Source of the analysis.
LI_PPM NUMBER Lithium (ppm)
BE_PPM NUMBER Beryllium (ppm)
B_PPM NUMBER Boron (ppm)
MGO_PER NUMBER Magnesium (percent)
AL2O3_PER NUMBER Aluminium (percent)
SIO2_PER NUMBER Silicon (percent)
P_PER NUMBER Phosphorus (percent)
K2O_PER NUMBER Potassium (percent)
CAO_PER NUMBER Calcium (percent)
SC_PPM NUMBER Scandium (ppm)
TIO2_PER NUMBER Titanium (percent)
V_PPM NUMBER Vanadium (ppm)
CR_PPM NUMBER Chromium (ppm)
MN_PER NUMBER Manganese (percent)
FE2O3_PER NUMBER Iron (percent)
CO_PPM NUMBER Cobalt (ppm)
NI_PPM NUMBER Nickel (ppm)
CU_PPM NUMBER Copper (ppm)
ZN_PPM NUMBER Zinc (ppm)
GA_PPM NUMBER Gallium (ppm)
GE_PPM NUMBER Germanium (ppm)
RB_PPM NUMBER Rubidium (ppm)
SR_PPM NUMBER Strontium (ppm)
Y_PPM NUMBER Yttrium (ppm)
ZR_PPM NUMBER Zirconium (ppm)
NB_PPM NUMBER Niobium (ppm)
MO_PPM NUMBER Molybdenum (ppm)
AG_PPM NUMBER Silver (ppm)
CD_PPM NUMBER Cadmium (ppm)
SN_PPM NUMBER Strontium (ppm)
BA_PPM NUMBER Barium (ppm)
LA_PPM NUMBER Lanthanum (ppm)
CE_PPM NUMBER Cerium (ppm)
ND_PPM NUMBER Neodymium (ppm)
HG_PPM NUMBER Mercury (ppm)
PB_PPM NUMBER Lead (ppm)
BI_PPM NUMBER Bismuth (ppm)
U_PPM NUMBER Uranium (ppm)
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.