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

Summary

Abstract

This entity describes the columns in the dataset for coral belt observations (adult)

Description

Coral belt observations (adult)

Entity Information

Entity Type
Data View

Data Attribute / Type Description
ROUNDID
NUMERIC
Unique identifier for ROUND record.
MISSIONID
TEXT
Mission identifier.
REGION
TEXT
Code for REGION_NAME.
REGION_NAME
TEXT
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
TEXT
3-letter code for ISLAND.
ISLAND
TEXT
Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
SITE
TEXT
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
NUMERIC
Latitude in decimal degrees, WGS84, for the given SITE.
LONGITUDE
NUMERIC
Longitude in decimal degrees, WGS84 for the given SITE.
REEF_ZONE_CODE
TEXT
3-letter code for REEF_ZONE.
REEF_ZONE
TEXT
The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon).
HABITAT_CODE
TEXT
3-letter code for HABITAT_TYPE.
HABITAT_TYPE
TEXT
Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE.
SITE_MIN_DEPTH
NUMERIC
Minimum SITE depth (ft).
SITE_MAX_DEPTH
NUMERIC
Maximum SITE depth (ft).
DEPTH_BIN
TEXT
Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m
DEPTH_CODE
TEXT
Single-letter code for DEPTH_BIN (S, M, D).
SITEVISITID
NUMERIC
Unique identifier created each time a SITE is surveyed on a DATE_.
DATE_
DATE
Local date the survey was conducted.
OBS_DAY
NUMERIC
Numeric day the survey was conducted (DATE_).
OBS_MONTH
NUMERIC
Numeric month the survey was conducted (DATE_).
OBS_YEAR
NUMERIC
4-digit year the survey was conducted (DATE_).
NO_SURVEY_YN
NUMERIC
Flag (-1) to indicate transect was not surveyed (Added Sept. 2014).
PHOTOS_TAKEN
NUMERIC
Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (Added in 2018).
DIVER
TEXT
Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1.
METHODNAME
TEXT
References the coral belt survey method.
TRANSECTID
NUMERIC
Unique transect ID number assigned to each transect during the same NCRMP mission (Added in 2018).
TRANSECTNUM
NUMERIC
Used from 2013-2017 as a unique identifier for each transect surveyed within a SITE. In 2018, TRANSECTNUM = 2 indicates a re-survey of the same transect by an additional diver.
SEGMENTID
NUMERIC
Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018).
BELTTRANSECTRUN
NUMERIC
Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT.
TRANSECT
NUMERIC
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
SEGMENT
TEXT
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.
SEGLENGTH
NUMERIC
Segment length (m).
SEGWIDTH
NUMERIC
Segment width (m).
NO_COLONY_OBSERVED
NUMERIC
Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018).
COLONYID
NUMERIC
Coral colony identifier. NULL if NO_SURVEY_YN = -1 or TAXONCODE/SPECIES = 'AAAA'.
COLONYLENGTH
NUMERIC
Length of coral colony (cm). Required. Value -9 is a placeholder and represents a missing value.
MORPH_CODE
TEXT
Code for MORPHOLOGY.
MORPHOLOGY
TEXT
Coral morphology type (branching, columnar, encrusting, etc.). Required as of 2014. Does not apply to TAXONCODE/SPECIES = 'CALG'
FRAGMENT_YN
NUMERIC
Flag (-1) to indicate that the observed coral colony is a fragment and not attached to the substrate. 0 indicates the coral was not a fragment (Added in 2018).
OLDDEAD
NUMERIC
Percentage of older dead coral (0-100%), as opposed to recently dead coral recorded in RECENTDEAD. Required. Value -9 is a placeholder and represents a missing value.
RECENTDEAD
NUMERIC
Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%), as opposed to older dead coral recorded in OLDDEAD. Required. Value -9 is a placeholder and represents a missing value. Deprecated, replaced by RECENTDEAD_1.
RECENTDEAD_1
NUMERIC
Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%), as opposed to older dead coral recorded in OLDDEAD. Required. Value -9 is a placeholder and represents a missing value. Replaces RECENTDEAD.
RECENT_GENERAL_CAUSE_CODE_1
TEXT
Code for RECENT_GENERAL_CAUSE_DESC_1. Replaces RECENT_GENERAL_CAUSE_CODE.
RECENT_GENERAL_CAUSE_DESC_1
TEXT
General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_1. Required if RECENTDEAD_1 is >0.
RECENT_SPECIFIC_CAUSE_CODE_1
TEXT
Code for RECENT_SPECIFIC_CAUSE_DESC_1. Replaces RECENT_SPECIFIC_CAUSE_CODE.
RECENT_SPECIFIC_CAUSE_DESC_1
TEXT
Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_1. Required if RECENTDEAD_1 is >0.
RECENTDEAD_2
NUMERIC
Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral. Only used if more than one cause of coral mortality was observed (RECENTDEAD_1 >0).
RECENT_GENERAL_CAUSE_CODE_2
TEXT
Code for RECENT_GENERAL_CAUSE_DESC_2.
RECENT_GENERAL_CAUSE_DESC_2
TEXT
General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_2. Required if RECENTDEAD_2 is >0.
RECENT_SPECIFIC_CAUSE_CODE_2
TEXT
Code for RECENT_SPECIFIC_CAUSE_DESC_2.
RECENT_SPECIFIC_CAUSE_DESC_2
TEXT
Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_2. Required if RECENTDEAD_2 is >0.
RECENTDEAD_3
NUMERIC
Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral. Only used if more than two causes of coral mortality were observed (RECENTDEAD_1 and RECENTDEAD_2 >0).
RECENT_GENERAL_CAUSE_CODE_3
TEXT
Code for RECENT_GENERAL_CAUSE_DESC_3.
RECENT_GENERAL_CAUSE_DESC_3
TEXT
General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0.
RECENT_SPECIFIC_CAUSE_CODE_3
TEXT
Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0.
RECENT_SPECIFIC_CAUSE_DESC_3
TEXT
Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0.
CONDITION_1
TEXT
Code for CONDITION_1_DESC.
COND
TEXT
Code for COND_DESCRIPTION.
CONDITION_1_DESC
TEXT
Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD.
COND_DESCRIPTION
TEXT
Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD.
EXTENT
NUMERIC
Extent of condition/disease observed on coral colony (1-100). Required if COND is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not.
EXTENT_1
NUMERIC
Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not.
SEVERITY_1
NUMERIC
Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded.
SEVERITY
NUMERIC
Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE, BLP, PTR, or SGA. Value -9 is used as placeholder if SEVERITY was required and not recorded.
CONDITION_2
TEXT
Code for CONDITION_1_DESC.
CONDITION_2_DESC
TEXT
Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD.
EXTENT_2
NUMERIC
Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not.
SEVERITY_2
NUMERIC
Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded.
CONDITION_3
TEXT
Code for CONDITION_1_DESC.
CONDITION_3_DESC
TEXT
Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD.
EXTENT_3
NUMERIC
Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not.
SEVERITY_3
NUMERIC
Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded.
TAXONCODE
TEXT
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
TEXT
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.
SPECIES
TEXT
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).
RANK
TEXT
Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database.
PHYLUM
TEXT
Taxonomic classification: Phylum of observed organism (TAXONNAME).
CLASS
TEXT
Taxonomic classification: Class of observed organism (TAXONNAME).
S_ORDER
TEXT
Taxonomic classification: Order of observed organism (TAXONNAME).
FAMILY
TEXT
Taxonomic classification: Family of observed organism (TAXONNAME).
GENUS_CODE
TEXT
4-letter code for GENUS.
GENUS
TEXT
Taxonomic classification: Genus name of observed organism (TAXONNAME).
SCIENTIFIC_NAME
TEXT
Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If blank, organism not identified to species taxonomic level (see RANK).
APHIAID
TEXT
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, the species does not exist in WoRMS.

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: Adult Coral Belt Observations Data Dictionary
Short Name: Coral_Belt_E_DataDictionary
Status: Completed
Abstract:

