Guam Long-term Monitoring Program: Fish Observations
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 47785
| Published / External
Created: 2017-11-05
|
Last Modified: 2023-12-05
Parent: Guam Long-term Coral Reef Monitoring Program Reef Fish Surveys since 2010
Data Set (DS) | ID: 47783
Data Set (DS) | ID: 47783
ID: 47785
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
| * » Title | Guam Long-term Monitoring Program: Fish Observations |
|---|---|
| Short Name | GLTMP Fish |
| * Status | Completed |
| Creation Date | |
| Revision Date | |
| • Publication Date | |
| * » Abstract |
Guam Long-term Monitoring Program fish observation data |
| * Purpose | |
| Notes | |
| Other Citation Details | |
| • Supplemental Information | |
| DOI (Digital Object Identifier) | |
| DOI Registration Authority | |
| DOI Issue Date |
Keywords
Theme Keywords
| Thesaurus | Keyword |
|---|---|
Temporal Keywords
| Thesaurus | Keyword |
|---|---|
* Spatial Keywords
| Thesaurus | Keyword |
|---|---|
Stratum Keywords
| Thesaurus | Keyword |
|---|---|
Instrument Keywords
| Thesaurus | Keyword |
|---|---|
Platform Keywords
| Thesaurus | Keyword |
|---|---|
Physical Location
| • » Organization | |
|---|---|
| • » City | |
| • » State/Province | |
| • Country | |
| • » Location Description |
Entity Information
| Entity Type | Data View |
|---|---|
| Active Version? | Y |
| Alias | |
| Schema Name | |
| » Description |
Guam Long-term Monitoring Program fish observation data |
| Change Summary |
Data Attributes
Attribute Summary
| Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
|---|---|---|---|---|---|
| 100 | Yes | No | SITE_ID | NUMBER | Unique site identifier |
| 100 | Yes | No | SITE | NVARCHAR2 | The 3-character code for the site surveyed |
| 100 | Yes | No | SITE_NAME | VARCHAR2 | Site name |
| 100 | Yes | No | STATION | NUMBER | Sampling station number |
| 100 | Yes | No | STATIONID | VARCHAR2 | A unique identifier combining the SITE with the STATION |
| 100 | Yes | No | LATITUDE | NUMBER | Site latitude as recorded by diver in decimal degrees |
| 100 | Yes | No | LONGITUDE | NUMBER | Site longitude as recorded by diver decimal degrees |
| 100 | Yes | No | DATE_TIME | DATE | Date the survey was conducted |
| 100 | Yes | No | OBSERVER | NVARCHAR2 | Anonymized observer identification |
| 100 | No | No | 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 | No | No | DEPTH | NUMBER | Depth of survey area in meters |
| 100 | No | No | STRATUM | NVARCHAR2 | The stratum for the given sampling station, which includes the reef zone and subzone (e.g., ReefSlope-Terrace, ReefMargin-West) |
| 100 | Yes | No | STATION_TYPE | VARCHAR2 | The sampling station type (Fixed or Unfixed) |
| 100 | Yes | No | FISHTRANSECTID | NUMBER | Unique identifier for the transect along which a fish belt or two SPC replicates are conducted during a given sampling period |
| 100 | Yes | No | TRANSECT_NUMBER | NUMBER | The number of the transect surveyed at a given sampling station |
| 100 | Yes | No | METHOD_NAME | NVARCHAR2 | Fish method employed: belt transect (Fish BLT) or stationary point count (Fish SPC) |
| 100 | No | No | CYLINDER_RADIUS | NUMBER | Radius of SPC cylinder area in meters |
| 100 | No | No | 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 | Yes | No | FISH_SPECIES_ID | NUMBER | Unique species identifier |
| 100 | No | No | SCIENTIFIC_NAME | VARCHAR2 | Scientific name |
| 100 | No | No | FAMILY_SCI | NVARCHAR2 | Family to which the species belongs |
| 100 | No | No | 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 | No | No | 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 | No | No | LW_A_PIFSC | NUMBER | Parameter "a" used in length-weight calculations; values provided by NOAA PIFSC, originally obtained from various published online resources |
| 100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | TROPHIC_MONREP | NVARCHAR2 | Trophic level scheme used |
| 100 | No | No | FISH_COUNT | NUMBER | Number of fish observed during survey |
| 100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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
| Attribute Name | SITE_ID |
|---|---|
| Seq. Order | 1 |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Unique site identifier |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SITE |
|---|---|
| Seq. Order | 2 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
The 3-character code for the site surveyed |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SITE_NAME |
|---|---|
| Seq. Order | 3 |
| Data Storage Type | VARCHAR2 |
| Max Length | 20 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Site name |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | STATION |
|---|---|
| Seq. Order | 4 |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Sampling station number |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | STATIONID |
|---|---|
| Seq. Order | 5 |
| Data Storage Type | VARCHAR2 |
| Max Length | 20 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
A unique identifier combining the SITE with the STATION |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LATITUDE |
|---|---|
| Seq. Order | 6 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Site latitude as recorded by diver in decimal degrees |
| General Data Type | |
| Unit of Measure | decimal degrees |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LONGITUDE |
|---|---|
| Seq. Order | 7 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Site longitude as recorded by diver decimal degrees |
| General Data Type | |
| Unit of Measure | decimal degrees |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DATE_TIME |
|---|---|
| Seq. Order | 8 |
| Data Storage Type | DATE |
| Max Length | 7 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Date the survey was conducted |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OBSERVER |
|---|---|
| Seq. Order | 9 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Anonymized observer identification |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | WAVEEXPOSURE |
|---|---|
| Seq. Order | 10 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 60 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | NULL |
| Null Value Meaning |
Wave exposure class if not provided |
| Allowed Values | Low, Moderate, High |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DEPTH |
|---|---|
| Seq. Order | 11 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Depth of survey area in meters |
| General Data Type | |
| Unit of Measure | meters |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | STRATUM |
|---|---|
| Seq. Order | 12 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
The stratum for the given sampling station, which includes the reef zone and subzone (e.g., ReefSlope-Terrace, ReefMargin-West) |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | NULL |
| Null Value Meaning |
Stratum not provided for sampling station |
| Allowed Values | Embayment-Terrace, ReefSlope-Terrace, ReefSlope-West, ReefFlatMargin-East, ReefFlatMargin-West |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | STATION_TYPE |
|---|---|
| Seq. Order | 13 |
| Data Storage Type | VARCHAR2 |
| Max Length | 20 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
The sampling station type (Fixed or Unfixed) |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | NULL |
| Null Value Meaning |
Sampling station type not provided |
| Allowed Values | Fixed, Unfixed |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FISHTRANSECTID |
|---|---|
| Seq. Order | 14 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TRANSECT_NUMBER |
|---|---|
| Seq. Order | 15 |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
The number of the transect surveyed at a given sampling station |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | METHOD_NAME |
|---|---|
| Seq. Order | 16 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Fish method employed: belt transect (Fish BLT) or stationary point count (Fish SPC) |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Fish BLT, Fish SPC |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | CYLINDER_RADIUS |
|---|---|
| Seq. Order | 17 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Radius of SPC cylinder area in meters |
| General Data Type | |
| Unit of Measure | meters |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SPC_CYLINDER |
|---|---|
| Seq. Order | 18 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | A, B |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FISH_SPECIES_ID |
|---|---|
| Seq. Order | 19 |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Unique species identifier |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SCIENTIFIC_NAME |
|---|---|
| Seq. Order | 20 |
| Data Storage Type | VARCHAR2 |
| Max Length | 255 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Scientific name |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FAMILY_SCI |
|---|---|
| Seq. Order | 21 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Family to which the species belongs |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FOODFISH_GUAM |
|---|---|
| Seq. Order | 22 |
| Data Storage Type | VARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Y (= Yes), N (= No) |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | OBSERVATION_TYPE |
|---|---|
| Seq. Order | 23 |
| Data Storage Type | NVARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Count and size, count only, presence/absence only |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LW_A_PIFSC |
|---|---|
| Seq. Order | 24 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LW_B_PIFSC |
|---|---|
| Seq. Order | 25 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LEN_TYPE_PIFSC |
|---|---|
| Seq. Order | 26 |
| Data Storage Type | NVARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | SLTLRAT_PIFSC |
|---|---|
| Seq. Order | 27 |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FLTLRAT_PIFSC |
|---|---|
| Seq. Order | 28 |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | LEN_CONV_FACTOR |
|---|---|
| Seq. Order | 29 |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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). |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TROPHIC |
|---|---|
| Seq. Order | 30 |
| Data Storage Type | VARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| 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 |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | TROPHIC_MONREP |
|---|---|
| Seq. Order | 31 |
| Data Storage Type | NVARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Trophic level scheme used |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | NULL |
| Null Value Meaning |
Trophic level scheme not designated for the taxon |
| Allowed Values | PISCIVORE, PLANKTIVORE, PRIMARY, SECONDARY |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FISH_COUNT |
|---|---|
| Seq. Order | 32 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 5 |
| Scale | 0 |
| Status | Active |
| Description |
Number of fish observed during survey |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | FISH_LENGTH |
|---|---|
| Seq. Order | 33 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | DATA_TYPE |
|---|---|
| Seq. Order | 34 |
| Data Storage Type | VARCHAR2 |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | Instantaneous, Non-instantaneous, Non-instantaneous 5-10, Non-instantaneous 10-15, Non-instantaneous 15+, Presence |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | BIOMASS_PER_RECORD_G |
|---|---|
| Seq. Order | 35 |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | BIOMASS_PER_RECORD_G_PER_M2 |
|---|---|
| Seq. Order | 36 |
| Data Storage Type | NUMBER |
| Max Length | |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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. |
| General Data Type | |
| Unit of Measure | |
| Case Restriction | |
| Display Example | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
| Attribute Name | |
|---|---|
| Seq. Order | |
| Data Storage Type | |
| Max Length | |
| Precision | |
| Scale | |
| Required | |
| Primary Key | |
| Status | |
| Description | |
| General Data Type | |
| Case Restriction | |
| Format Mask | |
| Null Value | |
| Null Value Meaning | |
| Min Length | |
| Unit of Measure | |
| Display Example | |
| Allowed Values | |
| Default Value | |
| Foreign Key Relations | |
| Derivation | |
| Validation Rules |
Support Roles
» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
| * » Support Role | |
|---|---|
| * » Date Effective From | |
| Date Effective To | |
| * » Contact | |
| * Contact Instructions |
Extents
| Currentness Reference |
|---|
Extent Group 1
| Extent Description |
|---|
Extent Group 1 / Geographic Area
| * » W° Bound | |
|---|---|
| * » E° Bound | |
| * » N° Bound | |
| * » S° Bound | |
| * » Description |
Extent Group 1 / Vertical Extent
| EPSG Code | |
|---|---|
| Vertical Minimum | |
| Vertical Maximum |
Extent Group 1 / Time Frame
| * » Time Frame Type | |
|---|---|
| * » Start | |
| End | |
| Alternate Start as of Info | |
| Alternate End as of Info | |
| Description |
Access Information
| * » Security Class | |
|---|---|
| * Security Classification System |
|
| Security Handling Description |
|
| • Data Access Policy |
|
| » Data Access Procedure |
|
| • » Data Access Constraints |
|
| • Data Use Constraints |
|
| Metadata Access Constraints |
|
| Metadata Use Constraints |
|
Distribution Information
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
| Start Date | |
|---|---|
| End Date | |
| » Download URL | |
| Distributor | |
| File Name | |
| Description | |
| File Date/Time | |
| File Type | |
| FGDC Content Type | |
| File Size | |
| Application Version | |
| Compression | |
| Review Status |
Activity Log
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
| Activity Time | |
|---|---|
| Activity Type | |
| Responsible Party | |
| Description |
Issues
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
| Issue Date | |
|---|---|
| Author | |
| Issue |
FAQs
| Date | |
|---|---|
| Author | |
| Question | |
| Answer |
Child Items
Rubric scores updated every 15m
| Score | Type | Title |
|---|---|---|
Related Items
| Item Type | Relationship Type | Title |
|---|---|---|
Catalog Details
| Catalog Item ID | 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 Workflow State | Published / External |
| Metadata Last Review Date | 2021-04-14 |
| Metadata Review Frequency | 1 Year |
| Metadata Next Review Date | 2022-04-14 |
| Tags |
|---|