Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Coral Reef Ecosystem Program (CREP) Metad... > Ecosystem Monitoring and Assessment > Guam Long-term Coral Reef Monitoring Program > Guam Long-term Coral Reef Monitoring Program Re... >

Guam Long-term Monitoring Program: Fish Observations

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:47785  |  Updated: December 5, 2023  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Guam Long-term Monitoring Program fish observation data

Description

Guam Long-term Monitoring Program fish observation data

Entity Information

Entity Type
Data View

Data Attribute / Type Description
SITE_ID
NUMBER 		Unique site identifier
SITE
NVARCHAR2 		The 3-character code for the site surveyed
SITE_NAME
VARCHAR2 		Site name
STATION
NUMBER 		Sampling station number
STATIONID
VARCHAR2 		A unique identifier combining the SITE with the STATION
LATITUDE
NUMBER 		Site latitude as recorded by diver in decimal degrees
LONGITUDE
NUMBER 		Site longitude as recorded by diver decimal degrees
DATE_TIME
DATE 		Date the survey was conducted
OBSERVER
NVARCHAR2 		Anonymized observer identification
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
DEPTH
NUMBER 		Depth of survey area in meters
STRATUM
NVARCHAR2 		The stratum for the given sampling station, which includes the reef zone and subzone (e.g., ReefSlope-Terrace, ReefMargin-West)
STATION_TYPE
VARCHAR2 		The sampling station type (Fixed or Unfixed)
FISHTRANSECTID
NUMBER 		Unique identifier for the transect along which a fish belt or two SPC replicates are conducted during a given sampling period
TRANSECT_NUMBER
NUMBER 		The number of the transect surveyed at a given sampling station
METHOD_NAME
NVARCHAR2 		Fish method employed: belt transect (Fish BLT) or stationary point count (Fish SPC)
CYLINDER_RADIUS
NUMBER 		Radius of SPC cylinder area in meters
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
FISH_SPECIES_ID
NUMBER 		Unique species identifier
SCIENTIFIC_NAME
VARCHAR2 		Scientific name
FAMILY_SCI
NVARCHAR2 		Family to which the species belongs
FOODFISH_GUAM
VARCHAR2 		Indicates whether or not a taxon is considered a food fish on Guam, according to the Guam Department of Agriculture's Division of Aquatic and Wildlife Resources
OBSERVATION_TYPE
NVARCHAR2 		Observation type for a given taxon beginning with the 2020 field season; all taxa were counted and sized between 2010 and 2019
LW_A_PIFSC
NUMBER 		Parameter "a" used in length-weight calculations; values provided by NOAA PIFSC, originally obtained from various published online resources
LW_B_PIFSC
NUMBER 		Parameter "b" used in length-weight calculations; same as values used by NOAA PIFSC, originally obtained from various published online resources
LEN_TYPE_PIFSC
NVARCHAR2 		Length measurement type upon which the length-weight values were based; values provided by NOAA PIFSC, originally obtained from various published online resources
SLTLRAT_PIFSC
NUMBER 		Conversion factor used to calculate biomass for Total Length (TL) observations and length-weight values based upon Standard Length (SL) data; values provided by NOAA PIFSC, originally obtained from various published online resources
FLTLRAT_PIFSC
NUMBER 		Conversion factor used to calculate biomass for Total Length (TL) observations and length-weight values based upon Fork Length (FL) data; values provided by NOAA PIFSC, originally obtained from various published online resources
LEN_CONV_FACTOR
NUMBER 		The conversion factor used to calculate biomass for the Total Length (TL) observed, selected using an IF, THEN statement based upon the measurement type (TL, FL, SL, DW) upon which the length-weight values were based. A converstion factor of 1 was used for length-weight values based on upon TL data, while the SLTLRAT_PIFSC value was used for measurements of ray disk width (DW).
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
TROPHIC_MONREP
NVARCHAR2 		Trophic level scheme used
FISH_COUNT
NUMBER 		Number of fish observed during survey
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.
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.
BIOMASS_PER_RECORD_G
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 were made using length-weight values provided by NOAA PIFSC, originally obtained from various published online resources.
BIOMASS_PER_RECORD_G_PER_M2
NUMBER 		Total calculated wet weight in grams for all fish of a specific length for a single taxon within a single SPC cylinder survey, divided by the area of a single SPC cylinder (176.715 m^2). Calculations were made using length-weight values provided by NOAA PIFSC, originally obtained from various published online resources.

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: 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
 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
 OBSERVER NVARCHAR2 Anonymized observer identification
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
 FAMILY_SCI NVARCHAR2 Family to which the species belongs
100
 FOODFISH_GUAM VARCHAR2 Indicates whether or not a taxon is considered a food fish on Guam, according to the Guam Department of Agriculture's Division of Aquatic and Wildlife Resources
100
 OBSERVATION_TYPE NVARCHAR2 Observation type for a given taxon beginning with the 2020 field season; all taxa were counted and sized between 2010 and 2019
100
 LW_A_PIFSC NUMBER Parameter "a" used in length-weight calculations; values provided by NOAA PIFSC, originally obtained from various published online resources
