Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ecosystem Monitoring and Assessment > Pacific Reef Assessment and Monitoring Program:... >

View: V0_FISH_REA

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:36871  |  Updated: August 9, 2022  |  Published / External 
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 in decimal degrees
LONGITUDE
NUMBER 		Site longitude as recorded by divers in decimal degrees
REEF_ZONE
NVARCHAR2 		The reef zone for the given site (forereef, backreef, protected slope, 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: new stationary point count (nSPC)
PHOTOGRAPHER
NUMBER 		Flag to indicate photographer of benthic photos (not applicable to surveys conducted by Papahanaumokuakea). 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 %. Applicable to surveys from 2010-2012.
SOFT_CORAL
NUMBER 		Soft Coral %. Applicable to surveys from 2010-2012.
MA
NUMBER 		Macroalgae %. Applicable to surveys from 2010-2012.
CCA
NUMBER 		Crustose Coralline Algae %. Applicable to surveys from 2010-2012.
TA
NUMBER 		Turf Algae %. Applicable to surveys from 2010-2012.
SAND
NUMBER 		Sand %. Applicable to surveys from 2010-2012.
TUNICATE
NUMBER 		Tunicate %. Applicable to surveys from 2010-2012.
ZOANTHID
NUMBER 		Zoanthid %. Applicable to surveys from 2010-2012.
CORALLIMORPH
NUMBER 		Corallimorph %. Applicable to surveys from 2010-2012.
CLAM
NUMBER 		Clam %. Applicable to surveys from 2010-2012.
CYANO
NUMBER 		Cyanobacteria %. Applicable to surveys from 2010-2012.
SPONGE
NUMBER 		Sponge %. Applicable to surveys from 2010-2012.
OTHER
NUMBER 		Other benthic composition value %. Applicable to surveys from 2010-2012.
OTHER_TYPE
VARCHAR2 		Other benthic composition type. Applicable to surveys from 2010-2012.
HABITAT_CODE
VARCHAR2 		Habitat Type (see HABITAT_TYPE) for description of code. Applicable to surveys from 2010-2012.
HABITAT_TYPE
VARCHAR2 		Habitat description. Applicable to surveys from 2010-2012.
CURRENT_STRENGTH
VARCHAR2 		Current Strength (None, Slight, Moderate, High)
VISIBILITY
NUMBER 		Visibility measured in meters
SUBSTRATE_HEIGHT_0
NUMBER 		Substrate complexity between 0 cm and 20 cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012).
SUBSTRATE_HEIGHT_20
NUMBER 		Substrate complexity between 20 cm and 50cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012).
SUBSTRATE_HEIGHT_50
NUMBER 		Substrate complexity between 50 cm and 100 cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012).
SUBSTRATE_HEIGHT_100
NUMBER 		Substrate complexity between 100 cm and 150 cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012).
SUBSTRATE_HEIGHT_150
NUMBER 		Substrate complexity over 150 cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012).
MAX_HEIGHT
NUMBER 		Highest elevation point in SPC cylinder measured in centimeters (applicable to surveys conducted by Papahanaumokuakea in 2012).
URCHIN_DACOR
VARCHAR2 		Applicable to 2012 surveys: Urchin abundance, estimated by DACOR, an abundance code based on visual estimation (dominant, abundant, common, occasional, and rare)
BORING_URCHIN_DACOR
VARCHAR2 		Applicable to 2012 surveys: 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. Value is NULL if organism is not identified to Species (refer to RANK field).
RANK
VARCHAR2 		Lowest defined rank in taxonomic hierarchy (lowest = species)
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). Applicable to surveys from 2010-2012.
OBS_DESC
VARCHAR2 		The definition of the observation type. Applicable to surveys from 2010-2012.
SLOPE_MIN_DEPTH
NUMBER 		Minimum slope depth in meters (applicable to surveys conducted by Papahanaumokuakea in 2011)
SLOPE_MAX_DEPTH
NUMBER 		Maximum slope depth in meters (applicable to surveys conducted by Papahanaumokuakea in 2011)
COMPLEXITY
TEXT 		An estimate of the rugosity (complexity) of the the seafloor using a scale of low, medium-low, medium, medium-high, high, and very high (applicable to surveys conducted by Papahanaumokuakea in 2011).

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 in decimal degrees
100
 LONGITUDE NUMBER Site longitude as recorded by divers in decimal degrees
