Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

ADCP entities and attributes for diel surveys where data exists.

Description

ADCP entity for diel surveys

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
DSUITEID
NUMERIC
Unique identifier for each Diel Suite deployed
EXPOCODE
TEXT
Defined as the Ship ICES code + departure date formatted as YYYYMMDD
CRUISE_COMMON_NAME
TEXT
More descriptive name of cruise/mission and is usually in the format [MissionID]-[REGIONDesignation]-[IslandCode if only one visited]
MISSION_CODE
TEXT
A single designation that applies to all the rounds associated with a given mission/cruise
ASSOC_REA_SITE
TEXT
An identifier for the ecological site at the island or atoll (LOCATION) associated with the diel survey. Combines a 3-letter island code (derived from LOCATIONCODE) with a 2-4 digit site number.
OCC_SITEID
TEXT
A 3-dimensional identifier for the fixed location (LATITUDE and LONGITUDE) and depth where the subsurface temperature logger (STR) was deployed at the island or atoll (LOCATION). Includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number. A newly deployed instrument is assigned to a pre-existing OCC_SITEID if its coordinates are within a 100-m diameter and its depth is within a 3-m depth cylinder of a pre-existing OCC_SITEID, otherwise, the instrument is assigned a new OCC_SITEID.
REGION
TEXT
The name of the region where the diel survey was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
REGIONCODE
TEXT
Code for the region surveyed in the Pacific Islands region: American Samoa (SAMOA), Pacific Remote Island Areas (PRIA), Mariana Archipelago (MARIAN), main Hawaiian Islands (MHI), Northwestern Hawaiian Islands (NWHI).
LOCATION
TEXT
Name of island or atoll where the sample was collected in the Pacific Islands region (REGION).
LOCATIONCODE
TEXT
3-Letter unique code for LOCATION.
LATITUDE
NUMERIC
Latitude in decimal degrees, WGS84, for the given Site
LONGITUDE
NUMERIC
Longitude in decimal degrees, WGS84, for the given Site
DEPTH_M
NUMERIC
OCC Survey depth (m) from dive computer at diel suite deployment
YEAR
NUMERIC
Year of the mission
UTCDATETIME
DATE
UTC date and time of pressure measured from the ADCP, collected every 2 minutes.
CTD_SAMPLEINTERVAL_SEC
NUMERIC
Sample interval for CTD data.
PRESSURE_DB
NUMERIC
Measured pressure value in decibars, measured from an ADCP co-located at the SiteID with a CTD that collected only temperature and conductivity (a non-standard CTD for most diel surveys). ADCP pressure is substituted for pressure measured from the CTD in the carbonate chemistry calculations for diel surveys conducted in 2016 in the PRIA.
TEMP_DEGC
NUMERIC
Measured temperature value in degrees Celsius.
SALN_PSU
NUMERIC
Calculated salinity value in Practical Salinity Units (PSU) .
DENSITY_SIGMAT
NUMERIC
Calculated sigma-t density value, the density of seawater at atmospheric pressure minus 1000 kilograms/cubic meter. NULL if pressure is NULL.
ADCP_SAMPLEINTERVAL_SEC
NUMERIC
Sample interval for ADCP data.
HEIGHTBIN_M
NUMERIC
Height bin above the ADCP. Each height bin is represented as the upper limit of the bin height above the sensor on the seafloor (for example, a 1.4 m bin represents current data collected between 0.4 m and 1.4 m above the ADCP). ADCP data include a blanking region, or a small distance in front of the transducer in which measurements cannot be made, of 0.2-0.4 m, and typically grouped into 1-m height bins, though smaller bin sizes (0.25 m or 0.5 m) are used for shallower deployments (2016).
DIRECTION_DEG
NUMERIC
Current direction, measured in degrees (0-360). Data are trimmed to a maximum height bin for each time interval using pressure data to remove above-water signal. As a result, NULL values may exist for larger height bins above the surface of the water due to waves and tides.
SPEED_MS
NUMERIC
Current magnitude (speed), measured in meters per second. Calculated as the square root of the sum of the squared u and v velocities. Data are trimmed to a maximum height bin for each time interval using pressure data to remove above-water signal. As a result, NULL values may exist for larger height bins above the surface of the water due to waves and tides.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Item Identification

Title: ESD_DS_DataDict_2018_AMSM_ADCP
Status: Completed
Abstract:

ADCP entities and attributes for diel surveys where data exists.

Notes:

If CTD sensor failed to log pressure as in a diel suite deployment in 2016, depth was calculated with pressures as recorded from ADCP.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

ADCP entity for diel surveys

Change Summary:

