Slide Menu
Jump to Section...
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_SPC_DataDictionary_2023

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

Item Identification

Title: ESD_CarbBudget_SPC_DataDictionary_2023
Short Name: CarbBudget SPC DataDictionary
Status: Completed
Abstract:

Data dictionary for fish SPC dataset

Entity Information

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

Column definitions for fish SPC dataset.

Depending on the team that conducted the survey, benthic data may or may not be included in this dataset; null values may occur for columns:

HARD_CORAL

MA

CCA

SAND

OTHER

MIN_DEPTH

MAX_DEPTH

SUBSTRATE

MAX_HEIGHT

URCHIN_DACOR

BORING_URCHIN_DACOR
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
 REGION_CODE 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 NUMBER 4-digit year the survey was conducted.
100
 CRUISE_ID VARCHAR2 Mission Identifier.
100
 LOCATION NVARCHAR2 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
 REA_SITEID NVARCHAR2 The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code with a 2-4 digit site number.
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 NUMBER Latitude in decimal degrees, WGS84, for the given REA_SITEID as recorded by divers on the datasheets.
100
 LONGITUDE NUMBER Longitude in decimal degrees, WGS84, for the given REA_SITEID as recorded by divers on the datasheets.
100
 LOCALDATE DATE Local date the survey was conducted as YYYY-MM-DD
100
 CB_METHOD NVARCHAR2 Methodology used for collection of fish 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). Stationary Point Count (nSPC): In-water data collected along two 15m diameter cylinders within a 30m transect.
100
 OBJECTID NUMBER Unique identifier for fish REA observations.
100
 ROUNDID NUMBER Unique Identifier for ROUND record.
100
 REEF_ZONE NVARCHAR2 The zone for the given REA_SITEID (Forereef, Backreef, Protected Slope, Lagoon).
100
 DEPTH_BIN NVARCHAR2 Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m.
100
 SITEVISITID NUMBER Unique identifier created each time a REA_SITEID is surveyed on a LOCALDATE.
100
 DIVER NVARCHAR2 Initials of diver that conducted the survey.
100
 REPLICATEID NUMBER Unique identifier for the replicate sample within a Fish REA survey.
100
 REP NVARCHAR2 Letter associated to replicate (A, B, C, or D).
100
 PHOTOGRAPHER NUMBER Flag to indicate photographer of benthic photos. Two divers simultaneously conduct a survey at a site (indicated by the initials of the observer in the DIVER field), only one of which captures the benthic photos. Value -1 indicates the photographer.
100
 TRAINING_YN NUMBER Flag to signify whether replicate was for training purposes. Value -1 indicates the replicate was for training.
100
 DEPTH NUMBER Depth of survey area in meters. Depths usually within 0-30 m.
100
 SURVEY_RADIUS_M NUMBER Radius of survey area in meters, usually 7.5 m (15-m SPC survey 'cylinder').
100
 HARD_CORAL NUMBER Hard coral cover (0-100%). Sum of benthic composition categories equals 100.
100
 MA NUMBER Macroalgae cover (0-100%). Sum of benthic composition categories equals 100.
100
 CCA NUMBER Crustose coralline algae (CCA) cover (0-100%). Sum of benthic composition categories equals 100.
100
 SAND NUMBER Sand cover (0-100%). Sum of benthic composition categories equals 100.
100
 OTHER NUMBER Other benthic composition value (0-100%). Sum of benthic composition categories equals 100. Turf algae, tunicates, zoanthids, corallimorphs, clams, cyanobacteria, soft coral, and sponges are pooled into this category as of 2016 surveys.
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
 CURRENT_STRENGTH VARCHAR2 Current Strength (None, Slight, Moderate, High).
100
 VISIBILITY NUMBER Visibility measured in meters.
100
 MIN_DEPTH NUMBER Minimum depth of the diver's survey cylinder in meters.
100
 MAX_DEPTH NUMBER Maximum depth of the diver's survey cylinder in meters.
