ESD_DS_DataDict_2018_AMSM_ADCP
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:55939 | Updated: August 9, 2022 | Published / External
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
![]() |
![]() |
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
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique identifier for each Diel Suite deployed |
EXPOCODE
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
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
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
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
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
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
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
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
Seq. Order: | 10 |
---|---|
Data Storage Type: | TEXT |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
3-Letter unique code for LOCATION. |
LATITUDE
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
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
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
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year of the mission |
UTCDATETIME
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
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sample interval for CTD data. |
PRESSURE_DB
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
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Measured temperature value in degrees Celsius. |
SALN_PSU
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
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
Seq. Order: | 21 |
---|---|
Data Storage Type: | NUMERIC |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sample interval for ADCP data. |
HEIGHTBIN_M
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
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
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 |