EROCK
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 70378
| Published / External
Created: 2023-08-01
|
Last Modified: 2023-09-01
Data Set (DS) | ID: 70346
ID: 70378
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | EROCK |
---|---|
Short Name | MASTER EROCK |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Master erock for sites seal foraged with coded storms. |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information |
SPREADSHEET: Electric rock data_update_20230731.xlsx |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | |
» Description |
Master erock for sites seal foraged with coded storms. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | MASTERID | NUMBER | Unique id number for the record. |
100 | No | No | LOCATION | CHARACTER | Location of rock clusters with name of closest sand islands or bank summit and the ID number for the rock. |
100 | No | No | YEARDEPLY | NUMBER | Year the rock was deployed. |
100 | No | No | DEPTHFT | NUMBER | Depth of site in feet (diver metric used). Units for values are feet. |
100 | No | No | WITHINROCKID | NUMBER | Sequential ID number for records recorded by each individual rock. |
100 | No | No | LOCALHDYHMS | DATE/TIME | Local Hawaii Standard time with month day year hour minute and sec. |
100 | No | No | 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 | No | No | 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 | No | No | NUMBERCUMULATIVETRIPS | NUMBER | Number of movements listed in a sequential cumulative number. |
100 | No | No | ELAPSEDTIME | TIME | Time elapsed within a cluster of deployed rocks between a detected movements. |
100 | No | No | MEANWAIMEAHTM | NUMBER | Wave buoy data showing the height of waves measured at the Waimea buoy. Measures are reported with a precision of 16. |
100 | No | No | SYNCHDATE | DATE | Date used to synch up temp data with erock data. |
100 | No | No | H24 | NUMBER | Hour in the 24 hrs clock to synch up with temp data. |
100 | No | No | SYNCHDATEHOUR | DATE/TIME | Combined date and hour (24 hour clock) to add temperature data. |
100 | No | No | 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 | No | No | LOCALMDYHMS_A | DATE/TIME | Repeat of the HST month day year hour min sec reference. |
100 | No | No | 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 | No | No | 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 | No | No | MEANTA | NUMBER | Average period of sea state at the Waimea buoy. Measures are reported with a precision of 4. |
100 | No | No | 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 | No | No | RECORDS | NUMBER | Number of records (48) the Waimea buoy records with the hour for the mean. |
100 | No | No | WAIMEAMEANHTADVANCED1DAY | DATE | Adjustment for French Frigate Shoals Latitude. |
100 | No | No | REGION | CHARACTER | General description of the area of the erocks, "Shallowbank" "FFSterrace". |
100 | No | No | 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
Attribute Name | MASTERID |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unique id number for the record. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LOCATION |
---|---|
Seq. Order | 2 |
Data Storage Type | CHARACTER |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | YEARDEPLY |
---|---|
Seq. Order | 3 |
Data Storage Type | NUMBER |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Year the rock was deployed. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTHFT |
---|---|
Seq. Order | 4 |
Data Storage Type | NUMBER |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Depth of site in feet (diver metric used). Units for values are feet. |
General Data Type | NUMBER |
Unit of Measure | feet |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WITHINROCKID |
---|---|
Seq. Order | 5 |
Data Storage Type | NUMBER |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Sequential ID number for records recorded by each individual rock. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LOCALHDYHMS |
---|---|
Seq. Order | 6 |
Data Storage Type | DATE/TIME |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Local Hawaii Standard time with month day year hour minute and sec. |
General Data Type | DATE/TIME |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ROCKGROUPCODE |
---|---|
Seq. Order | 7 |
Data Storage Type | CHARACTER |
Max Length | 14 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | STORMCODE |
---|---|
Seq. Order | 8 |
Data Storage Type | NUMBER |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NUMBERCUMULATIVETRIPS |
---|---|
Seq. Order | 9 |
Data Storage Type | NUMBER |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of movements listed in a sequential cumulative number. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ELAPSEDTIME |
---|---|
Seq. Order | 10 |
Data Storage Type | TIME |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time elapsed within a cluster of deployed rocks between a detected movements. |
General Data Type | TIME |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MEANWAIMEAHTM |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | 17 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SYNCHDATE |
---|---|
Seq. Order | 12 |
Data Storage Type | DATE |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date used to synch up temp data with erock data. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | H24 |
---|---|
Seq. Order | 13 |
Data Storage Type | NUMBER |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Hour in the 24 hrs clock to synch up with temp data. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SYNCHDATEHOUR |
---|---|
Seq. Order | 14 |
Data Storage Type | DATE/TIME |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Combined date and hour (24 hour clock) to add temperature data. |
General Data Type | DATE/TIME |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TEMPC |
---|---|
Seq. Order | 15 |
Data Storage Type | NUMBER |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LOCALMDYHMS_A |
---|---|
Seq. Order | 16 |
Data Storage Type | DATE/TIME |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Repeat of the HST month day year hour min sec reference. |
General Data Type | DATETIME |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MEANHTM |
---|---|
Seq. Order | 17 |
Data Storage Type | NUMBER |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MEANPERIODS |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMBER |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MEANTA |
---|---|
Seq. Order | 19 |
Data Storage Type | NUMBER |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MEANSSTC |
---|---|
Seq. Order | 20 |
Data Storage Type | NUMBER |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
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 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | RECORDS |
---|---|
Seq. Order | 21 |
Data Storage Type | NUMBER |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number of records (48) the Waimea buoy records with the hour for the mean. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WAIMEAMEANHTADVANCED1DAY |
---|---|
Seq. Order | 22 |
Data Storage Type | DATE |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Adjustment for French Frigate Shoals Latitude. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REGION |
---|---|
Seq. Order | 23 |
Data Storage Type | CHARACTER |
Max Length | 11 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
General description of the area of the erocks, "Shallowbank" "FFSterrace". |
General Data Type | CHARACTER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SWELL |
---|---|
Seq. Order | 24 |
Data Storage Type | NUMBER |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0=wave period too small to move a rock; 1= wave period large enough to move the rock |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date |
Tags |
---|