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

Summary

Abstract

Raw data that are used to calculate density (abundance per hectare), biomass (kilograms per hectare), bioerosion (kilograms per meters squared per year).

Description

Column definitions for parrotfish belt survey data

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
REGION
VARCHAR2
The name of the region where the carbonate budget assessment was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
REGIONCODE
VARCHAR2
Code for the Pacific Islands region (REGION) surveyed: American Samoa (SAMOA), Pacific Remote Island Areas (PRIA), Mariana Archipelago (MARIAN), main Hawaiian Islands (MHI), Northwestern Hawaiian Islands (NWHI).
YEAR
NUMERIC
4-digit year the survey was conducted.
CRUISE_ID
VARCHAR2
Mission identifier.
LOCATION
VARCHAR2
Name of island or atoll where the sample was collected in the Pacific Islands region (REGION).
LOCATIONCODE
VARCHAR2
3-Letter unique code for LOCATION.
OCC_SITEID
VARCHAR2
An identifier for the fixed NCRMP climate site surveyed. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATIONCODE), and a 3-digit site number.
OCC_SITENAME
VARCHAR2
Descriptive name for the fixed NCRMP climate site (OCC_SITEID) surveyed.
LATITUDE
NUMERIC
Latitude in decimal degrees, WGS84, for the given OCC_SITEID.
LONGITUDE
NUMERIC
Longitude in decimal degrees, WGS84, for the given OCC_SITEID.
LOCALDATE
DATE
Local date the survey was conducted (mm/dd/yyyy).
CB_METHOD
VARCHAR2
Methodology used for collection of benthic data. Indo-Pacific Reef Budget (IPRB): in-water data collected along 5 x 30m transects following the Indo-Pacific ReefBudget approach (Perry et al. 2018).
DIVER
VARCHAR2
Three letter initials of the diver that conducted the survey.
BUDDY
VARCHAR2
Three letter initials of the diver buddy.
REP
VARCHAR2
A letter associated to each replicate (A or B). The replicate letters are assigned to each diver in the pair.
VISIBILITY_M
NUMERIC
Visibility at each transect measured in meters at the beginning of each transect survey.
TRANSECT_LENGTH_M
NUMERIC
Transect length surveyed in meters (30m maximum). Can vary based on ledge or depth related constraints.
TRANSECT_WIDTH_M
NUMERIC
Fixed transect width surveyed in meters (5m total width).
AREA_M2
NUMERIC
Total transect area calculated from mulitplying length and width in meters squared.
TRANSECT
NUMERIC
Transect identifier numbered from 1 through 10 (10 maximum transects per site). Diver assigned to replicate A surveys transects 1 through 5 and the diver assigned to replicate B surveys transects 6 through 10.
BEARING
NUMERIC
Compass bearing in the direction of each transect surveyed. Bearings are recorded at the beginning of each fish belt survey and all run perpendicular to the fixed site.
START_TIME
TIME
Survey start time recorded in local time (hhmm).
START_DEPTH_FT
NUMERIC
Survey start depth in meters. Depths usually within 0-30m.
END_TIME
TIME
Survey end time recorded in local time (hhmm).
END DEPTH_FT
NUMERIC
Survey end depth in meters. Depths usually within 0-30m.
HABITAT_CODE
VARCHAR2
Code for HABITAT_TYPE.
HABITAT_TYPE
VARCHAR2
Description of the habitat type (e.g., Aggregate Patch Reef, Pavement, Spur and Groove, Rock/Boulder).
TAXON_CODE
VARCHAR2
A 4-letter code for TAXONNAME.
TAXON_NAME
VARCHAR2
The genus and species of the observed organism from TAXON_CODE.
SIZE_BIN_0_10_CM
NUMERIC
The raw count of individuals observed between 0 to 10 cm in total length during the survey.
SIZE_BIN_11_20_CM
NUMERIC
The raw count of individuals observed between 11 to 20 cm in total length during the survey.
SIZE_BIN_21_30_CM
NUMERIC
The raw count of individuals observed between 21 to 30 cm in total length during the survey.
SIZE_BIN_31_40_CM
NUMERIC
The raw count of individuals observed between 31 to 40 cm in total length during the survey.
SIZE_BIN_41_50_CM
NUMERIC
The raw count of individuals observed between 41 to 50 cm in total length during the survey.
SIZE_BIN_51_60_CM
NUMERIC
The raw count of individuals observed between 51 to 60 cm in total length during the survey.
PHASE
VARCHAR2
The single letter code for the general life stage phase that the observed organism is in. Organisms are classified into Juvenile (J), Initial (I), and Terminal (T) phases. All observed organisms in the 0 - 10 cm size range are automatically assigned to the juvenile phase.
NOTES
VARCHAR2
Notes and descriptions that were worth recording of the site or organisms surveyed.

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: ESD_CarbBudget_Belt_DataDictionary_2023
Short Name: Fish Belt Data Dictionary
Status: Completed
Abstract:

