Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > National Coral Reef Monitoring Program > Hawaiian Archipelago > National Coral Reef Monitoring Program: Stratif... >

View: V0_CORAL_OBS_E_PRESENCE

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:36179 | Updated: October 20, 2022 | Published / External

Item Identification

Title:	View: V0_CORAL_OBS_E_PRESENCE
Short Name:	V0_CORAL_OBS_E_PRESENCE
Status:	Completed
Abstract:	Coral belt observations (presence)
Notes:	Updated Feb 2019 to reflect addition of monument-led surveys 2014 and 2015. Presence surveys do not apply to PMNM-led missions in 2014 or 2015. Updated TRANSECT description on June 19 2019 in anticipation of diver calibration data to be collected on transect 2 during HARAMP surveys (legs 2 and 3).

Entity Information

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	GISDAT
Description:	Coral belt observations (presence)

Data Attributes

Attribute Summary

	Name	Type	Description
100	ROUNDID	NUMBER	Unique Identifier for ROUND record.
100	MISSIONID	VARCHAR2	Mission Identifier.
100	REGION	VARCHAR2	Code for REGION_NAME.
100	REGION_NAME	VARCHAR2	The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
100	ISLANDCODE	NVARCHAR2	3-letter code for ISLAND.
100	ISLAND	NVARCHAR2	Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
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	LATITUDE	NUMBER	Latitude in decimal degrees, WGS84, for the given SITE.
100	LONGITUDE	NUMBER	Longitude in decimal degrees, WGS84 for the given SITE.
100	REEF_ZONE_CODE	VARCHAR2	3-letter code for REEF_ZONE.
100	REEF_ZONE	NVARCHAR2	The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon).
100	HABITAT_CODE	VARCHAR2	3-letter code for HABITAT_TYPE.
100	HABITAT_TYPE	VARCHAR2	Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE.
100	SITE_MIN_DEPTH	NUMBER	Minimum SITE depth (ft).
100	SITE_MAX_DEPTH	NUMBER	Maximum SITE depth (ft).
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	DEPTH_CODE	VARCHAR2	Single-letter code for DEPTH_BIN (S, M, D).
100	SITEVISITID	NUMBER	Unique identifier created each time a SITE is surveyed on a DATE_.
100	DATE_	DATE	Local date the survey was conducted.
100	OBS_DAY	NUMBER	Numeric day the survey was conducted (DATE_).
100	OBS_MONTH	NUMBER	Numeric month the survey was conducted (DATE_).
100	OBS_YEAR	NUMBER	4-digit year the survey was conducted (DATE_).
100	NO_SURVEY_YN	NUMBER	Flag (-1) to indicate transect was not surveyed (Added Sept. 2014).
100	PHOTOS_TAKEN	NUMBER	Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (Added in 2018).
100	DIVER	NVARCHAR2	Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1.
100	METHODNAME	NVARCHAR2	References the coral belt survey method.
100	BELTTRANSECTRUN	NUMBER	Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT.
100	TRANSECT	NUMBER	Transect number (1-4). For collections on HARAMP 2019, any data entered under transect 2 is for use as an internal, diver-to-diver calibration, and is not part of the canonical dataset
100	TRANSECTID	NUMBER	Unique transect ID number assigned to each transect during the same NCRMP mission (Added in 2018).
100	TRANSECTNUM	NUMBER	Unique identifier for each transect surveyed within a SITE.
100	SEGMENTID	NUMBER	Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018).
100	SEGMENT	NVARCHAR2	Segment number (1-7). Segments are within a TRANSECT and are typically 1 x 2.5 m in size and situated 2.5 m apart.
100	SEGLENGTH	NUMBER	Segment length (m).
100	SEGWIDTH	NUMBER	Segment width (m).
100	NO_COLONY_OBSERVED	NUMBER	Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018).
100	CORL_YN	NUMBER	Flag (-1) to indicate presence of corallimorph on transect.
100	CORALLIMORPH_YN	NUMERIC	Flag (-1) to indicate presence of corallimorph on transect (Added Feb. 2015).
100	CLADIELLA_YN	NUMBER	Flag (-1) to indicate presence of cladiella on transect (Added Sept. 2014)
100	DENDRONEPHTHYA_YN	NUMBER	Flag (-1) to indicate presence of dendronephthya on transect (Added Sept. 2014).
100	DISTICHOPORA_YN	NUMERIC	Flag (-1) to indicate presence of distichopora on transect (Added Feb. 2015).
100	LOBOPHYTUM_YN	NUMBER	Flag (-1) to indicate presence of lobophytum on transect (Added Sept. 2014).
100	OCTO_YN	NUMERIC	Flag (-1) to indicate presence of octocoral on transect (added 2015).
100	PACHYCLAVULARIA_YN	NUMBER	Flag (-1) to indicate presence of pachyclavularia on transect (Added Sept. 2014).
100	PALYTHOA_YN	NUMBER	Flag (-1) to indicate presence of palythoa on transect (Added Sept. 2014).
100	PROTOPALYTHOA_YN	NUMBER	Flag (-1) to indicate presence of protopalythoa on transect (Added Sept. 2014).
100	SARCOPHYTON_YN	NUMBER	Flag to indicate presence of sarcophyton on transect (Added Sept. 2014)
100	SARCOTHELIA_YN	NUMERIC	Flag (-1) to indicate presence of sarcothelia on transect (added 2017).
100	SINULARIA_YN	NUMBER	Flag (-1) to indicate presence of sinularia on transect (Added Sept. 2014).
100	SOFT_YN	NUMERIC	Flag (-1) to indicate presence of soft coral on transect (added 2015).
100	STEREONEPHTHYA_YN	NUMBER	Flag (-1) to indicate presence of stereonephthya on transect (Added Sept. 2014).
100	STYLASTER_YN	NUMERIC	Flag (-1) to indicate presence of stylaster on transect (Added Feb. 2015).
100	WIRECORAL_YN	NUMBER	Flag (-1) to indicate presence of wire coral on transect (Added Sept. 2014).
100	ZOANTHUS_YN	NUMBER	Flag (-1) to indicate presence of zoanthus on transect (Added Sept. 2014).