100
 SUBSTRATE_HEIGHT_0 NUMBER Proportion of survey area between 0-20 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100.
100
 SUBSTRATE_HEIGHT_20 NUMBER Proportion of survey area between 20-50 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100.
100
 SUBSTRATE_HEIGHT_50 NUMBER Proportion of survey area between 50-100 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100.
100
 SUBSTRATE_HEIGHT_100 NUMBER Proportion of survey area between 100-150 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100.
100
 SUBSTRATE_HEIGHT_150 NUMBER Proportion of survey area over 150 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100.
100
 MAX_HEIGHT NUMBER Highest elevation point in SPC cylinder measured in meters.
100
 URCHIN_DACOR VARCHAR2 Free urchin abundance, estimated by DACOR, an abundance code based on visual estimation (Dominant, Abundant, Common, Occasional, and Rare).
100
 BORING_URCHIN_DACOR VARCHAR2 Boring urchin abundance, estimated by DACOR, an abundance code based on visual estimation (Dominant, Abundant, Common, Occasional, and Rare).
100
 TAXON_CODE NVARCHAR2 4-letter code for TAXON_NAME. Required.
100
 TAXON_NAME NVARCHAR2 Scientific name of observed organism to the finest taxonomic resolution that divers can identify a fish to, usually to species (see RANK). Required.
100
 COMMONNAME NVARCHAR2 Common name (from FishBase).
100
 COMMONFAMILYALL NVARCHAR2 Common name of all families.
100
 FAMILY NVARCHAR2 Taxonomic classification: Family of observed organism (TAXON_NAME).
100
 SCIENTIFIC_NAME VARCHAR2 Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXON_NAME). If NULL, organism not identified to species taxonomic level (see RANK).
100
 RANK VARCHAR2 Lowest defined rank in taxonomic hierarchy.
100
 TROPHIC NVARCHAR2 Trophic level: APEX (apex predator), Cor (corallivore), H (herbivore), MI (mobile invertivore), Om (Omnivore), Par (parasite), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), X (if unidentified fish), Z (zooplantivore).
100
 TROPHIC_MONREP NVARCHAR2 Trophic level scheme used (Primary Consumer, Secondary Consumer, Planktivore, Piscivore).
100
 LW_A NUMBER Parameter "a" used in length-weight calculations.
100
 LW_B NUMBER Parameter "b" used in length-weight calculations.
100
 LMAX NUMBER Maximum length of the fish published in literature.
100
 LENGTH_CONVERSION_FACTOR NUMBER Factor to convert length as TOTAL LENGTH to get it to right form (standard [SL], fork [FL], or total length [TL]) for available length weight A and B parameters for this species
100
 COUNT NUMBER Number of fish observed during survey.
100
 SIZE_ NUMBER Total length of fish, measured from the tip of the snout to the tip of the longer lobe of the caudal fin, reported in centimeters. Total length for rays (Myliobatidae) is measured from pectoral fin tip to pectoral fin tip.
100
 OBS_TYPE VARCHAR2 Code for OBS_DESC.
100
 OBS_DESC VARCHAR2 The type of observation made during the fish survey (Instantaneous, non-instantaneous, after 5 minutes, after 10 minutes, presence). See the Reef Fish Survey Protocol for an explanation of the observation types.

Attribute Details

REGION

CC ID: 1192525
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 30
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.

REGION_CODE

CC ID: 1268716
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 30
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: 1192520
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

4-digit year the survey was conducted.

CRUISE_ID

CC ID: 1192516
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Mission Identifier.

LOCATION

CC ID: 1192504
Seq. Order: 5
Data Storage Type: NVARCHAR2
Max Length: 150
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: 1268722
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

3-Letter unique code for LOCATION.

REA_SITEID

CC ID: 1192531
Seq. Order: 7
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

The code for the site surveyed at the island or atoll (ISLAND). Combines a 3-letter island code with a 2-4 digit site number.