Raw data that are used to calculate density (abundance per hectare), biomass (kilograms per hectare), bioerosion (kilograms per meters squared per year).

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Column definitions for parrotfish belt survey data

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
REGION VARCHAR2 The name of the region where the carbonate budget assessment was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.
100
REGIONCODE VARCHAR2 Code for the Pacific Islands region (REGION) surveyed: American Samoa (SAMOA), Pacific Remote Island Areas (PRIA), Mariana Archipelago (MARIAN), main Hawaiian Islands (MHI), Northwestern Hawaiian Islands (NWHI).
100
YEAR NUMERIC 4-digit year the survey was conducted.
100
CRUISE_ID VARCHAR2 Mission identifier.
100
LOCATION VARCHAR2 Name of island or atoll where the sample was collected in the Pacific Islands region (REGION).
100
LOCATIONCODE VARCHAR2 3-Letter unique code for LOCATION.
100
OCC_SITEID VARCHAR2 An identifier for the fixed NCRMP climate site surveyed. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATIONCODE), and a 3-digit site number.
100
OCC_SITENAME VARCHAR2 Descriptive name for the fixed NCRMP climate site (OCC_SITEID) surveyed.
100
LATITUDE NUMERIC Latitude in decimal degrees, WGS84, for the given OCC_SITEID.
100
LONGITUDE NUMERIC Longitude in decimal degrees, WGS84, for the given OCC_SITEID.
100
LOCALDATE DATE Local date the survey was conducted (mm/dd/yyyy).
100
CB_METHOD VARCHAR2 Methodology used for collection of benthic data. Indo-Pacific Reef Budget (IPRB): in-water data collected along 5 x 30m transects following the Indo-Pacific ReefBudget approach (Perry et al. 2018).
100
DIVER VARCHAR2 Three letter initials of the diver that conducted the survey.
100
BUDDY VARCHAR2 Three letter initials of the diver buddy.
100
REP VARCHAR2 A letter associated to each replicate (A or B). The replicate letters are assigned to each diver in the pair.
100
VISIBILITY_M NUMERIC Visibility at each transect measured in meters at the beginning of each transect survey.
100
TRANSECT_LENGTH_M NUMERIC Transect length surveyed in meters (30m maximum). Can vary based on ledge or depth related constraints.
100
TRANSECT_WIDTH_M NUMERIC Fixed transect width surveyed in meters (5m total width).
100
AREA_M2 NUMERIC Total transect area calculated from mulitplying length and width in meters squared.
100
TRANSECT NUMERIC Transect identifier numbered from 1 through 10 (10 maximum transects per site). Diver assigned to replicate A surveys transects 1 through 5 and the diver assigned to replicate B surveys transects 6 through 10.
100
BEARING NUMERIC Compass bearing in the direction of each transect surveyed. Bearings are recorded at the beginning of each fish belt survey and all run perpendicular to the fixed site.
100
START_TIME TIME Survey start time recorded in local time (hhmm).
100
START_DEPTH_FT NUMERIC Survey start depth in meters. Depths usually within 0-30m.
100
END_TIME TIME Survey end time recorded in local time (hhmm).
100
END DEPTH_FT NUMERIC Survey end depth in meters. Depths usually within 0-30m.
100
HABITAT_CODE VARCHAR2 Code for HABITAT_TYPE.
100
HABITAT_TYPE VARCHAR2 Description of the habitat type (e.g., Aggregate Patch Reef, Pavement, Spur and Groove, Rock/Boulder).
100
TAXON_CODE VARCHAR2 A 4-letter code for TAXONNAME.
100
TAXON_NAME VARCHAR2 The genus and species of the observed organism from TAXON_CODE.
100
SIZE_BIN_0_10_CM NUMERIC The raw count of individuals observed between 0 to 10 cm in total length during the survey.
100
SIZE_BIN_11_20_CM NUMERIC The raw count of individuals observed between 11 to 20 cm in total length during the survey.
100
SIZE_BIN_21_30_CM NUMERIC The raw count of individuals observed between 21 to 30 cm in total length during the survey.
100
SIZE_BIN_31_40_CM NUMERIC The raw count of individuals observed between 31 to 40 cm in total length during the survey.
100
SIZE_BIN_41_50_CM NUMERIC The raw count of individuals observed between 41 to 50 cm in total length during the survey.
100
SIZE_BIN_51_60_CM NUMERIC The raw count of individuals observed between 51 to 60 cm in total length during the survey.
100
PHASE VARCHAR2 The single letter code for the general life stage phase that the observed organism is in. Organisms are classified into Juvenile (J), Initial (I), and Terminal (T) phases. All observed organisms in the 0 - 10 cm size range are automatically assigned to the juvenile phase.
100
NOTES VARCHAR2 Notes and descriptions that were worth recording of the site or organisms surveyed.

