View: V0_FISH_REA
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:35550 | 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
|
SECTOR | VARCHAR2 | This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island | |
|
100
|
DISTRICT | VARCHAR2 | District / municipality specifically for sites in Timor Leste | |
|
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
|
DEPTH | NUMBER | Depth of survey area in meters | |
|
100
|
SURVEY_RADIUS_M | NUMBER | Radius of survey area in meters | |
|
100
|
SURVEY_AREA_M2 | NUMBER | Survey area in square 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
|
HABITAT_CODE | VARCHAR2 | Habitat Type (see HABITAT_TYPE) for description of code. | |
|
100
|
HABITAT_DESC | VARCHAR2 | Habitat Description | |
|
100
|
CURRENT_STRENGTH | VARCHAR2 | Current Strength (None, Slight, Moderate, High) | |
|
100
|
VISIBILITY | NUMBER | Visibility measured in meters | |
|
100
|
SLOPE_MIN_DEPTH | NUMBER | Minimum slope depth in meters | |
|
100
|
SLOPE_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
|
RANK | VARCHAR2 | Lowest defined rank in taxonomic hierarchy | |
|
100
|
APHIAID | VARCHAR2 | AphiaID | |
|
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
|
CONSUMER_GROUP | 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 | |
|
100
|
DENSITY | NUMBER | Density (number of fish per square meter) | |
|
100
|
BIOMASS_G_M2 | NUMBER | Biomass (grams per square meter) |
Attribute Details
OBJECTID
CC ID: 356452
| 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 |
| General Data Type: | NUMBER |
ROUNDID
CC ID: 356453
| 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 |
| General Data Type: | NUMBER |
MISSIONID
CC ID: 356454
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 30 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Mission Identifier |
| General Data Type: | VARCHAR2 |
REGION_NAME
CC ID: 356455
| 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 |
| General Data Type: | VARCHAR2 |
ISLAND
CC ID: 356456
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | NVARCHAR2 |
| Max Length: | 150 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Island or Atoll surveyed |
| General Data Type: | NVARCHAR2 |
SECTOR
CC ID: 356457
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
This field is used by the fish team to represent a different stratification scheme based on fishing pressure and wave exposure around an island |
| General Data Type: | VARCHAR2 |
DISTRICT
CC ID: 356458
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
District / municipality specifically for sites in Timor Leste |
| General Data Type: | VARCHAR2 |
SITE
CC ID: 356459
| Seq. Order: | 8 |
|---|---|
| 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 |
| General Data Type: | NVARCHAR2 |
LATITUDE
CC ID: 356460
| Seq. Order: | 9 |
|---|---|
| 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 |
| General Data Type: | NUMBER |
LONGITUDE
CC ID: 356461
| Seq. Order: | 10 |
|---|---|
| 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 |
| General Data Type: | NUMBER |
REEF_ZONE
CC ID: 356462
| Seq. Order: | 11 |
|---|---|
| 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) |
| General Data Type: | NVARCHAR2 |
DEPTH_BIN
CC ID: 356463
| Seq. Order: | 12 |
|---|---|
| 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 |
| General Data Type: | NVARCHAR2 |
SITEVISITID
CC ID: 356464
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Unique Identifier for SITE_VISIT record |
| General Data Type: | NUMBER |
DATE_
CC ID: 356465
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date the survey was conducted |
| General Data Type: | DATE |
OBS_YEAR
CC ID: 356466
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Year the survey was conducted |
| General Data Type: | NUMBER |
DIVER
CC ID: 356467
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | NVARCHAR2 |
| Max Length: | 150 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Initials of diver conducting survey |
| General Data Type: | NVARCHAR2 |
REPLICATEID
CC ID: 356468
| Seq. Order: | 17 |
|---|---|
| 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 |
| General Data Type: | NUMBER |
REP
CC ID: 356469
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | NVARCHAR2 |
| Max Length: | 150 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Letter associated to replicate (A, B, C, or D) |
| General Data Type: | NVARCHAR2 |
METHOD
CC ID: 356470
| Seq. Order: | 19 |
|---|---|
| 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) |
| General Data Type: | NVARCHAR2 |
PHOTOGRAPHER
CC ID: 356471
| Seq. Order: | 20 |
|---|---|
| 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. |
| General Data Type: | NUMBER |
DEPTH
CC ID: 356472
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Depth of survey area in meters |
| General Data Type: | NUMBER |
SURVEY_RADIUS_M
CC ID: 356473
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Radius of survey area in meters |
| General Data Type: | NUMBER |
SURVEY_AREA_M2
CC ID: 356474
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Survey area in square meters |
| General Data Type: | NUMBER |
HARD_CORAL
CC ID: 356475
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Hard Coral % |
| General Data Type: | NUMBER |
SOFT_CORAL
CC ID: 356476
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Soft Coral % |
| General Data Type: | NUMBER |
MA
CC ID: 356477
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Macroalgae % |
| General Data Type: | NUMBER |
CCA
CC ID: 356478
| Seq. Order: | 27 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Crustose Coralline Algae % |
| General Data Type: | NUMBER |
TA
CC ID: 356479
| Seq. Order: | 28 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Turf Algae % |
| General Data Type: | NUMBER |
SAND
CC ID: 356480
| Seq. Order: | 29 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Sand % |
| General Data Type: | NUMBER |
TUNICATE
CC ID: 356481
| Seq. Order: | 30 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Tunicate % |
| General Data Type: | NUMBER |
ZOANTHID
CC ID: 356482
| Seq. Order: | 31 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Zoanthid % |
| General Data Type: | NUMBER |
CORALLIMORPH
CC ID: 356483
| Seq. Order: | 32 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Corallimorph % |
| General Data Type: | NUMBER |
CLAM
CC ID: 356484
| Seq. Order: | 33 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Clam % |
| General Data Type: | NUMBER |
CYANO
CC ID: 356485
| Seq. Order: | 34 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Cyanobacteria % |
| General Data Type: | NUMBER |
SPONGE
CC ID: 356486
| Seq. Order: | 35 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Sponge % |
| General Data Type: | NUMBER |
HABITAT_CODE
CC ID: 356487
| 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. |
| General Data Type: | VARCHAR2 |
HABITAT_DESC
CC ID: 356488
| Seq. Order: | 37 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Habitat Description |
| General Data Type: | VARCHAR2 |
CURRENT_STRENGTH
CC ID: 356489
| Seq. Order: | 38 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Current Strength (None, Slight, Moderate, High) |
| General Data Type: | VARCHAR2 |
VISIBILITY
CC ID: 356490
| 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 |
| General Data Type: | NUMBER |
SLOPE_MIN_DEPTH
CC ID: 356491
| Seq. Order: | 40 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Minimum slope depth in meters |
| General Data Type: | NUMBER |
SLOPE_MAX_DEPTH
CC ID: 356492
| 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 |
| General Data Type: | NUMBER |
SUBSTRATE_HEIGHT_0
CC ID: 356493
| 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 |
| General Data Type: | NUMBER |
SUBSTRATE_HEIGHT_20
CC ID: 356494
| 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 |
| General Data Type: | NUMBER |
SUBSTRATE_HEIGHT_50
CC ID: 356495
| 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 |
| General Data Type: | NUMBER |
SUBSTRATE_HEIGHT_100
CC ID: 356496
| 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 |
| General Data Type: | NUMBER |
SUBSTRATE_HEIGHT_150
CC ID: 356497
| 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 |
| General Data Type: | NUMBER |
MAX_HEIGHT
CC ID: 356498
| 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 |
| General Data Type: | NUMBER |
URCHIN_DACOR
CC ID: 356499
| 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) |
| General Data Type: | VARCHAR2 |
BORING_URCHIN_DACOR
CC ID: 356500
| 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) |
| General Data Type: | VARCHAR2 |
SPECIES
CC ID: 356501
| Seq. Order: | 50 |
|---|---|
| Data Storage Type: | NVARCHAR2 |
| Max Length: | 150 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
4-letter species code |
| General Data Type: | NVARCHAR2 |
TAXONNAME
CC ID: 356502
| Seq. Order: | 51 |
|---|---|
| Data Storage Type: | NVARCHAR2 |
| Max Length: | 765 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Scientific name |
| General Data Type: | NVARCHAR2 |
COMMONNAME
CC ID: 356503
| Seq. Order: | 52 |
|---|---|
| Data Storage Type: | NVARCHAR2 |
| Max Length: | 150 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Common name (from FishBase) |
| General Data Type: | NVARCHAR2 |
COMMONFAMILYALL
CC ID: 356504
| Seq. Order: | 53 |
|---|---|
| Data Storage Type: | NVARCHAR2 |
| Max Length: | 150 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Common name of all families |
| General Data Type: | NVARCHAR2 |
FAMILY
CC ID: 356505
| Seq. Order: | 54 |
|---|---|
| Data Storage Type: | NVARCHAR2 |
| Max Length: | 150 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Taxonomic family classification |
| General Data Type: | NVARCHAR2 |
RANK
CC ID: 356506
| Seq. Order: | 55 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Lowest defined rank in taxonomic hierarchy |
| General Data Type: | VARCHAR2 |
APHIAID
CC ID: 356507
| Seq. Order: | 56 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
AphiaID |
| General Data Type: | VARCHAR2 |
TROPHIC
CC ID: 356508
| 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) |
| General Data Type: | NVARCHAR2 |
CONSUMER_GROUP
CC ID: 356509
| 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) |
| General Data Type: | NVARCHAR2 |
LW_A
CC ID: 356510
| 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 |
| General Data Type: | NUMBER |
LW_B
CC ID: 356511
| 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 |
| General Data Type: | NUMBER |
LMAX
CC ID: 356512
| 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 |
| General Data Type: | NUMBER |
LENGTH_CONVERSION_FACTOR
CC ID: 356513
| 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 |
| General Data Type: | NUMBER |
COUNT
CC ID: 356514
| 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 |
| General Data Type: | NUMBER |
SIZE_
CC ID: 356515
| 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. |
| General Data Type: | NUMBER |
OBS_TYPE
CC ID: 356516
| 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) |
| General Data Type: | VARCHAR2 |
OBS_DESC
CC ID: 356517
| Seq. Order: | 66 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
The definition of the observation type |
| General Data Type: | VARCHAR2 |
DENSITY
CC ID: 356518
| Seq. Order: | 67 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 38 |
| Status: | Active |
| Description: |
Density (number of fish per square meter) |
| General Data Type: | NUMBER |
BIOMASS_G_M2
CC ID: 356519
| Seq. Order: | 68 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Biomass (grams per square meter) |
| General Data Type: | NUMBER |
Catalog Details
| Catalog Item ID: | 35550 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:35550 |
| Metadata Record Created By: | Annette M DesRochers |
| Metadata Record Created: | 2016-11-04 15:54+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2017-08-29 |
| Owner Org: | PIFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2017-08-29 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2018-08-29 |