View: VS_FISH_TDS
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:35764 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | View: VS_FISH_TDS |
---|---|
Short Name: | VS_FISH_TDS |
Status: | Completed |
Abstract: |
CREP Fish Towed-Diver Survey spatial view |
Notes: |
Loaded by batch 9491, 11-14-2016 14:54 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | GISDAT |
Description: |
CRED Fish Towed Diver Survey spatial view |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
OBJECTID | NUMBER | Primary key for the fish tow data table | |
100
|
ROUNDID | NUMBER | Unique Identifier for ROUND record | |
100
|
MISSIONID | VARCHAR2 | Mission Identifier | |
100
|
REGION_NAME | VARCHAR2 | One of the five Pacific Island regions CRED surveys | |
100
|
ISLAND | NVARCHAR2 | Foreign key reference to the LIST_OF_ISLANDS table for the given ISLANDVISIT record | |
100
|
LATITUDE | NUMBER | Latitude in decimal degrees, WGS84, for the given island | |
100
|
LONGITUDE | NUMBER | Longitude in decimal degrees, WGS84 for the given island | |
100
|
OBS_YEAR | NUMBER | Year the survey was conducted | |
100
|
DIVEID | NUMBER | Unique ID representing year, month, day, tow # of day | |
100
|
SEGMENTID | NUMBER | Unique ID representing year, month, day, tow # of day, segment # | |
100
|
DATE_ | DATE | Date of the Tow survey | |
100
|
REEF_ZONE | NVARCHAR2 | The reef zone for the given towed diver segment (Forereef, Backreef, Lagoon, unspecified). Forereef: The sloping bottom underlying the wave break zone, extending seaward from the reef crest. Comprehensive surveys of forereef habitats remain the priority for towed-diver operations. Backreef: The shallow strip of reef sheltered from breaking waves by the reef crest, situated between the reef crest and the lagoon floor. Lagoon: The zone sheltered from the waves by the reef crest, and separated from the reef crest by the back reef. Usually deeper than the back reef and covered in unconsolidated sediment, this term describes both an atoll's interior and the expanse situated between the back reef and shore of any islands present. Unspecified: these are other areas surveyed using towed-diver methods, which include: Bank: A submerged platform reef, often occurring either as an isolated feature atop a seamount or as a plateau situated between the fore reef and a deeper slope. These areas are no longer actively targeted, with Pathfinder Reef (MARAMP 2007, CNMI) and Tutuila (ASRAMP 2010; exploratory) represents the last banks actively surveyed. Channel: A submerged transition between forereef and backreef zones created by a gap in the reef crest. Divers should avoid using channels to transition from forereef to backreef habitats (i.e. stick with one or the other). In addition, divers should make a note in the ¿Comments¿ section whenever crossing a channel along a forereef/backreef survey. | |
100
|
DIVER1 | NVARCHAR2 | Initials of fish diver | |
100
|
DIVER2 | NVARCHAR2 | Initials of benthic diver | |
100
|
TOWKEY | NUMBER | Towkey for the given towed diver survey fish observation | |
100
|
SEGMENT | NUMBER | Segments represent 5-minute increments; there are 10 segments per tow. | |
100
|
DEPTH | NUMBER | Mean Depth (in meters) of the towed-diver segment | |
100
|
DEPTH_SD | NUMBER | Standard deviation of depth of the towed-diver segment | |
100
|
TEMPERATURE | NUMBER | Temperature of the Towed Diver Survey | |
100
|
TEMPERATURE_SD | NUMBER | Standard deviation of temperature of the Towed Diver Survey | |
100
|
STARTLOCALTIME | VARCHAR2 | Local start time of the Towed Diver Survey | |
100
|
ENDLOCALTIME | VARCHAR2 | Local end time of the Towed Diver Survey | |
100
|
CENTROIDLAT | NUMBER | Latitude in decimal degrees, WGS84, for the center point of each 5-minute towed-diver survey segment | |
100
|
CENTROIDLON | NUMBER | Longitude in decimal degrees, WGS84, for the center point of each 5-minute towed-diver survey segment | |
100
|
PROJECTEDLENGTH | NUMBER | Length of tow segment (meters). Calculated from tow tracks using GIS | |
100
|
FAMILY | NVARCHAR2 | Taxonomic family classification | |
100
|
COMMONFAMILYALL | NVARCHAR2 | Common name of all families | |
100
|
TAXONNAME | NVARCHAR2 | Scientific name | |
100
|
COMMONNAME | NVARCHAR2 | Common name (from FishBase) | |
100
|
SPECIES | NVARCHAR2 | Species observed during the fish towed diver survey | |
100
|
COUNT | NUMBER | Number of fish observed for that segment | |
100
|
SIZE_ | 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
|
LW_A | NUMBER | Parameter "a" used in length-weight calculations | |
100
|
LW_B | NUMBER | Parameter "b" used in length-weight calculations | |
100
|
LENGTH_CONVERSION_FACTOR | NUMBER | Factor to convert length as total length by to get it to right form (SL or FL or TL) for available length weight A and B parameters for this species. Weight per fish is calculated as W(g)=LW A * ((TL(cm)*Length Conversion Factor) <sup>LW B</sup>) | |
100
|
TROPHIC | NVARCHAR2 | Trophic level: APEX (apex predator), Cor (corallivore), H (herbivore), MI (mobile invertivore), Om (Omnivore), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), Z (zooplantivore) | |
100
|
CONSUMER_GROUP | NVARCHAR2 | Trophic level scheme used (Primary Consumer, Secondary Consumer, Planktivore, Piscivore).*Note: Primary Consumers are all Herbivores and Deteritivores. Piscivores are species that primarily eat other fishes. Secondary Consumers are Omnivores and Invertivores | |
100
|
COMMENT_ | NVARCHAR2 | Comment for the fish tow data |
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: |
Primary key for the fish tow data table |
ROUNDID
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 28 |
Scale: | 0 |
Status: | Active |
Description: |
Unique Identifier for ROUND record |
MISSIONID
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Mission Identifier |
REGION_NAME
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
One of the five Pacific Island regions CRED surveys |
ISLAND
Seq. Order: | 5 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 90 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Foreign key reference to the LIST_OF_ISLANDS table for the given ISLANDVISIT record |
LATITUDE
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Latitude in decimal degrees, WGS84, for the given island |
LONGITUDE
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Longitude in decimal degrees, WGS84 for the given island |
OBS_YEAR
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 28 |
Scale: | 0 |
Status: | Active |
Description: |
Year the survey was conducted |
DIVEID
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique ID representing year, month, day, tow # of day |
SEGMENTID
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Unique ID representing year, month, day, tow # of day, segment # |
DATE_
Seq. Order: | 11 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date of the Tow survey |
REEF_ZONE
Seq. Order: | 12 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
The reef zone for the given towed diver segment (Forereef, Backreef, Lagoon, unspecified). Forereef: The sloping bottom underlying the wave break zone, extending seaward from the reef crest. Comprehensive surveys of forereef habitats remain the priority for towed-diver operations. Backreef: The shallow strip of reef sheltered from breaking waves by the reef crest, situated between the reef crest and the lagoon floor. Lagoon: The zone sheltered from the waves by the reef crest, and separated from the reef crest by the back reef. Usually deeper than the back reef and covered in unconsolidated sediment, this term describes both an atoll's interior and the expanse situated between the back reef and shore of any islands present. Unspecified: these are other areas surveyed using towed-diver methods, which include: Bank: A submerged platform reef, often occurring either as an isolated feature atop a seamount or as a plateau situated between the fore reef and a deeper slope. These areas are no longer actively targeted, with Pathfinder Reef (MARAMP 2007, CNMI) and Tutuila (ASRAMP 2010; exploratory) represents the last banks actively surveyed. Channel: A submerged transition between forereef and backreef zones created by a gap in the reef crest. Divers should avoid using channels to transition from forereef to backreef habitats (i.e. stick with one or the other). In addition, divers should make a note in the ¿Comments¿ section whenever crossing a channel along a forereef/backreef survey. |
DIVER1
Seq. Order: | 13 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Initials of fish diver |
DIVER2
Seq. Order: | 14 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Initials of benthic diver |
TOWKEY
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Towkey for the given towed diver survey fish observation |
SEGMENT
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 28 |
Scale: | 0 |
Status: | Active |
Description: |
Segments represent 5-minute increments; there are 10 segments per tow. |
DEPTH
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Mean Depth (in meters) of the towed-diver segment |
DEPTH_SD
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Standard deviation of depth of the towed-diver segment |
TEMPERATURE
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Temperature of the Towed Diver Survey |
TEMPERATURE_SD
Seq. Order: | 20 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
Standard deviation of temperature of the Towed Diver Survey |
STARTLOCALTIME
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 27 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local start time of the Towed Diver Survey |
ENDLOCALTIME
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 27 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local end time of the Towed Diver Survey |
CENTROIDLAT
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 8 |
Status: | Active |
Description: |
Latitude in decimal degrees, WGS84, for the center point of each 5-minute towed-diver survey segment |
CENTROIDLON
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 8 |
Status: | Active |
Description: |
Longitude in decimal degrees, WGS84, for the center point of each 5-minute towed-diver survey segment |
PROJECTEDLENGTH
Seq. Order: | 25 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Length of tow segment (meters). Calculated from tow tracks using GIS |
FAMILY
Seq. Order: | 26 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Taxonomic family classification |
COMMONFAMILYALL
Seq. Order: | 27 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Common name of all families |
TAXONNAME
Seq. Order: | 28 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 765 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Scientific name |
COMMONNAME
Seq. Order: | 29 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Common name (from FishBase) |
SPECIES
Seq. Order: | 30 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Species observed during the fish towed diver survey |
COUNT
Seq. Order: | 31 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Number of fish observed for that segment |
SIZE_
Seq. Order: | 32 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 0 |
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. |
LW_A
Seq. Order: | 33 |
---|---|
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 |
LW_B
Seq. Order: | 34 |
---|---|
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 |
LENGTH_CONVERSION_FACTOR
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Factor to convert length as total length by to get it to right form (SL or FL or TL) for available length weight A and B parameters for this species. Weight per fish is calculated as W(g)=LW A * ((TL(cm)*Length Conversion Factor) <sup>LW B</sup>) |
TROPHIC
Seq. Order: | 36 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Trophic level: APEX (apex predator), Cor (corallivore), H (herbivore), MI (mobile invertivore), Om (Omnivore), Pisc (piscivore), Pk (planktivore), SI (sessile invertivore), Z (zooplantivore) |
CONSUMER_GROUP
Seq. Order: | 37 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Trophic level scheme used (Primary Consumer, Secondary Consumer, Planktivore, Piscivore).*Note: Primary Consumers are all Herbivores and Deteritivores. Piscivores are species that primarily eat other fishes. Secondary Consumers are Omnivores and Invertivores |
COMMENT_
Seq. Order: | 38 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comment for the fish tow data |
Catalog Details
Catalog Item ID: | 35764 |
---|---|
GUID: | gov.noaa.nmfs.inport:35764 |
Metadata Record Created By: | Troy T Kanemura |
Metadata Record Created: | 2016-11-21 18:44+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2017-09-11 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2017-09-11 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2018-09-11 |