Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > National Coral Reef Monitoring Program > Marianas Archipelago > National Coral Reef Monitoring Program: Water T... >

STR Entity

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:37074 | Updated: February 20, 2024 | Published / External

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

	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.

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

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