This entity describes the columns in the dataset for coral belt observations (adult)

Notes:

Updated Feb 2019 to reflect addition of monument-led surveys 2014 and 2015.

Updated TRANSECT description on June 19 2019 in anticipation of diver calibration data to be collected on transect 2 during HARAMP surveys (legs 2 and 3).

Entity Information

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

Coral belt observations (adult)

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
ROUNDID NUMERIC Unique identifier for ROUND record.
100
MISSIONID TEXT Mission identifier.
100
REGION TEXT Code for REGION_NAME.
100
REGION_NAME TEXT 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 TEXT 3-letter code for ISLAND.
100
ISLAND TEXT Name of island or atoll surveyed in the Pacific Islands region (REGION_NAME).
100
SITE TEXT 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 NUMERIC Latitude in decimal degrees, WGS84, for the given SITE.
100
LONGITUDE NUMERIC Longitude in decimal degrees, WGS84 for the given SITE.
100
REEF_ZONE_CODE TEXT 3-letter code for REEF_ZONE.
100
REEF_ZONE TEXT The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon).
100
HABITAT_CODE TEXT 3-letter code for HABITAT_TYPE.
100
HABITAT_TYPE TEXT Habitat type (e.g., aggregate reef, reef rubble, pavement) for the given SITE.
100
SITE_MIN_DEPTH NUMERIC Minimum SITE depth (ft).
100
SITE_MAX_DEPTH NUMERIC Maximum SITE depth (ft).
100
DEPTH_BIN TEXT Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of transect(s) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m
100
DEPTH_CODE TEXT Single-letter code for DEPTH_BIN (S, M, D).
100
SITEVISITID NUMERIC Unique identifier created each time a SITE is surveyed on a DATE_.
100
DATE_ DATE Local date the survey was conducted.
100
OBS_DAY NUMERIC Numeric day the survey was conducted (DATE_).
100
OBS_MONTH NUMERIC Numeric month the survey was conducted (DATE_).
100
OBS_YEAR NUMERIC 4-digit year the survey was conducted (DATE_).
100
NO_SURVEY_YN NUMERIC Flag (-1) to indicate transect was not surveyed (Added Sept. 2014).
100
PHOTOS_TAKEN NUMERIC Flag (-1) to indicate that photographs were taken at the transect. 0 indicates no photographs were taken (Added in 2018).
100
DIVER TEXT Initials of diver that conducted the survey. NULL if NO_SURVEY_YN = -1.
100
METHODNAME TEXT References the coral belt survey method.
100
TRANSECTID NUMERIC Unique transect ID number assigned to each transect during the same NCRMP mission (Added in 2018).
100
TRANSECTNUM NUMERIC Used from 2013-2017 as a unique identifier for each transect surveyed within a SITE. In 2018, TRANSECTNUM = 2 indicates a re-survey of the same transect by an additional diver.
100
SEGMENTID NUMERIC Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018).
100
BELTTRANSECTRUN NUMERIC Primary key for CORAL_BELT_TRANSECTRUN and unique identifier for TRANSECT.
100
TRANSECT NUMERIC 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
SEGMENT TEXT 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.
100
SEGLENGTH NUMERIC Segment length (m).
100
SEGWIDTH NUMERIC Segment width (m).
100
NO_COLONY_OBSERVED NUMERIC Flag (-1) to indicate that no coral colonies were observed. 0 indicates corals were present (Added in 2018).
100
COLONYID NUMERIC Coral colony identifier. NULL if NO_SURVEY_YN = -1 or TAXONCODE/SPECIES = 'AAAA'.
100
COLONYLENGTH NUMERIC Length of coral colony (cm). Required. Value -9 is a placeholder and represents a missing value.
100
MORPH_CODE TEXT Code for MORPHOLOGY.
100
MORPHOLOGY TEXT Coral morphology type (branching, columnar, encrusting, etc.). Required as of 2014. Does not apply to TAXONCODE/SPECIES = 'CALG'
100
FRAGMENT_YN NUMERIC Flag (-1) to indicate that the observed coral colony is a fragment and not attached to the substrate. 0 indicates the coral was not a fragment (Added in 2018).
100
OLDDEAD NUMERIC Percentage of older dead coral (0-100%), as opposed to recently dead coral recorded in RECENTDEAD. Required. Value -9 is a placeholder and represents a missing value.
100
RECENTDEAD NUMERIC Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%), as opposed to older dead coral recorded in OLDDEAD. Required. Value -9 is a placeholder and represents a missing value. Deprecated, replaced by RECENTDEAD_1.
100
RECENTDEAD_1 NUMERIC Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%), as opposed to older dead coral recorded in OLDDEAD. Required. Value -9 is a placeholder and represents a missing value. Replaces RECENTDEAD.
100
RECENT_GENERAL_CAUSE_CODE_1 TEXT Code for RECENT_GENERAL_CAUSE_DESC_1. Replaces RECENT_GENERAL_CAUSE_CODE.
100
RECENT_GENERAL_CAUSE_DESC_1 TEXT General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_1. Required if RECENTDEAD_1 is >0.
100
RECENT_SPECIFIC_CAUSE_CODE_1 TEXT Code for RECENT_SPECIFIC_CAUSE_DESC_1. Replaces RECENT_SPECIFIC_CAUSE_CODE.
100
RECENT_SPECIFIC_CAUSE_DESC_1 TEXT Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_1. Required if RECENTDEAD_1 is >0.
100
RECENTDEAD_2 NUMERIC Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral. Only used if more than one cause of coral mortality was observed (RECENTDEAD_1 >0).
100
RECENT_GENERAL_CAUSE_CODE_2 TEXT Code for RECENT_GENERAL_CAUSE_DESC_2.
100
RECENT_GENERAL_CAUSE_DESC_2 TEXT General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_2. Required if RECENTDEAD_2 is >0.
100
RECENT_SPECIFIC_CAUSE_CODE_2 TEXT Code for RECENT_SPECIFIC_CAUSE_DESC_2.
100
RECENT_SPECIFIC_CAUSE_DESC_2 TEXT Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_2. Required if RECENTDEAD_2 is >0.
100
RECENTDEAD_3 NUMERIC Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral. Only used if more than two causes of coral mortality were observed (RECENTDEAD_1 and RECENTDEAD_2 >0).
100
RECENT_GENERAL_CAUSE_CODE_3 TEXT Code for RECENT_GENERAL_CAUSE_DESC_3.
100
RECENT_GENERAL_CAUSE_DESC_3 TEXT General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0.
100
RECENT_SPECIFIC_CAUSE_CODE_3 TEXT Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0.
100
RECENT_SPECIFIC_CAUSE_DESC_3 TEXT Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0.
100
CONDITION_1 TEXT Code for CONDITION_1_DESC.
100
COND TEXT Code for COND_DESCRIPTION.
100
CONDITION_1_DESC TEXT Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD.
100
COND_DESCRIPTION TEXT Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD.
100
EXTENT NUMERIC Extent of condition/disease observed on coral colony (1-100). Required if COND is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not.
100
EXTENT_1 NUMERIC Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not.
100
SEVERITY_1 NUMERIC Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded.
100
SEVERITY NUMERIC Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE, BLP, PTR, or SGA. Value -9 is used as placeholder if SEVERITY was required and not recorded.
100
CONDITION_2 TEXT Code for CONDITION_1_DESC.
100
CONDITION_2_DESC TEXT Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD.
100
EXTENT_2 NUMERIC Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not.
100
SEVERITY_2 NUMERIC Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded.
100
CONDITION_3 TEXT Code for CONDITION_1_DESC.
100
CONDITION_3_DESC TEXT Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD.
100
EXTENT_3 NUMERIC Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not.
100
SEVERITY_3 NUMERIC Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded.
100
TAXONCODE TEXT 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 TEXT 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
SPECIES TEXT 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
RANK TEXT Lowest defined rank in taxonomic hierarchy, from the World Registry of Marine Species (WoRMS) database.
100
PHYLUM TEXT Taxonomic classification: Phylum of observed organism (TAXONNAME).
100
CLASS TEXT Taxonomic classification: Class of observed organism (TAXONNAME).
100
S_ORDER TEXT Taxonomic classification: Order of observed organism (TAXONNAME).
100
FAMILY TEXT Taxonomic classification: Family of observed organism (TAXONNAME).
100
GENUS_CODE TEXT 4-letter code for GENUS.
100
GENUS TEXT Taxonomic classification: Genus name of observed organism (TAXONNAME).
100
SCIENTIFIC_NAME TEXT Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). If blank, organism not identified to species taxonomic level (see RANK).
100
APHIAID TEXT 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, the species does not exist in WoRMS.

