Item Identification

Title: View: V0_FISH_REA
Short Name: V0_FISH_REA
Status: Completed
Abstract:

Object Comments:. Fish REA foundational view

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: GISDAT
Description:

Object Comments:. Fish REA foundational view

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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.
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.
100
CCA NUMBER Crustose coralline algae (CCA) cover (0-100%). Sum of benthic composition categories equals 100.
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.
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.
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.
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
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

CC ID: 365023
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

CC ID: 365035
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

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

Mission Identifier.

REGION_NAME

CC ID: 365032
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

CC ID: 365010
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

CC ID: 365038
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

CC ID: 365011
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

CC ID: 365014
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

CC ID: 365031
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

CC ID: 365004
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

CC ID: 365039
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_

CC ID: 365002
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

CC ID: 365026
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

CC ID: 365005
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

CC ID: 365034
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

CC ID: 365033
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

CC ID: 365020
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

CC ID: 365029
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

CC ID: 365052
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

CC ID: 365003
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

CC ID: 365049
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

CC ID: 365009
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.

SOFT_CORAL

CC ID: 365041
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

CC ID: 365017
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.

CCA

CC ID: 364994
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.

TA

CC ID: 365050
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

CC ID: 365036
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.

TUNICATE

CC ID: 365055
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

CC ID: 365058
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

CC ID: 364998
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

CC ID: 364995
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

CC ID: 365001
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

CC ID: 365043
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

CC ID: 365027
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.

OTHER_TYPE

CC ID: 365028
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

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

Code for HABITAT_TYPE.

HABITAT_TYPE

CC ID: 365008
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

CC ID: 365000
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

CC ID: 365057
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

CC ID: 365021
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

CC ID: 365018
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

CC ID: 365044
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.

SUBSTRATE_HEIGHT_20

CC ID: 365047
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.

SUBSTRATE_HEIGHT_50

CC ID: 365048
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.

SUBSTRATE_HEIGHT_100

CC ID: 365045
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.

SUBSTRATE_HEIGHT_150

CC ID: 365046
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.

MAX_HEIGHT

CC ID: 365019
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

CC ID: 365056
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).

BORING_URCHIN_DACOR

CC ID: 364993
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).

SPECIES

CC ID: 365042
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

CC ID: 365051
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

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

Common name (from FishBase).

COMMONFAMILYALL

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

Common name of all families.

FAMILY

CC ID: 365006
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

CC ID: 365037
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

CC ID: 365030
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

CC ID: 365053
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

CC ID: 365054
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

CC ID: 365015
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

CC ID: 365016
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

CC ID: 365013
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

CC ID: 365012
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

CC ID: 364999
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_

CC ID: 365040
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

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

Code for OBS_DESC.

OBS_DESC

CC ID: 365024
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
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2016-12-14 20:24+0000
Metadata Record Last Modified By: Annette M DesRochers
Metadata Record Last Modified: 2020-06-18 14:41+0000
Metadata Record Published: 2020-06-18
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2021-06-19