Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > National Coral Reef Monitoring Program > American Samoa > 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:36178 | 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. 2014.
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. 2014.

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

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.
General Data Type:	NUMBER

MISSIONID

CC ID: 371890

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

REGION

CC ID: 371891

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

REGION_NAME

CC ID: 371892

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.
General Data Type:	VARCHAR2

ISLANDCODE

CC ID: 371894

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

ISLAND

CC ID: 371893

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).
General Data Type:	NVARCHAR2

SITE

CC ID: 371895

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.
General Data Type:	NVARCHAR2

LATITUDE

CC ID: 371896

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.
General Data Type:	NUMBER

LONGITUDE

CC ID: 371897

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.
General Data Type:	NUMBER

REEF_ZONE_CODE

CC ID: 371898

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

REEF_ZONE

CC ID: 371899

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).
General Data Type:	NVARCHAR2

HABITAT_CODE

CC ID: 371909

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

HABITAT_TYPE

CC ID: 371910

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.
General Data Type:	VARCHAR2

SITE_MIN_DEPTH

CC ID: 371907

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

SITE_MAX_DEPTH

CC ID: 371908

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).
General Data Type:	NUMBER

DEPTH_BIN

CC ID: 371900

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
General Data Type:	NVARCHAR2

DEPTH_CODE

CC ID: 371901

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).
General Data Type:	VARCHAR2

SITEVISITID

CC ID: 371902

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_.
General Data Type:	NUMBER

DATE_

CC ID: 371903

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

OBS_DAY

CC ID: 371904

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_).
General Data Type:	NUMBER

OBS_MONTH

CC ID: 371905

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_).
General Data Type:	NUMBER

OBS_YEAR

CC ID: 371906

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_).
General Data Type:	NUMBER

NO_SURVEY_YN

CC ID: 371929

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.
General Data Type:	NUMBER

PHOTOS_TAKEN

CC ID: 813925

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

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.
General Data Type:	NVARCHAR2

METHODNAME

CC ID: 371913

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.
General Data Type:	NVARCHAR2

BELTTRANSECTRUN

CC ID: 371912

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.
General Data Type:	NUMBER

TRANSECTID

CC ID: 813926

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

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.
General Data Type:	NUMBER

TRANSECTNUM

CC ID: 813927

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

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

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.
General Data Type:	NVARCHAR2

SEGLENGTH

CC ID: 371917

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).
General Data Type:	NUMBER

SEGWIDTH

CC ID: 371916

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).
General Data Type:	NUMBER

NO_COLONY_OBSERVED

CC ID: 813929

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

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

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. 2014.
General Data Type:	NUMBER

DENDRONEPHTHYA_YN

CC ID: 371919

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.
General Data Type:	NUMBER

DISTICHOPORA_YN

CC ID: 821418

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

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.
General Data Type:	NUMBER

OCTO_YN

CC ID: 821419

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

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.
General Data Type:	NUMBER

PALYTHOA_YN

CC ID: 371926

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.
General Data Type:	NUMBER

PROTOPALYTHOA_YN

CC ID: 371927

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.
General Data Type:	NUMBER

SARCOPHYTON_YN

CC ID: 371922

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.
General Data Type:	NUMBER

SARCOTHELIA_YN

CC ID: 814069

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

SINULARIA_YN

CC ID: 371923

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.
General Data Type:	NUMBER

SOFT_YN

CC ID: 821420

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

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.
General Data Type:	NUMBER

STYLASTER_YN

CC ID: 821421

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

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.
General Data Type:	NUMBER

ZOANTHUS_YN

CC ID: 371928

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.
General Data Type:	NUMBER

Catalog Details

Catalog Item ID:	36178
GUID:	gov.noaa.nmfs.inport:36178
Metadata Record Created By:	Annette M DesRochers
Metadata Record Created:	2016-12-31 00:51+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2021-01-07
Owner Org:	PIFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2021-01-07
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2022-01-07