Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ocean and Climate Change > Benthic, urchin, and fish observation data coll... >

ESD_CarbBudget_Benthic_DataDictionary_2023

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:70200 | Updated: March 24, 2025 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Description

Meta-analysis data dictionary

Entity Type
Spreadsheet

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.
DEPTH_M NUMERIC	Depth of survey site, in meters.
LOCALDATE DATE	Local date the survey was conducted in YYYY-MM-DD format.
CB_METHOD VARCHAR2	Methodology used for collection of benthic data. Indo-Pacific Reef Budget (IPRB): in-water data collected along 6 x 10m transects following the Indo-Pacific ReefBudget approach (Perry et al. 2018). Chords: In-water data collected along 6 x 8-10m transects located within the 12m diameter circular footprint covered by Structure-from-Motion imagery. Structure-from-Motion (SFM): data extracted from fixed site Structure-from-Motion models along 6 x 8-10m virtual transects.
CB_TRANSECTID VARCHAR2	An identifier for the transect surveyed, differentiated by methodology (CB_METHOD). IPRB: A1, A2, A3, B1, B2, B3; Chords and SFM: A, B, C, D, E, F.
OCC_SITEID_TRANSECT VARCHAR2	An identifier for the site (OCC_SITEID) and transect (CB_TRANSECTID) surveyed.
TRANSECT_PLANAR_LENGTH_M NUMERIC	Total planar length of transect surveyed (CB_TRANSECTID), in meters.
SUBSTRATE_CLASS VARCHAR2	Category classication for the benthic substrate component (SUBSTRATE_NAME) observed directly beneath the transect line: hard coral (CORAL), crustose coralline algae (CCA), macroalgae (MA), turf (TURF), hard carbonate substrate (CARB), hard non-carbonate substrate (RCK), sand (SAND), or other (OTHER).
SUBSTRATE_NAME VARCHAR2	Name for the benthic substrate component observed directly beneath the transect line. Identified to genus or species for hard corals. Identified to functional group for macroalgae (including Halimedia sp. and Peyssonnelia sp.), crustose coralline algae (CCA), turf algae, cyanobacteria, invertibrates, soft coral, seagrass, sponges, zooathids. Identified to type of substrate for abiotic observations (hard carbonate substrate, hard non-carbonate substrate, dead coral, rubble, or sand).
SUBSTRATE_CODE VARCHAR2	Unique code for SUBSTRATE_NAME.
MORPHOLOGY VARCHAR2	Observed morphology for hard corals: branching, branching - fast growth (Acropora sp. only), branching - slow growth (Acropora sp. only), columnar, encrusting mounding, foliose, free-living, laminar columnar, mounding, plating, or table. No morphology is specified for non-coral observations.
MORPHOLOGYCODE VARCHAR2	Unique code for MORPHOLOGY.
SUBSTRATE_COVER_CM NUMERIC	Surface distance covered by the observed benthic component (SUBSTRATE_NAME) directly below the transect tape, in centimeters.

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.

DEPTH_M
NUMERIC

Depth of survey site, in meters.

LOCALDATE
DATE

Local date the survey was conducted in YYYY-MM-DD format.

CB_METHOD
VARCHAR2

Methodology used for collection of benthic data. Indo-Pacific Reef Budget (IPRB): in-water data collected along 6 x 10m transects following the Indo-Pacific ReefBudget approach (Perry et al. 2018). Chords: In-water data collected along 6 x 8-10m transects located within the 12m diameter circular footprint covered by Structure-from-Motion imagery. Structure-from-Motion (SFM): data extracted from fixed site Structure-from-Motion models along 6 x 8-10m virtual transects.

CB_TRANSECTID
VARCHAR2

An identifier for the transect surveyed, differentiated by methodology (CB_METHOD). IPRB: A1, A2, A3, B1, B2, B3; Chords and SFM: A, B, C, D, E, F.

OCC_SITEID_TRANSECT
VARCHAR2

An identifier for the site (OCC_SITEID) and transect (CB_TRANSECTID) surveyed.

TRANSECT_PLANAR_LENGTH_M
NUMERIC

Total planar length of transect surveyed (CB_TRANSECTID), in meters.

SUBSTRATE_CLASS
VARCHAR2

Category classication for the benthic substrate component (SUBSTRATE_NAME) observed directly beneath the transect line: hard coral (CORAL), crustose coralline algae (CCA), macroalgae (MA), turf (TURF), hard carbonate substrate (CARB), hard non-carbonate substrate (RCK), sand (SAND), or other (OTHER).

SUBSTRATE_NAME
VARCHAR2

Name for the benthic substrate component observed directly beneath the transect line. Identified to genus or species for hard corals. Identified to functional group for macroalgae (including Halimedia sp. and Peyssonnelia sp.), crustose coralline algae (CCA), turf algae, cyanobacteria, invertibrates, soft coral, seagrass, sponges, zooathids. Identified to type of substrate for abiotic observations (hard carbonate substrate, hard non-carbonate substrate, dead coral, rubble, or sand).