Attribute Details

ROUNDID

CC ID: 371628
Seq. Order: 1
Data Storage Type: NUMERIC
Max Length: 22
Required: Yes
Primary Key: No
Precision: 28
Scale: 0
Status: Active
Description:

Unique identifier for ROUND record.

MISSIONID

CC ID: 371608
Seq. Order: 2
Data Storage Type: TEXT
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Mission identifier.

REGION

CC ID: 371626
Seq. Order: 3
Data Storage Type: TEXT
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Code for REGION_NAME.

REGION_NAME

CC ID: 371627
Seq. Order: 4
Data Storage Type: TEXT
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: 371604
Seq. Order: 5
Data Storage Type: TEXT
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

3-letter code for ISLAND.

ISLAND

CC ID: 371603
Seq. Order: 6
Data Storage Type: TEXT
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: 371634
Seq. Order: 7
Data Storage Type: TEXT
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: 371605
Seq. Order: 8
Data Storage Type: NUMERIC
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: 371606
Seq. Order: 9
Data Storage Type: NUMERIC
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: 371625
Seq. Order: 10
Data Storage Type: TEXT
Max Length: 3
Required: Yes
Primary Key: No
Status: Active
Description:

3-letter code for REEF_ZONE.

REEF_ZONE

CC ID: 371624
Seq. Order: 11
Data Storage Type: TEXT
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: 371601
Seq. Order: 12
Data Storage Type: TEXT
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

