Item Identification

Title: STR Entity
Status: Completed
Abstract:

Subsurface Temperature Recorders Entity and Attributes

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Subsurface Temperature Recorders

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 NUMBER Depth in meters for the OCC_SITEID where the STR was deployed. Depths typically range from 0-30 m, although instruments are occasionally deployed in slightly deeper waters (< 40 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
INSTRUMENTTYPE 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
DEPLOYCRUISE 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
DEPLOYUTC DATETIME UTC date and time when the instrument was deployed (YYYY-MM-DD HH24:MI:SS).
100
RETRIEVECRUISE 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
RETRIEVEUTC DATETIME UTC date and time when the instrument was recovered (YYYY-MM-DD HH24:MI:SS).
100
VALIDDATASTART DATETIME Date and time the instrument began reporting valid data (YYYY-MM-DD HH24:MI:SS). VALIDDATASTART should be equal to or later than DEPLOYUTC.
100
MISSIONINSTRUMENTID NUMBER Unique identifier for the instrument deployed.
100
VALIDDATAEND DATETIME Date and time the instrument stopped reporting valid data (YYYY-MM-DD HH24:MI:SS). 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 HH24:MI:SS). TIMESTAMP should be within VALIDDATASTART and VALIDDATAEND.
100
TEMP_C NUMBER Water temperature in degrees Celsius.

Attribute Details

OCC_SITEID

CC ID: 387390
Seq. Order: 1
Data Storage Type: TEXT
Max Length: 75
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: 387383
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: 387385
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

CC ID: 387379
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, although instruments are occasionally deployed in slightly deeper waters (< 40 m).

Unit of Measure: meters

REGION

CC ID: 387387
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: 387384
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).

INSTRUMENTTYPE

CC ID: 387382
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: 387381
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.

DEPLOYCRUISE

CC ID: 387377
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).

DEPLOYUTC

CC ID: 387378
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 HH24:MI:SS).

RETRIEVECRUISE

CC ID: 387388
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).

RETRIEVEUTC

CC ID: 387389
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 HH24:MI:SS).

VALIDDATASTART

CC ID: 387394
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 HH24:MI:SS). VALIDDATASTART should be equal to or later than DEPLOYUTC.

MISSIONINSTRUMENTID

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

Unique identifier for the instrument deployed.

VALIDDATAEND

CC ID: 387393
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 HH24:MI:SS). VALIDDATAEND should be earlier than or equal to RETRIEVEUTC.

YEAR

CC ID: 387395
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: 387386
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: 387376
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: 387380
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: 903137
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: 903136
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: 387392
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 HH24:MI:SS). TIMESTAMP should be within VALIDDATASTART and VALIDDATAEND.

TEMP_C

CC ID: 387391
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: 37073
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2017-03-08 19:15+0000
Metadata Record Last Modified By: Annette M DesRochers
Metadata Record Last Modified: 2020-05-14 15:50+0000
Metadata Record Published: 2020-05-14
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-05-15