Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ocean and Climate Change > Benthic, urchin, and fish observation data coll... >

ESD_CarbBudget_Fixed_Belt_DataDictionary_2023

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:68416  |  Updated: March 24, 2025  |  Published / External 
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 YYYY-MM-DD
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_Fixed_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
Change Summary:

Updated Date format in 2023 to follow convention YYYY-MM-DD

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 YYYY-MM-DD
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 YYYY-MM-DD

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: 2025-03-24 22:37+0000
Metadata Record Published: 2025-03-24
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year