Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Subsurface Temperature Recorders Entity and Attributes

Description

Subsurface Temperature Recorders

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
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 island 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 3-m depth cylinder of a pre-existing OCC_SITEID, otherwise, the instrument is assigned a new OCC_SITEID.
LATITUDE
NUMBER
Latitude in decimal degrees, WGS84, for the OCC_SITEID where the STR was deployed.
LONGITUDE
NUMBER
Longitude in decimal degrees, WGS84, for the OCC_SITEID where the STR was deployed.
DEPTH
NUMBER
Depth in meters for the OCC_SITEID where the STR was deployed. Depths typically range from 0-30 m.
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.
LOCATION
TEXT
Name of island or atoll where OCC_SITEID is located in the U.S. Pacific Islands region (REGION).
INSTRUMENT_TYPE
TEXT
Code for general type of instrument deployed (e.g., STR = Subsurface Temperature Recorder)
INSTRUMENTSN
TEXT
Serial number of instrument deployed. This is a text field.
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).
DEPLOY_UTC
DATETIME
UTC date and time when the instrument was deployed in Zulu format (YYYY-MM-DD"T"HH24:MI:SS"Z").
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).
RETRIEVE_UTC
DATETIME
UTC date and time when the instrument was recovered in Zulu format (YYYY-MM-DD"T"HH24:MI:SS"Z").
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.
INSTFIELDSUMMARYID
NUMBER
Unique identifier for the instrument deployed.
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.
YEAR
NUMBER
4-digit year of the temperature observation (TIMESTAMP).
MONTH
NUMBER
Numeric month for the temperature observation, 1-12 (TIMESTAMP).
DAY
NUMBER
Numeric day for the temperature observation, 1-31 (TIMESTAMP).
HOUR
NUMBER
Numeric hour for the temperature observation, 0-23 (TIMESTAMP).
MINUTE
NUMBER
Numeric minute for the temperature observation, 0-59 (TIMESTAMP).
SECOND
NUMBER
Numeric second for the temperature observation, 0-59 (TIMESTAMP).
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.
TEMP_C
NUMBER
Water temperature in degrees Celsius.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Item Identification

Title: STR Entity
Status: Completed
Revision Date: 2020-03-30
Abstract:

Subsurface Temperature Recorders Entity and Attributes

Entity Information

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

Subsurface Temperature Recorders

Change Summary:

In 2022 some column names were updated:

- MISSIONINSTRUMENTID updated as INSTFIELDSUMMARYID

- DEPTH updated to DEPTH_M

- Other column names were updated with snake case lettering e.g. RETRIEVECRUISE to RETRIEVE_CRUISE

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 island 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 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 or atoll 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.
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 in Zulu format (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 in Zulu format (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.
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: 387410
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 island 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 3-m depth cylinder of a pre-existing OCC_SITEID, otherwise, the instrument is assigned a new OCC_SITEID.

LATITUDE

CC ID: 387403
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: 387405
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: 387399
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: 387407
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: 1055960
Seq. Order: 6
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

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

INSTRUMENT_TYPE

CC ID: 387402
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: 387401
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.

DEPLOY_CRUISE

CC ID: 387397
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: 387398
Seq. Order: 10
Data Storage Type: DATETIME
Required: No
Primary Key: No
Status: Active
Description:

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

RETRIEVE_CRUISE

CC ID: 387408
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: 387409
Seq. Order: 12
Data Storage Type: DATETIME
Required: No
Primary Key: No
Status: Active
Description:

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

VALID_DATA_START

CC ID: 387414
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: 836034
Seq. Order: 14
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier for the instrument deployed.

VALID_DATA_END

CC ID: 387413
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: 387415
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: 387406
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: 387396
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: 387400
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: 836035
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: 836036
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: 387412
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: 387411
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: 37074
GUID: gov.noaa.nmfs.inport:37074
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2017-03-08 19:15+0000
Metadata Record Last Modified By: Lori H Luers
Metadata Record Last Modified: 2024-02-20 20:49+0000
Metadata Record Published: 2023-11-01
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year