Name

Type

Description

100

ROUNDID

NUMBER

Unique Identifier for ROUND record.

100

MISSIONID

VARCHAR2

Mission Identifier.

100

REGION

VARCHAR2

Code for REGION_NAME.

100

REGION_NAME

VARCHAR2

The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.

100

ISLANDCODE

NVARCHAR2

3-letter code for ISLAND.

100

ISLAND

NVARCHAR2

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

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

LATITUDE

NUMBER

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

100

LONGITUDE

NUMBER

Longitude in decimal degrees, WGS84 for the given SITE.

100

REEF_ZONE_CODE

VARCHAR2

3-letter code for REEF_ZONE.

100

REEF_ZONE

NVARCHAR2

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

100

HABITAT_CODE

VARCHAR2

3-letter code for HABITAT_TYPE.

100

HABITAT_TYPE

VARCHAR2

Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE.

100

SITE_MIN_DEPTH

NUMBER

Minimum SITE depth (ft).

100

SITE_MAX_DEPTH

NUMBER

Maximum SITE depth (ft).

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

DEPTH_CODE

VARCHAR2

Single-letter code for DEPTH_BIN (S, M, D).

100

SITEVISITID

NUMBER

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

100

DATE_

DATE

Local date the survey was conducted.

100

OBS_DAY

NUMBER

Numeric day the survey was conducted (DATE_).

100

OBS_MONTH

NUMBER

Numeric month the survey was conducted (DATE_).

100

OBS_YEAR

NUMBER

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

100

NO_SURVEY_YN

NUMBER

Flag (-1) to indicate transect was not surveyed (Added Sept. 2014).

100

PHOTOS_TAKEN

NUMBER

Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (Added in 2018).

100

DIVER

NVARCHAR2

Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1.

100

METHODNAME

NVARCHAR2

References the coral belt survey method.

100

BELTTRANSECTRUN

NUMBER

Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT.

100

TRANSECT

NUMBER

Transect number (1-4). For collections on HARAMP 2019, any data entered under transect 2 is for use as an internal, diver-to-diver calibration, and is not part of the canonical dataset

100

TRANSECTID

NUMBER

Unique transect ID number assigned to each transect during the same NCRMP mission (Added in 2018).

100

TRANSECTNUM

NUMBER

Unique identifier for each transect surveyed within a SITE.

100

SEGMENTID

NUMBER

Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018).

100

SEGMENT

NVARCHAR2

Segment number (1-7). Segments are within a TRANSECT and are typically 1 x 2.5 m in size and situated 2.5 m apart.

100

SEGLENGTH

NUMBER

Segment length (m).

100

SEGWIDTH

NUMBER

Segment width (m).

100

NO_COLONY_OBSERVED

NUMBER

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

100

CORL_YN

NUMBER

Flag (-1) to indicate presence of corallimorph on transect.

100

CORALLIMORPH_YN

NUMERIC

Flag (-1) to indicate presence of corallimorph on transect (Added Feb. 2015).

100

CLADIELLA_YN

NUMBER

Flag (-1) to indicate presence of cladiella on transect (Added Sept. 2014)

