Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > National Coral Reef Monitoring Program > Pacific Remote Island Areas > 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:46283 | Updated: August 9, 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 Jan 2019 to reflect changes made during 2018 surveys

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) for the 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 to indicate transect was not surveyed (-1). Added Sept. 2014.
100	PHOTOS_TAKEN	NUMERIC	Flag to indicate that benthic photographs (also known as photoquads) were captured for the transect (-1). Photoquads are typically analyzed for benthic cover post-mission. 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. NULL if NO_SURVEY_YN = -1.
100	BELTTRANSECTRUN	NUMBER	Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT and SEGMENT. Deprecated in 2018.
100	TRANSECTID	NUMERIC	Primary key for CORAL_BELT_TRANSECT and unique identifier for TRANSECTNUM. Added in 2018.
100	TRANSECT	NUMBER	Transect number (1-4). Deprecated in 2018 and replaced by TRANSECTNUM.
100	TRANSECTNUM	NUMERIC	Transect number (1-2). Added in 2018, replaces TRANSECT.
100	SEGMENTID	NUMERIC	Unique identifier for SEGMENT. Added in 2018. NULL if NO_SURVEY_YN = -1.
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, numbered 1, 3, 5 and 7.
100	SEGLENGTH	NUMBER	Segment length (m).
100	SEGWIDTH	NUMBER	Segment width (m).
100	NO_COLONY_OBSERVED	NUMERIC	Flag to indicate the segment was surveyed and no adult colonies were found (-1). Added in 2018.
100	CORL_YN	NUMERIC	Flag to indicate presence of corallimorph on transect (-1). Temporarily added during Marianas portion of HA1401 cruise (Sept. 2014), permanently added Feb. 2015.
100	CLADIELLA_YN	NUMBER	Flag to indicate presence of cladiella on transect (-1). Added Sept. 201
100	DENDRONEPHTHYA_YN	NUMBER	Flag to indicate presence of dendronephthya on transect (-1). Added Sept. 2014.
100	DISTICHOPORA_YN	NUMERIC	Flag to indicate presence of distichopora on transect (-1). Added Feb. 2015.
100	LOBOPHYTUM_YN	NUMBER	Flag to indicate presence of lobophytum on transect (-1). Added Sept. 2014.
100	OCTO_YN	NUMERIC	Flag to indicate presence of octocoral on transect (-1). Added 2015.
100	PACHYCLAVULARIA_YN	NUMBER	Flag to indicate presence of pachyclavularia on transect (-1). Added Sept. 2014.
100	PALYTHOA_YN	NUMBER	Flag to indicate presence of palythoa on transect (-1). Added Sept. 2014.
100	PROTOPALYTHOA_YN	NUMBER	Flag to indicate presence of protopalythoa on transect (-1). Added Sept. 2014.
100	SARCOPHYTON_YN	NUMBER	Flag to indicate presence of sarcophyton on transect (-1). Added Sept. 2014.
100	SARCOTHELIA_YN	NUMBER	Flag to indicate presence of sarcothelia on transect (-1). Added June 2017.
100	SINULARIA_YN	NUMBER	Flag to indicate presence of sinularia on transect (-1). Added Sept. 2014.
100	SOFT_YN	NUMERIC	Flag to indicate presence of soft coral on transect (-1). Added 2015.
100	STEREONEPHTHYA_YN	NUMBER	Flag to indicate presence of stereonephthya on transect (-1). Added Sept. 2014.
100	STYLASTER_YN	NUMERIC	Flag (-1) to indicate presence of stylaster on transect (-1). Added Feb. 2015.
100	WIRECORAL_YN	NUMBER	Flag to indicate presence of wire coral on transect (-1). Added Sept. 2014.
100	ZOANTHUS_YN	NUMBER	Flag to indicate presence of zoanthus on transect (-1). 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) for the 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 to indicate transect was not surveyed (-1). Added Sept. 2014.

100

PHOTOS_TAKEN

NUMERIC

Flag to indicate that benthic photographs (also known as photoquads) were captured for the transect (-1). Photoquads are typically analyzed for benthic cover post-mission. 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. NULL if NO_SURVEY_YN = -1.

100

BELTTRANSECTRUN

NUMBER

Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT and SEGMENT. Deprecated in 2018.

100

TRANSECTID

NUMERIC

Primary key for CORAL_BELT_TRANSECT and unique identifier for TRANSECTNUM. Added in 2018.

100

TRANSECT

NUMBER

Transect number (1-4). Deprecated in 2018 and replaced by TRANSECTNUM.

100

TRANSECTNUM

NUMERIC

Transect number (1-2). Added in 2018, replaces TRANSECT.

100

SEGMENTID

NUMERIC

Unique identifier for SEGMENT. Added in 2018. NULL if NO_SURVEY_YN = -1.

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, numbered 1, 3, 5 and 7.

100

SEGLENGTH

