Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > International Programs > Timor Leste > Water temperature data from Subsurface Temperat... >

Temperature data entities and attributes

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:47070 | Updated: November 16, 2023 | Published / External

Item Identification

Title:	Temperature data entities and attributes
Status:	Completed
Abstract:	Entities and attributes for temperature data from subsurface temperature recorders

Entity Information

Entity Type:	Spreadsheet
Active Version?:	Yes
Description:	Subsurface Temperature Recorders

Data Attributes

Attribute Summary

	Name	Type	Description
100	SITETAG	NVARCHAR2	Unique ID for Site
100	LATITUDE	NUMBER	Latitude in decimal degree format (-8.22 to -8.85)
100	LONGITUDE	NUMBER	Longitude in decimal degree format (125.01 to 127.31)
100	DEPTH	NUMBER	Depth in meters
100	REGIONCODE	NVARCHAR2	Unique ID for Region
100	LOCATIONCODE	NVARCHAR2	3-letter Unique Location ID
100	INSTRUMENTTYPE	NVARCHAR2	Code for general typee of instrument (e.g. STR = Subsurface Temperature Recorder)
100	INSTRUMENTSN	NVARCHAR2	Serial Number of Instrument
100	DEPLOYCRUISE	NVARCHAR2	Unique Identifier for the Deployment Cruise
100	DEPLOYUTC	DATE	Date of Deployment in the format DD-MMM-YY
100	RETRIEVECRUISE	NVARCHAR2	Unique Identifier for the Retrieval Cruise
100	RETRIEVEUTC	DATE	Date of Retrieval in the format DD-MMM-YY
100	VALIDDATASTART	DATE	Date the instrument began reporting valid data in the format DD-MMM-YY
100	VALIDDATAEND	DATE	Date the instrument stopped reporting valid data in the format DD-MMM-YY
100	YEAR	NUMBER	4-digit year of temperature observation (2012 to 2014)
100	MONTH	NUMBER	Month of temperature observation (1-12)
100	DAY	NUMBER	Local day of temperature observation (1-31)
100	HOUR	NUMBER	Local hour of temperature observation (0-23)
100	TIMESTAMP	Date	Hourly average in the format DD-MMM-YY HH:mm:ss where Mmm = 3-digit month (e.g. DEC) and mm = two-digit minutes
100	TEMP_C	NUMBER	Water temperature in degrees Celsius
100	MINUTE	NUMBER	Digital value of minutes (e.g. 55). Typically this value is zero in the dataset
100	SECOND	NUMBER	Digital value of seconds (e.g. 55). Typically this value is zero in the dataset
100	SITE_TAG	NVARCHAR2	Unique ID for deployed instrument based on site and depth. Contains the previx "CTI_OCEAN_" followed by a sequential number (008 to 025)
100	DEPTH_M	NUMBER	Depth in meters (4-25 m)
100	REGION	NVARCHAR2	Region where instruments were deployed (Coral Triangle).
100	LOCATION	NVARCHAR2	Location where instruments were deployed (Timor-Leste)
100	INSTRUMENT_TYPE	NVARCHAR2	Code for general type of instrument (STR = Subsurface Temperature Recorder)
100	INSTRUMENT_SN	NVARCHAR2	11-digit Serial number of STR
100	DEPLOY_MISSION	NVARCHAR2	Unique Identifier for mission when instruments were deployed (CTI 2012 TIM)
100	DEPLOY_UTC	DATE	UTC date instrument was deployed (Oct 15 to Oct 25, 2012)
100	RETRIEVE_MISSION	NVARCHAR2	Unique Identifier for mission when instruments were recovered (CTI 2014 TIM)
100	RETRIEVE_UTC	DATE	UTC date instrument was recovered (Sept 16 to Oct 9 2014)
100	DATA_START	DATE	UTC date the instrument began recording data (Oct 15 to Oct 25, 2012)
100	DATA_END	DATE	UTC date the instrument stopped recording data (could be different from retrieve date if STR stopped recording before it was recovered; Sept 16 to Oct 9 2014).
100	_DATE	Date	Local date of temperature observation Oct 15 2012 to Oct 8 2014 (mm/dd/yyyy)
100	SITE_ID	NVARCHAR2	Unique ID for climate sites (3-digit place code, 2-digit number, separated by a dash (DIL_02). A SITE ID can have multiple SITE_TAGS if multiple STRs were deployed along a depth transect at the site.
100	INSTRUMENT_MFG	NVARCHAR2	Manufacturer of STRs (SeaBird Electronics)
100	INSTRUMENT_MODEL	NVARCHAR2	STR model (SBE 39)

Name

Type

Description

100

SITETAG

NVARCHAR2

Unique ID for Site

100

LATITUDE

NUMBER

Latitude in decimal degree format (-8.22 to -8.85)

100

LONGITUDE

NUMBER

Longitude in decimal degree format (125.01 to 127.31)

100

DEPTH

NUMBER

Depth in meters

100

REGIONCODE

NVARCHAR2

Unique ID for Region

100

LOCATIONCODE

NVARCHAR2

3-letter Unique Location ID

100

INSTRUMENTTYPE

NVARCHAR2

Code for general typee of instrument (e.g. STR = Subsurface Temperature Recorder)

100

INSTRUMENTSN

NVARCHAR2

Serial Number of Instrument

100

DEPLOYCRUISE

NVARCHAR2

Unique Identifier for the Deployment Cruise

100

DEPLOYUTC

DATE

Date of Deployment in the format DD-MMM-YY

100

RETRIEVECRUISE

NVARCHAR2

Unique Identifier for the Retrieval Cruise

100

RETRIEVEUTC

DATE

Date of Retrieval in the format DD-MMM-YY

100

VALIDDATASTART

DATE

Date the instrument began reporting valid data in the format DD-MMM-YY

100

VALIDDATAEND

DATE

Date the instrument stopped reporting valid data in the format DD-MMM-YY

100

YEAR

NUMBER

4-digit year of temperature observation (2012 to 2014)

100

MONTH

NUMBER

Month of temperature observation (1-12)

100

DAY

NUMBER

Local day of temperature observation (1-31)

100

HOUR

NUMBER

Local hour of temperature observation (0-23)

100

TIMESTAMP

Date

Hourly average in the format DD-MMM-YY HH:mm:ss where Mmm = 3-digit month (e.g. DEC) and mm = two-digit minutes

100

TEMP_C

NUMBER

Water temperature in degrees Celsius

100

MINUTE

NUMBER

Digital value of minutes (e.g. 55). Typically this value is zero in the dataset

100

SECOND

NUMBER

Digital value of seconds (e.g. 55). Typically this value is zero in the dataset

100

SITE_TAG

NVARCHAR2

Unique ID for deployed instrument based on site and depth. Contains the previx "CTI_OCEAN_" followed by a sequential number (008 to 025)

100

DEPTH_M

NUMBER

Depth in meters (4-25 m)

100

REGION

NVARCHAR2

Region where instruments were deployed (Coral Triangle).

100

LOCATION

NVARCHAR2

Location where instruments were deployed (Timor-Leste)

100

INSTRUMENT_TYPE

NVARCHAR2

Code for general type of instrument (STR = Subsurface Temperature Recorder)

100

INSTRUMENT_SN

NVARCHAR2

11-digit Serial number of STR

100

DEPLOY_MISSION

NVARCHAR2

Unique Identifier for mission when instruments were deployed (CTI 2012 TIM)

100

DEPLOY_UTC

DATE

UTC date instrument was deployed (Oct 15 to Oct 25, 2012)

100

RETRIEVE_MISSION

NVARCHAR2

Unique Identifier for mission when instruments were recovered (CTI 2014 TIM)

100

RETRIEVE_UTC

DATE

UTC date instrument was recovered (Sept 16 to Oct 9 2014)

100

DATA_START

DATE

UTC date the instrument began recording data (Oct 15 to Oct 25, 2012)

100

DATA_END

DATE

UTC date the instrument stopped recording data (could be different from retrieve date if STR stopped recording before it was recovered; Sept 16 to Oct 9 2014).

100

_DATE

Date

Local date of temperature observation Oct 15 2012 to Oct 8 2014 (mm/dd/yyyy)

100

SITE_ID

NVARCHAR2

Unique ID for climate sites (3-digit place code, 2-digit number, separated by a dash (DIL_02). A SITE ID can have multiple SITE_TAGS if multiple STRs were deployed along a depth transect at the site.

100

INSTRUMENT_MFG

NVARCHAR2

Manufacturer of STRs (SeaBird Electronics)

100

INSTRUMENT_MODEL

NVARCHAR2

STR model (SBE 39)

Attribute Details

SITETAG

CC ID: 579839

Seq. Order:	1
Data Storage Type:	NVARCHAR2
Max Length:	75
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique ID for Site

LATITUDE

CC ID: 579830

Seq. Order:	2
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Latitude in decimal degree format (-8.22 to -8.85)
Unit of Measure:	decimal degree

LONGITUDE

CC ID: 579832

Seq. Order:	3
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude in decimal degree format (125.01 to 127.31)
Unit of Measure:	decimal degree

DEPTH

CC ID: 579826

Seq. Order:	4
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Depth in meters
Unit of Measure:	meters

REGIONCODE

CC ID: 579835

Seq. Order:	5
Data Storage Type:	NVARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique ID for Region

LOCATIONCODE

CC ID: 579831

Seq. Order:	6
Data Storage Type:	NVARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	3-letter Unique Location ID

INSTRUMENTTYPE

CC ID: 579829

Seq. Order:	7
Data Storage Type:	NVARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for general typee of instrument (e.g. STR = Subsurface Temperature Recorder)

INSTRUMENTSN

CC ID: 579828

Seq. Order:	8
Data Storage Type:	NVARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Serial Number of Instrument

DEPLOYCRUISE

CC ID: 579824

Seq. Order:	9
Data Storage Type:	NVARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique Identifier for the Deployment Cruise

DEPLOYUTC

CC ID: 579825

Seq. Order:	10
Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	Date of Deployment in the format DD-MMM-YY

RETRIEVECRUISE

CC ID: 579836

Seq. Order:	11
Data Storage Type:	NVARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique Identifier for the Retrieval Cruise

RETRIEVEUTC

CC ID: 579837

Seq. Order:	12
Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	Date of Retrieval in the format DD-MMM-YY

VALIDDATASTART

CC ID: 579843

Seq. Order:	13
Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	Date the instrument began reporting valid data in the format DD-MMM-YY

VALIDDATAEND

CC ID: 579842

Seq. Order:	14
Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	Date the instrument stopped reporting valid data in the format DD-MMM-YY

YEAR

CC ID: 579844

Seq. Order:	15
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	4-digit year of temperature observation (2012 to 2014)

MONTH

CC ID: 579834

Seq. Order:	16
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Month of temperature observation (1-12)

DAY

CC ID: 579823

Seq. Order:	17
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Local day of temperature observation (1-31)

HOUR

CC ID: 579827

Seq. Order:	18
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Local hour of temperature observation (0-23)

TIMESTAMP

CC ID: 579841

Seq. Order:	19
Data Storage Type:	Date
Required:	No
Primary Key:	No
Status:	Active
Description:	Hourly average in the format DD-MMM-YY HH:mm:ss where Mmm = 3-digit month (e.g. DEC) and mm = two-digit minutes

TEMP_C

CC ID: 579840

Seq. Order:	20
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Water temperature in degrees Celsius
Unit of Measure:	degree C

MINUTE

CC ID: 579833

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Digital value of minutes (e.g. 55). Typically this value is zero in the dataset

SECOND

CC ID: 579838

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Digital value of seconds (e.g. 55). Typically this value is zero in the dataset

SITE_TAG

CC ID: 696053

Data Storage Type:	NVARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique ID for deployed instrument based on site and depth. Contains the previx "CTI_OCEAN_" followed by a sequential number (008 to 025)

DEPTH_M

CC ID: 696056

Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Depth in meters (4-25 m)

REGION

CC ID: 696057

Data Storage Type:	NVARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Region where instruments were deployed (Coral Triangle).

LOCATION

CC ID: 696058

Data Storage Type:	NVARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Location where instruments were deployed (Timor-Leste)

INSTRUMENT_TYPE

CC ID: 696059

Data Storage Type:	NVARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for general type of instrument (STR = Subsurface Temperature Recorder)

INSTRUMENT_SN

CC ID: 696060

Data Storage Type:	NVARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	11-digit Serial number of STR

DEPLOY_MISSION

CC ID: 696061

Data Storage Type:	NVARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique Identifier for mission when instruments were deployed (CTI 2012 TIM)

DEPLOY_UTC

CC ID: 696062

Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	UTC date instrument was deployed (Oct 15 to Oct 25, 2012)

RETRIEVE_MISSION

CC ID: 696063

Data Storage Type:	NVARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique Identifier for mission when instruments were recovered (CTI 2014 TIM)

RETRIEVE_UTC

CC ID: 696064

Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	UTC date instrument was recovered (Sept 16 to Oct 9 2014)

DATA_START

CC ID: 696065

Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	UTC date the instrument began recording data (Oct 15 to Oct 25, 2012)

DATA_END

CC ID: 696066

Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	UTC date the instrument stopped recording data (could be different from retrieve date if STR stopped recording before it was recovered; Sept 16 to Oct 9 2014).

_DATE

CC ID: 696071

Data Storage Type:	Date
Required:	No
Primary Key:	No
Status:	Active
Description:	Local date of temperature observation Oct 15 2012 to Oct 8 2014 (mm/dd/yyyy)

SITE_ID

CC ID: 696073

Data Storage Type:	NVARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique ID for climate sites (3-digit place code, 2-digit number, separated by a dash (DIL_02). A SITE ID can have multiple SITE_TAGS if multiple STRs were deployed along a depth transect at the site.

INSTRUMENT_MFG

CC ID: 696074

Data Storage Type:	NVARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Manufacturer of STRs (SeaBird Electronics)

INSTRUMENT_MODEL

CC ID: 696075

Data Storage Type:	NVARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	STR model (SBE 39)

Catalog Details

Catalog Item ID:	47070
GUID:	gov.noaa.nmfs.inport:47070
Metadata Record Created By:	Annette M DesRochers
Metadata Record Created:	2017-08-26 00:09+0000
Metadata Record Last Modified By:	Lori H Luers
Metadata Record Last Modified:	2023-11-16 20:38+0000
Metadata Record Published:	2023-11-16
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Review Frequency:	1 Year