Attribute Details

REGION

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

The name of the region where the carbonate budget assessment was conducted in the Pacific Islands region: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands.

REGIONCODE

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

Code for the Pacific Islands region (REGION) surveyed: American Samoa (SAMOA), Pacific Remote Island Areas (PRIA), Mariana Archipelago (MARIAN), main Hawaiian Islands (MHI), Northwestern Hawaiian Islands (NWHI).

YEAR

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

4-digit year the survey was conducted.

CRUISE_ID

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

Mission identifier.

LOCATION

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

Name of island or atoll where the sample was collected in the Pacific Islands region (REGION).

LOCATIONCODE

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

3-Letter unique code for LOCATION.

OCC_SITEID

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

An identifier for the fixed NCRMP climate site surveyed. An OCC_SITEID is a 3-dimensional identifier that describes a location (LATITUDE and LONGITUDE) and depth of a fixed climate site and includes "OCC" prefix, a 3-letter location code (derived from LOCATIONCODE), and a 3-digit site number.

OCC_SITENAME

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

Descriptive name for the fixed NCRMP climate site (OCC_SITEID) surveyed.

LATITUDE

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

Latitude in decimal degrees, WGS84, for the given OCC_SITEID.

LONGITUDE

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

Longitude in decimal degrees, WGS84, for the given OCC_SITEID.

LOCALDATE

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

Local date the survey was conducted (mm/dd/yyyy).

CB_METHOD

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

Methodology used for collection of benthic data. Indo-Pacific Reef Budget (IPRB): in-water data collected along 5 x 30m transects following the Indo-Pacific ReefBudget approach (Perry et al. 2018).

DIVER

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

Three letter initials of the diver that conducted the survey.

BUDDY

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

Three letter initials of the diver buddy.

REP

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

A letter associated to each replicate (A or B). The replicate letters are assigned to each diver in the pair.

VISIBILITY_M

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

Visibility at each transect measured in meters at the beginning of each transect survey.

TRANSECT_LENGTH_M

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

Transect length surveyed in meters (30m maximum). Can vary based on ledge or depth related constraints.

TRANSECT_WIDTH_M

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

Fixed transect width surveyed in meters (5m total width).

AREA_M2

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

Total transect area calculated from mulitplying length and width in meters squared.

TRANSECT

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

Transect identifier numbered from 1 through 10 (10 maximum transects per site). Diver assigned to replicate A surveys transects 1 through 5 and the diver assigned to replicate B surveys transects 6 through 10.

BEARING

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

Compass bearing in the direction of each transect surveyed. Bearings are recorded at the beginning of each fish belt survey and all run perpendicular to the fixed site.

START_TIME

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

Survey start time recorded in local time (hhmm).

START_DEPTH_FT

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

Survey start depth in meters. Depths usually within 0-30m.

END_TIME

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

Survey end time recorded in local time (hhmm).

END DEPTH_FT

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

Survey end depth in meters. Depths usually within 0-30m.

HABITAT_CODE

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

Code for HABITAT_TYPE.

HABITAT_TYPE

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

Description of the habitat type (e.g., Aggregate Patch Reef, Pavement, Spur and Groove, Rock/Boulder).

TAXON_CODE

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

A 4-letter code for TAXONNAME.

TAXON_NAME

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

The genus and species of the observed organism from TAXON_CODE.

SIZE_BIN_0_10_CM

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

The raw count of individuals observed between 0 to 10 cm in total length during the survey.

SIZE_BIN_11_20_CM

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

The raw count of individuals observed between 11 to 20 cm in total length during the survey.

SIZE_BIN_21_30_CM

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

The raw count of individuals observed between 21 to 30 cm in total length during the survey.

SIZE_BIN_31_40_CM

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

The raw count of individuals observed between 31 to 40 cm in total length during the survey.

SIZE_BIN_41_50_CM

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

The raw count of individuals observed between 41 to 50 cm in total length during the survey.

SIZE_BIN_51_60_CM

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

The raw count of individuals observed between 51 to 60 cm in total length during the survey.

PHASE

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

The single letter code for the general life stage phase that the observed organism is in. Organisms are classified into Juvenile (J), Initial (I), and Terminal (T) phases. All observed organisms in the 0 - 10 cm size range are automatically assigned to the juvenile phase.

NOTES

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

Notes and descriptions that were worth recording of the site or organisms surveyed.

Catalog Details

Catalog Item ID: 68416
GUID: gov.noaa.nmfs.inport:68416
Metadata Record Created By: Lori H Luers
Metadata Record Created: 2022-11-15 02:55+0000
Metadata Record Last Modified By: Lori H Luers
Metadata Record Last Modified: 2023-10-04 21:26+0000
Metadata Record Published: 2023-10-04
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year