NUMBER

Segment length (m).

100

SEGWIDTH

NUMBER

Segment width (m).

100

NO_COLONY_OBSERVED

NUMERIC

Flag to indicate the segment was surveyed and no adult colonies were found (-1). Added in 2018.

100

CORL_YN

NUMERIC

Flag to indicate presence of corallimorph on transect (-1). Temporarily added during Marianas portion of HA1401 cruise (Sept. 2014), permanently added Feb. 2015.

100

CLADIELLA_YN

NUMBER

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

100

DENDRONEPHTHYA_YN

NUMBER

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

100

DISTICHOPORA_YN

NUMERIC

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

100

LOBOPHYTUM_YN

NUMBER

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

100

OCTO_YN

NUMERIC

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

100

PACHYCLAVULARIA_YN

NUMBER

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

100

PALYTHOA_YN

NUMBER

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

100

PROTOPALYTHOA_YN

NUMBER

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

100

SARCOPHYTON_YN

NUMBER

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

100

SARCOTHELIA_YN

NUMBER

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

100

SINULARIA_YN

NUMBER

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

100

SOFT_YN

NUMERIC

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

100

STEREONEPHTHYA_YN

NUMBER

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

100

STYLASTER_YN

NUMERIC

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

100

WIRECORAL_YN

NUMBER

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

100

ZOANTHUS_YN

NUMBER

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

Attribute Details

ROUNDID

CC ID: 571792

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: 571780

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

REGION

CC ID: 571790

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: 571791

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: 571775

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: 571774

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: 571798

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: 571776

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: 571778

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: 571789

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: 571788

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: 571772

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: 571773

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: 571801

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: 571800

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: 571769

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) for the given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m

DEPTH_CODE

CC ID: 571770

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: 571799

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: 571767

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: 571782

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: 571783

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: 571784

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: 571781

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

PHOTOS_TAKEN

CC ID: 813832

Seq. Order:	22
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag to indicate that benthic photographs (also known as photoquads) were captured for the transect (-1). Photoquads are typically analyzed for benthic cover post-mission. Added in 2018.

DIVER

CC ID: 571771

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

Seq. Order:	23
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	Yes
Primary Key:	No
Status:	Active
Description:	References the coral belt survey method. NULL if NO_SURVEY_YN = -1.

BELTTRANSECTRUN

CC ID: 571765

Seq. Order:	24
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 and SEGMENT. Deprecated in 2018.

TRANSECTID

CC ID: 813833

Seq. Order:	24
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Primary key for CORAL_BELT_TRANSECT and unique identifier for TRANSECTNUM. Added in 2018.

TRANSECT

CC ID: 571803

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). Deprecated in 2018 and replaced by TRANSECTNUM.

TRANSECTNUM

CC ID: 813834

Seq. Order:	26
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Transect number (1-2). Added in 2018, replaces TRANSECT.

SEGMENTID

CC ID: 813835

Seq. Order:	27
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique identifier for SEGMENT. Added in 2018. NULL if NO_SURVEY_YN = -1.

SEGMENT

CC ID: 571795

Seq. Order:	28
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, numbered 1, 3, 5 and 7.

SEGLENGTH

CC ID: 571794

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

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: 813836

Seq. Order:	29
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag to indicate the segment was surveyed and no adult colonies were found (-1). Added in 2018.

CORL_YN

CC ID: 820384

Seq. Order:	29
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag to indicate presence of corallimorph on transect (-1). Temporarily added during Marianas portion of HA1401 cruise (Sept. 2014), permanently added Feb. 2015.

CLADIELLA_YN

CC ID: 571766

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

DENDRONEPHTHYA_YN

CC ID: 571768

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

DISTICHOPORA_YN

CC ID: 820385

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

LOBOPHYTUM_YN

CC ID: 571777

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

OCTO_YN

CC ID: 820386

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

PACHYCLAVULARIA_YN

CC ID: 571785

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

PALYTHOA_YN

CC ID: 571786

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

PROTOPALYTHOA_YN

CC ID: 571787

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

SARCOPHYTON_YN

CC ID: 571793

Seq. Order:	36
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 (-1). Added Sept. 2014.

SARCOTHELIA_YN

CC ID: 571806

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

SINULARIA_YN

CC ID: 571797

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

SOFT_YN

CC ID: 820387

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

STEREONEPHTHYA_YN

CC ID: 571802

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 stereonephthya on transect (-1). Added Sept. 2014.

STYLASTER_YN

CC ID: 820388

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

WIRECORAL_YN

CC ID: 571804

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

ZOANTHUS_YN

CC ID: 571805

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

Catalog Details

Catalog Item ID:	46283
GUID:	gov.noaa.nmfs.inport:46283
Metadata Record Created By:	Troy T Kanemura
Metadata Record Created:	2017-06-15 14:43+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2017-06-21
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2017-06-21
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2018-06-21