Marine Debris Entities from Underwater Surveys
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:36839 | Updated: March 11, 2024 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Entities for marine debris data from the underwater surveys
DescriptionMaterialized 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |