Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Guam Long-term Monitoring Program: Fish Observations
Short Name: GLTMP Fish
Status: Completed
Abstract:

Guam Long-term Monitoring Program fish observation data

Entity Information

Entity Type: Data View
Active Version?: Yes
Description:

Guam Long-term Monitoring Program fish observation data

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
OBJECTID NUMBER Unique identifier for fish observations
100
SITE_ID NUMBER Unique site identifier
100
SITE NVARCHAR2 The 3-character code for the site surveyed
100
SITE_NAME VARCHAR2 Site name
100
STATION NUMBER Sampling station number
100
STATIONID VARCHAR2 A unique identifier combining the SITE with the STATION
100
LATITUDE NUMBER Site latitude as recorded by diver in decimal degrees
100
LONGITUDE NUMBER Site longitude as recorded by diver decimal degrees
100
DATE_TIME DATE Date the survey was conducted
100
OBSERVERID NVARCHAR2 Initials of diver conducting survey
100
WAVEEXPOSURE NVARCHAR2 A general classification of the degree of wave exposure (Low, Moderate, High) for a given site; the wave exposure value is the same for all sampling stations within a given site
100
DEPTH NUMBER Depth of survey area in meters
100
STRATUM NVARCHAR2 The stratum for the given sampling station, which includes the reef zone and subzone (e.g., ReefSlope-Terrace, ReefMargin-West)
100
STATION_TYPE VARCHAR2 The sampling station type (Fixed or Unfixed)
100
FISHTRANSECTID NUMBER Unique identifier for the transect along which a fish belt or two SPC replicates are conducted during a given sampling period
100
TRANSECT_NUMBER NUMBER The number of the transect surveyed at a given sampling station
100
METHOD_NAME NVARCHAR2 Fish method employed: belt transect (Fish BLT) or stationary point count (Fish SPC)
100
CYLINDER_RADIUS NUMBER Radius of SPC cylinder area in meters
100
SPC_CYLINDER NVARCHAR2 Letter associated with SPC replicate (A or B). Replicate A refers to the first cylinder surveyed by a single observer and B is the 2nd cylinder surveyed by the same observer; thus, when two different observers simultaneously survey cylinders on either half of a transect both replicates are designated as replicate A
100
FISH_SPECIES_ID NUMBER Unique species identifier
100
SCIENTIFIC_NAME VARCHAR2 Scientific name
100
LW_A NUMBER Parameter "a" used in length-weight calculations; same as values used by NOAA PIFSC, obtained from various published online resources
100
LW_B NUMBER Parameter "b" used in length-weight calculations; same as values used by NOAA PIFSC, obtained from various published online resources
100
LMAX NUMBER Maximum recorded length for a given taxon
100
TROPHIC VARCHAR2 Trophic group designation; same as values used by NOAA PIFSC, obtained from various published online resources. Note that some taxa are assigned more than one trophic group designation
100
FISH_COUNT NUMBER Number of fish observed during survey
100
FISH_LENGTH 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
DATA_TYPE VARCHAR2 Type of data (Instantaneous, Non-instantaneous, Non-instantaneous 5-10, Non-instantaneous 10-15, Non-instantaneous 15+, Presence). Refer to the full metadata record for a description of these data types.
100
BIOMASS NUMBER Total calculated wet weight in grams for all fish of a specific length for a single taxon within a single SPC cylinder survey. Calculations are made using the same length-weight values used by NOAA PIFSC, obtained from various published online resources.

Attribute Details

OBJECTID

CC ID: 597302
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 observations

SITE_ID

CC ID: 597975
Seq. Order: 2
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Unique site identifier

SITE

CC ID: 597317
Seq. Order: 3
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

The 3-character code for the site surveyed

SITE_NAME

CC ID: 597976
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Site name

STATION

CC ID: 597981
Seq. Order: 5
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Sampling station number

STATIONID

CC ID: 597977
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

A unique identifier combining the SITE with the STATION

LATITUDE

CC ID: 597290
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Site latitude as recorded by diver in decimal degrees

Unit of Measure: decimal degrees

LONGITUDE

CC ID: 597293
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

Site longitude as recorded by diver decimal degrees

Unit of Measure: decimal degrees

DATE_TIME

CC ID: 597281
Seq. Order: 9
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date the survey was conducted

OBSERVERID

CC ID: 597284
Seq. Order: 11
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

Initials of diver conducting survey

WAVEEXPOSURE

CC ID: 597283
Seq. Order: 12
Data Storage Type: NVARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

A general classification of the degree of wave exposure (Low, Moderate, High) for a given site; the wave exposure value is the same for all sampling stations within a given site

