Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: ESD_NCRMP_TEMPERATURE_DATADICTIONARY_2023
Short Name: STR data dictionary
Status: Completed
Revision Date: 2020-03-30
Abstract:

Subsurface Temperature Recorders data dictionary

Entity Information

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

Subsurface Temperature Recorders dataset data dictionary

Change Summary:

MISSIONINSTRUMENTID updated to INSTFIELDSUMMARYID since 2023.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
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
LATITUDE NUMBER Latitude in decimal degrees, WGS84, for the OCC_SITEID where the STR was deployed.
100
LONGITUDE NUMBER Longitude in decimal degrees, WGS84, for the OCC_SITEID where the STR was deployed.
100
DEPTH_M NUMBER Depth in meters for the OCC_SITEID where the STR was deployed. Depths typically range from 0-30 m.
100
REGION TEXT The region in the U.S. Pacific Islands region where the STR was deployed: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
100
LOCATION TEXT Name of island, atoll, waterbody, or place where OCC_SITEID is located in the U.S. Pacific Islands region (REGION).
100
INSTRUMENT_TYPE TEXT Code for general type of instrument deployed (e.g., STR = Subsurface Temperature Recorder)
100
INSTRUMENTSN TEXT Serial number of instrument deployed. This is a text field. Serial number prefix indicates Sea-bird Electronics model for temperature sensor / recorder / logger: 39 = SBE 39plus; 56 = SBE 56.
100
DEPLOY_CRUISE TEXT Unique identifier for the mission/cruise when the instrument was deployed. NULL if instrument was not deployed during a mission/cruise (e.g., a NOAA partner deployed the instrument on the NOAA Ecosystem Sciences Division's [ESD's] behalf).
100
DEPLOY_UTC DATETIME UTC date and time when the instrument was deployed (YYYY-MM-DD"T"HH24:MI:SS"Z").
100
RETRIEVE_CRUISE TEXT Unique identifier for the mission/cruise when the instrument was recovered. NULL if instrument was not recovered during a mission/cruise (e.g., a NOAA partner recovered the instrument on the NOAA Ecosystem Sciences Division's [ESD's] behalf).
100
RETRIEVE_UTC DATETIME UTC date and time when the instrument was recovered (YYYY-MM-DD"T"HH24:MI:SS"Z").
100
VALID_DATA_START DATETIME Date and time the instrument began reporting valid data (YYYY-MM-DD"T"HH24:MI:SS"Z"). VALIDDATASTART should be equal to or later than DEPLOYUTC.
100
INSTFIELDSUMMARYID NUMBER Unique identifier for the instrument deployed, formerly known as MISSIONINSTRUMENTID
100
VALID_DATA_END DATETIME Date and time the instrument stopped reporting valid data (YYYY-MM-DD"T"HH24:MI:SS"Z"). VALIDDATAEND should be earlier than or equal to RETRIEVEUTC.
100
YEAR NUMBER 4-digit year of the temperature observation (TIMESTAMP).
100
MONTH NUMBER Numeric month for the temperature observation, 1-12 (TIMESTAMP).
100
DAY NUMBER Numeric day for the temperature observation, 1-31 (TIMESTAMP).
100
HOUR NUMBER Numeric hour for the temperature observation, 0-23 (TIMESTAMP).
100
MINUTE NUMBER Numeric minute for the temperature observation, 0-59 (TIMESTAMP).
100
SECOND NUMBER Numeric second for the temperature observation, 0-59 (TIMESTAMP).
100
TIMESTAMP TIMESTAMP UTC date and time of the temperature observation (YYYY-MM-DD"T"HH24:MI:SS"Z"). TIMESTAMP should be within VALIDDATASTART and VALIDDATAEND.
100
TEMP_C NUMBER Water temperature in degrees Celsius.

Attribute Details

OCC_SITEID

CC ID: 901084
Seq. Order: 1
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.

LATITUDE

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