100

DENDRONEPHTHYA_YN

NUMBER

Flag (-1) to indicate presence of dendronephthya on transect (Added Sept. 2014).

100

DISTICHOPORA_YN

NUMERIC

Flag (-1) to indicate presence of distichopora on transect (Added Feb. 2015).

100

LOBOPHYTUM_YN

NUMBER

Flag (-1) to indicate presence of lobophytum on transect (Added Sept. 2014).

100

OCTO_YN

NUMERIC

Flag (-1) to indicate presence of octocoral on transect (added 2015).

100

PACHYCLAVULARIA_YN

NUMBER

Flag (-1) to indicate presence of pachyclavularia on transect (Added Sept. 2014).

100

PALYTHOA_YN

NUMBER

Flag (-1) to indicate presence of palythoa on transect (Added Sept. 2014).

100

PROTOPALYTHOA_YN

NUMBER

Flag (-1) to indicate presence of protopalythoa on transect (Added Sept. 2014).

100

SARCOPHYTON_YN

NUMBER

Flag to indicate presence of sarcophyton on transect (Added Sept. 2014)

100

SARCOTHELIA_YN

NUMERIC

Flag (-1) to indicate presence of sarcothelia on transect (added 2017).

100

SINULARIA_YN

NUMBER

Flag (-1) to indicate presence of sinularia on transect (Added Sept. 2014).

100

SOFT_YN

NUMERIC

Flag (-1) to indicate presence of soft coral on transect (added 2015).

100

STEREONEPHTHYA_YN

NUMBER

Flag (-1) to indicate presence of stereonephthya on transect (Added Sept. 2014).

100

STYLASTER_YN

NUMERIC

Flag (-1) to indicate presence of stylaster on transect (Added Feb. 2015).

100

WIRECORAL_YN

NUMBER

Flag (-1) to indicate presence of wire coral on transect (Added Sept. 2014).

100

ZOANTHUS_YN

NUMBER

Flag (-1) to indicate presence of zoanthus on transect (Added Sept. 2014).

Attribute Details

ROUNDID

CC ID: 371957

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	28
Scale:	0
Status:	Active
Description:	Unique Identifier for ROUND record.

MISSIONID

CC ID: 371945

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Mission Identifier.

REGION

CC ID: 371955

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Code for REGION_NAME.

REGION_NAME

CC ID: 371956

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	The name of the region surveyed in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.

ISLANDCODE

CC ID: 371940

Seq. Order:	5
Data Storage Type:	NVARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	3-letter code for ISLAND.

ISLAND

CC ID: 371939

Seq. Order:	6
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).

SITE

CC ID: 371963

Seq. Order:	7
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.

LATITUDE

CC ID: 371941

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Latitude in decimal degrees, WGS84, for the given SITE.

LONGITUDE

CC ID: 371943

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Longitude in decimal degrees, WGS84 for the given SITE.

REEF_ZONE_CODE

CC ID: 371954

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	3-letter code for REEF_ZONE.

REEF_ZONE

CC ID: 371953

Seq. Order:	11
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon).

HABITAT_CODE

CC ID: 371937

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	3-letter code for HABITAT_TYPE.

HABITAT_TYPE

CC ID: 371938

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE.

SITE_MIN_DEPTH

CC ID: 371966

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Minimum SITE depth (ft).

SITE_MAX_DEPTH

CC ID: 371965

Seq. Order:	13
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Maximum SITE depth (ft).

DEPTH_BIN

CC ID: 371934

Seq. Order:	14
Data Storage Type:	NVARCHAR2
Max Length:	60
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

DEPTH_CODE

CC ID: 371935

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Single-letter code for DEPTH_BIN (S, M, D).

SITEVISITID

CC ID: 371964

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Unique identifier created each time a SITE is surveyed on a DATE_.

DATE_

CC ID: 371932

Seq. Order:	15
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Local date the survey was conducted.

OBS_DAY

CC ID: 371947

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Numeric day the survey was conducted (DATE_).

OBS_MONTH

CC ID: 371948

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Numeric month the survey was conducted (DATE_).

OBS_YEAR

CC ID: 371949

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	4-digit year the survey was conducted (DATE_).

NO_SURVEY_YN

CC ID: 371946

Seq. Order:	23
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag (-1) to indicate transect was not surveyed (Added Sept. 2014).

PHOTOS_TAKEN

CC ID: 989843

Seq. Order:	23
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (Added in 2018).

DIVER

CC ID: 371936

Seq. Order:	24
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1.

METHODNAME

CC ID: 371944

