Metadata Rubric

100%

6 / 6

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

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

	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.

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