Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Coral belt observations (juvenile)

Description

Coral belt observations (juvenile)

Entity Information

Entity Type
Data View

Data Attribute / Type Description
ROUNDID
NUMBER
Unique Identifier for ROUND record.
MISSIONID
VARCHAR2
Mission Identifier.
REGION
VARCHAR2
Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table
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.
ISLAND
VARCHAR2
Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
ISLANDCODE
VARCHAR2
3-letter island code
SECTOR
VARCHAR2
This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island (Added Jan. 2012)
SUB_ISLAND
NVARCHAR2
Name of the island specific location surveyed; e.g., Vatia, Faga'alu, Fagamalo
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 reef zone code
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.
DEPTH_BIN
NVARCHAR2
Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
DEPTH_CODE
VARCHAR2
Single-letter code for DEPTH_BIN (S, M, D).
SITE_MIN_DEPTH
NUMBER
Minimum SITE depth (ft).
MINDEPTH
NUMBER
Minimum Depth of the transect (in meters)
SITE_MAX_DEPTH
NUMBER
Maximum SITE depth (ft).
MAXDEPTH
NUMBER
Minimum Depth of the transect (in meters)
EXCLUDE_FLAG
VARCHAR2
Flag to indicate whether site should be excluded from analysis
NO_SURVEY_YN
NUMERIC
Flag (-1) to indicate TRANSECT was not surveyed (Added Sept. 2014).
SITEVISITID
NUMBER
Unique identifier created each time a SITE is surveyed on a DATE_.
DATE_
DATE
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_).
PHOTOS_TAKEN
NUMBER
Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (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
BELTTRANSECTRUN
NUMBER
Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT.
TRANSECTID
NVARCHAR2
References the coral belt survey method.
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
TRANSECTNUM
NUMBER
Unique identifier for each transect surveyed within a SITE.
SEGMENTID
NUMBER
Unique ID number for each segment surveyed during the same NCRMP mission.
SEGMENT
NVARCHAR2
Unique ID number for each segment surveyed during the same NCRMP mission.
SEGLENGTH
NUMBER
Segment length (m).
SEGWIDTH
NUMBER
Segment width (m), usually 1 m.
TRANWIDTH
NUMBER
Transect Length (m)
TRANLENGTH
NUMBER
Transect Width (m)
NO_COLONY_OBSERVED
NUMBER
Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018).
COLONYID
NUMBER
Colony Identifier
SPECIES
NVARCHAR2
Species observed
COLONYLENGTH
NUMBER
Length of juvenile coral colony (<=5 cm). Required. Value -9 is a placeholder and represents a missing value.
COLONYWIDTH
NUMBER
Width of juvenile coral colony (<=5 cm). Required. Value -9 is a placeholder and represents a missing value.
MORPH_CODE
VARCHAR2
4-letter morphology code
MORPHOLOGY
VARCHAR2
Coral morphology type (branching, columnar, encrusting, etc.). Required.
TAXONCODE
NVARCHAR2
4-letter code for TAXONNAME. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found. NULL if transect was not surveyed (NO_SURVEY_YN = -1).
TAXONNAME
NVARCHAR2
Scientific name of observed organism to the finest taxonomic resolution that divers can identify a colony to, either to species or genus level identification (see RANK). NULL if NO_SURVEY_YN = -1.
RANK
VARCHAR2
Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database.
CLASS
VARCHAR2
Taxonomic classification: Class of observed organism (TAXONNAME).
S_ORDER
VARCHAR2
Taxonomic classification: Order of observed organism (TAXONNAME).
FAMILY
VARCHAR2
Taxonomic classification: Order of observed organism (TAXONNAME).
GENUS_CODE
VARCHAR2
4-letter genus code
GENUS
NVARCHAR2
Taxonomic classification: Genus name of observed organism (TAXONNAME).
SCIENTIFIC_NAME
VARCHAR2
Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level (see RANK).
APHIAID
VARCHAR2
Aphia ID from the World Registry of Marine Species (WoRMS) database. Null if organism not identified to species taxonomic level (see RANK). If value = 0, species does not exist in WoRMS.
CORAL_CORISID
VARCHAR2
CoRIS ID for coral metadata record (Added June 2011)
COMMENTS
VARCHAR2
General observation comments

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_F
Short Name: V0_CORAL_OBS_F
Status: Completed
Abstract:

Coral belt observations (juvenile)

Notes:

Loaded by FGDC Metadata Uploader, batch 8172, 02-16-2016 19:10

Entity Information

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

