Slide Menu
Search Help Show/Hide Menu

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