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

Summary

Abstract

Data dictionary for fish SPC dataset

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

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.
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).
YEAR
NUMBER
4-digit year the survey was conducted.
CRUISE_ID
VARCHAR2
Mission Identifier.
LOCATION
NVARCHAR2
Name of island or atoll where the sample was collected in the Pacific Islands region (REGION).
LOCATIONCODE
VARCHAR2
3-Letter unique code for LOCATION.
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.
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
NUMBER
Latitude in decimal degrees, WGS84, for the given REA_SITEID as recorded by divers on the datasheets.
LONGITUDE
NUMBER
Longitude in decimal degrees, WGS84, for the given REA_SITEID as recorded by divers on the datasheets.
LOCALDATE
DATE
Local date the survey was conducted as MM/DD/YYYY.
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.
OBJECTID
NUMBER
Unique identifier for fish REA observations.
ROUNDID
NUMBER
Unique Identifier for ROUND record.
REEF_ZONE
NVARCHAR2
The zone for the given REA_SITEID (Forereef, Backreef, Protected Slope, Lagoon).
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.
SITEVISITID
NUMBER
Unique identifier created each time a REA_SITEID is surveyed on a LOCALDATE.
DIVER
NVARCHAR2
Initials of diver that conducted the survey.
REPLICATEID
NUMBER
Unique identifier for the replicate sample within a Fish REA survey.
REP
NVARCHAR2
Letter associated to replicate (A, B, C, or D).
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.
TRAINING_YN
NUMBER
Flag to signify whether replicate was for training purposes. Value -1 indicates the replicate was for training.
DEPTH
NUMBER
Depth of survey area in meters. Depths usually within 0-30 m.
SURVEY_RADIUS_M
NUMBER
Radius of survey area in meters, usually 7.5 m (15-m SPC survey 'cylinder').
HARD_CORAL
NUMBER
Hard coral cover (0-100%). Sum of benthic composition categories equals 100.
MA
NUMBER
Macroalgae cover (0-100%). Sum of benthic composition categories equals 100.
CCA
NUMBER
Crustose coralline algae (CCA) cover (0-100%). Sum of benthic composition categories equals 100.
SAND
NUMBER
Sand cover (0-100%). Sum of benthic composition categories equals 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.
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).
CURRENT_STRENGTH
VARCHAR2
Current Strength (None, Slight, Moderate, High).
VISIBILITY
NUMBER
Visibility measured in meters.
MIN_DEPTH
NUMBER
Minimum depth of the diver's survey cylinder in meters.
MAX_DEPTH
NUMBER
Maximum depth of the diver's survey cylinder in meters.
SUBSTRATE_HEIGHT_0
NUMBER
Proportion of survey area between 0-20 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100.
SUBSTRATE_HEIGHT_20
NUMBER
Proportion of survey area between 20-50 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100.
SUBSTRATE_HEIGHT_50
NUMBER
Proportion of survey area between 50-100 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100.
SUBSTRATE_HEIGHT_100
NUMBER
Proportion of survey area between 100-150 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100.
SUBSTRATE_HEIGHT_150
NUMBER
Proportion of survey area over 150 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100.
MAX_HEIGHT
NUMBER
Highest elevation point in SPC cylinder measured in meters.
URCHIN_DACOR
VARCHAR2
Free urchin abundance, estimated by DACOR, an abundance code based on visual estimation (Dominant, Abundant, Common, Occasional, and Rare).
BORING_URCHIN_DACOR
VARCHAR2
Boring urchin abundance, estimated by DACOR, an abundance code based on visual estimation (Dominant, Abundant, Common, Occasional, and Rare).
TAXON_CODE
NVARCHAR2
4-letter code for TAXON_NAME. Required.
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.
COMMONNAME
NVARCHAR2
Common name (from FishBase).
COMMONFAMILYALL
NVARCHAR2
Common name of all families.
FAMILY
NVARCHAR2
Taxonomic classification: Family of observed organism (TAXON_NAME).
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).
RANK
VARCHAR2
Lowest defined rank in taxonomic hierarchy.
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).
TROPHIC_MONREP
NVARCHAR2
Trophic level scheme used (Primary Consumer, Secondary Consumer, Planktivore, Piscivore).
LW_A
NUMBER
Parameter "a" used in length-weight calculations.
LW_B
NUMBER
Parameter "b" used in length-weight calculations.
LMAX
NUMBER
Maximum length of the fish published in literature.
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
COUNT
NUMBER
Number of fish observed during survey.
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.
OBS_TYPE
VARCHAR2
Code for OBS_DESC.
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.

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_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

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

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