View: V0_FISH_REA
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:35991 | Updated: August 9, 2022 | Published / External
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 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: 364824
| 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: 364836
| 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: 364823
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 30 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Mission Identifier |
REGION_NAME
CC ID: 364833
| 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: 364811
| 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: 364839
| 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: 364812
| 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: 364815
| 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: 364832
| 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: 364805
| 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: 364840
| 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: 364803
| 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: 364827
| 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: 364806
| 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: 364835
| 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: 364834
| 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: 364821
| 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: 364830
| 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: 364853
| 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: 364804
| 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: 364850
| 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: 364810
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Hard Coral % |
SOFT_CORAL
CC ID: 364842
| 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: 364818
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Macroalgae % |
CCA
CC ID: 364795
| 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: 364851
| 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: 364837
| Seq. Order: | 27 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Sand % |
TUNICATE
CC ID: 364856
| Seq. Order: | 28 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Tunicate % |
ZOANTHID
CC ID: 364859
| Seq. Order: | 29 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Zoanthid % |
CORALLIMORPH
CC ID: 364799
| Seq. Order: | 30 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Corallimorph % |
CLAM
CC ID: 364796
| Seq. Order: | 31 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Clam % |
CYANO
CC ID: 364802
| Seq. Order: | 32 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Cyanobacteria % |
SPONGE
CC ID: 364844
| Seq. Order: | 33 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Sponge % |
OTHER
CC ID: 364828
| 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: 364829
| 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: 364808
| 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: 364809
| Seq. Order: | 37 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Habitat description |
CURRENT_STRENGTH
CC ID: 364801
| 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: 364858
| 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: 364822
| 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: 364819
| 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: 364845
| 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: 364848
| 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: 364849
| 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: 364846
| 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: 364847
| 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: 364820
| 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: 364857
| 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: 364794
| 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: 364843
| 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: 364852
| Seq. Order: | 51 |
|---|---|
| Data Storage Type: | NVARCHAR2 |
| Max Length: | 765 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Scientific name |
COMMONNAME
CC ID: 364798
| 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: 364797
| 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: 364807
| 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: 364838
| 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: 364831
| 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: 364854
| 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: 364855
| 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: 364816
| 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: 364817
| 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: 364814
| 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: 364813
| 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: 364800
| 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: 364841
| 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: 364826
| 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: 364825
| 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: | 35991 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:35991 |
| Metadata Record Created By: | Troy T Kanemura |
| Metadata Record Created: | 2016-12-14 17:51+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 |