Coral belt observations (juvenile)

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 Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table
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
ISLAND VARCHAR2 Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
100
ISLANDCODE VARCHAR2 3-letter island code
100
SECTOR VARCHAR2 This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island (Added Jan. 2012)
100
SUB_ISLAND NVARCHAR2 Name of the island specific location surveyed; e.g., Vatia, Faga'alu, Fagamalo
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 reef zone code
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
DEPTH_BIN NVARCHAR2 Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site
100
DEPTH_CODE VARCHAR2 Single-letter code for DEPTH_BIN (S, M, D).
100
SITE_MIN_DEPTH NUMBER Minimum SITE depth (ft).
100
MINDEPTH NUMBER Minimum Depth of the transect (in meters)
100
SITE_MAX_DEPTH NUMBER Maximum SITE depth (ft).
100
MAXDEPTH NUMBER Minimum Depth of the transect (in meters)
100
EXCLUDE_FLAG VARCHAR2 Flag to indicate whether site should be excluded from analysis
100
NO_SURVEY_YN NUMERIC Flag (-1) to indicate TRANSECT was not surveyed (Added Sept. 2014).
100
SITEVISITID NUMBER Unique identifier created each time a SITE is surveyed on a DATE_.
100
DATE_ DATE 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
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
TRANSECTID NVARCHAR2 References the coral belt survey method.
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
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.
100
SEGMENT NVARCHAR2 Unique ID number for each segment surveyed during the same NCRMP mission.
100
SEGLENGTH NUMBER Segment length (m).
100
SEGWIDTH NUMBER Segment width (m), usually 1 m.
100
TRANWIDTH NUMBER Transect Length (m)
100
TRANLENGTH NUMBER Transect 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
COLONYID NUMBER Colony Identifier
100
SPECIES NVARCHAR2 Species observed
100
COLONYLENGTH NUMBER Length of juvenile coral colony (<=5 cm). Required. Value -9 is a placeholder and represents a missing value.
100
COLONYWIDTH NUMBER Width of juvenile coral colony (<=5 cm). Required. Value -9 is a placeholder and represents a missing value.
100
MORPH_CODE VARCHAR2 4-letter morphology code
100
MORPHOLOGY VARCHAR2 Coral morphology type (branching, columnar, encrusting, etc.). Required.
100
TAXONCODE NVARCHAR2 4-letter code for TAXONNAME. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found. NULL if transect was not surveyed (NO_SURVEY_YN = -1).
100
TAXONNAME NVARCHAR2 Scientific name of observed organism to the finest taxonomic resolution that divers can identify a colony to, either to species or genus level identification (see RANK). NULL if NO_SURVEY_YN = -1.
100
RANK VARCHAR2 Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database.
100
CLASS VARCHAR2 Taxonomic classification: Class of observed organism (TAXONNAME).
100
S_ORDER VARCHAR2 Taxonomic classification: Order of observed organism (TAXONNAME).
100
FAMILY VARCHAR2 Taxonomic classification: Order of observed organism (TAXONNAME).
100
GENUS_CODE VARCHAR2 4-letter genus code
100
GENUS NVARCHAR2 Taxonomic classification: Genus name of observed organism (TAXONNAME).
100
SCIENTIFIC_NAME VARCHAR2 Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level (see RANK).
100
APHIAID VARCHAR2 Aphia ID from the World Registry of Marine Species (WoRMS) database. Null if organism not identified to species taxonomic level (see RANK). If value = 0, species does not exist in WoRMS.
100
CORAL_CORISID VARCHAR2 CoRIS ID for coral metadata record (Added June 2011)
100
COMMENTS VARCHAR2 General observation comments

Attribute Details

ROUNDID

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

Unique Identifier for ROUND record.

MISSIONID

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

Mission Identifier.

REGION

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

Region Code for the LIST_OF_REGIONS record, this is used by other tables to join on the LIST_OF_REGIONS table

Allowed Values: No domain defined.

REGION_NAME

CC ID: 286377
Seq. Order: 4
Data Storage Type: VARCHAR2
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.

Allowed Values: No domain defined.

ISLAND

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

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

Allowed Values: No domain defined.

ISLANDCODE

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

3-letter island code

Allowed Values: No domain defined.

SECTOR

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

This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island (Added Jan. 2012)

Allowed Values: No domain defined.

SUB_ISLAND

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

Name of the island specific location surveyed; e.g., Vatia, Faga'alu, Fagamalo

SITE

CC ID: 286381
Seq. Order: 9
Data Storage Type: NVARCHAR2
Required: No
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.

Allowed Values: No domain defined.

LATITUDE

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

Latitude in decimal degrees, WGS84, for the given site

Allowed Values: No domain defined.

LONGITUDE

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

Longitude in decimal degrees, WGS84 for the given site

Allowed Values: No domain defined.

REEF_ZONE_CODE

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

3-letter reef zone code

Allowed Values: No domain defined.

REEF_ZONE

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

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

Allowed Values: No domain defined.

HABITAT_CODE

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

3-letter code for HABITAT_TYPE.

Allowed Values: No domain defined.

HABITAT_TYPE

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

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

Allowed Values: No domain defined.

