Slide Menu
System Maintenance Notice, Monday, December 5, 2022 @ 1pm-5pm Eastern. The Operations Team will be performing system maintenance. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

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

SfM-derived coral belt transect observations (adult)

Entity Information

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

SfM-derived coral belt transect observations (adult)

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ANALYST NVARCHAR2 Initials of person that annotated the imagery
100
OBS_YEAR NUMBER 4-digit year the survey was conducted (DATE).
100
MISSION_ID VARCHAR2 Mission identifier.
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
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
SITEVISITID NUMBER Unique identifier created each time a SITE is surveyed on a DATE_.
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).
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).
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
site_seg NVARCHAR2 Code which combines the site code (SITE) and the 1 digit SEGMENT surveyed.
100
SEGMENT NVARCHAR2 Segment number (0,5,10,15). Segments are within a TRANSECT and are typically 1 x 2.5 m in size and situated 2.5 m apart starting at the 0m, 5m, 10m, and 15m transect length.
100
SEGLENGTH NUMBER Segment length (m).
100
SEGWIDTH NUMBER Segment width (m).
100
NO_COLONY NUMBER Flag (-1) to indicate no corals present.
100
COLONYID NUMBER Unique coral colony identifier. Identifier also given if NO_COLONY = -1 or SPCODE = NULL.
100
SPCODE TEXT 4-letter code for coral species identification. NULL if a SEGMENT was surveyed and no individual colonies were found (NO_COLONY = -1).
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
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
REMNANT NUMBER Flag (-1) to indicate a coral as a remnant colony who's max diameter (Shape_Leng) cannot be determined.
100
OLDDEAD NUMBER Percentage of older dead coral (0-100%), as opposed to recently dead coral recorded in RECENTDEAD. Required.
100
MORPH_CODE VARCHAR2 Code for coral morphology type (branching, columnar, encrusting, etc.).
100
RDCAUSE1 VARCHAR2 Code for the cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RD_1. Required if RD_1 is >0.
100
RD_1 NUMBER Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%), as opposed to older dead coral recorded in OLDDEAD.
100
RDCAUSE_2 VARCHAR2 Code for the cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RD_2. Required if RD_2 is >0.
100
RD_2 NUMBER Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral. Only used if more than one cause of coral mortality was observed (RD_1 >0).
100
RDCAUSE_3 VARCHAR2 Code for the cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RD_3. Required if RD_3 is >0.
100
RD_3 NUMBER Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral. Only used if more than two causes of coral mortality were observed (RD_1 and RD_2 >0).
100
CON_1 NVARCHAR2 Code for the condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause recent dead.
100
EXTENT_1 NUMBER Extent of condition/disease observed on coral colony (1-100). Required if CON_1 is recorded (<> 'NDZ).
100
SEVERITY_1 NUMBER Severity of condition/disease observed on coral colony (scale of 1-3 from least to most severe). SEVERITY required only if CON_1 = BLE or BLP.
100
CON_2 NVARCHAR2 Code for the condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but does not cause recent dead.
100
EXTENT_2 NUMBER Extent of condition/disease observed on coral colony (1-100). Required if CON_2 is recorded (<> 'NDZ).
100
SEVERITY_2 NUMBER Severity of condition/disease observed on coral colony (scale of 1-3 from least to most severe). SEVERITY required only if CON_2 = BLE or BLP.
100
CON_3 NVARCHAR2 Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but does not cause recent dead.
100
EXTENT_3 NUMBER Extent of condition/disease observed on coral colony (1-100). Required if CON_3 is recorded (<> 'NDZ).
100
SEV_3 NUMBER Severity of condition/disease observed on coral colony (scale of 1-3 from least to most severe). SEVERITY required only if CON_3 = BLE or BLP.
100
Shape_Leng NUMBER Length of coral colony (m). Required.

Attribute Details

ANALYST

CC ID: 995400
Seq. Order: 1
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

Initials of person that annotated the imagery

OBS_YEAR

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

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

MISSION_ID

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

Mission identifier.

REGION

CC ID: 1003869
Seq. Order: 4
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: 1079965
Seq. Order: 5
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

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

SITE

CC ID: 995458
Seq. Order: 6
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.

SITEVISITID

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

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

REEF_ZONE

CC ID: 1003871
Seq. Order: 8
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: 1003872
Seq. Order: 9
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: 1003873
Seq. Order: 10
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Local date the survey was conducted.

HABITAT_CODE

CC ID: 1003874
Seq. Order: 11
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).

LATITUDE_LOV

CC ID: 1003875
Seq. Order: 12
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: 1003876
Seq. Order: 13
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: 1003877
Seq. Order: 14
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Maximum SITE depth (m).

MIN_DEPTH_M

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

Minimum SITE depth (m).

TRANSECT

CC ID: 995466
Seq. Order: 16
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.

site_seg

CC ID: 996368
Seq. Order: 17
Data Storage Type: NVARCHAR2
Required: Yes
Primary Key: No
Status: Active
Description:

Code which combines the site code (SITE) and the 1 digit SEGMENT surveyed.

SEGMENT

CC ID: 995451
Seq. Order: 18
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Segment number (0,5,10,15). Segments are within a TRANSECT and are typically 1 x 2.5 m in size and situated 2.5 m apart starting at the 0m, 5m, 10m, and 15m transect length.

SEGLENGTH

CC ID: 995450
Seq. Order: 19
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: 995453
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Segment width (m).

NO_COLONY

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

Flag (-1) to indicate no corals present.

COLONYID

CC ID: 995387
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Unique coral colony identifier. Identifier also given if NO_COLONY = -1 or SPCODE = NULL.

SPCODE

CC ID: 996362
Seq. Order: 23
Data Storage Type: TEXT
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).

EX_BOUND

CC ID: 996364
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
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: 996365
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Flag (-1) to indicate a juvenile coral.

FRAGMENT

CC ID: 995406
Seq. Order: 26
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.

REMNANT

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

OLDDEAD

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

Percentage of older dead coral (0-100%), as opposed to recently dead coral recorded in RECENTDEAD. Required.

MORPH_CODE

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

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

RDCAUSE1

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

Code for the cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RD_1. Required if RD_1 is >0.

RD_1

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

Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%), as opposed to older dead coral recorded in OLDDEAD.

