View: V0_FISH_REA
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:35550 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Object Comments:. Fish REA foundational view
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 |
|
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 |
|
DISTRICT
VARCHAR2 |
District / municipality specifically for sites in Timor Leste |
|
SITE
NVARCHAR2 |
The 5- to 6-character code for the site surveyed. Combines a 3-letter island code with a site number |
|
LATITUDE
NUMBER |
Site latitude as recorded by divers on the Dive & Nav Info datasheets in decimal degrees |
|
LONGITUDE
NUMBER |
Site longitude as recorded by divers on the Dive & Nav Info datasheets in decimal degrees |
|
REEF_ZONE
NVARCHAR2 |
The reef zone for the given site (Forereef, Backreef or Lagoon) |
|
DEPTH_BIN
NVARCHAR2 |
Classification of depth (shallow, mid, deep) based on midpoint between minimum and maximum depths of replicates at this site. 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: belt transect (BLT), stationary point count (SPC), or new stationary point count (nSPC) |
|
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. |
|
DEPTH
NUMBER |
Depth of survey area in meters |
|
SURVEY_RADIUS_M
NUMBER |
Radius of survey area in meters |
|
SURVEY_AREA_M2
NUMBER |
Survey area in square meters |
|
HARD_CORAL
NUMBER |
Hard Coral % |
|
SOFT_CORAL
NUMBER |
Soft Coral % |
|
MA
NUMBER |
Macroalgae % |
|
CCA
NUMBER |
Crustose Coralline Algae % |
|
TA
NUMBER |
Turf Algae % |
|
SAND
NUMBER |
Sand % |
|
TUNICATE
NUMBER |
Tunicate % |
|
ZOANTHID
NUMBER |
Zoanthid % |
|
CORALLIMORPH
NUMBER |
Corallimorph % |
|
CLAM
NUMBER |
Clam % |
|
CYANO
NUMBER |
Cyanobacteria % |
|
SPONGE
NUMBER |
Sponge % |
|
HABITAT_CODE
VARCHAR2 |
Habitat Type (see HABITAT_TYPE) for description of code. |
|
HABITAT_DESC
VARCHAR2 |
Habitat Description |
|
CURRENT_STRENGTH
VARCHAR2 |
Current Strength (None, Slight, Moderate, High) |
|
VISIBILITY
NUMBER |
Visibility measured in meters |
|
SLOPE_MIN_DEPTH
NUMBER |
Minimum slope depth in meters |
|
SLOPE_MAX_DEPTH
NUMBER |
Maximum slope depth in meters |
|
SUBSTRATE_HEIGHT_0
NUMBER |
Substrate complexity between 0cm and 20cm elevation |
|
SUBSTRATE_HEIGHT_20
NUMBER |
Substrate complexity between 20cm and 50cm elevation |
|
SUBSTRATE_HEIGHT_50
NUMBER |
Substrate complexity between 50cm and 100cm elevation |
|
SUBSTRATE_HEIGHT_100
NUMBER |
Substrate complexity between 100cm and 150cm elevation |
|
SUBSTRATE_HEIGHT_150
NUMBER |
Substrate complexity over 150cm elevation |
|
MAX_HEIGHT
NUMBER |
Highest elevation point in SPC cylinder measured in centimeters |
|
URCHIN_DACOR
VARCHAR2 |
Urchin abundance, estimated by DACOR, an abundance code based on visual estimation (dominant, abundant, common, occasional, and rare) |
|
BORING_URCHIN_DACOR
VARCHAR2 |
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 |
|
RANK
VARCHAR2 |
Lowest defined rank in taxonomic hierarchy |
|
APHIAID
VARCHAR2 |
AphiaID |
|
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) |
|
CONSUMER_GROUP
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) |
|
OBS_DESC
VARCHAR2 |
The definition of the observation type |
|
DENSITY
NUMBER |
Density (number of fish per square meter) |
|
BIOMASS_G_M2
NUMBER |
Biomass (grams per square meter) |
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
|
|
|
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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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_
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Macroalgae % |
| General Data Type: | NUMBER |
CCA
| 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
| 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
| 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
| Seq. Order: | 30 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Tunicate % |
| General Data Type: | NUMBER |
ZOANTHID
| 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
| Seq. Order: | 32 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Corallimorph % |
| General Data Type: | NUMBER |
CLAM
| 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
| Seq. Order: | 34 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Cyanobacteria % |
| General Data Type: | NUMBER |
SPONGE
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| 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
| Seq. Order: | 56 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
AphiaID |
| General Data Type: | VARCHAR2 |
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) |
| General Data Type: | NVARCHAR2 |
CONSUMER_GROUP
| 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
| 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
| 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
| 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
| 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
| 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_
| 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
| 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
| 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
| 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
| 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 |
