SfM Stratified Random: SfM Derived Juvenile Coral Annotations

Pacific Islands Fisheries Science Center
Entity (ENT) | ID: 63244 | Published / External
Created: 2020-11-27   |   Last Modified: 2022-08-09

Parent: National Coral Reef Monitoring Program: Structure from Motion (SfM) Coral (Adult and Juvenile) Annotations derived from Stratified Random Site (StRS) Imagery across the Hawaiian...
Data Set (DS) | ID: 63097

ID: 63244
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title SfM Stratified Random: SfM Derived Juvenile Coral Annotations
Short Name SfM Stratified Random: Juvenile
* Status Completed
Creation Date  
Revision Date  
• Publication Date  
* » Abstract

SfM-derived coral belt transect observations (juvenile)
* Purpose
Notes
Other Citation Details
• Supplemental Information
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 View
Active Version? Y
Alias  
Schema Name GISDAT
» Description

SfM-derived coral belt transect observations (juvenile)
Change Summary

Data Attributes

Attribute Summary

Score Req'd? PKey? » Name Data Storage Type Description
100 Yes No COLONYID NUMBER Unique coral colony identifier. Identifier also given if NO_COLONY = -1 or SPCODE = NULL.
100 No No ANALYST NVARCHAR2 Initials of analyst that annotated the orthoprojection.
100 Yes No OBS_YEAR NUMBER 4-digit year the survey was conducted (DATE).
100 No No MISSION_ID VARCHAR2 Mission Identifier.
100 Yes No SITE NVARCHAR2 The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-4 digit site number.
100 Yes No TRANSECT NVARCHAR2 Transect identifier (A or B). For collections on HARAMP 2019, any data entered under transect B was used for ANALYST-to-ANALYST calibration.
100 No No SEGMENT NVARCHAR2 Segment number (0, 5, 10). Segments are within a TRANSECT and are typically 1 x 1 m in size and situated 2.5 m apart.
100 No No SEGLENGTH NUMBER Segment length (m).
100 No No SEGWIDTH NUMBER Segment width (m), usually 1 m.
100 No No NO_COLONY NUMBER Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018).
100 No No SPCODE NVARCHAR2 4-letter code for coral species identification. NULL if a SEGMENT was surveyed and no individual colonies were found (NO_COLONY = -1).
100 No No FRAGMENT NUMBER Flag (-1) to indicate that the observed coral colony is a fragment and not attached to the substrate. 0 indicates the coral was not a fragment.
100 No No MORPH_CODE VARCHAR2 Code for coral morphology type (branching, columnar, encrusting, etc.).
100 No No EX_BOUND NUMBER Flag (-1) to indicate a coral with a max diameter that expands past image boundaries.
100 No No JUVENILE NUMBER Flag (-1) to indicate a juvenile coral.
100 No No REMNANT NUMBER Flag (-1) to indicate a coral as a remnant colony who's max diameter (Shape_Leng) cannot be determined.
100 No No Shape_Leng NUMBER Length of juvenile coral colony (<=0.05 m). Required.
100 No No SEGAREA NUMBER The area (m) of each SEGMENT surveyed.
100 No No SITEVISITID NUMBER Unique identifier created each time a SITE is surveyed on a DATE_.
100 No No REGION VARCHAR2 Code for the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
100 No No ISLAND NVARCHAR2 Name of island or atoll surveyed in the Pacific Islands region.
100 No No REEF_ZONE NVARCHAR2 The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon).
100 No No DEPTH_BIN NVARCHAR2 Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m
100 No No DATE_ DATE Local date the survey was conducted.
100 No No HABITAT_CODE VARCHAR2 3-letter code for habitat type (e.g. aggregate reef, reef rubble, pavement) for the given SITE.
100 No No LATITUDE_LOV NUMBER Latitude in decimal degrees, WGS84, for the given SITE.
100 No No LONGITUDE_LOV NUMBER Longitude in decimal degrees, WGS84, for the given SITE.
100 No No MAX_DEPTH_M NUMBER Maximum SITE depth (m).
100 No No MIN_DEPTH_M NUMBER Minimum SITE depth (m).

Attribute Details

Attribute Name COLONYID
Seq. Order 1
Data Storage Type NUMBER
Max Length 22
Min Length  
Required Yes
Primary Key No
Precision 28
Scale 0
Status Active
Description

Unique coral colony identifier. Identifier also given if NO_COLONY = -1 or SPCODE = NULL.
General Data Type  
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 ANALYST
Seq. Order 2
Data Storage Type NVARCHAR2
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Initials of analyst that annotated the orthoprojection.
General Data Type  
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 OBS_YEAR
Seq. Order 3
Data Storage Type NUMBER
Max Length  
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

