Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > International Programs > Timor Leste > Coral reef fish biomass and benthic cover data... >

View: V0_FISH_REA

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:35550  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Object Comments:. Fish REA foundational view

Description

Object Comments:. Fish REA foundational view

Entity Information

Entity Type
Data View

Data Attribute / Type Description
OBJECTID
NUMBER 		Unique identifier for fish REA observations
ROUNDID
NUMBER 		Unique Identifier for ROUND record
MISSIONID
VARCHAR2 		Mission Identifier
REGION_NAME
VARCHAR2 		One of the five Pacific Island regions CRED surveys
ISLAND
NVARCHAR2 		Island or Atoll surveyed
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

Rubric Score Primary Key? Name Type Description
100
 OBJECTID NUMBER Unique identifier for fish REA observations
100
 ROUNDID NUMBER Unique Identifier for ROUND record
100
 MISSIONID VARCHAR2 Mission Identifier
100
 REGION_NAME VARCHAR2 One of the five Pacific Island regions CRED surveys
100
 ISLAND NVARCHAR2 Island or Atoll surveyed
100
 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