3-letter code for HABITAT_TYPE.

HABITAT_TYPE

CC ID: 371602
Seq. Order: 12
Data Storage Type: TEXT
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: 371637
Seq. Order: 12
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Minimum SITE depth (ft).

SITE_MAX_DEPTH

CC ID: 371636
Seq. Order: 13
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Maximum SITE depth (ft).

DEPTH_BIN

CC ID: 371594
Seq. Order: 14
Data Storage Type: TEXT
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) of a given SITE. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m

DEPTH_CODE

CC ID: 371595
Seq. Order: 14
Data Storage Type: TEXT
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

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

SITEVISITID

CC ID: 371635
Seq. Order: 14
Data Storage Type: NUMERIC
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: 371593
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: 371612
Seq. Order: 16
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Numeric day the survey was conducted (DATE_).

OBS_MONTH

CC ID: 371613
Seq. Order: 17
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Numeric month the survey was conducted (DATE_).

OBS_YEAR

CC ID: 371614
Seq. Order: 18
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

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

NO_SURVEY_YN

CC ID: 371611
Seq. Order: 23
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

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

PHOTOS_TAKEN

CC ID: 989570
Seq. Order: 23
Data Storage Type: NUMERIC
Max Length: 22
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: 371596
Seq. Order: 24
Data Storage Type: TEXT
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: 371607
Seq. Order: 25
Data Storage Type: TEXT
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