Seq. Order:	25
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	Yes
Primary Key:	No
Status:	Active
Description:	References the coral belt survey method.

BELTTRANSECTRUN

CC ID: 371930

Seq. Order:	26
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Scale:	0
Status:	Active
Description:	Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT.

TRANSECT

CC ID: 371968

Seq. Order:	26
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Scale:	0
Status:	Active
Description:	Transect number (1-4). For collections on HARAMP 2019, any data entered under transect 2 is for use as an internal, diver-to-diver calibration, and is not part of the canonical dataset

TRANSECTID

CC ID: 989844

Seq. Order:	26
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique transect ID number assigned to each transect during the same NCRMP mission (Added in 2018).

TRANSECTNUM

CC ID: 989845

Seq. Order:	26
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique identifier for each transect surveyed within a SITE.

SEGMENTID

CC ID: 989846

Seq. Order:	26
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018).

SEGMENT

CC ID: 371960

Seq. Order:	27
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	Segment number (1-7). Segments are within a TRANSECT and are typically 1 x 2.5 m in size and situated 2.5 m apart.

SEGLENGTH

CC ID: 371959

Seq. Order:	28
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: 371961

Seq. Order:	29
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	8
Status:	Active
Description:	Segment width (m).

NO_COLONY_OBSERVED

CC ID: 989847

Seq. Order:	29
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).

CORL_YN

CC ID: 989848

Seq. Order:	29
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag (-1) to indicate presence of corallimorph on transect.

CORALLIMORPH_YN

CC ID: 819220

Seq. Order:	30
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag (-1) to indicate presence of corallimorph on transect (Added Feb. 2015).

CLADIELLA_YN

CC ID: 371931

Seq. Order:	31
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag (-1) to indicate presence of cladiella on transect (Added Sept. 2014)

DENDRONEPHTHYA_YN

CC ID: 371933

Seq. Order:	32
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag (-1) to indicate presence of dendronephthya on transect (Added Sept. 2014).

DISTICHOPORA_YN

CC ID: 819221

Seq. Order:	33
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag (-1) to indicate presence of distichopora on transect (Added Feb. 2015).

LOBOPHYTUM_YN

CC ID: 371942

Seq. Order:	34
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Flag (-1) to indicate presence of lobophytum on transect (Added Sept. 2014).

OCTO_YN

CC ID: 819224

Seq. Order:	35
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag (-1) to indicate presence of octocoral on transect (added 2015).

PACHYCLAVULARIA_YN

CC ID: 371950

Seq. Order:	36
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag (-1) to indicate presence of pachyclavularia on transect (Added Sept. 2014).

PALYTHOA_YN

CC ID: 371951

Seq. Order:	37
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Flag (-1) to indicate presence of palythoa on transect (Added Sept. 2014).

PROTOPALYTHOA_YN

CC ID: 371952

Seq. Order:	38
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag (-1) to indicate presence of protopalythoa on transect (Added Sept. 2014).

SARCOPHYTON_YN

CC ID: 371958

Seq. Order:	39
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Flag to indicate presence of sarcophyton on transect (Added Sept. 2014)

SARCOTHELIA_YN

CC ID: 819223

Seq. Order:	40
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag (-1) to indicate presence of sarcothelia on transect (added 2017).

SINULARIA_YN

CC ID: 371962

Seq. Order:	41
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag (-1) to indicate presence of sinularia on transect (Added Sept. 2014).

SOFT_YN

CC ID: 819271

Seq. Order:	42
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag (-1) to indicate presence of soft coral on transect (added 2015).

STEREONEPHTHYA_YN

CC ID: 371967

Seq. Order:	43
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Flag (-1) to indicate presence of stereonephthya on transect (Added Sept. 2014).

STYLASTER_YN

CC ID: 819222

Seq. Order:	44
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag (-1) to indicate presence of stylaster on transect (Added Feb. 2015).

WIRECORAL_YN

CC ID: 371969

Seq. Order:	45
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag (-1) to indicate presence of wire coral on transect (Added Sept. 2014).

ZOANTHUS_YN

CC ID: 371970

Seq. Order:	46
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	Flag (-1) to indicate presence of zoanthus on transect (Added Sept. 2014).

Catalog Details

Catalog Item ID:	36179
GUID:	gov.noaa.nmfs.inport:36179
Metadata Record Created By:	Troy T Kanemura
Metadata Record Created:	2016-12-31 00:51+0000
Metadata Record Last Modified By:	Lori H Luers
Metadata Record Last Modified:	2022-10-20 01:21+0000
Metadata Record Published:	2022-10-20
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2020-11-24
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2021-11-24