In 2021, a unique identifier for diel suite deployments was included as DSUITEID to improve data structure across data tables. Other columns were renamed or added to improve data management efficiency.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
DSUITEID NUMERIC Unique identifier for each Diel Suite deployed
100
EXPOCODE TEXT Defined as the Ship ICES code + departure date formatted as YYYYMMDD
100
CRUISE_COMMON_NAME TEXT More descriptive name of cruise/mission and is usually in the format [MissionID]-[REGIONDesignation]-[IslandCode if only one visited]
100
MISSION_CODE TEXT A single designation that applies to all the rounds associated with a given mission/cruise
100
ASSOC_REA_SITE TEXT An identifier for the ecological site at the island or atoll (LOCATION) associated with the diel survey. Combines a 3-letter island code (derived from LOCATIONCODE) with a 2-4 digit site number.
100
OCC_SITEID TEXT A 3-dimensional identifier for the fixed location (LATITUDE and LONGITUDE) and depth where the subsurface temperature logger (STR) was deployed at the island or atoll (LOCATION). Includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number. A newly deployed instrument is assigned to a pre-existing OCC_SITEID if its coordinates are within a 100-m diameter and its depth is within a 3-m depth cylinder of a pre-existing OCC_SITEID, otherwise, the instrument is assigned a new OCC_SITEID.
100
REGION TEXT The name of the region where the diel survey was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
100
REGIONCODE TEXT Code for the region surveyed in the Pacific Islands region: American Samoa (SAMOA), Pacific Remote Island Areas (PRIA), Mariana Archipelago (MARIAN), main Hawaiian Islands (MHI), Northwestern Hawaiian Islands (NWHI).
100
LOCATION TEXT Name of island or atoll where the sample was collected in the Pacific Islands region (REGION).
100
LOCATIONCODE TEXT 3-Letter unique code for LOCATION.
100
LATITUDE NUMERIC Latitude in decimal degrees, WGS84, for the given Site
100
LONGITUDE NUMERIC Longitude in decimal degrees, WGS84, for the given Site
100
DEPTH_M NUMERIC OCC Survey depth (m) from dive computer at diel suite deployment
100
YEAR NUMERIC Year of the mission
100
UTCDATETIME DATE UTC date and time of pressure measured from the ADCP, collected every 2 minutes.
100
CTD_SAMPLEINTERVAL_SEC NUMERIC Sample interval for CTD data.
100
PRESSURE_DB NUMERIC Measured pressure value in decibars, measured from an ADCP co-located at the SiteID with a CTD that collected only temperature and conductivity (a non-standard CTD for most diel surveys). ADCP pressure is substituted for pressure measured from the CTD in the carbonate chemistry calculations for diel surveys conducted in 2016 in the PRIA.
100
TEMP_DEGC NUMERIC Measured temperature value in degrees Celsius.
100
SALN_PSU NUMERIC Calculated salinity value in Practical Salinity Units (PSU) .
100
DENSITY_SIGMAT NUMERIC Calculated sigma-t density value, the density of seawater at atmospheric pressure minus 1000 kilograms/cubic meter. NULL if pressure is NULL.
100
ADCP_SAMPLEINTERVAL_SEC NUMERIC Sample interval for ADCP data.
100
HEIGHTBIN_M NUMERIC Height bin above the ADCP. Each height bin is represented as the upper limit of the bin height above the sensor on the seafloor (for example, a 1.4 m bin represents current data collected between 0.4 m and 1.4 m above the ADCP). ADCP data include a blanking region, or a small distance in front of the transducer in which measurements cannot be made, of 0.2-0.4 m, and typically grouped into 1-m height bins, though smaller bin sizes (0.25 m or 0.5 m) are used for shallower deployments (2016).
100
DIRECTION_DEG NUMERIC Current direction, measured in degrees (0-360). Data are trimmed to a maximum height bin for each time interval using pressure data to remove above-water signal. As a result, NULL values may exist for larger height bins above the surface of the water due to waves and tides.
100
SPEED_MS NUMERIC Current magnitude (speed), measured in meters per second. Calculated as the square root of the sum of the squared u and v velocities. Data are trimmed to a maximum height bin for each time interval using pressure data to remove above-water signal. As a result, NULL values may exist for larger height bins above the surface of the water due to waves and tides.

Attribute Details

DSUITEID

CC ID: 1077443
Seq. Order: 1
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier for each Diel Suite deployed

EXPOCODE

CC ID: 1077444
Seq. Order: 2
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Defined as the Ship ICES code + departure date formatted as YYYYMMDD

CRUISE_COMMON_NAME

CC ID: 1077445
Seq. Order: 3
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

More descriptive name of cruise/mission and is usually in the format [MissionID]-[REGIONDesignation]-[IslandCode if only one visited]

MISSION_CODE

CC ID: 1077446
Seq. Order: 4
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