4-digit year the survey was conducted (DATE).
General Data Type  
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 MISSION_ID
Seq. Order 4
Data Storage Type VARCHAR2
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Mission Identifier.
General Data Type  
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 SITE
Seq. Order 5
Data Storage Type NVARCHAR2
Max Length 150
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code (ISLANDCODE) with a 2-4 digit site number.
General Data Type  
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 TRANSECT
Seq. Order 6
Data Storage Type NVARCHAR2
Max Length 22
Min Length  
Required Yes
Primary Key No
Precision 38
Scale 0
Status Active
Description

Transect identifier (A or B). For collections on HARAMP 2019, any data entered under transect B was used for ANALYST-to-ANALYST calibration.
General Data Type  
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 SEGMENT
Seq. Order 7
Data Storage Type NVARCHAR2
Max Length 150
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Segment number (0, 5, 10). Segments are within a TRANSECT and are typically 1 x 1 m in size and situated 2.5 m apart.
General Data Type  
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 SEGLENGTH
Seq. Order 8
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 28
Scale 8
Status Active
Description

Segment length (m).
General Data Type  
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 SEGWIDTH
Seq. Order 9
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 38
Scale 8
Status Active
Description

Segment width (m), usually 1 m.
General Data Type  
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 NO_COLONY
Seq. Order 10
Data Storage Type NUMBER
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018).
General Data Type  
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 SPCODE
Seq. Order 11
Data Storage Type NVARCHAR2
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

4-letter code for coral species identification. NULL if a SEGMENT was surveyed and no individual colonies were found (NO_COLONY = -1).
General Data Type  
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 FRAGMENT
Seq. Order 12
Data Storage Type NUMBER
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Flag (-1) to indicate that the observed coral colony is a fragment and not attached to the substrate. 0 indicates the coral was not a fragment.
General Data Type  
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 MORPH_CODE
Seq. Order 13
Data Storage Type VARCHAR2
Max Length 5
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Code for coral morphology type (branching, columnar, encrusting, etc.).
General Data Type  
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 EX_BOUND
Seq. Order 14
Data Storage Type NUMBER
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Flag (-1) to indicate a coral with a max diameter that expands past image boundaries.
General Data Type  
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 JUVENILE
Seq. Order 15
Data Storage Type NUMBER
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Flag (-1) to indicate a juvenile coral.
General Data Type  
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 REMNANT
Seq. Order 16
Data Storage Type NUMBER
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Flag (-1) to indicate a coral as a remnant colony who's max diameter (Shape_Leng) cannot be determined.
General Data Type  
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 Shape_Leng
Seq. Order 18
Data Storage Type NUMBER
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Length of juvenile coral colony (<=0.05 m). Required.

General Data Type  
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 SEGAREA
Seq. Order 19
Data Storage Type NUMBER
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The area (m) of each SEGMENT surveyed.
General Data Type  
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 SITEVISITID
Seq. Order  
Data Storage Type NUMBER
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Unique identifier created each time a SITE is surveyed on a DATE_.
General Data Type  
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  
Data Storage Type VARCHAR2
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Code for the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
General Data Type  
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 ISLAND
Seq. Order  
Data Storage Type NVARCHAR2
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Name of island or atoll surveyed in the Pacific Islands region.
General Data Type  
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 REEF_ZONE
Seq. Order  
Data Storage Type NVARCHAR2
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon).
General Data Type  
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 DEPTH_BIN
Seq. Order  
Data Storage Type NVARCHAR2
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m
General Data Type  
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 DATE_
Seq. Order  
Data Storage Type DATE
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Local date the survey was conducted.
General Data Type  
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 HABITAT_CODE
Seq. Order  
Data Storage Type VARCHAR2
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

3-letter code for habitat type (e.g. aggregate reef, reef rubble, pavement) for the given SITE.

General Data Type  
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 LATITUDE_LOV
Seq. Order  
Data Storage Type NUMBER
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Latitude in decimal degrees, WGS84, for the given SITE.
General Data Type  
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 LONGITUDE_LOV
Seq. Order  
Data Storage Type NUMBER
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Longitude in decimal degrees, WGS84, for the given SITE.
General Data Type  
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 MAX_DEPTH_M
Seq. Order  
Data Storage Type NUMBER
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Maximum SITE depth (m).
General Data Type  
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 MIN_DEPTH_M
Seq. Order  
Data Storage Type NUMBER
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Minimum SITE depth (m).
General Data Type  
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
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

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » 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 63244
Metadata Record Created By Corinne Amir
Metadata Record Created 2020-11-27 21:18+0000
Metadata Record Last Modified By SysAdmin InPortAdmin
» Metadata Record Last Modified 2022-08-09 17:11+0000
Metadata Record Published 2022-05-11
Owner Org PIFSC
Metadata Publication Status Published Externally
Do Not Publish? N
Metadata Workflow State Published / External
Metadata Last Review Date 2022-05-11
Metadata Review Frequency 1 Year
Metadata Next Review Date 2023-05-11
Tags