View: VS_BENT_TDS
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:35770 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | View: VS_BENT_TDS |
---|---|
Short Name: | VS_BENT_TDS |
Status: | Completed |
Abstract: |
CREP Benthic Towed-Diver Survey spatial view |
Notes: |
Loaded by batch 9510, 11-21-2016 14:37 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | GISDAT |
Description: |
Benthic towed-diver survey spatial view |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
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
|
METHODCODE | NVARCHAR2 | Survey method used | |
100
|
NO_OBS | NUMBER | No data recorded for a towed-diver survey due to diver recall, hazardous conditions, depth, etc. | |
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 | DATE | Local start time of the Towed Diver Survey | |
100
|
ENDLOCALTIME | DATE | 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
|
DOMINANT_HABITAT | NVARCHAR2 | Dominant Habitat | |
100
|
DOMINANT_HABITAT_DESC | NVARCHAR2 | Dominant Habitat description | |
100
|
COMPLEXITY | NVARCHAR2 | Complexity | |
100
|
LIVE_CORAL_MID | NUMBER | Live coral mid-point | |
100
|
SOFT_CORAL_MID | NUMBER | Soft coral mid-point | |
100
|
SAND_MID | NUMBER | Sand mid-point | |
100
|
STRESSED_CORAL_MID | NUMBER | Stressed coral mid-point | |
100
|
MACROALGAE_MID | NUMBER | Macro algae mid-point | |
100
|
CORALLINE_MID | NUMBER | Coralline algae mid-point | |
100
|
CROWN_OF_THORN | NUMBER | Acanthaster planci. Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000 | |
100
|
BORING_URCHIN | NUMBER | "Boring" sea urchins (e.g. Echinostrephus, Echinometra). Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000 | |
100
|
FREE_URCHIN | NUMBER | "Free" sea urchins (e.g. Tripneustes, Diadema). Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000 | |
100
|
GIANT_CLAM | NUMBER | Giant clams (Tridacna sp.). Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000 | |
100
|
NET_LINE | NUMBER | Derelict fishing gear of any type (e.g. monofilament line, fishing nets or fragments of fishing nets, etc.) | |
100
|
MUNITION | NUMBER | Munitions/unexploded ordinance | |
100
|
WRECK | NUMBER | Shipwrecks | |
100
|
MANMADE_OBJECT | NUMBER | Man-made objects, whether of nautical or terrestrial origins (e.g. anchors/discarded mooring, tires, corrugated tin roofing). It is important to note that marine debris observations do not include highly mobile marine debris (e.g. bottles, cans, plastic bags, etc.) | |
100
|
MANMADE_NOTE | NVARCHAR2 | Manmade Note |
Attribute Details
ROUNDID
Seq. Order: | 1 |
---|---|
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: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 30 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Mission Identifier |
REGION_NAME
Seq. Order: | 3 |
---|---|
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: | 4 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Foreign key reference to the LIST_OF_ISLANDS table for the given ISLANDVISIT record |
LATITUDE
Seq. Order: | 5 |
---|---|
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: | 6 |
---|---|
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: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | Yes |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
Year the survey was conducted |
DIVEID
Seq. Order: | 8 |
---|---|
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: | 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, segment # |
DATE_
Seq. Order: | 10 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Date of the Tow survey |
REEF_ZONE
Seq. Order: | 11 |
---|---|
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. |
METHODCODE
Seq. Order: | 12 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Survey method used |
NO_OBS
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 0 |
Status: | Active |
Description: |
No data recorded for a towed-diver survey due to diver recall, hazardous conditions, depth, etc. |
DIVER1
Seq. Order: | 14 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Initials of fish diver |
DIVER2
Seq. Order: | 15 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Initials of benthic diver |
TOWKEY
Seq. Order: | 16 |
---|---|
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: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Segments represent 5-minute increments; there are 10 segments per tow. |
DEPTH
Seq. Order: | 18 |
---|---|
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: | 19 |
---|---|
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: | 20 |
---|---|
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: | 21 |
---|---|
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: | 22 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local start time of the Towed Diver Survey |
ENDLOCALTIME
Seq. Order: | 23 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local end time of the Towed Diver Survey |
CENTROIDLAT
Seq. Order: | 24 |
---|---|
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: | 25 |
---|---|
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: | 26 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Scale: | 8 |
Status: | Active |
Description: |
Length of tow segment (meters). Calculated from tow tracks using GIS |
DOMINANT_HABITAT
Seq. Order: | 27 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Dominant Habitat |
DOMINANT_HABITAT_DESC
Seq. Order: | 28 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 150 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Dominant Habitat description |
COMPLEXITY
Seq. Order: | 29 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 9 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Complexity |
LIVE_CORAL_MID
Seq. Order: | 30 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Live coral mid-point |
SOFT_CORAL_MID
Seq. Order: | 31 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Soft coral mid-point |
SAND_MID
Seq. Order: | 32 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Sand mid-point |
STRESSED_CORAL_MID
Seq. Order: | 33 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Stressed coral mid-point |
MACROALGAE_MID
Seq. Order: | 34 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Macro algae mid-point |
CORALLINE_MID
Seq. Order: | 35 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 28 |
Scale: | 8 |
Status: | Active |
Description: |
Coralline algae mid-point |
CROWN_OF_THORN
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Acanthaster planci. Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000 |
BORING_URCHIN
Seq. Order: | 37 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
"Boring" sea urchins (e.g. Echinostrephus, Echinometra). Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000 |
FREE_URCHIN
Seq. Order: | 38 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
"Free" sea urchins (e.g. Tripneustes, Diadema). Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000 |
GIANT_CLAM
Seq. Order: | 39 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Giant clams (Tridacna sp.). Macroinvertebrates are counted independently up to 25 individuals. Above that, numbers of each macroinvertebrate taxa are binned as follows: Category 1: 26 - 50 (1 with a circle around it; same for subsequent categories). Category 2: 51 - 100. Category 3: 101 - 250. Category 4: 251 - 500. Category 5: 501 - 1000. Category 6: > 1000 |
NET_LINE
Seq. Order: | 40 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Derelict fishing gear of any type (e.g. monofilament line, fishing nets or fragments of fishing nets, etc.) |
MUNITION
Seq. Order: | 41 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Munitions/unexploded ordinance |
WRECK
Seq. Order: | 42 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Shipwrecks |
MANMADE_OBJECT
Seq. Order: | 43 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Man-made objects, whether of nautical or terrestrial origins (e.g. anchors/discarded mooring, tires, corrugated tin roofing). It is important to note that marine debris observations do not include highly mobile marine debris (e.g. bottles, cans, plastic bags, etc.) |
MANMADE_NOTE
Seq. Order: | 44 |
---|---|
Data Storage Type: | NVARCHAR2 |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Manmade Note |
Catalog Details
Catalog Item ID: | 35770 |
---|---|
GUID: | gov.noaa.nmfs.inport:35770 |
Metadata Record Created By: | Troy T Kanemura |
Metadata Record Created: | 2016-11-21 19:45+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2017-03-16 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2017-03-16 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2018-03-16 |