A single designation that applies to all the rounds associated with a given mission/cruise

ASSOC_REA_SITE

CC ID: 1077447
Seq. Order: 5
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

An identifier for the ecological site at the island or atoll (LOCATION) associated with the diel survey. Combines a 3-letter island code (derived from LOCATIONCODE) with a 2-4 digit site number.

OCC_SITEID

CC ID: 1077448
Seq. Order: 6
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

A 3-dimensional identifier for the fixed location (LATITUDE and LONGITUDE) and depth where the subsurface temperature logger (STR) was deployed at the island or atoll (LOCATION). Includes "OCC" prefix, a 3-letter location code (derived from LOCATION), and a 3-digit site number. A newly deployed instrument is assigned to a pre-existing OCC_SITEID if its coordinates are within a 100-m diameter and its depth is within a 3-m depth cylinder of a pre-existing OCC_SITEID, otherwise, the instrument is assigned a new OCC_SITEID.

REGION

CC ID: 1077449
Seq. Order: 7
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

The name of the region where the diel survey was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.

REGIONCODE

CC ID: 1077450
Seq. Order: 8
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Code for the region surveyed in the Pacific Islands region: American Samoa (SAMOA), Pacific Remote Island Areas (PRIA), Mariana Archipelago (MARIAN), main Hawaiian Islands (MHI), Northwestern Hawaiian Islands (NWHI).

LOCATION

CC ID: 1077451
Seq. Order: 9
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Name of island or atoll where the sample was collected in the Pacific Islands region (REGION).

LOCATIONCODE

CC ID: 1077452
Seq. Order: 10
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

3-Letter unique code for LOCATION.

LATITUDE

CC ID: 1077453
Seq. Order: 11
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Latitude in decimal degrees, WGS84, for the given Site

LONGITUDE

CC ID: 1077454
Seq. Order: 12
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degrees, WGS84, for the given Site

DEPTH_M

CC ID: 1077455
Seq. Order: 13
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

OCC Survey depth (m) from dive computer at diel suite deployment

YEAR

CC ID: 1077456
Seq. Order: 14
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Year of the mission

UTCDATETIME

CC ID: 1077457
Seq. Order: 15
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

UTC date and time of pressure measured from the ADCP, collected every 2 minutes.

CTD_SAMPLEINTERVAL_SEC

CC ID: 1077458
Seq. Order: 16
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Sample interval for CTD data.

PRESSURE_DB

CC ID: 1077459
Seq. Order: 17
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Measured pressure value in decibars, measured from an ADCP co-located at the SiteID with a CTD that collected only temperature and conductivity (a non-standard CTD for most diel surveys). ADCP pressure is substituted for pressure measured from the CTD in the carbonate chemistry calculations for diel surveys conducted in 2016 in the PRIA.

TEMP_DEGC

CC ID: 1077460
Seq. Order: 18
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Measured temperature value in degrees Celsius.

SALN_PSU

CC ID: 1077461
Seq. Order: 19
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Calculated salinity value in Practical Salinity Units (PSU) .

DENSITY_SIGMAT

CC ID: 1077462
Seq. Order: 20
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Calculated sigma-t density value, the density of seawater at atmospheric pressure minus 1000 kilograms/cubic meter. NULL if pressure is NULL.

ADCP_SAMPLEINTERVAL_SEC

CC ID: 1077463
Seq. Order: 21
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Sample interval for ADCP data.

HEIGHTBIN_M

CC ID: 1077464
Seq. Order: 22
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Height bin above the ADCP. Each height bin is represented as the upper limit of the bin height above the sensor on the seafloor (for example, a 1.4 m bin represents current data collected between 0.4 m and 1.4 m above the ADCP). ADCP data include a blanking region, or a small distance in front of the transducer in which measurements cannot be made, of 0.2-0.4 m, and typically grouped into 1-m height bins, though smaller bin sizes (0.25 m or 0.5 m) are used for shallower deployments (2016).

DIRECTION_DEG

CC ID: 1077465
Seq. Order: 23
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Current direction, measured in degrees (0-360). Data are trimmed to a maximum height bin for each time interval using pressure data to remove above-water signal. As a result, NULL values may exist for larger height bins above the surface of the water due to waves and tides.

SPEED_MS

CC ID: 1077466
Seq. Order: 24
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

Current magnitude (speed), measured in meters per second. Calculated as the square root of the sum of the squared u and v velocities. Data are trimmed to a maximum height bin for each time interval using pressure data to remove above-water signal. As a result, NULL values may exist for larger height bins above the surface of the water due to waves and tides.

Catalog Details

Catalog Item ID: 55939
GUID: gov.noaa.nmfs.inport:55939
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2019-03-22 19:27+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-08-03
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-08-03
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-08-03