Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: SfM Stratified Random: SfM Derived Juvenile Coral Annotations
Short Name: SfM Stratified Random: Juvenile
Status: Completed
Abstract:

SfM-derived coral belt transect observations (juvenile)

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: GISDAT
Description:

SfM-derived coral belt transect observations (juvenile)

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
COLONYID NUMBER Unique coral colony identifier. Identifier also given if NO_COLONY = -1 or SPCODE = NULL.
100
ANALYST NVARCHAR2 Initials of analyst that annotated the orthoprojection.
100
OBS_YEAR NUMBER 4-digit year the survey was conducted (DATE).
100
MISSION_ID VARCHAR2 Mission Identifier.
100
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
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
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
SEGLENGTH NUMBER Segment length (m).
100
SEGWIDTH NUMBER Segment width (m), usually 1 m.
100
NO_COLONY NUMBER Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018).
100
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
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
MORPH_CODE VARCHAR2 Code for coral morphology type (branching, columnar, encrusting, etc.).
100
EX_BOUND NUMBER Flag (-1) to indicate a coral with a max diameter that expands past image boundaries.
100
JUVENILE NUMBER Flag (-1) to indicate a juvenile coral.
100
REMNANT NUMBER Flag (-1) to indicate a coral as a remnant colony who's max diameter (Shape_Leng) cannot be determined.
100
Shape_Leng NUMBER Length of juvenile coral colony (<=0.05 m). Required.
100
SEGAREA NUMBER The area (m) of each SEGMENT surveyed.
100
SITEVISITID NUMBER Unique identifier created each time a SITE is surveyed on a DATE_.
100
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
ISLAND NVARCHAR2 Name of island or atoll surveyed in the Pacific Islands region.
100
REEF_ZONE NVARCHAR2 The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon).
100
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
DATE_ DATE Local date the survey was conducted.
100
HABITAT_CODE VARCHAR2 3-letter code for habitat type (e.g. aggregate reef, reef rubble, pavement) for the given SITE.
100
LATITUDE_LOV NUMBER Latitude in decimal degrees, WGS84, for the given SITE.
100
LONGITUDE_LOV NUMBER Longitude in decimal degrees, WGS84, for the given SITE.
100
MAX_DEPTH_M NUMBER Maximum SITE depth (m).
100
MIN_DEPTH_M NUMBER Minimum SITE depth (m).

Attribute Details

COLONYID

CC ID: 996406
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
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.

ANALYST

CC ID: 996456
Seq. Order: 2
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Initials of analyst that annotated the orthoprojection.

OBS_YEAR

CC ID: 996599
Seq. Order: 3
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

4-digit year the survey was conducted (DATE).

MISSION_ID

CC ID: 996454
Seq. Order: 4
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Mission Identifier.

SITE

CC ID: 996444
Seq. Order: 5
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
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.

TRANSECT

CC ID: 996451
Seq. Order: 6
Data Storage Type: NVARCHAR2
Max Length: 22
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.

SEGMENT

CC ID: 996441
Seq. Order: 7
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
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.

SEGLENGTH

CC ID: 996440
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 28
Scale: 8
Status: Active
Description:

Segment length (m).

SEGWIDTH

CC ID: 996443
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Segment width (m), usually 1 m.

NO_COLONY

CC ID: 996461
Seq. Order: 10
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018).

SPCODE

CC ID: 996465
Seq. Order: 11
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
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).

FRAGMENT

CC ID: 996600
Seq. Order: 12
Data Storage Type: NUMBER
Required: No
Primary Key: No
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.

MORPH_CODE

CC ID: 996425
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Code for coral morphology type (branching, columnar, encrusting, etc.).

EX_BOUND

CC ID: 996601
Seq. Order: 14
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Flag (-1) to indicate a coral with a max diameter that expands past image boundaries.

JUVENILE

CC ID: 996602
Seq. Order: 15
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Flag (-1) to indicate a juvenile coral.

REMNANT

CC ID: 996603
Seq. Order: 16
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Flag (-1) to indicate a coral as a remnant colony who's max diameter (Shape_Leng) cannot be determined.

Shape_Leng

CC ID: 996463
Seq. Order: 18
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

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

SEGAREA

CC ID: 996604
Seq. Order: 19
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

The area (m) of each SEGMENT surveyed.

SITEVISITID

CC ID: 1003897
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Unique identifier created each time a SITE is surveyed on a DATE_.

REGION

CC ID: 1003898
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
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.

ISLAND

CC ID: 1003899
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Name of island or atoll surveyed in the Pacific Islands region.

REEF_ZONE

CC ID: 1003900
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon).

DEPTH_BIN

CC ID: 1003901
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
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

DATE_

CC ID: 1003902
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Local date the survey was conducted.

HABITAT_CODE

CC ID: 1003903
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

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

LATITUDE_LOV

CC ID: 1003904
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Latitude in decimal degrees, WGS84, for the given SITE.

LONGITUDE_LOV

CC ID: 1003905
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degrees, WGS84, for the given SITE.

MAX_DEPTH_M

CC ID: 1003906
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Maximum SITE depth (m).

MIN_DEPTH_M

CC ID: 1003907
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Minimum SITE depth (m).

Catalog Details

Catalog Item ID: 63244
GUID: gov.noaa.nmfs.inport: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 Last Review Date: 2022-05-11
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2023-05-11