Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Coral belt observations (presence)

Description

Coral belt observations (presence)

Entity Information

Entity Type
Data View

Data Attribute / Type Description
ROUNDID
NUMBER 		Unique Identifier for ROUND record.
MISSIONID
VARCHAR2 		Mission identifier.
REGION
VARCHAR2 		Code for REGION_NAME.
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.
ISLANDCODE
NVARCHAR2 		3-letter code for ISLAND.
ISLAND
NVARCHAR2 		Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
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.
LATITUDE
NUMBER 		Latitude in decimal degrees, WGS84, for the given SITE.
LONGITUDE
NUMBER 		Longitude in decimal degrees, WGS84 for the given SITE.
REEF_ZONE_CODE
VARCHAR2 		3-letter code for REEF_ZONE.
REEF_ZONE
NVARCHAR2 		The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon).
HABITAT_CODE
VARCHAR2 		3-letter code for HABITAT_TYPE.
HABITAT_TYPE
VARCHAR2 		Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE.
SITE_MIN_DEPTH
NUMBER 		Minimum SITE depth (ft).
SITE_MAX_DEPTH
NUMBER 		Maximum SITE depth (ft).
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
DEPTH_CODE
VARCHAR2 		Single-letter code for DEPTH_BIN (S, M, D).
SITEVISITID
NUMBER 		Unique identifier created each time a SITE is surveyed on a DATE_.
DATE_
DATE 		Local date the survey was conducted.
OBS_DAY
NUMBER 		Numeric day the survey was conducted (DATE_).
OBS_MONTH
NUMBER 		Numeric month the survey was conducted (DATE_).
OBS_YEAR
NUMBER 		4-digit year the survey was conducted (DATE_).
NO_SURVEY_YN
NUMBER 		Flag to indicate transect was not surveyed (-1). Added Sept. 2014.
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.
DIVER
NVARCHAR2 		Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1.
METHODNAME
NVARCHAR2 		References the coral belt survey method. NULL if NO_SURVEY_YN = -1.
BELTTRANSECTRUN
NUMBER 		Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT and SEGMENT. Deprecated in 2018.
TRANSECTID
NUMERIC 		Primary key for CORAL_BELT_TRANSECT and unique identifier for TRANSECTNUM. Added in 2018.
TRANSECT
NUMBER 		Transect number (1-4). Deprecated in 2018 and replaced by TRANSECTNUM.
TRANSECTNUM
NUMERIC 		Transect number (1-2). Added in 2018, replaces TRANSECT.
SEGMENTID
NUMERIC 		Unique identifier for SEGMENT. Added in 2018. NULL if NO_SURVEY_YN = -1.
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.
SEGLENGTH
NUMBER 		Segment length (m).
SEGWIDTH
NUMBER 		Segment width (m).
NO_COLONY_OBSERVED
NUMERIC 		Flag to indicate the segment was surveyed and no adult colonies were found (-1). Added in 2018.
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.
CLADIELLA_YN
NUMBER 		Flag to indicate presence of cladiella on transect (-1). Added Sept. 201
DENDRONEPHTHYA_YN
NUMBER 		Flag to indicate presence of dendronephthya on transect (-1). Added Sept. 2014.
DISTICHOPORA_YN
NUMERIC 		Flag to indicate presence of distichopora on transect (-1). Added Feb. 2015.
LOBOPHYTUM_YN
NUMBER 		Flag to indicate presence of lobophytum on transect (-1). Added Sept. 2014.
OCTO_YN
NUMERIC 		Flag to indicate presence of octocoral on transect (-1). Added 2015.
PACHYCLAVULARIA_YN
NUMBER 		Flag to indicate presence of pachyclavularia on transect (-1). Added Sept. 2014.
PALYTHOA_YN
NUMBER 		Flag to indicate presence of palythoa on transect (-1). Added Sept. 2014.
PROTOPALYTHOA_YN
NUMBER 		Flag to indicate presence of protopalythoa on transect (-1). Added Sept. 2014.
SARCOPHYTON_YN
NUMBER 		Flag to indicate presence of sarcophyton on transect (-1). Added Sept. 2014.
SARCOTHELIA_YN
NUMBER 		Flag to indicate presence of sarcothelia on transect (-1). Added June 2017.
SINULARIA_YN
NUMBER 		Flag to indicate presence of sinularia on transect (-1). Added Sept. 2014.
SOFT_YN
NUMERIC 		Flag to indicate presence of soft coral on transect (-1). Added 2015.
STEREONEPHTHYA_YN
NUMBER 		Flag to indicate presence of stereonephthya on transect (-1). Added Sept. 2014.
STYLASTER_YN
NUMERIC 		Flag (-1) to indicate presence of stylaster on transect (-1). Added Feb. 2015.
WIRECORAL_YN
NUMBER 		Flag to indicate presence of wire coral on transect (-1). Added Sept. 2014.
ZOANTHUS_YN
NUMBER 		Flag to indicate presence of zoanthus on transect (-1). Added Sept. 2014.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

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

Rubric Score Primary Key? 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