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
LONGITUDE
NUMBER
Site longitude as recorded by divers on the Dive & Nav Info datasheets
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
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)
DEPTH
NUMBER
Depth of survey area in meters
SURVEY_LENGTH_M
NUMBER
Length of survey area in meters
SURVEY_WIDTH_M
NUMBER
Width of survey area in meters
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.

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.