Marine Debris Entities from Underwater Surveys
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 36839
| Published / External
Created: 2017-02-17
|
Last Modified: 2024-03-11
Data Set (DS) | ID: 25089
ID: 36839
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Marine Debris Entities from Underwater Surveys |
---|---|
Short Name | Marine Debris |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Entities for marine debris data from the underwater surveys |
* Purpose | |
Notes |
Loaded by batch 9772, 02-17-2017 17:02 |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | CRED_DEBRIS |
» Description |
Materialized view containing marine debris data |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | No | MISSION | VARCHAR2 | Mission or Cruise |
100 | No | No | VESSEL | VARCHAR2 | Vessel or Vehicle the mission was conducted from. In the case of ship-based mission, this is the parent vessel. |
100 | No | No | 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 | Yes | No | REGION_CODE | VARCHAR2 | Descriptive Region Code, Currently: MHI = Main Hawaiian Islands, NWHI = Northwest Hawaiian Islands/Papahanaumamakuakea National Monument |
100 | No | No | REGION_DESC | VARCHAR2 | Long Description of Region |
100 | No | No | 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 | No | No | LOCATION | VARCHAR2 | Full LOCATION |
100 | No | No | LOCATION_LONG | VARCHAR2 | Full LOCATION and Region |
100 | Yes | No | 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 | No | No | 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 | No | No | LONGITUDE | NUMBER | Longitude of individual DFG (net) point from GPS waypoint |
100 | No | No | SOURCE | VARCHAR2 | Where debris is recovered from, either LAND (shoreline) or WATER (from the reefs) |
100 | No | No | 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 | No | No | GPS_FILE_DATE | DATE | Date the spatial data on GPS unit was collected (typically the date the survey was completed) |
100 | No | No | SURVEY_TOW | VARCHAR2 | Values: YES, NO, NO_DATA, indicates if survey was completed by divers being towed behind a vessel |
100 | No | No | SURVEY_SWIM | VARCHAR2 | Values: YES, NO, NO_DATA, indicates if survey was completed by divers swimming |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | SURVEY_TYPE | VARCHAR2 | Type of Survey Conducted. Values: NON_SURVEY, LAND, SWIM, TOW, and NO_DATA |
100 | No | No | 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 | No | No | 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 | No | No | OBS_HEIGHT | NUMBER | Unit=meters, Average height of DFG as found in the water, measured to the nearest 0.01m |
100 | No | No | 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 | No | No | 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 | No | No | SIZE_CLASS | VARCHAR2 | This entity depricated as of 3-2013, inconsistently used |
100 | No | No | DEPTH_M | NUMBER | Unit=meters: Average Depth of DFG as found in the water to the nearest 0.1m. |
100 | No | No | DEBRIS_TYPE | VARCHAR2 | Expanded Name for Type of DFG |
100 | No | No | CONGLOMERATE | VARCHAR2 | Is the Debris a mixture of DFG types? NO, YES, or NO_DATA |
100 | No | No | 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 | No | No | DEBRIS_COLOR | VARCHAR2 | Most Prominent Color of DFG. Value from Mar_Color.Color_Code column |
100 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | 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 | No | No | NOTES | VARCHAR2 | Unusual observations about the DFG or its collection |
100 | No | No | SUBSTRATE_COLOR | VARCHAR2 | Most Prominent Color of Substrate. Value from Mar_Color.Color_Code column |
Attribute Details
Attribute Name | MISSION |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Mission or Cruise |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VESSEL |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 95 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PRIMARY_PURPOSE |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REGION_CODE |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Descriptive Region Code, Currently: MHI = Main Hawaiian Islands, NWHI = Northwest Hawaiian Islands/Papahanaumamakuakea National Monument |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REGION_DESC |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Long Description of Region |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LOCATION_CODE |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LOCATION |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Full LOCATION |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LOCATION_LONG |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Full LOCATION and Region |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LOAD_NUM |
---|---|
Seq. Order | 9 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LATITUDE |
---|---|
Seq. Order | 10 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LONGITUDE |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude of individual DFG (net) point from GPS waypoint |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SOURCE |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Where debris is recovered from, either LAND (shoreline) or WATER (from the reefs) |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WEIGHTLOAD_KG |
---|---|
Seq. Order | 13 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GPS_FILE_DATE |
---|---|
Seq. Order | 14 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date the spatial data on GPS unit was collected (typically the date the survey was completed) |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SURVEY_TOW |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Values: YES, NO, NO_DATA, indicates if survey was completed by divers being towed behind a vessel |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SURVEY_SWIM |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Values: YES, NO, NO_DATA, indicates if survey was completed by divers swimming |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LAND_OPS |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VISIBILITY_START_M |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VISIBILITY_END_M |
---|---|
Seq. Order | 19 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SURVEY_TYPE |
---|---|
Seq. Order | 20 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of Survey Conducted. Values: NON_SURVEY, LAND, SWIM, TOW, and NO_DATA |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OBS_LENGTH |
---|---|
Seq. Order | 21 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OBS_WIDTH |
---|---|
Seq. Order | 22 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | OBS_HEIGHT |
---|---|
Seq. Order | 23 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unit=meters, Average height of DFG as found in the water, measured to the nearest 0.01m |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REMOVED |
---|---|
Seq. Order | 24 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VOLUME_REMOVED |
---|---|
Seq. Order | 25 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SIZE_CLASS |
---|---|
Seq. Order | 26 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
This entity depricated as of 3-2013, inconsistently used |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTH_M |
---|---|
Seq. Order | 27 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unit=meters: Average Depth of DFG as found in the water to the nearest 0.1m. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEBRIS_TYPE |
---|---|
Seq. Order | 28 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Expanded Name for Type of DFG |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CONGLOMERATE |
---|---|
Seq. Order | 29 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Is the Debris a mixture of DFG types? NO, YES, or NO_DATA |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEBRIS_TYPE_ORIGINAL |
---|---|
Seq. Order | 30 |
Data Storage Type | VARCHAR2 |
Max Length | 255 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEBRIS_COLOR |
---|---|
Seq. Order | 31 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Most Prominent Color of DFG. Value from Mar_Color.Color_Code column |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FOUL_LEVEL |
---|---|
Seq. Order | 32 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PERCENT_REMOVED |
---|---|
Seq. Order | 33 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CORAL_GROWTH |
---|---|
Seq. Order | 34 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GROWTH_TYPE1 |
---|---|
Seq. Order | 35 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CORAL_GENERA1 |
---|---|
Seq. Order | 36 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GROWTH_TYPE2 |
---|---|
Seq. Order | 37 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CORAL_GENERA2 |
---|---|
Seq. Order | 38 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GROWTH_TYPE3 |
---|---|
Seq. Order | 39 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CORAL_GENERA3 |
---|---|
Seq. Order | 40 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PERCENT_SAND |
---|---|
Seq. Order | 41 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PERCENT_LIVE_CORAL |
---|---|
Seq. Order | 42 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PERCENT_ALGAE |
---|---|
Seq. Order | 43 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PERCENT_CORAL_CEMENT |
---|---|
Seq. Order | 44 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NOTES |
---|---|
Seq. Order | 45 |
Data Storage Type | VARCHAR2 |
Max Length | 512 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unusual observations about the DFG or its collection |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SUBSTRATE_COLOR |
---|---|
Seq. Order | 46 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Most Prominent Color of Substrate. Value from Mar_Color.Color_Code column |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2019-05-30 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2020-05-30 |
Tags |
---|