References the coral belt survey method.

TRANSECTID

CC ID: 989571
Seq. Order: 25
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unique transect ID number assigned to each transect during the same NCRMP mission (Added in 2018).

TRANSECTNUM

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

Used from 2013-2017 as a unique identifier for each transect surveyed within a SITE. In 2018, TRANSECTNUM = 2 indicates a re-survey of the same transect by an additional diver.

SEGMENTID

CC ID: 989573
Seq. Order: 25
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unique ID number for each segment surveyed during the same NCRMP mission (Added in 2018).

BELTTRANSECTRUN

CC ID: 371587
Seq. Order: 26
Data Storage Type: NUMERIC
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.

TRANSECT

CC ID: 371641
Seq. Order: 26
Data Storage Type: NUMERIC
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
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

SEGMENT

CC ID: 371631
Seq. Order: 27
Data Storage Type: TEXT
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.

SEGLENGTH

CC ID: 371630
Seq. Order: 28
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 28
Scale: 8
Status: Active
Description:

Segment length (m).

SEGWIDTH

CC ID: 371632
Seq. Order: 29
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Segment width (m).

NO_COLONY_OBSERVED

CC ID: 989574
Seq. Order: 29
Data Storage Type: NUMERIC
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: 371589
Seq. Order: 31
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

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