Latitude in decimal degrees, WGS84, for the OCC_SITEID where the STR was deployed.

Unit of Measure: decimal degree

LONGITUDE

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

Longitude in decimal degrees, WGS84, for the OCC_SITEID where the STR was deployed.

Unit of Measure: decimal degree

DEPTH_M

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

Depth in meters for the OCC_SITEID where the STR was deployed. Depths typically range from 0-30 m.

Unit of Measure: meters

REGION

CC ID: 386710
Seq. Order: 5
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

The region in the U.S. Pacific Islands region where the STR was deployed: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.

LOCATION

CC ID: 386711
Seq. Order: 6
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Name of island, atoll, waterbody, or place where OCC_SITEID is located in the U.S. Pacific Islands region (REGION).

INSTRUMENT_TYPE

CC ID: 386712
Seq. Order: 7
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Code for general type of instrument deployed (e.g., STR = Subsurface Temperature Recorder)

INSTRUMENTSN

CC ID: 386713
Seq. Order: 8
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Serial number of instrument deployed. This is a text field. Serial number prefix indicates Sea-bird Electronics model for temperature sensor / recorder / logger: 39 = SBE 39plus; 56 = SBE 56.

DEPLOY_CRUISE

CC ID: 386714
Seq. Order: 9
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier for the mission/cruise when the instrument was deployed. NULL if instrument was not deployed during a mission/cruise (e.g., a NOAA partner deployed the instrument on the NOAA Ecosystem Sciences Division's [ESD's] behalf).

DEPLOY_UTC

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

UTC date and time when the instrument was deployed (YYYY-MM-DD"T"HH24:MI:SS"Z").

RETRIEVE_CRUISE

CC ID: 386716
Seq. Order: 11
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier for the mission/cruise when the instrument was recovered. NULL if instrument was not recovered during a mission/cruise (e.g., a NOAA partner recovered the instrument on the NOAA Ecosystem Sciences Division's [ESD's] behalf).

RETRIEVE_UTC

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

UTC date and time when the instrument was recovered (YYYY-MM-DD"T"HH24:MI:SS"Z").

VALID_DATA_START

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

Date and time the instrument began reporting valid data (YYYY-MM-DD"T"HH24:MI:SS"Z"). VALIDDATASTART should be equal to or later than DEPLOYUTC.

INSTFIELDSUMMARYID

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

Unique identifier for the instrument deployed, formerly known as MISSIONINSTRUMENTID

VALID_DATA_END

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

Date and time the instrument stopped reporting valid data (YYYY-MM-DD"T"HH24:MI:SS"Z"). VALIDDATAEND should be earlier than or equal to RETRIEVEUTC.

YEAR

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

4-digit year of the temperature observation (TIMESTAMP).

MONTH

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

Numeric month for the temperature observation, 1-12 (TIMESTAMP).

DAY

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

Numeric day for the temperature observation, 1-31 (TIMESTAMP).

HOUR

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

Numeric hour for the temperature observation, 0-23 (TIMESTAMP).

MINUTE

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

Numeric minute for the temperature observation, 0-59 (TIMESTAMP).

SECOND

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

Numeric second for the temperature observation, 0-59 (TIMESTAMP).

TIMESTAMP

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

UTC date and time of the temperature observation (YYYY-MM-DD"T"HH24:MI:SS"Z"). TIMESTAMP should be within VALIDDATASTART and VALIDDATAEND.

TEMP_C

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

Water temperature in degrees Celsius.

Unit of Measure: degree C

Catalog Details

Catalog Item ID: 37062
GUID: gov.noaa.nmfs.inport:37062
Metadata Record Created By: Nicole P Kamalu
Metadata Record Created: 2017-03-08 15:38+0000
Metadata Record Last Modified By: Lori H Luers
Metadata Record Last Modified: 2024-05-21 23:50+0000
Metadata Record Published: 2024-05-21
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2020-06-10
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2021-06-10