SUBSTRATE_CODE
VARCHAR2

Unique code for SUBSTRATE_NAME.

MORPHOLOGY
VARCHAR2

Observed morphology for hard corals: branching, branching - fast growth (Acropora sp. only), branching - slow growth (Acropora sp. only), columnar, encrusting mounding, foliose, free-living, laminar columnar, mounding, plating, or table. No morphology is specified for non-coral observations.

MORPHOLOGYCODE
VARCHAR2

Unique code for MORPHOLOGY.

SUBSTRATE_COVER_CM
NUMERIC

Surface distance covered by the observed benthic component (SUBSTRATE_NAME) directly below the transect tape, in centimeters.

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:	ESD_CarbBudget_Benthic_DataDictionary_2023
Short Name:	CarbBudget Benthic DataDictionary

Entity Type:	Spreadsheet
Active Version?:	Yes
Description:	Meta-analysis data dictionary
Change Summary:	Updated Date format in 2023 to follow convention YYYY-MM-DD

Attribute Summary

	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	DEPTH_M	NUMERIC	Depth of survey site, in meters.
100	LOCALDATE	DATE	Local date the survey was conducted in YYYY-MM-DD format.
100	CB_METHOD	VARCHAR2	Methodology used for collection of benthic data. Indo-Pacific Reef Budget (IPRB): in-water data collected along 6 x 10m transects following the Indo-Pacific ReefBudget approach (Perry et al. 2018). Chords: In-water data collected along 6 x 8-10m transects located within the 12m diameter circular footprint covered by Structure-from-Motion imagery. Structure-from-Motion (SFM): data extracted from fixed site Structure-from-Motion models along 6 x 8-10m virtual transects.
100	CB_TRANSECTID	VARCHAR2	An identifier for the transect surveyed, differentiated by methodology (CB_METHOD). IPRB: A1, A2, A3, B1, B2, B3; Chords and SFM: A, B, C, D, E, F.
100	OCC_SITEID_TRANSECT	VARCHAR2	An identifier for the site (OCC_SITEID) and transect (CB_TRANSECTID) surveyed.
100	TRANSECT_PLANAR_LENGTH_M	NUMERIC	Total planar length of transect surveyed (CB_TRANSECTID), in meters.
100	SUBSTRATE_CLASS	VARCHAR2	Category classication for the benthic substrate component (SUBSTRATE_NAME) observed directly beneath the transect line: hard coral (CORAL), crustose coralline algae (CCA), macroalgae (MA), turf (TURF), hard carbonate substrate (CARB), hard non-carbonate substrate (RCK), sand (SAND), or other (OTHER).
100	SUBSTRATE_NAME	VARCHAR2	Name for the benthic substrate component observed directly beneath the transect line. Identified to genus or species for hard corals. Identified to functional group for macroalgae (including Halimedia sp. and Peyssonnelia sp.), crustose coralline algae (CCA), turf algae, cyanobacteria, invertibrates, soft coral, seagrass, sponges, zooathids. Identified to type of substrate for abiotic observations (hard carbonate substrate, hard non-carbonate substrate, dead coral, rubble, or sand).
100	SUBSTRATE_CODE	VARCHAR2	Unique code for SUBSTRATE_NAME.
100	MORPHOLOGY	VARCHAR2	Observed morphology for hard corals: branching, branching - fast growth (Acropora sp. only), branching - slow growth (Acropora sp. only), columnar, encrusting mounding, foliose, free-living, laminar columnar, mounding, plating, or table. No morphology is specified for non-coral observations.
100	MORPHOLOGYCODE	VARCHAR2	Unique code for MORPHOLOGY.
100	SUBSTRATE_COVER_CM	NUMERIC	Surface distance covered by the observed benthic component (SUBSTRATE_NAME) directly below the transect tape, in centimeters.

Name

Type

Description

100

REGION

VARCHAR2

100

REGIONCODE

VARCHAR2

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

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

DEPTH_M

NUMERIC

Depth of survey site, in meters.

100

LOCALDATE

DATE

Local date the survey was conducted in YYYY-MM-DD format.

100

CB_METHOD

VARCHAR2

100

CB_TRANSECTID

VARCHAR2

An identifier for the transect surveyed, differentiated by methodology (CB_METHOD). IPRB: A1, A2, A3, B1, B2, B3; Chords and SFM: A, B, C, D, E, F.

100

OCC_SITEID_TRANSECT

VARCHAR2

An identifier for the site (OCC_SITEID) and transect (CB_TRANSECTID) surveyed.

100

TRANSECT_PLANAR_LENGTH_M

NUMERIC

Total planar length of transect surveyed (CB_TRANSECTID), in meters.

