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. |
Attribute Details
OBJECTID
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
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Unique site identifier |
SITE
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
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 20 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Site name |
STATION
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Sampling station number |
STATIONID
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
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
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
Seq. Order: | 9 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date the survey was conducted |
OBSERVERID
Seq. Order: | 11 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Initials of diver conducting survey |
WAVEEXPOSURE
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
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
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
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
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
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
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
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
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
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Unique species identifier |
SCIENTIFIC_NAME
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Scientific name |
LW_A
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
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
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
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
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
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
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
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 |