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_F

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

Item Identification

Title:	View: V0_CORAL_OBS_F
Short Name:	V0_CORAL_OBS_F
Status:	Completed
Abstract:	Coral belt observations (juvenile)
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 (juvenile)

Data Attributes

Attribute Summary

	Name	Type	Description
100	ROUNDID	NUMERIC	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	NUMERIC	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 (yes/no, -1/0). 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 1 m in size and situated 2.5 m apart.
100	SEGLENGTH	NUMBER	Segment length (m).
100	SEGWIDTH	NUMBER	Segment width (m).
100	NO_COLONY_OBSERVED	NUMERIC	Flag to indicate the SEGMENT was surveyed and no adult colonies were found (-1). Added in 2018.
100	COLONYID	NUMBER	Coral colony identifier. NULL if NO_SURVEY_YN = -1 or NO_COLONY_OBSERVED = -1 or TAXONCODE/SPECIES = 'AAAA'.
100	COLONYLENGTH	NUMBER	Length of juvenile coral colony (< 5 cm). Required if colony observed. Value -9 is a placeholder and represents a missing value.
100	COLONYWIDTH	NUMBER	Width of juvenile coral colony (cm). Value -9 is a placeholder and represents a missing value. No longer measured as of 2018.
100	MORPH_CODE	VARCHAR2	Code for MORPHOLOGY.
100	MORPHOLOGY	VARCHAR2	Coral morphology type (branching, columnar, encrusting, etc.). Required if colony observed.
100	TAXONCODE	NVARCHAR2	4-letter code for TAXONNAME. Required. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found (NO_COLONY_OBSERVED = -1). NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1).
100	SPECIES	TEXT	4-letter code for TAXONNAME. Required. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found (NO_COLONY_OBSERVED = -1). 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 or if NO_COLONY_OBSERVED = -1.
100	RANK	VARCHAR2	Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. NULL if TAXONCODE = 'UNKN' or 'CALG'.
100	PHYLUM	VARCHAR2	Taxonomic classification: Phylum of observed organism (TAXONNAME).
100	CLASS	NVARCHAR2	Taxonomic classification: Class of observed organism (TAXONNAME).
100	S_ORDER	VARCHAR2	Taxonomic classification: Order of observed organism (TAXONNAME).
100	FAMILY	VARCHAR2	Taxonomic classification: Family of observed organism (TAXONNAME).
100	GENUS_CODE	NVARCHAR2	4-letter code for GENUS.
100	GENUS	NVARCHAR2	Taxonomic classification: Genus name of observed organism (TAXONNAME). NULL if TAXONNAME = Unknown Scleractinian or Crustose Coralline Algae.
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.

Name

Type

Description

100

ROUNDID

NUMERIC

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

NUMERIC

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 (yes/no, -1/0). 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 1 m in size and situated 2.5 m apart.

100

SEGLENGTH

NUMBER

Segment length (m).

100

SEGWIDTH

NUMBER

Segment width (m).

100

NO_COLONY_OBSERVED

NUMERIC

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

100

COLONYID

NUMBER

Coral colony identifier. NULL if NO_SURVEY_YN = -1 or NO_COLONY_OBSERVED = -1 or TAXONCODE/SPECIES = 'AAAA'.

100

COLONYLENGTH

NUMBER

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

100

COLONYWIDTH

NUMBER

Width of juvenile coral colony (cm). Value -9 is a placeholder and represents a missing value. No longer measured as of 2018.

100

MORPH_CODE

VARCHAR2

Code for MORPHOLOGY.

100

MORPHOLOGY

VARCHAR2

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

100

TAXONCODE

NVARCHAR2

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

100

SPECIES

TEXT

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 or if NO_COLONY_OBSERVED = -1.

100

RANK

VARCHAR2

Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. NULL if TAXONCODE = 'UNKN' or 'CALG'.

100

PHYLUM

VARCHAR2

Taxonomic classification: Phylum of observed organism (TAXONNAME).

100

CLASS

NVARCHAR2

Taxonomic classification: Class of observed organism (TAXONNAME).

100

S_ORDER

VARCHAR2

Taxonomic classification: Order of observed organism (TAXONNAME).

100

FAMILY

VARCHAR2

Taxonomic classification: Family of observed organism (TAXONNAME).

100

GENUS_CODE

NVARCHAR2

4-letter code for GENUS.

100

GENUS

NVARCHAR2

Taxonomic classification: Genus name of observed organism (TAXONNAME). NULL if TAXONNAME = Unknown Scleractinian or Crustose Coralline Algae.

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.

Attribute Details

ROUNDID

CC ID: 813101

Seq. Order:	1
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique Identifier for ROUND record.

