Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ecosystem Monitoring and Assessment > Benthic Missions > Benthic Surveys in Faga'alu, American Samoa: co... >

View: V0_CORAL_OBS_F

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Coral belt observations (juvenile)

Description

Coral belt observations (juvenile)

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

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

No Child Items for this record.

No contact information is available for this record.

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

Title:	View: 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 Type:	Data View
Active Version?:	Yes
Schema Name:	GISDAT
Description:	Coral belt observations (juvenile)

Attribute Summary

	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

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

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

MISSIONID

CC ID: 1065146

Seq. Order:	2
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Mission Identifier.

REGION

CC ID: 1065147

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Seq. Order:	18
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Minimum SITE depth (ft).

MINDEPTH

CC ID: 1065163

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

Seq. Order:	20
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Maximum SITE depth (ft).

MAXDEPTH

CC ID: 1065165

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

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

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

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

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

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

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

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

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

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

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

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

Seq. Order:	33
Data Storage Type:	NVARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	References the coral belt survey method.

TRANSECT

CC ID: 1065178

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

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

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

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

Seq. Order:	38
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Segment length (m).

SEGWIDTH

CC ID: 1065183

Seq. Order:	39
Data Storage Type:	NUMBER
Required:	No
Primary Key:	No
Status:	Active
Description:	Segment width (m), usually 1 m.

TRANWIDTH

CC ID: 1065184

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Seq. Order:	61
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	General observation comments
Allowed Values:	No domain defined.

Catalog Item ID:	51108
GUID:	gov.noaa.nmfs.inport:51108
Metadata Record Created By:	Annette M DesRochers
Metadata Record Created:	2018-01-08 15:00+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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ROUNDID

MISSIONID

REGION

REGION_NAME

ISLAND

ISLANDCODE

SECTOR

SUB_ISLAND

SITE

LATITUDE

LONGITUDE

REEF_ZONE_CODE

REEF_ZONE

HABITAT_CODE

HABITAT_TYPE

DEPTH_BIN

DEPTH_CODE

SITE_MIN_DEPTH

MINDEPTH

SITE_MAX_DEPTH

MAXDEPTH

EXCLUDE_FLAG

NO_SURVEY_YN

SITEVISITID

DATE_

OBS_DAY

OBS_MONTH

OBS_YEAR

PHOTOS_TAKEN

DIVER

METHODNAME

BELTTRANSECTRUN

TRANSECTID

TRANSECT

TRANSECTNUM

SEGMENTID

SEGMENT

SEGLENGTH

SEGWIDTH

TRANWIDTH

TRANLENGTH

NO_COLONY_OBSERVED

COLONYID

SPECIES

COLONYLENGTH

COLONYWIDTH

MORPH_CODE

MORPHOLOGY

TAXONCODE

TAXONNAME

RANK

CLASS

S_ORDER

FAMILY

GENUS_CODE

GENUS

SCIENTIFIC_NAME

APHIAID

CORAL_CORISID

COMMENTS

Catalog Details