OCC_SITEID

CC ID: 1268300
Seq. Order: 8
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: 1268301
Seq. Order: 9
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: 1192505
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Latitude in decimal degrees, WGS84, for the given REA_SITEID as recorded by divers on the datasheets.

LONGITUDE

CC ID: 1192508
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Longitude in decimal degrees, WGS84, for the given REA_SITEID as recorded by divers on the datasheets.

LOCALDATE

CC ID: 1192496
Seq. Order: 12
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Local date the survey was conducted as YYYY-MM-DD

CB_METHOD

CC ID: 1192514
Seq. Order: 13
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

Methodology used for collection of fish 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). Stationary Point Count (nSPC): In-water data collected along two 15m diameter cylinders within a 30m transect.

OBJECTID

CC ID: 1192517
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Unique identifier for fish REA observations.

ROUNDID

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

Unique Identifier for ROUND record.

REEF_ZONE

CC ID: 1192524
Seq. Order: 16
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

The zone for the given REA_SITEID (Forereef, Backreef, Protected Slope, Lagoon).

DEPTH_BIN

CC ID: 1192498
Seq. Order: 17
Data Storage Type: NVARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site. Shallow: >0-6 m, Mid: >6-18 m, Deep: >18-30 m.

SITEVISITID

CC ID: 1192532
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Unique identifier created each time a REA_SITEID is surveyed on a LOCALDATE.

DIVER

CC ID: 1192499
Seq. Order: 19
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

Initials of diver that conducted the survey.

REPLICATEID

CC ID: 1192527
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Unique identifier for the replicate sample within a Fish REA survey.

REP

CC ID: 1192526
Seq. Order: 21
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Letter associated to replicate (A, B, C, or D).

PHOTOGRAPHER

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

Flag to indicate photographer of benthic photos. Two divers simultaneously conduct a survey at a site (indicated by the initials of the observer in the DIVER field), only one of which captures the benthic photos. Value -1 indicates the photographer.

TRAINING_YN

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

Flag to signify whether replicate was for training purposes. Value -1 indicates the replicate was for training.

DEPTH

CC ID: 1192497
Seq. Order: 24
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Depth of survey area in meters. Depths usually within 0-30 m.

SURVEY_RADIUS_M

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

Radius of survey area in meters, usually 7.5 m (15-m SPC survey 'cylinder').

HARD_CORAL

CC ID: 1192503
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Hard coral cover (0-100%). Sum of benthic composition categories equals 100.

MA

CC ID: 1192511
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Macroalgae cover (0-100%). Sum of benthic composition categories equals 100.

CCA

CC ID: 1192491
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Crustose coralline algae (CCA) cover (0-100%). Sum of benthic composition categories equals 100.

SAND

CC ID: 1192529
Seq. Order: 29
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Sand cover (0-100%). Sum of benthic composition categories equals 100.

OTHER

CC ID: 1192521
Seq. Order: 30
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Other benthic composition value (0-100%). Sum of benthic composition categories equals 100. Turf algae, tunicates, zoanthids, corallimorphs, clams, cyanobacteria, soft coral, and sponges are pooled into this category as of 2016 surveys.

HABITAT_CODE

CC ID: 1192501
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Code for HABITAT_TYPE.

HABITAT_TYPE

CC ID: 1192502
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

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

CURRENT_STRENGTH

CC ID: 1192495
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Current Strength (None, Slight, Moderate, High).

VISIBILITY

CC ID: 1192547
Seq. Order: 34
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Visibility measured in meters.

MIN_DEPTH

CC ID: 1192515
Seq. Order: 35
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Minimum depth of the diver's survey cylinder in meters.

MAX_DEPTH

CC ID: 1192512
Seq. Order: 36
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Maximum depth of the diver's survey cylinder in meters.

SUBSTRATE_HEIGHT_0

CC ID: 1192535
Seq. Order: 37
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Proportion of survey area between 0-20 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100.

SUBSTRATE_HEIGHT_20

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

