ESD_DS_DataDict_2018_AMSM_DO
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 65124
| Published / External
Created: 2021-08-02
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 54928
ID: 65124
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | ESD_DS_DataDict_2018_AMSM_DO |
---|---|
Short Name | |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Dissolved Oxygen (DO) entities and attributes for diel surveys. |
* Purpose | |
Notes |
As of 2018, SBE-43 oxygen sensor was tethered to the CTD sensor for diel surveys. Raw data was logged as an extra column with CTD sensor data. Here it is presented with other relevant site data. |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | |
» Description |
Dissolved oxygen entity for diel surveys |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | DSUITEID | NUMERIC | Unique identifier for each Diel Suite deployed |
100 | No | No | EXPOCODE | TEXT | Defined as the Ship ICES code + departure date formatted as YYYYMMDD |
100 | No | No | CRUISE_COMMON_NAME | TEXT | More descriptive name of cruise/mission and is usually in the format [MissionID]-[REGIONDesignation]-[IslandCode if only one visited] |
100 | No | No | MISSION_CODE | TEXT | A single designation that applies to all the rounds associated with a given mission/cruise |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | LOCATION | TEXT | Name of island or atoll where the sample was collected in the Pacific Islands region (REGION). |
100 | No | No | LOCATIONCODE | TEXT | 3-Letter unique code for LOCATION. |
100 | No | No | LATITUDE | NUMERIC | Latitude in decimal degrees, WGS84, for the given Site |
100 | No | No | LONGITUDE | NUMERIC | Longitude in decimal degrees, WGS84, for the given Site |
100 | No | No | DEPTH_M | NUMERIC | OCC Survey depth (m) from dive computer at diel suite deployment |
100 | No | No | YEAR | NUMERIC | Year of the mission |
100 | No | No | UTCDATETIME | DATE | UTC date and time of CTD cast m/d/yyyy h:mm:ss), collected every 10 seconds to 5 minutes, depending on the site and year. |
100 | No | No | OXYGEN_SAMPLEINTERVAL_SEC | NUMERIC | Sample Interval for DO data in seconds |
100 | No | No | OXYGEN_PERCENTSAT | NUMERIC | Percent saturation of oxygen as measured by RBRsolo3 oxygen sensor |
100 | No | No | OXYGEN_MGL | NUMERIC | As recorded by SBE-43 oxygen sensor, or as calculated mg/L of oxygen from percent saturation of the RBRsolo3 oxygen sensor. |
100 | No | No | OXYGEN_MGL_ORIGIN | TEXT | Defines which oxygen sensor collected DO data |
Attribute Details
Attribute Name | DSUITEID |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique identifier for each Diel Suite deployed |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EXPOCODE |
---|---|
Seq. Order | 2 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Defined as the Ship ICES code + departure date formatted as YYYYMMDD |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CRUISE_COMMON_NAME |
---|---|
Seq. Order | 3 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
More descriptive name of cruise/mission and is usually in the format [MissionID]-[REGIONDesignation]-[IslandCode if only one visited] |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MISSION_CODE |
---|---|
Seq. Order | 4 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A single designation that applies to all the rounds associated with a given mission/cruise |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ASSOC_REA_SITE |
---|---|
Seq. Order | 5 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OCC_SITEID |
---|---|
Seq. Order | 6 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REGION |
---|---|
Seq. Order | 7 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REGIONCODE |
---|---|
Seq. Order | 8 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LOCATION |
---|---|
Seq. Order | 9 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of island or atoll where the sample was collected in the Pacific Islands region (REGION). |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LOCATIONCODE |
---|---|
Seq. Order | 10 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
3-Letter unique code for LOCATION. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LATITUDE |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude in decimal degrees, WGS84, for the given Site |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LONGITUDE |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude in decimal degrees, WGS84, for the given Site |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTH_M |
---|---|
Seq. Order | 13 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
OCC Survey depth (m) from dive computer at diel suite deployment |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | YEAR |
---|---|
Seq. Order | 14 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Year of the mission |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | UTCDATETIME |
---|---|
Seq. Order | 15 |
Data Storage Type | DATE |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
UTC date and time of CTD cast m/d/yyyy h:mm:ss), collected every 10 seconds to 5 minutes, depending on the site and year. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OXYGEN_SAMPLEINTERVAL_SEC |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sample Interval for DO data in seconds |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OXYGEN_PERCENTSAT |
---|---|
Seq. Order | 17 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Percent saturation of oxygen as measured by RBRsolo3 oxygen sensor |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OXYGEN_MGL |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMERIC |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
As recorded by SBE-43 oxygen sensor, or as calculated mg/L of oxygen from percent saturation of the RBRsolo3 oxygen sensor. |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OXYGEN_MGL_ORIGIN |
---|---|
Seq. Order | 19 |
Data Storage Type | TEXT |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Defines which oxygen sensor collected DO data |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 65124 |
---|---|
Metadata Record Created By | Lori H Luers |
Metadata Record Created | 2021-08-02 23:19+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:10+0000 |
Metadata Record Published | 2021-08-03 |
Owner Org | PIFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2021-08-03 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2022-08-03 |
Tags |
---|