RDCAUSE_2

CC ID: 995433
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Code for the cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RD_2. Required if RD_2 is >0.

RD_2

CC ID: 995430
Seq. Order: 33
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral. Only used if more than one cause of coral mortality was observed (RD_1 >0).

RDCAUSE_3

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

Code for the cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RD_3. Required if RD_3 is >0.

RD_3

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

Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral. Only used if more than two causes of coral mortality were observed (RD_1 and RD_2 >0).

CON_1

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

Code for the condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause recent dead.

EXTENT_1

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

Extent of condition/disease observed on coral colony (1-100). Required if CON_1 is recorded (<> 'NDZ).

SEVERITY_1

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

Severity of condition/disease observed on coral colony (scale of 1-3 from least to most severe). SEVERITY required only if CON_1 = BLE or BLP.

CON_2

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

Code for the condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but does not cause recent dead.

EXTENT_2

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

Extent of condition/disease observed on coral colony (1-100). Required if CON_2 is recorded (<> 'NDZ).

SEVERITY_2

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

Severity of condition/disease observed on coral colony (scale of 1-3 from least to most severe). SEVERITY required only if CON_2 = BLE or BLP.

CON_3

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

Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but does not cause recent dead.

EXTENT_3

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

Extent of condition/disease observed on coral colony (1-100). Required if CON_3 is recorded (<> 'NDZ).

SEV_3

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

Severity of condition/disease observed on coral colony (scale of 1-3 from least to most severe). SEVERITY required only if CON_3 = BLE or BLP.

Shape_Leng

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

Length of coral colony (m). Required.

Catalog Details

Catalog Item ID: 63239
GUID: gov.noaa.nmfs.inport:63239
Metadata Record Created By: Corinne Amir
Metadata Record Created: 2020-11-24 18:40+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