MISSIONID

CC ID: 371864

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

REGION

CC ID: 371874

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

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

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

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

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

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

LONGITUDE

CC ID: 371862

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

REEF_ZONE_CODE

CC ID: 371873

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

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

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

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

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

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

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

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

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

DATE_

CC ID: 371850

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

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

OBS_MONTH

CC ID: 371868

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

OBS_YEAR

CC ID: 371869

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

NO_SURVEY_YN

CC ID: 812963

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

PHOTOS_TAKEN

CC ID: 812964

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 (yes/no, -1/0). Photoquads are typically analyzed for benthic cover post-mission. Added in 2018.

DIVER

CC ID: 371853

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

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

Seq. Order:	24
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	28
Scale:	0
Status:	Active
Description:	Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT and SEGMENT. Deprecated in 2018.

TRANSECTID

CC ID: 812965

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

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

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

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

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 1 m in size and situated 2.5 m apart.

SEGLENGTH

CC ID: 371878

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

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

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

COLONYID

CC ID: 371847

Seq. Order:	31
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	0
Status:	Active
Description:	Coral colony identifier. NULL if NO_SURVEY_YN = -1 or NO_COLONY_OBSERVED = -1 or TAXONCODE/SPECIES = 'AAAA'.

COLONYLENGTH

CC ID: 371848

Seq. Order:	31
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Scale:	8
Status:	Active
Description:	Length of juvenile coral colony (< 5 cm). Required if colony observed. Value -9 is a placeholder and represents a missing value.

COLONYWIDTH

CC ID: 371849

Seq. Order:	31
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	28
Scale:	8
Status:	Active
Description:	Width of juvenile coral colony (cm). Value -9 is a placeholder and represents a missing value. No longer measured as of 2018.

MORPH_CODE

CC ID: 371866

Seq. Order:	32
Data Storage Type:	VARCHAR2
Max Length:	5
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for MORPHOLOGY.

MORPHOLOGY

CC ID: 371865

Seq. Order:	33
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Coral morphology type (branching, columnar, encrusting, etc.). Required if colony observed.

TAXONCODE

CC ID: 371886

Seq. Order:	34
Data Storage Type:	NVARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	4-letter code for TAXONNAME. Required. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found (NO_COLONY_OBSERVED = -1). NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1).

SPECIES

CC ID: 812969

Seq. Order:	34
Data Storage Type:	TEXT
Required:	No
Primary Key:	No
Status:	Active
Description:	4-letter code for TAXONNAME. Required. Code AAAA represents a SEGMENT that was surveyed and no individual colonies were found (NO_COLONY_OBSERVED = -1). NULL if TRANSECT was not surveyed (NO_SURVEY_YN = -1).

TAXONNAME

CC ID: 371887

Seq. Order:	35
Data Storage Type:	NVARCHAR2
Max Length:	765
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 or if NO_COLONY_OBSERVED = -1.

RANK

CC ID: 371871

Seq. Order:	36
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database. NULL if TAXONCODE = 'UNKN' or 'CALG'.

PHYLUM

CC ID: 371870

Seq. Order:	37
Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Taxonomic classification: Phylum of observed organism (TAXONNAME).

CLASS

CC ID: 371846

Seq. Order:	38
Data Storage Type:	NVARCHAR2
Max Length:	60
Required:	No
Primary Key:	No
Status:	Active
Description:	Taxonomic classification: Class of observed organism (TAXONNAME).

S_ORDER

CC ID: 371885

Seq. Order:	39
Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Taxonomic classification: Order of observed organism (TAXONNAME).

FAMILY

CC ID: 371854

Seq. Order:	40
Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Taxonomic classification: Family of observed organism (TAXONNAME).

GENUS_CODE

CC ID: 371856

Seq. Order:	41
Data Storage Type:	NVARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	4-letter code for GENUS.

GENUS

CC ID: 371855

Seq. Order:	42
Data Storage Type:	NVARCHAR2
Max Length:	300
Required:	No
Primary Key:	No
Status:	Active
Description:	Taxonomic classification: Genus name of observed organism (TAXONNAME). NULL if TAXONNAME = Unknown Scleractinian or Crustose Coralline Algae.

SCIENTIFIC_NAME

CC ID: 371877

Seq. Order:	43
Data Storage Type:	VARCHAR2
Max Length:	255
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).

APHIAID

CC ID: 371844

Seq. Order:	45
Data Storage Type:	VARCHAR2
Max Length:	20
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.

Catalog Details

Catalog Item ID:	36177
GUID:	gov.noaa.nmfs.inport:36177
Metadata Record Created By:	Troy T Kanemura
Metadata Record Created:	2016-12-31 00:34+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