Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Entities for marine debris data from the underwater surveys

Description

Materialized view containing marine debris data

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
MISSION
VARCHAR2
Mission or Cruise
VESSEL
VARCHAR2
Vessel or Vehicle the mission was conducted from. In the case of ship-based mission, this is the parent vessel.
PRIMARY_PURPOSE
VARCHAR2
Values=LAND REMOVAL, MARINE REMOVAL, AERIAL SURVEY, NO_DATA, indicates type of survey. "Land" surveys were depricated from this table after 2/2013
REGION_CODE
VARCHAR2
Descriptive Region Code, Currently: MHI = Main Hawaiian Islands, NWHI = Northwest Hawaiian Islands/Papahanaumamakuakea National Monument
REGION_DESC
VARCHAR2
Long Description of Region
LOCATION_CODE
VARCHAR2
Descriptive 3 digit code for the island or atoll work was conducted at. FFS: French Frigate Shoals KUR: Kure Atoll MAR: Maro Reef PHR: Pearl and Hermes Atoll LIS: Lisianski Island MID: Midway Atoll
LOCATION
VARCHAR2
Full LOCATION
LOCATION_LONG
VARCHAR2
Full LOCATION and Region
LOAD_NUM
NUMBER
Sequential value for each daily load (per small boat) beginning with 1. For example, We have four small boats conducting removals (MD1, MD2, MD3 and MD4). Each of these four boats will have a load 1. If any of them go back out for a second load, only that boat would have a load #2.
LATITUDE
NUMBER
Latitude of individual DFG (net) point from GPS waypoint. This lat/long information is associated with the individual DFG net point that all net-associated data corresponds to.
LONGITUDE
NUMBER
Longitude of individual DFG (net) point from GPS waypoint
SOURCE
VARCHAR2
Where debris is recovered from, either LAND (shoreline) or WATER (from the reefs)
WEIGHTLOAD_KG
NUMBER
Unit=Kilograms. Weight of debris load (boat-load). This is NOT the weight of this DFG net point, but the weight of the larger load that includes this DFG net point and other DFG points removed by that boat that day. This entity added for use in 2003
GPS_FILE_DATE
DATE
Date the spatial data on GPS unit was collected (typically the date the survey was completed)
SURVEY_TOW
VARCHAR2
Values: YES, NO, NO_DATA, indicates if survey was completed by divers being towed behind a vessel
SURVEY_SWIM
VARCHAR2
Values: YES, NO, NO_DATA, indicates if survey was completed by divers swimming
LAND_OPS
VARCHAR2
Values: YES, NO, NO_DATA, indicates if survey was completed by participants on land (shoreline). Generally used for opportunistic shoreline removals of DFG on same day as an in-water survey
VISIBILITY_START_M
NUMBER
Units=Meters, Measured Value This is a measure of underwater visibility at the start of each day in the area surveyed. It can be considered the limit at which a fishing net can be seen underwater. A visibility measurement is taken once in the morning before surveys, and once at the end of the day after surveys are complete. A 1ftx1ft piece of green trawl/seine net is attached to a measuring tape and two divers swim apart until the limit of visibility of the net is reached. That data is then recorded.
VISIBILITY_END_M
NUMBER
Units=Meters, Measured Value This is a measure of underwater visibility at the end of each day in the area surveyed. It can be considered the limit at which a fishing net can be seen underwater. A visibility measurement is taken once in the morning before surveys, and once at the end of the day after surveys are complete. A 1ftx1ft piece of green trawl/seine net is attached to a measuring tape and two divers swim apart until the limit of visibility of the net is reached. That data is then recorded.
SURVEY_TYPE
VARCHAR2
Type of Survey Conducted. Values: NON_SURVEY, LAND, SWIM, TOW, and NO_DATA
OBS_LENGTH
NUMBER
Unit=meters, Length of DFG as found in the water, measured as longest 2 dimensional value. Measured to the nearest 0.05m
OBS_WIDTH
NUMBER
Unit=meters, Average width of DFG as found in the water, measured as shorter 2 dimensional value. Measured to the nearest 0.05m
OBS_HEIGHT
NUMBER
Unit=meters, Average height of DFG as found in the water, measured to the nearest 0.01m
REMOVED
VARCHAR2
Values: YES, NO, NO_DATA, (Blanks) This indicates if the DFG was removed from the water or land or left in place.
VOLUME_REMOVED
NUMBER
Unit=cubic meters,Volume of net physically removed from the water (volume estimated after pulled into the boat and consolidated into a pile. Does not reflect in-water LxWxH. Added as a data field for use in 2005
SIZE_CLASS
VARCHAR2
This entity depricated as of 3-2013, inconsistently used
DEPTH_M
NUMBER
Unit=meters: Average Depth of DFG as found in the water to the nearest 0.1m.
DEBRIS_TYPE
VARCHAR2
Expanded Name for Type of DFG
CONGLOMERATE
VARCHAR2
Is the Debris a mixture of DFG types? NO, YES, or NO_DATA
DEBRIS_TYPE_ORIGINAL
VARCHAR2
Original Debris TypeDesignations, Values generally: M: MONOFILAMENT GILLNET, F: TRAWL/SEINE, T: TRAWL (MULTIPANEL/COD END ONLY), R: MISC. LINE, H: HAWSER, L: LONGLINE, G: MULTIFILAMENT GILLNET, O: OTHER, NO_DATA, or SCRAP_METAL
DEBRIS_COLOR
VARCHAR2
Most Prominent Color of DFG. Value from Mar_Color.Color_Code column
FOUL_LEVEL
VARCHAR2
Values are NO_DATA, 1=0-25%, 2=26-50%, 3=51-75%, 4=76-100% Describing the level of bio-fouling on the surface of the DFG as found in the water. The percentage of the visible surface of the DFG that is fouled with bio-fouling.
PERCENT_REMOVED
NUMBER
% of total DFG physically removed and weighed. Note: sometimes all, or portions of, a given DFG net are left in place due to concerns of contributing to added coral damage.
CORAL_GROWTH
VARCHAR2
YES= Discernable Coral Growth has occured, NO= Discernable Coral Growth has not occured This refers to whether new coral growth has occurred in one of two ways: 1. Coral grows around the strands of DFG, encapsulating the DFG within the coral, or 2. New corals have recruited on top of the DFG, using it as a substrate for growth.
GROWTH_TYPE1
VARCHAR2
Indicates type of coral growth: R: RECRUITING, or E: ENCAPSULATED This refers to whether new coral growth has occurred in one of two ways: 1. Coral grows around the strands of DFG, encapsulating the DFG within the coral, or 2. New corals have recruited on top of the DFG, using it as a substrate for growth.
CORAL_GENERA1
VARCHAR2
Genera of coral that has encapsulated or recruited on the DFG if known. Generally, PP: POCILLOPORA, POR: PORITES, or MON: MONTIPORA
GROWTH_TYPE2
VARCHAR2
Indicates type of coral growth: R: RECRUITING, or E: ENCAPSULATED This refers to whether new coral growth has occurred in one of two ways: 1. Coral grows around the strands of DFG, encapsulating the DFG within the coral, or 2. New corals have recruited on top of the DFG, using it as a substrate for growth.
CORAL_GENERA2
VARCHAR2
Genera of coral that has encapsulated or recruited on the DFG if known. Generally, PP: POCILLOPORA, POR: PORITES, or MON: MONTIPORA
GROWTH_TYPE3
VARCHAR2
Indicates type of coral growth: R: RECRUITING, or E: ENCAPSULATED. This refers to whether new coral growth has occurred in one of two ways: 1. Coral grows around the strands of DFG, encapsulating the DFG within the coral, or 2. New corals have recruited on top of the DFG, using it as a substrate for growth.
CORAL_GENERA3
VARCHAR2
Genera of coral that has encapsulated or recruited on the DFG if known. Generally, PP: POCILLOPORA, POR: PORITES, or MON: MONTIPORA
PERCENT_SAND
NUMBER
Percentage of Substrate that is Sand (Using total of sand, live coral, algae, and coral cement as 100%) How to: using the length & width of the net/line as a visual gauge (planar perimeter), estimate a similar planar area on each side of net. The substrate to be characterized will be both the habitat in this extended area as well as underneath the net/line.
PERCENT_LIVE_CORAL
NUMBER
Percentage of Substrate that is Live Coral (Using total of sand, live coral, algae, and coral cement as 100%) How to: using the length & width of the net/line as a visual gauge (planar perimeter), estimate a similar planar area on each side of net. The substrate to be characterized will be both the habitat in this extended area as well as underneath the net/line.
PERCENT_ALGAE
NUMBER
Percentage of Substrate that is Macroalgae (Using total of sand, live coral, algae, and coral cement as 100%) How to: using the length & width of the net/line as a visual gauge (planar perimeter), estimate a similar planar area on each side of net. The substrate to be characterized will be both the habitat in this extended area as well as underneath the net/line.
PERCENT_CORAL_CEMENT
NUMBER
Percentage of Substrate that is Coral Cement aka reef pavement. (Using total of sand, live coral, algae, and coral cement as 100%) How to: using the length & width of the net/line as a visual gauge (planar perimeter), estimate a similar planar area on each side of net. The substrate to be characterized will be both the habitat in this extended area as well as underneath the net/line.
NOTES
VARCHAR2
Unusual observations about the DFG or its collection
SUBSTRATE_COLOR
VARCHAR2
Most Prominent Color of Substrate. Value from Mar_Color.Color_Code column

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Item Identification

Title: Marine Debris Entities from Underwater Surveys
Short Name: Marine Debris
Status: Completed
Abstract:

Entities for marine debris data from the underwater surveys

Notes:

Loaded by batch 9772, 02-17-2017 17:02

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: CRED_DEBRIS
Description:

Materialized view containing marine debris data

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
MISSION VARCHAR2 Mission or Cruise
100
VESSEL VARCHAR2 Vessel or Vehicle the mission was conducted from. In the case of ship-based mission, this is the parent vessel.
100
PRIMARY_PURPOSE VARCHAR2 Values=LAND REMOVAL, MARINE REMOVAL, AERIAL SURVEY, NO_DATA, indicates type of survey. "Land" surveys were depricated from this table after 2/2013
100
REGION_CODE VARCHAR2 Descriptive Region Code, Currently: MHI = Main Hawaiian Islands, NWHI = Northwest Hawaiian Islands/Papahanaumamakuakea National Monument
100
REGION_DESC VARCHAR2 Long Description of Region
100
LOCATION_CODE VARCHAR2 Descriptive 3 digit code for the island or atoll work was conducted at. FFS: French Frigate Shoals KUR: Kure Atoll MAR: Maro Reef PHR: Pearl and Hermes Atoll LIS: Lisianski Island MID: Midway Atoll
100
LOCATION VARCHAR2 Full LOCATION
100
LOCATION_LONG VARCHAR2 Full LOCATION and Region
100
LOAD_NUM NUMBER Sequential value for each daily load (per small boat) beginning with 1. For example, We have four small boats conducting removals (MD1, MD2, MD3 and MD4). Each of these four boats will have a load 1. If any of them go back out for a second load, only that boat would have a load #2.
100
LATITUDE NUMBER Latitude of individual DFG (net) point from GPS waypoint. This lat/long information is associated with the individual DFG net point that all net-associated data corresponds to.
100
LONGITUDE NUMBER Longitude of individual DFG (net) point from GPS waypoint
100
SOURCE VARCHAR2 Where debris is recovered from, either LAND (shoreline) or WATER (from the reefs)
100
WEIGHTLOAD_KG NUMBER Unit=Kilograms. Weight of debris load (boat-load). This is NOT the weight of this DFG net point, but the weight of the larger load that includes this DFG net point and other DFG points removed by that boat that day. This entity added for use in 2003
100
GPS_FILE_DATE DATE Date the spatial data on GPS unit was collected (typically the date the survey was completed)
100
SURVEY_TOW VARCHAR2 Values: YES, NO, NO_DATA, indicates if survey was completed by divers being towed behind a vessel
100
SURVEY_SWIM VARCHAR2 Values: YES, NO, NO_DATA, indicates if survey was completed by divers swimming
100
LAND_OPS VARCHAR2 Values: YES, NO, NO_DATA, indicates if survey was completed by participants on land (shoreline). Generally used for opportunistic shoreline removals of DFG on same day as an in-water survey
100
VISIBILITY_START_M NUMBER Units=Meters, Measured Value This is a measure of underwater visibility at the start of each day in the area surveyed. It can be considered the limit at which a fishing net can be seen underwater. A visibility measurement is taken once in the morning before surveys, and once at the end of the day after surveys are complete. A 1ftx1ft piece of green trawl/seine net is attached to a measuring tape and two divers swim apart until the limit of visibility of the net is reached. That data is then recorded.
100
VISIBILITY_END_M NUMBER Units=Meters, Measured Value This is a measure of underwater visibility at the end of each day in the area surveyed. It can be considered the limit at which a fishing net can be seen underwater. A visibility measurement is taken once in the morning before surveys, and once at the end of the day after surveys are complete. A 1ftx1ft piece of green trawl/seine net is attached to a measuring tape and two divers swim apart until the limit of visibility of the net is reached. That data is then recorded.
100
SURVEY_TYPE VARCHAR2 Type of Survey Conducted. Values: NON_SURVEY, LAND, SWIM, TOW, and NO_DATA
100
OBS_LENGTH NUMBER Unit=meters, Length of DFG as found in the water, measured as longest 2 dimensional value. Measured to the nearest 0.05m
100
OBS_WIDTH NUMBER Unit=meters, Average width of DFG as found in the water, measured as shorter 2 dimensional value. Measured to the nearest 0.05m
100
OBS_HEIGHT NUMBER Unit=meters, Average height of DFG as found in the water, measured to the nearest 0.01m
100
REMOVED VARCHAR2 Values: YES, NO, NO_DATA, (Blanks) This indicates if the DFG was removed from the water or land or left in place.
100
VOLUME_REMOVED NUMBER Unit=cubic meters,Volume of net physically removed from the water (volume estimated after pulled into the boat and consolidated into a pile. Does not reflect in-water LxWxH. Added as a data field for use in 2005
100
SIZE_CLASS VARCHAR2 This entity depricated as of 3-2013, inconsistently used
100
DEPTH_M NUMBER Unit=meters: Average Depth of DFG as found in the water to the nearest 0.1m.
100
DEBRIS_TYPE VARCHAR2 Expanded Name for Type of DFG
100
CONGLOMERATE VARCHAR2 Is the Debris a mixture of DFG types? NO, YES, or NO_DATA
100
DEBRIS_TYPE_ORIGINAL VARCHAR2 Original Debris TypeDesignations, Values generally: M: MONOFILAMENT GILLNET, F: TRAWL/SEINE, T: TRAWL (MULTIPANEL/COD END ONLY), R: MISC. LINE, H: HAWSER, L: LONGLINE, G: MULTIFILAMENT GILLNET, O: OTHER, NO_DATA, or SCRAP_METAL
100
DEBRIS_COLOR VARCHAR2 Most Prominent Color of DFG. Value from Mar_Color.Color_Code column
100
FOUL_LEVEL VARCHAR2 Values are NO_DATA, 1=0-25%, 2=26-50%, 3=51-75%, 4=76-100% Describing the level of bio-fouling on the surface of the DFG as found in the water. The percentage of the visible surface of the DFG that is fouled with bio-fouling.
100
PERCENT_REMOVED NUMBER % of total DFG physically removed and weighed. Note: sometimes all, or portions of, a given DFG net are left in place due to concerns of contributing to added coral damage.
100
CORAL_GROWTH VARCHAR2 YES= Discernable Coral Growth has occured, NO= Discernable Coral Growth has not occured This refers to whether new coral growth has occurred in one of two ways: 1. Coral grows around the strands of DFG, encapsulating the DFG within the coral, or 2. New corals have recruited on top of the DFG, using it as a substrate for growth.
100
GROWTH_TYPE1 VARCHAR2 Indicates type of coral growth: R: RECRUITING, or E: ENCAPSULATED This refers to whether new coral growth has occurred in one of two ways: 1. Coral grows around the strands of DFG, encapsulating the DFG within the coral, or 2. New corals have recruited on top of the DFG, using it as a substrate for growth.
100
CORAL_GENERA1 VARCHAR2 Genera of coral that has encapsulated or recruited on the DFG if known. Generally, PP: POCILLOPORA, POR: PORITES, or MON: MONTIPORA
100
GROWTH_TYPE2 VARCHAR2 Indicates type of coral growth: R: RECRUITING, or E: ENCAPSULATED This refers to whether new coral growth has occurred in one of two ways: 1. Coral grows around the strands of DFG, encapsulating the DFG within the coral, or 2. New corals have recruited on top of the DFG, using it as a substrate for growth.
100
CORAL_GENERA2 VARCHAR2 Genera of coral that has encapsulated or recruited on the DFG if known. Generally, PP: POCILLOPORA, POR: PORITES, or MON: MONTIPORA
100
GROWTH_TYPE3 VARCHAR2 Indicates type of coral growth: R: RECRUITING, or E: ENCAPSULATED. This refers to whether new coral growth has occurred in one of two ways: 1. Coral grows around the strands of DFG, encapsulating the DFG within the coral, or 2. New corals have recruited on top of the DFG, using it as a substrate for growth.
100
CORAL_GENERA3 VARCHAR2 Genera of coral that has encapsulated or recruited on the DFG if known. Generally, PP: POCILLOPORA, POR: PORITES, or MON: MONTIPORA
100
PERCENT_SAND NUMBER Percentage of Substrate that is Sand (Using total of sand, live coral, algae, and coral cement as 100%) How to: using the length & width of the net/line as a visual gauge (planar perimeter), estimate a similar planar area on each side of net. The substrate to be characterized will be both the habitat in this extended area as well as underneath the net/line.
100
PERCENT_LIVE_CORAL NUMBER Percentage of Substrate that is Live Coral (Using total of sand, live coral, algae, and coral cement as 100%) How to: using the length & width of the net/line as a visual gauge (planar perimeter), estimate a similar planar area on each side of net. The substrate to be characterized will be both the habitat in this extended area as well as underneath the net/line.
100
PERCENT_ALGAE NUMBER Percentage of Substrate that is Macroalgae (Using total of sand, live coral, algae, and coral cement as 100%) How to: using the length & width of the net/line as a visual gauge (planar perimeter), estimate a similar planar area on each side of net. The substrate to be characterized will be both the habitat in this extended area as well as underneath the net/line.
100
PERCENT_CORAL_CEMENT NUMBER Percentage of Substrate that is Coral Cement aka reef pavement. (Using total of sand, live coral, algae, and coral cement as 100%) How to: using the length & width of the net/line as a visual gauge (planar perimeter), estimate a similar planar area on each side of net. The substrate to be characterized will be both the habitat in this extended area as well as underneath the net/line.
100
NOTES VARCHAR2 Unusual observations about the DFG or its collection
100
SUBSTRATE_COLOR VARCHAR2 Most Prominent Color of Substrate. Value from Mar_Color.Color_Code column

Attribute Details

MISSION

CC ID: 382082
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 50
Required: Yes
Primary Key: No
Status: Active
Description:

Mission or Cruise

General Data Type: VARCHAR2

VESSEL

CC ID: 382093
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 95
Required: No
Primary Key: No
Status: Active
Description:

Vessel or Vehicle the mission was conducted from. In the case of ship-based mission, this is the parent vessel.

General Data Type: VARCHAR2

PRIMARY_PURPOSE

CC ID: 382104
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Values=LAND REMOVAL, MARINE REMOVAL, AERIAL SURVEY, NO_DATA, indicates type of survey.

"Land" surveys were depricated from this table after 2/2013

General Data Type: VARCHAR2

REGION_CODE

CC ID: 382115
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: No
Status: Active
Description:

Descriptive Region Code, Currently: MHI = Main Hawaiian Islands, NWHI = Northwest Hawaiian Islands/Papahanaumamakuakea National Monument

General Data Type: VARCHAR2

REGION_DESC

CC ID: 382123
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Long Description of Region

General Data Type: VARCHAR2

LOCATION_CODE

CC ID: 382124
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Descriptive 3 digit code for the island or atoll work was conducted at.

FFS: French Frigate Shoals

KUR: Kure Atoll

MAR: Maro Reef

PHR: Pearl and Hermes Atoll

LIS: Lisianski Island

MID: Midway Atoll

General Data Type: VARCHAR2

LOCATION

CC ID: 382125
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Full LOCATION

General Data Type: VARCHAR2

LOCATION_LONG

CC ID: 382126
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Full LOCATION and Region

General Data Type: VARCHAR2

LOAD_NUM

CC ID: 382127
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

Sequential value for each daily load (per small boat) beginning with 1. For example, We have four small boats conducting removals (MD1, MD2, MD3 and MD4). Each of these four boats will have a load 1. If any of them go back out for a second load, only that boat would have a load #2.

General Data Type: NUMBER

LATITUDE

CC ID: 382083
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Latitude of individual DFG (net) point from GPS waypoint. This lat/long information is associated with the individual DFG net point that all net-associated data corresponds to.

General Data Type: NUMBER

LONGITUDE

CC ID: 382084
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Longitude of individual DFG (net) point from GPS waypoint

General Data Type: NUMBER

SOURCE

CC ID: 382085
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Where debris is recovered from, either LAND (shoreline) or WATER (from the reefs)

General Data Type: VARCHAR2

WEIGHTLOAD_KG

CC ID: 382086
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unit=Kilograms. Weight of debris load (boat-load). This is NOT the weight of this DFG net point, but the weight of the larger load that includes this DFG net point and other DFG points removed by that boat that day.

This entity added for use in 2003

General Data Type: NUMBER

GPS_FILE_DATE

CC ID: 382087
Seq. Order: 14
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date the spatial data on GPS unit was collected (typically the date the survey was completed)

General Data Type: DATE

SURVEY_TOW

CC ID: 382088
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Values: YES, NO, NO_DATA, indicates if survey was completed by divers being towed behind a vessel

General Data Type: VARCHAR2

SURVEY_SWIM

CC ID: 382089
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Values: YES, NO, NO_DATA, indicates if survey was completed by divers swimming

General Data Type: VARCHAR2

LAND_OPS

CC ID: 382090
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Values: YES, NO, NO_DATA, indicates if survey was completed by participants on land (shoreline). Generally used for opportunistic shoreline removals of DFG on same day as an in-water survey

General Data Type: VARCHAR2

VISIBILITY_START_M

CC ID: 382091
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Units=Meters, Measured Value

This is a measure of underwater visibility at the start of each day in the area surveyed. It can be considered the limit at which a fishing net can be seen underwater. A visibility measurement is taken once in the morning before surveys, and once at the end of the day after surveys are complete. A 1ftx1ft piece of green trawl/seine net is attached to a measuring tape and two divers swim apart until the limit of visibility of the net is reached. That data is then recorded.

General Data Type: NUMBER

VISIBILITY_END_M

CC ID: 382092
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Units=Meters, Measured Value

This is a measure of underwater visibility at the end of each day in the area surveyed. It can be considered the limit at which a fishing net can be seen underwater. A visibility measurement is taken once in the morning before surveys, and once at the end of the day after surveys are complete. A 1ftx1ft piece of green trawl/seine net is attached to a measuring tape and two divers swim apart until the limit of visibility of the net is reached. That data is then recorded.

General Data Type: NUMBER

SURVEY_TYPE

CC ID: 382094
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Type of Survey Conducted. Values: NON_SURVEY, LAND, SWIM, TOW, and NO_DATA

General Data Type: VARCHAR2

OBS_LENGTH

CC ID: 382095
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unit=meters, Length of DFG as found in the water, measured as longest 2 dimensional value. Measured to the nearest 0.05m

General Data Type: NUMBER

OBS_WIDTH

CC ID: 382096
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Unit=meters, Average width of DFG as found in the water, measured as shorter 2 dimensional value. Measured to the nearest 0.05m

General Data Type: NUMBER

OBS_HEIGHT

CC ID: 382097
Seq. Order: 23
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unit=meters, Average height of DFG as found in the water, measured to the nearest 0.01m

General Data Type: NUMBER

REMOVED

CC ID: 382098
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Values: YES, NO, NO_DATA, (Blanks)

This indicates if the DFG was removed from the water or land or left in place.

General Data Type: VARCHAR2

VOLUME_REMOVED

CC ID: 382099
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unit=cubic meters,Volume of net physically removed from the water (volume estimated after pulled into the boat and consolidated into a pile. Does not reflect in-water LxWxH.

Added as a data field for use in 2005

General Data Type: NUMBER

SIZE_CLASS

CC ID: 382100
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

This entity depricated as of 3-2013, inconsistently used

General Data Type: VARCHAR2

DEPTH_M

CC ID: 382101
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Unit=meters: Average Depth of DFG as found in the water to the nearest 0.1m.

General Data Type: NUMBER

DEBRIS_TYPE

CC ID: 382102
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Expanded Name for Type of DFG

General Data Type: VARCHAR2

CONGLOMERATE

CC ID: 382103
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Is the Debris a mixture of DFG types? NO, YES, or NO_DATA

General Data Type: VARCHAR2

DEBRIS_TYPE_ORIGINAL

CC ID: 382105
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Original Debris TypeDesignations, Values generally: M: MONOFILAMENT GILLNET, F: TRAWL/SEINE, T: TRAWL (MULTIPANEL/COD END ONLY), R: MISC. LINE, H: HAWSER, L: LONGLINE, G: MULTIFILAMENT GILLNET, O: OTHER, NO_DATA, or SCRAP_METAL

General Data Type: VARCHAR2

DEBRIS_COLOR

CC ID: 382106
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Most Prominent Color of DFG. Value from Mar_Color.Color_Code column

General Data Type: VARCHAR2

FOUL_LEVEL

CC ID: 382107
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Values are NO_DATA, 1=0-25%, 2=26-50%, 3=51-75%, 4=76-100%

Describing the level of bio-fouling on the surface of the DFG as found in the water. The percentage of the visible surface of the DFG that is fouled with bio-fouling.

General Data Type: VARCHAR2

PERCENT_REMOVED

CC ID: 382108
Seq. Order: 33
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

% of total DFG physically removed and weighed. Note: sometimes all, or portions of, a given DFG net are left in place due to concerns of contributing to added coral damage.

General Data Type: NUMBER

CORAL_GROWTH

CC ID: 382109
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

YES= Discernable Coral Growth has occured, NO= Discernable Coral Growth has not occured

This refers to whether new coral growth has occurred in one of two ways: 1. Coral grows around the strands of DFG, encapsulating the DFG within the coral, or 2. New corals have recruited on top of the DFG, using it as a substrate for growth.

General Data Type: VARCHAR2

GROWTH_TYPE1

CC ID: 382110
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Indicates type of coral growth: R: RECRUITING, or E: ENCAPSULATED

This refers to whether new coral growth has occurred in one of two ways: 1. Coral grows around the strands of DFG, encapsulating the DFG within the coral, or 2. New corals have recruited on top of the DFG, using it as a substrate for growth.

General Data Type: VARCHAR2

CORAL_GENERA1

CC ID: 382111
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Genera of coral that has encapsulated or recruited on the DFG if known. Generally, PP: POCILLOPORA, POR: PORITES, or MON: MONTIPORA

General Data Type: VARCHAR2

GROWTH_TYPE2

CC ID: 382112
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Indicates type of coral growth: R: RECRUITING, or E: ENCAPSULATED

This refers to whether new coral growth has occurred in one of two ways: 1. Coral grows around the strands of DFG, encapsulating the DFG within the coral, or 2. New corals have recruited on top of the DFG, using it as a substrate for growth.

General Data Type: VARCHAR2

CORAL_GENERA2

CC ID: 382113
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Genera of coral that has encapsulated or recruited on the DFG if known. Generally, PP: POCILLOPORA, POR: PORITES, or MON: MONTIPORA

General Data Type: VARCHAR2

GROWTH_TYPE3

CC ID: 382114
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Indicates type of coral growth: R: RECRUITING, or E: ENCAPSULATED.

This refers to whether new coral growth has occurred in one of two ways: 1. Coral grows around the strands of DFG, encapsulating the DFG within the coral, or 2. New corals have recruited on top of the DFG, using it as a substrate for growth.

General Data Type: VARCHAR2

CORAL_GENERA3

CC ID: 382116
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Genera of coral that has encapsulated or recruited on the DFG if known. Generally, PP: POCILLOPORA, POR: PORITES, or MON: MONTIPORA

General Data Type: VARCHAR2

PERCENT_SAND

CC ID: 382117
Seq. Order: 41
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Percentage of Substrate that is Sand (Using total of sand, live coral, algae, and coral cement as 100%)

How to: using the length & width of the net/line as a visual gauge (planar perimeter), estimate a similar

planar area on each side of net. The substrate to be characterized will be both the habitat in this extended area as well as underneath the net/line.

General Data Type: NUMBER

PERCENT_LIVE_CORAL

CC ID: 382118
Seq. Order: 42
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Percentage of Substrate that is Live Coral (Using total of sand, live coral, algae, and coral cement as 100%)

How to: using the length & width of the net/line as a visual gauge (planar perimeter), estimate a similar

planar area on each side of net. The substrate to be characterized will be both the habitat in this extended area as well as underneath the net/line.

General Data Type: NUMBER

PERCENT_ALGAE

CC ID: 382119
Seq. Order: 43
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Percentage of Substrate that is Macroalgae (Using total of sand, live coral, algae, and coral cement as 100%)

How to: using the length & width of the net/line as a visual gauge (planar perimeter), estimate a similar

planar area on each side of net. The substrate to be characterized will be both the habitat in this extended area as well as underneath the net/line.

General Data Type: NUMBER

PERCENT_CORAL_CEMENT

CC ID: 382120
Seq. Order: 44
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Percentage of Substrate that is Coral Cement aka reef pavement. (Using total of sand, live coral, algae, and coral cement as 100%)

How to: using the length & width of the net/line as a visual gauge (planar perimeter), estimate a similar

planar area on each side of net. The substrate to be characterized will be both the habitat in this extended area as well as underneath the net/line.

General Data Type: NUMBER

NOTES

CC ID: 382121
Seq. Order: 45
Data Storage Type: VARCHAR2
Max Length: 512
Required: No
Primary Key: No
Status: Active
Description:

Unusual observations about the DFG or its collection

General Data Type: VARCHAR2

SUBSTRATE_COLOR

CC ID: 382122
Seq. Order: 46
Data Storage Type: VARCHAR2
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Most Prominent Color of Substrate. Value from Mar_Color.Color_Code column

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 36839
GUID: gov.noaa.nmfs.inport:36839
Metadata Record Created By: Annette M DesRochers
Metadata Record Created: 2017-02-17 17:02+0000
Metadata Record Last Modified By: Michael W Akridge
Metadata Record Last Modified: 2024-03-11 20:37+0000
Metadata Record Published: 2024-03-11
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2019-05-30
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2020-05-30