100
 LW_B_PIFSC NUMBER Parameter "b" used in length-weight calculations; same as values used by NOAA PIFSC, originally obtained from various published online resources
100
 LEN_TYPE_PIFSC NVARCHAR2 Length measurement type upon which the length-weight values were based; values provided by NOAA PIFSC, originally obtained from various published online resources
100
 SLTLRAT_PIFSC NUMBER Conversion factor used to calculate biomass for Total Length (TL) observations and length-weight values based upon Standard Length (SL) data; values provided by NOAA PIFSC, originally obtained from various published online resources
100
 FLTLRAT_PIFSC NUMBER Conversion factor used to calculate biomass for Total Length (TL) observations and length-weight values based upon Fork Length (FL) data; values provided by NOAA PIFSC, originally obtained from various published online resources
100
 LEN_CONV_FACTOR NUMBER The conversion factor used to calculate biomass for the Total Length (TL) observed, selected using an IF, THEN statement based upon the measurement type (TL, FL, SL, DW) upon which the length-weight values were based. A converstion factor of 1 was used for length-weight values based on upon TL data, while the SLTLRAT_PIFSC value was used for measurements of ray disk width (DW).
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
 TROPHIC_MONREP NVARCHAR2 Trophic level scheme used
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_PER_RECORD_G 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 were made using length-weight values provided by NOAA PIFSC, originally obtained from various published online resources.
100
 BIOMASS_PER_RECORD_G_PER_M2 NUMBER Total calculated wet weight in grams for all fish of a specific length for a single taxon within a single SPC cylinder survey, divided by the area of a single SPC cylinder (176.715 m^2). Calculations were made using length-weight values provided by NOAA PIFSC, originally obtained from various published online resources.

Attribute Details

SITE_ID

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

Unique site identifier

SITE

CC ID: 597317
Seq. Order: 2
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: 3
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Site name

STATION

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

Sampling station number

STATIONID

CC ID: 597977
Seq. Order: 5
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: 6
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: 7
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: 8
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Date the survey was conducted

OBSERVER

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

Anonymized observer identification

WAVEEXPOSURE

CC ID: 597283
Seq. Order: 10
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: 11
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: 12
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: 13
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: 14
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: 15
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: 16
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: 17
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: 18
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: 19
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Status: Active
Description:

Unique species identifier

SCIENTIFIC_NAME

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

Scientific name

FAMILY_SCI

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

Family to which the species belongs

FOODFISH_GUAM

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

Indicates whether or not a taxon is considered a food fish on Guam, according to the Guam Department of Agriculture's Division of Aquatic and Wildlife Resources
Allowed Values: Y (= Yes), N (= No)

OBSERVATION_TYPE

CC ID: 1284167
Seq. Order: 23
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Observation type for a given taxon beginning with the 2020 field season; all taxa were counted and sized between 2010 and 2019
Allowed Values: Count and size, count only, presence/absence only

LW_A_PIFSC

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; values provided by NOAA PIFSC, originally obtained from various published online resources

LW_B_PIFSC

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, originally obtained from various published online resources

LEN_TYPE_PIFSC

CC ID: 1284168
Seq. Order: 26
Data Storage Type: NVARCHAR2
Required: No
Primary Key: No
Status: Active
Description:

Length measurement type upon which the length-weight values were based; values provided by NOAA PIFSC, originally obtained from various published online resources

SLTLRAT_PIFSC

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

Conversion factor used to calculate biomass for Total Length (TL) observations and length-weight values based upon Standard Length (SL) data; values provided by NOAA PIFSC, originally obtained from various published online resources

FLTLRAT_PIFSC

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

Conversion factor used to calculate biomass for Total Length (TL) observations and length-weight values based upon Fork Length (FL) data; values provided by NOAA PIFSC, originally obtained from various published online resources

LEN_CONV_FACTOR

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

The conversion factor used to calculate biomass for the Total Length (TL) observed, selected using an IF, THEN statement based upon the measurement type (TL, FL, SL, DW) upon which the length-weight values were based. A converstion factor of 1 was used for length-weight values based on upon TL data, while the SLTLRAT_PIFSC value was used for measurements of ray disk width (DW).

TROPHIC

CC ID: 1111878
Seq. Order: 30
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

TROPHIC_MONREP

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

Trophic level scheme used
Null Value: NULL
Null Value Meaning:

Trophic level scheme not designated for the taxon
Allowed Values: PISCIVORE, PLANKTIVORE, PRIMARY, SECONDARY

FISH_COUNT

CC ID: 597278
Seq. Order: 32
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: 33
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: 34
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_PER_RECORD_G

CC ID: 1111877
Seq. Order: 35
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 were made using length-weight values provided by NOAA PIFSC, originally obtained from various published online resources.

BIOMASS_PER_RECORD_G_PER_M2

CC ID: 1284161
Seq. Order: 36
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, divided by the area of a single SPC cylinder (176.715 m^2). Calculations were made using length-weight values provided by NOAA PIFSC, originally 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: David R Burdick
Metadata Record Last Modified: 2023-12-05 01:31+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