100

SUBSTRATE_CLASS

VARCHAR2

100

SUBSTRATE_NAME

VARCHAR2

100

SUBSTRATE_CODE

VARCHAR2

Unique code for SUBSTRATE_NAME.

100

MORPHOLOGY

VARCHAR2

100

MORPHOLOGYCODE

VARCHAR2

Unique code for MORPHOLOGY.

100

SUBSTRATE_COVER_CM

NUMERIC

Surface distance covered by the observed benthic component (SUBSTRATE_NAME) directly below the transect tape, in centimeters.

Attribute Details

REGION

CC ID: 1257867

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

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

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

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

LOCATION

CC ID: 1257871

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

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

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

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

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

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.

DEPTH_M

CC ID: 1257881

Seq. Order:	13
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Depth of survey site, in meters.

LOCALDATE

CC ID: 1257877

Seq. Order:	14
Data Storage Type:	DATE
Required:	No
Primary Key:	No
Status:	Active
Description:	Local date the survey was conducted in YYYY-MM-DD format.

CB_METHOD

CC ID: 1257878

Seq. Order:	15
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 6 x 10m transects following the Indo-Pacific ReefBudget approach (Perry et al. 2018). Chords: In-water data collected along 6 x 8-10m transects located within the 12m diameter circular footprint covered by Structure-from-Motion imagery. Structure-from-Motion (SFM): data extracted from fixed site Structure-from-Motion models along 6 x 8-10m virtual transects.

CB_TRANSECTID

CC ID: 1257879

Seq. Order:	16
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	An identifier for the transect surveyed, differentiated by methodology (CB_METHOD). IPRB: A1, A2, A3, B1, B2, B3; Chords and SFM: A, B, C, D, E, F.

OCC_SITEID_TRANSECT

CC ID: 1257880

Seq. Order:	17
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	An identifier for the site (OCC_SITEID) and transect (CB_TRANSECTID) surveyed.

TRANSECT_PLANAR_LENGTH_M

CC ID: 1257897

Seq. Order:	18
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Total planar length of transect surveyed (CB_TRANSECTID), in meters.

SUBSTRATE_CLASS

CC ID: 1257898

Seq. Order:	19
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Category classication for the benthic substrate component (SUBSTRATE_NAME) observed directly beneath the transect line: hard coral (CORAL), crustose coralline algae (CCA), macroalgae (MA), turf (TURF), hard carbonate substrate (CARB), hard non-carbonate substrate (RCK), sand (SAND), or other (OTHER).

SUBSTRATE_NAME

CC ID: 1257899

Seq. Order:	20
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Name for the benthic substrate component observed directly beneath the transect line. Identified to genus or species for hard corals. Identified to functional group for macroalgae (including Halimedia sp. and Peyssonnelia sp.), crustose coralline algae (CCA), turf algae, cyanobacteria, invertibrates, soft coral, seagrass, sponges, zooathids. Identified to type of substrate for abiotic observations (hard carbonate substrate, hard non-carbonate substrate, dead coral, rubble, or sand).

SUBSTRATE_CODE

CC ID: 1257900

Seq. Order:	21
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique code for SUBSTRATE_NAME.

MORPHOLOGY

CC ID: 1257901

Seq. Order:	22
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Observed morphology for hard corals: branching, branching - fast growth (Acropora sp. only), branching - slow growth (Acropora sp. only), columnar, encrusting mounding, foliose, free-living, laminar columnar, mounding, plating, or table. No morphology is specified for non-coral observations.

MORPHOLOGYCODE

CC ID: 1257902

Seq. Order:	23
Data Storage Type:	VARCHAR2
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique code for MORPHOLOGY.

SUBSTRATE_COVER_CM

CC ID: 1257903

Seq. Order:	24
Data Storage Type:	NUMERIC
Required:	No
Primary Key:	No
Status:	Active
Description:	Surface distance covered by the observed benthic component (SUBSTRATE_NAME) directly below the transect tape, in centimeters.

Catalog Item ID:	70200
GUID:	gov.noaa.nmfs.inport:70200
Metadata Record Created By:	Hannah C Barkley
Metadata Record Created:	2023-06-27 18:59+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

ESD_CarbBudget_Benthic_DataDictionary_2023

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

REGION

REGIONCODE

YEAR

CRUISE_ID

LOCATION

LOCATIONCODE

OCC_SITEID

OCC_SITENAME

LATITUDE

LONGITUDE

DEPTH_M

LOCALDATE

CB_METHOD

CB_TRANSECTID

OCC_SITEID_TRANSECT

TRANSECT_PLANAR_LENGTH_M

SUBSTRATE_CLASS

SUBSTRATE_NAME

SUBSTRATE_CODE

MORPHOLOGY

MORPHOLOGYCODE

SUBSTRATE_COVER_CM

Catalog Details