ESD_FISH_REA_DataDictionary_2024
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:35994 | Updated: January 15, 2025 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Data dictionary for the NCRMP Fish REA SPC datasets
DescriptionData dictionary for NCRMP Fish REA SPC dataset.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
OBJECTID
NUMBER |
Unique identifier for fish REA observations. |
ROUNDID
NUMBER |
Unique Identifier for ROUND record. |
MISSIONID
VARCHAR2 |
Mission Identifier. |
REGION_NAME
VARCHAR2 |
The Pacific Island region surveyed: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands. |
ISLAND
NVARCHAR2 |
Island or Atoll surveyed in the Pacific Island region (REGION_NAME). |
SITE
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. |
LATITUDE
NUMBER |
Latitude in decimal degrees, WGS84, for the given SITE as recorded by divers on the datasheets. |
LONGITUDE
NUMBER |
Longitude in decimal degrees, WGS84 for the given SITE as recorded by divers on the datasheets. |
REEF_ZONE
NVARCHAR2 |
The zone for the given SITE (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 SITE is surveyed on a DATE_. |
DATE_
DATE |
Local date the survey was conducted. |
OBS_YEAR
NUMBER |
4-digit year the survey was conducted (DATE_). |
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). |
METHOD
NVARCHAR2 |
Fish method employed: stationary point count (nSPC). |
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. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
SOFT_CORAL
NUMBER |
Soft coral cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. |
MA
NUMBER |
Macroalgae cover (0-100%). Sum of benthic composition categories equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
CCA
NUMBER |
Crustose coralline algae (CCA) cover (0-100%). Sum of benthic composition categories equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
TA
NUMBER |
Turf algae cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. |
SAND
NUMBER |
Sand cover (0-100%). Sum of benthic composition categories equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
TUNICATE
NUMBER |
Tunicate cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. |
ZOANTHID
NUMBER |
Zoanthid cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. |
CORALLIMORPH
NUMBER |
Corallimorph cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. |
CLAM
NUMBER |
Clam cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. |
CYANO
NUMBER |
Cyanobacteria cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. |
SPONGE
NUMBER |
Sponge cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. |
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. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
OTHER_TYPE
VARCHAR2 |
Other benthic composition type. No longer collected 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. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
SUBSTRATE_HEIGHT_20
NUMBER |
Proportion of survey area between 20-50 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
SUBSTRATE_HEIGHT_50
NUMBER |
Proportion of survey area between 50-100 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
SUBSTRATE_HEIGHT_100
NUMBER |
Proportion of survey area between 100-150 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
SUBSTRATE_HEIGHT_150
NUMBER |
Proportion of survey area over 150 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
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). Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
BORING_URCHIN_DACOR
VARCHAR2 |
Boring urchin abundance, estimated by DACOR, an abundance code based on visual estimation (Dominant, Abundant, Common, Occasional, and Rare). Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
SPECIES
NVARCHAR2 |
4-letter code for TAXONNAME. Required. |
TAXONNAME
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 (TAXONNAME). |
SCIENTIFIC_NAME
VARCHAR2 |
Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). 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_FISH_REA_DataDictionary_2024 |
---|---|
Short Name: | ESD_FISH_REA_SPC_DataDict |
Status: | Completed |
Abstract: |
Data dictionary for the NCRMP Fish REA SPC datasets |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Data dictionary for NCRMP Fish REA SPC dataset. |
Change Summary: |
Starting in 2024, benthic estimate data such as substrate height, urchins, and benthic taxa are not collected during fish surveys, and instead are extracted from benthic imagery collected at the site. |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
OBJECTID | NUMBER | Unique identifier for fish REA observations. | |
100
|
ROUNDID | NUMBER | Unique Identifier for ROUND record. | |
100
|
MISSIONID | VARCHAR2 | Mission Identifier. | |
100
|
REGION_NAME | VARCHAR2 | The Pacific Island region surveyed: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands. | |
100
|
ISLAND | NVARCHAR2 | Island or Atoll surveyed in the Pacific Island region (REGION_NAME). | |
100
|
SITE | 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
|
LATITUDE | NUMBER | Latitude in decimal degrees, WGS84, for the given SITE as recorded by divers on the datasheets. | |
100
|
LONGITUDE | NUMBER | Longitude in decimal degrees, WGS84 for the given SITE as recorded by divers on the datasheets. | |
100
|
REEF_ZONE | NVARCHAR2 | The zone for the given SITE (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 SITE is surveyed on a DATE_. | |
100
|
DATE_ | DATE | Local date the survey was conducted. | |
100
|
OBS_YEAR | NUMBER | 4-digit year the survey was conducted (DATE_). | |
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
|
METHOD | NVARCHAR2 | Fish method employed: stationary point count (nSPC). | |
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. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. | |
100
|
SOFT_CORAL | NUMBER | Soft coral cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. | |
100
|
MA | NUMBER | Macroalgae cover (0-100%). Sum of benthic composition categories equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. | |
100
|
CCA | NUMBER | Crustose coralline algae (CCA) cover (0-100%). Sum of benthic composition categories equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. | |
100
|
TA | NUMBER | Turf algae cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. | |
100
|
SAND | NUMBER | Sand cover (0-100%). Sum of benthic composition categories equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. | |
100
|
TUNICATE | NUMBER | Tunicate cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. | |
100
|
ZOANTHID | NUMBER | Zoanthid cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. | |
100
|
CORALLIMORPH | NUMBER | Corallimorph cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. | |
100
|
CLAM | NUMBER | Clam cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. | |
100
|
CYANO | NUMBER | Cyanobacteria cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. | |
100
|
SPONGE | NUMBER | Sponge cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. | |
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. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. | |
100
|
OTHER_TYPE | VARCHAR2 | Other benthic composition type. No longer collected 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. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. | |
100
|
SUBSTRATE_HEIGHT_20 | NUMBER | Proportion of survey area between 20-50 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. | |
100
|
SUBSTRATE_HEIGHT_50 | NUMBER | Proportion of survey area between 50-100 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. | |
100
|
SUBSTRATE_HEIGHT_100 | NUMBER | Proportion of survey area between 100-150 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. | |
100
|
SUBSTRATE_HEIGHT_150 | NUMBER | Proportion of survey area over 150 cm elevation (0-100%). Sum of SUBSTRATE_HEIGHT fields equals 100. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. | |
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). Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. | |
100
|
BORING_URCHIN_DACOR | VARCHAR2 | Boring urchin abundance, estimated by DACOR, an abundance code based on visual estimation (Dominant, Abundant, Common, Occasional, and Rare). Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. | |
100
|
SPECIES | NVARCHAR2 | 4-letter code for TAXONNAME. Required. | |
100
|
TAXONNAME | 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 (TAXONNAME). | |
100
|
SCIENTIFIC_NAME | VARCHAR2 | Taxonomic classification: the true scientific name (genus and species) of the observed organism (TAXONNAME). 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
OBJECTID
Seq. Order: | 1 |
---|---|
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
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 28 |
Scale: | 0 |
Status: | Active |
Description: |
Unique Identifier for ROUND record. |
MISSIONID
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Mission Identifier. |
REGION_NAME
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The Pacific Island region surveyed: American Samoa, Pacific Remote Island Areas, Mariana Archipelago, main Hawaiian Islands, Northwestern Hawaiian Islands. |
ISLAND
Seq. Order: | 5 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Island or Atoll surveyed in the Pacific Island region (REGION_NAME). |
SITE
Seq. Order: | 6 |
---|---|
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. |
LATITUDE
Seq. Order: | 7 |
---|---|
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 SITE as recorded by divers on the datasheets. |
LONGITUDE
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude in decimal degrees, WGS84 for the given SITE as recorded by divers on the datasheets. |
REEF_ZONE
Seq. Order: | 9 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
The zone for the given SITE (Forereef, Backreef, Protected Slope, Lagoon). |
DEPTH_BIN
Seq. Order: | 10 |
---|---|
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
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Unique identifier created each time a SITE is surveyed on a DATE_. |
DATE_
Seq. Order: | 12 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Local date the survey was conducted. |
OBS_YEAR
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
4-digit year the survey was conducted (DATE_). |
DIVER
Seq. Order: | 14 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Initials of diver that conducted the survey. |
REPLICATEID
Seq. Order: | 15 |
---|---|
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
Seq. Order: | 16 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Letter associated to replicate (A, B, C, or D). |
METHOD
Seq. Order: | 17 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Fish method employed: stationary point count (nSPC). |
PHOTOGRAPHER
Seq. Order: | 18 |
---|---|
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
Seq. Order: | 19 |
---|---|
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
Seq. Order: | 20 |
---|---|
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
Seq. Order: | 21 |
---|---|
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
Seq. Order: | 22 |
---|---|
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. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
SOFT_CORAL
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Soft coral cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. |
MA
Seq. Order: | 24 |
---|---|
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. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
CCA
Seq. Order: | 25 |
---|---|
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. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
TA
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Turf algae cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. |
SAND
Seq. Order: | 27 |
---|---|
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. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
TUNICATE
Seq. Order: | 28 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Tunicate cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. |
ZOANTHID
Seq. Order: | 29 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Zoanthid cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. |
CORALLIMORPH
Seq. Order: | 30 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Corallimorph cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. |
CLAM
Seq. Order: | 31 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Clam cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. |
CYANO
Seq. Order: | 32 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Cyanobacteria cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. |
SPONGE
Seq. Order: | 33 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Sponge cover (0-100%). Sum of benthic composition categories equals 100. No longer collected as of 2016 surveys; pooled into OTHER. |
OTHER
Seq. Order: | 34 |
---|---|
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. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
OTHER_TYPE
Seq. Order: | 35 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Other benthic composition type. No longer collected as of 2016 surveys. |
HABITAT_CODE
Seq. Order: | 36 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for HABITAT_TYPE. |
HABITAT_TYPE
Seq. Order: | 37 |
---|---|
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
Seq. Order: | 38 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Current Strength (None, Slight, Moderate, High). |
VISIBILITY
Seq. Order: | 39 |
---|---|
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
Seq. Order: | 40 |
---|---|
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
Seq. Order: | 41 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Maximum depth of the diverâÂÂs survey cylinder in meters. |
SUBSTRATE_HEIGHT_0
Seq. Order: | 42 |
---|---|
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. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
SUBSTRATE_HEIGHT_20
Seq. Order: | 43 |
---|---|
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. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
SUBSTRATE_HEIGHT_50
Seq. Order: | 44 |
---|---|
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. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
SUBSTRATE_HEIGHT_100
Seq. Order: | 45 |
---|---|
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. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
SUBSTRATE_HEIGHT_150
Seq. Order: | 46 |
---|---|
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. Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
MAX_HEIGHT
Seq. Order: | 47 |
---|---|
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
Seq. Order: | 48 |
---|---|
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). Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
BORING_URCHIN_DACOR
Seq. Order: | 49 |
---|---|
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). Starting 2024 this is null as this value was calculated from benthic imagery rather than during fish surveys. |
SPECIES
Seq. Order: | 50 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
4-letter code for TAXONNAME. Required. |
TAXONNAME
Seq. Order: | 51 |
---|---|
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
Seq. Order: | 52 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Common name (from FishBase). |
COMMONFAMILYALL
Seq. Order: | 53 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Common name of all families. |
FAMILY
Seq. Order: | 54 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic classification: Family of observed organism (TAXONNAME). |
SCIENTIFIC_NAME
Seq. Order: | 55 |
---|---|
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 (TAXONNAME). If NULL, organism not identified to species taxonomic level (see RANK). |
RANK
Seq. Order: | 56 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Lowest defined rank in taxonomic hierarchy. |
TROPHIC
Seq. Order: | 57 |
---|---|
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
Seq. Order: | 58 |
---|---|
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
Seq. Order: | 59 |
---|---|
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
Seq. Order: | 60 |
---|---|
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
Seq. Order: | 61 |
---|---|
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
Seq. Order: | 62 |
---|---|
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
Seq. Order: | 63 |
---|---|
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_
Seq. Order: | 64 |
---|---|
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
Seq. Order: | 65 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for OBS_DESC. |
OBS_DESC
Seq. Order: | 66 |
---|---|
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: | 35994 |
---|---|
GUID: | gov.noaa.nmfs.inport:35994 |
Metadata Record Created By: | Troy T Kanemura |
Metadata Record Created: | 2016-12-14 20:24+0000 |
Metadata Record Last Modified By: | Lori H Luers |
Metadata Record Last Modified: | 2025-01-15 18:31+0000 |
Metadata Record Published: | 2025-01-15 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2020-06-18 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2021-06-18 |