Proportion of survey area between 20-50 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100.

SUBSTRATE_HEIGHT_50

CC ID: 1192539
Seq. Order: 39
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Proportion of survey area between 50-100 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100.

SUBSTRATE_HEIGHT_100

CC ID: 1192536
Seq. Order: 40
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Proportion of survey area between 100-150 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100.

SUBSTRATE_HEIGHT_150

CC ID: 1192537
Seq. Order: 41
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Proportion of survey area over 150 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100.

MAX_HEIGHT

CC ID: 1192513
Seq. Order: 42
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Highest elevation point in SPC cylinder measured in meters.

URCHIN_DACOR

CC ID: 1192546
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Free urchin abundance, estimated by DACOR, an abundance code based on visual estimation (Dominant, Abundant, Common, Occasional, and Rare).

BORING_URCHIN_DACOR

CC ID: 1192490
Seq. Order: 44
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Boring urchin abundance, estimated by DACOR, an abundance code based on visual estimation (Dominant, Abundant, Common, Occasional, and Rare).

TAXON_CODE

CC ID: 1192534
Seq. Order: 45
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

4-letter code for TAXON_NAME. Required.

TAXON_NAME

CC ID: 1192541
Seq. Order: 46
Data Storage Type: NVARCHAR2
Max Length: 765
Required: Yes
Primary Key: No
Status: Active
Description:

Scientific name of observed organism to the finest taxonomic resolution that divers can identify a fish to, usually to species (see RANK). Required.

COMMONNAME

CC ID: 1192493
Seq. Order: 47
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Common name (from FishBase).

COMMONFAMILYALL

CC ID: 1192492
Seq. Order: 48
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Common name of all families.

FAMILY

CC ID: 1192500
Seq. Order: 49
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic classification: Family of observed organism (TAXON_NAME).

SCIENTIFIC_NAME

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

Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXON_NAME). If NULL, organism not identified to species taxonomic level (see RANK).

RANK

CC ID: 1192523
Seq. Order: 51
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Lowest defined rank in taxonomic hierarchy.

TROPHIC

CC ID: 1192543
Seq. Order: 52
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Trophic level: APEX (apex predator), Cor (corallivore), H (herbivore), MI (mobile invertivore), Om (Omnivore), Par (parasite), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), X (if unidentified fish), Z (zooplantivore).

TROPHIC_MONREP

CC ID: 1192544
Seq. Order: 53
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Trophic level scheme used (Primary Consumer, Secondary Consumer, Planktivore, Piscivore).

LW_A

CC ID: 1192509
Seq. Order: 54
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Parameter "a" used in length-weight calculations.

LW_B

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

Parameter "b" used in length-weight calculations.

LMAX

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

Maximum length of the fish published in literature.

LENGTH_CONVERSION_FACTOR

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

Factor to convert length as TOTAL LENGTH to get it to right form (standard [SL], fork [FL], or total length [TL]) for available length weight A and B parameters for this species

COUNT

CC ID: 1192494
Seq. Order: 58
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Number of fish observed during survey.

SIZE_

CC ID: 1192533
Seq. Order: 59
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 8
Status: Active
Description:

Total length of fish, measured from the tip of the snout to the tip of the longer lobe of the caudal fin, reported in centimeters. Total length for rays (Myliobatidae) is measured from pectoral fin tip to pectoral fin tip.

OBS_TYPE

CC ID: 1192519
Seq. Order: 60
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for OBS_DESC.

OBS_DESC

CC ID: 1192518
Seq. Order: 61
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

The type of observation made during the fish survey (Instantaneous, non-instantaneous, after 5 minutes, after 10 minutes, presence). See the Reef Fish Survey Protocol for an explanation of the observation types.

Catalog Details

Catalog Item ID: 68418
GUID: gov.noaa.nmfs.inport:68418
Metadata Record Created By: Lori H Luers
Metadata Record Created: 2022-11-15 03:20+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