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: August 9, 2022 | 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	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.

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