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

Summary

Abstract

Object Comments:. Fish REA foundational view

Description

Object Comments:. Fish REA foundational view

Entity Information

Entity Type
Data View

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
One of the five Pacific Island regions CRED surveys
ISLAND
NVARCHAR2
Island or Atoll surveyed
SITE
NVARCHAR2
The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number
LATITUDE
NUMBER
Site latitude as recorded by divers on the Dive & Nav Info datasheets in decimal degrees
LONGITUDE
NUMBER
Site longitude as recorded by divers on the Dive & Nav Info datasheets in decimal degrees
REEF_ZONE
NVARCHAR2
The reef zone for the given site (Forereef, Backreef or 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 for SITE_VISIT record
DATE_
DATE
Date the survey was conducted
OBS_YEAR
NUMBER
Year the survey was conducted
DIVER
NVARCHAR2
Initials of diver conducting 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: belt transect (BLT), stationary point count (SPC), or new 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
SURVEY_RADIUS_M
NUMBER
Radius of survey area in meters
HARD_CORAL
NUMBER
Hard Coral %
SOFT_CORAL
NUMBER
Soft Coral %
MA
NUMBER
Macroalgae %
CCA
NUMBER
Crustose Coralline Algae %
TA
NUMBER
Turf Algae %
SAND
NUMBER
Sand %
TUNICATE
NUMBER
Tunicate %
ZOANTHID
NUMBER
Zoanthid %
CORALLIMORPH
NUMBER
Corallimorph %
CLAM
NUMBER
Clam %
CYANO
NUMBER
Cyanobacteria %
SPONGE
NUMBER
Sponge %
OTHER
NUMBER
Other benthic composition value %
OTHER_TYPE
VARCHAR2
Other benthic composition type
HABITAT_CODE
VARCHAR2
Habitat Type (see HABITAT_TYPE) for description of code.
HABITAT_TYPE
VARCHAR2
Habitat description
CURRENT_STRENGTH
VARCHAR2
Current Strength (None, Slight, Moderate, High)
VISIBILITY
NUMBER
Visibility measured in meters
MIN_DEPTH
NUMBER
Minimum slope depth in meters
MAX_DEPTH
NUMBER
Maximum slope depth in meters
SUBSTRATE_HEIGHT_0
NUMBER
Substrate complexity between 0cm and 20cm elevation
SUBSTRATE_HEIGHT_20
NUMBER
Substrate complexity between 20cm and 50cm elevation
SUBSTRATE_HEIGHT_50
NUMBER
Substrate complexity between 50cm and 100cm elevation
SUBSTRATE_HEIGHT_100
NUMBER
Substrate complexity between 100cm and 150cm elevation
SUBSTRATE_HEIGHT_150
NUMBER
Substrate complexity over 150cm elevation
MAX_HEIGHT
NUMBER
Highest elevation point in SPC cylinder measured in centimeters
URCHIN_DACOR
VARCHAR2
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)
SPECIES
NVARCHAR2
4-letter species code
TAXONNAME
NVARCHAR2
Scientific name
COMMONNAME
NVARCHAR2
Common name (from FishBase)
COMMONFAMILYALL
NVARCHAR2
Common name of all families
FAMILY
NVARCHAR2
Taxonomic family classification
SCIENTIFIC_NAME
VARCHAR2
Holds the true scientific name
RANK
VARCHAR2
Lowest defined rank in taxonomic hierarchy
TROPHIC
NVARCHAR2
Trophic level: APEX (apex predator), Cor (corallivore), H (herbivore), MI (mobile invertivore), Om (Omnivore), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), 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 by to get it to right form (SL or FL or 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
A single letter representation of the observation type (I: Instantaneous, N: Non-Instantaneous, F: After 5 minutes, T: After 10 minutes, P: Presence, U: Unknown)
OBS_DESC
VARCHAR2
The definition of the observation type

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: 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 One of the five Pacific Island regions CRED surveys
100
ISLAND NVARCHAR2 Island or Atoll surveyed
100
SITE NVARCHAR2 The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number
100
LATITUDE NUMBER Site latitude as recorded by divers on the Dive & Nav Info datasheets in decimal degrees
100
LONGITUDE NUMBER Site longitude as recorded by divers on the Dive & Nav Info datasheets in decimal degrees
100
REEF_ZONE NVARCHAR2 The reef zone for the given site (Forereef, Backreef or 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 for SITE_VISIT record
100
DATE_ DATE Date the survey was conducted
100
OBS_YEAR NUMBER Year the survey was conducted
100
DIVER NVARCHAR2 Initials of diver conducting 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: belt transect (BLT), stationary point count (SPC), or new 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
100
SURVEY_RADIUS_M NUMBER Radius of survey area in meters
100
HARD_CORAL NUMBER Hard Coral %
100
SOFT_CORAL NUMBER Soft Coral %
100
MA NUMBER Macroalgae %
100
CCA NUMBER Crustose Coralline Algae %
100
TA NUMBER Turf Algae %
100
SAND NUMBER Sand %
100
TUNICATE NUMBER Tunicate %
100
ZOANTHID NUMBER Zoanthid %
100
CORALLIMORPH NUMBER Corallimorph %
100
CLAM NUMBER Clam %
100
CYANO NUMBER Cyanobacteria %
100
SPONGE NUMBER Sponge %
100
OTHER NUMBER Other benthic composition value %
100
OTHER_TYPE VARCHAR2 Other benthic composition type
100
HABITAT_CODE VARCHAR2 Habitat Type (see HABITAT_TYPE) for description of code.
100
HABITAT_TYPE VARCHAR2 Habitat description
100
CURRENT_STRENGTH VARCHAR2 Current Strength (None, Slight, Moderate, High)
100
VISIBILITY NUMBER Visibility measured in meters
100
MIN_DEPTH NUMBER Minimum slope depth in meters
100
MAX_DEPTH NUMBER Maximum slope depth in meters
100
SUBSTRATE_HEIGHT_0 NUMBER Substrate complexity between 0cm and 20cm elevation
100
SUBSTRATE_HEIGHT_20 NUMBER Substrate complexity between 20cm and 50cm elevation
100
SUBSTRATE_HEIGHT_50 NUMBER Substrate complexity between 50cm and 100cm elevation
100
SUBSTRATE_HEIGHT_100 NUMBER Substrate complexity between 100cm and 150cm elevation
100
SUBSTRATE_HEIGHT_150 NUMBER Substrate complexity over 150cm elevation
100
MAX_HEIGHT NUMBER Highest elevation point in SPC cylinder measured in centimeters
100
URCHIN_DACOR VARCHAR2 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 species code
100
TAXONNAME NVARCHAR2 Scientific name
100
COMMONNAME NVARCHAR2 Common name (from FishBase)
100
COMMONFAMILYALL NVARCHAR2 Common name of all families
100
FAMILY NVARCHAR2 Taxonomic family classification
100
SCIENTIFIC_NAME VARCHAR2 Holds the true scientific name
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), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), 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 by to get it to right form (SL or FL or 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 A single letter representation of the observation type (I: Instantaneous, N: Non-Instantaneous, F: After 5 minutes, T: After 10 minutes, P: Presence, U: Unknown)
100
OBS_DESC VARCHAR2 The definition of the observation type

Attribute Details

OBJECTID

CC ID: 364890
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: 364902
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: 364889
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

Mission Identifier

REGION_NAME

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

One of the five Pacific Island regions CRED surveys

ISLAND

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

Island or Atoll surveyed

SITE

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

The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number

LATITUDE

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

Site latitude as recorded by divers on the Dive & Nav Info datasheets in decimal degrees

LONGITUDE

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

Site longitude as recorded by divers on the Dive & Nav Info datasheets in decimal degrees

REEF_ZONE

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

The reef zone for the given site (Forereef, Backreef or Lagoon)

DEPTH_BIN

CC ID: 364871
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: 364906
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Unique Identifier for SITE_VISIT record

DATE_

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

Date the survey was conducted

OBS_YEAR

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

Year the survey was conducted

DIVER

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

Initials of diver conducting survey

REPLICATEID

CC ID: 364901
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: 364900
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: 364887
Seq. Order: 17
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

Fish method employed: belt transect (BLT), stationary point count (SPC), or new stationary point count (nSPC)

PHOTOGRAPHER

CC ID: 364896
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: 364919
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: 364870
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

SURVEY_RADIUS_M

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

Radius of survey area in meters

HARD_CORAL

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

Hard Coral %

SOFT_CORAL

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

Soft Coral %

MA

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

Macroalgae %

CCA

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

Crustose Coralline Algae %

TA

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

Turf Algae %

SAND

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

Sand %

TUNICATE

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

Tunicate %

ZOANTHID

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

Zoanthid %

CORALLIMORPH

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

Corallimorph %

CLAM

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

Clam %

CYANO

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

Cyanobacteria %

SPONGE

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

Sponge %

OTHER

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

Other benthic composition value %

OTHER_TYPE

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

Other benthic composition type

HABITAT_CODE

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

Habitat Type (see HABITAT_TYPE) for description of code.

HABITAT_TYPE

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

Habitat description

CURRENT_STRENGTH

CC ID: 364867
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: 364924
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: 364888
Seq. Order: 40
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Minimum slope depth in meters

MAX_DEPTH

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

Maximum slope depth in meters

SUBSTRATE_HEIGHT_0

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

Substrate complexity between 0cm and 20cm elevation

SUBSTRATE_HEIGHT_20

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

Substrate complexity between 20cm and 50cm elevation

SUBSTRATE_HEIGHT_50

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

Substrate complexity between 50cm and 100cm elevation

SUBSTRATE_HEIGHT_100

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

Substrate complexity between 100cm and 150cm elevation

SUBSTRATE_HEIGHT_150

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

Substrate complexity over 150cm elevation

MAX_HEIGHT

CC ID: 364886
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 centimeters

URCHIN_DACOR

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

Urchin abundance, estimated by DACOR, an abundance code based on visual estimation (dominant, abundant, common, occasional, and rare)

BORING_URCHIN_DACOR

CC ID: 364860
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: 364909
Seq. Order: 50
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

4-letter species code

TAXONNAME

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

Scientific name

COMMONNAME

CC ID: 364864
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: 364863
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: 364873
Seq. Order: 54
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Taxonomic family classification

SCIENTIFIC_NAME

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

Holds the true scientific name

RANK

CC ID: 364897
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: 364920
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), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), Z (zooplantivore)

TROPHIC_MONREP

CC ID: 364921
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: 364882
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: 364883
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: 364880
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: 364879
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 by to get it to right form (SL or FL or TL) for available length weight A and B parameters for this species

COUNT

CC ID: 364866
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: 364907
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: 364892
Seq. Order: 65
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

A single letter representation of the observation type (I: Instantaneous, N: Non-Instantaneous, F: After 5 minutes, T: After 10 minutes, P: Presence, U: Unknown)

OBS_DESC

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

The definition of the observation type

Catalog Details

Catalog Item ID: 35992
GUID: gov.noaa.nmfs.inport:35992
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2016-12-14 17:54+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2017-11-22
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2017-11-22
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2018-11-22