Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC ESD Ecosystems and Oceanography Program (... > EOP In Situ Observational Data > Monitoring the diurnal and seasonal foraging of... >

EROCK

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:70378  |  Updated: September 1, 2023  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Master erock for sites seal foraged with coded storms.

Description

Master erock for sites seal foraged with coded storms.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
MASTERID
NUMBER 		Unique id number for the record.
LOCATION
CHARACTER 		Location of rock clusters with name of closest sand islands or bank summit and the ID number for the rock.
YEARDEPLY
NUMBER 		Year the rock was deployed.
DEPTHFT
NUMBER 		Depth of site in feet (diver metric used). Units for values are feet.
WITHINROCKID
NUMBER 		Sequential ID number for records recorded by each individual rock.
LOCALHDYHMS
DATE/TIME 		Local Hawaii Standard time with month day year hour minute and sec.
ROCKGROUPCODE
CHARACTER 		Code used to define the cluster of rocks deployed at a site, include general site depth in meters and year of deployment.
STORMCODE
NUMBER 		Sequential number assigned to represent large pulses in movements associated with a storm event that will be excluded from the data. Measures are reported with a precision of 4.
NUMBERCUMULATIVETRIPS
NUMBER 		Number of movements listed in a sequential cumulative number.
ELAPSEDTIME
TIME 		Time elapsed within a cluster of deployed rocks between a detected movements.
MEANWAIMEAHTM
NUMBER 		Wave buoy data showing the height of waves measured at the Waimea buoy. Measures are reported with a precision of 16.
SYNCHDATE
DATE 		Date used to synch up temp data with erock data.
H24
NUMBER 		Hour in the 24 hrs clock to synch up with temp data.
SYNCHDATEHOUR
DATE/TIME 		Combined date and hour (24 hour clock) to add temperature data.
TEMPC
NUMBER 		Temperature in degrees C recorded on the hour. Units for values are degrees Celcius. Measures are reported with a precision of 4.
LOCALMDYHMS_A
DATE/TIME 		Repeat of the HST month day year hour min sec reference.
MEANHTM
NUMBER 		Mean height in meters recorded at the Waimea buoy. Units for values are meters. Measures are reported with a precision of 3.
MEANPERIODS
NUMBER 		Mean period in seconds of the waves recorded at the Waimea buoy. Units for values are seconds. Measures are reported with a precision of 4.
MEANTA
NUMBER 		Average period of sea state at the Waimea buoy. Measures are reported with a precision of 4.
MEANSSTC
NUMBER 		Mean sea surface temperature in degrees C from the Waimea buoy. Units for values are degrees Celcius. Measures are reported with a precision of 3.
RECORDS
NUMBER 		Number of records (48) the Waimea buoy records with the hour for the mean.
WAIMEAMEANHTADVANCED1DAY
DATE 		Adjustment for French Frigate Shoals Latitude.
REGION
CHARACTER 		General description of the area of the erocks, "Shallowbank" "FFSterrace".
SWELL
NUMBER 		Swell code 1= means a wave period large enough to move the rock; 0=wave period too small to move a rock.

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: EROCK
Short Name: MASTER EROCK
Status: Completed
Abstract:

Master erock for sites seal foraged with coded storms.
Supplemental Information:

SPREADSHEET: Electric rock data_update_20230731.xlsx

Entity Information

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

Master erock for sites seal foraged with coded storms.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 MASTERID NUMBER Unique id number for the record.
100
 LOCATION CHARACTER Location of rock clusters with name of closest sand islands or bank summit and the ID number for the rock.
100
 YEARDEPLY NUMBER Year the rock was deployed.
100
 DEPTHFT NUMBER Depth of site in feet (diver metric used). Units for values are feet.
100
 WITHINROCKID NUMBER Sequential ID number for records recorded by each individual rock.
100
 LOCALHDYHMS DATE/TIME Local Hawaii Standard time with month day year hour minute and sec.
100
 ROCKGROUPCODE CHARACTER Code used to define the cluster of rocks deployed at a site, include general site depth in meters and year of deployment.
100
 STORMCODE NUMBER Sequential number assigned to represent large pulses in movements associated with a storm event that will be excluded from the data. Measures are reported with a precision of 4.
100
 NUMBERCUMULATIVETRIPS NUMBER Number of movements listed in a sequential cumulative number.
100
 ELAPSEDTIME TIME Time elapsed within a cluster of deployed rocks between a detected movements.
100
 MEANWAIMEAHTM NUMBER Wave buoy data showing the height of waves measured at the Waimea buoy. Measures are reported with a precision of 16.
100
 SYNCHDATE DATE Date used to synch up temp data with erock data.
100
 H24 NUMBER Hour in the 24 hrs clock to synch up with temp data.
100
 SYNCHDATEHOUR DATE/TIME Combined date and hour (24 hour clock) to add temperature data.
100
 TEMPC NUMBER Temperature in degrees C recorded on the hour. Units for values are degrees Celcius. Measures are reported with a precision of 4.
100
 LOCALMDYHMS_A DATE/TIME Repeat of the HST month day year hour min sec reference.
100
 MEANHTM NUMBER Mean height in meters recorded at the Waimea buoy. Units for values are meters. Measures are reported with a precision of 3.
100
 MEANPERIODS NUMBER Mean period in seconds of the waves recorded at the Waimea buoy. Units for values are seconds. Measures are reported with a precision of 4.
100
 MEANTA NUMBER Average period of sea state at the Waimea buoy. Measures are reported with a precision of 4.
100
 MEANSSTC NUMBER Mean sea surface temperature in degrees C from the Waimea buoy. Units for values are degrees Celcius. Measures are reported with a precision of 3.
100
 RECORDS NUMBER Number of records (48) the Waimea buoy records with the hour for the mean.
100
 WAIMEAMEANHTADVANCED1DAY DATE Adjustment for French Frigate Shoals Latitude.
100
 REGION CHARACTER General description of the area of the erocks, "Shallowbank" "FFSterrace".
100
 SWELL NUMBER Swell code 1= means a wave period large enough to move the rock; 0=wave period too small to move a rock.

Attribute Details

MASTERID

CC ID: 1263530
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Unique id number for the record.
General Data Type: NUMBER

LOCATION

CC ID: 1263531
Seq. Order: 2
Data Storage Type: CHARACTER
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Location of rock clusters with name of closest sand islands or bank summit and the ID number for the rock.
General Data Type: CHARACTER
Allowed Values: Tern 2001 cluster rock numbers 1, 2, 8 ,9, 11, 23° 52.602 166° 19.555 Trig 2001 cluster rock numbers 5, 6 23° 53.364 166° 14.376 Tern 2002 rocks 4, 6 23° 53.154 166° 16.652 Shark 2002 rocks 1,2,3, 23° 52.589 166° 19.556 Southeast Brooks 2002 rocks, 17, 14, 24 23° 58.575 166° 41.986 Middle Brooks 2002 rocks 11, 15 24° 06.155 166° 50,431 Mid Brooks 2003 rocks 22, 37, 39 24° 10.060 166° 59.136

YEARDEPLY

CC ID: 1263532
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year the rock was deployed.
General Data Type: NUMBER

DEPTHFT

CC ID: 1263533
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Depth of site in feet (diver metric used). Units for values are feet.
General Data Type: NUMBER
Unit of Measure: feet

WITHINROCKID

CC ID: 1263534
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Sequential ID number for records recorded by each individual rock.
General Data Type: NUMBER

LOCALHDYHMS

CC ID: 1263535
Seq. Order: 6
Data Storage Type: DATE/TIME
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Local Hawaii Standard time with month day year hour minute and sec.
General Data Type: DATE/TIME

ROCKGROUPCODE

CC ID: 1263536
Seq. Order: 7
Data Storage Type: CHARACTER
Max Length: 14
Required: No
Primary Key: No
Status: Active
Description:

Code used to define the cluster of rocks deployed at a site, include general site depth in meters and year of deployment.
General Data Type: CHARACTER

STORMCODE

CC ID: 1263537
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 5
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

Sequential number assigned to represent large pulses in movements associated with a storm event that will be excluded from the data. Measures are reported with a precision of 4.
General Data Type: NUMBER

NUMBERCUMULATIVETRIPS

CC ID: 1263538
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number of movements listed in a sequential cumulative number.
General Data Type: NUMBER

ELAPSEDTIME

CC ID: 1263539
Seq. Order: 10
Data Storage Type: TIME
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Time elapsed within a cluster of deployed rocks between a detected movements.
General Data Type: TIME

MEANWAIMEAHTM

CC ID: 1263540
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 17
Required: No
Primary Key: No
Scale: 15
Status: Active
Description:

Wave buoy data showing the height of waves measured at the Waimea buoy. Measures are reported with a precision of 16.
General Data Type: NUMBER

SYNCHDATE

CC ID: 1263541
Seq. Order: 12
Data Storage Type: DATE
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Date used to synch up temp data with erock data.
General Data Type: DATE

H24

CC ID: 1263542
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Hour in the 24 hrs clock to synch up with temp data.
General Data Type: NUMBER

SYNCHDATEHOUR

CC ID: 1263543
Seq. Order: 14
Data Storage Type: DATE/TIME
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Combined date and hour (24 hour clock) to add temperature data.
General Data Type: DATE/TIME

TEMPC

CC ID: 1263544
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 5
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

Temperature in degrees C recorded on the hour. Units for values are degrees Celcius. Measures are reported with a precision of 4.
General Data Type: NUMBER
Unit of Measure: degrees Celcius

LOCALMDYHMS_A

CC ID: 1263545
Seq. Order: 16
Data Storage Type: DATE/TIME
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Repeat of the HST month day year hour min sec reference.
General Data Type: DATETIME

MEANHTM

CC ID: 1263546
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Mean height in meters recorded at the Waimea buoy. Units for values are meters. Measures are reported with a precision of 3.
General Data Type: NUMBER
Unit of Measure: meters

MEANPERIODS

CC ID: 1263547
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 5
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

Mean period in seconds of the waves recorded at the Waimea buoy. Units for values are seconds. Measures are reported with a precision of 4.
General Data Type: NUMBER
Unit of Measure: seconds

MEANTA

CC ID: 1263548
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 5
Required: No
Primary Key: No
Scale: 2
Status: Active
Description:

Average period of sea state at the Waimea buoy. Measures are reported with a precision of 4.
General Data Type: NUMBER

MEANSSTC

CC ID: 1263549
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Mean sea surface temperature in degrees C from the Waimea buoy. Units for values are degrees Celcius. Measures are reported with a precision of 3.
General Data Type: NUMBER
Unit of Measure: degrees Celcius

RECORDS

CC ID: 1263550
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of records (48) the Waimea buoy records with the hour for the mean.
General Data Type: NUMBER

WAIMEAMEANHTADVANCED1DAY

CC ID: 1263551
Seq. Order: 22
Data Storage Type: DATE
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Adjustment for French Frigate Shoals Latitude.
General Data Type: DATE

REGION

CC ID: 1263552
Seq. Order: 23
Data Storage Type: CHARACTER
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

General description of the area of the erocks, "Shallowbank" "FFSterrace".
General Data Type: CHARACTER

SWELL

CC ID: 1263553
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Swell code 1= means a wave period large enough to move the rock; 0=wave period too small to move a rock.
General Data Type: NUMBER
Allowed Values: 0=wave period too small to move a rock; 1= wave period large enough to move the rock

Catalog Details

Catalog Item ID: 70378
GUID: gov.noaa.nmfs.inport:70378
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2023-08-01 23:42+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2023-09-01 22:24+0000
Metadata Record Published: 2023-09-01
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year