DEPTH_BIN

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

Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site

Allowed Values: No domain defined.

DEPTH_CODE

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

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

Allowed Values: No domain defined.

SITE_MIN_DEPTH

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

Minimum SITE depth (ft).

MINDEPTH

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

Minimum Depth of the transect (in meters)

Allowed Values: No domain defined.

SITE_MAX_DEPTH

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

Maximum SITE depth (ft).

MAXDEPTH

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

Minimum Depth of the transect (in meters)

Allowed Values: No domain defined.

EXCLUDE_FLAG

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

Flag to indicate whether site should be excluded from analysis

Allowed Values: No domain defined.

NO_SURVEY_YN

CC ID: 1003438
Seq. Order: 23
Data Storage Type: NUMERIC
Required: No
Primary Key: No
Status: Active
Description:

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

SITEVISITID

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

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

Allowed Values: No domain defined.

DATE_

CC ID: 286390
Seq. Order: 25
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date the survey was conducted

Allowed Values: No domain defined.

OBS_DAY

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

Numeric day the survey was conducted (DATE_).

Allowed Values: No domain defined.

OBS_MONTH

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

Numeric month the survey was conducted (DATE_).

Allowed Values: No domain defined.

OBS_YEAR

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

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

Allowed Values: No domain defined.

PHOTOS_TAKEN

CC ID: 1003439
Seq. Order: 29
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: 286397
Seq. Order: 30
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

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

Allowed Values: No domain defined.

METHODNAME

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

References the coral belt survey method

Allowed Values: No domain defined.

BELTTRANSECTRUN

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

Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT.

Allowed Values: No domain defined.

TRANSECTID

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

References the coral belt survey method.

TRANSECT

CC ID: 286400
Seq. Order: 34
Data Storage Type: NUMBER
Required: No
Primary Key: No
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

Allowed Values: No domain defined.

TRANSECTNUM

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

Unique identifier for each transect surveyed within a SITE.

SEGMENTID

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

Unique ID number for each segment surveyed during the same NCRMP mission.

SEGMENT

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

Unique ID number for each segment surveyed during the same NCRMP mission.

Allowed Values: No domain defined.

SEGLENGTH

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

Segment length (m).

SEGWIDTH

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

Segment width (m), usually 1 m.

TRANWIDTH

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

Transect Length (m)

Allowed Values: No domain defined.

TRANLENGTH

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

Transect Width (m)

Allowed Values: No domain defined.

NO_COLONY_OBSERVED

CC ID: 1003445
Seq. Order: 42
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).

COLONYID

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

Colony Identifier

Allowed Values: No domain defined.

SPECIES

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

Species observed

Allowed Values: No domain defined.

COLONYLENGTH

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

Length of juvenile coral colony (<=5 cm). Required. Value -9 is a placeholder and represents a missing value.

Allowed Values: No domain defined.

COLONYWIDTH

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

Width of juvenile coral colony (<=5 cm). Required. Value -9 is a placeholder and represents a missing value.

Allowed Values: No domain defined.

MORPH_CODE

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

4-letter morphology code

Allowed Values: No domain defined.

MORPHOLOGY

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

Coral morphology type (branching, columnar, encrusting, etc.). Required.

Allowed Values: No domain defined.

TAXONCODE

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

4-letter code for TAXONNAME. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found. NULL if transect was not surveyed (NO_SURVEY_YN = -1).

TAXONNAME

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

Scientific name of observed organism to the finest taxonomic resolution that divers can identify a colony to, either to species or genus level identification (see RANK). NULL if NO_SURVEY_YN = -1.

Allowed Values: No domain defined.

RANK

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

Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database.

Allowed Values: No domain defined.

CLASS

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

Taxonomic classification: Class of observed organism (TAXONNAME).

Allowed Values: No domain defined.

S_ORDER

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

Taxonomic classification: Order of observed organism (TAXONNAME).

Allowed Values: No domain defined.

FAMILY

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

Taxonomic classification: Order of observed organism (TAXONNAME).

Allowed Values: No domain defined.

GENUS_CODE

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

4-letter genus code

Allowed Values: No domain defined.

GENUS

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

Taxonomic classification: Genus name of observed organism (TAXONNAME).

Allowed Values: No domain defined.

SCIENTIFIC_NAME

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

Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If NULL, organism not identified to species taxonomic level (see RANK).

Allowed Values: No domain defined.

APHIAID

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

Aphia ID from the World Registry of Marine Species (WoRMS) database. Null if organism not identified to species taxonomic level (see RANK). If value = 0, species does not exist in WoRMS.

Allowed Values: No domain defined.

CORAL_CORISID

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

CoRIS ID for coral metadata record (Added June 2011)

Allowed Values: No domain defined.

COMMENTS

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

General observation comments

Allowed Values: No domain defined.

Catalog Details

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