View: V0_FISH_REA
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:36871 | Updated: August 9, 2022 | Published / External
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
![]() |
![]() |
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
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: |
One of the five Pacific Island regions CRED surveys |
ISLAND
Seq. Order: | 5 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Island or Atoll surveyed |
SITE
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
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
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
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
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 for SITE_VISIT record |
DATE_
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
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
Seq. Order: | 14 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Initials of diver conducting 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: new 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 (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
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 |
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 |
HARD_CORAL
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |
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: |
Substrate complexity between 0 cm and 20 cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012). |
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: |
Substrate complexity between 20 cm and 50cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012). |
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: |
Substrate complexity between 50 cm and 100 cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012). |
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: |
Substrate complexity between 100 cm and 150 cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012). |
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: |
Substrate complexity over 150 cm elevation (applicable to surveys conducted by Papahanaumokuakea in 2012). |
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 centimeters (applicable to surveys conducted by Papahanaumokuakea in 2012). |
URCHIN_DACOR
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
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
Seq. Order: | 50 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
4-letter species code |
TAXONNAME
Seq. Order: | 51 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 765 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Scientific name |
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 family classification |
SCIENTIFIC_NAME
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
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
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
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 by to get it to right form (SL or FL or 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: |
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
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
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
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
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 |