100
 REEF_ZONE NVARCHAR2 The reef zone for the given site (forereef, backreef, protected slope, 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: new stationary point count (nSPC)
100
 PHOTOGRAPHER NUMBER Flag to indicate photographer of benthic photos (not applicable to surveys conducted by Papahanaumokuakea). 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 %. Applicable to surveys from 2010-2012.
100
 SOFT_CORAL NUMBER Soft Coral %. Applicable to surveys from 2010-2012.
100
 MA NUMBER Macroalgae %. Applicable to surveys from 2010-2012.
100
 CCA NUMBER Crustose Coralline Algae %. Applicable to surveys from 2010-2012.
100
 TA NUMBER Turf Algae %. Applicable to surveys from 2010-2012.
100
 SAND NUMBER Sand %. Applicable to surveys from 2010-2012.
100
 TUNICATE NUMBER Tunicate %. Applicable to surveys from 2010-2012.
100
 ZOANTHID NUMBER Zoanthid %. Applicable to surveys from 2010-2012.
100
 CORALLIMORPH NUMBER Corallimorph %. Applicable to surveys from 2010-2012.
100
 CLAM NUMBER Clam %. Applicable to surveys from 2010-2012.
100
 CYANO NUMBER Cyanobacteria %. Applicable to surveys from 2010-2012.
100
 SPONGE NUMBER Sponge %. Applicable to surveys from 2010-2012.
100
 OTHER NUMBER Other benthic composition value %. Applicable to surveys from 2010-2012.
100
 OTHER_TYPE VARCHAR2 Other benthic composition type. Applicable to surveys from 2010-2012.
100
 HABITAT_CODE VARCHAR2 Habitat Type (see HABITAT_TYPE) for description of code. Applicable to surveys from 2010-2012.
100
 HABITAT_TYPE VARCHAR2 Habitat description. Applicable to surveys from 2010-2012.
100
 CURRENT_STRENGTH VARCHAR2 Current Strength (None, Slight, Moderate, High)
100
 VISIBILITY NUMBER Visibility measured in meters
100
 SUBSTRATE_HEIGHT_0 NUMBER Substrate complexity between 0 cm and 20 cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012).
100
 SUBSTRATE_HEIGHT_20 NUMBER Substrate complexity between 20 cm and 50cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012).
100
 SUBSTRATE_HEIGHT_50 NUMBER Substrate complexity between 50 cm and 100 cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012).
100
 SUBSTRATE_HEIGHT_100 NUMBER Substrate complexity between 100 cm and 150 cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012).
100
 SUBSTRATE_HEIGHT_150 NUMBER Substrate complexity over 150 cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012).
100
 MAX_HEIGHT NUMBER Highest elevation point in SPC cylinder measured in centimeters (applicable to surveys conducted by Papahanaumokuakea in 2012).
100
 URCHIN_DACOR VARCHAR2 Applicable to 2012 surveys: Urchin abundance, estimated by DACOR, an abundance code based on visual estimation (dominant, abundant, common, occasional, and rare)
100
 BORING_URCHIN_DACOR VARCHAR2 Applicable to 2012 surveys: 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. Value is NULL if organism is not identified to Species (refer to RANK field).
100
 RANK VARCHAR2 Lowest defined rank in taxonomic hierarchy (lowest = species)
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). Applicable to surveys from 2010-2012.
100
 OBS_DESC VARCHAR2 The definition of the observation type. Applicable to surveys from 2010-2012.
100
 SLOPE_MIN_DEPTH NUMBER Minimum slope depth in meters (applicable to surveys conducted by Papahanaumokuakea in 2011)
100
 SLOPE_MAX_DEPTH NUMBER Maximum slope depth in meters (applicable to surveys conducted by Papahanaumokuakea in 2011)
100
 COMPLEXITY TEXT An estimate of the rugosity (complexity) of the the seafloor using a scale of low, medium-low, medium, medium-high, high, and very high (applicable to surveys conducted by Papahanaumokuakea in 2011).

Attribute Details

OBJECTID

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

Mission Identifier

REGION_NAME

CC ID: 382754
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: 382732
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: 382760
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: 382733
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 in decimal degrees

LONGITUDE

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

Site longitude as recorded by divers in decimal degrees

