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.
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) or for conductivity and temperature recorder (37 = SBE 37-SM).
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: 387370
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: 387363
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: 387365
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: 387359
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: 387367
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: 387364
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: 387362
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: 387361
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) or for conductivity and temperature recorder (37 = SBE 37-SM).

DEPLOYCRUISE

CC ID: 387357
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: 387358
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: 387368
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: 387369
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: 387374
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: 836008
Seq. Order: 14
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier for the instrument deployed.

VALIDDATAEND

CC ID: 387373
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: 387375
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: 387366
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: 387356
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: 387360
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: 836009
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: 836010
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: 387372
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: 387371
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: 37072
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2017-03-08 19:14+0000
Metadata Record Last Modified By: Annette M DesRochers
Metadata Record Last Modified: 2020-05-26 19:58+0000
Metadata Record Published: 2020-05-26
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-05-27