COLONYLENGTH

CC ID: 371590
Seq. Order: 32
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

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

MORPH_CODE

CC ID: 371610
Seq. Order: 33
Data Storage Type: TEXT
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Code for MORPHOLOGY.

MORPHOLOGY

CC ID: 371609
Seq. Order: 34
Data Storage Type: TEXT
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Coral morphology type (branching, columnar, encrusting, etc.). Required as of 2014. Does not apply to TAXONCODE/SPECIES = 'CALG'

FRAGMENT_YN

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

Flag (-1) to indicate that the observed coral colony is a fragment and not attached to the substrate. 0 indicates the coral was not a fragment (Added in 2018).

OLDDEAD

CC ID: 371615
Seq. Order: 36
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Percentage of older dead coral (0-100%), as opposed to recently dead coral recorded in RECENTDEAD. Required. Value -9 is a placeholder and represents a missing value.

RECENTDEAD

CC ID: 371618
Seq. Order: 37
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%), as opposed to older dead coral recorded in OLDDEAD. Required. Value -9 is a placeholder and represents a missing value. Deprecated, replaced by RECENTDEAD_1.

RECENTDEAD_1

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

Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral (0-100%), as opposed to older dead coral recorded in OLDDEAD. Required. Value -9 is a placeholder and represents a missing value. Replaces RECENTDEAD.

RECENT_GENERAL_CAUSE_CODE_1

CC ID: 371620
Seq. Order: 38
Data Storage Type: TEXT
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Code for RECENT_GENERAL_CAUSE_DESC_1. Replaces RECENT_GENERAL_CAUSE_CODE.

RECENT_GENERAL_CAUSE_DESC_1

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

General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_1. Required if RECENTDEAD_1 is >0.

RECENT_SPECIFIC_CAUSE_CODE_1

CC ID: 371622
Seq. Order: 39
Data Storage Type: TEXT
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Code for RECENT_SPECIFIC_CAUSE_DESC_1. Replaces RECENT_SPECIFIC_CAUSE_CODE.

RECENT_SPECIFIC_CAUSE_DESC_1

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

Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_1. Required if RECENTDEAD_1 is >0.

RECENTDEAD_2

CC ID: 371619
Seq. Order: 40
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral. Only used if more than one cause of coral mortality was observed (RECENTDEAD_1 >0).

RECENT_GENERAL_CAUSE_CODE_2

CC ID: 371621
Seq. Order: 41
Data Storage Type: TEXT
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Code for RECENT_GENERAL_CAUSE_DESC_2.

RECENT_GENERAL_CAUSE_DESC_2

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

General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_2. Required if RECENTDEAD_2 is >0.

RECENT_SPECIFIC_CAUSE_CODE_2

CC ID: 371623
Seq. Order: 42
Data Storage Type: TEXT
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Code for RECENT_SPECIFIC_CAUSE_DESC_2.

RECENT_SPECIFIC_CAUSE_DESC_2

CC ID: 810652
Seq. Order: 42
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_2. Required if RECENTDEAD_2 is >0.

RECENTDEAD_3

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

Percentage of recently dead (freshly denuded skeleton not fouled by algae) coral. Only used if more than two causes of coral mortality were observed (RECENTDEAD_1 and RECENTDEAD_2 >0).

RECENT_GENERAL_CAUSE_CODE_3

CC ID: 989577
Seq. Order: 42
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Code for RECENT_GENERAL_CAUSE_DESC_3.

RECENT_GENERAL_CAUSE_DESC_3

CC ID: 989578
Seq. Order: 42
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

General cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0.