REEF_ZONE

CC ID: 382753
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, protected slope, or lagoon)

DEPTH_BIN

CC ID: 382726
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: 382761
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: 382724
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: 382748
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: 382727
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: 382756
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: 382755
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: 382742
Seq. Order: 17
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

Fish method employed: new stationary point count (nSPC)

PHOTOGRAPHER

CC ID: 382751
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 (not applicable to surveys conducted by Papahanaumokuakea). 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: 382774
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: 382725
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: 382771
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: 382731
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Hard Coral %. Applicable to surveys from 2010-2012.

SOFT_CORAL

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

Soft Coral %. Applicable to surveys from 2010-2012.

MA

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

Macroalgae %. Applicable to surveys from 2010-2012.

CCA

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

Crustose Coralline Algae %. Applicable to surveys from 2010-2012.

TA

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

Turf Algae %. Applicable to surveys from 2010-2012.

SAND

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

Sand %. Applicable to surveys from 2010-2012.

TUNICATE

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

Tunicate %. Applicable to surveys from 2010-2012.

ZOANTHID

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

Zoanthid %. Applicable to surveys from 2010-2012.

CORALLIMORPH

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

Corallimorph %. Applicable to surveys from 2010-2012.

CLAM

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

Clam %. Applicable to surveys from 2010-2012.

CYANO

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

Cyanobacteria %. Applicable to surveys from 2010-2012.

SPONGE

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

Sponge %. Applicable to surveys from 2010-2012.

OTHER

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

Other benthic composition value %. Applicable to surveys from 2010-2012.

OTHER_TYPE

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

Other benthic composition type. Applicable to surveys from 2010-2012.

HABITAT_CODE

CC ID: 382729
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. Applicable to surveys from 2010-2012.

HABITAT_TYPE

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

Habitat description. Applicable to surveys from 2010-2012.

CURRENT_STRENGTH

CC ID: 382722
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: 382779
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

SUBSTRATE_HEIGHT_0

CC ID: 382766
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 0 cm and 20 cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012).

SUBSTRATE_HEIGHT_20

CC ID: 382769
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 20 cm and 50cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012).

SUBSTRATE_HEIGHT_50

CC ID: 382770
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 50 cm and 100 cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012).

SUBSTRATE_HEIGHT_100

CC ID: 382767
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 100 cm and 150 cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012).

SUBSTRATE_HEIGHT_150

CC ID: 382768
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 150 cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012).

MAX_HEIGHT

CC ID: 382741
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 (applicable to surveys conducted by Papahanaumokuakea in 2012).

URCHIN_DACOR

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

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

BORING_URCHIN_DACOR

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

Applicable to 2012 surveys: Boring Urchin abundance, estimated by DACOR, an abundance code based on visual estimation (dominant, abundant, common, occasional, and rare)

SPECIES

CC ID: 382764
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: 382773
Seq. Order: 51
Data Storage Type: NVARCHAR2
Max Length: 765
Required: Yes
Primary Key: No
Status: Active
Description:

Scientific name

COMMONNAME

CC ID: 382719
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: 382718
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: 382728
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: 382759
Seq. Order: 55
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Holds the true scientific name. Value is NULL if organism is not identified to Species (refer to RANK field).

RANK

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

Lowest defined rank in taxonomic hierarchy (lowest = species)

TROPHIC

CC ID: 382775
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: 382776
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: 382737
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: 382738
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: 382735
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: 382734
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: 382721
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: 382762
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: 382747
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). Applicable to surveys from 2010-2012.

OBS_DESC

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

The definition of the observation type. Applicable to surveys from 2010-2012.

SLOPE_MIN_DEPTH

CC ID: 799127
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Minimum slope depth in meters (applicable to surveys conducted by Papahanaumokuakea in 2011)

SLOPE_MAX_DEPTH

CC ID: 799128
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Maximum slope depth in meters (applicable to surveys conducted by Papahanaumokuakea in 2011)

COMPLEXITY

CC ID: 799286
Data Storage Type: TEXT
Required: No
Primary Key: No
Status: Active
Description:

An estimate of the rugosity (complexity) of the the seafloor using a scale of low, medium-low, medium, medium-high, high, and very high (applicable to surveys conducted by Papahanaumokuakea in 2011).

Catalog Details

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