Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Entities and attributes for temperature data from subsurface temperature recorders

Description

Subsurface Temperature Recorders

Entity Information

Entity Type
Spreadsheet

Data Attribute / Type Description
SITETAG
NVARCHAR2 		Unique ID for Site
LATITUDE
NUMBER 		Latitude in decimal degree format (-8.22 to -8.85)
LONGITUDE
NUMBER 		Longitude in decimal degree format (125.01 to 127.31)
DEPTH
NUMBER 		Depth in meters
REGIONCODE
NVARCHAR2 		Unique ID for Region
LOCATIONCODE
NVARCHAR2 		3-letter Unique Location ID
INSTRUMENTTYPE
NVARCHAR2 		Code for general typee of instrument (e.g. STR = Subsurface Temperature Recorder)
INSTRUMENTSN
NVARCHAR2 		Serial Number of Instrument
DEPLOYCRUISE
NVARCHAR2 		Unique Identifier for the Deployment Cruise
DEPLOYUTC
DATE 		Date of Deployment in the format DD-MMM-YY
RETRIEVECRUISE
NVARCHAR2 		Unique Identifier for the Retrieval Cruise
RETRIEVEUTC
DATE 		Date of Retrieval in the format DD-MMM-YY
VALIDDATASTART
DATE 		Date the instrument began reporting valid data in the format DD-MMM-YY
VALIDDATAEND
DATE 		Date the instrument stopped reporting valid data in the format DD-MMM-YY
YEAR
NUMBER 		4-digit year of temperature observation (2012 to 2014)
MONTH
NUMBER 		Month of temperature observation (1-12)
DAY
NUMBER 		Local day of temperature observation (1-31)
HOUR
NUMBER 		Local hour of temperature observation (0-23)
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
TEMP_C
NUMBER 		Water temperature in degrees Celsius
MINUTE
NUMBER 		Digital value of minutes (e.g. 55). Typically this value is zero in the dataset
SECOND
NUMBER 		Digital value of seconds (e.g. 55). Typically this value is zero in the dataset
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)
DEPTH_M
NUMBER 		Depth in meters (4-25 m)
REGION
NVARCHAR2 		Region where instruments were deployed (Coral Triangle).
LOCATION
NVARCHAR2 		Location where instruments were deployed (Timor-Leste)
INSTRUMENT_TYPE
NVARCHAR2 		Code for general type of instrument (STR = Subsurface Temperature Recorder)
INSTRUMENT_SN
NVARCHAR2 		11-digit Serial number of STR
DEPLOY_MISSION
NVARCHAR2 		Unique Identifier for mission when instruments were deployed (CTI 2012 TIM)
DEPLOY_UTC
DATE 		UTC date instrument was deployed (Oct 15 to Oct 25, 2012)
RETRIEVE_MISSION
NVARCHAR2 		Unique Identifier for mission when instruments were recovered (CTI 2014 TIM)
RETRIEVE_UTC
DATE 		UTC date instrument was recovered (Sept 16 to Oct 9 2014)
DATA_START
DATE 		UTC date the instrument began recording data (Oct 15 to Oct 25, 2012)
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).
_DATE
Date 		Local date of temperature observation Oct 15 2012 to Oct 8 2014 (mm/dd/yyyy)
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.
INSTRUMENT_MFG
NVARCHAR2 		Manufacturer of STRs (SeaBird Electronics)
INSTRUMENT_MODEL
NVARCHAR2 		STR model (SBE 39)

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: 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

Rubric Score Primary Key? 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