View: VS_FISH_TDS
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 35764
| Published / External
Created: 2016-11-21
|
Last Modified: 2022-08-09
Parent: National Coral Reef Monitoring Program: Towed-diver Surveys of Large-bodied Fishes of the Marianas since 2014
Data Set (DS) | ID: 35762
Data Set (DS) | ID: 35762
ID: 35764
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
| * » Title | View: VS_FISH_TDS |
|---|---|
| Short Name | VS_FISH_TDS |
| * Status | Completed |
| Creation Date | |
| Revision Date | |
| • Publication Date | |
| * » Abstract |
CREP Fish Towed-Diver Survey spatial view |
| * Purpose | |
| Notes |
Loaded by batch 9491, 11-14-2016 14:54 |
| 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 | GISDAT |
| » Description |
CRED Fish Towed Diver Survey spatial view |
| Change Summary |
Data Attributes
Attribute Summary
| Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
|---|---|---|---|---|---|
| 100 | Yes | No | OBJECTID | NUMBER | Primary key for the fish tow data table |
| 100 | Yes | No | ROUNDID | NUMBER | Unique Identifier for ROUND record |
| 100 | Yes | No | MISSIONID | VARCHAR2 | Mission Identifier |
| 100 | No | No | REGION_NAME | VARCHAR2 | One of the five Pacific Island regions CRED surveys |
| 100 | Yes | No | ISLAND | NVARCHAR2 | Foreign key reference to the LIST_OF_ISLANDS table for the given ISLANDVISIT record |
| 100 | No | No | LATITUDE | NUMBER | Latitude in decimal degrees, WGS84, for the given island |
| 100 | No | No | LONGITUDE | NUMBER | Longitude in decimal degrees, WGS84 for the given island |
| 100 | Yes | No | OBS_YEAR | NUMBER | Year the survey was conducted |
| 100 | No | No | DIVEID | NUMBER | Unique ID representing year, month, day, tow # of day |
| 100 | No | No | SEGMENTID | NUMBER | Unique ID representing year, month, day, tow # of day, segment # |
| 100 | Yes | No | DATE_ | DATE | Date of the Tow survey |
| 100 | Yes | No | 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 | Yes | No | DIVER1 | NVARCHAR2 | Initials of fish diver |
| 100 | No | No | DIVER2 | NVARCHAR2 | Initials of benthic diver |
| 100 | Yes | No | TOWKEY | NUMBER | Towkey for the given towed diver survey fish observation |
| 100 | Yes | No | SEGMENT | NUMBER | Segments represent 5-minute increments; there are 10 segments per tow. |
| 100 | No | No | DEPTH | NUMBER | Mean Depth (in meters) of the towed-diver segment |
| 100 | No | No | DEPTH_SD | NUMBER | Standard deviation of depth of the towed-diver segment |
| 100 | No | No | TEMPERATURE | NUMBER | Temperature of the Towed Diver Survey |
| 100 | No | No | TEMPERATURE_SD | NUMBER | Standard deviation of temperature of the Towed Diver Survey |
| 100 | No | No | STARTLOCALTIME | VARCHAR2 | Local start time of the Towed Diver Survey |
| 100 | No | No | ENDLOCALTIME | VARCHAR2 | Local end time of the Towed Diver Survey |
| 100 | No | No | CENTROIDLAT | NUMBER | Latitude in decimal degrees, WGS84, for the center point of each 5-minute towed-diver survey segment |
| 100 | No | No | CENTROIDLON | NUMBER | Longitude in decimal degrees, WGS84, for the center point of each 5-minute towed-diver survey segment |
| 100 | No | No | PROJECTEDLENGTH | NUMBER | Length of tow segment (meters). Calculated from tow tracks using GIS |
| 100 | No | No | FAMILY | NVARCHAR2 | Taxonomic family classification |
| 100 | No | No | COMMONFAMILYALL | NVARCHAR2 | Common name of all families |
| 100 | Yes | No | TAXONNAME | NVARCHAR2 | Scientific name |
| 100 | No | No | COMMONNAME | NVARCHAR2 | Common name (from FishBase) |
| 100 | Yes | No | SPECIES | NVARCHAR2 | Species observed during the fish towed diver survey |
| 100 | No | No | COUNT | NUMBER | Number of fish observed for that segment |
| 100 | No | No | 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 | No | No | LW_A | NUMBER | Parameter "a" used in length-weight calculations |
| 100 | No | No | LW_B | NUMBER | Parameter "b" used in length-weight calculations |
| 100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | COMMENT_ | NVARCHAR2 | Comment for the fish tow data |
Attribute Details
| Attribute Name | OBJECTID |
|---|---|
| Seq. Order | 1 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | 38 |
| Scale | 0 |
| Status | Active |
| Description |
Primary key for the fish tow data table |
| 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 | ROUNDID |
|---|---|
| Seq. Order | 2 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | 28 |
| Scale | 0 |
| Status | Active |
| Description |
Unique Identifier for ROUND record |
| 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 | MISSIONID |
|---|---|
| Seq. Order | 3 |
| Data Storage Type | VARCHAR2 |
| Max Length | 30 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Mission 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 | REGION_NAME |
|---|---|
| Seq. Order | 4 |
| Data Storage Type | VARCHAR2 |
| Max Length | 30 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
One of the five Pacific Island regions CRED surveys |
| 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 | ISLAND |
|---|---|
| Seq. Order | 5 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 90 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Foreign key reference to the LIST_OF_ISLANDS table for the given ISLANDVISIT record |
| 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 | No |
| Primary Key | No |
| Precision | 28 |
| Scale | 8 |
| Status | Active |
| Description |
Latitude in decimal degrees, WGS84, for the given island |
| 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 | LONGITUDE |
|---|---|
| Seq. Order | 7 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 28 |
| Scale | 8 |
| Status | Active |
| Description |
Longitude in decimal degrees, WGS84 for the given island |
| 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 | OBS_YEAR |
|---|---|
| Seq. Order | 8 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | 28 |
| Scale | 0 |
| Status | Active |
| Description |
Year 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 | DIVEID |
|---|---|
| Seq. Order | 9 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Unique ID representing year, month, day, tow # of day |
| 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 | SEGMENTID |
|---|---|
| Seq. Order | 10 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Unique ID representing year, month, day, tow # of day, segment # |
| 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 | DATE_ |
|---|---|
| Seq. Order | 11 |
| Data Storage Type | DATE |
| Max Length | 7 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Date of the Tow 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 | REEF_ZONE |
|---|---|
| Seq. Order | 12 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| 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. |
| 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 | DIVER1 |
|---|---|
| Seq. Order | 13 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Initials of fish diver |
| 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 | DIVER2 |
|---|---|
| Seq. Order | 14 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Initials of benthic diver |
| 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 | TOWKEY |
|---|---|
| Seq. Order | 15 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | 38 |
| Scale | 0 |
| Status | Active |
| Description |
Towkey for the given towed diver survey fish observation |
| 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 | SEGMENT |
|---|---|
| Seq. Order | 16 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | 28 |
| Scale | 0 |
| Status | Active |
| Description |
Segments represent 5-minute increments; there are 10 segments per tow. |
| 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 | DEPTH |
|---|---|
| Seq. Order | 17 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Mean Depth (in meters) of the towed-diver segment |
| 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 | DEPTH_SD |
|---|---|
| Seq. Order | 18 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Standard deviation of depth of the towed-diver segment |
| 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 | TEMPERATURE |
|---|---|
| Seq. Order | 19 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Temperature of the Towed Diver 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 | TEMPERATURE_SD |
|---|---|
| Seq. Order | 20 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | |
| Status | Active |
| Description |
Standard deviation of temperature of the Towed Diver 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 | STARTLOCALTIME |
|---|---|
| Seq. Order | 21 |
| Data Storage Type | VARCHAR2 |
| Max Length | 27 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Local start time of the Towed Diver 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 | ENDLOCALTIME |
|---|---|
| Seq. Order | 22 |
| Data Storage Type | VARCHAR2 |
| Max Length | 27 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Local end time of the Towed Diver 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 | CENTROIDLAT |
|---|---|
| Seq. Order | 23 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| 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 | CENTROIDLON |
|---|---|
| Seq. Order | 24 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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 |
| 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 | PROJECTEDLENGTH |
|---|---|
| Seq. Order | 25 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Length of tow segment (meters). Calculated from tow tracks using GIS |
| 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 |
|---|---|
| Seq. Order | 26 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Taxonomic family classification |
| 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 | COMMONFAMILYALL |
|---|---|
| Seq. Order | 27 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Common name of all families |
| 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 | TAXONNAME |
|---|---|
| Seq. Order | 28 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 765 |
| Min Length | |
| Required | Yes |
| 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 | COMMONNAME |
|---|---|
| Seq. Order | 29 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Common name (from FishBase) |
| 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 | SPECIES |
|---|---|
| Seq. Order | 30 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | Yes |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Species observed during the fish towed diver 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 | COUNT |
|---|---|
| Seq. Order | 31 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | 38 |
| Scale | 0 |
| Status | Active |
| Description |
Number of fish observed for that segment |
| 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 | SIZE_ |
|---|---|
| Seq. Order | 32 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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. |
| 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_A |
|---|---|
| Seq. Order | 33 |
| 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 |
| 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 |
|---|---|
| Seq. Order | 34 |
| 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 |
| 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 | LENGTH_CONVERSION_FACTOR |
|---|---|
| Seq. Order | 35 |
| Data Storage Type | NUMBER |
| Max Length | 22 |
| Min Length | |
| 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>) |
| 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 | 36 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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) |
| 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 | CONSUMER_GROUP |
|---|---|
| Seq. Order | 37 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| 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 |
| 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 | COMMENT_ |
|---|---|
| Seq. Order | 38 |
| Data Storage Type | NVARCHAR2 |
| Max Length | 150 |
| Min Length | |
| Required | No |
| Primary Key | No |
| Precision | |
| Scale | |
| Status | Active |
| Description |
Comment for the fish tow data |
| 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 | 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 Workflow State | Published / External |
| Metadata Last Review Date | 2017-09-11 |
| Metadata Review Frequency | 1 Year |
| Metadata Next Review Date | 2018-09-11 |
| Tags |
|---|