Null Value: NULL
Null Value Meaning:

Wave exposure class if not provided

Allowed Values: Low, Moderate, High

DEPTH

CC ID: 597282
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Depth of survey area in meters

Unit of Measure: meters

STRATUM

CC ID: 597310
Seq. Order: 14
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

The stratum for the given sampling station, which includes the reef zone and subzone (e.g., ReefSlope-Terrace, ReefMargin-West)

Null Value: NULL
Null Value Meaning:

Stratum not provided for sampling station

Allowed Values: Embayment-Terrace, ReefSlope-Terrace, ReefSlope-West, ReefFlatMargin-East, ReefFlatMargin-West

STATION_TYPE

CC ID: 597978
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

The sampling station type (Fixed or Unfixed)

Null Value: NULL
Null Value Meaning:

Sampling station type not provided

Allowed Values: Fixed, Unfixed

FISHTRANSECTID

CC ID: 597313
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Unique identifier for the transect along which a fish belt or two SPC replicates are conducted during a given sampling period

TRANSECT_NUMBER

CC ID: 597979
Seq. Order: 17
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

The number of the transect surveyed at a given sampling station

METHOD_NAME

CC ID: 597299
Seq. Order: 18
Data Storage Type: NVARCHAR2
Max Length: 150
Required: Yes
Primary Key: No
Status: Active
Description:

Fish method employed: belt transect (Fish BLT) or stationary point count (Fish SPC)

Allowed Values: Fish BLT, Fish SPC

CYLINDER_RADIUS

CC ID: 597328
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Radius of SPC cylinder area in meters

Unit of Measure: meters

SPC_CYLINDER

CC ID: 597312
Seq. Order: 21
Data Storage Type: NVARCHAR2
Max Length: 150
Required: No
Primary Key: No
Status: Active
Description:

Letter associated with SPC replicate (A or B). Replicate A refers to the first cylinder surveyed by a single observer and B is the 2nd cylinder surveyed by the same observer; thus, when two different observers simultaneously survey cylinders on either half of a transect both replicates are designated as replicate A

Allowed Values: A, B

FISH_SPECIES_ID

CC ID: 597321
Seq. Order: 22
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Unique species identifier

SCIENTIFIC_NAME

CC ID: 597316
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Scientific name

LW_A

CC ID: 597294
Seq. Order: 24
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; same as values used by NOAA PIFSC, obtained from various published online resources

LW_B

CC ID: 597295
Seq. Order: 25
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; same as values used by NOAA PIFSC, obtained from various published online resources

LMAX

CC ID: 1111875
Seq. Order: 26
Data Storage Type: NUMBER
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Maximum recorded length for a given taxon

Null Value: 999
Null Value Meaning:

An arbitrary value assigned to taxa for which LMAX values are not available

TROPHIC

CC ID: 1111878
Seq. Order: 27
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Trophic group designation; same as values used by NOAA PIFSC, obtained from various published online resources. Note that some taxa are assigned more than one trophic group designation

Null Value: NULL
Null Value Meaning:

a trophic group has not be assigned to that taxon

Allowed Values: APEX = apex predator), Cor = corallivore, H = herbivore, MI = mobile invertivore, Om = omnivore, Par = parrotfish, Pisc = piscivore, Pk = planktivore, SI = sessile invertivore, Z = zooplanktivore

FISH_COUNT

CC ID: 597278
Seq. Order: 28
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

FISH_LENGTH

CC ID: 597319
Seq. Order: 29
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.

DATA_TYPE

CC ID: 1111876
Seq. Order: 30
Data Storage Type: VARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Type of data (Instantaneous, Non-instantaneous, Non-instantaneous 5-10, Non-instantaneous 10-15, Non-instantaneous 15+, Presence). Refer to the full metadata record for a description of these data types.

Allowed Values: Instantaneous, Non-instantaneous, Non-instantaneous 5-10, Non-instantaneous 10-15, Non-instantaneous 15+, Presence

BIOMASS

CC ID: 1111877
Seq. Order: 31
Data Storage Type: NUMBER
Required: No
Primary Key: No
Status: Active
Description:

Total calculated wet weight in grams for all fish of a specific length for a single taxon within a single SPC cylinder survey. Calculations are made using the same length-weight values used by NOAA PIFSC, obtained from various published online resources.

Catalog Details

Catalog Item ID: 47785
GUID: gov.noaa.nmfs.inport:47785
Metadata Record Created By: Troy T Kanemura
Metadata Record Created: 2017-11-05 17:42+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-04-14
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-04-14
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-04-14