RECENT_SPECIFIC_CAUSE_CODE_3

CC ID: 989579
Seq. Order: 42
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0.

RECENT_SPECIFIC_CAUSE_DESC_3

CC ID: 989580
Seq. Order: 42
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Specific cause of recently dead (freshly denuded skeleton not fouled by algae) coral recorded in RECENTDEAD_3. Required if RECENTDEAD_3 is >0.

CONDITION_1

CC ID: 989581
Seq. Order: 42
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

Code for CONDITION_1_DESC.

COND

CC ID: 371591
Seq. Order: 43
Data Storage Type: TEXT
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Code for COND_DESCRIPTION.

CONDITION_1_DESC

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

Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD.

COND_DESCRIPTION

CC ID: 371592
Seq. Order: 44
Data Storage Type: TEXT
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD.

EXTENT

CC ID: 371597
Seq. Order: 44
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Extent of condition/disease observed on coral colony (1-100). Required if COND is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not.

EXTENT_1

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

Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not.

SEVERITY_1

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

Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded.

SEVERITY

CC ID: 371633
Seq. Order: 45
Data Storage Type: NUMERIC
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE, BLP, PTR, or SGA. Value -9 is used as placeholder if SEVERITY was required and not recorded.

CONDITION_2

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

Code for CONDITION_1_DESC.

CONDITION_2_DESC

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

Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD.

EXTENT_2

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

Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not.

SEVERITY_2

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

Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded.

CONDITION_3

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

Code for CONDITION_1_DESC.

CONDITION_3_DESC

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

Condition/disease observed affecting the coral colony (e.g., bleaching, infection, infestation, pigmentation response, growth anomaly, etc.), but which does not cause RECENT DEAD.

EXTENT_3

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

Extent of condition/disease observed on coral colony (1-100). Required if CONDITION_1 is recorded (<> 'NDZ). Value -9 is used as placeholder if COND was recorded and EXTENT was not.

SEVERITY_3

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

Severity of condition/disease observed on coral colony (scale of 1-5 from least to most severe). SEVERITY required only if COND = BLE or BLP. Value -9 is used as placeholder if SEVERITY was required and not recorded.

TAXONCODE

CC ID: 371639
Seq. Order: 46
Data Storage Type: TEXT
Max Length: 150
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: 371640
Seq. Order: 46
Data Storage Type: TEXT
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.

SPECIES

CC ID: 803311
Seq. Order: 46
Data Storage Type: TEXT
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).

RANK

CC ID: 371617
Seq. Order: 47
Data Storage Type: TEXT
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.

PHYLUM

CC ID: 371616
Seq. Order: 48
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic classification: Phylum of observed organism (TAXONNAME).

CLASS

CC ID: 371588
Seq. Order: 49
Data Storage Type: TEXT
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic classification: Class of observed organism (TAXONNAME).

S_ORDER

CC ID: 371638
Seq. Order: 50
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic classification: Order of observed organism (TAXONNAME).

FAMILY

CC ID: 371598
Seq. Order: 51
Data Storage Type: TEXT
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic classification: Family of observed organism (TAXONNAME).

GENUS_CODE

CC ID: 371600
Seq. Order: 52
Data Storage Type: TEXT
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

4-letter code for GENUS.

GENUS

CC ID: 371599
Seq. Order: 53
Data Storage Type: TEXT
Max Length: 300
Required: No
Primary Key: No
Status: Active
Description:

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

SCIENTIFIC_NAME

CC ID: 371629
Seq. Order: 54
Data Storage Type: TEXT
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 blank, organism not identified to species taxonomic level (see RANK).

APHIAID

CC ID: 371586
Seq. Order: 56
Data Storage Type: TEXT
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, the species does not exist in WoRMS.

Catalog Details

Catalog Item ID: 36172
GUID: gov.noaa.nmfs.inport:36172
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2016-12-31 00:31+0000
Metadata Record Last Modified By: Lori H Luers
Metadata Record Last Modified: 2022-10-31 20:18+0000
Metadata Record Published: 2022-10-20
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2020-11-24
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2021-11-24